Slow performance of MySQL Join Query
Please provide SHOW CREATE TABLE; the explain is useless without it.

OR is a performance killer in many contexts.


  ( p.pricelist = "name_abc" AND p.iln = "sellerID_123" ) OR 
  ( p.pricelist = "name_def" AND p.iln = "sellerID_456" ) OR ...


Turn that into

JOIN ( SELECT id FROM p WHERE 
( p.pricelist = "name_abc" AND p.iln = "sellerID_123" ) OR 
( p.pricelist = "name_def" AND p.iln = "sellerID_456" ) OR ... ) x ON x.id = foo.id


Also needed (on p):

INDEX(pricelist, iln, id)

(With the CREATEs, I could be more specific.)

The idea behind this "trick" is to move the costly work of the OR into a subquery that returns the necessary ids.  Plus the INDEX makes it so that it can do all that work in the INDEX.