Query Metrics
2
Database Queries
2
Different statements
3.26 ms
Query time
0
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.price AS price_6, t0.vat_rate AS vat_rate_7, t0.stock AS stock_8, t0.image_url AS image_url_9, t0.origin AS origin_10, t0.grade AS grade_11, t0.is_active AS is_active_12, t0.is_featured AS is_featured_13, t0.category_id AS category_id_14 FROM product t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "gousses-de-vanille-bourbon" 1 ]
|
||||||||||||||||||||||||||||
| 2 | 1.62 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.vat_rate AS vat_rate_6, p0_.stock AS stock_7, p0_.image_url AS image_url_8, p0_.origin AS origin_9, p0_.grade AS grade_10, p0_.is_active AS is_active_11, p0_.is_featured AS is_featured_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.description AS description_16, c1_.image AS image_17, c1_.position AS position_18, c1_.is_active AS is_active_19, c1_.created_at AS created_at_20, p0_.category_id AS category_id_21 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.is_active = ? AND p0_.id <> ? AND c1_.id = ? ORDER BY p0_.is_featured DESC, p0_.id DESC LIMIT 4
Parameters:
[ 1 7 6 ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product\Product | 1 |
| App\Entity\Product\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product\Product | No errors. |
| App\Entity\Product\Category | No errors. |