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 `stock_logs` ORDER BY `type` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id branch_id product_id change_qty cost_price current_stock type Descending Ascending 1 reason reference reference_id note user_id created_at
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 13313
13313 8 1278 6 0.00 0 void void ORD-2026-3814 NULL NULL NULL 2026-05-09 15:17:27
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8965
8965 12 1473 1 0.00 11 void void ORD-2026-2220 NULL NULL 7 2026-05-02 19:20:32
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8966
8966 12 1178 1 0.00 169 void void ORD-2026-2220 NULL NULL 7 2026-05-02 19:20:32
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8476
8476 8 1158 15 0.00 21 void void ORD-2026-1965 NULL NULL 7 2026-05-02 14:11:17
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8477
8477 8 1491 25 0.00 42 void void ORD-2026-1965 NULL NULL 7 2026-05-02 14:11:17
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 11293
11293 8 990 2 0.00 2 void void ORD-2026-3120 NULL NULL 1 2026-05-06 16:19:30
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 15133
15133 8 1140 1 0.00 0 void void ORD-2026-4453 NULL NULL NULL 2026-05-12 20:31:05
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8478
8478 8 1178 6 0.00 47 void void ORD-2026-1965 NULL NULL 7 2026-05-02 14:11:17
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 11294
11294 8 1188 1 0.00 12 void void ORD-2026-3120 NULL NULL 1 2026-05-06 16:19:30
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 15134
15134 8 1178 1 0.00 0 void void ORD-2026-4453 NULL NULL NULL 2026-05-12 20:31:05
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8479
8479 8 1183 1 0.00 7 void void ORD-2026-1965 NULL NULL 7 2026-05-02 14:11:17
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 11295
11295 8 1178 1 0.00 59 void void ORD-2026-3120 NULL NULL 1 2026-05-06 16:19:30
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 9504
9504 8 1182 1 0.00 8 void void ORD-2026-2471 NULL NULL 1 2026-05-03 11:21:52
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 9505
9505 8 1182 1 0.00 9 void void ORD-2026-2472 NULL NULL 1 2026-05-03 11:26:27
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 9507
9507 8 1136 1 0.00 17 void void ORD-2026-2445 NULL NULL 1 2026-05-03 11:44:33
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 9508
9508 8 1278 1 0.00 15 void void ORD-2026-2445 NULL NULL 1 2026-05-03 11:44:33
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8742
8742 9 1195 1 0.00 17 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8743
8743 9 1278 6 0.00 31 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8744
8744 9 1200 1 0.00 8 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8745
8745 9 1268 1 0.00 6 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8746
8746 9 1224 2 0.00 20 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8747
8747 9 990 1 0.00 1 void void ORD-2026-2222 NULL NULL 7 2026-05-02 16:32:26
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8748
8748 9 1195 1 0.00 18 void void ORD-2026-2221 NULL NULL 7 2026-05-02 16:32:34
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8749
8749 9 1278 6 0.00 37 void void ORD-2026-2221 NULL NULL 7 2026-05-02 16:32:34
Edit Edit Copy Copy Delete Delete
DELETE FROM stock_logs WHERE `stock_logs`.`id` = 8750
8750 9 1200 1 0.00 9 void void ORD-2026-2221 NULL NULL 7 2026-05-02 16:32:34
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