[ DB ] CONNECT:[ UseTime:0.000313s ] mysql:host=localhost;port=3306;dbname=szhhkej;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fwshop_goods` [ RunTime:0.001677s ]
[ 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.000351s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_image` [ RunTime:0.001095s ]
[ 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.000202s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_upload_file` [ RunTime:0.000634s ]
[ 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.000169s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_goods_sku` [ RunTime:0.001310s ]
[ 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.000193s ]
[ 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.000200s ]
[ 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.000240s ]
[ 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.000254s ]
[ 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.000210s ]
[ 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.000210s ]
[ 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.000183s ]
[ 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.000204s ]
[ 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.000180s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page` [ RunTime:0.000721s ]
[ SQL ] SELECT * FROM `fwshop_page` WHERE `fwshop_page`.`wxapp_id` = '10001' AND `page_id` = 4 LIMIT 1 [ RunTime:0.000413s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_style` [ RunTime:0.000554s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_page_block` [ RunTime:0.001545s ]
[ 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.000517s ]
[ SQL ] SELECT * FROM `fwshop_page_style` WHERE `fwshop_page_style`.`wxapp_id` = '10001' AND `style_id` IN (40,35,37) [ RunTime:0.000488s ]
[ 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.000199s ]
[ 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.000222s ]
[ 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.000161s ]
[ SQL ] SELECT * FROM `fwshop_upload_file` WHERE `fwshop_upload_file`.`wxapp_id` = '10001' AND `file_id` IN (752,754,756,760) [ RunTime:0.000177s ]
[ 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.000175s ]
[ 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` = 97 ORDER BY `goods_sku_id` ASC [ RunTime:0.000175s ]
[ 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.000188s ]
[ SQL ] SHOW COLUMNS FROM `fwshop_user_fav` [ RunTime:0.000650s ]
[ 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.000163s ]
[ 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.000138s ]
[ 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.000166s ]
[ 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.000117s ]