Query Metrics
16
Database Queries
10
Different statements
19.24 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.62 ms (29.22%) |
4 |
SELECT c0_.id AS id_0, c0_.updated_date AS updated_date_1, c0_.created_date AS created_date_2, c0_.published_date AS published_date_3, c0_.position AS position_4, c0_.image_position AS image_position_5, c0_.image_orientation AS image_orientation_6, c0_.image AS image_7, c0_.cover_image_position AS cover_image_position_8, c0_.cover_image AS cover_image_9, c0_.custom_template AS custom_template_10, c1_.id AS id_11, c1_.title AS title_12, c1_.url AS url_13, c1_.path AS path_14, c1_.redirect_url AS redirect_url_15, c1_.target_blank AS target_blank_16, c1_.content1 AS content1_17, c1_.content2 AS content2_18, c1_.content3 AS content3_19, c1_.content4 AS content4_20, c1_.updated_date AS updated_date_21, c1_.meta_title AS meta_title_22, c1_.meta_description AS meta_description_23, c1_.meta_keywords AS meta_keywords_24, c1_.canonical_tag AS canonical_tag_25, c1_.no_index AS no_index_26, c1_.no_follow AS no_follow_27, c1_.hide_in_sitemap AS hide_in_sitemap_28, c1_.locale AS locale_29, c0_.user_id AS user_id_30, c0_.parent_id AS parent_id_31, c1_.translatable_id AS translatable_id_32 FROM contents c0_ LEFT JOIN content_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.published_date <= ? AND c0_.published_date IS NOT NULL) AND c0_.parent_id = ? ORDER BY c1_.title ASC
Parameters:
[ "2024-11-24 21:30:21" 420 ] |
2.99 ms (15.55%) |
1 |
SELECT c0_.id AS id_0, c0_.updated_date AS updated_date_1, c0_.created_date AS created_date_2, c0_.published_date AS published_date_3, c0_.position AS position_4, c0_.image_position AS image_position_5, c0_.image_orientation AS image_orientation_6, c0_.image AS image_7, c0_.cover_image_position AS cover_image_position_8, c0_.cover_image AS cover_image_9, c0_.custom_template AS custom_template_10, c1_.id AS id_11, c1_.title AS title_12, c1_.url AS url_13, c1_.path AS path_14, c1_.redirect_url AS redirect_url_15, c1_.target_blank AS target_blank_16, c1_.content1 AS content1_17, c1_.content2 AS content2_18, c1_.content3 AS content3_19, c1_.content4 AS content4_20, c1_.updated_date AS updated_date_21, c1_.meta_title AS meta_title_22, c1_.meta_description AS meta_description_23, c1_.meta_keywords AS meta_keywords_24, c1_.canonical_tag AS canonical_tag_25, c1_.no_index AS no_index_26, c1_.no_follow AS no_follow_27, c1_.hide_in_sitemap AS hide_in_sitemap_28, c1_.locale AS locale_29, c0_.user_id AS user_id_30, c0_.parent_id AS parent_id_31, c1_.translatable_id AS translatable_id_32 FROM contents c0_ LEFT JOIN content_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.published_date <= ? AND c0_.published_date IS NOT NULL) AND c1_.path = ? AND c1_.locale = ?
Parameters:
[ "2024-11-24 21:30:21" "produkty/bramy-i-ogrodzenia-balustrady-schody/balustrady" "pl" ] |
2.14 ms (11.11%) |
2 |
SELECT b0_.id AS id_0, b0_.alias AS alias_1, b0_.updated_date AS updated_date_2, b0_.created_date AS created_date_3, b0_.published_date AS published_date_4, b0_.image_position AS image_position_5, b0_.image AS image_6, b0_.template AS template_7, b1_.id AS id_8, b1_.title AS title_9, b1_.content1 AS content1_10, b1_.content2 AS content2_11, b1_.content3 AS content3_12, b1_.content4 AS content4_13, b1_.image_alt AS image_alt_14, b1_.updated_date AS updated_date_15, b1_.locale AS locale_16, b0_.user_id AS user_id_17, b1_.translatable_id AS translatable_id_18 FROM blocks b0_ LEFT JOIN block_translation b1_ ON b0_.id = b1_.translatable_id WHERE (b0_.published_date <= ? AND b0_.published_date IS NOT NULL) AND b0_.alias = ? AND b1_.locale = ? LIMIT 1
Parameters:
[ "2024-11-24 21:30:21" "menu" "pl" ] |
2.07 ms (10.78%) |
1 |
SELECT a0_.id AS id_0, a0_.updated_date AS updated_date_1, a0_.created_date AS created_date_2, a0_.position AS position_3, a0_.show_comments AS show_comments_4, a0_.show_recent AS show_recent_5, a0_.image_position AS image_position_6, a0_.image AS image_7, a0_.custom_template AS custom_template_8, a0_.custom_item_template AS custom_item_template_9, a0_.pagination_limit AS pagination_limit_10, a0_.lft AS lft_11, a0_.lvl AS lvl_12, a0_.rgt AS rgt_13, a1_.id AS id_14, a1_.title AS title_15, a1_.slug AS slug_16, a1_.content AS content_17, a1_.redirect_url AS redirect_url_18, a1_.updated_date AS updated_date_19, a1_.meta_title AS meta_title_20, a1_.meta_description AS meta_description_21, a1_.meta_keywords AS meta_keywords_22, a1_.canonical_tag AS canonical_tag_23, a1_.no_index AS no_index_24, a1_.no_follow AS no_follow_25, a1_.hide_in_sitemap AS hide_in_sitemap_26, a1_.locale AS locale_27, a0_.root AS root_28, a0_.parent_id AS parent_id_29, a1_.translatable_id AS translatable_id_30 FROM article_categories a0_ LEFT JOIN article_categories_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.slug = ? AND a0_.lvl = ? AND a0_.parent_id IS NULL
Parameters:
[ "produkty" 0 ] |
1.69 ms (8.77%) |
2 |
SELECT m0_.id AS id_0, m0_.updated_date AS updated_date_1, m0_.created_date AS created_date_2, m0_.mime_type AS mime_type_3, m0_.file_size AS file_size_4, m0_.media AS media_5, m0_.image_position AS image_position_6, m0_.position AS position_7, m1_.id AS id_8, m1_.title AS title_9, m1_.subtitle AS subtitle_10, m1_.description AS description_11, m1_.url AS url_12, m1_.locale AS locale_13, m0_.content_id AS content_id_14, m0_.event_id AS event_id_15, m0_.article_id AS article_id_16, m0_.block_id AS block_id_17, m1_.translatable_id AS translatable_id_18 FROM media m0_ LEFT JOIN media_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.block_id = ?
Parameters:
[
2
]
|
1.12 ms (5.82%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.path AS path_4, t0.redirect_url AS redirect_url_5, t0.target_blank AS target_blank_6, t0.content1 AS content1_7, t0.content2 AS content2_8, t0.content3 AS content3_9, t0.content4 AS content4_10, t0.updated_date AS updated_date_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.canonical_tag AS canonical_tag_15, t0.no_index AS no_index_16, t0.no_follow AS no_follow_17, t0.hide_in_sitemap AS hide_in_sitemap_18, t0.locale AS locale_19, t0.translatable_id AS translatable_id_20 FROM content_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
382
]
|
1.10 ms (5.71%) |
1 |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.created_date AS created_date_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.media AS media_6, t0.image_position AS image_position_7, t0.position AS position_8, t0.content_id AS content_id_9, t0.event_id AS event_id_10, t0.article_id AS article_id_11, t0.block_id AS block_id_12 FROM media t0 WHERE t0.content_id = ? ORDER BY t0.position ASC
Parameters:
[
418
]
|
0.99 ms (5.16%) |
1 |
SELECT c0_.id AS id_0, c0_.updated_date AS updated_date_1, c0_.created_date AS created_date_2, c0_.published_date AS published_date_3, c0_.position AS position_4, c0_.image_position AS image_position_5, c0_.image_orientation AS image_orientation_6, c0_.image AS image_7, c0_.cover_image_position AS cover_image_position_8, c0_.cover_image AS cover_image_9, c0_.custom_template AS custom_template_10, c1_.id AS id_11, c1_.title AS title_12, c1_.url AS url_13, c1_.path AS path_14, c1_.redirect_url AS redirect_url_15, c1_.target_blank AS target_blank_16, c1_.content1 AS content1_17, c1_.content2 AS content2_18, c1_.content3 AS content3_19, c1_.content4 AS content4_20, c1_.updated_date AS updated_date_21, c1_.meta_title AS meta_title_22, c1_.meta_description AS meta_description_23, c1_.meta_keywords AS meta_keywords_24, c1_.canonical_tag AS canonical_tag_25, c1_.no_index AS no_index_26, c1_.no_follow AS no_follow_27, c1_.hide_in_sitemap AS hide_in_sitemap_28, c1_.locale AS locale_29, c0_.user_id AS user_id_30, c0_.parent_id AS parent_id_31, c1_.translatable_id AS translatable_id_32 FROM contents c0_ LEFT JOIN content_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.published_date <= ? AND c0_.published_date IS NOT NULL) AND c0_.parent_id = ? ORDER BY c0_.position ASC
Parameters:
[ "2024-11-24 21:30:21" 382 ] |
0.83 ms (4.32%) |
1 |
SELECT c0_.id AS id_0, c0_.updated_date AS updated_date_1, c0_.created_date AS created_date_2, c0_.published_date AS published_date_3, c0_.position AS position_4, c0_.image_position AS image_position_5, c0_.image_orientation AS image_orientation_6, c0_.image AS image_7, c0_.cover_image_position AS cover_image_position_8, c0_.cover_image AS cover_image_9, c0_.custom_template AS custom_template_10, c1_.id AS id_11, c1_.title AS title_12, c1_.url AS url_13, c1_.path AS path_14, c1_.redirect_url AS redirect_url_15, c1_.target_blank AS target_blank_16, c1_.content1 AS content1_17, c1_.content2 AS content2_18, c1_.content3 AS content3_19, c1_.content4 AS content4_20, c1_.updated_date AS updated_date_21, c1_.meta_title AS meta_title_22, c1_.meta_description AS meta_description_23, c1_.meta_keywords AS meta_keywords_24, c1_.canonical_tag AS canonical_tag_25, c1_.no_index AS no_index_26, c1_.no_follow AS no_follow_27, c1_.hide_in_sitemap AS hide_in_sitemap_28, c1_.locale AS locale_29, c0_.user_id AS user_id_30, c0_.parent_id AS parent_id_31, c1_.translatable_id AS translatable_id_32 FROM contents c0_ LEFT JOIN content_translation c1_ ON c0_.id = c1_.translatable_id WHERE (c0_.published_date <= ? AND c0_.published_date IS NOT NULL) AND c0_.id = ? AND c1_.locale = ?
Parameters:
[ "2024-11-24 21:30:21" 382 "pl" ] |
0.68 ms (3.56%) |
1 |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.created_date AS created_date_3, t0.published_date AS published_date_4, t0.position AS position_5, t0.image_position AS image_position_6, t0.image_orientation AS image_orientation_7, t0.image AS image_8, t0.cover_image_position AS cover_image_position_9, t0.cover_image AS cover_image_10, t0.custom_template AS custom_template_11, t0.user_id AS user_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.updated_date AS updated_date_16, t14.created_date AS created_date_17, t14.published_date AS published_date_18, t14.position AS position_19, t14.image_position AS image_position_20, t14.image_orientation AS image_orientation_21, t14.image AS image_22, t14.cover_image_position AS cover_image_position_23, t14.cover_image AS cover_image_24, t14.custom_template AS custom_template_25, t14.user_id AS user_id_26, t14.parent_id AS parent_id_27 FROM contents t0 LEFT JOIN contents t14 ON t0.parent_id = t14.id WHERE t0.id IN (?)
Parameters:
[
382
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Article\Category | No errors. |
App\Entity\Article\Article | No errors. |
App\Entity\Article\CategoryTranslation | No errors. |
App\Entity\Content\Content | No errors. |
App\Entity\Content\ContentTranslation | No errors. |
App\Entity\User\User | No errors. |
App\Entity\Media\Media | No errors. |
App\Entity\Event\Event | No errors. |
App\Entity\Block\Block | No errors. |
App\Entity\Block\BlockTranslation | No errors. |
App\Entity\Media\MediaTranslation | No errors. |
App\Entity\Metadata\Metadata | No errors. |
App\Entity\Comment\Comment | No errors. |
App\Entity\Article\ArticleTranslation | No errors. |
App\Entity\Security\RolePermission | No errors. |
App\Entity\Event\Category | No errors. |
App\Entity\Event\EventDate | No errors. |
App\Entity\Event\EventTranslation | No errors. |
App\Entity\Metadata\MetadataTranslation | No errors. |
App\Entity\Security\Permission | No errors. |
App\Entity\Event\CategoryTranslation | No errors. |