0

Site Map

Products

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.68122720718384 805 0.4217 0


No Amazon API Requests Made.


App Debug - Total Time 0.68122720718384 seconds

Number Time From Start Name Description
1 0.21306109428406 Initialise Initialise FSB Function
2 0.2141420841217 App Controller Start Start of the App controller (called before the controller of every page)
3 0.23589420318604 Start of getCategoryListByGroup Function Before first category groups query
4 0.23620319366455 After initial query Before first category groups query
5 0.23620414733887 Get Category List for Group Before the call to getCategoryList function
6 0.2362060546875 Start of GetCategoryList function Start of the function
7 0.23620820045471 Before getting categories Query to get specific category list
8 0.2365710735321 After getting categories Query to get specific category list
9 0.23657202720642 Before getting category custom Before call to function getCategoryCustom
10 0.24826502799988 After getting category custom After call to function getCategoryCustom
11 0.24826622009277 Before getting category custom Before call to function getCategoryCustom
12 0.25664710998535 After getting category custom After call to function getCategoryCustom
13 0.25664806365967 Before getting category custom Before call to function getCategoryCustom
14 0.26228713989258 After getting category custom After call to function getCategoryCustom
15 0.26229119300842 Before getting category custom Before call to function getCategoryCustom
16 0.26532411575317 After getting category custom After call to function getCategoryCustom
17 0.26532602310181 Before getting category custom Before call to function getCategoryCustom
18 0.26830410957336 After getting category custom After call to function getCategoryCustom
19 0.26830506324768 Before getting category custom Before call to function getCategoryCustom
20 0.27152013778687 After getting category custom After call to function getCategoryCustom
21 0.2715220451355 End of GetCategoryList function End of the function
22 0.27152919769287 Get Category List for Group Before the call to getCategoryList function
23 0.27153015136719 Start of GetCategoryList function Start of the function
24 0.27153205871582 Before getting categories Query to get specific category list
25 0.27205920219421 End of getCategoryListByGroup Function Before return()
26 0.2816641330719 App Controller End End of the App controller (called before the controller of every page)
27 0.28543305397034 Start of GetCategoryList function Start of the function
28 0.28543519973755 Before getting categories Query to get specific category list
29 0.28605818748474 After getting categories Query to get specific category list
30 0.28605914115906 Before getting category custom Before call to function getCategoryCustom
31 0.31513714790344 After getting category custom After call to function getCategoryCustom
32 0.31513810157776 Before getting sub category list Before call to recursive function getCategoryList
33 0.31514000892639 Start of GetCategoryList function Start of the function
34 0.3151421546936 Before getting categories Query to get specific category list
35 0.31572222709656 After getting sub category list After call to recursive function getCategoryList
36 0.31572413444519 Before getting category custom Before call to function getCategoryCustom
37 0.33274412155151 After getting category custom After call to function getCategoryCustom
38 0.33274507522583 Before getting sub category list Before call to recursive function getCategoryList
39 0.33274602890015 Start of GetCategoryList function Start of the function
40 0.33274722099304 Before getting categories Query to get specific category list
41 0.33333301544189 After getting sub category list After call to recursive function getCategoryList
42 0.33333420753479 Before getting category custom Before call to function getCategoryCustom
43 0.33894515037537 After getting category custom After call to function getCategoryCustom
44 0.33894610404968 Before getting sub category list Before call to recursive function getCategoryList
45 0.33894610404968 Start of GetCategoryList function Start of the function
46 0.33894801139832 Before getting categories Query to get specific category list
47 0.33927607536316 After getting sub category list After call to recursive function getCategoryList
48 0.33927702903748 Before getting category custom Before call to function getCategoryCustom
49 0.34260106086731 After getting category custom After call to function getCategoryCustom
50 0.34260201454163 Before getting sub category list Before call to recursive function getCategoryList
51 0.34260320663452 Start of GetCategoryList function Start of the function
52 0.34260416030884 Before getting categories Query to get specific category list
53 0.34300017356873 After getting sub category list After call to recursive function getCategoryList
54 0.34300017356873 Before getting category custom Before call to function getCategoryCustom
55 0.34609413146973 After getting category custom After call to function getCategoryCustom
56 0.34609508514404 Before getting sub category list Before call to recursive function getCategoryList
57 0.34609603881836 Start of GetCategoryList function Start of the function
58 0.34609723091125 Before getting categories Query to get specific category list
59 0.34644913673401 After getting sub category list After call to recursive function getCategoryList
60 0.34645009040833 Before getting category custom Before call to function getCategoryCustom
61 0.34947514533997 After getting category custom After call to function getCategoryCustom
62 0.34947514533997 Before getting sub category list Before call to recursive function getCategoryList
63 0.34947609901428 Start of GetCategoryList function Start of the function
64 0.3494770526886 Before getting categories Query to get specific category list
65 0.34979200363159 After getting sub category list After call to recursive function getCategoryList
66 0.34979319572449 End of GetCategoryList function End of the function
67 0.60395503044128 App_after Controller Start Start of the App_after controller (called after the controller of every page)
68 0.6045970916748 Before Get Options Before the call to getOptions in the tpl class
69 0.64398908615112 After Get Options After the call to getOptions in the tpl class
70 0.64401721954346 App_after Controller End End of the App_after controller (called after the controller of every page)
71 0.68121719360352 Finalizing debug Before the debug is output to the page.
72 0.68122720718384 End of App This is the end of the app logging, final timestamp


Query Debug - 805 Database Queries. Total time 0.4217 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00075483322143555
SELECT parameter, value FROM parameters
2 0.0019 0.0018589496612549
SELECT * FROM `bad_bots`
3 0.0002 0.00023508071899414
SET time_zone = 'Europe/London'
4 0.0003 0.00034809112548828
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0004 0.00039005279541016
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.48\";}'
6 0.0003 0.00033807754516602
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1752877557'
7 0.0005 0.00046586990356445
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00023698806762695
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00036501884460449
SELECT id FROM pages WHERE pagename = 'site-map' LIMIT 1
10 0.0002 0.00024914741516113
SELECT * FROM pages WHERE id = 43
11 0.0010 0.0010268688201904
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0202 0.020199060440063
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0003 0.00032591819763184
SELECT * FROM pages WHERE pagename = 'site-map'
14 0.0003 0.0003049373626709
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00035595893859863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0048 0.00478196144104
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.0003 0.0003349781036377
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.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00031304359436035
SELECT id FROM categories WHERE parent_id = '26'
20 0.0047 0.0046539306640625
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.0003511905670166
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.00036311149597168
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.00031208992004395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00027608871459961
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030109882354736
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.00031399726867676
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.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00031399726867676
SELECT id FROM categories WHERE parent_id = '27'
29 0.0032 0.0031559467315674
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.0003 0.00033807754516602
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.00034093856811523
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.0003 0.00031709671020508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00030016899108887
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.001798152923584
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.00033307075500488
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.00030612945556641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00032401084899902
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014638900756836
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.00035691261291504
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.0003509521484375
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.00034499168395996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00029301643371582
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00037097930908203
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.00034880638122559
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.00026512145996094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.00042200088500977
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.00032615661621094
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.00034308433532715
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.0003349781036377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00029301643371582
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.0003669261932373
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.00030994415283203
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.00028610229492188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00030899047851562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00040721893310547
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.00033116340637207
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.0003 0.00034093856811523
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.00029993057250977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00028109550476074
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.0004119873046875
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.00032210350036621
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.00026488304138184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00033903121948242
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00046992301940918
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.00038599967956543
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.00036787986755371
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.00030994415283203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00028419494628906
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00051999092102051
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0036 0.0035691261291504
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0009 0.00086712837219238
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00065207481384277
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.0005 0.00048279762268066
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0021 0.0020508766174316
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012319087982178
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0005 0.00048398971557617
SELECT * FROM pages WHERE pagename = 'site-map'
78 0.0006 0.00060892105102539
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
79 0.0118 0.011752128601074
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
80 0.0006 0.00064587593078613
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
81 0.0005 0.00053191184997559
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
82 0.0005 0.00053501129150391
SELECT id FROM categories WHERE parent_id = '26'
83 0.0130 0.01301383972168
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 
84 0.0007 0.00069093704223633
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 
85 0.0008 0.00077199935913086
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
86 0.0006 0.00057601928710938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
87 0.0005 0.00048708915710449
SELECT * FROM categorygroups WHERE id = '1'
88 0.0006 0.00057411193847656
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
89 0.0073 0.0073199272155762
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
90 0.0005 0.0005488395690918
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
91 0.0004 0.00038599967956543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
92 0.0004 0.00042009353637695
SELECT id FROM categories WHERE parent_id = '27'
93 0.0058 0.0058460235595703
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 
94 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
95 0.0006 0.00058889389038086
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
96 0.0007 0.00070977210998535
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
97 0.0006 0.00056099891662598
SELECT * FROM categorygroups WHERE id = '1'
98 0.0006 0.00057888031005859
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
99 0.0022 0.0021829605102539
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
100 0.0003 0.00032186508178711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
101 0.0003 0.00026702880859375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
102 0.0003 0.00029110908508301
SELECT id FROM categories WHERE parent_id = '28'
103 0.0012 0.0011980533599854
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 
104 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 (28)
				  AND p.disabled = 0 
105 0.0003 0.00034093856811523
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
106 0.0003 0.00031399726867676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
107 0.0003 0.0002899169921875
SELECT * FROM categorygroups WHERE id = '1'
108 0.0003 0.00032305717468262
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
109 0.0005 0.00050091743469238
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
110 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 = 29
111 0.0003 0.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
112 0.0003 0.00029397010803223
SELECT id FROM categories WHERE parent_id = '29'
113 0.0005 0.0004570484161377
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 
114 0.0003 0.00034379959106445
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 
115 0.0004 0.00035905838012695
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
116 0.0003 0.00031304359436035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
117 0.0004 0.00039386749267578
SELECT * FROM categorygroups WHERE id = '1'
118 0.0004 0.00038909912109375
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
119 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 = 30
120 0.0003 0.00031304359436035
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
121 0.0003 0.0002901554107666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
122 0.0003 0.00028800964355469
SELECT id FROM categories WHERE parent_id = '30'
123 0.0004 0.00041484832763672
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 
124 0.0004 0.00038599967956543
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 
125 0.0003 0.00034880638122559
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
126 0.0003 0.00030398368835449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
127 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
128 0.0003 0.00034785270690918
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0004 0.0004279613494873
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
130 0.0003 0.00030398368835449
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
131 0.0003 0.0002598762512207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
132 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '31'
133 0.0004 0.00043296813964844
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 
134 0.0003 0.00031399726867676
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 
135 0.0003 0.00032591819763184
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
136 0.0003 0.00034689903259277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
137 0.0003 0.00029802322387695
SELECT * FROM categorygroups WHERE id = '1'
138 0.0003 0.00031304359436035
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
139 0.0005 0.00047016143798828
SELECT * FROM pages WHERE xmlsitemap = 1
140 0.0039 0.0038800239562988
SELECT COUNT(*) FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 
141 0.0051 0.005126953125
SELECT * FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 ORDER BY linktitle LIMIT 0, 59
142 0.0005 0.00046300888061523
SELECT * FROM productimages WHERE product_id = '2214' ORDER BY sortorder ASC
143 0.0003 0.00029611587524414
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2214' AND p.id = pi.product_id ORDER BY pi.sortorder
144 0.0005 0.00049185752868652
SELECT * FROM product_image_select WHERE product_id = '2214'
145 0.0003 0.00030183792114258
SELECT * FROM productcustomimages WHERE product_id = '2214'
146 0.0005 0.00048589706420898
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2214'
                GROUP BY o.product_id
147 0.0004 0.00044393539428711
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     = '2214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0003 0.00028800964355469
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2214
149 0.0007 0.0006558895111084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2214' AND a.name = n.originalname
150 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '2214' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.0002591609954834
SELECT * FROM productoffers
                WHERE product_id = '2214' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = 2214
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00025105476379395
SELECT value FROM productattributes
                WHERE product_id = '2214'
                AND name = 'ListPriceAmount'
154 0.0003 0.00026202201843262
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 = '2214'
                GROUP BY o.product_id
155 0.0004 0.00037312507629395
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     = '2214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
156 0.0003 0.00025296211242676
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2214
157 0.0003 0.00032281875610352
SELECT value FROM productattributes WHERE product_id = '2214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0003 0.00027585029602051
SELECT * FROM products WHERE parent_id = '2214'
159 0.0003 0.00030517578125
SELECT * FROM productimages WHERE product_id = '1445' ORDER BY sortorder ASC
160 0.0005 0.00045919418334961
SELECT * FROM product_image_select WHERE product_id = '1445'
161 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '1445'
162 0.0008 0.00080513954162598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1445' AND a.name = n.originalname
163 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '1445' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = '1445' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = 1445
                ORDER BY price ASC LIMIT 1
166 0.0003 0.00027799606323242
SELECT value FROM productattributes
                WHERE product_id = '1445'
                AND name = 'ListPriceAmount'
167 0.0003 0.0002751350402832
SELECT value FROM productattributes WHERE product_id = '1445' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0004 0.00036287307739258
SELECT * FROM productimages WHERE product_id = '1535' ORDER BY sortorder ASC
169 0.0005 0.00053715705871582
SELECT * FROM product_image_select WHERE product_id = '1535'
170 0.0003 0.0003058910369873
SELECT * FROM productcustomimages WHERE product_id = '1535'
171 0.0006 0.00063490867614746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1535' AND a.name = n.originalname
172 0.0003 0.00034999847412109
SELECT * FROM productoffers WHERE product_id = '1535' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = '1535' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = 1535
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00027012825012207
SELECT value FROM productattributes
                WHERE product_id = '1535'
                AND name = 'ListPriceAmount'
176 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '1535' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0003 0.00034284591674805
SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
178 0.0005 0.00046586990356445
SELECT * FROM product_image_select WHERE product_id = '2021'
179 0.0003 0.0002892017364502
SELECT * FROM productcustomimages WHERE product_id = '2021'
180 0.0006 0.0006411075592041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
181 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '2021' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 2021
                ORDER BY price ASC LIMIT 1
184 0.0003 0.00025510787963867
SELECT value FROM productattributes
                WHERE product_id = '2021'
                AND name = 'ListPriceAmount'
185 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0003 0.00034308433532715
SELECT * FROM productimages WHERE product_id = '1458' ORDER BY sortorder ASC
187 0.0005 0.00045084953308105
SELECT * FROM product_image_select WHERE product_id = '1458'
188 0.0003 0.00027680397033691
SELECT * FROM productcustomimages WHERE product_id = '1458'
189 0.0006 0.00062394142150879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1458' AND a.name = n.originalname
190 0.0004 0.00038290023803711
SELECT * FROM productoffers WHERE product_id = '1458' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0003 0.00029993057250977
SELECT * FROM productoffers
                WHERE product_id = '1458' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0003 0.00032186508178711
SELECT value FROM productattributes WHERE product_id = '1458' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0003 0.00033712387084961
SELECT * FROM productimages WHERE product_id = '1221' ORDER BY sortorder ASC
194 0.0005 0.00047016143798828
SELECT * FROM product_image_select WHERE product_id = '1221'
195 0.0003 0.0002751350402832
SELECT * FROM productcustomimages WHERE product_id = '1221'
196 0.0005 0.00052905082702637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1221' AND a.name = n.originalname
197 0.0004 0.00036907196044922
SELECT * FROM productoffers WHERE product_id = '1221' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '1221' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 1221
                ORDER BY price ASC LIMIT 1
200 0.0003 0.00025391578674316
SELECT value FROM productattributes
                WHERE product_id = '1221'
                AND name = 'ListPriceAmount'
201 0.0003 0.0002901554107666
SELECT value FROM productattributes WHERE product_id = '1221' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0004 0.00036311149597168
SELECT * FROM productimages WHERE product_id = '2954' ORDER BY sortorder ASC
203 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '2954'
204 0.0003 0.00028014183044434
SELECT * FROM productcustomimages WHERE product_id = '2954'
205 0.0006 0.00060606002807617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2954' AND a.name = n.originalname
206 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '2954' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0003 0.0002591609954834
SELECT * FROM productoffers
                WHERE product_id = '2954' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0002 0.00024986267089844
SELECT * FROM productoffers
                WHERE product_id = 2954
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00026202201843262
SELECT value FROM productattributes
                WHERE product_id = '2954'
                AND name = 'ListPriceAmount'
210 0.0003 0.00028896331787109
SELECT value FROM productattributes WHERE product_id = '2954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '778' ORDER BY sortorder ASC
212 0.0004 0.00044488906860352
SELECT * FROM product_image_select WHERE product_id = '778'
213 0.0003 0.00028777122497559
SELECT * FROM productcustomimages WHERE product_id = '778'
214 0.0006 0.00061488151550293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '778' AND a.name = n.originalname
215 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '778' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0002 0.0002448558807373
SELECT * FROM productoffers
                WHERE product_id = '778' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = 778
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00024890899658203
SELECT value FROM productattributes
                WHERE product_id = '778'
                AND name = 'ListPriceAmount'
219 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '778' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0003 0.00031518936157227
SELECT * FROM productimages WHERE product_id = '1854' ORDER BY sortorder ASC
221 0.0005 0.00047111511230469
SELECT * FROM product_image_select WHERE product_id = '1854'
222 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '1854'
223 0.0006 0.00056004524230957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1854' AND a.name = n.originalname
224 0.0004 0.0003509521484375
SELECT * FROM productoffers WHERE product_id = '1854' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '1854' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = 1854
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00027203559875488
SELECT value FROM productattributes
                WHERE product_id = '1854'
                AND name = 'ListPriceAmount'
228 0.0003 0.00034594535827637
SELECT value FROM productattributes WHERE product_id = '1854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0003 0.00034117698669434
SELECT * FROM productimages WHERE product_id = '3897' ORDER BY sortorder ASC
230 0.0004 0.00044894218444824
SELECT * FROM product_image_select WHERE product_id = '3897'
231 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '3897'
232 0.0005 0.00051093101501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3897' AND a.name = n.originalname
233 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '3897' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0002 0.00024890899658203
SELECT * FROM productoffers
                WHERE product_id = '3897' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = 3897
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00029706954956055
SELECT value FROM productattributes
                WHERE product_id = '3897'
                AND name = 'ListPriceAmount'
237 0.0003 0.00026178359985352
SELECT value FROM productattributes WHERE product_id = '3897' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
239 0.0004 0.00044488906860352
SELECT * FROM product_image_select WHERE product_id = '4944'
240 0.0003 0.00031280517578125
SELECT * FROM productcustomimages WHERE product_id = '4944'
241 0.0007 0.00068402290344238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
242 0.0003 0.00032806396484375
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
246 0.0003 0.00026679039001465
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '2439' ORDER BY sortorder ASC
248 0.0005 0.00047802925109863
SELECT * FROM product_image_select WHERE product_id = '2439'
249 0.0003 0.0002748966217041
SELECT * FROM productcustomimages WHERE product_id = '2439'
250 0.0007 0.00066399574279785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2439' AND a.name = n.originalname
251 0.0003 0.00033998489379883
SELECT * FROM productoffers WHERE product_id = '2439' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '2439' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 2439
                ORDER BY price ASC LIMIT 1
254 0.0003 0.00030183792114258
SELECT value FROM productattributes
                WHERE product_id = '2439'
                AND name = 'ListPriceAmount'
255 0.0003 0.00032305717468262
SELECT value FROM productattributes WHERE product_id = '2439' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0008 0.0008080005645752
SELECT * FROM productimages WHERE product_id = '4148' ORDER BY sortorder ASC
257 0.0006 0.00059199333190918
SELECT * FROM product_image_select WHERE product_id = '4148'
258 0.0004 0.00037503242492676
SELECT * FROM productcustomimages WHERE product_id = '4148'
259 0.0006 0.00061511993408203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4148' AND a.name = n.originalname
260 0.0003 0.00031590461730957
SELECT * FROM productoffers WHERE product_id = '4148' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0003 0.00027704238891602
SELECT * FROM productoffers
                WHERE product_id = '4148' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0003 0.00031304359436035
SELECT value FROM productattributes WHERE product_id = '4148' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0003 0.00032997131347656
SELECT * FROM productimages WHERE product_id = '4059' ORDER BY sortorder ASC
264 0.0005 0.00046610832214355
SELECT * FROM product_image_select WHERE product_id = '4059'
265 0.0003 0.00030016899108887
SELECT * FROM productcustomimages WHERE product_id = '4059'
266 0.0022 0.002161979675293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4059' AND a.name = n.originalname
267 0.0006 0.00061702728271484
SELECT * FROM productoffers WHERE product_id = '4059' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '4059' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '4059' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0006 0.00061702728271484
SELECT * FROM productimages WHERE product_id = '1873' ORDER BY sortorder ASC
271 0.0009 0.00087404251098633
SELECT * FROM product_image_select WHERE product_id = '1873'
272 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '1873'
273 0.0013 0.0013298988342285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1873' AND a.name = n.originalname
274 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '1873' AND merchantid = 'A1X6FK5RDHNB96'
275 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '1873' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = 1873
                ORDER BY price ASC LIMIT 1
277 0.0004 0.00040698051452637
SELECT value FROM productattributes
                WHERE product_id = '1873'
                AND name = 'ListPriceAmount'
278 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0006 0.00060915946960449
SELECT * FROM productimages WHERE product_id = '3348' ORDER BY sortorder ASC
280 0.0007 0.00071096420288086
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3348' AND p.id = pi.product_id ORDER BY pi.sortorder
281 0.0009 0.00086784362792969
SELECT * FROM product_image_select WHERE product_id = '3348'
282 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '3348'
283 0.0006 0.00062894821166992
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 = '3348'
                GROUP BY o.product_id
284 0.0009 0.00086712837219238
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     = '3348'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
285 0.0005 0.0004730224609375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3348
286 0.0014 0.0013790130615234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3348' AND a.name = n.originalname
287 0.0004 0.00038385391235352
SELECT * FROM productoffers WHERE product_id = '3348' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0004 0.00040888786315918
SELECT * FROM productoffers
                WHERE product_id = '3348' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0004 0.00037717819213867
SELECT * FROM productoffers
                WHERE product_id = 3348
                ORDER BY price ASC LIMIT 1
290 0.0004 0.00039911270141602
SELECT value FROM productattributes
                WHERE product_id = '3348'
                AND name = 'ListPriceAmount'
291 0.0004 0.00044894218444824
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 = '3348'
                GROUP BY o.product_id
292 0.0008 0.00076508522033691
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     = '3348'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
293 0.0004 0.00042104721069336
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3348
294 0.0006 0.00057291984558105
SELECT value FROM productattributes WHERE product_id = '3348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0007 0.00074076652526855
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3348'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
296 0.0006 0.00058817863464355
SELECT * FROM productimages WHERE product_id = '3775' ORDER BY sortorder ASC
297 0.0009 0.00085783004760742
SELECT * FROM product_image_select WHERE product_id = '3775'
298 0.0005 0.00049996376037598
SELECT * FROM productcustomimages WHERE product_id = '3775'
299 0.0011 0.0010738372802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3775' AND a.name = n.originalname
300 0.0005 0.00053286552429199
SELECT * FROM productoffers WHERE product_id = '3775' AND merchantid = 'A1X6FK5RDHNB96'
301 0.0004 0.00038981437683105
SELECT * FROM productoffers
                WHERE product_id = '3775' AND price > 0
                ORDER BY price ASC LIMIT 1
302 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = 3775
                ORDER BY price ASC LIMIT 1
303 0.0004 0.00040984153747559
SELECT value FROM productattributes
                WHERE product_id = '3775'
                AND name = 'ListPriceAmount'
304 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '3775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0008 0.00078701972961426
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
306 0.0010 0.0010440349578857
SELECT * FROM product_image_select WHERE product_id = '4930'
307 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '4930'
308 0.0019 0.0019199848175049
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
309 0.0006 0.0006110668182373
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0007 0.00074505805969238
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
313 0.0009 0.00091695785522461
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3693' AND p.id = pi.product_id ORDER BY pi.sortorder
314 0.0010 0.001039981842041
SELECT * FROM product_image_select WHERE product_id = '3693'
315 0.0006 0.00059413909912109
SELECT * FROM productcustomimages WHERE product_id = '3693'
316 0.0009 0.00085997581481934
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 = '3693'
                GROUP BY o.product_id
317 0.0010 0.0010409355163574
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     = '3693'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
318 0.0005 0.00047016143798828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
319 0.0016 0.0016119480133057
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
320 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
321 0.0005 0.00048589706420898
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
322 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
323 0.0004 0.00042581558227539
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
324 0.0005 0.00046706199645996
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3693'
                GROUP BY o.product_id
325 0.0009 0.00085091590881348
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     = '3693'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
326 0.0005 0.0005030632019043
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
327 0.0006 0.00061297416687012
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0008 0.00078415870666504
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3693'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
329 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '3940' ORDER BY sortorder ASC
330 0.0005 0.00046896934509277
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3940' AND p.id = pi.product_id ORDER BY pi.sortorder
331 0.0009 0.00092983245849609
SELECT * FROM product_image_select WHERE product_id = '3940'
332 0.0005 0.00045919418334961
SELECT * FROM productcustomimages WHERE product_id = '3940'
333 0.0006 0.00064301490783691
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 = '3940'
                GROUP BY o.product_id
334 0.0008 0.00084209442138672
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     = '3940'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
335 0.0005 0.00045108795166016
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3940
336 0.0016 0.0016021728515625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3940' AND a.name = n.originalname
337 0.0004 0.00040507316589355
SELECT * FROM productoffers WHERE product_id = '3940' AND merchantid = 'A1X6FK5RDHNB96'
338 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '3940' AND price > 0
                ORDER BY price ASC LIMIT 1
339 0.0004 0.00037002563476562
SELECT * FROM productoffers
                WHERE product_id = 3940
                ORDER BY price ASC LIMIT 1
340 0.0004 0.00042986869812012
SELECT value FROM productattributes
                WHERE product_id = '3940'
                AND name = 'ListPriceAmount'
341 0.0005 0.00045013427734375
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 = '3940'
                GROUP BY o.product_id
342 0.0009 0.00093197822570801
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     = '3940'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
343 0.0004 0.00042390823364258
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3940
344 0.0007 0.00071191787719727
SELECT value FROM productattributes WHERE product_id = '3940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0004 0.00042295455932617
SELECT * FROM products WHERE parent_id = '3940'
346 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '3728' ORDER BY sortorder ASC
347 0.0010 0.00098919868469238
SELECT * FROM product_image_select WHERE product_id = '3728'
348 0.0005 0.00051689147949219
SELECT * FROM productcustomimages WHERE product_id = '3728'
349 0.0010 0.0010318756103516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3728' AND a.name = n.originalname
350 0.0005 0.00047516822814941
SELECT * FROM productoffers WHERE product_id = '3728' AND merchantid = 'A1X6FK5RDHNB96'
351 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = '3728' AND price > 0
                ORDER BY price ASC LIMIT 1
352 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = 3728
                ORDER BY price ASC LIMIT 1
353 0.0004 0.00035905838012695
SELECT value FROM productattributes
                WHERE product_id = '3728'
                AND name = 'ListPriceAmount'
354 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '3728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '3234' ORDER BY sortorder ASC
356 0.0007 0.00073099136352539
SELECT * FROM product_image_select WHERE product_id = '3234'
357 0.0004 0.00038504600524902
SELECT * FROM productcustomimages WHERE product_id = '3234'
358 0.0010 0.0010349750518799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3234' AND a.name = n.originalname
359 0.0005 0.00045490264892578
SELECT * FROM productoffers WHERE product_id = '3234' AND merchantid = 'A1X6FK5RDHNB96'
360 0.0004 0.0003809928894043
SELECT * FROM productoffers
                WHERE product_id = '3234' AND price > 0
                ORDER BY price ASC LIMIT 1
361 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = 3234
                ORDER BY price ASC LIMIT 1
362 0.0004 0.00037384033203125
SELECT value FROM productattributes
                WHERE product_id = '3234'
                AND name = 'ListPriceAmount'
363 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '3234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0006 0.00059294700622559
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
365 0.0009 0.00085091590881348
SELECT * FROM product_image_select WHERE product_id = '812'
366 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '812'
367 0.0010 0.00095009803771973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
368 0.0005 0.00048518180847168
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'A1X6FK5RDHNB96'
369 0.0004 0.0004122257232666
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
370 0.0004 0.0003669261932373
SELECT * FROM productoffers
                WHERE product_id = 812
                ORDER BY price ASC LIMIT 1
371 0.0004 0.00037407875061035
SELECT value FROM productattributes
                WHERE product_id = '812'
                AND name = 'ListPriceAmount'
372 0.0003 0.00028681755065918
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373 0.0004 0.0003509521484375
SELECT * FROM productimages WHERE product_id = '4559' ORDER BY sortorder ASC
374 0.0004 0.00038409233093262
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4559' AND p.id = pi.product_id ORDER BY pi.sortorder
375 0.0005 0.00048279762268066
SELECT * FROM product_image_select WHERE product_id = '4559'
376 0.0003 0.00027585029602051
SELECT * FROM productcustomimages WHERE product_id = '4559'
377 0.0004 0.0003960132598877
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 = '4559'
                GROUP BY o.product_id
378 0.0004 0.00043892860412598
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     = '4559'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
379 0.0003 0.00030994415283203
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4559
380 0.0006 0.00058197975158691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4559' AND a.name = n.originalname
381 0.0003 0.00025796890258789
SELECT * FROM productoffers WHERE product_id = '4559' AND merchantid = 'A1X6FK5RDHNB96'
382 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '4559' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = 4559
                ORDER BY price ASC LIMIT 1
384 0.0003 0.00033688545227051
SELECT value FROM productattributes
                WHERE product_id = '4559'
                AND name = 'ListPriceAmount'
385 0.0003 0.00028800964355469
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 = '4559'
                GROUP BY o.product_id
386 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     = '4559'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
387 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 = 4559
388 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '4559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
389 0.0004 0.00037813186645508
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4559'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
390 0.0003 0.00034689903259277
SELECT * FROM productimages WHERE product_id = '4292' ORDER BY sortorder ASC
391 0.0003 0.0002739429473877
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4292' AND p.id = pi.product_id ORDER BY pi.sortorder
392 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '4292'
393 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '4292'
394 0.0003 0.00031685829162598
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 = '4292'
                GROUP BY o.product_id
395 0.0004 0.00036406517028809
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     = '4292'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
396 0.0003 0.00025796890258789
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4292
397 0.0005 0.00053906440734863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4292' AND a.name = n.originalname
398 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '4292' AND merchantid = 'A1X6FK5RDHNB96'
399 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '4292' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = 4292
                ORDER BY price ASC LIMIT 1
401 0.0003 0.00030779838562012
SELECT value FROM productattributes
                WHERE product_id = '4292'
                AND name = 'ListPriceAmount'
402 0.0003 0.00025582313537598
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 = '4292'
                GROUP BY o.product_id
403 0.0004 0.00036501884460449
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     = '4292'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
404 0.0002 0.00024294853210449
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4292
405 0.0003 0.0003209114074707
SELECT value FROM productattributes WHERE product_id = '4292' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406 0.0003 0.0002901554107666
SELECT * FROM products WHERE parent_id = '4292'
407 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '4061' ORDER BY sortorder ASC
408 0.0003 0.00027894973754883
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4061' AND p.id = pi.product_id ORDER BY pi.sortorder
409 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '4061'
410 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '4061'
411 0.0003 0.00033783912658691
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 = '4061'
                GROUP BY o.product_id
412 0.0004 0.00039410591125488
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     = '4061'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
413 0.0003 0.00025606155395508
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4061
414 0.0005 0.00054812431335449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4061' AND a.name = n.originalname
415 0.0002 0.00024890899658203
SELECT * FROM productoffers WHERE product_id = '4061' AND merchantid = 'A1X6FK5RDHNB96'
416 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '4061' AND price > 0
                ORDER BY price ASC LIMIT 1
417 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = 4061
                ORDER BY price ASC LIMIT 1
418 0.0002 0.00024795532226562
SELECT value FROM productattributes
                WHERE product_id = '4061'
                AND name = 'ListPriceAmount'
419 0.0003 0.00025010108947754
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 = '4061'
                GROUP BY o.product_id
420 0.0004 0.00038909912109375
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     = '4061'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
421 0.0003 0.00026607513427734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4061
422 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '4061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0003 0.00027894973754883
SELECT * FROM products WHERE parent_id = '4061'
424 0.0004 0.00036191940307617
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
425 0.0005 0.00049304962158203
SELECT * FROM product_image_select WHERE product_id = '2564'
426 0.0003 0.00028514862060547
SELECT * FROM productcustomimages WHERE product_id = '2564'
427 0.0006 0.00061893463134766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
428 0.0003 0.00034904479980469
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
429 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
431 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
432 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
434 0.0005 0.00046205520629883
SELECT * FROM product_image_select WHERE product_id = '3129'
435 0.0003 0.00027799606323242
SELECT * FROM productcustomimages WHERE product_id = '3129'
436 0.0007 0.00066304206848145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
437 0.0003 0.00034403800964355
SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
438 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '3129' AND price > 0
                ORDER BY price ASC LIMIT 1
439 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 3129
                ORDER BY price ASC LIMIT 1
440 0.0002 0.00024795532226562
SELECT value FROM productattributes
                WHERE product_id = '3129'
                AND name = 'ListPriceAmount'
441 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
442 0.0003 0.00031518936157227
SELECT * FROM productimages WHERE product_id = '1892' ORDER BY sortorder ASC
443 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '1892'
444 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '1892'
445 0.0006 0.00064492225646973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1892' AND a.name = n.originalname
446 0.0003 0.00030183792114258
SELECT * FROM productoffers WHERE product_id = '1892' AND merchantid = 'A1X6FK5RDHNB96'
447 0.0003 0.00027012825012207
SELECT * FROM productoffers
                WHERE product_id = '1892' AND price > 0
                ORDER BY price ASC LIMIT 1
448 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = 1892
                ORDER BY price ASC LIMIT 1
449 0.0002 0.00024509429931641
SELECT value FROM productattributes
                WHERE product_id = '1892'
                AND name = 'ListPriceAmount'
450 0.0003 0.00030517578125
SELECT value FROM productattributes WHERE product_id = '1892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
451 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '1617' ORDER BY sortorder ASC
452 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '1617'
453 0.0003 0.00026917457580566
SELECT * FROM productcustomimages WHERE product_id = '1617'
454 0.0007 0.00067496299743652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1617' AND a.name = n.originalname
455 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '1617' AND merchantid = 'A1X6FK5RDHNB96'
456 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = '1617' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = 1617
                ORDER BY price ASC LIMIT 1
458 0.0003 0.00026917457580566
SELECT value FROM productattributes
                WHERE product_id = '1617'
                AND name = 'ListPriceAmount'
459 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '1617' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '1323' ORDER BY sortorder ASC
461 0.0005 0.00049185752868652
SELECT * FROM product_image_select WHERE product_id = '1323'
462 0.0003 0.00027012825012207
SELECT * FROM productcustomimages WHERE product_id = '1323'
463 0.0007 0.00067400932312012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname
464 0.0003 0.00031185150146484
SELECT * FROM productoffers WHERE product_id = '1323' AND merchantid = 'A1X6FK5RDHNB96'
465 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '1323' AND price > 0
                ORDER BY price ASC LIMIT 1
466 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = 1323
                ORDER BY price ASC LIMIT 1
467 0.0003 0.00025701522827148
SELECT value FROM productattributes
                WHERE product_id = '1323'
                AND name = 'ListPriceAmount'
468 0.0003 0.00028419494628906
SELECT value FROM productattributes WHERE product_id = '1323' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
469 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '1322' ORDER BY sortorder ASC
470 0.0004 0.00044584274291992
SELECT * FROM product_image_select WHERE product_id = '1322'
471 0.0003 0.00026297569274902
SELECT * FROM productcustomimages WHERE product_id = '1322'
472 0.0007 0.00074601173400879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1322' AND a.name = n.originalname
473 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '1322' AND merchantid = 'A1X6FK5RDHNB96'
474 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '1322' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = 1322
                ORDER BY price ASC LIMIT 1
476 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '1322'
                AND name = 'ListPriceAmount'
477 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '1322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
478 0.0004 0.00035214424133301
SELECT * FROM productimages WHERE product_id = '870' ORDER BY sortorder ASC
479 0.0005 0.00046110153198242
SELECT * FROM product_image_select WHERE product_id = '870'
480 0.0003 0.00026893615722656
SELECT * FROM productcustomimages WHERE product_id = '870'
481 0.0006 0.00058603286743164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '870' AND a.name = n.originalname
482 0.0003 0.00030612945556641
SELECT * FROM productoffers WHERE product_id = '870' AND merchantid = 'A1X6FK5RDHNB96'
483 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '870' AND price > 0
                ORDER BY price ASC LIMIT 1
484 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = 870
                ORDER BY price ASC LIMIT 1
485 0.0002 0.00024795532226562
SELECT value FROM productattributes
                WHERE product_id = '870'
                AND name = 'ListPriceAmount'
486 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '870' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
487 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '962' ORDER BY sortorder ASC
488 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '962'
489 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '962'
490 0.0006 0.00060892105102539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '962' AND a.name = n.originalname
491 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '962' AND merchantid = 'A1X6FK5RDHNB96'
492 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '962' AND price > 0
                ORDER BY price ASC LIMIT 1
493 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = 962
                ORDER BY price ASC LIMIT 1
494 0.0002 0.0002439022064209
SELECT value FROM productattributes
                WHERE product_id = '962'
                AND name = 'ListPriceAmount'
495 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '962' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
496 0.0003 0.00030684471130371
SELECT * FROM productimages WHERE product_id = '1318' ORDER BY sortorder ASC
497 0.0005 0.00047206878662109
SELECT * FROM product_image_select WHERE product_id = '1318'
498 0.0003 0.00026893615722656
SELECT * FROM productcustomimages WHERE product_id = '1318'
499 0.0006 0.00061583518981934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1318' AND a.name = n.originalname
500 0.0003 0.0003058910369873
SELECT * FROM productoffers WHERE product_id = '1318' AND merchantid = 'A1X6FK5RDHNB96'
501 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '1318' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = 1318
                ORDER BY price ASC LIMIT 1
503 0.0002 0.00024104118347168
SELECT value FROM productattributes
                WHERE product_id = '1318'
                AND name = 'ListPriceAmount'
504 0.0003 0.0002589225769043
SELECT value FROM productattributes WHERE product_id = '1318' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
505 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
506 0.0005 0.00045299530029297
SELECT * FROM product_image_select WHERE product_id = '864'
507 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '864'
508 0.0006 0.00062799453735352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
509 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
510 0.0002 0.00024509429931641
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
511 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
512 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
513 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
514 0.0003 0.00032591819763184
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
515 0.0004 0.00044488906860352
SELECT * FROM product_image_select WHERE product_id = '854'
516 0.0003 0.00026392936706543
SELECT * FROM productcustomimages WHERE product_id = '854'
517 0.0006 0.00063204765319824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
518 0.0004 0.00036382675170898
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
519 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
521 0.0002 0.00023603439331055
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
522 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
523 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '1270' ORDER BY sortorder ASC
524 0.0004 0.00043487548828125
SELECT * FROM product_image_select WHERE product_id = '1270'
525 0.0003 0.00026297569274902
SELECT * FROM productcustomimages WHERE product_id = '1270'
526 0.0007 0.00073814392089844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1270' AND a.name = n.originalname
527 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '1270' AND merchantid = 'A1X6FK5RDHNB96'
528 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '1270' AND price > 0
                ORDER BY price ASC LIMIT 1
529 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = 1270
                ORDER BY price ASC LIMIT 1
530 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '1270'
                AND name = 'ListPriceAmount'
531 0.0003 0.00029683113098145
SELECT value FROM productattributes WHERE product_id = '1270' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
532 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
533 0.0003 0.00031900405883789
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
534 0.0005 0.00045299530029297
SELECT * FROM product_image_select WHERE product_id = '4201'
535 0.0003 0.00028276443481445
SELECT * FROM productcustomimages WHERE product_id = '4201'
536 0.0003 0.00033807754516602
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 = '4201'
                GROUP BY o.product_id
537 0.0004 0.00040912628173828
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     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
538 0.0003 0.00025582313537598
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
539 0.0005 0.00054502487182617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
540 0.0002 0.00023484230041504
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
541 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
542 0.0003 0.00026583671569824
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
543 0.0003 0.0002748966217041
SELECT value FROM productattributes
                WHERE product_id = '4201'
                AND name = 'ListPriceAmount'
544 0.0003 0.00025200843811035
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 = '4201'
                GROUP BY o.product_id
545 0.0005 0.00047183036804199
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     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
546 0.0002 0.00024604797363281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
547 0.0003 0.00031685829162598
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
548 0.0003 0.00026082992553711
SELECT * FROM products WHERE parent_id = '4201'
549 0.0003 0.00032997131347656
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
550 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '3588'
551 0.0003 0.00026082992553711
SELECT * FROM productcustomimages WHERE product_id = '3588'
552 0.0005 0.00052714347839355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
553 0.0004 0.00037384033203125
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
554 0.0003 0.00026607513427734
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
555 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
556 0.0005 0.00045919418334961
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
557 0.0006 0.00055289268493652
SELECT * FROM product_image_select WHERE product_id = '3524'
558 0.0003 0.00028395652770996
SELECT * FROM productcustomimages WHERE product_id = '3524'
559 0.0005 0.00053715705871582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
560 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
561 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
563 0.0004 0.00036001205444336
SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
564 0.0005 0.00054693222045898
SELECT * FROM product_image_select WHERE product_id = '4202'
565 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '4202'
566 0.0005 0.0005490779876709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
567 0.0003 0.00033688545227051
SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
568 0.0003 0.00028204917907715
SELECT * FROM productoffers
                WHERE product_id = '4202' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0004 0.00037193298339844
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
571 0.0004 0.00037980079650879
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
572 0.0005 0.00053501129150391
SELECT * FROM product_image_select WHERE product_id = '3578'
573 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '3578'
574 0.0004 0.00036406517028809
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 = '3578'
                GROUP BY o.product_id
575 0.0005 0.00045084953308105
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
576 0.0003 0.00025510787963867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
577 0.0006 0.00057697296142578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
578 0.0003 0.00029492378234863
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
579 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
580 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
581 0.0003 0.00026607513427734
SELECT value FROM productattributes
                WHERE product_id = '3578'
                AND name = 'ListPriceAmount'
582 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 = '3578'
                GROUP BY o.product_id
583 0.0004 0.00041508674621582
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
584 0.0003 0.00025582313537598
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
585 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0003 0.00030088424682617
SELECT * FROM products WHERE parent_id = '3578'
587 0.0004 0.0003511905670166
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
588 0.0005 0.00047612190246582
SELECT * FROM product_image_select WHERE product_id = '3587'
589 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '3587'
590 0.0005 0.00053215026855469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
591 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
592 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
593 0.0003 0.00026488304138184
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0004 0.00036406517028809
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
595 0.0004 0.00043106079101562
SELECT * FROM product_image_select WHERE product_id = '3525'
596 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '3525'
597 0.0005 0.00047492980957031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
598 0.0004 0.00035214424133301
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
599 0.0002 0.00024509429931641
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
600 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
601 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '867' ORDER BY sortorder ASC
602 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '867'
603 0.0003 0.0002598762512207
SELECT * FROM productcustomimages WHERE product_id = '867'
604 0.0006 0.0006260871887207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '867' AND a.name = n.originalname
605 0.0003 0.0003359317779541
SELECT * FROM productoffers WHERE product_id = '867' AND merchantid = 'A1X6FK5RDHNB96'
606 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '867' AND price > 0
                ORDER BY price ASC LIMIT 1
607 0.0002 0.0002448558807373
SELECT * FROM productoffers
                WHERE product_id = 867
                ORDER BY price ASC LIMIT 1
608 0.0002 0.00024104118347168
SELECT value FROM productattributes
                WHERE product_id = '867'
                AND name = 'ListPriceAmount'
609 0.0003 0.00025582313537598
SELECT value FROM productattributes WHERE product_id = '867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
610 0.0003 0.00031208992004395
SELECT * FROM productimages WHERE product_id = '4570' ORDER BY sortorder ASC
611 0.0004 0.00042390823364258
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4570' AND p.id = pi.product_id ORDER BY pi.sortorder
612 0.0005 0.00048708915710449
SELECT * FROM product_image_select WHERE product_id = '4570'
613 0.0003 0.00027704238891602
SELECT * FROM productcustomimages WHERE product_id = '4570'
614 0.0003 0.00034213066101074
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 = '4570'
                GROUP BY o.product_id
615 0.0004 0.00039982795715332
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     = '4570'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
616 0.0003 0.00026297569274902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4570
617 0.0005 0.00051188468933105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4570' AND a.name = n.originalname
618 0.0003 0.00027012825012207
SELECT * FROM productoffers WHERE product_id = '4570' AND merchantid = 'A1X6FK5RDHNB96'
619 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '4570' AND price > 0
                ORDER BY price ASC LIMIT 1
620 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = 4570
                ORDER BY price ASC LIMIT 1
621 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '4570'
                AND name = 'ListPriceAmount'
622 0.0003 0.00027990341186523
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 = '4570'
                GROUP BY o.product_id
623 0.0004 0.00043487548828125
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     = '4570'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
624 0.0003 0.00026798248291016
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4570
625 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '4570' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0004 0.00043702125549316
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4570'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
627 0.0003 0.00027203559875488
SELECT * FROM products WHERE parent_id = '4570'
628 0.0003 0.00032806396484375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4645' AND a.name = n.originalname
629 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '4645' AND merchantid = 'A1X6FK5RDHNB96'
630 0.0002 0.00024819374084473
SELECT * FROM productoffers
                WHERE product_id = '4645' AND price > 0
                ORDER BY price ASC LIMIT 1
631 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = 4645
                ORDER BY price ASC LIMIT 1
632 0.0002 0.00023102760314941
SELECT value FROM productattributes
                WHERE product_id = '4645'
                AND name = 'ListPriceAmount'
633 0.0004 0.00035285949707031
SELECT * FROM productimages WHERE product_id = '1108' ORDER BY sortorder ASC
634 0.0004 0.00044894218444824
SELECT * FROM product_image_select WHERE product_id = '1108'
635 0.0003 0.0002589225769043
SELECT * FROM productcustomimages WHERE product_id = '1108'
636 0.0006 0.00058889389038086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
637 0.0003 0.00030183792114258
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
638 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
640 0.0002 0.00023603439331055
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
641 0.0003 0.00031280517578125
SELECT value FROM productattributes WHERE product_id = '1108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0004 0.00043201446533203
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
643 0.0005 0.00051379203796387
SELECT * FROM product_image_select WHERE product_id = '1215'
644 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '1215'
645 0.0007 0.00065302848815918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
646 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
647 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
648 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
649 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
650 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '1140'
651 0.0003 0.00025415420532227
SELECT * FROM productcustomimages WHERE product_id = '1140'
652 0.0005 0.00047016143798828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
653 0.0003 0.0003209114074707
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
654 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0003 0.00025177001953125
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '4006' ORDER BY sortorder ASC
657 0.0004 0.00041508674621582
SELECT * FROM product_image_select WHERE product_id = '4006'
658 0.0003 0.00025010108947754
SELECT * FROM productcustomimages WHERE product_id = '4006'
659 0.0005 0.00050806999206543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
660 0.0003 0.00028896331787109
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
661 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
662 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
663 0.0002 0.00023007392883301
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
664 0.0002 0.00024986267089844
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
665 0.0003 0.00029611587524414
SELECT * FROM productimages WHERE product_id = '762' ORDER BY sortorder ASC
666 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '762'
667 0.0003 0.00025510787963867
SELECT * FROM productcustomimages WHERE product_id = '762'
668 0.0006 0.00058794021606445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '762' AND a.name = n.originalname
669 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '762' AND merchantid = 'A1X6FK5RDHNB96'
670 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = '762' AND price > 0
                ORDER BY price ASC LIMIT 1
671 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = 762
                ORDER BY price ASC LIMIT 1
672 0.0002 0.00022196769714355
SELECT value FROM productattributes
                WHERE product_id = '762'
                AND name = 'ListPriceAmount'
673 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '762' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
674 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
675 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '4921'
676 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '4921'
677 0.0008 0.00077199935913086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
678 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
679 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
680 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '2234' ORDER BY sortorder ASC
682 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '2234'
683 0.0002 0.00024795532226562
SELECT * FROM productcustomimages WHERE product_id = '2234'
684 0.0005 0.00048303604125977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2234' AND a.name = n.originalname
685 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '2234' AND merchantid = 'A1X6FK5RDHNB96'
686 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '2234' AND price > 0
                ORDER BY price ASC LIMIT 1
687 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = 2234
                ORDER BY price ASC LIMIT 1
688 0.0002 0.00024199485778809
SELECT value FROM productattributes
                WHERE product_id = '2234'
                AND name = 'ListPriceAmount'
689 0.0002 0.00024199485778809
SELECT value FROM productattributes WHERE product_id = '2234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
690 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '4769' ORDER BY sortorder ASC
691 0.0003 0.00031018257141113
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4769' AND p.id = pi.product_id ORDER BY pi.sortorder
692 0.0004 0.00042510032653809
SELECT * FROM product_image_select WHERE product_id = '4769'
693 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '4769'
694 0.0003 0.00034809112548828
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 = '4769'
                GROUP BY o.product_id
695 0.0004 0.00036191940307617
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     = '4769'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
696 0.0002 0.00023293495178223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4769
697 0.0007 0.00074410438537598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4769' AND a.name = n.originalname
698 0.0002 0.00023984909057617
SELECT * FROM productoffers WHERE product_id = '4769' AND merchantid = 'A1X6FK5RDHNB96'
699 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '4769' AND price > 0
                ORDER BY price ASC LIMIT 1
700 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = 4769
                ORDER BY price ASC LIMIT 1
701 0.0002 0.00023889541625977
SELECT value FROM productattributes
                WHERE product_id = '4769'
                AND name = 'ListPriceAmount'
702 0.0003 0.00025105476379395
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 = '4769'
                GROUP BY o.product_id
703 0.0004 0.00038003921508789
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     = '4769'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
704 0.0002 0.00024008750915527
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4769
705 0.0003 0.00031208992004395
SELECT value FROM productattributes WHERE product_id = '4769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
706 0.0003 0.0002589225769043
SELECT * FROM products WHERE parent_id = '4769'
707 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '1319' ORDER BY sortorder ASC
708 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '1319'
709 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '1319'
710 0.0007 0.00066280364990234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1319' AND a.name = n.originalname
711 0.0003 0.0003058910369873
SELECT * FROM productoffers WHERE product_id = '1319' AND merchantid = 'A1X6FK5RDHNB96'
712 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '1319' AND price > 0
                ORDER BY price ASC LIMIT 1
713 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '1319' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
714 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '1476' ORDER BY sortorder ASC
715 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '1476'
716 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '1476'
717 0.0006 0.00059795379638672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1476' AND a.name = n.originalname
718 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '1476' AND merchantid = 'A1X6FK5RDHNB96'
719 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '1476' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = 1476
                ORDER BY price ASC LIMIT 1
721 0.0003 0.00026607513427734
SELECT value FROM productattributes
                WHERE product_id = '1476'
                AND name = 'ListPriceAmount'
722 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '1476' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
723 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '1349' ORDER BY sortorder ASC
724 0.0004 0.00044512748718262
SELECT * FROM product_image_select WHERE product_id = '1349'
725 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '1349'
726 0.0005 0.00050091743469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1349' AND a.name = n.originalname
727 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1349' AND merchantid = 'A1X6FK5RDHNB96'
728 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '1349' AND price > 0
                ORDER BY price ASC LIMIT 1
729 0.0003 0.0002601146697998
SELECT value FROM productattributes WHERE product_id = '1349' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
730 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
731 0.0006 0.00055980682373047
SELECT * FROM product_image_select WHERE product_id = '2109'
732 0.0003 0.00029516220092773
SELECT * FROM productcustomimages WHERE product_id = '2109'
733 0.0006 0.00060009956359863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
734 0.0003 0.00034618377685547
SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
735 0.0003 0.0002748966217041
SELECT * FROM productoffers
                WHERE product_id = '2109' AND price > 0
                ORDER BY price ASC LIMIT 1
736 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = 2109
                ORDER BY price ASC LIMIT 1
737 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '2109'
                AND name = 'ListPriceAmount'
738 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '2109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
739 0.0004 0.00035190582275391
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
740 0.0003 0.00031590461730957
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
741 0.0003 0.00028491020202637
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
742 0.0133 0.013273954391479
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
743 0.0005 0.00050497055053711
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
744 0.0004 0.00043916702270508
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
745 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 1626
746 0.0003 0.00034403800964355
SELECT * FROM products WHERE id = 4041
747 0.0003 0.00028491020202637
SELECT * FROM products WHERE id = 4312
748 0.0003 0.00027108192443848
SELECT * FROM products WHERE id = 777
749 0.0003 0.00027799606323242
SELECT * FROM products WHERE id = 3881
750 0.0003 0.00030899047851562
SELECT * FROM products WHERE id = 4213
751 0.0003 0.00027298927307129
SELECT * FROM products WHERE id = '1626'
752 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
753 0.0004 0.00043797492980957
SELECT * FROM product_image_select WHERE product_id = '1626'
754 0.0003 0.00030612945556641
SELECT * FROM productcustomimages WHERE product_id = '1626'
755 0.0007 0.00069999694824219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
756 0.0003 0.00034880638122559
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
757 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
758 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
759 0.0003 0.00034213066101074
SELECT * FROM products WHERE id = '4041'
760 0.0003 0.00033116340637207
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
761 0.0006 0.00056290626525879
SELECT * FROM product_image_select WHERE product_id = '4041'
762 0.0003 0.00028610229492188
SELECT * FROM productcustomimages WHERE product_id = '4041'
763 0.0009 0.00085282325744629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
764 0.0003 0.00034213066101074
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
765 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
766 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
767 0.0003 0.00030684471130371
SELECT * FROM products WHERE id = '4312'
768 0.0003 0.00030112266540527
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
769 0.0004 0.00043106079101562
SELECT * FROM product_image_select WHERE product_id = '4312'
770 0.0003 0.00026583671569824
SELECT * FROM productcustomimages WHERE product_id = '4312'
771 0.0007 0.00068092346191406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
772 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
773 0.0003 0.00028800964355469
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
774 0.0003 0.00026392936706543
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
775 0.0003 0.00034189224243164
SELECT * FROM products WHERE id = '777'
776 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
777 0.0005 0.00045180320739746
SELECT * FROM product_image_select WHERE product_id = '777'
778 0.0003 0.00026178359985352
SELECT * FROM productcustomimages WHERE product_id = '777'
779 0.0006 0.0006251335144043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
780 0.0003 0.00030207633972168
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
781 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
782 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
783 0.0003 0.00031399726867676
SELECT * FROM products WHERE id = '3881'
784 0.0004 0.00035619735717773
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
785 0.0004 0.00042390823364258
SELECT * FROM product_image_select WHERE product_id = '3881'
786 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '3881'
787 0.0011 0.0011119842529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
788 0.0004 0.00035285949707031
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
789 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
790 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
791 0.0003 0.00034785270690918
SELECT * FROM products WHERE id = '4213'
792 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
793 0.0004 0.00042510032653809
SELECT * FROM product_image_select WHERE product_id = '4213'
794 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '4213'
795 0.0007 0.00072717666625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
796 0.0004 0.0003969669342041
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
797 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
798 0.0003 0.00031709671020508
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
799 0.0006 0.00056695938110352
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
800 0.0006 0.00057101249694824
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
801 0.0017 0.0016689300537109
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
802 0.0004 0.00043606758117676
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
803 0.0004 0.00040292739868164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
804 0.0005 0.00047993659973145
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
805 0.0004 0.00040698051452637
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'