GET https://preprod.spira-clim.fr/categories/flexibles

Query Metrics

11 Database Queries
7 Different statements
17.76 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.14 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.slug = ? LIMIT 1
Parameters:
[
  "flexibles"
]
2 2.69 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 FROM category_page t0 LIMIT 1
Parameters:
[]
3 1.01 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:
[
  30
]
4 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 IS NULL ORDER BY t0.position ASC
Parameters:
[]
5 0.65 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
]
6 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
]
7 0.71 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
]
8 0.63 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
]
9 2.57 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:
[]
10 0.92 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:
[]
11 3.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.slug AS slug_5, t0.hero_image AS hero_image_6, t0.images AS images_7, t0.presentation AS presentation_8, t0.details AS details_9, t0.is_enabled AS is_enabled_10, t0.fields AS fields_11, t0.position AS position_12, t0.title_color AS title_color_13, t0.category_id AS category_id_14 FROM produit t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  30
]

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\ProduitCategory No errors.
App\Entity\Produit No errors.
App\Entity\CategoryPage No errors.
App\Entity\Settings No errors.