http://www.facomia.asb-digital.fr/fr/presentation

Query Metrics

118 Database Queries
15 Different statements
75.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.36 ms
(52.02%)
64
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM history_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
13.95 ms
(18.44%)
28
SELECT t0.id AS id_1, t0.position AS position_2, t0.sub_category_file_name AS sub_category_file_name_3, t0.sub_category_file_size AS sub_category_file_size_4, t0.sub_category_file_updated_at AS sub_category_file_updated_at_5, t0.sub_category_bg_file_name AS sub_category_bg_file_name_6, t0.sub_category_bg_file_size AS sub_category_bg_file_size_7, t0.sub_category_bg_file_updated_at AS sub_category_bg_file_updated_at_8, t0.category_id AS category_id_9 FROM sub_category t0 WHERE t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
7.53 ms
(9.95%)
2
SELECT t0.id AS id_1, t0.position AS position_2, t0.presentation_paragraph_file_name AS presentation_paragraph_file_name_3, t0.presentation_paragraph_file_size AS presentation_paragraph_file_size_4, t0.presentation_paragraph_file_updated_at AS presentation_paragraph_file_updated_at_5, t0.is_fade AS is_fade_6, t0.is_other AS is_other_7, t0.presentation_paragraph_icon_file_name AS presentation_paragraph_icon_file_name_8, t0.presentation_paragraph_icon_file_size AS presentation_paragraph_icon_file_size_9, t0.presentation_paragraph_icon_file_updated_at AS presentation_paragraph_icon_file_updated_at_10 FROM presentation_paragraph t0 WHERE t0.is_other = ? ORDER BY t0.position ASC
Parameters:
[
  0
]
2.43 ms
(3.21%)
3
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.is_chaine AS is_chaine_6, t0.category_bg_file_name AS category_bg_file_name_7, t0.category_bg_file_size AS category_bg_file_size_8, t0.category_bg_file_updated_at AS category_bg_file_updated_at_9 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
1.99 ms
(2.63%)
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.intro AS intro_7, t0.listing_title AS listing_title_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM sub_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
1.61 ms
(2.12%)
3
SELECT t0.id AS id_1, t0.subtitle AS subtitle_2, t0.title AS title_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM presentation_paragraph_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
1.55 ms
(2.05%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.intro AS intro_7, t0.listing_intro AS listing_intro_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
1.55 ms
(2.05%)
3
SELECT t0.id AS id_1, t0.history_category_file_name AS history_category_file_name_2, t0.history_category_file_size AS history_category_file_size_3, t0.history_category_file_updated_at AS history_category_file_updated_at_4 FROM history_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.33 ms
(1.76%)
2
SELECT t0.id AS id_1, t0.year AS year_2, t0.history_file_name AS history_file_name_3, t0.history_file_size AS history_file_size_4, t0.history_file_updated_at AS history_file_updated_at_5, t0.is_highlight AS is_highlight_6, t0.history_category_id AS history_category_id_7 FROM history t0 ORDER BY t0.year DESC
Parameters:
[]
1.06 ms
(1.40%)
1
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 FROM page t0 WHERE t0.controller = ? LIMIT 1
Parameters:
[
  "App\Controller\FrontController::presentation"
]
0.91 ms
(1.20%)
2
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 FROM page p0_ WHERE p0_.id IS NOT NULL AND p0_.meta_color IS NOT NULL LIMIT 1
Parameters:
[]
0.81 ms
(1.07%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.category_file_name AS category_file_name_3, t0.category_file_size AS category_file_size_4, t0.category_file_updated_at AS category_file_updated_at_5, t0.is_chaine AS is_chaine_6, t0.category_bg_file_name AS category_bg_file_name_7, t0.category_bg_file_size AS category_bg_file_size_8, t0.category_bg_file_updated_at AS category_bg_file_updated_at_9 FROM category t0 WHERE t0.is_chaine = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.76 ms
(1.01%)
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.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.49 ms
(0.65%)
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 FROM page p0_ WHERE p0_.id IS NOT NULL AND p0_.google_analytic IS NOT NULL LIMIT 1
Parameters:
[]
0.32 ms
(0.42%)
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 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\PresentationParagraph No errors.
App\Entity\PresentationParagraphTranslation No errors.
App\Entity\Page No errors.
App\Entity\PageTranslation No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\SubCategory No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\SubCategoryTranslation No errors.
App\Entity\History No errors.
App\Entity\HistoryCategory No errors.
App\Entity\HistoryTranslation No errors.
App\Entity\HistoryCategoryTranslation No errors.