GET https://www.hasicskasoutez.cz/trocnov-2023/

Query Metrics

15 Database Queries
15 Different statements
8.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.90 ms
(58.57%)
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:
[
  "trocnov-2023"
]
0.55 ms
(6.56%)
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:
[
  4590
  "P"
]
0.40 ms
(4.80%)
1
SELECT t0.id AS id_1, t0.id_rezervace AS id_rezervace_2, t0.id_kategorie AS id_kategorie_3, t0.user_id AS user_id_4, t0.datump AS datump_5, t0.tym AS tym_6, t0.start_cislo AS start_cislo_7, t0.heslo AS heslo_8 FROM rezervace_rezervace t0 WHERE t0.id_rezervace = ?
Parameters:
[
  639
]
0.30 ms
(3.56%)
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:
[
  4590
]
0.27 ms
(3.26%)
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:
[
  4590
]
0.27 ms
(3.26%)
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.27 ms
(3.17%)
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.25 ms
(2.96%)
1
UPDATE souteze SET hity = ? WHERE id_souteze = ?
Parameters:
[
  2
  4590
]
0.25 ms
(2.95%)
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.21 ms
(2.54%)
1
SELECT t0.id_rezervace AS id_rezervace_1, t0.id_souteze AS id_souteze_2, t0.user_id AS user_id_3, t0.datump AS datump_4, t0.zacatek AS zacatek_5, t0.konec AS konec_6, t0.spusteno AS spusteno_7, t0.poznamka AS poznamka_8, t0.zakazat_anonymni_rezervace AS zakazat_anonymni_rezervace_9 FROM rezervace t0 WHERE t0.id_rezervace = ?
Parameters:
[
  639
]
0.20 ms
(2.35%)
1
SELECT t0.disciplina AS disciplina_1, t0.popis AS popis_2, t0.url_souteze AS url_souteze_3, t0.podtitulek AS podtitulek_4 FROM ciselnik_discipliny t0
Parameters:
[]
0.15 ms
(1.85%)
1
SELECT t0.id_terce AS id_terce_1, t0.nazev AS nazev_2, t0.razeni AS razeni_3 FROM ciselnik_terce t0
Parameters:
[]
0.14 ms
(1.69%)
1
SELECT t0.kategorie AS kategorie_1, t0.popis AS popis_2 FROM ciselnik_kategorie t0
Parameters:
[]
0.12 ms
(1.41%)
1
"START TRANSACTION"
Parameters:
[]
0.09 ms
(1.07%)
1
"COMMIT"
Parameters:
[]

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