Symfony Profiler

SELECT
  NAZZUJ AS NAME
FROM
  SAZPCIS.ZUJ
WHERE
  ICZUJ = ?

SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = '543292';

SELECT
  IDP,
  NAZOV
FROM
  ESK_REGPREV
ORDER BY
  NAZOV

SELECT IDP, NAZOV FROM ESK_REGPREV  ORDER BY NAZOV;

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 = ?

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 = 121;

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 = ?

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 = 121;

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 = ?

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 = 121;

SELECT
  NAZOKS AS NAME
FROM
  SAZPCIS.OKRES
WHERE
  IDOK = ?

SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = '704';

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'

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';

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 = ?

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 = 121;

SELECT
  IDURAD AS KEY,
  NAZOVPRURAD AS NAME
FROM
  CIS_PRURAD
ORDER BY
  NAZOVPRURAD

SELECT IDURAD AS KEY, NAZOVPRURAD AS NAME FROM CIS_PRURAD ORDER BY NAZOVPRURAD;

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_podnet 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

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_podnet e1_ ON e0_.id = e1_.notice_id LEFT JOIN es_loc e2_ ON e0_.id = e2_.notice_id WHERE e0_.n_public = 1 AND e0_.n_type = 'podnet' AND e1_.vznik IS NOT NULL AND e2_.zuj IS NOT NULL;

INSERT INTO es_last_activity (
  id, user_id, la_time, url, ip_addr,
  device, edit
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO es_last_activity (id, user_id, la_time, url, ip_addr, device, edit) VALUES (554671, NULL, '2026-01-22 12:06:17', '/podnet/new/', '18.97.9.170', 'CCBot/2.0 (https://commoncrawl.org/faq/)', NULL);

"COMMIT"

"COMMIT";

SELECT
  es_last_activity_id_seq.nextval
FROM
  DUAL

SELECT es_last_activity_id_seq.nextval FROM DUAL;

"START TRANSACTION"

"START TRANSACTION";