User Deprecated: Version detection logic for MySQL will change in DBAL 4. Please specify the version as the server reports it, e.g. "8.0.31" instead of "8". (AbstractMySQLDriver.php:89 called by AbstractDriverMiddleware.php:68, https://github.com/doctrine/dbal/pull/5779, package doctrine/orm)
"SELECT c0_.id AS id_0, c0_.last_name AS last_name_1, c0_.first_name AS first_name_2, c0_.address AS address_3, c0_.password AS password_4, c0_.phone AS phone_5, c0_.mail AS mail_6, c0_.canal AS canal_7, c0_.created_at AS created_at_8, c0_.deleted_at AS deleted_at_9, c0_.status AS status_10, c0_.code_lancement AS code_lancement_11, c0_.kyc AS kyc_12, c0_.piece_identite AS piece_identite_13, c0_.code_unique AS code_unique_14, c0_.nbre_tentative AS nbre_tentative_15, c0_.id_session AS id_session_16, c0_.is_active AS is_active_17, c0_.id_roles_id AS id_roles_id_18 FROM customer c0_ WHERE c0_.phone = ?"
(parameters:
[1 => "22797977992"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT c0_.id AS id_0, c0_.last_name AS last_name_1, c0_.first_name AS first_name_2, c0_.address AS address_3, c0_.password AS password_4, c0_.phone AS phone_5, c0_.mail AS mail_6, c0_.canal AS canal_7, c0_.created_at AS created_at_8, c0_.deleted_at AS deleted_at_9, c0_.status AS status_10, c0_.code_lancement AS code_lancement_11, c0_.kyc AS kyc_12, c0_.piece_identite AS piece_identite_13, c0_.code_unique AS code_unique_14, c0_.nbre_tentative AS nbre_tentative_15, c0_.id_session AS id_session_16, c0_.is_active AS is_active_17, c0_.id_roles_id AS id_roles_id_18 FROM customer c0_ WHERE c0_.phone = ?"
"params" => [1 => "22797977992"
]
"types" => [1 => 2]
]
deprecation
Deprecated: Creation of dynamic property Proxies\__CG__\App\Entity\Roles::$label is deprecated
"SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.phone = ? LIMIT 1"
(parameters:
[1 => "22797977992"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.phone = ? LIMIT 1"
"params" => [1 => "22797977992"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.id = ? LIMIT 1"
(parameters:
[1 => 186]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.id = ? LIMIT 1"
"params" => [1 => 186]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.number_of_connection_attempts AS number_of_connection_attempts_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.limit_mensuelle AS limit_mensuelle_6, t0.limit_journalier AS limit_journalier_7 FROM setting t0 WHERE t0.status = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.number_of_connection_attempts AS number_of_connection_attempts_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.limit_mensuelle AS limit_mensuelle_6, t0.limit_journalier AS limit_journalier_7 FROM setting t0 WHERE t0.status = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = ? AND m0_.status = ? AND (m0_.created_at BETWEEN ? AND ?)"
[
"sql" => "SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = ? AND m0_.status = ? AND (m0_.created_at BETWEEN ? AND ?)"
"params" => [1 => "186"
2 => 13 => "2026-04-01 00:00:00"
4 => "2026-04-30 23:59:59"
]
"types" => [1 => 22 => 13 => 24 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.libel AS libel_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.image AS image_6 FROM operator t0 WHERE t0.id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => "1"
2 => 1]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.libel AS libel_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.image AS image_6 FROM operator t0 WHERE t0.id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => "1"
2 => 1]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.pq AS pq_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.id_operator_id AS id_operator_id_6 FROM pq t0 WHERE t0.pq = ? AND t0.id_operator_id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => "97"
2 => "1"
3 => 1]
, types:
[1 => 22 => 13 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.pq AS pq_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.id_operator_id AS id_operator_id_6 FROM pq t0 WHERE t0.pq = ? AND t0.id_operator_id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => "97"
2 => "1"
3 => 1]
"types" => [1 => 22 => 13 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.libel AS libel_2, t0.with_or_without_commission AS with_or_without_commission_3, t0.commission_percentage AS commission_percentage_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_type_op AS id_type_op_8 FROM transaction_type t0 WHERE t0.id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => 42 => 1]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.libel AS libel_2, t0.with_or_without_commission AS with_or_without_commission_3, t0.commission_percentage AS commission_percentage_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_type_op AS id_type_op_8 FROM transaction_type t0 WHERE t0.id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => 42 => 1]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.id_store_id AS id_store_id_12, t0.id_customer_id AS id_customer_id_13, t0.id_type_id AS id_type_id_14 FROM account t0 WHERE t0.id_customer_id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => 1862 => 1]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.id_store_id AS id_store_id_12, t0.id_customer_id AS id_customer_id_13, t0.id_type_id AS id_type_id_14 FROM account t0 WHERE t0.id_customer_id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => 1862 => 1]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.pourcentage_commission AS pourcentage_commission_12, t0.id_operator_id AS id_operator_id_13, t0.id_operator_account_type_id AS id_operator_account_type_id_14 FROM operator_account t0 WHERE t0.id_operator_id = ? AND t0.id_operator_account_type_id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => 12 => 13 => 1]
, types:
[1 => 12 => 13 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.pourcentage_commission AS pourcentage_commission_12, t0.id_operator_id AS id_operator_id_13, t0.id_operator_account_type_id AS id_operator_account_type_id_14 FROM operator_account t0 WHERE t0.id_operator_id = ? AND t0.id_operator_account_type_id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => 12 => 13 => 1]
"types" => [1 => 12 => 13 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.commission AS commission_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.commission_client AS commission_client_6, t0.id_operateur_id AS id_operateur_id_7, t0.id_type_id AS id_type_id_8, t0.id_role_id AS id_role_id_9 FROM partage_commission t0 WHERE t0.id_type_id = ? AND t0.id_operateur_id = ? AND t0.id_role_id = ? AND t0.status = ? LIMIT 1"
(parameters:
[1 => 42 => 13 => 14 => 1]
, types:
[1 => 12 => 13 => 14 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.commission AS commission_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.commission_client AS commission_client_6, t0.id_operateur_id AS id_operateur_id_7, t0.id_type_id AS id_type_id_8, t0.id_role_id AS id_role_id_9 FROM partage_commission t0 WHERE t0.id_type_id = ? AND t0.id_operateur_id = ? AND t0.id_role_id = ? AND t0.status = ? LIMIT 1"
"params" => [1 => 42 => 13 => 14 => 1]
"types" => [1 => 12 => 13 => 14 => 1]
]
debug
Executing statement:
"SELECT t0_.id AS id_0, t0_.amount AS amount_1, t0_.name AS name_2, t0_.first_name AS first_name_3, t0_.phone AS phone_4, t0_.back_api AS back_api_5, t0_.costs AS costs_6, t0_.commission AS commission_7, t0_.code AS code_8, t0_.created_at AS created_at_9, t0_.deleted_at AS deleted_at_10, t0_.status AS status_11, t0_.n_recu AS n_recu_12, t0_.commission_agent AS commission_agent_13, t0_.commission_partage AS commission_partage_14, t0_.pourcentage_comm AS pourcentage_comm_15, t0_.pourcentage_comm_agent AS pourcentage_comm_agent_16, t0_.pourcentage_comm_partage AS pourcentage_comm_partage_17, t0_.id_operation_partenaire_id AS id_operation_partenaire_id_18, t0_.id_transaction_type_id AS id_transaction_type_id_19, t0_.id_status_operation_id AS id_status_operation_id_20, t0_.id_customer_id AS id_customer_id_21, t0_.id_operator_id AS id_operator_id_22 FROM transaction t0_ WHERE t0_.id_transaction_type_id = ? AND t0_.id_operator_id = ? AND t0_.id_customer_id = ? AND t0_.amount = ? AND t0_.phone = ? AND t0_.created_at LIKE ? AND (t0_.created_at BETWEEN ? AND ?)"
[
"sql" => "SELECT t0_.id AS id_0, t0_.amount AS amount_1, t0_.name AS name_2, t0_.first_name AS first_name_3, t0_.phone AS phone_4, t0_.back_api AS back_api_5, t0_.costs AS costs_6, t0_.commission AS commission_7, t0_.code AS code_8, t0_.created_at AS created_at_9, t0_.deleted_at AS deleted_at_10, t0_.status AS status_11, t0_.n_recu AS n_recu_12, t0_.commission_agent AS commission_agent_13, t0_.commission_partage AS commission_partage_14, t0_.pourcentage_comm AS pourcentage_comm_15, t0_.pourcentage_comm_agent AS pourcentage_comm_agent_16, t0_.pourcentage_comm_partage AS pourcentage_comm_partage_17, t0_.id_operation_partenaire_id AS id_operation_partenaire_id_18, t0_.id_transaction_type_id AS id_transaction_type_id_19, t0_.id_status_operation_id AS id_status_operation_id_20, t0_.id_customer_id AS id_customer_id_21, t0_.id_operator_id AS id_operator_id_22 FROM transaction t0_ WHERE t0_.id_transaction_type_id = ? AND t0_.id_operator_id = ? AND t0_.id_customer_id = ? AND t0_.amount = ? AND t0_.phone = ? AND t0_.created_at LIKE ? AND (t0_.created_at BETWEEN ? AND ?)"
"params" => [1 => 42 => 13 => 1864 => "8945"
5 => "97180775"
6 => "2026-04-11%"
7 => "2026-04-11 20:26:02"
8 => "2026-04-11 20:27:02"
]
"types" => [1 => 12 => 13 => 14 => 25 => 26 => 27 => 28 => 2]
]