Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.titre_principal AS titre_principal_1,
  a0_.slug AS slug_2,
  a0_.contenu_principal AS contenu_principal_3,
  a0_.code_image_principale AS code_image_principale_4,
  a0_.code_fichier AS code_fichier_5,
  a0_.date_ajout AS date_ajout_6,
  a0_.date_modif AS date_modif_7,
  a0_.date_publication AS date_publication_8,
  a0_.date_event AS date_event_9,
  a0_.visible_accueil AS visible_accueil_10,
  a0_.type_principal AS type_principal_11,
  a0_.type_secondaire AS type_secondaire_12,
  a0_.sous_titre_principal AS sous_titre_principal_13,
  a0_.lien_bouton_action1 AS lien_bouton_action1_14,
  a0_.lien_bouton_action2 AS lien_bouton_action2_15,
  a0_.lien_bouton_action3 AS lien_bouton_action3_16,
  a0_.titre_bouton_action1 AS titre_bouton_action1_17,
  a0_.titre_bouton_action2 AS titre_bouton_action2_18,
  a0_.titre_bouton_action3 AS titre_bouton_action3_19,
  a0_.description_detail_contact AS description_detail_contact_20,
  a0_.description_detail_entreprise AS description_detail_entreprise_21,
  a0_.autre_document_code_fichier AS autre_document_code_fichier_22,
  u1_.id AS id_23,
  u1_.email AS email_24,
  u1_.roles AS roles_25,
  u1_.password AS password_26,
  u1_.is_verified AS is_verified_27,
  u1_.nom AS nom_28,
  u1_.prenom AS prenom_29,
  u1_.date_ajout AS date_ajout_30,
  u1_.date_modif AS date_modif_31,
  u1_.photo_code_fichier AS photo_code_fichier_32,
  u1_.tel AS tel_33,
  c2_.id AS id_34,
  c2_.nom AS nom_35,
  c2_.date_ajout AS date_ajout_36,
  a0_.auteur_id AS auteur_id_37,
  a0_.categorie_id AS categorie_id_38,
  c2_.parent_id AS parent_id_39
FROM
  actualite_evenement a0_
  LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id
  LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id
WHERE
  a0_.date_event <= ?
  AND a0_.type_principal = ?
ORDER BY
  a0_.date_event DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.titre_principal AS titre_principal_1, a0_.slug AS slug_2, a0_.contenu_principal AS contenu_principal_3, a0_.code_image_principale AS code_image_principale_4, a0_.code_fichier AS code_fichier_5, a0_.date_ajout AS date_ajout_6, a0_.date_modif AS date_modif_7, a0_.date_publication AS date_publication_8, a0_.date_event AS date_event_9, a0_.visible_accueil AS visible_accueil_10, a0_.type_principal AS type_principal_11, a0_.type_secondaire AS type_secondaire_12, a0_.sous_titre_principal AS sous_titre_principal_13, a0_.lien_bouton_action1 AS lien_bouton_action1_14, a0_.lien_bouton_action2 AS lien_bouton_action2_15, a0_.lien_bouton_action3 AS lien_bouton_action3_16, a0_.titre_bouton_action1 AS titre_bouton_action1_17, a0_.titre_bouton_action2 AS titre_bouton_action2_18, a0_.titre_bouton_action3 AS titre_bouton_action3_19, a0_.description_detail_contact AS description_detail_contact_20, a0_.description_detail_entreprise AS description_detail_entreprise_21, a0_.autre_document_code_fichier AS autre_document_code_fichier_22, u1_.id AS id_23, u1_.email AS email_24, u1_.roles AS roles_25, u1_.password AS password_26, u1_.is_verified AS is_verified_27, u1_.nom AS nom_28, u1_.prenom AS prenom_29, u1_.date_ajout AS date_ajout_30, u1_.date_modif AS date_modif_31, u1_.photo_code_fichier AS photo_code_fichier_32, u1_.tel AS tel_33, c2_.id AS id_34, c2_.nom AS nom_35, c2_.date_ajout AS date_ajout_36, a0_.auteur_id AS auteur_id_37, a0_.categorie_id AS categorie_id_38, c2_.parent_id AS parent_id_39 FROM actualite_evenement a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE a0_.date_event <= '2026-03-27 15:07:11' AND a0_.type_principal = 'evenement' ORDER BY a0_.date_event DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.titre_principal AS titre_principal_1,
  a0_.slug AS slug_2,
  a0_.contenu_principal AS contenu_principal_3,
  a0_.code_image_principale AS code_image_principale_4,
  a0_.code_fichier AS code_fichier_5,
  a0_.date_ajout AS date_ajout_6,
  a0_.date_modif AS date_modif_7,
  a0_.date_publication AS date_publication_8,
  a0_.date_event AS date_event_9,
  a0_.visible_accueil AS visible_accueil_10,
  a0_.type_principal AS type_principal_11,
  a0_.type_secondaire AS type_secondaire_12,
  a0_.sous_titre_principal AS sous_titre_principal_13,
  a0_.lien_bouton_action1 AS lien_bouton_action1_14,
  a0_.lien_bouton_action2 AS lien_bouton_action2_15,
  a0_.lien_bouton_action3 AS lien_bouton_action3_16,
  a0_.titre_bouton_action1 AS titre_bouton_action1_17,
  a0_.titre_bouton_action2 AS titre_bouton_action2_18,
  a0_.titre_bouton_action3 AS titre_bouton_action3_19,
  a0_.description_detail_contact AS description_detail_contact_20,
  a0_.description_detail_entreprise AS description_detail_entreprise_21,
  a0_.autre_document_code_fichier AS autre_document_code_fichier_22,
  u1_.id AS id_23,
  u1_.email AS email_24,
  u1_.roles AS roles_25,
  u1_.password AS password_26,
  u1_.is_verified AS is_verified_27,
  u1_.nom AS nom_28,
  u1_.prenom AS prenom_29,
  u1_.date_ajout AS date_ajout_30,
  u1_.date_modif AS date_modif_31,
  u1_.photo_code_fichier AS photo_code_fichier_32,
  u1_.tel AS tel_33,
  c2_.id AS id_34,
  c2_.nom AS nom_35,
  c2_.date_ajout AS date_ajout_36,
  a0_.auteur_id AS auteur_id_37,
  a0_.categorie_id AS categorie_id_38,
  c2_.parent_id AS parent_id_39
FROM
  actualite_evenement a0_
  LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id
  LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id
WHERE
  (
    a0_.date_publication <= ?
    AND a0_.visible_accueil = ?
    AND a0_.type_principal = ?
  )
  OR a0_.type_secondaire = ?
ORDER BY
  a0_.date_publication DESC

SELECT a0_.id AS id_0, a0_.titre_principal AS titre_principal_1, a0_.slug AS slug_2, a0_.contenu_principal AS contenu_principal_3, a0_.code_image_principale AS code_image_principale_4, a0_.code_fichier AS code_fichier_5, a0_.date_ajout AS date_ajout_6, a0_.date_modif AS date_modif_7, a0_.date_publication AS date_publication_8, a0_.date_event AS date_event_9, a0_.visible_accueil AS visible_accueil_10, a0_.type_principal AS type_principal_11, a0_.type_secondaire AS type_secondaire_12, a0_.sous_titre_principal AS sous_titre_principal_13, a0_.lien_bouton_action1 AS lien_bouton_action1_14, a0_.lien_bouton_action2 AS lien_bouton_action2_15, a0_.lien_bouton_action3 AS lien_bouton_action3_16, a0_.titre_bouton_action1 AS titre_bouton_action1_17, a0_.titre_bouton_action2 AS titre_bouton_action2_18, a0_.titre_bouton_action3 AS titre_bouton_action3_19, a0_.description_detail_contact AS description_detail_contact_20, a0_.description_detail_entreprise AS description_detail_entreprise_21, a0_.autre_document_code_fichier AS autre_document_code_fichier_22, u1_.id AS id_23, u1_.email AS email_24, u1_.roles AS roles_25, u1_.password AS password_26, u1_.is_verified AS is_verified_27, u1_.nom AS nom_28, u1_.prenom AS prenom_29, u1_.date_ajout AS date_ajout_30, u1_.date_modif AS date_modif_31, u1_.photo_code_fichier AS photo_code_fichier_32, u1_.tel AS tel_33, c2_.id AS id_34, c2_.nom AS nom_35, c2_.date_ajout AS date_ajout_36, a0_.auteur_id AS auteur_id_37, a0_.categorie_id AS categorie_id_38, c2_.parent_id AS parent_id_39 FROM actualite_evenement a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE (a0_.date_publication <= '2026-03-27 15:07:11' AND a0_.visible_accueil = 1 AND a0_.type_principal = 'actualite') OR a0_.type_secondaire = 'actualite' ORDER BY a0_.date_publication DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_fichier AS code_fichier_3,
  t0.lien_site_web AS lien_site_web_4,
  t0.lien_facebook AS lien_facebook_5,
  t0.lien_linkedin AS lien_linkedin_6,
  t0.lien_twitter AS lien_twitter_7,
  t0.position AS position_8
FROM
  partenaire t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_fichier AS code_fichier_3, t0.lien_site_web AS lien_site_web_4, t0.lien_facebook AS lien_facebook_5, t0.lien_linkedin AS lien_linkedin_6, t0.lien_twitter AS lien_twitter_7, t0.position AS position_8 FROM partenaire t0 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'accueil' LIMIT 1;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.titre_principal AS titre_principal_1,
  s0_.sous_titre_principal AS sous_titre_principal_2,
  s0_.contenu_principal AS contenu_principal_3,
  s0_.code_image_principale AS code_image_principale_4,
  s0_.position_page AS position_page_5,
  s0_.code_fichier AS code_fichier_6,
  s0_.position_template AS position_template_7,
  s0_.background_image AS background_image_8,
  s0_.background_color AS background_color_9,
  s0_.lien_bouton_action1 AS lien_bouton_action1_10,
  s0_.lien_bouton_action2 AS lien_bouton_action2_11,
  s0_.lien_bouton_action3 AS lien_bouton_action3_12,
  s0_.titre_bouton_action1 AS titre_bouton_action1_13,
  s0_.titre_bouton_action2 AS titre_bouton_action2_14,
  s0_.titre_bouton_action3 AS titre_bouton_action3_15,
  s0_.reference AS reference_16,
  s0_.autre_document_code_fichier AS autre_document_code_fichier_17,
  s0_.parent_id AS parent_id_18,
  s0_.menu_id AS menu_id_19,
  s0_.actualite_evenement_id AS actualite_evenement_id_20
FROM
  section s0_
  INNER JOIN section s1_ ON s0_.id = s1_.parent_id
WHERE
  s0_.parent_id IS NULL
  AND s0_.menu_id = ?
ORDER BY
  s0_.position_page ASC

SELECT DISTINCT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ INNER JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.menu_id = 1 ORDER BY s0_.position_page ASC;

SELECT
  s0_.id AS id_0,
  s0_.titre_principal AS titre_principal_1,
  s0_.sous_titre_principal AS sous_titre_principal_2,
  s0_.contenu_principal AS contenu_principal_3,
  s0_.code_image_principale AS code_image_principale_4,
  s0_.position_page AS position_page_5,
  s0_.code_fichier AS code_fichier_6,
  s0_.position_template AS position_template_7,
  s0_.background_image AS background_image_8,
  s0_.background_color AS background_color_9,
  s0_.lien_bouton_action1 AS lien_bouton_action1_10,
  s0_.lien_bouton_action2 AS lien_bouton_action2_11,
  s0_.lien_bouton_action3 AS lien_bouton_action3_12,
  s0_.titre_bouton_action1 AS titre_bouton_action1_13,
  s0_.titre_bouton_action2 AS titre_bouton_action2_14,
  s0_.titre_bouton_action3 AS titre_bouton_action3_15,
  s0_.reference AS reference_16,
  s0_.autre_document_code_fichier AS autre_document_code_fichier_17,
  s0_.parent_id AS parent_id_18,
  s0_.menu_id AS menu_id_19,
  s0_.actualite_evenement_id AS actualite_evenement_id_20
FROM
  section s0_
  LEFT JOIN section s1_ ON s0_.id = s1_.parent_id
WHERE
  s0_.parent_id IS NULL
  AND s1_.id IS NULL
  AND s0_.menu_id = ?
ORDER BY
  s0_.position_page ASC

SELECT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ LEFT JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s1_.id IS NULL AND s0_.menu_id = 1 ORDER BY s0_.position_page ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'accueil' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'opportunites' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'solutions' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'evenements' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'a-propos' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.background_color AS background_color_4,
  t0.font_size AS font_size_5,
  t0.date AS date_6,
  t0.code AS code_7,
  t0.parent_id AS parent_id_8
FROM
  menu t0
WHERE
  t0.code = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = 'contact' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.code_fichier AS code_fichier_4,
  t0.position_contenu AS position_contenu_5,
  t0.sous_titre AS sous_titre_6,
  t0.lien_bouton_action1 AS lien_bouton_action1_7,
  t0.lien_bouton_action2 AS lien_bouton_action2_8,
  t0.lien_bouton_action3 AS lien_bouton_action3_9,
  t0.titre_bouton_action1 AS titre_bouton_action1_10,
  t0.titre_bouton_action2 AS titre_bouton_action2_11,
  t0.titre_bouton_action3 AS titre_bouton_action3_12,
  t0.autre_document_code_fichier AS autre_document_code_fichier_13,
  t0.section_id AS section_id_14
FROM
  disposition t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = 6;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.location AS location_5,
  t0.size AS size_6,
  t0.reference_code AS reference_code_7,
  t0.temp AS temp_8,
  t0.lien AS lien_9
FROM
  files t0
WHERE
  t0.reference_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = 'jMIRwKfmnEhq5Wme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.location AS location_5,
  t0.size AS size_6,
  t0.reference_code AS reference_code_7,
  t0.temp AS temp_8,
  t0.lien AS lien_9
FROM
  files t0
WHERE
  t0.reference_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = '23E2YdrEChDFVIgR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.location AS location_5,
  t0.size AS size_6,
  t0.reference_code AS reference_code_7,
  t0.temp AS temp_8,
  t0.lien AS lien_9
FROM
  files t0
WHERE
  t0.reference_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = 'rdcTOTvFgg2XdiSy' LIMIT 1;