0

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

Price: €6,90
Product prices and availability are accurate as of 2022-06-24 08:48:08 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.5399980545044 261 0.8515 0


No Amazon API Requests Made.


App Debug - Total Time 1.5399980545044 seconds

Number Time From Start Name Description
1 0.64306807518005 Initialise Initialise FSB Function
2 0.64640998840332 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68507313728333 Start of getCategoryListByGroup Function Before first category groups query
4 0.68575811386108 After initial query Before first category groups query
5 0.68576002120972 Get Category List for Group Before the call to getCategoryList function
6 0.68576407432556 Start of GetCategoryList function Start of the function
7 0.68576717376709 Before getting categories Query to get specific category list
8 0.68662118911743 After getting categories Query to get specific category list
9 0.68662214279175 Before getting category custom Before call to function getCategoryCustom
10 0.70907020568848 After getting category custom After call to function getCategoryCustom
11 0.70907402038574 Before getting category custom Before call to function getCategoryCustom
12 0.72093605995178 After getting category custom After call to function getCategoryCustom
13 0.72093820571899 Before getting category custom Before call to function getCategoryCustom
14 0.73051714897156 After getting category custom After call to function getCategoryCustom
15 0.73051905632019 Before getting category custom Before call to function getCategoryCustom
16 0.73583602905273 After getting category custom After call to function getCategoryCustom
17 0.73583817481995 Before getting category custom Before call to function getCategoryCustom
18 0.7406370639801 After getting category custom After call to function getCategoryCustom
19 0.74063920974731 Before getting category custom Before call to function getCategoryCustom
20 0.74566221237183 After getting category custom After call to function getCategoryCustom
21 0.74566411972046 End of GetCategoryList function End of the function
22 0.74566912651062 Get Category List for Group Before the call to getCategoryList function
23 0.74567198753357 Start of GetCategoryList function Start of the function
24 0.74567413330078 Before getting categories Query to get specific category list
25 0.74620318412781 End of getCategoryListByGroup Function Before return()
26 1.2670760154724 App Controller End End of the App controller (called before the controller of every page)
27 1.2675621509552 Product Start Start of the product info controller
28 1.2862920761108 Cache file not found Starting get product details
29 1.3215591907501 Related products Start getting related products if enabled
30 1.3215610980988 Related Products Start Before the related products are found
31 1.3215620517731 Related Products Keywords Before the related product keywords are found
32 1.3215661048889 Create Keyword List Function Start of function
33 1.32160115242 Create Keyword List Function After looping provided content - 27 keywords found
34 1.3226420879364 Create Keyword List Function After looping initial keyword list - 22 keywords remaining
35 1.3226490020752 Create Keyword List Function After reducing keyword list
36 1.322704076767 Create Keyword List Function After selecting by scoring keywords
37 1.3227071762085 Create Keyword List Function After final loop of keywords
38 1.3227090835571 Related Products Keywords After the related product keywords are found
39 1.3840041160583 Related Products End After the related products are found
40 1.4221169948578 Product End End of the product info controller (Product Info)
41 1.4231650829315 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4242219924927 Before Get Options Before the call to getOptions in the tpl class
43 1.5098631381989 After Get Options After the call to getOptions in the tpl class
44 1.509968996048 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5099971294403 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.514533996582 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5145380496979 Product Info: Before Template Display Before the template is displayed
48 1.5399692058563 Product Info: After Template Display After the template is displayed
49 1.5399830341339 Finalizing debug Before the debug is output to the page.
50 1.5399971008301 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.8515 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0012459754943848
SELECT parameter, value FROM parameters
2 0.0025 0.0025420188903809
SELECT * FROM `bad_bots`
3 0.0006 0.00060296058654785
SET time_zone = 'Europe/London'
4 0.0011 0.0011439323425293
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011260509490967
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.145.46.4\";}'
6 0.0011 0.0011401176452637
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722060668'
7 0.0017 0.0017261505126953
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00069403648376465
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010430812835693
SELECT id FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr' LIMIT 1
10 0.0013 0.0012578964233398
SELECT id FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr' AND hidden = 0 LIMIT 1
11 0.0038 0.0038001537322998
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0339 0.033866882324219
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00055599212646484
SELECT * FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr'
14 0.0007 0.00067400932312012
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00083518028259277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0060 0.0060460567474365
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.00073909759521484
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.00054001808166504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053501129150391
SELECT id FROM categories WHERE parent_id = '26'
20 0.0111 0.011121034622192
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.0012 0.0011880397796631
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.0011 0.001115083694458
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.00056314468383789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00046992301940918
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037920475006104
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.00058507919311523
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.00047802925109863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046014785766602
SELECT id FROM categories WHERE parent_id = '27'
29 0.0041 0.0040600299835205
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0006 0.00063896179199219
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.00061821937561035
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.00053119659423828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0006 0.00059390068054199
SELECT * FROM categorygroups WHERE id = '1'
34 0.0021 0.0020790100097656
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.00066494941711426
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.00054287910461426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0009 0.00086402893066406
SELECT id FROM categories WHERE parent_id = '28'
38 0.0030 0.0030109882354736
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.00063419342041016
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.0006 0.00061297416687012
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0006 0.00055313110351562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00049710273742676
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.0008389949798584
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.0005347728729248
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.00042986869812012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043296813964844
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00078511238098145
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.00060701370239258
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.00057387351989746
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.00053000450134277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00058102607727051
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.00048017501831055
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.0004270076751709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00045514106750488
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00070500373840332
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.0005 0.00050592422485352
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.00052523612976074
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.00051021575927734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.0004730224609375
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00077104568481445
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.0005190372467041
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.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00072503089904785
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.00050902366638184
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.00056910514831543
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.00052404403686523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.0004570484161377
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.0005190372467041
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0026 0.0025520324707031
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0013 0.0013267993927002
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00061416625976562
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.00043201446533203
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010759830474854
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0011601448059082
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5110 0.51100492477417
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.46.4') >= INET_ATON(ip_start) AND INET_ATON('3.145.46.4') <= INET_ATON(ip_end)
78 0.0012 0.0011589527130127
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00052189826965332
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00081801414489746
SELECT * FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-15-x-2gr'
81 0.0005 0.00045490264892578
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3665
82 0.0008 0.00075221061706543
SELECT * FROM manufacturers WHERE id = '538'
83 0.0007 0.00067806243896484
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
84 0.0006 0.00058078765869141
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '538' LIMIT 1
85 0.0007 0.00074315071105957
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.0006 0.00057816505432129
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
87 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
88 0.0006 0.0006098747253418
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.0004 0.00044012069702148
SELECT * FROM manufacturerimages WHERE manufacturer_id = '538'
90 0.0006 0.00061893463134766
SELECT category_id FROM products_categories WHERE product_id = '3665'
91 0.0007 0.00069808959960938
SELECT * FROM categories WHERE id = '27'
92 0.0068 0.0067620277404785
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.00059103965759277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00043821334838867
SELECT id FROM categories WHERE parent_id = '27'
95 0.0056 0.0056281089782715
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0008 0.00075697898864746
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.00063705444335938
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.0006 0.00055503845214844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00054097175598145
SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
100 0.0007 0.00065517425537109
SELECT * FROM product_image_select WHERE product_id = '3665'
101 0.0005 0.00049710273742676
SELECT * FROM productcustomimages WHERE product_id = '3665'
102 0.0005 0.00049805641174316
SELECT * FROM productfeeds WHERE product_id = '3665' ORDER BY item_date DESC
103 0.0008 0.00077605247497559
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00072717666625977
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3665' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00041985511779785
SELECT * FROM tags WHERE id = '15'
106 0.0012 0.0011610984802246
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.0010 0.0010409355163574
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.0012 0.0011589527130127
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.00066113471984863
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0005 0.00051617622375488
SELECT * FROM productamazoncontent WHERE product_id = '3665'
111 0.0011 0.001068115234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
112 0.0008 0.00084686279296875
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00049996376037598
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
116 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0006 0.0005958080291748
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.0255 0.025490999221802
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 3665 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0011 0.0010759830474854
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 3665 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0008 0.00082993507385254
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 3665 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0008 0.00081586837768555
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
122 0.0008 0.00081777572631836
SELECT * FROM product_image_select WHERE product_id = '865'
123 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '865'
124 0.0010 0.001011848449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
125 0.0007 0.00067591667175293
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.0006568431854248
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0007 0.00071597099304199
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0008 0.00075411796569824
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
129 0.0009 0.00087809562683105
SELECT * FROM product_image_select WHERE product_id = '890'
130 0.0006 0.00057220458984375
SELECT * FROM productcustomimages WHERE product_id = '890'
131 0.0014 0.001446008682251
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
132 0.0007 0.00074410438537598
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0007 0.00073599815368652
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0009 0.00090789794921875
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0010 0.00095295906066895
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
136 0.0009 0.00089097023010254
SELECT * FROM product_image_select WHERE product_id = '858'
137 0.0005 0.00054597854614258
SELECT * FROM productcustomimages WHERE product_id = '858'
138 0.0021 0.0020790100097656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
139 0.0007 0.00073409080505371
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.00057291984558105
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0006 0.00063014030456543
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0009 0.00092315673828125
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0011 0.001101016998291
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0006 0.00060582160949707
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0015 0.0015499591827393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0007 0.00072407722473145
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0006 0.00056314468383789
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0007 0.00068497657775879
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0007 0.00070786476135254
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
150 0.0008 0.00079989433288574
SELECT * FROM product_image_select WHERE product_id = '869'
151 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '869'
152 0.0010 0.0010230541229248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
153 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0005 0.00047612190246582
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00049281120300293
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0007 0.00072407722473145
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
157 0.0007 0.00070810317993164
SELECT * FROM product_image_select WHERE product_id = '862'
158 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '862'
159 0.0010 0.00096607208251953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
160 0.0006 0.0005948543548584
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00055813789367676
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0005 0.00052309036254883
SELECT id,asin FROM products WHERE parent_id = 3665
164 0.0007 0.00068807601928711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3665' ORDER BY timestamp DESC
165 0.0006 0.00058197975158691
SELECT category_id FROM products_categories WHERE product_id = '3665'
166 0.0005 0.00053691864013672
SELECT * FROM categories WHERE id = '27'
167 0.0056 0.0055789947509766
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
168 0.0006 0.00064301490783691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0004 0.00039482116699219
SELECT id FROM categories WHERE parent_id = '27'
170 0.0045 0.0045051574707031
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.0015 0.0014679431915283
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.0012 0.0012340545654297
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.0007 0.00068998336791992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0013 0.0012869834899902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
175 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00045895576477051
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
179 0.0009 0.00085282325744629
SELECT * FROM products WHERE id = '3665'
180 0.0006 0.00061297416687012
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0007 0.00071215629577637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
182 0.0005 0.00051307678222656
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0006 0.00055480003356934
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
185 0.0005 0.00048303604125977
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
186 0.0005 0.00053596496582031
SELECT category_id FROM products_categories WHERE product_id = '3665' AND prod_type = 'amz'
187 0.0005 0.00052809715270996
SELECT parent_id FROM categories WHERE id = '27'
188 0.0004 0.00038003921508789
SELECT * FROM categories WHERE id = '27'
189 0.0042 0.0041749477386475
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.00051593780517578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0005 0.00051307678222656
SELECT id FROM categories WHERE parent_id = '27'
192 0.0047 0.0046679973602295
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.00070405006408691
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
194 0.0007 0.00070095062255859
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
195 0.0007 0.00069093704223633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0007 0.00067400932312012
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0006 0.00055789947509766
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.0004429817199707
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0262 0.026172876358032
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.00090718269348145
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
201 0.0006 0.00063514709472656
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
202 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = 4041
204 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = 4312
205 0.0006 0.00055098533630371
SELECT * FROM products WHERE id = 777
206 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 3881
207 0.0006 0.00063109397888184
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.0005338191986084
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0007 0.00071501731872559
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0010 0.00096297264099121
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.00063800811767578
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0005 0.00050616264343262
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0007 0.0006558895111084
SELECT * FROM products WHERE id = '4041'
217 0.0006 0.00058889389038086
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0007 0.0006871223449707
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.00049090385437012
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0011 0.0011439323425293
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.00056910514831543
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0006 0.00055122375488281
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00050020217895508
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = '4312'
225 0.0014 0.0013670921325684
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0018 0.001823902130127
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0011 0.0010659694671631
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0039 0.00394606590271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0013 0.0012640953063965
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0018 0.001816987991333
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0011 0.0010590553283691
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0010 0.0010139942169189
SELECT * FROM products WHERE id = '777'
233 0.0008 0.00082683563232422
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0010 0.0010440349578857
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0006 0.0006260871887207
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0019 0.001896858215332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0008 0.00077700614929199
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0007 0.00069499015808105
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0007 0.00072813034057617
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0007 0.00074410438537598
SELECT * FROM products WHERE id = '3881'
241 0.0008 0.00077486038208008
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0009 0.0009000301361084
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0006 0.00058603286743164
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0022 0.0021698474884033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0008 0.00081110000610352
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0007 0.00066208839416504
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0007 0.0006709098815918
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0008 0.0008091926574707
SELECT * FROM products WHERE id = '4213'
249 0.0008 0.00077700614929199
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0009 0.00093889236450195
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0006 0.00059294700622559
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0016 0.0016140937805176
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.0007929801940918
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0006 0.00056719779968262
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0006 0.00062704086303711
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0026 0.0026412010192871
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0014 0.00142502784729
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0021 0.0021309852600098
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0010 0.00095510482788086
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0008 0.00081086158752441
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0010 0.0010018348693848
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'