1
1.71 ms
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
2
1.70 ms
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC LIMIT 6
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC LIMIT 6 ;
Copy
3
1.57 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
4
2.46 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
5
0.49 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
6
0.87 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
7
0.44 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
8
2.65 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
9
0.47 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
10
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 :
[
"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
11
0.18 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
12
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 :
[
"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
13
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 = 'b19cf6bf-4799-4796-aa11-ee31467761cd' ;
Copy
14
0.89 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
15
0.32 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
16
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 :
[
"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
17
0.35 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
18
0.18 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
19
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 :
[
"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
20
0.26 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
21
0.96 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
22
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 :
[
"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
23
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 :
[
"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
24
0.25 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
25
0.17 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
26
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
27
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
28
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 :
[
"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
29
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 :
[
"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
30
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 :
[
"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
31
0.24 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
32
0.17 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
33
0.29 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
34
0.21 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
35
0.89 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
36
0.32 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
37
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 :
[
"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
38
0.17 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
39
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 :
[
"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
40
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 = 'a94c1907-f056-4542-a3de-aacdd561b656' ;
Copy
41
0.62 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
42
0.31 ms
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC ;
Copy
43
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 :
[
"38f2f129-6765-4a8b-b281-5d57f7668866 "
]
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 = '38f2f129-6765-4a8b-b281-5d57f7668866' ;
Copy
44
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 :
[
"38f2f129-6765-4a8b-b281-5d57f7668866 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '38f2f129-6765-4a8b-b281-5d57f7668866' GROUP BY proposal_id ;
Copy
45
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"38f2f129-6765-4a8b-b281-5d57f7668866 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '38f2f129-6765-4a8b-b281-5d57f7668866' ;
Copy
46
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 :
[
"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
47
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
48
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 :
[
"38f2f129-6765-4a8b-b281-5d57f7668866 "
]
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 = '38f2f129-6765-4a8b-b281-5d57f7668866' ORDER BY pg . id ASC , p . id ASC ;
Copy
49
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 :
[
"569ffe50-05b2-40b2-b355-198add23a824 "
]
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 = '569ffe50-05b2-40b2-b355-198add23a824' ;
Copy
50
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 :
[
"569ffe50-05b2-40b2-b355-198add23a824 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '569ffe50-05b2-40b2-b355-198add23a824' GROUP BY proposal_id ;
Copy
51
0.14 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"569ffe50-05b2-40b2-b355-198add23a824 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '569ffe50-05b2-40b2-b355-198add23a824' ;
Copy
52
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
53
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
54
1.43 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 :
[
"569ffe50-05b2-40b2-b355-198add23a824 "
]
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 = '569ffe50-05b2-40b2-b355-198add23a824' ORDER BY pg . id ASC , p . id ASC ;
Copy
55
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 :
[
"e160a681-9395-4207-b2ca-4f6e8d4dbd77 "
]
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 = 'e160a681-9395-4207-b2ca-4f6e8d4dbd77' ;
Copy
56
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 :
[
"e160a681-9395-4207-b2ca-4f6e8d4dbd77 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'e160a681-9395-4207-b2ca-4f6e8d4dbd77' GROUP BY proposal_id ;
Copy
57
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"e160a681-9395-4207-b2ca-4f6e8d4dbd77 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'e160a681-9395-4207-b2ca-4f6e8d4dbd77' ;
Copy
58
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
59
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
60
1.46 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 :
[
"e160a681-9395-4207-b2ca-4f6e8d4dbd77 "
]
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 = 'e160a681-9395-4207-b2ca-4f6e8d4dbd77' ORDER BY pg . id ASC , p . id ASC ;
Copy
61
0.40 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 :
[
"abc9a1d4-9d30-4b90-aec6-7e49c58338ef "
]
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 = 'abc9a1d4-9d30-4b90-aec6-7e49c58338ef' ;
Copy
62
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 :
[
"abc9a1d4-9d30-4b90-aec6-7e49c58338ef "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'abc9a1d4-9d30-4b90-aec6-7e49c58338ef' GROUP BY proposal_id ;
Copy
63
0.18 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"abc9a1d4-9d30-4b90-aec6-7e49c58338ef "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'abc9a1d4-9d30-4b90-aec6-7e49c58338ef' ;
Copy
64
0.36 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
65
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
66
1.22 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 :
[
"abc9a1d4-9d30-4b90-aec6-7e49c58338ef "
]
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 = 'abc9a1d4-9d30-4b90-aec6-7e49c58338ef' ORDER BY pg . id ASC , p . id ASC ;
Copy
67
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 :
[
"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
68
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 :
[
"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
69
0.18 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
70
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 :
[
"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
71
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
72
1.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 :
[
"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
73
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 :
[
"8a929d5a-6572-48c1-947c-1281474bb892 "
]
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 = '8a929d5a-6572-48c1-947c-1281474bb892' ;
Copy
74
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 :
[
"8a929d5a-6572-48c1-947c-1281474bb892 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '8a929d5a-6572-48c1-947c-1281474bb892' GROUP BY proposal_id ;
Copy
75
0.14 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"8a929d5a-6572-48c1-947c-1281474bb892 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '8a929d5a-6572-48c1-947c-1281474bb892' ;
Copy
76
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 :
[
"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
77
0.26 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
78
1.18 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 :
[
"8a929d5a-6572-48c1-947c-1281474bb892 "
]
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 = '8a929d5a-6572-48c1-947c-1281474bb892' ORDER BY pg . id ASC , p . id ASC ;
Copy
79
0.36 ms
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC ;
Copy
80
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
81
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 :
[
"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
82
0.17 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
83
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
84
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
85
0.57 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
86
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 :
[
"4339bd72-8e8a-47e7-ac43-7c35ddecbfa3 "
]
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 = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' ;
Copy
87
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 :
[
"4339bd72-8e8a-47e7-ac43-7c35ddecbfa3 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' GROUP BY proposal_id ;
Copy
88
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"4339bd72-8e8a-47e7-ac43-7c35ddecbfa3 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' ;
Copy
89
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
90
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
91
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 :
[
"4339bd72-8e8a-47e7-ac43-7c35ddecbfa3 "
]
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 = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' ORDER BY pg . id ASC , p . id ASC ;
Copy
92
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 :
[
"cf16b97b-b630-4ac8-b2fc-c9876f013225 "
]
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 = 'cf16b97b-b630-4ac8-b2fc-c9876f013225' ;
Copy
93
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 :
[
"cf16b97b-b630-4ac8-b2fc-c9876f013225 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'cf16b97b-b630-4ac8-b2fc-c9876f013225' GROUP BY proposal_id ;
Copy
94
0.15 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"cf16b97b-b630-4ac8-b2fc-c9876f013225 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'cf16b97b-b630-4ac8-b2fc-c9876f013225' ;
Copy
95
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 :
[
"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
96
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
97
1.57 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 :
[
"cf16b97b-b630-4ac8-b2fc-c9876f013225 "
]
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 = 'cf16b97b-b630-4ac8-b2fc-c9876f013225' ORDER BY pg . id ASC , p . id ASC ;
Copy
98
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 :
[
"256ecb16-46c2-4061-b87d-f9e55a1a46d7 "
]
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 = '256ecb16-46c2-4061-b87d-f9e55a1a46d7' ;
Copy
99
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 :
[
"256ecb16-46c2-4061-b87d-f9e55a1a46d7 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '256ecb16-46c2-4061-b87d-f9e55a1a46d7' GROUP BY proposal_id ;
Copy
100
0.18 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"256ecb16-46c2-4061-b87d-f9e55a1a46d7 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '256ecb16-46c2-4061-b87d-f9e55a1a46d7' ;
Copy
101
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
102
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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
103
0.88 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 :
[
"256ecb16-46c2-4061-b87d-f9e55a1a46d7 "
]
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 = '256ecb16-46c2-4061-b87d-f9e55a1a46d7' ORDER BY pg . id ASC , p . id ASC ;
Copy
104
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 :
[
"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
105
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 :
[
"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
106
0.23 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
107
0.16 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
108
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
109
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
110
0.92 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
111
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 :
[
"17c57209-c579-4931-8b8a-33868dd1fb75 "
]
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 = '17c57209-c579-4931-8b8a-33868dd1fb75' ;
Copy
112
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 :
[
"17c57209-c579-4931-8b8a-33868dd1fb75 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '17c57209-c579-4931-8b8a-33868dd1fb75' GROUP BY proposal_id ;
Copy
113
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"17c57209-c579-4931-8b8a-33868dd1fb75 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '17c57209-c579-4931-8b8a-33868dd1fb75' ;
Copy
114
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 :
[
"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
115
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
116
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 :
[
"17c57209-c579-4931-8b8a-33868dd1fb75 "
]
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 = '17c57209-c579-4931-8b8a-33868dd1fb75' ORDER BY pg . id ASC , p . id ASC ;
Copy
117
0.73 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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? ORDER BY t0 . date_add DESC LIMIT 4
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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 ORDER BY t0 . date_add DESC LIMIT 4 ;
Copy
118
0.65 ms
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN (? ) GROUP BY price_request_id
Parameters :
[
"85dbf9ad-345c-4c78-8910-b23f4533ee78 "
]
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN ('85dbf9ad-345c-4c78-8910-b23f4533ee78' ) GROUP BY price_request_id ;
Copy
119
0.53 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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? ORDER BY t0 . end_date ASC LIMIT 4
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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 ORDER BY t0 . end_date ASC LIMIT 4 ;
Copy
120
0.22 ms
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN (? ) GROUP BY price_request_id
Parameters :
[
"85dbf9ad-345c-4c78-8910-b23f4533ee78 "
]
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN ('85dbf9ad-345c-4c78-8910-b23f4533ee78' ) GROUP BY price_request_id ;
Copy
121
0.18 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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? LIMIT 100
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 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 LIMIT 100 ;
Copy
122
0.21 ms
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN (? ) GROUP BY price_request_id
Parameters :
[
"85dbf9ad-345c-4c78-8910-b23f4533ee78 "
]
SELECT price_request_id AS id , COUNT (id ) AS total , MIN (price ) AS min_price , MAX (price ) AS max_price FROM trade . price_request_answer WHERE price_request_id IN ('85dbf9ad-345c-4c78-8910-b23f4533ee78' ) GROUP BY price_request_id ;
Copy