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

Response
200 OK
IP
216.73.216.133
Profiled on
Token
47a002

Query Metrics

3 Database Queries
3 Different statements
3.77 ms Query time
3 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.25 ms
(59.76%) 		1 
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: 
[
  "test"
]
View formatted query    View runnable query    Explain query
1.05 ms
(27.80%) 		1 
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: 
[
  "test"
  129
]
View formatted query    View runnable query    Explain query
0.47 ms
(12.44%) 		1 
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: 
[
  "test"
]
View formatted query    View runnable query    Explain query

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 1

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.