Query Metrics
10
Database Queries
5
Different statements
18.03 ms
Query time
1
Invalid entities
122
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
10.24 ms (56.78%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.subtitle AS subtitle_3, t0.status AS status_4, t0.edycja7 AS edycja7_5, t0.base_price AS base_price_6, t0.description AS description_7, t0.options AS options_8, t0.points AS points_9, t0.netto AS netto_10, t0.promo_points AS promo_points_11, t0.promo_start AS promo_start_12, t0.promo_end AS promo_end_13, t0.number AS number_14, t0.manufacturer AS manufacturer_15, t0.packing AS packing_16, t0.packing2 AS packing2_17, t0.orderable AS orderable_18, t0.position AS position_19, t0.vip AS vip_20, t0.only_vip AS only_vip_21, t0.knauf AS knauf_22, t0.label AS label_23, t0.info AS info_24, t0.slug AS slug_25, t0.image_name AS image_name_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.deleted_at AS deleted_at_29 FROM p_product t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_id WHERE product_product_category.product_category_id = ?
Parameters:
[
13
]
|
2.56 ms (14.20%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.subtitle AS subtitle_2, p0_.status AS status_3, p0_.edycja7 AS edycja7_4, p0_.base_price AS base_price_5, p0_.description AS description_6, p0_.options AS options_7, p0_.points AS points_8, p0_.netto AS netto_9, p0_.promo_points AS promo_points_10, p0_.promo_start AS promo_start_11, p0_.promo_end AS promo_end_12, p0_.number AS number_13, p0_.manufacturer AS manufacturer_14, p0_.packing AS packing_15, p0_.packing2 AS packing2_16, p0_.orderable AS orderable_17, p0_.position AS position_18, p0_.vip AS vip_19, p0_.only_vip AS only_vip_20, p0_.knauf AS knauf_21, p0_.label AS label_22, p0_.info AS info_23, p0_.slug AS slug_24, p0_.image_name AS image_name_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.deleted_at AS deleted_at_28, p1_.id AS id_29, p1_.name AS name_30, p1_.position AS position_31, p1_.slug AS slug_32, p1_.image_name AS image_name_33, p1_.active AS active_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p2_.id AS id_38, p2_.image AS image_39, p2_.main AS main_40, p2_.created_at AS created_at_41, p2_.updated_at AS updated_at_42, p1_.parent_id AS parent_id_43, p2_.product_id AS product_id_44 FROM p_product p0_ LEFT JOIN product_product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN p_category p1_ ON p1_.id = p3_.product_category_id LEFT JOIN p_photo p2_ ON p0_.id = p2_.product_id WHERE p0_.status = ? AND p0_.deleted_at IS NULL AND p1_.id = ? AND (p0_.only_vip = 0 OR p0_.only_vip IS NULL) ORDER BY p1_.position ASC, p0_.position ASC
Parameters:
[ 1 34 ] |
1.92 ms (10.63%) |
1 |
SELECT p0_.slug AS slug_0, p1_.id AS id_1 FROM p_category p0_ LEFT JOIN product_product_category p2_ ON p0_.id = p2_.product_category_id LEFT JOIN p_product p1_ ON p1_.id = p2_.product_id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.deleted_at IS NULL
Parameters:
[ 165 167 168 169 170 264 266 265 539 540 182 ] |
1.66 ms (9.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.slug AS slug_4, t0.image_name AS image_name_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM p_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"systemy-suchej-zabudowy"
]
|
1.65 ms (9.16%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.position AS position_2, p0_.slug AS slug_3, p0_.image_name AS image_name_4, p0_.active AS active_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8, p0_.parent_id AS parent_id_9 FROM p_category p0_ WHERE p0_.parent_id = ? AND p0_.active = 1 AND p0_.deleted_at IS NULL ORDER BY p0_.position 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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Product | 115 |
App\Entity\ProductCategory | 7 |