Flying Fisherman


Bluza Flying Fisherman Sailfish Frenzy White Long Sleeve Tee L

Bluza Flying Fisherman Sailfish Frenzy White Long Sleeve Tee L

tl1650wl
Livrare 24-48 ore

128,01Lei

Bluza Flying Fisherman Built for Water Performance Hoodie Tee Silver S

Bluza Flying Fisherman Built for Water Performance Hoodie Tee Silver S

tl1415s
Livrare 24-48 ore

234,76Lei

Tricou Flying Fisherman Marlin White Tee L

Tricou Flying Fisherman Marlin White Tee L

t1639wl
Livrare 24-48 ore

108,68Lei

Ochelari Flying Fisherman Slack Tide Matte Black Smoke Slack Tide Matte Black Smoke

Ochelari Flying Fisherman Slack Tide Matte Black Smoke Slack Tide Matte Black Smoke

7756bs
Livrare 24-48 ore

159,51Lei

Tricou Flying Fisherman Passport Performance Black Tee XXL

Tricou Flying Fisherman Passport Performance Black Tee XXL

t1400bxxl
Livrare 24-48 ore

135,12Lei

Tricou Flying Fisherman Sailfish Frenzy White Tee XL

Tricou Flying Fisherman Sailfish Frenzy White Tee XL

t1650wxl
Livrare 24-48 ore

118,85Lei

Tricou Flying Fisherman Tarpon Light Blue Tee XXL

Tricou Flying Fisherman Tarpon Light Blue Tee XXL

t1668xxl
Livrare 24-48 ore

118,85Lei

Ochelari Flying Fisherman Cali Black Amber Cali Black Amber

Ochelari Flying Fisherman Cali Black Amber Cali Black Amber

7305ba
Livrare 24-48 ore

407,62Lei

Ochelari Flying Fisherman Buchanan Crystal Gunmetal Copper Buchanan Crystal Gunmetal Copper

Ochelari Flying Fisherman Buchanan Crystal Gunmetal Copper Buchanan Crystal Gunmetal Copper

7719gc
Livrare 24-48 ore

133,08Lei

Bluza Flying Fisherman Midnight Angler Pirate White Long Sleeve Tee L

Bluza Flying Fisherman Midnight Angler Pirate White Long Sleeve Tee L

tl1662wl
Livrare 24-48 ore

128,01Lei

Bluza Flying Fisherman Built for Water Performance Hoodie Tee Silver XL

Bluza Flying Fisherman Built for Water Performance Hoodie Tee Silver XL

tl1415sxl
Livrare 24-48 ore

234,76Lei

Afişare 41 - 51 din 51 (3 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 42.057 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'aedee6b7d68dbf6c242e844698'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Flying-Fisherman'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '348' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (19.789)
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 = '348'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (21.798)
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 = '348' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.102)
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