Symfony Profiler

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.title AS title_3,
  t0.deleted_at AS deleted_at_4,
  t0.modified_at AS modified_at_5,
  t0.created_at AS created_at_6
FROM
  c_blog_tag t0
WHERE
  t0.slug = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.title AS title_3, t0.deleted_at AS deleted_at_4, t0.modified_at AS modified_at_5, t0.created_at AS created_at_6 FROM c_blog_tag t0 WHERE t0.slug = 'sicilia' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  blog b0_
  INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id
  INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    b0_.publish_from <= '2025-04-05 11:47:40'
    AND b0_.publish_from IS NOT NULL
    AND b0_.is_active = 1
    AND c1_.id = 314
  )
  AND (b0_.deleted_at IS NULL)

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id AND (c1_.deleted_at IS NULL) WHERE (b0_.publish_from <= '2025-04-05 11:47:40' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1 AND c1_.id = 314) AND (b0_.deleted_at IS NULL);

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.publish_from AS publish_from_1
FROM
  blog b0_
  INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id
  INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    b0_.publish_from <= '2025-04-05 11:47:40'
    AND b0_.publish_from IS NOT NULL
    AND b0_.is_active = 1
    AND c1_.id = 314
  )
  AND (b0_.deleted_at IS NULL)
ORDER BY
  b0_.publish_from DESC
LIMIT
  12

SELECT DISTINCT b0_.id AS id_0, b0_.publish_from AS publish_from_1 FROM blog b0_ INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id AND (c1_.deleted_at IS NULL) WHERE (b0_.publish_from <= '2025-04-05 11:47:40' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1 AND c1_.id = 314) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC LIMIT 12;

SELECT
  b0_.title AS title_0,
  b0_.slug AS slug_1,
  b0_.is_active AS is_active_2,
  b0_.image AS image_3,
  b0_.publish_from AS publish_from_4,
  b0_.views AS views_5,
  b0_.read_time_min AS read_time_min_6,
  b0_.no_index AS no_index_7,
  b0_.updated_at AS updated_at_8,
  b0_.id AS id_9,
  b0_.deleted_at AS deleted_at_10,
  b0_.modified_at AS modified_at_11,
  b0_.created_at AS created_at_12,
  b0_.seo_title AS seo_title_13,
  b0_.meta_description AS meta_description_14,
  b0_.meta_image AS meta_image_15,
  b0_.blog_category_id AS blog_category_id_16,
  b0_.destination_id AS destination_id_17
FROM
  blog b0_
  INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id
  INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    b0_.publish_from <= '2025-04-05 11:47:40'
    AND b0_.publish_from IS NOT NULL
    AND b0_.is_active = 1
    AND c1_.id = 314
    AND b0_.id IN (?, ?, ?, ?, ?)
  )
  AND (b0_.deleted_at IS NULL)
ORDER BY
  b0_.publish_from DESC

SELECT b0_.title AS title_0, b0_.slug AS slug_1, b0_.is_active AS is_active_2, b0_.image AS image_3, b0_.publish_from AS publish_from_4, b0_.views AS views_5, b0_.read_time_min AS read_time_min_6, b0_.no_index AS no_index_7, b0_.updated_at AS updated_at_8, b0_.id AS id_9, b0_.deleted_at AS deleted_at_10, b0_.modified_at AS modified_at_11, b0_.created_at AS created_at_12, b0_.seo_title AS seo_title_13, b0_.meta_description AS meta_description_14, b0_.meta_image AS meta_image_15, b0_.blog_category_id AS blog_category_id_16, b0_.destination_id AS destination_id_17 FROM blog b0_ INNER JOIN blog_blog_tag b2_ ON b0_.id = b2_.blog_id INNER JOIN c_blog_tag c1_ ON c1_.id = b2_.blog_tag_id AND (c1_.deleted_at IS NULL) WHERE (b0_.publish_from <= '2025-04-05 111340384' AND b0_.publish_from IS NOT NULL AND b0_.is_active = 1 AND c1_.id = 314 AND b0_.id IN (343, 154, 153, ?, ?)) AND (b0_.deleted_at IS NULL) ORDER BY b0_.publish_from DESC;

SELECT
  t0.title AS title_1,
  t0.region AS region_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.map_zoom AS map_zoom_5,
  t0.description AS description_6,
  t0.is_active AS is_active_7,
  t0.opening_hours_mon AS opening_hours_mon_8,
  t0.opening_hours_tue AS opening_hours_tue_9,
  t0.opening_hours_wed AS opening_hours_wed_10,
  t0.opening_hours_thu AS opening_hours_thu_11,
  t0.opening_hours_fri AS opening_hours_fri_12,
  t0.opening_hours_sat AS opening_hours_sat_13,
  t0.opening_hours_sun AS opening_hours_sun_14,
  t0.no_index AS no_index_15,
  t0.slug AS slug_16,
  t0.id AS id_17,
  t0.deleted_at AS deleted_at_18,
  t0.modified_at AS modified_at_19,
  t0.created_at AS created_at_20,
  t0.seo_title AS seo_title_21,
  t0.meta_description AS meta_description_22,
  t0.meta_image AS meta_image_23,
  t0.street AS street_24,
  t0.street_number AS street_number_25,
  t0.zipcode AS zipcode_26,
  t0.city AS city_27,
  t0.latitude AS latitude_28,
  t0.longitude AS longitude_29,
  t0.country_id AS country_id_30
FROM
  branch_office t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.title AS title_1, t0.region AS region_2, t0.phone AS phone_3, t0.email AS email_4, t0.map_zoom AS map_zoom_5, t0.description AS description_6, t0.is_active AS is_active_7, t0.opening_hours_mon AS opening_hours_mon_8, t0.opening_hours_tue AS opening_hours_tue_9, t0.opening_hours_wed AS opening_hours_wed_10, t0.opening_hours_thu AS opening_hours_thu_11, t0.opening_hours_fri AS opening_hours_fri_12, t0.opening_hours_sat AS opening_hours_sat_13, t0.opening_hours_sun AS opening_hours_sun_14, t0.no_index AS no_index_15, t0.slug AS slug_16, t0.id AS id_17, t0.deleted_at AS deleted_at_18, t0.modified_at AS modified_at_19, t0.created_at AS created_at_20, t0.seo_title AS seo_title_21, t0.meta_description AS meta_description_22, t0.meta_image AS meta_image_23, t0.street AS street_24, t0.street_number AS street_number_25, t0.zipcode AS zipcode_26, t0.city AS city_27, t0.latitude AS latitude_28, t0.longitude AS longitude_29, t0.country_id AS country_id_30 FROM branch_office t0 WHERE t0.id = 94 AND ((t0.deleted_at IS NULL));

SELECT
  t0.date_from AS date_from_1,
  t0.date_to AS date_to_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.deleted_at AS deleted_at_5,
  t0.modified_at AS modified_at_6,
  t0.created_at AS created_at_7,
  t0.branch_office_id AS branch_office_id_8
FROM
  branch_office_hour t0
WHERE
  t0.branch_office_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.date_from AS date_from_1, t0.date_to AS date_to_2, t0.description AS description_3, t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.modified_at AS modified_at_6, t0.created_at AS created_at_7, t0.branch_office_id AS branch_office_id_8 FROM branch_office_hour t0 WHERE t0.branch_office_id = 94 AND ((t0.deleted_at IS NULL));

SELECT
  COUNT(*)
FROM
  branch_office t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM branch_office t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.slug AS slug_1,
  t0.is_active AS is_active_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.deleted_at AS deleted_at_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8
FROM
  blog_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.slug AS slug_1,
  t0.is_active AS is_active_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.deleted_at AS deleted_at_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8
FROM
  blog_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.id = 8 AND ((t0.deleted_at IS NULL));

SELECT
  t0.slug AS slug_1,
  t0.is_active AS is_active_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.deleted_at AS deleted_at_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8
FROM
  blog_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.slug AS slug_1, t0.is_active AS is_active_2, t0.position AS position_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.id = 5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.is_visible AS is_visible_1,
  t0.position AS position_2,
  t0.external_slug AS external_slug_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.deleted_at AS deleted_at_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8
FROM
  c_newsletter_category t0
WHERE
  t0.is_visible = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.title AS title_1,
  t0.slug AS slug_2,
  t0.is_active AS is_active_3,
  t0.is_popular AS is_popular_4,
  t0.image AS image_5,
  t0.image_mobile AS image_mobile_6,
  t0.image_alt AS image_alt_7,
  t0.video AS video_8,
  t0.redirect_url AS redirect_url_9,
  t0.no_index AS no_index_10,
  t0.canonical_url AS canonical_url_11,
  t0.video_url AS video_url_12,
  t0.video_title AS video_title_13,
  t0.id AS id_14,
  t0.deleted_at AS deleted_at_15,
  t0.modified_at AS modified_at_16,
  t0.created_at AS created_at_17,
  t0.seo_title AS seo_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_image AS meta_image_20,
  t0.type_id AS type_id_21,
  t0.destination_id AS destination_id_22
FROM
  page t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.is_popular AS is_popular_4, t0.image AS image_5, t0.image_mobile AS image_mobile_6, t0.image_alt AS image_alt_7, t0.video AS video_8, t0.redirect_url AS redirect_url_9, t0.no_index AS no_index_10, t0.canonical_url AS canonical_url_11, t0.video_url AS video_url_12, t0.video_title AS video_title_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.modified_at AS modified_at_16, t0.created_at AS created_at_17, t0.seo_title AS seo_title_18, t0.meta_description AS meta_description_19, t0.meta_image AS meta_image_20, t0.type_id AS type_id_21, t0.destination_id AS destination_id_22 FROM page t0 WHERE t0.id = 2445 AND ((t0.deleted_at IS NULL));

SELECT
  t0.is_visible AS is_visible_1,
  t0.position AS position_2,
  t0.external_slug AS external_slug_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.deleted_at AS deleted_at_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8
FROM
  c_newsletter_category t0
WHERE
  t0.is_visible = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.is_visible AS is_visible_1, t0.position AS position_2, t0.external_slug AS external_slug_3, t0.id AS id_4, t0.title AS title_5, t0.deleted_at AS deleted_at_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8 FROM c_newsletter_category t0 WHERE t0.is_visible = 1 AND ((t0.deleted_at IS NULL));

SELECT
  COUNT(*)
FROM
  branch_office t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM branch_office t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL));