https://www.dmdinox.asb-digital.fr/fr/categorie/raccords/raccord-pour-gaz-purs/reductions-a-soudure-orbitale-pour-gaz-purs

Query Metrics

8 Database Queries
8 Different statements
5.15 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.00 ms
(19.38%)
1
SELECT s0_.id AS id_0, s0_.sub_sub_category_icon_file_name AS sub_sub_category_icon_file_name_1, s0_.sub_sub_category_bg_file_name AS sub_sub_category_bg_file_name_2, s0_.sub_sub_category_bg_file_size AS sub_sub_category_bg_file_size_3, s0_.sub_sub_category_bg_file_updated_at AS sub_sub_category_bg_file_updated_at_4, s0_.sub_sub_category_icon_file_size AS sub_sub_category_icon_file_size_5, s0_.sub_sub_category_icon_file_updated_at AS sub_sub_category_icon_file_updated_at_6, s0_.sub_sub_category_file_name AS sub_sub_category_file_name_7, s0_.sub_sub_category_file_size AS sub_sub_category_file_size_8, s0_.sub_sub_category_file_updated_at AS sub_sub_category_file_updated_at_9, s0_.position AS position_10, s0_.sub_category_id AS sub_category_id_11 FROM sub_sub_category s0_ LEFT JOIN sub_sub_category_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IS NOT NULL AND s1_.slug = ? LIMIT 1
Parameters:
[
  "reductions-a-soudure-orbitale-pour-gaz-purs"
]
0.94 ms
(18.25%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM category_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "raccords"
]
0.69 ms
(13.42%)
1
SELECT t0.id AS id_1, t0.sub_sub_sub_category_icon_file_name AS sub_sub_sub_category_icon_file_name_2, t0.sub_sub_sub_category_icon_file_size AS sub_sub_sub_category_icon_file_size_3, t0.sub_sub_sub_category_bg_file_name AS sub_sub_sub_category_bg_file_name_4, t0.sub_sub_sub_category_bg_file_size AS sub_sub_sub_category_bg_file_size_5, t0.sub_sub_sub_category_bg_file_updated_at AS sub_sub_sub_category_bg_file_updated_at_6, t0.sub_sub_sub_category_icon_file_updated_at AS sub_sub_sub_category_icon_file_updated_at_7, t0.position AS position_8, t0.sub_sub_sub_category_file_name AS sub_sub_sub_category_file_name_9, t0.sub_sub_sub_category_file_size AS sub_sub_sub_category_file_size_10, t0.sub_sub_sub_category_file_updated_at AS sub_sub_sub_category_file_updated_at_11, t0.sub_sub_category_id AS sub_sub_category_id_12 FROM sub_sub_sub_category t0 WHERE t0.sub_sub_category_id = ?
Parameters:
[
  23
]
0.54 ms
(10.55%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
0.52 ms
(10.04%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_bg_file_name AS category_bg_file_name_3, t0.category_bg_file_size AS category_bg_file_size_4, t0.category_bg_file_updated_at AS category_bg_file_updated_at_5, t0.category_file_name AS category_file_name_6, t0.category_file_size AS category_file_size_7, t0.category_file_updated_at AS category_file_updated_at_8, t0.category_icon_file_name AS category_icon_file_name_9, t0.category_icon_file_size AS category_icon_file_size_10, t0.category_icon_file_updated_at AS category_icon_file_updated_at_11, t0.color AS color_12 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.51 ms
(9.88%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM sub_sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  23
]
0.49 ms
(9.46%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
0.46 ms
(9.01%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.sub_category_icon_file_name AS sub_category_icon_file_name_3, t0.sub_category_bg_file_name AS sub_category_bg_file_name_4, t0.sub_category_bg_file_size AS sub_category_bg_file_size_5, t0.sub_category_bg_file_updated_at AS sub_category_bg_file_updated_at_6, t0.sub_category_icon_file_size AS sub_category_icon_file_size_7, t0.sub_category_icon_file_updated_at AS sub_category_icon_file_updated_at_8, t0.sub_category_file_name AS sub_category_file_name_9, t0.sub_category_file_size AS sub_category_file_size_10, t0.sub_category_file_updated_at AS sub_category_file_updated_at_11, t0.category_id AS category_id_12 FROM sub_category t0 WHERE t0.id = ?
Parameters:
[
  10
]

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\CategoryTranslation No errors.
App\Entity\Category No errors.
App\Entity\SubSubCategory No errors.
App\Entity\SubSubCategoryTranslation No errors.
App\Entity\SubCategory No errors.
App\Entity\Product No errors.
App\Entity\SubSubSubCategory No errors.
App\Entity\ApplicationProduct No errors.
App\Entity\SubCategoryTranslation No errors.