0

Dragonfly Organic Rooibos Chai Tea Bags 20 per pack

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-25 18:44: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

GB-ORG-4 non l'agriculture biologique de l'UE Fédération des aliments certifiés biologiques. Organique Chai

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.5816740989685 257 1.1615 0


No Amazon API Requests Made.


App Debug - Total Time 1.5816740989685 seconds

Number Time From Start Name Description
1 0.3910219669342 Initialise Initialise FSB Function
2 0.4009211063385 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44369316101074 Start of getCategoryListByGroup Function Before first category groups query
4 0.44411301612854 After initial query Before first category groups query
5 0.44411396980286 Get Category List for Group Before the call to getCategoryList function
6 0.44411516189575 Start of GetCategoryList function Start of the function
7 0.44411706924438 Before getting categories Query to get specific category list
8 0.44466805458069 After getting categories Query to get specific category list
9 0.44466805458069 Before getting category custom Before call to function getCategoryCustom
10 0.4728729724884 After getting category custom After call to function getCategoryCustom
11 0.47287511825562 Before getting category custom Before call to function getCategoryCustom
12 0.49036717414856 After getting category custom After call to function getCategoryCustom
13 0.49037003517151 Before getting category custom Before call to function getCategoryCustom
14 0.49939203262329 After getting category custom After call to function getCategoryCustom
15 0.49939513206482 Before getting category custom Before call to function getCategoryCustom
16 0.50440406799316 After getting category custom After call to function getCategoryCustom
17 0.50440502166748 Before getting category custom Before call to function getCategoryCustom
18 0.5092191696167 After getting category custom After call to function getCategoryCustom
19 0.50922012329102 Before getting category custom Before call to function getCategoryCustom
20 0.5147590637207 After getting category custom After call to function getCategoryCustom
21 0.51476001739502 End of GetCategoryList function End of the function
22 0.5147659778595 Get Category List for Group Before the call to getCategoryList function
23 0.51476812362671 Start of GetCategoryList function Start of the function
24 0.51477003097534 Before getting categories Query to get specific category list
25 0.51539516448975 End of getCategoryListByGroup Function Before return()
26 1.3620080947876 App Controller End End of the App controller (called before the controller of every page)
27 1.3623471260071 Product Start Start of the product info controller
28 1.3816001415253 Cache file not found Starting get product details
29 1.4163479804993 Related products Start getting related products if enabled
30 1.4163491725922 Related Products Start Before the related products are found
31 1.4163501262665 Related Products Keywords Before the related product keywords are found
32 1.4163529872894 Create Keyword List Function Start of function
33 1.4164459705353 Create Keyword List Function After looping provided content - 24 keywords found
34 1.4170141220093 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
35 1.4170191287994 Create Keyword List Function After reducing keyword list
36 1.4170520305634 Create Keyword List Function After selecting by scoring keywords
37 1.417053937912 Create Keyword List Function After final loop of keywords
38 1.4170551300049 Related Products Keywords After the related product keywords are found
39 1.4538691043854 Related Products End After the related products are found
40 1.4855060577393 Product End End of the product info controller (Product Info)
41 1.4876430034637 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4901330471039 Before Get Options Before the call to getOptions in the tpl class
43 1.5520730018616 After Get Options After the call to getOptions in the tpl class
44 1.5521960258484 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5522191524506 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5621161460876 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5621199607849 Product Info: Before Template Display Before the template is displayed
48 1.5816540718079 Product Info: After Template Display After the template is displayed
49 1.5816640853882 Finalizing debug Before the debug is output to the page.
50 1.5816731452942 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 1.1615 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.001215934753418
SELECT parameter, value FROM parameters
2 0.0086 0.0085721015930176
SELECT * FROM `bad_bots`
3 0.0004 0.00040006637573242
SET time_zone = 'Europe/London'
4 0.0038 0.0038089752197266
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0027 0.0027341842651367
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.222.226.15\";}'
6 0.0023 0.0023059844970703
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745163728'
7 0.0048 0.0048129558563232
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00081396102905273
UPDATE autorun SET lastrun = '2025-04-20 15:42:09' WHERE id = '13'
9 0.0008 0.00084304809570312
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0040 0.0039510726928711
SELECT id FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack' LIMIT 1
11 0.0049 0.0048961639404297
SELECT id FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack' AND hidden = 0 LIMIT 1
12 0.0069 0.0069050788879395
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0349 0.034893035888672
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00058817863464355
SELECT * FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack'
15 0.0004 0.00041389465332031
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00054097175598145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0103 0.010282039642334
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.0015 0.0015370845794678
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.0014 0.0013999938964844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0007 0.00072193145751953
SELECT id FROM categories WHERE parent_id = '26'
21 0.0111 0.011123895645142
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.0011 0.0010750293731689
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.0008 0.00080013275146484
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.0006 0.0005650520324707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00063681602478027
SELECT * FROM categorygroups WHERE id = '1'
26 0.0079 0.0079231262207031
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.0010 0.0009920597076416
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.0004 0.0004270076751709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00041508674621582
SELECT id FROM categories WHERE parent_id = '27'
30 0.0051 0.0051181316375732
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.0007 0.00072002410888672
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.0006 0.00059199333190918
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.00064206123352051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0006 0.00058507919311523
SELECT * FROM categorygroups WHERE id = '1'
35 0.0022 0.002155065536499
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.0006 0.00062108039855957
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.0005 0.0005040168762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.0005040168762207
SELECT id FROM categories WHERE parent_id = '28'
39 0.0023 0.0023298263549805
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.0009 0.00089883804321289
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.0009 0.00090193748474121
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.0005 0.00054502487182617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00048685073852539
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00068497657775879
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.00049400329589844
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.0005 0.0004880428314209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00047802925109863
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00079703330993652
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.0005 0.00049400329589844
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.0006 0.00058722496032715
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.0005 0.00049209594726562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00042486190795898
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.0006558895111084
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.0005 0.00047707557678223
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.0004 0.0004420280456543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00041699409484863
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00067019462585449
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.00057387351989746
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.0005 0.00051498413085938
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.0005 0.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00051712989807129
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00063896179199219
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.0005 0.00052690505981445
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.0005 0.00047612190246582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00053286552429199
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00069689750671387
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.0006 0.00064611434936523
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.0007 0.0006561279296875
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.00073504447937012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00057387351989746
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00061798095703125
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0019 0.0018680095672607
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0006 0.00064706802368164
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00069999694824219
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.0005 0.00052285194396973
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0014181137084961
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0010 0.0010330677032471
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8383 0.83832597732544
SELECT * FROM ipgeocountries WHERE INET_ATON('18.222.226.15') >= INET_ATON(ip_start) AND INET_ATON('18.222.226.15') <= INET_ATON(ip_end)
79 0.0009 0.00092101097106934
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0004 0.00037097930908203
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0005 0.00052404403686523
SELECT * FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack'
82 0.0006 0.00055098533630371
UPDATE products SET viewcount = viewcount + 1 WHERE id = 902
83 0.0012 0.0011570453643799
SELECT * FROM manufacturers WHERE id = '243'
84 0.0010 0.0010221004486084
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
85 0.0007 0.00074005126953125
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
86 0.0018 0.0017900466918945
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '243' ORDER BY RAND() LIMIT 1
87 0.0006 0.00064301490783691
SELECT * FROM productimages WHERE product_id = '1442' ORDER BY sortorder ASC
88 0.0009 0.0009150505065918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
89 0.0013 0.0012619495391846
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '243'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0005 0.0005190372467041
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
91 0.0009 0.00085592269897461
SELECT category_id FROM products_categories WHERE product_id = '902'
92 0.0010 0.00098419189453125
SELECT * FROM categories WHERE id = '27'
93 0.0070 0.0070250034332275
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0004 0.0003509521484375
SELECT id FROM categories WHERE parent_id = '27'
96 0.0044 0.0044100284576416
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.0006 0.00059294700622559
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.0006 0.00058317184448242
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.0005 0.0005338191986084
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0005 0.0004570484161377
SELECT * FROM productimages WHERE product_id = '902' ORDER BY sortorder ASC
101 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '902'
102 0.0005 0.00049281120300293
SELECT * FROM productcustomimages WHERE product_id = '902'
103 0.0005 0.00048303604125977
SELECT * FROM productfeeds WHERE product_id = '902' ORDER BY item_date DESC
104 0.0008 0.00079512596130371
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0007 0.00066494941711426
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '902' AND t.hidden = 0 AND display_product = 1
106 0.0017 0.0016801357269287
SELECT * FROM productamazoncontent WHERE product_id = '902'
107 0.0010 0.00097107887268066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
108 0.0020 0.0019538402557373
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0005 0.00049519538879395
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00035214424133301
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
111 0.0004 0.00037908554077148
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
112 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0005 0.00048995018005371
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
114 0.0101 0.010127067565918
SELECT *, MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AND 902 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00069499015808105
SELECT *, MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AND 902 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0006 0.00064492225646973
SELECT *, MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dragonfly organic rooibos' IN BOOLEAN MODE) AND 902 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0006 0.0005650520324707
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
118 0.0007 0.00068783760070801
SELECT * FROM product_image_select WHERE product_id = '890'
119 0.0005 0.00048613548278809
SELECT * FROM productcustomimages WHERE product_id = '890'
120 0.0011 0.0010569095611572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
121 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.00041389465332031
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0006 0.00064802169799805
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
125 0.0007 0.00074195861816406
SELECT * FROM product_image_select WHERE product_id = '858'
126 0.0004 0.00041317939758301
SELECT * FROM productcustomimages WHERE product_id = '858'
127 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
128 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00054192543029785
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0005 0.00053715705871582
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
132 0.0006 0.00061607360839844
SELECT * FROM product_image_select WHERE product_id = '869'
133 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '869'
134 0.0008 0.00084900856018066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
135 0.0005 0.00053787231445312
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00049614906311035
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
139 0.0006 0.00063014030456543
SELECT * FROM product_image_select WHERE product_id = '878'
140 0.0004 0.0003812313079834
SELECT * FROM productcustomimages WHERE product_id = '878'
141 0.0010 0.0010280609130859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
142 0.0005 0.00050997734069824
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00045609474182129
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00060892105102539
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
146 0.0006 0.0006251335144043
SELECT * FROM product_image_select WHERE product_id = '862'
147 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '862'
148 0.0011 0.0011401176452637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
149 0.0004 0.00043582916259766
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
153 0.0007 0.00072288513183594
SELECT * FROM product_image_select WHERE product_id = '865'
154 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '865'
155 0.0009 0.00086808204650879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
156 0.0005 0.00053000450134277
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.0004727840423584
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00053596496582031
SELECT id,asin FROM products WHERE parent_id = 902
160 0.0019 0.0018930435180664
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '902' ORDER BY timestamp DESC
161 0.0004 0.0004420280456543
SELECT category_id FROM products_categories WHERE product_id = '902'
162 0.0004 0.00043487548828125
SELECT * FROM categories WHERE id = '27'
163 0.0049 0.0049030780792236
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
164 0.0004 0.00042390823364258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0003 0.00031399726867676
SELECT id FROM categories WHERE parent_id = '27'
166 0.0048 0.0048279762268066
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 
167 0.0005 0.00050997734069824
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 
168 0.0006 0.00063300132751465
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
169 0.0005 0.00046014785766602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0009 0.00089502334594727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
171 0.0004 0.0004420280456543
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
174 0.0004 0.00036096572875977
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
175 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = '902'
176 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0006 0.00064897537231445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
178 0.0004 0.00036501884460449
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0003 0.00034189224243164
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00042200088500977
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
182 0.0004 0.00043010711669922
SELECT category_id FROM products_categories WHERE product_id = '902' AND prod_type = 'amz'
183 0.0004 0.0003960132598877
SELECT parent_id FROM categories WHERE id = '27'
184 0.0003 0.00033998489379883
SELECT * FROM categories WHERE id = '27'
185 0.0037 0.0036821365356445
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
186 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0003 0.00032997131347656
SELECT id FROM categories WHERE parent_id = '27'
188 0.0037 0.0036540031433105
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 
189 0.0005 0.00045585632324219
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 
190 0.0005 0.00047802925109863
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
191 0.0005 0.00047612190246582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0017 0.0016539096832275
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0018 0.0018138885498047
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0006 0.00063490867614746
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0153 0.015313863754272
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
196 0.0020 0.0020420551300049
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
197 0.0006 0.0005800724029541
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
198 0.0005 0.00045394897460938
SELECT * FROM products WHERE id = 1626
199 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = 4041
200 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = 4312
201 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = 777
202 0.0004 0.0003669261932373
SELECT * FROM products WHERE id = 3881
203 0.0004 0.00035405158996582
SELECT * FROM products WHERE id = 4213
204 0.0004 0.00044608116149902
SELECT * FROM products WHERE id = '1626'
205 0.0025 0.0024878978729248
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0006 0.0005800724029541
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0004 0.00038504600524902
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0007 0.00074601173400879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0004 0.00042200088500977
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = '4041'
213 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0006 0.00058984756469727
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0012 0.001154899597168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0004 0.00044012069702148
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00034713745117188
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.00044798851013184
SELECT * FROM products WHERE id = '4312'
221 0.0005 0.00052213668823242
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0006 0.00059199333190918
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0004 0.00036907196044922
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0010 0.001039981842041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0004 0.00040793418884277
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00033211708068848
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00043201446533203
SELECT * FROM products WHERE id = '777'
229 0.0004 0.00041699409484863
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0006 0.00055789947509766
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0004 0.00035476684570312
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0018 0.001798152923584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0004 0.00040984153747559
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0005 0.00045585632324219
SELECT * FROM products WHERE id = '3881'
237 0.0005 0.00045919418334961
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0005 0.00054121017456055
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0023 0.0022950172424316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0010 0.00097894668579102
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0008 0.00082111358642578
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0006 0.00055217742919922
SELECT * FROM products WHERE id = '4213'
245 0.0005 0.0005488395690918
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0008 0.00079011917114258
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0004 0.00042390823364258
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0021 0.002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0007 0.00069785118103027
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0022 0.0022339820861816
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0008 0.00082802772521973
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0028 0.0027759075164795
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0020 0.0020101070404053
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0006 0.00063300132751465
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0006 0.00062417984008789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'