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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Bookmark 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 `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
REPLACE INTO `phpmyadmin` . `p ... ame` , `tables`... phpmyadmin 993 0 0 16.40 s 145.60 ms 16.52 ms 39.99 ms 0 0 0 0 993 1 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2024-06-16 10:29:52.800962 2024-06-16 10:44:42.408241
SELECT ? FROM `phpmyadmin` . ` ...  = ? AND `db_na... phpmyadmin * 79266 0 0 7.53 s 2.08 ms 94.97 us 3.48 s 0 0 0 0 0 0 0 0 0 0 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... 2024-06-16 10:29:52.625419 2024-06-16 10:44:42.787322
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 20616 0 0 5.32 s 1.89 ms 257.83 us 2.87 s 20392 1 123024 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 10:15:56.122722 2024-06-16 10:44:31.347033
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 2939 0 0 4.41 s 26.18 ms 1.50 ms 2.57 s 54919 19 254000 86 0 0 162 0 54919 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 10:15:57.252340 2024-06-16 10:44:42.761063
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... phpmyadmin * 2476 0 0 3.33 s 224.69 ms 1.34 ms 1.92 s 46993 19 190025 77 0 0 6 0 46993 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 10:29:49.581624 2024-06-16 10:44:42.762066
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... phpmyadmin 2493 0 0 3.13 s 4.71 ms 1.25 ms 1.83 s 5194 2 57458 23 0 0 2455 0 5014 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 10:29:49.587787 2024-06-16 10:44:42.763072
UPDATE `phpmyadmin` . `pma__us ... data` = ? WHERE... phpmyadmin 179 0 0 2.95 s 192.81 ms 16.49 ms 12.61 ms 0 0 179 1 164 1 0 0 0 0 e06af9c9a016909fb10aa053f985ecfc161569f5631b9ce8f2... 2024-06-16 10:29:54.856664 2024-06-16 10:44:40.442636
SELECT `CONCAT` ( `db_name` ,  ... transformation_... phpmyadmin * 15316 0 0 2.14 s 1.66 ms 139.86 us 964.39 ms 0 0 0 0 0 0 0 0 0 0 1e5c3c5b862adc139113587fbc1dff8a3453c453610cd7909a... 2024-06-16 10:29:52.700818 2024-06-16 10:44:42.066730
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 1970 0 0 2.12 s 5.42 ms 1.07 ms 243.26 ms 4135 2 82978 42 0 0 1923 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 10:17:03.171936 2024-06-16 10:44:41.362078
DROP SCHEMA `sakila` NULL 1 0 0 1.96 s 1.96 s 1.96 s 1.90 ms 0 0 0 0 23 23 0 0 0 0 a2587d785e1d8a8fd35a0bd14178b03ec5347fc6801413c03b... 2024-06-16 10:18:03.407437 2024-06-16 10:18:03.407437
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... sys * 17 0 4 1.53 s 566.16 ms 90.02 ms 5.55 ms 108 6 75674 4451 0 0 85 12 6668 12 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-16 10:15:58.673579 2024-06-16 10:27:27.511012
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 2508 0 0 1.52 s 7.29 ms 604.49 us 665.58 ms 10395 4 60968 24 0 0 5755 0 17239 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 10:15:57.209554 2024-06-16 10:44:40.444890
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 3008 0 44 1.28 s 4.33 ms 425.90 us 578.64 ms 12880 4 70096 23 0 0 5690 0 18053 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 10:15:57.665054 2024-06-16 10:44:42.097714
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 1230 0 0 1.28 s 8.29 ms 1.04 ms 458.83 ms 64294 52 325112 264 0 0 1229 0 64270 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 10:15:56.546803 2024-06-16 10:44:37.271743
SELECT `tables` FROM `phpmyadm ... __recent` WHERE... phpmyadmin * 1812 0 0 1.20 s 26.60 ms 661.04 us 62.78 ms 900561 497 900561 497 0 0 0 0 0 0 d69835e5fe5fb0226d6c68d185457f2ea0b6121c7475eaeaeb... 2024-06-16 10:29:52.172501 2024-06-16 10:44:42.355968
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 2496 0 0 1.06 s 2.62 ms 426.23 us 474.03 ms 9577 4 58357 23 0 0 5602 0 15410 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 10:15:56.667316 2024-06-16 10:44:37.365872
SHOW SESSION VARIABLES LIKE ? performance_schema * 1222 0 0 1.01 s 3.18 ms 824.50 us 109.10 ms 1222 1 701428 574 0 0 1222 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 10:15:56.537169 2024-06-16 10:44:37.348403
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 539 0 0 892.66 ms 79.25 ms 1.66 ms 197.24 ms 988 2 20954 39 0 0 539 0 988 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 10:16:03.174726 2024-06-16 10:44:41.992422
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 642 0 0 885.34 ms 47.95 ms 1.38 ms 302.32 ms 2784 4 200662 313 0 0 628 0 2784 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 10:15:56.544356 2024-06-16 10:44:37.258929
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sys * 1133 0 35 828.36 ms 17.33 ms 731.12 us 404.51 ms 146 0 75208 66 0 0 1166 0 2738 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 10:15:56.124923 2024-06-16 10:44:31.276825
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 898 0 0 822.58 ms 4.99 ms 916.01 us 352.95 ms 26916 30 138068 154 0 0 737 0 26142 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 10:16:03.150230 2024-06-16 10:44:42.015996
SELECT `config_data` , `UNIX_T ... erconfig` WHERE... phpmyadmin * 4561 0 0 800.09 ms 1.03 ms 175.42 us 358.97 ms 4561 1 4561 1 0 0 0 0 0 0 cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... 2024-06-16 10:29:52.624979 2024-06-16 10:44:42.765112
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... university * 463 0 0 748.59 ms 140.72 ms 1.62 ms 230.36 ms 2533 5 85183 184 0 0 259 0 2453 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 10:23:18.594573 2024-06-16 10:43:50.181528
SELECT `cat` . `name` AS `CATA ... database` ( `sc... sys * 1467 0 0 731.39 ms 1.91 ms 498.56 us 294.06 ms 8044 5 52800 36 0 0 3313 0 13928 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 10:15:56.166144 2024-06-16 10:44:31.334599
DROP SCHEMA `university` NULL 1 0 0 730.36 ms 730.36 ms 730.36 ms 265.00 us 0 0 0 0 10 10 0 0 0 0 c9be70dd765fec6d641540a2eb6e4217367ae20b97d7197766... 2024-06-16 10:23:44.489759 2024-06-16 10:23:44.489759
Query results operations
Bookmark this SQL query Bookmark this SQL query