SHOW FULL COLUMNS FROM `db_config` [ RunTime:0.001000s ]
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.000792s ]
SHOW FULL COLUMNS FROM `db_news_category` [ RunTime:0.000812s ]
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.000631s ]
SHOW FULL COLUMNS FROM `db_banner` [ RunTime:0.000837s ]
SELECT `db_banner`.*,a.path as coverPath FROM `db_banner` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_banner`.`cover` WHERE `db_banner`.`status` <> '-1' ORDER BY `db_banner`.`sort` DESC,`db_banner`.`id` DESC [ RunTime:0.000583s ]
SELECT `id` FROM `db_news_category` WHERE `db_news_category`.`pid` = '6' [ RunTime:0.000415s ]
SELECT `id` FROM `db_news_category` WHERE `db_news_category`.`pid` = '4' [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.001077s ]
SELECT `db_news`.*,a.path as coverPath FROM `db_news` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news`.`cover` WHERE `db_news`.`isTop` = '1' AND `db_news`.`status` = '1' AND `db_news`.`cate` IN ('27','26') ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 5 [ RunTime:0.000794s ]
SELECT `db_news`.*,a.path as coverPath FROM `db_news` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news`.`cover` WHERE `db_news`.`isTop` = '1' AND `db_news`.`status` = '1' AND `db_news`.`cate` IN ('24','23','22','21','20') ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 5 [ RunTime:0.000666s ]
SELECT `db_news`.*,a.path as coverPath,`b`.`url` 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`.`cate` = '15' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `db_news`.*,a.path as coverPath FROM `db_news` LEFT JOIN `db_picture` `a` ON `a`.`id`=`db_news`.`cover` WHERE `db_news`.`isTop` = '1' AND `db_news`.`status` = '1' AND `db_news`.`cate` = '25' ORDER BY `db_news`.`sort` DESC,`db_news`.`id` DESC LIMIT 6 [ RunTime:0.000617s ]
