0

Sachets de thé rooibos originales (80) - Paquet de 6

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-22 14:57:57 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.

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.4987699985504 257 0.8533 0


No Amazon API Requests Made.


App Debug - Total Time 1.4987699985504 seconds

Number Time From Start Name Description
1 0.55644798278809 Initialise Initialise FSB Function
2 0.56191611289978 App Controller Start Start of the App controller (called before the controller of every page)
3 0.60597920417786 Start of getCategoryListByGroup Function Before first category groups query
4 0.60673308372498 After initial query Before first category groups query
5 0.60673499107361 Get Category List for Group Before the call to getCategoryList function
6 0.60673809051514 Start of GetCategoryList function Start of the function
7 0.60674118995667 Before getting categories Query to get specific category list
8 0.60763907432556 After getting categories Query to get specific category list
9 0.60764098167419 Before getting category custom Before call to function getCategoryCustom
10 0.62630105018616 After getting category custom After call to function getCategoryCustom
11 0.62630605697632 Before getting category custom Before call to function getCategoryCustom
12 0.63736701011658 After getting category custom After call to function getCategoryCustom
13 0.63737106323242 Before getting category custom Before call to function getCategoryCustom
14 0.64376401901245 After getting category custom After call to function getCategoryCustom
15 0.6437680721283 Before getting category custom Before call to function getCategoryCustom
16 0.64903998374939 After getting category custom After call to function getCategoryCustom
17 0.64904308319092 Before getting category custom Before call to function getCategoryCustom
18 0.6540470123291 After getting category custom After call to function getCategoryCustom
19 0.65405011177063 Before getting category custom Before call to function getCategoryCustom
20 0.65907621383667 After getting category custom After call to function getCategoryCustom
21 0.6590781211853 End of GetCategoryList function End of the function
22 0.6590850353241 Get Category List for Group Before the call to getCategoryList function
23 0.65908908843994 Start of GetCategoryList function Start of the function
24 0.65909099578857 Before getting categories Query to get specific category list
25 0.65972805023193 End of getCategoryListByGroup Function Before return()
26 1.1888930797577 App Controller End End of the App controller (called before the controller of every page)
27 1.1895861625671 Product Start Start of the product info controller
28 1.2249901294708 Cache file not found Starting get product details
29 1.2756299972534 Related products Start getting related products if enabled
30 1.2756330966949 Related Products Start Before the related products are found
31 1.2756340503693 Related Products Keywords Before the related product keywords are found
32 1.2756412029266 Create Keyword List Function Start of function
33 1.2756900787354 Create Keyword List Function After looping provided content - 23 keywords found
34 1.2770731449127 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
35 1.277083158493 Create Keyword List Function After reducing keyword list
36 1.2771620750427 Create Keyword List Function After selecting by scoring keywords
37 1.2771670818329 Create Keyword List Function After final loop of keywords
38 1.2771711349487 Related Products Keywords After the related product keywords are found
39 1.3442590236664 Related Products End After the related products are found
40 1.3779971599579 Product End End of the product info controller (Product Info)
41 1.3795120716095 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3806881904602 Before Get Options Before the call to getOptions in the tpl class
43 1.4422030448914 After Get Options After the call to getOptions in the tpl class
44 1.4423871040344 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4424300193787 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4560470581055 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4560551643372 Product Info: Before Template Display Before the template is displayed
48 1.498722076416 Product Info: After Template Display After the template is displayed
49 1.4987440109253 Finalizing debug Before the debug is output to the page.
50 1.4987680912018 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 0.8533 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0023000240325928
SELECT parameter, value FROM parameters
2 0.0049 0.0048530101776123
SELECT * FROM `bad_bots`
3 0.0005 0.00047802925109863
SET time_zone = 'Europe/London'
4 0.0012 0.0012369155883789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0012669563293457
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.147.85.108\";}'
6 0.0013 0.0013010501861572
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722092734'
7 0.0022 0.0022008419036865
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0011999607086182
UPDATE autorun SET lastrun = '2024-07-27 15:05:34' WHERE id = '8'
9 0.0010 0.0010318756103516
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0016 0.0016319751739502
SELECT id FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6' LIMIT 1
11 0.0019 0.0019021034240723
SELECT id FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6' AND hidden = 0 LIMIT 1
12 0.0051 0.0051031112670898
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0377 0.037665128707886
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00066781044006348
SELECT * FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6'
15 0.0007 0.00074195861816406
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0009 0.00088000297546387
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0084 0.008371114730835
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.0007 0.00071096420288086
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.0006 0.00055694580078125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00052118301391602
SELECT id FROM categories WHERE parent_id = '26'
21 0.0062 0.0061509609222412
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.0006 0.00058913230895996
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.0006 0.00059604644775391
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.0005 0.00053906440734863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00045919418334961
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.0037329196929932
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.00052809715270996
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.00044608116149902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00045084953308105
SELECT id FROM categories WHERE parent_id = '27'
30 0.0037 0.0036888122558594
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.00052499771118164
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.00058293342590332
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.00051498413085938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00047612190246582
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0014128684997559
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.00038909912109375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00044918060302734
SELECT id FROM categories WHERE parent_id = '28'
39 0.0015 0.0015079975128174
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.00050091743469238
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.00054407119750977
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.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00046706199645996
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00062394142150879
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.0005 0.0005190372467041
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.0005 0.0004580020904541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00043582916259766
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00076103210449219
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.0007 0.00069189071655273
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.0007 0.00068402290344238
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.0005 0.00054097175598145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00046420097351074
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00066900253295898
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.0006 0.00057601928710938
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.0004 0.00040102005004883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00048303604125977
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00074505805969238
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.0005 0.00050210952758789
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.0006 0.00056815147399902
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.0005 0.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00049495697021484
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00069713592529297
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.0005 0.0004730224609375
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.0004 0.00040197372436523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.0004880428314209
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00078988075256348
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.0006 0.00057888031005859
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.0006 0.00058484077453613
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.0005 0.00050091743469238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00042915344238281
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.0006260871887207
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0016 0.0016341209411621
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0006 0.00059008598327637
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00060892105102539
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.0005 0.00046205520629883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010790824890137
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0010600090026855
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5199 0.51994490623474
SELECT * FROM ipgeocountries WHERE INET_ATON('3.147.85.108') >= INET_ATON(ip_start) AND INET_ATON('3.147.85.108') <= INET_ATON(ip_end)
79 0.0013 0.0013120174407959
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0005 0.00047612190246582
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00070405006408691
SELECT * FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6'
82 0.0004 0.00044798851013184
UPDATE products SET viewcount = viewcount + 1 WHERE id = 918
83 0.0012 0.0011529922485352
SELECT * FROM manufacturers WHERE id = '639'
84 0.0024 0.0024220943450928
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0008 0.00082993507385254
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0027 0.002655029296875
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87 0.0010 0.00099587440490723
SELECT * FROM productimages WHERE product_id = '3925' ORDER BY sortorder ASC
88 0.0023 0.0022809505462646
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0024 0.0023751258850098
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00055193901062012
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0010 0.00098705291748047
SELECT category_id FROM products_categories WHERE product_id = '918'
92 0.0011 0.0010888576507568
SELECT * FROM categories WHERE id = '27'
93 0.0088 0.0087771415710449
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.0007 0.00071096420288086
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '27'
96 0.0065 0.0065159797668457
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.0007 0.00072312355041504
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.0008 0.00084400177001953
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.0011 0.001068115234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0009 0.00088596343994141
SELECT * FROM productimages WHERE product_id = '918' ORDER BY sortorder ASC
101 0.0012 0.0011920928955078
SELECT * FROM product_image_select WHERE product_id = '918'
102 0.0007 0.00069379806518555
SELECT * FROM productcustomimages WHERE product_id = '918'
103 0.0007 0.00071382522583008
SELECT * FROM productfeeds WHERE product_id = '918' ORDER BY item_date DESC
104 0.0014 0.0014381408691406
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0017 0.0016889572143555
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '918' AND t.hidden = 0 AND display_product = 1
106 0.0011 0.0010859966278076
SELECT * FROM productamazoncontent WHERE product_id = '918'
107 0.0019 0.00189208984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
108 0.0011 0.0011119842529297
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0009 0.0009000301361084
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0009 0.00086212158203125
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
111 0.0008 0.00082206726074219
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
112 0.0011 0.0011329650878906
SELECT value FROM productattributes WHERE product_id = '918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0011 0.0010509490966797
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.0277 0.027733087539673
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0014 0.0013530254364014
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0011 0.00105881690979
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0010 0.00097799301147461
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
118 0.0010 0.00098204612731934
SELECT * FROM product_image_select WHERE product_id = '869'
119 0.0006 0.00061488151550293
SELECT * FROM productcustomimages WHERE product_id = '869'
120 0.0016 0.0015840530395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
121 0.0008 0.00075888633728027
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0006 0.0005950927734375
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0006 0.00063204765319824
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0008 0.00075411796569824
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
125 0.0009 0.00086784362792969
SELECT * FROM product_image_select WHERE product_id = '890'
126 0.0007 0.00066208839416504
SELECT * FROM productcustomimages WHERE product_id = '890'
127 0.0016 0.0016047954559326
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
128 0.0007 0.00065708160400391
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0007 0.00072312355041504
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0006 0.00064706802368164
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0008 0.00084996223449707
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
132 0.0009 0.00089502334594727
SELECT * FROM product_image_select WHERE product_id = '858'
133 0.0006 0.00056600570678711
SELECT * FROM productcustomimages WHERE product_id = '858'
134 0.0016 0.0015988349914551
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
135 0.0007 0.00065302848815918
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.0006098747253418
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0006 0.0006411075592041
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0008 0.00077390670776367
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
139 0.0008 0.00084900856018066
SELECT * FROM product_image_select WHERE product_id = '862'
140 0.0006 0.00056600570678711
SELECT * FROM productcustomimages WHERE product_id = '862'
141 0.0012 0.0012030601501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
142 0.0026 0.0025961399078369
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0006 0.0005640983581543
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0006 0.00056791305541992
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0007 0.00068497657775879
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
146 0.0009 0.00085806846618652
SELECT * FROM product_image_select WHERE product_id = '865'
147 0.0005 0.00051593780517578
SELECT * FROM productcustomimages WHERE product_id = '865'
148 0.0011 0.0011141300201416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
149 0.0007 0.0007479190826416
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0006 0.0005650520324707
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0006 0.00060105323791504
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00060200691223145
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
153 0.0008 0.00076889991760254
SELECT * FROM product_image_select WHERE product_id = '878'
154 0.0005 0.00051689147949219
SELECT * FROM productcustomimages WHERE product_id = '878'
155 0.0012 0.0012359619140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
156 0.0006 0.00062298774719238
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00049304962158203
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0006 0.00064206123352051
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0007 0.00072693824768066
SELECT id,asin FROM products WHERE parent_id = 918
160 0.0005 0.00053191184997559
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '918' ORDER BY timestamp DESC
161 0.0005 0.00051593780517578
SELECT category_id FROM products_categories WHERE product_id = '918'
162 0.0006 0.00059795379638672
SELECT * FROM categories WHERE id = '27'
163 0.0063 0.0063278675079346
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
164 0.0006 0.00058078765869141
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0005 0.00046181678771973
SELECT id FROM categories WHERE parent_id = '27'
166 0.0038 0.0037550926208496
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 
167 0.0007 0.00068092346191406
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 
168 0.0006 0.00060296058654785
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
169 0.0005 0.00048708915710449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0009 0.00086808204650879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
171 0.0005 0.00053811073303223
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
174 0.0004 0.00039505958557129
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
175 0.0008 0.00075006484985352
SELECT * FROM products WHERE id = '918'
176 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0007 0.00070905685424805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
178 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00040793418884277
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
182 0.0005 0.00053501129150391
SELECT category_id FROM products_categories WHERE product_id = '918' AND prod_type = 'amz'
183 0.0006 0.00056099891662598
SELECT parent_id FROM categories WHERE id = '27'
184 0.0004 0.00043797492980957
SELECT * FROM categories WHERE id = '27'
185 0.0037 0.0037088394165039
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
186 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0004 0.00040411949157715
SELECT id FROM categories WHERE parent_id = '27'
188 0.0036 0.0035660266876221
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 
189 0.0006 0.00063014030456543
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 
190 0.0007 0.00066089630126953
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
191 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0006 0.00063085556030273
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0006 0.00062894821166992
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0005 0.00045299530029297
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0133 0.013329029083252
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
196 0.0009 0.00086092948913574
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
197 0.0007 0.00065708160400391
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
198 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = 1626
199 0.0008 0.00076699256896973
SELECT * FROM products WHERE id = 4041
200 0.0007 0.00067996978759766
SELECT * FROM products WHERE id = 4312
201 0.0006 0.00063395500183105
SELECT * FROM products WHERE id = 777
202 0.0007 0.0007469654083252
SELECT * FROM products WHERE id = 3881
203 0.0007 0.00065898895263672
SELECT * FROM products WHERE id = 4213
204 0.0007 0.0006718635559082
SELECT * FROM products WHERE id = '1626'
205 0.0005 0.00052309036254883
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0006 0.00064182281494141
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0005 0.00050783157348633
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0010 0.00096297264099121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0006 0.00058698654174805
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00052690505981445
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.0006721019744873
SELECT * FROM products WHERE id = '4041'
213 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0007 0.00073099136352539
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0005 0.00047683715820312
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0013 0.0012738704681396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0006 0.00058388710021973
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = '4312'
221 0.0006 0.000640869140625
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0007 0.00071907043457031
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0005 0.00052094459533691
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0015 0.0014529228210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0006 0.00056195259094238
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0008 0.00080299377441406
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0007 0.0006871223449707
SELECT * FROM products WHERE id = '777'
229 0.0006 0.00061988830566406
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0008 0.00078296661376953
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0012 0.0012350082397461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0006 0.0005638599395752
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0005 0.00051188468933105
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = '3881'
237 0.0008 0.00078606605529785
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0008 0.00079798698425293
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0005 0.00053286552429199
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0014 0.0014371871948242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0006 0.0006258487701416
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0006 0.00059700012207031
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0008 0.00078010559082031
SELECT * FROM products WHERE id = '4213'
245 0.0009 0.00088095664978027
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0007 0.00071287155151367
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0005 0.00049519538879395
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0014 0.0013940334320068
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0006 0.00059890747070312
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0005 0.00053715705871582
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0006 0.00055599212646484
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0010 0.0010299682617188
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0009 0.00085592269897461
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0018 0.0018208026885986
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0010 0.00099897384643555
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0009 0.00085020065307617
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0011 0.0010659694671631
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'