1
1.83 ms
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
2
2.41 ms
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 "
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
)
Copy
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 ('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' ));
Copy
3
1.35 ms
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
]
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
Copy
SELECT p . id FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('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' )) AND (p . price > = 0 ) AND (p . price < = 1000000 ) ORDER BY p . date_add DESC LIMIT 20 ;
Copy
4
0.58 ms
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 "
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
)
Copy
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 ('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' ));
Copy
5
1.44 ms
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 "
]
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 = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' ;
Copy
6
1.36 ms
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 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' GROUP BY proposal_id ;
Copy
7
0.41 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"e6c63b4b-3c52-4670-ba1b-6b8546058bb3 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' ;
Copy
8
0.68 ms
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 "
]
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' LIMIT 1 ;
Copy
9
0.41 ms
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 = ?
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' ;
Copy
10
2.00 ms
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 "
]
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 = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' ORDER BY pg . id ASC , p . id ASC ;
Copy
11
0.43 ms
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 :
[
"d2882f95-93d1-4f36-81de-aee1a2cb25c1 "
]
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 = 'd2882f95-93d1-4f36-81de-aee1a2cb25c1' ;
Copy
12
0.28 ms
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 :
[
"d2882f95-93d1-4f36-81de-aee1a2cb25c1 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'd2882f95-93d1-4f36-81de-aee1a2cb25c1' GROUP BY proposal_id ;
Copy
13
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"d2882f95-93d1-4f36-81de-aee1a2cb25c1 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'd2882f95-93d1-4f36-81de-aee1a2cb25c1' ;
Copy
14
0.21 ms
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 "
]
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' LIMIT 1 ;
Copy
15
0.19 ms
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 = ?
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' ;
Copy
16
0.68 ms
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 :
[
"d2882f95-93d1-4f36-81de-aee1a2cb25c1 "
]
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 = 'd2882f95-93d1-4f36-81de-aee1a2cb25c1' ORDER BY pg . id ASC , p . id ASC ;
Copy
17
0.28 ms
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 :
[
"2f561b5a-51dd-420a-866b-465d5b411768 "
]
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 = '2f561b5a-51dd-420a-866b-465d5b411768' ;
Copy
18
0.26 ms
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 :
[
"2f561b5a-51dd-420a-866b-465d5b411768 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '2f561b5a-51dd-420a-866b-465d5b411768' GROUP BY proposal_id ;
Copy
19
0.31 ms
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 "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = '2f561b5a-51dd-420a-866b-465d5b411768' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
20
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"2f561b5a-51dd-420a-866b-465d5b411768 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '2f561b5a-51dd-420a-866b-465d5b411768' ;
Copy
21
0.21 ms
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 :
[
"013239b0-b19f-4944-b285-e9dfbcd5704d "
]
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 = '013239b0-b19f-4944-b285-e9dfbcd5704d' LIMIT 1 ;
Copy
22
0.19 ms
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 = ?
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 = '013239b0-b19f-4944-b285-e9dfbcd5704d' ;
Copy
23
0.68 ms
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 :
[
"2f561b5a-51dd-420a-866b-465d5b411768 "
]
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 = '2f561b5a-51dd-420a-866b-465d5b411768' ORDER BY pg . id ASC , p . id ASC ;
Copy
24
0.26 ms
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 :
[
"358aadd3-f59f-4740-98b9-bf4991b7c5d3 "
]
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 = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' ;
Copy
25
0.23 ms
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 :
[
"358aadd3-f59f-4740-98b9-bf4991b7c5d3 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' GROUP BY proposal_id ;
Copy
26
0.19 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"358aadd3-f59f-4740-98b9-bf4991b7c5d3 "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
27
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"358aadd3-f59f-4740-98b9-bf4991b7c5d3 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' ;
Copy
28
0.20 ms
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 "
]
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' LIMIT 1 ;
Copy
29
0.17 ms
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 = ?
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' ;
Copy
30
0.53 ms
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 :
[
"358aadd3-f59f-4740-98b9-bf4991b7c5d3 "
]
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 = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' ORDER BY pg . id ASC , p . id ASC ;
Copy
31
0.21 ms
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 :
[
"8ab018d3-c7a1-4b72-93c8-8fda044e92ea "
]
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 = '8ab018d3-c7a1-4b72-93c8-8fda044e92ea' ;
Copy
32
0.22 ms
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 :
[
"8ab018d3-c7a1-4b72-93c8-8fda044e92ea "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '8ab018d3-c7a1-4b72-93c8-8fda044e92ea' GROUP BY proposal_id ;
Copy
33
0.17 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"8ab018d3-c7a1-4b72-93c8-8fda044e92ea "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = '8ab018d3-c7a1-4b72-93c8-8fda044e92ea' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
34
0.14 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"8ab018d3-c7a1-4b72-93c8-8fda044e92ea "
]
SELECT cnt FROM counters . proposal_view WHERE id = '8ab018d3-c7a1-4b72-93c8-8fda044e92ea' ;
Copy
35
0.25 ms
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 "
]
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' LIMIT 1 ;
Copy
36
0.18 ms
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 = ?
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' ;
Copy
37
0.64 ms
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 :
[
"8ab018d3-c7a1-4b72-93c8-8fda044e92ea "
]
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 = '8ab018d3-c7a1-4b72-93c8-8fda044e92ea' ORDER BY pg . id ASC , p . id ASC ;
Copy
38
0.22 ms
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 :
[
"d74dd3d4-8819-4bbd-beda-44591753650c "
]
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 = 'd74dd3d4-8819-4bbd-beda-44591753650c' ;
Copy
39
0.20 ms
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 :
[
"d74dd3d4-8819-4bbd-beda-44591753650c "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'd74dd3d4-8819-4bbd-beda-44591753650c' GROUP BY proposal_id ;
Copy
40
0.13 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"d74dd3d4-8819-4bbd-beda-44591753650c "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'd74dd3d4-8819-4bbd-beda-44591753650c' ;
Copy
41
0.18 ms
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 :
[
"a94c1907-f056-4542-a3de-aacdd561b656 "
]
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 = 'a94c1907-f056-4542-a3de-aacdd561b656' LIMIT 1 ;
Copy
42
0.17 ms
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 = ?
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 = 'a94c1907-f056-4542-a3de-aacdd561b656' ;
Copy
43
0.58 ms
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 :
[
"d74dd3d4-8819-4bbd-beda-44591753650c "
]
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 = 'd74dd3d4-8819-4bbd-beda-44591753650c' ORDER BY pg . id ASC , p . id ASC ;
Copy
44
0.36 ms
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 :
[
"dd2d640e-48fe-4f02-8d11-bbc14137884c "
]
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 = 'dd2d640e-48fe-4f02-8d11-bbc14137884c' ;
Copy
45
0.31 ms
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 :
[
"dd2d640e-48fe-4f02-8d11-bbc14137884c "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'dd2d640e-48fe-4f02-8d11-bbc14137884c' GROUP BY proposal_id ;
Copy
46
0.21 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"dd2d640e-48fe-4f02-8d11-bbc14137884c "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'dd2d640e-48fe-4f02-8d11-bbc14137884c' ;
Copy
47
0.21 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
48
0.19 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
49
0.81 ms
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 :
[
"dd2d640e-48fe-4f02-8d11-bbc14137884c "
]
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 = 'dd2d640e-48fe-4f02-8d11-bbc14137884c' ORDER BY pg . id ASC , p . id ASC ;
Copy
50
0.31 ms
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 :
[
"21d4fbfa-279f-4972-9a0e-01cad228c175 "
]
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 = '21d4fbfa-279f-4972-9a0e-01cad228c175' ;
Copy
51
0.29 ms
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 :
[
"21d4fbfa-279f-4972-9a0e-01cad228c175 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '21d4fbfa-279f-4972-9a0e-01cad228c175' GROUP BY proposal_id ;
Copy
52
0.24 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"21d4fbfa-279f-4972-9a0e-01cad228c175 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '21d4fbfa-279f-4972-9a0e-01cad228c175' ;
Copy
53
0.26 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
54
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
55
0.84 ms
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 :
[
"21d4fbfa-279f-4972-9a0e-01cad228c175 "
]
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 = '21d4fbfa-279f-4972-9a0e-01cad228c175' ORDER BY pg . id ASC , p . id ASC ;
Copy
56
0.35 ms
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 :
[
"49f8d5bd-f26f-4095-bacf-14bab5630357 "
]
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 = '49f8d5bd-f26f-4095-bacf-14bab5630357' ;
Copy
57
0.30 ms
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 :
[
"49f8d5bd-f26f-4095-bacf-14bab5630357 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '49f8d5bd-f26f-4095-bacf-14bab5630357' GROUP BY proposal_id ;
Copy
58
0.20 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"49f8d5bd-f26f-4095-bacf-14bab5630357 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '49f8d5bd-f26f-4095-bacf-14bab5630357' ;
Copy
59
0.35 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
60
0.28 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
61
0.87 ms
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 :
[
"49f8d5bd-f26f-4095-bacf-14bab5630357 "
]
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 = '49f8d5bd-f26f-4095-bacf-14bab5630357' ORDER BY pg . id ASC , p . id ASC ;
Copy
62
0.37 ms
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 :
[
"5e7fc632-9fb6-4a71-ab37-e53ca6aac29f "
]
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 = '5e7fc632-9fb6-4a71-ab37-e53ca6aac29f' ;
Copy
63
0.32 ms
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 :
[
"5e7fc632-9fb6-4a71-ab37-e53ca6aac29f "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '5e7fc632-9fb6-4a71-ab37-e53ca6aac29f' GROUP BY proposal_id ;
Copy
64
0.18 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"5e7fc632-9fb6-4a71-ab37-e53ca6aac29f "
]
SELECT cnt FROM counters . proposal_view WHERE id = '5e7fc632-9fb6-4a71-ab37-e53ca6aac29f' ;
Copy
65
0.24 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
66
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
67
0.80 ms
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 :
[
"5e7fc632-9fb6-4a71-ab37-e53ca6aac29f "
]
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 = '5e7fc632-9fb6-4a71-ab37-e53ca6aac29f' ORDER BY pg . id ASC , p . id ASC ;
Copy
68
0.28 ms
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 :
[
"4c5bb938-247d-4db8-8899-8dd9da2ea751 "
]
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 = '4c5bb938-247d-4db8-8899-8dd9da2ea751' ;
Copy
69
0.27 ms
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 :
[
"4c5bb938-247d-4db8-8899-8dd9da2ea751 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '4c5bb938-247d-4db8-8899-8dd9da2ea751' GROUP BY proposal_id ;
Copy
70
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"4c5bb938-247d-4db8-8899-8dd9da2ea751 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '4c5bb938-247d-4db8-8899-8dd9da2ea751' ;
Copy
71
0.23 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
72
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
73
0.75 ms
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 :
[
"4c5bb938-247d-4db8-8899-8dd9da2ea751 "
]
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 = '4c5bb938-247d-4db8-8899-8dd9da2ea751' ORDER BY pg . id ASC , p . id ASC ;
Copy
74
0.27 ms
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 :
[
"39dd1a60-f488-4c79-949e-ac7b37130598 "
]
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 = '39dd1a60-f488-4c79-949e-ac7b37130598' ;
Copy
75
0.26 ms
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 :
[
"39dd1a60-f488-4c79-949e-ac7b37130598 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '39dd1a60-f488-4c79-949e-ac7b37130598' GROUP BY proposal_id ;
Copy
76
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"39dd1a60-f488-4c79-949e-ac7b37130598 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '39dd1a60-f488-4c79-949e-ac7b37130598' ;
Copy
77
0.25 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
78
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
79
0.80 ms
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 :
[
"39dd1a60-f488-4c79-949e-ac7b37130598 "
]
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 = '39dd1a60-f488-4c79-949e-ac7b37130598' ORDER BY pg . id ASC , p . id ASC ;
Copy
80
0.29 ms
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 :
[
"b39d1223-27c8-467c-8d87-d442b6e0c394 "
]
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 = 'b39d1223-27c8-467c-8d87-d442b6e0c394' ;
Copy
81
0.28 ms
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 :
[
"b39d1223-27c8-467c-8d87-d442b6e0c394 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'b39d1223-27c8-467c-8d87-d442b6e0c394' GROUP BY proposal_id ;
Copy
82
0.19 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"b39d1223-27c8-467c-8d87-d442b6e0c394 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'b39d1223-27c8-467c-8d87-d442b6e0c394' ;
Copy
83
0.24 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
84
0.23 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
85
0.79 ms
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 :
[
"b39d1223-27c8-467c-8d87-d442b6e0c394 "
]
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 = 'b39d1223-27c8-467c-8d87-d442b6e0c394' ORDER BY pg . id ASC , p . id ASC ;
Copy
86
0.30 ms
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 :
[
"8a013461-8565-4fab-86ff-7cbd2736c2ac "
]
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 = '8a013461-8565-4fab-86ff-7cbd2736c2ac' ;
Copy
87
0.26 ms
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 :
[
"8a013461-8565-4fab-86ff-7cbd2736c2ac "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '8a013461-8565-4fab-86ff-7cbd2736c2ac' GROUP BY proposal_id ;
Copy
88
0.21 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"8a013461-8565-4fab-86ff-7cbd2736c2ac "
]
SELECT cnt FROM counters . proposal_view WHERE id = '8a013461-8565-4fab-86ff-7cbd2736c2ac' ;
Copy
89
0.25 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
90
0.23 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
91
0.73 ms
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 :
[
"8a013461-8565-4fab-86ff-7cbd2736c2ac "
]
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 = '8a013461-8565-4fab-86ff-7cbd2736c2ac' ORDER BY pg . id ASC , p . id ASC ;
Copy
92
0.28 ms
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 :
[
"a85ba043-0470-4e19-9489-80027eb2c23d "
]
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 = 'a85ba043-0470-4e19-9489-80027eb2c23d' ;
Copy
93
0.25 ms
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 :
[
"a85ba043-0470-4e19-9489-80027eb2c23d "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'a85ba043-0470-4e19-9489-80027eb2c23d' GROUP BY proposal_id ;
Copy
94
0.18 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"a85ba043-0470-4e19-9489-80027eb2c23d "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'a85ba043-0470-4e19-9489-80027eb2c23d' ;
Copy
95
0.25 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
96
0.23 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
97
0.74 ms
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 :
[
"a85ba043-0470-4e19-9489-80027eb2c23d "
]
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 = 'a85ba043-0470-4e19-9489-80027eb2c23d' ORDER BY pg . id ASC , p . id ASC ;
Copy
98
0.30 ms
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 :
[
"05577ba3-660f-4403-832c-17479cc1ff79 "
]
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 = '05577ba3-660f-4403-832c-17479cc1ff79' ;
Copy
99
0.26 ms
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 :
[
"05577ba3-660f-4403-832c-17479cc1ff79 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '05577ba3-660f-4403-832c-17479cc1ff79' GROUP BY proposal_id ;
Copy
100
0.17 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"05577ba3-660f-4403-832c-17479cc1ff79 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '05577ba3-660f-4403-832c-17479cc1ff79' ;
Copy
101
0.25 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
102
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
103
0.80 ms
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 :
[
"05577ba3-660f-4403-832c-17479cc1ff79 "
]
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 = '05577ba3-660f-4403-832c-17479cc1ff79' ORDER BY pg . id ASC , p . id ASC ;
Copy
104
0.31 ms
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 :
[
"6294b1d2-7a3e-4167-a3a2-dff15c2873a8 "
]
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 = '6294b1d2-7a3e-4167-a3a2-dff15c2873a8' ;
Copy
105
0.25 ms
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 :
[
"6294b1d2-7a3e-4167-a3a2-dff15c2873a8 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '6294b1d2-7a3e-4167-a3a2-dff15c2873a8' GROUP BY proposal_id ;
Copy
106
0.17 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"6294b1d2-7a3e-4167-a3a2-dff15c2873a8 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '6294b1d2-7a3e-4167-a3a2-dff15c2873a8' ;
Copy
107
0.24 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
108
0.22 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
109
0.74 ms
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 :
[
"6294b1d2-7a3e-4167-a3a2-dff15c2873a8 "
]
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 = '6294b1d2-7a3e-4167-a3a2-dff15c2873a8' ORDER BY pg . id ASC , p . id ASC ;
Copy
110
0.31 ms
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 :
[
"cafe2c2e-cfb9-4623-987b-97d51c0fea62 "
]
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 = 'cafe2c2e-cfb9-4623-987b-97d51c0fea62' ;
Copy
111
0.28 ms
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 :
[
"cafe2c2e-cfb9-4623-987b-97d51c0fea62 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'cafe2c2e-cfb9-4623-987b-97d51c0fea62' GROUP BY proposal_id ;
Copy
112
0.21 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"cafe2c2e-cfb9-4623-987b-97d51c0fea62 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'cafe2c2e-cfb9-4623-987b-97d51c0fea62' ;
Copy
113
0.25 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
114
0.24 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
115
0.78 ms
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 :
[
"cafe2c2e-cfb9-4623-987b-97d51c0fea62 "
]
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 = 'cafe2c2e-cfb9-4623-987b-97d51c0fea62' ORDER BY pg . id ASC , p . id ASC ;
Copy
116
0.28 ms
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 :
[
"3cdfa76b-a5e4-4bcc-b366-27b622c88312 "
]
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 = '3cdfa76b-a5e4-4bcc-b366-27b622c88312' ;
Copy
117
0.28 ms
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 :
[
"3cdfa76b-a5e4-4bcc-b366-27b622c88312 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '3cdfa76b-a5e4-4bcc-b366-27b622c88312' GROUP BY proposal_id ;
Copy
118
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"3cdfa76b-a5e4-4bcc-b366-27b622c88312 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '3cdfa76b-a5e4-4bcc-b366-27b622c88312' ;
Copy
119
0.23 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
120
0.25 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
121
0.79 ms
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 :
[
"3cdfa76b-a5e4-4bcc-b366-27b622c88312 "
]
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 = '3cdfa76b-a5e4-4bcc-b366-27b622c88312' ORDER BY pg . id ASC , p . id ASC ;
Copy
122
0.28 ms
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 :
[
"05ea807e-5076-4083-9466-a4525cf58218 "
]
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 = '05ea807e-5076-4083-9466-a4525cf58218' ;
Copy
123
0.26 ms
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 :
[
"05ea807e-5076-4083-9466-a4525cf58218 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '05ea807e-5076-4083-9466-a4525cf58218' GROUP BY proposal_id ;
Copy
124
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"05ea807e-5076-4083-9466-a4525cf58218 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '05ea807e-5076-4083-9466-a4525cf58218' ;
Copy
125
0.23 ms
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 :
[
"8fdbc881-baf1-44fc-ab1b-9ee7a18b3239 "
]
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' LIMIT 1 ;
Copy
126
0.20 ms
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 = ?
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 = '8fdbc881-baf1-44fc-ab1b-9ee7a18b3239' ;
Copy
127
0.72 ms
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 :
[
"05ea807e-5076-4083-9466-a4525cf58218 "
]
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 = '05ea807e-5076-4083-9466-a4525cf58218' ORDER BY pg . id ASC , p . id ASC ;
Copy
128
0.65 ms
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 "
]
SELECT
COUNT (p . id )
FROM
goods . proposal p
WHERE
(NOT p . is_archive )
AND (NOT p . is_private )
AND (
p . category_id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
)
Copy
SELECT COUNT (p . id ) FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('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' ));
Copy