explain_old_query.txt

*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: agreement
         type: ref
possible_keys: PRIMARY,customer_id
          key: customer_id
      key_len: 4
          ref: const
         rows: 2
        Extra: Using index
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: product1
         type: ref
possible_keys: agreement_id
          key: agreement_id
      key_len: 4
          ref: main.agreement.id
         rows: 22
        Extra: Using where
2 rows in set (0.13 sec)