Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.validated AS validated_7, t0.subscribed AS subscribed_8, t0.validation_key AS validation_key_9, t0.influxdb_url AS influxdb_url_10, t0.influxdb_user AS influxdb_user_11, t0.influxdb_password AS influxdb_password_12, t0.influxdb_name AS influxdb_name_13, t0.account_id AS account_id_14 FROM "user" t0 WHERE t0.email = ? LIMIT 1

[
  "iulian.arcus@tbs-avionics.com"
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.validated AS validated_7,
  t0.subscribed AS subscribed_8,
  t0.validation_key AS validation_key_9,
  t0.influxdb_url AS influxdb_url_10,
  t0.influxdb_user AS influxdb_user_11,
  t0.influxdb_password AS influxdb_password_12,
  t0.influxdb_name AS influxdb_name_13,
  t0.account_id AS account_id_14
FROM
  "user" t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.validated AS validated_7, t0.subscribed AS subscribed_8, t0.validation_key AS validation_key_9, t0.influxdb_url AS influxdb_url_10, t0.influxdb_user AS influxdb_user_11, t0.influxdb_password AS influxdb_password_12, t0.influxdb_name AS influxdb_name_13, t0.account_id AS account_id_14 FROM "user" t0 WHERE t0.email = 'iulian.arcus@tbs-avionics.com' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.master AS master_4, t0.climate AS climate_5, t0.is_deleted AS is_deleted_6, t0.seasons AS seasons_7, t0.start_date AS start_date_8, t0.owner_id AS owner_id_9 FROM growbox t0 WHERE t0.id = ?

[
  66
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.master AS master_4,
  t0.climate AS climate_5,
  t0.is_deleted AS is_deleted_6,
  t0.seasons AS seasons_7,
  t0.start_date AS start_date_8,
  t0.owner_id AS owner_id_9
FROM
  growbox t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.master AS master_4, t0.climate AS climate_5, t0.is_deleted AS is_deleted_6, t0.seasons AS seasons_7, t0.start_date AS start_date_8, t0.owner_id AS owner_id_9 FROM growbox t0 WHERE t0.id = 66;

SELECT t0.id AS id_1, t0.name AS name_2, t0.long_name AS long_name_3, t0.display_type AS display_type_4, t0.last_active_date AS last_active_date_5, t0.position AS position_6, t0.is_deleted AS is_deleted_7, t0.dashboard AS dashboard_8, t0.active AS active_9, t0.source AS source_10, t0.cache_key AS cache_key_11, t0.disc_type AS disc_type_12, t0.device_id AS device_id_13, t0.type FROM sensor t0 WHERE t0.id = ? AND t0.is_deleted = ? AND t0.type IN ('all', 'pump', 'co2', 'ec', 'humidity', 'light', 'ph', 'soilmoist', 'temp', 'vpd', 'water_level') ORDER BY t0.position ASC

[
  25
  0
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.long_name AS long_name_3,
  t0.display_type AS display_type_4,
  t0.last_active_date AS last_active_date_5,
  t0.position AS position_6,
  t0.is_deleted AS is_deleted_7,
  t0.dashboard AS dashboard_8,
  t0.active AS active_9,
  t0.source AS source_10,
  t0.cache_key AS cache_key_11,
  t0.disc_type AS disc_type_12,
  t0.device_id AS device_id_13,
  t0.type
FROM
  sensor t0
WHERE
  t0.id = ?
  AND t0.is_deleted = ?
  AND t0.type IN (
    'all', 'pump', 'co2', 'ec', 'humidity',
    'light', 'ph', 'soilmoist', 'temp',
    'vpd', 'water_level'
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.long_name AS long_name_3, t0.display_type AS display_type_4, t0.last_active_date AS last_active_date_5, t0.position AS position_6, t0.is_deleted AS is_deleted_7, t0.dashboard AS dashboard_8, t0.active AS active_9, t0.source AS source_10, t0.cache_key AS cache_key_11, t0.disc_type AS disc_type_12, t0.device_id AS device_id_13, t0.type FROM sensor t0 WHERE t0.id = 25 AND t0.is_deleted = 0 AND t0.type IN ('all', 'pump', 'co2', 'ec', 'humidity', 'light', 'ph', 'soilmoist', 'temp', 'vpd', 'water_level') ORDER BY t0.position ASC;

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.id = ? AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual')

[
  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.id = ?
  AND t0.type IN (
    'nutrient', 'lamp', 'fan', 'multi_socket',
    'virtual'
  )

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.id = 1 AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual');

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.parent_id = ? AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual')

[
  66
]

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.parent_id = ?
  AND t0.type IN (
    'nutrient', 'lamp', 'fan', 'multi_socket',
    'virtual'
  )

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.parent_id = 66 AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual');

SELECT t0.id AS id_1, t0.name AS name_2, t0.monthly_cost AS monthly_cost_3, t0.yearly_cost AS yearly_cost_4, t0.limit_sensor_storage_frequency AS limit_sensor_storage_frequency_5, t0.limit_sensor_storage_duration AS limit_sensor_storage_duration_6 FROM account t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.monthly_cost AS monthly_cost_3,
  t0.yearly_cost AS yearly_cost_4,
  t0.limit_sensor_storage_frequency AS limit_sensor_storage_frequency_5,
  t0.limit_sensor_storage_duration AS limit_sensor_storage_duration_6
FROM
  account t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.monthly_cost AS monthly_cost_3, t0.yearly_cost AS yearly_cost_4, t0.limit_sensor_storage_frequency AS limit_sensor_storage_frequency_5, t0.limit_sensor_storage_duration AS limit_sensor_storage_duration_6 FROM account t0 WHERE t0.id = 4;

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.port AS port_4, t0.sensor_id AS sensor_id_5 FROM sensor_log_entry t0 WHERE (t0.created_at >= ? AND t0.sensor_id = ?) ORDER BY t0.created_at DESC

[
  "2024-09-19 22:00:26"
  25
]

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.port AS port_4,
  t0.sensor_id AS sensor_id_5
FROM
  sensor_log_entry t0
WHERE
  (
    t0.created_at >= ?
    AND t0.sensor_id = ?
  )
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.port AS port_4, t0.sensor_id AS sensor_id_5 FROM sensor_log_entry t0 WHERE (t0.created_at >= '2024-09-19 22:00:26' AND t0.sensor_id = 25) ORDER BY t0.created_at DESC;