[ DB ] CONNECT:[ UseTime:0.000286s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.000972s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.000526s ]
[ 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.001021s ]
[ 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.000215s ]
[ 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.000178s ]
[ 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.000216s ]
[ 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.000194s ]
[ 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.000180s ]
[ 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.000188s ]
[ 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.000186s ]
[ 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.000203s ]
[ 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.000187s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.000701s ]
[ 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.000165s ]
[ 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 'T%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000834s ]
[ 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 'T%' [ RunTime:0.000262s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000546s ]
[ 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.000177s ]
[ 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 'T%' LIMIT 1 [ RunTime:0.000234s ]
[ 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 'T%' LIMIT 1 [ RunTime:0.000217s ]
[ 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 'T%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000247s ]
[ 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 'T%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000234s ]
[ 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 'T%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.000205s ]
[ 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 'T%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000843s ]
[ 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 'T%' LIMIT 1 [ RunTime:0.000221s ]
[ 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 'T%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000355s ]