Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT w0_.id) AS sclr_0 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = ?

[
  1
]

SELECT
  count(DISTINCT w0_.id) AS sclr_0
FROM
  warehouse_items w0_
  LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id
WHERE
  w0_.warehouse_id = ?

SELECT count(DISTINCT w0_.id) AS sclr_0 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.created_by_name AS created_by_name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7 FROM warehouses t0 WHERE t0.is_active = ? ORDER BY t0.name ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.address AS address_4,
  t0.created_by_name AS created_by_name_5,
  t0.created_at AS created_at_6,
  t0.is_active AS is_active_7
FROM
  warehouses t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.created_by_name AS created_by_name_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7 FROM warehouses t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

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_.price AS price_6, w0_.sector AS sector_7, w0_.shelf AS shelf_8, w0_.rack AS rack_9, w0_.supplier AS supplier_10, w0_.product_code AS product_code_11, w0_.image_file_name AS image_file_name_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w1_.id AS id_15, w1_.name AS name_16, w1_.symbol AS symbol_17, w1_.is_cut AS is_cut_18, w1_.is_active AS is_active_19, w0_.unit_id AS unit_id_20, w0_.warehouse_id AS warehouse_id_21 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = ? ORDER BY w0_.name ASC

[
  1
]

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_.price AS price_6,
  w0_.sector AS sector_7,
  w0_.shelf AS shelf_8,
  w0_.rack AS rack_9,
  w0_.supplier AS supplier_10,
  w0_.product_code AS product_code_11,
  w0_.image_file_name AS image_file_name_12,
  w0_.created_at AS created_at_13,
  w0_.updated_at AS updated_at_14,
  w1_.id AS id_15,
  w1_.name AS name_16,
  w1_.symbol AS symbol_17,
  w1_.is_cut AS is_cut_18,
  w1_.is_active AS is_active_19,
  w0_.unit_id AS unit_id_20,
  w0_.warehouse_id AS warehouse_id_21
FROM
  warehouse_items w0_
  LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id
WHERE
  w0_.warehouse_id = ?
ORDER BY
  w0_.name ASC

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_.price AS price_6, w0_.sector AS sector_7, w0_.shelf AS shelf_8, w0_.rack AS rack_9, w0_.supplier AS supplier_10, w0_.product_code AS product_code_11, w0_.image_file_name AS image_file_name_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w1_.id AS id_15, w1_.name AS name_16, w1_.symbol AS symbol_17, w1_.is_cut AS is_cut_18, w1_.is_active AS is_active_19, w0_.unit_id AS unit_id_20, w0_.warehouse_id AS warehouse_id_21 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = 1 ORDER BY w0_.name ASC;

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_.price AS price_6, w0_.sector AS sector_7, w0_.shelf AS shelf_8, w0_.rack AS rack_9, w0_.supplier AS supplier_10, w0_.product_code AS product_code_11, w0_.image_file_name AS image_file_name_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w1_.id AS id_15, w1_.name AS name_16, w1_.symbol AS symbol_17, w1_.is_cut AS is_cut_18, w1_.is_active AS is_active_19, w0_.unit_id AS unit_id_20, w0_.warehouse_id AS warehouse_id_21 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = ? AND w0_.id IN (?, ?, ?, ?, ?) ORDER BY w0_.name ASC

[
  1
  1
  5
  3
  2
  4
]

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_.price AS price_6,
  w0_.sector AS sector_7,
  w0_.shelf AS shelf_8,
  w0_.rack AS rack_9,
  w0_.supplier AS supplier_10,
  w0_.product_code AS product_code_11,
  w0_.image_file_name AS image_file_name_12,
  w0_.created_at AS created_at_13,
  w0_.updated_at AS updated_at_14,
  w1_.id AS id_15,
  w1_.name AS name_16,
  w1_.symbol AS symbol_17,
  w1_.is_cut AS is_cut_18,
  w1_.is_active AS is_active_19,
  w0_.unit_id AS unit_id_20,
  w0_.warehouse_id AS warehouse_id_21
FROM
  warehouse_items w0_
  LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id
WHERE
  w0_.warehouse_id = ?
  AND w0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  w0_.name ASC

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_.price AS price_6, w0_.sector AS sector_7, w0_.shelf AS shelf_8, w0_.rack AS rack_9, w0_.supplier AS supplier_10, w0_.product_code AS product_code_11, w0_.image_file_name AS image_file_name_12, w0_.created_at AS created_at_13, w0_.updated_at AS updated_at_14, w1_.id AS id_15, w1_.name AS name_16, w1_.symbol AS symbol_17, w1_.is_cut AS is_cut_18, w1_.is_active AS is_active_19, w0_.unit_id AS unit_id_20, w0_.warehouse_id AS warehouse_id_21 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = 1 AND w0_.id IN (1, 5, 3, 2, 4) ORDER BY w0_.name ASC;

SELECT DISTINCT w0_.id AS id_0, w0_.name AS name_1 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = ? ORDER BY w0_.name ASC LIMIT 20

[
  1
]

SELECT
  DISTINCT w0_.id AS id_0,
  w0_.name AS name_1
FROM
  warehouse_items w0_
  LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id
WHERE
  w0_.warehouse_id = ?
ORDER BY
  w0_.name ASC
LIMIT
  20

SELECT DISTINCT w0_.id AS id_0, w0_.name AS name_1 FROM warehouse_items w0_ LEFT JOIN warehouse_units w1_ ON w0_.unit_id = w1_.id WHERE w0_.warehouse_id = 1 ORDER BY w0_.name ASC LIMIT 20;

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

[
  1
]

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