https://api.dev.talloverde.com/api/carts/291438?q=%2Fapi%2Fcarts%2F291438

Query Metrics

3 Database Queries
3 Different statements
1.95 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 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, 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
Parameters:
[
  291438
]
2 0.70 ms
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 = ?
Parameters:
[
  291438
]
3 0.53 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:
[]

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.