Query Metrics
36
Database Queries
14
Different statements
53.89 ms
Query time
1
Invalid entities
53
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.51 ms (38.06%) |
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 = ?
Parameters:
[ "PUBLISHED" "2026-10-13 05:19:03" 1 2 1 "oktagon-45" ] |
|
9.43 ms (17.50%) |
4 |
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" ] |
|
7.47 ms (13.86%) |
19 |
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
]
|
|
3.94 ms (7.31%) |
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 = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "hot-news" 1 ] |
|
3.24 ms (6.01%) |
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_.translation_group_id = ? ORDER BY l3_.id ASC
Parameters:
[ "PUBLISHED" "2026-10-13 05:19:03" 1 "21d977e9-a66b-5c31-a9b5-c8637e09b39c" ] |
|
1.66 ms (3.07%) |
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_.id IN (?, ?, ?, ?) ORDER BY k0_.published_at DESC, k0_.id DESC
Parameters:
[ "PUBLISHED" "2026-10-13 05:19:03" 180 178 174 171 ] |
|
1.53 ms (2.84%) |
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 4
Parameters:
[ "PUBLISHED" "2026-10-13 05:19:03" 1 2 1 ] |
|
1.40 ms (2.60%) |
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 = ?
Parameters:
[
1
]
|
|
1.24 ms (2.31%) |
2 |
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 ] |
|
1.05 ms (1.95%) |
1 |
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"
]
|
|
0.80 ms (1.48%) |
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 = ?
Parameters:
[
2
]
|
|
0.68 ms (1.27%) |
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 ?
Parameters:
[
"%hotpeppers.e-online.cz%"
]
|
|
0.47 ms (0.88%) |
1 |
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
]
|
|
0.47 ms (0.87%) |
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.name = ? LIMIT 1
Parameters:
[ 2 "footer" ] |
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 |