Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.password AS password_2,
  u0_.salt AS salt_3,
  u0_.email AS email_4,
  u0_.name AS name_5,
  u0_.roles AS roles_6,
  u0_.verification_code AS verification_code_7,
  u0_.is_verified AS is_verified_8,
  u0_.is_active AS is_active_9
FROM
  users u0_
WHERE
  u0_.username = ?
  OR u0_.email = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.salt AS salt_3, u0_.email AS email_4, u0_.name AS name_5, u0_.roles AS roles_6, u0_.verification_code AS verification_code_7, u0_.is_verified AS is_verified_8, u0_.is_active AS is_active_9 FROM users u0_ WHERE u0_.username = 'test@testuser.com' OR u0_.email = 'test@testuser.com';

SELECT
  t0.id AS id_1,
  t0.order_type AS order_type_2,
  t0.delivery_date AS delivery_date_3,
  t0.delivery_start_time AS delivery_start_time_4,
  t0.delivery_end_time AS delivery_end_time_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.customer_id AS customer_id_8,
  t0.shipping_address_id AS shipping_address_id_9,
  t0.billing_address_id AS billing_address_id_10,
  t0.delivery_schedule_id AS delivery_schedule_id_11,
  t0.shipping_product_id AS shipping_product_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14
FROM
  cart t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.order_type AS order_type_2, t0.delivery_date AS delivery_date_3, t0.delivery_start_time AS delivery_start_time_4, t0.delivery_end_time AS delivery_end_time_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t0.shipping_address_id AS shipping_address_id_9, t0.billing_address_id AS billing_address_id_10, t0.delivery_schedule_id AS delivery_schedule_id_11, t0.shipping_product_id AS shipping_product_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM cart t0 WHERE t0.id = 291438 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.cart_id AS cart_id_5,
  t0.product_id AS product_id_6,
  t7.id AS id_8,
  t7.type AS type_9,
  t7.name AS name_10,
  t7.description AS description_11,
  t7.presentation AS presentation_12,
  t7.is_wholesaler AS is_wholesaler_13,
  t7.publicSale AS publicSale_14,
  t7.active AS active_15,
  t7.isDeleted AS isDeleted_16,
  t7.recommended AS recommended_17,
  t7.tax AS tax_18,
  t7.base_price AS base_price_19,
  t7.price AS price_20,
  t7.thumbnail AS thumbnail_21,
  t7.image AS image_22,
  t7.idCategory AS idCategory_23,
  t7.idSize AS idSize_24,
  t7.unit_of_measurement_id AS unit_of_measurement_id_25,
  t0.created_by_id AS created_by_id_26,
  t0.updated_by_id AS updated_by_id_27
FROM
  cart_item t0
  LEFT JOIN product t7 ON t0.product_id = t7.id
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6, t7.id AS id_8, t7.type AS type_9, t7.name AS name_10, t7.description AS description_11, t7.presentation AS presentation_12, t7.is_wholesaler AS is_wholesaler_13, t7.publicSale AS publicSale_14, t7.active AS active_15, t7.isDeleted AS isDeleted_16, t7.recommended AS recommended_17, t7.tax AS tax_18, t7.base_price AS base_price_19, t7.price AS price_20, t7.thumbnail AS thumbnail_21, t7.image AS image_22, t7.idCategory AS idCategory_23, t7.idSize AS idSize_24, t7.unit_of_measurement_id AS unit_of_measurement_id_25, t0.created_by_id AS created_by_id_26, t0.updated_by_id AS updated_by_id_27 FROM cart_item t0 LEFT JOIN product t7 ON t0.product_id = t7.id WHERE t0.cart_id = 291438;

SELECT
  t0.id AS id_1,
  t0.firstName AS firstName_2,
  t0.lastName AS lastName_3,
  t0.companyName AS companyName_4,
  t0.email AS email_5,
  t0.isWholesaler AS isWholesaler_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10,
  t0.created_by_id AS created_by_id_11,
  t0.updated_by_id AS updated_by_id_12
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.companyName AS companyName_4, t0.email AS email_5, t0.isWholesaler AS isWholesaler_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12 FROM customer t0 WHERE t0.id = 49589;

SELECT
  t0.id AS id_1,
  t0.place AS place_2,
  t0.area AS area_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.apartment AS apartment_6,
  t0.phoneNumberA AS phoneNumberA_7,
  t0.phoneNumberB AS phoneNumberB_8,
  t0.isActive AS isActive_9,
  t0.notes AS notes_10,
  ST_AsBinary(t0.location) AS location_11,
  t0.formatted_address AS formatted_address_12,
  t0.customer_id AS customer_id_13
FROM
  street_address t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.place AS place_2, t0.area AS area_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.apartment AS apartment_6, t0.phoneNumberA AS phoneNumberA_7, t0.phoneNumberB AS phoneNumberB_8, t0.isActive AS isActive_9, t0.notes AS notes_10, ST_AsBinary(t0.location) AS location_11, t0.formatted_address AS formatted_address_12, t0.customer_id AS customer_id_13 FROM street_address t0 WHERE t0.id = 52729 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product
SET
  tax = ?,
  base_price = ?,
  price = ?
WHERE
  id = ?

UPDATE product SET tax = 21, base_price = 16983.47107438, price = 20550 WHERE id = 63;

UPDATE
  cart
SET
  customer_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE cart SET customer_id = 49589, updated_at = '2025-12-21 01:30:26' WHERE id = 291438;

"COMMIT"

"COMMIT";

SELECT
  t0.pkey AS pkey_1,
  t0.pvalue AS pvalue_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_id AS created_by_id_5,
  t0.updated_by_id AS updated_by_id_6
FROM
  parameter t0

SELECT t0.pkey AS pkey_1, t0.pvalue AS pvalue_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM parameter t0;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.coordinates AS coordinates_2,
  d0_.center AS center_3,
  d0_.waiting_time AS waiting_time_4,
  ST_AsBinary(d0_.polygon) AS polygon_5,
  d0_.is_active AS is_active_6,
  d0_.is_for_wholesaler AS is_for_wholesaler_7,
  d0_.shipping_cost_product_id AS shipping_cost_product_id_8
FROM
  deliveryZones d0_
WHERE
  ST_Contains(
    d0_.polygon,
    ST_GeomFromText(
      'POINT(-58.456867 -34.5689508)'
    )
  ) = 1
  AND d0_.is_active = 1
  AND d0_.is_for_wholesaler = 0

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.coordinates AS coordinates_2, d0_.center AS center_3, d0_.waiting_time AS waiting_time_4, ST_AsBinary(d0_.polygon) AS polygon_5, d0_.is_active AS is_active_6, d0_.is_for_wholesaler AS is_for_wholesaler_7, d0_.shipping_cost_product_id AS shipping_cost_product_id_8 FROM deliveryZones d0_ WHERE ST_Contains(d0_.polygon, ST_GeomFromText('POINT(-58.456867 -34.5689508)')) = 1 AND d0_.is_active = 1 AND d0_.is_for_wholesaler = 0;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.presentation AS presentation_5,
  t0.is_wholesaler AS is_wholesaler_6,
  t0.publicSale AS publicSale_7,
  t0.active AS active_8,
  t0.isDeleted AS isDeleted_9,
  t0.recommended AS recommended_10,
  t0.tax AS tax_11,
  t0.base_price AS base_price_12,
  t0.price AS price_13,
  t0.thumbnail AS thumbnail_14,
  t0.image AS image_15,
  t0.idCategory AS idCategory_16,
  t0.idSize AS idSize_17,
  t0.unit_of_measurement_id AS unit_of_measurement_id_18
FROM
  product t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.description AS description_4, t0.presentation AS presentation_5, t0.is_wholesaler AS is_wholesaler_6, t0.publicSale AS publicSale_7, t0.active AS active_8, t0.isDeleted AS isDeleted_9, t0.recommended AS recommended_10, t0.tax AS tax_11, t0.base_price AS base_price_12, t0.price AS price_13, t0.thumbnail AS thumbnail_14, t0.image AS image_15, t0.idCategory AS idCategory_16, t0.idSize AS idSize_17, t0.unit_of_measurement_id AS unit_of_measurement_id_18 FROM product t0 WHERE t0.id IN (856);

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product
SET
  tax = ?,
  base_price = ?,
  price = ?
WHERE
  id = ?

UPDATE product SET tax = 21, base_price = 1487.6033057851, price = 1800 WHERE id = 856;

UPDATE
  cart
SET
  shipping_address_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE cart SET shipping_address_id = 52729, updated_at = '2025-12-21 01:30:26' WHERE id = 291438;

"COMMIT"

"COMMIT";

SELECT
  s0_.current_stock AS current_stock_0,
  s0_.minimum_stock_level AS minimum_stock_level_1,
  s0_.stop_selling_stock_level AS stop_selling_stock_level_2,
  s0_.perishable AS perishable_3,
  s0_.product_id AS product_id_4
FROM
  stock_item s0_
  INNER JOIN product p1_ ON s0_.product_id = p1_.id
WHERE
  s0_.product_id = ?
ORDER BY
  p1_.name ASC

SELECT s0_.current_stock AS current_stock_0, s0_.minimum_stock_level AS minimum_stock_level_1, s0_.stop_selling_stock_level AS stop_selling_stock_level_2, s0_.perishable AS perishable_3, s0_.product_id AS product_id_4 FROM stock_item s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.product_id = 63 ORDER BY p1_.name ASC;

SELECT
  s0_.current_stock AS current_stock_0,
  s0_.minimum_stock_level AS minimum_stock_level_1,
  s0_.stop_selling_stock_level AS stop_selling_stock_level_2,
  s0_.perishable AS perishable_3,
  s0_.product_id AS product_id_4
FROM
  stock_item s0_
  INNER JOIN product p1_ ON s0_.product_id = p1_.id
WHERE
  s0_.product_id = ?
ORDER BY
  p1_.name ASC

SELECT s0_.current_stock AS current_stock_0, s0_.minimum_stock_level AS minimum_stock_level_1, s0_.stop_selling_stock_level AS stop_selling_stock_level_2, s0_.perishable AS perishable_3, s0_.product_id AS product_id_4 FROM stock_item s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.product_id = 63 ORDER BY p1_.name ASC;