Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.contract_number AS contract_number_2,
  t0.contract_date AS contract_date_3,
  t0.contract_type AS contract_type_4,
  t0.laycan_start AS laycan_start_5,
  t0.laycan_end AS laycan_end_6,
  t0.status AS status_7,
  t0.freight_cost AS freight_cost_8,
  t0.freight_cost_currency AS freight_cost_currency_9,
  t0.freight_type AS freight_type_10,
  t0.demurrage_per_day AS demurrage_per_day_11,
  t0.demurrage_per_day_currency AS demurrage_per_day_currency_12,
  t0.address_commission AS address_commission_13,
  t0.brokerage_commission AS brokerage_commission_14,
  t0.liftings_min AS liftings_min_15,
  t0.liftings_max AS liftings_max_16,
  t0.checklist_notes AS checklist_notes_17,
  t0.demurrage_status AS demurrage_status_18,
  t0.demurrage_time_bar AS demurrage_time_bar_19,
  t0.demurrage_payment_date AS demurrage_payment_date_20,
  t0.final_demurrage_cost AS final_demurrage_cost_21,
  t0.final_demurrage_cost_currency AS final_demurrage_cost_currency_22,
  t0.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_23,
  t0.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_24,
  t0.eta_arrival AS eta_arrival_25,
  t0.delivered_arrival AS delivered_arrival_26,
  t0.delivery_aprox_notice1 AS delivery_aprox_notice1_27,
  t0.delivery_aprox_notice2 AS delivery_aprox_notice2_28,
  t0.delivery_aprox_notice3 AS delivery_aprox_notice3_29,
  t0.delivery_aprox_notice4 AS delivery_aprox_notice4_30,
  t0.delivery_aprox_notice5 AS delivery_aprox_notice5_31,
  t0.delivery_aprox_notice6 AS delivery_aprox_notice6_32,
  t0.delivery_aprox_notice7 AS delivery_aprox_notice7_33,
  t0.delivery_firm_notice1 AS delivery_firm_notice1_34,
  t0.delivery_firm_notice2 AS delivery_firm_notice2_35,
  t0.delivery_firm_notice3 AS delivery_firm_notice3_36,
  t0.delivery_firm_notice4 AS delivery_firm_notice4_37,
  t0.delivery_firm_notice5 AS delivery_firm_notice5_38,
  t0.delivery_firm_notice6 AS delivery_firm_notice6_39,
  t0.delivery_firm_notice7 AS delivery_firm_notice7_40,
  t0.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_41,
  t0.ship_delivered AS ship_delivered_42,
  t0.hire_per_day AS hire_per_day_43,
  t0.hire_per_day_currency AS hire_per_day_currency_44,
  t0.period AS period_45,
  t0.report_description AS report_description_46,
  t0.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_47,
  t0.vessel_was_substituted AS vessel_was_substituted_48,
  t0.addendum_issued AS addendum_issued_49,
  t0.addendum_description AS addendum_description_50,
  t0.created_at AS created_at_51,
  t0.updated_at AS updated_at_52,
  t0.vessel_id AS vessel_id_53,
  t0.owner_id AS owner_id_54,
  t0.charterer_id AS charterer_id_55,
  t0.broker_id AS broker_id_56,
  t0.operator_id AS operator_id_57,
  t0.checklist_id AS checklist_id_58,
  t0.delivery_port1_id AS delivery_port1_id_59,
  t0.delivery_port2_id AS delivery_port2_id_60,
  t0.contract_coa_id AS contract_coa_id_61
FROM
  contract t0
WHERE
  t0.contract_coa_id = ?

SELECT t0.id AS id_1, t0.contract_number AS contract_number_2, t0.contract_date AS contract_date_3, t0.contract_type AS contract_type_4, t0.laycan_start AS laycan_start_5, t0.laycan_end AS laycan_end_6, t0.status AS status_7, t0.freight_cost AS freight_cost_8, t0.freight_cost_currency AS freight_cost_currency_9, t0.freight_type AS freight_type_10, t0.demurrage_per_day AS demurrage_per_day_11, t0.demurrage_per_day_currency AS demurrage_per_day_currency_12, t0.address_commission AS address_commission_13, t0.brokerage_commission AS brokerage_commission_14, t0.liftings_min AS liftings_min_15, t0.liftings_max AS liftings_max_16, t0.checklist_notes AS checklist_notes_17, t0.demurrage_status AS demurrage_status_18, t0.demurrage_time_bar AS demurrage_time_bar_19, t0.demurrage_payment_date AS demurrage_payment_date_20, t0.final_demurrage_cost AS final_demurrage_cost_21, t0.final_demurrage_cost_currency AS final_demurrage_cost_currency_22, t0.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_23, t0.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_24, t0.eta_arrival AS eta_arrival_25, t0.delivered_arrival AS delivered_arrival_26, t0.delivery_aprox_notice1 AS delivery_aprox_notice1_27, t0.delivery_aprox_notice2 AS delivery_aprox_notice2_28, t0.delivery_aprox_notice3 AS delivery_aprox_notice3_29, t0.delivery_aprox_notice4 AS delivery_aprox_notice4_30, t0.delivery_aprox_notice5 AS delivery_aprox_notice5_31, t0.delivery_aprox_notice6 AS delivery_aprox_notice6_32, t0.delivery_aprox_notice7 AS delivery_aprox_notice7_33, t0.delivery_firm_notice1 AS delivery_firm_notice1_34, t0.delivery_firm_notice2 AS delivery_firm_notice2_35, t0.delivery_firm_notice3 AS delivery_firm_notice3_36, t0.delivery_firm_notice4 AS delivery_firm_notice4_37, t0.delivery_firm_notice5 AS delivery_firm_notice5_38, t0.delivery_firm_notice6 AS delivery_firm_notice6_39, t0.delivery_firm_notice7 AS delivery_firm_notice7_40, t0.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_41, t0.ship_delivered AS ship_delivered_42, t0.hire_per_day AS hire_per_day_43, t0.hire_per_day_currency AS hire_per_day_currency_44, t0.period AS period_45, t0.report_description AS report_description_46, t0.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_47, t0.vessel_was_substituted AS vessel_was_substituted_48, t0.addendum_issued AS addendum_issued_49, t0.addendum_description AS addendum_description_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.vessel_id AS vessel_id_53, t0.owner_id AS owner_id_54, t0.charterer_id AS charterer_id_55, t0.broker_id AS broker_id_56, t0.operator_id AS operator_id_57, t0.checklist_id AS checklist_id_58, t0.delivery_port1_id AS delivery_port1_id_59, t0.delivery_port2_id AS delivery_port2_id_60, t0.contract_coa_id AS contract_coa_id_61 FROM contract t0 WHERE t0.contract_coa_id = '040fceeb-113b-459d-9d77-1cc65cc7e43a';

SELECT
  t0.id AS id_1,
  t0.port_name AS port_name_2,
  t0.geographic_location AS geographic_location_3,
  t0.cost_information_source AS cost_information_source_4,
  t0.state AS state_5,
  t0.country AS country_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  port t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.port_name AS port_name_2, t0.geographic_location AS geographic_location_3, t0.cost_information_source AS cost_information_source_4, t0.state AS state_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM port t0 WHERE t0.id = 'b45ec7d0-a321-4dca-86e4-903564ed7b97';

SELECT
  t0.id AS id_1,
  t0.vessel_name AS vessel_name_2,
  t0.imo_number AS imo_number_3,
  t0.vessel_type AS vessel_type_4,
  t0.tanker_type AS tanker_type_5,
  t0.bulker_type AS bulker_type_6,
  t0.tank_coating AS tank_coating_7,
  t0.dwt AS dwt_8,
  t0.year_built AS year_built_9,
  t0.observations AS observations_10,
  t0.box_shape AS box_shape_11,
  t0.open_hatch AS open_hatch_12,
  t0.nitrogen_generator AS nitrogen_generator_13,
  t0.imo_class AS imo_class_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.owner_id AS owner_id_17
FROM
  vessel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.vessel_name AS vessel_name_2, t0.imo_number AS imo_number_3, t0.vessel_type AS vessel_type_4, t0.tanker_type AS tanker_type_5, t0.bulker_type AS bulker_type_6, t0.tank_coating AS tank_coating_7, t0.dwt AS dwt_8, t0.year_built AS year_built_9, t0.observations AS observations_10, t0.box_shape AS box_shape_11, t0.open_hatch AS open_hatch_12, t0.nitrogen_generator AS nitrogen_generator_13, t0.imo_class AS imo_class_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.owner_id AS owner_id_17 FROM vessel t0 WHERE t0.id = '6a036530-51a9-4cb5-bf74-b1f6920e8961';

SELECT
  t0.id AS id_1,
  t0.port_call_type AS port_call_type_2,
  t0.arrival AS arrival_3,
  t0.berthing AS berthing_4,
  t0.departure AS departure_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.port_id AS port_id_8,
  t0.contract_id AS contract_id_9
FROM
  port_call t0
WHERE
  t0.contract_id = ?

SELECT t0.id AS id_1, t0.port_call_type AS port_call_type_2, t0.arrival AS arrival_3, t0.berthing AS berthing_4, t0.departure AS departure_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.port_id AS port_id_8, t0.contract_id AS contract_id_9 FROM port_call t0 WHERE t0.contract_id = '040fceeb-113b-459d-9d77-1cc65cc7e43a';

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.detailed_company_name AS detailed_company_name_3,
  t0.address_line1 AS address_line1_4,
  t0.address_line2 AS address_line2_5,
  t0.address_line3 AS address_line3_6,
  t0.chartering_email AS chartering_email_7,
  t0.operations_email AS operations_email_8,
  t0.accounting_email AS accounting_email_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.primary_contact_id AS primary_contact_id_12
FROM
  owner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.detailed_company_name AS detailed_company_name_3, t0.address_line1 AS address_line1_4, t0.address_line2 AS address_line2_5, t0.address_line3 AS address_line3_6, t0.chartering_email AS chartering_email_7, t0.operations_email AS operations_email_8, t0.accounting_email AS accounting_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.primary_contact_id AS primary_contact_id_12 FROM owner t0 WHERE t0.id = '5385e462-dc99-4dbd-b75e-fc8f5927a5cc';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.confirmation_token AS confirmation_token_6,
  t0.desk AS desk_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.avatar_id AS avatar_id_10
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.confirmation_token AS confirmation_token_6, t0.desk AS desk_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.avatar_id AS avatar_id_10 FROM user t0 WHERE t0.email = 'vtp@tidemaritime.com.br' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.address_line1 AS address_line1_3,
  t0.address_line2 AS address_line2_4,
  t0.address_line3 AS address_line3_5,
  t0.chartering_email AS chartering_email_6,
  t0.operations_email AS operations_email_7,
  t0.accounting_email AS accounting_email_8,
  t0.observations AS observations_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  charterer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.address_line1 AS address_line1_3, t0.address_line2 AS address_line2_4, t0.address_line3 AS address_line3_5, t0.chartering_email AS chartering_email_6, t0.operations_email AS operations_email_7, t0.accounting_email AS accounting_email_8, t0.observations AS observations_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM charterer t0 WHERE t0.id = '3c59fd9f-0877-41df-9c56-b3b669b9233b';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content_size AS content_size_3,
  t0.encoding_format AS encoding_format_4,
  t0.upload_date AS upload_date_5,
  t0.genre AS genre_6,
  t0.file_path AS file_path_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.contract_id AS contract_id_10
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content_size AS content_size_3, t0.encoding_format AS encoding_format_4, t0.upload_date AS upload_date_5, t0.genre AS genre_6, t0.file_path AS file_path_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.contract_id AS contract_id_10 FROM media t0 WHERE t0.id = '906c72a9-174a-4281-8ef0-9f3bfa282c9c';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.confirmation_token AS confirmation_token_6,
  t0.desk AS desk_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.avatar_id AS avatar_id_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.confirmation_token AS confirmation_token_6, t0.desk AS desk_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.avatar_id AS avatar_id_10 FROM user t0 WHERE t0.id = '6a4656d5-8ab1-41fc-9037-11153c21288f';

SELECT
  c0_.id AS id_0,
  c0_.contract_number AS contract_number_1,
  c0_.contract_date AS contract_date_2,
  c0_.contract_type AS contract_type_3,
  c0_.laycan_start AS laycan_start_4,
  c0_.laycan_end AS laycan_end_5,
  c0_.status AS status_6,
  c0_.freight_cost AS freight_cost_7,
  c0_.freight_cost_currency AS freight_cost_currency_8,
  c0_.freight_type AS freight_type_9,
  c0_.demurrage_per_day AS demurrage_per_day_10,
  c0_.demurrage_per_day_currency AS demurrage_per_day_currency_11,
  c0_.address_commission AS address_commission_12,
  c0_.brokerage_commission AS brokerage_commission_13,
  c0_.liftings_min AS liftings_min_14,
  c0_.liftings_max AS liftings_max_15,
  c0_.checklist_notes AS checklist_notes_16,
  c0_.demurrage_status AS demurrage_status_17,
  c0_.demurrage_time_bar AS demurrage_time_bar_18,
  c0_.demurrage_payment_date AS demurrage_payment_date_19,
  c0_.final_demurrage_cost AS final_demurrage_cost_20,
  c0_.final_demurrage_cost_currency AS final_demurrage_cost_currency_21,
  c0_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_22,
  c0_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_23,
  c0_.eta_arrival AS eta_arrival_24,
  c0_.delivered_arrival AS delivered_arrival_25,
  c0_.delivery_aprox_notice1 AS delivery_aprox_notice1_26,
  c0_.delivery_aprox_notice2 AS delivery_aprox_notice2_27,
  c0_.delivery_aprox_notice3 AS delivery_aprox_notice3_28,
  c0_.delivery_aprox_notice4 AS delivery_aprox_notice4_29,
  c0_.delivery_aprox_notice5 AS delivery_aprox_notice5_30,
  c0_.delivery_aprox_notice6 AS delivery_aprox_notice6_31,
  c0_.delivery_aprox_notice7 AS delivery_aprox_notice7_32,
  c0_.delivery_firm_notice1 AS delivery_firm_notice1_33,
  c0_.delivery_firm_notice2 AS delivery_firm_notice2_34,
  c0_.delivery_firm_notice3 AS delivery_firm_notice3_35,
  c0_.delivery_firm_notice4 AS delivery_firm_notice4_36,
  c0_.delivery_firm_notice5 AS delivery_firm_notice5_37,
  c0_.delivery_firm_notice6 AS delivery_firm_notice6_38,
  c0_.delivery_firm_notice7 AS delivery_firm_notice7_39,
  c0_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_40,
  c0_.ship_delivered AS ship_delivered_41,
  c0_.hire_per_day AS hire_per_day_42,
  c0_.hire_per_day_currency AS hire_per_day_currency_43,
  c0_.period AS period_44,
  c0_.report_description AS report_description_45,
  c0_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_46,
  c0_.vessel_was_substituted AS vessel_was_substituted_47,
  c0_.addendum_issued AS addendum_issued_48,
  c0_.addendum_description AS addendum_description_49,
  c0_.created_at AS created_at_50,
  c0_.updated_at AS updated_at_51,
  c0_.vessel_id AS vessel_id_52,
  c0_.owner_id AS owner_id_53,
  c0_.charterer_id AS charterer_id_54,
  c0_.broker_id AS broker_id_55,
  c0_.operator_id AS operator_id_56,
  c0_.checklist_id AS checklist_id_57,
  c0_.delivery_port1_id AS delivery_port1_id_58,
  c0_.delivery_port2_id AS delivery_port2_id_59,
  c0_.contract_coa_id AS contract_coa_id_60
FROM
  contract c0_
WHERE
  c0_.status <> 'COMPLETED'
  AND (
    SELECT
      COUNT(*)
    FROM
      contract c1_
    WHERE
      c1_.contract_coa_id = c0_.id
  ) = 0

SELECT c0_.id AS id_0, c0_.contract_number AS contract_number_1, c0_.contract_date AS contract_date_2, c0_.contract_type AS contract_type_3, c0_.laycan_start AS laycan_start_4, c0_.laycan_end AS laycan_end_5, c0_.status AS status_6, c0_.freight_cost AS freight_cost_7, c0_.freight_cost_currency AS freight_cost_currency_8, c0_.freight_type AS freight_type_9, c0_.demurrage_per_day AS demurrage_per_day_10, c0_.demurrage_per_day_currency AS demurrage_per_day_currency_11, c0_.address_commission AS address_commission_12, c0_.brokerage_commission AS brokerage_commission_13, c0_.liftings_min AS liftings_min_14, c0_.liftings_max AS liftings_max_15, c0_.checklist_notes AS checklist_notes_16, c0_.demurrage_status AS demurrage_status_17, c0_.demurrage_time_bar AS demurrage_time_bar_18, c0_.demurrage_payment_date AS demurrage_payment_date_19, c0_.final_demurrage_cost AS final_demurrage_cost_20, c0_.final_demurrage_cost_currency AS final_demurrage_cost_currency_21, c0_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_22, c0_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_23, c0_.eta_arrival AS eta_arrival_24, c0_.delivered_arrival AS delivered_arrival_25, c0_.delivery_aprox_notice1 AS delivery_aprox_notice1_26, c0_.delivery_aprox_notice2 AS delivery_aprox_notice2_27, c0_.delivery_aprox_notice3 AS delivery_aprox_notice3_28, c0_.delivery_aprox_notice4 AS delivery_aprox_notice4_29, c0_.delivery_aprox_notice5 AS delivery_aprox_notice5_30, c0_.delivery_aprox_notice6 AS delivery_aprox_notice6_31, c0_.delivery_aprox_notice7 AS delivery_aprox_notice7_32, c0_.delivery_firm_notice1 AS delivery_firm_notice1_33, c0_.delivery_firm_notice2 AS delivery_firm_notice2_34, c0_.delivery_firm_notice3 AS delivery_firm_notice3_35, c0_.delivery_firm_notice4 AS delivery_firm_notice4_36, c0_.delivery_firm_notice5 AS delivery_firm_notice5_37, c0_.delivery_firm_notice6 AS delivery_firm_notice6_38, c0_.delivery_firm_notice7 AS delivery_firm_notice7_39, c0_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_40, c0_.ship_delivered AS ship_delivered_41, c0_.hire_per_day AS hire_per_day_42, c0_.hire_per_day_currency AS hire_per_day_currency_43, c0_.period AS period_44, c0_.report_description AS report_description_45, c0_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_46, c0_.vessel_was_substituted AS vessel_was_substituted_47, c0_.addendum_issued AS addendum_issued_48, c0_.addendum_description AS addendum_description_49, c0_.created_at AS created_at_50, c0_.updated_at AS updated_at_51, c0_.vessel_id AS vessel_id_52, c0_.owner_id AS owner_id_53, c0_.charterer_id AS charterer_id_54, c0_.broker_id AS broker_id_55, c0_.operator_id AS operator_id_56, c0_.checklist_id AS checklist_id_57, c0_.delivery_port1_id AS delivery_port1_id_58, c0_.delivery_port2_id AS delivery_port2_id_59, c0_.contract_coa_id AS contract_coa_id_60 FROM contract c0_ WHERE c0_.status <> 'COMPLETED' AND (SELECT COUNT(*) FROM contract c1_ WHERE c1_.contract_coa_id = c0_.id) = 0;