Query Metrics
84
Database Queries
24
Different statements
135.33 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
19.51 ms (14.42%) |
11 |
SELECT object_5.o_id as o_id, object_5.o_type as o_type FROM object_5 WHERE (`kv_id` = '1' AND object_5.o_type IN ('object','folder')) AND object_5.o_published = 1 LIMIT 1
Parameters:
[] |
15.08 ms (11.14%) |
14 |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Aufträge" "path" => "/" ] |
12.19 ms (9.01%) |
6 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '57' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
10.70 ms (7.91%) |
5 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '321' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
10.54 ms (7.79%) |
5 |
SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`kv_id` = '5' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1 LIMIT 1
Parameters:
[] |
10.48 ms (7.74%) |
6 |
SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`kv_id` = '9' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1 LIMIT 1
Parameters:
[] |
9.24 ms (6.83%) |
5 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '468' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
6.09 ms (4.50%) |
1 |
INSERT INTO application_logs (`pid`, `priority`, `message`, `timestamp`, `component`, `fileobject`, `relatedobject`, `relatedobjecttype`, `source`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 28794 "info" "Received 1473 Transportlauf items from CAT (0.795s) # 8f8a641a09ab268a91c611021c32b61d ## pimcore-website-fpm-5d9bcbc47-qhqqb" "2024-09-28 18:06:29" "app" null null null "KVBundle\Service\CatJsonWebservice::log:78" ] |
5.82 ms (4.30%) |
3 |
SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`kv_id` = '36' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1 LIMIT 1
Parameters:
[] |
5.62 ms (4.16%) |
4 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '2590' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
4.23 ms (3.13%) |
2 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '570' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
3.91 ms (2.89%) |
3 |
SELECT object_5.o_id as o_id, object_5.o_type as o_type FROM object_5 WHERE (`kv_id` = '0' AND object_5.o_type IN ('object','folder')) AND object_5.o_published = 1 LIMIT 1
Parameters:
[] |
3.72 ms (2.75%) |
4 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
2.61 ms (1.93%) |
1 |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '1' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/data/auftraege-meta" "sourcePathQuery" => "/data/auftraege-meta" "sourceEntireUri" => "http://kv-tracking-staging.m2.krankikom.de/data/auftraege-meta" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
2.26 ms (1.67%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '432' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
2.02 ms (1.50%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '14337' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
2.00 ms (1.48%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '732' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
1.86 ms (1.37%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '381' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
1.68 ms (1.24%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '14333' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
1.43 ms (1.05%) |
1 |
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (`kv_id` = '486' AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 LIMIT 1
Parameters:
[] |
1.43 ms (1.05%) |
3 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "auftraege-meta" "path" => "/KV/data/" ] |
1.16 ms (0.86%) |
2 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/KV/%" "/data/auftraege-meta" ] |
0.88 ms (0.65%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/KV/data/auftraege-meta" ] |
0.85 ms (0.63%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
SeoBundle\Model\ElementMetaData | No errors. |