Owner


Kick, Tail, Owner, RB2, 13, Ring, Kick, Tail, 82906, White, 8290618, Shad-uri, Shad-uri Owner, Owner

Kick, Tail, Owner, RB2, 13, Ring, Kick, Tail, 82906, White, 8290618, Shad-uri, Shad-uri Owner, Owner

8290618
Livrare 48-72 ore

15,29Lei

Carlig, Owner, 5123, No.2, Baitholder, Hook, Red, 5123093, Carlige Feeder, Carlige Feeder Owner, Owner
Carlige, Offset, Owner, 5139, Nr.7/0, Wide, Gap, Plus, 5139171, Carlige Rapitor, Carlige Rapitor Owner, Owner
JIG Owner Lestat No.2/0 4gr Jig-57 253987 White -21%

JIG Owner Lestat No.2/0 4gr Jig-57 253987 White

122539872004
Livrare imediată!

15,01Lei(-21%) 11,90Lei

Carlig Owner 50044 Negru Semirotund Nr 1/0 - 11buc/plic

Carlig Owner 50044 Negru Semirotund Nr 1/0 - 11buc/plic

5004405
Livrare imediată!

11,23Lei

Ancora Owner CF-66 No.2/0

Ancora Owner CF-66 No.2/0

12070256967-20
Livrare imediată!

75,98Lei

Carlig Owner 50097 Auriu Spin pe Tija Nr 2 - 6buc/plic

Carlig Owner 50097 Auriu Spin pe Tija Nr 2 - 6buc/plic

5009704
Livrare 48-72 ore

10,25Lei

Creatura Owner Yuki Bug 85mm 05 Watermelon Black

Creatura Owner Yuki Bug 85mm 05 Watermelon Black

1301375594-05
Livrare 48-72 ore

27,38Lei

Carlig Owner 50286 Rosu Tija Lunga Nr 7 - 15buc/plic

Carlig Owner 50286 Rosu Tija Lunga Nr 7 - 15buc/plic

5028605
Livrare imediată!

10,41Lei

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 24 Lime Chart

Vobler Owner Mira Shad 5267 MS-50SP 50mm 3.5gr 24 Lime Chart

804020075
Livrare 48-72 ore

40,83Lei

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 11 - 16buc/pac -28%

Carlig Owner 50482 Auriu Rotund Tija Scurta Nr 11 - 16buc/pac

5048205
Livrare imediată!

10,90Lei(-28%) 7,90Lei

Jig Lestat Owner 5149 No.1 1/8Oz Ultra Head Finesse Type 3.54g 5buc/plic

Jig Lestat Owner 5149 No.1 1/8Oz Ultra Head Finesse Type 3.54g 5buc/plic

1209025149021
Livrare 48-72 ore

32,70Lei

Carlig Owner Cp 51481 Negru Rotund Nr 2/0 - 12buc/plic

Carlig Owner Cp 51481 Negru Rotund Nr 2/0 - 12buc/plic

5148102
Livrare imediată!

12,88Lei

Ancore Owner Cultiva ST-36TN Nichel No.14 8buc

Ancore Owner Cultiva ST-36TN Nichel No.14 8buc

1399503
Livrare 48-72 ore

39,81Lei

Carlige Crap Owner Carp Down C-7 nr 2 - 8buc/plic

Carlige Crap Owner Carp Down C-7 nr 2 - 8buc/plic

5000019
Livrare 48-72 ore

12,88Lei

Jig, Owner, Lestat, 56978, No.3/0, 15gr, Round, Jig, Head, 4buc/plic, 56978315, Jiguri Turnate, Jiguri Turnate Owner, Owner
Carlige Owner 50001 Albastru Tija Lunga Nr 5 - 17buc/pC

Carlige Owner 50001 Albastru Tija Lunga Nr 5 - 17buc/pC

5000105
Livrare imediată!

10,90Lei

Manusi Game Owner 9918 Jigging Casting Black S

Manusi Game Owner 9918 Jigging Casting Black S

810029918-410
Livrare 48-72 ore

182,91Lei

Carlige, Owner, 5060903, Negru, Nr, 1/0, -, 9Buc/plic, 5060904, Carlige Stationar, Carlige Stationar Owner, Owner -27%

Carlige, Owner, 5060903, Negru, Nr, 1/0, -, 9Buc/plic, 5060904, Carlige Stationar, Carlige Stationar Owner, Owner

5060904
Livrare imediată!

8,50Lei(-27%) 6,22Lei

Carlige Owner Cut Gure 50330 Aurii nr 6 - 15buc/plic

Carlige Owner Cut Gure 50330 Aurii nr 6 - 15buc/plic

5033012
Livrare imediată!

12,88Lei

Afişare 361 - 380 din 1473 (74 pagini)
Queries: 7, Total time: 87.389 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '22a981b37bf43235dc6f5c3ddd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.103)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '15' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.291)
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 = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (52.628)
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 = '2' AND p.manufacturer_id = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.108)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38