0

Infusion " Be Happy" Violette Citronnelle Verveine

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

Rooibos, violettes cristallisées, citronnelle, verveine, pommes Boite métal de 40g

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.4963991641998 272 0.8835 0


No Amazon API Requests Made.


App Debug - Total Time 1.4963991641998 seconds

Number Time From Start Name Description
1 0.57140517234802 Initialise Initialise FSB Function
2 0.57730007171631 App Controller Start Start of the App controller (called before the controller of every page)
3 0.61426401138306 Start of getCategoryListByGroup Function Before first category groups query
4 0.61584997177124 After initial query Before first category groups query
5 0.61585307121277 Get Category List for Group Before the call to getCategoryList function
6 0.61585712432861 Start of GetCategoryList function Start of the function
7 0.61586117744446 Before getting categories Query to get specific category list
8 0.61651110649109 After getting categories Query to get specific category list
9 0.61651611328125 Before getting category custom Before call to function getCategoryCustom
10 0.63132810592651 After getting category custom After call to function getCategoryCustom
11 0.63133001327515 Before getting category custom Before call to function getCategoryCustom
12 0.64225196838379 After getting category custom After call to function getCategoryCustom
13 0.64225602149963 Before getting category custom Before call to function getCategoryCustom
14 0.64841103553772 After getting category custom After call to function getCategoryCustom
15 0.64841508865356 Before getting category custom Before call to function getCategoryCustom
16 0.65258717536926 After getting category custom After call to function getCategoryCustom
17 0.65259003639221 Before getting category custom Before call to function getCategoryCustom
18 0.65674805641174 After getting category custom After call to function getCategoryCustom
19 0.65674996376038 Before getting category custom Before call to function getCategoryCustom
20 0.66111397743225 After getting category custom After call to function getCategoryCustom
21 0.66111707687378 End of GetCategoryList function End of the function
22 0.66112399101257 Get Category List for Group Before the call to getCategoryList function
23 0.66112613677979 Start of GetCategoryList function Start of the function
24 0.66112899780273 Before getting categories Query to get specific category list
25 0.66164302825928 End of getCategoryListByGroup Function Before return()
26 1.1987900733948 App Controller End End of the App controller (called before the controller of every page)
27 1.1993091106415 Product Start Start of the product info controller
28 1.2109470367432 Cache file not found Starting get product details
29 1.2478420734406 Related products Start getting related products if enabled
30 1.2478439807892 Related Products Start Before the related products are found
31 1.2478451728821 Related Products Keywords Before the related product keywords are found
32 1.2478489875793 Create Keyword List Function Start of function
33 1.2478749752045 Create Keyword List Function After looping provided content - 18 keywords found
34 1.248636007309 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
35 1.2486431598663 Create Keyword List Function After reducing keyword list
36 1.2486841678619 Create Keyword List Function After selecting by scoring keywords
37 1.2486879825592 Create Keyword List Function After final loop of keywords
38 1.2486901283264 Related Products Keywords After the related product keywords are found
39 1.3213219642639 Related Products End After the related products are found
40 1.358332157135 Product End End of the product info controller (Product Info)
41 1.3617150783539 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3643779754639 Before Get Options Before the call to getOptions in the tpl class
43 1.4540040493011 After Get Options After the call to getOptions in the tpl class
44 1.4541130065918 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4541440010071 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4603521823883 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4603559970856 Product Info: Before Template Display Before the template is displayed
48 1.4963641166687 Product Info: After Template Display After the template is displayed
49 1.4963791370392 Finalizing debug Before the debug is output to the page.
50 1.4963979721069 End of App This is the end of the app logging, final timestamp


Query Debug - 272 Database Queries. Total time 0.8835 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.002255916595459
SELECT parameter, value FROM parameters
2 0.0073 0.0073480606079102
SELECT * FROM `bad_bots`
3 0.0004 0.00040221214294434
SET time_zone = 'Europe/London'
4 0.0009 0.00092792510986328
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0035 0.0035221576690674
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.91\";}'
6 0.0030 0.0029928684234619
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737233325'
7 0.0037 0.0036940574645996
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00088596343994141
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0032 0.0032010078430176
SELECT id FROM pages WHERE pagename = 'infusion-be-happy-violette-citronnelle-verveine' LIMIT 1
10 0.0011 0.0011110305786133
SELECT id FROM products WHERE pagename = 'infusion-be-happy-violette-citronnelle-verveine' AND hidden = 0 LIMIT 1
11 0.0053 0.0053040981292725
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0307 0.030672073364258
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00055599212646484
SELECT * FROM pages WHERE pagename = 'infusion-be-happy-violette-citronnelle-verveine'
14 0.0016 0.0015718936920166
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00062704086303711
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0055 0.0054998397827148
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.0007 0.00066208839416504
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.0004 0.00043797492980957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053310394287109
SELECT id FROM categories WHERE parent_id = '26'
20 0.0055 0.0054850578308105
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.0005 0.00054502487182617
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.00059294700622559
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.00049090385437012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00045394897460938
SELECT * FROM categorygroups WHERE id = '1'
25 0.0035 0.0035309791564941
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.0005 0.00050687789916992
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.00041890144348145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.0005030632019043
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0037548542022705
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.00053787231445312
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.0006 0.00059604644775391
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.0005028247833252
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00046086311340332
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014069080352783
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.0004570484161377
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.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00040006637573242
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014910697937012
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.00048589706420898
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.00050497055053711
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.00044989585876465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00042009353637695
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00054383277893066
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.00044012069702148
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.0003 0.00033903121948242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00037693977355957
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00061917304992676
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.0005 0.00046515464782715
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.00048613548278809
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.00041604042053223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.0003819465637207
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00051689147949219
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.00040698051452637
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.00034618377685547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037503242492676
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00062108039855957
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.00044989585876465
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.00047802925109863
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.00047707557678223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00038003921508789
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00058293342590332
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.00042009353637695
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.0003 0.00034999847412109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0003809928894043
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066709518432617
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.0004270076751709
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.00051307678222656
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.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00044798851013184
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00050187110900879
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0027 0.0027091503143311
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0014519691467285
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00049400329589844
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.0012 0.0011930465698242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010988712310791
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010380744934082
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5228 0.52277898788452
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.91') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.91') <= INET_ATON(ip_end)
78 0.0027 0.0026700496673584
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0017 0.0016920566558838
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00079107284545898
SELECT * FROM products WHERE pagename = 'infusion-be-happy-violette-citronnelle-verveine'
81 0.0005 0.00050592422485352
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1072
82 0.0007 0.00066900253295898
SELECT * FROM manufacturers WHERE id = '270'
83 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '270'
84 0.0019 0.001878023147583
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '270' LIMIT 1
85 0.0008 0.00083303451538086
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '270' ORDER BY RAND() LIMIT 1
86 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '1162' ORDER BY sortorder ASC
87 0.0006 0.00063085556030273
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '270'
88 0.0006 0.00055789947509766
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '270'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00039982795715332
SELECT * FROM manufacturerimages WHERE manufacturer_id = '270'
90 0.0005 0.00054311752319336
SELECT category_id FROM products_categories WHERE product_id = '1072'
91 0.0006 0.00058603286743164
SELECT * FROM categories WHERE id = '27'
92 0.0048 0.0047528743743896
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.0006 0.00055193901062012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00039005279541016
SELECT id FROM categories WHERE parent_id = '27'
95 0.0041 0.004101037979126
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.0007021427154541
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.0006 0.00064301490783691
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.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00056695938110352
SELECT * FROM productimages WHERE product_id = '1072' ORDER BY sortorder ASC
100 0.0008 0.00076699256896973
SELECT * FROM product_image_select WHERE product_id = '1072'
101 0.0005 0.00047111511230469
SELECT * FROM productcustomimages WHERE product_id = '1072'
102 0.0017 0.0017299652099609
SELECT * FROM productfeeds WHERE product_id = '1072' ORDER BY item_date DESC
103 0.0025 0.0025050640106201
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0039 0.0039379596710205
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1072' AND t.hidden = 0 AND display_product = 1
105 0.0024 0.002392053604126
SELECT * FROM productamazoncontent WHERE product_id = '1072'
106 0.0012 0.001168966293335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname
107 0.0016 0.0015890598297119
SELECT * FROM productoffers WHERE product_id = '1072' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00046181678771973
SELECT * FROM productoffers
                WHERE product_id = '1072' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00042581558227539
SELECT * FROM productoffers
                WHERE product_id = 1072
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00056791305541992
SELECT value FROM productattributes
                WHERE product_id = '1072'
                AND name = 'ListPriceAmount'
111 0.0005 0.00046515464782715
SELECT value FROM productattributes WHERE product_id = '1072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00054693222045898
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.0117 0.01165509223938
SELECT *, MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AND 1072 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0009 0.00090789794921875
SELECT *, MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0006 0.00062799453735352
SELECT *, MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('happyandquot violette citronnelle' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0092 0.0091979503631592
SELECT *, MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AND 1072 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117 0.0006 0.00064706802368164
SELECT *, MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
118 0.0005 0.00046396255493164
SELECT *, MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andquot be happyandquot' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0102 0.010209798812866
SELECT *, MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AND 1072 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
120 0.0007 0.00073099136352539
SELECT *, MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0006 0.00063300132751465
SELECT *, MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('infusion andquot' IN BOOLEAN MODE) AND 1072 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
122 0.0005 0.00054097175598145
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0007 0.00073409080505371
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0012 0.001162052154541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0005 0.00054812431335449
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.00057816505432129
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00052881240844727
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
130 0.0006 0.00063800811767578
SELECT * FROM product_image_select WHERE product_id = '4924'
131 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '4924'
132 0.0011 0.0010750293731689
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
133 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.00048303604125977
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00062203407287598
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
137 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '1251'
138 0.0004 0.00040912628173828
SELECT * FROM productcustomimages WHERE product_id = '1251'
139 0.0016 0.0016491413116455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
140 0.0006 0.00056314468383789
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0005 0.00049400329589844
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0007 0.00065994262695312
SELECT * FROM productimages WHERE product_id = '1022' ORDER BY sortorder ASC
144 0.0012 0.0011889934539795
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1022' AND p.id = pi.product_id ORDER BY pi.sortorder
145 0.0007 0.00070095062255859
SELECT * FROM product_image_select WHERE product_id = '1022'
146 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '1022'
147 0.0007 0.00073003768920898
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 = '1022'
                GROUP BY o.product_id
148 0.0034 0.0034151077270508
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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
149 0.0006 0.00064897537231445
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
150 0.0013 0.0012850761413574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1022' AND a.name = n.originalname
151 0.0005 0.00046086311340332
SELECT * FROM productoffers WHERE product_id = '1022' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00045609474182129
SELECT * FROM productoffers
                WHERE product_id = '1022' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = 1022
                ORDER BY price ASC LIMIT 1
154 0.0007 0.00065398216247559
SELECT value FROM productattributes
                WHERE product_id = '1022'
                AND name = 'ListPriceAmount'
155 0.0005 0.00054717063903809
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 = '1022'
                GROUP BY o.product_id
156 0.0009 0.0008690357208252
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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
157 0.0005 0.0004570484161377
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
158 0.0006 0.0005791187286377
SELECT value FROM productattributes WHERE product_id = '1022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0007 0.00074386596679688
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1022'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
160 0.0006 0.00060176849365234
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
161 0.0006 0.00063085556030273
SELECT * FROM product_image_select WHERE product_id = '4921'
162 0.0004 0.00042200088500977
SELECT * FROM productcustomimages WHERE product_id = '4921'
163 0.0014 0.0013959407806396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
164 0.0005 0.00050616264343262
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0005 0.00045895576477051
SELECT * FROM productimages WHERE product_id = '1159' ORDER BY sortorder ASC
168 0.0006 0.00059103965759277
SELECT * FROM product_image_select WHERE product_id = '1159'
169 0.0004 0.00040411949157715
SELECT * FROM productcustomimages WHERE product_id = '1159'
170 0.0010 0.00095796585083008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1159' AND a.name = n.originalname
171 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '1159' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '1159' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0005 0.00045585632324219
SELECT value FROM productattributes WHERE product_id = '1159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0005 0.00052785873413086
SELECT id,asin FROM products WHERE parent_id = 1072
175 0.0017 0.0016829967498779
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1072' ORDER BY timestamp DESC
176 0.0005 0.00049591064453125
SELECT category_id FROM products_categories WHERE product_id = '1072'
177 0.0005 0.00051212310791016
SELECT * FROM categories WHERE id = '27'
178 0.0055 0.0055232048034668
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
179 0.0006 0.00056314468383789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0004 0.00043606758117676
SELECT id FROM categories WHERE parent_id = '27'
181 0.0041 0.0040931701660156
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 
182 0.0007 0.00067019462585449
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 
183 0.0007 0.00068211555480957
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
184 0.0005 0.00052094459533691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0010 0.00095987319946289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname
186 0.0005 0.00052785873413086
SELECT * FROM productoffers WHERE product_id = '1072' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0006 0.00059413909912109
SELECT * FROM productoffers
                WHERE product_id = '1072' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = 1072
                ORDER BY price ASC LIMIT 1
189 0.0005 0.00047516822814941
SELECT value FROM productattributes
                WHERE product_id = '1072'
                AND name = 'ListPriceAmount'
190 0.0008 0.00076794624328613
SELECT * FROM products WHERE id = '1072'
191 0.0005 0.00048112869262695
SELECT value FROM productattributes WHERE product_id = '1072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0008 0.00078201293945312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname
193 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '1072' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '1072' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = 1072
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00044703483581543
SELECT value FROM productattributes
                WHERE product_id = '1072'
                AND name = 'ListPriceAmount'
197 0.0005 0.00047993659973145
SELECT category_id FROM products_categories WHERE product_id = '1072' AND prod_type = 'amz'
198 0.0004 0.00043702125549316
SELECT parent_id FROM categories WHERE id = '27'
199 0.0004 0.00038790702819824
SELECT * FROM categories WHERE id = '27'
200 0.0039 0.0038669109344482
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
201 0.0005 0.00048685073852539
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
202 0.0006 0.00058984756469727
SELECT id FROM categories WHERE parent_id = '27'
203 0.0047 0.0047199726104736
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 
204 0.0015 0.0014700889587402
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 
205 0.0010 0.00097203254699707
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
206 0.0007 0.00069379806518555
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
207 0.0027 0.0027339458465576
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
208 0.0021 0.0020978450775146
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
209 0.0005 0.00049209594726562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
210 0.0350 0.034985065460205
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
211 0.0027 0.0026640892028809
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
212 0.0007 0.00068306922912598
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
213 0.0007 0.00068521499633789
SELECT * FROM products WHERE id = 1626
214 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = 4041
215 0.0006 0.00055718421936035
SELECT * FROM products WHERE id = 4312
216 0.0006 0.00060510635375977
SELECT * FROM products WHERE id = 777
217 0.0006 0.00062799453735352
SELECT * FROM products WHERE id = 3881
218 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = 4213
219 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = '1626'
220 0.0006 0.00060296058654785
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
221 0.0008 0.00075292587280273
SELECT * FROM product_image_select WHERE product_id = '1626'
222 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '1626'
223 0.0011 0.0010988712310791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
224 0.0006 0.00057315826416016
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0005 0.00050020217895508
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0007 0.00070500373840332
SELECT * FROM products WHERE id = '4041'
228 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
229 0.0007 0.00068378448486328
SELECT * FROM product_image_select WHERE product_id = '4041'
230 0.0004 0.00043296813964844
SELECT * FROM productcustomimages WHERE product_id = '4041'
231 0.0017 0.0017039775848389
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
232 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0005 0.00053215026855469
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0007 0.00072193145751953
SELECT * FROM products WHERE id = '4312'
236 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
237 0.0008 0.00075292587280273
SELECT * FROM product_image_select WHERE product_id = '4312'
238 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '4312'
239 0.0015 0.0015461444854736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
240 0.0005 0.00054192543029785
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.00053811073303223
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.0005040168762207
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0006 0.00059890747070312
SELECT * FROM products WHERE id = '777'
244 0.0006 0.00055813789367676
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
245 0.0008 0.0007779598236084
SELECT * FROM product_image_select WHERE product_id = '777'
246 0.0004 0.00043416023254395
SELECT * FROM productcustomimages WHERE product_id = '777'
247 0.0016 0.0016100406646729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
248 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0004 0.00043582916259766
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0007 0.00072598457336426
SELECT * FROM products WHERE id = '3881'
252 0.0008 0.00081491470336914
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
253 0.0007 0.0007328987121582
SELECT * FROM product_image_select WHERE product_id = '3881'
254 0.0005 0.00049996376037598
SELECT * FROM productcustomimages WHERE product_id = '3881'
255 0.0018 0.0017728805541992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
256 0.0006 0.0006108283996582
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0004 0.00042486190795898
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0007 0.00066399574279785
SELECT * FROM products WHERE id = '4213'
260 0.0008 0.00079584121704102
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
261 0.0007 0.0007328987121582
SELECT * FROM product_image_select WHERE product_id = '4213'
262 0.0005 0.00048589706420898
SELECT * FROM productcustomimages WHERE product_id = '4213'
263 0.0017 0.0017218589782715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
264 0.0005 0.00054192543029785
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0005 0.00046706199645996
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0029 0.0029418468475342
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
268 0.0011 0.0010669231414795
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
269 0.0039 0.0039219856262207
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
270 0.0027 0.0027060508728027
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
271 0.0008 0.00081396102905273
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
272 0.0009 0.00091195106506348
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'