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.privacy_policy_url AS privacy_policy_url_14,
  t0.information_notice_url AS information_notice_url_15,
  t0.terms_and_conditions_url AS terms_and_conditions_url_16,
  t0.brand_phone AS brand_phone_17,
  t0.brand_email AS brand_email_18,
  t0.brand_open_hours AS brand_open_hours_19,
  t0.external_brand_id AS external_brand_id_20,
  t0.brand_logo_url AS brand_logo_url_21,
  t0.external_order_id AS external_order_id_22,
  t0.rci_proposal_id AS rci_proposal_id_23,
  t0.rci_proposal_status AS rci_proposal_status_24,
  t0.contact_consents_sms AS contact_consents_sms_25,
  t0.contact_consents_email AS contact_consents_email_26,
  t0.contact_consents_post AS contact_consents_post_27,
  t0.contact_consents_telephone AS contact_consents_telephone_28,
  t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_29,
  t0.eula_consents_information_notice AS eula_consents_information_notice_30,
  t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_31,
  t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_32,
  t0.private_individual_id AS private_individual_id_33,
  t34.prefix_title AS prefix_title_35,
  t34.first_name AS first_name_36,
  t34.middle_name AS middle_name_37,
  t34.surname AS surname_38,
  t34.birthday AS birthday_39,
  t34.nationality AS nationality_40,
  t34.number_of_financial_dependants AS number_of_financial_dependants_41,
  t34.marital_status AS marital_status_42,
  t34.driving_licence_number AS driving_licence_number_43,
  t34.gender AS gender_44,
  t34.driving_license_issue_date AS driving_license_issue_date_45,
  t34.driving_license_expiry_date AS driving_license_expiry_date_46,
  t34.previous_surname AS previous_surname_47,
  t34.id AS id_48,
  t34.comments AS comments_49,
  t34.additional_info_health_corners AS additional_info_health_corners_50,
  t34.employment_id AS employment_id_51,
  t34.financial_id AS financial_id_52,
  t34.contact_id AS contact_id_53,
  t34.address_id AS address_id_54,
  t0.company_id AS company_id_55,
  t56.id AS id_57,
  t56.company_name AS company_name_58,
  t56.trading_name AS trading_name_59,
  t56.registration_number AS registration_number_60,
  t56.vat_registered AS vat_registered_61,
  t56.vat_number AS vat_number_62,
  t56.comments AS comments_63,
  t56.company_fleet_fleet_size AS company_fleet_fleet_size_64,
  t56.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_65,
  t56.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_66,
  t56.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_67,
  t56.address_id AS address_id_68,
  t56.contact_id AS contact_id_69,
  t56.bank_details_id AS bank_details_id_70,
  t0.partnership_id AS partnership_id_71,
  t72.id AS id_73,
  t72.trading_name AS trading_name_74,
  t72.comments AS comments_75,
  t72.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_76,
  t72.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_77,
  t72.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_78,
  t72.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_79,
  t72.address_id AS address_id_80,
  t72.contact_id AS contact_id_81,
  t72.bank_details_id AS bank_details_id_82,
  t0.sole_trader_id AS sole_trader_id_83,
  t84.prefix_title AS prefix_title_85,
  t84.first_name AS first_name_86,
  t84.middle_name AS middle_name_87,
  t84.surname AS surname_88,
  t84.birthday AS birthday_89,
  t84.nationality AS nationality_90,
  t84.number_of_financial_dependants AS number_of_financial_dependants_91,
  t84.marital_status AS marital_status_92,
  t84.driving_licence_number AS driving_licence_number_93,
  t84.gender AS gender_94,
  t84.driving_license_issue_date AS driving_license_issue_date_95,
  t84.driving_license_expiry_date AS driving_license_expiry_date_96,
  t84.previous_surname AS previous_surname_97,
  t84.id AS id_98,
  t84.trading_name AS trading_name_99,
  t84.nature_of_business AS nature_of_business_100,
  t84.trading_since AS trading_since_101,
  t84.comments AS comments_102,
  t84.additional_info_health_corners AS additional_info_health_corners_103,
  t84.trading_address_id AS trading_address_id_104,
  t84.financial_id AS financial_id_105,
  t84.employment_id AS employment_id_106,
  t84.address_id AS address_id_107,
  t84.contact_id AS contact_id_108,
  t0.vehicle_id AS vehicle_id_109,
  t110.id AS id_111,
  t110.cap_id AS cap_id_112,
  t110.cap_code AS cap_code_113,
  t110.type AS type_114,
  t110.manufacturer_name AS manufacturer_name_115,
  t110.model_name AS model_name_116,
  t110.model_short_name AS model_short_name_117,
  t110.model_year AS model_year_118,
  t110.deal_type AS deal_type_119,
  t110.vehicle_name AS vehicle_name_120,
  t110.contract_length AS contract_length_121,
  t110.monthly_rate AS monthly_rate_122,
  t110.maintenance_monthly_rate AS maintenance_monthly_rate_123,
  t110.initial_payment AS initial_payment_124,
  t110.includes_vat AS includes_vat_125,
  t110.annual_mileage AS annual_mileage_126,
  t110.processing_fee AS processing_fee_127,
  t110.dealership_code AS dealership_code_128,
  t110.product_code AS product_code_129,
  t110.dealer_discount AS dealer_discount_130,
  t110.gross_yearly_road_tax AS gross_yearly_road_tax_131,
  t110.government_adjustment AS government_adjustment_132,
  t110.color_id AS color_id_133,
  t110.trim_id AS trim_id_134
FROM
  application t0
  LEFT JOIN private_individual t34 ON t0.private_individual_id = t34.id
  LEFT JOIN company t56 ON t0.company_id = t56.id
  LEFT JOIN partnership t72 ON t0.partnership_id = t72.id
  LEFT JOIN sole_trader t84 ON t0.sole_trader_id = t84.id
  LEFT JOIN vehicle t110 ON t0.vehicle_id = t110.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.privacy_policy_url AS privacy_policy_url_14, t0.information_notice_url AS information_notice_url_15, t0.terms_and_conditions_url AS terms_and_conditions_url_16, t0.brand_phone AS brand_phone_17, t0.brand_email AS brand_email_18, t0.brand_open_hours AS brand_open_hours_19, t0.external_brand_id AS external_brand_id_20, t0.brand_logo_url AS brand_logo_url_21, t0.external_order_id AS external_order_id_22, t0.rci_proposal_id AS rci_proposal_id_23, t0.rci_proposal_status AS rci_proposal_status_24, t0.contact_consents_sms AS contact_consents_sms_25, t0.contact_consents_email AS contact_consents_email_26, t0.contact_consents_post AS contact_consents_post_27, t0.contact_consents_telephone AS contact_consents_telephone_28, t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_29, t0.eula_consents_information_notice AS eula_consents_information_notice_30, t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_31, t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_32, t0.private_individual_id AS private_individual_id_33, t34.prefix_title AS prefix_title_35, t34.first_name AS first_name_36, t34.middle_name AS middle_name_37, t34.surname AS surname_38, t34.birthday AS birthday_39, t34.nationality AS nationality_40, t34.number_of_financial_dependants AS number_of_financial_dependants_41, t34.marital_status AS marital_status_42, t34.driving_licence_number AS driving_licence_number_43, t34.gender AS gender_44, t34.driving_license_issue_date AS driving_license_issue_date_45, t34.driving_license_expiry_date AS driving_license_expiry_date_46, t34.previous_surname AS previous_surname_47, t34.id AS id_48, t34.comments AS comments_49, t34.additional_info_health_corners AS additional_info_health_corners_50, t34.employment_id AS employment_id_51, t34.financial_id AS financial_id_52, t34.contact_id AS contact_id_53, t34.address_id AS address_id_54, t0.company_id AS company_id_55, t56.id AS id_57, t56.company_name AS company_name_58, t56.trading_name AS trading_name_59, t56.registration_number AS registration_number_60, t56.vat_registered AS vat_registered_61, t56.vat_number AS vat_number_62, t56.comments AS comments_63, t56.company_fleet_fleet_size AS company_fleet_fleet_size_64, t56.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_65, t56.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_66, t56.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_67, t56.address_id AS address_id_68, t56.contact_id AS contact_id_69, t56.bank_details_id AS bank_details_id_70, t0.partnership_id AS partnership_id_71, t72.id AS id_73, t72.trading_name AS trading_name_74, t72.comments AS comments_75, t72.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_76, t72.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_77, t72.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_78, t72.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_79, t72.address_id AS address_id_80, t72.contact_id AS contact_id_81, t72.bank_details_id AS bank_details_id_82, t0.sole_trader_id AS sole_trader_id_83, t84.prefix_title AS prefix_title_85, t84.first_name AS first_name_86, t84.middle_name AS middle_name_87, t84.surname AS surname_88, t84.birthday AS birthday_89, t84.nationality AS nationality_90, t84.number_of_financial_dependants AS number_of_financial_dependants_91, t84.marital_status AS marital_status_92, t84.driving_licence_number AS driving_licence_number_93, t84.gender AS gender_94, t84.driving_license_issue_date AS driving_license_issue_date_95, t84.driving_license_expiry_date AS driving_license_expiry_date_96, t84.previous_surname AS previous_surname_97, t84.id AS id_98, t84.trading_name AS trading_name_99, t84.nature_of_business AS nature_of_business_100, t84.trading_since AS trading_since_101, t84.comments AS comments_102, t84.additional_info_health_corners AS additional_info_health_corners_103, t84.trading_address_id AS trading_address_id_104, t84.financial_id AS financial_id_105, t84.employment_id AS employment_id_106, t84.address_id AS address_id_107, t84.contact_id AS contact_id_108, t0.vehicle_id AS vehicle_id_109, t110.id AS id_111, t110.cap_id AS cap_id_112, t110.cap_code AS cap_code_113, t110.type AS type_114, t110.manufacturer_name AS manufacturer_name_115, t110.model_name AS model_name_116, t110.model_short_name AS model_short_name_117, t110.model_year AS model_year_118, t110.deal_type AS deal_type_119, t110.vehicle_name AS vehicle_name_120, t110.contract_length AS contract_length_121, t110.monthly_rate AS monthly_rate_122, t110.maintenance_monthly_rate AS maintenance_monthly_rate_123, t110.initial_payment AS initial_payment_124, t110.includes_vat AS includes_vat_125, t110.annual_mileage AS annual_mileage_126, t110.processing_fee AS processing_fee_127, t110.dealership_code AS dealership_code_128, t110.product_code AS product_code_129, t110.dealer_discount AS dealer_discount_130, t110.gross_yearly_road_tax AS gross_yearly_road_tax_131, t110.government_adjustment AS government_adjustment_132, t110.color_id AS color_id_133, t110.trim_id AS trim_id_134 FROM application t0 LEFT JOIN private_individual t34 ON t0.private_individual_id = t34.id LEFT JOIN company t56 ON t0.company_id = t56.id LEFT JOIN partnership t72 ON t0.partnership_id = t72.id LEFT JOIN sole_trader t84 ON t0.sole_trader_id = t84.id LEFT JOIN vehicle t110 ON t0.vehicle_id = t110.id WHERE t0.uuid = 0x1F1BF2D4B2B867F48D17137551EC5162 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 = '3647';

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 = 763;