Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

50 Database Queries

11 Different statements

32.81 ms Query time

0 Invalid entities

Queries

Group similar statements


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 redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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 * FROM object_url_slugs WHERE slug = '/productoverview' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules 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 name FROM classes WHERE 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 objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
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 name FROM classes WHERE 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 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 object_localized_PRODUCT_de.o_id as o_id, object_localized_PRODUCT_de.o_type as o_type FROM object_localized_PRODUCT_de LEFT JOIN object_collection_Specification_PRODUCT `Specification~specs` ON 1
 AND `Specification~specs`.o_id = `object_localized_PRODUCT_de`.o_id AND `Specification~specs`.fieldname = "specs" WHERE (categories LIKE '%object|195%' AND (categories LIKE ?)  AND (brand__id = ?)  AND (`Specification~specs`.specKey = 'Gehäusematerial' AND `Specification~specs`.specValue LIKE ?)  AND  object_localized_PRODUCT_de.o_type IN ('object','folder')) AND object_localized_PRODUCT_de.o_published = 1 ORDER BY `stockInputDate` DESC
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 name FROM classes WHERE 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 dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename

#▲	Time	Info
1	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: [`1747144483 [ "\x00tags\x00site_domain_2239a9e89b406913df9da6fa69aa8524" "site_domain_2239a9e89b406913df9da6fa69aa8524" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_2239a9e89b406913df9da6fa69aa8524', 'site_domain_2239a9e89b406913df9da6fa69aa8524');
2	0.48 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: [`1747144483 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_2239a9e89b406913df9da6fa69aa8524\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_2239a9e89b406913df9da6fa69aa8524\0tags\0');
3	1.34 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/productoverview" "sourcePathQuery" => "/productoverview?brand=73&collection=122&type=195&casematerial=stahl" "sourceEntireUri" => "http://www.zeit.at/productoverview?brand=73&casematerial=stahl&collection=122&type=195" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/productoverview' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/productoverview?brand=73&collection=122&type=195&casematerial=stahl' AND `type` = 'path_query') OR (source = 'http://www.zeit.at/productoverview?brand=73&casematerial=stahl&collection=122&type=195' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
4	0.71 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: [`1747144483 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	0.68 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: [`1747144483 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
6	0.56 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
7	0.66 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "productoverview" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'productoverview';
8	0.71 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: [`1747144483 [ "\x00tags\x00document_34" "document_34" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_34', 'document_34');
9	0.45 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: [`1747144483 [ "document_34\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_34\0tags\0');
10	0.43 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: [`1747144483 [ "\x00tags\x00document_properties_34" "document_properties_34" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_34', 'document_properties_34');
11	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: [`1747144483 [ "document_properties\x00tags\x00" "document_34\x00tags\x00" "document_properties_34\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_34\0tags\0', 'document_properties_34\0tags\0');
12	0.36 ms	SELECT * FROM object_url_slugs WHERE slug = '/productoverview' 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 = '/productoverview' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/productoverview' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
13	0.42 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	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: [`1747144483 [ "\x00tags\x00object_73" "object_73" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_73', 'object_73');
15	0.45 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: [`1747144483 [ "object_73\x00tags\x00" "class_BRAND\x00tags\x00" "asset_178\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_73\0tags\0', 'class_BRAND\0tags\0', 'asset_178\0tags\0');
16	0.35 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BRAND"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BRAND';
17	0.70 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: [`1747144483 [ "\x00tags\x00object_118" "object_118" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_118', 'object_118');
18	0.38 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: [`1747144483 [ "object_118\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_118\0tags\0');
19	0.84 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`118`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 118 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
20	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: [`1747144483 [ "\x00tags\x00object_10853" "object_10853" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_10853', 'object_10853');
21	0.39 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: [`1747144483 [ "object_10853\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10853\0tags\0', 'class_CATEGORY\0tags\0');
22	0.41 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CATEGORY"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CATEGORY';
23	0.41 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: [`1747144483 [ "\x00tags\x00object_121" "object_121" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_121', 'object_121');
24	0.39 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: [`1747144483 [ "object_121\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_121\0tags\0', 'class_CATEGORY\0tags\0');
25	1.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: [`1747144483 [ "\x00tags\x00object_122" "object_122" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_122', 'object_122');
26	0.83 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: [`1747144483 [ "object_122\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_122\0tags\0', 'class_CATEGORY\0tags\0');
27	0.84 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: [`1747144483 [ "\x00tags\x00object_119" "object_119" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_119', 'object_119');
28	0.62 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: [`1747144483 [ "object_119\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_119\0tags\0', 'class_CATEGORY\0tags\0');
29	0.78 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: [`1747144483 [ "\x00tags\x00object_123" "object_123" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_123', 'object_123');
30	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: [`1747144483 [ "object_123\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_123\0tags\0', 'class_CATEGORY\0tags\0');
31	0.73 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: [`1747144483 [ "\x00tags\x00object_120" "object_120" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_120', 'object_120');
32	0.40 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: [`1747144483 [ "object_120\x00tags\x00" "class_CATEGORY\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_120\0tags\0', 'class_CATEGORY\0tags\0');
33	4.91 ms	SELECT object_localized_PRODUCT_de.o_id as o_id, object_localized_PRODUCT_de.o_type as o_type FROM object_localized_PRODUCT_de LEFT JOIN object_collection_Specification_PRODUCT `Specification~specs` ON 1 AND `Specification~specs`.o_id = `object_localized_PRODUCT_de`.o_id AND `Specification~specs`.fieldname = "specs" WHERE (categories LIKE '%object\|195%' AND (categories LIKE ?) AND (brand__id = ?) AND (`Specification~specs`.specKey = 'Gehäusematerial' AND `Specification~specs`.specValue LIKE ?) AND object_localized_PRODUCT_de.o_type IN ('object','folder')) AND object_localized_PRODUCT_de.o_published = 1 ORDER BY `stockInputDate` DESC Parameters: [`"%object\|122%" "73" "%stahl%"`] View formatted query View runnable query Explain query SELECT object_localized_PRODUCT_de.o_id as o_id, object_localized_PRODUCT_de.o_type as o_type FROM object_localized_PRODUCT_de LEFT JOIN object_collection_Specification_PRODUCT `Specification~specs` ON 1 AND `Specification~specs`.o_id = `object_localized_PRODUCT_de`.o_id AND `Specification~specs`.fieldname = "specs" WHERE ( categories LIKE '%object\|195%' AND (categories LIKE ?) AND (brand__id = ?) AND ( `Specification~specs`.specKey = 'Gehäusematerial' AND `Specification~specs`.specValue LIKE ? ) AND object_localized_PRODUCT_de.o_type IN ('object', 'folder') ) AND object_localized_PRODUCT_de.o_published = 1 ORDER BY `stockInputDate` DESC SELECT object_localized_PRODUCT_de.o_id as o_id, object_localized_PRODUCT_de.o_type as o_type FROM object_localized_PRODUCT_de LEFT JOIN object_collection_Specification_PRODUCT `Specification~specs` ON 1 AND `Specification~specs`.o_id = `object_localized_PRODUCT_de`.o_id AND `Specification~specs`.fieldname = "specs" WHERE (categories LIKE '%object\|195%' AND (categories LIKE '%object\|122%') AND (brand__id = '73') AND (`Specification~specs`.specKey = 'Gehäusematerial' AND `Specification~specs`.specValue LIKE '%stahl%') AND object_localized_PRODUCT_de.o_type IN ('object','folder')) AND object_localized_PRODUCT_de.o_published = 1 ORDER BY `stockInputDate` DESC ;
34	0.60 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: [`1747144483 [ "\x00tags\x00object_5830" "object_5830" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_5830', 'object_5830');
35	0.45 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: [`1747144483 [ "object_5830\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_244416\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5830\0tags\0', 'class_PRODUCT\0tags\0', 'asset_244416\0tags\0');
36	0.35 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PRODUCT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PRODUCT';
37	0.52 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: [`1747144483 [ "\x00tags\x00object_5832" "object_5832" ]`] 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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_5832', 'object_5832');
38	0.45 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: [`1747144483 [ "object_5832\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_244418\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 > 1747144483 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5832\0tags\0', 'class_PRODUCT\0tags\0', 'asset_244418\0tags\0');
39	0.59 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`10853 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 10853 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
40	0.48 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 10853`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 10853 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;
41	0.41 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`121 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 121 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
42	0.55 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 121`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 121 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;
43	0.49 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`122 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 122 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
44	0.69 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 122`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 122 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;
45	0.40 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`119 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 119 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
46	0.54 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 119`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 119 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;
47	0.38 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`123 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 123 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
48	0.37 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 123`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 123 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;
49	0.34 ms	SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`120 "object"`] View formatted query View runnable query Explain query SELECT dependencies.targetid, dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype = "object" AND dependencies.targetid = objects.o_id LEFT JOIN assets ON dependencies.targettype = "asset" AND dependencies.targetid = assets.id LEFT JOIN documents ON dependencies.targettype = "document" AND dependencies.targetid = documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = 120 AND dependencies.sourcetype = 'object' ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename;
50	0.78 ms	SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename Parameters: [`"object" 120`] View formatted query View runnable query Explain query SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid = objects.o_id AND dependencies.sourcetype = "object" LEFT JOIN assets ON dependencies.sourceid = assets.id AND dependencies.sourcetype = "asset" LEFT JOIN documents ON dependencies.sourceid = documents.id AND dependencies.sourcetype = "document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = 'object' AND dependencies.targetid = 120 ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename ;

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

http://www.zeit.at/productoverview?brand=73&casematerial=stahl&collection=122&type=195

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache