Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177448 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:public_status.states');

DELETE FROM
  cache_items
WHERE
  item_lifetime + item_time <= ?
  AND item_id IN (?)

DELETE FROM cache_items WHERE item_lifetime + item_time <= 1794177448 AND item_id IN ('d-g2z6bTPX:public_status.states');

SELECT
  s0_.kind AS kind_0,
  s0_.name AS name_1,
  s0_.endpoint AS endpoint_2,
  s0_.credential AS credential_3,
  s0_.status AS status_4,
  s0_.public_host AS public_host_5,
  s0_.roles AS roles_6,
  s0_.last_seen_at AS last_seen_at_7,
  s0_.capacity AS capacity_8,
  s0_.labels AS labels_9,
  s0_.ingress_installed_at AS ingress_installed_at_10,
  s0_.ingress_error AS ingress_error_11,
  s0_.ingress_network AS ingress_network_12,
  s0_.ingress_verified_at AS ingress_verified_at_13,
  s0_.ingress_verification_error AS ingress_verification_error_14,
  s0_.id AS id_15,
  s0_.deleted_at AS deleted_at_16,
  s0_.created_at AS created_at_17,
  s0_.updated_at AS updated_at_18,
  CASE WHEN s0_.owner_id IS NULL THEN
    0
  ELSE
    1
  END AS sclr_19,
  s0_.owner_id AS owner_id_20
FROM
  swarm s0_
WHERE
  (s0_.status = ?)
  AND (s0_.deleted_at IS NULL)
ORDER BY
  sclr_19 ASC,
  s0_.name ASC

SELECT s0_.kind AS kind_0, s0_.name AS name_1, s0_.endpoint AS endpoint_2, s0_.credential AS credential_3, s0_.status AS status_4, s0_.public_host AS public_host_5, s0_.roles AS roles_6, s0_.last_seen_at AS last_seen_at_7, s0_.capacity AS capacity_8, s0_.labels AS labels_9, s0_.ingress_installed_at AS ingress_installed_at_10, s0_.ingress_error AS ingress_error_11, s0_.ingress_network AS ingress_network_12, s0_.ingress_verified_at AS ingress_verified_at_13, s0_.ingress_verification_error AS ingress_verification_error_14, s0_.id AS id_15, s0_.deleted_at AS deleted_at_16, s0_.created_at AS created_at_17, s0_.updated_at AS updated_at_18, CASE WHEN s0_.owner_id IS NULL THEN 0 ELSE 1 END AS sclr_19, s0_.owner_id AS owner_id_20 FROM swarm s0_ WHERE (s0_.status = 'reachable') AND (s0_.deleted_at IS NULL) ORDER BY sclr_19 ASC, s0_.name ASC;

SELECT
  COUNT(*) AS queued,
  MIN(available_at) AS oldest
FROM
  "messenger_messages"
WHERE
  queue_name = ?
  AND delivered_at IS NULL

SELECT COUNT(*) AS queued, MIN(available_at) AS oldest FROM "messenger_messages" WHERE queue_name = 'default' AND delivered_at IS NULL;

SELECT
  1

SELECT 1;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  f0_.created_at AS created_at_0,
  f0_.phase AS phase_1,
  f0_.reason AS reason_2
FROM
  failure f0_
WHERE
  f0_.triaged_at IS NULL
ORDER BY
  f0_.created_at ASC,
  f0_.id ASC
LIMIT
  100

SELECT f0_.created_at AS created_at_0, f0_.phase AS phase_1, f0_.reason AS reason_2 FROM failure f0_ WHERE f0_.triaged_at IS NULL ORDER BY f0_.created_at ASC, f0_.id ASC LIMIT 100;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:failure_sweep.heartbeat');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:oauth_check.github.d8160dbceeab1811c3b543ab28c3bc32');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:oauth_check.google.7c0ef0aa3aeddde1fdfa68a7b2a7ecab');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.home');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.login');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.register');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.pricing');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.dashboard');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794177450 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:key_page_probe.organization_show');

SELECT
  t0.name AS name_1,
  t0.kind AS kind_2,
  t0.major_version AS major_version_3,
  t0.image_ref AS image_ref_4,
  t0.overlay_network AS overlay_network_5,
  t0.credential_algo AS credential_algo_6,
  t0.credential_key_id AS credential_key_id_7,
  t0.credential_nonce AS credential_nonce_8,
  t0.credential_ciphertext AS credential_ciphertext_9,
  t0.state AS state_10,
  t0.failure_reason AS failure_reason_11,
  t0.capacity_bytes AS capacity_bytes_12,
  t0.observed_usage_bytes AS observed_usage_bytes_13,
  t0.observed_at AS observed_at_14,
  t0.in_flight_since AS in_flight_since_15,
  t0.id AS id_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.swarm_id AS swarm_id_19
FROM
  service_instance t0

SELECT t0.name AS name_1, t0.kind AS kind_2, t0.major_version AS major_version_3, t0.image_ref AS image_ref_4, t0.overlay_network AS overlay_network_5, t0.credential_algo AS credential_algo_6, t0.credential_key_id AS credential_key_id_7, t0.credential_nonce AS credential_nonce_8, t0.credential_ciphertext AS credential_ciphertext_9, t0.state AS state_10, t0.failure_reason AS failure_reason_11, t0.capacity_bytes AS capacity_bytes_12, t0.observed_usage_bytes AS observed_usage_bytes_13, t0.observed_at AS observed_at_14, t0.in_flight_since AS in_flight_since_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.swarm_id AS swarm_id_19 FROM service_instance t0;

SELECT
  t0.name AS name_1,
  t0.endpoint AS endpoint_2,
  t0.token_id AS token_id_3,
  t0.token_secret AS token_secret_4,
  t0.verify_tls AS verify_tls_5,
  t0.public_key_pin AS public_key_pin_6,
  t0.status AS status_7,
  t0.last_seen_at AS last_seen_at_8,
  t0.last_error AS last_error_9,
  t0.version AS version_10,
  t0.template_vmid AS template_vmid_11,
  t0.template_alpine_version AS template_alpine_version_12,
  t0.template_built_at AS template_built_at_13,
  t0.template_build_started_at AS template_build_started_at_14,
  t0.template_build_failures AS template_build_failures_15,
  t0.id AS id_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  proxmox_instance t0
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.endpoint AS endpoint_2, t0.token_id AS token_id_3, t0.token_secret AS token_secret_4, t0.verify_tls AS verify_tls_5, t0.public_key_pin AS public_key_pin_6, t0.status AS status_7, t0.last_seen_at AS last_seen_at_8, t0.last_error AS last_error_9, t0.version AS version_10, t0.template_vmid AS template_vmid_11, t0.template_alpine_version AS template_alpine_version_12, t0.template_built_at AS template_built_at_13, t0.template_build_started_at AS template_build_started_at_14, t0.template_build_failures AS template_build_failures_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM proxmox_instance t0 ORDER BY t0.name ASC;

SELECT
  t0.kind AS kind_1,
  t0.name AS name_2,
  t0.endpoint AS endpoint_3,
  t0.credential AS credential_4,
  t0.status AS status_5,
  t0.public_host AS public_host_6,
  t0.roles AS roles_7,
  t0.last_seen_at AS last_seen_at_8,
  t0.capacity AS capacity_9,
  t0.labels AS labels_10,
  t0.ingress_installed_at AS ingress_installed_at_11,
  t0.ingress_error AS ingress_error_12,
  t0.ingress_network AS ingress_network_13,
  t0.ingress_verified_at AS ingress_verified_at_14,
  t0.ingress_verification_error AS ingress_verification_error_15,
  t0.id AS id_16,
  t0.deleted_at AS deleted_at_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.owner_id AS owner_id_20
FROM
  swarm t0
WHERE
  t0.owner_id IS NULL
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.kind AS kind_1, t0.name AS name_2, t0.endpoint AS endpoint_3, t0.credential AS credential_4, t0.status AS status_5, t0.public_host AS public_host_6, t0.roles AS roles_7, t0.last_seen_at AS last_seen_at_8, t0.capacity AS capacity_9, t0.labels AS labels_10, t0.ingress_installed_at AS ingress_installed_at_11, t0.ingress_error AS ingress_error_12, t0.ingress_network AS ingress_network_13, t0.ingress_verified_at AS ingress_verified_at_14, t0.ingress_verification_error AS ingress_verification_error_15, t0.id AS id_16, t0.deleted_at AS deleted_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.owner_id AS owner_id_20 FROM swarm t0 WHERE t0.owner_id IS NULL AND ((t0.deleted_at IS NULL));

SELECT
  s0_.signature_date AS signature_date_0,
  s0_.error_reason AS error_reason_1,
  s0_.id AS id_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4
FROM
  signature_refresh s0_
WHERE
  s0_.error_reason IS NULL
ORDER BY
  s0_.signature_date DESC
LIMIT
  1

SELECT s0_.signature_date AS signature_date_0, s0_.error_reason AS error_reason_1, s0_.id AS id_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM signature_refresh s0_ WHERE s0_.error_reason IS NULL ORDER BY s0_.signature_date DESC LIMIT 1;

SELECT
  COUNT(*) AS stranded,
  MIN(
    COALESCE(updated_at, created_at)
  ) AS oldest
FROM
  "deployment"
WHERE
  status IN (?, ?, ?)
  AND deleted_at IS NULL

SELECT COUNT(*) AS stranded, MIN(COALESCE(updated_at, created_at)) AS oldest FROM "deployment" WHERE status IN ('pending', 'building', 'deploying') AND deleted_at IS NULL;

SELECT
  s0_.name AS name_0,
  s0_.kind AS kind_1,
  s0_.major_version AS major_version_2,
  s0_.image_ref AS image_ref_3,
  s0_.overlay_network AS overlay_network_4,
  s0_.credential_algo AS credential_algo_5,
  s0_.credential_key_id AS credential_key_id_6,
  s0_.credential_nonce AS credential_nonce_7,
  s0_.credential_ciphertext AS credential_ciphertext_8,
  s0_.state AS state_9,
  s0_.failure_reason AS failure_reason_10,
  s0_.capacity_bytes AS capacity_bytes_11,
  s0_.observed_usage_bytes AS observed_usage_bytes_12,
  s0_.observed_at AS observed_at_13,
  s0_.in_flight_since AS in_flight_since_14,
  s0_.id AS id_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.swarm_id AS swarm_id_18
FROM
  service_instance s0_
WHERE
  s0_.state = ?
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.kind AS kind_1, s0_.major_version AS major_version_2, s0_.image_ref AS image_ref_3, s0_.overlay_network AS overlay_network_4, s0_.credential_algo AS credential_algo_5, s0_.credential_key_id AS credential_key_id_6, s0_.credential_nonce AS credential_nonce_7, s0_.credential_ciphertext AS credential_ciphertext_8, s0_.state AS state_9, s0_.failure_reason AS failure_reason_10, s0_.capacity_bytes AS capacity_bytes_11, s0_.observed_usage_bytes AS observed_usage_bytes_12, s0_.observed_at AS observed_at_13, s0_.in_flight_since AS in_flight_since_14, s0_.id AS id_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.swarm_id AS swarm_id_18 FROM service_instance s0_ WHERE s0_.state = 'serving' ORDER BY s0_.name ASC;

SELECT
  d0_.sequence AS sequence_0,
  d0_.name AS name_1,
  d0_.raw_compose AS raw_compose_2,
  d0_.canonical_spec AS canonical_spec_3,
  d0_.build_contexts AS build_contexts_4,
  d0_.forwarded_images AS forwarded_images_5,
  d0_.build_secrets AS build_secrets_6,
  d0_.mount_secrets AS mount_secrets_7,
  d0_.partial AS partial_8,
  d0_.status AS status_9,
  d0_.status_reason AS status_reason_10,
  d0_.failed_on_swarm AS failed_on_swarm_11,
  d0_.zero_task_observed_at AS zero_task_observed_at_12,
  d0_.degraded AS degraded_13,
  d0_.digest AS digest_14,
  d0_.id AS id_15,
  d0_.deleted_at AS deleted_at_16,
  d0_.created_at AS created_at_17,
  d0_.updated_at AS updated_at_18,
  a1_.slug AS slug_19,
  a1_.name AS name_20,
  a1_.isolation_level AS isolation_level_21,
  a1_.service_adoption AS service_adoption_22,
  a1_.access_gate AS access_gate_23,
  a1_.first_running_at AS first_running_at_24,
  a1_.primary_deployment_name AS primary_deployment_name_25,
  a1_.legacy_stack_base AS legacy_stack_base_26,
  a1_.icon_key AS icon_key_27,
  a1_.icon_source AS icon_source_28,
  a1_.build_bucket AS build_bucket_29,
  a1_.build_key_id AS build_key_id_30,
  a1_.build_credential_algo AS build_credential_algo_31,
  a1_.build_credential_key_id AS build_credential_key_id_32,
  a1_.build_credential_nonce AS build_credential_nonce_33,
  a1_.build_credential_ciphertext AS build_credential_ciphertext_34,
  a1_.access_gate_credential_algo AS access_gate_credential_algo_35,
  a1_.access_gate_credential_key_id AS access_gate_credential_key_id_36,
  a1_.access_gate_credential_nonce AS access_gate_credential_nonce_37,
  a1_.access_gate_credential_ciphertext AS access_gate_credential_ciphertext_38,
  a1_.pool_domain AS pool_domain_39,
  a1_.pool_label AS pool_label_40,
  a1_.pool_short_name AS pool_short_name_41,
  a1_.pool_short_name_deployment AS pool_short_name_deployment_42,
  a1_.pool_short_name_service AS pool_short_name_service_43,
  a1_.health_alerts AS health_alerts_44,
  a1_.id AS id_45,
  a1_.deleted_at AS deleted_at_46,
  a1_.created_at AS created_at_47,
  a1_.updated_at AS updated_at_48,
  o2_.name AS name_49,
  o2_.slug AS slug_50,
  o2_.theme AS theme_51,
  o2_.tier_pin AS tier_pin_52,
  o2_.tier_pinned_at AS tier_pinned_at_53,
  o2_.tier_pin_reason AS tier_pin_reason_54,
  o2_.low_balance_warned_at AS low_balance_warned_at_55,
  o2_.negative_balance_allowed AS negative_balance_allowed_56,
  o2_.applications_discover_each_other AS applications_discover_each_other_57,
  o2_.two_factor_required_at AS two_factor_required_at_58,
  o2_.api_access_log_retention_days AS api_access_log_retention_days_59,
  o2_.id AS id_60,
  o2_.deleted_at AS deleted_at_61,
  o2_.created_at AS created_at_62,
  o2_.updated_at AS updated_at_63,
  s3_.name AS name_64,
  s3_.image AS image_65,
  s3_.replicas AS replicas_66,
  s3_.cpu_limit AS cpu_limit_67,
  s3_.mem_limit AS mem_limit_68,
  s3_.cpu_reservation AS cpu_reservation_69,
  s3_.mem_reservation AS mem_reservation_70,
  s3_.ports AS ports_71,
  s3_.http_port AS http_port_72,
  s3_.command AS command_73,
  s3_.entrypoint AS entrypoint_74,
  s3_.healthcheck AS healthcheck_75,
  s3_.restart AS restart_76,
  s3_.forwarded_unscanned AS forwarded_unscanned_77,
  s3_.id AS id_78,
  s3_.created_at AS created_at_79,
  s3_.updated_at AS updated_at_80,
  s4_.kind AS kind_81,
  s4_.name AS name_82,
  s4_.endpoint AS endpoint_83,
  s4_.credential AS credential_84,
  s4_.status AS status_85,
  s4_.public_host AS public_host_86,
  s4_.roles AS roles_87,
  s4_.last_seen_at AS last_seen_at_88,
  s4_.capacity AS capacity_89,
  s4_.labels AS labels_90,
  s4_.ingress_installed_at AS ingress_installed_at_91,
  s4_.ingress_error AS ingress_error_92,
  s4_.ingress_network AS ingress_network_93,
  s4_.ingress_verified_at AS ingress_verified_at_94,
  s4_.ingress_verification_error AS ingress_verification_error_95,
  s4_.id AS id_96,
  s4_.deleted_at AS deleted_at_97,
  s4_.created_at AS created_at_98,
  s4_.updated_at AS updated_at_99,
  d0_.application_id AS application_id_100,
  d0_.target_swarm_id AS target_swarm_id_101,
  d0_.created_by_id AS created_by_id_102,
  a1_.organization_id AS organization_id_103,
  a1_.current_deployment_id AS current_deployment_id_104,
  o2_.machine_account_id AS machine_account_id_105,
  o2_.tier_pinned_by_id AS tier_pinned_by_id_106,
  s3_.deployment_id AS deployment_id_107,
  s4_.owner_id AS owner_id_108
FROM
  deployment d0_
  INNER JOIN application a1_ ON d0_.application_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  INNER JOIN organization o2_ ON a1_.organization_id = o2_.id
  AND (o2_.deleted_at IS NULL)
  INNER JOIN service s3_ ON d0_.id = s3_.deployment_id
  LEFT JOIN swarm s4_ ON d0_.target_swarm_id = s4_.id
  AND (s4_.deleted_at IS NULL)
WHERE
  (d0_.status = ?)
  AND (d0_.deleted_at IS NULL)