+------+-------------+-------+------------+----------------------------------------------------------------------------------------------+---------------------+---------+-----------------------------------------+---------+------------------------------------------------------------------+
| id   | select_type | table | type       | possible_keys                                                                                | key                 | key_len | ref                                     | rows    | Extra                                                            |
+------+-------------+-------+------------+----------------------------------------------------------------------------------------------+---------------------+---------+-----------------------------------------+---------+------------------------------------------------------------------+
|    1 | SIMPLE      | t4    | ref|filter | PRIMARY,SampleId,ExamSettingVersionId,IsArchived,IsDeleted,IX_ArchivedExam,IX_SampleProducer | IsArchived|SampleId | 1|8     | const                                   | 25 (0%) | Using where; Using temporary; Using filesort; Using rowid filter |
|    1 | SIMPLE      | s     | eq_ref     | PRIMARY,SampleTypeId,AssemblyOrderId,IsDeleted                                               | PRIMARY             | 8       | test.t4.SampleId                        | 1       | Using where                                                      |
|    1 | SIMPLE      | p     | eq_ref     | PRIMARY,AssemblyId,IsDeleted,IX_AssemblyDeletedArchived                                      | PRIMARY             | 8       | test.s.AssemblyOrderId                  | 1       | Using where                                                      |
|    1 | SIMPLE      | d     | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 4       | test.p.OperatorId                       | 1       | Using where; Using index                                         |
|    1 | SIMPLE      | s0    | eq_ref     | PRIMARY,IsDeleted                                                                            | PRIMARY             | 2       | test.s.SampleTypeId                     | 1       | Using where                                                      |
|    1 | SIMPLE      | p4    | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 4       | test.p.AssemblyLocationId               | 1       | Using where                                                      |
|    1 | SIMPLE      | d0    | eq_ref     | PRIMARY,IsDeleted                                                                            | PRIMARY             | 4       | test.p4.SubunitId                       | 1       | Using where                                                      |
|    1 | SIMPLE      | p0    | eq_ref     | PRIMARY,PolarityId                                                                           | PRIMARY             | 4       | test.p.AssemblyId                       | 1       |                                                                  |
|    1 | SIMPLE      | g     | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 1       | test.p0.PolarityId                      | 1       | Using index                                                      |
|    1 | SIMPLE      | p1    | eq_ref     | PRIMARY,AssemblyId                                                                           | PRIMARY             | 4       | test.p.AssemblyId                       | 1       |                                                                  |
|    1 | SIMPLE      | p2    | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 2       | test.p1.AssemblyTitleId                 | 1       | Using where                                                      |
|    1 | SIMPLE      | p3    | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 2       | test.p2.AssemblyTitleSetId              | 1       | Using where; Using index                                         |
|    1 | SIMPLE      | u     | eq_ref     | PRIMARY,IsDeleted                                                                            | PRIMARY             | 2       | test.s.ValidationUserAccountId          | 1       | Using where                                                      |
|    1 | SIMPLE      | a     | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 4       | test.t4.ExamSettingVersionId            | 1       | Using index                                                      |
|    1 | SIMPLE      | a0    | eq_ref     | PRIMARY,ExamSettingVersionId                                                                 | PRIMARY             | 4       | test.t4.ExamSettingVersionId            | 1       | Using index                                                      |
|    1 | SIMPLE      | a1    | eq_ref     | PRIMARY,ExamSettingVersionId                                                                 | PRIMARY             | 4       | test.t4.ExamSettingVersionId            | 1       | Using index                                                      |
|    1 | SIMPLE      | t8    | ref        | PRIMARY,TestId,ExaminerFlagId                                                                | PRIMARY             | 8       | test.t4.Id                              | 1       | Using index                                                      |
|    1 | SIMPLE      | a4    | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 4       | test.t8.ExaminerFlagId                  | 1       | Using where                                                      |
|    1 | SIMPLE      | a2    | eq_ref     | PRIMARY,ExamSettingVersionId                                                                 | PRIMARY             | 4       | test.t4.ExamSettingVersionId            | 1       | Using index                                                      |
|    1 | SIMPLE      | u0    | eq_ref     | PRIMARY,IsDeleted                                                                            | PRIMARY             | 2       | test.t4.TechnicalValidatorUserAccountId | 1       | Using where                                                      |
|    1 | SIMPLE      | a3    | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 4       | test.t4.ExaminerIdentifierId            | 1       | Using where; Using index                                         |
|    1 | SIMPLE      | r     | eq_ref     | PRIMARY                                                                                      | PRIMARY             | 8       | test.t4.ResultProducerId                | 1       | Using where                                                      |
|    1 | SIMPLE      | u1    | eq_ref     | PRIMARY,IsDeleted                                                                            | PRIMARY             | 2       | test.r.UserAccountId                    | 1       | Using where                                                      |
+------+-------------+-------+------------+----------------------------------------------------------------------------------------------+---------------------+---------+-----------------------------------------+---------+------------------------------------------------------------------+