POST http://sbctest.kantoor.maarnseberg.nl/admin/relay-button/4/edit

Query Metrics

9 Database Queries
8 Different statements
5.79 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.79 ms
(48.29%)
1
"COMMIT"
Parameters:
[]
0.77 ms
(13.22%)
1
INSERT INTO relay_button_camera_setting (relay_button_id, camera_setting_id) VALUES (?, ?)
Parameters:
[
  4
  1
]
0.66 ms
(11.45%)
2
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.rtsp_url AS rtsp_url_3, c0_.stream_url AS stream_url_4, c0_.stream_type AS stream_type_5, c0_.poster_url AS poster_url_6, c0_.ffmpeg_enabled AS ffmpeg_enabled_7, c0_.ffmpeg_path AS ffmpeg_path_8, c0_.ffmpeg_transport AS ffmpeg_transport_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM camera_setting c0_ WHERE c0_.id IN (?)
Parameters:
[
  "1"
]
0.39 ms
(6.72%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.35 ms
(5.98%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.color AS color_4, t0.enabled AS enabled_5, t0.position AS position_6, t0.type AS type_7, t0.address AS address_8, t0.value AS value_9, t0.off_value AS off_value_10, t0.pulse_ms AS pulse_ms_11, t0.unit_id AS unit_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM relay_button t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
0.33 ms
(5.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.rtsp_url AS rtsp_url_4, t0.stream_url AS stream_url_5, t0.stream_type AS stream_type_6, t0.poster_url AS poster_url_7, t0.ffmpeg_enabled AS ffmpeg_enabled_8, t0.ffmpeg_path AS ffmpeg_path_9, t0.ffmpeg_transport AS ffmpeg_transport_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM camera_setting t0 INNER JOIN relay_button_camera_setting ON t0.id = relay_button_camera_setting.camera_setting_id WHERE relay_button_camera_setting.relay_button_id = ?
Parameters:
[
  4
]
0.31 ms
(5.41%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 INNER JOIN relay_button_allowed_user ON t0.id = relay_button_allowed_user.user_id WHERE relay_button_allowed_user.relay_button_id = ?
Parameters:
[
  4
]
0.19 ms
(3.28%)
1
"START TRANSACTION"
Parameters:
[]

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
App\Entity\User 1
App\Entity\RelayButton 1
App\Entity\CameraSetting 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\RelayButton No errors.
App\Entity\CameraSetting No errors.