GET https://waldkicker.org/admin/asset/get-preview-document?_dc=1768917970458&id=22507

Query Metrics

25 Database Queries
18 Different statements
5.38 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
2 0.24 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
3 0.36 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/admin/asset/get-preview-document"
  "path"
  "auto_create"
  "/admin/asset/get-preview-document?id=22507&_dc=1768917970458"
  "path_query"
  "https://waldkicker.org/admin/asset/get-preview-document?_dc=1768917970458&id=22507"
  "entire_uri"
]
4 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:
[
  1768927496
  "system_route_redirect"
]
5 0.21 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:
[
  1768927496
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
6 0.18 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
7 0.26 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  8
]
8 0.20 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  8
]
9 0.19 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  8
]
10 0.23 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  8
]
11 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:
[
  1768927496
  "asset_22507"
]
12 0.17 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:
[
  1768927496
  "asset_22507\x01tags\x01"
]
13 0.19 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  22507
]
14 0.22 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300)
Parameters:
[
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
15 0.22 ms
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP(NOW(6)))
Parameters:
[
  300.0
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
16 0.18 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
17 0.14 ms
"START TRANSACTION"
Parameters:
[]
18 0.21 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:41:\"Pimcore\\Messenger\\AssetUpdateTasksMessage\":1:{s:5:\"\0*\0id\";i:22507;}}"
  "[]"
  "pimcore_asset_update"
  "2026-01-20 16:44:56"
  "2026-01-20 16:44:56"
]
19 0.14 ms
"COMMIT"
Parameters:
[]
20 0.19 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
21 0.18 ms
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
22 0.18 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))
Parameters:
[
  "25e1fd6cd619c75d183ac763abdd8efe02e74185ba2009c0997e6df0721dcedf"
  "3Eqgww0gVX04RbAJT68rFPRh9cL2a15WH9s1iK0QFUA="
]
23 0.22 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
24 0.30 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:
[
  1768927496
  "translation_data_2e364d315ad5ad984609e7f4beedf0f7"
]
25 0.21 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:
[
  1768927496
  "translator\x01tags\x01"
  "translator_website\x01tags\x01"
  "translate\x01tags\x01"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
SeoBundle\Model\ElementMetaData No errors.