Symfony Profiler

SELECT
  r0_.nom_recherche AS nom_recherche_0,
  r0_.nb_resultats AS nb_resultats_1,
  r0_.pointeur AS pointeur_2
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r0_
WHERE
  (
    r0_.id_service_prestataire IS NULL
    OR r0_.id_service_prestataire = ''
  )
  AND r0_.type IN (?, ?, ?)
ORDER BY
  r0_.nb_resultats DESC

SELECT r0_.nom_recherche AS nom_recherche_0, r0_.nb_resultats AS nb_resultats_1, r0_.pointeur AS pointeur_2 FROM fusacq_dbo.recherche_mots_cles_prestataire r0_ WHERE (r0_.id_service_prestataire IS NULL OR r0_.id_service_prestataire = '') AND r0_.type IN ('societe', 'secteur', 'service') ORDER BY r0_.nb_resultats DESC;

SELECT
  r0_.nom_recherche AS nom_recherche_0,
  r0_.nb_resultats AS nb_resultats_1,
  r0_.pointeur AS pointeur_2
FROM
  fusacq_dbo.recherche_mots_cles_prestataire r0_
WHERE
  (
    r0_.id_service_prestataire IS NULL
    OR r0_.id_service_prestataire = ''
  )
  AND r0_.type IN (?, ?, ?)
ORDER BY
  r0_.nb_resultats DESC

SELECT r0_.nom_recherche AS nom_recherche_0, r0_.nb_resultats AS nb_resultats_1, r0_.pointeur AS pointeur_2 FROM fusacq_dbo.recherche_mots_cles_prestataire r0_ WHERE (r0_.id_service_prestataire IS NULL OR r0_.id_service_prestataire = '') AND r0_.type IN ('societe', 'secteur', 'service') ORDER BY r0_.nb_resultats DESC;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

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 = '0603aa49d83de0bb73fe8ea44d222098';

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

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  DISTINCT (s0_.id_service_prestataire) AS sclr_0,
  s0_.id_localisation_prestataire AS id_localisation_prestataire_1,
  s0_.titre_service AS titre_service_2,
  s0_.nom_commercial_societe AS nom_commercial_societe_3,
  s0_.date_mise_en_ligne AS date_mise_en_ligne_4,
  s0_.resume_service AS resume_service_5,
  s0_.url_site_web AS url_site_web_6,
  s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7,
  s0_.utiliser_artviper AS utiliser_artviper_8,
  c1_.code_postal AS code_postal_9,
  c1_.ville AS ville_10,
  c1_.nom_contact1 AS nom_contact1_11
FROM
  fusacq_dbo.services_prestataire s0_
  LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (
    s0_.id_secteur_new = s2_.pointe_vers
  )
  LEFT JOIN localisations_prestataire l3_ ON (
    s0_.id_localisation_prestataire = l3_.id_localisation_prestataire
  )
  LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (
    s0_.id_service_prestataire = c1_.id_service_prestataire
  )
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'
ORDER BY
  s0_.date_mise_en_ligne DESC,
  s0_.id_service_prestataire DESC
LIMIT
  3

SELECT DISTINCT (s0_.id_service_prestataire) AS sclr_0, s0_.id_localisation_prestataire AS id_localisation_prestataire_1, s0_.titre_service AS titre_service_2, s0_.nom_commercial_societe AS nom_commercial_societe_3, s0_.date_mise_en_ligne AS date_mise_en_ligne_4, s0_.resume_service AS resume_service_5, s0_.url_site_web AS url_site_web_6, s0_.src_image_si_artviper_desactive AS src_image_si_artviper_desactive_7, s0_.utiliser_artviper AS utiliser_artviper_8, c1_.code_postal AS code_postal_9, c1_.ville AS ville_10, c1_.nom_contact1 AS nom_contact1_11 FROM fusacq_dbo.services_prestataire s0_ LEFT JOIN fusacq_dbo.secteurs_activite_prestataire_new s2_ ON (s0_.id_secteur_new = s2_.pointe_vers) LEFT JOIN localisations_prestataire l3_ ON (s0_.id_localisation_prestataire = l3_.id_localisation_prestataire) LEFT JOIN fusacq_dbo.coordonnees_service_prestataire c1_ ON (s0_.id_service_prestataire = c1_.id_service_prestataire) WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%' ORDER BY s0_.date_mise_en_ligne DESC, s0_.id_service_prestataire DESC LIMIT 3;

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

SELECT
  s0_.id_service_prestataire AS id_service_prestataire_0
FROM
  fusacq_dbo.services_prestataire s0_
WHERE
  s0_.statut LIKE 'publique%'
  AND s0_.visibilite LIKE '%prestataire%'

SELECT s0_.id_service_prestataire AS id_service_prestataire_0 FROM fusacq_dbo.services_prestataire s0_ WHERE s0_.statut LIKE 'publique%' AND s0_.visibilite LIKE '%prestataire%';

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 = '20263c471f734ef9e12aae633bdff930';

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 = '29629585233df88596e5fc2c766bde65';

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 = '404d74afddb34059900ffd8b14ba8e56';

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 = '74017a1c22a4b822683299b25e31b6f0';

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 = '44b1404e6470eee0cccdb434c139bbeb';