Full database table scan oc_circles_circle/oc_circles_member

[ChristophWurst]

Query Id: 840cd7ddd2b35ffc135ea23c59096c00

SELECT
  `cs`.`unique_id`,
  `cs`.`name`,
  `cs`.`display_name`,
  `cs`.`sanitized_name`,
  `cs`.`source`,
  `cs`.`description`,
  `cs`.`settings`,
  `cs`.`config`,
  `cs`.`contact_addressbook`,
  `cs`.`contact_groupname`,
  `cs`.`creation`
FROM
  `oc_circles_circle` `cs`
  INNER JOIN `oc_circles_member` `cs_mm` ON `cs_mm`.`circle_id` = `cs`.`unique_id`
WHERE
  (`cs`.`instance` = ?)
  AND (
    (`cs_mm`.`user_id` = ?)
    AND (`cs_mm`.`user_type` = ?)
    AND (`cs_mm`.`level` >= ?)
  )
  AND ((`cs`.`config` & ?) > ?)

Nextcloud 27.1.11