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.8174271583557 343 0.9936 0


No Amazon API Requests Made.


App Debug - Total Time 1.8174271583557 seconds

Number Time From Start Name Description
1 0.7392430305481 Initialise Initialise FSB Function
2 0.74944519996643 App Controller Start Start of the App controller (called before the controller of every page)
3 0.78655815124512 Start of getCategoryListByGroup Function Before first category groups query
4 0.78795099258423 After initial query Before first category groups query
5 0.78795313835144 Get Category List for Group Before the call to getCategoryList function
6 0.78795719146729 Start of GetCategoryList function Start of the function
7 0.78796100616455 Before getting categories Query to get specific category list
8 0.78975105285645 After getting categories Query to get specific category list
9 0.78975319862366 Before getting category custom Before call to function getCategoryCustom
10 0.81050610542297 After getting category custom After call to function getCategoryCustom
11 0.81051206588745 Before getting category custom Before call to function getCategoryCustom
12 0.82255005836487 After getting category custom After call to function getCategoryCustom
13 0.82255411148071 Before getting category custom Before call to function getCategoryCustom
14 0.82982420921326 After getting category custom After call to function getCategoryCustom
15 0.82982707023621 Before getting category custom Before call to function getCategoryCustom
16 0.83503413200378 After getting category custom After call to function getCategoryCustom
17 0.83503699302673 Before getting category custom Before call to function getCategoryCustom
18 0.83972120285034 After getting category custom After call to function getCategoryCustom
19 0.83972311019897 Before getting category custom Before call to function getCategoryCustom
20 0.84461903572083 After getting category custom After call to function getCategoryCustom
21 0.84462118148804 End of GetCategoryList function End of the function
22 0.84462809562683 Get Category List for Group Before the call to getCategoryList function
23 0.84463119506836 Start of GetCategoryList function Start of the function
24 0.84463405609131 Before getting categories Query to get specific category list
25 0.84557104110718 End of getCategoryListByGroup Function Before return()
26 1.4653270244598 App Controller End End of the App controller (called before the controller of every page)
27 1.4660310745239 Product Start Start of the product info controller
28 1.4857461452484 Cache file not found Starting get product details
29 1.5536131858826 Related products Start getting related products if enabled
30 1.5536150932312 Related Products Start Before the related products are found
31 1.5536170005798 Related Products Keywords Before the related product keywords are found
32 1.5536210536957 Create Keyword List Function Start of function
33 1.5537121295929 Create Keyword List Function After looping provided content - 12 keywords found
34 1.554249048233 Create Keyword List Function After looping initial keyword list - 11 keywords remaining
35 1.5542550086975 Create Keyword List Function After reducing keyword list
36 1.5542721748352 Create Keyword List Function After selecting by scoring keywords
37 1.5542759895325 Create Keyword List Function After final loop of keywords
38 1.5542781352997 Related Products Keywords After the related product keywords are found
39 1.6185681819916 Related Products End After the related products are found
40 1.6746981143951 Product End End of the product info controller (Product Info)
41 1.67715716362 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.6789441108704 Before Get Options Before the call to getOptions in the tpl class
43 1.7407200336456 After Get Options After the call to getOptions in the tpl class
44 1.7408680915833 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.7409000396729 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.7523241043091 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.7523291110992 Product Info: Before Template Display Before the template is displayed
48 1.8173890113831 Product Info: After Template Display After the template is displayed
49 1.8174080848694 Finalizing debug Before the debug is output to the page.
50 1.8174250125885 End of App This is the end of the app logging, final timestamp


Query Debug - 343 Database Queries. Total time 0.9936 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022499561309814
SELECT parameter, value FROM parameters
2 0.0064 0.0064032077789307
SELECT * FROM `bad_bots`
3 0.0005 0.00045990943908691
SET time_zone = 'Europe/London'
4 0.0019 0.0019209384918213
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0029 0.0029070377349854
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.219.88.60\";}'
6 0.0036 0.0036239624023438
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734787219'
7 0.0040 0.0040221214294434
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00079894065856934
UPDATE autorun SET lastrun = '2024-12-21 13:20:20' WHERE id = '9'
9 0.0010 0.00097298622131348
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0037 0.0036990642547607
SELECT id FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' LIMIT 1
11 0.0048 0.0047857761383057
SELECT id FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' AND hidden = 0 LIMIT 1
12 0.0050 0.0050399303436279
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0309 0.03089714050293
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00060200691223145
SELECT * FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
15 0.0014 0.0013809204101562
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0018 0.0017709732055664
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0064 0.0064041614532471
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0018 0.0017709732055664
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0014 0.0013928413391113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00049400329589844
SELECT id FROM categories WHERE parent_id = '26'
21 0.0056 0.0056490898132324
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0016 0.0016078948974609
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0015 0.0014839172363281
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0013 0.0013251304626465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00049185752868652
SELECT * FROM categorygroups WHERE id = '1'
26 0.0040 0.0040349960327148
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0008 0.00081992149353027
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00049018859863281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00056886672973633
SELECT id FROM categories WHERE parent_id = '27'
30 0.0040 0.0039551258087158
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0005 0.00051593780517578
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00051403045654297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00048995018005371
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0016260147094727
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0006 0.00062012672424316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00051617622375488
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017149448394775
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0006 0.00056815147399902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0006 0.0005950927734375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00050806999206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.0005340576171875
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00064492225646973
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0007 0.00072693824768066
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.0004420280456543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00057220458984375
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00071501731872559
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00052213668823242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0005 0.00051379203796387
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00046706199645996
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00061702728271484
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0005 0.00049185752868652
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0005 0.00046586990356445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00046992301940918
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00065398216247559
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0005 0.00051689147949219
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00047993659973145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00042104721069336
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00063204765319824
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.0004730224609375
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.0004429817199707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00047183036804199
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00079798698425293
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0005 0.00051307678222656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0006 0.00055599212646484
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00043988227844238
SELECT * FROM categorygroups WHERE id = '1'
71 0.0009 0.00092577934265137
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0042 0.0042469501495361
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0023 0.0023128986358643
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00059795379638672
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0012 0.0011861324310303
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010600090026855
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.001230001449585
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.6039 0.60391092300415
SELECT * FROM ipgeocountries WHERE INET_ATON('18.219.88.60') >= INET_ATON(ip_start) AND INET_ATON('18.219.88.60') <= INET_ATON(ip_end)
79 0.0021 0.0020508766174316
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0011579990386963
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0009 0.00091910362243652
SELECT * FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
82 0.0004 0.00043201446533203
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4556
83 0.0008 0.000762939453125
SELECT * FROM manufacturers WHERE id = '619'
84 0.0007 0.00068497657775879
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
85 0.0023 0.0023050308227539
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
86 0.0029 0.0028541088104248
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
87 0.0006 0.00061202049255371
SELECT * FROM productimages WHERE product_id = '4261' ORDER BY sortorder ASC
88 0.0007 0.00069308280944824
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
89 0.0009 0.00088286399841309
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 
90 0.0006 0.00061607360839844
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
91 0.0006 0.00061416625976562
SELECT category_id FROM products_categories WHERE product_id = '4556'
92 0.0009 0.00093317031860352
SELECT * FROM categories WHERE id = '27'
93 0.0058 0.0057799816131592
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
94 0.0011 0.0011060237884521
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00059700012207031
SELECT id FROM categories WHERE parent_id = '27'
96 0.0097 0.0096979141235352
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 
97 0.0011 0.0011200904846191
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 
98 0.0011 0.0010769367218018
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
99 0.0010 0.00096702575683594
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0009 0.00092005729675293
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
101 0.0014 0.0014400482177734
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
102 0.0030 0.002979040145874
SELECT * FROM product_image_select WHERE product_id = '4556'
103 0.0020 0.002047061920166
SELECT * FROM productcustomimages WHERE product_id = '4556'
104 0.0020 0.002004861831665
SELECT * FROM productfeeds WHERE product_id = '4556' ORDER BY item_date DESC
105 0.0035 0.0035340785980225
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
106 0.0031 0.003148078918457
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
107 0.0005 0.00047397613525391
SELECT * FROM tags WHERE id = '3966'
108 0.0011 0.0010700225830078
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
109 0.0008 0.00084495544433594
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 
110 0.0009 0.00086402893066406
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
111 0.0007 0.00071811676025391
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
112 0.0019 0.0019309520721436
SELECT * FROM productamazoncontent WHERE product_id = '4556'
113 0.0022 0.0021538734436035
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
114 0.0029 0.0029430389404297
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
115 0.0007 0.0007021427154541
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
116 0.0010 0.001011848449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
117 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0006 0.00056600570678711
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00043821334838867
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00050497055053711
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
121 0.0007 0.00065016746520996
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
122 0.0009 0.00087308883666992
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
123 0.0005 0.00054097175598145
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
124 0.0006 0.0006108283996582
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0008 0.00078105926513672
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
126 0.0007 0.00065803527832031
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
127 0.0006 0.00058794021606445
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
128 0.0093 0.0092861652374268
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
129 0.0008 0.00078582763671875
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
130 0.0007 0.00072407722473145
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
131 0.0005 0.00046300888061523
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
132 0.0006 0.00062084197998047
SELECT * FROM product_image_select WHERE product_id = '4246'
133 0.0004 0.00040698051452637
SELECT * FROM productcustomimages WHERE product_id = '4246'
134 0.0010 0.0010349750518799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
135 0.0005 0.0004889965057373
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00049304962158203
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00048208236694336
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
139 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '4256'
140 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '4256'
141 0.0011 0.001147985458374
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
142 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.00050115585327148
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
146 0.0014 0.0013890266418457
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
147 0.0010 0.00095009803771973
SELECT * FROM product_image_select WHERE product_id = '4322'
148 0.0004 0.00044584274291992
SELECT * FROM productcustomimages WHERE product_id = '4322'
149 0.0008 0.00078105926513672
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
150 0.0016 0.0015900135040283
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
151 0.0007 0.00066304206848145
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
152 0.0011 0.0011301040649414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
153 0.0004 0.00040483474731445
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00041508674621582
SELECT value FROM productattributes
                WHERE product_id = '4322'
                AND name = 'ListPriceAmount'
157 0.0007 0.00070786476135254
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
158 0.0017 0.0016598701477051
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
159 0.0007 0.00072407722473145
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
160 0.0006 0.00063300132751465
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0012 0.0012099742889404
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
162 0.0030 0.0030438899993896
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
163 0.0008 0.0007789134979248
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
164 0.0011 0.0011248588562012
SELECT * FROM product_image_select WHERE product_id = '4245'
165 0.0006 0.00055980682373047
SELECT * FROM productcustomimages WHERE product_id = '4245'
166 0.0010 0.0010030269622803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
167 0.0005 0.00052404403686523
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0005 0.00052189826965332
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0005 0.00048708915710449
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
171 0.0007 0.00066184997558594
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
172 0.0007 0.00065708160400391
SELECT * FROM product_image_select WHERE product_id = '4247'
173 0.0004 0.00041604042053223
SELECT * FROM productcustomimages WHERE product_id = '4247'
174 0.0006 0.0006101131439209
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
175 0.0013 0.0013120174407959
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
176 0.0008 0.00079607963562012
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
177 0.0010 0.0010499954223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
178 0.0004 0.00041413307189941
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00045609474182129
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00054192543029785
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00042390823364258
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
182 0.0005 0.00050497055053711
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
183 0.0008 0.0008089542388916
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
184 0.0005 0.00049090385437012
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
185 0.0006 0.00057506561279297
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0008 0.00076007843017578
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
187 0.0007 0.00067496299743652
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
188 0.0006 0.00057005882263184
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
189 0.0005 0.00052094459533691
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
190 0.0007 0.00066184997558594
SELECT * FROM product_image_select WHERE product_id = '4581'
191 0.0005 0.00048995018005371
SELECT * FROM productcustomimages WHERE product_id = '4581'
192 0.0005 0.00054097175598145
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
193 0.0007 0.00068497657775879
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
194 0.0004 0.00041294097900391
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
195 0.0009 0.0008552074432373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
196 0.0004 0.00041413307189941
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0004 0.00035285949707031
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00041699409484863
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
200 0.0005 0.00048303604125977
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
201 0.0007 0.00073003768920898
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
202 0.0004 0.00043606758117676
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
203 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0007 0.00066900253295898
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
205 0.0006 0.00055909156799316
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
206 0.0004 0.00042295455932617
SELECT id,asin FROM products WHERE parent_id = 4556
207 0.0005 0.00046610832214355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4512
208 0.0006 0.00055503845214844
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4512
209 0.0004 0.00036787986755371
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4514
210 0.0005 0.00045394897460938
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4514
211 0.0004 0.00044488906860352
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4263
212 0.0006 0.00060510635375977
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4263
213 0.0004 0.00036501884460449
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4264
214 0.0005 0.00046300888061523
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4264
215 0.0003 0.00034904479980469
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4515
216 0.0004 0.00042510032653809
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4515
217 0.0004 0.0003669261932373
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4784
218 0.0005 0.00050806999206543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4784
219 0.0003 0.00034403800964355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4785
220 0.0005 0.00046110153198242
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4785
221 0.0003 0.00034594535827637
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4786
222 0.0004 0.00044512748718262
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4786
223 0.0003 0.00034594535827637
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4787
224 0.0005 0.0004580020904541
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4787
225 0.0004 0.00035500526428223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4788
226 0.0005 0.00048398971557617
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4788
227 0.0004 0.00036501884460449
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4789
228 0.0005 0.00046205520629883
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4789
229 0.0004 0.00040006637573242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4790
230 0.0005 0.00050592422485352
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4790
231 0.0004 0.00043082237243652
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4791
232 0.0005 0.0005490779876709
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4791
233 0.0004 0.00037789344787598
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4792
234 0.0005 0.0005338191986084
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4792
235 0.0004 0.00043296813964844
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4793
236 0.0005 0.00054192543029785
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4793
237 0.0004 0.00042104721069336
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4889
238 0.0006 0.0005638599395752
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4889
239 0.0018 0.0017879009246826
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
240 0.0005 0.00052690505981445
SELECT category_id FROM products_categories WHERE product_id = '4556'
241 0.0005 0.00054812431335449
SELECT * FROM categories WHERE id = '27'
242 0.0048 0.0048208236694336
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
243 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
244 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '27'
245 0.0054 0.0054349899291992
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 
246 0.0006 0.0006411075592041
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 
247 0.0006 0.00064897537231445
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
248 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
249 0.0010 0.00099301338195801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
250 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.0004880428314209
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00039005279541016
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
254 0.0006 0.00061416625976562
SELECT * FROM products WHERE id = '4556'
255 0.0006 0.00059294700622559
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
256 0.0010 0.0010499954223633
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
257 0.0008 0.00077009201049805
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
258 0.0008 0.0007929801940918
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0009 0.00090599060058594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
260 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0005 0.00048303604125977
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
263 0.0006 0.00062084197998047
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
264 0.0006 0.00064897537231445
SELECT DISTINCT (name) FROM productoptions
265 0.0008 0.00080490112304688
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4556))
266 0.0006 0.00061511993408203
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
267 0.0017 0.0017151832580566
SELECT * FROM translationsfilter
268 0.0005 0.00050687789916992
SELECT category_id FROM products_categories WHERE product_id = '4556' AND prod_type = 'amz'
269 0.0004 0.00043201446533203
SELECT parent_id FROM categories WHERE id = '27'
270 0.0004 0.00040411949157715
SELECT * FROM categories WHERE id = '27'
271 0.0039 0.0038859844207764
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
272 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
273 0.0003 0.00034284591674805
SELECT id FROM categories WHERE parent_id = '27'
274 0.0033 0.0033199787139893
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 
275 0.0005 0.00048184394836426
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 
276 0.0005 0.00053310394287109
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
277 0.0005 0.0005190372467041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
278 0.0018 0.0017509460449219
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
279 0.0013 0.001284122467041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
280 0.0004 0.00039005279541016
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
281 0.0127 0.012665987014771
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
282 0.0018 0.0017881393432617
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
283 0.0007 0.00069403648376465
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
284 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = 1626
285 0.0007 0.00068092346191406
SELECT * FROM products WHERE id = 4041
286 0.0007 0.00069594383239746
SELECT * FROM products WHERE id = 4312
287 0.0007 0.00068807601928711
SELECT * FROM products WHERE id = 777
288 0.0008 0.00075721740722656
SELECT * FROM products WHERE id = 3881
289 0.0007 0.00066590309143066
SELECT * FROM products WHERE id = 4213
290 0.0007 0.00066614151000977
SELECT * FROM products WHERE id = '1626'
291 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
292 0.0007 0.00073909759521484
SELECT * FROM product_image_select WHERE product_id = '1626'
293 0.0004 0.00043296813964844
SELECT * FROM productcustomimages WHERE product_id = '1626'
294 0.0009 0.00094699859619141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
295 0.0006 0.00058889389038086
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0006 0.00057506561279297
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0008 0.00075793266296387
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0006 0.00058984756469727
SELECT * FROM products WHERE id = '4041'
299 0.0005 0.0004889965057373
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
300 0.0006 0.00061988830566406
SELECT * FROM product_image_select WHERE product_id = '4041'
301 0.0004 0.00042581558227539
SELECT * FROM productcustomimages WHERE product_id = '4041'
302 0.0011 0.0011110305786133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
303 0.0005 0.00054812431335449
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0005 0.00053095817565918
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = '4312'
307 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
308 0.0008 0.00076413154602051
SELECT * FROM product_image_select WHERE product_id = '4312'
309 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '4312'
310 0.0012 0.001230001449585
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
311 0.0006 0.00061488151550293
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0006 0.00063085556030273
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0009 0.00090289115905762
SELECT * FROM products WHERE id = '777'
315 0.0005 0.00048208236694336
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
316 0.0007 0.00067901611328125
SELECT * FROM product_image_select WHERE product_id = '777'
317 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '777'
318 0.0015 0.0014669895172119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
319 0.0006 0.00056815147399902
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0005 0.00047707557678223
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0007 0.00065088272094727
SELECT * FROM products WHERE id = '3881'
323 0.0008 0.00077199935913086
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
324 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '3881'
325 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '3881'
326 0.0014 0.0013751983642578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
327 0.0006 0.00059700012207031
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = '4213'
331 0.0008 0.000762939453125
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
332 0.0007 0.00065398216247559
SELECT * FROM product_image_select WHERE product_id = '4213'
333 0.0004 0.00041818618774414
SELECT * FROM productcustomimages WHERE product_id = '4213'
334 0.0013 0.0012688636779785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
335 0.0005 0.0005190372467041
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0005 0.00054311752319336
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0021 0.0021040439605713
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
339 0.0010 0.00096416473388672
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
340 0.0029 0.0028951168060303
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
341 0.0017 0.0017011165618896
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
342 0.0007 0.00071287155151367
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
343 0.0010 0.0009760856628418
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'