Query Metrics
8
Database Queries
8
Different statements
6.25 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.12 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.cart_cat AS cart_cat_2, t0.type AS type_3, t0.type1 AS type1_4, t0.status AS status_5, t0.user_id AS user_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.name AS name_9, t0.name_en AS name_en_10, t0.content AS content_11, t0.content_en AS content_en_12, t0.image AS image_13, t0.price AS price_14, t0.price_old AS price_old_15 FROM cart_product t0
Parameters:
[] |
1.44 ms (0.00%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.annonces_id AS annonces_id_2 FROM images i0_ WHERE i0_.annonces_id = ? ORDER BY i0_.id ASC LIMIT 1
Parameters:
[
"1f968c72-eb78-11ec-8a72-ca02b436025f"
]
|
0.95 ms (0.00%) |
1 |
SELECT * FROM cart_product WHERE price = ( SELECT MAX(price) FROM cart_product WHERE cart_cat = 1 ) AND cart_cat = 1
Parameters:
[] |
0.61 ms (0.00%) |
1 |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.content AS content_4, c0_.image AS image_5, c0_.price AS price_6 FROM cart_payment c0_
Parameters:
[] |
0.49 ms (0.00%) |
1 |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.price AS price_4, c0_.content AS content_5, c0_.image AS image_6 FROM cart_shipment c0_
Parameters:
[] |
0.26 ms (0.00%) |
1 |
SELECT MIN(price) AS price FROM cart_product WHERE cart_cat = 1
Parameters:
[] |
0.23 ms (0.00%) |
1 |
SELECT * FROM images p WHERE p.annonces_id = :id
Parameters:
[ "id" => "127" ] |
0.15 ms (0.00%) |
1 |
SELECT * FROM cart_product WHERE cart_cat = 1 LIMIT 10
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\Entity\Images | No errors. |
App\Entity\WishList | No errors. |
App\Entity\Annonces |
|
App\Component\Product\Model\Product | No errors. |
App\Component\Order\Model\OrderItem | No errors. |
App\Component\Payment\Model\Payment | No errors. |
App\Component\Shipment\Model\Shipment | No errors. |
App\Entity\User |
|
App\Component\Order\Model\Order | No errors. |