GET http://api-felso.inneti.net/api/news?g%5B0%5D=news%3Aread&g%5B1%5D=news%3Amedia&itemsPerPage=4

Response
200 OK
Browse referrer URL
IP
244.145.15.106
Profiled on
Token
f9c594

Query Metrics

19 Database Queries
4 Different statements
6.90 ms Query time
3 Invalid entities
24 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.88 ms 
SELECT DISTINCT n0_.id AS id_0, n0_.id AS id_1 FROM news n0_ LEFT JOIN category_news c2_ ON n0_.id = c2_.news_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id LEFT JOIN media_object m3_ ON n0_.media_id = m3_.id LEFT JOIN media_object m4_ ON m3_.id = m4_.resize_img_parent_id LEFT JOIN languages l5_ ON n0_.language_id = l5_.id LEFT JOIN news n6_ ON n0_.translation_id = n6_.id LEFT JOIN news n7_ ON n0_.id = n7_.translation_id ORDER BY n0_.id DESC LIMIT 4
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 2.66 ms 
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.date AS date_2, n0_.news_shot AS news_shot_3, n0_.news_full AS news_full_4, n0_.active AS active_5, n0_.top AS top_6, n0_.audio_link AS audio_link_7, n0_.video_link AS video_link_8, n0_.audio_title AS audio_title_9, n0_.audio_active AS audio_active_10, n0_.video_img AS video_img_11, n0_.slider AS slider_12, n0_.date_start AS date_start_13, n0_.address AS address_14, n0_.short_description AS short_description_15, n0_.content_img AS content_img_16, n0_.opacity_card AS opacity_card_17, n0_.seo_title AS seo_title_18, n0_.seo_description AS seo_description_19, c1_.id AS id_20, c1_.date_entered AS date_entered_21, c1_.date_modified AS date_modified_22, c1_.created_by AS created_by_23, c1_.modified_user_id AS modified_user_id_24, c1_.name AS name_25, c1_.slug AS slug_26, c1_.status AS status_27, c1_.description AS description_28, c1_.main AS main_29, c1_.type AS type_30, c1_.product_cnt AS product_cnt_31, c1_.site_product_cnt AS site_product_cnt_32, c1_.sort AS sort_33, c1_.seo_title AS seo_title_34, c1_.seo_description AS seo_description_35, m2_.id AS id_36, m2_.upload_timestamp AS upload_timestamp_37, m2_.main AS main_38, m2_.file_path AS file_path_39, m2_.type AS type_40, m2_.name AS name_41, m2_.size AS size_42, m2_.sort AS sort_43, m3_.id AS id_44, m3_.upload_timestamp AS upload_timestamp_45, m3_.main AS main_46, m3_.file_path AS file_path_47, m3_.type AS type_48, m3_.name AS name_49, m3_.size AS size_50, m3_.sort AS sort_51, l4_.id AS id_52, l4_.name AS name_53, l4_.key AS key_54, n5_.id AS id_55, n5_.name AS name_56, n5_.date AS date_57, n5_.news_shot AS news_shot_58, n5_.news_full AS news_full_59, n5_.active AS active_60, n5_.top AS top_61, n5_.audio_link AS audio_link_62, n5_.video_link AS video_link_63, n5_.audio_title AS audio_title_64, n5_.audio_active AS audio_active_65, n5_.video_img AS video_img_66, n5_.slider AS slider_67, n5_.date_start AS date_start_68, n5_.address AS address_69, n5_.short_description AS short_description_70, n5_.content_img AS content_img_71, n5_.opacity_card AS opacity_card_72, n5_.seo_title AS seo_title_73, n5_.seo_description AS seo_description_74, n6_.id AS id_75, n6_.name AS name_76, n6_.date AS date_77, n6_.news_shot AS news_shot_78, n6_.news_full AS news_full_79, n6_.active AS active_80, n6_.top AS top_81, n6_.audio_link AS audio_link_82, n6_.video_link AS video_link_83, n6_.audio_title AS audio_title_84, n6_.audio_active AS audio_active_85, n6_.video_img AS video_img_86, n6_.slider AS slider_87, n6_.date_start AS date_start_88, n6_.address AS address_89, n6_.short_description AS short_description_90, n6_.content_img AS content_img_91, n6_.opacity_card AS opacity_card_92, n6_.seo_title AS seo_title_93, n6_.seo_description AS seo_description_94, n0_.media_id AS media_id_95, n0_.language_id AS language_id_96, n0_.translation_id AS translation_id_97, c1_.parent_id AS parent_id_98, c1_.media_id AS media_id_99, c1_.language_id AS language_id_100, c1_.translation_id AS translation_id_101, m2_.product_id AS product_id_102, m2_.orders_id AS orders_id_103, m2_.users_id AS users_id_104, m2_.account_worker_id AS account_worker_id_105, m2_.form_answer_id AS form_answer_id_106, m2_.job_id AS job_id_107, m2_.resize_img_parent_id AS resize_img_parent_id_108, m3_.product_id AS product_id_109, m3_.orders_id AS orders_id_110, m3_.users_id AS users_id_111, m3_.account_worker_id AS account_worker_id_112, m3_.form_answer_id AS form_answer_id_113, m3_.job_id AS job_id_114, m3_.resize_img_parent_id AS resize_img_parent_id_115, n5_.media_id AS media_id_116, n5_.language_id AS language_id_117, n5_.translation_id AS translation_id_118, n6_.media_id AS media_id_119, n6_.language_id AS language_id_120, n6_.translation_id AS translation_id_121 FROM news n0_ LEFT JOIN category_news c7_ ON n0_.id = c7_.news_id LEFT JOIN category c1_ ON c1_.id = c7_.category_id LEFT JOIN media_object m2_ ON n0_.media_id = m2_.id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN languages l4_ ON n0_.language_id = l4_.id LEFT JOIN news n5_ ON n0_.translation_id = n5_.id LEFT JOIN news n6_ ON n0_.id = n6_.translation_id WHERE n0_.id IN (?, ?, ?, ?) ORDER BY n0_.id DESC
Parameters: 
[
  16
  11
  3
  2
]
View formatted query    View runnable query    Explain query
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: 
[
  22890
]
View formatted query    View runnable query    Explain query
4 0.13 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: 
[
  22891
]
View formatted query    View runnable query    Explain query
5 0.12 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: 
[
  22892
]
View formatted query    View runnable query    Explain query
6 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: 
[
  22893
]
View formatted query    View runnable query    Explain query
7 0.14 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: 
[
  21854
]
View formatted query    View runnable query    Explain query
8 0.13 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: 
[
  21855
]
View formatted query    View runnable query    Explain query
9 0.13 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: 
[
  21856
]
View formatted query    View runnable query    Explain query
10 0.13 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: 
[
  21857
]
View formatted query    View runnable query    Explain query
11 0.10 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: 
[
  21869
]
View formatted query    View runnable query    Explain query
12 0.10 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: 
[
  21870
]
View formatted query    View runnable query    Explain query
13 0.10 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: 
[
  21871
]
View formatted query    View runnable query    Explain query
14 0.10 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: 
[
  21872
]
View formatted query    View runnable query    Explain query
15 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: 
[
  21777
]
View formatted query    View runnable query    Explain query
16 0.10 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: 
[
  21778
]
View formatted query    View runnable query    Explain query
17 0.10 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: 
[
  21779
]
View formatted query    View runnable query    Explain query
18 0.12 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: 
[
  21780
]
View formatted query    View runnable query    Explain query
19 0.47 ms 
SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news n0_ LEFT JOIN category_news c2_ ON n0_.id = c2_.news_id LEFT JOIN category c1_ ON c1_.id = c2_.category_id LEFT JOIN media_object m3_ ON n0_.media_id = m3_.id LEFT JOIN media_object m4_ ON m3_.id = m4_.resize_img_parent_id LEFT JOIN languages l5_ ON n0_.language_id = l5_.id LEFT JOIN news n6_ ON n0_.translation_id = n6_.id LEFT JOIN news n7_ ON n0_.id = n7_.translation_id
Parameters: 
[]
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 20
App\Entity\News 4

Entities Mapping

Class Mapping errors
App\Entity\News No 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\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\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\Objects No errors.
App\Entity\Projects No errors.
App\Entity\Posts No errors.
App\Entity\Documents No errors.