[ DB ] CONNECT:[ UseTime:0.000322s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.000904s ]
[ 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.000343s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.000584s ]
[ 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.000146s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000633s ]
[ 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.000277s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.001070s ]
[ 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.000212s ]
[ 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.000450s ]
[ 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.000181s ]
[ 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.000215s ]
[ 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.000219s ]
[ 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.000269s ]
[ 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.000198s ]
[ 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.000207s ]
[ 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.000191s ]
[ 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.000191s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page` [ RunTime:0.000740s ]
[ SQL ] SELECT * FROM `fwshop_page` WHERE `fwshop_page`.`wxapp_id` = '10001' AND `page_id` = 6 LIMIT 1 [ RunTime:0.000365s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_style` [ RunTime:0.000517s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_block` [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `fwshop_page_block` WHERE `fwshop_page_block`.`wxapp_id` = '10001' AND `page_id` = 6 AND `status` = 1 ORDER BY `sort` ASC,`block_id` ASC [ RunTime:0.000525s ]
[ SQL ] SELECT * FROM `fwshop_page_style` WHERE `fwshop_page_style`.`wxapp_id` = '10001' AND `style_id` IN (40,42,41) [ RunTime:0.000400s ]
[ 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.001252s ]
[ 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.000426s ]
[ 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.000300s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,754,756,760) [ RunTime:0.000279s ]
[ 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.000227s ]
[ 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.000206s ]
[ 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.000199s ]
[ 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.000191s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_user_fav` [ RunTime:0.000683s ]
[ 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.000158s ]
[ 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.000139s ]
[ 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.000132s ]
[ 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.000125s ]
返回
SHOP NOW 
了解更多 
