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.9525821208954 348 1.2911 0


No Amazon API Requests Made.


App Debug - Total Time 1.9525821208954 seconds

Number Time From Start Name Description
1 0.61704111099243 Initialise Initialise FSB Function
2 0.62070798873901 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65928792953491 Start of getCategoryListByGroup Function Before first category groups query
4 0.66097688674927 After initial query Before first category groups query
5 0.66097807884216 Get Category List for Group Before the call to getCategoryList function
6 0.6609799861908 Start of GetCategoryList function Start of the function
7 0.66098189353943 Before getting categories Query to get specific category list
8 0.66301488876343 After getting categories Query to get specific category list
9 0.66301608085632 Before getting category custom Before call to function getCategoryCustom
10 0.68669509887695 After getting category custom After call to function getCategoryCustom
11 0.68669700622559 Before getting category custom Before call to function getCategoryCustom
12 0.69915008544922 After getting category custom After call to function getCategoryCustom
13 0.69915199279785 Before getting category custom Before call to function getCategoryCustom
14 0.70797109603882 After getting category custom After call to function getCategoryCustom
15 0.70797300338745 Before getting category custom Before call to function getCategoryCustom
16 0.71286702156067 After getting category custom After call to function getCategoryCustom
17 0.71286797523499 Before getting category custom Before call to function getCategoryCustom
18 0.71804809570312 After getting category custom After call to function getCategoryCustom
19 0.71805000305176 Before getting category custom Before call to function getCategoryCustom
20 0.72439694404602 After getting category custom After call to function getCategoryCustom
21 0.72439908981323 End of GetCategoryList function End of the function
22 0.72440409660339 Get Category List for Group Before the call to getCategoryList function
23 0.72440600395203 Start of GetCategoryList function Start of the function
24 0.72440791130066 Before getting categories Query to get specific category list
25 0.72488903999329 End of getCategoryListByGroup Function Before return()
26 1.6550140380859 App Controller End End of the App controller (called before the controller of every page)
27 1.8386828899384 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.8394958972931 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.8403360843658 Before Get Options Before the call to getOptions in the tpl class
30 1.9023470878601 After Get Options After the call to getOptions in the tpl class
31 1.9024739265442 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.9525740146637 Finalizing debug Before the debug is output to the page.
33 1.9525809288025 End of App This is the end of the app logging, final timestamp


Query Debug - 348 Database Queries. Total time 1.2911 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022859573364258 
SELECT parameter, value FROM parameters
2 0.0078 0.0078041553497314 
SELECT * FROM `bad_bots`
3 0.0005 0.00045585632324219 
SET time_zone = 'Europe/London'
4 0.0033 0.0032820701599121 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0031 0.003075122833252 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.117.79.92\";}'
6 0.0030 0.0029690265655518 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1744950503'
7 0.0030 0.0029580593109131 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00083303451538086 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0018 0.0018141269683838 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0005 0.00049400329589844 
SELECT * FROM pages WHERE id = 37
11 0.0041 0.0040798187255859 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0335 0.033500909805298 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00076603889465332 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0017 0.0016820430755615 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0020 0.0020198822021484 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0080 0.0079758167266846 
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.0021 0.0020551681518555 
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.0011579990386963 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00047087669372559 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0066 0.0066180229187012 
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.0017 0.0017309188842773 
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.0017 0.0017058849334717 
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.0015 0.0014660358428955 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.0004119873046875 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0053 0.0053229331970215 
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.0006 0.00055503845214844 
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.00039815902709961 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00037693977355957 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0038390159606934 
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.00051212310791016 
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.00054001808166504 
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.0004 0.00044989585876465 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00039505958557129 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0013 0.0013389587402344 
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.00050783157348633 
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.0012 0.001215934753418 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0014 0.0014278888702393 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0021 0.0020599365234375 
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.0007 0.0006561279296875 
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.0006 0.00058412551879883 
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.0005040168762207 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00045394897460938 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00069594383239746 
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.00050091743469238 
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.00042104721069336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00040912628173828 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.0007479190826416 
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.00046205520629883 
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.0006 0.00061607360839844 
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.00051593780517578 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00047111511230469 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00065994262695312 
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.00051093101501465 
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.00043201446533203 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00046300888061523 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00083088874816895 
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.0006 0.00055217742919922 
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.0006 0.00061607360839844 
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.00052809715270996 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00053906440734863 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00080394744873047 
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.0010 0.0010330677032471 
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.0006 0.00055098533630371 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00050497055053711 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00091814994812012 
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.0006 0.00064396858215332 
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.0008 0.00076198577880859 
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.0005 0.00051593780517578 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00047397613525391 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.0015079975128174 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00057792663574219 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00063300132751465 
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.0005 0.00049209594726562 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011160373687744 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0013210773468018 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.9221 0.92212414741516 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.79.92') >= INET_ATON(ip_start) AND INET_ATON('18.117.79.92') <= INET_ATON(ip_end)
78 0.0012 0.0011699199676514 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00046706199645996 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00056791305541992 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0077 0.0076520442962646 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0025 0.0025110244750977 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0009 0.00085806846618652 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0073 0.0073249340057373 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0016 0.0015881061553955 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0005 0.0004880428314209 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0045 0.0045499801635742 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0052 0.0051679611206055 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0015 0.0014541149139404 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0005 0.00047588348388672 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0031 0.0031018257141113 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 72, 18
92 0.0006 0.0006248950958252 
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
93 0.0007 0.00065302848815918 
SELECT * FROM product_image_select WHERE product_id = '810'
94 0.0005 0.00045609474182129 
SELECT * FROM productcustomimages WHERE product_id = '810'
95 0.0012 0.001162052154541 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
96 0.0005 0.00048279762268066 
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0004 0.0004420280456543 
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0004 0.00043702125549316 
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0004 0.00044608116149902 
SELECT * FROM productimages WHERE product_id = '1917' ORDER BY sortorder ASC
100 0.0005 0.00053215026855469 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1917' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0006 0.00059700012207031 
SELECT * FROM product_image_select WHERE product_id = '1917'
102 0.0004 0.00042390823364258 
SELECT * FROM productcustomimages WHERE product_id = '1917'
103 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 = '1917'
                GROUP BY o.product_id
104 0.0007 0.00065112113952637 
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     = '1917'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
105 0.0004 0.0003960132598877 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1917
106 0.0008 0.0008080005645752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1917' AND a.name = n.originalname
107 0.0004 0.00037598609924316 
SELECT * FROM productoffers WHERE product_id = '1917' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.0004122257232666 
SELECT * FROM productoffers
                WHERE product_id = '1917' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00033283233642578 
SELECT * FROM productoffers
                WHERE product_id = 1917
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00041985511779785 
SELECT value FROM productattributes
                WHERE product_id = '1917'
                AND name = 'ListPriceAmount'
111 0.0005 0.00054311752319336 
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 = '1917'
                GROUP BY o.product_id
112 0.0007 0.00069785118103027 
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     = '1917'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
113 0.0004 0.00044584274291992 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1917
114 0.0004 0.0003819465637207 
SELECT * FROM products WHERE parent_id = '1917'
115 0.0005 0.00050592422485352 
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
116 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '3546'
117 0.0004 0.00039410591125488 
SELECT * FROM productcustomimages WHERE product_id = '3546'
118 0.0009 0.00094890594482422 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
119 0.0005 0.00046110153198242 
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00043296813964844 
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00040793418884277 
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.0004730224609375 
SELECT * FROM productimages WHERE product_id = '3743' ORDER BY sortorder ASC
123 0.0006 0.00063180923461914 
SELECT * FROM product_image_select WHERE product_id = '3743'
124 0.0004 0.00039887428283691 
SELECT * FROM productcustomimages WHERE product_id = '3743'
125 0.0008 0.00081300735473633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3743' AND a.name = n.originalname
126 0.0005 0.00051188468933105 
SELECT * FROM productoffers WHERE product_id = '3743' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '3743' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00041508674621582 
SELECT value FROM productattributes WHERE product_id = '3743' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '3204' ORDER BY sortorder ASC
130 0.0007 0.00067400932312012 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3204' AND p.id = pi.product_id ORDER BY pi.sortorder
131 0.0011 0.0010628700256348 
SELECT * FROM product_image_select WHERE product_id = '3204'
132 0.0006 0.00059103965759277 
SELECT * FROM productcustomimages WHERE product_id = '3204'
133 0.0007 0.00072383880615234 
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 = '3204'
                GROUP BY o.product_id
134 0.0008 0.00081586837768555 
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     = '3204'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0005 0.00046110153198242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
136 0.0011 0.0010590553283691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3204' AND a.name = n.originalname
137 0.0004 0.00040483474731445 
SELECT * FROM productoffers WHERE product_id = '3204' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0011 0.0010600090026855 
SELECT * FROM productoffers
                WHERE product_id = '3204' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00053596496582031 
SELECT * FROM productoffers
                WHERE product_id = 3204
                ORDER BY price ASC LIMIT 1
140 0.0006 0.00057005882263184 
SELECT value FROM productattributes
                WHERE product_id = '3204'
                AND name = 'ListPriceAmount'
141 0.0005 0.00053191184997559 
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 = '3204'
                GROUP BY o.product_id
142 0.0009 0.00086688995361328 
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     = '3204'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
143 0.0005 0.00052213668823242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
144 0.0007 0.00074481964111328 
SELECT value FROM productattributes WHERE product_id = '3204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0008 0.00081181526184082 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3204'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
146 0.0006 0.00062704086303711 
SELECT * FROM productimages WHERE product_id = '974' ORDER BY sortorder ASC
147 0.0008 0.00077009201049805 
SELECT * FROM product_image_select WHERE product_id = '974'
148 0.0005 0.00051498413085938 
SELECT * FROM productcustomimages WHERE product_id = '974'
149 0.0014 0.0013971328735352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname
150 0.0007 0.00066494941711426 
SELECT * FROM productoffers WHERE product_id = '974' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0006 0.00055384635925293 
SELECT * FROM productoffers
                WHERE product_id = '974' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00052809715270996 
SELECT value FROM productattributes WHERE product_id = '974' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0008 0.00075697898864746 
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
154 0.0007 0.00074315071105957 
SELECT * FROM product_image_select WHERE product_id = '931'
155 0.0005 0.00053215026855469 
SELECT * FROM productcustomimages WHERE product_id = '931'
156 0.0011 0.0011200904846191 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
157 0.0006 0.00058603286743164 
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0006 0.00055193901062012 
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00052690505981445 
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0006 0.0006098747253418 
SELECT * FROM productimages WHERE product_id = '1115' ORDER BY sortorder ASC
161 0.0008 0.00083303451538086 
SELECT * FROM product_image_select WHERE product_id = '1115'
162 0.0006 0.00059413909912109 
SELECT * FROM productcustomimages WHERE product_id = '1115'
163 0.0019 0.0019290447235107 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
164 0.0007 0.00066804885864258 
SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0006 0.00060296058654785 
SELECT * FROM productoffers
                WHERE product_id = '1115' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00060105323791504 
SELECT value FROM productattributes WHERE product_id = '1115' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0007 0.00065279006958008 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
168 0.0008 0.0007779598236084 
SELECT * FROM product_image_select WHERE product_id = '1204'
169 0.0006 0.00057792663574219 
SELECT * FROM productcustomimages WHERE product_id = '1204'
170 0.0010 0.0010120868682861 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
171 0.0007 0.00066900253295898 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0005 0.00053095817565918 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0006 0.00060606002807617 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0006 0.00061392784118652 
SELECT * FROM productimages WHERE product_id = '3134' ORDER BY sortorder ASC
175 0.0008 0.00080585479736328 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3134' AND p.id = pi.product_id ORDER BY pi.sortorder
176 0.0009 0.00085997581481934 
SELECT * FROM product_image_select WHERE product_id = '3134'
177 0.0006 0.00055098533630371 
SELECT * FROM productcustomimages WHERE product_id = '3134'
178 0.0007 0.00067305564880371 
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 = '3134'
                GROUP BY o.product_id
179 0.0010 0.0010311603546143 
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
180 0.0006 0.00061511993408203 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
181 0.0011 0.0011281967163086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname
182 0.0004 0.00043988227844238 
SELECT * FROM productoffers WHERE product_id = '3134' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0005 0.00048303604125977 
SELECT * FROM productoffers
                WHERE product_id = '3134' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0005 0.00049996376037598 
SELECT * FROM productoffers
                WHERE product_id = 3134
                ORDER BY price ASC LIMIT 1
185 0.0005 0.0005490779876709 
SELECT value FROM productattributes
                WHERE product_id = '3134'
                AND name = 'ListPriceAmount'
186 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 = '3134'
                GROUP BY o.product_id
187 0.0010 0.00095486640930176 
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
188 0.0005 0.00053501129150391 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
189 0.0007 0.00069117546081543 
SELECT value FROM productattributes WHERE product_id = '3134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0008 0.0008389949798584 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3134'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
191 0.0007 0.00066804885864258 
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
192 0.0008 0.00078487396240234 
SELECT * FROM product_image_select WHERE product_id = '4944'
193 0.0006 0.00056600570678711 
SELECT * FROM productcustomimages WHERE product_id = '4944'
194 0.0023 0.002269983291626 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
195 0.0007 0.0006568431854248 
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0005 0.00051999092102051 
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0004 0.00043892860412598 
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
198 0.0005 0.00049304962158203 
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
199 0.0006 0.00055503845214844 
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.00063204765319824 
SELECT * FROM productimages WHERE product_id = '4505' ORDER BY sortorder ASC
201 0.0008 0.00078177452087402 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4505' AND p.id = pi.product_id ORDER BY pi.sortorder
202 0.0013 0.0012729167938232 
SELECT * FROM product_image_select WHERE product_id = '4505'
203 0.0008 0.00077486038208008 
SELECT * FROM productcustomimages WHERE product_id = '4505'
204 0.0011 0.0011301040649414 
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 = '4505'
                GROUP BY o.product_id
205 0.0017 0.0016739368438721 
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     = '4505'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
206 0.0008 0.00081419944763184 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
207 0.0016 0.0015590190887451 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4505' AND a.name = n.originalname
208 0.0006 0.000579833984375 
SELECT * FROM productoffers WHERE product_id = '4505' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0006 0.00060796737670898 
SELECT * FROM productoffers
                WHERE product_id = '4505' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0006 0.00060296058654785 
SELECT * FROM productoffers
                WHERE product_id = 4505
                ORDER BY price ASC LIMIT 1
211 0.0007 0.00069189071655273 
SELECT value FROM productattributes
                WHERE product_id = '4505'
                AND name = 'ListPriceAmount'
212 0.0007 0.00074601173400879 
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 = '4505'
                GROUP BY o.product_id
213 0.0013 0.0013060569763184 
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     = '4505'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
214 0.0008 0.00080394744873047 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
215 0.0012 0.0011730194091797 
SELECT value FROM productattributes WHERE product_id = '4505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0013 0.0013129711151123 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4505'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
217 0.0007 0.00073599815368652 
SELECT * FROM products WHERE parent_id = '4505'
218 0.0011 0.0010740756988525 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4506' AND a.name = n.originalname
219 0.0009 0.00086688995361328 
SELECT * FROM productoffers WHERE product_id = '4506' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0007 0.00067496299743652 
SELECT * FROM productimages WHERE product_id = '796' ORDER BY sortorder ASC
221 0.0009 0.00086307525634766 
SELECT * FROM product_image_select WHERE product_id = '796'
222 0.0006 0.00056791305541992 
SELECT * FROM productcustomimages WHERE product_id = '796'
223 0.0013 0.0012938976287842 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '796' AND a.name = n.originalname
224 0.0007 0.00068807601928711 
SELECT * FROM productoffers WHERE product_id = '796' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0006 0.00055408477783203 
SELECT * FROM productoffers
                WHERE product_id = '796' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00044703483581543 
SELECT * FROM productoffers
                WHERE product_id = 796
                ORDER BY price ASC LIMIT 1
227 0.0005 0.00053095817565918 
SELECT value FROM productattributes
                WHERE product_id = '796'
                AND name = 'ListPriceAmount'
228 0.0006 0.00060391426086426 
SELECT value FROM productattributes WHERE product_id = '796' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0008 0.00081777572631836 
SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
230 0.0009 0.00090789794921875 
SELECT * FROM product_image_select WHERE product_id = '1017'
231 0.0005 0.00053787231445312 
SELECT * FROM productcustomimages WHERE product_id = '1017'
232 0.0011 0.0010960102081299 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
233 0.0007 0.00071215629577637 
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0006 0.0005500316619873 
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0005 0.00051307678222656 
SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0006 0.00059700012207031 
SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC
237 0.0008 0.00078797340393066 
SELECT * FROM product_image_select WHERE product_id = '1201'
238 0.0005 0.00052881240844727 
SELECT * FROM productcustomimages WHERE product_id = '1201'
239 0.0013 0.0013320446014404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname
240 0.0006 0.00059986114501953 
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.00053691864013672 
SELECT * FROM productoffers
                WHERE product_id = '1201' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00051188468933105 
SELECT value FROM productattributes WHERE product_id = '1201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0007 0.00068187713623047 
SELECT * FROM productimages WHERE product_id = '1414' ORDER BY sortorder ASC
244 0.0012 0.0011990070343018 
SELECT * FROM product_image_select WHERE product_id = '1414'
245 0.0005 0.00051593780517578 
SELECT * FROM productcustomimages WHERE product_id = '1414'
246 0.0020 0.002007007598877 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1414' AND a.name = n.originalname
247 0.0009 0.00088620185852051 
SELECT * FROM productoffers WHERE product_id = '1414' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0023 0.0023109912872314 
SELECT * FROM productoffers
                WHERE product_id = '1414' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0008 0.00080204010009766 
SELECT value FROM productattributes WHERE product_id = '1414' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0007 0.00071096420288086 
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
251 0.0010 0.00096702575683594 
SELECT * FROM product_image_select WHERE product_id = '1217'
252 0.0007 0.00069999694824219 
SELECT * FROM productcustomimages WHERE product_id = '1217'
253 0.0020 0.002039909362793 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
254 0.0010 0.001039981842041 
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0005 0.00046992301940918 
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0005 0.0005028247833252 
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
258 0.0006 0.00059700012207031 
SELECT * FROM product_image_select WHERE product_id = '4917'
259 0.0005 0.00045490264892578 
SELECT * FROM productcustomimages WHERE product_id = '4917'
260 0.0011 0.0010700225830078 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
261 0.0005 0.00052690505981445 
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0005 0.00049281120300293 
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0005 0.00048494338989258 
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264 0.0006 0.00060200691223145 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '810' ORDER BY timestamp DESC
265 0.0004 0.00040602684020996 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1917' ORDER BY timestamp DESC
266 0.0004 0.00041389465332031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3546' ORDER BY timestamp DESC
267 0.0003 0.00034689903259277 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3743' ORDER BY timestamp DESC
268 0.0003 0.00033092498779297 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3204' ORDER BY timestamp DESC
269 0.0003 0.00030994415283203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '974' ORDER BY timestamp DESC
270 0.0003 0.00031185150146484 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '931' ORDER BY timestamp DESC
271 0.0003 0.00033903121948242 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1115' ORDER BY timestamp DESC
272 0.0004 0.00037217140197754 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1204' ORDER BY timestamp DESC
273 0.0004 0.00037407875061035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3134' ORDER BY timestamp DESC
274 0.0004 0.00038719177246094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4944' ORDER BY timestamp DESC
275 0.0003 0.00032520294189453 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4505' ORDER BY timestamp DESC
276 0.0003 0.0003201961517334 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '796' ORDER BY timestamp DESC
277 0.0003 0.00032210350036621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1017' ORDER BY timestamp DESC
278 0.0003 0.00034117698669434 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1201' ORDER BY timestamp DESC
279 0.0003 0.00031113624572754 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1414' ORDER BY timestamp DESC
280 0.0003 0.00032186508178711 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
281 0.0003 0.0003058910369873 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4917' ORDER BY timestamp DESC
282 0.0005 0.00050592422485352 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
283 0.0004 0.00043606758117676 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
284 0.0004 0.00036311149597168 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
285 0.0219 0.021929979324341 
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
286 0.0008 0.00082898139953613 
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
287 0.0007 0.00067400932312012 
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
288 0.0006 0.00055909156799316 
SELECT * FROM products WHERE id = 1626
289 0.0004 0.00037980079650879 
SELECT * FROM products WHERE id = 4041
290 0.0004 0.0004417896270752 
SELECT * FROM products WHERE id = 4312
291 0.0011 0.0011260509490967 
SELECT * FROM products WHERE id = 777
292 0.0006 0.00055408477783203 
SELECT * FROM products WHERE id = 3881
293 0.0005 0.00045990943908691 
SELECT * FROM products WHERE id = 4213
294 0.0005 0.00046181678771973 
SELECT * FROM products WHERE id = '1626'
295 0.0010 0.00095486640930176 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
296 0.0007 0.00067496299743652 
SELECT * FROM product_image_select WHERE product_id = '1626'
297 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '1626'
298 0.0013 0.0013339519500732 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
299 0.0006 0.00058102607727051 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0005 0.00049996376037598 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0005 0.0004727840423584 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0006 0.00056099891662598 
SELECT * FROM products WHERE id = '4041'
303 0.0005 0.00048303604125977 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
304 0.0007 0.00066399574279785 
SELECT * FROM product_image_select WHERE product_id = '4041'
305 0.0007 0.00074315071105957 
SELECT * FROM productcustomimages WHERE product_id = '4041'
306 0.0014 0.0013768672943115 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
307 0.0006 0.0005638599395752 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0005 0.00046086311340332 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00050210952758789 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0005 0.00052404403686523 
SELECT * FROM products WHERE id = '4312'
311 0.0005 0.00047802925109863 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
312 0.0007 0.00069594383239746 
SELECT * FROM product_image_select WHERE product_id = '4312'
313 0.0005 0.00049781799316406 
SELECT * FROM productcustomimages WHERE product_id = '4312'
314 0.0010 0.0010380744934082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
315 0.0005 0.00048303604125977 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0005 0.00053000450134277 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0005 0.00051999092102051 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0006 0.00057697296142578 
SELECT * FROM products WHERE id = '777'
319 0.0006 0.0006401538848877 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
320 0.0008 0.00081515312194824 
SELECT * FROM product_image_select WHERE product_id = '777'
321 0.0004 0.00041389465332031 
SELECT * FROM productcustomimages WHERE product_id = '777'
322 0.0010 0.001025915145874 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
323 0.0005 0.00049996376037598 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0004 0.00044488906860352 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0005 0.0004880428314209 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0006 0.00058603286743164 
SELECT * FROM products WHERE id = '3881'
327 0.0006 0.00057482719421387 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
328 0.0007 0.00066900253295898 
SELECT * FROM product_image_select WHERE product_id = '3881'
329 0.0005 0.00048112869262695 
SELECT * FROM productcustomimages WHERE product_id = '3881'
330 0.0011 0.0011250972747803 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
331 0.0005 0.00048398971557617 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0005 0.00047206878662109 
SELECT * FROM products WHERE id = '4213'
335 0.0005 0.00049090385437012 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
336 0.0007 0.00066280364990234 
SELECT * FROM product_image_select WHERE product_id = '4213'
337 0.0005 0.00048398971557617 
SELECT * FROM productcustomimages WHERE product_id = '4213'
338 0.0012 0.0012099742889404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
339 0.0005 0.00052618980407715 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0004 0.00044989585876465 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0009 0.00089097023010254 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
343 0.0006 0.00064611434936523 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
344 0.0014 0.0014231204986572 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
345 0.0006 0.00061988830566406 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0005 0.00047111511230469 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347 0.0013 0.0012719631195068 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
348 0.0011 0.001129150390625 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'