Jackall


LANSETA, JACKALL, 21, BPM, B1-C70H, 2,13/10-42G, 2, SEG, ja.807213737, Lansete Rapitori, Lansete Rapitori Jackall, Jackall
Jig Jackall Tide Ring Head 1.5g 5buc/plic

Jig Jackall Tide Ring Head 1.5g 5buc/plic

f2.ja.807207569
Livrare 24-48 ore

28,06Lei

Cicada, Jackall, Jeublu, 5.2cm, 6.4g, Maruhata, Suji, Shrimp, ja.807191622, Spinnertails, Spinnertails Jackall, Jackall -20%

Cicada, Jackall, Jeublu, 5.2cm, 6.4g, Maruhata, Suji, Shrimp, ja.807191622, Spinnertails, Spinnertails Jackall, Jackall

ja.807191622
Livrare 24-48 ore

76,79Lei(-20%) 61,43Lei

Vobler, Jackall, D-Bill, Shad, 55SR, SP,, Pol, Chart, Back, Blue, Gill,, 5.5cm,, 5.5g, ja.807197341, Voblere Floating, Voblere Floating Jackall, Jackall -20%
Lingurita Oscilanta Jackall Tearo 2.2cm, 1.9g, Silver Yamame Trout

Lingurita Oscilanta Jackall Tearo 2.2cm, 1.9g, Silver Yamame Trout

f3.ja.212126265
Livrare 24-48 ore

31,75Lei

Cleste Jackall Pentru Inele Despicate

Cleste Jackall Pentru Inele Despicate

ja.807251265
Livrare 24-48 ore

163,99Lei

Vobler Jackall TN70 Trigon, Deadly Pearl Bait, 7cm, 31.5g

Vobler Jackall TN70 Trigon, Deadly Pearl Bait, 7cm, 31.5g

ja.807214598
Livrare 24-48 ore

122,27Lei

Vobler Jackall TN70 Trigon, Noike Gill, 7cm, 31.5g

Vobler Jackall TN70 Trigon, Noike Gill, 7cm, 31.5g

ja.807263985
Livrare 24-48 ore

128,73Lei

Lingurita, Oscilanta, Jackall, Tearo,, Crazy, Purple,, 2.2cm,, 1.6g, f3.ja.418091765, Lingurite Pastrav, Lingurite Pastrav Jackall, Jackall
Vobler, Jackall, Pepino, SR,, Sojuku, Banana,, 5.6cm,, 2.2g, ja.807256390, Voblere Floating, Voblere Floating Jackall, Voblere Jackall, Floating Jackall, Jackall
Vobler Jackall Tricoroll GT 88SR-F Sight Red&Gold 8.8cm 9g -20%

Vobler Jackall Tricoroll GT 88SR-F Sight Red&Gold 8.8cm 9g

ja.418099112
Livrare 24-48 ore

93,20Lei(-20%) 74,57Lei

Spinnerbait Jackall Deraspin Fire Dip 7g -20%

Spinnerbait Jackall Deraspin Fire Dip 7g

ja.807177190
Livrare 24-48 ore

71,57Lei(-20%) 57,26Lei

VOBLER JACKALL TN60 6.0CM/12.7G RT UROKO HL BLUEGILL

VOBLER JACKALL TN60 6.0CM/12.7G RT UROKO HL BLUEGILL

ja.807144062
Livrare 24-48 ore

99,67Lei

Vobler Jackall Block Ripper 48MR, Blue Back Chartreuse, 4.8cm, 8.5g

Vobler Jackall Block Ripper 48MR, Blue Back Chartreuse, 4.8cm, 8.5g

ja.807179279
Livrare 24-48 ore

92,81Lei

Vobler, Jackall, Flapani,, TK, Glow,, 2.8cm,, 1.9g, ja.807225136, Voblere Floating, Voblere Floating Jackall, Jackall
Lingurita, Oscilanta, Jackall, Tearo, 2.2cm,, 1.6g,, Daigo, Secret, Green, f3.ja.807169218, Lingurite Pastrav, Lingurite Pastrav Jackall, Jackall
Lingurita Oscilanta Jackall Tearo Wasabi, 1.9cm, 1.2g -20%

Lingurita Oscilanta Jackall Tearo Wasabi, 1.9cm, 1.2g

f3.ja.418087102
Livrare 24-48 ore

37,06Lei(-20%) 29,65Lei

Vobler Jackall TN50 Trigon, Kawashima Prism Wakasagi, 5.2cm, 11.2g

Vobler Jackall TN50 Trigon, Kawashima Prism Wakasagi, 5.2cm, 11.2g

ja.807143065
Livrare 24-48 ore

104,92Lei

Vobler, Jackall, TN60, Trigon,, Maruhata, Keimura, Gill,, 6cm,, 8.5g, ja.807143133, Voblere Sinking, Voblere Sinking Jackall, Voblere Jackall, Sinking Jackall, Jackall
Lingurita Oscilanta Jackall Tearo, Crystal Yamame, 2.2cm, 1.9g

Lingurita Oscilanta Jackall Tearo, Crystal Yamame, 2.2cm, 1.9g

f3.ja.807227550
Livrare 24-48 ore

34,55Lei

Afişare 1 - 20 din 537 (27 pagini)
Queries: 9, Total time: 92.107 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = '1038c0b19191dd9ce47862294b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.070)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jackall'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.142)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (41.289)
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 = '150'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (50.067)
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 = '150' 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:432
8 (0.073)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.094)
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