Query Metrics

26 Database Queries
14 Different statements
9.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.64 ms
(26.98%)
1
SELECT t0.id AS id_1, t0.category_rea AS category_rea_2, t0.sort AS sort_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7 FROM app_activite t0
Parameters:
[]
2.27 ms
(23.19%)
1
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.sort AS sort_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM article_article t0
Parameters:
[]
1.03 ms
(10.60%)
1
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM article_partner t0
Parameters:
[]
0.90 ms
(9.17%)
1
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.reference AS reference_3, t0.is_new AS is_new_4, t0.new_start_date AS new_start_date_5, t0.new_end_date AS new_end_date_6, t0.weight AS weight_7, t0.total_weight AS total_weight_8, t0.price AS price_9, t0.promotion_price AS promotion_price_10, t0.stock_handler AS stock_handler_11, t0.stock AS stock_12, t0.promotion_start_date AS promotion_start_date_13, t0.promotion_end_date AS promotion_end_date_14, t0.deleted_at AS deleted_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM catalog_product t0
Parameters:
[]
0.58 ms
(5.96%)
8
SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_h1 AS seo_h1_3, t0.title AS title_4, t0.short_content AS short_content_5, t0.content AS content_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM catalog_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.46 ms
(4.70%)
6
SELECT t0.id AS id_1, t0.deletedAt AS deletedAt_2, t0.sort AS sort_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM catalog_category t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]
0.39 ms
(4.04%)
1
SELECT t0.id AS id_1, t0.route AS route_2, t0.structured_data AS structured_data_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM seo_seo_route t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "sitemap"
]
0.29 ms
(2.95%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.h1 AS h1_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM seo_seo_route_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
0.29 ms
(2.94%)
1
SELECT t0.id AS id_1, t0.deletedAt AS deletedAt_2, t0.sort AS sort_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM catalog_category t0
Parameters:
[]
0.28 ms
(2.85%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM seo_seo_route_meta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
0.27 ms
(2.78%)
1
SELECT t0.id AS id_1, t0.serialized_content AS serialized_content_2, t0.sort AS sort_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page_page t0
Parameters:
[]
0.20 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM seo_seo_route_meta t0 INNER JOIN seo_seo_route_seo_route_meta ON t0.id = seo_seo_route_seo_route_meta.seo_route_meta_id WHERE seo_seo_route_seo_route_meta.seo_route_id = ?
Parameters:
[
  8
]
0.11 ms
(1.13%)
1
SELECT t0.id AS id_1, t0.deletedAt AS deletedAt_2, t0.sort AS sort_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM catalog_category t0 WHERE t0.parent_id IS NULL AND t0.deletedAt IS NULL ORDER BY t0.sort ASC
Parameters:
[]
0.06 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.serialized_content AS serialized_content_2, t0.sort AS sort_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page_page t0 WHERE t0.deleted_at IS NULL ORDER BY t0.sort ASC
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\Article No errors.
App\Entity\Page No errors.
App\Entity\Partner No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Activite No errors.
App\Entity\CategoryParagraphe No errors.
App\Entity\Picture No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\ActiviteTranslation No errors.
App\Entity\SeoRoute No errors.
App\Entity\SeoRouteMeta No errors.
App\Entity\SeoRouteTranslation No errors.
App\Entity\SeoRouteMetaTranslation No errors.