[ SQL ] SELECT `post`.* FROM `zitu_portal_post` `post` INNER JOIN `zitu_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 39 AND ( `post`.`published_time` < 1727994970 and `post`.`published_time` > 0 ) ORDER BY `post`.`is_top` DESC,`list_order` DESC,`published_time` DESC [ RunTime:0.001303s ]
[ SQL ] SHOW COLUMNS FROM `zitu_portal_category_post` [ RunTime:0.000838s ]
[ SQL ] SHOW COLUMNS FROM `zitu_portal_category` [ RunTime:0.000872s ]
[ SQL ] SELECT `zitu_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_portal_category` INNER JOIN `zitu_portal_category_post` `pivot` ON `pivot`.`category_id`=`zitu_portal_category`.`id` WHERE `pivot`.`post_id` IN (560,555) [ RunTime:0.000679s ]
[ SQL ] SELECT `post`.* FROM `zitu_portal_post` `post` INNER JOIN `zitu_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 39 AND ( `post`.`published_time` < 1727994970 and `post`.`published_time` > 0 ) ORDER BY `post`.`is_top` DESC,`list_order` DESC,`published_time` DESC [ RunTime:0.000413s ]
[ SQL ] SELECT `zitu_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_portal_category` INNER JOIN `zitu_portal_category_post` `pivot` ON `pivot`.`category_id`=`zitu_portal_category`.`id` WHERE `pivot`.`post_id` IN (560,555) [ RunTime:0.000443s ]