This query is inherently heavy and there are not enough resources allocated to your MySql server to run it.
1) Is there a way to limit the possibility to choose options, 2) adding some index or 3) do you have any other suggestion to solve this?
1) use a different control type, i.e. "select" instead of "AND multiselect"; there's no other way to limit the number of selection (unless you do some JS customization)
2) this query and the underlying tables already make full use of indexes; see for yourself using the 'EXPLAIN' sytax
3) the critical part seem the 'AND multiselect' part (field = antal); we know from tests that 'AND multiselect' is way heavier than 'OR multiselect'; if possible, change the search control type. If that's not an option you'll need a beefier server and/or you need to be give more resources.
Feel free to contact us via email, if you want to discuss details in a more private form.
