0

Thés de la Pagode rooibos Vanille Amande Edition prestige 100gr

Price: €19,50
Product prices and availability are accurate as of 2022-06-26 15:21:19 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.
Availability: In Stock
En stock.
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.5417718887329 255 1.1819 0


No Amazon API Requests Made.


App Debug - Total Time 1.5417718887329 seconds

Number Time From Start Name Description
1 0.35418891906738 Initialise Initialise FSB Function
2 0.35795903205872 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39438486099243 Start of getCategoryListByGroup Function Before first category groups query
4 0.39487791061401 After initial query Before first category groups query
5 0.39487886428833 Get Category List for Group Before the call to getCategoryList function
6 0.39487981796265 Start of GetCategoryList function Start of the function
7 0.39488196372986 Before getting categories Query to get specific category list
8 0.39536595344543 After getting categories Query to get specific category list
9 0.39536595344543 Before getting category custom Before call to function getCategoryCustom
10 0.41190791130066 After getting category custom After call to function getCategoryCustom
11 0.41190886497498 Before getting category custom Before call to function getCategoryCustom
12 0.4230899810791 After getting category custom After call to function getCategoryCustom
13 0.42309188842773 Before getting category custom Before call to function getCategoryCustom
14 0.43003487586975 After getting category custom After call to function getCategoryCustom
15 0.43003582954407 Before getting category custom Before call to function getCategoryCustom
16 0.43461298942566 After getting category custom After call to function getCategoryCustom
17 0.43461298942566 Before getting category custom Before call to function getCategoryCustom
18 0.43957686424255 After getting category custom After call to function getCategoryCustom
19 0.43957781791687 Before getting category custom Before call to function getCategoryCustom
20 0.44465494155884 After getting category custom After call to function getCategoryCustom
21 0.44465684890747 End of GetCategoryList function End of the function
22 0.44466090202332 Get Category List for Group Before the call to getCategoryList function
23 0.44466185569763 Start of GetCategoryList function Start of the function
24 0.44466280937195 Before getting categories Query to get specific category list
25 0.44514203071594 End of getCategoryListByGroup Function Before return()
26 1.3404078483582 App Controller End End of the App controller (called before the controller of every page)
27 1.3408849239349 Product Start Start of the product info controller
28 1.3494968414307 Cache file not found Starting get product details
29 1.3859279155731 Related products Start getting related products if enabled
30 1.3859298229218 Related Products Start Before the related products are found
31 1.3859310150146 Related Products Keywords Before the related product keywords are found
32 1.3859348297119 Create Keyword List Function Start of function
33 1.385960817337 Create Keyword List Function After looping provided content - 27 keywords found
34 1.3866329193115 Create Keyword List Function After looping initial keyword list - 25 keywords remaining
35 1.386638879776 Create Keyword List Function After reducing keyword list
36 1.3866889476776 Create Keyword List Function After selecting by scoring keywords
37 1.3866918087006 Create Keyword List Function After final loop of keywords
38 1.3866930007935 Related Products Keywords After the related product keywords are found
39 1.4244220256805 Related Products End After the related products are found
40 1.4728808403015 Product End End of the product info controller (Product Info)
41 1.4737269878387 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4745450019836 Before Get Options Before the call to getOptions in the tpl class
43 1.5310928821564 After Get Options After the call to getOptions in the tpl class
44 1.531172990799 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5311949253082 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5346128940582 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5346148014069 Product Info: Before Template Display Before the template is displayed
48 1.5417559146881 Product Info: After Template Display After the template is displayed
49 1.5417640209198 Finalizing debug Before the debug is output to the page.
50 1.5417709350586 End of App This is the end of the app logging, final timestamp


Query Debug - 255 Database Queries. Total time 1.1819 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0011861324310303
SELECT parameter, value FROM parameters
2 0.0072 0.0071871280670166
SELECT * FROM `bad_bots`
3 0.0010 0.00096607208251953
SET time_zone = 'Europe/London'
4 0.0017 0.0016648769378662
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0019710063934326
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.219.209.76\";}'
6 0.0015 0.0015461444854736
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743714216'
7 0.0027 0.0027170181274414
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010769367218018
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0012 0.0012180805206299
SELECT id FROM pages WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr' LIMIT 1
10 0.0013 0.0012609958648682
SELECT id FROM products WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr' AND hidden = 0 LIMIT 1
11 0.0032 0.0032150745391846
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0326 0.032567977905273
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00043010711669922
SELECT * FROM pages WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr'
14 0.0005 0.00048995018005371
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00047612190246582
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0065 0.0064539909362793
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.0005 0.00046300888061523
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.0004 0.00044608116149902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043392181396484
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.006680965423584
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.0005 0.00053715705871582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0005 0.00052714347839355
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.0006 0.00055813789367676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040388107299805
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037569999694824
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.0005 0.00046205520629883
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.0004 0.00037503242492676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00036716461181641
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043389797210693
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.0005 0.00050687789916992
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.0005 0.00047588348388672
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.00049591064453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00037002563476562
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016200542449951
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.0004 0.00043582916259766
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.0003 0.00033402442932129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00040411949157715
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015890598297119
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.0007 0.00070691108703613
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.0009 0.0008540153503418
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.00048303604125977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00049304962158203
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00063800811767578
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.00049805641174316
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.0004 0.00041007995605469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00036787986755371
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00081300735473633
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.00048089027404785
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.0004 0.00044107437133789
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.00048708915710449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00042200088500977
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00060391426086426
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.0004 0.00043702125549316
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.00035691261291504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00076103210449219
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.00057196617126465
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.0005 0.00053691864013672
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.00053119659423828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00061607360839844
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075221061706543
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.00049591064453125
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.00049781799316406
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00048685073852539
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00093984603881836
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.00049781799316406
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.0004 0.00044703483581543
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.00050711631774902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043416023254395
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00047492980957031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0017 0.0016589164733887
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00057601928710938
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.0006718635559082
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.0005 0.00051188468933105
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0013530254364014
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.0009300708770752
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8872 0.88720488548279
SELECT * FROM ipgeocountries WHERE INET_ATON('18.219.209.76') >= INET_ATON(ip_start) AND INET_ATON('18.219.209.76') <= INET_ATON(ip_end)
78 0.0012 0.0011909008026123
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.0004880428314209
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00062394142150879
SELECT * FROM products WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr'
81 0.0005 0.00047016143798828
UPDATE products SET viewcount = viewcount + 1 WHERE id = 998
82 0.0006 0.00060892105102539
SELECT * FROM manufacturers WHERE id = '258'
83 0.0004 0.00043892860412598
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '258'
84 0.0004 0.00040888786315918
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '258' LIMIT 1
85 0.0006 0.00056982040405273
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '258' ORDER BY RAND() LIMIT 1
86 0.0004 0.00035691261291504
SELECT * FROM productimages WHERE product_id = '3584' ORDER BY sortorder ASC
87 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '258'
88 0.0004 0.00040388107299805
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '258'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00029897689819336
SELECT * FROM manufacturerimages WHERE manufacturer_id = '258'
90 0.0004 0.00038886070251465
SELECT category_id FROM products_categories WHERE product_id = '998'
91 0.0004 0.00042605400085449
SELECT * FROM categories WHERE id = '27'
92 0.0046 0.0046079158782959
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.0007469654083252
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0007 0.00065183639526367
SELECT id FROM categories WHERE parent_id = '27'
95 0.0048 0.0048160552978516
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.00089597702026367
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.00079512596130371
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.001291036605835
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0011 0.0011138916015625
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
100 0.0013 0.0012879371643066
SELECT * FROM product_image_select WHERE product_id = '998'
101 0.0012 0.0012338161468506
SELECT * FROM productcustomimages WHERE product_id = '998'
102 0.0006 0.0006110668182373
SELECT * FROM productfeeds WHERE product_id = '998' ORDER BY item_date DESC
103 0.0013 0.0013370513916016
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0012 0.001176118850708
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '998' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.0004119873046875
SELECT * FROM tags WHERE id = '1'
106 0.0023 0.0022871494293213
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.0019 0.0018861293792725
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.0017 0.0017168521881104
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.0006 0.00061917304992676
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0008 0.00083184242248535
SELECT * FROM productamazoncontent WHERE product_id = '998'
111 0.0013 0.0012540817260742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
112 0.0007 0.00067400932312012
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00041317939758301
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00052714347839355
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
116 0.0111 0.011133909225464
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117 0.0017 0.0016510486602783
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
118 0.0016 0.0016458034515381
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0009 0.00090909004211426
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
120 0.0008 0.00081515312194824
SELECT * FROM product_image_select WHERE product_id = '862'
121 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '862'
122 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
123 0.0006 0.0005650520324707
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0005 0.00050020217895508
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0004 0.00041389465332031
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
127 0.0007 0.00070309638977051
SELECT * FROM product_image_select WHERE product_id = '865'
128 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '865'
129 0.0008 0.00076913833618164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
130 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
134 0.0005 0.00051307678222656
SELECT * FROM product_image_select WHERE product_id = '4814'
135 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '4814'
136 0.0009 0.00089097023010254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
137 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.00037002563476562
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00036716461181641
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
141 0.0005 0.00054192543029785
SELECT * FROM product_image_select WHERE product_id = '858'
142 0.0004 0.0003662109375
SELECT * FROM productcustomimages WHERE product_id = '858'
143 0.0010 0.00097393989562988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
144 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.0003809928894043
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00038790702819824
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
148 0.0006 0.00055789947509766
SELECT * FROM product_image_select WHERE product_id = '878'
149 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '878'
150 0.0010 0.00098013877868652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
151 0.0004 0.00044584274291992
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00039100646972656
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
155 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '890'
156 0.0004 0.00037288665771484
SELECT * FROM productcustomimages WHERE product_id = '890'
157 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
158 0.0004 0.0004420280456543
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0004 0.00044703483581543
SELECT id,asin FROM products WHERE parent_id = 998
162 0.0004 0.00042080879211426
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '998' ORDER BY timestamp DESC
163 0.0004 0.0003809928894043
SELECT category_id FROM products_categories WHERE product_id = '998'
164 0.0005 0.00048208236694336
SELECT * FROM categories WHERE id = '27'
165 0.0038 0.0038180351257324
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
166 0.0007 0.00065898895263672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0007 0.00070786476135254
SELECT id FROM categories WHERE parent_id = '27'
168 0.0111 0.01108193397522
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 
169 0.0012 0.0012211799621582
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 
170 0.0014 0.00136399269104
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
171 0.0008 0.00084590911865234
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0021 0.0020718574523926
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
173 0.0008 0.00075101852416992
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0006 0.00057196617126465
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0008 0.00084900856018066
SELECT * FROM products WHERE id = '998'
176 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0017 0.0016541481018066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
178 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0006 0.00062298774719238
SELECT category_id FROM products_categories WHERE product_id = '998' AND prod_type = 'amz'
181 0.0005 0.00050997734069824
SELECT parent_id FROM categories WHERE id = '27'
182 0.0004 0.0004270076751709
SELECT * FROM categories WHERE id = '27'
183 0.0068 0.0067870616912842
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
184 0.0018 0.0017800331115723
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
185 0.0017 0.0016889572143555
SELECT id FROM categories WHERE parent_id = '27'
186 0.0054 0.0054359436035156
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 
187 0.0007 0.00074887275695801
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 
188 0.0008 0.00078797340393066
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
189 0.0005 0.00054693222045898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0006 0.0005500316619873
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
191 0.0005 0.00046205520629883
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0003 0.0003211498260498
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0150 0.015000820159912
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
194 0.0006 0.00064682960510254
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
195 0.0006 0.00061798095703125
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
196 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = 1626
197 0.0004 0.00042414665222168
SELECT * FROM products WHERE id = 4041
198 0.0004 0.00035405158996582
SELECT * FROM products WHERE id = 4312
199 0.0004 0.00038480758666992
SELECT * FROM products WHERE id = 777
200 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = 3881
201 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = 4213
202 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = '1626'
203 0.0005 0.00052690505981445
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
204 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '1626'
205 0.0004 0.00043416023254395
SELECT * FROM productcustomimages WHERE product_id = '1626'
206 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
207 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00052618980407715
SELECT * FROM products WHERE id = '4041'
211 0.0005 0.00048708915710449
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
212 0.0007 0.00069999694824219
SELECT * FROM product_image_select WHERE product_id = '4041'
213 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '4041'
214 0.0011 0.0011329650878906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
215 0.0005 0.00045108795166016
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0006 0.00061917304992676
SELECT * FROM products WHERE id = '4312'
219 0.0005 0.00053620338439941
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
220 0.0007 0.0007479190826416
SELECT * FROM product_image_select WHERE product_id = '4312'
221 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '4312'
222 0.0016 0.0015599727630615
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
223 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = '777'
227 0.0009 0.00094318389892578
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0004 0.00044107437133789
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0015 0.0014770030975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0006 0.00056314468383789
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0007 0.00073385238647461
SELECT * FROM products WHERE id = '3881'
235 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
236 0.0008 0.00082182884216309
SELECT * FROM product_image_select WHERE product_id = '3881'
237 0.0005 0.00052094459533691
SELECT * FROM productcustomimages WHERE product_id = '3881'
238 0.0015 0.0014770030975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
239 0.0005 0.00054788589477539
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0004 0.00042510032653809
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = '4213'
243 0.0006 0.00056791305541992
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
244 0.0007 0.00070095062255859
SELECT * FROM product_image_select WHERE product_id = '4213'
245 0.0005 0.00047111511230469
SELECT * FROM productcustomimages WHERE product_id = '4213'
246 0.0016 0.0016269683837891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
247 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0005 0.00048494338989258
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0009 0.00090193748474121
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
251 0.0008 0.00084209442138672
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
252 0.0019 0.001884937286377
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
253 0.0008 0.00076007843017578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
254 0.0006 0.00056099891662598
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0006 0.00057888031005859
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'