MySQL查询“某个商品平均价格、每个商品平均价格“SQL语句写法

今天,一位群友有一个需求,如何求出这几个商家同一件产品的平均价格?Mysql语句又如何写呢?如下图:mysql语句如何求出这几个商家同一件产品的平均价格

 

一、Mysql查询 某个商品平均价格

查询商品ID=348且门店ID为42,43的平均价格

 

mysql5.5低版本SQL语句:

SELECT goods_id,goods_name,AVG(store_price) FROM `ns_storegoods_price` WHERE `goods_id`=349 AND `pic_id` in(41,42) group by `goods_id`;

 

mysql5.7以上版本SQL语句:

SELECT AVG(store_price) FROM `ns_storegoods_price` WHERE `goods_id`=349 AND `pic_id` in(41,42);

 

二、Mysql查询 各个商品平均价格

 

mysql5.5低版本SQL语句:

SELECT `goods_id`,`goods_name`,AVG(store_price) FROM `ns_storegoods_price` WHERE `pic_id` in(41,42) GROUP by `goods_id`;

 

mysql5.7以上版本SQL语句:

SELECT `goods_id`,AVG(store_price) FROM `ns_storegoods_price` WHERE `pic_id` in(41,42) GROUP by `goods_id`;

 

最后:

再给大家一份测试数据的sql语句,如下:

/*
Navicat MySQL Data Transfer

Target Server Type    : MYSQL
Target Server Version : 50562
File Encoding         : 65001
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ns_storegoods_price
-- ----------------------------
DROP TABLE IF EXISTS `ns_storegoods_price`;
CREATE TABLE `ns_storegoods_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pic_id` int(11) NOT NULL COMMENT '自提点门店ID',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_img` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `goods_spec` varchar(255) DEFAULT NULL COMMENT '商品规格',
  `platform_price` decimal(10,2) NOT NULL COMMENT '平台定价',
  `status` int(2) NOT NULL DEFAULT '1' COMMENT '上架状态  0-未上架   1-上架',
  `store_price` decimal(10,2) NOT NULL COMMENT '门店定价',
  `addtime` int(11) NOT NULL COMMENT '添加或修改时间',
  `updattime` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8 COMMENT='生鲜店铺价格汇总表(生鲜上架)';

-- ----------------------------
-- Records of ns_storegoods_price
-- ----------------------------
INSERT INTO `ns_storegoods_price` VALUES ('11', '41', '348', '干云耳 100g/份', null, '500g', '11.00', '1', '19.00', '1598869938', null);
INSERT INTO `ns_storegoods_price` VALUES ('12', '41', '349', '干辣椒粉 100g/份', null, '500g', '19.00', '1', '20.00', '1598869938', null);
INSERT INTO `ns_storegoods_price` VALUES ('13', '42', '349', '白蘑菇500g正负20g', '/upload/goods/20200506/d65f8c7260a789e44e32834c0e7fef7d.jpg', '500g', '5.00', '1', '8.00', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('14', '42', '348', '白玉菇  200g正负20g', '/upload/goods/20200506/b18313017af1d033ac84f37e29f9f678.jpg', '500g', '4.00', '1', '21.00', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('15', '42', '28', '新鲜菠菜350g/份  正负20g', '/upload/goods/20200506/08c4ad1175e3c61631a093d266429e7d.jpg', '500g', '3.00', '1', '6.28', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('16', '42', '30', '新鲜菜藕 700g/份  正负50g', '/upload/goods/20200506/1efed0ef7977f2d640c12ca5a6ad4109.jpg', '500g', '6.00', '1', '4.98', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('17', '42', '33', '精品大红椒500g正负50g', '/upload/goods/20200506/e62931a0c5584a0727d6c9c44004ed76.jpg', '500g', '5.00', '1', '7.50', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('18', '42', '35', '本地青椒500g  正负50g', '/upload/goods/20200506/b4289bb1825acdb371f21af0d768b81f.jpg', '500g', '3.00', '1', '4.50', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('19', '42', '36', '红皮大蒜叶   300g/份正负20g', '/upload/goods/20200506/f86cdbb1892ddcee6ab610b64fe3cf70.jpg', '500g', '2.00', '1', '7.80', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('20', '42', '37', '大蒜籽  500g正负50g', '/upload/goods/20200506/f0fdce512fec2977d3804e407afd5324.jpg', '500g', '2.00', '1', '4.28', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('21', '42', '38', '云南精品大土豆1000g正负50g', '/upload/goods/20200506/1a9367a41ebb63026a02b1137a9174f0.jpg', '500g', '3.00', '1', '1.68', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('22', '42', '39', '本地带泥胡萝卜500g正负50g', '/upload/goods/20200506/e72e628a573032b4c3771413affdb069.jpg', '500g', '2.00', '1', '2.50', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('23', '42', '42', '高山娃娃菜500g正负50g', '/upload/goods/20200506/2d5119f8541758a78ceb19f9f603679e.jpg', '500g', '3.00', '1', '4.28', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('24', '42', '43', '广心菜  400g正负20g', '/upload/goods/20200506/5578b5a8590af410889b8adf9d061a97.jpg', '500g', '4.00', '1', '4.98', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('25', '42', '45', '精品荷兰豆350g/份  正负20g', '/upload/goods/20200506/937de2d683d5c7dfbb10bd549228185c.jpg', '500g', '4.00', '1', '10.80', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('26', '42', '47', '新鲜红薯尖500g正负50g', '/upload/goods/20200506/9a912504a50293bc198d756d6e472f0b.jpg', '500g', '3.00', '1', '3.00', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('27', '42', '48', '红苋菜  500g/份  正负50g', '/upload/goods/20200506/bd628edaf29679f2aed82d74d2512eb0.jpg', '500g', '4.00', '1', '4.00', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('28', '42', '50', '胡萝卜  500g正负50g', '/upload/goods/20200506/296fccea75d2d6ba65b487a967a135db.jpg', '500g', '2.00', '1', '2.50', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('29', '42', '51', '精品有机花菜  400g正负20g', '/upload/goods/20200506/2304fae6d906ab17d02fe203d1878067.jpg', '500g', '4.00', '1', '4.50', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('30', '42', '53', '黄白菜500g/份 正负20g', '/upload/goods/20200506/34b35363376e098c9606aa625a79e720.jpg', '500g', '4.00', '1', '3.98', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('31', '42', '54', '鸡心包  800g/份 正负50g', '/upload/goods/20200506/1de960e272f591f6b0f0f21ae229e20a.jpg', '500g', '3.00', '1', '2.98', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('32', '42', '56', '芥兰头500g/份  正负50g', '/upload/goods/20200506/f8d630636c33df8cf724a8a354e44eff.jpg', '500g', '4.00', '1', '4.98', '1598932480', null);
INSERT INTO `ns_storegoods_price` VALUES ('33', '44', '21', '白蘑菇  500g正负20g', '/upload/goods/20200506/d65f8c7260a789e44e32834c0e7fef7d.jpg', '500g', '14.00', '1', '12.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('34', '44', '24', '白玉菇  200g正负20g', '/upload/goods/20200506/b18313017af1d033ac84f37e29f9f678.jpg', '500g', '4.00', '1', '3.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('35', '44', '28', '新鲜菠菜350g/份  正负20g', '/upload/goods/20200506/08c4ad1175e3c61631a093d266429e7d.jpg', '500g', '3.00', '1', '3.55', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('36', '44', '30', '新鲜菜藕 700g/份  正负50g', '/upload/goods/20200506/1efed0ef7977f2d640c12ca5a6ad4109.jpg', '500g', '6.00', '1', '7.99', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('37', '44', '33', '精品大红椒500g正负50g', '/upload/goods/20200506/e62931a0c5584a0727d6c9c44004ed76.jpg', '500g', '5.00', '1', '5.99', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('38', '44', '35', '本地青椒500g  正负50g', '/upload/goods/20200506/b4289bb1825acdb371f21af0d768b81f.jpg', '500g', '3.00', '1', '0.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('39', '44', '36', '红皮大蒜叶   300g/份正负20g', '/upload/goods/20200506/f86cdbb1892ddcee6ab610b64fe3cf70.jpg', '500g', '2.00', '1', '0.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('40', '44', '37', '大蒜籽  500g正负50g', '/upload/goods/20200506/f0fdce512fec2977d3804e407afd5324.jpg', '500g', '2.00', '1', '0.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('41', '44', '38', '云南精品大土豆1000g正负50g', '/upload/goods/20200506/1a9367a41ebb63026a02b1137a9174f0.jpg', '500g', '3.00', '1', '0.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('42', '44', '39', '本地带泥胡萝卜500g正负50g', '/upload/goods/20200506/e72e628a573032b4c3771413affdb069.jpg', '500g', '2.00', '1', '0.00', '1598941112', null);
INSERT INTO `ns_storegoods_price` VALUES ('43', '42', '58', '金针菇400g/份 正负20g', '/upload/goods/20200506/52d563e87fdf5726381f467279b7894d.jpg', '500g', '3.00', '1', '3.68', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('44', '42', '59', '韭菜  500g/份正负50g', '/upload/goods/20200506/515368470e52992ce4f248b8af48e9c7.jpg', '500g', '3.00', '1', '4.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('45', '42', '60', '空心菜  500g/份正负50g', '/upload/goods/20200507/beafd6a3c77c8a99467960ad1fbadb22.jpg', '500g', '3.00', '1', '3.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('46', '42', '61', '苦瓜  500g/份正负50g', '/upload/goods/20200507/1a6161842c2c05288acb09030d0e0755.jpg', '500g', '5.00', '1', '4.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('47', '42', '65', '精品螺丝椒500g/份 正负50g', '/upload/goods/20200507/c4e16b6492e37fafd121222e6dd9261d.jpg', '500g', '4.00', '1', '3.68', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('48', '42', '66', '绿豆芽250g/份 正负20g', '/upload/goods/20200507/5681c9facbfb48927b54e24800922c88.jpg', '500g', '2.00', '1', '1.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('49', '42', '68', '毛芋头1000g/份 正负50g', '/upload/goods/20200507/c1428e2849a70b405a0fff04408b546b.jpg', '500g', '7.00', '1', '4.58', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('50', '42', '69', '香芹菜350g/份  正负20g', '/upload/goods/20200507/dc2c365c5c693cd623eefccc0b0df97d.jpg', '500g', '4.00', '1', '6.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('51', '42', '71', '青黄瓜500g/份  正负50g', '/upload/goods/20200507/b5928330af1f1e47cfef563bbe3e467c.jpg', '500g', '3.00', '1', '3.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('52', '42', '73', '青线椒500g/份  正负20g', '/upload/goods/20200507/054e8b417946a6fb1a839fead4d7e1ef.jpg', '500g', '3.00', '1', '4.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('53', '42', '75', '上海青  500g/份正负50g', '/upload/goods/20200507/20c8ee4ffcd3335f28d82f8f36f290d2.jpg', '500g', '3.00', '1', '3.88', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('54', '42', '76', '生菜500g/份  正负50g', '/upload/goods/20200507/010d7d71d75f0d8fac4d667b97a921d9.jpg', '500g', '3.00', '1', '3.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('55', '42', '78', '四季豆350g/份  正负20g', '/upload/goods/20200507/2c78f9aa93e69346eee6d4ef9a7351da.jpg', '500g', '3.00', '1', '6.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('56', '42', '82', '甜玉米  3个/份', '/upload/goods/20200507/22e61997f56aa7f89f4343c6bb98ddc9.jpg', '500g', '5.00', '1', '2.50', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('57', '42', '83', '铁棍山药  500g/份正负50g', '/upload/goods/20200507/e9e7c4c02177a83efe1a40d3f21f3cfb.jpg', '500g', '5.00', '1', '5.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('58', '42', '84', '豌豆尖500g/份  正负20g', '/upload/goods/20200507/5950f62b996168dda53764989d70fffc.jpg', '500g', '7.00', '1', '0.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('59', '42', '85', '西红柿500g/份  正负20g', '/upload/goods/20200507/162b0b6561ae44bc081212455c9f8af0.jpg', '500g', '3.00', '1', '3.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('60', '42', '86', '西葫芦350g/份  正负20g', '/upload/goods/20200507/ae04c7a444d89193774a37c9be579c7d.jpg', '500g', '1.00', '1', '4.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('61', '42', '87', '西兰花500g/份  正负50g', '/upload/goods/20200507/5b994bde9de4f2653cce052be0fb1d38.jpg', '500g', '6.00', '1', '7.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('62', '42', '90', '鲜香菇400g/份  正负20g', '/upload/goods/20200507/cd2d91394c01f9f78a4289ceda589677.jpg', '500g', '4.00', '1', '9.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('63', '42', '91', '香菜250g/份  正负20g', '/upload/goods/20200507/87aa9f3dd63c6305297f20dfdaa9da65.jpg', '500g', '3.00', '1', '13.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('64', '42', '92', '香葱350g/份  正负20g', '/upload/goods/20200507/54871a567df7ececdf3f566ea49608f1.jpg', '500g', '2.00', '1', '6.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('65', '42', '93', '香莴笋1000g/份  正负50g', '/upload/goods/20200507/e69b85e7d71582723b6d07777db1071d.jpg', '500g', '5.00', '1', '4.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('66', '42', '94', '小芥兰400g/份  正负20g', '/upload/goods/20200507/1114596e054cf67e5b12b43ffb0f6d99.jpg', '500g', '2.00', '1', '4.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('67', '42', '100', '杏鲍菇500g/份  正负50g', '/upload/goods/20200507/bd839dc4763f5d85bc8e35ca478a9e1b.jpg', '500g', '4.00', '1', '4.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('68', '42', '101', '芽白苗500g/份  正负20g', '/upload/goods/20200507/5569067a2425a6dcb9f3ffd11b210b1d.jpg', '500g', '5.00', '1', '3.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('69', '42', '102', '洋葱500g/份  正负50g', '/upload/goods/20200507/f8cf4443101ff2b590528e5a0feaa27b.jpg', '500g', '2.00', '1', '1.38', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('70', '42', '106', '油麦菜  500g/份正负20g', '/upload/goods/20200507/492cd8d9f8f963a12110ac1a0fb32b9d.jpg', '500g', '3.00', '1', '2.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('71', '42', '108', '小米椒  350g/份正负20g', '/upload/goods/20200507/598436c6c7dc64e4ca644ff386660688.jpg', '500g', '4.00', '1', '5.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('72', '42', '111', '长豆角500g/份  正负50g', '/upload/goods/20200507/222414581eaf39bfe342c1772655b3ee.jpg', '500g', '3.00', '1', '0.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('73', '42', '112', '长茄子750g/份  正负50g', '/upload/goods/20200507/7a49c0e86fa7b65385d516dbbd01dd11.jpg', '500g', '4.00', '1', '0.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('74', '42', '115', '猪肚菇  250g/份正负20g', '/upload/goods/20200507/576364829dd98f04c6d69690cc09469d.jpg', '500g', '6.00', '1', '7.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('75', '42', '116', '紫包菜500g/份  正负20g', '/upload/goods/20200507/6fea15fb9507c3507e90b48d82cd96f5.jpg', '500g', '3.00', '1', '2.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('76', '42', '118', '本地紫圆茄子500g/份  正负50g', '/upload/goods/20200507/1d892343be02aa3685122dd84b43ec30.jpg', '500g', '0.00', '1', '4.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('77', '42', '318', '新鲜云耳  250g/份正负20g', '/upload/goods/20200519/84e27c84b96614526e73e26b8d032dd8.jpg', '500g', '3.00', '1', '0.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('78', '42', '320', '精品韭花  250g正负20g', '/upload/goods/20200622/e80e5c948410a6c5082c5d6bceda2a56.jpg', '500g', '2.00', '1', '8.90', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('79', '42', '325', '青丝瓜 500g份  正负50g', '/upload/goods/20200710/c43062cf45a4e1c69b000f2394d6ec64.jpg', '500g', '4.00', '1', '3.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('80', '42', '352', '精品冬瓜  500g/份正负50g', '/upload/goods/20200831/298f346b5d829c1e430a8afca150a3c2.jpg', '500g', '1.00', '1', '1.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('81', '42', '353', '黄心蜜薯  500g/份正负50g', '/upload/goods/20200831/2e5e40ed0159cc437399d2678433149f.jpg', '500g', '4.00', '1', '1.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('82', '42', '354', '香芋  1500g/份正负100g', '/upload/goods/20200831/d47f8d64d026a0a885958f886a7aaa77.jpg', '500g', '12.00', '1', '4.58', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('83', '42', '355', '黄豆芽  250g/份正负20g', '/upload/goods/20200831/326cb5ec0e3d5a235037955c55941364.jpg', '500g', '3.00', '1', '1.98', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('84', '42', '356', '蟹味菇  250/份正负20g', '/upload/goods/20200831/7f227b3b6226a406b3499dffeb39eb79.jpg', '500g', '3.00', '1', '5.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('85', '42', '357', '秀珍菇  250g/份正负20g', '/upload/goods/20200831/170a5b500225a1b44cf0ab69e0283baf.jpg', '500g', '3.00', '1', '0.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('86', '42', '358', '精品红线椒  250g/份正负20g', '/upload/goods/20200831/599da3e3c832cf9e65b8c38c28e1a999.jpg', '500g', '3.00', '1', '5.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('87', '42', '364', '本地小南瓜  1000g/份正负100g', '/upload/goods/20200901/6aba04361e0e43f053c7c1ed4e488c80.jpg', '500g', '6.00', '1', '3.28', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('88', '42', '366', '雪里红  500g/份正负50g', '/upload/goods/20200901/4e28bae11e4eca5a8c28711685288ed4.jpg', '500g', '5.00', '1', '4.00', '1599015486', null);
INSERT INTO `ns_storegoods_price` VALUES ('89', '42', '191', '鳊鱼400g/份  正负20g', '/upload/goods/20200509/df04274358514611dd2cbeb47658ea62.jpg', '500g', '10.00', '1', '12.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('90', '42', '203', '黄鸭叫300g/份  正负20g', '/upload/goods/20200509/d8f87d48ab051887c70baaa5933909b7.jpg', '500g', '13.00', '1', '9.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('91', '42', '205', '新鲜鲫鱼  400g/份正负20g', '/upload/goods/20200509/80ef37e91dda45ded029c382c0fb9d27.jpg', '500g', '10.00', '1', '8.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('92', '42', '207', '鲈鱼350g/份  正负20g', '/upload/goods/20200509/f331b3bd9bcaea4acf5dca5fc0279968.jpg', '500g', '12.00', '1', '18.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('93', '42', '367', '新鲜草鱼  1500g/份正负100g', '/upload/goods/20200901/7ab684e62b80df7b4c424304613cbbaa.jpg', '500g', '35.00', '1', '24.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('94', '42', '368', '鲜活雄鱼  1500g/份正负100g', '/upload/goods/20200901/78884e79ccf4d954acc1e037620f6a1b.jpg', '500g', '36.00', '1', '29.00', '1599016256', null);
INSERT INTO `ns_storegoods_price` VALUES ('95', '42', '12', '谷物鸡蛋20枚/份', '/upload/goods/20200430/85dff97ffe87579a777a1aec86041df4.jpg', '500g', '6.00', '1', '14.90', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('96', '42', '13', '鹌鹑蛋 500g/份 正负50g', '/upload/goods/20200506/f7ab419eb22a71f294fcafa8d10347b2.jpg', '500g', '11.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('97', '42', '15', '生咸鸭蛋  6枚/份', '/upload/goods/20200506/2ed0f6f71085ce9493f9a66ead34aa71.jpg', '500g', '6.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('98', '42', '17', '松花皮蛋  10枚/份', '/upload/goods/20200506/aac64a8cf6f7f135fb485009a83ee5ac.jpg', '500g', '14.00', '1', '10.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('99', '42', '137', '黄牛肉500g/份  正负50g', '/upload/goods/20200508/d0bb133e35c677923c7feff8457d400a.jpg', '500g', '45.00', '1', '50.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('100', '42', '140', '牛腩500g/份  正负50g', '/upload/goods/20200508/3ef8b37bd53caa15fb8854a9127331d3.jpg', '500g', '43.00', '1', '50.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('101', '42', '144', '猪后腿肉  500g/份正负50g', '/upload/goods/20200508/632a37588b0ca859249a658723e9f4f8.jpg', '500g', '35.00', '1', '29.80', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('102', '42', '146', '里脊肉500g/份  正负50g', '/upload/goods/20200508/78ae5a57893a025988f283ab5ca83fae.jpg', '500g', '36.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('103', '42', '147', '龙骨  500g/份正负50g', '/upload/goods/20200508/1ad159ed57da96e665c7b25f59336953.jpg', '500g', '18.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('104', '42', '149', '前腿肉500g/份  正负50g', '/upload/goods/20200508/13713a524fec893530dc4d19316823db.jpg', '500g', '32.00', '1', '29.80', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('105', '42', '150', '汤骨  500g/份正负50g', '/upload/goods/20200508/7bfc7e42ee2e67ac425c7db3bf3f9b8f.jpg', '500g', '22.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('106', '42', '151', '筒子骨  500g/份正负50g', '/upload/goods/20200508/f69ee62ecea661d3b59f83f289ddbb10.jpg', '500g', '32.00', '1', '24.80', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('107', '42', '152', '精品五花肉300g/份  正负20g', '/upload/goods/20200508/0f2b97d352a0a68ce515c557183a4519.jpg', '500g', '16.00', '1', '18.48', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('108', '42', '155', '猪肝500g/份  正负20g', '/upload/goods/20200508/f85427521d5e54ed055e2401dcdc4e6b.jpg', '500g', '16.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('109', '42', '156', '猪脚  1500g/份正负50g', '/upload/goods/20200508/6a676f078397bdd6d07a7e368969330f.jpg', '500g', '79.00', '1', '108.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('110', '42', '157', '猪舌200g/份  正负20g', '/upload/goods/20200508/9ae52254d937ed136ed4cb1c70226e1c.jpg', '500g', '11.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('111', '42', '160', '猪腰  350g/份  正负20g', '/upload/goods/20200508/0340d7e188a6935fa1a916aae638ae24.jpg', '500g', '14.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('112', '42', '174', '老母鸡1350g/份  正负100g', '/upload/goods/20200508/a68f5c05a76aa4e0666640a16fa68f1a.jpg', '500g', '58.00', '1', '13.80', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('113', '42', '175', '老水鸭1500g/份  正负200g', '/upload/goods/20200508/ade9e5ad37e9407d5e102ffebb39e810.jpg', '500g', '16.00', '1', '17.80', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('114', '42', '180', '散养土鸡1350g/份  正负100g', '/upload/goods/20200508/611b85670aaa640fec4cdbff0c4ebda1.jpg', '500g', '49.00', '1', '88.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('115', '42', '336', '肋排  400g/份正负20g', '/upload/goods/20200717/e58944b4b020ff3f04f93bb47926059a.jpg', '500g', '25.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('116', '42', '351', '乌鸡整只 1250g/只  正负100g', '/upload/goods/20200831/85cae2db4f95c47d60ce677029cc0611.jpg', '500g', '36.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('117', '42', '362', '乳鸽一只', '/upload/goods/20200831/76f35c095be0921d0c3d4a9fff66b134.jpg', '500g', '35.00', '1', '0.00', '1599016714', null);
INSERT INTO `ns_storegoods_price` VALUES ('118', '42', '119', '白豆腐  400g/份正负20g', '/upload/goods/20200508/055bd3296205ca32f7e2b494774a1843.jpg', '500g', '3.00', '1', '0.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('119', '42', '123', '鸡蛋豆腐400g/份  正负20g', '/upload/goods/20200508/b0123cf23e8fde3a9afac62ae750eebb.jpg', '500g', '3.00', '1', '1.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('120', '42', '126', '米豆腐500g/份  正负20g', '/upload/goods/20200508/729cdf6baa90ff9d3adddba21cc0f0a0.jpg', '500g', '3.00', '1', '1.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('121', '42', '128', '魔芋豆腐500g/份  正负20g', '/upload/goods/20200508/c3d6fbe6033c40bec3b175210a8b2a68.jpg', '500g', '5.00', '1', '1.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('122', '42', '129', '千张250g/份  正负20g', '/upload/goods/20200508/fa34e5fb5b8563ee8fa68f31851f8726.jpg', '500g', '4.00', '1', '0.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('123', '42', '130', '素捆鸡250g/份  正负20g', '/upload/goods/20200508/463132086ecffb9a762e659b06a589be.jpg', '500g', '5.00', '1', '0.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('124', '42', '134', '攸县香干250g/份  正负20g', '/upload/goods/20200508/75485f153255299e453a3b07b0406770.jpg', '500g', '3.00', '1', '0.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('125', '42', '135', '油豆腐250g/份  正负20g', '/upload/goods/20200508/a51213e7793bc0d225abc596cfd296c4.jpg', '500g', '6.00', '1', '5.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('126', '42', '359', '兰花豆干  150g/份正负20g', '/upload/goods/20200831/db2a452fedadd7d20440603158ac3827.jpg', '500g', '8.00', '1', '0.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('127', '42', '360', '柴火腊香干  250g/份正负20g', '/upload/goods/20200831/61150f38931c11a250395a9c832014b6.jpg', '500g', '4.00', '1', '5.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('128', '42', '363', '酱卤小香干  300g/份正负20g', '/upload/goods/20200901/9f7a78c29d838cb3e7e0657925be9d1d.jpg', '500g', '4.00', '1', '5.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('129', '42', '365', '精选腐竹  250g/份', '/upload/goods/20200901/efc6b26d9ddab4958f9b6b049dd95d5d.jpg', '500g', '9.00', '1', '14.00', '1599016825', null);
INSERT INTO `ns_storegoods_price` VALUES ('130', '43', '348', '干云耳  100g/份', '/upload/goods/20200730/a045856e7953352e7db2bcda839186f1.jpg', '500g', '11.00', '1', '60.00', '1599020579', null);
INSERT INTO `ns_storegoods_price` VALUES ('131', '43', '349', '干辣椒粉  100g/份', '/upload/goods/20200730/47043a8033597f4deb2a7bc5d02f01d2.jpg', '500g', '19.00', '1', '38.00', '1599020579', null);
INSERT INTO `ns_storegoods_price` VALUES ('132', '43', '361', '干香菇  100g/份', '/upload/goods/20200831/d03ff5869ee4e25bfb55c685eded4240.jpg', '500g', '13.00', '1', '60.00', '1599020579', null);
INSERT INTO `ns_storegoods_price` VALUES ('133', '43', '21', '白蘑菇  500g正负20g', '/upload/goods/20200506/d65f8c7260a789e44e32834c0e7fef7d.jpg', '500g', '14.00', '1', '12.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('134', '43', '24', '白玉菇  200g正负20g', '/upload/goods/20200506/b18313017af1d033ac84f37e29f9f678.jpg', '500g', '4.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('135', '43', '28', '新鲜菠菜350g/份  正负20g', '/upload/goods/20200506/08c4ad1175e3c61631a093d266429e7d.jpg', '500g', '3.00', '1', '7.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('136', '43', '30', '新鲜菜藕 700g/份  正负50g', '/upload/goods/20200506/1efed0ef7977f2d640c12ca5a6ad4109.jpg', '500g', '6.00', '1', '6.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('137', '43', '33', '精品大红椒500g正负50g', '/upload/goods/20200506/e62931a0c5584a0727d6c9c44004ed76.jpg', '500g', '5.00', '1', '9.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('138', '43', '35', '本地青椒500g  正负50g', '/upload/goods/20200506/b4289bb1825acdb371f21af0d768b81f.jpg', '500g', '3.00', '1', '6.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('139', '43', '36', '红皮大蒜叶   300g/份正负20g', '/upload/goods/20200506/f86cdbb1892ddcee6ab610b64fe3cf70.jpg', '500g', '2.00', '1', '6.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('140', '43', '37', '大蒜籽  500g正负50g', '/upload/goods/20200506/f0fdce512fec2977d3804e407afd5324.jpg', '500g', '2.00', '1', '4.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('141', '43', '38', '云南精品大土豆1000g正负50g', '/upload/goods/20200506/1a9367a41ebb63026a02b1137a9174f0.jpg', '500g', '3.00', '1', '2.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('142', '43', '39', '本地带泥胡萝卜500g正负50g', '/upload/goods/20200506/e72e628a573032b4c3771413affdb069.jpg', '500g', '2.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('143', '43', '42', '高山娃娃菜500g正负50g', '/upload/goods/20200506/2d5119f8541758a78ceb19f9f603679e.jpg', '500g', '3.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('144', '43', '43', '广心菜  400g正负20g', '/upload/goods/20200506/5578b5a8590af410889b8adf9d061a97.jpg', '500g', '4.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('145', '43', '45', '精品荷兰豆350g/份  正负20g', '/upload/goods/20200506/937de2d683d5c7dfbb10bd549228185c.jpg', '500g', '4.00', '1', '7.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('146', '43', '47', '新鲜红薯尖500g正负50g', '/upload/goods/20200506/9a912504a50293bc198d756d6e472f0b.jpg', '500g', '3.00', '1', '2.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('147', '43', '48', '红苋菜  500g/份  正负50g', '/upload/goods/20200506/bd628edaf29679f2aed82d74d2512eb0.jpg', '500g', '4.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('148', '43', '50', '胡萝卜  500g正负50g', '/upload/goods/20200506/296fccea75d2d6ba65b487a967a135db.jpg', '500g', '2.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('149', '43', '51', '精品有机花菜  400g正负20g', '/upload/goods/20200506/2304fae6d906ab17d02fe203d1878067.jpg', '500g', '4.00', '1', '5.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('150', '43', '53', '黄白菜500g/份 正负20g', '/upload/goods/20200506/34b35363376e098c9606aa625a79e720.jpg', '500g', '4.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('151', '43', '54', '鸡心包  800g/份 正负50g', '/upload/goods/20200506/1de960e272f591f6b0f0f21ae229e20a.jpg', '500g', '3.00', '1', '2.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('152', '43', '56', '芥兰头500g/份  正负50g', '/upload/goods/20200506/f8d630636c33df8cf724a8a354e44eff.jpg', '500g', '4.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('153', '43', '58', '金针菇400g/份 正负20g', '/upload/goods/20200506/52d563e87fdf5726381f467279b7894d.jpg', '500g', '3.00', '1', '5.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('154', '43', '59', '韭菜  500g/份正负50g', '/upload/goods/20200506/515368470e52992ce4f248b8af48e9c7.jpg', '500g', '3.00', '1', '6.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('155', '43', '60', '空心菜  500g/份正负50g', '/upload/goods/20200507/beafd6a3c77c8a99467960ad1fbadb22.jpg', '500g', '3.00', '1', '2.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('156', '43', '61', '苦瓜  500g/份正负50g', '/upload/goods/20200507/1a6161842c2c05288acb09030d0e0755.jpg', '500g', '5.00', '1', '5.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('157', '43', '65', '精品螺丝椒500g/份 正负50g', '/upload/goods/20200507/c4e16b6492e37fafd121222e6dd9261d.jpg', '500g', '4.00', '1', '4.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('158', '43', '66', '绿豆芽250g/份 正负20g', '/upload/goods/20200507/5681c9facbfb48927b54e24800922c88.jpg', '500g', '2.00', '1', '2.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('159', '43', '68', '毛芋头1000g/份 正负50g', '/upload/goods/20200507/c1428e2849a70b405a0fff04408b546b.jpg', '500g', '7.00', '1', '5.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('160', '43', '69', '香芹菜350g/份  正负20g', '/upload/goods/20200507/dc2c365c5c693cd623eefccc0b0df97d.jpg', '500g', '4.00', '1', '6.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('161', '43', '71', '青黄瓜500g/份  正负50g', '/upload/goods/20200507/b5928330af1f1e47cfef563bbe3e467c.jpg', '500g', '3.00', '1', '3.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('162', '43', '73', '青线椒500g/份  正负20g', '/upload/goods/20200507/054e8b417946a6fb1a839fead4d7e1ef.jpg', '500g', '3.00', '1', '4.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('163', '43', '75', '上海青  500g/份正负50g', '/upload/goods/20200507/20c8ee4ffcd3335f28d82f8f36f290d2.jpg', '500g', '3.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('164', '43', '76', '生菜500g/份  正负50g', '/upload/goods/20200507/010d7d71d75f0d8fac4d667b97a921d9.jpg', '500g', '3.00', '1', '4.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('165', '43', '78', '四季豆350g/份  正负20g', '/upload/goods/20200507/2c78f9aa93e69346eee6d4ef9a7351da.jpg', '500g', '3.00', '1', '8.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('166', '43', '82', '甜玉米  3个/份', '/upload/goods/20200507/22e61997f56aa7f89f4343c6bb98ddc9.jpg', '500g', '5.00', '1', '7.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('167', '43', '83', '铁棍山药  500g/份正负50g', '/upload/goods/20200507/e9e7c4c02177a83efe1a40d3f21f3cfb.jpg', '500g', '5.00', '1', '5.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('168', '43', '84', '豌豆尖500g/份  正负20g', '/upload/goods/20200507/5950f62b996168dda53764989d70fffc.jpg', '500g', '7.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('169', '43', '85', '西红柿500g/份  正负20g', '/upload/goods/20200507/162b0b6561ae44bc081212455c9f8af0.jpg', '500g', '3.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('170', '43', '86', '西葫芦350g/份  正负20g', '/upload/goods/20200507/ae04c7a444d89193774a37c9be579c7d.jpg', '500g', '1.00', '1', '0.00', '1599021036', null);
INSERT INTO `ns_storegoods_price` VALUES ('171', '43', '87', '西兰花500g/份  正负50g', '/upload/goods/20200507/5b994bde9de4f2653cce052be0fb1d38.jpg', '500g', '6.00', '1', '7.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('172', '43', '90', '鲜香菇400g/份  正负20g', '/upload/goods/20200507/cd2d91394c01f9f78a4289ceda589677.jpg', '500g', '4.00', '1', '10.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('173', '43', '91', '香菜250g/份  正负20g', '/upload/goods/20200507/87aa9f3dd63c6305297f20dfdaa9da65.jpg', '500g', '3.00', '1', '15.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('174', '43', '92', '香葱350g/份  正负20g', '/upload/goods/20200507/54871a567df7ececdf3f566ea49608f1.jpg', '500g', '2.00', '1', '7.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('175', '43', '93', '香莴笋1000g/份  正负50g', '/upload/goods/20200507/e69b85e7d71582723b6d07777db1071d.jpg', '500g', '5.00', '1', '5.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('176', '43', '94', '小芥兰400g/份  正负20g', '/upload/goods/20200507/1114596e054cf67e5b12b43ffb0f6d99.jpg', '500g', '2.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('177', '43', '100', '杏鲍菇500g/份  正负50g', '/upload/goods/20200507/bd839dc4763f5d85bc8e35ca478a9e1b.jpg', '500g', '4.00', '1', '5.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('178', '43', '101', '芽白苗500g/份  正负20g', '/upload/goods/20200507/5569067a2425a6dcb9f3ffd11b210b1d.jpg', '500g', '5.00', '1', '4.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('179', '43', '102', '洋葱500g/份  正负50g', '/upload/goods/20200507/f8cf4443101ff2b590528e5a0feaa27b.jpg', '500g', '2.00', '1', '2.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('180', '43', '106', '油麦菜  500g/份正负20g', '/upload/goods/20200507/492cd8d9f8f963a12110ac1a0fb32b9d.jpg', '500g', '3.00', '1', '3.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('181', '43', '108', '小米椒  350g/份正负20g', '/upload/goods/20200507/598436c6c7dc64e4ca644ff386660688.jpg', '500g', '4.00', '1', '4.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('182', '43', '111', '长豆角500g/份  正负50g', '/upload/goods/20200507/222414581eaf39bfe342c1772655b3ee.jpg', '500g', '3.00', '1', '6.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('183', '43', '112', '长茄子750g/份  正负50g', '/upload/goods/20200507/7a49c0e86fa7b65385d516dbbd01dd11.jpg', '500g', '4.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('184', '43', '115', '猪肚菇  250g/份正负20g', '/upload/goods/20200507/576364829dd98f04c6d69690cc09469d.jpg', '500g', '6.00', '1', '18.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('185', '43', '116', '紫包菜500g/份  正负20g', '/upload/goods/20200507/6fea15fb9507c3507e90b48d82cd96f5.jpg', '500g', '3.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('186', '43', '118', '本地紫圆茄子500g/份  正负50g', '/upload/goods/20200507/1d892343be02aa3685122dd84b43ec30.jpg', '500g', '0.00', '1', '4.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('187', '43', '318', '新鲜云耳  250g/份正负20g', '/upload/goods/20200519/84e27c84b96614526e73e26b8d032dd8.jpg', '500g', '3.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('188', '43', '320', '精品韭花  250g正负20g', '/upload/goods/20200622/e80e5c948410a6c5082c5d6bceda2a56.jpg', '500g', '2.00', '1', '8.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('189', '43', '325', '青丝瓜 500g份  正负50g', '/upload/goods/20200710/c43062cf45a4e1c69b000f2394d6ec64.jpg', '500g', '4.00', '1', '3.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('190', '43', '352', '精品冬瓜  500g/份正负50g', '/upload/goods/20200831/298f346b5d829c1e430a8afca150a3c2.jpg', '500g', '1.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('191', '43', '353', '黄心蜜薯  500g/份正负50g', '/upload/goods/20200831/2e5e40ed0159cc437399d2678433149f.jpg', '500g', '4.00', '1', '2.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('192', '43', '354', '香芋  1500g/份正负100g', '/upload/goods/20200831/d47f8d64d026a0a885958f886a7aaa77.jpg', '500g', '12.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('193', '43', '355', '黄豆芽  250g/份正负20g', '/upload/goods/20200831/326cb5ec0e3d5a235037955c55941364.jpg', '500g', '3.00', '1', '2.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('194', '43', '356', '蟹味菇  250/份正负20g', '/upload/goods/20200831/7f227b3b6226a406b3499dffeb39eb79.jpg', '500g', '3.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('195', '43', '357', '秀珍菇  250g/份正负20g', '/upload/goods/20200831/170a5b500225a1b44cf0ab69e0283baf.jpg', '500g', '3.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('196', '43', '358', '精品红线椒  250g/份正负20g', '/upload/goods/20200831/599da3e3c832cf9e65b8c38c28e1a999.jpg', '500g', '3.00', '1', '5.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('197', '43', '364', '本地小南瓜  1000g/份正负100g', '/upload/goods/20200901/6aba04361e0e43f053c7c1ed4e488c80.jpg', '500g', '6.00', '1', '0.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('198', '43', '366', '雪里红  500g/份正负50g', '/upload/goods/20200901/4e28bae11e4eca5a8c28711685288ed4.jpg', '500g', '5.00', '1', '4.00', '1599021037', null);
INSERT INTO `ns_storegoods_price` VALUES ('199', '43', '12', '谷物鸡蛋20枚/份', '/upload/goods/20200430/85dff97ffe87579a777a1aec86041df4.jpg', '500g', '6.00', '1', '18.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('200', '43', '13', '鹌鹑蛋 500g/份 正负50g', '/upload/goods/20200506/f7ab419eb22a71f294fcafa8d10347b2.jpg', '500g', '11.00', '1', '12.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('201', '43', '15', '生咸鸭蛋  6枚/份', '/upload/goods/20200506/2ed0f6f71085ce9493f9a66ead34aa71.jpg', '500g', '6.00', '1', '7.20', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('202', '43', '17', '松花皮蛋  10枚/份', '/upload/goods/20200506/aac64a8cf6f7f135fb485009a83ee5ac.jpg', '500g', '14.00', '1', '12.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('203', '43', '137', '黄牛肉500g/份  正负50g', '/upload/goods/20200508/d0bb133e35c677923c7feff8457d400a.jpg', '500g', '45.00', '1', '50.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('204', '43', '140', '牛腩500g/份  正负50g', '/upload/goods/20200508/3ef8b37bd53caa15fb8854a9127331d3.jpg', '500g', '43.00', '1', '45.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('205', '43', '144', '猪后腿肉  500g/份正负50g', '/upload/goods/20200508/632a37588b0ca859249a658723e9f4f8.jpg', '500g', '35.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('206', '43', '146', '里脊肉500g/份  正负50g', '/upload/goods/20200508/78ae5a57893a025988f283ab5ca83fae.jpg', '500g', '36.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('207', '43', '147', '龙骨  500g/份正负50g', '/upload/goods/20200508/1ad159ed57da96e665c7b25f59336953.jpg', '500g', '18.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('208', '43', '149', '前腿肉500g/份  正负50g', '/upload/goods/20200508/13713a524fec893530dc4d19316823db.jpg', '500g', '32.00', '1', '29.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('209', '43', '150', '汤骨  500g/份正负50g', '/upload/goods/20200508/7bfc7e42ee2e67ac425c7db3bf3f9b8f.jpg', '500g', '22.00', '1', '29.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('210', '43', '151', '筒子骨  500g/份正负50g', '/upload/goods/20200508/f69ee62ecea661d3b59f83f289ddbb10.jpg', '500g', '32.00', '1', '29.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('211', '43', '152', '精品五花肉300g/份  正负20g', '/upload/goods/20200508/0f2b97d352a0a68ce515c557183a4519.jpg', '500g', '16.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('212', '43', '155', '猪肝500g/份  正负20g', '/upload/goods/20200508/f85427521d5e54ed055e2401dcdc4e6b.jpg', '500g', '16.00', '1', '26.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('213', '43', '156', '猪脚  1500g/份正负50g', '/upload/goods/20200508/6a676f078397bdd6d07a7e368969330f.jpg', '500g', '79.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('214', '43', '157', '猪舌200g/份  正负20g', '/upload/goods/20200508/9ae52254d937ed136ed4cb1c70226e1c.jpg', '500g', '11.00', '1', '28.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('215', '43', '160', '猪腰  350g/份  正负20g', '/upload/goods/20200508/0340d7e188a6935fa1a916aae638ae24.jpg', '500g', '14.00', '1', '25.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('216', '43', '174', '老母鸡1350g/份  正负100g', '/upload/goods/20200508/a68f5c05a76aa4e0666640a16fa68f1a.jpg', '500g', '58.00', '1', '0.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('217', '43', '175', '老水鸭1500g/份  正负200g', '/upload/goods/20200508/ade9e5ad37e9407d5e102ffebb39e810.jpg', '500g', '16.00', '1', '68.80', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('218', '43', '180', '散养土鸡1350g/份  正负100g', '/upload/goods/20200508/611b85670aaa640fec4cdbff0c4ebda1.jpg', '500g', '49.00', '1', '90.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('219', '43', '336', '肋排  400g/份正负20g', '/upload/goods/20200717/e58944b4b020ff3f04f93bb47926059a.jpg', '500g', '25.00', '1', '0.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('220', '43', '351', '乌鸡整只 1250g/只  正负100g', '/upload/goods/20200831/85cae2db4f95c47d60ce677029cc0611.jpg', '500g', '36.00', '1', '0.00', '1599021293', null);
INSERT INTO `ns_storegoods_price` VALUES ('221', '43', '362', '乳鸽一只', '/upload/goods/20200831/76f35c095be0921d0c3d4a9fff66b134.jpg', '500g', '35.00', '1', '0.00', '1599021294', null);
INSERT INTO `ns_storegoods_price` VALUES ('222', '45', '348', '干云耳  100g/份', '/upload/goods/20200730/a045856e7953352e7db2bcda839186f1.jpg', '500g', '11.00', '1', '11.88', '1599025494', null);
INSERT INTO `ns_storegoods_price` VALUES ('223', '45', '349', '干辣椒粉  100g/份', '/upload/goods/20200730/47043a8033597f4deb2a7bc5d02f01d2.jpg', '500g', '19.00', '1', '19.81', '1599025494', null);
INSERT INTO `ns_storegoods_price` VALUES ('224', '45', '361', '干香菇  100g/份', '/upload/goods/20200831/d03ff5869ee4e25bfb55c685eded4240.jpg', '500g', '13.00', '1', '0.00', '1599025494', null);
INSERT INTO `ns_storegoods_price` VALUES ('225', '44', '42', '高山娃娃菜500g正负50g', '/upload/goods/20200506/2d5119f8541758a78ceb19f9f603679e.jpg', '500g', '3.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('226', '44', '43', '广心菜  400g正负20g', '/upload/goods/20200506/5578b5a8590af410889b8adf9d061a97.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('227', '44', '45', '精品荷兰豆350g/份  正负20g', '/upload/goods/20200506/937de2d683d5c7dfbb10bd549228185c.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('228', '44', '47', '新鲜红薯尖500g正负50g', '/upload/goods/20200506/9a912504a50293bc198d756d6e472f0b.jpg', '500g', '3.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('229', '44', '48', '红苋菜  500g/份  正负50g', '/upload/goods/20200506/bd628edaf29679f2aed82d74d2512eb0.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('230', '44', '50', '胡萝卜  500g正负50g', '/upload/goods/20200506/296fccea75d2d6ba65b487a967a135db.jpg', '500g', '2.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('231', '44', '51', '精品有机花菜  400g正负20g', '/upload/goods/20200506/2304fae6d906ab17d02fe203d1878067.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('232', '44', '53', '黄白菜500g/份 正负20g', '/upload/goods/20200506/34b35363376e098c9606aa625a79e720.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('233', '44', '54', '鸡心包  800g/份 正负50g', '/upload/goods/20200506/1de960e272f591f6b0f0f21ae229e20a.jpg', '500g', '3.00', '1', '0.00', '1599025503', null);
INSERT INTO `ns_storegoods_price` VALUES ('234', '44', '56', '芥兰头500g/份  正负50g', '/upload/goods/20200506/f8d630636c33df8cf724a8a354e44eff.jpg', '500g', '4.00', '1', '0.00', '1599025503', null);
    A+
发布日期:2020年09月02日 17:28:39  所属分类:MySQL
最后更新时间:2020-09-02 18:21:06
付杰
  • ¥ 89.0元
  • 市场价:129.0元
  • ¥ 68.0元
  • 市场价:98.0元
  • ¥ 199.0元
  • 市场价:299.0元
  • ¥ 1999.9元
  • 市场价:8999元

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: