Symfony Profiler

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.slug = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

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.slug = 'ake-by-to-bolo-keby-sa-bol-konal-zajazd-milano-a-boromejske-ostrovy-s-nasou-sprievodkynou-slavkou-specialistkou-na-taliansko' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.title AS title_1,
  t0.slug AS slug_2,
  t0.is_active AS is_active_3,
  t0.image AS image_4,
  t0.publish_from AS publish_from_5,
  t0.views AS views_6,
  t0.read_time_min AS read_time_min_7,
  t0.no_index AS no_index_8,
  t0.updated_at AS updated_at_9,
  t0.id AS id_10,
  t0.deleted_at AS deleted_at_11,
  t0.modified_at AS modified_at_12,
  t0.created_at AS created_at_13,
  t0.seo_title AS seo_title_14,
  t0.meta_description AS meta_description_15,
  t0.meta_image AS meta_image_16,
  t0.blog_category_id AS blog_category_id_17,
  t0.destination_id AS destination_id_18
FROM
  blog t0
WHERE
  t0.slug = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.title AS title_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.publish_from AS publish_from_5, t0.views AS views_6, t0.read_time_min AS read_time_min_7, t0.no_index AS no_index_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.deleted_at AS deleted_at_11, t0.modified_at AS modified_at_12, t0.created_at AS created_at_13, t0.seo_title AS seo_title_14, t0.meta_description AS meta_description_15, t0.meta_image AS meta_image_16, t0.blog_category_id AS blog_category_id_17, t0.destination_id AS destination_id_18 FROM blog t0 WHERE t0.slug = 'ake-by-to-bolo-keby-sa-bol-konal-zajazd-milano-a-boromejske-ostrovy-s-nasou-sprievodkynou-slavkou-specialistkou-na-taliansko' AND t0.is_active = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  blog
SET
  views = ?,
  modified_at = ?
WHERE
  id = ?

UPDATE blog SET views = 3529, modified_at = '2025-04-05 02:09:56' WHERE id = 766;

"COMMIT"

"COMMIT";

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
  INNER JOIN blog_blog_tag ON t0.id = blog_blog_tag.blog_tag_id
WHERE
  blog_blog_tag.blog_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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 INNER JOIN blog_blog_tag ON t0.id = blog_blog_tag.blog_tag_id WHERE blog_blog_tag.blog_id = 766 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 = ?
  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.title AS title_1,
  t0.id AS id_2,
  t0.deleted_at AS deleted_at_3,
  t0.modified_at AS modified_at_4,
  t0.created_at AS created_at_5,
  t0.page_id AS page_id_6,
  t0.career_id AS career_id_7,
  t0.blog_id AS blog_id_8,
  t0.map_item_id AS map_item_id_9
FROM
  content_section t0
WHERE
  t0.blog_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.title AS title_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.page_id AS page_id_6, t0.career_id AS career_id_7, t0.blog_id AS blog_id_8, t0.map_item_id AS map_item_id_9 FROM content_section t0 WHERE t0.blog_id = 766 AND ((t0.deleted_at IS NULL));

SELECT
  t0.type AS type_1,
  t0.value AS value_2,
  t0.modified_user AS modified_user_3,
  t0.is_active AS is_active_4,
  t0.position AS position_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.modified_at AS modified_at_8,
  t0.created_at AS created_at_9,
  t0.section_id AS section_id_10
FROM
  content_block t0
WHERE
  t0.section_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.type AS type_1, t0.value AS value_2, t0.modified_user AS modified_user_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.modified_at AS modified_at_8, t0.created_at AS created_at_9, t0.section_id AS section_id_10 FROM content_block t0 WHERE t0.section_id = 7703 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

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.title AS title_1,
  t0.slug AS slug_2,
  t0.is_active AS is_active_3,
  t0.image AS image_4,
  t0.publish_from AS publish_from_5,
  t0.views AS views_6,
  t0.read_time_min AS read_time_min_7,
  t0.no_index AS no_index_8,
  t0.updated_at AS updated_at_9,
  t0.id AS id_10,
  t0.deleted_at AS deleted_at_11,
  t0.modified_at AS modified_at_12,
  t0.created_at AS created_at_13,
  t0.seo_title AS seo_title_14,
  t0.meta_description AS meta_description_15,
  t0.meta_image AS meta_image_16,
  t0.blog_category_id AS blog_category_id_17,
  t0.destination_id AS destination_id_18
FROM
  blog 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.image AS image_4, t0.publish_from AS publish_from_5, t0.views AS views_6, t0.read_time_min AS read_time_min_7, t0.no_index AS no_index_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.deleted_at AS deleted_at_11, t0.modified_at AS modified_at_12, t0.created_at AS created_at_13, t0.seo_title AS seo_title_14, t0.meta_description AS meta_description_15, t0.meta_image AS meta_image_16, t0.blog_category_id AS blog_category_id_17, t0.destination_id AS destination_id_18 FROM blog t0 WHERE t0.id = 716 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));