SHOW FULL COLUMNS FROM `db_config` [ RunTime:0.000712s ]
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.000479s ]
SHOW FULL COLUMNS FROM `db_news_category` [ RunTime:0.000576s ]
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.000514s ]
SELECT * FROM `db_news_category` WHERE `db_news_category`.`pid` = '4' ORDER BY `sort` DESC [ RunTime:0.000635s ]
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.000511s ]
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` = '23' LIMIT 1 [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.000818s ]
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` = 23 [ RunTime:0.000737s ]
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` = 23 ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 0,6 [ RunTime:0.000892s ]
