1
1.81 ms
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
2
3.09 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 :
[
"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 "
]
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 ('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' ));
Copy
3
1.54 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 :
[
"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 "
0
1000000
]
SELECT p . id FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('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' )) AND (p . price > = 0 ) AND (p . price < = 1000000 ) ORDER BY p . date_add DESC LIMIT 20 ;
Copy
4
0.55 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 :
[
"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 "
]
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 ('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' ));
Copy
5
1.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 :
[
"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.43 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.42 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.71 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.39 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.47 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.34 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
12
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
13
0.32 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
14
0.15 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
15
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
16
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
17
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
18
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 :
[
"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
19
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 :
[
"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
20
0.16 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
21
0.12 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
22
0.17 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
23
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
24
0.60 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
25
0.39 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 :
[
"07c08813-e82c-4572-86be-41500a5b860a "
]
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 = '07c08813-e82c-4572-86be-41500a5b860a' ;
Copy
26
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 :
[
"07c08813-e82c-4572-86be-41500a5b860a "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '07c08813-e82c-4572-86be-41500a5b860a' GROUP BY proposal_id ;
Copy
27
0.19 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"07c08813-e82c-4572-86be-41500a5b860a "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = '07c08813-e82c-4572-86be-41500a5b860a' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
28
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"07c08813-e82c-4572-86be-41500a5b860a "
]
SELECT cnt FROM counters . proposal_view WHERE id = '07c08813-e82c-4572-86be-41500a5b860a' ;
Copy
29
0.19 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 :
[
"0ca6c62b-3d61-469e-96d4-4082c4093a39 "
]
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 = '0ca6c62b-3d61-469e-96d4-4082c4093a39' LIMIT 1 ;
Copy
30
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 = '0ca6c62b-3d61-469e-96d4-4082c4093a39' ;
Copy
31
0.61 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 :
[
"07c08813-e82c-4572-86be-41500a5b860a "
]
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 = '07c08813-e82c-4572-86be-41500a5b860a' ORDER BY pg . id ASC , p . id ASC ;
Copy
32
0.25 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 :
[
"7165f4f8-3c1b-42f0-a045-f7e5d5d510fa "
]
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 = '7165f4f8-3c1b-42f0-a045-f7e5d5d510fa' ;
Copy
33
0.24 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 :
[
"7165f4f8-3c1b-42f0-a045-f7e5d5d510fa "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '7165f4f8-3c1b-42f0-a045-f7e5d5d510fa' GROUP BY proposal_id ;
Copy
34
0.21 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"7165f4f8-3c1b-42f0-a045-f7e5d5d510fa "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = '7165f4f8-3c1b-42f0-a045-f7e5d5d510fa' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
35
0.17 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"7165f4f8-3c1b-42f0-a045-f7e5d5d510fa "
]
SELECT cnt FROM counters . proposal_view WHERE id = '7165f4f8-3c1b-42f0-a045-f7e5d5d510fa' ;
Copy
36
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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
37
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
38
0.59 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 :
[
"7165f4f8-3c1b-42f0-a045-f7e5d5d510fa "
]
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 = '7165f4f8-3c1b-42f0-a045-f7e5d5d510fa' ORDER BY pg . id ASC , p . id ASC ;
Copy
39
0.24 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 :
[
"530f7959-e837-47d7-8027-04262113e497 "
]
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 = '530f7959-e837-47d7-8027-04262113e497' ;
Copy
40
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 :
[
"530f7959-e837-47d7-8027-04262113e497 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '530f7959-e837-47d7-8027-04262113e497' GROUP BY proposal_id ;
Copy
41
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"530f7959-e837-47d7-8027-04262113e497 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '530f7959-e837-47d7-8027-04262113e497' ;
Copy
42
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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
43
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
44
1.05 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 :
[
"530f7959-e837-47d7-8027-04262113e497 "
]
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 = '530f7959-e837-47d7-8027-04262113e497' ORDER BY pg . id ASC , p . id ASC ;
Copy
45
0.25 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 :
[
"2190b892-65f4-4196-9954-f89d7a84faed "
]
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 = '2190b892-65f4-4196-9954-f89d7a84faed' ;
Copy
46
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 :
[
"2190b892-65f4-4196-9954-f89d7a84faed "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '2190b892-65f4-4196-9954-f89d7a84faed' GROUP BY proposal_id ;
Copy
47
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"2190b892-65f4-4196-9954-f89d7a84faed "
]
SELECT cnt FROM counters . proposal_view WHERE id = '2190b892-65f4-4196-9954-f89d7a84faed' ;
Copy
48
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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
49
0.15 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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
50
1.05 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 :
[
"2190b892-65f4-4196-9954-f89d7a84faed "
]
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 = '2190b892-65f4-4196-9954-f89d7a84faed' ORDER BY pg . id ASC , p . id ASC ;
Copy
51
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 :
[
"b3159697-c1bf-49a6-a82e-7a0a16ece837 "
]
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 = 'b3159697-c1bf-49a6-a82e-7a0a16ece837' ;
Copy
52
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 :
[
"b3159697-c1bf-49a6-a82e-7a0a16ece837 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'b3159697-c1bf-49a6-a82e-7a0a16ece837' GROUP BY proposal_id ;
Copy
53
0.20 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"b3159697-c1bf-49a6-a82e-7a0a16ece837 "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = 'b3159697-c1bf-49a6-a82e-7a0a16ece837' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
54
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"b3159697-c1bf-49a6-a82e-7a0a16ece837 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'b3159697-c1bf-49a6-a82e-7a0a16ece837' ;
Copy
55
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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
56
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
57
1.05 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 :
[
"b3159697-c1bf-49a6-a82e-7a0a16ece837 "
]
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 = 'b3159697-c1bf-49a6-a82e-7a0a16ece837' ORDER BY pg . id ASC , p . id ASC ;
Copy
58
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 :
[
"b7577a9b-380d-44bd-aaa4-aff928d7dcd1 "
]
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 = 'b7577a9b-380d-44bd-aaa4-aff928d7dcd1' ;
Copy
59
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 :
[
"b7577a9b-380d-44bd-aaa4-aff928d7dcd1 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'b7577a9b-380d-44bd-aaa4-aff928d7dcd1' GROUP BY proposal_id ;
Copy
60
0.23 ms
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = ? ) AND (state = 0 ) GROUP BY proposal_id
Parameters :
[
"b7577a9b-380d-44bd-aaa4-aff928d7dcd1 "
]
SELECT COUNT (id ) AS new FROM trade . auction_offer WHERE (proposal_id = 'b7577a9b-380d-44bd-aaa4-aff928d7dcd1' ) AND (state = 0 ) GROUP BY proposal_id ;
Copy
61
0.22 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"b7577a9b-380d-44bd-aaa4-aff928d7dcd1 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'b7577a9b-380d-44bd-aaa4-aff928d7dcd1' ;
Copy
62
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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
63
0.27 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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
64
1.39 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 :
[
"b7577a9b-380d-44bd-aaa4-aff928d7dcd1 "
]
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 = 'b7577a9b-380d-44bd-aaa4-aff928d7dcd1' ORDER BY pg . id ASC , p . id ASC ;
Copy
65
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 :
[
"9394e8fa-2c0f-45be-8376-a7a2f77ebc4c "
]
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 = '9394e8fa-2c0f-45be-8376-a7a2f77ebc4c' ;
Copy
66
0.19 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 :
[
"9394e8fa-2c0f-45be-8376-a7a2f77ebc4c "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '9394e8fa-2c0f-45be-8376-a7a2f77ebc4c' GROUP BY proposal_id ;
Copy
67
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"9394e8fa-2c0f-45be-8376-a7a2f77ebc4c "
]
SELECT cnt FROM counters . proposal_view WHERE id = '9394e8fa-2c0f-45be-8376-a7a2f77ebc4c' ;
Copy
68
0.19 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 :
[
"7bb2c305-0384-40ee-8c13-f490a91adbeb "
]
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' LIMIT 1 ;
Copy
69
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 = '7bb2c305-0384-40ee-8c13-f490a91adbeb' ;
Copy
70
1.01 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 :
[
"9394e8fa-2c0f-45be-8376-a7a2f77ebc4c "
]
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 = '9394e8fa-2c0f-45be-8376-a7a2f77ebc4c' ORDER BY pg . id ASC , p . id ASC ;
Copy
71
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 :
[
"ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9 "
]
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 = 'ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9' ;
Copy
72
0.21 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 :
[
"ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9' GROUP BY proposal_id ;
Copy
73
0.13 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9' ;
Copy
74
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
75
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
76
1.04 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 :
[
"ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9 "
]
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 = 'ca84013b-6bc9-46d3-bdb4-0cbf3d9e21c9' ORDER BY pg . id ASC , p . id ASC ;
Copy
77
0.23 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 :
[
"8d1098fd-fbcc-4a20-8c95-97c85402e0de "
]
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 = '8d1098fd-fbcc-4a20-8c95-97c85402e0de' ;
Copy
78
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 :
[
"8d1098fd-fbcc-4a20-8c95-97c85402e0de "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '8d1098fd-fbcc-4a20-8c95-97c85402e0de' GROUP BY proposal_id ;
Copy
79
0.12 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"8d1098fd-fbcc-4a20-8c95-97c85402e0de "
]
SELECT cnt FROM counters . proposal_view WHERE id = '8d1098fd-fbcc-4a20-8c95-97c85402e0de' ;
Copy
80
0.17 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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
81
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
82
1.15 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 :
[
"8d1098fd-fbcc-4a20-8c95-97c85402e0de "
]
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 = '8d1098fd-fbcc-4a20-8c95-97c85402e0de' ORDER BY pg . id ASC , p . id ASC ;
Copy
83
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 :
[
"eaeac76d-f5a8-4602-80ad-aee93b41d987 "
]
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 = 'eaeac76d-f5a8-4602-80ad-aee93b41d987' ;
Copy
84
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 :
[
"eaeac76d-f5a8-4602-80ad-aee93b41d987 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'eaeac76d-f5a8-4602-80ad-aee93b41d987' GROUP BY proposal_id ;
Copy
85
0.13 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"eaeac76d-f5a8-4602-80ad-aee93b41d987 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'eaeac76d-f5a8-4602-80ad-aee93b41d987' ;
Copy
86
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
87
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
88
0.99 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 :
[
"eaeac76d-f5a8-4602-80ad-aee93b41d987 "
]
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 = 'eaeac76d-f5a8-4602-80ad-aee93b41d987' ORDER BY pg . id ASC , p . id ASC ;
Copy
89
0.33 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 :
[
"a324e555-9e56-4625-9a2a-c69ac3169e02 "
]
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 = 'a324e555-9e56-4625-9a2a-c69ac3169e02' ;
Copy
90
0.21 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 :
[
"a324e555-9e56-4625-9a2a-c69ac3169e02 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'a324e555-9e56-4625-9a2a-c69ac3169e02' GROUP BY proposal_id ;
Copy
91
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"a324e555-9e56-4625-9a2a-c69ac3169e02 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'a324e555-9e56-4625-9a2a-c69ac3169e02' ;
Copy
92
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
93
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
94
1.07 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 :
[
"a324e555-9e56-4625-9a2a-c69ac3169e02 "
]
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 = 'a324e555-9e56-4625-9a2a-c69ac3169e02' ORDER BY pg . id ASC , p . id ASC ;
Copy
95
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 :
[
"04db38ff-dfeb-4d20-b87c-b4b415131cde "
]
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 = '04db38ff-dfeb-4d20-b87c-b4b415131cde' ;
Copy
96
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 :
[
"04db38ff-dfeb-4d20-b87c-b4b415131cde "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '04db38ff-dfeb-4d20-b87c-b4b415131cde' GROUP BY proposal_id ;
Copy
97
0.17 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"04db38ff-dfeb-4d20-b87c-b4b415131cde "
]
SELECT cnt FROM counters . proposal_view WHERE id = '04db38ff-dfeb-4d20-b87c-b4b415131cde' ;
Copy
98
0.22 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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
99
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
100
1.15 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 :
[
"04db38ff-dfeb-4d20-b87c-b4b415131cde "
]
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 = '04db38ff-dfeb-4d20-b87c-b4b415131cde' ORDER BY pg . id ASC , p . id ASC ;
Copy
101
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 :
[
"94a8efc1-2dba-4596-b605-dea10c7d705b "
]
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 = '94a8efc1-2dba-4596-b605-dea10c7d705b' ;
Copy
102
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 :
[
"94a8efc1-2dba-4596-b605-dea10c7d705b "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '94a8efc1-2dba-4596-b605-dea10c7d705b' GROUP BY proposal_id ;
Copy
103
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"94a8efc1-2dba-4596-b605-dea10c7d705b "
]
SELECT cnt FROM counters . proposal_view WHERE id = '94a8efc1-2dba-4596-b605-dea10c7d705b' ;
Copy
104
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
105
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
106
1.08 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 :
[
"94a8efc1-2dba-4596-b605-dea10c7d705b "
]
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 = '94a8efc1-2dba-4596-b605-dea10c7d705b' ORDER BY pg . id ASC , p . id ASC ;
Copy
107
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 :
[
"4273475b-9da4-4c99-ab8d-ab2fcbf2a169 "
]
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 = '4273475b-9da4-4c99-ab8d-ab2fcbf2a169' ;
Copy
108
0.24 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 :
[
"4273475b-9da4-4c99-ab8d-ab2fcbf2a169 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '4273475b-9da4-4c99-ab8d-ab2fcbf2a169' GROUP BY proposal_id ;
Copy
109
0.18 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"4273475b-9da4-4c99-ab8d-ab2fcbf2a169 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '4273475b-9da4-4c99-ab8d-ab2fcbf2a169' ;
Copy
110
0.22 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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
111
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
112
1.20 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 :
[
"4273475b-9da4-4c99-ab8d-ab2fcbf2a169 "
]
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 = '4273475b-9da4-4c99-ab8d-ab2fcbf2a169' ORDER BY pg . id ASC , p . id ASC ;
Copy
113
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 :
[
"c573e84c-4b35-46b3-93fc-ffeba4dc5732 "
]
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 = 'c573e84c-4b35-46b3-93fc-ffeba4dc5732' ;
Copy
114
0.21 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 :
[
"c573e84c-4b35-46b3-93fc-ffeba4dc5732 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'c573e84c-4b35-46b3-93fc-ffeba4dc5732' GROUP BY proposal_id ;
Copy
115
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"c573e84c-4b35-46b3-93fc-ffeba4dc5732 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'c573e84c-4b35-46b3-93fc-ffeba4dc5732' ;
Copy
116
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
117
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
118
0.99 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 :
[
"c573e84c-4b35-46b3-93fc-ffeba4dc5732 "
]
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 = 'c573e84c-4b35-46b3-93fc-ffeba4dc5732' ORDER BY pg . id ASC , p . id ASC ;
Copy
119
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 :
[
"a4f7cf5a-4168-45f6-a6d6-1f3523be82b9 "
]
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 = 'a4f7cf5a-4168-45f6-a6d6-1f3523be82b9' ;
Copy
120
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 :
[
"a4f7cf5a-4168-45f6-a6d6-1f3523be82b9 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'a4f7cf5a-4168-45f6-a6d6-1f3523be82b9' GROUP BY proposal_id ;
Copy
121
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"a4f7cf5a-4168-45f6-a6d6-1f3523be82b9 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'a4f7cf5a-4168-45f6-a6d6-1f3523be82b9' ;
Copy
122
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
123
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
124
1.09 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 :
[
"a4f7cf5a-4168-45f6-a6d6-1f3523be82b9 "
]
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 = 'a4f7cf5a-4168-45f6-a6d6-1f3523be82b9' ORDER BY pg . id ASC , p . id ASC ;
Copy
125
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 :
[
"d8238847-673f-4554-8012-96cc247ccf83 "
]
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 = 'd8238847-673f-4554-8012-96cc247ccf83' ;
Copy
126
0.21 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 :
[
"d8238847-673f-4554-8012-96cc247ccf83 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'd8238847-673f-4554-8012-96cc247ccf83' GROUP BY proposal_id ;
Copy
127
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"d8238847-673f-4554-8012-96cc247ccf83 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'd8238847-673f-4554-8012-96cc247ccf83' ;
Copy
128
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 :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
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 = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
129
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
130
0.95 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 :
[
"d8238847-673f-4554-8012-96cc247ccf83 "
]
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 = 'd8238847-673f-4554-8012-96cc247ccf83' ORDER BY pg . id ASC , p . id ASC ;
Copy
131
0.27 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 :
[
"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 "
]
SELECT COUNT (p . id ) FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('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' ));
Copy