This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find
< Back
Pic no. 1 from 6 Next >
Posted:
10 Jan 2012 at 05:19
By: KinnShare
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-6 from 6 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
By: KinnShare
By: KinnShare
เค้กชอค
By: pijno
เค้กมะม่วงโยเกิร์ต อัน...
By: pijno
ข้าวผัดซักอย่างกับปลาด...
By: pijno
ผัดไทยเกี๊ยวกรอบ
By: pijno
Showing 1-6 from 6 total
« Prev Next »
(default) 11 queries took 32 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
2SELECT `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` = 2058 AND `Rest`.`active` = 1 LIMIT 1113
3SELECT `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 110
4SELECT `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 110
5SELECT `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 110
6SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`seo_url` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` = 34 110
7 SELECT COUNT(*) AS `total_photo` FROM `rests_pics` AS RestsPic WHERE RestsPic.`rest_id` IN ( SELECT Rest.`id` FROM `rests` AS Rest WHERE Rest.`rest_chain_id` = '34' ) AND RestsPic.`active` = '1' 115
8SELECT 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` = 2058 113
9SELECT `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` = 2058 ORDER BY `RestsPic`.`id` DESC LIMIT 606610
10 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` = '2058' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '615' LIMIT 1 117
11 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R WHERE RestsPic.`rest_id` = '2058' 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 114
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 ...