Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.genre AS genre_4,
  u0_.nom AS nom_5,
  u0_.prenom AS prenom_6,
  u0_.entreprise AS entreprise_7,
  u0_.telephone AS telephone_8,
  u0_.adresse AS adresse_9,
  u0_.code_postale AS code_postale_10,
  u0_.image AS image_11,
  u0_.updated_at AS updated_at_12,
  u0_.enabled AS enabled_13,
  u0_.password_defined AS password_defined_14,
  u0_.password_creation_token AS password_creation_token_15,
  u0_.confirmation_token AS confirmation_token_16,
  u0_.password_requested_at AS password_requested_at_17,
  u0_.last_login AS last_login_18,
  u0_.reset_password AS reset_password_19,
  u0_.token AS token_20,
  u0_.ville AS ville_21,
  u0_.grade AS grade_22,
  u0_.cabinet_id AS cabinet_id_23
FROM
  user u0_
  INNER JOIN cabinet c1_ ON u0_.cabinet_id = c1_.id
WHERE
  u0_.roles LIKE '%ROLE_MANAGER%'
ORDER BY
  u0_.prenom ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.genre AS genre_4, u0_.nom AS nom_5, u0_.prenom AS prenom_6, u0_.entreprise AS entreprise_7, u0_.telephone AS telephone_8, u0_.adresse AS adresse_9, u0_.code_postale AS code_postale_10, u0_.image AS image_11, u0_.updated_at AS updated_at_12, u0_.enabled AS enabled_13, u0_.password_defined AS password_defined_14, u0_.password_creation_token AS password_creation_token_15, u0_.confirmation_token AS confirmation_token_16, u0_.password_requested_at AS password_requested_at_17, u0_.last_login AS last_login_18, u0_.reset_password AS reset_password_19, u0_.token AS token_20, u0_.ville AS ville_21, u0_.grade AS grade_22, u0_.cabinet_id AS cabinet_id_23 FROM user u0_ INNER JOIN cabinet c1_ ON u0_.cabinet_id = c1_.id WHERE u0_.roles LIKE '%ROLE_MANAGER%' ORDER BY u0_.prenom 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
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 = 'myeval.devextractor.com' LIMIT 1;

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 = 4 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
  INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id
WHERE
  diagnostic_site.diagnostic_id = ?

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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = 44;

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 = 4 AND p0_.is_header = 1 GROUP BY p0_.id ORDER BY p0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.is_obligatoire AS is_obligatoire_3,
  t0.bulle_info AS bulle_info_4,
  t0.plus_reponse AS plus_reponse_5,
  t0.autre_fin AS autre_fin_6,
  t0.position AS position_7,
  t0.have_condition AS have_condition_8,
  t0.scoring AS scoring_9,
  t0.for_user AS for_user_10,
  t0.type_question_id AS type_question_id_11,
  t0.diagnostic_id AS diagnostic_id_12
FROM
  question t0
WHERE
  t0.diagnostic_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.is_obligatoire AS is_obligatoire_3, t0.bulle_info AS bulle_info_4, t0.plus_reponse AS plus_reponse_5, t0.autre_fin AS autre_fin_6, t0.position AS position_7, t0.have_condition AS have_condition_8, t0.scoring AS scoring_9, t0.for_user AS for_user_10, t0.type_question_id AS type_question_id_11, t0.diagnostic_id AS diagnostic_id_12 FROM question t0 WHERE t0.diagnostic_id = 51 ORDER BY t0.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
  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.is_exclusive AS is_exclusive_14,
  t0.type_abonnement_id AS type_abonnement_id_15
FROM
  diagnostic t0
WHERE
  t0.slug = ?
LIMIT
  1

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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 WHERE t0.slug = 'entretien-annuel' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.position AS position_3,
  t0.indication AS indication_4,
  t0.is_rh AS is_rh_5,
  t0.has_synthese AS has_synthese_6,
  t0.diagnostic_id AS diagnostic_id_7
FROM
  etape_question t0
WHERE
  t0.diagnostic_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.position AS position_3, t0.indication AS indication_4, t0.is_rh AS is_rh_5, t0.has_synthese AS has_synthese_6, t0.diagnostic_id AS diagnostic_id_7 FROM etape_question t0 WHERE t0.diagnostic_id = 51 ORDER BY t0.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.is_active AS is_active_2,
  c0_.annee AS annee_3
FROM
  campaign c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.annee AS annee_3 FROM campaign c0_;

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.description AS description_2,
  d0_.image AS image_3,
  d0_.date_create AS date_create_4,
  d0_.date_publication AS date_publication_5,
  d0_.statut AS statut_6,
  d0_.updated_at AS updated_at_7,
  d0_.introduction AS introduction_8,
  d0_.tarif AS tarif_9,
  d0_.thumbnail AS thumbnail_10,
  d0_.slug AS slug_11,
  d0_.is_home AS is_home_12,
  d0_.is_exclusive AS is_exclusive_13,
  d0_.type_abonnement_id AS type_abonnement_id_14
FROM
  diagnostic d0_
  INNER JOIN diagnostic_site d2_ ON d0_.id = d2_.diagnostic_id
  INNER JOIN site s1_ ON s1_.id = d2_.site_id
WHERE
  s1_.id = ?
  AND d0_.statut = 'publie'
GROUP BY
  d0_.id
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.description AS description_2, d0_.image AS image_3, d0_.date_create AS date_create_4, d0_.date_publication AS date_publication_5, d0_.statut AS statut_6, d0_.updated_at AS updated_at_7, d0_.introduction AS introduction_8, d0_.tarif AS tarif_9, d0_.thumbnail AS thumbnail_10, d0_.slug AS slug_11, d0_.is_home AS is_home_12, d0_.is_exclusive AS is_exclusive_13, d0_.type_abonnement_id AS type_abonnement_id_14 FROM diagnostic d0_ INNER JOIN diagnostic_site d2_ ON d0_.id = d2_.diagnostic_id INNER JOIN site s1_ ON s1_.id = d2_.site_id WHERE s1_.id = 4 AND d0_.statut = 'publie' GROUP BY d0_.id ORDER BY d0_.id ASC;

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.description AS description_2,
  d0_.image AS image_3,
  d0_.date_create AS date_create_4,
  d0_.date_publication AS date_publication_5,
  d0_.statut AS statut_6,
  d0_.updated_at AS updated_at_7,
  d0_.introduction AS introduction_8,
  d0_.tarif AS tarif_9,
  d0_.thumbnail AS thumbnail_10,
  d0_.slug AS slug_11,
  d0_.is_home AS is_home_12,
  d0_.is_exclusive AS is_exclusive_13,
  d0_.type_abonnement_id AS type_abonnement_id_14
FROM
  diagnostic d0_

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.description AS description_2, d0_.image AS image_3, d0_.date_create AS date_create_4, d0_.date_publication AS date_publication_5, d0_.statut AS statut_6, d0_.updated_at AS updated_at_7, d0_.introduction AS introduction_8, d0_.tarif AS tarif_9, d0_.thumbnail AS thumbnail_10, d0_.slug AS slug_11, d0_.is_home AS is_home_12, d0_.is_exclusive AS is_exclusive_13, d0_.type_abonnement_id AS type_abonnement_id_14 FROM diagnostic d0_;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1
FROM
  cabinet c0_

SELECT c0_.id AS id_0, c0_.nom AS nom_1 FROM cabinet c0_;