[ 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` < 1727987544 and `post`.`published_time` > 0 ) ORDER BY `post`.`is_top` DESC,`list_order` DESC,`published_time` DESC [ RunTime:0.001260s ]
[ SQL ] SHOW COLUMNS FROM `zitu_portal_category_post` [ RunTime:0.000806s ]
[ SQL ] SHOW COLUMNS FROM `zitu_portal_category` [ RunTime:0.000975s ]
[ 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.000502s ]
[ 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` < 1727987544 and `post`.`published_time` > 0 ) ORDER BY `post`.`is_top` DESC,`list_order` DESC,`published_time` DESC [ RunTime:0.001273s ]
[ 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.000445s ]