SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:06:40' AND `end_date` > '2019-02-18 01:06:40'Type: ALL ·Rows: 14691 ·Speed: 370.833 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.490 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 7.325 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` = 'GU' 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: 317 ·Speed: 51.132 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.360 ms |
SELECT `filename` 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.376 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.375 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.315 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.301 ms |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '794' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.346 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '794' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.372 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '203'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.298 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HAG'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms |
SELECT `filename` 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.361 ms |
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.367 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.298 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.296 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '1263' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 6 ·Speed: 0.337 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1263' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.331 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '204'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.304 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.295 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '797' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.354 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '797' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.346 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '204'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.299 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.294 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '774' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 16 ·Speed: 0.393 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '774' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.329 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '199'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.298 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '799' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.393 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '799' AND `category_code` = '48'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` = '204'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.308 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.272 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '793' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.351 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '793' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.309 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '204'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.301 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.265 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '1576' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.324 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1576' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.303 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '203'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.271 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.266 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '798' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.311 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '798' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.332 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '204'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.270 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.860 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.370 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.308 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.312 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.272 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.324 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'US'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.314 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.305 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.269 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.353 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 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.346 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.269 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.359 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.319 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.343 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.272 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.378 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.307 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.350 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.270 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.381 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 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.339 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.270 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.370 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.309 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.306 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.267 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.341 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.290 ms · DUPLICATE |
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.300 ms · DUPLICATE |
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 · DUPLICATE |
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.324 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.346 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.301 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.301 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.345 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.332 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.313 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '246'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.306 ms |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.404 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 9.355 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 16.230 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 10.737 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 7.298 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 9.211 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 4.004 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 9.625 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.117 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 13.818 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 12.290 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 10.552 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 1.765 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 30 ·Speed: 1.001 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ID' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 10.802 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 10.556 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 14.112 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 8.700 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 2.919 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 13.944 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 6.217 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 24.242 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 25.250 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 3.176 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 16.298 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 10.808 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 7.814 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.816 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.747 ms |
SELECT * FROM master_city WHERE ct_code = 'GU'Type: ALL ·Rows: 203 ·Speed: 0.595 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'AGT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Type: ALL ·Rows: 14691 ·Speed: 48.673 ms |
SELECT * FROM `master_restaurant` LEFT JOIN `master_restaurant_picture` ON (`master_restaurant`.`restaurant_code` = `master_restaurant_picture`.`restaurant_code`) LEFT JOIN `master_city` ON (`master_restaurant`.`city_code` = `master_city`.`city_code`) WHERE `master_restaurant`.`city_code` = 'AGT' AND `master_restaurant_picture`.`call_name` = 'Main' AND `master_restaurant`.`delete_flag` = 0 AND `master_restaurant`.`open_date` <= '2019-02-18 01:06:41' AND `master_restaurant`.`end_date` > '2019-02-18 01:06:41' ORDER BY `master_restaurant`.`reservation_count` DESC LIMIT 12 OFFSET 0Possible keys: restaurant_code ·Type: ALL ·Rows: 14691 ·Speed: 16.430 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '30518' AND `category_code` = '48'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.441 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.376 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `ct_code` = 'GU'Type: ALL ·Rows: 203 ·Speed: 0.569 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'AGT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Type: ALL ·Rows: 14691 ·Speed: 48.336 ms · DUPLICATE |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'HAG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:41' AND `end_date` > '2019-02-18 01:06:41'Type: ALL ·Rows: 14691 ·Speed: 46.285 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'TMO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:42' AND `end_date` > '2019-02-18 01:06:42'Type: ALL ·Rows: 14691 ·Speed: 46.191 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'TMU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:42' AND `end_date` > '2019-02-18 01:06:42'Type: ALL ·Rows: 14691 ·Speed: 47.732 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'YON' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:42' AND `end_date` > '2019-02-18 01:06:42'Type: ALL ·Rows: 14691 ·Speed: 44.491 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/212/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 40.041 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/204/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 40.603 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/302/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 40.926 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/199/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 42.015 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/213/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 41.735 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/209/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 41.381 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/208/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 41.460 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/207/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 41.521 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/206/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 40.916 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/200/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 40.866 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/952/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 41.057 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/201/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 75.870 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/202/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 65.518 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/203/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 84.721 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/205/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 78.319 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/345/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 74.958 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/346/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 42.320 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/347/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 78.738 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `item_code` LIKE '%/214/%' AND `category_code` = '48'Type: ALL ·Rows: 45021 ·Speed: 89.821 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'AGT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.426 ms |
SELECT * FROM `master_restaurant` WHERE `city_code` = 'AGT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:43' AND `end_date` > '2019-02-18 01:06:43'Type: ALL ·Rows: 14691 ·Speed: 90.253 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.385 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/68/%' AND `category_code` = '14' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 2.015 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/69/%' AND `category_code` = '14' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 10.151 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/74/%' AND `category_code` = '17' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 2.173 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/75/%' AND `category_code` = '17' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 2.050 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/78/%' AND `category_code` = '19' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 2.040 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/80/%' AND `category_code` = '20' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 1.579 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/76/%' AND `category_code` = '12' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 10.186 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/110/%' AND `category_code` = '13' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 1.805 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/89/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.858 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/88/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 17.930 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/87/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.002 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/86/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 17.969 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/85/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 14.940 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/84/%' AND (`category_code` = '22' OR `category_code` = '52') AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.026 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/4/%' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 13.490 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/7/%' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 17.059 ms |
SELECT `item_code` FROM `restaurant_item` INNER JOIN `master_restaurant` ON (`restaurant_item`.`restaurant_code` = `master_restaurant`.`restaurant_code`) WHERE `item_code` LIKE '%/8/%' AND `ct_code` = 'GU'Possible keys: restaurant_code,ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 29.401 ms |
SELECT *, `master_restaurant`.`city_code` FROM `master_restaurant` WHERE `city_code` = 'AGT' AND `lat` != '' AND `lng` != '' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:06:43' AND `end_date` > '2019-02-18 01:06:43' ORDER BY `wom_total_rate` DESCType: ALL ·Rows: 14691 ·Speed: 48.651 ms |
SELECT `lat`, `lng` FROM `master_city` WHERE `city_code` = 'AGT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 5.467 ms |
SELECT * FROM `master_ma_display_tours` WHERE `city_code` LIKE '%AGT%'Type: ALL ·Rows: 51 ·Speed: 8.261 ms |