0
  1. My Store
  2. Tags

Browse Categories

Wait! We have a something for you...

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

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

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5015871524811 379 1.1657 0


No Amazon API Requests Made.


App Debug - Total Time 1.5015871524811 seconds

Number Time From Start Name Description
1 0.32601594924927 Initialise Initialise FSB Function
2 0.33385801315308 App Controller Start Start of the App controller (called before the controller of every page)
3 0.37239503860474 Start of getCategoryListByGroup Function Before first category groups query
4 0.3728301525116 After initial query Before first category groups query
5 0.3728301525116 Get Category List for Group Before the call to getCategoryList function
6 0.37283205986023 Start of GetCategoryList function Start of the function
7 0.37283301353455 Before getting categories Query to get specific category list
8 0.373379945755 After getting categories Query to get specific category list
9 0.373379945755 Before getting category custom Before call to function getCategoryCustom
10 0.38885998725891 After getting category custom After call to function getCategoryCustom
11 0.38886213302612 Before getting category custom Before call to function getCategoryCustom
12 0.39937496185303 After getting category custom After call to function getCategoryCustom
13 0.39937806129456 Before getting category custom Before call to function getCategoryCustom
14 0.40522813796997 After getting category custom After call to function getCategoryCustom
15 0.4052300453186 Before getting category custom Before call to function getCategoryCustom
16 0.409588098526 After getting category custom After call to function getCategoryCustom
17 0.40959000587463 Before getting category custom Before call to function getCategoryCustom
18 0.41397309303284 After getting category custom After call to function getCategoryCustom
19 0.41397404670715 Before getting category custom Before call to function getCategoryCustom
20 0.41859793663025 After getting category custom After call to function getCategoryCustom
21 0.41859912872314 End of GetCategoryList function End of the function
22 0.41860294342041 Get Category List for Group Before the call to getCategoryList function
23 0.41860413551331 Start of GetCategoryList function Start of the function
24 0.41860508918762 Before getting categories Query to get specific category list
25 0.41904211044312 End of getCategoryListByGroup Function Before return()
26 1.2309830188751 App Controller End End of the App controller (called before the controller of every page)
27 1.4406039714813 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.4413599967957 Before Get Options Before the call to getOptions in the tpl class
29 1.4898729324341 After Get Options After the call to getOptions in the tpl class
30 1.4899079799652 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.5015790462494 Finalizing debug Before the debug is output to the page.
32 1.5015859603882 End of App This is the end of the app logging, final timestamp


Query Debug - 379 Database Queries. Total time 1.1657 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021800994873047 
SELECT parameter, value FROM parameters
2 0.0018 0.0017721652984619 
SELECT * FROM `bad_bots`
3 0.0003 0.00025820732116699 
SET time_zone = 'Europe/London'
4 0.0005 0.00045919418334961 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0005 0.00054311752319336 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.149.120\";}'
6 0.0004 0.00043892860412598 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747088394'
7 0.0010 0.0010371208190918 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059294700622559 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0008 0.00075602531433105 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
10 0.0009 0.00090789794921875 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
11 0.0007 0.00066304206848145 
SELECT id FROM ebay_products WHERE pagename = 'tag'
12 0.0007 0.00065493583679199 
SELECT id FROM custom_products WHERE pagename = 'tag'
13 0.0007 0.00072789192199707 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
14 0.0008 0.00078797340393066 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
15 0.0007 0.00074315071105957 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
16 0.0016 0.0016260147094727 
SELECT id FROM tags WHERE pagename = 'picerie' LIMIT 1
17 0.0033 0.003309965133667 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
18 0.0343 0.034252882003784 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
19 0.0006 0.00056195259094238 
SELECT * FROM pages WHERE pagename = 'tag'
20 0.0004 0.00043010711669922 
SELECT * FROM categorygroups ORDER BY sortorder ASC
21 0.0005 0.00053596496582031 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
22 0.0058 0.0058119297027588 
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
23 0.0007 0.00070691108703613 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
24 0.0004 0.00038695335388184 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
25 0.0005 0.00051188468933105 
SELECT id FROM categories WHERE parent_id = '26'
26 0.0059 0.0058751106262207 
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
27 0.0006 0.00055503845214844 
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
28 0.0007 0.00068497657775879 
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
29 0.0005 0.00049614906311035 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
30 0.0004 0.00038814544677734 
SELECT * FROM categorygroups WHERE id = '1'
31 0.0035 0.0035140514373779 
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
32 0.0005 0.00051593780517578 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
33 0.0004 0.00039005279541016 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
34 0.0004 0.00043106079101562 
SELECT id FROM categories WHERE parent_id = '27'
35 0.0037 0.0036849975585938 
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
36 0.0005 0.00049400329589844 
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
37 0.0006 0.00055909156799316 
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
38 0.0005 0.00045895576477051 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
39 0.0004 0.00041317939758301 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0014 0.0013959407806396 
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
41 0.0005 0.00046300888061523 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
42 0.0003 0.00034403800964355 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
43 0.0004 0.00037503242492676 
SELECT id FROM categories WHERE parent_id = '28'
44 0.0014 0.0014309883117676 
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
45 0.0005 0.00046086311340332 
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
46 0.0005 0.00048589706420898 
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
47 0.0004 0.00043010711669922 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
48 0.0004 0.00041103363037109 
SELECT * FROM categorygroups WHERE id = '1'
49 0.0006 0.00060296058654785 
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
50 0.0004 0.0004270076751709 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
51 0.0004 0.00037717819213867 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
52 0.0004 0.00041103363037109 
SELECT id FROM categories WHERE parent_id = '29'
53 0.0007 0.00065088272094727 
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
54 0.0005 0.00047016143798828 
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
55 0.0005 0.00047779083251953 
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
56 0.0005 0.00047087669372559 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
57 0.0004 0.00043702125549316 
SELECT * FROM categorygroups WHERE id = '1'
58 0.0005 0.00052905082702637 
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
59 0.0005 0.00050997734069824 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
60 0.0004 0.0003669261932373 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
61 0.0004 0.00039100646972656 
SELECT id FROM categories WHERE parent_id = '30'
62 0.0007 0.00066995620727539 
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
63 0.0005 0.00046110153198242 
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
64 0.0005 0.00050806999206543 
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
65 0.0005 0.00052499771118164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
66 0.0004 0.00040292739868164 
SELECT * FROM categorygroups WHERE id = '1'
67 0.0006 0.00056695938110352 
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
68 0.0004 0.00042486190795898 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
69 0.0006 0.00063085556030273 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
70 0.0006 0.00058293342590332 
SELECT id FROM categories WHERE parent_id = '31'
71 0.0006 0.00060915946960449 
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
72 0.0005 0.00051593780517578 
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
73 0.0005 0.00047183036804199 
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
74 0.0004 0.00042486190795898 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
75 0.0004 0.00037598609924316 
SELECT * FROM categorygroups WHERE id = '1'
76 0.0004 0.00043392181396484 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
77 0.0015 0.0014820098876953 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
78 0.0005 0.00051999092102051 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
79 0.0005 0.00049281120300293 
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
80 0.0004 0.00035405158996582 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
81 0.0010 0.0010271072387695 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
82 0.0008 0.00077295303344727 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
83 0.8051 0.80508685112 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.149.120') >= INET_ATON(ip_start) AND INET_ATON('3.145.149.120') <= INET_ATON(ip_end)
84 0.0011 0.0010631084442139 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
85 0.0005 0.00045990943908691 
SELECT * FROM countryredirects WHERE countrycode = 'US'
86 0.0096 0.0095751285552979 
SELECT * FROM tags WHERE pagename = 'picerie'
87 0.0055 0.0055420398712158 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
88 0.0016 0.0015969276428223 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0009 0.0009150505065918 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
90 0.0208 0.020799875259399 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
91 0.0049 0.0048871040344238 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
92 0.0006 0.00062990188598633 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
93 0.0024 0.002357006072998 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '62' AND hidden = 0 AND enabled = 1  AND 1 = 1
94 0.0094 0.0094280242919922 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '62' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 36, 18
95 0.0007 0.00071406364440918 
SELECT * FROM productimages WHERE product_id = '936' ORDER BY sortorder ASC
96 0.0009 0.00090479850769043 
SELECT * FROM product_image_select WHERE product_id = '936'
97 0.0006 0.00064206123352051 
SELECT * FROM productcustomimages WHERE product_id = '936'
98 0.0019 0.0018751621246338 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '936' AND a.name = n.originalname
99 0.0007 0.00067901611328125 
SELECT * FROM productoffers WHERE product_id = '936' AND merchantid = 'A1X6FK5RDHNB96'
100 0.0005 0.00052809715270996 
SELECT * FROM productoffers
                WHERE product_id = '936' AND price > 0
                ORDER BY price ASC LIMIT 1
101 0.0006 0.00060009956359863 
SELECT value FROM productattributes WHERE product_id = '936' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0008 0.00082302093505859 
SELECT * FROM productimages WHERE product_id = '1245' ORDER BY sortorder ASC
103 0.0011 0.0010561943054199 
SELECT * FROM product_image_select WHERE product_id = '1245'
104 0.0006 0.00057196617126465 
SELECT * FROM productcustomimages WHERE product_id = '1245'
105 0.0019 0.001939058303833 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname
106 0.0010 0.0010280609130859 
SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00049114227294922 
SELECT * FROM productoffers
                WHERE product_id = '1245' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0009 0.00088191032409668 
SELECT value FROM productattributes WHERE product_id = '1245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0009 0.00093197822570801 
SELECT * FROM productimages WHERE product_id = '2210' ORDER BY sortorder ASC
110 0.0008 0.0008080005645752 
SELECT * FROM product_image_select WHERE product_id = '2210'
111 0.0004 0.00043606758117676 
SELECT * FROM productcustomimages WHERE product_id = '2210'
112 0.0013 0.0012969970703125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2210' AND a.name = n.originalname
113 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '2210' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0017 0.0016860961914062 
SELECT * FROM productoffers
                WHERE product_id = '2210' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0017 0.0016679763793945 
SELECT * FROM productoffers
                WHERE product_id = 2210
                ORDER BY price ASC LIMIT 1
116 0.0010 0.0010349750518799 
SELECT value FROM productattributes
                WHERE product_id = '2210'
                AND name = 'ListPriceAmount'
117 0.0032 0.003197193145752 
SELECT value FROM productattributes WHERE product_id = '2210' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0014 0.0013880729675293 
SELECT * FROM productimages WHERE product_id = '1147' ORDER BY sortorder ASC
119 0.0016 0.0016281604766846 
SELECT * FROM product_image_select WHERE product_id = '1147'
120 0.0009 0.00093793869018555 
SELECT * FROM productcustomimages WHERE product_id = '1147'
121 0.0027 0.0027461051940918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1147' AND a.name = n.originalname
122 0.0011 0.0010690689086914 
SELECT * FROM productoffers WHERE product_id = '1147' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0007 0.00069212913513184 
SELECT * FROM productoffers
                WHERE product_id = '1147' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0005 0.00049805641174316 
SELECT * FROM productoffers
                WHERE product_id = 1147
                ORDER BY price ASC LIMIT 1
125 0.0007 0.00069785118103027 
SELECT value FROM productattributes
                WHERE product_id = '1147'
                AND name = 'ListPriceAmount'
126 0.0008 0.00079512596130371 
SELECT value FROM productattributes WHERE product_id = '1147' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0008 0.00083088874816895 
SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
128 0.0011 0.0011379718780518 
SELECT * FROM product_image_select WHERE product_id = '4609'
129 0.0006 0.00064396858215332 
SELECT * FROM productcustomimages WHERE product_id = '4609'
130 0.0017 0.0016679763793945 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
131 0.0009 0.00090599060058594 
SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0010 0.0010139942169189 
SELECT * FROM productoffers
                WHERE product_id = '4609' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0008 0.0007779598236084 
SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00061798095703125 
SELECT * FROM productimages WHERE product_id = '1063' ORDER BY sortorder ASC
135 0.0008 0.00078105926513672 
SELECT * FROM product_image_select WHERE product_id = '1063'
136 0.0005 0.00053095817565918 
SELECT * FROM productcustomimages WHERE product_id = '1063'
137 0.0013 0.0012500286102295 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1063' AND a.name = n.originalname
138 0.0006 0.0006248950958252 
SELECT * FROM productoffers WHERE product_id = '1063' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0004 0.00044393539428711 
SELECT * FROM productoffers
                WHERE product_id = '1063' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0004 0.00039315223693848 
SELECT * FROM productoffers
                WHERE product_id = 1063
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00046205520629883 
SELECT value FROM productattributes
                WHERE product_id = '1063'
                AND name = 'ListPriceAmount'
142 0.0006 0.00057291984558105 
SELECT value FROM productattributes WHERE product_id = '1063' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0007 0.00072002410888672 
SELECT * FROM productimages WHERE product_id = '910' ORDER BY sortorder ASC
144 0.0008 0.00081205368041992 
SELECT * FROM product_image_select WHERE product_id = '910'
145 0.0005 0.00050687789916992 
SELECT * FROM productcustomimages WHERE product_id = '910'
146 0.0016 0.0015888214111328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '910' AND a.name = n.originalname
147 0.0008 0.00078201293945312 
SELECT * FROM productoffers WHERE product_id = '910' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = '910' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = 910
                ORDER BY price ASC LIMIT 1
150 0.0004 0.00040292739868164 
SELECT value FROM productattributes
                WHERE product_id = '910'
                AND name = 'ListPriceAmount'
151 0.0004 0.00038599967956543 
SELECT value FROM productattributes WHERE product_id = '910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00049901008605957 
SELECT * FROM productimages WHERE product_id = '1128' ORDER BY sortorder ASC
153 0.0006 0.00060510635375977 
SELECT * FROM product_image_select WHERE product_id = '1128'
154 0.0004 0.0004270076751709 
SELECT * FROM productcustomimages WHERE product_id = '1128'
155 0.0009 0.00089502334594727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1128' AND a.name = n.originalname
156 0.0005 0.00048494338989258 
SELECT * FROM productoffers WHERE product_id = '1128' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00047898292541504 
SELECT * FROM productoffers
                WHERE product_id = '1128' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00039792060852051 
SELECT * FROM productoffers
                WHERE product_id = 1128
                ORDER BY price ASC LIMIT 1
159 0.0004 0.0004420280456543 
SELECT value FROM productattributes
                WHERE product_id = '1128'
                AND name = 'ListPriceAmount'
160 0.0005 0.00051403045654297 
SELECT value FROM productattributes WHERE product_id = '1128' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00064706802368164 
SELECT * FROM productimages WHERE product_id = '1022' ORDER BY sortorder ASC
162 0.0011 0.0010612010955811 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1022' AND p.id = pi.product_id ORDER BY pi.sortorder
163 0.0006 0.00064492225646973 
SELECT * FROM product_image_select WHERE product_id = '1022'
164 0.0004 0.00043582916259766 
SELECT * FROM productcustomimages WHERE product_id = '1022'
165 0.0008 0.00080108642578125 
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 = '1022'
                GROUP BY o.product_id
166 0.0008 0.00081682205200195 
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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
167 0.0005 0.00049591064453125 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
168 0.0010 0.00096511840820312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1022' AND a.name = n.originalname
169 0.0004 0.00042414665222168 
SELECT * FROM productoffers WHERE product_id = '1022' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = '1022' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = 1022
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00037884712219238 
SELECT value FROM productattributes
                WHERE product_id = '1022'
                AND name = 'ListPriceAmount'
173 0.0006 0.00055313110351562 
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 = '1022'
                GROUP BY o.product_id
174 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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0004 0.00043988227844238 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
176 0.0006 0.00060582160949707 
SELECT value FROM productattributes WHERE product_id = '1022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0009 0.00090980529785156 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1022'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
178 0.0007 0.00071310997009277 
SELECT * FROM productimages WHERE product_id = '1409' ORDER BY sortorder ASC
179 0.0007 0.0006859302520752 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1409' AND p.id = pi.product_id ORDER BY pi.sortorder
180 0.0010 0.0010130405426025 
SELECT * FROM product_image_select WHERE product_id = '1409'
181 0.0011 0.0010731220245361 
SELECT * FROM productcustomimages WHERE product_id = '1409'
182 0.0008 0.00078201293945312 
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 = '1409'
                GROUP BY o.product_id
183 0.0010 0.0010168552398682 
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     = '1409'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
184 0.0005 0.00054192543029785 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1409
185 0.0011 0.0011191368103027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1409' AND a.name = n.originalname
186 0.0004 0.00037097930908203 
SELECT * FROM productoffers WHERE product_id = '1409' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0006 0.00063991546630859 
SELECT * FROM productoffers
                WHERE product_id = '1409' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00046586990356445 
SELECT * FROM productoffers
                WHERE product_id = 1409
                ORDER BY price ASC LIMIT 1
189 0.0006 0.00061678886413574 
SELECT value FROM productattributes
                WHERE product_id = '1409'
                AND name = 'ListPriceAmount'
190 0.0005 0.0005340576171875 
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 = '1409'
                GROUP BY o.product_id
191 0.0007 0.00071310997009277 
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     = '1409'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
192 0.0004 0.00040817260742188 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1409
193 0.0006 0.0006260871887207 
SELECT value FROM productattributes WHERE product_id = '1409' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0007 0.00068402290344238 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1409'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
195 0.0007 0.00067996978759766 
SELECT * FROM productimages WHERE product_id = '1574' ORDER BY sortorder ASC
196 0.0008 0.00079798698425293 
SELECT * FROM product_image_select WHERE product_id = '1574'
197 0.0005 0.00051093101501465 
SELECT * FROM productcustomimages WHERE product_id = '1574'
198 0.0020 0.0019559860229492 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1574' AND a.name = n.originalname
199 0.0009 0.00086188316345215 
SELECT * FROM productoffers WHERE product_id = '1574' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0006 0.00055384635925293 
SELECT * FROM productoffers
                WHERE product_id = '1574' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0006 0.00059103965759277 
SELECT value FROM productattributes WHERE product_id = '1574' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0007 0.00071001052856445 
SELECT * FROM productimages WHERE product_id = '1291' ORDER BY sortorder ASC
203 0.0007 0.00074982643127441 
SELECT * FROM product_image_select WHERE product_id = '1291'
204 0.0005 0.00047683715820312 
SELECT * FROM productcustomimages WHERE product_id = '1291'
205 0.0017 0.0017170906066895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
206 0.0007 0.00072813034057617 
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0006 0.00060796737670898 
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0005 0.00045990943908691 
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
209 0.0006 0.00055313110351562 
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
210 0.0007 0.0006718635559082 
SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0008 0.00080204010009766 
SELECT * FROM productimages WHERE product_id = '4291' ORDER BY sortorder ASC
212 0.0008 0.00081610679626465 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4291' AND p.id = pi.product_id ORDER BY pi.sortorder
213 0.0008 0.00082993507385254 
SELECT * FROM product_image_select WHERE product_id = '4291'
214 0.0005 0.00047516822814941 
SELECT * FROM productcustomimages WHERE product_id = '4291'
215 0.0007 0.00067520141601562 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4291'
                GROUP BY o.product_id
216 0.0009 0.0008540153503418 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
217 0.0005 0.00054717063903809 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
218 0.0021 0.0021071434020996 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4291' AND a.name = n.originalname
219 0.0005 0.00050997734069824 
SELECT * FROM productoffers WHERE product_id = '4291' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0006 0.00056719779968262 
SELECT * FROM productoffers
                WHERE product_id = '4291' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00049901008605957 
SELECT * FROM productoffers
                WHERE product_id = 4291
                ORDER BY price ASC LIMIT 1
222 0.0005 0.00050997734069824 
SELECT value FROM productattributes
                WHERE product_id = '4291'
                AND name = 'ListPriceAmount'
223 0.0006 0.00062394142150879 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4291'
                GROUP BY o.product_id
224 0.0009 0.0008537769317627 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
225 0.0004 0.00043296813964844 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
226 0.0007 0.00067710876464844 
SELECT value FROM productattributes WHERE product_id = '4291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0005 0.00049400329589844 
SELECT * FROM products WHERE parent_id = '4291'
228 0.0005 0.00054407119750977 
SELECT * FROM productimages WHERE product_id = '2852' ORDER BY sortorder ASC
229 0.0005 0.00049304962158203 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2852' AND p.id = pi.product_id ORDER BY pi.sortorder
230 0.0008 0.00076413154602051 
SELECT * FROM product_image_select WHERE product_id = '2852'
231 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '2852'
232 0.0006 0.00061702728271484 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2852'
                GROUP BY o.product_id
233 0.0007 0.00067400932312012 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
234 0.0005 0.00045299530029297 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2852
235 0.0013 0.0012989044189453 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2852' AND a.name = n.originalname
236 0.0004 0.00041294097900391 
SELECT * FROM productoffers WHERE product_id = '2852' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.0003969669342041 
SELECT * FROM productoffers
                WHERE product_id = '2852' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0003 0.00031709671020508 
SELECT * FROM productoffers
                WHERE product_id = 2852
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00037884712219238 
SELECT value FROM productattributes
                WHERE product_id = '2852'
                AND name = 'ListPriceAmount'
240 0.0004 0.00040698051452637 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2852'
                GROUP BY o.product_id
241 0.0008 0.00075507164001465 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
242 0.0004 0.00038814544677734 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2852
243 0.0007 0.00065016746520996 
SELECT value FROM productattributes WHERE product_id = '2852' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0004 0.00038003921508789 
SELECT * FROM products WHERE parent_id = '2852'
245 0.0005 0.00050497055053711 
SELECT * FROM productimages WHERE product_id = '1832' ORDER BY sortorder ASC
246 0.0004 0.00041985511779785 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1832' AND p.id = pi.product_id ORDER BY pi.sortorder
247 0.0006 0.00063991546630859 
SELECT * FROM product_image_select WHERE product_id = '1832'
248 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '1832'
249 0.0006 0.00058603286743164 
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 = '1832'
                GROUP BY o.product_id
250 0.0007 0.00065207481384277 
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
251 0.0006 0.00060606002807617 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
252 0.0012 0.0012328624725342 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname
253 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '1832' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '1832' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0003 0.00028610229492188 
SELECT * FROM productoffers
                WHERE product_id = 1832
                ORDER BY price ASC LIMIT 1
256 0.0004 0.00041294097900391 
SELECT value FROM productattributes
                WHERE product_id = '1832'
                AND name = 'ListPriceAmount'
257 0.0004 0.00041413307189941 
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 = '1832'
                GROUP BY o.product_id
258 0.0007 0.00067496299743652 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
259 0.0004 0.00038504600524902 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
260 0.0007 0.0007169246673584 
SELECT value FROM productattributes WHERE product_id = '1832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0005 0.00045490264892578 
SELECT * FROM products WHERE parent_id = '1832'
262 0.0005 0.0005037784576416 
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
263 0.0008 0.00076413154602051 
SELECT * FROM product_image_select WHERE product_id = '776'
264 0.0004 0.00036907196044922 
SELECT * FROM productcustomimages WHERE product_id = '776'
265 0.0014 0.0014479160308838 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
266 0.0006 0.00061798095703125 
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
267 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
268 0.0007 0.0006561279296875 
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0011 0.001086950302124 
SELECT * FROM productimages WHERE product_id = '846' ORDER BY sortorder ASC
270 0.0012 0.0012211799621582 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '846' AND p.id = pi.product_id ORDER BY pi.sortorder
271 0.0007 0.00072717666625977 
SELECT * FROM product_image_select WHERE product_id = '846'
272 0.0004 0.00041007995605469 
SELECT * FROM productcustomimages WHERE product_id = '846'
273 0.0006 0.00058817863464355 
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 = '846'
                GROUP BY o.product_id
274 0.0007 0.0007178783416748 
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     = '846'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
275 0.0005 0.00052690505981445 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
276 0.0008 0.00082898139953613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '846' AND a.name = n.originalname
277 0.0004 0.00037002563476562 
SELECT * FROM productoffers WHERE product_id = '846' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0004 0.00039005279541016 
SELECT * FROM productoffers
                WHERE product_id = '846' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = 846
                ORDER BY price ASC LIMIT 1
280 0.0008 0.00082612037658691 
SELECT value FROM productattributes
                WHERE product_id = '846'
                AND name = 'ListPriceAmount'
281 0.0006 0.00064587593078613 
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 = '846'
                GROUP BY o.product_id
282 0.0007 0.0007331371307373 
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     = '846'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
283 0.0006 0.00056695938110352 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
284 0.0005 0.00052499771118164 
SELECT value FROM productattributes WHERE product_id = '846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0009 0.00088787078857422 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '846'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
286 0.0009 0.00086688995361328 
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
287 0.0007 0.00068378448486328 
SELECT * FROM product_image_select WHERE product_id = '1669'
288 0.0008 0.00078797340393066 
SELECT * FROM productcustomimages WHERE product_id = '1669'
289 0.0012 0.0011639595031738 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
290 0.0004 0.00044894218444824 
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0003 0.00033116340637207 
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
293 0.0004 0.00035786628723145 
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
294 0.0005 0.00046610832214355 
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0005 0.00049400329589844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '936' ORDER BY timestamp DESC
296 0.0003 0.00025796890258789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1245' ORDER BY timestamp DESC
297 0.0002 0.00024199485778809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2210' ORDER BY timestamp DESC
298 0.0002 0.00023293495178223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1147' ORDER BY timestamp DESC
299 0.0002 0.00022792816162109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4609' ORDER BY timestamp DESC
300 0.0002 0.00022792816162109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1063' ORDER BY timestamp DESC
301 0.0002 0.00022983551025391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '910' ORDER BY timestamp DESC
302 0.0002 0.00022506713867188 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1128' ORDER BY timestamp DESC
303 0.0002 0.00023508071899414 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1022' ORDER BY timestamp DESC
304 0.0002 0.00022220611572266 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1409' ORDER BY timestamp DESC
305 0.0002 0.00022506713867188 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1574' ORDER BY timestamp DESC
306 0.0002 0.00022101402282715 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1291' ORDER BY timestamp DESC
307 0.0003 0.0002589225769043 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4291' ORDER BY timestamp DESC
308 0.0002 0.0002288818359375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2852' ORDER BY timestamp DESC
309 0.0002 0.00023198127746582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1832' ORDER BY timestamp DESC
310 0.0003 0.00026607513427734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '776' ORDER BY timestamp DESC
311 0.0002 0.00023412704467773 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '846' ORDER BY timestamp DESC
312 0.0002 0.00023412704467773 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1669' ORDER BY timestamp DESC
313 0.0005 0.00046586990356445 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
314 0.0004 0.00043082237243652 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
315 0.0003 0.0002899169921875 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
316 0.0137 0.013696193695068 
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
317 0.0008 0.00082898139953613 
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
318 0.0006 0.00062322616577148 
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
319 0.0006 0.00058197975158691 
SELECT * FROM products WHERE id = 1626
320 0.0003 0.00034689903259277 
SELECT * FROM products WHERE id = 4041
321 0.0003 0.00034689903259277 
SELECT * FROM products WHERE id = 4312
322 0.0004 0.00036287307739258 
SELECT * FROM products WHERE id = 777
323 0.0003 0.00034904479980469 
SELECT * FROM products WHERE id = 3881
324 0.0004 0.0003509521484375 
SELECT * FROM products WHERE id = 4213
325 0.0003 0.00034499168395996 
SELECT * FROM products WHERE id = '1626'
326 0.0005 0.00048208236694336 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
327 0.0007 0.0006558895111084 
SELECT * FROM product_image_select WHERE product_id = '1626'
328 0.0005 0.00049495697021484 
SELECT * FROM productcustomimages WHERE product_id = '1626'
329 0.0009 0.0008690357208252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
330 0.0005 0.00045084953308105 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0004 0.00041103363037109 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0006 0.00055098533630371 
SELECT * FROM products WHERE id = '4041'
334 0.0004 0.0004429817199707 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
335 0.0006 0.00058484077453613 
SELECT * FROM product_image_select WHERE product_id = '4041'
336 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '4041'
337 0.0011 0.001107931137085 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
338 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0004 0.00043106079101562 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0005 0.00049996376037598 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0005 0.00049686431884766 
SELECT * FROM products WHERE id = '4312'
342 0.0004 0.00041890144348145 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
343 0.0006 0.00062298774719238 
SELECT * FROM product_image_select WHERE product_id = '4312'
344 0.0004 0.00040507316589355 
SELECT * FROM productcustomimages WHERE product_id = '4312'
345 0.0010 0.0010221004486084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
346 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0004 0.00041580200195312 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0004 0.00043797492980957 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0005 0.00049114227294922 
SELECT * FROM products WHERE id = '777'
350 0.0005 0.00045514106750488 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
351 0.0006 0.00058889389038086 
SELECT * FROM product_image_select WHERE product_id = '777'
352 0.0004 0.0003819465637207 
SELECT * FROM productcustomimages WHERE product_id = '777'
353 0.0010 0.00099897384643555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
354 0.0005 0.00046610832214355 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0004 0.00042009353637695 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0004 0.00040793418884277 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0005 0.00052714347839355 
SELECT * FROM products WHERE id = '3881'
358 0.0005 0.00052905082702637 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
359 0.0006 0.00059700012207031 
SELECT * FROM product_image_select WHERE product_id = '3881'
360 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '3881'
361 0.0011 0.0010569095611572 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
362 0.0005 0.00046586990356445 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
363 0.0004 0.0003969669342041 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
364 0.0005 0.00054693222045898 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0005 0.00053906440734863 
SELECT * FROM products WHERE id = '4213'
366 0.0005 0.0005490779876709 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
367 0.0006 0.00059008598327637 
SELECT * FROM product_image_select WHERE product_id = '4213'
368 0.0004 0.00039219856262207 
SELECT * FROM productcustomimages WHERE product_id = '4213'
369 0.0012 0.001183032989502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
370 0.0005 0.00051498413085938 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
371 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
372 0.0004 0.00043797492980957 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373 0.0007 0.00074911117553711 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
374 0.0006 0.00061607360839844 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
375 0.0014 0.0014419555664062 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
376 0.0007 0.0006721019744873 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
377 0.0006 0.00055289268493652 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
378 0.0005 0.00051999092102051 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
379 0.0005 0.00051593780517578 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'