id  select_type     table               partitions  type        possible_keys           key?    key_len?    ref?            rows?   Extra?
1   PRIMARY         <derived2>          NULL        ALL         NULL                    NULL    NULL        NULL            363     Using temporary; Using filesort
1   PRIMARY         p                   NULL        eq_ref      PRIMARY,on_sale_deleted PRIMARY 8           pt.product_id   1       Using where
2   DERIVED         shop_product_terms  NULL        range       term_id                 term_id 4           NULL            362     Using where