Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Debug
• Messages
• Emails
• Workflow
• Configuration

Query Metrics

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.readed AS readed_3, n0_.add_date AS add_date_4, n0_.read_date AS read_date_5, n0_.image AS image_6, n0_.style AS style_7 FROM notification n0_ WHERE n0_.readed = ? ORDER BY n0_.add_date DESC

[
  0
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.description AS description_2,
  n0_.readed AS readed_3,
  n0_.add_date AS add_date_4,
  n0_.read_date AS read_date_5,
  n0_.image AS image_6,
  n0_.style AS style_7
FROM
  notification n0_
WHERE
  n0_.readed = ?
ORDER BY
  n0_.add_date DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.readed AS readed_3, n0_.add_date AS add_date_4, n0_.read_date AS read_date_5, n0_.image AS image_6, n0_.style AS style_7 FROM notification n0_ WHERE n0_.readed = 0 ORDER BY n0_.add_date DESC;

SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.start_date >= ? ORDER BY i0_.start_date DESC, i0_.id DESC LIMIT 20

[
  "2024-01-01"
]

SELECT
  i0_.id AS id_0,
  i0_.smart_contract AS smart_contract_1,
  i0_.name AS name_2,
  i0_.company_name AS company_name_3,
  i0_.location AS location_4,
  i0_.country AS country_5,
  i0_.country_flag AS country_flag_6,
  i0_.description AS description_7,
  i0_.rate AS rate_8,
  i0_.category AS category_9,
  i0_.amount AS amount_10,
  i0_.amount_collected AS amount_collected_11,
  i0_.waiting_people AS waiting_people_12,
  i0_.people AS people_13,
  i0_.economic_rating AS economic_rating_14,
  i0_.legal_rating AS legal_rating_15,
  i0_.community_rating AS community_rating_16,
  i0_.favorite AS favorite_17,
  i0_.start_date AS start_date_18,
  i0_.end_date AS end_date_19
FROM
  investment i0_
WHERE
  i0_.start_date >= ?
ORDER BY
  i0_.start_date DESC,
  i0_.id DESC
LIMIT
  20

SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.start_date >= '2024-01-01' ORDER BY i0_.start_date DESC, i0_.id DESC LIMIT 20;

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  7
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 7 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  6
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 6 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  9
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 9 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  5
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 5 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  4
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 4 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  8
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 8 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  3
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 3 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  2
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 2 AND r0_.data <= '2026-07-08 13:36:00';

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?

[
  1
  "2026-07-08 13:36:00"
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.investment_id = ?
  AND r0_.data <= ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = 1 AND r0_.data <= '2026-07-08 13:36:00';