0

Sachets De Thé Rooibos D'Origine (80)

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-16 23:46:26 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.3719718456268 256 1.3975 0


No Amazon API Requests Made.


App Debug - Total Time 3.3719718456268 seconds

Number Time From Start Name Description
1 1.9127268791199 Initialise Initialise FSB Function
2 1.9244959354401 App Controller Start Start of the App controller (called before the controller of every page)
3 1.9666919708252 Start of getCategoryListByGroup Function Before first category groups query
4 1.9690959453583 After initial query Before first category groups query
5 1.9690999984741 Get Category List for Group Before the call to getCategoryList function
6 1.9691059589386 Start of GetCategoryList function Start of the function
7 1.9691138267517 Before getting categories Query to get specific category list
8 1.9719889163971 After getting categories Query to get specific category list
9 1.9719939231873 Before getting category custom Before call to function getCategoryCustom
10 1.9959878921509 After getting category custom After call to function getCategoryCustom
11 1.9959938526154 Before getting category custom Before call to function getCategoryCustom
12 2.0089290142059 After getting category custom After call to function getCategoryCustom
13 2.0089349746704 Before getting category custom Before call to function getCategoryCustom
14 2.0209150314331 After getting category custom After call to function getCategoryCustom
15 2.0209209918976 Before getting category custom Before call to function getCategoryCustom
16 2.0273070335388 After getting category custom After call to function getCategoryCustom
17 2.0273129940033 Before getting category custom Before call to function getCategoryCustom
18 2.0323388576508 After getting category custom After call to function getCategoryCustom
19 2.0323448181152 Before getting category custom Before call to function getCategoryCustom
20 2.0374639034271 After getting category custom After call to function getCategoryCustom
21 2.0374698638916 End of GetCategoryList function End of the function
22 2.0374820232391 Get Category List for Group Before the call to getCategoryList function
23 2.0374858379364 Start of GetCategoryList function Start of the function
24 2.0374908447266 Before getting categories Query to get specific category list
25 2.0383069515228 End of getCategoryListByGroup Function Before return()
26 2.6681618690491 App Controller End End of the App controller (called before the controller of every page)
27 2.6688458919525 Product Start Start of the product info controller
28 2.6826310157776 Cache file not found Starting get product details
29 2.8166208267212 Related products Start getting related products if enabled
30 2.8166239261627 Related Products Start Before the related products are found
31 2.8166270256042 Related Products Keywords Before the related product keywords are found
32 2.8166348934174 Create Keyword List Function Start of function
33 2.8167729377747 Create Keyword List Function After looping provided content - 15 keywords found
34 2.8177289962769 Create Keyword List Function After looping initial keyword list - 13 keywords remaining
35 2.8177390098572 Create Keyword List Function After reducing keyword list
36 2.81778383255 Create Keyword List Function After selecting by scoring keywords
37 2.8177909851074 Create Keyword List Function After final loop of keywords
38 2.8177950382233 Related Products Keywords After the related product keywords are found
39 2.9428329467773 Related Products End After the related products are found
40 3.0558969974518 Product End End of the product info controller (Product Info)
41 3.067941904068 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 3.077810049057 Before Get Options Before the call to getOptions in the tpl class
43 3.310868024826 After Get Options After the call to getOptions in the tpl class
44 3.3111109733582 App_after Controller End End of the App_after controller (called after the controller of every page)
45 3.3111639022827 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 3.318531036377 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 3.3185379505157 Product Info: Before Template Display Before the template is displayed
48 3.3719189167023 Product Info: After Template Display After the template is displayed
49 3.3719458580017 Finalizing debug Before the debug is output to the page.
50 3.3719699382782 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 1.3975 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015308856964111
SELECT parameter, value FROM parameters
2 0.0089 0.0088880062103271
SELECT * FROM `bad_bots`
3 0.0004 0.00040912628173828
SET time_zone = 'Europe/London'
4 0.0010 0.00097298622131348
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0044 0.0044190883636475
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"98.82.120.188\";}'
6 0.0050 0.0049848556518555
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725942526'
7 0.0060 0.0059828758239746
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0015 0.0014569759368896
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0051 0.0050909519195557
SELECT id FROM pages WHERE pagename = 'sachets-de-the-rooibos-dorigine-80' LIMIT 1
10 0.0046 0.0045859813690186
SELECT id FROM products WHERE pagename = 'sachets-de-the-rooibos-dorigine-80' AND hidden = 0 LIMIT 1
11 0.0060 0.0059750080108643
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0341 0.034144163131714
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0011 0.0011129379272461
SELECT * FROM pages WHERE pagename = 'sachets-de-the-rooibos-dorigine-80'
14 0.0024 0.0023691654205322
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0028 0.0028212070465088
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0084 0.0084071159362793
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.0008 0.00075793266296387
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.0006 0.00061607360839844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052809715270996
SELECT id FROM categories WHERE parent_id = '26'
20 0.0079 0.0079121589660645
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.0024 0.0023901462554932
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.0007 0.00071310997009277
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.0019 0.0018649101257324
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00052404403686523
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0042510032653809
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.0006 0.00057101249694824
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.0005 0.00047087669372559
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '27'
29 0.0040 0.0039551258087158
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.0007 0.00067305564880371
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.0008 0.00076794624328613
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.0006 0.00057601928710938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0010 0.00098991394042969
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0020039081573486
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.0006 0.00063204765319824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0005 0.00047898292541504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00047087669372559
SELECT id FROM categories WHERE parent_id = '28'
38 0.0045 0.0045359134674072
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.0013 0.0012788772583008
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.0008 0.00077104568481445
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.0011 0.0010759830474854
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00052690505981445
SELECT * FROM categorygroups WHERE id = '1'
43 0.0010 0.00096797943115234
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.0006 0.00062704086303711
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.0005 0.00052380561828613
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00053882598876953
SELECT id FROM categories WHERE parent_id = '29'
47 0.0012 0.0012409687042236
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.0007 0.00066494941711426
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.0007 0.0006871223449707
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.0005 0.00049805641174316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00045394897460938
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00061202049255371
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.0005 0.00049209594726562
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.0004 0.00043988227844238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.0004730224609375
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00074005126953125
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.0006 0.00055503845214844
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.0006 0.00055885314941406
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.0005 0.00049805641174316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047802925109863
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00065302848815918
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.0005 0.00052189826965332
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.0005 0.0004570484161377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00045990943908691
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00076603889465332
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.0005 0.00049495697021484
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.0006 0.00057291984558105
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.0005 0.00050115585327148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00049495697021484
SELECT * FROM categorygroups WHERE id = '1'
70 0.0008 0.00079607963562012
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0030989646911621
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0019 0.0018861293792725
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00066304206848145
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.0014 0.0014488697052002
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0011980533599854
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0017 0.0017180442810059
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.6121 0.61213994026184
SELECT * FROM ipgeocountries WHERE INET_ATON('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
78 0.0036 0.003587007522583
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0023 0.002310037612915
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00079703330993652
SELECT * FROM products WHERE pagename = 'sachets-de-the-rooibos-dorigine-80'
81 0.0015 0.0014841556549072
UPDATE products SET viewcount = viewcount + 1 WHERE id = 940
82 0.0009 0.00090885162353516
SELECT * FROM manufacturers WHERE id = '639'
83 0.0055 0.0055079460144043
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
84 0.0031 0.0031330585479736
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
85 0.0099 0.0098929405212402
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
86 0.0009 0.00091695785522461
SELECT * FROM productimages WHERE product_id = '4476' ORDER BY sortorder ASC
87 0.0069 0.0068950653076172
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
88 0.0097 0.0097219944000244
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0009 0.00089287757873535
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
90 0.0009 0.000885009765625
SELECT category_id FROM products_categories WHERE product_id = '940'
91 0.0011 0.0011122226715088
SELECT * FROM categories WHERE id = '27'
92 0.0170 0.016999006271362
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.0009 0.00091195106506348
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0006 0.0006260871887207
SELECT id FROM categories WHERE parent_id = '27'
95 0.0104 0.010425090789795
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.0009 0.00092506408691406
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.0009 0.00094914436340332
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.0013 0.0013201236724854
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0053 0.0052509307861328
SELECT * FROM productimages WHERE product_id = '940' ORDER BY sortorder ASC
100 0.0036 0.003572940826416
SELECT * FROM product_image_select WHERE product_id = '940'
101 0.0031 0.0030999183654785
SELECT * FROM productcustomimages WHERE product_id = '940'
102 0.0126 0.012635946273804
SELECT * FROM productfeeds WHERE product_id = '940' ORDER BY item_date DESC
103 0.0119 0.011896133422852
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '940' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0082 0.0081501007080078
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '940' AND t.hidden = 0 AND display_product = 1
105 0.0077 0.007749080657959
SELECT * FROM productamazoncontent WHERE product_id = '940'
106 0.0016 0.001600980758667
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '940' AND a.name = n.originalname
107 0.0030 0.0029819011688232
SELECT * FROM productoffers WHERE product_id = '940' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0007 0.00067806243896484
SELECT * FROM productoffers
                WHERE product_id = '940' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00063085556030273
SELECT * FROM productoffers
                WHERE product_id = 940
                ORDER BY price ASC LIMIT 1
110 0.0009 0.00087714195251465
SELECT value FROM productattributes
                WHERE product_id = '940'
                AND name = 'ListPriceAmount'
111 0.0007 0.00067496299743652
SELECT value FROM productattributes WHERE product_id = '940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0009 0.00085783004760742
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
113 0.0174 0.017439842224121
SELECT *, MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AND 940 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0009 0.00094413757324219
SELECT *, MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AND 940 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00072789192199707
SELECT *, MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé rooibos dorigine' IN BOOLEAN MODE) AND 940 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
117 0.0008 0.00082302093505859
SELECT * FROM product_image_select WHERE product_id = '865'
118 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '865'
119 0.0024 0.0024228096008301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
120 0.0018 0.0017797946929932
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0009 0.00092697143554688
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0011 0.0010819435119629
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0021 0.0020508766174316
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
124 0.0008 0.000762939453125
SELECT * FROM product_image_select WHERE product_id = '858'
125 0.0005 0.00050711631774902
SELECT * FROM productcustomimages WHERE product_id = '858'
126 0.0014 0.0014009475708008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
127 0.0006 0.00064206123352051
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0084 0.0084130764007568
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0009 0.00087690353393555
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0011 0.0010521411895752
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
131 0.0011 0.0011129379272461
SELECT * FROM product_image_select WHERE product_id = '869'
132 0.0010 0.0010120868682861
SELECT * FROM productcustomimages WHERE product_id = '869'
133 0.0020 0.0020060539245605
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
134 0.0056 0.0055508613586426
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0007 0.0007321834564209
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0007 0.00072383880615234
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0011 0.0011019706726074
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
138 0.0052 0.0052080154418945
SELECT * FROM product_image_select WHERE product_id = '862'
139 0.0010 0.00099396705627441
SELECT * FROM productcustomimages WHERE product_id = '862'
140 0.0023 0.0022549629211426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
141 0.0085 0.0085101127624512
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0011 0.0011420249938965
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0012 0.0012338161468506
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0013 0.0012540817260742
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
145 0.0018 0.0018339157104492
SELECT * FROM product_image_select WHERE product_id = '878'
146 0.0063 0.0063188076019287
SELECT * FROM productcustomimages WHERE product_id = '878'
147 0.0034 0.0033659934997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
148 0.0050 0.0049781799316406
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0011 0.0011138916015625
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0010 0.0010020732879639
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0052 0.005155086517334
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
152 0.0017 0.001708984375
SELECT * FROM product_image_select WHERE product_id = '890'
153 0.0010 0.00098609924316406
SELECT * FROM productcustomimages WHERE product_id = '890'
154 0.0131 0.013068914413452
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
155 0.0011 0.0010769367218018
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0008 0.00078296661376953
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0009 0.00091886520385742
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0010 0.00096487998962402
SELECT id,asin FROM products WHERE parent_id = 940
159 0.0080 0.0080151557922363
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '940' ORDER BY timestamp DESC
160 0.0014 0.0013530254364014
SELECT category_id FROM products_categories WHERE product_id = '940'
161 0.0012 0.0011999607086182
SELECT * FROM categories WHERE id = '27'
162 0.0134 0.01336407661438
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
163 0.0013 0.0012609958648682
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0006 0.00056219100952148
SELECT id FROM categories WHERE parent_id = '27'
165 0.0141 0.014060020446777
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 
166 0.0009 0.00091695785522461
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 
167 0.0010 0.0010209083557129
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
168 0.0008 0.00081706047058105
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0052 0.0051848888397217
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '940' AND a.name = n.originalname
170 0.0010 0.00096893310546875
SELECT * FROM productoffers WHERE product_id = '940' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0006 0.00062108039855957
SELECT * FROM productoffers
                WHERE product_id = '940' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0006 0.0006110668182373
SELECT * FROM productoffers
                WHERE product_id = 940
                ORDER BY price ASC LIMIT 1
173 0.0007 0.00065088272094727
SELECT value FROM productattributes
                WHERE product_id = '940'
                AND name = 'ListPriceAmount'
174 0.0050 0.0049870014190674
SELECT * FROM products WHERE id = '940'
175 0.0008 0.00081110000610352
SELECT value FROM productattributes WHERE product_id = '940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0013 0.0012528896331787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '940' AND a.name = n.originalname
177 0.0007 0.00069999694824219
SELECT * FROM productoffers WHERE product_id = '940' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '940' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0007 0.0007481575012207
SELECT * FROM productoffers
                WHERE product_id = 940
                ORDER BY price ASC LIMIT 1
180 0.0008 0.00078392028808594
SELECT value FROM productattributes
                WHERE product_id = '940'
                AND name = 'ListPriceAmount'
181 0.0019 0.00193190574646
SELECT category_id FROM products_categories WHERE product_id = '940' AND prod_type = 'amz'
182 0.0010 0.00097894668579102
SELECT parent_id FROM categories WHERE id = '27'
183 0.0006 0.00059700012207031
SELECT * FROM categories WHERE id = '27'
184 0.0085 0.008530855178833
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
185 0.0009 0.00090408325195312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0007 0.00074315071105957
SELECT id FROM categories WHERE parent_id = '27'
187 0.0290 0.028991937637329
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 
188 0.0014 0.0013959407806396
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 
189 0.0010 0.0010418891906738
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
190 0.0055 0.00547194480896
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191 0.0114 0.011369943618774
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0080 0.007951021194458
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0017 0.0017259120941162
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0338 0.033807039260864
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
195 0.0026 0.0025579929351807
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
196 0.0008 0.00078201293945312
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
197 0.0007 0.00070691108703613
SELECT * FROM products WHERE id = 1626
198 0.0078 0.0078361034393311
SELECT * FROM products WHERE id = 4041
199 0.0011 0.0010631084442139
SELECT * FROM products WHERE id = 4312
200 0.0011 0.0011069774627686
SELECT * FROM products WHERE id = 777
201 0.0011 0.0011451244354248
SELECT * FROM products WHERE id = 3881
202 0.0089 0.0088980197906494
SELECT * FROM products WHERE id = 4213
203 0.0011 0.0010831356048584
SELECT * FROM products WHERE id = '1626'
204 0.0017 0.0016558170318604
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0031 0.0030879974365234
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0011 0.001143217086792
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0043 0.0043449401855469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0013 0.0012891292572021
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0009 0.00090599060058594
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0013 0.0012791156768799
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0012 0.0011880397796631
SELECT * FROM products WHERE id = '4041'
212 0.0010 0.00097203254699707
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0013 0.0012989044189453
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0122 0.012198925018311
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0039 0.0039279460906982
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0044 0.0044150352478027
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0011 0.0011379718780518
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0012 0.0012390613555908
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0017 0.0016889572143555
SELECT * FROM products WHERE id = '4312'
220 0.0013 0.0012609958648682
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0064 0.0064351558685303
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0016 0.0016160011291504
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0032 0.0032079219818115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0011 0.0010631084442139
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0016 0.0015521049499512
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0007 0.00069880485534668
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0012 0.0012028217315674
SELECT * FROM products WHERE id = '777'
228 0.0009 0.00092005729675293
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0012 0.0011770725250244
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0042 0.0041520595550537
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0023 0.0022640228271484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0016 0.0015799999237061
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0011 0.0010969638824463
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0064 0.0064342021942139
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0019 0.0019440650939941
SELECT * FROM products WHERE id = '3881'
236 0.0016 0.0015959739685059
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0013 0.0013110637664795
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0008 0.00078511238098145
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0067 0.0067298412322998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0012 0.001183032989502
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0015 0.0014970302581787
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0087 0.008746862411499
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0017 0.0016839504241943
SELECT * FROM products WHERE id = '4213'
244 0.0016 0.0015890598297119
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0017 0.0016770362854004
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0108 0.010777950286865
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0029 0.002871036529541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0008 0.00084900856018066
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0007 0.00074291229248047
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0007 0.00072813034057617
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0143 0.014317989349365
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0011 0.0010910034179688
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0231 0.023103952407837
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0062 0.0062019824981689
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0039 0.0038909912109375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0047 0.0047280788421631
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'