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.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.wowza_id = t0.id WHERE t0.address = 'dev-wowza.valt.forasoft.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.available_size AS available_size_3,
  t0.reserved_size AS reserved_size_4
FROM
  wowza_storage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.available_size AS available_size_3, t0.reserved_size AS reserved_size_4 FROM wowza_storage t0 WHERE t0.id = 3048;

SELECT
  r0_.id AS id_0,
  r0_.stop_at AS stop_at_1,
  r0_.paused AS paused_2,
  r0_.last_start_time AS last_start_time_3,
  r0_.last_stop_time AS last_stop_time_4,
  r0_.duration_before_last_start AS duration_before_last_start_5,
  r0_.record_id AS record_id_6,
  r0_.schedule_session_id AS schedule_session_id_7,
  r0_.room_id AS room_id_8
FROM
  recordings r0_
  INNER JOIN record r1_ ON r0_.record_id = r1_.id
  AND r1_.type IN (
    'record', 'scheduled', 'io', 'api',
    'motion'
  )
  INNER JOIN record_video r2_ ON r1_.id = r2_.record_id
  AND r2_.type IN (
    'unplayable', 'playable', 'camera'
  )
  INNER JOIN record_video_location r3_ ON (r3_.video_id = r2_.id)
WHERE
  r3_.wowza_id = ?

SELECT r0_.id AS id_0, r0_.stop_at AS stop_at_1, r0_.paused AS paused_2, r0_.last_start_time AS last_start_time_3, r0_.last_stop_time AS last_stop_time_4, r0_.duration_before_last_start AS duration_before_last_start_5, r0_.record_id AS record_id_6, r0_.schedule_session_id AS schedule_session_id_7, r0_.room_id AS room_id_8 FROM recordings r0_ INNER JOIN record r1_ ON r0_.record_id = r1_.id AND r1_.type IN ('record', 'scheduled', 'io', 'api', 'motion') INNER JOIN record_video r2_ ON r1_.id = r2_.record_id AND r2_.type IN ('unplayable', 'playable', 'camera') INNER JOIN record_video_location r3_ ON (r3_.video_id = r2_.id) WHERE r3_.wowza_id = 70;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  wowza_storage
SET
  available_size = ?
WHERE
  id = ?

UPDATE wowza_storage SET available_size = '4886429696' WHERE id = 3048;

"COMMIT"

"COMMIT";

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.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.wowza_id = t0.id;