0
  1. My Store
  2. Site Map

Site Map

Products

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
2.742486000061 1297 1.6649 0


No Amazon API Requests Made.


App Debug - Total Time 2.742486000061 seconds

Number Time From Start Name Description
1 0.62000608444214 Initialise Initialise FSB Function
2 0.6244330406189 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65302705764771 Start of getCategoryListByGroup Function Before first category groups query
4 0.65523195266724 After initial query Before first category groups query
5 0.65523290634155 Get Category List for Group Before the call to getCategoryList function
6 0.65523505210876 Start of GetCategoryList function Start of the function
7 0.6552369594574 Before getting categories Query to get specific category list
8 0.65763211250305 After getting categories Query to get specific category list
9 0.65763211250305 Before getting category custom Before call to function getCategoryCustom
10 0.68317294120789 After getting category custom After call to function getCategoryCustom
11 0.68317604064941 Before getting category custom Before call to function getCategoryCustom
12 0.69450902938843 After getting category custom After call to function getCategoryCustom
13 0.69451189041138 Before getting category custom Before call to function getCategoryCustom
14 0.70149803161621 After getting category custom After call to function getCategoryCustom
15 0.70150089263916 Before getting category custom Before call to function getCategoryCustom
16 0.70650196075439 After getting category custom After call to function getCategoryCustom
17 0.70650410652161 Before getting category custom Before call to function getCategoryCustom
18 0.71169900894165 After getting category custom After call to function getCategoryCustom
19 0.71169996261597 Before getting category custom Before call to function getCategoryCustom
20 0.71739506721497 After getting category custom After call to function getCategoryCustom
21 0.71739602088928 End of GetCategoryList function End of the function
22 0.71740102767944 Get Category List for Group Before the call to getCategoryList function
23 0.71740198135376 Start of GetCategoryList function Start of the function
24 0.71740293502808 Before getting categories Query to get specific category list
25 0.71798205375671 End of getCategoryListByGroup Function Before return()
26 1.5187420845032 App Controller End End of the App controller (called before the controller of every page)
27 1.5565838813782 Start of GetCategoryList function Start of the function
28 1.5565869808197 Before getting categories Query to get specific category list
29 1.5582070350647 After getting categories Query to get specific category list
30 1.558207988739 Before getting category custom Before call to function getCategoryCustom
31 1.5917589664459 After getting category custom After call to function getCategoryCustom
32 1.5917611122131 Before getting sub category list Before call to recursive function getCategoryList
33 1.5917630195618 Start of GetCategoryList function Start of the function
34 1.5917649269104 Before getting categories Query to get specific category list
35 1.5923459529877 After getting sub category list After call to recursive function getCategoryList
36 1.5923480987549 Before getting category custom Before call to function getCategoryCustom
37 1.6048099994659 After getting category custom After call to function getCategoryCustom
38 1.6048099994659 Before getting sub category list Before call to recursive function getCategoryList
39 1.6048109531403 Start of GetCategoryList function Start of the function
40 1.6048119068146 Before getting categories Query to get specific category list
41 1.6053268909454 After getting sub category list After call to recursive function getCategoryList
42 1.6053280830383 Before getting category custom Before call to function getCategoryCustom
43 1.6124210357666 After getting category custom After call to function getCategoryCustom
44 1.6124219894409 Before getting sub category list Before call to recursive function getCategoryList
45 1.6124219894409 Start of GetCategoryList function Start of the function
46 1.6124229431152 Before getting categories Query to get specific category list
47 1.6129059791565 After getting sub category list After call to recursive function getCategoryList
48 1.6129069328308 Before getting category custom Before call to function getCategoryCustom
49 1.6181709766388 After getting category custom After call to function getCategoryCustom
50 1.6181709766388 Before getting sub category list Before call to recursive function getCategoryList
51 1.6181719303131 Start of GetCategoryList function Start of the function
52 1.6181719303131 Before getting categories Query to get specific category list
53 1.618635892868 After getting sub category list After call to recursive function getCategoryList
54 1.618635892868 Before getting category custom Before call to function getCategoryCustom
55 1.6238269805908 After getting category custom After call to function getCategoryCustom
56 1.6238279342651 Before getting sub category list Before call to recursive function getCategoryList
57 1.6238288879395 Start of GetCategoryList function Start of the function
58 1.6238288879395 Before getting categories Query to get specific category list
59 1.6243450641632 After getting sub category list After call to recursive function getCategoryList
60 1.6243460178375 Before getting category custom Before call to function getCategoryCustom
61 1.6295709609985 After getting category custom After call to function getCategoryCustom
62 1.6295709609985 Before getting sub category list Before call to recursive function getCategoryList
63 1.6295719146729 Start of GetCategoryList function Start of the function
64 1.6295731067657 Before getting categories Query to get specific category list
65 1.6300609111786 After getting sub category list After call to recursive function getCategoryList
66 1.6300621032715 End of GetCategoryList function End of the function
67 2.2947030067444 App_after Controller Start Start of the App_after controller (called after the controller of every page)
68 2.2964479923248 Before Get Options Before the call to getOptions in the tpl class
69 2.3480250835419 After Get Options After the call to getOptions in the tpl class
70 2.3480570316315 App_after Controller End End of the App_after controller (called after the controller of every page)
71 2.7424759864807 Finalizing debug Before the debug is output to the page.
72 2.742486000061 End of App This is the end of the app logging, final timestamp


Query Debug - 1297 Database Queries. Total time 1.6649 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00092911720275879 
SELECT parameter, value FROM parameters
2 0.0036 0.0035998821258545 
SELECT * FROM `bad_bots`
3 0.0004 0.00036001205444336 
SET time_zone = 'Europe/London'
4 0.0006 0.00063586235046387 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019199848175049 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.224.20.254\";}'
6 0.0015 0.0014889240264893 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746840004'
7 0.0022 0.0022201538085938 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059795379638672 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0027 0.0027470588684082 
SELECT id FROM pages WHERE pagename = 'site-map' LIMIT 1
10 0.0005 0.00053501129150391 
SELECT * FROM pages WHERE id = 43
11 0.0025 0.0025448799133301 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0251 0.025061845779419 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00072908401489258 
SELECT * FROM pages WHERE pagename = 'site-map'
14 0.0022 0.0021989345550537 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0024 0.0023841857910156 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0086 0.0086181163787842 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0025 0.0025229454040527 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0015 0.0015480518341064 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00048208236694336 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0057 0.0057120323181152 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0023 0.0022730827331543 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0020 0.0019619464874268 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0018 0.0017759799957275 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00054001808166504 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037920475006104 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.0006251335144043 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.0004570484161377 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00047087669372559 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0038111209869385 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0006 0.00059604644775391 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0006 0.0005650520324707 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00047993659973145 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047397613525391 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014550685882568 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0005 0.00054097175598145 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00039911270141602 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00040197372436523 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015299320220947 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0009 0.00086498260498047 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0007 0.00066399574279785 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0006 0.00057101249694824 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00049901008605957 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00064992904663086 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00052499771118164 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0005 0.00048589706420898 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043392181396484 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00085186958312988 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0005 0.0005028247833252 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0005 0.00054097175598145 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.00049495697021484 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00047183036804199 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00063085556030273 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0007 0.00067996978759766 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00041103363037109 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00042486190795898 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00071287155151367 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0005 0.00054192543029785 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0006 0.00063705444335938 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0006 0.00063991546630859 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00049090385437012 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00064396858215332 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00049805641174316 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00036811828613281 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0004279613494873 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00091791152954102 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0007 0.0006709098815918 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0007 0.00073695182800293 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0009 0.00085687637329102 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00054788589477539 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00057601928710938 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0031239986419678 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0016269683837891 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0009 0.00091099739074707 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0017 0.0017180442810059 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011389255523682 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010089874267578 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7629 0.76286792755127 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.224.20.254') >= INET_ATON(ip_start) AND INET_ATON('18.224.20.254') <= INET_ATON(ip_end)
78 0.0027 0.0027239322662354 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0015 0.0014660358428955 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0016 0.0015721321105957 
SELECT * FROM pages WHERE pagename = 'site-map'
81 0.0016 0.0016021728515625 
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0184 0.018447875976562 
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
83 0.0011 0.0010790824890137 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
84 0.0007 0.00074386596679688 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
85 0.0008 0.00080990791320801 
SELECT id FROM categories WHERE parent_id = '26'
86 0.0095 0.0095250606536865 
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
87 0.0009 0.0009009838104248 
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
88 0.0008 0.00081896781921387 
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
89 0.0006 0.00061202049255371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
90 0.0005 0.00051498413085938 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0006 0.00057315826416016 
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
92 0.0044 0.0043549537658691 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0006 0.00061202049255371 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
94 0.0005 0.00048208236694336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0005 0.00048708915710449 
SELECT id FROM categories WHERE parent_id = '27'
96 0.0042 0.0041899681091309 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
97 0.0007 0.00065302848815918 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
98 0.0006 0.00061893463134766 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0005 0.00050187110900879 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0005 0.00049805641174316 
SELECT * FROM categorygroups WHERE id = '1'
101 0.0005 0.00051188468933105 
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
102 0.0017 0.0017321109771729 
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
103 0.0005 0.00049781799316406 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
104 0.0004 0.00040316581726074 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
105 0.0004 0.00039815902709961 
SELECT id FROM categories WHERE parent_id = '28'
106 0.0017 0.0017480850219727 
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
107 0.0006 0.00059914588928223 
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
108 0.0007 0.0006871223449707 
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
109 0.0005 0.00050711631774902 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
110 0.0005 0.00048708915710449 
SELECT * FROM categorygroups WHERE id = '1'
111 0.0005 0.00048017501831055 
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
112 0.0007 0.00072002410888672 
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
113 0.0005 0.00053787231445312 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
114 0.0006 0.00055789947509766 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
115 0.0005 0.00051712989807129 
SELECT id FROM categories WHERE parent_id = '29'
116 0.0008 0.00077509880065918 
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
117 0.0006 0.0005800724029541 
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
118 0.0006 0.00057601928710938 
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
119 0.0005 0.00051498413085938 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
120 0.0005 0.00046300888061523 
SELECT * FROM categorygroups WHERE id = '1'
121 0.0005 0.00046110153198242 
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
122 0.0008 0.00076699256896973 
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
123 0.0005 0.00050806999206543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
124 0.0004 0.00040411949157715 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
125 0.0004 0.00043296813964844 
SELECT id FROM categories WHERE parent_id = '30'
126 0.0008 0.00080394744873047 
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
127 0.0006 0.00062799453735352 
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
128 0.0006 0.00063800811767578 
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
129 0.0005 0.00048112869262695 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
130 0.0005 0.0005037784576416 
SELECT * FROM categorygroups WHERE id = '1'
131 0.0005 0.00051283836364746 
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
132 0.0008 0.00076794624328613 
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
133 0.0005 0.00052213668823242 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
134 0.0004 0.00043296813964844 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
135 0.0005 0.0005040168762207 
SELECT id FROM categories WHERE parent_id = '31'
136 0.0008 0.00082993507385254 
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
137 0.0005 0.00054097175598145 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
138 0.0006 0.00063109397888184 
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
139 0.0005 0.00051498413085938 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
140 0.0005 0.00045609474182129 
SELECT * FROM categorygroups WHERE id = '1'
141 0.0005 0.00048589706420898 
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0010 0.00095891952514648 
SELECT * FROM pages WHERE xmlsitemap = 1
143 0.0075 0.0075430870056152 
SELECT COUNT(*) FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0
144 0.0067 0.0066788196563721 
SELECT * FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 ORDER BY linktitle LIMIT 759, 100
145 0.0027 0.0026540756225586 
SELECT * FROM productimages WHERE product_id = '3880' ORDER BY sortorder ASC
146 0.0024 0.0024418830871582 
SELECT * FROM product_image_select WHERE product_id = '3880'
147 0.0017 0.0017199516296387 
SELECT * FROM productcustomimages WHERE product_id = '3880'
148 0.0037 0.0036909580230713 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3880' AND a.name = n.originalname
149 0.0019 0.0018961429595947 
SELECT * FROM productoffers WHERE product_id = '3880' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.00046801567077637 
SELECT * FROM productoffers
                WHERE product_id = '3880' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00044012069702148 
SELECT * FROM productoffers
                WHERE product_id = 3880
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00053501129150391 
SELECT value FROM productattributes
                WHERE product_id = '3880'
                AND name = 'ListPriceAmount'
153 0.0004 0.00044488906860352 
SELECT value FROM productattributes WHERE product_id = '3880' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00048422813415527 
SELECT * FROM productimages WHERE product_id = '3826' ORDER BY sortorder ASC
155 0.0006 0.00061202049255371 
SELECT * FROM product_image_select WHERE product_id = '3826'
156 0.0004 0.00039005279541016 
SELECT * FROM productcustomimages WHERE product_id = '3826'
157 0.0014 0.0014469623565674 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3826' AND a.name = n.originalname
158 0.0005 0.00046396255493164 
SELECT * FROM productoffers WHERE product_id = '3826' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00049114227294922 
SELECT * FROM productoffers
                WHERE product_id = '3826' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00054502487182617 
SELECT * FROM productoffers
                WHERE product_id = 3826
                ORDER BY price ASC LIMIT 1
161 0.0004 0.00044393539428711 
SELECT value FROM productattributes
                WHERE product_id = '3826'
                AND name = 'ListPriceAmount'
162 0.0005 0.00046491622924805 
SELECT value FROM productattributes WHERE product_id = '3826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.00063085556030273 
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
164 0.0008 0.00083017349243164 
SELECT * FROM product_image_select WHERE product_id = '3828'
165 0.0005 0.00050806999206543 
SELECT * FROM productcustomimages WHERE product_id = '3828'
166 0.0017 0.0016720294952393 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
167 0.0005 0.00051593780517578 
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0004 0.00043010711669922 
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0006 0.00063014030456543 
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0006 0.00058388710021973 
SELECT * FROM productimages WHERE product_id = '3487' ORDER BY sortorder ASC
171 0.0006 0.00064301490783691 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3487' AND p.id = pi.product_id ORDER BY pi.sortorder
172 0.0008 0.0007929801940918 
SELECT * FROM product_image_select WHERE product_id = '3487'
173 0.0005 0.00051999092102051 
SELECT * FROM productcustomimages WHERE product_id = '3487'
174 0.0007 0.00065398216247559 
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 = '3487'
                GROUP BY o.product_id
175 0.0042 0.0041849613189697 
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     = '3487'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0006 0.00060200691223145 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3487
177 0.0011 0.0010850429534912 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3487' AND a.name = n.originalname
178 0.0006 0.00062799453735352 
SELECT * FROM productoffers WHERE product_id = '3487' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '3487' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = 3487
                ORDER BY price ASC LIMIT 1
181 0.0007 0.00067496299743652 
SELECT value FROM productattributes
                WHERE product_id = '3487'
                AND name = 'ListPriceAmount'
182 0.0007 0.00072789192199707 
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 = '3487'
                GROUP BY o.product_id
183 0.0009 0.0008549690246582 
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     = '3487'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
184 0.0006 0.00060105323791504 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3487
185 0.0007 0.0007319450378418 
SELECT value FROM productattributes WHERE product_id = '3487' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0008 0.00084519386291504 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3487'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
187 0.0005 0.0005030632019043 
SELECT * FROM products WHERE parent_id = '3487'
188 0.0007 0.00072193145751953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4881' AND a.name = n.originalname
189 0.0006 0.00055909156799316 
SELECT * FROM productoffers WHERE product_id = '4881' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0004 0.00041103363037109 
SELECT * FROM productoffers
                WHERE product_id = '4881' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00034403800964355 
SELECT * FROM productoffers
                WHERE product_id = 4881
                ORDER BY price ASC LIMIT 1
192 0.0004 0.00043106079101562 
SELECT value FROM productattributes
                WHERE product_id = '4881'
                AND name = 'ListPriceAmount'
193 0.0005 0.00053620338439941 
SELECT * FROM productimages WHERE product_id = '3507' ORDER BY sortorder ASC
194 0.0007 0.00071382522583008 
SELECT * FROM product_image_select WHERE product_id = '3507'
195 0.0004 0.00043702125549316 
SELECT * FROM productcustomimages WHERE product_id = '3507'
196 0.0008 0.00084495544433594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3507' AND a.name = n.originalname
197 0.0005 0.00052785873413086 
SELECT * FROM productoffers WHERE product_id = '3507' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0004 0.00038981437683105 
SELECT * FROM productoffers
                WHERE product_id = '3507' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00035381317138672 
SELECT * FROM productoffers
                WHERE product_id = 3507
                ORDER BY price ASC LIMIT 1
200 0.0004 0.00043082237243652 
SELECT value FROM productattributes
                WHERE product_id = '3507'
                AND name = 'ListPriceAmount'
201 0.0004 0.00042605400085449 
SELECT value FROM productattributes WHERE product_id = '3507' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '4203' ORDER BY sortorder ASC
203 0.0007 0.00067806243896484 
SELECT * FROM product_image_select WHERE product_id = '4203'
204 0.0004 0.00044512748718262 
SELECT * FROM productcustomimages WHERE product_id = '4203'
205 0.0009 0.00086307525634766 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4203' AND a.name = n.originalname
206 0.0006 0.00062799453735352 
SELECT * FROM productoffers WHERE product_id = '4203' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0004 0.00043892860412598 
SELECT * FROM productoffers
                WHERE product_id = '4203' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 4203
                ORDER BY price ASC LIMIT 1
209 0.0006 0.00057196617126465 
SELECT value FROM productattributes
                WHERE product_id = '4203'
                AND name = 'ListPriceAmount'
210 0.0005 0.00046920776367188 
SELECT value FROM productattributes WHERE product_id = '4203' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0006 0.00059604644775391 
SELECT * FROM productimages WHERE product_id = '773' ORDER BY sortorder ASC
212 0.0007 0.00069999694824219 
SELECT * FROM product_image_select WHERE product_id = '773'
213 0.0005 0.00050592422485352 
SELECT * FROM productcustomimages WHERE product_id = '773'
214 0.0010 0.00098204612731934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname
215 0.0006 0.00062799453735352 
SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0005 0.0004889965057373 
SELECT * FROM productoffers
                WHERE product_id = '773' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0005 0.00049710273742676 
SELECT * FROM productoffers
                WHERE product_id = 773
                ORDER BY price ASC LIMIT 1
218 0.0004 0.00041794776916504 
SELECT value FROM productattributes
                WHERE product_id = '773'
                AND name = 'ListPriceAmount'
219 0.0005 0.00050187110900879 
SELECT value FROM productattributes WHERE product_id = '773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.0005950927734375 
SELECT * FROM productimages WHERE product_id = '2104' ORDER BY sortorder ASC
221 0.0007 0.00066113471984863 
SELECT * FROM product_image_select WHERE product_id = '2104'
222 0.0004 0.00042605400085449 
SELECT * FROM productcustomimages WHERE product_id = '2104'
223 0.0010 0.00099802017211914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2104' AND a.name = n.originalname
224 0.0005 0.00045609474182129 
SELECT * FROM productoffers WHERE product_id = '2104' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00035810470581055 
SELECT * FROM productoffers
                WHERE product_id = '2104' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.0003361701965332 
SELECT * FROM productoffers
                WHERE product_id = 2104
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00035786628723145 
SELECT value FROM productattributes
                WHERE product_id = '2104'
                AND name = 'ListPriceAmount'
228 0.0004 0.00039005279541016 
SELECT value FROM productattributes WHERE product_id = '2104' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00044703483581543 
SELECT * FROM productimages WHERE product_id = '2245' ORDER BY sortorder ASC
230 0.0005 0.00054001808166504 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2245' AND p.id = pi.product_id ORDER BY pi.sortorder
231 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '2245'
232 0.0004 0.00041103363037109 
SELECT * FROM productcustomimages WHERE product_id = '2245'
233 0.0005 0.00049495697021484 
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 = '2245'
                GROUP BY o.product_id
234 0.0007 0.00065088272094727 
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     = '2245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
235 0.0004 0.00040578842163086 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2245
236 0.0008 0.0008399486541748 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2245' AND a.name = n.originalname
237 0.0004 0.00037097930908203 
SELECT * FROM productoffers WHERE product_id = '2245' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = '2245' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = 2245
                ORDER BY price ASC LIMIT 1
240 0.0004 0.0003960132598877 
SELECT value FROM productattributes
                WHERE product_id = '2245'
                AND name = 'ListPriceAmount'
241 0.0004 0.00038909912109375 
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 = '2245'
                GROUP BY o.product_id
242 0.0006 0.00062990188598633 
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     = '2245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
243 0.0004 0.0003821849822998 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2245
244 0.0005 0.0005340576171875 
SELECT value FROM productattributes WHERE product_id = '2245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0004 0.0003960132598877 
SELECT * FROM products WHERE parent_id = '2245'
246 0.0005 0.00047612190246582 
SELECT * FROM productimages WHERE product_id = '2244' ORDER BY sortorder ASC
247 0.0006 0.00063800811767578 
SELECT * FROM product_image_select WHERE product_id = '2244'
248 0.0004 0.0003960132598877 
SELECT * FROM productcustomimages WHERE product_id = '2244'
249 0.0011 0.001079797744751 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2244' AND a.name = n.originalname
250 0.0004 0.00042915344238281 
SELECT * FROM productoffers WHERE product_id = '2244' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0009 0.00087499618530273 
SELECT * FROM productoffers
                WHERE product_id = '2244' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0006 0.00060200691223145 
SELECT * FROM productoffers
                WHERE product_id = 2244
                ORDER BY price ASC LIMIT 1
253 0.0007 0.00070285797119141 
SELECT value FROM productattributes
                WHERE product_id = '2244'
                AND name = 'ListPriceAmount'
254 0.0005 0.00051093101501465 
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
255 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '1251'
256 0.0004 0.00037980079650879 
SELECT * FROM productcustomimages WHERE product_id = '1251'
257 0.0010 0.0010499954223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
258 0.0005 0.00046491622924805 
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0004 0.00043702125549316 
SELECT * FROM productimages WHERE product_id = '2836' ORDER BY sortorder ASC
262 0.0005 0.00053906440734863 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2836' AND p.id = pi.product_id ORDER BY pi.sortorder
263 0.0006 0.00059103965759277 
SELECT * FROM product_image_select WHERE product_id = '2836'
264 0.0004 0.00043392181396484 
SELECT * FROM productcustomimages WHERE product_id = '2836'
265 0.0006 0.00060081481933594 
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 = '2836'
                GROUP BY o.product_id
266 0.0008 0.00076580047607422 
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     = '2836'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0004 0.00044989585876465 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2836
268 0.0010 0.0010249614715576 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2836' AND a.name = n.originalname
269 0.0003 0.00032997131347656 
SELECT * FROM productoffers WHERE product_id = '2836' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = '2836' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = 2836
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00031805038452148 
SELECT value FROM productattributes
                WHERE product_id = '2836'
                AND name = 'ListPriceAmount'
273 0.0004 0.00036501884460449 
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 = '2836'
                GROUP BY o.product_id
274 0.0006 0.00059890747070312 
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     = '2836'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
275 0.0004 0.00036287307739258 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2836
276 0.0005 0.00050902366638184 
SELECT value FROM productattributes WHERE product_id = '2836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
277 0.0006 0.00061297416687012 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2836'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
278 0.0004 0.00041604042053223 
SELECT * FROM products WHERE parent_id = '2836'
279 0.0005 0.00052905082702637 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2837' AND a.name = n.originalname
280 0.0004 0.0004279613494873 
SELECT * FROM productoffers WHERE product_id = '2837' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0003 0.00032711029052734 
SELECT * FROM productoffers
                WHERE product_id = '2837' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0003 0.00029110908508301 
SELECT * FROM productoffers
                WHERE product_id = 2837
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00031900405883789 
SELECT value FROM productattributes
                WHERE product_id = '2837'
                AND name = 'ListPriceAmount'
284 0.0005 0.00045108795166016 
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
285 0.0006 0.00057816505432129 
SELECT * FROM product_image_select WHERE product_id = '4910'
286 0.0004 0.00035810470581055 
SELECT * FROM productcustomimages WHERE product_id = '4910'
287 0.0012 0.0012249946594238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
288 0.0004 0.0004279613494873 
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0004 0.00038695335388184 
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0005 0.00053000450134277 
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
292 0.0009 0.00088596343994141 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
293 0.0006 0.00060606002807617 
SELECT * FROM product_image_select WHERE product_id = '3434'
294 0.0004 0.00038814544677734 
SELECT * FROM productcustomimages WHERE product_id = '3434'
295 0.0006 0.0006101131439209 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3434'
                GROUP BY o.product_id
296 0.0011 0.0010709762573242 
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     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
297 0.0005 0.00050187110900879 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
298 0.0010 0.0010201930999756 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
299 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00038290023803711 
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
302 0.0003 0.00033903121948242 
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
303 0.0005 0.0004730224609375 
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 = '3434'
                GROUP BY o.product_id
304 0.0010 0.0010330677032471 
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     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
305 0.0006 0.00061893463134766 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
306 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0009 0.00091695785522461 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
308 0.0008 0.000762939453125 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
309 0.0005 0.00047779083251953 
SELECT * FROM productimages WHERE product_id = '3744' ORDER BY sortorder ASC
310 0.0006 0.00063109397888184 
SELECT * FROM product_image_select WHERE product_id = '3744'
311 0.0004 0.00040006637573242 
SELECT * FROM productcustomimages WHERE product_id = '3744'
312 0.0010 0.00098609924316406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
313 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
314 0.0003 0.00033378601074219 
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
315 0.0003 0.00028109550476074 
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
316 0.0003 0.00032806396484375 
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
317 0.0004 0.00035691261291504 
SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0005 0.00046515464782715 
SELECT * FROM productimages WHERE product_id = '980' ORDER BY sortorder ASC
319 0.0007 0.00067591667175293 
SELECT * FROM product_image_select WHERE product_id = '980'
320 0.0023 0.0022721290588379 
SELECT * FROM productcustomimages WHERE product_id = '980'
321 0.0029 0.0028860569000244 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '980' AND a.name = n.originalname
322 0.0025 0.0025069713592529 
SELECT * FROM productoffers WHERE product_id = '980' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0022 0.0021800994873047 
SELECT * FROM productoffers
                WHERE product_id = '980' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0008 0.00077605247497559 
SELECT value FROM productattributes WHERE product_id = '980' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0006 0.00055789947509766 
SELECT * FROM productimages WHERE product_id = '973' ORDER BY sortorder ASC
326 0.0008 0.00084686279296875 
SELECT * FROM product_image_select WHERE product_id = '973'
327 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '973'
328 0.0010 0.00097799301147461 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '973' AND a.name = n.originalname
329 0.0005 0.00052499771118164 
SELECT * FROM productoffers WHERE product_id = '973' AND merchantid = 'A1X6FK5RDHNB96'
330 0.0004 0.00037884712219238 
SELECT * FROM productoffers
                WHERE product_id = '973' AND price > 0
                ORDER BY price ASC LIMIT 1
331 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = 973
                ORDER BY price ASC LIMIT 1
332 0.0005 0.00045299530029297 
SELECT value FROM productattributes
                WHERE product_id = '973'
                AND name = 'ListPriceAmount'
333 0.0005 0.00050806999206543 
SELECT value FROM productattributes WHERE product_id = '973' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0006 0.00059890747070312 
SELECT * FROM productimages WHERE product_id = '4325' ORDER BY sortorder ASC
335 0.0008 0.00075197219848633 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4325' AND p.id = pi.product_id ORDER BY pi.sortorder
336 0.0008 0.000762939453125 
SELECT * FROM product_image_select WHERE product_id = '4325'
337 0.0004 0.00041508674621582 
SELECT * FROM productcustomimages WHERE product_id = '4325'
338 0.0008 0.00078392028808594 
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 = '4325'
                GROUP BY o.product_id
339 0.0008 0.00079894065856934 
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     = '4325'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
340 0.0011 0.0010669231414795 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4325
341 0.0017 0.0017249584197998 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4325' AND a.name = n.originalname
342 0.0006 0.00064396858215332 
SELECT * FROM productoffers WHERE product_id = '4325' AND merchantid = 'A1X6FK5RDHNB96'
343 0.0004 0.00038719177246094 
SELECT * FROM productoffers
                WHERE product_id = '4325' AND price > 0
                ORDER BY price ASC LIMIT 1
344 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = 4325
                ORDER BY price ASC LIMIT 1
345 0.0008 0.00082588195800781 
SELECT value FROM productattributes
                WHERE product_id = '4325'
                AND name = 'ListPriceAmount'
346 0.0013 0.0013000965118408 
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 = '4325'
                GROUP BY o.product_id
347 0.0008 0.00079512596130371 
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     = '4325'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
348 0.0004 0.0004429817199707 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4325
349 0.0007 0.00067901611328125 
SELECT value FROM productattributes WHERE product_id = '4325' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350 0.0005 0.00050210952758789 
SELECT * FROM products WHERE parent_id = '4325'
351 0.0007 0.00070595741271973 
SELECT * FROM productimages WHERE product_id = '3047' ORDER BY sortorder ASC
352 0.0008 0.00076508522033691 
SELECT * FROM product_image_select WHERE product_id = '3047'
353 0.0005 0.00047612190246582 
SELECT * FROM productcustomimages WHERE product_id = '3047'
354 0.0016 0.001615047454834 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3047' AND a.name = n.originalname
355 0.0005 0.00053787231445312 
SELECT * FROM productoffers WHERE product_id = '3047' AND merchantid = 'A1X6FK5RDHNB96'
356 0.0005 0.00049304962158203 
SELECT * FROM productoffers
                WHERE product_id = '3047' AND price > 0
                ORDER BY price ASC LIMIT 1
357 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = 3047
                ORDER BY price ASC LIMIT 1
358 0.0004 0.00041484832763672 
SELECT value FROM productattributes
                WHERE product_id = '3047'
                AND name = 'ListPriceAmount'
359 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '3047' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0010 0.0009920597076416 
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
361 0.0007 0.00070095062255859 
SELECT * FROM product_image_select WHERE product_id = '1418'
362 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '1418'
363 0.0017 0.0017368793487549 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
364 0.0006 0.00055694580078125 
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
365 0.0005 0.00046586990356445 
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
366 0.0005 0.00048208236694336 
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367 0.0006 0.00056600570678711 
SELECT * FROM productimages WHERE product_id = '2136' ORDER BY sortorder ASC
368 0.0007 0.00068998336791992 
SELECT * FROM product_image_select WHERE product_id = '2136'
369 0.0004 0.00044703483581543 
SELECT * FROM productcustomimages WHERE product_id = '2136'
370 0.0013 0.0012648105621338 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2136' AND a.name = n.originalname
371 0.0005 0.00049996376037598 
SELECT * FROM productoffers WHERE product_id = '2136' AND merchantid = 'A1X6FK5RDHNB96'
372 0.0004 0.00037980079650879 
SELECT * FROM productoffers
                WHERE product_id = '2136' AND price > 0
                ORDER BY price ASC LIMIT 1
373 0.0003 0.00033783912658691 
SELECT * FROM productoffers
                WHERE product_id = 2136
                ORDER BY price ASC LIMIT 1
374 0.0004 0.00038814544677734 
SELECT value FROM productattributes
                WHERE product_id = '2136'
                AND name = 'ListPriceAmount'
375 0.0005 0.00046205520629883 
SELECT value FROM productattributes WHERE product_id = '2136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
376 0.0006 0.00058317184448242 
SELECT * FROM productimages WHERE product_id = '2225' ORDER BY sortorder ASC
377 0.0007 0.00067996978759766 
SELECT * FROM product_image_select WHERE product_id = '2225'
378 0.0004 0.00042510032653809 
SELECT * FROM productcustomimages WHERE product_id = '2225'
379 0.0017 0.0016520023345947 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2225' AND a.name = n.originalname
380 0.0005 0.00050806999206543 
SELECT * FROM productoffers WHERE product_id = '2225' AND merchantid = 'A1X6FK5RDHNB96'
381 0.0004 0.00042200088500977 
SELECT * FROM productoffers
                WHERE product_id = '2225' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0004 0.00036287307739258 
SELECT * FROM productoffers
                WHERE product_id = 2225
                ORDER BY price ASC LIMIT 1
383 0.0004 0.00038790702819824 
SELECT value FROM productattributes
                WHERE product_id = '2225'
                AND name = 'ListPriceAmount'
384 0.0005 0.00052499771118164 
SELECT value FROM productattributes WHERE product_id = '2225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
385 0.0006 0.00057816505432129 
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
386 0.0008 0.00076103210449219 
SELECT * FROM product_image_select WHERE product_id = '4917'
387 0.0004 0.00041818618774414 
SELECT * FROM productcustomimages WHERE product_id = '4917'
388 0.0019 0.0018939971923828 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
389 0.0006 0.00062203407287598 
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
390 0.0004 0.00041818618774414 
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
391 0.0005 0.00050616264343262 
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
392 0.0005 0.00054407119750977 
SELECT * FROM productimages WHERE product_id = '4916' ORDER BY sortorder ASC
393 0.0007 0.00070905685424805 
SELECT * FROM product_image_select WHERE product_id = '4916'
394 0.0005 0.00045919418334961 
SELECT * FROM productcustomimages WHERE product_id = '4916'
395 0.0019 0.0018658638000488 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4916' AND a.name = n.originalname
396 0.0005 0.00051403045654297 
SELECT * FROM productoffers WHERE product_id = '4916' AND merchantid = 'A1X6FK5RDHNB96'
397 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = '4916' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = 4916
                ORDER BY price ASC LIMIT 1
399 0.0004 0.00040388107299805 
SELECT value FROM productattributes
                WHERE product_id = '4916'
                AND name = 'ListPriceAmount'
400 0.0005 0.00051093101501465 
SELECT value FROM productattributes WHERE product_id = '4916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0005 0.00049996376037598 
SELECT * FROM productimages WHERE product_id = '1006' ORDER BY sortorder ASC
402 0.0008 0.00076198577880859 
SELECT * FROM product_image_select WHERE product_id = '1006'
403 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '1006'
404 0.0019 0.0018599033355713 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1006' AND a.name = n.originalname
405 0.0006 0.00055503845214844 
SELECT * FROM productoffers WHERE product_id = '1006' AND merchantid = 'A1X6FK5RDHNB96'
406 0.0004 0.00043487548828125 
SELECT * FROM productoffers
                WHERE product_id = '1006' AND price > 0
                ORDER BY price ASC LIMIT 1
407 0.0004 0.00037288665771484 
SELECT * FROM productoffers
                WHERE product_id = 1006
                ORDER BY price ASC LIMIT 1
408 0.0005 0.0005028247833252 
SELECT value FROM productattributes
                WHERE product_id = '1006'
                AND name = 'ListPriceAmount'
409 0.0006 0.00056791305541992 
SELECT value FROM productattributes WHERE product_id = '1006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
410 0.0006 0.00059890747070312 
SELECT * FROM productimages WHERE product_id = '1261' ORDER BY sortorder ASC
411 0.0008 0.00079107284545898 
SELECT * FROM product_image_select WHERE product_id = '1261'
412 0.0005 0.00048995018005371 
SELECT * FROM productcustomimages WHERE product_id = '1261'
413 0.0017 0.0017361640930176 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1261' AND a.name = n.originalname
414 0.0006 0.00059604644775391 
SELECT * FROM productoffers WHERE product_id = '1261' AND merchantid = 'A1X6FK5RDHNB96'
415 0.0004 0.00044393539428711 
SELECT * FROM productoffers
                WHERE product_id = '1261' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = 1261
                ORDER BY price ASC LIMIT 1
417 0.0005 0.00046396255493164 
SELECT value FROM productattributes
                WHERE product_id = '1261'
                AND name = 'ListPriceAmount'
418 0.0005 0.00054812431335449 
SELECT value FROM productattributes WHERE product_id = '1261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
419 0.0007 0.000701904296875 
SELECT * FROM productimages WHERE product_id = '891' ORDER BY sortorder ASC
420 0.0008 0.00079584121704102 
SELECT * FROM product_image_select WHERE product_id = '891'
421 0.0005 0.0005040168762207 
SELECT * FROM productcustomimages WHERE product_id = '891'
422 0.0015 0.0014691352844238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '891' AND a.name = n.originalname
423 0.0011 0.0010931491851807 
SELECT * FROM productoffers WHERE product_id = '891' AND merchantid = 'A1X6FK5RDHNB96'
424 0.0008 0.00083613395690918 
SELECT * FROM productoffers
                WHERE product_id = '891' AND price > 0
                ORDER BY price ASC LIMIT 1
425 0.0006 0.00063490867614746 
SELECT * FROM productoffers
                WHERE product_id = 891
                ORDER BY price ASC LIMIT 1
426 0.0007 0.00074577331542969 
SELECT value FROM productattributes
                WHERE product_id = '891'
                AND name = 'ListPriceAmount'
427 0.0008 0.0008089542388916 
SELECT value FROM productattributes WHERE product_id = '891' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
428 0.0010 0.00095295906066895 
SELECT * FROM productimages WHERE product_id = '1400' ORDER BY sortorder ASC
429 0.0014 0.001410961151123 
SELECT * FROM product_image_select WHERE product_id = '1400'
430 0.0007 0.0007169246673584 
SELECT * FROM productcustomimages WHERE product_id = '1400'
431 0.0028 0.0028128623962402 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname
432 0.0009 0.00087499618530273 
SELECT * FROM productoffers WHERE product_id = '1400' AND merchantid = 'A1X6FK5RDHNB96'
433 0.0006 0.00061893463134766 
SELECT * FROM productoffers
                WHERE product_id = '1400' AND price > 0
                ORDER BY price ASC LIMIT 1
434 0.0006 0.0005500316619873 
SELECT * FROM productoffers
                WHERE product_id = 1400
                ORDER BY price ASC LIMIT 1
435 0.0008 0.0007929801940918 
SELECT value FROM productattributes
                WHERE product_id = '1400'
                AND name = 'ListPriceAmount'
436 0.0010 0.00097894668579102 
SELECT value FROM productattributes WHERE product_id = '1400' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
437 0.0009 0.00086212158203125 
SELECT * FROM productimages WHERE product_id = '946' ORDER BY sortorder ASC
438 0.0013 0.0012879371643066 
SELECT * FROM product_image_select WHERE product_id = '946'
439 0.0006 0.00063896179199219 
SELECT * FROM productcustomimages WHERE product_id = '946'
440 0.0024 0.0024039745330811 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '946' AND a.name = n.originalname
441 0.0008 0.00081992149353027 
SELECT * FROM productoffers WHERE product_id = '946' AND merchantid = 'A1X6FK5RDHNB96'
442 0.0006 0.00059986114501953 
SELECT * FROM productoffers
                WHERE product_id = '946' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0005 0.00053596496582031 
SELECT * FROM productoffers
                WHERE product_id = 946
                ORDER BY price ASC LIMIT 1
444 0.0007 0.00073099136352539 
SELECT value FROM productattributes
                WHERE product_id = '946'
                AND name = 'ListPriceAmount'
445 0.0008 0.00076484680175781 
SELECT value FROM productattributes WHERE product_id = '946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446 0.0008 0.00082802772521973 
SELECT * FROM productimages WHERE product_id = '1225' ORDER BY sortorder ASC
447 0.0012 0.0011608600616455 
SELECT * FROM product_image_select WHERE product_id = '1225'
448 0.0007 0.00066590309143066 
SELECT * FROM productcustomimages WHERE product_id = '1225'
449 0.0013 0.0012838840484619 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1225' AND a.name = n.originalname
450 0.0005 0.00052499771118164 
SELECT * FROM productoffers WHERE product_id = '1225' AND merchantid = 'A1X6FK5RDHNB96'
451 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '1225' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00038385391235352 
SELECT * FROM productoffers
                WHERE product_id = 1225
                ORDER BY price ASC LIMIT 1
453 0.0004 0.00037884712219238 
SELECT value FROM productattributes
                WHERE product_id = '1225'
                AND name = 'ListPriceAmount'
454 0.0004 0.00043511390686035 
SELECT value FROM productattributes WHERE product_id = '1225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
456 0.0008 0.00076198577880859 
SELECT * FROM product_image_select WHERE product_id = '889'
457 0.0005 0.00045204162597656 
SELECT * FROM productcustomimages WHERE product_id = '889'
458 0.0008 0.00082802772521973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
459 0.0005 0.00046801567077637 
SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
460 0.0005 0.00049519538879395 
SELECT * FROM productoffers
                WHERE product_id = '889' AND price > 0
                ORDER BY price ASC LIMIT 1
461 0.0004 0.00044798851013184 
SELECT * FROM productoffers
                WHERE product_id = 889
                ORDER BY price ASC LIMIT 1
462 0.0007 0.00067591667175293 
SELECT value FROM productattributes
                WHERE product_id = '889'
                AND name = 'ListPriceAmount'
463 0.0007 0.00067806243896484 
SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
464 0.0006 0.00062108039855957 
SELECT * FROM productimages WHERE product_id = '3676' ORDER BY sortorder ASC
465 0.0007 0.0006871223449707 
SELECT * FROM product_image_select WHERE product_id = '3676'
466 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '3676'
467 0.0007 0.00071597099304199 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
468 0.0005 0.0004889965057373 
SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
469 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = '3676' AND price > 0
                ORDER BY price ASC LIMIT 1
470 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = 3676
                ORDER BY price ASC LIMIT 1
471 0.0004 0.0003669261932373 
SELECT value FROM productattributes
                WHERE product_id = '3676'
                AND name = 'ListPriceAmount'
472 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '3676' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0005 0.00045204162597656 
SELECT * FROM productimages WHERE product_id = '1529' ORDER BY sortorder ASC
474 0.0006 0.00055098533630371 
SELECT * FROM product_image_select WHERE product_id = '1529'
475 0.0004 0.00036311149597168 
SELECT * FROM productcustomimages WHERE product_id = '1529'
476 0.0007 0.00067806243896484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1529' AND a.name = n.originalname
477 0.0005 0.00048398971557617 
SELECT * FROM productoffers WHERE product_id = '1529' AND merchantid = 'A1X6FK5RDHNB96'
478 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = '1529' AND price > 0
                ORDER BY price ASC LIMIT 1
479 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = 1529
                ORDER BY price ASC LIMIT 1
480 0.0004 0.00037193298339844 
SELECT value FROM productattributes
                WHERE product_id = '1529'
                AND name = 'ListPriceAmount'
481 0.0004 0.00040483474731445 
SELECT value FROM productattributes WHERE product_id = '1529' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0005 0.00045680999755859 
SELECT * FROM productimages WHERE product_id = '1543' ORDER BY sortorder ASC
483 0.0006 0.00060892105102539 
SELECT * FROM product_image_select WHERE product_id = '1543'
484 0.0004 0.00043487548828125 
SELECT * FROM productcustomimages WHERE product_id = '1543'
485 0.0011 0.0010871887207031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1543' AND a.name = n.originalname
486 0.0005 0.00053191184997559 
SELECT * FROM productoffers WHERE product_id = '1543' AND merchantid = 'A1X6FK5RDHNB96'
487 0.0004 0.0004420280456543 
SELECT * FROM productoffers
                WHERE product_id = '1543' AND price > 0
                ORDER BY price ASC LIMIT 1
488 0.0005 0.00050497055053711 
SELECT value FROM productattributes WHERE product_id = '1543' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
489 0.0005 0.00051999092102051 
SELECT * FROM productimages WHERE product_id = '4163' ORDER BY sortorder ASC
490 0.0006 0.00058794021606445 
SELECT * FROM product_image_select WHERE product_id = '4163'
491 0.0004 0.00039196014404297 
SELECT * FROM productcustomimages WHERE product_id = '4163'
492 0.0008 0.00075411796569824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4163' AND a.name = n.originalname
493 0.0007 0.00070500373840332 
SELECT * FROM productoffers WHERE product_id = '4163' AND merchantid = 'A1X6FK5RDHNB96'
494 0.0005 0.00049686431884766 
SELECT * FROM productoffers
                WHERE product_id = '4163' AND price > 0
                ORDER BY price ASC LIMIT 1
495 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = 4163
                ORDER BY price ASC LIMIT 1
496 0.0005 0.00049400329589844 
SELECT value FROM productattributes
                WHERE product_id = '4163'
                AND name = 'ListPriceAmount'
497 0.0005 0.00050783157348633 
SELECT value FROM productattributes WHERE product_id = '4163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
498 0.0006 0.00059199333190918 
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
499 0.0007 0.0007469654083252 
SELECT * FROM product_image_select WHERE product_id = '4933'
500 0.0005 0.00052905082702637 
SELECT * FROM productcustomimages WHERE product_id = '4933'
501 0.0014 0.0013618469238281 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
502 0.0006 0.00058603286743164 
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
503 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0005 0.00054097175598145 
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
505 0.0006 0.00064301490783691 
SELECT * FROM productimages WHERE product_id = '4291' ORDER BY sortorder ASC
506 0.0007 0.00068306922912598 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4291' AND p.id = pi.product_id ORDER BY pi.sortorder
507 0.0008 0.00082087516784668 
SELECT * FROM product_image_select WHERE product_id = '4291'
508 0.0005 0.00047683715820312 
SELECT * FROM productcustomimages WHERE product_id = '4291'
509 0.0007 0.00066304206848145 
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 = '4291'
                GROUP BY o.product_id
510 0.0008 0.00078701972961426 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
511 0.0005 0.00047588348388672 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
512 0.0017 0.0017249584197998 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4291' AND a.name = n.originalname
513 0.0005 0.00045680999755859 
SELECT * FROM productoffers WHERE product_id = '4291' AND merchantid = 'A1X6FK5RDHNB96'
514 0.0005 0.00052285194396973 
SELECT * FROM productoffers
                WHERE product_id = '4291' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0004 0.00039482116699219 
SELECT * FROM productoffers
                WHERE product_id = 4291
                ORDER BY price ASC LIMIT 1
516 0.0005 0.00048112869262695 
SELECT value FROM productattributes
                WHERE product_id = '4291'
                AND name = 'ListPriceAmount'
517 0.0005 0.00046992301940918 
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 = '4291'
                GROUP BY o.product_id
518 0.0008 0.0007941722869873 
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     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
519 0.0006 0.00064802169799805 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
520 0.0006 0.00062704086303711 
SELECT value FROM productattributes WHERE product_id = '4291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0004 0.00044012069702148 
SELECT * FROM products WHERE parent_id = '4291'
522 0.0005 0.00052809715270996 
SELECT * FROM productimages WHERE product_id = '3406' ORDER BY sortorder ASC
523 0.0007 0.00067400932312012 
SELECT * FROM product_image_select WHERE product_id = '3406'
524 0.0004 0.00043201446533203 
SELECT * FROM productcustomimages WHERE product_id = '3406'
525 0.0012 0.0012369155883789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3406' AND a.name = n.originalname
526 0.0006 0.0006260871887207 
SELECT * FROM productoffers WHERE product_id = '3406' AND merchantid = 'A1X6FK5RDHNB96'
527 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '3406' AND price > 0
                ORDER BY price ASC LIMIT 1
528 0.0004 0.00036406517028809 
SELECT * FROM productoffers
                WHERE product_id = 3406
                ORDER BY price ASC LIMIT 1
529 0.0004 0.00039100646972656 
SELECT value FROM productattributes
                WHERE product_id = '3406'
                AND name = 'ListPriceAmount'
530 0.0005 0.00053691864013672 
SELECT value FROM productattributes WHERE product_id = '3406' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
531 0.0005 0.00054311752319336 
SELECT * FROM productimages WHERE product_id = '4672' ORDER BY sortorder ASC
532 0.0007 0.00069808959960938 
SELECT * FROM product_image_select WHERE product_id = '4672'
533 0.0004 0.00042986869812012 
SELECT * FROM productcustomimages WHERE product_id = '4672'
534 0.0017 0.001680850982666 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4672' AND a.name = n.originalname
535 0.0007 0.00068306922912598 
SELECT * FROM productoffers WHERE product_id = '4672' AND merchantid = 'A1X6FK5RDHNB96'
536 0.0004 0.00038886070251465 
SELECT * FROM productoffers
                WHERE product_id = '4672' AND price > 0
                ORDER BY price ASC LIMIT 1
537 0.0003 0.00032210350036621 
SELECT * FROM productoffers
                WHERE product_id = 4672
                ORDER BY price ASC LIMIT 1
538 0.0004 0.00039315223693848 
SELECT value FROM productattributes
                WHERE product_id = '4672'
                AND name = 'ListPriceAmount'
539 0.0004 0.00038790702819824 
SELECT value FROM productattributes WHERE product_id = '4672' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
540 0.0004 0.0004429817199707 
SELECT * FROM productimages WHERE product_id = '2830' ORDER BY sortorder ASC
541 0.0006 0.00059008598327637 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2830' AND p.id = pi.product_id ORDER BY pi.sortorder
542 0.0007 0.00066709518432617 
SELECT * FROM product_image_select WHERE product_id = '2830'
543 0.0004 0.00040292739868164 
SELECT * FROM productcustomimages WHERE product_id = '2830'
544 0.0006 0.00056314468383789 
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 = '2830'
                GROUP BY o.product_id
545 0.0006 0.00061893463134766 
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     = '2830'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
546 0.0004 0.00040102005004883 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2830
547 0.0010 0.0010011196136475 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2830' AND a.name = n.originalname
548 0.0004 0.00035905838012695 
SELECT * FROM productoffers WHERE product_id = '2830' AND merchantid = 'A1X6FK5RDHNB96'
549 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = '2830' AND price > 0
                ORDER BY price ASC LIMIT 1
550 0.0003 0.00029897689819336 
SELECT * FROM productoffers
                WHERE product_id = 2830
                ORDER BY price ASC LIMIT 1
551 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '2830'
                AND name = 'ListPriceAmount'
552 0.0004 0.00041508674621582 
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 = '2830'
                GROUP BY o.product_id
553 0.0007 0.00066113471984863 
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     = '2830'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
554 0.0004 0.0003819465637207 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2830
555 0.0005 0.00049304962158203 
SELECT value FROM productattributes WHERE product_id = '2830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
556 0.0009 0.00085282325744629 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2830'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
557 0.0004 0.00044798851013184 
SELECT * FROM products WHERE parent_id = '2830'
558 0.0006 0.00058102607727051 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4770' AND a.name = n.originalname
559 0.0004 0.00043082237243652 
SELECT * FROM productoffers WHERE product_id = '4770' AND merchantid = 'A1X6FK5RDHNB96'
560 0.0004 0.00037002563476562 
SELECT * FROM productoffers
                WHERE product_id = '4770' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = 4770
                ORDER BY price ASC LIMIT 1
562 0.0004 0.00035405158996582 
SELECT value FROM productattributes
                WHERE product_id = '4770'
                AND name = 'ListPriceAmount'
563 0.0005 0.00046586990356445 
SELECT * FROM productimages WHERE product_id = '2912' ORDER BY sortorder ASC
564 0.0005 0.00049591064453125 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2912' AND p.id = pi.product_id ORDER BY pi.sortorder
565 0.0006 0.00061798095703125 
SELECT * FROM product_image_select WHERE product_id = '2912'
566 0.0004 0.00037503242492676 
SELECT * FROM productcustomimages WHERE product_id = '2912'
567 0.0005 0.00046706199645996 
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 = '2912'
                GROUP BY o.product_id
568 0.0006 0.0005958080291748 
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     = '2912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
569 0.0004 0.00039482116699219 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2912
570 0.0009 0.00087404251098633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2912' AND a.name = n.originalname
571 0.0003 0.00034618377685547 
SELECT * FROM productoffers WHERE product_id = '2912' AND merchantid = 'A1X6FK5RDHNB96'
572 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = '2912' AND price > 0
                ORDER BY price ASC LIMIT 1
573 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = 2912
                ORDER BY price ASC LIMIT 1
574 0.0003 0.00033211708068848 
SELECT value FROM productattributes
                WHERE product_id = '2912'
                AND name = 'ListPriceAmount'
575 0.0004 0.00037288665771484 
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 = '2912'
                GROUP BY o.product_id
576 0.0006 0.00059103965759277 
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     = '2912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
577 0.0004 0.00037598609924316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2912
578 0.0008 0.00075793266296387 
SELECT value FROM productattributes WHERE product_id = '2912' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
579 0.0005 0.00048518180847168 
SELECT * FROM products WHERE parent_id = '2912'
580 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '2941' ORDER BY sortorder ASC
581 0.0004 0.00038719177246094 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2941' AND p.id = pi.product_id ORDER BY pi.sortorder
582 0.0007 0.00066900253295898 
SELECT * FROM product_image_select WHERE product_id = '2941'
583 0.0004 0.00040912628173828 
SELECT * FROM productcustomimages WHERE product_id = '2941'
584 0.0005 0.00052881240844727 
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 = '2941'
                GROUP BY o.product_id
585 0.0006 0.00061607360839844 
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     = '2941'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
586 0.0004 0.00037598609924316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
587 0.0010 0.0010380744934082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2941' AND a.name = n.originalname
588 0.0004 0.00035977363586426 
SELECT * FROM productoffers WHERE product_id = '2941' AND merchantid = 'A1X6FK5RDHNB96'
589 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = '2941' AND price > 0
                ORDER BY price ASC LIMIT 1
590 0.0003 0.00030708312988281 
SELECT * FROM productoffers
                WHERE product_id = 2941
                ORDER BY price ASC LIMIT 1
591 0.0003 0.00034308433532715 
SELECT value FROM productattributes
                WHERE product_id = '2941'
                AND name = 'ListPriceAmount'
592 0.0004 0.00040698051452637 
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 = '2941'
                GROUP BY o.product_id
593 0.0007 0.00068092346191406 
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     = '2941'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
594 0.0004 0.0003809928894043 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
595 0.0005 0.00049805641174316 
SELECT value FROM productattributes WHERE product_id = '2941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
596 0.0003 0.00034999847412109 
SELECT * FROM products WHERE parent_id = '2941'
597 0.0005 0.00046801567077637 
SELECT * FROM productimages WHERE product_id = '2942' ORDER BY sortorder ASC
598 0.0004 0.0003960132598877 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2942' AND p.id = pi.product_id ORDER BY pi.sortorder
599 0.0007 0.00065207481384277 
SELECT * FROM product_image_select WHERE product_id = '2942'
600 0.0004 0.00038504600524902 
SELECT * FROM productcustomimages WHERE product_id = '2942'
601 0.0005 0.00046682357788086 
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 = '2942'
                GROUP BY o.product_id
602 0.0006 0.00055408477783203 
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     = '2942'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
603 0.0004 0.00043106079101562 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
604 0.0010 0.0010061264038086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2942' AND a.name = n.originalname
605 0.0003 0.00032901763916016 
SELECT * FROM productoffers WHERE product_id = '2942' AND merchantid = 'A1X6FK5RDHNB96'
606 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = '2942' AND price > 0
                ORDER BY price ASC LIMIT 1
607 0.0003 0.0003049373626709 
SELECT * FROM productoffers
                WHERE product_id = 2942
                ORDER BY price ASC LIMIT 1
608 0.0004 0.00035786628723145 
SELECT value FROM productattributes
                WHERE product_id = '2942'
                AND name = 'ListPriceAmount'
609 0.0004 0.00038504600524902 
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 = '2942'
                GROUP BY o.product_id
610 0.0006 0.00062894821166992 
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     = '2942'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
611 0.0004 0.00037097930908203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
612 0.0005 0.00049304962158203 
SELECT value FROM productattributes WHERE product_id = '2942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0004 0.00035595893859863 
SELECT * FROM products WHERE parent_id = '2942'
614 0.0005 0.00051999092102051 
SELECT * FROM productimages WHERE product_id = '2810' ORDER BY sortorder ASC
615 0.0004 0.00041413307189941 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2810' AND p.id = pi.product_id ORDER BY pi.sortorder
616 0.0006 0.00062298774719238 
SELECT * FROM product_image_select WHERE product_id = '2810'
617 0.0004 0.00039815902709961 
SELECT * FROM productcustomimages WHERE product_id = '2810'
618 0.0005 0.00052213668823242 
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 = '2810'
                GROUP BY o.product_id
619 0.0006 0.00056004524230957 
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     = '2810'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
620 0.0003 0.00034403800964355 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2810
621 0.0010 0.0010418891906738 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2810' AND a.name = n.originalname
622 0.0004 0.00037813186645508 
SELECT * FROM productoffers WHERE product_id = '2810' AND merchantid = 'A1X6FK5RDHNB96'
623 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = '2810' AND price > 0
                ORDER BY price ASC LIMIT 1
624 0.0003 0.00033402442932129 
SELECT * FROM productoffers
                WHERE product_id = 2810
                ORDER BY price ASC LIMIT 1
625 0.0004 0.00037598609924316 
SELECT value FROM productattributes
                WHERE product_id = '2810'
                AND name = 'ListPriceAmount'
626 0.0004 0.00038003921508789 
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 = '2810'
                GROUP BY o.product_id
627 0.0006 0.0006248950958252 
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     = '2810'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
628 0.0004 0.00037503242492676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2810
629 0.0005 0.00051283836364746 
SELECT value FROM productattributes WHERE product_id = '2810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
630 0.0004 0.00035810470581055 
SELECT * FROM products WHERE parent_id = '2810'
631 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '2943' ORDER BY sortorder ASC
632 0.0004 0.00036501884460449 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2943' AND p.id = pi.product_id ORDER BY pi.sortorder
633 0.0006 0.00060582160949707 
SELECT * FROM product_image_select WHERE product_id = '2943'
634 0.0004 0.00040984153747559 
SELECT * FROM productcustomimages WHERE product_id = '2943'
635 0.0005 0.00051498413085938 
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 = '2943'
                GROUP BY o.product_id
636 0.0006 0.00056815147399902 
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     = '2943'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
637 0.0004 0.00036787986755371 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2943
638 0.0010 0.0010068416595459 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2943' AND a.name = n.originalname
639 0.0003 0.00034713745117188 
SELECT * FROM productoffers WHERE product_id = '2943' AND merchantid = 'A1X6FK5RDHNB96'
640 0.0003 0.00033807754516602 
SELECT * FROM productoffers
                WHERE product_id = '2943' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0003 0.00029516220092773 
SELECT * FROM productoffers
                WHERE product_id = 2943
                ORDER BY price ASC LIMIT 1
642 0.0004 0.00043010711669922 
SELECT value FROM productattributes
                WHERE product_id = '2943'
                AND name = 'ListPriceAmount'
643 0.0004 0.00042200088500977 
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 = '2943'
                GROUP BY o.product_id
644 0.0007 0.0006709098815918 
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     = '2943'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
645 0.0005 0.00045108795166016 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2943
646 0.0006 0.00056815147399902 
SELECT value FROM productattributes WHERE product_id = '2943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
647 0.0005 0.00046896934509277 
SELECT * FROM products WHERE parent_id = '2943'
648 0.0006 0.00055217742919922 
SELECT * FROM productimages WHERE product_id = '2949' ORDER BY sortorder ASC
649 0.0005 0.0005190372467041 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2949' AND p.id = pi.product_id ORDER BY pi.sortorder
650 0.0008 0.00079107284545898 
SELECT * FROM product_image_select WHERE product_id = '2949'
651 0.0005 0.00049591064453125 
SELECT * FROM productcustomimages WHERE product_id = '2949'
652 0.0005 0.00054001808166504 
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 = '2949'
                GROUP BY o.product_id
653 0.0007 0.0006721019744873 
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     = '2949'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
654 0.0004 0.00037908554077148 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2949
655 0.0011 0.0010521411895752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2949' AND a.name = n.originalname
656 0.0004 0.00039482116699219 
SELECT * FROM productoffers WHERE product_id = '2949' AND merchantid = 'A1X6FK5RDHNB96'
657 0.0004 0.00037479400634766 
SELECT * FROM productoffers
                WHERE product_id = '2949' AND price > 0
                ORDER BY price ASC LIMIT 1
658 0.0004 0.0003819465637207 
SELECT * FROM productoffers
                WHERE product_id = 2949
                ORDER BY price ASC LIMIT 1
659 0.0004 0.00037407875061035 
SELECT value FROM productattributes
                WHERE product_id = '2949'
                AND name = 'ListPriceAmount'
660 0.0004 0.00039482116699219 
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 = '2949'
                GROUP BY o.product_id
661 0.0006 0.00058722496032715 
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     = '2949'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
662 0.0004 0.00037097930908203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2949
663 0.0005 0.00052404403686523 
SELECT value FROM productattributes WHERE product_id = '2949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
664 0.0011 0.0010659694671631 
SELECT * FROM products WHERE parent_id = '2949'
665 0.0006 0.00057220458984375 
SELECT * FROM productimages WHERE product_id = '2728' ORDER BY sortorder ASC
666 0.0005 0.00046205520629883 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2728' AND p.id = pi.product_id ORDER BY pi.sortorder
667 0.0006 0.00063800811767578 
SELECT * FROM product_image_select WHERE product_id = '2728'
668 0.0004 0.00040197372436523 
SELECT * FROM productcustomimages WHERE product_id = '2728'
669 0.0005 0.00049996376037598 
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 = '2728'
                GROUP BY o.product_id
670 0.0006 0.00056815147399902 
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     = '2728'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
671 0.0004 0.00037503242492676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2728
672 0.0010 0.00099706649780273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2728' AND a.name = n.originalname
673 0.0003 0.00034093856811523 
SELECT * FROM productoffers WHERE product_id = '2728' AND merchantid = 'A1X6FK5RDHNB96'
674 0.0004 0.0003509521484375 
SELECT * FROM productoffers
                WHERE product_id = '2728' AND price > 0
                ORDER BY price ASC LIMIT 1
675 0.0003 0.00029110908508301 
SELECT * FROM productoffers
                WHERE product_id = 2728
                ORDER BY price ASC LIMIT 1
676 0.0003 0.00033998489379883 
SELECT value FROM productattributes
                WHERE product_id = '2728'
                AND name = 'ListPriceAmount'
677 0.0004 0.00038290023803711 
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 = '2728'
                GROUP BY o.product_id
678 0.0006 0.00056910514831543 
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     = '2728'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
679 0.0004 0.00037002563476562 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2728
680 0.0005 0.00049495697021484 
SELECT value FROM productattributes WHERE product_id = '2728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0004 0.00035309791564941 
SELECT * FROM products WHERE parent_id = '2728'
682 0.0005 0.0005490779876709 
SELECT * FROM productimages WHERE product_id = '2852' ORDER BY sortorder ASC
683 0.0004 0.00041484832763672 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2852' AND p.id = pi.product_id ORDER BY pi.sortorder
684 0.0006 0.00063586235046387 
SELECT * FROM product_image_select WHERE product_id = '2852'
685 0.0004 0.00037884712219238 
SELECT * FROM productcustomimages WHERE product_id = '2852'
686 0.0005 0.00048589706420898 
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 = '2852'
                GROUP BY o.product_id
687 0.0006 0.00058197975158691 
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     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
688 0.0004 0.00036907196044922 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2852
689 0.0014 0.0013790130615234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2852' AND a.name = n.originalname
690 0.0006 0.00056219100952148 
SELECT * FROM productoffers WHERE product_id = '2852' AND merchantid = 'A1X6FK5RDHNB96'
691 0.0005 0.00053596496582031 
SELECT * FROM productoffers
                WHERE product_id = '2852' AND price > 0
                ORDER BY price ASC LIMIT 1
692 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = 2852
                ORDER BY price ASC LIMIT 1
693 0.0005 0.00053787231445312 
SELECT value FROM productattributes
                WHERE product_id = '2852'
                AND name = 'ListPriceAmount'
694 0.0005 0.00052404403686523 
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 = '2852'
                GROUP BY o.product_id
695 0.0010 0.00095510482788086 
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     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
696 0.0006 0.00063395500183105 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2852
697 0.0007 0.00066900253295898 
SELECT value FROM productattributes WHERE product_id = '2852' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
698 0.0004 0.00039911270141602 
SELECT * FROM products WHERE parent_id = '2852'
699 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '2985' ORDER BY sortorder ASC
700 0.0005 0.00045299530029297 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2985' AND p.id = pi.product_id ORDER BY pi.sortorder
701 0.0007 0.00072288513183594 
SELECT * FROM product_image_select WHERE product_id = '2985'
702 0.0006 0.00058817863464355 
SELECT * FROM productcustomimages WHERE product_id = '2985'
703 0.0006 0.00059103965759277 
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 = '2985'
                GROUP BY o.product_id
704 0.0007 0.00066208839416504 
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     = '2985'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
705 0.0005 0.00046300888061523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2985
706 0.0014 0.0014300346374512 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2985' AND a.name = n.originalname
707 0.0004 0.00044417381286621 
SELECT * FROM productoffers WHERE product_id = '2985' AND merchantid = 'A1X6FK5RDHNB96'
708 0.0005 0.00047898292541504 
SELECT * FROM productoffers
                WHERE product_id = '2985' AND price > 0
                ORDER BY price ASC LIMIT 1
709 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = 2985
                ORDER BY price ASC LIMIT 1
710 0.0004 0.00043988227844238 
SELECT value FROM productattributes
                WHERE product_id = '2985'
                AND name = 'ListPriceAmount'
711 0.0005 0.00045180320739746 
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 = '2985'
                GROUP BY o.product_id
712 0.0007 0.00069999694824219 
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     = '2985'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
713 0.0004 0.00040102005004883 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2985
714 0.0006 0.00061297416687012 
SELECT value FROM productattributes WHERE product_id = '2985' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
715 0.0004 0.00044083595275879 
SELECT * FROM products WHERE parent_id = '2985'
716 0.0006 0.0005791187286377 
SELECT * FROM productimages WHERE product_id = '3020' ORDER BY sortorder ASC
717 0.0005 0.00049114227294922 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3020' AND p.id = pi.product_id ORDER BY pi.sortorder
718 0.0007 0.00066900253295898 
SELECT * FROM product_image_select WHERE product_id = '3020'
719 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '3020'
720 0.0005 0.00050210952758789 
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 = '3020'
                GROUP BY o.product_id
721 0.0006 0.00059103965759277 
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     = '3020'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
722 0.0004 0.0004119873046875 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3020
723 0.0010 0.0010387897491455 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3020' AND a.name = n.originalname
724 0.0004 0.00041604042053223 
SELECT * FROM productoffers WHERE product_id = '3020' AND merchantid = 'A1X6FK5RDHNB96'
725 0.0004 0.00035810470581055 
SELECT * FROM productoffers
                WHERE product_id = '3020' AND price > 0
                ORDER BY price ASC LIMIT 1
726 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = 3020
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00036716461181641 
SELECT value FROM productattributes
                WHERE product_id = '3020'
                AND name = 'ListPriceAmount'
728 0.0004 0.00038504600524902 
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 = '3020'
                GROUP BY o.product_id
729 0.0006 0.00059914588928223 
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     = '3020'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
730 0.0004 0.00037789344787598 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3020
731 0.0006 0.00056910514831543 
SELECT value FROM productattributes WHERE product_id = '3020' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
732 0.0004 0.00042319297790527 
SELECT * FROM products WHERE parent_id = '3020'
733 0.0005 0.00047206878662109 
SELECT * FROM productimages WHERE product_id = '974' ORDER BY sortorder ASC
734 0.0006 0.00061583518981934 
SELECT * FROM product_image_select WHERE product_id = '974'
735 0.0004 0.0003960132598877 
SELECT * FROM productcustomimages WHERE product_id = '974'
736 0.0019 0.0019190311431885 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname
737 0.0018 0.0017781257629395 
SELECT * FROM productoffers WHERE product_id = '974' AND merchantid = 'A1X6FK5RDHNB96'
738 0.0017 0.0017321109771729 
SELECT * FROM productoffers
                WHERE product_id = '974' AND price > 0
                ORDER BY price ASC LIMIT 1
739 0.0020 0.0020210742950439 
SELECT value FROM productattributes WHERE product_id = '974' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0023 0.0022599697113037 
SELECT * FROM productimages WHERE product_id = '937' ORDER BY sortorder ASC
741 0.0010 0.00096416473388672 
SELECT * FROM product_image_select WHERE product_id = '937'
742 0.0006 0.00062108039855957 
SELECT * FROM productcustomimages WHERE product_id = '937'
743 0.0016 0.0015869140625 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '937' AND a.name = n.originalname
744 0.0007 0.00067710876464844 
SELECT * FROM productoffers WHERE product_id = '937' AND merchantid = 'A1X6FK5RDHNB96'
745 0.0006 0.00057005882263184 
SELECT * FROM productoffers
                WHERE product_id = '937' AND price > 0
                ORDER BY price ASC LIMIT 1
746 0.0006 0.00060391426086426 
SELECT value FROM productattributes WHERE product_id = '937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
747 0.0006 0.00064492225646973 
SELECT * FROM productimages WHERE product_id = '2882' ORDER BY sortorder ASC
748 0.0009 0.00088095664978027 
SELECT * FROM product_image_select WHERE product_id = '2882'
749 0.0005 0.00051522254943848 
SELECT * FROM productcustomimages WHERE product_id = '2882'
750 0.0017 0.0016710758209229 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2882' AND a.name = n.originalname
751 0.0006 0.00061511993408203 
SELECT * FROM productoffers WHERE product_id = '2882' AND merchantid = 'A1X6FK5RDHNB96'
752 0.0005 0.00051212310791016 
SELECT * FROM productoffers
                WHERE product_id = '2882' AND price > 0
                ORDER BY price ASC LIMIT 1
753 0.0007 0.0007469654083252 
SELECT * FROM productoffers
                WHERE product_id = 2882
                ORDER BY price ASC LIMIT 1
754 0.0005 0.00054001808166504 
SELECT value FROM productattributes
                WHERE product_id = '2882'
                AND name = 'ListPriceAmount'
755 0.0005 0.00051116943359375 
SELECT value FROM productattributes WHERE product_id = '2882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
756 0.0006 0.00060391426086426 
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
757 0.0008 0.000762939453125 
SELECT * FROM product_image_select WHERE product_id = '994'
758 0.0005 0.00046777725219727 
SELECT * FROM productcustomimages WHERE product_id = '994'
759 0.0012 0.0012369155883789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
760 0.0006 0.00063490867614746 
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
761 0.0006 0.0005500316619873 
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
762 0.0006 0.00056290626525879 
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
763 0.0006 0.00061607360839844 
SELECT * FROM productimages WHERE product_id = '3281' ORDER BY sortorder ASC
764 0.0006 0.00063490867614746 
SELECT * FROM product_image_select WHERE product_id = '3281'
765 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '3281'
766 0.0011 0.0010659694671631 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3281' AND a.name = n.originalname
767 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '3281' AND merchantid = 'A1X6FK5RDHNB96'
768 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = '3281' AND price > 0
                ORDER BY price ASC LIMIT 1
769 0.0003 0.00034594535827637 
SELECT * FROM productoffers
                WHERE product_id = 3281
                ORDER BY price ASC LIMIT 1
770 0.0004 0.0003960132598877 
SELECT value FROM productattributes
                WHERE product_id = '3281'
                AND name = 'ListPriceAmount'
771 0.0004 0.00041794776916504 
SELECT value FROM productattributes WHERE product_id = '3281' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '3171' ORDER BY sortorder ASC
773 0.0006 0.00059390068054199 
SELECT * FROM product_image_select WHERE product_id = '3171'
774 0.0004 0.00036406517028809 
SELECT * FROM productcustomimages WHERE product_id = '3171'
775 0.0009 0.0009160041809082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
776 0.0004 0.00044584274291992 
SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
777 0.0004 0.00035595893859863 
SELECT * FROM productoffers
                WHERE product_id = '3171' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0015 0.0015249252319336 
SELECT * FROM productoffers
                WHERE product_id = 3171
                ORDER BY price ASC LIMIT 1
779 0.0004 0.00039386749267578 
SELECT value FROM productattributes
                WHERE product_id = '3171'
                AND name = 'ListPriceAmount'
780 0.0004 0.00041699409484863 
SELECT value FROM productattributes WHERE product_id = '3171' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
781 0.0006 0.0005648136138916 
SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
782 0.0006 0.00056695938110352 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1915' AND p.id = pi.product_id ORDER BY pi.sortorder
783 0.0007 0.00066685676574707 
SELECT * FROM product_image_select WHERE product_id = '1915'
784 0.0004 0.00041985511779785 
SELECT * FROM productcustomimages WHERE product_id = '1915'
785 0.0005 0.0005040168762207 
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 = '1915'
                GROUP BY o.product_id
786 0.0006 0.00061702728271484 
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     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
787 0.0004 0.00039386749267578 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
788 0.0008 0.00079488754272461 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
789 0.0003 0.00034093856811523 
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
790 0.0004 0.00035881996154785 
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
791 0.0003 0.00030684471130371 
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
792 0.0003 0.00032591819763184 
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
793 0.0004 0.00038719177246094 
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 = '1915'
                GROUP BY o.product_id
794 0.0006 0.00064587593078613 
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     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
795 0.0004 0.0004279613494873 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
796 0.0005 0.00049090385437012 
SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
797 0.0006 0.00063991546630859 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1915'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
798 0.0005 0.00045394897460938 
SELECT * FROM products WHERE parent_id = '1915'
799 0.0005 0.00054001808166504 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
800 0.0004 0.00044894218444824 
SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
801 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = '4901' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0005 0.00047993659973145 
SELECT * FROM productimages WHERE product_id = '3903' ORDER BY sortorder ASC
803 0.0006 0.00057101249694824 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3903' AND p.id = pi.product_id ORDER BY pi.sortorder
804 0.0007 0.00066304206848145 
SELECT * FROM product_image_select WHERE product_id = '3903'
805 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '3903'
806 0.0008 0.0007941722869873 
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 = '3903'
                GROUP BY o.product_id
807 0.0008 0.00079703330993652 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3903'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
808 0.0005 0.00046896934509277 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3903
809 0.0008 0.00076913833618164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
810 0.0004 0.00037097930908203 
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
811 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
812 0.0004 0.00041913986206055 
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
813 0.0004 0.00039386749267578 
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
814 0.0005 0.0004880428314209 
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 = '3903'
                GROUP BY o.product_id
815 0.0008 0.0008089542388916 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3903'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
816 0.0005 0.00050687789916992 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3903
817 0.0006 0.00057697296142578 
SELECT value FROM productattributes WHERE product_id = '3903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
818 0.0007 0.00068402290344238 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3903'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
819 0.0006 0.00062012672424316 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3903'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
820 0.0006 0.00057697296142578 
SELECT * FROM productimages WHERE product_id = '3710' ORDER BY sortorder ASC
821 0.0011 0.0011141300201416 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3710' AND p.id = pi.product_id ORDER BY pi.sortorder
822 0.0007 0.00070500373840332 
SELECT * FROM product_image_select WHERE product_id = '3710'
823 0.0004 0.00040578842163086 
SELECT * FROM productcustomimages WHERE product_id = '3710'
824 0.0006 0.00058698654174805 
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 = '3710'
                GROUP BY o.product_id
825 0.0009 0.00086116790771484 
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     = '3710'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
826 0.0005 0.00046801567077637 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3710
827 0.0009 0.00086784362792969 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3710' AND a.name = n.originalname
828 0.0004 0.00037217140197754 
SELECT * FROM productoffers WHERE product_id = '3710' AND merchantid = 'A1X6FK5RDHNB96'
829 0.0004 0.00039505958557129 
SELECT * FROM productoffers
                WHERE product_id = '3710' AND price > 0
                ORDER BY price ASC LIMIT 1
830 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = 3710
                ORDER BY price ASC LIMIT 1
831 0.0004 0.00043010711669922 
SELECT value FROM productattributes
                WHERE product_id = '3710'
                AND name = 'ListPriceAmount'
832 0.0005 0.00046896934509277 
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 = '3710'
                GROUP BY o.product_id
833 0.0008 0.00084710121154785 
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     = '3710'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
834 0.0005 0.00048995018005371 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3710
835 0.0005 0.00053191184997559 
SELECT value FROM productattributes WHERE product_id = '3710' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
836 0.0007 0.00072097778320312 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3710'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
837 0.0006 0.00062704086303711 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3710'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
838 0.0005 0.00052309036254883 
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
839 0.0007 0.0006721019744873 
SELECT * FROM product_image_select WHERE product_id = '1112'
840 0.0004 0.0003662109375 
SELECT * FROM productcustomimages WHERE product_id = '1112'
841 0.0011 0.0011191368103027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
842 0.0005 0.00048494338989258 
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
843 0.0004 0.00039887428283691 
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
844 0.0003 0.00034809112548828 
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
845 0.0004 0.00040006637573242 
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
846 0.0005 0.00049901008605957 
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
847 0.0006 0.0005650520324707 
SELECT * FROM productimages WHERE product_id = '1262' ORDER BY sortorder ASC
848 0.0006 0.00061297416687012 
SELECT * FROM product_image_select WHERE product_id = '1262'
849 0.0005 0.00046992301940918 
SELECT * FROM productcustomimages WHERE product_id = '1262'
850 0.0010 0.00098490715026855 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname
851 0.0006 0.00058388710021973 
SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96'
852 0.0007 0.00066995620727539 
SELECT * FROM productoffers
                WHERE product_id = '1262' AND price > 0
                ORDER BY price ASC LIMIT 1
853 0.0005 0.00054001808166504 
SELECT value FROM productattributes WHERE product_id = '1262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
854 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
855 0.0006 0.00063586235046387 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
856 0.0006 0.00063490867614746 
SELECT * FROM product_image_select WHERE product_id = '3643'
857 0.0004 0.00041007995605469 
SELECT * FROM productcustomimages WHERE product_id = '3643'
858 0.0005 0.00050902366638184 
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 = '3643'
                GROUP BY o.product_id
859 0.0007 0.00065803527832031 
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     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
860 0.0004 0.00037598609924316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
861 0.0008 0.00076913833618164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
862 0.0003 0.00034284591674805 
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
863 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
864 0.0003 0.0003058910369873 
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
865 0.0004 0.00037503242492676 
SELECT value FROM productattributes
                WHERE product_id = '3643'
                AND name = 'ListPriceAmount'
866 0.0004 0.0003969669342041 
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 = '3643'
                GROUP BY o.product_id
867 0.0007 0.00067615509033203 
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     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
868 0.0004 0.0004270076751709 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
869 0.0005 0.00053691864013672 
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
870 0.0006 0.00057005882263184 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
871 0.0005 0.00054001808166504 
SELECT * FROM productimages WHERE product_id = '837' ORDER BY sortorder ASC
872 0.0005 0.00047588348388672 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '837' AND p.id = pi.product_id ORDER BY pi.sortorder
873 0.0007 0.00066184997558594 
SELECT * FROM product_image_select WHERE product_id = '837'
874 0.0004 0.0003819465637207 
SELECT * FROM productcustomimages WHERE product_id = '837'
875 0.0006 0.0005950927734375 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '837'
                GROUP BY o.product_id
876 0.0006 0.00063800811767578 
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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
877 0.0004 0.00038504600524902 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
878 0.0008 0.00080394744873047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
879 0.0003 0.00032186508178711 
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
880 0.0003 0.00032997131347656 
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
881 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
882 0.0003 0.0003209114074707 
SELECT value FROM productattributes
                WHERE product_id = '837'
                AND name = 'ListPriceAmount'
883 0.0004 0.00043201446533203 
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 = '837'
                GROUP BY o.product_id
884 0.0007 0.00072693824768066 
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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
885 0.0004 0.00041699409484863 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
886 0.0005 0.0004889965057373 
SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
887 0.0006 0.0005791187286377 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '837'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
888 0.0004 0.00043511390686035 
SELECT * FROM productimages WHERE product_id = '3810' ORDER BY sortorder ASC
889 0.0006 0.0005650520324707 
SELECT * FROM product_image_select WHERE product_id = '3810'
890 0.0004 0.00037503242492676 
SELECT * FROM productcustomimages WHERE product_id = '3810'
891 0.0009 0.00085020065307617 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3810' AND a.name = n.originalname
892 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '3810' AND merchantid = 'A1X6FK5RDHNB96'
893 0.0004 0.00042104721069336 
SELECT * FROM productoffers
                WHERE product_id = '3810' AND price > 0
                ORDER BY price ASC LIMIT 1
894 0.0003 0.00031399726867676 
SELECT * FROM productoffers
                WHERE product_id = 3810
                ORDER BY price ASC LIMIT 1
895 0.0003 0.00034189224243164 
SELECT value FROM productattributes
                WHERE product_id = '3810'
                AND name = 'ListPriceAmount'
896 0.0004 0.00035810470581055 
SELECT value FROM productattributes WHERE product_id = '3810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
897 0.0004 0.00042891502380371 
SELECT * FROM productimages WHERE product_id = '2619' ORDER BY sortorder ASC
898 0.0006 0.00056791305541992 
SELECT * FROM product_image_select WHERE product_id = '2619'
899 0.0004 0.00038290023803711 
SELECT * FROM productcustomimages WHERE product_id = '2619'
900 0.0008 0.00083184242248535 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2619' AND a.name = n.originalname
901 0.0004 0.00043797492980957 
SELECT * FROM productoffers WHERE product_id = '2619' AND merchantid = 'A1X6FK5RDHNB96'
902 0.0004 0.00036287307739258 
SELECT * FROM productoffers
                WHERE product_id = '2619' AND price > 0
                ORDER BY price ASC LIMIT 1
903 0.0003 0.0003049373626709 
SELECT * FROM productoffers
                WHERE product_id = 2619
                ORDER BY price ASC LIMIT 1
904 0.0004 0.00038313865661621 
SELECT value FROM productattributes
                WHERE product_id = '2619'
                AND name = 'ListPriceAmount'
905 0.0005 0.00054693222045898 
SELECT value FROM productattributes WHERE product_id = '2619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
906 0.0006 0.00055289268493652 
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
907 0.0007 0.00074887275695801 
SELECT * FROM product_image_select WHERE product_id = '1354'
908 0.0006 0.00057291984558105 
SELECT * FROM productcustomimages WHERE product_id = '1354'
909 0.0010 0.00095200538635254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
910 0.0005 0.00049710273742676 
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
911 0.0004 0.00035595893859863 
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
912 0.0004 0.00039005279541016 
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
913 0.0005 0.0004570484161377 
SELECT * FROM productimages WHERE product_id = '1473' ORDER BY sortorder ASC
914 0.0006 0.00057101249694824 
SELECT * FROM product_image_select WHERE product_id = '1473'
915 0.0004 0.00039005279541016 
SELECT * FROM productcustomimages WHERE product_id = '1473'
916 0.0009 0.00092601776123047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1473' AND a.name = n.originalname
917 0.0005 0.00045394897460938 
SELECT * FROM productoffers WHERE product_id = '1473' AND merchantid = 'A1X6FK5RDHNB96'
918 0.0003 0.00032496452331543 
SELECT * FROM productoffers
                WHERE product_id = '1473' AND price > 0
                ORDER BY price ASC LIMIT 1
919 0.0003 0.00032591819763184 
SELECT * FROM productoffers
                WHERE product_id = 1473
                ORDER BY price ASC LIMIT 1
920 0.0004 0.00036501884460449 
SELECT value FROM productattributes
                WHERE product_id = '1473'
                AND name = 'ListPriceAmount'
921 0.0004 0.00037097930908203 
SELECT value FROM productattributes WHERE product_id = '1473' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
922 0.0004 0.00044608116149902 
SELECT * FROM productimages WHERE product_id = '1220' ORDER BY sortorder ASC
923 0.0006 0.0005800724029541 
SELECT * FROM product_image_select WHERE product_id = '1220'
924 0.0004 0.00035381317138672 
SELECT * FROM productcustomimages WHERE product_id = '1220'
925 0.0007 0.00071191787719727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1220' AND a.name = n.originalname
926 0.0005 0.00054287910461426 
SELECT * FROM productoffers WHERE product_id = '1220' AND merchantid = 'A1X6FK5RDHNB96'
927 0.0004 0.00035810470581055 
SELECT * FROM productoffers
                WHERE product_id = '1220' AND price > 0
                ORDER BY price ASC LIMIT 1
928 0.0003 0.00030398368835449 
SELECT * FROM productoffers
                WHERE product_id = 1220
                ORDER BY price ASC LIMIT 1
929 0.0004 0.00037908554077148 
SELECT value FROM productattributes
                WHERE product_id = '1220'
                AND name = 'ListPriceAmount'
930 0.0004 0.0004270076751709 
SELECT value FROM productattributes WHERE product_id = '1220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
931 0.0005 0.00046610832214355 
SELECT * FROM productimages WHERE product_id = '1039' ORDER BY sortorder ASC
932 0.0006 0.00057315826416016 
SELECT * FROM product_image_select WHERE product_id = '1039'
933 0.0004 0.00036907196044922 
SELECT * FROM productcustomimages WHERE product_id = '1039'
934 0.0009 0.00092911720275879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1039' AND a.name = n.originalname
935 0.0005 0.00049495697021484 
SELECT * FROM productoffers WHERE product_id = '1039' AND merchantid = 'A1X6FK5RDHNB96'
936 0.0004 0.00035190582275391 
SELECT * FROM productoffers
                WHERE product_id = '1039' AND price > 0
                ORDER BY price ASC LIMIT 1
937 0.0003 0.00033116340637207 
SELECT * FROM productoffers
                WHERE product_id = 1039
                ORDER BY price ASC LIMIT 1
938 0.0004 0.0003509521484375 
SELECT value FROM productattributes
                WHERE product_id = '1039'
                AND name = 'ListPriceAmount'
939 0.0004 0.0003809928894043 
SELECT value FROM productattributes WHERE product_id = '1039' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
940 0.0005 0.00049400329589844 
SELECT * FROM productimages WHERE product_id = '1668' ORDER BY sortorder ASC
941 0.0006 0.00059795379638672 
SELECT * FROM product_image_select WHERE product_id = '1668'
942 0.0004 0.00037908554077148 
SELECT * FROM productcustomimages WHERE product_id = '1668'
943 0.0007 0.00071001052856445 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1668' AND a.name = n.originalname
944 0.0005 0.0005190372467041 
SELECT * FROM productoffers WHERE product_id = '1668' AND merchantid = 'A1X6FK5RDHNB96'
945 0.0004 0.00037813186645508 
SELECT * FROM productoffers
                WHERE product_id = '1668' AND price > 0
                ORDER BY price ASC LIMIT 1
946 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = 1668
                ORDER BY price ASC LIMIT 1
947 0.0004 0.00040912628173828 
SELECT value FROM productattributes
                WHERE product_id = '1668'
                AND name = 'ListPriceAmount'
948 0.0004 0.0003972053527832 
SELECT value FROM productattributes WHERE product_id = '1668' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
949 0.0006 0.00056099891662598 
SELECT * FROM productimages WHERE product_id = '3773' ORDER BY sortorder ASC
950 0.0006 0.00056886672973633 
SELECT * FROM product_image_select WHERE product_id = '3773'
951 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '3773'
952 0.0010 0.0010311603546143 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3773' AND a.name = n.originalname
953 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '3773' AND merchantid = 'A1X6FK5RDHNB96'
954 0.0004 0.00037217140197754 
SELECT * FROM productoffers
                WHERE product_id = '3773' AND price > 0
                ORDER BY price ASC LIMIT 1
955 0.0004 0.00041913986206055 
SELECT value FROM productattributes WHERE product_id = '3773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
956 0.0005 0.0005028247833252 
SELECT * FROM productimages WHERE product_id = '4142' ORDER BY sortorder ASC
957 0.0006 0.00063705444335938 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4142' AND p.id = pi.product_id ORDER BY pi.sortorder
958 0.0007 0.00066494941711426 
SELECT * FROM product_image_select WHERE product_id = '4142'
959 0.0004 0.00037598609924316 
SELECT * FROM productcustomimages WHERE product_id = '4142'
960 0.0005 0.00051379203796387 
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 = '4142'
                GROUP BY o.product_id
961 0.0006 0.00061988830566406 
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     = '4142'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
962 0.0004 0.00042009353637695 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4142
963 0.0008 0.00083708763122559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4142' AND a.name = n.originalname
964 0.0003 0.00033688545227051 
SELECT * FROM productoffers WHERE product_id = '4142' AND merchantid = 'A1X6FK5RDHNB96'
965 0.0004 0.00037288665771484 
SELECT * FROM productoffers
                WHERE product_id = '4142' AND price > 0
                ORDER BY price ASC LIMIT 1
966 0.0003 0.00034284591674805 
SELECT * FROM productoffers
                WHERE product_id = 4142
                ORDER BY price ASC LIMIT 1
967 0.0004 0.00035691261291504 
SELECT value FROM productattributes
                WHERE product_id = '4142'
                AND name = 'ListPriceAmount'
968 0.0004 0.00039386749267578 
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 = '4142'
                GROUP BY o.product_id
969 0.0006 0.00063896179199219 
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     = '4142'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
970 0.0004 0.00039410591125488 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4142
971 0.0005 0.00052118301391602 
SELECT value FROM productattributes WHERE product_id = '4142' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
972 0.0006 0.00058794021606445 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4142'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
973 0.0005 0.00053811073303223 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
974 0.0005 0.00048208236694336 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3666' AND p.id = pi.product_id ORDER BY pi.sortorder
975 0.0007 0.00066304206848145 
SELECT * FROM product_image_select WHERE product_id = '3666'
976 0.0004 0.0003812313079834 
SELECT * FROM productcustomimages WHERE product_id = '3666'
977 0.0005 0.00053000450134277 
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 = '3666'
                GROUP BY o.product_id
978 0.0007 0.00066089630126953 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
979 0.0004 0.00043010711669922 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
980 0.0009 0.00090980529785156 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
981 0.0003 0.00033712387084961 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
982 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
983 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
984 0.0003 0.00033783912658691 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
985 0.0005 0.00046205520629883 
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 = '3666'
                GROUP BY o.product_id
986 0.0007 0.00065994262695312 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
987 0.0004 0.00042390823364258 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
988 0.0005 0.0005028247833252 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
989 0.0006 0.0005950927734375 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3666'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
990 0.0005 0.00049901008605957 
SELECT * FROM productimages WHERE product_id = '2073' ORDER BY sortorder ASC
991 0.0006 0.00058603286743164 
SELECT * FROM product_image_select WHERE product_id = '2073'
992 0.0004 0.00035715103149414 
SELECT * FROM productcustomimages WHERE product_id = '2073'
993 0.0008 0.00079107284545898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2073' AND a.name = n.originalname
994 0.0004 0.00043487548828125 
SELECT * FROM productoffers WHERE product_id = '2073' AND merchantid = 'A1X6FK5RDHNB96'
995 0.0004 0.00035881996154785 
SELECT * FROM productoffers
                WHERE product_id = '2073' AND price > 0
                ORDER BY price ASC LIMIT 1
996 0.0003 0.00030684471130371 
SELECT * FROM productoffers
                WHERE product_id = 2073
                ORDER BY price ASC LIMIT 1
997 0.0003 0.00032901763916016 
SELECT value FROM productattributes
                WHERE product_id = '2073'
                AND name = 'ListPriceAmount'
998 0.0004 0.00035214424133301 
SELECT value FROM productattributes WHERE product_id = '2073' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
999 0.0004 0.00043797492980957 
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
1000 0.0005 0.0005488395690918 
SELECT * FROM product_image_select WHERE product_id = '4909'
1001 0.0004 0.00036191940307617 
SELECT * FROM productcustomimages WHERE product_id = '4909'
1002 0.0010 0.00095701217651367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
1003 0.0006 0.00062012672424316 
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
1004 0.0004 0.00038886070251465 
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
1005 0.0004 0.00040984153747559 
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1006 0.0004 0.0004279613494873 
SELECT * FROM productimages WHERE product_id = '3019' ORDER BY sortorder ASC
1007 0.0006 0.00062704086303711 
SELECT * FROM product_image_select WHERE product_id = '3019'
1008 0.0004 0.00042819976806641 
SELECT * FROM productcustomimages WHERE product_id = '3019'
1009 0.0007 0.0007469654083252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3019' AND a.name = n.originalname
1010 0.0005 0.00051712989807129 
SELECT * FROM productoffers WHERE product_id = '3019' AND merchantid = 'A1X6FK5RDHNB96'
1011 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '3019' AND price > 0
                ORDER BY price ASC LIMIT 1
1012 0.0003 0.00031495094299316 
SELECT * FROM productoffers
                WHERE product_id = 3019
                ORDER BY price ASC LIMIT 1
1013 0.0003 0.00034093856811523 
SELECT value FROM productattributes
                WHERE product_id = '3019'
                AND name = 'ListPriceAmount'
1014 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '3019' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1015 0.0005 0.00046300888061523 
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
1016 0.0006 0.00059986114501953 
SELECT * FROM product_image_select WHERE product_id = '764'
1017 0.0004 0.00037217140197754 
SELECT * FROM productcustomimages WHERE product_id = '764'
1018 0.0009 0.00090694427490234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
1019 0.0005 0.00048494338989258 
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
1020 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
1021 0.0004 0.00043511390686035 
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1022 0.0005 0.00047707557678223 
SELECT * FROM productimages WHERE product_id = '2953' ORDER BY sortorder ASC
1023 0.0006 0.00061893463134766 
SELECT * FROM product_image_select WHERE product_id = '2953'
1024 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '2953'
1025 0.0008 0.00083208084106445 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2953' AND a.name = n.originalname
1026 0.0005 0.00045514106750488 
SELECT * FROM productoffers WHERE product_id = '2953' AND merchantid = 'A1X6FK5RDHNB96'
1027 0.0005 0.00045418739318848 
SELECT * FROM productoffers
                WHERE product_id = '2953' AND price > 0
                ORDER BY price ASC LIMIT 1
1028 0.0005 0.00047016143798828 
SELECT value FROM productattributes WHERE product_id = '2953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1029 0.0005 0.00054383277893066 
SELECT * FROM productimages WHERE product_id = '3820' ORDER BY sortorder ASC
1030 0.0007 0.00067496299743652 
SELECT * FROM product_image_select WHERE product_id = '3820'
1031 0.0004 0.0004270076751709 
SELECT * FROM productcustomimages WHERE product_id = '3820'
1032 0.0010 0.00098204612731934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3820' AND a.name = n.originalname
1033 0.0005 0.00048303604125977 
SELECT * FROM productoffers WHERE product_id = '3820' AND merchantid = 'A1X6FK5RDHNB96'
1034 0.0004 0.00044512748718262 
SELECT * FROM productoffers
                WHERE product_id = '3820' AND price > 0
                ORDER BY price ASC LIMIT 1
1035 0.0003 0.00033903121948242 
SELECT * FROM productoffers
                WHERE product_id = 3820
                ORDER BY price ASC LIMIT 1
1036 0.0004 0.00037002563476562 
SELECT value FROM productattributes
                WHERE product_id = '3820'
                AND name = 'ListPriceAmount'
1037 0.0004 0.00040507316589355 
SELECT value FROM productattributes WHERE product_id = '3820' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1038 0.0005 0.00047183036804199 
SELECT * FROM productimages WHERE product_id = '2923' ORDER BY sortorder ASC
1039 0.0006 0.00056195259094238 
SELECT * FROM product_image_select WHERE product_id = '2923'
1040 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '2923'
1041 0.0010 0.00097179412841797 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2923' AND a.name = n.originalname
1042 0.0005 0.00047397613525391 
SELECT * FROM productoffers WHERE product_id = '2923' AND merchantid = 'A1X6FK5RDHNB96'
1043 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = '2923' AND price > 0
                ORDER BY price ASC LIMIT 1
1044 0.0004 0.0003821849822998 
SELECT * FROM productoffers
                WHERE product_id = 2923
                ORDER BY price ASC LIMIT 1
1045 0.0004 0.00039291381835938 
SELECT value FROM productattributes
                WHERE product_id = '2923'
                AND name = 'ListPriceAmount'
1046 0.0005 0.00051307678222656 
SELECT value FROM productattributes WHERE product_id = '2923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1047 0.0005 0.00051689147949219 
SELECT * FROM productimages WHERE product_id = '2924' ORDER BY sortorder ASC
1048 0.0006 0.00058817863464355 
SELECT * FROM product_image_select WHERE product_id = '2924'
1049 0.0005 0.0005040168762207 
SELECT * FROM productcustomimages WHERE product_id = '2924'
1050 0.0009 0.00094008445739746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2924' AND a.name = n.originalname
1051 0.0006 0.00061178207397461 
SELECT * FROM productoffers WHERE product_id = '2924' AND merchantid = 'A1X6FK5RDHNB96'
1052 0.0007 0.00067782402038574 
SELECT * FROM productoffers
                WHERE product_id = '2924' AND price > 0
                ORDER BY price ASC LIMIT 1
1053 0.0004 0.00039792060852051 
SELECT * FROM productoffers
                WHERE product_id = 2924
                ORDER BY price ASC LIMIT 1
1054 0.0004 0.00038313865661621 
SELECT value FROM productattributes
                WHERE product_id = '2924'
                AND name = 'ListPriceAmount'
1055 0.0004 0.00042605400085449 
SELECT value FROM productattributes WHERE product_id = '2924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1056 0.0005 0.00052285194396973 
SELECT * FROM productimages WHERE product_id = '3259' ORDER BY sortorder ASC
1057 0.0007 0.00068783760070801 
SELECT * FROM product_image_select WHERE product_id = '3259'
1058 0.0004 0.00042605400085449 
SELECT * FROM productcustomimages WHERE product_id = '3259'
1059 0.0011 0.0010960102081299 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3259' AND a.name = n.originalname
1060 0.0005 0.00047087669372559 
SELECT * FROM productoffers WHERE product_id = '3259' AND merchantid = 'A1X6FK5RDHNB96'
1061 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = '3259' AND price > 0
                ORDER BY price ASC LIMIT 1
1062 0.0003 0.00033712387084961 
SELECT * FROM productoffers
                WHERE product_id = 3259
                ORDER BY price ASC LIMIT 1
1063 0.0004 0.00040602684020996 
SELECT value FROM productattributes
                WHERE product_id = '3259'
                AND name = 'ListPriceAmount'
1064 0.0004 0.00043606758117676 
SELECT value FROM productattributes WHERE product_id = '3259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1065 0.0005 0.00053215026855469 
SELECT * FROM productimages WHERE product_id = '2926' ORDER BY sortorder ASC
1066 0.0007 0.0007011890411377 
SELECT * FROM product_image_select WHERE product_id = '2926'
1067 0.0004 0.00043702125549316 
SELECT * FROM productcustomimages WHERE product_id = '2926'
1068 0.0010 0.0009770393371582 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2926' AND a.name = n.originalname
1069 0.0005 0.00047802925109863 
SELECT * FROM productoffers WHERE product_id = '2926' AND merchantid = 'A1X6FK5RDHNB96'
1070 0.0006 0.00062417984008789 
SELECT * FROM productoffers
                WHERE product_id = '2926' AND price > 0
                ORDER BY price ASC LIMIT 1
1071 0.0005 0.0005190372467041 
SELECT * FROM productoffers
                WHERE product_id = 2926
                ORDER BY price ASC LIMIT 1
1072 0.0005 0.00048089027404785 
SELECT value FROM productattributes
                WHERE product_id = '2926'
                AND name = 'ListPriceAmount'
1073 0.0004 0.00039792060852051 
SELECT value FROM productattributes WHERE product_id = '2926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1074 0.0006 0.0005958080291748 
SELECT * FROM productimages WHERE product_id = '964' ORDER BY sortorder ASC
1075 0.0006 0.0006251335144043 
SELECT * FROM product_image_select WHERE product_id = '964'
1076 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '964'
1077 0.0010 0.0010049343109131 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '964' AND a.name = n.originalname
1078 0.0004 0.00043320655822754 
SELECT * FROM productoffers WHERE product_id = '964' AND merchantid = 'A1X6FK5RDHNB96'
1079 0.0004 0.00040006637573242 
SELECT * FROM productoffers
                WHERE product_id = '964' AND price > 0
                ORDER BY price ASC LIMIT 1
1080 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = 964
                ORDER BY price ASC LIMIT 1
1081 0.0004 0.00039100646972656 
SELECT value FROM productattributes
                WHERE product_id = '964'
                AND name = 'ListPriceAmount'
1082 0.0004 0.00042891502380371 
SELECT value FROM productattributes WHERE product_id = '964' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1083 0.0006 0.00055289268493652 
SELECT * FROM productimages WHERE product_id = '4002' ORDER BY sortorder ASC
1084 0.0007 0.00065493583679199 
SELECT * FROM product_image_select WHERE product_id = '4002'
1085 0.0004 0.00044989585876465 
SELECT * FROM productcustomimages WHERE product_id = '4002'
1086 0.0010 0.0010278224945068 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4002' AND a.name = n.originalname
1087 0.0005 0.0004880428314209 
SELECT * FROM productoffers WHERE product_id = '4002' AND merchantid = 'A1X6FK5RDHNB96'
1088 0.0005 0.00045013427734375 
SELECT * FROM productoffers
                WHERE product_id = '4002' AND price > 0
                ORDER BY price ASC LIMIT 1
1089 0.0005 0.00051593780517578 
SELECT value FROM productattributes WHERE product_id = '4002' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1090 0.0005 0.00049209594726562 
SELECT * FROM productimages WHERE product_id = '4007' ORDER BY sortorder ASC
1091 0.0007 0.00066995620727539 
SELECT * FROM product_image_select WHERE product_id = '4007'
1092 0.0004 0.00042486190795898 
SELECT * FROM productcustomimages WHERE product_id = '4007'
1093 0.0010 0.0010249614715576 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
1094 0.0005 0.0004580020904541 
SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
1095 0.0005 0.00046110153198242 
SELECT * FROM productoffers
                WHERE product_id = '4007' AND price > 0
                ORDER BY price ASC LIMIT 1
1096 0.0005 0.00048613548278809 
SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1097 0.0005 0.00047802925109863 
SELECT * FROM productimages WHERE product_id = '4011' ORDER BY sortorder ASC
1098 0.0006 0.00060915946960449 
SELECT * FROM product_image_select WHERE product_id = '4011'
1099 0.0004 0.00040793418884277 
SELECT * FROM productcustomimages WHERE product_id = '4011'
1100 0.0011 0.0011210441589355 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4011' AND a.name = n.originalname
1101 0.0005 0.00050902366638184 
SELECT * FROM productoffers WHERE product_id = '4011' AND merchantid = 'A1X6FK5RDHNB96'
1102 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = '4011' AND price > 0
                ORDER BY price ASC LIMIT 1
1103 0.0005 0.00047516822814941 
SELECT value FROM productattributes WHERE product_id = '4011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1104 0.0004 0.00041890144348145 
SELECT * FROM productimages WHERE product_id = '1370' ORDER BY sortorder ASC
1105 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '1370'
1106 0.0004 0.00038504600524902 
SELECT * FROM productcustomimages WHERE product_id = '1370'
1107 0.0007 0.0007479190826416 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1370' AND a.name = n.originalname
1108 0.0004 0.00044107437133789 
SELECT * FROM productoffers WHERE product_id = '1370' AND merchantid = 'A1X6FK5RDHNB96'
1109 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = '1370' AND price > 0
                ORDER BY price ASC LIMIT 1
1110 0.0003 0.00031113624572754 
SELECT * FROM productoffers
                WHERE product_id = 1370
                ORDER BY price ASC LIMIT 1
1111 0.0004 0.00035190582275391 
SELECT value FROM productattributes
                WHERE product_id = '1370'
                AND name = 'ListPriceAmount'
1112 0.0004 0.00035905838012695 
SELECT value FROM productattributes WHERE product_id = '1370' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1113 0.0005 0.00049400329589844 
SELECT * FROM productimages WHERE product_id = '2746' ORDER BY sortorder ASC
1114 0.0006 0.00056099891662598 
SELECT * FROM product_image_select WHERE product_id = '2746'
1115 0.0004 0.0003809928894043 
SELECT * FROM productcustomimages WHERE product_id = '2746'
1116 0.0010 0.00099015235900879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2746' AND a.name = n.originalname
1117 0.0004 0.0004270076751709 
SELECT * FROM productoffers WHERE product_id = '2746' AND merchantid = 'A1X6FK5RDHNB96'
1118 0.0007 0.00069808959960938 
SELECT * FROM productoffers
                WHERE product_id = '2746' AND price > 0
                ORDER BY price ASC LIMIT 1
1119 0.0004 0.00044012069702148 
SELECT value FROM productattributes WHERE product_id = '2746' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1120 0.0005 0.00047183036804199 
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
1121 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '1290'
1122 0.0003 0.00034904479980469 
SELECT * FROM productcustomimages WHERE product_id = '1290'
1123 0.0010 0.0010271072387695 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
1124 0.0004 0.00040817260742188 
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
1125 0.0004 0.00039386749267578 
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
1126 0.0004 0.00042414665222168 
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1127 0.0006 0.00058197975158691 
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
1128 0.0006 0.0006098747253418 
SELECT * FROM product_image_select WHERE product_id = '1070'
1129 0.0004 0.00040984153747559 
SELECT * FROM productcustomimages WHERE product_id = '1070'
1130 0.0010 0.0010020732879639 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
1131 0.0006 0.00057101249694824 
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
1132 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
1133 0.0004 0.00044012069702148 
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1134 0.0005 0.0004889965057373 
SELECT * FROM productimages WHERE product_id = '1240' ORDER BY sortorder ASC
1135 0.0006 0.00060391426086426 
SELECT * FROM product_image_select WHERE product_id = '1240'
1136 0.0004 0.00038480758666992 
SELECT * FROM productcustomimages WHERE product_id = '1240'
1137 0.0009 0.00093603134155273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1240' AND a.name = n.originalname
1138 0.0004 0.00042986869812012 
SELECT * FROM productoffers WHERE product_id = '1240' AND merchantid = 'A1X6FK5RDHNB96'
1139 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '1240' AND price > 0
                ORDER BY price ASC LIMIT 1
1140 0.0005 0.00045204162597656 
SELECT value FROM productattributes WHERE product_id = '1240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1141 0.0005 0.0005340576171875 
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
1142 0.0006 0.00058317184448242 
SELECT * FROM product_image_select WHERE product_id = '923'
1143 0.0004 0.0004119873046875 
SELECT * FROM productcustomimages WHERE product_id = '923'
1144 0.0010 0.00095295906066895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
1145 0.0006 0.00058889389038086 
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
1146 0.0004 0.00036311149597168 
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
1147 0.0005 0.00049281120300293 
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1148 0.0005 0.00051188468933105 
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
1149 0.0007 0.00067687034606934 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
1150 0.0007 0.00071001052856445 
SELECT * FROM product_image_select WHERE product_id = '822'
1151 0.0005 0.00049996376037598 
SELECT * FROM productcustomimages WHERE product_id = '822'
1152 0.0006 0.00061988830566406 
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 = '822'
                GROUP BY o.product_id
1153 0.0006 0.00064897537231445 
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
1154 0.0004 0.00042414665222168 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
1155 0.0009 0.00090909004211426 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
1156 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
1157 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
1158 0.0004 0.00040888786315918 
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
1159 0.0004 0.00040102005004883 
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
1160 0.0004 0.00042414665222168 
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 = '822'
                GROUP BY o.product_id
1161 0.0006 0.00064516067504883 
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
1162 0.0004 0.00040602684020996 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
1163 0.0005 0.00051522254943848 
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1164 0.0007 0.00065112113952637 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
1165 0.0005 0.00054812431335449 
SELECT * FROM productimages WHERE product_id = '984' ORDER BY sortorder ASC
1166 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '984'
1167 0.0004 0.00038290023803711 
SELECT * FROM productcustomimages WHERE product_id = '984'
1168 0.0008 0.00078010559082031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '984' AND a.name = n.originalname
1169 0.0004 0.00043892860412598 
SELECT * FROM productoffers WHERE product_id = '984' AND merchantid = 'A1X6FK5RDHNB96'
1170 0.0003 0.0003361701965332 
SELECT * FROM productoffers
                WHERE product_id = '984' AND price > 0
                ORDER BY price ASC LIMIT 1
1171 0.0003 0.00030088424682617 
SELECT * FROM productoffers
                WHERE product_id = 984
                ORDER BY price ASC LIMIT 1
1172 0.0004 0.00042891502380371 
SELECT value FROM productattributes
                WHERE product_id = '984'
                AND name = 'ListPriceAmount'
1173 0.0004 0.00042390823364258 
SELECT value FROM productattributes WHERE product_id = '984' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1174 0.0005 0.00047612190246582 
SELECT * FROM productimages WHERE product_id = '1707' ORDER BY sortorder ASC
1175 0.0007 0.00065898895263672 
SELECT * FROM product_image_select WHERE product_id = '1707'
1176 0.0004 0.00042104721069336 
SELECT * FROM productcustomimages WHERE product_id = '1707'
1177 0.0008 0.00077509880065918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1707' AND a.name = n.originalname
1178 0.0005 0.00050210952758789 
SELECT * FROM productoffers WHERE product_id = '1707' AND merchantid = 'A1X6FK5RDHNB96'
1179 0.0004 0.0003821849822998 
SELECT * FROM productoffers
                WHERE product_id = '1707' AND price > 0
                ORDER BY price ASC LIMIT 1
1180 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = 1707
                ORDER BY price ASC LIMIT 1
1181 0.0004 0.00039386749267578 
SELECT value FROM productattributes
                WHERE product_id = '1707'
                AND name = 'ListPriceAmount'
1182 0.0004 0.00037884712219238 
SELECT value FROM productattributes WHERE product_id = '1707' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1183 0.0006 0.00055599212646484 
SELECT * FROM productimages WHERE product_id = '2108' ORDER BY sortorder ASC
1184 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '2108'
1185 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '2108'
1186 0.0007 0.00072503089904785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2108' AND a.name = n.originalname
1187 0.0005 0.00050091743469238 
SELECT * FROM productoffers WHERE product_id = '2108' AND merchantid = 'A1X6FK5RDHNB96'
1188 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '2108' AND price > 0
                ORDER BY price ASC LIMIT 1
1189 0.0005 0.00045490264892578 
SELECT * FROM productoffers
                WHERE product_id = 2108
                ORDER BY price ASC LIMIT 1
1190 0.0004 0.00044679641723633 
SELECT value FROM productattributes
                WHERE product_id = '2108'
                AND name = 'ListPriceAmount'
1191 0.0004 0.00044417381286621 
SELECT value FROM productattributes WHERE product_id = '2108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1192 0.0005 0.00051403045654297 
SELECT * FROM productimages WHERE product_id = '4136' ORDER BY sortorder ASC
1193 0.0006 0.0006110668182373 
SELECT * FROM product_image_select WHERE product_id = '4136'
1194 0.0004 0.0004119873046875 
SELECT * FROM productcustomimages WHERE product_id = '4136'
1195 0.0010 0.0010480880737305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4136' AND a.name = n.originalname
1196 0.0005 0.00047802925109863 
SELECT * FROM productoffers WHERE product_id = '4136' AND merchantid = 'A1X6FK5RDHNB96'
1197 0.0004 0.0003969669342041 
SELECT * FROM productoffers
                WHERE product_id = '4136' AND price > 0
                ORDER BY price ASC LIMIT 1
1198 0.0004 0.00043988227844238 
SELECT value FROM productattributes WHERE product_id = '4136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1199 0.0004 0.00044608116149902 
SELECT * FROM productimages WHERE product_id = '1884' ORDER BY sortorder ASC
1200 0.0006 0.00055193901062012 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1884' AND p.id = pi.product_id ORDER BY pi.sortorder
1201 0.0007 0.0006859302520752 
SELECT * FROM product_image_select WHERE product_id = '1884'
1202 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '1884'
1203 0.0007 0.00070619583129883 
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 = '1884'
                GROUP BY o.product_id
1204 0.0008 0.00084686279296875 
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     = '1884'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
1205 0.0005 0.00052189826965332 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1884
1206 0.0011 0.0011301040649414 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1884' AND a.name = n.originalname
1207 0.0004 0.00035285949707031 
SELECT * FROM productoffers WHERE product_id = '1884' AND merchantid = 'A1X6FK5RDHNB96'
1208 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '1884' AND price > 0
                ORDER BY price ASC LIMIT 1
1209 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = 1884
                ORDER BY price ASC LIMIT 1
1210 0.0004 0.0003509521484375 
SELECT value FROM productattributes
                WHERE product_id = '1884'
                AND name = 'ListPriceAmount'
1211 0.0004 0.00039196014404297 
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 = '1884'
                GROUP BY o.product_id
1212 0.0007 0.00069999694824219 
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     = '1884'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
1213 0.0004 0.00044393539428711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1884
1214 0.0005 0.00050711631774902 
SELECT value FROM productattributes WHERE product_id = '1884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1215 0.0007 0.00065493583679199 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1884'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
1216 0.0004 0.00041699409484863 
SELECT * FROM products WHERE parent_id = '1884'
1217 0.0007 0.0006568431854248 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1888' AND a.name = n.originalname
1218 0.0004 0.00041794776916504 
SELECT * FROM productoffers WHERE product_id = '1888' AND merchantid = 'A1X6FK5RDHNB96'
1219 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = '1888' AND price > 0
                ORDER BY price ASC LIMIT 1
1220 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = 1888
                ORDER BY price ASC LIMIT 1
1221 0.0004 0.00039792060852051 
SELECT value FROM productattributes
                WHERE product_id = '1888'
                AND name = 'ListPriceAmount'
1222 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '1803' ORDER BY sortorder ASC
1223 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '1803'
1224 0.0004 0.00043892860412598 
SELECT * FROM productcustomimages WHERE product_id = '1803'
1225 0.0007 0.00066089630126953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1803' AND a.name = n.originalname
1226 0.0004 0.0004420280456543 
SELECT * FROM productoffers WHERE product_id = '1803' AND merchantid = 'A1X6FK5RDHNB96'
1227 0.0004 0.00035190582275391 
SELECT * FROM productoffers
                WHERE product_id = '1803' AND price > 0
                ORDER BY price ASC LIMIT 1
1228 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = 1803
                ORDER BY price ASC LIMIT 1
1229 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '1803'
                AND name = 'ListPriceAmount'
1230 0.0004 0.00041794776916504 
SELECT value FROM productattributes WHERE product_id = '1803' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1231 0.0020 0.0020248889923096 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
1232 0.0013 0.0013489723205566 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
1233 0.0004 0.00035500526428223 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
1234 0.0127 0.012738943099976 
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
1235 0.0020 0.0020151138305664 
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
1236 0.0006 0.00057387351989746 
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
1237 0.0005 0.00051593780517578 
SELECT * FROM products WHERE id = 1626
1238 0.0004 0.00035691261291504 
SELECT * FROM products WHERE id = 4041
1239 0.0003 0.00033116340637207 
SELECT * FROM products WHERE id = 4312
1240 0.0004 0.00036501884460449 
SELECT * FROM products WHERE id = 777
1241 0.0004 0.0003659725189209 
SELECT * FROM products WHERE id = 3881
1242 0.0003 0.0003211498260498 
SELECT * FROM products WHERE id = 4213
1243 0.0004 0.00035500526428223 
SELECT * FROM products WHERE id = '1626'
1244 0.0005 0.00049090385437012 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
1245 0.0006 0.00056600570678711 
SELECT * FROM product_image_select WHERE product_id = '1626'
1246 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '1626'
1247 0.0008 0.00082612037658691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
1248 0.0005 0.00047397613525391 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
1249 0.0003 0.00034594535827637 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
1250 0.0004 0.00043892860412598 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1251 0.0005 0.00046300888061523 
SELECT * FROM products WHERE id = '4041'
1252 0.0004 0.00041389465332031 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
1253 0.0006 0.00064420700073242 
SELECT * FROM product_image_select WHERE product_id = '4041'
1254 0.0004 0.00035905838012695 
SELECT * FROM productcustomimages WHERE product_id = '4041'
1255 0.0011 0.0010950565338135 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
1256 0.0004 0.00044894218444824 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
1257 0.0004 0.00035309791564941 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
1258 0.0004 0.00042104721069336 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1259 0.0005 0.00050997734069824 
SELECT * FROM products WHERE id = '4312'
1260 0.0004 0.00043606758117676 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
1261 0.0006 0.00056695938110352 
SELECT * FROM product_image_select WHERE product_id = '4312'
1262 0.0004 0.00039291381835938 
SELECT * FROM productcustomimages WHERE product_id = '4312'
1263 0.0010 0.00099992752075195 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
1264 0.0004 0.00044393539428711 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
1265 0.0004 0.00037002563476562 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
1266 0.0004 0.00043201446533203 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1267 0.0005 0.00051307678222656 
SELECT * FROM products WHERE id = '777'
1268 0.0005 0.00047898292541504 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
1269 0.0006 0.00060296058654785 
SELECT * FROM product_image_select WHERE product_id = '777'
1270 0.0004 0.00036406517028809 
SELECT * FROM productcustomimages WHERE product_id = '777'
1271 0.0010 0.0010290145874023 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
1272 0.0005 0.00045609474182129 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
1273 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
1274 0.0004 0.0003960132598877 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1275 0.0005 0.0004880428314209 
SELECT * FROM products WHERE id = '3881'
1276 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
1277 0.0006 0.00058102607727051 
SELECT * FROM product_image_select WHERE product_id = '3881'
1278 0.0003 0.00034999847412109 
SELECT * FROM productcustomimages WHERE product_id = '3881'
1279 0.0010 0.0010490417480469 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
1280 0.0004 0.00044894218444824 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
1281 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
1282 0.0004 0.00040197372436523 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1283 0.0005 0.00050806999206543 
SELECT * FROM products WHERE id = '4213'
1284 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
1285 0.0005 0.00054812431335449 
SELECT * FROM product_image_select WHERE product_id = '4213'
1286 0.0003 0.00034904479980469 
SELECT * FROM productcustomimages WHERE product_id = '4213'
1287 0.0011 0.0010800361633301 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
1288 0.0004 0.00042104721069336 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
1289 0.0004 0.00035190582275391 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
1290 0.0004 0.0003960132598877 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1291 0.0023 0.0022709369659424 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
1292 0.0007 0.00065016746520996 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
1293 0.0025 0.0024609565734863 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
1294 0.0019 0.0018649101257324 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
1295 0.0005 0.0004730224609375 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
1296 0.0008 0.0007781982421875 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
1297 0.0007 0.00072312355041504 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'