0
  1. My Store
  2. Best Sellers

Best Sellers

These are our current bestselling products - popular with our customers not only for the price, but for the great quality!

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
3.2877690792084 313 0.8274 0


No Amazon API Requests Made.


App Debug - Total Time 3.2877690792084 seconds

Number Time From Start Name Description
1 2.2048559188843 Initialise Initialise FSB Function
2 2.211611032486 App Controller Start Start of the App controller (called before the controller of every page)
3 2.2518780231476 Start of getCategoryListByGroup Function Before first category groups query
4 2.2532949447632 After initial query Before first category groups query
5 2.2532970905304 Get Category List for Group Before the call to getCategoryList function
6 2.2532999515533 Start of GetCategoryList function Start of the function
7 2.2533030509949 Before getting categories Query to get specific category list
8 2.2548320293427 After getting categories Query to get specific category list
9 2.254832983017 Before getting category custom Before call to function getCategoryCustom
10 2.2774939537048 After getting category custom After call to function getCategoryCustom
11 2.2774980068207 Before getting category custom Before call to function getCategoryCustom
12 2.2884480953217 After getting category custom After call to function getCategoryCustom
13 2.2884531021118 Before getting category custom Before call to function getCategoryCustom
14 2.2951331138611 After getting category custom After call to function getCategoryCustom
15 2.2951369285583 Before getting category custom Before call to function getCategoryCustom
16 2.2999179363251 After getting category custom After call to function getCategoryCustom
17 2.2999200820923 Before getting category custom Before call to function getCategoryCustom
18 2.3046879768372 After getting category custom After call to function getCategoryCustom
19 2.3046901226044 Before getting category custom Before call to function getCategoryCustom
20 2.3095619678497 After getting category custom After call to function getCategoryCustom
21 2.3095641136169 End of GetCategoryList function End of the function
22 2.3095710277557 Get Category List for Group Before the call to getCategoryList function
23 2.3095729351044 Start of GetCategoryList function Start of the function
24 2.3095750808716 Before getting categories Query to get specific category list
25 2.3101069927216 End of getCategoryListByGroup Function Before return()
26 2.7652180194855 App Controller End End of the App controller (called before the controller of every page)
27 3.0246150493622 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 3.0262830257416 Before Get Options Before the call to getOptions in the tpl class
29 3.0865650177002 After Get Options After the call to getOptions in the tpl class
30 3.086837053299 App_after Controller End End of the App_after controller (called after the controller of every page)
31 3.2877399921417 Finalizing debug Before the debug is output to the page.
32 3.2877669334412 End of App This is the end of the app logging, final timestamp


Query Debug - 313 Database Queries. Total time 0.8274 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0023789405822754 
SELECT parameter, value FROM parameters
2 0.0048 0.0048151016235352 
SELECT * FROM `bad_bots`
3 0.0004 0.00041508674621582 
SET time_zone = 'Europe/London'
4 0.0030 0.0029990673065186 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0034 0.0033831596374512 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"52.14.44.232\";}'
6 0.0031 0.0031280517578125 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738738726'
7 0.0045 0.0045359134674072 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0010089874267578 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0037 0.0036790370941162 
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
10 0.0007 0.0007011890411377 
SELECT * FROM pages WHERE id = 44
11 0.0057 0.0057430267333984 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0332 0.033232927322388 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00079011917114258 
SELECT * FROM pages WHERE pagename = 'best-sellers'
14 0.0014 0.0014011859893799 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0015060901641846 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0077 0.0076870918273926 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0018 0.0018389225006104 
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.0013 0.0012791156768799 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00049114227294922 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0058679580688477 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0016 0.0016350746154785 
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.0017390251159668 
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.0014791488647461 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00048089027404785 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0036 0.0035598278045654 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00049304962158203 
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.00040102005004883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.0004270076751709 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0037760734558105 
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.0006 0.00060701370239258 
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.0006 0.00055503845214844 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00053119659423828 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00048208236694336 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014650821685791 
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.00054597854614258 
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.0005 0.00046515464782715 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00045204162597656 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015959739685059 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0005 0.00051689147949219 
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.00059008598327637 
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.00050592422485352 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00044107437133789 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061798095703125 
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.0004730224609375 
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.00040698051452637 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00047993659973145 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00070405006408691 
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.00051712989807129 
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.00057315826416016 
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.00045084953308105 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046801567077637 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066018104553223 
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.00045490264892578 
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.00040984153747559 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00043106079101562 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00070095062255859 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0005 0.00053215026855469 
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.00055098533630371 
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.00050997734069824 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.0004279613494873 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.0006868839263916 
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.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 = 31
63 0.0004 0.00043106079101562 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00043606758117676 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00071096420288086 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0005 0.0005030632019043 
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.0006 0.00055718421936035 
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.0005 0.00047588348388672 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00042605400085449 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00052094459533691 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0029189586639404 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.001582145690918 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00060296058654785 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0012 0.0012490749359131 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011470317840576 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012049674987793 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4403 0.44030809402466 
SELECT * FROM ipgeocountries WHERE INET_ATON('52.14.44.232') >= INET_ATON(ip_start) AND INET_ATON('52.14.44.232') <= INET_ATON(ip_end)
78 0.0022 0.00217604637146 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.0012011528015137 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0014 0.001378059387207 
SELECT * FROM pages WHERE pagename = 'best-sellers'
81 0.0138 0.013791084289551 
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
82 0.0061 0.0061240196228027 
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
83 0.0085 0.0085189342498779 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
84 0.0022 0.0022339820861816 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
85 0.0030 0.0029740333557129 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
86 0.0095 0.0095319747924805 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
87 0.0023 0.0023460388183594 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
88 0.0010 0.00095105171203613 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
89 0.0009 0.00087499618530273 
SELECT id,asin FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		
		AND salesrank <> 0
		AND 1 = 1
		ORDER BY salesrank ASC
		LIMIT 20
90 0.0007 0.0006868839263916 
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
91 0.0007 0.00065302848815918 
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
92 0.0016 0.0015668869018555 
SELECT * FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		
		AND salesrank <> 0
		AND 1 = 1
		AND id IN (4950,4953,4933,4926,4925,868,4919,2029,862,1011,4122,1010,1140,1061,2165,4939,1110,4930,1160,4940)
		ORDER BY salesrank ASC
		LIMIT 0, 18
93 0.0031 0.0031149387359619 
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
94 0.0024 0.0024209022521973 
SELECT * FROM product_image_select WHERE product_id = '4953'
95 0.0018 0.0017659664154053 
SELECT * FROM productcustomimages WHERE product_id = '4953'
96 0.0025 0.0025138854980469 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
97 0.0019 0.0019288063049316 
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00049304962158203 
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0007 0.00065517425537109 
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0007 0.0007021427154541 
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
101 0.0007 0.00069212913513184 
SELECT * FROM product_image_select WHERE product_id = '4950'
102 0.0005 0.00048398971557617 
SELECT * FROM productcustomimages WHERE product_id = '4950'
103 0.0011 0.001068115234375 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
104 0.0006 0.00057387351989746 
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0005 0.00045084953308105 
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0005 0.00050091743469238 
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0006 0.00064396858215332 
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
108 0.0007 0.00072693824768066 
SELECT * FROM product_image_select WHERE product_id = '4933'
109 0.0005 0.00053000450134277 
SELECT * FROM productcustomimages WHERE product_id = '4933'
110 0.0037 0.0037200450897217 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
111 0.0008 0.00075888633728027 
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0006 0.0005638599395752 
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0007 0.00066399574279785 
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0008 0.00082111358642578 
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
115 0.0008 0.00079679489135742 
SELECT * FROM product_image_select WHERE product_id = '4926'
116 0.0006 0.00057411193847656 
SELECT * FROM productcustomimages WHERE product_id = '4926'
117 0.0039 0.0039081573486328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
118 0.0007 0.00065517425537109 
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0006 0.0005950927734375 
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0006 0.00062704086303711 
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
122 0.0007 0.00069808959960938 
SELECT * FROM product_image_select WHERE product_id = '4925'
123 0.0006 0.0006110668182373 
SELECT * FROM productcustomimages WHERE product_id = '4925'
124 0.0015 0.00152587890625 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
125 0.0007 0.00066399574279785 
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0006 0.00059700012207031 
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0006 0.00061297416687012 
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0008 0.00079011917114258 
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
129 0.0008 0.00084710121154785 
SELECT * FROM product_image_select WHERE product_id = '868'
130 0.0005 0.00054502487182617 
SELECT * FROM productcustomimages WHERE product_id = '868'
131 0.0011 0.001121997833252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
132 0.0006 0.00056004524230957 
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00047492980957031 
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00052189826965332 
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0008 0.00075006484985352 
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
136 0.0007 0.00065207481384277 
SELECT * FROM product_image_select WHERE product_id = '4919'
137 0.0005 0.00045680999755859 
SELECT * FROM productcustomimages WHERE product_id = '4919'
138 0.0012 0.0012259483337402 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
139 0.0005 0.00054097175598145 
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00045895576477051 
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0006 0.00064802169799805 
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.00067496299743652 
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
143 0.0010 0.0010149478912354 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
144 0.0006 0.00062298774719238 
SELECT * FROM product_image_select WHERE product_id = '2029'
145 0.0005 0.00048708915710449 
SELECT * FROM productcustomimages WHERE product_id = '2029'
146 0.0007 0.00072789192199707 
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 = '2029'
                GROUP BY o.product_id
147 0.0037 0.0036771297454834 
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0007 0.00068283081054688 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
149 0.0010 0.00096511840820312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
150 0.0004 0.00043797492980957 
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0005 0.00049281120300293 
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00051212310791016 
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
153 0.0008 0.00081396102905273 
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
154 0.0006 0.00055384635925293 
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 = '2029'
                GROUP BY o.product_id
155 0.0009 0.00093293190002441 
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
156 0.0006 0.00055885314941406 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
157 0.0007 0.00067591667175293 
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0007 0.00070714950561523 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
159 0.0011 0.001101016998291 
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
160 0.0007 0.00069189071655273 
SELECT * FROM product_image_select WHERE product_id = '862'
161 0.0004 0.00043916702270508 
SELECT * FROM productcustomimages WHERE product_id = '862'
162 0.0011 0.001147985458374 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
163 0.0005 0.00054097175598145 
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00052595138549805 
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00050497055053711 
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0007 0.00073003768920898 
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
167 0.0006 0.00063395500183105 
SELECT * FROM product_image_select WHERE product_id = '1011'
168 0.0005 0.00045919418334961 
SELECT * FROM productcustomimages WHERE product_id = '1011'
169 0.0009 0.00092697143554688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
170 0.0014 0.0014498233795166 
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0010 0.00099492073059082 
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0010 0.00098204612731934 
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0011 0.001147985458374 
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
174 0.0021 0.0020711421966553 
SELECT * FROM product_image_select WHERE product_id = '4122'
175 0.0008 0.0008089542388916 
SELECT * FROM productcustomimages WHERE product_id = '4122'
176 0.0027 0.0027029514312744 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
177 0.0010 0.0010499954223633 
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0008 0.0007631778717041 
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0008 0.00076103210449219 
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0010 0.00095891952514648 
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
181 0.0017 0.0016708374023438 
SELECT * FROM product_image_select WHERE product_id = '1140'
182 0.0009 0.00086498260498047 
SELECT * FROM productcustomimages WHERE product_id = '1140'
183 0.0018 0.0017750263214111 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
184 0.0010 0.00096797943115234 
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0007 0.0007319450378418 
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0008 0.00082802772521973 
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0009 0.00093698501586914 
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
188 0.0011 0.0010831356048584 
SELECT * FROM product_image_select WHERE product_id = '1010'
189 0.0010 0.00096678733825684 
SELECT * FROM productcustomimages WHERE product_id = '1010'
190 0.0015 0.001533031463623 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
191 0.0006 0.00058412551879883 
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0006 0.0006098747253418 
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0007 0.00069212913513184 
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0008 0.000762939453125 
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
195 0.0011 0.001072883605957 
SELECT * FROM product_image_select WHERE product_id = '2165'
196 0.0008 0.00077009201049805 
SELECT * FROM productcustomimages WHERE product_id = '2165'
197 0.0018 0.0017819404602051 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
198 0.0007 0.00067806243896484 
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0005 0.00049614906311035 
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0005 0.0005340576171875 
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0008 0.00082707405090332 
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
202 0.0008 0.00077009201049805 
SELECT * FROM product_image_select WHERE product_id = '1061'
203 0.0005 0.00050020217895508 
SELECT * FROM productcustomimages WHERE product_id = '1061'
204 0.0014 0.0014388561248779 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
205 0.0006 0.00057291984558105 
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0005 0.00047183036804199 
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0005 0.00050997734069824 
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0006 0.00063586235046387 
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
209 0.0008 0.00078296661376953 
SELECT * FROM product_image_select WHERE product_id = '4939'
210 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '4939'
211 0.0013 0.0012729167938232 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
212 0.0005 0.00050997734069824 
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0004 0.00041985511779785 
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0006 0.00062203407287598 
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0011 0.0010771751403809 
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
216 0.0011 0.0010771751403809 
SELECT * FROM product_image_select WHERE product_id = '1110'
217 0.0004 0.00044918060302734 
SELECT * FROM productcustomimages WHERE product_id = '1110'
218 0.0011 0.0011069774627686 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
219 0.0006 0.00056195259094238 
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0005 0.00048208236694336 
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0007 0.00065493583679199 
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0008 0.00083518028259277 
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
223 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '4930'
224 0.0004 0.00039792060852051 
SELECT * FROM productcustomimages WHERE product_id = '4930'
225 0.0017 0.0016951560974121 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
226 0.0005 0.00053119659423828 
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.00052094459533691 
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00051498413085938 
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0018 0.0018088817596436 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
230 0.0004 0.00036406517028809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
231 0.0003 0.00029420852661133 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
232 0.0003 0.00027108192443848 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
233 0.0003 0.00029397010803223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
234 0.0003 0.00029182434082031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
235 0.0003 0.00029420852661133 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
236 0.0003 0.00027298927307129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
237 0.0003 0.00029110908508301 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
238 0.0003 0.00026202201843262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
239 0.0003 0.00028705596923828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
240 0.0003 0.00028109550476074 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
241 0.0004 0.00039792060852051 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
242 0.0003 0.00027203559875488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
243 0.0003 0.0002901554107666 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
244 0.0004 0.00036382675170898 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
245 0.0003 0.00028491020202637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
246 0.0003 0.00029397010803223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
247 0.0016 0.0016050338745117 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
248 0.0013 0.0012660026550293 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
249 0.0003 0.00032401084899902 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
250 0.0147 0.014686822891235 
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
251 0.0017 0.00166916847229 
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
252 0.0006 0.00055098533630371 
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
253 0.0006 0.00061702728271484 
SELECT * FROM products WHERE id = 1626
254 0.0006 0.00057315826416016 
SELECT * FROM products WHERE id = 4041
255 0.0004 0.00040984153747559 
SELECT * FROM products WHERE id = 4312
256 0.0006 0.00058484077453613 
SELECT * FROM products WHERE id = 777
257 0.0006 0.00061607360839844 
SELECT * FROM products WHERE id = 3881
258 0.0005 0.0005190372467041 
SELECT * FROM products WHERE id = 4213
259 0.0005 0.00050902366638184 
SELECT * FROM products WHERE id = '1626'
260 0.0005 0.00051093101501465 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
261 0.0006 0.00060892105102539 
SELECT * FROM product_image_select WHERE product_id = '1626'
262 0.0004 0.0003969669342041 
SELECT * FROM productcustomimages WHERE product_id = '1626'
263 0.0011 0.0011489391326904 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
264 0.0005 0.00051999092102051 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0004 0.00038886070251465 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0004 0.00044608116149902 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0006 0.00055909156799316 
SELECT * FROM products WHERE id = '4041'
268 0.0004 0.00044608116149902 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
269 0.0006 0.00056695938110352 
SELECT * FROM product_image_select WHERE product_id = '4041'
270 0.0004 0.00035405158996582 
SELECT * FROM productcustomimages WHERE product_id = '4041'
271 0.0011 0.0011420249938965 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
272 0.0005 0.00047707557678223 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0005 0.00047922134399414 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0006 0.00056791305541992 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0006 0.00057482719421387 
SELECT * FROM products WHERE id = '4312'
276 0.0005 0.00049281120300293 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
277 0.0006 0.00060701370239258 
SELECT * FROM product_image_select WHERE product_id = '4312'
278 0.0004 0.00043106079101562 
SELECT * FROM productcustomimages WHERE product_id = '4312'
279 0.0010 0.0010499954223633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
280 0.0005 0.00048303604125977 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0006 0.00057482719421387 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0006 0.00060606002807617 
SELECT * FROM products WHERE id = '777'
284 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
285 0.0006 0.00059413909912109 
SELECT * FROM product_image_select WHERE product_id = '777'
286 0.0005 0.00050187110900879 
SELECT * FROM productcustomimages WHERE product_id = '777'
287 0.0011 0.0010509490966797 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
288 0.0005 0.00050806999206543 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0004 0.00041389465332031 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0006 0.00057697296142578 
SELECT * FROM products WHERE id = '3881'
292 0.0005 0.00052905082702637 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
293 0.0006 0.00062203407287598 
SELECT * FROM product_image_select WHERE product_id = '3881'
294 0.0004 0.00037598609924316 
SELECT * FROM productcustomimages WHERE product_id = '3881'
295 0.0012 0.0011839866638184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
296 0.0005 0.00048613548278809 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0007 0.00068187713623047 
SELECT * FROM products WHERE id = '4213'
300 0.0007 0.00066709518432617 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
301 0.0006 0.00058507919311523 
SELECT * FROM product_image_select WHERE product_id = '4213'
302 0.0006 0.00064206123352051 
SELECT * FROM productcustomimages WHERE product_id = '4213'
303 0.0015 0.0014948844909668 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
304 0.0005 0.00049614906311035 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0004 0.00040006637573242 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0005 0.00047111511230469 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0023 0.0022780895233154 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
308 0.0007 0.00072407722473145 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
309 0.0027 0.0027120113372803 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
310 0.0023 0.0023188591003418 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
311 0.0010 0.00095200538635254 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
312 0.0016 0.0016100406646729 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
313 0.0064 0.0064241886138916 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'