Query Metrics
4
Database Queries
4
Different statements
24.15 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
11.85 ms (49.07%) |
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 = ? LIMIT 1
Parameters:
[
"camera1"
]
|
||||||||||||||||||||||||||||
|
5.83 ms (24.12%) |
1 |
SELECT COUNT(*) FROM operator_camera_event e WHERE (e.camera_id = ?) AND (e.created_at >= ?) AND (e.person LIKE ?)
Parameters:
[ 1 "2026-08-31 16:44:48+0300" "person:%" ]
|
||||||||||||||||||||||||||||
|
5.18 ms (21.45%) |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.29 ms (5.36%) |
1 |
SELECT COUNT(*) FROM operator_camera_event e WHERE (e.camera_id = ?) AND (e.created_at >= ?) AND (e.human_id IS NULL) AND (e.person LIKE ?)
Parameters:
[ 1 "2026-08-31 16:30:33+0300" "person: unknown" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| HomeEye\Core\Domain\Operator\Camera\Camera | 1 |
| HomeEye\Core\Domain\Operator\Operator | 1 |
| HomeEye\Core\Domain\Operator\RecognitionSettings | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| HomeEye\Core\Domain\Operator\Camera\Camera | No errors. |
| HomeEye\Core\Domain\Operator\Operator | No errors. |
| HomeEye\Core\Domain\Operator\Camera\EventEnum | No errors. |
| HomeEye\Core\Domain\Operator\Camera\Event | No errors. |
| HomeEye\Core\Domain\Operator\RecognitionSettings | No errors. |