[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001620s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` WHERE `site_id` = 4 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (49,50,51) ) AND ( `published_time` > 0 and `published_time` < 1711714920 ) [ RunTime:0.001797s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 4 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (49,50,51) ) AND ( `published_time` > 0 and `published_time` < 1711714920 ) ORDER BY `published_time` DESC LIMIT 0,20 [ RunTime:0.001888s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001391s ]
[ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` IN (69256,69319,46828,46829,38626,38627,31490,31491,30209,30210,28930,28931,25189,25190,23911,23912,22633,22634,21363,21365) [ RunTime:0.001576s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (10584,10585,10586,1394,2226,4503,28,5635,3651,8269,1878,9397,3919,4610,3668,10540) [ RunTime:0.001379s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (4805,9688,9689,3099,2986,995,205,2137,1278,5769,1735,2040,2871,8486,8256,4038,10678,10687,3777) [ RunTime:0.001317s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9494,9495,9496,1474,1657,53,8260,3338,47,8518,2480,2843,3426,9359,6288) [ RunTime:0.001338s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9298,9299,2040,1278,1735,4108,4038,4805,205,8486,2137,2871,3777,8256,10678) [ RunTime:0.001320s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8790,8791,3750,4980,2039,1749,46,1474,1657,53,4388,2843,4893,8260,8695,2062,3958,8630,8267,2474,3198,8975,8518,10509,9359) [ RunTime:0.001259s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8617,8618,1878,1394,4610,4503,28,5635,2226,3651,3919,8269,9397,10540) [ RunTime:0.001508s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (8427,8428,1731,45,2797,1648,2810,3099,1733,1882,8255,2831,2986,3009,8266,995,8485,8278,2837,8706,8982,4704,9180,9211,9389,5769,9085,4275,10687,9425,8271,9062) [ RunTime:0.001372s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 4 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (52,53,54) ) AND ( `published_time` > 0 and `published_time` < 1711714920 ) ORDER BY `published_time` DESC LIMIT 0,5 [ RunTime:0.210154s ]