Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

176 Database Queries

15 Different statements

62.83 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 * FROM object_url_slugs WHERE slug = '/Resource-Directory' 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 tags WHERE parentId = 9  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT id FROM tags WHERE parentId = ?  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT object_17.o_id as o_id, object_17.o_type as o_type FROM object_17 WHERE ((o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%')))  AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC   LIMIT 10 OFFSET 40
SELECT COUNT(*) FROM object_17 WHERE ((o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%')))  AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT name FROM classes WHERE id = ?
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE :contribs AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (project LIKE :projects AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1
SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE :type AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 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" => "/Resource-Directory" "sourcePathQuery" => "/Resource-Directory?page=5&tree=11,16" "sourceEntireUri" => "https://cessda.openconcept.no/Resource-Directory?page=5&tree=11,16" "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 = '/Resource-Directory' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/Resource-Directory?page=5&tree=11,16' AND `type` = 'path_query') OR (source = 'https://cessda.openconcept.no/Resource-Directory?page=5&tree=11,16' 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.13 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.13 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Resource-Directory" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'Resource-Directory';
4	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Resource-Directory"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Resource-Directory';
5	0.13 ms	SELECT * FROM object_url_slugs WHERE slug = '/Resource-Directory' 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 = '/Resource-Directory' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/Resource-Directory' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
6	0.15 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.16 ms	SELECT id FROM tags WHERE parentId = 9 ORDER BY `name` Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = 9 ORDER BY `name` SELECT id FROM tags WHERE parentId = 9 ORDER BY `name` ;
8	0.10 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
9	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
10	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 23;
11	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
12	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
13	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
14	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
15	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
16	0.12 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`17`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 17 ORDER BY `name` ;
17	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 22;
18	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
19	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
20	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 20;
21	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
22	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
23	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 19;
24	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
25	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
26	0.09 ms	SELECT * FROM tags WHERE id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 21;
27	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
28	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
29	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 18;
30	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
31	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
32	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`22`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 22 ORDER BY `name` ;
33	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`20`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 20 ORDER BY `name` ;
34	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`19`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 19 ORDER BY `name` ;
35	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`21`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 21 ORDER BY `name` ;
36	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`18`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 18 ORDER BY `name` ;
37	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`23`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 23 ORDER BY `name` ;
38	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`27`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 27;
39	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 23;
40	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
41	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 26;
42	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 23;
43	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
44	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 25;
45	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 23;
46	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
47	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 24;
48	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 23;
49	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
50	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`27`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 27 ORDER BY `name` ;
51	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`26`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 26 ORDER BY `name` ;
52	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`25`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 25 ORDER BY `name` ;
53	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`24`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 24 ORDER BY `name` ;
54	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`11`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 11 ORDER BY `name` ;
55	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 12;
56	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
57	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
58	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 15;
59	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
60	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
61	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 16;
62	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
63	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
64	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 14;
65	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
66	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
67	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 13;
68	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
69	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
70	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`12`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 12 ORDER BY `name` ;
71	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`15`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 15 ORDER BY `name` ;
72	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`16`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 16 ORDER BY `name` ;
73	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`14`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 14 ORDER BY `name` ;
74	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`13`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 13 ORDER BY `name` ;
75	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`28`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 28 ORDER BY `name` ;
76	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 32;
77	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
78	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
79	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 31;
80	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
81	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
82	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 33;
83	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
84	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
85	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`34`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 34;
86	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
87	0.22 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
88	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 30;
89	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
90	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
91	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 29;
92	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 28;
93	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
94	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`32`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 32 ORDER BY `name` ;
95	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`31`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 31 ORDER BY `name` ;
96	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`33`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 33 ORDER BY `name` ;
97	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`34`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 34 ORDER BY `name` ;
98	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`30`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 30 ORDER BY `name` ;
99	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`29`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 29 ORDER BY `name` ;
100	0.10 ms	SELECT * FROM tags WHERE id = ? Parameters: [`"11"`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '11';
101	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
102	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`"16"`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '16';
103	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
104	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
105	1.36 ms	SELECT object_17.o_id as o_id, object_17.o_type as o_type FROM object_17 WHERE ((o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 40 Parameters: [] View formatted query View runnable query Explain query SELECT object_17.o_id as o_id, object_17.o_type as o_type FROM object_17 WHERE ( ( o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 11 OR tags.idPath LIKE '/9/11/%' ) ) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 16 OR tags.idPath LIKE '/9/11/16/%' ) ) ) AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 40 SELECT object_17.o_id as o_id, object_17.o_type as o_type FROM object_17 WHERE ((o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 40;
106	1.19 ms	SELECT COUNT() FROM object_17 WHERE ((o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( ( o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 11 OR tags.idPath LIKE '/9/11/%' ) ) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 16 OR tags.idPath LIKE '/9/11/16/%' ) ) ) AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE ((o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 11 OR tags.idPath LIKE '/9/11/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 16 OR tags.idPath LIKE '/9/11/16/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
107	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"17"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '17';
108	0.84 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%CESSDAERIC%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%CESSDAERIC%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
109	0.85 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%CESSDAMO%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%CESSDAMO%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
110	0.77 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%AL CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%AL CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
111	0.83 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%AT CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%AT CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
112	0.91 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%BE CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%BE CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
113	0.78 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%BA CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%BA CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
114	0.76 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%BG CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%BG CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
115	0.79 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%HR CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%HR CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
116	0.79 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%CZ CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%CZ CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
117	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%EE CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%EE CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
118	0.80 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%FI CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%FI CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
119	0.76 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%FR CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%FR CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
120	0.85 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%DE CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%DE CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
121	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%GR CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%GR CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
122	0.77 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%HU CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%HU CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
123	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%IS CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%IS CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
124	0.77 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%IE CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%IE CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
125	0.78 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%IT CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%IT CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
126	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%XK CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%XK CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
127	0.73 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%LV CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%LV CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
128	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%LT CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%LT CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
129	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%LU CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%LU CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
130	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%ME CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%ME CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
131	0.84 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%NL CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%NL CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
132	0.73 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%MK CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%MK CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
133	0.80 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%NO CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%NO CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
134	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%PL CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%PL CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
135	0.77 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%PT CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%PT CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
136	0.74 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%RO CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%RO CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
137	0.73 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%RS CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%RS CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
138	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%SK CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%SK CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
139	0.80 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%SI CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%SI CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
140	0.84 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%SE CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%SE CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
141	0.85 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%CH CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%CH CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
142	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%UA CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%UA CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
143	0.85 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%UK CESSDA SP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%UK CESSDA SP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
144	0.75 ms	SELECT COUNT() FROM object_17 WHERE (contributors LIKE :contribs AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"contribs" => "%Other%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( contributors LIKE :contribs AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (contributors LIKE '%Other%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
145	0.71 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%BY-COVID%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%BY-COVID%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
146	0.73 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%COORDINATE%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%COORDINATE%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
147	0.70 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%EOSC Enhance%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%EOSC Enhance%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
148	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%EOSC Future%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%EOSC Future%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
149	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%ERIC Forum%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%ERIC Forum%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
150	0.68 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%eRImote%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%eRImote%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
151	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%EURHISFIRM%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%EURHISFIRM%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
152	0.68 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%FAIR-IMPACT%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%FAIR-IMPACT%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
153	0.66 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%GGP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%GGP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
154	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%HumMingBird%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%HumMingBird%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
155	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%RItrainPlus%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%RItrainPlus%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
156	0.74 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%SSHOC%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%SSHOC%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
157	0.70 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%Triple%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%Triple%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
158	0.68 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%----%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%----%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
159	0.68 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%BigDataEurope (BDE)%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%BigDataEurope (BDE)%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
160	0.73 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%CESSDA SaW%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%CESSDA SaW%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
161	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%CESSDA PPP%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%CESSDA PPP%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
162	0.68 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%DASISH%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%DASISH%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
163	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%Data without Boundaries (DwB)%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%Data without Boundaries (DwB)%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
164	0.66 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%FOSTER%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%FOSTER%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
165	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%RISCAPE%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%RISCAPE%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
166	0.71 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%SEEDS%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%SEEDS%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
167	0.72 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "%SERISS%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '%SERISS%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
168	0.67 ms	SELECT COUNT() FROM object_17 WHERE (project LIKE :projects AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"projects" => "% SERSCIDA%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( project LIKE :projects AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (project LIKE '% SERSCIDA%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
169	0.65 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Book%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Book%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
170	0.88 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Document%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Document%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
171	0.66 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Consultancy%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Consultancy%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
172	0.67 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Journal article%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Journal article%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
173	0.83 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Presentation%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Presentation%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
174	0.78 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Report%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Report%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
175	0.79 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Software%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Software%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
176	0.82 ms	SELECT COUNT() FROM object_17 WHERE (resource_type LIKE :type AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 Parameters: [`"type" => "%Webpage%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_17 WHERE ( resource_type LIKE :type AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 SELECT COUNT(*) FROM object_17 WHERE (resource_type LIKE '%Webpage%' AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 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/Resource-Directory?page=5&tree=11%2C16

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache