Redirect 302 redirect from GET @app_shop_shoppingcart_decrease (93435d)

GET https://checkout.unkonventionell.at/shop

Query Metrics

12 Database Queries
6 Different statements
7.14 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 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:
[
  "btjl3nuko25peu0m0mqf3ucg44"
]
2 0.07 ms
"START TRANSACTION"
Parameters:
[]
3 0.21 ms
INSERT INTO shopping_cart (state, session_id, user_id_id) VALUES (?, ?, ?)
Parameters:
[
  "shopping"
  "btjl3nuko25peu0m0mqf3ucg44"
  null
]
4 5.29 ms
"COMMIT"
Parameters:
[]
5 0.19 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:
[
  200
]
6 0.11 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:
[
  "btjl3nuko25peu0m0mqf3ucg44"
]
7 0.11 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:
[
  "btjl3nuko25peu0m0mqf3ucg44"
]
8 0.09 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:
[
  200
]
9 0.13 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:
[
  "btjl3nuko25peu0m0mqf3ucg44"
]
10 0.09 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:
[
  200
]
11 0.14 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:
[
  "btjl3nuko25peu0m0mqf3ucg44"
]
12 0.11 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
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.