[ SQL ] SHOW COLUMNS FROM `gd_portal_category_post` [ RunTime:0.000641s ]
[ SQL ] SELECT `a`.`category_id`,`b`.* FROM `gd_portal_category_post` `a` LEFT JOIN `gd_portal_post` `b` ON `a`.`post_id`=`b`.`id` WHERE `b`.`post_status` = '1' AND `b`.`delete_time` = '0' ORDER BY `a`.`list_order` DESC,`b`.`create_time` DESC LIMIT 2 [ RunTime:0.004448s ]
[ SQL ] SELECT `a`.`category_id`,`b`.* FROM `gd_portal_category_post` `a` LEFT JOIN `gd_portal_post` `b` ON `a`.`post_id`=`b`.`id` WHERE `a`.`category_id` IN ('1') AND `b`.`post_status` = '1' AND `b`.`delete_time` = '0' ORDER BY `a`.`list_order` DESC,`b`.`create_time` DESC LIMIT 5 [ RunTime:0.003679s ]
[ SQL ] SELECT `a`.`category_id`,`b`.* FROM `gd_portal_category_post` `a` LEFT JOIN `gd_portal_post` `b` ON `a`.`post_id`=`b`.`id` WHERE `a`.`category_id` IN ('1') AND `b`.`post_status` = '1' AND `b`.`delete_time` = '0' ORDER BY `a`.`list_order` DESC,`b`.`create_time` DESC LIMIT 4,6 [ RunTime:0.003723s ]
[ SQL ] SELECT `a`.`category_id`,`b`.* FROM `gd_portal_category_post` `a` LEFT JOIN `gd_portal_post` `b` ON `a`.`post_id`=`b`.`id` WHERE `a`.`category_id` IN ('7','8','9','10','11','12','4') AND `b`.`post_status` = '1' AND `b`.`delete_time` = '0' ORDER BY `a`.`list_order` DESC,`b`.`create_time` DESC LIMIT 12 [ RunTime:0.001260s ]