string(206) "SELECT p.tag_id,t.name ,count(p.tag_id)as num FROM `cmf_portal_tag_post` `p` LEFT JOIN `cmf_portal_tag` `t` ON `p`.`tag_id`=`t`.`id` WHERE ( t.status=1 ) GROUP BY `p`.`tag_id` ORDER BY `num` DESC LIMIT 20"
string(417) "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`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1716626209 ) GROUP BY `post`.`id` ORDER BY `post`.`post_hits` DESC LIMIT 8"
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.071039s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.020880s ]
[ SQL ] SELECT p.tag_id,t.name ,count(p.tag_id)as num FROM `cmf_portal_tag_post` `p` LEFT JOIN `cmf_portal_tag` `t` ON `p`.`tag_id`=`t`.`id` WHERE ( t.status=1 ) GROUP BY `p`.`tag_id` ORDER BY `num` DESC LIMIT 20 [ RunTime:0.009104s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.051935s ]
[ 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`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1716626209 ) GROUP BY `post`.`id` ORDER BY `post`.`post_hits` DESC LIMIT 8 [ RunTime:0.014731s ]
[ 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`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1716626209 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.054358s ]
[ 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`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( post.published_time >0 or ( post.post_content like '%净化装置%' ) ) AND ( `category_post`.`category_id` IN (103,104,105,106,107) ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1716626209 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 10 [ RunTime:0.061435s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002462s ]
[ 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` = 2633 [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.004167s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000198s ]
[ 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` = 2632 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000242s ]
[ 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` = 2631 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 107 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 107 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.005071s ]
[ 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` = 2630 [ RunTime:0.001186s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.072969s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.019151s ]
[ 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` = 2629 [ RunTime:0.001398s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.000187s ]
[ 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` = 2628 [ RunTime:0.004261s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.028964s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.002770s ]
[ 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` = 2627 [ RunTime:0.003610s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.007008s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 106 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.016236s ]
[ 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` = 2626 [ RunTime:0.002506s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.013356s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 105 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.001392s ]
[ 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` = 2625 [ RunTime:0.003178s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 104 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.001317s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 104 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.002378s ]
[ 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` = 163 [ RunTime:0.002957s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 103 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.003148s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 103 ORDER BY `list_order` ASC LIMIT 10000 [ RunTime:0.008601s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 1 ORDER BY `list_order` DESC LIMIT 10000 [ RunTime:0.047544s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` DESC LIMIT 10000 [ RunTime:0.013278s ]