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.5387330055237 266 1.1747 0


No Amazon API Requests Made.


App Debug - Total Time 1.5387330055237 seconds

Number Time From Start Name Description
1 0.34923386573792 Initialise Initialise FSB Function
2 0.35103702545166 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38722801208496 Start of getCategoryListByGroup Function Before first category groups query
4 0.38923406600952 After initial query Before first category groups query
5 0.38923501968384 Get Category List for Group Before the call to getCategoryList function
6 0.38923788070679 Start of GetCategoryList function Start of the function
7 0.389240026474 Before getting categories Query to get specific category list
8 0.39133286476135 After getting categories Query to get specific category list
9 0.39133501052856 Before getting category custom Before call to function getCategoryCustom
10 0.42020797729492 After getting category custom After call to function getCategoryCustom
11 0.42021083831787 Before getting category custom Before call to function getCategoryCustom
12 0.43570303916931 After getting category custom After call to function getCategoryCustom
13 0.43570590019226 Before getting category custom Before call to function getCategoryCustom
14 0.4469690322876 After getting category custom After call to function getCategoryCustom
15 0.44697093963623 Before getting category custom Before call to function getCategoryCustom
16 0.45289301872253 After getting category custom After call to function getCategoryCustom
17 0.45289397239685 Before getting category custom Before call to function getCategoryCustom
18 0.45849204063416 After getting category custom After call to function getCategoryCustom
19 0.45849394798279 Before getting category custom Before call to function getCategoryCustom
20 0.46345400810242 After getting category custom After call to function getCategoryCustom
21 0.46345496177673 End of GetCategoryList function End of the function
22 0.46346092224121 Get Category List for Group Before the call to getCategoryList function
23 0.46346187591553 Start of GetCategoryList function Start of the function
24 0.46346306800842 Before getting categories Query to get specific category list
25 0.46405100822449 End of getCategoryListByGroup Function Before return()
26 1.3197629451752 App Controller End End of the App controller (called before the controller of every page)
27 1.3202819824219 Product Start Start of the product info controller
28 1.3351609706879 Cache file not found Starting get product details
29 1.3625800609589 Related products Start getting related products if enabled
30 1.3625819683075 Related Products Start Before the related products are found
31 1.3625819683075 Related Products Keywords Before the related product keywords are found
32 1.3625860214233 Create Keyword List Function Start of function
33 1.3626809120178 Create Keyword List Function After looping provided content - 17 keywords found
34 1.363077878952 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.3630828857422 Create Keyword List Function After reducing keyword list
36 1.3631119728088 Create Keyword List Function After selecting by scoring keywords
37 1.3631148338318 Create Keyword List Function After final loop of keywords
38 1.3631160259247 Related Products Keywords After the related product keywords are found
39 1.4226398468018 Related Products End After the related products are found
40 1.4604468345642 Product End End of the product info controller (Product Info)
41 1.4613380432129 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4622280597687 Before Get Options Before the call to getOptions in the tpl class
43 1.5284278392792 After Get Options After the call to getOptions in the tpl class
44 1.5285499095917 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5285739898682 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5315999984741 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.53160405159 Product Info: Before Template Display Before the template is displayed
48 1.5387179851532 Product Info: After Template Display After the template is displayed
49 1.538724899292 Finalizing debug Before the debug is output to the page.
50 1.5387330055237 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 1.1747 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0021190643310547
SELECT parameter, value FROM parameters
2 0.0024 0.0024049282073975
SELECT * FROM `bad_bots`
3 0.0003 0.00029706954956055
SET time_zone = 'Europe/London'
4 0.0016 0.0015950202941895
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011019706726074
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.217.136.187\";}'
6 0.0005 0.00051093101501465
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745062440'
7 0.0007 0.00069594383239746
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047993659973145
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00052595138549805
SELECT id FROM pages WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos' LIMIT 1
10 0.0006 0.00055813789367676
SELECT id FROM products WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos' AND hidden = 0 LIMIT 1
11 0.0016 0.0015521049499512
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0324 0.032410860061646
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0018 0.0018320083618164
SELECT * FROM pages WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos'
14 0.0020 0.0019919872283936
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0021 0.0020720958709717
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0097 0.0096819400787354
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.0006 0.00064802169799805
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.0005 0.00045514106750488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00057005882263184
SELECT id FROM categories WHERE parent_id = '26'
20 0.0149 0.01487398147583
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.0010 0.0010151863098145
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.0006 0.00058984756469727
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.0005 0.0005040168762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00042819976806641
SELECT * FROM categorygroups WHERE id = '1'
25 0.0052 0.0051629543304443
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.00059008598327637
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.0005 0.00046086311340332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00044107437133789
SELECT id FROM categories WHERE parent_id = '27'
29 0.0062 0.0062379837036133
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.0008 0.00076103210449219
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.0008 0.00081491470336914
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.00050997734069824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00044703483581543
SELECT * FROM categorygroups WHERE id = '1'
34 0.0029 0.0028579235076904
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.0008 0.0007781982421875
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.0005 0.00054216384887695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.0006108283996582
SELECT id FROM categories WHERE parent_id = '28'
38 0.0034 0.0034019947052002
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.0010 0.00098299980163574
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.0008 0.00080013275146484
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.0007 0.0006561279296875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.00057578086853027
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00084710121154785
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.0006 0.00060391426086426
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.0005 0.00054597854614258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00052309036254883
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.0007939338684082
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.0006 0.00060200691223145
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.0007 0.00072598457336426
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.0006 0.00064396858215332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00058484077453613
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00077104568481445
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.0006 0.00062894821166992
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.0005 0.00048494338989258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00090289115905762
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.0007 0.00070405006408691
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.0006 0.00059103965759277
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047397613525391
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00067996978759766
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.0005 0.00054717063903809
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.0005 0.00046300888061523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00047492980957031
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00072693824768066
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.0005190372467041
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.00053596496582031
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.0005 0.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00046586990356445
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.000579833984375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0017 0.0016589164733887
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0009 0.0008540153503418
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00060200691223145
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.0005 0.00048184394836426
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0016 0.0015978813171387
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010421276092529
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8464 0.84637999534607
SELECT * FROM ipgeocountries WHERE INET_ATON('18.217.136.187') >= INET_ATON(ip_start) AND INET_ATON('18.217.136.187') <= INET_ATON(ip_end)
78 0.0016 0.0016341209411621
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.0005500316619873
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00069499015808105
SELECT * FROM products WHERE pagename = 'lv-organic-coffret-all-my-lv-rooibos'
81 0.0070 0.0069770812988281
UPDATE products SET viewcount = viewcount + 1 WHERE id = 953
82 0.0009 0.00086593627929688
SELECT * FROM manufacturers WHERE id = '249'
83 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
84 0.0005 0.00052404403686523
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '249' LIMIT 1
85 0.0008 0.000762939453125
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.00041294097900391
SELECT * FROM productimages WHERE product_id = '953' ORDER BY sortorder ASC
87 0.0005 0.00048208236694336
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.00035691261291504
SELECT * FROM manufacturerimages WHERE manufacturer_id = '249'
90 0.0006 0.00061202049255371
SELECT category_id FROM products_categories WHERE product_id = '953'
91 0.0005 0.00048208236694336
SELECT * FROM categories WHERE id = '27'
92 0.0051 0.0050702095031738
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.00042581558227539
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00031614303588867
SELECT id FROM categories WHERE parent_id = '27'
95 0.0048 0.0047619342803955
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.0009 0.00092887878417969
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.00068116188049316
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.0006 0.00057005882263184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0009 0.00086808204650879
SELECT * FROM productimages WHERE product_id = '953' ORDER BY sortorder ASC
100 0.0007 0.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '953'
101 0.0005 0.00054001808166504
SELECT * FROM productcustomimages WHERE product_id = '953'
102 0.0005 0.00052785873413086
SELECT * FROM productfeeds WHERE product_id = '953' ORDER BY item_date DESC
103 0.0009 0.00092911720275879
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.0007 0.0007479190826416
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.0005 0.00054812431335449
SELECT * FROM productamazoncontent WHERE product_id = '953'
106 0.0009 0.00089311599731445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
107 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00043392181396484
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00042295455932617
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
111 0.0005 0.00047707557678223
SELECT value FROM productattributes WHERE product_id = '953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0006 0.00059103965759277
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.0155 0.015504121780396
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.0008 0.00079107284545898
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.0012 0.0011608600616455
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.0006 0.00059700012207031
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
117 0.0006 0.0006258487701416
SELECT * FROM product_image_select WHERE product_id = '4919'
118 0.0006 0.00058603286743164
SELECT * FROM productcustomimages WHERE product_id = '4919'
119 0.0025 0.0025489330291748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
120 0.0009 0.00087189674377441
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0023 0.0023419857025146
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0014 0.0014221668243408
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0009 0.00086593627929688
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
124 0.0013 0.0012819766998291
SELECT * FROM product_image_select WHERE product_id = '1089'
125 0.0006 0.00056815147399902
SELECT * FROM productcustomimages WHERE product_id = '1089'
126 0.0015 0.0014879703521729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
127 0.0009 0.00094699859619141
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0006 0.00056195259094238
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0006 0.00063991546630859
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
131 0.0007 0.00070595741271973
SELECT * FROM product_image_select WHERE product_id = '4917'
132 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '4917'
133 0.0016 0.0016219615936279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
134 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00046586990356445
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0007 0.00070405006408691
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
138 0.0007 0.00070977210998535
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
139 0.0007 0.00070285797119141
SELECT * FROM product_image_select WHERE product_id = '822'
140 0.0006 0.00055503845214844
SELECT * FROM productcustomimages WHERE product_id = '822'
141 0.0007 0.00069999694824219
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
142 0.0008 0.0007779598236084
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
143 0.0005 0.0004580020904541
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
144 0.0013 0.00130295753479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
145 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00044393539428711
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
149 0.0005 0.00049710273742676
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
150 0.0009 0.00086379051208496
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
151 0.0005 0.00046086311340332
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
152 0.0006 0.00063109397888184
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0008 0.00080394744873047
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
154 0.0005 0.00052714347839355
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
155 0.0006 0.00063800811767578
SELECT * FROM product_image_select WHERE product_id = '938'
156 0.0005 0.00047779083251953
SELECT * FROM productcustomimages WHERE product_id = '938'
157 0.0010 0.00096416473388672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
158 0.0006 0.00062394142150879
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00047683715820312
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0010 0.0010330677032471
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
162 0.0007 0.0006861686706543
SELECT * FROM product_image_select WHERE product_id = '923'
163 0.0005 0.0005040168762207
SELECT * FROM productcustomimages WHERE product_id = '923'
164 0.0012 0.0012469291687012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
165 0.0008 0.000762939453125
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0005 0.00050497055053711
SELECT id,asin FROM products WHERE parent_id = 953
169 0.0005 0.00047111511230469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '953' ORDER BY timestamp DESC
170 0.0005 0.00049591064453125
SELECT category_id FROM products_categories WHERE product_id = '953'
171 0.0005 0.00049495697021484
SELECT * FROM categories WHERE id = '27'
172 0.0049 0.004889965057373
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.0008 0.00078105926513672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0008 0.0007779598236084
SELECT id FROM categories WHERE parent_id = '27'
175 0.0069 0.0068638324737549
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.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 (27)
				  AND p.disabled = 0 
177 0.0007 0.00071907043457031
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.0006 0.00059604644775391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0011 0.0010890960693359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
180 0.0005 0.00050997734069824
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00037813186645508
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00035905838012695
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
183 0.0004 0.0004279613494873
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
184 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = '953'
185 0.0005 0.00045180320739746
SELECT value FROM productattributes WHERE product_id = '953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0008 0.00075697898864746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '953' AND a.name = n.originalname
187 0.0004 0.00036907196044922
SELECT * FROM productoffers WHERE product_id = '953' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '953' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.0003511905670166
SELECT * FROM productoffers
                WHERE product_id = 953
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00039792060852051
SELECT value FROM productattributes
                WHERE product_id = '953'
                AND name = 'ListPriceAmount'
191 0.0005 0.00051593780517578
SELECT category_id FROM products_categories WHERE product_id = '953' AND prod_type = 'amz'
192 0.0005 0.00046896934509277
SELECT parent_id FROM categories WHERE id = '27'
193 0.0003 0.00034499168395996
SELECT * FROM categories WHERE id = '27'
194 0.0049 0.0048770904541016
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.0005 0.00054717063903809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '27'
197 0.0054 0.0053939819335938
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.00063419342041016
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.0006 0.00061607360839844
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.0006 0.00055193901062012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0006 0.00056195259094238
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0005 0.00047683715820312
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0004 0.00037193298339844
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0227 0.022717952728271
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.0008 0.00080108642578125
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.0006 0.00062394142150879
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.0006 0.00055217742919922
SELECT * FROM products WHERE id = 1626
208 0.0004 0.00036811828613281
SELECT * FROM products WHERE id = 4041
209 0.0004 0.00037717819213867
SELECT * FROM products WHERE id = 4312
210 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 777
211 0.0022 0.0022428035736084
SELECT * FROM products WHERE id = 3881
212 0.0005 0.00051689147949219
SELECT * FROM products WHERE id = 4213
213 0.0004 0.00039505958557129
SELECT * FROM products WHERE id = '1626'
214 0.0006 0.00061297416687012
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0007 0.00072216987609863
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0005 0.00046801567077637
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0012 0.0011730194091797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0005 0.00052285194396973
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00042486190795898
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00054717063903809
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00055813789367676
SELECT * FROM products WHERE id = '4041'
222 0.0005 0.00052094459533691
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0006 0.00064396858215332
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0004 0.00040888786315918
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0014 0.0013952255249023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0006 0.00056314468383789
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00048708915710449
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00054717063903809
SELECT * FROM products WHERE id = '4312'
230 0.0005 0.00050806999206543
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0008 0.00075888633728027
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0005 0.00045180320739746
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0014 0.0013649463653564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0005 0.00053906440734863
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0005 0.00054383277893066
SELECT * FROM products WHERE id = '777'
238 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0007 0.0006871223449707
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0013 0.0013289451599121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0005 0.00054478645324707
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0006 0.00059294700622559
SELECT * FROM products WHERE id = '3881'
246 0.0005 0.00048112869262695
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0006 0.00056099891662598
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0005 0.00052189826965332
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0012 0.001194953918457
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0010 0.00096893310546875
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0006 0.00060606002807617
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0007 0.00069594383239746
SELECT * FROM products WHERE id = '4213'
254 0.0006 0.00063204765319824
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0007 0.00072908401489258
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0005 0.0004880428314209
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0018 0.0018060207366943
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0006 0.00058794021606445
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0005 0.00050711631774902
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0005 0.00051498413085938
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0012 0.0012481212615967
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0008 0.00078988075256348
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0017 0.0016658306121826
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0007 0.00074100494384766
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0006 0.00061893463134766
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0007 0.00069689750671387
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'