http://www.facomia.asb-digital.fr/en/news/facomia-vous-presente-sa-toute-derniere-innovation

Query Metrics

48 Database Queries
15 Different statements
72.97 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
24.55 ms
(33.64%)
27
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
]
5.88 ms
(8.05%)
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:
[]
5.13 ms
(7.03%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.legend AS legend_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM paragraph_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
4.86 ms
(6.66%)
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
]
4.74 ms
(6.50%)
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
]
4.68 ms
(6.42%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.post_file_name AS post_file_name_3, t0.post_file_size AS post_file_size_4, t0.post_file_updated_at AS post_file_updated_at_5, t0.is_published AS is_published_6, t0.post_pdf_file_name AS post_pdf_file_name_7, t0.post_pdf_file_size AS post_pdf_file_size_8, t0.post_pdf_file_updated_at AS post_pdf_file_updated_at_9, t0.post_category_id AS post_category_id_10 FROM post t0 WHERE t0.id = ?
Parameters:
[
  3
]
4.44 ms
(6.08%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.intro_raw AS intro_raw_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.pdf_name AS pdf_name_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM post_translation t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "facomia-vous-presente-sa-toute-derniere-innovation"
]
3.89 ms
(5.34%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.youtube AS youtube_3, t0.post_media_file_name AS post_media_file_name_4, t0.post_media_file_size AS post_media_file_size_5, t0.post_media_file_updated_at AS post_media_file_updated_at_6, t0.post_id AS post_id_7 FROM post_media t0 WHERE t0.post_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
3.61 ms
(4.95%)
1
SELECT t0.id AS id_1, t0.paragraph_file_name AS paragraph_file_name_2, t0.paragraph_file_size AS paragraph_file_size_3, t0.paragraph_file_updated_at AS paragraph_file_updated_at_4, t0.position AS position_5, t0.color AS color_6, t0.youtube AS youtube_7, t0.post_id AS post_id_8 FROM paragraph t0 WHERE t0.post_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
2.90 ms
(3.98%)
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::post"
]
2.67 ms
(3.66%)
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:
[]
2.44 ms
(3.34%)
1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.post_file_name AS post_file_name_2, p0_.post_file_size AS post_file_size_3, p0_.post_file_updated_at AS post_file_updated_at_4, p0_.is_published AS is_published_5, p0_.post_pdf_file_name AS post_pdf_file_name_6, p0_.post_pdf_file_size AS post_pdf_file_size_7, p0_.post_pdf_file_updated_at AS post_pdf_file_updated_at_8, p0_.post_category_id AS post_category_id_9 FROM post p0_ LEFT JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.id IS NOT NULL AND p0_.is_published = ? AND p0_.id <> ? AND p0_.date <= ? GROUP BY p0_.id ORDER BY p0_.date DESC LIMIT 2
Parameters:
[
  1
  3
  "2024-12-21 16:45:20"
]
1.36 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.intro_raw AS intro_raw_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.pdf_name AS pdf_name_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
0.96 ms
(1.32%)
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.84 ms
(1.16%)
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\PostTranslation No errors.
App\Entity\Post No errors.
App\Entity\PostCategory No errors.
App\Entity\Paragraph No errors.
App\Entity\PostMedia No errors.
App\Entity\ParagraphTranslation 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.