将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: gym »表: mbw_store_canyin_order"门店餐饮订单"
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 65 行, 查询花费 0.0009 秒。)
SELECT * FROM `mbw_store_canyin_order`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
行数：
过滤行:
按索引排序:

完整内容idstore_id门店idcustomer顾客order_no订单单号food_list菜单store_zhekouquan菜单折扣信息jianlouquan_list捡漏券列表store_manjianquan满减券列表eat_type就餐类型eat_time到店时间delivery_info配送信息remarks备注orig_price原价actual_price实际价格status0:未支付,1:代发货,2带收货,3.待评论,4.已评论,5.退款中,6.退款失败.7退款完成,add_time数据入库时间pay_time支付时间back_reason退款原因apply_back_time申请退款时间fz_time分账时间back_complate_time退款完成时间fz_status0:未分账,1:已分账fail_back_reasontypesend_nosend_timefz_blfz_day
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 1
1 144 2f6bc69e900dd5a63c515be6c16a7cce PHZPEJCNGJYMSYYARWFZ [{"id":175,"store_id":144,"category_id":94,"food_i... 0 [{"id":190,"store_id":144,"customer":"2f6bc69e900d... 0 type_in_store {"location":"","room_number":"","name":"","phone":... 10.00 1.00 1 1631953784 0 0 0 0 0 1 0 99 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 2
2 8 2f6bc69e900dd5a63c515be6c16a7cce FZTZ2C57SDNSQ2DSBKSY [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634806042 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 3
3 8 2f6bc69e900dd5a63c515be6c16a7cce HSG2GTCYGJNBCYDG3CPA [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634819954 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 4
4 8 2f6bc69e900dd5a63c515be6c16a7cce DBTTWW7RK6FEFMQTHGZ4 [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634820045 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 5
5 8 2f6bc69e900dd5a63c515be6c16a7cce XXPDINR65SA6NRSSTGZQ [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634820541 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 6
6 8 2f6bc69e900dd5a63c515be6c16a7cce Z3Z3SNI6FQYG6SRKBISP [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634820659 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 7
7 8 2f6bc69e900dd5a63c515be6c16a7cce EX33BMQQBYMQYRFMMZJW [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634821081 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 8
8 8 2f6bc69e900dd5a63c515be6c16a7cce 7A4TCTWSMIBYZAJDGXFJ [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634823116 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 9
9 8 2f6bc69e900dd5a63c515be6c16a7cce KDKWMJ8HZKRMSX8KX8WN [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634824069 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 11
11 8 2f6bc69e900dd5a63c515be6c16a7cce WWCZEBPDCZS3TFSBFJTK [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634824577 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 12
12 8 2f6bc69e900dd5a63c515be6c16a7cce XY6RTMGSNQJA65CHCFWW [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634824829 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 13
13 8 2f6bc69e900dd5a63c515be6c16a7cce IPNXZEDQD6GFYWCCXDST [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634824992 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 14
14 8 2f6bc69e900dd5a63c515be6c16a7cce 6WYYXSTCNTRDX3FKFZ7I [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634825105 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 15
15 8 2f6bc69e900dd5a63c515be6c16a7cce R5PFEPES4NC4YFQQYFYD [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634825275 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 16
16 8 2f6bc69e900dd5a63c515be6c16a7cce YBP3ZDCAYH4YSTE7CCM7 [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634825451 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 17
17 8 2f6bc69e900dd5a63c515be6c16a7cce NMXR36D3MNNBX3RJCQZS [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634873426 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 18
18 8 2f6bc69e900dd5a63c515be6c16a7cce KBNWW3JNJXSCMAWYE8M4 [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634874123 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 19
19 8 2f6bc69e900dd5a63c515be6c16a7cce MQEZFEMEHZEKAAKTNK4P [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634875299 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 20
20 8 2f6bc69e900dd5a63c515be6c16a7cce BPFAXGDYPTGCFAS4WZX8 [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634875469 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 21
21 8 2f6bc69e900dd5a63c515be6c16a7cce CCIAFNPECQAFDG2E46MI [{"id":176,"store_id":8,"category_id":95,"food_img... 0 0 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 1.00 1.00 3 1634875943 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 22
22 8 2f6bc69e900dd5a63c515be6c16a7cce HCRAXRWNFEJM6PBI8FH4 [{"id":14,"store_id":8,"category_id":6,"food_img":... 0 [{"id":197,"store_id":8,"customer":"2f6bc69e900dd5... 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 45.00 0.00 3 1635940956 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 23
23 8 2f6bc69e900dd5a63c515be6c16a7cce ZHKHP74HIX4D6B8DHAKA [{"id":14,"store_id":8,"category_id":6,"food_img":... 0 [{"id":198,"store_id":8,"customer":"2f6bc69e900dd5... 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 45.00 0.00 3 1635941008 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 24
24 8 2f6bc69e900dd5a63c515be6c16a7cce NC8ZREXZSWF5AAM4ZPYS [{"id":14,"store_id":8,"category_id":6,"food_img":... 0 [{"id":199,"store_id":8,"customer":"2f6bc69e900dd5... 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 45.00 0.00 3 1635941086 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 25
25 8 2f6bc69e900dd5a63c515be6c16a7cce 84A8JW7XZHFTTBGNS7ER [{"id":14,"store_id":8,"category_id":6,"food_img":... 0 [{"id":200,"store_id":8,"customer":"2f6bc69e900dd5... 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 45.00 0.00 3 1635941196 0 0 0 0 0 1 0 0 0
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_canyin_order` WHERE `mbw_store_canyin_order`.`id` = 26
26 8 2f6bc69e900dd5a63c515be6c16a7cce MC4RPJDZZS8WRRMWQRD4 [{"id":14,"store_id":8,"category_id":6,"food_img":... 0 [{"id":201,"store_id":8,"customer":"2f6bc69e900dd5... 0 type_retail {"location":"重庆市渝中区鲁祖庙11号2楼商铺洞府老火锅(解放碑总店)1楼508","n... 45.00 0.00 3 1635948951 0 0 0 0 0 1 0 0 0
选中项： 选中项：

|
|
|
|
行数：
过滤行:
按索引排序:
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出 显示图表 显示图表 新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
使用配置文件中定义的控制用户连接失败。