[ SQL ] SHOW COLUMNS FROM `cmf_nami_teams` [ RunTime:0.003219s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 0 AND `cid` IN (10114,10148,10116,10131,10137,10129,104342,10161,10732,11072,21609,104343) [ RunTime:0.003147s ]
[ SQL ] SELECT `cid`,`short_name_zh`,`name_zh`,`logo` FROM `cmf_nami_teams` WHERE `com_type` = 1 AND `cid` IN (10114,10148,10116,10131,10137,10129,104342,10161,10732,11072,21609,104343) [ RunTime:0.003026s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.003239s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_post` `post` WHERE `site_id` = 40 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 [ RunTime:0.013317s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 40 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 ORDER BY `published_time` DESC LIMIT 1188,12 [ RunTime:0.007980s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.003072s ]
[ 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 (7251109,7251005,7250830,7250708,7250552,7250377,7250274,7250135,7249996,7249887,7249748,7249608) [ RunTime:0.004176s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `post` WHERE `site_id` = 40 AND `post_status` = 1 AND `post_type` = 1 AND `delete_time` = 0 AND ( `category_id` IN (268,269,270) ) ORDER BY `published_time` DESC LIMIT 0,20 [ RunTime:0.003284s ]
