[ DB ] CONNECT:[ UseTime:0.000327s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_goods` [ RunTime:0.000848s ]
[ SQL ] SELECT `id`,`goods_name` FROM `wt_site_goods` WHERE `goods_name` IN ('小儿感冒推拿疗法视频') AND `status` = 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000195s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_goods_class` [ RunTime:0.000463s ]
[ SQL ] SELECT `id`,`class_name` FROM `wt_site_goods_class` WHERE `pclass_id` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000128s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_question` [ RunTime:0.000410s ]
[ 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` = '513' LIMIT 1 [ RunTime:0.000406s ]
[ SQL ] UPDATE `wt_site_question` SET `hit` = hit+1 WHERE `site_id` = 1047 AND `id` = 513 [ RunTime:0.000499s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_answer` [ RunTime:0.000461s ]
[ 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` = '513' AND `a`.`status` = '1' LIMIT 1 [ 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` = '513' 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` = '513' AND `a`.`status` = '2' LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SELECT class_id as q_id FROM `wt_site_question` WHERE `site_id` = 1047 AND `id` = 513 LIMIT 1 [ RunTime:0.000151s ]
[ 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.000315s ]
[ 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.000260s ]
