id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | object_query_2 | index | PRIMARY | PRIMARY | 4 | 199 | Using index | |
1 | PRIMARY | objects | eq_ref | PRIMARY, published, type_path_classId | PRIMARY | 4 | pimcore.object_query_2.oo_id | 1 | Using where |
1 | PRIMARY | nl | ref | PRIMARY, IDX_C03BA3D7A94707C7 | IDX_C03BA3D7A94707C7 | 4 | pimcore.object_query_2.oo_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 |