Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

19 Database Queries

10 Different statements

12.62 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT COUNT(*) as amount FROM bundle_process_manager_monitoring_item  WHERE executedByUser = ? and parentId IS NULL AND published = 1
SELECT id FROM bundle_process_manager_monitoring_item WHERE executedByUser = ? and parentId IS NULL AND published = 1   ORDER BY `id` DESC
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id
SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id

#▲	Time	Info
1	0.38 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.19 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.28 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.12 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.25 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 32`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 32;
8	0.11 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 32;
9	0.09 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 32;
10	0.09 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 32;
11	4.86 ms	SELECT COUNT() as amount FROM bundle_process_manager_monitoring_item WHERE executedByUser = ? and parentId IS NULL AND published = 1 Parameters: [`32`] View formatted query View runnable query Explain query SELECT COUNT() as amount FROM bundle_process_manager_monitoring_item WHERE executedByUser = ? and parentId IS NULL AND published = 1 SELECT COUNT(*) as amount FROM bundle_process_manager_monitoring_item WHERE executedByUser = 32 and parentId IS NULL AND published = 1 ;
12	5.18 ms	SELECT id FROM bundle_process_manager_monitoring_item WHERE executedByUser = ? and parentId IS NULL AND published = 1 ORDER BY `id` DESC Parameters: [`32`] View formatted query View runnable query Explain query SELECT id FROM bundle_process_manager_monitoring_item WHERE executedByUser = ? and parentId IS NULL AND published = 1 ORDER BY `id` DESC SELECT id FROM bundle_process_manager_monitoring_item WHERE executedByUser = 32 and parentId IS NULL AND published = 1 ORDER BY `id` DESC;
13	0.17 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
14	0.13 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
15	0.11 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
16	0.11 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
17	0.15 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
18	0.11 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;
19	0.12 ms	SELECT * FROM bundle_process_manager_monitoring_item WHERE id= :id Parameters: [`"id" => 2741312`] View formatted query View runnable query Explain query SELECT * FROM bundle_process_manager_monitoring_item WHERE id = :id SELECT * FROM bundle_process_manager_monitoring_item WHERE id= 2741312;

demi_vacancies connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
demi_vacancies	doctrine.dbal.demi_vacancies_connection

Entity Managers

Name	Service
portal_engine	doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit	doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer	doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/admin/elementsprocessmanager/monitoring-item/list-processes-for-user?_dc=1738587814749

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

demi_vacancies connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager