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.5321569442749 259 1.1391 0


No Amazon API Requests Made.


App Debug - Total Time 1.5321569442749 seconds

Number Time From Start Name Description
1 0.37241792678833 Initialise Initialise FSB Function
2 0.38036298751831 App Controller Start Start of the App controller (called before the controller of every page)
3 0.41547894477844 Start of getCategoryListByGroup Function Before first category groups query
4 0.41730093955994 After initial query Before first category groups query
5 0.41730189323425 Get Category List for Group Before the call to getCategoryList function
6 0.41730499267578 Start of GetCategoryList function Start of the function
7 0.41730690002441 Before getting categories Query to get specific category list
8 0.41914105415344 After getting categories Query to get specific category list
9 0.41914105415344 Before getting category custom Before call to function getCategoryCustom
10 0.44270396232605 After getting category custom After call to function getCategoryCustom
11 0.44270586967468 Before getting category custom Before call to function getCategoryCustom
12 0.45516800880432 After getting category custom After call to function getCategoryCustom
13 0.45516991615295 Before getting category custom Before call to function getCategoryCustom
14 0.46132493019104 After getting category custom After call to function getCategoryCustom
15 0.46132588386536 Before getting category custom Before call to function getCategoryCustom
16 0.46529698371887 After getting category custom After call to function getCategoryCustom
17 0.46529698371887 Before getting category custom Before call to function getCategoryCustom
18 0.469398021698 After getting category custom After call to function getCategoryCustom
19 0.46939897537231 Before getting category custom Before call to function getCategoryCustom
20 0.47402691841125 After getting category custom After call to function getCategoryCustom
21 0.47402787208557 End of GetCategoryList function End of the function
22 0.47403192520142 Get Category List for Group Before the call to getCategoryList function
23 0.47403287887573 Start of GetCategoryList function Start of the function
24 0.47403502464294 Before getting categories Query to get specific category list
25 0.47450685501099 End of getCategoryListByGroup Function Before return()
26 1.3071780204773 App Controller End End of the App controller (called before the controller of every page)
27 1.3077929019928 Product Start Start of the product info controller
28 1.3093359470367 Cache file not found Starting get product details
29 1.3656070232391 Related products Start getting related products if enabled
30 1.3656089305878 Related Products Start Before the related products are found
31 1.3656089305878 Related Products Keywords Before the related product keywords are found
32 1.3656139373779 Create Keyword List Function Start of function
33 1.3657150268555 Create Keyword List Function After looping provided content - 24 keywords found
34 1.3662779331207 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
35 1.3662848472595 Create Keyword List Function After reducing keyword list
36 1.366317987442 Create Keyword List Function After selecting by scoring keywords
37 1.3663220405579 Create Keyword List Function After final loop of keywords
38 1.3663229942322 Related Products Keywords After the related product keywords are found
39 1.4149088859558 Related Products End After the related products are found
40 1.4452080726624 Product End End of the product info controller (Product Info)
41 1.4474420547485 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4492828845978 Before Get Options Before the call to getOptions in the tpl class
43 1.5044720172882 After Get Options After the call to getOptions in the tpl class
44 1.5046150684357 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5046429634094 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5147459506989 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5147490501404 Product Info: Before Template Display Before the template is displayed
48 1.5321390628815 Product Info: After Template Display After the template is displayed
49 1.5321459770203 Finalizing debug Before the debug is output to the page.
50 1.5321559906006 End of App This is the end of the app logging, final timestamp


Query Debug - 259 Database Queries. Total time 1.1391 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.002612829208374
SELECT parameter, value FROM parameters
2 0.0040 0.0040311813354492
SELECT * FROM `bad_bots`
3 0.0003 0.00025200843811035
SET time_zone = 'Europe/London'
4 0.0016 0.0015950202941895
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0028 0.0027840137481689
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.222.22.193\";}'
6 0.0015 0.0015380382537842
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746108495'
7 0.0024 0.002418041229248
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00083494186401367
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0029 0.002924919128418
SELECT id FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet' LIMIT 1
10 0.0035 0.0035109519958496
SELECT id FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet' AND hidden = 0 LIMIT 1
11 0.0037 0.0036618709564209
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0305 0.030518054962158
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00064897537231445
SELECT * FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet'
14 0.0018 0.0018160343170166
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0018 0.0018231868743896
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0078 0.0078308582305908
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.0023 0.0023078918457031
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.0014 0.0014469623565674
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00044512748718262
SELECT id FROM categories WHERE parent_id = '26'
20 0.0061 0.0060868263244629
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.0019 0.0018839836120605
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.0016 0.0016310214996338
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.0014 0.0014498233795166
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.0004279613494873
SELECT * FROM categorygroups WHERE id = '1'
25 0.0047 0.0047409534454346
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.00054407119750977
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.0004 0.0003969669342041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.0044050216674805
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.0006 0.00058197975158691
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.00051307678222656
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.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00034904479980469
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014891624450684
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.0004 0.00044798851013184
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.0004 0.00039386749267578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00035190582275391
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015528202056885
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.0005 0.00047898292541504
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.0005 0.00049614906311035
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.00047397613525391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00044512748718262
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00058412551879883
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.0004 0.00041413307189941
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.0004 0.00038695335388184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00033903121948242
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00059199333190918
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.0004 0.00040197372436523
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.0004 0.00043392181396484
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.0004 0.00041985511779785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00037789344787598
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00053000450134277
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.00038313865661621
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.00036811828613281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00033712387084961
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00060009956359863
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.0004 0.00041007995605469
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.0004 0.00042605400085449
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.0006 0.00057315826416016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045204162597656
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00054001808166504
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.0004 0.00044417381286621
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.00055599212646484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00075292587280273
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.00054597854614258
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.00053095817565918
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.0004 0.00039386749267578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00038409233093262
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00046896934509277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0030 0.0029680728912354
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0016071796417236
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00067615509033203
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.0013 0.0013329982757568
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010960102081299
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00083017349243164
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8190 0.81896710395813
SELECT * FROM ipgeocountries WHERE INET_ATON('18.222.22.193') >= INET_ATON(ip_start) AND INET_ATON('18.222.22.193') <= INET_ATON(ip_end)
78 0.0024 0.0024189949035645
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012598037719727
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00058102607727051
SELECT * FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet'
81 0.0004 0.00041007995605469
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1674
82 0.0004 0.00042295455932617
SELECT * FROM manufacturers WHERE id = '243'
83 0.0005 0.00047588348388672
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
84 0.0015 0.0015058517456055
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
85 0.0017 0.0016980171203613
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.0004 0.00038313865661621
SELECT * FROM productimages WHERE product_id = '2686' ORDER BY sortorder ASC
87 0.0004 0.00044083595275879
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
88 0.0005 0.00048303604125977
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '243'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00038003921508789
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
90 0.0004 0.00039100646972656
SELECT category_id FROM products_categories WHERE product_id = '1674'
91 0.0005 0.00045585632324219
SELECT * FROM categories WHERE id = '27'
92 0.0038 0.0038070678710938
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.0005 0.00045394897460938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.0003211498260498
SELECT id FROM categories WHERE parent_id = '27'
95 0.0036 0.003605842590332
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.0005 0.00054693222045898
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.0008 0.00077581405639648
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.0005 0.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0013 0.0013439655303955
SELECT * FROM productimages WHERE product_id = '1674' ORDER BY sortorder ASC
100 0.0063 0.0063140392303467
SELECT * FROM product_image_select WHERE product_id = '1674'
101 0.0052 0.0051629543304443
SELECT * FROM productcustomimages WHERE product_id = '1674'
102 0.0039 0.003878116607666
SELECT * FROM productfeeds WHERE product_id = '1674' ORDER BY item_date DESC
103 0.0078 0.0078368186950684
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.0050 0.0050420761108398
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.0031 0.003065824508667
SELECT * FROM productamazoncontent WHERE product_id = '1674'
106 0.0014 0.0013630390167236
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
107 0.0023 0.0022978782653809
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00050520896911621
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00059700012207031
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
111 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0007 0.00068116188049316
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
113 0.0118 0.011766910552979
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
114 0.0007 0.00070595741271973
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
115 0.0005 0.00053000450134277
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
116 0.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
117 0.0006 0.00062012672424316
SELECT * FROM product_image_select WHERE product_id = '1443'
118 0.0005 0.00045514106750488
SELECT * FROM productcustomimages WHERE product_id = '1443'
119 0.0011 0.0010738372802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
120 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0006 0.00057387351989746
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
124 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '1435'
125 0.0008 0.00077080726623535
SELECT * FROM productcustomimages WHERE product_id = '1435'
126 0.0012 0.0011708736419678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
127 0.0005 0.00054407119750977
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0099 0.0098719596862793
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
131 0.0007 0.00070405006408691
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
132 0.0006 0.00055217742919922
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
133 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
134 0.0006 0.00063300132751465
SELECT * FROM product_image_select WHERE product_id = '878'
135 0.0003 0.00034594535827637
SELECT * FROM productcustomimages WHERE product_id = '878'
136 0.0011 0.0010890960693359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
137 0.0005 0.00048398971557617
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00048685073852539
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.00050997734069824
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
141 0.0006 0.00060319900512695
SELECT * FROM product_image_select WHERE product_id = '858'
142 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '858'
143 0.0010 0.00098013877868652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
144 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00038814544677734
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
148 0.0006 0.00061988830566406
SELECT * FROM product_image_select WHERE product_id = '862'
149 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '862'
150 0.0010 0.0010061264038086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
151 0.0004 0.00043511390686035
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
155 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '865'
156 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '865'
157 0.0008 0.00076508522033691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
158 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00034809112548828
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00051593780517578
SELECT id,asin FROM products WHERE parent_id = 1674
162 0.0018 0.001823902130127
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1674' ORDER BY timestamp DESC
163 0.0004 0.00041604042053223
SELECT category_id FROM products_categories WHERE product_id = '1674'
164 0.0004 0.00042605400085449
SELECT * FROM categories WHERE id = '27'
165 0.0040 0.0039541721343994
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
166 0.0004 0.00041294097900391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0003 0.00030803680419922
SELECT id FROM categories WHERE parent_id = '27'
168 0.0036 0.0036239624023438
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 
169 0.0005 0.00049495697021484
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 
170 0.0005 0.00051784515380859
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
171 0.0004 0.00042986869812012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0009 0.00088286399841309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
173 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00051403045654297
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00035619735717773
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
177 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = '1674'
178 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0008 0.00084900856018066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
180 0.0004 0.00036287307739258
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00036883354187012
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00038290023803711
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
184 0.0004 0.00044584274291992
SELECT category_id FROM products_categories WHERE product_id = '1674' AND prod_type = 'amz'
185 0.0004 0.00043606758117676
SELECT parent_id FROM categories WHERE id = '27'
186 0.0003 0.00030279159545898
SELECT * FROM categories WHERE id = '27'
187 0.0040 0.0040218830108643
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
188 0.0004 0.00040388107299805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
189 0.0003 0.00033283233642578
SELECT id FROM categories WHERE parent_id = '27'
190 0.0036 0.0035920143127441
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 
191 0.0005 0.00049400329589844
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 
192 0.0005 0.00048589706420898
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
193 0.0005 0.00050592422485352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
194 0.0018 0.0017690658569336
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
195 0.0015 0.0014650821685791
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
196 0.0003 0.00033402442932129
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
197 0.0144 0.014395952224731
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
198 0.0020 0.001971960067749
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
199 0.0005 0.00051283836364746
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
200 0.0005 0.00048708915710449
SELECT * FROM products WHERE id = 1626
201 0.0003 0.00033807754516602
SELECT * FROM products WHERE id = 4041
202 0.0003 0.00031590461730957
SELECT * FROM products WHERE id = 4312
203 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = 777
204 0.0003 0.00031590461730957
SELECT * FROM products WHERE id = 3881
205 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = 4213
206 0.0004 0.00037980079650879
SELECT * FROM products WHERE id = '1626'
207 0.0004 0.00043010711669922
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
208 0.0006 0.00061488151550293
SELECT * FROM product_image_select WHERE product_id = '1626'
209 0.0004 0.00039887428283691
SELECT * FROM productcustomimages WHERE product_id = '1626'
210 0.0010 0.00098013877868652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
211 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = '4041'
215 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
216 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '4041'
217 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '4041'
218 0.0013 0.0013368129730225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
219 0.0005 0.00049591064453125
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00040578842163086
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0005 0.00049519538879395
SELECT * FROM products WHERE id = '4312'
223 0.0005 0.00045108795166016
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
224 0.0006 0.00060105323791504
SELECT * FROM product_image_select WHERE product_id = '4312'
225 0.0004 0.00035214424133301
SELECT * FROM productcustomimages WHERE product_id = '4312'
226 0.0011 0.0011031627655029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
227 0.0006 0.00056886672973633
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00050902366638184
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0007 0.00066995620727539
SELECT * FROM products WHERE id = '777'
231 0.0005 0.00051689147949219
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
232 0.0007 0.00067687034606934
SELECT * FROM product_image_select WHERE product_id = '777'
233 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '777'
234 0.0014 0.0014328956604004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
235 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0005 0.00049710273742676
SELECT * FROM products WHERE id = '3881'
239 0.0005 0.00046300888061523
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
240 0.0005 0.00054597854614258
SELECT * FROM product_image_select WHERE product_id = '3881'
241 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '3881'
242 0.0010 0.0010349750518799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
243 0.0005 0.00045108795166016
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = '4213'
247 0.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
248 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '4213'
249 0.0003 0.00034093856811523
SELECT * FROM productcustomimages WHERE product_id = '4213'
250 0.0011 0.001147985458374
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
251 0.0004 0.0004270076751709
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0020 0.0019598007202148
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
255 0.0006 0.00060296058654785
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
256 0.0026 0.0026490688323975
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
257 0.0019 0.0018670558929443
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
258 0.0006 0.0005650520324707
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0008 0.00081706047058105
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'