African Extracts Rooibos Nourishing Night Cream

African Extracts Rooibos Nourishing Night Cream
African Extracts Rooibos Nourishing Night Cream African Extracts Rooibos Nourishing Night Cream African Extracts Rooibos Nourishing Night Cream African Extracts Rooibos Nourishing Night Cream African Extracts Rooibos Nourishing Night Cream (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2022-05-23 05:30:00 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.

Caractéristiques du Produit

Hydratant et rassodante
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.84753203392029 235 0.1619 0


No Amazon API Requests Made.

Total time 0.84753203392029 seconds

Number Time From Start Name Description
1 0.64954996109009 Initialise Initialise FSB Function
2 0.65248012542725 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65550804138184 Start of getCategoryListByGroup Function Before first category groups query
4 0.65593814849854 After initial query Before first category groups query
5 0.65594005584717 Get Category List for Group Before the call to getCategoryList function
6 0.65594410896301 Start of GetCategoryList function Start of the function
7 0.65594696998596 Before getting categories Query to get specific category list
8 0.65631198883057 After getting categories Query to get specific category list
9 0.65631413459778 Before getting category custom Before call to function getCategoryCustom
10 0.68020009994507 After getting category custom After call to function getCategoryCustom
11 0.68020296096802 Before getting category custom Before call to function getCategoryCustom
12 0.69083905220032 After getting category custom After call to function getCategoryCustom
13 0.69084095954895 Before getting category custom Before call to function getCategoryCustom
14 0.69671201705933 After getting category custom After call to function getCategoryCustom
15 0.69671511650085 Before getting category custom Before call to function getCategoryCustom
16 0.70036196708679 After getting category custom After call to function getCategoryCustom
17 0.70036506652832 Before getting category custom Before call to function getCategoryCustom
18 0.70470499992371 After getting category custom After call to function getCategoryCustom
19 0.70470809936523 Before getting category custom Before call to function getCategoryCustom
20 0.70857501029968 After getting category custom After call to function getCategoryCustom
21 0.70857715606689 End of GetCategoryList function End of the function
22 0.70858407020569 End of getCategoryListByGroup Function Before return()
23 0.71451115608215 App Controller End End of the App controller (called before the controller of every page)
24 0.71529316902161 Product Start Start of the product info controller
25 0.71747303009033 Cache file not found Starting get product details
26 0.74298214912415 Related products Start getting related products if enabled
27 0.74298405647278 Related Products Start Before the related products are found
28 0.74298501014709 Related Products Keywords Before the related product keywords are found
29 0.74299001693726 Create Keyword List Function Start of function
30 0.74301695823669 Create Keyword List Function After looping provided content - 15 keywords found
31 0.74395298957825 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
32 0.74396204948425 Create Keyword List Function After reducing keyword list
33 0.74400115013123 Create Keyword List Function After selecting by scoring keywords
34 0.74400615692139 Create Keyword List Function After final loop of keywords
35 0.74400901794434 Related Products Keywords After the related product keywords are found
36 0.76441097259521 Related Products End After the related products are found
37 0.77479600906372 Product End End of the product info controller (Product Info)
38 0.77590799331665 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.77674913406372 Before Get Options Before the call to getOptions in the tpl class
40 0.81436610221863 After Get Options After the call to getOptions in the tpl class
41 0.81446099281311 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.81449604034424 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.82726502418518 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.82727098464966 Product Info: Before Template Display Before the template is displayed
45 0.84750413894653 Product Info: After Template Display After the template is displayed
46 0.8475170135498 Finalizing debug Before the debug is output to the page.
47 0.84753012657166 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1619 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00072097778320312
SELECT parameter, value FROM parameters
2 0.0011 0.0011098384857178
SELECT * FROM `bad_bots`
3 0.0005 0.00050687789916992
SET time_zone = 'Europe/London'
4 0.0006 0.00058293342590332
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0027 0.0026929378509521
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0017 0.0016541481018066
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653307113'
7 0.0011 0.0011379718780518
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047993659973145
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00074911117553711
SELECT id FROM pages WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream' LIMIT 1
10 0.0010 0.00096607208251953
SELECT id FROM products WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream' AND hidden = 0 LIMIT 1
11 0.0011 0.0011451244354248
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00082707405090332
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00060820579528809
SELECT * FROM pages WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream'
14 0.0004 0.00041818618774414
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00034499168395996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0117 0.011717081069946
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.0003 0.00030994415283203
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.0005 0.00050115585327148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '26'
20 0.0095 0.0094699859619141
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.0004 0.00035595893859863
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.0003 0.00028800964355469
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.00034213066101074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040102005004883
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0043189525604248
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.00028800964355469
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.0002 0.00024795532226562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.0043759346008301
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.00025200843811035
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.0003 0.00030899047851562
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.00028491020202637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.0002281665802002
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016300678253174
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.00042486190795898
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.00027012825012207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00034189224243164
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.001662015914917
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.00037097930908203
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.0003 0.00033807754516602
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.00033998489379883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00036406517028809
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00068807601928711
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.0002 0.00023889541625977
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.00031304359436035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00063800811767578
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.0004 0.00036406517028809
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.0004 0.00040793418884277
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.0002 0.00024700164794922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00041079521179199
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066494941711426
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.0002 0.00023508071899414
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.0002 0.00024604797363281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0013 0.0012731552124023
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00073790550231934
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.00028109550476074
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.0002 0.00023984909057617
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.00028514862060547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00026297569274902
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00081396102905273
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.00031590461730957
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.00028491020202637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065803527832031
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.00030994415283203
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.00039911270141602
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.00031685829162598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00037193298339844
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00037384033203125
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00036811828613281
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00026106834411621
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
73 0.0004 0.00036096572875977
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00060105323791504
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.00043892860412598
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00032997131347656
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0004 0.00038409233093262
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00030088424682617
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00071096420288086
SELECT * FROM products WHERE pagename = 'african-extracts-rooibos-nourishing-night-cream'
80 0.0005 0.00053095817565918
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2564
81 0.0007 0.00069689750671387
SELECT * FROM manufacturers WHERE id = '453'
82 0.0006 0.00057482719421387
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '453'
83 0.0004 0.00041913986206055
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '453' LIMIT 1
84 0.0008 0.00082087516784668
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
85 0.0003 0.00028109550476074
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
86 0.0002 0.00021910667419434
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '453'
87 0.0006 0.00059390068054199
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 
88 0.0003 0.0003361701965332
SELECT * FROM manufacturerimages WHERE manufacturer_id = '453'
89 0.0004 0.00041389465332031
SELECT category_id FROM products_categories WHERE product_id = '2564'
90 0.0003 0.00029993057250977
SELECT * FROM categories WHERE id = '27'
91 0.0060 0.0060210227966309
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
92 0.0004 0.00039196014404297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00041294097900391
SELECT id FROM categories WHERE parent_id = '27'
94 0.0057 0.0056729316711426
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 
95 0.0004 0.00037693977355957
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 
96 0.0003 0.00029397010803223
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
97 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0003 0.00027608871459961
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
99 0.0003 0.00027990341186523
SELECT * FROM product_image_select WHERE product_id = '2564'
100 0.0003 0.00025582313537598
SELECT * FROM productcustomimages WHERE product_id = '2564'
101 0.0005 0.00053095817565918
SELECT * FROM productfeeds WHERE product_id = '2564' ORDER BY item_date DESC
102 0.0005 0.00051593780517578
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
103 0.0008 0.000762939453125
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
104 0.0005 0.00053811073303223
SELECT * FROM productamazoncontent WHERE product_id = '2564'
105 0.0008 0.00081777572631836
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
106 0.0004 0.00043010711669922
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00043678283691406
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00043296813964844
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
110 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00032186508178711
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
112 0.0083 0.0083119869232178
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 3
113 0.0007 0.0006711483001709
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 3
114 0.0007 0.00068116188049316
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 3
115 0.0003 0.00032305717468262
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0003 0.00033307075500488
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0003 0.00029206275939941
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0009 0.00088691711425781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0005 0.00052404403686523
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00031709671020508
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
123 0.0003 0.00034999847412109
SELECT * FROM product_image_select WHERE product_id = '858'
124 0.0002 0.00023698806762695
SELECT * FROM productcustomimages WHERE product_id = '858'
125 0.0009 0.00092792510986328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
126 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00052499771118164
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00049519538879395
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
130 0.0003 0.00034093856811523
SELECT * FROM product_image_select WHERE product_id = '878'
131 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '878'
132 0.0010 0.0009918212890625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
133 0.0004 0.00043106079101562
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.00053882598876953
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00049114227294922
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0005 0.00045299530029297
SELECT id,asin FROM products WHERE parent_id = 2564
137 0.0002 0.00024509429931641
SELECT category_id FROM products_categories WHERE product_id = '2564'
138 0.0003 0.00026893615722656
SELECT * FROM categories WHERE id = '27'
139 0.0003 0.00034093856811523
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
140 0.0003 0.00026488304138184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0003 0.00030779838562012
SELECT id FROM categories WHERE parent_id = '27'
142 0.0003 0.00027203559875488
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 
143 0.0003 0.0002598762512207
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 
144 0.0003 0.00025200843811035
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
145 0.0004 0.00039982795715332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0004 0.00038814544677734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
147 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
150 0.0002 0.0001978874206543
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
151 0.0005 0.00045490264892578
SELECT * FROM products WHERE id = '2564'
152 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00024509429931641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
154 0.0003 0.00026488304138184
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
158 0.0003 0.00031805038452148
SELECT category_id FROM products_categories WHERE product_id = '2564' AND prod_type = 'amz'
159 0.0003 0.00030684471130371
SELECT parent_id FROM categories WHERE id = '27'
160 0.0005 0.00047707557678223
SELECT * FROM categories WHERE id = '27'
161 0.0003 0.00033998489379883
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
162 0.0002 0.00023603439331055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '27'
164 0.0004 0.00038719177246094
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 
165 0.0004 0.00040912628173828
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 
166 0.0003 0.00034999847412109
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
167 0.0004 0.00038886070251465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0005 0.00046706199645996
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0004 0.00039291381835938
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0004 0.00037693977355957
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00031495094299316
SELECT * FROM pages WHERE id = 38
172 0.0050 0.004990816116333
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
173 0.0005 0.00054717063903809
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653307113;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
174 0.0005 0.00046110153198242
SELECT * FROM products WHERE id = 788
175 0.0006 0.00064182281494141
SELECT * FROM products WHERE id = 787
176 0.0007 0.00065088272094727
SELECT * FROM products WHERE id = 1287
177 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = 780
178 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = 777
179 0.0005 0.0004580020904541
SELECT * FROM products WHERE id = 776
180 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = '788'
181 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
182 0.0003 0.00032997131347656
SELECT * FROM product_image_select WHERE product_id = '788'
183 0.0003 0.00025582313537598
SELECT * FROM productcustomimages WHERE product_id = '788'
184 0.0008 0.00081396102905273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
185 0.0003 0.00025701522827148
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0006 0.00059604644775391
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00051212310791016
SELECT * FROM products WHERE id = '787'
189 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
190 0.0003 0.00027799606323242
SELECT * FROM product_image_select WHERE product_id = '787'
191 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '787'
192 0.0016 0.0015678405761719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
193 0.0004 0.00038504600524902
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = '1287'
197 0.0004 0.00038886070251465
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
198 0.0004 0.00037503242492676
SELECT * FROM product_image_select WHERE product_id = '1287'
199 0.0004 0.00038790702819824
SELECT * FROM productcustomimages WHERE product_id = '1287'
200 0.0012 0.0011560916900635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
201 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0005 0.00053882598876953
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00064516067504883
SELECT * FROM products WHERE id = '780'
205 0.0004 0.0003511905670166
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
206 0.0004 0.00035691261291504
SELECT * FROM product_image_select WHERE product_id = '780'
207 0.0002 0.00022983551025391
SELECT * FROM productcustomimages WHERE product_id = '780'
208 0.0011 0.0010550022125244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
209 0.0003 0.00033879280090332
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00054502487182617
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00055980682373047
SELECT * FROM products WHERE id = '777'
213 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0004 0.00037407875061035
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0002 0.00022792816162109
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0010 0.001046895980835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0004 0.00037813186645508
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00038313865661621
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0006 0.00064992904663086
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00052809715270996
SELECT * FROM products WHERE id = '776'
221 0.0004 0.00042080879211426
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0004 0.0003509521484375
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0002 0.00024199485778809
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0010 0.00097489356994629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0004 0.00036120414733887
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00028014183044434
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00031781196594238
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00042915344238281
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0006 0.00060009956359863
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00043296813964844
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00036811828613281
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0006 0.00056290626525879
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.00051093101501465
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.00033092498779297
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'