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 `x$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 `TABLE_CATALOG` , `sch` .... mysql * 248 0 0 872133917000 529501735000 3516669000 123508000000 630 3 101216 408 0 0 238 0 630 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-07 03:30:53.304500 2025-07-07 03:39:33.338267
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 1227 0 19 697166545000 7608290000 568187000 243804000000 11992 10 75129 61 0 0 2727 0 20526 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-07 03:30:53.361705 2025-07-07 03:39:33.398150
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 467 0 0 674440145000 7276958000 1444197000 239280000000 23768 51 121220 260 0 0 466 0 23766 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-07 03:30:53.234184 2025-07-07 03:39:33.341916
SHOW SESSION VARIABLES LIKE ? mysql * 518 0 0 580777582000 9414922000 1121192000 54611000000 518 1 297332 574 0 0 518 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-07 03:30:53.224636 2025-07-07 03:39:33.391485
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 1160 0 0 549760833000 3202760000 473931000 302567000000 0 0 3478 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-07 03:30:53.230516 2025-07-07 03:39:33.334905
CREATE TABLE `Prestamos` ( `IDPrestamo` INTEGER AU... biblioteca_escuela 1 0 0 477222749000 477222749000 477222749000 423000000 0 0 0 0 0 0 0 0 0 0 e6a2afa0e39b5ee03aac6a70b9272473cee4181b086f9935e8... 2025-07-07 03:34:07.590656 2025-07-07 03:34:07.590656
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 417 0 0 419138764000 4018053000 1005128000 140019000000 4921 12 30828 74 0 0 984 0 9308 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-07 03:30:58.104073 2025-07-07 03:39:12.631165
CREATE TABLE `Libros` ( `IDLibro` INTEGER AUTO_INC... biblioteca_escuela 1 0 0 378877321000 378877321000 378877321000 510000000 0 0 0 0 0 0 0 0 0 0 e4558131d816f68f7f7ca276f0fb3791785066c088ab0f726c... 2025-07-07 03:34:06.894499 2025-07-07 03:34:06.894499
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 265 0 0 353243490000 6577603000 1332994000 41255000000 1625 6 11998 45 0 0 253 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2025-07-07 03:31:07.924763 2025-07-07 03:39:11.752133
CREATE TABLE `Autores` ( `IDAutor` INTEGER AUTO_IN... biblioteca_escuela 1 0 0 317027037000 317027037000 317027037000 5154000000 0 0 0 0 0 0 0 0 0 0 72b836c316e92989c336771474a33133ea7094acebd669cef1... 2025-07-07 03:34:06.028142 2025-07-07 03:34:06.028142
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 233 0 0 273226854000 30351396000 1172647000 129483000000 466 2 15376 66 0 0 233 0 466 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-07 03:30:53.264933 2025-07-07 03:39:33.307893
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 172 0 0 254645953000 4643231000 1480499000 90515000000 9484 55 47936 279 0 0 172 0 9484 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-07 03:30:55.753197 2025-07-07 03:39:12.679265
CREATE TABLE `Biblioteca` ( `IDBiblioteca` INTEGER... biblioteca_escuela 1 0 0 249404332000 249404332000 249404332000 432000000 0 0 0 0 0 0 0 0 0 0 96f22a16d7ce03cbb9a2802f553564c2b4aac27489948d0ad1... 2025-07-07 03:34:06.497356 2025-07-07 03:34:06.497356
SHOW TABLES FROM `phpmyadmin` NULL 780 780 0 202837938000 1445266000 260048000 83489000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2025-07-07 03:30:53.194166 2025-07-07 03:39:34.147554
CREATE TABLE `Lectores` ( `IDLector` INTEGER AUTO_... biblioteca_escuela 1 0 0 191353288000 191353288000 191353288000 289000000 0 0 0 0 0 0 0 0 0 0 e33338a1e65a6a0da845d7e861158188e0836f3ca8dcbeb5c3... 2025-07-07 03:34:07.097336 2025-07-07 03:34:07.097336
CREATE TABLE `Generos` ( `IDGenero` INTEGER AUTO_I... biblioteca_escuela 1 0 0 190302189000 190302189000 190302189000 373000000 0 0 0 0 0 0 0 0 0 0 4074225296c9b620405006f85c75f2b40085a0637db59d9150... 2025-07-07 03:34:06.232317 2025-07-07 03:34:06.232317
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 235 0 0 188212306000 2133128000 800903000 60601000000 235 1 940 4 0 0 1645 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-07 03:30:58.112268 2025-07-07 03:39:21.919701
SHOW SESSION VARIABLES LIKE ? performance_schema * 172 0 0 178851682000 3696935000 1039835000 18216000000 172 1 98728 574 0 0 172 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-07 03:30:55.740981 2025-07-07 03:39:12.737622
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql * 72 0 0 168195185000 5245501000 2336044000 21904000000 19584 272 22536 313 0 0 72 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2025-07-07 03:30:57.375308 2025-07-07 03:39:30.028943
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 317 0 0 161269554000 1799719000 508736000 52219000000 317 1 1268 4 0 0 2219 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-07 03:30:53.368662 2025-07-07 03:39:33.400189
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 344 0 0 159204434000 1578499000 462803000 56002000000 2979 9 20134 59 0 0 774 0 5442 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-07 03:30:55.858256 2025-07-07 03:39:12.744125
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 86 0 0 157056274000 5670351000 1826235000 58645000000 86 1 35529 413 0 0 86 0 86 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-07 03:30:55.750271 2025-07-07 03:39:12.659456
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... biblioteca_escuela 14 0 0 138904513000 53736730000 9921750000 8830000000 47 3 450 32 0 0 14 0 47 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-07 03:34:22.362647 2025-07-07 03:39:23.762181
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 8 0 0 133423866000 49753120000 16677983000 5628000000 21 3 249 31 0 0 8 0 21 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-07 03:31:06.231636 2025-07-07 03:38:22.610390
SHOW SESSION VARIABLES LIKE ? biblioteca_escuela * 76 0 0 129806587000 7371243000 1707981000 10236000000 76 1 43624 574 0 0 76 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-07 03:33:41.905865 2025-07-07 03:39:23.763631
Query results operations