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.4063110351562 347 1.1522 0


No Amazon API Requests Made.


App Debug - Total Time 1.4063110351562 seconds

Number Time From Start Name Description
1 0.25117897987366 Initialise Initialise FSB Function
2 0.25510311126709 App Controller Start Start of the App controller (called before the controller of every page)
3 0.30448007583618 Start of getCategoryListByGroup Function Before first category groups query
4 0.30498194694519 After initial query Before first category groups query
5 0.30498313903809 Get Category List for Group Before the call to getCategoryList function
6 0.30498600006104 Start of GetCategoryList function Start of the function
7 0.30499005317688 Before getting categories Query to get specific category list
8 0.3056640625 After getting categories Query to get specific category list
9 0.30566501617432 Before getting category custom Before call to function getCategoryCustom
10 0.32457613945007 After getting category custom After call to function getCategoryCustom
11 0.32457804679871 Before getting category custom Before call to function getCategoryCustom
12 0.33691811561584 After getting category custom After call to function getCategoryCustom
13 0.33692002296448 Before getting category custom Before call to function getCategoryCustom
14 0.34415006637573 After getting category custom After call to function getCategoryCustom
15 0.34415197372437 Before getting category custom Before call to function getCategoryCustom
16 0.34841895103455 After getting category custom After call to function getCategoryCustom
17 0.34842109680176 Before getting category custom Before call to function getCategoryCustom
18 0.35290908813477 After getting category custom After call to function getCategoryCustom
19 0.3529109954834 Before getting category custom Before call to function getCategoryCustom
20 0.35863995552063 After getting category custom After call to function getCategoryCustom
21 0.35864305496216 End of GetCategoryList function End of the function
22 0.35864901542664 Get Category List for Group Before the call to getCategoryList function
23 0.35865092277527 Start of GetCategoryList function Start of the function
24 0.35865211486816 Before getting categories Query to get specific category list
25 0.35911512374878 End of getCategoryListByGroup Function Before return()
26 1.2015011310577 App Controller End End of the App controller (called before the controller of every page)
27 1.2018301486969 Product Start Start of the product info controller
28 1.2031979560852 Cache file not found Starting get product details
29 1.2398850917816 Related products Start getting related products if enabled
30 1.2398850917816 Related Products Start Before the related products are found
31 1.2398860454559 Related Products Keywords Before the related product keywords are found
32 1.2398879528046 Create Keyword List Function Start of function
33 1.2399039268494 Create Keyword List Function After looping provided content - 12 keywords found
34 1.2401180267334 Create Keyword List Function After looping initial keyword list - 11 keywords remaining
35 1.2401211261749 Create Keyword List Function After reducing keyword list
36 1.2401311397552 Create Keyword List Function After selecting by scoring keywords
37 1.2401320934296 Create Keyword List Function After final loop of keywords
38 1.2401330471039 Related Products Keywords After the related product keywords are found
39 1.2971720695496 Related Products End After the related products are found
40 1.3456430435181 Product End End of the product info controller (Product Info)
41 1.346529006958 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3474540710449 Before Get Options Before the call to getOptions in the tpl class
43 1.3955299854279 After Get Options After the call to getOptions in the tpl class
44 1.395604133606 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3956251144409 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3986761569977 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3986780643463 Product Info: Before Template Display Before the template is displayed
48 1.4062950611115 Product Info: After Template Display After the template is displayed
49 1.4063041210175 Finalizing debug Before the debug is output to the page.
50 1.4063110351562 End of App This is the end of the app logging, final timestamp


Query Debug - 347 Database Queries. Total time 1.1522 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0026290416717529
SELECT parameter, value FROM parameters
2 0.0042 0.0041580200195312
SELECT * FROM `bad_bots`
3 0.0003 0.00033998489379883
SET time_zone = 'Europe/London'
4 0.0006 0.00059318542480469
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0020709037780762
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.139.59.149\";}'
6 0.0018 0.001802921295166
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743756083'
7 0.0022 0.0022120475769043
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00053691864013672
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0021 0.0021188259124756
SELECT id FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' LIMIT 1
10 0.0008 0.00075602531433105
SELECT id FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882' AND hidden = 0 LIMIT 1
11 0.0030 0.0029830932617188
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0454 0.045408964157104
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00063514709472656
SELECT * FROM pages WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
14 0.0005 0.00049114227294922
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00065994262695312
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0077 0.0076689720153809
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.00062394142150879
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.0004 0.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00045919418334961
SELECT id FROM categories WHERE parent_id = '26'
20 0.0076 0.0075509548187256
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.0006 0.00057697296142578
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.00056695938110352
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.00052309036254883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00041699409484863
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0044481754302979
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00053286552429199
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.0004 0.00037598609924316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00043988227844238
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.0045771598815918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00048494338989258
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.00049209594726562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016791820526123
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.00056290626525879
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.0003821849822998
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00042009353637695
SELECT id FROM categories WHERE parent_id = '28'
38 0.0022 0.002173900604248
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.0006 0.00058817863464355
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.0005 0.00049400329589844
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.00049090385437012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00037312507629395
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00056195259094238
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.00046086311340332
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00037479400634766
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00039505958557129
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.0006411075592041
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.00045609474182129
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.00048112869262695
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.0004 0.00044894218444824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00040102005004883
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056815147399902
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.0004 0.00043702125549316
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.00039505958557129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037598609924316
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00067710876464844
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0005 0.00048995018005371
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.0006 0.00056004524230957
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.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00043106079101562
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00060081481933594
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.00046491622924805
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00033807754516602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00036907196044922
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00073003768920898
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.0004 0.00042605400085449
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.0007 0.00071811676025391
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.0016 0.0015869140625
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0004270076751709
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00045490264892578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0015530586242676
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0023 0.0023369789123535
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059294700622559
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.0018 0.001849889755249
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0015 0.0014660358428955
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.00088691711425781
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8306 0.83057403564453
SELECT * FROM ipgeocountries WHERE INET_ATON('3.139.59.149') >= INET_ATON(ip_start) AND INET_ATON('3.139.59.149') <= INET_ATON(ip_end)
78 0.0010 0.0010290145874023
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00041890144348145
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00053119659423828
SELECT * FROM products WHERE pagename = 'vivaraise-tapis-de-bain-etia-333538882'
81 0.0004 0.00041794776916504
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4556
82 0.0005 0.00052213668823242
SELECT * FROM manufacturers WHERE id = '619'
83 0.0005 0.00051689147949219
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
84 0.0004 0.00044798851013184
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '619' LIMIT 1
85 0.0008 0.00083613395690918
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '619' ORDER BY RAND() LIMIT 1
86 0.0005 0.00047111511230469
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
87 0.0005 0.00047612190246582
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '619'
88 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '619'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00033903121948242
SELECT * FROM manufacturerimages WHERE manufacturer_id = '619'
90 0.0006 0.0005791187286377
SELECT category_id FROM products_categories WHERE product_id = '4556'
91 0.0004 0.00044703483581543
SELECT * FROM categories WHERE id = '27'
92 0.0038 0.0038220882415771
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.0004 0.00044608116149902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00037980079650879
SELECT id FROM categories WHERE parent_id = '27'
95 0.0036 0.0036270618438721
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.0006 0.0006110668182373
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.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
98 0.0005 0.00052785873413086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
100 0.0007 0.00073814392089844
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.0006 0.00058698654174805
SELECT * FROM product_image_select WHERE product_id = '4556'
102 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '4556'
103 0.0004 0.00040698051452637
SELECT * FROM productfeeds WHERE product_id = '4556' ORDER BY item_date DESC
104 0.0007 0.0007328987121582
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.0006 0.00058603286743164
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.0003 0.0002901554107666
SELECT * FROM tags WHERE id = '938'
107 0.0007 0.00066614151000977
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0006 0.00055694580078125
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '938'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0006 0.00059390068054199
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '938' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0005 0.00050902366638184
SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
111 0.0004 0.00036883354187012
SELECT * FROM tags WHERE id = '58'
112 0.0017 0.0017340183258057
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
113 0.0018 0.0017738342285156
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
114 0.0018 0.0017719268798828
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
116 0.0005 0.00045680999755859
SELECT * FROM productamazoncontent WHERE product_id = '4556'
117 0.0006 0.00057196617126465
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
118 0.0009 0.00086498260498047
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
119 0.0004 0.00043392181396484
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
120 0.0008 0.000762939453125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
121 0.0004 0.00035285949707031
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
124 0.0004 0.00035214424133301
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
125 0.0005 0.00045204162597656
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
126 0.0009 0.00086688995361328
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
127 0.0005 0.00047588348388672
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
128 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0007 0.00070285797119141
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
130 0.0006 0.00060606002807617
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
131 0.0005 0.00047993659973145
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
132 0.0093 0.0093169212341309
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
133 0.0006 0.00055909156799316
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
134 0.0005 0.00052595138549805
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
135 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
136 0.0006 0.00057101249694824
SELECT * FROM product_image_select WHERE product_id = '4245'
137 0.0004 0.00043606758117676
SELECT * FROM productcustomimages WHERE product_id = '4245'
138 0.0010 0.00099015235900879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
139 0.0005 0.00048589706420898
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0004 0.00043606758117676
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
143 0.0006 0.0005640983581543
SELECT * FROM product_image_select WHERE product_id = '4256'
144 0.0004 0.00035214424133301
SELECT * FROM productcustomimages WHERE product_id = '4256'
145 0.0012 0.0011768341064453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
146 0.0005 0.0004889965057373
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
150 0.0006 0.00055885314941406
SELECT * FROM product_image_select WHERE product_id = '4246'
151 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '4246'
152 0.0010 0.0009911060333252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
153 0.0004 0.00042510032653809
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0005 0.00050878524780273
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
157 0.0006 0.00060606002807617
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
158 0.0007 0.00065112113952637
SELECT * FROM product_image_select WHERE product_id = '4247'
159 0.0004 0.00035786628723145
SELECT * FROM productcustomimages WHERE product_id = '4247'
160 0.0006 0.00057816505432129
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
161 0.0007 0.00074601173400879
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
162 0.0004 0.0004420280456543
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
163 0.0008 0.00078177452087402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
164 0.0004 0.00040292739868164
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0004 0.00035190582275391
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
167 0.0004 0.0003960132598877
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
168 0.0005 0.00049090385437012
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
169 0.0008 0.00079703330993652
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
170 0.0004 0.00044393539428711
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
171 0.0006 0.00057506561279297
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0008 0.00078797340393066
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
173 0.0005 0.00054001808166504
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
174 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
175 0.0006 0.0005650520324707
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
176 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '4581'
177 0.0005 0.00046110153198242
SELECT * FROM productcustomimages WHERE product_id = '4581'
178 0.0006 0.0005950927734375
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
179 0.0007 0.00073099136352539
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
180 0.0004 0.00043296813964844
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
181 0.0008 0.00081300735473633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
182 0.0004 0.00039815902709961
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00036501884460449
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00036811828613281
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
186 0.0004 0.00041484832763672
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
187 0.0007 0.00069308280944824
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
188 0.0004 0.00041794776916504
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
189 0.0005 0.00053620338439941
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0007 0.00070405006408691
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
191 0.0006 0.00057196617126465
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
192 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
193 0.0010 0.0010151863098145
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
194 0.0005 0.00054311752319336
SELECT * FROM product_image_select WHERE product_id = '4322'
195 0.0004 0.00039410591125488
SELECT * FROM productcustomimages WHERE product_id = '4322'
196 0.0008 0.00079011917114258
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
197 0.0015 0.0015430450439453
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
198 0.0006 0.00060415267944336
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
199 0.0011 0.0011110305786133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
200 0.0003 0.00034022331237793
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00033283233642578
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
203 0.0004 0.0003669261932373
SELECT value FROM productattributes
                WHERE product_id = '4322'
                AND name = 'ListPriceAmount'
204 0.0006 0.00061202049255371
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
205 0.0015 0.0015208721160889
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
206 0.0006 0.00059700012207031
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
207 0.0006 0.00057005882263184
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0011 0.0010969638824463
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
209 0.0029 0.002924919128418
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
210 0.0004 0.00038504600524902
SELECT id,asin FROM products WHERE parent_id = 4556
211 0.0004 0.00044393539428711
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4512
212 0.0005 0.00047111511230469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4512
213 0.0003 0.00034594535827637
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4514
214 0.0004 0.00040888786315918
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4514
215 0.0003 0.00032806396484375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4263
216 0.0004 0.00041699409484863
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4263
217 0.0003 0.00029301643371582
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4264
218 0.0004 0.00040411949157715
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4264
219 0.0004 0.00036001205444336
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4515
220 0.0004 0.00043201446533203
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4515
221 0.0003 0.00033903121948242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4784
222 0.0004 0.0003969669342041
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4784
223 0.0003 0.00032186508178711
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4785
224 0.0004 0.00041389465332031
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4785
225 0.0003 0.00030612945556641
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4786
226 0.0004 0.00042295455932617
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4786
227 0.0003 0.00030088424682617
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4787
228 0.0004 0.00039505958557129
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4787
229 0.0003 0.00030899047851562
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4788
230 0.0004 0.00040578842163086
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4788
231 0.0003 0.00033092498779297
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4789
232 0.0004 0.00040602684020996
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4789
233 0.0003 0.00034785270690918
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4790
234 0.0004 0.00039005279541016
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4790
235 0.0003 0.0002901554107666
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4791
236 0.0004 0.00042891502380371
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4791
237 0.0003 0.00030899047851562
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4792
238 0.0004 0.00040411949157715
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4792
239 0.0004 0.00040006637573242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4793
240 0.0004 0.00044989585876465
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4793
241 0.0003 0.00029277801513672
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4889
242 0.0004 0.00042581558227539
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4889
243 0.0004 0.00043296813964844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
244 0.0004 0.00044703483581543
SELECT category_id FROM products_categories WHERE product_id = '4556'
245 0.0004 0.0004279613494873
SELECT * FROM categories WHERE id = '27'
246 0.0039 0.0039188861846924
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
247 0.0004 0.00043511390686035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
248 0.0003 0.00034999847412109
SELECT id FROM categories WHERE parent_id = '27'
249 0.0038 0.0038070678710938
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
250 0.0005 0.00051999092102051
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
251 0.0005 0.00051498413085938
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
252 0.0005 0.00046515464782715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
253 0.0008 0.00084400177001953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
254 0.0004 0.00044584274291992
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0004 0.00037717819213867
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0003 0.00034594535827637
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
257 0.0004 0.00039911270141602
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
258 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = '4556'
259 0.0005 0.00048184394836426
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
260 0.0009 0.00086307525634766
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
261 0.0005 0.00048708915710449
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
262 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0007 0.00069999694824219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
264 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
267 0.0004 0.00037598609924316
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
268 0.0005 0.00053000450134277
SELECT DISTINCT (name) FROM productoptions
269 0.0006 0.00063800811767578
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4556))
270 0.0005 0.00051283836364746
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
271 0.0016 0.0015609264373779
SELECT * FROM translationsfilter
272 0.0005 0.00049495697021484
SELECT category_id FROM products_categories WHERE product_id = '4556' AND prod_type = 'amz'
273 0.0004 0.00044083595275879
SELECT parent_id FROM categories WHERE id = '27'
274 0.0003 0.00031185150146484
SELECT * FROM categories WHERE id = '27'
275 0.0039 0.0039379596710205
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
276 0.0004 0.00040292739868164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
277 0.0003 0.00031709671020508
SELECT id FROM categories WHERE parent_id = '27'
278 0.0063 0.0062739849090576
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
279 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
280 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
281 0.0007 0.00066399574279785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
282 0.0006 0.00059199333190918
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
283 0.0005 0.00052285194396973
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
284 0.0004 0.00036382675170898
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
285 0.0138 0.013762950897217
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
286 0.0007 0.00073814392089844
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
287 0.0008 0.00079512596130371
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
288 0.0005 0.00053215026855469
SELECT * FROM products WHERE id = 1626
289 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = 4041
290 0.0004 0.00035309791564941
SELECT * FROM products WHERE id = 4312
291 0.0004 0.00038886070251465
SELECT * FROM products WHERE id = 777
292 0.0005 0.00052785873413086
SELECT * FROM products WHERE id = 3881
293 0.0004 0.00044512748718262
SELECT * FROM products WHERE id = 4213
294 0.0005 0.00052285194396973
SELECT * FROM products WHERE id = '1626'
295 0.0005 0.00051689147949219
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
296 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '1626'
297 0.0004 0.00040078163146973
SELECT * FROM productcustomimages WHERE product_id = '1626'
298 0.0009 0.00088882446289062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
299 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0004 0.00039577484130859
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = '4041'
303 0.0004 0.00044488906860352
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
304 0.0006 0.00057101249694824
SELECT * FROM product_image_select WHERE product_id = '4041'
305 0.0004 0.00036883354187012
SELECT * FROM productcustomimages WHERE product_id = '4041'
306 0.0011 0.0011398792266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
307 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0005 0.0005028247833252
SELECT * FROM products WHERE id = '4312'
311 0.0004 0.00043797492980957
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
312 0.0006 0.00058197975158691
SELECT * FROM product_image_select WHERE product_id = '4312'
313 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '4312'
314 0.0011 0.0011050701141357
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
315 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0005 0.00048589706420898
SELECT * FROM products WHERE id = '777'
319 0.0005 0.00046682357788086
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
320 0.0006 0.00059103965759277
SELECT * FROM product_image_select WHERE product_id = '777'
321 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '777'
322 0.0011 0.0011138916015625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
323 0.0005 0.00046181678771973
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0005 0.00047087669372559
SELECT * FROM products WHERE id = '3881'
327 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
328 0.0006 0.00055408477783203
SELECT * FROM product_image_select WHERE product_id = '3881'
329 0.0004 0.00044488906860352
SELECT * FROM productcustomimages WHERE product_id = '3881'
330 0.0011 0.0010991096496582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
331 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0004 0.00044012069702148
SELECT * FROM products WHERE id = '4213'
335 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
336 0.0006 0.0006108283996582
SELECT * FROM product_image_select WHERE product_id = '4213'
337 0.0004 0.00037097930908203
SELECT * FROM productcustomimages WHERE product_id = '4213'
338 0.0011 0.0011119842529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
339 0.0004 0.00042200088500977
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0003 0.00034284591674805
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0007 0.00070881843566895
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
343 0.0006 0.00060081481933594
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
344 0.0013 0.001317024230957
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
345 0.0005 0.00054192543029785
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0005 0.00045895576477051
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347 0.0005 0.00051116943359375
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'