[ SQL ] SHOW COLUMNS FROM `templates` [ RunTime:0.000566s ]
[ SQL ] SELECT `name`,`content` FROM `templates` WHERE `id` IN (SELECT `ax`.`value` FROM `article_extend_info` `ax` LEFT JOIN `article_fields` `af` ON `af`.`id`=`ax`.`field_id` WHERE ( ax.article_id = 129 ) AND ( af.en_name = 'pc_special_tpl_id' )) [ RunTime:0.000362s ]
[ SQL ] SELECT `a`.`id`,`a`.`folder_id`,`a`.`route_id`,`a`.`title`,`a`.`summary`,`a`.`img`,`a`.`imgs`,`a`.`hot`,`a`.`pageviews`,`a`.`recommend`,`a`.`uid`,`a`.`author`,`a`.`baidupush`,`a`.`checkonly`,`a`.`created_at`,`a`.`acquisition_at`,`a`.`seo_title`,`a`.`seo_keywords`,`a`.`seo_desc`,`a`.`updated_at`,`a`.`status`,`a`.`is_grab`,`b`.`route`,`b`.`route_pattern`,b.seo_title as f_seo_title,b.seo_keywords as f_seo_keywords,b.seo_desc as f_seo_desc,b.status as fstatus FROM `articles` `a` LEFT JOIN `folders` `b` ON `a`.`folder_id`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`id` IN ('119','212','160','152','164','124') [ RunTime:0.000594s ]
[ SQL ] SELECT `a`.`id`,`a`.`folder_id`,`a`.`route_id`,`a`.`title`,`a`.`summary`,`a`.`img`,`a`.`imgs`,`a`.`hot`,`a`.`pageviews`,`a`.`recommend`,`a`.`uid`,`a`.`author`,`a`.`baidupush`,`a`.`checkonly`,`a`.`created_at`,`a`.`acquisition_at`,`a`.`seo_title`,`a`.`seo_keywords`,`a`.`seo_desc`,`a`.`updated_at`,`a`.`status`,`a`.`is_grab`,`b`.`route`,`b`.`route_pattern`,b.seo_title as f_seo_title,b.seo_keywords as f_seo_keywords,b.seo_desc as f_seo_desc,b.status as fstatus FROM `articles` `a` LEFT JOIN `folders` `b` ON `a`.`folder_id`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`id` IN ('106','120','150','96','155','301') [ RunTime:0.000483s ]
[ SQL ] SELECT DISTINCT `article_id` FROM `article_tags` WHERE `tag_id` IN ('') AND `article_id` <> 129 AND `folder_id` IN (27) ORDER BY `article_id` DESC LIMIT 0,160 [ RunTime:0.000308s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `article_tags` WHERE `tag_id` IN ('') AND `article_id` <> 129 AND `folder_id` IN (27) [ RunTime:0.000259s ]
[ SQL ] SELECT DISTINCT `article_id` FROM `article_tags` WHERE `tag_id` IN (36444) AND `article_id` <> 129 AND `folder_id` IN (4,11,9,6,5,10,8,3,12,7) ORDER BY `article_id` DESC LIMIT 0,120 [ RunTime:0.000363s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `article_tags` WHERE `tag_id` IN (36444) AND `article_id` <> 129 AND `folder_id` IN (4,11,9,6,5,10,8,3,12,7) [ RunTime:0.000353s ]
[ SQL ] SELECT `a`.`id`,`a`.`folder_id`,`a`.`route_id`,`a`.`title`,`a`.`summary`,`a`.`img`,`a`.`imgs`,`a`.`hot`,`a`.`pageviews`,`a`.`recommend`,`a`.`uid`,`a`.`author`,`a`.`baidupush`,`a`.`checkonly`,`a`.`created_at`,`a`.`acquisition_at`,`a`.`seo_title`,`a`.`seo_keywords`,`a`.`seo_desc`,`a`.`updated_at`,`a`.`status`,`a`.`is_grab`,`b`.`route`,`b`.`route_pattern`,b.seo_title as f_seo_title,b.seo_keywords as f_seo_keywords,b.seo_desc as f_seo_desc,b.status as fstatus FROM `articles` `a` LEFT JOIN `folders` `b` ON `a`.`folder_id`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`id` = '129' [ RunTime:0.000369s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`tag_id`,`a`.`folder_id`,`b`.`name`,`b`.`fmid` FROM `article_tags` `a` LEFT JOIN `tags` `b` ON `a`.`tag_id`=`b`.`id` WHERE `a`.`article_id` IN ('129') [ RunTime:0.000271s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`attr_id`,`a`.`folder_id`,`b`.`name`,`b`.`fmid` FROM `article_attrs` `a` LEFT JOIN `attrs` `b` ON `a`.`attr_id`=`b`.`id` WHERE `a`.`article_id` IN ('129') [ RunTime:0.000375s ]
