Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.paiement_at AS paiement_at_4,
  t0.total_amount AS total_amount_5,
  t0.paiement_ref AS paiement_ref_6,
  t0.method_name AS method_name_7,
  t0.stock_processing_status AS stock_processing_status_8,
  t0.stock_processing_reason AS stock_processing_reason_9,
  t0.animatrice_numero_id AS animatrice_numero_id_10,
  t0.coach_id AS coach_id_11,
  t12.id AS id_13,
  t12.code AS code_14,
  t12.created_at AS created_at_15,
  t12.total_value AS total_value_16,
  t12.quantite_estimee AS quantite_estimee_17,
  t12.quantite_calculee_raw AS quantite_calculee_raw_18,
  t12.quantite_rounding_mode AS quantite_rounding_mode_19,
  t12.quantite_rounding_precision AS quantite_rounding_precision_20,
  t12.vente_at AS vente_at_21,
  t12.animatrice_numero_id AS animatrice_numero_id_22,
  t12.paiement_id AS paiement_id_23,
  t24.id AS id_25,
  t24.code AS code_26,
  t24.created_at AS created_at_27,
  t24.quantite_demandee AS quantite_demandee_28,
  t24.quantite_servie AS quantite_servie_29,
  t24.quantite_impayee AS quantite_impayee_30,
  t24.unit_price AS unit_price_31,
  t24.stock_policy_used AS stock_policy_used_32,
  t24.status AS status_33,
  t24.regularised_at AS regularised_at_34,
  t24.last_regularisation_at AS last_regularisation_at_35,
  t24.paiement_id AS paiement_id_36,
  t24.last_regularised_by_id AS last_regularised_by_id_37
FROM
  paiement t0
  LEFT JOIN vente t12 ON t12.paiement_id = t0.id
  LEFT JOIN paiement_reliquat t24 ON t24.paiement_id = t0.id
WHERE
  t0.paiement_ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.paiement_at AS paiement_at_4, t0.total_amount AS total_amount_5, t0.paiement_ref AS paiement_ref_6, t0.method_name AS method_name_7, t0.stock_processing_status AS stock_processing_status_8, t0.stock_processing_reason AS stock_processing_reason_9, t0.animatrice_numero_id AS animatrice_numero_id_10, t0.coach_id AS coach_id_11, t12.id AS id_13, t12.code AS code_14, t12.created_at AS created_at_15, t12.total_value AS total_value_16, t12.quantite_estimee AS quantite_estimee_17, t12.quantite_calculee_raw AS quantite_calculee_raw_18, t12.quantite_rounding_mode AS quantite_rounding_mode_19, t12.quantite_rounding_precision AS quantite_rounding_precision_20, t12.vente_at AS vente_at_21, t12.animatrice_numero_id AS animatrice_numero_id_22, t12.paiement_id AS paiement_id_23, t24.id AS id_25, t24.code AS code_26, t24.created_at AS created_at_27, t24.quantite_demandee AS quantite_demandee_28, t24.quantite_servie AS quantite_servie_29, t24.quantite_impayee AS quantite_impayee_30, t24.unit_price AS unit_price_31, t24.stock_policy_used AS stock_policy_used_32, t24.status AS status_33, t24.regularised_at AS regularised_at_34, t24.last_regularisation_at AS last_regularisation_at_35, t24.paiement_id AS paiement_id_36, t24.last_regularised_by_id AS last_regularised_by_id_37 FROM paiement t0 LEFT JOIN vente t12 ON t12.paiement_id = t0.id LEFT JOIN paiement_reliquat t24 ON t24.paiement_id = t0.id WHERE t0.paiement_ref = '8d72fda2-53e7-41b1-b0bd-c3fb05d6e075' LIMIT 1;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  animatrice
SET
  last_updated_at = ?
WHERE
  id = ?

UPDATE animatrice SET last_updated_at = '2026-10-20 06:15:17' WHERE id = 2;

SELECT
  COALESCE(
    SUM(p0_.total_value),
    0
  ) AS sclr_0
FROM
  product_stock p0_
WHERE
  p0_.animatrice_id = ?

SELECT COALESCE(SUM(p0_.total_value), 0) AS sclr_0 FROM product_stock p0_ WHERE p0_.animatrice_id = 2;

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.numero AS numero_4,
  a0_.is_enabled AS is_enabled_5,
  a0_.last_sync_at AS last_sync_at_6,
  a0_.animatrice_id AS animatrice_id_7,
  a0_.created_by_id AS created_by_id_8,
  a0_.product_id AS product_id_9
FROM
  animatrice_numero a0_
WHERE
  a0_.animatrice_id = ?
  AND (
    a0_.is_enabled = 1
    OR a0_.is_enabled IS NULL
  )

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.numero AS numero_4, a0_.is_enabled AS is_enabled_5, a0_.last_sync_at AS last_sync_at_6, a0_.animatrice_id AS animatrice_id_7, a0_.created_by_id AS created_by_id_8, a0_.product_id AS product_id_9 FROM animatrice_numero a0_ WHERE a0_.animatrice_id = 2 AND (a0_.is_enabled = 1 OR a0_.is_enabled IS NULL);

UPDATE
  animatrice_numero
SET
  last_sync_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE animatrice_numero SET last_sync_at = '2026-10-20 06:15:17', updated_at = '2026-10-20 06:15:17' WHERE id = 99;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.description AS description_4,
  t0.value AS value_5,
  t0.value_type AS value_type_6,
  t0.options AS options_7,
  t0.config_group AS config_group_8
FROM
  configuration t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.description AS description_4, t0.value AS value_5, t0.value_type AS value_type_6, t0.options AS options_7, t0.config_group AS config_group_8 FROM configuration t0 WHERE t0.code = 'ENABLE_EBP_SYNC' LIMIT 1;

UPDATE
  configuration
SET
  value = ?
WHERE
  id = ?

UPDATE configuration SET value = '2026-10-20T06:15:16+00:00' WHERE id = 27;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom_prenom AS nom_prenom_3,
  t0.created_at AS created_at_4,
  t0.code_collaborateur AS code_collaborateur_5,
  t0.last_updated_at AS last_updated_at_6,
  t0.adresse AS adresse_7,
  t0.phone_number AS phone_number_8,
  t0.total_vente AS total_vente_9,
  t0.valeur_stock AS valeur_stock_10,
  t0.total_paiement_restant AS total_paiement_restant_11,
  t0.is_soazaza AS is_soazaza_12,
  t0.soazaza_started_at AS soazaza_started_at_13,
  t0.soazaza_funnel_status AS soazaza_funnel_status_14,
  t0.soazaza_recommended_decision AS soazaza_recommended_decision_15,
  t0.soazaza_stagnation_alert AS soazaza_stagnation_alert_16,
  t0.soazaza_funnel_months AS soazaza_funnel_months_17,
  t0.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_18,
  t0.is_risque AS is_risque_19,
  t0.is_eligible_relegation AS is_eligible_relegation_20,
  t0.risque_level AS risque_level_21,
  t0.risque_reasons AS risque_reasons_22,
  t0.risque_evaluated_at AS risque_evaluated_at_23,
  t0.objectif_unites_mois AS objectif_unites_mois_24,
  t0.projection_unites_fin_mois AS projection_unites_fin_mois_25,
  t0.trajectoire_status AS trajectoire_status_26,
  t0.alerte_projection AS alerte_projection_27,
  t0.objectif_evaluated_at AS objectif_evaluated_at_28,
  t0.objectif_ventes_mois AS objectif_ventes_mois_29,
  t0.projection_ventes_fin_mois AS projection_ventes_fin_mois_30,
  t0.trajectoire_status_ventes AS trajectoire_status_ventes_31,
  t0.paiements_projetes_fin_mois AS paiements_projetes_fin_mois_32,
  t0.exposition_cash_projetee AS exposition_cash_projetee_33,
  t0.last_visite_at AS last_visite_at_34,
  t0.is_enabled AS is_enabled_35,
  t0.region_id AS region_id_36,
  t0.coach_id AS coach_id_37
FROM
  animatrice t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom_prenom AS nom_prenom_3, t0.created_at AS created_at_4, t0.code_collaborateur AS code_collaborateur_5, t0.last_updated_at AS last_updated_at_6, t0.adresse AS adresse_7, t0.phone_number AS phone_number_8, t0.total_vente AS total_vente_9, t0.valeur_stock AS valeur_stock_10, t0.total_paiement_restant AS total_paiement_restant_11, t0.is_soazaza AS is_soazaza_12, t0.soazaza_started_at AS soazaza_started_at_13, t0.soazaza_funnel_status AS soazaza_funnel_status_14, t0.soazaza_recommended_decision AS soazaza_recommended_decision_15, t0.soazaza_stagnation_alert AS soazaza_stagnation_alert_16, t0.soazaza_funnel_months AS soazaza_funnel_months_17, t0.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_18, t0.is_risque AS is_risque_19, t0.is_eligible_relegation AS is_eligible_relegation_20, t0.risque_level AS risque_level_21, t0.risque_reasons AS risque_reasons_22, t0.risque_evaluated_at AS risque_evaluated_at_23, t0.objectif_unites_mois AS objectif_unites_mois_24, t0.projection_unites_fin_mois AS projection_unites_fin_mois_25, t0.trajectoire_status AS trajectoire_status_26, t0.alerte_projection AS alerte_projection_27, t0.objectif_evaluated_at AS objectif_evaluated_at_28, t0.objectif_ventes_mois AS objectif_ventes_mois_29, t0.projection_ventes_fin_mois AS projection_ventes_fin_mois_30, t0.trajectoire_status_ventes AS trajectoire_status_ventes_31, t0.paiements_projetes_fin_mois AS paiements_projetes_fin_mois_32, t0.exposition_cash_projetee AS exposition_cash_projetee_33, t0.last_visite_at AS last_visite_at_34, t0.is_enabled AS is_enabled_35, t0.region_id AS region_id_36, t0.coach_id AS coach_id_37 FROM animatrice t0 WHERE t0.is_enabled = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.created_at AS created_at_6,
  t0.nom_prenom AS nom_prenom_7,
  t0.ebp_client_code AS ebp_client_code_8,
  t0.is_enabled AS is_enabled_9,
  t0.last_activity_at AS last_activity_at_10,
  t0.last_visite_at AS last_visite_at_11,
  t0.last_update_at AS last_update_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.utilisateur_role_id AS utilisateur_role_id_14,
  t0.region_id AS region_id_15
FROM
  utilisateur t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.nom_prenom AS nom_prenom_7, t0.ebp_client_code AS ebp_client_code_8, t0.is_enabled AS is_enabled_9, t0.last_activity_at AS last_activity_at_10, t0.last_visite_at AS last_visite_at_11, t0.last_update_at AS last_update_at_12, t0.last_login_at AS last_login_at_13, t0.utilisateur_role_id AS utilisateur_role_id_14, t0.region_id AS region_id_15 FROM utilisateur t0 WHERE t0.code = 'TLS6A2F0A6BD2DA620260614200915' LIMIT 1;