https://racket-trip.eu/fr/blog/latest-news

Query Metrics

9 Database Queries
6 Different statements
3.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.84 ms
(22.28%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 INNER JOIN category_article ON t0.id = category_article.category_id WHERE category_article.article_id = ?
Parameters:
[
  280
]
0.67 ms
(17.62%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.original AS original_4, t0.unit AS unit_5, t0.image AS image_6, t0.website_language_id AS website_language_id_7 FROM category t0 WHERE t0.unit = ? AND t0.website_language_id = ? LIMIT 1
Parameters:
[
  4
  1
]
0.59 ms
(15.63%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = ? AND w1_.slug = ?
Parameters:
[
  1
  "fr"
]
0.59 ms
(15.63%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM website_language t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "fr"
]
0.59 ms
(15.53%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_date AS created_date_3, a0_.slug AS slug_4, a0_.cover AS cover_5, a0_.views AS views_6, a0_.published AS published_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.featured_at AS featured_at_10, a0_.original AS original_11, a0_.unit AS unit_12, a0_.alt_cover AS alt_cover_13, a0_.title_seo AS title_seo_14, a0_.description_seo AS description_seo_15, a0_.published_at AS published_at_16, a0_.author_id AS author_id_17, a0_.reviewer_id AS reviewer_id_18, a0_.website_language_id AS website_language_id_19 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = ? AND w1_.slug = ? AND a0_.id IN (?, ?) ORDER BY a0_.created_date DESC
Parameters:
[
  1
  "fr"
  280
  269
]
0.50 ms
(13.30%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.created_date AS created_date_1 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = ? AND w1_.slug = ? ORDER BY a0_.created_date DESC LIMIT 16
Parameters:
[
  1
  "fr"
]

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 No errors.
App\Entity\WebsiteLanguage No errors.
App\Entity\User No errors.
App\Entity\Admin No errors.
App\Entity\Category No errors.
App\Entity\Comment No errors.
App\Entity\Tutorial No errors.
App\Entity\WebsiteInfo No errors.
App\Entity\Faq No errors.
App\Entity\HomeSlider No errors.
App\Entity\Media No errors.
App\Entity\LegalInfo No errors.