Alister & Lloyd - Thé Rooibos - 601 Rooibos Original

Alister & Lloyd - Thé Rooibos - 601 Rooibos Original
Alister & Lloyd - Thé Rooibos - 601 Rooibos Original (cliquez sur les images pour élargir)
€4,90
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 10:45:32 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.

Description du Fabricant

Rooibos nature.L'afrique du Sud dans la tasse ! Alister & Lloyd, maison de négoce de thés, recherche pour vous la perfection de ce breuvage. Au coeur des plus beaux jardins de thés, Alister & Lloyd sélectionne les feuilles de calibres parfaits afin d'apporter à votre tasse toute l'excellence d'une liqueur symbole de correspondances exotiques.

Caractéristiques du Produit

Rooibos nature. L'afrique du Sud dans la tasse ! En bouteille de 50 gr pour garder toute sa fraicheur Alister & Lloyd, maison de négoce de thés, recherche pour vous la perfection de ce breuvage. Au coeur des plus beaux jardins de thés, Allister & Lloyd sélectionne les feuilles de calibres parfaits afin d'apporter à votre tasse toute l'excellence d'une liqueur symbole de correspondances exotiques.
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
1.1437091827393 235 0.1531 0


No Amazon API Requests Made.

Total time 1.1437091827393 seconds

Number Time From Start Name Description
1 0.90142917633057 Initialise Initialise FSB Function
2 0.90329003334045 App Controller Start Start of the App controller (called before the controller of every page)
3 0.90587115287781 Start of getCategoryListByGroup Function Before first category groups query
4 0.90608596801758 After initial query Before first category groups query
5 0.90608716011047 Get Category List for Group Before the call to getCategoryList function
6 0.90609097480774 Start of GetCategoryList function Start of the function
7 0.90609502792358 Before getting categories Query to get specific category list
8 0.90657019615173 After getting categories Query to get specific category list
9 0.90657210350037 Before getting category custom Before call to function getCategoryCustom
10 0.92940711975098 After getting category custom After call to function getCategoryCustom
11 0.92940998077393 Before getting category custom Before call to function getCategoryCustom
12 0.945228099823 After getting category custom After call to function getCategoryCustom
13 0.94523096084595 Before getting category custom Before call to function getCategoryCustom
14 0.95020318031311 After getting category custom After call to function getCategoryCustom
15 0.95020604133606 Before getting category custom Before call to function getCategoryCustom
16 0.95316219329834 After getting category custom After call to function getCategoryCustom
17 0.95316410064697 Before getting category custom Before call to function getCategoryCustom
18 0.9559280872345 After getting category custom After call to function getCategoryCustom
19 0.95593118667603 Before getting category custom Before call to function getCategoryCustom
20 0.95897817611694 After getting category custom After call to function getCategoryCustom
21 0.95898103713989 End of GetCategoryList function End of the function
22 0.95898509025574 End of getCategoryListByGroup Function Before return()
23 0.96392607688904 App Controller End End of the App controller (called before the controller of every page)
24 0.96453809738159 Product Start Start of the product info controller
25 0.96970200538635 Cache file not found Starting get product details
26 0.99430108070374 Related products Start getting related products if enabled
27 0.99430203437805 Related Products Start Before the related products are found
28 0.99430418014526 Related Products Keywords Before the related product keywords are found
29 0.99430918693542 Create Keyword List Function Start of function
30 0.99438405036926 Create Keyword List Function After looping provided content - 20 keywords found
31 0.99523711204529 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
32 0.99524402618408 Create Keyword List Function After reducing keyword list
33 0.99530005455017 Create Keyword List Function After selecting by scoring keywords
34 0.9953031539917 Create Keyword List Function After final loop of keywords
35 0.99530506134033 Related Products Keywords After the related product keywords are found
36 1.0211100578308 Related Products End After the related products are found
37 1.0279290676117 Product End End of the product info controller (Product Info)
38 1.0287289619446 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.029205083847 Before Get Options Before the call to getOptions in the tpl class
40 1.0626041889191 After Get Options After the call to getOptions in the tpl class
41 1.0626981258392 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.06272315979 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.1111080646515 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.1111121177673 Product Info: Before Template Display Before the template is displayed
45 1.1436831951141 Product Info: After Template Display After the template is displayed
46 1.1436951160431 Finalizing debug Before the debug is output to the page.
47 1.1437079906464 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1531 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00044488906860352
SELECT parameter, value FROM parameters
2 0.0008 0.00076699256896973
SELECT * FROM `bad_bots`
3 0.0002 0.00023889541625977
SET time_zone = 'Europe/London'
4 0.0002 0.00020217895507812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0018289089202881
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.236.232.99\";}'
6 0.0014 0.0013890266418457
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1634883015'
7 0.0003 0.00031208992004395
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00025296211242676
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00048398971557617
SELECT id FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-601-rooibos-original' LIMIT 1
10 0.0005 0.00048685073852539
SELECT id FROM products WHERE pagename = 'alister-lloyd-the-rooibos-601-rooibos-original' AND hidden = 0 LIMIT 1
11 0.0009 0.0009150505065918
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00078296661376953
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00044584274291992
SELECT * FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-601-rooibos-original'
14 0.0002 0.00020289421081543
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00045585632324219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0103 0.010288000106812
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.0003 0.00028800964355469
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.00018620491027832
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '26'
20 0.0103 0.010257005691528
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.00041985511779785
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.0005 0.00047492980957031
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.00034904479980469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00022196769714355
SELECT * FROM categorygroups WHERE id = '1'
25 0.0076 0.0075769424438477
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.0003 0.00026202201843262
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.00024890899658203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0003209114074707
SELECT id FROM categories WHERE parent_id = '27'
29 0.0063 0.0063290596008301
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.00035595893859863
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.0002 0.00023007392883301
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.0002 0.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00019216537475586
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017268657684326
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.0003 0.00026798248291016
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.00021910667419434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016450881958008
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.00020194053649902
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.00022101402282715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00019288063049316
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00060701370239258
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.00024700164794922
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.00018811225891113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00018787384033203
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00075817108154297
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.00029110908508301
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.00019693374633789
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056910514831543
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.00024294853210449
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.00018692016601562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00018692016601562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00058794021606445
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.0002 0.00024509429931641
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.0002129077911377
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.00021791458129883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020813941955566
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00068092346191406
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.00020718574523926
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.0002601146697998
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00074291229248047
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.0002 0.00021910667419434
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.0002 0.00021910667419434
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.00021815299987793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00021100044250488
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00020098686218262
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00027203559875488
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00042009353637695
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.00029802322387695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00062799453735352
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00052309036254883
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00023198127746582
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.232.99') >= INET_ATON(ip_start) AND INET_ATON('3.236.232.99') <= INET_ATON(ip_end)
77 0.0002 0.00020790100097656
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.0001828670501709
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.000640869140625
SELECT * FROM products WHERE pagename = 'alister-lloyd-the-rooibos-601-rooibos-original'
80 0.0005 0.00049686431884766
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1323
81 0.0006 0.00058698654174805
SELECT * FROM manufacturers WHERE id = '173'
82 0.0007 0.00066399574279785
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
83 0.0004 0.00043702125549316
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '173' LIMIT 1
84 0.0009 0.00090408325195312
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '173' ORDER BY RAND() LIMIT 1
85 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
86 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
87 0.0006 0.00061488151550293
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '173'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.0003809928894043
SELECT * FROM manufacturerimages WHERE manufacturer_id = '173'
89 0.0005 0.00046920776367188
SELECT category_id FROM products_categories WHERE product_id = '1323'
90 0.0002 0.0002291202545166
SELECT * FROM categories WHERE id = '27'
91 0.0058 0.0058479309082031
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.0003 0.00025391578674316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '27'
94 0.0057 0.005652904510498
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.00022292137145996
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.0001981258392334
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.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00018119812011719
SELECT * FROM productimages WHERE product_id = '1323' ORDER BY sortorder ASC
99 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '1323'
100 0.0002 0.00017309188842773
SELECT * FROM productcustomimages WHERE product_id = '1323'
101 0.0004 0.00038480758666992
SELECT * FROM productfeeds WHERE product_id = '1323' ORDER BY item_date DESC
102 0.0005 0.0005190372467041
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0006 0.0005791187286377
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1323' AND t.hidden = 0 AND display_product = 1
104 0.0009 0.00088405609130859
SELECT * FROM productamazoncontent WHERE product_id = '1323'
105 0.0010 0.0010099411010742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname
106 0.0004 0.00044417381286621
SELECT * FROM productoffers WHERE product_id = '1323' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '1323' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = 1323
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00043988227844238
SELECT value FROM productattributes
                WHERE product_id = '1323'
                AND name = 'ListPriceAmount'
110 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '1323' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.0005340576171875
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.0096 0.0095698833465576
SELECT *, MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AND 1323 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00055503845214844
SELECT *, MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AND 1323 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00050497055053711
SELECT *, MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('601 rooibos original' IN BOOLEAN MODE) AND 1323 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00037193298339844
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0007 0.00065994262695312
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0007 0.00071096420288086
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0008 0.00084018707275391
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0002 0.00020790100097656
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0002 0.0002288818359375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0016 0.0015997886657715
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.0002589225769043
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
130 0.0002 0.00018882751464844
SELECT * FROM product_image_select WHERE product_id = '862'
131 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '862'
132 0.0008 0.00084996223449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
133 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0048 0.004849910736084
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00026702880859375
SELECT id,asin FROM products WHERE parent_id = 1323
137 0.0002 0.00016593933105469
SELECT category_id FROM products_categories WHERE product_id = '1323'
138 0.0002 0.00020194053649902
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00016283988952637
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.0002 0.00015807151794434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0003 0.00028610229492188
SELECT id FROM categories WHERE parent_id = '27'
142 0.0004 0.00036001205444336
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.0002 0.00017786026000977
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.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
145 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname
147 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '1323' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00016689300537109
SELECT * FROM productoffers
                WHERE product_id = '1323' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00016498565673828
SELECT * FROM productoffers
                WHERE product_id = 1323
                ORDER BY price ASC LIMIT 1
150 0.0002 0.0001680850982666
SELECT value FROM productattributes
                WHERE product_id = '1323'
                AND name = 'ListPriceAmount'
151 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '1323'
152 0.0002 0.00015997886657715
SELECT value FROM productattributes WHERE product_id = '1323' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00019121170043945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname
154 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '1323' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '1323' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00018310546875
SELECT * FROM productoffers
                WHERE product_id = 1323
                ORDER BY price ASC LIMIT 1
157 0.0002 0.0001680850982666
SELECT value FROM productattributes
                WHERE product_id = '1323'
                AND name = 'ListPriceAmount'
158 0.0003 0.00032210350036621
SELECT category_id FROM products_categories WHERE product_id = '1323' AND prod_type = 'amz'
159 0.0002 0.00017905235290527
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00022101402282715
SELECT * FROM categories WHERE id = '27'
161 0.0001 0.00014710426330566
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.0001521110534668
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.0001530647277832
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00015902519226074
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.0001 0.00014495849609375
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.00015687942504883
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.00015020370483398
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0003 0.00025296211242676
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00022006034851074
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00019192695617676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00025391578674316
SELECT * FROM pages WHERE id = 38
172 0.0078 0.0078129768371582
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.0006 0.00055599212646484
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:1634883016;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:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
174 0.0006 0.00063610076904297
SELECT * FROM products WHERE id = 790
175 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = 788
176 0.0007 0.0006871223449707
SELECT * FROM products WHERE id = 787
177 0.0006 0.00060415267944336
SELECT * FROM products WHERE id = 1287
178 0.0007 0.00065207481384277
SELECT * FROM products WHERE id = 780
179 0.0007 0.00068092346191406
SELECT * FROM products WHERE id = 779
180 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = '790'
181 0.0004 0.00041007995605469
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00020909309387207
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0005 0.00052380561828613
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00034713745117188
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00054287910461426
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.0002129077911377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0006 0.00056886672973633
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00018405914306641
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00044894218444824
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00019216537475586
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00022506713867188
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00022292137145996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0005 0.00053095817565918
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00047492980957031
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00040197372436523
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00019478797912598
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0002 0.0002439022064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0004 0.00041794776916504
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00020694732666016
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00053286552429199
SELECT * FROM products WHERE id = '780'
213 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
214 0.0002 0.00018692016601562
SELECT * FROM product_image_select WHERE product_id = '780'
215 0.0002 0.00017404556274414
SELECT * FROM productcustomimages WHERE product_id = '780'
216 0.0002 0.00020098686218262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
217 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00051116943359375
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00046896934509277
SELECT * FROM products WHERE id = '779'
221 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
222 0.0002 0.0002448558807373
SELECT * FROM product_image_select WHERE product_id = '779'
223 0.0002 0.00020909309387207
SELECT * FROM productcustomimages WHERE product_id = '779'
224 0.0002 0.00024914741516113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
225 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00021004676818848
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00029802322387695
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00044894218444824
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0007 0.00068116188049316
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00047397613525391
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00046706199645996
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0005 0.00045204162597656
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0007 0.0006868839263916
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0002 0.00020599365234375
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'