Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.base_url AS base_url_3,
  t0.instance_id AS instance_id_4,
  t0.instance_secret AS instance_secret_5,
  t0.active AS active_6,
  t0.cms_version AS cms_version_7,
  t0.cms_update_notified_version AS cms_update_notified_version_8,
  t0.contao_update_asana_subtask_gid AS contao_update_asana_subtask_gid_9,
  t0.contao_update_asana_target_version AS contao_update_asana_target_version_10,
  t0.php_version AS php_version_11,
  t0.security_advisory_checked_at AS security_advisory_checked_at_12,
  t0.created_at AS created_at_13,
  t0.is_local AS is_local_14,
  t0.environment AS environment_15,
  t0.favicon_path AS favicon_path_16,
  t0.favicon_content_type AS favicon_content_type_17,
  t0.sso_ready AS sso_ready_18,
  t0.gate_enabled AS gate_enabled_19,
  t0.gate_password_hash AS gate_password_hash_20,
  t0.gate_synced_at AS gate_synced_at_21,
  t0.health_checked_at AS health_checked_at_22,
  t0.health_response_time_ms AS health_response_time_ms_23,
  t0.health_status_code AS health_status_code_24,
  t0.health_error AS health_error_25,
  t0.notes AS notes_26,
  t0.type AS type_27,
  t28.id AS id_29,
  t28.manager_url AS manager_url_30,
  t28.api_token AS api_token_31,
  t28.scopes AS scopes_32,
  t28.connected_at AS connected_at_33,
  t28.instance_id AS instance_id_34,
  t0.owner_id AS owner_id_35,
  t0.workspace_id AS workspace_id_36,
  t0.project_id AS project_id_37,
  t0.hoster_id AS hoster_id_38
FROM
  instance t0
  LEFT JOIN contao_manager_connection t28 ON t28.instance_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.base_url AS base_url_3, t0.instance_id AS instance_id_4, t0.instance_secret AS instance_secret_5, t0.active AS active_6, t0.cms_version AS cms_version_7, t0.cms_update_notified_version AS cms_update_notified_version_8, t0.contao_update_asana_subtask_gid AS contao_update_asana_subtask_gid_9, t0.contao_update_asana_target_version AS contao_update_asana_target_version_10, t0.php_version AS php_version_11, t0.security_advisory_checked_at AS security_advisory_checked_at_12, t0.created_at AS created_at_13, t0.is_local AS is_local_14, t0.environment AS environment_15, t0.favicon_path AS favicon_path_16, t0.favicon_content_type AS favicon_content_type_17, t0.sso_ready AS sso_ready_18, t0.gate_enabled AS gate_enabled_19, t0.gate_password_hash AS gate_password_hash_20, t0.gate_synced_at AS gate_synced_at_21, t0.health_checked_at AS health_checked_at_22, t0.health_response_time_ms AS health_response_time_ms_23, t0.health_status_code AS health_status_code_24, t0.health_error AS health_error_25, t0.notes AS notes_26, t0.type AS type_27, t28.id AS id_29, t28.manager_url AS manager_url_30, t28.api_token AS api_token_31, t28.scopes AS scopes_32, t28.connected_at AS connected_at_33, t28.instance_id AS instance_id_34, t0.owner_id AS owner_id_35, t0.workspace_id AS workspace_id_36, t0.project_id AS project_id_37, t0.hoster_id AS hoster_id_38 FROM instance t0 LEFT JOIN contao_manager_connection t28 ON t28.instance_id = t0.id WHERE t0.id = 34;

SELECT
  i0_.id AS id_0,
  i0_.checked_at AS checked_at_1,
  i0_.ok AS ok_2,
  i0_.status_code AS status_code_3,
  i0_.response_time_ms AS response_time_ms_4,
  i0_.error AS error_5,
  i0_.sso_ready AS sso_ready_6,
  i0_.cms_version AS cms_version_7,
  i0_.php_version AS php_version_8,
  i0_.instance_id AS instance_id_9
FROM
  instance_health_check i0_
WHERE
  i0_.instance_id = ?
ORDER BY
  i0_.checked_at DESC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.checked_at AS checked_at_1, i0_.ok AS ok_2, i0_.status_code AS status_code_3, i0_.response_time_ms AS response_time_ms_4, i0_.error AS error_5, i0_.sso_ready AS sso_ready_6, i0_.cms_version AS cms_version_7, i0_.php_version AS php_version_8, i0_.instance_id AS instance_id_9 FROM instance_health_check i0_ WHERE i0_.instance_id = 34 ORDER BY i0_.checked_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.checked_at AS checked_at_2,
  t0.ok AS ok_3,
  t0.status_code AS status_code_4,
  t0.response_time_ms AS response_time_ms_5,
  t0.error AS error_6,
  t0.sso_ready AS sso_ready_7,
  t0.cms_version AS cms_version_8,
  t0.php_version AS php_version_9,
  t0.instance_id AS instance_id_10
FROM
  instance_health_check t0
WHERE
  t0.instance_id = ?

SELECT t0.id AS id_1, t0.checked_at AS checked_at_2, t0.ok AS ok_3, t0.status_code AS status_code_4, t0.response_time_ms AS response_time_ms_5, t0.error AS error_6, t0.sso_ready AS sso_ready_7, t0.cms_version AS cms_version_8, t0.php_version AS php_version_9, t0.instance_id AS instance_id_10 FROM instance_health_check t0 WHERE t0.instance_id = 34;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO instance_health_check (
  checked_at, ok, status_code, response_time_ms,
  error, sso_ready, cms_version, php_version,
  instance_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO instance_health_check (checked_at, ok, status_code, response_time_ms, error, sso_ready, cms_version, php_version, instance_id) VALUES ('2026-07-17 15:15:19', 1, 200, 224, NULL, 0, NULL, NULL, 34);

UPDATE
  instance
SET
  health_checked_at = ?,
  health_response_time_ms = ?
WHERE
  id = ?

UPDATE instance SET health_checked_at = '2026-07-17 15:15:19', health_response_time_ms = 224 WHERE id = 34;

"COMMIT"

"COMMIT";