Query Metrics
1
Database Queries
1
Different statements
1.33 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.33 ms |
SELECT p0_.id AS id_0, p0_.variant_code AS variant_code_1, p0_.smaregi_product_id AS smaregi_product_id_2, p0_.name AS name_3, p0_.price AS price_4, p0_.stock AS stock_5, p0_.deleted_at AS deleted_at_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p1_.id AS id_9, p1_.smaregi_product_id AS smaregi_product_id_10, p1_.product_code AS product_code_11, p1_.name AS name_12, p1_.stock AS stock_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.deleted_at AS deleted_at_16, p0_.product_id AS product_id_17, p1_.category_id AS category_id_18 FROM product_variants p0_ LEFT JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.deleted_at IS NULL ORDER BY p1_.name ASC, p0_.variant_code ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ProductVariant | 6 |
| App\Entity\Product | 3 |
| App\Entity\Category | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductVariant | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |