Query Metrics
4
Database Queries
4
Different statements
1.45 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.53 ms (36.32%) |
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:
[
226
]
|
|
0.35 ms (23.99%) |
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.33 ms (22.47%) |
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:
[
226
]
|
|
0.25 ms (17.22%) |
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:
[
226
]
|
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 |
|
| 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 |
|
| App\Entity\ProductTag | No errors. |
| App\Entity\ClassCategory | No errors. |
| App\Entity\DeliveryDuration | No errors. |
| App\Entity\Category | No errors. |