SHOW FULL COLUMNS FROM `custom_route` [ RunTime:0.000856s ]
SELECT * FROM `custom_route` WHERE `status` = 1 ORDER BY `order` [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `article` [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `ad_position` [ RunTime:0.000652s ]
SHOW FULL COLUMNS FROM `menu` [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `site_setting` [ RunTime:0.000723s ]
SELECT * FROM `site_setting` [ RunTime:0.000236s ]
SELECT COUNT(*) AS think_count FROM `article` `p` LEFT JOIN `article_content` `act` ON `p`.`id`=`act`.`article_id` LEFT JOIN `article_cate` `ac` ON `p`.`cate`=`ac`.`id` LEFT JOIN `article_cate` `fac` ON `ac`.`father_id`=`fac`.`id` WHERE `p`.`status` = '1' [ RunTime:1.869332s ]
SELECT `p`.*,act.content as content,ac.name as cate_title,ac.pinyin as cate_pinyin,ac.father_id as cate_father_id,fac.pinyin as father_cate_pinyin,fac.name as father_cate_title FROM `article` `p` LEFT JOIN `article_content` `act` ON `p`.`id`=`act`.`article_id` LEFT JOIN `article_cate` `ac` ON `p`.`cate`=`ac`.`id` LEFT JOIN `article_cate` `fac` ON `ac`.`father_id`=`fac`.`id` WHERE `p`.`status` = '1' ORDER BY `p`.`id` DESC LIMIT 0,10 [ RunTime:0.001316s ]
SHOW FULL COLUMNS FROM `article_label` [ RunTime:0.000940s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493066' [ RunTime:0.000445s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493065' [ RunTime:0.000358s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493064' [ RunTime:0.000243s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493063' [ RunTime:0.000278s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493062' [ RunTime:0.000255s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493061' [ RunTime:0.000235s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493060' [ RunTime:0.000254s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493059' [ RunTime:0.000237s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493058' [ RunTime:0.000213s ]
SELECT `l`.* FROM `article_label` `al` INNER JOIN `label` `l` ON `al`.`label_id`=`l`.`id` WHERE `al`.`article_id` = '493057' [ RunTime:0.000208s ]