Query Metrics
6
Database Queries
6
Different statements
4.55 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3.08 ms |
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:
[
"knezice-2023"
]
|
||||||||||||||||||||||
2 | 0.43 ms |
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:
[
4530
]
|
||||||||||||||||||||||
3 | 0.29 ms |
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 (?)
Parameters:
[
20
]
|
||||||||||||||||||||||
4 | 0.23 ms |
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:
[
"TR"
]
|
||||||||||||||||||||||
5 | 0.26 ms |
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
]
|
||||||||||||||||||||||
6 | 0.28 ms |
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:
[
4530
]
|
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\Okres | No errors. |
App\Entity\Avatar | No errors. |