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 t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC

[
  4
  "2025-01-01"
  "2025-12-31"
]

SELECT
  t0_.id AS id_0,
  t0_.icon AS icon_1,
  t0_.title AS title_2,
  t0_.subtitle AS subtitle_3,
  t0_.amount AS amount_4,
  t0_.unit AS unit_5,
  t0_.type AS type_6,
  t0_.amount_style AS amount_style_7,
  t0_.date AS date_8
FROM
  transaction_history t0_
WHERE
  t0_.type = ?
  AND t0_.date >= ?
  AND t0_.date <= ?
ORDER BY
  t0_.date ASC

SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = 4 AND t0_.date >= '2025-01-01' AND t0_.date <= '2025-12-31' ORDER BY t0_.date ASC;

SELECT DISTINCT EXTRACT(YEAR FROM t.date) AS year FROM transaction_history t ORDER BY year ASC

[]

SELECT
  DISTINCT EXTRACT(
    YEAR
    FROM
      t.date
  ) AS year
FROM
  transaction_history t
ORDER BY
  year ASC

SELECT DISTINCT EXTRACT(YEAR FROM t.date) AS year FROM transaction_history t ORDER BY year ASC;

SELECT t0.id AS id_1, t0.smart_contract AS smart_contract_2, t0.name AS name_3, t0.company_name AS company_name_4, t0.location AS location_5, t0.country AS country_6, t0.country_flag AS country_flag_7, t0.description AS description_8, t0.rate AS rate_9, t0.category AS category_10, t0.amount AS amount_11, t0.amount_collected AS amount_collected_12, t0.waiting_people AS waiting_people_13, t0.people AS people_14, t0.economic_rating AS economic_rating_15, t0.legal_rating AS legal_rating_16, t0.community_rating AS community_rating_17, t0.favorite AS favorite_18, t0.start_date AS start_date_19, t0.end_date AS end_date_20 FROM investment t0

[]

SELECT
  t0.id AS id_1,
  t0.smart_contract AS smart_contract_2,
  t0.name AS name_3,
  t0.company_name AS company_name_4,
  t0.location AS location_5,
  t0.country AS country_6,
  t0.country_flag AS country_flag_7,
  t0.description AS description_8,
  t0.rate AS rate_9,
  t0.category AS category_10,
  t0.amount AS amount_11,
  t0.amount_collected AS amount_collected_12,
  t0.waiting_people AS waiting_people_13,
  t0.people AS people_14,
  t0.economic_rating AS economic_rating_15,
  t0.legal_rating AS legal_rating_16,
  t0.community_rating AS community_rating_17,
  t0.favorite AS favorite_18,
  t0.start_date AS start_date_19,
  t0.end_date AS end_date_20
FROM
  investment t0

SELECT t0.id AS id_1, t0.smart_contract AS smart_contract_2, t0.name AS name_3, t0.company_name AS company_name_4, t0.location AS location_5, t0.country AS country_6, t0.country_flag AS country_flag_7, t0.description AS description_8, t0.rate AS rate_9, t0.category AS category_10, t0.amount AS amount_11, t0.amount_collected AS amount_collected_12, t0.waiting_people AS waiting_people_13, t0.people AS people_14, t0.economic_rating AS economic_rating_15, t0.legal_rating AS legal_rating_16, t0.community_rating AS community_rating_17, t0.favorite AS favorite_18, t0.start_date AS start_date_19, t0.end_date AS end_date_20 FROM investment t0;

SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?

[
  1
]

SELECT
  t0_.amount AS amount_0
FROM
  transaction_history t0_
WHERE
  t0_.type = ?

SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = 1;

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 t0.id AS id_1, t0.smart_contract AS smart_contract_2, t0.name AS name_3, t0.company_name AS company_name_4, t0.location AS location_5, t0.country AS country_6, t0.country_flag AS country_flag_7, t0.description AS description_8, t0.rate AS rate_9, t0.category AS category_10, t0.amount AS amount_11, t0.amount_collected AS amount_collected_12, t0.waiting_people AS waiting_people_13, t0.people AS people_14, t0.economic_rating AS economic_rating_15, t0.legal_rating AS legal_rating_16, t0.community_rating AS community_rating_17, t0.favorite AS favorite_18, t0.start_date AS start_date_19, t0.end_date AS end_date_20 FROM investment t0 WHERE t0.smart_contract = ? LIMIT 1

[
  546333
]

SELECT
  t0.id AS id_1,
  t0.smart_contract AS smart_contract_2,
  t0.name AS name_3,
  t0.company_name AS company_name_4,
  t0.location AS location_5,
  t0.country AS country_6,
  t0.country_flag AS country_flag_7,
  t0.description AS description_8,
  t0.rate AS rate_9,
  t0.category AS category_10,
  t0.amount AS amount_11,
  t0.amount_collected AS amount_collected_12,
  t0.waiting_people AS waiting_people_13,
  t0.people AS people_14,
  t0.economic_rating AS economic_rating_15,
  t0.legal_rating AS legal_rating_16,
  t0.community_rating AS community_rating_17,
  t0.favorite AS favorite_18,
  t0.start_date AS start_date_19,
  t0.end_date AS end_date_20
FROM
  investment t0
WHERE
  t0.smart_contract = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.smart_contract AS smart_contract_2, t0.name AS name_3, t0.company_name AS company_name_4, t0.location AS location_5, t0.country AS country_6, t0.country_flag AS country_flag_7, t0.description AS description_8, t0.rate AS rate_9, t0.category AS category_10, t0.amount AS amount_11, t0.amount_collected AS amount_collected_12, t0.waiting_people AS waiting_people_13, t0.people AS people_14, t0.economic_rating AS economic_rating_15, t0.legal_rating AS legal_rating_16, t0.community_rating AS community_rating_17, t0.favorite AS favorite_18, t0.start_date AS start_date_19, t0.end_date AS end_date_20 FROM investment t0 WHERE t0.smart_contract = 546333 LIMIT 1;

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.amount AS amount_5, t0.unit AS unit_6, t0.type AS type_7, t0.amount_style AS amount_style_8, t0.date AS date_9 FROM transaction_history t0 WHERE t0.type = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.title AS title_3,
  t0.subtitle AS subtitle_4,
  t0.amount AS amount_5,
  t0.unit AS unit_6,
  t0.type AS type_7,
  t0.amount_style AS amount_style_8,
  t0.date AS date_9
FROM
  transaction_history t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.amount AS amount_5, t0.unit AS unit_6, t0.type AS type_7, t0.amount_style AS amount_style_8, t0.date AS date_9 FROM transaction_history t0 WHERE t0.type = 3;

SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = ?

[
  3
]

SELECT
  t0_.id AS id_0,
  t0_.icon AS icon_1,
  t0_.title AS title_2,
  t0_.subtitle AS subtitle_3,
  t0_.amount AS amount_4,
  t0_.unit AS unit_5,
  t0_.type AS type_6,
  t0_.amount_style AS amount_style_7,
  t0_.date AS date_8
FROM
  transaction_history t0_
WHERE
  t0_.type = ?

SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = 3;

SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = ? AND t0_.date >= ? AND t0_.date <= ?

[
  4
  "2025-01-01"
  "2025-12-31"
]

SELECT
  t0_.id AS id_0,
  t0_.icon AS icon_1,
  t0_.title AS title_2,
  t0_.subtitle AS subtitle_3,
  t0_.amount AS amount_4,
  t0_.unit AS unit_5,
  t0_.type AS type_6,
  t0_.amount_style AS amount_style_7,
  t0_.date AS date_8
FROM
  transaction_history t0_
WHERE
  t0_.type = ?
  AND t0_.date >= ?
  AND t0_.date <= ?

SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = 4 AND t0_.date >= '2025-01-01' AND t0_.date <= '2025-12-31';