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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.76 ms
(21.08%)
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.65 ms
(14.86%)
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:
[
  120
]
1.48 ms
(8.30%)
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.27 ms
(7.13%)
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
]
1.07 ms
(5.96%)
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
]
0.90 ms
(5.03%)
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.84 ms
(4.69%)
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.70 ms
(3.91%)
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.69 ms
(3.89%)
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:
[
  "instaxstore"
]
0.56 ms
(3.15%)
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
]
0.53 ms
(2.98%)
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.52 ms
(2.89%)
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:
[
  ""
  "instaxstore"
  1
]
0.46 ms
(2.59%)
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:
[
  26
]
0.39 ms
(2.17%)
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:
[
  16
]
0.38 ms
(2.15%)
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:
[
  16
]
0.37 ms
(2.05%)
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.36 ms
(2.04%)
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:
[
  16
]
0.24 ms
(1.34%)
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:
[
  26
]
0.24 ms
(1.32%)
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.22 ms
(1.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:
[
  16
]
0.22 ms
(1.21%)
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
]

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.