Rooibos AFRICAN SWEETY 100g

Rooibos AFRICAN SWEETY 100g
Rooibos AFRICAN SWEETY 100g (cliquez sur les images pour élargir)
€5,90
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 22:01:35 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.

Description du Fabricant

Rooibos parfumé à la fraise auréolé de chantilly.
Temps d'infusion : 5 mn
Température de l'eau : 95°C
Moment de la journée : Le matin, L'après-midi, Le soir.

Caractéristiques du Produit

Rooibos gourmand à la fraise chantilly
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
1.3917100429535 234 0.1322 0


No Amazon API Requests Made.

Total time 1.3917100429535 seconds

Number Time From Start Name Description
1 0.91131520271301 Initialise Initialise FSB Function
2 0.91375708580017 App Controller Start Start of the App controller (called before the controller of every page)
3 0.91660809516907 Start of getCategoryListByGroup Function Before first category groups query
4 0.91687417030334 After initial query Before first category groups query
5 0.91687607765198 Get Category List for Group Before the call to getCategoryList function
6 0.91687917709351 Start of GetCategoryList function Start of the function
7 0.91688299179077 Before getting categories Query to get specific category list
8 0.9172191619873 After getting categories Query to get specific category list
9 0.91722106933594 Before getting category custom Before call to function getCategoryCustom
10 0.91978907585144 After getting category custom After call to function getCategoryCustom
11 0.91979217529297 Before getting category custom Before call to function getCategoryCustom
12 0.93378400802612 After getting category custom After call to function getCategoryCustom
13 0.93378710746765 Before getting category custom Before call to function getCategoryCustom
14 0.93737697601318 After getting category custom After call to function getCategoryCustom
15 0.9373791217804 Before getting category custom Before call to function getCategoryCustom
16 0.94204211235046 After getting category custom After call to function getCategoryCustom
17 0.94204497337341 Before getting category custom Before call to function getCategoryCustom
18 0.94699907302856 After getting category custom After call to function getCategoryCustom
19 0.9470009803772 Before getting category custom Before call to function getCategoryCustom
20 0.95137000083923 After getting category custom After call to function getCategoryCustom
21 0.95137310028076 End of GetCategoryList function End of the function
22 0.95137715339661 End of getCategoryListByGroup Function Before return()
23 0.95798015594482 App Controller End End of the App controller (called before the controller of every page)
24 0.95858502388 Product Start Start of the product info controller
25 0.98483800888062 Cache file not found Starting get product details
26 1.0176150798798 Related products Start getting related products if enabled
27 1.0176160335541 Related Products Start Before the related products are found
28 1.0176169872284 Related Products Keywords Before the related product keywords are found
29 1.0176210403442 Create Keyword List Function Start of function
30 1.0176830291748 Create Keyword List Function After looping provided content - 9 keywords found
31 1.0181159973145 Create Keyword List Function After looping initial keyword list - 9 keywords remaining
32 1.0181331634521 Create Keyword List Function After reducing keyword list
33 1.0181450843811 Create Keyword List Function After selecting by scoring keywords
34 1.0181491374969 Create Keyword List Function After final loop of keywords
35 1.0181510448456 Related Products Keywords After the related product keywords are found
36 1.0349731445312 Related Products End After the related products are found
37 1.0423450469971 Product End End of the product info controller (Product Info)
38 1.0435450077057 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.0440480709076 Before Get Options Before the call to getOptions in the tpl class
40 1.0700621604919 After Get Options After the call to getOptions in the tpl class
41 1.0701801776886 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.0702080726624 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.2944641113281 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.2944700717926 Product Info: Before Template Display Before the template is displayed
45 1.3916840553284 Product Info: After Template Display After the template is displayed
46 1.3916959762573 Finalizing debug Before the debug is output to the page.
47 1.3917090892792 End of App This is the end of the app logging, final timestamp


Query Debug - 234 Database Queries. Total time 0.1322 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00070405006408691
SELECT parameter, value FROM parameters
2 0.0009 0.0009160041809082
SELECT * FROM `bad_bots`
3 0.0004 0.00043702125549316
SET time_zone = 'Europe/London'
4 0.0005 0.00048708915710449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0024139881134033
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.224.117.125\";}'
6 0.0015 0.0015292167663574
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642906640'
7 0.0011 0.0010819435119629
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00064301490783691
UPDATE autorun SET lastrun = '2022-01-23 02:57:20' WHERE id = '13'
9 0.0003 0.00030684471130371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0007 0.00073480606079102
SELECT id FROM pages WHERE pagename = 'rooibos-african-sweety-100g' LIMIT 1
11 0.0006 0.00063490867614746
SELECT id FROM products WHERE pagename = 'rooibos-african-sweety-100g' AND hidden = 0 LIMIT 1
12 0.0013 0.0012531280517578
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0006 0.00063490867614746
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0004 0.00041294097900391
SELECT * FROM pages WHERE pagename = 'rooibos-african-sweety-100g'
15 0.0003 0.00025320053100586
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0003 0.00031685829162598
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0002 0.00023508071899414
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.0002 0.00021195411682129
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.0002 0.00022387504577637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '26'
21 0.0002 0.00022387504577637
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.0002 0.00022411346435547
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.0002 0.00021505355834961
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.0006 0.00061297416687012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00029420852661133
SELECT * FROM categorygroups WHERE id = '1'
26 0.0046 0.0045750141143799
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.0005 0.0005190372467041
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.0003 0.00025200843811035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00031805038452148
SELECT id FROM categories WHERE parent_id = '27'
30 0.0064 0.0063600540161133
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.0004 0.0004279613494873
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.0004 0.00039815902709961
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.0007 0.00065398216247559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.0003511905670166
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00028109550476074
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.0003 0.00025391578674316
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.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '28'
39 0.0004 0.00043702125549316
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.0003 0.00034999847412109
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.0003 0.00025391578674316
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.0011 0.0010569095611572
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.0003352165222168
SELECT * FROM categorygroups WHERE id = '1'
44 0.0012 0.0012362003326416
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.0003 0.00033283233642578
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.0003 0.00034999847412109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '29'
48 0.0009 0.00088000297546387
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.0003 0.00025296211242676
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.0003 0.00027894973754883
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.0007 0.00066685676574707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.0002591609954834
SELECT * FROM categorygroups WHERE id = '1'
53 0.0008 0.00081610679626465
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.0004 0.0004429817199707
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.0003 0.00033116340637207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.00090312957763672
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.0004 0.00035691261291504
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.0004 0.00040197372436523
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.0008 0.00075101852416992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00044584274291992
SELECT * FROM categorygroups WHERE id = '1'
62 0.0009 0.00086808204650879
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.0003 0.00028181076049805
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.0002 0.00023484230041504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00023698806762695
SELECT id FROM categories WHERE parent_id = '31'
66 0.0009 0.00090193748474121
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.00041580200195312
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.0003 0.00025010108947754
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.0006 0.00061702728271484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00044512748718262
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00044798851013184
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0005 0.0005180835723877
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00045514106750488
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.0004 0.00044393539428711
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00088095664978027
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00051403045654297
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0004 0.00036096572875977
SELECT * FROM ipgeocountries WHERE INET_ATON('54.224.117.125') >= INET_ATON(ip_start) AND INET_ATON('54.224.117.125') <= INET_ATON(ip_end)
78 0.0003 0.00033092498779297
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.00026702880859375
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00074005126953125
SELECT * FROM products WHERE pagename = 'rooibos-african-sweety-100g'
81 0.0009 0.00093913078308105
UPDATE products SET viewcount = viewcount + 1 WHERE id = 871
82 0.0009 0.0008540153503418
SELECT * FROM manufacturers WHERE id = '230'
83 0.0009 0.00087404251098633
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '230'
84 0.0006 0.00059890747070312
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '230' LIMIT 1
85 0.0011 0.0010671615600586
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '230' ORDER BY RAND() LIMIT 1
86 0.0003 0.00031685829162598
SELECT * FROM productimages WHERE product_id = '872' ORDER BY sortorder ASC
87 0.0002 0.00024890899658203
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '230'
88 0.0007 0.00072813034057617
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '230'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00037384033203125
SELECT * FROM manufacturerimages WHERE manufacturer_id = '230'
90 0.0005 0.00053095817565918
SELECT category_id FROM products_categories WHERE product_id = '871'
91 0.0003 0.00034713745117188
SELECT * FROM categories WHERE id = '27'
92 0.0069 0.00685715675354
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
93 0.0003 0.00028800964355469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '27'
95 0.0067 0.0066959857940674
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 
96 0.0004 0.00036191940307617
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 
97 0.0002 0.00024795532226562
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
98 0.0003 0.0002591609954834
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '871' ORDER BY sortorder ASC
100 0.0003 0.00025701522827148
SELECT * FROM product_image_select WHERE product_id = '871'
101 0.0002 0.00023698806762695
SELECT * FROM productcustomimages WHERE product_id = '871'
102 0.0006 0.00061297416687012
SELECT * FROM productfeeds WHERE product_id = '871' ORDER BY item_date DESC
103 0.0036 0.0036170482635498
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '871' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0010 0.00097084045410156
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '871' AND t.hidden = 0 AND display_product = 1
105 0.0010 0.0010430812835693
SELECT * FROM productamazoncontent WHERE product_id = '871'
106 0.0013 0.001305103302002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '871' AND a.name = n.originalname
107 0.0009 0.00085711479187012
SELECT * FROM productoffers WHERE product_id = '871' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.00062704086303711
SELECT * FROM productoffers
                WHERE product_id = '871' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00044918060302734
SELECT * FROM productoffers
                WHERE product_id = 871
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00053501129150391
SELECT value FROM productattributes
                WHERE product_id = '871'
                AND name = 'ListPriceAmount'
111 0.0004 0.00041103363037109
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.0071 0.007098913192749
SELECT *, MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AND 871 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00061607360839844
SELECT *, MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AND 871 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00052499771118164
SELECT *, MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos african sweety' IN BOOLEAN MODE) AND 871 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0002 0.00022101402282715
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0007 0.00072216987609863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0003 0.00034093856811523
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00047016143798828
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0002 0.0002281665802002
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0005 0.00045013427734375
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00035715103149414
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00024509429931641
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00032305717468262
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0002 0.00022077560424805
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0002 0.0002281665802002
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0005 0.00046181678771973
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00034499168395996
SELECT id,asin FROM products WHERE parent_id = 871
137 0.0002 0.00021600723266602
SELECT category_id FROM products_categories WHERE product_id = '871'
138 0.0002 0.00024199485778809
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00020408630371094
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.0002 0.00020790100097656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.0002140998840332
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.0002 0.0001990795135498
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.0002 0.00020098686218262
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.0003 0.00027894973754883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0003 0.00025415420532227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '871' AND a.name = n.originalname
147 0.0002 0.00021982192993164
SELECT * FROM productoffers WHERE product_id = '871' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '871' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = 871
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00020098686218262
SELECT value FROM productattributes
                WHERE product_id = '871'
                AND name = 'ListPriceAmount'
151 0.0004 0.00037789344787598
SELECT * FROM products WHERE id = '871'
152 0.0002 0.00020909309387207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '871' AND a.name = n.originalname
153 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '871' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '871' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0002 0.00022721290588379
SELECT * FROM productoffers
                WHERE product_id = 871
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00018310546875
SELECT value FROM productattributes
                WHERE product_id = '871'
                AND name = 'ListPriceAmount'
157 0.0003 0.00030779838562012
SELECT category_id FROM products_categories WHERE product_id = '871' AND prod_type = 'amz'
158 0.0002 0.00020813941955566
SELECT parent_id FROM categories WHERE id = '27'
159 0.0003 0.00025010108947754
SELECT * FROM categories WHERE id = '27'
160 0.0002 0.00020003318786621
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
161 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '27'
163 0.0002 0.00018501281738281
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 
164 0.0002 0.00019192695617676
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 
165 0.0002 0.0002140998840332
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
166 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0004 0.0004270076751709
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
168 0.0002 0.00019407272338867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
169 0.0002 0.00023293495178223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
170 0.0004 0.00036501884460449
SELECT * FROM pages WHERE id = 38
171 0.0045 0.0045080184936523
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
172 0.0006 0.00058102607727051
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:1642906640;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
173 0.0004 0.00042414665222168
SELECT * FROM products WHERE id = 790
174 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = 788
175 0.0005 0.00046610832214355
SELECT * FROM products WHERE id = 787
176 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = 1287
177 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = 780
178 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = 779
179 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '790'
180 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
181 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '790'
182 0.0002 0.00024080276489258
SELECT * FROM productcustomimages WHERE product_id = '790'
183 0.0002 0.00023508071899414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
184 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '788'
188 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
189 0.0003 0.00025010108947754
SELECT * FROM product_image_select WHERE product_id = '788'
190 0.0002 0.00021600723266602
SELECT * FROM productcustomimages WHERE product_id = '788'
191 0.0002 0.0002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
192 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0002 0.00022578239440918
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0002 0.00019288063049316
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0004 0.00040912628173828
SELECT * FROM products WHERE id = '787'
196 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
197 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '787'
198 0.0002 0.0002288818359375
SELECT * FROM productcustomimages WHERE product_id = '787'
199 0.0002 0.00022006034851074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
200 0.0002 0.00021791458129883
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0002 0.00018191337585449
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '1287'
204 0.0004 0.00035190582275391
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
205 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '1287'
206 0.0003 0.0002598762512207
SELECT * FROM productcustomimages WHERE product_id = '1287'
207 0.0003 0.00030708312988281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
208 0.0002 0.00022411346435547
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0002 0.00019288063049316
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.0004432201385498
SELECT * FROM products WHERE id = '780'
212 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
213 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '780'
214 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '780'
215 0.0002 0.00023412704467773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
216 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = '779'
220 0.0003 0.0003049373626709
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
221 0.0004 0.00040197372436523
SELECT * FROM product_image_select WHERE product_id = '779'
222 0.0002 0.00023198127746582
SELECT * FROM productcustomimages WHERE product_id = '779'
223 0.0003 0.00025510787963867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
224 0.0002 0.00024318695068359
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00026917457580566
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0002 0.00020480155944824
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0003 0.00033307075500488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
228 0.0003 0.00031208992004395
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
229 0.0007 0.00069594383239746
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
230 0.0003 0.00031208992004395
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
231 0.0003 0.00029802322387695
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00046896934509277
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
233 0.0004 0.00040698051452637
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0004 0.00040483474731445
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'