[ DB ] CONNECT:[ UseTime:0.000354s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_question` [ RunTime:0.000675s ]
[ 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` = '467' LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] UPDATE `wt_site_question` SET `hit` = hit+1 WHERE `site_id` = 1047 AND `id` = 467 [ RunTime:0.000233s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_answer` [ RunTime:0.000578s ]
[ 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` = '467' AND `a`.`status` = '1' LIMIT 1 [ RunTime:0.000139s ]
[ 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` = '467' AND `a`.`status` = '1' ORDER BY `a`.`id` DESC LIMIT 0,5 [ RunTime:0.000129s ]
[ 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` = '467' AND `a`.`status` = '2' LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT class_id as q_id FROM `wt_site_question` WHERE `site_id` = 1047 AND `id` = 467 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 16 AND `status` = 1 ORDER BY `hit` DESC LIMIT 0,6 [ RunTime:0.000333s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 16 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000300s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_art` [ RunTime:0.000722s ]
[ SQL ] SELECT `a`.`id`,`a`.`art_name` FROM `wt_site_art` `a` LEFT JOIN `wt_site_art_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_art_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '609' ORDER BY `a`.`hit` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.061698s ]
[ SQL ] SELECT `a`.`id`,`a`.`art_name` FROM `wt_site_art` `a` LEFT JOIN `wt_site_art_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_art_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '609' ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.004342s ]
