[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001920s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` WHERE `site_id` = 37 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (247,248,249) ) AND ( `published_time` > 0 and `published_time` < 1711706055 ) [ RunTime:0.001510s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 37 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (247,248,249) ) AND ( `published_time` > 0 and `published_time` < 1711706055 ) ORDER BY `published_time` DESC LIMIT 0,20 [ RunTime:0.001964s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001520s ]
[ 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 (71644,54496,52153,47724,30253,28973,26549,26510,26486,26485,26484) [ RunTime:0.001704s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9124,9125,9126,9127,9128,2039,2060,5317,1749,1345,227,46,2143,2062,8275,3750,2245,2839) [ RunTime:0.001338s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9129,9130,10723,9131,10724,10725,2335,4982,3268,3409,3108,1628,3353,171,3428,2565,3798) [ RunTime:0.001371s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9139,9140,9141,9142,8260,53,1474,2843,1657,8975,4980,8518,8695,9359) [ RunTime:0.001382s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9129,9130,9131,9132,9133,1653,995,2986,3099,634,5415,2067,3748,3799,5769,10687) [ RunTime:0.001434s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `id` IN (9124,9125,9126,9127,9128,205,1278,1735,8256,2040,4108,4038,4805,8862,2137,2871,3777,8486,10678) [ RunTime:0.001324s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 37 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (250,251,252) ) AND ( `published_time` > 0 and `published_time` < 1711706055 ) ORDER BY `published_time` DESC LIMIT 0,5 [ RunTime:0.001501s ]