0

Fairtrade Libellule Sacs De Thé Rooibos 40 Par Paquet

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-09 07:30:13 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

Fairtrade Libellule Sacs De Thé Rooibos 40 Par Paquet Quantité: 1

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2089040279388 264 0.9777 0


No Amazon API Requests Made.


App Debug - Total Time 1.2089040279388 seconds

Number Time From Start Name Description
1 0.20581007003784 Initialise Initialise FSB Function
2 0.20708799362183 App Controller Start Start of the App controller (called before the controller of every page)
3 0.22856903076172 Start of getCategoryListByGroup Function Before first category groups query
4 0.22893500328064 After initial query Before first category groups query
5 0.22893595695496 Get Category List for Group Before the call to getCategoryList function
6 0.22893691062927 Start of GetCategoryList function Start of the function
7 0.22893786430359 Before getting categories Query to get specific category list
8 0.22930502891541 After getting categories Query to get specific category list
9 0.22930598258972 Before getting category custom Before call to function getCategoryCustom
10 0.24277591705322 After getting category custom After call to function getCategoryCustom
11 0.24277806282043 Before getting category custom Before call to function getCategoryCustom
12 0.26146006584167 After getting category custom After call to function getCategoryCustom
13 0.26146292686462 Before getting category custom Before call to function getCategoryCustom
14 0.27159190177917 After getting category custom After call to function getCategoryCustom
15 0.27159404754639 Before getting category custom Before call to function getCategoryCustom
16 0.27742600440979 After getting category custom After call to function getCategoryCustom
17 0.27742886543274 Before getting category custom Before call to function getCategoryCustom
18 0.28251385688782 After getting category custom After call to function getCategoryCustom
19 0.28251504898071 Before getting category custom Before call to function getCategoryCustom
20 0.28730392456055 After getting category custom After call to function getCategoryCustom
21 0.28730607032776 End of GetCategoryList function End of the function
22 0.28731107711792 Get Category List for Group Before the call to getCategoryList function
23 0.28731203079224 Start of GetCategoryList function Start of the function
24 0.28731298446655 Before getting categories Query to get specific category list
25 0.28780794143677 End of getCategoryListByGroup Function Before return()
26 1.0712509155273 App Controller End End of the App controller (called before the controller of every page)
27 1.0717148780823 Product Start Start of the product info controller
28 1.0765750408173 Cache file not found Starting get product details
29 1.0966410636902 Related products Start getting related products if enabled
30 1.0966410636902 Related Products Start Before the related products are found
31 1.0966420173645 Related Products Keywords Before the related product keywords are found
32 1.0966448783875 Create Keyword List Function Start of function
33 1.0966670513153 Create Keyword List Function After looping provided content - 24 keywords found
34 1.0970768928528 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
35 1.0970818996429 Create Keyword List Function After reducing keyword list
36 1.0971078872681 Create Keyword List Function After selecting by scoring keywords
37 1.0971109867096 Create Keyword List Function After final loop of keywords
38 1.0971119403839 Related Products Keywords After the related product keywords are found
39 1.1253020763397 Related Products End After the related products are found
40 1.1452360153198 Product End End of the product info controller (Product Info)
41 1.1459238529205 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.1465179920197 Before Get Options Before the call to getOptions in the tpl class
43 1.1869418621063 After Get Options After the call to getOptions in the tpl class
44 1.1870150566101 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.1870379447937 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.1900320053101 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.1900339126587 Product Info: Before Template Display Before the template is displayed
48 1.208888053894 Product Info: After Template Display After the template is displayed
49 1.2088959217072 Finalizing debug Before the debug is output to the page.
50 1.2089030742645 End of App This is the end of the app logging, final timestamp


Query Debug - 264 Database Queries. Total time 0.9777 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00080299377441406
SELECT parameter, value FROM parameters
2 0.0023 0.0022990703582764
SELECT * FROM `bad_bots`
3 0.0002 0.00024008750915527
SET time_zone = 'Europe/London'
4 0.0005 0.00052499771118164
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0004 0.00038886070251465
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.53\";}'
6 0.0004 0.00036191940307617
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1752400058'
7 0.0006 0.00056600570678711
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00026392936706543
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00038313865661621
SELECT id FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet' LIMIT 1
10 0.0004 0.00039911270141602
SELECT id FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet' AND hidden = 0 LIMIT 1
11 0.0010 0.0010390281677246
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0198 0.01976203918457
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00037002563476562
SELECT * FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet'
14 0.0004 0.00036287307739258
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00036001205444336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0048 0.004755973815918
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.00036811828613281
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.0003 0.00029301643371582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00030088424682617
SELECT id FROM categories WHERE parent_id = '26'
20 0.0047 0.0046970844268799
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.0004 0.00036406517028809
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.0015 0.0014879703521729
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.0006 0.00061702728271484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00054192543029785
SELECT * FROM categorygroups WHERE id = '1'
25 0.0071 0.0071380138397217
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.0007 0.0007178783416748
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.0005 0.00046586990356445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00054502487182617
SELECT id FROM categories WHERE parent_id = '27'
29 0.0073 0.0073180198669434
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.0007 0.00068402290344238
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.0007 0.00070309638977051
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.0006 0.00056195259094238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049805641174316
SELECT * FROM categorygroups WHERE id = '1'
34 0.0025 0.0024709701538086
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.0006 0.00058388710021973
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.0005 0.00050210952758789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00049591064453125
SELECT id FROM categories WHERE parent_id = '28'
38 0.0032 0.003216028213501
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.0009 0.00086188316345215
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.0008 0.00080585479736328
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.0006 0.0005958080291748
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00052809715270996
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00075197219848633
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.0006 0.00055408477783203
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00051999092102051
SELECT id FROM categories WHERE parent_id = '29'
47 0.0010 0.00096607208251953
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.0006 0.00060701370239258
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.0007 0.0007178783416748
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.0006 0.00063610076904297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00048208236694336
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00079798698425293
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.0006 0.00061607360839844
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.0004 0.00044012069702148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00043320655822754
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00079011917114258
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.0005 0.00053191184997559
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.0005 0.0005338191986084
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.0005 0.0004570484161377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045514106750488
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075697898864746
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.00045680999755859
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.0004 0.00039386749267578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00049400329589844
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00078797340393066
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.00047516822814941
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.00053596496582031
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.00045680999755859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0004119873046875
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00049114227294922
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0027 0.0026769638061523
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00056004524230957
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.0003809928894043
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.0003 0.00029492378234863
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00092005729675293
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00056695938110352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7760 0.77599406242371
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.53') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.53') <= INET_ATON(ip_end)
78 0.0010 0.0009911060333252
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.00031900405883789
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0004 0.00043106079101562
SELECT * FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet'
81 0.0003 0.00030779838562012
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1674
82 0.0004 0.00037002563476562
SELECT * FROM manufacturers WHERE id = '243'
83 0.0004 0.00038480758666992
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
84 0.0003 0.00028705596923828
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
85 0.0005 0.00048398971557617
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.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
87 0.0003 0.0003209114074707
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
88 0.0003 0.0003359317779541
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.0002 0.0001990795135498
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
90 0.0003 0.00029087066650391
SELECT category_id FROM products_categories WHERE product_id = '1674'
91 0.0003 0.00030303001403809
SELECT * FROM categories WHERE id = '27'
92 0.0029 0.0029048919677734
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.00030016899108887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '27'
95 0.0028 0.002842903137207
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.00034403800964355
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.0003 0.00034809112548828
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.0003 0.00029897689819336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '1674' ORDER BY sortorder ASC
100 0.0006 0.00056195259094238
SELECT * FROM product_image_select WHERE product_id = '1674'
101 0.0003 0.00026082992553711
SELECT * FROM productcustomimages WHERE product_id = '1674'
102 0.0003 0.00029897689819336
SELECT * FROM productfeeds WHERE product_id = '1674' ORDER BY item_date DESC
103 0.0005 0.00051999092102051
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0006 0.00056886672973633
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1674' AND t.hidden = 0 AND display_product = 1
105 0.0002 0.0002288818359375
SELECT * FROM tags WHERE id = '1'
106 0.0013 0.0012650489807129
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
107 0.0010 0.0010290145874023
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 
108 0.0010 0.0010170936584473
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
109 0.0004 0.00037789344787598
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0003 0.00029802322387695
SELECT * FROM productamazoncontent WHERE product_id = '1674'
111 0.0006 0.00060796737670898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
112 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
115 0.0002 0.00023913383483887
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
116 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0003 0.00032687187194824
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
118 0.0058 0.0058331489562988
SELECT *, MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AND 1674 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0004 0.00037884712219238
SELECT *, MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AND 1674 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0003 0.00034904479980469
SELECT *, MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('fairtrade libellule sacs' IN BOOLEAN MODE) AND 1674 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
122 0.0005 0.00045013427734375
SELECT * FROM product_image_select WHERE product_id = '1443'
123 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '1443'
124 0.0007 0.00065898895263672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
125 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0003 0.0002601146697998
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0003 0.00031089782714844
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
129 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '1435'
130 0.0003 0.00025606155395508
SELECT * FROM productcustomimages WHERE product_id = '1435'
131 0.0006 0.00059890747070312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
132 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00028800964355469
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0059 0.0058801174163818
SELECT *, MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AND 1674 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
136 0.0004 0.00035691261291504
SELECT *, MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AND 1674 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
137 0.0003 0.00031018257141113
SELECT *, MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé rooibos 40' IN BOOLEAN MODE) AND 1674 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
138 0.0003 0.00029587745666504
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
139 0.0004 0.00042915344238281
SELECT * FROM product_image_select WHERE product_id = '865'
140 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '865'
141 0.0006 0.00057888031005859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
142 0.0003 0.00029921531677246
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0003 0.00033307075500488
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
146 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '862'
147 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '862'
148 0.0006 0.00057601928710938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
149 0.0003 0.00029182434082031
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0003 0.00030612945556641
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
153 0.0004 0.00041890144348145
SELECT * FROM product_image_select WHERE product_id = '878'
154 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '878'
155 0.0006 0.00063300132751465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
156 0.0003 0.00028586387634277
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0003 0.00027704238891602
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0003 0.00034785270690918
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
160 0.0004 0.00041508674621582
SELECT * FROM product_image_select WHERE product_id = '858'
161 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '858'
162 0.0006 0.0006411075592041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
163 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0003 0.00028085708618164
SELECT id,asin FROM products WHERE parent_id = 1674
167 0.0003 0.00027108192443848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1674' ORDER BY timestamp DESC
168 0.0003 0.00027108192443848
SELECT category_id FROM products_categories WHERE product_id = '1674'
169 0.0003 0.00030207633972168
SELECT * FROM categories WHERE id = '27'
170 0.0029 0.0029079914093018
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
171 0.0003 0.00027012825012207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '27'
173 0.0029 0.0028641223907471
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 
174 0.0003 0.0003361701965332
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 
175 0.0003 0.00033807754516602
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
176 0.0003 0.00030112266540527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0006 0.00057697296142578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
178 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00023412704467773
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
182 0.0003 0.00034379959106445
SELECT * FROM products WHERE id = '1674'
183 0.0002 0.00024700164794922
SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0005 0.00047397613525391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
185 0.0002 0.00022196769714355
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
188 0.0002 0.00022506713867188
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
189 0.0003 0.00028586387634277
SELECT category_id FROM products_categories WHERE product_id = '1674' AND prod_type = 'amz'
190 0.0003 0.00026917457580566
SELECT parent_id FROM categories WHERE id = '27'
191 0.0002 0.00021505355834961
SELECT * FROM categories WHERE id = '27'
192 0.0029 0.0028879642486572
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
193 0.0003 0.00027298927307129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
194 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '27'
195 0.0028 0.0028281211853027
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 
196 0.0003 0.00032806396484375
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 
197 0.0003 0.00033402442932129
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
198 0.0003 0.00029492378234863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
199 0.0003 0.00032615661621094
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
200 0.0003 0.00031185150146484
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
201 0.0002 0.00024700164794922
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
202 0.0115 0.011460065841675
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
203 0.0067 0.006655216217041
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
204 0.0006 0.000579833984375
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
205 0.0003 0.00033712387084961
SELECT * FROM products WHERE id = 1626
206 0.0003 0.00025296211242676
SELECT * FROM products WHERE id = 4041
207 0.0002 0.00024795532226562
SELECT * FROM products WHERE id = 4312
208 0.0003 0.00025606155395508
SELECT * FROM products WHERE id = 777
209 0.0002 0.00023913383483887
SELECT * FROM products WHERE id = 3881
210 0.0002 0.0002291202545166
SELECT * FROM products WHERE id = 4213
211 0.0002 0.0002288818359375
SELECT * FROM products WHERE id = '1626'
212 0.0003 0.00029611587524414
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
213 0.0004 0.00042986869812012
SELECT * FROM product_image_select WHERE product_id = '1626'
214 0.0003 0.00025391578674316
SELECT * FROM productcustomimages WHERE product_id = '1626'
215 0.0006 0.00058221817016602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
216 0.0003 0.00030612945556641
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00026416778564453
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0003 0.00033783912658691
SELECT * FROM products WHERE id = '4041'
220 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
221 0.0005 0.00047087669372559
SELECT * FROM product_image_select WHERE product_id = '4041'
222 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '4041'
223 0.0007 0.00067496299743652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
224 0.0003 0.00029706954956055
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0003 0.00030803680419922
SELECT * FROM products WHERE id = '4312'
228 0.0003 0.00028181076049805
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
229 0.0004 0.00043010711669922
SELECT * FROM product_image_select WHERE product_id = '4312'
230 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '4312'
231 0.0006 0.00064682960510254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
232 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0002 0.00024914741516113
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0003 0.00030183792114258
SELECT * FROM products WHERE id = '777'
236 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
237 0.0004 0.00044012069702148
SELECT * FROM product_image_select WHERE product_id = '777'
238 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '777'
239 0.0006 0.00062918663024902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
240 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0003 0.00033998489379883
SELECT * FROM products WHERE id = '3881'
244 0.0003 0.00032711029052734
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
245 0.0004 0.00041413307189941
SELECT * FROM product_image_select WHERE product_id = '3881'
246 0.0002 0.00024986267089844
SELECT * FROM productcustomimages WHERE product_id = '3881'
247 0.0006 0.00064802169799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
248 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0003 0.00032520294189453
SELECT * FROM products WHERE id = '4213'
252 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
253 0.0004 0.00041389465332031
SELECT * FROM product_image_select WHERE product_id = '4213'
254 0.0003 0.00025010108947754
SELECT * FROM productcustomimages WHERE product_id = '4213'
255 0.0007 0.00067901611328125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
256 0.0003 0.00029611587524414
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0005 0.00054597854614258
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
260 0.0005 0.00045084953308105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
261 0.0011 0.0010600090026855
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
262 0.0004 0.00042104721069336
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
263 0.0003 0.00032901763916016
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
264 0.0004 0.00036501884460449
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'