0
  1. My Store
  2. Tags
  3. Palais Des Thés

Palais Des Thés

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3534209728241 352 0.4255 0


No Amazon API Requests Made.


App Debug - Total Time 1.3534209728241 seconds

Number Time From Start Name Description
1 0.66287302970886 Initialise Initialise FSB Function
2 0.6719172000885 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67639708518982 Start of getCategoryListByGroup Function Before first category groups query
4 0.67739319801331 After initial query Before first category groups query
5 0.67739510536194 Get Category List for Group Before the call to getCategoryList function
6 0.6774001121521 Start of GetCategoryList function Start of the function
7 0.67740511894226 Before getting categories Query to get specific category list
8 0.6784200668335 After getting categories Query to get specific category list
9 0.67842197418213 Before getting category custom Before call to function getCategoryCustom
10 0.68619513511658 After getting category custom After call to function getCategoryCustom
11 0.68620109558105 Before getting category custom Before call to function getCategoryCustom
12 0.6943039894104 After getting category custom After call to function getCategoryCustom
13 0.69431018829346 Before getting category custom Before call to function getCategoryCustom
14 0.70385718345642 After getting category custom After call to function getCategoryCustom
15 0.7038631439209 Before getting category custom Before call to function getCategoryCustom
16 0.71258807182312 After getting category custom After call to function getCategoryCustom
17 0.7125940322876 Before getting category custom Before call to function getCategoryCustom
18 0.72071099281311 After getting category custom After call to function getCategoryCustom
19 0.72071814537048 Before getting category custom Before call to function getCategoryCustom
20 0.73094916343689 After getting category custom After call to function getCategoryCustom
21 0.73095607757568 End of GetCategoryList function End of the function
22 0.73096919059753 Get Category List for Group Before the call to getCategoryList function
23 0.7309741973877 Start of GetCategoryList function Start of the function
24 0.73097920417786 Before getting categories Query to get specific category list
25 0.73211812973022 End of getCategoryListByGroup Function Before return()
26 0.82332110404968 App Controller End End of the App controller (called before the controller of every page)
27 1.0460531711578 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.0476040840149 Before Get Options Before the call to getOptions in the tpl class
29 1.1178011894226 After Get Options After the call to getOptions in the tpl class
30 1.117858171463 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.3533971309662 Finalizing debug Before the debug is output to the page.
32 1.3534190654755 End of App This is the end of the app logging, final timestamp


Query Debug - 352 Database Queries. Total time 0.4255 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00093889236450195 
SELECT parameter, value FROM parameters
2 0.0020 0.0020260810852051 
SELECT * FROM `bad_bots`
3 0.0006 0.0005950927734375 
SET time_zone = 'Europe/London'
4 0.0005 0.00054287910461426 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.0012028217315674 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.191.22.34\";}'
6 0.0011 0.0010919570922852 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1716083392'
7 0.0016 0.0016229152679443 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010740756988525 
UPDATE autorun SET lastrun = '2024-05-19 01:49:53' WHERE id = '13'
9 0.0007 0.00073814392089844 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0007 0.00069284439086914 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0019 0.0018510818481445 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0007 0.00067877769470215 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0007 0.00069403648376465 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0007 0.00071382522583008 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0007 0.00072002410888672 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0007 0.00074887275695801 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0009 0.00092196464538574 
SELECT id FROM tags WHERE pagename = 'palais-des-thes' LIMIT 1
18 0.0013 0.001305103302002 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0014 0.0013880729675293 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0009 0.00089502334594727 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0010 0.0009758472442627 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0010 0.00098299980163574 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0009 0.00094103813171387 
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
24 0.0009 0.00089502334594727 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0010 0.00096893310546875 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0008 0.00080108642578125 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0008 0.00083184242248535 
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
28 0.0007 0.0007469654083252 
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
29 0.0008 0.00077700614929199 
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
30 0.0008 0.00075507164001465 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0009 0.00087213516235352 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0009 0.00088405609130859 
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
33 0.0010 0.00097012519836426 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0009 0.00089406967163086 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0010 0.00097298622131348 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0009 0.00087785720825195 
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
37 0.0008 0.00081920623779297 
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
38 0.0008 0.00081396102905273 
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
39 0.0008 0.00081682205200195 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0009 0.00088000297546387 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0010 0.00097084045410156 
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
42 0.0009 0.00093507766723633 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0009 0.00093698501586914 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0010 0.0010049343109131 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0011 0.0010979175567627 
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
46 0.0011 0.0010960102081299 
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
47 0.0010 0.0010020732879639 
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
48 0.0013 0.0012581348419189 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0011 0.0010550022125244 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0009 0.00089192390441895 
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
51 0.0009 0.00091385841369629 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
52 0.0011 0.0010559558868408 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0009 0.00093913078308105 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0009 0.00087118148803711 
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
55 0.0011 0.0010671615600586 
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
56 0.0009 0.00088095664978027 
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
57 0.0010 0.00099301338195801 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0009 0.00094103813171387 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0010 0.00096511840820312 
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
60 0.0012 0.0012459754943848 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0009 0.00093483924865723 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0009 0.00087904930114746 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0008 0.00081300735473633 
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
64 0.0008 0.00083708763122559 
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
65 0.0008 0.00077295303344727 
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
66 0.0008 0.00075602531433105 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0007 0.00073504447937012 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0008 0.00075888633728027 
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
69 0.0008 0.00079584121704102 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0009 0.00091886520385742 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0012 0.001230001449585 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0010 0.0010108947753906 
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
73 0.0010 0.0010311603546143 
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
74 0.0011 0.0011439323425293 
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
75 0.0015 0.0014991760253906 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0017 0.0016651153564453 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0011 0.0010740756988525 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0015 0.001471996307373 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0011 0.001068115234375 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0012 0.001166820526123 
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
81 0.0012 0.0011780261993408 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0011 0.0010650157928467 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0013 0.0013000965118408 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.0787 0.07865309715271 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.22.34') >= INET_ATON(ip_start) AND INET_ATON('18.191.22.34') <= INET_ATON(ip_end)
85 0.0008 0.00078916549682617 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0006 0.00055789947509766 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0010 0.0010049343109131 
SELECT * FROM tags WHERE pagename = 'palais-des-thes'
88 0.0011 0.0010960102081299 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0009 0.00093817710876465 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0008 0.00077390670776367 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0008 0.00075292587280273 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0009 0.00085186958312988 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0008 0.00082492828369141 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0023 0.002263069152832 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '529' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0031 0.0031177997589111 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '529' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
96 0.0009 0.00085091590881348 
SELECT * FROM productimages WHERE product_id = '3839' ORDER BY sortorder ASC
97 0.0015 0.0014760494232178 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3839' AND p.id = pi.product_id ORDER BY pi.sortorder
98 0.0009 0.00092601776123047 
SELECT * FROM product_image_select WHERE product_id = '3839'
99 0.0009 0.0009310245513916 
SELECT * FROM productcustomimages WHERE product_id = '3839'
100 0.0016 0.0016069412231445 
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 = '3839'
                GROUP BY o.product_id
101 0.0015 0.0015239715576172 
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     = '3839'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
102 0.0011 0.0011270046234131 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3839
103 0.0007 0.00074481964111328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3839' AND a.name = n.originalname
104 0.0008 0.00076413154602051 
SELECT * FROM productoffers WHERE product_id = '3839' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0009 0.00086212158203125 
SELECT * FROM productoffers
                WHERE product_id = '3839' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0008 0.00081181526184082 
SELECT * FROM productoffers
                WHERE product_id = 3839
                ORDER BY price ASC LIMIT 1
107 0.0007 0.00068306922912598 
SELECT value FROM productattributes
                WHERE product_id = '3839'
                AND name = 'ListPriceAmount'
108 0.0007 0.00067782402038574 
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 = '3839'
                GROUP BY o.product_id
109 0.0007 0.00067496299743652 
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     = '3839'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0007 0.00071001052856445 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3839
111 0.0007 0.00071907043457031 
SELECT value FROM productattributes WHERE product_id = '3839' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0016 0.0015790462493896 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3839'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
113 0.0009 0.00086402893066406 
SELECT * FROM productimages WHERE product_id = '3707' ORDER BY sortorder ASC
114 0.0017 0.0016570091247559 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3707' AND p.id = pi.product_id ORDER BY pi.sortorder
115 0.0008 0.00077700614929199 
SELECT * FROM product_image_select WHERE product_id = '3707'
116 0.0007 0.00071096420288086 
SELECT * FROM productcustomimages WHERE product_id = '3707'
117 0.0016 0.0015690326690674 
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 = '3707'
                GROUP BY o.product_id
118 0.0022 0.0021591186523438 
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     = '3707'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
119 0.0012 0.0012400150299072 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3707
120 0.0008 0.00083088874816895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3707' AND a.name = n.originalname
121 0.0009 0.00091195106506348 
SELECT * FROM productoffers WHERE product_id = '3707' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0008 0.00081682205200195 
SELECT * FROM productoffers
                WHERE product_id = '3707' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0008 0.00079607963562012 
SELECT * FROM productoffers
                WHERE product_id = 3707
                ORDER BY price ASC LIMIT 1
124 0.0007 0.00074887275695801 
SELECT value FROM productattributes
                WHERE product_id = '3707'
                AND name = 'ListPriceAmount'
125 0.0007 0.00069904327392578 
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 = '3707'
                GROUP BY o.product_id
126 0.0007 0.0007328987121582 
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     = '3707'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0008 0.00083017349243164 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3707
128 0.0009 0.00088095664978027 
SELECT value FROM productattributes WHERE product_id = '3707' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0017 0.0016589164733887 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3707'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
130 0.0008 0.00080299377441406 
SELECT * FROM productimages WHERE product_id = '3709' ORDER BY sortorder ASC
131 0.0007 0.00073790550231934 
SELECT * FROM product_image_select WHERE product_id = '3709'
132 0.0008 0.00076603889465332 
SELECT * FROM productcustomimages WHERE product_id = '3709'
133 0.0008 0.00081300735473633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3709' AND a.name = n.originalname
134 0.0008 0.0008089542388916 
SELECT * FROM productoffers WHERE product_id = '3709' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0008 0.00081992149353027 
SELECT * FROM productoffers
                WHERE product_id = '3709' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0008 0.00078082084655762 
SELECT * FROM productoffers
                WHERE product_id = 3709
                ORDER BY price ASC LIMIT 1
137 0.0008 0.00076699256896973 
SELECT value FROM productattributes
                WHERE product_id = '3709'
                AND name = 'ListPriceAmount'
138 0.0008 0.00080204010009766 
SELECT value FROM productattributes WHERE product_id = '3709' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0008 0.00077700614929199 
SELECT * FROM productimages WHERE product_id = '3705' ORDER BY sortorder ASC
140 0.0016 0.001600980758667 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3705' AND p.id = pi.product_id ORDER BY pi.sortorder
141 0.0007 0.00068306922912598 
SELECT * FROM product_image_select WHERE product_id = '3705'
142 0.0007 0.00067996978759766 
SELECT * FROM productcustomimages WHERE product_id = '3705'
143 0.0014 0.001370906829834 
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 = '3705'
                GROUP BY o.product_id
144 0.0019 0.0019130706787109 
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     = '3705'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
145 0.0013 0.0012509822845459 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3705
146 0.0009 0.00089097023010254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3705' AND a.name = n.originalname
147 0.0008 0.0008399486541748 
SELECT * FROM productoffers WHERE product_id = '3705' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0007 0.00069594383239746 
SELECT * FROM productoffers
                WHERE product_id = '3705' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0007 0.00070309638977051 
SELECT * FROM productoffers
                WHERE product_id = 3705
                ORDER BY price ASC LIMIT 1
150 0.0007 0.00068879127502441 
SELECT value FROM productattributes
                WHERE product_id = '3705'
                AND name = 'ListPriceAmount'
151 0.0008 0.00075602531433105 
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 = '3705'
                GROUP BY o.product_id
152 0.0008 0.00080299377441406 
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     = '3705'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
153 0.0008 0.00081515312194824 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3705
154 0.0008 0.00082182884216309 
SELECT value FROM productattributes WHERE product_id = '3705' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0015 0.0014629364013672 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3705'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
156 0.0014 0.0014219284057617 
SELECT * FROM products WHERE parent_id = '3705'
157 0.0008 0.0008089542388916 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4026' AND a.name = n.originalname
158 0.0008 0.00082182884216309 
SELECT * FROM productoffers WHERE product_id = '4026' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0008 0.00078082084655762 
SELECT * FROM productoffers
                WHERE product_id = '4026' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0008 0.0008080005645752 
SELECT * FROM productimages WHERE product_id = '3594' ORDER BY sortorder ASC
161 0.0016 0.0016250610351562 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3594' AND p.id = pi.product_id ORDER BY pi.sortorder
162 0.0009 0.00086092948913574 
SELECT * FROM product_image_select WHERE product_id = '3594'
163 0.0009 0.00086402893066406 
SELECT * FROM productcustomimages WHERE product_id = '3594'
164 0.0015 0.0014948844909668 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3594'
                GROUP BY o.product_id
165 0.0017 0.0017120838165283 
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     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0012 0.0011708736419678 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3594
167 0.0009 0.00092887878417969 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3594' AND a.name = n.originalname
168 0.0009 0.000885009765625 
SELECT * FROM productoffers WHERE product_id = '3594' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0008 0.00078511238098145 
SELECT * FROM productoffers
                WHERE product_id = '3594' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0007 0.00072097778320312 
SELECT * FROM productoffers
                WHERE product_id = 3594
                ORDER BY price ASC LIMIT 1
171 0.0007 0.00072908401489258 
SELECT value FROM productattributes
                WHERE product_id = '3594'
                AND name = 'ListPriceAmount'
172 0.0008 0.00075793266296387 
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 = '3594'
                GROUP BY o.product_id
173 0.0006 0.00064277648925781 
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     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0007 0.00073504447937012 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3594
175 0.0007 0.00071883201599121 
SELECT value FROM productattributes WHERE product_id = '3594' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0020 0.0019559860229492 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3594'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
177 0.0017 0.0016911029815674 
SELECT * FROM products WHERE parent_id = '3594'
178 0.0011 0.0011498928070068 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3969' AND a.name = n.originalname
179 0.0009 0.00087094306945801 
SELECT * FROM productoffers WHERE product_id = '3969' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0008 0.00083613395690918 
SELECT * FROM productoffers
                WHERE product_id = '3969' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0009 0.00089812278747559 
SELECT * FROM productoffers
                WHERE product_id = 3969
                ORDER BY price ASC LIMIT 1
182 0.0009 0.00092506408691406 
SELECT value FROM productattributes
                WHERE product_id = '3969'
                AND name = 'ListPriceAmount'
183 0.0009 0.00089192390441895 
SELECT * FROM productimages WHERE product_id = '946' ORDER BY sortorder ASC
184 0.0009 0.00092577934265137 
SELECT * FROM product_image_select WHERE product_id = '946'
185 0.0009 0.0009160041809082 
SELECT * FROM productcustomimages WHERE product_id = '946'
186 0.0010 0.00098299980163574 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '946' AND a.name = n.originalname
187 0.0010 0.0010139942169189 
SELECT * FROM productoffers WHERE product_id = '946' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0012 0.0011920928955078 
SELECT * FROM productoffers
                WHERE product_id = '946' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0009 0.00094795227050781 
SELECT * FROM productoffers
                WHERE product_id = 946
                ORDER BY price ASC LIMIT 1
190 0.0009 0.00088715553283691 
SELECT value FROM productattributes
                WHERE product_id = '946'
                AND name = 'ListPriceAmount'
191 0.0009 0.00087308883666992 
SELECT value FROM productattributes WHERE product_id = '946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0009 0.00089788436889648 
SELECT * FROM productimages WHERE product_id = '1400' ORDER BY sortorder ASC
193 0.0009 0.00087904930114746 
SELECT * FROM product_image_select WHERE product_id = '1400'
194 0.0007 0.00070309638977051 
SELECT * FROM productcustomimages WHERE product_id = '1400'
195 0.0008 0.00083589553833008 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname
196 0.0009 0.00085806846618652 
SELECT * FROM productoffers WHERE product_id = '1400' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0009 0.00093388557434082 
SELECT * FROM productoffers
                WHERE product_id = '1400' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0008 0.00081110000610352 
SELECT * FROM productoffers
                WHERE product_id = 1400
                ORDER BY price ASC LIMIT 1
199 0.0009 0.00094890594482422 
SELECT value FROM productattributes
                WHERE product_id = '1400'
                AND name = 'ListPriceAmount'
200 0.0008 0.00077700614929199 
SELECT value FROM productattributes WHERE product_id = '1400' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0008 0.00077199935913086 
SELECT * FROM productimages WHERE product_id = '3579' ORDER BY sortorder ASC
202 0.0017 0.0016648769378662 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3579' AND p.id = pi.product_id ORDER BY pi.sortorder
203 0.0010 0.0009911060333252 
SELECT * FROM product_image_select WHERE product_id = '3579'
204 0.0010 0.00096487998962402 
SELECT * FROM productcustomimages WHERE product_id = '3579'
205 0.0017 0.001708984375 
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 = '3579'
                GROUP BY o.product_id
206 0.0021 0.0020740032196045 
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     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
207 0.0016 0.0015969276428223 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
208 0.0011 0.0010578632354736 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname
209 0.0012 0.0012269020080566 
SELECT * FROM productoffers WHERE product_id = '3579' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0011 0.0011458396911621 
SELECT * FROM productoffers
                WHERE product_id = '3579' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0009 0.00089716911315918 
SELECT * FROM productoffers
                WHERE product_id = 3579
                ORDER BY price ASC LIMIT 1
212 0.0007 0.0007469654083252 
SELECT value FROM productattributes
                WHERE product_id = '3579'
                AND name = 'ListPriceAmount'
213 0.0008 0.00080585479736328 
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 = '3579'
                GROUP BY o.product_id
214 0.0006 0.00064706802368164 
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     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0006 0.00061202049255371 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
216 0.0007 0.00069212913513184 
SELECT value FROM productattributes WHERE product_id = '3579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0014 0.0013689994812012 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3579'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
218 0.0007 0.00066518783569336 
SELECT * FROM productimages WHERE product_id = '3702' ORDER BY sortorder ASC
219 0.0006 0.00064206123352051 
SELECT * FROM product_image_select WHERE product_id = '3702'
220 0.0006 0.00064206123352051 
SELECT * FROM productcustomimages WHERE product_id = '3702'
221 0.0008 0.00078392028808594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3702' AND a.name = n.originalname
222 0.0009 0.00087404251098633 
SELECT * FROM productoffers WHERE product_id = '3702' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0010 0.0010180473327637 
SELECT * FROM productoffers
                WHERE product_id = '3702' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0008 0.00083494186401367 
SELECT * FROM productoffers
                WHERE product_id = 3702
                ORDER BY price ASC LIMIT 1
225 0.0008 0.00079989433288574 
SELECT value FROM productattributes
                WHERE product_id = '3702'
                AND name = 'ListPriceAmount'
226 0.0008 0.00083804130554199 
SELECT value FROM productattributes WHERE product_id = '3702' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0008 0.00083398818969727 
SELECT * FROM productimages WHERE product_id = '3841' ORDER BY sortorder ASC
228 0.0017 0.0017309188842773 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3841' AND p.id = pi.product_id ORDER BY pi.sortorder
229 0.0007 0.00071883201599121 
SELECT * FROM product_image_select WHERE product_id = '3841'
230 0.0008 0.00077104568481445 
SELECT * FROM productcustomimages WHERE product_id = '3841'
231 0.0014 0.0013940334320068 
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 = '3841'
                GROUP BY o.product_id
232 0.0015 0.0015051364898682 
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     = '3841'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
233 0.0011 0.0011241436004639 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3841
234 0.0009 0.00090599060058594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3841' AND a.name = n.originalname
235 0.0008 0.00075912475585938 
SELECT * FROM productoffers WHERE product_id = '3841' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0007 0.00069212913513184 
SELECT * FROM productoffers
                WHERE product_id = '3841' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0008 0.00075602531433105 
SELECT * FROM productoffers
                WHERE product_id = 3841
                ORDER BY price ASC LIMIT 1
238 0.0008 0.0007781982421875 
SELECT value FROM productattributes
                WHERE product_id = '3841'
                AND name = 'ListPriceAmount'
239 0.0010 0.00095200538635254 
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 = '3841'
                GROUP BY o.product_id
240 0.0011 0.0010650157928467 
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     = '3841'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0011 0.0010759830474854 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3841
242 0.0009 0.00093913078308105 
SELECT value FROM productattributes WHERE product_id = '3841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0016 0.0016400814056396 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3841'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
244 0.0009 0.00086784362792969 
SELECT * FROM productimages WHERE product_id = '3842' ORDER BY sortorder ASC
245 0.0011 0.0010650157928467 
SELECT * FROM product_image_select WHERE product_id = '3842'
246 0.0009 0.00092816352844238 
SELECT * FROM productcustomimages WHERE product_id = '3842'
247 0.0009 0.00085210800170898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3842' AND a.name = n.originalname
248 0.0009 0.00093507766723633 
SELECT * FROM productoffers WHERE product_id = '3842' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0010 0.00095009803771973 
SELECT * FROM productoffers
                WHERE product_id = '3842' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0009 0.00091409683227539 
SELECT * FROM productoffers
                WHERE product_id = 3842
                ORDER BY price ASC LIMIT 1
251 0.0008 0.00080704689025879 
SELECT value FROM productattributes
                WHERE product_id = '3842'
                AND name = 'ListPriceAmount'
252 0.0008 0.00079798698425293 
SELECT value FROM productattributes WHERE product_id = '3842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0008 0.00080704689025879 
SELECT * FROM productimages WHERE product_id = '4113' ORDER BY sortorder ASC
254 0.0012 0.0012478828430176 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4113' AND p.id = pi.product_id ORDER BY pi.sortorder
255 0.0006 0.00062394142150879 
SELECT * FROM product_image_select WHERE product_id = '4113'
256 0.0006 0.00057196617126465 
SELECT * FROM productcustomimages WHERE product_id = '4113'
257 0.0012 0.0012259483337402 
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 = '4113'
                GROUP BY o.product_id
258 0.0019 0.0018949508666992 
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     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
259 0.0013 0.0012550354003906 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
260 0.0008 0.0008080005645752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname
261 0.0007 0.00068497657775879 
SELECT * FROM productoffers WHERE product_id = '4113' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0006 0.00064992904663086 
SELECT * FROM productoffers
                WHERE product_id = '4113' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0007 0.00069499015808105 
SELECT * FROM productoffers
                WHERE product_id = 4113
                ORDER BY price ASC LIMIT 1
264 0.0008 0.00078797340393066 
SELECT value FROM productattributes
                WHERE product_id = '4113'
                AND name = 'ListPriceAmount'
265 0.0008 0.00079512596130371 
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 = '4113'
                GROUP BY o.product_id
266 0.0005 0.0005490779876709 
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     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0005 0.00054311752319336 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
268 0.0006 0.00060105323791504 
SELECT value FROM productattributes WHERE product_id = '4113' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0013 0.0012760162353516 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4113'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
270 0.0010 0.0010299682617188 
SELECT * FROM products WHERE parent_id = '4113'
271 0.0006 0.00057291984558105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4753' AND a.name = n.originalname
272 0.0006 0.00063014030456543 
SELECT * FROM productoffers WHERE product_id = '4753' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0007 0.00070810317993164 
SELECT * FROM productoffers
                WHERE product_id = '4753' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0008 0.00084185600280762 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3839' ORDER BY timestamp DESC
275 0.0006 0.00063109397888184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3707' ORDER BY timestamp DESC
276 0.0006 0.00062108039855957 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3709' ORDER BY timestamp DESC
277 0.0007 0.00066304206848145 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3705' ORDER BY timestamp DESC
278 0.0007 0.00066304206848145 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3594' ORDER BY timestamp DESC
279 0.0008 0.00080394744873047 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '946' ORDER BY timestamp DESC
280 0.0007 0.00070905685424805 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1400' ORDER BY timestamp DESC
281 0.0007 0.00068998336791992 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3579' ORDER BY timestamp DESC
282 0.0007 0.00065088272094727 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3702' ORDER BY timestamp DESC
283 0.0006 0.00063705444335938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3841' ORDER BY timestamp DESC
284 0.0007 0.00071907043457031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3842' ORDER BY timestamp DESC
285 0.0007 0.00068187713623047 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4113' ORDER BY timestamp DESC
286 0.0009 0.00089502334594727 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
287 0.0008 0.00076699256896973 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
288 0.0007 0.00066494941711426 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
289 0.0007 0.00067782402038574 
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
290 0.0007 0.00067806243896484 
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
291 0.0006 0.000640869140625 
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
292 0.0009 0.00086808204650879 
SELECT * FROM products WHERE id = 1626
293 0.0010 0.00096392631530762 
SELECT * FROM products WHERE id = 4041
294 0.0010 0.0010039806365967 
SELECT * FROM products WHERE id = 4312
295 0.0011 0.001093864440918 
SELECT * FROM products WHERE id = 777
296 0.0010 0.0010349750518799 
SELECT * FROM products WHERE id = 4213
297 0.0011 0.00111985206604 
SELECT * FROM products WHERE id = 3881
298 0.0012 0.0011739730834961 
SELECT * FROM products WHERE id = '1626'
299 0.0009 0.00089907646179199 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
300 0.0009 0.00091195106506348 
SELECT * FROM product_image_select WHERE product_id = '1626'
301 0.0009 0.00092887878417969 
SELECT * FROM productcustomimages WHERE product_id = '1626'
302 0.0010 0.00095891952514648 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
303 0.0009 0.00094914436340332 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0008 0.00076198577880859 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0007 0.00069999694824219 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0009 0.00091099739074707 
SELECT * FROM products WHERE id = '4041'
307 0.0009 0.00091981887817383 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
308 0.0010 0.0010180473327637 
SELECT * FROM product_image_select WHERE product_id = '4041'
309 0.0009 0.00092101097106934 
SELECT * FROM productcustomimages WHERE product_id = '4041'
310 0.0008 0.00075387954711914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
311 0.0007 0.00070619583129883 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0007 0.00070405006408691 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0009 0.00087404251098633 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0008 0.00082898139953613 
SELECT * FROM products WHERE id = '4312'
315 0.0008 0.00075101852416992 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
316 0.0009 0.00086498260498047 
SELECT * FROM product_image_select WHERE product_id = '4312'
317 0.0009 0.00085592269897461 
SELECT * FROM productcustomimages WHERE product_id = '4312'
318 0.0008 0.00082111358642578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
319 0.0009 0.00090789794921875 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0009 0.00094008445739746 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0009 0.00094103813171387 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0010 0.0010330677032471 
SELECT * FROM products WHERE id = '777'
323 0.0009 0.0009000301361084 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
324 0.0009 0.00088787078857422 
SELECT * FROM product_image_select WHERE product_id = '777'
325 0.0010 0.0010020732879639 
SELECT * FROM productcustomimages WHERE product_id = '777'
326 0.0010 0.0010170936584473 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
327 0.0010 0.0010299682617188 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0012 0.0011987686157227 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0012 0.0011990070343018 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0013 0.0012519359588623 
SELECT * FROM products WHERE id = '4213'
331 0.0013 0.0013041496276855 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
332 0.0012 0.0011780261993408 
SELECT * FROM product_image_select WHERE product_id = '4213'
333 0.0011 0.0010969638824463 
SELECT * FROM productcustomimages WHERE product_id = '4213'
334 0.0013 0.0013101100921631 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
335 0.0012 0.0011570453643799 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0013 0.0012810230255127 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0012 0.0011868476867676 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0014 0.0013630390167236 
SELECT * FROM products WHERE id = '3881'
339 0.0016 0.0015690326690674 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
340 0.0013 0.0012519359588623 
SELECT * FROM product_image_select WHERE product_id = '3881'
341 0.0013 0.001317024230957 
SELECT * FROM productcustomimages WHERE product_id = '3881'
342 0.0014 0.0013902187347412 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
343 0.0013 0.0013258457183838 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
344 0.0014 0.0014119148254395 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
345 0.0013 0.0013020038604736 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346 0.0016 0.001615047454834 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
347 0.0017 0.0016880035400391 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
348 0.0015 0.0015079975128174 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
349 0.0017 0.0017390251159668 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
350 0.0015 0.0015418529510498 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
351 0.0013 0.0013101100921631 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
352 0.0015 0.0015418529510498 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'