Rooibos Capetown Bio 200g

Rooibos Capetown Bio 200g
Rooibos Capetown Bio 200g Rooibos Capetown Bio 200g Rooibos Capetown Bio 200g Rooibos Capetown Bio 200g Rooibos Capetown Bio 200g (cliquez sur les images pour élargir)
€14,99
Le prix et la disponibilité du produit sont corrects en date du 2021-09-16 13:50:14 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.
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.83763694763184 235 0.1259 0


No Amazon API Requests Made.

Total time 0.83763694763184 seconds

Number Time From Start Name Description
1 0.68929195404053 Initialise Initialise FSB Function
2 0.69095683097839 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69384980201721 Start of getCategoryListByGroup Function Before first category groups query
4 0.69429492950439 After initial query Before first category groups query
5 0.69429683685303 Get Category List for Group Before the call to getCategoryList function
6 0.69430088996887 Start of GetCategoryList function Start of the function
7 0.6943039894104 Before getting categories Query to get specific category list
8 0.69494199752808 After getting categories Query to get specific category list
9 0.69494295120239 Before getting category custom Before call to function getCategoryCustom
10 0.71268892288208 After getting category custom After call to function getCategoryCustom
11 0.71269297599792 Before getting category custom Before call to function getCategoryCustom
12 0.71428298950195 After getting category custom After call to function getCategoryCustom
13 0.7142858505249 Before getting category custom Before call to function getCategoryCustom
14 0.71919989585876 After getting category custom After call to function getCategoryCustom
15 0.71920299530029 Before getting category custom Before call to function getCategoryCustom
16 0.72179889678955 After getting category custom After call to function getCategoryCustom
17 0.72180080413818 Before getting category custom Before call to function getCategoryCustom
18 0.72426080703735 After getting category custom After call to function getCategoryCustom
19 0.72426295280457 Before getting category custom Before call to function getCategoryCustom
20 0.72662901878357 After getting category custom After call to function getCategoryCustom
21 0.7266309261322 End of GetCategoryList function End of the function
22 0.726637840271 End of getCategoryListByGroup Function Before return()
23 0.73059296607971 App Controller End End of the App controller (called before the controller of every page)
24 0.73102784156799 Product Start Start of the product info controller
25 0.7331268787384 Cache file not found Starting get product details
26 0.76052188873291 Related products Start getting related products if enabled
27 0.76052379608154 Related Products Start Before the related products are found
28 0.76052498817444 Related Products Keywords Before the related product keywords are found
29 0.7605299949646 Create Keyword List Function Start of function
30 0.76055192947388 Create Keyword List Function After looping provided content - 9 keywords found
31 0.760910987854 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
32 0.76091599464417 Create Keyword List Function After reducing keyword list
33 0.76092791557312 Create Keyword List Function After selecting by scoring keywords
34 0.76093101501465 Create Keyword List Function After final loop of keywords
35 0.76093292236328 Related Products Keywords After the related product keywords are found
36 0.77636194229126 Related Products End After the related products are found
37 0.78384280204773 Product End End of the product info controller (Product Info)
38 0.78462290763855 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.78511381149292 Before Get Options Before the call to getOptions in the tpl class
40 0.81376099586487 After Get Options After the call to getOptions in the tpl class
41 0.81384587287903 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.81387400627136 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.81911897659302 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.81912302970886 Product Info: Before Template Display Before the template is displayed
45 0.83760690689087 Product Info: After Template Display After the template is displayed
46 0.83761882781982 Finalizing debug Before the debug is output to the page.
47 0.83763480186462 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1259 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046086311340332
SELECT parameter, value FROM parameters
2 0.0011 0.0011448860168457
SELECT * FROM `bad_bots`
3 0.0021 0.0020990371704102
SET time_zone = 'Europe/London'
4 0.0003 0.00034308433532715
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0016818046569824
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0011 0.0011289119720459
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632135668'
7 0.0004 0.00044798851013184
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0010421276092529
UPDATE autorun SET lastrun = '2021-09-20 11:01:09' WHERE id = '13'
9 0.0003 0.00025510787963867
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0004 0.00042819976806641
SELECT id FROM pages WHERE pagename = 'rooibos-capetown-bio-200g' LIMIT 1
11 0.0006 0.00057291984558105
SELECT id FROM products WHERE pagename = 'rooibos-capetown-bio-200g' AND hidden = 0 LIMIT 1
12 0.0011 0.001121997833252
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0008 0.00082087516784668
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.0005500316619873
SELECT * FROM pages WHERE pagename = 'rooibos-capetown-bio-200g'
15 0.0004 0.00042891502380371
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00061607360839844
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0091 0.0091259479522705
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0003 0.00029087066650391
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00016593933105469
SELECT id FROM categories WHERE parent_id = '26'
21 0.0069 0.0069210529327393
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0003 0.00033807754516602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00018095970153809
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00017619132995605
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0002 0.00018000602722168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00016593933105469
SELECT id FROM categories WHERE parent_id = '27'
30 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00016880035400391
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0002 0.00016117095947266
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00015997886657715
SELECT * FROM categorygroups WHERE id = '1'
35 0.0017 0.0016818046569824
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00026392936706543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00018405914306641
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0002 0.00023102760314941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0002 0.00020194053649902
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00021505355834961
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0002 0.00023007392883301
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0002 0.00020694732666016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00017786026000977
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00060296058654785
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0002 0.0002129077911377
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.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 (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00015807151794434
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00046110153198242
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.0002589225769043
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00016188621520996
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0002 0.00019979476928711
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00017094612121582
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00052118301391602
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0002 0.00018692016601562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.0001530647277832
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00054001808166504
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00017499923706055
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00021696090698242
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00025796890258789
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00032401084899902
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0002 0.00024914741516113
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00047588348388672
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00057196617126465
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00026202201843262
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.212.116') >= INET_ATON(ip_start) AND INET_ATON('3.236.212.116') <= INET_ATON(ip_end)
78 0.0002 0.0002131462097168
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.0001978874206543
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00052905082702637
SELECT * FROM products WHERE pagename = 'rooibos-capetown-bio-200g'
81 0.0011 0.001101016998291
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1011
82 0.0003 0.00026512145996094
SELECT * FROM manufacturers WHERE id = '255'
83 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
84 0.0002 0.00018095970153809
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '255' LIMIT 1
85 0.0010 0.0010130405426025
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '255' ORDER BY RAND() LIMIT 1
86 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
87 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
88 0.0005 0.00049495697021484
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '255'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00029897689819336
SELECT * FROM manufacturerimages WHERE manufacturer_id = '255'
90 0.0003 0.00030708312988281
SELECT category_id FROM products_categories WHERE product_id = '1011'
91 0.0004 0.0003819465637207
SELECT * FROM categories WHERE id = '27'
92 0.0045 0.00453782081604
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0002 0.00017404556274414
SELECT id FROM categories WHERE parent_id = '27'
95 0.0045 0.0044832229614258
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0003 0.00025510787963867
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0002 0.00020480155944824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
100 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '1011'
101 0.0002 0.00021004676818848
SELECT * FROM productcustomimages WHERE product_id = '1011'
102 0.0003 0.00032782554626465
SELECT * FROM productfeeds WHERE product_id = '1011' ORDER BY item_date DESC
103 0.0007 0.00067400932312012
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0018 0.0017631053924561
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1011' AND t.hidden = 0 AND display_product = 1
105 0.0003 0.0003361701965332
SELECT * FROM tags WHERE id = '1'
106 0.0017 0.0017149448394775
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0016 0.0015761852264404
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0019 0.0019280910491943
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
110 0.0005 0.00054597854614258
SELECT * FROM productamazoncontent WHERE product_id = '1011'
111 0.0009 0.00090479850769043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
112 0.0006 0.00064992904663086
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00046586990356445
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0002 0.00022006034851074
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
116 0.0082 0.0082027912139893
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
117 0.0005 0.00052309036254883
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0005 0.0005497932434082
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
120 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '878'
121 0.0002 0.00020909309387207
SELECT * FROM productcustomimages WHERE product_id = '878'
122 0.0002 0.0002281665802002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
123 0.0003 0.00027704238891602
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.00037384033203125
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00029587745666504
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0004 0.00043892860412598
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
127 0.0003 0.00026702880859375
SELECT * FROM product_image_select WHERE product_id = '858'
128 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '858'
129 0.0002 0.00022792816162109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
130 0.0002 0.0002291202545166
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0003 0.00030207633972168
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0004 0.00035786628723145
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
134 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '862'
135 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '862'
136 0.0002 0.00021815299987793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
137 0.0002 0.00021886825561523
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.0005030632019043
SELECT id,asin FROM products WHERE parent_id = 1011
141 0.0002 0.00023508071899414
SELECT category_id FROM products_categories WHERE product_id = '1011'
142 0.0002 0.00021505355834961
SELECT * FROM categories WHERE id = '27'
143 0.0002 0.00019693374633789
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
144 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
145 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '27'
146 0.0002 0.00018215179443359
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 
147 0.0002 0.00018811225891113
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 
148 0.0002 0.00017094612121582
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
149 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
150 0.0002 0.00019001960754395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
151 0.0002 0.00024890899658203
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0008 0.00084900856018066
SELECT * FROM products WHERE id = '1011'
154 0.0002 0.00020217895507812
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0002 0.00023508071899414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
156 0.0002 0.00022196769714355
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0002 0.00023484230041504
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00036215782165527
SELECT category_id FROM products_categories WHERE product_id = '1011' AND prod_type = 'amz'
159 0.0003 0.00031399726867676
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.00025796890258789
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00020098686218262
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.0002 0.00020694732666016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00022292137145996
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.0002 0.00022602081298828
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.0002 0.00018095970153809
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.0002 0.00021004676818848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0004 0.00038790702819824
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00020694732666016
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00022196769714355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00028800964355469
SELECT * FROM pages WHERE id = 38
172 0.0047 0.0047249794006348
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.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:1632135669;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0006 0.00058412551879883
SELECT * FROM products WHERE id = 790
175 0.0006 0.0005791187286377
SELECT * FROM products WHERE id = 788
176 0.0006 0.00059890747070312
SELECT * FROM products WHERE id = 787
177 0.0011 0.001121997833252
SELECT * FROM products WHERE id = 1287
178 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = 779
179 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = 777
180 0.0007 0.00065994262695312
SELECT * FROM products WHERE id = '790'
181 0.0005 0.00047588348388672
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00022315979003906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00030612945556641
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = '788'
189 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00022387504577637
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.00024294853210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0003 0.00028514862060547
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.0002129077911377
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = '787'
197 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.0002448558807373
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00019407272338867
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00020384788513184
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0008 0.00081205368041992
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00042986869812012
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0002 0.00023102760314941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0002 0.0002138614654541
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00058293342590332
SELECT * FROM products WHERE id = '779'
213 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0002 0.0002439022064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00028181076049805
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00024509429931641
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = '777'
221 0.0002 0.0002291202545166
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0002 0.00023603439331055
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0002 0.00024986267089844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00030994415283203
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00035190582275391
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00042986869812012
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0007 0.00074195861816406
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0003 0.00031495094299316
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00043797492980957
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0006 0.00058794021606445
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.00046086311340332
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.00034999847412109
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'