Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.code_negociateur AS code_negociateur_1,
  a0_.slug AS slug_2,
  a0_.prenom AS prenom_3,
  a0_.nom AS nom_4,
  a0_.is_actif AS is_actif_5,
  a0_.siret AS siret_6,
  a0_.raison_sociale AS raison_sociale_7,
  a0_.cos_id AS cos_id_8,
  a0_.photo AS photo_9,
  a0_.bio AS bio_10,
  a0_.secteur AS secteur_11,
  a0_.cp AS cp_12,
  a0_.latitude AS latitude_13,
  a0_.longitude AS longitude_14,
  a0_.email AS email_15,
  a0_.telephone AS telephone_16,
  a0_.whatsapp AS whatsapp_17,
  a0_.facebook AS facebook_18,
  a0_.twitter AS twitter_19,
  a0_.linkedin AS linkedin_20,
  a0_.instagram AS instagram_21,
  a0_.video AS video_22,
  a0_.comment AS comment_23,
  a0_.rating AS rating_24,
  a0_.fonction AS fonction_25,
  a0_.created_at AS created_at_26,
  a0_.updated_at AS updated_at_27,
  a0_.deleted_at AS deleted_at_28
FROM
  agent a0_
  INNER JOIN estate e1_ ON a0_.id = e1_.agent_id
  AND (e1_.deleted_at IS NULL)
WHERE
  (
    a0_.latitude IS NOT NULL
    AND a0_.longitude IS NOT NULL
    AND a0_.is_actif = 1
  )
  AND (a0_.deleted_at IS NULL)
GROUP BY
  a0_.id
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.code_negociateur AS code_negociateur_1, a0_.slug AS slug_2, a0_.prenom AS prenom_3, a0_.nom AS nom_4, a0_.is_actif AS is_actif_5, a0_.siret AS siret_6, a0_.raison_sociale AS raison_sociale_7, a0_.cos_id AS cos_id_8, a0_.photo AS photo_9, a0_.bio AS bio_10, a0_.secteur AS secteur_11, a0_.cp AS cp_12, a0_.latitude AS latitude_13, a0_.longitude AS longitude_14, a0_.email AS email_15, a0_.telephone AS telephone_16, a0_.whatsapp AS whatsapp_17, a0_.facebook AS facebook_18, a0_.twitter AS twitter_19, a0_.linkedin AS linkedin_20, a0_.instagram AS instagram_21, a0_.video AS video_22, a0_.comment AS comment_23, a0_.rating AS rating_24, a0_.fonction AS fonction_25, a0_.created_at AS created_at_26, a0_.updated_at AS updated_at_27, a0_.deleted_at AS deleted_at_28 FROM agent a0_ INNER JOIN estate e1_ ON a0_.id = e1_.agent_id AND (e1_.deleted_at IS NULL) WHERE (a0_.latitude IS NOT NULL AND a0_.longitude IS NOT NULL AND a0_.is_actif = 1) AND (a0_.deleted_at IS NULL) GROUP BY a0_.id ORDER BY a0_.nom ASC;

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 = 10 ORDER BY t0.date DESC;

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';