Savage Gear


Vobler, Savage, Gear, Gravity, Twitch, SR, Ayu, Chrome, 6.7cm, 6g, sg.71651, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler, Savage, Gear, Gravity, Crank, MR, Dirty, Roach, 7.3cm, 19g, sg.71688, Voblere Floating, Voblere Floating Savage Gear, Savage Gear -42%
SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G BLUE PEARL 5BUC/PLIC -40%

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G BLUE PEARL 5BUC/PLIC

f1.sg.72412
Livrare 24-48 ore

36,85Lei(-40%) 22,11Lei

TRICOU SAVAGE GEAR CANNIBAL BLACK MAR. M -23%

TRICOU SAVAGE GEAR CANNIBAL BLACK MAR. M

a8.sg.71578
Livrare imediată!

146,07Lei(-23%) 112,36Lei

VOBLER, SAVAGE, GEAR, 3D, STICKLEBAIT, TWITCH, 5.5CM, 7G, GREEN, SILVER, sg.72319, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND F 2,51M/10-35G

LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND F 2,51M/10-35G

o.sg.74881
Livrare imediată!

445,10Lei

Shad SAVAGE GEAR CRAFT 8.8CM/4,6G PERCH 4BUC/PL -40%

Shad SAVAGE GEAR CRAFT 8.8CM/4,6G PERCH 4BUC/PL

f1.sg.74084
Livrare 24-48 ore

30,88Lei(-40%) 18,53Lei

VOBLER, SAVAGE, GEAR, GRAVITY, TWITCH, 9.5CM/15G, SUSPENDING, BTS, sg.74116, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear -20%
GRIP SAVAGE GEAR LRP LIP ALU 13,5CM

GRIP SAVAGE GEAR LRP LIP ALU 13,5CM

a.sg.71159
Livrare imediată!

127,93Lei

VOBLER, SAVAGE, GEAR, 3D, SMASH, TAIL, RUDD, 8CM, 12G, sg.76785, Voblere Floating, Voblere Floating Savage Gear, Savage Gear
LINGURITA ROTATIVA SAVAGE GEAR ROTEX NR.3 FLUO ORANGE SILVE 8G

LINGURITA ROTATIVA SAVAGE GEAR ROTEX NR.3 FLUO ORANGE SILVE 8G

f.sg.42126
Livrare 24-48 ore

16,58Lei

JACHETA SAVAGE PRO GUARD THERMO MAS.M

JACHETA SAVAGE PRO GUARD THERMO MAS.M

a8.sg.47900
Livrare 24-48 ore

492,70Lei

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XXXL -20%

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XXXL

a8.sg.76595
Livrare 24-48 ore

970,46Lei(-20%) 776,37Lei

Shad, Savage, Gear, Cannibal,, Chartreuse, Pumpkin,, 8cm,, 5g,, 5buc/pac, f1.sg.77136, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Cannibal,, Purple, Glitter, Bomb,, 6.8cm,, 3g,, 5buc/pac, f1.sg.77130, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Fat Minnow T-Tail, Smelt, 7.5cm, 5g, 5buc/pac -40%

Shad Savage Gear Fat Minnow T-Tail, Smelt, 7.5cm, 5g, 5buc/pac

f1.sg.76982
Livrare 24-48 ore

30,38Lei(-40%) 18,23Lei

Vobler, Savage, Gear, Gravity, Minnow, Cristal, White, Glow,, 5cm,, 8g, sg.73518, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
Lingurita, Rotativa, Savage, Gear, Spinner, Grub,, Sinking,, Silver, Red, Lime,, Nr.2,, 5.8g, sg.82468, Lingurite Rotative, Lingurite Rotative Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, Lemon, Glow,, 10.0cm,, 6.8g,, 5buc/pac, f1.sg.1609127, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE, GEAR, 3D, GOBY, CRANK, SR, 4CM/3G, GOB, sg.71724, Voblere Sinking, Voblere Sinking Savage Gear, Voblere Savage Gear, Sinking Savage Gear, Savage Gear
Afişare 41 - 60 din 1427 (72 pagini)
Queries: 7, Total time: 95.951 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '0412b7ca1caa2ea8b427bc8f30'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '85' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.587)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '85'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (52.747)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.130)
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