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.brand_identifier AS brand_identifier_20,
  t0.rci_proposal_id AS rci_proposal_id_21,
  t0.rci_proposal_status AS rci_proposal_status_22,
  t0.contact_consents_sms AS contact_consents_sms_23,
  t0.contact_consents_email AS contact_consents_email_24,
  t0.contact_consents_post AS contact_consents_post_25,
  t0.contact_consents_telephone AS contact_consents_telephone_26,
  t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_27,
  t0.eula_consents_information_notice AS eula_consents_information_notice_28,
  t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_29,
  t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_30,
  t0.private_individual_id AS private_individual_id_31,
  t32.prefix_title AS prefix_title_33,
  t32.first_name AS first_name_34,
  t32.middle_name AS middle_name_35,
  t32.surname AS surname_36,
  t32.birthday AS birthday_37,
  t32.nationality AS nationality_38,
  t32.number_of_financial_dependants AS number_of_financial_dependants_39,
  t32.marital_status AS marital_status_40,
  t32.driving_licence_number AS driving_licence_number_41,
  t32.gender AS gender_42,
  t32.driving_license_issue_date AS driving_license_issue_date_43,
  t32.driving_license_expiry_date AS driving_license_expiry_date_44,
  t32.previous_surname AS previous_surname_45,
  t32.id AS id_46,
  t32.comments AS comments_47,
  t32.employment_id AS employment_id_48,
  t32.financial_id AS financial_id_49,
  t32.contact_id AS contact_id_50,
  t32.address_id AS address_id_51,
  t0.company_id AS company_id_52,
  t53.id AS id_54,
  t53.company_name AS company_name_55,
  t53.trading_name AS trading_name_56,
  t53.registration_number AS registration_number_57,
  t53.vat_registered AS vat_registered_58,
  t53.vat_number AS vat_number_59,
  t53.comments AS comments_60,
  t53.company_fleet_fleet_size AS company_fleet_fleet_size_61,
  t53.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_62,
  t53.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_63,
  t53.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_64,
  t53.address_id AS address_id_65,
  t53.contact_id AS contact_id_66,
  t53.bank_details_id AS bank_details_id_67,
  t0.partnership_id AS partnership_id_68,
  t69.id AS id_70,
  t69.trading_name AS trading_name_71,
  t69.comments AS comments_72,
  t69.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_73,
  t69.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_74,
  t69.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_75,
  t69.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_76,
  t69.address_id AS address_id_77,
  t69.contact_id AS contact_id_78,
  t69.bank_details_id AS bank_details_id_79,
  t0.sole_trader_id AS sole_trader_id_80,
  t81.prefix_title AS prefix_title_82,
  t81.first_name AS first_name_83,
  t81.middle_name AS middle_name_84,
  t81.surname AS surname_85,
  t81.birthday AS birthday_86,
  t81.nationality AS nationality_87,
  t81.number_of_financial_dependants AS number_of_financial_dependants_88,
  t81.marital_status AS marital_status_89,
  t81.driving_licence_number AS driving_licence_number_90,
  t81.gender AS gender_91,
  t81.driving_license_issue_date AS driving_license_issue_date_92,
  t81.driving_license_expiry_date AS driving_license_expiry_date_93,
  t81.previous_surname AS previous_surname_94,
  t81.id AS id_95,
  t81.trading_name AS trading_name_96,
  t81.nature_of_business AS nature_of_business_97,
  t81.trading_since AS trading_since_98,
  t81.comments AS comments_99,
  t81.trading_address_id AS trading_address_id_100,
  t81.bank_details_id AS bank_details_id_101,
  t81.employment_id AS employment_id_102,
  t81.address_id AS address_id_103,
  t81.contact_id AS contact_id_104,
  t0.vehicle_id AS vehicle_id_105,
  t106.id AS id_107,
  t106.cap_id AS cap_id_108,
  t106.cap_code AS cap_code_109,
  t106.type AS type_110,
  t106.manufacturer_name AS manufacturer_name_111,
  t106.model_name AS model_name_112,
  t106.model_short_name AS model_short_name_113,
  t106.model_year AS model_year_114,
  t106.deal_type AS deal_type_115,
  t106.vehicle_name AS vehicle_name_116,
  t106.contract_length AS contract_length_117,
  t106.monthly_rate AS monthly_rate_118,
  t106.maintenance_monthly_rate AS maintenance_monthly_rate_119,
  t106.initial_payment AS initial_payment_120,
  t106.includes_vat AS includes_vat_121,
  t106.annual_mileage AS annual_mileage_122,
  t106.processing_fee AS processing_fee_123,
  t106.dealership_code AS dealership_code_124,
  t106.product_code AS product_code_125,
  t106.dealer_discount AS dealer_discount_126,
  t106.gross_yearly_road_tax AS gross_yearly_road_tax_127,
  t106.government_adjustment AS government_adjustment_128,
  t106.color_id AS color_id_129,
  t106.trim_id AS trim_id_130
FROM
  application t0
  LEFT JOIN private_individual t32 ON t0.private_individual_id = t32.id
  LEFT JOIN company t53 ON t0.company_id = t53.id
  LEFT JOIN partnership t69 ON t0.partnership_id = t69.id
  LEFT JOIN sole_trader t81 ON t0.sole_trader_id = t81.id
  LEFT JOIN vehicle t106 ON t0.vehicle_id = t106.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.brand_identifier AS brand_identifier_20, t0.rci_proposal_id AS rci_proposal_id_21, t0.rci_proposal_status AS rci_proposal_status_22, t0.contact_consents_sms AS contact_consents_sms_23, t0.contact_consents_email AS contact_consents_email_24, t0.contact_consents_post AS contact_consents_post_25, t0.contact_consents_telephone AS contact_consents_telephone_26, t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_27, t0.eula_consents_information_notice AS eula_consents_information_notice_28, t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_29, t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_30, t0.private_individual_id AS private_individual_id_31, t32.prefix_title AS prefix_title_33, t32.first_name AS first_name_34, t32.middle_name AS middle_name_35, t32.surname AS surname_36, t32.birthday AS birthday_37, t32.nationality AS nationality_38, t32.number_of_financial_dependants AS number_of_financial_dependants_39, t32.marital_status AS marital_status_40, t32.driving_licence_number AS driving_licence_number_41, t32.gender AS gender_42, t32.driving_license_issue_date AS driving_license_issue_date_43, t32.driving_license_expiry_date AS driving_license_expiry_date_44, t32.previous_surname AS previous_surname_45, t32.id AS id_46, t32.comments AS comments_47, t32.employment_id AS employment_id_48, t32.financial_id AS financial_id_49, t32.contact_id AS contact_id_50, t32.address_id AS address_id_51, t0.company_id AS company_id_52, t53.id AS id_54, t53.company_name AS company_name_55, t53.trading_name AS trading_name_56, t53.registration_number AS registration_number_57, t53.vat_registered AS vat_registered_58, t53.vat_number AS vat_number_59, t53.comments AS comments_60, t53.company_fleet_fleet_size AS company_fleet_fleet_size_61, t53.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_62, t53.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_63, t53.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_64, t53.address_id AS address_id_65, t53.contact_id AS contact_id_66, t53.bank_details_id AS bank_details_id_67, t0.partnership_id AS partnership_id_68, t69.id AS id_70, t69.trading_name AS trading_name_71, t69.comments AS comments_72, t69.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_73, t69.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_74, t69.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_75, t69.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_76, t69.address_id AS address_id_77, t69.contact_id AS contact_id_78, t69.bank_details_id AS bank_details_id_79, t0.sole_trader_id AS sole_trader_id_80, t81.prefix_title AS prefix_title_82, t81.first_name AS first_name_83, t81.middle_name AS middle_name_84, t81.surname AS surname_85, t81.birthday AS birthday_86, t81.nationality AS nationality_87, t81.number_of_financial_dependants AS number_of_financial_dependants_88, t81.marital_status AS marital_status_89, t81.driving_licence_number AS driving_licence_number_90, t81.gender AS gender_91, t81.driving_license_issue_date AS driving_license_issue_date_92, t81.driving_license_expiry_date AS driving_license_expiry_date_93, t81.previous_surname AS previous_surname_94, t81.id AS id_95, t81.trading_name AS trading_name_96, t81.nature_of_business AS nature_of_business_97, t81.trading_since AS trading_since_98, t81.comments AS comments_99, t81.trading_address_id AS trading_address_id_100, t81.bank_details_id AS bank_details_id_101, t81.employment_id AS employment_id_102, t81.address_id AS address_id_103, t81.contact_id AS contact_id_104, t0.vehicle_id AS vehicle_id_105, t106.id AS id_107, t106.cap_id AS cap_id_108, t106.cap_code AS cap_code_109, t106.type AS type_110, t106.manufacturer_name AS manufacturer_name_111, t106.model_name AS model_name_112, t106.model_short_name AS model_short_name_113, t106.model_year AS model_year_114, t106.deal_type AS deal_type_115, t106.vehicle_name AS vehicle_name_116, t106.contract_length AS contract_length_117, t106.monthly_rate AS monthly_rate_118, t106.maintenance_monthly_rate AS maintenance_monthly_rate_119, t106.initial_payment AS initial_payment_120, t106.includes_vat AS includes_vat_121, t106.annual_mileage AS annual_mileage_122, t106.processing_fee AS processing_fee_123, t106.dealership_code AS dealership_code_124, t106.product_code AS product_code_125, t106.dealer_discount AS dealer_discount_126, t106.gross_yearly_road_tax AS gross_yearly_road_tax_127, t106.government_adjustment AS government_adjustment_128, t106.color_id AS color_id_129, t106.trim_id AS trim_id_130 FROM application t0 LEFT JOIN private_individual t32 ON t0.private_individual_id = t32.id LEFT JOIN company t53 ON t0.company_id = t53.id LEFT JOIN partnership t69 ON t0.partnership_id = t69.id LEFT JOIN sole_trader t81 ON t0.sole_trader_id = t81.id LEFT JOIN vehicle t106 ON t0.vehicle_id = t106.id WHERE t0.uuid = 0x1F18F50335FD68BCBD0FF1F2E710950A 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 = '2623';

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 = '2624';

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