SHOW FULL COLUMNS FROM `wzx_portal_post` [ RunTime:0.009030s ]
SELECT `post`.* FROM `wzx_portal_post` `post` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `post`.`id` = '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942170' ) LIMIT 1 [ RunTime:0.008824s ]
SELECT `post`.* FROM `wzx_portal_post` `post` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `post`.`id` < '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942170' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008835s ]
SELECT `post`.* FROM `wzx_portal_post` `post` WHERE `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `post`.`id` > '403' AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1769942170' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008778s ]
SHOW FULL COLUMNS FROM `wzx_portal_category_post` [ RunTime:0.008946s ]
SHOW FULL COLUMNS FROM `wzx_portal_category` [ RunTime:0.008968s ]
SELECT `wzx_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 `wzx_portal_category` INNER JOIN `wzx_portal_category_post` `pivot` ON `pivot`.`category_id`=`wzx_portal_category`.`id` WHERE ( `pivot`.`post_id` = '403' ) [ RunTime:0.009581s ]
UPDATE `wzx_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = '403' [ RunTime:0.012912s ]
SHOW FULL COLUMNS FROM `wzx_user_favorite` [ RunTime:0.009149s ]
SELECT * FROM `wzx_user_favorite` WHERE `user_id` = '0' AND `object_id` = 403 LIMIT 1 [ RunTime:0.009043s ]
SHOW FULL COLUMNS FROM `wzx_theme_file` [ RunTime:0.009680s ]
SELECT * FROM `wzx_theme_file` WHERE `theme` = 'wzxaini9' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.008842s ]
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.008767s ]
SHOW FULL COLUMNS FROM `wzx_user` [ RunTime:0.009041s ]
SELECT * FROM `wzx_user` WHERE `id` = '1' LIMIT 1 [ RunTime:0.008746s ]
SHOW FULL COLUMNS FROM `wzx_nav_menu` [ RunTime:0.009262s ]
SELECT * FROM `wzx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008780s ]
SHOW FULL COLUMNS FROM `wzx_portal_tag` [ RunTime:0.008913s ]
SELECT `id`,`name` FROM `wzx_portal_tag` WHERE ( `status` = 1 AND `recommended` = 1 AND `post_count` > '2' ) ORDER BY `id` DESC [ RunTime:0.008634s ]
SHOW FULL COLUMNS FROM `wzx_plugin` [ RunTime:0.008972s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.008439s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.008515s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008496s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.008468s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Github' LIMIT 1 [ RunTime:0.008501s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Gitee' LIMIT 1 [ RunTime:0.008449s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Qq' LIMIT 1 [ RunTime:0.008459s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Weibo' LIMIT 1 [ RunTime:0.008545s ]
SHOW FULL COLUMNS FROM `wzx_comment` [ RunTime:0.009030s ]
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.011326s ]
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.008558s ]
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.009293s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'Comment' LIMIT 1 [ RunTime:0.008411s ]
SELECT `status` FROM `wzx_plugin` WHERE `name` = 'TencentApp' LIMIT 1 [ RunTime:0.009375s ]
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` < '1769942171' ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.033041s ]
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` < '1769942171' ) GROUP BY `post`.`id` ORDER BY `post`.`comment_count` DESC LIMIT 0,8 [ RunTime:0.011618s ]
SHOW FULL COLUMNS FROM `wzx_link` [ RunTime:0.009844s ]
SELECT * FROM `wzx_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.008792s ]
评 论