[ DB ] CONNECT:[ UseTime:0.000304s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.000878s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.000604s ]
[ 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.000268s ]
[ 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.000337s ]
[ 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.000324s ]
[ 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.000327s ]
[ 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.000308s ]
[ 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.000252s ]
[ 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.000312s ]
[ 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.000305s ]
[ 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.000350s ]
[ 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.000298s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page` [ RunTime:0.000794s ]
[ SQL ] SELECT * FROM `fwshop_page` WHERE `fwshop_page`.`wxapp_id` = '10001' AND `page_id` = 5 LIMIT 1 [ RunTime:0.000383s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_style` [ RunTime:0.000656s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_block` [ RunTime:0.000534s ]
[ 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.000662s ]
[ SQL ] SELECT * FROM `fwshop_page_style` WHERE `fwshop_page_style`.`wxapp_id` = '10001' AND `style_id` IN (38,44,37) [ RunTime:0.000630s ]
[ 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.000257s ]
[ 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.000612s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000857s ]
[ 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.000316s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000573s ]
[ 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.000298s ]
[ 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.000249s ]
[ 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.000362s ]
[ 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.000308s ]
[ 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.000341s ]
[ 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.000366s ]
[ 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.000376s ]
[ 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.000400s ]
[ 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.000407s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_user_fav` [ RunTime:0.001212s ]
[ 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.001138s ]
[ 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.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` = 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.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` = 104 LIMIT 1 [ RunTime:0.000196s ]
[ 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.000816s ]
[ 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.000224s ]
[ 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.000233s ]