[ SQL ] SHOW COLUMNS FROM `dzpark_hook_plugin` [ RunTime:0.000600s ]
[ SQL ] SELECT `hook`,`plugin` FROM `dzpark_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `dzpark_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 15 ORDER BY `list_order` ASC [ RunTime:0.000541s ]
[ SQL ] SHOW COLUMNS FROM `dzpark_portal_post` [ RunTime:0.000736s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327198 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000690s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '22' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327198 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000734s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327198 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000529s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '23' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327198 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000718s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '24' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327198 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.001920s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '24' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000715s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '26' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000492s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '26' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000713s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '27' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000491s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '27' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000712s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '28' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000516s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '28' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000674s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '29' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000453s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '29' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000626s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '31' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000455s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '31' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000681s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '32' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000463s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '32' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000667s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '33' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000450s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '33' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000623s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '40' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000463s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '40' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000618s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '42' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000431s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '42' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000692s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '43' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000470s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '43' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000673s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000459s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '44' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000657s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '45' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000511s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '45' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000681s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '46' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000450s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '46' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000670s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '51' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000550s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '51' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000686s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '62' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000474s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '62' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000684s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '63' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000507s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '63' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000699s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '64' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000514s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `dzpark_portal_post` `post` INNER JOIN `dzpark_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`.`create_time` >= 0 ) AND ( `category_post`.`category_id` = '64' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1711327199 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.000795s ]