Query Metrics
4
Database Queries
3
Different statements
2.02 ms
Query time
2
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.56 ms |
SELECT c0_.id AS id_0, c0_.date_entered AS date_entered_1, c0_.date_modified AS date_modified_2, c0_.created_by AS created_by_3, c0_.modified_user_id AS modified_user_id_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.status AS status_7, c0_.description AS description_8, c0_.main AS main_9, c0_.type AS type_10, c0_.product_cnt AS product_cnt_11, c0_.site_product_cnt AS site_product_cnt_12, c0_.sort AS sort_13, c0_.seo_title AS seo_title_14, c0_.seo_description AS seo_description_15, c1_.id AS id_16, c1_.date_entered AS date_entered_17, c1_.date_modified AS date_modified_18, c1_.created_by AS created_by_19, c1_.modified_user_id AS modified_user_id_20, c1_.name AS name_21, c1_.slug AS slug_22, c1_.status AS status_23, c1_.description AS description_24, c1_.main AS main_25, c1_.type AS type_26, c1_.product_cnt AS product_cnt_27, c1_.site_product_cnt AS site_product_cnt_28, c1_.sort AS sort_29, c1_.seo_title AS seo_title_30, c1_.seo_description AS seo_description_31, l2_.id AS id_32, l2_.name AS name_33, l2_.key AS key_34, c3_.id AS id_35, c3_.date_entered AS date_entered_36, c3_.date_modified AS date_modified_37, c3_.created_by AS created_by_38, c3_.modified_user_id AS modified_user_id_39, c3_.name AS name_40, c3_.slug AS slug_41, c3_.status AS status_42, c3_.description AS description_43, c3_.main AS main_44, c3_.type AS type_45, c3_.product_cnt AS product_cnt_46, c3_.site_product_cnt AS site_product_cnt_47, c3_.sort AS sort_48, c3_.seo_title AS seo_title_49, c3_.seo_description AS seo_description_50, c4_.id AS id_51, c4_.date_entered AS date_entered_52, c4_.date_modified AS date_modified_53, c4_.created_by AS created_by_54, c4_.modified_user_id AS modified_user_id_55, c4_.name AS name_56, c4_.slug AS slug_57, c4_.status AS status_58, c4_.description AS description_59, c4_.main AS main_60, c4_.type AS type_61, c4_.product_cnt AS product_cnt_62, c4_.site_product_cnt AS site_product_cnt_63, c4_.sort AS sort_64, c4_.seo_title AS seo_title_65, c4_.seo_description AS seo_description_66, c0_.parent_id AS parent_id_67, c0_.media_id AS media_id_68, c0_.language_id AS language_id_69, c0_.translation_id AS translation_id_70, c1_.parent_id AS parent_id_71, c1_.media_id AS media_id_72, c1_.language_id AS language_id_73, c1_.translation_id AS translation_id_74, c3_.parent_id AS parent_id_75, c3_.media_id AS media_id_76, c3_.language_id AS language_id_77, c3_.translation_id AS translation_id_78, c4_.parent_id AS parent_id_79, c4_.media_id AS media_id_80, c4_.language_id AS language_id_81, c4_.translation_id AS translation_id_82 FROM category c0_ LEFT JOIN category c1_ ON c0_.parent_id = c1_.id LEFT JOIN languages l2_ ON c0_.language_id = l2_.id LEFT JOIN category c3_ ON c0_.translation_id = c3_.id LEFT JOIN category c4_ ON c0_.id = c4_.translation_id WHERE c0_.id = ?
Parameters:
[
59
]
|
| 2 | 0.19 ms |
SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.parent_id AS parent_id_17, t0.media_id AS media_id_18, t0.language_id AS language_id_19, t0.translation_id AS translation_id_20 FROM category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 3 | 0.14 ms |
SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.parent_id AS parent_id_17, t0.media_id AS media_id_18, t0.language_id AS language_id_19, t0.translation_id AS translation_id_20 FROM category t0 WHERE t0.translation_id = ?
Parameters:
[
4
]
|
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.date_modified AS date_modified_3, t0.created_by AS created_by_4, t0.modified_user_id AS modified_user_id_5, t0.name AS name_6, t0.slug AS slug_7, t0.status AS status_8, t0.description AS description_9, t0.main AS main_10, t0.type AS type_11, t0.product_cnt AS product_cnt_12, t0.site_product_cnt AS site_product_cnt_13, t0.sort AS sort_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.parent_id AS parent_id_17, t0.media_id AS media_id_18, t0.language_id AS language_id_19, t0.translation_id AS translation_id_20 FROM category t0 WHERE t0.translation_id = ?
Parameters:
[
58
]
|
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\Category | 3 |
| App\Entity\MediaObject | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Languages |
|
| App\Entity\MediaObject | No errors. |
| App\Entity\Products | No errors. |
| App\Entity\Attributes | No errors. |
| App\Entity\AttributeItems | No errors. |
| App\Entity\Coupons | No errors. |
| App\Entity\Faq |
|
| App\Entity\Pages | No errors. |
| App\Entity\News | No errors. |
| App\Entity\SiteProducts | No errors. |
| App\Entity\Objects | No errors. |
| App\Entity\Projects | No errors. |