Query Metrics
9
Database Queries
9
Different statements
6.35 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3.29 ms (51.75%) |
1 |
SELECT t0.id_souteze AS id_souteze_1, t0.rocnik AS rocnik_2, t0.nazev AS nazev_3, t0.misto AS misto_4, t0.okres AS okres_5, t0.datum AS datum_6, t0.datum_do AS datum_do_7, t0.datum_interval_zacatek AS datum_interval_zacatek_8, t0.datum_interval_konec AS datum_interval_konec_9, t0.zacatek AS zacatek_10, t0.datump AS datump_11, t0.datumz AS datumz_12, t0.kontakt AS kontakt_13, t0.kategorie AS kategorie_14, t0.disciplina AS disciplina_15, t0.pozvanka_id_dokumentu AS pozvanka_id_dokumentu_16, t0.poradatel AS poradatel_17, t0.nocni AS nocni_18, t0.pocet_prispevku AS pocet_prispevku_19, t0.pocet_videi AS pocet_videi_20, t0.pocet_fotek AS pocet_fotek_21, t0.terce AS terce_22, t0.poradatel_sdh AS poradatel_sdh_23, t0.url_rezervace AS url_rezervace_24, t0.pocet_vysledku AS pocet_vysledku_25, t0.id_rezervace AS id_rezervace_26, t0.lat AS lat_27, t0.lng AS lng_28, t0.muzi_bezi_na_2b AS muzi_bezi_na_2b_29, t0.id_zivy_prenos AS id_zivy_prenos_30, t0.id_tipovacky AS id_tipovacky_31, t0.datum_aktualizace_vysledku AS datum_aktualizace_vysledku_32, t0.misto_f AS misto_f_33, t0.pocet_rezervaci AS pocet_rezervaci_34, t0.slug AS slug_35, t0.user_id AS user_id_36, t0.slug_old AS slug_old_37, t0.hity AS hity_38 FROM souteze t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"test123-2024"
]
|
||||||||||||||||||||||||||
0.54 ms (8.49%) |
1 |
SELECT d0_.id AS id_0, d0_.datump AS datump_1, d0_.user_id AS user_id_2, d0_.id_souteze AS id_souteze_3, d0_.nazev_souboru AS nazev_souboru_4, d0_.velikost_souboru AS velikost_souboru_5, d0_.typ AS typ_6, d0_.id_tymu AS id_tymu_7, d0_.popis AS popis_8, d0_.id_ligy AS id_ligy_9 FROM dokumenty d0_ WHERE d0_.id_souteze = ? AND d0_.typ = ?
Parameters:
[ 4612 "V" ]
|
||||||||||||||||||||||||||
0.50 ms (7.90%) |
1 |
SELECT v0_.id AS id_0, v0_.id_souteze AS id_souteze_1, v0_.tym AS tym_2, v0_.cas_levy AS cas_levy_3, v0_.cas_pravy AS cas_pravy_4, v0_.cas AS cas_5, v0_.mc_kos AS mc_kos_6, v0_.mc_voda AS mc_voda_7, v0_.mc_rozd AS mc_rozd_8, v0_.mc_vystrik AS mc_vystrik_9, v0_.start_cislo AS start_cislo_10, v0_.um AS um_11, v0_.body AS body_12, v0_.kategorie AS kategorie_13, v0_.user_id AS user_id_14, v0_.duvod_nedokonceni AS duvod_nedokonceni_15, v0_.filtr2b AS filtr2b_16, v0_.id_tymu AS id_tymu_17, v0_.datump AS datump_18 FROM vysledky v0_ WHERE v0_.id_souteze = ? ORDER BY v0_.kategorie ASC, v0_.um ASC
Parameters:
[
4612
]
|
||||||||||||||||||||||||||
0.39 ms (6.20%) |
1 |
SELECT t0.id_ligy AS id_ligy_1, t0.zkratka AS zkratka_2, t0.nazev AS nazev_3, t0.user_id AS user_id_4, t0.url_stranek_ligy AS url_stranek_ligy_5, t0.url_pravidla AS url_pravidla_6, t0.url_facebook AS url_facebook_7, t0.url_youtube AS url_youtube_8, t0.datump AS datump_9, t0.datumz AS datumz_10, t0.kategorie AS kategorie_11, t0.disciplina AS disciplina_12, t0.top AS top_13, t0.pravidla_hadice AS pravidla_hadice_14, t0.razeni AS razeni_15, t0.open AS open_16, t0.deti AS deti_17, t0.avatar_url AS avatar_url_18, t0.url_instagram AS url_instagram_19, t0.slug AS slug_20, t0.popis AS popis_21 FROM ligy t0 WHERE t0.id_ligy IN (NULL)
Parameters:
[]
|
||||||||||||||||||||||||||
0.36 ms (5.65%) |
1 |
SELECT t0.id AS id_1, t0.id_soutez AS id_soutez_2, t0.id_ligy AS id_ligy_3, t0.user_id AS user_id_4, t0.razeni AS razeni_5 FROM souteze_do_ligy t0 WHERE t0.id_soutez = ?
Parameters:
[
4612
]
|
||||||||||||||||||||||||||
0.35 ms (5.51%) |
1 |
SELECT t0.id AS id_1, t0.kraj_id AS kraj_id_2, t0.okres_id AS okres_id_3, t0.alias AS alias_4, t0.okres AS okres_5 FROM okresy t0 WHERE t0.okres = ? LIMIT 1
Parameters:
[
"CB"
]
|
||||||||||||||||||||||||||
0.34 ms (5.35%) |
1 |
SELECT t0.id AS id_1, t0.id_souteze AS id_souteze_2, t0.id_tymu AS id_tymu_3, t0.image_url AS image_url_4, t0.image_url_sirka AS image_url_sirka_5, t0.image_url_vyska AS image_url_vyska_6, t0.datump AS datump_7, t0.user_id AS user_id_8, t0.image_url_old AS image_url_old_9, t0.image_url_default AS image_url_default_10, t0.image_url_default_sirka AS image_url_default_sirka_11, t0.image_url_default_vyska AS image_url_default_vyska_12, t0.image_url_default_851 AS image_url_default_851_13, t0.datumz AS datumz_14 FROM avatar t0 WHERE t0.id_souteze = ? LIMIT 1
Parameters:
[
4612
]
|
||||||||||||||||||||||||||
0.31 ms (4.82%) |
1 |
SELECT t0.id_ligy AS id_ligy_1, t0.zkratka AS zkratka_2, t0.nazev AS nazev_3, t0.user_id AS user_id_4, t0.url_stranek_ligy AS url_stranek_ligy_5, t0.url_pravidla AS url_pravidla_6, t0.url_facebook AS url_facebook_7, t0.url_youtube AS url_youtube_8, t0.datump AS datump_9, t0.datumz AS datumz_10, t0.kategorie AS kategorie_11, t0.disciplina AS disciplina_12, t0.top AS top_13, t0.pravidla_hadice AS pravidla_hadice_14, t0.razeni AS razeni_15, t0.open AS open_16, t0.deti AS deti_17, t0.avatar_url AS avatar_url_18, t0.url_instagram AS url_instagram_19, t0.slug AS slug_20, t0.popis AS popis_21 FROM ligy t0 WHERE t0.id_ligy = ? LIMIT 1
Parameters:
[
0
]
|
||||||||||||||||||||||||||
0.27 ms (4.33%) |
1 |
SELECT t0.onlajn_id AS onlajn_id_1, t0.id_souteze AS id_souteze_2, t0.popis AS popis_3, t0.nazev AS nazev_4, t0.kategorie AS kategorie_5, t0.youtube_embed_url AS youtube_embed_url_6, t0.user_id AS user_id_7, t0.ukonceno AS ukonceno_8, t0.datump AS datump_9 FROM onlajny t0 WHERE t0.id_souteze = ? LIMIT 1
Parameters:
[
4612
]
|
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\Soutez | No errors. |
App\Entity\SoutezeDoLigy | No errors. |
App\Entity\Liga | No errors. |
App\Entity\Onlajny | No errors. |
App\Entity\Dokument | No errors. |
App\Entity\Vysledek | No errors. |
App\Entity\Okres | No errors. |
App\Entity\Avatar | No errors. |