SELECT * FROM `master_restaurant` WHERE `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Type: ALL ·Rows: 14300 ·Speed: 181.135 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'PH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.473 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = '0' AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 11.071 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` = 'PH' 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: 506 ·Speed: 5.382 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.297 ms |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3384' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.396 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3384' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.337 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '432'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.360 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.275 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3423' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.355 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3423' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.314 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '444'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.322 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.282 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3409' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.368 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3409' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.308 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '435'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` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.282 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3394' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.399 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3394' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.370 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '435'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.372 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3417' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.391 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3417' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.359 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '441'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.367 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.320 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3400' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.390 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3400' AND `category_code` = '64'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` = '433'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.365 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.319 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3589' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.386 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3589' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.357 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '432'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.360 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.317 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3393' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.397 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3393' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.357 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '434'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.321 ms |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.315 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3429' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.358 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3429' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.391 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '444'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.326 ms · DUPLICATE |
SELECT `city_name` FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.322 ms · DUPLICATE |
SELECT `filename` FROM `master_restaurant_picture` WHERE `restaurant_code` = '3443' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.353 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3443' AND `category_code` = '64'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.386 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '435'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.315 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.972 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.451 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.367 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.364 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.354 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '2699' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 3 ·Speed: 0.378 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'HK'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.390 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '2699' AND `category_code` = '44'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.352 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '162'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.351 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.385 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'US'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.395 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.357 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.355 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.400 ms |
SELECT * FROM `master_country` WHERE `ct_code` = '9H'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.341 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.352 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.324 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.418 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'ID'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.359 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.388 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.319 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.428 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.341 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.327 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.417 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'IT'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.345 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.457 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.317 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.388 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.375 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.353 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.400 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.353 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.360 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '28819' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.372 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'FR'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.371 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.360 ms |
SELECT `item_name` FROM `master_item` WHERE `item_code` = '304'Possible keys: item_code ·Key Used: item_code ·Type: const ·Rows: 1 ·Speed: 0.354 ms · DUPLICATE |
SELECT * FROM `master_country`Type: ALL ·Rows: 27 ·Speed: 0.423 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = '9H' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 409 ·Speed: 8.524 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 895 ·Speed: 16.897 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'CN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 621 ·Speed: 12.386 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'HK' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 423 ·Speed: 11.058 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'SG' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 480 ·Speed: 9.621 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MO' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 253 ·Speed: 4.557 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 604 ·Speed: 11.082 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GU' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 317 ·Speed: 6.848 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'TH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 820 ·Speed: 19.314 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'FR' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 606 ·Speed: 12.175 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'US' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 568 ·Speed: 11.160 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MP' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 67 ·Speed: 1.751 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PW' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'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:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 582 ·Speed: 12.071 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 9.855 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MY' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 666 ·Speed: 13.402 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'KH' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:40' AND `end_date` > '2019-02-18 01:39:40'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 407 ·Speed: 8.364 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'MM' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 147 ·Speed: 3.249 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'VN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 755 ·Speed: 17.042 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IN' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 312 ·Speed: 7.048 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'AT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1247 ·Speed: 27.465 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'IT' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 1313 ·Speed: 28.620 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'GB' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 162 ·Speed: 3.564 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ES' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 704 ·Speed: 11.142 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'DE' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 543 ·Speed: 15.832 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'ZZ' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 294 ·Speed: 5.920 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'NC' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:41' AND `end_date` > '2019-02-18 01:39:41'Possible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 13 ·Speed: 0.746 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 = 3438 AND
master_restaurant.ct_code = 'PH' AND
master_restaurant.delete_flag = 0Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.656 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 1.026 ms |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3438' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.411 ms |
SELECT * FROM `restaurant_item` WHERE `restaurant_code` = '3438'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.372 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 = 'PH' OR master_category.ct_code = '' OR master_category.ct_code IS NULL)
ORDER BY master_category.category_code ASCType: ALL ·Rows: 958 ·Speed: 1.602 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3438'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.372 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '3438' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.443 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3438' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.392 ms |
SELECT * FROM `ticket_restaurant` WHERE `restaurant_code` = '3438' AND `status_code` = '0' LIMIT 1Type: ALL ·Rows: 10 ·Speed: 0.389 ms |
select * from weather where stationnumber = 72503Speed: 0.498 ms |
SELECT * FROM `news` WHERE `status` = '1' ORDER BY `public_date` DESC LIMIT 6Type: ALL ·Rows: 608 ·Speed: 0.793 ms |
SELECT * FROM `user_favorite` WHERE `type` = 'restaurant' AND `id` = '3438'Possible keys: id ·Key Used: id ·Type: ref ·Rows: 1 ·Speed: 0.366 ms |
INSERT INTO `restaurant_access_log` (`restaurant_code`, `ip_address`) VALUES ('3438', '34.203.28.212')Speed: 2.826 ms |
SELECT * FROM `restaurant_access_log` WHERE `restaurant_code` = '3438'Type: ALL ·Rows: 7919024 ·Speed: 5.660 s |
SELECT * FROM `master_city` WHERE `ct_code` = 'PH'Type: ALL ·Rows: 203 ·Speed: 0.606 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` = 'PH' ORDER BY `monthly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 1 ·Speed: 0.471 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` = 'PH' ORDER BY `yearly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 172 ·Speed: 0.919 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.361 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3409' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.373 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.807 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3409' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 8.468 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.335 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3384' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.366 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.731 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3384' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.386 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.343 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3423' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.435 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.780 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3423' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.361 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.377 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3417' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.376 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.732 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3417' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.362 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.372 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3394' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.375 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.786 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3394' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.397 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.341 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3393' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.422 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.741 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3393' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.363 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.339 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3400' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.379 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.720 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3400' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.329 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 5.648 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3383' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.359 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.778 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3383' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.338 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.320 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3473' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.351 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.764 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3473' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.370 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.324 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3405' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.387 ms |
SELECT * FROM master_item WHERE category_code = 64 ORDER BY priority DESCType: ALL ·Rows: 958 ·Speed: 0.710 ms · DUPLICATE |
SELECT `item_code` FROM `restaurant_item` WHERE `restaurant_code` = '3405' AND `category_code` = '64' LIMIT 1Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 1 ·Speed: 0.327 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` = 'PH' ORDER BY `weekly_reservation_ranking`.`rank` ASCKey Used: rank ·Type: index ·Rows: 4 ·Speed: 0.439 ms |
SELECT *,user_word_of_mouth.member_id FROM user_word_of_mouth, master_restaurant
WHERE user_word_of_mouth.restaurant_code = master_restaurant.restaurant_code AND
user_word_of_mouth.restaurant_code = 3438 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.655 ms |
SELECT * FROM master_companion_typeType: ALL ·Rows: 8 ·Speed: 0.315 ms |
SELECT * FROM master_budget WHERE ct_code = 'PH' ORDER BY priority DESCPossible keys: ct_dode ·Key Used: ct_dode ·Type: ref ·Rows: 11 ·Speed: 0.447 ms |
SELECT * FROM `master_restaurant` WHERE `restaurant_code` = '3438'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: const ·Rows: 1 ·Speed: 0.395 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3438' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 8.354 ms |
SELECT * FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `delete_flag` = '0' AND `restaurant_code` != '3438'Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 445 ·Speed: 22.408 ms |
SELECT * FROM `master_city` WHERE `ct_code` = 'PH'Type: ALL ·Rows: 203 ·Speed: 0.557 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 '%/432/%' AND `restaurant_item`.`category_code` = '64' AND `master_restaurant`.`ct_code` = 'PH' AND `master_restaurant`.`delete_flag` = '0' AND `master_restaurant`.`restaurant_code` != '3438' LIMIT 10Possible keys: restaurant_code,ct_code ·Key Used: ct_code,restaurant_code ·Type: index_merge ·Rows: 445 ·Speed: 3.900 ms |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3384' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 5 ·Speed: 0.392 ms · DUPLICATE |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 8.024 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3420' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.360 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.355 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3431' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.355 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.360 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3445' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.369 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.357 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3461' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.349 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.356 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3464' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.356 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.358 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3466' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.358 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.379 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3479' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.388 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.387 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3536' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.392 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.408 ms · DUPLICATE |
SELECT * FROM `master_restaurant_picture` WHERE `restaurant_code` = '3541' AND `call_name` = 'Main'Possible keys: restaurant_code ·Key Used: restaurant_code ·Type: ref ·Rows: 2 ·Speed: 0.418 ms |
SELECT * FROM `master_city` WHERE `city_code` = 'CEB'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.349 ms · DUPLICATE |
SELECT * FROM `yearly_reservation_ranking` WHERE `restaurant_code` = '3438' LIMIT 1Type: ALL ·Rows: 172 ·Speed: 0.613 ms |
SELECT * FROM `master_setmenu` WHERE `restaurant_code` = '3438' AND `reservation_flag` = '1'Type: ALL ·Rows: 281 ·Speed: 1.236 ms |
SELECT * FROM `master_ma_display_tours` WHERE `ct_code` = 'PH'Type: ALL ·Rows: 51 ·Speed: 0.467 ms |
SELECT * FROM `master_country` WHERE `ct_code` = 'PH'Possible keys: PRIMARY ·Key Used: PRIMARY ·Type: const ·Rows: 1 ·Speed: 0.342 ms · DUPLICATE |
SELECT *, `master_restaurant`.`ct_code` FROM `master_restaurant` WHERE `ct_code` = 'PH' AND `lat` != '' AND `lng` != '' AND `delete_flag` = 0 AND `open_date` <= '2019-02-18 01:39:47' AND `end_date` > '2019-02-18 01:39:47' ORDER BY `wom_total_rate` DESCPossible keys: ct_code ·Key Used: ct_code ·Type: ref ·Rows: 506 ·Speed: 31.302 ms |