Query Metrics
97
Database Queries
23
Different statements
469.18 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
395.69 ms (84.34%) |
6 |
SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0
Parameters:
[] |
18.14 ms (3.87%) |
1 |
SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = ?) LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) JOIN (SELECT DISTINCT o.object_identifier as id FROM host7_gcs_dev.acl_object_identities as o INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id LEFT JOIN host7_gcs_dev.acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN host7_gcs_dev.acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node" AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY") AND e.mask & 1 > 0) ta_ ON k0_.id = ta_.id WHERE k0_.deleted = 0 AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC
Parameters:
[
"pl"
]
|
14.59 ms (3.11%) |
30 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1879" "pl" "Kunstmaan\MediaBundle\Entity\Media" ] |
6.19 ms (1.32%) |
1 |
SELECT g0_.show_on_homepage AS show_on_homepage_0, g0_.date AS date_1, g0_.summary AS summary_2, g0_.title AS title_3, g0_.page_title AS page_title_4, g0_.id AS id_5, g0_.gfx_menu AS gfx_menu_6, g0_.collor_class AS collor_class_7, g0_.news_author_id AS news_author_id_8 FROM gcs_news_pages g0_ INNER JOIN kuma_node_versions k1_ ON (g0_.id = k1_.ref_id) INNER JOIN kuma_node_translations k2_ ON (k2_.public_node_version_id = k1_.id) INNER JOIN kuma_nodes k3_ ON (k2_.node_id = k3_.id) WHERE k2_.online = 1 AND k3_.deleted = 0 AND k1_.ref_entity_name = ? AND k2_.lang = ? ORDER BY g0_.date DESC
Parameters:
[ "App\Entity\Pages\NewsPage" "pl" ] |
4.95 ms (1.05%) |
9 |
SELECT t0.type AS type_1, t0.owner AS owner_2, t0.created AS created_3, t0.updated AS updated_4, t0.ref_id AS ref_id_5, t0.ref_entity_name AS ref_entity_name_6, t0.id AS id_7, t0.node_translation_id AS node_translation_id_8, t0.origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1
Parameters:
[ "1169" "App\Entity\Pages\NewsPage" ] |
4.71 ms (1.00%) |
9 |
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.description AS description_3, t0.copyright AS copyright_4, t0.location AS location_5, t0.content_type AS content_type_6, t0.metadata AS metadata_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.filesize AS filesize_10, t0.url AS url_11, t0.original_filename AS original_filename_12, t0.deleted AS deleted_13, t0.removed_from_file_system AS removed_from_file_system_14, t0.id AS id_15, t0.folder_id AS folder_id_16 FROM kuma_media t0 WHERE t0.id = ?
Parameters:
[
"1879"
]
|
4.46 ms (0.95%) |
9 |
SELECT t0.id AS id_1, t0.media_alt AS media_alt_2, t0.cropping AS cropping_3, t0.media_id AS media_id_4 FROM list_image t0 INNER JOIN gcs_pages_list_images_news_page ON t0.id = gcs_pages_list_images_news_page.list_image_id WHERE gcs_pages_list_images_news_page.news_page_id = ?
Parameters:
[
"1169"
]
|
4.21 ms (0.90%) |
9 |
SELECT t0.name AS name_1, t0.deleted_at AS deleted_at_2, t0.id AS id_3 FROM gcs_news_tags t0 INNER JOIN news_page_news_tag ON t0.id = news_page_news_tag.news_tag_id WHERE news_page_news_tag.news_page_id = ?
Parameters:
[
"1169"
]
|
3.10 ms (0.66%) |
6 |
SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"facebook"
]
|
2.70 ms (0.58%) |
2 |
SELECT k0_.type AS type_0, k0_.title AS title_1, k0_.url AS url_2, k0_.new_window AS new_window_3, k0_.lft AS lft_4, k0_.lvl AS lvl_5, k0_.rgt AS rgt_6, k0_.id AS id_7, k1_.type AS type_8, k1_.title AS title_9, k1_.url AS url_10, k1_.new_window AS new_window_11, k1_.lft AS lft_12, k1_.lvl AS lvl_13, k1_.rgt AS rgt_14, k1_.id AS id_15, k2_.lang AS lang_16, k2_.online AS online_17, k2_.title AS title_18, k2_.slug AS slug_19, k2_.url AS url_20, k2_.weight AS weight_21, k2_.created AS created_22, k2_.updated AS updated_23, k2_.id AS id_24 FROM kuma_menu_item k0_ INNER JOIN kuma_menu k3_ ON k0_.menu_id = k3_.id LEFT JOIN kuma_menu_item k1_ ON k0_.parent_id = k1_.id LEFT JOIN kuma_node_translations k2_ ON k0_.node_translation_id = k2_.id LEFT JOIN kuma_nodes k4_ ON k2_.node_id = k4_.id WHERE k3_.locale = ? AND k3_.name = ? AND (k2_.online = 1 OR k0_.type = ?) ORDER BY k0_.lft ASC
Parameters:
[ "pl" "main_navigation" "url_link" ] |
2.43 ms (0.52%) |
2 |
SELECT k0_.lang AS lang_0, k0_.online AS online_1, k0_.title AS title_2, k0_.slug AS slug_3, k0_.url AS url_4, k0_.weight AS weight_5, k0_.created AS created_6, k0_.updated AS updated_7, k0_.id AS id_8, k1_.type AS type_9, k1_.owner AS owner_10, k1_.created AS created_11, k1_.updated AS updated_12, k1_.ref_id AS ref_id_13, k1_.ref_entity_name AS ref_entity_name_14, k1_.id AS id_15, k0_.node_id AS node_id_16, k0_.public_node_version_id AS public_node_version_id_17, k1_.node_translation_id AS node_translation_id_18, k1_.origin_id AS origin_id_19 FROM kuma_node_translations k0_ INNER JOIN kuma_nodes k2_ ON k0_.node_id = k2_.id AND (k0_.node_id = k2_.id) LEFT JOIN kuma_node_versions k1_ ON k0_.public_node_version_id = k1_.id AND (k0_.public_node_version_id = k1_.id) WHERE k2_.deleted = 0 AND k0_.lang = ? AND k0_.url = ? ORDER BY k0_.online DESC LIMIT 1
Parameters:
[ "pl" "aktualnosci" ] |
1.01 ms (0.22%) |
2 |
SELECT t0.id AS id_1, t0.media_alt AS media_alt_2, t0.cropping AS cropping_3, t0.media_id AS media_id_4 FROM header_image t0 INNER JOIN gcs_pages_header_images_news_page ON t0.id = gcs_pages_header_images_news_page.header_image_id WHERE gcs_pages_header_images_news_page.news_page_id = ?
Parameters:
[
"1169"
]
|
0.94 ms (0.20%) |
1 |
SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ INNER JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) WHERE k0_.deleted = 0 AND (k0_.lft <= 212 AND k0_.rgt >= 1285) ORDER BY k0_.lft ASC
Parameters:
[] |
0.77 ms (0.17%) |
1 |
SELECT o.id as acl_id, o.object_identifier, o.parent_object_identity_id, o.entries_inheriting, c.class_type, e.id as ace_id, e.object_identity_id, e.field_name, e.ace_order, e.mask, e.granting, e.granting_strategy, e.audit_success, e.audit_failure, s.username, s.identifier as security_identifier FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id LEFT JOIN acl_entries e ON ( e.class_id = o.class_id AND (e.object_identity_id = o.id OR e.object_identity_id IS NULL) ) LEFT JOIN acl_security_identities s ON ( s.id = e.security_identity_id ) WHERE (o.id =6)
Parameters:
[] |
0.70 ms (0.15%) |
1 |
SELECT a.ancestor_id FROM acl_object_identities o INNER JOIN acl_classes c ON c.id = o.class_id INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id WHERE ((o.object_identifier IN ('6') AND c.class_type = 'Kunstmaan\\NodeBundle\\Entity\\Node'))
Parameters:
[] |
0.68 ms (0.15%) |
1 |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_author AS meta_author_3, t0.meta_robots AS meta_robots_4, t0.og_type AS og_type_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.extra_metadata AS extra_metadata_8, t0.ref_id AS ref_id_9, t0.ref_entity_name AS ref_entity_name_10, t0.og_url AS og_url_11, t0.og_article_author AS og_article_author_12, t0.og_article_publisher AS og_article_publisher_13, t0.og_article_section AS og_article_section_14, t0.twitter_title AS twitter_title_15, t0.twitter_description AS twitter_description_16, t0.twitter_site AS twitter_site_17, t0.twitter_creator AS twitter_creator_18, t0.id AS id_19, t0.og_image_id AS og_image_id_20, t0.twitter_image_id AS twitter_image_id_21 FROM kuma_seo t0 WHERE t0.ref_id = ? AND t0.ref_entity_name = ? LIMIT 1
Parameters:
[ "1" "App\Entity\Pages\NewsOverviewPage" ] |
0.67 ms (0.14%) |
1 |
SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain
Parameters:
[] |
0.58 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.media_alt AS media_alt_2, t0.cropping AS cropping_3, t0.media_id AS media_id_4 FROM header_image t0 INNER JOIN gcs_pages_header_images_news_overview ON t0.id = gcs_pages_header_images_news_overview.header_image_id WHERE gcs_pages_header_images_news_overview.news_overview_page_id = ?
Parameters:
[
"1"
]
|
0.58 ms (0.12%) |
1 |
SELECT t0.page_id AS page_id_1, t0.page_entity_name AS page_entity_name_2, t0.page_template AS page_template_3, t0.id AS id_4 FROM kuma_page_template_configuration t0 WHERE t0.page_id = ? AND t0.page_entity_name = ? LIMIT 1
Parameters:
[ "1" "App\Entity\Pages\NewsOverviewPage" ] |
0.57 ms (0.12%) |
1 |
SELECT t0.domain AS domain_1, t0.origin AS origin_2, t0.note AS note_3, t0.target AS target_4, t0.permanent AS permanent_5, t0.id AS id_6 FROM kuma_redirects t0
Parameters:
[] |
0.55 ms (0.12%) |
1 |
SELECT t0.title AS title_1, t0.page_title AS page_title_2, t0.id AS id_3, t0.gfx_menu AS gfx_menu_4, t0.collor_class AS collor_class_5 FROM gcs_news_overview_pages t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
0.49 ms (0.10%) |
1 |
SELECT t0.name AS name_1, t0.deleted_at AS deleted_at_2, t0.id AS id_3, t0.gfx_menu AS gfx_menu_4, t0.collor_class AS collor_class_5 FROM gcs_news_categories t0 ORDER BY t0.name ASC
Parameters:
[] |
0.46 ms (0.10%) |
1 |
SELECT t0.name AS name_1, t0.deleted_at AS deleted_at_2, t0.id AS id_3 FROM gcs_news_tags t0 ORDER BY t0.name ASC
Parameters:
[] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
Kunstmaan\RedirectBundle\Entity\Redirect | No errors. |
Kunstmaan\TranslatorBundle\Entity\Translation | No errors. |
Kunstmaan\NodeBundle\Entity\NodeTranslation | No errors. |
Kunstmaan\NodeBundle\Entity\Node | No errors. |
Kunstmaan\NodeBundle\Entity\NodeVersion | No errors. |
App\Entity\Pages\NewsOverviewPage | No errors. |
App\Entity\HeaderImage | No errors. |
App\Entity\ListImage | No errors. |
App\Entity\Pages\NewsPage | No errors. |
App\Entity\NewsAuthor | No errors. |
App\Entity\NewsCategory | No errors. |
App\Entity\NewsTag | No errors. |
Kunstmaan\MediaBundle\Entity\Folder | No errors. |
Kunstmaan\PagePartBundle\Entity\PageTemplateConfiguration | No errors. |
Kunstmaan\MenuBundle\Entity\BaseMenuItem | No errors. |
Kunstmaan\MenuBundle\Entity\MenuItem | No errors. |
Kunstmaan\SeoBundle\Entity\Seo | No errors. |
Kunstmaan\MediaBundle\Entity\Media | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | No errors. |
App\Entity\SocialLink | No errors. |
Kunstmaan\MenuBundle\Entity\BaseMenu | No errors. |
Kunstmaan\MenuBundle\Entity\Menu | No errors. |
Kunstmaan\AdminBundle\Entity\Exception | No errors. |