Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 26
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 1
• 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.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.id = ?

[
  "01655dad-396a-4061-a475-6b30d4fb5ca8"
]

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.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.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.id = '01655dad-396a-4061-a475-6b30d4fb5ca8';

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

[
  "01655dad-396a-4061-a475-6b30d4fb5ca8"
]

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 ('01655dad-396a-4061-a475-6b30d4fb5ca8') GROUP BY price_request_id;

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

[
  "01655dad-396a-4061-a475-6b30d4fb5ca8"
]

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

INSERT INTO counters.price_request_view (id, cnt) VALUES ('01655dad-396a-4061-a475-6b30d4fb5ca8', 1)
                                             ON conflict (id) DO UPDATE SET cnt = excluded.cnt + 1;