Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

119 Database Queries

54 Different statements

220.36 ms Query time

0 Invalid entities

Queries

Group similar statements


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
SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8015 LIMIT 1;
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 (8015) and mgm.use <> '-' group by mgm.climate_zone
SELECT x.* FROM public.analytic x WHERE x.status = 1
SELECT x.* FROM public.analytic x WHERE x.status = 1
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 9
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 (8015) and analytic = 9
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 6
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 (8015) and analytic = 6
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 2
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 (8015) and analytic = 2
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 8
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 (8015) and analytic = 8
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 3
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 (8015) and analytic = 3
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 1
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 (8015) and analytic = 1
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 4
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 (8015) and analytic = 4
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 5
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 (8015) and analytic = 5
	       order by ark.order
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
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
SELECT x.* FROM public.analytic x WHERE x.status = 1
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 9
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 9
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 (8015) and analytic = 9
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 6
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 6
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 (8015) and analytic = 6
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 2
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 (8015) and analytic = 2
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 8
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 8
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 (8015) and analytic = 8
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 3
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 3
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 (8015) and analytic = 3
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 1
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 1
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 (8015) and analytic = 1
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 4
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 4
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 (8015) and analytic = 4
	       order by ark.order
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
select *
                  from stat_analytic_data
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_year
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8015) and analytic = 5
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8015) and analytic = 5
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 (8015) and analytic = 5
	       order by ark.order
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

#▲	Time	Info
1	20.53 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: [] View formatted query View runnable query Explain query 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 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;
2	22.95 ms	SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8015 LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT adminunitname, geom, Box2D( ST_envelope(geom) ) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8015 LIMIT 1; SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8015 LIMIT 1;;
3	60.82 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_consumptionmgm.grossfloorarea )/1000000)::int as kpi_2_final_energy_consumption, -- Unidades: GWh año (sum(mgm.kpi_8_ghg_emissionsmgm.grossfloorarea)/1000)::int as kpi_8_ghg_emissions, -- Unidades: TCO año (100avg(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 (8015) and mgm.use <> '-' group by mgm.climate_zone Parameters: [] View formatted query View runnable query Explain query 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 (8015) and mgm.use <> '-' group by mgm.climate_zone 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_consumptionmgm.grossfloorarea )/1000000)::int as kpi_2_final_energy_consumption, -- Unidades: GWh año (sum(mgm.kpi_8_ghg_emissionsmgm.grossfloorarea)/1000)::int as kpi_8_ghg_emissions, -- Unidades: TCO año (100avg(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 (8015) and mgm.use <> '-' group by mgm.climate_zone;
4	1.72 ms	SELECT x.* FROM public.analytic x WHERE x.status = 1 Parameters: [] View formatted query View runnable query Explain query SELECT x.* FROM public.analytic x WHERE x.status = 1 SELECT x.* FROM public.analytic x WHERE x.status = 1;
5	0.48 ms	SELECT x.* FROM public.analytic x WHERE x.status = 1 Parameters: [] View formatted query View runnable query Explain query SELECT x.* FROM public.analytic x WHERE x.status = 1 SELECT x.* FROM public.analytic x WHERE x.status = 1;
6	2.52 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 9 select * from stat_analytic_data where adminunit in (8015) and analytic = 9;
7	2.65 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9;
8	2.26 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 9 select * from stat_analytic_year where adminunit in (8015) and analytic = 9;
9	2.26 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9;
10	2.09 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9;
11	4.39 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 (8015) and analytic = 9 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 9 order by ark.order 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 (8015) and analytic = 9 order by ark.order;
12	0.63 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: 7428 (57%) habitantes: 144740 (62%) precio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.84 (nivel: alto)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.89 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4458.70 (nivel: bajo)\nacceso a puntos de recarga: 52662.63 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 7428 (57%) habitantes: 144740 (62%) precio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.84 (nivel: alto)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.89 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4458.70 (nivel: bajo)\\nacceso a puntos de recarga: 52662.63 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
13	0.96 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 6 select * from stat_analytic_data where adminunit in (8015) and analytic = 6;
14	0.78 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6;
15	0.88 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 6 select * from stat_analytic_year where adminunit in (8015) and analytic = 6;
16	1.00 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6;
17	0.84 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6;
18	1.78 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 (8015) and analytic = 6 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 6 order by ark.order 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 (8015) and analytic = 6 order by ark.order;
19	0.42 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 con gran potencial de generación edificios: 111 (1%) habitantes: 16873 (7%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\nconsumo final de energía (kWh/m²año): 168.90 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 116.02 (nivel: bajo)\nacceso a puntos de recarga: 42457.32 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 8.37 (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): 56102.76 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios con gran potencial de generación edificios: 111 (1%) habitantes: 16873 (7%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\\nconsumo final de energía (kWh/m²año): 168.90 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 116.02 (nivel: bajo)\\nacceso a puntos de recarga: 42457.32 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 8.37 (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): 56102.76 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
20	0.79 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 2 select * from stat_analytic_data where adminunit in (8015) and analytic = 2;
21	0.74 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2;
22	0.97 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 2 select * from stat_analytic_year where adminunit in (8015) and analytic = 2;
23	0.87 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2;
24	0.88 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2;
25	1.92 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 (8015) and analytic = 2 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 2 order by ark.order 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 (8015) and analytic = 2 order by ark.order;
26	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: 748 (6%) habitantes: 17247 (7%) consumo final de energía (kWh/m²año): 128.10 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 85.97 (nivel: bajo)\nviviendas energéticamente eficientes: 0.10 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.66 (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): 7636.14 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios eficientes edificios: 748 (6%) habitantes: 17247 (7%) consumo final de energía (kWh/m²año): 128.10 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 85.97 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.10 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.66 (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): 7636.14 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
27	0.87 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 8 select * from stat_analytic_data where adminunit in (8015) and analytic = 8;
28	0.90 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8;
29	0.80 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 8 select * from stat_analytic_year where adminunit in (8015) and analytic = 8;
30	0.82 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8;
31	0.77 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8;
32	1.91 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 (8015) and analytic = 8 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 8 order by ark.order 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 (8015) and analytic = 8 order by ark.order;
33	0.63 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: Vida inasequible y falta de equidad social edificios: 4466 (34%) habitantes: 31580 (14%) población con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 6.17 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4028.67 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.86 (nivel: alto)\nacceso a puntos de recarga: 57995.16 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Vida inasequible y falta de equidad social edificios: 4466 (34%) habitantes: 31580 (14%) población con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 6.17 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4028.67 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.86 (nivel: alto)\\nacceso a puntos de recarga: 57995.16 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
34	1.01 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 3 select * from stat_analytic_data where adminunit in (8015) and analytic = 3;
35	0.84 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3;
36	0.75 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 3 select * from stat_analytic_year where adminunit in (8015) and analytic = 3;
37	0.71 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3;
38	0.78 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3;
39	1.96 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 (8015) and analytic = 3 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 3 order by ark.order 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 (8015) and analytic = 3 order by ark.order;
40	0.49 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: 10033 (77%) habitantes: 170882 (74%) superficies de zonas verdes (Ha): 3.80 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4313.73 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.92 (nivel: alto)\nacceso a puntos de recarga: 57432.37 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Vulnerabilidad olas de calor edificios: 10033 (77%) habitantes: 170882 (74%) superficies de zonas verdes (Ha): 3.80 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4313.73 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.92 (nivel: alto)\\nacceso a puntos de recarga: 57432.37 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
41	0.73 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 1 select * from stat_analytic_data where adminunit in (8015) and analytic = 1;
42	0.74 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1;
43	0.69 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 1 select * from stat_analytic_year where adminunit in (8015) and analytic = 1;
44	0.72 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1;
45	0.68 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1;
46	1.69 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 (8015) and analytic = 1 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 1 order by ark.order 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 (8015) and analytic = 1 order by ark.order;
47	0.52 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: Población económicamente vulnerable edificios: 82 (1%) habitantes: 6761 (3%) ingresos familiares medios (€): 20896.83 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 132.60 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 17.09 (nivel: alto)\nacceso al carril bici: 0.91 (nivel: alto)\nsuperficies de zonas verdes (Ha): 1.74 (nivel: bajo)\nacceso a puntos de recarga: (nivel: )\npotencial de generación solar fotovoltaica (kWh/m²año): 10309.54 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 1.00 (nivel: alto)\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Población económicamente vulnerable edificios: 82 (1%) habitantes: 6761 (3%) ingresos familiares medios (€): 20896.83 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 132.60 (nivel: bajo)\\nequipamiento urbano a 15 minutos caminando: 17.09 (nivel: alto)\\nacceso al carril bici: 0.91 (nivel: alto)\\nsuperficies de zonas verdes (Ha): 1.74 (nivel: bajo)\\nacceso a puntos de recarga: (nivel: )\\npotencial de generación solar fotovoltaica (kWh/m²año): 10309.54 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 1.00 (nivel: alto)\\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\\n' AND t0.adminunit = 8015 LIMIT 1;
48	0.85 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 4 select * from stat_analytic_data where adminunit in (8015) and analytic = 4;
49	0.79 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4;
50	0.74 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 4 select * from stat_analytic_year where adminunit in (8015) and analytic = 4;
51	0.71 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4;
52	0.71 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4;
53	1.85 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 (8015) and analytic = 4 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 4 order by ark.order 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 (8015) and analytic = 4 order by ark.order;
54	0.51 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: 6835 (53%) habitantes: 202111 (87%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\nacceso a puntos de recarga: 55391.86 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.27 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.95 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 6526.37 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios certificados energéticamente edificios: 6835 (53%) habitantes: 202111 (87%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\\nacceso a puntos de recarga: 55391.86 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.27 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.95 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 6526.37 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
55	0.78 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 5 select * from stat_analytic_data where adminunit in (8015) and analytic = 5;
56	0.69 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5;
57	0.69 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 5 select * from stat_analytic_year where adminunit in (8015) and analytic = 5;
58	0.72 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5;
59	0.92 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5;
60	1.56 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 (8015) and analytic = 5 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 5 order by ark.order 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 (8015) and analytic = 5 order by ark.order;
61	0.65 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: 535 (4%) habitantes: 6037 (3%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6138.23 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.96 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\nacceso al carril bici: 0.73 (nivel: alto)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.93 (nivel: alto)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios generadores de energía edificios: 535 (4%) habitantes: 6037 (3%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 6138.23 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.96 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\nacceso al carril bici: 0.73 (nivel: alto)\\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.93 (nivel: alto)\\n' AND t0.adminunit = 8015 LIMIT 1;
62	2.07 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: [] View formatted query View runnable query Explain query 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 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;
63	0.38 ms	SELECT x.* FROM public.analytic x WHERE x.status = 1 Parameters: [] View formatted query View runnable query Explain query SELECT x.* FROM public.analytic x WHERE x.status = 1 SELECT x.* FROM public.analytic x WHERE x.status = 1;
64	0.77 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 9 select * from stat_analytic_data where adminunit in (8015) and analytic = 9;
65	0.79 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 9;
66	0.92 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 9 select * from stat_analytic_year where adminunit in (8015) and analytic = 9;
67	0.78 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 9;
68	0.95 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 9;
69	1.92 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 (8015) and analytic = 9 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 9 order by ark.order 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 (8015) and analytic = 9 order by ark.order;
70	0.42 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: 7428 (57%) habitantes: 144740 (62%) precio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.84 (nivel: alto)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.89 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4458.70 (nivel: bajo)\nacceso a puntos de recarga: 52662.63 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 7428 (57%) habitantes: 144740 (62%) precio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.84 (nivel: alto)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.89 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4458.70 (nivel: bajo)\\nacceso a puntos de recarga: 52662.63 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
71	0.85 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 6 select * from stat_analytic_data where adminunit in (8015) and analytic = 6;
72	0.81 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 6;
73	0.78 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 6 select * from stat_analytic_year where adminunit in (8015) and analytic = 6;
74	0.95 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 6;
75	0.77 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 6;
76	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 (8015) and analytic = 6 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 6 order by ark.order 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 (8015) and analytic = 6 order by ark.order;
77	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 con gran potencial de generación edificios: 111 (1%) habitantes: 16873 (7%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\nconsumo final de energía (kWh/m²año): 168.90 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 116.02 (nivel: bajo)\nacceso a puntos de recarga: 42457.32 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 8.37 (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): 56102.76 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios con gran potencial de generación edificios: 111 (1%) habitantes: 16873 (7%) viviendas energéticamente eficientes: 0.05 (nivel: bajo)\\nconsumo final de energía (kWh/m²año): 168.90 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 116.02 (nivel: bajo)\\nacceso a puntos de recarga: 42457.32 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 8.37 (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): 56102.76 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
78	0.63 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 2 select * from stat_analytic_data where adminunit in (8015) and analytic = 2;
79	0.61 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 2;
80	0.85 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 2 select * from stat_analytic_year where adminunit in (8015) and analytic = 2;
81	0.77 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 2;
82	0.94 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 2;
83	1.78 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 (8015) and analytic = 2 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 2 order by ark.order 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 (8015) and analytic = 2 order by ark.order;
84	0.44 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: 748 (6%) habitantes: 17247 (7%) consumo final de energía (kWh/m²año): 128.10 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 85.97 (nivel: bajo)\nviviendas energéticamente eficientes: 0.10 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.66 (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): 7636.14 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios eficientes edificios: 748 (6%) habitantes: 17247 (7%) consumo final de energía (kWh/m²año): 128.10 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 85.97 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.10 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.66 (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): 7636.14 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
85	0.79 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 8 select * from stat_analytic_data where adminunit in (8015) and analytic = 8;
86	0.78 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 8;
87	0.70 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 8 select * from stat_analytic_year where adminunit in (8015) and analytic = 8;
88	0.74 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 8;
89	0.88 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 8;
90	1.81 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 (8015) and analytic = 8 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 8 order by ark.order 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 (8015) and analytic = 8 order by ark.order;
91	0.45 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: Vida inasequible y falta de equidad social edificios: 4466 (34%) habitantes: 31580 (14%) población con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 6.17 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4028.67 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.86 (nivel: alto)\nacceso a puntos de recarga: 57995.16 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Vida inasequible y falta de equidad social edificios: 4466 (34%) habitantes: 31580 (14%) población con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 6.17 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4028.67 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.86 (nivel: alto)\\nacceso a puntos de recarga: 57995.16 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
92	0.89 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 3 select * from stat_analytic_data where adminunit in (8015) and analytic = 3;
93	0.83 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 3;
94	0.89 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 3 select * from stat_analytic_year where adminunit in (8015) and analytic = 3;
95	0.97 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 3;
96	0.85 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 3;
97	1.64 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 (8015) and analytic = 3 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 3 order by ark.order 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 (8015) and analytic = 3 order by ark.order;
98	0.43 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: 10033 (77%) habitantes: 170882 (74%) superficies de zonas verdes (Ha): 3.80 (nivel: bajo)\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 4313.73 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.92 (nivel: alto)\nacceso a puntos de recarga: 57432.37 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Vulnerabilidad olas de calor edificios: 10033 (77%) habitantes: 170882 (74%) superficies de zonas verdes (Ha): 3.80 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4313.73 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.92 (nivel: alto)\\nacceso a puntos de recarga: 57432.37 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
99	0.98 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 1 select * from stat_analytic_data where adminunit in (8015) and analytic = 1;
100	0.83 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 1;
101	0.92 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 1 select * from stat_analytic_year where adminunit in (8015) and analytic = 1;
102	1.14 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 1;
103	0.79 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 1;
104	1.73 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 (8015) and analytic = 1 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 1 order by ark.order 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 (8015) and analytic = 1 order by ark.order;
105	0.43 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: Población económicamente vulnerable edificios: 82 (1%) habitantes: 6761 (3%) ingresos familiares medios (€): 20896.83 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\nconsumo de energía de calefacción (kWh/m²año): 132.60 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 17.09 (nivel: alto)\nacceso al carril bici: 0.91 (nivel: alto)\nsuperficies de zonas verdes (Ha): 1.74 (nivel: bajo)\nacceso a puntos de recarga: (nivel: )\npotencial de generación solar fotovoltaica (kWh/m²año): 10309.54 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 1.00 (nivel: alto)\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Población económicamente vulnerable edificios: 82 (1%) habitantes: 6761 (3%) ingresos familiares medios (€): 20896.83 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 132.60 (nivel: bajo)\\nequipamiento urbano a 15 minutos caminando: 17.09 (nivel: alto)\\nacceso al carril bici: 0.91 (nivel: alto)\\nsuperficies de zonas verdes (Ha): 1.74 (nivel: bajo)\\nacceso a puntos de recarga: (nivel: )\\npotencial de generación solar fotovoltaica (kWh/m²año): 10309.54 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 1.00 (nivel: alto)\\nviviendas energéticamente eficientes y recuperadoras de energía: 1.00 (nivel: alto)\\n' AND t0.adminunit = 8015 LIMIT 1;
106	0.84 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 4 select * from stat_analytic_data where adminunit in (8015) and analytic = 4;
107	0.79 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 4;
108	0.71 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 4 select * from stat_analytic_year where adminunit in (8015) and analytic = 4;
109	0.69 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 4;
110	0.69 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 4;
111	1.60 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 (8015) and analytic = 4 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 4 order by ark.order 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 (8015) and analytic = 4 order by ark.order;
112	0.45 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: 6835 (53%) habitantes: 202111 (87%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\nacceso a puntos de recarga: 55391.86 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.27 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.95 (nivel: alto)\npotencial de generación solar fotovoltaica (kWh/m²año): 6526.37 (nivel: bajo)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios certificados energéticamente edificios: 6835 (53%) habitantes: 202111 (87%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\\nacceso a puntos de recarga: 55391.86 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.27 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.01 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.95 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 6526.37 (nivel: bajo)\\n' AND t0.adminunit = 8015 LIMIT 1;
113	0.97 ms	select * from stat_analytic_data where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_data where adminunit in (8015) and analytic = 5 select * from stat_analytic_data where adminunit in (8015) and analytic = 5;
114	0.68 ms	select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5 select * from stat_analytic_buildinguse where adminunit in (8015) and analytic = 5;
115	0.88 ms	select * from stat_analytic_year where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_year where adminunit in (8015) and analytic = 5 select * from stat_analytic_year where adminunit in (8015) and analytic = 5;
116	0.80 ms	select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5 select * from stat_analytic_grossfloorarea where adminunit in (8015) and analytic = 5;
117	0.83 ms	select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5 Parameters: [] View formatted query View runnable query Explain query select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5 select * from stat_analytic_ocupacion where adminunit in (8015) and analytic = 5;
118	1.54 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 (8015) and analytic = 5 order by ark.order Parameters: [] View formatted query View runnable query Explain query 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 (8015) and analytic = 5 order by ark.order 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 (8015) and analytic = 5 order by ark.order;
119	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: 535 (4%) habitantes: 6037 (3%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6138.23 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 5.96 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\nacceso al carril bici: 0.73 (nivel: alto)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nviviendas energéticamente eficientes y recuperadoras de energía: 0.93 (nivel: alto)\n" 8015] View formatted query View runnable query Explain query 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 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 = 'Indicadores: tema: Edificios generadores de energía edificios: 535 (4%) habitantes: 6037 (3%) viviendas energéticamente eficientes: 0.02 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 6138.23 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.96 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.27 (nivel: bajo)\\nacceso al carril bici: 0.73 (nivel: alto)\\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.93 (nivel: alto)\\n' AND t0.adminunit = 8015 LIMIT 1;

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.

Symfony Profiler

https://platform.retabit.es/es/explora/8015?slug=edificios-certificados-energeticamente

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping