Query Metrics

6 Database Queries
6 Different statements
1.75 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.image AS image_6, t0.is_published AS is_published_7, t0.meta_description AS meta_description_8, t0.seo_keyword AS seo_keyword_9, t0.article_type AS article_type_10, t0.facebook_text AS facebook_text_11, t0.instagram_caption AS instagram_caption_12, t0.published_facebook AS published_facebook_13, t0.facebook_published_at AS facebook_published_at_14, t0.facebook_post_id AS facebook_post_id_15, t0.published_instagram AS published_instagram_16, t0.instagram_published_at AS instagram_published_at_17, t0.instagram_post_id AS instagram_post_id_18, t0.category_id AS category_id_19 FROM blog_post t0 WHERE t0.slug = ? AND t0.is_published = ? LIMIT 1
Parameters:
[
  "wetterlage-anfang-jaenner-update-viel-bewegung-klare-tendenzen-aber-voraussichtlich-kein-extrem"
  1
]
2 0.20 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.client_name AS client_name_2, p0_.image_path AS image_path_3, p0_.target_url AS target_url_4, p0_.placement AS placement_5, p0_.width AS width_6, p0_.height AS height_7, p0_.limit_type AS limit_type_8, p0_.max_views AS max_views_9, p0_.max_clicks AS max_clicks_10, p0_.starts_at AS starts_at_11, p0_.ends_at AS ends_at_12, p0_.view_count AS view_count_13, p0_.click_count AS click_count_14, p0_.status AS status_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17 FROM paid_banner p0_ WHERE p0_.placement = ? AND p0_.status = ? LIMIT 1
Parameters:
[
  "blog_article_sidebar"
  "active"
]
3 0.27 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6, b0_.meta_description AS meta_description_7, b0_.seo_keyword AS seo_keyword_8, b0_.article_type AS article_type_9, b0_.facebook_text AS facebook_text_10, b0_.instagram_caption AS instagram_caption_11, b0_.published_facebook AS published_facebook_12, b0_.facebook_published_at AS facebook_published_at_13, b0_.facebook_post_id AS facebook_post_id_14, b0_.published_instagram AS published_instagram_15, b0_.instagram_published_at AS instagram_published_at_16, b0_.instagram_post_id AS instagram_post_id_17, b0_.category_id AS category_id_18 FROM blog_post b0_ WHERE b0_.is_published = ? AND b0_.id NOT IN (?) ORDER BY b0_.created_at DESC LIMIT 4
Parameters:
[
  1
  78
]
4 0.27 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.sort_order AS sort_order_3, COUNT(b1_.id) AS sclr_4 FROM blog_category b0_ LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id AND (b1_.is_published = ?) GROUP BY b0_.id ORDER BY b0_.sort_order ASC, b0_.name ASC
Parameters:
[
  1
]
5 0.21 ms
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.header_badge_text AS header_badge_text_3, t0.header_kicker AS header_kicker_4, t0.impressum_url AS impressum_url_5, t0.datenschutz_url AS datenschutz_url_6, t0.footer_html AS footer_html_7, t0.snippets AS snippets_8, t0.updated_at AS updated_at_9 FROM email_template_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.15 ms
SELECT t0.id AS id_1, t0.tokens AS tokens_2, t0.updated_at AS updated_at_3 FROM app_theme_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\BlogPost 5
App\Entity\BlogCategory 4
App\Entity\AppThemeSettings 1

Entities Mapping

Class Mapping errors
App\Entity\BlogPost No errors.
App\Entity\BlogCategory No errors.
App\Entity\PaidBanner No errors.
App\Entity\EmailTemplateSettings No errors.
App\Entity\AppThemeSettings No errors.