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` .... performance_schema 25737 25382 0 5095215841000 2589589000 197972000 76879000000 0 0 1065 0 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.774360 2024-07-30 15:55:13.723091
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 10949 10780 0 4623837221000 6051194000 422306000 78022000000 169 0 69290 6 0 0 169 0 169 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.780826 2024-07-30 15:55:13.719638
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 20479 19526 0 4245573354000 2368074000 207313000 208817000000 0 0 2859 0 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.797175 2024-07-30 15:55:13.117392
SHOW SESSION VARIABLES LIKE ? performance_schema * 3989 0 0 3447295418000 7142740000 864200000 343430000000 3989 1 2289686 574 0 0 3989 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.767319 2024-07-30 15:55:13.716527
SHOW SESSION VARIABLES LIKE ? mysql * 3585 0 0 3113079616000 3277779000 868362000 306128000000 3585 1 2057790 574 0 0 3585 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.794602 2024-07-30 15:55:13.094784
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 7031 6825 0 3066999202000 22004717000 436210000 96224000000 366 0 83998 12 0 0 201 0 366 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.928517 2024-07-30 15:55:13.116946
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 8872 7974 5 2199874422000 4487931000 247956000 212009000000 7887 1 50795 6 0 0 2008 0 13830 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:23.042381 2024-07-30 15:55:13.105055
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 7975 7303 0 1942546348000 43397788000 243579000 154558000000 5544 1 37128 5 0 0 1512 0 10080 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.856991 2024-07-30 15:55:12.947942
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 4111 3692 0 1813692438000 4153629000 441180000 167563000000 20879 5 106940 26 0 0 409 0 20859 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.798478 2024-07-30 15:55:13.050816
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 3988 3651 0 1663567221000 5450163000 417143000 135120000000 21848 5 110251 28 0 0 337 0 21848 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.784214 2024-07-30 15:55:13.721495
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 3381 3180 0 1233959756000 88295518000 364968000 78384000000 402 0 13264 4 0 0 201 0 402 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.887076 2024-07-30 15:55:13.040321
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 3821 3652 0 1224513864000 1706942000 320469000 59938000000 501 0 2849 1 0 0 169 0 501 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.785969 2024-07-30 15:55:13.723668
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 2269 0 0 1129335233000 7830798000 497723000 391060000000 2269 1 6930 3 0 0 15883 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.080399 2024-07-30 15:55:13.118172
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema * 1994 0 0 973018490000 2966889000 487973000 332516000000 1994 1 6019 3 0 0 13958 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:22.892705 2024-07-30 15:55:12.964640
SHOW TABLES FROM `phpmyadmin` NULL 5475 5475 0 908397287000 1721021000 165917000 365641000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-07-30 15:46:22.742646 2024-07-30 15:55:13.709737
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 1475 1339 0 860172873000 3270359000 583168000 77199000000 3400 2 34119 23 0 0 40 0 3400 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:23.490633 2024-07-30 15:55:13.018788
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 5077 0 0 697054187000 16921702000 137296000 339197000000 5077 1 5077 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2024-07-30 15:46:22.759702 2024-07-30 15:55:13.729626
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 2196 1854 0 632180790000 2120368000 287878000 83746000000 3358 2 22026 10 0 0 788 0 6240 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.955636 2024-07-30 15:55:13.002281
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema * 1746 0 0 524729217000 9538470000 300532000 69419000000 1746 1 0 0 0 0 0 0 0 0 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... 2024-07-30 15:46:22.781688 2024-07-30 15:55:13.720121
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema * 1746 0 0 511230187000 4050134000 292800000 120805000000 43650 25 43650 25 0 0 0 0 0 0 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... 2024-07-30 15:46:22.771102 2024-07-30 15:55:13.717309
SELECT @@`version` , @@`version_comment` NULL 5475 0 0 464259293000 3450035000 84796000 0 5475 1 5475 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2024-07-30 15:46:22.741459 2024-07-30 15:55:13.709193
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 849 0 0 424688355000 2581576000 500221000 152256000000 849 1 2640 3 0 0 5943 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.010450 2024-07-30 15:55:13.016213
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql * 2014 0 0 385862851000 1373461000 191590000 103893000000 2014 1 248998 124 0 0 2014 0 0 0 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... 2024-07-30 15:46:23.085450 2024-07-30 15:55:13.118662
SHOW CREATE TABLE `performance_schema` . `table_lo... performance_schema 1746 0 0 377602927000 1432369000 216267000 0 0 0 0 0 0 0 0 0 0 0 bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... 2024-07-30 15:46:22.788494 2024-07-30 15:55:13.724606
SHOW CREATE TABLE `mysql` . `user` mysql 2014 0 0 371762554000 4357902000 184589000 0 0 0 0 0 0 0 0 0 0 0 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... 2024-07-30 15:46:22.889266 2024-07-30 15:55:13.040670
Query results operations