1
2.05 ms
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
2
2.24 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 :
[
"3ae07b44-5a2f-4cb7-afb1-6c606d458b39 "
"26197838-fd64-4fd6-806f-f6411e5223d3 "
"6227032b-8045-4ec9-ba72-321372167d57 "
"20813c9e-2a83-4c18-9088-60b2e829d1e1 "
]
SELECT MIN (p . price ) AS min_price , MAX (p . price ) AS max_price FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('3ae07b44-5a2f-4cb7-afb1-6c606d458b39' , '26197838-fd64-4fd6-806f-f6411e5223d3' , '6227032b-8045-4ec9-ba72-321372167d57' , '20813c9e-2a83-4c18-9088-60b2e829d1e1' ));
Copy
3
1.06 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 :
[
"3ae07b44-5a2f-4cb7-afb1-6c606d458b39 "
"26197838-fd64-4fd6-806f-f6411e5223d3 "
"6227032b-8045-4ec9-ba72-321372167d57 "
"20813c9e-2a83-4c18-9088-60b2e829d1e1 "
0
1000000
]
SELECT p . id FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('3ae07b44-5a2f-4cb7-afb1-6c606d458b39' , '26197838-fd64-4fd6-806f-f6411e5223d3' , '6227032b-8045-4ec9-ba72-321372167d57' , '20813c9e-2a83-4c18-9088-60b2e829d1e1' )) AND (p . price > = 0 ) AND (p . price < = 1000000 ) ORDER BY p . date_add DESC LIMIT 20 ;
Copy
4
0.34 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 :
[
"3ae07b44-5a2f-4cb7-afb1-6c606d458b39 "
"26197838-fd64-4fd6-806f-f6411e5223d3 "
"6227032b-8045-4ec9-ba72-321372167d57 "
"20813c9e-2a83-4c18-9088-60b2e829d1e1 "
]
SELECT MIN (p . price ) AS min_price , MAX (p . price ) AS max_price FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('3ae07b44-5a2f-4cb7-afb1-6c606d458b39' , '26197838-fd64-4fd6-806f-f6411e5223d3' , '6227032b-8045-4ec9-ba72-321372167d57' , '20813c9e-2a83-4c18-9088-60b2e829d1e1' ));
Copy
5
1.10 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 :
[
"a2562eff-16e7-42e2-b523-61c1e8f57b85 "
]
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 = 'a2562eff-16e7-42e2-b523-61c1e8f57b85' ;
Copy
6
1.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 :
[
"a2562eff-16e7-42e2-b523-61c1e8f57b85 "
]
SELECT COUNT (id ) AS total , MIN (price ):: int AS start_price , MAX (price ):: int AS end_price FROM trade . auction_offer WHERE proposal_id = 'a2562eff-16e7-42e2-b523-61c1e8f57b85' GROUP BY proposal_id ;
Copy
7
0.39 ms
SELECT cnt FROM counters . proposal_view WHERE id = ?
Parameters :
[
"a2562eff-16e7-42e2-b523-61c1e8f57b85 "
]
SELECT cnt FROM counters . proposal_view WHERE id = 'a2562eff-16e7-42e2-b523-61c1e8f57b85' ;
Copy
8
0.64 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.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 = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
10
2.27 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 :
[
"a2562eff-16e7-42e2-b523-61c1e8f57b85 "
]
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 = 'a2562eff-16e7-42e2-b523-61c1e8f57b85' ORDER BY pg . id ASC , p . id ASC ;
Copy
11
0.43 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . is_private AS is_private_8 , t0 . items_count AS items_count_9 , t0 . delivery_method AS delivery_method_10 , t0 . payload AS payload_11 , t0 . category_id AS category_id_12 , t0 . item_id AS item_id_13 , t0 . owner_id AS owner_id_14 FROM goods . proposal t0 WHERE t0 . id = ?
Parameters :
[
"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
12
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 :
[
"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
13
0.19 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
14
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
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
0.56 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
17
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 :
[
"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
18
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 :
[
"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
19
0.15 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
20
0.17 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . patronymic AS patronymic_4 , t0 . gender AS gender_5 , t0 . birthdate AS birthdate_6 , t0 . email AS email_7 , t0 . phone AS phone_8 , t0 . avatar AS avatar_9 , t0 . user_id AS user_id_10 FROM account . person t0 WHERE t0 . user_id = ? LIMIT 1
Parameters :
[
"e2350144-be17-4130-bca9-2f200ed36640 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . surname AS surname_3 , t0 . patronymic AS patronymic_4 , t0 . gender AS gender_5 , t0 . birthdate AS birthdate_6 , t0 . email AS email_7 , t0 . phone AS phone_8 , t0 . avatar AS avatar_9 , t0 . user_id AS user_id_10 FROM account . person t0 WHERE t0 . user_id = 'e2350144-be17-4130-bca9-2f200ed36640' LIMIT 1 ;
Copy
21
0.17 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = ?
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . surname AS surname_2 , p0_ . patronymic AS patronymic_3 , p0_ . gender AS gender_4 , p0_ . birthdate AS birthdate_5 , p0_ . email AS email_6 , p0_ . phone AS phone_7 , p0_ . avatar AS avatar_8 , p0_ . user_id AS user_id_9 FROM account . person p0_ WHERE p0_ . user_id = 'e2350144-be17-4130-bca9-2f200ed36640' ;
Copy
22
0.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 :
[
"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
23
0.22 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 :
[
"3ae07b44-5a2f-4cb7-afb1-6c606d458b39 "
"26197838-fd64-4fd6-806f-f6411e5223d3 "
"6227032b-8045-4ec9-ba72-321372167d57 "
"20813c9e-2a83-4c18-9088-60b2e829d1e1 "
]
SELECT COUNT (p . id ) FROM goods . proposal p WHERE (NOT p . is_archive ) AND (NOT p . is_private ) AND (p . category_id IN ('3ae07b44-5a2f-4cb7-afb1-6c606d458b39' , '26197838-fd64-4fd6-806f-f6411e5223d3' , '6227032b-8045-4ec9-ba72-321372167d57' , '20813c9e-2a83-4c18-9088-60b2e829d1e1' ));
Copy