Query Metrics
343
Database Queries
8
Different statements
39.28 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
9.29 ms (23.64%) |
75 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.ean_value AS ean_value_3, t0.image_cs AS image_cs_4, t0.image_sk AS image_sk_5, t0.product_id AS product_id_6 FROM ean t0 WHERE t0.product_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||
|
8.73 ms (22.23%) |
75 |
SELECT t0.id AS id_1, t0.images_thumb AS images_thumb_2, t0.images_detail AS images_detail_3, t0.product_assets_product_list AS product_assets_product_list_4, t0.product_assets_product_image AS product_assets_product_image_5, t0.title AS title_6, t0.category AS category_7, t0.perex AS perex_8, t0.description AS description_9, t0.ingredients AS ingredients_10, t0.consumption AS consumption_11, t0.language AS language_12, t0.title_sub_1 AS title_sub_1_13, t0.title_sub_2 AS title_sub_2_14, t0.product_id AS product_id_15 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||
|
8.28 ms (21.09%) |
75 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.size_value AS size_value_3, t0.product_id AS product_id_4 FROM product_size t0 WHERE t0.product_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||
|
7.87 ms (20.03%) |
75 |
SELECT t0.id AS id_1, t0.category_slug AS category_slug_2, t0.sub_category_slug AS sub_category_slug_3, t0.product_slug AS product_slug_4, t0.language AS language_5, t0.product_id AS product_id_6 FROM product_slug t0 WHERE t0.product_id = ?
Parameters:
[
46
]
|
||||||||||||||||||||
|
1.94 ms (4.93%) |
14 |
SELECT t0.id AS id_1, t0.position_order AS position_order_2, t0.admin_description AS admin_description_3, t0.published AS published_4, t0.onlyDev AS onlyDev_5, t0.rohlik_link AS rohlik_link_6, t0.kosik_link AS kosik_link_7, t0.edelia_sk_link AS edelia_sk_link_8, t0.nutrition_energy AS nutrition_energy_9, t0.nutrition_fat AS nutrition_fat_10, t0.nutrition_saturated_fat AS nutrition_saturated_fat_11, t0.nutrition_carbon_hydrates AS nutrition_carbon_hydrates_12, t0.nutrition_sugar AS nutrition_sugar_13, t0.nutrition_proteins AS nutrition_proteins_14, t0.nutrition_salt AS nutrition_salt_15, t0.nutrition_gmos AS nutrition_gmos_16, t0.nutrition_lactose_free AS nutrition_lactose_free_17, t0.nutrition_gluten AS nutrition_gluten_18, t0.nutrition_bifidobacterium AS nutrition_bifidobacterium_19, t0.nutrition_farma_otrocin AS nutrition_farma_otrocin_20, t0.nutrition_2_energy AS nutrition_2_energy_21, t0.nutrition_2_fat AS nutrition_2_fat_22, t0.nutrition_2_saturated_fat AS nutrition_2_saturated_fat_23, t0.nutrition_2_carbon_hydrates AS nutrition_2_carbon_hydrates_24, t0.nutrition_2_sugar AS nutrition_2_sugar_25, t0.nutrition_2_proteins AS nutrition_2_proteins_26, t0.nutrition_2_salt AS nutrition_2_salt_27, t0.nutrition_2_gmos AS nutrition_2_gmos_28, t0.nutrition_2_lactose_free AS nutrition_2_lactose_free_29, t0.nutrition_2_gluten AS nutrition_2_gluten_30, t0.nutrition_2_bifidobacterium AS nutrition_2_bifidobacterium_31, t0.nutrition_2_farma_otrocin AS nutrition_2_farma_otrocin_32, t0.main_category_id AS main_category_id_33 FROM product t0 WHERE t0.main_category_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||
|
1.47 ms (3.74%) |
14 |
SELECT t0.id AS id_1, t0.position_order AS position_order_2, t0.admin_description AS admin_description_3, t0.published AS published_4, t0.onlyDev AS onlyDev_5, t0.parent_category_id AS parent_category_id_6, t0.homepage_category_id AS homepage_category_id_7 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||
|
1.47 ms (3.73%) |
14 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.language AS language_5, t0.image AS image_6, t0.product_category_id AS product_category_id_7 FROM product_category_translation t0 WHERE t0.product_category_id = ?
Parameters:
[
14
]
|
||||||||||||||||||||
|
0.24 ms (0.61%) |
1 |
SELECT t0.id AS id_1, t0.position_order AS position_order_2, t0.admin_description AS admin_description_3, t0.published AS published_4, t0.onlyDev AS onlyDev_5, t0.parent_category_id AS parent_category_id_6, t0.homepage_category_id AS homepage_category_id_7 FROM product_category t0 WHERE t0.published = ? AND t0.parent_category_id IS NULL ORDER BY t0.position_order ASC
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductCategory |
|
| App\Entity\HomepageProductCategory | No errors. |
| App\Entity\ProductNutrition | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductCategoryTranslation | No errors. |
| App\Entity\Ean | No errors. |
| App\Entity\ProductSize | No errors. |
| App\Entity\ProductSlug | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\SellerProduct | No errors. |