SHOW FULL COLUMNS FROM `wzx_portal_post` [ RunTime:0.008982s ]
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` = '3' AND `relation`.`post_id` = '149' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769965778' ) LIMIT 1 [ RunTime:0.008679s ]
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` = '3' AND `relation`.`post_id` < '149' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769965778' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009365s ]
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` = '3' AND `relation`.`post_id` > '149' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769965778' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009802s ]
SHOW FULL COLUMNS FROM `wzx_portal_category` [ RunTime:0.008719s ]
SELECT * FROM `wzx_portal_category` WHERE `id` = '3' AND `status` = 1 LIMIT 1 [ RunTime:0.008349s ]
UPDATE `wzx_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = '149' [ RunTime:0.013300s ]
SHOW FULL COLUMNS FROM `wzx_user_favorite` [ RunTime:0.008763s ]
SELECT * FROM `wzx_user_favorite` WHERE `user_id` = '0' AND `object_id` = 149 LIMIT 1 [ RunTime:0.008690s ]
SHOW FULL COLUMNS FROM `wzx_theme_file` [ RunTime:0.008816s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.008304s ]
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.008400s ]
SHOW FULL COLUMNS FROM `wzx_user` [ RunTime:0.008823s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008415s ]
SHOW FULL COLUMNS FROM `wzx_nav_menu` [ RunTime:0.008629s ]
SELECT * FROM `wzx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008401s ]
SHOW FULL COLUMNS FROM `wzx_portal_tag` [ RunTime:0.008527s ]
SELECT `id`,`name` FROM `wzx_portal_tag` WHERE ( `status` = 1 AND `recommended` = 1 AND `post_count` > '2' ) ORDER BY `id` DESC [ RunTime:0.008319s ]
SHOW FULL COLUMNS FROM `wzx_plugin` [ RunTime:0.008613s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.008161s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.008245s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008087s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.008306s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.009078s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.008289s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008177s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.008218s ]
SHOW FULL COLUMNS FROM `wzx_comment` [ RunTime:0.008753s ]
SELECT COUNT(*) AS think_count FROM `wzx_comment` WHERE `table_name` = 'portal_post' AND `object_id` = 149 AND `status` = 1 AND `parent_id` = '0' AND `delete_time` = 0 [ RunTime:0.008248s ]
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` = '149' AND `comment`.`status` = '1' AND 0 = 1 AND `comment`.`delete_time` = '0' ORDER BY `comment`.`parent_id` ASC,`comment`.`create_time` DESC ) AS sub WHERE `count` <= '5' [ RunTime:0.008649s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Comment' LIMIT 1 [ RunTime:0.008156s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'TencentApp' LIMIT 1 [ RunTime:0.008256s ]
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` < '1769965779' ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.031395s ]
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` < '1769965779' ) GROUP BY `post`.`id` ORDER BY `post`.`comment_count` DESC LIMIT 0,8 [ RunTime:0.010658s ]
SHOW FULL COLUMNS FROM `wzx_link` [ RunTime:0.008758s ]
SELECT * FROM `wzx_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008370s ]
评 论