Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.last_connection_date AS last_connection_date_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.trigram AS trigram_10
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.last_connection_date AS last_connection_date_7, t0.created AS created_8, t0.updated AS updated_9, t0.trigram AS trigram_10 FROM `user` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.departure_airport AS departure_airport_3,
  t0.arrival_airport AS arrival_airport_4,
  t0.departure_date AS departure_date_5,
  t0.arrival_date AS arrival_date_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.api_flight_id AS api_flight_id_9,
  t0.cockpitcrew AS cockpitcrew_10,
  t0.cabincrew AS cabincrew_11,
  t0.estimated_departure AS estimated_departure_12,
  t0.estimated_arrival AS estimated_arrival_13,
  t0.actual_departure AS actual_departure_14,
  t0.actual_arrival AS actual_arrival_15,
  t0.is_closed AS is_closed_16,
  t0.is_other_user AS is_other_user_17,
  t0.take_off AS take_off_18,
  t0.landing AS landing_19,
  t0.flight_status_id AS flight_status_id_20,
  t0.aircraft_id AS aircraft_id_21,
  t0.aircraft_flight_correc_id AS aircraft_flight_correc_id_22,
  t23.id AS id_24,
  t23.jclass AS jclass_25,
  t23.wclass AS wclass_26,
  t23.yclass AS yclass_27,
  t23.stcrnumber AS stcrnumber_28,
  t23.petcnumber AS petcnumber_29,
  t23.wchcnumber AS wchcnumber_30,
  t23.wchrnumber AS wchrnumber_31,
  t23.wchsnumber AS wchsnumber_32,
  t23.avihnumber AS avihnumber_33,
  t23.depunumber AS depunumber_34,
  t23.depanumber AS depanumber_35,
  t23.infnumber AS infnumber_36,
  t23.chdnumber AS chdnumber_37,
  t23.weapnumber AS weapnumber_38,
  t23.maasnumber AS maasnumber_39,
  t23.gpnumber AS gpnumber_40,
  t23.created AS created_41,
  t23.updated AS updated_42,
  t23.flight_id_id AS flight_id_id_43,
  t44.id AS id_45,
  t44.stcr AS stcr_46,
  t44.petc AS petc_47,
  t44.wchc AS wchc_48,
  t44.wchr AS wchr_49,
  t44.wchs AS wchs_50,
  t44.avih AS avih_51,
  t44.depu AS depu_52,
  t44.depa AS depa_53,
  t44.inf AS inf_54,
  t44.chd AS chd_55,
  t44.weap AS weap_56,
  t44.maas AS maas_57,
  t44.gp AS gp_58,
  t44.j AS j_59,
  t44.w AS w_60,
  t44.y AS y_61,
  t44.codeshare AS codeshare_62,
  t44.total_pax_number AS total_pax_number_63,
  t44.total_pax_weight AS total_pax_weight_64,
  t44.ake_number AS ake_number_65,
  t44.ake_weight AS ake_weight_66,
  t44.flight_kit_number AS flight_kit_number_67,
  t44.flight_kit_weight AS flight_kit_weight_68,
  t44.other_payload_number AS other_payload_number_69,
  t44.other_payload_weight AS other_payload_weight_70,
  t44.fret AS fret_71,
  t44.payload AS payload_72,
  t44.dow AS dow_73,
  t44.pnt_number AS pnt_number_74,
  t44.pnt_weight AS pnt_weight_75,
  t44.pnc_number AS pnc_number_76,
  t44.pnc_weight AS pnc_weight_77,
  t44.mechanic_number AS mechanic_number_78,
  t44.mechanic_weight AS mechanic_weight_79,
  t44.ads AS ads_80,
  t44.other_dow AS other_dow_81,
  t44.water_number AS water_number_82,
  t44.water_weight AS water_weight_83,
  t44.corrected_dow AS corrected_dow_84,
  t44.observations AS observations_85,
  t44.created AS created_86,
  t44.updated AS updated_87,
  t44.um AS um_88,
  t44.bsct AS bsct_89,
  t44.gom_cw AS gom_cw_90,
  t44.umnr AS umnr_91,
  t44.unzz AS unzz_92,
  t44.default_pnt_weight AS default_pnt_weight_93,
  t44.default_pnc_weight AS default_pnc_weight_94,
  t44.default_ake_weight AS default_ake_weight_95,
  t44.flight_id_id AS flight_id_id_96,
  t97.id AS id_98,
  t97.path_ofp AS path_ofp_99,
  t97.raim AS raim_100,
  t97.atc AS atc_101,
  t97.plotting_chart AS plotting_chart_102,
  t97.over_flight_authorization AS over_flight_authorization_103,
  t97.meda_agreement AS meda_agreement_104,
  t97.opti_flight AS opti_flight_105,
  t97.safety_sheet AS safety_sheet_106,
  t97.other_document AS other_document_107,
  t97.aip_sup AS aip_sup_108,
  t97.nav_data AS nav_data_109,
  t97.metar_taf AS metar_taf_110,
  t97.wintem_temsi AS wintem_temsi_111,
  t97.vag_tcag AS vag_tcag_112,
  t97.notam_apt_fir AS notam_apt_fir_113,
  t97.flight_time AS flight_time_114,
  t97.flight_eta AS flight_eta_115,
  t97.security_officer AS security_officer_116,
  t97.technician AS technician_117,
  t97.observer AS observer_118,
  t97.dispatch AS dispatch_119,
  t97.captain AS captain_120,
  t97.pnt AS pnt_121,
  t97.pnc AS pnc_122,
  t97.mep AS mep_123,
  t97.is_mep AS is_mep_124,
  t97.flight_id AS flight_id_125,
  t126.id AS id_127,
  t126.observation AS observation_128,
  t126.compo_peq AS compo_peq_129,
  t126.route AS route_130,
  t126.etops AS etops_131,
  t126.limit_ope AS limit_ope_132,
  t126.pk AS pk_133,
  t126.weather AS weather_134,
  t126.rmk_pax AS rmk_pax_135,
  t126.gp AS gp_136,
  t126.rmk_fret AS rmk_fret_137,
  t126.connexion AS connexion_138,
  t126.notams AS notams_139,
  t126.mel AS mel_140,
  t126.metar_taf AS metar_taf_141,
  t126.created AS created_142,
  t126.updated AS updated_143,
  t126.rmk_mcc AS rmk_mcc_144,
  t126.author AS author_145,
  t126.gp_name AS gp_name_146,
  t126.is_manual AS is_manual_147,
  t126.manually AS manually_148,
  t126.flight_id AS flight_id_149,
  t150.id AS id_151,
  t150.fh AS fh_152,
  t150.cy AS cy_153,
  t150.date AS date_154,
  t150.station AS station_155,
  t150.last_update AS last_update_156,
  t150.user_update AS user_update_157,
  t150.date_request AS date_request_158,
  t150.flight_id AS flight_id_159,
  t160.id AS id_161,
  t160.ddv AS ddv_162,
  t160.pre_checklist AS pre_checklist_163,
  t160.dispatcher_briefing AS dispatcher_briefing_164,
  t160.aircraft_status AS aircraft_status_165,
  t160.crew_list AS crew_list_166,
  t160.mep AS mep_167,
  t160.gendec AS gendec_168,
  t160.ofp AS ofp_169,
  t160.raim AS raim_170,
  t160.atc AS atc_171,
  t160.notam AS notam_172,
  t160.metar AS metar_173,
  t160.airport_briefing AS airport_briefing_174,
  t160.briefing_etops AS briefing_etops_175,
  t160.plotting_chart_etops AS plotting_chart_etops_176,
  t160.wintem AS wintem_177,
  t160.vag AS vag_178,
  t160.nav_data AS nav_data_179,
  t160.aip_sup AS aip_sup_180,
  t160.autorisation_survol AS autorisation_survol_181,
  t160.accord_meda AS accord_meda_182,
  t160.opti_flight AS opti_flight_183,
  t160.fiche_surete AS fiche_surete_184,
  t160.other_document AS other_document_185,
  t160.created AS created_186,
  t160.updated AS updated_187,
  t160.flight_id AS flight_id_188,
  t189.id AS id_190,
  t189.taxiout AS taxiout_191,
  t189.cruise_speed AS cruise_speed_192,
  t189.reserves AS reserves_193,
  t189.created AS created_194,
  t189.updated AS updated_195,
  t189.flight_id AS flight_id_196,
  t197.id AS id_198,
  t197.fret AS fret_199,
  t197.mcc AS mcc_200,
  t197.eff AS eff_201,
  t197.mail AS mail_202,
  t197.flight_id AS flight_id_203,
  t204.id AS id_205,
  t204.case_a AS case_a_206,
  t204.case_b AS case_b_207,
  t204.pbn AS pbn_208,
  t204.rmk AS rmk_209,
  t204.alt1 AS alt1_210,
  t204.alt2 AS alt2_211,
  t204.alt3 AS alt3_212,
  t204.t_alt AS t_alt_213,
  t204.type AS type_214,
  t204.route AS route_215,
  t204.tdv AS tdv_216,
  t204.eet AS eet_217,
  t204.fl AS fl_218,
  t204.call_sign AS call_sign_219,
  t204.number AS number_220,
  t204.dep AS dep_221,
  t204.arr AS arr_222,
  t204.flight_id AS flight_id_223
FROM
  flight t0
  LEFT JOIN flight_pax t23 ON t23.flight_id_id = t0.id
  LEFT JOIN ddv t44 ON t44.flight_id_id = t0.id
  LEFT JOIN ppv_content t97 ON t97.flight_id = t0.id
  LEFT JOIN dispatcher_briefing t126 ON t126.flight_id = t0.id
  LEFT JOIN aircraft_status t150 ON t150.flight_id = t0.id
  LEFT JOIN module_status t160 ON t160.flight_id = t0.id
  LEFT JOIN prechecklist t189 ON t189.flight_id = t0.id
  LEFT JOIN workflow t197 ON t197.flight_id = t0.id
  LEFT JOIN ppv_atc_atr t204 ON t204.flight_id = t0.id
WHERE
  t0.api_flight_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.departure_airport AS departure_airport_3, t0.arrival_airport AS arrival_airport_4, t0.departure_date AS departure_date_5, t0.arrival_date AS arrival_date_6, t0.created AS created_7, t0.updated AS updated_8, t0.api_flight_id AS api_flight_id_9, t0.cockpitcrew AS cockpitcrew_10, t0.cabincrew AS cabincrew_11, t0.estimated_departure AS estimated_departure_12, t0.estimated_arrival AS estimated_arrival_13, t0.actual_departure AS actual_departure_14, t0.actual_arrival AS actual_arrival_15, t0.is_closed AS is_closed_16, t0.is_other_user AS is_other_user_17, t0.take_off AS take_off_18, t0.landing AS landing_19, t0.flight_status_id AS flight_status_id_20, t0.aircraft_id AS aircraft_id_21, t0.aircraft_flight_correc_id AS aircraft_flight_correc_id_22, t23.id AS id_24, t23.jclass AS jclass_25, t23.wclass AS wclass_26, t23.yclass AS yclass_27, t23.stcrnumber AS stcrnumber_28, t23.petcnumber AS petcnumber_29, t23.wchcnumber AS wchcnumber_30, t23.wchrnumber AS wchrnumber_31, t23.wchsnumber AS wchsnumber_32, t23.avihnumber AS avihnumber_33, t23.depunumber AS depunumber_34, t23.depanumber AS depanumber_35, t23.infnumber AS infnumber_36, t23.chdnumber AS chdnumber_37, t23.weapnumber AS weapnumber_38, t23.maasnumber AS maasnumber_39, t23.gpnumber AS gpnumber_40, t23.created AS created_41, t23.updated AS updated_42, t23.flight_id_id AS flight_id_id_43, t44.id AS id_45, t44.stcr AS stcr_46, t44.petc AS petc_47, t44.wchc AS wchc_48, t44.wchr AS wchr_49, t44.wchs AS wchs_50, t44.avih AS avih_51, t44.depu AS depu_52, t44.depa AS depa_53, t44.inf AS inf_54, t44.chd AS chd_55, t44.weap AS weap_56, t44.maas AS maas_57, t44.gp AS gp_58, t44.j AS j_59, t44.w AS w_60, t44.y AS y_61, t44.codeshare AS codeshare_62, t44.total_pax_number AS total_pax_number_63, t44.total_pax_weight AS total_pax_weight_64, t44.ake_number AS ake_number_65, t44.ake_weight AS ake_weight_66, t44.flight_kit_number AS flight_kit_number_67, t44.flight_kit_weight AS flight_kit_weight_68, t44.other_payload_number AS other_payload_number_69, t44.other_payload_weight AS other_payload_weight_70, t44.fret AS fret_71, t44.payload AS payload_72, t44.dow AS dow_73, t44.pnt_number AS pnt_number_74, t44.pnt_weight AS pnt_weight_75, t44.pnc_number AS pnc_number_76, t44.pnc_weight AS pnc_weight_77, t44.mechanic_number AS mechanic_number_78, t44.mechanic_weight AS mechanic_weight_79, t44.ads AS ads_80, t44.other_dow AS other_dow_81, t44.water_number AS water_number_82, t44.water_weight AS water_weight_83, t44.corrected_dow AS corrected_dow_84, t44.observations AS observations_85, t44.created AS created_86, t44.updated AS updated_87, t44.um AS um_88, t44.bsct AS bsct_89, t44.gom_cw AS gom_cw_90, t44.umnr AS umnr_91, t44.unzz AS unzz_92, t44.default_pnt_weight AS default_pnt_weight_93, t44.default_pnc_weight AS default_pnc_weight_94, t44.default_ake_weight AS default_ake_weight_95, t44.flight_id_id AS flight_id_id_96, t97.id AS id_98, t97.path_ofp AS path_ofp_99, t97.raim AS raim_100, t97.atc AS atc_101, t97.plotting_chart AS plotting_chart_102, t97.over_flight_authorization AS over_flight_authorization_103, t97.meda_agreement AS meda_agreement_104, t97.opti_flight AS opti_flight_105, t97.safety_sheet AS safety_sheet_106, t97.other_document AS other_document_107, t97.aip_sup AS aip_sup_108, t97.nav_data AS nav_data_109, t97.metar_taf AS metar_taf_110, t97.wintem_temsi AS wintem_temsi_111, t97.vag_tcag AS vag_tcag_112, t97.notam_apt_fir AS notam_apt_fir_113, t97.flight_time AS flight_time_114, t97.flight_eta AS flight_eta_115, t97.security_officer AS security_officer_116, t97.technician AS technician_117, t97.observer AS observer_118, t97.dispatch AS dispatch_119, t97.captain AS captain_120, t97.pnt AS pnt_121, t97.pnc AS pnc_122, t97.mep AS mep_123, t97.is_mep AS is_mep_124, t97.flight_id AS flight_id_125, t126.id AS id_127, t126.observation AS observation_128, t126.compo_peq AS compo_peq_129, t126.route AS route_130, t126.etops AS etops_131, t126.limit_ope AS limit_ope_132, t126.pk AS pk_133, t126.weather AS weather_134, t126.rmk_pax AS rmk_pax_135, t126.gp AS gp_136, t126.rmk_fret AS rmk_fret_137, t126.connexion AS connexion_138, t126.notams AS notams_139, t126.mel AS mel_140, t126.metar_taf AS metar_taf_141, t126.created AS created_142, t126.updated AS updated_143, t126.rmk_mcc AS rmk_mcc_144, t126.author AS author_145, t126.gp_name AS gp_name_146, t126.is_manual AS is_manual_147, t126.manually AS manually_148, t126.flight_id AS flight_id_149, t150.id AS id_151, t150.fh AS fh_152, t150.cy AS cy_153, t150.date AS date_154, t150.station AS station_155, t150.last_update AS last_update_156, t150.user_update AS user_update_157, t150.date_request AS date_request_158, t150.flight_id AS flight_id_159, t160.id AS id_161, t160.ddv AS ddv_162, t160.pre_checklist AS pre_checklist_163, t160.dispatcher_briefing AS dispatcher_briefing_164, t160.aircraft_status AS aircraft_status_165, t160.crew_list AS crew_list_166, t160.mep AS mep_167, t160.gendec AS gendec_168, t160.ofp AS ofp_169, t160.raim AS raim_170, t160.atc AS atc_171, t160.notam AS notam_172, t160.metar AS metar_173, t160.airport_briefing AS airport_briefing_174, t160.briefing_etops AS briefing_etops_175, t160.plotting_chart_etops AS plotting_chart_etops_176, t160.wintem AS wintem_177, t160.vag AS vag_178, t160.nav_data AS nav_data_179, t160.aip_sup AS aip_sup_180, t160.autorisation_survol AS autorisation_survol_181, t160.accord_meda AS accord_meda_182, t160.opti_flight AS opti_flight_183, t160.fiche_surete AS fiche_surete_184, t160.other_document AS other_document_185, t160.created AS created_186, t160.updated AS updated_187, t160.flight_id AS flight_id_188, t189.id AS id_190, t189.taxiout AS taxiout_191, t189.cruise_speed AS cruise_speed_192, t189.reserves AS reserves_193, t189.created AS created_194, t189.updated AS updated_195, t189.flight_id AS flight_id_196, t197.id AS id_198, t197.fret AS fret_199, t197.mcc AS mcc_200, t197.eff AS eff_201, t197.mail AS mail_202, t197.flight_id AS flight_id_203, t204.id AS id_205, t204.case_a AS case_a_206, t204.case_b AS case_b_207, t204.pbn AS pbn_208, t204.rmk AS rmk_209, t204.alt1 AS alt1_210, t204.alt2 AS alt2_211, t204.alt3 AS alt3_212, t204.t_alt AS t_alt_213, t204.type AS type_214, t204.route AS route_215, t204.tdv AS tdv_216, t204.eet AS eet_217, t204.fl AS fl_218, t204.call_sign AS call_sign_219, t204.number AS number_220, t204.dep AS dep_221, t204.arr AS arr_222, t204.flight_id AS flight_id_223 FROM flight t0 LEFT JOIN flight_pax t23 ON t23.flight_id_id = t0.id LEFT JOIN ddv t44 ON t44.flight_id_id = t0.id LEFT JOIN ppv_content t97 ON t97.flight_id = t0.id LEFT JOIN dispatcher_briefing t126 ON t126.flight_id = t0.id LEFT JOIN aircraft_status t150 ON t150.flight_id = t0.id LEFT JOIN module_status t160 ON t160.flight_id = t0.id LEFT JOIN prechecklist t189 ON t189.flight_id = t0.id LEFT JOIN workflow t197 ON t197.flight_id = t0.id LEFT JOIN ppv_atc_atr t204 ON t204.flight_id = t0.id WHERE t0.api_flight_id = 36090070 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.departure_airport AS departure_airport_3,
  t0.arrival_airport AS arrival_airport_4,
  t0.departure_date AS departure_date_5,
  t0.arrival_date AS arrival_date_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.api_flight_id AS api_flight_id_9,
  t0.cockpitcrew AS cockpitcrew_10,
  t0.cabincrew AS cabincrew_11,
  t0.estimated_departure AS estimated_departure_12,
  t0.estimated_arrival AS estimated_arrival_13,
  t0.actual_departure AS actual_departure_14,
  t0.actual_arrival AS actual_arrival_15,
  t0.is_closed AS is_closed_16,
  t0.is_other_user AS is_other_user_17,
  t0.take_off AS take_off_18,
  t0.landing AS landing_19,
  t0.flight_status_id AS flight_status_id_20,
  t0.aircraft_id AS aircraft_id_21,
  t0.aircraft_flight_correc_id AS aircraft_flight_correc_id_22,
  t23.id AS id_24,
  t23.jclass AS jclass_25,
  t23.wclass AS wclass_26,
  t23.yclass AS yclass_27,
  t23.stcrnumber AS stcrnumber_28,
  t23.petcnumber AS petcnumber_29,
  t23.wchcnumber AS wchcnumber_30,
  t23.wchrnumber AS wchrnumber_31,
  t23.wchsnumber AS wchsnumber_32,
  t23.avihnumber AS avihnumber_33,
  t23.depunumber AS depunumber_34,
  t23.depanumber AS depanumber_35,
  t23.infnumber AS infnumber_36,
  t23.chdnumber AS chdnumber_37,
  t23.weapnumber AS weapnumber_38,
  t23.maasnumber AS maasnumber_39,
  t23.gpnumber AS gpnumber_40,
  t23.created AS created_41,
  t23.updated AS updated_42,
  t23.flight_id_id AS flight_id_id_43,
  t44.id AS id_45,
  t44.stcr AS stcr_46,
  t44.petc AS petc_47,
  t44.wchc AS wchc_48,
  t44.wchr AS wchr_49,
  t44.wchs AS wchs_50,
  t44.avih AS avih_51,
  t44.depu AS depu_52,
  t44.depa AS depa_53,
  t44.inf AS inf_54,
  t44.chd AS chd_55,
  t44.weap AS weap_56,
  t44.maas AS maas_57,
  t44.gp AS gp_58,
  t44.j AS j_59,
  t44.w AS w_60,
  t44.y AS y_61,
  t44.codeshare AS codeshare_62,
  t44.total_pax_number AS total_pax_number_63,
  t44.total_pax_weight AS total_pax_weight_64,
  t44.ake_number AS ake_number_65,
  t44.ake_weight AS ake_weight_66,
  t44.flight_kit_number AS flight_kit_number_67,
  t44.flight_kit_weight AS flight_kit_weight_68,
  t44.other_payload_number AS other_payload_number_69,
  t44.other_payload_weight AS other_payload_weight_70,
  t44.fret AS fret_71,
  t44.payload AS payload_72,
  t44.dow AS dow_73,
  t44.pnt_number AS pnt_number_74,
  t44.pnt_weight AS pnt_weight_75,
  t44.pnc_number AS pnc_number_76,
  t44.pnc_weight AS pnc_weight_77,
  t44.mechanic_number AS mechanic_number_78,
  t44.mechanic_weight AS mechanic_weight_79,
  t44.ads AS ads_80,
  t44.other_dow AS other_dow_81,
  t44.water_number AS water_number_82,
  t44.water_weight AS water_weight_83,
  t44.corrected_dow AS corrected_dow_84,
  t44.observations AS observations_85,
  t44.created AS created_86,
  t44.updated AS updated_87,
  t44.um AS um_88,
  t44.bsct AS bsct_89,
  t44.gom_cw AS gom_cw_90,
  t44.umnr AS umnr_91,
  t44.unzz AS unzz_92,
  t44.default_pnt_weight AS default_pnt_weight_93,
  t44.default_pnc_weight AS default_pnc_weight_94,
  t44.default_ake_weight AS default_ake_weight_95,
  t44.flight_id_id AS flight_id_id_96,
  t97.id AS id_98,
  t97.path_ofp AS path_ofp_99,
  t97.raim AS raim_100,
  t97.atc AS atc_101,
  t97.plotting_chart AS plotting_chart_102,
  t97.over_flight_authorization AS over_flight_authorization_103,
  t97.meda_agreement AS meda_agreement_104,
  t97.opti_flight AS opti_flight_105,
  t97.safety_sheet AS safety_sheet_106,
  t97.other_document AS other_document_107,
  t97.aip_sup AS aip_sup_108,
  t97.nav_data AS nav_data_109,
  t97.metar_taf AS metar_taf_110,
  t97.wintem_temsi AS wintem_temsi_111,
  t97.vag_tcag AS vag_tcag_112,
  t97.notam_apt_fir AS notam_apt_fir_113,
  t97.flight_time AS flight_time_114,
  t97.flight_eta AS flight_eta_115,
  t97.security_officer AS security_officer_116,
  t97.technician AS technician_117,
  t97.observer AS observer_118,
  t97.dispatch AS dispatch_119,
  t97.captain AS captain_120,
  t97.pnt AS pnt_121,
  t97.pnc AS pnc_122,
  t97.mep AS mep_123,
  t97.is_mep AS is_mep_124,
  t97.flight_id AS flight_id_125,
  t126.id AS id_127,
  t126.observation AS observation_128,
  t126.compo_peq AS compo_peq_129,
  t126.route AS route_130,
  t126.etops AS etops_131,
  t126.limit_ope AS limit_ope_132,
  t126.pk AS pk_133,
  t126.weather AS weather_134,
  t126.rmk_pax AS rmk_pax_135,
  t126.gp AS gp_136,
  t126.rmk_fret AS rmk_fret_137,
  t126.connexion AS connexion_138,
  t126.notams AS notams_139,
  t126.mel AS mel_140,
  t126.metar_taf AS metar_taf_141,
  t126.created AS created_142,
  t126.updated AS updated_143,
  t126.rmk_mcc AS rmk_mcc_144,
  t126.author AS author_145,
  t126.gp_name AS gp_name_146,
  t126.is_manual AS is_manual_147,
  t126.manually AS manually_148,
  t126.flight_id AS flight_id_149,
  t150.id AS id_151,
  t150.fh AS fh_152,
  t150.cy AS cy_153,
  t150.date AS date_154,
  t150.station AS station_155,
  t150.last_update AS last_update_156,
  t150.user_update AS user_update_157,
  t150.date_request AS date_request_158,
  t150.flight_id AS flight_id_159,
  t160.id AS id_161,
  t160.ddv AS ddv_162,
  t160.pre_checklist AS pre_checklist_163,
  t160.dispatcher_briefing AS dispatcher_briefing_164,
  t160.aircraft_status AS aircraft_status_165,
  t160.crew_list AS crew_list_166,
  t160.mep AS mep_167,
  t160.gendec AS gendec_168,
  t160.ofp AS ofp_169,
  t160.raim AS raim_170,
  t160.atc AS atc_171,
  t160.notam AS notam_172,
  t160.metar AS metar_173,
  t160.airport_briefing AS airport_briefing_174,
  t160.briefing_etops AS briefing_etops_175,
  t160.plotting_chart_etops AS plotting_chart_etops_176,
  t160.wintem AS wintem_177,
  t160.vag AS vag_178,
  t160.nav_data AS nav_data_179,
  t160.aip_sup AS aip_sup_180,
  t160.autorisation_survol AS autorisation_survol_181,
  t160.accord_meda AS accord_meda_182,
  t160.opti_flight AS opti_flight_183,
  t160.fiche_surete AS fiche_surete_184,
  t160.other_document AS other_document_185,
  t160.created AS created_186,
  t160.updated AS updated_187,
  t160.flight_id AS flight_id_188,
  t189.id AS id_190,
  t189.taxiout AS taxiout_191,
  t189.cruise_speed AS cruise_speed_192,
  t189.reserves AS reserves_193,
  t189.created AS created_194,
  t189.updated AS updated_195,
  t189.flight_id AS flight_id_196,
  t197.id AS id_198,
  t197.fret AS fret_199,
  t197.mcc AS mcc_200,
  t197.eff AS eff_201,
  t197.mail AS mail_202,
  t197.flight_id AS flight_id_203,
  t204.id AS id_205,
  t204.case_a AS case_a_206,
  t204.case_b AS case_b_207,
  t204.pbn AS pbn_208,
  t204.rmk AS rmk_209,
  t204.alt1 AS alt1_210,
  t204.alt2 AS alt2_211,
  t204.alt3 AS alt3_212,
  t204.t_alt AS t_alt_213,
  t204.type AS type_214,
  t204.route AS route_215,
  t204.tdv AS tdv_216,
  t204.eet AS eet_217,
  t204.fl AS fl_218,
  t204.call_sign AS call_sign_219,
  t204.number AS number_220,
  t204.dep AS dep_221,
  t204.arr AS arr_222,
  t204.flight_id AS flight_id_223
FROM
  flight t0
  LEFT JOIN flight_pax t23 ON t23.flight_id_id = t0.id
  LEFT JOIN ddv t44 ON t44.flight_id_id = t0.id
  LEFT JOIN ppv_content t97 ON t97.flight_id = t0.id
  LEFT JOIN dispatcher_briefing t126 ON t126.flight_id = t0.id
  LEFT JOIN aircraft_status t150 ON t150.flight_id = t0.id
  LEFT JOIN module_status t160 ON t160.flight_id = t0.id
  LEFT JOIN prechecklist t189 ON t189.flight_id = t0.id
  LEFT JOIN workflow t197 ON t197.flight_id = t0.id
  LEFT JOIN ppv_atc_atr t204 ON t204.flight_id = t0.id
WHERE
  t0.api_flight_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.departure_airport AS departure_airport_3, t0.arrival_airport AS arrival_airport_4, t0.departure_date AS departure_date_5, t0.arrival_date AS arrival_date_6, t0.created AS created_7, t0.updated AS updated_8, t0.api_flight_id AS api_flight_id_9, t0.cockpitcrew AS cockpitcrew_10, t0.cabincrew AS cabincrew_11, t0.estimated_departure AS estimated_departure_12, t0.estimated_arrival AS estimated_arrival_13, t0.actual_departure AS actual_departure_14, t0.actual_arrival AS actual_arrival_15, t0.is_closed AS is_closed_16, t0.is_other_user AS is_other_user_17, t0.take_off AS take_off_18, t0.landing AS landing_19, t0.flight_status_id AS flight_status_id_20, t0.aircraft_id AS aircraft_id_21, t0.aircraft_flight_correc_id AS aircraft_flight_correc_id_22, t23.id AS id_24, t23.jclass AS jclass_25, t23.wclass AS wclass_26, t23.yclass AS yclass_27, t23.stcrnumber AS stcrnumber_28, t23.petcnumber AS petcnumber_29, t23.wchcnumber AS wchcnumber_30, t23.wchrnumber AS wchrnumber_31, t23.wchsnumber AS wchsnumber_32, t23.avihnumber AS avihnumber_33, t23.depunumber AS depunumber_34, t23.depanumber AS depanumber_35, t23.infnumber AS infnumber_36, t23.chdnumber AS chdnumber_37, t23.weapnumber AS weapnumber_38, t23.maasnumber AS maasnumber_39, t23.gpnumber AS gpnumber_40, t23.created AS created_41, t23.updated AS updated_42, t23.flight_id_id AS flight_id_id_43, t44.id AS id_45, t44.stcr AS stcr_46, t44.petc AS petc_47, t44.wchc AS wchc_48, t44.wchr AS wchr_49, t44.wchs AS wchs_50, t44.avih AS avih_51, t44.depu AS depu_52, t44.depa AS depa_53, t44.inf AS inf_54, t44.chd AS chd_55, t44.weap AS weap_56, t44.maas AS maas_57, t44.gp AS gp_58, t44.j AS j_59, t44.w AS w_60, t44.y AS y_61, t44.codeshare AS codeshare_62, t44.total_pax_number AS total_pax_number_63, t44.total_pax_weight AS total_pax_weight_64, t44.ake_number AS ake_number_65, t44.ake_weight AS ake_weight_66, t44.flight_kit_number AS flight_kit_number_67, t44.flight_kit_weight AS flight_kit_weight_68, t44.other_payload_number AS other_payload_number_69, t44.other_payload_weight AS other_payload_weight_70, t44.fret AS fret_71, t44.payload AS payload_72, t44.dow AS dow_73, t44.pnt_number AS pnt_number_74, t44.pnt_weight AS pnt_weight_75, t44.pnc_number AS pnc_number_76, t44.pnc_weight AS pnc_weight_77, t44.mechanic_number AS mechanic_number_78, t44.mechanic_weight AS mechanic_weight_79, t44.ads AS ads_80, t44.other_dow AS other_dow_81, t44.water_number AS water_number_82, t44.water_weight AS water_weight_83, t44.corrected_dow AS corrected_dow_84, t44.observations AS observations_85, t44.created AS created_86, t44.updated AS updated_87, t44.um AS um_88, t44.bsct AS bsct_89, t44.gom_cw AS gom_cw_90, t44.umnr AS umnr_91, t44.unzz AS unzz_92, t44.default_pnt_weight AS default_pnt_weight_93, t44.default_pnc_weight AS default_pnc_weight_94, t44.default_ake_weight AS default_ake_weight_95, t44.flight_id_id AS flight_id_id_96, t97.id AS id_98, t97.path_ofp AS path_ofp_99, t97.raim AS raim_100, t97.atc AS atc_101, t97.plotting_chart AS plotting_chart_102, t97.over_flight_authorization AS over_flight_authorization_103, t97.meda_agreement AS meda_agreement_104, t97.opti_flight AS opti_flight_105, t97.safety_sheet AS safety_sheet_106, t97.other_document AS other_document_107, t97.aip_sup AS aip_sup_108, t97.nav_data AS nav_data_109, t97.metar_taf AS metar_taf_110, t97.wintem_temsi AS wintem_temsi_111, t97.vag_tcag AS vag_tcag_112, t97.notam_apt_fir AS notam_apt_fir_113, t97.flight_time AS flight_time_114, t97.flight_eta AS flight_eta_115, t97.security_officer AS security_officer_116, t97.technician AS technician_117, t97.observer AS observer_118, t97.dispatch AS dispatch_119, t97.captain AS captain_120, t97.pnt AS pnt_121, t97.pnc AS pnc_122, t97.mep AS mep_123, t97.is_mep AS is_mep_124, t97.flight_id AS flight_id_125, t126.id AS id_127, t126.observation AS observation_128, t126.compo_peq AS compo_peq_129, t126.route AS route_130, t126.etops AS etops_131, t126.limit_ope AS limit_ope_132, t126.pk AS pk_133, t126.weather AS weather_134, t126.rmk_pax AS rmk_pax_135, t126.gp AS gp_136, t126.rmk_fret AS rmk_fret_137, t126.connexion AS connexion_138, t126.notams AS notams_139, t126.mel AS mel_140, t126.metar_taf AS metar_taf_141, t126.created AS created_142, t126.updated AS updated_143, t126.rmk_mcc AS rmk_mcc_144, t126.author AS author_145, t126.gp_name AS gp_name_146, t126.is_manual AS is_manual_147, t126.manually AS manually_148, t126.flight_id AS flight_id_149, t150.id AS id_151, t150.fh AS fh_152, t150.cy AS cy_153, t150.date AS date_154, t150.station AS station_155, t150.last_update AS last_update_156, t150.user_update AS user_update_157, t150.date_request AS date_request_158, t150.flight_id AS flight_id_159, t160.id AS id_161, t160.ddv AS ddv_162, t160.pre_checklist AS pre_checklist_163, t160.dispatcher_briefing AS dispatcher_briefing_164, t160.aircraft_status AS aircraft_status_165, t160.crew_list AS crew_list_166, t160.mep AS mep_167, t160.gendec AS gendec_168, t160.ofp AS ofp_169, t160.raim AS raim_170, t160.atc AS atc_171, t160.notam AS notam_172, t160.metar AS metar_173, t160.airport_briefing AS airport_briefing_174, t160.briefing_etops AS briefing_etops_175, t160.plotting_chart_etops AS plotting_chart_etops_176, t160.wintem AS wintem_177, t160.vag AS vag_178, t160.nav_data AS nav_data_179, t160.aip_sup AS aip_sup_180, t160.autorisation_survol AS autorisation_survol_181, t160.accord_meda AS accord_meda_182, t160.opti_flight AS opti_flight_183, t160.fiche_surete AS fiche_surete_184, t160.other_document AS other_document_185, t160.created AS created_186, t160.updated AS updated_187, t160.flight_id AS flight_id_188, t189.id AS id_190, t189.taxiout AS taxiout_191, t189.cruise_speed AS cruise_speed_192, t189.reserves AS reserves_193, t189.created AS created_194, t189.updated AS updated_195, t189.flight_id AS flight_id_196, t197.id AS id_198, t197.fret AS fret_199, t197.mcc AS mcc_200, t197.eff AS eff_201, t197.mail AS mail_202, t197.flight_id AS flight_id_203, t204.id AS id_205, t204.case_a AS case_a_206, t204.case_b AS case_b_207, t204.pbn AS pbn_208, t204.rmk AS rmk_209, t204.alt1 AS alt1_210, t204.alt2 AS alt2_211, t204.alt3 AS alt3_212, t204.t_alt AS t_alt_213, t204.type AS type_214, t204.route AS route_215, t204.tdv AS tdv_216, t204.eet AS eet_217, t204.fl AS fl_218, t204.call_sign AS call_sign_219, t204.number AS number_220, t204.dep AS dep_221, t204.arr AS arr_222, t204.flight_id AS flight_id_223 FROM flight t0 LEFT JOIN flight_pax t23 ON t23.flight_id_id = t0.id LEFT JOIN ddv t44 ON t44.flight_id_id = t0.id LEFT JOIN ppv_content t97 ON t97.flight_id = t0.id LEFT JOIN dispatcher_briefing t126 ON t126.flight_id = t0.id LEFT JOIN aircraft_status t150 ON t150.flight_id = t0.id LEFT JOIN module_status t160 ON t160.flight_id = t0.id LEFT JOIN prechecklist t189 ON t189.flight_id = t0.id LEFT JOIN workflow t197 ON t197.flight_id = t0.id LEFT JOIN ppv_atc_atr t204 ON t204.flight_id = t0.id WHERE t0.api_flight_id = 36090070 LIMIT 1;