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
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.

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.

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'