[ DB ] CONNECT:[ UseTime:0.000341s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_question` [ RunTime:0.000627s ]
[ SQL ] SELECT `a`.`id`,`a`.`uid`,`a`.`question`,`a`.`create_time`,`a`.`description`,`b`.`name`,c.id as cid,`c`.`class_name`,`b`.`wxAvatar` FROM wt_site_question as a LEFT JOIN `wt_site_member` `b` ON `a`.`uid`=`b`.`id` LEFT JOIN `wt_site_question_class` `c` ON `a`.`class_id`=`c`.`id` WHERE `a`.`site_id` = '1047' AND `a`.`status` = '1' AND `a`.`id` = '509' LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] UPDATE `wt_site_question` SET `hit` = hit+1 WHERE `site_id` = 1047 AND `id` = 509 [ RunTime:0.000265s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_answer` [ RunTime:0.000465s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM wt_site_answer as a LEFT JOIN `wt_site_member` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`site_id` = '1047' AND `a`.`question_id` = '509' AND `a`.`status` = '1' LIMIT 1 [ RunTime:0.000746s ]
[ SQL ] SELECT `a`.`id`,`a`.`answer`,`a`.`create_time`,`b`.`name`,`b`.`wxAvatar` FROM wt_site_answer as a LEFT JOIN `wt_site_member` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`site_id` = '1047' AND `a`.`question_id` = '509' AND `a`.`status` = '1' ORDER BY `a`.`id` DESC LIMIT 0,5 [ RunTime:0.001216s ]
[ SQL ] SELECT `a`.`id`,`a`.`answer`,`a`.`create_time`,`b`.`name`,`b`.`wxAvatar` FROM wt_site_answer as a LEFT JOIN `wt_site_member` `b` ON `a`.`uid`=`b`.`id` WHERE `a`.`site_id` = '1047' AND `a`.`question_id` = '509' AND `a`.`status` = '2' LIMIT 1 [ RunTime:0.000557s ]
[ SQL ] SELECT class_id as q_id FROM `wt_site_question` WHERE `site_id` = 1047 AND `id` = 509 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 20 AND `status` = 1 ORDER BY `hit` DESC LIMIT 0,6 [ RunTime:0.000290s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 20 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000291s ]