Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `order_items` ORDER BY `order_id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id order_id Descending Ascending 1 product_id product_name quantity price_per_unit subtotal cost_price total_price created_at kitchen_status item_key parent_id parent_key
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11959
11959 5547 1436 เพิ่มไข่ดาว 1 10.00 10.00 0.00 10.00 2026-05-14 23:39:58 pending NULL 11958 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11958
11958 5547 1495 test001 1 0.00 0.00 0.00 0.00 2026-05-14 23:39:58 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11957
11957 5546 1496 test ข้าว 1 0.00 0.00 0.00 0.00 2026-05-14 23:37:59 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11956
11956 5546 1496 test ข้าว 1 0.00 0.00 0.00 0.00 2026-05-14 23:37:59 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11955
11955 5545 1149 testน้ำ 1 0.00 0.00 0.00 0.00 2026-05-14 23:36:51 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11954
11954 5545 1495 test001 1 0.00 0.00 0.00 0.00 2026-05-14 23:36:51 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11953
11953 5545 1494 test 1 0.00 0.00 0.00 0.00 2026-05-14 23:36:51 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11952
11952 5545 1496 test ข้าว 1 0.00 0.00 0.00 0.00 2026-05-14 23:36:51 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11951
11951 5544 1496 test ข้าว 1 0.00 0.00 0.00 0.00 2026-05-14 23:34:11 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11950
11950 5544 1496 test ข้าว 1 0.00 0.00 0.00 0.00 2026-05-14 23:34:11 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11949
11949 5543 965 ทาโร่ รสซูเปอร์แซ่บ 1 30.00 30.00 0.26 30.00 2026-05-14 21:57:09 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11948
11948 5543 1091 เลย์แผ่นหยัก รสมันฝรั่ง 1 30.00 30.00 0.00 30.00 2026-05-14 21:57:09 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11947
11947 5543 1178 น้ำเปล่า Pomelo 1 25.00 25.00 0.90 25.00 2026-05-14 21:57:09 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11946
11946 5543 1357 มาม่ารสต้มยํากุ้งน้ําข้น 1 30.00 30.00 11.83 30.00 2026-05-14 21:57:09 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11945
11945 5542 938 ซันไบทส้รสบาร์บีคิว 1 30.00 30.00 16.99 30.00 2026-05-14 21:53:33 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11944
11944 5542 1357 มาม่ารสต้มยํากุ้งน้ําข้น 1 30.00 30.00 11.83 30.00 2026-05-14 21:53:33 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11943
11943 5541 1085 เลย์ สาหร่าย 1 30.00 30.00 0.39 30.00 2026-05-14 21:51:31 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11942
11942 5541 1357 มาม่ารสต้มยํากุ้งน้ําข้น 1 30.00 30.00 11.83 30.00 2026-05-14 21:51:31 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11941
11941 5540 1178 น้ำเปล่า Pomelo 1 25.00 25.00 0.90 25.00 2026-05-14 21:50:22 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11940
11940 5540 1490 ขนมจีบหมู (อาหลง) 5 10.00 50.00 0.00 50.00 2026-05-14 21:50:22 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11939
11939 5540 1357 มาม่ารสต้มยํากุ้งน้ําข้น 1 30.00 30.00 11.83 30.00 2026-05-14 21:50:22 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11938
11938 5539 1490 ขนมจีบหมู (อาหลง) 5 10.00 50.00 0.00 50.00 2026-05-14 21:48:20 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11937
11937 5539 1194 สไปร์ทกระป๋อง 1 30.00 30.00 14.44 30.00 2026-05-14 21:48:20 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11936
11936 5539 1361 มาม่าหมูสับ 1 30.00 30.00 11.83 30.00 2026-05-14 21:48:20 pending NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM order_items WHERE `order_items`.`id` = 11935
11935 5538 918 คอนเน่ข้าวโพด 1 30.00 30.00 16.01 30.00 2026-05-14 21:11:07 pending NULL NULL NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query