Home
ร้านอาหาร
คอมเม้นต์ร้านทั้งหมด
แชร์ชวนชิม
Sort by:
Showing 1-60 from 155 total
Showing 1-60 from 155 total
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `rest_chains` | 35 | 35 | 21 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | |
| 3 | SHOW FULL COLUMNS FROM `blds_pics` | 19 | 19 | 14 | |
| 4 | SHOW FULL COLUMNS FROM `blds_pics_likes` | 5 | 5 | 10 | |
| 5 | SHOW FULL COLUMNS FROM `rests_comments_likes` | 5 | 5 | 9 | |
| 6 | SHOW FULL COLUMNS FROM `external_reviews_likes` | 5 | 5 | 9 | |
| 7 | SHOW FULL COLUMNS FROM `external_reviews` | 23 | 23 | 9 | |
| 8 | SHOW FULL COLUMNS FROM `price_ranges` | 7 | 7 | 16 | |
| 9 | SHOW FULL COLUMNS FROM `rests_cuisine_types` | 3 | 3 | 9 | |
| 10 | SHOW FULL COLUMNS FROM `rest_chains_cuisine_types` | 3 | 3 | 9 | |
| 11 | SHOW FULL COLUMNS FROM `rests_rest_types` | 3 | 3 | 11 | |
| 12 | SHOW FULL COLUMNS FROM `rest_types` | 10 | 10 | 22 | |
| 13 | SHOW FULL COLUMNS FROM `rest_features` | 10 | 10 | 10 | |
| 14 | SHOW FULL COLUMNS FROM `rest_chains_rest_features` | 3 | 3 | 8 | |
| 15 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
| 16 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`lat`, `Bts`.`lng`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`lat`, `Mrt`.`lng`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `blds` AS `Bld` LEFT JOIN `btses` AS `Bts` ON (`Bld`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Bld`.`mrt_id` = `Mrt`.`id`) LEFT JOIN `bld_types` AS `BldType` ON (`Bld`.`bld_type_id` = `BldType`.`id`) WHERE `Bld`.`id` = 5 AND `Bld`.`active` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 17 | SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 5 AND `BldsPic`.`active` = 1 | 1 | 1 | 1 | |
| 18 | SELECT COUNT(*) AS `count` FROM `rests_pics` AS `RestsPic` INNER JOIN rests AS `Rest` ON (`Rest`.`id` = `RestsPic`.`rest_id`) LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`bld_id` = 5 | 1 | 1 | 9 | |
| 19 | SELECT `RestsPic`.*, `Rest`.`id`, `Rest`.`rest_chain_id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`seo_url`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username` FROM `rests_pics` AS `RestsPic` INNER JOIN rests AS `Rest` ON (`Rest`.`id` = `RestsPic`.`rest_id`) LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`bld_id` = 5 ORDER BY `RestsPic`.`id` DESC LIMIT 60 | 60 | 60 | 15 | |
| 20 | SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`bld_id` = '5' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '1448' LIMIT 1 | 1 | 1 | 12 | |
| 21 | SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`bld_id` = '5' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`rank` BETWEEN 0 AND 2 AND Result.`rank` <> 1 ORDER BY Result.`rank` DESC LIMIT 2 | 1 | 1 | 6 |
