0

Rooibos Du Hammam

Price: €10,50
Product prices and availability are accurate as of 2022-06-26 00:55:03 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
En stock.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3828160762787 248 1.0320 0


No Amazon API Requests Made.


App Debug - Total Time 1.3828160762787 seconds

Number Time From Start Name Description
1 0.34109902381897 Initialise Initialise FSB Function
2 0.34292411804199 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38147115707397 Start of getCategoryListByGroup Function Before first category groups query
4 0.38183116912842 After initial query Before first category groups query
5 0.38183212280273 Get Category List for Group Before the call to getCategoryList function
6 0.38183403015137 Start of GetCategoryList function Start of the function
7 0.38183617591858 Before getting categories Query to get specific category list
8 0.38222312927246 After getting categories Query to get specific category list
9 0.38222408294678 Before getting category custom Before call to function getCategoryCustom
10 0.39364004135132 After getting category custom After call to function getCategoryCustom
11 0.39364099502563 Before getting category custom Before call to function getCategoryCustom
12 0.40179419517517 After getting category custom After call to function getCategoryCustom
13 0.40179514884949 Before getting category custom Before call to function getCategoryCustom
14 0.40699505805969 After getting category custom After call to function getCategoryCustom
15 0.40699601173401 Before getting category custom Before call to function getCategoryCustom
16 0.40997314453125 After getting category custom After call to function getCategoryCustom
17 0.40997409820557 Before getting category custom Before call to function getCategoryCustom
18 0.41281700134277 After getting category custom After call to function getCategoryCustom
19 0.41281819343567 Before getting category custom Before call to function getCategoryCustom
20 0.41578722000122 After getting category custom After call to function getCategoryCustom
21 0.41578817367554 End of GetCategoryList function End of the function
22 0.4157931804657 Get Category List for Group Before the call to getCategoryList function
23 0.41579413414001 Start of GetCategoryList function Start of the function
24 0.41579604148865 Before getting categories Query to get specific category list
25 0.41613006591797 End of getCategoryListByGroup Function Before return()
26 1.2390711307526 App Controller End End of the App controller (called before the controller of every page)
27 1.2394621372223 Product Start Start of the product info controller
28 1.2410550117493 Cache file not found Starting get product details
29 1.259024143219 Related products Start getting related products if enabled
30 1.2590250968933 Related Products Start Before the related products are found
31 1.2590250968933 Related Products Keywords Before the related product keywords are found
32 1.2590281963348 Create Keyword List Function Start of function
33 1.2591052055359 Create Keyword List Function After looping provided content - 6 keywords found
34 1.2592191696167 Create Keyword List Function After looping initial keyword list - 5 keywords remaining
35 1.2592220306396 Create Keyword List Function After reducing keyword list
36 1.2592260837555 Create Keyword List Function After selecting by scoring keywords
37 1.2592279911041 Create Keyword List Function After final loop of keywords
38 1.259229183197 Related Products Keywords After the related product keywords are found
39 1.2960710525513 Related Products End After the related products are found
40 1.3075561523438 Product End End of the product info controller (Product Info)
41 1.3083992004395 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3091921806335 Before Get Options Before the call to getOptions in the tpl class
43 1.3694770336151 After Get Options After the call to getOptions in the tpl class
44 1.3696281909943 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3696551322937 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.373300075531 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3733031749725 Product Info: Before Template Display Before the template is displayed
48 1.3827981948853 Product Info: After Template Display After the template is displayed
49 1.3828070163727 Finalizing debug Before the debug is output to the page.
50 1.3828160762787 End of App This is the end of the app logging, final timestamp


Query Debug - 248 Database Queries. Total time 1.0320 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.0014071464538574
SELECT parameter, value FROM parameters
2 0.0040 0.0040338039398193
SELECT * FROM `bad_bots`
3 0.0003 0.00027799606323242
SET time_zone = 'Europe/London'
4 0.0006 0.00064206123352051
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00064492225646973
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.235\";}'
6 0.0006 0.000579833984375
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750465634'
7 0.0007 0.00069999694824219
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00038695335388184
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00056815147399902
SELECT id FROM pages WHERE pagename = 'rooibos-du-hammam' LIMIT 1
10 0.0006 0.00063204765319824
SELECT id FROM products WHERE pagename = 'rooibos-du-hammam' AND hidden = 0 LIMIT 1
11 0.0023 0.0022759437561035
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0355 0.035515069961548
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0003 0.00032305717468262
SELECT * FROM pages WHERE pagename = 'rooibos-du-hammam'
14 0.0004 0.00035500526428223
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00037598609924316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0046 0.0045878887176514
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0004 0.00036215782165527
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00028204917907715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '26'
20 0.0046 0.0045530796051025
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0003 0.00034689903259277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0004 0.0003509521484375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.0003201961517334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00027704238891602
SELECT * FROM categorygroups WHERE id = '1'
25 0.0029 0.0028808116912842
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.00030016899108887
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00027108192443848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0002901554107666
SELECT id FROM categories WHERE parent_id = '27'
29 0.0030 0.0030481815338135
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0003 0.00032591819763184
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0004 0.00038409233093262
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00032305717468262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00029897689819336
SELECT * FROM categorygroups WHERE id = '1'
34 0.0013 0.0012509822845459
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00037097930908203
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.00028204917907715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00029087066650391
SELECT id FROM categories WHERE parent_id = '28'
38 0.0013 0.001338005065918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00038909912109375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0004 0.00036191940307617
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00030398368835449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.00058412551879883
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00039982795715332
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0003 0.0003049373626709
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.00043916702270508
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0003 0.0003199577331543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.0003349781036377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00027585029602051
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00036096572875977
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.00028491020202637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00026082992553711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.0004420280456543
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0003 0.00030112266540527
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0003 0.00031805038452148
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0003 0.00030183792114258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00026798248291016
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00038504600524902
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0003 0.00029206275939941
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00045895576477051
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00029993057250977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0004 0.00038814544677734
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00030016899108887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00028300285339355
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00033211708068848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0013 0.0013110637664795
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00041413307189941
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00034213066101074
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0003 0.00026893615722656
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00089097023010254
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00056695938110352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8171 0.81709694862366
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.235') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.235') <= INET_ATON(ip_end)
78 0.0010 0.00095510482788086
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.0003511905670166
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00048303604125977
SELECT * FROM products WHERE pagename = 'rooibos-du-hammam'
81 0.0006 0.00057816505432129
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4113
82 0.0006 0.00063610076904297
SELECT * FROM manufacturers WHERE id = '222'
83 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '222'
84 0.0003 0.0003359317779541
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '222' LIMIT 1
85 0.0007 0.00067496299743652
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '222' ORDER BY RAND() LIMIT 1
86 0.0003 0.00034189224243164
SELECT * FROM productimages WHERE product_id = '1225' ORDER BY sortorder ASC
87 0.0004 0.00040698051452637
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '222'
88 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '222'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0002 0.00024199485778809
SELECT * FROM manufacturerimages WHERE manufacturer_id = '222'
90 0.0005 0.00045108795166016
SELECT category_id FROM products_categories WHERE product_id = '4113'
91 0.0003 0.00031113624572754
SELECT * FROM productimages WHERE product_id = '4113' ORDER BY sortorder ASC
92 0.0004 0.0003960132598877
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4113' AND p.id = pi.product_id ORDER BY pi.sortorder
93 0.0007 0.00070595741271973
SELECT * FROM product_image_select WHERE product_id = '4113'
94 0.0003 0.00031709671020508
SELECT * FROM productcustomimages WHERE product_id = '4113'
95 0.0004 0.0004279613494873
SELECT * FROM productfeeds WHERE product_id = '4113' ORDER BY item_date DESC
96 0.0008 0.00083303451538086
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
97 0.0011 0.0010788440704346
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4113' AND t.hidden = 0 AND display_product = 1
98 0.0008 0.00075197219848633
SELECT * FROM productamazoncontent WHERE product_id = '4113'
99 0.0008 0.00079989433288574
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4113'
                GROUP BY o.product_id
100 0.0008 0.00075697898864746
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
101 0.0003 0.00027799606323242
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
102 0.0010 0.00095105171203613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname
103 0.0004 0.00038290023803711
SELECT * FROM productoffers WHERE product_id = '4113' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0003 0.00029706954956055
SELECT * FROM productoffers
                WHERE product_id = '4113' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 4113
                ORDER BY price ASC LIMIT 1
106 0.0003 0.0002589225769043
SELECT value FROM productattributes
                WHERE product_id = '4113'
                AND name = 'ListPriceAmount'
107 0.0004 0.00038814544677734
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4113'
                GROUP BY o.product_id
108 0.0008 0.00078105926513672
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0003 0.00032401084899902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
110 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '4113' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0006 0.00060009956359863
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4113'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
112 0.0004 0.00037789344787598
SELECT * FROM products WHERE parent_id = '4113'
113 0.0005 0.00050616264343262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4753' AND a.name = n.originalname
114 0.0005 0.00045514106750488
SELECT * FROM productoffers WHERE product_id = '4753' AND merchantid = 'A1X6FK5RDHNB96'
115 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '4753' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0005 0.00046706199645996
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
117 0.0062 0.0062370300292969
SELECT *, MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AND 4113 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
118 0.0004 0.0003819465637207
SELECT *, MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AND 4113 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0003 0.00034093856811523
SELECT *, MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos du hammam' IN BOOLEAN MODE) AND 4113 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0016 0.0016109943389893
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0009 0.00093698501586914
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0005 0.00051999092102051
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0014 0.0013980865478516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0006 0.00060105323791504
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0005 0.00045299530029297
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
128 0.0009 0.00094914436340332
SELECT * FROM product_image_select WHERE product_id = '865'
129 0.0005 0.00047183036804199
SELECT * FROM productcustomimages WHERE product_id = '865'
130 0.0011 0.0010848045349121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
131 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00063204765319824
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
135 0.0009 0.00088310241699219
SELECT * FROM product_image_select WHERE product_id = '869'
136 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '869'
137 0.0012 0.0011749267578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
138 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
142 0.0009 0.00086712837219238
SELECT * FROM product_image_select WHERE product_id = '878'
143 0.0005 0.0005190372467041
SELECT * FROM productcustomimages WHERE product_id = '878'
144 0.0013 0.0012960433959961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
145 0.0006 0.0006098747253418
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00041389465332031
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
149 0.0009 0.00089383125305176
SELECT * FROM product_image_select WHERE product_id = '890'
150 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '890'
151 0.0014 0.0013649463653564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
152 0.0005 0.00053596496582031
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00044584274291992
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0007 0.00065898895263672
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
156 0.0009 0.00089907646179199
SELECT * FROM product_image_select WHERE product_id = '858'
157 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '858'
158 0.0013 0.0013270378112793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
159 0.0005 0.00054788589477539
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00054693222045898
SELECT id,asin FROM products WHERE parent_id = 4113
163 0.0006 0.00055289268493652
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4753
164 0.0007 0.00067496299743652
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4753
165 0.0005 0.00053501129150391
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4113' ORDER BY timestamp DESC
166 0.0005 0.00049901008605957
SELECT category_id FROM products_categories WHERE product_id = '4113'
167 0.0011 0.0011458396911621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname
168 0.0005 0.0005340576171875
SELECT * FROM productoffers WHERE product_id = '4113' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '4113' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00041580200195312
SELECT * FROM productoffers
                WHERE product_id = 4113
                ORDER BY price ASC LIMIT 1
171 0.0004 0.0003969669342041
SELECT value FROM productattributes
                WHERE product_id = '4113'
                AND name = 'ListPriceAmount'
172 0.0006 0.00059294700622559
SELECT * FROM products WHERE id = '4113'
173 0.0005 0.00046896934509277
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4113'
                GROUP BY o.product_id
174 0.0008 0.00076794624328613
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0004 0.00044679641723633
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
176 0.0006 0.00060701370239258
SELECT value FROM productattributes WHERE product_id = '4113' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0010 0.00096583366394043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname
178 0.0004 0.0003659725189209
SELECT * FROM productoffers WHERE product_id = '4113' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0003 0.00033783912658691
SELECT * FROM productoffers
                WHERE product_id = '4113' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = 4113
                ORDER BY price ASC LIMIT 1
181 0.0003 0.00034594535827637
SELECT value FROM productattributes
                WHERE product_id = '4113'
                AND name = 'ListPriceAmount'
182 0.0004 0.00044703483581543
SELECT category_id FROM products_categories WHERE product_id = '4113' AND prod_type = 'amz'
183 0.0005 0.0005340576171875
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
184 0.0004 0.00043892860412598
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
185 0.0003 0.00031900405883789
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
186 0.0231 0.023121118545532
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
187 0.0006 0.00060200691223145
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
188 0.0006 0.00055718421936035
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
189 0.0003 0.00034618377685547
SELECT * FROM products WHERE id = 1626
190 0.0002 0.00024604797363281
SELECT * FROM products WHERE id = 4041
191 0.0002 0.00024795532226562
SELECT * FROM products WHERE id = 4312
192 0.0003 0.00026607513427734
SELECT * FROM products WHERE id = 777
193 0.0002 0.00023913383483887
SELECT * FROM products WHERE id = 3881
194 0.0003 0.00026106834411621
SELECT * FROM products WHERE id = 4213
195 0.0002 0.00024008750915527
SELECT * FROM products WHERE id = '1626'
196 0.0003 0.00030183792114258
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
197 0.0004 0.00043010711669922
SELECT * FROM product_image_select WHERE product_id = '1626'
198 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '1626'
199 0.0006 0.0005800724029541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
200 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00028705596923828
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0005 0.00051593780517578
SELECT * FROM products WHERE id = '4041'
204 0.0004 0.00044512748718262
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
205 0.0006 0.00064206123352051
SELECT * FROM product_image_select WHERE product_id = '4041'
206 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '4041'
207 0.0011 0.0010550022125244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
208 0.0004 0.00037980079650879
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0003 0.00029802322387695
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.00041007995605469
SELECT * FROM products WHERE id = '4312'
212 0.0003 0.0003201961517334
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
213 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '4312'
214 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4312'
215 0.0014 0.0013959407806396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
216 0.0009 0.00086188316345215
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0005 0.00051403045654297
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0006 0.00055503845214844
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0007 0.00070691108703613
SELECT * FROM products WHERE id = '777'
220 0.0006 0.00061297416687012
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
221 0.0009 0.00091099739074707
SELECT * FROM product_image_select WHERE product_id = '777'
222 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '777'
223 0.0016 0.0015878677368164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
224 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '3881'
228 0.0007 0.00071501731872559
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
229 0.0009 0.00093793869018555
SELECT * FROM product_image_select WHERE product_id = '3881'
230 0.0004 0.00043916702270508
SELECT * FROM productcustomimages WHERE product_id = '3881'
231 0.0015 0.0015490055084229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
232 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0005 0.00045585632324219
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0004 0.00044918060302734
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0008 0.00076389312744141
SELECT * FROM products WHERE id = '4213'
236 0.0006 0.00064897537231445
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
237 0.0007 0.00072479248046875
SELECT * FROM product_image_select WHERE product_id = '4213'
238 0.0004 0.00041580200195312
SELECT * FROM productcustomimages WHERE product_id = '4213'
239 0.0016 0.0015931129455566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
240 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0003 0.00028610229492188
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0008 0.00084400177001953
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
244 0.0007 0.00074911117553711
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
245 0.0019 0.001859188079834
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
246 0.0008 0.00080585479736328
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
247 0.0005 0.00054693222045898
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
248 0.0006 0.00058889389038086
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'