[ DB ] CONNECT:[ UseTime:0.000266s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.001029s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.000762s ]
[ 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.000226s ]
[ 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.000639s ]
[ 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.000176s ]
[ 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.000168s ]
[ 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.000162s ]
[ 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.000173s ]
[ 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.000167s ]
[ 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.000164s ]
[ 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.000213s ]
[ 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.000180s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.000761s ]
[ 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.000197s ]
[ 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 'D%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000224s ]
[ 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 'D%' [ RunTime:0.000917s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000551s ]
[ 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.000231s ]
[ 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 'D%' LIMIT 1 [ RunTime:0.000160s ]
[ 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 'D%' LIMIT 1 [ RunTime:0.000160s ]
[ 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 'D%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000191s ]
[ 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 'D%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000196s ]
[ 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 'D%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.000209s ]
[ 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 'D%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000184s ]
[ 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 'D%' LIMIT 1 [ RunTime:0.000736s ]
[ 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 'D%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000247s ]