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.5845839977264 394 1.2890 0


No Amazon API Requests Made.


App Debug - Total Time 1.5845839977264 seconds

Number Time From Start Name Description
1 0.2474582195282 Initialise Initialise FSB Function
2 0.25378203392029 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29409217834473 Start of getCategoryListByGroup Function Before first category groups query
4 0.29555702209473 After initial query Before first category groups query
5 0.29555821418762 Get Category List for Group Before the call to getCategoryList function
6 0.29556107521057 Start of GetCategoryList function Start of the function
7 0.29556322097778 Before getting categories Query to get specific category list
8 0.29713916778564 After getting categories Query to get specific category list
9 0.29714012145996 Before getting category custom Before call to function getCategoryCustom
10 0.31868815422058 After getting category custom After call to function getCategoryCustom
11 0.31869101524353 Before getting category custom Before call to function getCategoryCustom
12 0.32960104942322 After getting category custom After call to function getCategoryCustom
13 0.32960414886475 Before getting category custom Before call to function getCategoryCustom
14 0.33608603477478 After getting category custom After call to function getCategoryCustom
15 0.33608913421631 Before getting category custom Before call to function getCategoryCustom
16 0.34080910682678 After getting category custom After call to function getCategoryCustom
17 0.34081220626831 Before getting category custom Before call to function getCategoryCustom
18 0.34525108337402 After getting category custom After call to function getCategoryCustom
19 0.34525299072266 Before getting category custom Before call to function getCategoryCustom
20 0.35014009475708 After getting category custom After call to function getCategoryCustom
21 0.35014200210571 End of GetCategoryList function End of the function
22 0.35014700889587 Get Category List for Group Before the call to getCategoryList function
23 0.35014915466309 Start of GetCategoryList function Start of the function
24 0.35015106201172 Before getting categories Query to get specific category list
25 0.35067510604858 End of getCategoryListByGroup Function Before return()
26 1.2603511810303 App Controller End End of the App controller (called before the controller of every page)
27 1.451003074646 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4527950286865 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.4542450904846 Before Get Options Before the call to getOptions in the tpl class
30 1.5189030170441 After Get Options After the call to getOptions in the tpl class
31 1.5189821720123 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.5845770835876 Finalizing debug Before the debug is output to the page.
33 1.5845830440521 End of App This is the end of the app logging, final timestamp


Query Debug - 394 Database Queries. Total time 1.2890 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022659301757812 
SELECT parameter, value FROM parameters
2 0.0095 0.0095269680023193 
SELECT * FROM `bad_bots`
3 0.0005 0.00054693222045898 
SET time_zone = 'Europe/London'
4 0.0031 0.0030760765075684 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0042 0.0042169094085693 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.119.29.162\";}'
6 0.0035 0.0034699440002441 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746468626'
7 0.0036 0.0036180019378662 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010581016540527 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0038 0.00376296043396 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0009 0.00089597702026367 
SELECT * FROM pages WHERE id = 37
11 0.0055 0.005479097366333 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0340 0.033998012542725 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00057816505432129 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0015 0.0014538764953613 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0016 0.0015559196472168 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0075 0.0074830055236816 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0018 0.0017919540405273 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0012 0.0012040138244629 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00047421455383301 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0056 0.0055909156799316 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0016 0.0016109943389893 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0014 0.0014359951019287 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0014 0.0013937950134277 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.0004727840423584 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0037360191345215 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00054121017456055 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00042605400085449 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00043511390686035 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.003727912902832 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0005 0.00050210952758789 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0005 0.00052404403686523 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00049304962158203 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045204162597656 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014181137084961 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0005 0.0004889965057373 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00038909912109375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00049686431884766 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015618801116943 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0005 0.00051116943359375 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0005 0.00053310394287109 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00048685073852539 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00053119659423828 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00057721138000488 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00050806999206543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00041103363037109 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00046300888061523 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00063085556030273 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0005 0.00049495697021484 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0005 0.00053215026855469 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.0004570484161377 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00057387351989746 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.0005950927734375 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0005 0.00048589706420898 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.0003809928894043 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00039291381835938 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00065112113952637 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0005 0.00045680999755859 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0005 0.00051712989807129 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00049304962158203 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00040888786315918 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00060391426086426 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00050806999206543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0005 0.00045609474182129 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00048089027404785 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00078701972961426 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0005 0.00051403045654297 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0005 0.00049614906311035 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0006 0.00056290626525879 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00040197372436523 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00051498413085938 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0025 0.0024988651275635 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0014 0.001427173614502 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00066494941711426 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0012 0.0012161731719971 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0010 0.0010449886322021 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00077605247497559 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8925 0.89254689216614 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.119.29.162') >= INET_ATON(ip_start) AND INET_ATON('18.119.29.162') <= INET_ATON(ip_end)
78 0.0020 0.0020248889923096 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.001276969909668 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00057220458984375 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0053 0.0053150653839111 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0016 0.0016129016876221 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0019 0.0019450187683105 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0065 0.0064880847930908 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0018 0.0018291473388672 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0007 0.0006561279296875 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0053 0.0052659511566162 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0055 0.0054619312286377 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0015 0.0015020370483398 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0005 0.00052881240844727 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0059 0.0059380531311035 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 1062, 18
92 0.0016 0.0015649795532227 
SELECT * FROM productimages WHERE product_id = '3856' ORDER BY sortorder ASC
93 0.0015 0.0015499591827393 
SELECT * FROM product_image_select WHERE product_id = '3856'
94 0.0015 0.0014660358428955 
SELECT * FROM productcustomimages WHERE product_id = '3856'
95 0.0028 0.0027539730072021 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3856' AND a.name = n.originalname
96 0.0015 0.0014939308166504 
SELECT * FROM productoffers WHERE product_id = '3856' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0005 0.00052285194396973 
SELECT * FROM productoffers
                WHERE product_id = '3856' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0005 0.00051593780517578 
SELECT * FROM productoffers
                WHERE product_id = 3856
                ORDER BY price ASC LIMIT 1
99 0.0007 0.0006871223449707 
SELECT value FROM productattributes
                WHERE product_id = '3856'
                AND name = 'ListPriceAmount'
100 0.0005 0.00054192543029785 
SELECT value FROM productattributes WHERE product_id = '3856' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0006 0.00055289268493652 
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
102 0.0007 0.00071120262145996 
SELECT * FROM product_image_select WHERE product_id = '4943'
103 0.0004 0.00043606758117676 
SELECT * FROM productcustomimages WHERE product_id = '4943'
104 0.0012 0.0011811256408691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
105 0.0006 0.00056099891662598 
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00037288665771484 
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
109 0.0004 0.00040793418884277 
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00050210952758789 
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
111 0.0005 0.00050806999206543 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
112 0.0006 0.00059199333190918 
SELECT * FROM product_image_select WHERE product_id = '3578'
113 0.0004 0.00037002563476562 
SELECT * FROM productcustomimages WHERE product_id = '3578'
114 0.0006 0.00057601928710938 
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 = '3578'
                GROUP BY o.product_id
115 0.0032 0.0031609535217285 
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
116 0.0005 0.00052905082702637 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
117 0.0008 0.00082921981811523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
118 0.0004 0.00037384033203125 
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0003 0.00034379959106445 
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
121 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '3578'
                AND name = 'ListPriceAmount'
122 0.0004 0.00037693977355957 
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 = '3578'
                GROUP BY o.product_id
123 0.0006 0.00058794021606445 
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
124 0.0003 0.00034689903259277 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
125 0.0005 0.00050783157348633 
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0004 0.00036287307739258 
SELECT * FROM products WHERE parent_id = '3578'
127 0.0005 0.00050592422485352 
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
128 0.0006 0.00058794021606445 
SELECT * FROM product_image_select WHERE product_id = '3587'
129 0.0004 0.00039076805114746 
SELECT * FROM productcustomimages WHERE product_id = '3587'
130 0.0009 0.0008699893951416 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
131 0.0005 0.00047612190246582 
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00045990943908691 
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0007 0.00065302848815918 
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00062012672424316 
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
135 0.0007 0.00072216987609863 
SELECT * FROM product_image_select WHERE product_id = '3588'
136 0.0005 0.00046896934509277 
SELECT * FROM productcustomimages WHERE product_id = '3588'
137 0.0011 0.001060962677002 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
138 0.0007 0.00067710876464844 
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00047397613525391 
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00054216384887695 
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.00056791305541992 
SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
142 0.0007 0.00072097778320312 
SELECT * FROM product_image_select WHERE product_id = '3600'
143 0.0004 0.00043392181396484 
SELECT * FROM productcustomimages WHERE product_id = '3600'
144 0.0028 0.0027709007263184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
145 0.0009 0.000885009765625 
SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0006 0.00061202049255371 
SELECT * FROM productoffers
                WHERE product_id = '3600' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00043296813964844 
SELECT * FROM productoffers
                WHERE product_id = 3600
                ORDER BY price ASC LIMIT 1
148 0.0006 0.00056600570678711 
SELECT value FROM productattributes
                WHERE product_id = '3600'
                AND name = 'ListPriceAmount'
149 0.0006 0.00063300132751465 
SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0006 0.00057506561279297 
SELECT * FROM productimages WHERE product_id = '3606' ORDER BY sortorder ASC
151 0.0007 0.00072598457336426 
SELECT * FROM product_image_select WHERE product_id = '3606'
152 0.0005 0.00048613548278809 
SELECT * FROM productcustomimages WHERE product_id = '3606'
153 0.0010 0.0010280609130859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3606' AND a.name = n.originalname
154 0.0006 0.00060415267944336 
SELECT * FROM productoffers WHERE product_id = '3606' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '3606' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = 3606
                ORDER BY price ASC LIMIT 1
157 0.0006 0.00056004524230957 
SELECT value FROM productattributes
                WHERE product_id = '3606'
                AND name = 'ListPriceAmount'
158 0.0005 0.00047516822814941 
SELECT value FROM productattributes WHERE product_id = '3606' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0009 0.00088095664978027 
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
160 0.0009 0.00093412399291992 
SELECT * FROM product_image_select WHERE product_id = '3738'
161 0.0006 0.00059008598327637 
SELECT * FROM productcustomimages WHERE product_id = '3738'
162 0.0021 0.0020918846130371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
163 0.0006 0.00064182281494141 
SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00052499771118164 
SELECT * FROM productoffers
                WHERE product_id = '3738' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00053691864013672 
SELECT * FROM productoffers
                WHERE product_id = 3738
                ORDER BY price ASC LIMIT 1
166 0.0006 0.0006411075592041 
SELECT value FROM productattributes
                WHERE product_id = '3738'
                AND name = 'ListPriceAmount'
167 0.0006 0.00057101249694824 
SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0007 0.0006861686706543 
SELECT * FROM productimages WHERE product_id = '3610' ORDER BY sortorder ASC
169 0.0008 0.00079584121704102 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3610' AND p.id = pi.product_id ORDER BY pi.sortorder
170 0.0007 0.0007331371307373 
SELECT * FROM product_image_select WHERE product_id = '3610'
171 0.0005 0.00051593780517578 
SELECT * FROM productcustomimages WHERE product_id = '3610'
172 0.0010 0.0010449886322021 
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 = '3610'
                GROUP BY o.product_id
173 0.0008 0.00083398818969727 
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     = '3610'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0005 0.0005028247833252 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3610
175 0.0017 0.0017049312591553 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3610' AND a.name = n.originalname
176 0.0005 0.00049281120300293 
SELECT * FROM productoffers WHERE product_id = '3610' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = '3610' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00047397613525391 
SELECT * FROM productoffers
                WHERE product_id = 3610
                ORDER BY price ASC LIMIT 1
179 0.0006 0.00055408477783203 
SELECT value FROM productattributes
                WHERE product_id = '3610'
                AND name = 'ListPriceAmount'
180 0.0006 0.00061202049255371 
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 = '3610'
                GROUP BY o.product_id
181 0.0009 0.00088405609130859 
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     = '3610'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
182 0.0005 0.00046992301940918 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3610
183 0.0006 0.00060486793518066 
SELECT value FROM productattributes WHERE product_id = '3610' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0008 0.00075697898864746 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3610'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
185 0.0004 0.00044798851013184 
SELECT * FROM products WHERE parent_id = '3610'
186 0.0011 0.0010859966278076 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4713' AND a.name = n.originalname
187 0.0008 0.00075602531433105 
SELECT * FROM productoffers WHERE product_id = '4713' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0006 0.00056290626525879 
SELECT * FROM productoffers
                WHERE product_id = '4713' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00043296813964844 
SELECT * FROM productoffers
                WHERE product_id = 4713
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00041508674621582 
SELECT value FROM productattributes
                WHERE product_id = '4713'
                AND name = 'ListPriceAmount'
191 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '3613' ORDER BY sortorder ASC
192 0.0007 0.00072908401489258 
SELECT * FROM product_image_select WHERE product_id = '3613'
193 0.0006 0.00059199333190918 
SELECT * FROM productcustomimages WHERE product_id = '3613'
194 0.0013 0.0013220310211182 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3613' AND a.name = n.originalname
195 0.0006 0.00059294700622559 
SELECT * FROM productoffers WHERE product_id = '3613' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0005 0.00054001808166504 
SELECT * FROM productoffers
                WHERE product_id = '3613' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0005 0.0004889965057373 
SELECT * FROM productoffers
                WHERE product_id = 3613
                ORDER BY price ASC LIMIT 1
198 0.0005 0.0004889965057373 
SELECT value FROM productattributes
                WHERE product_id = '3613'
                AND name = 'ListPriceAmount'
199 0.0005 0.00053811073303223 
SELECT value FROM productattributes WHERE product_id = '3613' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.00057101249694824 
SELECT * FROM productimages WHERE product_id = '3614' ORDER BY sortorder ASC
201 0.0010 0.00095701217651367 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3614' AND p.id = pi.product_id ORDER BY pi.sortorder
202 0.0008 0.00076198577880859 
SELECT * FROM product_image_select WHERE product_id = '3614'
203 0.0005 0.00053000450134277 
SELECT * FROM productcustomimages WHERE product_id = '3614'
204 0.0007 0.00066995620727539 
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 = '3614'
                GROUP BY o.product_id
205 0.0009 0.00094985961914062 
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     = '3614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
206 0.0005 0.00054001808166504 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3614
207 0.0011 0.0010840892791748 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3614' AND a.name = n.originalname
208 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '3614' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '3614' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00039291381835938 
SELECT * FROM productoffers
                WHERE product_id = 3614
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00051689147949219 
SELECT value FROM productattributes
                WHERE product_id = '3614'
                AND name = 'ListPriceAmount'
212 0.0006 0.00060892105102539 
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 = '3614'
                GROUP BY o.product_id
213 0.0008 0.00083208084106445 
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     = '3614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
214 0.0004 0.00042581558227539 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3614
215 0.0006 0.00059008598327637 
SELECT value FROM productattributes WHERE product_id = '3614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0007 0.00072407722473145 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
217 0.0006 0.00061821937561035 
SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
218 0.0007 0.00068116188049316 
SELECT * FROM product_image_select WHERE product_id = '3623'
219 0.0005 0.00050997734069824 
SELECT * FROM productcustomimages WHERE product_id = '3623'
220 0.0010 0.00098204612731934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
221 0.0005 0.00052094459533691 
SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00049185752868652 
SELECT * FROM productoffers
                WHERE product_id = '3623' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = 3623
                ORDER BY price ASC LIMIT 1
224 0.0005 0.00054001808166504 
SELECT value FROM productattributes
                WHERE product_id = '3623'
                AND name = 'ListPriceAmount'
225 0.0006 0.00057101249694824 
SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0007 0.00068998336791992 
SELECT * FROM productimages WHERE product_id = '3622' ORDER BY sortorder ASC
227 0.0007 0.00071811676025391 
SELECT * FROM product_image_select WHERE product_id = '3622'
228 0.0005 0.00046396255493164 
SELECT * FROM productcustomimages WHERE product_id = '3622'
229 0.0011 0.0011050701141357 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3622' AND a.name = n.originalname
230 0.0005 0.00053787231445312 
SELECT * FROM productoffers WHERE product_id = '3622' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '3622' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00038599967956543 
SELECT * FROM productoffers
                WHERE product_id = 3622
                ORDER BY price ASC LIMIT 1
233 0.0004 0.00042986869812012 
SELECT value FROM productattributes
                WHERE product_id = '3622'
                AND name = 'ListPriceAmount'
234 0.0005 0.00051999092102051 
SELECT value FROM productattributes WHERE product_id = '3622' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0005 0.00052309036254883 
SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
236 0.0006 0.00064992904663086 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
237 0.0007 0.00067901611328125 
SELECT * FROM product_image_select WHERE product_id = '3626'
238 0.0004 0.00041103363037109 
SELECT * FROM productcustomimages WHERE product_id = '3626'
239 0.0006 0.00060606002807617 
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 = '3626'
                GROUP BY o.product_id
240 0.0006 0.00064277648925781 
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0004 0.00042104721069336 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
242 0.0010 0.0010020732879639 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
243 0.0004 0.00037598609924316 
SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = '3626' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0006 0.00064587593078613 
SELECT * FROM productoffers
                WHERE product_id = 3626
                ORDER BY price ASC LIMIT 1
246 0.0008 0.00080108642578125 
SELECT value FROM productattributes
                WHERE product_id = '3626'
                AND name = 'ListPriceAmount'
247 0.0008 0.00078582763671875 
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 = '3626'
                GROUP BY o.product_id
248 0.0012 0.0012369155883789 
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
249 0.0007 0.00069117546081543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
250 0.0010 0.0010480880737305 
SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0012 0.0012190341949463 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3626'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
252 0.0015 0.0014731884002686 
SELECT * FROM productimages WHERE product_id = '3632' ORDER BY sortorder ASC
253 0.0013 0.0012669563293457 
SELECT * FROM product_image_select WHERE product_id = '3632'
254 0.0006 0.00064682960510254 
SELECT * FROM productcustomimages WHERE product_id = '3632'
255 0.0015 0.0014510154724121 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3632' AND a.name = n.originalname
256 0.0007 0.00072002410888672 
SELECT * FROM productoffers WHERE product_id = '3632' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0005 0.00046896934509277 
SELECT * FROM productoffers
                WHERE product_id = '3632' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0004 0.00043582916259766 
SELECT * FROM productoffers
                WHERE product_id = 3632
                ORDER BY price ASC LIMIT 1
259 0.0006 0.00055789947509766 
SELECT value FROM productattributes
                WHERE product_id = '3632'
                AND name = 'ListPriceAmount'
260 0.0006 0.00059294700622559 
SELECT value FROM productattributes WHERE product_id = '3632' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0007 0.00071597099304199 
SELECT * FROM productimages WHERE product_id = '3658' ORDER BY sortorder ASC
262 0.0007 0.00070500373840332 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3658' AND p.id = pi.product_id ORDER BY pi.sortorder
263 0.0009 0.00088119506835938 
SELECT * FROM product_image_select WHERE product_id = '3658'
264 0.0005 0.0004880428314209 
SELECT * FROM productcustomimages WHERE product_id = '3658'
265 0.0007 0.0007011890411377 
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 = '3658'
                GROUP BY o.product_id
266 0.0008 0.00081515312194824 
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     = '3658'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0005 0.00046300888061523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3658
268 0.0017 0.0017268657684326 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3658' AND a.name = n.originalname
269 0.0004 0.00036311149597168 
SELECT * FROM productoffers WHERE product_id = '3658' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = '3658' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00031590461730957 
SELECT * FROM productoffers
                WHERE product_id = 3658
                ORDER BY price ASC LIMIT 1
272 0.0004 0.00036883354187012 
SELECT value FROM productattributes
                WHERE product_id = '3658'
                AND name = 'ListPriceAmount'
273 0.0004 0.00039100646972656 
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 = '3658'
                GROUP BY o.product_id
274 0.0006 0.0006260871887207 
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     = '3658'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
275 0.0004 0.00037217140197754 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3658
276 0.0006 0.00057601928710938 
SELECT value FROM productattributes WHERE product_id = '3658' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
277 0.0006 0.00064992904663086 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3658'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
278 0.0004 0.00042986869812012 
SELECT * FROM products WHERE parent_id = '3658'
279 0.0006 0.00059795379638672 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4518' AND a.name = n.originalname
280 0.0005 0.00047397613525391 
SELECT * FROM productoffers WHERE product_id = '4518' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '4518' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0003 0.00031805038452148 
SELECT * FROM productoffers
                WHERE product_id = 4518
                ORDER BY price ASC LIMIT 1
283 0.0004 0.00036907196044922 
SELECT value FROM productattributes
                WHERE product_id = '4518'
                AND name = 'ListPriceAmount'
284 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
285 0.0007 0.00067281723022461 
SELECT * FROM product_image_select WHERE product_id = '3665'
286 0.0004 0.00039982795715332 
SELECT * FROM productcustomimages WHERE product_id = '3665'
287 0.0009 0.00087904930114746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
288 0.0005 0.00047683715820312 
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00035285949707031 
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0003 0.00028181076049805 
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
291 0.0003 0.00032687187194824 
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
292 0.0004 0.00037002563476562 
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0004 0.00044488906860352 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
294 0.0005 0.00054693222045898 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3666' AND p.id = pi.product_id ORDER BY pi.sortorder
295 0.0005 0.00052618980407715 
SELECT * FROM product_image_select WHERE product_id = '3666'
296 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '3666'
297 0.0005 0.00049805641174316 
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 = '3666'
                GROUP BY o.product_id
298 0.0006 0.00058603286743164 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
299 0.0004 0.00038313865661621 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
300 0.0012 0.0011780261993408 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
301 0.0004 0.00035500526428223 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0003 0.00034403800964355 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0003 0.00029897689819336 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
304 0.0004 0.00036382675170898 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
305 0.0004 0.00042414665222168 
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 = '3666'
                GROUP BY o.product_id
306 0.0006 0.00060105323791504 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
307 0.0004 0.00038385391235352 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
308 0.0005 0.00047707557678223 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0006 0.0005800724029541 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3666'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
310 0.0014 0.0014150142669678 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3856' ORDER BY timestamp DESC
311 0.0003 0.00032615661621094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
312 0.0003 0.00032711029052734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
313 0.0003 0.00027608871459961 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
314 0.0003 0.00030207633972168 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
315 0.0003 0.00026488304138184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
316 0.0003 0.00025582313537598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3606' ORDER BY timestamp DESC
317 0.0003 0.00026392936706543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
318 0.0003 0.00025320053100586 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3610' ORDER BY timestamp DESC
319 0.0003 0.00025606155395508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3613' ORDER BY timestamp DESC
320 0.0003 0.00029206275939941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3614' ORDER BY timestamp DESC
321 0.0003 0.00026583671569824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' ORDER BY timestamp DESC
322 0.0002 0.00024700164794922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3622' ORDER BY timestamp DESC
323 0.0002 0.00024008750915527 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3626' ORDER BY timestamp DESC
324 0.0002 0.00023198127746582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3632' ORDER BY timestamp DESC
325 0.0003 0.00027608871459961 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3658' ORDER BY timestamp DESC
326 0.0003 0.00025606155395508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3665' ORDER BY timestamp DESC
327 0.0002 0.00024008750915527 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3666' ORDER BY timestamp DESC
328 0.0013 0.001323938369751 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
329 0.0011 0.0010910034179688 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
330 0.0003 0.0003211498260498 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
331 0.0126 0.012621164321899 
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
332 0.0015 0.001539945602417 
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
333 0.0006 0.00055694580078125 
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
334 0.0005 0.0005180835723877 
SELECT * FROM products WHERE id = 1626
335 0.0004 0.00037193298339844 
SELECT * FROM products WHERE id = 4041
336 0.0004 0.00036907196044922 
SELECT * FROM products WHERE id = 4312
337 0.0003 0.00033307075500488 
SELECT * FROM products WHERE id = 777
338 0.0004 0.0004420280456543 
SELECT * FROM products WHERE id = 3881
339 0.0005 0.00052785873413086 
SELECT * FROM products WHERE id = 4213
340 0.0003 0.00032210350036621 
SELECT * FROM products WHERE id = '1626'
341 0.0004 0.0004270076751709 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
342 0.0006 0.00060009956359863 
SELECT * FROM product_image_select WHERE product_id = '1626'
343 0.0003 0.00034809112548828 
SELECT * FROM productcustomimages WHERE product_id = '1626'
344 0.0008 0.00080394744873047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
345 0.0004 0.00043606758117676 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
346 0.0004 0.00038886070251465 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
347 0.0004 0.00043892860412598 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348 0.0005 0.00050187110900879 
SELECT * FROM products WHERE id = '4041'
349 0.0004 0.00042390823364258 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
350 0.0006 0.00056099891662598 
SELECT * FROM product_image_select WHERE product_id = '4041'
351 0.0003 0.00034809112548828 
SELECT * FROM productcustomimages WHERE product_id = '4041'
352 0.0011 0.0010800361633301 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
353 0.0005 0.00046110153198242 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
354 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
355 0.0004 0.00039196014404297 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356 0.0005 0.00048708915710449 
SELECT * FROM products WHERE id = '4312'
357 0.0005 0.00046586990356445 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
358 0.0006 0.00057697296142578 
SELECT * FROM product_image_select WHERE product_id = '4312'
359 0.0004 0.0003969669342041 
SELECT * FROM productcustomimages WHERE product_id = '4312'
360 0.0021 0.0021159648895264 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
361 0.0009 0.0008847713470459 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
362 0.0005 0.00054097175598145 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
363 0.0008 0.00077199935913086 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0009 0.00091314315795898 
SELECT * FROM products WHERE id = '777'
365 0.0009 0.00086402893066406 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
366 0.0012 0.0012009143829346 
SELECT * FROM product_image_select WHERE product_id = '777'
367 0.0007 0.00069022178649902 
SELECT * FROM productcustomimages WHERE product_id = '777'
368 0.0023 0.0023090839385986 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
369 0.0009 0.00087285041809082 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
370 0.0006 0.00061321258544922 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
371 0.0007 0.00070810317993164 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372 0.0010 0.00096487998962402 
SELECT * FROM products WHERE id = '3881'
373 0.0010 0.00097489356994629 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
374 0.0012 0.0011699199676514 
SELECT * FROM product_image_select WHERE product_id = '3881'
375 0.0006 0.00058984756469727 
SELECT * FROM productcustomimages WHERE product_id = '3881'
376 0.0022 0.0022091865539551 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
377 0.0008 0.00079584121704102 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
378 0.0005 0.00052690505981445 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
379 0.0006 0.00062203407287598 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380 0.0007 0.00068497657775879 
SELECT * FROM products WHERE id = '4213'
381 0.0007 0.00073790550231934 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
382 0.0009 0.00089693069458008 
SELECT * FROM product_image_select WHERE product_id = '4213'
383 0.0006 0.0006101131439209 
SELECT * FROM productcustomimages WHERE product_id = '4213'
384 0.0028 0.0028319358825684 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
385 0.0009 0.00093913078308105 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
386 0.0005 0.00049805641174316 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
387 0.0005 0.00053811073303223 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
388 0.0027 0.0026869773864746 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
389 0.0008 0.00079512596130371 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
390 0.0026 0.0025901794433594 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
391 0.0015 0.0014889240264893 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
392 0.0006 0.00056695938110352 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
393 0.0019 0.001878023147583 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
394 0.0016 0.0016131401062012 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'