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

[
  "d4b4d4e9-dad4-4ea8-a009-5de15bd80c5f"
]

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 = 'd4b4d4e9-dad4-4ea8-a009-5de15bd80c5f';

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

[
  "d4b4d4e9-dad4-4ea8-a009-5de15bd80c5f"
]

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 ('d4b4d4e9-dad4-4ea8-a009-5de15bd80c5f') GROUP BY price_request_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 = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1034
    __toString(): "a85f169a-f2a7-4b63-8356-a6aef3d270c0"
  }
]

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 = 'a85f169a-f2a7-4b63-8356-a6aef3d270c0';

SELECT avatar FROM account.person WHERE user_id = ?

[
  "a85f169a-f2a7-4b63-8356-a6aef3d270c0"
]

SELECT
  avatar
FROM
  account.person
WHERE
  user_id = ?

SELECT avatar FROM account.person WHERE user_id = 'a85f169a-f2a7-4b63-8356-a6aef3d270c0';

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

[
  "d4b4d4e9-dad4-4ea8-a009-5de15bd80c5f"
]

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 ('d4b4d4e9-dad4-4ea8-a009-5de15bd80c5f', 1)
                                             ON conflict (id) DO UPDATE SET cnt = excluded.cnt + 1;