SET SESSION query_cache_type=0;
select SQL_CALC_FOUND_ROWS g.id_galery_obfuscated,g.author,g.id_tezaver,g.title,g.height_px_thumb,g.width_px_thumb,t.id_tezaver_obfuscated,SUBSTRING_INDEX(group_concat(t.term order by t.eunis ),',',1) as term,ttxs.source as taxonomy_src, breed_cultivar.breed_cultivar,group_concat(distinct t1.term) as term_g
from galery_1 g
left join tezaver t on g.id_tezaver = t.id_tezaver and t.l2 = 'la'
left join tezaver_taxonomy_source ttxs on g.id_tezaver = ttxs.id_tezaver
join tezaver t1 on g.id_tezaver = t1.id_tezaver and t1.l2 = 'la'
left join galery_1_breed_cultivar breed_cultivar on g.id_galery = breed_cultivar.id_galery
where 1 = 1 and (g.image_quality >= 1 or g.image_quality is null)
group by g.id_galery
having term_g like '%agaricus%'
order by g.id_galery desc
limit 0,18
/* Affected rows: 0 Found rows: 18 Warnings: 0 Duration for 2 queries: 0,280 sec. (+ 34,118 sec. network) */
How is that network 34 sec for 18 records? I'm sure it is not.
Removing SQL_CALC_FOUND_ROWS from query does it all together in 1.5 sec.