Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.controller AS controller_3,
  t0.io_last_call AS io_last_call_4,
  t0.io_last_port_called AS io_last_port_called_5,
  t0.io_configured AS io_configured_6,
  t0.has_audio AS has_audio_7,
  t0.control_enabled AS control_enabled_8,
  t0.status AS status_9,
  t0.camera_has_been_online AS camera_has_been_online_10,
  t0.pending_alert_token AS pending_alert_token_11,
  t12.device_id AS device_id_13,
  t0.wowza_id AS wowza_id_14,
  t0.type,
  t0.brand AS brand_15,
  t0.ip AS ip_16,
  t0.port AS port_17,
  t0.rtsp_port AS rtsp_port_18,
  t0.use_ssl AS use_ssl_19,
  t0.username AS username_20,
  t0.password AS password_21,
  t0.rtsp_url AS rtsp_url_22,
  t0.rtsp_url AS rtsp_url_23,
  t0.linked_user_id AS linked_user_id_24
FROM
  device t0
  LEFT JOIN device_ocr t12 ON t12.device_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'camera', 'beam', 'roam', 'controller',
    'stream'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.rtsp_url AS rtsp_url_22, t0.rtsp_url AS rtsp_url_23, t0.linked_user_id AS linked_user_id_24 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = 1475 AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream');

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.roles AS roles_9,
  t0.userType AS userType_10,
  t0.ldapScript AS ldapScript_11,
  t0.ldapDomain AS ldapDomain_12,
  t0.ldapDN AS ldapDN_13,
  t0.display_name AS display_name_14,
  t0.card_number AS card_number_15,
  t0.pin AS pin_16,
  t0.control_type AS control_type_17,
  t0.disabled_access AS disabled_access_18,
  t0.ldap_extra_data AS ldap_extra_data_19,
  t0.login_failures AS login_failures_20,
  t0.login_block_start AS login_block_start_21,
  t0.last_passwords AS last_passwords_22,
  t0.last_change_password_date AS last_change_password_date_23,
  t0.night_mode AS night_mode_24,
  t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25,
  t0.auto_play_audio_comments AS auto_play_audio_comments_26,
  t0.notification_sound AS notification_sound_27,
  t0.avatar_filename AS avatar_filename_28,
  t0.avatar_original_filename AS avatar_original_filename_29,
  t0.emails_alerts_enabled AS emails_alerts_enabled_30,
  t0.zoom_step AS zoom_step_31,
  t0.api_token AS api_token_32,
  t0.deleted_at AS deleted_at_33,
  t0.group_id AS group_id_34,
  t0.ldap_sync_id AS ldap_sync_id_35,
  t0.saml_config_id AS saml_config_id_36,
  t0.zoom_account_id AS zoom_account_id_37,
  t38.notifications_enabled AS notifications_enabled_39,
  t38.notifications_frequency AS notifications_frequency_40,
  t38.notifications_schedule_enabled AS notifications_schedule_enabled_41,
  t38.notifications_cron_last_execute AS notifications_cron_last_execute_42,
  t38.user_id AS user_id_43,
  t0.expiration_from_id AS expiration_from_id_44,
  t0.r_access_id AS r_access_id_45
FROM
  users t0
  LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.password AS password_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.roles AS roles_9, t0.userType AS userType_10, t0.ldapScript AS ldapScript_11, t0.ldapDomain AS ldapDomain_12, t0.ldapDN AS ldapDN_13, t0.display_name AS display_name_14, t0.card_number AS card_number_15, t0.pin AS pin_16, t0.control_type AS control_type_17, t0.disabled_access AS disabled_access_18, t0.ldap_extra_data AS ldap_extra_data_19, t0.login_failures AS login_failures_20, t0.login_block_start AS login_block_start_21, t0.last_passwords AS last_passwords_22, t0.last_change_password_date AS last_change_password_date_23, t0.night_mode AS night_mode_24, t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25, t0.auto_play_audio_comments AS auto_play_audio_comments_26, t0.notification_sound AS notification_sound_27, t0.avatar_filename AS avatar_filename_28, t0.avatar_original_filename AS avatar_original_filename_29, t0.emails_alerts_enabled AS emails_alerts_enabled_30, t0.zoom_step AS zoom_step_31, t0.api_token AS api_token_32, t0.deleted_at AS deleted_at_33, t0.group_id AS group_id_34, t0.ldap_sync_id AS ldap_sync_id_35, t0.saml_config_id AS saml_config_id_36, t0.zoom_account_id AS zoom_account_id_37, t38.notifications_enabled AS notifications_enabled_39, t38.notifications_frequency AS notifications_frequency_40, t38.notifications_schedule_enabled AS notifications_schedule_enabled_41, t38.notifications_cron_last_execute AS notifications_cron_last_execute_42, t38.user_id AS user_id_43, t0.expiration_from_id AS expiration_from_id_44, t0.r_access_id AS r_access_id_45 FROM users t0 LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id WHERE t0.id = 1;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.enabled AS enabled_2
FROM
  rights r0_
WHERE
  r0_.enabled = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.enabled AS enabled_2 FROM rights r0_ WHERE r0_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.record_duration AS record_duration_3,
  t0.record_duration_selection_type AS record_duration_selection_type_4,
  t0.io_record_name AS io_record_name_5,
  t0.search_results AS search_results_6,
  t0.room_sorting_order AS room_sorting_order_7,
  t0.disabled_access AS disabled_access_8,
  t0.default_review_view AS default_review_view_9,
  t0.default_schedule_view AS default_schedule_view_10,
  t0.default_report_view AS default_report_view_11,
  t0.default_review_list_period AS default_review_list_period_12,
  t0.deleted_users_video_access AS deleted_users_video_access_13,
  t0.without_groups_users_video_access AS without_groups_users_video_access_14,
  t0.deleted_at AS deleted_at_15,
  t0.comment_template_id AS comment_template_id_16,
  t0.marker_template_id AS marker_template_id_17,
  t0.info_template_id AS info_template_id_18,
  t0.evaluation_template_id AS evaluation_template_id_19,
  t0.default_retention_rule_id AS default_retention_rule_id_20,
  t0.expiration_from_id AS expiration_from_id_21,
  t0.container_id AS container_id_22,
  t0.r_access_id AS r_access_id_23
FROM
  user_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.record_duration AS record_duration_3, t0.record_duration_selection_type AS record_duration_selection_type_4, t0.io_record_name AS io_record_name_5, t0.search_results AS search_results_6, t0.room_sorting_order AS room_sorting_order_7, t0.disabled_access AS disabled_access_8, t0.default_review_view AS default_review_view_9, t0.default_schedule_view AS default_schedule_view_10, t0.default_report_view AS default_report_view_11, t0.default_review_list_period AS default_review_list_period_12, t0.deleted_users_video_access AS deleted_users_video_access_13, t0.without_groups_users_video_access AS without_groups_users_video_access_14, t0.deleted_at AS deleted_at_15, t0.comment_template_id AS comment_template_id_16, t0.marker_template_id AS marker_template_id_17, t0.info_template_id AS info_template_id_18, t0.evaluation_template_id AS evaluation_template_id_19, t0.default_retention_rule_id AS default_retention_rule_id_20, t0.expiration_from_id AS expiration_from_id_21, t0.container_id AS container_id_22, t0.r_access_id AS r_access_id_23 FROM user_groups t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_shared_audio AS is_shared_audio_3,
  t0.is_camera_io AS is_camera_io_4,
  t0.grid AS grid_5,
  t0.room_type AS room_type_6,
  t0.camera_sorting_order AS camera_sorting_order_7,
  t0.priority AS priority_8,
  t0.schedule_email AS schedule_email_9,
  t0.master_source_id AS master_source_id_10,
  t11.id AS id_12,
  t11.stop_at AS stop_at_13,
  t11.paused AS paused_14,
  t11.last_start_time AS last_start_time_15,
  t11.last_stop_time AS last_stop_time_16,
  t11.duration_before_last_start AS duration_before_last_start_17,
  t11.record_id AS record_id_18,
  t11.schedule_session_id AS schedule_session_id_19,
  t11.room_id AS room_id_20,
  t0.sharing_link_id AS sharing_link_id_21,
  t0.camera_io_id AS camera_io_id_22,
  t0.wowza_id AS wowza_id_23,
  t0.user_io_id AS user_io_id_24,
  t0.user_id AS user_id_25,
  t0.locked_by_id AS locked_by_id_26,
  t0.prepared_record_id AS prepared_record_id_27,
  t28.timeout AS timeout_29,
  t28.room_id AS room_id_30,
  t28.enabled_by_id AS enabled_by_id_31,
  t28.author_id AS author_id_32,
  t0.container_id AS container_id_33
FROM
  rooms t0
  LEFT JOIN recordings t11 ON t11.room_id = t0.id
  LEFT JOIN room_motion_detection t28 ON t28.room_id = t0.id
  INNER JOIN users_groups_rooms ON t0.id = users_groups_rooms.room_id
WHERE
  users_groups_rooms.user_group_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_shared_audio AS is_shared_audio_3, t0.is_camera_io AS is_camera_io_4, t0.grid AS grid_5, t0.room_type AS room_type_6, t0.camera_sorting_order AS camera_sorting_order_7, t0.priority AS priority_8, t0.schedule_email AS schedule_email_9, t0.master_source_id AS master_source_id_10, t11.id AS id_12, t11.stop_at AS stop_at_13, t11.paused AS paused_14, t11.last_start_time AS last_start_time_15, t11.last_stop_time AS last_stop_time_16, t11.duration_before_last_start AS duration_before_last_start_17, t11.record_id AS record_id_18, t11.schedule_session_id AS schedule_session_id_19, t11.room_id AS room_id_20, t0.sharing_link_id AS sharing_link_id_21, t0.camera_io_id AS camera_io_id_22, t0.wowza_id AS wowza_id_23, t0.user_io_id AS user_io_id_24, t0.user_id AS user_id_25, t0.locked_by_id AS locked_by_id_26, t0.prepared_record_id AS prepared_record_id_27, t28.timeout AS timeout_29, t28.room_id AS room_id_30, t28.enabled_by_id AS enabled_by_id_31, t28.author_id AS author_id_32, t0.container_id AS container_id_33 FROM rooms t0 LEFT JOIN recordings t11 ON t11.room_id = t0.id LEFT JOIN room_motion_detection t28 ON t28.room_id = t0.id INNER JOIN users_groups_rooms ON t0.id = users_groups_rooms.room_id WHERE users_groups_rooms.user_group_id = 1 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = '37fd3f5a-977e-4a7b-82cc-541a78bc10e0' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = 'b052fb59-ca57-4be9-8c7b-f297eb9bf3df' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = '2d4fdb73-c84a-475f-8968-0deee5f1c203' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = 'ca9973f5-fbef-4146-a636-94736bbe9cf7' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = 'a3de7d4a-8abd-4599-abab-b9bfa044fe2f' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.controller AS controller_3,
  t0.io_last_call AS io_last_call_4,
  t0.io_last_port_called AS io_last_port_called_5,
  t0.io_configured AS io_configured_6,
  t0.has_audio AS has_audio_7,
  t0.control_enabled AS control_enabled_8,
  t0.status AS status_9,
  t0.camera_has_been_online AS camera_has_been_online_10,
  t0.pending_alert_token AS pending_alert_token_11,
  t12.device_id AS device_id_13,
  t0.wowza_id AS wowza_id_14,
  t0.type,
  t0.brand AS brand_15,
  t0.ip AS ip_16,
  t0.port AS port_17,
  t0.rtsp_port AS rtsp_port_18,
  t0.use_ssl AS use_ssl_19,
  t0.username AS username_20,
  t0.password AS password_21,
  t0.rtsp_url AS rtsp_url_22,
  t0.rtsp_url AS rtsp_url_23,
  t0.linked_user_id AS linked_user_id_24
FROM
  device t0
  LEFT JOIN device_ocr t12 ON t12.device_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'camera', 'beam', 'roam', 'controller',
    'stream'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.rtsp_url AS rtsp_url_22, t0.rtsp_url AS rtsp_url_23, t0.linked_user_id AS linked_user_id_24 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = 1429 AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream');

SELECT
  t0.sampling_frequency AS sampling_frequency_1,
  t0.sensitivity AS sensitivity_2,
  t0.camera_id AS camera_id_3,
  t0.mask_id AS mask_id_4
FROM
  camera_motion_detection t0
WHERE
  t0.camera_id = ?

SELECT t0.sampling_frequency AS sampling_frequency_1, t0.sensitivity AS sensitivity_2, t0.camera_id AS camera_id_3, t0.mask_id AS mask_id_4 FROM camera_motion_detection t0 WHERE t0.camera_id = 1429;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = '170a3d3e-fdf5-4e0a-ba84-52ca70ba2031' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expiration AS expiration_3,
  t0.allow_share_markers AS allow_share_markers_4,
  t0.allow_new_markers AS allow_new_markers_5,
  t0.created_by_id AS created_by_id_6,
  t0.type
FROM
  sharing_link t0
WHERE
  t0.id = ?
  AND t0.type IN ('common', 'record')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expiration AS expiration_3, t0.allow_share_markers AS allow_share_markers_4, t0.allow_new_markers AS allow_new_markers_5, t0.created_by_id AS created_by_id_6, t0.type FROM sharing_link t0 WHERE t0.id = '35f4e536-ca52-4846-b70f-d8ca2e8f61a5' AND t0.type IN ('common', 'record');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.controller AS controller_3,
  t0.io_last_call AS io_last_call_4,
  t0.io_last_port_called AS io_last_port_called_5,
  t0.io_configured AS io_configured_6,
  t0.has_audio AS has_audio_7,
  t0.control_enabled AS control_enabled_8,
  t0.status AS status_9,
  t0.camera_has_been_online AS camera_has_been_online_10,
  t0.pending_alert_token AS pending_alert_token_11,
  t12.device_id AS device_id_13,
  t0.wowza_id AS wowza_id_14,
  t0.type,
  t0.brand AS brand_15,
  t0.ip AS ip_16,
  t0.port AS port_17,
  t0.rtsp_port AS rtsp_port_18,
  t0.use_ssl AS use_ssl_19,
  t0.username AS username_20,
  t0.password AS password_21,
  t0.rtsp_url AS rtsp_url_22,
  t0.rtsp_url AS rtsp_url_23,
  t0.linked_user_id AS linked_user_id_24
FROM
  device t0
  LEFT JOIN device_ocr t12 ON t12.device_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'camera', 'beam', 'roam', 'controller',
    'stream'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.controller AS controller_3, t0.io_last_call AS io_last_call_4, t0.io_last_port_called AS io_last_port_called_5, t0.io_configured AS io_configured_6, t0.has_audio AS has_audio_7, t0.control_enabled AS control_enabled_8, t0.status AS status_9, t0.camera_has_been_online AS camera_has_been_online_10, t0.pending_alert_token AS pending_alert_token_11, t12.device_id AS device_id_13, t0.wowza_id AS wowza_id_14, t0.type, t0.brand AS brand_15, t0.ip AS ip_16, t0.port AS port_17, t0.rtsp_port AS rtsp_port_18, t0.use_ssl AS use_ssl_19, t0.username AS username_20, t0.password AS password_21, t0.rtsp_url AS rtsp_url_22, t0.rtsp_url AS rtsp_url_23, t0.linked_user_id AS linked_user_id_24 FROM device t0 LEFT JOIN device_ocr t12 ON t12.device_id = t0.id WHERE t0.id = 1471 AND t0.type IN ('camera', 'beam', 'roam', 'controller', 'stream');