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 |