nextcloud / circles

👪 Create groups with other users on a Nextcloud instance and share with them
GNU Affero General Public License v3.0
141 stars 47 forks source link

Full database table scan #1621

Open ChristophWurst opened 5 days ago

ChristophWurst commented 5 days ago
SELECT
  `cc`.`unique_id`,
  `cc`.`name`,
  `cc`.`display_name`,
  `cc`.`sanitized_name`,
  `cc`.`source`,
  `cc`.`description`,
  `cc`.`settings`,
  `cc`.`config`,
  `cc`.`contact_addressbook`,
  `cc`.`contact_groupname`,
  `cc`.`creation`,
  `cc_wn`.`circle_id` AS `cc_wn_circle_id`,
  `cc_wn`.`member_id` AS `cc_wn_member_id`,
  `cc_wn`.`single_id` AS `cc_wn_single_id`,
  `cc_wn`.`user_id` AS `cc_wn_user_id`,
  `cc_wn`.`instance` AS `cc_wn_instance`,
  `cc_wn`.`user_type` AS `cc_wn_user_type`,
  `cc_wn`.`level` AS `cc_wn_level`,
  `cc_wn`.`status` AS `cc_wn_status`,
  `cc_wn`.`note` AS `cc_wn_note`,
  `cc_wn`.`contact_id` AS `cc_wn_contact_id`,
  `cc_wn`.`cached_name` AS `cc_wn_cached_name`,
  `cc_wn`.`cached_update` AS `cc_wn_cached_update`,
  `cc_wn`.`contact_meta` AS `cc_wn_contact_meta`,
  `cc_wn`.`joined` AS `cc_wn_joined`,
  `cc_wn_on`.`unique_id` AS `cc_wn_on_unique_id`,
  `cc_wn_on`.`name` AS `cc_wn_on_name`,
  `cc_wn_on`.

(truncated)

The full query and the feature triggering this are unknown.

Query ID: c331886a84959a9d6aa62e86f7f6acc4

Nextcloud v27.1.11