Mysql,show processlist, query has been sending data, affecting query performance

MariaDB [(None)]> show processlist;

+--------+--------+------------------+---------+-------------+---------+---------------+----------------------+ --------

| Id | User | Host | db | Command | Time | State | Info | Progre

| 287662 | Root | localhost:41583 | Finance |  Query | 665767 | Sending Data |    SELECT COUNT (*) from ' cash_beorder ' INNER JOIN ' Cash_account ' on (' Cash_beorder '. ' account_id ' = ' CA | 0.00

| 287663 | Root | localhost:41626 | Finance |  Query | 665766 | Sending Data |    SELECT COUNT (*) from ' cash_beorder ' INNER JOIN ' Cash_account ' on (' Cash_beorder '. ' account_id ' = ' CA | 0.00

| 287664 | Root | localhost:41990 | Finance |  Query | 665751 | Sending Data |    SELECT COUNT (*) from ' cash_beorder ' INNER JOIN ' Cash_account ' on (' Cash_beorder '. ' account_id ' = ' CA | 0.00

| 287665 | Root | localhost:42153 | Finance |  Query | 665744 | Sending Data |    SELECT COUNT (*) from ' cash_beorder ' INNER JOIN ' Cash_account ' on (' Cash_beorder '. ' account_id ' = ' CA | 0.0

MySQL query, has been in the sending data state, query card dead, affecting the performance of MySQL query, time to show that the query statement has been executed.

Workaround: Kill the corresponding ID of the card that is dead

>kill ID

Mysql,show processlist, query has been sending data, affecting query performance