[ DB ] CONNECT:[ UseTime:0.000327s ] mysql:host=127.0.0.1;port=3306;dbname=lxweb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `lx_home_notice` [ RunTime:0.000628s ]
[ SQL ] SELECT * FROM `lx_home_notice` WHERE ( `id` = 1 AND `status` = 1 ) AND `lx_home_notice`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_post` [ RunTime:0.000509s ]
[ SQL ] SELECT `post`.* FROM `lx_portal_post` `post` WHERE ( `post`.`id` = 6144 AND `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND ( `post`.`published_time` < 1776631531 and `post`.`published_time` > 0 ) ) AND `post`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_industry` [ RunTime:0.000396s ]
[ SQL ] SELECT `id`,`route_id`,`route_url`,`name` FROM `lx_portal_industry` WHERE ( `status` = 1 ) AND `lx_portal_industry`.`delete_time` IS NULL ORDER BY `list_order` ASC [ RunTime:0.000181s ]
[ SQL ] SHOW COLUMNS FROM `lx_recommend_product` [ RunTime:0.000382s ]
[ SQL ] SELECT * FROM `lx_recommend_product` WHERE ( `status` = 1 ) AND `lx_recommend_product`.`delete_time` IS NULL ORDER BY `list_order` ASC [ RunTime:0.000176s ]
[ SQL ] SHOW COLUMNS FROM `lx_post_view_status` [ RunTime:0.000333s ]
[ SQL ] SELECT id, article_id,sum(view_count) as sumcount FROM `lx_post_view_status` GROUP BY `article_id` ORDER BY `sumcount` DESC LIMIT 6 [ RunTime:0.000141s ]
[ SQL ] SHOW COLUMNS FROM `lx_rd_hot_tag` [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `lx_rd_hot_tag` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000154s ]
[ SQL ] SHOW COLUMNS FROM `lx_rd_search_words` [ RunTime:0.000327s ]
[ SQL ] SELECT `r`.*,`t`.`name` FROM `lx_rd_search_words` `r` INNER JOIN `lx_portal_tag` `t` ON `r`.`tag_id`=`t`.`id` WHERE `r`.`status` = 1 ORDER BY `r`.`list_order` ASC [ RunTime:0.000165s ]
[ SQL ] SHOW COLUMNS FROM `lx_tdk` [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `lx_tdk` WHERE ( `id` = 11014 ) AND `lx_tdk`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000342s ]
[ SQL ] SELECT `post`.* FROM `lx_portal_post` `post` WHERE ( `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`id` < 6144 AND ( `post`.`published_time` < 1776631531 and `post`.`published_time` > 0 ) ) AND `post`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
[ SQL ] SELECT `post`.* FROM `lx_portal_post` `post` WHERE ( `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`id` > 6144 AND ( `post`.`published_time` < 1776631531 and `post`.`published_time` > 0 ) ) AND `post`.`delete_time` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_tag` [ RunTime:0.000381s ]
[ SQL ] SELECT `t`.`id` FROM `lx_portal_tag` `t` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`t`.`id` WHERE ( `pivot`.`post_id` = 6144 ) AND `t`.`delete_time` IS NULL [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_category` [ RunTime:0.000399s ]
[ SQL ] SELECT `t`.`id` FROM `lx_portal_category` `t` INNER JOIN `lx_portal_category_post` `pivot` ON `pivot`.`category_id`=`t`.`id` WHERE ( `pivot`.`post_id` = 6144 ) AND `t`.`delete_time` IS NULL [ RunTime:0.009151s ]
[ SQL ] SELECT DISTINCT `p`.`id`,`p`.`banner_id`,`p`.`post_status`,`p`.`comment_status`,`p`.`is_top`,`p`.`recommended`,`p`.`post_hits`,`p`.`post_favorites`,`p`.`post_like`,`p`.`comment_count`,`p`.`published_time`,`p`.`protal_industry_id`,`p`.`use_tdk`,`p`.`tdk_id`,`p`.`create_time`,`p`.`thumbnail`,`p`.`post_excerpt`,`p`.`post_source`,`p`.`post_title` FROM `lx_portal_post` `p` RIGHT JOIN `lx_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE ( `cp`.`category_id` = 1 AND `cp`.`status` = 1 AND `p`.`post_status` = 1 AND `p`.`post_type` = 1 AND ( `p`.`published_time` < 1776631531 and `p`.`published_time` > 0 ) ) AND `p`.`delete_time` IS NULL GROUP BY `p`.`id` ORDER BY rand() LIMIT 3 [ RunTime:0.040625s ]
[ SQL ] SELECT DISTINCT `p`.`id`,`p`.`banner_id`,`p`.`post_status`,`p`.`comment_status`,`p`.`is_top`,`p`.`recommended`,`p`.`post_hits`,`p`.`post_favorites`,`p`.`post_like`,`p`.`comment_count`,`p`.`published_time`,`p`.`protal_industry_id`,`p`.`use_tdk`,`p`.`tdk_id`,`p`.`create_time`,`p`.`thumbnail`,`p`.`post_excerpt`,`p`.`post_source`,`p`.`post_title` FROM `lx_portal_post` `p` RIGHT JOIN `lx_portal_category_post` `cp` ON `cp`.`post_id`=`p`.`id` WHERE ( `cp`.`category_id` = 1 AND `cp`.`status` = 1 AND `p`.`post_status` = 1 AND `p`.`post_type` = 1 AND ( `p`.`published_time` < 1776631531 and `p`.`published_time` > 0 ) ) AND `p`.`delete_time` IS NULL GROUP BY `p`.`id` ORDER BY `p`.`published_time` DESC LIMIT 6 [ RunTime:0.000232s ]
[ SQL ] SELECT `post`.* FROM `lx_portal_post` `post` WHERE ( `post_type` = 1 AND `post_status` = 1 AND ( `post`.`published_time` < 1776631531 and `post`.`published_time` > 0 ) ) AND `post`.`delete_time` IS NULL ORDER BY rand() LIMIT 6 [ RunTime:0.201422s ]
[ SQL ] SHOW COLUMNS FROM `lx_comment` [ RunTime:0.000480s ]
[ SQL ] SELECT `id`,`full_name`,`content`,`create_time` FROM `lx_comment` WHERE ( `table_name` = 'portal_post' AND `object_id` = 6144 AND `status` = 1 ) AND `lx_comment`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `lx_portal_tag` WHERE ( `id` = 1 ) AND `lx_portal_tag`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `lx_portal_tag` WHERE ( `id` = 2 ) AND `lx_portal_tag`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000097s ]
[ SQL ] SELECT * FROM `lx_portal_tag` WHERE ( `id` = 3 ) AND `lx_portal_tag`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000088s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_category_post` [ RunTime:0.000283s ]
[ SQL ] SELECT `lx_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 `lx_portal_category` INNER JOIN `lx_portal_category_post` `pivot` ON `pivot`.`category_id`=`lx_portal_category`.`id` WHERE ( `pivot`.`post_id` = 6144 ) AND `lx_portal_category`.`delete_time` IS NULL [ RunTime:0.005698s ]
[ SQL ] SHOW COLUMNS FROM `lx_slide_item` [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `lx_slide_item` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SHOW COLUMNS FROM `lx_portal_tag_post` [ RunTime:0.000266s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6144 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000210s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 4122 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000280s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6120 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000233s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 3946 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000239s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6342 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000129s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6341 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000118s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6340 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000107s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6339 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000110s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6338 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000117s ]
[ SQL ] SELECT `lx_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `lx_portal_tag` INNER JOIN `lx_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`lx_portal_tag`.`id` WHERE ( `pivot`.`post_id` = 6337 ) AND `lx_portal_tag`.`delete_time` IS NULL [ RunTime:0.000130s ]
评论