0
  1. My Store
  2. All Products

All Products

Browse Categories

Wait! We have a something for you...

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

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

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4611179828644 363 0.9797 0


No Amazon API Requests Made.


App Debug - Total Time 1.4611179828644 seconds

Number Time From Start Name Description
1 0.39084506034851 Initialise Initialise FSB Function
2 0.39362406730652 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44166493415833 Start of getCategoryListByGroup Function Before first category groups query
4 0.44245100021362 After initial query Before first category groups query
5 0.44245195388794 Get Category List for Group Before the call to getCategoryList function
6 0.44245386123657 Start of GetCategoryList function Start of the function
7 0.44245505332947 Before getting categories Query to get specific category list
8 0.44318699836731 After getting categories Query to get specific category list
9 0.44318795204163 Before getting category custom Before call to function getCategoryCustom
10 0.45736289024353 After getting category custom After call to function getCategoryCustom
11 0.45736503601074 Before getting category custom Before call to function getCategoryCustom
12 0.46545004844666 After getting category custom After call to function getCategoryCustom
13 0.46545195579529 Before getting category custom Before call to function getCategoryCustom
14 0.46969485282898 After getting category custom After call to function getCategoryCustom
15 0.46969604492188 Before getting category custom Before call to function getCategoryCustom
16 0.47242903709412 After getting category custom After call to function getCategoryCustom
17 0.47242903709412 Before getting category custom Before call to function getCategoryCustom
18 0.47539091110229 After getting category custom After call to function getCategoryCustom
19 0.47539186477661 Before getting category custom Before call to function getCategoryCustom
20 0.47822904586792 After getting category custom After call to function getCategoryCustom
21 0.47822999954224 End of GetCategoryList function End of the function
22 0.47823405265808 Get Category List for Group Before the call to getCategoryList function
23 0.4782350063324 Start of GetCategoryList function Start of the function
24 0.47823596000671 Before getting categories Query to get specific category list
25 0.47857904434204 End of getCategoryListByGroup Function Before return()
26 1.2292909622192 App Controller End End of the App controller (called before the controller of every page)
27 1.3742790222168 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.3749449253082 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.3755359649658 Before Get Options Before the call to getOptions in the tpl class
30 1.4105849266052 After Get Options After the call to getOptions in the tpl class
31 1.4107270240784 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.4611070156097 Finalizing debug Before the debug is output to the page.
33 1.4611179828644 End of App This is the end of the app logging, final timestamp


Query Debug - 363 Database Queries. Total time 0.9797 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.0013649463653564 
SELECT parameter, value FROM parameters
2 0.0038 0.003849983215332 
SELECT * FROM `bad_bots`
3 0.0003 0.00027012825012207 
SET time_zone = 'Europe/London'
4 0.0014 0.0014159679412842 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.0012469291687012 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.235\";}'
6 0.0014 0.0013799667358398 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750118986'
7 0.0018 0.0018129348754883 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.0004270076751709 
UPDATE autorun SET lastrun = '2025-06-17 00:09:46' WHERE id = '9'
9 0.0005 0.00051403045654297 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0013 0.0013470649719238 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00035905838012695 
SELECT * FROM pages WHERE id = 37
12 0.0029 0.0029399394989014 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0443 0.044338941574097 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.00037908554077148 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0008 0.00078201293945312 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00072193145751953 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0050 0.0049808025360107 
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
18 0.0009 0.000885009765625 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0006 0.00060009956359863 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00027608871459961 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0048 0.0048189163208008 
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
22 0.0008 0.00081992149353027 
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
23 0.0007 0.00071907043457031 
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
24 0.0008 0.00075078010559082 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00027799606323242 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0030078887939453 
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
27 0.0003 0.00031208992004395 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00029706954956055 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00026607513427734 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0030 0.002985954284668 
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
31 0.0003 0.00031805038452148 
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
32 0.0003 0.00032901763916016 
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
33 0.0003 0.00028395652770996 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00025391578674316 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0011301040649414 
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
36 0.0003 0.00028014183044434 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0002 0.00024795532226562 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00025510787963867 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0011 0.0010941028594971 
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
40 0.0003 0.00029802322387695 
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
41 0.0004 0.00035285949707031 
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
42 0.0003 0.0002899169921875 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.0002739429473877 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00035405158996582 
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
45 0.0003 0.00029492378234863 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0002 0.00024199485778809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00027322769165039 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0004 0.00041508674621582 
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
49 0.0003 0.00030398368835449 
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
50 0.0003 0.00030112266540527 
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
51 0.0003 0.00027608871459961 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00025296211242676 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0003 0.00034093856811523 
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
54 0.0004 0.00036501884460449 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00027990341186523 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00035500526428223 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0004 0.00038290023803711 
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
58 0.0003 0.0002899169921875 
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
59 0.0003 0.00029802322387695 
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
60 0.0004 0.00036787986755371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00026321411132812 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00038981437683105 
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
63 0.0003 0.00028491020202637 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0002 0.00024914741516113 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00026416778564453 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0004 0.00042009353637695 
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
67 0.0003 0.00029993057250977 
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
68 0.0003 0.00031614303588867 
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
69 0.0003 0.00031113624572754 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00028395652770996 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00033998489379883 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0017 0.0017440319061279 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00079607963562012 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0003 0.00033783912658691 
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
75 0.0006 0.00063204765319824 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.00090813636779785 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00056004524230957 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7423 0.74230813980103 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.235') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.235') <= INET_ATON(ip_end)
79 0.0013 0.0013070106506348 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0006 0.00062394142150879 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0005 0.00049400329589844 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0047 0.0046591758728027 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0014 0.0013549327850342 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0009 0.00090408325195312 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0045 0.0044839382171631 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0013 0.0013229846954346 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00043106079101562 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0036 0.0035858154296875 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0045 0.0044629573822021 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0012 0.0012149810791016 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0004 0.00039911270141602 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0039 0.0038511753082275 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 288, 18
93 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '1562' ORDER BY sortorder ASC
94 0.0005 0.00046801567077637 
SELECT * FROM product_image_select WHERE product_id = '1562'
95 0.0003 0.00028586387634277 
SELECT * FROM productcustomimages WHERE product_id = '1562'
96 0.0009 0.00088596343994141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1562' AND a.name = n.originalname
97 0.0003 0.00031018257141113 
SELECT * FROM productoffers WHERE product_id = '1562' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0002 0.00024890899658203 
SELECT * FROM productoffers
                WHERE product_id = '1562' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0002 0.00023198127746582 
SELECT * FROM productoffers
                WHERE product_id = 1562
                ORDER BY price ASC LIMIT 1
100 0.0002 0.00024509429931641 
SELECT value FROM productattributes
                WHERE product_id = '1562'
                AND name = 'ListPriceAmount'
101 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '1562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0003 0.00031805038452148 
SELECT * FROM productimages WHERE product_id = '2602' ORDER BY sortorder ASC
103 0.0004 0.00042891502380371 
SELECT * FROM product_image_select WHERE product_id = '2602'
104 0.0003 0.00028610229492188 
SELECT * FROM productcustomimages WHERE product_id = '2602'
105 0.0006 0.00062203407287598 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2602' AND a.name = n.originalname
106 0.0003 0.00030398368835449 
SELECT * FROM productoffers WHERE product_id = '2602' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0003 0.00026988983154297 
SELECT * FROM productoffers
                WHERE product_id = '2602' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00023603439331055 
SELECT * FROM productoffers
                WHERE product_id = 2602
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00025105476379395 
SELECT value FROM productattributes
                WHERE product_id = '2602'
                AND name = 'ListPriceAmount'
110 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '2602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00033187866210938 
SELECT * FROM productimages WHERE product_id = '1849' ORDER BY sortorder ASC
112 0.0005 0.00047087669372559 
SELECT * FROM product_image_select WHERE product_id = '1849'
113 0.0003 0.00026297569274902 
SELECT * FROM productcustomimages WHERE product_id = '1849'
114 0.0008 0.00075197219848633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1849' AND a.name = n.originalname
115 0.0003 0.00030207633972168 
SELECT * FROM productoffers WHERE product_id = '1849' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '1849' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0003 0.00029587745666504 
SELECT value FROM productattributes WHERE product_id = '1849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0003 0.00032687187194824 
SELECT * FROM productimages WHERE product_id = '1302' ORDER BY sortorder ASC
119 0.0004 0.00043606758117676 
SELECT * FROM product_image_select WHERE product_id = '1302'
120 0.0003 0.00025391578674316 
SELECT * FROM productcustomimages WHERE product_id = '1302'
121 0.0006 0.00060200691223145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1302' AND a.name = n.originalname
122 0.0003 0.00028896331787109 
SELECT * FROM productoffers WHERE product_id = '1302' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '1302' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00029993057250977 
SELECT value FROM productattributes WHERE product_id = '1302' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0003 0.00031280517578125 
SELECT * FROM productimages WHERE product_id = '3077' ORDER BY sortorder ASC
126 0.0004 0.0004270076751709 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3077' AND p.id = pi.product_id ORDER BY pi.sortorder
127 0.0005 0.00046706199645996 
SELECT * FROM product_image_select WHERE product_id = '3077'
128 0.0003 0.00026392936706543 
SELECT * FROM productcustomimages WHERE product_id = '3077'
129 0.0003 0.00033783912658691 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3077'
                GROUP BY o.product_id
130 0.0012 0.0011849403381348 
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     = '3077'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
131 0.0003 0.00032186508178711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3077
132 0.0007 0.00065493583679199 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3077' AND a.name = n.originalname
133 0.0002 0.00024008750915527 
SELECT * FROM productoffers WHERE product_id = '3077' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0002 0.00024199485778809 
SELECT * FROM productoffers
                WHERE product_id = '3077' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.0002751350402832 
SELECT * FROM productoffers
                WHERE product_id = 3077
                ORDER BY price ASC LIMIT 1
136 0.0003 0.00025200843811035 
SELECT value FROM productattributes
                WHERE product_id = '3077'
                AND name = 'ListPriceAmount'
137 0.0003 0.00029587745666504 
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 = '3077'
                GROUP BY o.product_id
138 0.0004 0.0004270076751709 
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     = '3077'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
139 0.0003 0.00029802322387695 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3077
140 0.0003 0.00034213066101074 
SELECT value FROM productattributes WHERE product_id = '3077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00039911270141602 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3077'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
142 0.0003 0.00030803680419922 
SELECT * FROM productimages WHERE product_id = '1159' ORDER BY sortorder ASC
143 0.0004 0.00042295455932617 
SELECT * FROM product_image_select WHERE product_id = '1159'
144 0.0002 0.00024795532226562 
SELECT * FROM productcustomimages WHERE product_id = '1159'
145 0.0008 0.00076794624328613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1159' AND a.name = n.originalname
146 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '1159' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = '1159' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '1159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0004 0.00035405158996582 
SELECT * FROM productimages WHERE product_id = '1620' ORDER BY sortorder ASC
150 0.0006 0.0005640983581543 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1620' AND p.id = pi.product_id ORDER BY pi.sortorder
151 0.0004 0.00043106079101562 
SELECT * FROM product_image_select WHERE product_id = '1620'
152 0.0003 0.00026202201843262 
SELECT * FROM productcustomimages WHERE product_id = '1620'
153 0.0003 0.00030803680419922 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1620'
                GROUP BY o.product_id
154 0.0004 0.00038790702819824 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1620'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
155 0.0002 0.00024890899658203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1620
156 0.0005 0.00053191184997559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1620' AND a.name = n.originalname
157 0.0002 0.00023508071899414 
SELECT * FROM productoffers WHERE product_id = '1620' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0002 0.00024008750915527 
SELECT * FROM productoffers
                WHERE product_id = '1620' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00022292137145996 
SELECT * FROM productoffers
                WHERE product_id = 1620
                ORDER BY price ASC LIMIT 1
160 0.0002 0.00024700164794922 
SELECT value FROM productattributes
                WHERE product_id = '1620'
                AND name = 'ListPriceAmount'
161 0.0003 0.00026202201843262 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1620'
                GROUP BY o.product_id
162 0.0004 0.00041484832763672 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1620'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
163 0.0003 0.00026392936706543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1620
164 0.0003 0.00034499168395996 
SELECT value FROM productattributes WHERE product_id = '1620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0007 0.00074005126953125 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1620'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
166 0.0004 0.00040411949157715 
SELECT * FROM productimages WHERE product_id = '3954' ORDER BY sortorder ASC
167 0.0003 0.00026702880859375 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3954' AND p.id = pi.product_id ORDER BY pi.sortorder
168 0.0005 0.00045299530029297 
SELECT * FROM product_image_select WHERE product_id = '3954'
169 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '3954'
170 0.0003 0.00032997131347656 
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 = '3954'
                GROUP BY o.product_id
171 0.0004 0.00036096572875977 
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     = '3954'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
172 0.0003 0.00025701522827148 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3954
173 0.0007 0.00071907043457031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3954' AND a.name = n.originalname
174 0.0003 0.00025200843811035 
SELECT * FROM productoffers WHERE product_id = '3954' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0002 0.00023818016052246 
SELECT * FROM productoffers
                WHERE product_id = '3954' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0002 0.0002288818359375 
SELECT * FROM productoffers
                WHERE product_id = 3954
                ORDER BY price ASC LIMIT 1
177 0.0002 0.0002439022064209 
SELECT value FROM productattributes
                WHERE product_id = '3954'
                AND name = 'ListPriceAmount'
178 0.0002 0.00024795532226562 
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 = '3954'
                GROUP BY o.product_id
179 0.0004 0.00035595893859863 
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     = '3954'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
180 0.0002 0.00023388862609863 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3954
181 0.0003 0.0003359317779541 
SELECT value FROM productattributes WHERE product_id = '3954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0003 0.0002589225769043 
SELECT * FROM products WHERE parent_id = '3954'
183 0.0003 0.00029706954956055 
SELECT * FROM productimages WHERE product_id = '3707' ORDER BY sortorder ASC
184 0.0003 0.00030899047851562 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3707' AND p.id = pi.product_id ORDER BY pi.sortorder
185 0.0004 0.0004432201385498 
SELECT * FROM product_image_select WHERE product_id = '3707'
186 0.0003 0.0002598762512207 
SELECT * FROM productcustomimages WHERE product_id = '3707'
187 0.0003 0.0003349781036377 
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 = '3707'
                GROUP BY o.product_id
188 0.0004 0.00040793418884277 
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     = '3707'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
189 0.0003 0.00026416778564453 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3707
190 0.0005 0.00052499771118164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3707' AND a.name = n.originalname
191 0.0002 0.00024008750915527 
SELECT * FROM productoffers WHERE product_id = '3707' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0002 0.00023317337036133 
SELECT * FROM productoffers
                WHERE product_id = '3707' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0002 0.00022482872009277 
SELECT * FROM productoffers
                WHERE product_id = 3707
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00026607513427734 
SELECT value FROM productattributes
                WHERE product_id = '3707'
                AND name = 'ListPriceAmount'
195 0.0003 0.00026798248291016 
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 = '3707'
                GROUP BY o.product_id
196 0.0004 0.0003960132598877 
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     = '3707'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0003 0.00028300285339355 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3707
198 0.0003 0.00032711029052734 
SELECT value FROM productattributes WHERE product_id = '3707' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0004 0.00035405158996582 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3707'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
200 0.0006 0.00056886672973633 
SELECT * FROM productimages WHERE product_id = '3531' ORDER BY sortorder ASC
201 0.0004 0.00043201446533203 
SELECT * FROM product_image_select WHERE product_id = '3531'
202 0.0003 0.00027203559875488 
SELECT * FROM productcustomimages WHERE product_id = '3531'
203 0.0007 0.00069093704223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3531' AND a.name = n.originalname
204 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '3531' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0002 0.00023889541625977 
SELECT * FROM productoffers
                WHERE product_id = '3531' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0002 0.00022101402282715 
SELECT * FROM productoffers
                WHERE product_id = 3531
                ORDER BY price ASC LIMIT 1
207 0.0002 0.00023984909057617 
SELECT value FROM productattributes
                WHERE product_id = '3531'
                AND name = 'ListPriceAmount'
208 0.0003 0.00031709671020508 
SELECT value FROM productattributes WHERE product_id = '3531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0003 0.00034284591674805 
SELECT * FROM productimages WHERE product_id = '2808' ORDER BY sortorder ASC
210 0.0004 0.00042510032653809 
SELECT * FROM product_image_select WHERE product_id = '2808'
211 0.0003 0.0002748966217041 
SELECT * FROM productcustomimages WHERE product_id = '2808'
212 0.0006 0.00064802169799805 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2808' AND a.name = n.originalname
213 0.0003 0.00030303001403809 
SELECT * FROM productoffers WHERE product_id = '2808' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '2808' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0003 0.00025582313537598 
SELECT value FROM productattributes WHERE product_id = '2808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0003 0.00034999847412109 
SELECT * FROM productimages WHERE product_id = '4766' ORDER BY sortorder ASC
217 0.0004 0.00044798851013184 
SELECT * FROM product_image_select WHERE product_id = '4766'
218 0.0004 0.0003659725189209 
SELECT * FROM productcustomimages WHERE product_id = '4766'
219 0.0007 0.00068092346191406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4766' AND a.name = n.originalname
220 0.0003 0.0003049373626709 
SELECT * FROM productoffers WHERE product_id = '4766' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00025010108947754 
SELECT * FROM productoffers
                WHERE product_id = '4766' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = 4766
                ORDER BY price ASC LIMIT 1
223 0.0003 0.00025010108947754 
SELECT value FROM productattributes
                WHERE product_id = '4766'
                AND name = 'ListPriceAmount'
224 0.0003 0.00027012825012207 
SELECT value FROM productattributes WHERE product_id = '4766' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0003 0.00033807754516602 
SELECT * FROM productimages WHERE product_id = '3554' ORDER BY sortorder ASC
226 0.0004 0.00044393539428711 
SELECT * FROM product_image_select WHERE product_id = '3554'
227 0.0003 0.00025701522827148 
SELECT * FROM productcustomimages WHERE product_id = '3554'
228 0.0006 0.00056290626525879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3554' AND a.name = n.originalname
229 0.0003 0.00029301643371582 
SELECT * FROM productoffers WHERE product_id = '3554' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0002 0.00024199485778809 
SELECT * FROM productoffers
                WHERE product_id = '3554' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0002 0.00022721290588379 
SELECT * FROM productoffers
                WHERE product_id = 3554
                ORDER BY price ASC LIMIT 1
232 0.0002 0.00023889541625977 
SELECT value FROM productattributes
                WHERE product_id = '3554'
                AND name = 'ListPriceAmount'
233 0.0003 0.00025200843811035 
SELECT value FROM productattributes WHERE product_id = '3554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0003 0.00030994415283203 
SELECT * FROM productimages WHERE product_id = '767' ORDER BY sortorder ASC
235 0.0003 0.00033903121948242 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '767' AND p.id = pi.product_id ORDER BY pi.sortorder
236 0.0005 0.00046992301940918 
SELECT * FROM product_image_select WHERE product_id = '767'
237 0.0003 0.00025701522827148 
SELECT * FROM productcustomimages WHERE product_id = '767'
238 0.0003 0.0003349781036377 
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 = '767'
                GROUP BY o.product_id
239 0.0004 0.00041103363037109 
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     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0003 0.00025606155395508 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
241 0.0005 0.0005490779876709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '767' AND a.name = n.originalname
242 0.0002 0.000244140625 
SELECT * FROM productoffers WHERE product_id = '767' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0002 0.00023913383483887 
SELECT * FROM productoffers
                WHERE product_id = '767' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0002 0.00022196769714355 
SELECT * FROM productoffers
                WHERE product_id = 767
                ORDER BY price ASC LIMIT 1
245 0.0002 0.00023818016052246 
SELECT value FROM productattributes
                WHERE product_id = '767'
                AND name = 'ListPriceAmount'
246 0.0003 0.00027203559875488 
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 = '767'
                GROUP BY o.product_id
247 0.0004 0.00039386749267578 
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     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
248 0.0003 0.00025701522827148 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
249 0.0003 0.00034093856811523 
SELECT value FROM productattributes WHERE product_id = '767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0004 0.00037503242492676 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '767'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
251 0.0003 0.00031614303588867 
SELECT * FROM productimages WHERE product_id = '1232' ORDER BY sortorder ASC
252 0.0005 0.00045394897460938 
SELECT * FROM product_image_select WHERE product_id = '1232'
253 0.0003 0.00025606155395508 
SELECT * FROM productcustomimages WHERE product_id = '1232'
254 0.0005 0.0005340576171875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1232' AND a.name = n.originalname
255 0.0003 0.00030612945556641 
SELECT * FROM productoffers WHERE product_id = '1232' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '1232' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.0002739429473877 
SELECT value FROM productattributes WHERE product_id = '1232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0003 0.00034880638122559 
SELECT * FROM productimages WHERE product_id = '2276' ORDER BY sortorder ASC
259 0.0004 0.00042414665222168 
SELECT * FROM product_image_select WHERE product_id = '2276'
260 0.0003 0.00026202201843262 
SELECT * FROM productcustomimages WHERE product_id = '2276'
261 0.0006 0.00059700012207031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2276' AND a.name = n.originalname
262 0.0003 0.00033903121948242 
SELECT * FROM productoffers WHERE product_id = '2276' AND merchantid = 'A1X6FK5RDHNB96'
263 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '2276' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0003 0.00026679039001465 
SELECT value FROM productattributes WHERE product_id = '2276' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0004 0.0004119873046875 
SELECT * FROM productimages WHERE product_id = '2008' ORDER BY sortorder ASC
266 0.0004 0.00043582916259766 
SELECT * FROM product_image_select WHERE product_id = '2008'
267 0.0003 0.00032901763916016 
SELECT * FROM productcustomimages WHERE product_id = '2008'
268 0.0006 0.00059199333190918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2008' AND a.name = n.originalname
269 0.0003 0.00032711029052734 
SELECT * FROM productoffers WHERE product_id = '2008' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = '2008' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00027799606323242 
SELECT value FROM productattributes WHERE product_id = '2008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0003 0.00028300285339355 
SELECT * FROM productimages WHERE product_id = '1164' ORDER BY sortorder ASC
273 0.0004 0.00043392181396484 
SELECT * FROM product_image_select WHERE product_id = '1164'
274 0.0003 0.00026583671569824 
SELECT * FROM productcustomimages WHERE product_id = '1164'
275 0.0006 0.00062203407287598 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1164' AND a.name = n.originalname
276 0.0003 0.00030899047851562 
SELECT * FROM productoffers WHERE product_id = '1164' AND merchantid = 'A1X6FK5RDHNB96'
277 0.0002 0.00024914741516113 
SELECT * FROM productoffers
                WHERE product_id = '1164' AND price > 0
                ORDER BY price ASC LIMIT 1
278 0.0003 0.00028610229492188 
SELECT value FROM productattributes WHERE product_id = '1164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0003 0.00028800964355469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1562' ORDER BY timestamp DESC
280 0.0002 0.00021100044250488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2602' ORDER BY timestamp DESC
281 0.0002 0.0002288818359375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1849' ORDER BY timestamp DESC
282 0.0002 0.00019717216491699 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1302' ORDER BY timestamp DESC
283 0.0002 0.00020098686218262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3077' ORDER BY timestamp DESC
284 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1159' ORDER BY timestamp DESC
285 0.0002 0.00020098686218262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1620' ORDER BY timestamp DESC
286 0.0002 0.00020098686218262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3954' ORDER BY timestamp DESC
287 0.0002 0.00019311904907227 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3707' ORDER BY timestamp DESC
288 0.0002 0.00019407272338867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3531' ORDER BY timestamp DESC
289 0.0002 0.00023484230041504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2808' ORDER BY timestamp DESC
290 0.0002 0.00019693374633789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4766' ORDER BY timestamp DESC
291 0.0002 0.00019288063049316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3554' ORDER BY timestamp DESC
292 0.0002 0.00019407272338867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '767' ORDER BY timestamp DESC
293 0.0002 0.00019717216491699 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1232' ORDER BY timestamp DESC
294 0.0002 0.00019598007202148 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2276' ORDER BY timestamp DESC
295 0.0002 0.0001981258392334 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2008' ORDER BY timestamp DESC
296 0.0002 0.00019407272338867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1164' ORDER BY timestamp DESC
297 0.0003 0.00032210350036621 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
298 0.0003 0.00031304359436035 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
299 0.0002 0.00023794174194336 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
300 0.0110 0.010961055755615 
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
301 0.0004 0.00038886070251465 
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
302 0.0003 0.00034689903259277 
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
303 0.0003 0.00031805038452148 
SELECT * FROM products WHERE id = 1626
304 0.0003 0.00025701522827148 
SELECT * FROM products WHERE id = 4041
305 0.0002 0.00024580955505371 
SELECT * FROM products WHERE id = 4312
306 0.0002 0.00023603439331055 
SELECT * FROM products WHERE id = 777
307 0.0002 0.00023818016052246 
SELECT * FROM products WHERE id = 3881
308 0.0003 0.00030207633972168 
SELECT * FROM products WHERE id = 4213
309 0.0002 0.00024914741516113 
SELECT * FROM products WHERE id = '1626'
310 0.0003 0.0003058910369873 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
311 0.0004 0.00044703483581543 
SELECT * FROM product_image_select WHERE product_id = '1626'
312 0.0003 0.00025415420532227 
SELECT * FROM productcustomimages WHERE product_id = '1626'
313 0.0005 0.00052499771118164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
314 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0003 0.00026082992553711 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0003 0.00031614303588867 
SELECT * FROM products WHERE id = '4041'
318 0.0003 0.00029706954956055 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
319 0.0004 0.00041604042053223 
SELECT * FROM product_image_select WHERE product_id = '4041'
320 0.0002 0.00024580955505371 
SELECT * FROM productcustomimages WHERE product_id = '4041'
321 0.0006 0.00064611434936523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
322 0.0003 0.00031304359436035 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0003 0.00025081634521484 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0003 0.00026297569274902 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0003 0.00030684471130371 
SELECT * FROM products WHERE id = '4312'
326 0.0003 0.00028014183044434 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
327 0.0004 0.00041890144348145 
SELECT * FROM product_image_select WHERE product_id = '4312'
328 0.0002 0.000244140625 
SELECT * FROM productcustomimages WHERE product_id = '4312'
329 0.0006 0.00060105323791504 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
330 0.0003 0.00028896331787109 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0003 0.0002598762512207 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0003 0.00025606155395508 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0003 0.00033807754516602 
SELECT * FROM products WHERE id = '777'
334 0.0003 0.00029897689819336 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
335 0.0004 0.00042104721069336 
SELECT * FROM product_image_select WHERE product_id = '777'
336 0.0003 0.00026917457580566 
SELECT * FROM productcustomimages WHERE product_id = '777'
337 0.0007 0.00069093704223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
338 0.0003 0.00029802322387695 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0003 0.00030612945556641 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0003 0.00034618377685547 
SELECT * FROM products WHERE id = '3881'
342 0.0003 0.00034999847412109 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
343 0.0004 0.00043106079101562 
SELECT * FROM product_image_select WHERE product_id = '3881'
344 0.0003 0.0002598762512207 
SELECT * FROM productcustomimages WHERE product_id = '3881'
345 0.0006 0.00064682960510254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
346 0.0003 0.00031280517578125 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0003 0.0003359317779541 
SELECT * FROM products WHERE id = '4213'
350 0.0004 0.00037598609924316 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
351 0.0004 0.00042390823364258 
SELECT * FROM product_image_select WHERE product_id = '4213'
352 0.0003 0.00026202201843262 
SELECT * FROM productcustomimages WHERE product_id = '4213'
353 0.0007 0.00069499015808105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
354 0.0003 0.0003049373626709 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0003 0.00026178359985352 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0003 0.00028896331787109 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0006 0.00055480003356934 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
358 0.0004 0.00044798851013184 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
359 0.0024 0.0023910999298096 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
360 0.0004 0.00042104721069336 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
361 0.0003 0.00033688545227051 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
362 0.0004 0.00037217140197754 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
363 0.0004 0.00041604042053223 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'