GET http://35.77.87.19/admin/stock

Query Metrics

1 Database Queries
1 Different statements
1.33 ms Query time
0 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.33 ms
(100.00%)
1
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.