Symfony Profiler

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

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 = '5c03c357-27e1-483d-8425-248f812e72bc' ORDER BY pg.id ASC, p.id ASC;

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 = ?

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 = '5c03c357-27e1-483d-8425-248f812e72bc';

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

SELECT COUNT(id) AS total, MIN(price)::int AS start_price, MAX(price)::int AS end_price FROM trade.auction_offer WHERE proposal_id = '5c03c357-27e1-483d-8425-248f812e72bc' GROUP BY proposal_id;

SELECT
  id,
  name,
  parent_id
FROM
  goods.category

SELECT id, name, parent_id FROM goods.category;

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = '5c03c357-27e1-483d-8425-248f812e72bc';

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;

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';

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;

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

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 ('3fb3349d-ce57-4d5a-90ab-7a5c99600460', '8748cbef-b46b-4944-893e-a5f3380a9654', 'e1489e3f-99db-4038-8f5b-3890a31a6df8', 'b0eb2cde-2a3a-4146-b0d6-f6e48c7c1a02') GROUP BY price_request_id;

SELECT
  avatar
FROM
  account.person
WHERE
  user_id = ?

SELECT avatar FROM account.person WHERE user_id = '0ca6c62b-3d61-469e-96d4-4082c4093a39';

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;

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;

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;

SELECT
  COUNT(id) AS new
FROM
  trade.auction_offer
WHERE
  (proposal_id = ?)
  AND (state = 0)
GROUP BY
  proposal_id

SELECT COUNT(id) AS new FROM trade.auction_offer WHERE (proposal_id = 'db2d4121-3309-4483-9b60-153288623a86') AND (state = 0) GROUP BY proposal_id;

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

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 ('aaf4a2db-4ad5-4ab7-b2a6-c574d6c39974', '01655dad-396a-4061-a475-6b30d4fb5ca8', 'd4b4d4e9-dad4-4ea8-a009-5de15bd80c5f', '8fd98b8e-da87-4853-b9a0-821c2599c026', 'dac72e6e-ff01-4bde-9edc-8074f861d104', '85dbf9ad-345c-4c78-8910-b23f4533ee78', 'e276723d-4441-4da3-a0bd-5fca5e737089', '095a3e27-6bdd-4736-b2a4-071c12cbe02c') GROUP BY price_request_id;