Căutare

Queries: 13, Total time: 1,927.939 ms [By time] [By id] [By file]

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = 'c4bf01ce5f24077b5ba8b8cb9a'

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

2 (0.077)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.110)

SELECT `trigger`, `action`
FROM oc_event

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

4 (993.288)

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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%3%' AND pd.tag LIKE '%5%')) 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:698

5 (4.813)

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

6 (279.275)

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 220, 20

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

7 (47.540)

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

8 (0.114)

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

9 (11.326)

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

10 (590.851)

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

11 (0.196)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

12 (0.128)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

13 (0.132)

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

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

Produse ce potrivesc criteriilor de căutare

Bluza UV Zeck Longsleeve, Marime 3XL

Fir Monofilament MOMOI Cast Mania Mono, Flash Orange, 0.309mm, 7.20kg, 1200m

Fir Monofilament MOMOI Cast Mania Mono, Wasabi Green, 0.286mm, 6.31kg, 1200m

Fir Monofilament KAMATSU Techron Method Feeder Fast Sinking, Brown, 0.26mm, 7.95kg, 300m

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Mulineta DAM Feeder Quick 1 4000FD

Mulineta Fl Strategist Tx 14000 Silver

Mulineta DAM Feeder Quick 2 4000FD

MULINETA DAIWA TDR CAST IZM FEEDER 25QD

LANSETA DAIWA 2SEG NINJA X CARP 3.90M 3.5LBS

Cosulet, Feeder, Water, Magic, Semi-rotund, Basket-1, 30, Gr, clm216571, Cosulete Feeder, Cosulete Feeder Water Magic , Water Magic

Cosulet Feeder Water Magic Trapez Basket-3 50Gr

Mulineta FL SF 5000

LANSETA, PROLOGIC, C-SERIES, 3.90M, 3.5LBS, 2SEG, o.pro.72636, Lansete Crap, Lansete Crap Prologic, Prologic

Montura FL Textil Momitor MV2 55 Gr Cu Porumb Carlig Wide Gape Nr 6

Lanseta FL FLX10 3.60M 3.75Lbs 2Seg

Cosulet Feeder Water Magic Trapez Basket-3 90Gr

Wafter 220Baits Supreme 10 mm alb & roz

Nada Claumar Special Betaina Galben 3KG

ANTI TANGLE 15CM CORMORAN 3BUC/PLIC

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare