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 ... D ) , ? ) ) AS ... NULL 324 0 0 2.33 s 145.91 ms 7.19 ms 160.52 ms 673 2 6912 21 0 0 324 0 673 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-08 23:32:59.945214 2022-12-08 23:40:03.076154
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 17 0 0 706.45 ms 666.55 ms 41.56 ms 6.46 ms 337 20 3853 227 0 0 8 0 676 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:25.459266 2022-12-08 23:35:20.822196
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... sakila * 3 0 24 546.97 ms 284.80 ms 182.32 ms 2.94 ms 26 9 645821 215274 0 0 6 0 400 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2022-12-08 23:37:36.195938 2022-12-08 23:37:55.686898
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 46 0 0 412.17 ms 358.14 ms 8.96 ms 27.97 ms 420 9 3220 70 0 0 32 0 420 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:44.503834 2022-12-08 23:40:28.683371
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 324 0 0 311.11 ms 6.83 ms 960.23 us 162.37 ms 1996 6 11412 35 0 0 324 0 1996 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-08 23:32:59.944139 2022-12-08 23:40:03.075583
CREATE TABLE `website_pages` ( ... _noindex` TINYI... аа 1 0 15 258.31 ms 258.31 ms 258.31 ms 853.00 us 0 0 0 0 0 0 0 0 0 0 3f1db4c20db72ec50f953f2c0a4586545075fe3b83757ad837... 2022-12-08 23:40:01.847111 2022-12-08 23:40:01.847111
SHOW TABLES FROM `phpmyadmin` NULL 952 952 0 199.58 ms 626.69 us 209.64 us 84.42 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-08 23:32:12.630644 2022-12-08 23:40:52.979495
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 157 0 0 129.42 ms 4.61 ms 824.32 us 40.75 ms 157 1 471 3 0 0 942 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-08 23:32:12.650443 2022-12-08 23:40:45.843671
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 98 0 0 113.42 ms 2.87 ms 1.16 ms 66.09 ms 976 10 5744 59 0 0 0 0 926 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:45.391374 2022-12-08 23:40:24.356249
SELECT COUNT ( * ) AS `count`  ... G `utf8` ) LIKE... sakila * 1 0 42 112.89 ms 112.89 ms 112.89 ms 227.00 us 1 1 16044 16044 0 0 0 0 0 0 d74dec7db8dc85748259d5e1cda7bc3e234a5e21b079f37067... 2022-12-08 23:37:56.002032 2022-12-08 23:37:56.002032
SHOW SESSION VARIABLES LIKE ? sakila * 108 0 0 101.33 ms 2.64 ms 938.24 us 8.55 ms 108 1 61992 574 0 0 108 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:33:04.837671 2022-12-08 23:40:06.937725
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 101 0 0 100.46 ms 5.77 ms 994.64 us 35.09 ms 1174 12 7319 72 0 0 239 0 2220 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-08 23:32:12.640188 2022-12-08 23:40:19.459543
SELECT COUNT ( * ) AS `count`  ... ING `utf8` ) LI... sakila * 1 0 42 95.42 ms 95.42 ms 95.42 ms 208.00 us 1 1 16049 16049 0 0 0 0 0 0 01e07780805711d4971fbe0622b1164a3b9d20cc6e20e08501... 2022-12-08 23:37:55.886903 2022-12-08 23:37:55.886903
SHOW SESSION VARIABLES LIKE ? NULL * 100 0 0 91.90 ms 2.89 ms 918.97 us 8.03 ms 100 1 57400 574 0 0 100 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:32:25.379178 2022-12-08 23:40:52.984595
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 122 0 0 87.88 ms 2.68 ms 720.35 us 48.46 ms 625 5 3575 29 0 0 106 0 556 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-08 23:33:04.758353 2022-12-08 23:40:28.717875
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 37 0 0 80.19 ms 11.81 ms 2.17 ms 9.81 ms 10064 272 11581 313 0 0 37 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-12-08 23:32:13.612553 2022-12-08 23:40:23.155956
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 101 0 1 79.86 ms 3.62 ms 790.74 us 27.30 ms 1087 11 6885 68 0 0 226 0 1950 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-08 23:32:13.622345 2022-12-08 23:39:57.258207
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 55 0 0 79.48 ms 42.30 ms 1.45 ms 19.99 ms 104 2 1142 21 0 0 55 0 104 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-08 23:33:04.800850 2022-12-08 23:40:28.686775
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 272 0 0 76.74 ms 1.24 ms 282.14 us 42.44 ms 215 1 1461 5 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-12-08 23:33:04.755287 2022-12-08 23:40:06.926371
SELECT `c` . `name` AS `catego ... e` ORDER BY `to... sakila * 1 0 12 68.36 ms 68.36 ms 68.36 ms 441.00 us 1 1 16 16 0 0 2 0 16 0 a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4... 2022-12-08 23:37:56.072458 2022-12-08 23:37:56.072458
SHOW SESSION VARIABLES LIKE ? mysql * 52 0 0 67.50 ms 7.42 ms 1.30 ms 4.93 ms 52 1 29848 574 0 0 52 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:32:13.616716 2022-12-08 23:40:23.157860
SELECT @@`version` , @@`version_comment` NULL 477 0 0 61.80 ms 350.86 us 129.55 us 0 ps 477 1 477 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-12-08 23:32:12.629642 2022-12-08 23:40:52.977549
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL * 34 0 0 51.73 ms 13.88 ms 1.52 ms 21.54 ms 34 1 3178 93 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2022-12-08 23:32:45.406368 2022-12-08 23:40:02.171062
SET `lc_messages` = ? NULL 477 0 0 48.74 ms 5.27 ms 102.18 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-12-08 23:32:12.630098 2022-12-08 23:40:52.977877
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 6 0 0 38.20 ms 35.43 ms 6.37 ms 1.62 ms 14 2 313 52 0 0 6 0 14 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-08 23:32:25.420894 2022-12-08 23:35:20.825482
Query results operations