GET http://delk.wiemo.pl/komunikaty/przerwa-w-dostawie-wody

Query Metrics

131 Database Queries
64 Different statements
173.50 ms Query time
0 Invalid entities
47 Managed entities

Grouped Statements

Show all queries

Time Count Info
23.08 ms
(13.31%)
4
SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?)
Parameters:
[
  35
]
21.64 ms
(12.48%)
8
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "delk"
  "delk"
  "url_alias"
]
15.76 ms
(9.08%)
14
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.entity_id AS entity_id_3, t0.title AS title_4, t0.description AS description_5, t0.keywords AS keywords_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.og_image_url AS og_image_url_9, t0.canonical_override AS canonical_override_10, t0.robots_noindex AS robots_noindex_11, t0.robots_nofollow AS robots_nofollow_12, t0.overrides AS overrides_13, t0.updated_at AS updated_at_14 FROM seo_metatag_entry t0 WHERE t0.kind = ? AND t0.entity_id = ? LIMIT 1
Parameters:
[
  "content"
  47
]
10.14 ms
(5.85%)
9
SELECT DATABASE()
Parameters:
[]
9.41 ms
(5.43%)
3
SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?)
Parameters:
[
  137
  141
  139
]
8.16 ms
(4.70%)
2
SELECT * FROM ee_view WHERE id = ?
Parameters:
[
  39
]
7.85 ms
(4.52%)
6
SELECT fu.id AS usage_id, f.*, fu.name AS usage_name, fu.description AS usage_description, fu.alt AS usage_alt, fu.focal AS usage_focal, fu.instance_id AS usage_instance_id, fi.name AS instance_name, fi.context AS instance_context, fi.author_id AS instance_author_id, fi.focal AS instance_focal FROM entity_file_usage fu JOIN entity_file f ON f.id = fu.file_id LEFT JOIN entity_file_instance fi ON fi.id = fu.instance_id WHERE fu.id = ?
Parameters:
[
  46
]
7.22 ms
(4.16%)
10
SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0 WHERE t0.parent_id = ? AND t0.mode = ?
Parameters:
[
  1
  "alias"
]
3.69 ms
(2.12%)
2
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
Parameters:
[
  "ikona"
  14
]
3.66 ms
(2.11%)
2
SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0
Parameters:
[]
3.51 ms
(2.02%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "delk"
]
3.39 ms
(1.95%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slot AS slot_2, s0_.code AS code_3, s0_.paths AS paths_4, s0_.paths_mode AS paths_mode_5, s0_.position AS position_6, s0_.status AS status_7, s0_.site_id AS site_id_8 FROM site_injection s0_ WHERE s0_.site_id = ? AND (s0_.status & 1) = 1 ORDER BY s0_.position ASC, s0_.id ASC
Parameters:
[
  1
]
3.30 ms
(1.90%)
1
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.enabled = 1 ORDER BY l0_.weight ASC, l0_.code ASC
Parameters:
[]
2.86 ms
(1.65%)
1
SELECT * FROM entity_content_translation WHERE entity_id IN (?)
Parameters:
[
  24
]
2.48 ms
(1.43%)
1
SELECT * FROM entity_file_type WHERE id = ?
Parameters:
[
  1
]
2.44 ms
(1.41%)
1
SELECT * FROM entity_file_type
Parameters:
[]
2.40 ms
(1.39%)
6
SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0 INNER JOIN navigation_site ON t0.id = navigation_site.site_id WHERE navigation_site.navigation_id = ?
Parameters:
[
  3
]
2.35 ms
(1.35%)
1
SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC
Parameters:
[]
2.23 ms
(1.28%)
1
SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  142
  20
  21
  22
  23
  24
]
2.08 ms
(1.20%)
1
SELECT e.id FROM entity_content e WHERE e.type_id IN (?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND e.site_id = ? ORDER BY e.id DESC
Parameters:
[
  1
  1
]
1.98 ms
(1.14%)
1
SELECT * FROM ee_view ORDER BY name ASC
Parameters:
[]
1.96 ms
(1.13%)
1
SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY id ASC
Parameters:
[
  "ee"
  "content:47"
  "content:36"
  "content:35"
  "content:11"
  "content:10"
  "content:9"
  "content:8"
  "content:7"
  "content:6"
  "content:5"
  "content:4"
  "content:3"
  "content:2"
  "content:1"
]
1.59 ms
(0.92%)
2
SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?)
Parameters:
[
  34
  136
]
1.52 ms
(0.87%)
2
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  14
  "default"
]
1.35 ms
(0.78%)
2
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  14
  5
]
1.27 ms
(0.73%)
1
SELECT * FROM entity_content_data_text WHERE (entity_id IN (?)) AND (field_id IN (?, ?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  41
  42
  43
  24
]
1.25 ms
(0.72%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.19 ms
(0.69%)
2
SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1
Parameters:
[
  1
  "/komunikaty/przerwa-w-dostawie-wody"
]
1.17 ms
(0.68%)
3
SELECT def_hash FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
1.15 ms
(0.66%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?) ORDER BY id ASC
Parameters:
[
  "ee"
  "category:32"
  "category:20"
  "category:19"
]
1.10 ms
(0.64%)
2
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
Parameters:
[
  14
]
1.03 ms
(0.59%)
2
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  14
  5
]
0.96 ms
(0.55%)
1
SELECT * FROM entity_content_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  4
  4
]
0.94 ms
(0.54%)
1
SELECT * FROM entity_content_data_geolocation WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  49
  24
]
0.90 ms
(0.52%)
1
SELECT * FROM entity_content_data_link WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  44
  24
]
0.84 ms
(0.49%)
1
SELECT * FROM entity_content WHERE id IN (?)
Parameters:
[
  24
]
0.75 ms
(0.43%)
1
SELECT * FROM entity_content_schema
Parameters:
[]
0.73 ms
(0.42%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
Parameters:
[
  "ee"
  "content:24"
]
0.73 ms
(0.42%)
2
SELECT definition FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
0.72 ms
(0.41%)
1
SELECT e.id FROM entity_category e WHERE e.type_id IN (?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND e.site_id = ? ORDER BY e.id DESC
Parameters:
[
  14
  1
]
0.72 ms
(0.41%)
1
SELECT * FROM entity_content_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  4
  4
]
0.71 ms
(0.41%)
1
SELECT s0_.id AS id_0, s0_.theme AS theme_1, s0_.name AS name_2, s0_.json AS json_3, s0_.status AS status_4, s0_.site_id AS site_id_5 FROM site_theme s0_ WHERE s0_.site_id = ? AND (s0_.status & 2) = 2 LIMIT 1
Parameters:
[
  1
]
0.71 ms
(0.41%)
1
SELECT * FROM entity_content WHERE id = ?
Parameters:
[
  24
]
0.70 ms
(0.40%)
1
SELECT * FROM entity_content_type
Parameters:
[]
0.68 ms
(0.39%)
1
SELECT * FROM entity_content_data_checkbox WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  47
  24
]
0.66 ms
(0.38%)
1
SELECT * FROM entity_content_data_reference WHERE (entity_id IN (?)) AND (field_id IN (?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  50
  51
  24
]
0.66 ms
(0.38%)
1
SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC
Parameters:
[]
0.58 ms
(0.33%)
1
SELECT * FROM entity_content_data_file WHERE (entity_id IN (?)) AND (field_id IN (?, ?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC
Parameters:
[
  24
  45
  46
  48
  24
]
0.57 ms
(0.33%)
1
SELECT * FROM entity_category_schema
Parameters:
[]
0.56 ms
(0.32%)
1
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "ikona"
]
0.54 ms
(0.31%)
1
SELECT * FROM entity_file_schema
Parameters:
[]
0.53 ms
(0.31%)
1
SELECT * FROM entity_category_type
Parameters:
[]
0.51 ms
(0.29%)
1
SELECT entity_id, counter FROM entity_view_counter WHERE kind = ? AND entity_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "content"
  47
  36
  35
  11
  10
  9
  8
  7
  6
  5
  4
  3
  2
  1
]
0.48 ms
(0.28%)
1
SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?, ?)
Parameters:
[
  33
  32
  134
  135
]
0.47 ms
(0.27%)
1
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "full"
]
0.47 ms
(0.27%)
1
SELECT * FROM entity_content_translation WHERE entity_id = ?
Parameters:
[
  24
]
0.44 ms
(0.26%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id IS NULL
Parameters:
[]
0.44 ms
(0.25%)
1
SELECT id, status_id FROM entity_content_revision WHERE id IN (?) AND status_id IS NOT NULL
Parameters:
[
  24
]
0.43 ms
(0.25%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id = ?
Parameters:
[
  4
]
0.40 ms
(0.23%)
1
SELECT id FROM entity_content_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  4
  "default"
]
0.40 ms
(0.23%)
1
SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL
Parameters:
[]
0.39 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation t0
Parameters:
[]
0.35 ms
(0.20%)
1
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id = ?
Parameters:
[
  "full"
  4
]
0.30 ms
(0.17%)
1
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.is_default = 1 LIMIT 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\Theme\Block 27
App\Entity\Site\Site 10
App\Entity\Navigation\Navigation 8
App\Entity\Language 1
App\Entity\Theme\SiteTheme 1