Symfony Profiler

SELECT
  id,
  name,
  parent_id
FROM
  goods.category

SELECT id, name, parent_id FROM goods.category;

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )

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 ('a0f55932-0dc0-4b96-bf26-0f3f607f7d47', '9d236378-53ae-49fc-8b91-fe713f15607c', '651574b2-fe7f-40f0-9cba-6d9654657589', '7ae0f226-511d-4aab-8434-b7a0b5358c87', '1bf94b62-3f56-4eb3-8a9f-112a4074d5f1', 'c5924499-d1e7-4941-a173-b138ce490a58', '85174a0a-93e9-4132-b74f-cd01efc7bf0c', 'fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef', 'e35f1b4d-112b-4705-88f4-ad711ecdfc60', '421b3b2e-abea-4aa0-a748-230166d96103', '2c814812-d3b1-4f0b-bd3e-df9da0492ef7', '44290fb9-ddcc-41ff-833f-ffbde7e20cbe', '09be0bdb-6649-40af-85be-73ee69470eb4'));

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

SELECT p.id FROM goods.proposal p WHERE (NOT p.is_archive) AND (NOT p.is_private) AND (p.category_id IN ('a0f55932-0dc0-4b96-bf26-0f3f607f7d47', '9d236378-53ae-49fc-8b91-fe713f15607c', '651574b2-fe7f-40f0-9cba-6d9654657589', '7ae0f226-511d-4aab-8434-b7a0b5358c87', '1bf94b62-3f56-4eb3-8a9f-112a4074d5f1', 'c5924499-d1e7-4941-a173-b138ce490a58', '85174a0a-93e9-4132-b74f-cd01efc7bf0c', 'fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef', 'e35f1b4d-112b-4705-88f4-ad711ecdfc60', '421b3b2e-abea-4aa0-a748-230166d96103', '2c814812-d3b1-4f0b-bd3e-df9da0492ef7', '44290fb9-ddcc-41ff-833f-ffbde7e20cbe', '09be0bdb-6649-40af-85be-73ee69470eb4')) AND (p.price >= 0) AND (p.price <= 1000000) ORDER BY p.date_add DESC LIMIT 20;

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )

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 ('a0f55932-0dc0-4b96-bf26-0f3f607f7d47', '9d236378-53ae-49fc-8b91-fe713f15607c', '651574b2-fe7f-40f0-9cba-6d9654657589', '7ae0f226-511d-4aab-8434-b7a0b5358c87', '1bf94b62-3f56-4eb3-8a9f-112a4074d5f1', 'c5924499-d1e7-4941-a173-b138ce490a58', '85174a0a-93e9-4132-b74f-cd01efc7bf0c', 'fa4ffbb0-b4ca-4b1b-846c-1379a1dd32ef', 'e35f1b4d-112b-4705-88f4-ad711ecdfc60', '421b3b2e-abea-4aa0-a748-230166d96103', '2c814812-d3b1-4f0b-bd3e-df9da0492ef7', '44290fb9-ddcc-41ff-833f-ffbde7e20cbe', '09be0bdb-6649-40af-85be-73ee69470eb4'));

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 = '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 = ?
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 = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' GROUP BY proposal_id;

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3';

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

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;

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

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 = 'e6c63b4b-3c52-4670-ba1b-6b8546058bb3' 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 = '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 = ?
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 = '2f561b5a-51dd-420a-866b-465d5b411768' GROUP BY proposal_id;

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 = '2f561b5a-51dd-420a-866b-465d5b411768') AND (state = 0) GROUP BY proposal_id;

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = '2f561b5a-51dd-420a-866b-465d5b411768';

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

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;

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

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 = '2f561b5a-51dd-420a-866b-465d5b411768' 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 = '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 = ?
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 = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' GROUP BY proposal_id;

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 = '358aadd3-f59f-4740-98b9-bf4991b7c5d3') AND (state = 0) GROUP BY proposal_id;

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = '358aadd3-f59f-4740-98b9-bf4991b7c5d3';

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

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;

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

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 = '358aadd3-f59f-4740-98b9-bf4991b7c5d3' 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 = '07c08813-e82c-4572-86be-41500a5b860a';

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 = '07c08813-e82c-4572-86be-41500a5b860a' GROUP BY proposal_id;

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 = '07c08813-e82c-4572-86be-41500a5b860a') AND (state = 0) GROUP BY proposal_id;

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = '07c08813-e82c-4572-86be-41500a5b860a';

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