| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | objects | range | PRIMARY, published, type_path_classId | PRIMARY | 4 | 859 | Using where | |
| 1 | PRIMARY | object_query_1 | eq_ref | PRIMARY | PRIMARY | 4 | pimcore.objects.o_id | 1 | Using index |
| 1 | PRIMARY | fr | ref | PRIMARY, IDX_E058BB52A94707C7 | IDX_E058BB52A94707C7 | 4 | pimcore.objects.o_id | 1 | Using where; Using index |
| 3 | DEPENDENT SUBQUERY | plugin_datahub_workspaces_object | ALL | 1 | Using where; Using filesort | ||||
| 2 | DEPENDENT SUBQUERY | plugin_datahub_workspaces_object | ALL | 1 | Using where; Using filesort |