Symfony Profiler

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,
  t12.id AS id_13,
  t12.quantity AS quantity_14,
  t12.created_at AS created_at_15,
  t12.updated_at AS updated_at_16,
  t12.cart_id AS cart_id_17,
  t12.product_id AS product_id_18,
  t12.created_by_id AS created_by_id_19,
  t12.updated_by_id AS updated_by_id_20,
  t0.shipping_product_id AS shipping_product_id_21,
  t0.created_by_id AS created_by_id_22,
  t0.updated_by_id AS updated_by_id_23
FROM
  cart t0
  LEFT JOIN cart_item t12 ON t12.cart_id = t0.id
WHERE
  t0.id = ?

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, t12.id AS id_13, t12.quantity AS quantity_14, t12.created_at AS created_at_15, t12.updated_at AS updated_at_16, t12.cart_id AS cart_id_17, t12.product_id AS product_id_18, t12.created_by_id AS created_by_id_19, t12.updated_by_id AS updated_by_id_20, t0.shipping_product_id AS shipping_product_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM cart t0 LEFT JOIN cart_item t12 ON t12.cart_id = t0.id WHERE t0.id = '291439';

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 (63, 889, 187);

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 = ?
LIMIT
  1

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 = 911 LIMIT 1;

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
  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 = ?

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 = 52730;

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.5208595 -34.4680753)'
    )
  ) = 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.5208595 -34.4680753)')) = 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";

INSERT INTO cart_item (
  quantity, created_at, updated_at,
  cart_id, product_id, created_by_id,
  updated_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO cart_item (quantity, created_at, updated_at, cart_id, product_id, created_by_id, updated_by_id) VALUES (1, '2025-12-21 16:26:00', '2025-12-21 16:26:00', 291439, 911, NULL, NULL);

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

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

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

UPDATE product SET tax = 21, base_price = 2107.4380165289, price = 2550 WHERE id = 889;

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

UPDATE product SET tax = 21, base_price = 1776.8595041322, price = 2150 WHERE id = 187;

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

UPDATE product SET tax = 21, base_price = 2115.7024793388, price = 2560 WHERE id = 911;

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

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

"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 = 889 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 = 187 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 = 911 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;

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 = 889 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 = 187 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 = 911 ORDER BY p1_.name ASC;