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 3212512000 3212512000 3212512000 3212512000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:45:47.743537 2024-07-17 07:45:47.743537 3311311214 3311311214 3311311214 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-07-17 07:45:47.743537 3212512000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 2467 280739488000 24828000 113797000 817695000 0 0 0 0 2467 2467 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.007577 2024-07-17 07:56:06.249789 239883291 275422870 346736850 SELECT @@version, @@version_comment 2024-07-17 07:56:01.229378 283718000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 2467 162042563000 19277000 65684000 321744000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.007717 2024-07-17 07:56:06.250019 151356124 181970085 229086765 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-07-17 07:55:27.635302 197766000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 2455 203704658000 12426000 82975000 7730871000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.007842 2024-07-17 07:56:06.250272 151356124 190546071 6025595860 SET lc_messages = 'ru_RU' 2024-07-17 07:55:57.932183 187313000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 2467 540392956000 69746000 219048000 1386161000 218311000000 2467 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.009157 2024-07-17 07:56:06.250583 457088189 549540873 1047128548 SHOW TABLES FROM `phpmyadmin` 2024-07-17 07:56:06.241449 419488000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 2467 168369219000 15291000 68248000 884947000 0 0 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.010193 2024-07-17 07:56:06.251270 165958690 208929613 346736850 SET collation_connection = 'utf8mb4_unicode_ci' 2024-07-17 07:56:01.236476 244729000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1934 272805800000 50448000 141057000 846056000 132464000000 0 0 0 1934 1934 0 0 0 0 0 0 1934 0 0 0 0 0 0 2024-07-17 07:46:01.025484 2024-07-17 07:56:06.258853 218776162 316227766 416869383 SELECT 1 FROM mysql.user LIMIT 1 2024-07-17 07:55:22.844940 361240000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 1346 59828957000 13016000 44449000 450605000 0 0 0 0 1346 1346 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.026427 2024-07-17 07:56:06.259316 66069344 87096358 151356124 SELECT DATABASE() 2024-07-17 07:55:52.649578 92640000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 786 686073898000 615398000 872867000 5496104000 69574000000 0 0 0 786 451164 0 786 0 0 0 0 1572 0 0 0 0 786 0 2024-07-17 07:46:01.032426 2024-07-17 07:56:05.199480 1380384264 2511886431 5754399373 SHOW SESSION VARIABLES LIKE 'character_set_server' 2024-07-17 07:55:22.885719 1518066000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 303 56176265000 116239000 185400000 434751000 18510000000 0 0 0 2727 2727 0 0 0 0 0 0 303 0 0 0 0 303 0 2024-07-17 07:46:01.033052 2024-07-17 07:56:05.137258 263026799 331131121 436515832 SELECT * FROM `user` LIMIT 0, 25 2024-07-17 07:55:24.144502 323403000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 311 9829698000 14792000 31606000 117636000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.033319 2024-07-17 07:56:05.137623 45708818 54954087 120226443 SHOW WARNINGS 2024-07-17 07:55:41.557731 44441000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 351 17074454000 29799000 48645000 125947000 0 0 0 0 351 351 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.033572 2024-07-17 07:56:05.137978 75857757 104712854 131825673 SELECT @@lower_case_table_names 2024-07-17 07:56:02.524954 101826000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1581 550690259000 206421000 348317000 2341351000 306523000000 0 0 0 0 4743 0 0 0 0 0 0 1581 0 0 0 0 0 0 2024-07-17 07:46:01.035755 2024-07-17 07:56:05.150346 549540873 870963589 2089296130 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-07-17 07:55:33.164931 2341351000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 749 778467708000 477081000 1039342000 3605697000 276169000000 0 0 0 36221 185701 0 720 0 0 0 0 749 0 0 36137 720 0 0 2024-07-17 07:46:01.037459 2024-07-17 07:56:05.152732 1819700858 2398832919 3630780547 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-07-17 07:55:56.220394 2291822000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 350 444435050000 500621000 1269814000 56239860000 119629000000 0 0 0 711 22861 0 350 0 0 0 0 350 0 0 711 350 0 0 2024-07-17 07:46:01.093805 2024-07-17 07:56:05.140466 954992586 28840315031 57543993733 SHOW INDEXES FROM `mysql`.`user` 2024-07-17 07:55:56.216792 1043891000
mysql 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 276 12613275000 31213000 45700000 184268000 0 0 276 0 276 276 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.095224 2024-07-17 07:56:00.480347 66069344 83176377 190546071 SELECT @@have_profiling 2024-07-17 07:55:41.314322 66452000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 342 100821588000 128113000 294799000 40952442000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.095651 2024-07-17 07:56:05.141783 263026799 331131121 41686938347 SHOW CREATE TABLE `mysql`.`user` 2024-07-17 07:55:45.458310 254953000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 353 427578537000 682442000 1211270000 35493930000 144522000000 0 0 0 449 35941 0 350 350 0 0 0 353 0 0 449 353 350 0 2024-07-17 07:46:01.135639 2024-07-17 07:56:05.151402 1318256738 21877616239 36307805477 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-07-17 07:55:08.374013 1628502000
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 514 32403103000 27604000 63041000 205240000 0 0 0 0 514 514 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.199379 2024-07-17 07:56:05.200485 100000000 131825673 208929613 SELECT CURRENT_USER() 2024-07-17 07:56:04.499743 114242000
mysql 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 313 22190541000 48245000 70896000 218540000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.199667 2024-07-17 07:56:00.540545 95499258 138038426 218776162 SHOW GRANTS 2024-07-17 07:55:06.858211 83223000
mysql db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 1992 1121119395000 164775000 562810000 7038067000 410524000000 0 4 0 17874 117730 0 4473 3050 0 0 0 4498 0 0 32459 1082 1972 0 2024-07-17 07:46:01.206948 2024-07-17 07:56:05.213135 1202264434 1659586907 4570881896 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-07-17 07:55:06.865805 1897934000
StdMdDB ee9b71b0ca5691f4c25deb72b2711e3fef937f2d5779d22f6e... SELECT ? FROM `StdMdDB` . `user` LIMIT ? 4 14352044000 111149000 3588011000 13944474000 766000000 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 2024-07-17 07:46:01.211317 2024-07-17 07:46:01.904148 14454397707 14454397707 14454397707 SELECT 1 FROM `StdMdDB`.`user` LIMIT 1 2024-07-17 07:46:01.211317 13944474000
StdMdDB 1aa2301cfd9c2b126f072e5b2ab3b394cec7570cf581f8b878... SELECT @@`local_infile` 3 510753000 44268000 170251000 307340000 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-17 07:46:01.213175 2024-07-17 07:46:02.281012 316227766 316227766 316227766 SELECT @@local_infile 2024-07-17 07:46:02.233252 307340000
StdMdDB 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... 4 4771280000 276321000 1192820000 3762867000 823000000 0 0 0 164 328 0 0 0 0 0 0 4 0 0 0 0 4 0 2024-07-17 07:46:01.217484 2024-07-17 07:46:02.287480 3801893963 3801893963 3801893963 SELECT `CHARACTER_SET_NAME` AS `Charset`, `DEFAULT... 2024-07-17 07:46:01.217484 3762867000
performance_schema 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 1697 1425530834000 608771000 840029000 8820432000 151884000000 0 0 0 1697 974078 0 1697 0 0 0 0 3394 0 0 0 0 1697 0 2024-07-17 07:46:01.217909 2024-07-17 07:56:06.260566 1202264434 1659586907 6918309709 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-07-17 07:55:54.025063 1357425000
|
|
|
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