THORNTON & ROSS | Pharmatune

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

THORNTON & ROSS

HEDRIN LOTION 100ML - THORNTON & ROSS

HEDRIN LOTION 100ML - THORNTON & ROSS

€10,00 - €16,51

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

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

Εξαλείφει τις ψείρες και τα αβγά τους σε ενήλικες και σε παιδιά άνω των 6 μηνών. Εφαρμόστε αρκετό διάλυμα ομοιόμορφα πάνω σε ΣΤΕΓΝΑ μαλλιά και σιγουρευτείτε ότι το τριχωτό της κεφαλής καλύπτεται πλήρως. Απλώστε το υγρό ομοιόμορφα στα μαλλιά από τις ρίζες μέχρι τις άκρες. Αφήστε τα μαλλιά να στεγνώσουν φυσικά. Μετά την εφαρμογή, αφήστε το διάλυμα στα μαλλιά για μία ώρα. Ξεπλύνετε τα μαλλιά με κανονικό σαμπουάν, ξεβγάλετε σχολαστικά με νερό και στεγνώστε. Είναι σημαντικό να χρ

HEDRIN PLUS LIQUID GEL 100 ML - THORNTON & ROSS

HEDRIN PLUS LIQUID GEL 100 ML - THORNTON & ROSS

€14,50

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

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

HEDRIN PLUS SPRAY GEL 100 ML - THORNTON & ROSS

HEDRIN PLUS SPRAY GEL 100 ML - THORNTON & ROSS

€17,00

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

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

HEDRIN PROTECT & GO 200 ML - THORNTON & ROSS

HEDRIN PROTECT & GO 200 ML - THORNTON & ROSS

€9,90

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

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

HEDRIN SPRAY 100 ML - THORNTON & ROSS

HEDRIN SPRAY 100 ML - THORNTON & ROSS

€16,58

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

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

Σε πιο πυκνή μορφή τζελ. Περιέχει Penetrol© για να διευκολύνεται η διείσδυση του τζελ στο αυγό της ψείρας. Με γρήγορη δράση που μειώνει τη διάρκεια της θεραπείας. Κλινικά αποδεδειγμένο ότι σκοτώνει τις ψείρες και τα αυγά. Η δεύτερη εφαρμογή γίνεται μόνο αν αυτό είναι απαραίτητο

HEDRIN THREAT & GO MOUSSE 100ML - THORNTON & ROSS

HEDRIN THREAT & GO MOUSSE 100ML - THORNTON & ROSS

€14,00

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

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

back to top

Queries: 109, Total time: 173.257 ms [By time] [By id] [By file]

1 (0.066)

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

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

2 (0.335)

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

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

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

4 (0.052)

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

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

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

10 (0.019)

SELECT *
FROM ph_event

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

11 (25.420)

SELECT *
FROM ph_url_alias
WHERE keyword = 'thornton-and-ross'

/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 = '242' AND m2s.store_id = '0'

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

13 (0.031)

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

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

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

15 (0.454)

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

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

16 (0.778)

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 = '242' 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.274)

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 = '34693' 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.220)

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 = '24211' 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.179)

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

20 (0.193)

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

21 (0.189)

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

22 (0.172)

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

23 (0.172)

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

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

24 (0.867)

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

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

25 (0.148)

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

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

26 (0.050)

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

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

27 (0.132)

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

28 (0.141)

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

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

29 (0.134)

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

30 (0.027)

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

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

31 (21.978)

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

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

32 (0.327)

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

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

33 (0.821)

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

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

34 (0.205)

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

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

35 (0.047)

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

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

36 (0.129)

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

37 (0.147)

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

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

38 (0.163)

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

39 (0.026)

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

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

40 (21.984)

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

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

41 (0.313)

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

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

42 (0.904)

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

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

43 (0.162)

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

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

44 (0.046)

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

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

45 (0.125)

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

46 (0.137)

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

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

47 (0.155)

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

48 (0.025)

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

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

49 (21.851)

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

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

50 (0.322)

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

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

51 (0.905)

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

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

52 (0.181)

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

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

53 (0.047)

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

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

54 (0.121)

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

55 (0.142)

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

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

56 (0.172)

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

57 (0.042)

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

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

58 (22.337)

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

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

59 (0.324)

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

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

60 (0.710)

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

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

61 (0.170)

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

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

62 (0.061)

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

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

63 (0.129)

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

64 (0.144)

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

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

65 (0.156)

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

66 (0.026)

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

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

67 (21.963)

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

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

68 (0.325)

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

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

69 (1.015)

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

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

70 (0.192)

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

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

71 (0.048)

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

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

72 (0.128)

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

73 (0.169)

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

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

74 (0.172)

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

75 (0.028)

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

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

76 (21.899)

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

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

77 (0.061)

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

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

78 (0.017)

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

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

79 (0.014)

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

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

80 (0.015)

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

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

81 (0.031)

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

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

82 (0.015)

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

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

83 (0.014)

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

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

84 (0.017)

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

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

85 (0.017)

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

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

86 (0.015)

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

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

87 (0.024)

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

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

88 (0.018)

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

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

89 (0.016)

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

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

90 (0.014)

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

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

91 (0.043)

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

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

92 (0.041)

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

93 (0.029)

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

94 (0.024)

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

95 (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

96 (0.023)

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

97 (0.020)

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

98 (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

99 (0.015)

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

100 (0.299)

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

101 (0.037)

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

102 (0.079)

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

103 (0.020)

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

104 (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

105 (0.039)

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

106 (0.026)

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

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

107 (0.043)

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

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

108 (0.027)

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

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

109 (0.032)

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

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