Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_xx_jour' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_partir_decouverte' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_partir_decouverte_baseline' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_maisaufait_titre' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_maisaufait_description' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_maisaufait_lien' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_tirage_sort' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_confirmation_inscription_newsletter' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'homepage_confirmation_inscription_tirage_sort' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.enabled AS enabled_6,
  t0.sortable AS sortable_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  categorie t0
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.enabled AS enabled_6, t0.sortable AS sortable_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM categorie t0 ORDER BY t0.libelle ASC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.homepage_baseline AS homepage_baseline_4,
  t0.homepage_filename AS homepage_filename_5,
  t0.title AS title_6,
  t0.meta_description AS meta_description_7,
  t0.infos_pratiques_adresse AS infos_pratiques_adresse_8,
  t0.infos_pratiques_mail AS infos_pratiques_mail_9,
  t0.infos_pratiques_telephone AS infos_pratiques_telephone_10,
  t0.url_site_internet AS url_site_internet_11,
  t0.url_billetterie AS url_billetterie_12,
  t0.url_instagram AS url_instagram_13,
  t0.url_facebook AS url_facebook_14,
  t0.url_youtube AS url_youtube_15,
  t0.calendrier_horaires AS calendrier_horaires_16,
  t0.infos_pratique_logo_filename AS infos_pratique_logo_filename_17,
  t0.infos_pratiques_map_filename AS infos_pratiques_map_filename_18,
  t0.header_image_filename AS header_image_filename_19,
  t0.texte1 AS texte1_20,
  t0.slotmachine_filename AS slotmachine_filename_21,
  t0.autonome_creation_lot AS autonome_creation_lot_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24,
  t0.enabled AS enabled_25,
  t0.sortable AS sortable_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28
FROM
  fiche_partenaire t0
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.homepage_baseline AS homepage_baseline_4, t0.homepage_filename AS homepage_filename_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.infos_pratiques_adresse AS infos_pratiques_adresse_8, t0.infos_pratiques_mail AS infos_pratiques_mail_9, t0.infos_pratiques_telephone AS infos_pratiques_telephone_10, t0.url_site_internet AS url_site_internet_11, t0.url_billetterie AS url_billetterie_12, t0.url_instagram AS url_instagram_13, t0.url_facebook AS url_facebook_14, t0.url_youtube AS url_youtube_15, t0.calendrier_horaires AS calendrier_horaires_16, t0.infos_pratique_logo_filename AS infos_pratique_logo_filename_17, t0.infos_pratiques_map_filename AS infos_pratiques_map_filename_18, t0.header_image_filename AS header_image_filename_19, t0.texte1 AS texte1_20, t0.slotmachine_filename AS slotmachine_filename_21, t0.autonome_creation_lot AS autonome_creation_lot_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24, t0.enabled AS enabled_25, t0.sortable AS sortable_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28 FROM fiche_partenaire t0 ORDER BY t0.libelle ASC;

SELECT
  l0_.id AS id_0,
  l0_.date AS date_1,
  l0_.gagnant_nom AS gagnant_nom_2,
  l0_.gagnant_prenom AS gagnant_prenom_3,
  l0_.gagnant_mail AS gagnant_mail_4,
  l0_.gagnant_code_postal AS gagnant_code_postal_5,
  l0_.gagnant_telephone AS gagnant_telephone_6,
  l0_.date_bloquee AS date_bloquee_7,
  l0_.token AS token_8,
  l0_.utilisation_du_bon AS utilisation_du_bon_9,
  l0_.date_gagne AS date_gagne_10,
  l0_.created_by AS created_by_11,
  l0_.updated_by AS updated_by_12,
  l0_.created_at AS created_at_13,
  l0_.updated_at AS updated_at_14,
  l1_.id AS id_15,
  l1_.libelle AS libelle_16,
  l1_.illustration_filename AS illustration_filename_17,
  l1_.logo_filename AS logo_filename_18,
  l1_.voucher_description_lot AS voucher_description_lot_19,
  l1_.voucher_duree_validite AS voucher_duree_validite_20,
  l1_.voucher_condition_utilisation AS voucher_condition_utilisation_21,
  l1_.voucher_libelle AS voucher_libelle_22,
  l1_.voucher_description_site AS voucher_description_site_23,
  l1_.voucher_calendrier AS voucher_calendrier_24,
  l1_.couleur AS couleur_25,
  l1_.voucher_debut_validite AS voucher_debut_validite_26,
  l1_.voucher_fin_validite AS voucher_fin_validite_27,
  l1_.generer_qr_sur_voucher AS generer_qr_sur_voucher_28,
  l1_.created_by AS created_by_29,
  l1_.updated_by AS updated_by_30,
  l1_.created_at AS created_at_31,
  l1_.updated_at AS updated_at_32,
  f2_.id AS id_33,
  f2_.libelle AS libelle_34,
  f2_.slug AS slug_35,
  f2_.homepage_baseline AS homepage_baseline_36,
  f2_.homepage_filename AS homepage_filename_37,
  f2_.title AS title_38,
  f2_.meta_description AS meta_description_39,
  f2_.infos_pratiques_adresse AS infos_pratiques_adresse_40,
  f2_.infos_pratiques_mail AS infos_pratiques_mail_41,
  f2_.infos_pratiques_telephone AS infos_pratiques_telephone_42,
  f2_.url_site_internet AS url_site_internet_43,
  f2_.url_billetterie AS url_billetterie_44,
  f2_.url_instagram AS url_instagram_45,
  f2_.url_facebook AS url_facebook_46,
  f2_.url_youtube AS url_youtube_47,
  f2_.calendrier_horaires AS calendrier_horaires_48,
  f2_.infos_pratique_logo_filename AS infos_pratique_logo_filename_49,
  f2_.infos_pratiques_map_filename AS infos_pratiques_map_filename_50,
  f2_.header_image_filename AS header_image_filename_51,
  f2_.texte1 AS texte1_52,
  f2_.slotmachine_filename AS slotmachine_filename_53,
  f2_.autonome_creation_lot AS autonome_creation_lot_54,
  f2_.created_by AS created_by_55,
  f2_.updated_by AS updated_by_56,
  f2_.enabled AS enabled_57,
  f2_.sortable AS sortable_58,
  f2_.created_at AS created_at_59,
  f2_.updated_at AS updated_at_60,
  l0_.lot_id AS lot_id_61,
  l1_.fiche_partenaire_id AS fiche_partenaire_id_62
FROM
  lot_periode l0_
  INNER JOIN lot l1_ ON l0_.lot_id = l1_.id
  INNER JOIN fiche_partenaire f2_ ON l1_.fiche_partenaire_id = f2_.id
WHERE
  l0_.date_bloquee < ?
  AND l0_.date_gagne IS NULL
LIMIT
  1

SELECT l0_.id AS id_0, l0_.date AS date_1, l0_.gagnant_nom AS gagnant_nom_2, l0_.gagnant_prenom AS gagnant_prenom_3, l0_.gagnant_mail AS gagnant_mail_4, l0_.gagnant_code_postal AS gagnant_code_postal_5, l0_.gagnant_telephone AS gagnant_telephone_6, l0_.date_bloquee AS date_bloquee_7, l0_.token AS token_8, l0_.utilisation_du_bon AS utilisation_du_bon_9, l0_.date_gagne AS date_gagne_10, l0_.created_by AS created_by_11, l0_.updated_by AS updated_by_12, l0_.created_at AS created_at_13, l0_.updated_at AS updated_at_14, l1_.id AS id_15, l1_.libelle AS libelle_16, l1_.illustration_filename AS illustration_filename_17, l1_.logo_filename AS logo_filename_18, l1_.voucher_description_lot AS voucher_description_lot_19, l1_.voucher_duree_validite AS voucher_duree_validite_20, l1_.voucher_condition_utilisation AS voucher_condition_utilisation_21, l1_.voucher_libelle AS voucher_libelle_22, l1_.voucher_description_site AS voucher_description_site_23, l1_.voucher_calendrier AS voucher_calendrier_24, l1_.couleur AS couleur_25, l1_.voucher_debut_validite AS voucher_debut_validite_26, l1_.voucher_fin_validite AS voucher_fin_validite_27, l1_.generer_qr_sur_voucher AS generer_qr_sur_voucher_28, l1_.created_by AS created_by_29, l1_.updated_by AS updated_by_30, l1_.created_at AS created_at_31, l1_.updated_at AS updated_at_32, f2_.id AS id_33, f2_.libelle AS libelle_34, f2_.slug AS slug_35, f2_.homepage_baseline AS homepage_baseline_36, f2_.homepage_filename AS homepage_filename_37, f2_.title AS title_38, f2_.meta_description AS meta_description_39, f2_.infos_pratiques_adresse AS infos_pratiques_adresse_40, f2_.infos_pratiques_mail AS infos_pratiques_mail_41, f2_.infos_pratiques_telephone AS infos_pratiques_telephone_42, f2_.url_site_internet AS url_site_internet_43, f2_.url_billetterie AS url_billetterie_44, f2_.url_instagram AS url_instagram_45, f2_.url_facebook AS url_facebook_46, f2_.url_youtube AS url_youtube_47, f2_.calendrier_horaires AS calendrier_horaires_48, f2_.infos_pratique_logo_filename AS infos_pratique_logo_filename_49, f2_.infos_pratiques_map_filename AS infos_pratiques_map_filename_50, f2_.header_image_filename AS header_image_filename_51, f2_.texte1 AS texte1_52, f2_.slotmachine_filename AS slotmachine_filename_53, f2_.autonome_creation_lot AS autonome_creation_lot_54, f2_.created_by AS created_by_55, f2_.updated_by AS updated_by_56, f2_.enabled AS enabled_57, f2_.sortable AS sortable_58, f2_.created_at AS created_at_59, f2_.updated_at AS updated_at_60, l0_.lot_id AS lot_id_61, l1_.fiche_partenaire_id AS fiche_partenaire_id_62 FROM lot_periode l0_ INNER JOIN lot l1_ ON l0_.lot_id = l1_.id INNER JOIN fiche_partenaire f2_ ON l1_.fiche_partenaire_id = f2_.id WHERE l0_.date_bloquee < '2025-12-07 16:19:09' AND l0_.date_gagne IS NULL LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  lot_periode
SET
  date_bloquee = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE lot_periode SET date_bloquee = '2025-12-07 16:34:09', updated_at = '2025-12-07 16:19:09' WHERE id = 8216;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.homepage_baseline AS homepage_baseline_4,
  t0.homepage_filename AS homepage_filename_5,
  t0.title AS title_6,
  t0.meta_description AS meta_description_7,
  t0.infos_pratiques_adresse AS infos_pratiques_adresse_8,
  t0.infos_pratiques_mail AS infos_pratiques_mail_9,
  t0.infos_pratiques_telephone AS infos_pratiques_telephone_10,
  t0.url_site_internet AS url_site_internet_11,
  t0.url_billetterie AS url_billetterie_12,
  t0.url_instagram AS url_instagram_13,
  t0.url_facebook AS url_facebook_14,
  t0.url_youtube AS url_youtube_15,
  t0.calendrier_horaires AS calendrier_horaires_16,
  t0.infos_pratique_logo_filename AS infos_pratique_logo_filename_17,
  t0.infos_pratiques_map_filename AS infos_pratiques_map_filename_18,
  t0.header_image_filename AS header_image_filename_19,
  t0.texte1 AS texte1_20,
  t0.slotmachine_filename AS slotmachine_filename_21,
  t0.autonome_creation_lot AS autonome_creation_lot_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24,
  t0.enabled AS enabled_25,
  t0.sortable AS sortable_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28
FROM
  fiche_partenaire t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.homepage_baseline AS homepage_baseline_4, t0.homepage_filename AS homepage_filename_5, t0.title AS title_6, t0.meta_description AS meta_description_7, t0.infos_pratiques_adresse AS infos_pratiques_adresse_8, t0.infos_pratiques_mail AS infos_pratiques_mail_9, t0.infos_pratiques_telephone AS infos_pratiques_telephone_10, t0.url_site_internet AS url_site_internet_11, t0.url_billetterie AS url_billetterie_12, t0.url_instagram AS url_instagram_13, t0.url_facebook AS url_facebook_14, t0.url_youtube AS url_youtube_15, t0.calendrier_horaires AS calendrier_horaires_16, t0.infos_pratique_logo_filename AS infos_pratique_logo_filename_17, t0.infos_pratiques_map_filename AS infos_pratiques_map_filename_18, t0.header_image_filename AS header_image_filename_19, t0.texte1 AS texte1_20, t0.slotmachine_filename AS slotmachine_filename_21, t0.autonome_creation_lot AS autonome_creation_lot_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24, t0.enabled AS enabled_25, t0.sortable AS sortable_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28 FROM fiche_partenaire t0;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.code AS code_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  parametre t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.valeur AS valeur_4, t0.type AS type_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM parametre t0 WHERE t0.code = 'lien_politique_confidentialite' LIMIT 1;