SHOW FULL COLUMNS FROM `db_config` [ RunTime:0.001102s ]
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.000978s ]
SHOW FULL COLUMNS FROM `db_news_category` [ RunTime:0.000824s ]
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.000517s ]
SELECT * FROM `db_news_category` WHERE `db_news_category`.`pid` = '4' ORDER BY `sort` DESC [ RunTime:0.000429s ]
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.000415s ]
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` = '24' LIMIT 1 [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.000764s ]
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` = 24 [ RunTime:0.000686s ]
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` = 24 ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 0,6 [ RunTime:0.000742s ]
