Campingaz


Capac din Otel Tip Dom Campingaz

Capac din Otel Tip Dom Campingaz

2000035409
Livrare 24-48 ore

296,79Lei

Aragaz CAMPINGAZ Kitchen 2

Aragaz CAMPINGAZ Kitchen 2

2000035521
Livrare imediată!

477,88Lei

Aragaz Campingaz Bleuet Micro Plus, 13x9cm

Aragaz Campingaz Bleuet Micro Plus, 13x9cm

2184543
Livrare 24-48 ore

110,72Lei

Aragaz & Gratar Campingaz CV 3 in 1

Aragaz & Gratar Campingaz CV 3 in 1

2000008369
Livrare 24-48 ore

621,15Lei

Rucsac termizolant Campingaz 14l

Rucsac termizolant Campingaz 14l

2000011728
Livrare 24-48 ore

118,85Lei

Aragaz & Gratar Campingaz 360 CV

Aragaz & Gratar Campingaz 360 CV

2000038776
Livrare 24-48 ore

978,06Lei

Spatula Premium Campingaz

Spatula Premium Campingaz

2000035410
Livrare 24-48 ore

92,41Lei

Perie Campingaz din sarma triunghiulara pentru gratar

Perie Campingaz din sarma triunghiulara pentru gratar

2000032369
Livrare 24-48 ore

51,74Lei

Aragaz Campingaz Party Grill 400

Aragaz Campingaz Party Grill 400

2000035499
Livrare 24-48 ore

774,69Lei

Rucsac termoizolant Campingaz The Office 16l

Rucsac termoizolant Campingaz The Office 16l

2000036877
Livrare imediată!

163,69Lei

Spatula Lunga Premium Campingaz

Spatula Lunga Premium Campingaz

2000035411
Livrare 24-48 ore

102,58Lei

Aragaz Grill Campingaz Bistro Grill, 43x28x11cm

Aragaz Grill Campingaz Bistro Grill, 43x28x11cm

2197182
Livrare 24-48 ore

556,07Lei

Lichid Toaletă Campingaz Instablue Standard 2,5L

Lichid Toaletă Campingaz Instablue Standard 2,5L

2000031966
Livrare 24-48 ore

54,79Lei

Gratar Cattara Pe Carbuni Piran Pliabil

Gratar Cattara Pe Carbuni Piran Pliabil

tt13003
Livrare 24-48 ore

179,85Lei

Aragaz Campingaz Twister Plus PZ

Aragaz Campingaz Twister Plus PZ

2184535
Livrare 24-48 ore

159,51Lei

Lichid Toaleta Instablue Extra 1L

Lichid Toaleta Instablue Extra 1L

2000031967
Livrare imediată!

50,72Lei

Set Pietre Cattara Pentru Curatarea Gratarului, TT13091, 4buc/pac

Set Pietre Cattara Pentru Curatarea Gratarului, TT13091, 4buc/pac

tt13091
Livrare 24-48 ore

62,92Lei

Accesoriu Campingaz pentru Ridicat Gratare si Capace

Accesoriu Campingaz pentru Ridicat Gratare si Capace

2000037057
Livrare 24-48 ore

61,92Lei

Cleste de Precizie din Otel pentru Gratar Campingaz

Cleste de Precizie din Otel pentru Gratar Campingaz

2000035418
Livrare imediată!

52,76Lei

Aragaz Campingaz Camp Bistro III

Aragaz Campingaz Camp Bistro III

2000038753
Livrare 24-48 ore

225,60Lei

Afişare 1 - 20 din 109 (6 pagini)
Queries: 7, Total time: 58.969 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'df73f9e6a833e083a6eaee2d99'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Campingaz'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.144)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '364' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.604)
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 = '364'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (29.776)
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 = '364' 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.108)
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