SHOW FULL COLUMNS FROM `cm_term_taxonomy` [ RunTime:0.010679s ]
SELECT `term_taxonomy_id`,`name`,`url` FROM `cm_term_taxonomy` `tt` INNER JOIN `cm_terms` `t` ON `tt`.`term_id`=`t`.`term_id` WHERE ( parent=8 and taxonomy='category' ) [ RunTime:0.009546s ]
SHOW FULL COLUMNS FROM `cm_term_relationships` [ RunTime:0.010446s ]
SELECT COUNT(*) AS think_count FROM `cm_term_relationships` `tr` INNER JOIN `cm_posts` `p` ON `tr`.`object_id`=`p`.`ID` WHERE ( term_taxonomy_id in (11,12) and post_status='publish' ) [ RunTime:0.015198s ]
SELECT `term_taxonomy_id`,`name`,`url` FROM `cm_term_taxonomy` `tt` INNER JOIN `cm_terms` `t` ON `tt`.`term_id`=`t`.`term_id` WHERE ( parent=10 and taxonomy='category' ) [ RunTime:0.009218s ]
SELECT COUNT(*) AS think_count FROM `cm_term_relationships` `tr` INNER JOIN `cm_posts` `p` ON `tr`.`object_id`=`p`.`ID` WHERE ( term_taxonomy_id = 3 and post_status='publish' ) [ RunTime:0.009235s ]
SELECT ID,post_content,post_title,post_date,date_format(post_date,'%Y') as year,date_format(post_date,'%m') as month,date_format(post_date,'%d') as day,term_taxonomy_id FROM `cm_term_relationships` `tr` INNER JOIN `cm_posts` `p` ON `tr`.`object_id`=`p`.`ID` WHERE ( term_taxonomy_id = 3 and post_status='publish' ) ORDER BY `ID` DESC LIMIT 0,100 [ RunTime:0.014096s ]
SELECT `term_taxonomy_id`,`name`,`url` FROM `cm_term_taxonomy` `tt` INNER JOIN `cm_terms` `t` ON `tt`.`term_id`=`t`.`term_id` WHERE ( parent=3 and taxonomy='category' ) [ RunTime:0.009197s ]
