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.636137008667 428 1.2523 0


No Amazon API Requests Made.


App Debug - Total Time 1.636137008667 seconds

Number Time From Start Name Description
1 0.34354996681213 Initialise Initialise FSB Function
2 0.35198998451233 App Controller Start Start of the App controller (called before the controller of every page)
3 0.37706613540649 Start of getCategoryListByGroup Function Before first category groups query
4 0.37748312950134 After initial query Before first category groups query
5 0.37748312950134 Get Category List for Group Before the call to getCategoryList function
6 0.37748503684998 Start of GetCategoryList function Start of the function
7 0.37748599052429 Before getting categories Query to get specific category list
8 0.37792491912842 After getting categories Query to get specific category list
9 0.37792491912842 Before getting category custom Before call to function getCategoryCustom
10 0.39401602745056 After getting category custom After call to function getCategoryCustom
11 0.39401793479919 Before getting category custom Before call to function getCategoryCustom
12 0.40530610084534 After getting category custom After call to function getCategoryCustom
13 0.40530800819397 Before getting category custom Before call to function getCategoryCustom
14 0.41040396690369 After getting category custom After call to function getCategoryCustom
15 0.410404920578 Before getting category custom Before call to function getCategoryCustom
16 0.41377592086792 After getting category custom After call to function getCategoryCustom
17 0.41377806663513 Before getting category custom Before call to function getCategoryCustom
18 0.41724991798401 After getting category custom After call to function getCategoryCustom
19 0.4172511100769 Before getting category custom Before call to function getCategoryCustom
20 0.42063593864441 After getting category custom After call to function getCategoryCustom
21 0.4206371307373 End of GetCategoryList function End of the function
22 0.42064094543457 Get Category List for Group Before the call to getCategoryList function
23 0.42064309120178 Start of GetCategoryList function Start of the function
24 0.4206440448761 Before getting categories Query to get specific category list
25 0.42102313041687 End of getCategoryListByGroup Function Before return()
26 1.3735721111298 App Controller End End of the App controller (called before the controller of every page)
27 1.5582120418549 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5588550567627 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.5594279766083 Before Get Options Before the call to getOptions in the tpl class
30 1.5938539505005 After Get Options After the call to getOptions in the tpl class
31 1.5939490795135 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.6361269950867 Finalizing debug Before the debug is output to the page.
33 1.6361360549927 End of App This is the end of the app logging, final timestamp


Query Debug - 428 Database Queries. Total time 1.2523 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.0018138885498047 
SELECT parameter, value FROM parameters
2 0.0027 0.0026640892028809 
SELECT * FROM `bad_bots`
3 0.0003 0.00027704238891602 
SET time_zone = 'Europe/London'
4 0.0005 0.00045990943908691 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0005 0.00045108795166016 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.202\";}'
6 0.0003 0.00032520294189453 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750130758'
7 0.0014 0.00136399269104 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0028 0.0028460025787354 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0044 0.0044460296630859 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0008 0.00082278251647949 
SELECT * FROM pages WHERE id = 37
11 0.0017 0.001741886138916 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0227 0.022727012634277 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00036191940307617 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0004 0.00041294097900391 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00042915344238281 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0066 0.006554126739502 
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.00041294097900391 
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.0003 0.00033402442932129 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00034618377685547 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0067780017852783 
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.0005 0.00047397613525391 
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.00044107437133789 
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.0004 0.00037598609924316 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00033783912658691 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0041649341583252 
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.0004 0.00040721893310547 
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.0004 0.00037407875061035 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00036883354187012 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.0043528079986572 
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.0005 0.00049304962158203 
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.00043606758117676 
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.0004 0.00036501884460449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00029301643371582 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0012 0.0012390613555908 
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.0004 0.00039315223693848 
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.00031304359436035 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00034403800964355 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0014410018920898 
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.0003 0.00034809112548828 
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.00034594535827637 
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.00032615661621094 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030994415283203 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00046586990356445 
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.0004 0.00036787986755371 
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.00031280517578125 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00032496452331543 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00045990943908691 
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.0004 0.00035810470581055 
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.0004 0.0003969669342041 
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.00034284591674805 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00031208992004395 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.0004420280456543 
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.0003359317779541 
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.00031590461730957 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00034904479980469 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00055098533630371 
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.00037407875061035 
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.00041913986206055 
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.0004 0.00035405158996582 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00031089782714844 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00046992301940918 
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.00034379959106445 
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.00031089782714844 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00034403800964355 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00058507919311523 
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.0004 0.00035786628723145 
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.0003 0.00034213066101074 
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.00030612945556641 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00030899047851562 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00037598609924316 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.0015020370483398 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0005 0.00046992301940918 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00040888786315918 
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.0003 0.00029897689819336 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00094199180603027 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00057816505432129 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.9464 0.94643592834473 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.202') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.202') <= INET_ATON(ip_end)
78 0.0010 0.00098419189453125 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.00028300285339355 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0003 0.00030708312988281 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0048 0.0048398971557617 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0013 0.0012969970703125 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0004 0.00039982795715332 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0045 0.0044920444488525 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0012 0.0012328624725342 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0003 0.00034594535827637 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0083 0.0083239078521729 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0124 0.012388944625854 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0030 0.0029881000518799 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0007 0.00073099136352539 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0097 0.0097341537475586 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 252, 18
92 0.0007 0.00073599815368652 
SELECT * FROM productimages WHERE product_id = '3742' ORDER BY sortorder ASC
93 0.0004 0.00041794776916504 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3742' AND p.id = pi.product_id ORDER BY pi.sortorder
94 0.0009 0.00094795227050781 
SELECT * FROM product_image_select WHERE product_id = '3742'
95 0.0005 0.0004880428314209 
SELECT * FROM productcustomimages WHERE product_id = '3742'
96 0.0006 0.00059819221496582 
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 = '3742'
                GROUP BY o.product_id
97 0.0007 0.00070810317993164 
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     = '3742'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
98 0.0004 0.0003960132598877 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3742
99 0.0017 0.0016500949859619 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3742' AND a.name = n.originalname
100 0.0042 0.0042221546173096 
SELECT * FROM productoffers WHERE product_id = '3742' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0042 0.0042209625244141 
SELECT * FROM productoffers
                WHERE product_id = '3742' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0004 0.00042819976806641 
SELECT * FROM productoffers
                WHERE product_id = 3742
                ORDER BY price ASC LIMIT 1
103 0.0004 0.00040698051452637 
SELECT value FROM productattributes
                WHERE product_id = '3742'
                AND name = 'ListPriceAmount'
104 0.0005 0.00047683715820312 
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 = '3742'
                GROUP BY o.product_id
105 0.0007 0.00069785118103027 
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     = '3742'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
106 0.0004 0.00039100646972656 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3742
107 0.0006 0.00064992904663086 
SELECT value FROM productattributes WHERE product_id = '3742' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0004 0.0003809928894043 
SELECT * FROM products WHERE parent_id = '3742'
109 0.0007 0.00066399574279785 
SELECT * FROM productimages WHERE product_id = '1267' ORDER BY sortorder ASC
110 0.0011 0.001086950302124 
SELECT * FROM product_image_select WHERE product_id = '1267'
111 0.0005 0.00048494338989258 
SELECT * FROM productcustomimages WHERE product_id = '1267'
112 0.0018 0.0017809867858887 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1267' AND a.name = n.originalname
113 0.0007 0.00066494941711426 
SELECT * FROM productoffers WHERE product_id = '1267' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0005 0.00050902366638184 
SELECT * FROM productoffers
                WHERE product_id = '1267' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00037384033203125 
SELECT * FROM productoffers
                WHERE product_id = 1267
                ORDER BY price ASC LIMIT 1
116 0.0004 0.00039291381835938 
SELECT value FROM productattributes
                WHERE product_id = '1267'
                AND name = 'ListPriceAmount'
117 0.0004 0.00043201446533203 
SELECT value FROM productattributes WHERE product_id = '1267' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0006 0.00057792663574219 
SELECT * FROM productimages WHERE product_id = '1409' ORDER BY sortorder ASC
119 0.0008 0.00075817108154297 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1409' AND p.id = pi.product_id ORDER BY pi.sortorder
120 0.0009 0.00090694427490234 
SELECT * FROM product_image_select WHERE product_id = '1409'
121 0.0005 0.00054478645324707 
SELECT * FROM productcustomimages WHERE product_id = '1409'
122 0.0006 0.00061392784118652 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1409'
                GROUP BY o.product_id
123 0.0009 0.00085186958312988 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1409'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
124 0.0005 0.0005490779876709 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1409
125 0.0011 0.0010781288146973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1409' AND a.name = n.originalname
126 0.0004 0.00036001205444336 
SELECT * FROM productoffers WHERE product_id = '1409' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = '1409' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0003 0.00029683113098145 
SELECT * FROM productoffers
                WHERE product_id = 1409
                ORDER BY price ASC LIMIT 1
129 0.0003 0.0003349781036377 
SELECT value FROM productattributes
                WHERE product_id = '1409'
                AND name = 'ListPriceAmount'
130 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 = '1409'
                GROUP BY o.product_id
131 0.0007 0.00066685676574707 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1409'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
132 0.0004 0.00035190582275391 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1409
133 0.0008 0.00077700614929199 
SELECT value FROM productattributes WHERE product_id = '1409' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0007 0.00069999694824219 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1409'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
135 0.0007 0.00070619583129883 
SELECT * FROM productimages WHERE product_id = '1574' ORDER BY sortorder ASC
136 0.0010 0.00096392631530762 
SELECT * FROM product_image_select WHERE product_id = '1574'
137 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '1574'
138 0.0014 0.0013909339904785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1574' AND a.name = n.originalname
139 0.0006 0.0005648136138916 
SELECT * FROM productoffers WHERE product_id = '1574' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00042891502380371 
SELECT * FROM productoffers
                WHERE product_id = '1574' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00052118301391602 
SELECT value FROM productattributes WHERE product_id = '1574' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0006 0.00056886672973633 
SELECT * FROM productimages WHERE product_id = '1291' ORDER BY sortorder ASC
143 0.0010 0.00095295906066895 
SELECT * FROM product_image_select WHERE product_id = '1291'
144 0.0005 0.00050115585327148 
SELECT * FROM productcustomimages WHERE product_id = '1291'
145 0.0016 0.0015749931335449 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
146 0.0005 0.00047111511230469 
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00043511390686035 
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
150 0.0005 0.00047612190246582 
SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0007 0.00073909759521484 
SELECT * FROM productimages WHERE product_id = '1601' ORDER BY sortorder ASC
152 0.0010 0.00096797943115234 
SELECT * FROM product_image_select WHERE product_id = '1601'
153 0.0004 0.00043511390686035 
SELECT * FROM productcustomimages WHERE product_id = '1601'
154 0.0016 0.0015969276428223 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1601' AND a.name = n.originalname
155 0.0006 0.00061607360839844 
SELECT * FROM productoffers WHERE product_id = '1601' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00029993057250977 
SELECT * FROM productoffers
                WHERE product_id = '1601' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00035309791564941 
SELECT value FROM productattributes WHERE product_id = '1601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0003 0.00033783912658691 
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
159 0.0005 0.00049996376037598 
SELECT * FROM product_image_select WHERE product_id = '857'
160 0.0003 0.00025606155395508 
SELECT * FROM productcustomimages WHERE product_id = '857'
161 0.0006 0.00058603286743164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
162 0.0003 0.00030088424682617 
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0003 0.00033807754516602 
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0003 0.00034499168395996 
SELECT * FROM productimages WHERE product_id = '4291' ORDER BY sortorder ASC
166 0.0011 0.0011060237884521 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4291' AND p.id = pi.product_id ORDER BY pi.sortorder
167 0.0009 0.000885009765625 
SELECT * FROM product_image_select WHERE product_id = '4291'
168 0.0005 0.00051999092102051 
SELECT * FROM productcustomimages WHERE product_id = '4291'
169 0.0006 0.00059604644775391 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4291'
                GROUP BY o.product_id
170 0.0007 0.00071406364440918 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
171 0.0004 0.00037002563476562 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
172 0.0017 0.0017299652099609 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4291' AND a.name = n.originalname
173 0.0004 0.00042915344238281 
SELECT * FROM productoffers WHERE product_id = '4291' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00036406517028809 
SELECT * FROM productoffers
                WHERE product_id = '4291' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00033712387084961 
SELECT * FROM productoffers
                WHERE product_id = 4291
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00040793418884277 
SELECT value FROM productattributes
                WHERE product_id = '4291'
                AND name = 'ListPriceAmount'
177 0.0004 0.0003960132598877 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4291'
                GROUP BY o.product_id
178 0.0007 0.00066709518432617 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4291'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
179 0.0004 0.00037598609924316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4291
180 0.0006 0.00061321258544922 
SELECT value FROM productattributes WHERE product_id = '4291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0004 0.00037288665771484 
SELECT * FROM products WHERE parent_id = '4291'
182 0.0008 0.00083398818969727 
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
183 0.0009 0.00093317031860352 
SELECT * FROM product_image_select WHERE product_id = '790'
184 0.0004 0.00042200088500977 
SELECT * FROM productcustomimages WHERE product_id = '790'
185 0.0014 0.0013961791992188 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
186 0.0005 0.00054502487182617 
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0004 0.00036215782165527 
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = 790
                ORDER BY price ASC LIMIT 1
189 0.0004 0.0003819465637207 
SELECT value FROM productattributes
                WHERE product_id = '790'
                AND name = 'ListPriceAmount'
190 0.0005 0.00046181678771973 
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0005 0.00054216384887695 
SELECT * FROM productimages WHERE product_id = '3020' ORDER BY sortorder ASC
192 0.0005 0.00051784515380859 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3020' AND p.id = pi.product_id ORDER BY pi.sortorder
193 0.0008 0.00084304809570312 
SELECT * FROM product_image_select WHERE product_id = '3020'
194 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '3020'
195 0.0005 0.00052785873413086 
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 = '3020'
                GROUP BY o.product_id
196 0.0007 0.0006868839263916 
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     = '3020'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0004 0.0003819465637207 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3020
198 0.0013 0.0013489723205566 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3020' AND a.name = n.originalname
199 0.0004 0.00036096572875977 
SELECT * FROM productoffers WHERE product_id = '3020' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0004 0.00035881996154785 
SELECT * FROM productoffers
                WHERE product_id = '3020' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0004 0.00035786628723145 
SELECT * FROM productoffers
                WHERE product_id = 3020
                ORDER BY price ASC LIMIT 1
202 0.0004 0.00036907196044922 
SELECT value FROM productattributes
                WHERE product_id = '3020'
                AND name = 'ListPriceAmount'
203 0.0005 0.00047111511230469 
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 = '3020'
                GROUP BY o.product_id
204 0.0007 0.0006721019744873 
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     = '3020'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
205 0.0004 0.00037312507629395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3020
206 0.0006 0.00058698654174805 
SELECT value FROM productattributes WHERE product_id = '3020' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0004 0.00036406517028809 
SELECT * FROM products WHERE parent_id = '3020'
208 0.0006 0.00062894821166992 
SELECT * FROM productimages WHERE product_id = '2949' ORDER BY sortorder ASC
209 0.0004 0.00040698051452637 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2949' AND p.id = pi.product_id ORDER BY pi.sortorder
210 0.0009 0.00087785720825195 
SELECT * FROM product_image_select WHERE product_id = '2949'
211 0.0005 0.0005338191986084 
SELECT * FROM productcustomimages WHERE product_id = '2949'
212 0.0005 0.00053811073303223 
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 = '2949'
                GROUP BY o.product_id
213 0.0006 0.00064587593078613 
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     = '2949'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
214 0.0004 0.00035786628723145 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2949
215 0.0012 0.00124192237854 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2949' AND a.name = n.originalname
216 0.0004 0.00036001205444336 
SELECT * FROM productoffers WHERE product_id = '2949' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = '2949' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00031614303588867 
SELECT * FROM productoffers
                WHERE product_id = 2949
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00036811828613281 
SELECT value FROM productattributes
                WHERE product_id = '2949'
                AND name = 'ListPriceAmount'
220 0.0004 0.00039076805114746 
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 = '2949'
                GROUP BY o.product_id
221 0.0008 0.00076603889465332 
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     = '2949'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
222 0.0004 0.00037789344787598 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2949
223 0.0006 0.00057387351989746 
SELECT value FROM productattributes WHERE product_id = '2949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0004 0.00035190582275391 
SELECT * FROM products WHERE parent_id = '2949'
225 0.0006 0.00064396858215332 
SELECT * FROM productimages WHERE product_id = '2943' ORDER BY sortorder ASC
226 0.0004 0.00038886070251465 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2943' AND p.id = pi.product_id ORDER BY pi.sortorder
227 0.0009 0.00093507766723633 
SELECT * FROM product_image_select WHERE product_id = '2943'
228 0.0004 0.00042605400085449 
SELECT * FROM productcustomimages WHERE product_id = '2943'
229 0.0005 0.00053000450134277 
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 = '2943'
                GROUP BY o.product_id
230 0.0007 0.00065398216247559 
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     = '2943'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
231 0.0004 0.00035500526428223 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2943
232 0.0015 0.0015239715576172 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2943' AND a.name = n.originalname
233 0.0004 0.00036001205444336 
SELECT * FROM productoffers WHERE product_id = '2943' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0003 0.00030612945556641 
SELECT * FROM productoffers
                WHERE product_id = '2943' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00029492378234863 
SELECT * FROM productoffers
                WHERE product_id = 2943
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00032806396484375 
SELECT value FROM productattributes
                WHERE product_id = '2943'
                AND name = 'ListPriceAmount'
237 0.0003 0.00033402442932129 
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 = '2943'
                GROUP BY o.product_id
238 0.0006 0.00055599212646484 
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     = '2943'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
239 0.0003 0.00031900405883789 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2943
240 0.0005 0.00052881240844727 
SELECT value FROM productattributes WHERE product_id = '2943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0003 0.0003209114074707 
SELECT * FROM products WHERE parent_id = '2943'
242 0.0005 0.0005028247833252 
SELECT * FROM productimages WHERE product_id = '2941' ORDER BY sortorder ASC
243 0.0003 0.00032901763916016 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2941' AND p.id = pi.product_id ORDER BY pi.sortorder
244 0.0007 0.00069189071655273 
SELECT * FROM product_image_select WHERE product_id = '2941'
245 0.0004 0.00035905838012695 
SELECT * FROM productcustomimages WHERE product_id = '2941'
246 0.0005 0.00050902366638184 
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 = '2941'
                GROUP BY o.product_id
247 0.0006 0.00063014030456543 
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     = '2941'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
248 0.0003 0.0003199577331543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
249 0.0012 0.0012071132659912 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2941' AND a.name = n.originalname
250 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '2941' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0003 0.00030612945556641 
SELECT * FROM productoffers
                WHERE product_id = '2941' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = 2941
                ORDER BY price ASC LIMIT 1
253 0.0003 0.0003199577331543 
SELECT value FROM productattributes
                WHERE product_id = '2941'
                AND name = 'ListPriceAmount'
254 0.0003 0.00034523010253906 
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 = '2941'
                GROUP BY o.product_id
255 0.0006 0.00056195259094238 
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     = '2941'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
256 0.0003 0.00032496452331543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
257 0.0005 0.00050806999206543 
SELECT value FROM productattributes WHERE product_id = '2941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0003 0.00032901763916016 
SELECT * FROM products WHERE parent_id = '2941'
259 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '2942' ORDER BY sortorder ASC
260 0.0003 0.00034594535827637 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2942' AND p.id = pi.product_id ORDER BY pi.sortorder
261 0.0005 0.00052189826965332 
SELECT * FROM product_image_select WHERE product_id = '2942'
262 0.0003 0.00025820732116699 
SELECT * FROM productcustomimages WHERE product_id = '2942'
263 0.0004 0.00035309791564941 
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 = '2942'
                GROUP BY o.product_id
264 0.0004 0.00037503242492676 
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     = '2942'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
265 0.0002 0.00023293495178223 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
266 0.0006 0.00064992904663086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2942' AND a.name = n.originalname
267 0.0003 0.00025105476379395 
SELECT * FROM productoffers WHERE product_id = '2942' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0003 0.00027012825012207 
SELECT * FROM productoffers
                WHERE product_id = '2942' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = 2942
                ORDER BY price ASC LIMIT 1
270 0.0002 0.00024104118347168 
SELECT value FROM productattributes
                WHERE product_id = '2942'
                AND name = 'ListPriceAmount'
271 0.0003 0.00026106834411621 
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 = '2942'
                GROUP BY o.product_id
272 0.0004 0.00038814544677734 
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     = '2942'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
273 0.0002 0.00023388862609863 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
274 0.0003 0.00032687187194824 
SELECT value FROM productattributes WHERE product_id = '2942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0002 0.00023984909057617 
SELECT * FROM products WHERE parent_id = '2942'
276 0.0003 0.00034189224243164 
SELECT * FROM productimages WHERE product_id = '2912' ORDER BY sortorder ASC
277 0.0002 0.00024104118347168 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2912' AND p.id = pi.product_id ORDER BY pi.sortorder
278 0.0004 0.00042510032653809 
SELECT * FROM product_image_select WHERE product_id = '2912'
279 0.0003 0.00026392936706543 
SELECT * FROM productcustomimages WHERE product_id = '2912'
280 0.0003 0.00029706954956055 
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 = '2912'
                GROUP BY o.product_id
281 0.0004 0.00036406517028809 
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     = '2912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
282 0.0002 0.00023198127746582 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2912
283 0.0006 0.00058698654174805 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2912' AND a.name = n.originalname
284 0.0002 0.00023794174194336 
SELECT * FROM productoffers WHERE product_id = '2912' AND merchantid = 'A1X6FK5RDHNB96'
285 0.0003 0.00026607513427734 
SELECT * FROM productoffers
                WHERE product_id = '2912' AND price > 0
                ORDER BY price ASC LIMIT 1
286 0.0002 0.00022387504577637 
SELECT * FROM productoffers
                WHERE product_id = 2912
                ORDER BY price ASC LIMIT 1
287 0.0003 0.00025701522827148 
SELECT value FROM productattributes
                WHERE product_id = '2912'
                AND name = 'ListPriceAmount'
288 0.0003 0.00025796890258789 
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 = '2912'
                GROUP BY o.product_id
289 0.0004 0.00038409233093262 
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     = '2912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
290 0.0002 0.00023603439331055 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2912
291 0.0003 0.00031709671020508 
SELECT value FROM productattributes WHERE product_id = '2912' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0002 0.00023889541625977 
SELECT * FROM products WHERE parent_id = '2912'
293 0.0003 0.00029301643371582 
SELECT * FROM productimages WHERE product_id = '2852' ORDER BY sortorder ASC
294 0.0003 0.00026106834411621 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2852' AND p.id = pi.product_id ORDER BY pi.sortorder
295 0.0005 0.00049996376037598 
SELECT * FROM product_image_select WHERE product_id = '2852'
296 0.0003 0.00028681755065918 
SELECT * FROM productcustomimages WHERE product_id = '2852'
297 0.0003 0.00033187866210938 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2852'
                GROUP BY o.product_id
298 0.0004 0.00037503242492676 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
299 0.0004 0.00036382675170898 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2852
300 0.0007 0.0006558895111084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2852' AND a.name = n.originalname
301 0.0003 0.00027799606323242 
SELECT * FROM productoffers WHERE product_id = '2852' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0003 0.00025081634521484 
SELECT * FROM productoffers
                WHERE product_id = '2852' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = 2852
                ORDER BY price ASC LIMIT 1
304 0.0003 0.00025391578674316 
SELECT value FROM productattributes
                WHERE product_id = '2852'
                AND name = 'ListPriceAmount'
305 0.0003 0.00026893615722656 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2852'
                GROUP BY o.product_id
306 0.0004 0.00039100646972656 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2852'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
307 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 = 2852
308 0.0003 0.00034713745117188 
SELECT value FROM productattributes WHERE product_id = '2852' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0003 0.0002591609954834 
SELECT * FROM products WHERE parent_id = '2852'
310 0.0003 0.00031185150146484 
SELECT * FROM productimages WHERE product_id = '2728' ORDER BY sortorder ASC
311 0.0002 0.00024199485778809 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2728' AND p.id = pi.product_id ORDER BY pi.sortorder
312 0.0004 0.00042510032653809 
SELECT * FROM product_image_select WHERE product_id = '2728'
313 0.0003 0.00025796890258789 
SELECT * FROM productcustomimages WHERE product_id = '2728'
314 0.0003 0.00030612945556641 
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 = '2728'
                GROUP BY o.product_id
315 0.0004 0.00037884712219238 
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     = '2728'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
316 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 = 2728
317 0.0006 0.0006098747253418 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2728' AND a.name = n.originalname
318 0.0003 0.00025486946105957 
SELECT * FROM productoffers WHERE product_id = '2728' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = '2728' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0002 0.00023698806762695 
SELECT * FROM productoffers
                WHERE product_id = 2728
                ORDER BY price ASC LIMIT 1
321 0.0003 0.00025296211242676 
SELECT value FROM productattributes
                WHERE product_id = '2728'
                AND name = 'ListPriceAmount'
322 0.0002 0.00024604797363281 
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 = '2728'
                GROUP BY o.product_id
323 0.0004 0.0003509521484375 
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     = '2728'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
324 0.0002 0.00023317337036133 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2728
325 0.0003 0.00032901763916016 
SELECT value FROM productattributes WHERE product_id = '2728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0003 0.00028300285339355 
SELECT * FROM products WHERE parent_id = '2728'
327 0.0003 0.00032281875610352 
SELECT * FROM productimages WHERE product_id = '3498' ORDER BY sortorder ASC
328 0.0002 0.00023508071899414 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3498' AND p.id = pi.product_id ORDER BY pi.sortorder
329 0.0004 0.0004270076751709 
SELECT * FROM product_image_select WHERE product_id = '3498'
330 0.0003 0.00026392936706543 
SELECT * FROM productcustomimages WHERE product_id = '3498'
331 0.0003 0.0003209114074707 
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 = '3498'
                GROUP BY o.product_id
332 0.0004 0.00036191940307617 
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     = '3498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
333 0.0002 0.00022697448730469 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3498
334 0.0006 0.00057387351989746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3498' AND a.name = n.originalname
335 0.0003 0.00030803680419922 
SELECT * FROM productoffers WHERE product_id = '3498' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0002 0.00024008750915527 
SELECT * FROM productoffers
                WHERE product_id = '3498' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0002 0.00022697448730469 
SELECT * FROM productoffers
                WHERE product_id = 3498
                ORDER BY price ASC LIMIT 1
338 0.0003 0.00027894973754883 
SELECT value FROM productattributes
                WHERE product_id = '3498'
                AND name = 'ListPriceAmount'
339 0.0003 0.00026416778564453 
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 = '3498'
                GROUP BY o.product_id
340 0.0004 0.0003969669342041 
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     = '3498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
341 0.0003 0.00026822090148926 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3498
342 0.0004 0.00035500526428223 
SELECT value FROM productattributes WHERE product_id = '3498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
343 0.0003 0.00026988983154297 
SELECT * FROM products WHERE parent_id = '3498'
344 0.0003 0.00028491020202637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3742' ORDER BY timestamp DESC
345 0.0002 0.00022387504577637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1267' ORDER BY timestamp DESC
346 0.0002 0.00020384788513184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1409' ORDER BY timestamp DESC
347 0.0002 0.00019693374633789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1574' ORDER BY timestamp DESC
348 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1291' ORDER BY timestamp DESC
349 0.0002 0.0001990795135498 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1601' ORDER BY timestamp DESC
350 0.0002 0.00019478797912598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '857' ORDER BY timestamp DESC
351 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4291' ORDER BY timestamp DESC
352 0.0002 0.00019311904907227 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '790' ORDER BY timestamp DESC
353 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3020' ORDER BY timestamp DESC
354 0.0002 0.00019288063049316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2949' ORDER BY timestamp DESC
355 0.0002 0.00019407272338867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2943' ORDER BY timestamp DESC
356 0.0002 0.00018501281738281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2941' ORDER BY timestamp DESC
357 0.0002 0.00018692016601562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2942' ORDER BY timestamp DESC
358 0.0002 0.00018501281738281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2912' ORDER BY timestamp DESC
359 0.0002 0.00018596649169922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2852' ORDER BY timestamp DESC
360 0.0002 0.00018882751464844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2728' ORDER BY timestamp DESC
361 0.0002 0.0001838207244873 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3498' ORDER BY timestamp DESC
362 0.0003 0.0003209114074707 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
363 0.0003 0.00029897689819336 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
364 0.0002 0.00023603439331055 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
365 0.0115 0.011483907699585 
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
366 0.0005 0.00045299530029297 
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
367 0.0004 0.00037503242492676 
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
368 0.0004 0.00035190582275391 
SELECT * FROM products WHERE id = 1626
369 0.0002 0.00024223327636719 
SELECT * FROM products WHERE id = 4041
370 0.0003 0.0002591609954834 
SELECT * FROM products WHERE id = 4312
371 0.0003 0.00025320053100586 
SELECT * FROM products WHERE id = 777
372 0.0002 0.00024700164794922 
SELECT * FROM products WHERE id = 3881
373 0.0002 0.00022697448730469 
SELECT * FROM products WHERE id = 4213
374 0.0002 0.00022006034851074 
SELECT * FROM products WHERE id = '1626'
375 0.0003 0.00029587745666504 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
376 0.0004 0.00042414665222168 
SELECT * FROM product_image_select WHERE product_id = '1626'
377 0.0003 0.00025606155395508 
SELECT * FROM productcustomimages WHERE product_id = '1626'
378 0.0005 0.0005488395690918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
379 0.0003 0.0003199577331543 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
380 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
381 0.0003 0.00026392936706543 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
382 0.0003 0.00029206275939941 
SELECT * FROM products WHERE id = '4041'
383 0.0003 0.00028896331787109 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
384 0.0004 0.00041794776916504 
SELECT * FROM product_image_select WHERE product_id = '4041'
385 0.0003 0.0002591609954834 
SELECT * FROM productcustomimages WHERE product_id = '4041'
386 0.0007 0.00069093704223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
387 0.0003 0.00030016899108887 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
388 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
389 0.0003 0.00029206275939941 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
390 0.0003 0.00029206275939941 
SELECT * FROM products WHERE id = '4312'
391 0.0003 0.00029897689819336 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
392 0.0004 0.0004270076751709 
SELECT * FROM product_image_select WHERE product_id = '4312'
393 0.0003 0.00026202201843262 
SELECT * FROM productcustomimages WHERE product_id = '4312'
394 0.0006 0.00063109397888184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
395 0.0003 0.0002899169921875 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
396 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
397 0.0003 0.00026893615722656 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
398 0.0003 0.00031304359436035 
SELECT * FROM products WHERE id = '777'
399 0.0003 0.00032806396484375 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
400 0.0005 0.00047802925109863 
SELECT * FROM product_image_select WHERE product_id = '777'
401 0.0003 0.00026702880859375 
SELECT * FROM productcustomimages WHERE product_id = '777'
402 0.0007 0.00070691108703613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
403 0.0003 0.00031113624572754 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
404 0.0003 0.00027799606323242 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
405 0.0003 0.0002601146697998 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406 0.0003 0.0003349781036377 
SELECT * FROM products WHERE id = '3881'
407 0.0003 0.00034093856811523 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
408 0.0004 0.00043487548828125 
SELECT * FROM product_image_select WHERE product_id = '3881'
409 0.0003 0.0002591609954834 
SELECT * FROM productcustomimages WHERE product_id = '3881'
410 0.0007 0.00067877769470215 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
411 0.0003 0.0003361701965332 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
412 0.0003 0.00025510787963867 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0003 0.0002591609954834 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0003 0.00030994415283203 
SELECT * FROM products WHERE id = '4213'
415 0.0003 0.00032806396484375 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
416 0.0004 0.00041484832763672 
SELECT * FROM product_image_select WHERE product_id = '4213'
417 0.0003 0.00025200843811035 
SELECT * FROM productcustomimages WHERE product_id = '4213'
418 0.0007 0.00069284439086914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
419 0.0003 0.00029492378234863 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
420 0.0002 0.00024318695068359 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
421 0.0002 0.00024819374084473 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0005 0.00053095817565918 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
423 0.0004 0.00044918060302734 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
424 0.0011 0.0010988712310791 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
425 0.0004 0.00040888786315918 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
426 0.0003 0.00033283233642578 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
427 0.0005 0.0004570484161377 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
428 0.0004 0.00036501884460449 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'