Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

68 Database Queries

15 Different statements

38.77 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
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)
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 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)
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 * FROM users WHERE `type` = ? AND `name` = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
DELETE FROM cache_items WHERE item_id IN (?)
DELETE 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 (?)
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT assets.id, assets.type FROM assets WHERE (parentId = ?)  ORDER BY FIELD(assets.type, 'folder') DESC, CAST(assets.filename AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 100
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 assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
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 assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
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 (?)
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 assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT COUNT(*) FROM assets WHERE (parentId = ?)
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 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 (?)
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 (?)
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 id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
SELECT COUNT(*) AS count FROM assets WHERE parentId = ?

#▲	Time	Info
1	0.53 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 2`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 2;
2	0.31 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 2;
3	0.24 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 2;
4	0.31 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 2;
5	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: [`1780342472 [ "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6" "appb5003cab61b59631c83b2e65817e0bebe98e50d6" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6', 'appb5003cab61b59631c83b2e65817e0bebe98e50d6');
6	0.24 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: [`1780342472 [ "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6" "appb5003cab61b59631c83b2e65817e0bebe98e50d6" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6', 'appb5003cab61b59631c83b2e65817e0bebe98e50d6');
7	3.33 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: [`1 => null 2 => null 3 => 300 4 => 1780342472`] 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 (NULL, NULL, 300, 1780342472) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
8	2.78 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: [`1 => null 2 => null 3 => 300 4 => 1780342472`] 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 (NULL, NULL, 300, 1780342472) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
9	0.33 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: [`1780342472 [ "\x00tags\x00app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" "app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', 'app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');
10	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: [`1780342472 [ "\x00tags\x00app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" "app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', 'app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');
11	2.63 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: [`1 => null 2 => null 3 => 300 4 => 1780342472`] 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 (NULL, NULL, 300, 1780342472) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
12	2.93 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: [`1 => null 2 => null 3 => 300 4 => 1780342472`] 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 (NULL, NULL, 300, 1780342472) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
13	0.43 ms	SELECT * FROM users WHERE `type` = ? AND `name` = ? Parameters: [`"user" "custompuzzles"`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND `name` = ? SELECT * FROM users WHERE `type` = 'user' AND `name` = 'custompuzzles';
14	0.47 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 2;
15	0.40 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 2;
16	0.52 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 2;
17	2.90 ms	DELETE FROM cache_items WHERE item_id IN (?) Parameters: [`[ "appb5003cab61b59631c83b2e65817e0bebe98e50d6" "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6" ]`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?) DELETE FROM cache_items WHERE item_id IN ('appb5003cab61b59631c83b2e65817e0bebe98e50d6', '\0tags\0appb5003cab61b59631c83b2e65817e0bebe98e50d6');
18	2.72 ms	DELETE FROM cache_items WHERE item_id IN (?) Parameters: [`[ "app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" "\x00tags\x00app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1" ]`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?) DELETE FROM cache_items WHERE item_id IN ('app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1', '\0tags\0app8f1c84fa2006b5035d3d2eec227d86fa0c8a24d1');
19	0.63 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: [`1780342472 [ "\x00tags\x00asset_1679" "asset_1679" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1679', 'asset_1679');
20	0.28 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: [`1780342472 [ "asset_1679\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1679\0tags\0');
21	0.40 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1679`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1679 LIMIT 1;;
22	0.66 ms	SELECT assets.id, assets.type FROM assets WHERE (parentId = ?) ORDER BY FIELD(assets.type, 'folder') DESC, CAST(assets.filename AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 100 Parameters: [`1679`] View formatted query View runnable query Explain query SELECT assets.id, assets.type FROM assets WHERE (parentId = ?) ORDER BY FIELD(assets.type, 'folder') DESC, CAST( assets.filename AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci ASC LIMIT 100 SELECT assets.id, assets.type FROM assets WHERE (parentId = 1679) ORDER BY FIELD(assets.type, 'folder') DESC, CAST(assets.filename AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC LIMIT 100;
23	1.03 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: [`1780342472 [ "\x00tags\x00asset_1684" "asset_1684" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1684', 'asset_1684');
24	0.46 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1684`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1684;
25	0.29 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1684`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1684;
26	0.35 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: [`1780342472 [ "\x00tags\x00asset_1683" "asset_1683" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1683', 'asset_1683');
27	0.37 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1683`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1683;
28	0.27 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1683`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1683;
29	0.32 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: [`1780342472 [ "\x00tags\x00asset_1682" "asset_1682" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1682', 'asset_1682');
30	0.24 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: [`1780342472 [ "asset_1682\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1682\0tags\0');
31	0.31 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: [`1780342472 [ "\x00tags\x00asset_1681" "asset_1681" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1681', 'asset_1681');
32	0.33 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: [`1780342472 [ "asset_1681\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1681\0tags\0');
33	0.32 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: [`1780342472 [ "\x00tags\x00asset_1680" "asset_1680" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1680', 'asset_1680');
34	0.30 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1680`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1680;
35	0.34 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`1680`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 1680;
36	0.29 ms	SELECT COUNT() FROM assets WHERE (parentId = ?) Parameters: [`1679`] View formatted query View runnable query Explain query SELECT COUNT() FROM assets WHERE (parentId = ?) SELECT COUNT(*) FROM assets WHERE (parentId = 1679) ;
37	0.37 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/File\_000.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/File\\_000.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
38	0.32 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: [`1780342472 [ "\x00tags\x00asset_1480" "asset_1480" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1480', 'asset_1480');
39	0.25 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: [`1780342472 [ "asset_1480\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1480\0tags\0');
40	0.42 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: [`1780342472 [ "\x00tags\x00asset_696" "asset_696" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_696', 'asset_696');
41	0.30 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: [`1780342472 [ "asset_696\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_696\0tags\0');
42	0.31 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: [`1780342472 [ "\x00tags\x00asset_1" "asset_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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_1', 'asset_1');
43	0.30 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: [`1780342472 [ "asset_1\x00tags\x00" ]`] 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 > 1780342472 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1\0tags\0');
44	0.32 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
45	0.25 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1684`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1684 LIMIT 1;;
46	0.40 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/File\_000.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/File\\_000.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
47	0.28 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
48	0.33 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/fotopuzzle6040.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/fotopuzzle6040.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
49	0.27 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
50	0.33 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1683`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1683 LIMIT 1;;
51	0.44 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/fotopuzzle6040.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/fotopuzzle6040.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
52	0.31 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
53	0.43 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/lasergravur\_birke.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/lasergravur\\_birke.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
54	0.36 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
55	0.28 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1682`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1682 LIMIT 1;;
56	0.47 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/lasergravur\_birke.jpeg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/lasergravur\\_birke.jpeg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
57	0.31 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
58	0.35 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/mentzl.jpg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/mentzl.jpg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
59	0.31 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
60	0.20 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1681`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1681 LIMIT 1;;
61	0.37 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/mentzl.jpg/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/mentzl.jpg/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
62	0.21 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
63	0.26 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/rueckwandfuerpuzzles.JPG/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/rueckwandfuerpuzzles.JPG/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
64	0.21 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
65	0.21 ms	SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; Parameters: [`1680`] View formatted query View runnable query Explain query SELECT `a`.`id` FROM `assets` a WHERE parentId = ? LIMIT 1; SELECT `a`.`id` FROM `assets` a WHERE parentId = 1680 LIMIT 1;;
66	0.27 ms	SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/custompuzzles/cp-products/kundenfotos/rueckwandfuerpuzzles.JPG/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE '/custompuzzles/cp-products/kundenfotos/rueckwandfuerpuzzles.JPG/%' AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
67	0.26 ms	SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 1679, 1480, 696) AND type = 'asset' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1;
68	0.24 ms	SELECT COUNT() AS count FROM assets WHERE parentId = ? Parameters: [`1679`] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM assets WHERE parentId = ? SELECT COUNT(*) AS count FROM assets WHERE parentId = 1679;

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.

Symfony Profiler

https://custompuzzles-xxl.com/admin/asset/tree-get-childs-by-id?_dc=1780342472860&fromPaging=0&limit=100&node=1679&page=1&start=0&view=

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache