{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Calibri;}} {\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\sa200\sl276\slmult1\lang7\f0\fs22 *************************** 1. row ***************************\par id: 1\par select_type: PRIMARY\par table: \par type: ALL\par possible_keys: NULL\par key: NULL\par key_len: NULL\par ref: NULL\par rows: 4\par Extra: Using temporary; Using filesort\par *************************** 2. row ***************************\par id: 1\par select_type: PRIMARY\par table: ind\par type: ref\par possible_keys: ind_kll_id\par key: ind_kll_id\par key_len: 4\par ref: list.kll_id\par rows: 4\par Extra:\par *************************** 3. row ***************************\par id: 1\par select_type: PRIMARY\par table: com\par type: index\par possible_keys: NULL\par key: site_kll_id\par key_len: 53\par ref: NULL\par rows: 2655\par Extra: Using index\par *************************** 4. row ***************************\par id: 2\par select_type: DERIVED\par table: inv\par type: ref\par possible_keys: PRIMARY,ina_all_time\par key: ina_all_time\par key_len: 4\par ref:\par rows: 58275\par Extra: Using where; Using index\par *************************** 5. row ***************************\par id: 2\par select_type: DERIVED\par table: kll\par type: eq_ref\par possible_keys: PRIMARY,kll_ship_id,kll_victim_id,kll_all_id,kll_crp_id,kll_system_id\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.inv.ina_kll_id\par rows: 1\par Extra:\par *************************** 6. row ***************************\par id: 2\par select_type: DERIVED\par table: plt\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_victim_id\par rows: 1\par Extra:\par *************************** 7. row ***************************\par id: 2\par select_type: DERIVED\par table: crp\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_crp_id\par rows: 1\par Extra:\par *************************** 8. row ***************************\par id: 2\par select_type: DERIVED\par table: ali\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_all_id\par rows: 1\par Extra:\par *************************** 9. row ***************************\par id: 2\par select_type: DERIVED\par table: fbplt\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_fb_plt_id\par rows: 1\par Extra:\par *************************** 10. row ***************************\par id: 2\par select_type: DERIVED\par table: fb\par type: ref\par possible_keys: ind_kll_id,ind_plt_id,ind_crp_id,ind_plt_time,ind_all_id\par key: ind_plt_time\par key_len: 4\par ref: ev0ke_kb2.fbplt.plt_id\par rows: 2\par Extra: Using where\par *************************** 11. row ***************************\par id: 2\par select_type: DERIVED\par table: fbcrp\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.fb.ind_crp_id\par rows: 1\par Extra:\par *************************** 12. row ***************************\par id: 2\par select_type: DERIVED\par table: fbali\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.fb.ind_all_id\par rows: 1\par Extra:\par *************************** 13. row ***************************\par id: 2\par select_type: DERIVED\par table: sys\par type: eq_ref\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_system_id\par rows: 1\par Extra:\par *************************** 14. row ***************************\par id: 2\par select_type: DERIVED\par table: shp\par type: eq_ref\par possible_keys: PRIMARY,shp_class\par key: PRIMARY\par key_len: 4\par ref: ev0ke_kb2.kll.kll_ship_id\par rows: 1\par Extra: Using where\par *************************** 15. row ***************************\par id: 2\par select_type: DERIVED\par table: scl\par type: const\par possible_keys: PRIMARY\par key: PRIMARY\par key_len: 4\par ref:\par rows: 1\par Extra:\par 15 rows in set (26 min 38.65 sec)\par }