Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

187 Database Queries

12 Different statements

34.11 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 id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT id FROM classes WHERE name = ?
SELECT name FROM classes WHERE id = ?
SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_4 r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND o.o_id = r.src_id
            AND r.type='object'

            UNION SELECT r.src_id as dest_id, r.src_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_4 r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND a.id = r.src_id
            AND r.type='asset'

            UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_4 r
            WHERE r.fieldname= ?
            AND r.ownertype = 'object'
            AND r.dest_id = ?
            AND d.id = r.src_id
            AND r.type='document'

            ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1
SELECT 1 FROM objects o WHERE o_parentId = ?  AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1

#▲	Time	Info
1	0.44 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" => "/Training/Training-Resources/Resource-crd-2628" "sourcePathQuery" => "/Training/Training-Resources/Resource-crd-2628?keywords=Data management&page=4" "sourceEntireUri" => "https://cessda.openconcept.no/Training/Training-Resources/Resource-crd-2628?keywords=Data management&page=4" "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 = '/Training/Training-Resources/Resource-crd-2628' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/Training/Training-Resources/Resource-crd-2628?keywords=Data management&page=4' AND `type` = 'path_query') OR (source = 'https://cessda.openconcept.no/Training/Training-Resources/Resource-crd-2628?keywords=Data management&page=4' 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.16 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	0.19 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Resource-crd-2628" "path" => "/Training/Training-Resources/"`] 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 '/Training/Training-Resources/' AND `key` = BINARY 'Resource-crd-2628';
4	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Training/Training-Resources/Resource-crd-2628"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Training/Training-Resources/Resource-crd-2628';
5	0.16 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Training-Resources" "path" => "/Training/"`] 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 '/Training/' AND `key` = BINARY 'Training-Resources';
6	0.21 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;
7	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '1';
8	0.13 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"ResourceCollection"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'ResourceCollection';
9	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '4';
10	0.58 ms	SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_4 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.o_id = r.src_id AND r.type='object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_4 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_4 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC Parameters: [`"resource_item" 2628 "resource_item" 2628 "resource_item" 2628`] View formatted query View runnable query Explain query SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path, o.o_key) as path, r.index FROM objects o, object_relations_4 r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.o_id = r.src_id AND r.type = 'object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path, a.filename) as path, r.index FROM assets a, object_relations_4 r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type = 'asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path, d.key) as path, r.index FROM documents d, object_relations_4 r WHERE r.fieldname = ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type = 'document' ORDER BY `index` ASC SELECT r.src_id as dest_id, r.src_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index FROM objects o, object_relations_4 r WHERE r.fieldname= 'resource_item' AND r.ownertype = 'object' AND r.dest_id = 2628 AND o.o_id = r.src_id AND r.type='object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index FROM assets a, object_relations_4 r WHERE r.fieldname= 'resource_item' AND r.ownertype = 'object' AND r.dest_id = 2628 AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index FROM documents d, object_relations_4 r WHERE r.fieldname= 'resource_item' AND r.ownertype = 'object' AND r.dest_id = 2628 AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC;
11	0.22 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 1 AND published = 1 LIMIT 1;
12	0.25 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 1) AND published = 1 ORDER BY `index` ASC ;
13	0.23 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`8`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 8 AND published = 1 LIMIT 1;
14	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`8`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 8) AND published = 1 ORDER BY `index` ASC ;
15	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`37`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 37 AND published = 1 LIMIT 1;
16	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`9`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 9 AND published = 1 LIMIT 1;
17	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`13`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 13 AND published = 1 LIMIT 1;
18	0.19 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`13`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 13) AND published = 1 ORDER BY `index` ASC ;
19	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`159`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 159 AND published = 1 LIMIT 1;
20	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`10`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 10 AND published = 1 LIMIT 1;
21	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 11 AND published = 1 LIMIT 1;
22	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`12`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 12 AND published = 1 LIMIT 1;
23	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`66`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 66 AND published = 1 LIMIT 1;
24	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`14`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 14 AND published = 1 LIMIT 1;
25	0.16 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`14`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 14) AND published = 1 ORDER BY `index` ASC ;
26	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`38`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 38 AND published = 1 LIMIT 1;
27	0.12 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`6`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 6 AND published = 1 LIMIT 1;
28	0.14 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`6`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 6) AND published = 1 ORDER BY `index` ASC ;
29	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`145`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 145 AND published = 1 LIMIT 1;
30	0.12 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`130`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 130 AND published = 1 LIMIT 1;
31	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`16`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 16 AND published = 1 LIMIT 1;
32	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`17`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 17 AND published = 1 LIMIT 1;
33	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`174`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 174 AND published = 1 LIMIT 1;
34	0.64 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`67`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 67 AND published = 1 LIMIT 1;
35	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`19`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 19 AND published = 1 LIMIT 1;
36	0.20 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`19`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 19) AND published = 1 ORDER BY `index` ASC ;
37	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`39`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 39 AND published = 1 LIMIT 1;
38	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`20`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 20 AND published = 1 LIMIT 1;
39	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`21`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 21 AND published = 1 LIMIT 1;
40	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`22`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 22 AND published = 1 LIMIT 1;
41	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`23`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 23 AND published = 1 LIMIT 1;
42	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`24`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 24 AND published = 1 LIMIT 1;
43	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`25`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 25 AND published = 1 LIMIT 1;
44	0.16 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`25`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 25) AND published = 1 ORDER BY `index` ASC ;
45	0.22 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`41`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 41 AND published = 1 LIMIT 1;
46	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`28`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 28 AND published = 1 LIMIT 1;
47	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`26`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 26 AND published = 1 LIMIT 1;
48	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`75`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 75 AND published = 1 LIMIT 1;
49	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`80`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 80 AND published = 1 LIMIT 1;
50	0.23 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`80`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 80) AND published = 1 ORDER BY `index` ASC ;
51	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`117`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 117 AND published = 1 LIMIT 1;
52	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`97`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 97 AND published = 1 LIMIT 1;
53	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`93`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 93 AND published = 1 LIMIT 1;
54	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`99`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 99 AND published = 1 LIMIT 1;
55	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`94`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 94 AND published = 1 LIMIT 1;
56	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`118`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 118 AND published = 1 LIMIT 1;
57	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`119`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 119 AND published = 1 LIMIT 1;
58	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`120`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 120 AND published = 1 LIMIT 1;
59	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`121`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 121 AND published = 1 LIMIT 1;
60	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`122`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 122 AND published = 1 LIMIT 1;
61	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`123`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 123 AND published = 1 LIMIT 1;
62	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`124`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 124 AND published = 1 LIMIT 1;
63	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`125`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 125 AND published = 1 LIMIT 1;
64	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`126`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 126 AND published = 1 LIMIT 1;
65	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`100`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 100 AND published = 1 LIMIT 1;
66	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`88`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 88 AND published = 1 LIMIT 1;
67	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`91`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 91 AND published = 1 LIMIT 1;
68	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`95`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 95 AND published = 1 LIMIT 1;
69	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`98`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 98 AND published = 1 LIMIT 1;
70	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`87`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 87 AND published = 1 LIMIT 1;
71	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`96`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 96 AND published = 1 LIMIT 1;
72	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`127`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 127 AND published = 1 LIMIT 1;
73	0.19 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`127`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 127) AND published = 1 ORDER BY `index` ASC ;
74	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`101`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 101 AND published = 1 LIMIT 1;
75	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`142`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 142 AND published = 1 LIMIT 1;
76	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`152`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 152 AND published = 1 LIMIT 1;
77	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`153`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 153 AND published = 1 LIMIT 1;
78	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`154`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 154 AND published = 1 LIMIT 1;
79	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`155`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 155 AND published = 1 LIMIT 1;
80	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`156`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 156 AND published = 1 LIMIT 1;
81	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`157`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 157 AND published = 1 LIMIT 1;
82	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`158`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 158 AND published = 1 LIMIT 1;
83	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`176`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 176 AND published = 1 LIMIT 1;
84	0.27 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`30`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 30 AND published = 1 LIMIT 1;
85	0.25 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`30`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 30) AND published = 1 ORDER BY `index` ASC ;
86	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`40`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 40 AND published = 1 LIMIT 1;
87	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`32`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 32 AND published = 1 LIMIT 1;
88	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`32`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 32) AND published = 1 ORDER BY `index` ASC ;
89	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`56`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 56 AND published = 1 LIMIT 1;
90	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`55`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 55 AND published = 1 LIMIT 1;
91	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`74`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 74 AND published = 1 LIMIT 1;
92	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`33`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 33 AND published = 1 LIMIT 1;
93	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`33`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 33) AND published = 1 ORDER BY `index` ASC ;
94	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`76`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 76 AND published = 1 LIMIT 1;
95	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`73`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 73 AND published = 1 LIMIT 1;
96	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`73`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 73) AND published = 1 ORDER BY `index` ASC ;
97	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`105`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 105 AND published = 1 LIMIT 1;
98	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`106`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 106 AND published = 1 LIMIT 1;
99	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`109`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 109 AND published = 1 LIMIT 1;
100	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`146`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 146 AND published = 1 LIMIT 1;
101	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`147`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 147 AND published = 1 LIMIT 1;
102	0.23 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`148`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 148 AND published = 1 LIMIT 1;
103	0.23 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`151`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 151 AND published = 1 LIMIT 1;
104	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`175`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 175 AND published = 1 LIMIT 1;
105	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`31`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 31 AND published = 1 LIMIT 1;
106	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`34`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 34 AND published = 1 LIMIT 1;
107	0.17 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`34`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 34) AND published = 1 ORDER BY `index` ASC ;
108	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`64`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 64 AND published = 1 LIMIT 1;
109	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`59`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 59 AND published = 1 LIMIT 1;
110	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`35`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 35 AND published = 1 LIMIT 1;
111	0.22 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`42`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 42 AND published = 1 LIMIT 1;
112	0.16 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`42`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 42) AND published = 1 ORDER BY `index` ASC ;
113	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`43`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 43 AND published = 1 LIMIT 1;
114	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`44`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 44 AND published = 1 LIMIT 1;
115	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`50`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 50 AND published = 1 LIMIT 1;
116	0.13 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`51`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 51 AND published = 1 LIMIT 1;
117	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`78`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 78 AND published = 1 LIMIT 1;
118	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`45`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 45 AND published = 1 LIMIT 1;
119	0.17 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`45`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 45) AND published = 1 ORDER BY `index` ASC ;
120	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`65`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 65 AND published = 1 LIMIT 1;
121	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`47`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 47 AND published = 1 LIMIT 1;
122	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`48`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 48 AND published = 1 LIMIT 1;
123	0.17 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`48`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 48) AND published = 1 ORDER BY `index` ASC ;
124	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`58`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 58 AND published = 1 LIMIT 1;
125	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`60`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 60 AND published = 1 LIMIT 1;
126	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`69`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 69 AND published = 1 LIMIT 1;
127	0.20 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`69`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 69) AND published = 1 ORDER BY `index` ASC ;
128	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`49`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 49 AND published = 1 LIMIT 1;
129	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`49`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 49) AND published = 1 ORDER BY `index` ASC ;
130	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`57`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 57 AND published = 1 LIMIT 1;
131	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`70`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 70 AND published = 1 LIMIT 1;
132	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`132`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 132 AND published = 1 LIMIT 1;
133	0.17 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`132`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 132) AND published = 1 ORDER BY `index` ASC ;
134	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`133`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 133 AND published = 1 LIMIT 1;
135	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`135`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 135 AND published = 1 LIMIT 1;
136	0.17 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`135`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 135) AND published = 1 ORDER BY `index` ASC ;
137	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`134`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 134 AND published = 1 LIMIT 1;
138	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`136`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 136 AND published = 1 LIMIT 1;
139	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`143`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 143 AND published = 1 LIMIT 1;
140	0.26 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`161`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 161 AND published = 1 LIMIT 1;
141	0.23 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`161`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 161) AND published = 1 ORDER BY `index` ASC ;
142	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`162`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 162 AND published = 1 LIMIT 1;
143	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`163`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 163 AND published = 1 LIMIT 1;
144	0.30 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`164`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 164 AND published = 1 LIMIT 1;
145	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`165`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 165 AND published = 1 LIMIT 1;
146	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`166`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 166 AND published = 1 LIMIT 1;
147	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`167`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 167 AND published = 1 LIMIT 1;
148	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`168`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 168 AND published = 1 LIMIT 1;
149	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`169`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 169 AND published = 1 LIMIT 1;
150	0.24 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`170`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 170 AND published = 1 LIMIT 1;
151	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`173`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 173 AND published = 1 LIMIT 1;
152	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`171`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 171 AND published = 1 LIMIT 1;
153	0.26 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`178`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 178 AND published = 1 LIMIT 1;
154	0.21 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`178`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 178) AND published = 1 ORDER BY `index` ASC ;
155	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`179`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 179 AND published = 1 LIMIT 1;
156	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`180`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 180 AND published = 1 LIMIT 1;
157	0.24 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`181`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 181 AND published = 1 LIMIT 1;
158	0.21 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`181`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 181) AND published = 1 ORDER BY `index` ASC ;
159	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`184`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 184 AND published = 1 LIMIT 1;
160	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`183`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 183 AND published = 1 LIMIT 1;
161	0.14 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`185`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 185 AND published = 1 LIMIT 1;
162	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`187`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 187 AND published = 1 LIMIT 1;
163	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`198`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 198 AND published = 1 LIMIT 1;
164	0.15 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`198`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 198) AND published = 1 ORDER BY `index` ASC ;
165	0.15 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`182`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 182 AND published = 1 LIMIT 1;
166	0.22 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2628`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2628 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
167	0.22 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2628`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2628 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
168	0.20 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`4`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 4 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
169	0.15 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2550`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2550 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
170	0.16 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2557`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2557 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
171	0.19 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2557`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2557 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
172	0.19 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2561`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2561 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
173	0.17 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2561`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2561 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
174	0.19 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2555`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2555 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
175	0.17 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2555`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2555 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
176	0.20 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2559`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2559 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
177	0.19 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2559`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2559 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
178	0.20 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2545`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2545 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
179	0.19 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2545`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2545 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
180	0.17 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2626`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2626 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
181	0.19 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2626`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2626 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
182	0.17 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2598`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2598 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
183	0.18 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2598`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2598 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
184	0.17 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2596`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2596 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
185	0.16 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2564`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2564 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
186	0.15 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2632`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2632 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;
187	0.16 ms	SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1 Parameters: [`2544`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE o_parentId = ? AND o_published = 1 AND o_type IN ('object', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE o_parentId = 2544 AND o_published = 1 AND o_type IN ('object','folder') LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://cessda.openconcept.no/Training/Training-Resources/Resource-crd-2628?keywords=Data%20management&page=4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache