[ SQL ] SHOW COLUMNS FROM `gd_portal_category_post` [ RunTime:0.000482s ]
[ 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` = '1' AND `b`.`post_status` = '1' ORDER BY `a`.`list_order` DESC,`b`.`create_time` DESC LIMIT 8 [ RunTime:0.001271s ]
[ 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 1,10 [ RunTime:0.002851s ]
[ 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 1 [ RunTime:0.002692s ]
