Query Metrics
3
Database Queries
3
Different statements
0.33 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.10 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.smaregi_product_id AS smaregi_product_id_3, t0.name AS name_4, t0.price AS price_5, t0.stock AS stock_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM product_variants t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 2 | 0.13 ms |
SELECT s0_.id AS id_0, s0_.source AS source_1, s0_.change_amount AS change_amount_2, s0_.stock_before AS stock_before_3, s0_.stock_after AS stock_after_4, s0_.store_id AS store_id_5, s0_.stock_change_id AS stock_change_id_6, s0_.event AS event_7, s0_.action AS action_8, s0_.memo AS memo_9, s0_.created_at AS created_at_10, s0_.product_variant_id AS product_variant_id_11 FROM stock_change_histories s0_ WHERE s0_.product_variant_id = ? ORDER BY s0_.created_at DESC, s0_.id DESC LIMIT 200
Parameters:
[
3
]
|
| 3 | 0.10 ms |
SELECT t0.id AS id_1, t0.smaregi_product_id AS smaregi_product_id_2, t0.product_code AS product_code_3, t0.name AS name_4, t0.stock AS stock_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.category_id AS category_id_9 FROM products t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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 | 1 |
| App\Entity\Product | 1 |
| App\Entity\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductVariant | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\StockChangeHistory | No errors. |
| App\Entity\Category | No errors. |