0
  1. My Store
  2. Cafés

?? CAFE GRAIN 1kg BIO | Café en Grain Arabica | Coffret café dégustation, Torréfaction Artisanale, 4x250g | Idée Cadeau

Price: €32,97
Product prices and availability are accurate as of 2022-06-18 08:57:56 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.
Availability: In Stock
Click and Choose Options
Buy Now from Amazon
En stock.
Product Information (more info)
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

???? CAFE EN GRAIN BIO - Le café grains Origeens est certifié agriculture biologique : La culture des grains de café a été faite sans utiliser de produits chimiques pour respecter leur nature et la Nature. Dégustez un café grain avec un goût préservé et parfumé ???? COFFRET DEGUSTATION AMÉRIQUE LATINE - Cette boîte est constituée de 4 cafés en grains, 100% Arabica, pour vous faire voyager au coeur de l’Amérique latine: 3 pure origines (Brésil, Colombie, Mexique) et 1 mélange des 3 origines, afin de vous offrir une palette de saveurs et d’intensité différentes. Idée cadeau idéale pour les amateurs de café! ???? TORRÉFACTION ARTISANALE ITALIENNE - Les grains ont été torréfiés artisanalement par notre torréfacteur italien de façon lente (20min), permettant de respecter les saveurs et d’enchanter vos papilles d’arômes subtils. ???? POUR TOUTES LES MACHINES - Nos cafés ont été développés pour assurer une belle crème et une longueur en bouche des saveurs qui en feront votre ami idéal pour tout type de cafetières: Automatique, Expresso, Italienne, Piston, Filtre ???? FRAICHEUR ASSURÉE - nos cafés ont été récemment torréfiés et conditionnés dans un sac refermable qualitatif avec valve fraicheur pour assurer une conservation optimale, y compris après ouverture. Goûtez la différence en comparaison d’un café moulu… et bonne dégustation!

Related Products

There are no customer reviews yet. Be the first to Write a Review!

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6103241443634 266 1.0158 0


No Amazon API Requests Made.


App Debug - Total Time 1.6103241443634 seconds

Number Time From Start Name Description
1 0.36404919624329 Initialise Initialise FSB Function
2 0.36670613288879 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39130020141602 Start of getCategoryListByGroup Function Before first category groups query
4 0.39199614524841 After initial query Before first category groups query
5 0.39199709892273 Get Category List for Group Before the call to getCategoryList function
6 0.39199900627136 Start of GetCategoryList function Start of the function
7 0.39200019836426 Before getting categories Query to get specific category list
8 0.39271712303162 After getting categories Query to get specific category list
9 0.39271807670593 Before getting category custom Before call to function getCategoryCustom
10 0.40834212303162 After getting category custom After call to function getCategoryCustom
11 0.40834403038025 Before getting category custom Before call to function getCategoryCustom
12 0.42260718345642 After getting category custom After call to function getCategoryCustom
13 0.42260813713074 Before getting category custom Before call to function getCategoryCustom
14 0.42819213867188 After getting category custom After call to function getCategoryCustom
15 0.42819404602051 Before getting category custom Before call to function getCategoryCustom
16 0.432049036026 After getting category custom After call to function getCategoryCustom
17 0.43205118179321 Before getting category custom Before call to function getCategoryCustom
18 0.43542218208313 After getting category custom After call to function getCategoryCustom
19 0.43542408943176 Before getting category custom Before call to function getCategoryCustom
20 0.43918108940125 After getting category custom After call to function getCategoryCustom
21 0.43918299674988 End of GetCategoryList function End of the function
22 0.43918919563293 Get Category List for Group Before the call to getCategoryList function
23 0.43919014930725 Start of GetCategoryList function Start of the function
24 0.43919205665588 Before getting categories Query to get specific category list
25 0.43958711624146 End of getCategoryListByGroup Function Before return()
26 1.2708070278168 App Controller End End of the App controller (called before the controller of every page)
27 1.2713611125946 Product Start Start of the product info controller
28 1.2745130062103 Cache file not found Starting get product details
29 1.2912662029266 Related products Start getting related products if enabled
30 1.2912681102753 Related Products Start Before the related products are found
31 1.2912681102753 Related Products Keywords Before the related product keywords are found
32 1.2912721633911 Create Keyword List Function Start of function
33 1.2913601398468 Create Keyword List Function After looping provided content - 43 keywords found
34 1.2924032211304 Create Keyword List Function After looping initial keyword list - 40 keywords remaining
35 1.2924091815948 Create Keyword List Function After reducing keyword list
36 1.2924990653992 Create Keyword List Function After selecting by scoring keywords
37 1.2925021648407 Create Keyword List Function After final loop of keywords
38 1.2925040721893 Related Products Keywords After the related product keywords are found
39 1.3289670944214 Related Products End After the related products are found
40 1.3396520614624 Product End End of the product info controller (Product Info)
41 1.3410630226135 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3419661521912 Before Get Options Before the call to getOptions in the tpl class
43 1.3820490837097 After Get Options After the call to getOptions in the tpl class
44 1.3822131156921 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3822410106659 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.494127035141 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4941320419312 Product Info: Before Template Display Before the template is displayed
48 1.6103041172028 Product Info: After Template Display After the template is displayed
49 1.6103131771088 Finalizing debug Before the debug is output to the page.
50 1.6103231906891 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 1.0158 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00091195106506348 
SELECT parameter, value FROM parameters
2 0.0037 0.0036630630493164 
SELECT * FROM `bad_bots`
3 0.0003 0.00026416778564453 
SET time_zone = 'Europe/London'
4 0.0008 0.00082993507385254 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011210441589355 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.145\";}'
6 0.0009 0.00086712837219238 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750020575'
7 0.0010 0.0010130405426025 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00029182434082031 
UPDATE autorun SET lastrun = '2025-06-15 20:49:35' WHERE id = '17'
9 0.0003 0.0003211498260498 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0008 0.00077199935913086 
SELECT id FROM pages WHERE pagename = '-cafe-grain-1kg-bio-cafe-en-grain-arabica-coffret-cafe-degustation' LIMIT 1
11 0.0010 0.0010409355163574 
SELECT id FROM products WHERE pagename = '-cafe-grain-1kg-bio-cafe-en-grain-arabica-coffret-cafe-degustation' AND hidden = 0 LIMIT 1
12 0.0016 0.0016148090362549 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0223 0.022280931472778 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.00037813186645508 
SELECT * FROM pages WHERE pagename = '-cafe-grain-1kg-bio-cafe-en-grain-arabica-coffret-cafe-degustation'
15 0.0007 0.00069284439086914 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00070786476135254 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0052 0.0052030086517334 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0010 0.00095319747924805 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0008 0.00077199935913086 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00039792060852051 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0049 0.0049290657043457 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
22 0.0011 0.0011179447174072 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
23 0.0010 0.00097799301147461 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0009 0.00087213516235352 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00032401084899902 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0042 0.0041539669036865 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0003 0.00034308433532715 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00032615661621094 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.0003960132598877 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0075 0.0075409412384033 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
31 0.0004 0.00039505958557129 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
32 0.0004 0.00036096572875977 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0004 0.00036406517028809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00034499168395996 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0013570785522461 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0004 0.00039315223693848 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00030517578125 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.0003669261932373 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0016179084777832 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
40 0.0004 0.00035905838012695 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
41 0.0004 0.00039291381835938 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0004 0.00039410591125488 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00034499168395996 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00066184997558594 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00034999847412109 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00033402442932129 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00033903121948242 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00055289268493652 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0004 0.0003969669342041 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
50 0.0005 0.00049090385437012 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00034499168395996 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00033998489379883 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00043606758117676 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00032806396484375 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00027203559875488 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00029706954956055 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00060105323791504 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.0004 0.00036787986755371 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0004 0.00040411949157715 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.00031900405883789 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00029492378234863 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00053215026855469 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00033092498779297 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00027894973754883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.0003209114074707 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00070714950561523 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0004 0.0004119873046875 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
68 0.0004 0.00039792060852051 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0004 0.00035595893859863 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.0003669261932373 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00038719177246094 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0022 0.0021538734436035 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0009 0.00092101097106934 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.00038695335388184 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0006 0.00061297416687012 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.00091409683227539 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0021 0.0021011829376221 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8203 0.82032895088196 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.145') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.145') <= INET_ATON(ip_end)
79 0.0014 0.0014190673828125 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0007 0.00068306922912598 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00040698051452637 
SELECT * FROM products WHERE pagename = '-cafe-grain-1kg-bio-cafe-en-grain-arabica-coffret-cafe-degustation'
82 0.0003 0.00028014183044434 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4930
83 0.0004 0.00036787986755371 
SELECT * FROM manufacturers WHERE id = '655'
84 0.0004 0.00043511390686035 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '655'
85 0.0007 0.00067782402038574 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '655' LIMIT 1
86 0.0008 0.000762939453125 
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '655' ORDER BY RAND() LIMIT 1
87 0.0003 0.00030803680419922 
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
88 0.0002 0.00024604797363281 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '655'
89 0.0003 0.00026702880859375 
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '655'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0
90 0.0003 0.00025296211242676 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '655'
91 0.0003 0.00027799606323242 
SELECT category_id FROM products_categories WHERE product_id = '4930'
92 0.0003 0.00031614303588867 
SELECT * FROM categories WHERE id = '30'
93 0.0003 0.00034499168395996 
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
94 0.0003 0.00027108192443848 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
95 0.0002 0.00022697448730469 
SELECT id FROM categories WHERE parent_id = '30'
96 0.0003 0.00031590461730957 
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
97 0.0003 0.00033688545227051 
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
98 0.0004 0.00036215782165527 
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
99 0.0003 0.00029802322387695 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
100 0.0004 0.00036287307739258 
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
101 0.0008 0.00077414512634277 
SELECT * FROM product_image_select WHERE product_id = '4930'
102 0.0006 0.00059294700622559 
SELECT * FROM productcustomimages WHERE product_id = '4930'
103 0.0006 0.0005791187286377 
SELECT * FROM productfeeds WHERE product_id = '4930' ORDER BY item_date DESC
104 0.0012 0.0012040138244629 
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0010 0.0010440349578857 
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4930' AND t.hidden = 0 AND display_product = 1
106 0.0002 0.00023913383483887 
SELECT * FROM tags WHERE id = '91'
107 0.0008 0.00076389312744141 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0006 0.00060391426086426 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1
109 0.0006 0.00063014030456543 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '91' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0003 0.00032782554626465 
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
111 0.0007 0.00072097778320312 
SELECT * FROM productamazoncontent WHERE product_id = '4930'
112 0.0007 0.00072002410888672 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
113 0.0007 0.00070309638977051 
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0003 0.00028419494628906 
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0003 0.00034689903259277 
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0003 0.00034999847412109 
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
117 0.0064 0.0063581466674805 
SELECT *, MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AND 4930 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
118 0.0004 0.00039291381835938 
SELECT *, MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AND 4930 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0003 0.00034999847412109 
SELECT *, MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('grain arabica coffret' IN BOOLEAN MODE) AND 4930 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0004 0.00039100646972656 
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
121 0.0005 0.00046396255493164 
SELECT * FROM product_image_select WHERE product_id = '1290'
122 0.0003 0.00028204917907715 
SELECT * FROM productcustomimages WHERE product_id = '1290'
123 0.0008 0.00075483322143555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
124 0.0004 0.00039505958557129 
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0004 0.0003819465637207 
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
128 0.0004 0.00043082237243652 
SELECT * FROM product_image_select WHERE product_id = '4919'
129 0.0003 0.00027823448181152 
SELECT * FROM productcustomimages WHERE product_id = '4919'
130 0.0007 0.00070500373840332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
131 0.0003 0.00032305717468262 
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0003 0.0002901554107666 
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00028085708618164 
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0004 0.00035500526428223 
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
135 0.0004 0.0004429817199707 
SELECT * FROM product_image_select WHERE product_id = '1093'
136 0.0003 0.00030899047851562 
SELECT * FROM productcustomimages WHERE product_id = '1093'
137 0.0005 0.00053119659423828 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
138 0.0003 0.00032305717468262 
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0003 0.00027108192443848 
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0003 0.00034499168395996 
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
142 0.0005 0.00047087669372559 
SELECT * FROM product_image_select WHERE product_id = '4917'
143 0.0003 0.00027298927307129 
SELECT * FROM productcustomimages WHERE product_id = '4917'
144 0.0007 0.00067782402038574 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
145 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0003 0.00026893615722656 
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0003 0.00026488304138184 
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0004 0.00038599967956543 
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
149 0.0005 0.00046610832214355 
SELECT * FROM product_image_select WHERE product_id = '923'
150 0.0003 0.0002748966217041 
SELECT * FROM productcustomimages WHERE product_id = '923'
151 0.0006 0.00060892105102539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
152 0.0003 0.00030994415283203 
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0003 0.00026607513427734 
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00025296211242676 
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0004 0.00038409233093262 
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
156 0.0004 0.00041508674621582 
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
157 0.0005 0.00050592422485352 
SELECT * FROM product_image_select WHERE product_id = '822'
158 0.0003 0.00027179718017578 
SELECT * FROM productcustomimages WHERE product_id = '822'
159 0.0004 0.00038385391235352 
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
160 0.0020 0.0019690990447998 
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
161 0.0039 0.0038788318634033 
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
162 0.0044 0.0044047832489014 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
163 0.0003 0.00026297569274902 
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.00028705596923828 
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0002 0.00024795532226562 
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00024795532226562 
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
167 0.0003 0.00028204917907715 
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
168 0.0004 0.00041794776916504 
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
169 0.0003 0.00026392936706543 
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
170 0.0003 0.00034594535827637 
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0004 0.00038790702819824 
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
172 0.0003 0.00027894973754883 
SELECT id,asin FROM products WHERE parent_id = 4930
173 0.0007 0.0007171630859375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
174 0.0003 0.00030398368835449 
SELECT category_id FROM products_categories WHERE product_id = '4930'
175 0.0004 0.00037097930908203 
SELECT * FROM categories WHERE id = '30'
176 0.0004 0.00039196014404297 
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
177 0.0003 0.00029301643371582 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
178 0.0003 0.00025296211242676 
SELECT id FROM categories WHERE parent_id = '30'
179 0.0005 0.00047898292541504 
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
180 0.0005 0.00046896934509277 
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
181 0.0003 0.00034904479980469 
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
182 0.0003 0.00032186508178711 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
183 0.0007 0.00071191787719727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
184 0.0003 0.0003199577331543 
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00029397010803223 
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0004 0.0003509521484375 
SELECT * FROM products WHERE id = '4930'
187 0.0003 0.00026988983154297 
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0006 0.00059390068054199 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
189 0.0002 0.0002439022064209 
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0003 0.00027704238891602 
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00028896331787109 
SELECT category_id FROM products_categories WHERE product_id = '4930' AND prod_type = 'amz'
192 0.0003 0.0002901554107666 
SELECT parent_id FROM categories WHERE id = '30'
193 0.0002 0.00024199485778809 
SELECT * FROM categories WHERE id = '30'
194 0.0004 0.00038504600524902 
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
195 0.0003 0.00028085708618164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
196 0.0002 0.00022506713867188 
SELECT id FROM categories WHERE parent_id = '30'
197 0.0003 0.00034904479980469 
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
198 0.0003 0.0003211498260498 
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
199 0.0004 0.00037193298339844 
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
200 0.0003 0.00030684471130371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
201 0.0008 0.00079512596130371 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0006 0.00059103965759277 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0003 0.00025010108947754 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0114 0.011439085006714 
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.00076794624328613 
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.0004 0.00042891502380371 
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.0004 0.00038290023803711 
SELECT * FROM products WHERE id = 1626
208 0.0006 0.00064492225646973 
SELECT * FROM products WHERE id = 4041
209 0.0003 0.00027680397033691 
SELECT * FROM products WHERE id = 4312
210 0.0003 0.00027585029602051 
SELECT * FROM products WHERE id = 777
211 0.0003 0.00025081634521484 
SELECT * FROM products WHERE id = 3881
212 0.0002 0.00024509429931641 
SELECT * FROM products WHERE id = 4213
213 0.0002 0.00024700164794922 
SELECT * FROM products WHERE id = '1626'
214 0.0003 0.00032401084899902 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0004 0.00044608116149902 
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0003 0.00026607513427734 
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0006 0.0005650520324707 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0003 0.00029993057250977 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.00031304359436035 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00057506561279297 
SELECT * FROM products WHERE id = '4041'
222 0.0003 0.00033783912658691 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0005 0.00046896934509277 
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0003 0.00031304359436035 
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0007 0.00073814392089844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0003 0.00029087066650391 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.00029206275939941 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.0003969669342041 
SELECT * FROM products WHERE id = '4312'
230 0.0003 0.00034904479980469 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0005 0.00047588348388672 
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0003 0.00028300285339355 
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0007 0.00069403648376465 
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.00036096572875977 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0007 0.00065207481384277 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00041699409484863 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0004 0.00036287307739258 
SELECT * FROM products WHERE id = '777'
238 0.0003 0.00031113624572754 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0005 0.00046992301940918 
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0007 0.00066900253295898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0003 0.00033998489379883 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0003 0.00029397010803223 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00026798248291016 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0004 0.00038003921508789 
SELECT * FROM products WHERE id = '3881'
246 0.0004 0.00038814544677734 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0004 0.00043487548828125 
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0003 0.0002741813659668 
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0007 0.000701904296875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0003 0.00033712387084961 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0003 0.00028491020202637 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0004 0.00035500526428223 
SELECT * FROM products WHERE id = '4213'
254 0.0004 0.00035500526428223 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0004 0.00043988227844238 
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0003 0.00027298927307129 
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0007 0.00072002410888672 
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.00035190582275391 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0003 0.00028800964355469 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0003 0.00026988983154297 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0010 0.0010190010070801 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0005 0.0005040168762207 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0015 0.0015289783477783 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0009 0.00085806846618652 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0004 0.00039315223693848 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0008 0.00081896781921387 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'