SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:37:32' AND `end_date` > '2019-02-18 01:37:32'Type: ALL ·Rows: 14300 ·Speed: 339.644 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.425 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 7.566 ms |
SELECT `master_restaurant`.`restaurant_code`, `master_restaurant`.`restaurant_id`, `master_restaurant`.`restaurant_name`, `master_restaurant`.`city_code`, COUNT(restaurant_name) FROM `user_reservation` LEFT JOIN `master_restaurant` ON (`user_reservation`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `master_restaurant`.`ct_code` = '9H' GROUP BY `user_reservation`.`restaurant_code` ORDER BY `COUNT(restaurant_name)` DESC LIMIT 10Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 91.556 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 8.392 ms |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '24' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.371 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '24' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.336 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '17'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.303 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.347 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '91' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.349 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '91' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.377 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '2'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.293 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.338 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '38' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.362 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '38' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.374 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '2'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '25' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.334 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '25' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.392 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '20'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.312 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.340 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '988' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.356 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '988' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.379 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '17'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.351 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '92' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.355 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '92' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.382 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '2'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.352 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '1278' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.358 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1278' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.398 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '2'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '1294' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.359 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1294' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.395 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '25'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.316 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.349 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '1297' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 19 ·Speed: 0.369 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1297' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.400 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '17'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.314 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.344 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '999' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 7.952 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '999' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.025 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '108'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.282 ms |
SELECT * FROM (SELECT distinct restaurant_code FROM user_reservation ORDER BY reg_date DESC limit 10) AS u LEFT JOIN master_restaurant AS m ON (u.restaurant_code = m.restaurant_code)Type: ALL ·Rows: 10 ·Speed: 0.792 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '861' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.360 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.348 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '861' AND `category_code` = '44'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.302 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '156'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.303 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2699' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.335 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2699' AND `category_code` = '44'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.298 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '162'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.267 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '10143' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.329 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'US'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.291 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '10143' AND `category_code` = '57'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.304 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '319'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.266 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '24' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.374 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.305 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '24' AND `category_code` = '1'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.341 ms · DUPLICATE |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '17'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.272 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '30532' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.453 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.312 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '30532' AND `category_code` = '63'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.314 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '401'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.280 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '26779' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.395 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.302 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '26779' AND `category_code` = '56'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.310 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '304'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.280 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '29119' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 6 ·Speed: 0.398 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.303 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '29119' AND `category_code` = '71'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.317 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '667'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.290 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '9900' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.333 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.298 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '9900' AND `category_code` = '49'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.355 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '765'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.266 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1005' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.387 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1005' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.330 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '212'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.267 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '28819' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.373 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '28819' AND `category_code` = '56'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.338 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '304'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.269 ms · DUPLICATE |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.405 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 18.470 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 24.010 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 10.516 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 13.201 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 15.341 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 4.212 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 17.341 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.202 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 15.895 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 10.386 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 9.222 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 1.520 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 30 ·Speed: 0.897 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ID' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 9.250 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 7.590 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 10.975 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 6.564 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 2.719 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 11.400 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 5.288 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:33' AND `end_date` > '2019-02-18 01:37:33'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 21.198 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 23.489 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 3.240 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 13.733 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 9.009 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 5.589 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:34' AND `end_date` > '2019-02-18 01:37:34'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.827 ms |
SELECT * FROM `master_setmenu` WHERE `setmenu_id` = '181' AND `reservation_flag` = '1' LIMIT 1Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.408 ms |
SELECT
master_country.country_name,
master_area.area_name,
master_city.city_name,
master_restaurant.*
FROM master_country,master_area,master_restaurant,master_city
WHERE master_restaurant.city_code = master_city.city_code and
master_restaurant.ct_code = master_country.ct_code AND
master_restaurant.area_code = master_area.area_code AND
master_restaurant.restaurant_code = 24 AND
master_restaurant.ct_code = '9H' AND
master_restaurant.delete_flag = 0Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.622 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.790 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '24' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.398 ms |
SELECT * FROM `restaurant_item` WHERE `restaurant_code` = '24'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 17 ·Speed: 0.464 ms |
SELECT
master_category.category_code,
master_category.category_name,
master_item.item_code,
master_item.item_name
FROM master_category,master_item where
master_category.category_code = master_item.category_code AND
(master_category.ct_code = '9H' OR master_category.ct_code = '' OR master_category.ct_code IS NULL)
ORDER BY master_category.category_code ASCType: ALL ·Rows: 958 ·Speed: 1.679 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '24'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.413 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '24' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.439 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '24' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.357 ms |
SELECT * FROM `ticket_restaurant` WHERE `restaurant_code` = '24' AND `status_code` = '0' LIMIT 1Type: ALL ·Rows: 10 ·Speed: 0.373 ms |
select * from weather where stationnumber = 91182Speed: 0.446 ms |
SELECT * FROM `news` WHERE `status` = '1' ORDER BY `public_date` DESC LIMIT 6Type: ALL ·Rows: 608 ·Speed: 0.754 ms |
SELECT * FROM `user_favorite` WHERE `type` = 'restaurant' AND `id` = '24'Possible keys: id ·Key Used: id ·Type: ref ·Rows: 778 ·Speed: 4.549 ms |
INSERT INTO `restaurant_access_log` (`restaurant_code`, `ip_address`) VALUES ('24', '34.203.28.212')Speed: 2.748 ms |
SELECT * FROM `restaurant_access_log` WHERE `restaurant_code` = '24'Type: ALL ·Rows: 7918961 ·Speed: 6.238 s |
SELECT * FROM `master_city` WHERE `ct_code` = '9H'Type: ALL ·Rows: 203 ·Speed: 0.890 ms |
SELECT * FROM `master_restaurant` LEFT JOIN `monthly_reservation_ranking` ON (`master_restaurant`.`restaurant_code` = `monthly_reservation_ranking`.`restaurant_code`) WHERE `monthly_reservation_ranking`.`ct_code` = '9H' ORDER BY `monthly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 1 ·Speed: 0.572 ms |
SELECT * FROM `master_restaurant` LEFT JOIN `yearly_reservation_ranking` ON (`master_restaurant`.`restaurant_code` = `yearly_reservation_ranking`.`restaurant_code`) WHERE `yearly_reservation_ranking`.`ct_code` = '9H' ORDER BY `yearly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 172 ·Speed: 1.051 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.340 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '24' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.406 ms · DUPLICATE |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.770 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '24' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.388 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.329 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '38' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.411 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.743 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '38' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.342 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.374 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '91' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.374 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.839 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '91' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.383 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '988' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.435 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.745 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '988' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.347 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.441 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '92' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.390 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.746 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '92' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.390 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.333 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '999' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.449 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.739 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '999' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.351 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.365 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '25' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.367 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.725 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '25' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.376 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.327 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1278' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.405 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.744 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1278' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.347 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.364 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1297' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 19 ·Speed: 0.390 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.738 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1297' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.379 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.333 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '86' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 11 ·Speed: 0.427 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 1.074 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '86' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.384 ms |
SELECT * FROM `master_restaurant` LEFT JOIN `weekly_reservation_ranking` ON (`master_restaurant`.`restaurant_code` = `weekly_reservation_ranking`.`restaurant_code`) WHERE `weekly_reservation_ranking`.`ct_code` = '9H' ORDER BY `weekly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 4 ·Speed: 0.570 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.399 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '19' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.401 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.746 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '19' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.344 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.364 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '21' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 6 ·Speed: 0.384 ms |
SELECT * FROM master_item WHERE category_code = 1 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.820 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '21' AND `category_code` = '1' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.388 ms |
SELECT *,user_word_of_mouth.member_id FROM user_word_of_mouth, master_restaurant
WHERE user_word_of_mouth.restaurant_code = master_restaurant.restaurant_code AND
user_word_of_mouth.restaurant_code = 24 AND
user_word_of_mouth.delete_flag = 0 ORDER BY user_word_of_mouth.send_date DESC LIMIT 3Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.944 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = '9H_5c4552a0b9a87'
AND restaurant_code = 24Type: ALL ·Rows: 1855 ·Speed: 1.182 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = '9H_5799f4b55711b'
AND restaurant_code = 24Type: ALL ·Rows: 1855 ·Speed: 1.189 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = '9H_5719b97ba5eb7'
AND restaurant_code = 24Type: ALL ·Rows: 1855 ·Speed: 1.167 ms |
SELECT * FROM master_companion_typeType: ALL ·Rows: 8 ·Speed: 0.294 ms |
SELECT * FROM master_budget WHERE ct_code = '9H' ORDER BY priority DESCPossible keys: ct_dode ·Key Used: ct_dode ·Type: ref ·Rows: 11 ·Speed: 0.613 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '24'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.405 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '24' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.344 ms · DUPLICATE |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = '0' AND `restaurant_code` != '24'Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 204 ·Speed: 12.803 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '11' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.386 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.319 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '12' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.372 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.299 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '20' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 11 ·Speed: 0.462 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.296 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '23' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.349 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '25' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.344 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.296 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '30' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 7 ·Speed: 0.340 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '33' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.341 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.293 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '49' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.353 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.289 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '56' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.335 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.291 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '58' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.951 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.289 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `ct_code` = '9H'Type: ALL ·Rows: 203 ·Speed: 0.521 ms · DUPLICATE |
SELECT * FROM `master_restaurant` LEFT JOIN `restaurant_item` ON (`master_restaurant`.`restaurant_code` = `restaurant_item`.`restaurant_code`) WHERE `restaurant_item`.`item_code` LIKE '%/17/%' AND `restaurant_item`.`category_code` = '1' AND `master_restaurant`.`ct_code` = '9H' AND `master_restaurant`.`delete_flag` = '0' AND `master_restaurant`.`restaurant_code` != '24' LIMIT 10Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 204 ·Speed: 6.595 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '56' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.413 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.322 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '988' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.410 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1279' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.402 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1283' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 16 ·Speed: 8.455 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1285' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.399 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.325 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1297' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 19 ·Speed: 0.431 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.327 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1890' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.407 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.319 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1910' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.500 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.295 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2177' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.336 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.301 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2213' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.372 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HNL'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT * FROM `yearly_reservation_ranking` WHERE `restaurant_code` = '24' LIMIT 1Type: ALL ·Rows: 172 ·Speed: 0.335 ms |
SELECT * FROM `master_ma_display_tours` WHERE `ct_code` = '9H'Type: ALL ·Rows: 51 ·Speed: 0.423 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.313 ms · DUPLICATE |
SELECT *, `master_restaurant`.`ct_code` FROM `master_restaurant` WHERE `ct_code` = '9H' AND `lat` != '' AND `lng` != '' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:37:40' AND `end_date` > '2019-02-18 01:37:40' ORDER BY `wom_total_rate` DESCPossible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 34.021 ms |