[ DB ] CONNECT:[ UseTime:0.000436s ] mysql:host=127.0.0.1;dbname=fis_main;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_thread` [ RunTime:0.000693s ]
[ SQL ] SELECT `a`.*,m.id as member_id,`m`.`nickname`,`m`.`avatar`,`m`.`sex`,`m`.`vip`,`m`.`ident`,`mi`.`identification`,tc.title as column_title FROM `tb_thread` `a` LEFT JOIN `tb_member` `m` ON `m`.`id`=`a`.`member_id` LEFT JOIN `tb_member_ident` `mi` ON `mi`.`member_id`=`m`.`id` LEFT JOIN `tb_thread_column` `tc` ON `tc`.`id`=`a`.`cid` WHERE ( `a`.`id` = '4' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`top` DESC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000530s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_column` [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `tb_thread_column` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000259s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_column_member` [ RunTime:0.000463s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_thread_column_member` WHERE `column_id` = 13 AND `member_id` = -1 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_comment` [ RunTime:0.000414s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_thread_comment` `a` LEFT JOIN `tb_member` `m` ON `m`.`id`=`a`.`member_id` LEFT JOIN `tb_thread` `t` ON `t`.`id`=`a`.`thread_id` WHERE `a`.`thread_id` = '4' AND `t`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000266s ]
[ SQL ] SELECT `a`.*,m.id as member_id,`m`.`nickname`,`m`.`avatar`,`m`.`sex`,`t`.`title`,t.id as thread_id FROM `tb_thread_comment` `a` LEFT JOIN `tb_member` `m` ON `m`.`id`=`a`.`member_id` LEFT JOIN `tb_thread` `t` ON `t`.`id`=`a`.`thread_id` WHERE `a`.`thread_id` = '4' AND `t`.`delete_time` IS NULL ORDER BY `a`.`is_take` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.000292s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_thread_comment` `a` LEFT JOIN `tb_member` `m` ON `m`.`id`=`a`.`member_id` LEFT JOIN `tb_thread` `t` ON `t`.`id`=`a`.`thread_id` WHERE `a`.`thread_id` = '4' AND `t`.`delete_time` IS NULL ORDER BY `a`.`is_take` DESC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `tb_thread_column` [ RunTime:0.000253s ]
[ SQL ] SELECT `id`,`title`,`hits_comment` FROM `tb_thread` WHERE `create_time` > 1748784309 AND `delete_time` IS NULL ORDER BY `hits_comment` DESC LIMIT 10 [ RunTime:0.000292s ]
