https://staging.amsel-suite.com/fr/shop/?selected_locale=fr

Query Metrics

13 Database Queries
7 Different statements
3.23 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.display_on_shop AS display_on_shop_2, t0.sort AS sort_3, t0.reference AS reference_4, t0.price AS price_5, t0.promotion_price AS promotion_price_6, t0.promotion_start_date AS promotion_start_date_7, t0.promotion_end_date AS promotion_end_date_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12 FROM catalog_product t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.44 ms
SELECT t0.id AS id_1, t0.display_on_shop AS display_on_shop_2, t0.sort AS sort_3, t0.reference AS reference_4, t0.price AS price_5, t0.promotion_price AS promotion_price_6, t0.promotion_start_date AS promotion_start_date_7, t0.promotion_end_date AS promotion_end_date_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12 FROM catalog_product t0 WHERE t0.id = ?
Parameters:
[
  10
]
3 0.26 ms
SELECT t0.id AS id_1, t0.display_on_shop AS display_on_shop_2, t0.sort AS sort_3, t0.reference AS reference_4, t0.price AS price_5, t0.promotion_price AS promotion_price_6, t0.promotion_start_date AS promotion_start_date_7, t0.promotion_end_date AS promotion_end_date_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12 FROM catalog_product t0 WHERE t0.id = ?
Parameters:
[
  11
]
4 0.27 ms
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 FROM catalog_category t0 WHERE t0.deletedAt IS NULL ORDER BY t0.sort ASC
Parameters:
[]
5 0.30 ms
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:
[
  "shop"
]
6 0.14 ms
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:
[
  "homepage"
]
7 0.22 ms
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:
[
  1
]
8 0.21 ms
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:
[
  1
]
9 0.16 ms
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:
[
  1
]
10 0.25 ms
SELECT t0.id AS id_1, t0.session AS session_2, t0.recipient AS recipient_3, t0.ordered AS ordered_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7 FROM ecommerce_cart t0 WHERE t0.session = ? AND t0.ordered = ? LIMIT 1
Parameters:
[
  "3caihgi9vb7ns4t0hj7tk4ijlo"
  0
]
11 0.21 ms
SELECT t0.id AS id_1, t0.session AS session_2, t0.recipient AS recipient_3, t0.ordered AS ordered_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7 FROM ecommerce_cart t0 WHERE t0.session = ? AND t0.ordered = ? LIMIT 1
Parameters:
[
  "3caihgi9vb7ns4t0hj7tk4ijlo"
  0
]
12 0.15 ms
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:
[
  "shop"
]
13 0.12 ms
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:
[
  "homepage"
]

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\Product No errors.
App\Entity\Category No errors.
App\Entity\Picture No errors.
App\Entity\ProductTranslation No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\SeoRoute No errors.
App\Entity\SeoRouteMeta No errors.
App\Entity\SeoRouteTranslation No errors.
App\Entity\SeoRouteMetaTranslation No errors.
App\Entity\Cart No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\PictureTranslation No errors.
App\Entity\CartProduct No errors.