1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = '03b330fb0e014b19fe58d25b9a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.511)
CREATE TEMPORARY TABLE oc_bf_tmp_product (
product_id int PRIMARY KEY,
sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id)
) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1016
3 (0.639)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("255070", "2", "1000", "59", "1", "60.25", "1"),("81513", "2", "1002", "109", "1", "42", "2"),("137877", "2", "1000", "73", "1", "132.15", "3"),("242648", "1", "1000", "73", "1", "132.15", "4"),("117539", "2", "5", "168", "1", "34.63", "5"),("144515", "2", "1003", "353", "1", "67.69", "6"),("22094", "2", "1000", "76", "1", "61.07", "7"),("210237", "2", "1000", "476", "1", "68.14", "8"),("255507", "2", "1000", "533", "1", "74.3", "9"),("255508", "2", "1000", "533", "1", "74.3", "10"),("47826", "2", "1003", "75", "1", "42.07", "11"),("102303", "2", "1000", "204", "1", "60.25", "12"),("205679", "2", "1000", "476", "1", "68.14", "13"),("228185", "2", "1000", "168", "1", "44.55", "14"),("143301", "2", "0", "47", "1", "46.88", "15"),("255935", "1", "0", "47", "1", "70.99", "16"),("44540", "2", "0", "287", "1", "18", "17"),("192845", "2", "0", "121", "1", "41.6", "18"),("255711", "2", "0", "533", "1", "29.31", "19"),("111637", "2", "0", "168", "1", "47.48", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1025
4 (0.609)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1617
5 (1.016)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:198
6 (0.135)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%NASH NOU%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
7 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%KORDA EUROPE BV%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
8 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%KORDA EUROPE BV%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
9 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%ARROW INTERNATIONAL%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
10 (0.097)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%CIPHER EUROPE SRO%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
11 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%SONIK SPORTS CZ LOGISTICS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
12 (0.077)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%SONIK SPORTS CZ LOGISTICS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
13 (0.076)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%RAPALA VMC ROMANIA SRL%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
14 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%CIPHER EUROPE SRO%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
15 (0.071)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%FOX INTERNATIONAL GROUP LTD%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
16 (0.074)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
17 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
18 (0.068)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%HEROS EXPORT-IMPORT SRL%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
19 (0.076)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%PURE FISHING EUROPE SAS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
20 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%SONIK SPORTS CZ LOGISTICS%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
21 (0.071)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%FOX INTERNATIONAL GROUP LTD%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:132
22 (0.213)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)),
LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1630
23 (0.110)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1658
24 (0.109)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1385
25 (0.303)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1283
26 (0.084)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37