This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find


Chain(s) Shabushi : All pics

< Back
Pic no. 1 from 3 Next >
Branch:
GATEWAY EKAMAI
Posted:
20 Jul 2012 at 05:10
By: KinnShare
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-3 from 3 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
Branch: MBK Center
Branch: MBK Center
Showing 1-3 from 3 total
« Prev Next »
(default) 12 queries took 133 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `members`464623
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `th_provinces`9916
4SHOW FULL COLUMNS FROM `mrts`323225
5SHOW FULL COLUMNS FROM `settings`4428
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
7SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
8SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`tags`, `RestChain`.`descriptionTh`, `RestChain`.`descriptionEn`, `RestChain`.`seo_url`, `RestChain`.`tel`, `RestChain`.`official_website`, `RestChain`.`official_menu`, `RestChain`.`facebook`, `RestChain`.`price_range_id`, `RestChain`.`related_chain1_id`, `RestChain`.`related_chain2_id`, `RestChain`.`related_chain3_id`, `RestChain`.`num_rests`, `RestChain`.`cur_overall_rating`, `RestChain`.`active`, `RestChain`.`added_by_member_id`, `RestChain`.`created`, `RestChain`.`modified`, `RestChain`.`num_overall_rating`, `RestChain`.`cur_taste_rating`, `RestChain`.`num_taste_rating`, `RestChain`.`cur_atmosphere_rating`, `RestChain`.`num_atmosphere_rating`, `RestChain`.`cur_price_rating`, `RestChain`.`num_price_rating`, `RestChain`.`cur_service_rating`, `RestChain`.`num_service_rating`, `RestChain`.`logo`, `RestChain`.`logo_s`, `RestChain`.`logo_thumb`, `RestChain`.`logo_thumb_s`, `RestChain`.`show_home_order`, (CONCAT(`RestChain`.`nameTh`, " (", `RestChain`.`nameEn`, ")")) AS `RestChain__nameThEn` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` = 4 AND `RestChain`.`active` = 1 LIMIT 1111
9SELECT COUNT(*) AS `count` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) LEFT JOIN `rests` AS `Rest` ON (`RestsPic`.`rest_id` = `Rest`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`rest_chain_id` = 4 116
10SELECT `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`, `Member`.`first_name`, `Member`.`last_name`, `Rest`.`id`, `Rest`.`rest_chain_id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`branch_nameEn`, `Rest`.`seo_url`, (CONCAT(`Rest`.`nameTh`, " (", `Rest`.`nameEn`, ")")) AS `Rest__nameThEn` FROM `rests_pics` AS `RestsPic` LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) LEFT JOIN `rests` AS `Rest` ON (`RestsPic`.`rest_id` = `Rest`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`rest_chain_id` = 4 ORDER BY `RestsPic`.`id` DESC LIMIT 603317
11 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`.`rest_chain_id` = '4' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '1317' LIMIT 1 117
12 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`.`rest_chain_id` = '4' 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 ...