Polaroid


Ochelarii de Soare POLAROID PLD 7046/S 08A/M9, Rectangular, 57mm, Black-Grey -11%

Ochelarii de Soare POLAROID PLD 7046/S 08A/M9, Rectangular, 57mm, Black-Grey

4988669
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2059/S 003/M9, 60mm, Black -20%

Ochelari de Soare POLAROID PLD 2059/S 003/M9, 60mm, Black

4942141
Livrare imediată!

301,00Lei(-20%) 241,47Lei

Ochelarii de Soare POLAROID PLD 1015/S DL5 LB, 53mm, Matte Black -11%

Ochelarii de Soare POLAROID PLD 1015/S DL5 LB, 53mm, Matte Black

4942114
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2123/S D51/5X, 57mm, Negru-Albastru -20%

Ochelari de Soare POLAROID PLD 2123/S D51/5X, 57mm, Negru-Albastru

4978829
Livrare imediată!

217,00Lei(-20%) 174,37Lei

Ochelari de Soare POLAROID PLD 2149/S 8LZ 57 M9, Black Orange -20%

Ochelari de Soare POLAROID PLD 2149/S 8LZ 57 M9, Black Orange

5013141
Livrare imediată!

208,60Lei(-20%) 167,65Lei

Ochelari de Soare POLAROID 4128/S/X KJ1/SP, 59mm, Black -11%

Ochelari de Soare POLAROID 4128/S/X KJ1/SP, 59mm, Black

4988675
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID Unisex PLD 2161/S 900 56 16, Crystal ECO -20%

Ochelari de Soare POLAROID Unisex PLD 2161/S 900 56 16, Crystal ECO

5012210
Livrare imediată!

217,00Lei(-20%) 174,37Lei

Ochelari de Soare POLAROID PLD 6187/S KJ1/M9, 60mm, Gri -11%

Ochelari de Soare POLAROID PLD 6187/S KJ1/M9, 60mm, Gri

4988691
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID 07886 BLX/AI, 66mm, Negru-Mov -20%

Ochelari de Soare POLAROID 07886 BLX/AI, 66mm, Negru-Mov

4978838
Livrare imediată!

222,60Lei(-20%) 178,84Lei

Ochelarii de Soare POLAROID PLD 8411 9CA RC Rubber, 63mm, Black Sport -11%

Ochelarii de Soare POLAROID PLD 8411 9CA RC Rubber, 63mm, Black Sport

4942106
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2101/S 003/UC, 63mm, UC Black -20%

Ochelari de Soare POLAROID PLD 2101/S 003/UC, 63mm, UC Black

4962206
Livrare imediată!

250,60Lei(-20%) 201,21Lei

Ochelarii de Soare POLAROID PLD 7044 0VK/C3, Rectangular, 60mm, Black -11%

Ochelarii de Soare POLAROID PLD 7044 0VK/C3, Rectangular, 60mm, Black

4984603
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2135/S 08A/M9, 65mm, Negru-Gri -11%

Ochelari de Soare POLAROID PLD 2135/S 08A/M9, 65mm, Negru-Gri

4988660
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD2164/S 003 58 15, Matte Blue Eco -20%

Ochelari de Soare POLAROID PLD2164/S 003 58 15, Matte Blue Eco

5011972
Livrare imediată!

250,60Lei(-20%) 201,21Lei

Ochelari de Soare POLAROID PLD 4137/S PJP/C3, 58mm, Albastru -11%

Ochelari de Soare POLAROID PLD 4137/S PJP/C3, 58mm, Albastru

4988614
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID Unisex PLD 2161/S O6W/M9, Matte Black Grey ECO -20%

Ochelari de Soare POLAROID Unisex PLD 2161/S O6W/M9, Matte Black Grey ECO

5008552
Livrare imediată!

217,00Lei(-20%) 174,37Lei

Ochelarii de Soare POLAROID PLD 7043/S 0VK/C3, 57mm, Matt Black Blue -11%

Ochelarii de Soare POLAROID PLD 7043/S 0VK/C3, 57mm, Matt Black Blue

4988143
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2058/S 003/M9, 55mm, Black-Grey -11%

Ochelari de Soare POLAROID PLD 2058/S 003/M9, 55mm, Black-Grey

4942140
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelarii de Soare POLAROID PLD 07886 3OL 5Z, 66mm, Black Green -11%

Ochelarii de Soare POLAROID PLD 07886 3OL 5Z, 66mm, Black Green

4978837
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Ochelari de Soare POLAROID PLD 2123/S 08A/M9, 57mm, Negru-Gri -11%

Ochelari de Soare POLAROID PLD 2123/S 08A/M9, 57mm, Negru-Gri

4978828
Livrare imediată!

195,40Lei(-11%) 173,76Lei

Afişare 1 - 20 din 75 (4 pagini)
Queries: 7, Total time: 2.762 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '24a6cfaa2fd5f54cc405acd994'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'polaroid.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '767' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.544)
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 = '767'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (1.600)
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 = '767' 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.121)
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