Home
ร้านอาหาร
คอมเม้นต์ร้านทั้งหมด
แชร์ชวนชิมร้านคำพูน : รูปทั้งหมด
โพสเมื่อ:
23 ก.ค. 2011 ตอน 07:24 น
By: pijno
คอหมูย่าง พรีเซนเตชั่นสวยน่ากินมาก เสียแต่น้อยไปหน่อย - -' แต่รสชาติดีเลยคับ
Sort by:
Showing 1-7 from 7 total
Showing 1-7 from 7 total
« Prev Next »
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `rests_pics` | 22 | 22 | 20 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 1 | |
| 3 | SHOW FULL COLUMNS FROM `rest_pic_types` | 6 | 6 | 17 | |
| 4 | SHOW FULL COLUMNS FROM `admin_tmp_pics` | 12 | 12 | 9 | |
| 5 | SHOW FULL COLUMNS FROM `blds_pics` | 19 | 19 | 10 | |
| 6 | SHOW FULL COLUMNS FROM `visits` | 7 | 7 | 10 | |
| 7 | SHOW FULL COLUMNS FROM `unique_visitors` | 5 | 5 | 13 | |
| 8 | SHOW FULL COLUMNS FROM `searches` | 10 | 10 | 11 | |
| 9 | SHOW FULL COLUMNS FROM `rest_features` | 10 | 10 | 14 | |
| 10 | SHOW FULL COLUMNS FROM `rests_rest_features` | 3 | 3 | 10 | |
| 11 | SHOW FULL COLUMNS FROM `rest_chains_histories` | 18 | 18 | 10 | |
| 12 | SHOW FULL COLUMNS FROM `website_deals` | 17 | 17 | 24 | |
| 13 | SHOW FULL COLUMNS FROM `deal_websites` | 5 | 5 | 15 | |
| 14 | SHOW FULL COLUMNS FROM `report_statuses` | 5 | 5 | 24 | |
| 15 | SHOW FULL COLUMNS FROM `reported_members` | 11 | 11 | 13 | |
| 16 | SHOW FULL COLUMNS FROM `corrected_blds` | 32 | 32 | 17 | |
| 17 | SHOW FULL COLUMNS FROM `corrected_rests` | 52 | 52 | 18 | |
| 18 | SHOW FULL COLUMNS FROM `corrected_rest_chains` | 21 | 21 | 17 | |
| 19 | SHOW FULL COLUMNS FROM `saved_rests` | 6 | 6 | 14 | |
| 20 | SHOW FULL COLUMNS FROM `messages` | 12 | 12 | 16 | |
| 21 | SHOW FULL COLUMNS FROM `follows` | 5 | 5 | 19 | |
| 22 | SHOW FULL COLUMNS FROM `rests_hours` | 9 | 9 | 29 | |
| 23 | SHOW FULL COLUMNS FROM `rests_histories` | 54 | 54 | 15 | |
| 24 | SHOW FULL COLUMNS FROM `articles` | 14 | 14 | 14 | |
| 25 | SHOW FULL COLUMNS FROM `articles_pics` | 6 | 6 | 20 | |
| 26 | SHOW FULL COLUMNS FROM `articles_comments` | 8 | 8 | 19 | |
| 27 | SHOW FULL COLUMNS FROM `articles_blds` | 5 | 5 | 16 | |
| 28 | SHOW FULL COLUMNS FROM `articles_rests` | 5 | 5 | 16 | |
| 29 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
| 30 | SELECT `Rest`.`id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`branch_nameEn`, `Rest`.`tags`, `Rest`.`descriptionTh`, `Rest`.`descriptionEn`, `Rest`.`seo_url`, `Rest`.`full_text`, `Rest`.`st_addrTh`, `Rest`.`st_addrEn`, `Rest`.`directionTh`, `Rest`.`directionEn`, `Rest`.`th_province_id`, `Rest`.`country_id`, `Rest`.`lat`, `Rest`.`lng`, `Rest`.`bts_id`, `Rest`.`bts_minutes`, `Rest`.`mrt_id`, `Rest`.`mrt_minutes`, `Rest`.`tel`, `Rest`.`official_website`, `Rest`.`official_menu`, `Rest`.`facebook`, `Rest`.`hours`, `Rest`.`price_range_id`, `Rest`.`rest_chain_id`, `Rest`.`bld_id`, `Rest`.`bld_floor`, `Rest`.`bld_zone`, `Rest`.`in_bld_addrTh_orig`, `Rest`.`in_bld_addrTh`, `Rest`.`in_bld_addrEn`, `Rest`.`cur_overall_rating`, `Rest`.`num_overall_rating`, `Rest`.`cur_taste_rating`, `Rest`.`num_taste_rating`, `Rest`.`cur_atmosphere_rating`, `Rest`.`num_atmosphere_rating`, `Rest`.`cur_price_rating`, `Rest`.`num_price_rating`, `Rest`.`cur_service_rating`, `Rest`.`num_service_rating`, `Rest`.`bayesian_rating`, `Rest`.`is_our_member`, `Rest`.`from_owner`, `Rest`.`num_comments`, `Rest`.`num_kratoos`, `Rest`.`num_pics`, `Rest`.`num_external_reviews`, `Rest`.`active`, `Rest`.`moved_to_rest_id`, `Rest`.`added_by_member_id`, `Rest`.`created`, `Rest`.`modified`, `Rest`.`primary_rests_pic_id`, `Rest`.`primary_pic_by_admin`, `Rest`.`primary_rests_pic_thumb_m`, `Rest`.`admin_validated`, `Rest`.`cuisine_type_ids`, `Rest`.`rest_type_ids`, `Rest`.`rest_feature_ids`, `Rest`.`logo`, `Rest`.`logo_s`, `Rest`.`logo_thumb`, `Rest`.`logo_thumb_s`, (CONCAT(`Rest`.`nameTh`, " (", `Rest`.`nameEn`, ")")) AS `Rest__nameThEn`, `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`seo_url`, `Bld`.`bts_id`, `Bld`.`mrt_id`, `Bld`.`bld_type_id`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`seo_url` FROM `rests` AS `Rest` LEFT JOIN `blds` AS `Bld` ON (`Rest`.`bld_id` = `Bld`.`id`) LEFT JOIN `btses` AS `Bts` ON (`Rest`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Rest`.`mrt_id` = `Mrt`.`id`) LEFT JOIN `rest_chains` AS `RestChain` ON (`Rest`.`rest_chain_id` = `RestChain`.`id`) WHERE `Rest`.`id` = 627 AND `Rest`.`active` = 1 LIMIT 1 | 1 | 1 | 2 | |
| 31 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`seo_url`, `Bld`.`bts_id`, `Bld`.`mrt_id`, `Bld`.`bld_type_id` FROM `blds` AS `Bld` WHERE `Bld`.`id` = 5 | 1 | 1 | 0 | |
| 32 | SELECT `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE `Bts`.`id` = 9 | 1 | 1 | 0 | |
| 33 | SELECT `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | 1 | 1 | 0 | |
| 34 | SELECT COUNT(*) AS `count` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `RestsPic`.`rest_id` = 627 | 1 | 1 | 3 | |
| 35 | SELECT `RestsPic`.`id`, `RestsPic`.`member_id`, `RestsPic`.`member_ip`, `RestsPic`.`rest_id`, `RestsPic`.`rests_comment_id`, `RestsPic`.`order_in_comment`, `RestsPic`.`created`, `RestsPic`.`file_name`, `RestsPic`.`file_name_l`, `RestsPic`.`file_name_m`, `RestsPic`.`file_name_s`, `RestsPic`.`file_name_thumb_l`, `RestsPic`.`file_name_thumb_m`, `RestsPic`.`file_name_thumb_s`, `RestsPic`.`caption`, `RestsPic`.`rest_pic_type_id`, `RestsPic`.`file_size`, `RestsPic`.`date_taken`, `RestsPic`.`active`, `RestsPic`.`reported`, `RestsPic`.`modified`, `RestsPic`.`num_likes`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `RestsPic`.`rest_id` = 627 ORDER BY `RestsPic`.`id` DESC LIMIT 60 | 7 | 7 | 13 | |
| 36 | SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R WHERE RestsPic.`rest_id` = '627' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '176' LIMIT 1 | 1 | 1 | 5 | |
| 37 | SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R WHERE RestsPic.`rest_id` = '627' 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 | 4 |
