Query Metrics
26
Database Queries
14
Different statements
9.77 ms
Query time
0
Invalid entities
Grouped Statements
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. |
App\Entity\ArticleTranslation | No errors. |
App\Entity\PageTranslation | No errors. |
App\Entity\PartnerTranslation | No errors. |
App\Entity\ProductAttribute | No errors. |
App\Entity\ProductTranslation | No errors. |
App\Entity\PictureTranslation | No errors. |