1 | SHOW FULL COLUMNS FROM `price_ranges` | | 7 | 7 | 22 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 2 |
3 | SHOW FULL COLUMNS FROM `rests_cuisine_types` | | 3 | 3 | 12 |
4 | SHOW FULL COLUMNS FROM `rests_rest_types` | | 3 | 3 | 17 |
5 | SHOW FULL COLUMNS FROM `rest_types` | | 10 | 10 | 8 |
6 | SHOW FULL COLUMNS FROM `rest_chains_rest_types` | | 3 | 3 | 24 |
7 | SHOW FULL COLUMNS FROM `rests_rest_features` | | 3 | 3 | 25 |
8 | SHOW FULL COLUMNS FROM `rests_hours` | | 9 | 9 | 18 |
9 | SHOW FULL COLUMNS FROM `rests_histories` | | 54 | 54 | 24 |
10 | SHOW FULL COLUMNS FROM `saved_rests` | | 6 | 6 | 10 |
11 | SHOW FULL COLUMNS FROM `corrected_rests` | | 52 | 52 | 24 |
12 | SHOW FULL COLUMNS FROM `report_statuses` | | 5 | 5 | 17 |
13 | SHOW FULL COLUMNS FROM `reported_comments` | | 15 | 15 | 10 |
14 | SHOW FULL COLUMNS FROM `reported_members` | | 11 | 11 | 18 |
15 | SHOW FULL COLUMNS FROM `corrected_blds` | | 32 | 32 | 17 |
16 | SHOW FULL COLUMNS FROM `messages` | | 12 | 12 | 19 |
17 | SHOW FULL COLUMNS FROM `follows` | | 5 | 5 | 19 |
18 | SHOW FULL COLUMNS FROM `articles` | | 14 | 14 | 14 |
19 | SHOW FULL COLUMNS FROM `articles_pics` | | 6 | 6 | 8 |
20 | SHOW FULL COLUMNS FROM `articles_comments` | | 8 | 8 | 12 |
21 | SHOW FULL COLUMNS FROM `articles_blds` | | 5 | 5 | 16 |
22 | SHOW FULL COLUMNS FROM `articles_rests` | | 5 | 5 | 14 |
23 | SHOW FULL COLUMNS FROM `blds_histories` | | 33 | 33 | 15 |
24 | SHOW FULL COLUMNS FROM `blds_hours` | | 9 | 9 | 16 |
25 | SHOW FULL COLUMNS FROM `rests_comments_histories` | | 24 | 24 | 47 |
26 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | | 2 | 2 | 0 |
27 | SELECT `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` = 162 AND `Bld`.`active` = 1 LIMIT 1 | | 1 | 1 | 0 |
28 |
SELECT COUNT(*) AS `total`
FROM `rests_pics`
WHERE `rest_id` IN (
SELECT `id` FROM `rests` WHERE `bld_id` = '162'
)
| | 1 | 1 | 9 |
29 | SELECT 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` = 162 | | 1 | 1 | 1 |
30 | SELECT `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` = 162 ORDER BY `BldsPic`.`id` DESC LIMIT 20 | | 0 | 0 | 3 |