Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.date_create AS date_create_5,
  t0.date_publication AS date_publication_6,
  t0.statut AS statut_7,
  t0.updated_at AS updated_at_8,
  t0.introduction AS introduction_9,
  t0.tarif AS tarif_10,
  t0.thumbnail AS thumbnail_11,
  t0.slug AS slug_12,
  t0.is_home AS is_home_13,
  t0.type_abonnement_id AS type_abonnement_id_14,
  t0.author_id AS author_id_15
FROM
  diagnostic t0
  INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id
WHERE
  diagnostic_categorie.categorie_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = 19;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.url AS url_4,
  t0.icone AS icone_5,
  t0.updated_at AS updated_at_6,
  t0.position AS position_7
FROM
  categorie t0
  INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id
WHERE
  diagnostic_categorie.diagnostic_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.icone AS icone_5, t0.updated_at AS updated_at_6, t0.position AS position_7 FROM categorie t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id WHERE diagnostic_categorie.diagnostic_id = 33;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.sous_titre1 AS sous_titre1_3,
  t0.sous_titre2 AS sous_titre2_4,
  t0.domaine AS domaine_5,
  t0.logo AS logo_6,
  t0.image AS image_7,
  t0.description AS description_8,
  t0.updated_at AS updated_at_9,
  t0.url AS url_10,
  t0.bg_color_menu AS bg_color_menu_11,
  t0.text_color_menu AS text_color_menu_12,
  t0.btn_inscription_color AS btn_inscription_color_13,
  t0.bg_color_body AS bg_color_body_14,
  t0.copyright AS copyright_15,
  t0.cabinet_id AS cabinet_id_16
FROM
  site t0
WHERE
  t0.domaine = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 WHERE t0.domaine = 'mysherlock.devextractor.com' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.url AS url_2,
  p0_.contenu AS contenu_3,
  p0_.footer AS footer_4,
  p0_.position AS position_5,
  p0_.is_header AS is_header_6,
  p0_.sous_titre AS sous_titre_7,
  p0_.image AS image_8,
  p0_.updated_at AS updated_at_9,
  p0_.contenu_home AS contenu_home_10
FROM
  page p0_
  INNER JOIN page_site p2_ ON p0_.id = p2_.page_id
  INNER JOIN site s1_ ON s1_.id = p2_.site_id
WHERE
  s1_.id = ?
  AND p0_.is_header = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.url AS url_2, p0_.contenu AS contenu_3, p0_.footer AS footer_4, p0_.position AS position_5, p0_.is_header AS is_header_6, p0_.sous_titre AS sous_titre_7, p0_.image AS image_8, p0_.updated_at AS updated_at_9, p0_.contenu_home AS contenu_home_10 FROM page p0_ INNER JOIN page_site p2_ ON p0_.id = p2_.page_id INNER JOIN site s1_ ON s1_.id = p2_.site_id WHERE s1_.id = 3 AND p0_.is_header = 1 GROUP BY p0_.id ORDER BY p0_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.titre AS titre_1,
  c0_.description AS description_2,
  c0_.url AS url_3,
  c0_.icone AS icone_4,
  c0_.updated_at AS updated_at_5,
  c0_.position AS position_6
FROM
  categorie c0_
  INNER JOIN categorie_site c2_ ON c0_.id = c2_.categorie_id
  INNER JOIN site s1_ ON s1_.id = c2_.site_id
  INNER JOIN diagnostic_categorie d4_ ON c0_.id = d4_.categorie_id
  INNER JOIN diagnostic d3_ ON d3_.id = d4_.diagnostic_id
WHERE
  s1_.id = ?
  AND (
    d3_.statut = 'publie'
    AND d3_.is_home = 1
  )
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.description AS description_2, c0_.url AS url_3, c0_.icone AS icone_4, c0_.updated_at AS updated_at_5, c0_.position AS position_6 FROM categorie c0_ INNER JOIN categorie_site c2_ ON c0_.id = c2_.categorie_id INNER JOIN site s1_ ON s1_.id = c2_.site_id INNER JOIN diagnostic_categorie d4_ ON c0_.id = d4_.categorie_id INNER JOIN diagnostic d3_ ON d3_.id = d4_.diagnostic_id WHERE s1_.id = 3 AND (d3_.statut = 'publie' AND d3_.is_home = 1) GROUP BY c0_.id ORDER BY c0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.sous_titre1 AS sous_titre1_3,
  t0.sous_titre2 AS sous_titre2_4,
  t0.domaine AS domaine_5,
  t0.logo AS logo_6,
  t0.image AS image_7,
  t0.description AS description_8,
  t0.updated_at AS updated_at_9,
  t0.url AS url_10,
  t0.bg_color_menu AS bg_color_menu_11,
  t0.text_color_menu AS text_color_menu_12,
  t0.btn_inscription_color AS btn_inscription_color_13,
  t0.bg_color_body AS bg_color_body_14,
  t0.copyright AS copyright_15,
  t0.cabinet_id AS cabinet_id_16
FROM
  site t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.url AS url_2,
  p0_.contenu AS contenu_3,
  p0_.footer AS footer_4,
  p0_.position AS position_5,
  p0_.is_header AS is_header_6,
  p0_.sous_titre AS sous_titre_7,
  p0_.image AS image_8,
  p0_.updated_at AS updated_at_9,
  p0_.contenu_home AS contenu_home_10
FROM
  page p0_
  INNER JOIN page_site p2_ ON p0_.id = p2_.page_id
  INNER JOIN site s1_ ON s1_.id = p2_.site_id
WHERE
  s1_.id = ?
  AND p0_.footer = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.url AS url_2, p0_.contenu AS contenu_3, p0_.footer AS footer_4, p0_.position AS position_5, p0_.is_header AS is_header_6, p0_.sous_titre AS sous_titre_7, p0_.image AS image_8, p0_.updated_at AS updated_at_9, p0_.contenu_home AS contenu_home_10 FROM page p0_ INNER JOIN page_site p2_ ON p0_.id = p2_.page_id INNER JOIN site s1_ ON s1_.id = p2_.site_id WHERE s1_.id = 3 AND p0_.footer = 1 GROUP BY p0_.id ORDER BY p0_.position ASC;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.lien AS lien_2,
  r0_.classe AS classe_3,
  r0_.position AS position_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.site_id AS site_id_7
FROM
  reseaux_sociaux r0_
WHERE
  r0_.site_id = ?
ORDER BY
  r0_.position ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.lien AS lien_2, r0_.classe AS classe_3, r0_.position AS position_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.site_id AS site_id_7 FROM reseaux_sociaux r0_ WHERE r0_.site_id = 3 ORDER BY r0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.url AS url_2,
  p0_.contenu AS contenu_3,
  p0_.footer AS footer_4,
  p0_.position AS position_5,
  p0_.is_header AS is_header_6,
  p0_.sous_titre AS sous_titre_7,
  p0_.image AS image_8,
  p0_.updated_at AS updated_at_9,
  p0_.contenu_home AS contenu_home_10
FROM
  page p0_
  INNER JOIN page_site p2_ ON p0_.id = p2_.page_id
  INNER JOIN site s1_ ON s1_.id = p2_.site_id
WHERE
  s1_.id = ?
  AND p0_.url = ?

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.url AS url_2, p0_.contenu AS contenu_3, p0_.footer AS footer_4, p0_.position AS position_5, p0_.is_header AS is_header_6, p0_.sous_titre AS sous_titre_7, p0_.image AS image_8, p0_.updated_at AS updated_at_9, p0_.contenu_home AS contenu_home_10 FROM page p0_ INNER JOIN page_site p2_ ON p0_.id = p2_.page_id INNER JOIN site s1_ ON s1_.id = p2_.site_id WHERE s1_.id = 3 AND p0_.url = 'mentions-legales';