Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.title AS title_1, t0.source_url AS source_url_2, t0.path_name AS path_name_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.operator_id AS operator_id_8 FROM operator_camera t0 WHERE t0.path_name = ? LIMIT 1

[
  "camera2"
]

SELECT
  t0.title AS title_1,
  t0.source_url AS source_url_2,
  t0.path_name AS path_name_3,
  t0.enabled AS enabled_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.operator_id AS operator_id_8
FROM
  operator_camera t0
WHERE
  t0.path_name = ?
LIMIT
  1

SELECT t0.title AS title_1, t0.source_url AS source_url_2, t0.path_name AS path_name_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.operator_id AS operator_id_8 FROM operator_camera t0 WHERE t0.path_name = 'camera2' LIMIT 1;

SELECT o0_.title AS title_0, o0_.dir_name AS dir_name_1, o0_.created_at AS created_at_2, o0_.updated_at AS updated_at_3, o0_.id AS id_4, o0_.operator_id AS operator_id_5 FROM operator_human o0_ INNER JOIN operator o1_ ON o0_.operator_id = o1_.id INNER JOIN operator_camera o2_ ON (o2_.operator_id = o1_.id) WHERE o0_.id = ? AND o2_.id = ?

[
  0
  2
]

SELECT
  o0_.title AS title_0,
  o0_.dir_name AS dir_name_1,
  o0_.created_at AS created_at_2,
  o0_.updated_at AS updated_at_3,
  o0_.id AS id_4,
  o0_.operator_id AS operator_id_5
FROM
  operator_human o0_
  INNER JOIN operator o1_ ON o0_.operator_id = o1_.id
  INNER JOIN operator_camera o2_ ON (o2_.operator_id = o1_.id)
WHERE
  o0_.id = ?
  AND o2_.id = ?

SELECT o0_.title AS title_0, o0_.dir_name AS dir_name_1, o0_.created_at AS created_at_2, o0_.updated_at AS updated_at_3, o0_.id AS id_4, o0_.operator_id AS operator_id_5 FROM operator_human o0_ INNER JOIN operator o1_ ON o0_.operator_id = o1_.id INNER JOIN operator_camera o2_ ON (o2_.operator_id = o1_.id) WHERE o0_.id = 0 AND o2_.id = 2;

SELECT t0.face_event_dedup_minutes AS face_event_dedup_minutes_1, t0.face_detector_backend AS face_detector_backend_2, t0.face_distance_threshold AS face_distance_threshold_3, t0.face_match_min_margin AS face_match_min_margin_4, t0.face_min_size_px AS face_min_size_px_5, t0.single_identity_max_distance AS single_identity_max_distance_6, t0.min_photos_for_match AS min_photos_for_match_7, t0.yolo_conf_person AS yolo_conf_person_8, t0.yolo_conf_car AS yolo_conf_car_9, t0.yolo_conf_cat AS yolo_conf_cat_10, t0.yolo_conf_dog AS yolo_conf_dog_11, t0.motion_threshold AS motion_threshold_12, t0.motion_min_area AS motion_min_area_13, t0.inference_interval_sec AS inference_interval_sec_14, t0.motion_burst_interval_sec AS motion_burst_interval_sec_15, t0.min_bbox_area_ratio AS min_bbox_area_ratio_16, t0.min_bbox_area_ratio_object AS min_bbox_area_ratio_object_17, t0.max_bbox_area_ratio_animal AS max_bbox_area_ratio_animal_18, t0.min_animal_aspect_ratio AS min_animal_aspect_ratio_19, t0.max_animal_aspect_ratio AS max_animal_aspect_ratio_20, t0.animal_large_box_conf AS animal_large_box_conf_21, t0.person_animal_iou_suppress AS person_animal_iou_suppress_22, t0.small_car_area_ratio AS small_car_area_ratio_23, t0.small_car_min_conf AS small_car_min_conf_24, t0.min_car_aspect_ratio AS min_car_aspect_ratio_25, t0.max_car_aspect_ratio AS max_car_aspect_ratio_26, t0.frame_skip AS frame_skip_27, t0.event_session_absence_sec AS event_session_absence_sec_28, t0.event_session_absence_object_sec AS event_session_absence_object_sec_29, t0.yolo_active_model AS yolo_active_model_30, t0.yolo_last_train_at AS yolo_last_train_at_31, t0.yolo_last_train_map50 AS yolo_last_train_map50_32, t0.yolo_last_train_failure_at AS yolo_last_train_failure_at_33, t0.yolo_last_train_failure_error AS yolo_last_train_failure_error_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.id AS id_37 FROM recognition_settings t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.face_event_dedup_minutes AS face_event_dedup_minutes_1,
  t0.face_detector_backend AS face_detector_backend_2,
  t0.face_distance_threshold AS face_distance_threshold_3,
  t0.face_match_min_margin AS face_match_min_margin_4,
  t0.face_min_size_px AS face_min_size_px_5,
  t0.single_identity_max_distance AS single_identity_max_distance_6,
  t0.min_photos_for_match AS min_photos_for_match_7,
  t0.yolo_conf_person AS yolo_conf_person_8,
  t0.yolo_conf_car AS yolo_conf_car_9,
  t0.yolo_conf_cat AS yolo_conf_cat_10,
  t0.yolo_conf_dog AS yolo_conf_dog_11,
  t0.motion_threshold AS motion_threshold_12,
  t0.motion_min_area AS motion_min_area_13,
  t0.inference_interval_sec AS inference_interval_sec_14,
  t0.motion_burst_interval_sec AS motion_burst_interval_sec_15,
  t0.min_bbox_area_ratio AS min_bbox_area_ratio_16,
  t0.min_bbox_area_ratio_object AS min_bbox_area_ratio_object_17,
  t0.max_bbox_area_ratio_animal AS max_bbox_area_ratio_animal_18,
  t0.min_animal_aspect_ratio AS min_animal_aspect_ratio_19,
  t0.max_animal_aspect_ratio AS max_animal_aspect_ratio_20,
  t0.animal_large_box_conf AS animal_large_box_conf_21,
  t0.person_animal_iou_suppress AS person_animal_iou_suppress_22,
  t0.small_car_area_ratio AS small_car_area_ratio_23,
  t0.small_car_min_conf AS small_car_min_conf_24,
  t0.min_car_aspect_ratio AS min_car_aspect_ratio_25,
  t0.max_car_aspect_ratio AS max_car_aspect_ratio_26,
  t0.frame_skip AS frame_skip_27,
  t0.event_session_absence_sec AS event_session_absence_sec_28,
  t0.event_session_absence_object_sec AS event_session_absence_object_sec_29,
  t0.yolo_active_model AS yolo_active_model_30,
  t0.yolo_last_train_at AS yolo_last_train_at_31,
  t0.yolo_last_train_map50 AS yolo_last_train_map50_32,
  t0.yolo_last_train_failure_at AS yolo_last_train_failure_at_33,
  t0.yolo_last_train_failure_error AS yolo_last_train_failure_error_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.id AS id_37
FROM
  recognition_settings t0
WHERE
  t0.id = ?

SELECT t0.face_event_dedup_minutes AS face_event_dedup_minutes_1, t0.face_detector_backend AS face_detector_backend_2, t0.face_distance_threshold AS face_distance_threshold_3, t0.face_match_min_margin AS face_match_min_margin_4, t0.face_min_size_px AS face_min_size_px_5, t0.single_identity_max_distance AS single_identity_max_distance_6, t0.min_photos_for_match AS min_photos_for_match_7, t0.yolo_conf_person AS yolo_conf_person_8, t0.yolo_conf_car AS yolo_conf_car_9, t0.yolo_conf_cat AS yolo_conf_cat_10, t0.yolo_conf_dog AS yolo_conf_dog_11, t0.motion_threshold AS motion_threshold_12, t0.motion_min_area AS motion_min_area_13, t0.inference_interval_sec AS inference_interval_sec_14, t0.motion_burst_interval_sec AS motion_burst_interval_sec_15, t0.min_bbox_area_ratio AS min_bbox_area_ratio_16, t0.min_bbox_area_ratio_object AS min_bbox_area_ratio_object_17, t0.max_bbox_area_ratio_animal AS max_bbox_area_ratio_animal_18, t0.min_animal_aspect_ratio AS min_animal_aspect_ratio_19, t0.max_animal_aspect_ratio AS max_animal_aspect_ratio_20, t0.animal_large_box_conf AS animal_large_box_conf_21, t0.person_animal_iou_suppress AS person_animal_iou_suppress_22, t0.small_car_area_ratio AS small_car_area_ratio_23, t0.small_car_min_conf AS small_car_min_conf_24, t0.min_car_aspect_ratio AS min_car_aspect_ratio_25, t0.max_car_aspect_ratio AS max_car_aspect_ratio_26, t0.frame_skip AS frame_skip_27, t0.event_session_absence_sec AS event_session_absence_sec_28, t0.event_session_absence_object_sec AS event_session_absence_object_sec_29, t0.yolo_active_model AS yolo_active_model_30, t0.yolo_last_train_at AS yolo_last_train_at_31, t0.yolo_last_train_map50 AS yolo_last_train_map50_32, t0.yolo_last_train_failure_at AS yolo_last_train_failure_at_33, t0.yolo_last_train_failure_error AS yolo_last_train_failure_error_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.id AS id_37 FROM recognition_settings t0 WHERE t0.id = 1;

SELECT COUNT(*) FROM operator_camera_event e WHERE (e.camera_id = ?) AND (e.created_at >= ?) AND ((e.person LIKE ? OR e.person LIKE ?))

[
  2
  "2026-08-31 21:16:42+0300"
  "cat:%"
  "dog:%"
]

SELECT
  COUNT(*)
FROM
  operator_camera_event e
WHERE
  (e.camera_id = ?)
  AND (e.created_at >= ?)
  AND (
    (
      e.person LIKE ?
      OR e.person LIKE ?
    )
  )

SELECT COUNT(*) FROM operator_camera_event e WHERE (e.camera_id = 2) AND (e.created_at >= '2026-08-31 21:16:42+0300') AND ((e.person LIKE 'cat:%' OR e.person LIKE 'dog:%'));