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

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

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

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 = '2' AND t0.status = 1 LIMIT 1;

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

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 = '95' AND t0.id_operator_id = '2' AND t0.status = 1 LIMIT 1;

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

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 = 2 AND t0.status = 1 LIMIT 1;

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

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 = 149 AND t0.status = 1 LIMIT 1;

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

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 = 2 AND t0.id_operator_account_type_id = 2 AND t0.status = 1 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.id = ?
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.id = 149 LIMIT 1;

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

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

SELECT
  SUM(m0_.amount) AS sclr_0
FROM
  movement_account m0_
WHERE
  m0_.id_client = ?
  AND m0_.status = ?
  AND (
    m0_.created_at BETWEEN ?
    AND ?
  )

SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = '149' AND m0_.status = 1 AND (m0_.created_at BETWEEN '2026-06-19 00:00:00' AND '2026-06-19 23:59:59');

SELECT
  SUM(m0_.amount) AS sclr_0
FROM
  movement_account m0_
WHERE
  m0_.id_client = ?
  AND m0_.status = ?
  AND (
    m0_.created_at BETWEEN ?
    AND ?
  )

SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = '149' AND m0_.status = 1 AND (m0_.created_at BETWEEN '2026-06-01 00:00:00' AND '2026-06-30 23:59:59');

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

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 = 2 AND t0.id_operateur_id = 2 AND t0.id_role_id = 1 AND t0.status = 1 LIMIT 1;

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

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 = 2 AND t0_.id_operator_id = 2 AND t0_.id_customer_id = 149 AND t0_.amount = '1000' AND t0_.phone = '95947391' AND t0_.created_at LIKE '2026-06-19%' AND (t0_.created_at BETWEEN '2026-06-19 09:07:20' AND '2026-06-19 09:08:20');

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5
FROM
  status_operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5 FROM status_operation t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5
FROM
  status_operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5 FROM status_operation t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5
FROM
  status_operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5 FROM status_operation t0 WHERE t0.id = 3;

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.code = ?
LIMIT
  1

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.code = 'CMI26061909082015' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO transaction (
  amount, name, first_name, phone, back_api,
  costs, commission, code, created_at,
  deleted_at, status, n_recu, commission_agent,
  commission_partage, pourcentage_comm,
  pourcentage_comm_agent, pourcentage_comm_partage,
  id_operation_partenaire_id, id_transaction_type_id,
  id_status_operation_id, id_customer_id,
  id_operator_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO transaction (amount, name, first_name, phone, back_api, costs, commission, code, created_at, deleted_at, status, n_recu, commission_agent, commission_partage, pourcentage_comm, pourcentage_comm_agent, pourcentage_comm_partage, id_operation_partenaire_id, id_transaction_type_id, id_status_operation_id, id_customer_id, id_operator_id) VALUES ('1000', 'Client Airtel Money', 'Saga', '95947391', NULL, '1005', '5', 'CMI26061909082015', '2026-06-19 09:08:20', NULL, 0, '202606190908200149068311', NULL, NULL, NULL, NULL, NULL, NULL, 2, 1, 149, 2);

INSERT INTO operator_movement (
  transaction, balance_before, sale_after,
  amount, id_operator, id_user, reference,
  created_at, deleted_at, status, id_transaction,
  id_client, id_operator_account,
  movement_type, n_recu
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO operator_movement (transaction, balance_before, sale_after, amount, id_operator, id_user, reference, created_at, deleted_at, status, id_transaction, id_client, id_operator_account, movement_type, n_recu) VALUES ('CASH IN Moov Niger', '1666554.0000', NULL, '1000', 2, NULL, NULL, '2026-06-19 09:08:20', NULL, 0, NULL, 149, 'CPT-005', 'DEBIT', '202606190908200149068311');

INSERT INTO movement_account (
  compte, id_operation, operation, movement_type,
  amount, balance_before, sale_after,
  id_client, reference, date_update,
  id_user, created_at, deleted_at,
  status, n_recu, id_store, commission_avant,
  commission_apres
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO movement_account (compte, id_operation, operation, movement_type, amount, balance_before, sale_after, id_client, reference, date_update, id_user, created_at, deleted_at, status, n_recu, id_store, commission_avant, commission_apres) VALUES ('NCD0000000149', NULL, 'CASH IN Moov Niger', 'DEBIT', '1000', '10520.0000', NULL, '149', NULL, NULL, NULL, '2026-06-19 09:08:20', NULL, 0, '202606190908200149068311', NULL, '2943.5300', NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

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

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 = 149 FOR UPDATE;