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
2.2863619327545 379 1.2550 0


No Amazon API Requests Made.


App Debug - Total Time 2.2863619327545 seconds

Number Time From Start Name Description
1 0.38830399513245 Initialise Initialise FSB Function
2 0.39665389060974 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45004296302795 Start of getCategoryListByGroup Function Before first category groups query
4 0.45151400566101 After initial query Before first category groups query
5 0.45151495933533 Get Category List for Group Before the call to getCategoryList function
6 0.45151686668396 Start of GetCategoryList function Start of the function
7 0.45151901245117 Before getting categories Query to get specific category list
8 0.45318388938904 After getting categories Query to get specific category list
9 0.45318484306335 Before getting category custom Before call to function getCategoryCustom
10 0.48337888717651 After getting category custom After call to function getCategoryCustom
11 0.48338198661804 Before getting category custom Before call to function getCategoryCustom
12 0.50504493713379 After getting category custom After call to function getCategoryCustom
13 0.50504803657532 Before getting category custom Before call to function getCategoryCustom
14 0.5136878490448 After getting category custom After call to function getCategoryCustom
15 0.51369094848633 Before getting category custom Before call to function getCategoryCustom
16 0.51856184005737 After getting category custom After call to function getCategoryCustom
17 0.5185649394989 Before getting category custom Before call to function getCategoryCustom
18 0.52371501922607 After getting category custom After call to function getCategoryCustom
19 0.52371788024902 Before getting category custom Before call to function getCategoryCustom
20 0.52802896499634 After getting category custom After call to function getCategoryCustom
21 0.52803087234497 End of GetCategoryList function End of the function
22 0.52803802490234 Get Category List for Group Before the call to getCategoryList function
23 0.52803993225098 Start of GetCategoryList function Start of the function
24 0.52804183959961 Before getting categories Query to get specific category list
25 0.52849793434143 End of getCategoryListByGroup Function Before return()
26 1.3463969230652 App Controller End End of the App controller (called before the controller of every page)
27 1.5851209163666 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5859189033508 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.5867419242859 Before Get Options Before the call to getOptions in the tpl class
30 1.6456508636475 After Get Options After the call to getOptions in the tpl class
31 1.6457948684692 App_after Controller End End of the App_after controller (called after the controller of every page)
32 2.2863490581512 Finalizing debug Before the debug is output to the page.
33 2.2863619327545 End of App This is the end of the app logging, final timestamp


Query Debug - 379 Database Queries. Total time 1.2550 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0011911392211914 
SELECT parameter, value FROM parameters
2 0.0075 0.0075271129608154 
SELECT * FROM `bad_bots`
3 0.0005 0.00049805641174316 
SET time_zone = 'Europe/London'
4 0.0031 0.0031349658966064 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0034 0.0034139156341553 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.116.27.229\";}'
6 0.0034 0.0034289360046387 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746500155'
7 0.0033 0.0033340454101562 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00068306922912598 
UPDATE autorun SET lastrun = '2025-05-06 02:55:55' WHERE id = '15'
9 0.0008 0.00075006484985352 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0032 0.0031750202178955 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0006 0.00064682960510254 
SELECT * FROM pages WHERE id = 37
12 0.0073 0.0072660446166992 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0452 0.045208930969238 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00055384635925293 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0015 0.001460075378418 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0016460418701172 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0096 0.0096321105957031 
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.0014 0.0013759136199951 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0015 0.0014998912811279 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00055694580078125 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0129 0.012928009033203 
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.0012 0.0011720657348633 
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.0011 0.0010550022125244 
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.0010 0.00099897384643555 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0009 0.00086402893066406 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0102 0.010203838348389 
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.0008 0.00077509880065918 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00052189826965332 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00058794021606445 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0073 0.0072979927062988 
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.00059103965759277 
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.00058794021606445 
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.00051617622375488 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00049090385437012 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0026 0.0026280879974365 
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.0007 0.00069117546081543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00052690505981445 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0007 0.00071310997009277 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.0020439624786377 
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.00048184394836426 
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.00051498413085938 
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.00042319297790527 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00054311752319336 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00070500373840332 
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.00053095817565918 
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.00046110153198242 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00045204162597656 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00063490867614746 
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.00048708915710449 
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.00049686431884766 
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.0005 0.00051593780517578 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00052189826965332 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0009 0.00091218948364258 
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.00049519538879395 
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.00038790702819824 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.0004580020904541 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0008 0.00079202651977539 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.0005 0.0005490779876709 
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.00049996376037598 
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.0005 0.0005180835723877 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00046992301940918 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00058388710021973 
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.00041604042053223 
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.00036406517028809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00042104721069336 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00069594383239746 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0005 0.00047802925109863 
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.0004580020904541 
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.00041699409484863 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00040578842163086 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00044894218444824 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0015 0.0015499591827393 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0006 0.00059604644775391 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00048208236694336 
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.0004 0.00041103363037109 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0010 0.001032829284668 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00079011917114258 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8107 0.81073498725891 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.116.27.229') >= INET_ATON(ip_start) AND INET_ATON('18.116.27.229') <= INET_ATON(ip_end)
79 0.0011 0.0010519027709961 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0004 0.00042200088500977 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00055694580078125 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0098 0.0097689628601074 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0029 0.0029120445251465 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0007 0.00073599815368652 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0064 0.0063610076904297 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0019 0.0019140243530273 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00052690505981445 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0046 0.0046169757843018 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0052 0.0051858425140381 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0015 0.0015230178833008 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00048398971557617 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0066 0.006641149520874 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 1134, 18
93 0.0006 0.00060606002807617 
SELECT * FROM productimages WHERE product_id = '4311' ORDER BY sortorder ASC
94 0.0007 0.0007328987121582 
SELECT * FROM product_image_select WHERE product_id = '4311'
95 0.0005 0.00049304962158203 
SELECT * FROM productcustomimages WHERE product_id = '4311'
96 0.0014 0.0014410018920898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4311' AND a.name = n.originalname
97 0.0005 0.00053000450134277 
SELECT * FROM productoffers WHERE product_id = '4311' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00047087669372559 
SELECT * FROM productoffers
                WHERE product_id = '4311' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0005 0.0004889965057373 
SELECT value FROM productattributes WHERE product_id = '4311' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0006 0.00057697296142578 
SELECT * FROM productimages WHERE product_id = '4065' ORDER BY sortorder ASC
101 0.0007 0.00066399574279785 
SELECT * FROM product_image_select WHERE product_id = '4065'
102 0.0004 0.00039005279541016 
SELECT * FROM productcustomimages WHERE product_id = '4065'
103 0.0009 0.00088286399841309 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4065' AND a.name = n.originalname
104 0.0006 0.0006260871887207 
SELECT * FROM productoffers WHERE product_id = '4065' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0004 0.00042104721069336 
SELECT * FROM productoffers
                WHERE product_id = '4065' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0004 0.00037813186645508 
SELECT * FROM productoffers
                WHERE product_id = 4065
                ORDER BY price ASC LIMIT 1
107 0.0004 0.00041913986206055 
SELECT value FROM productattributes
                WHERE product_id = '4065'
                AND name = 'ListPriceAmount'
108 0.0005 0.00051712989807129 
SELECT value FROM productattributes WHERE product_id = '4065' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0005 0.00053620338439941 
SELECT * FROM productimages WHERE product_id = '4075' ORDER BY sortorder ASC
110 0.0007 0.00068211555480957 
SELECT * FROM product_image_select WHERE product_id = '4075'
111 0.0004 0.00042510032653809 
SELECT * FROM productcustomimages WHERE product_id = '4075'
112 0.0013 0.001270055770874 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4075' AND a.name = n.originalname
113 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '4075' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = '4075' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00036787986755371 
SELECT * FROM productoffers
                WHERE product_id = 4075
                ORDER BY price ASC LIMIT 1
116 0.0004 0.00037884712219238 
SELECT value FROM productattributes
                WHERE product_id = '4075'
                AND name = 'ListPriceAmount'
117 0.0005 0.00054693222045898 
SELECT value FROM productattributes WHERE product_id = '4075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0005 0.00052213668823242 
SELECT * FROM productimages WHERE product_id = '4080' ORDER BY sortorder ASC
119 0.0007 0.00066781044006348 
SELECT * FROM product_image_select WHERE product_id = '4080'
120 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '4080'
121 0.0013 0.0013258457183838 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4080' AND a.name = n.originalname
122 0.0006 0.00055217742919922 
SELECT * FROM productoffers WHERE product_id = '4080' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00046610832214355 
SELECT * FROM productoffers
                WHERE product_id = '4080' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0005 0.00045013427734375 
SELECT * FROM productoffers
                WHERE product_id = 4080
                ORDER BY price ASC LIMIT 1
125 0.0005 0.0004730224609375 
SELECT value FROM productattributes
                WHERE product_id = '4080'
                AND name = 'ListPriceAmount'
126 0.0005 0.00045394897460938 
SELECT value FROM productattributes WHERE product_id = '4080' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00051712989807129 
SELECT * FROM productimages WHERE product_id = '4089' ORDER BY sortorder ASC
128 0.0006 0.00060892105102539 
SELECT * FROM product_image_select WHERE product_id = '4089'
129 0.0004 0.00038814544677734 
SELECT * FROM productcustomimages WHERE product_id = '4089'
130 0.0012 0.0012030601501465 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4089' AND a.name = n.originalname
131 0.0004 0.00042009353637695 
SELECT * FROM productoffers WHERE product_id = '4089' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '4089' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = 4089
                ORDER BY price ASC LIMIT 1
134 0.0004 0.0004119873046875 
SELECT value FROM productattributes
                WHERE product_id = '4089'
                AND name = 'ListPriceAmount'
135 0.0004 0.00038886070251465 
SELECT value FROM productattributes WHERE product_id = '4089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00043201446533203 
SELECT * FROM productimages WHERE product_id = '4110' ORDER BY sortorder ASC
137 0.0006 0.00062394142150879 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4110' AND p.id = pi.product_id ORDER BY pi.sortorder
138 0.0006 0.00056314468383789 
SELECT * FROM product_image_select WHERE product_id = '4110'
139 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '4110'
140 0.0005 0.00050997734069824 
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 = '4110'
                GROUP BY o.product_id
141 0.0023 0.0023419857025146 
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     = '4110'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
142 0.0005 0.00049304962158203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4110
143 0.0008 0.00079894065856934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4110' AND a.name = n.originalname
144 0.0004 0.00040221214294434 
SELECT * FROM productoffers WHERE product_id = '4110' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = '4110' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00032210350036621 
SELECT * FROM productoffers
                WHERE product_id = 4110
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00037503242492676 
SELECT value FROM productattributes
                WHERE product_id = '4110'
                AND name = 'ListPriceAmount'
148 0.0006 0.00055503845214844 
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 = '4110'
                GROUP BY o.product_id
149 0.0006 0.0006411075592041 
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     = '4110'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
150 0.0004 0.00037312507629395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4110
151 0.0005 0.00054788589477539 
SELECT value FROM productattributes WHERE product_id = '4110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00062108039855957 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4110'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
153 0.0005 0.0004570484161377 
SELECT * FROM productimages WHERE product_id = '4113' ORDER BY sortorder ASC
154 0.0004 0.00039911270141602 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4113' AND p.id = pi.product_id ORDER BY pi.sortorder
155 0.0006 0.00062990188598633 
SELECT * FROM product_image_select WHERE product_id = '4113'
156 0.0004 0.00040984153747559 
SELECT * FROM productcustomimages WHERE product_id = '4113'
157 0.0005 0.00046896934509277 
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 = '4113'
                GROUP BY o.product_id
158 0.0006 0.0005500316619873 
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     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
159 0.0004 0.00041079521179199 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
160 0.0007 0.00073599815368652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4113' AND a.name = n.originalname
161 0.0003 0.00034189224243164 
SELECT * FROM productoffers WHERE product_id = '4113' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0004 0.00035881996154785 
SELECT * FROM productoffers
                WHERE product_id = '4113' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 4113
                ORDER BY price ASC LIMIT 1
164 0.0004 0.00035190582275391 
SELECT value FROM productattributes
                WHERE product_id = '4113'
                AND name = 'ListPriceAmount'
165 0.0004 0.0003960132598877 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4113'
                GROUP BY o.product_id
166 0.0006 0.00056290626525879 
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     = '4113'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
167 0.0004 0.0003509521484375 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4113
168 0.0005 0.00054693222045898 
SELECT value FROM productattributes WHERE product_id = '4113' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0005 0.00054001808166504 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4113'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
170 0.0004 0.0003819465637207 
SELECT * FROM products WHERE parent_id = '4113'
171 0.0005 0.00048494338989258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4753' AND a.name = n.originalname
172 0.0004 0.00042414665222168 
SELECT * FROM productoffers WHERE product_id = '4753' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = '4753' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0005 0.00047993659973145 
SELECT * FROM productimages WHERE product_id = '4114' ORDER BY sortorder ASC
175 0.0006 0.00063896179199219 
SELECT * FROM product_image_select WHERE product_id = '4114'
176 0.0004 0.00035190582275391 
SELECT * FROM productcustomimages WHERE product_id = '4114'
177 0.0009 0.00090909004211426 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4114' AND a.name = n.originalname
178 0.0004 0.0004270076751709 
SELECT * FROM productoffers WHERE product_id = '4114' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0003 0.00032997131347656 
SELECT * FROM productoffers
                WHERE product_id = '4114' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00050711631774902 
SELECT * FROM productoffers
                WHERE product_id = 4114
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00035405158996582 
SELECT value FROM productattributes
                WHERE product_id = '4114'
                AND name = 'ListPriceAmount'
182 0.0004 0.00043892860412598 
SELECT value FROM productattributes WHERE product_id = '4114' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0004 0.00043296813964844 
SELECT * FROM productimages WHERE product_id = '4116' ORDER BY sortorder ASC
184 0.0006 0.00056099891662598 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4116' AND p.id = pi.product_id ORDER BY pi.sortorder
185 0.0005 0.0005490779876709 
SELECT * FROM product_image_select WHERE product_id = '4116'
186 0.0004 0.00040197372436523 
SELECT * FROM productcustomimages WHERE product_id = '4116'
187 0.0005 0.00047588348388672 
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 = '4116'
                GROUP BY o.product_id
188 0.0008 0.0008080005645752 
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     = '4116'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
189 0.0007 0.00067996978759766 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4116
190 0.0012 0.0012168884277344 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4116' AND a.name = n.originalname
191 0.0007 0.00072312355041504 
SELECT * FROM productoffers WHERE product_id = '4116' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0009 0.00086879730224609 
SELECT * FROM productoffers
                WHERE product_id = '4116' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0006 0.00061488151550293 
SELECT * FROM productoffers
                WHERE product_id = 4116
                ORDER BY price ASC LIMIT 1
194 0.0007 0.00066900253295898 
SELECT value FROM productattributes
                WHERE product_id = '4116'
                AND name = 'ListPriceAmount'
195 0.0004 0.00043201446533203 
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 = '4116'
                GROUP BY o.product_id
196 0.0011 0.0011250972747803 
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     = '4116'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0010 0.00096297264099121 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4116
198 0.0009 0.00086498260498047 
SELECT value FROM productattributes WHERE product_id = '4116' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0011 0.0010538101196289 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4116'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
200 0.0011 0.0011260509490967 
SELECT * FROM productimages WHERE product_id = '4136' ORDER BY sortorder ASC
201 0.0014 0.0013821125030518 
SELECT * FROM product_image_select WHERE product_id = '4136'
202 0.0012 0.0012099742889404 
SELECT * FROM productcustomimages WHERE product_id = '4136'
203 0.0022 0.0021719932556152 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4136' AND a.name = n.originalname
204 0.0017 0.0016779899597168 
SELECT * FROM productoffers WHERE product_id = '4136' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0013 0.0012960433959961 
SELECT * FROM productoffers
                WHERE product_id = '4136' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0014 0.0014450550079346 
SELECT value FROM productattributes WHERE product_id = '4136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0020 0.0019888877868652 
SELECT * FROM productimages WHERE product_id = '4137' ORDER BY sortorder ASC
208 0.0016 0.001633882522583 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4137' AND p.id = pi.product_id ORDER BY pi.sortorder
209 0.0021 0.0020899772644043 
SELECT * FROM product_image_select WHERE product_id = '4137'
210 0.0018 0.0018310546875 
SELECT * FROM productcustomimages WHERE product_id = '4137'
211 0.0027 0.0027079582214355 
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 = '4137'
                GROUP BY o.product_id
212 0.0028 0.0028171539306641 
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     = '4137'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
213 0.0024 0.0024168491363525 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4137
214 0.0036 0.0036261081695557 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4137' AND a.name = n.originalname
215 0.0007 0.00067591667175293 
SELECT * FROM productoffers WHERE product_id = '4137' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0006 0.00059795379638672 
SELECT * FROM productoffers
                WHERE product_id = '4137' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0005 0.00052285194396973 
SELECT * FROM productoffers
                WHERE product_id = 4137
                ORDER BY price ASC LIMIT 1
218 0.0008 0.00081610679626465 
SELECT value FROM productattributes
                WHERE product_id = '4137'
                AND name = 'ListPriceAmount'
219 0.0011 0.0010929107666016 
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 = '4137'
                GROUP BY o.product_id
220 0.0035 0.0034890174865723 
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     = '4137'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
221 0.0032 0.0031919479370117 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4137
222 0.0036 0.003572940826416 
SELECT value FROM productattributes WHERE product_id = '4137' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0040 0.0040431022644043 
SELECT * FROM products WHERE parent_id = '4137'
224 0.0039 0.0038900375366211 
SELECT * FROM productimages WHERE product_id = '4145' ORDER BY sortorder ASC
225 0.0044 0.0043900012969971 
SELECT * FROM product_image_select WHERE product_id = '4145'
226 0.0042 0.0042409896850586 
SELECT * FROM productcustomimages WHERE product_id = '4145'
227 0.0064 0.0064270496368408 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4145' AND a.name = n.originalname
228 0.0013 0.0012550354003906 
SELECT * FROM productoffers WHERE product_id = '4145' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0007 0.0006721019744873 
SELECT * FROM productoffers
                WHERE product_id = '4145' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0006 0.00061488151550293 
SELECT * FROM productoffers
                WHERE product_id = 4145
                ORDER BY price ASC LIMIT 1
231 0.0007 0.00068187713623047 
SELECT value FROM productattributes
                WHERE product_id = '4145'
                AND name = 'ListPriceAmount'
232 0.0009 0.00088000297546387 
SELECT value FROM productattributes WHERE product_id = '4145' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0009 0.00094318389892578 
SELECT * FROM productimages WHERE product_id = '4151' ORDER BY sortorder ASC
234 0.0014 0.0014219284057617 
SELECT * FROM product_image_select WHERE product_id = '4151'
235 0.0007 0.00072312355041504 
SELECT * FROM productcustomimages WHERE product_id = '4151'
236 0.0017 0.0016958713531494 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4151' AND a.name = n.originalname
237 0.0010 0.00095200538635254 
SELECT * FROM productoffers WHERE product_id = '4151' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0007 0.00065898895263672 
SELECT * FROM productoffers
                WHERE product_id = '4151' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0006 0.00057601928710938 
SELECT * FROM productoffers
                WHERE product_id = 4151
                ORDER BY price ASC LIMIT 1
240 0.0007 0.00065898895263672 
SELECT value FROM productattributes
                WHERE product_id = '4151'
                AND name = 'ListPriceAmount'
241 0.0008 0.00082898139953613 
SELECT value FROM productattributes WHERE product_id = '4151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0008 0.00077700614929199 
SELECT * FROM productimages WHERE product_id = '4158' ORDER BY sortorder ASC
243 0.0010 0.0010178089141846 
SELECT * FROM product_image_select WHERE product_id = '4158'
244 0.0006 0.00064992904663086 
SELECT * FROM productcustomimages WHERE product_id = '4158'
245 0.0019 0.0019450187683105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4158' AND a.name = n.originalname
246 0.0007 0.0006709098815918 
SELECT * FROM productoffers WHERE product_id = '4158' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0006 0.00056004524230957 
SELECT * FROM productoffers
                WHERE product_id = '4158' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00043201446533203 
SELECT * FROM productoffers
                WHERE product_id = 4158
                ORDER BY price ASC LIMIT 1
249 0.0005 0.00050497055053711 
SELECT value FROM productattributes
                WHERE product_id = '4158'
                AND name = 'ListPriceAmount'
250 0.0006 0.00060296058654785 
SELECT value FROM productattributes WHERE product_id = '4158' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0007 0.00068306922912598 
SELECT * FROM productimages WHERE product_id = '4159' ORDER BY sortorder ASC
252 0.0009 0.00094699859619141 
SELECT * FROM product_image_select WHERE product_id = '4159'
253 0.0005 0.0005030632019043 
SELECT * FROM productcustomimages WHERE product_id = '4159'
254 0.0017 0.0016698837280273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4159' AND a.name = n.originalname
255 0.0006 0.00058102607727051 
SELECT * FROM productoffers WHERE product_id = '4159' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0004 0.00038719177246094 
SELECT * FROM productoffers
                WHERE product_id = '4159' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00032997131347656 
SELECT * FROM productoffers
                WHERE product_id = 4159
                ORDER BY price ASC LIMIT 1
258 0.0005 0.00045108795166016 
SELECT value FROM productattributes
                WHERE product_id = '4159'
                AND name = 'ListPriceAmount'
259 0.0005 0.00046586990356445 
SELECT value FROM productattributes WHERE product_id = '4159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '4175' ORDER BY sortorder ASC
261 0.0007 0.00070095062255859 
SELECT * FROM product_image_select WHERE product_id = '4175'
262 0.0005 0.00045680999755859 
SELECT * FROM productcustomimages WHERE product_id = '4175'
263 0.0012 0.001187801361084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4175' AND a.name = n.originalname
264 0.0006 0.0006248950958252 
SELECT * FROM productoffers WHERE product_id = '4175' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = '4175' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 4175
                ORDER BY price ASC LIMIT 1
267 0.0004 0.00042104721069336 
SELECT value FROM productattributes
                WHERE product_id = '4175'
                AND name = 'ListPriceAmount'
268 0.0004 0.0004270076751709 
SELECT value FROM productattributes WHERE product_id = '4175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0006 0.00057888031005859 
SELECT * FROM productimages WHERE product_id = '4180' ORDER BY sortorder ASC
270 0.0008 0.00075197219848633 
SELECT * FROM product_image_select WHERE product_id = '4180'
271 0.0004 0.00038981437683105 
SELECT * FROM productcustomimages WHERE product_id = '4180'
272 0.0008 0.00075197219848633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4180' AND a.name = n.originalname
273 0.0004 0.00043082237243652 
SELECT * FROM productoffers WHERE product_id = '4180' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0004 0.00042414665222168 
SELECT * FROM productoffers
                WHERE product_id = '4180' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0003 0.00032591819763184 
SELECT * FROM productoffers
                WHERE product_id = 4180
                ORDER BY price ASC LIMIT 1
276 0.0004 0.00037384033203125 
SELECT value FROM productattributes
                WHERE product_id = '4180'
                AND name = 'ListPriceAmount'
277 0.0004 0.00037813186645508 
SELECT value FROM productattributes WHERE product_id = '4180' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0004 0.00044703483581543 
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
279 0.0005 0.00049090385437012 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
280 0.0006 0.00058102607727051 
SELECT * FROM product_image_select WHERE product_id = '4201'
281 0.0004 0.0003821849822998 
SELECT * FROM productcustomimages WHERE product_id = '4201'
282 0.0005 0.00051689147949219 
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 = '4201'
                GROUP BY o.product_id
283 0.0006 0.00062394142150879 
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     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
284 0.0004 0.00038814544677734 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
285 0.0008 0.00076699256896973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
286 0.0004 0.00036001205444336 
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
289 0.0004 0.00038981437683105 
SELECT value FROM productattributes
                WHERE product_id = '4201'
                AND name = 'ListPriceAmount'
290 0.0004 0.00036096572875977 
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 = '4201'
                GROUP BY o.product_id
291 0.0006 0.00060200691223145 
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     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
292 0.0004 0.00036716461181641 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
293 0.0005 0.00051212310791016 
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0004 0.00035905838012695 
SELECT * FROM products WHERE parent_id = '4201'
295 0.0004 0.00036501884460449 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4311' ORDER BY timestamp DESC
296 0.0003 0.00031805038452148 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4065' ORDER BY timestamp DESC
297 0.0003 0.00029087066650391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4075' ORDER BY timestamp DESC
298 0.0003 0.00028491020202637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4080' ORDER BY timestamp DESC
299 0.0003 0.00027084350585938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4089' ORDER BY timestamp DESC
300 0.0003 0.00029587745666504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4110' ORDER BY timestamp DESC
301 0.0003 0.00027704238891602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4113' ORDER BY timestamp DESC
302 0.0003 0.00026106834411621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4114' ORDER BY timestamp DESC
303 0.0003 0.00028681755065918 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4116' ORDER BY timestamp DESC
304 0.0003 0.00025701522827148 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4136' ORDER BY timestamp DESC
305 0.0003 0.00026488304138184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4137' ORDER BY timestamp DESC
306 0.0003 0.00028085708618164 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4145' ORDER BY timestamp DESC
307 0.0003 0.00027203559875488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4151' ORDER BY timestamp DESC
308 0.0003 0.00030708312988281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4158' ORDER BY timestamp DESC
309 0.0003 0.00034379959106445 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4159' ORDER BY timestamp DESC
310 0.0003 0.00026202201843262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4175' ORDER BY timestamp DESC
311 0.0003 0.00030708312988281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4180' ORDER BY timestamp DESC
312 0.0003 0.00027799606323242 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4201' ORDER BY timestamp DESC
313 0.0005 0.00048708915710449 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
314 0.0004 0.00042486190795898 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
315 0.0004 0.00035405158996582 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
316 0.0128 0.012808084487915 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
317 0.0007 0.00071406364440918 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
318 0.0005 0.00052285194396973 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
319 0.0006 0.00056099891662598 
SELECT * FROM products WHERE id = 1626
320 0.0004 0.00037097930908203 
SELECT * FROM products WHERE id = 4041
321 0.0007 0.00068187713623047 
SELECT * FROM products WHERE id = 4312
322 0.0005 0.00047016143798828 
SELECT * FROM products WHERE id = 777
323 0.0004 0.00038003921508789 
SELECT * FROM products WHERE id = 3881
324 0.0004 0.00042414665222168 
SELECT * FROM products WHERE id = 4213
325 0.0005 0.00051498413085938 
SELECT * FROM products WHERE id = '1626'
326 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
327 0.0008 0.00075006484985352 
SELECT * FROM product_image_select WHERE product_id = '1626'
328 0.0004 0.00041294097900391 
SELECT * FROM productcustomimages WHERE product_id = '1626'
329 0.0009 0.00091314315795898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
330 0.0005 0.00049495697021484 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0004 0.00044393539428711 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0005 0.00049901008605957 
SELECT * FROM products WHERE id = '4041'
334 0.0004 0.00044989585876465 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
335 0.0006 0.00057506561279297 
SELECT * FROM product_image_select WHERE product_id = '4041'
336 0.0004 0.00042009353637695 
SELECT * FROM productcustomimages WHERE product_id = '4041'
337 0.0011 0.0010929107666016 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
338 0.0005 0.00053286552429199 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0004 0.00044488906860352 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0005 0.00048112869262695 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0005 0.00054621696472168 
SELECT * FROM products WHERE id = '4312'
342 0.0004 0.00041294097900391 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
343 0.0006 0.00062012672424316 
SELECT * FROM product_image_select WHERE product_id = '4312'
344 0.0005 0.00045895576477051 
SELECT * FROM productcustomimages WHERE product_id = '4312'
345 0.0010 0.0010290145874023 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
346 0.0005 0.00051784515380859 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0005 0.00047421455383301 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0005 0.00052785873413086 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0005 0.00053501129150391 
SELECT * FROM products WHERE id = '777'
350 0.0005 0.0005340576171875 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
351 0.0006 0.000579833984375 
SELECT * FROM product_image_select WHERE product_id = '777'
352 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '777'
353 0.0010 0.00099587440490723 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
354 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0004 0.00043702125549316 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0005 0.00045394897460938 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0006 0.00061488151550293 
SELECT * FROM products WHERE id = '3881'
358 0.0006 0.00057601928710938 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
359 0.0007 0.00067019462585449 
SELECT * FROM product_image_select WHERE product_id = '3881'
360 0.0004 0.00035285949707031 
SELECT * FROM productcustomimages WHERE product_id = '3881'
361 0.0011 0.0010650157928467 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
362 0.0005 0.00046205520629883 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
363 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
364 0.0005 0.00046920776367188 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0014 0.0014040470123291 
SELECT * FROM products WHERE id = '4213'
366 0.0014 0.0013778209686279 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
367 0.0015 0.0014569759368896 
SELECT * FROM product_image_select WHERE product_id = '4213'
368 0.0008 0.00076508522033691 
SELECT * FROM productcustomimages WHERE product_id = '4213'
369 0.0031 0.0031180381774902 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
370 0.0009 0.00086712837219238 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
371 0.0007 0.00068497657775879 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
372 0.0008 0.00081896781921387 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373 0.0018 0.0018119812011719 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
374 0.0013 0.0013241767883301 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
375 0.0029 0.0029361248016357 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
376 0.0010 0.001039981842041 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
377 0.0009 0.00085997581481934 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
378 0.0013 0.0013198852539062 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
379 0.0012 0.0011968612670898 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'