GET https://2.uniqskills.com/pl/baza-wiedzy/artykuly-ksiegowe/jpk-cit-w-praktyce-jak-uniknac-bledow-w-raportowaniu

Query Metrics

26 Database Queries
10 Different statements
172.16 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 55.31 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.slug = ?) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 1
Parameters:
[
  "jpk-cit-w-praktyce-jak-uniknac-bledow-w-raportowaniu"
]
2 0.96 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?
Parameters:
[
  b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
3 94.32 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = ? AND a1_.id IN (?) AND a0_.id <> ?) AND a0_.type IN ('audio', 'download', 'text', 'video') ORDER BY a0_.created_at DESC LIMIT 6
Parameters:
[
  1
  b"\x01žÊîË~›\x1DtšœÏ~"
  b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
4 0.74 ms
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM article_image t0 WHERE t0.id = ?
Parameters:
[
  b"\x01žÊ‘Ï\x0Fq¤¤Ü»w<Â\x03ï"
]
5 1.07 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.footer_text AS footer_text_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.seo_keywords AS seo_keywords_5, p0_.seo_meta_title AS seo_meta_title_6, p0_.seo_meta_description AS seo_meta_description_7, p0_.seo_open_graph_title AS seo_open_graph_title_8, p0_.seo_open_graph_description AS seo_open_graph_description_9, p0_.seo_open_graph_image_url AS seo_open_graph_image_url_10, p0_.seo_is_no_index AS seo_is_no_index_11, p0_.social_facebook AS social_facebook_12, p0_.social_twitter AS social_twitter_13, p0_.social_instagram AS social_instagram_14, p0_.social_linked_in AS social_linked_in_15, p0_.social_youtube AS social_youtube_16, p0_.login_settings_google_id AS login_settings_google_id_17, p0_.login_settings_google_secret AS login_settings_google_secret_18, p0_.created_by_id AS created_by_id_19, p0_.updated_by_id AS updated_by_id_20 FROM portal_settings p0_ LIMIT 1
Parameters:
[]
6 1.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.portal_settings_id AS portal_settings_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM footer_link t0 WHERE t0.portal_settings_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
7 1.42 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC
Parameters:
[]
8 0.75 ms
SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1
Parameters:
[]
9 0.61 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01š^/°-y‹ŽK•/7¼F"
]
10 0.54 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01œûÁ"\vuä¶\x18íyw\x0E`"
]
11 0.54 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01‘[ÐÏ{\x04·jÖþÖÿ "
]
12 0.75 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žºï°\x0EzÏ“\r®9;õ™\"
]
13 0.77 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊ-¡¬q‘­Ú\x0F(\x06„ŒÉ"
]
14 0.61 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊîË~›\x1DtšœÏ~"
]
15 0.86 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊ¦ç(qn¿õv¬ÿH¦ù"
]
16 1.31 ms
SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1
Parameters:
[]
17 2.22 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01š^/°-y‹ŽK•/7¼F"
]
18 0.64 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01œûÁ"\vuä¶\x18íyw\x0E`"
]
19 0.58 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01‘[ÐÏ{\x04·jÖþÖÿ "
]
20 0.86 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žºï°\x0EzÏ“\r®9;õ™\"
]
21 0.61 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊ-¡¬q‘­Ú\x0F(\x06„ŒÉ"
]
22 0.78 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊîË~›\x1DtšœÏ~"
]
23 0.70 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  b"\x01žÊ¦ç(qn¿õv¬ÿH¦ù"
]
24 0.74 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.profession AS profession_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.avatar_id AS avatar_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM author t0 INNER JOIN article_author ON t0.id = article_author.author_id WHERE article_author.article_id = ?
Parameters:
[
  b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
25 2.14 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?
Parameters:
[
  b"\x01žÊ¥\x07cz¢¶\vºÚ>\x02"
]
26 0.74 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?
Parameters:
[
  b"\x01žÊ™¨øt(¨âd\x1F\e†£ß"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
gos doctrine.dbal.gos_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
gos doctrine.orm.gos_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\KnowledgeBase\Category\Category 7
App\Entity\User\User 4
App\Entity\KnowledgeBase\Article\Article 3
App\Entity\KnowledgeBase\Article\ArticleImage 3
App\Entity\PortalSettings\FooterLink\FooterLink 2
App\Entity\PortalSettings\PortalSettings 1
App\Entity\Author\Author 1

gos entity manager

Class Amount of managed objects