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

Response
200 OK
IP
196.65.232.209
Profiled on
Token
671c27

Query Metrics

5 Database Queries
5 Different statements
222.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
148.75 ms
(67.00%) 		1 
INSERT INTO `order` (infos, order_paypal_id, created_by_id) VALUES (?, ?, ?)
Parameters: 
[
  "{"id":"4XS93334BG819642P","intent":"CAPTURE","status":"COMPLETED","payment_source":{"paypal":{"email_address":"ismail.amrani.ezzerrifi-buyer@gmail.com","account_id":"5SD5V6C3FRN94","account_status":"VERIFIED","name":{"given_name":"test","surname":"buyer"},"address":{"country_code":"US"}}},"purchase_units":[{"reference_id":"ebook_8","amount":{"currency_code":"USD","value":"19.00"},"payee":{"email_address":"amrani.ezzerrifi.amrani@gmail.com","merchant_id":"NNYRGL3QBXAZS"},"description":"la belle et la b\u00eate","shipping":{"name":{"full_name":"test buyer"},"address":{"address_line_1":"1 Main St","admin_area_2":"San Jose","admin_area_1":"CA","postal_code":"95131","country_code":"US"}},"supplementary_data":{"tax_nexus":[]},"payments":{"captures":[{"id":"35W97071321309453","status":"COMPLETED","amount":{"currency_code":"USD","value":"19.00"},"final_capture":true,"seller_protection":{"status":"ELIGIBLE","dispute_categories":["ITEM_NOT_RECEIVED","UNAUTHORIZED_TRANSACTION"]},"seller_receivable_breakdown":{"gross_amount":{"currency_code":"USD","value":"19.00"},"paypal_fee":{"currency_code":"USD","value":"1.23"},"net_amount":{"currency_code":"USD","value":"17.77"}},"links":[{"href":"https:\/\/api.sandbox.paypal.com\/v2\/payments\/captures\/35W97071321309453","rel":"self","method":"GET"},{"href":"https:\/\/api.sandbox.paypal.com\/v2\/payments\/captures\/35W97071321309453\/refund","rel":"refund","method":"POST"},{"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/4XS93334BG819642P","rel":"up","method":"GET"}],"create_time":"2026-01-19T15:11:57Z","update_time":"2026-01-19T15:11:57Z"}]}}],"payer":{"name":{"given_name":"test","surname":"buyer"},"email_address":"ismail.amrani.ezzerrifi-buyer@gmail.com","payer_id":"5SD5V6C3FRN94","address":{"country_code":"US"}},"create_time":"2026-01-19T15:11:57Z","update_time":"2026-01-19T15:11:57Z","links":[{"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/4XS93334BG819642P","rel":"self","method":"GET"}]}"
  "4XS93334BG819642P"
  6
]
View formatted query    View runnable query    Explain query
55.72 ms
(25.10%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
12.23 ms
(5.51%) 		1 
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: 
[
  "G1D3UJCEWaqMaR2D5WJ3tuOFcb1BLjZQZ5KWvOmWI4GMD03KGk9YyBYHxnhb3Ju8T5sISul39Z18W1S4bI6n2QmTK8YfxncoC7CeM4ckSLFXIZZS2mINCluX"
]
View formatted query    View runnable query    Explain query
3.93 ms
(1.77%) 		1 
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 = ?
Parameters: 
[
  "8"
]
View formatted query    View runnable query    Explain query
1.39 ms
(0.63%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.