Query Metrics
26
Database Queries
12
Different statements
7.78 ms
Query time
3
Invalid entities
1669
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.28 ms |
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
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.20 ms |
SELECT e0_.id AS id_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.nombre AS nombre_3, e0_.slug AS slug_4, e0_.codigo_postal AS codigo_postal_5, e0_.direccion AS direccion_6, e0_.latitud AS latitud_7, e0_.longitud AS longitud_8, e0_.descripcion_min AS descripcion_min_9, e0_.descripcion AS descripcion_10, e0_.path AS path_11, e0_.codigo_ine AS codigo_ine_12, e0_.habitantes AS habitantes_13, e0_.auto_evaluar_datos AS auto_evaluar_datos_14, e0_.mostrar_parte_publica AS mostrar_parte_publica_15, e0_.path_portada_ivl AS path_portada_ivl_16, e0_.path_fondo_ivl AS path_fondo_ivl_17, e0_.path_contraportada_ivl AS path_contraportada_ivl_18, e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19, e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20, e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21, e0_.color_titulos_ivl AS color_titulos_ivl_22, e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23, e0_.color_textos_ivl AS color_textos_ivl_24, e0_.color_corporativo AS color_corporativo_25, e0_.color_fondo AS color_fondo_26, e0_.comunidad_id AS comunidad_id_27, e0_.provincia_id AS provincia_id_28, e0_.poblacion_id AS poblacion_id_29 FROM entidad_local e0_ WHERE e0_.slug = ? AND e0_.deleted_at IS NULL
Parameters:
[
"AYUNTAMIENTO-DE-BENETUSSER"
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.21 ms |
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:
[
13
]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.56 ms |
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.deleted_at IS NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.19 ms |
SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.created_at AS created_at_2, o0_.orden AS orden_3, o0_.nombre AS nombre_4, o0_.color AS color_5, o0_.path_ivl AS path_ivl_6 FROM ods o0_ WHERE o0_.deleted_at IS NULL ORDER BY o0_.orden ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.20 ms |
SELECT a0_.id AS id_0, a0_.deleted_at AS deleted_at_1, a0_.created_at AS created_at_2, a0_.anio AS anio_3, a0_.estado AS estado_4, a0_.entidad_local_id AS entidad_local_id_5 FROM anio a0_ WHERE a0_.entidad_local_id = ? AND a0_.deleted_at IS NULL AND a0_.estado = 3 ORDER BY a0_.anio DESC
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.23 ms |
SELECT o0_.id AS id_0, o0_.nombre AS nombre_1, o0_.color AS color_2, o0_.orden AS orden_3, AVG(r1_.valor_homogenizado) AS sclr_4, COUNT(r1_.id) AS sclr_5 FROM resultado r1_ INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id INNER JOIN meta m3_ ON i2_.meta_id = m3_.id INNER JOIN ods o0_ ON m3_.ods_id = o0_.id WHERE r1_.anio = ? AND r1_.entidad_local_id = ? AND r1_.deleted_at IS NULL AND r1_.valor_homogenizado IS NOT NULL AND i2_.deleted_at IS NULL AND m3_.deleted_at IS NULL AND o0_.deleted_at IS NULL AND r1_.estado = 3 GROUP BY o0_.id ORDER BY o0_.orden ASC
Parameters:
[ 2024 6 ]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.21 ms |
SELECT o0_.id AS id_0, AVG(r1_.valor_homogenizado) AS sclr_1, COUNT(r1_.id) AS sclr_2 FROM resultado r1_ INNER JOIN indicador i2_ ON r1_.indicador_id = i2_.id INNER JOIN meta m3_ ON i2_.meta_id = m3_.id INNER JOIN ods o0_ ON m3_.ods_id = o0_.id WHERE r1_.anio = ? AND r1_.deleted_at IS NULL AND r1_.valor_homogenizado IS NOT NULL AND i2_.deleted_at IS NULL AND m3_.deleted_at IS NULL AND o0_.deleted_at IS NULL AND r1_.estado = 3 GROUP BY o0_.id ORDER BY o0_.orden ASC
Parameters:
[
2024
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.18 ms |
SELECT r0_.anio AS anio_0, AVG(r0_.valor_homogenizado) AS sclr_1 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id WHERE r0_.entidad_local_id = ? AND r0_.deleted_at IS NULL AND r0_.valor_homogenizado IS NOT NULL AND i1_.deleted_at IS NULL AND m2_.deleted_at IS NULL AND r0_.estado = 3 GROUP BY r0_.anio ORDER BY r0_.anio ASC
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||||
| 10 | 2.19 ms |
SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id INNER JOIN entidad_local e4_ ON r0_.entidad_local_id = e4_.id WHERE r0_.deleted_at IS NULL AND r0_.valor_homogenizado IS NOT NULL AND i1_.deleted_at IS NULL AND m2_.deleted_at IS NULL AND o3_.deleted_at IS NULL AND r0_.anio = ? AND e4_.id = ? AND o3_.id = ?
Parameters:
[ 2024 6 13 ]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.20 ms |
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:
[
654
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.20 ms |
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:
[
69
]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.28 ms |
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:
[
658
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.20 ms |
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:
[
659
]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.19 ms |
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:
[
661
]
|
||||||||||||||||||||||||||||||||||
| 16 | 0.20 ms |
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:
[
664
]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.19 ms |
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:
[
70
]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.18 ms |
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:
[
666
]
|
||||||||||||||||||||||||||||||||||
| 19 | 0.23 ms |
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:
[
71
]
|
||||||||||||||||||||||||||||||||||
| 20 | 0.20 ms |
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:
[
667
]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.31 ms |
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:
[
672
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.18 ms |
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:
[
73
]
|
||||||||||||||||||||||||||||||||||
| 23 | 0.19 ms |
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:
[
675
]
|
||||||||||||||||||||||||||||||||||
| 24 | 0.20 ms |
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:
[
685
]
|
||||||||||||||||||||||||||||||||||
| 25 | 0.16 ms |
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:
[
76
]
|
||||||||||||||||||||||||||||||||||
| 26 | 0.22 ms |
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:
[
655
]
|
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\EntidadLocal | 778 |
| App\Entity\Poblacion | 749 |
| App\Entity\Provincia | 48 |
| App\Entity\Comunidad | 17 |
| App\Entity\Ods | 17 |
| App\Entity\Resultado | 11 |
| App\Entity\Indicador | 11 |
| App\Entity\UnidadMedida | 7 |
| App\Entity\ObjetivoUAE | 6 |
| App\Entity\Meta | 5 |
| App\Entity\FuenteValorObjetivo | 4 |
| App\Entity\SetEntity | 2 |
| App\Entity\MetodoObtencion | 2 |
| App\Entity\PeriodicidadPublicacion | 2 |
| App\Entity\FrecuenciaActualizacion | 2 |
| App\Entity\TipoIndicador | 2 |
| App\Entity\Calculo | 2 |
| App\Entity\Smtp | 1 |
| App\Entity\Anio | 1 |
| App\Entity\Usuario | 1 |
| App\Entity\SubFuenteValorObjetivo | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Smtp | No errors. |
| App\Entity\EntidadLocal | No errors. |
| App\Entity\Comunidad | No errors. |
| App\Entity\Provincia |
|
| App\Entity\Poblacion |
|
| App\Entity\Usuario |
|
| App\Entity\Cluster | No errors. |
| App\Entity\Anio | No errors. |
| App\Entity\Ivl | No errors. |
| App\Entity\Ods | No errors. |
| App\Entity\Resultado | No errors. |
| App\Entity\Indicador | No errors. |
| App\Entity\Meta | No errors. |
| App\Entity\Pagina | 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. |