Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.icon AS icon_5
FROM
  offer_service t0
  INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id
WHERE
  offer_service_relation.offer_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.icon AS icon_5 FROM offer_service t0 INNER JOIN offer_service_relation ON t0.id = offer_service_relation.service_id WHERE offer_service_relation.offer_id = 'b409128e-b115-486f-84a1-63f27fb66250';

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.car_id AS car_id_7
FROM
  car_image t0
WHERE
  t0.car_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.car_id AS car_id_7 FROM car_image t0 WHERE t0.car_id IN ('7e96092b-aa5c-494d-983b-3c847dc46fd3') 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.offer_id AS offer_id_6
FROM
  offer_variation t0
WHERE
  t0.offer_id IN (?)

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.offer_id AS offer_id_6 FROM offer_variation t0 WHERE t0.offer_id IN ('b409128e-b115-486f-84a1-63f27fb66250');

SELECT
  t0.id AS id_1,
  t0.brand_name AS brand_name_2,
  t0.brand_slug AS brand_slug_3,
  t0.fuel_name AS fuel_name_4,
  t0.fuel_slug AS fuel_slug_5,
  t0.category_name AS category_name_6,
  t0.category_slug AS category_slug_7,
  t0.model_name AS model_name_8,
  t0.model_slug AS model_slug_9,
  t0.version AS version_10,
  t0.displacement AS displacement_11,
  t0.power AS power_12,
  t0.drive AS drive_13,
  t0.average_consumption AS average_consumption_14,
  t0.emission AS emission_15,
  t0.sizes AS sizes_16,
  t0.capacity AS capacity_17,
  t0.seats AS seats_18,
  t0.doors AS doors_19,
  t0.gearbox AS gearbox_20,
  t0.gearbox_slug AS gearbox_slug_21
FROM
  car t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_slug AS brand_slug_3, t0.fuel_name AS fuel_name_4, t0.fuel_slug AS fuel_slug_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.model_name AS model_name_8, t0.model_slug AS model_slug_9, t0.version AS version_10, t0.displacement AS displacement_11, t0.power AS power_12, t0.drive AS drive_13, t0.average_consumption AS average_consumption_14, t0.emission AS emission_15, t0.sizes AS sizes_16, t0.capacity AS capacity_17, t0.seats AS seats_18, t0.doors AS doors_19, t0.gearbox AS gearbox_20, t0.gearbox_slug AS gearbox_slug_21 FROM car t0 WHERE t0.id IN ('7e96092b-aa5c-494d-983b-3c847dc46fd3');

SELECT
  o0_.id AS id_0,
  o0_.webid AS webid_1,
  o0_.code AS code_2,
  o0_.price AS price_3,
  o0_.deposit AS deposit_4,
  o0_.duration AS duration_5,
  o0_.distance AS distance_6,
  o0_.notes AS notes_7,
  o0_.left_label AS left_label_8,
  o0_.right_label AS right_label_9,
  o0_.fast_delivery AS fast_delivery_10,
  o0_.delivery_time AS delivery_time_11,
  o0_.tag AS tag_12,
  o0_.secondary_tag AS secondary_tag_13,
  o0_.seolink AS seolink_14,
  o0_.status AS status_15,
  o0_.created_at AS created_at_16,
  o0_.updated_at AS updated_at_17,
  o0_.deleted_at AS deleted_at_18,
  o0_.featured AS featured_19,
  o0_.catalog AS catalog_20,
  o0_.published AS published_21,
  o0_.private AS private_22,
  o0_.for_company AS for_company_23,
  o0_.video_id AS video_id_24,
  o0_.last_import_at AS last_import_at_25,
  o0_.priority AS priority_26,
  o0_.adv AS adv_27,
  o0_.linear_badge AS linear_badge_28,
  o0_.linear_badge_color AS linear_badge_color_29,
  o0_.round_badge AS round_badge_30,
  o0_.round_badge_color AS round_badge_color_31,
  o0_.ribbon_badge AS ribbon_badge_32,
  o0_.ribbon_badge_color AS ribbon_badge_color_33,
  o0_.provider AS provider_34,
  o0_.image_lock AS image_lock_35,
  o0_.booked AS booked_36,
  o0_.booked_by AS booked_by_37,
  o0_.booked_at AS booked_at_38,
  o0_.car_id AS car_id_39
FROM
  offer o0_
  LEFT JOIN car c1_ ON o0_.car_id = c1_.id
WHERE
  o0_.published = 1
  AND c1_.category_slug IN ('suv-crossover')
ORDER BY
  o0_.priority DESC,
  o0_.price ASC

SELECT o0_.id AS id_0, o0_.webid AS webid_1, o0_.code AS code_2, o0_.price AS price_3, o0_.deposit AS deposit_4, o0_.duration AS duration_5, o0_.distance AS distance_6, o0_.notes AS notes_7, o0_.left_label AS left_label_8, o0_.right_label AS right_label_9, o0_.fast_delivery AS fast_delivery_10, o0_.delivery_time AS delivery_time_11, o0_.tag AS tag_12, o0_.secondary_tag AS secondary_tag_13, o0_.seolink AS seolink_14, o0_.status AS status_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.deleted_at AS deleted_at_18, o0_.featured AS featured_19, o0_.catalog AS catalog_20, o0_.published AS published_21, o0_.private AS private_22, o0_.for_company AS for_company_23, o0_.video_id AS video_id_24, o0_.last_import_at AS last_import_at_25, o0_.priority AS priority_26, o0_.adv AS adv_27, o0_.linear_badge AS linear_badge_28, o0_.linear_badge_color AS linear_badge_color_29, o0_.round_badge AS round_badge_30, o0_.round_badge_color AS round_badge_color_31, o0_.ribbon_badge AS ribbon_badge_32, o0_.ribbon_badge_color AS ribbon_badge_color_33, o0_.provider AS provider_34, o0_.image_lock AS image_lock_35, o0_.booked AS booked_36, o0_.booked_by AS booked_by_37, o0_.booked_at AS booked_at_38, o0_.car_id AS car_id_39 FROM offer o0_ LEFT JOIN car c1_ ON o0_.car_id = c1_.id WHERE o0_.published = 1 AND c1_.category_slug IN ('suv-crossover') ORDER BY o0_.priority DESC, o0_.price ASC;

SELECT
  DISTINCT c0_.fuel_slug AS fuel_slug_0,
  c0_.fuel_name AS fuel_name_1
FROM
  offer o1_
  LEFT JOIN car c0_ ON o1_.car_id = c0_.id
ORDER BY
  c0_.fuel_name ASC

SELECT DISTINCT c0_.fuel_slug AS fuel_slug_0, c0_.fuel_name AS fuel_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.fuel_name ASC;

SELECT
  DISTINCT c0_.gearbox_slug AS gearbox_slug_0,
  c0_.gearbox AS gearbox_1
FROM
  offer o1_
  LEFT JOIN car c0_ ON o1_.car_id = c0_.id
WHERE
  o1_.published = 1
ORDER BY
  c0_.gearbox ASC

SELECT DISTINCT c0_.gearbox_slug AS gearbox_slug_0, c0_.gearbox AS gearbox_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id WHERE o1_.published = 1 ORDER BY c0_.gearbox ASC;

SELECT
  DISTINCT c0_.model_slug AS model_slug_0,
  c0_.model_name AS model_name_1
FROM
  offer o1_
  LEFT JOIN car c0_ ON o1_.car_id = c0_.id
ORDER BY
  c0_.model_name ASC

SELECT DISTINCT c0_.model_slug AS model_slug_0, c0_.model_name AS model_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.model_name ASC;

SELECT
  DISTINCT c0_.category_slug AS category_slug_0,
  c0_.category_name AS category_name_1
FROM
  offer o1_
  LEFT JOIN car c0_ ON o1_.car_id = c0_.id
ORDER BY
  c0_.category_name ASC

SELECT DISTINCT c0_.category_slug AS category_slug_0, c0_.category_name AS category_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id ORDER BY c0_.category_name ASC;

SELECT
  DISTINCT c0_.brand_slug AS brand_slug_0,
  c0_.brand_name AS brand_name_1
FROM
  offer o1_
  LEFT JOIN car c0_ ON o1_.car_id = c0_.id
WHERE
  o1_.published = 1
ORDER BY
  c0_.brand_name ASC

SELECT DISTINCT c0_.brand_slug AS brand_slug_0, c0_.brand_name AS brand_name_1 FROM offer o1_ LEFT JOIN car c0_ ON o1_.car_id = c0_.id WHERE o1_.published = 1 ORDER BY c0_.brand_name ASC;

SELECT
  MIN(o0_.price) AS sclr_0
FROM
  offer o0_
WHERE
  o0_.published = 1

SELECT MIN(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1;

SELECT
  MAX(o0_.price) AS sclr_0
FROM
  offer o0_
WHERE
  o0_.published = 1

SELECT MAX(o0_.price) AS sclr_0 FROM offer o0_ WHERE o0_.published = 1;