Symfony Profiler

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 = ?

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 = '22788641402';

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

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

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

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 = 1 AND t0.id_client = 6 ORDER BY t0.id DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.id = 9140;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.id = 9139;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.id = 9107;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.id = 9101;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.id = 9096;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  action, message, context, source, created_at,
  updated_at, identifiant
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES ('TRANSACTIONS', 'Affichage de la liste dernieres transaction', '{\"client\":6}', 'ApiListController', '2026-04-11 22:05:14', NULL, '1');

"COMMIT"

"COMMIT";