Dragonfly Rooibos Vanilla Tea 40 per pack

Dragonfly Rooibos Vanilla Tea 40 per pack
Dragonfly Rooibos Vanilla Tea 40 per pack (cliquez sur les images pour élargir)
€9,87
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 00:47:03 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

Conserver dans un endroit frais et sec Pays d'origine: Afrique du Sud. Rooibos
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.76520299911499 254 0.1505 0


No Amazon API Requests Made.

Total time 0.76520299911499 seconds

Number Time From Start Name Description
1 0.54585003852844 Initialise Initialise FSB Function
2 0.54847717285156 App Controller Start Start of the App controller (called before the controller of every page)
3 0.55200505256653 Start of getCategoryListByGroup Function Before first category groups query
4 0.55234599113464 After initial query Before first category groups query
5 0.55234813690186 Get Category List for Group Before the call to getCategoryList function
6 0.5523521900177 Start of GetCategoryList function Start of the function
7 0.55235600471497 Before getting categories Query to get specific category list
8 0.55278611183167 After getting categories Query to get specific category list
9 0.5527880191803 Before getting category custom Before call to function getCategoryCustom
10 0.55447101593018 After getting category custom After call to function getCategoryCustom
11 0.55447316169739 Before getting category custom Before call to function getCategoryCustom
12 0.56723308563232 After getting category custom After call to function getCategoryCustom
13 0.56723618507385 Before getting category custom Before call to function getCategoryCustom
14 0.57277703285217 After getting category custom After call to function getCategoryCustom
15 0.5727801322937 Before getting category custom Before call to function getCategoryCustom
16 0.57545614242554 After getting category custom After call to function getCategoryCustom
17 0.57545900344849 Before getting category custom Before call to function getCategoryCustom
18 0.57794308662415 After getting category custom After call to function getCategoryCustom
19 0.57794499397278 Before getting category custom Before call to function getCategoryCustom
20 0.58033108711243 After getting category custom After call to function getCategoryCustom
21 0.58033418655396 End of GetCategoryList function End of the function
22 0.58033919334412 End of getCategoryListByGroup Function Before return()
23 0.58544707298279 App Controller End End of the App controller (called before the controller of every page)
24 0.58599305152893 Product Start Start of the product info controller
25 0.59852814674377 Cache file not found Starting get product details
26 0.62941718101501 Related products Start getting related products if enabled
27 0.62941908836365 Related Products Start Before the related products are found
28 0.62942004203796 Related Products Keywords Before the related product keywords are found
29 0.62942504882812 Create Keyword List Function Start of function
30 0.62945413589478 Create Keyword List Function After looping provided content - 18 keywords found
31 0.63013219833374 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
32 0.63013911247253 Create Keyword List Function After reducing keyword list
33 0.63017821311951 Create Keyword List Function After selecting by scoring keywords
34 0.63018202781677 Create Keyword List Function After final loop of keywords
35 0.63018417358398 Related Products Keywords After the related product keywords are found
36 0.68074703216553 Related Products End After the related products are found
37 0.68717122077942 Product End End of the product info controller (Product Info)
38 0.68801021575928 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.68840718269348 Before Get Options Before the call to getOptions in the tpl class
40 0.71299910545349 After Get Options After the call to getOptions in the tpl class
41 0.71308612823486 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.71311616897583 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.73311614990234 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.7331211566925 Product Info: Before Template Display Before the template is displayed
45 0.76517105102539 Product Info: After Template Display After the template is displayed
46 0.76518702507019 Finalizing debug Before the debug is output to the page.
47 0.76520204544067 End of App This is the end of the app logging, final timestamp


Query Debug - 254 Database Queries. Total time 0.1505 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00052905082702637
SELECT parameter, value FROM parameters
2 0.0013 0.0013179779052734
SELECT * FROM `bad_bots`
3 0.0004 0.0003969669342041
SET time_zone = 'Europe/London'
4 0.0003 0.0002601146697998
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0020980834960938
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0013 0.0012500286102295
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628124621'
7 0.0009 0.00093793869018555
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00027990341186523
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00071406364440918
SELECT id FROM pages WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack-1294335424' LIMIT 1
10 0.0008 0.0008080005645752
SELECT id FROM products WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack-1294335424' AND hidden = 0 LIMIT 1
11 0.0016 0.0015590190887451
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.0009310245513916
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00062108039855957
SELECT * FROM pages WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack-1294335424'
14 0.0003 0.00032401084899902
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00040888786315918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00017714500427246
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.0002 0.00017905235290527
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.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00016880035400391
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.0001678466796875
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.0002 0.00018692016601562
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.0001680850982666
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00017309188842773
SELECT * FROM categorygroups WHERE id = '1'
25 0.0058 0.0057940483093262
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.0002 0.00020194053649902
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.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00017905235290527
SELECT id FROM categories WHERE parent_id = '27'
29 0.0055 0.005486011505127
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.00021004676818848
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.00020194053649902
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.00023293495178223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0019960403442383
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.0002 0.00024008750915527
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.00017690658569336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.002018928527832
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.00019502639770508
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.0003 0.00026893615722656
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.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00066018104553223
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.00017285346984863
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.00016212463378906
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00068998336791992
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.00019001960754395
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.00017690658569336
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.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016307830810547
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00061607360839844
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.00018405914306641
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.00017690658569336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00015997886657715
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.0005950927734375
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.0002 0.00016903877258301
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.00016307830810547
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.00016117095947266
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00015687942504883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00059890747070312
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.00016212463378906
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.0001518726348877
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.0005340576171875
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.00020003318786621
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.00015997886657715
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.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00015997886657715
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00019717216491699
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.0002291202545166
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00031018257141113
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.00018095970153809
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00049304962158203
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.0005648136138916
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00023293495178223
SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
77 0.0002 0.00018906593322754
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00017690658569336
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00046300888061523
SELECT * FROM products WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack-1294335424'
80 0.0006 0.00060701370239258
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4222
81 0.0007 0.00070381164550781
SELECT * FROM manufacturers WHERE id = '243'
82 0.0007 0.00070881843566895
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
83 0.0004 0.00040793418884277
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
84 0.0014 0.0013589859008789
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.0019 0.0018899440765381
SELECT * FROM productimages WHERE product_id = '1438' ORDER BY sortorder ASC
86 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
87 0.0007 0.00072789192199707
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.0004 0.00039386749267578
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
89 0.0003 0.0002899169921875
SELECT category_id FROM products_categories WHERE product_id = '4222'
90 0.0002 0.00024795532226562
SELECT * FROM categories WHERE id = '27'
91 0.0046 0.004633903503418
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.00017404556274414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00016689300537109
SELECT id FROM categories WHERE parent_id = '27'
94 0.0046 0.0046169757843018
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.0002 0.00024199485778809
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.0002 0.00016999244689941
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0009 0.00089883804321289
SELECT * FROM productimages WHERE product_id = '4222' ORDER BY sortorder ASC
99 0.0004 0.00044584274291992
SELECT * FROM product_image_select WHERE product_id = '4222'
100 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '4222'
101 0.0004 0.0003819465637207
SELECT * FROM productfeeds WHERE product_id = '4222' ORDER BY item_date DESC
102 0.0007 0.00067496299743652
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0010 0.00097203254699707
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4222' AND t.hidden = 0 AND display_product = 1
104 0.0003 0.00025486946105957
SELECT * FROM tags WHERE id = '1'
105 0.0017 0.001708984375
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0017 0.0016658306121826
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0019 0.0019209384918213
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0003 0.00027322769165039
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
109 0.0007 0.00070095062255859
SELECT * FROM productamazoncontent WHERE product_id = '4222'
110 0.0008 0.00083518028259277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
111 0.0005 0.00046014785766602
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = 4222
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '4222'
                AND name = 'ListPriceAmount'
115 0.0002 0.0001838207244873
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
116 0.0078 0.0077590942382812
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 4222 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
117 0.0008 0.00075292587280273
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 4222 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0009 0.00088191032409668
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 4222 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0011 0.0010900497436523
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
120 0.0003 0.00032901763916016
SELECT * FROM product_image_select WHERE product_id = '2521'
121 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '2521'
122 0.0021 0.0020830631256104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
123 0.0003 0.00034189224243164
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0003 0.00032210350036621
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
127 0.0002 0.00018787384033203
SELECT * FROM product_image_select WHERE product_id = '858'
128 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '858'
129 0.0003 0.00030612945556641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
130 0.0002 0.00023007392883301
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0003 0.00030803680419922
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0081 0.008059024810791
SELECT *, MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AND 4222 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
134 0.0006 0.00060200691223145
SELECT *, MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AND 4222 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
135 0.0004 0.00042510032653809
SELECT *, MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dragonfly rooibos vanilla' IN BOOLEAN MODE) AND 4222 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
136 0.0003 0.00032281875610352
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
137 0.0002 0.00017404556274414
SELECT * FROM product_image_select WHERE product_id = '858'
138 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '858'
139 0.0002 0.0002138614654541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
140 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0003 0.00030612945556641
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0016 0.0015549659729004
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '4222') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
144 0.0134 0.013411998748779
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '4222' ORDER BY RAND()
145 0.0007 0.00073504447937012
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '4222' ORDER BY RAND()
146 0.0006 0.00064301490783691
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '4222' ORDER BY RAND()
147 0.0011 0.0010900497436523
SELECT * FROM productimages WHERE product_id = '944' ORDER BY sortorder ASC
148 0.0003 0.00031399726867676
SELECT * FROM product_image_select WHERE product_id = '944'
149 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '944'
150 0.0010 0.00098705291748047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '944' AND a.name = n.originalname
151 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '944' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00033283233642578
SELECT * FROM productoffers
                WHERE product_id = '944' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00030708312988281
SELECT * FROM productoffers
                WHERE product_id = 944
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00031304359436035
SELECT value FROM productattributes
                WHERE product_id = '944'
                AND name = 'ListPriceAmount'
155 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0003 0.00026392936706543
SELECT id,asin FROM products WHERE parent_id = 4222
157 0.0002 0.00022220611572266
SELECT category_id FROM products_categories WHERE product_id = '4222'
158 0.0002 0.00019383430480957
SELECT * FROM categories WHERE id = '27'
159 0.0002 0.00015020370483398
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
160 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
161 0.0002 0.00015115737915039
SELECT id FROM categories WHERE parent_id = '27'
162 0.0002 0.00015902519226074
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 
163 0.0002 0.00017499923706055
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 
164 0.0002 0.00015497207641602
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
165 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
166 0.0002 0.00016498565673828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
167 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0002 0.00016999244689941
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = 4222
                ORDER BY price ASC LIMIT 1
170 0.0002 0.00016403198242188
SELECT value FROM productattributes
                WHERE product_id = '4222'
                AND name = 'ListPriceAmount'
171 0.0005 0.00050091743469238
SELECT * FROM products WHERE id = '4222'
172 0.0002 0.00018000602722168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
173 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0002 0.00016999244689941
SELECT * FROM productoffers
                WHERE product_id = 4222
                ORDER BY price ASC LIMIT 1
176 0.0002 0.0001680850982666
SELECT value FROM productattributes
                WHERE product_id = '4222'
                AND name = 'ListPriceAmount'
177 0.0003 0.00026488304138184
SELECT category_id FROM products_categories WHERE product_id = '4222' AND prod_type = 'amz'
178 0.0002 0.00017404556274414
SELECT parent_id FROM categories WHERE id = '27'
179 0.0002 0.00022006034851074
SELECT * FROM categories WHERE id = '27'
180 0.0002 0.00015711784362793
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
181 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
182 0.0002 0.00017309188842773
SELECT id FROM categories WHERE parent_id = '27'
183 0.0002 0.00016593933105469
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 
184 0.0002 0.00016021728515625
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 
185 0.0002 0.00015807151794434
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
186 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
187 0.0002 0.00022506713867188
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
188 0.0002 0.00015091896057129
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
189 0.0002 0.00018095970153809
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
190 0.0002 0.00024509429931641
SELECT * FROM pages WHERE id = 38
191 0.0041 0.0040900707244873
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
192 0.0004 0.0003960132598877
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:1628124622;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:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
193 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = 790
194 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = 788
195 0.0005 0.00048112869262695
SELECT * FROM products WHERE id = 787
196 0.0005 0.00050187110900879
SELECT * FROM products WHERE id = 1287
197 0.0006 0.00055503845214844
SELECT * FROM products WHERE id = 777
198 0.0005 0.00047683715820312
SELECT * FROM products WHERE id = 776
199 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = '790'
200 0.0004 0.00041699409484863
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
201 0.0002 0.00017499923706055
SELECT * FROM product_image_select WHERE product_id = '790'
202 0.0002 0.00021600723266602
SELECT * FROM productcustomimages WHERE product_id = '790'
203 0.0002 0.00019598007202148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
204 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0003 0.00030398368835449
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0004 0.00040292739868164
SELECT * FROM products WHERE id = '788'
208 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
209 0.0003 0.00025415420532227
SELECT * FROM product_image_select WHERE product_id = '788'
210 0.0003 0.00034689903259277
SELECT * FROM productcustomimages WHERE product_id = '788'
211 0.0002 0.00020599365234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
212 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00023198127746582
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.00041317939758301
SELECT * FROM products WHERE id = '787'
216 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
217 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '787'
218 0.0002 0.0002138614654541
SELECT * FROM productcustomimages WHERE product_id = '787'
219 0.0002 0.00018692016601562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
220 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00021505355834961
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = '1287'
224 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
225 0.0002 0.00016903877258301
SELECT * FROM product_image_select WHERE product_id = '1287'
226 0.0002 0.00018811225891113
SELECT * FROM productcustomimages WHERE product_id = '1287'
227 0.0002 0.00018906593322754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
228 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0005 0.00047492980957031
SELECT * FROM products WHERE id = '777'
232 0.0002 0.00023412704467773
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0002 0.00017213821411133
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0002 0.00018906593322754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0003 0.00032615661621094
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0004 0.00043201446533203
SELECT * FROM products WHERE id = '776'
240 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
241 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '776'
242 0.0002 0.00018215179443359
SELECT * FROM productcustomimages WHERE product_id = '776'
243 0.0002 0.00019717216491699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
244 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0002 0.00022101402282715
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0003 0.00028300285339355
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
248 0.0004 0.00038790702819824
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
249 0.0005 0.00046396255493164
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
250 0.0004 0.00039386749267578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
251 0.0004 0.00039100646972656
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
252 0.0006 0.00060701370239258
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
253 0.0005 0.00051093101501465
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
254 0.0004 0.00036001205444336
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'