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

Query Metrics

39 Database Queries
19 Different statements
12.94 ms Query time
0 Invalid entities
130 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.40 ms
(26.28%)
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
]
1.90 ms
(14.65%)
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.80 ms
(6.18%)
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.77 ms
(5.98%)
3
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.active AS active_3, t0.whisperer AS whisperer_4 FROM products_param t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.75 ms
(5.78%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.param_id AS param_id_3, t0.language_id AS language_id_4 FROM products_param_translation t0 WHERE t0.param_id = ?
Parameters:
[
  1
]
0.73 ms
(5.68%)
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.67 ms
(5.19%)
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.51 ms
(3.91%)
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.39 ms
(2.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.url_prefix = ? AND t0.url = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  ""
  "hammer-strength-fitness"
  1
]
0.36 ms
(2.82%)
1
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:
[
  10
]
0.36 ms
(2.80%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.param_id AS param_id_4, t0.language_id AS language_id_5 FROM products_product_param t0 WHERE t0.product_id = ?
Parameters:
[
  10
]
0.34 ms
(2.62%)
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:
[
  "hammer-strength-fitness"
]
0.34 ms
(2.62%)
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.32 ms
(2.50%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.image AS image_3, t0.image_big AS image_big_4, t0.sort AS sort_5, t0.gallery AS gallery_6, t0.top AS top_7, t0.password AS password_8 FROM products t0 WHERE t0.id = ?
Parameters:
[
  10
]
0.29 ms
(2.23%)
1
SELECT t0.product_id AS product_id_1, t0.label_id AS label_id_2 FROM products_product_label t0 WHERE t0.product_id = ?
Parameters:
[
  10
]
0.27 ms
(2.12%)
1
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.active AS active_3, t0.category_id AS category_id_4 FROM gallery_gallery t0 WHERE t0.id = ?
Parameters:
[
  0
]
0.25 ms
(1.94%)
1
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.active AS active_3 FROM products_label t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.25 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label_id AS label_id_3, t0.language_id AS language_id_4 FROM products_label_translation t0 WHERE t0.label_id = ?
Parameters:
[
  1
]
0.23 ms
(1.79%)
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 26
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\Products\Domain\Entity\ProductParam 6
DkLAB\CmsCore\Modules\Products\Domain\Entity\Param 6
DkLAB\CmsCore\Modules\Products\Domain\Entity\ParamTranslation 6
DkLAB\CmsCore\Modules\I18n\Domain\Entity\Language 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettingsTranslation 3
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettings 1
DkLAB\CmsCore\Modules\Products\Domain\Entity\Product 1
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductTranslation 1
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductLabel 1
DkLAB\CmsCore\Modules\Products\Domain\Entity\Label 1
DkLAB\CmsCore\Modules\Products\Domain\Entity\LabelTranslation 1

Entities Mapping

Class Mapping errors
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettings No errors.
DkLAB\CmsCore\Modules\Settings\Domain\Entity\SiteSettingsTranslation No errors.
DkLAB\CmsCore\Modules\I18n\Domain\Entity\Language No errors.
DkLAB\CmsCore\Modules\Redirect\Domain\Entity\Redirect No errors.
DkLAB\CmsCore\Modules\Routing\Domain\Entity\UrlIndex No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\Product No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductTranslation No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductCategory No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductLabel No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductAccessory No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductParam No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductFile No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductDate No errors.
DkLAB\CmsCore\Modules\Pages\Domain\Entity\Page No errors.
DkLAB\CmsCore\Modules\Pages\Domain\Entity\PageTranslation No errors.
DkLAB\CmsCore\Modules\Column\Domain\Entity\Column No errors.
DkLAB\CmsCore\Modules\Column\Domain\Entity\ColumnTranslation No errors.
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\Gallery No errors.
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\Category No errors.
DkLAB\CmsCore\Modules\I18n\Domain\Entity\Translation No errors.
DkLAB\CmsCore\Modules\I18n\Domain\Entity\TranslationKey No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\Param No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\ParamTranslation No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\Label No errors.
DkLAB\CmsCore\Modules\Products\Domain\Entity\LabelTranslation No errors.