This is the test environment server: dev.kinnshare.com
แถวไหน
อยากกิน/หาร้าน
< Back
รูปที่ 1 จาก 2 Next >
โพสเมื่อ:
9 มิ.ย. 2011 ตอน 14:50 น
By: KinnShare
คุณอยากจะ..
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-2 from 2 total
« Prev Next »
(default) 27 queries took 66 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `blds`41413
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `btses`33333
4SHOW FULL COLUMNS FROM `mrts`32324
5SHOW FULL COLUMNS FROM `rests`68684
6SHOW FULL COLUMNS FROM `follows`552
7SHOW FULL COLUMNS FROM `website_deals`17173
8SHOW FULL COLUMNS FROM `deal_websites`552
9SHOW FULL COLUMNS FROM `articles`14143
10SHOW FULL COLUMNS FROM `articles_pics`664
11SHOW FULL COLUMNS FROM `articles_comments`883
12SHOW FULL COLUMNS FROM `articles_blds`552
13SHOW FULL COLUMNS FROM `articles_rests`552
14SHOW FULL COLUMNS FROM `blds_histories`33334
15SHOW FULL COLUMNS FROM `blds_hours`993
16SHOW FULL COLUMNS FROM `rests_comments_histories`24243
17SHOW FULL COLUMNS FROM `rests_comments_replies`993
18SHOW FULL COLUMNS FROM `rest_chains_histories`18183
19SHOW FULL COLUMNS FROM `settings`443
20SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
21SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
22SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`lat`, `Bts`.`lng`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`lat`, `Mrt`.`lng`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `blds` AS `Bld` LEFT JOIN `btses` AS `Bts` ON (`Bld`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Bld`.`mrt_id` = `Mrt`.`id`) LEFT JOIN `bld_types` AS `BldType` ON (`Bld`.`bld_type_id` = `BldType`.`id`) WHERE `Bld`.`id` = 1 AND `Bld`.`active` = 1 LIMIT 1110
23 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1' ) 110
24SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` LEFT JOIN `members` AS `Member` ON (`BldsPic`.`member_id` = `Member`.`id`) WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = 1 1111
25SELECT `BldsPic`.`id`, `BldsPic`.`member_id`, `BldsPic`.`member_ip`, `BldsPic`.`bld_id`, `BldsPic`.`created`, `BldsPic`.`file_name`, `BldsPic`.`file_name_l`, `BldsPic`.`file_name_m`, `BldsPic`.`file_name_s`, `BldsPic`.`file_name_thumb_l`, `BldsPic`.`file_name_thumb_m`, `BldsPic`.`file_name_thumb_s`, `BldsPic`.`caption`, `BldsPic`.`pic_type_id`, `BldsPic`.`file_size`, `BldsPic`.`date_taken`, `BldsPic`.`active`, `BldsPic`.`modified`, `BldsPic`.`num_likes`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name` FROM `blds_pics` AS `BldsPic` LEFT JOIN `members` AS `Member` ON (`BldsPic`.`member_id` = `Member`.`id`) WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = 1 ORDER BY `BldsPic`.`id` DESC LIMIT 20221
26 SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '1' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` DESC ) AS Result WHERE Result.`id` = '13' LIMIT 1 110
27 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '1' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` DESC ) AS Result WHERE Result.`rank` BETWEEN 0 AND 2 AND Result.`rank` <> 1 ORDER BY Result.`rank` DESC LIMIT 2 110
Submit feedback to KinnShare
ถ้าคุณต้องการส่ง Feedback ให้ทางทีมงานกินแชร์, แจ้งปัญหาการใช้งานหรือบั๊กของระบบ หรือพบข้อมูลที่ไม่ถูกต้อง คุณสามารถใช้แบบฟอร์มข้างล่างนี้ติดต่อกับเราได้เลยค่ะ
submitting ...