https://staging.amsel-suite.com/shop/cart/add/11

Query Metrics

8 Database Queries
7 Different statements
5.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.68 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_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:
[
  "11"
]
2 1.36 ms
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:
[
  "edkldeu9nsm1ogaqbjee8eefc9"
  0
]
3 0.10 ms
"START TRANSACTION"
Parameters:
[]
4 0.39 ms
INSERT INTO ecommerce_cart (SESSION, recipient, currency, ordered, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "edkldeu9nsm1ogaqbjee8eefc9"
  2 => null
  3 => "dollars"
  4 => 0
  5 => "2025-12-06 12:44:46"
  6 => "2025-12-06 12:44:46"
  7 => null
]
5 0.97 ms
INSERT INTO ecommerce_cart_product (quantity, reference, price_euros, promotion_price_euros, price_dollars, promotion_price_dollars, price_pounds, promotion_price_pounds, promotion_start_date, promotion_end_date, created_at, updated_at, product_id, cart_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => 1
  2 => "TOME-STANDARD"
  3 => 34.99
  4 => 29.99
  5 => 40.99
  6 => 40.99
  7 => 30.99
  8 => 30.99
  9 => "2025-05-01 00:00:00"
  10 => "2025-06-30 23:59:00"
  11 => "2025-12-06 12:44:46"
  12 => "2025-12-06 12:44:46"
  13 => 11
  14 => 342
]
6 0.65 ms
"COMMIT"
Parameters:
[]
7 0.33 ms
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:
[
  "edkldeu9nsm1ogaqbjee8eefc9"
  0
]
8 0.91 ms
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:
[
  11
]

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\Cart No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\CartProduct No errors.