14.14 ms (31.16%)
18
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
5.97 ms (13.16%)
18
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.70 ms (12.57%)
16
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.52 ms (9.97%)
18
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
3.91 ms (8.61%)
18
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
3.15 ms (6.94%)
18
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
1.78 ms (3.93%)
1
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
1.48 ms (3.27%)
1
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
1.38 ms (3.05%)
6
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
1.15 ms (2.53%)
3
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
0.80 ms (1.76%)
1
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
0.65 ms (1.43%)
2
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
0.53 ms (1.16%)
1
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
0.21 ms (0.46%)
1
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