Query Metrics
12
Database Queries
10
Different statements
7.60 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.86 ms |
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:
[ "nowosci" 0 ] |
2 | 0.56 ms |
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 = ?
Parameters:
[ "technologie" 1 63 ] |
3 | 0.67 ms |
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN article_translation a1_ ON a0_.id = a1_.translatable_id LEFT JOIN articles_categories a3_ ON a0_.id = a3_.article_id LEFT JOIN article_categories a2_ ON a2_.id = a3_.category_id LEFT JOIN article_categories_translation a4_ ON a2_.id = a4_.translatable_id WHERE (a0_.published_date <= ? AND a0_.published_date IS NOT NULL) AND a2_.id = ?
Parameters:
[ "2024-11-24 18:53:38" 65 ] |
4 | 0.64 ms |
SELECT DISTINCT a0_.id AS id_0, a0_.position AS position_1, a0_.published_date AS published_date_2 FROM article a0_ LEFT JOIN article_translation a1_ ON a0_.id = a1_.translatable_id LEFT JOIN articles_categories a3_ ON a0_.id = a3_.article_id LEFT JOIN article_categories a2_ ON a2_.id = a3_.category_id LEFT JOIN article_categories_translation a4_ ON a2_.id = a4_.translatable_id WHERE (a0_.published_date <= ? AND a0_.published_date IS NOT NULL) AND a2_.id = ? ORDER BY a0_.position DESC, a0_.published_date DESC LIMIT 10
Parameters:
[ "2024-11-24 18:53:38" 65 ] |
5 | 0.88 ms |
SELECT a0_.id AS id_0, a0_.updated_date AS updated_date_1, a0_.created_date AS created_date_2, a0_.published_date AS published_date_3, a0_.position AS position_4, a0_.image_position AS image_position_5, a0_.image AS image_6, a0_.custom_template AS custom_template_7, a0_.image_orientation AS image_orientation_8, a0_.cover_image_position AS cover_image_position_9, a0_.cover_image AS cover_image_10, a1_.id AS id_11, a1_.title AS title_12, a1_.slug AS slug_13, a1_.redirect_url AS redirect_url_14, a1_.content_lead AS content_lead_15, a1_.content1 AS content1_16, a1_.content2 AS content2_17, a1_.content3 AS content3_18, a1_.content4 AS content4_19, a1_.updated_date AS updated_date_20, a1_.meta_title AS meta_title_21, a1_.meta_description AS meta_description_22, a1_.meta_keywords AS meta_keywords_23, a1_.canonical_tag AS canonical_tag_24, a1_.no_index AS no_index_25, a1_.no_follow AS no_follow_26, a1_.hide_in_sitemap AS hide_in_sitemap_27, a1_.locale AS locale_28, a0_.user_id AS user_id_29, a1_.translatable_id AS translatable_id_30 FROM article a0_ LEFT JOIN article_translation a1_ ON a0_.id = a1_.translatable_id LEFT JOIN articles_categories a3_ ON a0_.id = a3_.article_id LEFT JOIN article_categories a2_ ON a2_.id = a3_.category_id LEFT JOIN article_categories_translation a4_ ON a2_.id = a4_.translatable_id WHERE (a0_.published_date <= ? AND a0_.published_date IS NOT NULL) AND a2_.id = ? AND a0_.id IN (?) ORDER BY a0_.position DESC, a0_.published_date DESC
Parameters:
[ "2024-11-24 18:53:38" 65 144 ] |
6 | 0.66 ms |
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 a0_.lvl = ? AND a0_.root = ? ORDER BY a0_.position ASC
Parameters:
[ 1 63 ] |
7 | 0.66 ms |
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 18:53:38" "menu" "pl" ] |
8 | 0.61 ms |
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
]
|
9 | 0.53 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.created_date AS created_date_3, t0.position AS position_4, t0.show_comments AS show_comments_5, t0.show_recent AS show_recent_6, t0.image_position AS image_position_7, t0.image AS image_8, t0.custom_template AS custom_template_9, t0.custom_item_template AS custom_item_template_10, t0.pagination_limit AS pagination_limit_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.root AS root_15, t0.parent_id AS parent_id_16 FROM article_categories t0 INNER JOIN articles_categories ON t0.id = articles_categories.category_id WHERE articles_categories.article_id = ?
Parameters:
[
144
]
|
10 | 0.54 ms |
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 = ?
Parameters:
[ "2024-11-24 18:53:38" "stopka" ] |
11 | 0.51 ms |
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 = ?
Parameters:
[ "2024-11-24 18:53:38" "stopkaKontakt" ] |
12 | 0.47 ms |
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 = ?
Parameters:
[ "2024-11-24 18:53:38" "cookies" ] |
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\Article\ArticleTranslation | No errors. |
App\Entity\User\User | No errors. |
App\Entity\Media\Media | No errors. |
App\Entity\Metadata\Metadata | No errors. |
App\Entity\Comment\Comment | 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\Content\Content | No errors. |
App\Entity\Security\RolePermission | No errors. |
App\Entity\Metadata\MetadataTranslation | No errors. |
App\Entity\Event\Category | No errors. |
App\Entity\Event\EventDate | No errors. |
App\Entity\Event\EventTranslation | No errors. |
App\Entity\Content\ContentTranslation | No errors. |