Symfony Profiler

[
  "route" => "cron_web_soazaza_funnel_snapshot"
  "route_parameters" => [
    "_route" => "cron_web_soazaza_funnel_snapshot"
    "_controller" => "App\Controller\CronWebController::snapshotSoazazaFunnel"
  ]
  "request_uri" => "https://nutrizaza.com/public/cron/soazaza-funnel/snapshot?token=7dff24e268bc0f4cdd11de85753c4d3a4cddf64449191238a197dd6d998a30f4"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "ua6fa9.myd.infomaniak.com"
    "port" => null
    "user" => "ua6fa9_anim"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ua6fa9_anim"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#969
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#969}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C116B4B20260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 63
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 63
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 63
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A59E80D83F4D20260717083005"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-07-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 112
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 112
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 112
    2 => "2026-09-01 00:00:00"
    3 => "2026-09-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C109E5520260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 32
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 32
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 32
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C10A4BC20260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 33
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 33
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 33
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C103D6F20260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 17
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 17
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 17
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C0F122220260614200624"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 1
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 1
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 1
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C0F19BB20260614200624"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 2
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 2
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 2
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C120DE420260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 88
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 88
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 88
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C11993920260614200625"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 70
    2 => "2026-06-01 00:00:00"
    3 => "2026-06-30 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 70
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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 <= ?"
  "params" => [
    1 => 70
    2 => "2026-08-01 00:00:00"
    3 => "2026-08-31 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_TRIAL_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MONTHLY_TARGETS_KG"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_ALLOWED_FAILED_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_STAGNATION_MONTHS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_REQUIRE_COACH_RECOMMENDATION"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_RISK"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_BLOCK_ON_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "SOAZAZA_FUNNEL_MAX_PAYMENT_RESTANT"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "NMT6A2F09C0F22AC20260614200624"
    2 => "SOAZAZA_RECO_MOCOACH"
    3 => "2026-06-01 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#928
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#928}
    3 => Doctrine\DBAL\ParameterType {#928}
  ]
]