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 31203 30848 0 6117592558000 4225598000 196057000 76879000000 0 0 1065 0 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.774360 2024-07-30 15:57:52.112319
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 13267 13098 0 5534051189000 6051194000 417129000 78022000000 169 0 69290 5 0 0 169 0 169 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.780826 2024-07-30 15:57:52.110245
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 24816 23863 0 5063087140000 2368074000 204025000 208817000000 0 0 2859 0 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.797175 2024-07-30 15:57:51.274197
SHOW SESSION VARIABLES LIKE ? performance_schema * 4775 0 0 4096665043000 7142740000 857940000 410570000000 4775 1 2740850 574 0 0 4775 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.767319 2024-07-30 15:57:52.092171
SHOW SESSION VARIABLES LIKE ? mysql * 4292 0 0 3695968625000 3277779000 861129000 364972000000 4292 1 2463608 574 0 0 4292 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.794602 2024-07-30 15:57:51.229711
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 8554 8348 0 3646192885000 22004717000 426255000 96224000000 366 0 83998 10 0 0 201 0 366 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.928517 2024-07-30 15:57:51.273871
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 10639 9741 5 2536454049000 4487931000 238410000 212009000000 7887 1 50795 5 0 0 2008 0 13830 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:23.042381 2024-07-30 15:57:51.246655
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 9547 8875 0 2235868643000 43397788000 234195000 154558000000 5544 1 37128 4 0 0 1512 0 10080 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.856991 2024-07-30 15:57:51.800006
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 4964 4545 0 2118914963000 4153629000 426856000 167563000000 20879 4 106940 22 0 0 409 0 20859 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.798478 2024-07-30 15:57:51.162861
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4775 4438 0 1927816220000 5450163000 403731000 135120000000 21848 5 110251 23 0 0 337 0 21848 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.784214 2024-07-30 15:57:52.111539
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4607 4438 0 1458464307000 1706942000 316575000 59938000000 501 0 2849 1 0 0 169 0 501 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.785969 2024-07-30 15:57:52.102051
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 4089 3888 0 1445891387000 88295518000 353605000 78384000000 402 0 13264 3 0 0 201 0 402 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.887076 2024-07-30 15:57:51.147010
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 2722 0 0 1334994393000 7830798000 490446000 461466000000 2722 1 8289 3 0 0 19054 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.080399 2024-07-30 15:57:51.274790
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema * 2387 0 0 1151407776000 2966889000 482366000 393548000000 2387 1 7198 3 0 0 16709 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:22.892705 2024-07-30 15:57:51.813065
SHOW TABLES FROM `phpmyadmin` NULL 6499 6499 0 1115248757000 1721021000 171603000 449503000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-07-30 15:46:22.742646 2024-07-30 15:57:52.103056
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 1772 1636 0 1046527950000 3270359000 590591000 77199000000 3400 2 34119 19 0 0 40 0 3400 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:23.490633 2024-07-30 15:57:51.103324
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 6039 0 0 829718565000 16921702000 137393000 402095000000 6039 1 6039 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2024-07-30 15:46:22.759702 2024-07-30 15:57:52.117637
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 2528 2186 0 700503523000 2120368000 277097000 83746000000 3358 1 22026 9 0 0 788 0 6240 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.955636 2024-07-30 15:57:52.044235
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema * 2087 0 0 624008280000 9538470000 298997000 80848000000 2087 1 0 0 0 0 0 0 0 0 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... 2024-07-30 15:46:22.781688 2024-07-30 15:57:52.095932
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema * 2087 0 0 608431198000 4050134000 291533000 143302000000 52175 25 52175 25 0 0 0 0 0 0 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... 2024-07-30 15:46:22.771102 2024-07-30 15:57:52.092970
SELECT @@`version` , @@`version_comment` NULL 6499 0 0 571845272000 3450035000 87989000 0 6499 1 6499 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2024-07-30 15:46:22.741459 2024-07-30 15:57:52.102645
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 972 0 0 484134217000 2581576000 498080000 173748000000 972 1 3009 3 0 0 6804 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.010450 2024-07-30 15:57:52.056398
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql * 2417 0 0 456088852000 1373461000 188700000 121788000000 2417 1 297761 123 0 0 2417 0 0 0 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... 2024-07-30 15:46:23.085450 2024-07-30 15:57:51.275084
SHOW CREATE TABLE `performance_schema` . `table_lo... performance_schema 2087 0 0 449520970000 1432369000 215390000 0 0 0 0 0 0 0 0 0 0 0 bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... 2024-07-30 15:46:22.788494 2024-07-30 15:57:52.103051
SHOW CREATE TABLE `mysql` . `user` mysql 2416 0 0 444244538000 4357902000 183876000 0 0 0 0 0 0 0 0 0 0 0 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... 2024-07-30 15:46:22.889266 2024-07-30 15:57:51.147379
Query results operations