Query Metrics
59
Database Queries
33
Different statements
11.09 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.85 ms (16.64%) |
6 |
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 ] |
0.80 ms (7.22%) |
4 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 569 ] |
0.64 ms (5.81%) |
2 |
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 ] |
0.61 ms (5.50%) |
1 |
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 ] |
0.57 ms (5.12%) |
1 |
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 ] |
0.54 ms (4.87%) |
1 |
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:
[] |
0.49 ms (4.46%) |
4 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
569
]
|
0.44 ms (3.99%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
0.41 ms (3.70%) |
5 |
SELECT * FROM versions WHERE id = ?
Parameters:
[
293240578
]
|
0.41 ms (3.66%) |
4 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
569
]
|
0.40 ms (3.65%) |
4 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
569
]
|
0.40 ms (3.57%) |
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
Parameters:
[] |
0.30 ms (2.67%) |
1 |
SELECT id FROM versions WHERE cid = :cid AND ctype = :ctype AND autoSave = 0 ORDER BY `id` ASC
Parameters:
[ "cid" => 43140130 "ctype" => "object" ] |
0.26 ms (2.34%) |
2 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_perspectives"
]
|
0.24 ms (2.21%) |
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
Parameters:
[] |
0.21 ms (1.86%) |
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
Parameters:
[] |
0.20 ms (1.79%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "web_to_print" "scope" => "pimcore_web_to_print" ] |
0.20 ms (1.78%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.20 ms (1.77%) |
1 |
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:
[] |
0.18 ms (1.62%) |
1 |
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:
[] |
0.18 ms (1.60%) |
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
Parameters:
[
"/Press/Media-Assets/Magazin\_101/Magazin Steiermark 101 Englisch/%"
]
|
0.17 ms (1.56%) |
1 |
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:
[] |
0.16 ms (1.47%) |
1 |
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
]
|
0.15 ms (1.37%) |
1 |
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:
[] |
0.14 ms (1.27%) |
1 |
SELECT * FROM edit_lock WHERE cid = ? AND ctype = ?
Parameters:
[ 43140130 "object" ] |
0.14 ms (1.25%) |
1 |
SELECT id FROM tree_locks WHERE id IN (1,45933364,42994971,5020) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
0.13 ms (1.21%) |
1 |
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/%"
]
|
0.13 ms (1.15%) |
1 |
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:
[] |
0.13 ms (1.14%) |
1 |
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:
[] |
0.12 ms (1.13%) |
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
Parameters:
[] |
0.11 ms (1.03%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 43140130 "object" ] |
0.10 ms (0.87%) |
1 |
DELETE FROM tmp_store WHERE id = ?
Parameters:
[
"object_session_43140130_12722af521bbc98a9ae1edc46adae3f1"
]
|
0.08 ms (0.73%) |
1 |
SELECT id FROM custom_layouts WHERE classId = 'MediaAsset' ORDER BY `name`
Parameters:
[] |
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.