GET http://api-felso.inneti.net/api/categories/59?g%5B0%5D=cat%3Aread&g%5B1%5D=cat%3Aparent

Query Metrics

4 Database Queries
3 Different statements
2.85 ms Query time
2 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 2.36 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.20 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.16 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.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:
[
  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
  • The association App\Entity\Languages#vacancies refers to the owning side field App\Entity\Vacancies#language which does not exist.
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
  • The mappings App\Entity\Faq#createdUser and App\Entity\User#faqs are inconsistent with each other.
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.