Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = ?

[
  262
]

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.active AS active_8,
  t0.locale AS locale_9,
  t0.newsletter AS newsletter_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deactivate_date AS deactivate_date_13,
  t0.group_id AS group_id_14,
  t0.company_id AS company_id_15,
  t0.client_id AS client_id_16,
  t0.division_id AS division_id_17,
  t0.client_localization_id AS client_localization_id_18,
  t19.id AS id_20,
  t19.notifications AS notifications_21,
  t19.user_id AS user_id_22,
  t23.id AS id_24,
  t23.after_login_route AS after_login_route_25,
  t23.user_id AS user_id_26,
  t23.printer_id AS printer_id_27,
  t23.mqtt_broker_id AS mqtt_broker_id_28,
  t0.worker_id AS worker_id_29,
  t0.created_by AS created_by_30,
  t0.updated_by AS updated_by_31
FROM
  user t0
  LEFT JOIN user_notification t19 ON t19.user_id = t0.id
  LEFT JOIN user_setting t23 ON t23.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = 262;

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.permissions AS permissions_8, t6.role_id AS role_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM user_role t0 LEFT JOIN role_permission t6 ON t6.role_id = t0.id INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = ?

[
  262
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t6.id AS id_7,
  t6.permissions AS permissions_8,
  t6.role_id AS role_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  user_role t0
  LEFT JOIN role_permission t6 ON t6.role_id = t0.id
  INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id
WHERE
  user_role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.permissions AS permissions_8, t6.role_id AS role_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM user_role t0 LEFT JOIN role_permission t6 ON t6.role_id = t0.id INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = 262;

SELECT count(DISTINCT (p0_.id)) AS sclr_0 FROM products p0_ INNER JOIN products_batch p1_ ON p0_.product_batch_id = p1_.id INNER JOIN clothe c2_ ON p0_.clothe_id = c2_.id INNER JOIN divisions d3_ ON p1_.division_id = d3_.id INNER JOIN client_localization c4_ ON p1_.client_localization_id = c4_.id INNER JOIN client c5_ ON c4_.client_id = c5_.id WHERE p0_.product_batch_id IS NOT NULL AND p0_.company_id = ? AND p0_.active = ? AND p1_.owner_id IS NULL AND p1_.created_at <= ?

[
  18
  1
  "2026-06-30 23:59:59"
]

SELECT
  count(
    DISTINCT (p0_.id)
  ) AS sclr_0
FROM
  products p0_
  INNER JOIN products_batch p1_ ON p0_.product_batch_id = p1_.id
  INNER JOIN clothe c2_ ON p0_.clothe_id = c2_.id
  INNER JOIN divisions d3_ ON p1_.division_id = d3_.id
  INNER JOIN client_localization c4_ ON p1_.client_localization_id = c4_.id
  INNER JOIN client c5_ ON c4_.client_id = c5_.id
WHERE
  p0_.product_batch_id IS NOT NULL
  AND p0_.company_id = ?
  AND p0_.active = ?
  AND p1_.owner_id IS NULL
  AND p1_.created_at <= ?

SELECT count(DISTINCT (p0_.id)) AS sclr_0 FROM products p0_ INNER JOIN products_batch p1_ ON p0_.product_batch_id = p1_.id INNER JOIN clothe c2_ ON p0_.clothe_id = c2_.id INNER JOIN divisions d3_ ON p1_.division_id = d3_.id INNER JOIN client_localization c4_ ON p1_.client_localization_id = c4_.id INNER JOIN client c5_ ON c4_.client_id = c5_.id WHERE p0_.product_batch_id IS NOT NULL AND p0_.company_id = 18 AND p0_.active = 1 AND p1_.owner_id IS NULL AND p1_.created_at <= '2026-06-30 23:59:59';