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

Query Metrics

487 Database Queries
3 Different statements
82.27 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
80.39 ms
(97.71%)
483
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.discriminator_type AS discriminator_type_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7 FROM dtb_product_image t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
1.25 ms
(1.52%)
1
SELECT t0.id AS id_1, t0.product_status_id AS product_status_id_2, t0.name AS name_3, t0.note AS note_4, t0.description_list AS description_list_5, t0.description_detail AS description_detail_6, t0.search_word AS search_word_7, t0.free_area AS free_area_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.discriminator_type AS discriminator_type_11, t0.product_status_id AS product_status_id_12, t0.creator_id AS creator_id_13, t0.product_status_id AS product_status_id_14 FROM dtb_product t0
Parameters:
[]
0.63 ms
(0.77%)
3
SELECT t0.id AS id_1, t0.work_id AS work_id_2, t0.authority_id AS authority_id_3, t0.name AS name_4, t0.department AS department_5, t0.login_id AS login_id_6, t0.password AS password_7, t0.salt AS salt_8, t0.sort_no AS sort_no_9, t0.two_factor_auth_key AS two_factor_auth_key_10, t0.two_factor_auth_enabled AS two_factor_auth_enabled_11, t0.create_date AS create_date_12, t0.update_date AS update_date_13, t0.login_date AS login_date_14, t0.discriminator_type AS discriminator_type_15, t0.creator_id AS creator_id_16 FROM dtb_member t0 WHERE t0.id = ?
Parameters:
[
  6
]

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\SaleType No errors.
App\Entity\Member No errors.
App\Entity\ProductStatus No errors.
App\Entity\ProductImage 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.