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

Response
200 OK
Browse referrer URL
IP
41.248.52.167
Profiled on
Token
17b620

Query Metrics

6 Database Queries
6 Different statements
20.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
8.57 ms
(42.44%) 		1 
INSERT INTO `order` (infos, order_paypal_id, created_by_id) VALUES (?, ?, ?)
Parameters: 
[
  "{"id":"0U064354RL770234X","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_7","amount":{"currency_code":"USD","value":"13.00"},"payee":{"email_address":"amrani.ezzerrifi.amrani@gmail.com","merchant_id":"NNYRGL3QBXAZS"},"description":"The Smart Money Blueprint","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":"69T92746L05234124","status":"COMPLETED","amount":{"currency_code":"USD","value":"13.00"},"final_capture":true,"seller_protection":{"status":"ELIGIBLE","dispute_categories":["ITEM_NOT_RECEIVED","UNAUTHORIZED_TRANSACTION"]},"seller_receivable_breakdown":{"gross_amount":{"currency_code":"USD","value":"13.00"},"paypal_fee":{"currency_code":"USD","value":"0.94"},"net_amount":{"currency_code":"USD","value":"12.06"}},"links":[{"href":"https:\/\/api.sandbox.paypal.com\/v2\/payments\/captures\/69T92746L05234124","rel":"self","method":"GET"},{"href":"https:\/\/api.sandbox.paypal.com\/v2\/payments\/captures\/69T92746L05234124\/refund","rel":"refund","method":"POST"},{"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/0U064354RL770234X","rel":"up","method":"GET"}],"create_time":"2026-01-19T17:39:20Z","update_time":"2026-01-19T17:39:20Z"}]}}],"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-19T17:39:20Z","update_time":"2026-01-19T17:39:20Z","links":[{"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/0U064354RL770234X","rel":"self","method":"GET"}]}"
  "0U064354RL770234X"
  6
]
View formatted query    View runnable query    Explain query
3.58 ms
(17.75%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.49 ms
(17.29%) 		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: 
[
  "oSxzplPbyyzG6wfRgSbCvp1Lyvg6pOuS9BmJKeHO1dItURnKKp6NYUEoKyBE3BoEwzZwVLXC3uPiPlxyum8FJC3VB6tBEfweuzIyFCKHcjiGU07jr7CrP6RW"
]
View formatted query    View runnable query    Explain query
3.03 ms
(15.02%) 		1 
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 = ? LIMIT 1
Parameters: 
[
  "0U064354RL770234X"
]
View formatted query    View runnable query    Explain query
1.10 ms
(5.47%) 		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: 
[
  "7"
]
View formatted query    View runnable query    Explain query
0.41 ms
(2.04%) 		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\Order No errors.
App\Entity\User No errors.
App\Entity\Ebook No errors.
App\Entity\Msgs No errors.