[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000784s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002462s ]
[ 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` < '1610862648' ) 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') AND `post`.`id` IN ('170','174','177','183','184','185','186','190','202','204','215','236','237','250','254','269','279','300','301','345','464','471','487','507','581','618','656','665','671','677','685','694','701','715','735','757','758','761','762','769','774','776','784','786','789','798','802','804','810','820','826','842','854','856','756','871','874','878','885','909','922','932','937','949','951','959','963','693','970','973','976','980','982','992','994','995','999','1000','1003','1007','1012','1017','1023','1024','1031','1034','1035','1037','1038','1039','1040','1042','1048','1060','1063','1064','1070','1072','1079','1080','1084','1102','1106','1110','1112','1113','1118','1120','1121','1122','1124','1131','1134','1136','1138','1140','1143','1144','1149','1151','1155','1158','1160','1166','1168','1169','1172','1174','1175','1177','1184','1189','1190','1192','1194','1196','1199','1201','1205','1206','1207','1208','1210','1211','1213','1214','1215','1216','1217','1219','1220','1222','1224','1226','1227','1229','1232','1233','1235','1236','1240','1243','1244','1245','1246','1247','1248','1253','1254','1255','1257','1258','1259','1260','1261') GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.004464s ]
[ 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` < '1610862648' ) 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') AND `post`.`id` IN ('170','174','177','183','184','185','186','190','202','204','215','236','237','250','254','269','279','300','301','345','464','471','487','507','581','618','656','665','671','677','685','694','701','715','735','757','758','761','762','769','774','776','784','786','789','798','802','804','810','820','826','842','854','856','756','871','874','878','885','909','922','932','937','949','951','959','963','693','970','973','976','980','982','992','994','995','999','1000','1003','1007','1012','1017','1023','1024','1031','1034','1035','1037','1038','1039','1040','1042','1048','1060','1063','1064','1070','1072','1079','1080','1084','1102','1106','1110','1112','1113','1118','1120','1121','1122','1124','1131','1134','1136','1138','1140','1143','1144','1149','1151','1155','1158','1160','1166','1168','1169','1172','1174','1175','1177','1184','1189','1190','1192','1194','1196','1199','1201','1205','1206','1207','1208','1210','1211','1213','1214','1215','1216','1217','1219','1220','1222','1224','1226','1227','1229','1232','1233','1235','1236','1240','1243','1244','1245','1246','1247','1248','1253','1254','1255','1257','1258','1259','1260','1261') GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`published_time` DESC LIMIT 0,8 [ RunTime:0.023476s ]
