Colmic


Pluta, Colmic, Milazzo, Inline, 2g, gamil020, Plute Stationar, Plute Stationar Colmic, Plute Colmic, Stationar Colmic, Colmic
LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr Chartreuse Orange

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr Chartreuse Orange

arhklm14
Livrare 48-72 ore

22,00Lei

CARLIGE, COLMIC, NUCLEAR, DK800, GOLD, NR, 12, amq12, Carlige Stationar, Carlige Stationar Colmic, Carlige Feeder, Carlige Feeder Colmic, Colmic
Vobler, Colmic, Herakles, Popper, Area, Kiro, Matt, Black,, 2.7cm,, 1.8g, arhkki2739, Voblere Floating, Voblere Floating Colmic, Colmic
VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Alburno Ghost

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Alburno Ghost

arhkfq03
Livrare 48-72 ore

38,00Lei

CARLIGE COLMIC LEGATE N500 NR 4-0.16 70CM

CARLIGE COLMIC LEGATE N500 NR 4-0.16 70CM

al10416
Livrare imediată!

23,00Lei

Varga Colmic Alborella Record SR 4.0m

Varga Colmic Alborella Record SR 4.0m

care05e
Livrare 48-72 ore

415,00Lei

POPPER COLMIC HERAKLES HI-POP 11cm 26gr Ghost

POPPER COLMIC HERAKLES HI-POP 11cm 26gr Ghost

arhkfp11
Livrare 48-72 ore

63,00Lei

CARLIGE, COLMIC, LEGATE, NK800, NR, 10-0.14, 70CM, al41014, Carlige Legate Stationar, Carlige Legate Stationar Colmic, Colmic
Varga, Colmic, Fiume, S31, 5m, 25g, cafi99a, Vergi 5 Metri, Vergi 5 Metri Colmic, Colmic

Varga, Colmic, Fiume, S31, 5m, 25g, cafi99a, Vergi 5 Metri, Vergi 5 Metri Colmic, Colmic

cafi99a
Livrare 48-72 ore

1.110,00Lei

GRUB COLMIC HERAKLES MATO WORM 16.5cm Watermelon Plum Sapphire -30%

GRUB COLMIC HERAKLES MATO WORM 16.5cm Watermelon Plum Sapphire

arhkmat17
Livrare 48-72 ore

22,00Lei(-30%) 15,40Lei

PLUTA COLMIC GRANADA COLMIC GR 2.00

PLUTA COLMIC GRANADA COLMIC GR 2.00

gagrbae
Livrare imediată!

12,99Lei

Lanseta Colmic Carter 2.40m, 300g, 2seg

Lanseta Colmic Carter 2.40m, 300g, 2seg

cacar01a
Livrare 48-72 ore

579,99Lei

Shad, Colmic, Herakles, Ghost, Shad, 5cm, Ghost, Luminous, Fluorescent, arhkba09, Shad-uri, Shad-uri Colmic, Colmic
PLUTA COLMIC SENNA INLINE GR 4x14

PLUTA COLMIC SENNA INLINE GR 4x14

gasengb
Livrare 48-72 ore

10,50Lei

SHAD, COLMIC, HERAKLES, BENJO, SHAD, XX, 14.5cm, Thunder, arhkbxx07, Shad-uri, Shad-uri Colmic, Colmic

SHAD, COLMIC, HERAKLES, BENJO, SHAD, XX, 14.5cm, Thunder, arhkbxx07, Shad-uri, Shad-uri Colmic, Colmic

arhkbxx07
Livrare 48-72 ore

9,00Lei

WAGLER COLMIC AERO BLINDO CANAL 14 gr

WAGLER COLMIC AERO BLINDO CANAL 14 gr

gcablce
Livrare 48-72 ore

48,00Lei

Lanseta Colmic Sanset Tele Boat 2.10m 50 150g

Lanseta Colmic Sanset Tele Boat 2.10m 50 150g

casa80a
Livrare 48-72 ore

170,00Lei

CUPA COLMIC MARE MESH

CUPA COLMIC MARE MESH

fncq05d
Livrare imediată!

17,50Lei

Fir, Fluorocarbon, Colmic, Seaguar, Secol, PowerF, 0.185mm, 50m, nysc185, Fire Varga Bolo, Fire Varga Bolo Colmic, Colmic
Afişare 121 - 140 din 2614 (131 pagini)
Queries: 10, Total time: 172.319 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '760c13951cd3649d4b9ae28318'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.117)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '115' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (80.433)
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 = '115'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (91.044)
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 = '115' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=53277'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
9 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.103)
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