Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.id_kraje AS id_kraje_3,
  t0.id_okresu AS id_okresu_4
FROM
  ad_co_inzerat_mesto t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.id_kraje AS id_kraje_3, t0.id_okresu AS id_okresu_4 FROM ad_co_inzerat_mesto t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_min_vzdelani t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_min_vzdelani t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_mzda_mena t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_mena t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_mzda_typ t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_typ t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_obor t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_obor t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_pocet_mist t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_pocet_mist t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.id_oboru AS id_oboru_3,
  t0.is_brigada AS is_brigada_4,
  t0.is_pozice AS is_pozice_5,
  t0.id_oboru AS id_oboru_6
FROM
  ad_co_inzerat_pozice t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.id_oboru AS id_oboru_3, t0.is_brigada AS is_brigada_4, t0.is_pozice AS is_pozice_5, t0.id_oboru AS id_oboru_6 FROM ad_co_inzerat_pozice t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_sekce t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_sekce t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_stat t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_stat t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_co_inzerat_termin t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_termin t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.id_kraje AS id_kraje_3,
  t0.id_okresu AS id_okresu_4
FROM
  ad_custom_co_inzerat_mesto t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.id_kraje AS id_kraje_3, t0.id_okresu AS id_okresu_4 FROM ad_custom_co_inzerat_mesto t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_sekce t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_sekce t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.id_oboru AS id_oboru_3,
  t0.is_brigada AS is_brigada_4,
  t0.is_pozice AS is_pozice_5,
  t0.id_oboru AS id_oboru_6
FROM
  ad_custom_co_inzerat_pozice t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.id_oboru AS id_oboru_3, t0.is_brigada AS is_brigada_4, t0.is_pozice AS is_pozice_5, t0.id_oboru AS id_oboru_6 FROM ad_custom_co_inzerat_pozice t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_obor t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_obor t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_vhodne_pro t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_vhodne_pro t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_typ_omezeni t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_typ_omezeni t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_fyzicke_prostredi t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_fyzicke_prostredi t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_flexibilita_prace t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_flexibilita_prace t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_benefity_podpora t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_benefity_podpora t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_pristupnost_pracoviste t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_pristupnost_pracoviste t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_benefity t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_benefity t0;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  ad_custom_co_inzerat_smeny t0

SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_custom_co_inzerat_smeny t0;

SELECT
  a0_.id AS id_0,
  a0_.id_zdroje AS id_zdroje_1,
  a0_.uzivatele_id_zdroje AS uzivatele_id_zdroje_2,
  a0_.oznaceni AS oznaceni_3,
  a0_.titulek_cs AS titulek_cs_4,
  a0_.popis_cs AS popis_cs_5,
  a0_.pozadujeme_cs AS pozadujeme_cs_6,
  a0_.nabizime_cs AS nabizime_cs_7,
  a0_.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_8,
  a0_.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_9,
  a0_.mzda_od AS mzda_od_10,
  a0_.mzda_do AS mzda_do_11,
  a0_.pocet_dni AS pocet_dni_12,
  a0_.vhodne_pro AS vhodne_pro_13,
  a0_.uvazek AS uvazek_14,
  a0_.emaily AS emaily_15,
  a0_.zobraz_telefon AS zobraz_telefon_16,
  a0_.is_deleted AS is_deleted_17,
  a0_.created_at AS created_at_18,
  a0_.id_sekce AS id_sekce_19,
  a0_.id_statu AS id_statu_20,
  a0_.id_mesta AS id_mesta_21,
  a0_.id_pozice AS id_pozice_22,
  a0_.termin_od AS termin_od_23,
  a0_.mzda_typ AS mzda_typ_24,
  a0_.mzda_mena AS mzda_mena_25,
  a0_.pocet_mist AS pocet_mist_26,
  a0_.id_min_vzdelani AS id_min_vzdelani_27,
  a0_.uzivatel_zdroj_id AS uzivatel_zdroj_id_28
FROM
  ad_inzerat a0_
  LEFT JOIN ad_co_inzerat_pozice a1_ ON a0_.id_pozice = a1_.id
  LEFT JOIN ad_co_inzerat_sekce a2_ ON a0_.id_sekce = a2_.id
  LEFT JOIN ad_co_inzerat_mesto a3_ ON a0_.id_mesta = a3_.id
  LEFT JOIN ad_co_inzerat_obor a4_ ON a1_.id_oboru = a4_.id
  LEFT JOIN ad_uzivatel a5_ ON a0_.uzivatel_zdroj_id = a5_.id
  LEFT JOIN ad_firma a6_ ON a5_.firma_zdroj_id = a6_.id
WHERE
  a0_.is_deleted = ?
  AND 1 = 0
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.id_zdroje AS id_zdroje_1, a0_.uzivatele_id_zdroje AS uzivatele_id_zdroje_2, a0_.oznaceni AS oznaceni_3, a0_.titulek_cs AS titulek_cs_4, a0_.popis_cs AS popis_cs_5, a0_.pozadujeme_cs AS pozadujeme_cs_6, a0_.nabizime_cs AS nabizime_cs_7, a0_.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_8, a0_.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_9, a0_.mzda_od AS mzda_od_10, a0_.mzda_do AS mzda_do_11, a0_.pocet_dni AS pocet_dni_12, a0_.vhodne_pro AS vhodne_pro_13, a0_.uvazek AS uvazek_14, a0_.emaily AS emaily_15, a0_.zobraz_telefon AS zobraz_telefon_16, a0_.is_deleted AS is_deleted_17, a0_.created_at AS created_at_18, a0_.id_sekce AS id_sekce_19, a0_.id_statu AS id_statu_20, a0_.id_mesta AS id_mesta_21, a0_.id_pozice AS id_pozice_22, a0_.termin_od AS termin_od_23, a0_.mzda_typ AS mzda_typ_24, a0_.mzda_mena AS mzda_mena_25, a0_.pocet_mist AS pocet_mist_26, a0_.id_min_vzdelani AS id_min_vzdelani_27, a0_.uzivatel_zdroj_id AS uzivatel_zdroj_id_28 FROM ad_inzerat a0_ LEFT JOIN ad_co_inzerat_pozice a1_ ON a0_.id_pozice = a1_.id LEFT JOIN ad_co_inzerat_sekce a2_ ON a0_.id_sekce = a2_.id LEFT JOIN ad_co_inzerat_mesto a3_ ON a0_.id_mesta = a3_.id LEFT JOIN ad_co_inzerat_obor a4_ ON a1_.id_oboru = a4_.id LEFT JOIN ad_uzivatel a5_ ON a0_.uzivatel_zdroj_id = a5_.id LEFT JOIN ad_firma a6_ ON a5_.firma_zdroj_id = a6_.id WHERE a0_.is_deleted = 0 AND 1 = 0 ORDER BY a0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.oznaceni AS oznaceni_1,
  a0_.titulek_cs AS titulek_cs_2,
  a0_.popis_cs AS popis_cs_3,
  a0_.pozadujeme_cs AS pozadujeme_cs_4,
  a0_.nabizime_cs AS nabizime_cs_5,
  a0_.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_6,
  a0_.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_7,
  a0_.mzda_od AS mzda_od_8,
  a0_.mzda_do AS mzda_do_9,
  a0_.pocet_dni AS pocet_dni_10,
  a0_.emaily AS emaily_11,
  a0_.zobraz_telefon AS zobraz_telefon_12,
  a0_.is_deleted AS is_deleted_13,
  a0_.created_at AS created_at_14,
  a0_.forma_prace AS forma_prace_15,
  a0_.casova_flexibilita AS casova_flexibilita_16,
  a0_.vhodne_pro AS vhodne_pro_17,
  a0_.typ_omezeni AS typ_omezeni_18,
  a0_.fyzicke_prostredi AS fyzicke_prostredi_19,
  a0_.flexibilita_prace AS flexibilita_prace_20,
  a0_.benefity_podpora AS benefity_podpora_21,
  a0_.pristupnost_pracoviste AS pristupnost_pracoviste_22,
  a0_.specifikace_zdravotni_stav AS specifikace_zdravotni_stav_23,
  a0_.benefity AS benefity_24,
  a0_.smeny AS smeny_25,
  a0_.termin_brigady_od AS termin_brigady_od_26,
  a0_.termin_brigady_do AS termin_brigady_do_27,
  a0_.id_sekce AS id_sekce_28,
  a0_.id_statu AS id_statu_29,
  a0_.id_mesta AS id_mesta_30,
  a0_.id_pozice AS id_pozice_31,
  a0_.termin_od AS termin_od_32,
  a0_.mzda_typ AS mzda_typ_33,
  a0_.mzda_mena AS mzda_mena_34,
  a0_.pocet_mist AS pocet_mist_35,
  a0_.id_min_vzdelani AS id_min_vzdelani_36,
  a0_.uzivatel_zdroj_id AS uzivatel_zdroj_id_37,
  a0_.created_by_id AS created_by_id_38
FROM
  ad_custom_inzerat a0_
  LEFT JOIN ad_co_inzerat_pozice a1_ ON a0_.id_pozice = a1_.id
  LEFT JOIN ad_co_inzerat_sekce a2_ ON a0_.id_sekce = a2_.id
  LEFT JOIN ad_co_inzerat_mesto a3_ ON a0_.id_mesta = a3_.id
  LEFT JOIN ad_co_inzerat_obor a4_ ON a1_.id_oboru = a4_.id
  LEFT JOIN ad_uzivatel a5_ ON a0_.uzivatel_zdroj_id = a5_.id
  LEFT JOIN ad_firma a6_ ON a5_.firma_zdroj_id = a6_.id
WHERE
  a0_.is_deleted = ?
  AND (
    a0_.forma_prace LIKE ?
    OR a0_.vhodne_pro LIKE ?
    OR a0_.typ_omezeni LIKE ?
    OR a0_.fyzicke_prostredi LIKE ?
    OR a0_.flexibilita_prace LIKE ?
    OR a0_.benefity_podpora LIKE ?
    OR a0_.pristupnost_pracoviste LIKE ?
    OR a0_.benefity LIKE ?
    OR a0_.smeny LIKE ?
    OR a0_.forma_prace LIKE ?
    OR a0_.vhodne_pro LIKE ?
    OR a0_.typ_omezeni LIKE ?
    OR a0_.fyzicke_prostredi LIKE ?
    OR a0_.flexibilita_prace LIKE ?
    OR a0_.benefity_podpora LIKE ?
    OR a0_.pristupnost_pracoviste LIKE ?
    OR a0_.benefity LIKE ?
    OR a0_.smeny LIKE ?
    OR a0_.forma_prace LIKE ?
    OR a0_.vhodne_pro LIKE ?
    OR a0_.typ_omezeni LIKE ?
    OR a0_.fyzicke_prostredi LIKE ?
    OR a0_.flexibilita_prace LIKE ?
    OR a0_.benefity_podpora LIKE ?
    OR a0_.pristupnost_pracoviste LIKE ?
    OR a0_.benefity LIKE ?
    OR a0_.smeny LIKE ?
  )
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.oznaceni AS oznaceni_1, a0_.titulek_cs AS titulek_cs_2, a0_.popis_cs AS popis_cs_3, a0_.pozadujeme_cs AS pozadujeme_cs_4, a0_.nabizime_cs AS nabizime_cs_5, a0_.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_6, a0_.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_7, a0_.mzda_od AS mzda_od_8, a0_.mzda_do AS mzda_do_9, a0_.pocet_dni AS pocet_dni_10, a0_.emaily AS emaily_11, a0_.zobraz_telefon AS zobraz_telefon_12, a0_.is_deleted AS is_deleted_13, a0_.created_at AS created_at_14, a0_.forma_prace AS forma_prace_15, a0_.casova_flexibilita AS casova_flexibilita_16, a0_.vhodne_pro AS vhodne_pro_17, a0_.typ_omezeni AS typ_omezeni_18, a0_.fyzicke_prostredi AS fyzicke_prostredi_19, a0_.flexibilita_prace AS flexibilita_prace_20, a0_.benefity_podpora AS benefity_podpora_21, a0_.pristupnost_pracoviste AS pristupnost_pracoviste_22, a0_.specifikace_zdravotni_stav AS specifikace_zdravotni_stav_23, a0_.benefity AS benefity_24, a0_.smeny AS smeny_25, a0_.termin_brigady_od AS termin_brigady_od_26, a0_.termin_brigady_do AS termin_brigady_do_27, a0_.id_sekce AS id_sekce_28, a0_.id_statu AS id_statu_29, a0_.id_mesta AS id_mesta_30, a0_.id_pozice AS id_pozice_31, a0_.termin_od AS termin_od_32, a0_.mzda_typ AS mzda_typ_33, a0_.mzda_mena AS mzda_mena_34, a0_.pocet_mist AS pocet_mist_35, a0_.id_min_vzdelani AS id_min_vzdelani_36, a0_.uzivatel_zdroj_id AS uzivatel_zdroj_id_37, a0_.created_by_id AS created_by_id_38 FROM ad_custom_inzerat a0_ LEFT JOIN ad_co_inzerat_pozice a1_ ON a0_.id_pozice = a1_.id LEFT JOIN ad_co_inzerat_sekce a2_ ON a0_.id_sekce = a2_.id LEFT JOIN ad_co_inzerat_mesto a3_ ON a0_.id_mesta = a3_.id LEFT JOIN ad_co_inzerat_obor a4_ ON a1_.id_oboru = a4_.id LEFT JOIN ad_uzivatel a5_ ON a0_.uzivatel_zdroj_id = a5_.id LEFT JOIN ad_firma a6_ ON a5_.firma_zdroj_id = a6_.id WHERE a0_.is_deleted = 0 AND (a0_.forma_prace LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.vhodne_pro LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.typ_omezeni LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.fyzicke_prostredi LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.flexibilita_prace LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.benefity_podpora LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.pristupnost_pracoviste LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.benefity LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.smeny LIKE '%\"V léčbě / imunokompromitovaný/á\"%' OR a0_.forma_prace LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.vhodne_pro LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.typ_omezeni LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.fyzicke_prostredi LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.flexibilita_prace LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.benefity_podpora LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.pristupnost_pracoviste LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.benefity LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.smeny LIKE '%\"V léčbě / imunosuprese\"%' OR a0_.forma_prace LIKE '%\"imunosup\"%' OR a0_.vhodne_pro LIKE '%\"imunosup\"%' OR a0_.typ_omezeni LIKE '%\"imunosup\"%' OR a0_.fyzicke_prostredi LIKE '%\"imunosup\"%' OR a0_.flexibilita_prace LIKE '%\"imunosup\"%' OR a0_.benefity_podpora LIKE '%\"imunosup\"%' OR a0_.pristupnost_pracoviste LIKE '%\"imunosup\"%' OR a0_.benefity LIKE '%\"imunosup\"%' OR a0_.smeny LIKE '%\"imunosup\"%') ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.general_partner AS general_partner_3,
  t0.web_url AS web_url_4,
  t0.poradi AS poradi_5,
  t0.logo_id AS logo_id_6
FROM
  partners t0
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.poradi AS poradi_5
FROM
  main_menu_items t0
WHERE
  t0.active = ?
ORDER BY
  t0.poradi ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = 1 ORDER BY t0.poradi ASC;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 473;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 369;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 370;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 371;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.updated_at AS updated_at_3
FROM
  uploaded t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = 372;