如何使用多个连接优化查询？

I have simple but long query which count the content of the result it takes about 14 seconds. the count itself on the main table takes less than a second but after multiple join the delay is too high as followI have simple but long query which count the co