On some MySql versions, the price indexer runs very slow.

[albertdahlin]

[albertdahlin]

The array of product ids contains values of mixed type string and ints. This causes the where part of the mysql query to look like this.

WHERE entity_id IN (123, '124', '125')

On some server versions this causes a full table scan instead of an index search.