DUO


Spinnertail DUO Realis Spin 40, CDA4054 Black Gold, 4cm, 14g

Spinnertail DUO Realis Spin 40, CDA4054 Black Gold, 4cm, 14g

duo04252
Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 70MDF, ACC3008 Neo Pearl, 7cm, 5.4g

Vobler DUO Spreadhead Ryuki 70MDF, ACC3008 Neo Pearl, 7cm, 5.4g

duo93508
Livrare 48-72 ore

76,15Lei

Vobler DUO Tetra Works Kurakura SF, CUA0755 Stone Worm, 3cm, 2.5g

Vobler DUO Tetra Works Kurakura SF, CUA0755 Stone Worm, 3cm, 2.5g

duo92129
Livrare 48-72 ore

72,07Lei

Vobler DUO Spearhead Ryuki 70F, CRA3061 Komochi Wakasagi, 7cm, 5.3g

Vobler DUO Spearhead Ryuki 70F, CRA3061 Komochi Wakasagi, 7cm, 5.3g

duo05457
Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Spinbait 62 Alpha, CCC3108 Ghost Pearl, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, CCC3108 Ghost Pearl, 6.2cm, 10.9g

duo44104
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0087 Mazume Sardine, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PHA0087 Mazume Sardine, 8cm, 40g

duo35683
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0119 Pink Sardine, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PHA0119 Pink Sardine, 6.5cm, 20g

duo35386
Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Shad 57MR SP, DEA3006 Ghost Minnow, 5.7cm, 4.8g

Vobler DUO Realis Shad 57MR SP, DEA3006 Ghost Minnow, 5.7cm, 4.8g

duo26599
Livrare 48-72 ore

72,07Lei

Vobler DUO Realis Crank 55SR Kabuki, ACC3306 Blue Back Chart, 5.5cm, 10g

Vobler DUO Realis Crank 55SR Kabuki, ACC3306 Blue Back Chart, 5.5cm, 10g

duo19072
Livrare 48-72 ore

72,07Lei

Swimbait DUO Realis Clawtrap, F058 Poison Purple, 14cm, 26.1g, 1buc/pac

Swimbait DUO Realis Clawtrap, F058 Poison Purple, 14cm, 26.1g, 1buc/pac

duo71070
Livrare 48-72 ore

85,29Lei

Vobler DUO Bay Ruf Tide Vib 70, ASA0032 Red Shiner, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, ASA0032 Red Shiner, 7cm, 15.5g

duo79939
Livrare 48-72 ore

82,24Lei

Vobler DUO Bayruf Bulk 95F, CSH0776 UV Clear Flash, 9.5cm, 14g

Vobler DUO Bayruf Bulk 95F, CSH0776 UV Clear Flash, 9.5cm, 14g

duo98442
Livrare 48-72 ore

109,70Lei

Spinnertail DUO Realis Spin 40 4cm 14g CRA3050 Lively Ayu

Spinnertail DUO Realis Spin 40 4cm 14g CRA3050 Lively Ayu

duo04269
Livrare 48-72 ore

69,02Lei

Vobler DUO Bay Ruf Tide Vib 70, CEA0674 Clear Chart Mirage, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, CEA0674 Clear Chart Mirage, 7cm, 15.5g

duo79984
Livrare 48-72 ore

82,24Lei

Vobler DUO Spearhead Ryuki 70S SW, AQA0283 Tiranga OB, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, AQA0283 Tiranga OB, 7cm, 9g

duo62825
Livrare 48-72 ore

75,13Lei

Vobler DUO Tetra Works Totoshad, CCC0382 Clear Glow, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, CCC0382 Clear Glow, 4.8cm, 4.5g

duo54172
Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Pocopoco F, CTA0375 Tiger Shrimp, 4cm, 3g

Vobler DUO Tetra Works Pocopoco F, CTA0375 Tiger Shrimp, 4cm, 3g

duo07000
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki Vib 45, ASI4073 Pink Chart Yamame, 4.5cm, 5.3g

Vobler DUO Spearhead Ryuki Vib 45, ASI4073 Pink Chart Yamame, 4.5cm, 5.3g

duo72732
Livrare 48-72 ore

66,99Lei

Vobler DUO Spearhead Ryuki 80S, ACC4810 Ayu ND, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, ACC4810 Ayu ND, 8cm, 12g

duo62026
Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 71S, ASI4044 Full Chart Yamame, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ASI4044 Full Chart Yamame, 7.1cm, 10g

duo73746
Livrare 48-72 ore

90,37Lei

Afişare 1 - 20 din 1280 (64 pagini)
Queries: 7, Total time: 78.058 ms [By time] [By id] [By file]
1 (0.167)
SELECT data
FROM `oc_session`
WHERE session_id = '0b188596da21f2f2c212a19863'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '459' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (33.220)
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 = '3' AND p.manufacturer_id = '459'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (44.206)
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 = '3' AND p.manufacturer_id = '459' 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.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37