RESULTZ | Pharmatune

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

RESULTZ

RESULTZ SOLUTION 100ML

RESULTZ SOLUTION 100ML

€10,90 - €15,98

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

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

Το Resultz είναι ένα καινοτόμο αντιφθειρικό προϊόν με κλινικά αποδεδειγμένη αποτελεσματικότητα στην εξουδετέρωση των ψειρών και απομάκρυνση των κόνιδων χωρίς χημικά παρασιτοκτόνα! Ο μοναδικός μηχανισμός δράσης του εξασφαλίζει σίγουρο αποτέλεσμα σε 10 λεπτά μόνο! Το δραστικό συστατικό isopropyl myristate καταστρέφει το κέρινο περίβλημα των ψειρών με αποτέλεσμα αυτές να αφυδατώνονται και έτσι να εξουδετερώνονται. H πατενταρισμένη σύνθεσή του έχει αποδειχθεί δερματολογικά ασφαλής, αφού περιέχει σ

RESULTZ SPRAY 150 ml

RESULTZ SPRAY 150 ml

€19,65

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

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

Το Resultz είναι ένα καινοτόμο αντιφθειρικό προϊόν με κλινικά αποδεδειγμένη αποτελεσματικότητα στην εξουδετέρωση των ψειρών και απομάκρυνση των κόνιδων χωρίς χημικά παρασιτοκτόνα! Ο μοναδικός μηχανισμός δράσης του εξασφαλίζει σίγουρο αποτέλεσμα σε 10 λεπτά μόνο! Το δραστικό συστατικό isopropyl myristate καταστρέφει το κέρινο περίβλημα των ψειρών με αποτέλεσμα αυτές να αφυδατώνονται και έτσι να εξουδετερώνονται. H πατενταρισμένη σύνθεσή του έχει αποδειχθεί δερματολογικά ασφαλής, αφού περιέχει σ

back to top

Queries: 69, Total time: 50.490 ms [By time] [By id] [By file]

1 (0.068)

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

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

2 (0.277)

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.090)

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

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

4 (0.070)

SELECT *
FROM ph_currency

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

5 (0.043)

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.018)

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.027)

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.025)

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.029)

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

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

10 (0.016)

SELECT *
FROM ph_event

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

11 (20.234)

SELECT *
FROM ph_url_alias
WHERE keyword = 'resultz'

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

12 (0.360)

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

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

13 (0.038)

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

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

14 (0.017)

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

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

15 (0.479)

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 = '153'

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

16 (0.742)

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 = '153' 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

17 (0.298)

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 = '20028' 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

18 (0.242)

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 = '23287' 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

19 (0.204)

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 = 20028

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

20 (0.078)

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

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

21 (0.167)

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 = 20028

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

22 (0.048)

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

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

23 (0.177)

SELECT *
FROM ph_product_special
WHERE product_id = '20028' 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

24 (0.024)

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

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

25 (0.168)

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 = '20028' 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

26 (0.023)

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

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

27 (0.024)

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

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

28 (0.195)

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 = 23287

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

29 (0.872)

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

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

30 (0.212)

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 = 23287

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

31 (0.056)

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

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

32 (0.228)

SELECT *
FROM ph_product_special
WHERE product_id = '23287' 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

33 (0.213)

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

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

34 (0.204)

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 = '23287' 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

35 (0.027)

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

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

36 (23.256)

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

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

37 (0.055)

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

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

38 (0.017)

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

/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=153'

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

40 (0.016)

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

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

41 (0.016)

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

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

42 (0.019)

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

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

43 (0.014)

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

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

44 (0.014)

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

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

45 (0.017)

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

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

46 (0.016)

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

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

47 (0.017)

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

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

48 (0.014)

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

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

49 (0.017)

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

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

50 (0.015)

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

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

51 (0.036)

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

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

52 (0.033)

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

53 (0.024)

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

54 (0.028)

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

55 (0.015)

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

56 (0.026)

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

57 (0.017)

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

58 (0.027)

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

59 (0.016)

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

60 (0.304)

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

61 (0.029)

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

62 (0.111)

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

63 (0.049)

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

64 (0.027)

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

65 (0.024)

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

66 (0.066)

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

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

67 (0.064)

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

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

68 (0.037)

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

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

69 (0.041)

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

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