Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.application_type AS application_type_3,
  t0.declined_at AS declined_at_4,
  t0.approved_at AS approved_at_5,
  t0.created_at AS created_at_6,
  t0.submitted_at AS submitted_at_7,
  t0.enquiry_source AS enquiry_source_8,
  t0.callback_url AS callback_url_9,
  t0.final_declaration AS final_declaration_10,
  t0.error AS error_11,
  t0.submitter_ip_address AS submitter_ip_address_12,
  t0.initial_disclosure_document_url AS initial_disclosure_document_url_13,
  t0.brand_phone AS brand_phone_14,
  t0.brand_email AS brand_email_15,
  t0.brand_open_hours AS brand_open_hours_16,
  t0.rci_proposal_id AS rci_proposal_id_17,
  t0.rci_proposal_status AS rci_proposal_status_18,
  t0.contact_consents_sms AS contact_consents_sms_19,
  t0.contact_consents_email AS contact_consents_email_20,
  t0.contact_consents_post AS contact_consents_post_21,
  t0.contact_consents_telephone AS contact_consents_telephone_22,
  t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_23,
  t0.eula_consents_information_notice AS eula_consents_information_notice_24,
  t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_25,
  t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_26,
  t0.private_individual_id AS private_individual_id_27,
  t28.prefix_title AS prefix_title_29,
  t28.first_name AS first_name_30,
  t28.middle_name AS middle_name_31,
  t28.surname AS surname_32,
  t28.birthday AS birthday_33,
  t28.nationality AS nationality_34,
  t28.number_of_financial_dependants AS number_of_financial_dependants_35,
  t28.marital_status AS marital_status_36,
  t28.driving_licence_number AS driving_licence_number_37,
  t28.gender AS gender_38,
  t28.driving_license_issue_date AS driving_license_issue_date_39,
  t28.driving_license_expiry_date AS driving_license_expiry_date_40,
  t28.previous_surname AS previous_surname_41,
  t28.id AS id_42,
  t28.comments AS comments_43,
  t28.employment_id AS employment_id_44,
  t28.financial_id AS financial_id_45,
  t28.contact_id AS contact_id_46,
  t28.address_id AS address_id_47,
  t0.company_id AS company_id_48,
  t49.id AS id_50,
  t49.company_name AS company_name_51,
  t49.trading_name AS trading_name_52,
  t49.registration_number AS registration_number_53,
  t49.vat_registered AS vat_registered_54,
  t49.vat_number AS vat_number_55,
  t49.comments AS comments_56,
  t49.company_fleet_fleet_size AS company_fleet_fleet_size_57,
  t49.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_58,
  t49.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_59,
  t49.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_60,
  t49.address_id AS address_id_61,
  t49.contact_id AS contact_id_62,
  t49.bank_details_id AS bank_details_id_63,
  t0.partnership_id AS partnership_id_64,
  t65.id AS id_66,
  t65.trading_name AS trading_name_67,
  t65.comments AS comments_68,
  t65.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_69,
  t65.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_70,
  t65.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_71,
  t65.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_72,
  t65.address_id AS address_id_73,
  t65.contact_id AS contact_id_74,
  t65.bank_details_id AS bank_details_id_75,
  t0.sole_trader_id AS sole_trader_id_76,
  t77.prefix_title AS prefix_title_78,
  t77.first_name AS first_name_79,
  t77.middle_name AS middle_name_80,
  t77.surname AS surname_81,
  t77.birthday AS birthday_82,
  t77.nationality AS nationality_83,
  t77.number_of_financial_dependants AS number_of_financial_dependants_84,
  t77.marital_status AS marital_status_85,
  t77.driving_licence_number AS driving_licence_number_86,
  t77.gender AS gender_87,
  t77.driving_license_issue_date AS driving_license_issue_date_88,
  t77.driving_license_expiry_date AS driving_license_expiry_date_89,
  t77.previous_surname AS previous_surname_90,
  t77.id AS id_91,
  t77.trading_name AS trading_name_92,
  t77.nature_of_business AS nature_of_business_93,
  t77.trading_since AS trading_since_94,
  t77.comments AS comments_95,
  t77.trading_address_id AS trading_address_id_96,
  t77.bank_details_id AS bank_details_id_97,
  t77.employment_id AS employment_id_98,
  t77.address_id AS address_id_99,
  t77.contact_id AS contact_id_100,
  t0.vehicle_id AS vehicle_id_101,
  t102.id AS id_103,
  t102.cap_id AS cap_id_104,
  t102.cap_code AS cap_code_105,
  t102.type AS type_106,
  t102.manufacturer_name AS manufacturer_name_107,
  t102.model_name AS model_name_108,
  t102.model_short_name AS model_short_name_109,
  t102.model_year AS model_year_110,
  t102.deal_type AS deal_type_111,
  t102.vehicle_name AS vehicle_name_112,
  t102.contract_length AS contract_length_113,
  t102.monthly_rate AS monthly_rate_114,
  t102.maintenance_monthly_rate AS maintenance_monthly_rate_115,
  t102.initial_payment AS initial_payment_116,
  t102.includes_vat AS includes_vat_117,
  t102.annual_mileage AS annual_mileage_118,
  t102.processing_fee AS processing_fee_119,
  t102.dealership_code AS dealership_code_120,
  t102.product_code AS product_code_121,
  t102.dealer_discount AS dealer_discount_122,
  t102.gross_yearly_road_tax AS gross_yearly_road_tax_123,
  t102.government_adjustment AS government_adjustment_124,
  t102.color_id AS color_id_125,
  t102.trim_id AS trim_id_126
FROM
  application t0
  LEFT JOIN private_individual t28 ON t0.private_individual_id = t28.id
  LEFT JOIN company t49 ON t0.company_id = t49.id
  LEFT JOIN partnership t65 ON t0.partnership_id = t65.id
  LEFT JOIN sole_trader t77 ON t0.sole_trader_id = t77.id
  LEFT JOIN vehicle t102 ON t0.vehicle_id = t102.id
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.application_type AS application_type_3, t0.declined_at AS declined_at_4, t0.approved_at AS approved_at_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.enquiry_source AS enquiry_source_8, t0.callback_url AS callback_url_9, t0.final_declaration AS final_declaration_10, t0.error AS error_11, t0.submitter_ip_address AS submitter_ip_address_12, t0.initial_disclosure_document_url AS initial_disclosure_document_url_13, t0.brand_phone AS brand_phone_14, t0.brand_email AS brand_email_15, t0.brand_open_hours AS brand_open_hours_16, t0.rci_proposal_id AS rci_proposal_id_17, t0.rci_proposal_status AS rci_proposal_status_18, t0.contact_consents_sms AS contact_consents_sms_19, t0.contact_consents_email AS contact_consents_email_20, t0.contact_consents_post AS contact_consents_post_21, t0.contact_consents_telephone AS contact_consents_telephone_22, t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_23, t0.eula_consents_information_notice AS eula_consents_information_notice_24, t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_25, t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_26, t0.private_individual_id AS private_individual_id_27, t28.prefix_title AS prefix_title_29, t28.first_name AS first_name_30, t28.middle_name AS middle_name_31, t28.surname AS surname_32, t28.birthday AS birthday_33, t28.nationality AS nationality_34, t28.number_of_financial_dependants AS number_of_financial_dependants_35, t28.marital_status AS marital_status_36, t28.driving_licence_number AS driving_licence_number_37, t28.gender AS gender_38, t28.driving_license_issue_date AS driving_license_issue_date_39, t28.driving_license_expiry_date AS driving_license_expiry_date_40, t28.previous_surname AS previous_surname_41, t28.id AS id_42, t28.comments AS comments_43, t28.employment_id AS employment_id_44, t28.financial_id AS financial_id_45, t28.contact_id AS contact_id_46, t28.address_id AS address_id_47, t0.company_id AS company_id_48, t49.id AS id_50, t49.company_name AS company_name_51, t49.trading_name AS trading_name_52, t49.registration_number AS registration_number_53, t49.vat_registered AS vat_registered_54, t49.vat_number AS vat_number_55, t49.comments AS comments_56, t49.company_fleet_fleet_size AS company_fleet_fleet_size_57, t49.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_58, t49.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_59, t49.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_60, t49.address_id AS address_id_61, t49.contact_id AS contact_id_62, t49.bank_details_id AS bank_details_id_63, t0.partnership_id AS partnership_id_64, t65.id AS id_66, t65.trading_name AS trading_name_67, t65.comments AS comments_68, t65.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_69, t65.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_70, t65.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_71, t65.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_72, t65.address_id AS address_id_73, t65.contact_id AS contact_id_74, t65.bank_details_id AS bank_details_id_75, t0.sole_trader_id AS sole_trader_id_76, t77.prefix_title AS prefix_title_78, t77.first_name AS first_name_79, t77.middle_name AS middle_name_80, t77.surname AS surname_81, t77.birthday AS birthday_82, t77.nationality AS nationality_83, t77.number_of_financial_dependants AS number_of_financial_dependants_84, t77.marital_status AS marital_status_85, t77.driving_licence_number AS driving_licence_number_86, t77.gender AS gender_87, t77.driving_license_issue_date AS driving_license_issue_date_88, t77.driving_license_expiry_date AS driving_license_expiry_date_89, t77.previous_surname AS previous_surname_90, t77.id AS id_91, t77.trading_name AS trading_name_92, t77.nature_of_business AS nature_of_business_93, t77.trading_since AS trading_since_94, t77.comments AS comments_95, t77.trading_address_id AS trading_address_id_96, t77.bank_details_id AS bank_details_id_97, t77.employment_id AS employment_id_98, t77.address_id AS address_id_99, t77.contact_id AS contact_id_100, t0.vehicle_id AS vehicle_id_101, t102.id AS id_103, t102.cap_id AS cap_id_104, t102.cap_code AS cap_code_105, t102.type AS type_106, t102.manufacturer_name AS manufacturer_name_107, t102.model_name AS model_name_108, t102.model_short_name AS model_short_name_109, t102.model_year AS model_year_110, t102.deal_type AS deal_type_111, t102.vehicle_name AS vehicle_name_112, t102.contract_length AS contract_length_113, t102.monthly_rate AS monthly_rate_114, t102.maintenance_monthly_rate AS maintenance_monthly_rate_115, t102.initial_payment AS initial_payment_116, t102.includes_vat AS includes_vat_117, t102.annual_mileage AS annual_mileage_118, t102.processing_fee AS processing_fee_119, t102.dealership_code AS dealership_code_120, t102.product_code AS product_code_121, t102.dealer_discount AS dealer_discount_122, t102.gross_yearly_road_tax AS gross_yearly_road_tax_123, t102.government_adjustment AS government_adjustment_124, t102.color_id AS color_id_125, t102.trim_id AS trim_id_126 FROM application t0 LEFT JOIN private_individual t28 ON t0.private_individual_id = t28.id LEFT JOIN company t49 ON t0.company_id = t49.id LEFT JOIN partnership t65 ON t0.partnership_id = t65.id LEFT JOIN sole_trader t77 ON t0.sole_trader_id = t77.id LEFT JOIN vehicle t102 ON t0.vehicle_id = t102.id WHERE t0.uuid = 0x1F165A73D7676B628C8295B10F529A21 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_id AS option_id_2,
  t0.option_name AS option_name_3,
  t0.option_price AS option_price_4
FROM
  vehicle_extra t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.option_id AS option_id_2, t0.option_name AS option_name_3, t0.option_price AS option_price_4 FROM vehicle_extra t0 WHERE t0.id = '2029';

SELECT
  t0.id AS id_1,
  t0.option_id AS option_id_2,
  t0.option_name AS option_name_3,
  t0.option_price AS option_price_4
FROM
  vehicle_extra t0
  INNER JOIN vehicle_vehicle_extra ON t0.id = vehicle_vehicle_extra.vehicle_extra_id
WHERE
  vehicle_vehicle_extra.vehicle_id = ?

SELECT t0.id AS id_1, t0.option_id AS option_id_2, t0.option_name AS option_name_3, t0.option_price AS option_price_4 FROM vehicle_extra t0 INNER JOIN vehicle_vehicle_extra ON t0.id = vehicle_vehicle_extra.vehicle_extra_id WHERE vehicle_vehicle_extra.vehicle_id = 379;