GET http://api-felso.inneti.net/api/categories?g%5B0%5D=cat%3Aread&g%5B1%5D=cat%3Acategories&g%5B2%5D=cat%3Amedia&main=true&status=active&type=category

Response
200 OK
Browse referrer URL
IP
242.180.137.56
Profiled on
Token
debeb4

Query Metrics

387 Database Queries
7 Different statements
47.30 ms Query time
4 Invalid entities
304 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
27.01 ms
(57.11%) 		245 
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: 
[
  20491
]
View formatted query    View runnable query    Explain query
5.46 ms
(11.54%) 		47 
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.parent_id = ?
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query
5.14 ms
(10.86%) 		47 
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: 
[
  59
]
View formatted query    View runnable query    Explain query
5.10 ms
(10.78%) 		45 
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.id = ?
Parameters: 
[
  20491
]
View formatted query    View runnable query    Explain query
2.14 ms
(4.52%) 		1 
SELECT DISTINCT c0_.id AS id_0, c0_.sort AS sort_1, c0_.name AS name_2 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN languages l4_ ON c0_.language_id = l4_.id LEFT JOIN category c5_ ON c0_.translation_id = c5_.id LEFT JOIN category c6_ ON c0_.id = c6_.translation_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ? ORDER BY c0_.sort ASC, c0_.name ASC LIMIT 30
Parameters: 
[
  "true"
  "active"
  "category"
]
View formatted query    View runnable query    Explain query
1.84 ms
(3.89%) 		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, 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, m2_.id AS id_32, m2_.upload_timestamp AS upload_timestamp_33, m2_.main AS main_34, m2_.file_path AS file_path_35, m2_.type AS type_36, m2_.name AS name_37, m2_.size AS size_38, m2_.sort AS sort_39, m3_.id AS id_40, m3_.upload_timestamp AS upload_timestamp_41, m3_.main AS main_42, m3_.file_path AS file_path_43, m3_.type AS type_44, m3_.name AS name_45, m3_.size AS size_46, m3_.sort AS sort_47, l4_.id AS id_48, l4_.name AS name_49, l4_.key AS key_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, c6_.id AS id_67, c6_.date_entered AS date_entered_68, c6_.date_modified AS date_modified_69, c6_.created_by AS created_by_70, c6_.modified_user_id AS modified_user_id_71, c6_.name AS name_72, c6_.slug AS slug_73, c6_.status AS status_74, c6_.description AS description_75, c6_.main AS main_76, c6_.type AS type_77, c6_.product_cnt AS product_cnt_78, c6_.site_product_cnt AS site_product_cnt_79, c6_.sort AS sort_80, c6_.seo_title AS seo_title_81, c6_.seo_description AS seo_description_82, c0_.parent_id AS parent_id_83, c0_.media_id AS media_id_84, c0_.language_id AS language_id_85, c0_.translation_id AS translation_id_86, c1_.parent_id AS parent_id_87, c1_.media_id AS media_id_88, c1_.language_id AS language_id_89, c1_.translation_id AS translation_id_90, m2_.product_id AS product_id_91, m2_.orders_id AS orders_id_92, m2_.users_id AS users_id_93, m2_.account_worker_id AS account_worker_id_94, m2_.form_answer_id AS form_answer_id_95, m2_.job_id AS job_id_96, m2_.resize_img_parent_id AS resize_img_parent_id_97, m3_.product_id AS product_id_98, m3_.orders_id AS orders_id_99, m3_.users_id AS users_id_100, m3_.account_worker_id AS account_worker_id_101, m3_.form_answer_id AS form_answer_id_102, m3_.job_id AS job_id_103, m3_.resize_img_parent_id AS resize_img_parent_id_104, c5_.parent_id AS parent_id_105, c5_.media_id AS media_id_106, c5_.language_id AS language_id_107, c5_.translation_id AS translation_id_108, c6_.parent_id AS parent_id_109, c6_.media_id AS media_id_110, c6_.language_id AS language_id_111, c6_.translation_id AS translation_id_112 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN languages l4_ ON c0_.language_id = l4_.id LEFT JOIN category c5_ ON c0_.translation_id = c5_.id LEFT JOIN category c6_ ON c0_.id = c6_.translation_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ? AND c0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY c0_.sort ASC, c0_.name ASC
Parameters: 
[
  "true"
  "active"
  "category"
  4
  5
  6
  126
  7
  56
]
View formatted query    View runnable query    Explain query
0.61 ms
(1.30%) 		1 
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id LEFT JOIN media_object m2_ ON c0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN languages l4_ ON c0_.language_id = l4_.id LEFT JOIN category c5_ ON c0_.translation_id = c5_.id LEFT JOIN category c6_ ON c0_.id = c6_.translation_id WHERE c0_.main = ? AND c0_.status = ? AND c0_.type = ?
Parameters: 
[
  "true"
  "active"
  "category"
]
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\MediaObject 251
App\Entity\Category 53

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.