Symfony Profiler

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

Query Metrics

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.material AS material_2, w0_.dimension AS dimension_3, w0_.quantity AS quantity_4, w0_.cut_length AS cut_length_5, w0_.warning_level AS warning_level_6, w0_.price AS price_7, w0_.position AS position_8, w0_.supplier AS supplier_9, w0_.product_code AS product_code_10, w0_.image_file_name AS image_file_name_11, w0_.created_at AS created_at_12, w0_.updated_at AS updated_at_13, w0_.item_type AS item_type_14, w0_.is_active AS is_active_15, w0_.unit_id AS unit_id_16, w0_.warehouse_id AS warehouse_id_17, w0_.category_id AS category_id_18, w0_.subcategory_id AS subcategory_id_19 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.warehouse_id = ? ORDER BY w0_.name ASC LIMIT 100

[
  "%Lower%"
  "%Lower%"
  "%Lower%"
  3
]

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.material AS material_2,
  w0_.dimension AS dimension_3,
  w0_.quantity AS quantity_4,
  w0_.cut_length AS cut_length_5,
  w0_.warning_level AS warning_level_6,
  w0_.price AS price_7,
  w0_.position AS position_8,
  w0_.supplier AS supplier_9,
  w0_.product_code AS product_code_10,
  w0_.image_file_name AS image_file_name_11,
  w0_.created_at AS created_at_12,
  w0_.updated_at AS updated_at_13,
  w0_.item_type AS item_type_14,
  w0_.is_active AS is_active_15,
  w0_.unit_id AS unit_id_16,
  w0_.warehouse_id AS warehouse_id_17,
  w0_.category_id AS category_id_18,
  w0_.subcategory_id AS subcategory_id_19
FROM
  warehouse_items w0_
WHERE
  (
    w0_.name LIKE ?
    OR w0_.material LIKE ?
    OR w0_.dimension LIKE ?
  )
  AND w0_.warehouse_id = ?
ORDER BY
  w0_.name ASC
LIMIT
  100

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.material AS material_2, w0_.dimension AS dimension_3, w0_.quantity AS quantity_4, w0_.cut_length AS cut_length_5, w0_.warning_level AS warning_level_6, w0_.price AS price_7, w0_.position AS position_8, w0_.supplier AS supplier_9, w0_.product_code AS product_code_10, w0_.image_file_name AS image_file_name_11, w0_.created_at AS created_at_12, w0_.updated_at AS updated_at_13, w0_.item_type AS item_type_14, w0_.is_active AS is_active_15, w0_.unit_id AS unit_id_16, w0_.warehouse_id AS warehouse_id_17, w0_.category_id AS category_id_18, w0_.subcategory_id AS subcategory_id_19 FROM warehouse_items w0_ WHERE (w0_.name LIKE '%Lower%' OR w0_.material LIKE '%Lower%' OR w0_.dimension LIKE '%Lower%') AND w0_.warehouse_id = 3 ORDER BY w0_.name ASC LIMIT 100;

SELECT COUNT(w0_.id) AS sclr_0 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.is_active = ? AND w0_.warehouse_id = ?

[
  "%Lower%"
  "%Lower%"
  "%Lower%"
  1
  3
]

SELECT
  COUNT(w0_.id) AS sclr_0
FROM
  warehouse_items w0_
WHERE
  (
    w0_.name LIKE ?
    OR w0_.material LIKE ?
    OR w0_.dimension LIKE ?
  )
  AND w0_.is_active = ?
  AND w0_.warehouse_id = ?

SELECT COUNT(w0_.id) AS sclr_0 FROM warehouse_items w0_ WHERE (w0_.name LIKE '%Lower%' OR w0_.material LIKE '%Lower%' OR w0_.dimension LIKE '%Lower%') AND w0_.is_active = 1 AND w0_.warehouse_id = 3;

SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?

[
  2776
]

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.file_name AS file_name_3,
  t0.item_id AS item_id_4,
  t0.field_id AS field_id_5
FROM
  warehouse_item_value t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = 2776;

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.position AS position_7,
  t0.user_group AS user_group_8,
  t0.email AS email_9,
  t0.created_at AS created_at_10,
  t0.created_by_name AS created_by_name_11,
  t0.is_active AS is_active_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_cut AS is_cut_4, t0.is_active AS is_active_5 FROM warehouse_units t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.is_cut AS is_cut_4,
  t0.is_active AS is_active_5
FROM
  warehouse_units t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_cut AS is_cut_4, t0.is_active AS is_active_5 FROM warehouse_units t0 WHERE t0.id = 1;