SHOW FULL COLUMNS FROM `st_about` [ RunTime:0.001894s ]
SELECT `name`,`logo`,`introduce`,`tel`,`wechat`,wechat AS whatsapp,`email`,`business_hours`,`address`,`seo_title`,`seo_keywords`,`seo_description` FROM `st_about` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000711s ]
SHOW FULL COLUMNS FROM `st_page` [ RunTime:0.001228s ]
SELECT `id`,`title` FROM `st_page` WHERE `is_show` = 1 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `st_country` [ RunTime:0.001393s ]
SELECT `id`,`name` FROM `st_country` WHERE `is_show` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000585s ]
SHOW FULL COLUMNS FROM `st_tag` [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `st_tag` WHERE `is_show` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `st_study_tour_group` [ RunTime:0.001722s ]
SELECT COUNT(*) AS think_count FROM `st_study_tour_group` WHERE `is_show` = 1 LIMIT 1 [ RunTime:0.000475s ]
SELECT `stg`.`id`,`stg`.`country_id`,`stg`.`name`,`stg`.`img`,`stg`.`price`,c.name AS country_name FROM `st_study_tour_group` `stg` INNER JOIN `st_country` `c` ON `c`.`id`=`stg`.`country_id` WHERE `stg`.`is_show` = '1' ORDER BY `stg`.`sort` DESC,`stg`.`id` DESC LIMIT 0,12 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `st_study_tour_group_re_tag` [ RunTime:0.001364s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 3 [ RunTime:0.000425s ]
SELECT `name` FROM `st_tag` WHERE `id` = 1 [ RunTime:0.000289s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 2 [ RunTime:0.000277s ]
SELECT `name` FROM `st_tag` WHERE `id` IN (1,2) [ RunTime:0.000489s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 1 [ RunTime:0.000387s ]
SELECT `name` FROM `st_tag` WHERE `id` IN (1,2) [ RunTime:0.000345s ]
全部
13-16 
