Re: How should I config the my.ini(or my.cnf) file for mysql?

[Rick James]

SHOW CREATE TABLE surveys;

The first SELECT probably needs these on `surveys`:
INDEX(Survey_Type, id_rep) for the inner query, and
INDEX(id_rep) for the JOIN.

chats probably needs
INDEX(chat_type, id_rep)

Aha, here is the real killer -- you have create temp tables without indexes.
Instead of "CREATE TEMPORARY TABLE Foo_Temp AS SELECT ...", do
CREATE TEMPORARY TABLE Foo_Temp (PRIMARY KEY id_rep) AS SELECT ...

That will make these _much_ more efficient:
Left Join Surveys_Temp As S ON S.Id_Rep = R.Id_Rep
Left Join Orders_Temp As O ON O.Id_Rep = R.Id_Rep
Left Join Chats_Temp As C on c.id_rep = R.Id_Rep

Also provide output of
EXPLAIN SELECT ...;
for each of the SELECTs -- those in the CREATEs, and the final query.