SHOW FULL COLUMNS FROM `moban_site` [ RunTime:0.004839s ]
SELECT * FROM `moban_site` WHERE `lang` = 'zh-cn' LIMIT 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `moban_columns` [ RunTime:0.001475s ]
SELECT * FROM `moban_columns` WHERE `state` = 1 AND `lang` = 'zh-cn' ORDER BY `sort` ASC [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `moban_news` [ RunTime:0.001176s ]
SELECT * FROM `moban_news` WHERE `lang` = 'zh-cn' AND `state` = 1 LIMIT 1 [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `moban_news_category` [ RunTime:0.001051s ]
SELECT * FROM `moban_news_category` WHERE `lang` = 'zh-cn' ORDER BY `id` ASC [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `moban_single_page` [ RunTime:0.001039s ]
SELECT * FROM `moban_single_page` WHERE `id` IN (0,54,32,33,45,74,75,76) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.000495s ]
SELECT * FROM `moban_single_page` WHERE `id` IN (0,35,77) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `moban_link` [ RunTime:0.001010s ]
SELECT * FROM `moban_link` WHERE `state` = 1 ORDER BY `sort` ASC [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `moban_banner` [ RunTime:0.001461s ]
SELECT * FROM `moban_banner` WHERE `state` = 1 AND `lang` = 'zh-cn' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `moban_products` [ RunTime:0.001490s ]
SELECT * FROM `moban_products` WHERE `recommend` = 1 AND `state` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `moban_products` WHERE `hot` = 1 AND `state` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `moban_products` WHERE `popularize` = 1 AND `state` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT * FROM `moban_news` WHERE `state` = 1 AND `is_draft` = 0 AND `recommend` = 1 AND `lang` = 'zh-cn' ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.001127s ]
SELECT category_id,count(id) total FROM `moban_products` WHERE `state` = 1 GROUP BY `category_id` [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `moban_category` [ RunTime:0.001227s ]
SELECT * FROM `moban_category` ORDER BY `id` ASC [ RunTime:0.000483s ]