Notice: Undefined index: sortoptions in /home/demofres/public_html/evolution/library/pagination.php on line 227
Site Map

Site Map

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam luctus euismod. Pellentesque cursus felis sodales ligula gravida vel ultrices purus pellentesque. Vestibulum scelerisque, lorem nec cursus aliquet, sem neque placerat nulla, id ullamcorper ante orci a purus. Etiam urna lorem, faucibus vitae porta sed, semper sit amet massa. Fusce quis nisi et nisl ullamcorper varius vitae nec magna. Ut pharetra pharetra urna, ac lacinia metus porttitor ut. Integer eu rutrum velit. Cras vitae mauris nisi.

Products

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam luctus euismod. Pellentesque cursus felis sodales ligula gravida vel ultrices purus pellentesque. Vestibulum scelerisque, lorem nec cursus aliquet, sem neque placerat nulla, id ullamcorper ante orci a purus. Etiam urna lorem, faucibus vitae porta sed, semper sit amet massa. Fusce quis nisi et nisl ullamcorper varius vitae nec magna. Ut pharetra pharetra urna, ac lacinia metus porttitor ut. Integer eu rutrum velit. Cras vitae mauris nisi.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.255231142044 534 0.0718 0


No Amazon API Requests Made.

Total time 0.255231142044 seconds

Number Time From Start Name Description
1 0.0498249530792 Initialise Initialise FSB Function
2 0.0505750179291 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0543830394745 Start of getCategoryListByGroup Function Before first category groups query
4 0.0544860363007 After initial query Before first category groups query
5 0.054486989975 Get Category List for Group Before the call to getCategoryList function
6 0.0544891357422 Start of GetCategoryList function Start of the function
7 0.0544950962067 Before getting categories Query to get specific category list
8 0.0546419620514 After getting categories Query to get specific category list
9 0.0546431541443 Before getting category custom Before call to function getCategoryCustom
10 0.0555009841919 After getting category custom After call to function getCategoryCustom
11 0.0555021762848 Before getting category custom Before call to function getCategoryCustom
12 0.0562989711761 After getting category custom After call to function getCategoryCustom
13 0.056300163269 Before getting category custom Before call to function getCategoryCustom
14 0.0571041107178 After getting category custom After call to function getCategoryCustom
15 0.0571060180664 Before getting category custom Before call to function getCategoryCustom
16 0.0578579902649 After getting category custom After call to function getCategoryCustom
17 0.0578601360321 End of GetCategoryList function End of the function
18 0.0578670501709 End of getCategoryListByGroup Function Before return()
19 0.059690952301 App Controller End End of the App controller (called before the controller of every page)
20 0.0766460895538 Start of GetCategoryList function Start of the function
21 0.076651096344 Before getting categories Query to get specific category list
22 0.0769309997559 After getting categories Query to get specific category list
23 0.0769331455231 Before getting category custom Before call to function getCategoryCustom
24 0.078565120697 After getting category custom After call to function getCategoryCustom
25 0.0785660743713 Before getting sub category list Before call to recursive function getCategoryList
26 0.07856798172 Start of GetCategoryList function Start of the function
27 0.0785701274872 Before getting categories Query to get specific category list
28 0.0787861347198 After getting sub category list After call to recursive function getCategoryList
29 0.0787870883942 Before getting category custom Before call to function getCategoryCustom
30 0.0794720649719 After getting category custom After call to function getCategoryCustom
31 0.0794730186462 Before getting sub category list Before call to recursive function getCategoryList
32 0.0794739723206 Start of GetCategoryList function Start of the function
33 0.0794761180878 Before getting categories Query to get specific category list
34 0.0795760154724 After getting sub category list After call to recursive function getCategoryList
35 0.0795769691467 Before getting category custom Before call to function getCategoryCustom
36 0.080265045166 After getting category custom After call to function getCategoryCustom
37 0.0802659988403 Before getting sub category list Before call to recursive function getCategoryList
38 0.0802681446075 Start of GetCategoryList function Start of the function
39 0.0802690982819 Before getting categories Query to get specific category list
40 0.0803680419922 After getting sub category list After call to recursive function getCategoryList
41 0.0803689956665 Before getting category custom Before call to function getCategoryCustom
42 0.0809609889984 After getting category custom After call to function getCategoryCustom
43 0.0809621810913 Before getting sub category list Before call to recursive function getCategoryList
44 0.0809640884399 Start of GetCategoryList function Start of the function
45 0.0809671878815 Before getting categories Query to get specific category list
46 0.0810639858246 After getting sub category list After call to recursive function getCategoryList
47 0.0810651779175 End of GetCategoryList function End of the function
48 0.130932092667 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 0.130989074707 Before Get Options Before the call to getOptions in the tpl class
50 0.146157979965 After Get Options After the call to getOptions in the tpl class
51 0.146208047867 App_after Controller End End of the App_after controller (called after the controller of every page)
52 0.255207061768 Finalizing debug Before the debug is output to the page.
53 0.25523018837 End of App This is the end of the app logging, final timestamp


Query Debug - 534 Database Queries. Total time 0.0718 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00026798248291
SELECT parameter, value FROM parameters
2 0.0001 0.000108957290649
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0001 0.000102996826172
SET time_zone = 'Europe/London'
4 0.0002 0.000185966491699
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0001 0.000108003616333
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0001 0.000128030776978
SELECT id FROM pages WHERE pagename = 'site-map' LIMIT 1
7 0.0001 0.000109910964966
SELECT * FROM pages WHERE id = 24
8 0.0003 0.000285148620605
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0028 0.00279498100281
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0002 0.000159978866577
SELECT * FROM pages WHERE pagename = 'site-map'
11 0.0001 8.89301300049E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0001 0.000126123428345
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
13 0.0002 0.000184059143066
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 = 67
14 0.0001 9.20295715332E-5
SELECT id FROM categories WHERE parent_id = '67'
15 0.0002 0.000178098678589
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
16 0.0001 0.0001060962677
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 AND offers > 0
17 0.0001 0.000108957290649
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0001 9.29832458496E-5
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000154972076416
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 = 68
20 0.0001 9.29832458496E-5
SELECT id FROM categories WHERE parent_id = '68'
21 0.0002 0.000167846679688
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
22 0.0001 9.67979431152E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 AND offers > 0
23 0.0001 0.0001060962677
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0001 9.41753387451E-5
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.00016188621521
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 = 69
26 0.0001 8.98838043213E-5
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000172853469849
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
28 0.0001 9.67979431152E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
29 0.0001 0.000102996826172
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 9.3936920166E-5
SELECT * FROM categorygroups WHERE id = '10'
31 0.0001 0.000137090682983
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 = 70
32 0.0001 9.20295715332E-5
SELECT id FROM categories WHERE parent_id = '70'
33 0.0001 0.000147104263306
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
34 0.0001 9.70363616943E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 AND offers > 0
35 0.0001 0.000104904174805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 9.20295715332E-5
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000178098678589
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0001 0.000144004821777
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 9.89437103271E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 0.000112056732178
SELECT * FROM pages WHERE id = '37'
41 0.0001 0.000102043151855
SELECT * FROM pages WHERE id = '4'
42 0.0001 9.98973846436E-5
SELECT * FROM pages WHERE id = '34'
43 0.0001 9.79900360107E-5
SELECT * FROM pages WHERE id = '3'
44 0.0001 9.89437103271E-5
SELECT * FROM pages WHERE id = '24'
45 0.0001 9.79900360107E-5
SELECT * FROM pages WHERE id = '5'
46 0.0001 0.000104188919067
SELECT * FROM pages WHERE id = '38'
47 0.0001 9.89437103271E-5
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000163078308105
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0004 0.000383853912354
SELECT * FROM pages WHERE pagename = 'site-map'
50 0.0003 0.000259160995483
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
51 0.0003 0.000319004058838
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 = 67
52 0.0002 0.000216960906982
SELECT id FROM categories WHERE parent_id = '67'
53 0.0003 0.000306844711304
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
54 0.0002 0.000224828720093
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 AND offers > 0
55 0.0002 0.000237941741943
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
56 0.0002 0.000191926956177
SELECT * FROM categorygroups WHERE id = '10'
57 0.0002 0.00019097328186
SELECT * FROM categories WHERE parent_id = '67'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
58 0.0002 0.000165939331055
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 = 68
59 0.0001 7.39097595215E-5
SELECT id FROM categories WHERE parent_id = '68'
60 0.0001 0.000149011611938
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
61 0.0001 8.01086425781E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 AND offers > 0
62 0.0001 8.48770141602E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
63 0.0001 7.20024108887E-5
SELECT * FROM categorygroups WHERE id = '10'
64 0.0001 9.01222229004E-5
SELECT * FROM categories WHERE parent_id = '68'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
65 0.0001 0.000139951705933
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 = 69
66 0.0001 7.29560852051E-5
SELECT id FROM categories WHERE parent_id = '69'
67 0.0002 0.000150203704834
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
68 0.0001 7.79628753662E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
69 0.0001 8.29696655273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
70 0.0001 0.000106811523438
SELECT * FROM categorygroups WHERE id = '10'
71 0.0001 9.01222229004E-5
SELECT * FROM categories WHERE parent_id = '69'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
72 0.0001 0.000109910964966
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 = 70
73 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '70'
74 0.0001 0.000121831893921
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
75 0.0001 7.89165496826E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 AND offers > 0
76 0.0001 8.29696655273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
77 0.0001 7.10487365723E-5
SELECT * FROM categorygroups WHERE id = '10'
78 0.0001 8.98838043213E-5
SELECT * FROM categories WHERE parent_id = '70'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
79 0.0001 0.000114917755127
SELECT * FROM pages WHERE xmlsitemap = 1
80 0.0001 0.000134944915771
SELECT COUNT(*) FROM products WHERE enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 
81 0.0003 0.000279903411865
SELECT * FROM products WHERE enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY linktitle LIMIT 0, 79
82 0.0001 9.3936920166E-5
SELECT * FROM productimages WHERE product_id = '53164' ORDER BY sortorder ASC
83 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53164'
84 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53164'
85 0.0004 0.000431060791016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53164' AND a.name = n.originalname
86 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53164' AND merchantid = 'ATVPDKIKX0DER'
87 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53164' AND price > 0
				ORDER BY price ASC LIMIT 1
88 0.0001 0.000148057937622
SELECT value FROM productattributes WHERE product_id = '53164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
89 0.0001 7.79628753662E-5
UPDATE products SET price = '849' WHERE id = '53164'
90 0.0001 0.000121831893921
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
91 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
92 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
93 0.0004 0.000444173812866
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
94 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
95 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
96 0.0002 0.000164031982422
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
97 0.0001 7.5101852417E-5
UPDATE products SET price = '998' WHERE id = '53159'
98 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53163' ORDER BY sortorder ASC
99 0.0001 6.5803527832E-5
SELECT * FROM product_image_select WHERE product_id = '53163'
100 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53163'
101 0.0003 0.000311851501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53163' AND a.name = n.originalname
102 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53163' AND merchantid = 'ATVPDKIKX0DER'
103 0.0001 0.000102996826172
SELECT * FROM productoffers
				WHERE product_id = '53163' AND price > 0
				ORDER BY price ASC LIMIT 1
104 0.0001 0.000134229660034
SELECT value FROM productattributes WHERE product_id = '53163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0001 7.29560852051E-5
UPDATE products SET price = '648' WHERE id = '53163'
106 0.0001 9.3936920166E-5
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
107 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
108 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
109 0.0005 0.000545024871826
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
110 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
111 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
112 0.0002 0.000152111053467
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0001 7.39097595215E-5
UPDATE products SET price = '1998' WHERE id = '53187'
114 0.0001 9.17911529541E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
115 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
116 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
117 0.0005 0.000481843948364
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
118 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
119 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
120 0.0002 0.000152111053467
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0001 7.41481781006E-5
UPDATE products SET price = '44900' WHERE id = '53141'
122 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
123 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
124 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
125 0.0004 0.000414848327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
126 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
127 0.0001 0.000102996826172
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
128 0.0001 0.000137805938721
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0001 7.29560852051E-5
UPDATE products SET price = '2854' WHERE id = '53188'
130 0.0001 0.000127792358398
SELECT * FROM productimages WHERE product_id = '53147' ORDER BY sortorder ASC
131 0.0001 0.000113010406494
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53147' AND p.id = pi.product_id ORDER BY pi.sortorder
132 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53147'
133 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53147'
134 0.0001 0.000112056732178
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53147'
				GROUP BY o.product_id
135 0.0001 0.000124931335449
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		= '53147'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
136 0.0001 9.79900360107E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53147
137 0.0005 0.000495910644531
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53147' AND a.name = n.originalname
138 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53147' AND merchantid = 'ATVPDKIKX0DER'
139 0.0001 9.41753387451E-5
SELECT * FROM productoffers
				WHERE product_id = '53147' AND price > 0
				ORDER BY price ASC LIMIT 1
140 0.0001 8.58306884766E-5
SELECT * FROM productoffers
				WHERE product_id = 53147
				ORDER BY price ASC LIMIT 1
141 0.0001 0.000113964080811
SELECT value FROM productattributes
				WHERE product_id = '53147'
				AND name = 'ListPriceAmount'
142 0.0001 0.000111818313599
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53147'
				GROUP BY o.product_id
143 0.0001 0.000121831893921
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		= '53147'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
144 0.0001 0.000102043151855
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53147
145 0.0002 0.000157117843628
SELECT value FROM productattributes WHERE product_id = '53147' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0001 7.29560852051E-5
UPDATE products SET price = '95400' WHERE id = '53147'
147 0.0001 0.000115871429443
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53147'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Color'
				GROUP BY o.value
				ORDER BY o.value ASC
148 0.0001 0.000108003616333
SELECT * FROM products WHERE parent_id = '53147'
149 0.0003 0.000311136245728
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53148' AND a.name = n.originalname
150 0.0001 0.000141143798828
SELECT * FROM productoffers WHERE product_id = '53148' AND merchantid = 'ATVPDKIKX0DER'
151 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53148' AND price > 0
				ORDER BY price ASC LIMIT 1
152 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53142' ORDER BY sortorder ASC
153 0.0001 0.000109195709229
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53142' AND p.id = pi.product_id ORDER BY pi.sortorder
154 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53142'
155 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53142'
156 0.0001 0.000109910964966
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53142'
				GROUP BY o.product_id
157 0.0001 0.000120162963867
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		= '53142'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
158 0.0001 9.79900360107E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53142
159 0.0004 0.000432968139648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53142' AND a.name = n.originalname
160 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53142' AND merchantid = 'ATVPDKIKX0DER'
161 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53142' AND price > 0
				ORDER BY price ASC LIMIT 1
162 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53142
				ORDER BY price ASC LIMIT 1
163 0.0001 0.00011420249939
SELECT value FROM productattributes
				WHERE product_id = '53142'
				AND name = 'ListPriceAmount'
164 0.0001 0.000112056732178
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53142'
				GROUP BY o.product_id
165 0.0001 0.000124931335449
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		= '53142'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
166 0.0001 9.67979431152E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53142
167 0.0002 0.000159025192261
SELECT value FROM productattributes WHERE product_id = '53142' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0001 7.48634338379E-5
UPDATE products SET price = '43864' WHERE id = '53142'
169 0.0001 0.000116109848022
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53142'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Color'
				GROUP BY o.value
				ORDER BY o.value ASC
170 0.0001 0.000107049942017
SELECT * FROM products WHERE parent_id = '53142'
171 0.0003 0.000318050384521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53143' AND a.name = n.originalname
172 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53143' AND merchantid = 'ATVPDKIKX0DER'
173 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53143' AND price > 0
				ORDER BY price ASC LIMIT 1
174 0.0001 8.29696655273E-5
SELECT * FROM productimages WHERE product_id = '53144' ORDER BY sortorder ASC
175 0.0001 0.0001220703125
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53144' AND p.id = pi.product_id ORDER BY pi.sortorder
176 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53144'
177 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53144'
178 0.0001 0.000115156173706
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53144'
				GROUP BY o.product_id
179 0.0001 0.000128984451294
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		= '53144'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
180 0.0001 0.000107049942017
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53144
181 0.0003 0.000327110290527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53144' AND a.name = n.originalname
182 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53144' AND merchantid = 'ATVPDKIKX0DER'
183 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53144' AND price > 0
				ORDER BY price ASC LIMIT 1
184 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53144
				ORDER BY price ASC LIMIT 1
185 0.0001 0.000105857849121
SELECT value FROM productattributes
				WHERE product_id = '53144'
				AND name = 'ListPriceAmount'
186 0.0001 0.000116109848022
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53144'
				GROUP BY o.product_id
187 0.0001 0.000133037567139
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		= '53144'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
188 0.0001 0.00010085105896
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53144
189 0.0001 0.000137090682983
SELECT value FROM productattributes WHERE product_id = '53144' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0001 7.5101852417E-5
UPDATE products SET price = '26657' WHERE id = '53144'
191 0.0001 0.0001220703125
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53144'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Style'
				GROUP BY o.value
				ORDER BY o.value ASC
192 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
193 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
194 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
195 0.0005 0.000495910644531
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
196 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
197 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
198 0.0001 0.000149011611938
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0001 7.41481781006E-5
UPDATE products SET price = '3597' WHERE id = '53196'
200 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
201 0.0001 0.000108003616333
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
202 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53176'
203 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53176'
204 0.0001 0.000108957290649
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
205 0.0001 0.000123977661133
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
206 0.0001 9.70363616943E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
207 0.0004 0.000424146652222
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
208 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
209 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
210 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
211 0.0001 0.000110864639282
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
212 0.0001 0.000113010406494
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
213 0.0001 0.000121831893921
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
214 0.0001 9.70363616943E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
215 0.0001 0.000144958496094
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0001 7.41481781006E-5
UPDATE products SET price = '3663' WHERE id = '53176'
217 0.0002 0.000203847885132
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
218 0.0001 0.000107049942017
SELECT * FROM products WHERE parent_id = '53176'
219 0.0001 0.000102996826172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
220 0.0001 8.98838043213E-5
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
221 0.0001 9.91821289062E-5
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
222 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
223 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
224 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
225 0.0005 0.000452995300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
226 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
227 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
228 0.0001 0.000146150588989
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0001 7.31945037842E-5
UPDATE products SET price = '1595' WHERE id = '53155'
230 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
231 0.0001 7.08103179932E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
232 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
233 0.0005 0.000508069992065
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
234 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
235 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
236 0.0002 0.00019907951355
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0001 0.000128984451294
UPDATE products SET price = '1510' WHERE id = '53162'
238 0.0001 8.20159912109E-5
SELECT * FROM productimages WHERE product_id = '53156' ORDER BY sortorder ASC
239 0.0001 0.000109910964966
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53156' AND p.id = pi.product_id ORDER BY pi.sortorder
240 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53156'
241 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53156'
242 0.0001 0.000113964080811
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53156'
				GROUP BY o.product_id
243 0.0001 0.000128984451294
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		= '53156'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
244 0.0001 9.98973846436E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53156
245 0.0004 0.000437021255493
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53156' AND a.name = n.originalname
246 0.0001 9.01222229004E-5
SELECT * FROM productoffers WHERE product_id = '53156' AND merchantid = 'ATVPDKIKX0DER'
247 0.0001 9.20295715332E-5
SELECT * FROM productoffers
				WHERE product_id = '53156' AND price > 0
				ORDER BY price ASC LIMIT 1
248 0.0001 8.48770141602E-5
SELECT * FROM productoffers
				WHERE product_id = 53156
				ORDER BY price ASC LIMIT 1
249 0.0001 0.000112056732178
SELECT value FROM productattributes
				WHERE product_id = '53156'
				AND name = 'ListPriceAmount'
250 0.0001 0.000116109848022
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53156'
				GROUP BY o.product_id
251 0.0001 0.000133991241455
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		= '53156'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
252 0.0001 9.98973846436E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53156
253 0.0001 0.000149965286255
SELECT value FROM productattributes WHERE product_id = '53156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0001 7.39097595215E-5
UPDATE products SET price = '314' WHERE id = '53156'
255 0.0001 0.0001220703125
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53156'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Style'
				GROUP BY o.value
				ORDER BY o.value ASC
256 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53170' ORDER BY sortorder ASC
257 0.0001 0.000114917755127
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53170' AND p.id = pi.product_id ORDER BY pi.sortorder
258 0.0001 6.8187713623E-5
SELECT * FROM product_image_select WHERE product_id = '53170'
259 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53170'
260 0.0002 0.000209808349609
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
261 0.0001 0.000146865844727
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		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
262 0.0001 0.000111103057861
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
263 0.0004 0.000371932983398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname
264 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53170' AND merchantid = 'ATVPDKIKX0DER'
265 0.0001 9.67979431152E-5
SELECT * FROM productoffers
				WHERE product_id = '53170' AND price > 0
				ORDER BY price ASC LIMIT 1
266 0.0001 9.01222229004E-5
SELECT * FROM productoffers
				WHERE product_id = 53170
				ORDER BY price ASC LIMIT 1
267 0.0001 0.000108957290649
SELECT value FROM productattributes
				WHERE product_id = '53170'
				AND name = 'ListPriceAmount'
268 0.0001 0.000128030776978
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
269 0.0001 0.000146865844727
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		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
270 0.0001 0.000108957290649
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
271 0.0001 0.000141859054565
SELECT value FROM productattributes WHERE product_id = '53170' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0001 7.39097595215E-5
UPDATE products SET price = '1481' WHERE id = '53170'
273 0.0001 0.000133991241455
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53170'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
274 0.0001 9.01222229004E-5
SELECT * FROM productimages WHERE product_id = '53165' ORDER BY sortorder ASC
275 0.0001 0.000108003616333
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53165' AND p.id = pi.product_id ORDER BY pi.sortorder
276 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53165'
277 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53165'
278 0.0001 0.000109195709229
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53165'
				GROUP BY o.product_id
279 0.0001 0.0001220703125
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		= '53165'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
280 0.0001 9.60826873779E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53165
281 0.0005 0.000533103942871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53165' AND a.name = n.originalname
282 0.0001 9.10758972168E-5
SELECT * FROM productoffers WHERE product_id = '53165' AND merchantid = 'ATVPDKIKX0DER'
283 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53165' AND price > 0
				ORDER BY price ASC LIMIT 1
284 0.0001 8.58306884766E-5
SELECT * FROM productoffers
				WHERE product_id = 53165
				ORDER BY price ASC LIMIT 1
285 0.0001 0.000112056732178
SELECT value FROM productattributes
				WHERE product_id = '53165'
				AND name = 'ListPriceAmount'
286 0.0001 0.000112056732178
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53165'
				GROUP BY o.product_id
287 0.0001 0.000123023986816
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		= '53165'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
288 0.0001 9.79900360107E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53165
289 0.0002 0.000163793563843
SELECT value FROM productattributes WHERE product_id = '53165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0001 7.20024108887E-5
UPDATE products SET price = '2099' WHERE id = '53165'
291 0.0001 0.000117063522339
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53165'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
292 0.0001 0.000107049942017
SELECT * FROM products WHERE parent_id = '53165'
293 0.0001 0.000104904174805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53166' AND a.name = n.originalname
294 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53166' AND merchantid = 'ATVPDKIKX0DER'
295 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53166' AND price > 0
				ORDER BY price ASC LIMIT 1
296 0.0001 9.01222229004E-5
SELECT * FROM productimages WHERE product_id = '53168' ORDER BY sortorder ASC
297 0.0001 0.000107049942017
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53168' AND p.id = pi.product_id ORDER BY pi.sortorder
298 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53168'
299 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53168'
300 0.0001 0.000108957290649
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53168'
				GROUP BY o.product_id
301 0.0001 0.000123023986816
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		= '53168'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
302 0.0001 9.79900360107E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53168
303 0.0003 0.000333070755005
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53168' AND a.name = n.originalname
304 0.0001 0.000144958496094
SELECT * FROM productoffers WHERE product_id = '53168' AND merchantid = 'ATVPDKIKX0DER'
305 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53168' AND price > 0
				ORDER BY price ASC LIMIT 1
306 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53168
				ORDER BY price ASC LIMIT 1
307 0.0001 0.000104904174805
SELECT value FROM productattributes
				WHERE product_id = '53168'
				AND name = 'ListPriceAmount'
308 0.0001 0.000112056732178
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53168'
				GROUP BY o.product_id
309 0.0001 0.000122785568237
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		= '53168'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
310 0.0001 9.89437103271E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53168
311 0.0001 0.000137805938721
SELECT value FROM productattributes WHERE product_id = '53168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0001 7.5101852417E-5
UPDATE products SET price = '1709' WHERE id = '53168'
313 0.0001 0.000114917755127
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53168'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
314 0.0001 0.0001060962677
SELECT * FROM products WHERE parent_id = '53168'
315 0.0001 0.000102996826172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53169' AND a.name = n.originalname
316 0.0001 8.98838043213E-5
SELECT * FROM productoffers WHERE product_id = '53169' AND merchantid = 'ATVPDKIKX0DER'
317 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53169' AND price > 0
				ORDER BY price ASC LIMIT 1
318 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
319 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
320 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
321 0.0004 0.000439167022705
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
322 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
323 0.0001 0.000102996826172
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
324 0.0001 0.00012993812561
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0001 7.48634338379E-5
UPDATE products SET price = '3395' WHERE id = '53167'
326 0.0001 9.48905944824E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
327 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
328 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
329 0.0003 0.000324010848999
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
330 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
331 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
332 0.0001 0.000133037567139
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0001 7.29560852051E-5
UPDATE products SET price = '471' WHERE id = '53160'
334 0.0001 8.48770141602E-5
SELECT * FROM productimages WHERE product_id = '53149' ORDER BY sortorder ASC
335 0.0001 0.000111818313599
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53149' AND p.id = pi.product_id ORDER BY pi.sortorder
336 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53149'
337 0.0001 6.31809234619E-5
SELECT * FROM productcustomimages WHERE product_id = '53149'
338 0.0001 0.000123023986816
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
339 0.0001 0.000144958496094
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
340 0.0001 0.000107049942017
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
341 0.0003 0.000337839126587
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
342 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
343 0.0001 9.20295715332E-5
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
344 0.0001 8.6784362793E-5
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
345 0.0001 0.000104904174805
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
346 0.0001 0.000126123428345
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
347 0.0001 0.000146150588989
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
348 0.0001 0.000107049942017
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
349 0.0002 0.000198841094971
SELECT value FROM productattributes WHERE product_id = '53149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350 0.0001 7.29560852051E-5
UPDATE products SET price = '1323' WHERE id = '53149'
351 0.0001 0.000128984451294
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53149'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
352 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53178' ORDER BY sortorder ASC
353 0.0001 0.000107049942017
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53178' AND p.id = pi.product_id ORDER BY pi.sortorder
354 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53178'
355 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53178'
356 0.0001 0.000108957290649
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53178'
				GROUP BY o.product_id
357 0.0001 0.000121116638184
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		= '53178'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
358 0.0001 0.000100135803223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53178
359 0.0005 0.00046181678772
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53178' AND a.name = n.originalname
360 0.0001 8.98838043213E-5
SELECT * FROM productoffers WHERE product_id = '53178' AND merchantid = 'ATVPDKIKX0DER'
361 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53178' AND price > 0
				ORDER BY price ASC LIMIT 1
362 0.0001 8.6784362793E-5
SELECT * FROM productoffers
				WHERE product_id = 53178
				ORDER BY price ASC LIMIT 1
363 0.0001 0.000113010406494
SELECT value FROM productattributes
				WHERE product_id = '53178'
				AND name = 'ListPriceAmount'
364 0.0001 0.000113010406494
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53178'
				GROUP BY o.product_id
365 0.0001 0.000121831893921
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		= '53178'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
366 0.0001 9.70363616943E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53178
367 0.0002 0.000152111053467
SELECT value FROM productattributes WHERE product_id = '53178' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0001 7.29560852051E-5
UPDATE products SET price = '8950' WHERE id = '53178'
369 0.0001 0.000115871429443
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53178'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
370 0.0001 0.000106811523438
SELECT * FROM products WHERE parent_id = '53178'
371 0.0001 0.000105142593384
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53179' AND a.name = n.originalname
372 0.0002 0.000153064727783
SELECT * FROM productoffers WHERE product_id = '53179' AND merchantid = 'ATVPDKIKX0DER'
373 0.0001 0.000113010406494
SELECT * FROM productoffers
				WHERE product_id = '53179' AND price > 0
				ORDER BY price ASC LIMIT 1
374 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53197' ORDER BY sortorder ASC
375 0.0001 0.000107049942017
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53197' AND p.id = pi.product_id ORDER BY pi.sortorder
376 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53197'
377 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53197'
378 0.0001 0.000108003616333
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53197'
				GROUP BY o.product_id
379 0.0001 0.000123977661133
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		= '53197'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
380 0.0001 9.89437103271E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53197
381 0.0005 0.000472784042358
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53197' AND a.name = n.originalname
382 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53197' AND merchantid = 'ATVPDKIKX0DER'
383 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53197' AND price > 0
				ORDER BY price ASC LIMIT 1
384 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53197
				ORDER BY price ASC LIMIT 1
385 0.0001 0.00011420249939
SELECT value FROM productattributes
				WHERE product_id = '53197'
				AND name = 'ListPriceAmount'
386 0.0001 0.000114917755127
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53197'
				GROUP BY o.product_id
387 0.0001 0.000123023986816
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		= '53197'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
388 0.0001 9.58442687988E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53197
389 0.0002 0.000150918960571
SELECT value FROM productattributes WHERE product_id = '53197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
390 0.0001 7.29560852051E-5
UPDATE products SET price = '2423' WHERE id = '53197'
391 0.0001 0.000116109848022
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53197'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
392 0.0001 0.000107049942017
SELECT * FROM products WHERE parent_id = '53197'
393 0.0001 0.000103950500488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53198' AND a.name = n.originalname
394 0.0001 8.98838043213E-5
SELECT * FROM productoffers WHERE product_id = '53198' AND merchantid = 'ATVPDKIKX0DER'
395 0.0002 0.000169992446899
SELECT * FROM productoffers
				WHERE product_id = '53198' AND price > 0
				ORDER BY price ASC LIMIT 1
396 0.0001 8.29696655273E-5
SELECT * FROM productimages WHERE product_id = '53130' ORDER BY sortorder ASC
397 0.0001 0.000113010406494
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53130' AND p.id = pi.product_id ORDER BY pi.sortorder
398 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53130'
399 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53130'
400 0.0001 0.000128984451294
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53130'
				GROUP BY o.product_id
401 0.0002 0.000152826309204
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		= '53130'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
402 0.0001 0.000113010406494
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53130
403 0.0003 0.000263929367065
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53130' AND a.name = n.originalname
404 0.0001 8.89301300049E-5
SELECT * FROM productoffers WHERE product_id = '53130' AND merchantid = 'ATVPDKIKX0DER'
405 0.0001 9.08374786377E-5
SELECT * FROM productoffers
				WHERE product_id = '53130' AND price > 0
				ORDER BY price ASC LIMIT 1
406 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53130
				ORDER BY price ASC LIMIT 1
407 0.0001 0.000101089477539
SELECT value FROM productattributes
				WHERE product_id = '53130'
				AND name = 'ListPriceAmount'
408 0.0001 0.000133991241455
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53130'
				GROUP BY o.product_id
409 0.0002 0.0001540184021
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		= '53130'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
410 0.0001 0.000119924545288
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53130
411 0.0001 0.000128984451294
SELECT value FROM productattributes WHERE product_id = '53130' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
412 0.0001 7.29560852051E-5
UPDATE products SET price = '18049' WHERE id = '53130'
413 0.0001 0.000133991241455
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53130'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
414 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53189' ORDER BY sortorder ASC
415 0.0001 0.00011420249939
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53189' AND p.id = pi.product_id ORDER BY pi.sortorder
416 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53189'
417 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53189'
418 0.0001 0.000113964080811
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53189'
				GROUP BY o.product_id
419 0.0002 0.000232934951782
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		= '53189'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
420 0.0001 0.000102996826172
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53189
421 0.0003 0.000288963317871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53189' AND a.name = n.originalname
422 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53189' AND merchantid = 'ATVPDKIKX0DER'
423 0.0001 9.32216644287E-5
SELECT * FROM productoffers
				WHERE product_id = '53189' AND price > 0
				ORDER BY price ASC LIMIT 1
424 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53189
				ORDER BY price ASC LIMIT 1
425 0.0001 0.000106811523438
SELECT value FROM productattributes
				WHERE product_id = '53189'
				AND name = 'ListPriceAmount'
426 0.0001 0.000119924545288
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53189'
				GROUP BY o.product_id
427 0.0001 0.000148773193359
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		= '53189'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
428 0.0001 0.000102043151855
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53189
429 0.0001 0.00012993812561
SELECT value FROM productattributes WHERE product_id = '53189' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430 0.0001 7.39097595215E-5
UPDATE products SET price = '2493' WHERE id = '53189'
431 0.0001 0.000128984451294
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53189'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Style'
				GROUP BY o.value
				ORDER BY o.value ASC
432 0.0001 0.000124931335449
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53189'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
433 0.0001 9.70363616943E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
434 0.0001 8.70227813721E-5
SELECT * FROM pages WHERE id = 2
435 0.0001 0.000136137008667
SELECT * FROM pages WHERE id = 38
436 0.0001 7.82012939453E-5
SELECT * FROM pages WHERE id = 39
437 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 6
438 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 7
439 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 32
440 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 2
441 0.0001 7.58171081543E-5
SELECT * FROM pages WHERE id = 28
442 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 13
443 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 24
444 0.0002 0.000165939331055
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
445 0.0001 9.48905944824E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
446 0.0001 6.8187713623E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
447 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
448 0.0005 0.000481128692627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
449 0.0001 9.60826873779E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
450 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
451 0.0002 0.000153779983521
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 7.5101852417E-5
UPDATE products SET price = '44900' WHERE id = '53141'
453 0.0001 9.08374786377E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
454 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
455 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
456 0.0005 0.000453948974609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
457 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
458 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
459 0.0001 0.00014591217041
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 7.39097595215E-5
UPDATE products SET price = '1595' WHERE id = '53155'
461 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
462 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
463 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
464 0.0004 0.000447034835815
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
465 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
466 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
467 0.0002 0.000158071517944
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 7.29560852051E-5
UPDATE products SET price = '998' WHERE id = '53159'
469 0.0001 9.48905944824E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
470 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
471 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
472 0.0003 0.000320911407471
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
473 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
474 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
475 0.0001 0.000133037567139
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 7.29560852051E-5
UPDATE products SET price = '471' WHERE id = '53160'
477 0.0001 0.000148057937622
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
478 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
479 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
480 0.0005 0.000509977340698
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
481 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
482 0.0001 0.000103950500488
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
483 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 7.29560852051E-5
UPDATE products SET price = '1510' WHERE id = '53162'
485 0.0001 9.20295715332E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
486 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
487 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
488 0.0004 0.000411987304688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
489 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
490 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
491 0.0001 0.000126123428345
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
492 0.0001 7.20024108887E-5
UPDATE products SET price = '3395' WHERE id = '53167'
493 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
494 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
495 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
496 0.0004 0.000426054000854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
497 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
498 0.0001 9.20295715332E-5
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
499 0.0001 8.60691070557E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
500 0.0001 0.000100135803223
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
501 0.0001 7.39097595215E-5
UPDATE products SET price = '6995' WHERE id = '53186'
502 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
503 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
504 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
505 0.0005 0.000500917434692
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
506 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
507 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
508 0.0002 0.000151872634888
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 7.29560852051E-5
UPDATE products SET price = '1998' WHERE id = '53187'
510 0.0001 9.20295715332E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
511 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
512 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
513 0.0004 0.000411033630371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
514 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
515 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
516 0.0002 0.000171184539795
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0001 7.29560852051E-5
UPDATE products SET price = '2854' WHERE id = '53188'
518 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
519 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
520 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
521 0.0004 0.000432014465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
522 0.0001 9.10758972168E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
523 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
524 0.0001 0.00014591217041
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
525 0.0001 7.20024108887E-5
UPDATE products SET price = '3597' WHERE id = '53196'
526 0.0002 0.000163078308105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
527 0.0001 0.000140905380249
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
528 0.0004 0.000380992889404
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
529 0.0001 0.000141859054565
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
530 0.0001 0.000130891799927
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
531 0.0004 0.000397920608521
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
532 0.0003 0.000273942947388
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
533 0.0003 0.000269889831543
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
534 0.0004 0.000399112701416
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'