This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find
< Back
Pic no. 1 from 18 Next >
Posted:
8 Dec 2011 at 20:45
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-18 from 18 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
ของกินเล่นแนะนำ
By: KinnShare
ทางขึ้นไปยังร้าน ร้านจ...
By: KinnShare
ในร้าน
By: KinnShare
ทางเข้าร้าน อยู่ชั้น 2...
By: KinnShare
Showing 1-18 from 18 total
« Prev Next »
(default) 42 queries took 517 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `visits`7726
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `unique_visitors`5519
4SHOW FULL COLUMNS FROM `searches`101014
5SHOW FULL COLUMNS FROM `rests_comments_likes`5519
6SHOW FULL COLUMNS FROM `rests_pics_likes`5514
7SHOW FULL COLUMNS FROM `blds_pics_likes`5510
8SHOW FULL COLUMNS FROM `external_reviews_likes`559
9SHOW FULL COLUMNS FROM `external_reviews`232317
10SHOW FULL COLUMNS FROM `rest_chains`353515
11SHOW FULL COLUMNS FROM `price_ranges`7717
12SHOW FULL COLUMNS FROM `rest_chains_cuisine_types`3321
13SHOW FULL COLUMNS FROM `rests_cuisine_types`3323
14SHOW FULL COLUMNS FROM `rest_chains_rest_types`3310
15SHOW FULL COLUMNS FROM `rest_types`101017
16SHOW FULL COLUMNS FROM `rests_rest_types`339
17SHOW FULL COLUMNS FROM `rest_chains_rest_features`3323
18SHOW FULL COLUMNS FROM `rests_rest_features`3316
19SHOW FULL COLUMNS FROM `rest_chains_histories`181816
20SHOW FULL COLUMNS FROM `website_deals`171718
21SHOW FULL COLUMNS FROM `deal_websites`5512
22SHOW FULL COLUMNS FROM `reported_pics`161619
23SHOW FULL COLUMNS FROM `reported_comments`151511
24SHOW FULL COLUMNS FROM `report_statuses`5514
25SHOW FULL COLUMNS FROM `reported_members`111110
26SHOW FULL COLUMNS FROM `corrected_blds`323213
27SHOW FULL COLUMNS FROM `corrected_rests`525213
28SHOW FULL COLUMNS FROM `corrected_rest_chains`212110
29SHOW FULL COLUMNS FROM `saved_rests`6612
30SHOW FULL COLUMNS FROM `messages`121210
31SHOW FULL COLUMNS FROM `follows`5510
32SHOW FULL COLUMNS FROM `articles_rests`5511
33SHOW FULL COLUMNS FROM `blds_histories`333322
34SHOW FULL COLUMNS FROM `settings`4421
35SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';113
36SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
37SELECT `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` = 3085 AND `Rest`.`active` = 1 LIMIT 1110
38SELECT `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` = 3 110
39SELECT 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` = 3085 110
40SELECT `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` = 3085 ORDER BY `RestsPic`.`id` DESC LIMIT 6018180
41 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` = '3085' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '403' LIMIT 1 114
42 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R WHERE RestsPic.`rest_id` = '3085' 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 117
Submit feedback to KinnShare
If you would like to submit feedback to us, report any bugs or problems using KinnShare website, or found any incorrect info. You can use the form below to contact us :-).
submitting ...