Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.transaction_number AS transaction_number_2,
  t0.creation_date AS creation_date_3,
  t0.status AS status_4,
  t0.amount AS amount_5,
  t0.provider_status AS provider_status_6,
  t0.currency AS currency_7,
  t0.update_date AS update_date_8,
  t0.description AS description_9,
  t0.client_operator AS client_operator_10,
  t0.wallet AS wallet_11,
  t0.financial_transaction AS financial_transaction_12,
  t0.amount_usd AS amount_usd_13,
  t0.exchange_rate AS exchange_rate_14,
  t0.financial_transaction_url AS financial_transaction_url_15,
  t0.folder_id AS folder_id_16,
  t0.user_id AS user_id_17
FROM
  transaction t0
WHERE
  t0.financial_transaction = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.transaction_number AS transaction_number_2, t0.creation_date AS creation_date_3, t0.status AS status_4, t0.amount AS amount_5, t0.provider_status AS provider_status_6, t0.currency AS currency_7, t0.update_date AS update_date_8, t0.description AS description_9, t0.client_operator AS client_operator_10, t0.wallet AS wallet_11, t0.financial_transaction AS financial_transaction_12, t0.amount_usd AS amount_usd_13, t0.exchange_rate AS exchange_rate_14, t0.financial_transaction_url AS financial_transaction_url_15, t0.folder_id AS folder_id_16, t0.user_id AS user_id_17 FROM transaction t0 WHERE t0.financial_transaction = '019fab00-a246-731d-ba60-26bf7f492840' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO transaction_log (
  TYPE, payload, http_status, created_at,
  transaction_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO transaction_log (TYPE, payload, http_status, created_at, transaction_id) VALUES ('callback', '{\"scope\":\"C2B\",\"status\":\"TF\",\"message\":\"B2C Detail error notification\",\"txnId\":\"019fab00-a246-731d-ba60-26bf7f492840\",\"callbackReference\":\"-1\"}', NULL, '2026-07-28 23:14:06', 208);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  transaction
SET
  STATUS = ?,
  provider_status = ?,
  update_date = ?
WHERE
  id = ?

UPDATE transaction SET STATUS = 'FAILED', provider_status = 'TF', update_date = '2026-07-28 23:14:19' WHERE id = 208;

INSERT INTO transaction_audit (
  TYPE, object_id, discriminator, transaction_hash,
  diffs, blame_id, blame_user, blame_user_fqdn,
  blame_user_firewall, ip, created_at
)
VALUES
  (
    :type, :object_id, :discriminator,
    :transaction_hash, :diffs, :blame_id,
    :blame_user, :blame_user_fqdn, :blame_user_firewall,
    :ip, :created_at
  )

INSERT INTO transaction_audit (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('update', '208', NULL, '22fd5848701389df4e6dcdde0ab09b1e9d2475d2', '{\"status\":{\"new\":\"FAILED\",\"old\":\"PENDING\"},\"providerStatus\":{\"new\":\"TF\",\"old\":null},\"updateDate\":{\"new\":\"2026-07-28 23:14:19\",\"old\":null}}', NULL, NULL, NULL, 'main', '172.68.247.27', '2026-07-28 23:14:19.758349');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.is_deleted AS is_deleted_3,
  t0.date_validation AS date_validation_4,
  t0.date_create AS date_create_5,
  t0.date_update AS date_update_6,
  t0.date_sign AS date_sign_7,
  t0.request_id AS request_id_8,
  t0.authority_name AS authority_name_9,
  t0.number AS number_10,
  t0.date_cancellation AS date_cancellation_11,
  t0.cancellation_comment AS cancellation_comment_12,
  t0.numero_qr AS numero_qr_13,
  t0.approved AS approved_14,
  t0.approved_at AS approved_at_15,
  t0.to_deliver AS to_deliver_16,
  t0.user_create_id AS user_create_id_17,
  t0.user_validation_id AS user_validation_id_18,
  t0.document_category_id AS document_category_id_19,
  t0.site_id AS site_id_20,
  t0.user_update_id AS user_update_id_21,
  t0.user_autority_id AS user_autority_id_22,
  t0.beneficiary_id AS beneficiary_id_23,
  t24.id AS id_25,
  t24.lastname AS lastname_26,
  t24.postname AS postname_27,
  t24.firstname AS firstname_28,
  t24.birth_place AS birth_place_29,
  t24.birth_date AS birth_date_30,
  t24.is_deleted AS is_deleted_31,
  t24.sexe AS sexe_32,
  t24.photo AS photo_33,
  t24.date_create AS date_create_34,
  t24.date_update AS date_update_35,
  t24.registration_number AS registration_number_36,
  t24.origine_text AS origine_text_37,
  t24.adresse AS adresse_38,
  t24.civilite AS civilite_39,
  t24.e_civil AS e_civil_40,
  t24.origine_id AS origine_id_41,
  t24.user_create_id AS user_create_id_42,
  t24.user_update_id AS user_update_id_43,
  t24.nationality_id AS nationality_id_44,
  t24.profession_id AS profession_id_45,
  t24.registration_site_id AS registration_site_id_46,
  t0.user_cancellation_id AS user_cancellation_id_47,
  t0.pcode_id AS pcode_id_48,
  t0.approved_by_id AS approved_by_id_49
FROM
  folder t0
  LEFT JOIN identite t24 ON t0.beneficiary_id = t24.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.is_deleted AS is_deleted_3, t0.date_validation AS date_validation_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.date_sign AS date_sign_7, t0.request_id AS request_id_8, t0.authority_name AS authority_name_9, t0.number AS number_10, t0.date_cancellation AS date_cancellation_11, t0.cancellation_comment AS cancellation_comment_12, t0.numero_qr AS numero_qr_13, t0.approved AS approved_14, t0.approved_at AS approved_at_15, t0.to_deliver AS to_deliver_16, t0.user_create_id AS user_create_id_17, t0.user_validation_id AS user_validation_id_18, t0.document_category_id AS document_category_id_19, t0.site_id AS site_id_20, t0.user_update_id AS user_update_id_21, t0.user_autority_id AS user_autority_id_22, t0.beneficiary_id AS beneficiary_id_23, t24.id AS id_25, t24.lastname AS lastname_26, t24.postname AS postname_27, t24.firstname AS firstname_28, t24.birth_place AS birth_place_29, t24.birth_date AS birth_date_30, t24.is_deleted AS is_deleted_31, t24.sexe AS sexe_32, t24.photo AS photo_33, t24.date_create AS date_create_34, t24.date_update AS date_update_35, t24.registration_number AS registration_number_36, t24.origine_text AS origine_text_37, t24.adresse AS adresse_38, t24.civilite AS civilite_39, t24.e_civil AS e_civil_40, t24.origine_id AS origine_id_41, t24.user_create_id AS user_create_id_42, t24.user_update_id AS user_update_id_43, t24.nationality_id AS nationality_id_44, t24.profession_id AS profession_id_45, t24.registration_site_id AS registration_site_id_46, t0.user_cancellation_id AS user_cancellation_id_47, t0.pcode_id AS pcode_id_48, t0.approved_by_id AS approved_by_id_49 FROM folder t0 LEFT JOIN identite t24 ON t0.beneficiary_id = t24.id WHERE t0.id = 1312725;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.number AS number_3,
  t0.html_model AS html_model_4,
  t0.is_deleted AS is_deleted_5,
  t0.date_create AS date_create_6,
  t0.date_update AS date_update_7,
  t0.status AS status_8,
  t0.is_base_document AS is_base_document_9,
  t0.can_add_identity AS can_add_identity_10,
  t0.can_select_same_identity AS can_select_same_identity_11,
  t0.anchor_beneficiaire AS anchor_beneficiaire_12,
  t0.for_internet_user AS for_internet_user_13,
  t0.is_published AS is_published_14,
  t0.icon_class AS icon_class_15,
  t0.service_id AS service_id_16,
  t0.user_create_id AS user_create_id_17,
  t0.user_update_id AS user_update_id_18
FROM
  document_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.number AS number_3, t0.html_model AS html_model_4, t0.is_deleted AS is_deleted_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.status AS status_8, t0.is_base_document AS is_base_document_9, t0.can_add_identity AS can_add_identity_10, t0.can_select_same_identity AS can_select_same_identity_11, t0.anchor_beneficiaire AS anchor_beneficiaire_12, t0.for_internet_user AS for_internet_user_13, t0.is_published AS is_published_14, t0.icon_class AS icon_class_15, t0.service_id AS service_id_16, t0.user_create_id AS user_create_id_17, t0.user_update_id AS user_update_id_18 FROM document_category t0 WHERE t0.id = 57;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.is_deleted AS is_deleted_3,
  t0.date_update AS date_update_4,
  t0.date_create AS date_create_5,
  t0.authority_name AS authority_name_6,
  t0.signature_file AS signature_file_7,
  t0.parent_id AS parent_id_8,
  t0.user_create_id AS user_create_id_9,
  t0.user_update_id AS user_update_id_10,
  t0.pcode_id AS pcode_id_11,
  t0.type_site_id AS type_site_id_12
FROM
  sites t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.is_deleted AS is_deleted_3, t0.date_update AS date_update_4, t0.date_create AS date_create_5, t0.authority_name AS authority_name_6, t0.signature_file AS signature_file_7, t0.parent_id AS parent_id_8, t0.user_create_id AS user_create_id_9, t0.user_update_id AS user_update_id_10, t0.pcode_id AS pcode_id_11, t0.type_site_id AS type_site_id_12 FROM sites t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.user_type AS user_type_4,
  t0.mail AS mail_5,
  t0.telephone AS telephone_6,
  t0.is_authority AS is_authority_7,
  t0.signature AS signature_8,
  t0.login AS login_9,
  t0.is_deleted AS is_deleted_10,
  t0.status AS status_11,
  t0.date_create AS date_create_12,
  t0.last_connection AS last_connection_13,
  t0.otp AS otp_14,
  t0.time_otp AS time_otp_15,
  t0.first_login AS first_login_16,
  t0.update_password_date AS update_password_date_17,
  t0.deleted_date AS deleted_date_18,
  t0.user_deleted AS user_deleted_19,
  t0.u_id AS u_id_20,
  t0.site_id AS site_id_21
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.user_type AS user_type_4, t0.mail AS mail_5, t0.telephone AS telephone_6, t0.is_authority AS is_authority_7, t0.signature AS signature_8, t0.login AS login_9, t0.is_deleted AS is_deleted_10, t0.status AS status_11, t0.date_create AS date_create_12, t0.last_connection AS last_connection_13, t0.otp AS otp_14, t0.time_otp AS time_otp_15, t0.first_login AS first_login_16, t0.update_password_date AS update_password_date_17, t0.deleted_date AS deleted_date_18, t0.user_deleted AS user_deleted_19, t0.u_id AS u_id_20, t0.site_id AS site_id_21 FROM users t0 WHERE t0.id = 106;