GET https://35-77-87-19.nip.io/admin/stock/1

Query Metrics

3 Database Queries
3 Different statements
2.80 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.87 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:
[
  1
]
2 1.80 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:
[
  1
]
3 0.13 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:
[
  1
]

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\StockChangeHistory 3
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.