Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 16;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE user SET last_activity_timestamp = ? WHERE id = ?

[
  1781710124
  16
]

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1781710124 WHERE id = 16;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT j0_.id AS id_0, j0_.kind AS kind_1, j0_.completed_at_timestamp AS completed_at_timestamp_2, j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3, j0_.specification AS specification_4, j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5, j0_.stock_status AS stock_status_6, j0_.created_at_timestamp AS created_at_timestamp_7, j0_.updated_at_timestamp AS updated_at_timestamp_8, j0_.status AS status_9, j0_.booked_at_timestamp AS booked_at_timestamp_10, j0_.metadata AS metadata_11, j0_.arrival_timestamp AS arrival_timestamp_12, j0_.leaving_timestamp AS leaving_timestamp_13, j0_.display_id AS display_id_14, j0_.project_id AS project_id_15, j0_.reviewed_by_user_id AS reviewed_by_user_id_16, j0_.trainer_user_id AS trainer_user_id_17, j0_.quote_product_id AS quote_product_id_18, j0_.assigned_items_id AS assigned_items_id_19, j0_.created_by_user_id AS created_by_user_id_20, j0_.last_updated_by_user_id AS last_updated_by_user_id_21, j0_.assigned_user_id AS assigned_user_id_22 FROM job j0_ WHERE j0_.assigned_user_id = ? AND j0_.status = ? AND j0_.booked_at_timestamp IS NOT NULL AND j0_.booked_at_timestamp >= ? AND j0_.booked_at_timestamp < ? ORDER BY j0_.booked_at_timestamp ASC

[
  16
  "incomplete"
  1781650800
  1781737200
]

SELECT
  j0_.id AS id_0,
  j0_.kind AS kind_1,
  j0_.completed_at_timestamp AS completed_at_timestamp_2,
  j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3,
  j0_.specification AS specification_4,
  j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5,
  j0_.stock_status AS stock_status_6,
  j0_.created_at_timestamp AS created_at_timestamp_7,
  j0_.updated_at_timestamp AS updated_at_timestamp_8,
  j0_.status AS status_9,
  j0_.booked_at_timestamp AS booked_at_timestamp_10,
  j0_.metadata AS metadata_11,
  j0_.arrival_timestamp AS arrival_timestamp_12,
  j0_.leaving_timestamp AS leaving_timestamp_13,
  j0_.display_id AS display_id_14,
  j0_.project_id AS project_id_15,
  j0_.reviewed_by_user_id AS reviewed_by_user_id_16,
  j0_.trainer_user_id AS trainer_user_id_17,
  j0_.quote_product_id AS quote_product_id_18,
  j0_.assigned_items_id AS assigned_items_id_19,
  j0_.created_by_user_id AS created_by_user_id_20,
  j0_.last_updated_by_user_id AS last_updated_by_user_id_21,
  j0_.assigned_user_id AS assigned_user_id_22
FROM
  job j0_
WHERE
  j0_.assigned_user_id = ?
  AND j0_.status = ?
  AND j0_.booked_at_timestamp IS NOT NULL
  AND j0_.booked_at_timestamp >= ?
  AND j0_.booked_at_timestamp < ?
ORDER BY
  j0_.booked_at_timestamp ASC

SELECT j0_.id AS id_0, j0_.kind AS kind_1, j0_.completed_at_timestamp AS completed_at_timestamp_2, j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3, j0_.specification AS specification_4, j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5, j0_.stock_status AS stock_status_6, j0_.created_at_timestamp AS created_at_timestamp_7, j0_.updated_at_timestamp AS updated_at_timestamp_8, j0_.status AS status_9, j0_.booked_at_timestamp AS booked_at_timestamp_10, j0_.metadata AS metadata_11, j0_.arrival_timestamp AS arrival_timestamp_12, j0_.leaving_timestamp AS leaving_timestamp_13, j0_.display_id AS display_id_14, j0_.project_id AS project_id_15, j0_.reviewed_by_user_id AS reviewed_by_user_id_16, j0_.trainer_user_id AS trainer_user_id_17, j0_.quote_product_id AS quote_product_id_18, j0_.assigned_items_id AS assigned_items_id_19, j0_.created_by_user_id AS created_by_user_id_20, j0_.last_updated_by_user_id AS last_updated_by_user_id_21, j0_.assigned_user_id AS assigned_user_id_22 FROM job j0_ WHERE j0_.assigned_user_id = 16 AND j0_.status = 'incomplete' AND j0_.booked_at_timestamp IS NOT NULL AND j0_.booked_at_timestamp >= 1781650800 AND j0_.booked_at_timestamp < 1781737200 ORDER BY j0_.booked_at_timestamp ASC;

SELECT DISTINCT i0_.assigned_items_id AS sclr_0 FROM item i0_ WHERE i0_.status = ? AND i0_.assigned_items_id IS NOT NULL

[
  "collected"
]

SELECT
  DISTINCT i0_.assigned_items_id AS sclr_0
FROM
  item i0_
WHERE
  i0_.status = ?
  AND i0_.assigned_items_id IS NOT NULL

SELECT DISTINCT i0_.assigned_items_id AS sclr_0 FROM item i0_ WHERE i0_.status = 'collected' AND i0_.assigned_items_id IS NOT NULL;

SELECT j0_.id AS id_0, j0_.kind AS kind_1, j0_.completed_at_timestamp AS completed_at_timestamp_2, j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3, j0_.specification AS specification_4, j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5, j0_.stock_status AS stock_status_6, j0_.created_at_timestamp AS created_at_timestamp_7, j0_.updated_at_timestamp AS updated_at_timestamp_8, j0_.status AS status_9, j0_.booked_at_timestamp AS booked_at_timestamp_10, j0_.metadata AS metadata_11, j0_.arrival_timestamp AS arrival_timestamp_12, j0_.leaving_timestamp AS leaving_timestamp_13, j0_.display_id AS display_id_14, j0_.project_id AS project_id_15, j0_.reviewed_by_user_id AS reviewed_by_user_id_16, j0_.trainer_user_id AS trainer_user_id_17, j0_.quote_product_id AS quote_product_id_18, j0_.assigned_items_id AS assigned_items_id_19, j0_.created_by_user_id AS created_by_user_id_20, j0_.last_updated_by_user_id AS last_updated_by_user_id_21, j0_.assigned_user_id AS assigned_user_id_22 FROM job j0_ LEFT JOIN assigned_items a1_ ON j0_.assigned_items_id = a1_.id WHERE j0_.assigned_user_id = ? AND a1_.id IN (?, ?)

[
  16
  4544
  4632
]

SELECT
  j0_.id AS id_0,
  j0_.kind AS kind_1,
  j0_.completed_at_timestamp AS completed_at_timestamp_2,
  j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3,
  j0_.specification AS specification_4,
  j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5,
  j0_.stock_status AS stock_status_6,
  j0_.created_at_timestamp AS created_at_timestamp_7,
  j0_.updated_at_timestamp AS updated_at_timestamp_8,
  j0_.status AS status_9,
  j0_.booked_at_timestamp AS booked_at_timestamp_10,
  j0_.metadata AS metadata_11,
  j0_.arrival_timestamp AS arrival_timestamp_12,
  j0_.leaving_timestamp AS leaving_timestamp_13,
  j0_.display_id AS display_id_14,
  j0_.project_id AS project_id_15,
  j0_.reviewed_by_user_id AS reviewed_by_user_id_16,
  j0_.trainer_user_id AS trainer_user_id_17,
  j0_.quote_product_id AS quote_product_id_18,
  j0_.assigned_items_id AS assigned_items_id_19,
  j0_.created_by_user_id AS created_by_user_id_20,
  j0_.last_updated_by_user_id AS last_updated_by_user_id_21,
  j0_.assigned_user_id AS assigned_user_id_22
FROM
  job j0_
  LEFT JOIN assigned_items a1_ ON j0_.assigned_items_id = a1_.id
WHERE
  j0_.assigned_user_id = ?
  AND a1_.id IN (?, ?)

SELECT j0_.id AS id_0, j0_.kind AS kind_1, j0_.completed_at_timestamp AS completed_at_timestamp_2, j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3, j0_.specification AS specification_4, j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5, j0_.stock_status AS stock_status_6, j0_.created_at_timestamp AS created_at_timestamp_7, j0_.updated_at_timestamp AS updated_at_timestamp_8, j0_.status AS status_9, j0_.booked_at_timestamp AS booked_at_timestamp_10, j0_.metadata AS metadata_11, j0_.arrival_timestamp AS arrival_timestamp_12, j0_.leaving_timestamp AS leaving_timestamp_13, j0_.display_id AS display_id_14, j0_.project_id AS project_id_15, j0_.reviewed_by_user_id AS reviewed_by_user_id_16, j0_.trainer_user_id AS trainer_user_id_17, j0_.quote_product_id AS quote_product_id_18, j0_.assigned_items_id AS assigned_items_id_19, j0_.created_by_user_id AS created_by_user_id_20, j0_.last_updated_by_user_id AS last_updated_by_user_id_21, j0_.assigned_user_id AS assigned_user_id_22 FROM job j0_ LEFT JOIN assigned_items a1_ ON j0_.assigned_items_id = a1_.id WHERE j0_.assigned_user_id = 16 AND a1_.id IN (4544, 4632);