[ DB ] CONNECT:[ UseTime:0.000448s ] mysql:host=127.0.0.1;dbname=fis_main;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_thread` [ RunTime:0.000645s ]
[ 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` = '1' ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`top` DESC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_column` [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `tb_thread_column` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_column_member` [ RunTime:0.000494s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_thread_column_member` WHERE `column_id` = 12 AND `member_id` = -1 LIMIT 1 [ RunTime:0.000942s ]
[ SQL ] SHOW COLUMNS FROM `tb_thread_comment` [ RunTime:0.000431s ]
[ 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` = '1' AND `t`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000270s ]
[ 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` = '1' AND `t`.`delete_time` IS NULL ORDER BY `a`.`is_take` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.000290s ]
[ 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` = '1' AND `t`.`delete_time` IS NULL ORDER BY `a`.`is_take` DESC,`a`.`id` DESC LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `tb_thread_column` [ RunTime:0.000326s ]
[ SQL ] SELECT `id`,`title`,`hits_comment` FROM `tb_thread` WHERE `create_time` > 1748781521 AND `delete_time` IS NULL ORDER BY `hits_comment` DESC LIMIT 10 [ RunTime:0.000292s ]
