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_temp_tables`
query db exec_count total_latency memory_tmp_tables disk_tmp_tables avg_tmp_tables_per_query tmp_tables_to_disk_pct first_seen last_seen digest
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 9 1034040669000 27 6 3 22 2024-06-16 07:33:27.884774 2024-06-16 07:39:30.410720 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
SELECT `PLUGIN_NAME` , `PLUGIN_DESCRIPTION` FROM `... mysql 6 5055193000 6 6 1 100 2024-06-16 07:35:24.434321 2024-06-16 07:44:28.227763 da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a...
SELECT ? FROM `information_schema` . `INNODB_BUFFE... information_schema 4 69345604000 4 4 1 100 2024-06-16 07:33:50.808378 2024-06-16 07:42:29.145238 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 3 168020916000 9 2 3 22 2024-06-16 07:36:45.194707 2024-06-16 07:36:45.389334 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema 2 413573724000 2 2 1 100 2024-06-16 07:33:50.688255 2024-06-16 07:39:03.910561 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 1297 673731036000 2916 0 2 0 2024-06-16 07:31:04.230257 2024-06-16 07:44:51.161022 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema 324 177421802000 2268 0 7 0 2024-06-16 07:31:04.251950 2024-06-16 07:44:51.172928 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 988 607517914000 2024 0 2 0 2024-06-16 07:31:03.483561 2024-06-16 07:44:54.036854 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 888 594284295000 2004 0 2 0 2024-06-16 07:31:03.586086 2024-06-16 07:44:55.941173 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql 250 138560659000 1750 0 7 0 2024-06-16 07:31:03.538512 2024-06-16 07:44:54.051477 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL 250 134710061000 1750 0 7 0 2024-06-16 07:31:03.611552 2024-06-16 07:44:55.957343 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 748 412505681000 1662 0 2 0 2024-06-16 07:31:57.181397 2024-06-16 07:44:23.955774 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sakila 192 98136873000 1344 0 7 0 2024-06-16 07:31:57.204619 2024-06-16 07:44:23.967871 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 716 288160988000 981 0 1 0 2024-06-16 07:31:04.323847 2024-06-16 07:44:59.395014 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema 119 57480638000 833 0 7 0 2024-06-16 07:31:04.345713 2024-06-16 07:44:59.407679 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema 811 805081754000 786 0 1 0 2024-06-16 07:32:06.645461 2024-06-16 07:44:59.369968 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... test19 343 192041309000 749 0 2 0 2024-06-16 07:36:31.740661 2024-06-16 07:44:42.224736 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 706 451256415000 703 0 1 0 2024-06-16 07:31:04.298263 2024-06-16 07:44:59.330676 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 647 639235850000 646 0 1 0 2024-06-16 07:31:04.107627 2024-06-16 07:44:51.092734 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SHOW SESSION VARIABLES LIKE ? performance_schema 638 508443644000 638 0 1 0 2024-06-16 07:31:04.097401 2024-06-16 07:44:51.149254 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... test19 85 42940060000 595 0 7 0 2024-06-16 07:36:31.787474 2024-06-16 07:44:42.237528 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT `ENGINE` FROM `information_schema` . `ENGIN... information_schema 554 40814655000 554 0 1 0 2024-06-16 07:31:50.899327 2024-06-16 07:44:34.684780 7a7ef781f8a87ecaafaca60612366942c66b7cb3d2ea562d5d...
SELECT `TABLESPACE_NAME` FROM `information_schema`... information_schema 550 40390169000 550 0 1 0 2024-06-16 07:31:50.898201 2024-06-16 07:44:34.684443 1b9f8b5127195ff2666a798e5069445bfb51943ac52a3c6730...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sku 212 114573553000 472 0 2 0 2024-06-16 07:36:05.909866 2024-06-16 07:44:58.592405 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... dvwa 180 102009647000 396 0 2 0 2024-06-16 07:36:55.649079 2024-06-16 07:41:40.715347 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
Query results operations