Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

174 Database Queries

15 Different statements

93.93 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 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 = 318))  AND  object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC   LIMIT 10
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 = 318))  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.98 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?rtag=318" "sourceEntireUri" => "https://cessda.openconcept.no/Resource-Directory?rtag=318" "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?rtag=318' AND `type` = 'path_query') OR (source = 'https://cessda.openconcept.no/Resource-Directory?rtag=318' 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.15 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.18 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.14 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.16 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.20 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.39 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.14 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.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;
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.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: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
13	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;
14	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;
15	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;
16	0.13 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.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;
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: [`20`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 20;
21	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;
22	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;
23	0.08 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.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;
25	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;
26	0.08 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.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;
29	0.08 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.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;
31	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;
32	0.11 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.11 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.10 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.10 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.10 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.12 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.08 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.10 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.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: [`26`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 26;
42	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;
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.08 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.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;
46	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;
47	0.08 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.09 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.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.11 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.11 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.10 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.10 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.12 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.13 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.11 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.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;
58	0.09 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.08 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.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;
61	0.08 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.08 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.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;
64	0.09 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.08 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.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;
67	0.08 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.08 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.11 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.10 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.11 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.10 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.10 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.12 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.08 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.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;
78	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;
79	0.08 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.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;
82	0.08 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.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;
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.08 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.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;
87	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;
88	0.08 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.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;
90	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;
91	0.08 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.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;
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.10 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.10 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.10 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.10 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.12 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.10 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.15 ms	SELECT * FROM tags WHERE id = ? Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '';
101	0.12 ms	SELECT * FROM tags WHERE id = ? Parameters: [`"318"`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = '318';
102	0.09 ms	SELECT * FROM tags WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 10;
103	0.83 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 = 318)) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 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 = 318 ) ) AND object_17.o_type IN ('object', 'folder') ) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10 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 = 318)) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1 ORDER BY `registered_date` DESC LIMIT 10;
104	0.95 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 = 318)) 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 = 318 ) ) 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 = 318)) AND object_17.o_type IN ('object','folder')) AND object_17.o_published = 1;
105	0.15 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';
106	2.02 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;
107	1.50 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;
108	1.11 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;
109	1.44 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;
110	1.26 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;
111	1.30 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;
112	1.12 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;
113	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" => "%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;
114	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;
115	1.09 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;
116	1.35 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;
117	1.25 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;
118	1.43 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;
119	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" => "%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;
120	1.31 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;
121	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" => "%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;
122	1.42 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;
123	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" => "%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;
124	1.45 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;
125	1.49 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;
126	1.29 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;
127	1.18 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;
128	1.59 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;
129	1.87 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;
130	1.57 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;
131	1.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;
132	1.39 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;
133	1.53 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;
134	1.39 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;
135	1.12 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;
136	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" => "%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;
137	0.98 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;
138	1.03 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;
139	1.41 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;
140	1.12 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;
141	1.03 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;
142	0.87 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;
143	0.85 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;
144	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" => "%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;
145	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" => "%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;
146	0.81 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;
147	0.82 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;
148	0.83 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;
149	0.81 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;
150	0.79 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;
151	1.16 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;
152	0.88 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;
153	0.84 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;
154	0.93 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;
155	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" => "%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;
156	1.06 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;
157	1.05 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;
158	1.17 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;
159	1.24 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;
160	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" => "%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;
161	0.79 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;
162	1.31 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;
163	1.04 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;
164	0.93 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;
165	0.99 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;
166	0.85 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;
167	1.02 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;
168	1.59 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;
169	1.00 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;
170	0.97 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;
171	1.33 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;
172	1.54 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;
173	1.27 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;
174	1.51 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?rtag=318

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache