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

Query Metrics

10 Database Queries
7 Different statements
13.11 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.35 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:
[
  291437
]
2 2.77 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:
[
  291437
]
3 0.60 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
]
4 0.35 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:
[
  856
]
5 0.41 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:
[]
6 0.45 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
]
7 0.32 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:
[
  856
]
8 1.41 ms
SELECT t0.id AS id_1, t0.businessName AS businessName_2, t0.cuit AS cuit_3, t0.postalAddress AS postalAddress_4, t0.fiscalAddress AS fiscalAddress_5, t0.isActive AS isActive_6, t0.idIsis AS idIsis_7, t0.idIvaCondition AS idIvaCondition_8, t0.customer_id AS customer_id_9 FROM billing_address t0 WHERE t0.id = ?
Parameters:
[
  42704
]
9 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.receiptType AS receiptType_3, t0.documentType AS documentType_4, t0.receiptName AS receiptName_5, t0.isisName AS isisName_6, t0.is_active AS is_active_7 FROM iva_condition t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 3.84 ms
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 = ?
Parameters:
[
  52729
]

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.