Symfony Profiler

[
  "route" => "api_device_update_status"
  "route_parameters" => [
    "_route" => "api_device_update_status"
    "_controller" => "Valt\CamBundle\Controller\WowzaApiController::updateDeviceStatusAction"
  ]
  "request_uri" => "https://dev.valt.forasoft.com/wowza/api/updateDeviceStatus"
  "method" => "POST"
]

[
  "params" => [
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "host" => "valt_dev_mariadb"
    "port" => 3306
    "dbname" => "valt"
    "user" => "root"
    "password" => "<redacted>"
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "serverVersion" => "11.8.2-MariaDB"
    "defaultTableOptions" => [
      "collate" => "utf8mb4_unicode_ci"
    ]
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.provider_type, t0.name AS name_2, t0.aws_access_key_id AS aws_access_key_id_3, t0.aws_secret_key AS aws_secret_key_4, t0.aws_s3_bucket_name AS aws_s3_bucket_name_5, t0.aws_region AS aws_region_6, t0.host_wowza_id AS host_wowza_id_7 FROM transcription_service t0 WHERE t0.id = ? AND t0.provider_type IN ('aws', 'local')"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "firewall_name" => "wowza_api"
  "authenticators" => 1
]

[
  "firewall_name" => "wowza_api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "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"
]

[
  "sql" => "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')"
]

[
  "sql" => "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"
  "params" => [
    1 => "dev-wowza.valt.forasoft.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1827
      +name: "STRING"
    }
  ]
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#1828
    -user: Valt\CamBundle\Entity\Wowza {#472 …}
    -roleNames: []
    -attributes: []
    -firewallName: "wowza_api"
  }
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator"
]

[
  "sql" => "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')"
  "params" => [
    1 => "1469"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1469
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1469
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 WHERE t0.id = ?"
  "params" => [
    1 => 548
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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')"
  "params" => [
    1 => "1e907cee-33a1-4adb-a2f6-dc6def4b8d2a"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1827
      +name: "STRING"
    }
  ]
]

[
  "sql" => "UPDATE device SET status = ? WHERE id = ?"
  "params" => [
    1 => "online"
    2 => 1469
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1827
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_time_format AS date_time_format_2, t0.time_format AS time_format_3, t0.comment_overlay_font_size AS comment_overlay_font_size_4, t0.streaming_method AS streaming_method_5, t0.smtp_server_address AS smtp_server_address_6, t0.smtp_server_port AS smtp_server_port_7, t0.email_encryption AS email_encryption_8, t0.email_username AS email_username_9, t0.email_password AS email_password_10, t0.email_from_name AS email_from_name_11, t0.email_bcc_email AS email_bcc_email_12, t0.email_from_address AS email_from_address_13, t0.login_page_logo AS login_page_logo_14, t0.camera_alert_delay_seconds AS camera_alert_delay_seconds_15, t0.notifications_enabled AS notifications_enabled_16, t0.alerts_enabled AS alerts_enabled_17, t0.schedule_enabled AS schedule_enabled_18, t0.info_template_id AS info_template_id_19 FROM global_settings t0 LIMIT 1"
]

[
  "sql" => "UPDATE device SET pending_alert_token = ? WHERE id = ?"
  "params" => [
    1 => "2e0be5d7-ec7a-468e-b359-d00d841b79d9"
    2 => 1469
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1827
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#218
      +name: "INTEGER"
    }
  ]
]

[
  "class" => "Valt\CamBundle\Message\EvaluateDelayedCameraAlert"
  "alias" => "async"
  "sender" => "Symfony\Component\Messenger\Bridge\Amqp\Transport\AmqpTransport"
]

[
  "class" => "Valt\CamBundle\Message\Websocket\DeviceStatusChanged"
  "alias" => "event_for_websocket"
  "sender" => "Symfony\Component\Messenger\Bridge\Amqp\Transport\AmqpTransport"
]

[
  "type" => "Valt\CamBundle\Message\Websocket\DeviceStatusChanged"
  "payload" => [
    "channel" => "recording:status"
    "message" => [
      "action" => "deviceStatusChanged"
      "cameraId" => 1469
      "roomsIds" => [
        548
      ]
      "isOnline" => true
      "isStreamable" => true
      "hasAudio" => false
    ]
  ]
]

[
  "sql" => "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"
]