0

Vivaraise Tapis de Bain Etia

Price: €28,90
Product prices and availability are accurate as of 2022-06-26 00:02:26 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

🍀 100% COTON 🍀 1500 g/m2 🍀 Lavable à 30°, Javel : non, Séchage : non, Repassage moyen 1Nettoyage à l'eau°, 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.5132629871368 342 0.8398 0


No Amazon API Requests Made.


App Debug - Total Time 1.5132629871368 seconds

Number Time From Start Name Description
1 0.55644798278809 Initialise Initialise FSB Function
2 0.55974292755127 App Controller Start Start of the App controller (called before the controller of every page)
3 0.59926104545593 Start of getCategoryListByGroup Function Before first category groups query
4 0.59980392456055 After initial query Before first category groups query
5 0.59980607032776 Get Category List for Group Before the call to getCategoryList function
6 0.59981107711792 Start of GetCategoryList function Start of the function
7 0.59981608390808 Before getting categories Query to get specific category list
8 0.60060214996338 After getting categories Query to get specific category list
9 0.60060501098633 Before getting category custom Before call to function getCategoryCustom
10 0.61683201789856 After getting category custom After call to function getCategoryCustom
11 0.6168360710144 Before getting category custom Before call to function getCategoryCustom
12 0.62912106513977 After getting category custom After call to function getCategoryCustom
13 0.62912702560425 Before getting category custom Before call to function getCategoryCustom
14 0.63675498962402 After getting category custom After call to function getCategoryCustom
15 0.63675904273987 Before getting category custom Before call to function getCategoryCustom
16 0.64163494110107 After getting category custom After call to function getCategoryCustom
17 0.6416380405426 Before getting category custom Before call to function getCategoryCustom
18 0.64656209945679 After getting category custom After call to function getCategoryCustom
19 0.64656496047974 Before getting category custom Before call to function getCategoryCustom
20 0.65122413635254 After getting category custom After call to function getCategoryCustom
21 0.65122699737549 End of GetCategoryList function End of the function
22 0.65123510360718 Get Category List for Group Before the call to getCategoryList function
23 0.65123701095581 Start of GetCategoryList function Start of the function
24 0.65124011039734 Before getting categories Query to get specific category list
25 0.65175008773804 End of getCategoryListByGroup Function Before return()
26 1.1272721290588 App Controller End End of the App controller (called before the controller of every page)
27 1.1278629302979 Product Start Start of the product info controller
28 1.1420631408691 Cache file not found Starting get product details
29 1.1911420822144 Related products Start getting related products if enabled
30 1.191143989563 Related Products Start Before the related products are found
31 1.1911461353302 Related Products Keywords Before the related product keywords are found
32 1.1911499500275 Create Keyword List Function Start of function
33 1.1911799907684 Create Keyword List Function After looping provided content - 12 keywords found
34 1.1917219161987 Create Keyword List Function After looping initial keyword list - 11 keywords remaining
35 1.1917290687561 Create Keyword List Function After reducing keyword list
36 1.1917469501495 Create Keyword List Function After selecting by scoring keywords
37 1.1917510032654 Create Keyword List Function After final loop of keywords
38 1.1917531490326 Related Products Keywords After the related product keywords are found
39 1.2844760417938 Related Products End After the related products are found
40 1.3438320159912 Product End End of the product info controller (Product Info)
41 1.3454351425171 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3465421199799 Before Get Options Before the call to getOptions in the tpl class
43 1.4102289676666 After Get Options After the call to getOptions in the tpl class
44 1.4104030132294 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.410453081131 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4349460601807 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4349520206451 Product Info: Before Template Display Before the template is displayed
48 1.5132219791412 Product Info: After Template Display After the template is displayed
49 1.5132400989532 Finalizing debug Before the debug is output to the page.
50 1.5132620334625 End of App This is the end of the app logging, final timestamp


Query Debug - 342 Database Queries. Total time 0.8398 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.0019679069519043
SELECT parameter, value FROM parameters
2 0.0053 0.0052750110626221
SELECT * FROM `bad_bots`
3 0.0004 0.0004270076751709
SET time_zone = 'Europe/London'
4 0.0011 0.0010738372802734
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011329650878906
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.200.122.214\";}'
6 0.0010 0.00098299980163574
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1728674699'
7 0.0012 0.0012109279632568
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00063920021057129
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010261535644531
SELECT id FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' LIMIT 1
10 0.0013 0.0012679100036621
SELECT id FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' AND hidden = 0 LIMIT 1
11 0.0030 0.0030088424682617
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0352 0.035233020782471
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00060915946960449
SELECT * FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
14 0.0005 0.00052285194396973
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00075197219848633
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0057 0.0056779384613037
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0006 0.00058984756469727
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.0006 0.00056600570678711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00054121017456055
SELECT id FROM categories WHERE parent_id = '26'
20 0.0062 0.0061848163604736
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.0008 0.00078105926513672
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0006 0.00060892105102539
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0005 0.0005338191986084
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00048708915710449
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0038177967071533
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.0006 0.00060105323791504
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00049400329589844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00052595138549805
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0042648315429688
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.0006 0.00064301490783691
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0006 0.00062704086303711
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.00054311752319336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053286552429199
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0019218921661377
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.0006 0.00064516067504883
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.0005 0.00046610832214355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00047492980957031
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0017869472503662
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00052809715270996
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.0007 0.00067400932312012
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.0005490779876709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00043892860412598
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00058293342590332
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.0005347728729248
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.0005 0.00045609474182129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00048708915710449
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00068402290344238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0005 0.00051283836364746
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.00054001808166504
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.00053691864013672
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00043296813964844
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056600570678711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0005 0.00049686431884766
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.0004 0.00044894218444824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00045204162597656
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00079894065856934
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.0006 0.00059700012207031
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00050187110900879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00044989585876465
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00055694580078125
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00054407119750977
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00042486190795898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00041103363037109
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00068497657775879
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.0005 0.00052714347839355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00050187110900879
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00046801567077637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0004417896270752
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00049805641174316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.0015120506286621
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00061392784118652
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00055503845214844
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.0005 0.00049304962158203
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.001107931137085
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0012578964233398
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4655 0.4655168056488
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.122.214') >= INET_ATON(ip_start) AND INET_ATON('44.200.122.214') <= INET_ATON(ip_end)
78 0.0019 0.0019369125366211
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0013229846954346
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00074505805969238
SELECT * FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
81 0.0009 0.00089097023010254
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4556
82 0.0014 0.0014469623565674
SELECT * FROM manufacturers WHERE id = '619'
83 0.0014 0.0013859272003174
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
84 0.0009 0.00090599060058594
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
85 0.0018 0.0018079280853271
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.0009 0.00086808204650879
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
87 0.0012 0.0011959075927734
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
88 0.0011 0.0011000633239746
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.00060105323791504
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
90 0.0009 0.00089120864868164
SELECT category_id FROM products_categories WHERE product_id = '4556'
91 0.0009 0.00086188316345215
SELECT * FROM categories WHERE id = '27'
92 0.0122 0.012184143066406
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.00060415267944336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '27'
95 0.0046 0.0046000480651855
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.00066184997558594
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0006 0.00060510635375977
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.00058102607727051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00061893463134766
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
100 0.0009 0.0009000301361084
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4556' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0008 0.00078511238098145
SELECT * FROM product_image_select WHERE product_id = '4556'
102 0.0005 0.00049304962158203
SELECT * FROM productcustomimages WHERE product_id = '4556'
103 0.0005 0.00050783157348633
SELECT * FROM productfeeds WHERE product_id = '4556' ORDER BY item_date DESC
104 0.0009 0.00086498260498047
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0007 0.00071191787719727
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4556' AND t.hidden = 0 AND display_product = 1
106 0.0004 0.00035500526428223
SELECT * FROM tags WHERE id = '3966'
107 0.0007 0.00066399574279785
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.0005 0.00052380561828613
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.0005 0.00053787231445312
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.0005 0.00054121017456055
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
111 0.0005 0.00048494338989258
SELECT * FROM productamazoncontent WHERE product_id = '4556'
112 0.0006 0.00063800811767578
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 = '4556'
                GROUP BY o.product_id
113 0.0010 0.00096893310546875
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     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
114 0.0005 0.00053191184997559
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
115 0.0009 0.00090885162353516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
116 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0004 0.00037193298339844
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00039792060852051
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
120 0.0005 0.00050806999206543
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 = '4556'
                GROUP BY o.product_id
121 0.0010 0.0009911060333252
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     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
122 0.0005 0.00049519538879395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
123 0.0006 0.000640869140625
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0009 0.00092911720275879
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
125 0.0007 0.00067996978759766
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
126 0.0006 0.00062990188598633
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.0098 0.0097689628601074
SELECT *, MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AND 4556 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
128 0.0010 0.00096797943115234
SELECT *, MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AND 4556 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
129 0.0009 0.00088405609130859
SELECT *, MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vivaraise tapis de' IN BOOLEAN MODE) AND 4556 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
130 0.0009 0.00093483924865723
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
131 0.0006 0.00058913230895996
SELECT * FROM product_image_select WHERE product_id = '4245'
132 0.0005 0.00051212310791016
SELECT * FROM productcustomimages WHERE product_id = '4245'
133 0.0011 0.0010719299316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
134 0.0005 0.00047707557678223
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00046586990356445
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
138 0.0007 0.00067901611328125
SELECT * FROM product_image_select WHERE product_id = '4256'
139 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '4256'
140 0.0012 0.0012099742889404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
141 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0005 0.00048089027404785
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00054502487182617
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
145 0.0007 0.00072097778320312
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
146 0.0006 0.00063204765319824
SELECT * FROM product_image_select WHERE product_id = '4247'
147 0.0005 0.00049114227294922
SELECT * FROM productcustomimages WHERE product_id = '4247'
148 0.0007 0.00065493583679199
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
149 0.0007 0.00073409080505371
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
150 0.0004 0.00044512748718262
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
151 0.0008 0.00081396102905273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
152 0.0004 0.00035500526428223
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00045108795166016
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
156 0.0005 0.00050091743469238
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
157 0.0008 0.00077700614929199
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
158 0.0006 0.00061297416687012
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
159 0.0007 0.00065803527832031
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0009 0.0008540153503418
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
161 0.0006 0.00058984756469727
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
162 0.0005 0.00051999092102051
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
163 0.0005 0.00046801567077637
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
164 0.0009 0.00088906288146973
SELECT * FROM product_image_select WHERE product_id = '4581'
165 0.0005 0.00045299530029297
SELECT * FROM productcustomimages WHERE product_id = '4581'
166 0.0006 0.00061702728271484
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
167 0.0008 0.00078701972961426
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
168 0.0005 0.00045895576477051
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
169 0.0010 0.00095987319946289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
170 0.0004 0.00043106079101562
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0010 0.0010221004486084
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0010 0.0010421276092529
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
173 0.0010 0.00099396705627441
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
174 0.0014 0.0013949871063232
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
175 0.0022 0.0022051334381104
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
176 0.0010 0.00098800659179688
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
177 0.0013 0.0013298988342285
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0021 0.002072811126709
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
179 0.0029 0.0028660297393799
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
180 0.0010 0.00095987319946289
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
181 0.0012 0.0011742115020752
SELECT * FROM product_image_select WHERE product_id = '4246'
182 0.0006 0.00063896179199219
SELECT * FROM productcustomimages WHERE product_id = '4246'
183 0.0020 0.0020267963409424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
184 0.0015 0.00148606300354
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0012 0.0011820793151855
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0011 0.0011310577392578
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0014 0.0013799667358398
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
188 0.0042 0.0041849613189697
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4322' AND p.id = pi.product_id ORDER BY pi.sortorder
189 0.0015 0.0014691352844238
SELECT * FROM product_image_select WHERE product_id = '4322'
190 0.0009 0.000946044921875
SELECT * FROM productcustomimages WHERE product_id = '4322'
191 0.0026 0.0025539398193359
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4322'
                GROUP BY o.product_id
192 0.0039 0.0039260387420654
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
193 0.0013 0.0013010501861572
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
194 0.0025 0.0024518966674805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
195 0.0006 0.00060081481933594
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0005 0.00051689147949219
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
198 0.0006 0.00055694580078125
SELECT value FROM productattributes
                WHERE product_id = '4322'
                AND name = 'ListPriceAmount'
199 0.0012 0.0011701583862305
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4322'
                GROUP BY o.product_id
200 0.0020 0.0020439624786377
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
201 0.0007 0.00067901611328125
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
202 0.0006 0.00062203407287598
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0014 0.001446008682251
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
204 0.0044 0.0043649673461914
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
205 0.0005 0.00046396255493164
SELECT id,asin FROM products WHERE parent_id = 4556
206 0.0007 0.00067901611328125
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4512
207 0.0005 0.00048494338989258
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4512
208 0.0004 0.00041413307189941
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4514
209 0.0009 0.00092697143554688
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4514
210 0.0015 0.001511812210083
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4263
211 0.0010 0.0010309219360352
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4263
212 0.0004 0.00039505958557129
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4264
213 0.0004 0.00043487548828125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4264
214 0.0004 0.00040888786315918
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4515
215 0.0005 0.00046205520629883
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4515
216 0.0004 0.00039577484130859
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4784
217 0.0005 0.0004878044128418
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4784
218 0.0004 0.00037097930908203
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4785
219 0.0005 0.00046992301940918
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4785
220 0.0004 0.0004279613494873
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4786
221 0.0005 0.0005030632019043
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4786
222 0.0004 0.00044703483581543
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4787
223 0.0005 0.00048398971557617
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4787
224 0.0003 0.00033783912658691
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4788
225 0.0005 0.00047707557678223
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4788
226 0.0003 0.00034403800964355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4789
227 0.0005 0.00045394897460938
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4789
228 0.0004 0.0003809928894043
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4790
229 0.0004 0.0004420280456543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4790
230 0.0004 0.00041890144348145
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4791
231 0.0005 0.00054502487182617
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4791
232 0.0004 0.00040197372436523
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4792
233 0.0005 0.00048208236694336
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4792
234 0.0004 0.0004119873046875
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4793
235 0.0005 0.00047206878662109
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4793
236 0.0003 0.00034213066101074
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4889
237 0.0005 0.00052809715270996
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4889
238 0.0005 0.00052499771118164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
239 0.0004 0.00043392181396484
SELECT category_id FROM products_categories WHERE product_id = '4556'
240 0.0006 0.0005638599395752
SELECT * FROM categories WHERE id = '27'
241 0.0040 0.0040059089660645
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
242 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
243 0.0004 0.0003669261932373
SELECT id FROM categories WHERE parent_id = '27'
244 0.0041 0.0041100978851318
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 
245 0.0006 0.00064206123352051
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 
246 0.0007 0.00067591667175293
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
247 0.0005 0.00053977966308594
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
248 0.0009 0.00091314315795898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
249 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0006 0.00055408477783203
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00046300888061523
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
253 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = '4556'
254 0.0006 0.00060296058654785
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 = '4556'
                GROUP BY o.product_id
255 0.0010 0.0010230541229248
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     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
256 0.0006 0.00055909156799316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
257 0.0007 0.00067281723022461
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0010 0.00096678733825684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
259 0.0006 0.00060510635375977
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
262 0.0007 0.00069403648376465
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
263 0.0009 0.00093293190002441
SELECT DISTINCT (name) FROM productoptions
264 0.0011 0.0011029243469238
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4556))
265 0.0010 0.00095701217651367
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 4556
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
266 0.0021 0.0021281242370605
SELECT * FROM translationsfilter
267 0.0006 0.00057506561279297
SELECT category_id FROM products_categories WHERE product_id = '4556' AND prod_type = 'amz'
268 0.0005 0.000518798828125
SELECT parent_id FROM categories WHERE id = '27'
269 0.0004 0.00043797492980957
SELECT * FROM categories WHERE id = '27'
270 0.0050 0.0050380229949951
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
271 0.0006 0.0006248950958252
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
272 0.0005 0.00049304962158203
SELECT id FROM categories WHERE parent_id = '27'
273 0.0045 0.0044550895690918
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 
274 0.0007 0.00074005126953125
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 
275 0.0006 0.0006258487701416
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
276 0.0006 0.00060606002807617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
277 0.0008 0.00076699256896973
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
278 0.0005 0.00050997734069824
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
279 0.0005 0.00045490264892578
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
280 0.0156 0.015642881393433
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
281 0.0008 0.00078797340393066
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
282 0.0007 0.00073480606079102
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
283 0.0007 0.00067496299743652
SELECT * FROM products WHERE id = 1626
284 0.0007 0.00065302848815918
SELECT * FROM products WHERE id = 4041
285 0.0006 0.00058913230895996
SELECT * FROM products WHERE id = 4312
286 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 777
287 0.0007 0.00066590309143066
SELECT * FROM products WHERE id = 3881
288 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = 4213
289 0.0006 0.00063395500183105
SELECT * FROM products WHERE id = '1626'
290 0.0005 0.00054287910461426
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
291 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '1626'
292 0.0005 0.00053000450134277
SELECT * FROM productcustomimages WHERE product_id = '1626'
293 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
294 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0007 0.00068116188049316
SELECT * FROM products WHERE id = '4041'
298 0.0006 0.00059294700622559
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
299 0.0007 0.00072598457336426
SELECT * FROM product_image_select WHERE product_id = '4041'
300 0.0005 0.00052690505981445
SELECT * FROM productcustomimages WHERE product_id = '4041'
301 0.0012 0.0011639595031738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
302 0.0010 0.0010280609130859
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
303 0.0006 0.00060582160949707
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0007 0.00072503089904785
SELECT * FROM products WHERE id = '4312'
306 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
307 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '4312'
308 0.0005 0.00047206878662109
SELECT * FROM productcustomimages WHERE product_id = '4312'
309 0.0012 0.0011920928955078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
310 0.0008 0.00075197219848633
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0005 0.00053095817565918
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0006 0.00057291984558105
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0007 0.00074505805969238
SELECT * FROM products WHERE id = '777'
314 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
315 0.0009 0.00089406967163086
SELECT * FROM product_image_select WHERE product_id = '777'
316 0.0005 0.00053310394287109
SELECT * FROM productcustomimages WHERE product_id = '777'
317 0.0016 0.001629114151001
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
318 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0006 0.0005948543548584
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0008 0.00077295303344727
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0010 0.0010311603546143
SELECT * FROM products WHERE id = '3881'
322 0.0011 0.0010929107666016
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
323 0.0007 0.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '3881'
324 0.0004 0.00043416023254395
SELECT * FROM productcustomimages WHERE product_id = '3881'
325 0.0012 0.0012438297271729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
326 0.0005 0.00052690505981445
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0005 0.00052285194396973
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0006 0.00057578086853027
SELECT * FROM products WHERE id = '4213'
330 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
331 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '4213'
332 0.0004 0.00042295455932617
SELECT * FROM productcustomimages WHERE product_id = '4213'
333 0.0012 0.0012130737304688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
334 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
335 0.0005 0.0005030632019043
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
336 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0009 0.00093603134155273
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
338 0.0008 0.00076484680175781
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
339 0.0019 0.0018830299377441
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
340 0.0008 0.00075697898864746
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
341 0.0006 0.00060892105102539
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
342 0.0010 0.0010290145874023
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'