Query Metrics

8 Database Queries
6 Different statements
5.17 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 1.53 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_.path = ? AND p0_.status = 1 AND (p0_.web_id = ? OR p0_.web_id LIKE ?)
Parameters:
[
  "pooperacna-starostlivost/"
  "%2%"
  "%2%"
]
2 0.44 ms
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.content AS content_3, t0.has_gallery AS has_gallery_4, t0.page_id AS page_id_5 FROM pages_content t0 WHERE t0.page_id = ?
Parameters:
[
  138
]
3 0.72 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%"
]
4 0.65 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%"
]
5 0.81 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_.og_title AS og_title_14, p0_.og_description AS og_description_15, p0_.og_site_name AS og_site_name_16, p0_.og_url AS og_url_17, p0_.og_img AS og_img_18, p0_.tw_title AS tw_title_19, p0_.tw_description AS tw_description_20, p0_.tw_image AS tw_image_21, p0_.tw_card AS tw_card_22, p0_.tw_alt_image AS tw_alt_image_23, p0_.status AS status_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.created_by AS created_by_27 FROM pages p0_ WHERE p0_.type = 4 AND p0_.status = 1 ORDER BY p0_.created_at DESC LIMIT 3
Parameters:
[]
6 0.45 ms
SELECT t0.id AS id_1, t0.news_id AS news_id_2, t0.short_text AS short_text_3, t0.content AS content_4, t0.title_image AS title_image_5, t0.news_id AS news_id_6 FROM news_content t0 WHERE t0.news_id = ?
Parameters:
[
  103
]
7 0.29 ms
SELECT t0.id AS id_1, t0.news_id AS news_id_2, t0.short_text AS short_text_3, t0.content AS content_4, t0.title_image AS title_image_5, t0.news_id AS news_id_6 FROM news_content t0 WHERE t0.news_id = ?
Parameters:
[
  140
]
8 0.27 ms
SELECT t0.id AS id_1, t0.news_id AS news_id_2, t0.short_text AS short_text_3, t0.content AS content_4, t0.title_image AS title_image_5, t0.news_id AS news_id_6 FROM news_content t0 WHERE t0.news_id = ?
Parameters:
[
  141
]

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\News 3
App\Entity\NewsContent 3
App\Entity\Pages 1
App\Entity\PagesContent 1

Entities Mapping

Class Mapping errors
App\Entity\Pages No errors.
App\Entity\PagesContent No errors.
App\Entity\News No errors.
App\Entity\NewsContent No errors.