id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY pt index PRIMARY PRIMARY 110 69347 Using where; Using index; Using temporary; Using filesort
1 PRIMARY bp ref PRIMARY PRIMARY 4 steiermark_vacancies.pt.id 1 Using where
2 DEPENDENT SUBQUERY objects eq_ref PRIMARY PRIMARY 4 steiermark_vacancies.pt.product_id 1 Using where; Using index
2 DEPENDENT SUBQUERY object_query_6 eq_ref PRIMARY PRIMARY 4 steiermark.objects.o_id 1