Drop files here

SQL upload ( 0 ) x -

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:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling 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 `x$statement_analysis`
query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 41931 0 0 10515685901000 3255051000 250785000 5621663000000 41862 1 251379 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-23 04:00:48.225539 2024-06-23 04:12:36.118806
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 63 0 18 1356403306000 89713940000 21530211000 30142000000 284 5 939 15 0 0 168 0 3729 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-23 04:01:35.948912 2024-06-23 04:12:28.210397
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 1105 0 0 1104170370000 2500632000 999249000 126046000000 1721 2 46411 42 0 0 1090 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-23 04:00:49.883714 2024-06-23 04:12:44.968007
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 2393 0 0 871563946000 1800729000 364213000 358726000000 12502 5 79011 33 0 0 2567 0 20242 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:00:49.027492 2024-06-23 04:12:58.753746
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 790 0 0 828496909000 2571293000 1048730000 277829000000 47954 61 242140 307 0 0 790 0 47954 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-23 04:00:48.210835 2024-06-23 04:12:59.624268
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1580 0 0 826714158000 2192959000 523236000 293085000000 14017 9 94871 60 0 0 3555 0 25664 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:00:48.366357 2024-06-23 04:12:59.769309
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema * 5 0 0 764329792000 600166411000 152865958000 319000000 125 25 125 25 0 0 5 5 0 0 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c... 2024-06-23 04:01:49.234740 2024-06-23 04:09:21.384543
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 1001 0 0 687137512000 3415017000 686451000 336858000000 13794 14 72115 72 0 0 538 0 10540 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-23 04:00:48.934995 2024-06-23 04:12:58.712991
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 1073 0 0 678360325000 48659983000 632209000 366055000000 52 0 5389 5 0 0 1067 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-23 04:00:48.936095 2024-06-23 04:12:58.713754
SHOW SESSION VARIABLES LIKE ? performance_schema * 790 0 0 661112636000 9266727000 836851000 76935000000 790 1 453460 574 0 0 790 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-23 04:00:48.187600 2024-06-23 04:12:59.755224
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 6 0 0 613722890000 461814205000 102287148000 1619000000 52 9 37392 6232 0 0 34 4 2400 4 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-23 04:03:09.714349 2024-06-23 04:04:35.577758
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 260 0 0 603759541000 69105599000 2322152000 90924000000 439 2 6400 25 0 0 260 0 439 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-23 04:00:53.218540 2024-06-23 04:12:57.615996
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 117 0 0 597335568000 408962214000 5105432000 46990000000 213 2 48215 412 0 0 115 0 213 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:00:53.335075 2024-06-23 04:12:57.627148
SHOW SESSION VARIABLES LIKE ? information_schema * 602 0 0 479855033000 1559448000 797101000 52527000000 602 1 345548 574 0 0 602 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-23 04:00:48.929160 2024-06-23 04:12:58.742536
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 395 0 0 477454096000 9292415000 1208744000 174965000000 395 1 162612 412 0 0 395 0 395 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:00:48.207387 2024-06-23 04:12:59.612308
CREATE TABLE `Authors` ( `author_id` INTEGER (?) N... videoGames 2 0 4 442137284000 236198097000 221068642000 2596000000 0 0 0 0 0 0 0 0 0 0 c84c5a33ee0d904e4076fc55081376fe99d8eb44d6a1d4a435... 2024-06-23 04:03:23.089818 2024-06-23 04:06:29.697682
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 12 0 4 426036624000 106260685000 35503052000 2141000000 43 4 43 4 0 0 36 8 3514 8 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... 2024-06-23 04:02:25.078551 2024-06-23 04:11:36.226471
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 862 0 4 415446181000 2165355000 481956000 153714000000 8819 10 51055 59 0 0 1508 0 12980 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:00:52.439604 2024-06-23 04:12:57.688416
SHOW TABLES FROM `phpmyadmin` NULL 1677 1677 0 382398471000 710244000 228025000 153995000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-23 04:00:48.147695 2024-06-23 04:13:00.546982
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 434 0 0 357120576000 4141308000 822858000 122644000000 5249 12 32820 76 0 0 1023 0 9940 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:00:53.121351 2024-06-23 04:12:56.157302
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 12 0 0 307053222000 52231994000 25587768000 3331000000 79 7 20216 1685 0 0 48 0 236 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-23 04:00:48.222766 2024-06-23 04:12:21.448811
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 814 0 0 303329771000 2827480000 372640000 167767000000 0 0 2442 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-23 04:00:48.197594 2024-06-23 04:12:59.613801
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila * 11 0 0 296540285000 208355197000 26958207000 5158000000 77 7 3970 361 0 0 9 0 77 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:01:09.625961 2024-06-23 04:12:27.039393
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 23 0 0 278954457000 59503148000 12128454000 7355000000 184 8 10592 461 0 0 1 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-23 04:01:42.771835 2024-06-23 04:12:42.131812
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 184 0 0 258576228000 19173373000 1405305000 118463000000 6918 38 24210 132 0 0 12 0 6918 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:00:49.804207 2024-06-23 04:12:51.687342
Query results operations