[ DB ] CONNECT:[ UseTime:0.000308s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.000863s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `goods_status` = 10 AND `is_delete` = 0 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 10 [ RunTime:0.000389s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `fwshop_goods_image` WHERE `fwshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (105,104,103,102,101,100,99,98,97,96) ORDER BY `id` ASC [ RunTime:0.000155s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,753,754,755,756,758,757,759,760,761) [ RunTime:0.000193s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.001437s ]
[ 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.000174s ]
[ 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.000482s ]
[ 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.000183s ]
[ 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.000187s ]
[ 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.000203s ]
[ 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.000192s ]
[ 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.000182s ]
[ 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.000222s ]
[ 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.000180s ]
[ 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.000174s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_category` [ RunTime:0.000690s ]
[ 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.000190s ]
[ 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 'H%' AND (`category_id` LIKE '%,55,%') LIMIT 1 [ RunTime:0.000339s ]
[ 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 'H%' [ RunTime:0.000263s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_attr` [ RunTime:0.000541s ]
[ 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.000137s ]
[ 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 'H%' LIMIT 1 [ RunTime:0.000224s ]
[ 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 'H%' LIMIT 1 [ RunTime:0.000241s ]
[ 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 'H%' AND `discount` BETWEEN 0.001 AND 24.999 LIMIT 1 [ RunTime:0.000238s ]
[ 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 'H%' AND `discount` BETWEEN 25 AND 50 LIMIT 1 [ RunTime:0.000226s ]
[ 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 'H%' AND `discount` BETWEEN 50.001 AND 75 LIMIT 1 [ RunTime:0.000711s ]
[ 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 'H%' AND `discount` BETWEEN 75.001 AND 99.99 LIMIT 1 [ RunTime:0.000333s ]
[ 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 'H%' LIMIT 1 [ RunTime:0.000230s ]
[ 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 'H%' ORDER BY `goods_sort`,`goods_id` DESC LIMIT 0,12 [ RunTime:0.000352s ]