Symfony Profiler

Query Metrics

36 Database Queries

14 Different statements

53.89 ms Query time

1 Invalid entities

53 Managed entities

Queries


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 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 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.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 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_.project_id = ? AND k0_.language_id = ? AND k0_.primary_category_id = ? AND k0_.slug = ?
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_.project_id = ? AND k0_.translation_group_id = ? ORDER BY l3_.id ASC
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 4
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 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.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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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.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 = ? AND t0.is_main = ? 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.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 = ? AND t0.language_group_id = ? 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.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 = ? AND t0.language_group_id = ? LIMIT 1

#▲	Time	Info
1	1.05 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"en"`] View formatted query View runnable query Explain query 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 = 'en' LIMIT 1;
2	0.68 ms	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 ? Parameters: [`"%hotpeppers.e-online.cz%"`] View formatted query View runnable query Explain query 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%';
3	0.47 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
4	3.94 ms	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 Parameters: [`"hot-news" 1`] View formatted query View runnable query Explain query 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;
5	20.51 ms	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_.project_id = ? AND k0_.language_id = ? AND k0_.primary_category_id = ? AND k0_.slug = ? Parameters: [`"PUBLISHED" "2026-10-13 05:19:03" 1 2 1 "oktagon-45"`] View formatted query View runnable query Explain query 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_.project_id = ? AND k0_.language_id = ? AND k0_.primary_category_id = ? AND k0_.slug = ? 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-13 05:19:03' AND k0_.project_id = 1 AND k0_.language_id = 2 AND k0_.primary_category_id = 1 AND k0_.slug = 'oktagon-45';
6	3.24 ms	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_.project_id = ? AND k0_.translation_group_id = ? ORDER BY l3_.id ASC Parameters: [`"PUBLISHED" "2026-10-13 05:19:03" 1 "21d977e9-a66b-5c31-a9b5-c8637e09b39c"`] View formatted query View runnable query Explain query 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_.project_id = ? AND k0_.translation_group_id = ? ORDER BY l3_.id ASC 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-13 05:19:03' AND k0_.project_id = 1 AND k0_.translation_group_id = '21d977e9-a66b-5c31-a9b5-c8637e09b39c' ORDER BY l3_.id ASC;
7	1.53 ms	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 4 Parameters: [`"PUBLISHED" "2026-10-13 05:19:03" 1 2 1`] View formatted query View runnable query Explain query 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 4 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-13 05:19:03' AND k0_.project_id = 1 AND k0_.language_id = 2 AND k0_.primary_category_id = 1 ORDER BY published_at_1 DESC, k0_.id DESC LIMIT 4;
8	1.66 ms	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 Parameters: [`"PUBLISHED" "2026-10-13 05:19:03" 180 178 174 171`] View formatted query View runnable query Explain query 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-13 05:19:03' AND k0_.id IN (180, 178, 174, 171) ORDER BY k0_.published_at DESC, k0_.id DESC;
9	0.83 ms	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 Parameters: [`2 1`] View formatted query View runnable query Explain query 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 = 2 AND t0.is_main = 1 LIMIT 1;
10	0.80 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
11	0.62 ms	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 = ? Parameters: [`213`] View formatted query View runnable query Explain query 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 = 213;
12	0.43 ms	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 = ? Parameters: [`214`] View formatted query View runnable query Explain query 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 = 214;
13	0.41 ms	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 = ? Parameters: [`215`] View formatted query View runnable query Explain query 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 = 215;
14	0.39 ms	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 = ? Parameters: [`216`] View formatted query View runnable query Explain query 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 = 216;
15	0.38 ms	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 = ? Parameters: [`217`] View formatted query View runnable query Explain query 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 = 217;
16	0.36 ms	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 = ? Parameters: [`218`] View formatted query View runnable query Explain query 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 = 218;
17	0.39 ms	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 = ? Parameters: [`219`] View formatted query View runnable query Explain query 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 = 219;
18	0.37 ms	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 = ? Parameters: [`220`] View formatted query View runnable query Explain query 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 = 220;
19	0.40 ms	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 = ? Parameters: [`221`] View formatted query View runnable query Explain query 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 = 221;
20	0.36 ms	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 = ? Parameters: [`222`] View formatted query View runnable query Explain query 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 = 222;
21	0.35 ms	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 = ? Parameters: [`223`] View formatted query View runnable query Explain query 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 = 223;
22	0.43 ms	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 = ? Parameters: [`224`] View formatted query View runnable query Explain query 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 = 224;
23	0.37 ms	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 = ? Parameters: [`225`] View formatted query View runnable query Explain query 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 = 225;
24	0.36 ms	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 = ? Parameters: [`226`] View formatted query View runnable query Explain query 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 = 226;
25	0.34 ms	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 = ? Parameters: [`227`] View formatted query View runnable query Explain query 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 = 227;
26	0.33 ms	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 = ? Parameters: [`228`] View formatted query View runnable query Explain query 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 = 228;
27	0.37 ms	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 = ? Parameters: [`229`] View formatted query View runnable query Explain query 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 = 229;
28	0.39 ms	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 = ? Parameters: [`230`] View formatted query View runnable query Explain query 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 = 230;
29	0.43 ms	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 = ? Parameters: [`231`] View formatted query View runnable query Explain query 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 = 231;
30	0.47 ms	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 Parameters: [`2 "footer"`] View formatted query View runnable query Explain query 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 = 2 AND t0.name = 'footer' LIMIT 1;
31	0.42 ms	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 Parameters: [`2 1`] View formatted query View runnable query Explain query 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 = 2 AND t0.is_main = 1 LIMIT 1;
32	3.56 ms	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 Parameters: [`2 "9148b3e2-07d0-dfee-9067-869c0eba8df4"`] View formatted query View runnable query Explain query 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 = 2 AND t0.language_group_id = '9148b3e2-07d0-dfee-9067-869c0eba8df4' LIMIT 1;
33	1.74 ms	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 Parameters: [`2 "9148b3e2-07d0-dfee-9067-869c0eba8df4"`] View formatted query View runnable query Explain query 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 = 2 AND t0.language_group_id = '9148b3e2-07d0-dfee-9067-869c0eba8df4' LIMIT 1;
34	1.40 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
35	2.90 ms	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 Parameters: [`2 "6b05ab47-a00b-56ac-b68f-db20fdf04b2c"`] View formatted query View runnable query Explain query 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 = 2 AND t0.language_group_id = '6b05ab47-a00b-56ac-b68f-db20fdf04b2c' LIMIT 1;
36	1.22 ms	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 Parameters: [`2 "f34e3439-0eec-5e98-9c2d-2b5ad0d9d019"`] View formatted query View runnable query Explain query 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 = 2 AND t0.language_group_id = 'f34e3439-0eec-5e98-9c2d-2b5ad0d9d019' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Kiwi\WebBundle\Entity\NavigationItem	19
Kiwi\BlogBundle\Entity\Post	7
Kiwi\BlogBundle\Entity\PostSEO	7
Kiwi\AdminBundle\Entity\Language	3
Kiwi\WebBundle\Entity\Page	3
Kiwi\WebBundle\Entity\PageExcerpt	3
Kiwi\WebBundle\Entity\PageSEO	3
Kiwi\BlogBundle\Entity\Tag	2
Kiwi\AdminBundle\Entity\Project	1
Kiwi\BlogBundle\Entity\Category	1
Kiwi\AdminBundle\Entity\KiwiUser	1
Kiwi\BlogBundle\Entity\PostState	1
Kiwi\WebBundle\Entity\Navigation	1
Kiwi\WebBundle\Entity\PageState	1

Entities Mapping

Class	Mapping errors
Kiwi\AdminBundle\Entity\Language	No errors.
Kiwi\AdminBundle\Entity\Project	No errors.
Kiwi\AdminBundle\Entity\KiwiUser	No errors.
Kiwi\AdminBundle\Entity\Module	No errors.
Kiwi\AdminBundle\Entity\Invite	No errors.
Kiwi\AdminBundle\Entity\ProjectInformation	No errors.
Kiwi\BlogBundle\Entity\Category	No errors.
Kiwi\BlogBundle\Entity\Post	No errors.
Kiwi\BlogBundle\Entity\PostState	No errors.
Kiwi\BlogBundle\Entity\Tag	No errors.
Kiwi\BlogBundle\Entity\PostSEO	No errors.
Kiwi\BlogBundle\Entity\PostRevision	No errors.
Kiwi\WebBundle\Entity\Navigation	No errors.
Kiwi\WebBundle\Entity\NavigationItem	The field Kiwi\WebBundle\Entity\NavigationItem#childrens is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Kiwi\WebBundle\Entity\NavigationItem#parent does not contain the required 'inversedBy="childrens"' attribute.
Kiwi\WebBundle\Entity\Page	No errors.
Kiwi\WebBundle\Entity\PageExcerpt	No errors.
Kiwi\WebBundle\Entity\PageSEO	No errors.
Kiwi\WebBundle\Entity\PageState	No errors.

Symfony Profiler

GET https://hotpeppers.e-online.cz/en/hot-news/oktagon-45

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping