GET https://vazektomia.tomas-levcik.sk/forum/pred-operaciou/docasna-vazektomia/

Query Metrics

8 Database Queries
8 Different statements
11.03 ms Query time
0 Invalid entities
29 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.33 ms
(21.14%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_9 FROM (SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.topic_id AS topic_id_2, f0_.username AS username_3, f0_.reply_to AS reply_to_4, f0_.content AS content_5, f0_.status AS status_6, f0_.is_moderator AS is_moderator_7, f0_.creating_comment AS creating_comment_8, f0_.created_at AS created_at_9, f0_.topic_path AS topic_path_10 FROM forum_comments_view f0_ WHERE f0_.topic_path = ? AND f0_.status = 1 AND f0_.reply_to = 0 AND f0_.username NOT IN (?, ?)) dctrn_result_inner ORDER BY created_at_9 DESC) dctrn_result LIMIT 10
Parameters:
[
  "docasna-vazektomia"
  "Igor"
  "hah"
]
2.06 ms
(18.68%)
1
SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.topic_id AS topic_id_2, f0_.username AS username_3, f0_.reply_to AS reply_to_4, f0_.content AS content_5, f0_.status AS status_6, f0_.is_moderator AS is_moderator_7, f0_.creating_comment AS creating_comment_8, f0_.created_at AS created_at_9, f0_.topic_path AS topic_path_10 FROM forum_comments_view f0_ WHERE f0_.topic_path = ? AND f0_.status = 1 AND f0_.reply_to <> 0 AND f0_.username NOT IN (?, ?) ORDER BY f0_.created_at ASC
Parameters:
[
  "docasna-vazektomia"
  "Igor"
  "hah"
]
1.96 ms
(17.77%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.topic_id AS topic_id_2, f0_.username AS username_3, f0_.reply_to AS reply_to_4, f0_.content AS content_5, f0_.status AS status_6, f0_.is_moderator AS is_moderator_7, f0_.creating_comment AS creating_comment_8, f0_.created_at AS created_at_9, f0_.topic_path AS topic_path_10 FROM forum_comments_view f0_ WHERE f0_.topic_path = ? AND f0_.status = 1 AND f0_.reply_to = 0 AND f0_.username NOT IN (?, ?) ORDER BY f0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "docasna-vazektomia"
  "Igor"
  "hah"
]
1.06 ms
(9.63%)
1
SELECT t0.id AS id_1, t0.theme_id AS theme_id_2, t0.title AS title_3, t0.path AS path_4, t0.username AS username_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.theme_path AS theme_path_8, t0.count AS count_9, t0.last_insert AS last_insert_10 FROM forum_topics_view t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "docasna-vazektomia"
]
1.05 ms
(9.54%)
1
SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = ? AND p0_.level >= 2 AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?) ORDER BY p0_.position ASC
Parameters:
[
  "sk"
  "%2%"
  "%2%"
]
0.93 ms
(8.41%)
1
SELECT f0_.id AS id_0, f0_.theme_id AS theme_id_1, f0_.topic_id AS topic_id_2, f0_.username AS username_3, f0_.reply_to AS reply_to_4, f0_.content AS content_5, f0_.status AS status_6, f0_.is_moderator AS is_moderator_7, f0_.creating_comment AS creating_comment_8, f0_.created_at AS created_at_9, f0_.topic_path AS topic_path_10 FROM forum_comments_view f0_ WHERE f0_.topic_path = ? AND f0_.status = 1 AND f0_.reply_to = 0 AND f0_.username NOT IN (?, ?) AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.created_at DESC
Parameters:
[
  "docasna-vazektomia"
  "Igor"
  "hah"
  580
  578
  568
  542
  521
  390
  373
  342
  261
  220
]
0.84 ms
(7.66%)
1
SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.web_id AS web_id_2, p0_.lang AS lang_3, p0_.url AS url_4, p0_.path AS path_5, p0_.canonical_url AS canonical_url_6, p0_.title AS title_7, p0_.meta_description AS meta_description_8, p0_.nodes AS nodes_9, p0_.level AS level_10, p0_.type AS type_11, p0_.position AS position_12, p0_.has_subpage AS has_subpage_13, p0_.has_sidebar AS has_sidebar_14, p0_.og_title AS og_title_15, p0_.og_description AS og_description_16, p0_.og_site_name AS og_site_name_17, p0_.og_url AS og_url_18, p0_.og_img AS og_img_19, p0_.tw_title AS tw_title_20, p0_.tw_description AS tw_description_21, p0_.tw_image AS tw_image_22, p0_.tw_card AS tw_card_23, p0_.tw_alt_image AS tw_alt_image_24, p0_.status AS status_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.created_by AS created_by_28 FROM pages p0_ WHERE p0_.lang = ? AND p0_.level = 1 AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?) ORDER BY p0_.position ASC
Parameters:
[
  "sk"
  "%2%"
  "%2%"
]
0.79 ms
(7.17%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.status AS status_2 FROM forum_blacklist f0_ WHERE f0_.status = 1
Parameters:
[]

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\ForumCommentsView 26
App\Entity\ForumBlacklist 2
App\Entity\ForumTopicsView 1

Entities Mapping

Class Mapping errors
App\Entity\ForumBlacklist No errors.
App\Entity\ForumCommentsView No errors.
App\Entity\ForumTopicsView No errors.
App\Entity\Pages No errors.
App\Entity\PagesContent No errors.