[ DB ] CONNECT:[ UseTime:0.000372s ] mysql:host=localhost;port=3306;dbname=haihedb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.001198s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.001422s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 105 ORDER BY `goods_sku_id` ASC [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 104 ORDER BY `goods_sku_id` ASC [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 103 ORDER BY `goods_sku_id` ASC [ RunTime:0.000325s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 102 ORDER BY `goods_sku_id` ASC [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 101 ORDER BY `goods_sku_id` ASC [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 100 ORDER BY `goods_sku_id` ASC [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 99 ORDER BY `goods_sku_id` ASC [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 98 ORDER BY `goods_sku_id` ASC [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 97 ORDER BY `goods_sku_id` ASC [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `fwshop_goods_sku` WHERE `fwshop_goods_sku`.`wxapp_id` = '10001' AND `goods_id` = 96 ORDER BY `goods_sku_id` ASC [ RunTime:0.000295s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.000799s ]
[ SQL ] SELECT * FROM `fwshop_category` WHERE `fwshop_category`.`wxapp_id` = '10001' AND `parent_id` = 0 AND `status` = 1 ORDER BY `sort` ASC,`category_id` ASC [ RunTime:0.000213s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000468s ]
[ SQL ] SELECT DISTINCT `brand_id` FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' [ RunTime:0.000276s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000583s ]
[ SQL ] SELECT * FROM `fwshop_goods_attr` WHERE `fwshop_goods_attr`.`wxapp_id` = '10001' AND `category_id` IN ('') AND `status` = 1 ORDER BY `sort` ASC,`attr_id` ASC [ RunTime:0.000970s ]
[ SQL ] SELECT DISTINCT MIN(goods_price) AS tp_min FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' LIMIT 1 [ RunTime:0.000377s ]
[ SQL ] SELECT DISTINCT MAX(goods_price) AS tp_max FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' LIMIT 1 [ RunTime:0.000444s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000231s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.001384s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000264s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 AND `goods_name` LIKE 'Y%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000438s ]