4 (0.160)
INSERT INTO oc_tmp_elastic (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("156533", "1", "1000", "179", "1", "101.640000000000", "1"),("156539", "1", "1000", "179", "1", "101.640000000000", "2"),("108139", "2", "1001", "179", "1", "89.220000000000", "3"),("123131", "10", "1", "179", "1", "67.980000000000", "4"),("156517", "1", "0", "179", "1", "65.520000000000", "5"),("156519", "1", "0", "179", "1", "65.520000000000", "6"),("156521", "1", "0", "179", "1", "77.240000000000", "7"),("156527", "1", "0", "179", "1", "84.860000000000", "8"),("156537", "1", "0", "179", "1", "77.240000000000", "9"),("156541", "1", "0", "179", "1", "72.850000000000", "10"),("156555", "1", "0", "179", "1", "77.240000000000", "11"),("156531", "1", "0", "179", "1", "77.240000000000", "12"),("156549", "1", "0", "179", "1", "77.240000000000", "13"),("156553", "1", "0", "179", "1", "72.850000000000", "14"),("57222", "2", "0", "179", "1", "103.820000000000", "15"),("116318", "2", "0", "179", "1", "65.610000000000", "16"),("116316", "2", "0", "179", "1", "62.270000000000", "17")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:844
5 (0.820)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (179)), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())
AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
INNER JOIN `oc_tmp_elastic` AS te ON (te.product_id = p.product_id)
WHERE p2s.store_id = '0' AND p.manufacturer_id = '179' AND p.status_filtru > 0 AND p.price > 0 AND te.product_id IS NOT NULL GROUP BY p.product_id
ORDER BY te.sort ASC
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:854