Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre_fr AS titre_fr_2,
  t0.titre_en AS titre_en_3,
  t0.titre_de AS titre_de_4,
  t0.description_fr AS description_fr_5,
  t0.description_en AS description_en_6,
  t0.description_de AS description_de_7,
  t0.date AS date_8,
  t0.image AS image_9,
  t0.lieu_fr AS lieu_fr_10,
  t0.lieu_en AS lieu_en_11,
  t0.lieu_de AS lieu_de_12,
  t0.affichage AS affichage_13,
  t0.savethedate AS savethedate_14,
  t0.seo_description_en AS seo_description_en_15,
  t0.seo_description_fr AS seo_description_fr_16,
  t0.seo_description_de AS seo_description_de_17,
  t0.link_form AS link_form_18
FROM
  events t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.date AS date_8, t0.image AS image_9, t0.lieu_fr AS lieu_fr_10, t0.lieu_en AS lieu_en_11, t0.lieu_de AS lieu_de_12, t0.affichage AS affichage_13, t0.savethedate AS savethedate_14, t0.seo_description_en AS seo_description_en_15, t0.seo_description_fr AS seo_description_fr_16, t0.seo_description_de AS seo_description_de_17, t0.link_form AS link_form_18 FROM events t0 WHERE t0.id = '28' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre_en AS titre_en_2,
  t0.titre_fr AS titre_fr_3,
  t0.titre_de AS titre_de_4,
  t0.intro_fr AS intro_fr_5,
  t0.intro_en AS intro_en_6,
  t0.intro_de AS intro_de_7,
  t0.page_id AS page_id_8,
  t0.expertise_id AS expertise_id_9,
  t0.event_id AS event_id_10,
  t0.award_id AS award_id_11
FROM
  qand_a t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.titre_en AS titre_en_2, t0.titre_fr AS titre_fr_3, t0.titre_de AS titre_de_4, t0.intro_fr AS intro_fr_5, t0.intro_en AS intro_en_6, t0.intro_de AS intro_de_7, t0.page_id AS page_id_8, t0.expertise_id AS expertise_id_9, t0.event_id AS event_id_10, t0.award_id AS award_id_11 FROM qand_a t0 WHERE t0.event_id = 28;

SELECT
  t0.id AS id_1,
  t0.quote_en AS quote_en_2,
  t0.quote_fr AS quote_fr_3,
  t0.quote_de AS quote_de_4,
  t0.autor AS autor_5,
  t0.page_id AS page_id_6,
  t0.expertise_id AS expertise_id_7,
  t0.event_id AS event_id_8,
  t0.award_id AS award_id_9,
  t0.avocat_id AS avocat_id_10
FROM
  quotes t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.quote_en AS quote_en_2, t0.quote_fr AS quote_fr_3, t0.quote_de AS quote_de_4, t0.autor AS autor_5, t0.page_id AS page_id_6, t0.expertise_id AS expertise_id_7, t0.event_id AS event_id_8, t0.award_id AS award_id_9, t0.avocat_id AS avocat_id_10 FROM quotes t0 WHERE t0.event_id = 28;

SELECT
  t0.id AS id_1,
  t0.titre_fr AS titre_fr_2,
  t0.titre_en AS titre_en_3,
  t0.titre_de AS titre_de_4,
  t0.description_fr AS description_fr_5,
  t0.description_en AS description_en_6,
  t0.description_de AS description_de_7,
  t0.contenus_id AS contenus_id_8,
  t0.qanda_id AS qanda_id_9
FROM
  accordeons t0
WHERE
  t0.qanda_id IN (NULL)

SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.contenus_id AS contenus_id_8, t0.qanda_id AS qanda_id_9 FROM accordeons t0 WHERE t0.qanda_id IN (NULL);

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.image AS image_3,
  t0.ordre AS ordre_4,
  t0.pages_id AS pages_id_5,
  t0.actualites_id AS actualites_id_6,
  t0.expertises_id AS expertises_id_7,
  t0.avocats_id AS avocats_id_8,
  t0.events_id AS events_id_9,
  t0.awards_id AS awards_id_10
FROM
  sections t0
WHERE
  t0.events_id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.image AS image_3, t0.ordre AS ordre_4, t0.pages_id AS pages_id_5, t0.actualites_id AS actualites_id_6, t0.expertises_id AS expertises_id_7, t0.avocats_id AS avocats_id_8, t0.events_id AS events_id_9, t0.awards_id AS awards_id_10 FROM sections t0 WHERE t0.events_id = 28;

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.image AS image_3,
  t0.ordre AS ordre_4,
  t0.pages_id AS pages_id_5,
  t0.actualites_id AS actualites_id_6,
  t0.expertises_id AS expertises_id_7,
  t0.avocats_id AS avocats_id_8,
  t0.events_id AS events_id_9,
  t0.awards_id AS awards_id_10
FROM
  sections t0
WHERE
  t0.events_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.color AS color_2, t0.image AS image_3, t0.ordre AS ordre_4, t0.pages_id AS pages_id_5, t0.actualites_id AS actualites_id_6, t0.expertises_id AS expertises_id_7, t0.avocats_id AS avocats_id_8, t0.events_id AS events_id_9, t0.awards_id AS awards_id_10 FROM sections t0 WHERE t0.events_id = 28 ORDER BY t0.ordre ASC;

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.description_en AS description_en_2,
  a0_.telephone AS telephone_3,
  a0_.linkedin AS linkedin_4,
  a0_.mail AS mail_5,
  a0_.image AS image_6,
  a0_.education_accordeon AS education_accordeon_7,
  a0_.language_accordeon AS language_accordeon_8,
  a0_.memberships_accordeon AS memberships_accordeon_9,
  a0_.date_admission_barreau AS date_admission_barreau_10,
  a0_.telephone_perso AS telephone_perso_11,
  a0_.vcard AS vcard_12,
  a0_.bio_pdf AS bio_pdf_13,
  a0_.qrcode AS qrcode_14,
  a0_.affichage AS affichage_15,
  a0_.affichage_liste AS affichage_liste_16,
  a0_.seo_description_en AS seo_description_en_17,
  a0_.seo_description_fr AS seo_description_fr_18,
  a0_.seo_description_de AS seo_description_de_19,
  a0_.role_change_en AS role_change_en_20,
  a0_.role_change_fr AS role_change_fr_21,
  a0_.role_change_de AS role_change_de_22,
  a0_.role_id AS role_id_23
FROM
  avocats a0_
  INNER JOIN avocat_events a1_ ON a0_.id = a1_.avocat_id
  INNER JOIN roles_avocats r2_ ON a0_.role_id = r2_.id
WHERE
  a1_.event_id = ?
ORDER BY
  r2_.priority ASC,
  a0_.date_admission_barreau ASC,
  SUBSTRING(
    a0_.nom
    FROM
      LOCATE(' ', a0_.nom) + 1
  ) ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description_en AS description_en_2, a0_.telephone AS telephone_3, a0_.linkedin AS linkedin_4, a0_.mail AS mail_5, a0_.image AS image_6, a0_.education_accordeon AS education_accordeon_7, a0_.language_accordeon AS language_accordeon_8, a0_.memberships_accordeon AS memberships_accordeon_9, a0_.date_admission_barreau AS date_admission_barreau_10, a0_.telephone_perso AS telephone_perso_11, a0_.vcard AS vcard_12, a0_.bio_pdf AS bio_pdf_13, a0_.qrcode AS qrcode_14, a0_.affichage AS affichage_15, a0_.affichage_liste AS affichage_liste_16, a0_.seo_description_en AS seo_description_en_17, a0_.seo_description_fr AS seo_description_fr_18, a0_.seo_description_de AS seo_description_de_19, a0_.role_change_en AS role_change_en_20, a0_.role_change_fr AS role_change_fr_21, a0_.role_change_de AS role_change_de_22, a0_.role_id AS role_id_23 FROM avocats a0_ INNER JOIN avocat_events a1_ ON a0_.id = a1_.avocat_id INNER JOIN roles_avocats r2_ ON a0_.role_id = r2_.id WHERE a1_.event_id = '28' ORDER BY r2_.priority ASC, a0_.date_admission_barreau ASC, SUBSTRING(a0_.nom FROM LOCATE(' ', a0_.nom) + 1) ASC;

SELECT
  t0.id AS id_1,
  t0.titre_fr AS titre_fr_2,
  t0.titre_en AS titre_en_3,
  t0.titre_de AS titre_de_4,
  t0.description_fr AS description_fr_5,
  t0.description_en AS description_en_6,
  t0.description_de AS description_de_7,
  t0.date AS date_8,
  t0.image AS image_9,
  t0.lieu_fr AS lieu_fr_10,
  t0.lieu_en AS lieu_en_11,
  t0.lieu_de AS lieu_de_12,
  t0.affichage AS affichage_13,
  t0.savethedate AS savethedate_14,
  t0.seo_description_en AS seo_description_en_15,
  t0.seo_description_fr AS seo_description_fr_16,
  t0.seo_description_de AS seo_description_de_17,
  t0.link_form AS link_form_18
FROM
  events t0
WHERE
  t0.affichage = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.date AS date_8, t0.image AS image_9, t0.lieu_fr AS lieu_fr_10, t0.lieu_en AS lieu_en_11, t0.lieu_de AS lieu_de_12, t0.affichage AS affichage_13, t0.savethedate AS savethedate_14, t0.seo_description_en AS seo_description_en_15, t0.seo_description_fr AS seo_description_fr_16, t0.seo_description_de AS seo_description_de_17, t0.link_form AS link_form_18 FROM events t0 WHERE t0.affichage = 'Oui' ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.nom_en AS nom_en_2,
  t0.nom_fr AS nom_fr_3,
  t0.nom_de AS nom_de_4,
  t0.image AS image_5,
  t0.affichage AS affichage_6,
  t0.seo_description_de AS seo_description_de_7,
  t0.seo_description_fr AS seo_description_fr_8,
  t0.seo_description_en AS seo_description_en_9,
  t0.categorie_id AS categorie_id_10
FROM
  expertises t0
ORDER BY
  t0.nom_en ASC

SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC;

SELECT
  t0.id AS id_1,
  t0.libelle_en AS libelle_en_2,
  t0.libelle_fr AS libelle_fr_3,
  t0.libelle_de AS libelle_de_4
FROM
  categories_expertises t0

SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0;

SELECT
  t0.id AS id_1,
  t0.nom_en AS nom_en_2,
  t0.nom_fr AS nom_fr_3,
  t0.nom_de AS nom_de_4,
  t0.image AS image_5,
  t0.affichage AS affichage_6,
  t0.seo_description_de AS seo_description_de_7,
  t0.seo_description_fr AS seo_description_fr_8,
  t0.seo_description_en AS seo_description_en_9,
  t0.categorie_id AS categorie_id_10
FROM
  expertises t0
WHERE
  t0.affichage = ?
ORDER BY
  t0.nom_en ASC

SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 WHERE t0.affichage = 'Oui' ORDER BY t0.nom_en ASC;

SELECT
  t0.id AS id_1,
  t0.libelle_en AS libelle_en_2,
  t0.libelle_fr AS libelle_fr_3,
  t0.libelle_de AS libelle_de_4
FROM
  categories_expertises t0

SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0;

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.sections_id AS sections_id_3
FROM
  lignes t0
WHERE
  t0.sections_id = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = 260;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.lignes_id AS lignes_id_3
FROM
  blocs t0
WHERE
  t0.lignes_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.lignes_id AS lignes_id_3 FROM blocs t0 WHERE t0.lignes_id = 637;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.lignes_id AS lignes_id_3
FROM
  blocs t0
WHERE
  t0.lignes_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.lignes_id AS lignes_id_3 FROM blocs t0 WHERE t0.lignes_id = 638;

SELECT
  t0.id AS id_1,
  t0.titre_fr AS titre_fr_2,
  t0.texte_fr AS texte_fr_3,
  t0.image AS image_4,
  t0.titre_en AS titre_en_5,
  t0.titre_de AS titre_de_6,
  t0.texte_en AS texte_en_7,
  t0.texte_de AS texte_de_8,
  t0.document AS document_9,
  t0.lien_en AS lien_en_10,
  t0.citation_fr AS citation_fr_11,
  t0.citation_en AS citation_en_12,
  t0.citation_de AS citation_de_13,
  t0.auteur AS auteur_14,
  t0.image_fr AS image_fr_15,
  t0.image_de AS image_de_16,
  t0.lien_fr AS lien_fr_17,
  t0.lien_de AS lien_de_18,
  t0.blocs_id AS blocs_id_19,
  t0.types_contenus_id AS types_contenus_id_20
FROM
  contenus t0
WHERE
  t0.blocs_id = ?

SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.texte_fr AS texte_fr_3, t0.image AS image_4, t0.titre_en AS titre_en_5, t0.titre_de AS titre_de_6, t0.texte_en AS texte_en_7, t0.texte_de AS texte_de_8, t0.document AS document_9, t0.lien_en AS lien_en_10, t0.citation_fr AS citation_fr_11, t0.citation_en AS citation_en_12, t0.citation_de AS citation_de_13, t0.auteur AS auteur_14, t0.image_fr AS image_fr_15, t0.image_de AS image_de_16, t0.lien_fr AS lien_fr_17, t0.lien_de AS lien_de_18, t0.blocs_id AS blocs_id_19, t0.types_contenus_id AS types_contenus_id_20 FROM contenus t0 WHERE t0.blocs_id = 422;

SELECT
  t0.id AS id_1,
  t0.event_id AS event_id_2,
  t0.expertise_id AS expertise_id_3
FROM
  event_expertises t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.event_id AS event_id_2, t0.expertise_id AS expertise_id_3 FROM event_expertises t0 WHERE t0.event_id = 28;

SELECT
  t0.id AS id_1,
  t0.role_en AS role_en_2,
  t0.priority AS priority_3,
  t0.role_fr AS role_fr_4,
  t0.role_de AS role_de_5,
  t0.role_change_fr AS role_change_fr_6,
  t0.role_change_en AS role_change_en_7,
  t0.role_change_de AS role_change_de_8
FROM
  roles_avocats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.role_en AS role_en_2, t0.priority AS priority_3, t0.role_fr AS role_fr_4, t0.role_de AS role_de_5, t0.role_change_fr AS role_change_fr_6, t0.role_change_en AS role_change_en_7, t0.role_change_de AS role_change_de_8 FROM roles_avocats t0 WHERE t0.id = 6;