0

African Extracts Rooibos Nourishing Night Cream

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-25 20:44:48 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.
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.

Product Features

Hydratant et rassodante

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.572762966156 257 1.2466 0


No Amazon API Requests Made.


App Debug - Total Time 1.572762966156 seconds

Number Time From Start Name Description
1 0.29177093505859 Initialise Initialise FSB Function
2 0.30049300193787 App Controller Start Start of the App controller (called before the controller of every page)
3 0.33389282226562 Start of getCategoryListByGroup Function Before first category groups query
4 0.33591794967651 After initial query Before first category groups query
5 0.33591890335083 Get Category List for Group Before the call to getCategoryList function
6 0.33592081069946 Start of GetCategoryList function Start of the function
7 0.33592295646667 Before getting categories Query to get specific category list
8 0.33802390098572 After getting categories Query to get specific category list
9 0.33802390098572 Before getting category custom Before call to function getCategoryCustom
10 0.36873888969421 After getting category custom After call to function getCategoryCustom
11 0.36874294281006 Before getting category custom Before call to function getCategoryCustom
12 0.39760279655457 After getting category custom After call to function getCategoryCustom
13 0.39760589599609 Before getting category custom Before call to function getCategoryCustom
14 0.40707492828369 After getting category custom After call to function getCategoryCustom
15 0.40707778930664 Before getting category custom Before call to function getCategoryCustom
16 0.41528391838074 After getting category custom After call to function getCategoryCustom
17 0.41528701782227 Before getting category custom Before call to function getCategoryCustom
18 0.42055892944336 After getting category custom After call to function getCategoryCustom
19 0.42055988311768 Before getting category custom Before call to function getCategoryCustom
20 0.42506098747253 After getting category custom After call to function getCategoryCustom
21 0.42506194114685 End of GetCategoryList function End of the function
22 0.42506790161133 Get Category List for Group Before the call to getCategoryList function
23 0.42506885528564 Start of GetCategoryList function Start of the function
24 0.42506980895996 Before getting categories Query to get specific category list
25 0.42568898200989 End of getCategoryListByGroup Function Before return()
26 1.3147490024567 App Controller End End of the App controller (called before the controller of every page)
27 1.3153688907623 Product Start Start of the product info controller
28 1.3425328731537 Cache file not found Starting get product details
29 1.3876428604126 Related products Start getting related products if enabled
30 1.3876438140869 Related Products Start Before the related products are found
31 1.3876450061798 Related Products Keywords Before the related product keywords are found
32 1.3876488208771 Create Keyword List Function Start of function
33 1.3877229690552 Create Keyword List Function After looping provided content - 15 keywords found
34 1.3881068229675 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
35 1.3881118297577 Create Keyword List Function After reducing keyword list
36 1.3881289958954 Create Keyword List Function After selecting by scoring keywords
37 1.3881318569183 Create Keyword List Function After final loop of keywords
38 1.3881328105927 Related Products Keywords After the related product keywords are found
39 1.4294509887695 Related Products End After the related products are found
40 1.4658257961273 Product End End of the product info controller (Product Info)
41 1.4680600166321 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4697508811951 Before Get Options Before the call to getOptions in the tpl class
43 1.5383439064026 After Get Options After the call to getOptions in the tpl class
44 1.5384879112244 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5385129451752 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5482258796692 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5482289791107 Product Info: Before Template Display Before the template is displayed
48 1.572744846344 Product Info: After Template Display After the template is displayed
49 1.5727529525757 Finalizing debug Before the debug is output to the page.
50 1.5727620124817 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 1.2466 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0019 0.001884937286377
SELECT parameter, value FROM parameters
2 0.0101 0.010076999664307
SELECT * FROM `bad_bots`
3 0.0005 0.00052309036254883
SET time_zone = 'Europe/London'
4 0.0036 0.00360107421875
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0063 0.0062880516052246
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.135.224.139\";}'
6 0.0066 0.0066299438476562
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746173308'
7 0.0037 0.0036849975585938
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0012381076812744
UPDATE autorun SET lastrun = '2025-05-02 08:08:28' WHERE id = '16'
9 0.0008 0.00084781646728516
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0038 0.0037739276885986
SELECT id FROM pages WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream' LIMIT 1
11 0.0035 0.0034599304199219
SELECT id FROM products WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream' AND hidden = 0 LIMIT 1
12 0.0043 0.0042960643768311
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0280 0.028038024902344
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00075912475585938
SELECT * FROM pages WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream'
15 0.0020 0.002018928527832
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0021 0.0020899772644043
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0084 0.008404016494751
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
18 0.0020 0.0019688606262207
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0035 0.0035321712493896
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0020 0.0020430088043213
SELECT id FROM categories WHERE parent_id = '26'
21 0.0073 0.0073180198669434
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 
22 0.0028 0.0027589797973633
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 
23 0.0023 0.0023088455200195
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
24 0.0018 0.0018091201782227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00047612190246582
SELECT * FROM categorygroups WHERE id = '1'
26 0.0142 0.014157056808472
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
27 0.0018 0.0018429756164551
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0009 0.0008549690246582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0009 0.00089192390441895
SELECT id FROM categories WHERE parent_id = '27'
30 0.0081 0.008126974105835
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 
31 0.0007 0.00073099136352539
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 
32 0.0009 0.00090408325195312
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
33 0.0006 0.00062990188598633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0006 0.00062704086303711
SELECT * FROM categorygroups WHERE id = '1'
35 0.0022 0.0022029876708984
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
36 0.0006 0.00058817863464355
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.0004570484161377
SELECT id FROM categories WHERE parent_id = '28'
39 0.0027 0.0026500225067139
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 
40 0.0010 0.0010108947753906
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 
41 0.0009 0.00085592269897461
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
42 0.0006 0.00059294700622559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00061821937561035
SELECT * FROM categorygroups WHERE id = '1'
44 0.0020 0.0019791126251221
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
45 0.0013 0.0013179779052734
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0006 0.0006251335144043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0007 0.00065898895263672
SELECT id FROM categories WHERE parent_id = '29'
48 0.0011 0.001115083694458
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 
49 0.0006 0.00064897537231445
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 
50 0.0007 0.00069212913513184
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
51 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00050902366638184
SELECT * FROM categorygroups WHERE id = '1'
53 0.0009 0.00089192390441895
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
54 0.0006 0.00056004524230957
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.00088095664978027
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 
58 0.0005 0.00046992301940918
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 
59 0.0005 0.00053811073303223
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
60 0.0004 0.00043702125549316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00043487548828125
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00069117546081543
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
63 0.0005 0.00051593780517578
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00037789344787598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00038385391235352
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00075006484985352
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 
67 0.0004 0.00043416023254395
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 
68 0.0005 0.00046896934509277
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
69 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00038003921508789
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00061583518981934
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0036 0.0036301612854004
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0018 0.0017788410186768
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00056695938110352
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
75 0.0014 0.0014171600341797
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0013 0.0013301372528076
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0010 0.0010418891906738
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8742 0.87415504455566
SELECT * FROM ipgeocountries WHERE INET_ATON('3.135.224.139') >= INET_ATON(ip_start) AND INET_ATON('3.135.224.139') <= INET_ATON(ip_end)
79 0.0022 0.0022201538085938
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0014379024505615
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00062394142150879
SELECT * FROM products WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream'
82 0.0004 0.00037598609924316
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2564
83 0.0015 0.0015120506286621
SELECT * FROM manufacturers WHERE id = '453'
84 0.0009 0.00086879730224609
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '453'
85 0.0033 0.0032589435577393
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '453' LIMIT 1
86 0.0037 0.0037398338317871
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '453' ORDER BY RAND() LIMIT 1
87 0.0007 0.00073504447937012
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
88 0.0006 0.0005650520324707
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '453'
89 0.0006 0.00062108039855957
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '453'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0005 0.00053191184997559
SELECT * FROM manufacturerimages WHERE manufacturer_id = '453'
91 0.0006 0.00056004524230957
SELECT category_id FROM products_categories WHERE product_id = '2564'
92 0.0006 0.00064492225646973
SELECT * FROM categories WHERE id = '27'
93 0.0077 0.0076510906219482
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
94 0.0005 0.00049495697021484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0003 0.00034403800964355
SELECT id FROM categories WHERE parent_id = '27'
96 0.0057 0.0057158470153809
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 
97 0.0007 0.00065708160400391
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 
98 0.0007 0.00069212913513184
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
99 0.0006 0.00062704086303711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0006 0.00055480003356934
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
101 0.0017 0.0016939640045166
SELECT * FROM product_image_select WHERE product_id = '2564'
102 0.0012 0.0012068748474121
SELECT * FROM productcustomimages WHERE product_id = '2564'
103 0.0013 0.0012819766998291
SELECT * FROM productfeeds WHERE product_id = '2564' ORDER BY item_date DESC
104 0.0024 0.0024430751800537
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0022 0.0022299289703369
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2564' AND t.hidden = 0 AND display_product = 1
106 0.0013 0.0013318061828613
SELECT * FROM productamazoncontent WHERE product_id = '2564'
107 0.0010 0.0010199546813965
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
108 0.0013 0.0013408660888672
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
111 0.0005 0.00049495697021484
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
112 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0005 0.00054693222045898
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
114 0.0097 0.0096869468688965
SELECT *, MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AND 2564 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0006 0.00056886672973633
SELECT *, MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AND 2564 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0005 0.00047397613525391
SELECT *, MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('extracts rooibos nourishing' IN BOOLEAN MODE) AND 2564 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
118 0.0006 0.00057220458984375
SELECT * FROM product_image_select WHERE product_id = '869'
119 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '869'
120 0.0009 0.00086593627929688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
121 0.0005 0.00046491622924805
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.00040912628173828
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0004 0.00041413307189941
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
125 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '878'
126 0.0004 0.00038695335388184
SELECT * FROM productcustomimages WHERE product_id = '878'
127 0.0010 0.00096511840820312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
128 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0005 0.0004730224609375
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
132 0.0006 0.000640869140625
SELECT * FROM product_image_select WHERE product_id = '858'
133 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '858'
134 0.0010 0.00096487998962402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
135 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0006 0.00057005882263184
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
139 0.0006 0.00061702728271484
SELECT * FROM product_image_select WHERE product_id = '890'
140 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '890'
141 0.0010 0.0010170936584473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
142 0.0011 0.0010690689086914
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0007 0.00068283081054688
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0008 0.00077199935913086
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0008 0.00083279609680176
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
146 0.0013 0.0012948513031006
SELECT * FROM product_image_select WHERE product_id = '865'
147 0.0007 0.0006871223449707
SELECT * FROM productcustomimages WHERE product_id = '865'
148 0.0017 0.0016739368438721
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
149 0.0009 0.0008690357208252
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0007 0.00066494941711426
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0008 0.000762939453125
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0011 0.0010590553283691
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
153 0.0010 0.0010499954223633
SELECT * FROM product_image_select WHERE product_id = '862'
154 0.0006 0.00062012672424316
SELECT * FROM productcustomimages WHERE product_id = '862'
155 0.0017 0.001741886138916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
156 0.0008 0.00081396102905273
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0006 0.00057196617126465
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0006 0.00060606002807617
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0008 0.00079083442687988
SELECT id,asin FROM products WHERE parent_id = 2564
160 0.0026 0.0026321411132812
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2564' ORDER BY timestamp DESC
161 0.0007 0.00073409080505371
SELECT category_id FROM products_categories WHERE product_id = '2564'
162 0.0006 0.00058507919311523
SELECT * FROM categories WHERE id = '27'
163 0.0061 0.0061230659484863
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
164 0.0005 0.00054717063903809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0004 0.00040388107299805
SELECT id FROM categories WHERE parent_id = '27'
166 0.0049 0.0048980712890625
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 
167 0.0005 0.00053191184997559
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 
168 0.0006 0.00059604644775391
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
169 0.0006 0.00063300132751465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0011 0.0010709762573242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
171 0.0005 0.00049304962158203
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
174 0.0004 0.00039100646972656
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
175 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '2564'
176 0.0005 0.00045585632324219
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0009 0.00089120864868164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
178 0.0004 0.00037789344787598
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00038504600524902
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
182 0.0004 0.00043296813964844
SELECT category_id FROM products_categories WHERE product_id = '2564' AND prod_type = 'amz'
183 0.0005 0.00045180320739746
SELECT parent_id FROM categories WHERE id = '27'
184 0.0005 0.00047087669372559
SELECT * FROM categories WHERE id = '27'
185 0.0039 0.003870964050293
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
186 0.0006 0.00063395500183105
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0004 0.00035905838012695
SELECT id FROM categories WHERE parent_id = '27'
188 0.0037 0.003699779510498
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 
189 0.0005 0.00053906440734863
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 
190 0.0005 0.00053882598876953
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
191 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0017 0.0017011165618896
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0012 0.001244068145752
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0004 0.00037407875061035
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0128 0.012781858444214
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
196 0.0016 0.0015568733215332
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
197 0.0006 0.00063109397888184
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
198 0.0007 0.0006709098815918
SELECT * FROM products WHERE id = 1626
199 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = 4041
200 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 4312
201 0.0003 0.00032401084899902
SELECT * FROM products WHERE id = 777
202 0.0004 0.00036811828613281
SELECT * FROM products WHERE id = 3881
203 0.0004 0.00039815902709961
SELECT * FROM products WHERE id = 4213
204 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '1626'
205 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0006 0.00058102607727051
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0004 0.00038695335388184
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0009 0.00086307525634766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0005 0.00052285194396973
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00038981437683105
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = '4041'
213 0.0004 0.00044488906860352
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0006 0.00058889389038086
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0010 0.0010480880737305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0005 0.00049114227294922
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.00049805641174316
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0012 0.0012028217315674
SELECT * FROM products WHERE id = '4312'
221 0.0011 0.0010738372802734
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0013 0.0013229846954346
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0007 0.00074291229248047
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0028 0.0027649402618408
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0010 0.00095105171203613
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0007 0.00065279006958008
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0009 0.00087404251098633
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0010 0.0010039806365967
SELECT * FROM products WHERE id = '777'
229 0.0008 0.00077605247497559
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0013 0.0012900829315186
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0007 0.00070309638977051
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0024 0.0023860931396484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0008 0.00084710121154785
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0007 0.00067901611328125
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0008 0.00077199935913086
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0007 0.0007021427154541
SELECT * FROM products WHERE id = '3881'
237 0.0007 0.00069284439086914
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0009 0.00092697143554688
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0006 0.00055789947509766
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0023 0.0022711753845215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0007 0.00072216987609863
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0007 0.0006718635559082
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0007 0.00070405006408691
SELECT * FROM products WHERE id = '4213'
245 0.0008 0.00081920623779297
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0009 0.00093793869018555
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0005 0.00054812431335449
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0024 0.0024471282958984
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0005 0.00051212310791016
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0024 0.0024487972259521
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0008 0.00083494186401367
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0027 0.0027279853820801
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0018 0.0018341541290283
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0005 0.00047397613525391
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0009 0.00088191032409668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'