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
1.7088799476624 1179 1.3859 0


No Amazon API Requests Made.


App Debug - Total Time 1.7088799476624 seconds

Number Time From Start Name Description
1 0.24454784393311 Initialise Initialise FSB Function
2 0.2465980052948 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29551482200623 Start of getCategoryListByGroup Function Before first category groups query
4 0.29634094238281 After initial query Before first category groups query
5 0.29634189605713 Get Category List for Group Before the call to getCategoryList function
6 0.29634404182434 Start of GetCategoryList function Start of the function
7 0.29634499549866 Before getting categories Query to get specific category list
8 0.29672384262085 After getting categories Query to get specific category list
9 0.29672503471375 Before getting category custom Before call to function getCategoryCustom
10 0.30839586257935 After getting category custom After call to function getCategoryCustom
11 0.30839800834656 Before getting category custom Before call to function getCategoryCustom
12 0.3167998790741 After getting category custom After call to function getCategoryCustom
13 0.31680202484131 Before getting category custom Before call to function getCategoryCustom
14 0.32149386405945 After getting category custom After call to function getCategoryCustom
15 0.32149600982666 Before getting category custom Before call to function getCategoryCustom
16 0.32463002204895 After getting category custom After call to function getCategoryCustom
17 0.32463192939758 Before getting category custom Before call to function getCategoryCustom
18 0.32774996757507 After getting category custom After call to function getCategoryCustom
19 0.32775187492371 Before getting category custom Before call to function getCategoryCustom
20 0.33091998100281 After getting category custom After call to function getCategoryCustom
21 0.33092188835144 End of GetCategoryList function End of the function
22 0.33092904090881 Get Category List for Group Before the call to getCategoryList function
23 0.33093094825745 Start of GetCategoryList function Start of the function
24 0.33093190193176 Before getting categories Query to get specific category list
25 0.3312840461731 End of getCategoryListByGroup Function Before return()
26 1.1187088489532 App Controller End End of the App controller (called before the controller of every page)
27 1.1539649963379 Start of GetCategoryList function Start of the function
28 1.1539678573608 Before getting categories Query to get specific category list
29 1.1544008255005 After getting categories Query to get specific category list
30 1.1544008255005 Before getting category custom Before call to function getCategoryCustom
31 1.1663808822632 After getting category custom After call to function getCategoryCustom
32 1.1663830280304 Before getting sub category list Before call to recursive function getCategoryList
33 1.1663839817047 Start of GetCategoryList function Start of the function
34 1.1663858890533 Before getting categories Query to get specific category list
35 1.1667308807373 After getting sub category list After call to recursive function getCategoryList
36 1.1667318344116 Before getting category custom Before call to function getCategoryCustom
37 1.1751909255981 After getting category custom After call to function getCategoryCustom
38 1.1751909255981 Before getting sub category list Before call to recursive function getCategoryList
39 1.1751918792725 Start of GetCategoryList function Start of the function
40 1.1751928329468 Before getting categories Query to get specific category list
41 1.175528049469 After getting sub category list After call to recursive function getCategoryList
42 1.175528049469 Before getting category custom Before call to function getCategoryCustom
43 1.1814048290253 After getting category custom After call to function getCategoryCustom
44 1.1814048290253 Before getting sub category list Before call to recursive function getCategoryList
45 1.1814060211182 Start of GetCategoryList function Start of the function
46 1.1814069747925 Before getting categories Query to get specific category list
47 1.1817500591278 After getting sub category list After call to recursive function getCategoryList
48 1.1817510128021 Before getting category custom Before call to function getCategoryCustom
49 1.1851890087128 After getting category custom After call to function getCategoryCustom
50 1.1851899623871 Before getting sub category list Before call to recursive function getCategoryList
51 1.1851909160614 Start of GetCategoryList function Start of the function
52 1.18519282341 Before getting categories Query to get specific category list
53 1.1855850219727 After getting sub category list After call to recursive function getCategoryList
54 1.185585975647 Before getting category custom Before call to function getCategoryCustom
55 1.1889350414276 After getting category custom After call to function getCategoryCustom
56 1.1889359951019 Before getting sub category list Before call to recursive function getCategoryList
57 1.1889359951019 Start of GetCategoryList function Start of the function
58 1.1889379024506 Before getting categories Query to get specific category list
59 1.1893198490143 After getting sub category list After call to recursive function getCategoryList
60 1.1893210411072 Before getting category custom Before call to function getCategoryCustom
61 1.1927728652954 After getting category custom After call to function getCategoryCustom
62 1.1927728652954 Before getting sub category list Before call to recursive function getCategoryList
63 1.1927740573883 Start of GetCategoryList function Start of the function
64 1.1927750110626 Before getting categories Query to get specific category list
65 1.1931350231171 After getting sub category list After call to recursive function getCategoryList
66 1.1931369304657 End of GetCategoryList function End of the function
67 1.6213009357452 App_after Controller Start Start of the App_after controller (called after the controller of every page)
68 1.6227719783783 Before Get Options Before the call to getOptions in the tpl class
69 1.6724269390106 After Get Options After the call to getOptions in the tpl class
70 1.6724660396576 App_after Controller End End of the App_after controller (called after the controller of every page)
71 1.7088639736176 Finalizing debug Before the debug is output to the page.
72 1.708878993988 End of App This is the end of the app logging, final timestamp


Query Debug - 1179 Database Queries. Total time 1.3859 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0014770030975342 
SELECT parameter, value FROM parameters
2 0.0051 0.0051119327545166 
SELECT * FROM `bad_bots`
3 0.0003 0.00033092498779297 
SET time_zone = 'Europe/London'
4 0.0006 0.00063204765319824 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015699863433838 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.195\";}'
6 0.0014 0.0014059543609619 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751620520'
7 0.0017 0.0017268657684326 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054502487182617 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00059795379638672 
SELECT id FROM pages WHERE pagename = 'site-map' LIMIT 1
10 0.0004 0.00040006637573242 
SELECT * FROM pages WHERE id = 43
11 0.0022 0.002227783203125 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0459 0.045921802520752 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00051212310791016 
SELECT * FROM pages WHERE pagename = 'site-map'
14 0.0008 0.00082087516784668 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00036907196044922 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0047 0.0047121047973633 
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.0004 0.0003659725189209 
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.0003 0.00028014183044434 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00029420852661133 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0046 0.0046401023864746 
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.0004 0.0003669261932373 
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.0004 0.00036382675170898 
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.0003 0.00031304359436035 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00028896331787109 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0029640197753906 
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.0003 0.00034713745117188 
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.0003 0.00030803680419922 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00029206275939941 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0030 0.0030410289764404 
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.0004 0.00035810470581055 
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.0003 0.00034999847412109 
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.0004 0.00035214424133301 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00030708312988281 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0011370182037354 
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.0003 0.00031900405883789 
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.0003 0.00028300285339355 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00031614303588867 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0012 0.0012071132659912 
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.0004 0.00035595893859863 
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.0004 0.00035691261291504 
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.0003 0.00033712387084961 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.0003049373626709 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00041794776916504 
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.0003 0.00031089782714844 
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.0003 0.00028014183044434 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00029516220092773 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00045895576477051 
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.0003 0.00034213066101074 
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.0003 0.00034809112548828 
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.0003 0.00031900405883789 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00029397010803223 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00040006637573242 
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.0003 0.00032281875610352 
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.0003 0.00028014183044434 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00029397010803223 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00044584274291992 
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.0003 0.00032997131347656 
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.0004 0.00035309791564941 
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.0003 0.0003211498260498 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00030398368835449 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00040698051452637 
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.0003 0.00031208992004395 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00027704238891602 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00030612945556641 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00046896934509277 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0004 0.00036096572875977 
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.0004 0.0003509521484375 
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.0003 0.00032687187194824 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00029182434082031 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00034499168395996 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0013 0.00130295753479 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0010 0.0010421276092529 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00039505958557129 
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.0007 0.00066304206848145 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00089192390441895 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00059914588928223 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7786 0.77857112884521 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.195') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.195') <= INET_ATON(ip_end)
78 0.0015 0.0015149116516113 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0007 0.00066995620727539 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00056600570678711 
SELECT * FROM pages WHERE pagename = 'site-map'
81 0.0004 0.00041890144348145 
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0048 0.0048110485076904 
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.0004 0.00037598609924316 
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.0003 0.00031495094299316 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
85 0.0003 0.00031709671020508 
SELECT id FROM categories WHERE parent_id = '26'
86 0.0047 0.0046939849853516 
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.0004 0.00039505958557129 
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.0004 0.00038886070251465 
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.0003 0.00032210350036621 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
90 0.0003 0.00030398368835449 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0003 0.00033783912658691 
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
92 0.0030 0.0030410289764404 
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.0003 0.00033998489379883 
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.0003 0.00028014183044434 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0003 0.00031495094299316 
SELECT id FROM categories WHERE parent_id = '27'
96 0.0031 0.0030980110168457 
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.0003 0.00034213066101074 
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.0004 0.00037717819213867 
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.0003 0.00031900405883789 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0003 0.00030803680419922 
SELECT * FROM categorygroups WHERE id = '1'
101 0.0003 0.00033187866210938 
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
102 0.0023 0.0022709369659424 
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.0003 0.00032496452331543 
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.0003 0.00030708312988281 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
105 0.0003 0.00031900405883789 
SELECT id FROM categories WHERE parent_id = '28'
106 0.0012 0.001227855682373 
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.0004 0.00036501884460449 
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.0004 0.0003659725189209 
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.0003 0.00033903121948242 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
110 0.0003 0.00031518936157227 
SELECT * FROM categorygroups WHERE id = '1'
111 0.0003 0.00033998489379883 
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
112 0.0005 0.00046086311340332 
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.0004 0.00039005279541016 
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.0003 0.00030398368835449 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
115 0.0003 0.00029897689819336 
SELECT id FROM categories WHERE parent_id = '29'
116 0.0005 0.00047993659973145 
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.0003 0.00034093856811523 
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.0004 0.00036787986755371 
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.0004 0.00036907196044922 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
120 0.0003 0.00033903121948242 
SELECT * FROM categorygroups WHERE id = '1'
121 0.0004 0.00037002563476562 
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
122 0.0004 0.00044012069702148 
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.0003 0.00031018257141113 
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.0003 0.00031495094299316 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
125 0.0003 0.00031089782714844 
SELECT id FROM categories WHERE parent_id = '30'
126 0.0005 0.00050997734069824 
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.0004 0.00038695335388184 
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.0004 0.00035595893859863 
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.0003 0.00033187866210938 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
130 0.0003 0.00030708312988281 
SELECT * FROM categorygroups WHERE id = '1'
131 0.0004 0.00036501884460449 
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
132 0.0005 0.00048208236694336 
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.0003 0.00033307075500488 
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.0003 0.00032997131347656 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
135 0.0004 0.00039792060852051 
SELECT id FROM categories WHERE parent_id = '31'
136 0.0005 0.00051021575927734 
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.0003 0.00034403800964355 
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.0004 0.00036501884460449 
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.0003 0.00032496452331543 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
140 0.0003 0.00030303001403809 
SELECT * FROM categorygroups WHERE id = '1'
141 0.0004 0.00035595893859863 
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0008 0.00078701972961426 
SELECT * FROM pages WHERE xmlsitemap = 1
143 0.0040 0.0039949417114258 
SELECT COUNT(*) FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0
144 0.0047 0.0047249794006348 
SELECT * FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 ORDER BY linktitle LIMIT 959, 100
145 0.0004 0.0003809928894043 
SELECT * FROM productimages WHERE product_id = '1691' ORDER BY sortorder ASC
146 0.0005 0.0005030632019043 
SELECT * FROM product_image_select WHERE product_id = '1691'
147 0.0003 0.00031113624572754 
SELECT * FROM productcustomimages WHERE product_id = '1691'
148 0.0008 0.00076699256896973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1691' AND a.name = n.originalname
149 0.0004 0.00035309791564941 
SELECT * FROM productoffers WHERE product_id = '1691' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0003 0.00028204917907715 
SELECT * FROM productoffers
                WHERE product_id = '1691' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0003 0.0002589225769043 
SELECT * FROM productoffers
                WHERE product_id = 1691
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00028181076049805 
SELECT value FROM productattributes
                WHERE product_id = '1691'
                AND name = 'ListPriceAmount'
153 0.0004 0.00041604042053223 
SELECT value FROM productattributes WHERE product_id = '1691' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0003 0.00033807754516602 
SELECT * FROM productimages WHERE product_id = '3889' ORDER BY sortorder ASC
155 0.0004 0.00036883354187012 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3889' AND p.id = pi.product_id ORDER BY pi.sortorder
156 0.0005 0.00048685073852539 
SELECT * FROM product_image_select WHERE product_id = '3889'
157 0.0003 0.00028705596923828 
SELECT * FROM productcustomimages WHERE product_id = '3889'
158 0.0004 0.00039505958557129 
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 = '3889'
                GROUP BY o.product_id
159 0.0015 0.0014917850494385 
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     = '3889'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
160 0.0004 0.00037312507629395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3889
161 0.0006 0.00061416625976562 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3889' AND a.name = n.originalname
162 0.0003 0.00027680397033691 
SELECT * FROM productoffers WHERE product_id = '3889' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0003 0.00027108192443848 
SELECT * FROM productoffers
                WHERE product_id = '3889' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00023889541625977 
SELECT * FROM productoffers
                WHERE product_id = 3889
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00027298927307129 
SELECT value FROM productattributes
                WHERE product_id = '3889'
                AND name = 'ListPriceAmount'
166 0.0003 0.0002739429473877 
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 = '3889'
                GROUP BY o.product_id
167 0.0004 0.0004279613494873 
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     = '3889'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0003 0.00027298927307129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3889
169 0.0004 0.00036382675170898 
SELECT value FROM productattributes WHERE product_id = '3889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0003 0.00027799606323242 
SELECT * FROM products WHERE parent_id = '3889'
171 0.0004 0.00036501884460449 
SELECT * FROM productimages WHERE product_id = '3155' ORDER BY sortorder ASC
172 0.0003 0.00033807754516602 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3155' AND p.id = pi.product_id ORDER BY pi.sortorder
173 0.0005 0.0004730224609375 
SELECT * FROM product_image_select WHERE product_id = '3155'
174 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '3155'
175 0.0004 0.00037097930908203 
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 = '3155'
                GROUP BY o.product_id
176 0.0004 0.00043296813964844 
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     = '3155'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
177 0.0003 0.00027894973754883 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3155
178 0.0006 0.00060200691223145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3155' AND a.name = n.originalname
179 0.0003 0.0002598762512207 
SELECT * FROM productoffers WHERE product_id = '3155' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0003 0.00028300285339355 
SELECT * FROM productoffers
                WHERE product_id = '3155' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00024819374084473 
SELECT * FROM productoffers
                WHERE product_id = 3155
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00030088424682617 
SELECT value FROM productattributes
                WHERE product_id = '3155'
                AND name = 'ListPriceAmount'
183 0.0003 0.00029802322387695 
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 = '3155'
                GROUP BY o.product_id
184 0.0004 0.00043106079101562 
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     = '3155'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
185 0.0003 0.00028681755065918 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3155
186 0.0004 0.00036406517028809 
SELECT value FROM productattributes WHERE product_id = '3155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0004 0.00041007995605469 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3155'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
188 0.0004 0.00037384033203125 
SELECT * FROM productimages WHERE product_id = '3134' ORDER BY sortorder ASC
189 0.0004 0.00038290023803711 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3134' AND p.id = pi.product_id ORDER BY pi.sortorder
190 0.0005 0.00048995018005371 
SELECT * FROM product_image_select WHERE product_id = '3134'
191 0.0003 0.00029301643371582 
SELECT * FROM productcustomimages WHERE product_id = '3134'
192 0.0004 0.00037503242492676 
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 = '3134'
                GROUP BY o.product_id
193 0.0005 0.00050497055053711 
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
194 0.0003 0.00028896331787109 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
195 0.0006 0.00060296058654785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname
196 0.0003 0.00026512145996094 
SELECT * FROM productoffers WHERE product_id = '3134' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0003 0.00026321411132812 
SELECT * FROM productoffers
                WHERE product_id = '3134' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = 3134
                ORDER BY price ASC LIMIT 1
199 0.0003 0.0002598762512207 
SELECT value FROM productattributes
                WHERE product_id = '3134'
                AND name = 'ListPriceAmount'
200 0.0003 0.00029492378234863 
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 = '3134'
                GROUP BY o.product_id
201 0.0005 0.00046706199645996 
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
202 0.0003 0.00031709671020508 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
203 0.0004 0.00037097930908203 
SELECT value FROM productattributes WHERE product_id = '3134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00041103363037109 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3134'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
205 0.0004 0.00035500526428223 
SELECT * FROM productimages WHERE product_id = '2421' ORDER BY sortorder ASC
206 0.0005 0.00047922134399414 
SELECT * FROM product_image_select WHERE product_id = '2421'
207 0.0003 0.00029301643371582 
SELECT * FROM productcustomimages WHERE product_id = '2421'
208 0.0007 0.00072383880615234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2421' AND a.name = n.originalname
209 0.0004 0.00035309791564941 
SELECT * FROM productoffers WHERE product_id = '2421' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00028300285339355 
SELECT * FROM productoffers
                WHERE product_id = '2421' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00024199485778809 
SELECT * FROM productoffers
                WHERE product_id = 2421
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00025081634521484 
SELECT value FROM productattributes
                WHERE product_id = '2421'
                AND name = 'ListPriceAmount'
213 0.0003 0.00026416778564453 
SELECT value FROM productattributes WHERE product_id = '2421' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0004 0.00035786628723145 
SELECT * FROM productimages WHERE product_id = '4032' ORDER BY sortorder ASC
215 0.0005 0.00054597854614258 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4032' AND p.id = pi.product_id ORDER BY pi.sortorder
216 0.0005 0.00051403045654297 
SELECT * FROM product_image_select WHERE product_id = '4032'
217 0.0003 0.00028204917907715 
SELECT * FROM productcustomimages WHERE product_id = '4032'
218 0.0004 0.0003659725189209 
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 = '4032'
                GROUP BY o.product_id
219 0.0005 0.00045585632324219 
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
220 0.0003 0.00029182434082031 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
221 0.0006 0.0005791187286377 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4032' AND a.name = n.originalname
222 0.0003 0.00028300285339355 
SELECT * FROM productoffers WHERE product_id = '4032' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = '4032' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 4032
                ORDER BY price ASC LIMIT 1
225 0.0003 0.00026416778564453 
SELECT value FROM productattributes
                WHERE product_id = '4032'
                AND name = 'ListPriceAmount'
226 0.0003 0.00029802322387695 
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 = '4032'
                GROUP BY o.product_id
227 0.0005 0.00045895576477051 
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
228 0.0003 0.00028514862060547 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
229 0.0004 0.0003809928894043 
SELECT value FROM productattributes WHERE product_id = '4032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0004 0.00042605400085449 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4032'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
231 0.0004 0.00036215782165527 
SELECT * FROM productimages WHERE product_id = '3492' ORDER BY sortorder ASC
232 0.0004 0.00036716461181641 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3492' AND p.id = pi.product_id ORDER BY pi.sortorder
233 0.0005 0.00046110153198242 
SELECT * FROM product_image_select WHERE product_id = '3492'
234 0.0003 0.00027298927307129 
SELECT * FROM productcustomimages WHERE product_id = '3492'
235 0.0003 0.00034284591674805 
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 = '3492'
                GROUP BY o.product_id
236 0.0007 0.000701904296875 
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     = '3492'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
237 0.0003 0.00028491020202637 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3492
238 0.0007 0.00074100494384766 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3492' AND a.name = n.originalname
239 0.0003 0.00027799606323242 
SELECT * FROM productoffers WHERE product_id = '3492' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = '3492' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0003 0.00028800964355469 
SELECT * FROM productoffers
                WHERE product_id = 3492
                ORDER BY price ASC LIMIT 1
242 0.0003 0.00027894973754883 
SELECT value FROM productattributes
                WHERE product_id = '3492'
                AND name = 'ListPriceAmount'
243 0.0003 0.00029206275939941 
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 = '3492'
                GROUP BY o.product_id
244 0.0004 0.00042390823364258 
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     = '3492'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
245 0.0003 0.00028204917907715 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3492
246 0.0004 0.00039815902709961 
SELECT value FROM productattributes WHERE product_id = '3492' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0004 0.00040602684020996 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3492'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
248 0.0004 0.00035715103149414 
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
249 0.0005 0.00049185752868652 
SELECT * FROM product_image_select WHERE product_id = '4865'
250 0.0003 0.0002748966217041 
SELECT * FROM productcustomimages WHERE product_id = '4865'
251 0.0006 0.00057387351989746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4865' AND a.name = n.originalname
252 0.0003 0.00034403800964355 
SELECT * FROM productoffers WHERE product_id = '4865' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = '4865' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 4865
                ORDER BY price ASC LIMIT 1
255 0.0003 0.00027894973754883 
SELECT value FROM productattributes
                WHERE product_id = '4865'
                AND name = 'ListPriceAmount'
256 0.0003 0.00028085708618164 
SELECT value FROM productattributes WHERE product_id = '4865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0003 0.00032210350036621 
SELECT * FROM productimages WHERE product_id = '2023' ORDER BY sortorder ASC
258 0.0005 0.00045108795166016 
SELECT * FROM product_image_select WHERE product_id = '2023'
259 0.0003 0.00031399726867676 
SELECT * FROM productcustomimages WHERE product_id = '2023'
260 0.0005 0.00052785873413086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2023' AND a.name = n.originalname
261 0.0003 0.00032281875610352 
SELECT * FROM productoffers WHERE product_id = '2023' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0003 0.00027680397033691 
SELECT * FROM productoffers
                WHERE product_id = '2023' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = 2023
                ORDER BY price ASC LIMIT 1
264 0.0003 0.00026416778564453 
SELECT value FROM productattributes
                WHERE product_id = '2023'
                AND name = 'ListPriceAmount'
265 0.0003 0.00030398368835449 
SELECT value FROM productattributes WHERE product_id = '2023' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0004 0.0003821849822998 
SELECT * FROM productimages WHERE product_id = '1620' ORDER BY sortorder ASC
267 0.0004 0.00037813186645508 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1620' AND p.id = pi.product_id ORDER BY pi.sortorder
268 0.0005 0.0005340576171875 
SELECT * FROM product_image_select WHERE product_id = '1620'
269 0.0003 0.00028800964355469 
SELECT * FROM productcustomimages WHERE product_id = '1620'
270 0.0005 0.00046491622924805 
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 = '1620'
                GROUP BY o.product_id
271 0.0004 0.00044989585876465 
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     = '1620'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
272 0.0003 0.00027608871459961 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1620
273 0.0007 0.00066781044006348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1620' AND a.name = n.originalname
274 0.0003 0.00030112266540527 
SELECT * FROM productoffers WHERE product_id = '1620' AND merchantid = 'A1X6FK5RDHNB96'
275 0.0003 0.00029993057250977 
SELECT * FROM productoffers
                WHERE product_id = '1620' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0003 0.0002748966217041 
SELECT * FROM productoffers
                WHERE product_id = 1620
                ORDER BY price ASC LIMIT 1
277 0.0003 0.00032401084899902 
SELECT value FROM productattributes
                WHERE product_id = '1620'
                AND name = 'ListPriceAmount'
278 0.0003 0.00028085708618164 
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 = '1620'
                GROUP BY o.product_id
279 0.0004 0.00044107437133789 
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     = '1620'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
280 0.0003 0.00026488304138184 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1620
281 0.0004 0.00040817260742188 
SELECT value FROM productattributes WHERE product_id = '1620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0004 0.00042200088500977 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1620'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
283 0.0004 0.00035786628723145 
SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
284 0.0004 0.00036787986755371 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
285 0.0005 0.00047397613525391 
SELECT * FROM product_image_select WHERE product_id = '3551'
286 0.0003 0.00031208992004395 
SELECT * FROM productcustomimages WHERE product_id = '3551'
287 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 = '3551'
                GROUP BY o.product_id
288 0.0005 0.00045990943908691 
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     = '3551'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
289 0.0003 0.00027704238891602 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
290 0.0005 0.0005490779876709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
291 0.0003 0.00027203559875488 
SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '3551' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0003 0.00025796890258789 
SELECT * FROM productoffers
                WHERE product_id = 3551
                ORDER BY price ASC LIMIT 1
294 0.0003 0.00028085708618164 
SELECT value FROM productattributes
                WHERE product_id = '3551'
                AND name = 'ListPriceAmount'
295 0.0003 0.0003209114074707 
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 = '3551'
                GROUP BY o.product_id
296 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     = '3551'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
297 0.0003 0.00027799606323242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
298 0.0004 0.00037097930908203 
SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0004 0.00040006637573242 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3551'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
300 0.0013 0.0012578964233398 
SELECT * FROM productimages WHERE product_id = '1808' ORDER BY sortorder ASC
301 0.0005 0.00046300888061523 
SELECT * FROM product_image_select WHERE product_id = '1808'
302 0.0003 0.00029206275939941 
SELECT * FROM productcustomimages WHERE product_id = '1808'
303 0.0009 0.0009009838104248 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1808' AND a.name = n.originalname
304 0.0003 0.00034403800964355 
SELECT * FROM productoffers WHERE product_id = '1808' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = '1808' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = 1808
                ORDER BY price ASC LIMIT 1
307 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '1808'
                AND name = 'ListPriceAmount'
308 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '1808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0004 0.00036311149597168 
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
310 0.0004 0.00044703483581543 
SELECT * FROM product_image_select WHERE product_id = '4954'
311 0.0003 0.0002751350402832 
SELECT * FROM productcustomimages WHERE product_id = '4954'
312 0.0006 0.00057291984558105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
313 0.0003 0.00034594535827637 
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
314 0.0003 0.00029516220092773 
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
315 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
316 0.0003 0.00033807754516602 
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
317 0.0005 0.00045919418334961 
SELECT * FROM product_image_select WHERE product_id = '4939'
318 0.0003 0.00028800964355469 
SELECT * FROM productcustomimages WHERE product_id = '4939'
319 0.0007 0.00070381164550781 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
320 0.0003 0.00032210350036621 
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
321 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
322 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323 0.0004 0.00035595893859863 
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
324 0.0005 0.00046300888061523 
SELECT * FROM product_image_select WHERE product_id = '3546'
325 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '3546'
326 0.0006 0.00057387351989746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
327 0.0003 0.0003359317779541 
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0003 0.00027894973754883 
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0003 0.00026798248291016 
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0003 0.00033307075500488 
SELECT * FROM productimages WHERE product_id = '1413' ORDER BY sortorder ASC
331 0.0004 0.00044512748718262 
SELECT * FROM product_image_select WHERE product_id = '1413'
332 0.0003 0.00028085708618164 
SELECT * FROM productcustomimages WHERE product_id = '1413'
333 0.0007 0.00067710876464844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1413' AND a.name = n.originalname
334 0.0003 0.00031781196594238 
SELECT * FROM productoffers WHERE product_id = '1413' AND merchantid = 'A1X6FK5RDHNB96'
335 0.0003 0.00029993057250977 
SELECT * FROM productoffers
                WHERE product_id = '1413' AND price > 0
                ORDER BY price ASC LIMIT 1
336 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = 1413
                ORDER BY price ASC LIMIT 1
337 0.0003 0.00026416778564453 
SELECT value FROM productattributes
                WHERE product_id = '1413'
                AND name = 'ListPriceAmount'
338 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '1413' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0003 0.00032591819763184 
SELECT * FROM productimages WHERE product_id = '1083' ORDER BY sortorder ASC
340 0.0005 0.00047421455383301 
SELECT * FROM product_image_select WHERE product_id = '1083'
341 0.0003 0.00028586387634277 
SELECT * FROM productcustomimages WHERE product_id = '1083'
342 0.0007 0.0006709098815918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1083' AND a.name = n.originalname
343 0.0003 0.00032901763916016 
SELECT * FROM productoffers WHERE product_id = '1083' AND merchantid = 'A1X6FK5RDHNB96'
344 0.0003 0.00027894973754883 
SELECT * FROM productoffers
                WHERE product_id = '1083' AND price > 0
                ORDER BY price ASC LIMIT 1
345 0.0003 0.00026893615722656 
SELECT * FROM productoffers
                WHERE product_id = 1083
                ORDER BY price ASC LIMIT 1
346 0.0003 0.0002748966217041 
SELECT value FROM productattributes
                WHERE product_id = '1083'
                AND name = 'ListPriceAmount'
347 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '1083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348 0.0003 0.0003349781036377 
SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
349 0.0004 0.00039792060852051 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
350 0.0005 0.00046491622924805 
SELECT * FROM product_image_select WHERE product_id = '3626'
351 0.0003 0.00028085708618164 
SELECT * FROM productcustomimages WHERE product_id = '3626'
352 0.0003 0.00034999847412109 
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 = '3626'
                GROUP BY o.product_id
353 0.0004 0.0004420280456543 
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
354 0.0003 0.00029110908508301 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
355 0.0006 0.00063991546630859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
356 0.0003 0.00026679039001465 
SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
357 0.0003 0.00026607513427734 
SELECT * FROM productoffers
                WHERE product_id = '3626' AND price > 0
                ORDER BY price ASC LIMIT 1
358 0.0005 0.00049400329589844 
SELECT * FROM productoffers
                WHERE product_id = 3626
                ORDER BY price ASC LIMIT 1
359 0.0003 0.00026917457580566 
SELECT value FROM productattributes
                WHERE product_id = '3626'
                AND name = 'ListPriceAmount'
360 0.0003 0.00027585029602051 
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 = '3626'
                GROUP BY o.product_id
361 0.0005 0.00045609474182129 
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
362 0.0003 0.00027608871459961 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
363 0.0004 0.00035500526428223 
SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0004 0.00043106079101562 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3626'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
365 0.0003 0.00033378601074219 
SELECT * FROM productimages WHERE product_id = '1167' ORDER BY sortorder ASC
366 0.0028 0.0028209686279297 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1167' AND p.id = pi.product_id ORDER BY pi.sortorder
367 0.0005 0.00051188468933105 
SELECT * FROM product_image_select WHERE product_id = '1167'
368 0.0003 0.00029587745666504 
SELECT * FROM productcustomimages WHERE product_id = '1167'
369 0.0007 0.00071597099304199 
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 = '1167'
                GROUP BY o.product_id
370 0.0018 0.0017688274383545 
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     = '1167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
371 0.0006 0.00059700012207031 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
372 0.0006 0.00060200691223145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
373 0.0003 0.00032281875610352 
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
374 0.0003 0.00025486946105957 
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
375 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
376 0.0002 0.00024795532226562 
SELECT value FROM productattributes
                WHERE product_id = '1167'
                AND name = 'ListPriceAmount'
377 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 = '1167'
                GROUP BY o.product_id
378 0.0033 0.0032730102539062 
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     = '1167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
379 0.0011 0.001072883605957 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
380 0.0005 0.00050497055053711 
SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381 0.0057 0.0056979656219482 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1167'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
382 0.0011 0.001093864440918 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1167'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
383 0.0004 0.00037598609924316 
SELECT * FROM productimages WHERE product_id = '879' ORDER BY sortorder ASC
384 0.0005 0.00049901008605957 
SELECT * FROM product_image_select WHERE product_id = '879'
385 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '879'
386 0.0016 0.0016491413116455 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '879' AND a.name = n.originalname
387 0.0007 0.00066995620727539 
SELECT * FROM productoffers WHERE product_id = '879' AND merchantid = 'A1X6FK5RDHNB96'
388 0.0028 0.0028378963470459 
SELECT * FROM productoffers
                WHERE product_id = '879' AND price > 0
                ORDER BY price ASC LIMIT 1
389 0.0002 0.00024104118347168 
SELECT * FROM productoffers
                WHERE product_id = 879
                ORDER BY price ASC LIMIT 1
390 0.0003 0.0002589225769043 
SELECT value FROM productattributes
                WHERE product_id = '879'
                AND name = 'ListPriceAmount'
391 0.0003 0.00027799606323242 
SELECT value FROM productattributes WHERE product_id = '879' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
392 0.0003 0.00033092498779297 
SELECT * FROM productimages WHERE product_id = '920' ORDER BY sortorder ASC
393 0.0008 0.00077295303344727 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '920' AND p.id = pi.product_id ORDER BY pi.sortorder
394 0.0008 0.00078201293945312 
SELECT * FROM product_image_select WHERE product_id = '920'
395 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '920'
396 0.0005 0.00054597854614258 
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 = '920'
                GROUP BY o.product_id
397 0.0005 0.00052404403686523 
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     = '920'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
398 0.0003 0.00025820732116699 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 920
399 0.0009 0.00088191032409668 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '920' AND a.name = n.originalname
400 0.0004 0.00042486190795898 
SELECT * FROM productoffers WHERE product_id = '920' AND merchantid = 'A1X6FK5RDHNB96'
401 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '920' AND price > 0
                ORDER BY price ASC LIMIT 1
402 0.0002 0.0002439022064209 
SELECT * FROM productoffers
                WHERE product_id = 920
                ORDER BY price ASC LIMIT 1
403 0.0003 0.00026798248291016 
SELECT value FROM productattributes
                WHERE product_id = '920'
                AND name = 'ListPriceAmount'
404 0.0003 0.00026893615722656 
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 = '920'
                GROUP BY o.product_id
405 0.0005 0.0004570484161377 
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     = '920'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
406 0.0003 0.00026082992553711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 920
407 0.0004 0.00038909912109375 
SELECT value FROM productattributes WHERE product_id = '920' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
408 0.0003 0.00029492378234863 
SELECT * FROM products WHERE parent_id = '920'
409 0.0003 0.00033998489379883 
SELECT * FROM productimages WHERE product_id = '860' ORDER BY sortorder ASC
410 0.0003 0.0002751350402832 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '860' AND p.id = pi.product_id ORDER BY pi.sortorder
411 0.0009 0.00091195106506348 
SELECT * FROM product_image_select WHERE product_id = '860'
412 0.0011 0.0011091232299805 
SELECT * FROM productcustomimages WHERE product_id = '860'
413 0.0009 0.00090813636779785 
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 = '860'
                GROUP BY o.product_id
414 0.0012 0.0011951923370361 
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     = '860'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
415 0.0003 0.00028610229492188 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 860
416 0.0009 0.00085091590881348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '860' AND a.name = n.originalname
417 0.0003 0.00027298927307129 
SELECT * FROM productoffers WHERE product_id = '860' AND merchantid = 'A1X6FK5RDHNB96'
418 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = '860' AND price > 0
                ORDER BY price ASC LIMIT 1
419 0.0005 0.00048589706420898 
SELECT * FROM productoffers
                WHERE product_id = 860
                ORDER BY price ASC LIMIT 1
420 0.0005 0.00047802925109863 
SELECT value FROM productattributes
                WHERE product_id = '860'
                AND name = 'ListPriceAmount'
421 0.0003 0.00027799606323242 
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 = '860'
                GROUP BY o.product_id
422 0.0013 0.0013298988342285 
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     = '860'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
423 0.0003 0.00027298927307129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 860
424 0.0006 0.00063300132751465 
SELECT value FROM productattributes WHERE product_id = '860' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0004 0.00044584274291992 
SELECT * FROM products WHERE parent_id = '860'
426 0.0005 0.0004889965057373 
SELECT * FROM productimages WHERE product_id = '915' ORDER BY sortorder ASC
427 0.0009 0.00092506408691406 
SELECT * FROM product_image_select WHERE product_id = '915'
428 0.0005 0.00045299530029297 
SELECT * FROM productcustomimages WHERE product_id = '915'
429 0.0011 0.0011239051818848 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname
430 0.0005 0.00048708915710449 
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
431 0.0005 0.00046801567077637 
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
433 0.0009 0.00091314315795898 
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
434 0.0003 0.00029611587524414 
SELECT value FROM productattributes WHERE product_id = '915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
435 0.0005 0.00046300888061523 
SELECT * FROM productimages WHERE product_id = '1042' ORDER BY sortorder ASC
436 0.0006 0.00056982040405273 
SELECT * FROM product_image_select WHERE product_id = '1042'
437 0.0005 0.00052118301391602 
SELECT * FROM productcustomimages WHERE product_id = '1042'
438 0.0005 0.00053095817565918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1042' AND a.name = n.originalname
439 0.0006 0.00061416625976562 
SELECT * FROM productoffers WHERE product_id = '1042' AND merchantid = 'A1X6FK5RDHNB96'
440 0.0007 0.00067496299743652 
SELECT * FROM productoffers
                WHERE product_id = '1042' AND price > 0
                ORDER BY price ASC LIMIT 1
441 0.0004 0.00044107437133789 
SELECT * FROM productoffers
                WHERE product_id = 1042
                ORDER BY price ASC LIMIT 1
442 0.0004 0.00037693977355957 
SELECT value FROM productattributes
                WHERE product_id = '1042'
                AND name = 'ListPriceAmount'
443 0.0007 0.00066995620727539 
SELECT value FROM productattributes WHERE product_id = '1042' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0005 0.00054311752319336 
SELECT * FROM productimages WHERE product_id = '914' ORDER BY sortorder ASC
445 0.0007 0.00071001052856445 
SELECT * FROM product_image_select WHERE product_id = '914'
446 0.0004 0.00037312507629395 
SELECT * FROM productcustomimages WHERE product_id = '914'
447 0.0008 0.0008080005645752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '914' AND a.name = n.originalname
448 0.0005 0.00050902366638184 
SELECT * FROM productoffers WHERE product_id = '914' AND merchantid = 'A1X6FK5RDHNB96'
449 0.0004 0.00044584274291992 
SELECT * FROM productoffers
                WHERE product_id = '914' AND price > 0
                ORDER BY price ASC LIMIT 1
450 0.0003 0.00033307075500488 
SELECT * FROM productoffers
                WHERE product_id = 914
                ORDER BY price ASC LIMIT 1
451 0.0004 0.0004429817199707 
SELECT value FROM productattributes
                WHERE product_id = '914'
                AND name = 'ListPriceAmount'
452 0.0003 0.00032997131347656 
SELECT value FROM productattributes WHERE product_id = '914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0006 0.00063610076904297 
SELECT * FROM productimages WHERE product_id = '2243' ORDER BY sortorder ASC
454 0.0005 0.00051784515380859 
SELECT * FROM product_image_select WHERE product_id = '2243'
455 0.0003 0.00029611587524414 
SELECT * FROM productcustomimages WHERE product_id = '2243'
456 0.0012 0.001194953918457 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2243' AND a.name = n.originalname
457 0.0005 0.00046896934509277 
SELECT * FROM productoffers WHERE product_id = '2243' AND merchantid = 'A1X6FK5RDHNB96'
458 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '2243' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0003 0.00034213066101074 
SELECT * FROM productoffers
                WHERE product_id = 2243
                ORDER BY price ASC LIMIT 1
460 0.0007 0.00074195861816406 
SELECT value FROM productattributes
                WHERE product_id = '2243'
                AND name = 'ListPriceAmount'
461 0.0003 0.00034403800964355 
SELECT value FROM productattributes WHERE product_id = '2243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
462 0.0007 0.0007178783416748 
SELECT * FROM productimages WHERE product_id = '2286' ORDER BY sortorder ASC
463 0.0005 0.00048184394836426 
SELECT * FROM product_image_select WHERE product_id = '2286'
464 0.0003 0.00032520294189453 
SELECT * FROM productcustomimages WHERE product_id = '2286'
465 0.0008 0.00076699256896973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2286' AND a.name = n.originalname
466 0.0009 0.0008690357208252 
SELECT * FROM productoffers WHERE product_id = '2286' AND merchantid = 'A1X6FK5RDHNB96'
467 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = '2286' AND price > 0
                ORDER BY price ASC LIMIT 1
468 0.0003 0.00031304359436035 
SELECT * FROM productoffers
                WHERE product_id = 2286
                ORDER BY price ASC LIMIT 1
469 0.0007 0.00069594383239746 
SELECT value FROM productattributes
                WHERE product_id = '2286'
                AND name = 'ListPriceAmount'
470 0.0006 0.00059890747070312 
SELECT value FROM productattributes WHERE product_id = '2286' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
471 0.0006 0.00059008598327637 
SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
472 0.0008 0.00084304809570312 
SELECT * FROM product_image_select WHERE product_id = '3704'
473 0.0004 0.00041413307189941 
SELECT * FROM productcustomimages WHERE product_id = '3704'
474 0.0008 0.00077986717224121 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3704' AND a.name = n.originalname
475 0.0008 0.00084209442138672 
SELECT * FROM productoffers WHERE product_id = '3704' AND merchantid = 'A1X6FK5RDHNB96'
476 0.0003 0.00028514862060547 
SELECT * FROM productoffers
                WHERE product_id = '3704' AND price > 0
                ORDER BY price ASC LIMIT 1
477 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = 3704
                ORDER BY price ASC LIMIT 1
478 0.0003 0.00028014183044434 
SELECT value FROM productattributes
                WHERE product_id = '3704'
                AND name = 'ListPriceAmount'
479 0.0003 0.00031685829162598 
SELECT value FROM productattributes WHERE product_id = '3704' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
480 0.0004 0.00035881996154785 
SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
481 0.0007 0.00069308280944824 
SELECT * FROM product_image_select WHERE product_id = '3665'
482 0.0003 0.00029397010803223 
SELECT * FROM productcustomimages WHERE product_id = '3665'
483 0.0006 0.00057792663574219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
484 0.0003 0.00034213066101074 
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
485 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
486 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
487 0.0003 0.00028395652770996 
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
488 0.0003 0.00031113624572754 
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
489 0.0003 0.00033307075500488 
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
490 0.0004 0.00044679641723633 
SELECT * FROM product_image_select WHERE product_id = '3664'
491 0.0003 0.0002901554107666 
SELECT * FROM productcustomimages WHERE product_id = '3664'
492 0.0005 0.00052809715270996 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
493 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
494 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
495 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
496 0.0003 0.00029802322387695 
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
497 0.0003 0.00029087066650391 
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
498 0.0003 0.00032281875610352 
SELECT * FROM productimages WHERE product_id = '885' ORDER BY sortorder ASC
499 0.0005 0.0005180835723877 
SELECT * FROM product_image_select WHERE product_id = '885'
500 0.0003 0.00033211708068848 
SELECT * FROM productcustomimages WHERE product_id = '885'
501 0.0006 0.00058913230895996 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '885' AND a.name = n.originalname
502 0.0004 0.00037813186645508 
SELECT * FROM productoffers WHERE product_id = '885' AND merchantid = 'A1X6FK5RDHNB96'
503 0.0003 0.00027990341186523 
SELECT * FROM productoffers
                WHERE product_id = '885' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 885
                ORDER BY price ASC LIMIT 1
505 0.0003 0.00025391578674316 
SELECT value FROM productattributes
                WHERE product_id = '885'
                AND name = 'ListPriceAmount'
506 0.0003 0.0002901554107666 
SELECT value FROM productattributes WHERE product_id = '885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
507 0.0003 0.00032901763916016 
SELECT * FROM productimages WHERE product_id = '1135' ORDER BY sortorder ASC
508 0.0005 0.00045108795166016 
SELECT * FROM product_image_select WHERE product_id = '1135'
509 0.0003 0.00028204917907715 
SELECT * FROM productcustomimages WHERE product_id = '1135'
510 0.0006 0.00061297416687012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1135' AND a.name = n.originalname
511 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '1135' AND merchantid = 'A1X6FK5RDHNB96'
512 0.0003 0.00029706954956055 
SELECT * FROM productoffers
                WHERE product_id = '1135' AND price > 0
                ORDER BY price ASC LIMIT 1
513 0.0003 0.00029587745666504 
SELECT value FROM productattributes WHERE product_id = '1135' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
514 0.0003 0.00031590461730957 
SELECT * FROM productimages WHERE product_id = '1003' ORDER BY sortorder ASC
515 0.0004 0.0004420280456543 
SELECT * FROM product_image_select WHERE product_id = '1003'
516 0.0003 0.00028109550476074 
SELECT * FROM productcustomimages WHERE product_id = '1003'
517 0.0006 0.00063705444335938 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1003' AND a.name = n.originalname
518 0.0004 0.00038599967956543 
SELECT * FROM productoffers WHERE product_id = '1003' AND merchantid = 'A1X6FK5RDHNB96'
519 0.0003 0.00030899047851562 
SELECT * FROM productoffers
                WHERE product_id = '1003' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = 1003
                ORDER BY price ASC LIMIT 1
521 0.0003 0.00027990341186523 
SELECT value FROM productattributes
                WHERE product_id = '1003'
                AND name = 'ListPriceAmount'
522 0.0003 0.00030803680419922 
SELECT value FROM productattributes WHERE product_id = '1003' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
523 0.0004 0.00043296813964844 
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
524 0.0005 0.0004570484161377 
SELECT * FROM product_image_select WHERE product_id = '931'
525 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '931'
526 0.0006 0.00062704086303711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
527 0.0003 0.00032997131347656 
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
528 0.0003 0.00030517578125 
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
529 0.0003 0.00026798248291016 
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
530 0.0003 0.00033307075500488 
SELECT * FROM productimages WHERE product_id = '1602' ORDER BY sortorder ASC
531 0.0005 0.00048589706420898 
SELECT * FROM product_image_select WHERE product_id = '1602'
532 0.0003 0.00029706954956055 
SELECT * FROM productcustomimages WHERE product_id = '1602'
533 0.0007 0.00074005126953125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1602' AND a.name = n.originalname
534 0.0003 0.0003209114074707 
SELECT * FROM productoffers WHERE product_id = '1602' AND merchantid = 'A1X6FK5RDHNB96'
535 0.0003 0.00025796890258789 
SELECT * FROM productoffers
                WHERE product_id = '1602' AND price > 0
                ORDER BY price ASC LIMIT 1
536 0.0003 0.00027704238891602 
SELECT * FROM productoffers
                WHERE product_id = 1602
                ORDER BY price ASC LIMIT 1
537 0.0003 0.00028800964355469 
SELECT value FROM productattributes
                WHERE product_id = '1602'
                AND name = 'ListPriceAmount'
538 0.0003 0.00030684471130371 
SELECT value FROM productattributes WHERE product_id = '1602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
539 0.0003 0.00033807754516602 
SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
540 0.0005 0.0004570484161377 
SELECT * FROM product_image_select WHERE product_id = '1075'
541 0.0003 0.0003058910369873 
SELECT * FROM productcustomimages WHERE product_id = '1075'
542 0.0007 0.00069189071655273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1075' AND a.name = n.originalname
543 0.0003 0.00033092498779297 
SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
544 0.0003 0.00026106834411621 
SELECT * FROM productoffers
                WHERE product_id = '1075' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 1075
                ORDER BY price ASC LIMIT 1
546 0.0003 0.00025296211242676 
SELECT value FROM productattributes
                WHERE product_id = '1075'
                AND name = 'ListPriceAmount'
547 0.0003 0.00026607513427734 
SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
548 0.0004 0.0003511905670166 
SELECT * FROM productimages WHERE product_id = '1062' ORDER BY sortorder ASC
549 0.0005 0.0004570484161377 
SELECT * FROM product_image_select WHERE product_id = '1062'
550 0.0003 0.00030398368835449 
SELECT * FROM productcustomimages WHERE product_id = '1062'
551 0.0006 0.0006251335144043 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1062' AND a.name = n.originalname
552 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '1062' AND merchantid = 'A1X6FK5RDHNB96'
553 0.0003 0.00027990341186523 
SELECT * FROM productoffers
                WHERE product_id = '1062' AND price > 0
                ORDER BY price ASC LIMIT 1
554 0.0002 0.00023984909057617 
SELECT * FROM productoffers
                WHERE product_id = 1062
                ORDER BY price ASC LIMIT 1
555 0.0002 0.00024199485778809 
SELECT value FROM productattributes
                WHERE product_id = '1062'
                AND name = 'ListPriceAmount'
556 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '1062' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
557 0.0003 0.0003199577331543 
SELECT * FROM productimages WHERE product_id = '947' ORDER BY sortorder ASC
558 0.0005 0.00045990943908691 
SELECT * FROM product_image_select WHERE product_id = '947'
559 0.0003 0.00031280517578125 
SELECT * FROM productcustomimages WHERE product_id = '947'
560 0.0006 0.00061202049255371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '947' AND a.name = n.originalname
561 0.0004 0.00035405158996582 
SELECT * FROM productoffers WHERE product_id = '947' AND merchantid = 'A1X6FK5RDHNB96'
562 0.0003 0.0002741813659668 
SELECT * FROM productoffers
                WHERE product_id = '947' AND price > 0
                ORDER BY price ASC LIMIT 1
563 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 947
                ORDER BY price ASC LIMIT 1
564 0.0003 0.00025606155395508 
SELECT value FROM productattributes
                WHERE product_id = '947'
                AND name = 'ListPriceAmount'
565 0.0003 0.00028491020202637 
SELECT value FROM productattributes WHERE product_id = '947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
566 0.0003 0.00034117698669434 
SELECT * FROM productimages WHERE product_id = '1153' ORDER BY sortorder ASC
567 0.0004 0.00044608116149902 
SELECT * FROM product_image_select WHERE product_id = '1153'
568 0.0003 0.00028705596923828 
SELECT * FROM productcustomimages WHERE product_id = '1153'
569 0.0007 0.00071096420288086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1153' AND a.name = n.originalname
570 0.0003 0.0003359317779541 
SELECT * FROM productoffers WHERE product_id = '1153' AND merchantid = 'A1X6FK5RDHNB96'
571 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = '1153' AND price > 0
                ORDER BY price ASC LIMIT 1
572 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '1153' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
573 0.0003 0.00031208992004395 
SELECT * FROM productimages WHERE product_id = '793' ORDER BY sortorder ASC
574 0.0005 0.00046682357788086 
SELECT * FROM product_image_select WHERE product_id = '793'
575 0.0003 0.0002899169921875 
SELECT * FROM productcustomimages WHERE product_id = '793'
576 0.0005 0.0005490779876709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '793' AND a.name = n.originalname
577 0.0003 0.00031805038452148 
SELECT * FROM productoffers WHERE product_id = '793' AND merchantid = 'A1X6FK5RDHNB96'
578 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '793' AND price > 0
                ORDER BY price ASC LIMIT 1
579 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = 793
                ORDER BY price ASC LIMIT 1
580 0.0002 0.00024700164794922 
SELECT value FROM productattributes
                WHERE product_id = '793'
                AND name = 'ListPriceAmount'
581 0.0003 0.00029110908508301 
SELECT value FROM productattributes WHERE product_id = '793' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
582 0.0003 0.00033998489379883 
SELECT * FROM productimages WHERE product_id = '4758' ORDER BY sortorder ASC
583 0.0005 0.00045609474182129 
SELECT * FROM product_image_select WHERE product_id = '4758'
584 0.0003 0.00028491020202637 
SELECT * FROM productcustomimages WHERE product_id = '4758'
585 0.0005 0.00052785873413086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
586 0.0003 0.00031113624572754 
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
587 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
589 0.0003 0.00026202201843262 
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
590 0.0003 0.00027108192443848 
SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
591 0.0003 0.00031805038452148 
SELECT * FROM productimages WHERE product_id = '3594' ORDER BY sortorder ASC
592 0.0004 0.00037813186645508 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3594' AND p.id = pi.product_id ORDER BY pi.sortorder
593 0.0005 0.00049090385437012 
SELECT * FROM product_image_select WHERE product_id = '3594'
594 0.0003 0.00027585029602051 
SELECT * FROM productcustomimages WHERE product_id = '3594'
595 0.0003 0.00034594535827637 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3594'
                GROUP BY o.product_id
596 0.0005 0.00045514106750488 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
597 0.0003 0.00026893615722656 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3594
598 0.0006 0.00056886672973633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3594' AND a.name = n.originalname
599 0.0003 0.00025415420532227 
SELECT * FROM productoffers WHERE product_id = '3594' AND merchantid = 'A1X6FK5RDHNB96'
600 0.0003 0.00026106834411621 
SELECT * FROM productoffers
                WHERE product_id = '3594' AND price > 0
                ORDER BY price ASC LIMIT 1
601 0.0002 0.00023794174194336 
SELECT * FROM productoffers
                WHERE product_id = 3594
                ORDER BY price ASC LIMIT 1
602 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '3594'
                AND name = 'ListPriceAmount'
603 0.0003 0.00027608871459961 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3594'
                GROUP BY o.product_id
604 0.0004 0.00041604042053223 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
605 0.0003 0.00027990341186523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3594
606 0.0004 0.0003812313079834 
SELECT value FROM productattributes WHERE product_id = '3594' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
607 0.0004 0.00037908554077148 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3594'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
608 0.0003 0.00030899047851562 
SELECT * FROM products WHERE parent_id = '3594'
609 0.0003 0.00034499168395996 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3969' AND a.name = n.originalname
610 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '3969' AND merchantid = 'A1X6FK5RDHNB96'
611 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '3969' AND price > 0
                ORDER BY price ASC LIMIT 1
612 0.0002 0.00023484230041504 
SELECT * FROM productoffers
                WHERE product_id = 3969
                ORDER BY price ASC LIMIT 1
613 0.0003 0.00026607513427734 
SELECT value FROM productattributes
                WHERE product_id = '3969'
                AND name = 'ListPriceAmount'
614 0.0004 0.00037312507629395 
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
615 0.0005 0.00047707557678223 
SELECT * FROM product_image_select WHERE product_id = '883'
616 0.0003 0.00028800964355469 
SELECT * FROM productcustomimages WHERE product_id = '883'
617 0.0005 0.00049996376037598 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
618 0.0003 0.00032305717468262 
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
619 0.0003 0.00026416778564453 
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
620 0.0003 0.00025582313537598 
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
621 0.0003 0.0002589225769043 
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
622 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
623 0.0003 0.00031900405883789 
SELECT * FROM productimages WHERE product_id = '1317' ORDER BY sortorder ASC
624 0.0004 0.00044393539428711 
SELECT * FROM product_image_select WHERE product_id = '1317'
625 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '1317'
626 0.0005 0.00049209594726562 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1317' AND a.name = n.originalname
627 0.0003 0.00033688545227051 
SELECT * FROM productoffers WHERE product_id = '1317' AND merchantid = 'A1X6FK5RDHNB96'
628 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = '1317' AND price > 0
                ORDER BY price ASC LIMIT 1
629 0.0002 0.00023698806762695 
SELECT * FROM productoffers
                WHERE product_id = 1317
                ORDER BY price ASC LIMIT 1
630 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '1317'
                AND name = 'ListPriceAmount'
631 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '1317' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
632 0.0004 0.00035595893859863 
SELECT * FROM productimages WHERE product_id = '989' ORDER BY sortorder ASC
633 0.0005 0.00047707557678223 
SELECT * FROM product_image_select WHERE product_id = '989'
634 0.0003 0.00028491020202637 
SELECT * FROM productcustomimages WHERE product_id = '989'
635 0.0006 0.00057005882263184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '989' AND a.name = n.originalname
636 0.0003 0.00033092498779297 
SELECT * FROM productoffers WHERE product_id = '989' AND merchantid = 'A1X6FK5RDHNB96'
637 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = '989' AND price > 0
                ORDER BY price ASC LIMIT 1
638 0.0003 0.00027608871459961 
SELECT value FROM productattributes WHERE product_id = '989' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
639 0.0003 0.00032782554626465 
SELECT * FROM productimages WHERE product_id = '3214' ORDER BY sortorder ASC
640 0.0004 0.0003511905670166 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3214' AND p.id = pi.product_id ORDER BY pi.sortorder
641 0.0005 0.00048589706420898 
SELECT * FROM product_image_select WHERE product_id = '3214'
642 0.0003 0.00029397010803223 
SELECT * FROM productcustomimages WHERE product_id = '3214'
643 0.0004 0.00035381317138672 
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 = '3214'
                GROUP BY o.product_id
644 0.0004 0.00041890144348145 
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     = '3214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
645 0.0003 0.00031495094299316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3214
646 0.0008 0.00075888633728027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3214' AND a.name = n.originalname
647 0.0003 0.00031304359436035 
SELECT * FROM productoffers WHERE product_id = '3214' AND merchantid = 'A1X6FK5RDHNB96'
648 0.0003 0.00026893615722656 
SELECT * FROM productoffers
                WHERE product_id = '3214' AND price > 0
                ORDER BY price ASC LIMIT 1
649 0.0003 0.00031495094299316 
SELECT * FROM productoffers
                WHERE product_id = 3214
                ORDER BY price ASC LIMIT 1
650 0.0003 0.0003211498260498 
SELECT value FROM productattributes
                WHERE product_id = '3214'
                AND name = 'ListPriceAmount'
651 0.0003 0.00029206275939941 
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 = '3214'
                GROUP BY o.product_id
652 0.0004 0.00041699409484863 
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     = '3214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
653 0.0003 0.00031208992004395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3214
654 0.0004 0.00040507316589355 
SELECT value FROM productattributes WHERE product_id = '3214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
655 0.0004 0.0004270076751709 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3214'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
656 0.0003 0.00034999847412109 
SELECT * FROM products WHERE parent_id = '3214'
657 0.0003 0.00034999847412109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4803' AND a.name = n.originalname
658 0.0003 0.00033783912658691 
SELECT * FROM productoffers WHERE product_id = '4803' AND merchantid = 'A1X6FK5RDHNB96'
659 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '4803' AND price > 0
                ORDER BY price ASC LIMIT 1
660 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = 4803
                ORDER BY price ASC LIMIT 1
661 0.0003 0.00026798248291016 
SELECT value FROM productattributes
                WHERE product_id = '4803'
                AND name = 'ListPriceAmount'
662 0.0004 0.00040602684020996 
SELECT * FROM productimages WHERE product_id = '1090' ORDER BY sortorder ASC
663 0.0005 0.00047111511230469 
SELECT * FROM product_image_select WHERE product_id = '1090'
664 0.0003 0.00030303001403809 
SELECT * FROM productcustomimages WHERE product_id = '1090'
665 0.0007 0.0006711483001709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1090' AND a.name = n.originalname
666 0.0003 0.00034809112548828 
SELECT * FROM productoffers WHERE product_id = '1090' AND merchantid = 'A1X6FK5RDHNB96'
667 0.0003 0.00028705596923828 
SELECT * FROM productoffers
                WHERE product_id = '1090' AND price > 0
                ORDER BY price ASC LIMIT 1
668 0.0003 0.00025701522827148 
SELECT * FROM productoffers
                WHERE product_id = 1090
                ORDER BY price ASC LIMIT 1
669 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '1090'
                AND name = 'ListPriceAmount'
670 0.0003 0.00029492378234863 
SELECT value FROM productattributes WHERE product_id = '1090' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
671 0.0004 0.0003669261932373 
SELECT * FROM productimages WHERE product_id = '1479' ORDER BY sortorder ASC
672 0.0005 0.00048303604125977 
SELECT * FROM product_image_select WHERE product_id = '1479'
673 0.0003 0.00030207633972168 
SELECT * FROM productcustomimages WHERE product_id = '1479'
674 0.0007 0.00073909759521484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1479' AND a.name = n.originalname
675 0.0003 0.00033187866210938 
SELECT * FROM productoffers WHERE product_id = '1479' AND merchantid = 'A1X6FK5RDHNB96'
676 0.0003 0.00028514862060547 
SELECT * FROM productoffers
                WHERE product_id = '1479' AND price > 0
                ORDER BY price ASC LIMIT 1
677 0.0003 0.00025701522827148 
SELECT * FROM productoffers
                WHERE product_id = 1479
                ORDER BY price ASC LIMIT 1
678 0.0003 0.00025582313537598 
SELECT value FROM productattributes
                WHERE product_id = '1479'
                AND name = 'ListPriceAmount'
679 0.0003 0.00029492378234863 
SELECT value FROM productattributes WHERE product_id = '1479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
680 0.0003 0.00033402442932129 
SELECT * FROM productimages WHERE product_id = '1118' ORDER BY sortorder ASC
681 0.0006 0.00060200691223145 
SELECT * FROM product_image_select WHERE product_id = '1118'
682 0.0003 0.00029110908508301 
SELECT * FROM productcustomimages WHERE product_id = '1118'
683 0.0005 0.00050711631774902 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1118' AND a.name = n.originalname
684 0.0003 0.00031185150146484 
SELECT * FROM productoffers WHERE product_id = '1118' AND merchantid = 'A1X6FK5RDHNB96'
685 0.0003 0.00026106834411621 
SELECT * FROM productoffers
                WHERE product_id = '1118' AND price > 0
                ORDER BY price ASC LIMIT 1
686 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = 1118
                ORDER BY price ASC LIMIT 1
687 0.0003 0.00026297569274902 
SELECT value FROM productattributes
                WHERE product_id = '1118'
                AND name = 'ListPriceAmount'
688 0.0003 0.00027298927307129 
SELECT value FROM productattributes WHERE product_id = '1118' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.0003 0.00032687187194824 
SELECT * FROM productimages WHERE product_id = '1068' ORDER BY sortorder ASC
690 0.0005 0.00047898292541504 
SELECT * FROM product_image_select WHERE product_id = '1068'
691 0.0003 0.00028300285339355 
SELECT * FROM productcustomimages WHERE product_id = '1068'
692 0.0006 0.00058603286743164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1068' AND a.name = n.originalname
693 0.0003 0.00034594535827637 
SELECT * FROM productoffers WHERE product_id = '1068' AND merchantid = 'A1X6FK5RDHNB96'
694 0.0003 0.00027990341186523 
SELECT * FROM productoffers
                WHERE product_id = '1068' AND price > 0
                ORDER BY price ASC LIMIT 1
695 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = 1068
                ORDER BY price ASC LIMIT 1
696 0.0003 0.00026702880859375 
SELECT value FROM productattributes
                WHERE product_id = '1068'
                AND name = 'ListPriceAmount'
697 0.0003 0.00029420852661133 
SELECT value FROM productattributes WHERE product_id = '1068' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
698 0.0004 0.00035905838012695 
SELECT * FROM productimages WHERE product_id = '1044' ORDER BY sortorder ASC
699 0.0005 0.00046610832214355 
SELECT * FROM product_image_select WHERE product_id = '1044'
700 0.0003 0.00029301643371582 
SELECT * FROM productcustomimages WHERE product_id = '1044'
701 0.0007 0.00069499015808105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1044' AND a.name = n.originalname
702 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '1044' AND merchantid = 'A1X6FK5RDHNB96'
703 0.0003 0.00028109550476074 
SELECT * FROM productoffers
                WHERE product_id = '1044' AND price > 0
                ORDER BY price ASC LIMIT 1
704 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '1044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
705 0.0003 0.00032401084899902 
SELECT * FROM productimages WHERE product_id = '1150' ORDER BY sortorder ASC
706 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '1150'
707 0.0003 0.0003049373626709 
SELECT * FROM productcustomimages WHERE product_id = '1150'
708 0.0006 0.00056314468383789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1150' AND a.name = n.originalname
709 0.0003 0.0003359317779541 
SELECT * FROM productoffers WHERE product_id = '1150' AND merchantid = 'A1X6FK5RDHNB96'
710 0.0003 0.00025796890258789 
SELECT * FROM productoffers
                WHERE product_id = '1150' AND price > 0
                ORDER BY price ASC LIMIT 1
711 0.0002 0.00023508071899414 
SELECT * FROM productoffers
                WHERE product_id = 1150
                ORDER BY price ASC LIMIT 1
712 0.0003 0.00026082992553711 
SELECT value FROM productattributes
                WHERE product_id = '1150'
                AND name = 'ListPriceAmount'
713 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '1150' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
714 0.0003 0.00031399726867676 
SELECT * FROM productimages WHERE product_id = '1211' ORDER BY sortorder ASC
715 0.0004 0.00044703483581543 
SELECT * FROM product_image_select WHERE product_id = '1211'
716 0.0003 0.00030088424682617 
SELECT * FROM productcustomimages WHERE product_id = '1211'
717 0.0006 0.00057291984558105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1211' AND a.name = n.originalname
718 0.0003 0.0003359317779541 
SELECT * FROM productoffers WHERE product_id = '1211' AND merchantid = 'A1X6FK5RDHNB96'
719 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '1211' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0003 0.00025796890258789 
SELECT * FROM productoffers
                WHERE product_id = 1211
                ORDER BY price ASC LIMIT 1
721 0.0003 0.0002598762512207 
SELECT value FROM productattributes
                WHERE product_id = '1211'
                AND name = 'ListPriceAmount'
722 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '1211' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
723 0.0003 0.00032186508178711 
SELECT * FROM productimages WHERE product_id = '874' ORDER BY sortorder ASC
724 0.0005 0.00045394897460938 
SELECT * FROM product_image_select WHERE product_id = '874'
725 0.0003 0.0002751350402832 
SELECT * FROM productcustomimages WHERE product_id = '874'
726 0.0007 0.00068402290344238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '874' AND a.name = n.originalname
727 0.0003 0.00031113624572754 
SELECT * FROM productoffers WHERE product_id = '874' AND merchantid = 'A1X6FK5RDHNB96'
728 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '874' AND price > 0
                ORDER BY price ASC LIMIT 1
729 0.0002 0.00024104118347168 
SELECT * FROM productoffers
                WHERE product_id = 874
                ORDER BY price ASC LIMIT 1
730 0.0003 0.0002739429473877 
SELECT value FROM productattributes
                WHERE product_id = '874'
                AND name = 'ListPriceAmount'
731 0.0004 0.00036311149597168 
SELECT * FROM productimages WHERE product_id = '1126' ORDER BY sortorder ASC
732 0.0005 0.00047183036804199 
SELECT * FROM product_image_select WHERE product_id = '1126'
733 0.0003 0.00028705596923828 
SELECT * FROM productcustomimages WHERE product_id = '1126'
734 0.0005 0.00048995018005371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname
735 0.0003 0.0003211498260498 
SELECT * FROM productoffers WHERE product_id = '1126' AND merchantid = 'A1X6FK5RDHNB96'
736 0.0003 0.00025415420532227 
SELECT * FROM productoffers
                WHERE product_id = '1126' AND price > 0
                ORDER BY price ASC LIMIT 1
737 0.0002 0.00023794174194336 
SELECT * FROM productoffers
                WHERE product_id = 1126
                ORDER BY price ASC LIMIT 1
738 0.0003 0.00030398368835449 
SELECT value FROM productattributes
                WHERE product_id = '1126'
                AND name = 'ListPriceAmount'
739 0.0003 0.00034904479980469 
SELECT value FROM productattributes WHERE product_id = '1126' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0003 0.00033211708068848 
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
741 0.0005 0.00048995018005371 
SELECT * FROM product_image_select WHERE product_id = '955'
742 0.0003 0.00028419494628906 
SELECT * FROM productcustomimages WHERE product_id = '955'
743 0.0005 0.00051593780517578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
744 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = 'A1X6FK5RDHNB96'
745 0.0003 0.00029301643371582 
SELECT * FROM productoffers
                WHERE product_id = '955' AND price > 0
                ORDER BY price ASC LIMIT 1
746 0.0002 0.00023913383483887 
SELECT * FROM productoffers
                WHERE product_id = 955
                ORDER BY price ASC LIMIT 1
747 0.0003 0.00028800964355469 
SELECT value FROM productattributes
                WHERE product_id = '955'
                AND name = 'ListPriceAmount'
748 0.0003 0.00028610229492188 
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
749 0.0005 0.00045394897460938 
SELECT * FROM productimages WHERE product_id = '924' ORDER BY sortorder ASC
750 0.0004 0.00044083595275879 
SELECT * FROM product_image_select WHERE product_id = '924'
751 0.0003 0.00029397010803223 
SELECT * FROM productcustomimages WHERE product_id = '924'
752 0.0006 0.00060701370239258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '924' AND a.name = n.originalname
753 0.0003 0.00034189224243164 
SELECT * FROM productoffers WHERE product_id = '924' AND merchantid = 'A1X6FK5RDHNB96'
754 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = '924' AND price > 0
                ORDER BY price ASC LIMIT 1
755 0.0003 0.00028109550476074 
SELECT value FROM productattributes WHERE product_id = '924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
756 0.0003 0.00032591819763184 
SELECT * FROM productimages WHERE product_id = '1684' ORDER BY sortorder ASC
757 0.0005 0.00045299530029297 
SELECT * FROM product_image_select WHERE product_id = '1684'
758 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '1684'
759 0.0005 0.00050997734069824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1684' AND a.name = n.originalname
760 0.0003 0.00032615661621094 
SELECT * FROM productoffers WHERE product_id = '1684' AND merchantid = 'A1X6FK5RDHNB96'
761 0.0003 0.00029516220092773 
SELECT * FROM productoffers
                WHERE product_id = '1684' AND price > 0
                ORDER BY price ASC LIMIT 1
762 0.0003 0.00028705596923828 
SELECT value FROM productattributes WHERE product_id = '1684' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
763 0.0004 0.00035595893859863 
SELECT * FROM productimages WHERE product_id = '1082' ORDER BY sortorder ASC
764 0.0005 0.00054502487182617 
SELECT * FROM product_image_select WHERE product_id = '1082'
765 0.0003 0.00028586387634277 
SELECT * FROM productcustomimages WHERE product_id = '1082'
766 0.0006 0.00057601928710938 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname
767 0.0004 0.00035595893859863 
SELECT * FROM productoffers WHERE product_id = '1082' AND merchantid = 'A1X6FK5RDHNB96'
768 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '1082' AND price > 0
                ORDER BY price ASC LIMIT 1
769 0.0003 0.00028204917907715 
SELECT * FROM productoffers
                WHERE product_id = 1082
                ORDER BY price ASC LIMIT 1
770 0.0003 0.00028491020202637 
SELECT value FROM productattributes
                WHERE product_id = '1082'
                AND name = 'ListPriceAmount'
771 0.0003 0.00028610229492188 
SELECT value FROM productattributes WHERE product_id = '1082' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0003 0.0003199577331543 
SELECT * FROM productimages WHERE product_id = '945' ORDER BY sortorder ASC
773 0.0005 0.00047111511230469 
SELECT * FROM product_image_select WHERE product_id = '945'
774 0.0003 0.0002899169921875 
SELECT * FROM productcustomimages WHERE product_id = '945'
775 0.0005 0.00050497055053711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '945' AND a.name = n.originalname
776 0.0004 0.00038599967956543 
SELECT * FROM productoffers WHERE product_id = '945' AND merchantid = 'A1X6FK5RDHNB96'
777 0.0004 0.00035500526428223 
SELECT * FROM productoffers
                WHERE product_id = '945' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0003 0.00028800964355469 
SELECT * FROM productoffers
                WHERE product_id = 945
                ORDER BY price ASC LIMIT 1
779 0.0003 0.0002899169921875 
SELECT value FROM productattributes
                WHERE product_id = '945'
                AND name = 'ListPriceAmount'
780 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
781 0.0003 0.00033402442932129 
SELECT * FROM productimages WHERE product_id = '1091' ORDER BY sortorder ASC
782 0.0005 0.00049901008605957 
SELECT * FROM product_image_select WHERE product_id = '1091'
783 0.0003 0.00028705596923828 
SELECT * FROM productcustomimages WHERE product_id = '1091'
784 0.0005 0.00050902366638184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1091' AND a.name = n.originalname
785 0.0003 0.00032687187194824 
SELECT * FROM productoffers WHERE product_id = '1091' AND merchantid = 'A1X6FK5RDHNB96'
786 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '1091' AND price > 0
                ORDER BY price ASC LIMIT 1
787 0.0002 0.00023388862609863 
SELECT * FROM productoffers
                WHERE product_id = 1091
                ORDER BY price ASC LIMIT 1
788 0.0003 0.00025606155395508 
SELECT value FROM productattributes
                WHERE product_id = '1091'
                AND name = 'ListPriceAmount'
789 0.0003 0.00027680397033691 
SELECT value FROM productattributes WHERE product_id = '1091' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
790 0.0003 0.00030803680419922 
SELECT * FROM productimages WHERE product_id = '1683' ORDER BY sortorder ASC
791 0.0005 0.00046992301940918 
SELECT * FROM product_image_select WHERE product_id = '1683'
792 0.0003 0.00031113624572754 
SELECT * FROM productcustomimages WHERE product_id = '1683'
793 0.0005 0.00051593780517578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1683' AND a.name = n.originalname
794 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '1683' AND merchantid = 'A1X6FK5RDHNB96'
795 0.0004 0.0003509521484375 
SELECT * FROM productoffers
                WHERE product_id = '1683' AND price > 0
                ORDER BY price ASC LIMIT 1
796 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '1683' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
797 0.0003 0.00034499168395996 
SELECT * FROM productimages WHERE product_id = '859' ORDER BY sortorder ASC
798 0.0005 0.00045108795166016 
SELECT * FROM product_image_select WHERE product_id = '859'
799 0.0003 0.00027704238891602 
SELECT * FROM productcustomimages WHERE product_id = '859'
800 0.0007 0.00066995620727539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '859' AND a.name = n.originalname
801 0.0004 0.00038504600524902 
SELECT * FROM productoffers WHERE product_id = '859' AND merchantid = 'A1X6FK5RDHNB96'
802 0.0003 0.00026082992553711 
SELECT * FROM productoffers
                WHERE product_id = '859' AND price > 0
                ORDER BY price ASC LIMIT 1
803 0.0002 0.00023603439331055 
SELECT * FROM productoffers
                WHERE product_id = 859
                ORDER BY price ASC LIMIT 1
804 0.0002 0.00024795532226562 
SELECT value FROM productattributes
                WHERE product_id = '859'
                AND name = 'ListPriceAmount'
805 0.0003 0.00031495094299316 
SELECT value FROM productattributes WHERE product_id = '859' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
806 0.0003 0.00034189224243164 
SELECT * FROM productimages WHERE product_id = '1292' ORDER BY sortorder ASC
807 0.0005 0.00047683715820312 
SELECT * FROM product_image_select WHERE product_id = '1292'
808 0.0004 0.00035214424133301 
SELECT * FROM productcustomimages WHERE product_id = '1292'
809 0.0007 0.00065994262695312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1292' AND a.name = n.originalname
810 0.0004 0.00043916702270508 
SELECT * FROM productoffers WHERE product_id = '1292' AND merchantid = 'A1X6FK5RDHNB96'
811 0.0003 0.00026082992553711 
SELECT * FROM productoffers
                WHERE product_id = '1292' AND price > 0
                ORDER BY price ASC LIMIT 1
812 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = 1292
                ORDER BY price ASC LIMIT 1
813 0.0003 0.00025486946105957 
SELECT value FROM productattributes
                WHERE product_id = '1292'
                AND name = 'ListPriceAmount'
814 0.0003 0.00028705596923828 
SELECT value FROM productattributes WHERE product_id = '1292' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
815 0.0004 0.00035285949707031 
SELECT * FROM productimages WHERE product_id = '1020' ORDER BY sortorder ASC
816 0.0005 0.00046086311340332 
SELECT * FROM product_image_select WHERE product_id = '1020'
817 0.0003 0.00029516220092773 
SELECT * FROM productcustomimages WHERE product_id = '1020'
818 0.0006 0.00060796737670898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1020' AND a.name = n.originalname
819 0.0004 0.00038385391235352 
SELECT * FROM productoffers WHERE product_id = '1020' AND merchantid = 'A1X6FK5RDHNB96'
820 0.0003 0.00028300285339355 
SELECT * FROM productoffers
                WHERE product_id = '1020' AND price > 0
                ORDER BY price ASC LIMIT 1
821 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = 1020
                ORDER BY price ASC LIMIT 1
822 0.0003 0.00026202201843262 
SELECT value FROM productattributes
                WHERE product_id = '1020'
                AND name = 'ListPriceAmount'
823 0.0003 0.00030803680419922 
SELECT value FROM productattributes WHERE product_id = '1020' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
824 0.0003 0.0003199577331543 
SELECT * FROM productimages WHERE product_id = '1685' ORDER BY sortorder ASC
825 0.0005 0.00053596496582031 
SELECT * FROM product_image_select WHERE product_id = '1685'
826 0.0003 0.00030112266540527 
SELECT * FROM productcustomimages WHERE product_id = '1685'
827 0.0006 0.00055694580078125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1685' AND a.name = n.originalname
828 0.0003 0.00034785270690918 
SELECT * FROM productoffers WHERE product_id = '1685' AND merchantid = 'A1X6FK5RDHNB96'
829 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = '1685' AND price > 0
                ORDER BY price ASC LIMIT 1
830 0.0003 0.00028800964355469 
SELECT value FROM productattributes WHERE product_id = '1685' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
831 0.0003 0.00034308433532715 
SELECT * FROM productimages WHERE product_id = '1266' ORDER BY sortorder ASC
832 0.0005 0.00045418739318848 
SELECT * FROM product_image_select WHERE product_id = '1266'
833 0.0003 0.00031590461730957 
SELECT * FROM productcustomimages WHERE product_id = '1266'
834 0.0006 0.00064182281494141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1266' AND a.name = n.originalname
835 0.0003 0.00033688545227051 
SELECT * FROM productoffers WHERE product_id = '1266' AND merchantid = 'A1X6FK5RDHNB96'
836 0.0003 0.00027084350585938 
SELECT * FROM productoffers
                WHERE product_id = '1266' AND price > 0
                ORDER BY price ASC LIMIT 1
837 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = 1266
                ORDER BY price ASC LIMIT 1
838 0.0002 0.000244140625 
SELECT value FROM productattributes
                WHERE product_id = '1266'
                AND name = 'ListPriceAmount'
839 0.0003 0.00030398368835449 
SELECT value FROM productattributes WHERE product_id = '1266' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
840 0.0004 0.00036311149597168 
SELECT * FROM productimages WHERE product_id = '1101' ORDER BY sortorder ASC
841 0.0004 0.00043797492980957 
SELECT * FROM product_image_select WHERE product_id = '1101'
842 0.0003 0.00027203559875488 
SELECT * FROM productcustomimages WHERE product_id = '1101'
843 0.0005 0.00049901008605957 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname
844 0.0004 0.00036716461181641 
SELECT * FROM productoffers WHERE product_id = '1101' AND merchantid = 'A1X6FK5RDHNB96'
845 0.0002 0.00024914741516113 
SELECT * FROM productoffers
                WHERE product_id = '1101' AND price > 0
                ORDER BY price ASC LIMIT 1
846 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = 1101
                ORDER BY price ASC LIMIT 1
847 0.0003 0.00030517578125 
SELECT value FROM productattributes
                WHERE product_id = '1101'
                AND name = 'ListPriceAmount'
848 0.0003 0.00028109550476074 
SELECT value FROM productattributes WHERE product_id = '1101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
849 0.0004 0.00039005279541016 
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
850 0.0004 0.00044608116149902 
SELECT * FROM product_image_select WHERE product_id = '1061'
851 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '1061'
852 0.0007 0.00067496299743652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
853 0.0003 0.00034594535827637 
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
854 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
855 0.0003 0.00029706954956055 
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
856 0.0004 0.00040721893310547 
SELECT * FROM productimages WHERE product_id = '1100' ORDER BY sortorder ASC
857 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '1100'
858 0.0003 0.00026297569274902 
SELECT * FROM productcustomimages WHERE product_id = '1100'
859 0.0006 0.00063085556030273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1100' AND a.name = n.originalname
860 0.0003 0.00030803680419922 
SELECT * FROM productoffers WHERE product_id = '1100' AND merchantid = 'A1X6FK5RDHNB96'
861 0.0003 0.00027585029602051 
SELECT * FROM productoffers
                WHERE product_id = '1100' AND price > 0
                ORDER BY price ASC LIMIT 1
862 0.0003 0.00028586387634277 
SELECT value FROM productattributes WHERE product_id = '1100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
863 0.0003 0.00031781196594238 
SELECT * FROM productimages WHERE product_id = '1395' ORDER BY sortorder ASC
864 0.0004 0.00043296813964844 
SELECT * FROM product_image_select WHERE product_id = '1395'
865 0.0003 0.00027704238891602 
SELECT * FROM productcustomimages WHERE product_id = '1395'
866 0.0007 0.00072288513183594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1395' AND a.name = n.originalname
867 0.0003 0.00033688545227051 
SELECT * FROM productoffers WHERE product_id = '1395' AND merchantid = 'A1X6FK5RDHNB96'
868 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = '1395' AND price > 0
                ORDER BY price ASC LIMIT 1
869 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = 1395
                ORDER BY price ASC LIMIT 1
870 0.0003 0.00027084350585938 
SELECT value FROM productattributes
                WHERE product_id = '1395'
                AND name = 'ListPriceAmount'
871 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '1395' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
872 0.0003 0.00034403800964355 
SELECT * FROM productimages WHERE product_id = '1067' ORDER BY sortorder ASC
873 0.0005 0.00049018859863281 
SELECT * FROM product_image_select WHERE product_id = '1067'
874 0.0003 0.00028610229492188 
SELECT * FROM productcustomimages WHERE product_id = '1067'
875 0.0008 0.00081706047058105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1067' AND a.name = n.originalname
876 0.0004 0.00040388107299805 
SELECT * FROM productoffers WHERE product_id = '1067' AND merchantid = 'A1X6FK5RDHNB96'
877 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '1067' AND price > 0
                ORDER BY price ASC LIMIT 1
878 0.0003 0.00027894973754883 
SELECT * FROM productoffers
                WHERE product_id = 1067
                ORDER BY price ASC LIMIT 1
879 0.0003 0.00026583671569824 
SELECT value FROM productattributes
                WHERE product_id = '1067'
                AND name = 'ListPriceAmount'
880 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '1067' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
881 0.0003 0.00034093856811523 
SELECT * FROM productimages WHERE product_id = '1065' ORDER BY sortorder ASC
882 0.0005 0.00054097175598145 
SELECT * FROM product_image_select WHERE product_id = '1065'
883 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '1065'
884 0.0007 0.00070595741271973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1065' AND a.name = n.originalname
885 0.0003 0.0003361701965332 
SELECT * FROM productoffers WHERE product_id = '1065' AND merchantid = 'A1X6FK5RDHNB96'
886 0.0003 0.00030899047851562 
SELECT * FROM productoffers
                WHERE product_id = '1065' AND price > 0
                ORDER BY price ASC LIMIT 1
887 0.0003 0.00033211708068848 
SELECT * FROM productoffers
                WHERE product_id = 1065
                ORDER BY price ASC LIMIT 1
888 0.0003 0.00026297569274902 
SELECT value FROM productattributes
                WHERE product_id = '1065'
                AND name = 'ListPriceAmount'
889 0.0003 0.00028800964355469 
SELECT value FROM productattributes WHERE product_id = '1065' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
890 0.0004 0.00041913986206055 
SELECT * FROM productimages WHERE product_id = '1166' ORDER BY sortorder ASC
891 0.0005 0.00048279762268066 
SELECT * FROM product_image_select WHERE product_id = '1166'
892 0.0003 0.00028109550476074 
SELECT * FROM productcustomimages WHERE product_id = '1166'
893 0.0008 0.00081586837768555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1166' AND a.name = n.originalname
894 0.0003 0.00033307075500488 
SELECT * FROM productoffers WHERE product_id = '1166' AND merchantid = 'A1X6FK5RDHNB96'
895 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = '1166' AND price > 0
                ORDER BY price ASC LIMIT 1
896 0.0003 0.00025081634521484 
SELECT * FROM productoffers
                WHERE product_id = 1166
                ORDER BY price ASC LIMIT 1
897 0.0003 0.00027799606323242 
SELECT value FROM productattributes
                WHERE product_id = '1166'
                AND name = 'ListPriceAmount'
898 0.0003 0.00027704238891602 
SELECT value FROM productattributes WHERE product_id = '1166' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
899 0.0003 0.00033903121948242 
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
900 0.0005 0.00048613548278809 
SELECT * FROM product_image_select WHERE product_id = '1339'
901 0.0003 0.00030803680419922 
SELECT * FROM productcustomimages WHERE product_id = '1339'
902 0.0006 0.00063681602478027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
903 0.0004 0.00035881996154785 
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
904 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
905 0.0002 0.00024700164794922 
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
906 0.0003 0.00028395652770996 
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
907 0.0003 0.00029706954956055 
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
908 0.0004 0.00042009353637695 
SELECT * FROM productimages WHERE product_id = '1239' ORDER BY sortorder ASC
909 0.0005 0.00046205520629883 
SELECT * FROM product_image_select WHERE product_id = '1239'
910 0.0003 0.00028800964355469 
SELECT * FROM productcustomimages WHERE product_id = '1239'
911 0.0006 0.00061392784118652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1239' AND a.name = n.originalname
912 0.0003 0.00032901763916016 
SELECT * FROM productoffers WHERE product_id = '1239' AND merchantid = 'A1X6FK5RDHNB96'
913 0.0003 0.0002598762512207 
SELECT * FROM productoffers
                WHERE product_id = '1239' AND price > 0
                ORDER BY price ASC LIMIT 1
914 0.0002 0.00024604797363281 
SELECT * FROM productoffers
                WHERE product_id = 1239
                ORDER BY price ASC LIMIT 1
915 0.0003 0.00026488304138184 
SELECT value FROM productattributes
                WHERE product_id = '1239'
                AND name = 'ListPriceAmount'
916 0.0003 0.00026702880859375 
SELECT value FROM productattributes WHERE product_id = '1239' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
917 0.0005 0.00048089027404785 
SELECT * FROM productimages WHERE product_id = '3764' ORDER BY sortorder ASC
918 0.0006 0.0005648136138916 
SELECT * FROM product_image_select WHERE product_id = '3764'
919 0.0003 0.00030708312988281 
SELECT * FROM productcustomimages WHERE product_id = '3764'
920 0.0007 0.00067591667175293 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname
921 0.0004 0.00036501884460449 
SELECT * FROM productoffers WHERE product_id = '3764' AND merchantid = 'A1X6FK5RDHNB96'
922 0.0003 0.00028681755065918 
SELECT * FROM productoffers
                WHERE product_id = '3764' AND price > 0
                ORDER BY price ASC LIMIT 1
923 0.0002 0.00024700164794922 
SELECT * FROM productoffers
                WHERE product_id = 3764
                ORDER BY price ASC LIMIT 1
924 0.0003 0.00027298927307129 
SELECT value FROM productattributes
                WHERE product_id = '3764'
                AND name = 'ListPriceAmount'
925 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '3764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
926 0.0004 0.00040912628173828 
SELECT * FROM productimages WHERE product_id = '1152' ORDER BY sortorder ASC
927 0.0005 0.00049400329589844 
SELECT * FROM product_image_select WHERE product_id = '1152'
928 0.0003 0.00030803680419922 
SELECT * FROM productcustomimages WHERE product_id = '1152'
929 0.0006 0.00063085556030273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1152' AND a.name = n.originalname
930 0.0003 0.0003209114074707 
SELECT * FROM productoffers WHERE product_id = '1152' AND merchantid = 'A1X6FK5RDHNB96'
931 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '1152' AND price > 0
                ORDER BY price ASC LIMIT 1
932 0.0003 0.00027179718017578 
SELECT * FROM productoffers
                WHERE product_id = 1152
                ORDER BY price ASC LIMIT 1
933 0.0003 0.00031495094299316 
SELECT value FROM productattributes
                WHERE product_id = '1152'
                AND name = 'ListPriceAmount'
934 0.0003 0.00029802322387695 
SELECT value FROM productattributes WHERE product_id = '1152' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
935 0.0004 0.00039505958557129 
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
936 0.0004 0.00044989585876465 
SELECT * FROM product_image_select WHERE product_id = '1160'
937 0.0003 0.00031185150146484 
SELECT * FROM productcustomimages WHERE product_id = '1160'
938 0.0007 0.0006709098815918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
939 0.0003 0.00032305717468262 
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
940 0.0003 0.00029492378234863 
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
941 0.0003 0.00028586387634277 
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
942 0.0003 0.00034499168395996 
SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
943 0.0005 0.00046396255493164 
SELECT * FROM product_image_select WHERE product_id = '875'
944 0.0003 0.00028014183044434 
SELECT * FROM productcustomimages WHERE product_id = '875'
945 0.0006 0.00055098533630371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
946 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
947 0.0003 0.00029897689819336 
SELECT * FROM productoffers
                WHERE product_id = '875' AND price > 0
                ORDER BY price ASC LIMIT 1
948 0.0003 0.00025796890258789 
SELECT * FROM productoffers
                WHERE product_id = 875
                ORDER BY price ASC LIMIT 1
949 0.0003 0.00028610229492188 
SELECT value FROM productattributes
                WHERE product_id = '875'
                AND name = 'ListPriceAmount'
950 0.0003 0.00029611587524414 
SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
951 0.0004 0.00039815902709961 
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
952 0.0005 0.00048089027404785 
SELECT * FROM product_image_select WHERE product_id = '1217'
953 0.0003 0.00030303001403809 
SELECT * FROM productcustomimages WHERE product_id = '1217'
954 0.0007 0.0006859302520752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
955 0.0003 0.00033998489379883 
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
956 0.0003 0.00029587745666504 
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
957 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
958 0.0004 0.00037789344787598 
SELECT * FROM productimages WHERE product_id = '958' ORDER BY sortorder ASC
959 0.0005 0.00049495697021484 
SELECT * FROM product_image_select WHERE product_id = '958'
960 0.0003 0.00028085708618164 
SELECT * FROM productcustomimages WHERE product_id = '958'
961 0.0005 0.00050902366638184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '958' AND a.name = n.originalname
962 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '958' AND merchantid = 'A1X6FK5RDHNB96'
963 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '958' AND price > 0
                ORDER BY price ASC LIMIT 1
964 0.0002 0.0002448558807373 
SELECT * FROM productoffers
                WHERE product_id = 958
                ORDER BY price ASC LIMIT 1
965 0.0003 0.0002751350402832 
SELECT value FROM productattributes
                WHERE product_id = '958'
                AND name = 'ListPriceAmount'
966 0.0003 0.00026893615722656 
SELECT value FROM productattributes WHERE product_id = '958' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
967 0.0003 0.00032401084899902 
SELECT * FROM productimages WHERE product_id = '1138' ORDER BY sortorder ASC
968 0.0004 0.00044798851013184 
SELECT * FROM product_image_select WHERE product_id = '1138'
969 0.0003 0.0002741813659668 
SELECT * FROM productcustomimages WHERE product_id = '1138'
970 0.0006 0.00055503845214844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1138' AND a.name = n.originalname
971 0.0003 0.00033903121948242 
SELECT * FROM productoffers WHERE product_id = '1138' AND merchantid = 'A1X6FK5RDHNB96'
972 0.0003 0.00030708312988281 
SELECT * FROM productoffers
                WHERE product_id = '1138' AND price > 0
                ORDER BY price ASC LIMIT 1
973 0.0002 0.000244140625 
SELECT * FROM productoffers
                WHERE product_id = 1138
                ORDER BY price ASC LIMIT 1
974 0.0003 0.00026988983154297 
SELECT value FROM productattributes
                WHERE product_id = '1138'
                AND name = 'ListPriceAmount'
975 0.0003 0.00028896331787109 
SELECT value FROM productattributes WHERE product_id = '1138' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
976 0.0003 0.00034785270690918 
SELECT * FROM productimages WHERE product_id = '1260' ORDER BY sortorder ASC
977 0.0005 0.00046515464782715 
SELECT * FROM product_image_select WHERE product_id = '1260'
978 0.0003 0.00028896331787109 
SELECT * FROM productcustomimages WHERE product_id = '1260'
979 0.0005 0.00050520896911621 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1260' AND a.name = n.originalname
980 0.0004 0.00035691261291504 
SELECT * FROM productoffers WHERE product_id = '1260' AND merchantid = 'A1X6FK5RDHNB96'
981 0.0003 0.00028109550476074 
SELECT * FROM productoffers
                WHERE product_id = '1260' AND price > 0
                ORDER BY price ASC LIMIT 1
982 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = 1260
                ORDER BY price ASC LIMIT 1
983 0.0003 0.00027298927307129 
SELECT value FROM productattributes
                WHERE product_id = '1260'
                AND name = 'ListPriceAmount'
984 0.0003 0.00028610229492188 
SELECT value FROM productattributes WHERE product_id = '1260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
985 0.0004 0.00040984153747559 
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
986 0.0005 0.00047397613525391 
SELECT * FROM product_image_select WHERE product_id = '970'
987 0.0003 0.00028395652770996 
SELECT * FROM productcustomimages WHERE product_id = '970'
988 0.0006 0.00058794021606445 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
989 0.0004 0.00036215782165527 
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
990 0.0003 0.00032687187194824 
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
991 0.0003 0.0002899169921875 
SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
992 0.0004 0.00040411949157715 
SELECT * FROM productimages WHERE product_id = '908' ORDER BY sortorder ASC
993 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '908'
994 0.0003 0.00029802322387695 
SELECT * FROM productcustomimages WHERE product_id = '908'
995 0.0005 0.00051593780517578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '908' AND a.name = n.originalname
996 0.0003 0.00032496452331543 
SELECT * FROM productoffers WHERE product_id = '908' AND merchantid = 'A1X6FK5RDHNB96'
997 0.0003 0.00026392936706543 
SELECT * FROM productoffers
                WHERE product_id = '908' AND price > 0
                ORDER BY price ASC LIMIT 1
998 0.0002 0.00024795532226562 
SELECT * FROM productoffers
                WHERE product_id = 908
                ORDER BY price ASC LIMIT 1
999 0.0003 0.00025486946105957 
SELECT value FROM productattributes
                WHERE product_id = '908'
                AND name = 'ListPriceAmount'
1000 0.0003 0.00029516220092773 
SELECT value FROM productattributes WHERE product_id = '908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1001 0.0003 0.00034999847412109 
SELECT * FROM productimages WHERE product_id = '893' ORDER BY sortorder ASC
1002 0.0005 0.0005030632019043 
SELECT * FROM product_image_select WHERE product_id = '893'
1003 0.0003 0.0003209114074707 
SELECT * FROM productcustomimages WHERE product_id = '893'
1004 0.0005 0.00054097175598145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '893' AND a.name = n.originalname
1005 0.0003 0.00032186508178711 
SELECT * FROM productoffers WHERE product_id = '893' AND merchantid = 'A1X6FK5RDHNB96'
1006 0.0003 0.00034093856811523 
SELECT * FROM productoffers
                WHERE product_id = '893' AND price > 0
                ORDER BY price ASC LIMIT 1
1007 0.0003 0.00025486946105957 
SELECT * FROM productoffers
                WHERE product_id = 893
                ORDER BY price ASC LIMIT 1
1008 0.0003 0.00026488304138184 
SELECT value FROM productattributes
                WHERE product_id = '893'
                AND name = 'ListPriceAmount'
1009 0.0003 0.00030088424682617 
SELECT value FROM productattributes WHERE product_id = '893' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1010 0.0004 0.0004429817199707 
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
1011 0.0005 0.00051283836364746 
SELECT * FROM product_image_select WHERE product_id = '1110'
1012 0.0004 0.00039887428283691 
SELECT * FROM productcustomimages WHERE product_id = '1110'
1013 0.0006 0.00063490867614746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
1014 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
1015 0.0003 0.00029301643371582 
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
1016 0.0003 0.00027799606323242 
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1017 0.0003 0.00031900405883789 
SELECT * FROM productimages WHERE product_id = '4908' ORDER BY sortorder ASC
1018 0.0005 0.00047612190246582 
SELECT * FROM product_image_select WHERE product_id = '4908'
1019 0.0003 0.00029397010803223 
SELECT * FROM productcustomimages WHERE product_id = '4908'
1020 0.0006 0.00062108039855957 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4908' AND a.name = n.originalname
1021 0.0003 0.00032305717468262 
SELECT * FROM productoffers WHERE product_id = '4908' AND merchantid = 'A1X6FK5RDHNB96'
1022 0.0003 0.00026988983154297 
SELECT * FROM productoffers
                WHERE product_id = '4908' AND price > 0
                ORDER BY price ASC LIMIT 1
1023 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = 4908
                ORDER BY price ASC LIMIT 1
1024 0.0003 0.00030183792114258 
SELECT value FROM productattributes
                WHERE product_id = '4908'
                AND name = 'ListPriceAmount'
1025 0.0003 0.00028085708618164 
SELECT value FROM productattributes WHERE product_id = '4908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1026 0.0003 0.00034403800964355 
SELECT * FROM productimages WHERE product_id = '1145' ORDER BY sortorder ASC
1027 0.0005 0.00047397613525391 
SELECT * FROM product_image_select WHERE product_id = '1145'
1028 0.0003 0.00029611587524414 
SELECT * FROM productcustomimages WHERE product_id = '1145'
1029 0.0007 0.00066900253295898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname
1030 0.0003 0.00033307075500488 
SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96'
1031 0.0003 0.00028586387634277 
SELECT * FROM productoffers
                WHERE product_id = '1145' AND price > 0
                ORDER BY price ASC LIMIT 1
1032 0.0003 0.0002739429473877 
SELECT value FROM productattributes WHERE product_id = '1145' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1033 0.0004 0.00037312507629395 
SELECT * FROM productimages WHERE product_id = '4906' ORDER BY sortorder ASC
1034 0.0005 0.00046992301940918 
SELECT * FROM product_image_select WHERE product_id = '4906'
1035 0.0003 0.00027990341186523 
SELECT * FROM productcustomimages WHERE product_id = '4906'
1036 0.0007 0.00072002410888672 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname
1037 0.0003 0.00031685829162598 
SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96'
1038 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = '4906' AND price > 0
                ORDER BY price ASC LIMIT 1
1039 0.0003 0.00027799606323242 
SELECT value FROM productattributes WHERE product_id = '4906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1040 0.0003 0.00031709671020508 
SELECT * FROM productimages WHERE product_id = '1242' ORDER BY sortorder ASC
1041 0.0004 0.00044608116149902 
SELECT * FROM product_image_select WHERE product_id = '1242'
1042 0.0003 0.00027990341186523 
SELECT * FROM productcustomimages WHERE product_id = '1242'
1043 0.0007 0.00069022178649902 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1242' AND a.name = n.originalname
1044 0.0005 0.00046706199645996 
SELECT * FROM productoffers WHERE product_id = '1242' AND merchantid = 'A1X6FK5RDHNB96'
1045 0.0004 0.00040316581726074 
SELECT * FROM productoffers
                WHERE product_id = '1242' AND price > 0
                ORDER BY price ASC LIMIT 1
1046 0.0003 0.00028586387634277 
SELECT * FROM productoffers
                WHERE product_id = 1242
                ORDER BY price ASC LIMIT 1
1047 0.0004 0.00037598609924316 
SELECT value FROM productattributes
                WHERE product_id = '1242'
                AND name = 'ListPriceAmount'
1048 0.0003 0.00030016899108887 
SELECT value FROM productattributes WHERE product_id = '1242' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1049 0.0005 0.00048089027404785 
SELECT * FROM productimages WHERE product_id = '4757' ORDER BY sortorder ASC
1050 0.0004 0.00044798851013184 
SELECT * FROM product_image_select WHERE product_id = '4757'
1051 0.0003 0.0002899169921875 
SELECT * FROM productcustomimages WHERE product_id = '4757'
1052 0.0007 0.00065183639526367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4757' AND a.name = n.originalname
1053 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '4757' AND merchantid = 'A1X6FK5RDHNB96'
1054 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '4757' AND price > 0
                ORDER BY price ASC LIMIT 1
1055 0.0010 0.00099587440490723 
SELECT * FROM productoffers
                WHERE product_id = 4757
                ORDER BY price ASC LIMIT 1
1056 0.0005 0.00050997734069824 
SELECT value FROM productattributes
                WHERE product_id = '4757'
                AND name = 'ListPriceAmount'
1057 0.0005 0.00051093101501465 
SELECT value FROM productattributes WHERE product_id = '4757' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1058 0.0007 0.00069499015808105 
SELECT * FROM productimages WHERE product_id = '4756' ORDER BY sortorder ASC
1059 0.0010 0.00095415115356445 
SELECT * FROM product_image_select WHERE product_id = '4756'
1060 0.0005 0.00049400329589844 
SELECT * FROM productcustomimages WHERE product_id = '4756'
1061 0.0014 0.0014231204986572 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4756' AND a.name = n.originalname
1062 0.0006 0.00055313110351562 
SELECT * FROM productoffers WHERE product_id = '4756' AND merchantid = 'A1X6FK5RDHNB96'
1063 0.0004 0.00040793418884277 
SELECT * FROM productoffers
                WHERE product_id = '4756' AND price > 0
                ORDER BY price ASC LIMIT 1
1064 0.0004 0.00037002563476562 
SELECT * FROM productoffers
                WHERE product_id = 4756
                ORDER BY price ASC LIMIT 1
1065 0.0005 0.00045919418334961 
SELECT value FROM productattributes
                WHERE product_id = '4756'
                AND name = 'ListPriceAmount'
1066 0.0005 0.00046300888061523 
SELECT value FROM productattributes WHERE product_id = '4756' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1067 0.0006 0.00064516067504883 
SELECT * FROM productimages WHERE product_id = '4767' ORDER BY sortorder ASC
1068 0.0009 0.00091409683227539 
SELECT * FROM product_image_select WHERE product_id = '4767'
1069 0.0005 0.00045895576477051 
SELECT * FROM productcustomimages WHERE product_id = '4767'
1070 0.0015 0.0015251636505127 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4767' AND a.name = n.originalname
1071 0.0005 0.00054192543029785 
SELECT * FROM productoffers WHERE product_id = '4767' AND merchantid = 'A1X6FK5RDHNB96'
1072 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '4767' AND price > 0
                ORDER BY price ASC LIMIT 1
1073 0.0004 0.00043988227844238 
SELECT * FROM productoffers
                WHERE product_id = 4767
                ORDER BY price ASC LIMIT 1
1074 0.0004 0.00042319297790527 
SELECT value FROM productattributes
                WHERE product_id = '4767'
                AND name = 'ListPriceAmount'
1075 0.0005 0.00046086311340332 
SELECT value FROM productattributes WHERE product_id = '4767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1076 0.0007 0.00065302848815918 
SELECT * FROM productimages WHERE product_id = '4766' ORDER BY sortorder ASC
1077 0.0009 0.00094795227050781 
SELECT * FROM product_image_select WHERE product_id = '4766'
1078 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '4766'
1079 0.0014 0.001446008682251 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4766' AND a.name = n.originalname
1080 0.0005 0.00054001808166504 
SELECT * FROM productoffers WHERE product_id = '4766' AND merchantid = 'A1X6FK5RDHNB96'
1081 0.0004 0.00040411949157715 
SELECT * FROM productoffers
                WHERE product_id = '4766' AND price > 0
                ORDER BY price ASC LIMIT 1
1082 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = 4766
                ORDER BY price ASC LIMIT 1
1083 0.0004 0.00040006637573242 
SELECT value FROM productattributes
                WHERE product_id = '4766'
                AND name = 'ListPriceAmount'
1084 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '4766' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1085 0.0006 0.00059795379638672 
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
1086 0.0009 0.0009150505065918 
SELECT * FROM product_image_select WHERE product_id = '1007'
1087 0.0005 0.00045490264892578 
SELECT * FROM productcustomimages WHERE product_id = '1007'
1088 0.0014 0.0013601779937744 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
1089 0.0005 0.00054597854614258 
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
1090 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
1091 0.0006 0.00062799453735352 
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1092 0.0007 0.00066900253295898 
SELECT * FROM productimages WHERE product_id = '1268' ORDER BY sortorder ASC
1093 0.0010 0.0010209083557129 
SELECT * FROM product_image_select WHERE product_id = '1268'
1094 0.0004 0.00044608116149902 
SELECT * FROM productcustomimages WHERE product_id = '1268'
1095 0.0013 0.0013477802276611 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1268' AND a.name = n.originalname
1096 0.0006 0.0006248950958252 
SELECT * FROM productoffers WHERE product_id = '1268' AND merchantid = 'A1X6FK5RDHNB96'
1097 0.0004 0.00042891502380371 
SELECT * FROM productoffers
                WHERE product_id = '1268' AND price > 0
                ORDER BY price ASC LIMIT 1
1098 0.0004 0.00044703483581543 
SELECT value FROM productattributes WHERE product_id = '1268' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1099 0.0006 0.00059294700622559 
SELECT * FROM productimages WHERE product_id = '1232' ORDER BY sortorder ASC
1100 0.0009 0.00092077255249023 
SELECT * FROM product_image_select WHERE product_id = '1232'
1101 0.0004 0.0004429817199707 
SELECT * FROM productcustomimages WHERE product_id = '1232'
1102 0.0010 0.0010061264038086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1232' AND a.name = n.originalname
1103 0.0006 0.00055313110351562 
SELECT * FROM productoffers WHERE product_id = '1232' AND merchantid = 'A1X6FK5RDHNB96'
1104 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = '1232' AND price > 0
                ORDER BY price ASC LIMIT 1
1105 0.0004 0.00044703483581543 
SELECT value FROM productattributes WHERE product_id = '1232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1106 0.0006 0.0006101131439209 
SELECT * FROM productimages WHERE product_id = '1276' ORDER BY sortorder ASC
1107 0.0009 0.00091814994812012 
SELECT * FROM product_image_select WHERE product_id = '1276'
1108 0.0005 0.00045394897460938 
SELECT * FROM productcustomimages WHERE product_id = '1276'
1109 0.0010 0.00098800659179688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1276' AND a.name = n.originalname
1110 0.0006 0.00055289268493652 
SELECT * FROM productoffers WHERE product_id = '1276' AND merchantid = 'A1X6FK5RDHNB96'
1111 0.0004 0.00042891502380371 
SELECT * FROM productoffers
                WHERE product_id = '1276' AND price > 0
                ORDER BY price ASC LIMIT 1
1112 0.0005 0.00045299530029297 
SELECT value FROM productattributes WHERE product_id = '1276' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1113 0.0015 0.0015380382537842 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
1114 0.0011 0.001060962677002 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
1115 0.0004 0.00035786628723145 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
1116 0.0228 0.022826910018921 
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
1117 0.0010 0.00095796585083008 
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
1118 0.0004 0.00038695335388184 
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
1119 0.0004 0.0003659725189209 
SELECT * FROM products WHERE id = 1626
1120 0.0003 0.00026607513427734 
SELECT * FROM products WHERE id = 4041
1121 0.0003 0.00025010108947754 
SELECT * FROM products WHERE id = 4312
1122 0.0002 0.00023889541625977 
SELECT * FROM products WHERE id = 777
1123 0.0002 0.00024986267089844 
SELECT * FROM products WHERE id = 3881
1124 0.0002 0.00024318695068359 
SELECT * FROM products WHERE id = 4213
1125 0.0002 0.00024604797363281 
SELECT * FROM products WHERE id = '1626'
1126 0.0003 0.00030803680419922 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
1127 0.0004 0.00043702125549316 
SELECT * FROM product_image_select WHERE product_id = '1626'
1128 0.0003 0.00027704238891602 
SELECT * FROM productcustomimages WHERE product_id = '1626'
1129 0.0006 0.00060677528381348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
1130 0.0003 0.00032711029052734 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
1131 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
1132 0.0003 0.00027704238891602 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1133 0.0003 0.00033402442932129 
SELECT * FROM products WHERE id = '4041'
1134 0.0003 0.00030684471130371 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
1135 0.0004 0.00044584274291992 
SELECT * FROM product_image_select WHERE product_id = '4041'
1136 0.0003 0.00028181076049805 
SELECT * FROM productcustomimages WHERE product_id = '4041'
1137 0.0007 0.00073814392089844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
1138 0.0003 0.00032186508178711 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
1139 0.0003 0.00028014183044434 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
1140 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1141 0.0004 0.00037598609924316 
SELECT * FROM products WHERE id = '4312'
1142 0.0003 0.00033187866210938 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
1143 0.0005 0.00046181678771973 
SELECT * FROM product_image_select WHERE product_id = '4312'
1144 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '4312'
1145 0.0007 0.00067806243896484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
1146 0.0003 0.00030994415283203 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
1147 0.0003 0.00028204917907715 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
1148 0.0003 0.00025796890258789 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1149 0.0003 0.00032591819763184 
SELECT * FROM products WHERE id = '777'
1150 0.0003 0.00030207633972168 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
1151 0.0004 0.00043392181396484 
SELECT * FROM product_image_select WHERE product_id = '777'
1152 0.0003 0.00025796890258789 
SELECT * FROM productcustomimages WHERE product_id = '777'
1153 0.0007 0.00065279006958008 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
1154 0.0003 0.00031399726867676 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
1155 0.0003 0.00027108192443848 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
1156 0.0003 0.0002589225769043 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1157 0.0003 0.00034499168395996 
SELECT * FROM products WHERE id = '3881'
1158 0.0004 0.0003662109375 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
1159 0.0004 0.00044608116149902 
SELECT * FROM product_image_select WHERE product_id = '3881'
1160 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '3881'
1161 0.0007 0.00070786476135254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
1162 0.0003 0.0003058910369873 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
1163 0.0003 0.00029087066650391 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
1164 0.0003 0.00026607513427734 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1165 0.0003 0.00034713745117188 
SELECT * FROM products WHERE id = '4213'
1166 0.0004 0.00035905838012695 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
1167 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '4213'
1168 0.0003 0.00027298927307129 
SELECT * FROM productcustomimages WHERE product_id = '4213'
1169 0.0007 0.00071907043457031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
1170 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
1171 0.0003 0.00028705596923828 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
1172 0.0003 0.00027680397033691 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
1173 0.0011 0.0010979175567627 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
1174 0.0005 0.00049018859863281 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
1175 0.0015 0.0014851093292236 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
1176 0.0009 0.00092101097106934 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
1177 0.0004 0.00036001205444336 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
1178 0.0004 0.00041389465332031 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
1179 0.0004 0.00038695335388184 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'