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

Query Metrics

49 Database Queries
21 Different statements
37.94 ms Query time
0 Invalid entities
141 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.24 ms
(13.80%)
1
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.gallery_id AS gallery_id_3 FROM gallery_photo t0 WHERE t0.gallery_id = ?
Parameters:
[
  14
]
3.72 ms
(9.81%)
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
]
3.55 ms
(9.34%)
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:
[
  19
]
3.47 ms
(9.14%)
5
SELECT t0.id AS id_1, t0.description AS description_2, t0.photo_id AS photo_id_3, t0.language_id AS language_id_4 FROM gallery_photo_description t0 WHERE t0.photo_id = ?
Parameters:
[
  66
]
3.44 ms
(9.06%)
5
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
]
2.47 ms
(6.52%)
5
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
]
2.42 ms
(6.37%)
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:
[
  2
]
2.23 ms
(5.89%)
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"
]
2.16 ms
(5.70%)
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:
[
  2
]
1.96 ms
(5.16%)
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:
[
  19
]
1.82 ms
(4.80%)
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:
[
  14
]
0.92 ms
(2.44%)
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:
[
  ""
  "barnaby"
  1
]
0.90 ms
(2.38%)
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.81 ms
(2.14%)
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.57 ms
(1.52%)
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.51 ms
(1.33%)
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.43 ms
(1.12%)
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:
[
  19
]
0.37 ms
(0.97%)
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:
[
  19
]
0.35 ms
(0.92%)
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.31 ms
(0.83%)
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.30 ms
(0.78%)
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:
[
  "barnaby"
]

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\ParamTranslation 10
DkLAB\CmsCore\Modules\Products\Domain\Entity\ProductParam 6
DkLAB\CmsCore\Modules\Products\Domain\Entity\Param 6
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\GalleryPhoto 5
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\Gallery\Domain\Entity\Gallery 1
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\Category 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\Gallery\Domain\Entity\GalleryTranslation No errors.
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\GalleryPhoto 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.
DkLAB\CmsCore\Modules\Gallery\Domain\Entity\GalleryPhotoDescription No errors.