Gold Star


Aparat Goldstar Pentru Legat Carlige GS

Aparat Goldstar Pentru Legat Carlige GS

49650999
Livrare imediată!

9,14Lei

Opritoare Gold Star Boilies Siliconice In Rama 99buc

Opritoare Gold Star Boilies Siliconice In Rama 99buc

79630035
Livrare imediată!

4,46Lei

Opritor Dublu GoldStar Negru/Galben L

Opritor Dublu GoldStar Negru/Galben L

79006403
Livrare imediată!

2,53Lei

Vobler GoldStar Perch 2 Culoare 1 4cm

Vobler GoldStar Perch 2 Culoare 1 4cm

87225401
Livrare imediată!

10,06Lei

Vobler GoldStar PERCH 3 Culoare 2 4.5cm 3.5g

Vobler GoldStar PERCH 3 Culoare 2 4.5cm 3.5g

87205502
Livrare 24-48 ore

10,06Lei

Vobler GoldStar Joint 5

Vobler GoldStar Joint 5

87235905
Livrare imediată!

10,06Lei

Vobler GoldStar Popp culoare 2 5cm

Vobler GoldStar Popp culoare 2 5cm

87210502
Livrare 24-48 ore

10,06Lei

Set Plumbi GoldStar Culisanti Picatura IV 4.5-7.5g

Set Plumbi GoldStar Culisanti Picatura IV 4.5-7.5g

54104150
Livrare imediată!

37,61Lei

SET VOBLERE GOLDSTAR UNIVERSAL (4 VOBLERE, 2 STRUNE+CUTIE)

SET VOBLERE GOLDSTAR UNIVERSAL (4 VOBLERE, 2 STRUNE+CUTIE)

83011202
Livrare imediată!

28,35Lei

PILKER GOLDSTAR ECO 40G NEGRU/ARGINT

PILKER GOLDSTAR ECO 40G NEGRU/ARGINT

84305240
Livrare imediată!

11,07Lei

Vobler GoldStar Fat Shad culoare 2 9cm

Vobler GoldStar Fat Shad culoare 2 9cm

87250902
Livrare imediată!

10,06Lei

Inel Gold Star Lansete 2 picioare WCG : 30

Inel Gold Star Lansete 2 picioare WCG : 30

81010030
Livrare imediată!

9,53Lei

VARGA GOLD STAR VIKING 4MT FIBRA DE STICLA

VARGA GOLD STAR VIKING 4MT FIBRA DE STICLA

11001400
Livrare 24-48 ore

38,51Lei

Vobler GoldStar Fat culoare 1 6cm

Vobler GoldStar Fat culoare 1 6cm

87240601
Livrare imediată!

10,06Lei

Inel Gold Star Cu Bucsa (Ceramica Fluo) 31.0mm

Inel Gold Star Cu Bucsa (Ceramica Fluo) 31.0mm

81001310
Livrare 24-48 ore

10,56Lei

Vobler GoldStar Perch 1 Culoare 1 3cm

Vobler GoldStar Perch 1 Culoare 1 3cm

87225301
Livrare 24-48 ore

10,06Lei

Swinger Gold Star ECO 77090 Rosu

Swinger Gold Star ECO 77090 Rosu

77090322
Livrare 24-48 ore

14,93Lei

Vobler GoldStar Bug Culoare 1

Vobler GoldStar Bug Culoare 1

87225201
Livrare imediată!

10,06Lei

Vobler GoldStar Perch 3 Culoare 3 4.5cm

Vobler GoldStar Perch 3 Culoare 3 4.5cm

87205503
Livrare imediată!

10,06Lei

Vobler GoldStar Joint culoare 2

Vobler GoldStar Joint culoare 2

87255802
Livrare imediată!

10,06Lei

Afişare 1 - 20 din 104 (6 pagini)
Queries: 7, Total time: 51.629 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = '3cf71d7e850d371ebb64f63b28'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Gold-Star'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '39' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (25.183)
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 = '39'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (25.869)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '39' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37