Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.sn AS sn_3, t0.long_name AS long_name_4, t0.disc_type AS disc_type_5, t0.is_deleted AS is_deleted_6, t0.data AS data_7, t0.last_seen AS last_seen_8, t0.parent_id AS parent_id_9, t0.virtual_parent_id AS virtual_parent_id_10, t0.owner_id AS owner_id_11, t0.type FROM device t0 WHERE t0.sn = ? AND t0.is_deleted = ? AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual') LIMIT 1

[
  "h5PtN4bD7pf"
  0
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sn AS sn_3,
  t0.long_name AS long_name_4,
  t0.disc_type AS disc_type_5,
  t0.is_deleted AS is_deleted_6,
  t0.data AS data_7,
  t0.last_seen AS last_seen_8,
  t0.parent_id AS parent_id_9,
  t0.virtual_parent_id AS virtual_parent_id_10,
  t0.owner_id AS owner_id_11,
  t0.type
FROM
  device t0
WHERE
  t0.sn = ?
  AND t0.is_deleted = ?
  AND t0.type IN (
    'nutrient', 'lamp', 'fan', 'multi_socket',
    'virtual'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sn AS sn_3, t0.long_name AS long_name_4, t0.disc_type AS disc_type_5, t0.is_deleted AS is_deleted_6, t0.data AS data_7, t0.last_seen AS last_seen_8, t0.parent_id AS parent_id_9, t0.virtual_parent_id AS virtual_parent_id_10, t0.owner_id AS owner_id_11, t0.type FROM device t0 WHERE t0.sn = 'h5PtN4bD7pf' AND t0.is_deleted = 0 AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual') LIMIT 1;