Symfony Profiler

Query Metrics

105 Database Queries

34 Different statements

1009.49 ms Query time

0 Invalid entities

Queries


SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
SELECT id,domains FROM sites
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
SELECT id FROM redirects WHERE active = 1 AND regex = 1  ORDER BY `priority` DESC
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CAR WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
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 * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97'
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CAR WHERE oo_id = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_MA WHERE oo_id = ?
SELECT name FROM classes WHERE 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 * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_relations_MA WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CA WHERE oo_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_CA WHERE oo_id = ?
SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_CA WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?

#▲	Time	Info
1	4.50 ms	SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ? Parameters: [`"pimcoredemo.edelsau.uber.space" "%"pimcoredemo.edelsau.uber.space"%"`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ? SELECT * FROM sites WHERE mainDomain = 'pimcoredemo.edelsau.uber.space' OR domains LIKE '%\"pimcoredemo.edelsau.uber.space\"%';
2	3.78 ms	SELECT id,domains FROM sites Parameters: [] View formatted query View runnable query Explain query SELECT id, domains FROM sites SELECT id,domains FROM sites;
3	2.27 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
4	5.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
5	12.66 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97" "path" "auto_create" "/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97" "path_query" "https://pimcoredemo.edelsau.uber.space/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97' AND `type` = 'path_query') OR (source = 'https://pimcoredemo.edelsau.uber.space/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
6	16.62 ms	INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300) Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw="`] View formatted query View runnable query Explain query INSERT INTO lock_keys ( key_id, key_token, key_expiration ) VALUES ( ?, ?, UNIX_TIMESTAMP() + 300 ) INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071', 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=', UNIX_TIMESTAMP() + 300);
7	2.76 ms	UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP()) Parameters: [`300.0 "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=" "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw="`] View formatted query View runnable query Explain query UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND ( key_token = ? OR key_expiration <= UNIX_TIMESTAMP() ) UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=' WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND (key_token = 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=' OR key_expiration <= UNIX_TIMESTAMP());
8	3.25 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() SELECT 1 FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=' AND key_expiration > UNIX_TIMESTAMP();
9	5.43 ms	SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC;
10	18.30 ms	DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw="`] View formatted query View runnable query Explain query DELETE FROM lock_keys WHERE key_id = ? AND key_token = ? DELETE FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=';
11	1.20 ms	SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() Parameters: [`"56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw="`] View formatted query View runnable query Explain query SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP() SELECT 1 FROM lock_keys WHERE key_id = '56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071' AND key_token = 'IkBwrs+HnaoCM8sRMgLa7w9lTORtysNPylvjrE7zDYw=' AND key_expiration > UNIX_TIMESTAMP();
12	2.45 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
13	5.02 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
14	3.01 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/shop/Fahrzeuge/Sport--Leistung/" "Ferrari~p97"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/de/shop/Fahrzeuge/Sport--Leistung/' AND `key` = BINARY 'Ferrari~p97';
15	3.05 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97';
16	1.53 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/shop/Fahrzeuge/" "Sport--Leistung"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/de/shop/Fahrzeuge/' AND `key` = BINARY 'Sport--Leistung';
17	6.37 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/shop/Fahrzeuge/Sport--Leistung"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/shop/Fahrzeuge/Sport--Leistung';
18	4.03 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/shop/" "Fahrzeuge"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/de/shop/' AND `key` = BINARY 'Fahrzeuge';
19	1.05 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/shop/Fahrzeuge"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/shop/Fahrzeuge';
20	3.90 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/" "shop"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'shop';
21	3.44 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de/shop';
22	2.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "de"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'de';
23	4.46 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 136;
24	5.71 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 136;
25	6.08 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 1;
26	6.51 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 1;
27	1.26 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`136`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = 136 ) AND ctype='document';
28	0.75 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`97`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 97;
29	2.08 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`97`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 97;
30	5.56 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`97`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 97;
31	4.76 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CAR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CAR';
32	2.30 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
33	4.25 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`97`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 97 AND language IN ('en','de','fr');
34	2.93 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: [`79`] 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 = 79;
35	1.37 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`79`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 79;
36	3.39 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: [`79`] 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 = 79;
37	1.87 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`79`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 79;
38	4.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: [`80`] 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 = 80;
39	1.97 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`80`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 80;
40	2.13 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: [`80`] 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 = 80;
41	2.30 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`80`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 80;
42	1.03 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: [`81`] 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 = 81;
43	9.61 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`81`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 81;
44	9.47 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: [`81`] 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 = 81;
45	1.51 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`81`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 81;
46	9.03 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: [`83`] 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 = 83;
47	1.24 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`83`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 83;
48	32.39 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: [`83`] 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 = 83;
49	6.04 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`83`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 83;
50	35.85 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? Parameters: [`97 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = 97 AND fieldname = 'attributes';
51	5.54 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? Parameters: [`97 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE id = 97 AND fieldname = 'attributes';
52	3.45 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? Parameters: [`97 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = 97 AND fieldname = 'attributes';
53	4.93 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? Parameters: [`97 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE id = 97 AND fieldname = 'attributes';
54	3.04 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? Parameters: [`97 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = 97 AND fieldname = 'saleInformation';
55	13.71 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`97`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 97;
56	2.79 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97';
57	49.50 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 95;
58	3.76 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 95;
59	12.77 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 95;
60	1.17 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`95`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 95 AND language IN ('en','de','fr');
61	0.87 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? Parameters: [`95 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE id = 95 AND fieldname = 'attributes';
62	4.68 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? Parameters: [`95 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE id = 95 AND fieldname = 'attributes';
63	1.25 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? Parameters: [`95 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE id = 95 AND fieldname = 'attributes';
64	0.80 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? Parameters: [`95 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE id = 95 AND fieldname = 'attributes';
65	2.73 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? Parameters: [`95 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE id = 95 AND fieldname = 'saleInformation';
66	2.73 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`95`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 95;
67	4.76 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`93`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 93;
68	11.25 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`93`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 93;
69	1.11 ms	SELECT * FROM object_store_MA WHERE oo_id = ? Parameters: [`93`] View formatted query View runnable query Explain query SELECT * FROM object_store_MA WHERE oo_id = ? SELECT * FROM object_store_MA WHERE oo_id = 93;
70	2.71 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"MA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'MA';
71	3.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: [`299`] 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 = 299;
72	0.98 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`299`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = 299;
73	1.01 ms	SELECT * FROM object_relations_MA WHERE src_id = ? Parameters: [`93`] View formatted query View runnable query Explain query SELECT * FROM object_relations_MA WHERE src_id = ? SELECT * FROM object_relations_MA WHERE src_id = 93;
74	6.58 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`94`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 94;
75	1.02 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`94`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 94;
76	4.88 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 2;
77	2.18 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 2;
78	2.66 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`744`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 744;
79	3.89 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`744`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 744;
80	5.11 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 1;
81	4.16 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 1;
82	1.52 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
83	15.98 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 559;
84	3.28 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 559;
85	2.22 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 559;
86	1.33 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CA';
87	1.48 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 559 AND language IN ('en','de','fr');
88	2.89 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 559;
89	2.34 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 545;
90	2.67 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 545;
91	0.63 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 545;
92	3.39 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 545 AND language IN ('en','de','fr');
93	1.72 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`545`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 545;
94	141.05 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 390;
95	4.12 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 390;
96	4.57 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 390;
97	4.86 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 390 AND language IN ('en','de','fr');
98	9.92 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`390`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 390;
99	110.24 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 564;
100	0.71 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 564;
101	0.37 ms	SELECT * FROM object_store_CA WHERE oo_id = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_store_CA WHERE oo_id = ? SELECT * FROM object_store_CA WHERE oo_id = 564;
102	0.64 ms	SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CA WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CA WHERE ooo_id = 564 AND language IN ('en','de','fr');
103	0.56 ms	SELECT * FROM object_relations_CA WHERE src_id = ? Parameters: [`564`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CA WHERE src_id = ? SELECT * FROM object_relations_CA WHERE src_id = 564;
104	8.32 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`389`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 389;
105	233.34 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`389`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 389;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://pimcoredemo.edelsau.uber.space/de/shop/Fahrzeuge/Sport--Leistung/Ferrari~p97

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping