Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.has_gpu AS has_gpu_13,
  t0.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.has_gpu AS has_gpu_13,
  t0.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.host_wowza_id AS host_wowza_id_2,
  t0.provider_type
FROM
  transcription_service t0
WHERE
  t0.provider_type IN ('local')

SELECT t0.id AS id_1, t0.host_wowza_id AS host_wowza_id_2, t0.provider_type FROM transcription_service t0 WHERE t0.provider_type IN ('local');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.has_gpu AS has_gpu_13,
  t0.rtmp_username AS rtmp_username_14,
  t0.rtmp_password AS rtmp_password_15,
  t0.transcription_service_id AS transcription_service_id_16,
  t0.sync_id AS sync_id_17,
  t18.stream AS stream_19,
  t18.video AS video_20,
  t18.video_prefix AS video_prefix_21,
  t18.wowza_id AS wowza_id_22,
  t23.active AS active_24,
  t23.wowza_id AS wowza_id_25,
  t23.storage_id AS storage_id_26
FROM
  wowza t0
  LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id
  LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id
WHERE
  t0.address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.wowza_id = t0.id WHERE t0.address = 'dev-wowza.valt.forasoft.com' LIMIT 1;

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 = '1470' 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 = 1470;

SELECT
  t0.id AS id_1,
  t0.motion_detection_enabled AS motion_detection_enabled_2,
  t0.room_id AS room_id_3,
  t0.video_id AS video_id_4,
  t0.audio_id AS audio_id_5
FROM
  device_source t0
WHERE
  t0.video_id = ?

SELECT t0.id AS id_1, t0.motion_detection_enabled AS motion_detection_enabled_2, t0.room_id AS room_id_3, t0.video_id AS video_id_4, t0.audio_id AS audio_id_5 FROM device_source t0 WHERE t0.video_id = 1470;

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.locked_automatically AS locked_automatically_7,
  t0.camera_sorting_order AS camera_sorting_order_8,
  t0.priority AS priority_9,
  t0.schedule_email AS schedule_email_10,
  t0.master_source_id AS master_source_id_11,
  t12.id AS id_13,
  t12.stop_at AS stop_at_14,
  t12.paused AS paused_15,
  t12.last_start_time AS last_start_time_16,
  t12.last_stop_time AS last_stop_time_17,
  t12.duration_before_last_start AS duration_before_last_start_18,
  t12.record_id AS record_id_19,
  t12.schedule_session_id AS schedule_session_id_20,
  t12.room_id AS room_id_21,
  t0.sharing_link_id AS sharing_link_id_22,
  t0.camera_io_id AS camera_io_id_23,
  t0.wowza_id AS wowza_id_24,
  t0.user_io_id AS user_io_id_25,
  t0.user_id AS user_id_26,
  t0.locked_by_id AS locked_by_id_27,
  t0.prepared_record_id AS prepared_record_id_28,
  t29.timeout AS timeout_30,
  t29.suspended_at AS suspended_at_31,
  t29.room_id AS room_id_32,
  t29.enabled_by_id AS enabled_by_id_33,
  t29.author_id AS author_id_34,
  t35.room_id AS room_id_36,
  t35.enabled_by_id AS enabled_by_id_37,
  t35.author_id AS author_id_38,
  t0.container_id AS container_id_39
FROM
  rooms t0
  LEFT JOIN recordings t12 ON t12.room_id = t0.id
  LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id
  LEFT JOIN room_locking t35 ON t35.room_id = t0.id
WHERE
  t0.id = ?

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.locked_automatically AS locked_automatically_7, t0.camera_sorting_order AS camera_sorting_order_8, t0.priority AS priority_9, t0.schedule_email AS schedule_email_10, t0.master_source_id AS master_source_id_11, t12.id AS id_13, t12.stop_at AS stop_at_14, t12.paused AS paused_15, t12.last_start_time AS last_start_time_16, t12.last_stop_time AS last_stop_time_17, t12.duration_before_last_start AS duration_before_last_start_18, t12.record_id AS record_id_19, t12.schedule_session_id AS schedule_session_id_20, t12.room_id AS room_id_21, t0.sharing_link_id AS sharing_link_id_22, t0.camera_io_id AS camera_io_id_23, t0.wowza_id AS wowza_id_24, t0.user_io_id AS user_io_id_25, t0.user_id AS user_id_26, t0.locked_by_id AS locked_by_id_27, t0.prepared_record_id AS prepared_record_id_28, t29.timeout AS timeout_30, t29.suspended_at AS suspended_at_31, t29.room_id AS room_id_32, t29.enabled_by_id AS enabled_by_id_33, t29.author_id AS author_id_34, t35.room_id AS room_id_36, t35.enabled_by_id AS enabled_by_id_37, t35.author_id AS author_id_38, t0.container_id AS container_id_39 FROM rooms t0 LEFT JOIN recordings t12 ON t12.room_id = t0.id LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id LEFT JOIN room_locking t35 ON t35.room_id = t0.id WHERE t0.id = 503;

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 = '3a934801-c303-4221-a757-740012b4ec15' AND t0.type IN ('common', 'record');

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.locked_automatically AS locked_automatically_7,
  t0.camera_sorting_order AS camera_sorting_order_8,
  t0.priority AS priority_9,
  t0.schedule_email AS schedule_email_10,
  t0.master_source_id AS master_source_id_11,
  t12.id AS id_13,
  t12.stop_at AS stop_at_14,
  t12.paused AS paused_15,
  t12.last_start_time AS last_start_time_16,
  t12.last_stop_time AS last_stop_time_17,
  t12.duration_before_last_start AS duration_before_last_start_18,
  t12.record_id AS record_id_19,
  t12.schedule_session_id AS schedule_session_id_20,
  t12.room_id AS room_id_21,
  t0.sharing_link_id AS sharing_link_id_22,
  t0.camera_io_id AS camera_io_id_23,
  t0.wowza_id AS wowza_id_24,
  t0.user_io_id AS user_io_id_25,
  t0.user_id AS user_id_26,
  t0.locked_by_id AS locked_by_id_27,
  t0.prepared_record_id AS prepared_record_id_28,
  t29.timeout AS timeout_30,
  t29.suspended_at AS suspended_at_31,
  t29.room_id AS room_id_32,
  t29.enabled_by_id AS enabled_by_id_33,
  t29.author_id AS author_id_34,
  t35.room_id AS room_id_36,
  t35.enabled_by_id AS enabled_by_id_37,
  t35.author_id AS author_id_38,
  t0.container_id AS container_id_39
FROM
  rooms t0
  LEFT JOIN recordings t12 ON t12.room_id = t0.id
  LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id
  LEFT JOIN room_locking t35 ON t35.room_id = t0.id
WHERE
  t0.id = ?

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.locked_automatically AS locked_automatically_7, t0.camera_sorting_order AS camera_sorting_order_8, t0.priority AS priority_9, t0.schedule_email AS schedule_email_10, t0.master_source_id AS master_source_id_11, t12.id AS id_13, t12.stop_at AS stop_at_14, t12.paused AS paused_15, t12.last_start_time AS last_start_time_16, t12.last_stop_time AS last_stop_time_17, t12.duration_before_last_start AS duration_before_last_start_18, t12.record_id AS record_id_19, t12.schedule_session_id AS schedule_session_id_20, t12.room_id AS room_id_21, t0.sharing_link_id AS sharing_link_id_22, t0.camera_io_id AS camera_io_id_23, t0.wowza_id AS wowza_id_24, t0.user_io_id AS user_io_id_25, t0.user_id AS user_id_26, t0.locked_by_id AS locked_by_id_27, t0.prepared_record_id AS prepared_record_id_28, t29.timeout AS timeout_30, t29.suspended_at AS suspended_at_31, t29.room_id AS room_id_32, t29.enabled_by_id AS enabled_by_id_33, t29.author_id AS author_id_34, t35.room_id AS room_id_36, t35.enabled_by_id AS enabled_by_id_37, t35.author_id AS author_id_38, t0.container_id AS container_id_39 FROM rooms t0 LEFT JOIN recordings t12 ON t12.room_id = t0.id LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id LEFT JOIN room_locking t35 ON t35.room_id = t0.id WHERE t0.id = 548;

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 = '1e907cee-33a1-4adb-a2f6-dc6def4b8d2a' AND t0.type IN ('common', 'record');

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.locked_automatically AS locked_automatically_7,
  t0.camera_sorting_order AS camera_sorting_order_8,
  t0.priority AS priority_9,
  t0.schedule_email AS schedule_email_10,
  t0.master_source_id AS master_source_id_11,
  t12.id AS id_13,
  t12.stop_at AS stop_at_14,
  t12.paused AS paused_15,
  t12.last_start_time AS last_start_time_16,
  t12.last_stop_time AS last_stop_time_17,
  t12.duration_before_last_start AS duration_before_last_start_18,
  t12.record_id AS record_id_19,
  t12.schedule_session_id AS schedule_session_id_20,
  t12.room_id AS room_id_21,
  t0.sharing_link_id AS sharing_link_id_22,
  t0.camera_io_id AS camera_io_id_23,
  t0.wowza_id AS wowza_id_24,
  t0.user_io_id AS user_io_id_25,
  t0.user_id AS user_id_26,
  t0.locked_by_id AS locked_by_id_27,
  t0.prepared_record_id AS prepared_record_id_28,
  t29.timeout AS timeout_30,
  t29.suspended_at AS suspended_at_31,
  t29.room_id AS room_id_32,
  t29.enabled_by_id AS enabled_by_id_33,
  t29.author_id AS author_id_34,
  t35.room_id AS room_id_36,
  t35.enabled_by_id AS enabled_by_id_37,
  t35.author_id AS author_id_38,
  t0.container_id AS container_id_39
FROM
  rooms t0
  LEFT JOIN recordings t12 ON t12.room_id = t0.id
  LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id
  LEFT JOIN room_locking t35 ON t35.room_id = t0.id
WHERE
  t0.id = ?

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.locked_automatically AS locked_automatically_7, t0.camera_sorting_order AS camera_sorting_order_8, t0.priority AS priority_9, t0.schedule_email AS schedule_email_10, t0.master_source_id AS master_source_id_11, t12.id AS id_13, t12.stop_at AS stop_at_14, t12.paused AS paused_15, t12.last_start_time AS last_start_time_16, t12.last_stop_time AS last_stop_time_17, t12.duration_before_last_start AS duration_before_last_start_18, t12.record_id AS record_id_19, t12.schedule_session_id AS schedule_session_id_20, t12.room_id AS room_id_21, t0.sharing_link_id AS sharing_link_id_22, t0.camera_io_id AS camera_io_id_23, t0.wowza_id AS wowza_id_24, t0.user_io_id AS user_io_id_25, t0.user_id AS user_id_26, t0.locked_by_id AS locked_by_id_27, t0.prepared_record_id AS prepared_record_id_28, t29.timeout AS timeout_30, t29.suspended_at AS suspended_at_31, t29.room_id AS room_id_32, t29.enabled_by_id AS enabled_by_id_33, t29.author_id AS author_id_34, t35.room_id AS room_id_36, t35.enabled_by_id AS enabled_by_id_37, t35.author_id AS author_id_38, t0.container_id AS container_id_39 FROM rooms t0 LEFT JOIN recordings t12 ON t12.room_id = t0.id LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id LEFT JOIN room_locking t35 ON t35.room_id = t0.id WHERE t0.id = 555;

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.locked_automatically AS locked_automatically_7,
  t0.camera_sorting_order AS camera_sorting_order_8,
  t0.priority AS priority_9,
  t0.schedule_email AS schedule_email_10,
  t0.master_source_id AS master_source_id_11,
  t12.id AS id_13,
  t12.stop_at AS stop_at_14,
  t12.paused AS paused_15,
  t12.last_start_time AS last_start_time_16,
  t12.last_stop_time AS last_stop_time_17,
  t12.duration_before_last_start AS duration_before_last_start_18,
  t12.record_id AS record_id_19,
  t12.schedule_session_id AS schedule_session_id_20,
  t12.room_id AS room_id_21,
  t0.sharing_link_id AS sharing_link_id_22,
  t0.camera_io_id AS camera_io_id_23,
  t0.wowza_id AS wowza_id_24,
  t0.user_io_id AS user_io_id_25,
  t0.user_id AS user_id_26,
  t0.locked_by_id AS locked_by_id_27,
  t0.prepared_record_id AS prepared_record_id_28,
  t29.timeout AS timeout_30,
  t29.suspended_at AS suspended_at_31,
  t29.room_id AS room_id_32,
  t29.enabled_by_id AS enabled_by_id_33,
  t29.author_id AS author_id_34,
  t35.room_id AS room_id_36,
  t35.enabled_by_id AS enabled_by_id_37,
  t35.author_id AS author_id_38,
  t0.container_id AS container_id_39
FROM
  rooms t0
  LEFT JOIN recordings t12 ON t12.room_id = t0.id
  LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id
  LEFT JOIN room_locking t35 ON t35.room_id = t0.id
WHERE
  t0.id = ?

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.locked_automatically AS locked_automatically_7, t0.camera_sorting_order AS camera_sorting_order_8, t0.priority AS priority_9, t0.schedule_email AS schedule_email_10, t0.master_source_id AS master_source_id_11, t12.id AS id_13, t12.stop_at AS stop_at_14, t12.paused AS paused_15, t12.last_start_time AS last_start_time_16, t12.last_stop_time AS last_stop_time_17, t12.duration_before_last_start AS duration_before_last_start_18, t12.record_id AS record_id_19, t12.schedule_session_id AS schedule_session_id_20, t12.room_id AS room_id_21, t0.sharing_link_id AS sharing_link_id_22, t0.camera_io_id AS camera_io_id_23, t0.wowza_id AS wowza_id_24, t0.user_io_id AS user_io_id_25, t0.user_id AS user_id_26, t0.locked_by_id AS locked_by_id_27, t0.prepared_record_id AS prepared_record_id_28, t29.timeout AS timeout_30, t29.suspended_at AS suspended_at_31, t29.room_id AS room_id_32, t29.enabled_by_id AS enabled_by_id_33, t29.author_id AS author_id_34, t35.room_id AS room_id_36, t35.enabled_by_id AS enabled_by_id_37, t35.author_id AS author_id_38, t0.container_id AS container_id_39 FROM rooms t0 LEFT JOIN recordings t12 ON t12.room_id = t0.id LEFT JOIN room_motion_detection t29 ON t29.room_id = t0.id LEFT JOIN room_locking t35 ON t35.room_id = t0.id WHERE t0.id = 558;