0

Alter Eco Thé Blanc Rooibos Épices Bio et Équitable 20 Infusettes

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-17 22:55:13 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

120 Infusettes

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.7829959392548 267 0.9728 0


No Amazon API Requests Made.


App Debug - Total Time 1.7829959392548 seconds

Number Time From Start Name Description
1 0.75133395195007 Initialise Initialise FSB Function
2 0.76287698745728 App Controller Start Start of the App controller (called before the controller of every page)
3 0.79520511627197 Start of getCategoryListByGroup Function Before first category groups query
4 0.79726696014404 After initial query Before first category groups query
5 0.79727005958557 Get Category List for Group Before the call to getCategoryList function
6 0.79727411270142 Start of GetCategoryList function Start of the function
7 0.79727911949158 Before getting categories Query to get specific category list
8 0.79919695854187 After getting categories Query to get specific category list
9 0.79919910430908 Before getting category custom Before call to function getCategoryCustom
10 0.82623505592346 After getting category custom After call to function getCategoryCustom
11 0.82623910903931 Before getting category custom Before call to function getCategoryCustom
12 0.8390429019928 After getting category custom After call to function getCategoryCustom
13 0.83904600143433 Before getting category custom Before call to function getCategoryCustom
14 0.84686994552612 After getting category custom After call to function getCategoryCustom
15 0.84687304496765 Before getting category custom Before call to function getCategoryCustom
16 0.85451197624207 After getting category custom After call to function getCategoryCustom
17 0.85451507568359 Before getting category custom Before call to function getCategoryCustom
18 0.86565899848938 After getting category custom After call to function getCategoryCustom
19 0.86566305160522 Before getting category custom Before call to function getCategoryCustom
20 0.87362909317017 After getting category custom After call to function getCategoryCustom
21 0.87363195419312 End of GetCategoryList function End of the function
22 0.87363910675049 Get Category List for Group Before the call to getCategoryList function
23 0.87364196777344 Start of GetCategoryList function Start of the function
24 0.87364602088928 Before getting categories Query to get specific category list
25 0.87425398826599 End of getCategoryListByGroup Function Before return()
26 1.4871411323547 App Controller End End of the App controller (called before the controller of every page)
27 1.4881551265717 Product Start Start of the product info controller
28 1.5057580471039 Cache file not found Starting get product details
29 1.5712029933929 Related products Start getting related products if enabled
30 1.5712060928345 Related Products Start Before the related products are found
31 1.5712080001831 Related Products Keywords Before the related product keywords are found
32 1.5712149143219 Create Keyword List Function Start of function
33 1.5713601112366 Create Keyword List Function After looping provided content - 30 keywords found
34 1.5734300613403 Create Keyword List Function After looping initial keyword list - 26 keywords remaining
35 1.5734429359436 Create Keyword List Function After reducing keyword list
36 1.5736329555511 Create Keyword List Function After selecting by scoring keywords
37 1.5736401081085 Create Keyword List Function After final loop of keywords
38 1.5736439228058 Related Products Keywords After the related product keywords are found
39 1.6137609481812 Related Products End After the related products are found
40 1.647341966629 Product End End of the product info controller (Product Info)
41 1.6501770019531 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.6522700786591 Before Get Options Before the call to getOptions in the tpl class
43 1.7228090763092 After Get Options After the call to getOptions in the tpl class
44 1.7229919433594 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.723030090332 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.7435400485992 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.7435479164124 Product Info: Before Template Display Before the template is displayed
48 1.7829580307007 Product Info: After Template Display After the template is displayed
49 1.7829740047455 Finalizing debug Before the debug is output to the page.
50 1.7829949855804 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 0.9728 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0053 0.0053379535675049
SELECT parameter, value FROM parameters
2 0.0085 0.0084941387176514
SELECT * FROM `bad_bots`
3 0.0004 0.00040006637573242
SET time_zone = 'Europe/London'
4 0.0041 0.0040671825408936
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0068 0.0067670345306396
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.12.148.195\";}'
6 0.0030 0.0029699802398682
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734789183'
7 0.0056 0.0056040287017822
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00087189674377441
UPDATE autorun SET lastrun = '2024-12-21 13:53:03' WHERE id = '16'
9 0.0013 0.0013358592987061
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0037 0.0036640167236328
SELECT id FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-Epices-bio-et-Equitable-20-infusettes' LIMIT 1
11 0.0039 0.0038938522338867
SELECT id FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-Epices-bio-et-Equitable-20-infusettes' AND hidden = 0 LIMIT 1
12 0.0049 0.0048789978027344
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0261 0.026114940643311
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00070309638977051
SELECT * FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-Epices-bio-et-Equitable-20-infusettes'
15 0.0020 0.0020380020141602
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0019 0.0018939971923828
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0070 0.0069580078125
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
18 0.0024 0.0024111270904541
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0015 0.0014560222625732
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00044012069702148
SELECT id FROM categories WHERE parent_id = '26'
21 0.0071 0.0070750713348389
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 
22 0.0026 0.0025889873504639
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 
23 0.0024 0.0023839473724365
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
24 0.0026 0.0026400089263916
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0009 0.00091195106506348
SELECT * FROM categorygroups WHERE id = '1'
26 0.0046 0.004601001739502
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
27 0.0007 0.00070500373840332
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00046110153198242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '27'
30 0.0041 0.0040550231933594
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 
31 0.0006 0.00060820579528809
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 
32 0.0007 0.00069785118103027
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
33 0.0006 0.00057506561279297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0006 0.00055503845214844
SELECT * FROM categorygroups WHERE id = '1'
35 0.0018 0.0017688274383545
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
36 0.0005 0.00053000450134277
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00040888786315918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '28'
39 0.0018 0.0018379688262939
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 
40 0.0007 0.000701904296875
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 
41 0.0008 0.00075507164001465
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
42 0.0006 0.00063085556030273
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.0006098747253418
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00070309638977051
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
45 0.0005 0.00051093101501465
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00040483474731445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00041604042053223
SELECT id FROM categories WHERE parent_id = '29'
48 0.0009 0.00088906288146973
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 
49 0.0006 0.00064301490783691
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 
50 0.0014 0.0013678073883057
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
51 0.0015 0.0014939308166504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0011 0.0011210441589355
SELECT * FROM categorygroups WHERE id = '1'
53 0.0016 0.0016341209411621
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
54 0.0017 0.0016548633575439
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0017 0.0016710758209229
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0016 0.0016438961029053
SELECT id FROM categories WHERE parent_id = '30'
57 0.0019 0.0019240379333496
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 
58 0.0006 0.00063204765319824
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 
59 0.0006 0.00059890747070312
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
60 0.0008 0.00076198577880859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00051188468933105
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00066399574279785
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
63 0.0006 0.00061202049255371
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0006 0.00055885314941406
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00053215026855469
SELECT id FROM categories WHERE parent_id = '31'
66 0.0025 0.0025479793548584
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 
67 0.0011 0.0010819435119629
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 
68 0.0006 0.00064992904663086
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
69 0.0007 0.0006871223449707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00053906440734863
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00059700012207031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0036 0.0036420822143555
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0018 0.0018229484558105
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00071191787719727
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
75 0.0014 0.0013730525970459
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010800361633301
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.001168966293335
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5964 0.59641599655151
SELECT * FROM ipgeocountries WHERE INET_ATON('3.12.148.195') >= INET_ATON(ip_start) AND INET_ATON('3.12.148.195') <= INET_ATON(ip_end)
79 0.0025 0.002540111541748
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0019 0.0019199848175049
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0009 0.00092411041259766
SELECT * FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-Epices-bio-et-Equitable-20-infusettes'
82 0.0005 0.00047802925109863
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1108
83 0.0008 0.0008080005645752
SELECT * FROM manufacturers WHERE id = '227'
84 0.0006 0.00060606002807617
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '227'
85 0.0021 0.0021250247955322
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '227' LIMIT 1
86 0.0024 0.0024278163909912
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '227' ORDER BY RAND() LIMIT 1
87 0.0008 0.00078797340393066
SELECT * FROM productimages WHERE product_id = '1108' ORDER BY sortorder ASC
88 0.0007 0.00070095062255859
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '227'
89 0.0007 0.00073099136352539
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '227'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00060701370239258
SELECT * FROM manufacturerimages WHERE manufacturer_id = '227'
91 0.0006 0.00063300132751465
SELECT category_id FROM products_categories WHERE product_id = '1108'
92 0.0007 0.00072097778320312
SELECT * FROM categories WHERE id = '27'
93 0.0075 0.0075151920318604
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
94 0.0007 0.00066304206848145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00055408477783203
SELECT id FROM categories WHERE parent_id = '27'
96 0.0091 0.0090751647949219
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 
97 0.0008 0.00081205368041992
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 
98 0.0013 0.0012741088867188
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
99 0.0011 0.0010571479797363
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0015 0.0014581680297852
SELECT * FROM productimages WHERE product_id = '1108' ORDER BY sortorder ASC
101 0.0028 0.0028140544891357
SELECT * FROM product_image_select WHERE product_id = '1108'
102 0.0016 0.0015799999237061
SELECT * FROM productcustomimages WHERE product_id = '1108'
103 0.0014 0.001384973526001
SELECT * FROM productfeeds WHERE product_id = '1108' ORDER BY item_date DESC
104 0.0029 0.0029361248016357
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0028 0.0027701854705811
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1108' AND t.hidden = 0 AND display_product = 1
106 0.0004 0.0004420280456543
SELECT * FROM tags WHERE id = '62'
107 0.0018 0.0017640590667725
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0016 0.0015799999237061
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0016 0.001572847366333
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0007 0.00072598457336426
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
111 0.0004 0.0004270076751709
SELECT * FROM tags WHERE id = '1'
112 0.0014 0.0014259815216064
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
113 0.0016 0.0016109943389893
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 
114 0.0014 0.001370906829834
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
115 0.0006 0.00056695938110352
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
116 0.0024 0.0023720264434814
SELECT * FROM productamazoncontent WHERE product_id = '1108'
117 0.0013 0.0013349056243896
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
118 0.0022 0.0021700859069824
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.0004730224609375
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
121 0.0006 0.00058817863464355
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
122 0.0006 0.00057506561279297
SELECT value FROM productattributes WHERE product_id = '1108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00057601928710938
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
124 0.0105 0.010503053665161
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AND 1108 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
125 0.0010 0.0010249614715576
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AND 1108 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
126 0.0007 0.00073504447937012
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('blanc rooibos Ãpices' IN BOOLEAN MODE) AND 1108 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
127 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
128 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '865'
129 0.0005 0.00050592422485352
SELECT * FROM productcustomimages WHERE product_id = '865'
130 0.0009 0.00091290473937988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
131 0.0006 0.00055789947509766
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.00055289268493652
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.00052118301391602
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00055193901062012
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
135 0.0007 0.00069999694824219
SELECT * FROM product_image_select WHERE product_id = '878'
136 0.0005 0.0005040168762207
SELECT * FROM productcustomimages WHERE product_id = '878'
137 0.0010 0.0010080337524414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
138 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0004 0.00044679641723633
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.0005180835723877
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0007 0.00073003768920898
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
142 0.0006 0.00060296058654785
SELECT * FROM product_image_select WHERE product_id = '858'
143 0.0005 0.00052905082702637
SELECT * FROM productcustomimages WHERE product_id = '858'
144 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
145 0.0006 0.00059604644775391
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0006 0.00056886672973633
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0005 0.0005338191986084
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
149 0.0007 0.0006859302520752
SELECT * FROM product_image_select WHERE product_id = '4952'
150 0.0005 0.00048112869262695
SELECT * FROM productcustomimages WHERE product_id = '4952'
151 0.0009 0.00085091590881348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
152 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0007 0.00066494941711426
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
156 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '862'
157 0.0004 0.00043511390686035
SELECT * FROM productcustomimages WHERE product_id = '862'
158 0.0010 0.00096011161804199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
159 0.0006 0.00056886672973633
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0006 0.0005500316619873
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0006 0.00057315826416016
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
163 0.0006 0.00063490867614746
SELECT * FROM product_image_select WHERE product_id = '4947'
164 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '4947'
165 0.0010 0.0010268688201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
166 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0005 0.00049805641174316
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00049686431884766
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0005 0.00054192543029785
SELECT id,asin FROM products WHERE parent_id = 1108
170 0.0020 0.0019810199737549
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1108' ORDER BY timestamp DESC
171 0.0006 0.00063514709472656
SELECT category_id FROM products_categories WHERE product_id = '1108'
172 0.0006 0.0005500316619873
SELECT * FROM categories WHERE id = '27'
173 0.0042 0.0041799545288086
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
174 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
175 0.0005 0.00047993659973145
SELECT id FROM categories WHERE parent_id = '27'
176 0.0036 0.0035967826843262
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 
177 0.0007 0.00067877769470215
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 
178 0.0007 0.00065898895263672
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
179 0.0006 0.0005638599395752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
180 0.0011 0.0010528564453125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
181 0.0006 0.00061511993408203
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
184 0.0005 0.00054502487182617
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
185 0.0008 0.00081300735473633
SELECT * FROM products WHERE id = '1108'
186 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '1108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0010 0.0010449886322021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
188 0.0004 0.00041389465332031
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
191 0.0005 0.00046014785766602
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
192 0.0005 0.00050497055053711
SELECT category_id FROM products_categories WHERE product_id = '1108' AND prod_type = 'amz'
193 0.0005 0.00045490264892578
SELECT parent_id FROM categories WHERE id = '27'
194 0.0005 0.00051403045654297
SELECT * FROM categories WHERE id = '27'
195 0.0036 0.003619909286499
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
196 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
197 0.0004 0.00039815902709961
SELECT id FROM categories WHERE parent_id = '27'
198 0.0035 0.0034840106964111
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 
199 0.0006 0.0006110668182373
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
200 0.0006 0.00061416625976562
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
201 0.0005 0.00052618980407715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
202 0.0020 0.0020267963409424
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
203 0.0015 0.0015189647674561
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
204 0.0004 0.00043010711669922
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
205 0.0128 0.012805938720703
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
206 0.0018 0.0018439292907715
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
207 0.0006 0.00063180923461914
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
208 0.0006 0.00062084197998047
SELECT * FROM products WHERE id = 1626
209 0.0007 0.00068998336791992
SELECT * FROM products WHERE id = 4041
210 0.0007 0.00065016746520996
SELECT * FROM products WHERE id = 4312
211 0.0006 0.00063014030456543
SELECT * FROM products WHERE id = 777
212 0.0006 0.00063800811767578
SELECT * FROM products WHERE id = 3881
213 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = 4213
214 0.0006 0.00062298774719238
SELECT * FROM products WHERE id = '1626'
215 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
216 0.0010 0.00097298622131348
SELECT * FROM product_image_select WHERE product_id = '1626'
217 0.0005 0.00048017501831055
SELECT * FROM productcustomimages WHERE product_id = '1626'
218 0.0009 0.00089597702026367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
219 0.0005 0.0005497932434082
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0007 0.00065302848815918
SELECT * FROM products WHERE id = '4041'
223 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
224 0.0008 0.00078511238098145
SELECT * FROM product_image_select WHERE product_id = '4041'
225 0.0005 0.0005030632019043
SELECT * FROM productcustomimages WHERE product_id = '4041'
226 0.0012 0.0012469291687012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
227 0.0006 0.00059604644775391
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0006 0.00056695938110352
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0007 0.00067400932312012
SELECT * FROM products WHERE id = '4312'
231 0.0005 0.00051498413085938
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
232 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '4312'
233 0.0005 0.00052189826965332
SELECT * FROM productcustomimages WHERE product_id = '4312'
234 0.0017 0.0017490386962891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
235 0.0007 0.00069999694824219
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0006 0.00061607360839844
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0009 0.00094914436340332
SELECT * FROM products WHERE id = '777'
239 0.0011 0.0010859966278076
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
240 0.0011 0.0010788440704346
SELECT * FROM product_image_select WHERE product_id = '777'
241 0.0007 0.00069594383239746
SELECT * FROM productcustomimages WHERE product_id = '777'
242 0.0016 0.0015530586242676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
243 0.0007 0.00074601173400879
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0006 0.00055909156799316
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0008 0.00081300735473633
SELECT * FROM products WHERE id = '3881'
247 0.0009 0.00090503692626953
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
248 0.0009 0.00088095664978027
SELECT * FROM product_image_select WHERE product_id = '3881'
249 0.0005 0.00054693222045898
SELECT * FROM productcustomimages WHERE product_id = '3881'
250 0.0017 0.0016908645629883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
251 0.0007 0.00072407722473145
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0006 0.00062417984008789
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0006 0.00064992904663086
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0008 0.00082492828369141
SELECT * FROM products WHERE id = '4213'
255 0.0011 0.0010900497436523
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
256 0.0008 0.00077319145202637
SELECT * FROM product_image_select WHERE product_id = '4213'
257 0.0006 0.0005650520324707
SELECT * FROM productcustomimages WHERE product_id = '4213'
258 0.0016 0.0015521049499512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
259 0.0006 0.00064301490783691
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0005 0.0005497932434082
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0006 0.00059890747070312
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0030 0.002979040145874
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
263 0.0010 0.0010209083557129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
264 0.0035 0.0035479068756104
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
265 0.0026 0.0025629997253418
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0008 0.00081515312194824
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
267 0.0010 0.00097489356994629
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'