Căutare - Etichetă - 86965010

💬

WhatsApp Chat

👋 Salut! Cu ce va pot ajuta?

Pot raspunde la intrebari despre:
✅ Comenzi si status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 12, Total time: 2.526 ms [By time] [By id] [By file]

1 (0.146)

SELECT data
FROM `oc_session`
WHERE session_id = '226b55a63ae660d6927036bfea'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.154)

CREATE TEMPORARY TABLE oc_tmp_elastic ( 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:1000

3 (0.108)

INSERT INTO oc_tmp_elastic (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("158619", "1", "1000", "24", "1", "10.66", "1"),("158595", "1", "1000", "24", "1", "9.01", "2"),("158615", "1", "1000", "24", "1", "10.66", "3"),("158617", "1", "1000", "24", "1", "10.66", "4"),("158621", "1", "1000", "24", "1", "10.66", "5"),("158623", "1", "1000", "24", "1", "10.66", "6"),("158585", "2", "1000", "401", "1", "10.66", "7"),("158605", "2", "1000", "401", "1", "12.31", "8"),("158597", "1", "1002", "24", "1", "9.01", "9"),("158603", "1", "1001", "24", "1", "9.01", "10"),("158599", "1", "1001", "24", "1", "9.83", "11"),("158601", "1", "1000", "24", "1", "9.01", "12"),("158519", "1", "1004", "24", "1", "10.66", "13"),("158609", "2", "1001", "401", "1", "12.31", "14"),("158611", "2", "1001", "401", "1", "11.49", "15"),("158525", "2", "1000", "401", "1", "10.66", "16"),("158587", "2", "1000", "401", "1", "11.49", "17"),("158589", "2", "1000", "401", "1", "10.66", "18"),("158591", "2", "1000", "401", "1", "10.66", "19"),("158607", "2", "1000", "401", "1", "12.31", "20"),("158613", "2", "1000", "401", "1", "10.66", "21"),("158593", "2", "1000", "401", "1", "10.66", "22")

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1012

4 (0.868)

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 (24)), 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` GROUP BY tax_class_id) 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 = '24' 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:1022

5 (0.164)

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

6 (0.232)

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

7 (0.174)

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:1619

8 (0.118)

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:1647

9 (0.099)

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:1374

10 (0.251)

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1272

11 (0.097)

SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1312

12 (0.115)

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