Symfony Profiler

SELECT
  k0_.id AS id_0,
  k0_.uuid AS uuid_1,
  k0_.title AS title_2,
  k0_.subtitle AS subtitle_3,
  k0_.slug AS slug_4,
  k0_.image_src AS image_src_5,
  k0_.image_description AS image_description_6,
  k0_.image_alt AS image_alt_7,
  k0_.perex AS perex_8,
  k0_.content AS content_9,
  k0_.translation_group_id AS translation_group_id_10,
  k0_.view_count AS view_count_11,
  k0_.created_at AS created_at_12,
  k0_.updated_at AS updated_at_13,
  k0_.published_at AS published_at_14,
  k0_.is_promotional_post AS is_promotional_post_15,
  k0_.deleted_at AS deleted_at_16,
  k1_.id AS id_17,
  k1_.name AS name_18,
  p2_.id AS id_19,
  p2_.name AS name_20,
  p2_.domains AS domains_21,
  p2_.template AS template_22,
  l3_.id AS id_23,
  l3_.name AS name_24,
  l3_.code AS code_25,
  k4_.id AS id_26,
  k4_.title AS title_27,
  k4_.slug AS slug_28,
  k4_.description AS description_29,
  k4_.is_active AS is_active_30,
  k4_.layout AS layout_31,
  k4_.created_at AS created_at_32,
  k4_.updated_at AS updated_at_33,
  k4_.deleted_at AS deleted_at_34,
  k5_.id AS id_35,
  k5_.title AS title_36,
  k5_.slug AS slug_37,
  k5_.description AS description_38,
  k5_.is_active AS is_active_39,
  k5_.layout AS layout_40,
  k5_.created_at AS created_at_41,
  k5_.updated_at AS updated_at_42,
  k5_.deleted_at AS deleted_at_43,
  k6_.id AS id_44,
  k6_.title AS title_45,
  k6_.description AS description_46,
  k6_.is_active AS is_active_47,
  k6_.created_at AS created_at_48,
  k6_.updated_at AS updated_at_49,
  k6_.deleted_at AS deleted_at_50,
  k7_.id AS id_51,
  k7_.title AS title_52,
  k7_.description AS description_53,
  k7_.keywords AS keywords_54,
  k0_.post_state_id AS post_state_id_55,
  k0_.project_id AS project_id_56,
  k0_.language_id AS language_id_57,
  k0_.primary_category_id AS primary_category_id_58,
  k0_.published_by_id AS published_by_id_59,
  k0_.created_by_id AS created_by_id_60,
  k0_.post_seo_id AS post_seo_id_61,
  k4_.parent_id AS parent_id_62,
  k4_.owner_id AS owner_id_63,
  k5_.parent_id AS parent_id_64,
  k5_.owner_id AS owner_id_65
FROM
  kwbb_post k0_
  INNER JOIN kwbb_post_state k1_ ON k0_.post_state_id = k1_.id
  INNER JOIN project p2_ ON k0_.project_id = p2_.id
  INNER JOIN language l3_ ON k0_.language_id = l3_.id
  INNER JOIN kwbb_category k4_ ON k0_.primary_category_id = k4_.id
  LEFT JOIN post_category p8_ ON k0_.id = p8_.post_id
  LEFT JOIN kwbb_category k5_ ON k5_.id = p8_.category_id
  LEFT JOIN post_tag p9_ ON k0_.id = p9_.post_id
  LEFT JOIN kwbb_tag k6_ ON k6_.id = p9_.tag_id
  LEFT JOIN kwbb_post_seo k7_ ON k0_.post_seo_id = k7_.id
WHERE
  k1_.name = ?
  AND k0_.deleted_at IS NULL
  AND k0_.published_at IS NOT NULL
  AND k0_.published_at <= ?
  AND k0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )
ORDER BY
  k0_.published_at DESC,
  k0_.id DESC

SELECT k0_.id AS id_0, k0_.uuid AS uuid_1, k0_.title AS title_2, k0_.subtitle AS subtitle_3, k0_.slug AS slug_4, k0_.image_src AS image_src_5, k0_.image_description AS image_description_6, k0_.image_alt AS image_alt_7, k0_.perex AS perex_8, k0_.content AS content_9, k0_.translation_group_id AS translation_group_id_10, k0_.view_count AS view_count_11, k0_.created_at AS created_at_12, k0_.updated_at AS updated_at_13, k0_.published_at AS published_at_14, k0_.is_promotional_post AS is_promotional_post_15, k0_.deleted_at AS deleted_at_16, k1_.id AS id_17, k1_.name AS name_18, p2_.id AS id_19, p2_.name AS name_20, p2_.domains AS domains_21, p2_.template AS template_22, l3_.id AS id_23, l3_.name AS name_24, l3_.code AS code_25, k4_.id AS id_26, k4_.title AS title_27, k4_.slug AS slug_28, k4_.description AS description_29, k4_.is_active AS is_active_30, k4_.layout AS layout_31, k4_.created_at AS created_at_32, k4_.updated_at AS updated_at_33, k4_.deleted_at AS deleted_at_34, k5_.id AS id_35, k5_.title AS title_36, k5_.slug AS slug_37, k5_.description AS description_38, k5_.is_active AS is_active_39, k5_.layout AS layout_40, k5_.created_at AS created_at_41, k5_.updated_at AS updated_at_42, k5_.deleted_at AS deleted_at_43, k6_.id AS id_44, k6_.title AS title_45, k6_.description AS description_46, k6_.is_active AS is_active_47, k6_.created_at AS created_at_48, k6_.updated_at AS updated_at_49, k6_.deleted_at AS deleted_at_50, k7_.id AS id_51, k7_.title AS title_52, k7_.description AS description_53, k7_.keywords AS keywords_54, k0_.post_state_id AS post_state_id_55, k0_.project_id AS project_id_56, k0_.language_id AS language_id_57, k0_.primary_category_id AS primary_category_id_58, k0_.published_by_id AS published_by_id_59, k0_.created_by_id AS created_by_id_60, k0_.post_seo_id AS post_seo_id_61, k4_.parent_id AS parent_id_62, k4_.owner_id AS owner_id_63, k5_.parent_id AS parent_id_64, k5_.owner_id AS owner_id_65 FROM kwbb_post k0_ INNER JOIN kwbb_post_state k1_ ON k0_.post_state_id = k1_.id INNER JOIN project p2_ ON k0_.project_id = p2_.id INNER JOIN language l3_ ON k0_.language_id = l3_.id INNER JOIN kwbb_category k4_ ON k0_.primary_category_id = k4_.id LEFT JOIN post_category p8_ ON k0_.id = p8_.post_id LEFT JOIN kwbb_category k5_ ON k5_.id = p8_.category_id LEFT JOIN post_tag p9_ ON k0_.id = p9_.post_id LEFT JOIN kwbb_tag k6_ ON k6_.id = p9_.tag_id LEFT JOIN kwbb_post_seo k7_ ON k0_.post_seo_id = k7_.id WHERE k1_.name = 'PUBLISHED' AND k0_.deleted_at IS NULL AND k0_.published_at IS NOT NULL AND k0_.published_at <= '2026-10-24 18:40:44' AND k0_.id IN (181, 176, 175, 172, 169, 166, 163, 160, 157, 145, 142, 139, 154, 151, 130, 129, 118, 117, 116, 115, 114, 113, 112, 111, 110, 109, 108, 107, 106, 105, 104, 103, 102, 101, 100, 99, 98, 97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84) ORDER BY k0_.published_at DESC, k0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 3 AND t0.language_group_id = '9148b3e2-07d0-dfee-9067-869c0eba8df4' LIMIT 1;

SELECT
  DISTINCT k0_.id AS id_0,
  k0_.published_at AS published_at_1
FROM
  kwbb_post k0_
  INNER JOIN kwbb_post_state k1_ ON k0_.post_state_id = k1_.id
WHERE
  k1_.name = ?
  AND k0_.deleted_at IS NULL
  AND k0_.published_at IS NOT NULL
  AND k0_.published_at <= ?
  AND k0_.project_id = ?
  AND k0_.language_id = ?
  AND k0_.primary_category_id = ?
ORDER BY
  published_at_1 DESC,
  k0_.id DESC
LIMIT
  100

SELECT DISTINCT k0_.id AS id_0, k0_.published_at AS published_at_1 FROM kwbb_post k0_ INNER JOIN kwbb_post_state k1_ ON k0_.post_state_id = k1_.id WHERE k1_.name = 'PUBLISHED' AND k0_.deleted_at IS NULL AND k0_.published_at IS NOT NULL AND k0_.published_at <= '2026-10-24 18:40:44' AND k0_.project_id = 1 AND k0_.language_id = 3 AND k0_.primary_category_id = 1 ORDER BY published_at_1 DESC, k0_.id DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.layout AS layout_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.parent_id AS parent_id_10,
  t0.owner_id AS owner_id_11
FROM
  kwbb_category t0
WHERE
  t0.slug = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.layout AS layout_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10, t0.owner_id AS owner_id_11 FROM kwbb_category t0 WHERE t0.slug = 'hot-news' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = 195;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 WHERE t0.code = 'de' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.project_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 3 AND t0.project_id = 1 AND t0.slug = 'de/hot-news' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.domains AS domains_2,
  p0_.template AS template_3
FROM
  project p0_
WHERE
  p0_.domains LIKE ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.domains AS domains_2, p0_.template AS template_3 FROM project p0_ WHERE p0_.domains LIKE '%hotpeppers.e-online.cz%';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.language_id AS language_id_4
FROM
  navigation t0
WHERE
  t0.language_id = ?
  AND t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = 3 AND t0.is_main = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  language t0
  INNER JOIN language_project ON t0.id = language_project.language_id
WHERE
  language_project.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 INNER JOIN language_project ON t0.id = language_project.language_id WHERE language_project.project_id = 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.navigation_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.navigation_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domains AS domains_3,
  t0.template AS template_4
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domains AS domains_3, t0.template AS template_4 FROM project t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.id = 284;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.language_id AS language_id_4
FROM
  navigation t0
WHERE
  t0.language_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = 3 AND t0.name = 'footer' LIMIT 1;