Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

101 Database Queries

39 Different statements

131.28 ms Query time

0 Invalid entities

Queries

Group similar statements


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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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,55) AND inheritable = 1) OR cid = ? )  AND ctype='document'
SELECT * FROM object_url_slugs WHERE slug = '/fahrzeugboerse/fahrzeuge' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT id FROM website_settings
SELECT * FROM website_settings WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin WHERE language = ?
SELECT name FROM classes WHERE id = ?
SELECT object_vehicle.o_id as o_id, object_vehicle.o_type as o_type FROM object_vehicle WHERE ((`internalVehicleId` = ?)  AND  object_vehicle.o_type IN ('object','folder')) AND object_vehicle.o_published = 1
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT * FROM object_store_vehicle WHERE oo_id = ?
SELECT * FROM object_brick_store_vehicleBaseData_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Costs_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Exterieur_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Interieur_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Financing_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Leasing_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_TechnicalData_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_TechnicalDataMore_vehicle WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_relations_vehicle WHERE src_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 assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT 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_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_dealerLocation WHERE oo_id = ?
SELECT * FROM object_relations_dealerLocation WHERE src_id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.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.*, tree_locks.locked FROM documents
            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,5,3) AND inheritable = 1) OR cid = ? )  AND ctype='document'
SELECT * FROM documents_editables WHERE documentId = ?
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 t0.id AS id_1, t0.`name` AS name_2, t0.`group` AS group_3, t0.creationDate AS creationDate_4, t0.modificationDate AS modificationDate_5, t0.createdBy AS createdBy_6, t0.modifiedBy AS modifiedBy_7, t0.mailLayout AS mailLayout_8, t0.configuration AS configuration_9, t0.conditionalLogic AS conditionalLogic_10, t0.fields AS fields_11 FROM formbuilder_forms t0 WHERE t0.id = ?
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages WHERE language = ?

#▲	Time	Info
1	1.17 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" => "/fahrzeugboerse/fahrzeuge" "sourcePathQuery" => "/fahrzeugboerse/fahrzeuge?i=FBUD2211529" "sourceEntireUri" => "http://bmw-timmermanns-dev.m2.krankikom.de/fahrzeugboerse/fahrzeuge?i=FBUD2211529" "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 = '/fahrzeugboerse/fahrzeuge' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/fahrzeugboerse/fahrzeuge?i=FBUD2211529' AND `type` = 'path_query') OR (source = 'http://bmw-timmermanns-dev.m2.krankikom.de/fahrzeugboerse/fahrzeuge?i=FBUD2211529' 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;
2	0.99 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';
3	1.06 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "fahrzeuge" "path" => "/fahrzeugboerse/"`] 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 '/fahrzeugboerse/' AND `key` = BINARY 'fahrzeuge';
4	0.91 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: [`153`] 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 = 153;
5	0.95 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: [`153`] 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 = 153;
6	1.19 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: [`55`] 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 = 55;
7	1.42 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: [`55`] 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 = 55;
8	1.21 ms	SELECT * FROM properties WHERE ((cid IN (1,55) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`153`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 55) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ((cid IN (1,55) AND inheritable = 1) OR cid = 153 ) AND ctype='document';
9	1.15 ms	SELECT * FROM object_url_slugs WHERE slug = '/fahrzeugboerse/fahrzeuge' 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 = '/fahrzeugboerse/fahrzeuge' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/fahrzeugboerse/fahrzeuge' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
10	1.06 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;
11	1.35 ms	SELECT id FROM website_settings Parameters: [] View formatted query View runnable query Explain query SELECT id FROM website_settings SELECT id FROM website_settings;
12	1.11 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
13	1.14 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "quick-access-bar" "path" => "/shared/includes/"`] 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 '/shared/includes/' AND `key` = BINARY 'quick-access-bar';
14	1.01 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/shared/includes/quick-access-bar"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/shared/includes/quick-access-bar';
15	1.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`153`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 153;
16	1.13 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
17	1.41 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
18	5.23 ms	SELECT * FROM translations_admin WHERE language = ? Parameters: [`"de"`] View formatted query View runnable query Explain query SELECT * FROM translations_admin WHERE language = ? SELECT * FROM translations_admin WHERE language = 'de';
19	1.28 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"vehicle"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'vehicle';
20	1.48 ms	SELECT object_vehicle.o_id as o_id, object_vehicle.o_type as o_type FROM object_vehicle WHERE ((`internalVehicleId` = ?) AND object_vehicle.o_type IN ('object','folder')) AND object_vehicle.o_published = 1 Parameters: [`"FBUD2211529"`] View formatted query View runnable query Explain query SELECT object_vehicle.o_id as o_id, object_vehicle.o_type as o_type FROM object_vehicle WHERE ( (`internalVehicleId` = ?) AND object_vehicle.o_type IN ('object', 'folder') ) AND object_vehicle.o_published = 1 SELECT object_vehicle.o_id as o_id, object_vehicle.o_type as o_type FROM object_vehicle WHERE ((`internalVehicleId` = 'FBUD2211529') AND object_vehicle.o_type IN ('object','folder')) AND object_vehicle.o_published = 1;
21	0.94 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`1831`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 1831;
22	1.07 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`1831`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 1831;
23	0.95 ms	SELECT * FROM object_store_vehicle WHERE oo_id = ? Parameters: [`1831`] View formatted query View runnable query Explain query SELECT * FROM object_store_vehicle WHERE oo_id = ? SELECT * FROM object_store_vehicle WHERE oo_id = 1831;
24	1.47 ms	SELECT * FROM object_brick_store_vehicleBaseData_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Stammdaten"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_vehicleBaseData_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_vehicleBaseData_vehicle WHERE o_id = 1831 AND fieldname = 'Stammdaten';
25	1.03 ms	SELECT * FROM object_brick_store_Costs_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Kosten"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Costs_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Costs_vehicle WHERE o_id = 1831 AND fieldname = 'Kosten';
26	1.32 ms	SELECT * FROM object_brick_store_Exterieur_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Aussen"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Exterieur_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Exterieur_vehicle WHERE o_id = 1831 AND fieldname = 'Aussen';
27	1.35 ms	SELECT * FROM object_brick_store_Interieur_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Innen"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Interieur_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Interieur_vehicle WHERE o_id = 1831 AND fieldname = 'Innen';
28	1.04 ms	SELECT * FROM object_brick_store_Financing_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Finanzierung"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Financing_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Financing_vehicle WHERE o_id = 1831 AND fieldname = 'Finanzierung';
29	1.21 ms	SELECT * FROM object_brick_store_Leasing_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "Leasing"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Leasing_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Leasing_vehicle WHERE o_id = 1831 AND fieldname = 'Leasing';
30	1.60 ms	SELECT * FROM object_brick_store_TechnicalData_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "TechnischeDaten"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_TechnicalData_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_TechnicalData_vehicle WHERE o_id = 1831 AND fieldname = 'TechnischeDaten';
31	0.98 ms	SELECT * FROM object_brick_store_TechnicalDataMore_vehicle WHERE o_id = ? AND fieldname = ? Parameters: [`1831 "TechnischeDatenMore"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_TechnicalDataMore_vehicle WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_TechnicalDataMore_vehicle WHERE o_id = 1831 AND fieldname = 'TechnischeDatenMore';
32	1.35 ms	SELECT * FROM object_relations_vehicle WHERE src_id = ? Parameters: [`1831`] View formatted query View runnable query Explain query SELECT * FROM object_relations_vehicle WHERE src_id = ? SELECT * FROM object_relations_vehicle WHERE src_id = 1831;
33	1.14 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: [`8681`] 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 = 8681;
34	1.12 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: [`8681`] 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 = 8681;
35	1.06 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: [`8682`] 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 = 8682;
36	1.05 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: [`8682`] 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 = 8682;
37	1.25 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: [`8683`] 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 = 8683;
38	1.10 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: [`8683`] 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 = 8683;
39	1.24 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: [`8684`] 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 = 8684;
40	1.16 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: [`8684`] 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 = 8684;
41	0.92 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: [`8685`] 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 = 8685;
42	1.45 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: [`8685`] 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 = 8685;
43	1.21 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: [`9535`] 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 = 9535;
44	1.17 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: [`9535`] 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 = 9535;
45	1.57 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: [`9536`] 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 = 9536;
46	1.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: [`9536`] 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 = 9536;
47	1.63 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: [`9537`] 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 = 9537;
48	0.92 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: [`9537`] 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 = 9537;
49	1.35 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: [`9538`] 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 = 9538;
50	1.19 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: [`9538`] 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 = 9538;
51	1.75 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: [`9539`] 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 = 9539;
52	1.15 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: [`9539`] 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 = 9539;
53	1.53 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: [`9540`] 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 = 9540;
54	1.25 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: [`9540`] 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 = 9540;
55	1.20 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: [`9541`] 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 = 9541;
56	1.23 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: [`9541`] 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 = 9541;
57	1.25 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: [`9542`] 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 = 9542;
58	1.24 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: [`9542`] 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 = 9542;
59	1.28 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: [`9543`] 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 = 9543;
60	1.21 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: [`9543`] 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 = 9543;
61	1.23 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: [`9544`] 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 = 9544;
62	1.18 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: [`9544`] 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 = 9544;
63	1.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 8681`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8681;
64	1.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 8682`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8682;
65	1.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 8683`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8683;
66	1.06 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 8684`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8684;
67	0.93 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 8685`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 8685;
68	0.96 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9535`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9535;
69	0.89 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9536`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9536;
70	0.93 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9537`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9537;
71	1.06 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9538`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9538;
72	0.97 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "_auto_bbe1096c84ff733c05e133cd6417255f" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '_auto_bbe1096c84ff733c05e133cd6417255f' AND scope = 'pimcore_image_thumbnails';
73	0.93 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_9538__f5c397dfe8e00ee221cfd8f14e1c6b5c"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_9538__f5c397dfe8e00ee221cfd8f14e1c6b5c';
74	5.11 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_9538__f5c397dfe8e00ee221cfd8f14e1c6b5c" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:920;s:11:"forceResize";b:0;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:38:"_auto_bbe1096c84ff733c05e133cd6417255f";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"jpeg";s:10:"\x00\x00quality";i:60;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1788347934 ":col4" => 1788952734 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
75	1.09 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9539`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9539;
76	1.03 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9540`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9540;
77	1.03 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "_auto_bbe1096c84ff733c05e133cd6417255f" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '_auto_bbe1096c84ff733c05e133cd6417255f' AND scope = 'pimcore_image_thumbnails';
78	0.98 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_9540__45d19fe341cc61552eb13422927eeebc"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_9540__45d19fe341cc61552eb13422927eeebc';
79	4.34 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_9540__45d19fe341cc61552eb13422927eeebc" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:8:"\x00\x00items";a:1:{i:0;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:920;s:11:"forceResize";b:0;}}}s:9:"\x00\x00medias";a:0:{}s:7:"\x00\x00name";s:38:"_auto_bbe1096c84ff733c05e133cd6417255f";s:14:"\x00\x00description";s:0:"";s:8:"\x00\x00group";s:0:"";s:9:"\x00\x00format";s:4:"jpeg";s:10:"\x00\x00quality";i:60;s:17:"\x00\x00highResolution";N;s:16:"\x00\x00preserveColor";b:0;s:19:"\x00\x00preserveMetaData";b:0;s:15:"\x00\x00rasterizeSVG";b:0;s:15:"\x00\x00downloadable";b:0;s:19:"\x00\x00modificationDate";N;s:15:"\x00\x00creationDate";N;s:17:"\x00\x00filenameSuffix";N;s:20:"\x00\x00preserveAnimation";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1788347934 ":col4" => 1788952734 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( :col0, :col1, :col2, :col3, :col4, :col5 ) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
80	1.56 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9541`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9541;
81	1.19 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9542`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9542;
82	1.10 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9543`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9543;
83	0.94 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 9544`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 9544;
84	0.98 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`129`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 129;
85	1.25 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`129`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 129;
86	1.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"dealerLocation"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'dealerLocation';
87	1.62 ms	SELECT * FROM object_store_dealerLocation WHERE oo_id = ? Parameters: [`129`] View formatted query View runnable query Explain query SELECT * FROM object_store_dealerLocation WHERE oo_id = ? SELECT * FROM object_store_dealerLocation WHERE oo_id = 129;
88	0.98 ms	SELECT * FROM object_relations_dealerLocation WHERE src_id = ? Parameters: [`129`] View formatted query View runnable query Explain query SELECT * FROM object_relations_dealerLocation WHERE src_id = ? SELECT * FROM object_relations_dealerLocation WHERE src_id = 129;
89	1.37 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "footer" "path" => "/shared/includes/"`] 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 '/shared/includes/' AND `key` = BINARY 'footer';
90	1.42 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: [`6`] 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 = 6;
91	1.15 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 6;
92	0.99 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: [`5`] 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 = 5;
93	0.95 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: [`5`] 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 = 5;
94	1.15 ms	SELECT * FROM properties WHERE ((cid IN (1,5,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 5, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ((cid IN (1,5,3) AND inheritable = 1) OR cid = 6 ) AND ctype='document';
95	1.46 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6;
96	1.11 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: [`157`] 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 = 157;
97	1.33 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: [`157`] 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 = 157;
98	1.76 ms	SELECT t0.id AS id_1, t0.`name` AS name_2, t0.`group` AS group_3, t0.creationDate AS creationDate_4, t0.modificationDate AS modificationDate_5, t0.createdBy AS createdBy_6, t0.modifiedBy AS modifiedBy_7, t0.mailLayout AS mailLayout_8, t0.configuration AS configuration_9, t0.conditionalLogic AS conditionalLogic_10, t0.fields AS fields_11 FROM formbuilder_forms t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`name` AS name_2, t0.`group` AS group_3, t0.creationDate AS creationDate_4, t0.modificationDate AS modificationDate_5, t0.createdBy AS createdBy_6, t0.modifiedBy AS modifiedBy_7, t0.mailLayout AS mailLayout_8, t0.configuration AS configuration_9, t0.conditionalLogic AS conditionalLogic_10, t0.fields AS fields_11 FROM formbuilder_forms t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.`name` AS name_2, t0.`group` AS group_3, t0.creationDate AS creationDate_4, t0.modificationDate AS modificationDate_5, t0.createdBy AS createdBy_6, t0.modifiedBy AS modifiedBy_7, t0.mailLayout AS mailLayout_8, t0.configuration AS configuration_9, t0.conditionalLogic AS conditionalLogic_10, t0.fields AS fields_11 FROM formbuilder_forms t0 WHERE t0.id = 1;
99	1.21 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
100	0.85 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
101	2.05 ms	SELECT * FROM translations_messages WHERE language = ? Parameters: [`"de"`] View formatted query View runnable query Explain query SELECT * FROM translations_messages WHERE language = ? SELECT * FROM translations_messages WHERE language = 'de';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
SeoBundle\Model\ElementMetaData	No errors.
FormBuilderBundle\Model\FormDefinition	No errors.
FormBuilderBundle\Model\OutputWorkflow	No errors.

Symfony Profiler

http://bmw-timmermanns-dev.m2.krankikom.de/fahrzeugboerse/fahrzeuge?i=FBUD2211529

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping