Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Set default
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 `statement_analysis`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
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 `TABL ... me` AS UNSIGNED... sakila * 24 0 0 362.97 ms 206.09 ms 15.12 ms 14.45 ms 156 7 1628 68 0 0 20 0 156 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-03 09:02:43.844020 2022-12-03 09:14:22.167369
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 18 0 0 229.17 ms 92.34 ms 12.73 ms 6.49 ms 34 2 403 22 0 0 18 0 34 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-03 09:02:43.889420 2022-12-03 09:14:22.172518
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 5 0 0 132.19 ms 46.62 ms 26.44 ms 3.71 ms 11 2 220 44 0 0 5 0 11 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-03 09:03:14.558727 2022-12-03 09:09:28.342375
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 3 0 0 90.66 ms 88.29 ms 30.22 ms 1.59 ms 309 103 1977 659 0 0 0 0 578 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-03 09:03:09.741638 2022-12-03 09:03:09.854492
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 7 0 0 87.54 ms 26.34 ms 12.51 ms 5.71 ms 7 1 677 97 0 0 6 0 7 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-03 09:03:14.528446 2022-12-03 09:09:28.378807
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 72 0 0 68.24 ms 3.54 ms 947.79 us 23.96 ms 739 10 4880 68 0 0 167 0 1380 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-03 09:03:14.573567 2022-12-03 09:13:45.746941
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 70 0 0 64.58 ms 4.12 ms 922.61 us 32.98 ms 372 5 2072 30 0 0 54 0 303 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-03 09:02:43.855328 2022-12-03 09:14:22.185780
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... mysql 2 0 0 62.71 ms 60.46 ms 31.35 ms 1.81 ms 2 1 7 4 0 0 1 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2022-12-03 09:03:41.806986 2022-12-03 09:03:41.810201
SELECT `cat` . `name` AS `CATA ... database` ( `sc... sakila * 70 0 0 46.82 ms 3.23 ms 668.85 us 15.90 ms 650 9 4324 62 0 0 156 0 1200 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-03 09:02:43.983559 2022-12-03 09:14:22.191365
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 19 0 0 40.95 ms 3.91 ms 2.16 ms 5.75 ms 5168 272 5947 313 0 0 19 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-12-03 09:03:41.744769 2022-12-03 09:13:45.730749
SHOW TABLES FROM `phpmyadmin` NULL 184 184 0 40.79 ms 607.19 us 221.69 us 17.46 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-03 09:02:43.723772 2022-12-03 09:14:33.550412
SHOW SESSION VARIABLES LIKE ? mysql * 22 0 0 39.51 ms 5.12 ms 1.80 ms 2.90 ms 22 1 12628 574 0 0 22 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-03 09:03:14.564745 2022-12-03 09:13:45.735209
SHOW SESSION VARIABLES LIKE ? NULL * 23 0 0 32.67 ms 6.28 ms 1.42 ms 2.75 ms 23 1 13202 574 0 0 23 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-03 09:02:43.735884 2022-12-03 09:14:33.555013
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... аа * 5 0 0 30.92 ms 26.17 ms 6.18 ms 7.66 ms 5 1 89 18 0 0 2 0 5 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-03 09:05:17.968082 2022-12-03 09:05:18.013793
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sys * 3 0 0 29.36 ms 27.69 ms 9.79 ms 1.02 ms 303 101 748 249 0 0 1 0 303 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-03 09:09:33.834751 2022-12-03 09:09:33.909491
SELECT `country` FROM `sakila` ... ountry` WHERE `... sakila 150 0 0 24.64 ms 4.66 ms 164.24 us 7.25 ms 150 1 150 1 0 0 0 0 0 0 0430c4b085bd37e271327ece3cd7aa85c87f1f3e47bae89b3a... 2022-12-03 09:02:43.915775 2022-12-03 09:12:52.065406
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 39 0 0 23.45 ms 4.12 ms 601.39 us 11.10 ms 0 0 117 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-12-03 09:02:43.754043 2022-12-03 09:14:22.169957
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 13 0 0 21.30 ms 3.16 ms 1.64 ms 8.96 ms 406 31 2095 161 0 0 13 0 406 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-03 09:03:14.530202 2022-12-03 09:09:28.422771
SHOW SESSION VARIABLES LIKE ? sakila * 18 0 0 21.25 ms 4.69 ms 1.18 ms 1.45 ms 18 1 10332 574 0 0 18 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-03 09:02:43.975779 2022-12-03 09:14:22.184618
SELECT `city` FROM `sakila` . `city` WHERE `city_i... sakila 200 0 0 19.73 ms 461.33 us 98.64 us 8.40 ms 200 1 200 1 0 0 0 0 0 0 44c82f738f27b17b95cb071b6a7383895c81d94875d734831a... 2022-12-03 09:08:38.772550 2022-12-03 09:13:53.125736
SET `lc_messages` = ? NULL 106 0 0 19.08 ms 4.97 ms 179.95 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-12-03 09:02:43.723015 2022-12-03 09:14:33.548855
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 17 0 0 18.21 ms 1.70 ms 1.07 ms 5.52 ms 17 1 51 3 0 0 102 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-03 09:05:16.763293 2022-12-03 09:13:46.439387
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 20 0 0 16.49 ms 3.15 ms 824.25 us 5.84 ms 165 8 1075 54 0 0 45 0 300 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-03 09:06:13.766374 2022-12-03 09:13:05.288636
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... mysql * 23 0 0 15.59 ms 1.83 ms 677.98 us 4.53 ms 23 1 69 3 0 0 138 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-03 09:03:14.623649 2022-12-03 09:13:45.751376
SELECT COUNT ( * ) FROM `sakila` . `film` sakila 2 0 0 15.39 ms 13.55 ms 7.69 ms 1.10 ms 2 1 0 0 0 0 0 0 0 0 e2bad0048e4fda42275285c56959cc02c3180254cb5c949816... 2022-12-03 09:06:11.074393 2022-12-03 09:12:47.678848
Query results operations