Symfony Profiler

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

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 2972 (35%) habitantes: 25000 (39%) precio de la vivienda (€/m2): 6.50 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.03 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4466.52 (nivel: bajo)\\nacceso a puntos de recarga: 58607.92 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 79 (1%) habitantes: 7259 (11%) viviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 117.92 (nivel: bajo)\\nacceso a puntos de recarga: 47310.24 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 4.29 (nivel: bajo)\\nacceso al carril bici: 0.88 (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.96 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 59147.88 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 839 (10%) habitantes: 6606 (10%) consumo final de energía (kWh/m²año): 129.34 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 89.47 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.08 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.18 (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): 6497.53 (nivel: bajo)\\nacceso a puntos de recarga: 52354.13 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 2783 (33%) habitantes: 7142 (11%) población con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nprecio de la vivienda (€/m2): 6.20 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.96 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4090.44 (nivel: bajo)\\nacceso a puntos de recarga: 58994.20 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 3365 (40%) habitantes: 34766 (54%) superficies de zonas verdes (Ha): 1.76 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\nequipamiento urbano a 15 minutos caminando: 18.61 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 5904.79 (nivel: bajo)\\nprecio de la vivienda (€/m2): 6.42 (nivel: bajo)\\nacceso al carril bici: 1.00 (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.94 (nivel: alto)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 4403 (52%) habitantes: 24455 (38%) precio de la vivienda (€/m2): 6.38 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.36 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4447.58 (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.76 (nivel: alto)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 3546 (42%) habitantes: 51217 (80%) viviendas energéticamente eficientes: 0.03 (nivel: bajo)\\nacceso a puntos de recarga: 59898.59 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 3.78 (nivel: bajo)\\nacceso al carril bici: 0.84 (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.91 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 8024.45 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 601 (7%) habitantes: 2485 (4%) viviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4224.21 (nivel: bajo)\\nprecio de la vivienda (€/m2): 6.29 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.47 (nivel: bajo)\\nprecio medio alquiler comparado ingresos familiares (%): 0.28 (nivel: bajo)\\nacceso al carril bici: 0.81 (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.88 (nivel: alto)\\nacceso a puntos de recarga: 58546.54 (nivel: bajo)\\n' AND t0.adminunit = 8308 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 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 x.* FROM public.analytic x WHERE x.status = 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 2972 (35%) habitantes: 25000 (39%) precio de la vivienda (€/m2): 6.50 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.01 (nivel: bajo)\\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.03 (nivel: bajo)\\npotencial de generación solar fotovoltaica (kWh/m²año): 4466.52 (nivel: bajo)\\nacceso a puntos de recarga: 58607.92 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 79 (1%) habitantes: 7259 (11%) viviendas energéticamente eficientes: 0.00 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 117.92 (nivel: bajo)\\nacceso a puntos de recarga: 47310.24 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 4.29 (nivel: bajo)\\nacceso al carril bici: 0.88 (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.96 (nivel: alto)\\npotencial de generación solar fotovoltaica (kWh/m²año): 59147.88 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

select *
                  from stat_analytic_ocupacion
                  where adminunit in (8308) 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 (8308)
  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 (8308) 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 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: 839 (10%) habitantes: 6606 (10%) consumo final de energía (kWh/m²año): 129.34 (nivel: bajo)\\nconsumo de energía de calefacción (kWh/m²año): 89.47 (nivel: bajo)\\nviviendas energéticamente eficientes: 0.08 (nivel: bajo)\\nsuperficies de zonas verdes (Ha): 5.18 (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): 6497.53 (nivel: bajo)\\nacceso a puntos de recarga: 52354.13 (nivel: bajo)\\n' AND t0.adminunit = 8308 LIMIT 1;

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

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

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

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

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

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

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

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

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

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