[ SQL ] SHOW COLUMNS FROM `zitu_search_log` [ RunTime:0.000901s ]
[ SQL ] SELECT sc.search_content, count('a.search_content_id') as search_count FROM `zitu_search_log` `a` INNER JOIN `zitu_search_content` `sc` ON `a`.`search_content_id`=`sc`.`id` WHERE `sc`.`delete_time` = 0 AND `a`.`delete_time` = 0 GROUP BY `a`.`search_content_id` ORDER BY `search_count` DESC,`initial` ASC LIMIT 10 [ RunTime:0.000718s ]
[ SQL ] SELECT post.*,category_post.list_order, min(category_post.category_id) as category_id FROM `zitu_knowledge_base` `post` INNER JOIN `zitu_knowledge_base_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 ( `category_post`.`category_id` IN (1,2,3,4,5,6,7) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1675078556 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 5 [ RunTime:0.001389s ]
[ SQL ] SELECT `zitu_knowledge_base_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 `zitu_knowledge_base_category` INNER JOIN `zitu_knowledge_base_category_post` `pivot` ON `pivot`.`category_id`=`zitu_knowledge_base_category`.`id` WHERE `pivot`.`post_id` = 47 [ RunTime:0.000367s ]
[ SQL ] SELECT `zitu_knowledge_base_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 `zitu_knowledge_base_category` INNER JOIN `zitu_knowledge_base_category_post` `pivot` ON `pivot`.`category_id`=`zitu_knowledge_base_category`.`id` WHERE `pivot`.`post_id` = 46 [ RunTime:0.000303s ]
[ SQL ] SELECT `zitu_knowledge_base_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 `zitu_knowledge_base_category` INNER JOIN `zitu_knowledge_base_category_post` `pivot` ON `pivot`.`category_id`=`zitu_knowledge_base_category`.`id` WHERE `pivot`.`post_id` = 45 [ RunTime:0.000249s ]
[ SQL ] SELECT `zitu_knowledge_base_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 `zitu_knowledge_base_category` INNER JOIN `zitu_knowledge_base_category_post` `pivot` ON `pivot`.`category_id`=`zitu_knowledge_base_category`.`id` WHERE `pivot`.`post_id` = 42 [ RunTime:0.000225s ]
[ SQL ] SELECT `zitu_knowledge_base_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 `zitu_knowledge_base_category` INNER JOIN `zitu_knowledge_base_category_post` `pivot` ON `pivot`.`category_id`=`zitu_knowledge_base_category`.`id` WHERE `pivot`.`post_id` = 41 [ RunTime:0.000223s ]
