SHOW FULL COLUMNS FROM `st_about` [ RunTime:0.006162s ]
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.005773s ]
SHOW FULL COLUMNS FROM `st_page` [ RunTime:0.004281s ]
SELECT `id`,`title` FROM `st_page` WHERE `is_show` = 1 [ RunTime:0.002917s ]
SHOW FULL COLUMNS FROM `st_country` [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `st_country` WHERE `is_show` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002823s ]
SHOW FULL COLUMNS FROM `st_tag` [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `st_tag` WHERE `is_show` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002911s ]
SHOW FULL COLUMNS FROM `st_study_tour_group` [ RunTime:0.001332s ]
SELECT COUNT(*) AS think_count FROM `st_study_tour_group` WHERE `is_show` = 1 LIMIT 1 [ RunTime:0.002115s ]
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.000339s ]
SHOW FULL COLUMNS FROM `st_study_tour_group_re_tag` [ RunTime:0.001127s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 3 [ RunTime:0.002528s ]
SELECT `name` FROM `st_tag` WHERE `id` = 1 [ RunTime:0.000317s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 2 [ RunTime:0.000284s ]
SELECT `name` FROM `st_tag` WHERE `id` IN (1,2) [ RunTime:0.000263s ]
SELECT `tag_id` FROM `st_study_tour_group_re_tag` WHERE `study_tour_group_id` = 1 [ RunTime:0.000211s ]
SELECT `name` FROM `st_tag` WHERE `id` IN (1,2) [ RunTime:0.000250s ]
全部
13-16 
