[ DB ] CONNECT:[ UseTime:0.000371s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_goods` [ RunTime:0.000823s ]
[ 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.000188s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_goods_class` [ RunTime:0.000487s ]
[ SQL ] SELECT `id`,`class_name` FROM `wt_site_goods_class` WHERE `pclass_id` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000138s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_question` [ RunTime:0.000420s ]
[ 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` = '244' LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] UPDATE `wt_site_question` SET `hit` = hit+1 WHERE `site_id` = 1047 AND `id` = 244 [ RunTime:0.000254s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_answer` [ RunTime:0.000519s ]
[ 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` = '244' AND `a`.`status` = '1' LIMIT 1 [ RunTime:0.000161s ]
[ 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` = '244' AND `a`.`status` = '1' ORDER BY `a`.`id` DESC LIMIT 0,5 [ RunTime:0.000146s ]
[ 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` = '244' AND `a`.`status` = '2' LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT class_id as q_id FROM `wt_site_question` WHERE `site_id` = 1047 AND `id` = 244 LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 17 AND `status` = 1 ORDER BY `hit` DESC LIMIT 0,6 [ RunTime:0.000331s ]
[ SQL ] SELECT `id`,`question` FROM `wt_site_question` WHERE `site_id` = 1047 AND `class_id` = 17 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000297s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_art` [ RunTime:0.000537s ]
[ 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` = '608' ORDER BY `a`.`hit` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.062067s ]
[ 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` = '608' ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.016159s ]
