0

Yogi Tea ROOIBOS 17 FILTRES BIO

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 06:20:05 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
1.1828961372375 261 0.7752 0


No Amazon API Requests Made.


App Debug - Total Time 1.1828961372375 seconds

Number Time From Start Name Description
1 0.38442420959473 Initialise Initialise FSB Function
2 0.3875892162323 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42242622375488 Start of getCategoryListByGroup Function Before first category groups query
4 0.42315220832825 After initial query Before first category groups query
5 0.42315411567688 Get Category List for Group Before the call to getCategoryList function
6 0.42315816879272 Start of GetCategoryList function Start of the function
7 0.42316222190857 Before getting categories Query to get specific category list
8 0.42388319969177 After getting categories Query to get specific category list
9 0.42388415336609 Before getting category custom Before call to function getCategoryCustom
10 0.44526219367981 After getting category custom After call to function getCategoryCustom
11 0.44526600837708 Before getting category custom Before call to function getCategoryCustom
12 0.45963215827942 After getting category custom After call to function getCategoryCustom
13 0.45963716506958 Before getting category custom Before call to function getCategoryCustom
14 0.4684522151947 After getting category custom After call to function getCategoryCustom
15 0.4684591293335 Before getting category custom Before call to function getCategoryCustom
16 0.47421503067017 After getting category custom After call to function getCategoryCustom
17 0.47421908378601 Before getting category custom Before call to function getCategoryCustom
18 0.48038601875305 After getting category custom After call to function getCategoryCustom
19 0.48039221763611 Before getting category custom Before call to function getCategoryCustom
20 0.48679900169373 After getting category custom After call to function getCategoryCustom
21 0.48680400848389 End of GetCategoryList function End of the function
22 0.4868152141571 Get Category List for Group Before the call to getCategoryList function
23 0.48681807518005 Start of GetCategoryList function Start of the function
24 0.4868221282959 Before getting categories Query to get specific category list
25 0.48755216598511 End of getCategoryListByGroup Function Before return()
26 0.9587070941925 App Controller End End of the App controller (called before the controller of every page)
27 0.95927405357361 Product Start Start of the product info controller
28 0.96364307403564 Cache file not found Starting get product details
29 1.0020391941071 Related products Start getting related products if enabled
30 1.0020411014557 Related Products Start Before the related products are found
31 1.0020430088043 Related Products Keywords Before the related product keywords are found
32 1.0020492076874 Create Keyword List Function Start of function
33 1.0020890235901 Create Keyword List Function After looping provided content - 15 keywords found
34 1.0029540061951 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
35 1.0029630661011 Create Keyword List Function After reducing keyword list
36 1.0030071735382 Create Keyword List Function After selecting by scoring keywords
37 1.0030131340027 Create Keyword List Function After final loop of keywords
38 1.0030159950256 Related Products Keywords After the related product keywords are found
39 1.0420022010803 Related Products End After the related products are found
40 1.0800621509552 Product End End of the product info controller (Product Info)
41 1.0811061859131 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.0821831226349 Before Get Options Before the call to getOptions in the tpl class
43 1.1593470573425 After Get Options After the call to getOptions in the tpl class
44 1.1595320701599 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.15957903862 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.1667211055756 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.1667292118073 Product Info: Before Template Display Before the template is displayed
48 1.1828420162201 Product Info: After Template Display After the template is displayed
49 1.1828680038452 Finalizing debug Before the debug is output to the page.
50 1.1828939914703 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.7752 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0025 0.002457857131958
SELECT parameter, value FROM parameters
2 0.0035 0.0034580230712891
SELECT * FROM `bad_bots`
3 0.0024 0.0024349689483643
SET time_zone = 'Europe/London'
4 0.0008 0.0008089542388916
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00081801414489746
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.149.231.40\";}'
6 0.0007 0.00067687034606934
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738778299'
7 0.0009 0.00087594985961914
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00071191787719727
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0009770393371582
SELECT id FROM pages WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio' LIMIT 1
10 0.0011 0.0010550022125244
SELECT id FROM products WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio' AND hidden = 0 LIMIT 1
11 0.0019 0.0018980503082275
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0317 0.031675100326538
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00054001808166504
SELECT * FROM pages WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio'
14 0.0007 0.00071096420288086
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00069999694824219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0079 0.0079450607299805
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.00077104568481445
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.0005 0.00050687789916992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053691864013672
SELECT id FROM categories WHERE parent_id = '26'
20 0.0084 0.0083549022674561
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.0013 0.0013399124145508
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.00065898895263672
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.0005 0.00054597854614258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00051593780517578
SELECT * FROM categorygroups WHERE id = '1'
25 0.0049 0.0049018859863281
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.00064206123352051
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.00049901008605957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00047707557678223
SELECT id FROM categories WHERE parent_id = '27'
29 0.0052 0.0052499771118164
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.00067591667175293
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.00062799453735352
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.00058507919311523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047111511230469
SELECT * FROM categorygroups WHERE id = '1'
34 0.0025 0.0025269985198975
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.0007 0.00070810317993164
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.00049710273742676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00047111511230469
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0020270347595215
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.0006260871887207
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.0007 0.00069808959960938
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.0005 0.00053000450134277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00053977966308594
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00070691108703613
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.0006110668182373
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.00046992301940918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00047707557678223
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00085783004760742
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.0006 0.00063896179199219
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.00064206123352051
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.0007 0.00066900253295898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.0005650520324707
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00079798698425293
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.0006 0.00057315826416016
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.0006 0.00055694580078125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00052690505981445
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00087189674377441
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.0008 0.00076913833618164
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.0007 0.00071501731872559
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.00063586235046387
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.0005948543548584
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00071883201599121
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.0008 0.00076198577880859
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.00054407119750977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0007 0.00069189071655273
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0011451244354248
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.0007 0.00073099136352539
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.00069093704223633
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.00051593780517578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043606758117676
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.00071191787719727
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0015699863433838
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00063610076904297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00056815147399902
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.0004 0.0003819465637207
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0010 0.0010480880737305
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010747909545898
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4606 0.46063780784607
SELECT * FROM ipgeocountries WHERE INET_ATON('3.149.231.40') >= INET_ATON(ip_start) AND INET_ATON('3.149.231.40') <= INET_ATON(ip_end)
78 0.0022 0.002161979675293
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0017 0.0016589164733887
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0017 0.0017468929290771
SELECT * FROM products WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio'
81 0.0021 0.0020580291748047
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3168
82 0.0007 0.00069022178649902
SELECT * FROM manufacturers WHERE id = '226'
83 0.0007 0.00066804885864258
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
84 0.0005 0.00054001808166504
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '226' LIMIT 1
85 0.0009 0.00092101097106934
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '226' ORDER BY RAND() LIMIT 1
86 0.0005 0.00051712989807129
SELECT * FROM productimages WHERE product_id = '1279' ORDER BY sortorder ASC
87 0.0006 0.00057888031005859
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
88 0.0006 0.00058889389038086
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '226'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00035977363586426
SELECT * FROM manufacturerimages WHERE manufacturer_id = '226'
90 0.0006 0.00057291984558105
SELECT category_id FROM products_categories WHERE product_id = '3168'
91 0.0006 0.00062990188598633
SELECT * FROM categories WHERE id = '27'
92 0.0059 0.0058951377868652
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.0007 0.00072598457336426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00039410591125488
SELECT id FROM categories WHERE parent_id = '27'
95 0.0050 0.0049669742584229
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.0006 0.00058889389038086
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.0006 0.00060915946960449
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.0005 0.00050997734069824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '3168' ORDER BY sortorder ASC
100 0.0006 0.00059890747070312
SELECT * FROM product_image_select WHERE product_id = '3168'
101 0.0005 0.00050187110900879
SELECT * FROM productcustomimages WHERE product_id = '3168'
102 0.0006 0.00059700012207031
SELECT * FROM productfeeds WHERE product_id = '3168' ORDER BY item_date DESC
103 0.0008 0.00077104568481445
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0017 0.0017299652099609
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3168' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00042891502380371
SELECT * FROM tags WHERE id = '58'
106 0.0020 0.0020310878753662
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0019 0.0018720626831055
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0019 0.0018830299377441
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' 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.0009 0.00087213516235352
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
110 0.0010 0.00095009803771973
SELECT * FROM productamazoncontent WHERE product_id = '3168'
111 0.0012 0.0012171268463135
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
112 0.0008 0.00082588195800781
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0007 0.00066089630126953
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0006 0.00062918663024902
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
115 0.0005 0.00047707557678223
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
116 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0007 0.00066089630126953
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.0102 0.010225057601929
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0014 0.0013768672943115
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0008 0.00081801414489746
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0006 0.00057291984558105
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
122 0.0007 0.00069117546081543
SELECT * FROM product_image_select WHERE product_id = '865'
123 0.0006 0.00059914588928223
SELECT * FROM productcustomimages WHERE product_id = '865'
124 0.0009 0.00091886520385742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
125 0.0009 0.00089597702026367
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.00071501731872559
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0006 0.00056910514831543
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
129 0.0007 0.00071811676025391
SELECT * FROM product_image_select WHERE product_id = '890'
130 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '890'
131 0.0011 0.0011429786682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
132 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00044608116149902
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00060892105102539
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
136 0.0008 0.00075912475585938
SELECT * FROM product_image_select WHERE product_id = '869'
137 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '869'
138 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
139 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00048589706420898
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0006 0.00059390068054199
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0010 0.0009918212890625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00042009353637695
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
150 0.0006 0.0005638599395752
SELECT * FROM product_image_select WHERE product_id = '858'
151 0.0004 0.00038290023803711
SELECT * FROM productcustomimages WHERE product_id = '858'
152 0.0010 0.001025915145874
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
153 0.0005 0.00051712989807129
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.0005500316619873
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00046920776367188
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00060009956359863
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
157 0.0006 0.0006248950958252
SELECT * FROM product_image_select WHERE product_id = '862'
158 0.0004 0.00038409233093262
SELECT * FROM productcustomimages WHERE product_id = '862'
159 0.0009 0.00086498260498047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
160 0.0004 0.00044798851013184
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.00040698051452637
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0004 0.0004279613494873
SELECT id,asin FROM products WHERE parent_id = 3168
164 0.0004 0.00041985511779785
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3168' ORDER BY timestamp DESC
165 0.0004 0.0004270076751709
SELECT category_id FROM products_categories WHERE product_id = '3168'
166 0.0005 0.00054502487182617
SELECT * FROM categories WHERE id = '27'
167 0.0047 0.0046849250793457
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.0011 0.0010960102081299
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0011 0.0010831356048584
SELECT id FROM categories WHERE parent_id = '27'
170 0.0038 0.003770112991333
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.0006 0.0005950927734375
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.0006 0.00057506561279297
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.0011 0.0010981559753418
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0011 0.0011229515075684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
175 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0005 0.0005030632019043
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
178 0.0004 0.0004429817199707
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
179 0.0008 0.00075197219848633
SELECT * FROM products WHERE id = '3168'
180 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0008 0.00078701972961426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
182 0.0004 0.00044703483581543
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00037384033203125
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00041604042053223
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
186 0.0005 0.00049686431884766
SELECT category_id FROM products_categories WHERE product_id = '3168' AND prod_type = 'amz'
187 0.0005 0.00047993659973145
SELECT parent_id FROM categories WHERE id = '27'
188 0.0007 0.00065708160400391
SELECT * FROM categories WHERE id = '27'
189 0.0065 0.0065140724182129
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.0005 0.00048089027404785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '27'
192 0.0051 0.0051040649414062
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.00065994262695312
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.0006 0.0006098747253418
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.0006 0.0006101131439209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0006 0.00062417984008789
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0007 0.00065398216247559
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.0003509521484375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0187 0.018684864044189
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.0009 0.0009310245513916
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.0010 0.00095105171203613
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.0007 0.00070309638977051
SELECT * FROM products WHERE id = 1626
203 0.0007 0.00065803527832031
SELECT * FROM products WHERE id = 4041
204 0.0006 0.00059080123901367
SELECT * FROM products WHERE id = 4312
205 0.0007 0.00070786476135254
SELECT * FROM products WHERE id = 777
206 0.0007 0.00070714950561523
SELECT * FROM products WHERE id = 3881
207 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = 4213
208 0.0007 0.0007178783416748
SELECT * FROM products WHERE id = '1626'
209 0.0008 0.00075197219848633
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0009 0.00091314315795898
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0006 0.00057792663574219
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0011 0.0010900497436523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0006 0.00060391426086426
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00050091743469238
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0024 0.0023810863494873
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0007 0.00065112113952637
SELECT * FROM products WHERE id = '4041'
217 0.0005 0.00053286552429199
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0007 0.00069689750671387
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0016 0.0016129016876221
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.00053811073303223
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00050878524780273
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0007 0.00065803527832031
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.00058078765869141
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0007 0.00070285797119141
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0004 0.00043511390686035
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0014 0.0014190673828125
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.00055909156799316
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.00054407119750977
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0007 0.00070691108703613
SELECT * FROM products WHERE id = '777'
233 0.0006 0.00055909156799316
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0007 0.00069379806518555
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0005 0.00045013427734375
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0017 0.0016880035400391
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.00061798095703125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0006 0.00064802169799805
SELECT * FROM products WHERE id = '3881'
241 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0005 0.00047206878662109
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0017 0.001737117767334
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.00056004524230957
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0007 0.00072598457336426
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0007 0.00066709518432617
SELECT * FROM products WHERE id = '4213'
249 0.0008 0.00082302093505859
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0007 0.00068807601928711
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0006 0.00055503845214844
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0016 0.0015640258789062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0008 0.00079989433288574
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0006 0.00060796737670898
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0007 0.00071001052856445
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0010 0.0010080337524414
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0081 0.008145809173584
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0021 0.0020670890808105
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0012 0.0011920928955078
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0009 0.00089192390441895
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.000762939453125
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'