Filtreaza

Naluca Wizard Soft Lure 004 3.5cm 6buc/plic
Exclusiv online!

Naluca Wizard Soft Lure 004 3.5cm 6buc/plic

86951040
Livrare 24-48 ore

12,25Lei

Creatura Jackall Scissor Comb Baby Zarigani 6.3cm 10buc/plic -20%
Exclusiv online!

Creatura Jackall Scissor Comb Baby Zarigani 6.3cm 10buc/plic

f1.ja.807199710
Livrare 24-48 ore

66,44Lei(-20%) 53,15Lei

Naluca Wizard Nymph 002 3cm 10buc/plic
Exclusiv online!

Naluca Wizard Nymph 002 3cm 10buc/plic

86961020
Livrare 24-48 ore

10,92Lei

Naluca Wizard Soft Lure 002 3.5cm 6buc/plic
Exclusiv online!

Naluca Wizard Soft Lure 002 3.5cm 6buc/plic

86951020
Livrare 48-72 ore

12,25Lei

Creatura Live Target Hollow Crawfish Jig, Mud / Blue, 4.5cm, 14g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Mud / Blue, 4.5cm, 14g

f1.lt.chb45s147
Livrare 24-48 ore

42,88Lei

Creatura Live Target Hollow Crawfish Jig, Junebug / Chartreuse, 4cm, 11g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Junebug / Chartreuse, 4cm, 11g

f1.lt.chb40s148
Livrare 24-48 ore

38,60Lei

Creatura Live Target Hollow Crawfish Jig, Green / Chartreuse, 4.5cm, 14g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Green / Chartreuse, 4.5cm, 14g

f1.lt.chb45s146
Livrare 24-48 ore

42,88Lei

Creatura Live Target Hollow Crawfish Jig, Red, 4cm, 11g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Red, 4cm, 11g

f1.lt.chb40s306
Livrare 24-48 ore

38,60Lei

Creatura Fox Critter 7cm - Uv Green Pumpkin

Creatura Fox Critter 7cm - Uv Green Pumpkin

nri056
Livrare imediată!

4,95Lei

Creatura Live Target Hollow Crawfish Jig, Mud / Blue, 4cm, 11g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Mud / Blue, 4cm, 11g

f1.lt.chb40s147
Livrare 24-48 ore

38,60Lei

Creatura Fox Critter 9cm - Uv Green Pumpkin
Exclusiv online!

Creatura Fox Critter 9cm - Uv Green Pumpkin

nri053
Livrare 7-14 zile

5,40Lei

Soarece Live Target Hollow Body Mouse Walking Bait, Brown / White, 7cm, 14g -20%
Exclusiv online!

Soarece Live Target Hollow Body Mouse Walking Bait, Brown / White, 7cm, 14g

lt.mhb70t400
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Creatura Strike King Rage Ned Bug, Watermelon Red Flake, 6.5cm, 9buc/plic

Creatura Strike King Rage Ned Bug, Watermelon Red Flake, 6.5cm, 9buc/plic

rgnbug-18
Livrare imediată!

31,46Lei

Creatura Live Target Hollow Crawfish Jig, Natural / Brown, 4.5cm, 14g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Natural / Brown, 4.5cm, 14g

f1.lt.chb45s723
Livrare 24-48 ore

42,88Lei

Creatura Fox Critter 7cm - Uv Hot Olive

Creatura Fox Critter 7cm - Uv Hot Olive

nri058
Livrare imediată!

4,95Lei

Creatura Strike King Rage Bug Culoare Summer Craw 10cm 7buc/plic -34%

Creatura Strike King Rage Bug Culoare Summer Craw 10cm 7buc/plic

rgbug-100
Livrare imediată!

31,46Lei(-34%) 20,90Lei

Creatura Live Target Hollow Crawfish Jig, Green / Chartreuse, 4cm, 11g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Green / Chartreuse, 4cm, 11g

f1.lt.chb40s146
Livrare 24-48 ore

38,60Lei

Creatura Strike King Rage Bug Culoare Bama Craw 10cm 7buc/plic -34%

Creatura Strike King Rage Bug Culoare Bama Craw 10cm 7buc/plic

rgbug-101
Livrare imediată!

31,46Lei(-34%) 20,90Lei

Creatura Live Target Hollow Crawfish Jig, Red, 4.5cm, 14g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Red, 4.5cm, 14g

f1.lt.chb45s306
Livrare 24-48 ore

42,88Lei

Creatura Live Target Hollow Crawfish Jig, Junebug / Chartreuse, 4.5cm, 14g
Exclusiv online!

Creatura Live Target Hollow Crawfish Jig, Junebug / Chartreuse, 4.5cm, 14g

f1.lt.chb45s148
Livrare 24-48 ore

42,88Lei

Afişare 41 - 60 din 567 (29 pagini)


Queries: 11, Total time: 12.917 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'c837d5bfabad3b7e66d1f6d99e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'naluci-artificiale'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.082)
SELECT *
FROM oc_url_alias
WHERE keyword = 'creaturi'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.404)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '521' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
7 (9.193)
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_to_category` AS p2c ON (p.product_id = p2c.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 = '2' AND p2c.category_id = '521' 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
8 (2.435)
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 DESC LIMIT 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
9 (0.126)
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
10 (0.110)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38