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 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 301 24733345000 26766000 82170000 1166270000 0 0 0 0 301 301 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.360415 2024-07-17 10:16:11.330709 109647819 239883291 1202264434 SELECT @@version, @@version_comment 2024-07-17 10:16:11.292335 1166270000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 301 12215763000 14927000 40583000 283539000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.360642 2024-07-17 10:16:11.330814 57543993 125892541 288403150 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-07-17 10:16:11.292753 283539000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 301 34565793000 17592000 114836000 9466970000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.360824 2024-07-17 10:16:11.330944 50118723 3311311214 9549925860 SET lc_messages = 'es_ES' 2024-07-17 10:15:52.571570 9466970000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 301 46619063000 83586000 154880000 1680464000 20473000000 301 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.361442 2024-07-17 10:16:11.331203 218776162 398107170 1737800828 SHOW TABLES FROM `phpmyadmin` 2024-07-17 10:15:58.657199 1680464000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 301 13125969000 20487000 43607000 148536000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.362466 2024-07-17 10:16:11.339206 79432823 125892541 151356124 SET collation_connection = 'utf8mb4_unicode_ci' 2024-07-17 10:16:07.209506 148536000
NULL 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... SELECT @@`skip_networking` , @@`skip_name_resolve`... 1 94470000 94470000 94470000 94470000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.364356 2024-07-17 10:15:48.364356 95499258 95499258 95499258 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-07-17 10:15:48.364356 94470000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 286 39215481000 51889000 137117000 1115114000 19457000000 0 0 0 286 286 0 0 0 0 0 0 286 0 0 0 0 0 0 2024-07-17 10:15:48.380609 2024-07-17 10:16:11.377003 208929613 316227766 1148153621 SELECT 1 FROM mysql.user LIMIT 1 2024-07-17 10:15:48.380609 1115114000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 193 9031928000 24039000 46797000 291096000 0 0 0 0 193 193 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.381378 2024-07-17 10:16:11.377535 79432823 251188643 301995172 SELECT DATABASE() 2024-07-17 10:15:48.381378 291096000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 153 167426707000 622273000 1094292000 17601538000 20302000000 0 0 0 153 87822 0 153 0 0 0 0 306 0 0 0 0 153 0 2024-07-17 10:15:48.398025 2024-07-17 10:16:11.348040 1737800828 16595869074 18197008586 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-07-17 10:15:48.399436 17601538000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 68 14778351000 126589000 217328000 1137553000 5290000000 0 0 0 612 612 0 0 0 0 0 0 68 0 0 0 0 68 0 2024-07-17 10:15:48.399905 2024-07-17 10:16:11.348523 363078054 1148153621 1148153621 SELECT * FROM `user` LIMIT 0, 25 2024-07-17 10:15:48.399905 1137553000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 68 2247003000 15306000 33044000 110133000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.400872 2024-07-17 10:16:11.348858 66069344 114815362 114815362 SHOW WARNINGS 2024-07-17 10:15:48.400872 110133000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 106 5057695000 27697000 47714000 151871000 0 0 0 0 106 106 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.401866 2024-07-17 10:16:11.349243 83176377 151356124 158489319 SELECT @@lower_case_table_names 2024-07-17 10:15:48.401866 151871000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 346 139055730000 209887000 401895000 6418584000 75084000000 0 0 0 0 1038 0 0 0 0 0 0 346 0 0 0 0 0 0 2024-07-17 10:15:48.408827 2024-07-17 10:16:11.375281 602559586 1148153621 6606934480 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-07-17 10:15:48.408856 6418584000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 179 204285038000 579989000 1141257000 5992120000 74397000000 0 0 0 8201 41900 0 179 0 0 0 0 179 0 0 8201 179 0 0 2024-07-17 10:15:48.415413 2024-07-17 10:16:11.351325 1905460717 6025595860 6025595860 SHOW  COLUMNS FROM `mysql`.`user` 2024-07-17 10:15:48.415503 5992120000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 74 91958593000 496287000 1242683000 36132520000 29727000000 0 1 0 148 4880 0 74 0 0 0 0 74 0 0 148 74 0 0 2024-07-17 10:15:48.422955 2024-07-17 10:16:11.352712 1000000000 36307805477 36307805477 SHOW INDEXES FROM `mysql`.`user` 2024-07-17 10:15:48.452447 36132520000
mysql 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 40 1950799000 32427000 48769000 156688000 0 0 40 0 40 40 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.427054 2024-07-17 10:16:11.354115 63095734 158489319 158489319 SELECT @@have_profiling 2024-07-17 10:15:48.427054 156688000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 74 14930161000 127052000 201758000 699852000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.428762 2024-07-17 10:16:11.354667 331131121 724435960 724435960 SHOW CREATE TABLE `mysql`.`user` 2024-07-17 10:15:58.137444 699852000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 138 142213249000 635092000 1030530000 13750119000 63760000000 0 0 0 2186 20082 0 74 74 0 0 0 138 0 0 2186 138 74 0 2024-07-17 10:15:48.469232 2024-07-17 10:16:11.376701 1445439770 3311311214 13803842646 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-07-17 10:15:48.469232 13750119000
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 91 5694636000 26905000 62578000 250373000 0 0 0 0 91 91 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.524261 2024-07-17 10:16:11.203366 104712854 251188643 251188643 SELECT CURRENT_USER() 2024-07-17 10:15:50.160710 250373000
mysql 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 40 2962799000 49779000 74069000 170406000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.524646 2024-07-17 10:16:09.505642 109647819 173780082 173780082 SHOW GRANTS 2024-07-17 10:15:49.058977 170406000
mysql db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 446 280915586000 278069000 629855000 6421880000 104694000000 0 1 0 4100 26933 0 1014 694 0 0 0 1015 0 0 7470 249 446 0 2024-07-17 10:15:48.527347 2024-07-17 10:16:11.323351 1318256738 2398832919 6606934480 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-07-17 10:16:04.842426 6421880000
mysql 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 124 73625477000 395656000 593753000 1959281000 26611000000 0 0 0 124 496 0 868 0 0 0 0 868 0 0 0 0 124 0 2024-07-17 10:15:48.550792 2024-07-17 10:16:11.265022 794328234 1318256738 1995262314 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-07-17 10:16:01.724297 1959281000
mysql cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... 72 18877704000 158191000 262190000 1068316000 4332000000 0 0 0 72 12456 0 72 0 0 0 0 72 0 0 0 0 72 0 2024-07-17 10:15:48.551254 2024-07-17 10:16:11.265347 416869383 1096478196 1096478196 SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.... 2024-07-17 10:16:03.830216 1068316000
mysql caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 84 11885412000 69060000 141493000 250962000 5912000000 0 0 0 84 84 0 0 0 0 0 0 84 0 0 0 0 0 0 2024-07-17 10:15:48.570289 2024-07-17 10:16:11.305580 199526231 251188643 251188643 SELECT 1 FROM `mysql`.`user` LIMIT 1 2024-07-17 10:16:02.103863 250962000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 74 3531100000 27693000 47717000 134123000 0 0 0 0 74 74 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 10:15:48.580342 2024-07-17 10:16:11.128685 87096358 138038426 138038426 SELECT CURRENT_USER() 2024-07-17 10:16:01.719657 134123000
|
|
|
|
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