[ SQL ] SHOW COLUMNS FROM `templates` [ RunTime:0.000610s ]
[ 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 = 168 ) AND ( af.en_name = 'pc_special_tpl_id' )) [ RunTime:0.000350s ]
[ 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 ('145','251','333','144','278','124') [ RunTime:0.000521s ]
[ 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 ('137','175','118','99','264','131') [ RunTime:0.000528s ]
[ SQL ] SELECT DISTINCT `article_id` FROM `article_tags` WHERE `tag_id` IN ('') AND `article_id` <> 168 AND `folder_id` IN (27) ORDER BY `article_id` DESC LIMIT 0,160 [ RunTime:0.000306s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `article_tags` WHERE `tag_id` IN ('') AND `article_id` <> 168 AND `folder_id` IN (27) [ RunTime:0.000266s ]
[ SQL ] SELECT DISTINCT `article_id` FROM `article_tags` WHERE `tag_id` IN (36481) AND `article_id` <> 168 AND `folder_id` IN (4,11,9,6,5,10,8,3,12,7) ORDER BY `article_id` DESC LIMIT 0,120 [ RunTime:0.000337s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `article_tags` WHERE `tag_id` IN (36481) AND `article_id` <> 168 AND `folder_id` IN (4,11,9,6,5,10,8,3,12,7) [ RunTime:0.000331s ]
[ 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` = '168' [ RunTime:0.000366s ]
[ 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 ('168') [ RunTime:0.000322s ]
[ 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 ('168') [ RunTime:0.000277s ]
