0

Floraison Rooibos Chillout 30G - Paquet de 6

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-20 05:13:09 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.

Product Features

Floraison Rooibos Chillout 30G - Paquet de 6 Quantité: 6

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
1.4909279346466 261 0.9510 0


No Amazon API Requests Made.


App Debug - Total Time 1.4909279346466 seconds

Number Time From Start Name Description
1 0.41648602485657 Initialise Initialise FSB Function
2 0.42311310768127 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46410202980042 Start of getCategoryListByGroup Function Before first category groups query
4 0.46571493148804 After initial query Before first category groups query
5 0.46571707725525 Get Category List for Group Before the call to getCategoryList function
6 0.46572208404541 Start of GetCategoryList function Start of the function
7 0.46572613716125 Before getting categories Query to get specific category list
8 0.467689037323 After getting categories Query to get specific category list
9 0.46769213676453 Before getting category custom Before call to function getCategoryCustom
10 0.5084171295166 After getting category custom After call to function getCategoryCustom
11 0.50841999053955 Before getting category custom Before call to function getCategoryCustom
12 0.53701400756836 After getting category custom After call to function getCategoryCustom
13 0.5370180606842 Before getting category custom Before call to function getCategoryCustom
14 0.54583501815796 After getting category custom After call to function getCategoryCustom
15 0.54583716392517 Before getting category custom Before call to function getCategoryCustom
16 0.55108499526978 After getting category custom After call to function getCategoryCustom
17 0.5510880947113 Before getting category custom Before call to function getCategoryCustom
18 0.5565459728241 After getting category custom After call to function getCategoryCustom
19 0.55654811859131 Before getting category custom Before call to function getCategoryCustom
20 0.56244802474976 After getting category custom After call to function getCategoryCustom
21 0.56245112419128 End of GetCategoryList function End of the function
22 0.56245708465576 Get Category List for Group Before the call to getCategoryList function
23 0.56245994567871 Start of GetCategoryList function Start of the function
24 0.56246209144592 Before getting categories Query to get specific category list
25 0.56326699256897 End of getCategoryListByGroup Function Before return()
26 1.1084380149841 App Controller End End of the App controller (called before the controller of every page)
27 1.108757019043 Product Start Start of the product info controller
28 1.1527709960938 Cache file not found Starting get product details
29 1.2181811332703 Related products Start getting related products if enabled
30 1.2181830406189 Related Products Start Before the related products are found
31 1.2181839942932 Related Products Keywords Before the related product keywords are found
32 1.2181870937347 Create Keyword List Function Start of function
33 1.2182791233063 Create Keyword List Function After looping provided content - 18 keywords found
34 1.2190020084381 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.2190079689026 Create Keyword List Function After reducing keyword list
36 1.2190380096436 Create Keyword List Function After selecting by scoring keywords
37 1.2190401554108 Create Keyword List Function After final loop of keywords
38 1.2190420627594 Related Products Keywords After the related product keywords are found
39 1.2736170291901 Related Products End After the related products are found
40 1.3284339904785 Product End End of the product info controller (Product Info)
41 1.3310010433197 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3333320617676 Before Get Options Before the call to getOptions in the tpl class
43 1.3946709632874 After Get Options After the call to getOptions in the tpl class
44 1.3948221206665 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3948450088501 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4221651554108 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.422168970108 Product Info: Before Template Display Before the template is displayed
48 1.4909100532532 Product Info: After Template Display After the template is displayed
49 1.4909150600433 Finalizing debug Before the debug is output to the page.
50 1.4909269809723 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.9510 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.0027320384979248
SELECT parameter, value FROM parameters
2 0.0088 0.0088059902191162
SELECT * FROM `bad_bots`
3 0.0005 0.00051093101501465
SET time_zone = 'Europe/London'
4 0.0032 0.0031871795654297
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0032 0.0032088756561279
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0036 0.0036101341247559
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738868129'
7 0.0025 0.0025408267974854
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00097894668579102
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0024 0.0024399757385254
SELECT id FROM pages WHERE pagename = 'floraison-rooibos-chillout-30g-paquet-de-6' LIMIT 1
10 0.0027 0.002687931060791
SELECT id FROM products WHERE pagename = 'floraison-rooibos-chillout-30g-paquet-de-6' AND hidden = 0 LIMIT 1
11 0.0030 0.003032922744751
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0363 0.036288976669312
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00076103210449219
SELECT * FROM pages WHERE pagename = 'floraison-rooibos-chillout-30g-paquet-de-6'
14 0.0016 0.0015912055969238
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0019 0.0019299983978271
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0128 0.012843132019043
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.0040 0.0039680004119873
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.0024 0.0023579597473145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0018 0.0017950534820557
SELECT id FROM categories WHERE parent_id = '26'
20 0.0080 0.0080299377441406
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.0035 0.0035438537597656
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.0053 0.0052728652954102
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.0017 0.0016989707946777
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0010 0.00098299980163574
SELECT * FROM categorygroups WHERE id = '1'
25 0.0065 0.0065479278564453
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.0025 0.0025222301483154
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.0100 0.009998083114624
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0033 0.003291130065918
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0038459300994873
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.0006 0.00058913230895996
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.0006 0.00062704086303711
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.0005 0.00053501129150391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049304962158203
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0019938945770264
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.0008 0.00079703330993652
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.0004730224609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00053191184997559
SELECT id FROM categories WHERE parent_id = '28'
38 0.0021 0.0021140575408936
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.0006 0.0006110668182373
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.0011 0.001121997833252
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.0006 0.00058388710021973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00049400329589844
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00071907043457031
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.0005 0.00052285194396973
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.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00047397613525391
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00075912475585938
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.0005 0.00051522254943848
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.0006 0.00056695938110352
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.00053000450134277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00055694580078125
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066590309143066
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.00050497055053711
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.0005 0.00048589706420898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00052404403686523
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00077104568481445
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.0007 0.00073790550231934
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.0006101131439209
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.0006 0.0005650520324707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00049901008605957
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00077295303344727
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.00051403045654297
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.00046396255493164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00053191184997559
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00085806846618652
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.0006 0.00055408477783203
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.0007 0.00066280364990234
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.0009 0.00089502334594727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00056886672973633
SELECT * FROM categorygroups WHERE id = '1'
70 0.0008 0.0007929801940918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0029020309448242
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0015180110931396
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.000701904296875
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.0014081001281738
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0012249946594238
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0011670589447021
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5307 0.53070497512817
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
78 0.0026 0.0025870800018311
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012979507446289
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00068402290344238
SELECT * FROM products WHERE pagename = 'floraison-rooibos-chillout-30g-paquet-de-6'
81 0.0004 0.00039410591125488
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1431
82 0.0012 0.0011970996856689
SELECT * FROM manufacturers WHERE id = '334'
83 0.0010 0.00095701217651367
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '334'
84 0.0036 0.0036368370056152
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '334' LIMIT 1
85 0.0038 0.0038430690765381
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '334' ORDER BY RAND() LIMIT 1
86 0.0007 0.00070500373840332
SELECT * FROM productimages WHERE product_id = '1431' ORDER BY sortorder ASC
87 0.0009 0.00091195106506348
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '334'
88 0.0011 0.0010941028594971
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '334'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0016 0.0015890598297119
SELECT * FROM manufacturerimages WHERE manufacturer_id = '334'
90 0.0009 0.00090503692626953
SELECT category_id FROM products_categories WHERE product_id = '1431'
91 0.0009 0.00093293190002441
SELECT * FROM categories WHERE id = '27'
92 0.0099 0.0099210739135742
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.0036 0.0035769939422607
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '27'
95 0.0063 0.0063049793243408
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.0008 0.0007789134979248
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.0008 0.00078392028808594
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.0007 0.00067901611328125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '1431' ORDER BY sortorder ASC
100 0.0020 0.0019698143005371
SELECT * FROM product_image_select WHERE product_id = '1431'
101 0.0017 0.0017139911651611
SELECT * FROM productcustomimages WHERE product_id = '1431'
102 0.0014 0.0014469623565674
SELECT * FROM productfeeds WHERE product_id = '1431' ORDER BY item_date DESC
103 0.0028 0.0027689933776855
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1431' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0032 0.0031569004058838
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1431' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00041294097900391
SELECT * FROM tags WHERE id = '1'
106 0.0016 0.0016441345214844
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0014 0.0014212131500244
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0015 0.0014998912811279
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0007 0.00071001052856445
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0019 0.0018808841705322
SELECT * FROM productamazoncontent WHERE product_id = '1431'
111 0.0012 0.0011568069458008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1431' AND a.name = n.originalname
112 0.0016 0.0016379356384277
SELECT * FROM productoffers WHERE product_id = '1431' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0006 0.00058698654174805
SELECT * FROM productoffers
                WHERE product_id = '1431' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = 1431
                ORDER BY price ASC LIMIT 1
115 0.0014 0.0013589859008789
SELECT value FROM productattributes
                WHERE product_id = '1431'
                AND name = 'ListPriceAmount'
116 0.0009 0.00091910362243652
SELECT value FROM productattributes WHERE product_id = '1431' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0013 0.0012509822845459
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
118 0.0234 0.023408174514771
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AND 1431 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0010 0.00096583366394043
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AND 1431 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0009 0.00089001655578613
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('floraison rooibos chillout' IN BOOLEAN MODE) AND 1431 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0005 0.0005190372467041
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
122 0.0007 0.0006721019744873
SELECT * FROM product_image_select WHERE product_id = '878'
123 0.0005 0.00050806999206543
SELECT * FROM productcustomimages WHERE product_id = '878'
124 0.0013 0.0013489723205566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
125 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0006 0.00060296058654785
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0007 0.00066995620727539
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
129 0.0008 0.00075507164001465
SELECT * FROM product_image_select WHERE product_id = '858'
130 0.0005 0.00050806999206543
SELECT * FROM productcustomimages WHERE product_id = '858'
131 0.0012 0.001168966293335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
132 0.0006 0.00063896179199219
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0006 0.00063014030456543
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0007 0.00067996978759766
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
136 0.0008 0.00079202651977539
SELECT * FROM product_image_select WHERE product_id = '890'
137 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '890'
138 0.0012 0.001183032989502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
139 0.0006 0.00057697296142578
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00052785873413086
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
143 0.0007 0.00069785118103027
SELECT * FROM product_image_select WHERE product_id = '865'
144 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '865'
145 0.0009 0.00088596343994141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
146 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
150 0.0007 0.00067901611328125
SELECT * FROM product_image_select WHERE product_id = '869'
151 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '869'
152 0.0011 0.0010519027709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
153 0.0006 0.00058412551879883
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00055694580078125
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0007 0.00068497657775879
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
157 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '862'
158 0.0007 0.00066089630126953
SELECT * FROM productcustomimages WHERE product_id = '862'
159 0.0011 0.0010721683502197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
160 0.0008 0.00079107284545898
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0006 0.00061702728271484
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.0005958080291748
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.0005648136138916
SELECT id,asin FROM products WHERE parent_id = 1431
164 0.0019 0.0019462108612061
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1431' ORDER BY timestamp DESC
165 0.0006 0.00059080123901367
SELECT category_id FROM products_categories WHERE product_id = '1431'
166 0.0006 0.00057697296142578
SELECT * FROM categories WHERE id = '27'
167 0.0057 0.0056700706481934
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
168 0.0006 0.00056695938110352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '27'
170 0.0039 0.003911018371582
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 
171 0.0022 0.0022289752960205
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 
172 0.0019 0.0019400119781494
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
173 0.0019 0.00187087059021
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0040 0.0040440559387207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1431' AND a.name = n.originalname
175 0.0016 0.0015938282012939
SELECT * FROM productoffers WHERE product_id = '1431' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0013 0.0013198852539062
SELECT * FROM productoffers
                WHERE product_id = '1431' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0013 0.0013229846954346
SELECT * FROM productoffers
                WHERE product_id = 1431
                ORDER BY price ASC LIMIT 1
178 0.0009 0.00090909004211426
SELECT value FROM productattributes
                WHERE product_id = '1431'
                AND name = 'ListPriceAmount'
179 0.0012 0.001237154006958
SELECT * FROM products WHERE id = '1431'
180 0.0010 0.0010449886322021
SELECT value FROM productattributes WHERE product_id = '1431' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0018 0.0018441677093506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1431' AND a.name = n.originalname
182 0.0007 0.00069308280944824
SELECT * FROM productoffers WHERE product_id = '1431' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0007 0.00068998336791992
SELECT * FROM productoffers
                WHERE product_id = '1431' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0006 0.00064206123352051
SELECT * FROM productoffers
                WHERE product_id = 1431
                ORDER BY price ASC LIMIT 1
185 0.0007 0.00069499015808105
SELECT value FROM productattributes
                WHERE product_id = '1431'
                AND name = 'ListPriceAmount'
186 0.0009 0.00085997581481934
SELECT category_id FROM products_categories WHERE product_id = '1431' AND prod_type = 'amz'
187 0.0009 0.00085186958312988
SELECT parent_id FROM categories WHERE id = '27'
188 0.0005 0.00052499771118164
SELECT * FROM categories WHERE id = '27'
189 0.0074 0.0074191093444824
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
190 0.0007 0.0007319450378418
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0005 0.00053787231445312
SELECT id FROM categories WHERE parent_id = '27'
192 0.0050 0.0050461292266846
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 
193 0.0007 0.00068998336791992
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 
194 0.0007 0.00072598457336426
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
195 0.0007 0.00073003768920898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0023 0.0022580623626709
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0018 0.0018110275268555
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00043010711669922
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0141 0.0140540599823
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
200 0.0019 0.0018520355224609
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
201 0.0006 0.00059986114501953
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
202 0.0006 0.00057387351989746
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00060296058654785
SELECT * FROM products WHERE id = 4041
204 0.0006 0.00058197975158691
SELECT * FROM products WHERE id = 4312
205 0.0006 0.00060582160949707
SELECT * FROM products WHERE id = 777
206 0.0006 0.00061702728271484
SELECT * FROM products WHERE id = 3881
207 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00060892105102539
SELECT * FROM products WHERE id = '1626'
209 0.0006 0.00059413909912109
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0007 0.00068402290344238
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0005 0.0004889965057373
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0009 0.00090503692626953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0005 0.00052213668823242
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00047111511230469
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = '4041'
217 0.0005 0.00050687789916992
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0006 0.00064992904663086
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.00045084953308105
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0012 0.001166820526123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0005 0.00052285194396973
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.0005040168762207
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0006 0.00062298774719238
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0004 0.00044512748718262
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0011 0.0011348724365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0006 0.00055217742919922
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00048589706420898
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00061607360839844
SELECT * FROM products WHERE id = '777'
233 0.0005 0.00052618980407715
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0006 0.00061893463134766
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0005 0.00047397613525391
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0010 0.0010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00047111511230469
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0008 0.00075101852416992
SELECT * FROM products WHERE id = '3881'
241 0.0006 0.00060105323791504
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00064587593078613
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00043082237243652
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0006 0.00058102607727051
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0005 0.00046682357788086
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = '4213'
249 0.0008 0.00078201293945312
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0007 0.00071501731872559
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0012 0.0012378692626953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0006 0.00061202049255371
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0006 0.00057220458984375
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0006 0.00057196617126465
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0021 0.0021429061889648
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0010 0.00096011161804199
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0030 0.0030438899993896
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0020 0.0019938945770264
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0008 0.00078296661376953
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0013 0.0013110637664795
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'