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 = '5527f842-96d1-4386-a8a1-48bbc48deb48';

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 ('9d119bc4-ccd3-44cd-add8-4f6d2feb1799') 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 ('5527f842-96d1-4386-a8a1-48bbc48deb48');

SELECT
  t0.id AS id_1,
  t0.webid AS webid_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.deposit AS deposit_5,
  t0.duration AS duration_6,
  t0.distance AS distance_7,
  t0.notes AS notes_8,
  t0.left_label AS left_label_9,
  t0.right_label AS right_label_10,
  t0.fast_delivery AS fast_delivery_11,
  t0.delivery_time AS delivery_time_12,
  t0.tag AS tag_13,
  t0.secondary_tag AS secondary_tag_14,
  t0.seolink AS seolink_15,
  t0.status AS status_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.featured AS featured_20,
  t0.catalog AS catalog_21,
  t0.published AS published_22,
  t0.private AS private_23,
  t0.for_company AS for_company_24,
  t0.video_id AS video_id_25,
  t0.last_import_at AS last_import_at_26,
  t0.priority AS priority_27,
  t0.adv AS adv_28,
  t0.linear_badge AS linear_badge_29,
  t0.linear_badge_color AS linear_badge_color_30,
  t0.round_badge AS round_badge_31,
  t0.round_badge_color AS round_badge_color_32,
  t0.ribbon_badge AS ribbon_badge_33,
  t0.ribbon_badge_color AS ribbon_badge_color_34,
  t0.provider AS provider_35,
  t0.image_lock AS image_lock_36,
  t0.booked AS booked_37,
  t0.booked_by AS booked_by_38,
  t0.booked_at AS booked_at_39,
  t0.car_id AS car_id_40,
  t41.id AS id_42,
  t41.brand_name AS brand_name_43,
  t41.brand_slug AS brand_slug_44,
  t41.fuel_name AS fuel_name_45,
  t41.fuel_slug AS fuel_slug_46,
  t41.category_name AS category_name_47,
  t41.category_slug AS category_slug_48,
  t41.model_name AS model_name_49,
  t41.model_slug AS model_slug_50,
  t41.version AS version_51,
  t41.displacement AS displacement_52,
  t41.power AS power_53,
  t41.drive AS drive_54,
  t41.average_consumption AS average_consumption_55,
  t41.emission AS emission_56,
  t41.sizes AS sizes_57,
  t41.capacity AS capacity_58,
  t41.seats AS seats_59,
  t41.doors AS doors_60,
  t41.gearbox AS gearbox_61,
  t41.gearbox_slug AS gearbox_slug_62
FROM
  offer t0
  LEFT JOIN car t41 ON t0.car_id = t41.id
WHERE
  t0.fast_delivery = ?
  AND t0.published = ?
LIMIT
  99

SELECT t0.id AS id_1, t0.webid AS webid_2, t0.code AS code_3, t0.price AS price_4, t0.deposit AS deposit_5, t0.duration AS duration_6, t0.distance AS distance_7, t0.notes AS notes_8, t0.left_label AS left_label_9, t0.right_label AS right_label_10, t0.fast_delivery AS fast_delivery_11, t0.delivery_time AS delivery_time_12, t0.tag AS tag_13, t0.secondary_tag AS secondary_tag_14, t0.seolink AS seolink_15, t0.status AS status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.featured AS featured_20, t0.catalog AS catalog_21, t0.published AS published_22, t0.private AS private_23, t0.for_company AS for_company_24, t0.video_id AS video_id_25, t0.last_import_at AS last_import_at_26, t0.priority AS priority_27, t0.adv AS adv_28, t0.linear_badge AS linear_badge_29, t0.linear_badge_color AS linear_badge_color_30, t0.round_badge AS round_badge_31, t0.round_badge_color AS round_badge_color_32, t0.ribbon_badge AS ribbon_badge_33, t0.ribbon_badge_color AS ribbon_badge_color_34, t0.provider AS provider_35, t0.image_lock AS image_lock_36, t0.booked AS booked_37, t0.booked_by AS booked_by_38, t0.booked_at AS booked_at_39, t0.car_id AS car_id_40, t41.id AS id_42, t41.brand_name AS brand_name_43, t41.brand_slug AS brand_slug_44, t41.fuel_name AS fuel_name_45, t41.fuel_slug AS fuel_slug_46, t41.category_name AS category_name_47, t41.category_slug AS category_slug_48, t41.model_name AS model_name_49, t41.model_slug AS model_slug_50, t41.version AS version_51, t41.displacement AS displacement_52, t41.power AS power_53, t41.drive AS drive_54, t41.average_consumption AS average_consumption_55, t41.emission AS emission_56, t41.sizes AS sizes_57, t41.capacity AS capacity_58, t41.seats AS seats_59, t41.doors AS doors_60, t41.gearbox AS gearbox_61, t41.gearbox_slug AS gearbox_slug_62 FROM offer t0 LEFT JOIN car t41 ON t0.car_id = t41.id WHERE t0.fast_delivery = 1 AND t0.published = 1 LIMIT 99;

SELECT
  t0.id AS id_1,
  t0.webid AS webid_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.deposit AS deposit_5,
  t0.duration AS duration_6,
  t0.distance AS distance_7,
  t0.notes AS notes_8,
  t0.left_label AS left_label_9,
  t0.right_label AS right_label_10,
  t0.fast_delivery AS fast_delivery_11,
  t0.delivery_time AS delivery_time_12,
  t0.tag AS tag_13,
  t0.secondary_tag AS secondary_tag_14,
  t0.seolink AS seolink_15,
  t0.status AS status_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.featured AS featured_20,
  t0.catalog AS catalog_21,
  t0.published AS published_22,
  t0.private AS private_23,
  t0.for_company AS for_company_24,
  t0.video_id AS video_id_25,
  t0.last_import_at AS last_import_at_26,
  t0.priority AS priority_27,
  t0.adv AS adv_28,
  t0.linear_badge AS linear_badge_29,
  t0.linear_badge_color AS linear_badge_color_30,
  t0.round_badge AS round_badge_31,
  t0.round_badge_color AS round_badge_color_32,
  t0.ribbon_badge AS ribbon_badge_33,
  t0.ribbon_badge_color AS ribbon_badge_color_34,
  t0.provider AS provider_35,
  t0.image_lock AS image_lock_36,
  t0.booked AS booked_37,
  t0.booked_by AS booked_by_38,
  t0.booked_at AS booked_at_39,
  t0.car_id AS car_id_40,
  t41.id AS id_42,
  t41.brand_name AS brand_name_43,
  t41.brand_slug AS brand_slug_44,
  t41.fuel_name AS fuel_name_45,
  t41.fuel_slug AS fuel_slug_46,
  t41.category_name AS category_name_47,
  t41.category_slug AS category_slug_48,
  t41.model_name AS model_name_49,
  t41.model_slug AS model_slug_50,
  t41.version AS version_51,
  t41.displacement AS displacement_52,
  t41.power AS power_53,
  t41.drive AS drive_54,
  t41.average_consumption AS average_consumption_55,
  t41.emission AS emission_56,
  t41.sizes AS sizes_57,
  t41.capacity AS capacity_58,
  t41.seats AS seats_59,
  t41.doors AS doors_60,
  t41.gearbox AS gearbox_61,
  t41.gearbox_slug AS gearbox_slug_62
FROM
  offer t0
  LEFT JOIN car t41 ON t0.car_id = t41.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.webid AS webid_2, t0.code AS code_3, t0.price AS price_4, t0.deposit AS deposit_5, t0.duration AS duration_6, t0.distance AS distance_7, t0.notes AS notes_8, t0.left_label AS left_label_9, t0.right_label AS right_label_10, t0.fast_delivery AS fast_delivery_11, t0.delivery_time AS delivery_time_12, t0.tag AS tag_13, t0.secondary_tag AS secondary_tag_14, t0.seolink AS seolink_15, t0.status AS status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.featured AS featured_20, t0.catalog AS catalog_21, t0.published AS published_22, t0.private AS private_23, t0.for_company AS for_company_24, t0.video_id AS video_id_25, t0.last_import_at AS last_import_at_26, t0.priority AS priority_27, t0.adv AS adv_28, t0.linear_badge AS linear_badge_29, t0.linear_badge_color AS linear_badge_color_30, t0.round_badge AS round_badge_31, t0.round_badge_color AS round_badge_color_32, t0.ribbon_badge AS ribbon_badge_33, t0.ribbon_badge_color AS ribbon_badge_color_34, t0.provider AS provider_35, t0.image_lock AS image_lock_36, t0.booked AS booked_37, t0.booked_by AS booked_by_38, t0.booked_at AS booked_at_39, t0.car_id AS car_id_40, t41.id AS id_42, t41.brand_name AS brand_name_43, t41.brand_slug AS brand_slug_44, t41.fuel_name AS fuel_name_45, t41.fuel_slug AS fuel_slug_46, t41.category_name AS category_name_47, t41.category_slug AS category_slug_48, t41.model_name AS model_name_49, t41.model_slug AS model_slug_50, t41.version AS version_51, t41.displacement AS displacement_52, t41.power AS power_53, t41.drive AS drive_54, t41.average_consumption AS average_consumption_55, t41.emission AS emission_56, t41.sizes AS sizes_57, t41.capacity AS capacity_58, t41.seats AS seats_59, t41.doors AS doors_60, t41.gearbox AS gearbox_61, t41.gearbox_slug AS gearbox_slug_62 FROM offer t0 LEFT JOIN car t41 ON t0.car_id = t41.id WHERE t0.code = 'hon4104-lsd8' LIMIT 1;

SELECT
  COUNT(*)
FROM
  offer t0
WHERE
  t0.fast_delivery = ?
  AND t0.published = ?

SELECT COUNT(*) FROM offer t0 WHERE t0.fast_delivery = 1 AND t0.published = 1;