Drop files here

SQL upload ( 0 ) x -

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
Restore default values
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`
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 ...  `client_coll` ... sys 4263 0 0 1.27 s 3.74 ms 297.38 us 696.24 ms 4260 1 25569 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 00:46:04.829210 2024-06-26 00:48:11.096354
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 782 0 0 794.20 ms 3.11 ms 1.02 ms 89.55 ms 1012 1 32664 42 0 0 772 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-26 00:46:03.118253 2024-06-26 00:49:05.228364
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 140 0 0 421.54 ms 63.92 ms 3.01 ms 50.67 ms 263 2 7035 50 0 0 140 0 263 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 00:46:02.622148 2024-06-26 00:49:19.235420
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 615 0 0 399.41 ms 8.48 ms 649.45 us 143.19 ms 5411 9 35761 58 0 0 1394 0 9920 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 00:46:02.642333 2024-06-26 00:49:19.224539
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 251 0 0 349.38 ms 21.28 ms 1.39 ms 157.46 ms 5875 23 64799 258 0 0 116 0 5875 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 00:46:02.686081 2024-06-26 00:49:19.487299
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 18 0 0 332.31 ms 238.60 ms 18.46 ms 9.29 ms 18 1 7425 413 0 0 18 0 18 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 00:46:05.437997 2024-06-26 00:49:17.185545
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 42 0 0 328.26 ms 54.47 ms 7.82 ms 17.62 ms 87 2 1037 25 0 0 42 0 87 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 00:46:05.496663 2024-06-26 00:49:17.120287
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 599 0 0 317.23 ms 2.42 ms 529.59 us 115.43 ms 5041 8 33876 57 0 0 1348 0 9184 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 00:46:03.095554 2024-06-26 00:49:17.975202
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 298 0 0 313.02 ms 3.29 ms 1.05 ms 109.23 ms 16915 57 85469 287 0 0 298 0 16915 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 00:46:03.018425 2024-06-26 00:49:17.938166
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 909 0 0 307.17 ms 6.40 ms 337.92 us 134.28 ms 3547 4 21616 24 0 0 702 0 5264 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 00:46:03.114684 2024-06-26 00:49:16.225941
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 571 0 1 306.90 ms 4.59 ms 537.48 us 111.65 ms 5380 9 34427 60 0 0 1265 0 9305 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 00:46:02.739946 2024-06-26 00:49:19.320618
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 274 0 0 278.08 ms 5.15 ms 1.01 ms 108.73 ms 10650 39 55012 201 0 0 235 0 10509 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 00:46:02.568216 2024-06-26 00:49:19.250048
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema * 310 0 0 265.47 ms 78.55 ms 856.36 us 110.46 ms 78 0 4185 14 0 0 301 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 00:46:03.093830 2024-06-26 00:49:16.149696
SELECT `cat` . `name` AS `CATA ... database` ( `sc... BaseFarmacia * 463 0 0 253.19 ms 1.79 ms 546.85 us 96.59 ms 4063 9 25442 55 0 0 1003 0 7006 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 00:47:07.194720 2024-06-26 00:49:19.582867
SHOW SESSION VARIABLES LIKE ? performance_schema * 297 0 0 246.02 ms 2.80 ms 828.34 us 26.52 ms 297 1 170478 574 0 0 297 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 00:46:03.002385 2024-06-26 00:49:16.175686
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... information_schema * 12 0 0 236.59 ms 114.19 ms 19.72 ms 4.22 ms 104 9 4767 397 0 0 0 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-26 00:46:04.139423 2024-06-26 00:49:15.269164
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 115 0 0 234.89 ms 24.90 ms 2.04 ms 47.01 ms 145 1 47078 409 0 0 114 0 145 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 00:46:02.662094 2024-06-26 00:49:19.246565
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... BaseFarmacia * 158 0 0 219.55 ms 46.46 ms 1.39 ms 88.29 ms 374 2 27407 173 0 0 61 0 356 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 00:47:12.019263 2024-06-26 00:49:19.549281
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema * 304 0 0 210.72 ms 4.22 ms 693.15 us 104.45 ms 4030 13 20371 67 0 0 152 0 2972 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 00:46:03.092958 2024-06-26 00:49:16.148918
CREATE TABLE `login_attempts`  ... T NOW , `succes... BaseFarmacia 1 0 0 194.87 ms 194.87 ms 194.87 ms 167.00 us 0 0 0 0 0 0 0 0 0 0 21d7197b1c69c19c1acfaa9a5714e495f72a502634a16d3cc7... 2024-06-26 00:47:07.105522 2024-06-26 00:47:07.105522
CREATE TABLE `registrados` ( ` ... RD VARCHARACTER... BaseFarmacia 1 0 0 178.54 ms 178.54 ms 178.54 ms 457.00 us 0 0 0 0 0 0 0 0 0 0 2b96804bddf8caaf2e364b667def89e74a344a9cc3642b147b... 2024-06-26 00:47:06.905345 2024-06-26 00:47:06.905345
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 150 0 0 178.29 ms 1.97 ms 1.19 ms 67.39 ms 150 1 61776 412 0 0 150 0 150 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 00:46:03.015528 2024-06-26 00:49:17.989373
CREATE TABLE `usuarios` ( `_id ... ?) , `pass` VAR... BaseFarmacia 1 0 0 174.68 ms 174.68 ms 174.68 ms 3.44 ms 0 0 0 0 0 0 0 0 0 0 5a882b853c4866fd9032bad69a926d895798810a84d8321738... 2024-06-26 00:47:06.712440 2024-06-26 00:47:06.712440
SHOW TABLES FROM `phpmyadmin` NULL 749 749 0 166.44 ms 543.23 us 222.22 us 67.57 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-26 00:46:02.540613 2024-06-26 00:49:19.611534
SHOW SESSION VARIABLES LIKE ? mysql * 188 0 0 165.60 ms 5.15 ms 880.86 us 17.10 ms 188 1 107912 574 0 0 188 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 00:46:02.563019 2024-06-26 00:49:19.309713
Query results operations