Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(p0_.id) AS sclr_0 FROM publication p0_ WHERE p0_.status IN (?, ?)

[
  "publicada"
  "adoptada"
]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  publication p0_
WHERE
  p0_.status IN (?, ?)

SELECT COUNT(p0_.id) AS sclr_0 FROM publication p0_ WHERE p0_.status IN ('publicada', 'adoptada');

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.summary AS summary_2, p0_.status AS status_3, p0_.created_at AS created_at_4, p0_.gender AS gender_5, p0_.birth_date AS birth_date_6, p0_.image_path AS image_path_7, p0_.rejection_note AS rejection_note_8, p0_.view_count AS view_count_9, u1_.id AS id_10, u1_.email AS email_11, u1_.roles AS roles_12, u1_.password AS password_13, u1_.full_name AS full_name_14, u1_.phone AS phone_15, u1_.city AS city_16, u1_.can_publish AS can_publish_17, u1_.reset_token AS reset_token_18, u1_.reset_requested_at AS reset_requested_at_19, u1_.created_at AS created_at_20, p0_.owner_id AS owner_id_21, p0_.province_id AS province_id_22, p0_.locality_id AS locality_id_23, p0_.animal_type_id AS animal_type_id_24, u1_.province_id AS province_id_25, u1_.locality_id AS locality_id_26 FROM publication p0_ LEFT JOIN `user` u1_ ON p0_.owner_id = u1_.id LEFT JOIN animal_type a2_ ON p0_.animal_type_id = a2_.id LEFT JOIN locality l3_ ON p0_.locality_id = l3_.id LEFT JOIN province p4_ ON p0_.province_id = p4_.id WHERE p0_.status IN (?, ?) ORDER BY p0_.created_at DESC LIMIT 6

[
  "publicada"
  "adoptada"
]

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.summary AS summary_2,
  p0_.status AS status_3,
  p0_.created_at AS created_at_4,
  p0_.gender AS gender_5,
  p0_.birth_date AS birth_date_6,
  p0_.image_path AS image_path_7,
  p0_.rejection_note AS rejection_note_8,
  p0_.view_count AS view_count_9,
  u1_.id AS id_10,
  u1_.email AS email_11,
  u1_.roles AS roles_12,
  u1_.password AS password_13,
  u1_.full_name AS full_name_14,
  u1_.phone AS phone_15,
  u1_.city AS city_16,
  u1_.can_publish AS can_publish_17,
  u1_.reset_token AS reset_token_18,
  u1_.reset_requested_at AS reset_requested_at_19,
  u1_.created_at AS created_at_20,
  p0_.owner_id AS owner_id_21,
  p0_.province_id AS province_id_22,
  p0_.locality_id AS locality_id_23,
  p0_.animal_type_id AS animal_type_id_24,
  u1_.province_id AS province_id_25,
  u1_.locality_id AS locality_id_26
FROM
  publication p0_
  LEFT JOIN `user` u1_ ON p0_.owner_id = u1_.id
  LEFT JOIN animal_type a2_ ON p0_.animal_type_id = a2_.id
  LEFT JOIN locality l3_ ON p0_.locality_id = l3_.id
  LEFT JOIN province p4_ ON p0_.province_id = p4_.id
WHERE
  p0_.status IN (?, ?)
ORDER BY
  p0_.created_at DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.summary AS summary_2, p0_.status AS status_3, p0_.created_at AS created_at_4, p0_.gender AS gender_5, p0_.birth_date AS birth_date_6, p0_.image_path AS image_path_7, p0_.rejection_note AS rejection_note_8, p0_.view_count AS view_count_9, u1_.id AS id_10, u1_.email AS email_11, u1_.roles AS roles_12, u1_.password AS password_13, u1_.full_name AS full_name_14, u1_.phone AS phone_15, u1_.city AS city_16, u1_.can_publish AS can_publish_17, u1_.reset_token AS reset_token_18, u1_.reset_requested_at AS reset_requested_at_19, u1_.created_at AS created_at_20, p0_.owner_id AS owner_id_21, p0_.province_id AS province_id_22, p0_.locality_id AS locality_id_23, p0_.animal_type_id AS animal_type_id_24, u1_.province_id AS province_id_25, u1_.locality_id AS locality_id_26 FROM publication p0_ LEFT JOIN `user` u1_ ON p0_.owner_id = u1_.id LEFT JOIN animal_type a2_ ON p0_.animal_type_id = a2_.id LEFT JOIN locality l3_ ON p0_.locality_id = l3_.id LEFT JOIN province p4_ ON p0_.province_id = p4_.id WHERE p0_.status IN ('publicada', 'adoptada') ORDER BY p0_.created_at DESC LIMIT 6;

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.can_publish = ?

[
  1
]

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_
WHERE
  u0_.can_publish = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_ WHERE u0_.can_publish = 1;

SELECT h0_.id AS id_0, h0_.chip_label AS chip_label_1, h0_.headline AS headline_2, h0_.lede AS lede_3, h0_.hero_background_path AS hero_background_path_4, h0_.meta_title AS meta_title_5, h0_.meta_description AS meta_description_6, h0_.meta_keywords AS meta_keywords_7, h0_.logo_path AS logo_path_8 FROM homepage_settings h0_ LIMIT 1

[]

SELECT
  h0_.id AS id_0,
  h0_.chip_label AS chip_label_1,
  h0_.headline AS headline_2,
  h0_.lede AS lede_3,
  h0_.hero_background_path AS hero_background_path_4,
  h0_.meta_title AS meta_title_5,
  h0_.meta_description AS meta_description_6,
  h0_.meta_keywords AS meta_keywords_7,
  h0_.logo_path AS logo_path_8
FROM
  homepage_settings h0_
LIMIT
  1

SELECT h0_.id AS id_0, h0_.chip_label AS chip_label_1, h0_.headline AS headline_2, h0_.lede AS lede_3, h0_.hero_background_path AS hero_background_path_4, h0_.meta_title AS meta_title_5, h0_.meta_description AS meta_description_6, h0_.meta_keywords AS meta_keywords_7, h0_.logo_path AS logo_path_8 FROM homepage_settings h0_ LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO visit_log (path, referer, created_at) VALUES (?, ?, ?)

[
  "/"
  null
  "2025-12-08 23:21:31"
]

INSERT INTO visit_log (path, referer, created_at)
VALUES
  (?, ?, ?)

INSERT INTO visit_log (path, referer, created_at) VALUES ('/', NULL, '2025-12-08 23:21:31');

"COMMIT"

[]

"COMMIT"

"COMMIT";