id | select_type | table | type       | possible_keys                                             | key                                  | key_len | ref                    | rows     | Extra                                          
---+-------------+-------+------------+-----------------------------------------------------------+--------------------------------------+---------+------------------------+----------+------------------------------------------------
 1 | SIMPLE      | PV    | ref|filter | I_PRO_OBJIHM_CODE,I_PRO_PROPLIST_CODE2,I_PRO_ZONEECR_CODE | I_PRO_ZONEECR_CODE|I_PRO_OBJIHM_CODE | 5|5     | const                  | 403 (4%) | Using where; Using filesort; Using rowid filter
 1 | SIMPLE      | PL    | ref        | I_PRO_PROPLIST_CODE1                                      | I_PRO_PROPLIST_CODE1                 | 4       | FLUOR.PV.PROPLIST_CODE | 1        | Using index