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

< Back Pic no. 2 from 8 Next >
Branch:
MBK Center
Posted:
12 Nov 2011 at 06:47
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-8 from 8 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
Branch: MBK Center
Branch: MBK Center
เบนโตะเซ็ตปลาดิบ
Branch: MBK Center
By: pijno
Showing 1-8 from 8 total
« Prev Next »
(default) 23 queries took 295 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rests_comments`272736
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `nonmembers`3324
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
5SHOW FULL COLUMNS FROM `rests_pics`222218
6SHOW FULL COLUMNS FROM `rest_pic_types`6612
7SHOW FULL COLUMNS FROM `rests_histories`545424
8SHOW FULL COLUMNS FROM `corrected_rest_chains`212120
9SHOW FULL COLUMNS FROM `messages`121220
10SHOW FULL COLUMNS FROM `follows`5515
11SHOW FULL COLUMNS FROM `articles`141415
12SHOW FULL COLUMNS FROM `articles_pics`6612
13SHOW FULL COLUMNS FROM `articles_comments`886
14SHOW FULL COLUMNS FROM `blds_histories`333313
15SHOW FULL COLUMNS FROM `blds_hours`9920
16SHOW FULL COLUMNS FROM `rests_comments_histories`242411
17SHOW FULL COLUMNS FROM `rests_comments_replies`998
18SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
19SELECT `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` = 3 AND `RestChain`.`active` = 1 LIMIT 1111
20SELECT 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` = 3 110
21SELECT `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` = 3 ORDER BY `RestsPic`.`num_likes` desc LIMIT 608823
22 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` = '3' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`num_likes` DESC ) AS Result WHERE Result.`id` = '304' LIMIT 1 117
23 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` = '3' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`num_likes` DESC ) AS Result WHERE Result.`rank` BETWEEN 1 AND 3 AND Result.`rank` <> 2 ORDER BY Result.`rank` DESC LIMIT 2 226
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 ...