Symfony Profiler

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

[
  80
]

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

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE user SET last_activity_timestamp = ? WHERE id = ?

[
  1781040780
  80
]

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1781040780 WHERE id = 80;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN (?, ?) AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> ?)

[
  "available"
  "unavailable"
  1
]

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  item i0_
  LEFT JOIN location l1_ ON i0_.location_id = l1_.id
WHERE
  i0_.status IN (?, ?)
  AND (
    i0_.is_deleted IS NULL
    OR i0_.is_deleted <> ?
  )

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN ('available', 'unavailable') AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> 1);

SELECT DISTINCT i0_.id AS id_0, i0_.name AS name_1 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN (?, ?) AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> ?) ORDER BY i0_.name ASC LIMIT 20

[
  "available"
  "unavailable"
  1
]

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.name AS name_1
FROM
  item i0_
  LEFT JOIN location l1_ ON i0_.location_id = l1_.id
WHERE
  i0_.status IN (?, ?)
  AND (
    i0_.is_deleted IS NULL
    OR i0_.is_deleted <> ?
  )
ORDER BY
  i0_.name ASC
LIMIT
  20

SELECT DISTINCT i0_.id AS id_0, i0_.name AS name_1 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN ('available', 'unavailable') AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> 1) ORDER BY i0_.name ASC LIMIT 20;

SELECT i0_.id AS id_0, i0_.item_condition AS item_condition_1, i0_.specification AS specification_2, i0_.name AS name_3, i0_.sku AS sku_4, i0_.warranty_in_months AS warranty_in_months_5, i0_.created_at_timestamp AS created_at_timestamp_6, i0_.updated_at_timestamp AS updated_at_timestamp_7, i0_.serial_number AS serial_number_8, i0_.status AS status_9, i0_.is_deleted AS is_deleted_10, i0_.deleted_at_timestamp AS deleted_at_timestamp_11, i0_.template_id AS template_id_12, i0_.location_id AS location_id_13, i0_.assigned_items_id AS assigned_items_id_14, i0_.customer_id AS customer_id_15, i0_.brand_id AS brand_id_16, i0_.created_by_user_id AS created_by_user_id_17, i0_.last_updated_by_user_id AS last_updated_by_user_id_18, i0_.deleted_by_user_id AS deleted_by_user_id_19 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN (?, ?) AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> ?) AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.name ASC

[
  "available"
  "unavailable"
  1
  10
  11
  15
  20
  21
  17
  9
  14
  2
]

SELECT
  i0_.id AS id_0,
  i0_.item_condition AS item_condition_1,
  i0_.specification AS specification_2,
  i0_.name AS name_3,
  i0_.sku AS sku_4,
  i0_.warranty_in_months AS warranty_in_months_5,
  i0_.created_at_timestamp AS created_at_timestamp_6,
  i0_.updated_at_timestamp AS updated_at_timestamp_7,
  i0_.serial_number AS serial_number_8,
  i0_.status AS status_9,
  i0_.is_deleted AS is_deleted_10,
  i0_.deleted_at_timestamp AS deleted_at_timestamp_11,
  i0_.template_id AS template_id_12,
  i0_.location_id AS location_id_13,
  i0_.assigned_items_id AS assigned_items_id_14,
  i0_.customer_id AS customer_id_15,
  i0_.brand_id AS brand_id_16,
  i0_.created_by_user_id AS created_by_user_id_17,
  i0_.last_updated_by_user_id AS last_updated_by_user_id_18,
  i0_.deleted_by_user_id AS deleted_by_user_id_19
FROM
  item i0_
  LEFT JOIN location l1_ ON i0_.location_id = l1_.id
WHERE
  i0_.status IN (?, ?)
  AND (
    i0_.is_deleted IS NULL
    OR i0_.is_deleted <> ?
  )
  AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.item_condition AS item_condition_1, i0_.specification AS specification_2, i0_.name AS name_3, i0_.sku AS sku_4, i0_.warranty_in_months AS warranty_in_months_5, i0_.created_at_timestamp AS created_at_timestamp_6, i0_.updated_at_timestamp AS updated_at_timestamp_7, i0_.serial_number AS serial_number_8, i0_.status AS status_9, i0_.is_deleted AS is_deleted_10, i0_.deleted_at_timestamp AS deleted_at_timestamp_11, i0_.template_id AS template_id_12, i0_.location_id AS location_id_13, i0_.assigned_items_id AS assigned_items_id_14, i0_.customer_id AS customer_id_15, i0_.brand_id AS brand_id_16, i0_.created_by_user_id AS created_by_user_id_17, i0_.last_updated_by_user_id AS last_updated_by_user_id_18, i0_.deleted_by_user_id AS deleted_by_user_id_19 FROM item i0_ LEFT JOIN location l1_ ON i0_.location_id = l1_.id WHERE i0_.status IN ('available', 'unavailable') AND (i0_.is_deleted IS NULL OR i0_.is_deleted <> 1) AND i0_.id IN (10, 11, 15, 20, 21, 17, 9, 14, 2) ORDER BY i0_.name ASC;

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.kind AS kind_2, l0_.serial_number AS serial_number_3, l0_.metadata AS metadata_4, l0_.parent_location_id AS parent_location_id_5 FROM location l0_

[]

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.kind AS kind_2,
  l0_.serial_number AS serial_number_3,
  l0_.metadata AS metadata_4,
  l0_.parent_location_id AS parent_location_id_5
FROM
  location l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.kind AS kind_2, l0_.serial_number AS serial_number_3, l0_.metadata AS metadata_4, l0_.parent_location_id AS parent_location_id_5 FROM location l0_;