SHOW FULL COLUMNS FROM `db_config` [ RunTime:0.000830s ]
SELECT `db_config`.*,a.path as logoPath,b.path as logo2Path,c.path as officialAccountCodePath FROM `db_config` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_config`.`logo` LEFT JOIN `db_picture` `b` ON `b`.`id`=`db_config`.`logo2` LEFT JOIN `db_picture` `c` ON `c`.`id`=`db_config`.`official_account_code` WHERE `db_config`.`id` = '1' LIMIT 1 [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `db_news_category` [ RunTime:0.000698s ]
SELECT * FROM `db_news_category` WHERE `db_news_category`.`status` <> '-1' ORDER BY `db_news_category`.`sort` DESC,`db_news_category`.`id` DESC [ RunTime:0.000518s ]
SELECT * FROM `db_news_category` WHERE `db_news_category`.`pid` = '4' ORDER BY `sort` DESC [ RunTime:0.000971s ]
SELECT `db_news_category`.*,a.path as coverPath FROM `db_news_category` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news_category`.`cover` WHERE `db_news_category`.`id` = '4' LIMIT 1 [ RunTime:0.000416s ]
SELECT `db_news_category`.*,a.path as coverPath FROM `db_news_category` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news_category`.`cover` WHERE `db_news_category`.`id` = '21' LIMIT 1 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.000743s ]
SELECT COUNT(*) AS think_count FROM `db_news` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news`.`cover` LEFT JOIN `db_news_category` `b` ON `b`.`id`=`db_news`.`cate` WHERE `db_news`.`status` = '1' AND `cate` = 21 [ RunTime:0.000591s ]
SELECT `db_news`.*,a.path as coverPath,b.title as newsCategoryTitle FROM `db_news` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news`.`cover` LEFT JOIN `db_news_category` `b` ON `b`.`id`=`db_news`.`cate` WHERE `db_news`.`status` = '1' AND `cate` = 21 ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 0,6 [ RunTime:0.000706s ]
