[ DB ] CONNECT:[ UseTime:0.000591s ] mysql:host=127.0.0.1;port=3306;dbname=bah_filter_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yoshop_wxapp` [ RunTime:0.000604s ]
[ SQL ] SELECT * FROM `yoshop_wxapp` WHERE `yoshop_wxapp`.`wxapp_id` = '10001' AND `wxapp_id` = 10001 LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_wxapp_page` [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `yoshop_wxapp_page` WHERE `yoshop_wxapp_page`.`wxapp_id` = '10001' AND `page_type` = 10 LIMIT 1 [ RunTime:0.000315s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_sku` [ RunTime:0.000428s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_category` [ RunTime:0.000349s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000405s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_goods` WHERE ( `yoshop_goods`.`wxapp_id` = '10001' AND `yoshop_goods`.`wxapp_id` = '10001' ) AND `is_delete` = 0 AND `goods_status` = 10 LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales,( SELECT MIN(goods_price) FROM `yoshop_goods_sku` WHERE `yoshop_goods_sku`.`wxapp_id` = '10001' AND ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_min_price,( SELECT MAX(goods_price) FROM `yoshop_goods_sku` WHERE `yoshop_goods_sku`.`wxapp_id` = '10001' AND ( `goods_id` = `yoshop_goods`.`goods_id` ) ) AS goods_max_price FROM `yoshop_goods` WHERE ( `yoshop_goods`.`wxapp_id` = '10001' AND `yoshop_goods`.`wxapp_id` = '10001' ) AND `is_delete` = 0 AND `goods_status` = 10 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,60 [ RunTime:0.000722s ]
[ SQL ] SELECT * FROM `yoshop_category` WHERE `yoshop_category`.`wxapp_id` = '10001' AND `category_id` IN (10004,10003,10002,10001) [ RunTime:0.000317s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_image` [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `yoshop_goods_image` WHERE `yoshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (10226,10225,10224,10001) ORDER BY `id` ASC [ RunTime:0.000318s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10252,10251,10243,10247) [ RunTime:0.000236s ]
[ SQL ] SELECT * FROM `yoshop_goods_sku` WHERE `yoshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` IN (10226,10225,10224,10001) ORDER BY `goods_sku_id` ASC [ RunTime:0.000286s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article_category` [ RunTime:0.000337s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000354s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 10002 AND `article_status` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SELECT * FROM `yoshop_article` WHERE ( `yoshop_article`.`wxapp_id` = '10001' AND `yoshop_article`.`wxapp_id` = '10001' ) AND `category_id` = 10002 AND `article_status` = 1 AND `is_delete` = 0 ORDER BY `article_sort` ASC,`create_time` DESC LIMIT 0,6 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10257) [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `yoshop_article_category` WHERE `yoshop_article_category`.`wxapp_id` = '10001' AND `category_id` IN (10002) [ RunTime:0.000726s ]
