SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:22:43' AND `end_date` > '2019-02-18 01:22:43'Type: ALL ·Rows: 14300 ·Speed: 411.135 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'MO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.418 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 5.024 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` = 'MO' 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: 253 ·Speed: 3.100 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.447 ms |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '2748' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.366 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2748' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.406 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '167'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.318 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.347 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '641' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.372 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '641' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.402 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.317 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.352 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '640' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.369 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '640' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.349 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.319 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.358 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '656' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.361 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '656' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.348 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '167'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` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.314 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '648' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.355 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '648' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.348 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.316 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.294 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '954' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.370 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '954' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.352 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '176'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.314 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.321 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '2952' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.351 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2952' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.356 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.369 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.313 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '647' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.411 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '647' AND `category_code` = '45'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` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.337 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.300 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '646' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.345 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '646' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.328 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '166'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.309 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.298 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '654' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.336 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '654' AND `category_code` = '45'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.335 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '167'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.302 ms · DUPLICATE |
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.853 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.367 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.954 ms |
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.411 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.324 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.431 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.425 ms · DUPLICATE |
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.350 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.315 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.376 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'US'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.394 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.355 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.358 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.388 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.381 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.345 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.391 ms |
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.371 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.382 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.345 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.340 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.386 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.389 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.360 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.333 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.449 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.360 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.397 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.328 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.443 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.335 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.371 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.306 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.409 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.327 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.371 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.304 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.407 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.337 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.333 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.308 ms · DUPLICATE |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.451 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 8.998 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 26.030 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 11.042 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 20.193 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 27.997 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 4.496 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 19.171 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.708 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 25.215 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 19.453 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 15.920 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 9.273 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 30 ·Speed: 1.051 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ID' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 10.736 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 12.462 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 14.726 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 6.640 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 8.341 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 12.138 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 5.155 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 26.947 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:44' AND `end_date` > '2019-02-18 01:22:44'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 47.777 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:45' AND `end_date` > '2019-02-18 01:22:45'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 3.312 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:45' AND `end_date` > '2019-02-18 01:22:45'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 14.190 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:45' AND `end_date` > '2019-02-18 01:22:45'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 11.951 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:45' AND `end_date` > '2019-02-18 01:22:45'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 5.743 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:45' AND `end_date` > '2019-02-18 01:22:45'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.761 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 = 640 AND
master_restaurant.ct_code = 'MO' AND
master_restaurant.delete_flag = 0Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.626 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.776 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '640' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.380 ms |
SELECT * FROM `restaurant_item` WHERE `restaurant_code` = '640'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.370 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 = 'MO' OR master_category.ct_code = '' OR master_category.ct_code IS NULL)
ORDER BY master_category.category_code ASCType: ALL ·Rows: 958 ·Speed: 1.621 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '640'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.389 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '640' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.929 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '640' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.357 ms |
SELECT * FROM `ticket_restaurant` WHERE `restaurant_code` = '640' AND `status_code` = '0' LIMIT 1Type: ALL ·Rows: 10 ·Speed: 0.416 ms |
select * from weather where stationnumber = 45004Speed: 0.453 ms |
SELECT * FROM `news` WHERE `status` = '1' ORDER BY `public_date` DESC LIMIT 6Type: ALL ·Rows: 608 ·Speed: 0.792 ms |
SELECT * FROM `user_favorite` WHERE `type` = 'restaurant' AND `id` = '640'Possible keys: id ·Key Used: id ·Type: ref ·Rows: 6 ·Speed: 0.495 ms |
INSERT INTO `restaurant_access_log` (`restaurant_code`, `ip_address`) VALUES ('640', '34.203.28.212')Speed: 8.404 ms |
SELECT * FROM `restaurant_access_log` WHERE `restaurant_code` = '640'Type: ALL ·Rows: 7918525 ·Speed: 5.803 s |
SELECT * FROM `master_city` WHERE `ct_code` = 'MO'Type: ALL ·Rows: 203 ·Speed: 4.266 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` = 'MO' ORDER BY `monthly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 1 ·Speed: 2.116 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` = 'MO' ORDER BY `yearly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 172 ·Speed: 1.114 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.682 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '640' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 4.073 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.836 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '640' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.600 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.723 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '656' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 1.260 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.833 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '656' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.863 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.775 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2748' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.739 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 1.147 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2748' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.916 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.148 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '648' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.354 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.678 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '648' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.210 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.325 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '954' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 1.119 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.690 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '954' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.306 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.493 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '641' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.348 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.688 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '641' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.305 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.225 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '958' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.392 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.786 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '958' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.923 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.310 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '647' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.356 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.836 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '647' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.360 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.848 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2756' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.394 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 4.096 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2756' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.984 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.187 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2757' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.324 ms |
SELECT * FROM master_item WHERE category_code = 45 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.688 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2757' AND `category_code` = '45' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.354 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` = 'MO' ORDER BY `weekly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 4 ·Speed: 1.425 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 = 640 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.659 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = 'MO_50eea05b633de'
AND restaurant_code = 640Type: ALL ·Rows: 1855 ·Speed: 1.762 ms |
SELECT * FROM master_companion_typeType: ALL ·Rows: 8 ·Speed: 1.990 ms |
SELECT * FROM master_budget WHERE ct_code = 'MO' ORDER BY priority DESCPossible keys: ct_dode ·Key Used: ct_dode ·Type: ref ·Rows: 5 ·Speed: 0.512 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '640'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.376 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '640' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 1.352 ms · DUPLICATE |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = '0' AND `restaurant_code` != '640'Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 145 ·Speed: 36.981 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '647' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 5.643 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '656' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.391 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.316 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '971' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.360 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.612 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '972' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.345 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.535 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2093' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 7 ·Speed: 4.876 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.328 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2751' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.324 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 6.244 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2754' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.860 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.313 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2755' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.473 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.286 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2795' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.327 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.541 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2796' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.673 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.784 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `ct_code` = 'MO'Type: ALL ·Rows: 203 ·Speed: 1.950 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 '%/166/%' AND `restaurant_item`.`category_code` = '45' AND `master_restaurant`.`ct_code` = 'MO' AND `master_restaurant`.`delete_flag` = '0' AND `master_restaurant`.`restaurant_code` != '640' LIMIT 10Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 145 ·Speed: 2.965 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '639' 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` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.291 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '641' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.343 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 8.734 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '646' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.403 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.303 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '647' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.354 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.305 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '648' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.360 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.288 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '953' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.329 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.289 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '961' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.321 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.326 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '969' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.319 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.320 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '975' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.329 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.346 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1685' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.339 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'MFM'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.336 ms · DUPLICATE |
SELECT * FROM `yearly_reservation_ranking` WHERE `restaurant_code` = '640' LIMIT 1Type: ALL ·Rows: 172 ·Speed: 0.365 ms |
SELECT * FROM `master_setmenu` WHERE `restaurant_code` = '640' AND `reservation_flag` = '1'Type: ALL ·Rows: 281 ·Speed: 1.405 ms |
SELECT * FROM `master_ma_display_tours` WHERE `ct_code` = 'MO'Type: ALL ·Rows: 51 ·Speed: 0.435 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'MO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 6.002 ms · DUPLICATE |
SELECT *, `master_restaurant`.`ct_code` FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `lat` != '' AND `lng` != '' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:22:51' AND `end_date` > '2019-02-18 01:22:51' ORDER BY `wom_total_rate` DESCPossible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 15.811 ms |