0

Fairtrade Libellule Sacs De Thé Rooibos 40 Par Paquet - Paquet de 2

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 17:14:23 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 - Paquet de 2 Quantité: 2

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
3.1741878986359 260 0.9370 0


No Amazon API Requests Made.


App Debug - Total Time 3.1741878986359 seconds

Number Time From Start Name Description
1 2.1970658302307 Initialise Initialise FSB Function
2 2.2062318325043 App Controller Start Start of the App controller (called before the controller of every page)
3 2.2413108348846 Start of getCategoryListByGroup Function Before first category groups query
4 2.2426729202271 After initial query Before first category groups query
5 2.2426748275757 Get Category List for Group Before the call to getCategoryList function
6 2.2426779270172 Start of GetCategoryList function Start of the function
7 2.2426819801331 Before getting categories Query to get specific category list
8 2.2442378997803 After getting categories Query to get specific category list
9 2.2442400455475 Before getting category custom Before call to function getCategoryCustom
10 2.2641780376434 After getting category custom After call to function getCategoryCustom
11 2.2641830444336 Before getting category custom Before call to function getCategoryCustom
12 2.2757740020752 After getting category custom After call to function getCategoryCustom
13 2.2757778167725 Before getting category custom Before call to function getCategoryCustom
14 2.2824609279633 After getting category custom After call to function getCategoryCustom
15 2.2824640274048 Before getting category custom Before call to function getCategoryCustom
16 2.2925899028778 After getting category custom After call to function getCategoryCustom
17 2.292592048645 Before getting category custom Before call to function getCategoryCustom
18 2.3027880191803 After getting category custom After call to function getCategoryCustom
19 2.3027918338776 Before getting category custom Before call to function getCategoryCustom
20 2.3122658729553 After getting category custom After call to function getCategoryCustom
21 2.3122689723969 End of GetCategoryList function End of the function
22 2.31227684021 Get Category List for Group Before the call to getCategoryList function
23 2.3122799396515 Start of GetCategoryList function Start of the function
24 2.312283039093 Before getting categories Query to get specific category list
25 2.3131608963013 End of getCategoryListByGroup Function Before return()
26 2.9028830528259 App Controller End End of the App controller (called before the controller of every page)
27 2.9035978317261 Product Start Start of the product info controller
28 2.9133930206299 Cache file not found Starting get product details
29 2.9532368183136 Related products Start getting related products if enabled
30 2.9532389640808 Related Products Start Before the related products are found
31 2.9532399177551 Related Products Keywords Before the related product keywords are found
32 2.9532449245453 Create Keyword List Function Start of function
33 2.9533529281616 Create Keyword List Function After looping provided content - 31 keywords found
34 2.9545669555664 Create Keyword List Function After looping initial keyword list - 26 keywords remaining
35 2.9545748233795 Create Keyword List Function After reducing keyword list
36 2.9546718597412 Create Keyword List Function After selecting by scoring keywords
37 2.9546759128571 Create Keyword List Function After final loop of keywords
38 2.9546778202057 Related Products Keywords After the related product keywords are found
39 3.010687828064 Related Products End After the related products are found
40 3.0421760082245 Product End End of the product info controller (Product Info)
41 3.0458228588104 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 3.048840045929 Before Get Options Before the call to getOptions in the tpl class
43 3.1309809684753 After Get Options After the call to getOptions in the tpl class
44 3.1311538219452 App_after Controller End End of the App_after controller (called after the controller of every page)
45 3.1311910152435 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 3.1456999778748 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 3.1457059383392 Product Info: Before Template Display Before the template is displayed
48 3.1741440296173 Product Info: After Template Display After the template is displayed
49 3.1741709709167 Finalizing debug Before the debug is output to the page.
50 3.1741859912872 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 0.9370 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022399425506592
SELECT parameter, value FROM parameters
2 0.0073 0.0073449611663818
SELECT * FROM `bad_bots`
3 0.0005 0.00051188468933105
SET time_zone = 'Europe/London'
4 0.0032 0.0032010078430176
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0034 0.0033779144287109
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.219.79.245\";}'
6 0.0030 0.002953052520752
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734796719'
7 0.0037 0.0037229061126709
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00068902969360352
UPDATE autorun SET lastrun = '2024-12-21 15:58:40' WHERE id = '15'
9 0.0009 0.00085091590881348
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0036 0.0036220550537109
SELECT id FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet-paquet-de-2' LIMIT 1
11 0.0040 0.0039751529693604
SELECT id FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet-paquet-de-2' AND hidden = 0 LIMIT 1
12 0.0041 0.0040597915649414
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0299 0.029889106750488
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00054097175598145
SELECT * FROM pages WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet-paquet-de-2'
15 0.0013 0.001349925994873
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0015 0.0015370845794678
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0062 0.0061550140380859
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0017 0.0016601085662842
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0012 0.0011739730834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00044989585876465
SELECT id FROM categories WHERE parent_id = '26'
21 0.0052 0.0052478313446045
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0014 0.0014269351959229
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0018 0.0017848014831543
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0013 0.0013389587402344
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00055694580078125
SELECT * FROM categorygroups WHERE id = '1'
26 0.0042 0.0041630268096924
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00053906440734863
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.0004420280456543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00049400329589844
SELECT id FROM categories WHERE parent_id = '27'
30 0.0037 0.0037479400634766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0005 0.00054287910461426
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0006 0.00058794021606445
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00052213668823242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00043988227844238
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0013890266418457
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00052404403686523
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00044989585876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00048017501831055
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015909671783447
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0005 0.00053715705871582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0005 0.00053906440734863
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00051307678222656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00055313110351562
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00065493583679199
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0012 0.0012009143829346
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0009 0.00089907646179199
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0011 0.001107931137085
SELECT id FROM categories WHERE parent_id = '29'
48 0.0017 0.0016589164733887
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0010 0.0010449886322021
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0013 0.0013210773468018
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0013 0.0013442039489746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0008 0.00079989433288574
SELECT * FROM categorygroups WHERE id = '1'
53 0.0013 0.0012731552124023
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0012 0.001187801361084
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0010 0.0010159015655518
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0010 0.00099492073059082
SELECT id FROM categories WHERE parent_id = '30'
57 0.0018 0.0017919540405273
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0011 0.0010747909545898
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0011 0.0010771751403809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0009 0.00090217590332031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0008 0.0007779598236084
SELECT * FROM categorygroups WHERE id = '1'
62 0.0015 0.0014588832855225
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0009 0.00092411041259766
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0008 0.00077700614929199
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0008 0.00075387954711914
SELECT id FROM categories WHERE parent_id = '31'
66 0.0016 0.0015690326690674
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0010 0.00097799301147461
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0011 0.0011498928070068
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0009 0.00088620185852051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0009 0.00087308883666992
SELECT * FROM categorygroups WHERE id = '1'
71 0.0009 0.00086688995361328
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0052 0.0051519870758057
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0025 0.002453088760376
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0008 0.00082516670227051
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
75 0.0020 0.0019738674163818
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0017 0.001655101776123
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0013 0.0013179779052734
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5710 0.57096982002258
SELECT * FROM ipgeocountries WHERE INET_ATON('18.219.79.245') >= INET_ATON(ip_start) AND INET_ATON('18.219.79.245') <= INET_ATON(ip_end)
79 0.0020 0.0020241737365723
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0012409687042236
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00075006484985352
SELECT * FROM products WHERE pagename = 'fairtrade-libellule-sacs-de-the-rooibos-40-par-paquet-paquet-de-2'
82 0.0004 0.00044989585876465
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1437
83 0.0007 0.00070095062255859
SELECT * FROM manufacturers WHERE id = '243'
84 0.0007 0.00065708160400391
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
85 0.0016 0.0015890598297119
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
86 0.0019 0.0019009113311768
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
87 0.0005 0.00047707557678223
SELECT * FROM productimages WHERE product_id = '1596' ORDER BY sortorder ASC
88 0.0006 0.00059390068054199
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
89 0.0006 0.00058817863464355
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 
90 0.0006 0.00057888031005859
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
91 0.0008 0.00075793266296387
SELECT category_id FROM products_categories WHERE product_id = '1437'
92 0.0006 0.00063920021057129
SELECT * FROM categories WHERE id = '27'
93 0.0059 0.0059280395507812
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
94 0.0006 0.00063514709472656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00055789947509766
SELECT id FROM categories WHERE parent_id = '27'
96 0.0050 0.0050041675567627
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 
97 0.0006 0.00064802169799805
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 
98 0.0007 0.00069499015808105
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
99 0.0006 0.00056910514831543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0007 0.0006709098815918
SELECT * FROM productimages WHERE product_id = '1437' ORDER BY sortorder ASC
101 0.0021 0.0020887851715088
SELECT * FROM product_image_select WHERE product_id = '1437'
102 0.0014 0.0014340877532959
SELECT * FROM productcustomimages WHERE product_id = '1437'
103 0.0012 0.0011780261993408
SELECT * FROM productfeeds WHERE product_id = '1437' ORDER BY item_date DESC
104 0.0024 0.0023519992828369
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1437' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0024 0.0024151802062988
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1437' AND t.hidden = 0 AND display_product = 1
106 0.0014 0.0013527870178223
SELECT * FROM productamazoncontent WHERE product_id = '1437'
107 0.0012 0.0012190341949463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1437' AND a.name = n.originalname
108 0.0015 0.0015110969543457
SELECT * FROM productoffers WHERE product_id = '1437' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '1437' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = 1437
                ORDER BY price ASC LIMIT 1
111 0.0005 0.0004730224609375
SELECT value FROM productattributes
                WHERE product_id = '1437'
                AND name = 'ListPriceAmount'
112 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '1437' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0007 0.00065493583679199
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
114 0.0094 0.0093750953674316
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 1437 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00066208839416504
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 1437 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0007 0.00070405006408691
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 1437 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
118 0.0006 0.00061702728271484
SELECT * FROM product_image_select WHERE product_id = '1435'
119 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '1435'
120 0.0010 0.00098800659179688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
121 0.0005 0.0004730224609375
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.00043511390686035
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0005 0.00046777725219727
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
125 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '1443'
126 0.0004 0.00039291381835938
SELECT * FROM productcustomimages WHERE product_id = '1443'
127 0.0009 0.00094008445739746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
128 0.0005 0.00047922134399414
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0148 0.014783143997192
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 1437 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
132 0.0008 0.00081396102905273
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 1437 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
133 0.0007 0.00072312355041504
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 1437 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
134 0.0007 0.00074195861816406
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
135 0.0008 0.0007789134979248
SELECT * FROM product_image_select WHERE product_id = '862'
136 0.0005 0.00051403045654297
SELECT * FROM productcustomimages WHERE product_id = '862'
137 0.0013 0.0013399124145508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
138 0.0007 0.00065994262695312
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0006 0.00056910514831543
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00054693222045898
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.0006098747253418
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
142 0.0008 0.00075793266296387
SELECT * FROM product_image_select WHERE product_id = '865'
143 0.0005 0.00049018859863281
SELECT * FROM productcustomimages WHERE product_id = '865'
144 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
145 0.0006 0.00064587593078613
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00052595138549805
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0007 0.00071191787719727
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
149 0.0007 0.00074100494384766
SELECT * FROM product_image_select WHERE product_id = '858'
150 0.0005 0.00051379203796387
SELECT * FROM productcustomimages WHERE product_id = '858'
151 0.0015 0.0015029907226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
152 0.0006 0.00059700012207031
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0006 0.00057387351989746
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
156 0.0007 0.00074315071105957
SELECT * FROM product_image_select WHERE product_id = '878'
157 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '878'
158 0.0013 0.001317024230957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
159 0.0006 0.00064182281494141
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00048589706420898
SELECT id,asin FROM products WHERE parent_id = 1437
163 0.0017 0.0017459392547607
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1437' ORDER BY timestamp DESC
164 0.0005 0.00046610832214355
SELECT category_id FROM products_categories WHERE product_id = '1437'
165 0.0005 0.00049209594726562
SELECT * FROM categories WHERE id = '27'
166 0.0036 0.0036401748657227
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.0005 0.00047707557678223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0004 0.00037789344787598
SELECT id FROM categories WHERE parent_id = '27'
169 0.0034 0.0033690929412842
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.0006 0.00055694580078125
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.0005 0.00052380561828613
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.0005 0.00047707557678223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0011 0.0010988712310791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1437' AND a.name = n.originalname
174 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '1437' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0004 0.00042986869812012
SELECT * FROM productoffers
                WHERE product_id = '1437' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = 1437
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00040912628173828
SELECT value FROM productattributes
                WHERE product_id = '1437'
                AND name = 'ListPriceAmount'
178 0.0006 0.00057196617126465
SELECT * FROM products WHERE id = '1437'
179 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '1437' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0009 0.00092101097106934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1437' AND a.name = n.originalname
181 0.0004 0.00036811828613281
SELECT * FROM productoffers WHERE product_id = '1437' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '1437' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = 1437
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00037503242492676
SELECT value FROM productattributes
                WHERE product_id = '1437'
                AND name = 'ListPriceAmount'
185 0.0005 0.00051379203796387
SELECT category_id FROM products_categories WHERE product_id = '1437' AND prod_type = 'amz'
186 0.0005 0.0004570484161377
SELECT parent_id FROM categories WHERE id = '27'
187 0.0004 0.00037693977355957
SELECT * FROM categories WHERE id = '27'
188 0.0035 0.0034701824188232
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
189 0.0005 0.00046396255493164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '27'
191 0.0034 0.0033900737762451
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 
192 0.0012 0.001215934753418
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 
193 0.0010 0.00095796585083008
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
194 0.0008 0.00083494186401367
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0030 0.0029959678649902
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0024 0.0023741722106934
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0005 0.00054311752319336
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0214 0.021390199661255
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
199 0.0018 0.0017778873443604
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
200 0.0005 0.00054001808166504
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
201 0.0006 0.00058388710021973
SELECT * FROM products WHERE id = 1626
202 0.0004 0.00041913986206055
SELECT * FROM products WHERE id = 4041
203 0.0005 0.00048589706420898
SELECT * FROM products WHERE id = 4312
204 0.0004 0.00043487548828125
SELECT * FROM products WHERE id = 777
205 0.0004 0.00044488906860352
SELECT * FROM products WHERE id = 3881
206 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 4213
207 0.0004 0.00039815902709961
SELECT * FROM products WHERE id = '1626'
208 0.0004 0.00044584274291992
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0006 0.00056099891662598
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.00038790702819824
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0021 0.0020749568939209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0009 0.00092005729675293
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0008 0.0007941722869873
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0009 0.00094199180603027
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0010 0.0010008811950684
SELECT * FROM products WHERE id = '4041'
216 0.0009 0.000885009765625
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0015 0.0015270709991455
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0008 0.00078296661376953
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0028 0.002795934677124
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0009 0.0009150505065918
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0006 0.0006110668182373
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0007 0.00066089630126953
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0008 0.00080180168151855
SELECT * FROM products WHERE id = '4312'
224 0.0008 0.00075507164001465
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0011 0.0010690689086914
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0006 0.00056982040405273
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0019 0.0018908977508545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0007 0.00071096420288086
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0006 0.00060892105102539
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0006 0.00063109397888184
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0008 0.00084400177001953
SELECT * FROM products WHERE id = '777'
232 0.0008 0.00084495544433594
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0010 0.00095081329345703
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0006 0.00056099891662598
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0020 0.0019679069519043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0008 0.00075507164001465
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0006 0.00061893463134766
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0006 0.00058197975158691
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0008 0.00076103210449219
SELECT * FROM products WHERE id = '3881'
240 0.0008 0.0007939338684082
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0009 0.00088405609130859
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0005 0.0005338191986084
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0017 0.001741886138916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0007 0.00069808959960938
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0006 0.00057101249694824
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0006 0.00061583518981934
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0008 0.00075578689575195
SELECT * FROM products WHERE id = '4213'
248 0.0008 0.00081801414489746
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0008 0.00082015991210938
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0017 0.001708984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0006 0.00064492225646973
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0005 0.00053286552429199
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0005 0.0005488395690918
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0025 0.0025250911712646
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0009 0.00090909004211426
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0032 0.0032479763031006
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0022 0.002194881439209
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0007 0.00067901611328125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0012 0.001194953918457
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'