Căutare

Queries: 11, Total time: 923.426 ms [By time] [By id] [By file]

1 (0.146)

SELECT data
FROM `oc_session`
WHERE session_id = '2dbd4d524d12ed6640dff2c8f4'

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

2 (0.077)

SELECT `trigger`, `action`
FROM oc_event

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

3 (687.126)

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 "%50%") 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.200)

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 (70.683)

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

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

6 (0.196)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'

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

7 (12.330)

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

8 (0.120)

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

9 (2.797)

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

10 (148.573)

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

11 (0.177)

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

LANSETA CARP ZOOM SPOD SPEC-C 3.60m 4.50lbs

PILKER SPRO CAST X HERING 60GR

CUTIE MOMELI TRABUCCO BAIT BOX 250GR BLUE

EXPRESS ATRACTOR CARP ZOOM 50ml SPICY

Inel EnergoTeam Varf Match SIC UMHSIT 4x1.0mm

Carlig Owner 50061 Auriu Semirotund Nr 6 - 12buc/plic

VIDRAX PLUTA BALSA MODEL007, 1,50G

VARF TRABUCCO SYGNUM TXL STILLWATER FEEDER LIGHT

Vobler Strike Pro Baby Buster, C544V, 25g, 10cm

BOILIES KRILL-TUNA SHELF LIFE 18MM 5KG

LANSETA COLMIC GHEMON PRO 2.40M 300GR

Momitor Delphin zinc striat cu tub 60g

Lanseta Carp Expert Method Feeder Pink 3.60m 100-150g 3seg

Bazooka DAM MAD Travel Rod Tube Telescopic 220cm

Fir ASSO Ultra Low Stretch Smoke 0.22mm 150m

Stoper Browning Xitan Super Stopper Oval L

Fir ASSO Ultra Cast Galben Fluo 0.14mm 150m

Momitor Energo Team Feeder Apa Curgatoare 150g

LANSETA LINEAEFFE IMPULSE II FEEDER 3.90M 70 150G 3 3SEGMENTE

FIR MONOFILAMENT CARBOTEX BOILIE CARP 033MM/14,45KG/500M

Produsul a fost adăugat în coș

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

Căutare

Produse ce potrivesc criteriilor de căutare