Query Metrics
26
Database Queries
6
Different statements
12.67 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.94 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:
[ "o-firmie" 0 ] |
2 | 1.35 ms |
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 18:53:38" "o-firmie" "pl" ] |
3 | 0.64 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.content_id = ? ORDER BY t0.position ASC
Parameters:
[
476
]
|
4 | 0.61 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" ] |
5 | 0.46 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
]
|
6 | 0.50 ms |
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:
[
710
]
|
7 | 0.35 ms |
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:
[
711
]
|
8 | 0.40 ms |
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:
[
712
]
|
9 | 0.38 ms |
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:
[
713
]
|
10 | 0.39 ms |
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:
[
714
]
|
11 | 0.42 ms |
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:
[
715
]
|
12 | 0.37 ms |
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:
[
716
]
|
13 | 0.45 ms |
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:
[
717
]
|
14 | 0.36 ms |
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:
[
718
]
|
15 | 0.39 ms |
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:
[
719
]
|
16 | 0.40 ms |
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:
[
720
]
|
17 | 0.47 ms |
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:
[
721
]
|
18 | 0.38 ms |
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:
[
722
]
|
19 | 0.39 ms |
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:
[
723
]
|
20 | 0.38 ms |
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:
[
724
]
|
21 | 0.40 ms |
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:
[
725
]
|
22 | 0.41 ms |
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:
[
726
]
|
23 | 0.41 ms |
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:
[
727
]
|
24 | 0.41 ms |
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:
[
728
]
|
25 | 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 18:53:38" "kontaktMetalmix" "pl" ] |
26 | 0.46 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:
[
46
]
|
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\Media\MediaTranslation | No errors. |
App\Entity\Block\BlockTranslation | 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. |