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 213 0 0 900.03 ms 107.48 ms 4.23 ms 101.16 ms 291 1 3199 15 0 0 213 0 291 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-05 10:34:06.169200 2022-12-05 10:39:10.835877
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 18 0 0 619.44 ms 590.63 ms 34.41 ms 14.34 ms 434 24 3131 174 0 0 5 0 434 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:32:48.137580 2022-12-05 10:39:10.729257
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 33 0 0 375.81 ms 239.13 ms 11.39 ms 26.71 ms 253 8 2205 67 0 0 23 0 253 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:33:13.340468 2022-12-05 10:38:47.269870
CREATE TABLE `test19` . `RISK_ ...  `RA_ID` ) ) EN... test19 1 0 0 342.65 ms 342.65 ms 342.65 ms 1.33 ms 0 0 0 0 0 0 0 0 0 0 ae1e21059ad20ba2c4551142c4691007f26fca8d07bc8ab975... 2022-12-05 10:38:30.229149 2022-12-05 10:38:30.229149
SHOW TABLES FROM `phpmyadmin` NULL 1340 1340 0 289.43 ms 4.67 ms 216.00 us 120.96 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2022-12-05 10:32:27.776831 2022-12-05 10:39:29.560195
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... NULL * 321 0 0 286.13 ms 5.09 ms 891.36 us 81.10 ms 321 1 963 3 0 0 1926 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-05 10:32:28.224283 2022-12-05 10:39:29.018263
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 204 0 0 244.72 ms 5.98 ms 1.20 ms 83.87 ms 2643 13 16244 80 0 0 488 0 5014 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-05 10:32:28.208130 2022-12-05 10:39:28.773740
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... NULL 215 0 0 203.99 ms 3.23 ms 948.77 us 85.96 ms 1500 7 8352 39 0 0 215 0 1500 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-05 10:34:06.168237 2022-12-05 10:39:10.835161
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... test19 * 13 0 0 179.64 ms 148.75 ms 13.82 ms 11.26 ms 55 4 500 38 0 0 8 0 55 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:34:42.937267 2022-12-05 10:38:49.716538
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 134 0 0 173.64 ms 4.05 ms 1.30 ms 108.81 ms 814 6 5370 40 0 0 2 0 717 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:33:53.638939 2022-12-05 10:39:14.940100
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... mysql * 75 0 0 166.43 ms 8.36 ms 2.22 ms 21.66 ms 20400 272 23475 313 0 0 75 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2022-12-05 10:32:27.783718 2022-12-05 10:39:28.009067
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 146 0 10 126.67 ms 3.47 ms 867.62 us 44.59 ms 1966 13 9999 68 0 0 304 0 2739 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2022-12-05 10:32:27.795514 2022-12-05 10:39:28.017848
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 17 0 0 114.42 ms 37.48 ms 6.73 ms 10.15 ms 44 3 493 29 0 0 17 0 44 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-05 10:33:13.375477 2022-12-05 10:38:47.280062
SHOW SESSION VARIABLES LIKE ? mysql * 67 0 0 112.62 ms 4.04 ms 1.68 ms 8.40 ms 67 1 38458 574 0 0 67 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-05 10:32:27.789030 2022-12-05 10:39:28.010977
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL * 65 0 0 102.14 ms 18.25 ms 1.57 ms 48.15 ms 67 1 5771 89 0 0 0 0 3 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2022-12-05 10:33:53.662728 2022-12-05 10:39:14.933811
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... world * 13 0 0 91.42 ms 72.36 ms 7.03 ms 12.60 ms 25 2 354 27 0 0 7 0 25 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:35:10.480800 2022-12-05 10:36:32.517310
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... world 5 0 0 91.05 ms 84.34 ms 18.21 ms 4.49 ms 10 2 75 15 0 0 5 0 10 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2022-12-05 10:35:20.600775 2022-12-05 10:36:31.392364
SELECT @@`version` , @@`version_comment` NULL 670 0 0 86.60 ms 440.59 us 129.26 us 0 ps 670 1 670 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2022-12-05 10:32:27.775674 2022-12-05 10:39:29.552193
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 428 0 0 84.57 ms 4.46 ms 197.59 us 36.44 ms 428 1 428 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2022-12-05 10:32:27.779145 2022-12-05 10:39:29.575028
SHOW SESSION VARIABLES LIKE ? sakila * 56 0 0 84.52 ms 6.42 ms 1.51 ms 6.32 ms 56 1 32144 574 0 0 56 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-05 10:33:13.394874 2022-12-05 10:38:47.306113
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ * 42 0 0 81.92 ms 29.56 ms 1.95 ms 31.58 ms 77 2 892 21 0 0 16 0 77 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2022-12-05 10:35:14.695874 2022-12-05 10:39:01.710800
SET `lc_messages` = ? NULL 670 0 0 78.82 ms 14.66 ms 117.64 us 0 ps 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2022-12-05 10:32:27.776001 2022-12-05 10:39:29.554170
SELECT ? FROM ( SELECT `GRANTE ... ? AND ? LIKE `G... mysql * 88 0 0 68.99 ms 2.58 ms 784.03 us 19.33 ms 88 1 264 3 0 0 528 0 0 0 a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa... 2022-12-05 10:32:27.799638 2022-12-05 10:39:28.020783
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... sakila 60 0 0 64.22 ms 2.61 ms 1.07 ms 34.80 ms 391 7 2197 37 0 0 51 0 362 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2022-12-05 10:33:13.343553 2022-12-05 10:38:47.306995
SHOW SESSION VARIABLES LIKE ? NULL * 44 0 0 60.15 ms 4.52 ms 1.37 ms 5.10 ms 44 1 25256 574 0 0 44 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2022-12-05 10:33:04.623992 2022-12-05 10:39:29.578479
Query results operations