SHOW FULL COLUMNS FROM `cm_term_taxonomy` [ RunTime:0.011414s ]
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.010034s ]
SHOW FULL COLUMNS FROM `cm_term_relationships` [ RunTime:0.011040s ]
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.009922s ]
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.009928s ]
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.009851s ]
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.014907s ]
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.009824s ]
