Query Metrics
8
Database Queries
6
Different statements
10.63 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.56 ms (33.48%) |
1 |
INSERT INTO `order` (uuid, external_id, order_number, receipt, status, amount, email, phone, fio, link, refund_id, refund_amount, created_at, client_id, module_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "996ec7ca-5a04-4a89-a1b5-541c0ade4eac" 107523 "107523A" "{"shopId":"wysh-shop","invoiceUuid":"996ec7ca-5a04-4a89-a1b5-541c0ade4eac","invoiceType":"link","amount":24283,"currency":"RUB","orderNumber":"107523A","orderId":107523,"siteUrl":"https:\/\/wysh.shop\/","returnUrl":"https:\/\/imshop.wysh.shop\/success","items":[{"name":"Черные челси с пирсингом и сердцем (39, Черный, Демисезон, Натуральная кожа, Турция)","price":17990,"quantity":1,"measurementUnit":"шт","vat":"none","paymentMethod":"full_prepayment","paymentObject":"commodity"},{"name":"Шикарные сапоги в цвете крем-брюле на тракторной подошве (Крем-брюле, Демисезон, 39, Натуральная кожа, Турция)","price":6293,"quantity":1,"measurementUnit":"шт.","vat":"none","paymentMethod":"full_prepayment","paymentObject":"commodity"}],"customer":{"email":"rakitina.anastasia@yandex.ru","phone":"79870191668","firstName":"Анастасия","lastName":"Ракитина","patronymic":"Сергеевна","contragentType":"individual"}}" "new" 24283.0 "rakitina.anastasia@yandex.ru" "79870191668" "РакитинаАнастасияСергеевна" null null null "2024-11-14 17:30:00" 1 1 ] |
1.71 ms (16.13%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.api_token AS api_token_3, t0.login AS login_4, t0.password AS password_5, t0.cert AS cert_6, t0.keyCode AS keyCode_7, t0.client_id AS client_id_8 FROM module t0 WHERE t0.client_id = ?
Parameters:
[
1
]
|
1.63 ms (15.37%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2 FROM `client` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"ooo-wysh"
]
|
1.42 ms (13.34%) |
1 |
UPDATE `order` SET link = ? WHERE uuid = ?
Parameters:
[ "https://dolyame.ru/form/32a43892-5f3e-4b44-ae9c-a48609fd940c?values=eyJzdG9yZSI6eyJpbWFnZUxvZ28iOiJodHRwczovL2JyYW5kcy1wcm9kLmNkbi10aW5rb2ZmLnJ1L2dlbmVyYWxfbG9nby93eXNoLWJyYW5kLW5ldy5wbmc/dGltZXN0YW1wPTE3MDkxMjIxMTg3ODQiLCJjb21wYW55TmFtZSI6Ild5c2gifSwib3B0aW9ucyI6eyJvcmRlckFtb3VudCI6MjQyODMsImZpcnN0UGF5bWVudEFtb3VudCI6bnVsbCwicGF5bWVudEFmdGVyRGVsaXZlcnkiOmZhbHNlfSwiY29udGFjdCI6eyJtb2JpbGVQaG9uZSI6Iis3OTg3MDE5MTY2OCJ9fQ" "996ec7ca-5a04-4a89-a1b5-541c0ade4eac" ] |
1.30 ms (12.23%) |
2 |
"COMMIT"
Parameters:
[] |
1.00 ms (9.45%) |
2 |
"START TRANSACTION"
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\Client | No errors. |
App\Entity\Order | No errors. |
App\Entity\Module | No errors. |