Symfony Profiler

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.sale_id AS sale_id_4,
  t0.lot_number AS lot_number_5,
  t0.expire_at AS expire_at_6,
  t0.quantite_disponible AS quantite_disponible_7,
  t0.quantite_initial AS quantite_initial_8,
  t0.total_value AS total_value_9,
  t0.last_mouvement_at AS last_mouvement_at_10,
  t0.slug AS slug_11,
  t0.animatrice_id AS animatrice_id_12,
  t0.product_id AS product_id_13
FROM
  product_stock t0
WHERE
  t0.animatrice_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.sale_id AS sale_id_4, t0.lot_number AS lot_number_5, t0.expire_at AS expire_at_6, t0.quantite_disponible AS quantite_disponible_7, t0.quantite_initial AS quantite_initial_8, t0.total_value AS total_value_9, t0.last_mouvement_at AS last_mouvement_at_10, t0.slug AS slug_11, t0.animatrice_id AS animatrice_id_12, t0.product_id AS product_id_13 FROM product_stock t0 WHERE t0.animatrice_id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.numero AS numero_3,
  t0.designation AS designation_4,
  t0.unit AS unit_5,
  t0.price AS price_6,
  t0.filename AS filename_7,
  t0.color AS color_8,
  t0.survente AS survente_9,
  t0.is_enabled AS is_enabled_10,
  t0.last_update_at AS last_update_at_11,
  t0.multiplier AS multiplier_12
FROM
  product t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.numero AS numero_3, t0.designation AS designation_4, t0.unit AS unit_5, t0.price AS price_6, t0.filename AS filename_7, t0.color AS color_8, t0.survente AS survente_9, t0.is_enabled AS is_enabled_10, t0.last_update_at AS last_update_at_11, t0.multiplier AS multiplier_12 FROM product t0;

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 = 1 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-09-03 05:00:26', updated_at = '2026-09-03 05:00:26' WHERE id = 1;

UPDATE
  animatrice
SET
  last_updated_at = ?
WHERE
  id = ?

UPDATE animatrice SET last_updated_at = '2026-09-03 05:00:26' WHERE id = 1;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_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 = 1;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.facture_ref AS facture_ref_4,
  t0.total_value AS total_value_5,
  t0.livraison_at AS livraison_at_6,
  t0.animatrice_numero_id AS animatrice_numero_id_7
FROM
  facturation t0
WHERE
  t0.facture_ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.facture_ref AS facture_ref_4, t0.total_value AS total_value_5, t0.livraison_at AS livraison_at_6, t0.animatrice_numero_id AS animatrice_numero_id_7 FROM facturation t0 WHERE t0.facture_ref = 'FA115003' 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 = ?
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;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.created_at AS created_at_2,
  p0_.quantite_demandee AS quantite_demandee_3,
  p0_.quantite_servie AS quantite_servie_4,
  p0_.quantite_impayee AS quantite_impayee_5,
  p0_.unit_price AS unit_price_6,
  p0_.stock_policy_used AS stock_policy_used_7,
  p0_.status AS status_8,
  p0_.regularised_at AS regularised_at_9,
  p0_.last_regularisation_at AS last_regularisation_at_10,
  p0_.paiement_id AS paiement_id_11,
  p0_.last_regularised_by_id AS last_regularised_by_id_12
FROM
  paiement_reliquat p0_
  INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id
  INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id
  INNER JOIN product p3_ ON a2_.product_id = p3_.id
WHERE
  a2_.animatrice_id = ?
  AND p3_.id = ?
  AND p0_.status = ?
  AND p0_.quantite_impayee > 0
ORDER BY
  p1_.paiement_at ASC,
  p0_.created_at ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.created_at AS created_at_2, p0_.quantite_demandee AS quantite_demandee_3, p0_.quantite_servie AS quantite_servie_4, p0_.quantite_impayee AS quantite_impayee_5, p0_.unit_price AS unit_price_6, p0_.stock_policy_used AS stock_policy_used_7, p0_.status AS status_8, p0_.regularised_at AS regularised_at_9, p0_.last_regularisation_at AS last_regularisation_at_10, p0_.paiement_id AS paiement_id_11, p0_.last_regularised_by_id AS last_regularised_by_id_12 FROM paiement_reliquat p0_ INNER JOIN paiement p1_ ON p0_.paiement_id = p1_.id INNER JOIN animatrice_numero a2_ ON p1_.animatrice_numero_id = a2_.id INNER JOIN product p3_ ON a2_.product_id = p3_.id WHERE a2_.animatrice_id = 19 AND p3_.id = 2 AND p0_.status = 'OPEN' AND p0_.quantite_impayee > 0 ORDER BY p1_.paiement_at ASC, p0_.created_at ASC;

INSERT INTO product_stock_mouvement (
  code, created_at, quantite, type, mouvement_at,
  total_value, computed_total_value,
  value_note, product_stock_id, created_by_id,
  facturation_id, retour_id, vente_id,
  ajustement_id, paiement_reliquat_regularisation_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO product_stock_mouvement (code, created_at, quantite, type, mouvement_at, total_value, computed_total_value, value_note, product_stock_id, created_by_id, facturation_id, retour_id, vente_id, ajustement_id, paiement_reliquat_regularisation_id) VALUES ('PRD6A98FEF306BE320260903050035', '2026-09-03 05:00:35', 25, 'FACTURATION', '2026-09-03 07:08:51', 292500, NULL, NULL, 883, 17, 806, NULL, NULL, NULL, NULL);

INSERT INTO facturation (
  code, created_at, facture_ref, total_value,
  livraison_at, animatrice_numero_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO facturation (code, created_at, facture_ref, total_value, livraison_at, animatrice_numero_id) VALUES ('FCT6A98FEF306B8720260903050035', '2026-09-03 05:00:35', 'FA115090', 292500, '2026-09-03 07:08:51', 105);

UPDATE
  animatrice
SET
  last_updated_at = ?,
  total_paiement_restant = ?
WHERE
  id = ?

UPDATE animatrice SET last_updated_at = '2026-09-03 05:00:35', total_paiement_restant = 834900 WHERE id = 19;

UPDATE
  animatrice
SET
  last_updated_at = ?,
  valeur_stock = ?
WHERE
  id = ?

UPDATE animatrice SET last_updated_at = '2026-09-03 05:00:35', valeur_stock = 836082 WHERE id = 19;

UPDATE
  configuration
SET
  value = ?
WHERE
  id = ?

UPDATE configuration SET value = '2026-09-03T05:00:25+00:00' WHERE id = 36;

INSERT INTO product_stock (
  code, created_at, sale_id, lot_number,
  expire_at, quantite_disponible,
  quantite_initial, total_value, last_mouvement_at,
  slug, animatrice_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO product_stock (code, created_at, sale_id, lot_number, expire_at, quantite_disponible, quantite_initial, total_value, last_mouvement_at, slug, animatrice_id, product_id) VALUES ('PRD6A98FEF306BC820260903050035', '2026-09-03 05:00:35', 'CL02477', '01-224-26', '2026-11-12 00:00:00', 25, 25, 292500, '2026-09-03 07:08:51', 'CL02477-KB02-01-224-26', 19, 2);

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.risque_level AS risque_level_20,
  t0.risque_reasons AS risque_reasons_21,
  t0.risque_evaluated_at AS risque_evaluated_at_22,
  t0.last_visite_at AS last_visite_at_23,
  t0.is_enabled AS is_enabled_24,
  t0.region_id AS region_id_25,
  t0.coach_id AS coach_id_26
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.risque_level AS risque_level_20, t0.risque_reasons AS risque_reasons_21, t0.risque_evaluated_at AS risque_evaluated_at_22, t0.last_visite_at AS last_visite_at_23, t0.is_enabled AS is_enabled_24, t0.region_id AS region_id_25, t0.coach_id AS coach_id_26 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.is_enabled AS is_enabled_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.last_visite_at AS last_visite_at_10,
  t0.last_update_at AS last_update_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.utilisateur_role_id AS utilisateur_role_id_13,
  t0.region_id AS region_id_14
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.is_enabled AS is_enabled_8, t0.last_activity_at AS last_activity_at_9, t0.last_visite_at AS last_visite_at_10, t0.last_update_at AS last_update_at_11, t0.last_login_at AS last_login_at_12, t0.utilisateur_role_id AS utilisateur_role_id_13, t0.region_id AS region_id_14 FROM utilisateur t0 WHERE t0.code = 'TLS6A2F0A6BD2DA620260614200915' LIMIT 1;

UPDATE
  product_stock
SET
  expire_at = ?,
  quantite_disponible = ?,
  total_value = ?,
  last_mouvement_at = ?
WHERE
  id = ?

UPDATE product_stock SET expire_at = '2026-11-13 00:00:00', quantite_disponible = 25, total_value = 292500, last_mouvement_at = '2026-09-03 06:59:21' WHERE id = 881;