0

Vivaraise Coussin uni Zeff

Price: €21,90
Product prices and availability are accurate as of 2022-06-24 00:32:29 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
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

🍀 Recto 100%Lin Verso 100%Coton 🍀 Indoor 🍀 Lavable à 40°, Javel : non, Séchage machine, Repassage fort 200°, Nettoyage interdit

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.4652059078217 347 0.8836 0


No Amazon API Requests Made.


App Debug - Total Time 1.4652059078217 seconds

Number Time From Start Name Description
1 0.53584909439087 Initialise Initialise FSB Function
2 0.53949594497681 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58066511154175 Start of getCategoryListByGroup Function Before first category groups query
4 0.58122611045837 After initial query Before first category groups query
5 0.58122801780701 Get Category List for Group Before the call to getCategoryList function
6 0.58123111724854 Start of GetCategoryList function Start of the function
7 0.58123397827148 Before getting categories Query to get specific category list
8 0.58198213577271 After getting categories Query to get specific category list
9 0.58198308944702 Before getting category custom Before call to function getCategoryCustom
10 0.59707713127136 After getting category custom After call to function getCategoryCustom
11 0.59708189964294 Before getting category custom Before call to function getCategoryCustom
12 0.60830092430115 After getting category custom After call to function getCategoryCustom
13 0.60830497741699 Before getting category custom Before call to function getCategoryCustom
14 0.61507797241211 After getting category custom After call to function getCategoryCustom
15 0.61508107185364 Before getting category custom Before call to function getCategoryCustom
16 0.61996293067932 After getting category custom After call to function getCategoryCustom
17 0.61996793746948 Before getting category custom Before call to function getCategoryCustom
18 0.62520790100098 After getting category custom After call to function getCategoryCustom
19 0.62521195411682 Before getting category custom Before call to function getCategoryCustom
20 0.63031792640686 After getting category custom After call to function getCategoryCustom
21 0.63032102584839 End of GetCategoryList function End of the function
22 0.63032913208008 Get Category List for Group Before the call to getCategoryList function
23 0.63033103942871 Start of GetCategoryList function Start of the function
24 0.63033294677734 Before getting categories Query to get specific category list
25 0.63086104393005 End of getCategoryListByGroup Function Before return()
26 1.1742160320282 App Controller End End of the App controller (called before the controller of every page)
27 1.1749229431152 Product Start Start of the product info controller
28 1.1767909526825 Cache file not found Starting get product details
29 1.221540927887 Related products Start getting related products if enabled
30 1.2215430736542 Related Products Start Before the related products are found
31 1.2215440273285 Related Products Keywords Before the related product keywords are found
32 1.2215480804443 Create Keyword List Function Start of function
33 1.2215750217438 Create Keyword List Function After looping provided content - 9 keywords found
34 1.2219669818878 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
35 1.2219741344452 Create Keyword List Function After reducing keyword list
36 1.2219860553741 Create Keyword List Function After selecting by scoring keywords
37 1.2219889163971 Create Keyword List Function After final loop of keywords
38 1.2219910621643 Related Products Keywords After the related product keywords are found
39 1.2840180397034 Related Products End After the related products are found
40 1.3597979545593 Product End End of the product info controller (Product Info)
41 1.3611159324646 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3621799945831 Before Get Options Before the call to getOptions in the tpl class
43 1.4189720153809 After Get Options After the call to getOptions in the tpl class
44 1.4190719127655 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4191009998322 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4382789134979 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4382829666138 Product Info: Before Template Display Before the template is displayed
48 1.4651820659637 Product Info: After Template Display After the template is displayed
49 1.4651930332184 Finalizing debug Before the debug is output to the page.
50 1.465204000473 End of App This is the end of the app logging, final timestamp


Query Debug - 347 Database Queries. Total time 0.8836 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0016870498657227
SELECT parameter, value FROM parameters
2 0.0052 0.0051500797271729
SELECT * FROM `bad_bots`
3 0.0005 0.00050592422485352
SET time_zone = 'Europe/London'
4 0.0011 0.0010550022125244
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0010621547698975
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.118.120.44\";}'
6 0.0010 0.0010139942169189
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722057801'
7 0.0013 0.0012540817260742
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.000701904296875
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010099411010742
SELECT id FROM pages WHERE pagename = 'vivaraise-coussin-uni-zeff' LIMIT 1
10 0.0012 0.0012350082397461
SELECT id FROM products WHERE pagename = 'vivaraise-coussin-uni-zeff' AND hidden = 0 LIMIT 1
11 0.0036 0.0036439895629883
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0366 0.036576986312866
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00045108795166016
SELECT * FROM pages WHERE pagename = 'vivaraise-coussin-uni-zeff'
14 0.0005 0.0005490779876709
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00072503089904785
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0056 0.0056118965148926
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.00060296058654785
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.00046896934509277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00051116943359375
SELECT id FROM categories WHERE parent_id = '26'
20 0.0055 0.0054938793182373
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.0007 0.00065517425537109
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.00059390068054199
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.00050902366638184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00046610832214355
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0037069320678711
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.0005340576171875
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.0004580020904541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00045418739318848
SELECT id FROM categories WHERE parent_id = '27'
29 0.0039 0.003899097442627
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.00054693222045898
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.00055694580078125
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.00049710273742676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045514106750488
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014879703521729
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.00049901008605957
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.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00047612190246582
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015630722045898
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.0007 0.000701904296875
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.0006 0.00057888031005859
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.0005 0.00046396255493164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00046801567077637
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00056219100952148
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.0005 0.00047612190246582
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00048184394836426
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00069093704223633
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.00047588348388672
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.0006 0.0005500316619873
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.0005 0.00052714347839355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00060510635375977
SELECT * FROM categorygroups WHERE id = '1'
52 0.0010 0.0010249614715576
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.0005 0.00051093101501465
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.00045990943908691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00045394897460938
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00069284439086914
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.0005 0.0005040168762207
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.00054788589477539
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.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047206878662109
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00063395500183105
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.00048398971557617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00058698654174805
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00071191787719727
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.0006 0.00058078765869141
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.0006 0.00057411193847656
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.00053191184997559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00046896934509277
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00051593780517578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0015850067138672
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00063085556030273
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059700012207031
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.0004 0.00042986869812012
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.001209020614624
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010750293731689
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5336 0.53362894058228
SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.120.44') >= INET_ATON(ip_start) AND INET_ATON('18.118.120.44') <= INET_ATON(ip_end)
78 0.0014 0.0013999938964844
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00055503845214844
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.000762939453125
SELECT * FROM products WHERE pagename = 'vivaraise-coussin-uni-zeff'
81 0.0005 0.00046801567077637
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4614
82 0.0006 0.00059986114501953
SELECT * FROM manufacturers WHERE id = '619'
83 0.0007 0.00067400932312012
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
84 0.0004 0.00044417381286621
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
85 0.0008 0.00082802772521973
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '619' ORDER BY RAND() LIMIT 1
86 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '4612' ORDER BY sortorder ASC
87 0.0005 0.00054216384887695
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
88 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '619'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00035500526428223
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
90 0.0005 0.00047898292541504
SELECT category_id FROM products_categories WHERE product_id = '4614'
91 0.0005 0.00048398971557617
SELECT * FROM categories WHERE id = '27'
92 0.0042 0.004155158996582
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.0005 0.0004580020904541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.0003209114074707
SELECT id FROM categories WHERE parent_id = '27'
95 0.0038 0.0038070678710938
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.0005 0.00053215026855469
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.0005 0.0005490779876709
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0005 0.0004880428314209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00066518783569336
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
100 0.0009 0.00085306167602539
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4614' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '4614'
102 0.0004 0.00039410591125488
SELECT * FROM productcustomimages WHERE product_id = '4614'
103 0.0004 0.00037693977355957
SELECT * FROM productfeeds WHERE product_id = '4614' ORDER BY item_date DESC
104 0.0007 0.00074219703674316
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0007 0.00069308280944824
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4614' AND t.hidden = 0 AND display_product = 1
106 0.0005 0.00046205520629883
SELECT * FROM tags WHERE id = '58'
107 0.0026 0.0026311874389648
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0026 0.0025999546051025
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0026 0.0025901794433594
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' 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.0006 0.00063991546630859
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
111 0.0004 0.00040793418884277
SELECT * FROM tags WHERE id = '938'
112 0.0007 0.00067687034606934
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
113 0.0008 0.00075721740722656
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
114 0.0008 0.00076007843017578
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
116 0.0006 0.00059890747070312
SELECT * FROM productamazoncontent WHERE product_id = '4614'
117 0.0007 0.00072002410888672
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 = '4614'
                GROUP BY o.product_id
118 0.0011 0.0010581016540527
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     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
119 0.0006 0.0006108283996582
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
120 0.0011 0.001107931137085
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
121 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.0004432201385498
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
124 0.0006 0.00057601928710938
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
125 0.0007 0.00069689750671387
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 = '4614'
                GROUP BY o.product_id
126 0.0014 0.0013530254364014
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     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0005 0.00053095817565918
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
128 0.0006 0.0006098747253418
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0011 0.0011119842529297
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
130 0.0011 0.0010800361633301
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
131 0.0005 0.00050687789916992
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
132 0.0120 0.011965036392212
SELECT *, MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AND 4614 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133 0.0008 0.00081682205200195
SELECT *, MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AND 4614 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0007 0.0007169246673584
SELECT *, MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vivaraise coussin uni' IN BOOLEAN MODE) AND 4614 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
135 0.0005 0.00053691864013672
SELECT * FROM productimages WHERE product_id = '4258' ORDER BY sortorder ASC
136 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '4258'
137 0.0006 0.00058889389038086
SELECT * FROM productcustomimages WHERE product_id = '4258'
138 0.0013 0.0012788772583008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4258' AND a.name = n.originalname
139 0.0006 0.0006258487701416
SELECT * FROM productoffers WHERE product_id = '4258' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00048089027404785
SELECT * FROM productoffers
                WHERE product_id = '4258' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00050711631774902
SELECT value FROM productattributes WHERE product_id = '4258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00047612190246582
SELECT * FROM productimages WHERE product_id = '4260' ORDER BY sortorder ASC
143 0.0007 0.00065279006958008
SELECT * FROM product_image_select WHERE product_id = '4260'
144 0.0004 0.00040507316589355
SELECT * FROM productcustomimages WHERE product_id = '4260'
145 0.0015 0.0015389919281006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4260' AND a.name = n.originalname
146 0.0005 0.00052189826965332
SELECT * FROM productoffers WHERE product_id = '4260' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.00047922134399414
SELECT * FROM productoffers
                WHERE product_id = '4260' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '4260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00055122375488281
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
150 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '4246'
151 0.0005 0.00053000450134277
SELECT * FROM productcustomimages WHERE product_id = '4246'
152 0.0011 0.0010850429534912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
153 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0005 0.00053977966308594
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00045990943908691
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00058221817016602
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
157 0.0014 0.0014111995697021
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4322' AND p.id = pi.product_id ORDER BY pi.sortorder
158 0.0007 0.00065994262695312
SELECT * FROM product_image_select WHERE product_id = '4322'
159 0.0004 0.00041604042053223
SELECT * FROM productcustomimages WHERE product_id = '4322'
160 0.0009 0.00087618827819824
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 = '4322'
                GROUP BY o.product_id
161 0.0016 0.0016200542449951
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     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
162 0.0006 0.00063800811767578
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
163 0.0013 0.0012891292572021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
164 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0007 0.00068402290344238
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00052404403686523
SELECT value FROM productattributes
                WHERE product_id = '4322'
                AND name = 'ListPriceAmount'
168 0.0007 0.0007319450378418
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 = '4322'
                GROUP BY o.product_id
169 0.0018 0.0017640590667725
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     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
170 0.0007 0.00068187713623047
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
171 0.0007 0.00069189071655273
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0014 0.001413106918335
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
173 0.0097 0.0097219944000244
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
174 0.0005 0.00054597854614258
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
175 0.0006 0.00062108039855957
SELECT * FROM product_image_select WHERE product_id = '4256'
176 0.0005 0.00045990943908691
SELECT * FROM productcustomimages WHERE product_id = '4256'
177 0.0014 0.0013949871063232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
178 0.0006 0.00058412551879883
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0006 0.00055384635925293
SELECT * FROM productimages WHERE product_id = '4257' ORDER BY sortorder ASC
182 0.0006 0.00063586235046387
SELECT * FROM product_image_select WHERE product_id = '4257'
183 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '4257'
184 0.0012 0.0012021064758301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4257' AND a.name = n.originalname
185 0.0005 0.00052094459533691
SELECT * FROM productoffers WHERE product_id = '4257' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0004 0.00044584274291992
SELECT * FROM productoffers
                WHERE product_id = '4257' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '4257' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0006 0.00059103965759277
SELECT id,asin FROM products WHERE parent_id = 4614
189 0.0006 0.00055813789367676
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4555
190 0.0006 0.00062203407287598
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4555
191 0.0004 0.0003511905670166
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4615
192 0.0004 0.0004420280456543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4615
193 0.0003 0.00032377243041992
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4616
194 0.0004 0.0004420280456543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4616
195 0.0003 0.0003352165222168
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4617
196 0.0004 0.00041508674621582
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4617
197 0.0004 0.00035786628723145
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4618
198 0.0005 0.0005190372467041
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4618
199 0.0004 0.00038719177246094
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4619
200 0.0005 0.00053119659423828
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4619
201 0.0003 0.00031518936157227
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4620
202 0.0004 0.00042009353637695
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4620
203 0.0003 0.00031900405883789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4622
204 0.0006 0.00057101249694824
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4622
205 0.0003 0.00034785270690918
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4623
206 0.0005 0.00047898292541504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4623
207 0.0004 0.00035619735717773
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4625
208 0.0005 0.00053095817565918
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4625
209 0.0004 0.0004119873046875
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4626
210 0.0005 0.00045204162597656
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4626
211 0.0004 0.00038290023803711
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4627
212 0.0005 0.00045490264892578
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4627
213 0.0003 0.00032806396484375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4628
214 0.0005 0.00047898292541504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4628
215 0.0003 0.00034213066101074
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4629
216 0.0005 0.00046610832214355
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4629
217 0.0004 0.00039505958557129
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4630
218 0.0004 0.00042009353637695
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4630
219 0.0003 0.00034499168395996
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4631
220 0.0005 0.00050091743469238
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4631
221 0.0004 0.00040602684020996
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4632
222 0.0004 0.00041007995605469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4632
223 0.0004 0.00035905838012695
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4633
224 0.0005 0.00045394897460938
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4633
225 0.0003 0.00034809112548828
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4634
226 0.0005 0.00049591064453125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4634
227 0.0004 0.00036501884460449
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4635
228 0.0005 0.00049805641174316
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4635
229 0.0003 0.00032520294189453
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4636
230 0.0004 0.00040507316589355
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4636
231 0.0003 0.00030708312988281
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4637
232 0.0005 0.00046181678771973
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4637
233 0.0004 0.00040102005004883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4638
234 0.0005 0.00047111511230469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4638
235 0.0004 0.00035691261291504
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4639
236 0.0005 0.00052380561828613
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4639
237 0.0003 0.00032997131347656
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4640
238 0.0005 0.00050497055053711
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4640
239 0.0003 0.00033807754516602
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4641
240 0.0004 0.00043511390686035
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4641
241 0.0004 0.00035500526428223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4886
242 0.0005 0.00051188468933105
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4886
243 0.0005 0.00051093101501465
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4614' ORDER BY timestamp DESC
244 0.0004 0.00043201446533203
SELECT category_id FROM products_categories WHERE product_id = '4614'
245 0.0005 0.00051188468933105
SELECT * FROM categories WHERE id = '27'
246 0.0044 0.0043649673461914
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
247 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
248 0.0003 0.00032401084899902
SELECT id FROM categories WHERE parent_id = '27'
249 0.0041 0.0041329860687256
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 
250 0.0006 0.00056600570678711
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 
251 0.0007 0.00071501731872559
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
252 0.0005 0.00053215026855469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
253 0.0009 0.00093388557434082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
254 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0005 0.00050783157348633
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
257 0.0007 0.00073003768920898
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
258 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = '4614'
259 0.0007 0.00066304206848145
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 = '4614'
                GROUP BY o.product_id
260 0.0011 0.0010709762573242
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     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
261 0.0006 0.00059199333190918
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
262 0.0007 0.00068902969360352
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0009 0.00088596343994141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
264 0.0005 0.00049686431884766
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0023 0.0022971630096436
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
267 0.0004 0.00042295455932617
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
268 0.0006 0.00064396858215332
SELECT DISTINCT (name) FROM productoptions
269 0.0009 0.00086307525634766
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4614))
270 0.0008 0.0007929801940918
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 4614
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
271 0.0059 0.0059289932250977
SELECT * FROM translationsfilter
272 0.0025 0.0025191307067871
SELECT category_id FROM products_categories WHERE product_id = '4614' AND prod_type = 'amz'
273 0.0011 0.0011148452758789
SELECT parent_id FROM categories WHERE id = '27'
274 0.0005 0.00052189826965332
SELECT * FROM categories WHERE id = '27'
275 0.0055 0.0055091381072998
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
276 0.0006 0.00061392784118652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
277 0.0005 0.0004889965057373
SELECT id FROM categories WHERE parent_id = '27'
278 0.0060 0.0059847831726074
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 
279 0.0009 0.00093793869018555
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 
280 0.0009 0.00093197822570801
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
281 0.0007 0.00067687034606934
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
282 0.0007 0.00068783760070801
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
283 0.0006 0.00060105323791504
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
284 0.0004 0.00039505958557129
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
285 0.0152 0.01521897315979
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
286 0.0007 0.00074601173400879
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
287 0.0007 0.00068807601928711
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
288 0.0007 0.00069999694824219
SELECT * FROM products WHERE id = 1626
289 0.0006 0.00059700012207031
SELECT * FROM products WHERE id = 4041
290 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = 4312
291 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = 777
292 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = 3881
293 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = 4213
294 0.0006 0.00058889389038086
SELECT * FROM products WHERE id = '1626'
295 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
296 0.0007 0.00066208839416504
SELECT * FROM product_image_select WHERE product_id = '1626'
297 0.0005 0.0005040168762207
SELECT * FROM productcustomimages WHERE product_id = '1626'
298 0.0009 0.00087499618530273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
299 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0004 0.00039815902709961
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0005 0.00048708915710449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0006 0.00055599212646484
SELECT * FROM products WHERE id = '4041'
303 0.0005 0.00047183036804199
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
304 0.0006 0.0006260871887207
SELECT * FROM product_image_select WHERE product_id = '4041'
305 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '4041'
306 0.0012 0.001230001449585
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
307 0.0005 0.00052881240844727
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00051021575927734
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0009 0.00085091590881348
SELECT * FROM products WHERE id = '4312'
311 0.0005 0.00051093101501465
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
312 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '4312'
313 0.0004 0.00044083595275879
SELECT * FROM productcustomimages WHERE product_id = '4312'
314 0.0011 0.0011460781097412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
315 0.0005 0.00052714347839355
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0005 0.00050783157348633
SELECT * FROM products WHERE id = '777'
319 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
320 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '777'
321 0.0004 0.00038814544677734
SELECT * FROM productcustomimages WHERE product_id = '777'
322 0.0010 0.0010321140289307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
323 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0004 0.00043106079101562
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = '3881'
327 0.0007 0.00069904327392578
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
328 0.0006 0.00059199333190918
SELECT * FROM product_image_select WHERE product_id = '3881'
329 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '3881'
330 0.0011 0.0010910034179688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
331 0.0005 0.00047707557678223
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0005 0.00054812431335449
SELECT * FROM products WHERE id = '4213'
335 0.0007 0.00068283081054688
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
336 0.0006 0.00063991546630859
SELECT * FROM product_image_select WHERE product_id = '4213'
337 0.0004 0.00041317939758301
SELECT * FROM productcustomimages WHERE product_id = '4213'
338 0.0011 0.0011239051818848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
339 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0009 0.00085711479187012
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
343 0.0008 0.00079894065856934
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
344 0.0019 0.001878023147583
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
345 0.0015 0.0015370845794678
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0009 0.0009160041809082
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347 0.0013 0.0012521743774414
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'