https://api.dev.talloverde.com/api/carts/291437?q=%2Fapi%2Fcarts%2F291437 Return to referer URL

Query Metrics

9 Database Queries
8 Different statements
30.63 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 7.98 ms
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 = ?
Parameters:
[
  "291437"
]
2 6.61 ms
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
Parameters:
[
  372
]
3 0.40 ms
"START TRANSACTION"
Parameters:
[]
4 5.40 ms
INSERT INTO cart_item (quantity, created_at, updated_at, cart_id, product_id, created_by_id, updated_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => 4
  2 => "2025-12-21 00:50:11"
  3 => "2025-12-21 00:50:11"
  4 => 291437
  5 => 372
  6 => null
  7 => null
]
5 0.56 ms
UPDATE product SET tax = ?, base_price = ?, price = ? WHERE id = ?
Parameters:
[
  21.0
  6157.0247933884
  7450.0
  372
]
6 1.28 ms
"COMMIT"
Parameters:
[]
7 5.34 ms
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
Parameters:
[
  372
]
8 2.55 ms
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
Parameters:
[]
9 0.53 ms
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
Parameters:
[
  372
]

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\Order\Entity\Cart
  • The field App\Order\Entity\Cart#items is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Order\Entity\CartItem#cart does not contain the required 'inversedBy="items"' attribute.
App\Core\Entity\Parameter No errors.
App\Delivery\Entity\DeliveryZone No errors.
App\Delivery\Entity\DeliverySchedule No errors.
App\Stock\Entity\StockItem No errors.
App\Stock\Entity\StockMovement No errors.
App\Product\Entity\Product No errors.
App\Customer\Entity\Customer No errors.
App\Authentication\Entity\User No errors.
App\Customer\Entity\StreetAddress No errors.
App\Customer\Entity\BillingAddress No errors.
App\Order\Entity\CartItem No errors.
App\Product\Entity\ProductCategory No errors.
App\Product\Entity\ProductSize No errors.
App\Product\Entity\UnitOfMeasurement No errors.
App\Customer\Entity\IvaCondition No errors.