0

Freshpak Rooibos Tea 100g

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-25 05:52:40 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

Convient pour les diabétiques Emballage Info: recyclable. Conserver dans un endroit frais et sec. Pays d'origine: Afrique du Sud. Rooibos

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.6604499816895 256 0.8305 0


No Amazon API Requests Made.


App Debug - Total Time 1.6604499816895 seconds

Number Time From Start Name Description
1 0.74259400367737 Initialise Initialise FSB Function
2 0.74779915809631 App Controller Start Start of the App controller (called before the controller of every page)
3 0.78813600540161 Start of getCategoryListByGroup Function Before first category groups query
4 0.79217600822449 After initial query Before first category groups query
5 0.79218006134033 Get Category List for Group Before the call to getCategoryList function
6 0.79218506813049 Start of GetCategoryList function Start of the function
7 0.79219102859497 Before getting categories Query to get specific category list
8 0.79470205307007 After getting categories Query to get specific category list
9 0.7947051525116 Before getting category custom Before call to function getCategoryCustom
10 0.8383321762085 After getting category custom After call to function getCategoryCustom
11 0.83833718299866 Before getting category custom Before call to function getCategoryCustom
12 0.85327315330505 After getting category custom After call to function getCategoryCustom
13 0.85327816009521 Before getting category custom Before call to function getCategoryCustom
14 0.86086106300354 After getting category custom After call to function getCategoryCustom
15 0.86086511611938 Before getting category custom Before call to function getCategoryCustom
16 0.86595511436462 After getting category custom After call to function getCategoryCustom
17 0.86595797538757 Before getting category custom Before call to function getCategoryCustom
18 0.87101411819458 After getting category custom After call to function getCategoryCustom
19 0.87101602554321 Before getting category custom Before call to function getCategoryCustom
20 0.87711501121521 After getting category custom After call to function getCategoryCustom
21 0.87711811065674 End of GetCategoryList function End of the function
22 0.87712597846985 Get Category List for Group Before the call to getCategoryList function
23 0.87712907791138 Start of GetCategoryList function Start of the function
24 0.87713217735291 Before getting categories Query to get specific category list
25 0.87780809402466 End of getCategoryListByGroup Function Before return()
26 1.3241431713104 App Controller End End of the App controller (called before the controller of every page)
27 1.3248629570007 Product Start Start of the product info controller
28 1.3588709831238 Cache file not found Starting get product details
29 1.4208240509033 Related products Start getting related products if enabled
30 1.420825958252 Related Products Start Before the related products are found
31 1.4208281040192 Related Products Keywords Before the related product keywords are found
32 1.420835018158 Create Keyword List Function Start of function
33 1.4208660125732 Create Keyword List Function After looping provided content - 9 keywords found
34 1.4212460517883 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
35 1.4212529659271 Create Keyword List Function After reducing keyword list
36 1.4212641716003 Create Keyword List Function After selecting by scoring keywords
37 1.4212679862976 Create Keyword List Function After final loop of keywords
38 1.4212701320648 Related Products Keywords After the related product keywords are found
39 1.4677240848541 Related Products End After the related products are found
40 1.5055191516876 Product End End of the product info controller (Product Info)
41 1.5085279941559 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5105030536652 Before Get Options Before the call to getOptions in the tpl class
43 1.5903990268707 After Get Options After the call to getOptions in the tpl class
44 1.5906140804291 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.590665102005 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6068601608276 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6068680286407 Product Info: Before Template Display Before the template is displayed
48 1.6603910923004 Product Info: After Template Display After the template is displayed
49 1.6604211330414 Finalizing debug Before the debug is output to the page.
50 1.6604480743408 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 0.8305 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0011 0.0011050701141357
SELECT parameter, value FROM parameters
2 0.0047 0.0046589374542236
SELECT * FROM `bad_bots`
3 0.0004 0.0003511905670166
SET time_zone = 'Europe/London'
4 0.0034 0.0034468173980713
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0115 0.011493921279907
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.222.131.239\";}'
6 0.0053 0.0052950382232666
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1726107124'
7 0.0022 0.00217604637146
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054502487182617
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0018 0.0017690658569336
SELECT id FROM pages WHERE pagename = 'freshpak-rooibos-tea-100g' LIMIT 1
10 0.0019 0.0019259452819824
SELECT id FROM products WHERE pagename = 'freshpak-rooibos-tea-100g' AND hidden = 0 LIMIT 1
11 0.0024 0.0023601055145264
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0361 0.036127090454102
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0011 0.0011401176452637
SELECT * FROM pages WHERE pagename = 'freshpak-rooibos-tea-100g'
14 0.0040 0.004019021987915
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0025 0.0024778842926025
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0087 0.0087461471557617
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.0030 0.0029971599578857
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.0046 0.0045738220214844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0013 0.0012898445129395
SELECT id FROM categories WHERE parent_id = '26'
20 0.0159 0.015852928161621
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.0037 0.0036509037017822
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.0027 0.0026540756225586
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.0031 0.003058910369873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00051784515380859
SELECT * FROM categorygroups WHERE id = '1'
25 0.0055 0.0054669380187988
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.0007 0.00067496299743652
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.0005 0.00051116943359375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00055289268493652
SELECT id FROM categories WHERE parent_id = '27'
29 0.0050 0.0049538612365723
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.0007 0.00073385238647461
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.0007 0.00071597099304199
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.0006 0.00060009956359863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053906440734863
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018959045410156
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.0006 0.0006260871887207
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.0005 0.00049495697021484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00051283836364746
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017340183258057
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.0006 0.00058412551879883
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.0006 0.00061297416687012
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00048613548278809
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00065112113952637
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.0005 0.00050497055053711
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.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.0004432201385498
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00081014633178711
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.0005 0.00054407119750977
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.0006 0.00061893463134766
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.0005 0.00054097175598145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046706199645996
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066304206848145
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.0006 0.0005500316619873
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.0005 0.00045895576477051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.0004429817199707
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.0007779598236084
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.0005 0.00051689147949219
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.0006 0.00056099891662598
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.0005 0.00050783157348633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047898292541504
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075483322143555
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.0005 0.00052499771118164
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.0006 0.00058317184448242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00055098533630371
SELECT id FROM categories WHERE parent_id = '31'
65 0.0010 0.00099897384643555
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.0007 0.00072717666625977
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.0007 0.00071501731872559
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.0006 0.00058293342590332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00056290626525879
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.00066494941711426
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0040 0.0040450096130371
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0023 0.0023391246795654
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00075697898864746
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.0019 0.0019011497497559
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.001288890838623
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012209415435791
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4279 0.42788195610046
SELECT * FROM ipgeocountries WHERE INET_ATON('44.222.131.239') >= INET_ATON(ip_start) AND INET_ATON('44.222.131.239') <= INET_ATON(ip_end)
78 0.0028 0.0028011798858643
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0020 0.0019650459289551
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00077700614929199
SELECT * FROM products WHERE pagename = 'freshpak-rooibos-tea-100g'
81 0.0005 0.00045084953308105
UPDATE products SET viewcount = viewcount + 1 WHERE id = 863
82 0.0008 0.0008389949798584
SELECT * FROM manufacturers WHERE id = '169'
83 0.0006 0.00059008598327637
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '169'
84 0.0024 0.0024049282073975
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '169' LIMIT 1
85 0.0031 0.0031311511993408
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '169' ORDER BY RAND() LIMIT 1
86 0.0007 0.00065302848815918
SELECT * FROM productimages WHERE product_id = '939' ORDER BY sortorder ASC
87 0.0008 0.00075602531433105
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '169'
88 0.0008 0.00080704689025879
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '169'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0007 0.00067400932312012
SELECT * FROM manufacturerimages WHERE manufacturer_id = '169'
90 0.0008 0.00076889991760254
SELECT category_id FROM products_categories WHERE product_id = '863'
91 0.0008 0.00081419944763184
SELECT * FROM categories WHERE id = '27'
92 0.0055 0.0054988861083984
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.0006 0.00059604644775391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00040888786315918
SELECT id FROM categories WHERE parent_id = '27'
95 0.0061 0.0060899257659912
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.0008 0.00079488754272461
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.0008 0.00084900856018066
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.0006 0.00060391426086426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00058794021606445
SELECT * FROM productimages WHERE product_id = '863' ORDER BY sortorder ASC
100 0.0026 0.002561092376709
SELECT * FROM product_image_select WHERE product_id = '863'
101 0.0017 0.0016958713531494
SELECT * FROM productcustomimages WHERE product_id = '863'
102 0.0017 0.0017318725585938
SELECT * FROM productfeeds WHERE product_id = '863' ORDER BY item_date DESC
103 0.0162 0.016248941421509
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '863' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0045 0.0044500827789307
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '863' AND t.hidden = 0 AND display_product = 1
105 0.0022 0.0021789073944092
SELECT * FROM productamazoncontent WHERE product_id = '863'
106 0.0010 0.0010440349578857
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '863' AND a.name = n.originalname
107 0.0020 0.0019981861114502
SELECT * FROM productoffers WHERE product_id = '863' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '863' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.0004730224609375
SELECT * FROM productoffers
                WHERE product_id = 863
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00057506561279297
SELECT value FROM productattributes
                WHERE product_id = '863'
                AND name = 'ListPriceAmount'
111 0.0004 0.00041580200195312
SELECT value FROM productattributes WHERE product_id = '863' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00052094459533691
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
113 0.0127 0.012672185897827
SELECT *, MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AND 863 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0010 0.00095510482788086
SELECT *, MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AND 863 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0010 0.00097107887268066
SELECT *, MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('freshpak rooibos tea' IN BOOLEAN MODE) AND 863 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0009 0.00090599060058594
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
117 0.0007 0.00066518783569336
SELECT * FROM product_image_select WHERE product_id = '858'
118 0.0004 0.00044608116149902
SELECT * FROM productcustomimages WHERE product_id = '858'
119 0.0012 0.0011968612670898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
120 0.0006 0.00055217742919922
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00063610076904297
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
124 0.0006 0.0005948543548584
SELECT * FROM product_image_select WHERE product_id = '869'
125 0.0004 0.00042819976806641
SELECT * FROM productcustomimages WHERE product_id = '869'
126 0.0009 0.00094699859619141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
127 0.0005 0.00050997734069824
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.00041413307189941
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0005 0.00046420097351074
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
131 0.0006 0.00060391426086426
SELECT * FROM product_image_select WHERE product_id = '865'
132 0.0004 0.00040507316589355
SELECT * FROM productcustomimages WHERE product_id = '865'
133 0.0008 0.00078487396240234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
134 0.0005 0.00051188468933105
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00046706199645996
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
138 0.0008 0.00081110000610352
SELECT * FROM product_image_select WHERE product_id = '878'
139 0.0004 0.00043606758117676
SELECT * FROM productcustomimages WHERE product_id = '878'
140 0.0017 0.0016579627990723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
141 0.0019 0.0018959045410156
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0005 0.00050592422485352
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0006 0.00056600570678711
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
145 0.0007 0.00071907043457031
SELECT * FROM product_image_select WHERE product_id = '890'
146 0.0010 0.0009911060333252
SELECT * FROM productcustomimages WHERE product_id = '890'
147 0.0031 0.003093957901001
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
148 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0005 0.00046515464782715
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0007 0.00068187713623047
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
152 0.0007 0.00071907043457031
SELECT * FROM product_image_select WHERE product_id = '862'
153 0.0005 0.00049114227294922
SELECT * FROM productcustomimages WHERE product_id = '862'
154 0.0012 0.0012080669403076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
155 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.00052881240844727
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0006 0.00056815147399902
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0006 0.00059318542480469
SELECT id,asin FROM products WHERE parent_id = 863
159 0.0021 0.0020980834960938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '863' ORDER BY timestamp DESC
160 0.0006 0.0006110668182373
SELECT category_id FROM products_categories WHERE product_id = '863'
161 0.0006 0.00057196617126465
SELECT * FROM categories WHERE id = '27'
162 0.0046 0.0046310424804688
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
163 0.0005 0.00051212310791016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0004 0.00036811828613281
SELECT id FROM categories WHERE parent_id = '27'
165 0.0038 0.0037779808044434
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 
166 0.0008 0.00080394744873047
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 
167 0.0007 0.00068902969360352
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
168 0.0006 0.00060200691223145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0011 0.0010638236999512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '863' AND a.name = n.originalname
170 0.0006 0.0005958080291748
SELECT * FROM productoffers WHERE product_id = '863' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '863' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = 863
                ORDER BY price ASC LIMIT 1
173 0.0005 0.00047707557678223
SELECT value FROM productattributes
                WHERE product_id = '863'
                AND name = 'ListPriceAmount'
174 0.0007 0.00069212913513184
SELECT * FROM products WHERE id = '863'
175 0.0005 0.00052404403686523
SELECT value FROM productattributes WHERE product_id = '863' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0008 0.00084114074707031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '863' AND a.name = n.originalname
177 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '863' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = '863' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = 863
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00048494338989258
SELECT value FROM productattributes
                WHERE product_id = '863'
                AND name = 'ListPriceAmount'
181 0.0009 0.00092005729675293
SELECT category_id FROM products_categories WHERE product_id = '863' AND prod_type = 'amz'
182 0.0005 0.00053906440734863
SELECT parent_id FROM categories WHERE id = '27'
183 0.0004 0.00036311149597168
SELECT * FROM categories WHERE id = '27'
184 0.0044 0.0044450759887695
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
185 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0004 0.00037813186645508
SELECT id FROM categories WHERE parent_id = '27'
187 0.0057 0.0057120323181152
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 
188 0.0008 0.00076913833618164
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 
189 0.0007 0.00073695182800293
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
190 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191 0.0022 0.0021860599517822
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0015 0.0015261173248291
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0003 0.00034999847412109
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0177 0.017650842666626
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
195 0.0027 0.0027170181274414
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
196 0.0008 0.00083613395690918
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
197 0.0009 0.00088596343994141
SELECT * FROM products WHERE id = 1626
198 0.0007 0.00067996978759766
SELECT * FROM products WHERE id = 4041
199 0.0006 0.00062894821166992
SELECT * FROM products WHERE id = 4312
200 0.0007 0.00072288513183594
SELECT * FROM products WHERE id = 777
201 0.0006 0.00064706802368164
SELECT * FROM products WHERE id = 3881
202 0.0008 0.00078511238098145
SELECT * FROM products WHERE id = 4213
203 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '1626'
204 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0011 0.0010850429534912
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0006 0.00059103965759277
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0021 0.0020649433135986
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0008 0.00076794624328613
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0007 0.00070381164550781
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0008 0.00081110000610352
SELECT * FROM products WHERE id = '4041'
212 0.0008 0.00079083442687988
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0008 0.0007789134979248
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0006 0.00057101249694824
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0018 0.0017600059509277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0007 0.00067806243896484
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0007 0.00066590309143066
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0006 0.0005500316619873
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0007 0.00074005126953125
SELECT * FROM products WHERE id = '4312'
220 0.0006 0.00060105323791504
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0008 0.00081586837768555
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0005 0.00052213668823242
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0020 0.002047061920166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0006 0.00057601928710938
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0007 0.00068807601928711
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00044584274291992
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0006 0.00062799453735352
SELECT * FROM products WHERE id = '777'
228 0.0008 0.00084400177001953
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0009 0.00089693069458008
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0015 0.0014960765838623
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0007 0.0006711483001709
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0006 0.00055909156799316
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0006 0.00057077407836914
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0008 0.00075793266296387
SELECT * FROM products WHERE id = '3881'
236 0.0007 0.00073003768920898
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0008 0.00081491470336914
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0006 0.00057005882263184
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0017 0.0016999244689941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0006 0.00061511993408203
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0006 0.0005948543548584
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00054001808166504
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0008 0.00076699256896973
SELECT * FROM products WHERE id = '4213'
244 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0008 0.00078797340393066
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0005 0.00053596496582031
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0019 0.0018651485443115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0008 0.00076103210449219
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0008 0.00084710121154785
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0014 0.0013949871063232
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0028 0.0027999877929688
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0009 0.0009000301361084
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0035 0.0035340785980225
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0024 0.0024280548095703
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0007 0.00069403648376465
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0008 0.00081992149353027
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'