[ DB ] CONNECT:[ UseTime:0.000597s ] mysql:dbname=niushop_b2c;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sys_config` [ RunTime:0.000899s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `instance_id` = 0 AND `key` = 'MERCHANT_SERVICE' LIMIT 1 [ RunTime:0.000425s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'HOTKEY' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000310s ]
[ SQL ] SELECT `value` FROM `sys_config` WHERE `key` = 'DEFAULTKEY' AND `instance_id` = 0 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_category_block` [ RunTime:0.000769s ]
[ SQL ] SELECT * FROM `ns_goods_category_block` WHERE `shop_id` = 0 AND `is_show` = 1 ORDER BY sort asc [ RunTime:0.000422s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods` [ RunTime:0.001024s ]
[ 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`,`ng`.`is_open_presell` 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` WHERE `ng`.`category_id_1` = 5 AND `ng`.`state` = 1 ORDER BY ng.sort asc,ng.create_time desc LIMIT 0,10 [ RunTime:0.001257s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_group` [ RunTime:0.000644s ]
[ SQL ] SELECT * FROM `ns_goods_group` WHERE `group_id` = 0 [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_sku` [ RunTime:0.000601s ]
[ SQL ] SELECT * FROM `ns_goods_sku` WHERE `goods_id` = 5 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `ns_goods_group` WHERE `group_id` = 0 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `ns_goods_sku` WHERE `goods_id` = 4 [ RunTime:0.000389s ]
[ SQL ] SELECT * FROM `ns_goods_group` WHERE `group_id` = 0 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `ns_goods_sku` WHERE `goods_id` = 2 [ RunTime:0.000395s ]
[ 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` WHERE `ng`.`category_id_1` = 5 AND `ng`.`state` = 1 LIMIT 1 [ RunTime:0.000406s ]
[ SQL ] SHOW COLUMNS FROM `ns_promotion_discount_goods` [ RunTime:0.000644s ]
[ SQL ] SELECT `npdg`.`discount_goods_id`,`npdg`.`discount_id`,`npdg`.`start_time`,`npdg`.`end_time`,`npdg`.`goods_id`,`npdg`.`status`,`npdg`.`discount`,`npdg`.`goods_name`,`ng`.`picture`,`ng`.`category_id_1`,`ng`.`price`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`point_exchange_type`,`ng`.`point_exchange` FROM `ns_promotion_discount_goods` `npdg` INNER JOIN `ns_goods` `ng` ON `ng`.`goods_id`=`npdg`.`goods_id` WHERE `ng`.`state` = 1 AND `status` = 1 ORDER BY end_time LIMIT 0,5 [ RunTime:0.000387s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_promotion_discount_goods` `npdg` INNER JOIN `ns_goods` `ng` ON `ng`.`goods_id`=`npdg`.`goods_id` WHERE `ng`.`state` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000352s ]
咨询客服