Symfony Profiler

Query Metrics

124 Database Queries
48 Different statements
257.73 ms Query time
0 Invalid entities
17 Managed entities
Queries


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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
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
SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1
SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1
SELECT * FROM ee_view WHERE slug = ?
SELECT * FROM entity_content_type
SELECT t0_.id AS id_0, t0_.options_patch AS options_patch_1, t0_.advanced_options_patch AS advanced_options_patch_2, t0_.version AS version_3, t0_.inherited_default AS inherited_default_4, t0_.explicit_active AS explicit_active_5, t0_.created_at AS created_at_6, t0_.changed_at AS changed_at_7, t0_.site_id AS site_id_8, t0_.pinned_default_site_theme_id AS pinned_default_site_theme_id_9 FROM theme_site_delta t0_ WHERE t0_.site_id = ?
SELECT t0_.id AS id_0, t0_.options_patch AS options_patch_1, t0_.advanced_options_patch AS advanced_options_patch_2, t0_.version AS version_3, t0_.inherited_default AS inherited_default_4, t0_.explicit_active AS explicit_active_5, t0_.created_at AS created_at_6, t0_.changed_at AS changed_at_7, t0_.site_id AS site_id_8, t0_.pinned_default_site_theme_id AS pinned_default_site_theme_id_9 FROM theme_site_delta t0_ WHERE t0_.site_id = ?
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.name AS name_3, t0.json AS json_4, t0.status AS status_5, t0.site_id AS site_id_6 FROM site_theme t0 WHERE t0.id = ?
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
SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT DATABASE()
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
SELECT DATABASE()
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
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 = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT def_hash FROM ee_file_style WHERE id = ?
SELECT definition FROM ee_file_style WHERE id = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT * FROM ee_view WHERE id = ?
SELECT * FROM entity_category_type
SELECT * FROM entity_category_schema
SELECT DATABASE()
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
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
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
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 = ?
SELECT * FROM entity_file_type
SELECT * FROM entity_file_schema
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
SELECT DATABASE()
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
SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
SELECT * FROM ee_view ORDER BY name ASC
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
SELECT * FROM entity_file_type WHERE id = ?
SELECT def_hash FROM ee_file_style WHERE id = ?
SELECT definition FROM ee_file_style WHERE id = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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 = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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 = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT * FROM ee_view WHERE id = ?
SELECT DATABASE()
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
SELECT COUNT(*) 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 = ?
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 LIMIT 5
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
SELECT * FROM entity_content_schema
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 = ?
SELECT * FROM url_alias WHERE module = ? AND target IN (?) ORDER BY id ASC
SELECT id FROM entity_content_view_mode WHERE type_id = ? AND name = ?
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id = ?
SELECT * FROM entity_content_view_mode WHERE name = ? AND type_id IS NULL
SELECT id, name FROM entity_content_view_mode WHERE type_id = ?
SELECT DATABASE()
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
SELECT id, name FROM entity_content_view_mode WHERE type_id IS NULL
SELECT * FROM entity_content_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
SELECT * FROM entity_content_meta_display WHERE type_id = ? AND view_mode_id = ?
SELECT def_hash FROM ee_file_style WHERE id = ?
SELECT definition FROM ee_file_style WHERE id = ?
SELECT DATABASE()
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
SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT * FROM ee_view WHERE id = ?
SELECT DISTINCT e.id FROM entity_category e LEFT JOIN entity_content_data_reference rd1 ON rd1.target_kind = ? AND rd1.target_id = e.id AND rd1.field_id IN (?, ?, ?, ?) LEFT JOIN entity_content rt2 ON rt2.id = rd1.entity_id AND rd1.rev_id <=> rt2.rev_id WHERE e.type_id IN (?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND EXISTS (SELECT 1 FROM entity_content_data_reference d3 JOIN entity_content n4 ON d3.entity_id = n4.id WHERE d3.target_kind = ? AND d3.target_id = e.id AND d3.field_id IN (?, ?, ?, ?) AND d3.rev_id <=> n4.rev_id AND NOT (n4.flags & 1) = 1 AND NOT (n4.flags & 2) = 2 AND n4.site_id = ?) ORDER BY (SELECT COUNT(DISTINCT aad.entity_id) FROM entity_content_data_reference aad WHERE aad.target_kind = ? AND aad.target_id = e.id AND aad.field_id IN (?, ?, ?, ?)) DESC, (SELECT d.value FROM entity_category_data_text d WHERE d.entity_id = e.id AND d.field_id IN (?) AND d.rev_id IS NULL AND d.delta = 0 LIMIT 1) ASC, e.id DESC
SELECT DISTINCT e.id AS entity_id, (SELECT COUNT(DISTINCT aad.entity_id) FROM entity_content_data_reference aad WHERE aad.target_kind = ? AND aad.target_id = e.id AND aad.field_id IN (?, ?, ?, ?)) AS agg_agg1 FROM entity_category e LEFT JOIN entity_content_data_reference rd1 ON rd1.target_kind = ? AND rd1.target_id = e.id AND rd1.field_id IN (?, ?, ?, ?) LEFT JOIN entity_content rt2 ON rt2.id = rd1.entity_id AND rd1.rev_id <=> rt2.rev_id WHERE e.type_id IN (?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND EXISTS (SELECT 1 FROM entity_content_data_reference d3 JOIN entity_content n4 ON d3.entity_id = n4.id WHERE d3.target_kind = ? AND d3.target_id = e.id AND d3.field_id IN (?, ?, ?, ?) AND d3.rev_id <=> n4.rev_id AND NOT (n4.flags & 1) = 1 AND NOT (n4.flags & 2) = 2 AND n4.site_id = ?) ORDER BY (SELECT COUNT(DISTINCT aad.entity_id) FROM entity_content_data_reference aad WHERE aad.target_kind = ? AND aad.target_id = e.id AND aad.field_id IN (?, ?, ?, ?)) DESC, (SELECT d.value FROM entity_category_data_text d WHERE d.entity_id = e.id AND d.field_id IN (?) AND d.rev_id IS NULL AND d.delta = 0 LIMIT 1) ASC, e.id DESC
SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?
SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL
SELECT id, name FROM entity_category_view_mode WHERE type_id = ?
SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC
SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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 = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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 = ?
SELECT t0_.site_id AS sclr_0 FROM theme_site_delta t0_ WHERE t0_.site_id IN (?, ?)
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\Site\Site	10
App\Entity\Navigation\Navigation	4
App\Entity\Language	1
App\Entity\Theme\ThemeSiteDelta	1
App\Entity\Theme\SiteTheme	1
Entities Mapping

Class	Mapping errors
App\Entity\Enums\SiteStatus	No errors.
App\Entity\Enums\SiteTypeFlags	No errors.
App\Entity\Site\Site	No errors.
App\Entity\Enums\ContentStatus	No errors.
App\Entity\Content\Content	No errors.
App\Entity\Category\Category	No errors.
App\Entity\User\UserSiteAccess	No errors.
App\Entity\Language	No errors.
App\Entity\Theme\ThemeSiteDelta	No errors.
App\Entity\Enums\SiteThemeStatus	No errors.
App\Entity\Theme\SiteTheme	No errors.
App\Entity\Theme\ThemeBlockDelta	No errors.
App\Entity\Theme\ThemeOwnBlockDelta	No errors.
App\Entity\Enums\BlockStatus	No errors.
App\Entity\Theme\Block	No errors.
App\Entity\Enums\SiteInjectionStatus	No errors.
App\Entity\Site\SiteInjection	No errors.
App\Entity\Enums\NavigationStatus	No errors.
App\Entity\Navigation\Navigation	No errors.
App\Entity\Enums\NavigationItemStatus	No errors.
App\Entity\Navigation\NavigationItem	No errors.
Symfony Profiler

GET http://sp1.delk.wiemo.pl/aktualnosci

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
