https://platform.retabit.es/es/explora/8173?slug=edificios-eficientes

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
27.26 ms
(14.22%)
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 (8173) and mgm.use <> '-' group by mgm.climate_zone
Parameters:
[]
25.32 ms
(13.21%)
1
SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8173 LIMIT 1;
Parameters:
[]
18.90 ms
(9.86%)
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
Parameters:
[]
6.56 ms
(3.42%)
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 (8173) and analytic = 9
	       order by ark.order
Parameters:
[]
5.44 ms
(2.84%)
10
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[
  "Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 31 (14%) habitantes: 62 (12%) precio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.24 (nivel: bajo)\nEmisiones de gases de efecto invernadero (KgCO2/m²año): 41.45 (nivel: alto)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.26 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6279.94 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\nacceso a puntos de recarga:  (nivel: )\n"
  8173
]
4.63 ms
(2.41%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
4.49 ms
(2.34%)
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 (8173) and analytic = 5
	       order by ark.order
Parameters:
[]
4.48 ms
(2.34%)
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 (8173) and analytic = 2
	       order by ark.order
Parameters:
[]
4.01 ms
(2.09%)
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 (8173) and analytic = 3
	       order by ark.order
Parameters:
[]
3.68 ms
(1.92%)
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 (8173) and analytic = 4
	       order by ark.order
Parameters:
[]
3.34 ms
(1.74%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
3.31 ms
(1.73%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
3.25 ms
(1.70%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
3.17 ms
(1.65%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
3.06 ms
(1.59%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 9
Parameters:
[]
2.77 ms
(1.45%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
2.49 ms
(1.30%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
2.45 ms
(1.28%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
2.43 ms
(1.27%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
2.40 ms
(1.25%)
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
Parameters:
[]
2.26 ms
(1.18%)
3
SELECT x.* FROM public.analytic x WHERE x.status = 1
Parameters:
[]
2.18 ms
(1.14%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
2.12 ms
(1.11%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
2.11 ms
(1.10%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
2.10 ms
(1.10%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
2.04 ms
(1.07%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
2.04 ms
(1.06%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
1.98 ms
(1.03%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
1.98 ms
(1.03%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
1.97 ms
(1.03%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
1.95 ms
(1.02%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
1.92 ms
(1.00%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
1.92 ms
(1.00%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
1.90 ms
(0.99%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
1.90 ms
(0.99%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
1.89 ms
(0.99%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
1.88 ms
(0.98%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
1.87 ms
(0.97%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 8
Parameters:
[]
1.85 ms
(0.97%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
1.84 ms
(0.96%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
1.81 ms
(0.94%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
1.81 ms
(0.94%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
1.79 ms
(0.94%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 3
Parameters:
[]
1.74 ms
(0.91%)
2
select *
                  from stat_analytic_year
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
1.73 ms
(0.90%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 1
Parameters:
[]
1.70 ms
(0.89%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 4
Parameters:
[]
1.65 ms
(0.86%)
2
select *
                  from stat_analytic_buildinguse
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
1.62 ms
(0.85%)
2
select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (8173) and analytic = 6
Parameters:
[]
1.59 ms
(0.83%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 5
Parameters:
[]
1.56 ms
(0.81%)
2
select *
                  from stat_analytic_data
                  where adminunit in (8173) and analytic = 2
Parameters:
[]
1.54 ms
(0.80%)
2
select *
                  from stat_analytic_ocupacion
                  where adminunit in (8173) and analytic = 6
Parameters:
[]

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.