0

Løv Organic - Coffret All My Løv Rooibos

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-07 02:14:20 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.4285910129547 266 1.0868 0


No Amazon API Requests Made.


App Debug - Total Time 1.4285910129547 seconds

Number Time From Start Name Description
1 0.29034495353699 Initialise Initialise FSB Function
2 0.29716300964355 App Controller Start Start of the App controller (called before the controller of every page)
3 0.33870005607605 Start of getCategoryListByGroup Function Before first category groups query
4 0.34043097496033 After initial query Before first category groups query
5 0.34043288230896 Get Category List for Group Before the call to getCategoryList function
6 0.34043502807617 Start of GetCategoryList function Start of the function
7 0.34043788909912 Before getting categories Query to get specific category list
8 0.34204983711243 After getting categories Query to get specific category list
9 0.34205102920532 Before getting category custom Before call to function getCategoryCustom
10 0.36445283889771 After getting category custom After call to function getCategoryCustom
11 0.36445593833923 Before getting category custom Before call to function getCategoryCustom
12 0.37629199028015 After getting category custom After call to function getCategoryCustom
13 0.3762948513031 Before getting category custom Before call to function getCategoryCustom
14 0.38227391242981 After getting category custom After call to function getCategoryCustom
15 0.38227486610413 Before getting category custom Before call to function getCategoryCustom
16 0.38646697998047 After getting category custom After call to function getCategoryCustom
17 0.38646697998047 Before getting category custom Before call to function getCategoryCustom
18 0.39053297042847 After getting category custom After call to function getCategoryCustom
19 0.39053606987 Before getting category custom Before call to function getCategoryCustom
20 0.39473295211792 After getting category custom After call to function getCategoryCustom
21 0.39473390579224 End of GetCategoryList function End of the function
22 0.3947389125824 Get Category List for Group Before the call to getCategoryList function
23 0.39474105834961 Start of GetCategoryList function Start of the function
24 0.39474105834961 Before getting categories Query to get specific category list
25 0.39519286155701 End of getCategoryListByGroup Function Before return()
26 1.1722459793091 App Controller End End of the App controller (called before the controller of every page)
27 1.1826000213623 Product Start Start of the product info controller
28 1.1841959953308 Cache file not found Starting get product details
29 1.2229149341583 Related products Start getting related products if enabled
30 1.2229158878326 Related Products Start Before the related products are found
31 1.2229158878326 Related Products Keywords Before the related product keywords are found
32 1.2229189872742 Create Keyword List Function Start of function
33 1.2229380607605 Create Keyword List Function After looping provided content - 17 keywords found
34 1.2232859134674 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.2232899665833 Create Keyword List Function After reducing keyword list
36 1.2233190536499 Create Keyword List Function After selecting by scoring keywords
37 1.2233219146729 Create Keyword List Function After final loop of keywords
38 1.2233228683472 Related Products Keywords After the related product keywords are found
39 1.272057056427 Related Products End After the related products are found
40 1.3156199455261 Product End End of the product info controller (Product Info)
41 1.3181500434875 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3203098773956 Before Get Options Before the call to getOptions in the tpl class
43 1.37535405159 After Get Options After the call to getOptions in the tpl class
44 1.37544298172 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3754689693451 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3847749233246 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3847770690918 Product Info: Before Template Display Before the template is displayed
48 1.4285728931427 Product Info: After Template Display After the template is displayed
49 1.4285809993744 Finalizing debug Before the debug is output to the page.
50 1.4285910129547 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 1.0868 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022201538085938
SELECT parameter, value FROM parameters
2 0.0076 0.0076389312744141
SELECT * FROM `bad_bots`
3 0.0005 0.00046682357788086
SET time_zone = 'Europe/London'
4 0.0010 0.00099778175354004
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.002485990524292
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.89\";}'
6 0.0021 0.0021159648895264
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745031118'
7 0.0038 0.0038149356842041
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00098800659179688
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0037 0.0037491321563721
SELECT id FROM pages WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos' LIMIT 1
10 0.0014 0.001446008682251
SELECT id FROM products WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos' AND hidden = 0 LIMIT 1
11 0.0051 0.0050630569458008
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0355 0.035480976104736
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00072717666625977
SELECT * FROM pages WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos'
14 0.0017 0.0017189979553223
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0016 0.0015990734100342
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0066 0.0065572261810303
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0022 0.0022120475769043
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0016 0.0015530586242676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0059359073638916
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0019 0.0018949508666992
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0017 0.0017149448394775
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0015 0.0014891624450684
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00045394897460938
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037870407104492
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00055694580078125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00038385391235352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00042009353637695
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.00472092628479
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00045108795166016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00038003921508789
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.001446008682251
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.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 = 28
36 0.0004 0.00036907196044922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015120506286621
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00045490264892578
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0004 0.00044608116149902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00038504600524902
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005488395690918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.00042390823364258
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064706802368164
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0004 0.00044894218444824
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.00052785873413086
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00040197372436523
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00052404403686523
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0004 0.00041604042053223
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00033187866210938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00064206123352051
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0004 0.0004420280456543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0005 0.00048995018005371
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0004 0.00042510032653809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00037813186645508
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00056195259094238
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.00039100646972656
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00035309791564941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00036811828613281
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00061893463134766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00049614906311035
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0006 0.00057101249694824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00038290023803711
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00044798851013184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0030570030212402
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0014820098876953
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00052404403686523
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0013 0.0012810230255127
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.001060962677002
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00078606605529785
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7641 0.76405620574951
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.89') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.89') <= INET_ATON(ip_end)
78 0.0022 0.0021650791168213
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0011 0.0011329650878906
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00061488151550293
SELECT * FROM products WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos'
81 0.0004 0.00038790702819824
UPDATE products SET viewcount = viewcount + 1 WHERE id = 953
82 0.0005 0.00048494338989258
SELECT * FROM manufacturers WHERE id = '249'
83 0.0005 0.00054717063903809
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
84 0.0015 0.0015079975128174
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '249' LIMIT 1
85 0.0018 0.0017859935760498
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '249' ORDER BY RAND() LIMIT 1
86 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '1249' ORDER BY sortorder ASC
87 0.0005 0.00047183036804199
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
88 0.0005 0.00051498413085938
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '249'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00044107437133789
SELECT * FROM manufacturerimages WHERE manufacturer_id = '249'
90 0.0004 0.00043702125549316
SELECT category_id FROM products_categories WHERE product_id = '953'
91 0.0005 0.00054192543029785
SELECT * FROM categories WHERE id = '27'
92 0.0042 0.0041689872741699
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0004 0.00040292739868164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00032901763916016
SELECT id FROM categories WHERE parent_id = '27'
95 0.0041 0.0040581226348877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0007 0.00065803527832031
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0007 0.00069379806518555
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0007 0.0007319450378418
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00062394142150879
SELECT * FROM productimages WHERE product_id = '953' ORDER BY sortorder ASC
100 0.0021 0.0020568370819092
SELECT * FROM product_image_select WHERE product_id = '953'
101 0.0018 0.0017859935760498
SELECT * FROM productcustomimages WHERE product_id = '953'
102 0.0020 0.0020060539245605
SELECT * FROM productfeeds WHERE product_id = '953' ORDER BY item_date DESC
103 0.0044 0.0044209957122803
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0026 0.0026149749755859
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '953' AND t.hidden = 0 AND display_product = 1
105 0.0013 0.0013341903686523
SELECT * FROM productamazoncontent WHERE product_id = '953'
106 0.0009 0.00094795227050781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
107 0.0018 0.0018038749694824
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00054192543029785
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00054502487182617
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
111 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00050210952758789
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
113 0.0121 0.012058973312378
SELECT *, MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AND 953 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0007 0.00070786476135254
SELECT *, MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AND 953 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0005 0.00053811073303223
SELECT *, MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('lÃv organic coffret' IN BOOLEAN MODE) AND 953 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0007 0.00065898895263672
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
117 0.0006 0.00056004524230957
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
118 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '822'
119 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '822'
120 0.0005 0.00052618980407715
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
121 0.0026 0.0026497840881348
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
122 0.0005 0.00053620338439941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
123 0.0010 0.00096583366394043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
124 0.0004 0.00038290023803711
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00037288665771484
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
128 0.0005 0.00045895576477051
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
129 0.0007 0.00065207481384277
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
130 0.0004 0.00042200088500977
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
131 0.0006 0.00061202049255371
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0007 0.00070714950561523
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
133 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
134 0.0006 0.00055813789367676
SELECT * FROM product_image_select WHERE product_id = '923'
135 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '923'
136 0.0010 0.0010337829589844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
137 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.00036501884460449
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0006 0.00055789947509766
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
141 0.0006 0.00059008598327637
SELECT * FROM product_image_select WHERE product_id = '938'
142 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '938'
143 0.0007 0.00070095062255859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
144 0.0004 0.00040316581726074
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0003 0.00034809112548828
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
148 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '4919'
149 0.0004 0.00038695335388184
SELECT * FROM productcustomimages WHERE product_id = '4919'
150 0.0011 0.0010890960693359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
151 0.0005 0.00049519538879395
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00040578842163086
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00047492980957031
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
155 0.0005 0.0005488395690918
SELECT * FROM product_image_select WHERE product_id = '1089'
156 0.0004 0.00037193298339844
SELECT * FROM productcustomimages WHERE product_id = '1089'
157 0.0011 0.0011301040649414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
158 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0006 0.00057816505432129
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
162 0.0007 0.00071287155151367
SELECT * FROM product_image_select WHERE product_id = '4917'
163 0.0005 0.00053691864013672
SELECT * FROM productcustomimages WHERE product_id = '4917'
164 0.0032 0.0032141208648682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
165 0.0012 0.0012328624725342
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0009 0.0009148120880127
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0010 0.0010039806365967
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0010 0.00097107887268066
SELECT id,asin FROM products WHERE parent_id = 953
169 0.0041 0.004141092300415
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '953' ORDER BY timestamp DESC
170 0.0008 0.00083398818969727
SELECT category_id FROM products_categories WHERE product_id = '953'
171 0.0008 0.00082492828369141
SELECT * FROM categories WHERE id = '27'
172 0.0093 0.0092949867248535
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
173 0.0005 0.00052213668823242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0003 0.00034117698669434
SELECT id FROM categories WHERE parent_id = '27'
175 0.0054 0.0054278373718262
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 
176 0.0006 0.00060701370239258
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
177 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
178 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0008 0.00080704689025879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
180 0.0004 0.00041079521179199
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00038790702819824
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00032591819763184
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
183 0.0004 0.0003809928894043
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
184 0.0005 0.00048184394836426
SELECT * FROM products WHERE id = '953'
185 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0006 0.00056004524230957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
187 0.0003 0.00031113624572754
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00035595893859863
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
191 0.0004 0.00042200088500977
SELECT category_id FROM products_categories WHERE product_id = '953' AND prod_type = 'amz'
192 0.0004 0.0004279613494873
SELECT parent_id FROM categories WHERE id = '27'
193 0.0004 0.00037693977355957
SELECT * FROM categories WHERE id = '27'
194 0.0056 0.0055751800537109
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
195 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '27'
197 0.0051 0.00506591796875
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 
198 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
199 0.0005 0.0005490779876709
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
200 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0020 0.0019879341125488
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0017 0.0017421245574951
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0003 0.00034999847412109
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0179 0.017868041992188
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
205 0.0016 0.0015580654144287
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
206 0.0005 0.00049209594726562
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
207 0.0005 0.00053811073303223
SELECT * FROM products WHERE id = 1626
208 0.0003 0.00033783912658691
SELECT * FROM products WHERE id = 4041
209 0.0004 0.00036811828613281
SELECT * FROM products WHERE id = 4312
210 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = 777
211 0.0004 0.00035905838012695
SELECT * FROM products WHERE id = 3881
212 0.0003 0.00034904479980469
SELECT * FROM products WHERE id = 4213
213 0.0003 0.00031709671020508
SELECT * FROM products WHERE id = '1626'
214 0.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0005 0.00054192543029785
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0003 0.00034713745117188
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0008 0.00075697898864746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0007 0.00074505805969238
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00043320655822754
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0005 0.0004878044128418
SELECT * FROM products WHERE id = '4041'
222 0.0004 0.00043606758117676
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0006 0.00057697296142578
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = '4312'
230 0.0004 0.00039386749267578
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0006 0.00060415267944336
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0004 0.00036406517028809
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0010 0.00098204612731934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0004 0.00040698051452637
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00040411949157715
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = '777'
238 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0005 0.00053215026855469
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0004 0.00035190582275391
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0009 0.00094914436340332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0004 0.00043010711669922
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.00035405158996582
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = '3881'
246 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0005 0.00052213668823242
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0004 0.00035691261291504
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0010 0.0010299682617188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0005 0.00047802925109863
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0004 0.00040888786315918
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0005 0.00051093101501465
SELECT * FROM products WHERE id = '4213'
254 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0005 0.00054597854614258
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0004 0.00036406517028809
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0011 0.0010628700256348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0004 0.00044703483581543
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0018 0.0017549991607666
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0006 0.00062012672424316
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0021 0.0020730495452881
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0018 0.0017578601837158
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0005 0.00046610832214355
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0007 0.00069880485534668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'