Have problem with this module.
If choose feature value, on 2 off 3 servers no result from ajax. Tested all function and found problem in this query:
if (!empty($sql_query['from'])) { $sql_query['from'] .= Shop::addSqlAssociation('product', 'p'); $products = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql_query['select']."\n".$sql_query['from'].\n".$sql_query['join']."\n".$sql_query['where']."\n".$sql_query['group']); }
Printed out query and tried to execute it directly to phpmyadmin. 2 servers executed it more than 20 s, one server in 0,00002 - 1,5 s interval. Maybe somebody know the problem?
Query is big: WHERE in (more than 5000 items here)