Dragonfly Fairtrade Rooibos Tea Bags 40 per pack

Dragonfly Fairtrade Rooibos Tea Bags 40 per pack
Dragonfly Fairtrade Rooibos Tea Bags 40 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 2022-05-28 21:51:16 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

Organique 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.71116805076599 240 0.1872 0


No Amazon API Requests Made.

Total time 0.71116805076599 seconds

Number Time From Start Name Description
1 0.49328994750977 Initialise Initialise FSB Function
2 0.49564790725708 App Controller Start Start of the App controller (called before the controller of every page)
3 0.49878406524658 Start of getCategoryListByGroup Function Before first category groups query
4 0.49908304214478 After initial query Before first category groups query
5 0.49908399581909 Get Category List for Group Before the call to getCategoryList function
6 0.49908709526062 Start of GetCategoryList function Start of the function
7 0.49908995628357 Before getting categories Query to get specific category list
8 0.49958205223083 After getting categories Query to get specific category list
9 0.49958395957947 Before getting category custom Before call to function getCategoryCustom
10 0.52089095115662 After getting category custom After call to function getCategoryCustom
11 0.52089405059814 Before getting category custom Before call to function getCategoryCustom
12 0.53312492370605 After getting category custom After call to function getCategoryCustom
13 0.53312706947327 Before getting category custom Before call to function getCategoryCustom
14 0.54024195671082 After getting category custom After call to function getCategoryCustom
15 0.54024410247803 Before getting category custom Before call to function getCategoryCustom
16 0.54378199577332 After getting category custom After call to function getCategoryCustom
17 0.54378390312195 Before getting category custom Before call to function getCategoryCustom
18 0.54798007011414 After getting category custom After call to function getCategoryCustom
19 0.54798197746277 Before getting category custom Before call to function getCategoryCustom
20 0.55346393585205 After getting category custom After call to function getCategoryCustom
21 0.55346703529358 End of GetCategoryList function End of the function
22 0.55347108840942 End of getCategoryListByGroup Function Before return()
23 0.56006693840027 App Controller End End of the App controller (called before the controller of every page)
24 0.56013703346252 Product Start Start of the product info controller
25 0.56270790100098 Cache file not found Starting get product details
26 0.60442209243774 Related products Start getting related products if enabled
27 0.60442304611206 Related Products Start Before the related products are found
28 0.60442399978638 Related Products Keywords Before the related product keywords are found
29 0.60442805290222 Create Keyword List Function Start of function
30 0.60445094108582 Create Keyword List Function After looping provided content - 21 keywords found
31 0.60521197319031 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
32 0.60521793365479 Create Keyword List Function After reducing keyword list
33 0.60525298118591 Create Keyword List Function After selecting by scoring keywords
34 0.60525488853455 Create Keyword List Function After final loop of keywords
35 0.60525703430176 Related Products Keywords After the related product keywords are found
36 0.62545299530029 Related Products End After the related products are found
37 0.64086699485779 Product End End of the product info controller (Product Info)
38 0.64157104492188 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.64220595359802 Before Get Options Before the call to getOptions in the tpl class
40 0.68210291862488 After Get Options After the call to getOptions in the tpl class
41 0.68216991424561 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.68218994140625 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.69149303436279 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.69149708747864 Product Info: Before Template Display Before the template is displayed
45 0.71114897727966 Product Info: After Template Display After the template is displayed
46 0.71115303039551 Finalizing debug Before the debug is output to the page.
47 0.71116709709167 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.1872 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00074291229248047
SELECT parameter, value FROM parameters
2 0.0012 0.001183032989502
SELECT * FROM `bad_bots`
3 0.0007 0.00066709518432617
SET time_zone = 'Europe/London'
4 0.0005 0.00046205520629883
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0026 0.0026421546936035
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.244.12\";}'
6 0.0014 0.0014050006866455
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653813502'
7 0.0005 0.00050806999206543
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00033211708068848
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0008 0.00083589553833008
SELECT id FROM pages WHERE pagename = 'dragonfly-fairtrade-rooibos-tea-bags-40-per-pack' LIMIT 1
10 0.0007 0.00070405006408691
SELECT id FROM products WHERE pagename = 'dragonfly-fairtrade-rooibos-tea-bags-40-per-pack' AND hidden = 0 LIMIT 1
11 0.0014 0.0014221668243408
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00075006484985352
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00058507919311523
SELECT * FROM pages WHERE pagename = 'dragonfly-fairtrade-rooibos-tea-bags-40-per-pack'
14 0.0003 0.00028705596923828
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00046992301940918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0110 0.010995864868164
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.0004 0.0004279613494873
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.0004 0.0004279613494873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00049781799316406
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0068140029907227
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.0006 0.00059294700622559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0006 0.00058603286743164
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.0005 0.00048184394836426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00034308433532715
SELECT * FROM categorygroups WHERE id = '1'
25 0.0049 0.004863977432251
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.0005 0.00045013427734375
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.00023794174194336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.0004429817199707
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0042998790740967
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.0003 0.00031590461730957
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.0005 0.00051403045654297
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.0005 0.0005040168762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00046086311340332
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018429756164551
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.0005 0.00046300888061523
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.0007 0.00065302848815918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00052118301391602
SELECT id FROM categories WHERE parent_id = '28'
38 0.0022 0.0021829605102539
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.00024890899658203
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.00026583671569824
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.0005 0.00045680999755859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00034213066101074
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00081801414489746
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.0005 0.00049304962158203
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.00023818016052246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064802169799805
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.00023889541625977
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.00024604797363281
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.00022482872009277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.0003058910369873
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00076198577880859
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.0004 0.00041508674621582
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.0005 0.00045609474182129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00046014785766602
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.0006868839263916
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.0003 0.00028896331787109
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.0003 0.00032901763916016
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.0003 0.00026392936706543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00040507316589355
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00087690353393555
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.0005 0.00053000450134277
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0006 0.00063490867614746
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00052094459533691
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0010559558868408
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.0005 0.00054001808166504
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.0005 0.0004570484161377
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.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00026893615722656
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00044894218444824
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00027918815612793
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00054502487182617
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.0005 0.00053620338439941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0009 0.00091814994812012
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00071501731872559
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00033187866210938
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.244.12') >= INET_ATON(ip_start) AND INET_ATON('34.231.244.12') <= INET_ATON(ip_end)
77 0.0005 0.00046992301940918
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0006 0.00055098533630371
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00094199180603027
SELECT * FROM products WHERE pagename = 'dragonfly-fairtrade-rooibos-tea-bags-40-per-pack'
80 0.0010 0.00096893310546875
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1259
81 0.0004 0.00040888786315918
SELECT * FROM manufacturers WHERE id = '243'
82 0.0009 0.00091910362243652
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
83 0.0005 0.00054407119750977
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
84 0.0013 0.001349925994873
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.0017 0.0017058849334717
SELECT * FROM productimages WHERE product_id = '2460' ORDER BY sortorder ASC
86 0.0005 0.00047516822814941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
87 0.0010 0.0010249614715576
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.0005 0.00048995018005371
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
89 0.0008 0.00075197219848633
SELECT category_id FROM products_categories WHERE product_id = '1259'
90 0.0005 0.00054502487182617
SELECT * FROM categories WHERE id = '27'
91 0.0063 0.0062651634216309
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.0005 0.00047898292541504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0005 0.00054216384887695
SELECT id FROM categories WHERE parent_id = '27'
94 0.0047 0.0047221183776855
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.0005 0.00046515464782715
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.0005 0.00045299530029297
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.0005 0.00049495697021484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0016 0.0016109943389893
SELECT * FROM productimages WHERE product_id = '1259' ORDER BY sortorder ASC
99 0.0006 0.00064420700073242
SELECT * FROM product_image_select WHERE product_id = '1259'
100 0.0008 0.00075006484985352
SELECT * FROM productcustomimages WHERE product_id = '1259'
101 0.0006 0.00062203407287598
SELECT * FROM productfeeds WHERE product_id = '1259' ORDER BY item_date DESC
102 0.0017 0.0017430782318115
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1259' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0013 0.0013258457183838
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1259' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00049495697021484
SELECT * FROM tags WHERE id = '1'
105 0.0020 0.0020349025726318
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.0018 0.0017769336700439
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.0020 0.0020320415496826
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.0005 0.00049805641174316
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
109 0.0006 0.00059199333190918
SELECT * FROM productamazoncontent WHERE product_id = '1259'
110 0.0018 0.0017950534820557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1259' AND a.name = n.originalname
111 0.0006 0.00061202049255371
SELECT * FROM productoffers WHERE product_id = '1259' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0006 0.00064301490783691
SELECT * FROM productoffers
                WHERE product_id = '1259' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00053787231445312
SELECT * FROM productoffers
                WHERE product_id = 1259
                ORDER BY price ASC LIMIT 1
114 0.0006 0.00057792663574219
SELECT value FROM productattributes
                WHERE product_id = '1259'
                AND name = 'ListPriceAmount'
115 0.0005 0.00054693222045898
SELECT value FROM productattributes WHERE product_id = '1259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0005 0.00046706199645996
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
117 0.0081 0.0080630779266357
SELECT *, MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AND 1259 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
118 0.0006 0.00063490867614746
SELECT *, MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AND 1259 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0007 0.00070810317993164
SELECT *, MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dragonfly fairtrade rooibos' IN BOOLEAN MODE) AND 1259 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0003 0.0002601146697998
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0003 0.00027084350585938
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0006 0.00055599212646484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0006 0.0006108283996582
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0007 0.00069499015808105
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00032591819763184
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00045919418334961
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
128 0.0003 0.00032615661621094
SELECT * FROM product_image_select WHERE product_id = '858'
129 0.0003 0.00034523010253906
SELECT * FROM productcustomimages WHERE product_id = '858'
130 0.0005 0.00052905082702637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
131 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0008 0.00084614753723145
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0005 0.00049090385437012
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
135 0.0005 0.00045585632324219
SELECT * FROM product_image_select WHERE product_id = '878'
136 0.0004 0.00044107437133789
SELECT * FROM productcustomimages WHERE product_id = '878'
137 0.0005 0.00053906440734863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
138 0.0005 0.00047779083251953
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00053191184997559
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0003 0.00027990341186523
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0005 0.00047779083251953
SELECT id,asin FROM products WHERE parent_id = 1259
142 0.0005 0.00048089027404785
SELECT category_id FROM products_categories WHERE product_id = '1259'
143 0.0006 0.00055289268493652
SELECT * FROM categories WHERE id = '27'
144 0.0004 0.00044488906860352
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
145 0.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
146 0.0005 0.00052785873413086
SELECT id FROM categories WHERE parent_id = '27'
147 0.0006 0.00061607360839844
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 
148 0.0005 0.00049901008605957
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 
149 0.0005 0.00047397613525391
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
150 0.0005 0.00046706199645996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
151 0.0004 0.00037789344787598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1259' AND a.name = n.originalname
152 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '1259' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '1259' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = 1259
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00042891502380371
SELECT value FROM productattributes
                WHERE product_id = '1259'
                AND name = 'ListPriceAmount'
156 0.0008 0.00075411796569824
SELECT * FROM products WHERE id = '1259'
157 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '1259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0004 0.00040888786315918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1259' AND a.name = n.originalname
159 0.0004 0.00036311149597168
SELECT * FROM productoffers WHERE product_id = '1259' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0004 0.00040507316589355
SELECT * FROM productoffers
                WHERE product_id = '1259' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00049209594726562
SELECT * FROM productoffers
                WHERE product_id = 1259
                ORDER BY price ASC LIMIT 1
162 0.0005 0.00046300888061523
SELECT value FROM productattributes
                WHERE product_id = '1259'
                AND name = 'ListPriceAmount'
163 0.0009 0.00088405609130859
SELECT category_id FROM products_categories WHERE product_id = '1259' AND prod_type = 'amz'
164 0.0004 0.00043106079101562
SELECT parent_id FROM categories WHERE id = '27'
165 0.0005 0.00045895576477051
SELECT * FROM categories WHERE id = '27'
166 0.0004 0.00044488906860352
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
167 0.0003 0.00034308433532715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '27'
169 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 (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
170 0.0003 0.00034189224243164
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 
171 0.0003 0.00026702880859375
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
172 0.0002 0.00024890899658203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0004 0.00042581558227539
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
174 0.0003 0.0002598762512207
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
175 0.0003 0.00031089782714844
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
176 0.0004 0.00039792060852051
SELECT * FROM pages WHERE id = 38
177 0.0053 0.0052759647369385
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
178 0.0009 0.00090599060058594
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:1653813503;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'
179 0.0008 0.0008089542388916
SELECT * FROM products WHERE id = 788
180 0.0009 0.00087213516235352
SELECT * FROM products WHERE id = 787
181 0.0007 0.00073695182800293
SELECT * FROM products WHERE id = 1287
182 0.0005 0.00048995018005371
SELECT * FROM products WHERE id = 780
183 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = 777
184 0.0007 0.0006558895111084
SELECT * FROM products WHERE id = 776
185 0.0006 0.00061893463134766
SELECT * FROM products WHERE id = '788'
186 0.0004 0.0004122257232666
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
187 0.0004 0.00042200088500977
SELECT * FROM product_image_select WHERE product_id = '788'
188 0.0003 0.00032496452331543
SELECT * FROM productcustomimages WHERE product_id = '788'
189 0.0003 0.00029087066650391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
190 0.0004 0.00043916702270508
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0005 0.00045490264892578
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0007 0.00066518783569336
SELECT * FROM products WHERE id = '787'
194 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
195 0.0005 0.0005180835723877
SELECT * FROM product_image_select WHERE product_id = '787'
196 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '787'
197 0.0003 0.00033307075500488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
198 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0006 0.00057411193847656
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0008 0.00080204010009766
SELECT * FROM products WHERE id = '1287'
202 0.0005 0.00049400329589844
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
203 0.0004 0.00040698051452637
SELECT * FROM product_image_select WHERE product_id = '1287'
204 0.0006 0.00057697296142578
SELECT * FROM productcustomimages WHERE product_id = '1287'
205 0.0006 0.00058484077453613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
206 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0006 0.00062918663024902
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0007 0.00068378448486328
SELECT * FROM products WHERE id = '780'
210 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
211 0.0004 0.00040912628173828
SELECT * FROM product_image_select WHERE product_id = '780'
212 0.0006 0.00057291984558105
SELECT * FROM productcustomimages WHERE product_id = '780'
213 0.0006 0.00064611434936523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
214 0.0006 0.00061702728271484
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0005 0.00049185752868652
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0007 0.0007319450378418
SELECT * FROM products WHERE id = '777'
218 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
219 0.0004 0.00042891502380371
SELECT * FROM product_image_select WHERE product_id = '777'
220 0.0005 0.00054788589477539
SELECT * FROM productcustomimages WHERE product_id = '777'
221 0.0005 0.0005030632019043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
222 0.0004 0.00044798851013184
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0004 0.00043988227844238
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0008 0.00079894065856934
SELECT * FROM products WHERE id = '776'
226 0.0004 0.00044107437133789
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
227 0.0005 0.0005030632019043
SELECT * FROM product_image_select WHERE product_id = '776'
228 0.0005 0.00047802925109863
SELECT * FROM productcustomimages WHERE product_id = '776'
229 0.0005 0.00048613548278809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
230 0.0004 0.00041079521179199
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00041413307189941
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0004 0.00042986869812012
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
234 0.0004 0.00041890144348145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
235 0.0007 0.00072312355041504
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
236 0.0004 0.00035810470581055
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0004 0.00038790702819824
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
238 0.0005 0.00046014785766602
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0003 0.00034594535827637
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
240 0.0004 0.00044918060302734
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'