Symfony Profiler

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 (17016)
  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_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 (17016) and mgm.use <> '-' group by mgm.climate_zone;

SELECT
  adminunitname,
  geom,
  Box2D(
    ST_envelope(geom)
  ) AS envelope
FROM
  public.map_geo_municipio
WHERE
  adminunit = 17016
LIMIT
  1;

SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 17016 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

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
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: 2174 (59%) habitantes: 8975 (46%) consumo final de energía (kWh/m²año): 324.88 (nivel: alto)\\nconsumo de energía de calefacción (kWh/m²año): 264.57 (nivel: alto)\\nprecio de la vivienda (€/m2): 4.87 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.23 (nivel: bajo)\\nEmisiones de gases de efecto invernadero (KgCO2/m²año): 42.28 (nivel: alto)\\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nviviendas energéticamente eficientes y recuperadoras de energía: 0.11 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 2.76 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 5704.71 (nivel: bajo)\\nacceso al carril bici: 0.95 (nivel: alto)\\nacceso a puntos de recarga: 29759.07 (nivel: bajo)\\n' AND t0.adminunit = 17016 LIMIT 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 (17016)
  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 (17016) 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 (17016)
  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 (17016) 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 (17016)
  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 (17016) and analytic = 6
	       order by ark.order;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 9

select *
                  from stat_analytic_data
                  where adminunit in (17016) 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 (17016)
  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 (17016) 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 (17016)
  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 (17016) 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 (17016)
  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 (17016) 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 (17016)
  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 (17016) and analytic = 2
	       order by ark.order;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 9

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 9;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 9

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 9;

SELECT
  x.*
FROM
  public.analytic x
WHERE
  x.status = 1

SELECT x.* FROM public.analytic x WHERE x.status = 1;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 9

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 9;

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;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 9

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 9;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 8

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 8;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 6

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 6;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 6

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 6;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 8

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 8;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 2

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 2;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 1

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 1;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 4

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 4;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 2

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 2;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 8

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 8;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 6

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 6;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 1

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 1;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 4

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 4;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 5

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 5;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 2

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 2;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 3

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 3;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 4

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 4;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 2

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 2;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 6

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 6;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 5

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 5;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 1

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 1;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 3

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 3;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 3

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 3;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 1

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 1;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 5

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 5;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 3

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 3;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 6

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 6;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 8

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 8;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 8

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 8;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 1

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 1;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 3

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 3;

select
  *
from
  stat_analytic_year
where
  adminunit in (17016)
  and analytic = 5

select *
                  from stat_analytic_year
                  where adminunit in (17016) and analytic = 5;

select
  *
from
  stat_analytic_buildinguse
where
  adminunit in (17016)
  and analytic = 4

select *
                  from stat_analytic_buildinguse
                  where adminunit in (17016) and analytic = 4;

select
  *
from
  stat_analytic_ocupacion
where
  adminunit in (17016)
  and analytic = 2

select *
                  from stat_analytic_ocupacion
                  where adminunit in (17016) and analytic = 2;

select
  *
from
  stat_analytic_grossfloorarea
where
  adminunit in (17016)
  and analytic = 5

select *
                  from stat_analytic_grossfloorarea
                  where adminunit in (17016) and analytic = 5;

select
  *
from
  stat_analytic_data
where
  adminunit in (17016)
  and analytic = 4

select *
                  from stat_analytic_data
                  where adminunit in (17016) and analytic = 4;