Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

14 Database Queries

8 Different statements

6.71 ms Query time

1 Invalid entities

Queries

Group similar statements


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 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, v1_.id AS id_52, v1_.vessel_name AS vessel_name_53, v1_.imo_number AS imo_number_54, v1_.vessel_type AS vessel_type_55, v1_.tanker_type AS tanker_type_56, v1_.bulker_type AS bulker_type_57, v1_.tank_coating AS tank_coating_58, v1_.dwt AS dwt_59, v1_.year_built AS year_built_60, v1_.observations AS observations_61, v1_.box_shape AS box_shape_62, v1_.open_hatch AS open_hatch_63, v1_.nitrogen_generator AS nitrogen_generator_64, v1_.imo_class AS imo_class_65, v1_.created_at AS created_at_66, v1_.updated_at AS updated_at_67, o2_.id AS id_68, o2_.company_name AS company_name_69, o2_.detailed_company_name AS detailed_company_name_70, o2_.address_line1 AS address_line1_71, o2_.address_line2 AS address_line2_72, o2_.address_line3 AS address_line3_73, o2_.chartering_email AS chartering_email_74, o2_.operations_email AS operations_email_75, o2_.accounting_email AS accounting_email_76, o2_.created_at AS created_at_77, o2_.updated_at AS updated_at_78, c3_.id AS id_79, c3_.company_name AS company_name_80, c3_.address_line1 AS address_line1_81, c3_.address_line2 AS address_line2_82, c3_.address_line3 AS address_line3_83, c3_.chartering_email AS chartering_email_84, c3_.operations_email AS operations_email_85, c3_.accounting_email AS accounting_email_86, c3_.observations AS observations_87, c3_.created_at AS created_at_88, c3_.updated_at AS updated_at_89, u4_.id AS id_90, u4_.name AS name_91, u4_.email AS email_92, u4_.roles AS roles_93, u4_.password AS password_94, u4_.confirmation_token AS confirmation_token_95, u4_.desk AS desk_96, u4_.created_at AS created_at_97, u4_.updated_at AS updated_at_98, u5_.id AS id_99, u5_.name AS name_100, u5_.email AS email_101, u5_.roles AS roles_102, u5_.password AS password_103, u5_.confirmation_token AS confirmation_token_104, u5_.desk AS desk_105, u5_.created_at AS created_at_106, u5_.updated_at AS updated_at_107, a6_.id AS id_108, a6_.additional_cost AS additional_cost_109, a6_.additional_cost_currency AS additional_cost_currency_110, a6_.additional_type AS additional_type_111, a6_.description AS description_112, a6_.created_at AS created_at_113, a6_.updated_at AS updated_at_114, m7_.id AS id_115, m7_.name AS name_116, m7_.content_size AS content_size_117, m7_.encoding_format AS encoding_format_118, m7_.upload_date AS upload_date_119, m7_.genre AS genre_120, m7_.file_path AS file_path_121, m7_.created_at AS created_at_122, m7_.updated_at AS updated_at_123, p8_.id AS id_124, p8_.port_call_type AS port_call_type_125, p8_.arrival AS arrival_126, p8_.berthing AS berthing_127, p8_.departure AS departure_128, p8_.created_at AS created_at_129, p8_.updated_at AS updated_at_130, r9_.id AS id_131, r9_.created_at AS created_at_132, r9_.updated_at AS updated_at_133, r10_.id AS id_134, r10_.category AS category_135, r10_.subcategory AS subcategory_136, r10_.created_at AS created_at_137, r10_.updated_at AS updated_at_138, c11_.id AS id_139, c11_.quantity_m3 AS quantity_m3_140, c11_.quantity_mt AS quantity_mt_141, c11_.created_at AS created_at_142, c11_.updated_at AS updated_at_143, p12_.id AS id_144, p12_.amount AS amount_145, p12_.amount_currency AS amount_currency_146, p12_.due_date AS due_date_147, p12_.description AS description_148, p12_.status AS status_149, p12_.created_at AS created_at_150, p12_.updated_at AS updated_at_151, h13_.id AS id_152, h13_.hire_begin AS hire_begin_153, h13_.hire_end AS hire_end_154, h13_.fuel_type AS fuel_type_155, h13_.fuel_type2 AS fuel_type2_156, h13_.fuel_type3 AS fuel_type3_157, h13_.price AS price_158, h13_.price2 AS price2_159, h13_.price3 AS price3_160, h13_.price_currency AS price_currency_161, h13_.price_currency2 AS price_currency2_162, h13_.price_currency3 AS price_currency3_163, h13_.multi_fuel AS multi_fuel_164, h13_.off_hire_begin AS off_hire_begin_165, h13_.off_hire_end AS off_hire_end_166, h13_.off_hire_cost AS off_hire_cost_167, h13_.off_hire_cost_currency AS off_hire_cost_currency_168, h13_.address_commission AS address_commission_169, h13_.extra_costs AS extra_costs_170, h13_.extra_costs_currency AS extra_costs_currency_171, h13_.extra_costs_description AS extra_costs_description_172, h13_.total_invoice AS total_invoice_173, h13_.total_invoice_currency AS total_invoice_currency_174, h13_.invoice_status AS invoice_status_175, h13_.bunker AS bunker_176, h13_.final_hire AS final_hire_177, h13_.created_at AS created_at_178, h13_.updated_at AS updated_at_179, c14_.id AS id_180, c14_.contract_number AS contract_number_181, c14_.contract_date AS contract_date_182, c14_.contract_type AS contract_type_183, c14_.laycan_start AS laycan_start_184, c14_.laycan_end AS laycan_end_185, c14_.status AS status_186, c14_.freight_cost AS freight_cost_187, c14_.freight_cost_currency AS freight_cost_currency_188, c14_.freight_type AS freight_type_189, c14_.demurrage_per_day AS demurrage_per_day_190, c14_.demurrage_per_day_currency AS demurrage_per_day_currency_191, c14_.address_commission AS address_commission_192, c14_.brokerage_commission AS brokerage_commission_193, c14_.liftings_min AS liftings_min_194, c14_.liftings_max AS liftings_max_195, c14_.checklist_notes AS checklist_notes_196, c14_.demurrage_status AS demurrage_status_197, c14_.demurrage_time_bar AS demurrage_time_bar_198, c14_.demurrage_payment_date AS demurrage_payment_date_199, c14_.final_demurrage_cost AS final_demurrage_cost_200, c14_.final_demurrage_cost_currency AS final_demurrage_cost_currency_201, c14_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202, c14_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203, c14_.eta_arrival AS eta_arrival_204, c14_.delivered_arrival AS delivered_arrival_205, c14_.delivery_aprox_notice1 AS delivery_aprox_notice1_206, c14_.delivery_aprox_notice2 AS delivery_aprox_notice2_207, c14_.delivery_aprox_notice3 AS delivery_aprox_notice3_208, c14_.delivery_aprox_notice4 AS delivery_aprox_notice4_209, c14_.delivery_aprox_notice5 AS delivery_aprox_notice5_210, c14_.delivery_aprox_notice6 AS delivery_aprox_notice6_211, c14_.delivery_aprox_notice7 AS delivery_aprox_notice7_212, c14_.delivery_firm_notice1 AS delivery_firm_notice1_213, c14_.delivery_firm_notice2 AS delivery_firm_notice2_214, c14_.delivery_firm_notice3 AS delivery_firm_notice3_215, c14_.delivery_firm_notice4 AS delivery_firm_notice4_216, c14_.delivery_firm_notice5 AS delivery_firm_notice5_217, c14_.delivery_firm_notice6 AS delivery_firm_notice6_218, c14_.delivery_firm_notice7 AS delivery_firm_notice7_219, c14_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220, c14_.ship_delivered AS ship_delivered_221, c14_.hire_per_day AS hire_per_day_222, c14_.hire_per_day_currency AS hire_per_day_currency_223, c14_.period AS period_224, c14_.report_description AS report_description_225, c14_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226, c14_.vessel_was_substituted AS vessel_was_substituted_227, c14_.addendum_issued AS addendum_issued_228, c14_.addendum_description AS addendum_description_229, c14_.created_at AS created_at_230, c14_.updated_at AS updated_at_231, c15_.id AS id_232, c15_.checklist_name AS checklist_name_233, c15_.notes AS notes_234, c15_.created_at AS created_at_235, c15_.updated_at AS updated_at_236, t16_.id AS id_237, t16_.task_name AS task_name_238, t16_.description AS description_239, t16_.task_index AS task_index_240, t16_.created_at AS created_at_241, t16_.updated_at AS updated_at_242, p17_.id AS id_243, p17_.port_name AS port_name_244, p17_.geographic_location AS geographic_location_245, p17_.cost_information_source AS cost_information_source_246, p17_.state AS state_247, p17_.country AS country_248, p17_.created_at AS created_at_249, p17_.updated_at AS updated_at_250, p18_.id AS id_251, p18_.port_name AS port_name_252, p18_.geographic_location AS geographic_location_253, p18_.cost_information_source AS cost_information_source_254, p18_.state AS state_255, p18_.country AS country_256, p18_.created_at AS created_at_257, p18_.updated_at AS updated_at_258, d19_.id AS id_259, d19_.notice_number AS notice_number_260, d19_.notice_type AS notice_type_261, d19_.notice_date AS notice_date_262, d19_.status AS status_263, d19_.created_at AS created_at_264, d19_.updated_at AS updated_at_265, c20_.id AS id_266, c20_.contract_number AS contract_number_267, c20_.contract_date AS contract_date_268, c20_.contract_type AS contract_type_269, c20_.laycan_start AS laycan_start_270, c20_.laycan_end AS laycan_end_271, c20_.status AS status_272, c20_.freight_cost AS freight_cost_273, c20_.freight_cost_currency AS freight_cost_currency_274, c20_.freight_type AS freight_type_275, c20_.demurrage_per_day AS demurrage_per_day_276, c20_.demurrage_per_day_currency AS demurrage_per_day_currency_277, c20_.address_commission AS address_commission_278, c20_.brokerage_commission AS brokerage_commission_279, c20_.liftings_min AS liftings_min_280, c20_.liftings_max AS liftings_max_281, c20_.checklist_notes AS checklist_notes_282, c20_.demurrage_status AS demurrage_status_283, c20_.demurrage_time_bar AS demurrage_time_bar_284, c20_.demurrage_payment_date AS demurrage_payment_date_285, c20_.final_demurrage_cost AS final_demurrage_cost_286, c20_.final_demurrage_cost_currency AS final_demurrage_cost_currency_287, c20_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288, c20_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289, c20_.eta_arrival AS eta_arrival_290, c20_.delivered_arrival AS delivered_arrival_291, c20_.delivery_aprox_notice1 AS delivery_aprox_notice1_292, c20_.delivery_aprox_notice2 AS delivery_aprox_notice2_293, c20_.delivery_aprox_notice3 AS delivery_aprox_notice3_294, c20_.delivery_aprox_notice4 AS delivery_aprox_notice4_295, c20_.delivery_aprox_notice5 AS delivery_aprox_notice5_296, c20_.delivery_aprox_notice6 AS delivery_aprox_notice6_297, c20_.delivery_aprox_notice7 AS delivery_aprox_notice7_298, c20_.delivery_firm_notice1 AS delivery_firm_notice1_299, c20_.delivery_firm_notice2 AS delivery_firm_notice2_300, c20_.delivery_firm_notice3 AS delivery_firm_notice3_301, c20_.delivery_firm_notice4 AS delivery_firm_notice4_302, c20_.delivery_firm_notice5 AS delivery_firm_notice5_303, c20_.delivery_firm_notice6 AS delivery_firm_notice6_304, c20_.delivery_firm_notice7 AS delivery_firm_notice7_305, c20_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306, c20_.ship_delivered AS ship_delivered_307, c20_.hire_per_day AS hire_per_day_308, c20_.hire_per_day_currency AS hire_per_day_currency_309, c20_.period AS period_310, c20_.report_description AS report_description_311, c20_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312, c20_.vessel_was_substituted AS vessel_was_substituted_313, c20_.addendum_issued AS addendum_issued_314, c20_.addendum_description AS addendum_description_315, c20_.created_at AS created_at_316, c20_.updated_at AS updated_at_317, c0_.vessel_id AS vessel_id_318, c0_.owner_id AS owner_id_319, c0_.charterer_id AS charterer_id_320, c0_.broker_id AS broker_id_321, c0_.operator_id AS operator_id_322, c0_.checklist_id AS checklist_id_323, c0_.delivery_port1_id AS delivery_port1_id_324, c0_.delivery_port2_id AS delivery_port2_id_325, c0_.contract_coa_id AS contract_coa_id_326, v1_.owner_id AS owner_id_327, o2_.primary_contact_id AS primary_contact_id_328, u4_.avatar_id AS avatar_id_329, u5_.avatar_id AS avatar_id_330, a6_.contract_id AS contract_id_331, m7_.contract_id AS contract_id_332, p8_.port_id AS port_id_333, p8_.contract_id AS contract_id_334, r9_.port_id AS port_id_335, r9_.contract_id AS contract_id_336, r10_.contract_id AS contract_id_337, c11_.cargo_id AS cargo_id_338, c11_.contract_id AS contract_id_339, p12_.contract_id AS contract_id_340, h13_.contract_id AS contract_id_341, c14_.vessel_id AS vessel_id_342, c14_.owner_id AS owner_id_343, c14_.charterer_id AS charterer_id_344, c14_.broker_id AS broker_id_345, c14_.operator_id AS operator_id_346, c14_.checklist_id AS checklist_id_347, c14_.delivery_port1_id AS delivery_port1_id_348, c14_.delivery_port2_id AS delivery_port2_id_349, c14_.contract_coa_id AS contract_coa_id_350, t16_.checklist_id AS checklist_id_351, d19_.contract_id AS contract_id_352, c20_.vessel_id AS vessel_id_353, c20_.owner_id AS owner_id_354, c20_.charterer_id AS charterer_id_355, c20_.broker_id AS broker_id_356, c20_.operator_id AS operator_id_357, c20_.checklist_id AS checklist_id_358, c20_.delivery_port1_id AS delivery_port1_id_359, c20_.delivery_port2_id AS delivery_port2_id_360, c20_.contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_.vessel_id = v1_.id LEFT JOIN owner o2_ ON c0_.owner_id = o2_.id LEFT JOIN charterer c3_ ON c0_.charterer_id = c3_.id LEFT JOIN user u4_ ON c0_.broker_id = u4_.id LEFT JOIN user u5_ ON c0_.operator_id = u5_.id LEFT JOIN additional_cost a6_ ON c0_.id = a6_.contract_id LEFT JOIN media m7_ ON c0_.id = m7_.contract_id LEFT JOIN port_call p8_ ON c0_.id = p8_.contract_id LEFT JOIN reported_port r9_ ON c0_.id = r9_.contract_id LEFT JOIN reported_incident r10_ ON c0_.id = r10_.contract_id LEFT JOIN contract_cargo c11_ ON c0_.id = c11_.contract_id LEFT JOIN payment p12_ ON c0_.id = p12_.contract_id LEFT JOIN hire h13_ ON c0_.id = h13_.contract_id LEFT JOIN contract c14_ ON c0_.id = c14_.contract_coa_id LEFT JOIN checklist c15_ ON c0_.checklist_id = c15_.id LEFT JOIN contract_task c21_ ON c0_.id = c21_.contract_id LEFT JOIN task t16_ ON t16_.id = c21_.task_id LEFT JOIN port p17_ ON c0_.delivery_port1_id = p17_.id LEFT JOIN port p18_ ON c0_.delivery_port2_id = p18_.id LEFT JOIN delivery_notice d19_ ON c0_.id = d19_.contract_id LEFT JOIN contract c20_ ON c0_.contract_coa_id = c20_.id WHERE c0_.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 = ?
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 = ?
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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.cargo_type AS cargo_type_3, t0.subtype AS subtype_4, t0.observations AS observations_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cargo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.task_name AS task_name_2, t0.description AS description_3, t0.task_index AS task_index_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.checklist_id AS checklist_id_7 FROM task t0 WHERE t0.checklist_id = ? ORDER BY t0.task_index ASC
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.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.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.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ?
SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ?

#▲	Time	Info
1	0.46 ms	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 Parameters: [`"vtp@tidemaritime.com.br"`] View formatted query View runnable query Explain query 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;
2	3.36 ms	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, v1_.id AS id_52, v1_.vessel_name AS vessel_name_53, v1_.imo_number AS imo_number_54, v1_.vessel_type AS vessel_type_55, v1_.tanker_type AS tanker_type_56, v1_.bulker_type AS bulker_type_57, v1_.tank_coating AS tank_coating_58, v1_.dwt AS dwt_59, v1_.year_built AS year_built_60, v1_.observations AS observations_61, v1_.box_shape AS box_shape_62, v1_.open_hatch AS open_hatch_63, v1_.nitrogen_generator AS nitrogen_generator_64, v1_.imo_class AS imo_class_65, v1_.created_at AS created_at_66, v1_.updated_at AS updated_at_67, o2_.id AS id_68, o2_.company_name AS company_name_69, o2_.detailed_company_name AS detailed_company_name_70, o2_.address_line1 AS address_line1_71, o2_.address_line2 AS address_line2_72, o2_.address_line3 AS address_line3_73, o2_.chartering_email AS chartering_email_74, o2_.operations_email AS operations_email_75, o2_.accounting_email AS accounting_email_76, o2_.created_at AS created_at_77, o2_.updated_at AS updated_at_78, c3_.id AS id_79, c3_.company_name AS company_name_80, c3_.address_line1 AS address_line1_81, c3_.address_line2 AS address_line2_82, c3_.address_line3 AS address_line3_83, c3_.chartering_email AS chartering_email_84, c3_.operations_email AS operations_email_85, c3_.accounting_email AS accounting_email_86, c3_.observations AS observations_87, c3_.created_at AS created_at_88, c3_.updated_at AS updated_at_89, u4_.id AS id_90, u4_.name AS name_91, u4_.email AS email_92, u4_.roles AS roles_93, u4_.password AS password_94, u4_.confirmation_token AS confirmation_token_95, u4_.desk AS desk_96, u4_.created_at AS created_at_97, u4_.updated_at AS updated_at_98, u5_.id AS id_99, u5_.name AS name_100, u5_.email AS email_101, u5_.roles AS roles_102, u5_.password AS password_103, u5_.confirmation_token AS confirmation_token_104, u5_.desk AS desk_105, u5_.created_at AS created_at_106, u5_.updated_at AS updated_at_107, a6_.id AS id_108, a6_.additional_cost AS additional_cost_109, a6_.additional_cost_currency AS additional_cost_currency_110, a6_.additional_type AS additional_type_111, a6_.description AS description_112, a6_.created_at AS created_at_113, a6_.updated_at AS updated_at_114, m7_.id AS id_115, m7_.name AS name_116, m7_.content_size AS content_size_117, m7_.encoding_format AS encoding_format_118, m7_.upload_date AS upload_date_119, m7_.genre AS genre_120, m7_.file_path AS file_path_121, m7_.created_at AS created_at_122, m7_.updated_at AS updated_at_123, p8_.id AS id_124, p8_.port_call_type AS port_call_type_125, p8_.arrival AS arrival_126, p8_.berthing AS berthing_127, p8_.departure AS departure_128, p8_.created_at AS created_at_129, p8_.updated_at AS updated_at_130, r9_.id AS id_131, r9_.created_at AS created_at_132, r9_.updated_at AS updated_at_133, r10_.id AS id_134, r10_.category AS category_135, r10_.subcategory AS subcategory_136, r10_.created_at AS created_at_137, r10_.updated_at AS updated_at_138, c11_.id AS id_139, c11_.quantity_m3 AS quantity_m3_140, c11_.quantity_mt AS quantity_mt_141, c11_.created_at AS created_at_142, c11_.updated_at AS updated_at_143, p12_.id AS id_144, p12_.amount AS amount_145, p12_.amount_currency AS amount_currency_146, p12_.due_date AS due_date_147, p12_.description AS description_148, p12_.status AS status_149, p12_.created_at AS created_at_150, p12_.updated_at AS updated_at_151, h13_.id AS id_152, h13_.hire_begin AS hire_begin_153, h13_.hire_end AS hire_end_154, h13_.fuel_type AS fuel_type_155, h13_.fuel_type2 AS fuel_type2_156, h13_.fuel_type3 AS fuel_type3_157, h13_.price AS price_158, h13_.price2 AS price2_159, h13_.price3 AS price3_160, h13_.price_currency AS price_currency_161, h13_.price_currency2 AS price_currency2_162, h13_.price_currency3 AS price_currency3_163, h13_.multi_fuel AS multi_fuel_164, h13_.off_hire_begin AS off_hire_begin_165, h13_.off_hire_end AS off_hire_end_166, h13_.off_hire_cost AS off_hire_cost_167, h13_.off_hire_cost_currency AS off_hire_cost_currency_168, h13_.address_commission AS address_commission_169, h13_.extra_costs AS extra_costs_170, h13_.extra_costs_currency AS extra_costs_currency_171, h13_.extra_costs_description AS extra_costs_description_172, h13_.total_invoice AS total_invoice_173, h13_.total_invoice_currency AS total_invoice_currency_174, h13_.invoice_status AS invoice_status_175, h13_.bunker AS bunker_176, h13_.final_hire AS final_hire_177, h13_.created_at AS created_at_178, h13_.updated_at AS updated_at_179, c14_.id AS id_180, c14_.contract_number AS contract_number_181, c14_.contract_date AS contract_date_182, c14_.contract_type AS contract_type_183, c14_.laycan_start AS laycan_start_184, c14_.laycan_end AS laycan_end_185, c14_.status AS status_186, c14_.freight_cost AS freight_cost_187, c14_.freight_cost_currency AS freight_cost_currency_188, c14_.freight_type AS freight_type_189, c14_.demurrage_per_day AS demurrage_per_day_190, c14_.demurrage_per_day_currency AS demurrage_per_day_currency_191, c14_.address_commission AS address_commission_192, c14_.brokerage_commission AS brokerage_commission_193, c14_.liftings_min AS liftings_min_194, c14_.liftings_max AS liftings_max_195, c14_.checklist_notes AS checklist_notes_196, c14_.demurrage_status AS demurrage_status_197, c14_.demurrage_time_bar AS demurrage_time_bar_198, c14_.demurrage_payment_date AS demurrage_payment_date_199, c14_.final_demurrage_cost AS final_demurrage_cost_200, c14_.final_demurrage_cost_currency AS final_demurrage_cost_currency_201, c14_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202, c14_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203, c14_.eta_arrival AS eta_arrival_204, c14_.delivered_arrival AS delivered_arrival_205, c14_.delivery_aprox_notice1 AS delivery_aprox_notice1_206, c14_.delivery_aprox_notice2 AS delivery_aprox_notice2_207, c14_.delivery_aprox_notice3 AS delivery_aprox_notice3_208, c14_.delivery_aprox_notice4 AS delivery_aprox_notice4_209, c14_.delivery_aprox_notice5 AS delivery_aprox_notice5_210, c14_.delivery_aprox_notice6 AS delivery_aprox_notice6_211, c14_.delivery_aprox_notice7 AS delivery_aprox_notice7_212, c14_.delivery_firm_notice1 AS delivery_firm_notice1_213, c14_.delivery_firm_notice2 AS delivery_firm_notice2_214, c14_.delivery_firm_notice3 AS delivery_firm_notice3_215, c14_.delivery_firm_notice4 AS delivery_firm_notice4_216, c14_.delivery_firm_notice5 AS delivery_firm_notice5_217, c14_.delivery_firm_notice6 AS delivery_firm_notice6_218, c14_.delivery_firm_notice7 AS delivery_firm_notice7_219, c14_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220, c14_.ship_delivered AS ship_delivered_221, c14_.hire_per_day AS hire_per_day_222, c14_.hire_per_day_currency AS hire_per_day_currency_223, c14_.period AS period_224, c14_.report_description AS report_description_225, c14_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226, c14_.vessel_was_substituted AS vessel_was_substituted_227, c14_.addendum_issued AS addendum_issued_228, c14_.addendum_description AS addendum_description_229, c14_.created_at AS created_at_230, c14_.updated_at AS updated_at_231, c15_.id AS id_232, c15_.checklist_name AS checklist_name_233, c15_.notes AS notes_234, c15_.created_at AS created_at_235, c15_.updated_at AS updated_at_236, t16_.id AS id_237, t16_.task_name AS task_name_238, t16_.description AS description_239, t16_.task_index AS task_index_240, t16_.created_at AS created_at_241, t16_.updated_at AS updated_at_242, p17_.id AS id_243, p17_.port_name AS port_name_244, p17_.geographic_location AS geographic_location_245, p17_.cost_information_source AS cost_information_source_246, p17_.state AS state_247, p17_.country AS country_248, p17_.created_at AS created_at_249, p17_.updated_at AS updated_at_250, p18_.id AS id_251, p18_.port_name AS port_name_252, p18_.geographic_location AS geographic_location_253, p18_.cost_information_source AS cost_information_source_254, p18_.state AS state_255, p18_.country AS country_256, p18_.created_at AS created_at_257, p18_.updated_at AS updated_at_258, d19_.id AS id_259, d19_.notice_number AS notice_number_260, d19_.notice_type AS notice_type_261, d19_.notice_date AS notice_date_262, d19_.status AS status_263, d19_.created_at AS created_at_264, d19_.updated_at AS updated_at_265, c20_.id AS id_266, c20_.contract_number AS contract_number_267, c20_.contract_date AS contract_date_268, c20_.contract_type AS contract_type_269, c20_.laycan_start AS laycan_start_270, c20_.laycan_end AS laycan_end_271, c20_.status AS status_272, c20_.freight_cost AS freight_cost_273, c20_.freight_cost_currency AS freight_cost_currency_274, c20_.freight_type AS freight_type_275, c20_.demurrage_per_day AS demurrage_per_day_276, c20_.demurrage_per_day_currency AS demurrage_per_day_currency_277, c20_.address_commission AS address_commission_278, c20_.brokerage_commission AS brokerage_commission_279, c20_.liftings_min AS liftings_min_280, c20_.liftings_max AS liftings_max_281, c20_.checklist_notes AS checklist_notes_282, c20_.demurrage_status AS demurrage_status_283, c20_.demurrage_time_bar AS demurrage_time_bar_284, c20_.demurrage_payment_date AS demurrage_payment_date_285, c20_.final_demurrage_cost AS final_demurrage_cost_286, c20_.final_demurrage_cost_currency AS final_demurrage_cost_currency_287, c20_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288, c20_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289, c20_.eta_arrival AS eta_arrival_290, c20_.delivered_arrival AS delivered_arrival_291, c20_.delivery_aprox_notice1 AS delivery_aprox_notice1_292, c20_.delivery_aprox_notice2 AS delivery_aprox_notice2_293, c20_.delivery_aprox_notice3 AS delivery_aprox_notice3_294, c20_.delivery_aprox_notice4 AS delivery_aprox_notice4_295, c20_.delivery_aprox_notice5 AS delivery_aprox_notice5_296, c20_.delivery_aprox_notice6 AS delivery_aprox_notice6_297, c20_.delivery_aprox_notice7 AS delivery_aprox_notice7_298, c20_.delivery_firm_notice1 AS delivery_firm_notice1_299, c20_.delivery_firm_notice2 AS delivery_firm_notice2_300, c20_.delivery_firm_notice3 AS delivery_firm_notice3_301, c20_.delivery_firm_notice4 AS delivery_firm_notice4_302, c20_.delivery_firm_notice5 AS delivery_firm_notice5_303, c20_.delivery_firm_notice6 AS delivery_firm_notice6_304, c20_.delivery_firm_notice7 AS delivery_firm_notice7_305, c20_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306, c20_.ship_delivered AS ship_delivered_307, c20_.hire_per_day AS hire_per_day_308, c20_.hire_per_day_currency AS hire_per_day_currency_309, c20_.period AS period_310, c20_.report_description AS report_description_311, c20_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312, c20_.vessel_was_substituted AS vessel_was_substituted_313, c20_.addendum_issued AS addendum_issued_314, c20_.addendum_description AS addendum_description_315, c20_.created_at AS created_at_316, c20_.updated_at AS updated_at_317, c0_.vessel_id AS vessel_id_318, c0_.owner_id AS owner_id_319, c0_.charterer_id AS charterer_id_320, c0_.broker_id AS broker_id_321, c0_.operator_id AS operator_id_322, c0_.checklist_id AS checklist_id_323, c0_.delivery_port1_id AS delivery_port1_id_324, c0_.delivery_port2_id AS delivery_port2_id_325, c0_.contract_coa_id AS contract_coa_id_326, v1_.owner_id AS owner_id_327, o2_.primary_contact_id AS primary_contact_id_328, u4_.avatar_id AS avatar_id_329, u5_.avatar_id AS avatar_id_330, a6_.contract_id AS contract_id_331, m7_.contract_id AS contract_id_332, p8_.port_id AS port_id_333, p8_.contract_id AS contract_id_334, r9_.port_id AS port_id_335, r9_.contract_id AS contract_id_336, r10_.contract_id AS contract_id_337, c11_.cargo_id AS cargo_id_338, c11_.contract_id AS contract_id_339, p12_.contract_id AS contract_id_340, h13_.contract_id AS contract_id_341, c14_.vessel_id AS vessel_id_342, c14_.owner_id AS owner_id_343, c14_.charterer_id AS charterer_id_344, c14_.broker_id AS broker_id_345, c14_.operator_id AS operator_id_346, c14_.checklist_id AS checklist_id_347, c14_.delivery_port1_id AS delivery_port1_id_348, c14_.delivery_port2_id AS delivery_port2_id_349, c14_.contract_coa_id AS contract_coa_id_350, t16_.checklist_id AS checklist_id_351, d19_.contract_id AS contract_id_352, c20_.vessel_id AS vessel_id_353, c20_.owner_id AS owner_id_354, c20_.charterer_id AS charterer_id_355, c20_.broker_id AS broker_id_356, c20_.operator_id AS operator_id_357, c20_.checklist_id AS checklist_id_358, c20_.delivery_port1_id AS delivery_port1_id_359, c20_.delivery_port2_id AS delivery_port2_id_360, c20_.contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_.vessel_id = v1_.id LEFT JOIN owner o2_ ON c0_.owner_id = o2_.id LEFT JOIN charterer c3_ ON c0_.charterer_id = c3_.id LEFT JOIN user u4_ ON c0_.broker_id = u4_.id LEFT JOIN user u5_ ON c0_.operator_id = u5_.id LEFT JOIN additional_cost a6_ ON c0_.id = a6_.contract_id LEFT JOIN media m7_ ON c0_.id = m7_.contract_id LEFT JOIN port_call p8_ ON c0_.id = p8_.contract_id LEFT JOIN reported_port r9_ ON c0_.id = r9_.contract_id LEFT JOIN reported_incident r10_ ON c0_.id = r10_.contract_id LEFT JOIN contract_cargo c11_ ON c0_.id = c11_.contract_id LEFT JOIN payment p12_ ON c0_.id = p12_.contract_id LEFT JOIN hire h13_ ON c0_.id = h13_.contract_id LEFT JOIN contract c14_ ON c0_.id = c14_.contract_coa_id LEFT JOIN checklist c15_ ON c0_.checklist_id = c15_.id LEFT JOIN contract_task c21_ ON c0_.id = c21_.contract_id LEFT JOIN task t16_ ON t16_.id = c21_.task_id LEFT JOIN port p17_ ON c0_.delivery_port1_id = p17_.id LEFT JOIN port p18_ ON c0_.delivery_port2_id = p18_.id LEFT JOIN delivery_notice d19_ ON c0_.id = d19_.contract_id LEFT JOIN contract c20_ ON c0_.contract_coa_id = c20_.id WHERE c0_.id = ? Parameters: [`"d3d8529c-3f44-4c07-8eb6-e251148b4be8"`] View formatted query View runnable query Explain query 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, v1_.id AS id_52, v1_.vessel_name AS vessel_name_53, v1_.imo_number AS imo_number_54, v1_.vessel_type AS vessel_type_55, v1_.tanker_type AS tanker_type_56, v1_.bulker_type AS bulker_type_57, v1_.tank_coating AS tank_coating_58, v1_.dwt AS dwt_59, v1_.year_built AS year_built_60, v1_.observations AS observations_61, v1_.box_shape AS box_shape_62, v1_.open_hatch AS open_hatch_63, v1_.nitrogen_generator AS nitrogen_generator_64, v1_.imo_class AS imo_class_65, v1_.created_at AS created_at_66, v1_.updated_at AS updated_at_67, o2_.id AS id_68, o2_.company_name AS company_name_69, o2_.detailed_company_name AS detailed_company_name_70, o2_.address_line1 AS address_line1_71, o2_.address_line2 AS address_line2_72, o2_.address_line3 AS address_line3_73, o2_.chartering_email AS chartering_email_74, o2_.operations_email AS operations_email_75, o2_.accounting_email AS accounting_email_76, o2_.created_at AS created_at_77, o2_.updated_at AS updated_at_78, c3_.id AS id_79, c3_.company_name AS company_name_80, c3_.address_line1 AS address_line1_81, c3_.address_line2 AS address_line2_82, c3_.address_line3 AS address_line3_83, c3_.chartering_email AS chartering_email_84, c3_.operations_email AS operations_email_85, c3_.accounting_email AS accounting_email_86, c3_.observations AS observations_87, c3_.created_at AS created_at_88, c3_.updated_at AS updated_at_89, u4_.id AS id_90, u4_.name AS name_91, u4_.email AS email_92, u4_.roles AS roles_93, u4_.password AS password_94, u4_.confirmation_token AS confirmation_token_95, u4_.desk AS desk_96, u4_.created_at AS created_at_97, u4_.updated_at AS updated_at_98, u5_.id AS id_99, u5_.name AS name_100, u5_.email AS email_101, u5_.roles AS roles_102, u5_.password AS password_103, u5_.confirmation_token AS confirmation_token_104, u5_.desk AS desk_105, u5_.created_at AS created_at_106, u5_.updated_at AS updated_at_107, a6_.id AS id_108, a6_.additional_cost AS additional_cost_109, a6_.additional_cost_currency AS additional_cost_currency_110, a6_.additional_type AS additional_type_111, a6_.description AS description_112, a6_.created_at AS created_at_113, a6_.updated_at AS updated_at_114, m7_.id AS id_115, m7_.name AS name_116, m7_.content_size AS content_size_117, m7_.encoding_format AS encoding_format_118, m7_.upload_date AS upload_date_119, m7_.genre AS genre_120, m7_.file_path AS file_path_121, m7_.created_at AS created_at_122, m7_.updated_at AS updated_at_123, p8_.id AS id_124, p8_.port_call_type AS port_call_type_125, p8_.arrival AS arrival_126, p8_.berthing AS berthing_127, p8_.departure AS departure_128, p8_.created_at AS created_at_129, p8_.updated_at AS updated_at_130, r9_.id AS id_131, r9_.created_at AS created_at_132, r9_.updated_at AS updated_at_133, r10_.id AS id_134, r10_.category AS category_135, r10_.subcategory AS subcategory_136, r10_.created_at AS created_at_137, r10_.updated_at AS updated_at_138, c11_.id AS id_139, c11_.quantity_m3 AS quantity_m3_140, c11_.quantity_mt AS quantity_mt_141, c11_.created_at AS created_at_142, c11_.updated_at AS updated_at_143, p12_.id AS id_144, p12_.amount AS amount_145, p12_.amount_currency AS amount_currency_146, p12_.due_date AS due_date_147, p12_.description AS description_148, p12_.status AS status_149, p12_.created_at AS created_at_150, p12_.updated_at AS updated_at_151, h13_.id AS id_152, h13_.hire_begin AS hire_begin_153, h13_.hire_end AS hire_end_154, h13_.fuel_type AS fuel_type_155, h13_.fuel_type2 AS fuel_type2_156, h13_.fuel_type3 AS fuel_type3_157, h13_.price AS price_158, h13_.price2 AS price2_159, h13_.price3 AS price3_160, h13_.price_currency AS price_currency_161, h13_.price_currency2 AS price_currency2_162, h13_.price_currency3 AS price_currency3_163, h13_.multi_fuel AS multi_fuel_164, h13_.off_hire_begin AS off_hire_begin_165, h13_.off_hire_end AS off_hire_end_166, h13_.off_hire_cost AS off_hire_cost_167, h13_.off_hire_cost_currency AS off_hire_cost_currency_168, h13_.address_commission AS address_commission_169, h13_.extra_costs AS extra_costs_170, h13_.extra_costs_currency AS extra_costs_currency_171, h13_.extra_costs_description AS extra_costs_description_172, h13_.total_invoice AS total_invoice_173, h13_.total_invoice_currency AS total_invoice_currency_174, h13_.invoice_status AS invoice_status_175, h13_.bunker AS bunker_176, h13_.final_hire AS final_hire_177, h13_.created_at AS created_at_178, h13_.updated_at AS updated_at_179, c14_.id AS id_180, c14_.contract_number AS contract_number_181, c14_.contract_date AS contract_date_182, c14_.contract_type AS contract_type_183, c14_.laycan_start AS laycan_start_184, c14_.laycan_end AS laycan_end_185, c14_.status AS status_186, c14_.freight_cost AS freight_cost_187, c14_.freight_cost_currency AS freight_cost_currency_188, c14_.freight_type AS freight_type_189, c14_.demurrage_per_day AS demurrage_per_day_190, c14_.demurrage_per_day_currency AS demurrage_per_day_currency_191, c14_.address_commission AS address_commission_192, c14_.brokerage_commission AS brokerage_commission_193, c14_.liftings_min AS liftings_min_194, c14_.liftings_max AS liftings_max_195, c14_.checklist_notes AS checklist_notes_196, c14_.demurrage_status AS demurrage_status_197, c14_.demurrage_time_bar AS demurrage_time_bar_198, c14_.demurrage_payment_date AS demurrage_payment_date_199, c14_.final_demurrage_cost AS final_demurrage_cost_200, c14_.final_demurrage_cost_currency AS final_demurrage_cost_currency_201, c14_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202, c14_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203, c14_.eta_arrival AS eta_arrival_204, c14_.delivered_arrival AS delivered_arrival_205, c14_.delivery_aprox_notice1 AS delivery_aprox_notice1_206, c14_.delivery_aprox_notice2 AS delivery_aprox_notice2_207, c14_.delivery_aprox_notice3 AS delivery_aprox_notice3_208, c14_.delivery_aprox_notice4 AS delivery_aprox_notice4_209, c14_.delivery_aprox_notice5 AS delivery_aprox_notice5_210, c14_.delivery_aprox_notice6 AS delivery_aprox_notice6_211, c14_.delivery_aprox_notice7 AS delivery_aprox_notice7_212, c14_.delivery_firm_notice1 AS delivery_firm_notice1_213, c14_.delivery_firm_notice2 AS delivery_firm_notice2_214, c14_.delivery_firm_notice3 AS delivery_firm_notice3_215, c14_.delivery_firm_notice4 AS delivery_firm_notice4_216, c14_.delivery_firm_notice5 AS delivery_firm_notice5_217, c14_.delivery_firm_notice6 AS delivery_firm_notice6_218, c14_.delivery_firm_notice7 AS delivery_firm_notice7_219, c14_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220, c14_.ship_delivered AS ship_delivered_221, c14_.hire_per_day AS hire_per_day_222, c14_.hire_per_day_currency AS hire_per_day_currency_223, c14_.period AS period_224, c14_.report_description AS report_description_225, c14_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226, c14_.vessel_was_substituted AS vessel_was_substituted_227, c14_.addendum_issued AS addendum_issued_228, c14_.addendum_description AS addendum_description_229, c14_.created_at AS created_at_230, c14_.updated_at AS updated_at_231, c15_.id AS id_232, c15_.checklist_name AS checklist_name_233, c15_.notes AS notes_234, c15_.created_at AS created_at_235, c15_.updated_at AS updated_at_236, t16_.id AS id_237, t16_.task_name AS task_name_238, t16_.description AS description_239, t16_.task_index AS task_index_240, t16_.created_at AS created_at_241, t16_.updated_at AS updated_at_242, p17_.id AS id_243, p17_.port_name AS port_name_244, p17_.geographic_location AS geographic_location_245, p17_.cost_information_source AS cost_information_source_246, p17_.state AS state_247, p17_.country AS country_248, p17_.created_at AS created_at_249, p17_.updated_at AS updated_at_250, p18_.id AS id_251, p18_.port_name AS port_name_252, p18_.geographic_location AS geographic_location_253, p18_.cost_information_source AS cost_information_source_254, p18_.state AS state_255, p18_.country AS country_256, p18_.created_at AS created_at_257, p18_.updated_at AS updated_at_258, d19_.id AS id_259, d19_.notice_number AS notice_number_260, d19_.notice_type AS notice_type_261, d19_.notice_date AS notice_date_262, d19_.status AS status_263, d19_.created_at AS created_at_264, d19_.updated_at AS updated_at_265, c20_.id AS id_266, c20_.contract_number AS contract_number_267, c20_.contract_date AS contract_date_268, c20_.contract_type AS contract_type_269, c20_.laycan_start AS laycan_start_270, c20_.laycan_end AS laycan_end_271, c20_.status AS status_272, c20_.freight_cost AS freight_cost_273, c20_.freight_cost_currency AS freight_cost_currency_274, c20_.freight_type AS freight_type_275, c20_.demurrage_per_day AS demurrage_per_day_276, c20_.demurrage_per_day_currency AS demurrage_per_day_currency_277, c20_.address_commission AS address_commission_278, c20_.brokerage_commission AS brokerage_commission_279, c20_.liftings_min AS liftings_min_280, c20_.liftings_max AS liftings_max_281, c20_.checklist_notes AS checklist_notes_282, c20_.demurrage_status AS demurrage_status_283, c20_.demurrage_time_bar AS demurrage_time_bar_284, c20_.demurrage_payment_date AS demurrage_payment_date_285, c20_.final_demurrage_cost AS final_demurrage_cost_286, c20_.final_demurrage_cost_currency AS final_demurrage_cost_currency_287, c20_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288, c20_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289, c20_.eta_arrival AS eta_arrival_290, c20_.delivered_arrival AS delivered_arrival_291, c20_.delivery_aprox_notice1 AS delivery_aprox_notice1_292, c20_.delivery_aprox_notice2 AS delivery_aprox_notice2_293, c20_.delivery_aprox_notice3 AS delivery_aprox_notice3_294, c20_.delivery_aprox_notice4 AS delivery_aprox_notice4_295, c20_.delivery_aprox_notice5 AS delivery_aprox_notice5_296, c20_.delivery_aprox_notice6 AS delivery_aprox_notice6_297, c20_.delivery_aprox_notice7 AS delivery_aprox_notice7_298, c20_.delivery_firm_notice1 AS delivery_firm_notice1_299, c20_.delivery_firm_notice2 AS delivery_firm_notice2_300, c20_.delivery_firm_notice3 AS delivery_firm_notice3_301, c20_.delivery_firm_notice4 AS delivery_firm_notice4_302, c20_.delivery_firm_notice5 AS delivery_firm_notice5_303, c20_.delivery_firm_notice6 AS delivery_firm_notice6_304, c20_.delivery_firm_notice7 AS delivery_firm_notice7_305, c20_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306, c20_.ship_delivered AS ship_delivered_307, c20_.hire_per_day AS hire_per_day_308, c20_.hire_per_day_currency AS hire_per_day_currency_309, c20_.period AS period_310, c20_.report_description AS report_description_311, c20_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312, c20_.vessel_was_substituted AS vessel_was_substituted_313, c20_.addendum_issued AS addendum_issued_314, c20_.addendum_description AS addendum_description_315, c20_.created_at AS created_at_316, c20_.updated_at AS updated_at_317, c0_.vessel_id AS vessel_id_318, c0_.owner_id AS owner_id_319, c0_.charterer_id AS charterer_id_320, c0_.broker_id AS broker_id_321, c0_.operator_id AS operator_id_322, c0_.checklist_id AS checklist_id_323, c0_.delivery_port1_id AS delivery_port1_id_324, c0_.delivery_port2_id AS delivery_port2_id_325, c0_.contract_coa_id AS contract_coa_id_326, v1_.owner_id AS owner_id_327, o2_.primary_contact_id AS primary_contact_id_328, u4_.avatar_id AS avatar_id_329, u5_.avatar_id AS avatar_id_330, a6_.contract_id AS contract_id_331, m7_.contract_id AS contract_id_332, p8_.port_id AS port_id_333, p8_.contract_id AS contract_id_334, r9_.port_id AS port_id_335, r9_.contract_id AS contract_id_336, r10_.contract_id AS contract_id_337, c11_.cargo_id AS cargo_id_338, c11_.contract_id AS contract_id_339, p12_.contract_id AS contract_id_340, h13_.contract_id AS contract_id_341, c14_.vessel_id AS vessel_id_342, c14_.owner_id AS owner_id_343, c14_.charterer_id AS charterer_id_344, c14_.broker_id AS broker_id_345, c14_.operator_id AS operator_id_346, c14_.checklist_id AS checklist_id_347, c14_.delivery_port1_id AS delivery_port1_id_348, c14_.delivery_port2_id AS delivery_port2_id_349, c14_.contract_coa_id AS contract_coa_id_350, t16_.checklist_id AS checklist_id_351, d19_.contract_id AS contract_id_352, c20_.vessel_id AS vessel_id_353, c20_.owner_id AS owner_id_354, c20_.charterer_id AS charterer_id_355, c20_.broker_id AS broker_id_356, c20_.operator_id AS operator_id_357, c20_.checklist_id AS checklist_id_358, c20_.delivery_port1_id AS delivery_port1_id_359, c20_.delivery_port2_id AS delivery_port2_id_360, c20_.contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_.vessel_id = v1_.id LEFT JOIN owner o2_ ON c0_.owner_id = o2_.id LEFT JOIN charterer c3_ ON c0_.charterer_id = c3_.id LEFT JOIN user u4_ ON c0_.broker_id = u4_.id LEFT JOIN user u5_ ON c0_.operator_id = u5_.id LEFT JOIN additional_cost a6_ ON c0_.id = a6_.contract_id LEFT JOIN media m7_ ON c0_.id = m7_.contract_id LEFT JOIN port_call p8_ ON c0_.id = p8_.contract_id LEFT JOIN reported_port r9_ ON c0_.id = r9_.contract_id LEFT JOIN reported_incident r10_ ON c0_.id = r10_.contract_id LEFT JOIN contract_cargo c11_ ON c0_.id = c11_.contract_id LEFT JOIN payment p12_ ON c0_.id = p12_.contract_id LEFT JOIN hire h13_ ON c0_.id = h13_.contract_id LEFT JOIN contract c14_ ON c0_.id = c14_.contract_coa_id LEFT JOIN checklist c15_ ON c0_.checklist_id = c15_.id LEFT JOIN contract_task c21_ ON c0_.id = c21_.contract_id LEFT JOIN task t16_ ON t16_.id = c21_.task_id LEFT JOIN port p17_ ON c0_.delivery_port1_id = p17_.id LEFT JOIN port p18_ ON c0_.delivery_port2_id = p18_.id LEFT JOIN delivery_notice d19_ ON c0_.id = d19_.contract_id LEFT JOIN contract c20_ ON c0_.contract_coa_id = c20_.id WHERE c0_.id = ? 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, v1_.id AS id_52, v1_.vessel_name AS vessel_name_53, v1_.imo_number AS imo_number_54, v1_.vessel_type AS vessel_type_55, v1_.tanker_type AS tanker_type_56, v1_.bulker_type AS bulker_type_57, v1_.tank_coating AS tank_coating_58, v1_.dwt AS dwt_59, v1_.year_built AS year_built_60, v1_.observations AS observations_61, v1_.box_shape AS box_shape_62, v1_.open_hatch AS open_hatch_63, v1_.nitrogen_generator AS nitrogen_generator_64, v1_.imo_class AS imo_class_65, v1_.created_at AS created_at_66, v1_.updated_at AS updated_at_67, o2_.id AS id_68, o2_.company_name AS company_name_69, o2_.detailed_company_name AS detailed_company_name_70, o2_.address_line1 AS address_line1_71, o2_.address_line2 AS address_line2_72, o2_.address_line3 AS address_line3_73, o2_.chartering_email AS chartering_email_74, o2_.operations_email AS operations_email_75, o2_.accounting_email AS accounting_email_76, o2_.created_at AS created_at_77, o2_.updated_at AS updated_at_78, c3_.id AS id_79, c3_.company_name AS company_name_80, c3_.address_line1 AS address_line1_81, c3_.address_line2 AS address_line2_82, c3_.address_line3 AS address_line3_83, c3_.chartering_email AS chartering_email_84, c3_.operations_email AS operations_email_85, c3_.accounting_email AS accounting_email_86, c3_.observations AS observations_87, c3_.created_at AS created_at_88, c3_.updated_at AS updated_at_89, u4_.id AS id_90, u4_.name AS name_91, u4_.email AS email_92, u4_.roles AS roles_93, u4_.password AS password_94, u4_.confirmation_token AS confirmation_token_95, u4_.desk AS desk_96, u4_.created_at AS created_at_97, u4_.updated_at AS updated_at_98, u5_.id AS id_99, u5_.name AS name_100, u5_.email AS email_101, u5_.roles AS roles_102, u5_.password AS password_103, u5_.confirmation_token AS confirmation_token_104, u5_.desk AS desk_105, u5_.created_at AS created_at_106, u5_.updated_at AS updated_at_107, a6_.id AS id_108, a6_.additional_cost AS additional_cost_109, a6_.additional_cost_currency AS additional_cost_currency_110, a6_.additional_type AS additional_type_111, a6_.description AS description_112, a6_.created_at AS created_at_113, a6_.updated_at AS updated_at_114, m7_.id AS id_115, m7_.name AS name_116, m7_.content_size AS content_size_117, m7_.encoding_format AS encoding_format_118, m7_.upload_date AS upload_date_119, m7_.genre AS genre_120, m7_.file_path AS file_path_121, m7_.created_at AS created_at_122, m7_.updated_at AS updated_at_123, p8_.id AS id_124, p8_.port_call_type AS port_call_type_125, p8_.arrival AS arrival_126, p8_.berthing AS berthing_127, p8_.departure AS departure_128, p8_.created_at AS created_at_129, p8_.updated_at AS updated_at_130, r9_.id AS id_131, r9_.created_at AS created_at_132, r9_.updated_at AS updated_at_133, r10_.id AS id_134, r10_.category AS category_135, r10_.subcategory AS subcategory_136, r10_.created_at AS created_at_137, r10_.updated_at AS updated_at_138, c11_.id AS id_139, c11_.quantity_m3 AS quantity_m3_140, c11_.quantity_mt AS quantity_mt_141, c11_.created_at AS created_at_142, c11_.updated_at AS updated_at_143, p12_.id AS id_144, p12_.amount AS amount_145, p12_.amount_currency AS amount_currency_146, p12_.due_date AS due_date_147, p12_.description AS description_148, p12_.status AS status_149, p12_.created_at AS created_at_150, p12_.updated_at AS updated_at_151, h13_.id AS id_152, h13_.hire_begin AS hire_begin_153, h13_.hire_end AS hire_end_154, h13_.fuel_type AS fuel_type_155, h13_.fuel_type2 AS fuel_type2_156, h13_.fuel_type3 AS fuel_type3_157, h13_.price AS price_158, h13_.price2 AS price2_159, h13_.price3 AS price3_160, h13_.price_currency AS price_currency_161, h13_.price_currency2 AS price_currency2_162, h13_.price_currency3 AS price_currency3_163, h13_.multi_fuel AS multi_fuel_164, h13_.off_hire_begin AS off_hire_begin_165, h13_.off_hire_end AS off_hire_end_166, h13_.off_hire_cost AS off_hire_cost_167, h13_.off_hire_cost_currency AS off_hire_cost_currency_168, h13_.address_commission AS address_commission_169, h13_.extra_costs AS extra_costs_170, h13_.extra_costs_currency AS extra_costs_currency_171, h13_.extra_costs_description AS extra_costs_description_172, h13_.total_invoice AS total_invoice_173, h13_.total_invoice_currency AS total_invoice_currency_174, h13_.invoice_status AS invoice_status_175, h13_.bunker AS bunker_176, h13_.final_hire AS final_hire_177, h13_.created_at AS created_at_178, h13_.updated_at AS updated_at_179, c14_.id AS id_180, c14_.contract_number AS contract_number_181, c14_.contract_date AS contract_date_182, c14_.contract_type AS contract_type_183, c14_.laycan_start AS laycan_start_184, c14_.laycan_end AS laycan_end_185, c14_.status AS status_186, c14_.freight_cost AS freight_cost_187, c14_.freight_cost_currency AS freight_cost_currency_188, c14_.freight_type AS freight_type_189, c14_.demurrage_per_day AS demurrage_per_day_190, c14_.demurrage_per_day_currency AS demurrage_per_day_currency_191, c14_.address_commission AS address_commission_192, c14_.brokerage_commission AS brokerage_commission_193, c14_.liftings_min AS liftings_min_194, c14_.liftings_max AS liftings_max_195, c14_.checklist_notes AS checklist_notes_196, c14_.demurrage_status AS demurrage_status_197, c14_.demurrage_time_bar AS demurrage_time_bar_198, c14_.demurrage_payment_date AS demurrage_payment_date_199, c14_.final_demurrage_cost AS final_demurrage_cost_200, c14_.final_demurrage_cost_currency AS final_demurrage_cost_currency_201, c14_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202, c14_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203, c14_.eta_arrival AS eta_arrival_204, c14_.delivered_arrival AS delivered_arrival_205, c14_.delivery_aprox_notice1 AS delivery_aprox_notice1_206, c14_.delivery_aprox_notice2 AS delivery_aprox_notice2_207, c14_.delivery_aprox_notice3 AS delivery_aprox_notice3_208, c14_.delivery_aprox_notice4 AS delivery_aprox_notice4_209, c14_.delivery_aprox_notice5 AS delivery_aprox_notice5_210, c14_.delivery_aprox_notice6 AS delivery_aprox_notice6_211, c14_.delivery_aprox_notice7 AS delivery_aprox_notice7_212, c14_.delivery_firm_notice1 AS delivery_firm_notice1_213, c14_.delivery_firm_notice2 AS delivery_firm_notice2_214, c14_.delivery_firm_notice3 AS delivery_firm_notice3_215, c14_.delivery_firm_notice4 AS delivery_firm_notice4_216, c14_.delivery_firm_notice5 AS delivery_firm_notice5_217, c14_.delivery_firm_notice6 AS delivery_firm_notice6_218, c14_.delivery_firm_notice7 AS delivery_firm_notice7_219, c14_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220, c14_.ship_delivered AS ship_delivered_221, c14_.hire_per_day AS hire_per_day_222, c14_.hire_per_day_currency AS hire_per_day_currency_223, c14_.period AS period_224, c14_.report_description AS report_description_225, c14_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226, c14_.vessel_was_substituted AS vessel_was_substituted_227, c14_.addendum_issued AS addendum_issued_228, c14_.addendum_description AS addendum_description_229, c14_.created_at AS created_at_230, c14_.updated_at AS updated_at_231, c15_.id AS id_232, c15_.checklist_name AS checklist_name_233, c15_.notes AS notes_234, c15_.created_at AS created_at_235, c15_.updated_at AS updated_at_236, t16_.id AS id_237, t16_.task_name AS task_name_238, t16_.description AS description_239, t16_.task_index AS task_index_240, t16_.created_at AS created_at_241, t16_.updated_at AS updated_at_242, p17_.id AS id_243, p17_.port_name AS port_name_244, p17_.geographic_location AS geographic_location_245, p17_.cost_information_source AS cost_information_source_246, p17_.state AS state_247, p17_.country AS country_248, p17_.created_at AS created_at_249, p17_.updated_at AS updated_at_250, p18_.id AS id_251, p18_.port_name AS port_name_252, p18_.geographic_location AS geographic_location_253, p18_.cost_information_source AS cost_information_source_254, p18_.state AS state_255, p18_.country AS country_256, p18_.created_at AS created_at_257, p18_.updated_at AS updated_at_258, d19_.id AS id_259, d19_.notice_number AS notice_number_260, d19_.notice_type AS notice_type_261, d19_.notice_date AS notice_date_262, d19_.status AS status_263, d19_.created_at AS created_at_264, d19_.updated_at AS updated_at_265, c20_.id AS id_266, c20_.contract_number AS contract_number_267, c20_.contract_date AS contract_date_268, c20_.contract_type AS contract_type_269, c20_.laycan_start AS laycan_start_270, c20_.laycan_end AS laycan_end_271, c20_.status AS status_272, c20_.freight_cost AS freight_cost_273, c20_.freight_cost_currency AS freight_cost_currency_274, c20_.freight_type AS freight_type_275, c20_.demurrage_per_day AS demurrage_per_day_276, c20_.demurrage_per_day_currency AS demurrage_per_day_currency_277, c20_.address_commission AS address_commission_278, c20_.brokerage_commission AS brokerage_commission_279, c20_.liftings_min AS liftings_min_280, c20_.liftings_max AS liftings_max_281, c20_.checklist_notes AS checklist_notes_282, c20_.demurrage_status AS demurrage_status_283, c20_.demurrage_time_bar AS demurrage_time_bar_284, c20_.demurrage_payment_date AS demurrage_payment_date_285, c20_.final_demurrage_cost AS final_demurrage_cost_286, c20_.final_demurrage_cost_currency AS final_demurrage_cost_currency_287, c20_.demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288, c20_.demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289, c20_.eta_arrival AS eta_arrival_290, c20_.delivered_arrival AS delivered_arrival_291, c20_.delivery_aprox_notice1 AS delivery_aprox_notice1_292, c20_.delivery_aprox_notice2 AS delivery_aprox_notice2_293, c20_.delivery_aprox_notice3 AS delivery_aprox_notice3_294, c20_.delivery_aprox_notice4 AS delivery_aprox_notice4_295, c20_.delivery_aprox_notice5 AS delivery_aprox_notice5_296, c20_.delivery_aprox_notice6 AS delivery_aprox_notice6_297, c20_.delivery_aprox_notice7 AS delivery_aprox_notice7_298, c20_.delivery_firm_notice1 AS delivery_firm_notice1_299, c20_.delivery_firm_notice2 AS delivery_firm_notice2_300, c20_.delivery_firm_notice3 AS delivery_firm_notice3_301, c20_.delivery_firm_notice4 AS delivery_firm_notice4_302, c20_.delivery_firm_notice5 AS delivery_firm_notice5_303, c20_.delivery_firm_notice6 AS delivery_firm_notice6_304, c20_.delivery_firm_notice7 AS delivery_firm_notice7_305, c20_.delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306, c20_.ship_delivered AS ship_delivered_307, c20_.hire_per_day AS hire_per_day_308, c20_.hire_per_day_currency AS hire_per_day_currency_309, c20_.period AS period_310, c20_.report_description AS report_description_311, c20_.vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312, c20_.vessel_was_substituted AS vessel_was_substituted_313, c20_.addendum_issued AS addendum_issued_314, c20_.addendum_description AS addendum_description_315, c20_.created_at AS created_at_316, c20_.updated_at AS updated_at_317, c0_.vessel_id AS vessel_id_318, c0_.owner_id AS owner_id_319, c0_.charterer_id AS charterer_id_320, c0_.broker_id AS broker_id_321, c0_.operator_id AS operator_id_322, c0_.checklist_id AS checklist_id_323, c0_.delivery_port1_id AS delivery_port1_id_324, c0_.delivery_port2_id AS delivery_port2_id_325, c0_.contract_coa_id AS contract_coa_id_326, v1_.owner_id AS owner_id_327, o2_.primary_contact_id AS primary_contact_id_328, u4_.avatar_id AS avatar_id_329, u5_.avatar_id AS avatar_id_330, a6_.contract_id AS contract_id_331, m7_.contract_id AS contract_id_332, p8_.port_id AS port_id_333, p8_.contract_id AS contract_id_334, r9_.port_id AS port_id_335, r9_.contract_id AS contract_id_336, r10_.contract_id AS contract_id_337, c11_.cargo_id AS cargo_id_338, c11_.contract_id AS contract_id_339, p12_.contract_id AS contract_id_340, h13_.contract_id AS contract_id_341, c14_.vessel_id AS vessel_id_342, c14_.owner_id AS owner_id_343, c14_.charterer_id AS charterer_id_344, c14_.broker_id AS broker_id_345, c14_.operator_id AS operator_id_346, c14_.checklist_id AS checklist_id_347, c14_.delivery_port1_id AS delivery_port1_id_348, c14_.delivery_port2_id AS delivery_port2_id_349, c14_.contract_coa_id AS contract_coa_id_350, t16_.checklist_id AS checklist_id_351, d19_.contract_id AS contract_id_352, c20_.vessel_id AS vessel_id_353, c20_.owner_id AS owner_id_354, c20_.charterer_id AS charterer_id_355, c20_.broker_id AS broker_id_356, c20_.operator_id AS operator_id_357, c20_.checklist_id AS checklist_id_358, c20_.delivery_port1_id AS delivery_port1_id_359, c20_.delivery_port2_id AS delivery_port2_id_360, c20_.contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_.vessel_id = v1_.id LEFT JOIN owner o2_ ON c0_.owner_id = o2_.id LEFT JOIN charterer c3_ ON c0_.charterer_id = c3_.id LEFT JOIN user u4_ ON c0_.broker_id = u4_.id LEFT JOIN user u5_ ON c0_.operator_id = u5_.id LEFT JOIN additional_cost a6_ ON c0_.id = a6_.contract_id LEFT JOIN media m7_ ON c0_.id = m7_.contract_id LEFT JOIN port_call p8_ ON c0_.id = p8_.contract_id LEFT JOIN reported_port r9_ ON c0_.id = r9_.contract_id LEFT JOIN reported_incident r10_ ON c0_.id = r10_.contract_id LEFT JOIN contract_cargo c11_ ON c0_.id = c11_.contract_id LEFT JOIN payment p12_ ON c0_.id = p12_.contract_id LEFT JOIN hire h13_ ON c0_.id = h13_.contract_id LEFT JOIN contract c14_ ON c0_.id = c14_.contract_coa_id LEFT JOIN checklist c15_ ON c0_.checklist_id = c15_.id LEFT JOIN contract_task c21_ ON c0_.id = c21_.contract_id LEFT JOIN task t16_ ON t16_.id = c21_.task_id LEFT JOIN port p17_ ON c0_.delivery_port1_id = p17_.id LEFT JOIN port p18_ ON c0_.delivery_port2_id = p18_.id LEFT JOIN delivery_notice d19_ ON c0_.id = d19_.contract_id LEFT JOIN contract c20_ ON c0_.contract_coa_id = c20_.id WHERE c0_.id = 'd3d8529c-3f44-4c07-8eb6-e251148b4be8';
3	0.14 ms	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 = ? Parameters: [`"2765c4fc-502f-4714-abf6-f043cbca979d"`] View formatted query View runnable query Explain query 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 = '2765c4fc-502f-4714-abf6-f043cbca979d';
4	0.12 ms	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 = ? Parameters: [`"feee9a59-147a-4483-ba78-9c1e648468c4"`] View formatted query View runnable query Explain query 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 = 'feee9a59-147a-4483-ba78-9c1e648468c4';
5	0.16 ms	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 = ? Parameters: [`"02247633-01ae-4b1b-822a-c171ba98811d"`] View formatted query View runnable query Explain query 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 = '02247633-01ae-4b1b-822a-c171ba98811d';
6	0.20 ms	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 = ? Parameters: [`"5cc8f2f8-5822-4507-ad3c-411d9c78247d"`] View formatted query View runnable query Explain query 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 = '5cc8f2f8-5822-4507-ad3c-411d9c78247d';
7	0.14 ms	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 = ? Parameters: [`"5a18fd6c-a3d5-43b0-a8aa-6bf34be786ec"`] View formatted query View runnable query Explain query 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 = '5a18fd6c-a3d5-43b0-a8aa-6bf34be786ec';
8	1.08 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.cargo_type AS cargo_type_3, t0.subtype AS subtype_4, t0.observations AS observations_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cargo t0 WHERE t0.id = ? Parameters: [`"6eb2621a-124c-4053-a285-fb93377d4019"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.cargo_type AS cargo_type_3, t0.subtype AS subtype_4, t0.observations AS observations_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cargo t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.cargo_type AS cargo_type_3, t0.subtype AS subtype_4, t0.observations AS observations_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cargo t0 WHERE t0.id = '6eb2621a-124c-4053-a285-fb93377d4019';
9	0.15 ms	SELECT t0.id AS id_1, t0.task_name AS task_name_2, t0.description AS description_3, t0.task_index AS task_index_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.checklist_id AS checklist_id_7 FROM task t0 WHERE t0.checklist_id = ? ORDER BY t0.task_index ASC Parameters: [`"38312632-3ada-459f-995f-4407550114e8"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.task_name AS task_name_2, t0.description AS description_3, t0.task_index AS task_index_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.checklist_id AS checklist_id_7 FROM task t0 WHERE t0.checklist_id = ? ORDER BY t0.task_index ASC SELECT t0.id AS id_1, t0.task_name AS task_name_2, t0.description AS description_3, t0.task_index AS task_index_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.checklist_id AS checklist_id_7 FROM task t0 WHERE t0.checklist_id = '38312632-3ada-459f-995f-4407550114e8' ORDER BY t0.task_index ASC;
10	0.17 ms	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 = ? Parameters: [`"47f7dc54-685b-4fdb-ac27-3f0fe530eee3"`] View formatted query View runnable query Explain query 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 = '47f7dc54-685b-4fdb-ac27-3f0fe530eee3';
11	0.19 ms	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 = ? Parameters: [`"374be3e9-9b16-49f6-b386-7ec0e43ae19a"`] View formatted query View runnable query Explain query 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 = '374be3e9-9b16-49f6-b386-7ec0e43ae19a';
12	0.13 ms	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 = ? Parameters: [`"d1d49e7e-a990-42e5-bcb8-6c737fa61dd1"`] View formatted query View runnable query Explain query 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 = 'd1d49e7e-a990-42e5-bcb8-6c737fa61dd1';
13	0.24 ms	SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ? Parameters: [`"a36d2c3a-3f49-46b2-9bf3-a0d37ea163db"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ? SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = 'a36d2c3a-3f49-46b2-9bf3-a0d37ea163db';
14	0.18 ms	SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ? Parameters: [`"374be3e9-9b16-49f6-b386-7ec0e43ae19a"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = ? SELECT t0.id AS id_1, t0.quantity_m3 AS quantity_m3_2, t0.quantity_mt AS quantity_mt_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.cargo_id AS cargo_id_6, t0.contract_id AS contract_id_7 FROM contract_cargo t0 WHERE t0.contract_id = '374be3e9-9b16-49f6-b386-7ec0e43ae19a';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Media	No errors.
App\Entity\Contract	No errors.
App\Entity\Vessel	No errors.
App\Entity\Owner	No errors.
App\Entity\Charterer	No errors.
App\Entity\AdditionalCost	No errors.
App\Entity\PortCall	No errors.
App\Entity\ReportedPort	No errors.
App\Entity\ReportedIncident	No errors.
App\Entity\ContractCargo	No errors.
App\Entity\Payment	No errors.
App\Entity\Hire	No errors.
App\Entity\Checklist	No errors.
App\Entity\Task	The field App\Entity\Task#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contract#checkedTasks does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\Port	No errors.
App\Entity\DeliveryNotice	No errors.
App\Entity\Contact	No errors.
App\Entity\Cargo	No errors.
App\Entity\Berth	No errors.

Symfony Profiler

https://tide-api.puracomunicacao.com.br/api/contracts/d3d8529c-3f44-4c07-8eb6-e251148b4be8

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping