SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 00:30:22' AND `end_date` > '2019-02-18 00:30:22'Type: ALL ·Rows: 14691 ·Speed: 834.253 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: 1.026 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.512 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.353 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.401 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.323 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.423 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.337 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.395 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.318 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: 23.234 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.351 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.401 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.323 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.421 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.342 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.348 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.310 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.376 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.352 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.349 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.317 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.382 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.383 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.356 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.347 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: 4.818 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.385 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.318 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '26875' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 14 ·Speed: 0.439 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.353 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '26875' AND `category_code` = '49'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.381 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '246'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 4.657 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '7174' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 4.789 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.352 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '7174' AND `category_code` = '49'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.390 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '236'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.308 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1615' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 16 ·Speed: 0.434 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.338 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1615' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.381 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.323 ms · DUPLICATE |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.583 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 12.054 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 55.736 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 33.916 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 12.588 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 20.587 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 4.389 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 15.163 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 11.459 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 34.699 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 11.078 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 10.309 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 2.659 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 30 ·Speed: 13.904 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ID' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 22.390 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:25' AND `end_date` > '2019-02-18 00:30:25'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 12.605 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 32.423 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 6.724 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 2.939 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 30.994 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 25.875 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 46.203 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 69.725 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 17.435 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 12.828 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 13.840 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 12.731 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.715 ms |
SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 00:30:26' AND `end_date` > '2019-02-18 00:30:26'Type: ALL ·Rows: 14691 ·Speed: 823.493 ms |
SELECT * FROM `country_restaurant_count`Type: ALL ·Rows: 27 ·Speed: 0.438 ms |
SELECT * FROM `city_restaurant_count`Type: ALL ·Rows: 145 ·Speed: 0.919 ms |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.476 ms · DUPLICATE |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = '9H' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.417 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'KR' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.446 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'CN' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.401 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'HK' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.456 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'SG' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.432 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'MO' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.438 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'TW' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.456 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'GU' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.398 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'TH' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.444 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'FR' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.408 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'US' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.431 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'MP' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.466 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'PW' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.421 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'ID' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 18.098 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'PH' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.415 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'MY' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.438 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'KH' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.407 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'MM' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.570 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'VN' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.467 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'IN' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.538 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'AT' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.392 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'IT' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.441 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'GB' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.388 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'ES' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.428 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'DE' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.395 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'ZZ' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.407 ms |
SELECT * FROM `yearly_reservation_ranking` WHERE `ct_code` = 'NC' LIMIT 3Type: ALL ·Rows: 235 ·Speed: 0.583 ms |