[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001612s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`is_top` = '1' ) AND ( `category_post`.`category_id` IN ('18','19') ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.007979s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`thumbnail` <> '' ) AND ( `category_post`.`category_id` = '18' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.002239s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`thumbnail` <> '' ) AND ( `category_post`.`category_id` = '18' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.002046s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`thumbnail` <> '' ) AND ( `category_post`.`category_id` = '18' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.001835s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '18' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 3 [ RunTime:0.002516s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '19' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 3 [ RunTime:0.012689s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('27','28','29') ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 35 [ RunTime:0.001212s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('51','52','53','54','55') ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.002310s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '3，20' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.003323s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 9 [ RunTime:0.000797s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '5' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC LIMIT 6 [ RunTime:0.000666s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('36','37','38','39') ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.000773s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '57' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.001441s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN ('40','41','42') ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.000668s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '58' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.000804s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '7' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1793728707 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.002256s ]
