This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find
< Back
Pic no. 1 from 3 Next >
Posted:
2 Dec 2011 at 00:21
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]
By: KinnShare
By: KinnShare
By: KinnShare
Showing 1-3 from 3 total
« Prev Next »
(default) 57 queries took 607 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rests`686829
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `mrts`323222
4SHOW FULL COLUMNS FROM `th_provinces`9913
5SHOW FULL COLUMNS FROM `members`464612
6SHOW FULL COLUMNS FROM `cuisine_types`101016
7SHOW FULL COLUMNS FROM `countries`9914
8SHOW FULL COLUMNS FROM `rests_comments`272713
9SHOW FULL COLUMNS FROM `nonmembers`3312
10SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
11SHOW FULL COLUMNS FROM `rests_pics`222211
12SHOW FULL COLUMNS FROM `rest_pic_types`6613
13SHOW FULL COLUMNS FROM `admin_tmp_pics`121211
14SHOW FULL COLUMNS FROM `blds_pics`191912
15SHOW FULL COLUMNS FROM `visits`7718
16SHOW FULL COLUMNS FROM `unique_visitors`5511
17SHOW FULL COLUMNS FROM `searches`101011
18SHOW FULL COLUMNS FROM `rests_comments_likes`5510
19SHOW FULL COLUMNS FROM `rests_pics_likes`5512
20SHOW FULL COLUMNS FROM `blds_pics_likes`5512
21SHOW FULL COLUMNS FROM `external_reviews_likes`5528
22SHOW FULL COLUMNS FROM `external_reviews`232318
23SHOW FULL COLUMNS FROM `rest_chains`353512
24SHOW FULL COLUMNS FROM `price_ranges`7710
25SHOW FULL COLUMNS FROM `rest_chains_cuisine_types`3310
26SHOW FULL COLUMNS FROM `rests_cuisine_types`3311
27SHOW FULL COLUMNS FROM `rest_chains_rest_types`3311
28SHOW FULL COLUMNS FROM `rest_types`101019
29SHOW FULL COLUMNS FROM `rests_rest_types`3315
30SHOW FULL COLUMNS FROM `rest_chains_rest_features`3312
31SHOW FULL COLUMNS FROM `rest_features`101019
32SHOW FULL COLUMNS FROM `rests_rest_features`3312
33SHOW FULL COLUMNS FROM `rest_chains_histories`181813
34SHOW FULL COLUMNS FROM `website_deals`171710
35SHOW FULL COLUMNS FROM `deal_websites`5510
36SHOW FULL COLUMNS FROM `reported_pics`161612
37SHOW FULL COLUMNS FROM `reported_comments`151516
38SHOW FULL COLUMNS FROM `corrected_blds`323213
39SHOW FULL COLUMNS FROM `corrected_rests`525210
40SHOW FULL COLUMNS FROM `corrected_rest_chains`212110
41SHOW FULL COLUMNS FROM `saved_rests`6610
42SHOW FULL COLUMNS FROM `messages`121211
43SHOW FULL COLUMNS FROM `follows`5510
44SHOW FULL COLUMNS FROM `rests_hours`9911
45SHOW FULL COLUMNS FROM `rests_histories`545410
46SHOW FULL COLUMNS FROM `articles`141417
47SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
48SELECT `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` = 3088 AND `Rest`.`active` = 1 LIMIT 1112
49SELECT `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` = 1971 110
50SELECT `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
51SELECT `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 110
52SELECT `RestChain`.`id`, `RestChain`.`nameTh`, `RestChain`.`nameEn`, `RestChain`.`seo_url` FROM `rest_chains` AS `RestChain` WHERE `RestChain`.`id` = 46 110
53 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` = '46' ) AND RestsPic.`active` = '1' 110
54SELECT 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` = 3088 110
55SELECT `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` = 3088 ORDER BY `RestsPic`.`id` asc LIMIT 60337
56 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` = '3088' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` ASC ) AS Result WHERE Result.`id` = '350' LIMIT 1 112
57 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R WHERE RestsPic.`rest_id` = '3088' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`id` ASC ) AS Result WHERE Result.`rank` BETWEEN 0 AND 2 AND Result.`rank` <> 1 ORDER BY Result.`rank` DESC LIMIT 2 112
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 ...