SHOW FULL COLUMNS FROM `tb_article_collection` [ RunTime:0.005086s ]
SELECT `a`.`img`,`a`.`name`,`intro` FROM `tb_article_collection` `a` WHERE ( a.delete_at is null or a.delete_at ="" or a.delete_at="0000-00-00 00:00:00" ) AND ( status=2 ) AND `a`.`id` = '34' LIMIT 1 [ RunTime:0.008573s ]
SHOW FULL COLUMNS FROM `tb_collection_articles` [ RunTime:0.007857s ]
SELECT COUNT(*) AS think_count FROM `tb_collection_articles` `a` LEFT JOIN `tb_article_content` `b` ON `b`.`id`=`a`.`article_id` WHERE ( a.article_id<>0 ) AND `a`.`collection_id` = '34' AND `b`.`status` = '2' [ RunTime:0.008499s ]
SELECT a.article_id as id,`b`.`cover`,`b`.`title`,`b`.`desc`,`b`.`create_at`,`b`.`m_reading`,`b`.`level_limit` FROM `tb_collection_articles` `a` LEFT JOIN `tb_article_content` `b` ON `b`.`id`=`a`.`article_id` WHERE ( a.article_id<>0 ) AND `a`.`collection_id` = '34' AND `b`.`status` = '2' ORDER BY `b`.`create_at` DESC LIMIT 0,30 [ RunTime:0.005701s ]
