https://platform.retabit.es/es/explora/8173?slug=vulnerabilidad-olas-calor

Query Metrics

107 Database Queries
51 Different statements
153.68 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 20.31 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0
Parameters:
[]
2 22.17 ms
SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8173 LIMIT 1;
Parameters:
[]
3 25.31 ms
select
            mgm.climate_zone,
            count (*) as blg, --edificios
            sum(mgm.numberofdwellings) as dwe, --viviendas
            sum(mgm.habitantes) as hab, --habitantes
            (sum(mgm.kpi_2_final_energy_consumption*mgm.grossfloorarea  )/1000000)::int as kpi_2_final_energy_consumption, -- Unidades: GWh año
            (sum(mgm.kpi_8_ghg_emissions*mgm.grossfloorarea)/1000)::int as  kpi_8_ghg_emissions, -- Unidades: TCO año
            (100*avg(mgm.kpi_21_average_price_renting_compared_family_income))::int as kpi_21_average_price_renting_compared_family_income -- Unidades: % de los ingresos
        from mat_map_geo_buildings mgm where adminunit in (8173) and mgm.use <> '-' group by mgm.climate_zone
Parameters:
[]
4 1.44 ms
SELECT x.* FROM public.analytic x WHERE x.status = 1
Parameters:
[]
5 0.42 ms
SELECT x.* FROM public.analytic x WHERE x.status = 1
Parameters:
[]
6 2.06 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
7 2.07 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
8 1.57 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
9 2.12 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
10 1.93 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
11 4.43 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 9
	       order by ark.order
Parameters:
[]
12 0.50 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 31 (14%) habitantes: 62 (12%) precio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.24 (nivel: bajo)\nEmisiones de gases de efecto invernadero (KgCO2/m²año): 41.45 (nivel: alto)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.26 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6279.94 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
13 0.77 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
14 0.87 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
15 0.64 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
16 0.57 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
17 0.74 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
18 0.63 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
19 0.63 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
20 0.61 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
21 0.58 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
22 0.60 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
23 1.52 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 2
	       order by ark.order
Parameters:
[]
24 0.56 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios eficientes edificios: 47 (22%) habitantes: 128 (25%) consumo final de energía (kWh/m²año): 130.73 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 93.37 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nviviendas energéticamente eficientes: 0.04 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.90 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 6719.74 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
25 0.69 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
26 0.62 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
27 0.65 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
28 0.60 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
29 0.58 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
30 0.58 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
31 0.85 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
32 0.70 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
33 0.73 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
34 1.05 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
35 1.50 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 3
	       order by ark.order
Parameters:
[]
36 0.40 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Vulnerabilidad olas de calor edificios: 216 (100%) habitantes: 504 (100%) superficies de zonas verdes (Ha): 0.42 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6124.49 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.94 (nivel: alto)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
37 0.68 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
38 0.82 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
39 0.75 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
40 0.68 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
41 0.59 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
42 0.60 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
43 1.15 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
44 1.04 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
45 0.71 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
46 0.60 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
47 1.35 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 4
	       order by ark.order
Parameters:
[]
48 0.36 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios certificados energéticamente edificios: 38 (18%) habitantes: 118 (23%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.60 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.97 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 5645.61 (nivel: bajo)\n"
  8173
]
49 0.79 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
50 0.75 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
51 0.68 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
52 0.63 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
53 0.56 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
54 1.31 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 5
	       order by ark.order
Parameters:
[]
55 0.40 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios generadores de energía edificios: 18 (8%) habitantes: 45 (9%) viviendas energéticamente eficientes: 0.06 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 3862.17 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.61 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.89 (nivel: alto)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
56 1.63 ms
SELECT kpi_legend.bgcolor, kpi_legend.min, kpi_legend.max, kpi_legend.kpi_id 
        FROM public.kpi_legend
        -- GROUP BY kpi_legend.kpi_id, kpi_legend.id
        order by kpi_legend.kpi_id, kpi_legend.min ASC
Parameters:
[]
57 0.34 ms
SELECT x.* FROM public.analytic x WHERE x.status = 1
Parameters:
[]
58 0.67 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
59 0.63 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
60 0.65 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
61 0.64 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
62 0.63 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
63 1.35 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 9
	       order by ark.order
Parameters:
[]
64 0.33 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 31 (14%) habitantes: 62 (12%) precio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.24 (nivel: bajo)\nEmisiones de gases de efecto invernadero (KgCO2/m²año): 41.45 (nivel: alto)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.26 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6279.94 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
65 0.59 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
66 0.62 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
67 0.70 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
68 0.65 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
69 0.66 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
70 0.59 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
71 0.55 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
72 0.54 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
73 0.56 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
74 0.58 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
75 1.37 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 2
	       order by ark.order
Parameters:
[]
76 0.34 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios eficientes edificios: 47 (22%) habitantes: 128 (25%) consumo final de energía (kWh/m²año): 130.73 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 93.37 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nviviendas energéticamente eficientes: 0.04 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.90 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 6719.74 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
77 0.65 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
78 0.62 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
79 0.62 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
80 1.02 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
81 0.71 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
82 0.60 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
83 0.95 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
84 0.67 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
85 0.85 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
86 0.65 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
87 1.38 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 3
	       order by ark.order
Parameters:
[]
88 0.37 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Vulnerabilidad olas de calor edificios: 216 (100%) habitantes: 504 (100%) superficies de zonas verdes (Ha): 0.42 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6124.49 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.94 (nivel: alto)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
89 0.70 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
90 0.62 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
91 0.61 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
92 0.61 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
93 0.58 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
94 0.56 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
95 0.78 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
96 0.71 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
97 0.68 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
98 0.70 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
99 1.44 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 4
	       order by ark.order
Parameters:
[]
100 0.37 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios certificados energéticamente edificios: 38 (18%) habitantes: 118 (23%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.60 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.97 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 5645.61 (nivel: bajo)\n"
  8173
]
101 0.66 ms
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
102 0.66 ms
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
103 0.62 ms
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
104 0.60 ms
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
105 0.63 ms
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
106 1.58 ms
select *
               from stat_analytic_related_kpis sa
	       join kpi k on k.id = sa.kpi
               left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi 
	       where adminunit in (8173) and analytic = 5
	       order by ark.order
Parameters:
[]
107 0.37 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios generadores de energía edificios: 18 (8%) habitantes: 45 (9%) viviendas energéticamente eficientes: 0.06 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 3862.17 (nivel: bajo)\nprecio de la vivienda (€/m2): 4.10 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.61 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.89 (nivel: alto)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]

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.

Entities Mapping

Class Mapping errors
App\Entity\CacheAi No errors.
App\Entity\Municipio No errors.
App\Entity\Analytic No errors.