GET https://preprod.spira-clim.fr/blog?page=2

Query Metrics

14 Database Queries
10 Different statements
51.84 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 15.78 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ WHERE b0_.is_enabled = 1
Parameters:
[]
2 0.77 ms
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog b0_ WHERE b0_.is_enabled = 1 ORDER BY b0_.created_at DESC LIMIT 2 OFFSET 2
Parameters:
[]
3 0.85 ms
SELECT b0_.seo_title AS seo_title_0, b0_.seo_description AS seo_description_1, b0_.title AS title_2, b0_.id AS id_3, b0_.slug AS slug_4, b0_.is_enabled AS is_enabled_5, b0_.created_at AS created_at_6, b0_.content AS content_7, b0_.image AS image_8, b0_.image_alt AS image_alt_9, b0_.author_id AS author_id_10, b0_.category_id AS category_id_11 FROM blog b0_ WHERE b0_.is_enabled = 1 AND b0_.id IN (?) ORDER BY b0_.created_at DESC
Parameters:
[
  1
]
4 9.34 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.hero_image AS hero_image_5, t0.hero_image_alt AS hero_image_alt_6, t0.intro AS intro_7 FROM blog_page t0 LIMIT 1
Parameters:
[]
5 0.64 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.hero_image AS hero_image_5, t0.hero_image_alt AS hero_image_alt_6, t0.intro AS intro_7 FROM blog_page t0 LIMIT 1
Parameters:
[]
6 3.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM blog_category t0
Parameters:
[]
7 2.61 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC
Parameters:
[]
8 0.67 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
9 0.66 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  12
]
10 0.66 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  13
]
11 0.68 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  14
]
12 2.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.mail AS mail_5, t0.logo AS logo_6, t0.linkedin_icon AS linkedin_icon_7, t0.linkedin_link AS linkedin_link_8, t0.facebook_icon AS facebook_icon_9, t0.facebook_link AS facebook_link_10, t0.urlsite AS urlsite_11 FROM settings t0 LIMIT 1
Parameters:
[]
13 1.10 ms
SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.title AS title_3, t0.id AS id_4, t0.presentation AS presentation_5, t0.slug AS slug_6, t0.image AS image_7, t0.position AS position_8, t0.title_color AS title_color_9, t0.parent_id AS parent_id_10 FROM produit_category t0
Parameters:
[]
14 12.32 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.image AS image_7, t0.is_verified AS is_verified_8, t0.adresse AS adresse_9, t0.codepostal AS codepostal_10, t0.ville AS ville_11, t0.telephone AS telephone_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.lastlogin AS lastlogin_15, t16.id AS id_17, t16.client_id AS client_id_18 FROM `user` t0 LEFT JOIN panier t16 ON t16.client_id = t0.id 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.

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\Blog No errors.
App\Entity\User No errors.
App\Entity\BlogCategory No errors.
App\Entity\BlogPage No errors.
App\Entity\ProduitCategory No errors.
App\Entity\Produit No errors.
App\Entity\Settings No errors.
App\Entity\Panier No errors.
App\Entity\PanierProduit No errors.