https://staging.amsel-suite.com/cookies?selected_locale=en

Query Metrics

10 Database Queries
8 Different statements
2.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.68 ms
(29.23%)
2
SELECT t0.id AS id_1, t0.session AS session_2, t0.recipient AS recipient_3, t0.currency AS currency_4, t0.ordered AS ordered_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM ecommerce_cart t0 WHERE t0.session = ? AND t0.ordered = ? LIMIT 1
Parameters:
[
  "lgb06ql0b8q0d66i5d9oj8s6kb"
  0
]
0.54 ms
(23.06%)
2
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:
[
  "cookies"
]
0.25 ms
(10.50%)
1
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_euros AS price_euros_5, t0.promotion_price_euros AS promotion_price_euros_6, t0.price_dollars AS price_dollars_7, t0.promotion_price_dollars AS promotion_price_dollars_8, t0.price_pounds AS price_pounds_9, t0.promotion_price_pounds AS promotion_price_pounds_10, t0.promotion_start_date AS promotion_start_date_11, t0.promotion_end_date AS promotion_end_date_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category_id AS category_id_16 FROM catalog_product t0 WHERE t0.id = ?
Parameters:
[
  10
]
0.20 ms
(8.62%)
1
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_product_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
0.19 ms
(8.02%)
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:
[
  3
]
0.18 ms
(7.56%)
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:
[
  3
]
0.17 ms
(7.21%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.reference AS reference_3, t0.price_euros AS price_euros_4, t0.promotion_price_euros AS promotion_price_euros_5, t0.price_dollars AS price_dollars_6, t0.promotion_price_dollars AS promotion_price_dollars_7, t0.price_pounds AS price_pounds_8, t0.promotion_price_pounds AS promotion_price_pounds_9, t0.promotion_start_date AS promotion_start_date_10, t0.promotion_end_date AS promotion_end_date_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.product_id AS product_id_14, t0.cart_id AS cart_id_15 FROM ecommerce_cart_product t0 WHERE t0.cart_id = ?
Parameters:
[
  336
]
0.14 ms
(5.80%)
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:
[
  3
]

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\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\CartProduct No errors.
App\Entity\Product No errors.
App\Entity\CartProductTranslation No errors.
App\Entity\Category No errors.
App\Entity\Picture No errors.
App\Entity\ProductTranslation No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\PictureTranslation No errors.