[ DB ] CONNECT:[ UseTime:0.000325s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_question` [ RunTime:0.000584s ]
[ 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` = '491' LIMIT 1 [ RunTime:0.000368s ]
[ SQL ] UPDATE `wt_site_question` SET `hit` = hit+1 WHERE `site_id` = 1047 AND `id` = 491 [ RunTime:0.000422s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_answer` [ RunTime:0.000444s ]
[ 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` = '491' AND `a`.`status` = '1' LIMIT 1 [ RunTime:0.000155s ]
[ 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` = '491' AND `a`.`status` = '1' ORDER BY `a`.`id` DESC LIMIT 0,5 [ RunTime:0.000152s ]
[ 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` = '491' AND `a`.`status` = '2' LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT class_id as q_id FROM `wt_site_question` WHERE `site_id` = 1047 AND `id` = 491 LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 15 AND `status` = 1 ORDER BY `hit` DESC LIMIT 0,6 [ RunTime:0.000295s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 15 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000219s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_art` [ RunTime:0.000479s ]
[ 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` = '607' ORDER BY `a`.`hit` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.065731s ]
[ 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` = '607' ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.000700s ]
