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 = '4fcc57f6dd7da24d88812d47b3d99cd1';

SELECT
  b0_.id_question AS id_question_0,
  b0_.question AS question_1,
  u1_.nom_utilisateur AS nom_utilisateur_2,
  u1_.prenom_utilisateur AS prenom_utilisateur_3,
  u1_.societe_utilisateur AS societe_utilisateur_4
FROM
  fusacq_dbo.base_connaissance b0_
  INNER JOIN fusacq_dbo.utilisateurs u1_ ON (
    b0_.id_expert = u1_.id_utilisateur
  )
WHERE
  (
    b0_.mode = 'publique'
    AND b0_.visibilite_autres_sites LIKE '%fusacq%'
    AND b0_.date_publication < 20260418
  )
ORDER BY
  GREATEST(
    COALESCE(b0_.date_publication, 0),
    COALESCE(b0_.date_republication, 0)
  ) DESC

SELECT b0_.id_question AS id_question_0, b0_.question AS question_1, u1_.nom_utilisateur AS nom_utilisateur_2, u1_.prenom_utilisateur AS prenom_utilisateur_3, u1_.societe_utilisateur AS societe_utilisateur_4 FROM fusacq_dbo.base_connaissance b0_ INNER JOIN fusacq_dbo.utilisateurs u1_ ON (b0_.id_expert = u1_.id_utilisateur) WHERE (b0_.mode = 'publique' AND b0_.visibilite_autres_sites LIKE '%fusacq%' AND b0_.date_publication < 20260418) ORDER BY GREATEST(COALESCE(b0_.date_publication, 0), COALESCE(b0_.date_republication, 0)) DESC;