GET http://api-felso.inneti.net/api/categories?g%5B0%5D=cat%3Aread&g%5B2%5D=cat%3Amedia&slug=frezeri

Query Metrics

6 Database Queries
4 Different statements
3.85 ms Query time
4 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 1.98 ms
SELECT DISTINCT c0_.id AS id_0, c0_.sort AS sort_1, c0_.name AS name_2 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ? ORDER BY c0_.sort ASC, c0_.name ASC LIMIT 30
Parameters:
[
  "frezeri"
]
2 1.01 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, m1_.id AS id_16, m1_.upload_timestamp AS upload_timestamp_17, m1_.main AS main_18, m1_.file_path AS file_path_19, m1_.type AS type_20, m1_.name AS name_21, m1_.size AS size_22, m1_.sort AS sort_23, m2_.id AS id_24, m2_.upload_timestamp AS upload_timestamp_25, m2_.main AS main_26, m2_.file_path AS file_path_27, m2_.type AS type_28, m2_.name AS name_29, m2_.size AS size_30, m2_.sort AS sort_31, l3_.id AS id_32, l3_.name AS name_33, l3_.key AS key_34, c4_.id AS id_35, c4_.date_entered AS date_entered_36, c4_.date_modified AS date_modified_37, c4_.created_by AS created_by_38, c4_.modified_user_id AS modified_user_id_39, c4_.name AS name_40, c4_.slug AS slug_41, c4_.status AS status_42, c4_.description AS description_43, c4_.main AS main_44, c4_.type AS type_45, c4_.product_cnt AS product_cnt_46, c4_.site_product_cnt AS site_product_cnt_47, c4_.sort AS sort_48, c4_.seo_title AS seo_title_49, c4_.seo_description AS seo_description_50, c5_.id AS id_51, c5_.date_entered AS date_entered_52, c5_.date_modified AS date_modified_53, c5_.created_by AS created_by_54, c5_.modified_user_id AS modified_user_id_55, c5_.name AS name_56, c5_.slug AS slug_57, c5_.status AS status_58, c5_.description AS description_59, c5_.main AS main_60, c5_.type AS type_61, c5_.product_cnt AS product_cnt_62, c5_.site_product_cnt AS site_product_cnt_63, c5_.sort AS sort_64, c5_.seo_title AS seo_title_65, c5_.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, m1_.product_id AS product_id_71, m1_.orders_id AS orders_id_72, m1_.users_id AS users_id_73, m1_.account_worker_id AS account_worker_id_74, m1_.form_answer_id AS form_answer_id_75, m1_.job_id AS job_id_76, m1_.resize_img_parent_id AS resize_img_parent_id_77, m2_.product_id AS product_id_78, m2_.orders_id AS orders_id_79, m2_.users_id AS users_id_80, m2_.account_worker_id AS account_worker_id_81, m2_.form_answer_id AS form_answer_id_82, m2_.job_id AS job_id_83, m2_.resize_img_parent_id AS resize_img_parent_id_84, c4_.parent_id AS parent_id_85, c4_.media_id AS media_id_86, c4_.language_id AS language_id_87, c4_.translation_id AS translation_id_88, c5_.parent_id AS parent_id_89, c5_.media_id AS media_id_90, c5_.language_id AS language_id_91, c5_.translation_id AS translation_id_92 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ? AND c0_.id IN (?) ORDER BY c0_.sort ASC, c0_.name ASC
Parameters:
[
  "frezeri"
  18
]
3 0.18 ms
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
  316
]
4 0.15 ms
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
  317
]
5 0.11 ms
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
  318
]
6 0.42 ms
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN media_object m1_ ON c0_.media_id = m1_.id LEFT JOIN media_object m2_ ON m1_.id = m2_.resize_img_parent_id LEFT JOIN languages l3_ ON c0_.language_id = l3_.id LEFT JOIN category c4_ ON c0_.translation_id = c4_.id LEFT JOIN category c5_ ON c0_.id = c5_.translation_id WHERE c0_.slug = ?
Parameters:
[
  "frezeri"
]

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\MediaObject 4
App\Entity\Category 2

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Products No errors.
App\Entity\Attributes No errors.
App\Entity\Faq
  • The mappings App\Entity\Faq#createdUser and App\Entity\User#faqs are inconsistent with each other.
App\Entity\News No errors.
App\Entity\Pages No errors.
App\Entity\Projects No errors.
App\Entity\SiteProducts No errors.
App\Entity\Objects No errors.
App\Entity\MediaObject 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\Orders No errors.
App\Entity\User
  • The association App\Entity\User#faqs refers to the owning side field App\Entity\Faq#created_by which does not exist.
App\Entity\AccountWorker No errors.
App\Entity\FormAnswer No errors.
App\Entity\Jobs No errors.
App\Entity\AttributeItems No errors.
App\Entity\Coupons No errors.
App\Entity\UsersDocs No errors.
App\Entity\Workers No errors.
App\Entity\AccountJobsList No errors.
App\Entity\SiteProductsMedia No errors.
App\Entity\Slide No errors.
App\Entity\GalleryItems No errors.
App\Entity\MenuItems No errors.
App\Entity\VacancyRequest
  • The association App\Entity\VacancyRequest#vacancy refers to the inverse side field App\Entity\Vacancies#vacancyRequests which does not exist.
App\Entity\MaterialMedia No errors.
App\Entity\Accounts No errors.
App\Entity\Posts No errors.
App\Entity\Documents No errors.