Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 26
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Notifications
• Serializer
• Elastica
• Configuration

Query Metrics

SELECT id, name, parent_id FROM goods.category

[]

SELECT
  id,
  name,
  parent_id
FROM
  goods.category

SELECT id, name, parent_id FROM goods.category;

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"
]

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 = '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 = ? GROUP BY proposal_id

[
  "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 = ?
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 = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' GROUP BY proposal_id;

SELECT cnt FROM counters.proposal_view WHERE id = ?

[
  "4339bd72-8e8a-47e7-ac43-7c35ddecbfa3"
]

SELECT
  cnt
FROM
  counters.proposal_view
WHERE
  id = ?

SELECT cnt FROM counters.proposal_view WHERE id = '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 = ? ORDER BY pg.id ASC, p.id ASC

[
  "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 = ?
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 = '4339bd72-8e8a-47e7-ac43-7c35ddecbfa3' ORDER BY pg.id ASC, p.id ASC;

INSERT INTO counters.proposal_view (id, cnt) VALUES (?, 1)
                                             ON conflict (id) DO UPDATE SET cnt = excluded.cnt + 1

[
  "4339bd72-8e8a-47e7-ac43-7c35ddecbfa3"
]

INSERT INTO counters.proposal_view (id, cnt)
VALUES
  (?, 1) ON conflict (id) DO
UPDATE
SET
  cnt = excluded.cnt + 1

INSERT INTO counters.proposal_view (id, cnt) VALUES ('4339bd72-8e8a-47e7-ac43-7c35ddecbfa3', 1)
                                             ON conflict (id) DO UPDATE SET cnt = excluded.cnt + 1;