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 => "22788925971"
]
, 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 => "22788925971"
]
"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 => "22788925971"
]
, 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 => "22788925971"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.compte AS compte_2, t0.id_operation AS id_operation_3, t0.operation AS operation_4, t0.movement_type AS movement_type_5, t0.amount AS amount_6, t0.balance_before AS balance_before_7, t0.sale_after AS sale_after_8, t0.id_client AS id_client_9, t0.reference AS reference_10, t0.date_update AS date_update_11, t0.id_user AS id_user_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.status AS status_15, t0.n_recu AS n_recu_16, t0.id_store AS id_store_17, t0.commission_avant AS commission_avant_18, t0.commission_apres AS commission_apres_19 FROM movement_account t0 WHERE t0.status = ? AND t0.id_client = ? ORDER BY t0.id DESC LIMIT 5"
(parameters:
[1 => 12 => 113]
, types:
[1 => 12 => 2]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.compte AS compte_2, t0.id_operation AS id_operation_3, t0.operation AS operation_4, t0.movement_type AS movement_type_5, t0.amount AS amount_6, t0.balance_before AS balance_before_7, t0.sale_after AS sale_after_8, t0.id_client AS id_client_9, t0.reference AS reference_10, t0.date_update AS date_update_11, t0.id_user AS id_user_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.status AS status_15, t0.n_recu AS n_recu_16, t0.id_store AS id_store_17, t0.commission_avant AS commission_avant_18, t0.commission_apres AS commission_apres_19 FROM movement_account t0 WHERE t0.status = ? AND t0.id_client = ? ORDER BY t0.id DESC LIMIT 5"
"params" => [1 => 12 => 113]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
(parameters:
[1 => 61605]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
"params" => [1 => 61605]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
(parameters:
[1 => 61585]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
"params" => [1 => 61585]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
(parameters:
[1 => 61563]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
"params" => [1 => 61563]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
(parameters:
[1 => 61559]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
"params" => [1 => 61559]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
(parameters:
[1 => 61521]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.amount AS amount_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.phone AS phone_5, t0.back_api AS back_api_6, t0.costs AS costs_7, t0.commission AS commission_8, t0.code AS code_9, t0.created_at AS created_at_10, t0.deleted_at AS deleted_at_11, t0.status AS status_12, t0.n_recu AS n_recu_13, t0.commission_agent AS commission_agent_14, t0.commission_partage AS commission_partage_15, t0.pourcentage_comm AS pourcentage_comm_16, t0.pourcentage_comm_agent AS pourcentage_comm_agent_17, t0.pourcentage_comm_partage AS pourcentage_comm_partage_18, t0.id_operation_partenaire_id AS id_operation_partenaire_id_19, t0.id_transaction_type_id AS id_transaction_type_id_20, t0.id_status_operation_id AS id_status_operation_id_21, t0.id_customer_id AS id_customer_id_22, t0.id_operator_id AS id_operator_id_23 FROM transaction t0 WHERE t0.id = ?"
"params" => [1 => 61521]
"types" => [1 => 1]
]
deprecation
Deprecated: Creation of dynamic property App\Entity\Log::$status is deprecated