REMESCAR | Pharmatune

Αποστολή σε όλη την Ελλάδα 210 721 0830

REMESCAR

REMESCAR ( ΓΙΑ ΕΥΡΥΑΓΓΕΙΕΣ) 50ML

REMESCAR ( ΓΙΑ ΕΥΡΥΑΓΓΕΙΕΣ) 50ML

€28,88 - €29,99

Σε 129 καταστήματα

ΠΡΟΣΘΗΚΗ ΣΤΟ ΚΑΛΑΘΙ

Η Remescar για Ευρυαγγείες είναι ένα καινοτόμο ιατροτεχνολογικό προϊόν σχεδιασμένο για την πρόληψη και την αντιμετώπιση των ευρυαγγειών στο δέρμα μέσω του σχηματισμού ενός αδιαπέραστου φιλμ μακράς διαρκείας που καλύπτει πλήρως την πάσχουσα περιοχή -επιτρέποντας ταυτόχρονα στο δέρμα να αναπνέει- με αποτέλεσμα τη γρήγορη αποκατάστασή της. Αυτός ο λεπτός και διακριτικός φραγμός έχει ευεργετικές ιδιότητες. Το προϊόν αναστέλλει την καταστροφή των αγγείων και ενσωματώνεται άριστα στο λιπιδικό στρώμα τ

back to top

Queries: 58, Total time: 41.994 ms [By time] [By id] [By file]

1 (0.042)

SELECT *
FROM ph_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://pharmatune.gr/'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/index.php:43

2 (0.173)

SELECT *
FROM `ph_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/index.php:55

3 (0.054)

SELECT *
FROM `ph_language`
WHERE status = '1'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/index.php:139

4 (0.040)

SELECT *
FROM ph_currency

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/currency.php:13

5 (0.033)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ph_tax_rule tr1
LEFT JOIN ph_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ph_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ph_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ph_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/tax.php:26

6 (0.017)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ph_tax_rule tr1
LEFT JOIN ph_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ph_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ph_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ph_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/tax.php:54

7 (0.026)

SELECT *
FROM ph_weight_class wc
LEFT JOIN ph_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/weight.php:9

8 (0.024)

SELECT *
FROM ph_length_class mc
LEFT JOIN ph_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/length.php:9

9 (0.022)

SELECT *
FROM ph_extension
WHERE `type` = 'openbay'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/openbay.php:116

10 (0.022)

SELECT *
FROM ph_event

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/index.php:243

11 (0.373)

SELECT *
FROM ph_manufacturer m
LEFT JOIN ph_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '515' AND m2s.store_id = '0'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:4

12 (0.025)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

13 (0.014)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

14 (0.430)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM ph_product p
LEFT JOIN ph_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ph_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:519

15 (0.669)

SELECT p.product_id, (SELECT price
FROM ph_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 ph_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
FROM ph_product p
LEFT JOIN ph_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ph_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '515' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,16

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:191

16 (0.300)

SELECT DISTINCT *, pd.name AS name, p.image, p.sort_order,p.*
FROM ph_product p
LEFT JOIN ph_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '42170' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW()

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:905

17 (0.248)

SELECT price,product_id,pharm_id
FROM ph_product_special ps
WHERE ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end >= NOW())) AND ps.product_id = 42170

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msproduct.php:1903

18 (0.626)

SELECT price
FROM ph_pharm_product php
WHERE php.product_id = 42170 AND php.product_status = 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msproduct.php:1913

19 (0.258)

SELECT price,product_id,pharm_id
FROM ph_product_special ps
WHERE ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end >= NOW())) AND ps.product_id = 42170

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msproduct.php:1941

20 (0.047)

SELECT price
FROM ph_pharm_product php
WHERE php.product_id = 42170 AND php.product_status = 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msproduct.php:1950

21 (0.230)

SELECT *
FROM ph_product_special
WHERE product_id = '42170' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-system_library_customer.php:159

22 (0.235)

SELECT COUNT(*) as count
FROM `ph_pharm_product`
WHERE product_id = '42170'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msproduct.php:1973

23 (0.191)

SELECT pm.name as man
FROM ph_product p
LEFT JOIN ph_manufacturer pm ON (p.manufacturer_id = pm.manufacturer_id)
WHERE p.product_id = '42170' AND p.status = '1' AND p.date_available <= NOW() AND pm.manufacturer_id != 11

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:1043

24 (0.025)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

25 (36.623)

SELECT *
FROM ph_url_alias
WHERE `query` = 'product_id=42170'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

26 (0.079)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

27 (0.022)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

28 (0.019)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

29 (0.020)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

30 (0.019)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

31 (0.019)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

32 (0.020)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

33 (0.018)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

34 (0.019)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

35 (0.019)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

36 (0.023)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

37 (0.020)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

38 (0.021)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

39 (0.021)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

40 (0.065)

SELECT *
FROM ph_url_alias
WHERE `query` = 'manufacturer_id=515'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

41 (0.053)

SELECT *
FROM ph_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:4

42 (0.041)

SELECT *
FROM ph_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:14

43 (0.068)

SELECT *
FROM ph_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:4

44 (0.023)

SELECT *
FROM ph_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:14

45 (0.044)

SELECT *
FROM ph_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:4

46 (0.026)

SELECT *
FROM ph_layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:14

47 (0.045)

SELECT *
FROM ph_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:4

48 (0.020)

SELECT *
FROM ph_layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/design/layout.php:14

49 (0.214)

SELECT *
FROM ph_information i
LEFT JOIN ph_information_description id ON (i.information_id = id.information_id)
LEFT JOIN ph_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/catalog/information.php:10

50 (0.025)

SELECT *
FROM ph_url_alias
WHERE `query` = 'information_id=18'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

51 (0.100)

SELECT *
FROM ph_blog i
LEFT JOIN ph_blog_description id ON (i.blog_id = id.blog_id)
LEFT JOIN ph_blog_to_store i2s ON (i.blog_id = i2s.blog_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.date_added DESC LIMIT 0, 3

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/catalog/model/catalog/blog.php:15

52 (0.025)

SELECT *
FROM ph_url_alias
WHERE `query` = 'blog_id=192'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

53 (0.016)

SELECT *
FROM ph_url_alias
WHERE `query` = 'blog_id=191'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

54 (0.015)

SELECT *
FROM ph_url_alias
WHERE `query` = 'blog_id=190'

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:198

55 (0.024)

SELECT COUNT(*) as 'total'
FROM `ph_pharm`
WHERE pharm_id = 0

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msseller.php:98

56 (0.049)

SELECT COUNT(*) as total
FROM ph_pharm ms
WHERE 1 = 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msseller.php:692

57 (0.028)

SELECT COUNT(*) as 'total'
FROM `ph_pharm`
WHERE pharm_id = 0

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msseller.php:98

58 (0.028)

SELECT COUNT(*) as total
FROM ph_pharm ms
WHERE 1 = 1

/home/734152.cloudwaysapps.com/kttaxxgdvz/public_html/system/library/msseller.php:692