https://www.dmdinox.asb-digital.fr/fr/application/nucleaire-recherche

Query Metrics

406 Database Queries
18 Different statements
121.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
43.91 ms
(36.04%)
146
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 = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
25.69 ms
(21.09%)
90
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM sub_sub_sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
20.32 ms
(16.68%)
73
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:
[
  3
]
12.38 ms
(10.16%)
39
SELECT t0.id AS id_1, t0.sub_sub_category_icon_file_name AS sub_sub_category_icon_file_name_2, t0.sub_sub_category_bg_file_name AS sub_sub_category_bg_file_name_3, t0.sub_sub_category_bg_file_size AS sub_sub_category_bg_file_size_4, t0.sub_sub_category_bg_file_updated_at AS sub_sub_category_bg_file_updated_at_5, t0.sub_sub_category_icon_file_size AS sub_sub_category_icon_file_size_6, t0.sub_sub_category_icon_file_updated_at AS sub_sub_category_icon_file_updated_at_7, t0.sub_sub_category_file_name AS sub_sub_category_file_name_8, t0.sub_sub_category_file_size AS sub_sub_category_file_size_9, t0.sub_sub_category_file_updated_at AS sub_sub_category_file_updated_at_10, t0.position AS position_11, t0.sub_category_id AS sub_category_id_12 FROM sub_sub_category t0 WHERE t0.sub_category_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
3.82 ms
(3.14%)
12
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.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
3.72 ms
(3.05%)
13
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:
[
  6
]
3.07 ms
(2.52%)
10
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 ORDER BY t0.position ASC
Parameters:
[]
1.97 ms
(1.62%)
7
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM application_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
1.33 ms
(1.09%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM application_paragraph_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
0.99 ms
(0.82%)
3
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.95 ms
(0.78%)
2
SELECT t0.id AS id_1, t0.controller AS controller_2, t0.sitemap_file_name AS sitemap_file_name_3, t0.sitemap_file_size AS sitemap_file_size_4, t0.sitemap_file_updated_at AS sitemap_file_updated_at_5, t0.meta_color AS meta_color_6, t0.google_analytic AS google_analytic_7, t0.google_search_console AS google_search_console_8, t0.header_img_file_name AS header_img_file_name_9, t0.header_img_file_size AS header_img_file_size_10, t0.header_img_file_updated_at AS header_img_file_updated_at_11 FROM page t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\FrontController::application"
]
0.79 ms
(0.65%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.application_paragraph_file_name AS application_paragraph_file_name_3, t0.application_paragraph_file_size AS application_paragraph_file_size_4, t0.application_paragraph_file_updated_at AS application_paragraph_file_updated_at_5, t0.is_fade AS is_fade_6, t0.pdf_name AS pdf_name_7, t0.pdf_size AS pdf_size_8, t0.pdf_updated_at AS pdf_updated_at_9, t0.cta_link AS cta_link_10, t0.cta_text AS cta_text_11, t0.application_id AS application_id_12 FROM application_paragraph t0 WHERE t0.application_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
0.77 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM application_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "nucleaire-recherche"
]
0.61 ms
(0.50%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.application_id AS application_id_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5, t0.sub_category_id AS sub_category_id_6, t0.sub_sub_category_id AS sub_sub_category_id_7 FROM application_product t0 WHERE t0.application_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
0.56 ms
(0.46%)
2
SELECT t0.id AS id_1, t0.titre_h1 AS titre_h1_2, t0.position AS position_3, t0.display_on_landing AS display_on_landing_4, t0.application_file_name AS application_file_name_5, t0.application_file_size AS application_file_size_6, t0.application_file_updated_at AS application_file_updated_at_7 FROM application t0 ORDER BY t0.position ASC
Parameters:
[]
0.36 ms
(0.29%)
1
SELECT p0_.id AS id_0, p0_.controller AS controller_1, p0_.sitemap_file_name AS sitemap_file_name_2, p0_.sitemap_file_size AS sitemap_file_size_3, p0_.sitemap_file_updated_at AS sitemap_file_updated_at_4, p0_.meta_color AS meta_color_5, p0_.google_analytic AS google_analytic_6, p0_.google_search_console AS google_search_console_7, p0_.header_img_file_name AS header_img_file_name_8, p0_.header_img_file_size AS header_img_file_size_9, p0_.header_img_file_updated_at AS header_img_file_updated_at_10 FROM page p0_ WHERE p0_.id IS NOT NULL AND p0_.meta_color IS NOT NULL LIMIT 1
Parameters:
[]
0.31 ms
(0.25%)
1
SELECT t0.id AS id_1, t0.titre_h1 AS titre_h1_2, t0.position AS position_3, t0.display_on_landing AS display_on_landing_4, t0.application_file_name AS application_file_name_5, t0.application_file_size AS application_file_size_6, t0.application_file_updated_at AS application_file_updated_at_7 FROM application t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.30 ms
(0.25%)
1
SELECT p0_.id AS id_0, p0_.controller AS controller_1, p0_.sitemap_file_name AS sitemap_file_name_2, p0_.sitemap_file_size AS sitemap_file_size_3, p0_.sitemap_file_updated_at AS sitemap_file_updated_at_4, p0_.meta_color AS meta_color_5, p0_.google_analytic AS google_analytic_6, p0_.google_search_console AS google_search_console_7, p0_.header_img_file_name AS header_img_file_name_8, p0_.header_img_file_size AS header_img_file_size_9, p0_.header_img_file_updated_at AS header_img_file_updated_at_10 FROM page p0_ WHERE p0_.id IS NOT NULL AND p0_.google_search_console IS NOT NULL LIMIT 1
Parameters:
[]

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\ApplicationTranslation No errors.
App\Entity\Application No errors.
App\Entity\ApplicationParagraph No errors.
App\Entity\ApplicationParagraphTranslation No errors.
App\Entity\ApplicationProduct No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\SubCategory No errors.
App\Entity\SubSubCategory No errors.
App\Entity\Page No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\SubCategoryTranslation No errors.
App\Entity\SubSubSubCategory No errors.
App\Entity\SubSubCategoryTranslation No errors.
App\Entity\SubSubSubCategoryTranslation No errors.