Query Metrics

11 Database Queries
8 Different statements
6.79 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.30 ms
SELECT b0_.id AS id_0, b0_.post_id AS post_id_1, b0_.date AS date_2, b0_.modified_date AS modified_date_3, b0_.title AS title_4, b0_.content AS content_5, b0_.text AS text_6, b0_.tag_id AS tag_id_7, b0_.tag_name AS tag_name_8, b0_.media_id AS media_id_9, b0_.media_source_url AS media_source_url_10, b0_.link AS link_11 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b0_.tag_id IS NOT NULL AND b1_.id = ? AND b0_.tag_id = ? ORDER BY b0_.date DESC LIMIT 16
Parameters:
[
  9
  "67"
]
2 0.62 ms
SELECT count(b0_.id) AS sclr_0 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b1_.id = ? AND b0_.tag_id = ?
Parameters:
[
  9
  "67"
]
3 0.26 ms
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.name AS name_3, t0.description AS description_4, t0.count AS count_5 FROM blog_category t0 WHERE t0.id = ?
Parameters:
[
  9
]
4 0.36 ms
SELECT b0_.id AS id_0, b0_.category_id AS category_id_1, b0_.name AS name_2, b0_.description AS description_3, b0_.count AS count_4 FROM blog_category b0_ WHERE b0_.category_id <> ? ORDER BY b0_.name ASC
Parameters:
[
  1
]
5 0.81 ms
SELECT DISTINCT b0_.tag_id AS tag_id_0 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b0_.tag_id IS NOT NULL AND b1_.id = ?
Parameters:
[
  9
]
6 0.65 ms
SELECT b0_.id AS id_0, b0_.tag_id AS tag_id_1, b0_.count AS count_2, b0_.name AS name_3, b0_.description AS description_4 FROM blog_tag b0_ WHERE b0_.tag_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND b0_.id NOT IN (?)
Parameters:
[
  57
  61
  62
  54
  48
  65
  58
  60
  49
  56
  59
  53
  50
  69
  67
  55
  14
]
7 0.68 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_brand_journal_list"
]
8 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_brand_journal_list"
]
9 0.59 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
10 0.52 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
11 0.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_brand_journal_list"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
internal doctrine.dbal.internal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
internal doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\BlogPost No errors.
App\Entity\BlogCategory No errors.
App\Entity\NewsletterSubscription No errors.
App\Entity\BlogTag No errors.
App\Entity\CmsPage No errors.
App\Entity\DataCount No errors.

internal entity manager

No loaded entities.