0

Best Sellers

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

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.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.3831419944763 314 1.0528 0


No Amazon API Requests Made.


App Debug - Total Time 2.3831419944763 seconds

Number Time From Start Name Description
1 1.0766961574554 Initialise Initialise FSB Function
2 1.0816090106964 App Controller Start Start of the App controller (called before the controller of every page)
3 1.1325430870056 Start of getCategoryListByGroup Function Before first category groups query
4 1.1343419551849 After initial query Before first category groups query
5 1.1343431472778 Get Category List for Group Before the call to getCategoryList function
6 1.1343500614166 Start of GetCategoryList function Start of the function
7 1.1343529224396 Before getting categories Query to get specific category list
8 1.135064125061 After getting categories Query to get specific category list
9 1.1350650787354 Before getting category custom Before call to function getCategoryCustom
10 1.1892290115356 After getting category custom After call to function getCategoryCustom
11 1.1892311573029 Before getting category custom Before call to function getCategoryCustom
12 1.2057869434357 After getting category custom After call to function getCategoryCustom
13 1.2057900428772 Before getting category custom Before call to function getCategoryCustom
14 1.2140641212463 After getting category custom After call to function getCategoryCustom
15 1.214066028595 Before getting category custom Before call to function getCategoryCustom
16 1.2191290855408 After getting category custom After call to function getCategoryCustom
17 1.2191309928894 Before getting category custom Before call to function getCategoryCustom
18 1.2243840694427 After getting category custom After call to function getCategoryCustom
19 1.2243869304657 Before getting category custom Before call to function getCategoryCustom
20 1.2296960353851 After getting category custom After call to function getCategoryCustom
21 1.2296991348267 End of GetCategoryList function End of the function
22 1.2297041416168 Get Category List for Group Before the call to getCategoryList function
23 1.2297060489655 Start of GetCategoryList function Start of the function
24 1.2297079563141 Before getting categories Query to get specific category list
25 1.2302401065826 End of getCategoryListByGroup Function Before return()
26 1.8587291240692 App Controller End End of the App controller (called before the controller of every page)
27 2.0538649559021 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 2.0552000999451 Before Get Options Before the call to getOptions in the tpl class
29 2.1321580410004 After Get Options After the call to getOptions in the tpl class
30 2.132385969162 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.3831300735474 Finalizing debug Before the debug is output to the page.
32 2.383141040802 End of App This is the end of the app logging, final timestamp


Query Debug - 314 Database Queries. Total time 1.0528 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010159015655518
SELECT parameter, value FROM parameters
2 0.0066 0.0066308975219727
SELECT * FROM `bad_bots`
3 0.0003 0.00028395652770996
SET time_zone = 'Europe/London'
4 0.0026 0.0026021003723145
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0032 0.003154993057251
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.15.25.144\";}'
6 0.0033 0.0033199787139893
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1729618343'
7 0.0032 0.0031521320343018
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047087669372559
UPDATE autorun SET lastrun = '2024-10-22 17:32:23' WHERE id = '17'
9 0.0009 0.00092005729675293
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0031 0.0031158924102783
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
11 0.0004 0.0004420280456543
SELECT * FROM pages WHERE id = 44
12 0.0048 0.0048041343688965
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0448 0.04483699798584
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00079703330993652
SELECT * FROM pages WHERE pagename = 'best-sellers'
15 0.0018 0.0017881393432617
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00069403648376465
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0270 0.027044057846069
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0009 0.000946044921875
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0015938282012939
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00053811073303223
SELECT id FROM categories WHERE parent_id = '26'
21 0.0130 0.012995958328247
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0025 0.0024878978729248
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0006 0.00062799453735352
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0045 0.0044679641723633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0033 0.0033490657806396
SELECT * FROM categorygroups WHERE id = '1'
26 0.0076 0.0076069831848145
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00054216384887695
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00042200088500977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00048494338989258
SELECT id FROM categories WHERE parent_id = '27'
30 0.0052 0.0052371025085449
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0006 0.00058817863464355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0006 0.00055098533630371
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0006 0.00057387351989746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00044679641723633
SELECT * FROM categorygroups WHERE id = '1'
35 0.0019 0.0018820762634277
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0006 0.00059294700622559
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0006 0.00060606002807617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0006 0.00057816505432129
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.0020408630371094
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0006 0.00064897537231445
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0006 0.00057291984558105
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0007 0.00072097778320312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00053906440734863
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00061511993408203
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0005 0.00054192543029785
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0005 0.00052881240844727
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00068521499633789
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0006 0.00061416625976562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00050806999206543
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0005 0.00052905082702637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0005 0.00047516822814941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00051498413085938
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00071597099304199
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0007 0.0006721019744873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0006 0.00059795379638672
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00051593780517578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00042581558227539
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00066900253295898
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.00054216384887695
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00043082237243652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00047016143798828
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00082707405090332
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0006 0.00062298774719238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0005 0.00054717063903809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0007 0.00065422058105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00045204162597656
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00052285194396973
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0019 0.0019280910491943
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00082492828369141
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00059390068054199
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0008 0.00084400177001953
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0011069774627686
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0010559558868408
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.6198 0.61984705924988
SELECT * FROM ipgeocountries WHERE INET_ATON('3.15.25.144') >= INET_ATON(ip_start) AND INET_ATON('3.15.25.144') <= INET_ATON(ip_end)
79 0.0011 0.0011489391326904
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0005 0.00045919418334961
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0005 0.00047707557678223
SELECT * FROM pages WHERE pagename = 'best-sellers'
82 0.0060 0.0060060024261475
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
83 0.0064 0.0063960552215576
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
84 0.0060 0.0059959888458252
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0022 0.002202033996582
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0005 0.00054502487182617
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
87 0.0053 0.0052521228790283
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
88 0.0016 0.0015809535980225
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0005 0.00046181678771973
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
90 0.0005 0.00046586990356445
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
91 0.0004 0.00042986869812012
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
92 0.0004 0.00042605400085449
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
93 0.0012 0.0012199878692627
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
94 0.0006 0.00057411193847656
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
95 0.0006 0.00058507919311523
SELECT * FROM product_image_select WHERE product_id = '4953'
96 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '4953'
97 0.0011 0.0010688304901123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
98 0.0004 0.00041484832763672
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
99 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
100 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0004 0.00044989585876465
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
102 0.0006 0.00056791305541992
SELECT * FROM product_image_select WHERE product_id = '4950'
103 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '4950'
104 0.0015 0.0015220642089844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
105 0.0006 0.00064706802368164
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0008 0.00081920623779297
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0005 0.00049495697021484
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
109 0.0006 0.00057005882263184
SELECT * FROM product_image_select WHERE product_id = '4933'
110 0.0003 0.00033712387084961
SELECT * FROM productcustomimages WHERE product_id = '4933'
111 0.0011 0.0010519027709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
112 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00042080879211426
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0007 0.0007319450378418
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00049304962158203
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
116 0.0008 0.00080204010009766
SELECT * FROM product_image_select WHERE product_id = '4926'
117 0.0005 0.00051784515380859
SELECT * FROM productcustomimages WHERE product_id = '4926'
118 0.0023 0.0022571086883545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
119 0.0007 0.00067901611328125
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0006 0.00059604644775391
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0007 0.00067806243896484
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0011 0.0011379718780518
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
123 0.0006 0.00056791305541992
SELECT * FROM product_image_select WHERE product_id = '4925'
124 0.0006 0.00062990188598633
SELECT * FROM productcustomimages WHERE product_id = '4925'
125 0.0040 0.0039529800415039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
126 0.0006 0.0006411075592041
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.00064706802368164
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0007 0.00072193145751953
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0026 0.0026369094848633
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
130 0.0009 0.00092983245849609
SELECT * FROM product_image_select WHERE product_id = '868'
131 0.0005 0.00054502487182617
SELECT * FROM productcustomimages WHERE product_id = '868'
132 0.0024 0.0024468898773193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
133 0.0010 0.00096797943115234
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.00052189826965332
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0007 0.00066304206848145
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0021 0.0021209716796875
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
137 0.0009 0.00086283683776855
SELECT * FROM product_image_select WHERE product_id = '4919'
138 0.0006 0.00059795379638672
SELECT * FROM productcustomimages WHERE product_id = '4919'
139 0.0037 0.0036540031433105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
140 0.0005 0.00054693222045898
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0007 0.00066685676574707
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0014 0.0013859272003174
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
144 0.0046 0.0045909881591797
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
145 0.0011 0.0010919570922852
SELECT * FROM product_image_select WHERE product_id = '2029'
146 0.0006 0.00059700012207031
SELECT * FROM productcustomimages WHERE product_id = '2029'
147 0.0009 0.00092506408691406
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
148 0.0019 0.0018839836120605
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
149 0.0005 0.0005190372467041
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
150 0.0026 0.0025720596313477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
151 0.0007 0.00069594383239746
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0007 0.00073599815368652
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0007 0.00072312355041504
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
154 0.0006 0.00057482719421387
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
155 0.0009 0.00086784362792969
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
156 0.0013 0.001255989074707
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
157 0.0009 0.00085091590881348
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
158 0.0011 0.0010509490966797
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0015 0.0014650821685791
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
160 0.0010 0.0010280609130859
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
161 0.0011 0.001101016998291
SELECT * FROM product_image_select WHERE product_id = '862'
162 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '862'
163 0.0055 0.005497932434082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
164 0.0007 0.00066399574279785
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0008 0.00075697898864746
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0007 0.00066304206848145
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
168 0.0009 0.00091910362243652
SELECT * FROM product_image_select WHERE product_id = '1011'
169 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '1011'
170 0.0029 0.0029449462890625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
171 0.0007 0.00066995620727539
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0007 0.00072193145751953
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0005 0.00053691864013672
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0006 0.00062894821166992
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
175 0.0008 0.0008389949798584
SELECT * FROM product_image_select WHERE product_id = '4122'
176 0.0006 0.00064706802368164
SELECT * FROM productcustomimages WHERE product_id = '4122'
177 0.0016 0.001582145690918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
178 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00050711631774902
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0010 0.0010418891906738
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
182 0.0032 0.0032069683074951
SELECT * FROM product_image_select WHERE product_id = '1140'
183 0.0005 0.00046706199645996
SELECT * FROM productcustomimages WHERE product_id = '1140'
184 0.0017 0.0017361640930176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
185 0.0006 0.00064396858215332
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0008 0.00075197219848633
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0006 0.00059199333190918
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0009 0.00087404251098633
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
189 0.0009 0.00087189674377441
SELECT * FROM product_image_select WHERE product_id = '1010'
190 0.0004 0.00038790702819824
SELECT * FROM productcustomimages WHERE product_id = '1010'
191 0.0024 0.0024399757385254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
192 0.0008 0.00080108642578125
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0007 0.00069379806518555
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0007 0.00071811676025391
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
196 0.0010 0.00095796585083008
SELECT * FROM product_image_select WHERE product_id = '2165'
197 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '2165'
198 0.0017 0.0017428398132324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
199 0.0005 0.00047683715820312
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0006 0.00055098533630371
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0007 0.00069093704223633
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0008 0.00078320503234863
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
203 0.0009 0.00092482566833496
SELECT * FROM product_image_select WHERE product_id = '1061'
204 0.0006 0.0006110668182373
SELECT * FROM productcustomimages WHERE product_id = '1061'
205 0.0027 0.0026779174804688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
206 0.0005 0.00049114227294922
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0006 0.0005950927734375
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0006 0.00064492225646973
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0007 0.00069403648376465
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
210 0.0008 0.00076889991760254
SELECT * FROM product_image_select WHERE product_id = '4939'
211 0.0006 0.00057101249694824
SELECT * FROM productcustomimages WHERE product_id = '4939'
212 0.0016 0.0015749931335449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
213 0.0005 0.00053310394287109
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0006 0.00059199333190918
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0007 0.0006718635559082
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0009 0.0008549690246582
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
217 0.0009 0.00088119506835938
SELECT * FROM product_image_select WHERE product_id = '1110'
218 0.0006 0.0006411075592041
SELECT * FROM productcustomimages WHERE product_id = '1110'
219 0.0017 0.0017449855804443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
220 0.0006 0.00058388710021973
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0006 0.0006258487701416
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0007 0.00065088272094727
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0008 0.00080704689025879
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
224 0.0008 0.00084805488586426
SELECT * FROM product_image_select WHERE product_id = '4930'
225 0.0006 0.00057482719421387
SELECT * FROM productcustomimages WHERE product_id = '4930'
226 0.0015 0.0014820098876953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
227 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0006 0.00061678886413574
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0006 0.00056290626525879
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0007 0.00073790550231934
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
231 0.0005 0.00049996376037598
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
232 0.0005 0.00051498413085938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
233 0.0005 0.00054478645324707
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
234 0.0006 0.00058293342590332
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
235 0.0005 0.00047898292541504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
236 0.0005 0.00053882598876953
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
237 0.0006 0.00056695938110352
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
238 0.0004 0.0004279613494873
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
239 0.0005 0.00050711631774902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
240 0.0006 0.00057101249694824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
241 0.0005 0.00047206878662109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
242 0.0004 0.00039792060852051
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
243 0.0006 0.00055098533630371
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
244 0.0005 0.00047802925109863
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
245 0.0005 0.00053095817565918
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
246 0.0006 0.00055980682373047
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
247 0.0005 0.00052905082702637
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
248 0.0006 0.00057196617126465
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
249 0.0008 0.00078296661376953
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
250 0.0005 0.00047707557678223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
251 0.0231 0.02311110496521
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
252 0.0013 0.001276969909668
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
253 0.0007 0.00069689750671387
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
254 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = 1626
255 0.0007 0.00065517425537109
SELECT * FROM products WHERE id = 4041
256 0.0006 0.00059008598327637
SELECT * FROM products WHERE id = 4312
257 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = 777
258 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 3881
259 0.0006 0.00063300132751465
SELECT * FROM products WHERE id = 4213
260 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = '1626'
261 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
262 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '1626'
263 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '1626'
264 0.0011 0.0011239051818848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
265 0.0006 0.00060296058654785
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0006 0.00063610076904297
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0007 0.00065493583679199
SELECT * FROM products WHERE id = '4041'
269 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
270 0.0011 0.0010790824890137
SELECT * FROM product_image_select WHERE product_id = '4041'
271 0.0004 0.00041699409484863
SELECT * FROM productcustomimages WHERE product_id = '4041'
272 0.0016 0.0016288757324219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
273 0.0009 0.00093507766723633
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0006 0.00059890747070312
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0008 0.00075197219848633
SELECT * FROM products WHERE id = '4312'
277 0.0005 0.00053215026855469
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
278 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '4312'
279 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '4312'
280 0.0015 0.0015261173248291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
281 0.0005 0.00050687789916992
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0005 0.00053310394287109
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0007 0.00068998336791992
SELECT * FROM products WHERE id = '777'
285 0.0007 0.0007171630859375
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
286 0.0007 0.00069093704223633
SELECT * FROM product_image_select WHERE product_id = '777'
287 0.0005 0.00048589706420898
SELECT * FROM productcustomimages WHERE product_id = '777'
288 0.0018 0.0017738342285156
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
289 0.0006 0.00058698654174805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
290 0.0005 0.00047206878662109
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
291 0.0009 0.000885009765625
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0009 0.00087690353393555
SELECT * FROM products WHERE id = '3881'
293 0.0008 0.00081801414489746
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
294 0.0008 0.00083112716674805
SELECT * FROM product_image_select WHERE product_id = '3881'
295 0.0007 0.00073719024658203
SELECT * FROM productcustomimages WHERE product_id = '3881'
296 0.0018 0.0017809867858887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
297 0.0007 0.00065803527832031
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
298 0.0009 0.0009300708770752
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
299 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0008 0.00079584121704102
SELECT * FROM products WHERE id = '4213'
301 0.0008 0.00075078010559082
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
302 0.0009 0.00085997581481934
SELECT * FROM product_image_select WHERE product_id = '4213'
303 0.0005 0.0004880428314209
SELECT * FROM productcustomimages WHERE product_id = '4213'
304 0.0023 0.0023431777954102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
305 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0006 0.00057196617126465
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0006 0.00063085556030273
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308 0.0012 0.0012350082397461
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
309 0.0012 0.0011708736419678
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
310 0.0036 0.0036110877990723
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
311 0.0017 0.0016829967498779
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
312 0.0012 0.0011661052703857
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
313 0.0009 0.00086688995361328
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
314 0.0007 0.00071406364440918
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'