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.8264949321747 359 1.2132 0


No Amazon API Requests Made.


App Debug - Total Time 1.8264949321747 seconds

Number Time From Start Name Description
1 0.44552206993103 Initialise Initialise FSB Function
2 0.45081901550293 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4913170337677 Start of getCategoryListByGroup Function Before first category groups query
4 0.49336695671082 After initial query Before first category groups query
5 0.49336791038513 Get Category List for Group Before the call to getCategoryList function
6 0.49337005615234 Start of GetCategoryList function Start of the function
7 0.49337291717529 Before getting categories Query to get specific category list
8 0.49525284767151 After getting categories Query to get specific category list
9 0.49525284767151 Before getting category custom Before call to function getCategoryCustom
10 0.52008605003357 After getting category custom After call to function getCategoryCustom
11 0.5200879573822 Before getting category custom Before call to function getCategoryCustom
12 0.53308200836182 After getting category custom After call to function getCategoryCustom
13 0.53308391571045 Before getting category custom Before call to function getCategoryCustom
14 0.53892302513123 After getting category custom After call to function getCategoryCustom
15 0.53892493247986 Before getting category custom Before call to function getCategoryCustom
16 0.54310297966003 After getting category custom After call to function getCategoryCustom
17 0.54310393333435 Before getting category custom Before call to function getCategoryCustom
18 0.54714202880859 After getting category custom After call to function getCategoryCustom
19 0.54714393615723 Before getting category custom Before call to function getCategoryCustom
20 0.55123805999756 After getting category custom After call to function getCategoryCustom
21 0.55123996734619 End of GetCategoryList function End of the function
22 0.55124497413635 Get Category List for Group Before the call to getCategoryList function
23 0.55124592781067 Start of GetCategoryList function Start of the function
24 0.55124807357788 Before getting categories Query to get specific category list
25 0.55169486999512 End of getCategoryListByGroup Function Before return()
26 1.3961899280548 App Controller End End of the App controller (called before the controller of every page)
27 1.5977990627289 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5997960567474 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.6013939380646 Before Get Options Before the call to getOptions in the tpl class
30 1.6744229793549 After Get Options After the call to getOptions in the tpl class
31 1.6745400428772 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.8264849185944 Finalizing debug Before the debug is output to the page.
33 1.8264949321747 End of App This is the end of the app logging, final timestamp


Query Debug - 359 Database Queries. Total time 1.2132 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0021090507507324 
SELECT parameter, value FROM parameters
2 0.0075 0.0074942111968994 
SELECT * FROM `bad_bots`
3 0.0005 0.00045204162597656 
SET time_zone = 'Europe/London'
4 0.0028 0.0028181076049805 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0032 0.0031900405883789 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.117.129.72\";}'
6 0.0041 0.0041229724884033 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746410829'
7 0.0038 0.0038459300994873 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00068497657775879 
UPDATE autorun SET lastrun = '2025-05-05 02:07:09' WHERE id = '8'
9 0.0008 0.00082015991210938 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0033 0.0033180713653564 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0006 0.00063490867614746 
SELECT * FROM pages WHERE id = 37
12 0.0054 0.0053858757019043 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0342 0.034167051315308 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00063896179199219 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0020 0.0020408630371094 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0019 0.001863956451416 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0096 0.0095920562744141 
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.0017349720001221 
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.0011770725250244 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00042319297790527 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0057 0.0057499408721924 
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.0020 0.0020370483398438 
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.0017 0.001723051071167 
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.0019 0.00187087059021 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00043797492980957 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0047 0.0047121047973633 
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.0006 0.00061988830566406 
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.0006 0.00063109397888184 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00049090385437012 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0044479370117188 
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.0005 0.00052189826965332 
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.0007 0.00070691108703613 
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.0004 0.00044584274291992 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00036001205444336 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0014090538024902 
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.00048995018005371 
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.00035595893859863 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.0003819465637207 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0014 0.0014159679412842 
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.00047183036804199 
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.0005 0.00046205520629883 
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.0004 0.00043487548828125 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00037407875061035 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00051999092102051 
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.0004 0.00044417381286621 
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.0004 0.00041604042053223 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00038003921508789 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00062704086303711 
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.00050210952758789 
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.00045204162597656 
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.0004 0.00040793418884277 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00038814544677734 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00052690505981445 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0004 0.00042510032653809 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00034499168395996 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00035691261291504 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.0006110668182373 
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.0004 0.0004420280456543 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0005 0.00048589706420898 
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.00043201446533203 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00036811828613281 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00055503845214844 
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.0004 0.00043797492980957 
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.00037312507629395 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00036096572875977 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00064301490783691 
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.0004 0.00043797492980957 
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.0005 0.0004570484161377 
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.0004 0.00040888786315918 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00039196014404297 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.0004429817199707 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0027 0.0027401447296143 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0016 0.0016109943389893 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00051999092102051 
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.0012 0.0012218952178955 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0011370182037354 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00079607963562012 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8294 0.82944512367249 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.129.72') >= INET_ATON(ip_start) AND INET_ATON('18.117.129.72') <= INET_ATON(ip_end)
79 0.0029 0.002856969833374 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0013 0.0013229846954346 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0043 0.0043439865112305 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0179 0.017930030822754 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0039 0.0039379596710205 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0020 0.0020339488983154 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0072 0.0072019100189209 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0017 0.0016689300537109 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00050091743469238 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0055 0.0055267810821533 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0059 0.0059270858764648 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0015 0.0014598369598389 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00050210952758789 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0061 0.0060920715332031 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 882, 18
93 0.0015 0.0015280246734619 
SELECT * FROM productimages WHERE product_id = '2103' ORDER BY sortorder ASC
94 0.0005 0.00051093101501465 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2103' AND p.id = pi.product_id ORDER BY pi.sortorder
95 0.0015 0.0014989376068115 
SELECT * FROM product_image_select WHERE product_id = '2103'
96 0.0011 0.0010850429534912 
SELECT * FROM productcustomimages WHERE product_id = '2103'
97 0.0014 0.001413106918335 
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 = '2103'
                GROUP BY o.product_id
98 0.0025 0.0024559497833252 
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     = '2103'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
99 0.0005 0.00047206878662109 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2103
100 0.0020 0.0020101070404053 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2103' AND a.name = n.originalname
101 0.0005 0.00048303604125977 
SELECT * FROM productoffers WHERE product_id = '2103' AND merchantid = 'A1X6FK5RDHNB96'
102 0.0004 0.00036287307739258 
SELECT * FROM productoffers
                WHERE product_id = '2103' AND price > 0
                ORDER BY price ASC LIMIT 1
103 0.0004 0.00037407875061035 
SELECT * FROM productoffers
                WHERE product_id = 2103
                ORDER BY price ASC LIMIT 1
104 0.0004 0.00040793418884277 
SELECT value FROM productattributes
                WHERE product_id = '2103'
                AND name = 'ListPriceAmount'
105 0.0006 0.0006110668182373 
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 = '2103'
                GROUP BY o.product_id
106 0.0007 0.00070500373840332 
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     = '2103'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
107 0.0004 0.00044703483581543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2103
108 0.0005 0.00053906440734863 
SELECT value FROM productattributes WHERE product_id = '2103' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0004 0.00037598609924316 
SELECT * FROM products WHERE parent_id = '2103'
110 0.0005 0.00045013427734375 
SELECT * FROM productimages WHERE product_id = '2104' ORDER BY sortorder ASC
111 0.0006 0.0005800724029541 
SELECT * FROM product_image_select WHERE product_id = '2104'
112 0.0004 0.00039291381835938 
SELECT * FROM productcustomimages WHERE product_id = '2104'
113 0.0013 0.0012760162353516 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2104' AND a.name = n.originalname
114 0.0007 0.00066804885864258 
SELECT * FROM productoffers WHERE product_id = '2104' AND merchantid = 'A1X6FK5RDHNB96'
115 0.0004 0.00039792060852051 
SELECT * FROM productoffers
                WHERE product_id = '2104' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = 2104
                ORDER BY price ASC LIMIT 1
117 0.0004 0.00041294097900391 
SELECT value FROM productattributes
                WHERE product_id = '2104'
                AND name = 'ListPriceAmount'
118 0.0005 0.00046586990356445 
SELECT value FROM productattributes WHERE product_id = '2104' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '2108' ORDER BY sortorder ASC
120 0.0006 0.00058507919311523 
SELECT * FROM product_image_select WHERE product_id = '2108'
121 0.0005 0.00047898292541504 
SELECT * FROM productcustomimages WHERE product_id = '2108'
122 0.0007 0.00074410438537598 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2108' AND a.name = n.originalname
123 0.0004 0.00042581558227539 
SELECT * FROM productoffers WHERE product_id = '2108' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0003 0.00032210350036621 
SELECT * FROM productoffers
                WHERE product_id = '2108' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00031518936157227 
SELECT * FROM productoffers
                WHERE product_id = 2108
                ORDER BY price ASC LIMIT 1
126 0.0004 0.00035715103149414 
SELECT value FROM productattributes
                WHERE product_id = '2108'
                AND name = 'ListPriceAmount'
127 0.0004 0.00038599967956543 
SELECT value FROM productattributes WHERE product_id = '2108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00047707557678223 
SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
129 0.0006 0.0005500316619873 
SELECT * FROM product_image_select WHERE product_id = '2109'
130 0.0005 0.00045204162597656 
SELECT * FROM productcustomimages WHERE product_id = '2109'
131 0.0009 0.00094819068908691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
132 0.0004 0.0004270076751709 
SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00035214424133301 
SELECT * FROM productoffers
                WHERE product_id = '2109' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00031805038452148 
SELECT * FROM productoffers
                WHERE product_id = 2109
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00032496452331543 
SELECT value FROM productattributes
                WHERE product_id = '2109'
                AND name = 'ListPriceAmount'
136 0.0004 0.00038313865661621 
SELECT value FROM productattributes WHERE product_id = '2109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00050497055053711 
SELECT * FROM productimages WHERE product_id = '2116' ORDER BY sortorder ASC
138 0.0007 0.00073099136352539 
SELECT * FROM product_image_select WHERE product_id = '2116'
139 0.0004 0.00037407875061035 
SELECT * FROM productcustomimages WHERE product_id = '2116'
140 0.0009 0.00092482566833496 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2116' AND a.name = n.originalname
141 0.0004 0.00040888786315918 
SELECT * FROM productoffers WHERE product_id = '2116' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00036787986755371 
SELECT * FROM productoffers
                WHERE product_id = '2116' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.00037622451782227 
SELECT * FROM productoffers
                WHERE product_id = 2116
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00039911270141602 
SELECT value FROM productattributes
                WHERE product_id = '2116'
                AND name = 'ListPriceAmount'
145 0.0005 0.00050997734069824 
SELECT value FROM productattributes WHERE product_id = '2116' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0005 0.00047016143798828 
SELECT * FROM productimages WHERE product_id = '2117' ORDER BY sortorder ASC
147 0.0006 0.0005791187286377 
SELECT * FROM product_image_select WHERE product_id = '2117'
148 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '2117'
149 0.0008 0.0008089542388916 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2117' AND a.name = n.originalname
150 0.0006 0.0005950927734375 
SELECT * FROM productoffers WHERE product_id = '2117' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '2117' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.0003809928894043 
SELECT value FROM productattributes WHERE product_id = '2117' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.0005040168762207 
SELECT * FROM productimages WHERE product_id = '2199' ORDER BY sortorder ASC
154 0.0006 0.00055694580078125 
SELECT * FROM product_image_select WHERE product_id = '2199'
155 0.0004 0.00040793418884277 
SELECT * FROM productcustomimages WHERE product_id = '2199'
156 0.0007 0.00068092346191406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2199' AND a.name = n.originalname
157 0.0005 0.00049591064453125 
SELECT * FROM productoffers WHERE product_id = '2199' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = '2199' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0003 0.00034093856811523 
SELECT * FROM productoffers
                WHERE product_id = 2199
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00041103363037109 
SELECT value FROM productattributes
                WHERE product_id = '2199'
                AND name = 'ListPriceAmount'
161 0.0005 0.00045585632324219 
SELECT value FROM productattributes WHERE product_id = '2199' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00048089027404785 
SELECT * FROM productimages WHERE product_id = '2132' ORDER BY sortorder ASC
163 0.0007 0.00071597099304199 
SELECT * FROM product_image_select WHERE product_id = '2132'
164 0.0004 0.00040411949157715 
SELECT * FROM productcustomimages WHERE product_id = '2132'
165 0.0013 0.0012779235839844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2132' AND a.name = n.originalname
166 0.0005 0.0005190372467041 
SELECT * FROM productoffers WHERE product_id = '2132' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = '2132' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00046396255493164 
SELECT * FROM productoffers
                WHERE product_id = 2132
                ORDER BY price ASC LIMIT 1
169 0.0004 0.00037002563476562 
SELECT value FROM productattributes
                WHERE product_id = '2132'
                AND name = 'ListPriceAmount'
170 0.0005 0.00050902366638184 
SELECT value FROM productattributes WHERE product_id = '2132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0005 0.00050091743469238 
SELECT * FROM productimages WHERE product_id = '2133' ORDER BY sortorder ASC
172 0.0006 0.00063395500183105 
SELECT * FROM product_image_select WHERE product_id = '2133'
173 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '2133'
174 0.0010 0.0010390281677246 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2133' AND a.name = n.originalname
175 0.0006 0.00064611434936523 
SELECT * FROM productoffers WHERE product_id = '2133' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0005 0.0005040168762207 
SELECT * FROM productoffers
                WHERE product_id = '2133' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0005 0.00046110153198242 
SELECT * FROM productoffers
                WHERE product_id = 2133
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00052499771118164 
SELECT value FROM productattributes
                WHERE product_id = '2133'
                AND name = 'ListPriceAmount'
179 0.0006 0.00055193901062012 
SELECT value FROM productattributes WHERE product_id = '2133' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0006 0.00059700012207031 
SELECT * FROM productimages WHERE product_id = '2136' ORDER BY sortorder ASC
181 0.0007 0.00072503089904785 
SELECT * FROM product_image_select WHERE product_id = '2136'
182 0.0006 0.00056290626525879 
SELECT * FROM productcustomimages WHERE product_id = '2136'
183 0.0012 0.0011789798736572 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2136' AND a.name = n.originalname
184 0.0005 0.00045490264892578 
SELECT * FROM productoffers WHERE product_id = '2136' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00033116340637207 
SELECT * FROM productoffers
                WHERE product_id = '2136' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0005 0.00045108795166016 
SELECT * FROM productoffers
                WHERE product_id = 2136
                ORDER BY price ASC LIMIT 1
187 0.0004 0.0003659725189209 
SELECT value FROM productattributes
                WHERE product_id = '2136'
                AND name = 'ListPriceAmount'
188 0.0004 0.00040102005004883 
SELECT value FROM productattributes WHERE product_id = '2136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0005 0.00049304962158203 
SELECT * FROM productimages WHERE product_id = '2140' ORDER BY sortorder ASC
190 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '2140'
191 0.0004 0.00036001205444336 
SELECT * FROM productcustomimages WHERE product_id = '2140'
192 0.0013 0.0013151168823242 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2140' AND a.name = n.originalname
193 0.0005 0.0004730224609375 
SELECT * FROM productoffers WHERE product_id = '2140' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00031399726867676 
SELECT * FROM productoffers
                WHERE product_id = '2140' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00028300285339355 
SELECT * FROM productoffers
                WHERE product_id = 2140
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00035309791564941 
SELECT value FROM productattributes
                WHERE product_id = '2140'
                AND name = 'ListPriceAmount'
197 0.0004 0.00037884712219238 
SELECT value FROM productattributes WHERE product_id = '2140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0004 0.00040507316589355 
SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
199 0.0005 0.00051116943359375 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
200 0.0005 0.00053000450134277 
SELECT * FROM product_image_select WHERE product_id = '2518'
201 0.0004 0.00035214424133301 
SELECT * FROM productcustomimages WHERE product_id = '2518'
202 0.0004 0.00043582916259766 
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 = '2518'
                GROUP BY o.product_id
203 0.0006 0.00059795379638672 
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
204 0.0004 0.00041890144348145 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
205 0.0014 0.0014419555664062 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
206 0.0004 0.00041389465332031 
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0003 0.00033998489379883 
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0004 0.00035309791564941 
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00033998489379883 
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
210 0.0004 0.0003819465637207 
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 = '2518'
                GROUP BY o.product_id
211 0.0005 0.00052905082702637 
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
212 0.0003 0.00032305717468262 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
213 0.0006 0.00059700012207031 
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0004 0.0003819465637207 
SELECT * FROM products WHERE parent_id = '2518'
215 0.0005 0.00052905082702637 
SELECT * FROM productimages WHERE product_id = '2164' ORDER BY sortorder ASC
216 0.0006 0.00059413909912109 
SELECT * FROM product_image_select WHERE product_id = '2164'
217 0.0004 0.0003969669342041 
SELECT * FROM productcustomimages WHERE product_id = '2164'
218 0.0010 0.0010380744934082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2164' AND a.name = n.originalname
219 0.0006 0.00055694580078125 
SELECT * FROM productoffers WHERE product_id = '2164' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.00036787986755371 
SELECT * FROM productoffers
                WHERE product_id = '2164' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0003 0.00031900405883789 
SELECT * FROM productoffers
                WHERE product_id = 2164
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00037288665771484 
SELECT value FROM productattributes
                WHERE product_id = '2164'
                AND name = 'ListPriceAmount'
223 0.0004 0.0003819465637207 
SELECT value FROM productattributes WHERE product_id = '2164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00046491622924805 
SELECT * FROM productimages WHERE product_id = '2183' ORDER BY sortorder ASC
225 0.0006 0.00055408477783203 
SELECT * FROM product_image_select WHERE product_id = '2183'
226 0.0004 0.00042295455932617 
SELECT * FROM productcustomimages WHERE product_id = '2183'
227 0.0009 0.0008699893951416 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2183' AND a.name = n.originalname
228 0.0005 0.00048398971557617 
SELECT * FROM productoffers WHERE product_id = '2183' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0003 0.00032210350036621 
SELECT * FROM productoffers
                WHERE product_id = '2183' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0003 0.00029492378234863 
SELECT * FROM productoffers
                WHERE product_id = 2183
                ORDER BY price ASC LIMIT 1
231 0.0003 0.0003359317779541 
SELECT value FROM productattributes
                WHERE product_id = '2183'
                AND name = 'ListPriceAmount'
232 0.0004 0.00036311149597168 
SELECT value FROM productattributes WHERE product_id = '2183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0004 0.00038504600524902 
SELECT * FROM productimages WHERE product_id = '2186' ORDER BY sortorder ASC
234 0.0006 0.00057601928710938 
SELECT * FROM product_image_select WHERE product_id = '2186'
235 0.0003 0.00032186508178711 
SELECT * FROM productcustomimages WHERE product_id = '2186'
236 0.0009 0.00094699859619141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2186' AND a.name = n.originalname
237 0.0006 0.00059390068054199 
SELECT * FROM productoffers WHERE product_id = '2186' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00045680999755859 
SELECT * FROM productoffers
                WHERE product_id = '2186' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00043392181396484 
SELECT * FROM productoffers
                WHERE product_id = 2186
                ORDER BY price ASC LIMIT 1
240 0.0004 0.00041294097900391 
SELECT value FROM productattributes
                WHERE product_id = '2186'
                AND name = 'ListPriceAmount'
241 0.0005 0.00047206878662109 
SELECT value FROM productattributes WHERE product_id = '2186' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0006 0.00060796737670898 
SELECT * FROM productimages WHERE product_id = '2192' ORDER BY sortorder ASC
243 0.0012 0.0012421607971191 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2192' AND p.id = pi.product_id ORDER BY pi.sortorder
244 0.0006 0.00064206123352051 
SELECT * FROM product_image_select WHERE product_id = '2192'
245 0.0004 0.00042891502380371 
SELECT * FROM productcustomimages WHERE product_id = '2192'
246 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 = '2192'
                GROUP BY o.product_id
247 0.0008 0.00083589553833008 
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     = '2192'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
248 0.0005 0.00048589706420898 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2192
249 0.0008 0.00084114074707031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2192' AND a.name = n.originalname
250 0.0004 0.00043010711669922 
SELECT * FROM productoffers WHERE product_id = '2192' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0004 0.00043106079101562 
SELECT * FROM productoffers
                WHERE product_id = '2192' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00046515464782715 
SELECT * FROM productoffers
                WHERE product_id = 2192
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00037503242492676 
SELECT value FROM productattributes
                WHERE product_id = '2192'
                AND name = 'ListPriceAmount'
254 0.0004 0.00044989585876465 
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 = '2192'
                GROUP BY o.product_id
255 0.0008 0.00078320503234863 
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     = '2192'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
256 0.0006 0.0005640983581543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2192
257 0.0006 0.00061988830566406 
SELECT value FROM productattributes WHERE product_id = '2192' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0007 0.00072693824768066 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2192'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
259 0.0005 0.00050592422485352 
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
260 0.0007 0.00065803527832031 
SELECT * FROM product_image_select WHERE product_id = '2290'
261 0.0004 0.00038409233093262 
SELECT * FROM productcustomimages WHERE product_id = '2290'
262 0.0011 0.0011310577392578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
263 0.0005 0.00051188468933105 
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0004 0.00040578842163086 
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0005 0.0005040168762207 
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0005 0.00048708915710449 
SELECT * FROM productimages WHERE product_id = '2205' ORDER BY sortorder ASC
267 0.0005 0.00053501129150391 
SELECT * FROM product_image_select WHERE product_id = '2205'
268 0.0003 0.00034403800964355 
SELECT * FROM productcustomimages WHERE product_id = '2205'
269 0.0007 0.00068879127502441 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2205' AND a.name = n.originalname
270 0.0004 0.00041913986206055 
SELECT * FROM productoffers WHERE product_id = '2205' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0003 0.00029587745666504 
SELECT * FROM productoffers
                WHERE product_id = '2205' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00029683113098145 
SELECT * FROM productoffers
                WHERE product_id = 2205
                ORDER BY price ASC LIMIT 1
273 0.0003 0.00029611587524414 
SELECT value FROM productattributes
                WHERE product_id = '2205'
                AND name = 'ListPriceAmount'
274 0.0003 0.00033092498779297 
SELECT value FROM productattributes WHERE product_id = '2205' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0016 0.0015978813171387 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2103' ORDER BY timestamp DESC
276 0.0003 0.00029802322387695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2104' ORDER BY timestamp DESC
277 0.0002 0.00023388862609863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2108' ORDER BY timestamp DESC
278 0.0002 0.0002129077911377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2109' ORDER BY timestamp DESC
279 0.0003 0.00026607513427734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2116' ORDER BY timestamp DESC
280 0.0003 0.00030612945556641 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2117' ORDER BY timestamp DESC
281 0.0003 0.00028300285339355 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2199' ORDER BY timestamp DESC
282 0.0003 0.00026702880859375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2132' ORDER BY timestamp DESC
283 0.0002 0.00022292137145996 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2133' ORDER BY timestamp DESC
284 0.0003 0.0002589225769043 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2136' ORDER BY timestamp DESC
285 0.0003 0.00029206275939941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2140' ORDER BY timestamp DESC
286 0.0003 0.00028300285339355 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
287 0.0003 0.00031685829162598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2164' ORDER BY timestamp DESC
288 0.0003 0.00030303001403809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2183' ORDER BY timestamp DESC
289 0.0003 0.00028395652770996 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2186' ORDER BY timestamp DESC
290 0.0002 0.00023198127746582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2192' ORDER BY timestamp DESC
291 0.0002 0.00023484230041504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2290' ORDER BY timestamp DESC
292 0.0003 0.00027680397033691 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2205' ORDER BY timestamp DESC
293 0.0015 0.0015439987182617 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
294 0.0012 0.0012259483337402 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
295 0.0003 0.00033783912658691 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
296 0.0170 0.017032861709595 
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
297 0.0037 0.0036609172821045 
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
298 0.0020 0.002007007598877 
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
299 0.0005 0.00046992301940918 
SELECT * FROM products WHERE id = 1626
300 0.0003 0.0003211498260498 
SELECT * FROM products WHERE id = 4041
301 0.0003 0.0002899169921875 
SELECT * FROM products WHERE id = 4312
302 0.0003 0.00026798248291016 
SELECT * FROM products WHERE id = 777
303 0.0003 0.00030899047851562 
SELECT * FROM products WHERE id = 3881
304 0.0003 0.00032806396484375 
SELECT * FROM products WHERE id = 4213
305 0.0003 0.00030708312988281 
SELECT * FROM products WHERE id = '1626'
306 0.0004 0.00040793418884277 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
307 0.0005 0.00053596496582031 
SELECT * FROM product_image_select WHERE product_id = '1626'
308 0.0004 0.0003669261932373 
SELECT * FROM productcustomimages WHERE product_id = '1626'
309 0.0007 0.00074005126953125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
310 0.0004 0.00040388107299805 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0003 0.00034785270690918 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0004 0.00035786628723145 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0005 0.00048995018005371 
SELECT * FROM products WHERE id = '4041'
314 0.0004 0.00040316581726074 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
315 0.0005 0.00053000450134277 
SELECT * FROM product_image_select WHERE product_id = '4041'
316 0.0003 0.00031685829162598 
SELECT * FROM productcustomimages WHERE product_id = '4041'
317 0.0013 0.0013000965118408 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
318 0.0004 0.00041413307189941 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0004 0.00037884712219238 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0004 0.00044608116149902 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0005 0.00054192543029785 
SELECT * FROM products WHERE id = '4312'
322 0.0005 0.00047802925109863 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
323 0.0007 0.00065493583679199 
SELECT * FROM product_image_select WHERE product_id = '4312'
324 0.0004 0.00040411949157715 
SELECT * FROM productcustomimages WHERE product_id = '4312'
325 0.0013 0.0012640953063965 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
326 0.0005 0.000518798828125 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0004 0.00037908554077148 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0005 0.00046706199645996 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0005 0.00047802925109863 
SELECT * FROM products WHERE id = '777'
330 0.0005 0.00046992301940918 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
331 0.0006 0.00060391426086426 
SELECT * FROM product_image_select WHERE product_id = '777'
332 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '777'
333 0.0010 0.00097203254699707 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
334 0.0004 0.00043702125549316 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
335 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
336 0.0005 0.00049805641174316 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0005 0.00052285194396973 
SELECT * FROM products WHERE id = '3881'
338 0.0011 0.0010550022125244 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
339 0.0011 0.0011270046234131 
SELECT * FROM product_image_select WHERE product_id = '3881'
340 0.0004 0.00042510032653809 
SELECT * FROM productcustomimages WHERE product_id = '3881'
341 0.0035 0.0034511089324951 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
342 0.0011 0.0011489391326904 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
343 0.0007 0.00066399574279785 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
344 0.0008 0.00076103210449219 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0011 0.0011200904846191 
SELECT * FROM products WHERE id = '4213'
346 0.0011 0.0011019706726074 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
347 0.0013 0.0012898445129395 
SELECT * FROM product_image_select WHERE product_id = '4213'
348 0.0006 0.00059103965759277 
SELECT * FROM productcustomimages WHERE product_id = '4213'
349 0.0025 0.0024590492248535 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
350 0.0008 0.00076103210449219 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
351 0.0009 0.00089693069458008 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
352 0.0008 0.00077986717224121 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353 0.0041 0.0041370391845703 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
354 0.0011 0.0010669231414795 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
355 0.0037 0.0037119388580322 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
356 0.0026 0.0025928020477295 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
357 0.0007 0.00070595741271973 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
358 0.0012 0.0011680126190186 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
359 0.0012 0.0011999607086182 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'