SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 00:39:14' AND `end_date` > '2019-02-18 00:39:14'Type: ALL ·Rows: 14691 ·Speed: 403.675 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.464 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = '0' AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 9.971 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: 81.640 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.436 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.368 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.378 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.327 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.341 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.311 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'HAG'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.334 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: 7.944 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.343 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.328 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.302 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.369 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.363 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.314 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.329 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.362 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.387 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.305 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.329 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.353 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.367 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.296 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.294 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.351 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.333 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.298 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.276 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.312 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.301 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.315 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.364 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.301 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.315 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.280 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.367 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.321 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.320 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: 1.013 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.367 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.315 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: 2.620 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '17'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 7.856 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.485 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.403 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.432 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.367 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.440 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.399 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.336 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.427 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.419 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.392 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.374 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.444 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.417 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: 5.449 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.364 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.448 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.387 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '9900' AND `category_code` = '49'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.355 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '765'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.356 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.404 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.380 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.408 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.426 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.421 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.401 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.404 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.404 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.494 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.399 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.432 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '246'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 5.720 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: 0.428 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'TH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.397 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.324 ms |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.474 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 13.275 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 23.087 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 14.241 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 14.583 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 19.253 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 11.525 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 18.740 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.253 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 35.009 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 18.526 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 20.614 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 8.052 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 30 ·Speed: 2.960 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ID' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 26.031 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 10.965 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 24.680 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 7.848 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 4.273 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 19.534 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 6.062 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 27.029 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 25.866 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 3.839 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 13.058 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 10.632 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 6.242 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:16' AND `end_date` > '2019-02-18 00:39:16'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.760 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 = 1576 AND
master_restaurant.ct_code = 'GU' AND
master_restaurant.delete_flag = 0Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.627 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.764 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1576' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.389 ms |
SELECT * FROM `restaurant_item` WHERE `restaurant_code` = '1576'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.495 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 = 'GU' OR master_category.ct_code = '' OR master_category.ct_code IS NULL)
ORDER BY master_category.category_code ASCType: ALL ·Rows: 958 ·Speed: 1.611 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1576'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.473 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '1576' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.447 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1576' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 0.376 ms |
SELECT * FROM `ticket_restaurant` WHERE `restaurant_code` = '1576' AND `status_code` = '0' LIMIT 1Type: ALL ·Rows: 10 ·Speed: 0.438 ms |
select * from weather where stationnumber = 91212Speed: 0.462 ms |
SELECT * FROM `news` WHERE `status` = '1' ORDER BY `public_date` DESC LIMIT 6Type: ALL ·Rows: 608 ·Speed: 0.767 ms |
SELECT * FROM `user_favorite` WHERE `type` = 'restaurant' AND `id` = '1576'Possible keys: id ·Key Used: id ·Type: ref ·Rows: 119 ·Speed: 1.024 ms |
INSERT INTO `restaurant_access_log` (`restaurant_code`, `ip_address`) VALUES ('1576', '34.203.28.212')Speed: 2.653 ms |
SELECT * FROM `restaurant_access_log` WHERE `restaurant_code` = '1576'Type: ALL ·Rows: 7913980 ·Speed: 6.952 s |
SELECT * FROM `master_city` WHERE `ct_code` = 'GU'Type: ALL ·Rows: 203 ·Speed: 0.573 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` = 'GU' ORDER BY `monthly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 1 ·Speed: 3.149 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` = 'GU' ORDER BY `yearly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 235 ·Speed: 35.247 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.513 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.431 ms · DUPLICATE |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.709 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1005' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.387 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.378 ms |
SELECT * 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.391 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.705 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '794' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.405 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HAG'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 2.038 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.412 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 4.088 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1615' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 2.730 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.350 ms · DUPLICATE |
SELECT * 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.434 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.712 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1263' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.363 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.382 ms · DUPLICATE |
SELECT * 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.402 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.703 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '774' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 4.792 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 1.129 ms · DUPLICATE |
SELECT * 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: 5.439 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.730 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '797' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.436 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.925 ms · DUPLICATE |
SELECT * 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.899 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.708 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '793' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 1.379 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.899 ms · DUPLICATE |
SELECT * 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.890 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 10.108 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '799' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.360 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 6.064 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '796' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 7 ·Speed: 0.396 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.768 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '796' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.392 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.344 ms · DUPLICATE |
SELECT * 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.413 ms |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.728 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '798' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 5.711 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` = 'GU' ORDER BY `weekly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 4 ·Speed: 0.550 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.327 ms · DUPLICATE |
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.412 ms · DUPLICATE |
SELECT * FROM master_item WHERE category_code = 48 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.686 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '1005' AND `category_code` = '48' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.344 ms · DUPLICATE |
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 = 1576 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.833 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = 'GU_5bed3a9c2d0f2'
AND restaurant_code = 1576Type: ALL ·Rows: 1855 ·Speed: 1.236 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = 'GU_57f30be24543b'
AND restaurant_code = 1576Type: ALL ·Rows: 1855 ·Speed: 1.226 ms |
SELECT seq FROM user_like
WHERE member_id = 0 AND wofmid = 'GU_570dd017bf85c'
AND restaurant_code = 1576Type: ALL ·Rows: 1855 ·Speed: 1.193 ms |
SELECT * FROM master_companion_typeType: ALL ·Rows: 8 ·Speed: 0.329 ms |
SELECT * FROM master_budget WHERE ct_code = 'GU' ORDER BY priority DESCPossible keys: ct_dode ·Key Used: ct_dode ·Type: ref ·Rows: 5 ·Speed: 0.378 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '1576'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.411 ms |
SELECT * 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: 6.483 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = '0' AND `restaurant_code` != '1576'Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 217 ·Speed: 24.820 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '772' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 16 ·Speed: 5.740 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.302 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '773' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 12 ·Speed: 8.515 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.301 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '776' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.374 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.290 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '791' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.387 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '792' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 14 ·Speed: 0.388 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.292 ms · DUPLICATE |
SELECT * 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.366 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.286 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '796' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 7 ·Speed: 0.366 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.289 ms · DUPLICATE |
SELECT * 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.384 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.289 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '801' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 13 ·Speed: 0.381 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.293 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '803' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 17 ·Speed: 0.406 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.291 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `ct_code` = 'GU'Type: ALL ·Rows: 203 ·Speed: 0.565 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 '%/203/%' AND `restaurant_item`.`category_code` = '48' AND `master_restaurant`.`ct_code` = 'GU' AND `master_restaurant`.`delete_flag` = '0' AND `master_restaurant`.`restaurant_code` != '1576' LIMIT 10Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 217 ·Speed: 4.234 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '791' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 9 ·Speed: 0.350 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.294 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '792' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 14 ·Speed: 8.053 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT * 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.375 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.288 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '795' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 15 ·Speed: 0.386 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.298 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '823' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 10 ·Speed: 0.347 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HAG'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.298 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1230' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 8 ·Speed: 0.337 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.295 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1238' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 4 ·Speed: 0.336 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMO'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '1262' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.323 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.298 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2252' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.326 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'HAG'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.287 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2257' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.322 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'TMU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.327 ms · DUPLICATE |
SELECT * FROM `yearly_reservation_ranking` WHERE `restaurant_code` = '1576' LIMIT 1Type: ALL ·Rows: 235 ·Speed: 0.546 ms |
SELECT * FROM `master_setmenu` WHERE `restaurant_code` = '1576' AND `reservation_flag` = '1'Type: ALL ·Rows: 341 ·Speed: 1.179 ms |
SELECT * FROM `master_ma_display_tours` WHERE `ct_code` = 'GU'Type: ALL ·Rows: 51 ·Speed: 0.420 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'GU'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.316 ms · DUPLICATE |
SELECT *, `master_restaurant`.`ct_code` FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `lat` != '' AND `lng` != '' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 00:39:24' AND `end_date` > '2019-02-18 00:39:24' ORDER BY `wom_total_rate` DESCPossible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 28.108 ms |