GET http://delk.wiemo.pl/komunikaty/nabor-wnioskow-wymiana-piecow

Query Metrics

132 Database Queries
65 Different statements
83.06 ms Query time
0 Invalid entities
47 Managed entities

Grouped Statements

Show all queries

Time Count Info
17.81 ms
(21.44%)
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"
]
7.70 ms
(9.27%)
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"
]
5.13 ms
(6.17%)
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
]
3.77 ms
(4.54%)
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"
]
3.28 ms
(3.95%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "delk"
]
3.25 ms
(3.91%)
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
]
3.00 ms
(3.61%)
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
]
2.28 ms
(2.74%)
9
SELECT DATABASE()
Parameters:
[]
2.00 ms
(2.40%)
1
SELECT * FROM entity_category_type
Parameters:
[]
1.72 ms
(2.07%)
1
SELECT * FROM entity_category_schema
Parameters:
[]
1.55 ms
(1.87%)
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
]
1.22 ms
(1.47%)
2
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  14
  5
]
1.18 ms
(1.42%)
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.13 ms
(1.36%)
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:
[]
1.12 ms
(1.35%)
2
SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1
Parameters:
[
  1
  "/komunikaty/nabor-wnioskow-wymiana-piecow"
]
1.09 ms
(1.31%)
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
]
1.08 ms
(1.30%)
2
SELECT * FROM ee_view WHERE id = ?
Parameters:
[
  39
]
0.98 ms
(1.18%)
1
SELECT * FROM ee_view ORDER BY name ASC
Parameters:
[]
0.91 ms
(1.10%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?) ORDER BY id ASC
Parameters:
[
  "ee"
  "category:32"
  "category:20"
  "category:19"
]
0.88 ms
(1.06%)
3
SELECT def_hash FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
0.79 ms
(0.95%)
2
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  14
  5
]
0.75 ms
(0.91%)
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
]
0.75 ms
(0.91%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
Parameters:
[
  "ee"
  "content:26"
]
0.73 ms
(0.87%)
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
]
0.70 ms
(0.84%)
1
SELECT * FROM entity_content WHERE id = ?
Parameters:
[
  26
]
0.70 ms
(0.84%)
2
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  14
  "default"
]
0.69 ms
(0.84%)
1
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 IN (?)
Parameters:
[
  68
]
0.66 ms
(0.79%)
2
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
Parameters:
[
  14
]
0.65 ms
(0.78%)
1
SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC
Parameters:
[]
0.62 ms
(0.74%)
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:
[
  26
  41
  42
  43
  60
]
0.59 ms
(0.71%)
2
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
Parameters:
[
  "ikona"
  14
]
0.59 ms
(0.71%)
2
SELECT definition FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
0.59 ms
(0.71%)
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:
[]
0.57 ms
(0.69%)
1
SELECT * FROM entity_content_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  4
  4
]
0.57 ms
(0.68%)
1
SELECT * FROM entity_content_schema
Parameters:
[]
0.52 ms
(0.62%)
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
]
0.50 ms
(0.60%)
1
SELECT * FROM entity_content_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  4
  4
]
0.48 ms
(0.58%)
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.46 ms
(0.56%)
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:
[
  26
  47
  60
]
0.46 ms
(0.55%)
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.45 ms
(0.54%)
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.45 ms
(0.54%)
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.44 ms
(0.53%)
1
SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC
Parameters:
[]
0.44 ms
(0.53%)
1
SELECT id FROM entity_content_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  4
  "default"
]
0.44 ms
(0.53%)
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:
[
  26
  50
  51
  60
]
0.43 ms
(0.52%)
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.43 ms
(0.52%)
1
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "ikona"
]
0.43 ms
(0.52%)
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:
[
  26
  45
  46
  48
  60
]
0.43 ms
(0.51%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id IS NULL
Parameters:
[]
0.43 ms
(0.51%)
1
SELECT * FROM entity_content_type
Parameters:
[]
0.42 ms
(0.51%)
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:
[
  26
  44
  60
]
0.42 ms
(0.50%)
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
]
0.41 ms
(0.50%)
1
SELECT * FROM entity_content_translation WHERE entity_id = ?
Parameters:
[
  26
]
0.39 ms
(0.47%)
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:
[
  26
  49
  60
]
0.37 ms
(0.45%)
1
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "full"
]
0.36 ms
(0.44%)
1
SELECT * FROM entity_content WHERE id IN (?)
Parameters:
[
  26
]
0.36 ms
(0.44%)
1
SELECT id, status_id FROM entity_content_revision WHERE id IN (?) AND status_id IS NOT NULL
Parameters:
[
  60
]
0.35 ms
(0.42%)
1
SELECT * FROM entity_file_type
Parameters:
[]
0.33 ms
(0.40%)
1
SELECT * FROM entity_file_schema
Parameters:
[]
0.32 ms
(0.39%)
1
SELECT * FROM entity_file_type WHERE id = ?
Parameters:
[
  1
]
0.32 ms
(0.38%)
1
SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL
Parameters:
[]
0.31 ms
(0.37%)
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:
[]
0.30 ms
(0.36%)
1
SELECT * FROM entity_content_translation WHERE entity_id IN (?)
Parameters:
[
  26
]
0.30 ms
(0.36%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id = ?
Parameters:
[
  4
]
0.28 ms
(0.34%)
1
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id = ?
Parameters:
[
  "full"
  4
]

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