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 46 0 0 843.82 ms 130.55 ms 18.34 ms 34.58 ms 94 2 936 20 0 0 46 0 94 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-07-05 20:01:44.532473 2022-07-05 20:03:28.021335
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 174 0 0 166.37 ms 3.80 ms 956.14 us 59.54 ms 1537 9 10054 58 0 0 395 0 2820 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-07-05 20:01:29.820776 2022-07-05 20:03:50.793957
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 145 0 3 113.58 ms 7.64 ms 783.30 us 37.69 ms 1682 12 10160 70 0 0 328 0 2850 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-07-05 20:01:29.498958 2022-07-05 20:03:50.819046
SHOW TABLES FROM `phpmyadmin` NULL 338 338 0 84.51 ms 1.51 ms 250.04 us 33.26 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-07-05 20:01:29.452074 2022-07-05 20:03:53.907930
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 49 0 0 83.88 ms 5.97 ms 1.71 ms 11.10 ms 13328 272 15337 313 0 0 49 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-07-05 20:01:29.473806 2022-07-05 20:03:50.810150
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 46 0 0 83.31 ms 5.19 ms 1.81 ms 19.55 ms 262 6 1508 33 0 0 46 0 262 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-07-05 20:01:44.528935 2022-07-05 20:03:28.020649
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 8 0 0 71.70 ms 25.96 ms 8.96 ms 5.24 ms 8 1 40 5 0 0 0 0 0 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-07-05 20:01:34.319145 2022-07-05 20:03:34.179359
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 85 0 0 68.41 ms 4.93 ms 804.83 us 19.82 ms 85 1 255 3 0 0 510 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-07-05 20:01:29.812339 2022-07-05 20:03:50.797159
SHOW SESSION VARIABLES LIKE ? mysql * 48 0 0 65.90 ms 7.13 ms 1.37 ms 5.78 ms 48 1 27552 574 0 0 48 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-07-05 20:01:29.484232 2022-07-05 20:03:50.812044
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 8 0 0 60.67 ms 53.71 ms 7.58 ms 5.28 ms 16 2 188 24 0 0 8 0 16 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-07-05 20:01:34.385337 2022-07-05 20:03:34.174900
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ 11 0 0 57.67 ms 41.71 ms 5.24 ms 10.56 ms 17 2 89 8 0 0 2 0 12 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-07-05 20:02:17.023317 2022-07-05 20:02:24.874603
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 35 0 0 53.83 ms 3.18 ms 1.54 ms 31.86 ms 233 7 1299 37 0 0 0 0 209 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-07-05 20:01:29.823041 2022-07-05 20:03:36.506632
SELECT @@`version` , @@`version_comment` NULL 206 0 0 31.08 ms 3.44 ms 150.87 us 0 ps 206 1 206 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-07-05 20:01:29.447624 2022-07-05 20:03:53.899759
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 29 0 0 30.55 ms 2.74 ms 1.05 ms 16.43 ms 150 5 859 30 0 0 24 0 132 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-07-05 20:01:34.330724 2022-07-05 20:03:34.184476
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... mysql * 54 0 0 30.33 ms 1.55 ms 561.65 us 8.82 ms 54 1 162 3 0 0 324 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-07-05 20:01:29.503662 2022-07-05 20:03:50.821318
SELECT `PRIVILEGE_TYPE` FROM ` ... ` = ? AND `PRIV... NULL * 86 0 0 27.04 ms 863.65 us 314.40 us 6.75 ms 86 1 14878 173 0 0 86 0 0 0 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... 2022-07-05 20:01:30.231090 2022-07-05 20:03:50.798067
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 151 0 0 26.99 ms 1.24 ms 178.71 us 12.66 ms 151 1 151 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2022-07-05 20:01:29.457388 2022-07-05 20:03:53.923083
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... mysql * 49 0 0 26.08 ms 6.09 ms 532.16 us 12.62 ms 2009 41 4018 82 0 0 0 0 0 0 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... 2022-07-05 20:01:29.466792 2022-07-05 20:03:50.809133
SET `lc_messages` = ? NULL 206 0 0 23.59 ms 5.93 ms 114.54 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-07-05 20:01:29.449413 2022-07-05 20:03:53.901642
SELECT * FROM `actor` LIMIT ?, ... sakila * 1 0 0 21.18 ms 21.18 ms 21.18 ms 1.78 ms 25 25 25 25 0 0 0 0 0 0 74cbd054819a94d3c9bf9156ca8e47dc3bde5b31caf0b6d709... 2022-07-05 20:01:34.291264 2022-07-05 20:01:34.291264
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... students 2 0 0 21.08 ms 18.62 ms 10.54 ms 2.41 ms 2 1 11 6 0 0 0 0 1 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-07-05 20:01:32.402395 2022-07-05 20:01:32.472873
SHOW SESSION VARIABLES LIKE ? NULL * 14 0 0 21.01 ms 3.17 ms 1.50 ms 1.91 ms 14 1 8036 574 0 0 14 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-07-05 20:01:34.266088 2022-07-05 20:03:53.926431
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ 23 0 0 20.44 ms 1.76 ms 888.70 us 11.78 ms 0 0 230 10 0 0 23 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-07-05 20:02:20.748323 2022-07-05 20:02:24.914678
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ 2 0 0 19.93 ms 19.18 ms 9.96 ms 625.00 us 2 1 7 4 0 0 1 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2022-07-05 20:02:24.909788 2022-07-05 20:02:24.910928
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL 16 0 0 19.22 ms 3.68 ms 1.20 ms 10.34 ms 16 1 140 9 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2022-07-05 20:01:29.828238 2022-07-05 20:02:41.328058
Query results operations