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 462 0 0 2.42 s 145.91 ms 5.24 ms 207.96 ms 955 2 9816 21 0 0 462 0 955 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-08 23:32:59.945214 2022-12-08 23:43:47.158090
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 19 0 0 709.05 ms 666.55 ms 37.32 ms 7.72 ms 371 20 4151 218 0 0 9 0 710 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:25.459266 2022-12-08 23:44:10.722022
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 * 68 0 0 449.18 ms 358.14 ms 6.61 ms 46.48 ms 523 8 4622 68 0 0 51 0 523 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:44.503834 2022-12-08 23:44:10.481649
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 462 0 0 396.24 ms 6.83 ms 857.66 us 209.54 ms 2782 6 15936 34 0 0 462 0 2782 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-08 23:32:59.944139 2022-12-08 23:43:47.157251
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 1248 1248 0 255.83 ms 626.69 us 204.99 us 108.58 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-08 23:32:12.630644 2022-12-08 23:44:16.932363
SHOW SESSION VARIABLES LIKE ? sakila * 182 0 0 212.33 ms 7.04 ms 1.17 ms 17.75 ms 182 1 104468 574 0 0 182 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:33:04.837671 2022-12-08 23:44:10.554078
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 191 0 0 181.94 ms 2.75 ms 952.59 us 98.81 ms 1007 5 5570 29 0 0 157 0 808 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-08 23:33:04.758353 2022-12-08 23:44:10.555898
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 203 0 0 159.94 ms 4.61 ms 787.86 us 49.91 ms 203 1 609 3 0 0 1218 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-08 23:32:12.650443 2022-12-08 23:44:13.402820
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 133 0 0 127.58 ms 5.77 ms 959.26 us 44.90 ms 1467 11 9270 70 0 0 312 0 2760 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-08 23:32:12.640188 2022-12-08 23:44:13.284449
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 112 0 0 124.28 ms 2.87 ms 1.11 ms 72.59 ms 1298 12 6864 61 0 0 0 0 1248 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-08 23:32:45.391374 2022-12-08 23:43:59.839291
SHOW SESSION VARIABLES LIKE ? NULL * 118 0 0 119.04 ms 2.89 ms 1.01 ms 10.35 ms 118 1 67732 574 0 0 118 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:32:25.379178 2022-12-08 23:44:16.936340
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sakila 318 0 0 115.61 ms 1.68 ms 363.55 us 63.90 ms 215 1 1599 5 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2022-12-08 23:33:04.755287 2022-12-08 23:44:10.486508
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
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 137 0 1 109.24 ms 3.62 ms 797.40 us 37.72 ms 1411 10 9018 66 0 0 298 0 2550 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-08 23:32:13.622345 2022-12-08 23:44:12.801993
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 73 0 0 107.11 ms 42.30 ms 1.47 ms 33.98 ms 162 2 1688 23 0 0 73 0 162 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-08 23:33:04.800850 2022-12-08 23:44:10.492405
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 45 0 0 99.18 ms 11.81 ms 2.20 ms 12.16 ms 12240 272 14085 313 0 0 45 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-12-08 23:32:13.612553 2022-12-08 23:44:12.765615
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
SELECT @@`version` , @@`version_comment` NULL 625 0 0 83.55 ms 4.20 ms 133.68 us 0 ps 625 1 625 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-12-08 23:32:12.629642 2022-12-08 23:44:16.930865
SHOW SESSION VARIABLES LIKE ? mysql * 61 0 0 83.31 ms 7.42 ms 1.37 ms 5.98 ms 61 1 35014 574 0 0 61 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-08 23:32:13.616716 2022-12-08 23:44:12.776065
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
SET `lc_messages` = ? NULL 625 0 0 60.25 ms 5.27 ms 96.40 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:44:16.931096
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
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 297 0 0 48.95 ms 756.14 us 164.83 us 21.86 ms 297 1 297 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2022-12-08 23:32:12.649689 2022-12-08 23:44:16.935470
Query results operations