Query Metrics

8 Database Queries
8 Different statements
10.79 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 0.80 ms
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:
[]
2 1.90 ms
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:
[
  "o-vasektomii-s-priatelmi"
  "Igor"
  "hah"
]
3 1.03 ms
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:
[
  "o-vasektomii-s-priatelmi"
]
4 2.36 ms
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:
[
  "o-vasektomii-s-priatelmi"
  "Igor"
  "hah"
]
5 0.95 ms
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%"
]
6 0.70 ms
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%"
]
7 2.29 ms
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 OFFSET 30
Parameters:
[
  "o-vasektomii-s-priatelmi"
  "Igor"
  "hah"
]
8 0.75 ms
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:
[
  "o-vasektomii-s-priatelmi"
  "Igor"
  "hah"
  237
  236
  233
  214
  205
  175
  174
  98
  81
  80
]

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 37
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.