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.3413248062134 175 0.7627 0


No Amazon API Requests Made.


App Debug - Total Time 1.3413248062134 seconds

Number Time From Start Name Description
1 0.30205893516541 Initialise Initialise FSB Function
2 0.30953001976013 App Controller Start Start of the App controller (called before the controller of every page)
3 0.35516786575317 Start of getCategoryListByGroup Function Before first category groups query
4 0.35687494277954 After initial query Before first category groups query
5 0.35687780380249 Get Category List for Group Before the call to getCategoryList function
6 0.35688281059265 Start of GetCategoryList function Start of the function
7 0.35688996315002 Before getting categories Query to get specific category list
8 0.3585889339447 After getting categories Query to get specific category list
9 0.35859203338623 Before getting category custom Before call to function getCategoryCustom
10 0.38572788238525 After getting category custom After call to function getCategoryCustom
11 0.38573384284973 Before getting category custom Before call to function getCategoryCustom
12 0.40196299552917 After getting category custom After call to function getCategoryCustom
13 0.40196895599365 Before getting category custom Before call to function getCategoryCustom
14 0.40964698791504 After getting category custom After call to function getCategoryCustom
15 0.40965294837952 Before getting category custom Before call to function getCategoryCustom
16 0.4154908657074 After getting category custom After call to function getCategoryCustom
17 0.41549587249756 Before getting category custom Before call to function getCategoryCustom
18 0.42168498039246 After getting category custom After call to function getCategoryCustom
19 0.42168998718262 Before getting category custom Before call to function getCategoryCustom
20 0.42792081832886 After getting category custom After call to function getCategoryCustom
21 0.42792582511902 End of GetCategoryList function End of the function
22 0.42793703079224 Get Category List for Group Before the call to getCategoryList function
23 0.4279408454895 Start of GetCategoryList function Start of the function
24 0.42794489860535 Before getting categories Query to get specific category list
25 0.42853999137878 End of getCategoryListByGroup Function Before return()
26 0.89170598983765 App Controller End End of the App controller (called before the controller of every page)
27 0.99224281311035 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 0.99425387382507 Before Get Options Before the call to getOptions in the tpl class
29 1.0820939540863 After Get Options After the call to getOptions in the tpl class
30 1.0822260379791 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.3413009643555 Finalizing debug Before the debug is output to the page.
32 1.3413228988647 End of App This is the end of the app logging, final timestamp


Query Debug - 175 Database Queries. Total time 0.7627 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0023629665374756
SELECT parameter, value FROM parameters
2 0.0073 0.0073039531707764
SELECT * FROM `bad_bots`
3 0.0004 0.00044798851013184
SET time_zone = 'Europe/London'
4 0.0021 0.0020589828491211
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0041 0.0040769577026367
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.221.140.197\";}'
6 0.0049 0.0048589706420898
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738737676'
7 0.0058 0.005789041519165
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0011649131774902
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0041 0.004080057144165
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
10 0.0012 0.0012040138244629
SELECT * FROM pages WHERE id = 44
11 0.0070 0.0070271492004395
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0370 0.03698205947876
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00081706047058105
SELECT * FROM pages WHERE pagename = 'best-sellers'
14 0.0017 0.0016858577728271
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0016560554504395
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0081 0.0080890655517578
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.0020 0.0020101070404053
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.0015 0.0014560222625732
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00055694580078125
SELECT id FROM categories WHERE parent_id = '26'
20 0.0058 0.0057899951934814
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.0047 0.00472092628479
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.0019 0.001863956451416
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.0017 0.0016660690307617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0007 0.00068402290344238
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0041739940643311
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.0008 0.00081586837768555
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.0036 0.0035569667816162
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0007 0.00067615509033203
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0042850971221924
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.0007 0.00074005126953125
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.00062394142150879
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.0006 0.0006098747253418
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049400329589844
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016880035400391
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.0007 0.00068497657775879
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.0004 0.00043511390686035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048518180847168
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017061233520508
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.0006 0.00057291984558105
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.0007 0.00066399574279785
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.0006 0.00058388710021973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0007 0.0006859302520752
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00081896781921387
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.0007 0.00065112113952637
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.0005 0.000518798828125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00061392784118652
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00084114074707031
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.00052690505981445
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.00062322616577148
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.0006 0.00057506561279297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00050187110900879
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00063800811767578
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.0006 0.00060200691223145
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.0007 0.00069999694824219
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00059390068054199
SELECT id FROM categories WHERE parent_id = '30'
56 0.0010 0.00095891952514648
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.0008 0.00075793266296387
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.00057601928710938
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.0006 0.00063800811767578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00055694580078125
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00067687034606934
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.0005 0.00052094459533691
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.0005 0.00048303604125977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00053906440734863
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00076198577880859
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.0009 0.00093221664428711
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.00058698654174805
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.0011 0.0010521411895752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00051307678222656
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00057792663574219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0030 0.0029559135437012
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0016419887542725
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00065302848815918
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.0014 0.00140380859375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0012609958648682
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0011181831359863
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4478 0.4477550983429
SELECT * FROM ipgeocountries WHERE INET_ATON('18.221.140.197') >= INET_ATON(ip_start) AND INET_ATON('18.221.140.197') <= INET_ATON(ip_end)
78 0.0024 0.0024151802062988
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012879371643066
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0014 0.0014059543609619
SELECT * FROM pages WHERE pagename = 'best-sellers'
81 0.0140 0.014022827148438
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
82 0.0067 0.006659984588623
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
83 0.0080 0.0080299377441406
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
84 0.0021 0.0021131038665771
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
85 0.0024 0.0023720264434814
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
86 0.0060 0.0060420036315918
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
87 0.0018 0.0017869472503662
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
88 0.0005 0.00052404403686523
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
89 0.0006 0.00055694580078125
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.0005 0.00047016143798828
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
91 0.0005 0.00048518180847168
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
92 0.0008 0.00078296661376953
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
93 0.0018 0.0017650127410889
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
94 0.0016 0.0016090869903564
SELECT * FROM product_image_select WHERE product_id = '1160'
95 0.0012 0.0012168884277344
SELECT * FROM productcustomimages WHERE product_id = '1160'
96 0.0022 0.0021960735321045
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
97 0.0015 0.0015401840209961
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00048089027404785
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0006 0.00062108039855957
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
101 0.0006 0.00061798095703125
SELECT * FROM product_image_select WHERE product_id = '4940'
102 0.0005 0.00051403045654297
SELECT * FROM productcustomimages WHERE product_id = '4940'
103 0.0008 0.00084519386291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
104 0.0006 0.0006260871887207
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0005 0.00051617622375488
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0021 0.0020849704742432
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
108 0.0009 0.00090909004211426
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
109 0.0019 0.0019450187683105
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
110 0.0014 0.0014400482177734
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
111 0.0004 0.00042819976806641
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
112 0.0155 0.015492916107178
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
113 0.0028 0.002763032913208
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
114 0.0007 0.00072407722473145
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
115 0.0008 0.00075984001159668
SELECT * FROM products WHERE id = 1626
116 0.0007 0.00071978569030762
SELECT * FROM products WHERE id = 4041
117 0.0006 0.0006401538848877
SELECT * FROM products WHERE id = 4312
118 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = 777
119 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 3881
120 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = 4213
121 0.0008 0.00079107284545898
SELECT * FROM products WHERE id = '1626'
122 0.0008 0.00082588195800781
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
123 0.0006 0.0006401538848877
SELECT * FROM product_image_select WHERE product_id = '1626'
124 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '1626'
125 0.0012 0.0012078285217285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
126 0.0008 0.00079798698425293
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.00060296058654785
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0006 0.00059795379638672
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0007 0.00074291229248047
SELECT * FROM products WHERE id = '4041'
130 0.0007 0.00070786476135254
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
131 0.0008 0.00079798698425293
SELECT * FROM product_image_select WHERE product_id = '4041'
132 0.0005 0.00051999092102051
SELECT * FROM productcustomimages WHERE product_id = '4041'
133 0.0016 0.0015699863433838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
134 0.0007 0.00067496299743652
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.0005490779876709
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.00053215026855469
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0009 0.0009307861328125
SELECT * FROM products WHERE id = '4312'
138 0.0007 0.00069212913513184
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
139 0.0036 0.0036439895629883
SELECT * FROM product_image_select WHERE product_id = '4312'
140 0.0008 0.00080609321594238
SELECT * FROM productcustomimages WHERE product_id = '4312'
141 0.0035 0.0034830570220947
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
142 0.0014 0.0013940334320068
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0008 0.00084495544433594
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0009 0.00088810920715332
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0012 0.0011749267578125
SELECT * FROM products WHERE id = '777'
146 0.0011 0.0011160373687744
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
147 0.0016 0.0015769004821777
SELECT * FROM product_image_select WHERE product_id = '777'
148 0.0008 0.00082278251647949
SELECT * FROM productcustomimages WHERE product_id = '777'
149 0.0033 0.0033450126647949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
150 0.0008 0.00081801414489746
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0007 0.00069403648376465
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0008 0.00075101852416992
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0010 0.00098109245300293
SELECT * FROM products WHERE id = '3881'
154 0.0009 0.00092482566833496
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
155 0.0010 0.0010120868682861
SELECT * FROM product_image_select WHERE product_id = '3881'
156 0.0006 0.00060200691223145
SELECT * FROM productcustomimages WHERE product_id = '3881'
157 0.0023 0.0022571086883545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
158 0.0009 0.0008690357208252
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0007 0.0006721019744873
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0006 0.00059795379638672
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0010 0.0010390281677246
SELECT * FROM products WHERE id = '4213'
162 0.0008 0.00079917907714844
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
163 0.0008 0.00083398818969727
SELECT * FROM product_image_select WHERE product_id = '4213'
164 0.0005 0.00053906440734863
SELECT * FROM productcustomimages WHERE product_id = '4213'
165 0.0018 0.0017890930175781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
166 0.0007 0.00067687034606934
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0006 0.00063514709472656
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0008 0.00075101852416992
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0030 0.0030460357666016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
170 0.0012 0.0011870861053467
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
171 0.0038 0.0037510395050049
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
172 0.0025 0.0025441646575928
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
173 0.0007 0.00069403648376465
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
174 0.0012 0.0011889934539795
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
175 0.0013 0.001284122467041
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'