Query Metrics

1 Database Queries
1 Different statements
4.70 ms Query time
0 Invalid entities
98 Managed entities

Queries

Group similar statements

# Time Info
1 4.70 ms
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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC
Parameters:
[
  7
]

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 92
App\Entity\ProductCategory 6

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\ProductPhoto No errors.
App\Entity\InvoiceProduct No errors.
App\Entity\OrderProduct No errors.