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.5833339691162 374 1.1699 0


No Amazon API Requests Made.


App Debug - Total Time 1.5833339691162 seconds

Number Time From Start Name Description
1 0.38066291809082 Initialise Initialise FSB Function
2 0.38844394683838 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42537689208984 Start of getCategoryListByGroup Function Before first category groups query
4 0.4268000125885 After initial query Before first category groups query
5 0.42680096626282 Get Category List for Group Before the call to getCategoryList function
6 0.42680406570435 Start of GetCategoryList function Start of the function
7 0.42680597305298 Before getting categories Query to get specific category list
8 0.42814683914185 After getting categories Query to get specific category list
9 0.42814803123474 Before getting category custom Before call to function getCategoryCustom
10 0.44895887374878 After getting category custom After call to function getCategoryCustom
11 0.44896197319031 Before getting category custom Before call to function getCategoryCustom
12 0.46020102500916 After getting category custom After call to function getCategoryCustom
13 0.4602038860321 Before getting category custom Before call to function getCategoryCustom
14 0.46792602539062 After getting category custom After call to function getCategoryCustom
15 0.46792888641357 Before getting category custom Before call to function getCategoryCustom
16 0.47295188903809 After getting category custom After call to function getCategoryCustom
17 0.47295498847961 Before getting category custom Before call to function getCategoryCustom
18 0.47766804695129 After getting category custom After call to function getCategoryCustom
19 0.47766900062561 Before getting category custom Before call to function getCategoryCustom
20 0.48332595825195 After getting category custom After call to function getCategoryCustom
21 0.48332786560059 End of GetCategoryList function End of the function
22 0.48333287239075 Get Category List for Group Before the call to getCategoryList function
23 0.48333406448364 Start of GetCategoryList function Start of the function
24 0.48333501815796 Before getting categories Query to get specific category list
25 0.48386287689209 End of getCategoryListByGroup Function Before return()
26 1.2930529117584 App Controller End End of the App controller (called before the controller of every page)
27 1.4817459583282 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4857149124146 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.4892349243164 Before Get Options Before the call to getOptions in the tpl class
30 1.5581018924713 After Get Options After the call to getOptions in the tpl class
31 1.5582399368286 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.5833249092102 Finalizing debug Before the debug is output to the page.
33 1.5833330154419 End of App This is the end of the app logging, final timestamp


Query Debug - 374 Database Queries. Total time 1.1699 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.002004861831665 
SELECT parameter, value FROM parameters
2 0.0048 0.0047581195831299 
SELECT * FROM `bad_bots`
3 0.0004 0.00037288665771484 
SET time_zone = 'Europe/London'
4 0.0023 0.0022668838500977 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0026 0.0026149749755859 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.144.36.122\";}'
6 0.0027 0.0026500225067139 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746394268'
7 0.0035 0.003493070602417 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00067996978759766 
UPDATE autorun SET lastrun = '2025-05-04 21:31:08' WHERE id = '16'
9 0.0009 0.00088095664978027 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0056 0.0055611133575439 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0007 0.00065493583679199 
SELECT * FROM pages WHERE id = 37
12 0.0054 0.0053858757019043 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0305 0.030454158782959 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00062894821166992 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0014 0.001413106918335 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0013 0.0013220310211182 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0075 0.0074849128723145 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0017 0.0016598701477051 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0012 0.0011909008026123 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00045490264892578 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0055 0.0054841041564941 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
22 0.0014 0.0014221668243408 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
23 0.0014 0.0013768672943115 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0013 0.0012590885162354 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00039505958557129 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0039 0.0039150714874268 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.0004570484161377 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00040912628173828 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00042295455932617 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0037 0.003680944442749 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
31 0.0006 0.00061392784118652 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
32 0.0006 0.00061202049255371 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00052499771118164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00052213668823242 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0019 0.0019009113311768 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00054502487182617 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00040006637573242 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00041794776916504 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.0019900798797607 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
40 0.0005 0.00050592422485352 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
41 0.0006 0.00056600570678711 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00049805641174316 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0008 0.00082516670227051 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00065493583679199 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0005 0.00045895576477051 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0005 0.00046205520629883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00047898292541504 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00083589553833008 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0005 0.00053095817565918 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
50 0.0005 0.00054812431335449 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0006 0.0005500316619873 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00043392181396484 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.0006110668182373 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0005 0.00048303604125977 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00042390823364258 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00045108795166016 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00072503089904785 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.0006 0.0005640983581543 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0006 0.00060796737670898 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0004 0.00043606758117676 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00038599967956543 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00064206123352051 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.00048112869262695 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.0003960132598877 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00059604644775391 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0014 0.0013761520385742 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0006 0.00057816505432129 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
68 0.0006 0.00056791305541992 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00053906440734863 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00044989585876465 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00052404403686523 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0058 0.0057580471038818 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0027 0.0026810169219971 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0009 0.00090193748474121 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0021 0.0020740032196045 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0020 0.0019919872283936 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.0012021064758301 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7900 0.7899968624115 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.36.122') >= INET_ATON(ip_start) AND INET_ATON('3.144.36.122') <= INET_ATON(ip_end)
79 0.0019 0.0018599033355713 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0011 0.0011441707611084 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00075078010559082 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0098 0.0097658634185791 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0024 0.0023760795593262 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0026 0.0026149749755859 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0070 0.0070159435272217 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0018 0.0017790794372559 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0006 0.00055503845214844 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0047 0.0047218799591064 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0051 0.0051159858703613 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0014 0.0014231204986572 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00051999092102051 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0056 0.00559401512146 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 864, 18
93 0.0016 0.0015730857849121 
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
94 0.0014 0.0013551712036133 
SELECT * FROM product_image_select WHERE product_id = '4904'
95 0.0011 0.0010890960693359 
SELECT * FROM productcustomimages WHERE product_id = '4904'
96 0.0019 0.0018820762634277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
97 0.0015 0.0014541149139404 
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.0005180835723877 
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0006 0.00057291984558105 
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0005 0.0004730224609375 
SELECT * FROM productimages WHERE product_id = '1937' ORDER BY sortorder ASC
101 0.0006 0.00061798095703125 
SELECT * FROM product_image_select WHERE product_id = '1937'
102 0.0005 0.00045013427734375 
SELECT * FROM productcustomimages WHERE product_id = '1937'
103 0.0009 0.00087904930114746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1937' AND a.name = n.originalname
104 0.0004 0.00042486190795898 
SELECT * FROM productoffers WHERE product_id = '1937' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0003 0.00032901763916016 
SELECT * FROM productoffers
                WHERE product_id = '1937' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0004 0.00035881996154785 
SELECT * FROM productoffers
                WHERE product_id = 1937
                ORDER BY price ASC LIMIT 1
107 0.0003 0.0003199577331543 
SELECT value FROM productattributes
                WHERE product_id = '1937'
                AND name = 'ListPriceAmount'
108 0.0004 0.00037598609924316 
SELECT value FROM productattributes WHERE product_id = '1937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0004 0.00036787986755371 
SELECT * FROM productimages WHERE product_id = '1939' ORDER BY sortorder ASC
110 0.0006 0.00059294700622559 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1939' AND p.id = pi.product_id ORDER BY pi.sortorder
111 0.0006 0.00063014030456543 
SELECT * FROM product_image_select WHERE product_id = '1939'
112 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '1939'
113 0.0004 0.00043797492980957 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1939'
                GROUP BY o.product_id
114 0.0023 0.0022850036621094 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
115 0.0004 0.0004420280456543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
116 0.0010 0.0010168552398682 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1939' AND a.name = n.originalname
117 0.0003 0.0003349781036377 
SELECT * FROM productoffers WHERE product_id = '1939' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0003 0.00029587745666504 
SELECT * FROM productoffers
                WHERE product_id = '1939' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.00027823448181152 
SELECT * FROM productoffers
                WHERE product_id = 1939
                ORDER BY price ASC LIMIT 1
120 0.0003 0.00031590461730957 
SELECT value FROM productattributes
                WHERE product_id = '1939'
                AND name = 'ListPriceAmount'
121 0.0004 0.0004119873046875 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1939'
                GROUP BY o.product_id
122 0.0005 0.00050783157348633 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
123 0.0003 0.00030708312988281 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
124 0.0005 0.00045919418334961 
SELECT value FROM productattributes WHERE product_id = '1939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0003 0.00032687187194824 
SELECT * FROM products WHERE parent_id = '1939'
126 0.0004 0.00041818618774414 
SELECT * FROM productimages WHERE product_id = '1993' ORDER BY sortorder ASC
127 0.0006 0.00055503845214844 
SELECT * FROM product_image_select WHERE product_id = '1993'
128 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '1993'
129 0.0009 0.00094485282897949 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1993' AND a.name = n.originalname
130 0.0004 0.00042891502380371 
SELECT * FROM productoffers WHERE product_id = '1993' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0003 0.00032901763916016 
SELECT * FROM productoffers
                WHERE product_id = '1993' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0003 0.00031805038452148 
SELECT * FROM productoffers
                WHERE product_id = 1993
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00035405158996582 
SELECT value FROM productattributes
                WHERE product_id = '1993'
                AND name = 'ListPriceAmount'
134 0.0004 0.00036096572875977 
SELECT value FROM productattributes WHERE product_id = '1993' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00051116943359375 
SELECT * FROM productimages WHERE product_id = '1943' ORDER BY sortorder ASC
136 0.0005 0.00054192543029785 
SELECT * FROM product_image_select WHERE product_id = '1943'
137 0.0004 0.00043392181396484 
SELECT * FROM productcustomimages WHERE product_id = '1943'
138 0.0008 0.00081610679626465 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1943' AND a.name = n.originalname
139 0.0004 0.00042486190795898 
SELECT * FROM productoffers WHERE product_id = '1943' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = '1943' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0010 0.00095391273498535 
SELECT * FROM productoffers
                WHERE product_id = 1943
                ORDER BY price ASC LIMIT 1
142 0.0008 0.00078201293945312 
SELECT value FROM productattributes
                WHERE product_id = '1943'
                AND name = 'ListPriceAmount'
143 0.0009 0.00089097023010254 
SELECT value FROM productattributes WHERE product_id = '1943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0009 0.00093197822570801 
SELECT * FROM productimages WHERE product_id = '1945' ORDER BY sortorder ASC
145 0.0013 0.0013360977172852 
SELECT * FROM product_image_select WHERE product_id = '1945'
146 0.0008 0.00077104568481445 
SELECT * FROM productcustomimages WHERE product_id = '1945'
147 0.0022 0.0022139549255371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1945' AND a.name = n.originalname
148 0.0009 0.00092506408691406 
SELECT * FROM productoffers WHERE product_id = '1945' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0008 0.00076413154602051 
SELECT * FROM productoffers
                WHERE product_id = '1945' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0007 0.00074386596679688 
SELECT value FROM productattributes WHERE product_id = '1945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0008 0.00079011917114258 
SELECT * FROM productimages WHERE product_id = '2017' ORDER BY sortorder ASC
152 0.0011 0.001105785369873 
SELECT * FROM product_image_select WHERE product_id = '2017'
153 0.0006 0.0005650520324707 
SELECT * FROM productcustomimages WHERE product_id = '2017'
154 0.0016 0.0015709400177002 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2017' AND a.name = n.originalname
155 0.0007 0.00072216987609863 
SELECT * FROM productoffers WHERE product_id = '2017' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0006 0.0005500316619873 
SELECT * FROM productoffers
                WHERE product_id = '2017' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0005 0.00047993659973145 
SELECT * FROM productoffers
                WHERE product_id = 2017
                ORDER BY price ASC LIMIT 1
158 0.0006 0.00061392784118652 
SELECT value FROM productattributes
                WHERE product_id = '2017'
                AND name = 'ListPriceAmount'
159 0.0007 0.0007328987121582 
SELECT value FROM productattributes WHERE product_id = '2017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0008 0.00082612037658691 
SELECT * FROM productimages WHERE product_id = '2249' ORDER BY sortorder ASC
161 0.0012 0.0011520385742188 
SELECT * FROM product_image_select WHERE product_id = '2249'
162 0.0006 0.00059795379638672 
SELECT * FROM productcustomimages WHERE product_id = '2249'
163 0.0012 0.0012178421020508 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2249' AND a.name = n.originalname
164 0.0006 0.000640869140625 
SELECT * FROM productoffers WHERE product_id = '2249' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00046491622924805 
SELECT * FROM productoffers
                WHERE product_id = '2249' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00038886070251465 
SELECT * FROM productoffers
                WHERE product_id = 2249
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00049686431884766 
SELECT value FROM productattributes
                WHERE product_id = '2249'
                AND name = 'ListPriceAmount'
168 0.0005 0.00054597854614258 
SELECT value FROM productattributes WHERE product_id = '2249' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0006 0.0006098747253418 
SELECT * FROM productimages WHERE product_id = '2014' ORDER BY sortorder ASC
170 0.0008 0.00084710121154785 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2014' AND p.id = pi.product_id ORDER BY pi.sortorder
171 0.0008 0.00083398818969727 
SELECT * FROM product_image_select WHERE product_id = '2014'
172 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '2014'
173 0.0008 0.00075507164001465 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2014'
                GROUP BY o.product_id
174 0.0009 0.00091910362243652 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2014'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0005 0.00047492980957031 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2014
176 0.0011 0.0010850429534912 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2014' AND a.name = n.originalname
177 0.0004 0.00042104721069336 
SELECT * FROM productoffers WHERE product_id = '2014' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00037217140197754 
SELECT * FROM productoffers
                WHERE product_id = '2014' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00033998489379883 
SELECT * FROM productoffers
                WHERE product_id = 2014
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00039100646972656 
SELECT value FROM productattributes
                WHERE product_id = '2014'
                AND name = 'ListPriceAmount'
181 0.0005 0.00046110153198242 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2014'
                GROUP BY o.product_id
182 0.0007 0.00070619583129883 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2014'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
183 0.0004 0.00044608116149902 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2014
184 0.0006 0.00059914588928223 
SELECT value FROM productattributes WHERE product_id = '2014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0009 0.00086092948913574 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2014'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'ItemDisplayHeight'
                GROUP BY o.value
                ORDER BY o.value ASC
186 0.0004 0.00043487548828125 
SELECT * FROM products WHERE parent_id = '2014'
187 0.0007 0.00065994262695312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2015' AND a.name = n.originalname
188 0.0005 0.00051403045654297 
SELECT * FROM productoffers WHERE product_id = '2015' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0004 0.00040483474731445 
SELECT * FROM productoffers
                WHERE product_id = '2015' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = 2015
                ORDER BY price ASC LIMIT 1
191 0.0004 0.00040006637573242 
SELECT value FROM productattributes
                WHERE product_id = '2015'
                AND name = 'ListPriceAmount'
192 0.0005 0.00053787231445312 
SELECT * FROM productimages WHERE product_id = '2023' ORDER BY sortorder ASC
193 0.0007 0.00069618225097656 
SELECT * FROM product_image_select WHERE product_id = '2023'
194 0.0004 0.00042986869812012 
SELECT * FROM productcustomimages WHERE product_id = '2023'
195 0.0008 0.00081992149353027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2023' AND a.name = n.originalname
196 0.0005 0.00050592422485352 
SELECT * FROM productoffers WHERE product_id = '2023' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0004 0.00041890144348145 
SELECT * FROM productoffers
                WHERE product_id = '2023' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0003 0.00034379959106445 
SELECT * FROM productoffers
                WHERE product_id = 2023
                ORDER BY price ASC LIMIT 1
199 0.0004 0.0003659725189209 
SELECT value FROM productattributes
                WHERE product_id = '2023'
                AND name = 'ListPriceAmount'
200 0.0004 0.00044918060302734 
SELECT value FROM productattributes WHERE product_id = '2023' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0004 0.00040888786315918 
SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
202 0.0006 0.00058317184448242 
SELECT * FROM product_image_select WHERE product_id = '2021'
203 0.0004 0.00036883354187012 
SELECT * FROM productcustomimages WHERE product_id = '2021'
204 0.0009 0.00094509124755859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
205 0.0005 0.00046992301940918 
SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = '2021' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 2021
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00034904479980469 
SELECT value FROM productattributes
                WHERE product_id = '2021'
                AND name = 'ListPriceAmount'
209 0.0004 0.00040388107299805 
SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0004 0.00041389465332031 
SELECT * FROM productimages WHERE product_id = '2024' ORDER BY sortorder ASC
211 0.0006 0.00059604644775391 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2024' AND p.id = pi.product_id ORDER BY pi.sortorder
212 0.0006 0.00058221817016602 
SELECT * FROM product_image_select WHERE product_id = '2024'
213 0.0005 0.00045299530029297 
SELECT * FROM productcustomimages WHERE product_id = '2024'
214 0.0005 0.00050592422485352 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2024'
                GROUP BY o.product_id
215 0.0007 0.00068187713623047 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
216 0.0004 0.00037097930908203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2024
217 0.0008 0.00077295303344727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2024' AND a.name = n.originalname
218 0.0004 0.00039482116699219 
SELECT * FROM productoffers WHERE product_id = '2024' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '2024' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.00030994415283203 
SELECT * FROM productoffers
                WHERE product_id = 2024
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00044608116149902 
SELECT value FROM productattributes
                WHERE product_id = '2024'
                AND name = 'ListPriceAmount'
222 0.0005 0.0004580020904541 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2024'
                GROUP BY o.product_id
223 0.0007 0.00066900253295898 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
224 0.0004 0.00037503242492676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2024
225 0.0005 0.00051593780517578 
SELECT value FROM productattributes WHERE product_id = '2024' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00060582160949707 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
227 0.0005 0.00047206878662109 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
228 0.0004 0.00042915344238281 
SELECT * FROM products WHERE parent_id = '2024'
229 0.0005 0.00052785873413086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2846' AND a.name = n.originalname
230 0.0005 0.00047683715820312 
SELECT * FROM productoffers WHERE product_id = '2846' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00041079521179199 
SELECT * FROM productoffers
                WHERE product_id = '2846' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0005 0.00048398971557617 
SELECT * FROM productimages WHERE product_id = '2241' ORDER BY sortorder ASC
233 0.0005 0.00054502487182617 
SELECT * FROM product_image_select WHERE product_id = '2241'
234 0.0004 0.00042390823364258 
SELECT * FROM productcustomimages WHERE product_id = '2241'
235 0.0008 0.00076913833618164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2241' AND a.name = n.originalname
236 0.0006 0.00058698654174805 
SELECT * FROM productoffers WHERE product_id = '2241' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00036215782165527 
SELECT * FROM productoffers
                WHERE product_id = '2241' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00044894218444824 
SELECT * FROM productoffers
                WHERE product_id = 2241
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00041413307189941 
SELECT value FROM productattributes
                WHERE product_id = '2241'
                AND name = 'ListPriceAmount'
240 0.0004 0.00039291381835938 
SELECT value FROM productattributes WHERE product_id = '2241' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0005 0.00052809715270996 
SELECT * FROM productimages WHERE product_id = '2134' ORDER BY sortorder ASC
242 0.0006 0.00056815147399902 
SELECT * FROM product_image_select WHERE product_id = '2134'
243 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '2134'
244 0.0007 0.00071620941162109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2134' AND a.name = n.originalname
245 0.0004 0.00044012069702148 
SELECT * FROM productoffers WHERE product_id = '2134' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00043916702270508 
SELECT * FROM productoffers
                WHERE product_id = '2134' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00040006637573242 
SELECT * FROM productoffers
                WHERE product_id = 2134
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00039386749267578 
SELECT value FROM productattributes
                WHERE product_id = '2134'
                AND name = 'ListPriceAmount'
249 0.0004 0.00039792060852051 
SELECT value FROM productattributes WHERE product_id = '2134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0005 0.00049495697021484 
SELECT * FROM productimages WHERE product_id = '2074' ORDER BY sortorder ASC
251 0.0008 0.00076889991760254 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2074' AND p.id = pi.product_id ORDER BY pi.sortorder
252 0.0005 0.00053501129150391 
SELECT * FROM product_image_select WHERE product_id = '2074'
253 0.0004 0.00039196014404297 
SELECT * FROM productcustomimages WHERE product_id = '2074'
254 0.0006 0.00055694580078125 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2074'
                GROUP BY o.product_id
255 0.0007 0.00065207481384277 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
256 0.0004 0.00044107437133789 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
257 0.0007 0.00072693824768066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2074' AND a.name = n.originalname
258 0.0004 0.00035595893859863 
SELECT * FROM productoffers WHERE product_id = '2074' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00038719177246094 
SELECT * FROM productoffers
                WHERE product_id = '2074' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 2074
                ORDER BY price ASC LIMIT 1
261 0.0005 0.0004570484161377 
SELECT value FROM productattributes
                WHERE product_id = '2074'
                AND name = 'ListPriceAmount'
262 0.0004 0.00043416023254395 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2074'
                GROUP BY o.product_id
263 0.0007 0.00069904327392578 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
264 0.0004 0.0004119873046875 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
265 0.0005 0.00054001808166504 
SELECT value FROM productattributes WHERE product_id = '2074' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0007 0.00065803527832031 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2074'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
267 0.0005 0.00046300888061523 
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
268 0.0006 0.0005650520324707 
SELECT * FROM product_image_select WHERE product_id = '2521'
269 0.0004 0.00038313865661621 
SELECT * FROM productcustomimages WHERE product_id = '2521'
270 0.0008 0.00081801414489746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
271 0.0005 0.00046706199645996 
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0004 0.00042891502380371 
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0005 0.00045108795166016 
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0004 0.00044894218444824 
SELECT * FROM productimages WHERE product_id = '2100' ORDER BY sortorder ASC
275 0.0006 0.00057792663574219 
SELECT * FROM product_image_select WHERE product_id = '2100'
276 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '2100'
277 0.0007 0.0007321834564209 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2100' AND a.name = n.originalname
278 0.0005 0.0004889965057373 
SELECT * FROM productoffers WHERE product_id = '2100' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = '2100' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00031709671020508 
SELECT * FROM productoffers
                WHERE product_id = 2100
                ORDER BY price ASC LIMIT 1
281 0.0004 0.0003659725189209 
SELECT value FROM productattributes
                WHERE product_id = '2100'
                AND name = 'ListPriceAmount'
282 0.0004 0.00036287307739258 
SELECT value FROM productattributes WHERE product_id = '2100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0005 0.00050020217895508 
SELECT * FROM productimages WHERE product_id = '2102' ORDER BY sortorder ASC
284 0.0005 0.00054287910461426 
SELECT * FROM product_image_select WHERE product_id = '2102'
285 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '2102'
286 0.0009 0.00085997581481934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2102' AND a.name = n.originalname
287 0.0004 0.00044393539428711 
SELECT * FROM productoffers WHERE product_id = '2102' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0004 0.00036787986755371 
SELECT * FROM productoffers
                WHERE product_id = '2102' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0004 0.0003960132598877 
SELECT value FROM productattributes WHERE product_id = '2102' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0015 0.0015020370483398 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
291 0.0004 0.00042486190795898 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1937' ORDER BY timestamp DESC
292 0.0004 0.00035691261291504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1939' ORDER BY timestamp DESC
293 0.0003 0.00032997131347656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1993' ORDER BY timestamp DESC
294 0.0003 0.00033807754516602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1943' ORDER BY timestamp DESC
295 0.0007 0.0006558895111084 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1945' ORDER BY timestamp DESC
296 0.0005 0.00050783157348633 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2017' ORDER BY timestamp DESC
297 0.0004 0.00042200088500977 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2249' ORDER BY timestamp DESC
298 0.0005 0.00048089027404785 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2014' ORDER BY timestamp DESC
299 0.0004 0.00042009353637695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2023' ORDER BY timestamp DESC
300 0.0005 0.00048613548278809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2021' ORDER BY timestamp DESC
301 0.0004 0.0004119873046875 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2024' ORDER BY timestamp DESC
302 0.0005 0.0005190372467041 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2241' ORDER BY timestamp DESC
303 0.0005 0.00052595138549805 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2134' ORDER BY timestamp DESC
304 0.0006 0.00061988830566406 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2074' ORDER BY timestamp DESC
305 0.0006 0.00057387351989746 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2521' ORDER BY timestamp DESC
306 0.0006 0.00055384635925293 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2100' ORDER BY timestamp DESC
307 0.0006 0.00058794021606445 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2102' ORDER BY timestamp DESC
308 0.0035 0.0035169124603271 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
309 0.0029 0.0028738975524902 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
310 0.0006 0.00060105323791504 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
311 0.0234 0.023449182510376 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
312 0.0019 0.0018599033355713 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
313 0.0006 0.00061583518981934 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
314 0.0005 0.00048995018005371 
SELECT * FROM products WHERE id = 1626
315 0.0004 0.00038790702819824 
SELECT * FROM products WHERE id = 4041
316 0.0004 0.00037288665771484 
SELECT * FROM products WHERE id = 4312
317 0.0004 0.00035500526428223 
SELECT * FROM products WHERE id = 777
318 0.0004 0.00036191940307617 
SELECT * FROM products WHERE id = 3881
319 0.0004 0.00044894218444824 
SELECT * FROM products WHERE id = 4213
320 0.0004 0.00038003921508789 
SELECT * FROM products WHERE id = '1626'
321 0.0005 0.00050497055053711 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
322 0.0007 0.00065493583679199 
SELECT * FROM product_image_select WHERE product_id = '1626'
323 0.0005 0.00047516822814941 
SELECT * FROM productcustomimages WHERE product_id = '1626'
324 0.0009 0.00090789794921875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
325 0.0006 0.0005948543548584 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
326 0.0005 0.00051403045654297 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
327 0.0006 0.00055813789367676 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0006 0.00064301490783691 
SELECT * FROM products WHERE id = '4041'
329 0.0006 0.00055599212646484 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
330 0.0008 0.00075697898864746 
SELECT * FROM product_image_select WHERE product_id = '4041'
331 0.0005 0.00047492980957031 
SELECT * FROM productcustomimages WHERE product_id = '4041'
332 0.0016 0.0016319751739502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
333 0.0005 0.00054693222045898 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
334 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
335 0.0004 0.00042295455932617 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336 0.0005 0.00053286552429199 
SELECT * FROM products WHERE id = '4312'
337 0.0004 0.00042986869812012 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
338 0.0006 0.00058889389038086 
SELECT * FROM product_image_select WHERE product_id = '4312'
339 0.0004 0.00039386749267578 
SELECT * FROM productcustomimages WHERE product_id = '4312'
340 0.0011 0.0011248588562012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
341 0.0005 0.00049185752868652 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
342 0.0004 0.00040817260742188 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
343 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0006 0.00064682960510254 
SELECT * FROM products WHERE id = '777'
345 0.0006 0.00062417984008789 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
346 0.0007 0.00073909759521484 
SELECT * FROM product_image_select WHERE product_id = '777'
347 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '777'
348 0.0017 0.0016989707946777 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
349 0.0006 0.00057291984558105 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
350 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
351 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352 0.0006 0.00057291984558105 
SELECT * FROM products WHERE id = '3881'
353 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
354 0.0006 0.00057411193847656 
SELECT * FROM product_image_select WHERE product_id = '3881'
355 0.0004 0.00044703483581543 
SELECT * FROM productcustomimages WHERE product_id = '3881'
356 0.0011 0.0011179447174072 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
357 0.0005 0.00051689147949219 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
358 0.0005 0.00047707557678223 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
359 0.0005 0.00046896934509277 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0005 0.00050616264343262 
SELECT * FROM products WHERE id = '4213'
361 0.0005 0.00051498413085938 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
362 0.0006 0.00057291984558105 
SELECT * FROM product_image_select WHERE product_id = '4213'
363 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '4213'
364 0.0016 0.0015609264373779 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
365 0.0006 0.0006248950958252 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
366 0.0005 0.00048708915710449 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
367 0.0005 0.00046992301940918 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0026 0.0026040077209473 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
369 0.0008 0.00078797340393066 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
370 0.0026 0.0026440620422363 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
371 0.0022 0.0021588802337646 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
372 0.0006 0.00062298774719238 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
373 0.0005 0.00053095817565918 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
374 0.0006 0.00057196617126465 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'