Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.post_id AS post_id_2, t0.date AS date_3, t0.modified_date AS modified_date_4, t0.title AS title_5, t0.content AS content_6, t0.text AS text_7, t0.tag_id AS tag_id_8, t0.tag_name AS tag_name_9, t0.media_id AS media_id_10, t0.media_source_url AS media_source_url_11, t0.link AS link_12 FROM blog_post t0 WHERE t0.id = ?
Parameters:
[
  "297"
]
2 0.50 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
]
3 5.94 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_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 16
Parameters:
[]
4 0.34 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 INNER JOIN blog_post_blog_category ON t0.id = blog_post_blog_category.blog_category_id WHERE blog_post_blog_category.blog_post_id = ?
Parameters:
[
  297
]
5 1.68 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 = ? ORDER BY b0_.date DESC LIMIT 16
Parameters:
[
  9
]
6 3.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Peugeot"
]
7 7.51 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_detail"
]
8 0.57 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_detail"
]
9 10.41 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.42 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 10.52 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_detail"
]

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\CarMarque No errors.
App\Entity\Etablissement No errors.
App\Entity\CarModele No errors.
App\Entity\MarqueNews No errors.
App\Entity\CmsPage No errors.
App\Entity\DataCount No errors.

internal entity manager

No loaded entities.