Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafelahore »Table: tbl_purchases
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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (5265 total, Query took 0.0156 seconds.) [id: 11480... - 11456...]
SELECT * FROM `tbl_purchases` ORDER BY `id`  DESC 
Full texts id_noid Descending Ascending 1hashsupplier_idcrdrdetailstransporttypepost_datepost_timestatusMethodPaidBylast_updated
5294 11480 5878a7ab84fb43402106c575658472fa 76 2310 0 11480 0 Pending 2025-03-16 03:16:21 1 Pending
5293 11479 5737034557ef5b8c02c0e46513b98f90 76 1980 0 11479 0 Pending 2025-03-16 03:16:03 1 Pending
5292 11478 e46de7e1bcaaced9a54f1e9d0d2f800d 76 3480 0 11478 0 Pending 2025-03-16 03:15:50 1 Pending
5291 11477 00411460f7c92d2124a67ea0f4cb5f85 76 3000 0 11477 0 Pending 2025-03-16 03:15:29 1 Pending
5290 11476 6da9003b743b65f4c0ccd295cc484e57 76 2170 0 11476 0 Pending 2025-03-16 03:15:10 1 Pending
5289 11475 7f6ffaa6bb0b408017b62254211691b5 73 650 650 11475 0 Paid 2025-03-16 03:12:59 1 From Restaurant Cash
5288 11474 1efa39bcaec6f3900149160693694536 12 60000 0 11474 0 Pending 2025-03-16 03:12:20 1 Pending
5287 11473 66f041e16a60928b05a7e228a89c3799 4 11000 11000 11473 0 Paid 2025-03-16 03:11:45 1 From Restaurant Cash
5286 11472 3e89ebdb49f712c7d90d1b39e348bbbf 9 15606 15606 11472 0 Paid 2025-03-16 03:11:24 1 From Restaurant Cash
5285 11471 f5deaeeae1538fb6c45901d524ee2f98 16 3000 3000 11471 0 Paid 2025-03-16 03:10:51 1 From Restaurant Cash
5284 11470 3ad7c2ebb96fcba7cda0cf54a2e802f5 4 1842 1842 11470 0 Paid 2025-03-16 03:09:37 1 From Restaurant Cash
5283 11469 57aeee35c98205091e18d1140e9f38cf 11 11600 0 11469 0 Pending 2025-03-16 03:09:15 1 Pending
5282 11468 bbcbff5c1f1ded46c25d28119a85c6c2 76 560 0 11468 0 Pending 2025-03-16 03:08:19 1 Pending
5281 11467 6faa8040da20ef399b63a72d0e4ab575 85 330 0 11467 0 Pending 2025-03-16 03:07:54 1 Pending
5280 11466 64223ccf70bbb65a3a4aceac37e21016 1 5500 0 11466 0 Pending 2025-03-16 03:07:40 1 Pending
5279 11465 7e7757b1e12abcb736ab9a754ffb617a 94 2000 0 11465 0 Pending 2025-03-16 03:07:24 1 Pending
5278 11464 ae0eb3eed39d2bcef4622b2499a05fe6 9 31245 0 11464 0 Pending 2025-03-16 03:07:03 1 Pending
5277 11463 dd458505749b2941217ddd59394240e8 6 3000 3000 11463 0 Paid 2025-03-15 02:42:35 1 From Restaurant Cash
5276 11462 f4552671f8909587cf485ea990207f3b 4 1200 1200 11462 0 Paid 2025-03-15 02:42:23 1 From Restaurant Cash
5275 11461 faa9afea49ef2ff029a833cccc778fd0 22 23760 0 11461 0 Pending 2025-03-15 02:42:00 1 Pending
5274 11460 093f65e080a295f8076b1c5722a46aa2 35 17200 0 11460 0 Pending 2025-03-15 02:41:39 1 Pending
5273 11459 ac1dd209cbcc5e5d1c6e28598e8cbbe8 27 28327 0 11459 0 Pending 2025-03-15 02:39:35 1 Pending
5272 11458 b55ec28c52d5f6205684a473a2193564 1 3300 0 11458 0 Pending 2025-03-15 02:38:55 1 Pending
5271 11457 428fca9bc1921c25c5121f9da7815cde 85 440 0 11457 0 Pending 2025-03-15 02:38:38 1 Pending
5270 11456 4f6ffe13a5d75b2d6a3923922b3922e5 68 2090 0 11456 0 Pending 2025-03-15 02:38:23 1 Pending