Căutare

Queries: 10, Total time: 996.341 ms [By time] [By id] [By file]

1 (0.142)

SELECT data
FROM `oc_session`
WHERE session_id = '4427b9ca9404218c1dc64d4967'

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

2 (0.081)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:428

3 (732.740)

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, "1" 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)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%și%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

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

4 (1.221)

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

5 (72.810)

SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 17520, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (11.622)

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

7 (0.177)

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

8 (2.724)

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

9 (174.677)

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

10 (0.147)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produse ce potrivesc criteriilor de căutare

SINA WEAVER M12/M98/ZASTAVA70 2 BUC

JACHETA VERNEY CARRON SIKA KAKI MARIME XL

JACHETA PROLOGIC TRAVERSE REVERSIBILA MARIME XL

Cizme Treesco Percussion Rambouillet Cauciuc Mar. 45

SINA RECKNAGEL PICATINNY AL. WINCHESTER M70 1BUC LUNGA

INSIGNA BROWNING FAZAN

SINA RECKNAGEL PICATINNY AL. WINCHESTER XPR 1BUC SCURTA

PANTALONI VERNEY CARRON SIKA KAKI MARIMEA 50

SINA WEAVER BROWNING BLR OTEL 2BUC

TOC ARROW ESP PENTRU 3 CATUSE DE UNICA FOLOSINTA

JACHETA SAVAGE SALT PACK-LITE MARIME L

Manusi Treesco Percussion Neopren Verzi Mar. M

Cizme Treesco Percussion Rambouillet Cauciuc Mar. 43

JACHETA VERNEY-CARRON SIKA KAKI MARIMEA L

PANTALON FIRST LAYER PRIMAVERA SPRING DRYARN MARIMEA M

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL WIDE

VESTA TREESCO PERCUSSION SAVANE REVERSIBILA KAKI BLAZE MARIME 2XL

Jacheta Verney-Carron Fleece Reversible Masura S

SINA RECKNAGEL PICATINNY AL. A.BOLT III 1BUC SCURTA

VESTA TREESCO PERCUSSION SAVANE REVERSIBILA MARO MARIME M

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare