[ DB ] CONNECT:[ UseTime:0.000428s ] mysql:host=localhost;port=3306;dbname=hhdbdb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.001168s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.002316s ]
[ 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.000982s ]
[ 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.000439s ]
[ 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.000465s ]
[ 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.000445s ]
[ 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.000331s ]
[ 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.000394s ]
[ 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.000403s ]
[ 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.000382s ]
[ 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.000297s ]
[ 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.000544s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page` [ RunTime:0.000870s ]
[ SQL ] SELECT * FROM `fwshop_page` WHERE `fwshop_page`.`wxapp_id` = '10001' AND `page_id` = 4 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_style` [ RunTime:0.000771s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_block` [ RunTime:0.000679s ]
[ SQL ] SELECT * FROM `fwshop_page_block` WHERE `fwshop_page_block`.`wxapp_id` = '10001' AND `page_id` = 4 AND `status` = 1 ORDER BY `sort` ASC,`block_id` ASC [ RunTime:0.000807s ]
[ SQL ] SELECT * FROM `fwshop_page_style` WHERE `fwshop_page_style`.`wxapp_id` = '10001' AND `style_id` IN (40,35,37) [ RunTime:0.000730s ]
[ 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.000710s ]
[ 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,4 [ RunTime:0.000714s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000893s ]
[ SQL ] SELECT * FROM `fwshop_goods_image` WHERE `fwshop_goods_image`.`wxapp_id` = '10001' AND `goods_id` IN (101,105,97,103) ORDER BY `id` ASC [ RunTime:0.000299s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,754,756,760) [ RunTime:0.000316s ]
[ 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.000217s ]
[ 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.000312s ]
[ 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.000389s ]
[ 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.000466s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_user_fav` [ RunTime:0.001075s ]
[ 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.000532s ]
[ 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.000581s ]
[ 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.000342s ]
[ 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.000351s ]