GET http://delk.wiemo.pl/komunikaty/ostrzezenie-upaly

Query Metrics

126 Database Queries
69 Different statements
76.50 ms Query time
0 Invalid entities
43 Managed entities

Grouped Statements

Show all queries

Time Count Info
17.79 ms
(23.25%)
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"
]
3.98 ms
(5.20%)
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.50 ms
(4.58%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "delk"
]
2.39 ms
(3.13%)
4
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.35 ms
(3.07%)
9
SELECT DATABASE()
Parameters:
[]
1.63 ms
(2.13%)
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.60 ms
(2.09%)
2
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:
[
  27
  41
  42
  43
  58
]
1.45 ms
(1.90%)
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.44 ms
(1.89%)
2
SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1
Parameters:
[
  1
  "/komunikaty/ostrzezenie-upaly"
]
1.43 ms
(1.87%)
4
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.39 ms
(1.82%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?) ORDER BY id ASC
Parameters:
[
  "ee"
  "category:32"
  "category:20"
  "category:19"
]
1.30 ms
(1.69%)
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:
[]
1.22 ms
(1.59%)
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.11 ms
(1.45%)
2
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  14
  5
]
1.04 ms
(1.35%)
2
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:
[
  27
  44
  58
]
1.02 ms
(1.33%)
1
SELECT * FROM ee_view ORDER BY name ASC
Parameters:
[]
0.99 ms
(1.29%)
2
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:
[
  27
  45
  46
  48
  58
]
0.96 ms
(1.26%)
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
]
0.94 ms
(1.23%)
2
SELECT * FROM entity_content WHERE id IN (?)
Parameters:
[
  27
]
0.93 ms
(1.21%)
2
SELECT id, status_id FROM entity_content_revision WHERE id IN (?) AND status_id IS NOT NULL
Parameters:
[
  58
]
0.90 ms
(1.18%)
2
SELECT * FROM ee_view WHERE id = ?
Parameters:
[
  39
]
0.90 ms
(1.18%)
2
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:
[
  27
  47
  58
]
0.88 ms
(1.15%)
2
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
Parameters:
[
  "ee"
  "content:27"
]
0.86 ms
(1.13%)
2
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:
[
  27
  50
  51
  58
]
0.85 ms
(1.11%)
2
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:
[
  27
  49
  58
]
0.84 ms
(1.10%)
2
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  14
  5
]
0.84 ms
(1.10%)
2
SELECT * FROM entity_content_translation WHERE entity_id IN (?)
Parameters:
[
  27
]
0.82 ms
(1.07%)
1
SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY id ASC
Parameters:
[
  "ee"
  "content:47"
  "content:36"
  "content:35"
  "content:10"
  "content:9"
  "content:7"
  "content:6"
  "content:5"
  "content:4"
  "content:3"
]
0.81 ms
(1.06%)
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.76 ms
(1.00%)
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:
[
  66
]
0.76 ms
(1.00%)
2
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  14
  "default"
]
0.72 ms
(0.94%)
1
SELECT * FROM entity_content WHERE id = ?
Parameters:
[
  27
]
0.69 ms
(0.91%)
2
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
Parameters:
[
  14
]
0.64 ms
(0.84%)
2
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
Parameters:
[
  "ikona"
  14
]
0.64 ms
(0.83%)
1
SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC
Parameters:
[]
0.63 ms
(0.83%)
1
SELECT * FROM entity_file_data_text WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IS NULL) ORDER BY delta ASC, id ASC
Parameters:
[
  31
  2
]
0.63 ms
(0.82%)
2
SELECT def_hash FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
0.62 ms
(0.81%)
1
SELECT * FROM entity_file_data_reference WHERE (entity_id IN (?)) AND (field_id IN (?, ?)) AND (rev_id IS NULL) ORDER BY delta ASC, id ASC
Parameters:
[
  31
  1
  3
]
0.61 ms
(0.80%)
1
SELECT * FROM entity_category_data_text WHERE (entity_id IN (?)) AND (field_id IN (?, ?, ?)) AND (rev_id IS NULL) ORDER BY delta ASC, id ASC
Parameters:
[
  4
  14
  15
  16
]
0.61 ms
(0.80%)
1
SELECT * FROM entity_content_schema
Parameters:
[]
0.59 ms
(0.77%)
2
SELECT definition FROM ee_file_style WHERE id = ?
Parameters:
[
  1
]
0.58 ms
(0.76%)
1
SELECT * FROM entity_category_data_file WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IS NULL) ORDER BY delta ASC, id ASC
Parameters:
[
  4
  52
]
0.58 ms
(0.76%)
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.58 ms
(0.76%)
1
SELECT * FROM entity_content_meta_display WHERE type_id = ? AND view_mode_id = ?
Parameters:
[
  4
  4
]
0.54 ms
(0.70%)
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.53 ms
(0.70%)
1
SELECT * FROM entity_category_type
Parameters:
[]
0.52 ms
(0.68%)
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.52 ms
(0.68%)
1
SELECT * FROM entity_category_translation WHERE entity_id IN (?)
Parameters:
[
  4
]
0.51 ms
(0.67%)
1
SELECT * FROM entity_file_translation WHERE entity_id IN (?)
Parameters:
[
  31
]
0.51 ms
(0.66%)
1
SELECT * FROM entity_content_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
Parameters:
[
  4
  4
]
0.46 ms
(0.60%)
1
SELECT * FROM entity_file WHERE id IN (?)
Parameters:
[
  31
]
0.46 ms
(0.60%)
1
SELECT * FROM entity_content_type
Parameters:
[]
0.45 ms
(0.59%)
1
SELECT * FROM entity_category_schema
Parameters:
[]
0.45 ms
(0.58%)
1
SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC
Parameters:
[]
0.45 ms
(0.58%)
1
SELECT * FROM entity_category WHERE id IN (?)
Parameters:
[
  4
]
0.44 ms
(0.58%)
1
SELECT * FROM entity_content_translation WHERE entity_id = ?
Parameters:
[
  27
]
0.43 ms
(0.57%)
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.43 ms
(0.56%)
1
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "full"
]
0.40 ms
(0.52%)
1
SELECT * FROM entity_file_type
Parameters:
[]
0.39 ms
(0.51%)
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.39 ms
(0.51%)
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.39 ms
(0.51%)
1
SELECT * FROM entity_file_schema
Parameters:
[]
0.38 ms
(0.50%)
1
SELECT id FROM entity_content_view_mode WHERE type_id = ? AND name = ?
Parameters:
[
  4
  "default"
]
0.38 ms
(0.50%)
1
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL
Parameters:
[
  "ikona"
]
0.35 ms
(0.46%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id IS NULL
Parameters:
[]
0.34 ms
(0.45%)
1
SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL
Parameters:
[]
0.34 ms
(0.44%)
1
SELECT id, name FROM entity_content_view_mode WHERE type_id = ?
Parameters:
[
  4
]
0.32 ms
(0.42%)
1
SELECT * FROM entity_file_type WHERE id = ?
Parameters:
[
  1
]
0.31 ms
(0.41%)
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 4
App\Entity\Language 1
App\Entity\Theme\SiteTheme 1