explain select * from product join category on product.category = category.id;
alter table product add index category_idx ( category );
alter table product_category add index category_product_idx ( category, product ); // to be confirmed / tested
