Symfony Profiler

SELECT
  DISTINCT v0_.id_valorisation AS id_valorisation_0,
  v0_.date_mois_operation AS date_mois_operation_1
FROM
  valorisations v0_
WHERE
  v0_.mode = 'publique'
ORDER BY
  v0_.date_mois_operation DESC
LIMIT
  10 OFFSET 40

SELECT DISTINCT v0_.id_valorisation AS id_valorisation_0, v0_.date_mois_operation AS date_mois_operation_1 FROM valorisations v0_ WHERE v0_.mode = 'publique' ORDER BY v0_.date_mois_operation DESC LIMIT 10 OFFSET 40;

SELECT
  v0_.id_valorisation AS id_valorisation_0,
  v0_.titre_valorisation AS titre_valorisation_1,
  v0_.description_activite AS description_activite_2,
  v0_.ca_n AS ca_n_3,
  v0_.type_cedant AS type_cedant_4,
  v0_.description_publique AS description_publique_5,
  v0_.date_mois_operation AS date_mois_operation_6,
  v0_.societe_difficulte AS societe_difficulte_7,
  v0_.type_rachat AS type_rachat_8,
  v0_.type_acquereur AS type_acquereur_9
FROM
  valorisations v0_
WHERE
  v0_.mode = 'publique'
  AND v0_.id_valorisation IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  v0_.date_mois_operation DESC

SELECT v0_.id_valorisation AS id_valorisation_0, v0_.titre_valorisation AS titre_valorisation_1, v0_.description_activite AS description_activite_2, v0_.ca_n AS ca_n_3, v0_.type_cedant AS type_cedant_4, v0_.description_publique AS description_publique_5, v0_.date_mois_operation AS date_mois_operation_6, v0_.societe_difficulte AS societe_difficulte_7, v0_.type_rachat AS type_rachat_8, v0_.type_acquereur AS type_acquereur_9 FROM valorisations v0_ WHERE v0_.mode = 'publique' AND v0_.id_valorisation IN (544, 573, 537, 542, 535, 538, 536, 559, 541, 531) ORDER BY v0_.date_mois_operation DESC;

SELECT
  COUNT(DISTINCT v0_.id_valorisation) AS sclr_0
FROM
  valorisations v0_
WHERE
  v0_.mode = 'publique'

SELECT COUNT(DISTINCT v0_.id_valorisation) AS sclr_0 FROM valorisations v0_ WHERE v0_.mode = 'publique';

SELECT
  s0_.id_secteur_activite AS id_secteur_activite_0,
  s0_.nom_secteur_activite AS nom_secteur_activite_1
FROM
  fusacq_dbo.secteurs_activite s0_
WHERE
  s0_.id_secteur_activite_pere = 0
  AND (
    s0_.obsolete <> ?
    OR s0_.obsolete IS NULL
  )
ORDER BY
  s0_.nom_secteur_activite ASC

SELECT s0_.id_secteur_activite AS id_secteur_activite_0, s0_.nom_secteur_activite AS nom_secteur_activite_1 FROM fusacq_dbo.secteurs_activite s0_ WHERE s0_.id_secteur_activite_pere = 0 AND (s0_.obsolete <> 'oui' OR s0_.obsolete IS NULL) ORDER BY s0_.nom_secteur_activite ASC;