Query Metrics

7 Database Queries
7 Different statements
10.47 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.97 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:
[
  "realizacje"
  0
]
2 2.44 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 a0_.id = ? AND a1_.slug = ? AND a2_.root = ?
Parameters:
[
  "2024-11-24 19:04:42"
  "152"
  "zestaw-mebli-dla-gastronomii"
  66
]
3 4.07 ms
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"
]
4 1.41 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 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"
]
5 0.55 ms
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
]
6 0.58 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 19:04:42"
  "menu"
  "pl"
]
7 0.47 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
]

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.