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

Query Metrics

75 Database Queries
15 Different statements
34.15 ms Query time
0 Invalid entities
195 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.57 ms
(33.88%)
23
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.perex AS perex_4, t0.content AS content_5, t0.content2 AS content2_6, t0.content3 AS content3_7, t0.content4 AS content4_8, t0.title AS title_9, t0.keywords AS keywords_10, t0.description AS description_11, t0.banner AS banner_12, t0.banner_mobile AS banner_mobile_13, t0.product_id AS product_id_14, t0.language_id AS language_id_15 FROM products_translation t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
6.81 ms
(19.93%)
23
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.entity_id = ?
Parameters:
[
  "product"
  1
]
4.10 ms
(12.01%)
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
]
4.06 ms
(11.89%)
1
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.image AS image_2, p0_.image_big AS image_big_3, p0_.sort AS sort_4, p0_.gallery AS gallery_5, p0_.top AS top_6, p0_.password AS password_7 FROM products p0_ ORDER BY p0_.sort ASC
Parameters:
[]
1.37 ms
(4.01%)
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"
]
0.95 ms
(2.79%)
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
]
0.77 ms
(2.26%)
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.url_prefix = ? AND t0.url = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  ""
  "reference"
  1
]
0.77 ms
(2.26%)
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:
[]
0.73 ms
(2.15%)
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.66 ms
(1.93%)
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.63 ms
(1.83%)
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:
[
  158
]
0.56 ms
(1.64%)
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:
[
  158
]
0.50 ms
(1.45%)
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:
[
  "reference"
]
0.34 ms
(0.99%)
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
]
0.33 ms
(0.98%)
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
]

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 48
DkLAB\CmsCore\Modules\Products\Domain\Entity\Product 43
DkLAB\CmsCore\Modules\Column\Domain\Entity\ColumnTranslation 25
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductTranslation 23
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\I18n\Domain\Entity\Language 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettingsTranslation 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettings 1