Query Metrics
118
Database Queries
25
Different statements
20.42 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 2 | 0.39 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 59 ] |
| 3 | 0.23 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
59
]
|
| 4 | 0.19 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
59
]
|
| 5 | 0.21 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
59
]
|
| 6 | 0.42 ms |
SELECT * FROM edit_lock WHERE cid = ? AND ctype = ?
Parameters:
[ 574375 "object" ] |
| 7 | 0.30 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
| 8 | 0.21 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
574375
]
|
| 9 | 0.23 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
574375
]
|
| 10 | 0.25 ms |
SELECT * FROM object_store_1 WHERE oo_id = ?
Parameters:
[
574375
]
|
| 11 | 0.28 ms |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
574375
]
|
| 12 | 0.14 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"2"
]
|
| 13 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554098
]
|
| 14 | 0.18 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554098
]
|
| 15 | 0.15 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554098
]
|
| 16 | 0.27 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554098
]
|
| 17 | 0.19 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554098
]
|
| 18 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554154
]
|
| 19 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554154
]
|
| 20 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554154
]
|
| 21 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554154
]
|
| 22 | 0.17 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554154
]
|
| 23 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554494
]
|
| 24 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554494
]
|
| 25 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554494
]
|
| 26 | 0.24 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554494
]
|
| 27 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554494
]
|
| 28 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554496
]
|
| 29 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554496
]
|
| 30 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554496
]
|
| 31 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554496
]
|
| 32 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554496
]
|
| 33 | 0.14 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
556084
]
|
| 34 | 0.18 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
556084
]
|
| 35 | 0.14 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
556084
]
|
| 36 | 0.23 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
556084
]
|
| 37 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
556084
]
|
| 38 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554687
]
|
| 39 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554687
]
|
| 40 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554687
]
|
| 41 | 0.23 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554687
]
|
| 42 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554687
]
|
| 43 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764246
]
|
| 44 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764246
]
|
| 45 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764246
]
|
| 46 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764246
]
|
| 47 | 0.17 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764246
]
|
| 48 | 0.14 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764295
]
|
| 49 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764295
]
|
| 50 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764295
]
|
| 51 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764295
]
|
| 52 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764295
]
|
| 53 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764594
]
|
| 54 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764594
]
|
| 55 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764594
]
|
| 56 | 0.24 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764594
]
|
| 57 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764594
]
|
| 58 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764596
]
|
| 59 | 0.19 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764596
]
|
| 60 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764596
]
|
| 61 | 0.25 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764596
]
|
| 62 | 0.19 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764596
]
|
| 63 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
766059
]
|
| 64 | 0.18 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
766059
]
|
| 65 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
766059
]
|
| 66 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
766059
]
|
| 67 | 0.18 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
766059
]
|
| 68 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764787
]
|
| 69 | 0.18 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764787
]
|
| 70 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764787
]
|
| 71 | 0.23 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764787
]
|
| 72 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764787
]
|
| 73 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554267
]
|
| 74 | 0.17 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554267
]
|
| 75 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554267
]
|
| 76 | 0.21 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554267
]
|
| 77 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554267
]
|
| 78 | 0.12 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554089
]
|
| 79 | 0.16 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554089
]
|
| 80 | 0.14 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554089
]
|
| 81 | 0.22 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554089
]
|
| 82 | 0.16 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554089
]
|
| 83 | 0.13 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764408
]
|
| 84 | 0.19 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764408
]
|
| 85 | 0.13 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764408
]
|
| 86 | 0.18 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764408
]
|
| 87 | 0.09 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764408
]
|
| 88 | 0.07 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764237
]
|
| 89 | 0.09 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764237
]
|
| 90 | 0.07 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764237
]
|
| 91 | 0.11 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764237
]
|
| 92 | 0.10 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764237
]
|
| 93 | 0.08 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
554081
]
|
| 94 | 0.10 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
554081
]
|
| 95 | 0.10 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
554081
]
|
| 96 | 0.13 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
554081
]
|
| 97 | 0.09 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
554081
]
|
| 98 | 0.08 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
3
]
|
| 99 | 0.10 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
3
]
|
| 100 | 0.08 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
764230
]
|
| 101 | 0.11 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
764230
]
|
| 102 | 0.08 ms |
SELECT * FROM object_store_2 WHERE oo_id = ?
Parameters:
[
764230
]
|
| 103 | 0.11 ms |
SELECT * FROM object_localized_data_2 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
764230
]
|
| 104 | 0.08 ms |
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
764230
]
|
| 105 | 0.15 ms |
SELECT COUNT(*) FROM objects WHERE parentId = ? AND objects.type IN ('object','variant','folder')
Parameters:
[
574375
]
|
| 106 | 0.09 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"11"
]
|
| 107 | 0.08 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
567098
]
|
| 108 | 0.09 ms |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
567098
]
|
| 109 | 0.08 ms |
SELECT * FROM object_store_11 WHERE oo_id = ?
Parameters:
[
567098
]
|
| 110 | 0.12 ms |
SELECT * FROM object_localized_data_11 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
567098
]
|
| 111 | 0.14 ms |
SELECT * FROM object_collection_BrandLine_11 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 567098 "BrandLines" ] |
| 112 | 0.09 ms |
SELECT * FROM object_relations_11 WHERE src_id = ?
Parameters:
[
567098
]
|
| 113 | 0.16 ms |
SELECT * FROM object_localized_data_1 WHERE ooo_id = ? AND language IN ('eurokos_lt','eurokos_gb','monro_lt','fi','sv')
Parameters:
[
574375
]
|
| 114 | 0.12 ms |
SELECT * FROM object_collection_Image_1 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 574375 "Images" ] |
| 115 | 0.12 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
2366329
]
|
| 116 | 0.17 ms |
SELECT * FROM object_classificationstore_groups_1 WHERE id = 574375 AND fieldname = 'CSTORE'
Parameters:
[] |
| 117 | 0.27 ms |
SELECT * FROM object_classificationstore_data_1 WHERE id = 574375 AND fieldname = 'CSTORE'
Parameters:
[] |
| 118 | 1.57 ms |
DELETE FROM edit_lock WHERE id = ?
Parameters:
[
22007
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore_translation_provider_interfaces | doctrine.orm.pimcore_translation_provider_interfaces_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.