GET https://dklab-symfony-cms.dev.nklck.cz/

Query Metrics

28 Database Queries
12 Different statements
19.69 ms Query time
0 Invalid entities
113 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.87 ms
(34.86%)
16
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.column_id AS column_id_4, t0.language_id AS language_id_5 FROM columns_translation t0 WHERE t0.column_id = ?
Parameters:
[
  1
]
2.62 ms
(13.28%)
1
SELECT p0_.id AS id_0, p0_.menu AS menu_1, p0_.show_submenu AS show_submenu_2, p0_.active AS active_3, p0_.sequence AS sequence_4, p0_.rights AS rights_5, p0_.og_logo AS og_logo_6, p1_.id AS id_7, p1_.name AS name_8, p1_.content AS content_9, p1_.url AS url_10, p1_.title AS title_11, p1_.keywords AS keywords_12, p1_.description AS description_13, p1_.banner AS banner_14, p1_.banner_mobile AS banner_mobile_15, p1_.last_modify AS last_modify_16, p1_.last_modifier AS last_modifier_17, p0_.parent_id AS parent_id_18, p1_.page_id AS page_id_19, p1_.language_id AS language_id_20 FROM pages p0_ LEFT JOIN pages_translation p1_ ON p0_.id = p1_.page_id WHERE p0_.active = 1 AND p0_.menu = 1 ORDER BY p0_.sequence ASC
Parameters:
[]
2.12 ms
(10.78%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.facebook AS facebook_4, t0.instagram AS instagram_5, t0.homepage_page_id AS homepage_page_id_6, t0.is_multi_domain AS is_multi_domain_7, t0.domain AS domain_8, t0.access_login AS access_login_9, t0.access_password AS access_password_10, t0.access_active AS access_active_11 FROM site_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.11 ms
(10.70%)
1
SELECT i0_.key_name AS key_name_0, i1_.translation AS translation_1 FROM i18n_translation i1_ INNER JOIN i18n_translation_key i0_ ON i1_.key_id = i0_.id INNER JOIN i18n_language i2_ ON i1_.language_id = i2_.id WHERE i0_.domain = ? AND i2_.shortcut = ? AND i2_.is_active = 1
Parameters:
[
  "messages"
  "cs"
]
1.19 ms
(6.05%)
2
SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.sequence AS sequence_2, c0_.active AS active_3, c0_.heading AS heading_4, c0_.page_link AS page_link_5, c0_.rights AS rights_6 FROM columns c0_ ORDER BY c0_.position ASC, c0_.sequence ASC
Parameters:
[]
0.93 ms
(4.74%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.url AS url_4, t0.title AS title_5, t0.keywords AS keywords_6, t0.description AS description_7, t0.banner AS banner_8, t0.banner_mobile AS banner_mobile_9, t0.last_modify AS last_modify_10, t0.last_modifier AS last_modifier_11, t0.page_id AS page_id_12, t0.language_id AS language_id_13 FROM pages_translation t0 WHERE t0.page_id = ?
Parameters:
[
  41
]
0.79 ms
(3.99%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.link AS link_3, b0_.image AS image_4, b0_.image_mobile AS image_mobile_5, b0_.date_from AS date_from_6, b0_.date_to AS date_to_7, b0_.active AS active_8, b0_.sort AS sort_9, b0_.language_id AS language_id_10 FROM banner b0_ ORDER BY b0_.sort ASC
Parameters:
[]
0.76 ms
(3.88%)
1
SELECT t0.id AS id_1, t0.menu AS menu_2, t0.show_submenu AS show_submenu_3, t0.active AS active_4, t0.sequence AS sequence_5, t0.rights AS rights_6, t0.og_logo AS og_logo_7, t0.parent_id AS parent_id_8 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  41
]
0.68 ms
(3.47%)
1
SELECT r0_.id AS id_0, r0_.from_url AS from_url_1, r0_.to_url AS to_url_2 FROM redirect r0_ WHERE r0_.from_url = ?
Parameters:
[
  ""
]
0.63 ms
(3.19%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.url_prefix AS url_prefix_3, t0.module AS module_4, t0.entity_id AS entity_id_5, t0.language_id AS language_id_6 FROM routing_url_index t0 WHERE t0.module = ? AND t0.language_id = ?
Parameters:
[
  "page"
  1
]
0.60 ms
(3.06%)
1
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.shortcut AS shortcut_2, i0_.is_default AS is_default_3, i0_.is_active AS is_active_4 FROM i18n_language i0_ WHERE i0_.is_active = ? ORDER BY i0_.id ASC
Parameters:
[
  1
]
0.40 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.default_keywords AS default_keywords_3, t0.default_description AS default_description_4, t0.meta_head AS meta_head_5, t0.footer_text AS footer_text_6, t0.tag_manager_id AS tag_manager_id_7, t0.analytics_id AS analytics_id_8, t0.ads_conversion_id AS ads_conversion_id_9, t0.ads_conversion_label AS ads_conversion_label_10, t0.domain AS domain_11, t0.footer_script AS footer_script_12, t0.settings_id AS settings_id_13, t0.language_id AS language_id_14 FROM site_settings_translation t0 WHERE t0.settings_id = ?
Parameters:
[
  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
DkLAB\CmsCore\Modules\Routing\Domain\Entity\UrlIndex 25
DkLAB\CmsCore\Modules\Column\Domain\Entity\ColumnTranslation 25
DkLAB\CmsCore\Modules\Pages\Domain\Entity\PageTranslation 20
DkLAB\CmsCore\Modules\Column\Domain\Entity\Column 16
DkLAB\CmsCore\Modules\Pages\Domain\Entity\Page 13
DkLAB\CmsCore\Modules\Banner\Domain\Entity\Banner 7
DkLAB\CmsCore\Modules\I18n\Domain\Entity\Language 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettingsTranslation 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettings 1