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 = ?
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 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 = ?
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 ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.phone_no AS phone_no_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.is_approved AS is_approved_9,
  t0.reg_reasons AS reg_reasons_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.approved_by_id AS approved_by_id_12,
  t0.uploadable_id AS uploadable_id_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.phone_no AS phone_no_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_approved AS is_approved_9, t0.reg_reasons AS reg_reasons_10, t0.updated_by_id AS updated_by_id_11, t0.approved_by_id AS approved_by_id_12, t0.uploadable_id AS uploadable_id_13 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.headquarter AS headquarter_4,
  t0.ico AS ico_5,
  t0.dic AS dic_6,
  t0.bank_no AS bank_no_7,
  t0.correspondece AS correspondece_8,
  t0.approved AS approved_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.nationwide AS nationwide_12,
  t0.slug AS slug_13,
  t0.changes_md_sum AS changes_md_sum_14,
  t0.approved_by_id AS approved_by_id_15,
  t0.owner_id AS owner_id_16,
  t0.logo_id AS logo_id_17
FROM
  company t0
  INNER JOIN user_company ON t0.id = user_company.company_id
WHERE
  user_company.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 INNER JOIN user_company ON t0.id = user_company.company_id WHERE user_company.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.headquarter AS headquarter_4,
  t0.ico AS ico_5,
  t0.dic AS dic_6,
  t0.bank_no AS bank_no_7,
  t0.correspondece AS correspondece_8,
  t0.approved AS approved_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.nationwide AS nationwide_12,
  t0.slug AS slug_13,
  t0.changes_md_sum AS changes_md_sum_14,
  t0.approved_by_id AS approved_by_id_15,
  t0.owner_id AS owner_id_16,
  t0.logo_id AS logo_id_17
FROM
  company t0
WHERE
  t0.owner_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.owner_id = 1 LIMIT 1;

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.id_zdroje AS id_zdroje_2,
  t0.firmy_id_zdroje AS firmy_id_zdroje_3,
  t0.email AS email_4,
  t0.jmeno AS jmeno_5,
  t0.prijmeni AS prijmeni_6,
  t0.predvolba_telefon AS predvolba_telefon_7,
  t0.telefon AS telefon_8,
  t0.is_deleted AS is_deleted_9,
  t0.firma_zdroj_id AS firma_zdroj_id_10
FROM
  ad_uzivatel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_zdroje AS id_zdroje_2, t0.firmy_id_zdroje AS firmy_id_zdroje_3, t0.email AS email_4, t0.jmeno AS jmeno_5, t0.prijmeni AS prijmeni_6, t0.predvolba_telefon AS predvolba_telefon_7, t0.telefon AS telefon_8, t0.is_deleted AS is_deleted_9, t0.firma_zdroj_id AS firma_zdroj_id_10 FROM ad_uzivatel t0 WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.id_zdroje AS id_zdroje_2,
  t0.nazev AS nazev_3,
  t0.ico AS ico_4,
  t0.dic AS dic_5,
  t0.ulice AS ulice_6,
  t0.mesto AS mesto_7,
  t0.url AS url_8,
  t0.popis AS popis_9,
  t0.logo_source AS logo_source_10,
  t0.id_inzerenta AS id_inzerenta_11,
  t0.is_deleted AS is_deleted_12,
  t0.logo_id AS logo_id_13
FROM
  ad_firma t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_zdroje AS id_zdroje_2, t0.nazev AS nazev_3, t0.ico AS ico_4, t0.dic AS dic_5, t0.ulice AS ulice_6, t0.mesto AS mesto_7, t0.url AS url_8, t0.popis AS popis_9, t0.logo_source AS logo_source_10, t0.id_inzerenta AS id_inzerenta_11, t0.is_deleted AS is_deleted_12, t0.logo_id AS logo_id_13 FROM ad_firma t0 WHERE t0.id = 22;