https://enviskody.enviroportal.sk/register/hrozba/41

Query Metrics

19 Database Queries
16 Different statements
32.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.89 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.25 ms
SELECT es_last_activity_id_seq.nextval FROM DUAL
Parameters:
[]
3 0.11 ms
"START TRANSACTION"
Parameters:
[]
4 1.75 ms
INSERT INTO es_last_activity (id, user_id, la_time, url, ip_addr, device, edit) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  539027
  null
  "2025-12-23 12:11:49"
  "/register/hrozba/41"
  "216.73.216.112"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  null
]
5 1.62 ms
"COMMIT"
Parameters:
[]
6 1.46 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 WHERE t0.id = ?
Parameters:
[
  "41"
]
7 1.30 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.skoda_id = ?
Parameters:
[
  41
]
8 1.14 ms
SELECT NAZKR AS NAME FROM SAZPCIS.KRAJ WHERE IDKR = ?
Parameters:
[
  "1"
]
9 0.96 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "108"
]
10 1.74 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "507938"
]
11 0.52 ms
SELECT NAZKR AS NAME FROM SAZPCIS.KRAJ WHERE IDKR = ?
Parameters:
[
  "1"
]
12 0.48 ms
SELECT NAZOKS AS NAME FROM SAZPCIS.OKRES WHERE IDOK = ?
Parameters:
[
  "102"
]
13 0.75 ms
SELECT NAZZUJ AS NAME FROM SAZPCIS.ZUJ WHERE ICZUJ = ?
Parameters:
[
  "529320"
]
14 1.07 ms
SELECT t0.id AS ID_1, t0.stat AS STAT_2, t0.n_type AS N_TYPE_3, t0.pid AS PID_4, t0.nazov AS NAZOV_5, t0.adresa AS ADRESA_6, t0.zastupca AS ZASTUPCA_7, t0.telefon AS TELEFON_8, t0.fax AS FAX_9, t0.email AS EMAIL_10, t0.sk_nace AS SK_NACE_11, t0.ico AS ICO_12, t0.created AS CREATED_13, t0.edited AS EDITED_14, t0.notice_id AS NOTICE_ID_15, t0.skoda_id AS SKODA_ID_16 FROM es_operator t0 WHERE t0.skoda_id = ?
Parameters:
[
  41
]
15 12.12 ms
SELECT NACE2 AS KEY, NAZOV2 AS NAME FROM EMS_NACE21 ORDER BY NAZOV2
Parameters:
[]
16 0.97 ms
SELECT t0.id AS ID_1, t0.typ_id AS TYP_ID_2, t0.nazov AS NAZOV_3, t0.rozsah AS ROZSAH_4, t0.jednotka AS JEDNOTKA_5, t0.nasledky AS NASLEDKY_6, t0.created AS CREATED_7, t0.edited AS EDITED_8, t0.skoda_id AS SKODA_ID_9 FROM es_nasledok t0 WHERE t0.skoda_id = ?
Parameters:
[
  41
]
17 0.95 ms
SELECT t0.id AS ID_1, t0.druh AS DRUH_2, t0.opatrenie AS OPATRENIE_3, t0.ok_naprava AS OK_NAPRAVA_4, t0.dod_naprava AS DOD_NAPRAVA_5, t0.vysledok_key AS VYSLEDOK_KEY_6, t0.vysledok AS VYSLEDOK_7, t0.datumy AS DATUMY_8, t0.popis AS POPIS_9, t0.naklady AS NAKLADY_10, t0.dov_nez AS DOV_NEZ_11, t0.vyn_fin AS VYN_FIN_12, t0.poznamka AS POZNAMKA_13, t0.created AS CREATED_14, t0.edited AS EDITED_15, t0.skoda_id AS SKODA_ID_16 FROM es_opatrenie t0 WHERE t0.skoda_id = ?
Parameters:
[
  41
]
18 0.91 ms
SELECT t0.id AS ID_1, t0.urad_n AS URAD_N_2, t0.subjekt_d AS SUBJEKT_D_3, t0.cis_spis AS CIS_SPIS_4, t0.suv_spk AS SUV_SPK_5, t0.subjekt_t AS SUBJEKT_T_6, t0.zaciatok AS ZACIATOK_7, t0.koniec AS KONIEC_8, t0.predmet AS PREDMET_9, t0.vysledok AS VYSLEDOK_10, t0.typ AS TYP_11, t0.created AS CREATED_12, t0.edited AS EDITED_13, t0.skoda_id AS SKODA_ID_14 FROM es_spk t0 WHERE t0.skoda_id = ?
Parameters:
[
  41
]
19 0.78 ms
SELECT t0.id AS ID_1, t0.sud AS SUD_2, t0.zaciatok AS ZACIATOK_3, t0.koniec AS KONIEC_4, t0.predmet AS PREDMET_5, t0.vysledok AS VYSLEDOK_6, t0.typ AS TYP_7, t0.created AS CREATED_8, t0.edited AS EDITED_9, t0.skoda_id AS SKODA_ID_10 FROM es_suk t0 WHERE t0.skoda_id = ?
Parameters:
[
  41
]

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