Query Metrics
19
Database Queries
16
Different statements
32.76 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |