Rooibos Tea Robert Roberts

Rooibos Tea Robert Roberts
Rooibos Tea Robert Roberts (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2022-05-18 08:36:28 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

Rooibos Tea Robert Roberts
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.88648414611816 235 0.1678 0


No Amazon API Requests Made.

Total time 0.88648414611816 seconds

Number Time From Start Name Description
1 0.68045902252197 Initialise Initialise FSB Function
2 0.68280816078186 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68610715866089 Start of getCategoryListByGroup Function Before first category groups query
4 0.686439037323 After initial query Before first category groups query
5 0.68644094467163 Get Category List for Group Before the call to getCategoryList function
6 0.68644499778748 Start of GetCategoryList function Start of the function
7 0.686448097229 Before getting categories Query to get specific category list
8 0.68691611289978 After getting categories Query to get specific category list
9 0.6869170665741 Before getting category custom Before call to function getCategoryCustom
10 0.70525598526001 After getting category custom After call to function getCategoryCustom
11 0.70525908470154 Before getting category custom Before call to function getCategoryCustom
12 0.71766901016235 After getting category custom After call to function getCategoryCustom
13 0.71767115592957 Before getting category custom Before call to function getCategoryCustom
14 0.72360897064209 After getting category custom After call to function getCategoryCustom
15 0.72361207008362 Before getting category custom Before call to function getCategoryCustom
16 0.72753000259399 After getting category custom After call to function getCategoryCustom
17 0.72753214836121 Before getting category custom Before call to function getCategoryCustom
18 0.73186707496643 After getting category custom After call to function getCategoryCustom
19 0.73186898231506 Before getting category custom Before call to function getCategoryCustom
20 0.73763513565063 After getting category custom After call to function getCategoryCustom
21 0.73763799667358 End of GetCategoryList function End of the function
22 0.73764514923096 End of getCategoryListByGroup Function Before return()
23 0.74434995651245 App Controller End End of the App controller (called before the controller of every page)
24 0.74497008323669 Product Start Start of the product info controller
25 0.74730801582336 Cache file not found Starting get product details
26 0.78004503250122 Related products Start getting related products if enabled
27 0.78004717826843 Related Products Start Before the related products are found
28 0.78004813194275 Related Products Keywords Before the related product keywords are found
29 0.78005313873291 Create Keyword List Function Start of function
30 0.78013801574707 Create Keyword List Function After looping provided content - 9 keywords found
31 0.78050398826599 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
32 0.78050994873047 Create Keyword List Function After reducing keyword list
33 0.780522108078 Create Keyword List Function After selecting by scoring keywords
34 0.78052616119385 Create Keyword List Function After final loop of keywords
35 0.78052806854248 Related Products Keywords After the related product keywords are found
36 0.79959607124329 Related Products End After the related products are found
37 0.81305909156799 Product End End of the product info controller (Product Info)
38 0.81420111656189 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.81512117385864 Before Get Options Before the call to getOptions in the tpl class
40 0.85246300697327 After Get Options After the call to getOptions in the tpl class
41 0.85260009765625 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.85263395309448 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.86550116539001 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.86550617218018 Product Info: Before Template Display Before the template is displayed
45 0.88645315170288 Product Info: After Template Display After the template is displayed
46 0.88646912574768 Finalizing debug Before the debug is output to the page.
47 0.88648295402527 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1678 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00055384635925293
SELECT parameter, value FROM parameters
2 0.0011 0.0010659694671631
SELECT * FROM `bad_bots`
3 0.0003 0.00029897689819336
SET time_zone = 'Europe/London'
4 0.0004 0.00035905838012695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0017721652984619
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0014 0.0013909339904785
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653303297'
7 0.0005 0.00050592422485352
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00036978721618652
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00063395500183105
SELECT id FROM pages WHERE pagename = 'rooibos-tea-robert-roberts' LIMIT 1
10 0.0006 0.00063610076904297
SELECT id FROM products WHERE pagename = 'rooibos-tea-robert-roberts' AND hidden = 0 LIMIT 1
11 0.0013 0.0012798309326172
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00074386596679688
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00066304206848145
SELECT * FROM pages WHERE pagename = 'rooibos-tea-robert-roberts'
14 0.0003 0.0003199577331543
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00044703483581543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0090 0.0089991092681885
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.0004 0.00041484832763672
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.0004 0.00038504600524902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0068299770355225
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00025415420532227
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.0002589225769043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00029301643371582
SELECT * FROM categorygroups WHERE id = '1'
25 0.0047 0.0046868324279785
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.0004 0.00041317939758301
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.0004 0.00039815902709961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '27'
29 0.0049 0.0048990249633789
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.0004 0.00038695335388184
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.0004 0.00044512748718262
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.00037002563476562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00024509429931641
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018229484558105
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00038599967956543
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.0002 0.00024914741516113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017421245574951
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00043296813964844
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.0004 0.00038695335388184
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.00024604797363281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.0007472038269043
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.0003 0.00026488304138184
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.0002899169921875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00029611587524414
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.0007929801940918
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.0003 0.00033402442932129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0004 0.00035691261291504
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.0004 0.00043797492980957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00028800964355469
SELECT * FROM categorygroups WHERE id = '1'
52 0.0012 0.0011560916900635
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.0003 0.00030016899108887
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.0003 0.00032615661621094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00087404251098633
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.0004 0.00038814544677734
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.0003 0.00028395652770996
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00037002563476562
SELECT * FROM categorygroups WHERE id = '1'
61 0.0014 0.0013740062713623
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.0012 0.0011858940124512
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00027704238891602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00026607513427734
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0011119842529297
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.0004 0.00037980079650879
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.00027298927307129
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.0004 0.0003509521484375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043606758117676
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00046992301940918
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0005 0.00048494338989258
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00040388107299805
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.0005 0.00045490264892578
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0009 0.00090289115905762
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00073599815368652
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00037407875061035
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0003 0.00032806396484375
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00032901763916016
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0008 0.00079798698425293
SELECT * FROM products WHERE pagename = 'rooibos-tea-robert-roberts'
80 0.0008 0.00081205368041992
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3805
81 0.0004 0.00043487548828125
SELECT * FROM manufacturers WHERE id = '639'
82 0.0013 0.0013329982757568
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
83 0.0004 0.00036883354187012
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
84 0.0021 0.0020911693572998
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
85 0.0021 0.002112865447998
SELECT * FROM productimages WHERE product_id = '1078' ORDER BY sortorder ASC
86 0.0004 0.00037884712219238
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
87 0.0013 0.0013458728790283
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00038719177246094
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
89 0.0006 0.00055718421936035
SELECT category_id FROM products_categories WHERE product_id = '3805'
90 0.0004 0.00039196014404297
SELECT * FROM categories WHERE id = '27'
91 0.0056 0.005634069442749
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.0005 0.00050091743469238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00032305717468262
SELECT id FROM categories WHERE parent_id = '27'
94 0.0046 0.0046389102935791
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.0005 0.00045895576477051
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.0005 0.00049901008605957
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.0004 0.00040388107299805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0014 0.0013720989227295
SELECT * FROM productimages WHERE product_id = '3805' ORDER BY sortorder ASC
99 0.0007 0.00066709518432617
SELECT * FROM product_image_select WHERE product_id = '3805'
100 0.0006 0.0006248950958252
SELECT * FROM productcustomimages WHERE product_id = '3805'
101 0.0007 0.00065493583679199
SELECT * FROM productfeeds WHERE product_id = '3805' ORDER BY item_date DESC
102 0.0008 0.00078320503234863
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0010 0.0010321140289307
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3805' AND t.hidden = 0 AND display_product = 1
104 0.0006 0.00055789947509766
SELECT * FROM productamazoncontent WHERE product_id = '3805'
105 0.0011 0.001086950302124
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
106 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.0006248950958252
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0007 0.00066304206848145
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00059795379638672
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
110 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '3805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0004 0.00038695335388184
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
112 0.0083 0.0082600116729736
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00060486793518066
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00066089630126953
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00044083595275879
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0004 0.0003960132598877
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0003 0.00034689903259277
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0005 0.00049805641174316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0004 0.00037193298339844
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00051212310791016
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
123 0.0004 0.00043892860412598
SELECT * FROM product_image_select WHERE product_id = '862'
124 0.0004 0.00038814544677734
SELECT * FROM productcustomimages WHERE product_id = '862'
125 0.0005 0.00045204162597656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
126 0.0005 0.00049209594726562
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00042319297790527
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00045514106750488
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
130 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '878'
131 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '878'
132 0.0004 0.00041294097900391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
133 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00033688545227051
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0005 0.00049400329589844
SELECT id,asin FROM products WHERE parent_id = 3805
137 0.0003 0.00033998489379883
SELECT category_id FROM products_categories WHERE product_id = '3805'
138 0.0004 0.00039005279541016
SELECT * FROM categories WHERE id = '27'
139 0.0004 0.00039792060852051
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
140 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '27'
142 0.0004 0.00038695335388184
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
143 0.0003 0.00026583671569824
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
144 0.0002 0.00024580955505371
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
145 0.0004 0.00044393539428711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0004 0.00041508674621582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
147 0.0003 0.00028896331787109
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
150 0.0004 0.00041913986206055
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
151 0.0006 0.00060009956359863
SELECT * FROM products WHERE id = '3805'
152 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '3805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0004 0.00037193298339844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
154 0.0003 0.00029706954956055
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00037002563476562
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00041007995605469
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
158 0.0007 0.00066399574279785
SELECT category_id FROM products_categories WHERE product_id = '3805' AND prod_type = 'amz'
159 0.0004 0.00044894218444824
SELECT parent_id FROM categories WHERE id = '27'
160 0.0005 0.00046205520629883
SELECT * FROM categories WHERE id = '27'
161 0.0004 0.00038003921508789
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
162 0.0004 0.00041580200195312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '27'
164 0.0004 0.00039505958557129
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
165 0.0004 0.00036191940307617
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
166 0.0005 0.00046086311340332
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
167 0.0004 0.00042510032653809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0005 0.00049185752868652
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0004 0.00037193298339844
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0005 0.00046086311340332
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0005 0.00051283836364746
SELECT * FROM pages WHERE id = 38
172 0.0050 0.0049710273742676
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
173 0.0008 0.00079798698425293
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:1653303298;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
174 0.0008 0.0007781982421875
SELECT * FROM products WHERE id = 788
175 0.0007 0.00071096420288086
SELECT * FROM products WHERE id = 787
176 0.0007 0.00067496299743652
SELECT * FROM products WHERE id = 1287
177 0.0009 0.00090599060058594
SELECT * FROM products WHERE id = 780
178 0.0007 0.00065207481384277
SELECT * FROM products WHERE id = 777
179 0.0007 0.00072193145751953
SELECT * FROM products WHERE id = 776
180 0.0007 0.00072598457336426
SELECT * FROM products WHERE id = '788'
181 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
182 0.0004 0.00041699409484863
SELECT * FROM product_image_select WHERE product_id = '788'
183 0.0003 0.0002741813659668
SELECT * FROM productcustomimages WHERE product_id = '788'
184 0.0005 0.00052309036254883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
185 0.0003 0.00033187866210938
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0005 0.00053095817565918
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0007 0.00068306922912598
SELECT * FROM products WHERE id = '787'
189 0.0004 0.00040793418884277
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
190 0.0004 0.00044393539428711
SELECT * FROM product_image_select WHERE product_id = '787'
191 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '787'
192 0.0004 0.00044989585876465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
193 0.0004 0.00041508674621582
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00043582916259766
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0008 0.00077986717224121
SELECT * FROM products WHERE id = '1287'
197 0.0004 0.00043106079101562
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
198 0.0003 0.00033092498779297
SELECT * FROM product_image_select WHERE product_id = '1287'
199 0.0003 0.00026392936706543
SELECT * FROM productcustomimages WHERE product_id = '1287'
200 0.0004 0.00037002563476562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
201 0.0004 0.00042009353637695
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00062179565429688
SELECT * FROM products WHERE id = '780'
205 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
206 0.0003 0.00029683113098145
SELECT * FROM product_image_select WHERE product_id = '780'
207 0.0003 0.00027608871459961
SELECT * FROM productcustomimages WHERE product_id = '780'
208 0.0003 0.00030207633972168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
209 0.0004 0.00038814544677734
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00060701370239258
SELECT * FROM products WHERE id = '777'
213 0.0005 0.00046110153198242
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0004 0.00038313865661621
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0003 0.00033307075500488
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0004 0.00039911270141602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0003 0.00034904479980469
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00034213066101074
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '776'
221 0.0004 0.00044989585876465
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0004 0.00040888786315918
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0006 0.00056314468383789
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0005 0.00053501129150391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0004 0.0003969669342041
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00052690505981445
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0005 0.00051498413085938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0008 0.00084614753723145
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.0004730224609375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00052499771118164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0006 0.0006258487701416
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.00047492980957031
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00054693222045898
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'