0

Thé Rooibos Vanille Classic Bio Pochette 100G - Tealodge

Price: €8,00
Product prices and availability are accurate as of 2022-06-04 11:35:49 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

Thé Rooibos Goût Vanille

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.6578481197357 257 1.1818 0


No Amazon API Requests Made.


App Debug - Total Time 1.6578481197357 seconds

Number Time From Start Name Description
1 0.43120694160461 Initialise Initialise FSB Function
2 0.43773698806763 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47399806976318 Start of getCategoryListByGroup Function Before first category groups query
4 0.47622394561768 After initial query Before first category groups query
5 0.47622513771057 Get Category List for Group Before the call to getCategoryList function
6 0.4762270450592 Start of GetCategoryList function Start of the function
7 0.47622895240784 Before getting categories Query to get specific category list
8 0.47844195365906 After getting categories Query to get specific category list
9 0.47844290733337 Before getting category custom Before call to function getCategoryCustom
10 0.50719499588013 After getting category custom After call to function getCategoryCustom
11 0.50719904899597 Before getting category custom Before call to function getCategoryCustom
12 0.51876592636108 After getting category custom After call to function getCategoryCustom
13 0.51876902580261 Before getting category custom Before call to function getCategoryCustom
14 0.52570295333862 After getting category custom After call to function getCategoryCustom
15 0.52570390701294 Before getting category custom Before call to function getCategoryCustom
16 0.53027200698853 After getting category custom After call to function getCategoryCustom
17 0.53027296066284 Before getting category custom Before call to function getCategoryCustom
18 0.53467893600464 After getting category custom After call to function getCategoryCustom
19 0.53468012809753 Before getting category custom Before call to function getCategoryCustom
20 0.53971409797668 After getting category custom After call to function getCategoryCustom
21 0.53971600532532 End of GetCategoryList function End of the function
22 0.53972005844116 Get Category List for Group Before the call to getCategoryList function
23 0.53972196578979 Start of GetCategoryList function Start of the function
24 0.53972291946411 Before getting categories Query to get specific category list
25 0.54021501541138 End of getCategoryListByGroup Function Before return()
26 1.393070936203 App Controller End End of the App controller (called before the controller of every page)
27 1.3936309814453 Product Start Start of the product info controller
28 1.4298861026764 Cache file not found Starting get product details
29 1.480476140976 Related products Start getting related products if enabled
30 1.4804770946503 Related Products Start Before the related products are found
31 1.4804770946503 Related Products Keywords Before the related product keywords are found
32 1.4804799556732 Create Keyword List Function Start of function
33 1.4805419445038 Create Keyword List Function After looping provided content - 21 keywords found
34 1.4809091091156 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.4809141159058 Create Keyword List Function After reducing keyword list
36 1.480938911438 Create Keyword List Function After selecting by scoring keywords
37 1.4809410572052 Create Keyword List Function After final loop of keywords
38 1.4809420108795 Related Products Keywords After the related product keywords are found
39 1.5251979827881 Related Products End After the related products are found
40 1.5652189254761 Product End End of the product info controller (Product Info)
41 1.5679731369019 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5696060657501 Before Get Options Before the call to getOptions in the tpl class
43 1.6238391399384 After Get Options After the call to getOptions in the tpl class
44 1.6239490509033 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6239709854126 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6330060958862 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6330080032349 Product Info: Before Template Display Before the template is displayed
48 1.6578299999237 Product Info: After Template Display After the template is displayed
49 1.6578381061554 Finalizing debug Before the debug is output to the page.
50 1.6578469276428 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 1.1818 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0023260116577148
SELECT parameter, value FROM parameters
2 0.0109 0.010936975479126
SELECT * FROM `bad_bots`
3 0.0005 0.00054192543029785
SET time_zone = 'Europe/London'
4 0.0044 0.0043990612030029
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0040 0.003964900970459
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"52.15.225.105\";}'
6 0.0050 0.0050199031829834
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746158608'
7 0.0028 0.0028188228607178
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054502487182617
UPDATE autorun SET lastrun = '2025-05-02 04:03:28' WHERE id = '11'
9 0.0007 0.00073099136352539
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0025 0.0024700164794922
SELECT id FROM pages WHERE pagename = 'the-rooibos-vanille-classic-bio-pochette-100g-tealodge' LIMIT 1
11 0.0027 0.0026838779449463
SELECT id FROM products WHERE pagename = 'the-rooibos-vanille-classic-bio-pochette-100g-tealodge' AND hidden = 0 LIMIT 1
12 0.0030 0.0029690265655518
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0319 0.03193211555481
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0009 0.00090503692626953
SELECT * FROM pages WHERE pagename = 'the-rooibos-vanille-classic-bio-pochette-100g-tealodge'
15 0.0022 0.0022199153900146
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0022 0.0022039413452148
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0101 0.010116100311279
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.0031 0.0030558109283447
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.0017 0.0016908645629883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00060701370239258
SELECT id FROM categories WHERE parent_id = '26'
21 0.0075 0.0075030326843262
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.0020 0.0019900798797607
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.0017 0.0016510486602783
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.0016 0.0015599727630615
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00046014785766602
SELECT * FROM categorygroups WHERE id = '1'
26 0.0039 0.0039141178131104
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.0007 0.00065517425537109
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.0005 0.00048017501831055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00044608116149902
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.0038521289825439
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.0006 0.00056004524230957
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.0005 0.00053811073303223
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.00052785873413086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00051689147949219
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0015568733215332
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.00049304962158203
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.00038409233093262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.0004878044128418
SELECT id FROM categories WHERE parent_id = '28'
39 0.0018 0.0017719268798828
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.0006 0.00060081481933594
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.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 (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00042891502380371
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00062298774719238
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.0004 0.00043797492980957
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.0003 0.0003349781036377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00042104721069336
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00072407722473145
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.0004 0.00043988227844238
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.0006 0.00063395500183105
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.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00045394897460938
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00057220458984375
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.0004 0.00044512748718262
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.00035500526428223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00045514106750488
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00071096420288086
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.00045299530029297
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.0005 0.00047492980957031
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.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00041413307189941
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00070691108703613
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.00046992301940918
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.0005 0.00045108795166016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00042605400085449
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00079107284545898
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.0005 0.00050902366638184
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.00055193901062012
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.0006 0.00057005882263184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00053095817565918
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.0004878044128418
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0032 0.0031559467315674
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0016 0.0016269683837891
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00060701370239258
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.0013 0.0012900829315186
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0011458396911621
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0009 0.00087189674377441
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8380 0.83798289299011
SELECT * FROM ipgeocountries WHERE INET_ATON('52.15.225.105') >= INET_ATON(ip_start) AND INET_ATON('52.15.225.105') <= INET_ATON(ip_end)
79 0.0030 0.003026008605957
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0016 0.0015850067138672
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.0007169246673584
SELECT * FROM products WHERE pagename = 'the-rooibos-vanille-classic-bio-pochette-100g-tealodge'
82 0.0004 0.00043797492980957
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1101
83 0.0011 0.0011129379272461
SELECT * FROM manufacturers WHERE id = '252'
84 0.0010 0.00098109245300293
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
85 0.0039 0.0038940906524658
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '252' LIMIT 1
86 0.0046 0.0045599937438965
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '252' ORDER BY RAND() LIMIT 1
87 0.0008 0.00082302093505859
SELECT * FROM productimages WHERE product_id = '1020' ORDER BY sortorder ASC
88 0.0011 0.0010559558868408
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
89 0.0009 0.00085306167602539
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '252'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00059700012207031
SELECT * FROM manufacturerimages WHERE manufacturer_id = '252'
91 0.0006 0.00057888031005859
SELECT category_id FROM products_categories WHERE product_id = '1101'
92 0.0007 0.00074410438537598
SELECT * FROM categories WHERE id = '27'
93 0.0085 0.0085320472717285
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.00066399574279785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0004 0.00042605400085449
SELECT id FROM categories WHERE parent_id = '27'
96 0.0052 0.0051991939544678
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.0008 0.00078296661376953
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.00077104568481445
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.0007 0.00066590309143066
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0005 0.00050997734069824
SELECT * FROM productimages WHERE product_id = '1101' ORDER BY sortorder ASC
101 0.0020 0.002000093460083
SELECT * FROM product_image_select WHERE product_id = '1101'
102 0.0016 0.0015602111816406
SELECT * FROM productcustomimages WHERE product_id = '1101'
103 0.0022 0.0022380352020264
SELECT * FROM productfeeds WHERE product_id = '1101' ORDER BY item_date DESC
104 0.0031 0.0031280517578125
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0023 0.002310037612915
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1101' AND t.hidden = 0 AND display_product = 1
106 0.0013 0.001349925994873
SELECT * FROM productamazoncontent WHERE product_id = '1101'
107 0.0010 0.00095891952514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname
108 0.0013 0.001323938369751
SELECT * FROM productoffers WHERE product_id = '1101' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = '1101' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00036716461181641
SELECT * FROM productoffers
                WHERE product_id = 1101
                ORDER BY price ASC LIMIT 1
111 0.0006 0.00056099891662598
SELECT value FROM productattributes
                WHERE product_id = '1101'
                AND name = 'ListPriceAmount'
112 0.0006 0.00057315826416016
SELECT value FROM productattributes WHERE product_id = '1101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0007 0.00067496299743652
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.0097 0.0097160339355469
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1101 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00071310997009277
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1101 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0005 0.00051498413085938
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1101 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0005 0.00052595138549805
SELECT * FROM productimages WHERE product_id = '929' ORDER BY sortorder ASC
118 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '929'
119 0.0012 0.0012168884277344
SELECT * FROM productcustomimages WHERE product_id = '929'
120 0.0020 0.0019919872283936
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '929' AND a.name = n.originalname
121 0.0008 0.00078201293945312
SELECT * FROM productoffers WHERE product_id = '929' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0005 0.00054812431335449
SELECT * FROM productoffers
                WHERE product_id = '929' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0007 0.0006568431854248
SELECT value FROM productattributes WHERE product_id = '929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0011 0.0010638236999512
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
125 0.0012 0.0011639595031738
SELECT * FROM product_image_select WHERE product_id = '1007'
126 0.0007 0.00069093704223633
SELECT * FROM productcustomimages WHERE product_id = '1007'
127 0.0024 0.0023958683013916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
128 0.0007 0.0006868839263916
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0006 0.00063014030456543
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0007 0.00070810317993164
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0007 0.00069594383239746
SELECT * FROM productimages WHERE product_id = '957' ORDER BY sortorder ASC
132 0.0009 0.00091195106506348
SELECT * FROM product_image_select WHERE product_id = '957'
133 0.0006 0.00055193901062012
SELECT * FROM productcustomimages WHERE product_id = '957'
134 0.0017 0.0017261505126953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '957' AND a.name = n.originalname
135 0.0006 0.00055789947509766
SELECT * FROM productoffers WHERE product_id = '957' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.00063300132751465
SELECT * FROM productoffers
                WHERE product_id = '957' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0007 0.00069379806518555
SELECT value FROM productattributes WHERE product_id = '957' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0007 0.00065708160400391
SELECT * FROM productimages WHERE product_id = '911' ORDER BY sortorder ASC
139 0.0009 0.00092697143554688
SELECT * FROM product_image_select WHERE product_id = '911'
140 0.0005 0.00051498413085938
SELECT * FROM productcustomimages WHERE product_id = '911'
141 0.0010 0.00098609924316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '911' AND a.name = n.originalname
142 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '911' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = '911' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '911' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00056314468383789
SELECT * FROM productimages WHERE product_id = '1014' ORDER BY sortorder ASC
146 0.0007 0.00066709518432617
SELECT * FROM product_image_select WHERE product_id = '1014'
147 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '1014'
148 0.0009 0.00087594985961914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1014' AND a.name = n.originalname
149 0.0004 0.00044393539428711
SELECT * FROM productoffers WHERE product_id = '1014' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = '1014' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '1014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0008 0.00081086158752441
SELECT * FROM productimages WHERE product_id = '1037' ORDER BY sortorder ASC
153 0.0009 0.00087618827819824
SELECT * FROM product_image_select WHERE product_id = '1037'
154 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '1037'
155 0.0014 0.0014059543609619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1037' AND a.name = n.originalname
156 0.0005 0.00048589706420898
SELECT * FROM productoffers WHERE product_id = '1037' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = '1037' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '1037' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0006 0.00057601928710938
SELECT id,asin FROM products WHERE parent_id = 1101
160 0.0026 0.0025770664215088
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1101' ORDER BY timestamp DESC
161 0.0005 0.00046491622924805
SELECT category_id FROM products_categories WHERE product_id = '1101'
162 0.0005 0.00048303604125977
SELECT * FROM categories WHERE id = '27'
163 0.0054 0.005396842956543
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.0005 0.00054001808166504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0006 0.00055694580078125
SELECT id FROM categories WHERE parent_id = '27'
166 0.0045 0.0044660568237305
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.0005 0.00054097175598145
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.0005950927734375
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.0006 0.00057291984558105
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0014 0.0013771057128906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname
171 0.0007 0.00073790550231934
SELECT * FROM productoffers WHERE product_id = '1101' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0005 0.00053000450134277
SELECT * FROM productoffers
                WHERE product_id = '1101' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = 1101
                ORDER BY price ASC LIMIT 1
174 0.0009 0.00091409683227539
SELECT value FROM productattributes
                WHERE product_id = '1101'
                AND name = 'ListPriceAmount'
175 0.0008 0.0008080005645752
SELECT * FROM products WHERE id = '1101'
176 0.0008 0.00075507164001465
SELECT value FROM productattributes WHERE product_id = '1101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0008 0.00084400177001953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname
178 0.0005 0.00048089027404785
SELECT * FROM productoffers WHERE product_id = '1101' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00048184394836426
SELECT * FROM productoffers
                WHERE product_id = '1101' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00053000450134277
SELECT * FROM productoffers
                WHERE product_id = 1101
                ORDER BY price ASC LIMIT 1
181 0.0006 0.00055694580078125
SELECT value FROM productattributes
                WHERE product_id = '1101'
                AND name = 'ListPriceAmount'
182 0.0006 0.0006248950958252
SELECT category_id FROM products_categories WHERE product_id = '1101' AND prod_type = 'amz'
183 0.0006 0.00061798095703125
SELECT parent_id FROM categories WHERE id = '27'
184 0.0004 0.00043106079101562
SELECT * FROM categories WHERE id = '27'
185 0.0059 0.0058531761169434
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.00049209594726562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0003 0.00034713745117188
SELECT id FROM categories WHERE parent_id = '27'
188 0.0046 0.0045871734619141
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.00062108039855957
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.0006 0.00058603286743164
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
191 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0022 0.0022318363189697
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0012 0.0012490749359131
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0003 0.00034403800964355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0134 0.013447999954224
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.0018 0.0017769336700439
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.0005 0.00051593780517578
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.0006 0.00055289268493652
SELECT * FROM products WHERE id = 1626
199 0.0004 0.00035619735717773
SELECT * FROM products WHERE id = 4041
200 0.0003 0.00034379959106445
SELECT * FROM products WHERE id = 4312
201 0.0003 0.0003211498260498
SELECT * FROM products WHERE id = 777
202 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = 3881
203 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = 4213
204 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = '1626'
205 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0004 0.00040984153747559
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0008 0.00084090232849121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0005 0.00047492980957031
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00048589706420898
SELECT * FROM products WHERE id = '4041'
213 0.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0005 0.00053596496582031
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0004 0.00038814544677734
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0013 0.0012588500976562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0005 0.00053095817565918
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.00047612190246582
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = '4312'
221 0.0005 0.00045514106750488
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0007 0.00065898895263672
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0005 0.00045084953308105
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0012 0.0011758804321289
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.00049591064453125
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0004 0.00036787986755371
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00053715705871582
SELECT * FROM products WHERE id = '777'
229 0.0004 0.00044798851013184
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0005 0.00054407119750977
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0005 0.0005040168762207
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0013 0.0013208389282227
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.00058293342590332
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0005 0.00054693222045898
SELECT * FROM products WHERE id = '3881'
237 0.0005 0.00051403045654297
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0006 0.00057888031005859
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0004 0.00036311149597168
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0011 0.0011260509490967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0006 0.00061607360839844
SELECT * FROM products WHERE id = '4213'
245 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0006 0.00055885314941406
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0004 0.00037288665771484
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0011 0.001115083694458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0004 0.00044679641723633
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0022 0.0021779537200928
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0007 0.00071597099304199
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0023 0.0022690296173096
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0017 0.0016560554504395
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0006 0.00057291984558105
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0008 0.00081992149353027
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'