GET https://demo.jakobaio.dev/teams/10

Query Metrics

50 Database Queries
11 Different statements
11.38 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.17 ms
(36.61%)
21
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:
[
  1768452076
  "site_domain_2bffa610fd526a079e2975e1cb0491f5"
]
1.83 ms
(16.10%)
9
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:
[
  1768452076
  "system\x01tags\x01"
  "site\x01tags\x01"
]
1.16 ms
(10.24%)
4
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  23
]
1.02 ms
(8.94%)
4
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  23
]
0.84 ms
(7.40%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/teams/"
  "10"
]
0.71 ms
(6.21%)
3
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:
[
  1768452076
  "object_10\x01tags\x01"
  "class_2\x01tags\x01"
  "asset_23\x01tags\x01"
]
0.56 ms
(4.94%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/teams/10"
]
0.53 ms
(4.66%)
1
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
  10
]
0.20 ms
(1.73%)
1
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
Parameters:
[
  "/Portraits/Players/"
  "Default.png"
]
0.19 ms
(1.63%)
1
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "2"
]
0.17 ms
(1.54%)
1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  1
]

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.