Query Metrics
6
Database Queries
6
Different statements
1.38 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.39 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:
[ "temperatursturz-allgaeu-heute-fakten" 1 ]
|
||||||||||||||||||||||||||||||||
| 2 | 0.23 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.19 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_.category_id = ? AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 4
Parameters:
[ 1 1 158 ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.24 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 158 ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.22 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
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.11 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\AppThemeSettings | No errors. |