0
  1. My Store
  2. Tags
  3. Pour

Pour

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.771152973175 375 1.1323 0


No Amazon API Requests Made.


App Debug - Total Time 1.771152973175 seconds

Number Time From Start Name Description
1 0.50790286064148 Initialise Initialise FSB Function
2 0.52535200119019 App Controller Start Start of the App controller (called before the controller of every page)
3 0.5525369644165 Start of getCategoryListByGroup Function Before first category groups query
4 0.55391001701355 After initial query Before first category groups query
5 0.55391097068787 Get Category List for Group Before the call to getCategoryList function
6 0.55391383171082 Start of GetCategoryList function Start of the function
7 0.55391693115234 Before getting categories Query to get specific category list
8 0.55445885658264 After getting categories Query to get specific category list
9 0.55445885658264 Before getting category custom Before call to function getCategoryCustom
10 0.57172083854675 After getting category custom After call to function getCategoryCustom
11 0.57172799110413 Before getting category custom Before call to function getCategoryCustom
12 0.58331799507141 After getting category custom After call to function getCategoryCustom
13 0.58332085609436 Before getting category custom Before call to function getCategoryCustom
14 0.5892128944397 After getting category custom After call to function getCategoryCustom
15 0.58921480178833 Before getting category custom Before call to function getCategoryCustom
16 0.59364581108093 After getting category custom After call to function getCategoryCustom
17 0.59364795684814 Before getting category custom Before call to function getCategoryCustom
18 0.59840989112854 After getting category custom After call to function getCategoryCustom
19 0.59841179847717 Before getting category custom Before call to function getCategoryCustom
20 0.6034619808197 After getting category custom After call to function getCategoryCustom
21 0.60346388816833 End of GetCategoryList function End of the function
22 0.60346794128418 Get Category List for Group Before the call to getCategoryList function
23 0.6034688949585 Start of GetCategoryList function Start of the function
24 0.60346984863281 Before getting categories Query to get specific category list
25 0.60397481918335 End of getCategoryListByGroup Function Before return()
26 1.3479549884796 App Controller End End of the App controller (called before the controller of every page)
27 1.5903308391571 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5919058322906 Before Get Options Before the call to getOptions in the tpl class
29 1.6676139831543 After Get Options After the call to getOptions in the tpl class
30 1.6676528453827 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.7711389064789 Finalizing debug Before the debug is output to the page.
32 1.7711520195007 End of App This is the end of the app logging, final timestamp


Query Debug - 375 Database Queries. Total time 1.1323 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0023360252380371 
SELECT parameter, value FROM parameters
2 0.0111 0.011121988296509 
SELECT * FROM `bad_bots`
3 0.0005 0.00046706199645996 
SET time_zone = 'Europe/London'
4 0.0015 0.0014598369598389 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015621185302734 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.143.115.168\";}'
6 0.0013 0.0012979507446289 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747045308'
7 0.0030 0.002979040145874 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00049686431884766 
UPDATE autorun SET lastrun = '2025-05-12 10:21:48' WHERE id = '16'
9 0.0006 0.00063204765319824 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0023 0.002310037612915 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0028 0.0027918815612793 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0026 0.0025730133056641 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0017 0.0017468929290771 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0017 0.0016539096832275 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0016 0.0016169548034668 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0016 0.0016281604766846 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0017 0.0017330646514893 
SELECT id FROM tags WHERE pagename = 'pour' LIMIT 1
18 0.0026 0.0025761127471924 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0235 0.02347207069397 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0006 0.00058603286743164 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0014 0.0013589859008789 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0005 0.00052905082702637 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0062 0.0061769485473633 
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
24 0.0006 0.00058102607727051 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0012 0.0011820793151855 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0005 0.00045013427734375 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0056 0.0055510997772217 
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
28 0.0006 0.00060510635375977 
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
29 0.0005 0.00053501129150391 
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
30 0.0016 0.0016398429870605 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0004 0.00043392181396484 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0038 0.0038471221923828 
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
33 0.0007 0.00067400932312012 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0005 0.00054407119750977 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0006 0.00062894821166992 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0039 0.0039219856262207 
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
37 0.0005 0.0004878044128418 
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
38 0.0005 0.00052094459533691 
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
39 0.0005 0.0004730224609375 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0004 0.00043296813964844 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0014 0.0013802051544189 
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
42 0.0005 0.00046014785766602 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0004 0.00040006637573242 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0004 0.00040793418884277 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0015 0.0014569759368896 
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
46 0.0004 0.00043511390686035 
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
47 0.0005 0.00049495697021484 
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
48 0.0004 0.00042510032653809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0004 0.0003809928894043 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00053501129150391 
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
51 0.0004 0.00044488906860352 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
52 0.0004 0.00035500526428223 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0004 0.00037598609924316 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0007 0.00073385238647461 
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
55 0.0005 0.00046491622924805 
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
56 0.0006 0.00058484077453613 
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
57 0.0005 0.00045990943908691 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0004 0.00041818618774414 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0007 0.00066900253295898 
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
60 0.0005 0.00047683715820312 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0005 0.00048398971557617 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0004 0.00041508674621582 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0006 0.00064897537231445 
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
64 0.0005 0.00053000450134277 
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
65 0.0006 0.00057101249694824 
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
66 0.0005 0.00045299530029297 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0005 0.00046992301940918 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0007 0.000701904296875 
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
69 0.0006 0.00055885314941406 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0004 0.00043296813964844 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0005 0.00047087669372559 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0009 0.00085783004760742 
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
73 0.0005 0.00054407119750977 
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
74 0.0005 0.00053000450134277 
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
75 0.0005 0.00048398971557617 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0004 0.00043892860412598 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0005 0.00049901008605957 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0020 0.0019819736480713 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0022 0.0022079944610596 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0017 0.0017421245574951 
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
81 0.0014 0.00140380859375 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0011 0.0010850429534912 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0009 0.00086116790771484 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.7267 0.72667908668518 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.143.115.168') >= INET_ATON(ip_start) AND INET_ATON('3.143.115.168') <= INET_ATON(ip_end)
85 0.0020 0.0019710063934326 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0011 0.0011441707611084 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0093 0.0092699527740479 
SELECT * FROM tags WHERE pagename = 'pour'
88 0.0128 0.012829065322876 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0035 0.0034639835357666 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0026 0.0026330947875977 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0074 0.0074379444122314 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0018 0.0018279552459717 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0006 0.00060391426086426 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0029 0.0029418468475342 
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 = '58' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0056 0.005587100982666 
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 = '58' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 18, 18
96 0.0019 0.0018620491027832 
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
97 0.0020 0.0019638538360596 
SELECT * FROM product_image_select WHERE product_id = '853'
98 0.0021 0.0021021366119385 
SELECT * FROM productcustomimages WHERE product_id = '853'
99 0.0035 0.0035250186920166 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
100 0.0020 0.0019779205322266 
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0005 0.00050902366638184 
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0006 0.00061702728271484 
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0007 0.00066614151000977 
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
104 0.0010 0.0009620189666748 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2498' AND p.id = pi.product_id ORDER BY pi.sortorder
105 0.0008 0.00083589553833008 
SELECT * FROM product_image_select WHERE product_id = '2498'
106 0.0004 0.00044989585876465 
SELECT * FROM productcustomimages WHERE product_id = '2498'
107 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 = '2498'
                GROUP BY o.product_id
108 0.0035 0.0034689903259277 
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0005 0.00051403045654297 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
110 0.0028 0.0027961730957031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
111 0.0007 0.00072288513183594 
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0016 0.0015521049499512 
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0027 0.0026810169219971 
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
114 0.0027 0.0026640892028809 
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
115 0.0028 0.0028140544891357 
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 = '2498'
                GROUP BY o.product_id
116 0.0016 0.001643180847168 
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0008 0.00075387954711914 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
118 0.0011 0.0011119842529297 
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0013 0.0012669563293457 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2498'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
120 0.0010 0.00099802017211914 
SELECT * FROM productimages WHERE product_id = '3497' ORDER BY sortorder ASC
121 0.0012 0.0012001991271973 
SELECT * FROM product_image_select WHERE product_id = '3497'
122 0.0008 0.00075292587280273 
SELECT * FROM productcustomimages WHERE product_id = '3497'
123 0.0027 0.0026688575744629 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3497' AND a.name = n.originalname
124 0.0008 0.00082683563232422 
SELECT * FROM productoffers WHERE product_id = '3497' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0007 0.00066995620727539 
SELECT * FROM productoffers
                WHERE product_id = '3497' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0007 0.00071215629577637 
SELECT value FROM productattributes WHERE product_id = '3497' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0008 0.00076103210449219 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
128 0.0012 0.0012059211730957 
SELECT * FROM product_image_select WHERE product_id = '1626'
129 0.0007 0.00073099136352539 
SELECT * FROM productcustomimages WHERE product_id = '1626'
130 0.0013 0.0013020038604736 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
131 0.0007 0.00070691108703613 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.00057792663574219 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0007 0.00072717666625977 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0008 0.00080299377441406 
SELECT * FROM productimages WHERE product_id = '3555' ORDER BY sortorder ASC
135 0.0009 0.00092911720275879 
SELECT * FROM product_image_select WHERE product_id = '3555'
136 0.0005 0.00049209594726562 
SELECT * FROM productcustomimages WHERE product_id = '3555'
137 0.0015 0.0015389919281006 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3555' AND a.name = n.originalname
138 0.0006 0.00063109397888184 
SELECT * FROM productoffers WHERE product_id = '3555' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0006 0.00055885314941406 
SELECT * FROM productoffers
                WHERE product_id = '3555' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0007 0.00066900253295898 
SELECT value FROM productattributes WHERE product_id = '3555' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0008 0.00082087516784668 
SELECT * FROM productimages WHERE product_id = '3662' ORDER BY sortorder ASC
142 0.0009 0.00094294548034668 
SELECT * FROM product_image_select WHERE product_id = '3662'
143 0.0005 0.00045084953308105 
SELECT * FROM productcustomimages WHERE product_id = '3662'
144 0.0016 0.0015780925750732 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3662' AND a.name = n.originalname
145 0.0006 0.0006110668182373 
SELECT * FROM productoffers WHERE product_id = '3662' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00050592422485352 
SELECT * FROM productoffers
                WHERE product_id = '3662' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0006 0.00055694580078125 
SELECT value FROM productattributes WHERE product_id = '3662' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0007 0.00067615509033203 
SELECT * FROM productimages WHERE product_id = '3535' ORDER BY sortorder ASC
149 0.0009 0.00087904930114746 
SELECT * FROM product_image_select WHERE product_id = '3535'
150 0.0005 0.00051021575927734 
SELECT * FROM productcustomimages WHERE product_id = '3535'
151 0.0015 0.0015499591827393 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3535' AND a.name = n.originalname
152 0.0006 0.00058293342590332 
SELECT * FROM productoffers WHERE product_id = '3535' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '3535' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00039792060852051 
SELECT * FROM productoffers
                WHERE product_id = 3535
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00051021575927734 
SELECT value FROM productattributes
                WHERE product_id = '3535'
                AND name = 'ListPriceAmount'
156 0.0006 0.00056695938110352 
SELECT value FROM productattributes WHERE product_id = '3535' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0005 0.00046896934509277 
SELECT * FROM productimages WHERE product_id = '2841' ORDER BY sortorder ASC
158 0.0006 0.00064492225646973 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2841' AND p.id = pi.product_id ORDER BY pi.sortorder
159 0.0006 0.00063300132751465 
SELECT * FROM product_image_select WHERE product_id = '2841'
160 0.0005 0.00046515464782715 
SELECT * FROM productcustomimages WHERE product_id = '2841'
161 0.0006 0.0005791187286377 
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 = '2841'
                GROUP BY o.product_id
162 0.0008 0.00078606605529785 
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     = '2841'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
163 0.0005 0.00049304962158203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2841
164 0.0009 0.00090885162353516 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2841' AND a.name = n.originalname
165 0.0004 0.0004279613494873 
SELECT * FROM productoffers WHERE product_id = '2841' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0004 0.00041890144348145 
SELECT * FROM productoffers
                WHERE product_id = '2841' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00033712387084961 
SELECT * FROM productoffers
                WHERE product_id = 2841
                ORDER BY price ASC LIMIT 1
168 0.0004 0.0003960132598877 
SELECT value FROM productattributes
                WHERE product_id = '2841'
                AND name = 'ListPriceAmount'
169 0.0005 0.00046515464782715 
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 = '2841'
                GROUP BY o.product_id
170 0.0007 0.0007169246673584 
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     = '2841'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
171 0.0005 0.00047588348388672 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2841
172 0.0005 0.00054502487182617 
SELECT value FROM productattributes WHERE product_id = '2841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0007 0.0006721019744873 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2841'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
174 0.0005 0.00052690505981445 
SELECT * FROM productimages WHERE product_id = '4214' ORDER BY sortorder ASC
175 0.0005 0.00053691864013672 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4214' AND p.id = pi.product_id ORDER BY pi.sortorder
176 0.0006 0.00058698654174805 
SELECT * FROM product_image_select WHERE product_id = '4214'
177 0.0003 0.00034689903259277 
SELECT * FROM productcustomimages WHERE product_id = '4214'
178 0.0005 0.00047492980957031 
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 = '4214'
                GROUP BY o.product_id
179 0.0007 0.00069117546081543 
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     = '4214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
180 0.0004 0.00042510032653809 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4214
181 0.0008 0.00081896781921387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4214' AND a.name = n.originalname
182 0.0004 0.00036787986755371 
SELECT * FROM productoffers WHERE product_id = '4214' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00035691261291504 
SELECT * FROM productoffers
                WHERE product_id = '4214' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = 4214
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00043487548828125 
SELECT value FROM productattributes
                WHERE product_id = '4214'
                AND name = 'ListPriceAmount'
186 0.0004 0.00042510032653809 
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 = '4214'
                GROUP BY o.product_id
187 0.0006 0.00061798095703125 
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     = '4214'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
188 0.0004 0.00037097930908203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4214
189 0.0005 0.00049495697021484 
SELECT value FROM productattributes WHERE product_id = '4214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0006 0.00063395500183105 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4214'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
191 0.0004 0.00043511390686035 
SELECT * FROM productimages WHERE product_id = '4142' ORDER BY sortorder ASC
192 0.0005 0.00045895576477051 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4142' AND p.id = pi.product_id ORDER BY pi.sortorder
193 0.0006 0.00061488151550293 
SELECT * FROM product_image_select WHERE product_id = '4142'
194 0.0004 0.00036406517028809 
SELECT * FROM productcustomimages WHERE product_id = '4142'
195 0.0005 0.00048995018005371 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4142'
                GROUP BY o.product_id
196 0.0006 0.00057411193847656 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4142'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0004 0.00037598609924316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4142
198 0.0008 0.00080585479736328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4142' AND a.name = n.originalname
199 0.0003 0.00034809112548828 
SELECT * FROM productoffers WHERE product_id = '4142' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = '4142' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = 4142
                ORDER BY price ASC LIMIT 1
202 0.0004 0.00036096572875977 
SELECT value FROM productattributes
                WHERE product_id = '4142'
                AND name = 'ListPriceAmount'
203 0.0004 0.00036811828613281 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4142'
                GROUP BY o.product_id
204 0.0006 0.00059914588928223 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4142'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
205 0.0004 0.0003969669342041 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4142
206 0.0005 0.00048398971557617 
SELECT value FROM productattributes WHERE product_id = '4142' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0009 0.00085806846618652 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4142'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
208 0.0005 0.00049304962158203 
SELECT * FROM productimages WHERE product_id = '4242' ORDER BY sortorder ASC
209 0.0007 0.00069713592529297 
SELECT * FROM product_image_select WHERE product_id = '4242'
210 0.0009 0.00093603134155273 
SELECT * FROM productcustomimages WHERE product_id = '4242'
211 0.0012 0.0012011528015137 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4242' AND a.name = n.originalname
212 0.0005 0.0004580020904541 
SELECT * FROM productoffers WHERE product_id = '4242' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0004 0.0003509521484375 
SELECT * FROM productoffers
                WHERE product_id = '4242' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 4242
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00039505958557129 
SELECT value FROM productattributes
                WHERE product_id = '4242'
                AND name = 'ListPriceAmount'
216 0.0004 0.00043988227844238 
SELECT value FROM productattributes WHERE product_id = '4242' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0006 0.00061297416687012 
SELECT * FROM productimages WHERE product_id = '4325' ORDER BY sortorder ASC
218 0.0005 0.00049090385437012 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4325' AND p.id = pi.product_id ORDER BY pi.sortorder
219 0.0006 0.00063300132751465 
SELECT * FROM product_image_select WHERE product_id = '4325'
220 0.0004 0.00037193298339844 
SELECT * FROM productcustomimages WHERE product_id = '4325'
221 0.0005 0.00051093101501465 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4325'
                GROUP BY o.product_id
222 0.0006 0.00059914588928223 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4325'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
223 0.0004 0.00043606758117676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4325
224 0.0011 0.001105785369873 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4325' AND a.name = n.originalname
225 0.0003 0.00033998489379883 
SELECT * FROM productoffers WHERE product_id = '4325' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00034689903259277 
SELECT * FROM productoffers
                WHERE product_id = '4325' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00034904479980469 
SELECT * FROM productoffers
                WHERE product_id = 4325
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00042009353637695 
SELECT value FROM productattributes
                WHERE product_id = '4325'
                AND name = 'ListPriceAmount'
229 0.0005 0.00045990943908691 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4325'
                GROUP BY o.product_id
230 0.0006 0.0006258487701416 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4325'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
231 0.0005 0.00047111511230469 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4325
232 0.0005 0.00054216384887695 
SELECT value FROM productattributes WHERE product_id = '4325' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0004 0.00044703483581543 
SELECT * FROM products WHERE parent_id = '4325'
234 0.0005 0.00048112869262695 
SELECT * FROM productimages WHERE product_id = '1938' ORDER BY sortorder ASC
235 0.0006 0.00060701370239258 
SELECT * FROM product_image_select WHERE product_id = '1938'
236 0.0004 0.00038313865661621 
SELECT * FROM productcustomimages WHERE product_id = '1938'
237 0.0009 0.00093579292297363 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1938' AND a.name = n.originalname
238 0.0004 0.00042986869812012 
SELECT * FROM productoffers WHERE product_id = '1938' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '1938' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = 1938
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00039410591125488 
SELECT value FROM productattributes
                WHERE product_id = '1938'
                AND name = 'ListPriceAmount'
242 0.0004 0.00041389465332031 
SELECT value FROM productattributes WHERE product_id = '1938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0005 0.00051617622375488 
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
244 0.0008 0.00078201293945312 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4556' AND p.id = pi.product_id ORDER BY pi.sortorder
245 0.0006 0.00064992904663086 
SELECT * FROM product_image_select WHERE product_id = '4556'
246 0.0004 0.00038886070251465 
SELECT * FROM productcustomimages WHERE product_id = '4556'
247 0.0006 0.00058102607727051 
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 = '4556'
                GROUP BY o.product_id
248 0.0011 0.0010738372802734 
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     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
249 0.0005 0.00045609474182129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
250 0.0008 0.00080490112304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
251 0.0004 0.00036501884460449 
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00033903121948242 
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
254 0.0016 0.0016129016876221 
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
255 0.0005 0.00049781799316406 
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 = '4556'
                GROUP BY o.product_id
256 0.0008 0.00084495544433594 
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     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
257 0.0004 0.0004420280456543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
258 0.0005 0.00054621696472168 
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0007 0.00067782402038574 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
260 0.0006 0.00062203407287598 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
261 0.0005 0.0004580020904541 
SELECT * FROM productimages WHERE product_id = '1458' ORDER BY sortorder ASC
262 0.0007 0.0007171630859375 
SELECT * FROM product_image_select WHERE product_id = '1458'
263 0.0005 0.00045108795166016 
SELECT * FROM productcustomimages WHERE product_id = '1458'
264 0.0010 0.0010378360748291 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1458' AND a.name = n.originalname
265 0.0004 0.00044584274291992 
SELECT * FROM productoffers WHERE product_id = '1458' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0004 0.00038313865661621 
SELECT * FROM productoffers
                WHERE product_id = '1458' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0004 0.00037503242492676 
SELECT value FROM productattributes WHERE product_id = '1458' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0005 0.00048398971557617 
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
269 0.0005 0.00054502487182617 
SELECT * FROM product_image_select WHERE product_id = '764'
270 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '764'
271 0.0010 0.00098609924316406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
272 0.0005 0.0004730224609375 
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0004 0.00037479400634766 
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0004 0.00044894218444824 
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0004 0.00042200088500977 
SELECT * FROM productimages WHERE product_id = '1612' ORDER BY sortorder ASC
276 0.0006 0.00057482719421387 
SELECT * FROM product_image_select WHERE product_id = '1612'
277 0.0004 0.00037622451782227 
SELECT * FROM productcustomimages WHERE product_id = '1612'
278 0.0010 0.0010039806365967 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1612' AND a.name = n.originalname
279 0.0005 0.00047016143798828 
SELECT * FROM productoffers WHERE product_id = '1612' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0007 0.00070786476135254 
SELECT * FROM productoffers
                WHERE product_id = '1612' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0007 0.00074386596679688 
SELECT * FROM productoffers
                WHERE product_id = 1612
                ORDER BY price ASC LIMIT 1
282 0.0006 0.00062799453735352 
SELECT value FROM productattributes
                WHERE product_id = '1612'
                AND name = 'ListPriceAmount'
283 0.0007 0.0007169246673584 
SELECT value FROM productattributes WHERE product_id = '1612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0010 0.0009610652923584 
SELECT * FROM productimages WHERE product_id = '1349' ORDER BY sortorder ASC
285 0.0011 0.0010960102081299 
SELECT * FROM product_image_select WHERE product_id = '1349'
286 0.0009 0.00089311599731445 
SELECT * FROM productcustomimages WHERE product_id = '1349'
287 0.0013 0.0012550354003906 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1349' AND a.name = n.originalname
288 0.0009 0.00087904930114746 
SELECT * FROM productoffers WHERE product_id = '1349' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0006 0.00061988830566406 
SELECT * FROM productoffers
                WHERE product_id = '1349' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0007 0.00069117546081543 
SELECT value FROM productattributes WHERE product_id = '1349' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0018 0.0017890930175781 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '853' ORDER BY timestamp DESC
292 0.0004 0.00035881996154785 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2498' ORDER BY timestamp DESC
293 0.0003 0.00029802322387695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3497' ORDER BY timestamp DESC
294 0.0003 0.00030994415283203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1626' ORDER BY timestamp DESC
295 0.0003 0.0003359317779541 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3555' ORDER BY timestamp DESC
296 0.0004 0.00036501884460449 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3662' ORDER BY timestamp DESC
297 0.0003 0.00031304359436035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3535' ORDER BY timestamp DESC
298 0.0003 0.00028800964355469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2841' ORDER BY timestamp DESC
299 0.0003 0.00027608871459961 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4214' ORDER BY timestamp DESC
300 0.0003 0.00027894973754883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4142' ORDER BY timestamp DESC
301 0.0003 0.00032186508178711 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4242' ORDER BY timestamp DESC
302 0.0004 0.00037097930908203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4325' ORDER BY timestamp DESC
303 0.0005 0.00053501129150391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1938' ORDER BY timestamp DESC
304 0.0005 0.00051999092102051 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
305 0.0005 0.00045204162597656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1458' ORDER BY timestamp DESC
306 0.0003 0.00034904479980469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '764' ORDER BY timestamp DESC
307 0.0003 0.00026988983154297 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1612' ORDER BY timestamp DESC
308 0.0003 0.00031685829162598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1349' ORDER BY timestamp DESC
309 0.0018 0.0018160343170166 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
310 0.0012 0.0011579990386963 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
311 0.0004 0.00037503242492676 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
312 0.0132 0.013203859329224 
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
313 0.0019 0.001945972442627 
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
314 0.0009 0.00094890594482422 
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
315 0.0007 0.00071310997009277 
SELECT * FROM products WHERE id = 1626
316 0.0006 0.00061392784118652 
SELECT * FROM products WHERE id = 4041
317 0.0007 0.00066494941711426 
SELECT * FROM products WHERE id = 4312
318 0.0013 0.0012738704681396 
SELECT * FROM products WHERE id = 777
319 0.0008 0.00082492828369141 
SELECT * FROM products WHERE id = 3881
320 0.0005 0.00052499771118164 
SELECT * FROM products WHERE id = 4213
321 0.0004 0.00040102005004883 
SELECT * FROM products WHERE id = '1626'
322 0.0005 0.00053787231445312 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
323 0.0008 0.00075292587280273 
SELECT * FROM product_image_select WHERE product_id = '1626'
324 0.0005 0.00053000450134277 
SELECT * FROM productcustomimages WHERE product_id = '1626'
325 0.0009 0.00094509124755859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
326 0.0005 0.00051498413085938 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0005 0.0004880428314209 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0005 0.00047993659973145 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0005 0.00049495697021484 
SELECT * FROM products WHERE id = '4041'
330 0.0005 0.00046992301940918 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
331 0.0007 0.00066900253295898 
SELECT * FROM product_image_select WHERE product_id = '4041'
332 0.0004 0.00043487548828125 
SELECT * FROM productcustomimages WHERE product_id = '4041'
333 0.0011 0.0011179447174072 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
334 0.0004 0.00044798851013184 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
335 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
336 0.0005 0.00052285194396973 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0005 0.00051188468933105 
SELECT * FROM products WHERE id = '4312'
338 0.0005 0.00048494338989258 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
339 0.0006 0.00057601928710938 
SELECT * FROM product_image_select WHERE product_id = '4312'
340 0.0004 0.00040507316589355 
SELECT * FROM productcustomimages WHERE product_id = '4312'
341 0.0010 0.0010380744934082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
342 0.0008 0.00077390670776367 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
343 0.0005 0.00045609474182129 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
344 0.0005 0.00050210952758789 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0005 0.00048494338989258 
SELECT * FROM products WHERE id = '777'
346 0.0005 0.00052094459533691 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
347 0.0006 0.0005500316619873 
SELECT * FROM product_image_select WHERE product_id = '777'
348 0.0004 0.00037002563476562 
SELECT * FROM productcustomimages WHERE product_id = '777'
349 0.0010 0.0010209083557129 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
350 0.0004 0.00043296813964844 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
351 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
352 0.0005 0.00047612190246582 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353 0.0012 0.0012149810791016 
SELECT * FROM products WHERE id = '3881'
354 0.0013 0.0013229846954346 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
355 0.0016 0.0015740394592285 
SELECT * FROM product_image_select WHERE product_id = '3881'
356 0.0008 0.00083208084106445 
SELECT * FROM productcustomimages WHERE product_id = '3881'
357 0.0030 0.0029869079589844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
358 0.0010 0.00095796585083008 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
359 0.0008 0.00075316429138184 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
360 0.0010 0.00097012519836426 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
361 0.0011 0.0011250972747803 
SELECT * FROM products WHERE id = '4213'
362 0.0010 0.0010268688201904 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
363 0.0011 0.0011489391326904 
SELECT * FROM product_image_select WHERE product_id = '4213'
364 0.0006 0.00057196617126465 
SELECT * FROM productcustomimages WHERE product_id = '4213'
365 0.0023 0.0022780895233154 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
366 0.0007 0.00069999694824219 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
367 0.0006 0.00060606002807617 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
368 0.0007 0.0007321834564209 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
369 0.0033 0.0032799243927002 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
370 0.0013 0.0013141632080078 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
371 0.0040 0.0040018558502197 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
372 0.0029 0.0028698444366455 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
373 0.0008 0.00075006484985352 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
374 0.0038 0.0037989616394043 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
375 0.0010 0.00095582008361816 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'