Query Metrics
169
Database Queries
72
Different statements
69.81 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 2 | 0.27 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 3 | 0.35 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
| 4 | 0.29 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
| 5 | 0.27 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
| 6 | 0.28 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
| 7 | 0.26 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_1913" ] |
| 8 | 0.20 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"21"
]
|
| 9 | 0.26 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1773310168 "object_1913\x01tags\x01" "class_21\x01tags\x01" "asset_132730\x01tags\x01" ] |
| 10 | 0.50 ms |
SELECT id FROM versions WHERE cid = ? AND ctype = ? AND (`date` > ? OR versionCount > ?) AND ((autoSave = 1 AND userId = ?) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1
Parameters:
[ 1913 "object" 1759326769 3 2 ] |
| 11 | 0.23 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_150" ] |
| 12 | 0.22 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_150\x01tags\x01" ] |
| 13 | 0.22 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
150
]
|
| 14 | 0.46 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Firm/" "Carrozzeria Touring (1913)" ] |
| 15 | 0.25 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Firm/" "Carrozzeria Touring (1913)" ] |
| 16 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 0.14 ms |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
1913
]
|
| 18 | 0.21 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 19 | 0.27 ms |
SELECT * FROM object_relations_21 WHERE src_id = ?
Parameters:
[
1913
]
|
| 20 | 0.19 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Articolo"
]
|
| 21 | 0.18 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"18"
]
|
| 22 | 0.30 ms |
SELECT * FROM object_relations_18 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 23 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Audio"
]
|
| 24 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"19"
]
|
| 25 | 0.30 ms |
SELECT * FROM object_relations_19 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 26 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Disegno"
]
|
| 27 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"20"
]
|
| 28 | 0.30 ms |
SELECT * FROM object_relations_20 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 29 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Documento"
]
|
| 30 | 0.18 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
| 31 | 0.30 ms |
SELECT * FROM object_relations_7 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 32 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Fotografia"
]
|
| 33 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
| 34 | 0.34 ms |
SELECT * FROM object_relations_6 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 35 | 0.19 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Oggetto"
]
|
| 36 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"8"
]
|
| 37 | 0.30 ms |
SELECT * FROM object_relations_8 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 38 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Pubblicazione"
]
|
| 39 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"9"
]
|
| 40 | 0.31 ms |
SELECT * FROM object_relations_9 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 41 | 0.19 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Video"
]
|
| 42 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"17"
]
|
| 43 | 0.30 ms |
SELECT * FROM object_relations_17 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 44 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Persona"
]
|
| 45 | 0.19 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"15"
]
|
| 46 | 0.30 ms |
SELECT * FROM object_relations_15 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 47 | 0.18 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Azienda"
]
|
| 48 | 0.18 ms |
SELECT * FROM object_relations_21 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 49 | 0.14 ms |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Evento"
]
|
| 50 | 0.12 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"11"
]
|
| 51 | 0.24 ms |
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 52 | 0.15 ms |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
1913
]
|
| 53 | 0.22 ms |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
1913
]
|
| 54 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_objects" ] |
| 55 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_objects" ] |
| 56 | 1.12 ms |
SHOW COLUMNS FROM objects
Parameters:
[] |
| 57 | 0.16 ms |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
1913
]
|
| 58 | 0.25 ms |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/Firm/" 1913 1759326257 1773310168 4 12 2 150 "object" "Carrozzeria Touring (1913)" 0 null null "21" 1 "Azienda" ] |
| 59 | 0.94 ms |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/Firm/" 1913 1759326257 1773310168 4 12 2 150 "object" "Carrozzeria Touring (1913)" 0 null null "21" 1 "Azienda" 1913 ] |
| 60 | 0.21 ms |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 1913 "object" ] |
| 61 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 62 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 63 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 64 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 65 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 66 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_object_localized_data_21" ] |
| 67 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_object_localized_data_21" ] |
| 68 | 0.88 ms |
SHOW COLUMNS FROM object_localized_data_21
Parameters:
[] |
| 69 | 0.23 ms |
INSERT INTO object_localized_data_21 (`ooo_id`, `language`, `dcDescription`, `biogHist`, `struttura_amministrativa`, `Sources`, `legal_status`, `Note`, `Note_archivista`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1913 "en" null null null null null null null ] |
| 70 | 0.19 ms |
UPDATE object_localized_data_21 SET `ooo_id` = ?, `language` = ?, `dcDescription` = ?, `biogHist` = ?, `struttura_amministrativa` = ?, `Sources` = ?, `legal_status` = ?, `Note` = ?, `Note_archivista` = ? WHERE `ooo_id` = ? AND `language` = ?
Parameters:
[ 1913 "en" null null null null null null null 1913 "en" ] |
| 71 | 0.99 ms |
SELECT * FROM object_localized_query_21_en WHERE ooo_id = 1913 AND language = 'en'
Parameters:
[] |
| 72 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 73 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 74 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 75 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 76 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 77 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 78 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 79 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_object_localized_query_21_en" ] |
| 80 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_object_localized_query_21_en" ] |
| 81 | 0.85 ms |
SHOW COLUMNS FROM object_localized_query_21_en
Parameters:
[] |
| 82 | 0.18 ms |
INSERT INTO object_localized_query_21_en (`ooo_id`, `language`, `dcDescription`, `biogHist`, `struttura_amministrativa`, `Sources`, `legal_status`, `Note`, `Note_archivista`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1913 "en" null null null null null null null ] |
| 83 | 0.31 ms |
UPDATE object_localized_query_21_en SET `ooo_id` = ?, `language` = ?, `dcDescription` = ?, `biogHist` = ?, `struttura_amministrativa` = ?, `Sources` = ?, `legal_status` = ?, `Note` = ?, `Note_archivista` = ? WHERE `ooo_id` = ? AND `language` = ?
Parameters:
[ 1913 "en" null null null null null null null 1913 "en" ] |
| 84 | 0.16 ms |
INSERT INTO object_localized_data_21 (`ooo_id`, `language`, `dcDescription`, `biogHist`, `struttura_amministrativa`, `Sources`, `legal_status`, `Note`, `Note_archivista`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1913 "it" null null null null null null null ] |
| 85 | 0.17 ms |
UPDATE object_localized_data_21 SET `ooo_id` = ?, `language` = ?, `dcDescription` = ?, `biogHist` = ?, `struttura_amministrativa` = ?, `Sources` = ?, `legal_status` = ?, `Note` = ?, `Note_archivista` = ? WHERE `ooo_id` = ? AND `language` = ?
Parameters:
[ 1913 "it" null null null null null null null 1913 "it" ] |
| 86 | 0.84 ms |
SELECT * FROM object_localized_query_21_it WHERE ooo_id = 1913 AND language = 'it'
Parameters:
[] |
| 87 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 88 | 0.14 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 89 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 90 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 91 | 0.14 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 92 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 93 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 94 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_object_localized_query_21_it" ] |
| 95 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_object_localized_query_21_it" ] |
| 96 | 0.88 ms |
SHOW COLUMNS FROM object_localized_query_21_it
Parameters:
[] |
| 97 | 0.18 ms |
INSERT INTO object_localized_query_21_it (`ooo_id`, `language`, `dcDescription`, `biogHist`, `struttura_amministrativa`, `Sources`, `legal_status`, `Note`, `Note_archivista`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1913 "it" null null null null null null null ] |
| 98 | 0.34 ms |
UPDATE object_localized_query_21_it SET `ooo_id` = ?, `language` = ?, `dcDescription` = ?, `biogHist` = ?, `struttura_amministrativa` = ?, `Sources` = ?, `legal_status` = ?, `Note` = ?, `Note_archivista` = ? WHERE `ooo_id` = ? AND `language` = ?
Parameters:
[ 1913 "it" null null null null null null null 1913 "it" ] |
| 99 | 0.18 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "asset_132730" ] |
| 100 | 0.15 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_object_store_21" ] |
| 101 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_object_store_21" ] |
| 102 | 1.08 ms |
SHOW COLUMNS FROM object_store_21
Parameters:
[] |
| 103 | 0.26 ms |
INSERT INTO object_store_21 (`oo_id`, `dcTitle`, `Suffix1`, `nameEntryParallel`, `data_fondazione`, `data_dissoluzione`, `Wikidata`, `Wikipedia`, `VIAF`, `External_link`, `source_id`, `occupation`, `AddressLine1`, `AddressLine2`, `ZIP`, `City`, `State`, `Country`, `Telephone`, `Email`, `livello_catalogazione`, `Azione`, `data_resp`, `compilatore`, `responsabilita_block`, `id_origine`, `PhotoGallery__images`, `PhotoGallery__hotspots`, `Video`, `link_esterni`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1913 "Carrozzeria Touring" null "a:0:{}" null null null null null null null null null null null null null null null null "" "" null null "a:0:{}" null ",132730," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null "a:0:{}" ] |
| 104 | 0.20 ms |
UPDATE object_store_21 SET `oo_id` = ?, `dcTitle` = ?, `Suffix1` = ?, `nameEntryParallel` = ?, `data_fondazione` = ?, `data_dissoluzione` = ?, `Wikidata` = ?, `Wikipedia` = ?, `VIAF` = ?, `External_link` = ?, `source_id` = ?, `occupation` = ?, `AddressLine1` = ?, `AddressLine2` = ?, `ZIP` = ?, `City` = ?, `State` = ?, `Country` = ?, `Telephone` = ?, `Email` = ?, `livello_catalogazione` = ?, `Azione` = ?, `data_resp` = ?, `compilatore` = ?, `responsabilita_block` = ?, `id_origine` = ?, `PhotoGallery__images` = ?, `PhotoGallery__hotspots` = ?, `Video` = ?, `link_esterni` = ? WHERE `oo_id` = ?
Parameters:
[ 1913 "Carrozzeria Touring" null "a:0:{}" null null null null null null null null null null null null null null null null "" "" null null "a:0:{}" null ",132730," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null "a:0:{}" 1913 ] |
| 105 | 0.29 ms |
SELECT * FROM object_query_21 WHERE oo_id = ?
Parameters:
[
1913
]
|
| 106 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_object_query_21" ] |
| 107 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_object_query_21" ] |
| 108 | 1.23 ms |
SHOW COLUMNS FROM object_query_21
Parameters:
[] |
| 109 | 0.22 ms |
INSERT INTO object_query_21 (`dcTitle`, `Suffix1`, `data_fondazione`, `data_dissoluzione`, `Wikidata`, `Wikipedia`, `VIAF`, `External_link`, `source_id`, `occupation`, `AddressLine1`, `AddressLine2`, `ZIP`, `City`, `State`, `Country`, `Telephone`, `Email`, `livello_catalogazione`, `Azione`, `data_resp`, `compilatore`, `id_origine`, `PhotoGallery__images`, `PhotoGallery__hotspots`, `Video`, `PDF`, `File_audio`, `other_files`, `related_companies`, `motori_collegati`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Carrozzeria Touring" null null null null null null null null null null null null null null null null null "" "" null null null ",132730," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null null null null null null 1913 ] |
| 110 | 0.29 ms |
UPDATE object_query_21 SET `dcTitle` = ?, `Suffix1` = ?, `data_fondazione` = ?, `data_dissoluzione` = ?, `Wikidata` = ?, `Wikipedia` = ?, `VIAF` = ?, `External_link` = ?, `source_id` = ?, `occupation` = ?, `AddressLine1` = ?, `AddressLine2` = ?, `ZIP` = ?, `City` = ?, `State` = ?, `Country` = ?, `Telephone` = ?, `Email` = ?, `livello_catalogazione` = ?, `Azione` = ?, `data_resp` = ?, `compilatore` = ?, `id_origine` = ?, `PhotoGallery__images` = ?, `PhotoGallery__hotspots` = ?, `Video` = ?, `PDF` = ?, `File_audio` = ?, `other_files` = ?, `related_companies` = ?, `motori_collegati` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters:
[ "Carrozzeria Touring" null null null null null null null null null null null null null null null null null "" "" null null null ",132730," "a:1:{i:0;s:63:"a:3:{s:8:"hotspots";a:0:{}s:6:"marker";a:0:{}s:4:"crop";a:0:{}}";}" null null null null null null 1913 1913 ] |
| 111 | 0.23 ms |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 1913 "object" ] |
| 112 | 0.13 ms |
DELETE FROM schedule_tasks WHERE `cid` = 1913 AND `ctype` = 'object'
Parameters:
[] |
| 113 | 0.16 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
| 114 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_properties_1913" ] |
| 115 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00object_properties_1913" ] |
| 116 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_1" ] |
| 117 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "object_1\x01tags\x01" ] |
| 118 | 0.27 ms |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,150) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
1913
]
|
| 119 | 0.20 ms |
SELECT * FROM object_relations_18 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 120 | 0.17 ms |
SELECT * FROM object_relations_19 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 121 | 0.19 ms |
SELECT * FROM object_relations_20 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 122 | 0.18 ms |
SELECT * FROM object_relations_7 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 123 | 0.18 ms |
SELECT * FROM object_relations_6 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 124 | 0.17 ms |
SELECT * FROM object_relations_8 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 125 | 0.18 ms |
SELECT * FROM object_relations_9 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 126 | 0.17 ms |
SELECT * FROM object_relations_17 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 127 | 0.17 ms |
SELECT * FROM object_relations_15 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 128 | 0.17 ms |
SELECT * FROM object_relations_21 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 129 | 0.17 ms |
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 130 | 0.16 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_resource_columns_versions" ] |
| 131 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_resource_columns_versions" ] |
| 132 | 0.94 ms |
SHOW COLUMNS FROM versions
Parameters:
[] |
| 133 | 0.40 ms |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 1913 "object" 2 "" 1773310168 0 1 """ #0 /var/www/html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\Model\Version->save()\n #1 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\Model\Element\AbstractElement->doSaveVersion(NULL, false, true, false)\n #2 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\Model\DataObject\Concrete->saveVersion(false, false, NULL)\n #3 /var/www/html/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\Model\DataObject\Concrete->update(true, Array)\n #4 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\Model\DataObject\AbstractObject->save(Array)\n #5 /var/www/html/vendor/pimcore/admin-ui-classic-bundle/src/Controller/Admin/DataObject/DataObjectController.php(1391): Pimcore\Model\DataObject\Concrete->save()\n #6 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\Bundle\AdminBundle\Controller\Admin\DataObject\DataObjectController->saveAction(Object(Symfony\Component\HttpFoundation\Request))\n #7 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)\n #8 /var/www/html/vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)\n #9 /var/www/html/public/index.php(36): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))\n #10 {main} """ 4 null null 0 "fs" ] |
| 134 | 8.48 ms |
"COMMIT"
Parameters:
[] |
| 135 | 0.20 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_cache_write_lock" ] |
| 136 | 0.14 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_cache_write_lock" ] |
| 137 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "system_cache_write_lock" ] |
| 138 | 0.13 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1773310168 "\x00tags\x00system_cache_write_lock" ] |
| 139 | 8.95 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 30 3 => 1773310168 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"oít\x07À\x1E";i:1773310168;}" ] |
| 140 | 4.14 ms |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_1913\x01tags\x01" "object_properties\x01tags\x01" ] |
| 141 | 0.23 ms |
SELECT * FROM object_relations_18 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 142 | 0.16 ms |
SELECT * FROM object_relations_19 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 143 | 0.15 ms |
SELECT * FROM object_relations_20 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 144 | 0.15 ms |
SELECT * FROM object_relations_7 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 145 | 0.16 ms |
SELECT * FROM object_relations_6 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 146 | 0.15 ms |
SELECT * FROM object_relations_8 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 147 | 0.16 ms |
SELECT * FROM object_relations_9 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 148 | 0.15 ms |
SELECT * FROM object_relations_17 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 149 | 0.15 ms |
SELECT * FROM object_relations_15 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "aziende_collegate" ] |
| 150 | 0.15 ms |
SELECT * FROM object_relations_21 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 151 | 0.15 ms |
SELECT * FROM object_relations_11 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 1913 "related_companies" ] |
| 152 | 0.79 ms |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 1913 ] |
| 153 | 0.09 ms |
"START TRANSACTION"
Parameters:
[] |
| 154 | 0.36 ms |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[ "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:26:\"messenger.bus.pimcore-core\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:69:\"Pimcore\\Bundle\\SimpleBackendSearchBundle\\Message\\SearchBackendMessage\":2:{s:7:\"\0*\0type\";s:6:\"object\";s:5:\"\0*\0id\";i:1913;}}" "[]" "pimcore_search_backend_message" "2026-03-12 10:09:28" "2026-03-12 10:09:28" ] |
| 155 | 8.17 ms |
"COMMIT"
Parameters:
[] |
| 156 | 0.25 ms |
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
"/Firm/Carrozzeria Touring (1913)/%"
]
|
| 157 | 0.16 ms |
SELECT id FROM tree_locks WHERE id IN (1,150) AND `type`='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
| 158 | 0.17 ms |
SELECT 1 FROM objects o WHERE parentId = ? AND `type` IN ('object','folder') LIMIT 1
Parameters:
[
1913
]
|
| 159 | 0.20 ms |
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
"/Firm/Carrozzeria Touring (1913)/%"
]
|
| 160 | 0.16 ms |
SELECT id FROM tree_locks WHERE id IN (1,150) AND `type`='object' AND locked = 'propagate' LIMIT 1
Parameters:
[] |
| 161 | 0.14 ms |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
1913
]
|
| 162 | 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:
[
1913
]
|
| 163 | 0.17 ms |
SELECT * FROM object_store_21 WHERE oo_id = ? FOR UPDATE
Parameters:
[
1913
]
|
| 164 | 0.11 ms |
select `nameEntryParallel` from object_store_21 where oo_id = 1913
Parameters:
[] |
| 165 | 0.18 ms |
SELECT * FROM object_localized_data_21 WHERE ooo_id = ? AND language IN ('en','it')
Parameters:
[
1913
]
|
| 166 | 0.12 ms |
select `responsabilita_block` from object_store_21 where oo_id = 1913
Parameters:
[] |
| 167 | 0.11 ms |
select `link_esterni` from object_store_21 where oo_id = 1913
Parameters:
[] |
| 168 | 0.13 ms |
SELECT * FROM object_relations_21 WHERE src_id = ?
Parameters:
[
1913
]
|
| 169 | 0.20 ms |
SELECT id FROM versions WHERE `ctype` = ? AND cid = ? AND `autoSave` = 1 AND userId = ?
Parameters:
[ "object" 1913 2 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.