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.4573850631714 379 1.0664 0


No Amazon API Requests Made.


App Debug - Total Time 1.4573850631714 seconds

Number Time From Start Name Description
1 0.36350297927856 Initialise Initialise FSB Function
2 0.36547803878784 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38820910453796 Start of getCategoryListByGroup Function Before first category groups query
4 0.38907694816589 After initial query Before first category groups query
5 0.38907814025879 Get Category List for Group Before the call to getCategoryList function
6 0.38907909393311 Start of GetCategoryList function Start of the function
7 0.38908100128174 Before getting categories Query to get specific category list
8 0.3899359703064 After getting categories Query to get specific category list
9 0.38993716239929 Before getting category custom Before call to function getCategoryCustom
10 0.40394616127014 After getting category custom After call to function getCategoryCustom
11 0.40394997596741 Before getting category custom Before call to function getCategoryCustom
12 0.41256618499756 After getting category custom After call to function getCategoryCustom
13 0.41256809234619 Before getting category custom Before call to function getCategoryCustom
14 0.41725611686707 After getting category custom After call to function getCategoryCustom
15 0.41725707054138 Before getting category custom Before call to function getCategoryCustom
16 0.42035818099976 After getting category custom After call to function getCategoryCustom
17 0.42035913467407 Before getting category custom Before call to function getCategoryCustom
18 0.42342495918274 After getting category custom After call to function getCategoryCustom
19 0.42342615127563 Before getting category custom Before call to function getCategoryCustom
20 0.42663598060608 After getting category custom After call to function getCategoryCustom
21 0.42663812637329 End of GetCategoryList function End of the function
22 0.42664217948914 Get Category List for Group Before the call to getCategoryList function
23 0.42664313316345 Start of GetCategoryList function Start of the function
24 0.42664408683777 Before getting categories Query to get specific category list
25 0.42697811126709 End of getCategoryListByGroup Function Before return()
26 1.2741391658783 App Controller End End of the App controller (called before the controller of every page)
27 1.3852860927582 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.3865649700165 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.3875160217285 Before Get Options Before the call to getOptions in the tpl class
30 1.428013086319 After Get Options After the call to getOptions in the tpl class
31 1.4281320571899 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.4573781490326 Finalizing debug Before the debug is output to the page.
33 1.4573850631714 End of App This is the end of the app logging, final timestamp


Query Debug - 379 Database Queries. Total time 1.0664 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010030269622803 
SELECT parameter, value FROM parameters
2 0.0036 0.0035750865936279 
SELECT * FROM `bad_bots`
3 0.0003 0.00034904479980469 
SET time_zone = 'Europe/London'
4 0.0006 0.0006258487701416 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.0014610290527344 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.106\";}'
6 0.0010 0.001025915145874 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1756132028'
7 0.0011 0.001129150390625 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00034308433532715 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00086498260498047 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0003 0.00026178359985352 
SELECT * FROM pages WHERE id = 37
11 0.0014 0.0014359951019287 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0204 0.020437955856323 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00050687789916992 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0009 0.00086402893066406 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00084710121154785 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0053 0.0052509307861328 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0004 0.00039815902709961 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0007 0.0007011890411377 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00031900405883789 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0048 0.0047519207000732 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0010 0.00095009803771973 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0004 0.00042200088500977 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0008 0.00079703330993652 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00033307075500488 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0032 0.0031628608703613 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.00033688545227051 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00028085708618164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00032401084899902 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0030 0.0030450820922852 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0004 0.00037193298339844 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0004 0.00040292739868164 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00034999847412109 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00030207633972168 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0012 0.0011630058288574 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00034284591674805 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.00026583671569824 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00030088424682617 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0013 0.0012648105621338 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0004 0.00037097930908203 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0003 0.00034618377685547 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00031089782714844 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030088424682617 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00040292739868164 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0003 0.00030398368835449 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00029206275939941 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00030612945556641 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00045204162597656 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0003 0.00034785270690918 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0003 0.00033783912658691 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00031089782714844 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00032591819763184 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00038409233093262 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.00030994415283203 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00027084350585938 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00028896331787109 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00049209594726562 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0004 0.00036787986755371 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0004 0.0003509521484375 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0003 0.00030708312988281 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.0002748966217041 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00040507316589355 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0003 0.00029492378234863 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00028491020202637 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00036716461181641 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00046896934509277 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0003 0.0003209114074707 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0004 0.00037312507629395 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00034809112548828 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00032997131347656 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00032997131347656 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0020 0.0020060539245605 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0008 0.00081205368041992 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00037598609924316 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0006 0.00062704086303711 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00094914436340332 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00058412551879883 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8383 0.83825922012329 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.106') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.106') <= INET_ATON(ip_end)
78 0.0013 0.0013458728790283 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0007 0.00066494941711426 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0003 0.00034904479980469 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0052 0.0052168369293213 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0016 0.0016090869903564 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0011 0.0010840892791748 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0052 0.0051839351654053 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0014 0.0014011859893799 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0004 0.0004279613494873 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0040 0.0039970874786377 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0046 0.0046079158782959 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0014 0.0013589859008789 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0004 0.00042295455932617 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0043 0.004256010055542 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 1044, 18
92 0.0008 0.00082898139953613 
SELECT * FROM productimages WHERE product_id = '3387' ORDER BY sortorder ASC
93 0.0004 0.00040793418884277 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3387' AND p.id = pi.product_id ORDER BY pi.sortorder
94 0.0009 0.00087499618530273 
SELECT * FROM product_image_select WHERE product_id = '3387'
95 0.0006 0.00061178207397461 
SELECT * FROM productcustomimages WHERE product_id = '3387'
96 0.0008 0.00077104568481445 
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 = '3387'
                GROUP BY o.product_id
97 0.0012 0.0012028217315674 
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     = '3387'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
98 0.0003 0.00033998489379883 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3387
99 0.0012 0.0011680126190186 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3387' AND a.name = n.originalname
100 0.0004 0.00042891502380371 
SELECT * FROM productoffers WHERE product_id = '3387' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '3387' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0002 0.00022697448730469 
SELECT * FROM productoffers
                WHERE product_id = 3387
                ORDER BY price ASC LIMIT 1
103 0.0003 0.00027012825012207 
SELECT value FROM productattributes
                WHERE product_id = '3387'
                AND name = 'ListPriceAmount'
104 0.0004 0.00037384033203125 
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 = '3387'
                GROUP BY o.product_id
105 0.0004 0.00042104721069336 
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     = '3387'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
106 0.0003 0.0002899169921875 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3387
107 0.0004 0.0003509521484375 
SELECT value FROM productattributes WHERE product_id = '3387' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0004 0.00040292739868164 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3387'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
109 0.0003 0.00034594535827637 
SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
110 0.0005 0.00050806999206543 
SELECT * FROM product_image_select WHERE product_id = '3590'
111 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '3590'
112 0.0006 0.00055384635925293 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
113 0.0003 0.00034618377685547 
SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0003 0.0002598762512207 
SELECT * FROM productoffers
                WHERE product_id = '3590' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = 3590
                ORDER BY price ASC LIMIT 1
116 0.0003 0.00026798248291016 
SELECT value FROM productattributes
                WHERE product_id = '3590'
                AND name = 'ListPriceAmount'
117 0.0003 0.00028109550476074 
SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0003 0.00029897689819336 
SELECT * FROM productimages WHERE product_id = '3528' ORDER BY sortorder ASC
119 0.0005 0.00047707557678223 
SELECT * FROM product_image_select WHERE product_id = '3528'
120 0.0003 0.00026702880859375 
SELECT * FROM productcustomimages WHERE product_id = '3528'
121 0.0005 0.00054097175598145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3528' AND a.name = n.originalname
122 0.0003 0.00030398368835449 
SELECT * FROM productoffers WHERE product_id = '3528' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0002 0.00023794174194336 
SELECT * FROM productoffers
                WHERE product_id = '3528' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = 3528
                ORDER BY price ASC LIMIT 1
125 0.0002 0.00024700164794922 
SELECT value FROM productattributes
                WHERE product_id = '3528'
                AND name = 'ListPriceAmount'
126 0.0003 0.00025510787963867 
SELECT value FROM productattributes WHERE product_id = '3528' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00030612945556641 
SELECT * FROM productimages WHERE product_id = '3406' ORDER BY sortorder ASC
128 0.0005 0.00046610832214355 
SELECT * FROM product_image_select WHERE product_id = '3406'
129 0.0003 0.0002901554107666 
SELECT * FROM productcustomimages WHERE product_id = '3406'
130 0.0006 0.00058507919311523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3406' AND a.name = n.originalname
131 0.0003 0.00032591819763184 
SELECT * FROM productoffers WHERE product_id = '3406' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0002 0.00023794174194336 
SELECT * FROM productoffers
                WHERE product_id = '3406' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0002 0.00024795532226562 
SELECT * FROM productoffers
                WHERE product_id = 3406
                ORDER BY price ASC LIMIT 1
134 0.0002 0.00024819374084473 
SELECT value FROM productattributes
                WHERE product_id = '3406'
                AND name = 'ListPriceAmount'
135 0.0003 0.0002601146697998 
SELECT value FROM productattributes WHERE product_id = '3406' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00038409233093262 
SELECT * FROM productimages WHERE product_id = '3407' ORDER BY sortorder ASC
137 0.0005 0.00049901008605957 
SELECT * FROM product_image_select WHERE product_id = '3407'
138 0.0003 0.0002591609954834 
SELECT * FROM productcustomimages WHERE product_id = '3407'
139 0.0005 0.00046086311340332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3407' AND a.name = n.originalname
140 0.0003 0.00034904479980469 
SELECT * FROM productoffers WHERE product_id = '3407' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0003 0.00029706954956055 
SELECT * FROM productoffers
                WHERE product_id = '3407' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '3407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0003 0.00034785270690918 
SELECT * FROM productimages WHERE product_id = '3413' ORDER BY sortorder ASC
144 0.0005 0.00045299530029297 
SELECT * FROM product_image_select WHERE product_id = '3413'
145 0.0003 0.0002748966217041 
SELECT * FROM productcustomimages WHERE product_id = '3413'
146 0.0006 0.00058579444885254 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3413' AND a.name = n.originalname
147 0.0003 0.0003058910369873 
SELECT * FROM productoffers WHERE product_id = '3413' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.000244140625 
SELECT * FROM productoffers
                WHERE product_id = '3413' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.0002291202545166 
SELECT * FROM productoffers
                WHERE product_id = 3413
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00024700164794922 
SELECT value FROM productattributes
                WHERE product_id = '3413'
                AND name = 'ListPriceAmount'
151 0.0003 0.00027298927307129 
SELECT value FROM productattributes WHERE product_id = '3413' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0004 0.00040078163146973 
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
153 0.0007 0.0006721019744873 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
154 0.0005 0.0004730224609375 
SELECT * FROM product_image_select WHERE product_id = '3434'
155 0.0003 0.00029110908508301 
SELECT * FROM productcustomimages WHERE product_id = '3434'
156 0.0004 0.00043106079101562 
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 = '3434'
                GROUP BY o.product_id
157 0.0011 0.001068115234375 
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     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
158 0.0003 0.00034403800964355 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
159 0.0007 0.00069999694824219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
160 0.0003 0.00028395652770996 
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0002 0.00024890899658203 
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00022387504577637 
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00024008750915527 
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
164 0.0003 0.00034785270690918 
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 = '3434'
                GROUP BY o.product_id
165 0.0008 0.00075221061706543 
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     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0003 0.00033783912658691 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
167 0.0003 0.00034594535827637 
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0006 0.00057601928710938 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
169 0.0005 0.00054597854614258 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
170 0.0003 0.00034284591674805 
SELECT * FROM productimages WHERE product_id = '3464' ORDER BY sortorder ASC
171 0.0004 0.00044512748718262 
SELECT * FROM product_image_select WHERE product_id = '3464'
172 0.0003 0.00028014183044434 
SELECT * FROM productcustomimages WHERE product_id = '3464'
173 0.0006 0.00059604644775391 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3464' AND a.name = n.originalname
174 0.0003 0.00031185150146484 
SELECT * FROM productoffers WHERE product_id = '3464' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0002 0.00024890899658203 
SELECT * FROM productoffers
                WHERE product_id = '3464' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0002 0.00023412704467773 
SELECT * FROM productoffers
                WHERE product_id = 3464
                ORDER BY price ASC LIMIT 1
177 0.0002 0.00023698806762695 
SELECT value FROM productattributes
                WHERE product_id = '3464'
                AND name = 'ListPriceAmount'
178 0.0003 0.00025105476379395 
SELECT value FROM productattributes WHERE product_id = '3464' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0003 0.00031089782714844 
SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
180 0.0004 0.00043702125549316 
SELECT * FROM product_image_select WHERE product_id = '3472'
181 0.0003 0.0002598762512207 
SELECT * FROM productcustomimages WHERE product_id = '3472'
182 0.0006 0.00062394142150879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
183 0.0003 0.00033807754516602 
SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0003 0.00026106834411621 
SELECT * FROM productoffers
                WHERE product_id = '3472' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0002 0.00021886825561523 
SELECT * FROM productoffers
                WHERE product_id = 3472
                ORDER BY price ASC LIMIT 1
186 0.0002 0.00023698806762695 
SELECT value FROM productattributes
                WHERE product_id = '3472'
                AND name = 'ListPriceAmount'
187 0.0003 0.00027894973754883 
SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0003 0.00030899047851562 
SELECT * FROM productimages WHERE product_id = '3487' ORDER BY sortorder ASC
189 0.0003 0.00033688545227051 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3487' AND p.id = pi.product_id ORDER BY pi.sortorder
190 0.0004 0.00042486190795898 
SELECT * FROM product_image_select WHERE product_id = '3487'
191 0.0003 0.00025486946105957 
SELECT * FROM productcustomimages WHERE product_id = '3487'
192 0.0004 0.00035381317138672 
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 = '3487'
                GROUP BY o.product_id
193 0.0004 0.00042200088500977 
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     = '3487'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
194 0.0003 0.00026607513427734 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3487
195 0.0006 0.00055503845214844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3487' AND a.name = n.originalname
196 0.0003 0.00028395652770996 
SELECT * FROM productoffers WHERE product_id = '3487' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = '3487' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0002 0.00023508071899414 
SELECT * FROM productoffers
                WHERE product_id = 3487
                ORDER BY price ASC LIMIT 1
199 0.0002 0.00024795532226562 
SELECT value FROM productattributes
                WHERE product_id = '3487'
                AND name = 'ListPriceAmount'
200 0.0003 0.00028204917907715 
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 = '3487'
                GROUP BY o.product_id
201 0.0004 0.0003819465637207 
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     = '3487'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
202 0.0002 0.00024104118347168 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3487
203 0.0003 0.00032711029052734 
SELECT value FROM productattributes WHERE product_id = '3487' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00040698051452637 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3487'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
205 0.0003 0.00027799606323242 
SELECT * FROM products WHERE parent_id = '3487'
206 0.0003 0.00034093856811523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4881' AND a.name = n.originalname
207 0.0004 0.00036096572875977 
SELECT * FROM productoffers WHERE product_id = '4881' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0003 0.0002601146697998 
SELECT * FROM productoffers
                WHERE product_id = '4881' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00022792816162109 
SELECT * FROM productoffers
                WHERE product_id = 4881
                ORDER BY price ASC LIMIT 1
210 0.0002 0.00023889541625977 
SELECT value FROM productattributes
                WHERE product_id = '4881'
                AND name = 'ListPriceAmount'
211 0.0003 0.00034189224243164 
SELECT * FROM productimages WHERE product_id = '3492' ORDER BY sortorder ASC
212 0.0004 0.00042295455932617 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3492' AND p.id = pi.product_id ORDER BY pi.sortorder
213 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '3492'
214 0.0003 0.00027108192443848 
SELECT * FROM productcustomimages WHERE product_id = '3492'
215 0.0003 0.00034499168395996 
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 = '3492'
                GROUP BY o.product_id
216 0.0004 0.00040507316589355 
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     = '3492'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
217 0.0003 0.00026893615722656 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3492
218 0.0007 0.00068783760070801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3492' AND a.name = n.originalname
219 0.0002 0.00023818016052246 
SELECT * FROM productoffers WHERE product_id = '3492' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00025701522827148 
SELECT * FROM productoffers
                WHERE product_id = '3492' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00022602081298828 
SELECT * FROM productoffers
                WHERE product_id = 3492
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00023794174194336 
SELECT value FROM productattributes
                WHERE product_id = '3492'
                AND name = 'ListPriceAmount'
223 0.0003 0.00026297569274902 
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 = '3492'
                GROUP BY o.product_id
224 0.0004 0.00039815902709961 
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     = '3492'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
225 0.0003 0.00025010108947754 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3492
226 0.0003 0.00034093856811523 
SELECT value FROM productattributes WHERE product_id = '3492' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00037693977355957 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3492'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
228 0.0003 0.00032186508178711 
SELECT * FROM productimages WHERE product_id = '3507' ORDER BY sortorder ASC
229 0.0005 0.00045490264892578 
SELECT * FROM product_image_select WHERE product_id = '3507'
230 0.0003 0.00026583671569824 
SELECT * FROM productcustomimages WHERE product_id = '3507'
231 0.0006 0.00059413909912109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3507' AND a.name = n.originalname
232 0.0003 0.00032496452331543 
SELECT * FROM productoffers WHERE product_id = '3507' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0002 0.00024604797363281 
SELECT * FROM productoffers
                WHERE product_id = '3507' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0002 0.00022101402282715 
SELECT * FROM productoffers
                WHERE product_id = 3507
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00026297569274902 
SELECT value FROM productattributes
                WHERE product_id = '3507'
                AND name = 'ListPriceAmount'
236 0.0003 0.0002589225769043 
SELECT value FROM productattributes WHERE product_id = '3507' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0003 0.00030899047851562 
SELECT * FROM productimages WHERE product_id = '3602' ORDER BY sortorder ASC
238 0.0004 0.0004429817199707 
SELECT * FROM product_image_select WHERE product_id = '3602'
239 0.0003 0.00025105476379395 
SELECT * FROM productcustomimages WHERE product_id = '3602'
240 0.0006 0.00058078765869141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3602' AND a.name = n.originalname
241 0.0003 0.00029897689819336 
SELECT * FROM productoffers WHERE product_id = '3602' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0002 0.00023722648620605 
SELECT * FROM productoffers
                WHERE product_id = '3602' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0002 0.00023293495178223 
SELECT * FROM productoffers
                WHERE product_id = 3602
                ORDER BY price ASC LIMIT 1
244 0.0003 0.0002601146697998 
SELECT value FROM productattributes
                WHERE product_id = '3602'
                AND name = 'ListPriceAmount'
245 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '3602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0003 0.00033688545227051 
SELECT * FROM productimages WHERE product_id = '3523' ORDER BY sortorder ASC
247 0.0004 0.00036096572875977 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3523' AND p.id = pi.product_id ORDER BY pi.sortorder
248 0.0005 0.00047206878662109 
SELECT * FROM product_image_select WHERE product_id = '3523'
249 0.0003 0.00025701522827148 
SELECT * FROM productcustomimages WHERE product_id = '3523'
250 0.0003 0.00030994415283203 
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 = '3523'
                GROUP BY o.product_id
251 0.0004 0.00037813186645508 
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     = '3523'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
252 0.0002 0.0002439022064209 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
253 0.0006 0.00062894821166992 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3523' AND a.name = n.originalname
254 0.0002 0.00024986267089844 
SELECT * FROM productoffers WHERE product_id = '3523' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0002 0.00022983551025391 
SELECT * FROM productoffers
                WHERE product_id = '3523' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0002 0.0002291202545166 
SELECT * FROM productoffers
                WHERE product_id = 3523
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00025510787963867 
SELECT value FROM productattributes
                WHERE product_id = '3523'
                AND name = 'ListPriceAmount'
258 0.0003 0.00025606155395508 
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 = '3523'
                GROUP BY o.product_id
259 0.0004 0.00035905838012695 
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     = '3523'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
260 0.0002 0.00023007392883301 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
261 0.0003 0.0003201961517334 
SELECT value FROM productattributes WHERE product_id = '3523' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0002 0.00024604797363281 
SELECT * FROM products WHERE parent_id = '3523'
263 0.0003 0.00033187866210938 
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
264 0.0005 0.00051498413085938 
SELECT * FROM product_image_select WHERE product_id = '3524'
265 0.0003 0.00026583671569824 
SELECT * FROM productcustomimages WHERE product_id = '3524'
266 0.0005 0.00053811073303223 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
267 0.0003 0.00030207633972168 
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0002 0.00024890899658203 
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0003 0.00028491020202637 
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0004 0.00037002563476562 
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
271 0.0005 0.00047492980957031 
SELECT * FROM product_image_select WHERE product_id = '3525'
272 0.0003 0.00026988983154297 
SELECT * FROM productcustomimages WHERE product_id = '3525'
273 0.0006 0.00056314468383789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
274 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
275 0.0003 0.0002601146697998 
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0003 0.00026988983154297 
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
277 0.0003 0.00031089782714844 
SELECT * FROM productimages WHERE product_id = '3529' ORDER BY sortorder ASC
278 0.0005 0.00051403045654297 
SELECT * FROM product_image_select WHERE product_id = '3529'
279 0.0003 0.00030207633972168 
SELECT * FROM productcustomimages WHERE product_id = '3529'
280 0.0006 0.0005500316619873 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3529' AND a.name = n.originalname
281 0.0003 0.00030899047851562 
SELECT * FROM productoffers WHERE product_id = '3529' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '3529' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0002 0.00022697448730469 
SELECT * FROM productoffers
                WHERE product_id = 3529
                ORDER BY price ASC LIMIT 1
284 0.0003 0.00025391578674316 
SELECT value FROM productattributes
                WHERE product_id = '3529'
                AND name = 'ListPriceAmount'
285 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '3529' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0003 0.00030612945556641 
SELECT * FROM productimages WHERE product_id = '3530' ORDER BY sortorder ASC
287 0.0005 0.00048208236694336 
SELECT * FROM product_image_select WHERE product_id = '3530'
288 0.0003 0.00029397010803223 
SELECT * FROM productcustomimages WHERE product_id = '3530'
289 0.0007 0.00067591667175293 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3530' AND a.name = n.originalname
290 0.0003 0.00032496452331543 
SELECT * FROM productoffers WHERE product_id = '3530' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0003 0.00025105476379395 
SELECT * FROM productoffers
                WHERE product_id = '3530' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.00026416778564453 
SELECT * FROM productoffers
                WHERE product_id = 3530
                ORDER BY price ASC LIMIT 1
293 0.0002 0.00024795532226562 
SELECT value FROM productattributes
                WHERE product_id = '3530'
                AND name = 'ListPriceAmount'
294 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '3530' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0009 0.00092601776123047 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3387' ORDER BY timestamp DESC
296 0.0002 0.00022506713867188 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3590' ORDER BY timestamp DESC
297 0.0002 0.0002140998840332 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3528' ORDER BY timestamp DESC
298 0.0002 0.00021195411682129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3406' ORDER BY timestamp DESC
299 0.0002 0.0002129077911377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3407' ORDER BY timestamp DESC
300 0.0002 0.00020790100097656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3413' ORDER BY timestamp DESC
301 0.0002 0.00020194053649902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
302 0.0002 0.00020813941955566 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3464' ORDER BY timestamp DESC
303 0.0002 0.00020098686218262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
304 0.0002 0.0002140998840332 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3487' ORDER BY timestamp DESC
305 0.0002 0.0002288818359375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3492' ORDER BY timestamp DESC
306 0.0003 0.00025081634521484 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3507' ORDER BY timestamp DESC
307 0.0002 0.00022292137145996 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3602' ORDER BY timestamp DESC
308 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3523' ORDER BY timestamp DESC
309 0.0002 0.00019288063049316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3524' ORDER BY timestamp DESC
310 0.0002 0.00019288063049316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
311 0.0002 0.00018906593322754 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3529' ORDER BY timestamp DESC
312 0.0002 0.0001978874206543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3530' ORDER BY timestamp DESC
313 0.0008 0.00077581405639648 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
314 0.0007 0.00066781044006348 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
315 0.0002 0.00024199485778809 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
316 0.0120 0.012030839920044 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
317 0.0010 0.0010309219360352 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
318 0.0004 0.00037217140197754 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
319 0.0004 0.00037717819213867 
SELECT * FROM products WHERE id = 1626
320 0.0003 0.00028085708618164 
SELECT * FROM products WHERE id = 4041
321 0.0003 0.00026798248291016 
SELECT * FROM products WHERE id = 4312
322 0.0003 0.0002751350402832 
SELECT * FROM products WHERE id = 777
323 0.0003 0.00026893615722656 
SELECT * FROM products WHERE id = 3881
324 0.0003 0.0002589225769043 
SELECT * FROM products WHERE id = 4213
325 0.0003 0.00025701522827148 
SELECT * FROM products WHERE id = '1626'
326 0.0004 0.00038504600524902 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
327 0.0005 0.00051307678222656 
SELECT * FROM product_image_select WHERE product_id = '1626'
328 0.0003 0.0003209114074707 
SELECT * FROM productcustomimages WHERE product_id = '1626'
329 0.0007 0.00065708160400391 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
330 0.0004 0.00035905838012695 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0003 0.00030398368835449 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0003 0.00030517578125 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0004 0.00038409233093262 
SELECT * FROM products WHERE id = '4041'
334 0.0003 0.00033283233642578 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
335 0.0005 0.00050902366638184 
SELECT * FROM product_image_select WHERE product_id = '4041'
336 0.0003 0.00029087066650391 
SELECT * FROM productcustomimages WHERE product_id = '4041'
337 0.0008 0.00075006484985352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
338 0.0004 0.00035595893859863 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0003 0.00028491020202637 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0003 0.00030207633972168 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0003 0.00034189224243164 
SELECT * FROM products WHERE id = '4312'
342 0.0003 0.00030183792114258 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
343 0.0005 0.00048017501831055 
SELECT * FROM product_image_select WHERE product_id = '4312'
344 0.0003 0.0002739429473877 
SELECT * FROM productcustomimages WHERE product_id = '4312'
345 0.0007 0.00069904327392578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
346 0.0004 0.00037002563476562 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0003 0.00029301643371582 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0004 0.00038313865661621 
SELECT * FROM products WHERE id = '777'
350 0.0003 0.00033903121948242 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
351 0.0005 0.00047993659973145 
SELECT * FROM product_image_select WHERE product_id = '777'
352 0.0003 0.00029683113098145 
SELECT * FROM productcustomimages WHERE product_id = '777'
353 0.0007 0.00074911117553711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
354 0.0003 0.00034189224243164 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0003 0.00029301643371582 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0003 0.0002901554107666 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0003 0.00034499168395996 
SELECT * FROM products WHERE id = '3881'
358 0.0004 0.00038409233093262 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
359 0.0005 0.00049805641174316 
SELECT * FROM product_image_select WHERE product_id = '3881'
360 0.0003 0.00028204917907715 
SELECT * FROM productcustomimages WHERE product_id = '3881'
361 0.0007 0.00073099136352539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
362 0.0003 0.00033807754516602 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
363 0.0003 0.00030422210693359 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
364 0.0003 0.00032997131347656 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0004 0.00036907196044922 
SELECT * FROM products WHERE id = '4213'
366 0.0004 0.00042510032653809 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
367 0.0005 0.00047397613525391 
SELECT * FROM product_image_select WHERE product_id = '4213'
368 0.0003 0.00029897689819336 
SELECT * FROM productcustomimages WHERE product_id = '4213'
369 0.0007 0.00071907043457031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
370 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
371 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
372 0.0003 0.00027108192443848 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373 0.0014 0.00142502784729 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
374 0.0005 0.00052285194396973 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
375 0.0016 0.0015859603881836 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
376 0.0010 0.0010340213775635 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
377 0.0004 0.00038504600524902 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
378 0.0004 0.00044989585876465 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
379 0.0004 0.00040388107299805 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'