Symfony Profiler

SELECT
  DISTINCT p0_.gearbox_slug AS gearbox_slug_0,
  p0_.gearbox AS gearbox_1
FROM
  proposal p0_
WHERE
  p0_.publishing_status = 'published'
ORDER BY
  p0_.gearbox ASC

SELECT DISTINCT p0_.gearbox_slug AS gearbox_slug_0, p0_.gearbox AS gearbox_1 FROM proposal p0_ WHERE p0_.publishing_status = 'published' ORDER BY p0_.gearbox ASC;

SELECT
  DISTINCT p0_.brand_slug AS brand_slug_0,
  p0_.brand_name AS brand_name_1
FROM
  proposal p0_
WHERE
  p0_.publishing_status = 'published'
ORDER BY
  p0_.brand_name ASC

SELECT DISTINCT p0_.brand_slug AS brand_slug_0, p0_.brand_name AS brand_name_1 FROM proposal p0_ WHERE p0_.publishing_status = 'published' ORDER BY p0_.brand_name ASC;

SELECT
  DISTINCT p0_.category_slug AS category_slug_0,
  p0_.category_name AS category_name_1
FROM
  proposal p0_
WHERE
  p0_.publishing_status = 'published'
ORDER BY
  p0_.category_name ASC

SELECT DISTINCT p0_.category_slug AS category_slug_0, p0_.category_name AS category_name_1 FROM proposal p0_ WHERE p0_.publishing_status = 'published' ORDER BY p0_.category_name ASC;

SELECT
  DISTINCT p0_.model_slug AS model_slug_0,
  p0_.model_name AS model_name_1
FROM
  proposal p0_
WHERE
  p0_.publishing_status = 'published'
ORDER BY
  p0_.model_name ASC

SELECT DISTINCT p0_.model_slug AS model_slug_0, p0_.model_name AS model_name_1 FROM proposal p0_ WHERE p0_.publishing_status = 'published' ORDER BY p0_.model_name ASC;

SELECT
  DISTINCT p0_.fuel_slug AS fuel_slug_0,
  p0_.fuel_name AS fuel_name_1
FROM
  proposal p0_
WHERE
  p0_.publishing_status = 'published'
ORDER BY
  p0_.fuel_name ASC

SELECT DISTINCT p0_.fuel_slug AS fuel_slug_0, p0_.fuel_name AS fuel_name_1 FROM proposal p0_ WHERE p0_.publishing_status = 'published' ORDER BY p0_.fuel_name ASC;

SELECT
  *
FROM
  read_proposal_list
WHERE
  noviceDriver = 1
ORDER BY
  installment ASC

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

SELECT
  min(p0_.price) AS sclr_0
FROM
  proposal p1_
  LEFT JOIN proposal_price p0_ ON (p1_.id = p0_.proposal_id)
WHERE
  p1_.publishing_status = 'published'

SELECT min(p0_.price) AS sclr_0 FROM proposal p1_ LEFT JOIN proposal_price p0_ ON (p1_.id = p0_.proposal_id) WHERE p1_.publishing_status = 'published';

SELECT
  max(installment)
FROM
  read_proposal_list

SELECT max(installment) FROM read_proposal_list;

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.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.campaign_id AS campaign_id_8
FROM
  campaign_banner t0
WHERE
  t0.campaign_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.campaign_id AS campaign_id_8 FROM campaign_banner t0 WHERE t0.campaign_id IN ('3ff2091f-6ef1-4727-a717-ed2f8c3da611') ORDER BY t0.ordering ASC;

SELECT
  t0.id AS id_1,
  t0.proposal_id AS proposal_id_2,
  t0.brand_name AS brand_name_3,
  t0.model_name AS model_name_4,
  t0.campaign_id AS campaign_id_5
FROM
  campaign_proposal t0
WHERE
  t0.campaign_id IN (?)
ORDER BY
  t0.brand_name ASC,
  t0.model_name ASC

SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.brand_name AS brand_name_3, t0.model_name AS model_name_4, t0.campaign_id AS campaign_id_5 FROM campaign_proposal t0 WHERE t0.campaign_id IN ('3ff2091f-6ef1-4727-a717-ed2f8c3da611') ORDER BY t0.brand_name ASC, t0.model_name 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.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.branding_id AS branding_id_8
FROM
  branding_banner t0
WHERE
  t0.branding_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.branding_id AS branding_id_8 FROM branding_banner t0 WHERE t0.branding_id IN ('7d0f460a-cc7e-4acd-9e4c-038be7d25abb') ORDER BY t0.ordering 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;