SHOW FULL COLUMNS FROM `cnpscy_articles` [ RunTime:0.000975s ]
SELECT `article_title`,`article_id` FROM `cnpscy_articles` `a` WHERE `a`.`category_id` IN ('6','7') AND `a`.`is_delete` = '0' AND `a`.`is_public` = '1' ORDER BY `article_id` DESC LIMIT 3 [ RunTime:0.000416s ]
SELECT `a`.`article_id`,`label_name`,`label`.`label_id` FROM `cnpscy_articles` `a` LEFT JOIN `cnpscy_article_with_labels` `awl` ON `awl`.`article_id`=`a`.`article_id` LEFT JOIN `cnpscy_article_labels` `label` ON `awl`.`label_id`=`label`.`label_id` WHERE `a`.`category_id` IN ('6','7') AND `a`.`is_delete` = '0' AND `a`.`is_public` = '1' ORDER BY `a`.`article_id` DESC LIMIT 15 [ RunTime:0.000414s ]
SELECT c.category_id, c.category_name, count(c.category_id) as article_num FROM `cnpscy_articles` `a` LEFT JOIN `cnpscy_article_categories` `c` ON `a`.`category_id`=`c`.`category_id` WHERE `a`.`category_id` IN ('6','7') AND `a`.`is_delete` = '0' AND `a`.`is_public` = '1' GROUP BY `c`.`category_id`,`c`.`category_name` ORDER BY `c`.`category_id` DESC LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `cnpscy_articles` `a` LEFT JOIN `cnpscy_article_categories` `c` ON `c`.`category_id`=`a`.`category_id` WHERE `a`.`article_id` = '148' AND `a`.`is_delete` = '0' AND `a`.`is_public` = '1' LIMIT 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `cnpscy_article_with_labels` [ RunTime:0.000711s ]
SELECT * FROM `cnpscy_article_with_labels` `awl` LEFT JOIN `cnpscy_article_labels` `label` ON `awl`.`label_id`=`label`.`label_id` WHERE `is_delete` = '0' AND `article_id` = 148 [ RunTime:0.000311s ]
