SHOW FULL COLUMNS FROM `mall_news` [ RunTime:0.001264s ]
SHOW FULL COLUMNS FROM `mall_column` [ RunTime:0.001376s ]
SHOW FULL COLUMNS FROM `mall_setting` [ RunTime:0.001206s ]
SELECT * FROM `mall_setting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000669s ]
SELECT * FROM `mall_column` [ RunTime:0.000650s ]
SELECT * FROM `mall_news` WHERE `c_id` = 7 AND `logo` <> '' ORDER BY `sort` ASC,`id` DESC LIMIT 7 [ RunTime:0.002047s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 2 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000748s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 11 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000783s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 35 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000627s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 28 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000635s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 32 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000658s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 37 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000789s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000725s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 24 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000771s ]
SELECT * FROM `mall_column` WHERE `parent_id` = 41 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000689s ]
SELECT * FROM `mall_column` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`parent_id` FROM `mall_column` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`parent_id` FROM `mall_column` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`parent_id` FROM `mall_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000492s ]
SELECT * FROM `mall_column` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `mall_column` [ RunTime:0.000631s ]
SELECT COUNT(*) AS think_count FROM `mall_news` `a` LEFT JOIN `mall_column` `b` ON `a`.`c_id`=`b`.`id` WHERE `a`.`logo` <> '' AND `c_id` = 25 LIMIT 1 [ RunTime:0.000847s ]
SELECT `a`.*,`b`.`classname` FROM `mall_news` `a` LEFT JOIN `mall_column` `b` ON `a`.`c_id`=`b`.`id` WHERE `a`.`logo` <> '' AND `c_id` = 25 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.000942s ]
官方微信
