POST https://b2c-leobro.url.org.ua/cart/api/remove

Query Metrics

18 Database Queries
11 Different statements
8.21 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  11
]
2 0.41 ms
SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.description AS description_3, p0_.detail_description AS detail_description_4, p0_.deleted AS deleted_5, p0_.pic AS pic_6, p0_.warranty AS warranty_7, p0_.cost_min AS cost_min_8, p0_.create_time AS create_time_9, s1_.product_id AS product_id_10, s1_.group_id AS group_id_11, s1_.product_type AS product_type_12, s1_.is_show_in_catalog AS is_show_in_catalog_13, s1_.presence AS presence_14, s1_.presence_str AS presence_str_15, s1_.rating AS rating_16, p2_.product_id AS product_id_17, p2_.url_code AS url_code_18, p2_.rating AS rating_19, p2_.seo_title AS seo_title_20, p2_.seo_description AS seo_description_21, p2_.seo_keyword AS seo_keyword_22, p3_.id AS id_23, p3_.default AS default_24, p3_.change_data AS change_data_25, p3_.show_img AS show_img_26, p3_.show_price AS show_price_27, p3_.show_presence AS show_presence_28, p3_.features_sharing AS features_sharing_29, p3_.manual_sharing AS manual_sharing_30, p3_.features AS features_31, p0_.category_id AS category_id_32, s1_.category_id AS category_id_33, s1_.catalog_product_id AS catalog_product_id_34, s1_.product_id AS product_id_35, p2_.product_id AS product_id_36, p3_.product_id AS product_id_37 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = ? LIMIT 1
Parameters:
[
  139943
]
3 0.76 ms
SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ? AND t0.product_id = ? AND t0.property = ? LIMIT 1
Parameters:
[
  11
  139943
  ""
]
4 0.17 ms
"START TRANSACTION"
Parameters:
[]
5 1.59 ms
DELETE FROM sf_cart_product WHERE cart_id = ? AND product_id = ? AND property = ?
Parameters:
[
  11
  139943
  ""
]
6 0.29 ms
"COMMIT"
Parameters:
[]
7 0.18 ms
"START TRANSACTION"
Parameters:
[]
8 1.28 ms
UPDATE sf_cart SET date_updated = ? WHERE id = ?
Parameters:
[
  "2026-04-01 12:55:02"
  11
]
9 0.39 ms
"COMMIT"
Parameters:
[]
10 0.55 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.code AS code_3, t0.promo_code AS promo_code_4, t0.checkout_data AS checkout_data_5, t0.date_updated AS date_updated_6 FROM sf_cart t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "badd52fc"
]
11 0.08 ms
"START TRANSACTION"
Parameters:
[]
12 0.27 ms
UPDATE sf_cart SET date_updated = ? WHERE id = ?
Parameters:
[
  "2026-04-01 12:55:02"
  11
]
13 0.13 ms
"COMMIT"
Parameters:
[]
14 0.10 ms
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
Parameters:
[]
15 0.10 ms
SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0
Parameters:
[]
16 0.97 ms
SELECT t0.cart_id AS cart_id_1, t0.product_id AS product_id_2, t0.quantity AS quantity_3, t0.price AS price_4, t0.currency_id AS currency_id_5, t0.property AS property_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8, t0.currency_id AS currency_id_9 FROM sf_cart_product t0 WHERE t0.cart_id = ?
Parameters:
[
  11
]
17 0.20 ms
SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ?
Parameters:
[
  140396
]
18 0.10 ms
SELECT t0.product_id AS product_id_1, t0.product AS product_2, t0.pn AS pn_3, t0.description AS description_4, t0.detail_description AS detail_description_5, t0.deleted AS deleted_6, t0.pic AS pic_7, t0.warranty AS warranty_8, t0.cost_min AS cost_min_9, t0.create_time AS create_time_10, t0.category_id AS category_id_11, t12.product_id AS product_id_13, t12.url_code AS url_code_14, t12.rating AS rating_15, t12.seo_title AS seo_title_16, t12.seo_description AS seo_description_17, t12.seo_keyword AS seo_keyword_18, t12.product_id AS product_id_19, t20.product_id AS product_id_21, t20.group_id AS group_id_22, t20.product_type AS product_type_23, t20.is_show_in_catalog AS is_show_in_catalog_24, t20.presence AS presence_25, t20.presence_str AS presence_str_26, t20.rating AS rating_27, t20.category_id AS category_id_28, t20.catalog_product_id AS catalog_product_id_29, t20.product_id AS product_id_30, t31.id AS id_32, t31.default AS default_33, t31.change_data AS change_data_34, t31.show_img AS show_img_35, t31.show_price AS show_price_36, t31.show_presence AS show_presence_37, t31.features_sharing AS features_sharing_38, t31.manual_sharing AS manual_sharing_39, t31.features AS features_40, t31.product_id AS product_id_41 FROM Products t0 LEFT JOIN Products_Data t12 ON t12.product_id = t0.product_id LEFT JOIN sf_product_index t20 ON t20.product_id = t0.product_id LEFT JOIN products_groups t31 ON t31.product_id = t0.product_id WHERE t0.product_id = ?
Parameters:
[
  140729
]

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.