0

Vivaraise Rideau Voile Zeff 140 x 280 cm

Price: Click Button for Price
Product prices and availability are accurate as of 2021-07-21 03:01:59 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

🍀 60%LIN 40%COTON 🍀 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.4983420372009 330 1.0357 0


No Amazon API Requests Made.


App Debug - Total Time 1.4983420372009 seconds

Number Time From Start Name Description
1 0.41783690452576 Initialise Initialise FSB Function
2 0.42809510231018 App Controller Start Start of the App controller (called before the controller of every page)
3 0.48155808448792 Start of getCategoryListByGroup Function Before first category groups query
4 0.48335194587708 After initial query Before first category groups query
5 0.4833550453186 Get Category List for Group Before the call to getCategoryList function
6 0.48335909843445 Start of GetCategoryList function Start of the function
7 0.48336386680603 Before getting categories Query to get specific category list
8 0.48506999015808 After getting categories Query to get specific category list
9 0.48507189750671 Before getting category custom Before call to function getCategoryCustom
10 0.50698494911194 After getting category custom After call to function getCategoryCustom
11 0.50698900222778 Before getting category custom Before call to function getCategoryCustom
12 0.51961302757263 After getting category custom After call to function getCategoryCustom
13 0.51961708068848 Before getting category custom Before call to function getCategoryCustom
14 0.53505492210388 After getting category custom After call to function getCategoryCustom
15 0.53505992889404 Before getting category custom Before call to function getCategoryCustom
16 0.54351806640625 After getting category custom After call to function getCategoryCustom
17 0.54352402687073 Before getting category custom Before call to function getCategoryCustom
18 0.55382204055786 After getting category custom After call to function getCategoryCustom
19 0.55382704734802 Before getting category custom Before call to function getCategoryCustom
20 0.56189489364624 After getting category custom After call to function getCategoryCustom
21 0.56189894676208 End of GetCategoryList function End of the function
22 0.56190800666809 Get Category List for Group Before the call to getCategoryList function
23 0.56191086769104 Start of GetCategoryList function Start of the function
24 0.56191396713257 Before getting categories Query to get specific category list
25 0.56300187110901 End of getCategoryListByGroup Function Before return()
26 1.1223049163818 App Controller End End of the App controller (called before the controller of every page)
27 1.1226069927216 Product Start Start of the product info controller
28 1.1478450298309 Cache file not found Starting get product details
29 1.2072949409485 Related products Start getting related products if enabled
30 1.2072970867157 Related Products Start Before the related products are found
31 1.20729804039 Related Products Keywords Before the related product keywords are found
32 1.2073020935059 Create Keyword List Function Start of function
33 1.2074139118195 Create Keyword List Function After looping provided content - 21 keywords found
34 1.2085430622101 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
35 1.2085499763489 Create Keyword List Function After reducing keyword list
36 1.2085950374603 Create Keyword List Function After selecting by scoring keywords
37 1.2085978984833 Create Keyword List Function After final loop of keywords
38 1.2086009979248 Related Products Keywords After the related product keywords are found
39 1.2901508808136 Related Products End After the related products are found
40 1.3775498867035 Product End End of the product info controller (Product Info)
41 1.3820860385895 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3846790790558 Before Get Options Before the call to getOptions in the tpl class
43 1.4592080116272 After Get Options After the call to getOptions in the tpl class
44 1.4593999385834 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4594309329987 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4779019355774 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4779069423676 Product Info: Before Template Display Before the template is displayed
48 1.4983270168304 Product Info: After Template Display After the template is displayed
49 1.4983310699463 Finalizing debug Before the debug is output to the page.
50 1.4983410835266 End of App This is the end of the app logging, final timestamp


Query Debug - 330 Database Queries. Total time 1.0357 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0023038387298584
SELECT parameter, value FROM parameters
2 0.0101 0.010124921798706
SELECT * FROM `bad_bots`
3 0.0004 0.00044989585876465
SET time_zone = 'Europe/London'
4 0.0040 0.0040450096130371
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0050 0.0049731731414795
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0038 0.00376296043396
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738872535'
7 0.0047 0.0047030448913574
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0013 0.0013470649719238
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0040 0.0040490627288818
SELECT id FROM pages WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm' LIMIT 1
10 0.0042 0.0042300224304199
SELECT id FROM products WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm' AND hidden = 0 LIMIT 1
11 0.0053 0.0052940845489502
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0465 0.046459913253784
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00082588195800781
SELECT * FROM pages WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm'
14 0.0018 0.0017650127410889
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0016701221466064
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0069 0.0069098472595215
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.0019 0.0018570423126221
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.0013 0.0013041496276855
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052714347839355
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0059077739715576
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.0017 0.0016968250274658
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.0016 0.001594066619873
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.0014 0.0014081001281738
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
25 0.0040 0.004019021987915
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.00052595138549805
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.0006 0.0005650520324707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00048112869262695
SELECT id FROM categories WHERE parent_id = '27'
29 0.0049 0.0049450397491455
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.00053095817565918
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00050997734069824
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.00046205520629883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00042104721069336
SELECT * FROM categorygroups WHERE id = '1'
34 0.0038 0.0037820339202881
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.0010 0.0010471343994141
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.0007 0.00070881843566895
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0009 0.00085306167602539
SELECT id FROM categories WHERE parent_id = '28'
38 0.0044 0.0043950080871582
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0010 0.00098586082458496
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.0011 0.0011007785797119
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.0015 0.0014550685882568
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0009 0.00094509124755859
SELECT * FROM categorygroups WHERE id = '1'
43 0.0011 0.0010950565338135
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.0007 0.0007319450378418
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.0006 0.0006101131439209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00057721138000488
SELECT id FROM categories WHERE parent_id = '29'
47 0.0012 0.0011720657348633
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.0008 0.000762939453125
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.0008 0.00081300735473633
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.0016 0.0015740394592285
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0009 0.00094008445739746
SELECT * FROM categorygroups WHERE id = '1'
52 0.0016 0.0015799999237061
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.0011 0.0010778903961182
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.0008 0.00078487396240234
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0008 0.00083708763122559
SELECT id FROM categories WHERE parent_id = '30'
56 0.0019 0.0018608570098877
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.0010 0.0010130405426025
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.0011 0.0010831356048584
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.0009 0.00092792510986328
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0010 0.00095105171203613
SELECT * FROM categorygroups WHERE id = '1'
61 0.0012 0.0012178421020508
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.0008 0.00076508522033691
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.0007 0.00067806243896484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0007 0.00069904327392578
SELECT id FROM categories WHERE parent_id = '31'
65 0.0014 0.0013978481292725
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.0008 0.00079703330993652
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.0010 0.00096416473388672
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.0007 0.00074100494384766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0007 0.00067687034606934
SELECT * FROM categorygroups WHERE id = '1'
70 0.0011 0.0010738372802734
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0045 0.0045230388641357
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0023 0.0022900104522705
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00076699256896973
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.0017 0.0016629695892334
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0016 0.0015869140625
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0011880397796631
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5420 0.54202103614807
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
78 0.0022 0.0021541118621826
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.001154899597168
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00063109397888184
SELECT * FROM products WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm'
81 0.0004 0.00040006637573242
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4554
82 0.0009 0.00086379051208496
SELECT * FROM manufacturers WHERE id = '619'
83 0.0009 0.00087809562683105
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
84 0.0023 0.0022690296173096
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
85 0.0028 0.0028219223022461
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.0005 0.00051403045654297
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
87 0.0008 0.00077605247497559
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
88 0.0008 0.00075888633728027
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.0006 0.00057196617126465
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
90 0.0007 0.00065016746520996
SELECT category_id FROM products_categories WHERE product_id = '4554'
91 0.0007 0.00070786476135254
SELECT * FROM categories WHERE id = '27'
92 0.0055 0.0055010318756104
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0006 0.00056004524230957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00043582916259766
SELECT id FROM categories WHERE parent_id = '27'
95 0.0049 0.0048589706420898
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0007 0.00069904327392578
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0007 0.00072479248046875
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0006 0.00058603286743164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00056791305541992
SELECT * FROM productimages WHERE product_id = '4554' ORDER BY sortorder ASC
100 0.0008 0.00081396102905273
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4554' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0021 0.0020599365234375
SELECT * FROM product_image_select WHERE product_id = '4554'
102 0.0014 0.0014441013336182
SELECT * FROM productcustomimages WHERE product_id = '4554'
103 0.0015 0.0014669895172119
SELECT * FROM productfeeds WHERE product_id = '4554' ORDER BY item_date DESC
104 0.0023 0.002263069152832
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0023 0.0022628307342529
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4554' AND t.hidden = 0 AND display_product = 1
106 0.0005 0.00049710273742676
SELECT * FROM tags WHERE id = '3966'
107 0.0008 0.00079798698425293
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3966'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0006 0.00059413909912109
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3966'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0006 0.00062108039855957
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3966' 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.00059103965759277
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
111 0.0017 0.0017318725585938
SELECT * FROM productamazoncontent WHERE product_id = '4554'
112 0.0015 0.0014948844909668
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 = '4554'
                GROUP BY o.product_id
113 0.0028 0.0027561187744141
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     = '4554'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
114 0.0007 0.00074577331542969
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4554
115 0.0012 0.0011870861053467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
116 0.0004 0.00041794776916504
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0009 0.00090813636779785
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
119 0.0012 0.0011520385742188
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
120 0.0010 0.0009760856628418
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 = '4554'
                GROUP BY o.product_id
121 0.0020 0.0019919872283936
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     = '4554'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
122 0.0009 0.00090384483337402
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4554
123 0.0012 0.0011861324310303
SELECT value FROM productattributes WHERE product_id = '4554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0018 0.0018470287322998
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4554'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
125 0.0015 0.0015099048614502
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4554'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
126 0.0012 0.0012340545654297
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
127 0.0189 0.018865823745728
SELECT *, MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AND 4554 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
128 0.0009 0.00094699859619141
SELECT *, MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AND 4554 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
129 0.0009 0.00089502334594727
SELECT *, MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vivaraise rideau voile' IN BOOLEAN MODE) AND 4554 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
130 0.0005 0.00050520896911621
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
131 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '4246'
132 0.0004 0.0004429817199707
SELECT * FROM productcustomimages WHERE product_id = '4246'
133 0.0012 0.0012011528015137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
134 0.0006 0.00061917304992676
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00053000450134277
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.00047707557678223
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00054311752319336
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
138 0.0006 0.00064611434936523
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4581' AND p.id = pi.product_id ORDER BY pi.sortorder
139 0.0007 0.0006568431854248
SELECT * FROM product_image_select WHERE product_id = '4581'
140 0.0005 0.00045514106750488
SELECT * FROM productcustomimages WHERE product_id = '4581'
141 0.0006 0.00059819221496582
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 = '4581'
                GROUP BY o.product_id
142 0.0008 0.00081086158752441
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     = '4581'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
143 0.0005 0.00047492980957031
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
144 0.0009 0.00089311599731445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
145 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00043487548828125
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
149 0.0005 0.00053095817565918
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 = '4581'
                GROUP BY o.product_id
150 0.0008 0.0007939338684082
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     = '4581'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
151 0.0005 0.00045990943908691
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
152 0.0006 0.00061297416687012
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0007 0.00072813034057617
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4581'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
154 0.0006 0.00064897537231445
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4581'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
155 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
156 0.0005 0.00054407119750977
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4247' AND p.id = pi.product_id ORDER BY pi.sortorder
157 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '4247'
158 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '4247'
159 0.0007 0.00069618225097656
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 = '4247'
                GROUP BY o.product_id
160 0.0009 0.00089502334594727
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     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
161 0.0005 0.0005340576171875
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
162 0.0010 0.00099611282348633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
163 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00045514106750488
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00057411193847656
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
167 0.0006 0.00057601928710938
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 = '4247'
                GROUP BY o.product_id
168 0.0010 0.0009918212890625
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     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0005 0.00051689147949219
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
170 0.0008 0.00075507164001465
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0010 0.00095605850219727
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
172 0.0008 0.00076389312744141
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
173 0.0007 0.0007479190826416
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
174 0.0011 0.0010690689086914
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
175 0.0007 0.00068306922912598
SELECT * FROM product_image_select WHERE product_id = '4614'
176 0.0005 0.00045394897460938
SELECT * FROM productcustomimages WHERE product_id = '4614'
177 0.0007 0.00074982643127441
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
178 0.0012 0.0012059211730957
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
179 0.0006 0.00059390068054199
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
180 0.0009 0.00087904930114746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
181 0.0005 0.00046086311340332
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00035190582275391
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
184 0.0005 0.00049209594726562
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
185 0.0016 0.0016131401062012
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
186 0.0034 0.0033900737762451
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
187 0.0010 0.0010049343109131
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
188 0.0013 0.0012750625610352
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0021 0.0020759105682373
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
190 0.0020 0.0019679069519043
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
191 0.0009 0.00092291831970215
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
192 0.0018 0.0018148422241211
SELECT * FROM product_image_select WHERE product_id = '4245'
193 0.0006 0.00063109397888184
SELECT * FROM productcustomimages WHERE product_id = '4245'
194 0.0016 0.0016260147094727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
195 0.0007 0.00068402290344238
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0006 0.00059604644775391
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0007 0.00071907043457031
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
199 0.0009 0.00089001655578613
SELECT * FROM product_image_select WHERE product_id = '4256'
200 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '4256'
201 0.0018 0.0018157958984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
202 0.0008 0.00079798698425293
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0006 0.00063610076904297
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00063705444335938
SELECT id,asin FROM products WHERE parent_id = 4554
206 0.0005 0.00051307678222656
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4470
207 0.0008 0.00081801414489746
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4470
208 0.0004 0.00041890144348145
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4571
209 0.0006 0.00055098533630371
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4571
210 0.0004 0.00038504600524902
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4572
211 0.0005 0.0004889965057373
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4572
212 0.0006 0.00063800811767578
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4574
213 0.0007 0.00074005126953125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4574
214 0.0006 0.00056695938110352
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4576
215 0.0020 0.0020349025726318
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4576
216 0.0006 0.00061392784118652
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4577
217 0.0011 0.0011360645294189
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4577
218 0.0007 0.00072193145751953
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4578
219 0.0010 0.00095605850219727
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4578
220 0.0006 0.00059294700622559
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4579
221 0.0009 0.00090312957763672
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4579
222 0.0009 0.00086593627929688
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4580
223 0.0009 0.00092697143554688
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4580
224 0.0007 0.00065803527832031
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4771
225 0.0009 0.00092601776123047
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4771
226 0.0035 0.0034990310668945
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4554' ORDER BY timestamp DESC
227 0.0008 0.00076699256896973
SELECT category_id FROM products_categories WHERE product_id = '4554'
228 0.0007 0.00072407722473145
SELECT * FROM categories WHERE id = '27'
229 0.0083 0.0083441734313965
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
230 0.0023 0.002345085144043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
231 0.0007 0.00074911117553711
SELECT id FROM categories WHERE parent_id = '27'
232 0.0093 0.0093159675598145
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 
233 0.0011 0.0011181831359863
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 
234 0.0011 0.0011308193206787
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
235 0.0009 0.00088191032409668
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
236 0.0025 0.0024540424346924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
237 0.0009 0.00090599060058594
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0006 0.00061488151550293
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
240 0.0005 0.00048208236694336
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
241 0.0008 0.00079202651977539
SELECT * FROM products WHERE id = '4554'
242 0.0006 0.00063896179199219
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 = '4554'
                GROUP BY o.product_id
243 0.0013 0.0013110637664795
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     = '4554'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
244 0.0010 0.00096297264099121
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4554
245 0.0008 0.000823974609375
SELECT value FROM productattributes WHERE product_id = '4554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0019 0.0018630027770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
247 0.0005 0.0005338191986084
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0006 0.00059318542480469
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
250 0.0007 0.00065398216247559
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
251 0.0008 0.00078606605529785
SELECT DISTINCT (name) FROM productoptions
252 0.0007 0.00073003768920898
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4554))
253 0.0006 0.0006260871887207
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 4554
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
254 0.0025 0.0025320053100586
SELECT * FROM translationsfilter
255 0.0006 0.00057506561279297
SELECT category_id FROM products_categories WHERE product_id = '4554' AND prod_type = 'amz'
256 0.0005 0.00048995018005371
SELECT parent_id FROM categories WHERE id = '27'
257 0.0004 0.00041890144348145
SELECT * FROM categories WHERE id = '27'
258 0.0049 0.0048880577087402
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
259 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
260 0.0014 0.0013530254364014
SELECT id FROM categories WHERE parent_id = '27'
261 0.0112 0.011203050613403
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 
262 0.0012 0.00124192237854
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 
263 0.0012 0.0012249946594238
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
264 0.0015 0.001478910446167
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
265 0.0042 0.0042221546173096
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
266 0.0020 0.0019538402557373
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
267 0.0005 0.00050806999206543
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
268 0.0191 0.019083976745605
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
269 0.0017 0.0017399787902832
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
270 0.0006 0.00055909156799316
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
271 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = 1626
272 0.0007 0.0006558895111084
SELECT * FROM products WHERE id = 4041
273 0.0006 0.00063014030456543
SELECT * FROM products WHERE id = 4312
274 0.0006 0.00059199333190918
SELECT * FROM products WHERE id = 777
275 0.0006 0.0005640983581543
SELECT * FROM products WHERE id = 3881
276 0.0006 0.00056815147399902
SELECT * FROM products WHERE id = 4213
277 0.0006 0.00058317184448242
SELECT * FROM products WHERE id = '1626'
278 0.0076 0.0076279640197754
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
279 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '1626'
280 0.0005 0.00052309036254883
SELECT * FROM productcustomimages WHERE product_id = '1626'
281 0.0010 0.00097799301147461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
282 0.0006 0.00057005882263184
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
283 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
284 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0006 0.00061607360839844
SELECT * FROM products WHERE id = '4041'
286 0.0009 0.0008549690246582
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
287 0.0007 0.00071620941162109
SELECT * FROM product_image_select WHERE product_id = '4041'
288 0.0004 0.00039315223693848
SELECT * FROM productcustomimages WHERE product_id = '4041'
289 0.0011 0.0011069774627686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
290 0.0005 0.00049185752868652
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0005 0.00050616264343262
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0009 0.00091218948364258
SELECT * FROM products WHERE id = '4312'
294 0.0006 0.00062394142150879
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
295 0.0006 0.00064206123352051
SELECT * FROM product_image_select WHERE product_id = '4312'
296 0.0008 0.00079011917114258
SELECT * FROM productcustomimages WHERE product_id = '4312'
297 0.0010 0.0010111331939697
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
298 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0006 0.00058293342590332
SELECT * FROM products WHERE id = '777'
302 0.0005 0.00046396255493164
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
303 0.0006 0.00059795379638672
SELECT * FROM product_image_select WHERE product_id = '777'
304 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '777'
305 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
306 0.0005 0.00046491622924805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0006 0.00058698654174805
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0005 0.00054717063903809
SELECT * FROM products WHERE id = '3881'
310 0.0007 0.00067782402038574
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
311 0.0006 0.00058579444885254
SELECT * FROM product_image_select WHERE product_id = '3881'
312 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '3881'
313 0.0012 0.001201868057251
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
314 0.0005 0.00050902366638184
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0006 0.00060200691223145
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0006 0.00061392784118652
SELECT * FROM products WHERE id = '4213'
318 0.0008 0.00076103210449219
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
319 0.0007 0.000701904296875
SELECT * FROM product_image_select WHERE product_id = '4213'
320 0.0006 0.00057506561279297
SELECT * FROM productcustomimages WHERE product_id = '4213'
321 0.0013 0.001291036605835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
322 0.0006 0.0006411075592041
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0006 0.00062799453735352
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0022 0.0021910667419434
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
326 0.0009 0.00085592269897461
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
327 0.0030 0.0029611587524414
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
328 0.0021 0.0021319389343262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
329 0.0008 0.00080180168151855
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
330 0.0011 0.0010900497436523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'