Query Metrics
247
Database Queries
10
Different statements
49.94 ms
Query time
3
Invalid entities
484
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
17.77 ms (35.57%) |
84 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.territorios AS territorios_6, t0.tendencia_deseada AS tendencia_deseada_7, t0.valor_objetivo AS valor_objetivo_8, t0.justificacion_valor_objetivo AS justificacion_valor_objetivo_9, t0.umbral_minimo_teorico AS umbral_minimo_teorico_10, t0.umbral_maximo_teorico AS umbral_maximo_teorico_11, t0.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_12, t0.metodo_calculo AS metodo_calculo_13, t0.fuentes AS fuentes_14, t0.datos_historicos AS datos_historicos_15, t0.indicador_repetido AS indicador_repetido_16, t0.referencias AS referencias_17, t0.automatizable AS automatizable_18, t0.descripcion AS descripcion_19, t0.set_entity_id AS set_entity_id_20, t0.metodo_obtencion_id AS metodo_obtencion_id_21, t0.periodicidad_publicacion_id AS periodicidad_publicacion_id_22, t0.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_23, t0.unidad_medida_id AS unidad_medida_id_24, t0.tipo_indicador_id AS tipo_indicador_id_25, t0.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_26, t0.objetivo_uae_id AS objetivo_uae_id_27, t0.calculo_id AS calculo_id_28, t0.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_29, t0.meta_id AS meta_id_30 FROM indicador t0 WHERE t0.id = ?
Parameters:
[
511
]
|
||||||||||||||||||||||||||||||||
|
16.18 ms (32.40%) |
84 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.valor_tras_formula AS valor_tras_formula_4, t0.valor_real_alcanzado AS valor_real_alcanzado_5, t0.valor_objetivo AS valor_objetivo_6, t0.umbral_minimo_teorico AS umbral_minimo_teorico_7, t0.umbral_maximo_teorico AS umbral_maximo_teorico_8, t0.valor_homogenizado AS valor_homogenizado_9, t0.semaforizacion AS semaforizacion_10, t0.informacion_adicional AS informacion_adicional_11, t0.observaciones AS observaciones_12, t0.observaciones_validador AS observaciones_validador_13, t0.texto_ivl AS texto_ivl_14, t0.mostrar_ivl AS mostrar_ivl_15, t0.fecha_validado AS fecha_validado_16, t0.estado AS estado_17, t0.anio AS anio_18, t0.path AS path_19, t0.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_20, t0.entidad_local_id AS entidad_local_id_21, t0.indicador_id AS indicador_id_22, t0.usuario_id AS usuario_id_23 FROM resultado t0 WHERE t0.id = ?
Parameters:
[
6164
]
|
||||||||||||||||||||||||||||||||
|
11.00 ms (22.02%) |
56 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.57 ms (5.15%) |
17 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
|
1.67 ms (3.35%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2, p0_.titulo AS titulo_3, p0_.subtitulo AS subtitulo_4, p0_.cuerpo AS cuerpo_5, p0_.imagen AS imagen_6, p0_.tipo_pagina AS tipo_pagina_7, p0_.tipoplantilla AS tipoplantilla_8, p0_.tipografica AS tipografica_9, p0_.tipo_chart AS tipo_chart_10, p0_.variables AS variables_11, p0_.orden AS orden_12, p0_.actualizar_pagina AS actualizar_pagina_13, p0_.mostrar_imagen_fondo AS mostrar_imagen_fondo_14, p0_.log_generacion AS log_generacion_15, p0_.fecha_generacion AS fecha_generacion_16, p0_.disposicion_indicador AS disposicion_indicador_17, p0_.ivl_id AS ivl_id_18, p0_.resultado_id AS resultado_id_19 FROM pagina p0_ WHERE p0_.ivl_id = ? AND p0_.deleted_at IS NULL ORDER BY p0_.orden ASC
Parameters:
[
124
]
|
||||||||||||||||||||||||||||||||
|
0.21 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.14 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.titulo AS titulo_4, t0.estado AS estado_5, t0.anio AS anio_6, t0.anios_seleccionados AS anios_seleccionados_7, t0.texto_introduccion AS texto_introduccion_8, t0.texto_metodologia AS texto_metodologia_9, t0.color_titulos AS color_titulos_10, t0.color_subtitulos AS color_subtitulos_11, t0.color_textos AS color_textos_12, t0.color_fondo AS color_fondo_13, t0.color_acento AS color_acento_14, t0.color_superficie AS color_superficie_15, t0.path_portada AS path_portada_16, t0.path_contraportada AS path_contraportada_17, t0.path_fondo AS path_fondo_18, t0.path_logo AS path_logo_19, t0.fuente AS fuente_20, t0.variante_portada AS variante_portada_21, t0.estilo_numeracion AS estilo_numeracion_22, t0.disposicion_indicador AS disposicion_indicador_23, t0.tema AS tema_24, t0.entidadlocal_id AS entidadlocal_id_25 FROM ivl t0 WHERE t0.id = ?
Parameters:
[
"124"
]
|
||||||||||||||||||||||||||||||||
|
0.14 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.nombre AS nombre_6, t0.apellidos AS apellidos_7, t0.direccion AS direccion_8, t0.email AS email_9, t0.codigo2_fa AS codigo2_fa_10, t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_expires_at AS reset_password_expires_at_13, t0.estado2_fa AS estado2_fa_14, t0.comunidad_id AS comunidad_id_15, t0.provincia_id AS provincia_id_16, t0.poblacion_id AS poblacion_id_17 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
|
0.13 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.role AS role_3 FROM role t0 INNER JOIN usuario_role ON t0.id = usuario_role.role_id WHERE usuario_role.usuario_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
|
0.13 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.nombre AS nombre_4, t0.slug AS slug_5, t0.codigo_postal AS codigo_postal_6, t0.direccion AS direccion_7, t0.latitud AS latitud_8, t0.longitud AS longitud_9, t0.descripcion_min AS descripcion_min_10, t0.descripcion AS descripcion_11, t0.path AS path_12, t0.codigo_ine AS codigo_ine_13, t0.habitantes AS habitantes_14, t0.auto_evaluar_datos AS auto_evaluar_datos_15, t0.mostrar_parte_publica AS mostrar_parte_publica_16, t0.path_portada_ivl AS path_portada_ivl_17, t0.path_fondo_ivl AS path_fondo_ivl_18, t0.path_contraportada_ivl AS path_contraportada_ivl_19, t0.optimizado_portada_ivl AS optimizado_portada_ivl_20, t0.optimizado_fondo_ivl AS optimizado_fondo_ivl_21, t0.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_22, t0.color_titulos_ivl AS color_titulos_ivl_23, t0.color_subtitulos_ivl AS color_subtitulos_ivl_24, t0.color_textos_ivl AS color_textos_ivl_25, t0.color_corporativo AS color_corporativo_26, t0.color_fondo AS color_fondo_27, t0.comunidad_id AS comunidad_id_28, t0.provincia_id AS provincia_id_29, t0.poblacion_id AS poblacion_id_30 FROM entidad_local t0 WHERE t0.id = ?
Parameters:
[
5
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Pagina | 162 |
| App\Entity\Resultado | 84 |
| App\Entity\Indicador | 84 |
| App\Entity\Meta | 56 |
| App\Entity\Calculo | 20 |
| App\Entity\Ods | 17 |
| App\Entity\UnidadMedida | 15 |
| App\Entity\ObjetivoUAE | 10 |
| App\Entity\PeriodicidadPublicacion | 8 |
| App\Entity\FuenteValorObjetivo | 4 |
| App\Entity\MetodoObtencion | 3 |
| App\Entity\FrecuenciaActualizacion | 3 |
| App\Entity\TipoIndicador | 3 |
| App\Entity\SubFuenteValorObjetivo | 3 |
| App\Entity\Comunidad | 2 |
| App\Entity\Provincia | 2 |
| App\Entity\Poblacion | 2 |
| App\Entity\Smtp | 1 |
| App\Entity\Usuario | 1 |
| App\Entity\Role | 1 |
| App\Entity\Ivl | 1 |
| App\Entity\EntidadLocal | 1 |
| App\Entity\SetEntity | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Smtp | No errors. |
| App\Entity\Usuario |
|
| App\Entity\Comunidad | No errors. |
| App\Entity\Provincia |
|
| App\Entity\Poblacion |
|
| App\Entity\Role | No errors. |
| App\Entity\EntidadLocal | No errors. |
| App\Entity\Cluster | No errors. |
| App\Entity\Ivl | No errors. |
| App\Entity\Pagina | No errors. |
| App\Entity\Resultado | No errors. |
| App\Entity\Anio | No errors. |
| App\Entity\Indicador | No errors. |
| App\Entity\SetEntity | No errors. |
| App\Entity\MetodoObtencion | No errors. |
| App\Entity\PeriodicidadPublicacion | No errors. |
| App\Entity\FrecuenciaActualizacion | No errors. |
| App\Entity\UnidadMedida | No errors. |
| App\Entity\TipoIndicador | No errors. |
| App\Entity\FuenteValorObjetivo | No errors. |
| App\Entity\ObjetivoUAE | No errors. |
| App\Entity\Calculo | No errors. |
| App\Entity\SubFuenteValorObjetivo | No errors. |
| App\Entity\Meta | No errors. |
| App\Entity\Ods | No errors. |