Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

59 Database Queries

33 Different statements

11.09 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 * 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 * 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 id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM settings_store WHERE scope = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND (`date` > :mdate OR versionCount > :versionCount) AND ((autoSave = 1 AND userId = :userId) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1
SELECT `save` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `save` DESC LIMIT 1
SELECT * FROM edit_lock WHERE cid = ? AND ctype = ?
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'steiermark' AND TABLE_NAME = 'edit_lock' ORDER BY ORDINAL_POSITION ASC
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'edit_lock' */ WHERE k.table_name = 'edit_lock' AND k.table_schema = 'steiermark' /*!50116 AND c.constraint_schema = 'steiermark' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'edit_lock' AND TABLE_SCHEMA = 'steiermark' ORDER BY SEQ_IN_INDEX ASC
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'edit_lock'
INSERT INTO `edit_lock` (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `cid` = :col1, `ctype` = :col2, `userId` = :col3, `sessionId` = :col4, `date` = :col5;
SELECT `view` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `view` DESC LIMIT 1
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,45933364,42994971,5020) AND type='object' AND locked = 'propagate' LIMIT 1
SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
            WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC LIMIT 1
SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
             WHERE cid = 1 AND userId IN (24,71,569)
             ORDER BY FIELD(userId, 569) DESC
SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype  AND autoSave = 0 ORDER BY `id` ASC
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT * FROM versions 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 * FROM versions WHERE id = ?
SELECT * FROM versions WHERE id = ?
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
SELECT o_classId FROM objects WHERE o_path LIKE ? AND o_type = 'object' LIMIT 1
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_MediaAsset r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.src_id = ?
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,45933364,42994971,5020) AND inheritable = 1) OR cid = ? ) AND ctype='object'
SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `layouts` DESC
SELECT id FROM custom_layouts WHERE classId = 'MediaAsset'  ORDER BY `name`
SELECT `lView`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lView` DESC
SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lEdit` DESC
DELETE FROM tmp_store WHERE id = ?

#▲	Time	Info
1	0.37 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.09 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.13 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.27 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.11 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.07 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.28 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 569`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 569;
8	0.15 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`569`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 569;
9	0.09 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`569`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 569;
10	0.09 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`569`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 569;
11	0.29 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" "24"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = '24';
12	0.13 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 24;
13	0.11 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 24;
14	0.11 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 24;
15	0.12 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"role" "71"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'role' AND id = '71';
16	0.11 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`71`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 71;
17	0.11 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`71`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 71;
18	0.11 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`71`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 71;
19	0.16 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_perspectives"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';
20	0.20 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "web_to_print" "scope" => "pimcore_web_to_print"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'web_to_print' AND scope = 'pimcore_web_to_print';
21	0.10 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_custom_views"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_custom_views';
22	0.24 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"MediaAsset"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'MediaAsset';
23	0.61 ms	SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND (`date` > :mdate OR versionCount > :versionCount) AND ((autoSave = 1 AND userId = :userId) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1 Parameters: [`"cid" => 43140130 "ctype" => "object" "userId" => 569 "mdate" => 1729586066 "versionCount" => 21`] View formatted query View runnable query Explain query SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND ( `date` > :mdate OR versionCount > :versionCount ) AND ( ( autoSave = 1 AND userId = :userId ) OR autoSave = 0 ) ORDER BY `versionCount` DESC LIMIT 1 SELECT id FROM versions WHERE cid = 43140130 AND ctype = 'object' AND (`date` > 1729586066 OR versionCount > 21) AND ((autoSave = 1 AND userId = 569) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;
24	0.40 ms	SELECT `save` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `save` DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `save` FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `save` DESC LIMIT 1 SELECT `save` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `save` DESC LIMIT 1;
25	0.14 ms	SELECT * FROM edit_lock WHERE cid = ? AND ctype = ? Parameters: [`43140130 "object"`] View formatted query View runnable query Explain query SELECT * FROM edit_lock WHERE cid = ? AND ctype = ? SELECT * FROM edit_lock WHERE cid = 43140130 AND ctype = 'object';
26	0.54 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'steiermark' AND TABLE_NAME = 'edit_lock' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'steiermark' AND TABLE_NAME = 'edit_lock' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'steiermark' AND TABLE_NAME = 'edit_lock' ORDER BY ORDINAL_POSITION ASC;
27	0.20 ms	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'edit_lock' / WHERE k.table_name = 'edit_lock' AND k.table_schema = 'steiermark' /!50116 AND c.constraint_schema = 'steiermark' / AND k.`REFERENCED_COLUMN_NAME` is not NULL Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'edit_lock' / WHERE k.table_name = 'edit_lock' AND k.table_schema = 'steiermark' /!50116 AND c.constraint_schema = 'steiermark' / AND k.`REFERENCED_COLUMN_NAME` is not NULL SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'edit_lock' / WHERE k.table_name = 'edit_lock' AND k.table_schema = 'steiermark' /!50116 AND c.constraint_schema = 'steiermark' / AND k.`REFERENCED_COLUMN_NAME` is not NULL;
28	0.13 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'edit_lock' AND TABLE_SCHEMA = 'steiermark' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'edit_lock' AND TABLE_SCHEMA = 'steiermark' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'edit_lock' AND TABLE_SCHEMA = 'steiermark' ORDER BY SEQ_IN_INDEX ASC;
29	0.13 ms	SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'edit_lock' Parameters: [] View formatted query View runnable query Explain query SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'edit_lock' SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS FROM information_schema.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'edit_lock';
30	0.57 ms	INSERT INTO `edit_lock` (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `cid` = :col1, `ctype` = :col2, `userId` = :col3, `sessionId` = :col4, `date` = :col5; Parameters: [`":col0" => null ":col1" => 43140130 ":col2" => "object" ":col3" => 569 ":col4" => "12722af521bbc98a9ae1edc46adae3f1" ":col5" => 1729597656`] View formatted query View runnable query Explain query INSERT INTO `edit_lock` ( `id`, `cid`, `ctype`, `userId`, `sessionId`, `date` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `cid` = :col1, `ctype` = :col2, `userId` = :col3, `sessionId` = :col4, `date` = :col5; INSERT INTO `edit_lock` (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `cid` = :col1, `ctype` = :col2, `userId` = :col3, `sessionId` = :col4, `date` = :col5;;
31	0.24 ms	SELECT `view` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `view` DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `view` FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `view` DESC LIMIT 1 SELECT `view` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `view` DESC LIMIT 1;
32	0.18 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/Press/Media-Assets/Magazin\_101/Magazin Steiermark 101 Englisch/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE '/Press/Media-Assets/Magazin\\_101/Magazin Steiermark 101 Englisch/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
33	0.14 ms	SELECT id FROM tree_locks WHERE id IN (1,45933364,42994971,5020) AND type='object' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 45933364, 42994971, 5020) AND type = 'object' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,45933364,42994971,5020) AND type='object' AND locked = 'propagate' LIMIT 1;
34	0.21 ms	SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT userId, cid, `list`, `view`, `publish`, `delete`, `rename`, `create`, `settings`, `versions`, `properties`, `save`, `unpublish`, `lEdit`, `lView`, `layouts` FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC LIMIT 1 SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC LIMIT 1 ;
35	0.12 ms	SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid = 1 AND userId IN (24,71,569) ORDER BY FIELD(userId, 569) DESC Parameters: [] View formatted query View runnable query Explain query SELECT userId, `list`, `view`, `publish`, `delete`, `rename`, `create`, `settings`, `versions`, `properties`, `save`, `unpublish`, `lEdit`, `lView`, `layouts` FROM users_workspaces_object WHERE cid = 1 AND userId IN (24, 71, 569) ORDER BY FIELD(userId, 569) DESC SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid = 1 AND userId IN (24,71,569) ORDER BY FIELD(userId, 569) DESC ;
36	0.30 ms	SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND autoSave = 0 ORDER BY `id` ASC Parameters: [`"cid" => 43140130 "ctype" => "object"`] View formatted query View runnable query Explain query SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND autoSave = 0 ORDER BY `id` ASC SELECT id FROM versions WHERE cid = 43140130 AND ctype = 'object' AND autoSave = 0 ORDER BY `id` ASC;
37	0.11 ms	SELECT * FROM versions WHERE id = ? Parameters: [`293240578`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 293240578;
38	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`308495857`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 308495857;
39	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`333486586`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 333486586;
40	0.11 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 549`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 549;
41	0.11 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`549`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 549;
42	0.10 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`549`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 549;
43	0.10 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`549`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 549;
44	0.08 ms	SELECT * FROM versions WHERE id = ? Parameters: [`346674616`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 346674616;
45	0.07 ms	SELECT * FROM versions WHERE id = ? Parameters: [`346690841`] View formatted query View runnable query Explain query SELECT * FROM versions WHERE id = ? SELECT * FROM versions WHERE id = 346690841;
46	0.11 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`43140130 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 43140130 AND `ctype` = 'object' ;
47	0.13 ms	SELECT o_classId FROM objects WHERE o_path LIKE ? AND o_type = 'object' LIMIT 1 Parameters: [`"/Press/Media-Assets/Magazin\_101/Magazin Steiermark 101 Englisch/%"`] View formatted query View runnable query Explain query SELECT o_classId FROM objects WHERE o_path LIKE ? AND o_type = 'object' LIMIT 1 SELECT o_classId FROM objects WHERE o_path LIKE '/Press/Media-Assets/Magazin\\_101/Magazin Steiermark 101 Englisch/%' AND o_type = 'object' LIMIT 1;
48	0.36 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"asset" 43140130 "asset" 43140130 "asset" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'asset' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'asset' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'asset' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
49	0.30 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"regions" 43140130 "regions" 43140130 "regions" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'regions' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'regions' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'regions' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
50	0.31 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"categories" 43140130 "categories" 43140130 "categories" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'categories' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'categories' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'categories' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
51	0.29 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"author" 43140130 "author" 43140130 "author" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'author' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'author' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'author' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
52	0.30 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"copyright" 43140130 "copyright" 43140130 "copyright" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'copyright' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'copyright' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'copyright' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
53	0.29 ms	SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"keywords" 43140130 "keywords" 43140130 "keywords" 43140130`] View formatted query View runnable query Explain query SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND o.o_id = r.dest_id AND r.type = 'object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND a.id = r.dest_id AND r.type = 'asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.src_id = ? AND d.id = r.dest_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_MediaAsset r WHERE r.fieldname= 'keywords' AND r.ownertype = 'object' AND r.src_id = 43140130 AND o.o_id = r.dest_id AND r.type='object' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_MediaAsset r WHERE r.fieldname= 'keywords' AND r.ownertype = 'object' AND r.src_id = 43140130 AND a.id = r.dest_id AND r.type='asset' UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_MediaAsset r WHERE r.fieldname= 'keywords' AND r.ownertype = 'object' AND r.src_id = 43140130 AND d.id = r.dest_id AND r.type='document' ORDER BY `index` ASC;
54	0.16 ms	SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,45933364,42994971,5020) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`43140130`] View formatted query View runnable query Explain query SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 45933364, 42994971, 5020) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,45933364,42994971,5020) AND inheritable = 1) OR cid = 43140130 ) AND ctype='object';
55	0.17 ms	SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `layouts` DESC Parameters: [] View formatted query View runnable query Explain query SELECT `layouts`, cid, cpath FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `layouts` DESC SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `layouts` DESC;
56	0.08 ms	SELECT id FROM custom_layouts WHERE classId = 'MediaAsset' ORDER BY `name` Parameters: [] View formatted query View runnable query Explain query SELECT id FROM custom_layouts WHERE classId = 'MediaAsset' ORDER BY `name` SELECT id FROM custom_layouts WHERE classId = 'MediaAsset' ORDER BY `name` ;
57	0.18 ms	SELECT `lView`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lView` DESC Parameters: [] View formatted query View runnable query Explain query SELECT `lView`, cid, cpath FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lView` DESC SELECT `lView`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lView` DESC;
58	0.15 ms	SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lEdit` DESC Parameters: [] View formatted query View runnable query Explain query SELECT `lEdit`, cid, cpath FROM users_workspaces_object WHERE cid IN ( 1, 45933364, 42994971, 5020, 43140130 ) AND userId IN (24, 71, 569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lEdit` DESC SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,45933364,42994971,5020,43140130) AND userId IN (24,71,569) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 569) DESC, `lEdit` DESC;
59	0.10 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"object_session_43140130_12722af521bbc98a9ae1edc46adae3f1"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'object_session_43140130_12722af521bbc98a9ae1edc46adae3f1';

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/object/get?_dc=1729597655223&id=43140130

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