39.53 ms (2.60%)
1
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 )
Parameters :
[
"running "
]
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 )
Copy
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 = 'running' ) AND (d0_ . deleted_at IS NULL );
Copy