0

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

Price: €9,90
Product prices and availability are accurate as of 2022-06-20 03:56: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.4247868061066 261 0.8351 0


No Amazon API Requests Made.


App Debug - Total Time 1.4247868061066 seconds

Number Time From Start Name Description
1 0.55435180664062 Initialise Initialise FSB Function
2 0.55632901191711 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58224296569824 Start of getCategoryListByGroup Function Before first category groups query
4 0.58271884918213 After initial query Before first category groups query
5 0.58272099494934 Get Category List for Group Before the call to getCategoryList function
6 0.58272480964661 Start of GetCategoryList function Start of the function
7 0.58272981643677 Before getting categories Query to get specific category list
8 0.58345580101013 After getting categories Query to get specific category list
9 0.58345794677734 Before getting category custom Before call to function getCategoryCustom
10 0.60001683235168 After getting category custom After call to function getCategoryCustom
11 0.60002183914185 Before getting category custom Before call to function getCategoryCustom
12 0.61355400085449 After getting category custom After call to function getCategoryCustom
13 0.61355996131897 Before getting category custom Before call to function getCategoryCustom
14 0.61980390548706 After getting category custom After call to function getCategoryCustom
15 0.61980795860291 Before getting category custom Before call to function getCategoryCustom
16 0.62428092956543 After getting category custom After call to function getCategoryCustom
17 0.62428593635559 Before getting category custom Before call to function getCategoryCustom
18 0.6292359828949 After getting category custom After call to function getCategoryCustom
19 0.62924098968506 Before getting category custom Before call to function getCategoryCustom
20 0.63418292999268 After getting category custom After call to function getCategoryCustom
21 0.63418698310852 End of GetCategoryList function End of the function
22 0.63419485092163 Get Category List for Group Before the call to getCategoryList function
23 0.63419699668884 Start of GetCategoryList function Start of the function
24 0.63419985771179 Before getting categories Query to get specific category list
25 0.63479399681091 End of getCategoryListByGroup Function Before return()
26 1.1862678527832 App Controller End End of the App controller (called before the controller of every page)
27 1.1867280006409 Product Start Start of the product info controller
28 1.2136487960815 Cache file not found Starting get product details
29 1.2492418289185 Related products Start getting related products if enabled
30 1.2492439746857 Related Products Start Before the related products are found
31 1.24924492836 Related Products Keywords Before the related product keywords are found
32 1.2492489814758 Create Keyword List Function Start of function
33 1.2493278980255 Create Keyword List Function After looping provided content - 27 keywords found
34 1.2503719329834 Create Keyword List Function After looping initial keyword list - 22 keywords remaining
35 1.2503788471222 Create Keyword List Function After reducing keyword list
36 1.2504408359528 Create Keyword List Function After selecting by scoring keywords
37 1.2504458427429 Create Keyword List Function After final loop of keywords
38 1.2504479885101 Related Products Keywords After the related product keywords are found
39 1.2999539375305 Related Products End After the related products are found
40 1.3397879600525 Product End End of the product info controller (Product Info)
41 1.3408818244934 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3417918682098 Before Get Options Before the call to getOptions in the tpl class
43 1.4041018486023 After Get Options After the call to getOptions in the tpl class
44 1.4042539596558 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4042840003967 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.409010887146 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4090149402618 Product Info: Before Template Display Before the template is displayed
48 1.4247629642487 Product Info: After Template Display After the template is displayed
49 1.4247748851776 Finalizing debug Before the debug is output to the page.
50 1.4247848987579 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.8351 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0020549297332764
SELECT parameter, value FROM parameters
2 0.0019 0.0018870830535889
SELECT * FROM `bad_bots`
3 0.0003 0.00030612945556641
SET time_zone = 'Europe/London'
4 0.0005 0.00053000450134277
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.0006868839263916
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.128.197.193\";}'
6 0.0006 0.00056195259094238
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722078455'
7 0.0008 0.00083208084106445
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040388107299805
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00049901008605957
SELECT id FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr' LIMIT 1
10 0.0006 0.00057601928710938
SELECT id FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr' AND hidden = 0 LIMIT 1
11 0.0015 0.0015239715576172
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0231 0.02311110496521
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00042605400085449
SELECT * FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr'
14 0.0005 0.00046014785766602
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00070095062255859
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0064 0.006356954574585
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.0007 0.00069117546081543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0006 0.00063204765319824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00051999092102051
SELECT id FROM categories WHERE parent_id = '26'
20 0.0061 0.006134033203125
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.00054097175598145
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.0006 0.0006110668182373
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.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040388107299805
SELECT * FROM categorygroups WHERE id = '1'
25 0.0051 0.0050749778747559
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.00051116943359375
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.00046610832214355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046420097351074
SELECT id FROM categories WHERE parent_id = '27'
29 0.0045 0.0045359134674072
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.0005340576171875
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.0009 0.00093889236450195
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.00046706199645996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00039219856262207
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016257762908936
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.0005 0.00048398971557617
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.0004 0.00037908554077148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0013968944549561
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.0005 0.00046205520629883
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.0005 0.00051593780517578
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.00047898292541504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00037479400634766
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00050091743469238
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.00047111511230469
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.00038981437683105
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00041508674621582
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00072216987609863
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.00046706199645996
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.0005 0.00050187110900879
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.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00039410591125488
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00053191184997559
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.00051307678222656
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.00046801567077637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.0004570484161377
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00081491470336914
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.00060486793518066
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.00059390068054199
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.0004 0.00043416023254395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.0003821849822998
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.0005950927734375
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.0004 0.00043296813964844
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.0004 0.00036001205444336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00047898292541504
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00085902214050293
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.00055599212646484
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0006 0.00057601928710938
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.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00058102607727051
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0019 0.0018990039825439
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00057792663574219
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00051712989807129
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.00041890144348145
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010581016540527
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.001007080078125
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5430 0.54302883148193
SELECT * FROM ipgeocountries WHERE INET_ATON('3.128.197.193') >= INET_ATON(ip_start) AND INET_ATON('3.128.197.193') <= INET_ATON(ip_end)
78 0.0012 0.0012149810791016
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00060892105102539
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00081992149353027
SELECT * FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr'
81 0.0138 0.013785839080811
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3664
82 0.0012 0.0011920928955078
SELECT * FROM manufacturers WHERE id = '538'
83 0.0007 0.00066113471984863
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
84 0.0009 0.00089907646179199
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '538' LIMIT 1
85 0.0007 0.00071191787719727
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '538' ORDER BY RAND() LIMIT 1
86 0.0004 0.00043010711669922
SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
87 0.0022 0.0021669864654541
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
88 0.0004 0.00044798851013184
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '538'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0011 0.0011141300201416
SELECT * FROM manufacturerimages WHERE manufacturer_id = '538'
90 0.0007 0.00072097778320312
SELECT category_id FROM products_categories WHERE product_id = '3664'
91 0.0006 0.00057697296142578
SELECT * FROM categories WHERE id = '27'
92 0.0041 0.0040550231933594
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.0006 0.00061988830566406
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0016 0.0016050338745117
SELECT id FROM categories WHERE parent_id = '27'
95 0.0055 0.005497932434082
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.00064897537231445
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.00063800811767578
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.00048589706420898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00045013427734375
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
100 0.0007 0.00066280364990234
SELECT * FROM product_image_select WHERE product_id = '3664'
101 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '3664'
102 0.0004 0.00043296813964844
SELECT * FROM productfeeds WHERE product_id = '3664' ORDER BY item_date DESC
103 0.0007 0.0006868839263916
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00067710876464844
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3664' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00035691261291504
SELECT * FROM tags WHERE id = '15'
106 0.0012 0.0012111663818359
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0012 0.001194953918457
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0011 0.0011098384857178
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' 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.00067305564880371
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0006 0.00059103965759277
SELECT * FROM productamazoncontent WHERE product_id = '3664'
111 0.0010 0.00097393989562988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
112 0.0005 0.00054502487182617
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
115 0.0005 0.00047707557678223
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
116 0.0005 0.0005040168762207
SELECT value FROM productattributes WHERE product_id = '3664' 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.0167 0.016738176345825
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0010 0.0009758472442627
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0007 0.00073719024658203
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0006 0.00059795379638672
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
122 0.0007 0.00073409080505371
SELECT * FROM product_image_select WHERE product_id = '865'
123 0.0004 0.00043487548828125
SELECT * FROM productcustomimages WHERE product_id = '865'
124 0.0013 0.0013449192047119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
125 0.0006 0.00060796737670898
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.0007328987121582
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0006 0.00060009956359863
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0010 0.00096392631530762
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
129 0.0009 0.0008699893951416
SELECT * FROM product_image_select WHERE product_id = '862'
130 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '862'
131 0.0009 0.00093603134155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
132 0.0006 0.00064492225646973
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00038790702819824
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00049996376037598
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
136 0.0006 0.00061988830566406
SELECT * FROM product_image_select WHERE product_id = '890'
137 0.0007 0.00065302848815918
SELECT * FROM productcustomimages WHERE product_id = '890'
138 0.0013 0.0012819766998291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
139 0.0007 0.00072789192199707
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00041389465332031
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00050210952758789
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.00070095062255859
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0007 0.00069284439086914
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0004 0.00037288665771484
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0012 0.0012319087982178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0009 0.00093793869018555
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0006 0.00056099891662598
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0008 0.0008389949798584
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
150 0.0008 0.00082111358642578
SELECT * FROM product_image_select WHERE product_id = '858'
151 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '858'
152 0.0013 0.0012609958648682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
153 0.0006 0.00061392784118652
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00043678283691406
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0006 0.00055098533630371
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0007 0.00069808959960938
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
157 0.0008 0.00079011917114258
SELECT * FROM product_image_select WHERE product_id = '869'
158 0.0007 0.00073099136352539
SELECT * FROM productcustomimages WHERE product_id = '869'
159 0.0013 0.0013189315795898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
160 0.0006 0.00059890747070312
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00047183036804199
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00064492225646973
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.0006251335144043
SELECT id,asin FROM products WHERE parent_id = 3664
164 0.0005 0.00054597854614258
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3664' ORDER BY timestamp DESC
165 0.0006 0.0005500316619873
SELECT category_id FROM products_categories WHERE product_id = '3664'
166 0.0007 0.00066184997558594
SELECT * FROM categories WHERE id = '27'
167 0.0041 0.0040619373321533
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.0005 0.00046181678771973
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0003 0.00030899047851562
SELECT id FROM categories WHERE parent_id = '27'
170 0.0039 0.0039279460906982
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.00057005882263184
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.0005 0.00052404403686523
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.0005 0.00047111511230469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0008 0.00083017349243164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
175 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00035786628723145
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0003 0.00034213066101074
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
178 0.0004 0.0003659725189209
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
179 0.0007 0.00073099136352539
SELECT * FROM products WHERE id = '3664'
180 0.0006 0.00059604644775391
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0011 0.0011270046234131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
182 0.0004 0.00043892860412598
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0007 0.00074911117553711
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
185 0.0005 0.00051212310791016
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
186 0.0006 0.00058102607727051
SELECT category_id FROM products_categories WHERE product_id = '3664' AND prod_type = 'amz'
187 0.0010 0.00095987319946289
SELECT parent_id FROM categories WHERE id = '27'
188 0.0031 0.0031118392944336
SELECT * FROM categories WHERE id = '27'
189 0.0050 0.0050199031829834
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.0008 0.00081110000610352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0004 0.0003809928894043
SELECT id FROM categories WHERE parent_id = '27'
192 0.0040 0.0040469169616699
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.0009 0.00087690353393555
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.0033 0.0032849311828613
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.00064587593078613
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0006 0.00063681602478027
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0005 0.00045299530029297
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00037288665771484
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0147 0.014718055725098
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.0011 0.0010740756988525
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.0008 0.00078892707824707
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.0007171630859375
SELECT * FROM products WHERE id = 1626
203 0.0007 0.00066089630126953
SELECT * FROM products WHERE id = 4041
204 0.0007 0.00069808959960938
SELECT * FROM products WHERE id = 4312
205 0.0007 0.00066614151000977
SELECT * FROM products WHERE id = 777
206 0.0011 0.0011270046234131
SELECT * FROM products WHERE id = 3881
207 0.0009 0.00089502334594727
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00062704086303711
SELECT * FROM products WHERE id = '1626'
209 0.0008 0.00076603889465332
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0011 0.0010709762573242
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0005 0.0004730224609375
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0010 0.0010340213775635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00051212310791016
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0006 0.0006098747253418
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0007 0.0007479190826416
SELECT * FROM products WHERE id = '4041'
217 0.0007 0.00066995620727539
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0008 0.00084900856018066
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.00051093101501465
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0017 0.0017459392547607
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0006 0.00063514709472656
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00053501129150391
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0006 0.00059914588928223
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0007 0.000701904296875
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0007 0.0007319450378418
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0007 0.00070786476135254
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0012 0.0012149810791016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0005 0.00053906440734863
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00043201446533203
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00056815147399902
SELECT * FROM products WHERE id = '777'
233 0.0005 0.00051307678222656
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0024 0.0023729801177979
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0010 0.0010349750518799
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0011 0.0011429786682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0007 0.00065898895263672
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00048685073852539
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0006 0.0006411075592041
SELECT * FROM products WHERE id = '3881'
241 0.0008 0.00077414512634277
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0011 0.0011019706726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0005 0.00053715705871582
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0007 0.00069499015808105
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0006 0.00060105323791504
SELECT * FROM products WHERE id = '4213'
249 0.0007 0.00071907043457031
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0006 0.00055289268493652
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0004 0.00041580200195312
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0011 0.0010800361633301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0005 0.00047683715820312
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0008 0.00083184242248535
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0009 0.00087404251098633
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0015 0.0014610290527344
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0008 0.0008089542388916
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0007 0.00065016746520996
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0007 0.00068306922912598
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'