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.8957829475403 374 1.4008 0


No Amazon API Requests Made.


App Debug - Total Time 1.8957829475403 seconds

Number Time From Start Name Description
1 0.46634602546692 Initialise Initialise FSB Function
2 0.46944808959961 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50180292129517 Start of getCategoryListByGroup Function Before first category groups query
4 0.50428700447083 After initial query Before first category groups query
5 0.50428795814514 Get Category List for Group Before the call to getCategoryList function
6 0.50429105758667 Start of GetCategoryList function Start of the function
7 0.5042929649353 Before getting categories Query to get specific category list
8 0.50713801383972 After getting categories Query to get specific category list
9 0.50713896751404 Before getting category custom Before call to function getCategoryCustom
10 0.53322601318359 After getting category custom After call to function getCategoryCustom
11 0.53322887420654 Before getting category custom Before call to function getCategoryCustom
12 0.54607605934143 After getting category custom After call to function getCategoryCustom
13 0.54607892036438 Before getting category custom Before call to function getCategoryCustom
14 0.55463600158691 After getting category custom After call to function getCategoryCustom
15 0.55463886260986 Before getting category custom Before call to function getCategoryCustom
16 0.56043601036072 After getting category custom After call to function getCategoryCustom
17 0.56043791770935 Before getting category custom Before call to function getCategoryCustom
18 0.56569194793701 After getting category custom After call to function getCategoryCustom
19 0.56569385528564 Before getting category custom Before call to function getCategoryCustom
20 0.57158994674683 After getting category custom After call to function getCategoryCustom
21 0.57159304618835 End of GetCategoryList function End of the function
22 0.57159900665283 Get Category List for Group Before the call to getCategoryList function
23 0.57159996032715 Start of GetCategoryList function Start of the function
24 0.57160186767578 Before getting categories Query to get specific category list
25 0.57215905189514 End of getCategoryListByGroup Function Before return()
26 1.5093410015106 App Controller End End of the App controller (called before the controller of every page)
27 1.7634649276733 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.7655780315399 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.7670660018921 Before Get Options Before the call to getOptions in the tpl class
30 1.856899023056 After Get Options After the call to getOptions in the tpl class
31 1.8570439815521 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.8957710266113 Finalizing debug Before the debug is output to the page.
33 1.895781993866 End of App This is the end of the app logging, final timestamp


Query Debug - 374 Database Queries. Total time 1.4008 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015439987182617 
SELECT parameter, value FROM parameters
2 0.0093 0.0092840194702148 
SELECT * FROM `bad_bots`
3 0.0004 0.00043201446533203 
SET time_zone = 'Europe/London'
4 0.0029 0.0029101371765137 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0040 0.0040450096130371 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.14.79.99\";}'
6 0.0113 0.01125693321228 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746379601'
7 0.0021 0.0020959377288818 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00051999092102051 
UPDATE autorun SET lastrun = '2025-05-04 17:26:41' WHERE id = '15'
9 0.0005 0.00048184394836426 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0017 0.0016708374023438 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00041699409484863 
SELECT * FROM pages WHERE id = 37
12 0.0028 0.0028030872344971 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0284 0.028351783752441 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00081586837768555 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0025 0.0024740695953369 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0028 0.0028250217437744 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0085 0.0084519386291504 
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.0027 0.0026938915252686 
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.0015 0.0015239715576172 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00058293342590332 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0066 0.006572961807251 
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.0021 0.0021049976348877 
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.0019 0.0018749237060547 
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.0017 0.001662015914917 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00050592422485352 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0042 0.0042281150817871 
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.0007 0.00067019462585449 
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.0005 0.00049400329589844 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00044989585876465 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0047 0.004741907119751 
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.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 (27)
				  AND p.disabled = 0
32 0.0006 0.00056695938110352 
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.0005 0.00053095817565918 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.0004889965057373 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0018 0.0017988681793213 
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.0008 0.00077509880065918 
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.0005 0.00052499771118164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00054192543029785 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0023 0.0022921562194824 
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.0006 0.00063300132751465 
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.0007 0.00067901611328125 
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.0007 0.00065779685974121 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00056791305541992 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00064396858215332 
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.0009 0.00087881088256836 
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.0005 0.00053691864013672 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00064802169799805 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00070905685424805 
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.0005 0.00050497055053711 
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.0006 0.00056791305541992 
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.0007 0.00072598457336426 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00051498413085938 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00070595741271973 
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.0005 0.00048208236694336 
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.0004 0.00043606758117676 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00045299530029297 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.0009300708770752 
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.0005 0.00053906440734863 
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.0005 0.0005340576171875 
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.0006 0.00063896179199219 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00048303604125977 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00072407722473145 
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.0006 0.00056695938110352 
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.0006 0.00060105323791504 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00057697296142578 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00084114074707031 
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.0005 0.00053906440734863 
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.0006 0.00060415267944336 
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.0007 0.00074100494384766 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00063109397888184 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00054693222045898 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0033 0.0032880306243896 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0019 0.0018579959869385 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00066494941711426 
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.0021 0.0020549297332764 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0013580322265625 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0009 0.00094699859619141 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.9176 0.91764187812805 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.14.79.99') >= INET_ATON(ip_start) AND INET_ATON('3.14.79.99') <= INET_ATON(ip_end)
79 0.0021 0.0021450519561768 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0012161731719971 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00073385238647461 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0066 0.0066139698028564 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0025 0.0025238990783691 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0112 0.011152982711792 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0098 0.0097928047180176 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0026 0.0025858879089355 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0008 0.00077295303344727 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0065 0.0064878463745117 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0066 0.0065531730651855 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0018 0.0017518997192383 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00047898292541504 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0071 0.0071008205413818 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 864, 18
93 0.0210 0.02095890045166 
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
94 0.0028 0.0027539730072021 
SELECT * FROM product_image_select WHERE product_id = '4904'
95 0.0019 0.001906156539917 
SELECT * FROM productcustomimages WHERE product_id = '4904'
96 0.0033 0.0032598972320557 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
97 0.0022 0.0021731853485107 
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00046086311340332 
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0008 0.00077700614929199 
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0013 0.0012879371643066 
SELECT * FROM productimages WHERE product_id = '1937' ORDER BY sortorder ASC
101 0.0007 0.00074505805969238 
SELECT * FROM product_image_select WHERE product_id = '1937'
102 0.0005 0.00046491622924805 
SELECT * FROM productcustomimages WHERE product_id = '1937'
103 0.0013 0.0012948513031006 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1937' AND a.name = n.originalname
104 0.0005 0.00052595138549805 
SELECT * FROM productoffers WHERE product_id = '1937' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0009 0.00088095664978027 
SELECT * FROM productoffers
                WHERE product_id = '1937' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0006 0.00061488151550293 
SELECT * FROM productoffers
                WHERE product_id = 1937
                ORDER BY price ASC LIMIT 1
107 0.0007 0.00071406364440918 
SELECT value FROM productattributes
                WHERE product_id = '1937'
                AND name = 'ListPriceAmount'
108 0.0008 0.00080609321594238 
SELECT value FROM productattributes WHERE product_id = '1937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0009 0.00087499618530273 
SELECT * FROM productimages WHERE product_id = '1939' ORDER BY sortorder ASC
110 0.0011 0.0010890960693359 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1939' AND p.id = pi.product_id ORDER BY pi.sortorder
111 0.0013 0.0013430118560791 
SELECT * FROM product_image_select WHERE product_id = '1939'
112 0.0007 0.00071501731872559 
SELECT * FROM productcustomimages WHERE product_id = '1939'
113 0.0010 0.00099611282348633 
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 = '1939'
                GROUP BY o.product_id
114 0.0064 0.0064129829406738 
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     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
115 0.0008 0.00081706047058105 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
116 0.0106 0.010560035705566 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1939' AND a.name = n.originalname
117 0.0007 0.0007469654083252 
SELECT * FROM productoffers WHERE product_id = '1939' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0006 0.00064992904663086 
SELECT * FROM productoffers
                WHERE product_id = '1939' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0006 0.00058388710021973 
SELECT * FROM productoffers
                WHERE product_id = 1939
                ORDER BY price ASC LIMIT 1
120 0.0007 0.00067591667175293 
SELECT value FROM productattributes
                WHERE product_id = '1939'
                AND name = 'ListPriceAmount'
121 0.0007 0.00074887275695801 
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 = '1939'
                GROUP BY o.product_id
122 0.0012 0.0012469291687012 
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     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
123 0.0007 0.00066709518432617 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
124 0.0011 0.0011289119720459 
SELECT value FROM productattributes WHERE product_id = '1939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0007 0.0006861686706543 
SELECT * FROM products WHERE parent_id = '1939'
126 0.0032 0.003242015838623 
SELECT * FROM productimages WHERE product_id = '1993' ORDER BY sortorder ASC
127 0.0011 0.0011229515075684 
SELECT * FROM product_image_select WHERE product_id = '1993'
128 0.0006 0.00061893463134766 
SELECT * FROM productcustomimages WHERE product_id = '1993'
129 0.0019 0.0019350051879883 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1993' AND a.name = n.originalname
130 0.0008 0.00078201293945312 
SELECT * FROM productoffers WHERE product_id = '1993' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.00054001808166504 
SELECT * FROM productoffers
                WHERE product_id = '1993' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00049614906311035 
SELECT * FROM productoffers
                WHERE product_id = 1993
                ORDER BY price ASC LIMIT 1
133 0.0007 0.00066709518432617 
SELECT value FROM productattributes
                WHERE product_id = '1993'
                AND name = 'ListPriceAmount'
134 0.0006 0.00064396858215332 
SELECT value FROM productattributes WHERE product_id = '1993' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0012 0.0012309551239014 
SELECT * FROM productimages WHERE product_id = '1943' ORDER BY sortorder ASC
136 0.0011 0.0010550022125244 
SELECT * FROM product_image_select WHERE product_id = '1943'
137 0.0005 0.00054502487182617 
SELECT * FROM productcustomimages WHERE product_id = '1943'
138 0.0015 0.0015461444854736 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1943' AND a.name = n.originalname
139 0.0007 0.00066685676574707 
SELECT * FROM productoffers WHERE product_id = '1943' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.00058078765869141 
SELECT * FROM productoffers
                WHERE product_id = '1943' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00048494338989258 
SELECT * FROM productoffers
                WHERE product_id = 1943
                ORDER BY price ASC LIMIT 1
142 0.0006 0.0005640983581543 
SELECT value FROM productattributes
                WHERE product_id = '1943'
                AND name = 'ListPriceAmount'
143 0.0006 0.00062203407287598 
SELECT value FROM productattributes WHERE product_id = '1943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0010 0.00098586082458496 
SELECT * FROM productimages WHERE product_id = '1945' ORDER BY sortorder ASC
145 0.0010 0.00096487998962402 
SELECT * FROM product_image_select WHERE product_id = '1945'
146 0.0005 0.00054001808166504 
SELECT * FROM productcustomimages WHERE product_id = '1945'
147 0.0016 0.0015640258789062 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1945' AND a.name = n.originalname
148 0.0008 0.00077199935913086 
SELECT * FROM productoffers WHERE product_id = '1945' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0005 0.00045514106750488 
SELECT * FROM productoffers
                WHERE product_id = '1945' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00053811073303223 
SELECT value FROM productattributes WHERE product_id = '1945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0005 0.00052905082702637 
SELECT * FROM productimages WHERE product_id = '2017' ORDER BY sortorder ASC
152 0.0008 0.00075793266296387 
SELECT * FROM product_image_select WHERE product_id = '2017'
153 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '2017'
154 0.0009 0.00094699859619141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2017' AND a.name = n.originalname
155 0.0006 0.00057506561279297 
SELECT * FROM productoffers WHERE product_id = '2017' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0004 0.00041580200195312 
SELECT * FROM productoffers
                WHERE product_id = '2017' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = 2017
                ORDER BY price ASC LIMIT 1
158 0.0005 0.0004570484161377 
SELECT value FROM productattributes
                WHERE product_id = '2017'
                AND name = 'ListPriceAmount'
159 0.0005 0.0004880428314209 
SELECT value FROM productattributes WHERE product_id = '2017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '2249' ORDER BY sortorder ASC
161 0.0008 0.00075888633728027 
SELECT * FROM product_image_select WHERE product_id = '2249'
162 0.0005 0.00045299530029297 
SELECT * FROM productcustomimages WHERE product_id = '2249'
163 0.0012 0.001230001449585 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2249' AND a.name = n.originalname
164 0.0005 0.00046300888061523 
SELECT * FROM productoffers WHERE product_id = '2249' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0004 0.00037288665771484 
SELECT * FROM productoffers
                WHERE product_id = '2249' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0003 0.0003211498260498 
SELECT * FROM productoffers
                WHERE product_id = 2249
                ORDER BY price ASC LIMIT 1
167 0.0004 0.0003669261932373 
SELECT value FROM productattributes
                WHERE product_id = '2249'
                AND name = 'ListPriceAmount'
168 0.0004 0.00042009353637695 
SELECT value FROM productattributes WHERE product_id = '2249' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0007 0.00066900253295898 
SELECT * FROM productimages WHERE product_id = '2014' ORDER BY sortorder ASC
170 0.0006 0.00059294700622559 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2014' AND p.id = pi.product_id ORDER BY pi.sortorder
171 0.0006 0.00060892105102539 
SELECT * FROM product_image_select WHERE product_id = '2014'
172 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '2014'
173 0.0006 0.00056219100952148 
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 = '2014'
                GROUP BY o.product_id
174 0.0007 0.00069808959960938 
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     = '2014'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0004 0.00044608116149902 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2014
176 0.0009 0.00090694427490234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2014' AND a.name = n.originalname
177 0.0004 0.00039792060852051 
SELECT * FROM productoffers WHERE product_id = '2014' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '2014' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = 2014
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00035810470581055 
SELECT value FROM productattributes
                WHERE product_id = '2014'
                AND name = 'ListPriceAmount'
181 0.0004 0.00044894218444824 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2014'
                GROUP BY o.product_id
182 0.0006 0.00061511993408203 
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     = '2014'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
183 0.0004 0.00037288665771484 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2014
184 0.0005 0.00051784515380859 
SELECT value FROM productattributes WHERE product_id = '2014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0044 0.004364013671875 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2014'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'ItemDisplayHeight'
                GROUP BY o.value
                ORDER BY o.value ASC
186 0.0004 0.00039482116699219 
SELECT * FROM products WHERE parent_id = '2014'
187 0.0005 0.00053095817565918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2015' AND a.name = n.originalname
188 0.0004 0.00044512748718262 
SELECT * FROM productoffers WHERE product_id = '2015' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = '2015' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0003 0.00032496452331543 
SELECT * FROM productoffers
                WHERE product_id = 2015
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00033020973205566 
SELECT value FROM productattributes
                WHERE product_id = '2015'
                AND name = 'ListPriceAmount'
192 0.0020 0.0020310878753662 
SELECT * FROM productimages WHERE product_id = '2023' ORDER BY sortorder ASC
193 0.0006 0.0005800724029541 
SELECT * FROM product_image_select WHERE product_id = '2023'
194 0.0004 0.00037407875061035 
SELECT * FROM productcustomimages WHERE product_id = '2023'
195 0.0007 0.00072407722473145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2023' AND a.name = n.originalname
196 0.0005 0.00053501129150391 
SELECT * FROM productoffers WHERE product_id = '2023' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '2023' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = 2023
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00043106079101562 
SELECT value FROM productattributes
                WHERE product_id = '2023'
                AND name = 'ListPriceAmount'
200 0.0005 0.00046586990356445 
SELECT value FROM productattributes WHERE product_id = '2023' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0005 0.00053310394287109 
SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
202 0.0007 0.00071597099304199 
SELECT * FROM product_image_select WHERE product_id = '2021'
203 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '2021'
204 0.0012 0.0012378692626953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
205 0.0005 0.00053095817565918 
SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0005 0.00047802925109863 
SELECT * FROM productoffers
                WHERE product_id = '2021' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00044798851013184 
SELECT * FROM productoffers
                WHERE product_id = 2021
                ORDER BY price ASC LIMIT 1
208 0.0004 0.00042891502380371 
SELECT value FROM productattributes
                WHERE product_id = '2021'
                AND name = 'ListPriceAmount'
209 0.0005 0.00052094459533691 
SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0008 0.00080704689025879 
SELECT * FROM productimages WHERE product_id = '2024' ORDER BY sortorder ASC
211 0.0008 0.00084400177001953 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2024' AND p.id = pi.product_id ORDER BY pi.sortorder
212 0.0007 0.00070500373840332 
SELECT * FROM product_image_select WHERE product_id = '2024'
213 0.0004 0.00042605400085449 
SELECT * FROM productcustomimages WHERE product_id = '2024'
214 0.0005 0.00054383277893066 
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 = '2024'
                GROUP BY o.product_id
215 0.0007 0.00070309638977051 
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     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
216 0.0005 0.00046491622924805 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2024
217 0.0009 0.00089406967163086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2024' AND a.name = n.originalname
218 0.0004 0.00038385391235352 
SELECT * FROM productoffers WHERE product_id = '2024' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00039792060852051 
SELECT * FROM productoffers
                WHERE product_id = '2024' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00040912628173828 
SELECT * FROM productoffers
                WHERE product_id = 2024
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00045990943908691 
SELECT value FROM productattributes
                WHERE product_id = '2024'
                AND name = 'ListPriceAmount'
222 0.0005 0.0004727840423584 
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 = '2024'
                GROUP BY o.product_id
223 0.0007 0.00068092346191406 
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     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
224 0.0004 0.0004119873046875 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2024
225 0.0005 0.00054812431335449 
SELECT value FROM productattributes WHERE product_id = '2024' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00058913230895996 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
227 0.0005 0.00050902366638184 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
228 0.0004 0.00041103363037109 
SELECT * FROM products WHERE parent_id = '2024'
229 0.0006 0.00062108039855957 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2846' AND a.name = n.originalname
230 0.0005 0.00048089027404785 
SELECT * FROM productoffers WHERE product_id = '2846' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00039505958557129 
SELECT * FROM productoffers
                WHERE product_id = '2846' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0011 0.0010519027709961 
SELECT * FROM productimages WHERE product_id = '2241' ORDER BY sortorder ASC
233 0.0006 0.00056910514831543 
SELECT * FROM product_image_select WHERE product_id = '2241'
234 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '2241'
235 0.0008 0.00076508522033691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2241' AND a.name = n.originalname
236 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '2241' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00037217140197754 
SELECT * FROM productoffers
                WHERE product_id = '2241' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = 2241
                ORDER BY price ASC LIMIT 1
239 0.0003 0.00034189224243164 
SELECT value FROM productattributes
                WHERE product_id = '2241'
                AND name = 'ListPriceAmount'
240 0.0004 0.0003819465637207 
SELECT value FROM productattributes WHERE product_id = '2241' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0034 0.0034148693084717 
SELECT * FROM productimages WHERE product_id = '2134' ORDER BY sortorder ASC
242 0.0006 0.00063920021057129 
SELECT * FROM product_image_select WHERE product_id = '2134'
243 0.0004 0.00037503242492676 
SELECT * FROM productcustomimages WHERE product_id = '2134'
244 0.0007 0.00068902969360352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2134' AND a.name = n.originalname
245 0.0005 0.00045609474182129 
SELECT * FROM productoffers WHERE product_id = '2134' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00038313865661621 
SELECT * FROM productoffers
                WHERE product_id = '2134' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0003 0.00034284591674805 
SELECT * FROM productoffers
                WHERE product_id = 2134
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00035500526428223 
SELECT value FROM productattributes
                WHERE product_id = '2134'
                AND name = 'ListPriceAmount'
249 0.0004 0.00037980079650879 
SELECT value FROM productattributes WHERE product_id = '2134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0031 0.0031487941741943 
SELECT * FROM productimages WHERE product_id = '2074' ORDER BY sortorder ASC
251 0.0008 0.00079989433288574 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2074' AND p.id = pi.product_id ORDER BY pi.sortorder
252 0.0006 0.00060582160949707 
SELECT * FROM product_image_select WHERE product_id = '2074'
253 0.0009 0.00088691711425781 
SELECT * FROM productcustomimages WHERE product_id = '2074'
254 0.0005 0.00054597854614258 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2074'
                GROUP BY o.product_id
255 0.0007 0.00070285797119141 
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     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
256 0.0005 0.00048494338989258 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
257 0.0009 0.00085616111755371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2074' AND a.name = n.originalname
258 0.0004 0.00043392181396484 
SELECT * FROM productoffers WHERE product_id = '2074' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00040912628173828 
SELECT * FROM productoffers
                WHERE product_id = '2074' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0003 0.00033998489379883 
SELECT * FROM productoffers
                WHERE product_id = 2074
                ORDER BY price ASC LIMIT 1
261 0.0004 0.00039982795715332 
SELECT value FROM productattributes
                WHERE product_id = '2074'
                AND name = 'ListPriceAmount'
262 0.0005 0.00045013427734375 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2074'
                GROUP BY o.product_id
263 0.0009 0.00088906288146973 
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     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
264 0.0004 0.00044894218444824 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
265 0.0006 0.00058698654174805 
SELECT value FROM productattributes WHERE product_id = '2074' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0007 0.00072193145751953 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2074'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
267 0.0007 0.00065088272094727 
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
268 0.0007 0.00069904327392578 
SELECT * FROM product_image_select WHERE product_id = '2521'
269 0.0004 0.00042009353637695 
SELECT * FROM productcustomimages WHERE product_id = '2521'
270 0.0010 0.0010080337524414 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
271 0.0006 0.00059819221496582 
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0005 0.00047588348388672 
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0005 0.00052595138549805 
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0005 0.0005030632019043 
SELECT * FROM productimages WHERE product_id = '2100' ORDER BY sortorder ASC
275 0.0007 0.00070309638977051 
SELECT * FROM product_image_select WHERE product_id = '2100'
276 0.0005 0.0005180835723877 
SELECT * FROM productcustomimages WHERE product_id = '2100'
277 0.0008 0.00078392028808594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2100' AND a.name = n.originalname
278 0.0005 0.00046110153198242 
SELECT * FROM productoffers WHERE product_id = '2100' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0003 0.00033712387084961 
SELECT * FROM productoffers
                WHERE product_id = '2100' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00030899047851562 
SELECT * FROM productoffers
                WHERE product_id = 2100
                ORDER BY price ASC LIMIT 1
281 0.0004 0.00035500526428223 
SELECT value FROM productattributes
                WHERE product_id = '2100'
                AND name = 'ListPriceAmount'
282 0.0004 0.00038599967956543 
SELECT value FROM productattributes WHERE product_id = '2100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0007 0.00072407722473145 
SELECT * FROM productimages WHERE product_id = '2102' ORDER BY sortorder ASC
284 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '2102'
285 0.0004 0.00037407875061035 
SELECT * FROM productcustomimages WHERE product_id = '2102'
286 0.0009 0.00085997581481934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2102' AND a.name = n.originalname
287 0.0005 0.00046515464782715 
SELECT * FROM productoffers WHERE product_id = '2102' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = '2102' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0004 0.00042009353637695 
SELECT value FROM productattributes WHERE product_id = '2102' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0016 0.0016279220581055 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
291 0.0003 0.00029516220092773 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1937' ORDER BY timestamp DESC
292 0.0003 0.00026106834411621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1939' ORDER BY timestamp DESC
293 0.0002 0.00024104118347168 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1993' ORDER BY timestamp DESC
294 0.0003 0.00026202201843262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1943' ORDER BY timestamp DESC
295 0.0002 0.000244140625 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1945' ORDER BY timestamp DESC
296 0.0003 0.00029897689819336 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2017' ORDER BY timestamp DESC
297 0.0003 0.00027894973754883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2249' ORDER BY timestamp DESC
298 0.0002 0.00024199485778809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2014' ORDER BY timestamp DESC
299 0.0002 0.00023508071899414 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2023' ORDER BY timestamp DESC
300 0.0002 0.00024890899658203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2021' ORDER BY timestamp DESC
301 0.0002 0.00023293495178223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2024' ORDER BY timestamp DESC
302 0.0002 0.00021910667419434 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2241' ORDER BY timestamp DESC
303 0.0002 0.00024199485778809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2134' ORDER BY timestamp DESC
304 0.0002 0.00022101402282715 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2074' ORDER BY timestamp DESC
305 0.0003 0.00025200843811035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2521' ORDER BY timestamp DESC
306 0.0002 0.00024986267089844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2100' ORDER BY timestamp DESC
307 0.0002 0.00024986267089844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2102' ORDER BY timestamp DESC
308 0.0016 0.001622200012207 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
309 0.0011 0.0011489391326904 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
310 0.0003 0.00029993057250977 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
311 0.0268 0.026848793029785 
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
312 0.0019 0.0018539428710938 
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
313 0.0005 0.00052690505981445 
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
314 0.0005 0.00052309036254883 
SELECT * FROM products WHERE id = 1626
315 0.0003 0.0003209114074707 
SELECT * FROM products WHERE id = 4041
316 0.0003 0.00034499168395996 
SELECT * FROM products WHERE id = 4312
317 0.0003 0.00033187866210938 
SELECT * FROM products WHERE id = 777
318 0.0004 0.00038290023803711 
SELECT * FROM products WHERE id = 3881
319 0.0003 0.00030994415283203 
SELECT * FROM products WHERE id = 4213
320 0.0003 0.00032806396484375 
SELECT * FROM products WHERE id = '1626'
321 0.0004 0.00042510032653809 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
322 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '1626'
323 0.0004 0.00035190582275391 
SELECT * FROM productcustomimages WHERE product_id = '1626'
324 0.0008 0.00079584121704102 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
325 0.0004 0.00042319297790527 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
326 0.0003 0.00030803680419922 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
327 0.0004 0.00041699409484863 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0005 0.00054812431335449 
SELECT * FROM products WHERE id = '4041'
329 0.0004 0.00038981437683105 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
330 0.0005 0.00051498413085938 
SELECT * FROM product_image_select WHERE product_id = '4041'
331 0.0003 0.00034713745117188 
SELECT * FROM productcustomimages WHERE product_id = '4041'
332 0.0013 0.0013089179992676 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
333 0.0004 0.0004119873046875 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
334 0.0004 0.00041103363037109 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
335 0.0005 0.00048017501831055 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336 0.0005 0.00052404403686523 
SELECT * FROM products WHERE id = '4312'
337 0.0005 0.00047492980957031 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
338 0.0006 0.00064301490783691 
SELECT * FROM product_image_select WHERE product_id = '4312'
339 0.0004 0.0004119873046875 
SELECT * FROM productcustomimages WHERE product_id = '4312'
340 0.0156 0.015573978424072 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
341 0.0006 0.00061988830566406 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
342 0.0004 0.00043916702270508 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
343 0.0005 0.00049901008605957 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0006 0.00056695938110352 
SELECT * FROM products WHERE id = '777'
345 0.0005 0.00053882598876953 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
346 0.0007 0.00069093704223633 
SELECT * FROM product_image_select WHERE product_id = '777'
347 0.0005 0.00045919418334961 
SELECT * FROM productcustomimages WHERE product_id = '777'
348 0.0020 0.0019791126251221 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
349 0.0006 0.00055313110351562 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
350 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
351 0.0005 0.00049114227294922 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352 0.0006 0.00060009956359863 
SELECT * FROM products WHERE id = '3881'
353 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
354 0.0006 0.00062012672424316 
SELECT * FROM product_image_select WHERE product_id = '3881'
355 0.0004 0.00040411949157715 
SELECT * FROM productcustomimages WHERE product_id = '3881'
356 0.0030 0.0029568672180176 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
357 0.0005 0.00052690505981445 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
358 0.0004 0.00042605400085449 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
359 0.0005 0.00049996376037598 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0006 0.00058412551879883 
SELECT * FROM products WHERE id = '4213'
361 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
362 0.0007 0.00065398216247559 
SELECT * FROM product_image_select WHERE product_id = '4213'
363 0.0004 0.00041484832763672 
SELECT * FROM productcustomimages WHERE product_id = '4213'
364 0.0015 0.0014760494232178 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
365 0.0005 0.00050806999206543 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
366 0.0004 0.00040578842163086 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
367 0.0005 0.00048708915710449 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0031 0.003101110458374 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
369 0.0008 0.0007929801940918 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
370 0.0043 0.0042898654937744 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
371 0.0035 0.0034699440002441 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
372 0.0006 0.00058889389038086 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
373 0.0007 0.00066304206848145 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
374 0.0005 0.00053119659423828 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'