GET https://waldkicker.org/api/teams/4489/tasks-quota

Query Metrics

154 Database Queries
21 Different statements
99.91 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
79.72 ms
(79.79%)
65
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:
[
  1768893262
  "site_domain_083208fa9ece965bc74c6f049f9b33ad"
]
10.65 ms
(10.66%)
54
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:
[
  1768893262
  "system\x01tags\x01"
  "site\x01tags\x01"
]
1.72 ms
(1.73%)
8
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:
[
  1768893263
  "object_604\x01tags\x01"
  "class_wk_task_template\x01tags\x01"
  "asset_16823\x01tags\x01"
  "asset_16824\x01tags\x01"
  "asset_16825\x01tags\x01"
]
1.49 ms
(1.49%)
5
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/api/teams/4489/"
  "tasks-quota"
]
0.80 ms
(0.80%)
4
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/api/teams/4489/tasks-quota"
]
0.78 ms
(0.78%)
1
SELECT taskTemplate__id, COUNT(*) as count
            FROM object_wk_task
            WHERE team__id = ?
            AND taskTemplate__id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
            AND date >= ?
            AND status != 'rejected'
            GROUP BY taskTemplate__id
Parameters:
[
  4489
  618
  5679
  6547
  8828
  10456
  604
  605
  611
  624
  625
  4397
  4413
  4415
  4416
  4421
  4422
  4423
  4424
  4427
  4429
  4430
  4431
  4433
  4435
  4439
  4440
  4442
  4444
  4445
  "2025-09-01 00:00:00"
]
0.42 ms
(0.42%)
1
SELECT object_wk_user.id as id, object_wk_user.type as `type` FROM object_wk_user WHERE (`apiToken` = '68e903faefba61a6edc4f52a56a265477489b50afe28ee8695d8db7de24c7526'  AND  object_wk_user.type IN ('variant','object')) AND object_wk_user.published = 1 LIMIT 1
Parameters:
[]
0.42 ms
(0.42%)
1
SELECT object_wk_task_template.id as id, object_wk_task_template.type as `type` FROM object_wk_task_template WHERE ( object_wk_task_template.type IN ('object','variant','folder')) AND object_wk_task_template.published = 1
Parameters:
[]
0.39 ms
(0.39%)
2
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "wk_user"
]
0.38 ms
(0.38%)
1
SELECT taskTemplate__id, COUNT(*) as count
            FROM object_wk_task
            WHERE team__id = ?
            AND taskTemplate__id IN (?,?,?,?,?,?,?,?)
            AND date >= ?
            AND status != 'rejected'
            GROUP BY taskTemplate__id
Parameters:
[
  4489
  619
  622
  4417
  4418
  4426
  4428
  4436
  4438
  "2026-01-01 00:00:00"
]
0.38 ms
(0.38%)
1
SELECT taskTemplate__id, COUNT(*) as count
            FROM object_wk_task
            WHERE team__id = ?
            AND taskTemplate__id IN (?,?,?,?)
            AND date >= ?
            AND status != 'rejected'
            GROUP BY taskTemplate__id
Parameters:
[
  4489
  623
  614
  615
  4412
  "1970-01-01 00:00:00"
]
0.38 ms
(0.38%)
2
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
0.37 ms
(0.37%)
1
SELECT taskTemplate__id, COUNT(*) as count
            FROM object_wk_task
            WHERE team__id = ?
            AND taskTemplate__id IN (?,?,?,?,?,?,?,?,?,?)
            AND date >= ?
            AND status != 'rejected'
            GROUP BY taskTemplate__id
Parameters:
[
  4489
  607
  612
  613
  616
  617
  4414
  4419
  4420
  4425
  4441
  "2026-01-01 00:00:00"
]
0.36 ms
(0.36%)
1
SELECT taskTemplate__id, COUNT(*) as count
            FROM object_wk_task
            WHERE team__id = ?
            AND taskTemplate__id IN (?,?,?,?,?,?,?)
            AND date >= ?
            AND status != 'rejected'
            GROUP BY taskTemplate__id
Parameters:
[
  4489
  606
  608
  609
  610
  626
  627
  629
  "2026-01-19 00:00:00"
]
0.31 ms
(0.31%)
1
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:
[
  "/api/teams/4489/tasks-quota"
  "path"
  "auto_create"
  "/api/teams/4489/tasks-quota"
  "path_query"
  "https://waldkicker.org/api/teams/4489/tasks-quota"
  "entire_uri"
]
0.28 ms
(0.28%)
1
SELECT * FROM object_relations_wk_user WHERE src_id = ?
Parameters:
[
  4597
]
0.25 ms
(0.25%)
1
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:
[
  1768893263
  "document_1\x01tags\x01"
  "asset_682\x01tags\x01"
  "asset_737\x01tags\x01"
  "asset_947\x01tags\x01"
  "asset_1224\x01tags\x01"
  "asset_1333\x01tags\x01"
]
0.24 ms
(0.24%)
1
SELECT * FROM object_relations_wk_team WHERE src_id = ?
Parameters:
[
  4489
]
0.21 ms
(0.21%)
1
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:
[
  1768893263
  "object_4489\x01tags\x01"
  "class_wk_team\x01tags\x01"
  "asset_1378\x01tags\x01"
  "asset_3504\x01tags\x01"
]
0.20 ms
(0.20%)
1
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:
[
  1768893262
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
0.18 ms
(0.18%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]

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.