select * from fanwe_order;
数据库查询结果 [ 返回12条查询记录 耗时:0.000805s ]
id | sn | money_status | goods_status | status | create_time | update_time | zip | region_lv1 | region_lv2 | region_lv3 | region_lv4 | address | mobile_phone | fax_phone | fix_phone | alim | msn | consignee | user_id | memo | adm_memo | payment | total_price | delivery | protect | card_code | delivery_fee | protect_fee | payment_fee | tax | tax_content | tax_money | order_weight | currency_id | currency_radio | order_score | promote_money | order_total_price | cost_total_price | cost_delivery_fee | cost_protect_fee | cost_payment_fee | cost_other_fee | order_incharge | order_profit | lang_conf_id | is_paid | discount | parent_id | ecv_id | ecv_money | offline | mobile_phone_sms | delivery_refer_order_id | repay_status | bank_id | order_referral_money | tax_title | goods_send_date | user_email | is_360_post | card_info | is_2345_post | is_baidu_post | ||
57 | 1009041031471 | 2 | 5 | 0 | 1283538707 | 1283538707 | 0 | 0 | 0 | 0 | mail@7dit.com | 52 | 3 | 220.0000 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 0 | 0.0000 | 220.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 220.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||||||
58 | 1009041034578 | 4 | 5 | 0 | 1283538897 | 1283538897 | 0 | 0 | 0 | 0 | 97139915@qq.com | 54 | 4 | 112.0000 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 0 | 0.0000 | 112.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 1 | 0 | 0.0000 | 52 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||||||
59 | 1009041051246 | 2 | 2 | 0 | 1283539884 | 1283539884 | 350000 | 1 | 4 | 53 | 519 | 博美诗帮5-1402 | mail@7dit.com | 13999999999 | 方维测试 | 52 | 3 | 60.0000 | 9 | 1 | 10.0000 | 10.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 60 | 0.0000 | 80.0000 | 0.0000 | 10.0000 | 0.6000 | 0.0000 | 0.0000 | 80.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||
60 | 1009041055031 | 2 | 0 | 0 | 1283540103 | 1283540103 | 350000 | 1 | 4 | 53 | 519 | 博美诗帮5-1402 | mail@7dit.com | 13999999999 | 方维测试 | 52 | 3 | 20.0000 | 9 | 0 | 10.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.2000 | 1 | 1.0000 | 10 | 0.0000 | 30.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 30.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||
61 | 1009041055537 | 2 | 2 | 0 | 1283540153 | 1283540153 | 350000 | 1 | 4 | 53 | 519 | 博美诗帮5-1402 | mail@7dit.com | 13999999999 | 方维测试 | 52 | 3 | 80.0000 | 9 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.8000 | 1 | 1.0000 | 40 | 0.0000 | 80.0000 | 0.0000 | 10.0000 | 0.0000 | 0.0000 | 0.0000 | 80.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||
62 | 1009041056093 | 2 | 2 | 0 | 1283540169 | 1283540169 | 350000 | 1 | 4 | 53 | 519 | 博美诗帮5-1402 | mail@7dit.com | 13999999999 | 方维测试 | 52 | 3 | 20.0000 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.2000 | 1 | 1.0000 | 10 | 0.0000 | 20.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 20.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 61 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||
63 | 1009041112239 | 2 | 5 | 0 | 1283541143 | 1283541143 | 0 | 0 | 0 | 0 | 97139915@qq.com | 54 | 3 | 110.0000 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 0 | 0.0000 | 110.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 110.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||||||
64 | 1009041114248 | 2 | 5 | 0 | 1283541264 | 1283541299 | 0 | 0 | 0 | 0 | mail@7dit.com | 52 | 4 | 55.0000 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 0 | 0.0000 | 55.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 55.0000 | 0.0000 | 1 | 0 | 0.0000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | |||||||||||||||||
65 | 1306082253206 | 2 | 0 | 0 | 1370674400 | 1370674400 | 444444 | 1 | 4 | 54 | 532 | rrtrtrrtrt | 121212@qq.com | 13146662222 | eererererer | 56 | 3 | 12.0000 | 1 | 0 | 0.0000 | 0.0000 | 0.0000 | 0 | 0.0000 | 0.0000 | 1 | 1.0000 | 0 | 0.0000 | 9.6000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 9.6000 | 0.0000 | 1 | 0 | 2.4000 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.0000 | 1370674400 | 0 | 0 | 0 | ||||||||||||||
select * from fanwe_order_goods;
数据库查询结果 [ 返回14条查询记录 耗时:0.000162s ]
id | pid | order_id | rec_module | rec_id | data_name | data_sn | data_score | data_total_score | data_price | data_total_price | attr | number | is_inquiry | data_cost_price | create_time | status | send_number | data_weight | user_id | data_total_referral_money |
56 | 0 | 57 | PromoteGoods | 88 | 仅售50元!原价100元的梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 55.0000 | 220.0000 | 尺寸:12 颜色:红 | 4 | 0 | 0.0000 | 1283538707 | 0 | 0 | 1000.0000 | 52 | 0.0000 |
57 | 0 | 58 | PromoteGoods | 88 | 仅售50元!原价100元的梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 56.0000 | 112.0000 | 尺寸:12 颜色:黄 | 2 | 0 | 0.0000 | 1283538897 | 0 | 0 | 1000.0000 | 54 | 0.0000 |
58 | 0 | 59 | PromoteGoods | 87 | 仅售12元!乐淘网上鞋城80元现金消费券 | FW_100328011523 | 12 | 60 | 12.0000 | 60.0000 | 5 | 0 | 0.0000 | 1283539884 | 0 | 5 | 0.0000 | 52 | 0.0000 | |
59 | 0 | 60 | PromoteGoods | 86 | 仅售35元!原价70元的西夏部落酱香羊蝎子+养生八宝茶 | FW_100324045629 | 10 | 10 | 20.0000 | 20.0000 | 1 | 1 | 0.0000 | 1283540103 | 0 | 0 | 0.2000 | 52 | 0.0000 | |
60 | 0 | 61 | PromoteGoods | 86 | 仅售35元!原价70元的西夏部落酱香羊蝎子+养生八宝茶 | FW_100324045629 | 10 | 40 | 20.0000 | 80.0000 | 4 | 1 | 0.0000 | 1283540153 | 0 | 4 | 0.2000 | 52 | 0.0000 | |
61 | 0 | 62 | PromoteGoods | 86 | 仅售35元!原价70元的西夏部落酱香羊蝎子+养生八宝茶 | FW_100324045629 | 10 | 10 | 20.0000 | 20.0000 | 1 | 1 | 0.0000 | 1283540169 | 0 | 0 | 0.2000 | 52 | 0.0000 | |
62 | 0 | 63 | PromoteGoods | 88 | 仅售50元!原价100元的梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 55.0000 | 110.0000 | 尺寸:12 颜色:红 | 2 | 0 | 0.0000 | 1283541143 | 0 | 0 | 1000.0000 | 54 | 0.0000 |
63 | 0 | 64 | PromoteGoods | 88 | 仅售50元!原价100元的梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 55.0000 | 55.0000 | 尺寸:12 颜色:红 | 1 | 0 | 0.0000 | 1283541264 | 0 | 0 | 1000.0000 | 52 | 0.0000 |
64 | 0 | 65 | PromoteGoods | 87 | 仅售12元!乐淘网上鞋城80元现金消费券 | FW_100328011523 | 0 | 0 | 12.0000 | 12.0000 | 1 | 0 | 0.0000 | 1370674400 | 0 | 0 | 0.0000 | 56 | 0.0000 | |
65 | 0 | 66 | PromoteGoods | 88 | 梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 55.0000 | 55.0000 | 尺寸:12 颜色:红 | 1 | 0 | 0.0000 | 1371229155 | 0 | 0 | 1000.0000 | 55 | 0.0000 |
66 | 0 | 66 | PromoteGoods | 88 | 梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 58.0000 | 116.0000 | 尺寸:13 颜色:蓝 | 2 | 0 | 0.0000 | 1371229155 | 0 | 0 | 1000.0000 | 55 | 0.0000 |
67 | 0 | 66 | PromoteGoods | 87 | 仅售12元!乐淘网上鞋城80元现金消费券 | FW_100328011523 | 0 | 0 | 12.0000 | 12.0000 | 1 | 0 | 0.0000 | 1371229155 | 0 | 0 | 0.0000 | 55 | 0.0000 | |
68 | 0 | 67 | PromoteGoods | 87 | 仅售12元!乐淘网上鞋城80元现金消费券 | FW_100328011523 | 0 | 0 | 12.0000 | 12.0000 | 1 | 0 | 0.0000 | 1371230650 | 0 | 0 | 0.0000 | 55 | 0.0000 | |
69 | 0 | 68 | PromoteGoods | 88 | 梵雅葡萄酒品尝套餐 | FW_100328093136 | 0 | 0 | 56.0000 | 280.0000 | 尺寸:13 颜色:红 | 5 | 0 | 0.0000 | 1371653324 | 0 | 0 | 1000.0000 | 55 | 0.0000 |
select * from fanwe_goods;
数据库查询结果 [ 返回5条查询记录 耗时:0.000528s ]
id | name_1 | sn | cate_id | city_id | suppliers_id | click_count | cost_price | shop_price | market_price | promote_price | promote_begin_time | promote_end_time | create_time | update_time | type_id | goods_type | stock | brief_1 | brand_id | is_best | is_hot | is_new | status | sort | seokeyword_1 | seocontent_1 | goods_desc_1 | small_img | big_img | origin_img | define_small_img | is_define_small_img | is_inquiry | weight | spec_type | weight_unit | score | web_reviews | goods_reviews | min_user_time | special_note | max_bought | is_group_fail | complete_time | buy_count | group_user | user_count | earnest_money | group_bond_end_time | expand1 | expand2 | expand3 | expand4 | goods_show_name | u_name | referrals | close_referrals | goods_short_name | fail_buy_count | free_delivery_amount | allow_combine_delivery | allow_sms | virtual_count | score_goods | is_preview | all_show | extend_cate_id | is_order_sms | is_first_referral | referral_money | fix_delivery_money | no_api | no_show_index | bond_pw_prefix | interval_time | interval_num | bond_sn_prefix | seo_title | shelves_price | profit | quan_id |
86 | 仅售35元!原价70元的西夏部落酱香羊蝎子+养生八宝茶 | FW_100324045629 | 40 | 2 | 5 | 14 | 0.0000 | 20.0000 | 48.0000 | 20.0000 | 1300953600 | 1364371200 | 1269392189 | 1330556847 | 1 | 0 | 1000 | 别再让身体高负荷运转啦,用老祖宗的经络调理法,好好调理你的革命本钱吧! | 0 | 0 | 0 | 0 | 1 | 1 |
【详情】凭券享受西夏部落特色餐厅招牌菜:酱香羊蝎子(原价50元)+宁夏养生八宝茶(原价20元)。 【店家】来自银川的正宗西北菜馆。身为中餐高级烹调技师、银川市烹饪协会副会长的马彪师傅亲自担任主厨。 【食材】为做出原汁原味的西北菜,店家采用的牛羊肉和调料等都是从银川空运过来的。 【酱香羊蝎子】新推出的特色菜,精选鲜美的羊大梁制成。不同于北京传统的羊蝎子做法,没有药材味儿,而是更多地保持了羊肉本身的鲜味及酱香味。 【养生八宝茶】最受欢迎的饮品,口味酸甜,用料精而足,加三四次水都不会变淡。虽叫八宝茶,却是由大枣、沙枣、酸枣、核桃、枸杞、山楂、桂圆等14种原料配成,有很好的补血养气功效。如果喝不完,还可以打包带走哦! 特别提示
|
/Public/upload/goods/small/201003/4ba9dc4902560.jpg | /Public/upload/goods/big/201003/4ba9dc4902560.jpg | /Public/upload/goods/origin/201003/4ba9dc4902560.jpg | 0 | 1 | 0.2000 | 4 | 0 |
走进西夏部落,十来米的走廊两侧挂满了描绘西夏风情的图画和装饰品,仿佛回到了遥远的游牧民族部落,可以豪情万丈地大碗喝酒、大口吃肉。 除了酱香羊蝎子,店家的辣爆羊羔肉是用只喝母羊乳汁、还没有开始吃青草的小羊做成,可见肉质之鲜嫩。糊辣羊蹄、手抓羊肉、羊肉臊子面、酸菜羊肉等地道西北菜式,也都倍受食客称赞。 |
西夏部落餐厅在“大众点评网”上被评为四星半,人均消费42元。 | 0 | 50 | 2 | 1283540153 | 6 | 5 | 3 | 0.0000 | 0 | 0 | 0 | 0 | 40.0000 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | |||||||||||||||
87 | 仅售12元!乐淘网上鞋城80元现金消费券 | FW_100328011523 | 40 | 1 | 5 | 10 | 10.0000 | 12.0000 | 80.0000 | 12.0000 | 1301040000 | 1382947200 | 1269681323 | 1370674251 | 1 | 0 | 1000 | 专柜大牌,正品新货!低价折扣,运费全免,再减现金!你不来一双? | 0 | 0 | 0 | 0 | 1 | 2 |
【详情】凭现金消费券可在 【使用】在美团购买成功后,您将在我的订单得到乐淘网现金消费券号码。在乐淘网尽情选购之后,最后在“结算”页面,点击商品列表下方的“使用消费券”,将您的消费券号码复制过去,即可成功充抵现金。 【店家】乐淘网是国内大型网上鞋城,注册会员超过40万人。所售商品均为一线知名品牌,来源于正规渠道,保证正品。更多问题答疑请浏览乐淘网帮助中心。 【购买】乐淘网支持四种付款方式:支付宝、财付通、网上银行支付、货到付款。配送可以选择:宅急送、EMS两种空运快递,目前全场免运费。 【签收】请在检验外包装和封条完好、商品正确的情况下签收,如有意外情况请致电乐淘客服:400-600-5252。选择宅急送快递,还可以先试穿、后签收,如果对商品不满意或鞋码不合适,可以直接拒收,无需承担任何费用。 【售后】乐淘网上所有商品均享受“三包”服务。如因鞋码不合适或其他原因需要退换货,乐淘网将承担来回运费。 特别提示
|
/Public/upload/goods/small/201003/4bae3d279f75c.jpg | /Public/upload/goods/big/201003/4bae3d279f75c.jpg | /Public/upload/goods/origin/201003/4bae3d279f75c.jpg | 0 | 0 | 0.0000 | 5 | 0 |
乐淘网是专营运动鞋、休闲鞋、时尚皮鞋的B2C购物网站,采取垂直经营的方式,与一线大牌深度合作,款式与专柜同步,每月增加数百款新品。即使专柜不打折的新款,在乐淘也能享受7折甚至更低的价格,其他款式更低至2-5折,算下来节省的费用很可观。现在再使用现金消费券,又能省下一成以上的折扣! 大家都知道网络购物的方便快捷,而乐淘在方便快捷之外,还做到了令人信任、放心。可靠的供货商、严格的包装、快速的物流,让送到你手上的鞋子和专柜买来的完全一样,免费退换货的政策,更让你不必担心号码不合适,不必担心实物和图片可能会有差异! |
0 | 10 | 2 | 1283539885 | 6 | 5 | 2 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | ||||||||||||||||
88 | 仅售50元!原价100元的梵雅葡萄酒品尝套餐 | FW_100328093136 | 40 | 1 | 6 | 5 | 0.0000 | 50.0000 | 100.0000 | 50.0000 | 1301040000 | 1382947200 | 1269754296 | 1330556823 | 0 | 1 | 900000000 |
有人拿红酒当附庸风雅,有人根本就没喝出葡萄酒的好,但用两顿快餐的钱,花点儿时间了解一下葡萄酒的基本知识也没什么不好,至少那些人谈及的时候,你心里有谱~ |
0 | 0 | 0 | 0 | 1 | 3 |
特别提示
|
/Public/upload/goods/small/201003/4baf5a5c34824.jpg | /Public/upload/goods/big/201003/4baf5a5c34824.jpg | /Public/upload/goods/origin/201003/4baf5a5c34824.jpg | 0 | 0 | 1000.0000 | 5 | 0 |
在如今这个节奏快到让人窒息的时代,悠闲似乎早已成为一种遥不可及的奢侈。但好在我们有很多方法可以让有限的生活变得更精致一些、更惬意一些,比如红酒。 轻轻晃动手中高脚杯,眼前映着深亮的红宝石色泽,轻嗅成熟果实的气息和植物新鲜的清香,或有经过烘培的橡木味,繁香四溢,恍如置身于阳光明艳的葡萄庄园。就让自己迷醉在馥郁丰醇的酒香中,慢慢享用时光的佳酿吧。 |
0 | 100000000 | 2 | 1283538928 | 7 | 5 | 3 | 0.0000 | 1388217600 | 0 | 0 | 梵雅葡萄酒品尝套餐 | 0 | 0.0000 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | |||||||||||||||
89 | 测试商品商品名称 | 商品货号: | 0 | 1 | 0 | 0 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 1371655860 | 1372951860 | 1371655929 | 1371655929 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 0.0000 | 5 | 0 | 0 | 0 | 2 | 1371655860 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0 | 品缩略名 | 0 | 0.0000 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 | |||||||||||||||||||||
90 | 不返利商品名称: | FW_1371656061 | 41 | 1 | 1 | 0 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 1371656040 | 1372952040 | 1371656061 | 1371656157 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 0 | 0.0000 | 5 | 0 | 0 | 0 | 2 | 1371656040 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 1 | 0 | 0.0000 | 0 | 1 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0.0000 | 0.0000 | 0 | 0 | 0 | 0 | 0.0000 | 0.0000 | 0 |