0

Best Sellers

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
1.4101929664612 176 1.0211 0


No Amazon API Requests Made.


App Debug - Total Time 1.4101929664612 seconds

Number Time From Start Name Description
1 0.36121797561646 Initialise Initialise FSB Function
2 0.36315202713013 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38519310951233 Start of getCategoryListByGroup Function Before first category groups query
4 0.38602304458618 After initial query Before first category groups query
5 0.38602304458618 Get Category List for Group Before the call to getCategoryList function
6 0.38602495193481 Start of GetCategoryList function Start of the function
7 0.38602614402771 Before getting categories Query to get specific category list
8 0.38675308227539 After getting categories Query to get specific category list
9 0.38675403594971 Before getting category custom Before call to function getCategoryCustom
10 0.4017391204834 After getting category custom After call to function getCategoryCustom
11 0.40174102783203 Before getting category custom Before call to function getCategoryCustom
12 0.41021800041199 After getting category custom After call to function getCategoryCustom
13 0.4102189540863 Before getting category custom Before call to function getCategoryCustom
14 0.41488099098206 After getting category custom After call to function getCategoryCustom
15 0.41488099098206 Before getting category custom Before call to function getCategoryCustom
16 0.41806101799011 After getting category custom After call to function getCategoryCustom
17 0.41806197166443 Before getting category custom Before call to function getCategoryCustom
18 0.42171001434326 After getting category custom After call to function getCategoryCustom
19 0.42171096801758 Before getting category custom Before call to function getCategoryCustom
20 0.42486715316772 After getting category custom After call to function getCategoryCustom
21 0.42486810684204 End of GetCategoryList function End of the function
22 0.42487192153931 Get Category List for Group Before the call to getCategoryList function
23 0.4248731136322 Start of GetCategoryList function Start of the function
24 0.42487406730652 Before getting categories Query to get specific category list
25 0.42530608177185 End of getCategoryListByGroup Function Before return()
26 1.3019919395447 App Controller End End of the App controller (called before the controller of every page)
27 1.3360290527344 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3370320796967 Before Get Options Before the call to getOptions in the tpl class
29 1.3798320293427 After Get Options After the call to getOptions in the tpl class
30 1.3798949718475 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4101810455322 Finalizing debug Before the debug is output to the page.
32 1.4101929664612 End of App This is the end of the app logging, final timestamp


Query Debug - 176 Database Queries. Total time 1.0211 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015490055084229
SELECT parameter, value FROM parameters
2 0.0033 0.0032758712768555
SELECT * FROM `bad_bots`
3 0.0002 0.00023603439331055
SET time_zone = 'Europe/London'
4 0.0010 0.0010030269622803
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00087285041809082
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.192\";}'
6 0.0009 0.00086712837219238
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1753981969'
7 0.0010 0.00098204612731934
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00029397010803223
UPDATE autorun SET lastrun = '2025-07-31 17:12:49' WHERE id = '8'
9 0.0003 0.00032305717468262
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0008 0.00077199935913086
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
11 0.0003 0.00026702880859375
SELECT * FROM pages WHERE id = 44
12 0.0014 0.0014200210571289
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0199 0.019927978515625
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.0003809928894043
SELECT * FROM pages WHERE pagename = 'best-sellers'
15 0.0008 0.00082588195800781
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00072002410888672
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0055 0.0055458545684814
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.00088095664978027
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.0006 0.00060892105102539
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00031399726867676
SELECT id FROM categories WHERE parent_id = '26'
21 0.0049 0.0049190521240234
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0008 0.0008399486541748
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0008 0.00075697898864746
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0007 0.00074195861816406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00029897689819336
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0030210018157959
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0003 0.00032591819763184
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.0003 0.00027990341186523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00029277801513672
SELECT id FROM categories WHERE parent_id = '27'
30 0.0032 0.0032289028167725
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.0004 0.0003659725189209
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0003 0.00033903121948242
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0003 0.00031304359436035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00028419494628906
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0011348724365234
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00030517578125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00027012825012207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '28'
39 0.0012 0.0011768341064453
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0003 0.00034284591674805
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.0005 0.00047087669372559
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0003 0.00034785270690918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00031304359436035
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00030803680419922
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00045299530029297
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.0004 0.00035881996154785
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0003 0.00034904479980469
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00033688545227051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00029802322387695
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00060200691223145
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.0004 0.00044989585876465
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00029706954956055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00035190582275391
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.0006101131439209
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0003 0.00034403800964355
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.0004 0.00036501884460449
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00028800964355469
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.0003049373626709
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00030708312988281
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0003 0.0003359317779541
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.0004 0.00035309791564941
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0003 0.00031614303588867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00031495094299316
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00042891502380371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0019 0.0018620491027832
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00081300735473633
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.00041413307189941
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0006 0.00063395500183105
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.00087189674377441
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00063705444335938
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8678 0.86781692504883
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.192') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.192') <= INET_ATON(ip_end)
79 0.0014 0.0014441013336182
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0007 0.00065994262695312
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00040817260742188
SELECT * FROM pages WHERE pagename = 'best-sellers'
82 0.0038 0.0037510395050049
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
83 0.0033 0.0033090114593506
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
84 0.0047 0.0047118663787842
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0013 0.0013349056243896
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0009 0.00093603134155273
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
87 0.0046 0.0045831203460693
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
88 0.0013 0.001305103302002
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0004 0.0004279613494873
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
90 0.0004 0.0003659725189209
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.0003 0.00030016899108887
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
92 0.0003 0.0002899169921875
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
93 0.0004 0.00043296813964844
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 18, 18
94 0.0009 0.00091004371643066
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
95 0.0008 0.0007929801940918
SELECT * FROM product_image_select WHERE product_id = '1160'
96 0.0007 0.00065207481384277
SELECT * FROM productcustomimages WHERE product_id = '1160'
97 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
98 0.0007 0.00072908401489258
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
99 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
100 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0003 0.00032877922058105
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
102 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '4940'
103 0.0003 0.00026297569274902
SELECT * FROM productcustomimages WHERE product_id = '4940'
104 0.0005 0.00050592422485352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
105 0.0003 0.00033020973205566
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0007 0.00067496299743652
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
109 0.0002 0.00021886825561523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
110 0.0007 0.00073099136352539
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
111 0.0007 0.00069499015808105
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
112 0.0003 0.00025796890258789
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
113 0.0117 0.011658191680908
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
114 0.0017 0.0017189979553223
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
115 0.0005 0.00051498413085938
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
116 0.0005 0.00047612190246582
SELECT * FROM products WHERE id = 1626
117 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = 4041
118 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 4312
119 0.0004 0.0003659725189209
SELECT * FROM products WHERE id = 777
120 0.0004 0.0003819465637207
SELECT * FROM products WHERE id = 3881
121 0.0004 0.00036501884460449
SELECT * FROM products WHERE id = 4213
122 0.0004 0.00037717819213867
SELECT * FROM products WHERE id = '1626'
123 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
124 0.0005 0.00052380561828613
SELECT * FROM product_image_select WHERE product_id = '1626'
125 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1626'
126 0.0007 0.00072097778320312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
127 0.0004 0.00037312507629395
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0003 0.00033283233642578
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = '4041'
131 0.0003 0.00034189224243164
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
132 0.0005 0.00047421455383301
SELECT * FROM product_image_select WHERE product_id = '4041'
133 0.0003 0.0002899169921875
SELECT * FROM productcustomimages WHERE product_id = '4041'
134 0.0008 0.000762939453125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
135 0.0003 0.00033307075500488
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '4312'
139 0.0004 0.00036501884460449
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
140 0.0005 0.00054502487182617
SELECT * FROM product_image_select WHERE product_id = '4312'
141 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '4312'
142 0.0007 0.00072002410888672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
143 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0004 0.00035214424133301
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0004 0.00037789344787598
SELECT * FROM products WHERE id = '777'
147 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
148 0.0005 0.0005180835723877
SELECT * FROM product_image_select WHERE product_id = '777'
149 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '777'
150 0.0007 0.00070309638977051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
151 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00031805038452148
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0004 0.00038313865661621
SELECT * FROM products WHERE id = '3881'
155 0.0004 0.00038814544677734
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
156 0.0005 0.0005488395690918
SELECT * FROM product_image_select WHERE product_id = '3881'
157 0.0003 0.00031781196594238
SELECT * FROM productcustomimages WHERE product_id = '3881'
158 0.0007 0.00070810317993164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
159 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0004 0.00036096572875977
SELECT * FROM products WHERE id = '4213'
163 0.0004 0.00036811828613281
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
164 0.0005 0.00047707557678223
SELECT * FROM product_image_select WHERE product_id = '4213'
165 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '4213'
166 0.0007 0.00071191787719727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
167 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0003 0.00028491020202637
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0013 0.0012550354003906
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
171 0.0006 0.00058293342590332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
172 0.0017 0.0017321109771729
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
173 0.0010 0.00098419189453125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
174 0.0004 0.00037384033203125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
175 0.0005 0.00050806999206543
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
176 0.0005 0.00045299530029297
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'