Symfony Profiler

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 = 'SOAZAZA_FUNNEL_TRIAL_MONTHS' LIMIT 1;

SELECT
  COALESCE(
    SUM(v0_.quantite_estimee),
    0
  ) AS sclr_0
FROM
  vente v0_
  INNER JOIN animatrice_numero a1_ ON v0_.animatrice_numero_id = a1_.id
WHERE
  a1_.animatrice_id = ?
  AND v0_.vente_at >= ?
  AND v0_.vente_at <= ?

SELECT COALESCE(SUM(v0_.quantite_estimee), 0) AS sclr_0 FROM vente v0_ INNER JOIN animatrice_numero a1_ ON v0_.animatrice_numero_id = a1_.id WHERE a1_.animatrice_id = 63 AND v0_.vente_at >= '2026-06-01 00:00:00' AND v0_.vente_at <= '2026-06-30 23:59:59';

SELECT
  m0_.valeur AS valeur_0
FROM
  module_response m0_
  INNER JOIN module m1_ ON m0_.module_id = m1_.id
  INNER JOIN visite v2_ ON m1_.visite_id = v2_.id
  INNER JOIN animatrice a3_ ON v2_.animatrice_id = a3_.id
  INNER JOIN module_question m4_ ON m0_.question_id = m4_.id
WHERE
  a3_.code = ?
  AND m4_.code = ?
  AND v2_.end_at >= ?
ORDER BY
  v2_.end_at DESC,
  m1_.end_at DESC,
  m0_.id DESC
LIMIT
  1

SELECT m0_.valeur AS valeur_0 FROM module_response m0_ INNER JOIN module m1_ ON m0_.module_id = m1_.id INNER JOIN visite v2_ ON m1_.visite_id = v2_.id INNER JOIN animatrice a3_ ON v2_.animatrice_id = a3_.id INNER JOIN module_question m4_ ON m0_.question_id = m4_.id WHERE a3_.code = 'NMT6A2F09C116B4B20260614200625' AND m4_.code = 'SOAZAZA_RECO_MOCOACH' AND v2_.end_at >= '2026-06-01 00:00:00' ORDER BY v2_.end_at DESC, m1_.end_at DESC, m0_.id DESC LIMIT 1;

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

UPDATE animatrice SET soazaza_funnel_evaluated_at = '2026-09-03 00:00:00', last_updated_at = '2026-09-03 05:00:36' WHERE id = 63;

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.nom_prenom AS nom_prenom_2,
  a0_.created_at AS created_at_3,
  a0_.code_collaborateur AS code_collaborateur_4,
  a0_.last_updated_at AS last_updated_at_5,
  a0_.adresse AS adresse_6,
  a0_.phone_number AS phone_number_7,
  a0_.total_vente AS total_vente_8,
  a0_.valeur_stock AS valeur_stock_9,
  a0_.total_paiement_restant AS total_paiement_restant_10,
  a0_.is_soazaza AS is_soazaza_11,
  a0_.soazaza_started_at AS soazaza_started_at_12,
  a0_.soazaza_funnel_status AS soazaza_funnel_status_13,
  a0_.soazaza_recommended_decision AS soazaza_recommended_decision_14,
  a0_.soazaza_stagnation_alert AS soazaza_stagnation_alert_15,
  a0_.soazaza_funnel_months AS soazaza_funnel_months_16,
  a0_.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_17,
  a0_.is_risque AS is_risque_18,
  a0_.risque_level AS risque_level_19,
  a0_.risque_reasons AS risque_reasons_20,
  a0_.risque_evaluated_at AS risque_evaluated_at_21,
  a0_.last_visite_at AS last_visite_at_22,
  a0_.is_enabled AS is_enabled_23,
  u1_.id AS id_24,
  u1_.code AS code_25,
  u1_.username AS username_26,
  u1_.roles AS roles_27,
  u1_.password AS password_28,
  u1_.created_at AS created_at_29,
  u1_.nom_prenom AS nom_prenom_30,
  u1_.is_enabled AS is_enabled_31,
  u1_.last_activity_at AS last_activity_at_32,
  u1_.last_visite_at AS last_visite_at_33,
  u1_.last_update_at AS last_update_at_34,
  u1_.last_login_at AS last_login_at_35,
  a0_.region_id AS region_id_36,
  a0_.coach_id AS coach_id_37,
  u1_.utilisateur_role_id AS utilisateur_role_id_38,
  u1_.region_id AS region_id_39
FROM
  animatrice a0_
  LEFT JOIN utilisateur u1_ ON a0_.coach_id = u1_.id
WHERE
  a0_.is_soazaza = ?
  AND a0_.is_enabled = ?
ORDER BY
  a0_.nom_prenom ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.nom_prenom AS nom_prenom_2, a0_.created_at AS created_at_3, a0_.code_collaborateur AS code_collaborateur_4, a0_.last_updated_at AS last_updated_at_5, a0_.adresse AS adresse_6, a0_.phone_number AS phone_number_7, a0_.total_vente AS total_vente_8, a0_.valeur_stock AS valeur_stock_9, a0_.total_paiement_restant AS total_paiement_restant_10, a0_.is_soazaza AS is_soazaza_11, a0_.soazaza_started_at AS soazaza_started_at_12, a0_.soazaza_funnel_status AS soazaza_funnel_status_13, a0_.soazaza_recommended_decision AS soazaza_recommended_decision_14, a0_.soazaza_stagnation_alert AS soazaza_stagnation_alert_15, a0_.soazaza_funnel_months AS soazaza_funnel_months_16, a0_.soazaza_funnel_evaluated_at AS soazaza_funnel_evaluated_at_17, a0_.is_risque AS is_risque_18, a0_.risque_level AS risque_level_19, a0_.risque_reasons AS risque_reasons_20, a0_.risque_evaluated_at AS risque_evaluated_at_21, a0_.last_visite_at AS last_visite_at_22, a0_.is_enabled AS is_enabled_23, u1_.id AS id_24, u1_.code AS code_25, u1_.username AS username_26, u1_.roles AS roles_27, u1_.password AS password_28, u1_.created_at AS created_at_29, u1_.nom_prenom AS nom_prenom_30, u1_.is_enabled AS is_enabled_31, u1_.last_activity_at AS last_activity_at_32, u1_.last_visite_at AS last_visite_at_33, u1_.last_update_at AS last_update_at_34, u1_.last_login_at AS last_login_at_35, a0_.region_id AS region_id_36, a0_.coach_id AS coach_id_37, u1_.utilisateur_role_id AS utilisateur_role_id_38, u1_.region_id AS region_id_39 FROM animatrice a0_ LEFT JOIN utilisateur u1_ ON a0_.coach_id = u1_.id WHERE a0_.is_soazaza = 1 AND a0_.is_enabled = 1 ORDER BY a0_.nom_prenom ASC;

UPDATE
  animatrice
SET
  soazaza_funnel_months = ?,
  soazaza_funnel_evaluated_at = ?,
  last_updated_at = ?
WHERE
  id = ?

UPDATE animatrice SET soazaza_funnel_months = '[{\"monthIndex\":1,\"label\":\"07\\/2026\",\"startAt\":\"2026-07-01T00:00:00+00:00\",\"endAt\":\"2026-07-31T23:59:59+00:00\",\"targetKg\":80.0,\"actualKg\":72.0,\"gapKg\":8.0,\"status\":\"NON_ATTEINT\",\"reached\":false,\"isCompleted\":true},{\"monthIndex\":2,\"label\":\"08\\/2026\",\"startAt\":\"2026-08-01T00:00:00+00:00\",\"endAt\":\"2026-08-31T23:59:59+00:00\",\"targetKg\":90.0,\"actualKg\":119.0,\"gapKg\":-29.0,\"status\":\"ATTEINT\",\"reached\":true,\"isCompleted\":true},{\"monthIndex\":3,\"label\":\"09\\/2026\",\"startAt\":\"2026-09-01T00:00:00+00:00\",\"endAt\":\"2026-09-30T23:59:59+00:00\",\"targetKg\":100.0,\"actualKg\":3.0,\"gapKg\":97.0,\"status\":\"EN_COURS\",\"reached\":false,\"isCompleted\":false}]', soazaza_funnel_evaluated_at = '2026-09-03 00:00:00', last_updated_at = '2026-09-03 05:00:36' WHERE id = 110;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";