Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.display_name AS display_name_1,
  c0_.legal_name AS legal_name_2,
  c0_.tagline AS tagline_3,
  c0_.logo_path AS logo_path_4,
  c0_.logo_light_path AS logo_light_path_5,
  c0_.favicon_path AS favicon_path_6,
  c0_.primary_color AS primary_color_7,
  c0_.accent_color AS accent_color_8,
  c0_.dark_sidebar AS dark_sidebar_9,
  c0_.template AS template_10,
  c0_.powered_by AS powered_by_11,
  c0_.email_from_name AS email_from_name_12,
  c0_.email_from_address AS email_from_address_13,
  c0_.email_reply_to AS email_reply_to_14,
  c0_.commercial_from_name AS commercial_from_name_15,
  c0_.commercial_from_address AS commercial_from_address_16,
  c0_.finance_from_name AS finance_from_name_17,
  c0_.finance_from_address AS finance_from_address_18,
  c0_.portal_from_name AS portal_from_name_19,
  c0_.portal_from_address AS portal_from_address_20,
  c0_.portal_reply_to AS portal_reply_to_21,
  c0_.portal_domain AS portal_domain_22,
  c0_.portal_domain_status AS portal_domain_status_23,
  c0_.portal_domain_status_message AS portal_domain_status_message_24,
  c0_.portal_domain_verified_at AS portal_domain_verified_at_25,
  c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26,
  c0_.portal_notification_emails AS portal_notification_emails_27,
  c0_.email_footer_html AS email_footer_html_28,
  c0_.bank_accounts AS bank_accounts_29,
  c0_.email_transport AS email_transport_30,
  c0_.email_transport_config AS email_transport_config_31,
  c0_.login_background_path AS login_background_path_32,
  c0_.login_page_message AS login_page_message_33,
  c0_.custom_css AS custom_css_34,
  c0_.locale_default AS locale_default_35,
  c0_.timezone_default AS timezone_default_36,
  c0_.compliance_request_default_basis AS compliance_request_default_basis_37,
  c0_.notes AS notes_38,
  c0_.created_at AS created_at_39,
  c0_.updated_at AS updated_at_40,
  c0_.tenant_id AS tenant_id_41
FROM
  cp_branding c0_
  INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id
WHERE
  c1_.slug = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.display_name AS display_name_1, c0_.legal_name AS legal_name_2, c0_.tagline AS tagline_3, c0_.logo_path AS logo_path_4, c0_.logo_light_path AS logo_light_path_5, c0_.favicon_path AS favicon_path_6, c0_.primary_color AS primary_color_7, c0_.accent_color AS accent_color_8, c0_.dark_sidebar AS dark_sidebar_9, c0_.template AS template_10, c0_.powered_by AS powered_by_11, c0_.email_from_name AS email_from_name_12, c0_.email_from_address AS email_from_address_13, c0_.email_reply_to AS email_reply_to_14, c0_.commercial_from_name AS commercial_from_name_15, c0_.commercial_from_address AS commercial_from_address_16, c0_.finance_from_name AS finance_from_name_17, c0_.finance_from_address AS finance_from_address_18, c0_.portal_from_name AS portal_from_name_19, c0_.portal_from_address AS portal_from_address_20, c0_.portal_reply_to AS portal_reply_to_21, c0_.portal_domain AS portal_domain_22, c0_.portal_domain_status AS portal_domain_status_23, c0_.portal_domain_status_message AS portal_domain_status_message_24, c0_.portal_domain_verified_at AS portal_domain_verified_at_25, c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26, c0_.portal_notification_emails AS portal_notification_emails_27, c0_.email_footer_html AS email_footer_html_28, c0_.bank_accounts AS bank_accounts_29, c0_.email_transport AS email_transport_30, c0_.email_transport_config AS email_transport_config_31, c0_.login_background_path AS login_background_path_32, c0_.login_page_message AS login_page_message_33, c0_.custom_css AS custom_css_34, c0_.locale_default AS locale_default_35, c0_.timezone_default AS timezone_default_36, c0_.compliance_request_default_basis AS compliance_request_default_basis_37, c0_.notes AS notes_38, c0_.created_at AS created_at_39, c0_.updated_at AS updated_at_40, c0_.tenant_id AS tenant_id_41 FROM cp_branding c0_ INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id WHERE c1_.slug = 'local' LIMIT 1;

SELECT
  enabled
FROM
  tenant_module_state
WHERE
  tenant_slug = ?
  AND module_key = ?
LIMIT
  1

SELECT enabled FROM tenant_module_state WHERE tenant_slug = 'local' AND module_key = 'capability.oauth-login' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email_address AS email_address_5,
  t0.user_name AS user_name_6,
  t0.is_verified AS is_verified_7,
  t0.google_id AS google_id_8,
  t0.google_access_token AS google_access_token_9,
  t0.azure_id AS azure_id_10,
  t0.azure_access_token AS azure_access_token_11,
  t0.is_on_premise AS is_on_premise_12,
  t0.preferred_theme AS preferred_theme_13,
  t0.preferred_locale AS preferred_locale_14,
  t0.api_key AS api_key_15,
  t0.api_key_generated_at AS api_key_generated_at_16,
  t0.is_customer_user AS is_customer_user_17,
  t0.last_login_at AS last_login_at_18,
  t0.email_signature AS email_signature_19,
  t0.is_commercial AS is_commercial_20,
  t0.is_awb_signer AS is_awb_signer_21,
  t0.is_operator AS is_operator_22,
  t0.profile_image_path AS profile_image_path_23,
  t0.job_title AS job_title_24,
  t0.ui_preferences AS ui_preferences_25,
  t0.privacy_consented_at AS privacy_consented_at_26,
  t0.phone AS phone_27,
  t0.mobile_phone AS mobile_phone_28,
  t0.website AS website_29,
  t0.totp_secret AS totp_secret_30,
  t0.is_two_factor_enabled AS is_two_factor_enabled_31,
  t0.allowed_ip_ranges AS allowed_ip_ranges_32,
  t0.is_active AS is_active_33,
  t0.department_id AS department_id_34,
  t0.current_department_id AS current_department_id_35,
  t0.customer_organization_id AS customer_organization_id_36
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.roles AS roles_3, t0.password AS password_4, t0.email_address AS email_address_5, t0.user_name AS user_name_6, t0.is_verified AS is_verified_7, t0.google_id AS google_id_8, t0.google_access_token AS google_access_token_9, t0.azure_id AS azure_id_10, t0.azure_access_token AS azure_access_token_11, t0.is_on_premise AS is_on_premise_12, t0.preferred_theme AS preferred_theme_13, t0.preferred_locale AS preferred_locale_14, t0.api_key AS api_key_15, t0.api_key_generated_at AS api_key_generated_at_16, t0.is_customer_user AS is_customer_user_17, t0.last_login_at AS last_login_at_18, t0.email_signature AS email_signature_19, t0.is_commercial AS is_commercial_20, t0.is_awb_signer AS is_awb_signer_21, t0.is_operator AS is_operator_22, t0.profile_image_path AS profile_image_path_23, t0.job_title AS job_title_24, t0.ui_preferences AS ui_preferences_25, t0.privacy_consented_at AS privacy_consented_at_26, t0.phone AS phone_27, t0.mobile_phone AS mobile_phone_28, t0.website AS website_29, t0.totp_secret AS totp_secret_30, t0.is_two_factor_enabled AS is_two_factor_enabled_31, t0.allowed_ip_ranges AS allowed_ip_ranges_32, t0.is_active AS is_active_33, t0.department_id AS department_id_34, t0.current_department_id AS current_department_id_35, t0.customer_organization_id AS customer_organization_id_36 FROM user t0 WHERE t0.id = 90;

SELECT
  t0.id AS id_1,
  t0.graph_message_id AS graph_message_id_2,
  t0.sender_email AS sender_email_3,
  t0.sender_name AS sender_name_4,
  t0.email_subject AS email_subject_5,
  t0.email_body_snippet AS email_body_snippet_6,
  t0.source_file_path AS source_file_path_7,
  t0.original_filename AS original_filename_8,
  t0.file_type AS file_type_9,
  t0.content_sha256 AS content_sha256_10,
  t0.ingest_dedup_key AS ingest_dedup_key_11,
  t0.processed_file_path AS processed_file_path_12,
  t0.status AS status_13,
  t0.parsed_data AS parsed_data_14,
  t0.match_results AS match_results_15,
  t0.field_locations AS field_locations_16,
  t0.audit_log AS audit_log_17,
  t0.match_report AS match_report_18,
  t0.classification AS classification_19,
  t0.forced_ours AS forced_ours_20,
  t0.batch_key AS batch_key_21,
  t0.document_key AS document_key_22,
  t0.document_kind AS document_kind_23,
  t0.last_auto_match_attempt_at AS last_auto_match_attempt_at_24,
  t0.overall_confidence AS overall_confidence_25,
  t0.reviewed_at AS reviewed_at_26,
  t0.version AS version_27,
  t0.error_message AS error_message_28,
  t0.received_at AS received_at_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.mailbox_id AS mailbox_id_32,
  t0.parent_item_id AS parent_item_id_33,
  t0.consolidated_into_id AS consolidated_into_id_34,
  t0.supplier_invoice_id AS supplier_invoice_id_35,
  t0.supplier_id AS supplier_id_36,
  t0.job_id AS job_id_37,
  t0.reviewed_by_id AS reviewed_by_id_38
FROM
  cp_invoice_ingestion_items t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.graph_message_id AS graph_message_id_2, t0.sender_email AS sender_email_3, t0.sender_name AS sender_name_4, t0.email_subject AS email_subject_5, t0.email_body_snippet AS email_body_snippet_6, t0.source_file_path AS source_file_path_7, t0.original_filename AS original_filename_8, t0.file_type AS file_type_9, t0.content_sha256 AS content_sha256_10, t0.ingest_dedup_key AS ingest_dedup_key_11, t0.processed_file_path AS processed_file_path_12, t0.status AS status_13, t0.parsed_data AS parsed_data_14, t0.match_results AS match_results_15, t0.field_locations AS field_locations_16, t0.audit_log AS audit_log_17, t0.match_report AS match_report_18, t0.classification AS classification_19, t0.forced_ours AS forced_ours_20, t0.batch_key AS batch_key_21, t0.document_key AS document_key_22, t0.document_kind AS document_kind_23, t0.last_auto_match_attempt_at AS last_auto_match_attempt_at_24, t0.overall_confidence AS overall_confidence_25, t0.reviewed_at AS reviewed_at_26, t0.version AS version_27, t0.error_message AS error_message_28, t0.received_at AS received_at_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.mailbox_id AS mailbox_id_32, t0.parent_item_id AS parent_item_id_33, t0.consolidated_into_id AS consolidated_into_id_34, t0.supplier_invoice_id AS supplier_invoice_id_35, t0.supplier_id AS supplier_id_36, t0.job_id AS job_id_37, t0.reviewed_by_id AS reviewed_by_id_38 FROM cp_invoice_ingestion_items t0 WHERE t0.id = 889;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legacy_org_id AS legacy_org_id_3,
  t0.legal_name AS legal_name_4,
  t0.tax_identifier AS tax_identifier_5,
  t0.tax_id_type AS tax_id_type_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.kind AS kind_10,
  t0.is_on_premise AS is_on_premise_11,
  t0.is_individual AS is_individual_12,
  t0.is_own_house AS is_own_house_13,
  t0.active AS active_14,
  t0.created_by_ai_flow AS created_by_ai_flow_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.credit_limit AS credit_limit_18,
  t0.credit_limit_currency AS credit_limit_currency_19,
  t0.vat_exempt AS vat_exempt_20,
  t0.default_currency AS default_currency_21,
  t0.iata_code AS iata_code_22,
  t0.cass_address AS cass_address_23,
  t0.fiata_number AS fiata_number_24,
  t0.scac_code AS scac_code_25,
  t0.eori_number AS eori_number_26,
  t0.notes AS notes_27,
  t0.last_contacted_at AS last_contacted_at_28,
  t0.crm_notes AS crm_notes_29,
  t0.customer_origin AS customer_origin_30,
  t0.iban AS iban_31,
  t0.swift AS swift_32,
  t0.erp_pre_check_at AS erp_pre_check_at_33,
  t0.erp_pre_check_passed AS erp_pre_check_passed_34,
  t0.statement_email AS statement_email_35,
  t0.statement_locale AS statement_locale_36,
  t0.statement_auto_send AS statement_auto_send_37,
  t0.statement_horizon_days AS statement_horizon_days_38,
  t0.services_air AS services_air_39,
  t0.services_sea AS services_sea_40,
  t0.services_road AS services_road_41,
  t0.services_rail AS services_rail_42,
  t0.services_export AS services_export_43,
  t0.services_import AS services_import_44,
  t0.services_customs_brokerage AS services_customs_brokerage_45,
  t0.services_warehouse AS services_warehouse_46,
  t0.transports_medicines AS transports_medicines_47,
  t0.moves_secured_air_cargo AS moves_secured_air_cargo_48,
  t0.is_aeo AS is_aeo_49,
  t0.is_insurer AS is_insurer_50,
  t0.auto_accept_provisionals AS auto_accept_provisionals_51,
  t0.auto_accept_variance_enabled AS auto_accept_variance_enabled_52,
  t0.auto_accept_variance_percent AS auto_accept_variance_percent_53,
  t0.auto_accept_variance_max_eur AS auto_accept_variance_max_eur_54,
  t0.stamp_duty_rate AS stamp_duty_rate_55,
  t0.aeo_certificate_number AS aeo_certificate_number_56,
  t0.aeo_authorization_type AS aeo_authorization_type_57,
  t0.aeo_expires_at AS aeo_expires_at_58,
  t0.airline_id AS airline_id_59,
  t0.sea_carrier_id AS sea_carrier_id_60,
  t0.erp_connection_id AS erp_connection_id_61,
  t0.crm_owner_id AS crm_owner_id_62,
  t0.payment_condition_id AS payment_condition_id_63,
  t0.compliance_contact_id AS compliance_contact_id_64,
  t0.security_contact_id AS security_contact_id_65
FROM
  organizations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.legacy_org_id AS legacy_org_id_3, t0.legal_name AS legal_name_4, t0.tax_identifier AS tax_identifier_5, t0.tax_id_type AS tax_id_type_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.kind AS kind_10, t0.is_on_premise AS is_on_premise_11, t0.is_individual AS is_individual_12, t0.is_own_house AS is_own_house_13, t0.active AS active_14, t0.created_by_ai_flow AS created_by_ai_flow_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.credit_limit AS credit_limit_18, t0.credit_limit_currency AS credit_limit_currency_19, t0.vat_exempt AS vat_exempt_20, t0.default_currency AS default_currency_21, t0.iata_code AS iata_code_22, t0.cass_address AS cass_address_23, t0.fiata_number AS fiata_number_24, t0.scac_code AS scac_code_25, t0.eori_number AS eori_number_26, t0.notes AS notes_27, t0.last_contacted_at AS last_contacted_at_28, t0.crm_notes AS crm_notes_29, t0.customer_origin AS customer_origin_30, t0.iban AS iban_31, t0.swift AS swift_32, t0.erp_pre_check_at AS erp_pre_check_at_33, t0.erp_pre_check_passed AS erp_pre_check_passed_34, t0.statement_email AS statement_email_35, t0.statement_locale AS statement_locale_36, t0.statement_auto_send AS statement_auto_send_37, t0.statement_horizon_days AS statement_horizon_days_38, t0.services_air AS services_air_39, t0.services_sea AS services_sea_40, t0.services_road AS services_road_41, t0.services_rail AS services_rail_42, t0.services_export AS services_export_43, t0.services_import AS services_import_44, t0.services_customs_brokerage AS services_customs_brokerage_45, t0.services_warehouse AS services_warehouse_46, t0.transports_medicines AS transports_medicines_47, t0.moves_secured_air_cargo AS moves_secured_air_cargo_48, t0.is_aeo AS is_aeo_49, t0.is_insurer AS is_insurer_50, t0.auto_accept_provisionals AS auto_accept_provisionals_51, t0.auto_accept_variance_enabled AS auto_accept_variance_enabled_52, t0.auto_accept_variance_percent AS auto_accept_variance_percent_53, t0.auto_accept_variance_max_eur AS auto_accept_variance_max_eur_54, t0.stamp_duty_rate AS stamp_duty_rate_55, t0.aeo_certificate_number AS aeo_certificate_number_56, t0.aeo_authorization_type AS aeo_authorization_type_57, t0.aeo_expires_at AS aeo_expires_at_58, t0.airline_id AS airline_id_59, t0.sea_carrier_id AS sea_carrier_id_60, t0.erp_connection_id AS erp_connection_id_61, t0.crm_owner_id AS crm_owner_id_62, t0.payment_condition_id AS payment_condition_id_63, t0.compliance_contact_id AS compliance_contact_id_64, t0.security_contact_id AS security_contact_id_65 FROM organizations t0 WHERE t0.id = 11707;

SELECT
  t0.id AS id_1,
  t0.job_number AS job_number_2,
  t0.status AS status_3,
  t0.milestone AS milestone_4,
  t0.direction AS direction_5,
  t0.transport_mode AS transport_mode_6,
  t0.profile AS profile_7,
  t0.sea_load_type AS sea_load_type_8,
  t0.service_type AS service_type_9,
  t0.courier_tracking_number AS courier_tracking_number_10,
  t0.is_master AS is_master_11,
  t0.is_house AS is_house_12,
  t0.erp_process_synced_at AS erp_process_synced_at_13,
  t0.invoice_mode AS invoice_mode_14,
  t0.include_non_invoiceable_in_freight_total AS include_non_invoiceable_in_freight_total_15,
  t0.pickup_date AS pickup_date_16,
  t0.pickup_time AS pickup_time_17,
  t0.pickup_reference AS pickup_reference_18,
  t0.pickup_contact_name AS pickup_contact_name_19,
  t0.pickup_contact_phone AS pickup_contact_phone_20,
  t0.pickup_instructions AS pickup_instructions_21,
  t0.pickup_observations AS pickup_observations_22,
  t0.delivery_date AS delivery_date_23,
  t0.delivery_time AS delivery_time_24,
  t0.delivery_reference AS delivery_reference_25,
  t0.delivery_contact_name AS delivery_contact_name_26,
  t0.delivery_contact_phone AS delivery_contact_phone_27,
  t0.delivery_instructions AS delivery_instructions_28,
  t0.delivery_observations AS delivery_observations_29,
  t0.pickup_address_override AS pickup_address_override_30,
  t0.delivery_address_override AS delivery_address_override_31,
  t0.pickup_depot_date AS pickup_depot_date_32,
  t0.pickup_depot_time AS pickup_depot_time_33,
  t0.pickup_depot_reference AS pickup_depot_reference_34,
  t0.pickup_depot_address_override AS pickup_depot_address_override_35,
  t0.delivery_depot_date AS delivery_depot_date_36,
  t0.delivery_depot_time AS delivery_depot_time_37,
  t0.delivery_depot_reference AS delivery_depot_reference_38,
  t0.delivery_depot_address_override AS delivery_depot_address_override_39,
  t0.cutoff_date AS cutoff_date_40,
  t0.cutoff_time AS cutoff_time_41,
  t0.si_cutoff_at AS si_cutoff_at_42,
  t0.port_terminal_address_override AS port_terminal_address_override_43,
  t0.port_terminal_date AS port_terminal_date_44,
  t0.port_terminal_time AS port_terminal_time_45,
  t0.port_terminal_reference AS port_terminal_reference_46,
  t0.mrn_number AS mrn_number_47,
  t0.customs_reference AS customs_reference_48,
  t0.customs_hs_codes AS customs_hs_codes_49,
  t0.customs_value AS customs_value_50,
  t0.customs_value_currency AS customs_value_currency_51,
  t0.customs_regime AS customs_regime_52,
  t0.customs_duty_amount AS customs_duty_amount_53,
  t0.departure_date AS departure_date_54,
  t0.arrival_date AS arrival_date_55,
  t0.goods_description AS goods_description_56,
  t0.cargo_category AS cargo_category_57,
  t0.has_insurance AS has_insurance_58,
  t0.insurance_number AS insurance_number_59,
  t0.insurance_coverage AS insurance_coverage_60,
  t0.compliance_override_reason AS compliance_override_reason_61,
  t0.compliance_override_at AS compliance_override_at_62,
  t0.cancelled_at AS cancelled_at_63,
  t0.cancellation_reason AS cancellation_reason_64,
  t0.created_at AS created_at_65,
  t0.updated_at AS updated_at_66,
  t0.version AS version_67,
  t0.arc_data AS arc_data_68,
  t0.currency AS currency_69,
  t0.commercial_value AS commercial_value_70,
  t0.is_dangerous AS is_dangerous_71,
  t0.special_instructions AS special_instructions_72,
  t0.operational_tags AS operational_tags_73,
  t0.ai_parse_snapshot AS ai_parse_snapshot_74,
  t0.ai_pre_edit_snapshot AS ai_pre_edit_snapshot_75,
  t0.ai_parsed_at AS ai_parsed_at_76,
  t0.ai_diffed_at AS ai_diffed_at_77,
  t0.ai_accuracy_sampled_at AS ai_accuracy_sampled_at_78,
  t0.pre_closed_at AS pre_closed_at_79,
  t0.closed_at AS closed_at_80,
  t0.closure_reason AS closure_reason_81,
  t0.shipper_manual_override AS shipper_manual_override_82,
  t0.shipper_override_name AS shipper_override_name_83,
  t0.shipper_override_legal_name AS shipper_override_legal_name_84,
  t0.shipper_override_tax_id AS shipper_override_tax_id_85,
  t0.shipper_override_address AS shipper_override_address_86,
  t0.shipper_override_city AS shipper_override_city_87,
  t0.shipper_override_state AS shipper_override_state_88,
  t0.shipper_override_postal_code AS shipper_override_postal_code_89,
  t0.shipper_override_country AS shipper_override_country_90,
  t0.shipper_override_phone AS shipper_override_phone_91,
  t0.shipper_override_email AS shipper_override_email_92,
  t0.shipper_override_contact_person AS shipper_override_contact_person_93,
  t0.consignee_manual_override AS consignee_manual_override_94,
  t0.consignee_override_name AS consignee_override_name_95,
  t0.consignee_override_legal_name AS consignee_override_legal_name_96,
  t0.consignee_override_tax_id AS consignee_override_tax_id_97,
  t0.consignee_override_address AS consignee_override_address_98,
  t0.consignee_override_city AS consignee_override_city_99,
  t0.consignee_override_state AS consignee_override_state_100,
  t0.consignee_override_postal_code AS consignee_override_postal_code_101,
  t0.consignee_override_country AS consignee_override_country_102,
  t0.consignee_override_phone AS consignee_override_phone_103,
  t0.consignee_override_email AS consignee_override_email_104,
  t0.consignee_override_contact_person AS consignee_override_contact_person_105,
  t0.notify_party_manual_override AS notify_party_manual_override_106,
  t0.notify_party_override_name AS notify_party_override_name_107,
  t0.notify_party_override_legal_name AS notify_party_override_legal_name_108,
  t0.notify_party_override_tax_id AS notify_party_override_tax_id_109,
  t0.notify_party_override_address AS notify_party_override_address_110,
  t0.notify_party_override_city AS notify_party_override_city_111,
  t0.notify_party_override_state AS notify_party_override_state_112,
  t0.notify_party_override_postal_code AS notify_party_override_postal_code_113,
  t0.notify_party_override_country AS notify_party_override_country_114,
  t0.notify_party_override_phone AS notify_party_override_phone_115,
  t0.notify_party_override_email AS notify_party_override_email_116,
  t0.notify_party_override_contact_person AS notify_party_override_contact_person_117,
  t0.department_id AS department_id_118,
  t0.courier_organization_id AS courier_organization_id_119,
  t0.master_job_id AS master_job_id_120,
  t0.main_freight_charge_code_id AS main_freight_charge_code_id_121,
  t0.shipper_id AS shipper_id_122,
  t0.consignee_id AS consignee_id_123,
  t0.notify_party_id AS notify_party_id_124,
  t0.profit_organization_id AS profit_organization_id_125,
  t0.counterparty_agent_id AS counterparty_agent_id_126,
  t0.commercial_id AS commercial_id_127,
  t0.customer_id AS customer_id_128,
  t0.airline_id AS airline_id_129,
  t0.shipper_address_id AS shipper_address_id_130,
  t0.consignee_address_id AS consignee_address_id_131,
  t0.notify_party_address_id AS notify_party_address_id_132,
  t0.pickup_organization_id AS pickup_organization_id_133,
  t0.pickup_address_id AS pickup_address_id_134,
  t0.delivery_organization_id AS delivery_organization_id_135,
  t0.delivery_address_id AS delivery_address_id_136,
  t0.pickup_transporter_id AS pickup_transporter_id_137,
  t0.delivery_transporter_id AS delivery_transporter_id_138,
  t0.pickup_depot_organization_id AS pickup_depot_organization_id_139,
  t0.pickup_depot_address_id AS pickup_depot_address_id_140,
  t0.delivery_depot_organization_id AS delivery_depot_organization_id_141,
  t0.delivery_depot_address_id AS delivery_depot_address_id_142,
  t0.delivery_airport_id AS delivery_airport_id_143,
  t0.port_terminal_organization_id AS port_terminal_organization_id_144,
  t0.customs_office_id AS customs_office_id_145,
  t0.customs_country_of_origin_id AS customs_country_of_origin_id_146,
  t0.origin_port_id AS origin_port_id_147,
  t0.destination_port_id AS destination_port_id_148,
  t0.origin_country_id AS origin_country_id_149,
  t0.destination_country_id AS destination_country_id_150,
  t0.mawb_number_id AS mawb_number_id_151,
  t0.incoterm_id AS incoterm_id_152,
  t0.compliance_override_by_id AS compliance_override_by_id_153,
  t0.created_by_id AS created_by_id_154,
  t0.updated_by_id AS updated_by_id_155,
  t0.cancelled_by_id AS cancelled_by_id_156,
  t157.id AS id_158,
  t157.mawb_number AS mawb_number_159,
  t157.sync_with_hawbs AS sync_with_hawbs_160,
  t157.accounting_information AS accounting_information_161,
  t157.handling_information AS handling_information_162,
  t157.sci AS sci_163,
  t157.weight_valuation_payment AS weight_valuation_payment_164,
  t157.other_charges_payment AS other_charges_payment_165,
  t157.declared_value_for_carriage AS declared_value_for_carriage_166,
  t157.declared_value_for_customs AS declared_value_for_customs_167,
  t157.amount_of_insurance AS amount_of_insurance_168,
  t157.weight_charge AS weight_charge_169,
  t157.valuation_charge AS valuation_charge_170,
  t157.tax AS tax_171,
  t157.total_other_charges_due_agent AS total_other_charges_due_agent_172,
  t157.total_other_charges_due_carrier AS total_other_charges_due_carrier_173,
  t157.total_prepaid AS total_prepaid_174,
  t157.total_collect AS total_collect_175,
  t157.ssr AS ssr_176,
  t157.shc AS shc_177,
  t157.nature_obs AS nature_obs_178,
  t157.awb_notes AS awb_notes_179,
  t157.as_agreed AS as_agreed_180,
  t157.frete_prepaid AS frete_prepaid_181,
  t157.taxa_prepaid AS taxa_prepaid_182,
  t157.frete_collect AS frete_collect_183,
  t157.taxa_collect AS taxa_collect_184,
  t157.terminal AS terminal_185,
  t157.issue_date AS issue_date_186,
  t157.status AS status_187,
  t157.created_at AS created_at_188,
  t157.updated_at AS updated_at_189,
  t157.job_id AS job_id_190,
  t157.airline_id AS airline_id_191,
  t157.issuer_id AS issuer_id_192,
  t157.signed_by_user_id AS signed_by_user_id_193,
  t157.currency_id AS currency_id_194,
  t195.id AS id_196,
  t195.mbl_number AS mbl_number_197,
  t195.booking_reference AS booking_reference_198,
  t195.total_weight AS total_weight_199,
  t195.total_volume AS total_volume_200,
  t195.total_packages AS total_packages_201,
  t195.vessel_name AS vessel_name_202,
  t195.voyage_number AS voyage_number_203,
  t195.place_of_receipt AS place_of_receipt_204,
  t195.place_of_delivery AS place_of_delivery_205,
  t195.load_type AS load_type_206,
  t195.freight_terms AS freight_terms_207,
  t195.service_type AS service_type_208,
  t195.shipping_marks AS shipping_marks_209,
  t195.number_of_originals AS number_of_originals_210,
  t195.place_of_issue AS place_of_issue_211,
  t195.freight_payable_at AS freight_payable_at_212,
  t195.date_of_issue AS date_of_issue_213,
  t195.on_board_date AS on_board_date_214,
  t195.declared_value AS declared_value_215,
  t195.sync_with_hbls AS sync_with_hbls_216,
  t195.notes AS notes_217,
  t195.status AS status_218,
  t195.created_at AS created_at_219,
  t195.updated_at AS updated_at_220,
  t195.shipper_manual_override AS shipper_manual_override_221,
  t195.shipper_override_name AS shipper_override_name_222,
  t195.shipper_override_legal_name AS shipper_override_legal_name_223,
  t195.shipper_override_tax_id AS shipper_override_tax_id_224,
  t195.shipper_override_address AS shipper_override_address_225,
  t195.shipper_override_city AS shipper_override_city_226,
  t195.shipper_override_state AS shipper_override_state_227,
  t195.shipper_override_postal_code AS shipper_override_postal_code_228,
  t195.shipper_override_country AS shipper_override_country_229,
  t195.shipper_override_phone AS shipper_override_phone_230,
  t195.shipper_override_email AS shipper_override_email_231,
  t195.shipper_override_contact_person AS shipper_override_contact_person_232,
  t195.consignee_manual_override AS consignee_manual_override_233,
  t195.consignee_override_name AS consignee_override_name_234,
  t195.consignee_override_legal_name AS consignee_override_legal_name_235,
  t195.consignee_override_tax_id AS consignee_override_tax_id_236,
  t195.consignee_override_address AS consignee_override_address_237,
  t195.consignee_override_city AS consignee_override_city_238,
  t195.consignee_override_state AS consignee_override_state_239,
  t195.consignee_override_postal_code AS consignee_override_postal_code_240,
  t195.consignee_override_country AS consignee_override_country_241,
  t195.consignee_override_phone AS consignee_override_phone_242,
  t195.consignee_override_email AS consignee_override_email_243,
  t195.consignee_override_contact_person AS consignee_override_contact_person_244,
  t195.notify_party_manual_override AS notify_party_manual_override_245,
  t195.notify_party_override_name AS notify_party_override_name_246,
  t195.notify_party_override_legal_name AS notify_party_override_legal_name_247,
  t195.notify_party_override_tax_id AS notify_party_override_tax_id_248,
  t195.notify_party_override_address AS notify_party_override_address_249,
  t195.notify_party_override_city AS notify_party_override_city_250,
  t195.notify_party_override_state AS notify_party_override_state_251,
  t195.notify_party_override_postal_code AS notify_party_override_postal_code_252,
  t195.notify_party_override_country AS notify_party_override_country_253,
  t195.notify_party_override_phone AS notify_party_override_phone_254,
  t195.notify_party_override_email AS notify_party_override_email_255,
  t195.notify_party_override_contact_person AS notify_party_override_contact_person_256,
  t195.job_id AS job_id_257,
  t195.carrier_id AS carrier_id_258,
  t195.issuer_id AS issuer_id_259,
  t195.shipper_id AS shipper_id_260,
  t195.consignee_id AS consignee_id_261,
  t195.notify_party_id AS notify_party_id_262,
  t195.shipper_address_id AS shipper_address_id_263,
  t195.consignee_address_id AS consignee_address_id_264,
  t195.notify_party_address_id AS notify_party_address_id_265,
  t195.port_of_loading_id AS port_of_loading_id_266,
  t195.port_of_discharge_id AS port_of_discharge_id_267,
  t195.currency_id AS currency_id_268,
  t269.id AS id_270,
  t269.cmr_number AS cmr_number_271,
  t269.load_mode AS load_mode_272,
  t269.vehicle_type AS vehicle_type_273,
  t269.truck_plate_number AS truck_plate_number_274,
  t269.trailer_plate_number AS trailer_plate_number_275,
  t269.driver_name AS driver_name_276,
  t269.driver_phone AS driver_phone_277,
  t269.place_of_taking_over AS place_of_taking_over_278,
  t269.place_of_delivery AS place_of_delivery_279,
  t269.incoterm_location AS incoterm_location_280,
  t269.freight_payment AS freight_payment_281,
  t269.agreed_price AS agreed_price_282,
  t269.total_pieces AS total_pieces_283,
  t269.total_gross_weight AS total_gross_weight_284,
  t269.total_volume AS total_volume_285,
  t269.total_loading_meters AS total_loading_meters_286,
  t269.has_dangerous_goods AS has_dangerous_goods_287,
  t269.adr_classes AS adr_classes_288,
  t269.adr_un_numbers AS adr_un_numbers_289,
  t269.requested_pickup_date AS requested_pickup_date_290,
  t269.requested_delivery_date AS requested_delivery_date_291,
  t269.actual_pickup_date AS actual_pickup_date_292,
  t269.actual_delivery_date AS actual_delivery_date_293,
  t269.sender_instructions AS sender_instructions_294,
  t269.special_agreements AS special_agreements_295,
  t269.carrier_reservations AS carrier_reservations_296,
  t269.pod_signed_by AS pod_signed_by_297,
  t269.pod_signed_at AS pod_signed_at_298,
  t269.pod_notes AS pod_notes_299,
  t269.notes AS notes_300,
  t269.sync_with_cargo_lines AS sync_with_cargo_lines_301,
  t269.status AS status_302,
  t269.created_at AS created_at_303,
  t269.updated_at AS updated_at_304,
  t269.shipper_manual_override AS shipper_manual_override_305,
  t269.shipper_override_name AS shipper_override_name_306,
  t269.shipper_override_legal_name AS shipper_override_legal_name_307,
  t269.shipper_override_tax_id AS shipper_override_tax_id_308,
  t269.shipper_override_address AS shipper_override_address_309,
  t269.shipper_override_city AS shipper_override_city_310,
  t269.shipper_override_state AS shipper_override_state_311,
  t269.shipper_override_postal_code AS shipper_override_postal_code_312,
  t269.shipper_override_country AS shipper_override_country_313,
  t269.shipper_override_phone AS shipper_override_phone_314,
  t269.shipper_override_email AS shipper_override_email_315,
  t269.shipper_override_contact_person AS shipper_override_contact_person_316,
  t269.consignee_manual_override AS consignee_manual_override_317,
  t269.consignee_override_name AS consignee_override_name_318,
  t269.consignee_override_legal_name AS consignee_override_legal_name_319,
  t269.consignee_override_tax_id AS consignee_override_tax_id_320,
  t269.consignee_override_address AS consignee_override_address_321,
  t269.consignee_override_city AS consignee_override_city_322,
  t269.consignee_override_state AS consignee_override_state_323,
  t269.consignee_override_postal_code AS consignee_override_postal_code_324,
  t269.consignee_override_country AS consignee_override_country_325,
  t269.consignee_override_phone AS consignee_override_phone_326,
  t269.consignee_override_email AS consignee_override_email_327,
  t269.consignee_override_contact_person AS consignee_override_contact_person_328,
  t269.notify_party_manual_override AS notify_party_manual_override_329,
  t269.notify_party_override_name AS notify_party_override_name_330,
  t269.notify_party_override_legal_name AS notify_party_override_legal_name_331,
  t269.notify_party_override_tax_id AS notify_party_override_tax_id_332,
  t269.notify_party_override_address AS notify_party_override_address_333,
  t269.notify_party_override_city AS notify_party_override_city_334,
  t269.notify_party_override_state AS notify_party_override_state_335,
  t269.notify_party_override_postal_code AS notify_party_override_postal_code_336,
  t269.notify_party_override_country AS notify_party_override_country_337,
  t269.notify_party_override_phone AS notify_party_override_phone_338,
  t269.notify_party_override_email AS notify_party_override_email_339,
  t269.notify_party_override_contact_person AS notify_party_override_contact_person_340,
  t269.job_id AS job_id_341,
  t269.carrier_id AS carrier_id_342,
  t269.issuer_id AS issuer_id_343,
  t269.driver_license_id AS driver_license_id_344,
  t269.shipper_id AS shipper_id_345,
  t269.consignee_id AS consignee_id_346,
  t269.notify_party_id AS notify_party_id_347,
  t269.shipper_address_id AS shipper_address_id_348,
  t269.consignee_address_id AS consignee_address_id_349,
  t269.notify_party_address_id AS notify_party_address_id_350,
  t269.incoterm_id AS incoterm_id_351,
  t269.currency_id AS currency_id_352
FROM
  jobs t0
  LEFT JOIN master_air_waybills t157 ON t157.job_id = t0.id
  LEFT JOIN master_bills_of_lading t195 ON t195.job_id = t0.id
  LEFT JOIN consignment_notes t269 ON t269.job_id = t0.id
WHERE
  t0.id = ?