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)
€7,07
Le prix et la disponibilité du produit sont corrects en date du 2022-05-19 08:40:52 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.81606197357178 230 0.2447 0


No Amazon API Requests Made.

Total time 0.81606197357178 seconds

Number Time From Start Name Description
1 0.53870391845703 Initialise Initialise FSB Function
2 0.54141092300415 App Controller Start Start of the App controller (called before the controller of every page)
3 0.55091786384583 Start of getCategoryListByGroup Function Before first category groups query
4 0.55156707763672 After initial query Before first category groups query
5 0.55156898498535 Get Category List for Group Before the call to getCategoryList function
6 0.5515730381012 Start of GetCategoryList function Start of the function
7 0.55157589912415 Before getting categories Query to get specific category list
8 0.5523419380188 After getting categories Query to get specific category list
9 0.55234408378601 Before getting category custom Before call to function getCategoryCustom
10 0.5761890411377 After getting category custom After call to function getCategoryCustom
11 0.57619190216064 Before getting category custom Before call to function getCategoryCustom
12 0.58793807029724 After getting category custom After call to function getCategoryCustom
13 0.5879430770874 Before getting category custom Before call to function getCategoryCustom
14 0.59429001808167 After getting category custom After call to function getCategoryCustom
15 0.59429407119751 Before getting category custom Before call to function getCategoryCustom
16 0.598797082901 After getting category custom After call to function getCategoryCustom
17 0.59879994392395 Before getting category custom Before call to function getCategoryCustom
18 0.60291886329651 After getting category custom After call to function getCategoryCustom
19 0.60292100906372 Before getting category custom Before call to function getCategoryCustom
20 0.60721492767334 After getting category custom After call to function getCategoryCustom
21 0.60721802711487 End of GetCategoryList function End of the function
22 0.60722494125366 End of getCategoryListByGroup Function Before return()
23 0.66544508934021 App Controller End End of the App controller (called before the controller of every page)
24 0.66579008102417 Product Start Start of the product info controller
25 0.66829395294189 Cache file not found Starting get product details
26 0.69545698165894 Related products Start getting related products if enabled
27 0.69545888900757 Related Products Start Before the related products are found
28 0.69546008110046 Related Products Keywords Before the related product keywords are found
29 0.69546389579773 Create Keyword List Function Start of function
30 0.6955349445343 Create Keyword List Function After looping provided content - 24 keywords found
31 0.69647598266602 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 0.69648408889771 Create Keyword List Function After reducing keyword list
33 0.69652986526489 Create Keyword List Function After selecting by scoring keywords
34 0.69653391838074 Create Keyword List Function After final loop of keywords
35 0.69653606414795 Related Products Keywords After the related product keywords are found
36 0.71925401687622 Related Products End After the related products are found
37 0.72880792617798 Product End End of the product info controller (Product Info)
38 0.72965598106384 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.73054099082947 Before Get Options Before the call to getOptions in the tpl class
40 0.77714204788208 After Get Options After the call to getOptions in the tpl class
41 0.77727890014648 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.77730703353882 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.78912901878357 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.78913497924805 Product Info: Before Template Display Before the template is displayed
45 0.81604290008545 Product Info: After Template Display After the template is displayed
46 0.81604886054993 Finalizing debug Before the debug is output to the page.
47 0.81606101989746 End of App This is the end of the app logging, final timestamp


Query Debug - 230 Database Queries. Total time 0.2447 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00093603134155273
SELECT parameter, value FROM parameters
2 0.0024 0.0023751258850098
SELECT * FROM `bad_bots`
3 0.0004 0.00040698051452637
SET time_zone = 'Europe/London'
4 0.0006 0.00055694580078125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0016820430755615
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0028 0.0027799606323242
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653092117'
7 0.0009 0.00086808204650879
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00079512596130371
UPDATE autorun SET lastrun = '2022-05-21 00:15:18' WHERE id = '15'
9 0.0007 0.00066614151000977
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.0006251335144043
SELECT id FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack-426791978' LIMIT 1
11 0.0008 0.00081300735473633
SELECT id FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack-426791978' AND hidden = 0 LIMIT 1
12 0.0010 0.0010340213775635
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0071 0.0071089267730713
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0008 0.00076889991760254
SELECT * FROM pages WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack-426791978'
15 0.0006 0.00063300132751465
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00074291229248047
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0091 0.0090510845184326
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.0009 0.00087904930114746
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.0013 0.001345157623291
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00062704086303711
SELECT id FROM categories WHERE parent_id = '26'
21 0.0096 0.0096421241760254
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.0006 0.00055718421936035
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.0005 0.00047087669372559
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.0007 0.0006859302520752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.0004270076751709
SELECT * FROM categorygroups WHERE id = '1'
26 0.0046 0.0046279430389404
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.0004 0.0003960132598877
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.0003 0.00029110908508301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00038790702819824
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0044269561767578
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.0003 0.00032281875610352
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.0004 0.00039100646972656
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.0005 0.00051093101501465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00023102760314941
SELECT * FROM categorygroups WHERE id = '1'
35 0.0017 0.0016541481018066
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.0004 0.0003969669342041
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.0003 0.0002739429473877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.0002901554107666
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0016200542449951
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.0004 0.00042581558227539
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.0005 0.00048089027404785
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.0007 0.00065088272094727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00040793418884277
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00069499015808105
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.0006 0.00056886672973633
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.00040292739868164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00067400932312012
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.0004 0.00039005279541016
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.0004 0.0003960132598877
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.0006 0.00055098533630371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.0003058910369873
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00055384635925293
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.0004 0.00038814544677734
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.00038909912109375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00038790702819824
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00064992904663086
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.0004 0.00039505958557129
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.0004 0.00037622451782227
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.0004 0.00037097930908203
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00073814392089844
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.0004 0.00042486190795898
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.0004 0.00037908554077148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00063395500183105
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.0004 0.00038909912109375
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.0005 0.00046300888061523
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.0005 0.00051593780517578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.0002589225769043
SELECT * FROM categorygroups WHERE id = '1'
71 0.0011 0.0011279582977295
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00061893463134766
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00080704689025879
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0005 0.00050115585327148
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0006 0.00056195259094238
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.0009310245513916
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0507 0.050734996795654
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
78 0.0006 0.00061893463134766
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00043106079101562
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00066304206848145
SELECT * FROM products WHERE pagename = 'dragonfly-organic-rooibos-chai-tea-bags-20-per-pack-426791978'
81 0.0011 0.0011019706726074
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1513
82 0.0005 0.0004880428314209
SELECT * FROM manufacturers WHERE id = '243'
83 0.0009 0.00085091590881348
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
84 0.0005 0.0004730224609375
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
85 0.0009 0.00092387199401855
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
86 0.0017 0.0017049312591553
SELECT * FROM productimages WHERE product_id = '1259' ORDER BY sortorder ASC
87 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
88 0.0007 0.0006561279296875
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 
89 0.0004 0.0003509521484375
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
90 0.0004 0.00039911270141602
SELECT category_id FROM products_categories WHERE product_id = '1513'
91 0.0005 0.00048208236694336
SELECT * FROM categories WHERE id = '27'
92 0.0046 0.0045580863952637
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0003 0.0002751350402832
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '27'
95 0.0051 0.0051229000091553
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0003 0.00033283233642578
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0002 0.00024604797363281
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0002 0.00024819374084473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0014 0.0013949871063232
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
100 0.0006 0.00058102607727051
SELECT * FROM product_image_select WHERE product_id = '1513'
101 0.0004 0.00043296813964844
SELECT * FROM productcustomimages WHERE product_id = '1513'
102 0.0004 0.0004270076751709
SELECT * FROM productfeeds WHERE product_id = '1513' ORDER BY item_date DESC
103 0.0015 0.0014679431915283
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0006 0.00062012672424316
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1513' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00050187110900879
SELECT * FROM productamazoncontent WHERE product_id = '1513'
106 0.0013 0.0012838840484619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
107 0.0005 0.00051307678222656
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.00062012672424316
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00054192543029785
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0003 0.00026988983154297
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
111 0.0081 0.0080580711364746
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 1513 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
112 0.0006 0.0005638599395752
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 1513 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0005 0.00051212310791016
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 1513 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0015 0.0015120506286621
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
115 0.0004 0.0003819465637207
SELECT * FROM product_image_select WHERE product_id = '858'
116 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '858'
117 0.0010 0.0010421276092529
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
118 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0006 0.00055885314941406
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0011 0.0010578632354736
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
122 0.0004 0.00044393539428711
SELECT * FROM product_image_select WHERE product_id = '878'
123 0.0004 0.00035190582275391
SELECT * FROM productcustomimages WHERE product_id = '878'
124 0.0009 0.00092816352844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
125 0.0004 0.00042986869812012
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0010 0.00098395347595215
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
129 0.0004 0.00036096572875977
SELECT * FROM product_image_select WHERE product_id = '862'
130 0.0003 0.00032305717468262
SELECT * FROM productcustomimages WHERE product_id = '862'
131 0.0008 0.00080990791320801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
132 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00043416023254395
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00043582916259766
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0004 0.00035691261291504
SELECT id,asin FROM products WHERE parent_id = 1513
136 0.0003 0.00026798248291016
SELECT category_id FROM products_categories WHERE product_id = '1513'
137 0.0003 0.00028681755065918
SELECT * FROM categories WHERE id = '27'
138 0.0002 0.00023412704467773
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
139 0.0002 0.00024604797363281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
140 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '27'
141 0.0003 0.00034999847412109
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 
142 0.0003 0.00030016899108887
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 
143 0.0003 0.00033879280090332
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
144 0.0009 0.00093388557434082
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
145 0.0003 0.00025796890258789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
146 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0003 0.00032591819763184
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00052905082702637
SELECT * FROM products WHERE id = '1513'
149 0.0002 0.00024509429931641
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0002 0.00024914741516113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
151 0.0003 0.00026917457580566
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00028419494628906
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00038385391235352
SELECT category_id FROM products_categories WHERE product_id = '1513' AND prod_type = 'amz'
154 0.0004 0.00038409233093262
SELECT parent_id FROM categories WHERE id = '27'
155 0.0003 0.00032711029052734
SELECT * FROM categories WHERE id = '27'
156 0.0002 0.0002439022064209
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
157 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
158 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '27'
159 0.0003 0.00026106834411621
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 
160 0.0003 0.00029921531677246
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 
161 0.0003 0.00029706954956055
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
162 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
163 0.0005 0.00054192543029785
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
164 0.0004 0.00043606758117676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
165 0.0003 0.00033712387084961
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
166 0.0005 0.0005040168762207
SELECT * FROM pages WHERE id = 38
167 0.0049 0.0049340724945068
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
168 0.0013 0.001255989074707
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:1653092118;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
169 0.0005 0.00046801567077637
SELECT * FROM products WHERE id = 788
170 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = 787
171 0.0005 0.00048303604125977
SELECT * FROM products WHERE id = 1287
172 0.0005 0.00051593780517578
SELECT * FROM products WHERE id = 780
173 0.0004 0.00044488906860352
SELECT * FROM products WHERE id = 777
174 0.0005 0.00051593780517578
SELECT * FROM products WHERE id = 776
175 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = '788'
176 0.0020 0.0019760131835938
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
177 0.0004 0.00038313865661621
SELECT * FROM product_image_select WHERE product_id = '788'
178 0.0003 0.00033307075500488
SELECT * FROM productcustomimages WHERE product_id = '788'
179 0.0012 0.0011579990386963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
180 0.0006 0.00055384635925293
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0006 0.00057601928710938
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0005 0.00050091743469238
SELECT * FROM products WHERE id = '787'
184 0.0012 0.0011658668518066
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
185 0.0004 0.00043511390686035
SELECT * FROM product_image_select WHERE product_id = '787'
186 0.0004 0.00040698051452637
SELECT * FROM productcustomimages WHERE product_id = '787'
187 0.0014 0.001356840133667
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
188 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0006 0.00057506561279297
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0005 0.00049710273742676
SELECT * FROM products WHERE id = '1287'
192 0.0012 0.0011870861053467
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
193 0.0004 0.0004119873046875
SELECT * FROM product_image_select WHERE product_id = '1287'
194 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1287'
195 0.0013 0.0013000965118408
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
196 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0006 0.00056886672973633
SELECT * FROM products WHERE id = '780'
200 0.0010 0.0010378360748291
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
201 0.0004 0.00036501884460449
SELECT * FROM product_image_select WHERE product_id = '780'
202 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '780'
203 0.0008 0.00076889991760254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
204 0.0004 0.00038909912109375
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0005 0.00047898292541504
SELECT * FROM products WHERE id = '777'
208 0.0010 0.0010180473327637
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
209 0.0004 0.00040483474731445
SELECT * FROM product_image_select WHERE product_id = '777'
210 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '777'
211 0.0009 0.00089812278747559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
212 0.0005 0.00047016143798828
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0006 0.00058102607727051
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = '776'
216 0.0010 0.00095701217651367
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
217 0.0004 0.00037789344787598
SELECT * FROM product_image_select WHERE product_id = '776'
218 0.0003 0.00034689903259277
SELECT * FROM productcustomimages WHERE product_id = '776'
219 0.0010 0.00098299980163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
220 0.0004 0.00038814544677734
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0005 0.00051093101501465
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0007 0.00068902969360352
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
224 0.0006 0.00063204765319824
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
225 0.0011 0.0010628700256348
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
226 0.0007 0.00067615509033203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
227 0.0004 0.00035405158996582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
228 0.0008 0.00077295303344727
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
229 0.0003 0.00033903121948242
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
230 0.0071 0.0071330070495605
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'