Symfony Profiler

Query Metrics

19 Database Queries

6 Different statements

17.57 ms Query time

0 Invalid entities

0 Managed entities

Queries


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 (?)
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
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 (?)
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 (?)
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 (?)
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)
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 (?)
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 (?)
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 (?)
SELECT * FROM object_url_slugs WHERE slug = '/pimcore-studio/api/login' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

#▲	Time	Info
1	0.53 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: [`1785852659 "app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832');
2	4.54 ms	DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) Parameters: [`1785852659 "app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) DELETE FROM cache_items WHERE item_lifetime + item_time <= 1785852659 AND item_id IN ('app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832');
3	0.77 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: [`1785852659 "app:\x00tags\x009bd0e65a2b1efa45cea7c2703fd8b8a75daa5832"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:\0tags\09bd0e65a2b1efa45cea7c2703fd8b8a75daa5832');
4	0.50 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: [`1785852659 "app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832');
5	0.46 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: [`1785852659 "app:\x00tags\x009bd0e65a2b1efa45cea7c2703fd8b8a75daa5832"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:\0tags\09bd0e65a2b1efa45cea7c2703fd8b8a75daa5832');
6	3.86 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 => 119 3 => 1785852659 0 => "app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832" 1 => b"O:1:"©":1:{s:6:"ãO4\x08À\x1E";O:50:"Symfony\Component\RateLimiter\Policy\SlidingWindow":1:{s:41:"\x00\x00\x00\x01\x00\x00\x00\x00\x00\x00\x00<studio_api_general-172.18.0.3";d:1785852719.119075;}}"`] View formatted query View runnable query Explain query 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) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (119, 1785852659, 'app:9bd0e65a2b1efa45cea7c2703fd8b8a75daa5832', 0x4F3A313A22A9223A313A7B733A363A22E34F3408C01E223B4F3A35303A2253796D666F6E795C436F6D706F6E656E745C526174654C696D697465725C506F6C6963795C536C6964696E6757696E646F77223A313A7B733A34313A2200000001000000000000003C73747564696F5F6170695F67656E6572616C2D3137322E31382E302E33223B643A313738353835323731392E3131393037353B7D7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
7	0.91 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: [`1785852659 "maintenance_mode"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
8	0.67 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-studio/api/" "login"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/pimcore-studio/api/' AND `key` = BINARY 'login';
9	0.47 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-studio/api/login"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-studio/api/login';
10	0.42 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-studio/api/" "login"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/pimcore-studio/api/' AND `key` = BINARY 'login';
11	0.34 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-studio/api/login"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-studio/api/login';
12	0.35 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/pimcore-studio/" "api"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/pimcore-studio/' AND `key` = BINARY 'api';
13	0.42 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-studio/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-studio/api';
14	0.76 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "pimcore-studio"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-studio';
15	0.74 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/pimcore-studio"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-studio';
16	0.52 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';
17	0.47 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: [`1785852659 "document_1"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
18	0.47 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: [`1785852659 "document_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785852659 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
19	0.37 ms	SELECT * FROM object_url_slugs WHERE slug = '/pimcore-studio/api/login' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/pimcore-studio/api/login' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/pimcore-studio/api/login' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

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.

Symfony Profiler

GET http://staging.pimcore-studio.waelzholz.remind-vps.de/pimcore-studio/api/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping