witch version espocrm ?
witch field on layout ?
i have remove all your custom field and execute the sql on my computer : 30ms
you have increase to 101 listview record ?
can you remove from layout this field LEFT JOIN `attachment` AS `ploha` ON account.ploha_id = ploha.id
i don't see ploha_id on index .. maybe you need run Yuri script.
test on clone instance

Leave a comment: