Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr)

Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr)
Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (15 x 2gr) (cliquez sur les images pour élargir)
€6,90
Le prix et la disponibilité du produit sont corrects en date du 2021-08-02 06:02:59 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.89052987098694 229 0.1040 0


No Amazon API Requests Made.

Total time 0.89052987098694 seconds

Number Time From Start Name Description
1 0.74912786483765 Initialise Initialise FSB Function
2 0.75155591964722 App Controller Start Start of the App controller (called before the controller of every page)
3 0.75435590744019 Start of getCategoryListByGroup Function Before first category groups query
4 0.75458908081055 After initial query Before first category groups query
5 0.75459003448486 Get Category List for Group Before the call to getCategoryList function
6 0.75459408760071 Start of GetCategoryList function Start of the function
7 0.75459694862366 Before getting categories Query to get specific category list
8 0.75490307807922 After getting categories Query to get specific category list
9 0.75490403175354 Before getting category custom Before call to function getCategoryCustom
10 0.75677108764648 After getting category custom After call to function getCategoryCustom
11 0.75677299499512 Before getting category custom Before call to function getCategoryCustom
12 0.76911091804504 After getting category custom After call to function getCategoryCustom
13 0.76911306381226 Before getting category custom Before call to function getCategoryCustom
14 0.77439093589783 After getting category custom After call to function getCategoryCustom
15 0.77439403533936 Before getting category custom Before call to function getCategoryCustom
16 0.77712106704712 After getting category custom After call to function getCategoryCustom
17 0.77712297439575 Before getting category custom Before call to function getCategoryCustom
18 0.77994394302368 After getting category custom After call to function getCategoryCustom
19 0.77994608879089 Before getting category custom Before call to function getCategoryCustom
20 0.78253388404846 After getting category custom After call to function getCategoryCustom
21 0.78253602981567 End of GetCategoryList function End of the function
22 0.78254103660583 End of getCategoryListByGroup Function Before return()
23 0.78955698013306 App Controller End End of the App controller (called before the controller of every page)
24 0.79013299942017 Product Start Start of the product info controller
25 0.79289293289185 Cache file not found Starting get product details
26 0.81423497200012 Related products Start getting related products if enabled
27 0.81423592567444 Related Products Start Before the related products are found
28 0.81423687934875 Related Products Keywords Before the related product keywords are found
29 0.81424188613892 Create Keyword List Function Start of function
30 0.8143138885498 Create Keyword List Function After looping provided content - 27 keywords found
31 0.81534290313721 Create Keyword List Function After looping initial keyword list - 22 keywords remaining
32 0.81535005569458 Create Keyword List Function After reducing keyword list
33 0.8154079914093 Create Keyword List Function After selecting by scoring keywords
34 0.81541204452515 Create Keyword List Function After final loop of keywords
35 0.81541395187378 Related Products Keywords After the related product keywords are found
36 0.83003902435303 Related Products End After the related products are found
37 0.83623099327087 Product End End of the product info controller (Product Info)
38 0.8370099067688 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.83744502067566 Before Get Options Before the call to getOptions in the tpl class
40 0.86187291145325 After Get Options After the call to getOptions in the tpl class
41 0.86198306083679 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.86201000213623 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.87275290489197 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.87275695800781 Product Info: Before Template Display Before the template is displayed
45 0.89050698280334 Product Info: After Template Display After the template is displayed
46 0.89051699638367 Finalizing debug Before the debug is output to the page.
47 0.89052891731262 End of App This is the end of the app logging, final timestamp


Query Debug - 229 Database Queries. Total time 0.1040 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00050091743469238
SELECT parameter, value FROM parameters
2 0.0007 0.0007469654083252
SELECT * FROM `bad_bots`
3 0.0003 0.00034308433532715
SET time_zone = 'Europe/London'
4 0.0003 0.00030708312988281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0017209053039551
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.229.142.104\";}'
6 0.0013 0.001255989074707
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627931160'
7 0.0003 0.00030708312988281
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00022792816162109
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00048303604125977
SELECT id FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr' LIMIT 1
10 0.0008 0.00076413154602051
SELECT id FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr' AND hidden = 0 LIMIT 1
11 0.0010 0.001039981842041
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00082802772521973
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00038504600524902
SELECT * FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr'
14 0.0002 0.00021886825561523
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00028586387634277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00021696090698242
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0002 0.00022315979003906
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.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00018692016601562
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.0001988410949707
SELECT * FROM categorygroups WHERE id = '1'
25 0.0054 0.0054349899291992
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0002 0.00022196769714355
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.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '27'
29 0.0054 0.0053918361663818
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.0002 0.00024294853210449
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.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
32 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00018787384033203
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018820762634277
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.00028204917907715
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.0001838207244873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0017800331115723
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.0003 0.00027585029602051
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.00017905235290527
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.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061392784118652
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.00021100044250488
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.00017905235290527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00063085556030273
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.0002 0.00022387504577637
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.00021219253540039
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00019478797912598
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066089630126953
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.00021195411682129
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.00017094612121582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066709518432617
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.00020217895507812
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.00019478797912598
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00019311904907227
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00059795379638672
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.00018405914306641
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00015997886657715
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00062203407287598
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.00021982192993164
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.00017714500427246
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00017690658569336
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00018906593322754
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00040888786315918
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00020194053649902
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.0002 0.00020194053649902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00061202049255371
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00053882598876953
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028300285339355
SELECT * FROM ipgeocountries WHERE INET_ATON('3.229.142.104') >= INET_ATON(ip_start) AND INET_ATON('3.229.142.104') <= INET_ATON(ip_end)
77 0.0002 0.00024604797363281
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.0002288818359375
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00049591064453125
SELECT * FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr'
80 0.0016 0.0016229152679443
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3665
81 0.0003 0.00026416778564453
SELECT * FROM manufacturers WHERE id = '538'
82 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
83 0.0002 0.00023484230041504
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '538' LIMIT 1
84 0.0006 0.00061702728271484
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '538' ORDER BY RAND() LIMIT 1
85 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
86 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
87 0.0005 0.00045394897460938
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '538'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00035309791564941
SELECT * FROM manufacturerimages WHERE manufacturer_id = '538'
89 0.0003 0.0003211498260498
SELECT category_id FROM products_categories WHERE product_id = '3665'
90 0.0002 0.00022387504577637
SELECT * FROM categories WHERE id = '27'
91 0.0055 0.0054929256439209
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
92 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00018000602722168
SELECT id FROM categories WHERE parent_id = '27'
94 0.0049 0.0048720836639404
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.0003 0.00025010108947754
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.0001990795135498
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.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
99 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '3665'
100 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '3665'
101 0.0003 0.00030088424682617
SELECT * FROM productfeeds WHERE product_id = '3665' ORDER BY item_date DESC
102 0.0018 0.0017879009246826
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00046801567077637
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3665' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00042104721069336
SELECT * FROM productamazoncontent WHERE product_id = '3665'
105 0.0011 0.0010979175567627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
106 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00047087669372559
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0002 0.00019598007202148
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
110 0.0085 0.0084960460662842
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3665 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0005 0.00045013427734375
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3665 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0005 0.00046801567077637
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3665 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0003 0.00029516220092773
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
114 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '941'
115 0.0002 0.0002131462097168
SELECT * FROM productcustomimages WHERE product_id = '941'
116 0.0002 0.00021195411682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
117 0.0002 0.00024890899658203
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0002 0.00017809867858887
SELECT value FROM productattributes WHERE product_id = '941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0003 0.00026082992553711
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0002 0.00018787384033203
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0002 0.00024604797363281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0002 0.00018787384033203
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '937' ORDER BY sortorder ASC
128 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '937'
129 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '937'
130 0.0002 0.0001828670501709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '937' AND a.name = n.originalname
131 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '937' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '937' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0002 0.0001990795135498
SELECT value FROM productattributes WHERE product_id = '937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00032997131347656
SELECT id,asin FROM products WHERE parent_id = 3665
135 0.0002 0.00017499923706055
SELECT category_id FROM products_categories WHERE product_id = '3665'
136 0.0002 0.00020909309387207
SELECT * FROM categories WHERE id = '27'
137 0.0002 0.00016593933105469
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
138 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
139 0.0002 0.00017404556274414
SELECT id FROM categories WHERE parent_id = '27'
140 0.0002 0.00021100044250488
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 
141 0.0002 0.00018405914306641
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 
142 0.0002 0.00018310546875
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
143 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
144 0.0002 0.00018501281738281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
145 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '3665'
148 0.0002 0.00021100044250488
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00019407272338867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
150 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00036120414733887
SELECT category_id FROM products_categories WHERE product_id = '3665' AND prod_type = 'amz'
153 0.0002 0.00018310546875
SELECT parent_id FROM categories WHERE id = '27'
154 0.0002 0.00019717216491699
SELECT * FROM categories WHERE id = '27'
155 0.0002 0.00018310546875
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
156 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
157 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '27'
158 0.0002 0.00018715858459473
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 
159 0.0002 0.0001680850982666
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 
160 0.0002 0.00018191337585449
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
161 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
162 0.0002 0.00021719932556152
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
163 0.0002 0.00018501281738281
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
164 0.0002 0.00018787384033203
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
165 0.0002 0.0002439022064209
SELECT * FROM pages WHERE id = 38
166 0.0031 0.0030758380889893
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
167 0.0007 0.0007321834564209
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:1627931160;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:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
168 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = 790
169 0.0004 0.00039505958557129
SELECT * FROM products WHERE id = 788
170 0.0004 0.00036406517028809
SELECT * FROM products WHERE id = 787
171 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = 1287
172 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = 777
173 0.0005 0.00046300888061523
SELECT * FROM products WHERE id = 776
174 0.0004 0.00037193298339844
SELECT * FROM products WHERE id = '790'
175 0.0004 0.00039410591125488
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
176 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '790'
177 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '790'
178 0.0002 0.00022578239440918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
179 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0002 0.00024509429931641
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00018501281738281
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0005 0.00051999092102051
SELECT * FROM products WHERE id = '788'
183 0.0003 0.0002589225769043
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
184 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '788'
185 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '788'
186 0.0002 0.00020313262939453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
187 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00024008750915527
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0006 0.00056791305541992
SELECT * FROM products WHERE id = '787'
191 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
192 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '787'
193 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '787'
194 0.0002 0.00018405914306641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
195 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.0002439022064209
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0004 0.00040316581726074
SELECT * FROM products WHERE id = '1287'
199 0.0004 0.00036811828613281
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
200 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '1287'
201 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '1287'
202 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
203 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0002 0.00020098686218262
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = '777'
207 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
208 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '777'
209 0.0002 0.0001978874206543
SELECT * FROM productcustomimages WHERE product_id = '777'
210 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
211 0.0002 0.00021791458129883
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0002 0.00020003318786621
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = '776'
215 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
216 0.0002 0.00018692016601562
SELECT * FROM product_image_select WHERE product_id = '776'
217 0.0002 0.00024986267089844
SELECT * FROM productcustomimages WHERE product_id = '776'
218 0.0003 0.00025701522827148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
219 0.0002 0.00023698806762695
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00021505355834961
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0003 0.00026798248291016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
223 0.0003 0.00027203559875488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
224 0.0006 0.00058293342590332
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
225 0.0003 0.00033903121948242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
226 0.0003 0.00026702880859375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
227 0.0003 0.00031876564025879
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
228 0.0003 0.00030398368835449
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
229 0.0003 0.00029897689819336
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'