Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.discount AS discount_6,
  t0.linear_badge AS linear_badge_7,
  t0.linear_badge_color AS linear_badge_color_8,
  t0.round_badge AS round_badge_9,
  t0.round_badge_color AS round_badge_color_10,
  t0.ribbon_badge AS ribbon_badge_11,
  t0.ribbon_badge_color AS ribbon_badge_color_12,
  t0.created_at AS created_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.publishing_status AS publishing_status_15
FROM
  campaign t0
WHERE
  t0.deleted_at IS NULL
  AND t0.publishing_status = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.discount AS discount_6, t0.linear_badge AS linear_badge_7, t0.linear_badge_color AS linear_badge_color_8, t0.round_badge AS round_badge_9, t0.round_badge_color AS round_badge_color_10, t0.ribbon_badge AS ribbon_badge_11, t0.ribbon_badge_color AS ribbon_badge_color_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15 FROM campaign t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = 'published';

SELECT
  t0.id AS id_1,
  t0.brand_name AS brand_name_2,
  t0.brand_slug AS brand_slug_3,
  t0.model_name AS model_name_4,
  t0.model_slug AS model_slug_5,
  t0.version AS version_6,
  t0.doors AS doors_7,
  t0.gearbox AS gearbox_8,
  t0.gearbox_slug AS gearbox_slug_9,
  t0.power_hp AS power_hp_10,
  t0.power_kw AS power_kw_11,
  t0.category_name AS category_name_12,
  t0.category_slug AS category_slug_13,
  t0.convertible_to_truck AS convertible_to_truck_14,
  t0.new_driver AS new_driver_15,
  t0.private AS private_16,
  t0.business AS business_17,
  t0.fleet AS fleet_18,
  t0.emission AS emission_19,
  t0.fuel_name AS fuel_name_20,
  t0.fuel_slug AS fuel_slug_21,
  t0.displacement AS displacement_22,
  t0.drive AS drive_23,
  t0.average_consumption AS average_consumption_24,
  t0.video_id AS video_id_25,
  t0.priority AS priority_26,
  t0.ready_to_deliver AS ready_to_deliver_27,
  t0.adv AS adv_28,
  t0.featured AS featured_29,
  t0.linear_badge AS linear_badge_30,
  t0.linear_badge_color AS linear_badge_color_31,
  t0.round_badge AS round_badge_32,
  t0.round_badge_color AS round_badge_color_33,
  t0.ribbon_badge AS ribbon_badge_34,
  t0.ribbon_badge_color AS ribbon_badge_color_35,
  t0.legal_rca_limit AS legal_rca_limit_36,
  t0.legal_rca_excess AS legal_rca_excess_37,
  t0.legal_theft_excess AS legal_theft_excess_38,
  t0.legal_kasko_excess AS legal_kasko_excess_39,
  t0.legal_accident_limit AS legal_accident_limit_40,
  t0.legal_accident_excess AS legal_accident_excess_41,
  t0.sizes AS sizes_42,
  t0.capacity AS capacity_43,
  t0.seats AS seats_44,
  t0.created_at AS created_at_45,
  t0.deleted_at AS deleted_at_46,
  t0.publishing_status AS publishing_status_47,
  t0.first_price_id AS first_price_id_48
FROM
  proposal t0
WHERE
  t0.id = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.model_name AS model_name_4, t0.model_slug AS model_slug_5, t0.version AS version_6, t0.doors AS doors_7, t0.gearbox AS gearbox_8, t0.gearbox_slug AS gearbox_slug_9, t0.power_hp AS power_hp_10, t0.power_kw AS power_kw_11, t0.category_name AS category_name_12, t0.category_slug AS category_slug_13, t0.convertible_to_truck AS convertible_to_truck_14, t0.new_driver AS new_driver_15, t0.private AS private_16, t0.business AS business_17, t0.fleet AS fleet_18, t0.emission AS emission_19, t0.fuel_name AS fuel_name_20, t0.fuel_slug AS fuel_slug_21, t0.displacement AS displacement_22, t0.drive AS drive_23, t0.average_consumption AS average_consumption_24, t0.video_id AS video_id_25, t0.priority AS priority_26, t0.ready_to_deliver AS ready_to_deliver_27, t0.adv AS adv_28, t0.featured AS featured_29, t0.linear_badge AS linear_badge_30, t0.linear_badge_color AS linear_badge_color_31, t0.round_badge AS round_badge_32, t0.round_badge_color AS round_badge_color_33, t0.ribbon_badge AS ribbon_badge_34, t0.ribbon_badge_color AS ribbon_badge_color_35, t0.legal_rca_limit AS legal_rca_limit_36, t0.legal_rca_excess AS legal_rca_excess_37, t0.legal_theft_excess AS legal_theft_excess_38, t0.legal_kasko_excess AS legal_kasko_excess_39, t0.legal_accident_limit AS legal_accident_limit_40, t0.legal_accident_excess AS legal_accident_excess_41, t0.sizes AS sizes_42, t0.capacity AS capacity_43, t0.seats AS seats_44, t0.created_at AS created_at_45, t0.deleted_at AS deleted_at_46, t0.publishing_status AS publishing_status_47, t0.first_price_id AS first_price_id_48 FROM proposal t0 WHERE t0.id = '0efc37be-04e2-499b-b3d3-a5c47a24a6d8' AND t0.deleted_at IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.alt AS alt_3,
  t0.src AS src_4,
  t0.original_src AS original_src_5,
  t0.ordering AS ordering_6,
  t0.published AS published_7,
  t0.proposal_id AS proposal_id_8
FROM
  proposal_image t0
WHERE
  t0.proposal_id IN (?)
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.alt AS alt_3, t0.src AS src_4, t0.original_src AS original_src_5, t0.ordering AS ordering_6, t0.published AS published_7, t0.proposal_id AS proposal_id_8 FROM proposal_image t0 WHERE t0.proposal_id IN ('0efc37be-04e2-499b-b3d3-a5c47a24a6d8') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.deposit AS deposit_3,
  t0.duration AS duration_4,
  t0.distance AS distance_5,
  t0.proposal_id AS proposal_id_6
FROM
  proposal_price t0
WHERE
  t0.proposal_id IN (?)
ORDER BY
  t0.price ASC

SELECT t0.id AS id_1, t0.price AS price_2, t0.deposit AS deposit_3, t0.duration AS duration_4, t0.distance AS distance_5, t0.proposal_id AS proposal_id_6 FROM proposal_price t0 WHERE t0.proposal_id IN ('0efc37be-04e2-499b-b3d3-a5c47a24a6d8') ORDER BY t0.price ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.publishing_status AS publishing_status_7
FROM
  branding t0
WHERE
  t0.active = ?
  AND t0.deleted_at IS NULL
  AND t0.publishing_status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.publishing_status AS publishing_status_7 FROM branding t0 WHERE t0.active = 1 AND t0.deleted_at IS NULL AND t0.publishing_status = 'published' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.publishing_status AS publishing_status_7
FROM
  branding t0
WHERE
  t0.active = ?
  AND t0.deleted_at IS NULL
  AND t0.publishing_status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.publishing_status AS publishing_status_7 FROM branding t0 WHERE t0.active = 1 AND t0.deleted_at IS NULL AND t0.publishing_status = 'published' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.publishing_status AS publishing_status_7
FROM
  branding t0
WHERE
  t0.active = ?
  AND t0.deleted_at IS NULL
  AND t0.publishing_status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.publishing_status AS publishing_status_7 FROM branding t0 WHERE t0.active = 1 AND t0.deleted_at IS NULL AND t0.publishing_status = 'published' LIMIT 1;

SELECT
  *
FROM
  read_proposal_list
WHERE
  fastDelivery = ?
ORDER BY
  installment ASC

SELECT * FROM read_proposal_list WHERE fastDelivery = '1' ORDER BY installment ASC;