Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.semestr_cz AS semestr_cz_2,
  t0.semestr_en AS semestr_en_3,
  t0.mezidobi AS mezidobi_4,
  t0.neuplny_rozvrh AS neuplny_rozvrh_5
FROM
  legacy_rozvrh_nastaveni t0
LIMIT
  1

SELECT t0.id AS id_1, t0.semestr_cz AS semestr_cz_2, t0.semestr_en AS semestr_en_3, t0.mezidobi AS mezidobi_4, t0.neuplny_rozvrh AS neuplny_rozvrh_5 FROM legacy_rozvrh_nastaveni t0 LIMIT 1;

SELECT
  DISTINCT s.sekce
FROM
  legacy_rozvrh_skupina s
  LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
WHERE
  s.typ = ?
  AND s.aktivni = 1
ORDER BY
  k.kodFJFI ASC,
  s.sekce ASC

SELECT DISTINCT s.sekce
             FROM legacy_rozvrh_skupina s
             LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
             WHERE s.typ = 'ucitel' AND s.aktivni = 1
             ORDER BY k.kodFJFI ASC, s.sekce ASC;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.kod AS kod_3,
  t0.nazev_cz AS nazev_cz_4,
  t0.nazev_en AS nazev_en_5,
  t0.sekce AS sekce_6,
  t0.png_soubor AS png_soubor_7,
  t0.pdf_soubor AS pdf_soubor_8,
  t0.poradi AS poradi_9,
  t0.aktivni AS aktivni_10,
  t0.katedra_id AS katedra_id_11,
  t0.mistnost_id AS mistnost_id_12
FROM
  legacy_rozvrh_skupina t0
WHERE
  t0.typ = ?
  AND t0.sekce = ?
  AND t0.aktivni = ?
ORDER BY
  t0.poradi ASC,
  t0.nazev_cz ASC

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.kod AS kod_3, t0.nazev_cz AS nazev_cz_4, t0.nazev_en AS nazev_en_5, t0.sekce AS sekce_6, t0.png_soubor AS png_soubor_7, t0.pdf_soubor AS pdf_soubor_8, t0.poradi AS poradi_9, t0.aktivni AS aktivni_10, t0.katedra_id AS katedra_id_11, t0.mistnost_id AS mistnost_id_12 FROM legacy_rozvrh_skupina t0 WHERE t0.typ = 'ucitel' AND t0.sekce = 'KF' AND t0.aktivni = 1 ORDER BY t0.poradi ASC, t0.nazev_cz ASC;

SELECT
  v0_.id AS id_0,
  v0_.poradi AS poradi_1,
  v0_.nazev_cz AS nazev_cz_2,
  v0_.nazev_en AS nazev_en_3,
  v0_.dynamicky_typ AS dynamicky_typ_4,
  v1_.id AS id_5,
  v1_.poradi AS poradi_6,
  v1_.nazev_cz AS nazev_cz_7,
  v1_.nazev_en AS nazev_en_8,
  v1_.dynamicky_typ AS dynamicky_typ_9,
  l2_.id AS id_10,
  l2_.slug AS slug_11,
  l2_.obsah_cz AS obsah_cz_12,
  l2_.obsah_en AS obsah_en_13,
  l2_.nadpis_cz AS nadpis_cz_14,
  l2_.nadpis_en AS nadpis_en_15,
  l2_.typ AS typ_16,
  l2_.viditelna AS viditelna_17,
  l3_.id AS id_18,
  l3_.slug AS slug_19,
  l3_.obsah_cz AS obsah_cz_20,
  l3_.obsah_en AS obsah_en_21,
  l3_.nadpis_cz AS nadpis_cz_22,
  l3_.nadpis_en AS nadpis_en_23,
  l3_.typ AS typ_24,
  l3_.viditelna AS viditelna_25,
  v0_.parent_id AS parent_id_26,
  v0_.stranka_id AS stranka_id_27,
  v1_.parent_id AS parent_id_28,
  v1_.stranka_id AS stranka_id_29
FROM
  verejny_menu_polozka v0_
  LEFT JOIN verejny_menu_polozka v1_ ON v0_.id = v1_.parent_id
  LEFT JOIN legacy_verejny_text l2_ ON v1_.stranka_id = l2_.id
  LEFT JOIN legacy_verejny_text l3_ ON v0_.stranka_id = l3_.id
WHERE
  v0_.parent_id IS NULL
ORDER BY
  v0_.poradi ASC,
  v1_.poradi ASC

SELECT v0_.id AS id_0, v0_.poradi AS poradi_1, v0_.nazev_cz AS nazev_cz_2, v0_.nazev_en AS nazev_en_3, v0_.dynamicky_typ AS dynamicky_typ_4, v1_.id AS id_5, v1_.poradi AS poradi_6, v1_.nazev_cz AS nazev_cz_7, v1_.nazev_en AS nazev_en_8, v1_.dynamicky_typ AS dynamicky_typ_9, l2_.id AS id_10, l2_.slug AS slug_11, l2_.obsah_cz AS obsah_cz_12, l2_.obsah_en AS obsah_en_13, l2_.nadpis_cz AS nadpis_cz_14, l2_.nadpis_en AS nadpis_en_15, l2_.typ AS typ_16, l2_.viditelna AS viditelna_17, l3_.id AS id_18, l3_.slug AS slug_19, l3_.obsah_cz AS obsah_cz_20, l3_.obsah_en AS obsah_en_21, l3_.nadpis_cz AS nadpis_cz_22, l3_.nadpis_en AS nadpis_en_23, l3_.typ AS typ_24, l3_.viditelna AS viditelna_25, v0_.parent_id AS parent_id_26, v0_.stranka_id AS stranka_id_27, v1_.parent_id AS parent_id_28, v1_.stranka_id AS stranka_id_29 FROM verejny_menu_polozka v0_ LEFT JOIN verejny_menu_polozka v1_ ON v0_.id = v1_.parent_id LEFT JOIN legacy_verejny_text l2_ ON v1_.stranka_id = l2_.id LEFT JOIN legacy_verejny_text l3_ ON v0_.stranka_id = l3_.id WHERE v0_.parent_id IS NULL ORDER BY v0_.poradi ASC, v1_.poradi ASC;

SELECT
  DISTINCT s.sekce
FROM
  legacy_rozvrh_skupina s
  LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
WHERE
  s.typ = ?
  AND s.aktivni = 1
ORDER BY
  k.kodFJFI ASC,
  s.sekce ASC

SELECT DISTINCT s.sekce
             FROM legacy_rozvrh_skupina s
             LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
             WHERE s.typ = 'ucitel' AND s.aktivni = 1
             ORDER BY k.kodFJFI ASC, s.sekce ASC;

SELECT
  DISTINCT s.sekce
FROM
  legacy_rozvrh_skupina s
  LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
WHERE
  s.typ = ?
  AND s.aktivni = 1
ORDER BY
  k.kodFJFI ASC,
  s.sekce ASC

SELECT DISTINCT s.sekce
             FROM legacy_rozvrh_skupina s
             LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci
             WHERE s.typ = 'ucitel' AND s.aktivni = 1
             ORDER BY k.kodFJFI ASC, s.sekce ASC;