Query Metrics

24 Database Queries
8 Different statements
51.87 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 14.05 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:
[
  "nieprawidlowe-wzorce-ruchowe-niemowlaka-jak-rozpoznac-objawy-i-skutki-wczesnej-nieprawidlowej-postawy"
]
2 1.01 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žÊ3Öô\x7FŠƒ]¨4è\x07pL"
]
3 22.26 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žÊ-¡¬q‘­Ú\x0F(\x06„ŒÉ"
  b"\x01žÊ3Öô\x7FŠƒ]¨4è\x07pL"
]
4 0.69 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žÊ;A\x1Dy¤‹Â(Öj^1À"
]
5 1.34 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:
[]
6 1.02 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:
[]
7 0.93 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"
]
8 0.65 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`"
]
9 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‘[ÐÏ{\x04·jÖþÖÿ "
]
10 0.63 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;õ™\"
]
11 0.59 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„ŒÉ"
]
12 0.63 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šœÏ~"
]
13 0.59 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¦ù"
]
14 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:
[]
15 0.63 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"
]
16 0.57 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`"
]
17 0.57 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ÖþÖÿ "
]
18 0.56 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;õ™\"
]
19 0.56 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„ŒÉ"
]
20 0.57 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šœÏ~"
]
21 0.55 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¦ù"
]
22 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.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žÊ3Öô\x7FŠƒ]¨4è\x07pL"
]
23 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žÊ<\x1Aâqü¦‘‘³Ü:G/"
]
24 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 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?
Parameters:
[
  b"\x01žÊ\x1F\x07Öw¦§…³Ò<\x00"
]

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\KnowledgeBase\Article\Article 3
App\Entity\KnowledgeBase\Article\ArticleImage 3
App\Entity\User\User 3
App\Entity\Author\Author 1

gos entity manager

Class Amount of managed objects