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
  categorySlug IN ('berlina')
ORDER BY
  installment DESC

SELECT * FROM read_proposal_list WHERE categorySlug IN ('berlina') ORDER BY installment DESC;

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(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(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
  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.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
  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;