English Tea Shop - Rooibos Choco Vanilla 20X2G

English Tea Shop - Rooibos Choco Vanilla 20X2G
English Tea Shop - Rooibos Choco Vanilla 20X2G English Tea Shop - Rooibos Choco Vanilla 20X2G English Tea Shop - Rooibos Choco Vanilla 20X2G English Tea Shop - Rooibos Choco Vanilla 20X2G English Tea Shop - Rooibos Choco Vanilla 20X2G (cliquez sur les images pour élargir)
€3,95
Achetez maintenant sur Amazon
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 19:54:24 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.
Informations Produit (plus d'infos)

Caractéristiques du Produit

Biologique - Naturally Caffeine Free
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.

Par Catégories


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.61476492881775 233 0.1261 0


No Amazon API Requests Made.

Total time 0.61476492881775 seconds

Number Time From Start Name Description
1 0.42394590377808 Initialise Initialise FSB Function
2 0.42610096931458 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42873096466064 Start of getCategoryListByGroup Function Before first category groups query
4 0.42897701263428 After initial query Before first category groups query
5 0.42897891998291 Get Category List for Group Before the call to getCategoryList function
6 0.42898178100586 Start of GetCategoryList function Start of the function
7 0.4289858341217 Before getting categories Query to get specific category list
8 0.42939496040344 After getting categories Query to get specific category list
9 0.42939591407776 Before getting category custom Before call to function getCategoryCustom
10 0.44686794281006 After getting category custom After call to function getCategoryCustom
11 0.44687080383301 Before getting category custom Before call to function getCategoryCustom
12 0.45834279060364 After getting category custom After call to function getCategoryCustom
13 0.45834589004517 Before getting category custom Before call to function getCategoryCustom
14 0.46411180496216 After getting category custom After call to function getCategoryCustom
15 0.46411490440369 Before getting category custom Before call to function getCategoryCustom
16 0.46617078781128 After getting category custom After call to function getCategoryCustom
17 0.46617388725281 Before getting category custom Before call to function getCategoryCustom
18 0.46894192695618 After getting category custom After call to function getCategoryCustom
19 0.46894383430481 Before getting category custom Before call to function getCategoryCustom
20 0.4718279838562 After getting category custom After call to function getCategoryCustom
21 0.47182989120483 End of GetCategoryList function End of the function
22 0.471834897995 End of getCategoryListByGroup Function Before return()
23 0.47704100608826 App Controller End End of the App controller (called before the controller of every page)
24 0.4776349067688 Product Start Start of the product info controller
25 0.47974896430969 Cache file not found Starting get product details
26 0.49926590919495 Related products Start getting related products if enabled
27 0.49926781654358 Related Products Start Before the related products are found
28 0.49926900863647 Related Products Keywords Before the related product keywords are found
29 0.49927401542664 Create Keyword List Function Start of function
30 0.49934697151184 Create Keyword List Function After looping provided content - 18 keywords found
31 0.50012588500977 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
32 0.50013279914856 Create Keyword List Function After reducing keyword list
33 0.50016379356384 Create Keyword List Function After selecting by scoring keywords
34 0.50016784667969 Create Keyword List Function After final loop of keywords
35 0.5001699924469 Related Products Keywords After the related product keywords are found
36 0.51504278182983 Related Products End After the related products are found
37 0.52207398414612 Product End End of the product info controller (Product Info)
38 0.52293086051941 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.52339386940002 Before Get Options Before the call to getOptions in the tpl class
40 0.5549647808075 After Get Options After the call to getOptions in the tpl class
41 0.55511498451233 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.55514788627625 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.5904688835144 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.5904757976532 Product Info: Before Template Display Before the template is displayed
45 0.61473679542542 Product Info: After Template Display After the template is displayed
46 0.61475086212158 Finalizing debug Before the debug is output to the page.
47 0.61476397514343 End of App This is the end of the app logging, final timestamp


Query Debug - 233 Database Queries. Total time 0.1261 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00042510032653809 
SELECT parameter, value FROM parameters
2 0.0011 0.0011239051818848 
SELECT * FROM `bad_bots`
3 0.0005 0.00052213668823242 
SET time_zone = 'Europe/London'
4 0.0003 0.00027179718017578 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.001849889755249 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0014 0.001384973526001 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627538236'
7 0.0005 0.00051999092102051 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00027298927307129 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00046205520629883 
SELECT id FROM pages WHERE pagename = 'english-tea-shop-rooibos-choco-vanilla-20x2g' LIMIT 1
10 0.0006 0.00058102607727051 
SELECT id FROM products WHERE pagename = 'english-tea-shop-rooibos-choco-vanilla-20x2g' AND hidden = 0 LIMIT 1
11 0.0008 0.0008399486541748 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00073385238647461 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.00051403045654297 
SELECT * FROM pages WHERE pagename = 'english-tea-shop-rooibos-choco-vanilla-20x2g'
14 0.0002 0.00023293495178223 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00038981437683105 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0087 0.0086679458618164 
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.0002 0.00022602081298828 
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.0002 0.00017094612121582 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00016498565673828 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0073 0.0073330402374268 
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.0002 0.00020694732666016 
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.0002 0.00018906593322754 
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.0002 0.00021600723266602 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00017786026000977 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0043330192565918 
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.0002 0.00024890899658203 
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.0002140998840332 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018095970153809 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.004256010055542 
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.00030708312988281 
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.0006 0.00057888031005859 
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.0004 0.00044798851013184 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0008 0.00078105926513672 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016961097717285 
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.0005 0.00046801567077637 
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.00046396255493164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00043702125549316 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0018100738525391 
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.0002 0.00020813941955566 
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.0002 0.00019001960754395 
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.0002 0.00017809867858887 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00017595291137695 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00022578239440918 
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.00019192695617676 
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.0002 0.00018501281738281 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017309188842773 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0002 0.00017404556274414 
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.00038790702819824 
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.0002 0.00024509429931641 
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.0001988410949707 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00017285346984863 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066113471984863 
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.00021600723266602 
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.00017189979553223 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020313262939453 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00054502487182617 
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.00029087066650391 
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.00020885467529297 
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.0002 0.00017881393432617 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00019001960754395 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00057291984558105 
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.0002 0.00021100044250488 
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.0002 0.00018119812011719 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0001828670501709 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00062108039855957 
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.00032281875610352 
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.0003 0.00025296211242676 
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.0002 0.00021910667419434 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.0002138614654541 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00024700164794922 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00032591819763184 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.0002281665802002 
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.0003 0.00033187866210938 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00052905082702637 
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.0005640983581543 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00019598007202148 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.110.106') >= INET_ATON(ip_start) AND INET_ATON('3.236.110.106') <= INET_ATON(ip_end)
77 0.0002 0.00020003318786621 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00027298927307129 
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00057101249694824 
SELECT * FROM products WHERE pagename = 'english-tea-shop-rooibos-choco-vanilla-20x2g'
80 0.0009 0.0008690357208252 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 941
81 0.0004 0.0004420280456543 
SELECT * FROM manufacturers WHERE id = '170'
82 0.0007 0.00066208839416504 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '170'
83 0.0003 0.00033783912658691 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '170' LIMIT 1
84 0.0007 0.00069499015808105 
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '170' ORDER BY RAND() LIMIT 1
85 0.0003 0.00031590461730957 
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
86 0.0002 0.00018501281738281 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '170'
87 0.0005 0.00047016143798828 
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '170'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0
88 0.0003 0.00030899047851562 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '170'
89 0.0003 0.00031709671020508 
SELECT category_id FROM products_categories WHERE product_id = '941'
90 0.0003 0.00027704238891602 
SELECT * FROM categories WHERE id = '27'
91 0.0049 0.0048680305480957 
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.0002 0.00023484230041504 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00017094612121582 
SELECT id FROM categories WHERE parent_id = '27'
94 0.0049 0.0048940181732178 
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.0002 0.00021815299987793 
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.0002 0.00017905235290527 
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.0002 0.00016093254089355 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0003 0.00025105476379395 
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
99 0.0002 0.00019001960754395 
SELECT * FROM product_image_select WHERE product_id = '941'
100 0.0002 0.00017905235290527 
SELECT * FROM productcustomimages WHERE product_id = '941'
101 0.0003 0.00029802322387695 
SELECT * FROM productfeeds WHERE product_id = '941' ORDER BY item_date DESC
102 0.0004 0.00042009353637695 
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0010 0.001007080078125 
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '941' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00052595138549805 
SELECT * FROM productamazoncontent WHERE product_id = '941'
105 0.0002 0.00020599365234375 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
106 0.0002 0.00023984909057617 
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0002 0.00019097328186035 
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00018906593322754 
SELECT * FROM productoffers
                WHERE product_id = 941
                ORDER BY price ASC LIMIT 1
109 0.0002 0.00020813941955566 
SELECT value FROM productattributes
                WHERE product_id = '941'
                AND name = 'ListPriceAmount'
110 0.0002 0.00022196769714355 
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
111 0.0082 0.0081870555877686 
SELECT *, MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AND 941 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
112 0.0007 0.00069785118103027 
SELECT *, MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AND 941 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00058794021606445 
SELECT *, MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos choco vanilla' IN BOOLEAN MODE) AND 941 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0002 0.00022196769714355 
SELECT * FROM productimages WHERE product_id = '937' ORDER BY sortorder ASC
115 0.0003 0.00025510787963867 
SELECT * FROM product_image_select WHERE product_id = '937'
116 0.0002 0.0001978874206543 
SELECT * FROM productcustomimages WHERE product_id = '937'
117 0.0003 0.00025701522827148 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '937' AND a.name = n.originalname
118 0.0002 0.00018811225891113 
SELECT * FROM productoffers WHERE product_id = '937' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0002 0.00019621849060059 
SELECT * FROM productoffers
                WHERE product_id = '937' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0002 0.00020194053649902 
SELECT value FROM productattributes WHERE product_id = '937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0003 0.00026607513427734 
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
122 0.0002 0.00017714500427246 
SELECT * FROM product_image_select WHERE product_id = '1010'
123 0.0002 0.00020813941955566 
SELECT * FROM productcustomimages WHERE product_id = '1010'
124 0.0002 0.00019311904907227 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
125 0.0002 0.00018906593322754 
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0002 0.00020503997802734 
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0002 0.0002439022064209 
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0003 0.00026583671569824 
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
129 0.0003 0.00027704238891602 
SELECT * FROM product_image_select WHERE product_id = '862'
130 0.0002 0.00019979476928711 
SELECT * FROM productcustomimages WHERE product_id = '862'
131 0.0003 0.00025200843811035 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
132 0.0002 0.00020313262939453 
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0002 0.00019407272338867 
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00033307075500488 
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00058102607727051 
SELECT id,asin FROM products WHERE parent_id = 941
136 0.0003 0.00031495094299316 
SELECT category_id FROM products_categories WHERE product_id = '941'
137 0.0002 0.00023198127746582 
SELECT * FROM categories WHERE id = '27'
138 0.0002 0.00017499923706055 
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
139 0.0002 0.00016689300537109 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
140 0.0002 0.00016283988952637 
SELECT id FROM categories WHERE parent_id = '27'
141 0.0002 0.00019097328186035 
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
142 0.0002 0.00018620491027832 
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
143 0.0002 0.00016403198242188 
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
144 0.0002 0.00016307830810547 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
145 0.0002 0.00019001960754395 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
146 0.0002 0.00019407272338867 
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0002 0.00017189979553223 
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0002 0.00017905235290527 
SELECT * FROM productoffers
                WHERE product_id = 941
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00016880035400391 
SELECT value FROM productattributes
                WHERE product_id = '941'
                AND name = 'ListPriceAmount'
150 0.0005 0.00052309036254883 
SELECT * FROM products WHERE id = '941'
151 0.0002 0.00019598007202148 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
152 0.0002 0.00023388862609863 
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.0001990795135498 
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0002 0.00018000602722168 
SELECT * FROM productoffers
                WHERE product_id = 941
                ORDER BY price ASC LIMIT 1
155 0.0002 0.00018119812011719 
SELECT value FROM productattributes
                WHERE product_id = '941'
                AND name = 'ListPriceAmount'
156 0.0003 0.00033092498779297 
SELECT category_id FROM products_categories WHERE product_id = '941' AND prod_type = 'amz'
157 0.0002 0.00017690658569336 
SELECT parent_id FROM categories WHERE id = '27'
158 0.0002 0.00021791458129883 
SELECT * FROM categories WHERE id = '27'
159 0.0002 0.00015902519226074 
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
160 0.0002 0.00016307830810547 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
161 0.0002 0.00016999244689941 
SELECT id FROM categories WHERE parent_id = '27'
162 0.0002 0.00016379356384277 
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
163 0.0002 0.00016689300537109 
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
164 0.0002 0.00017905235290527 
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
165 0.0002 0.00016498565673828 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
166 0.0003 0.00029110908508301 
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
167 0.0002 0.0001988410949707 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
168 0.0002 0.00018715858459473 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
169 0.0003 0.00033688545227051 
SELECT * FROM pages WHERE id = 38
170 0.0050 0.0050320625305176 
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
171 0.0005 0.00050616264343262 
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:1627538236;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:10:\"808|amazon\";i:4;s:10:\"810|amazon\";i:5;s:11:\"4947|amazon\";}}' WHERE id = '160'
172 0.0006 0.00056195259094238 
SELECT * FROM products WHERE id = 790
173 0.0006 0.00064992904663086 
SELECT * FROM products WHERE id = 788
174 0.0010 0.00099992752075195 
SELECT * FROM products WHERE id = 787
175 0.0008 0.00076198577880859 
SELECT * FROM products WHERE id = 808
176 0.0008 0.00075793266296387 
SELECT * FROM products WHERE id = 810
177 0.0006 0.00064802169799805 
SELECT * FROM products WHERE id = 4947
178 0.0006 0.00060200691223145 
SELECT * FROM products WHERE id = '790'
179 0.0004 0.0004119873046875 
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
180 0.0002 0.00020885467529297 
SELECT * FROM product_image_select WHERE product_id = '790'
181 0.0003 0.00030398368835449 
SELECT * FROM productcustomimages WHERE product_id = '790'
182 0.0003 0.00032615661621094 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
183 0.0003 0.00025296211242676 
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0002 0.00023293495178223 
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0003 0.00029110908508301 
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0006 0.0005648136138916 
SELECT * FROM products WHERE id = '788'
187 0.0003 0.00025200843811035 
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
188 0.0002 0.00022602081298828 
SELECT * FROM product_image_select WHERE product_id = '788'
189 0.0002 0.00023698806762695 
SELECT * FROM productcustomimages WHERE product_id = '788'
190 0.0002 0.00020694732666016 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
191 0.0002 0.00020098686218262 
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0002 0.0002129077911377 
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0002 0.00021505355834961 
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0005 0.00053310394287109 
SELECT * FROM products WHERE id = '787'
195 0.0002 0.00021219253540039 
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
196 0.0002 0.00023007392883301 
SELECT * FROM product_image_select WHERE product_id = '787'
197 0.0002 0.00019216537475586 
SELECT * FROM productcustomimages WHERE product_id = '787'
198 0.0002 0.00019216537475586 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
199 0.0002 0.00020813941955566 
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0002 0.0002129077911377 
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0002 0.00018501281738281 
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0005 0.00052499771118164 
SELECT * FROM products WHERE id = '808'
203 0.0002 0.0001988410949707 
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
204 0.0002 0.00020098686218262 
SELECT * FROM product_image_select WHERE product_id = '808'
205 0.0003 0.00032997131347656 
SELECT * FROM productcustomimages WHERE product_id = '808'
206 0.0002 0.00020813941955566 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
207 0.0002 0.00020503997802734 
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0002 0.00020909309387207 
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00030112266540527 
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00047802925109863 
SELECT * FROM products WHERE id = '810'
211 0.0004 0.00039505958557129 
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
212 0.0003 0.00028610229492188 
SELECT * FROM product_image_select WHERE product_id = '810'
213 0.0002 0.00022006034851074 
SELECT * FROM productcustomimages WHERE product_id = '810'
214 0.0002 0.00018715858459473 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
215 0.0002 0.00018811225891113 
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0002 0.0001988410949707 
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0003 0.00031900405883789 
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0004 0.00043988227844238 
SELECT * FROM products WHERE id = '4947'
219 0.0002 0.00020289421081543 
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
220 0.0002 0.00017595291137695 
SELECT * FROM product_image_select WHERE product_id = '4947'
221 0.0002 0.00017404556274414 
SELECT * FROM productcustomimages WHERE product_id = '4947'
222 0.0002 0.00019121170043945 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
223 0.0002 0.00019407272338867 
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00046896934509277 
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0021 0.0021450519561768 
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0004 0.00036501884460449 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
227 0.0005 0.00047993659973145 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
228 0.0008 0.00078606605529785 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
229 0.0007 0.00073504447937012 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
230 0.0005 0.00045394897460938 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
231 0.0004 0.0004270076751709 
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
232 0.0004 0.00038599967956543 
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
233 0.0005 0.00049591064453125 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'