GET http://78.56.202.79:443/map

Query Metrics

35 Database Queries
35 Different statements
585.47 ms Query time
0 Invalid entities
4364 Managed entities

Grouped Statements

Show all queries

Time Count Info
97.08 ms
(16.58%)
1
SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC
Parameters:
[]
90.62 ms
(15.48%)
1
SELECT DISTINCT s0_.mokslo_metai AS mokslo_metai_0 FROM statistic_priimtu_studijuoti_skaicius s0_ ORDER BY s0_.mokslo_metai DESC
Parameters:
[]
66.86 ms
(11.42%)
1
SELECT DISTINCT s0_.dek_metai AS dek_metai_0 FROM statistic_amzius_lytis_pilietybe s0_ WHERE s0_.dek_metai IS NOT NULL ORDER BY s0_.dek_metai DESC
Parameters:
[]
57.67 ms
(9.85%)
1
SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC
Parameters:
[]
45.90 ms
(7.84%)
1
SELECT s0_.id AS id_0, s0_.nr AS nr_1, s0_.lytis AS lytis_2, s0_.amzius AS amzius_3, s0_.pilietybe AS pilietybe_4, s0_.dek_ketvirtis AS dek_ketvirtis_5, s0_.dek_metai AS dek_metai_6, s0_.savivaldybe AS savivaldybe_7, l1_.pavadinimas AS pavadinimas_8 FROM statistic_amzius_lytis_pilietybe s0_ LEFT JOIN list_lithuania_savivaldybe l1_ ON (s0_.savivaldybe = l1_.uuid) WHERE s0_.dek_metai = ? AND s0_.dek_ketvirtis = ?
Parameters:
[
  2025
  "K1"
]
43.04 ms
(7.35%)
1
SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.metai IS NOT NULL ORDER BY s0_.metai DESC
Parameters:
[]
42.11 ms
(7.19%)
1
SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_absolventu_skaicius_pagal_sritis s0_ ORDER BY s0_.metai DESC
Parameters:
[]
34.20 ms
(5.84%)
1
SELECT DISTINCT s0_.mokslo_metai AS mokslo_metai_0 FROM statistic_studentu_skaicius_pagal_lyti_amziu s0_ ORDER BY s0_.mokslo_metai DESC
Parameters:
[]
17.15 ms
(2.93%)
1
SELECT DISTINCT s0_.dek_ketvirtis AS dek_ketvirtis_0 FROM statistic_amzius_lytis_pilietybe s0_ WHERE s0_.dek_ketvirtis IS NOT NULL AND s0_.dek_metai = ? ORDER BY s0_.dek_ketvirtis ASC
Parameters:
[
  2025
]
10.48 ms
(1.79%)
1
SELECT s0_.savivaldybe AS savivaldybe_0, COUNT(s0_.id) AS sclr_1 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.savivaldybe IS NOT NULL AND s0_.metai = ? GROUP BY s0_.savivaldybe ORDER BY sclr_1 DESC
Parameters:
[
  2025
]
9.92 ms
(1.69%)
1
SELECT s0_.veiklos_tipas AS veiklos_tipas_0, s0_.moketojas AS moketojas_1, COUNT(s0_.id) AS sclr_2 FROM statistic_vykdancius_individualia_veikla s0_ WHERE s0_.metai = ? GROUP BY s0_.veiklos_tipas, s0_.moketojas ORDER BY sclr_2 DESC
Parameters:
[
  2025
]
8.04 ms
(1.37%)
1
SELECT s0_.kodas_gpmi AS kodas_gpmi_0, s0_.kodas AS kodas_1, s0_.aprasas AS aprasas_2, s0_.lytis AS lytis_3, SUM(s0_.suma) AS sclr_4 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai = ? GROUP BY s0_.kodas_gpmi, s0_.kodas, s0_.aprasas, s0_.lytis ORDER BY sclr_4 DESC
Parameters:
[
  2023
]
6.92 ms
(1.18%)
1
SELECT s0_.sav_pavadinimas AS sav_pavadinimas_0, s0_.sav_kodas AS sav_kodas_1, SUM(s0_.suma) AS sclr_2 FROM statistic_gyventoju_pajamos_pagal_savivaldybe s0_ WHERE s0_.metai = ? GROUP BY s0_.sav_pavadinimas, s0_.sav_kodas ORDER BY sclr_2 DESC
Parameters:
[
  2023
]
5.14 ms
(0.88%)
1
SELECT s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0, s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1, SUM(s0_.priimtuju_skaicius) AS sclr_2 FROM statistic_priimtu_studijuoti_skaicius s0_ WHERE s0_.mokslo_metai = ? GROUP BY s0_.padalinio_savivaldybe, s0_.padalinio_savivaldybes_id ORDER BY sclr_2 DESC
Parameters:
[
  "ST Mokslo metai"
]
4.57 ms
(0.78%)
1
SELECT s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0, s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1, SUM(s0_.studentu_skaicius) AS sclr_2 FROM statistic_studentu_skaicius_pagal_lyti_amziu s0_ WHERE s0_.mokslo_metai = ? GROUP BY s0_.padalinio_savivaldybe, s0_.padalinio_savivaldybes_id ORDER BY sclr_2 DESC
Parameters:
[
  "2026-2027"
]
4.13 ms
(0.71%)
1
SELECT t0.id AS id_1, t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2, t0.pavadinimas AS pavadinimas_3, t0.buveines_adresas AS buveines_adresas_4, t0.iregistravimo_data AS iregistravimo_data_5, t0.isregistravimo_data AS isregistravimo_data_6, t0.teisine_forma AS teisine_forma_7, t0.teinis_statusas AS teinis_statusas_8, t0.teinis_statusas_nuo AS teinis_statusas_nuo_9, t0.valstybes_pripazinimas AS valstybes_pripazinimas_10, t0.religine_kryptis AS religine_kryptis_11 FROM statistic_religiniu_bendruomeniu_sarasas t0
Parameters:
[]
4.05 ms
(0.69%)
1
SELECT s0_.studiju_kryptis AS studiju_kryptis_0, s0_.studiju_pakopa AS studiju_pakopa_1, s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2, SUM(s0_.priimtuju_skaicius) AS sclr_3 FROM statistic_priimtu_studijuoti_skaicius s0_ WHERE s0_.mokslo_metai = ? GROUP BY s0_.studiju_kryptis, s0_.studiju_pakopa, s0_.dirbo_mokslo_metu_eigoje ORDER BY sclr_3 DESC
Parameters:
[
  "ST Mokslo metai"
]
3.98 ms
(0.68%)
1
SELECT s0_.savivaldybe AS savivaldybe_0, COUNT(s0_.id) AS sclr_1 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.savivaldybe IS NOT NULL AND s0_.metai = ? GROUP BY s0_.savivaldybe ORDER BY sclr_1 DESC
Parameters:
[
  2026
]
3.73 ms
(0.64%)
1
SELECT s0_.lytis AS lytis_0, s0_.amziaus_grupe AS amziaus_grupe_1, s0_.studiju_pakopa AS studiju_pakopa_2, SUM(s0_.studentu_skaicius) AS sclr_3 FROM statistic_studentu_skaicius_pagal_lyti_amziu s0_ WHERE s0_.mokslo_metai = ? GROUP BY s0_.lytis, s0_.amziaus_grupe, s0_.studiju_pakopa ORDER BY s0_.amziaus_grupe ASC
Parameters:
[
  "2026-2027"
]
3.41 ms
(0.58%)
1
SELECT s0_.padalinio_savivaldybe AS padalinio_savivaldybe_0, s0_.padalinio_savivaldybes_id AS padalinio_savivaldybes_id_1, SUM(s0_.absolventu_skaicius) AS sclr_2 FROM statistic_absolventu_skaicius_pagal_sritis s0_ WHERE s0_.metai = ? GROUP BY s0_.padalinio_savivaldybe, s0_.padalinio_savivaldybes_id ORDER BY sclr_2 DESC
Parameters:
[
  2026
]
3.36 ms
(0.57%)
1
SELECT t0.id AS id_1, t0.juridinio_asmens_kodas AS juridinio_asmens_kodas_2, t0.pavadinimas AS pavadinimas_3, t0.buveines_adresas AS buveines_adresas_4, t0.iregistravimo_data AS iregistravimo_data_5, t0.isregistravimo_data AS isregistravimo_data_6, t0.teisine_forma AS teisine_forma_7, t0.teinis_statusas AS teinis_statusas_8, t0.teinis_statusas_nuo AS teinis_statusas_nuo_9, t0.valstybes_pripazinimas AS valstybes_pripazinimas_10, t0.religine_kryptis AS religine_kryptis_11 FROM statistic_religiniu_bendruomeniu_sarasas t0 ORDER BY t0.pavadinimas ASC
Parameters:
[]
3.12 ms
(0.53%)
1
SELECT s0_.rusies_kodas AS rusies_kodas_0, s0_.rusis_pavadinimas AS rusis_pavadinimas_1, s0_.veiklos_tipas AS veiklos_tipas_2, COUNT(s0_.id) AS sclr_3 FROM statistic_gyventoju_isduotu_verslo_liudijimu s0_ WHERE s0_.metai = ? GROUP BY s0_.rusies_kodas, s0_.rusis_pavadinimas, s0_.veiklos_tipas ORDER BY sclr_3 DESC
Parameters:
[
  2026
]
2.93 ms
(0.50%)
1
SELECT s0_.studiju_kryptis AS studiju_kryptis_0, s0_.studiju_pakopa AS studiju_pakopa_1, s0_.dirbo_mokslo_metu_eigoje AS dirbo_mokslo_metu_eigoje_2, SUM(s0_.absolventu_skaicius) AS sclr_3 FROM statistic_absolventu_skaicius_pagal_sritis s0_ WHERE s0_.metai = ? GROUP BY s0_.studiju_kryptis, s0_.studiju_pakopa, s0_.dirbo_mokslo_metu_eigoje ORDER BY sclr_3 DESC
Parameters:
[
  2026
]
2.72 ms
(0.46%)
1
SELECT DISTINCT s0_.metai AS metai_0 FROM statistic_gimimai_mirimai s0_ ORDER BY s0_.metai DESC
Parameters:
[]
2.40 ms
(0.41%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.laikotarpis AS laikotarpis_3, t0.salies_kodas AS salies_kodas_4, t0.sal_pav AS sal_pav_5, t0.uzs_fiz_dalyviai AS uzs_fiz_dalyviai_6, t0.uzs_ja_dalyviai AS uzs_ja_dalyviai_7 FROM statistic_juridiniu_asmenu_apie_uzsienio_fj_asmenis t0 ORDER BY t0.laikotarpis DESC, t0.sal_pav ASC
Parameters:
[]
1.64 ms
(0.28%)
1
SELECT s0_.rinkimu_id AS rinkimu_id_0, s0_.rink_pavadinimas AS rink_pavadinimas_1 FROM statistic_politines_kompanijos_pajamos s0_ WHERE s0_.rinkimu_id IS NOT NULL GROUP BY s0_.rinkimu_id, s0_.rink_pavadinimas ORDER BY s0_.rinkimu_id DESC
Parameters:
[]
1.53 ms
(0.26%)
1
SELECT s0_.rinkimu_id AS rinkimu_id_0, s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_1 FROM statistic_politines_kampanijos_reklama s0_ WHERE s0_.rinkimu_id IS NOT NULL GROUP BY s0_.rinkimu_id, s0_.rinkimu_pavadinimas ORDER BY s0_.rinkimu_id DESC
Parameters:
[]
1.39 ms
(0.24%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.reklamos_id AS reklamos_id_3, s0_.rinkimu_id AS rinkimu_id_4, s0_.rinkimu_pavadinimas AS rinkimu_pavadinimas_5, s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6, s0_.p_kamp_dal_vardas AS p_kamp_dal_vardas_7, s0_.dal_tipo_kodas AS dal_tipo_kodas_8, s0_.dal_tipas AS dal_tipas_9, s0_.virs_ja_kodas AS virs_ja_kodas_10, s0_.virs_pavadinimas AS virs_pavadinimas_11, s0_.virs_tipo_pavadinimas AS virs_tipo_pavadinimas_12, s0_.reklamos_data_nuo AS reklamos_data_nuo_13, s0_.reklamos_data_iki AS reklamos_data_iki_14, s0_.reklamos_forma AS reklamos_forma_15, s0_.reklamos_kaina AS reklamos_kaina_16, s0_.islaidu_paskirtis AS islaidu_paskirtis_17, s0_.org_pavadinimas AS org_pavadinimas_18 FROM statistic_politines_kampanijos_reklama s0_ ORDER BY s0_.p_kamp_dal_pavadinimas ASC
Parameters:
[]
1.30 ms
(0.22%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.pajamu_id AS pajamu_id_3, s0_.rinkimu_id AS rinkimu_id_4, s0_.rink_pavadinimas AS rink_pavadinimas_5, s0_.p_kamp_dal_pavadinimas AS p_kamp_dal_pavadinimas_6, s0_.p_kamp_dal_id AS p_kamp_dal_id_7, s0_.auk_tipas AS auk_tipas_8, s0_.suma AS suma_9, s0_.auk_ja_kodas AS auk_ja_kodas_10, s0_.auk_ja_pavadinimas AS auk_ja_pavadinimas_11, s0_.lytis AS lytis_12, s0_.amziaus_grupe AS amziaus_grupe_13, s0_.lesu_saltinio_kodas AS lesu_saltinio_kodas_14, s0_.lesu_saltinis AS lesu_saltinis_15, s0_.paj_dok_data AS paj_dok_data_16, s0_.lesu_forma AS lesu_forma_17, s0_.dal_tipo_kodas AS dal_tipo_kodas_18, s0_.dal_tipas AS dal_tipas_19, s0_.dal_reg_busena AS dal_reg_busena_20 FROM statistic_politines_kompanijos_pajamos s0_ ORDER BY s0_.p_kamp_dal_pavadinimas ASC
Parameters:
[]
1.25 ms
(0.21%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.istaigos_id AS istaigos_id_3, s0_.pavaldumas_id AS pavaldumas_id_4, s0_.jar_kodas AS jar_kodas_5, s0_.pavadinimas AS pavadinimas_6, s0_.sutrumintas_pavadinimas AS sutrumintas_pavadinimas_7, s0_.istaigru_grupe AS istaigru_grupe_8, s0_.adresas AS adresas_9, s0_.web AS web_10, s0_.el_pastas AS el_pastas_11, s0_.isteigta AS isteigta_12, s0_.atnaujinimas AS atnaujinimas_13 FROM statistic_valstybines_istaigos s0_ ORDER BY s0_.pavadinimas ASC
Parameters:
[]
1.19 ms
(0.20%)
1
SELECT DISTINCT s0_.ataskaitiniai_metai AS ataskaitiniai_metai_0 FROM statistic_politines_kompanijos_nariu_mokesciai s0_ WHERE s0_.ataskaitiniai_metai IS NOT NULL ORDER BY s0_.ataskaitiniai_metai DESC
Parameters:
[]
1.13 ms
(0.19%)
1
SELECT DISTINCT s0_.istaigru_grupe AS istaigru_grupe_0 FROM statistic_valstybines_istaigos s0_ WHERE s0_.istaigru_grupe IS NOT NULL ORDER BY s0_.istaigru_grupe ASC
Parameters:
[]
0.93 ms
(0.16%)
1
SELECT DISTINCT s0_.religine_kryptis AS religine_kryptis_0 FROM statistic_religiniu_bendruomeniu_sarasas s0_ ORDER BY s0_.religine_kryptis ASC
Parameters:
[]
0.84 ms
(0.14%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.metai AS metai_2, s0_.menuo AS menuo_3, s0_.gimusiu_berniuku AS gimusiu_berniuku_4, s0_.gimusiu_mergaiciu AS gimusiu_mergaiciu_5, s0_.gimusiu_is_viso AS gimusiu_is_viso_6, s0_.uzsienyje_gime_vaikai AS uzsienyje_gime_vaikai_7, s0_.ivaikinta AS ivaikinta_8, s0_.mirusiu_moteru AS mirusiu_moteru_9, s0_.mirusiu_vyru AS mirusiu_vyru_10, s0_.mirusiu_is_viso AS mirusiu_is_viso_11, s0_.populiariausi_vardai AS populiariausi_vardai_12, s0_.savivaldybe AS savivaldybe_13 FROM statistic_gimimai_mirimai s0_ WHERE s0_.metai = ? ORDER BY s0_.id ASC
Parameters:
[
  2023
]
0.74 ms
(0.13%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.revision AS revision_2, s0_.nariai_id AS nariai_id_3, s0_.org_tipas AS org_tipas_4, s0_.org_ja_kodas AS org_ja_kodas_5, s0_.org_pavadinimas AS org_pavadinimas_6, s0_.ataskaitiniai_metai AS ataskaitiniai_metai_7, s0_.mok_data AS mok_data_8, s0_.mok_suma AS mok_suma_9, s0_.mok_busena AS mok_busena_10, s0_.mok_budas AS mok_budas_11, s0_.lytis AS lytis_12, s0_.amziaus_grupe AS amziaus_grupe_13 FROM statistic_politines_kompanijos_nariu_mokesciai s0_ ORDER BY s0_.org_pavadinimas ASC
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\StatisticReliginiuBendruomeniuSarasas 1380
App\Entity\StatisticJuridiniuAsmenuApieUzsienioFJAsmenis 1033
App\Entity\StatisticPolitinesKampanijosReklama 500
App\Entity\StatisticPolitinesKompanijosPajamos 500
App\Entity\StatisticPolitinesKompanijosNariuMokesciai 500
App\Entity\StatisticValstybinesIstaigos 438
App\Entity\StatisticGimimaiMirimai 13