Query Metrics
6
Database Queries
5
Different statements
5.06 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |