Dragonfly Organic Rooibos Chai Tea Bags 20 per pack

Dragonfly Organic Rooibos Chai Tea Bags 20 per pack
Dragonfly Organic Rooibos Chai Tea Bags 20 per pack Dragonfly Organic Rooibos Chai Tea Bags 20 per pack (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-19 22:59:30 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.

Caractéristiques du Produit

GB-ORG-4 non l'agriculture biologique de l'UE Fédération des aliments certifiés biologiques. Organique Chai
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.91946005821228 235 0.1283 0


No Amazon API Requests Made.

Total time 0.91946005821228 seconds

Number Time From Start Name Description
1 0.74455499649048 Initialise Initialise FSB Function
2 0.74664211273193 App Controller Start Start of the App controller (called before the controller of every page)
3 0.74910998344421 Start of getCategoryListByGroup Function Before first category groups query
4 0.74935603141785 After initial query Before first category groups query
5 0.74935793876648 Get Category List for Group Before the call to getCategoryList function
6 0.74936103820801 Start of GetCategoryList function Start of the function
7 0.74936413764954 Before getting categories Query to get specific category list
8 0.74970102310181 After getting categories Query to get specific category list
9 0.74970197677612 Before getting category custom Before call to function getCategoryCustom
10 0.76985001564026 After getting category custom After call to function getCategoryCustom
11 0.76985216140747 Before getting category custom Before call to function getCategoryCustom
12 0.77883195877075 After getting category custom After call to function getCategoryCustom
13 0.77883505821228 Before getting category custom Before call to function getCategoryCustom
14 0.78390598297119 After getting category custom After call to function getCategoryCustom
15 0.78390908241272 Before getting category custom Before call to function getCategoryCustom
16 0.78635597229004 After getting category custom After call to function getCategoryCustom
17 0.78635811805725 Before getting category custom Before call to function getCategoryCustom
18 0.79104495048523 After getting category custom After call to function getCategoryCustom
19 0.79104709625244 Before getting category custom Before call to function getCategoryCustom
20 0.79353809356689 After getting category custom After call to function getCategoryCustom
21 0.79354000091553 End of GetCategoryList function End of the function
22 0.79354500770569 End of getCategoryListByGroup Function Before return()
23 0.79801201820374 App Controller End End of the App controller (called before the controller of every page)
24 0.79862499237061 Product Start Start of the product info controller
25 0.80041098594666 Cache file not found Starting get product details
26 0.82171511650085 Related products Start getting related products if enabled
27 0.82171702384949 Related Products Start Before the related products are found
28 0.8217179775238 Related Products Keywords Before the related product keywords are found
29 0.82172203063965 Create Keyword List Function Start of function
30 0.82175207138062 Create Keyword List Function After looping provided content - 24 keywords found
31 0.82269716262817 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 0.82270503044128 Create Keyword List Function After reducing keyword list
33 0.82275104522705 Create Keyword List Function After selecting by scoring keywords
34 0.8227550983429 Create Keyword List Function After final loop of keywords
35 0.82275700569153 Related Products Keywords After the related product keywords are found
36 0.8368091583252 Related Products End After the related products are found
37 0.84434509277344 Product End End of the product info controller (Product Info)
38 0.84527611732483 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.84588694572449 Before Get Options Before the call to getOptions in the tpl class
40 0.87862205505371 After Get Options After the call to getOptions in the tpl class
41 0.87873506546021 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.87876796722412 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.89172101020813 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.89172601699829 Product Info: Before Template Display Before the template is displayed
45 0.91943216323853 Product Info: After Template Display After the template is displayed
46 0.9194450378418 Finalizing debug Before the debug is output to the page.
47 0.91945815086365 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1283 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00060391426086426
SELECT parameter, value FROM parameters
2 0.0008 0.00076913833618164
SELECT * FROM `bad_bots`
3 0.0002 0.0002448558807373
SET time_zone = 'Europe/London'
4 0.0002 0.00021600723266602
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015687942504883
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0009 0.00089478492736816
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632224361'
7 0.0005 0.00050806999206543
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00041985511779785
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00027203559875488
SELECT id FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack' LIMIT 1
10 0.0007 0.00071310997009277
SELECT id FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack' AND hidden = 0 LIMIT 1
11 0.0011 0.0011179447174072
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00068902969360352
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0003 0.00026297569274902
SELECT * FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack'
14 0.0002 0.00023484230041504
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00031709671020508
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0098 0.009768009185791
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.0010 0.00097894668579102
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.0002 0.0001828670501709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '26'
20 0.0054 0.0054190158843994
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.0029 0.0029029846191406
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.0002 0.00019121170043945
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.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
25 0.0036 0.0036311149597168
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.0003 0.00026178359985352
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.0002 0.00020813941955566
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0037779808044434
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.0002 0.00023508071899414
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.0002 0.00018000602722168
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.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0013861656188965
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.0011 0.0011119842529297
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.0002 0.00019598007202148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018715858459473
SELECT id FROM categories WHERE parent_id = '28'
38 0.0013 0.0013480186462402
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.0002 0.00021195411682129
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.0002 0.00017714500427246
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.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00017380714416504
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00047397613525391
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.0002 0.00018000602722168
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.0002 0.00017309188842773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00018882751464844
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00057792663574219
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.0002 0.00019192695617676
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.0002 0.00019097328186035
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.0002 0.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00017714500427246
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00046420097351074
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.0002 0.0001990795135498
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.0002 0.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00048589706420898
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.0025 0.0025148391723633
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.0002 0.00019598007202148
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.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00017189979553223
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00054216384887695
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.0002 0.00023889541625977
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.0002 0.00020098686218262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017094612121582
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00047397613525391
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.0002 0.00017690658569336
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.0002 0.00017595291137695
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.0002 0.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00021100044250488
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00026202201843262
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00028395652770996
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
73 0.0002 0.00021195411682129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0004 0.00038909912109375
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.00038003921508789
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00024104118347168
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
77 0.0002 0.00021004676818848
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00018501281738281
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00047397613525391
SELECT * FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack'
80 0.0006 0.00064706802368164
UPDATE products SET viewcount = viewcount + 1 WHERE id = 902
81 0.0003 0.00029110908508301
SELECT * FROM manufacturers WHERE id = '243'
82 0.0005 0.00053691864013672
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
83 0.0005 0.00053691864013672
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
84 0.0008 0.00076985359191895
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
85 0.0002 0.0002131462097168
SELECT * FROM productimages WHERE product_id = '1438' ORDER BY sortorder ASC
86 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
87 0.0005 0.00054788589477539
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 
88 0.0002 0.00019192695617676
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
89 0.0002 0.00021195411682129
SELECT category_id FROM products_categories WHERE product_id = '902'
90 0.0003 0.00025510787963867
SELECT * FROM categories WHERE id = '27'
91 0.0044 0.0044260025024414
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
92 0.0002 0.00021886825561523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00018715858459473
SELECT id FROM categories WHERE parent_id = '27'
94 0.0044 0.0043900012969971
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 
95 0.0004 0.00037407875061035
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 
96 0.0003 0.00028800964355469
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
97 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0004 0.00038790702819824
SELECT * FROM productimages WHERE product_id = '902' ORDER BY sortorder ASC
99 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '902'
100 0.0002 0.00020408630371094
SELECT * FROM productcustomimages WHERE product_id = '902'
101 0.0002 0.00020790100097656
SELECT * FROM productfeeds WHERE product_id = '902' ORDER BY item_date DESC
102 0.0020 0.002000093460083
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
103 0.0004 0.00042605400085449
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
104 0.0002 0.00021696090698242
SELECT * FROM productamazoncontent WHERE product_id = '902'
105 0.0010 0.0009911060333252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
106 0.0004 0.00041818618774414
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
109 0.0004 0.0004122257232666
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
110 0.0003 0.00032615661621094
SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00019693374633789
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
112 0.0068 0.0068449974060059
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 3
113 0.0003 0.00034308433532715
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 3
114 0.0003 0.0003049373626709
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 3
115 0.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0002 0.00022602081298828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0004 0.00039005279541016
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00040578842163086
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0003 0.00031208992004395
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0002 0.00021815299987793
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0007 0.00066685676574707
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00019288063049316
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00029397010803223
SELECT id,asin FROM products WHERE parent_id = 902
137 0.0004 0.00037693977355957
SELECT category_id FROM products_categories WHERE product_id = '902'
138 0.0003 0.0002598762512207
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00020694732666016
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
140 0.0002 0.00021791458129883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00019311904907227
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00020003318786621
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 
143 0.0002 0.0001978874206543
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 
144 0.0002 0.00019598007202148
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
145 0.0002 0.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00019097328186035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
147 0.0002 0.00021886825561523
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00021505355834961
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
151 0.0004 0.00038290023803711
SELECT * FROM products WHERE id = '902'
152 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00021696090698242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
154 0.0002 0.00021815299987793
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00019502639770508
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
158 0.0002 0.00023388862609863
SELECT category_id FROM products_categories WHERE product_id = '902' AND prod_type = 'amz'
159 0.0002 0.00020790100097656
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.00026488304138184
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00020313262939453
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
162 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00018596649169922
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 
165 0.0002 0.0001828670501709
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 
166 0.0002 0.00022196769714355
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
167 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0003 0.00029110908508301
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0004 0.00035214424133301
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00020003318786621
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.0004270076751709
SELECT * FROM pages WHERE id = 38
172 0.0062 0.0061800479888916
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
173 0.0005 0.00052094459533691
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1632224362;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0007 0.00070309638977051
SELECT * FROM products WHERE id = 790
175 0.0006 0.00058293342590332
SELECT * FROM products WHERE id = 788
176 0.0006 0.00058102607727051
SELECT * FROM products WHERE id = 787
177 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = 1287
178 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = 779
179 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = 777
180 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = '790'
181 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0003 0.00026202201843262
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0003 0.00030112266540527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0005 0.00046610832214355
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0008 0.00078892707824707
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00020909309387207
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00043296813964844
SELECT * FROM products WHERE id = '788'
189 0.0003 0.0002601146697998
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.0002129077911377
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.0002291202545166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0004 0.0003969669342041
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00020694732666016
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00047683715820312
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00020813941955566
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00024604797363281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00021195411682129
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00055599212646484
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0003 0.00033783912658691
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0004 0.00035905838012695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0005 0.00047898292541504
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0006 0.00056314468383789
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00052404403686523
SELECT * FROM products WHERE id = '779'
213 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0003 0.00026512145996094
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0003 0.00026178359985352
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0004 0.00042200088500977
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00023794174194336
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.0005958080291748
SELECT * FROM products WHERE id = '777'
221 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0003 0.00026917457580566
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0003 0.00028800964355469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0005 0.00053715705871582
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00048184394836426
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00033116340637207
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0003 0.00034499168395996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0006 0.00059294700622559
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0003 0.00033998489379883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0003 0.00032520294189453
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00036406517028809
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0003 0.00031089782714844
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.00029706954956055
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'