Query Metrics
14
Database Queries
7
Different statements
83.09 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.74 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:
[
291439
]
|
| 2 | 4.01 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:
[
291439
]
|
| 3 | 0.66 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:
[
63
]
|
| 4 | 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:
[
889
]
|
| 5 | 0.54 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:
[
187
]
|
| 6 | 0.43 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:
[
911
]
|
| 7 | 0.38 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:
[] |
| 8 | 0.48 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:
[
63
]
|
| 9 | 0.37 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:
[
889
]
|
| 10 | 0.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:
[
187
]
|
| 11 | 68.88 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:
[
911
]
|
| 12 | 0.84 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
]
|
| 13 | 0.51 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
]
|
| 14 | 4.36 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:
[
52730
]
|
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 |
|
| 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. |