Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad: Tiempo necesario:
Opciones
Restore default values
Colapsar Expandir Reconsultar Editar Explicar Perfilando Falló la consulta Base de datos: Fecha y hora la consulta:
Cambiar las opciones de la modalidad de visualización.
Modalidad de navegación
Documentación Use solamente íconos, solamente texto o ambos. Restaurar valor predeterminado
Documentación Use solamente íconos, solamente texto o ambos. Restaurar valor predeterminado
Documentación Si el usuario puede ver un botón "mostrar todos (los registros)" o no. Restaurar valor predeterminado
Documentación Número de filas mostradas cuando se visualiza un juego de resultados. Si el juego de resultados contiene más filas, aparecerán enlaces "Anterior" y "Siguiente". Restaurar valor predeterminado
Documentación SMART - es decir: orden descendente para columnas de tipo TIME, DATE, DATETIME y TIMESTAMP, ascendente en los demás casos. Restaurar valor predeterminado
Documentación Resaltar las filas señaladas por el cursor del ratón. Restaurar valor predeterminado
Documentación Resaltar las filas seleccionadas. Restaurar valor predeterminado
Documentación Restaurar valor predeterminado
Documentación Restaurar valor predeterminado
Documentación Repetir cabecera cada X celdas, 0 desactiva esta funcionalidad. Restaurar valor predeterminado
Documentación Cantidad máxima de caracteres a mostrar en un campo no-numérico en vista de navegación. Restaurar valor predeterminado
Documentación Estos son los enlaces para Editar, Copiar y Borrar. Restaurar valor predeterminado
Documentación Si se muestran enlaces de fila, incluso en ausencia de una clave única. Restaurar valor predeterminado
Documentación Ordenación predeterminada para tablas con una clave primaria. Restaurar valor predeterminado
Documentación Al explorar tablas, se recordará el ordenamiento de cada tabla. Restaurar valor predeterminado
Documentación Opciones de visualización Restaurar valor predeterminado 
SELECT * FROM `events_statements_summary_by_digest`
Editar en línea
Editar
Explicar SQL
Crear código PHP
Actualizar
|
|
|
Ordenar según la clave:
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED FIRST_SEEN LAST_SEEN QUANTILE_95 QUANTILE_99 QUANTILE_999 QUERY_SAMPLE_TEXT QUERY_SAMPLE_SEEN QUERY_SAMPLE_TIMER_WAIT
NULL 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... SELECT @@`skip_networking` , @@`skip_name_resolve`... 1 907942000 907942000 907942000 907942000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:47.764251 2024-07-17 10:45:47.764251 912010839 912010839 912010839 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-07-17 10:45:47.764251 907942000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 4293 336589193000 22344000 78404000 727922000 0 0 0 0 4293 4293 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.446537 2024-07-17 10:52:51.287598 165958690 229086765 316227766 SELECT @@version, @@version_comment 2024-07-17 10:52:49.519059 121409000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 4293 184971632000 13875000 43086000 690047000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.446719 2024-07-17 10:52:51.287748 104712854 144543977 190546071 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-07-17 10:52:33.840029 160652000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 3818 180236665000 12388000 47207000 4043249000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.448694 2024-07-17 10:52:51.288830 109647819 151356124 3311311214 SET lc_messages = 'en_US' 2024-07-17 10:52:18.812237 158956000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 4293 683033617000 65228000 159104000 1416879000 277379000000 4293 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.450017 2024-07-17 10:52:51.289866 346736850 457088189 1148153621 SHOW TABLES FROM `phpmyadmin` 2024-07-17 10:51:51.715592 671077000
NULL ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 509 558074776000 440806000 1096414000 18874767000 273847000000 0 0 0 16909 82047 0 45 45 0 0 0 509 0 0 16909 509 45 0 2024-07-17 10:45:54.459071 2024-07-17 10:52:51.007095 2630267991 3630780547 19054607179 SHOW TABLES FROM `mysql` 2024-07-17 10:52:13.774411 2720939000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 4293 204037968000 14775000 47528000 1290443000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.460063 2024-07-17 10:52:51.290883 109647819 158489319 301995172 SET collation_connection = 'utf8mb4_unicode_ci' 2024-07-17 10:52:27.363774 203954000
NULL 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 74 3582554000 28679000 48412000 160708000 0 0 0 0 74 74 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.469023 2024-07-17 10:52:50.919518 79432823 165958690 165958690 SELECT @@lower_case_table_names 2024-07-17 10:52:08.437347 160708000
NULL 2ab4974347707f29c546079e99c4bf7314de1420a9acb95a1e... SHOW CREATE TABLE `vedettfak` . `fa` 1 10413238000 10413238000 10413238000 10413238000 79000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.498714 2024-07-17 10:45:54.498714 10471285480 10471285480 10471285480 SHOW CREATE TABLE `vedettfak`.`fa` 2024-07-17 10:45:54.498714 10413238000
vedettfak 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2 3462463000 537940000 1731231000 2924523000 491000000 0 0 0 12 58 0 1 0 0 0 0 2 0 0 6 1 0 0 2024-07-17 10:45:54.504138 2024-07-17 10:45:54.728034 3019951720 3019951720 3019951720 SHOW  COLUMNS FROM `vedettfak`.`fa` 2024-07-17 10:45:54.504138 2924523000
mysql caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1382 189665276000 49388000 137239000 1444172000 96247000000 0 0 0 1382 1382 0 0 0 0 0 0 1382 0 0 0 0 0 0 2024-07-17 10:45:54.508675 2024-07-17 10:52:51.206845 199526231 275422870 1148153621 SELECT 1 FROM `mysql`.`user` LIMIT 1 2024-07-17 10:52:02.393772 273445000
mysql d9925ce0f68dd37cf17d5f6532b66f83b1c3c1fc9db94b7b93... SELECT * FROM `mysql` . `user` LIMIT ? 153 20603869000 81983000 134665000 1058152000 8614000000 0 0 0 153 153 0 0 0 0 0 0 153 0 0 0 0 153 0 2024-07-17 10:45:54.509009 2024-07-17 10:52:49.271728 181970085 331131121 1096478196 SELECT * FROM `mysql`.`user` LIMIT 1 2024-07-17 10:52:43.131352 196082000
sys 967e7c58adff8b2718300494813e8497da63e13217b73ee6cb... SELECT `performance_schema` . `file_summary_by_ins... 2 18318220000 250695000 9159110000 18067525000 7706000000 0 0 0 2 168 0 0 0 0 0 0 2 0 0 2 2 2 0 2024-07-17 10:45:54.510526 2024-07-17 10:45:54.653546 18197008586 18197008586 18197008586 SELECT 1 FROM `sys`.`x$io_global_by_file_by_latenc... 2024-07-17 10:45:54.510526 18067525000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2132 2467859006000 502479000 1157532000 9806479000 849226000000 0 0 0 108013 550574 0 2125 0 0 0 0 2132 0 0 107916 2125 0 0 2024-07-17 10:45:54.510596 2024-07-17 10:52:51.048211 1819700858 2511886431 5248074602 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-07-17 10:52:27.418599 4850990000
sys e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 18 12841477000 456988000 713415000 1457554000 7802000000 0 0 0 0 54 0 18 0 0 0 0 18 0 0 0 18 0 0 2024-07-17 10:45:54.512295 2024-07-17 10:49:25.775840 1513561248 1513561248 1513561248 SHOW INDEXES FROM `sys`.`io_global_by_file_by_byte... 2024-07-17 10:49:25.765505 681577000
sys 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 9 7468098000 619340000 829788000 1161477000 3811000000 0 0 0 157 812 0 9 0 0 0 0 9 0 0 157 9 0 0 2024-07-17 10:45:54.514771 2024-07-17 10:49:25.775297 1202264434 1202264434 1202264434 SHOW  COLUMNS FROM `sys`.`io_global_by_file_by_byt... 2024-07-17 10:49:25.764702 822848000
sys 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 45 16045468000 214717000 356565000 779216000 8696000000 0 0 0 41 258 0 0 0 0 0 0 45 0 0 0 0 0 0 2024-07-17 10:45:54.516873 2024-07-17 10:49:25.884157 575439937 794328234 794328234 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-07-17 10:49:25.884157 554489000
sys 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 5 232277000 33178000 46455000 63086000 0 0 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.520362 2024-07-17 10:49:34.244064 63095734 63095734 63095734 SELECT @@lower_case_table_names 2024-07-17 10:49:34.244064 49061000
sys ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 4 21490878000 1335927000 5372719000 17120547000 2774000000 0 0 0 304 884 0 2 2 0 0 0 4 0 0 304 4 2 0 2024-07-17 10:45:54.521957 2024-07-17 10:49:34.426351 17378008287 17378008287 17378008287 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-07-17 10:49:34.261301 17120547000
sys 0376606fbe23fe296c5397fcf21b912a21383b2afbbf288667... SHOW STORAGE ENGINES 1 129837000 129837000 129837000 129837000 68000000 0 0 0 9 9 0 1 0 0 0 0 1 0 0 0 0 1 0 2024-07-17 10:45:54.522414 2024-07-17 10:45:54.522414 131825673 131825673 131825673 SHOW STORAGE ENGINES 2024-07-17 10:45:54.522414 129837000
sys 459798d1129216bc2c692d86b884874650c1d6598200b7f4ab... SELECT @@`disabled_storage_engines` 1 47295000 47295000 47295000 47295000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:45:54.522633 2024-07-17 10:45:54.522633 47863009 47863009 47863009 SELECT @@disabled_storage_engines 2024-07-17 10:45:54.522633 47295000
sys 1fe7aba925a48c9ab55b7b197d166da67a92d13a24185cf5d8... SHOW GLOBAL VARIABLES LIKE ? 1 6710321000 6710321000 6710321000 6710321000 199000000 0 0 0 1 553 0 1 0 0 0 0 2 0 0 0 0 1 0 2024-07-17 10:45:54.529430 2024-07-17 10:45:54.529430 6918309709 6918309709 6918309709 SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table' 2024-07-17 10:45:54.529430 6710321000
sys 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... 2 2598836000 1014426000 1299418000 1584410000 367000000 0 0 0 544 626 0 2 0 0 0 0 4 0 0 0 0 2 0 2024-07-17 10:45:54.531343 2024-07-17 10:49:34.298867 1584893192 1584893192 1584893192 SELECT `COLLATION_NAME` AS `Collation`, `CHARACTER... 2024-07-17 10:49:34.298867 1014426000
sys 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2 1756887000 713905000 878443000 1042982000 599000000 0 0 0 2 7 0 1 0 0 0 0 2 0 0 0 0 0 0 2024-07-17 10:45:54.542017 2024-07-17 10:45:54.545277 1047128548 1047128548 1047128548 SELECT * FROM `information_schema`.`PARTITIONS` WH... 2024-07-17 10:45:54.542017 1042982000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 3786 527452638000 42926000 139316000 1731620000 263729000000 0 0 0 3786 3786 0 0 0 0 0 0 3786 0 0 0 0 0 0 2024-07-17 10:45:54.570691 2024-07-17 10:52:51.317411 199526231 251188643 602559586 SELECT 1 FROM mysql.user LIMIT 1 2024-07-17 10:52:03.072130 1731620000
|
|
|
Ordenar según la clave:
Operaciones sobre los resultados de la consulta
Copiar al portapapeles Copiar al portapapeles Exportar Exportar Mostrar gráfico Mostrar gráfico Crear vista Crear vista