[ DB ] CONNECT:[ UseTime:0.003697s ] mysql:host=127.0.0.1;port=3306;dbname=bah_filter_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yoshop_wxapp` [ RunTime:0.000866s ]
[ SQL ] SELECT * FROM `yoshop_wxapp` WHERE `yoshop_wxapp`.`wxapp_id` = '10001' AND `wxapp_id` = 10001 LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_wxapp_page` [ RunTime:0.000724s ]
[ SQL ] SELECT * FROM `yoshop_wxapp_page` WHERE `yoshop_wxapp_page`.`wxapp_id` = '10001' AND `page_type` = 10 LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_sku` [ RunTime:0.000706s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_category` [ RunTime:0.001080s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods` [ RunTime:0.000726s ]
[ 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.000570s ]
[ 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.000946s ]
[ SQL ] SELECT * FROM `yoshop_category` WHERE `yoshop_category`.`wxapp_id` = '10001' AND `category_id` IN (10004,10003,10002,10001) [ RunTime:0.000373s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_goods_image` [ RunTime:0.000597s ]
[ 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.000349s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_upload_file` [ RunTime:0.000604s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10252,10251,10243,10247) [ RunTime:0.000343s ]
[ 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.000449s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article_category` [ RunTime:0.000629s ]
[ SQL ] SHOW COLUMNS FROM `yoshop_article` [ RunTime:0.000487s ]
[ 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.000225s ]
[ 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.000243s ]
[ SQL ] SELECT * FROM `yoshop_upload_file` WHERE `yoshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (10257) [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `yoshop_article_category` WHERE `yoshop_article_category`.`wxapp_id` = '10001' AND `category_id` IN (10002) [ RunTime:0.000179s ]
