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 12924 0 0 3552167943000 4311290000 274850000 1917211000000 12895 1 77457 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-22 12:46:01.100477 2024-06-22 12:52:03.974632
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 39 0 4 1595563376000 509633789000 40911881000 15283000000 130 3 666 17 0 0 104 0 2407 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-22 12:46:01.098172 2024-06-22 12:52:04.032380
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 991 0 0 1072056207000 3692584000 1081792000 119280000000 1855 2 41912 42 0 0 977 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-22 12:46:02.032799 2024-06-22 12:52:04.319461
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... sys * 1269 0 0 913252633000 10213337000 719663000 492906000000 2444 2 84341 66 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2024-06-22 12:46:01.182550 2024-06-22 12:46:19.904058
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 1538 0 12 857050157000 3875291000 557249000 306628000000 16591 11 103380 67 0 0 3347 0 28084 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:46:01.267543 2024-06-22 12:52:02.844822
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1476 0 0 800494030000 3098711000 542340000 287081000000 13016 9 88261 60 0 0 3321 0 23818 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:46:02.447774 2024-06-22 12:52:01.948170
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 289 0 0 781980968000 113034852000 2705816000 103646000000 525 2 11521 40 0 0 289 0 525 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:46:01.145085 2024-06-22 12:52:02.826616
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 738 0 0 744067513000 5517593000 1008221000 266851000000 38022 52 192324 261 0 0 738 0 38022 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:46:02.255299 2024-06-22 12:52:01.820231
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 644 0 0 613801114000 3817488000 953107000 281996000000 17198 27 89210 139 0 0 562 0 16846 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:46:01.111842 2024-06-22 12:52:02.827681
SHOW SESSION VARIABLES LIKE ? performance_schema * 739 0 0 608058015000 2585990000 822811000 66441000000 739 1 424186 574 0 0 739 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-22 12:46:02.243756 2024-06-22 12:52:04.727396
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... sys * 2425 0 0 591594826000 2755796000 243956000 139059000000 2425 1 419525 173 0 0 2425 0 0 0 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... 2024-06-22 12:46:01.535011 2024-06-22 12:46:19.907231
CREATE TABLE `rental_base` ( `id` INTEGER PRIMARY ... ProtoSA 1 0 0 540240084000 540240084000 540240084000 480000000 0 0 0 0 0 0 0 0 0 0 3ad47f892d9885195e044f6d31c94aa014524c69e8b22976ae... 2024-06-22 12:47:00.699963 2024-06-22 12:47:00.699963
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 1450 0 0 508226227000 2478705000 350500000 222598000000 6447 4 40356 28 0 0 1321 0 10078 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:46:01.377324 2024-06-22 12:52:04.289641
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 67 0 0 441760855000 382138814000 6593445000 20265000000 748 11 3299 49 0 0 2 0 202 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:46:04.203014 2024-06-22 12:52:01.022563
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 45 0 0 420782493000 104417342000 9350722000 14773000000 104 2 1237 27 0 0 45 0 104 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:46:10.173508 2024-06-22 12:51:02.799164
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 577 0 0 371557845000 41626409000 643947000 194068000000 52 0 3901 7 0 0 571 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:46:01.341953 2024-06-22 12:52:04.245954
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 369 0 0 366205799000 3666141000 992427000 164899000000 369 1 51391 139 0 0 369 0 369 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:46:02.252695 2024-06-22 12:52:01.808176
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 527 0 0 353776403000 2605330000 671302000 181807000000 7060 13 33661 64 0 0 287 0 5414 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:46:01.344054 2024-06-22 12:52:04.245200
SHOW TABLES FROM `phpmyadmin` NULL 1620 1620 0 352220257000 1068862000 217419000 143038000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-22 12:46:01.013838 2024-06-22 12:52:04.705091
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 355 0 0 333414704000 14640276000 939196000 141184000000 4978 14 48521 137 0 0 193 0 4978 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:46:01.175306 2024-06-22 12:52:02.858074
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila * 34 0 0 302800596000 209287507000 8905899000 16879000000 210 6 2307 68 0 0 28 0 210 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:46:10.456578 2024-06-22 12:51:02.796797
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 386 0 0 300133823000 4778920000 777548000 102556000000 4368 11 27427 71 0 0 901 0 8222 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:46:09.703725 2024-06-22 12:51:58.524154
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 425 0 0 282252164000 2486244000 664122000 96725000000 425 1 1700 4 0 0 2975 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-06-22 12:46:01.291299 2024-06-22 12:52:02.859135
SHOW SESSION VARIABLES LIKE ? mysql * 332 0 0 278258082000 2593618000 838126000 29711000000 332 1 190568 574 0 0 332 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-22 12:46:01.108568 2024-06-22 12:52:00.925574
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 756 0 0 276280492000 800143000 365450000 154658000000 0 0 2268 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-22 12:46:02.248694 2024-06-22 12:52:01.809808
Query results operations