SHOW FULL COLUMNS FROM `travel_site` [ RunTime:0.000668s ]
SHOW FULL COLUMNS FROM `travel_card_type_entry` [ RunTime:0.000495s ]
SELECT * FROM `travel_card_type_entry` WHERE `tag` = 'ticket' AND `status` = 1 AND `url` IS NOT NULL AND `url` <> '' AND ( `site_id` = 0 OR `site_id` = 1 ) ORDER BY `site_id` ASC,`sort_order` ASC,`id` ASC LIMIT 1 [ RunTime:0.000621s ]
SHOW FULL COLUMNS FROM `travel_tag` [ RunTime:0.000585s ]
SELECT `id` FROM `travel_tag` WHERE `slug` = 'shi-jie-hua-hui-da-guan-yuan' AND `status` = 1 LIMIT 1 [ RunTime:0.000941s ]
SELECT * FROM `travel_tag` WHERE `id` = 6786 AND `status` = 1 LIMIT 1 [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `travel_tag_rel` [ RunTime:0.000419s ]
SELECT `t`.`id`,`t`.`name`,`t`.`summary`,`t`.`cover_image`,`t`.`slug`,`t`.`total_distance`,c.name AS category_name,c.icon AS category_icon FROM `travel_tag_rel` `r` LEFT JOIN `travel_topic` `t` ON `t`.`id`=`r`.`content_id` LEFT JOIN `travel_topic_category` `c` ON `c`.`id`=`t`.`category_id` WHERE `r`.`tag_id` = '6786' AND `r`.`content_type` = 'topic' AND `t`.`status` = '1' ORDER BY `t`.`sort_order` ASC,`t`.`id` DESC LIMIT 20 [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `travel_topic_scenic` [ RunTime:0.000609s ]
SELECT `s`.`cover_image` FROM `travel_topic_scenic` `ts` INNER JOIN `travel_scenic` `s` ON `s`.`id`=`ts`.`scenic_id` WHERE `ts`.`topic_id` = '13' AND `s`.`cover_image` IS NOT NULL AND `s`.`cover_image` <> '' ORDER BY `ts`.`sort_order` ASC,`ts`.`id` ASC LIMIT 1 [ RunTime:0.000475s ]
SELECT `a`.`id`,`a`.`title`,`a`.`summary`,`a`.`thumbnail`,`a`.`author`,`a`.`source`,`a`.`create_time`,`a`.`update_time`,`a`.`category_id` FROM `travel_tag_rel` `r` LEFT JOIN `travel_article` `a` ON `a`.`id`=`r`.`content_id` WHERE `r`.`tag_id` = '6786' AND `r`.`content_type` = 'article' AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL ORDER BY `a`.`update_time` DESC,`a`.`id` DESC LIMIT 20 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `travel_tag_link` [ RunTime:0.000399s ]
SELECT `t2`.`id`,`t2`.`name`,`t2`.`slug`,`t2`.`use_count_actual`,`l`.`source` FROM `travel_tag_link` `l` INNER JOIN `travel_tag` `t2` ON `t2`.`id`=l.related_tag_id AND t2.status = 1 WHERE ( `l`.`tag_id` = '6786' OR `l`.`related_tag_id` = '6786' ) AND `t2`.`id` <> '6786' LIMIT 50 [ RunTime:0.003904s ]