SHOW FULL COLUMNS FROM `wzx_portal_post` [ RunTime:0.008518s ]
SELECT `post`.* FROM `wzx_portal_post` `post` INNER JOIN `wzx_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `relation`.`category_id` = '5' AND `relation`.`post_id` = '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769947601' ) LIMIT 1 [ RunTime:0.008336s ]
SELECT `post`.* FROM `wzx_portal_post` `post` INNER JOIN `wzx_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `relation`.`category_id` = '5' AND `relation`.`post_id` < '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769947601' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.015185s ]
SELECT `post`.* FROM `wzx_portal_post` `post` INNER JOIN `wzx_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `relation`.`category_id` = '5' AND `relation`.`post_id` > '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769947601' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008873s ]
SHOW FULL COLUMNS FROM `wzx_portal_category` [ RunTime:0.008248s ]
SELECT * FROM `wzx_portal_category` WHERE `id` = '5' AND `status` = 1 LIMIT 1 [ RunTime:0.008009s ]
UPDATE `wzx_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = '403' [ RunTime:0.012407s ]
SHOW FULL COLUMNS FROM `wzx_user_favorite` [ RunTime:0.008239s ]
SELECT * FROM `wzx_user_favorite` WHERE `user_id` = '0' AND `object_id` = 403 LIMIT 1 [ RunTime:0.008321s ]
SHOW FULL COLUMNS FROM `wzx_theme_file` [ RunTime:0.008252s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.007828s ]
SELECT `more`,`file`,`id`,`is_public` FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND ( `is_public` = 1 OR `file` = 'portal/article' ) ORDER BY `is_public` DESC [ RunTime:0.008090s ]
SHOW FULL COLUMNS FROM `wzx_user` [ RunTime:0.008450s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008336s ]
SHOW FULL COLUMNS FROM `wzx_nav_menu` [ RunTime:0.008318s ]
SELECT * FROM `wzx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008022s ]
SHOW FULL COLUMNS FROM `wzx_portal_tag` [ RunTime:0.008107s ]
SELECT `id`,`name` FROM `wzx_portal_tag` WHERE ( `status` = 1 AND `recommended` = 1 AND `post_count` > '2' ) ORDER BY `id` DESC [ RunTime:0.008058s ]
SHOW FULL COLUMNS FROM `wzx_plugin` [ RunTime:0.008343s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.007873s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.007899s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.007931s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.007876s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.007949s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.007942s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008787s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.007931s ]
SHOW FULL COLUMNS FROM `wzx_comment` [ RunTime:0.008247s ]
SELECT COUNT(*) AS think_count FROM `wzx_comment` WHERE `table_name` = 'portal_post' AND `object_id` = 403 AND `status` = 1 AND `parent_id` = '0' AND `delete_time` = 0 [ RunTime:0.008055s ]
SELECT `id`,`user_id`,`full_name`,`like_count`,`content`,`create_time` FROM `wzx_comment` WHERE `table_name` = 'portal_post' AND `object_id` = 403 AND `status` = 1 AND `parent_id` = '0' AND `delete_time` = 0 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.008010s ]
SELECT * FROM ( SELECT comment.id,comment.parent_id,comment.user_id,comment.to_user_id,comment.full_name,comment.like_count,comment.content,comment.create_time,
user.user_nickname,user.user_login,
@row_number := IF(@prev_parent_id = comment.parent_id, @row_number + 1, 1) AS count,
@prev_parent_id := comment.parent_id FROM `wzx_comment` `comment` LEFT JOIN `wzx_user` `user` ON `comment`.`to_user_id`=`user`.`id` WHERE `comment`.`table_name` = 'portal_post' AND `comment`.`object_id` = '403' AND `comment`.`status` = '1' AND `comment`.`parent_id` = '178' AND `comment`.`delete_time` = '0' ORDER BY `comment`.`parent_id` ASC,`comment`.`create_time` DESC ) AS sub WHERE `count` <= '5' [ RunTime:0.008189s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Comment' LIMIT 1 [ RunTime:0.007824s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'TencentApp' LIMIT 1 [ RunTime:0.007864s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `wzx_portal_post` `post` INNER JOIN `wzx_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 ( `category_post`.`category_id` IN ('3','4','5') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769947603' ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.028497s ]
SELECT post_id,max(category_id),post_title,post_excerpt,published_time FROM `wzx_portal_post` `post` INNER JOIN `wzx_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 ( `category_post`.`category_id` IN ('3','4','5') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769947603' ) GROUP BY `post`.`id` ORDER BY `post`.`comment_count` DESC LIMIT 0,8 [ RunTime:0.010415s ]
SHOW FULL COLUMNS FROM `wzx_link` [ RunTime:0.008436s ]
SELECT * FROM `wzx_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008173s ]
评 论