Symfony Profiler

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL;

SELECT
  s0_.id AS id_0,
  MIN(s1_.price) AS sclr_1,
  CASE WHEN MIN(s1_.price) IS NULL THEN
    1
  ELSE
    0
  END AS sclr_2
FROM
  service s0_
  LEFT JOIN category c2_ ON s0_.category_id = c2_.id
  LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
GROUP BY
  s0_.id
ORDER BY
  sclr_2 ASC,
  sclr_1 DESC,
  s0_.id ASC
LIMIT
  12

SELECT s0_.id AS id_0, MIN(s1_.price) AS sclr_1, CASE WHEN MIN(s1_.price) IS NULL THEN 1 ELSE 0 END AS sclr_2 FROM service s0_ LEFT JOIN category c2_ ON s0_.category_id = c2_.id LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL GROUP BY s0_.id ORDER BY sclr_2 ASC, sclr_1 DESC, s0_.id ASC LIMIT 12;

SELECT
  s0_.title AS title_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.booking_type AS booking_type_3,
  s0_.status AS status_4,
  s0_.currency AS currency_5,
  s0_.short_description AS short_description_6,
  s0_.duration_minutes AS duration_minutes_7,
  s0_.place_label AS place_label_8,
  s0_.duration_label AS duration_label_9,
  s0_.badge AS badge_10,
  s0_.search_text AS search_text_11,
  s0_.search_place AS search_place_12,
  s0_.position AS position_13,
  s0_.rating_average AS rating_average_14,
  s0_.reviews_count AS reviews_count_15,
  s0_.capacity AS capacity_16,
  s0_.level AS level_17,
  s0_.languages AS languages_18,
  s0_.included AS included_19,
  s0_.subtitle AS subtitle_20,
  s0_.activity_type AS activity_type_21,
  s0_.minimum_age AS minimum_age_22,
  s0_.programme AS programme_23,
  s0_.meeting_point AS meeting_point_24,
  s0_.opening_period AS opening_period_25,
  s0_.audience AS audience_26,
  s0_.cancellation_policy AS cancellation_policy_27,
  s0_.address AS address_28,
  s0_.city AS city_29,
  s0_.postal_code AS postal_code_30,
  s0_.country AS country_31,
  s0_.latitude AS latitude_32,
  s0_.longitude AS longitude_33,
  s0_.id AS id_34,
  s0_.created_at AS created_at_35,
  s0_.updated_at AS updated_at_36,
  s0_.deleted_at AS deleted_at_37,
  s1_.name AS name_38,
  s1_.description AS description_39,
  s1_.price AS price_40,
  s1_.currency AS currency_41,
  s1_.pricing_unit AS pricing_unit_42,
  s1_.delivery_days AS delivery_days_43,
  s1_.id AS id_44,
  s1_.created_at AS created_at_45,
  s1_.updated_at AS updated_at_46,
  m2_.path AS path_47,
  m2_.type AS type_48,
  m2_.position AS position_49,
  m2_.id AS id_50,
  m2_.created_at AS created_at_51,
  m2_.updated_at AS updated_at_52,
  c3_.name AS name_53,
  c3_.slug AS slug_54,
  c3_.position AS position_55,
  c3_.id AS id_56,
  c3_.created_at AS created_at_57,
  c3_.updated_at AS updated_at_58,
  s0_.provider_id AS provider_id_59,
  s0_.category_id AS category_id_60,
  s0_.destination_id AS destination_id_61,
  s1_.service_id AS service_id_62,
  m2_.service_id AS service_id_63,
  c3_.parent_id AS parent_id_64
FROM
  service s0_
  LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id
  LEFT JOIN media m2_ ON s0_.id = m2_.service_id
  LEFT JOIN category c3_ ON s0_.category_id = c3_.id
WHERE
  s0_.id IN (?, ?)

SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.capacity AS capacity_16, s0_.level AS level_17, s0_.languages AS languages_18, s0_.included AS included_19, s0_.subtitle AS subtitle_20, s0_.activity_type AS activity_type_21, s0_.minimum_age AS minimum_age_22, s0_.programme AS programme_23, s0_.meeting_point AS meeting_point_24, s0_.opening_period AS opening_period_25, s0_.audience AS audience_26, s0_.cancellation_policy AS cancellation_policy_27, s0_.address AS address_28, s0_.city AS city_29, s0_.postal_code AS postal_code_30, s0_.country AS country_31, s0_.latitude AS latitude_32, s0_.longitude AS longitude_33, s0_.id AS id_34, s0_.created_at AS created_at_35, s0_.updated_at AS updated_at_36, s0_.deleted_at AS deleted_at_37, s1_.name AS name_38, s1_.description AS description_39, s1_.price AS price_40, s1_.currency AS currency_41, s1_.pricing_unit AS pricing_unit_42, s1_.delivery_days AS delivery_days_43, s1_.id AS id_44, s1_.created_at AS created_at_45, s1_.updated_at AS updated_at_46, m2_.path AS path_47, m2_.type AS type_48, m2_.position AS position_49, m2_.id AS id_50, m2_.created_at AS created_at_51, m2_.updated_at AS updated_at_52, c3_.name AS name_53, c3_.slug AS slug_54, c3_.position AS position_55, c3_.id AS id_56, c3_.created_at AS created_at_57, c3_.updated_at AS updated_at_58, s0_.provider_id AS provider_id_59, s0_.category_id AS category_id_60, s0_.destination_id AS destination_id_61, s1_.service_id AS service_id_62, m2_.service_id AS service_id_63, c3_.parent_id AS parent_id_64 FROM service s0_ LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id LEFT JOIN media m2_ ON s0_.id = m2_.service_id LEFT JOIN category c3_ ON s0_.category_id = c3_.id WHERE s0_.id IN ('019f9f89-3813-1a16-1a80-f22f1ca530ee', '019f9f89-3813-1a16-1a80-f22f1ca530f1');

SELECT
  t0.breadcrumb AS breadcrumb_1,
  t0.organizer AS organizer_2,
  t0.presentation_subtitle AS presentation_subtitle_3,
  t0.presentation_text AS presentation_text_4,
  t0.highlights_title AS highlights_title_5,
  t0.highlights AS highlights_6,
  t0.included AS included_7,
  t0.excluded AS excluded_8,
  t0.cannot_participate AS cannot_participate_9,
  t0.to_bring AS to_bring_10,
  t0.key_facts AS key_facts_11,
  t0.map_image AS map_image_12,
  t0.meeting_points AS meeting_points_13,
  t0.guarantees AS guarantees_14,
  t0.price AS price_15,
  t0.reviews_score AS reviews_score_16,
  t0.reviews_out_of AS reviews_out_of_17,
  t0.reviews_total AS reviews_total_18,
  t0.modal_title AS modal_title_19,
  t0.id AS id_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.service_id AS service_id_23
FROM
  service_detail t0
WHERE
  t0.service_id = ?

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = '019f9f89-3813-1a16-1a80-f22f1ca530ee';

SELECT
  t0.breadcrumb AS breadcrumb_1,
  t0.organizer AS organizer_2,
  t0.presentation_subtitle AS presentation_subtitle_3,
  t0.presentation_text AS presentation_text_4,
  t0.highlights_title AS highlights_title_5,
  t0.highlights AS highlights_6,
  t0.included AS included_7,
  t0.excluded AS excluded_8,
  t0.cannot_participate AS cannot_participate_9,
  t0.to_bring AS to_bring_10,
  t0.key_facts AS key_facts_11,
  t0.map_image AS map_image_12,
  t0.meeting_points AS meeting_points_13,
  t0.guarantees AS guarantees_14,
  t0.price AS price_15,
  t0.reviews_score AS reviews_score_16,
  t0.reviews_out_of AS reviews_out_of_17,
  t0.reviews_total AS reviews_total_18,
  t0.modal_title AS modal_title_19,
  t0.id AS id_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.service_id AS service_id_23
FROM
  service_detail t0
WHERE
  t0.service_id = ?

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = '019f9f89-3813-1a16-1a80-f22f1ca530f1';