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.2734940052032 325 1.0323 0


No Amazon API Requests Made.


App Debug - Total Time 1.2734940052032 seconds

Number Time From Start Name Description
1 0.22006297111511 Initialise Initialise FSB Function
2 0.22232389450073 App Controller Start Start of the App controller (called before the controller of every page)
3 0.26873087882996 Start of getCategoryListByGroup Function Before first category groups query
4 0.26917099952698 After initial query Before first category groups query
5 0.26917195320129 Get Category List for Group Before the call to getCategoryList function
6 0.26917386054993 Start of GetCategoryList function Start of the function
7 0.26917505264282 Before getting categories Query to get specific category list
8 0.26955604553223 After getting categories Query to get specific category list
9 0.26955699920654 Before getting category custom Before call to function getCategoryCustom
10 0.28174686431885 After getting category custom After call to function getCategoryCustom
11 0.28174901008606 Before getting category custom Before call to function getCategoryCustom
12 0.29017496109009 After getting category custom After call to function getCategoryCustom
13 0.2901759147644 Before getting category custom Before call to function getCategoryCustom
14 0.29469895362854 After getting category custom After call to function getCategoryCustom
15 0.29470086097717 Before getting category custom Before call to function getCategoryCustom
16 0.2975869178772 After getting category custom After call to function getCategoryCustom
17 0.29758787155151 Before getting category custom Before call to function getCategoryCustom
18 0.30052399635315 After getting category custom After call to function getCategoryCustom
19 0.30052495002747 Before getting category custom Before call to function getCategoryCustom
20 0.3034839630127 After getting category custom After call to function getCategoryCustom
21 0.30348491668701 End of GetCategoryList function End of the function
22 0.30348706245422 Get Category List for Group Before the call to getCategoryList function
23 0.30348896980286 Start of GetCategoryList function Start of the function
24 0.30348896980286 Before getting categories Query to get specific category list
25 0.30382299423218 End of getCategoryListByGroup Function Before return()
26 1.0846240520477 App Controller End End of the App controller (called before the controller of every page)
27 1.0849649906158 Product Start Start of the product info controller
28 1.0877690315247 Cache file not found Starting get product details
29 1.1140990257263 Related products Start getting related products if enabled
30 1.1140999794006 Related Products Start Before the related products are found
31 1.1140999794006 Related Products Keywords Before the related product keywords are found
32 1.1141040325165 Create Keyword List Function Start of function
33 1.1141250133514 Create Keyword List Function After looping provided content - 21 keywords found
34 1.1144599914551 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
35 1.1144649982452 Create Keyword List Function After reducing keyword list
36 1.1144828796387 Create Keyword List Function After selecting by scoring keywords
37 1.1144850254059 Create Keyword List Function After final loop of keywords
38 1.1144859790802 Related Products Keywords After the related product keywords are found
39 1.1598029136658 Related Products End After the related products are found
40 1.2017209529877 Product End End of the product info controller (Product Info)
41 1.2024848461151 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.2032558917999 Before Get Options Before the call to getOptions in the tpl class
43 1.2486538887024 After Get Options After the call to getOptions in the tpl class
44 1.248715877533 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.248733997345 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.2518248558044 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.2518270015717 Product Info: Before Template Display Before the template is displayed
48 1.2734758853912 Product Info: After Template Display After the template is displayed
49 1.2734839916229 Finalizing debug Before the debug is output to the page.
50 1.2734940052032 End of App This is the end of the app logging, final timestamp


Query Debug - 325 Database Queries. Total time 1.0323 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00084304809570312
SELECT parameter, value FROM parameters
2 0.0042 0.0042421817779541
SELECT * FROM `bad_bots`
3 0.0003 0.00033903121948242
SET time_zone = 'Europe/London'
4 0.0015 0.0014760494232178
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.00066804885864258
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.235\";}'
6 0.0006 0.0006260871887207
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750463376'
7 0.0010 0.00098586082458496
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00042009353637695
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.0006411075592041
SELECT id FROM pages WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm' LIMIT 1
10 0.0010 0.00098109245300293
SELECT id FROM products WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm' AND hidden = 0 LIMIT 1
11 0.0023 0.002349853515625
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0433 0.043349981307983
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00046205520629883
SELECT * FROM pages WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm'
14 0.0004 0.00043606758117676
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00037288665771484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0050 0.0050079822540283
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.0004 0.00037407875061035
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.0003 0.0002748966217041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00029492378234863
SELECT id FROM categories WHERE parent_id = '26'
20 0.0048 0.0048489570617676
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.0004 0.0003969669342041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00034999847412109
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.0003 0.00031614303588867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.0002901554107666
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030450820922852
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.0004 0.0003511905670166
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.0003 0.00026106834411621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0003058910369873
SELECT id FROM categories WHERE parent_id = '27'
29 0.0031 0.003108024597168
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.0004 0.00036406517028809
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.0004 0.00035309791564941
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.0003 0.0003211498260498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00029611587524414
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0011379718780518
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.0003 0.00033903121948242
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.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.0002899169921875
SELECT id FROM categories WHERE parent_id = '28'
38 0.0012 0.0012028217315674
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.0003 0.00034117698669434
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.0003 0.0003349781036377
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.0003 0.00029802322387695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00027799606323242
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00037193298339844
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.0003 0.00031495094299316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00025606155395508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00028491020202637
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.0004279613494873
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.0003 0.00030708312988281
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.0003 0.0003199577331543
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.0003 0.00031089782714844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.0002741813659668
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00041723251342773
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.0003 0.00029492378234863
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00026988983154297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.0002741813659668
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00043892860412598
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.0003 0.00031208992004395
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.0003 0.00032305717468262
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.0003 0.00029301643371582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00029587745666504
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.0003969669342041
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.0003 0.00029611587524414
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00026321411132812
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00029683113098145
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00046086311340332
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.0003 0.00032687187194824
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.0003 0.00033116340637207
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.0003 0.00029706954956055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.0002741813659668
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00033092498779297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0013 0.0013079643249512
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00040388107299805
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00036096572875977
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.0003 0.00027894973754883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00089383125305176
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00059390068054199
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7749 0.77485084533691
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.235') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.235') <= INET_ATON(ip_end)
78 0.0011 0.0010879039764404
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00036191940307617
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00047516822814941
SELECT * FROM products WHERE pagename = 'vivaraise-rideau-voile-zeff-140-x-280-cm'
81 0.0013 0.001349925994873
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4554
82 0.0004 0.00039196014404297
SELECT * FROM manufacturers WHERE id = '619'
83 0.0007 0.00065016746520996
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
84 0.0003 0.00031185150146484
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
85 0.0005 0.00049495697021484
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.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
87 0.0004 0.00035595893859863
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
88 0.0004 0.00038409233093262
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.0003 0.00026893615722656
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
90 0.0003 0.00031185150146484
SELECT category_id FROM products_categories WHERE product_id = '4554'
91 0.0003 0.00031900405883789
SELECT * FROM categories WHERE id = '27'
92 0.0029 0.0029199123382568
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.00058293342590332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00036501884460449
SELECT id FROM categories WHERE parent_id = '27'
95 0.0046 0.0046019554138184
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.0007319450378418
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.0004 0.00039100646972656
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.0003 0.0003211498260498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00066590309143066
SELECT * FROM productimages WHERE product_id = '4554' ORDER BY sortorder ASC
100 0.0008 0.00079011917114258
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.0005 0.00045609474182129
SELECT * FROM product_image_select WHERE product_id = '4554'
102 0.0006 0.00056004524230957
SELECT * FROM productcustomimages WHERE product_id = '4554'
103 0.0003 0.00027108192443848
SELECT * FROM productfeeds WHERE product_id = '4554' ORDER BY item_date DESC
104 0.0005 0.00048184394836426
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.0017 0.0017330646514893
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.0009 0.0008690357208252
SELECT * FROM productamazoncontent WHERE product_id = '4554'
107 0.0005 0.00047421455383301
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
108 0.0008 0.00083017349243164
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
109 0.0006 0.00060915946960449
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
110 0.0010 0.0010190010070801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
111 0.0003 0.00025796890258789
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
114 0.0002 0.00023508071899414
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
115 0.0003 0.00029301643371582
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
116 0.0005 0.0005190372467041
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
117 0.0003 0.00027012825012207
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
118 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '4554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0004 0.00042605400085449
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
120 0.0004 0.00038003921508789
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
121 0.0004 0.00035715103149414
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
122 0.0070 0.0069880485534668
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
123 0.0004 0.00038981437683105
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
124 0.0003 0.00034379959106445
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
125 0.0003 0.0003209114074707
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
126 0.0005 0.00049090385437012
SELECT * FROM product_image_select WHERE product_id = '4256'
127 0.0003 0.00031614303588867
SELECT * FROM productcustomimages WHERE product_id = '4256'
128 0.0020 0.0019810199737549
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
129 0.0005 0.00053596496582031
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0003 0.00034689903259277
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0004 0.00040698051452637
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
133 0.0006 0.00056195259094238
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
134 0.0006 0.00058412551879883
SELECT * FROM product_image_select WHERE product_id = '4247'
135 0.0003 0.0003359317779541
SELECT * FROM productcustomimages WHERE product_id = '4247'
136 0.0005 0.00051999092102051
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
137 0.0007 0.0007021427154541
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
138 0.0004 0.00039196014404297
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
139 0.0007 0.00073695182800293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
140 0.0003 0.00030303001403809
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0003 0.00028896331787109
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00030398368835449
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
144 0.0004 0.00036883354187012
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
145 0.0006 0.00061297416687012
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
146 0.0004 0.00035500526428223
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
147 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0006 0.0005638599395752
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
149 0.0005 0.00045490264892578
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
150 0.0005 0.00047492980957031
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
151 0.0009 0.00088596343994141
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
152 0.0006 0.00061488151550293
SELECT * FROM product_image_select WHERE product_id = '4614'
153 0.0003 0.00033092498779297
SELECT * FROM productcustomimages WHERE product_id = '4614'
154 0.0006 0.00056791305541992
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
155 0.0009 0.00094413757324219
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
156 0.0004 0.00044918060302734
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
157 0.0007 0.00072288513183594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
158 0.0003 0.00027108192443848
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00028514862060547
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0003 0.00026488304138184
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
161 0.0003 0.0003199577331543
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
162 0.0005 0.00047183036804199
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
163 0.0009 0.00092315673828125
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
164 0.0004 0.00043296813964844
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
165 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0007 0.00073099136352539
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
167 0.0007 0.0006558895111084
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
168 0.0004 0.00037884712219238
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
169 0.0006 0.0005650520324707
SELECT * FROM product_image_select WHERE product_id = '4245'
170 0.0003 0.00031089782714844
SELECT * FROM productcustomimages WHERE product_id = '4245'
171 0.0009 0.00086092948913574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
172 0.0004 0.0003659725189209
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0003 0.0003209114074707
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0004 0.00040578842163086
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
176 0.0005 0.00045895576477051
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
177 0.0006 0.00059604644775391
SELECT * FROM product_image_select WHERE product_id = '4581'
178 0.0003 0.00031495094299316
SELECT * FROM productcustomimages WHERE product_id = '4581'
179 0.0004 0.00044512748718262
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
180 0.0007 0.00066304206848145
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
181 0.0003 0.00033783912658691
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
182 0.0007 0.00069594383239746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
183 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0003 0.00029516220092773
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0003 0.00029206275939941
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
186 0.0003 0.00030303001403809
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
187 0.0004 0.00041294097900391
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
188 0.0006 0.00062298774719238
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
189 0.0003 0.00033903121948242
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
190 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0006 0.00057291984558105
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
192 0.0005 0.00046300888061523
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
193 0.0004 0.00037789344787598
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
194 0.0006 0.00056791305541992
SELECT * FROM product_image_select WHERE product_id = '4246'
195 0.0004 0.00035881996154785
SELECT * FROM productcustomimages WHERE product_id = '4246'
196 0.0009 0.00089001655578613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
197 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0003 0.00033307075500488
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0004 0.00040602684020996
SELECT id,asin FROM products WHERE parent_id = 4554
201 0.0004 0.00041294097900391
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4470
202 0.0005 0.00046396255493164
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4470
203 0.0003 0.00030207633972168
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4571
204 0.0004 0.00040698051452637
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4571
205 0.0003 0.00031876564025879
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4572
206 0.0004 0.00036501884460449
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4572
207 0.0003 0.00027894973754883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4574
208 0.0004 0.00036001205444336
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4574
209 0.0003 0.00029182434082031
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4576
210 0.0004 0.00035405158996582
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4576
211 0.0003 0.00026798248291016
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4577
212 0.0003 0.00034999847412109
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4577
213 0.0003 0.00026893615722656
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4578
214 0.0004 0.00035190582275391
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4578
215 0.0003 0.00026917457580566
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4579
216 0.0004 0.00037789344787598
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4579
217 0.0003 0.00027203559875488
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4580
218 0.0003 0.00034594535827637
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4580
219 0.0003 0.00027608871459961
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4771
220 0.0003 0.00034904479980469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4771
221 0.0004 0.00037503242492676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4554' ORDER BY timestamp DESC
222 0.0004 0.00035715103149414
SELECT category_id FROM products_categories WHERE product_id = '4554'
223 0.0004 0.00036120414733887
SELECT * FROM categories WHERE id = '27'
224 0.0041 0.0041201114654541
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
225 0.0004 0.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
226 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '27'
227 0.0040 0.0039770603179932
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 
228 0.0004 0.00044608116149902
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 
229 0.0005 0.00046992301940918
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
230 0.0004 0.00042390823364258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
231 0.0009 0.0009300708770752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
232 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0003 0.0003209114074707
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0003 0.00028204917907715
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00031304359436035
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
236 0.0005 0.00045990943908691
SELECT * FROM products WHERE id = '4554'
237 0.0004 0.00037789344787598
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
238 0.0008 0.00077199935913086
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
239 0.0004 0.00035715103149414
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
240 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '4554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0009 0.00088095664978027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
242 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0003 0.00029993057250977
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00029492378234863
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
246 0.0005 0.00049710273742676
SELECT DISTINCT (name) FROM productoptions
247 0.0005 0.00046896934509277
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4554))
248 0.0005 0.0004570484161377
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
249 0.0038 0.0038001537322998
SELECT * FROM translationsfilter
250 0.0004 0.00041103363037109
SELECT category_id FROM products_categories WHERE product_id = '4554' AND prod_type = 'amz'
251 0.0004 0.00038504600524902
SELECT parent_id FROM categories WHERE id = '27'
252 0.0003 0.00029611587524414
SELECT * FROM categories WHERE id = '27'
253 0.0041 0.0041160583496094
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
254 0.0004 0.00039100646972656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
255 0.0003 0.00027084350585938
SELECT id FROM categories WHERE parent_id = '27'
256 0.0041 0.0040569305419922
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 
257 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
258 0.0005 0.00046300888061523
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
259 0.0004 0.00042414665222168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
260 0.0004 0.00043487548828125
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
261 0.0004 0.00037789344787598
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
262 0.0003 0.00033998489379883
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
263 0.0164 0.016404151916504
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
264 0.0007 0.00066590309143066
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
265 0.0005 0.00050902366638184
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
266 0.0004 0.00044393539428711
SELECT * FROM products WHERE id = 1626
267 0.0003 0.00033712387084961
SELECT * FROM products WHERE id = 4041
268 0.0003 0.00028705596923828
SELECT * FROM products WHERE id = 4312
269 0.0003 0.00028204917907715
SELECT * FROM products WHERE id = 777
270 0.0003 0.00030398368835449
SELECT * FROM products WHERE id = 3881
271 0.0003 0.00028300285339355
SELECT * FROM products WHERE id = 4213
272 0.0003 0.00028705596923828
SELECT * FROM products WHERE id = '1626'
273 0.0004 0.00037789344787598
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
274 0.0006 0.00056815147399902
SELECT * FROM product_image_select WHERE product_id = '1626'
275 0.0003 0.00031590461730957
SELECT * FROM productcustomimages WHERE product_id = '1626'
276 0.0008 0.00075793266296387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
277 0.0004 0.00040721893310547
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0004 0.00043416023254395
SELECT * FROM products WHERE id = '4041'
281 0.0004 0.00038981437683105
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
282 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '4041'
283 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '4041'
284 0.0010 0.0010380744934082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
285 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0003 0.00033211708068848
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = '4312'
289 0.0004 0.00035595893859863
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
290 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '4312'
291 0.0003 0.00031018257141113
SELECT * FROM productcustomimages WHERE product_id = '4312'
292 0.0009 0.00086116790771484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
293 0.0004 0.0003659725189209
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0003 0.00031900405883789
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0004 0.00038409233093262
SELECT * FROM products WHERE id = '777'
297 0.0004 0.00036406517028809
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
298 0.0006 0.00055694580078125
SELECT * FROM product_image_select WHERE product_id = '777'
299 0.0003 0.00032305717468262
SELECT * FROM productcustomimages WHERE product_id = '777'
300 0.0009 0.00092101097106934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
301 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0003 0.00031304359436035
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0003 0.00031089782714844
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '3881'
305 0.0004 0.00042986869812012
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
306 0.0006 0.0005650520324707
SELECT * FROM product_image_select WHERE product_id = '3881'
307 0.0003 0.0003199577331543
SELECT * FROM productcustomimages WHERE product_id = '3881'
308 0.0009 0.00090384483337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
309 0.0004 0.00039219856262207
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0003 0.0003058910369873
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0003 0.00031495094299316
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0004 0.00039792060852051
SELECT * FROM products WHERE id = '4213'
313 0.0004 0.00040912628173828
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
314 0.0005 0.00053596496582031
SELECT * FROM product_image_select WHERE product_id = '4213'
315 0.0003 0.00031208992004395
SELECT * FROM productcustomimages WHERE product_id = '4213'
316 0.0010 0.00095605850219727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
317 0.0004 0.0003809928894043
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320 0.0007 0.00072383880615234
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
321 0.0006 0.00060701370239258
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
322 0.0014 0.0013511180877686
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
323 0.0005 0.00048208236694336
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
324 0.0004 0.00035214424133301
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
325 0.0005 0.00045585632324219
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'