[ DB ] CONNECT:[ UseTime:0.000324s ] mysql:host=localhost;port=3306;dbname=haihedb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.001045s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.000887s ]
[ 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.001257s ]
[ 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.000369s ]
[ 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.000336s ]
[ 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.000440s ]
[ 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.000424s ]
[ 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.000332s ]
[ 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.000302s ]
[ 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.000368s ]
[ 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.000309s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page` [ RunTime:0.000989s ]
[ SQL ] SELECT * FROM `fwshop_page` WHERE `fwshop_page`.`wxapp_id` = '10001' AND `page_id` = 5 LIMIT 1 [ RunTime:0.000644s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_style` [ RunTime:0.000636s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_block` [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `fwshop_page_block` WHERE `fwshop_page_block`.`wxapp_id` = '10001' AND `page_id` = 5 AND `status` = 1 ORDER BY `sort` ASC,`block_id` ASC [ RunTime:0.000694s ]
[ SQL ] SELECT * FROM `fwshop_page_style` WHERE `fwshop_page_style`.`wxapp_id` = '10001' AND `style_id` IN (38,44,37) [ RunTime:0.000572s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_goods` WHERE `fwshop_goods`.`wxapp_id` = '10001' AND `is_delete` = 0 AND `goods_status` = 10 LIMIT 1 [ RunTime:0.000530s ]
[ 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 ORDER BY `goods_sales` DESC LIMIT 0,8 [ RunTime:0.000747s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000824s ]
[ SQL ] SELECT * FROM `fwshop_goods_image` WHERE `fwshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (101,105,97,103,104,96,98,99) ORDER BY `id` ASC [ RunTime:0.000342s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000653s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,753,754,756,758,759,760,761) [ RunTime:0.000451s ]
[ 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.000245s ]
[ 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.000424s ]
[ 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.000356s ]
[ 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.000406s ]
[ 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.000325s ]
[ 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.000305s ]
[ 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.000448s ]
[ 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.000364s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_user_fav` [ RunTime:0.001047s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 101 LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 105 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 97 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 103 LIMIT 1 [ RunTime:0.000214s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 104 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 96 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 98 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fwshop_user_fav` WHERE `fwshop_user_fav`.`wxapp_id` = '10001' AND `user_id` IS NULL AND `goods_id` = 99 LIMIT 1 [ RunTime:0.000506s ]