Query Metrics
60
Database Queries
12
Different statements
60.53 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |