[ DB ] CONNECT:[ UseTime:0.000257s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_goods` [ RunTime:0.000830s ]
[ 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.000199s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_goods_class` [ RunTime:0.000562s ]
[ SQL ] SELECT `id`,`class_name` FROM `wt_site_goods_class` WHERE `pclass_id` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000148s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_pic` [ RunTime:0.000547s ]
[ SQL ] SELECT `path`,`link` FROM `wt_site_pic` WHERE `type` = 2 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000154s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_goods_globalfeature` [ RunTime:0.000517s ]
[ SQL ] SELECT `featureName`,`id` FROM `wt_site_goods_globalfeature` WHERE `pid` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000137s ]
[ SQL ] SELECT a.id as fid,a.featureName as fname,b.featureName as zname,`b`.`id` FROM wt_site_goods_globalfeature a LEFT JOIN `wt_site_goods_globalfeature` `b` ON `b`.`pid`=`a`.`id` WHERE `a`.`site_id` = '1047' AND `b`.`pid` > '0' ORDER BY `b`.`sort` DESC [ RunTime:0.000145s ]
[ SQL ] SELECT `class_name`,`id` FROM `wt_site_goods_class` WHERE `pclass_id` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000154s ]
[ SQL ] SELECT `class_name`,`id` FROM `wt_site_goods_class` WHERE `pclass_id` < 1 AND `site_id` = 1047 ORDER BY `sort` DESC [ RunTime:0.000145s ]
[ SQL ] SELECT a.class_name as fname,a.id as fid,`a`.`sort`,b.class_name as zname,`b`.`id` FROM wt_site_goods_class a LEFT JOIN `wt_site_goods_class` `b` ON `b`.`pclass_id`=`a`.`id` WHERE `a`.`site_id` = '1047' AND `b`.`pclass_id` > '0' ORDER BY `b`.`sort` DESC [ RunTime:0.000149s ]
[ DB ] CONNECT:[ UseTime:0.000176s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SELECT `class_name`,`pclass_id`,`id` FROM `wt_site_goods_class` WHERE `id` = 468 AND `pclass_id` = 0 [ RunTime:0.000191s ]
[ DB ] CONNECT:[ UseTime:0.000174s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SELECT `class_name`,`pclass_id`,`id` FROM `wt_site_goods_class` WHERE `id` = 468 LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT a.class_name as fname,a.id as fid,`a`.`sort`,b.class_name as zname,`b`.`id` FROM wt_site_goods_class a LEFT JOIN `wt_site_goods_class` `b` ON `b`.`pclass_id`=`a`.`id` WHERE `a`.`site_id` = '1047' AND `b`.`pclass_id` = '458' ORDER BY `b`.`sort` DESC [ RunTime:0.000158s ]
[ DB ] CONNECT:[ UseTime:0.000186s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SELECT `class_name`,`id` FROM `wt_site_goods_class` WHERE `id` = 458 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `wt_site_goods` `a` LEFT JOIN `wt_site_goods_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_goods_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '458' AND `ac`.`id` = '468' LIMIT 1 [ RunTime:0.004432s ]
[ SQL ] SELECT `a`.`id`,`a`.`goods_name`,`a`.`goods_title`,`a`.`thumb`,`a`.`add_time`,`a`.`price` FROM `wt_site_goods` `a` LEFT JOIN `wt_site_goods_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_goods_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '458' AND `ac`.`id` = '468' ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,12 [ RunTime:0.005130s ]
[ SQL ] SELECT `c`.`id`,c.goods_name as name,c.thumb as thumb,`c`.`price` FROM wt_site_goods_class a LEFT JOIN `wt_site_goods` `c` ON `c`.`class_id`=a.id and c.status=1 WHERE `a`.`site_id` = '1047' AND `a`.`id` = '468' ORDER BY `c`.`id` DESC LIMIT 10 [ RunTime:0.005986s ]
