1
1.43 ms
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
2
2.26 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 :
[
"55a6f9e6-d278-4d60-8a87-b19500c5c6a0 "
"46c239bf-f07e-47be-993a-ec7d45ba0797 "
"d739120e-bc14-4ff9-a079-55a93c91795b "
"7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b "
"6242c6c8-1d3b-499d-a3f9-31835e92def6 "
"f1c7dfda-d7c9-4702-a14f-7847ae301e0c "
"2b129ce4-b25b-4ad4-9549-781deea34dab "
"8e13f4e7-accf-4070-9cae-1db8f0229f52 "
"5388e8b9-5e83-475c-b172-cc20e247faac "
"315382d0-f96e-4423-a755-c6eac4253f03 "
]
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 ('55a6f9e6-d278-4d60-8a87-b19500c5c6a0' , '46c239bf-f07e-47be-993a-ec7d45ba0797' , 'd739120e-bc14-4ff9-a079-55a93c91795b' , '7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b' , '6242c6c8-1d3b-499d-a3f9-31835e92def6' , 'f1c7dfda-d7c9-4702-a14f-7847ae301e0c' , '2b129ce4-b25b-4ad4-9549-781deea34dab' , '8e13f4e7-accf-4070-9cae-1db8f0229f52' , '5388e8b9-5e83-475c-b172-cc20e247faac' , '315382d0-f96e-4423-a755-c6eac4253f03' ));
Copy
3
1.19 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 :
[
"55a6f9e6-d278-4d60-8a87-b19500c5c6a0 "
"46c239bf-f07e-47be-993a-ec7d45ba0797 "
"d739120e-bc14-4ff9-a079-55a93c91795b "
"7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b "
"6242c6c8-1d3b-499d-a3f9-31835e92def6 "
"f1c7dfda-d7c9-4702-a14f-7847ae301e0c "
"2b129ce4-b25b-4ad4-9549-781deea34dab "
"8e13f4e7-accf-4070-9cae-1db8f0229f52 "
"5388e8b9-5e83-475c-b172-cc20e247faac "
"315382d0-f96e-4423-a755-c6eac4253f03 "
0
1000000
]
SELECT p . id FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('55a6f9e6-d278-4d60-8a87-b19500c5c6a0' , '46c239bf-f07e-47be-993a-ec7d45ba0797' , 'd739120e-bc14-4ff9-a079-55a93c91795b' , '7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b' , '6242c6c8-1d3b-499d-a3f9-31835e92def6' , 'f1c7dfda-d7c9-4702-a14f-7847ae301e0c' , '2b129ce4-b25b-4ad4-9549-781deea34dab' , '8e13f4e7-accf-4070-9cae-1db8f0229f52' , '5388e8b9-5e83-475c-b172-cc20e247faac' , '315382d0-f96e-4423-a755-c6eac4253f03' )) AND (p . price > = 0 ) AND (p . price < = 1000000 ) ORDER BY p . date_add DESC LIMIT 20 ;
Copy
4
0.43 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 :
[
"55a6f9e6-d278-4d60-8a87-b19500c5c6a0 "
"46c239bf-f07e-47be-993a-ec7d45ba0797 "
"d739120e-bc14-4ff9-a079-55a93c91795b "
"7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b "
"6242c6c8-1d3b-499d-a3f9-31835e92def6 "
"f1c7dfda-d7c9-4702-a14f-7847ae301e0c "
"2b129ce4-b25b-4ad4-9549-781deea34dab "
"8e13f4e7-accf-4070-9cae-1db8f0229f52 "
"5388e8b9-5e83-475c-b172-cc20e247faac "
"315382d0-f96e-4423-a755-c6eac4253f03 "
]
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 ('55a6f9e6-d278-4d60-8a87-b19500c5c6a0' , '46c239bf-f07e-47be-993a-ec7d45ba0797' , 'd739120e-bc14-4ff9-a079-55a93c91795b' , '7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b' , '6242c6c8-1d3b-499d-a3f9-31835e92def6' , 'f1c7dfda-d7c9-4702-a14f-7847ae301e0c' , '2b129ce4-b25b-4ad4-9549-781deea34dab' , '8e13f4e7-accf-4070-9cae-1db8f0229f52' , '5388e8b9-5e83-475c-b172-cc20e247faac' , '315382d0-f96e-4423-a755-c6eac4253f03' ));
Copy
5
1.00 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 :
[
"c983a02f-7fc7-4b49-8225-14cfdd2aab6e "
]
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 = 'c983a02f-7fc7-4b49-8225-14cfdd2aab6e' ;
Copy
6
1.72 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 :
[
"c983a02f-7fc7-4b49-8225-14cfdd2aab6e "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'c983a02f-7fc7-4b49-8225-14cfdd2aab6e' GROUP BY proposal_id ;
Copy
7
0.65 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"c983a02f-7fc7-4b49-8225-14cfdd2aab6e "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'c983a02f-7fc7-4b49-8225-14cfdd2aab6e' ;
Copy
8
0.72 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
9
0.38 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
10
2.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 :
[
"c983a02f-7fc7-4b49-8225-14cfdd2aab6e "
]
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 = 'c983a02f-7fc7-4b49-8225-14cfdd2aab6e' ORDER BY pg . id ASC , p . id ASC ;
Copy
11
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 :
[
"6db0845f-8b2a-4edc-9e75-d56048a2cc08 "
]
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 = '6db0845f-8b2a-4edc-9e75-d56048a2cc08' ;
Copy
12
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 :
[
"6db0845f-8b2a-4edc-9e75-d56048a2cc08 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '6db0845f-8b2a-4edc-9e75-d56048a2cc08' GROUP BY proposal_id ;
Copy
13
0.22 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"6db0845f-8b2a-4edc-9e75-d56048a2cc08 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '6db0845f-8b2a-4edc-9e75-d56048a2cc08' ;
Copy
14
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
15
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
16
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 :
[
"6db0845f-8b2a-4edc-9e75-d56048a2cc08 "
]
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 = '6db0845f-8b2a-4edc-9e75-d56048a2cc08' ORDER BY pg . id ASC , p . id ASC ;
Copy
17
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 :
[
"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
18
0.26 ms
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = ? GROUP BY proposal_id
Parameters :
[
"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
19
0.15 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
20
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
21
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
22
1.23 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
23
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 :
[
"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
24
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 :
[
"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
25
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
26
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
27
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
28
1.16 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
29
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 :
[
"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
30
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 :
[
"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
31
0.15 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
32
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
33
0.23 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = ?
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
34
1.17 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
35
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 :
[
"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
36
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 :
[
"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
37
0.18 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
38
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
39
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
40
1.17 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
41
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 :
[
"4473e346-bdab-40d0-996a-b719e131e2a4 "
]
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 = '4473e346-bdab-40d0-996a-b719e131e2a4' ;
Copy
42
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 :
[
"4473e346-bdab-40d0-996a-b719e131e2a4 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '4473e346-bdab-40d0-996a-b719e131e2a4' GROUP BY proposal_id ;
Copy
43
0.19 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"4473e346-bdab-40d0-996a-b719e131e2a4 "
]
SELECT cnt FROM counters . proposal_view WHERE id = '4473e346-bdab-40d0-996a-b719e131e2a4' ;
Copy
44
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
45
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
46
0.71 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 :
[
"4473e346-bdab-40d0-996a-b719e131e2a4 "
]
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 = '4473e346-bdab-40d0-996a-b719e131e2a4' ORDER BY pg . id ASC , p . id ASC ;
Copy
47
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 :
[
"ddd5b9de-a188-4220-9d6d-d49e74d10495 "
]
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 = 'ddd5b9de-a188-4220-9d6d-d49e74d10495' ;
Copy
48
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 :
[
"ddd5b9de-a188-4220-9d6d-d49e74d10495 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'ddd5b9de-a188-4220-9d6d-d49e74d10495' GROUP BY proposal_id ;
Copy
49
0.16 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"ddd5b9de-a188-4220-9d6d-d49e74d10495 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'ddd5b9de-a188-4220-9d6d-d49e74d10495' ;
Copy
50
0.27 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
51
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
52
1.33 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 :
[
"ddd5b9de-a188-4220-9d6d-d49e74d10495 "
]
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 = 'ddd5b9de-a188-4220-9d6d-d49e74d10495' ORDER BY pg . id ASC , p . id ASC ;
Copy
53
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 :
[
"ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d "
]
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 = 'ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d' ;
Copy
54
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 :
[
"ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d' GROUP BY proposal_id ;
Copy
55
0.22 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d' ;
Copy
56
0.27 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
57
0.28 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = ?
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
58
0.86 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 :
[
"ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d "
]
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 = 'ad7eee0d-dc55-48dc-9ec2-f6b8ee7b566d' ORDER BY pg . id ASC , p . id ASC ;
Copy
59
0.45 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 :
[
"9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e "
]
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 = '9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e' ;
Copy
60
0.34 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 :
[
"9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = '9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e' GROUP BY proposal_id ;
Copy
61
0.22 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e "
]
SELECT cnt FROM counters . proposal_view WHERE id = '9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e' ;
Copy
62
0.28 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
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 = '0ca6c62b-3d61-469e-96d4-4082c4093a39' ;
Copy
64
0.80 ms
SELECT pg . id AS pg_id , pg . name AS pg_name , p . name AS p_name , p . in_short AS p_short , pp . value AS value FROM goods . proposal_parameter pp INNER JOIN goods . parameter p ON p . id = pp . parameter_id INNER JOIN goods . parameters_group pg ON pg . id = p . parameters_group_id WHERE pp . proposal_id = ? ORDER BY pg . id ASC , p . id ASC
Parameters :
[
"9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e "
]
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 = '9ed00a92-72a0-47d9-97f9-5c0dc7e2f47e' ORDER BY pg . id ASC , p . id ASC ;
Copy
65
0.41 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 :
[
"55a6f9e6-d278-4d60-8a87-b19500c5c6a0 "
"46c239bf-f07e-47be-993a-ec7d45ba0797 "
"d739120e-bc14-4ff9-a079-55a93c91795b "
"7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b "
"6242c6c8-1d3b-499d-a3f9-31835e92def6 "
"f1c7dfda-d7c9-4702-a14f-7847ae301e0c "
"2b129ce4-b25b-4ad4-9549-781deea34dab "
"8e13f4e7-accf-4070-9cae-1db8f0229f52 "
"5388e8b9-5e83-475c-b172-cc20e247faac "
"315382d0-f96e-4423-a755-c6eac4253f03 "
]
SELECT COUNT (p . id ) FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('55a6f9e6-d278-4d60-8a87-b19500c5c6a0' , '46c239bf-f07e-47be-993a-ec7d45ba0797' , 'd739120e-bc14-4ff9-a079-55a93c91795b' , '7d14b65b-7c1b-4bbc-9526-ddc8d089cf2b' , '6242c6c8-1d3b-499d-a3f9-31835e92def6' , 'f1c7dfda-d7c9-4702-a14f-7847ae301e0c' , '2b129ce4-b25b-4ad4-9549-781deea34dab' , '8e13f4e7-accf-4070-9cae-1db8f0229f52' , '5388e8b9-5e83-475c-b172-cc20e247faac' , '315382d0-f96e-4423-a755-c6eac4253f03' ));
Copy