[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000505s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.003296s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < '1611788349' ) AND `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `category_post`.`category_id` IN ('1','5','6','12','13','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','52','53','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','83','84','85','86','87','88','89','90','91','93','95','97','98','99','100','101','102','103','104','105','106','108','109','110','111','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','208','209','210','211','213','214','215','216','217') GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.005557s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < '1611788349' ) AND `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND `category_post`.`category_id` IN ('1','5','6','12','13','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','52','53','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','83','84','85','86','87','88','89','90','91','93','95','97','98','99','100','101','102','103','104','105','106','108','109','110','111','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','208','209','210','211','213','214','215','216','217') GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`published_time` DESC LIMIT 0,8 [ RunTime:0.054977s ]
