Query Metrics
18
Database Queries
10
Different statements
14.93 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.07 ms (27.24%) |
1 |
SELECT e0_.id AS id_0, e0_.updated_date AS updated_date_1, e0_.created_date AS created_date_2, e0_.published_date AS published_date_3, e0_.position AS position_4, e0_.ticket_id AS ticket_id_5, e0_.image_position AS image_position_6, e0_.image AS image_7, e0_.image_orientation AS image_orientation_8, e0_.cover_image_position AS cover_image_position_9, e0_.cover_image AS cover_image_10, e0_.custom_template AS custom_template_11, e1_.id AS id_12, e1_.title AS title_13, e1_.slug AS slug_14, e1_.redirect_url AS redirect_url_15, e1_.content_lead AS content_lead_16, e1_.content1 AS content1_17, e1_.content2 AS content2_18, e1_.content3 AS content3_19, e1_.content4 AS content4_20, e1_.updated_date AS updated_date_21, e1_.meta_title AS meta_title_22, e1_.meta_description AS meta_description_23, e1_.meta_keywords AS meta_keywords_24, e1_.canonical_tag AS canonical_tag_25, e1_.no_index AS no_index_26, e1_.no_follow AS no_follow_27, e1_.hide_in_sitemap AS hide_in_sitemap_28, e1_.locale AS locale_29, e2_.id AS id_30, e2_.start_date AS start_date_31, e2_.end_date AS end_date_32, e2_.hour AS hour_33, e2_.position AS position_34, e0_.user_id AS user_id_35, e1_.translatable_id AS translatable_id_36, e2_.event_id AS event_id_37 FROM event e0_ LEFT JOIN event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN event_dates e2_ ON e0_.id = e2_.event_id LEFT JOIN events_categories e4_ ON e0_.id = e4_.event_id LEFT JOIN event_categories e3_ ON e3_.id = e4_.category_id LEFT JOIN event_categories_translation e5_ ON e3_.id = e5_.translatable_id WHERE (e0_.published_date <= ? AND e0_.published_date IS NOT NULL) AND EXISTS (SELECT 1 FROM articles_events a6_ WHERE a6_.event_id = e0_.id AND a6_.article_id IN (?)) AND e1_.locale = ? ORDER BY e0_.position DESC, e2_.end_date DESC, e2_.start_date DESC, e2_.hour ASC, e0_.published_date DESC, e2_.position ASC
Parameters:
[ "2024-11-24 19:04:42" 152 "pl" ] |
2.44 ms (16.33%) |
1 |
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 a0_.id = ? AND a1_.slug = ? AND a2_.root = ?
Parameters:
[ "2024-11-24 19:04:42" "152" "zestaw-mebli-dla-gastronomii" 66 ] |
1.72 ms (11.55%) |
5 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.url AS url_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM media_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
633
]
|
1.45 ms (9.70%) |
3 |
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 19:04:42" "stopka" ] |
1.41 ms (9.45%) |
1 |
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 a0_.id <> ? AND a2_.id = ? AND a1_.locale = ? GROUP BY a0_.id ORDER BY a0_.position DESC, a0_.published_date DESC LIMIT 3
Parameters:
[ "2024-11-24 19:04:42" 152 66 "pl" ] |
1.28 ms (8.59%) |
3 |
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:
[
158
]
|
0.97 ms (6.48%) |
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:
[ "realizacje" 0 ] |
0.58 ms (3.86%) |
1 |
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 19:04:42" "menu" "pl" ] |
0.55 ms (3.67%) |
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.article_id = ? ORDER BY t0.position ASC
Parameters:
[
152
]
|
0.47 ms (3.14%) |
1 |
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
]
|
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\Article | No errors. |
App\Entity\Article\Category | 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\Event\EventTranslation | No errors. |
App\Entity\Event\EventDate | No errors. |
App\Entity\Event\Category | No errors. |
App\Entity\Event\CategoryTranslation | No errors. |
App\Entity\Content\Content | No errors. |
App\Entity\Block\Block | No errors. |
App\Entity\Media\MediaTranslation | No errors. |
App\Entity\Block\BlockTranslation | No errors. |
App\Entity\Security\RolePermission | No errors. |
App\Entity\Metadata\MetadataTranslation | No errors. |
App\Entity\Content\ContentTranslation | No errors. |