JSON https://zamowienia.dhapps.co.pl/product/7501/set-favorite

Query Metrics

7 Database Queries
7 Different statements
21.43 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  63
]
2 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "7501"
]
3 0.44 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 INNER JOIN user_product ON t0.id = user_product.user_id WHERE user_product.product_id = ?
Parameters:
[
  7501
]
4 7.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 INNER JOIN user_product ON t0.id = user_product.product_id WHERE user_product.user_id = ?
Parameters:
[
  63
]
5 0.14 ms
"START TRANSACTION"
Parameters:
[]
6 0.53 ms
INSERT INTO user_product (user_id, product_id) VALUES (?, ?)
Parameters:
[
  63
  7501
]
7 11.37 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.