Query Metrics
128
Database Queries
11
Different statements
50.66 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16.07 ms (31.72%) |
20 |
SELECT pg.id AS pg_id, pg.name AS pg_name, p.name AS p_name, p.in_short AS p_short, pp.value AS value FROM goods.proposal_parameter pp INNER JOIN goods.parameter p ON p.id = pp.parameter_id INNER JOIN goods.parameters_group pg ON pg.id = p.parameters_group_id WHERE pp.proposal_id = ? ORDER BY pg.id ASC, p.id ASC
Parameters:
[
"e6c63b4b-3c52-4670-ba1b-6b8546058bb3"
]
|
||||||||||||||||||||||||||||||
7.13 ms (14.08%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.is_archive AS is_archive_5, t0.date_add AS date_add_6, t0.end_date AS end_date_7, t0.is_private AS is_private_8, t0.items_count AS items_count_9, t0.delivery_method AS delivery_method_10, t0.payload AS payload_11, t0.category_id AS category_id_12, t0.item_id AS item_id_13, t0.owner_id AS owner_id_14 FROM goods.proposal t0 WHERE t0.id = ?
Parameters:
[
"e6c63b4b-3c52-4670-ba1b-6b8546058bb3"
]
|
||||||||||||||||||||||||||||||
6.42 ms (12.68%) |
20 |
SELECT COUNT(id) AS total, MIN(price)::int AS start_price, MAX(price)::int AS end_price FROM trade.auction_offer WHERE proposal_id = ? GROUP BY proposal_id
Parameters:
[
"e6c63b4b-3c52-4670-ba1b-6b8546058bb3"
]
|
||||||||||||||||||||||||||||||
5.21 ms (10.29%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronymic AS patronymic_4, t0.gender AS gender_5, t0.birthdate AS birthdate_6, t0.email AS email_7, t0.phone AS phone_8, t0.avatar AS avatar_9, t0.user_id AS user_id_10 FROM account.person t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
"b19cf6bf-4799-4796-aa11-ee31467761cd"
]
|
||||||||||||||||||||||||||||||
4.60 ms (9.08%) |
20 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = ?
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#919 : "b19cf6bf-4799-4796-aa11-ee31467761cd" } ] |
||||||||||||||||||||||||||||||
3.73 ms (7.37%) |
20 |
SELECT cnt FROM counters.proposal_view WHERE id = ?
Parameters:
[
"e6c63b4b-3c52-4670-ba1b-6b8546058bb3"
]
|
||||||||||||||||||||||||||||||
2.99 ms (5.91%) |
2 |
SELECT MIN(p.price) AS min_price, MAX(p.price) AS max_price FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ "94b872da-0958-4ff5-b211-40c724fd076d" "a0f55932-0dc0-4b96-bf26-0f3f607f7d47" "9d236378-53ae-49fc-8b91-fe713f15607c" "651574b2-fe7f-40f0-9cba-6d9654657589" "7ae0f226-511d-4aab-8434-b7a0b5358c87" "1bf94b62-3f56-4eb3-8a9f-112a4074d5f1" "c5924499-d1e7-4941-a173-b138ce490a58" "85174a0a-93e9-4132-b74f-cd01efc7bf0c" "fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef" "e35f1b4d-112b-4705-88f4-ad711ecdfc60" "421b3b2e-abea-4aa0-a748-230166d96103" "2c814812-d3b1-4f0b-bd3e-df9da0492ef7" "44290fb9-ddcc-41ff-833f-ffbde7e20cbe" "09be0bdb-6649-40af-85be-73ee69470eb4" "a14f705c-5b3e-4f45-a737-81f308fb7d58" "9940ad45-e3d8-4be3-ad0a-f5065575814e" "76cebea6-e6ae-428c-bfcb-545335318f6c" "d1e6d876-ddb2-4fa7-ba81-c1ed7e27b313" "b1220720-ddb4-4f7e-93de-58dce11810a2" "7df1e307-3b89-4508-a029-757228733628" "54ce519a-0363-4244-b56c-d3f1ffb8c3a4" "6540f02a-f691-446b-8efe-28d1b68eeb0e" "cb2edf57-9500-485a-aea9-033063e845e2" "f4ed1e97-e341-42dd-bcde-88b0fdcd5810" "2dd24a20-f836-4f49-aeb2-29feaf51ef1c" "d4982eaa-8475-417a-9609-1281e8d65780" "958f909b-c59c-42e5-b7b7-c4a399d2fe0c" "ea168356-1e34-45df-99c9-d82ebd6824bf" "790916a7-bd91-48dd-886b-adafad846b86" "55a6f9e6-d278-4d60-8a87-b19500c5c6a0" "46c239bf-f07e-47be-993a-ec7d45ba0797" "d739120e-bc14-4ff9-a079-55a93c91795b" "7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b" "6242c6c8-1d3b-499d-a3f9-31835e92def6" "f1c7dfda-d7c9-4702-a14f-7847ae301e0c" "2b129ce4-b25b-4ad4-9549-781deea34dab" "8e13f4e7-accf-4070-9cae-1db8f0229f52" "5388e8b9-5e83-475c-b172-cc20e247faac" "315382d0-f96e-4423-a755-c6eac4253f03" "e6f2c8c8-14fb-4516-bb16-7a6bc2d999c9" "5c54aa77-9ab7-4d55-8833-7167e64cc0b6" "2e51abf8-8cb3-41dd-a01a-1f4a0afc78ef" "493fc6e4-1de7-4f42-9ac8-b5ec65148100" "fd344554-d3b4-4571-b21c-9db72f2cef9e" "bc8c558c-8051-4928-bbe9-9b8a8900588c" "c87baeee-723e-41e2-b3ce-5705f989f5d7" "3ae07b44-5a2f-4cb7-afb1-6c606d458b39" "26197838-fd64-4fd6-806f-f6411e5223d3" "6227032b-8045-4ec9-ba72-321372167d57" "20813c9e-2a83-4c18-9088-60b2e829d1e1" ]
|
||||||||||||||||||||||||||||||
1.83 ms (3.61%) |
1 |
SELECT id, name, parent_id FROM goods.category
Parameters:
[] |
||||||||||||||||||||||||||||||
1.35 ms (2.66%) |
1 |
SELECT p.id FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p.price >= ?) AND (p.price <= ?) ORDER BY p.date_add DESC LIMIT 20
Parameters:
[ "94b872da-0958-4ff5-b211-40c724fd076d" "a0f55932-0dc0-4b96-bf26-0f3f607f7d47" "9d236378-53ae-49fc-8b91-fe713f15607c" "651574b2-fe7f-40f0-9cba-6d9654657589" "7ae0f226-511d-4aab-8434-b7a0b5358c87" "1bf94b62-3f56-4eb3-8a9f-112a4074d5f1" "c5924499-d1e7-4941-a173-b138ce490a58" "85174a0a-93e9-4132-b74f-cd01efc7bf0c" "fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef" "e35f1b4d-112b-4705-88f4-ad711ecdfc60" "421b3b2e-abea-4aa0-a748-230166d96103" "2c814812-d3b1-4f0b-bd3e-df9da0492ef7" "44290fb9-ddcc-41ff-833f-ffbde7e20cbe" "09be0bdb-6649-40af-85be-73ee69470eb4" "a14f705c-5b3e-4f45-a737-81f308fb7d58" "9940ad45-e3d8-4be3-ad0a-f5065575814e" "76cebea6-e6ae-428c-bfcb-545335318f6c" "d1e6d876-ddb2-4fa7-ba81-c1ed7e27b313" "b1220720-ddb4-4f7e-93de-58dce11810a2" "7df1e307-3b89-4508-a029-757228733628" "54ce519a-0363-4244-b56c-d3f1ffb8c3a4" "6540f02a-f691-446b-8efe-28d1b68eeb0e" "cb2edf57-9500-485a-aea9-033063e845e2" "f4ed1e97-e341-42dd-bcde-88b0fdcd5810" "2dd24a20-f836-4f49-aeb2-29feaf51ef1c" "d4982eaa-8475-417a-9609-1281e8d65780" "958f909b-c59c-42e5-b7b7-c4a399d2fe0c" "ea168356-1e34-45df-99c9-d82ebd6824bf" "790916a7-bd91-48dd-886b-adafad846b86" "55a6f9e6-d278-4d60-8a87-b19500c5c6a0" "46c239bf-f07e-47be-993a-ec7d45ba0797" "d739120e-bc14-4ff9-a079-55a93c91795b" "7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b" "6242c6c8-1d3b-499d-a3f9-31835e92def6" "f1c7dfda-d7c9-4702-a14f-7847ae301e0c" "2b129ce4-b25b-4ad4-9549-781deea34dab" "8e13f4e7-accf-4070-9cae-1db8f0229f52" "5388e8b9-5e83-475c-b172-cc20e247faac" "315382d0-f96e-4423-a755-c6eac4253f03" "e6f2c8c8-14fb-4516-bb16-7a6bc2d999c9" "5c54aa77-9ab7-4d55-8833-7167e64cc0b6" "2e51abf8-8cb3-41dd-a01a-1f4a0afc78ef" "493fc6e4-1de7-4f42-9ac8-b5ec65148100" "fd344554-d3b4-4571-b21c-9db72f2cef9e" "bc8c558c-8051-4928-bbe9-9b8a8900588c" "c87baeee-723e-41e2-b3ce-5705f989f5d7" "3ae07b44-5a2f-4cb7-afb1-6c606d458b39" "26197838-fd64-4fd6-806f-f6411e5223d3" "6227032b-8045-4ec9-ba72-321372167d57" "20813c9e-2a83-4c18-9088-60b2e829d1e1" 0 1000000 ]
|
||||||||||||||||||||||||||||||
0.68 ms (1.33%) |
3 |
SELECT COUNT(id) AS new FROM trade.auction_offer WHERE (proposal_id = ?) AND (state = 0) GROUP BY proposal_id
Parameters:
[
"2f561b5a-51dd-420a-866b-465d5b411768"
]
|
||||||||||||||||||||||||||||||
0.65 ms (1.28%) |
1 |
SELECT COUNT(p.id) FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ "94b872da-0958-4ff5-b211-40c724fd076d" "a0f55932-0dc0-4b96-bf26-0f3f607f7d47" "9d236378-53ae-49fc-8b91-fe713f15607c" "651574b2-fe7f-40f0-9cba-6d9654657589" "7ae0f226-511d-4aab-8434-b7a0b5358c87" "1bf94b62-3f56-4eb3-8a9f-112a4074d5f1" "c5924499-d1e7-4941-a173-b138ce490a58" "85174a0a-93e9-4132-b74f-cd01efc7bf0c" "fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef" "e35f1b4d-112b-4705-88f4-ad711ecdfc60" "421b3b2e-abea-4aa0-a748-230166d96103" "2c814812-d3b1-4f0b-bd3e-df9da0492ef7" "44290fb9-ddcc-41ff-833f-ffbde7e20cbe" "09be0bdb-6649-40af-85be-73ee69470eb4" "a14f705c-5b3e-4f45-a737-81f308fb7d58" "9940ad45-e3d8-4be3-ad0a-f5065575814e" "76cebea6-e6ae-428c-bfcb-545335318f6c" "d1e6d876-ddb2-4fa7-ba81-c1ed7e27b313" "b1220720-ddb4-4f7e-93de-58dce11810a2" "7df1e307-3b89-4508-a029-757228733628" "54ce519a-0363-4244-b56c-d3f1ffb8c3a4" "6540f02a-f691-446b-8efe-28d1b68eeb0e" "cb2edf57-9500-485a-aea9-033063e845e2" "f4ed1e97-e341-42dd-bcde-88b0fdcd5810" "2dd24a20-f836-4f49-aeb2-29feaf51ef1c" "d4982eaa-8475-417a-9609-1281e8d65780" "958f909b-c59c-42e5-b7b7-c4a399d2fe0c" "ea168356-1e34-45df-99c9-d82ebd6824bf" "790916a7-bd91-48dd-886b-adafad846b86" "55a6f9e6-d278-4d60-8a87-b19500c5c6a0" "46c239bf-f07e-47be-993a-ec7d45ba0797" "d739120e-bc14-4ff9-a079-55a93c91795b" "7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b" "6242c6c8-1d3b-499d-a3f9-31835e92def6" "f1c7dfda-d7c9-4702-a14f-7847ae301e0c" "2b129ce4-b25b-4ad4-9549-781deea34dab" "8e13f4e7-accf-4070-9cae-1db8f0229f52" "5388e8b9-5e83-475c-b172-cc20e247faac" "315382d0-f96e-4423-a755-c6eac4253f03" "e6f2c8c8-14fb-4516-bb16-7a6bc2d999c9" "5c54aa77-9ab7-4d55-8833-7167e64cc0b6" "2e51abf8-8cb3-41dd-a01a-1f4a0afc78ef" "493fc6e4-1de7-4f42-9ac8-b5ec65148100" "fd344554-d3b4-4571-b21c-9db72f2cef9e" "bc8c558c-8051-4928-bbe9-9b8a8900588c" "c87baeee-723e-41e2-b3ce-5705f989f5d7" "3ae07b44-5a2f-4cb7-afb1-6c606d458b39" "26197838-fd64-4fd6-806f-f6411e5223d3" "6227032b-8045-4ec9-ba72-321372167d57" "20813c9e-2a83-4c18-9088-60b2e829d1e1" ]
|
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\Goods\Proposal |
|
App\Entity\Goods\Category |
|
App\Entity\Goods\Item | No errors. |
App\Entity\Account\User | No errors. |
App\Entity\Goods\ProposalParameter | No errors. |
App\Entity\Account\Person | No errors. |