|
1
|
[req-ppwd88zexdci21xzrvsh] [1m[36mGroup Load (0.6ms)[0m [1m[34mSELECT "groups".* FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND (groups.uuid is NULL) ORDER BY "groups"."id" ASC LIMIT $1 OFFSET $2[0m [["LIMIT", 1], ["OFFSET", 0]]
|
|
2
|
[req-ppwd88zexdci21xzrvsh] [1m[36mGroup Load (1.5ms)[0m [1m[34mSELECT "groups".* FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND "groups"."group_class" IN ($1, $2) AND (groups.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=groups.owner_uuid and gp.group_class != 'project')) AND ((1=1 OR 1=0 OR 1=0 OR 1=0) AND (groups.name ilike '%%') AND (groups.uuid <> 'jutro-j7d0g-publicfavorites' OR groups.uuid IS NULL)) ORDER BY groups.modified_at desc LIMIT $3 OFFSET $4[0m [["group_class", "project"], ["group_class", "filter"], ["LIMIT", 50], ["OFFSET", 0]]
|
|
3
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.4ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-000000000000000"], ["LIMIT", 1]]
|
|
4
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.5ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-publicfavorites"], ["link_class", "permission"]]
|
|
5
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.3ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-publicfavorites"], ["uuid", "zzzzz-tpzed-000000000000000"], ["LIMIT", 1]]
|
|
6
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
7
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-rew6elm53kancon"], ["link_class", "permission"]]
|
|
8
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-rew6elm53kancon"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
9
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
10
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-fusefiltertest1"], ["link_class", "permission"]]
|
|
11
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-fusefiltertest1"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
12
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
13
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-9otoxmrksam74q6"], ["link_class", "permission"]]
|
|
14
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-9otoxmrksam74q6"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
15
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
16
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.3ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-filtergroupthre"], ["link_class", "permission"]]
|
|
17
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-filtergroupthre"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
18
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
19
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-filtergroupfour"], ["link_class", "permission"]]
|
|
20
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-filtergroupfour"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
21
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
22
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-filtergroupfive"], ["link_class", "permission"]]
|
|
23
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-filtergroupfive"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
24
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
25
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-0010collections"], ["link_class", "permission"]]
|
|
26
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-0010collections"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
27
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
28
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.3ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-0201collections"], ["link_class", "permission"]]
|
|
29
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.4ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-0201collections"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
30
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
31
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.3ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-000010pipelines"], ["link_class", "permission"]]
|
|
32
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-000010pipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
33
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
34
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-nnncrspipelines"], ["link_class", "permission"]]
|
|
35
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-nnncrspipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
36
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
37
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-000025pipelines"], ["link_class", "permission"]]
|
|
38
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.1ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-000025pipelines"], ["uuid", "zzzzz-tpzed-user1withloadab"], ["LIMIT", 1]]
|
|
39
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.1ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-0fusedrivertest"], ["LIMIT", 1]]
|
|
40
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.2ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-0000ownedbyfuse"], ["link_class", "permission"]]
|
|
41
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-0000ownedbyfuse"], ["uuid", "zzzzz-tpzed-0fusedrivertest"], ["LIMIT", 1]]
|
|
42
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
43
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-starredshared01"], ["link_class", "permission"]]
|
|
44
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-starredshared01"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
45
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
46
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-v955i6s2oi1cbso"], ["link_class", "permission"]]
|
|
47
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-v955i6s2oi1cbso"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
48
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
49
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-thisfiltergroup"], ["link_class", "permission"]]
|
|
50
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-thisfiltergroup"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
51
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
52
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-afiltergrouptwo"], ["link_class", "permission"]]
|
|
53
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-afiltergrouptwo"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
54
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.1ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-81hsbo6mk8nl05c"], ["LIMIT", 1]]
|
|
55
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.1ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-lsjm0ibr0ydwpzx"], ["link_class", "permission"]]
|
|
56
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-lsjm0ibr0ydwpzx"], ["uuid", "zzzzz-tpzed-81hsbo6mk8nl05c"], ["LIMIT", 1]]
|
|
57
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCACHE FrozenGroup Exists? (0.0ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" = $1 LIMIT $2[0m [["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
58
|
[req-ppwd88zexdci21xzrvsh] [1m[36mLink Load (0.3ms)[0m [1m[34mSELECT "links".* FROM "links" WHERE "links"."head_uuid" = $1 AND "links"."link_class" = $2[0m [["head_uuid", "zzzzz-j7d0g-subprojsamenam1"], ["link_class", "permission"]]
|
|
59
|
[req-ppwd88zexdci21xzrvsh] [1m[36mFrozenGroup Exists? (0.2ms)[0m [1m[34mSELECT 1 AS one FROM "frozen_groups" WHERE "frozen_groups"."uuid" IN ($1, $2) LIMIT $3[0m [["uuid", "zzzzz-j7d0g-subprojsamenam1"], ["uuid", "zzzzz-tpzed-xurymjxw79nv3jz"], ["LIMIT", 1]]
|
|
60
|
[req-ppwd88zexdci21xzrvsh] [1m[36mGroup Count (0.5ms)[0m [1m[34mSELECT COUNT(*) FROM "groups" WHERE (NOT (((groups.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR groups.trash_at <= statement_timestamp() IS TRUE))) AND "groups"."group_class" IN ($1, $2) AND (groups.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=groups.owner_uuid and gp.group_class != 'project')) AND ((1=1 OR 1=0 OR 1=0 OR 1=0) AND (groups.name ilike '%%') AND (groups.uuid <> 'jutro-j7d0g-publicfavorites' OR groups.uuid IS NULL))[0m [["group_class", "project"], ["group_class", "filter"]]
|
|
61
|
[req-ppwd88zexdci21xzrvsh] [1m[36mTRANSACTION (0.1ms)[0m [1m[35mBEGIN[0m
|
|
62
|
[req-ppwd88zexdci21xzrvsh] [1m[36mContainerRequest Load (1.0ms)[0m [1m[34mSELECT (octet_length(container_requests.mounts)) as read_length FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL)) ORDER BY container_requests.modified_at desc LIMIT $1 OFFSET $2[0m [["LIMIT", 31], ["OFFSET", 0]]
|
|
63
|
[req-ppwd88zexdci21xzrvsh] [1m[36mContainerRequest Load (0.9ms)[0m [1m[34mSELECT "container_requests".* FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL)) ORDER BY container_requests.modified_at desc LIMIT $1 OFFSET $2[0m [["LIMIT", 31], ["OFFSET", 0]]
|
|
64
|
[req-ppwd88zexdci21xzrvsh] [1m[36mTRANSACTION (0.3ms)[0m [1m[35mCOMMIT[0m
|
|
65
|
[req-ppwd88zexdci21xzrvsh] [1m[36mContainerRequest Count (0.9ms)[0m [1m[34mSELECT COUNT(*) FROM "container_requests" WHERE (NOT ((container_requests.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (container_requests.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=container_requests.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=0 OR 1=1) AND (container_requests.requesting_container_uuid is null) AND (container_requests.name ilike '%%') AND (container_requests.uuid <> 'jutro-j7d0g-publicfavorites' OR container_requests.uuid IS NULL))[0m
|
|
66
|
[req-ppwd88zexdci21xzrvsh] [1m[36mTRANSACTION (0.2ms)[0m [1m[35mBEGIN[0m
|
|
67
|
[req-ppwd88zexdci21xzrvsh] [1m[36mWorkflow Load (0.4ms)[0m [1m[34mSELECT (octet_length(workflows.definition)) as read_length FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL)) ORDER BY workflows.modified_at desc, workflows.uuid desc LIMIT $1 OFFSET $2[0m [["LIMIT", 12], ["OFFSET", 0]]
|
|
68
|
[req-ppwd88zexdci21xzrvsh] [1m[36mWorkflow Load (0.6ms)[0m [1m[34mSELECT "workflows".* FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL)) ORDER BY workflows.modified_at desc, workflows.uuid desc LIMIT $1 OFFSET $2[0m [["LIMIT", 12], ["OFFSET", 0]]
|
|
69
|
[req-ppwd88zexdci21xzrvsh] [1m[36mTRANSACTION (0.2ms)[0m [1m[35mCOMMIT[0m
|
|
70
|
[req-ppwd88zexdci21xzrvsh] [1m[36mWorkflow Count (0.5ms)[0m [1m[34mSELECT COUNT(*) FROM "workflows" WHERE (NOT ((workflows.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())))) AND (workflows.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=workflows.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=0 OR 1=1 OR 1=0) AND (workflows.uuid <> 'jutro-j7d0g-publicfavorites' OR workflows.uuid IS NULL))[0m
|
|
71
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCollection Load (1.5ms)[0m [1m[34mSELECT collections."uuid", collections."owner_uuid", collections."created_at", collections."modified_by_client_uuid", collections."modified_by_user_uuid", collections."modified_at", collections."name", collections."description", collections."properties", collections."portable_data_hash", collections."replication_desired", collections."replication_confirmed", collections."replication_confirmed_at", collections."storage_classes_desired", collections."storage_classes_confirmed", collections."storage_classes_confirmed_at", collections."delete_at", collections."trash_at", collections."is_trashed", collections."version", collections."current_version_uuid", collections."preserve_version", collections."file_count", collections."file_size_total" FROM "collections" WHERE (NOT (((collections.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR collections.trash_at <= statement_timestamp() IS TRUE)) AND collections.uuid = collections.current_version_uuid) AND (collections.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=collections.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=1 OR 1=0 OR 1=0) AND (collections.properties->>'type' NOT IN ('log','intermediate') OR collections.properties->>'type' IS NULL) AND (collections.name ilike '%%') AND (collections.uuid <> 'jutro-j7d0g-publicfavorites' OR collections.uuid IS NULL)) ORDER BY collections.modified_at desc LIMIT $1 OFFSET $2[0m [["LIMIT", 9], ["OFFSET", 0]]
|
|
72
|
[req-ppwd88zexdci21xzrvsh] [1m[36mCollection Count (1.0ms)[0m [1m[34mSELECT COUNT(*) FROM "collections" WHERE (NOT (((collections.owner_uuid IN (SELECT group_uuid FROM trashed_groups WHERE trash_at <= statement_timestamp())) OR collections.trash_at <= statement_timestamp() IS TRUE)) AND collections.uuid = collections.current_version_uuid) AND (collections.owner_uuid IN (SELECT users.uuid FROM users WHERE users.uuid != ('zzzzz-tpzed-d9tiejq69daie8f')) OR EXISTS(SELECT 1 FROM groups as gp where gp.uuid=collections.owner_uuid and gp.group_class != 'project')) AND ((1=0 OR 1=1 OR 1=0 OR 1=0) AND (collections.properties->>'type' NOT IN ('log','intermediate') OR collections.properties->>'type' IS NULL) AND (collections.name ilike '%%') AND (collections.uuid <> 'jutro-j7d0g-publicfavorites' OR collections.uuid IS NULL))[0m
|
|
73
|
{"method":"GET","path":"/arvados/v1/groups/contents","format":"html","controller":"Arvados::V1::GroupsController","action":"contents","status":200,"allocations":68272,"duration":92.47,"view":0.55,"db":21.84,"ClusterID":"zzzzz","request_id":"req-ppwd88zexdci21xzrvsh","client_ipaddr":"127.0.0.1","client_auth":"zzzzz-gj3su-027z32aux8dg2s1","params":{"cluster_id":"","count":"","exclude_home_project":"true","filters":"[[\"uuid\",\"is_a\",[\"arvados#group\",\"arvados#collection\",\"arvados#workflow\",\"arvados#containerRequest\"]],[\"collections.properties.type\",\"not in\",[\"log\",\"intermediate\"]],[\"container_requests.requesting_container_uuid\",\"=\",null],[\"collections.name\",\"ilike\",\"%%\"],[\"container_requests.name\",\"ilike\",\"%%\"],[\"groups.name\",\"ilike\",\"%%\"],[\"uuid\",\"!=\",\"jutro-j7d0g-publicfavorites\"]]","limit":"50","offset":"0","order":"[\"collections.modified_at desc\",\"container_requests.modified_at desc\",\"groups.modified_at desc\",\"container_requests.created_at desc\"]"},"@timestamp":"2024-06-03T16:01:34.266552700Z","@version":"1","message":"[200] GET /arvados/v1/groups/contents (Arvados::V1::GroupsController#contents)"}
|