Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations 3
• 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 = ?

[
  184
]

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 = 184;

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

[
  184
]

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 = 184;

SELECT t0.id AS id_1, t0.codes AS codes_2, t0.equipments AS equipments_3, t0.state AS state_4, t0.weight AS weight_5, t0.comment AS comment_6, t0.warnings AS warnings_7, t0.errors AS errors_8, t0.created_at AS created_at_9, t0.completed_at AS completed_at_10, t0.wrong_divisions AS wrong_divisions_11, t0.state_status_id AS state_status_id_12, t0.company_id AS company_id_13, t0.created_by AS created_by_14, t0.owner_id AS owner_id_15 FROM batch_job t0 WHERE t0.id = ?

[
  "178872"
]

SELECT
  t0.id AS id_1,
  t0.codes AS codes_2,
  t0.equipments AS equipments_3,
  t0.state AS state_4,
  t0.weight AS weight_5,
  t0.comment AS comment_6,
  t0.warnings AS warnings_7,
  t0.errors AS errors_8,
  t0.created_at AS created_at_9,
  t0.completed_at AS completed_at_10,
  t0.wrong_divisions AS wrong_divisions_11,
  t0.state_status_id AS state_status_id_12,
  t0.company_id AS company_id_13,
  t0.created_by AS created_by_14,
  t0.owner_id AS owner_id_15
FROM
  batch_job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codes AS codes_2, t0.equipments AS equipments_3, t0.state AS state_4, t0.weight AS weight_5, t0.comment AS comment_6, t0.warnings AS warnings_7, t0.errors AS errors_8, t0.created_at AS created_at_9, t0.completed_at AS completed_at_10, t0.wrong_divisions AS wrong_divisions_11, t0.state_status_id AS state_status_id_12, t0.company_id AS company_id_13, t0.created_by AS created_by_14, t0.owner_id AS owner_id_15 FROM batch_job t0 WHERE t0.id = '178872';

SELECT COUNT(*) AS dctrn_count FROM (SELECT count(p0_.id) AS sclr_0, c1_.group_name AS group_name_1, c2_.company_name AS company_name_2 FROM batch_job b3_ INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id INNER JOIN products p0_ ON p0_.id = b4_.product_id INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id INNER JOIN divisions d5_ ON p0_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c2_ ON c6_.client_id = c2_.id WHERE b3_.id = ? AND b3_.company_id = ? GROUP BY c2_.id, c1_.group_name ORDER BY c1_.group_name ASC) dctrn_table

[
  178872
  6
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      count(p0_.id) AS sclr_0,
      c1_.group_name AS group_name_1,
      c2_.company_name AS company_name_2
    FROM
      batch_job b3_
      INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id
      INNER JOIN products p0_ ON p0_.id = b4_.product_id
      INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id
      INNER JOIN divisions d5_ ON p0_.division_id = d5_.id
      INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id
      INNER JOIN client c2_ ON c6_.client_id = c2_.id
    WHERE
      b3_.id = ?
      AND b3_.company_id = ?
    GROUP BY
      c2_.id,
      c1_.group_name
    ORDER BY
      c1_.group_name ASC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT count(p0_.id) AS sclr_0, c1_.group_name AS group_name_1, c2_.company_name AS company_name_2 FROM batch_job b3_ INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id INNER JOIN products p0_ ON p0_.id = b4_.product_id INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id INNER JOIN divisions d5_ ON p0_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c2_ ON c6_.client_id = c2_.id WHERE b3_.id = 178872 AND b3_.company_id = 6 GROUP BY c2_.id, c1_.group_name ORDER BY c1_.group_name ASC) dctrn_table;

SELECT count(p0_.id) AS sclr_0, c1_.group_name AS group_name_1, c2_.company_name AS company_name_2 FROM batch_job b3_ INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id INNER JOIN products p0_ ON p0_.id = b4_.product_id INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id INNER JOIN divisions d5_ ON p0_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c2_ ON c6_.client_id = c2_.id WHERE b3_.id = ? AND b3_.company_id = ? GROUP BY c2_.id, c1_.group_name ORDER BY c1_.group_name ASC LIMIT 100

[
  178872
  6
]

SELECT
  count(p0_.id) AS sclr_0,
  c1_.group_name AS group_name_1,
  c2_.company_name AS company_name_2
FROM
  batch_job b3_
  INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id
  INNER JOIN products p0_ ON p0_.id = b4_.product_id
  INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id
  INNER JOIN divisions d5_ ON p0_.division_id = d5_.id
  INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id
  INNER JOIN client c2_ ON c6_.client_id = c2_.id
WHERE
  b3_.id = ?
  AND b3_.company_id = ?
GROUP BY
  c2_.id,
  c1_.group_name
ORDER BY
  c1_.group_name ASC
LIMIT
  100

SELECT count(p0_.id) AS sclr_0, c1_.group_name AS group_name_1, c2_.company_name AS company_name_2 FROM batch_job b3_ INNER JOIN batch_job_product b4_ ON b3_.id = b4_.batch_job_id INNER JOIN products p0_ ON p0_.id = b4_.product_id INNER JOIN clothes_group c1_ ON p0_.clothes_group_id = c1_.id INNER JOIN divisions d5_ ON p0_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c2_ ON c6_.client_id = c2_.id WHERE b3_.id = 178872 AND b3_.company_id = 6 GROUP BY c2_.id, c1_.group_name ORDER BY c1_.group_name ASC LIMIT 100;