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
2.0184240341187 175 1.6581 0


No Amazon API Requests Made.


App Debug - Total Time 2.0184240341187 seconds

Number Time From Start Name Description
1 0.3417911529541 Initialise Initialise FSB Function
2 0.34427618980408 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38674306869507 Start of getCategoryListByGroup Function Before first category groups query
4 0.38724112510681 After initial query Before first category groups query
5 0.38724207878113 Get Category List for Group Before the call to getCategoryList function
6 0.38724398612976 Start of GetCategoryList function Start of the function
7 0.38724517822266 Before getting categories Query to get specific category list
8 0.38772702217102 After getting categories Query to get specific category list
9 0.38772797584534 Before getting category custom Before call to function getCategoryCustom
10 0.40369606018066 After getting category custom After call to function getCategoryCustom
11 0.4036979675293 Before getting category custom Before call to function getCategoryCustom
12 0.41538000106812 After getting category custom After call to function getCategoryCustom
13 0.41538214683533 Before getting category custom Before call to function getCategoryCustom
14 0.42203712463379 After getting category custom After call to function getCategoryCustom
15 0.42203903198242 Before getting category custom Before call to function getCategoryCustom
16 0.42643713951111 After getting category custom After call to function getCategoryCustom
17 0.42643904685974 Before getting category custom Before call to function getCategoryCustom
18 0.43062806129456 After getting category custom After call to function getCategoryCustom
19 0.43062996864319 Before getting category custom Before call to function getCategoryCustom
20 0.43559408187866 After getting category custom After call to function getCategoryCustom
21 0.43559598922729 End of GetCategoryList function End of the function
22 0.43560099601746 Get Category List for Group Before the call to getCategoryList function
23 0.43560218811035 Start of GetCategoryList function Start of the function
24 0.43560409545898 Before getting categories Query to get specific category list
25 0.43605899810791 End of getCategoryListByGroup Function Before return()
26 1.9025220870972 App Controller End End of the App controller (called before the controller of every page)
27 1.9405550956726 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.9413530826569 Before Get Options Before the call to getOptions in the tpl class
29 1.9949021339417 After Get Options After the call to getOptions in the tpl class
30 1.9949522018433 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.0184149742126 Finalizing debug Before the debug is output to the page.
32 2.0184230804443 End of App This is the end of the app logging, final timestamp


Query Debug - 175 Database Queries. Total time 1.6581 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.0020132064819336
SELECT parameter, value FROM parameters
2 0.0019 0.0019030570983887
SELECT * FROM `bad_bots`
3 0.0003 0.00030207633972168
SET time_zone = 'Europe/London'
4 0.0005 0.0005488395690918
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00056099891662598
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"52.14.238.102\";}'
6 0.0005 0.000518798828125
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746017169'
7 0.0011 0.0010590553283691
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00060009956359863
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010490417480469
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
10 0.0006 0.0006110668182373
SELECT * FROM pages WHERE id = 44
11 0.0035 0.0034611225128174
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0383 0.038347959518433
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00042819976806641
SELECT * FROM pages WHERE pagename = 'best-sellers'
14 0.0005 0.00049400329589844
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00047397613525391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0061 0.006101131439209
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.0005 0.00052690505981445
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.0004 0.00044393539428711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00051689147949219
SELECT id FROM categories WHERE parent_id = '26'
20 0.0063 0.006335973739624
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.0005 0.00054383277893066
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.0005 0.00050091743469238
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.0005 0.00052309036254883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00041413307189941
SELECT * FROM categorygroups WHERE id = '1'
25 0.0039 0.0038559436798096
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00050687789916992
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00038695335388184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00043582916259766
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.0041618347167969
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.00065088272094727
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.0005948543548584
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.00055408477783203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00046205520629883
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015249252319336
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0005 0.00048398971557617
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.0004270076751709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00054287910461426
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015411376953125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00054502487182617
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.0005 0.00053811073303223
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.00057005882263184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00041913986206055
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00059819221496582
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00047802925109863
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00044798851013184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043892860412598
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00058889389038086
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.0004580020904541
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.00047516822814941
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.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00038599967956543
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056004524230957
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.0004 0.00043797492980957
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00035405158996582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066995620727539
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.00043606758117676
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.00045204162597656
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00045514106750488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00037503242492676
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00071597099304199
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.00045514106750488
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.0006 0.0006098747253418
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00043416023254395
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065708160400391
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.00045895576477051
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.00048089027404785
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.00057601928710938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00051593780517578
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00044798851013184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.001500129699707
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00055813789367676
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00052618980407715
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.0004 0.00038599967956543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.001054048538208
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00083613395690918
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.4589 1.4589049816132
SELECT * FROM ipgeocountries WHERE INET_ATON('52.14.238.102') >= INET_ATON(ip_start) AND INET_ATON('52.14.238.102') <= INET_ATON(ip_end)
78 0.0014 0.0014231204986572
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00044083595275879
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0004 0.0004420280456543
SELECT * FROM pages WHERE pagename = 'best-sellers'
81 0.0047 0.0046560764312744
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
82 0.0036 0.0036158561706543
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|2|bestselling|18'
83 0.0053 0.005277156829834
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
84 0.0017 0.001708984375
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
85 0.0007 0.00069189071655273
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
86 0.0055 0.0055022239685059
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
87 0.0016 0.0016031265258789
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
88 0.0005 0.00054693222045898
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
89 0.0006 0.00060606002807617
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.00051999092102051
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
91 0.0005 0.0004880428314209
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
92 0.0007 0.00072789192199707
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.0007 0.00068497657775879
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
94 0.0007 0.00066995620727539
SELECT * FROM product_image_select WHERE product_id = '1160'
95 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '1160'
96 0.0010 0.0009918212890625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
97 0.0004 0.0004417896270752
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0005 0.0005338191986084
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0006 0.00058984756469727
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
101 0.0006 0.00063705444335938
SELECT * FROM product_image_select WHERE product_id = '4940'
102 0.0005 0.00049304962158203
SELECT * FROM productcustomimages WHERE product_id = '4940'
103 0.0008 0.00075697898864746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
104 0.0005 0.00045204162597656
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0004 0.00043702125549316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
108 0.0004 0.00037693977355957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
109 0.0005 0.00046491622924805
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
110 0.0004 0.00042200088500977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
111 0.0003 0.00034403800964355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
112 0.0134 0.013447046279907
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.0006 0.00061416625976562
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.00056099891662598
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.00050497055053711
SELECT * FROM products WHERE id = 1626
116 0.0004 0.00037288665771484
SELECT * FROM products WHERE id = 4041
117 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = 4312
118 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 777
119 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = 3881
120 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = 4213
121 0.0004 0.00036311149597168
SELECT * FROM products WHERE id = '1626'
122 0.0005 0.00052118301391602
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
123 0.0006 0.00062990188598633
SELECT * FROM product_image_select WHERE product_id = '1626'
124 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '1626'
125 0.0008 0.00079488754272461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
126 0.0005 0.00051689147949219
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00048184394836426
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00052690505981445
SELECT * FROM products WHERE id = '4041'
130 0.0004 0.00041413307189941
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
131 0.0006 0.0005800724029541
SELECT * FROM product_image_select WHERE product_id = '4041'
132 0.0004 0.00037479400634766
SELECT * FROM productcustomimages WHERE product_id = '4041'
133 0.0011 0.0010690689086914
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.0004429817199707
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = '4312'
138 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
139 0.0006 0.0005500316619873
SELECT * FROM product_image_select WHERE product_id = '4312'
140 0.0005 0.00047612190246582
SELECT * FROM productcustomimages WHERE product_id = '4312'
141 0.0013 0.0012950897216797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
142 0.0007 0.00070786476135254
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00043082237243652
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00056219100952148
SELECT * FROM products WHERE id = '777'
146 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
147 0.0006 0.00055813789367676
SELECT * FROM product_image_select WHERE product_id = '777'
148 0.0004 0.00035810470581055
SELECT * FROM productcustomimages WHERE product_id = '777'
149 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
150 0.0005 0.00045490264892578
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00039386749267578
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0006 0.00055408477783203
SELECT * FROM products WHERE id = '3881'
154 0.0006 0.00062012672424316
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
155 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '3881'
156 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '3881'
157 0.0014 0.0013728141784668
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.0004417896270752
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00053286552429199
SELECT * FROM products WHERE id = '4213'
162 0.0005 0.00054597854614258
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
163 0.0008 0.00075387954711914
SELECT * FROM product_image_select WHERE product_id = '4213'
164 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '4213'
165 0.0011 0.001121997833252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
166 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0022 0.0022411346435547
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
170 0.0012 0.0011711120605469
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
171 0.0027 0.0027129650115967
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
172 0.0010 0.00096702575683594
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
173 0.0008 0.00075292587280273
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
174 0.0016 0.0015659332275391
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
175 0.0015 0.0015339851379395
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'