GET https://montessori-algeria.com/payment/failure/202508182T?_locale=fr

Query Metrics

6 Database Queries
5 Different statements
5.06 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.99 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.establishment AS establishment_6, t0.formation_type AS formation_type_7, t0.created_at AS created_at_8, t0.reference AS reference_9, t0.order_id AS order_id_10, t0.payment_status AS payment_status_11, t0.voucher_number AS voucher_number_12, t0.payment_date AS payment_date_13, t0.amount_paid AS amount_paid_14, t0.stripe_payment_intent_id AS stripe_payment_intent_id_15, t0.payment_method AS payment_method_16 FROM inscription t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
  "202508182T"
]
2 0.85 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.establishment AS establishment_6, t0.formation_type AS formation_type_7, t0.created_at AS created_at_8, t0.reference AS reference_9, t0.order_id AS order_id_10, t0.payment_status AS payment_status_11, t0.voucher_number AS voucher_number_12, t0.payment_date AS payment_date_13, t0.amount_paid AS amount_paid_14, t0.stripe_payment_intent_id AS stripe_payment_intent_id_15, t0.payment_method AS payment_method_16 FROM inscription t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
  "202508182T"
]
3 0.35 ms
"START TRANSACTION"
Parameters:
[]
4 1.49 ms
INSERT INTO satim_errors (order_id, cardholder_name, deposit_amount, currency, approval_code, auth_code, order_status, order_number, pan, amount, ip, params, error_message, error_code, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "5gOg0ewYytyPBQAAGZY2"
  "**********"
  0
  "012"
  null
  2
  6
  "202508182T"
  "628058**6316"
  10000
  "192.168.49.49"
  "{"respCode_desc":"Votre transaction a \u00e9t\u00e9 rejet\u00e9e, veuillez contacter votre banque. Code erreur :41","udf1":"202508182T","respCode":"41"}"
  "Votre transaction a été rejetée, veuillez contacter votre banque. Code erreur :41"
  "41"
  "2025-08-21 13:03:14"
]
5 0.58 ms
"COMMIT"
Parameters:
[]
6 0.81 ms
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.cardholder_name AS cardholder_name_3, t0.deposit_amount AS deposit_amount_4, t0.currency AS currency_5, t0.approval_code AS approval_code_6, t0.auth_code AS auth_code_7, t0.order_status AS order_status_8, t0.order_number AS order_number_9, t0.pan AS pan_10, t0.amount AS amount_11, t0.ip AS ip_12, t0.params AS params_13, t0.error_message AS error_message_14, t0.error_code AS error_code_15, t0.created_at AS created_at_16 FROM satim_errors t0 WHERE t0.order_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "5gOg0ewYytyPBQAAGZY2"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Inscription No errors.
App\Entity\SatimErrors No errors.