Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.refannonce AS refannonce_1,
  e0_.identifiant_technique AS identifiant_technique_2,
  e0_.numeromandat AS numeromandat_3,
  e0_.mandat_at AS mandat_at_4,
  e0_.statut AS statut_5,
  e0_.statut_name AS statut_name_6,
  e0_.slug AS slug_7,
  e0_.typebien AS typebien_8,
  e0_.si_mandatexclusif AS si_mandatexclusif_9,
  e0_.libelle AS libelle_10,
  e0_.descriptif AS descriptif_11,
  e0_.prix AS prix_12,
  e0_.surface AS surface_13,
  e0_.surf_terrain AS surf_terrain_14,
  e0_.nbpieces AS nbpieces_15,
  e0_.nbchambres AS nbchambres_16,
  e0_.latitude AS latitude_17,
  e0_.longitude AS longitude_18,
  e0_.orientation AS orientation_19,
  e0_.photos AS photos_20,
  e0_.features AS features_21,
  e0_.icones AS icones_22,
  e0_.is_new_checked AS is_new_checked_23,
  e0_.is_delete_checked AS is_delete_checked_24,
  e0_.import_type AS import_type_25,
  e0_.ca AS ca_26,
  e0_.ebe AS ebe_27,
  e0_.created_at AS created_at_28,
  e0_.updated_at AS updated_at_29,
  e0_.deleted_at AS deleted_at_30,
  a1_.id AS id_31,
  a1_.code_negociateur AS code_negociateur_32,
  a1_.slug AS slug_33,
  a1_.prenom AS prenom_34,
  a1_.nom AS nom_35,
  a1_.is_actif AS is_actif_36,
  a1_.siret AS siret_37,
  a1_.raison_sociale AS raison_sociale_38,
  a1_.cos_id AS cos_id_39,
  a1_.photo AS photo_40,
  a1_.bio AS bio_41,
  a1_.secteur AS secteur_42,
  a1_.cp AS cp_43,
  a1_.latitude AS latitude_44,
  a1_.longitude AS longitude_45,
  a1_.email AS email_46,
  a1_.telephone AS telephone_47,
  a1_.whatsapp AS whatsapp_48,
  a1_.facebook AS facebook_49,
  a1_.twitter AS twitter_50,
  a1_.linkedin AS linkedin_51,
  a1_.instagram AS instagram_52,
  a1_.video AS video_53,
  a1_.comment AS comment_54,
  a1_.rating AS rating_55,
  a1_.fonction AS fonction_56,
  a1_.created_at AS created_at_57,
  a1_.updated_at AS updated_at_58,
  a1_.deleted_at AS deleted_at_59,
  e0_.agent_id AS agent_id_60,
  e0_.sous_type_id AS sous_type_id_61
FROM
  estate e0_
  INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
  AND (a1_.deleted_at IS NULL)
WHERE
  (
    e0_.statut_name NOT IN ('under_contract', 'sold')
    AND a1_.is_actif = 1
    AND a1_.rating > 0
    AND e0_.typebien NOT IN (?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.numeromandat DESC

SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59, e0_.agent_id AS agent_id_60, e0_.sous_type_id AS sous_type_id_61 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract', 'sold') AND a1_.is_actif = 1 AND a1_.rating > 0 AND e0_.typebien NOT IN ('boutique', 'entreprise', 'bureaux', 'entrepot', 'local')) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 121 ORDER BY t0.date DESC;

SELECT
  e0_.id AS id_0,
  e0_.refannonce AS refannonce_1,
  e0_.identifiant_technique AS identifiant_technique_2,
  e0_.numeromandat AS numeromandat_3,
  e0_.mandat_at AS mandat_at_4,
  e0_.statut AS statut_5,
  e0_.statut_name AS statut_name_6,
  e0_.slug AS slug_7,
  e0_.typebien AS typebien_8,
  e0_.si_mandatexclusif AS si_mandatexclusif_9,
  e0_.libelle AS libelle_10,
  e0_.descriptif AS descriptif_11,
  e0_.prix AS prix_12,
  e0_.surface AS surface_13,
  e0_.surf_terrain AS surf_terrain_14,
  e0_.nbpieces AS nbpieces_15,
  e0_.nbchambres AS nbchambres_16,
  e0_.latitude AS latitude_17,
  e0_.longitude AS longitude_18,
  e0_.orientation AS orientation_19,
  e0_.photos AS photos_20,
  e0_.features AS features_21,
  e0_.icones AS icones_22,
  e0_.is_new_checked AS is_new_checked_23,
  e0_.is_delete_checked AS is_delete_checked_24,
  e0_.import_type AS import_type_25,
  e0_.ca AS ca_26,
  e0_.ebe AS ebe_27,
  e0_.created_at AS created_at_28,
  e0_.updated_at AS updated_at_29,
  e0_.deleted_at AS deleted_at_30,
  a1_.id AS id_31,
  a1_.code_negociateur AS code_negociateur_32,
  a1_.slug AS slug_33,
  a1_.prenom AS prenom_34,
  a1_.nom AS nom_35,
  a1_.is_actif AS is_actif_36,
  a1_.siret AS siret_37,
  a1_.raison_sociale AS raison_sociale_38,
  a1_.cos_id AS cos_id_39,
  a1_.photo AS photo_40,
  a1_.bio AS bio_41,
  a1_.secteur AS secteur_42,
  a1_.cp AS cp_43,
  a1_.latitude AS latitude_44,
  a1_.longitude AS longitude_45,
  a1_.email AS email_46,
  a1_.telephone AS telephone_47,
  a1_.whatsapp AS whatsapp_48,
  a1_.facebook AS facebook_49,
  a1_.twitter AS twitter_50,
  a1_.linkedin AS linkedin_51,
  a1_.instagram AS instagram_52,
  a1_.video AS video_53,
  a1_.comment AS comment_54,
  a1_.rating AS rating_55,
  a1_.fonction AS fonction_56,
  a1_.created_at AS created_at_57,
  a1_.updated_at AS updated_at_58,
  a1_.deleted_at AS deleted_at_59,
  e0_.agent_id AS agent_id_60,
  e0_.sous_type_id AS sous_type_id_61
FROM
  estate e0_
  INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
  AND (a1_.deleted_at IS NULL)
WHERE
  (
    e0_.statut_name = 'sold'
    AND a1_.is_actif = 1
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.numeromandat DESC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59, e0_.agent_id AS agent_id_60, e0_.sous_type_id AS sous_type_id_61 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name = 'sold' AND a1_.is_actif = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC LIMIT 4;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.value AS value_3,
  c0_.is_editable AS is_editable_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  config c0_
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.value AS value_3, c0_.is_editable AS is_editable_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM config c0_ WHERE c0_.slug = 'rating_os';

SELECT
  r0_.id AS id_0,
  r0_.survey_id AS survey_id_1,
  r0_.author AS author_2,
  r0_.subject AS subject_3,
  r0_.comment AS comment_4,
  r0_.date AS date_5,
  r0_.collaborator_id AS collaborator_id_6,
  r0_.rating AS rating_7,
  r0_.agent_id AS agent_id_8
FROM
  review r0_
WHERE
  r0_.rating >= ?
ORDER BY
  r0_.date DESC
LIMIT
  20

SELECT r0_.id AS id_0, r0_.survey_id AS survey_id_1, r0_.author AS author_2, r0_.subject AS subject_3, r0_.comment AS comment_4, r0_.date AS date_5, r0_.collaborator_id AS collaborator_id_6, r0_.rating AS rating_7, r0_.agent_id AS agent_id_8 FROM review r0_ WHERE r0_.rating >= 80 ORDER BY r0_.date DESC LIMIT 20;