Symfony Profiler

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

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 = 'olesnik-2024' LIMIT 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 = ?

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 = 4606;

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 (?)

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 (67);

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

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;

SELECT
  t0.id_terce AS id_terce_1,
  t0.nazev AS nazev_2,
  t0.razeni AS razeni_3
FROM
  ciselnik_terce t0

SELECT t0.id_terce AS id_terce_1, t0.nazev AS nazev_2, t0.razeni AS razeni_3 FROM ciselnik_terce t0;

SELECT
  t0.kategorie AS kategorie_1,
  t0.popis AS popis_2
FROM
  ciselnik_kategorie t0

SELECT t0.kategorie AS kategorie_1, t0.popis AS popis_2 FROM ciselnik_kategorie t0;

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 = ?

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 = 658;

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 = ?

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 = 658;

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 = ?

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 = 4606 AND d0_.typ = 'P';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  souteze
SET
  hity = ?
WHERE
  id_souteze = ?

UPDATE souteze SET hity = 5 WHERE id_souteze = 4606;

"COMMIT"

"COMMIT";

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

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 = 'CB' LIMIT 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

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 = 0 LIMIT 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

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 = 4606 LIMIT 1;

SELECT
  s.id_souteze
FROM
  souteze s,
  souteze_do_ligy sdl
WHERE
  sdl.id_ligy = :id_ligy
  AND sdl.id_soutez = s.id_souteze
  AND EXTRACT(
    YEAR
    FROM
      s.datum
  )= :rocnik
ORDER BY
  s.datum ASC,
  s.nocni ASC

SELECT s.id_souteze FROM souteze s, souteze_do_ligy sdl WHERE sdl.id_ligy=:id_ligy AND sdl.id_soutez=s.id_souteze AND EXTRACT(YEAR FROM s.datum)=:rocnik ORDER BY s.datum ASC,s.nocni ASC;