[ DB ] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=6306;dbname=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sys_seo_config` [ RunTime:0.000608s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'Index/index' LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'all' LIMIT 1 [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'Index/index' LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `sys_seo_config` WHERE `webpage_type` = 'all' LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `sys_config` [ RunTime:0.000405s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'WAP_CUSTOM_TEMPLATE_IS_ENABLE' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000212s ]
[ SQL ] SHOW COLUMNS FROM `ns_coupon_type` [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `ns_coupon_type` WHERE `start_time` <= 1761524288 AND `end_time` >= 1761524288 AND `is_show` = 1 AND `shop_id` = 0 AND `term_of_validity_type` = 0 AND `status` = 0 ORDER BY `start_time` DESC [ RunTime:0.000425s ]
[ SQL ] SELECT * FROM `ns_coupon_type` WHERE `is_show` = 1 AND `shop_id` = 0 AND `term_of_validity_type` = 1 AND `status` = 0 ORDER BY `create_time` DESC [ RunTime:0.000219s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_games` [ RunTime:0.000589s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_promotion_games` WHERE `status` = 1 AND `is_index_show` = 1 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `ns_promotion_games` WHERE `status` = 1 AND `is_index_show` = 1 ORDER BY `game_id` DESC [ RunTime:0.000253s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_discount` [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `ns_promotion_discount` WHERE `status` = 1 ORDER BY `discount_id` DESC LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods` [ RunTime:0.000636s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng`.`shop_id`,`ng`.`category_id`,`ng`.`brand_id`,`ng`.`group_id_array`,`ng`.`promotion_type`,`ng`.`goods_type`,`ng`.`market_price`,`ng`.`price`,`ng`.`promotion_price`,`ng`.`cost_price`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`give_point`,`ng`.`is_member_discount`,`ng`.`shipping_fee`,`ng`.`shipping_fee_id`,`ng`.`stock`,`ng`.`max_buy`,`ng`.`min_stock_alarm`,`ng`.`clicks`,`ng`.`sales`,`ng`.`collects`,`ng`.`star`,`ng`.`evaluates`,`ng`.`shares`,`ng`.`province_id`,`ng`.`city_id`,`ng`.`picture`,`ng`.`keywords`,`ng`.`introduction`,`ng`.`description`,`ng`.`QRcode`,`ng`.`code`,`ng`.`is_stock_visible`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`is_pre_sale`,`ng`.`is_bill`,`ng`.`state`,`ng`.`sale_date`,`ng`.`create_time`,`ng`.`update_time`,`ng`.`sort`,`ng`.`real_sales`,`ngb`.`brand_name`,`ngb`.`brand_pic`,`ngc`.`category_id`,`ngc`.`category_name`,`sap`.`pic_cover_micro`,`sap`.`pic_cover_mid`,`sap`.`pic_cover_small`,`nss`.`shop_name`,`nss`.`shop_type`,`sap`.`pic_id`,`sap`.`upload_type`,`sap`.`domain`,`sap`.`bucket`,`npbg`.`bargain_id`,`npbg`.`status`,`npbg`.`start_time`,`npbg`.`end_time`,`npbg`.`fictitious_sales`,`npbg`.`sales`,`npbg`.`partake_number`,`npbg`.`bargain_min_rate`,`npbg`.`one_min_rate`,`npbg`.`one_max_rate`,`npbg`.`bargain_min_number` FROM `ns_goods` `ng` LEFT JOIN `ns_goods_category` `ngc` ON `ng`.`category_id`=`ngc`.`category_id` LEFT JOIN `ns_goods_brand` `ngb` ON `ng`.`brand_id`=`ngb`.`brand_id` LEFT JOIN `sys_album_picture` `sap` ON `ng`.`picture`=`sap`.`pic_id` LEFT JOIN `ns_shop` `nss` ON `ng`.`shop_id`=`nss`.`shop_id` INNER JOIN `ns_promotion_bargain_goods` `npbg` ON `ng`.`goods_id`=`npbg`.`goods_id` WHERE `status` = 1 AND `ng`.`state` = 1 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000751s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` LEFT JOIN `ns_goods_category` `ngc` ON `ng`.`category_id`=`ngc`.`category_id` LEFT JOIN `ns_goods_brand` `ngb` ON `ng`.`brand_id`=`ngb`.`brand_id` LEFT JOIN `sys_album_picture` `sap` ON `ng`.`picture`=`sap`.`pic_id` LEFT JOIN `ns_promotion_bargain_goods` `npbg` ON `ng`.`goods_id`=`npbg`.`goods_id` WHERE `status` = 1 LIMIT 1 [ RunTime:0.000253s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng`.`shop_id`,`ng`.`category_id`,`ng`.`brand_id`,`ng`.`group_id_array`,`ng`.`promotion_type`,`ng`.`goods_type`,`ng`.`market_price`,`ng`.`price`,`ng`.`promotion_price`,`ng`.`cost_price`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`give_point`,`ng`.`is_member_discount`,`ng`.`shipping_fee`,`ng`.`shipping_fee_id`,`ng`.`stock`,`ng`.`max_buy`,`ng`.`min_stock_alarm`,`ng`.`clicks`,`ng`.`sales`,`ng`.`collects`,`ng`.`star`,`ng`.`evaluates`,`ng`.`shares`,`ng`.`province_id`,`ng`.`city_id`,`ng`.`picture`,`ng`.`keywords`,`ng`.`introduction`,`ng`.`description`,`ng`.`QRcode`,`ng`.`code`,`ng`.`is_stock_visible`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`is_pre_sale`,`ng`.`is_bill`,`ng`.`state`,`ng`.`sale_date`,`ng`.`create_time`,`ng`.`update_time`,`ng`.`sort`,`ng`.`real_sales`,`ngb`.`brand_name`,`ngb`.`brand_pic`,`ngc`.`category_id`,`ngc`.`category_name`,`sap`.`pic_cover_micro`,`sap`.`pic_cover_mid`,`sap`.`pic_cover_small`,`nss`.`shop_name`,`nss`.`shop_type`,`sap`.`pic_id`,`sap`.`upload_type`,`sap`.`domain`,`sap`.`bucket`,`npg`.`tuangou_money`,`npg`.`tuangou_num`,`npg`.`tuangou_type`,`npg`.`tuangou_content_json`,`npg`.`is_open`,`npg`.`is_show` FROM `ns_goods` `ng` LEFT JOIN `ns_goods_category` `ngc` ON `ng`.`category_id`=`ngc`.`category_id` LEFT JOIN `ns_goods_brand` `ngb` ON `ng`.`brand_id`=`ngb`.`brand_id` LEFT JOIN `sys_album_picture` `sap` ON `ng`.`picture`=`sap`.`pic_id` LEFT JOIN `ns_shop` `nss` ON `ng`.`shop_id`=`nss`.`shop_id` LEFT JOIN `ns_promotion_tuangou` `npg` ON `ng`.`goods_id`=`npg`.`goods_id` WHERE `npg`.`is_open` = 1 AND `npg`.`is_show` = 1 AND `ng`.`state` = 1 ORDER BY `npg`.`create_time` DESC LIMIT 0,5 [ RunTime:0.000917s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_group` [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `ns_goods_group` WHERE `group_id` = 0 [ RunTime:0.000308s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_sku` [ RunTime:0.000431s ]
[ SQL ] SELECT * FROM `ns_goods_sku` WHERE `goods_id` = 428 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `ns_goods_group` WHERE `group_id` = 0 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `ns_goods_sku` WHERE `goods_id` = 429 [ RunTime:0.000194s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` LEFT JOIN `ns_goods_category` `ngc` ON `ng`.`category_id`=`ngc`.`category_id` LEFT JOIN `ns_goods_brand` `ngb` ON `ng`.`brand_id`=`ngb`.`brand_id` LEFT JOIN `sys_album_picture` `sap` ON `ng`.`picture`=`sap`.`pic_id` LEFT JOIN `ns_promotion_tuangou` `npg` ON `ng`.`goods_id`=`npg`.`goods_id` WHERE `npg`.`is_open` = 1 AND `npg`.`is_show` = 1 LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_new` = 1 ORDER BY `ng`.`sort` DESC,`ng`.`goods_id` DESC LIMIT 0,4 [ RunTime:0.000367s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_recommend` = 1 ORDER BY `ng`.`sort` DESC,`ng`.`goods_id` DESC LIMIT 0,4 [ RunTime:0.000232s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`state` = 1 AND `ng`.`is_hot` = 1 ORDER BY `ng`.`sort` DESC,`ng`.`goods_id` DESC LIMIT 0,4 [ RunTime:0.000273s ]
[ SQL ] SELECT `ng`.`price`,`ng`.`brand_id`,`ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`goods_id` IN ('383','400','401','403','404','405','406','407','408','409','410','411','412','413','414','415') AND `ng`.`state` = 1 ORDER BY `ng`.`sales` DESC,`ng`.`goods_id` DESC LIMIT 0,1000000 [ RunTime:0.000353s ]
