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$statements_with_full_table_scans`
query db exec_count total_latency no_index_used_count no_good_index_used_count no_index_used_pct rows_sent rows_examined rows_sent_avg rows_examined_avg first_seen last_seen digest
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 1091 669761521000 1091 0 100 5649 34785 5 32 2024-06-15 22:01:02.074528 2024-06-15 22:10:43.229929 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 398 299561567000 398 0 100 398 1592 1 4 2024-06-15 22:01:02.783104 2024-06-15 22:10:43.807260 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 2 261013631000 2 0 100 2 2 1 1 2024-06-15 22:10:13.922789 2024-06-15 22:10:14.052672 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema 1 261002241000 1 0 100 25 25 25 25 2024-06-15 22:07:05.912261 2024-06-15 22:07:05.912261 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 440 204503823000 440 0 100 2458 15816 6 36 2024-06-15 22:01:03.831078 2024-06-15 22:10:45.843415 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 348 196983553000 348 0 100 348 1392 1 4 2024-06-15 22:01:02.118241 2024-06-15 22:10:43.243998 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... NULL 93 173317989000 93 0 100 25296 29109 272 313 2024-06-15 22:01:02.217732 2024-06-15 22:10:29.172749 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql 89 153057025000 89 0 100 24208 27857 272 313 2024-06-15 22:01:06.536429 2024-06-15 22:10:43.709142 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 5 141239264000 5 0 100 5 293 1 59 2024-06-15 22:01:02.603117 2024-06-15 22:04:35.848243 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT ? FROM `INFORMATION_SCHEMA` . `USER_PRIVILE... mysql 244 110067925000 244 0 100 244 35624 1 146 2024-06-15 22:01:02.789966 2024-06-15 22:10:43.807695 2c1d854eee39224e5fcace996a044c9d7b1a5c62507f079689...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 111 105237465000 111 0 100 111 14036 1 126 2024-06-15 22:01:03.681544 2024-06-15 22:10:45.709710 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT * FROM `film` LIMIT ?, ... sakila 4 72417600000 4 0 100 100 100 25 25 2024-06-15 22:01:02.497690 2024-06-15 22:04:35.846202 bc7c7ea1ea0ee83136859c20a5bac2bb70630a0a8e5c8313da...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... NULL 361 71842926000 361 0 100 361 62453 1 173 2024-06-15 22:01:02.118667 2024-06-15 22:10:43.245043 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... mysql 100 66631085000 100 0 100 0 10624 0 106 2024-06-15 22:01:04.604742 2024-06-15 22:09:39.814224 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 110 58578484000 110 0 100 110 440 1 4 2024-06-15 22:01:03.867198 2024-06-15 22:10:45.854387 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... DB_Orman 197 40974296000 197 0 100 197 34081 1 173 2024-06-15 22:05:38.110414 2024-06-15 22:10:40.911685 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... DB_Orman 87 40211254000 87 0 100 87 348 1 4 2024-06-15 22:05:38.109980 2024-06-15 22:10:40.910883 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... mysql 90 39457405000 90 0 100 3690 7380 41 82 2024-06-15 22:01:06.534262 2024-06-15 22:10:43.704384 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... NULL 93 38625174000 93 0 100 3813 7626 41 82 2024-06-15 22:01:02.212815 2024-06-15 22:10:29.171484 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL 28 33110386000 28 0 100 0 2206 0 79 2024-06-15 22:02:21.924207 2024-06-15 22:10:39.393365 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 56 27442848000 56 0 100 56 224 1 4 2024-06-15 22:01:02.671959 2024-06-15 22:10:29.368649 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM `information_schema` . `INNODB_TABLE... information_schema 1 23489561000 1 0 100 1 1 1 1 2024-06-15 22:02:04.986096 2024-06-15 22:02:04.986096 181a8e6a0d3d74e22e9532a90123c80c19818d6e34edf03d05...
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema 65 21966764000 65 0 100 1625 1625 25 25 2024-06-15 22:01:04.368421 2024-06-15 22:10:45.707309 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 44 21913707000 44 0 100 221 1459 5 33 2024-06-15 22:01:47.139873 2024-06-15 22:10:16.165695 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... pw 18 19699352000 18 0 100 4896 5634 272 313 2024-06-15 22:04:11.813428 2024-06-15 22:05:28.913932 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
Query results operations