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.5773210525513 175 1.1447 0


No Amazon API Requests Made.


App Debug - Total Time 1.5773210525513 seconds

Number Time From Start Name Description
1 0.2594621181488 Initialise Initialise FSB Function
2 0.26575112342834 App Controller Start Start of the App controller (called before the controller of every page)
3 0.30172514915466 Start of getCategoryListByGroup Function Before first category groups query
4 0.30316209793091 After initial query Before first category groups query
5 0.30316209793091 Get Category List for Group Before the call to getCategoryList function
6 0.30316400527954 Start of GetCategoryList function Start of the function
7 0.30316495895386 Before getting categories Query to get specific category list
8 0.3045699596405 After getting categories Query to get specific category list
9 0.3045711517334 Before getting category custom Before call to function getCategoryCustom
10 0.34711503982544 After getting category custom After call to function getCategoryCustom
11 0.34711694717407 Before getting category custom Before call to function getCategoryCustom
12 0.36255598068237 After getting category custom After call to function getCategoryCustom
13 0.36255693435669 Before getting category custom Before call to function getCategoryCustom
14 0.3722710609436 After getting category custom After call to function getCategoryCustom
15 0.37227201461792 Before getting category custom Before call to function getCategoryCustom
16 0.37783694267273 After getting category custom After call to function getCategoryCustom
17 0.37783813476562 Before getting category custom Before call to function getCategoryCustom
18 0.38271403312683 After getting category custom After call to function getCategoryCustom
19 0.38271498680115 Before getting category custom Before call to function getCategoryCustom
20 0.38718199729919 After getting category custom After call to function getCategoryCustom
21 0.38718295097351 End of GetCategoryList function End of the function
22 0.38718700408936 Get Category List for Group Before the call to getCategoryList function
23 0.38718914985657 Start of GetCategoryList function Start of the function
24 0.38719010353088 Before getting categories Query to get specific category list
25 0.38764500617981 End of getCategoryListByGroup Function Before return()
26 1.2259039878845 App Controller End End of the App controller (called before the controller of every page)
27 1.3273260593414 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3310720920563 Before Get Options Before the call to getOptions in the tpl class
29 1.419459104538 After Get Options After the call to getOptions in the tpl class
30 1.4195101261139 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.5773110389709 Finalizing debug Before the debug is output to the page.
32 1.5773210525513 End of App This is the end of the app logging, final timestamp


Query Debug - 175 Database Queries. Total time 1.1447 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022299289703369
SELECT parameter, value FROM parameters
2 0.0063 0.0063180923461914
SELECT * FROM `bad_bots`
3 0.0005 0.00051212310791016
SET time_zone = 'Europe/London'
4 0.0038 0.003803014755249
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0049 0.0048680305480957
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.165.239\";}'
6 0.0036 0.0036108493804932
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745055466'
7 0.0051 0.0051181316375732
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00092411041259766
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0043 0.0043010711669922
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
10 0.0006 0.00057196617126465
SELECT * FROM pages WHERE id = 44
11 0.0043 0.0042610168457031
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0308 0.030834913253784
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00055789947509766
SELECT * FROM pages WHERE pagename = 'best-sellers'
14 0.0014 0.0014328956604004
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0014 0.0013937950134277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0118 0.011800050735474
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.0022 0.002169132232666
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.0017 0.0016789436340332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '26'
20 0.0171 0.017058849334717
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.0043 0.0042669773101807
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.0024 0.0023760795593262
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.0021 0.0021119117736816
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00049805641174316
SELECT * FROM categorygroups WHERE id = '1'
25 0.0062 0.006248950958252
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00060486793518066
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.0005 0.00046801567077637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00052094459533691
SELECT id FROM categories WHERE parent_id = '27'
29 0.0054 0.0054030418395996
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0006 0.00059890747070312
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.00059008598327637
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.0005488395690918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00042510032653809
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0019829273223877
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.0016 0.0015749931335449
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0005 0.00054812431335449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.0005948543548584
SELECT id FROM categories WHERE parent_id = '28'
38 0.0026 0.0025599002838135
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0007 0.00065803527832031
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.00069808959960938
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.00056004524230957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00050592422485352
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00083208084106445
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.00066089630126953
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.00048995018005371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00060105323791504
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00094914436340332
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.00049304962158203
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.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
50 0.0005 0.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046896934509277
SELECT * FROM categorygroups WHERE id = '1'
52 0.0011 0.0011019706726074
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.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 = 30
54 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037717819213867
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00069212913513184
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.0004 0.00044393539428711
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.0005 0.00052499771118164
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.0004 0.00039196014404297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00033998489379883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00065302848815918
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.0004 0.00043201446533203
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00036787986755371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00033688545227051
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00067305564880371
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.0004 0.00044488906860352
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.0005 0.00054693222045898
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0006 0.00055885314941406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043296813964844
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00045204162597656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0030 0.0029819011688232
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0019 0.0019078254699707
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00058794021606445
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.0014278888702393
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0012991428375244
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.00099802017211914
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8246 0.82461786270142
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.165.239') >= INET_ATON(ip_start) AND INET_ATON('18.117.165.239') <= INET_ATON(ip_end)
78 0.0019 0.001896858215332
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0011 0.0011019706726074
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0012 0.0011630058288574
SELECT * FROM pages WHERE pagename = 'best-sellers'
81 0.0143 0.014328956604004
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
82 0.0078 0.0077919960021973
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
83 0.0080 0.0079989433288574
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
84 0.0019 0.0018558502197266
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
85 0.0019 0.0019168853759766
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
86 0.0057 0.0057170391082764
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
87 0.0016 0.0015590190887451
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
88 0.0006 0.00056791305541992
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
89 0.0005 0.00050997734069824
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.0004 0.00038504600524902
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
91 0.0004 0.00042104721069336
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
92 0.0006 0.0006401538848877
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.0015 0.0014920234680176
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
94 0.0013 0.001323938369751
SELECT * FROM product_image_select WHERE product_id = '1160'
95 0.0011 0.001115083694458
SELECT * FROM productcustomimages WHERE product_id = '1160'
96 0.0017 0.0017070770263672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
97 0.0012 0.0012269020080566
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0006 0.00062298774719238
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
101 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '4940'
102 0.0005 0.00045418739318848
SELECT * FROM productcustomimages WHERE product_id = '4940'
103 0.0007 0.00070309638977051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
104 0.0004 0.00042986869812012
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0004 0.00035381317138672
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0014 0.0013949871063232
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
108 0.0003 0.00027894973754883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
109 0.0033 0.0033090114593506
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
110 0.0031 0.0031249523162842
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
111 0.0006 0.00058794021606445
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
112 0.0349 0.034852981567383
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.0022 0.0021579265594482
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.0006 0.0005950927734375
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.0005 0.00052595138549805
SELECT * FROM products WHERE id = 1626
116 0.0004 0.00042009353637695
SELECT * FROM products WHERE id = 4041
117 0.0004 0.00037002563476562
SELECT * FROM products WHERE id = 4312
118 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = 777
119 0.0003 0.00033807754516602
SELECT * FROM products WHERE id = 3881
120 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = 4213
121 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = '1626'
122 0.0005 0.00046014785766602
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
123 0.0007 0.00065207481384277
SELECT * FROM product_image_select WHERE product_id = '1626'
124 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '1626'
125 0.0010 0.00098204612731934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
126 0.0004 0.00041985511779785
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00036001205444336
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = '4041'
130 0.0004 0.00039410591125488
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
131 0.0005 0.00054192543029785
SELECT * FROM product_image_select WHERE product_id = '4041'
132 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '4041'
133 0.0013 0.0012907981872559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
134 0.0004 0.00043487548828125
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0003 0.00032281875610352
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = '4312'
138 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
139 0.0007 0.00070619583129883
SELECT * FROM product_image_select WHERE product_id = '4312'
140 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '4312'
141 0.0010 0.00095891952514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
142 0.0005 0.00053787231445312
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = '777'
146 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
147 0.0006 0.00057697296142578
SELECT * FROM product_image_select WHERE product_id = '777'
148 0.0005 0.0005037784576416
SELECT * FROM productcustomimages WHERE product_id = '777'
149 0.0010 0.00099396705627441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
150 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = '3881'
154 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
155 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '3881'
156 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '3881'
157 0.0013 0.0012590885162354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
158 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00034689903259277
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = '4213'
162 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
163 0.0025 0.0024800300598145
SELECT * FROM product_image_select WHERE product_id = '4213'
164 0.0009 0.00086402893066406
SELECT * FROM productcustomimages WHERE product_id = '4213'
165 0.0031 0.0030989646911621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
166 0.0008 0.00084495544433594
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0006 0.0006411075592041
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0008 0.00084805488586426
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0038 0.0038101673126221
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
170 0.0019 0.0018999576568604
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
171 0.0067 0.0067009925842285
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
172 0.0031 0.0031468868255615
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
173 0.0008 0.00084805488586426
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
174 0.0013 0.0012919902801514
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
175 0.0013 0.0012669563293457
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'