GET https://checkout.unkonventionell.at/shop/shoppingcart/remove/9

Query Metrics

13 Database Queries
7 Different statements
5.79 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
2 0.25 ms
SELECT p0_.id AS id_0, s1_.quantity AS quantity_1, p0_.name AS name_2, p0_.price AS price_3, p0_.price * s1_.quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_.product_id = p0_.id WHERE s1_.shoppingcart_id = ?
Parameters:
[
  2
]
3 0.12 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
4 0.08 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
5 0.08 ms
SELECT p0_.id AS id_0, s1_.quantity AS quantity_1, p0_.name AS name_2, p0_.price AS price_3, p0_.price * s1_.quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_.product_id = p0_.id WHERE s1_.shoppingcart_id = ?
Parameters:
[
  2
]
6 0.21 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
7 0.10 ms
SELECT p0_.id AS id_0, s1_.quantity AS quantity_1, p0_.name AS name_2, p0_.price AS price_3, p0_.price * s1_.quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_.product_id = p0_.id WHERE s1_.shoppingcart_id = ?
Parameters:
[
  2
]
8 0.07 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.session_id AS session_id_3, t0.user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
9 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.price AS price_4, t0.description AS description_5 FROM product t0 WHERE t0.id = ?
Parameters:
[
  9
]
10 0.16 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.shoppingcart_id AS shoppingcart_id_3, t0.product_id AS product_id_4 FROM shopping_cart_product t0 WHERE t0.shoppingcart_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  2
  9
]
11 0.07 ms
"START TRANSACTION"
Parameters:
[]
12 0.22 ms
DELETE FROM shopping_cart_product WHERE id = ?
Parameters:
[
  133
]
13 3.85 ms
"COMMIT"
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\ShoppingCart No errors.
App\Entity\User No errors.
App\Entity\ShoppingCartProduct
  • The association App\Entity\ShoppingCartProduct#shoppingcart refers to the inverse side field App\Entity\ShoppingCart#shoppingCartProducts which does not exist.
App\Entity\Product No errors.
App\Entity\OrderProduct No errors.