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

< Back
Pic no. 1 from 4 Next >
Branch:
Sukhumvit Soi 5
Posted:
29 May 2012 at 03:26
By: KinnShare
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-4 from 4 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
Showing 1-4 from 4 total
« Prev Next »
(default) 17 queries took 281 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `members`464622
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `cuisine_types`101015
4SHOW FULL COLUMNS FROM `countries`9927
5SHOW FULL COLUMNS FROM `rests_comments`272717
6SHOW FULL COLUMNS FROM `reported_pics`161625
7SHOW FULL COLUMNS FROM `visits`7720
8SHOW FULL COLUMNS FROM `unique_visitors`5518
9SHOW FULL COLUMNS FROM `searches`101018
10SHOW FULL COLUMNS FROM `report_statuses`5542
11SHOW FULL COLUMNS FROM `reported_members`111139
12SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
13SELECT `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` = 80 AND `RestChain`.`active` = 1 LIMIT 1111
14SELECT 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` = 80 117
15SELECT `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` = 80 ORDER BY `RestsPic`.`id` DESC LIMIT 604415
16 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` = '80' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` DESC ) AS Result WHERE Result.`id` = '1144' LIMIT 1 117
17 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` = '80' 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 116
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 ...