POST https://enterprise-demo.pimcoredemos.com/pimcore-studio/api/login

Query Metrics

15 Database Queries
8 Different statements
4.65 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 0.19 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:
[
  1793178873
  "app:a629dfe7d43d31c8d162099df8f2d238b4363fed"
]
3 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:
[
  1793178873
  "app:a629dfe7d43d31c8d162099df8f2d238b4363fed"
]
4 0.96 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 => 106
  3 => 1793178873
  0 => "app:a629dfe7d43d31c8d162099df8f2d238b4363fed"
  1 => b"O:1:"©":1:{s:6:"Ü\x19¤\x08À\x1E";O:50:"Symfony\Component\RateLimiter\Policy\SlidingWindow":1:{s:43:"\x00\x00\x00\x04\x00\x00\x00\x00\x00\x00\x00<studio_api_general-167.103.7.81";d:1793178920.66151;}}"
]
5 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:
[
  1793178873
  "maintenance_mode"
]
6 0.29 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:
[
  1793178873
  "app:c35f5f901c27833cd5d53f2c264d1139f140b20f"
]
7 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:
[
  1793178873
  "app:\x00tags\x00c35f5f901c27833cd5d53f2c264d1139f140b20f"
]
8 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:
[
  1793178873
  "app:dbb1fef036333c4321c742f05e25247d0dcac069"
]
9 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:
[
  1793178873
  "app:\x00tags\x00dbb1fef036333c4321c742f05e25247d0dcac069"
]
10 0.21 ms
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[
  "user"
  "Admin"
]
11 0.16 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  22
]
12 0.12 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  22
]
13 0.12 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  22
]
14 1.33 ms
UPDATE users SET lastLogin = ? WHERE id = ?
Parameters:
[
  1793178873
  22
]
15 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "default_embeddings"
  "backend_power_tools_embeddings"
]

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

No loaded entities.