POST https://book.api.7ap.tech/api_v2/refund_request?p=api_v2%2Frefund_request

Query Metrics

10 Database Queries
8 Different statements
164.97 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 17.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.token AS token_7, t0.available_requests AS available_requests_8, t0.is_actif AS is_actif_9, t0.code_activation AS code_activation_10, t0.device_id AS device_id_11, t0.last_resend_verif AS last_resend_verif_12, t0.number_resend_verif AS number_resend_verif_13, t0.ip AS ip_14, t0.secret AS secret_15 FROM `user` t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "fbZzdTkezrXApXGPi8dAofeEgxuFgnAltOFXPNqRVP7MhyqrQkZDjtOBXCgCiZW2IzEGaIbrUOfOo1b1OGinDV4ev2hXv5hQQwdk8vXH5sR2oGU32HLidm0y"
]
2 37.93 ms
SELECT t0.id AS id_1, t0.infos AS infos_2, t0.order_paypal_id AS order_paypal_id_3, t0.created_by_id AS created_by_id_4 FROM `order` t0 WHERE t0.order_paypal_id = ? AND t0.created_by_id = ? LIMIT 1
Parameters:
[
  "4U3949389Y569193K"
  6
]
3 7.77 ms
SELECT t0.id AS id_1, t0.reason AS reason_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.status AS status_5, t0.created_by_id AS created_by_id_6, t0.ordr_id AS ordr_id_7 FROM refund t0 WHERE t0.ordr_id = ? AND t0.created_by_id = ? LIMIT 1
Parameters:
[
  6
  6
]
4 10.82 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.image_url AS image_url_4, t0.description AS description_5, t0.sommaire AS sommaire_6, t0.prix AS prix_7, t0.pdf_url AS pdf_url_8, t0.is_best_seller AS is_best_seller_9, t0.categories AS categories_10, t0.created_by_id AS created_by_id_11 FROM ebook t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "8"
]
5 2.73 ms
"START TRANSACTION"
Parameters:
[]
6 33.56 ms
INSERT INTO refund (reason, comment, created_at, status, created_by_id, ordr_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "Technical issues with the file"
  "ddd"
  "2026-01-20 20:31:07"
  "PENDING"
  6
  6
]
7 37.84 ms
"COMMIT"
Parameters:
[]
8 0.89 ms
"START TRANSACTION"
Parameters:
[]
9 11.04 ms
INSERT INTO email (to_email, subject, template, context, file, status) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "ismail.eamrani@gmail.com"
  "Refund Request Submitted"
  "refund_request_email"
  "{"mail":"ismail.eamrani@gmail.com","firstname":"Ismail AMRANI ezzerrifi","ebook_title":"la belle et la b\u00eate","order_id":"4U3949389Y569193K","reason":"Technical issues with the file","comment":"ddd"}"
  null
  null
]
10 4.92 ms
"COMMIT"
Parameters:
[]

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\User No errors.
App\Entity\Ebook No errors.
App\Entity\Msgs No errors.
App\Entity\Order No errors.
App\Entity\Refund No errors.
App\Entity\Email No errors.