https://enviskody.enviroportal.sk/oznamenie/

Query Metrics

60 Database Queries
12 Different statements
60.53 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.33 ms
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_SORT = 'XSLOVAK' NLS_LENGTH_SEMANTICS = 'CHAR'
Parameters:
[]
2 1.24 ms
SELECT es_last_activity_id_seq.nextval FROM DUAL
Parameters:
[]
3 0.10 ms
"START TRANSACTION"
Parameters:
[]
4 1.81 ms
INSERT INTO es_last_activity (id, user_id, la_time, url, ip_addr, device, edit) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  558862
  null
  "2026-02-04 01:55:04"
  "/oznamenie/"
  "216.73.216.219"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  null
]
5 1.78 ms
"COMMIT"
Parameters:
[]
6 4.99 ms
SELECT e0_.id AS ID_0, e0_.nazov AS NAZOV_1, e0_.n_type AS N_TYPE_2, e0_.user_id AS USER_ID_3, e0_.cis_spis AS CIS_SPIS_4, e0_.vysledok AS VYSLEDOK_5, e0_.stav AS STAV_6, e0_.n_public AS N_PUBLIC_7, e0_.n_created AS N_CREATED_8, e0_.n_edited AS N_EDITED_9 FROM es_notice e0_ LEFT JOIN es_notice_oznamenie e1_ ON e0_.id = e1_.notice_id LEFT JOIN es_loc e2_ ON e0_.id = e2_.notice_id WHERE e0_.n_public = ? AND e0_.n_type = ? AND e1_.vznik IS NOT NULL AND e2_.zuj IS NOT NULL
Parameters:
[
  1
  "oznamenie"
]
7 1.33 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  36
]
8 1.43 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  36
]
9 0.78 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  37
]
10 0.73 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  37
]
11 0.79 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  38
]
12 0.73 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  38
]
13 0.78 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  40
]
14 0.73 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  40
]
15 0.75 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  61
]
16 0.74 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  61
]
17 0.69 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  81
]
18 0.68 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  81
]
19 0.86 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  141
]
20 0.72 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  141
]
21 0.78 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  161
]
22 0.73 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  161
]
23 0.76 ms
SELECT t0.id AS ID_1, t0.vznik AS VZNIK_2, t0.zistenie AS ZISTENIE_3, t0.druh AS DRUH_4, t0.WGSN AS WGSN_5, t0.WGSE AS WGSE_6, t0.opis AS OPIS_7, t0.priciny AS PRICINY_8, t0.priciny_opis AS PRICINY_OPIS_9, t0.nasledky AS NASLEDKY_10, t0.nasledky_opis AS NASLEDKY_OPIS_11, t0.nasledky_plocha AS NASLEDKY_PLOCHA_12, t0.urad AS URAD_13, t0.urad_adresa AS URAD_ADRESA_14, t0.urad_pracovisko AS URAD_PRACOVISKO_15, t0.datum_podania AS DATUM_PODANIA_16, t0.od_nazov AS OD_NAZOV_17, t0.od_kat AS OD_KAT_18, t0.od_adresa AS OD_ADRESA_19, t0.od_meno AS OD_MENO_20, t0.od_funkcia AS OD_FUNKCIA_21, t0.od_telefon AS OD_TELEFON_22, t0.od_fax AS OD_FAX_23, t0.od_email AS OD_EMAIL_24, t0.od_vyp_meno AS OD_VYP_MENO_25, t0.od_vyp_funkcia AS OD_VYP_FUNKCIA_26, t0.created AS CREATED_27, t0.edited AS EDITED_28, t0.notice_id AS NOTICE_ID_29 FROM es_notice_oznamenie t0 WHERE t0.notice_id = ?
Parameters:
[
  182
]
24 0.76 ms
SELECT t0.id AS ID_1, t0.opis AS OPIS_2, t0.vznik AS VZNIK_3, t0.WGSN AS WGSN_4, t0.WGSE AS WGSE_5, t0.poskodene_zdroje AS POSKODENE_ZDROJE_6, t0.od_meno AS OD_MENO_7, t0.od_adresa AS OD_ADRESA_8, t0.od_email AS OD_EMAIL_9, t0.od_telefon AS OD_TELEFON_10, t0.urad AS URAD_11, t0.urad_adresa AS URAD_ADRESA_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15 FROM es_notice_podnet t0 WHERE t0.notice_id = ?
Parameters:
[
  182
]
25 1.27 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  36
]
26 1.19 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "202"
]
27 2.08 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "503878"
]
28 1.37 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  36
]
29 0.74 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  37
]
30 0.68 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "202"
]
31 0.92 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "503789"
]
32 0.74 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  37
]
33 0.61 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  38
]
34 0.67 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "402"
]
35 1.04 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "502987"
]
36 0.72 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  38
]
37 0.73 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  40
]
38 0.78 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "401"
]
39 0.97 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "501310"
]
40 0.77 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  40
]
41 0.76 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  61
]
42 0.79 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "203"
]
43 1.12 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "507032"
]
44 0.84 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  61
]
45 0.79 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  81
]
46 0.75 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "108"
]
47 1.17 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "507938"
]
48 0.79 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  81
]
49 0.73 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  141
]
50 0.73 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "611"
]
51 1.15 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "518204"
]
52 0.79 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  141
]
53 0.75 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  161
]
54 0.77 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "307"
]
55 1.16 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "514209"
]
56 0.86 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  161
]
57 0.66 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.kraj AS KRAJ_3, t0.okres AS OKRES_4, t0.zuj AS ZUJ_5, t0.lokalita AS LOKALITA_6, t0.notice_id AS NOTICE_ID_7, t0.skoda_id AS SKODA_ID_8 FROM es_loc t0 WHERE t0.notice_id = ?
Parameters:
[
  182
]
58 0.64 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "603"
]
59 1.09 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "508829"
]
60 0.85 ms
SELECT t0.id AS ID_1, t0.nazov AS NAZOV_2, t0.evc AS EVC_3, t0.s_public AS S_PUBLIC_4, t0.druh AS DRUH_5, t0.vznik AS VZNIK_6, t0.zistenie AS ZISTENIE_7, t0.WGSN AS WGSN_8, t0.WGSE AS WGSE_9, t0.priciny AS PRICINY_10, t0.priciny_opis AS PRICINY_OPIS_11, t0.nasledky_json AS NASLEDKY_JSON_12, t0.created AS CREATED_13, t0.edited AS EDITED_14 FROM es_skoda t0 INNER JOIN es_skoda_notice ON t0.id = es_skoda_notice.report_id WHERE es_skoda_notice.notice_id = ?
Parameters:
[
  182
]

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\LastActivity No errors.
App\Entity\Notice No errors.
App\Entity\NoticeOznamenie No errors.
App\Entity\Loc No errors.
App\Entity\Skoda No errors.
App\Entity\Doc No errors.
App\Entity\Operator No errors.
App\Entity\NoticePodnet No errors.
App\Entity\Nasledok No errors.
App\Entity\Opatrenie No errors.
App\Entity\SudneKonanie No errors.
App\Entity\SpravneKonanie No errors.