1 | SHOW FULL COLUMNS FROM `reported_pics` | | 16 | 16 | 31 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 2 |
3 | SHOW FULL COLUMNS FROM `visits` | | 7 | 7 | 14 |
4 | SHOW FULL COLUMNS FROM `unique_visitors` | | 5 | 5 | 12 |
5 | SHOW FULL COLUMNS FROM `searches` | | 10 | 10 | 12 |
6 | SHOW FULL COLUMNS FROM `rests_comments_likes` | | 5 | 5 | 27 |
7 | SHOW FULL COLUMNS FROM `rests_pics_likes` | | 5 | 5 | 12 |
8 | SHOW FULL COLUMNS FROM `external_reviews_likes` | | 5 | 5 | 12 |
9 | SHOW FULL COLUMNS FROM `external_reviews` | | 23 | 23 | 12 |
10 | SHOW FULL COLUMNS FROM `price_ranges` | | 7 | 7 | 12 |
11 | SHOW FULL COLUMNS FROM `rests_cuisine_types` | | 3 | 3 | 11 |
12 | SHOW FULL COLUMNS FROM `rest_chains_cuisine_types` | | 3 | 3 | 11 |
13 | SHOW FULL COLUMNS FROM `rests_rest_types` | | 3 | 3 | 11 |
14 | SHOW FULL COLUMNS FROM `rest_types` | | 10 | 10 | 11 |
15 | SHOW FULL COLUMNS FROM `rest_chains_rest_types` | | 3 | 3 | 10 |
16 | SHOW FULL COLUMNS FROM `report_statuses` | | 5 | 5 | 12 |
17 | SHOW FULL COLUMNS FROM `reported_members` | | 11 | 11 | 25 |
18 | SHOW FULL COLUMNS FROM `website_deals` | | 17 | 17 | 23 |
19 | SHOW FULL COLUMNS FROM `deal_websites` | | 5 | 5 | 18 |
20 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | | 2 | 2 | 0 |
21 | 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` = 503 AND `Bld`.`active` = 1 LIMIT 1 | | 1 | 1 | 4 |
22 |
SELECT COUNT(*) AS `total`
FROM `rests_pics`
WHERE `rest_id` IN (
SELECT `id` FROM `rests` WHERE `bld_id` = '503'
)
| | 1 | 1 | 5 |
23 | 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` = 503 | | 1 | 1 | 1 |
24 | 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` = 503 ORDER BY `BldsPic`.`id` DESC LIMIT 20 | | 0 | 0 | 3 |