Jackall

Jackall

Sortare după:

Lanseta Spinning Jackall T-Connection Comfy TCC-S58UL 1,75m/0,4-3g, 2seg

Lanseta Spinning Jackall T-Connection Comfy TCC-S58UL 1,75m/0,4-3g, 2seg

ja.807217964

Livrare 24-48 ore

973,31Lei(-19%) 792,74Lei

Lingurita Oscilanta Jackall Tearo 2.2cm, 1.6g, Red & Gold Yamame

Lingurita Oscilanta Jackall Tearo 2.2cm, 1.6g, Red & Gold Yamame

f3.ja.212112183

Livrare 24-48 ore

31,75Lei(-26%) 23,60Lei

Lingurita Oscilanta Jackall Tearo Dygomite II, 1.9cm, 1.2g

Lingurita Oscilanta Jackall Tearo Dygomite II, 1.9cm, 1.2g

f3.ja.418092045

Livrare 24-48 ore

37,06Lei(-36%) 23,61Lei

Vobler Jackall TN70 Trigon, Spark Punch Gill, 7cm, 31.5g

Vobler Jackall TN70 Trigon, Spark Punch Gill, 7cm, 31.5g

ja.807214567

Livrare 24-48 ore

123,27Lei

Vobler Jackall Chibi Panicra DR, Endo Glow Pelle Brown, 2.5cm, 1.4g

Vobler Jackall Chibi Panicra DR, Endo Glow Pelle Brown, 2.5cm, 1.4g

ja.807191332

Livrare 24-48 ore

81,45Lei

Vobler Jackall Panicra DR, Tackey Glow Yamame, 3.2cm, 3.6g

Vobler Jackall Panicra DR, Tackey Glow Yamame, 3.2cm, 3.6g

ja.418098894

Livrare 24-48 ore

84,68Lei

Vobler JACKALL Chubby 41F, Brown Suji Shrimp, 4.1cm, 5.5g

Vobler JACKALL Chubby 41F, Brown Suji Shrimp, 4.1cm, 5.5g

ja.807280586

Livrare 24-48 ore

91,94Lei

Cicada JACKALL Speed Vibe, Prism Magic, 4.2cm, 7g

Cicada JACKALL Speed Vibe, Prism Magic, 4.2cm, 7g

ja.807296167

Livrare 24-48 ore

86,50Lei

Vobler Jackall Tricoroll GT 56SR-F Green Gold Ayu 5.6cm 3.7g

Vobler Jackall Tricoroll GT 56SR-F Green Gold Ayu 5.6cm 3.7g

ja.418097408

Livrare 24-48 ore

79,64Lei(-38%) 49,59Lei

Vobler Jackall Tricoroll Ryushin 63HW Silver Yamame 6.3cm 7g

Vobler Jackall Tricoroll Ryushin 63HW Silver Yamame 6.3cm 7g

ja.807171266

Livrare 24-48 ore

100,94Lei

Vobler Jackall Mushbob 50SR Muddy Chart Fish 5cm 9g

Vobler Jackall Mushbob 50SR Muddy Chart Fish 5cm 9g

ja.807193039

Livrare 24-48 ore

95,51Lei(-28%) 68,98Lei

Cicada Jackall Knockin Jaw, Babataku White Claw, 3/8oz, 5.2cm

Cicada Jackall Knockin Jaw, Babataku White Claw, 3/8oz, 5.2cm

ja.807168969

Livrare 24-48 ore

62,25Lei(-37%) 38,97Lei

Lingurita Oscilanta Jackall Tearo 2.2cm, 1.3g, Green Yamame

Lingurita Oscilanta Jackall Tearo 2.2cm, 1.3g, Green Yamame

f3.ja.212111988

Livrare 24-48 ore

31,75Lei(-26%) 23,60Lei

Vobler Jackall TN38 Noike Piero, 3.8cm, 5.1g

Vobler Jackall TN38 Noike Piero, 3.8cm, 5.1g

ja.807246452

Livrare imediată!

102,41Lei

Vobler Jackall TN50 Trigon, Noike Gill, 5.2cm, 11.2g

Vobler Jackall TN50 Trigon, Noike Gill, 5.2cm, 11.2g

ja.807263824

Livrare 24-48 ore

104,92Lei(-28%) 75,67Lei

Vobler Jackall TN70 Trigon, Baba Taku Akakin Laser, 7cm, 31.5g

Vobler Jackall TN70 Trigon, Baba Taku Akakin Laser, 7cm, 31.5g

ja.807264036

Livrare 24-48 ore

129,72Lei

Lingurita Oscilanta Jackall Tearo, Genkotsu Yazimite, 2.2cm, 1.6g

Lingurita Oscilanta Jackall Tearo, Genkotsu Yazimite, 2.2cm, 1.6g

f3.ja.807264265

Livrare 24-48 ore

34,55Lei(-26%) 25,60Lei

Vobler Jackall Pepino SR, Takey Brown Orange, 5.6cm, 2.2g

Vobler Jackall Pepino SR, Takey Brown Orange, 5.6cm, 2.2g

ja.807256321

Livrare 24-48 ore

88,84Lei

Vobler JACKALL Chubby 38F Silent, UV Mat Chart Perch, 3.8cm, 3.9g

Vobler JACKALL Chubby 38F Silent, UV Mat Chart Perch, 3.8cm, 3.9g

ja.807283266

Livrare 24-48 ore

108,48Lei

Vobler JACKALL D Chubby Minnow 3SSP, HL Silver & Black, 3.5cm, 2.7g

Vobler JACKALL D Chubby Minnow 3SSP, HL Silver & Black, 3.5cm, 2.7g

ja.807065626

Livrare 24-48 ore

87,76Lei

Afişare 401 - 420 din 562 (29 pagini)

Queries: 7, Total time: 92.625 ms [By time] [By id] [By file]

1 (0.132)

SELECT data
FROM `oc_session`
WHERE session_id = '811c3f26333fe49c312693c647'

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

2 (0.082)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.112)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Jackall'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.109)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '150' AND m2s.store_id = '2'

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

5 (52.436)

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 = '2' AND p.manufacturer_id = '150'

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

6 (39.632)

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 = '2' AND p.manufacturer_id = '150' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 400,20

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

7 (0.122)

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

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