https://shiire.test.ky-trust.net/product/134/edit

Query Metrics

4 Database Queries
4 Different statements
1.18 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.48 ms
(40.31%)
1
SELECT d0_.id AS id_0, d0_.product_status_id AS product_status_id_1, d0_.name AS name_2, d0_.note AS note_3, d0_.description_list AS description_list_4, d0_.description_detail AS description_detail_5, d0_.search_word AS search_word_6, d0_.free_area AS free_area_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.discriminator_type AS discriminator_type_10, d1_.id AS id_11, d1_.file_name AS file_name_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.discriminator_type AS discriminator_type_15, d0_.product_status_id AS product_status_id_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d1_.product_id AS product_id_19, d1_.creator_id AS creator_id_20 FROM dtb_product d0_ LEFT JOIN dtb_product_image d1_ ON d0_.id = d1_.product_id WHERE d0_.id = ?
Parameters:
[
  134
]
0.28 ms
(23.50%)
1
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.discriminator_type AS discriminator_type_14, t0.product_id AS product_id_15, t0.sale_type_id AS sale_type_id_16, t0.class_category_id1 AS class_category_id1_17, t0.class_category_id2 AS class_category_id2_18, t0.delivery_duration_id AS delivery_duration_id_19, t0.creator_id AS creator_id_20 FROM dtb_product_class t0 WHERE t0.product_id = ?
Parameters:
[
  134
]
0.25 ms
(21.40%)
1
SELECT t0.id AS id_1, t0.parent_category_id AS parent_category_id_2, t0.creator_id AS creator_id_3, t0.category_name AS category_name_4, t0.hierarchy AS hierarchy_5, t0.sort_no AS sort_no_6, t0.create_date AS create_date_7, t0.update_date AS update_date_8, t0.discriminator_type AS discriminator_type_9 FROM dtb_category t0
Parameters:
[]
0.17 ms
(14.79%)
1
SELECT t0.discriminator_type AS discriminator_type_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3 FROM dtb_product_category t0 WHERE t0.product_id = ?
Parameters:
[
  134
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Product
  • The mappings App\Entity\Product#ProductCategories and App\Entity\ProductCategory#Product are inconsistent with each other.
  • The mappings App\Entity\Product#ProductClasses and App\Entity\ProductClass#Product are inconsistent with each other.
  • The mappings App\Entity\Product#ProductImage and App\Entity\ProductImage#Product are inconsistent with each other.
App\Entity\ProductImage No errors.
App\Entity\SaleType No errors.
App\Entity\Member No errors.
App\Entity\ProductStatus No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductClass
  • The association App\Entity\ProductClass#Product refers to the inverse side field App\Entity\Product#productClasses which does not exist.
App\Entity\ProductTag No errors.
App\Entity\ClassCategory No errors.
App\Entity\DeliveryDuration No errors.
App\Entity\Category No errors.