Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

176 Database Queries

15 Different statements

71.37 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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%')))  AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC   LIMIT 10 OFFSET 30
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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN (
                    SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid 
                    WHERE 
                        ctype = 'object' AND 
                        (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%')))  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.57 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?amp====&page=4&tree=606,607" "sourceEntireUri" => "https://cessda.openconcept.no/Resource-Directory?amp====&page=4&tree=606,607" "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?amp====&page=4&tree=606,607' AND `type` = 'path_query') OR (source = 'https://cessda.openconcept.no/Resource-Directory?amp====&page=4&tree=606,607' 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.18 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.17 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.15 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.15 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.17 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.20 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.11 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
9	0.10 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: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
11	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;
12	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
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: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
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.14 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`600`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 600 ORDER BY `name` ;
17	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`605`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 605;
18	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
19	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;
20	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`603`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 603;
21	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
22	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;
23	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`602`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 602;
24	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
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.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`604`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 604;
27	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
28	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;
29	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`601`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 601;
30	0.10 ms	SELECT * FROM tags WHERE id = ? Parameters: [`600`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 600;
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.12 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`605`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 605 ORDER BY `name` ;
33	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`603`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 603 ORDER BY `name` ;
34	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`602`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 602 ORDER BY `name` ;
35	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`604`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 604 ORDER BY `name` ;
36	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`601`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 601 ORDER BY `name` ;
37	0.12 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`606`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 606 ORDER BY `name` ;
38	0.09 ms	SELECT * FROM tags WHERE id = ? Parameters: [`610`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 610;
39	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
40	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;
41	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`609`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 609;
42	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
43	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;
44	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`608`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 608;
45	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
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.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`607`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 607;
48	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
49	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;
50	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`610`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 610 ORDER BY `name` ;
51	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`609`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 609 ORDER BY `name` ;
52	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`608`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 608 ORDER BY `name` ;
53	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`607`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 607 ORDER BY `name` ;
54	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`594`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 594 ORDER BY `name` ;
55	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`595`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 595;
56	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
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: [`598`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 598;
59	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
60	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;
61	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`599`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 599;
62	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
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: [`597`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 597;
65	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
66	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;
67	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`596`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 596;
68	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`594`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 594;
69	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;
70	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`595`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 595 ORDER BY `name` ;
71	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`598`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 598 ORDER BY `name` ;
72	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`599`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 599 ORDER BY `name` ;
73	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`597`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 597 ORDER BY `name` ;
74	0.09 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`596`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 596 ORDER BY `name` ;
75	0.12 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`611`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 611 ORDER BY `name` ;
76	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`615`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 615;
77	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
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.09 ms	SELECT * FROM tags WHERE id = ? Parameters: [`614`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 614;
80	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
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.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`616`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 616;
83	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
84	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;
85	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`617`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 617;
86	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
87	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;
88	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`613`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 613;
89	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
90	0.09 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.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`612`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 612;
92	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`611`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 611;
93	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;
94	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`615`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 615 ORDER BY `name` ;
95	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`614`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 614 ORDER BY `name` ;
96	0.12 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`616`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 616 ORDER BY `name` ;
97	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`617`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 617 ORDER BY `name` ;
98	0.11 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`613`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 613 ORDER BY `name` ;
99	0.10 ms	SELECT id FROM tags WHERE parentId = ? ORDER BY `name` Parameters: [`612`] View formatted query View runnable query Explain query SELECT id FROM tags WHERE parentId = ? ORDER BY `name` SELECT id FROM tags WHERE parentId = 612 ORDER BY `name` ;
100	0.11 ms	SELECT * FROM tags WHERE id = ? Parameters: [`"606"`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '606';
101	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;
102	0.08 ms	SELECT * FROM tags WHERE id = ? Parameters: [`"607"`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '607';
103	0.07 ms	SELECT * FROM tags WHERE id = ? Parameters: [`606`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 606;
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.52 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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 30 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 = 606 OR tags.idPath LIKE '/9/606/%' ) ) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 607 OR tags.idPath LIKE '/9/606/607/%' ) ) ) AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 30 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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 OFFSET 30;
106	1.29 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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%'))) 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 = 606 OR tags.idPath LIKE '/9/606/%' ) ) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND ( tags.id = 607 OR tags.idPath LIKE '/9/606/607/%' ) ) ) 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 = 606 OR tags.idPath LIKE '/9/606/%')) AND o_id IN ( SELECT cid FROM tags_assignment INNER JOIN tags ON tags.id = tags_assignment.tagid WHERE ctype = 'object' AND (tags.id = 607 OR tags.idPath LIKE '/9/606/607/%'))) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
107	0.13 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	1.32 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	1.28 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	1.16 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	1.20 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	1.14 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	1.15 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	1.07 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	1.13 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	1.21 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.95 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.88 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.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" => "%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.90 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.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" => "%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.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" => "%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.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" => "%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.81 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.82 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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.88 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.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" => "%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.88 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.86 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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.89 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.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" => "%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.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" => "%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.82 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.92 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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.77 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.97 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.86 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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.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" => "%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.80 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.76 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.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" => "%----%"`] 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.80 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.87 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.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 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.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" => "%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.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" => "%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.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" => "%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.69 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.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" => "%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.75 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.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" => "% 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.70 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.91 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.70 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.75 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.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" => "%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.84 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.84 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.87 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?amp%3D=%3D%3D&page=4&tree=606%2C607

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache