Symfony Profiler

SELECT
  t0_.id_translation AS id_translation_0,
  t0_.md5_fr AS md5_fr_1,
  t0_.texte_fr AS texte_fr_2,
  t0_.contexte_fr AS contexte_fr_3,
  t0_.md5_en AS md5_en_4,
  t0_.texte_en AS texte_en_5,
  t0_.contexte_en AS contexte_en_6,
  t0_.md5_fr_ca AS md5_fr_ca_7,
  t0_.texte_fr_ca AS texte_fr_ca_8,
  t0_.contexte_fr_ca AS contexte_fr_ca_9,
  t0_.md5_generique AS md5_generique_10,
  t0_.texte_generique AS texte_generique_11,
  t0_.contexte_generique AS contexte_generique_12,
  t0_.md5_es AS md5_es_13,
  t0_.texte_es AS texte_es_14,
  t0_.contexte_es AS contexte_es_15,
  t0_.md5_de AS md5_de_16,
  t0_.texte_de AS texte_de_17,
  t0_.contexte_de AS contexte_de_18,
  t0_.md5_nl AS md5_nl_19,
  t0_.texte_nl AS texte_nl_20,
  t0_.contexte_nl AS contexte_nl_21,
  t0_.md5_it AS md5_it_22,
  t0_.texte_it AS texte_it_23,
  t0_.contexte_it AS contexte_it_24,
  t0_.etat_en AS etat_en_25,
  t0_.etat_es AS etat_es_26,
  t0_.etat_de AS etat_de_27,
  t0_.etat_nl AS etat_nl_28,
  t0_.etat_it AS etat_it_29,
  t0_.etat_fr_ca AS etat_fr_ca_30,
  t0_.traduit_deepl AS traduit_deepl_31,
  t0_.created_at AS created_at_32,
  t0_.page_url AS page_url_33,
  t0_.etat_fr_ch AS etat_fr_ch_34,
  t0_.md5_fr_ch AS md5_fr_ch_35,
  t0_.texte_fr_ch AS texte_fr_ch_36,
  t0_.contexte_fr_ch AS contexte_fr_ch_37
FROM
  partage_dbo.translation t1_,
  partage_dbo.translation t0_
WHERE
  t0_.md5_generique = ?

SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = 'f552b24e59b5f1b0d675ff777de40949';

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 20

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

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 (588, 602, 586, 583, 585, 570, 595, 568, 584, 567) 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;