[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `list_tpl` = 'article' AND `parent_id` = 0 ORDER BY `list_order` DESC,`id` ASC [ RunTime:0.000219s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000501s ]
[ SQL ] SELECT `a`.* FROM `cmf_portal_post` `a` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `c`.`id`=`b`.`category_id` WHERE `c`.`list_tpl` = 'article' AND `a`.`delete_time` = '0' AND `a`.`post_type` = '1' AND `a`.`post_status` = '1' AND `b`.`category_id` = '23' ORDER BY `list_order` ASC,`update_time` DESC [ RunTime:0.000560s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `a` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `c`.`id`=`b`.`category_id` WHERE `c`.`list_tpl` = 'article' AND `a`.`delete_time` = '0' AND `a`.`post_type` = '1' AND `a`.`post_status` = '1' AND `b`.`category_id` = '2' [ RunTime:0.000250s ]
[ SQL ] SELECT `a`.* FROM `cmf_portal_post` `a` INNER JOIN `cmf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` INNER JOIN `cmf_portal_category` `c` ON `c`.`id`=`b`.`category_id` WHERE `c`.`list_tpl` = 'article' AND `a`.`delete_time` = '0' AND `a`.`post_type` = '1' AND `a`.`post_status` = '1' AND `b`.`category_id` = '2' ORDER BY `list_order` ASC,`update_time` DESC LIMIT 0,10 [ RunTime:0.000370s ]
0577-6607 2217
WECHAT
中文
English
