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.4613490104675 349 1.0521 0


No Amazon API Requests Made.


App Debug - Total Time 1.4613490104675 seconds

Number Time From Start Name Description
1 0.38595080375671 Initialise Initialise FSB Function
2 0.3885178565979 App Controller Start Start of the App controller (called before the controller of every page)
3 0.41401886940002 Start of getCategoryListByGroup Function Before first category groups query
4 0.41528487205505 After initial query Before first category groups query
5 0.41528582572937 Get Category List for Group Before the call to getCategoryList function
6 0.41528701782227 Start of GetCategoryList function Start of the function
7 0.4152889251709 Before getting categories Query to get specific category list
8 0.41651701927185 After getting categories Query to get specific category list
9 0.41651797294617 Before getting category custom Before call to function getCategoryCustom
10 0.43601489067078 After getting category custom After call to function getCategoryCustom
11 0.43601703643799 Before getting category custom Before call to function getCategoryCustom
12 0.44432282447815 After getting category custom After call to function getCategoryCustom
13 0.44432497024536 Before getting category custom Before call to function getCategoryCustom
14 0.4487419128418 After getting category custom After call to function getCategoryCustom
15 0.44874501228333 Before getting category custom Before call to function getCategoryCustom
16 0.45180988311768 After getting category custom After call to function getCategoryCustom
17 0.45181202888489 Before getting category custom Before call to function getCategoryCustom
18 0.45505881309509 After getting category custom After call to function getCategoryCustom
19 0.45506000518799 Before getting category custom Before call to function getCategoryCustom
20 0.45814895629883 After getting category custom After call to function getCategoryCustom
21 0.45814990997314 End of GetCategoryList function End of the function
22 0.45815491676331 Get Category List for Group Before the call to getCategoryList function
23 0.45815587043762 Start of GetCategoryList function Start of the function
24 0.45815682411194 Before getting categories Query to get specific category list
25 0.45849680900574 End of getCategoryListByGroup Function Before return()
26 1.3005068302155 App Controller End End of the App controller (called before the controller of every page)
27 1.3974189758301 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.3985829353333 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.3994929790497 Before Get Options Before the call to getOptions in the tpl class
30 1.4373049736023 After Get Options After the call to getOptions in the tpl class
31 1.4374558925629 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.4613389968872 Finalizing debug Before the debug is output to the page.
33 1.4613478183746 End of App This is the end of the app logging, final timestamp


Query Debug - 349 Database Queries. Total time 1.0521 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015170574188232 
SELECT parameter, value FROM parameters
2 0.0024 0.0024058818817139 
SELECT * FROM `bad_bots`
3 0.0002 0.0001988410949707 
SET time_zone = 'Europe/London'
4 0.0008 0.00078892707824707 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00086808204650879 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.202\";}'
6 0.0008 0.0007779598236084 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750117331'
7 0.0014 0.0014309883117676 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00043702125549316 
UPDATE autorun SET lastrun = '2025-06-16 23:42:11' WHERE id = '16'
9 0.0004 0.00043010711669922 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0011 0.0011329650878906 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00039219856262207 
SELECT * FROM pages WHERE id = 37
12 0.0025 0.0024631023406982 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0219 0.021881818771362 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0009 0.00086593627929688 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0013 0.0012609958648682 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0012 0.001215934753418 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0063 0.0062868595123291 
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.0018 0.0017509460449219 
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.0016 0.0015890598297119 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0014 0.0014350414276123 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0058 0.0057690143585205 
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.0008 0.00078988075256348 
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.0008 0.00081586837768555 
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.0007 0.00070691108703613 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00028800964355469 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0030190944671631 
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.0003 0.00031185150146484 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00037097930908203 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00031709671020508 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0030 0.0029888153076172 
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.0003 0.00032591819763184 
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.0003 0.00033998489379883 
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.0003 0.00031399726867676 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00028419494628906 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0011069774627686 
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.0003 0.00030899047851562 
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.0003 0.00026512145996094 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00031113624572754 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0011 0.0011410713195801 
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.0003 0.00031304359436035 
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.0003 0.0003359317779541 
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.0003 0.0003049373626709 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.0002899169921875 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00041294097900391 
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.0003 0.00031495094299316 
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.0003 0.0002589225769043 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00029182434082031 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00046205520629883 
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.0003 0.00031399726867676 
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.0003 0.0003359317779541 
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.0003 0.00033807754516602 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00029897689819336 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00039982795715332 
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.0003 0.00031208992004395 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00026297569274902 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.0002748966217041 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00046181678771973 
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.0003 0.00031685829162598 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0006 0.00061583518981934 
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.0003 0.00030088424682617 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00027704238891602 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.0005190372467041 
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.0003 0.00029301643371582 
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.0003 0.00025701522827148 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00031590461730957 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00045204162597656 
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.0003 0.00031399726867676 
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.0003 0.00033307075500488 
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.0003 0.00030303001403809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00028300285339355 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00033688545227051 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0025 0.0025160312652588 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00077199935913086 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.0003659725189209 
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.0006 0.00058293342590332 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.0009009838104248 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00056314468383789 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8302 0.83020305633545 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.202') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.202') <= INET_ATON(ip_end)
79 0.0037 0.0036859512329102 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0010 0.00098490715026855 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00061202049255371 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0047 0.0046670436859131 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0014 0.0013790130615234 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0010 0.0010180473327637 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0047 0.0047039985656738 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0021 0.0020620822906494 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.0003960132598877 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0037 0.0036520957946777 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0044 0.0044398307800293 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0012 0.0012259483337402 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0004 0.00038599967956543 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0039 0.0039000511169434 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 342, 18
93 0.0008 0.00079512596130371 
SELECT * FROM productimages WHERE product_id = '1575' ORDER BY sortorder ASC
94 0.0008 0.00083494186401367 
SELECT * FROM product_image_select WHERE product_id = '1575'
95 0.0006 0.00062680244445801 
SELECT * FROM productcustomimages WHERE product_id = '1575'
96 0.0010 0.00097298622131348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1575' AND a.name = n.originalname
97 0.0007 0.00072002410888672 
SELECT * FROM productoffers WHERE product_id = '1575' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '1575' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0002 0.00023221969604492 
SELECT * FROM productoffers
                WHERE product_id = 1575
                ORDER BY price ASC LIMIT 1
100 0.0003 0.00032401084899902 
SELECT value FROM productattributes
                WHERE product_id = '1575'
                AND name = 'ListPriceAmount'
101 0.0003 0.00026702880859375 
SELECT value FROM productattributes WHERE product_id = '1575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0003 0.00030994415283203 
SELECT * FROM productimages WHERE product_id = '845' ORDER BY sortorder ASC
103 0.0004 0.00043702125549316 
SELECT * FROM product_image_select WHERE product_id = '845'
104 0.0003 0.00026082992553711 
SELECT * FROM productcustomimages WHERE product_id = '845'
105 0.0005 0.00051307678222656 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '845' AND a.name = n.originalname
106 0.0003 0.00030207633972168 
SELECT * FROM productoffers WHERE product_id = '845' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0002 0.00024199485778809 
SELECT * FROM productoffers
                WHERE product_id = '845' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00021696090698242 
SELECT * FROM productoffers
                WHERE product_id = 845
                ORDER BY price ASC LIMIT 1
109 0.0002 0.0002448558807373 
SELECT value FROM productattributes
                WHERE product_id = '845'
                AND name = 'ListPriceAmount'
110 0.0003 0.00025296211242676 
SELECT value FROM productattributes WHERE product_id = '845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00029802322387695 
SELECT * FROM productimages WHERE product_id = '844' ORDER BY sortorder ASC
112 0.0004 0.0004279613494873 
SELECT * FROM product_image_select WHERE product_id = '844'
113 0.0003 0.00025701522827148 
SELECT * FROM productcustomimages WHERE product_id = '844'
114 0.0005 0.00051307678222656 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '844' AND a.name = n.originalname
115 0.0003 0.0002899169921875 
SELECT * FROM productoffers WHERE product_id = '844' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0002 0.000244140625 
SELECT * FROM productoffers
                WHERE product_id = '844' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0002 0.00021910667419434 
SELECT * FROM productoffers
                WHERE product_id = 844
                ORDER BY price ASC LIMIT 1
118 0.0002 0.00022792816162109 
SELECT value FROM productattributes
                WHERE product_id = '844'
                AND name = 'ListPriceAmount'
119 0.0003 0.00025701522827148 
SELECT value FROM productattributes WHERE product_id = '844' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00030303001403809 
SELECT * FROM productimages WHERE product_id = '1243' ORDER BY sortorder ASC
121 0.0004 0.0004420280456543 
SELECT * FROM product_image_select WHERE product_id = '1243'
122 0.0003 0.00026416778564453 
SELECT * FROM productcustomimages WHERE product_id = '1243'
123 0.0005 0.00048089027404785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1243' AND a.name = n.originalname
124 0.0003 0.00029897689819336 
SELECT * FROM productoffers WHERE product_id = '1243' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '1243' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '1243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00034117698669434 
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
128 0.0004 0.00043106079101562 
SELECT * FROM product_image_select WHERE product_id = '788'
129 0.0003 0.00025105476379395 
SELECT * FROM productcustomimages WHERE product_id = '788'
130 0.0006 0.00055599212646484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
131 0.0003 0.00029993057250977 
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0003 0.00025582313537598 
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00027585029602051 
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00029182434082031 
SELECT * FROM productimages WHERE product_id = '1342' ORDER BY sortorder ASC
135 0.0004 0.00043606758117676 
SELECT * FROM product_image_select WHERE product_id = '1342'
136 0.0003 0.00027012825012207 
SELECT * FROM productcustomimages WHERE product_id = '1342'
137 0.0006 0.00063610076904297 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1342' AND a.name = n.originalname
138 0.0003 0.00029897689819336 
SELECT * FROM productoffers WHERE product_id = '1342' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0003 0.00029802322387695 
SELECT * FROM productoffers
                WHERE product_id = '1342' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0002 0.00024700164794922 
SELECT * FROM productoffers
                WHERE product_id = 1342
                ORDER BY price ASC LIMIT 1
141 0.0003 0.00027799606323242 
SELECT value FROM productattributes
                WHERE product_id = '1342'
                AND name = 'ListPriceAmount'
142 0.0003 0.00027704238891602 
SELECT value FROM productattributes WHERE product_id = '1342' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0003 0.00030398368835449 
SELECT * FROM productimages WHERE product_id = '1285' ORDER BY sortorder ASC
144 0.0004 0.00043797492980957 
SELECT * FROM product_image_select WHERE product_id = '1285'
145 0.0003 0.0002589225769043 
SELECT * FROM productcustomimages WHERE product_id = '1285'
146 0.0006 0.00057482719421387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1285' AND a.name = n.originalname
147 0.0003 0.00030398368835449 
SELECT * FROM productoffers WHERE product_id = '1285' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '1285' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00024604797363281 
SELECT value FROM productattributes WHERE product_id = '1285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0003 0.00029206275939941 
SELECT * FROM productimages WHERE product_id = '1404' ORDER BY sortorder ASC
151 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '1404'
152 0.0003 0.00025486946105957 
SELECT * FROM productcustomimages WHERE product_id = '1404'
153 0.0006 0.00060892105102539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1404' AND a.name = n.originalname
154 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '1404' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0003 0.00026917457580566 
SELECT * FROM productoffers
                WHERE product_id = '1404' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00026392936706543 
SELECT value FROM productattributes WHERE product_id = '1404' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0003 0.00033402442932129 
SELECT * FROM productimages WHERE product_id = '1116' ORDER BY sortorder ASC
158 0.0004 0.00043511390686035 
SELECT * FROM product_image_select WHERE product_id = '1116'
159 0.0003 0.00026702880859375 
SELECT * FROM productcustomimages WHERE product_id = '1116'
160 0.0007 0.0006558895111084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1116' AND a.name = n.originalname
161 0.0003 0.00030303001403809 
SELECT * FROM productoffers WHERE product_id = '1116' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '1116' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0003 0.0002598762512207 
SELECT value FROM productattributes WHERE product_id = '1116' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0003 0.00031185150146484 
SELECT * FROM productimages WHERE product_id = '1543' ORDER BY sortorder ASC
165 0.0006 0.00057387351989746 
SELECT * FROM product_image_select WHERE product_id = '1543'
166 0.0003 0.00030279159545898 
SELECT * FROM productcustomimages WHERE product_id = '1543'
167 0.0007 0.00065994262695312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1543' AND a.name = n.originalname
168 0.0003 0.00031304359436035 
SELECT * FROM productoffers WHERE product_id = '1543' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = '1543' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00027298927307129 
SELECT value FROM productattributes WHERE product_id = '1543' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0003 0.00030994415283203 
SELECT * FROM productimages WHERE product_id = '1149' ORDER BY sortorder ASC
172 0.0004 0.00044798851013184 
SELECT * FROM product_image_select WHERE product_id = '1149'
173 0.0003 0.00026392936706543 
SELECT * FROM productcustomimages WHERE product_id = '1149'
174 0.0006 0.00064301490783691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1149' AND a.name = n.originalname
175 0.0003 0.00031113624572754 
SELECT * FROM productoffers WHERE product_id = '1149' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '1149' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0002 0.00022292137145996 
SELECT * FROM productoffers
                WHERE product_id = 1149
                ORDER BY price ASC LIMIT 1
178 0.0003 0.00025510787963867 
SELECT value FROM productattributes
                WHERE product_id = '1149'
                AND name = 'ListPriceAmount'
179 0.0003 0.00025105476379395 
SELECT value FROM productattributes WHERE product_id = '1149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0003 0.0002899169921875 
SELECT * FROM productimages WHERE product_id = '1487' ORDER BY sortorder ASC
181 0.0005 0.00045919418334961 
SELECT * FROM product_image_select WHERE product_id = '1487'
182 0.0003 0.00025415420532227 
SELECT * FROM productcustomimages WHERE product_id = '1487'
183 0.0007 0.0006558895111084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1487' AND a.name = n.originalname
184 0.0003 0.00029802322387695 
SELECT * FROM productoffers WHERE product_id = '1487' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '1487' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0003 0.00028705596923828 
SELECT value FROM productattributes WHERE product_id = '1487' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0003 0.00029921531677246 
SELECT * FROM productimages WHERE product_id = '3594' ORDER BY sortorder ASC
188 0.0004 0.00035405158996582 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3594' AND p.id = pi.product_id ORDER BY pi.sortorder
189 0.0004 0.00044393539428711 
SELECT * FROM product_image_select WHERE product_id = '3594'
190 0.0003 0.00027704238891602 
SELECT * FROM productcustomimages WHERE product_id = '3594'
191 0.0003 0.0003349781036377 
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 = '3594'
                GROUP BY o.product_id
192 0.0013 0.0012900829315186 
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     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
193 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 = 3594
194 0.0006 0.00059080123901367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3594' AND a.name = n.originalname
195 0.0003 0.00026202201843262 
SELECT * FROM productoffers WHERE product_id = '3594' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0002 0.0002448558807373 
SELECT * FROM productoffers
                WHERE product_id = '3594' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00022697448730469 
SELECT * FROM productoffers
                WHERE product_id = 3594
                ORDER BY price ASC LIMIT 1
198 0.0002 0.00024604797363281 
SELECT value FROM productattributes
                WHERE product_id = '3594'
                AND name = 'ListPriceAmount'
199 0.0003 0.00026202201843262 
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 = '3594'
                GROUP BY o.product_id
200 0.0004 0.00039005279541016 
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     = '3594'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
201 0.0002 0.00024580955505371 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3594
202 0.0003 0.00034713745117188 
SELECT value FROM productattributes WHERE product_id = '3594' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0004 0.00035905838012695 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3594'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
204 0.0003 0.00028896331787109 
SELECT * FROM products WHERE parent_id = '3594'
205 0.0003 0.00034403800964355 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3969' AND a.name = n.originalname
206 0.0003 0.00031495094299316 
SELECT * FROM productoffers WHERE product_id = '3969' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0003 0.00027012825012207 
SELECT * FROM productoffers
                WHERE product_id = '3969' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0002 0.0002288818359375 
SELECT * FROM productoffers
                WHERE product_id = 3969
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00023889541625977 
SELECT value FROM productattributes
                WHERE product_id = '3969'
                AND name = 'ListPriceAmount'
210 0.0003 0.00031590461730957 
SELECT * FROM productimages WHERE product_id = '1531' ORDER BY sortorder ASC
211 0.0003 0.00033092498779297 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1531' AND p.id = pi.product_id ORDER BY pi.sortorder
212 0.0004 0.00044894218444824 
SELECT * FROM product_image_select WHERE product_id = '1531'
213 0.0003 0.00026178359985352 
SELECT * FROM productcustomimages WHERE product_id = '1531'
214 0.0003 0.00031590461730957 
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 = '1531'
                GROUP BY o.product_id
215 0.0004 0.00038003921508789 
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     = '1531'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
216 0.0003 0.00026106834411621 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1531
217 0.0005 0.00051307678222656 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1531' AND a.name = n.originalname
218 0.0002 0.00023984909057617 
SELECT * FROM productoffers WHERE product_id = '1531' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0003 0.00025606155395508 
SELECT * FROM productoffers
                WHERE product_id = '1531' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00022506713867188 
SELECT * FROM productoffers
                WHERE product_id = 1531
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00023198127746582 
SELECT value FROM productattributes
                WHERE product_id = '1531'
                AND name = 'ListPriceAmount'
222 0.0002 0.00024890899658203 
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 = '1531'
                GROUP BY o.product_id
223 0.0004 0.00036787986755371 
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     = '1531'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
224 0.0002 0.00023794174194336 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1531
225 0.0003 0.00031900405883789 
SELECT value FROM productattributes WHERE product_id = '1531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0004 0.00035691261291504 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1531'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
227 0.0003 0.00025010108947754 
SELECT * FROM products WHERE parent_id = '1531'
228 0.0003 0.00032210350036621 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4802' AND a.name = n.originalname
229 0.0003 0.00031805038452148 
SELECT * FROM productoffers WHERE product_id = '4802' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = '4802' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0002 0.00021481513977051 
SELECT * FROM productoffers
                WHERE product_id = 4802
                ORDER BY price ASC LIMIT 1
232 0.0002 0.00022983551025391 
SELECT value FROM productattributes
                WHERE product_id = '4802'
                AND name = 'ListPriceAmount'
233 0.0003 0.00030994415283203 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0007 0.00074505805969238 
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0003 0.00027203559875488 
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0006 0.00060701370239258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0003 0.00030899047851562 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0003 0.00025701522827148 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0003 0.00026392936706543 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0003 0.00032615661621094 
SELECT * FROM productimages WHERE product_id = '3545' ORDER BY sortorder ASC
241 0.0004 0.00043201446533203 
SELECT * FROM product_image_select WHERE product_id = '3545'
242 0.0003 0.00027203559875488 
SELECT * FROM productcustomimages WHERE product_id = '3545'
243 0.0006 0.00061893463134766 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3545' AND a.name = n.originalname
244 0.0003 0.00030803680419922 
SELECT * FROM productoffers WHERE product_id = '3545' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0002 0.00024890899658203 
SELECT * FROM productoffers
                WHERE product_id = '3545' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0002 0.00023317337036133 
SELECT * FROM productoffers
                WHERE product_id = 3545
                ORDER BY price ASC LIMIT 1
247 0.0003 0.00025391578674316 
SELECT value FROM productattributes
                WHERE product_id = '3545'
                AND name = 'ListPriceAmount'
248 0.0003 0.00026988983154297 
SELECT value FROM productattributes WHERE product_id = '3545' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249 0.0003 0.00034403800964355 
SELECT * FROM productimages WHERE product_id = '2019' ORDER BY sortorder ASC
250 0.0004 0.00042605400085449 
SELECT * FROM product_image_select WHERE product_id = '2019'
251 0.0003 0.00026106834411621 
SELECT * FROM productcustomimages WHERE product_id = '2019'
252 0.0006 0.00064301490783691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2019' AND a.name = n.originalname
253 0.0003 0.00031304359436035 
SELECT * FROM productoffers WHERE product_id = '2019' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0003 0.0002598762512207 
SELECT * FROM productoffers
                WHERE product_id = '2019' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0005 0.0005490779876709 
SELECT value FROM productattributes WHERE product_id = '2019' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0004 0.00041103363037109 
SELECT * FROM productimages WHERE product_id = '1512' ORDER BY sortorder ASC
257 0.0004 0.00043416023254395 
SELECT * FROM product_image_select WHERE product_id = '1512'
258 0.0003 0.00028014183044434 
SELECT * FROM productcustomimages WHERE product_id = '1512'
259 0.0007 0.00066184997558594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1512' AND a.name = n.originalname
260 0.0003 0.0003049373626709 
SELECT * FROM productoffers WHERE product_id = '1512' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = '1512' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0002 0.00023484230041504 
SELECT * FROM productoffers
                WHERE product_id = 1512
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00025200843811035 
SELECT value FROM productattributes
                WHERE product_id = '1512'
                AND name = 'ListPriceAmount'
264 0.0003 0.00027203559875488 
SELECT value FROM productattributes WHERE product_id = '1512' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0007 0.00074601173400879 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1575' ORDER BY timestamp DESC
266 0.0002 0.00021600723266602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '845' ORDER BY timestamp DESC
267 0.0002 0.00020313262939453 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '844' ORDER BY timestamp DESC
268 0.0003 0.00026082992553711 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1243' ORDER BY timestamp DESC
269 0.0002 0.00021910667419434 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '788' ORDER BY timestamp DESC
270 0.0002 0.00020313262939453 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1342' ORDER BY timestamp DESC
271 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1285' ORDER BY timestamp DESC
272 0.0002 0.00020694732666016 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1404' ORDER BY timestamp DESC
273 0.0002 0.00020194053649902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1116' ORDER BY timestamp DESC
274 0.0002 0.0001990795135498 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1543' ORDER BY timestamp DESC
275 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1149' ORDER BY timestamp DESC
276 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1487' ORDER BY timestamp DESC
277 0.0002 0.00020313262939453 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3594' ORDER BY timestamp DESC
278 0.0002 0.0001990795135498 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1531' ORDER BY timestamp DESC
279 0.0002 0.00020813941955566 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '777' ORDER BY timestamp DESC
280 0.0002 0.00020194053649902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3545' ORDER BY timestamp DESC
281 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2019' ORDER BY timestamp DESC
282 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1512' ORDER BY timestamp DESC
283 0.0007 0.00067305564880371 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
284 0.0006 0.00060796737670898 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
285 0.0003 0.00025105476379395 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
286 0.0114 0.011449098587036 
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
287 0.0008 0.00080704689025879 
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
288 0.0004 0.00038504600524902 
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
289 0.0003 0.00034618377685547 
SELECT * FROM products WHERE id = 1626
290 0.0003 0.00026798248291016 
SELECT * FROM products WHERE id = 4041
291 0.0002 0.00023889541625977 
SELECT * FROM products WHERE id = 4312
292 0.0003 0.00025105476379395 
SELECT * FROM products WHERE id = 777
293 0.0003 0.00031304359436035 
SELECT * FROM products WHERE id = 3881
294 0.0002 0.00024104118347168 
SELECT * FROM products WHERE id = 4213
295 0.0003 0.00027608871459961 
SELECT * FROM products WHERE id = '1626'
296 0.0006 0.00062894821166992 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
297 0.0005 0.00045680999755859 
SELECT * FROM product_image_select WHERE product_id = '1626'
298 0.0003 0.00026702880859375 
SELECT * FROM productcustomimages WHERE product_id = '1626'
299 0.0006 0.0005791187286377 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
300 0.0003 0.00031590461730957 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
301 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
302 0.0003 0.00027608871459961 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303 0.0004 0.00040006637573242 
SELECT * FROM products WHERE id = '4041'
304 0.0003 0.00030708312988281 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
305 0.0004 0.00043320655822754 
SELECT * FROM product_image_select WHERE product_id = '4041'
306 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '4041'
307 0.0007 0.00068497657775879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
308 0.0003 0.00031089782714844 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
311 0.0003 0.00032901763916016 
SELECT * FROM products WHERE id = '4312'
312 0.0003 0.00030112266540527 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
313 0.0005 0.00045990943908691 
SELECT * FROM product_image_select WHERE product_id = '4312'
314 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '4312'
315 0.0007 0.00065493583679199 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
316 0.0003 0.00031113624572754 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
317 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
318 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319 0.0003 0.00032401084899902 
SELECT * FROM products WHERE id = '777'
320 0.0003 0.00031089782714844 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
321 0.0005 0.00046801567077637 
SELECT * FROM product_image_select WHERE product_id = '777'
322 0.0003 0.00026917457580566 
SELECT * FROM productcustomimages WHERE product_id = '777'
323 0.0007 0.00066113471984863 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
324 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
325 0.0003 0.00026679039001465 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
326 0.0003 0.00026392936706543 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
327 0.0003 0.00032901763916016 
SELECT * FROM products WHERE id = '3881'
328 0.0003 0.00033807754516602 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
329 0.0004 0.00043201446533203 
SELECT * FROM product_image_select WHERE product_id = '3881'
330 0.0003 0.00026416778564453 
SELECT * FROM productcustomimages WHERE product_id = '3881'
331 0.0007 0.00068092346191406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
332 0.0003 0.00030303001403809 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
333 0.0003 0.00025081634521484 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
334 0.0003 0.0002741813659668 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
335 0.0004 0.00042605400085449 
SELECT * FROM products WHERE id = '4213'
336 0.0004 0.00035905838012695 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
337 0.0005 0.00045585632324219 
SELECT * FROM product_image_select WHERE product_id = '4213'
338 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '4213'
339 0.0007 0.00068902969360352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
340 0.0003 0.0003058910369873 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
341 0.0003 0.00025105476379395 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
342 0.0003 0.00025510787963867 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
343 0.0010 0.00098299980163574 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
344 0.0005 0.00047516822814941 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
345 0.0014 0.0014159679412842 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
346 0.0008 0.00082612037658691 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347 0.0004 0.00037002563476562 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
348 0.0004 0.0003669261932373 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
349 0.0004 0.00040102005004883 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'