Best Sellers

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.38435006141663 300 0.0849 0


No Amazon API Requests Made.


App Debug - Total Time 0.38435006141663 seconds

Number Time From Start Name Description
1 0.27188086509705 Initialise Initialise FSB Function
2 0.27260684967041 App Controller Start Start of the App controller (called before the controller of every page)
3 0.27735590934753 Start of getCategoryListByGroup Function Before first category groups query
4 0.27750301361084 After initial query Before first category groups query
5 0.27750396728516 Get Category List for Group Before the call to getCategoryList function
6 0.27750587463379 Start of GetCategoryList function Start of the function
7 0.27750706672668 Before getting categories Query to get specific category list
8 0.27770686149597 After getting categories Query to get specific category list
9 0.27770805358887 Before getting category custom Before call to function getCategoryCustom
10 0.27925705909729 After getting category custom After call to function getCategoryCustom
11 0.2792649269104 Before getting category custom Before call to function getCategoryCustom
12 0.2805380821228 After getting category custom After call to function getCategoryCustom
13 0.28053998947144 Before getting category custom Before call to function getCategoryCustom
14 0.28184199333191 After getting category custom After call to function getCategoryCustom
15 0.28184294700623 Before getting category custom Before call to function getCategoryCustom
16 0.28296399116516 After getting category custom After call to function getCategoryCustom
17 0.28296589851379 End of GetCategoryList function End of the function
18 0.28296899795532 Get Category List for Group Before the call to getCategoryList function
19 0.28296995162964 Start of GetCategoryList function Start of the function
20 0.28297185897827 Before getting categories Query to get specific category list
21 0.28309202194214 End of getCategoryListByGroup Function Before return()
22 0.31527996063232 App Controller End End of the App controller (called before the controller of every page)
23 0.34741687774658 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.34767889976501 Before Get Options Before the call to getOptions in the tpl class
25 0.36309099197388 After Get Options After the call to getOptions in the tpl class
26 0.36324286460876 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.38434100151062 Finalizing debug Before the debug is output to the page.
28 0.38434886932373 End of App This is the end of the app logging, final timestamp


Query Debug - 300 Database Queries. Total time 0.0849 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00031018257141113
SELECT parameter, value FROM parameters
2 0.0003 0.0003359317779541
SELECT * FROM `bad_bots`
3 0.0003 0.00030398368835449
SET time_zone = 'Europe/London'
4 0.0002 0.00015997886657715
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00020098686218262
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.200.74.241\";}'
6 0.0001 0.00014805793762207
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653686729'
7 0.0003 0.00032591819763184
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00012898445129395
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00020003318786621
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
10 0.0001 0.00011301040649414
SELECT * FROM pages WHERE id = 45
11 0.0004 0.00038409233093262
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0038 0.0038268566131592
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00013422966003418
SELECT * FROM pages WHERE pagename = 'best-sellers'
14 0.0001 0.0001370906829834
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00018501281738281
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00033402442932129
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
17 0.0002 0.00016093254089355
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
18 0.0001 0.00011205673217773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.4877014160156E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00023508071899414
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 
21 0.0001 0.00014400482177734
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 
22 0.0001 0.00014591217041016
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
23 0.0001 0.0001368522644043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 8.8930130004883E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00025296211242676
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
26 0.0001 0.00010204315185547
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
27 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 9.7990036010742E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0003 0.00030016899108887
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 
30 0.0001 8.702278137207E-5
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 
31 0.0001 0.00010108947753906
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
32 0.0001 7.4863433837891E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 8.9168548583984E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00030398368835449
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
35 0.0001 9.9897384643555E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
36 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00029492378234863
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 
39 0.0001 8.4877014160156E-5
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 
40 0.0001 9.8943710327148E-5
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
41 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 9.7990036010742E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00018000602722168
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 = 38
44 0.0001 9.7990036010742E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
45 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
49 0.0001 0.00010585784912109
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.00011086463928223
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00048995018005371
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00021696090698242
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00017809867858887
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
56 0.0007 0.00072598457336426
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0004 0.00036215782165527
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0289 0.028866052627563
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.74.241') >= INET_ATON(ip_start) AND INET_ATON('44.200.74.241') <= INET_ATON(ip_end)
59 0.0003 0.00025796890258789
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00013494491577148
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.00016617774963379
SELECT * FROM pages WHERE pagename = 'best-sellers'
62 0.0018 0.0018250942230225
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
63 0.0001 0.00011587142944336
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|18'
64 0.0006 0.00055408477783203
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
65 0.0005 0.00048708915710449
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
66 0.0002 0.00016903877258301
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
67 0.0005 0.00045585632324219
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
68 0.0005 0.00045394897460938
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
69 0.0001 0.00012111663818359
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
70 0.0004 0.00043988227844238
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
71 0.0001 0.00012588500976562
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
72 0.0001 8.0108642578125E-5
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
73 0.0006 0.000640869140625
SELECT * FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		
		AND salesrank <> 0
		AND 1 = 1
		AND id IN (785,7841,7824,7826,812,7838,7834,7839,821,7836,7833,7831,7832,7835,7837,748,775,819,830,791)
		ORDER BY salesrank ASC
		LIMIT 0, 18
74 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
75 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '785'
76 0.0001 0.00014090538024902
SELECT * FROM productcustomimages WHERE product_id = '785'
77 0.0005 0.000518798828125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '785' AND a.name = n.originalname
78 0.0002 0.00015783309936523
SELECT * FROM productoffers WHERE product_id = '785' AND merchantid = 'ATVPDKIKX0DER'
79 0.0001 0.00014209747314453
SELECT * FROM productoffers
                WHERE product_id = '785' AND price > 0
                ORDER BY price ASC LIMIT 1
80 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
81 0.0001 0.00012493133544922
SELECT * FROM productimages WHERE product_id = '7841' ORDER BY sortorder ASC
82 0.0001 0.00014710426330566
SELECT * FROM product_image_select WHERE product_id = '7841'
83 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '7841'
84 0.0004 0.00042104721069336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7841' AND a.name = n.originalname
85 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '7841' AND merchantid = 'ATVPDKIKX0DER'
86 0.0001 0.00013089179992676
SELECT * FROM productoffers
                WHERE product_id = '7841' AND price > 0
                ORDER BY price ASC LIMIT 1
87 0.0001 0.00014901161193848
SELECT value FROM productattributes WHERE product_id = '7841' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
88 0.0001 0.00011205673217773
SELECT * FROM productimages WHERE product_id = '7824' ORDER BY sortorder ASC
89 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7824'
90 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7824'
91 0.0004 0.00035595893859863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7824' AND a.name = n.originalname
92 0.0001 0.00011682510375977
SELECT * FROM productoffers WHERE product_id = '7824' AND merchantid = 'ATVPDKIKX0DER'
93 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '7824' AND price > 0
                ORDER BY price ASC LIMIT 1
94 0.0001 0.00013399124145508
SELECT value FROM productattributes WHERE product_id = '7824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
95 0.0001 0.00011014938354492
SELECT * FROM productimages WHERE product_id = '7826' ORDER BY sortorder ASC
96 0.0001 0.00013279914855957
SELECT * FROM product_image_select WHERE product_id = '7826'
97 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '7826'
98 0.0004 0.0004279613494873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7826' AND a.name = n.originalname
99 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '7826' AND merchantid = 'ATVPDKIKX0DER'
100 0.0001 0.00011920928955078
SELECT * FROM productoffers
                WHERE product_id = '7826' AND price > 0
                ORDER BY price ASC LIMIT 1
101 0.0001 0.00013613700866699
SELECT value FROM productattributes WHERE product_id = '7826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
103 0.0001 0.00014185905456543
SELECT * FROM product_image_select WHERE product_id = '812'
104 0.0001 0.00011205673217773
SELECT * FROM productcustomimages WHERE product_id = '812'
105 0.0004 0.00038003921508789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
106 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'ATVPDKIKX0DER'
107 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '7838' ORDER BY sortorder ASC
110 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '7838'
111 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7838'
112 0.0003 0.00032711029052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7838' AND a.name = n.originalname
113 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '7838' AND merchantid = 'ATVPDKIKX0DER'
114 0.0001 0.00012683868408203
SELECT * FROM productoffers
                WHERE product_id = '7838' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0001 0.00010991096496582
SELECT * FROM productimages WHERE product_id = '7834' ORDER BY sortorder ASC
117 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7834'
118 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7834'
119 0.0004 0.00043201446533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7834' AND a.name = n.originalname
120 0.0001 0.00011801719665527
SELECT * FROM productoffers WHERE product_id = '7834' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.0001220703125
SELECT * FROM productoffers
                WHERE product_id = '7834' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0001 0.0001370906829834
SELECT value FROM productattributes WHERE product_id = '7834' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 0.00010919570922852
SELECT * FROM productimages WHERE product_id = '7839' ORDER BY sortorder ASC
124 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7839'
125 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7839'
126 0.0004 0.00037503242492676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7839' AND a.name = n.originalname
127 0.0001 0.00010299682617188
SELECT * FROM productoffers WHERE product_id = '7839' AND merchantid = 'ATVPDKIKX0DER'
128 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7839' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0001 0.00013208389282227
SELECT value FROM productattributes WHERE product_id = '7839' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0001 0.00013017654418945
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
131 0.0001 0.00014805793762207
SELECT * FROM product_image_select WHERE product_id = '821'
132 0.0001 0.00011491775512695
SELECT * FROM productcustomimages WHERE product_id = '821'
133 0.0003 0.00031900405883789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '821' AND a.name = n.originalname
134 0.0001 0.00011992454528809
SELECT * FROM productoffers WHERE product_id = '821' AND merchantid = 'ATVPDKIKX0DER'
135 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '821' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0001 0.00013113021850586
SELECT value FROM productattributes WHERE product_id = '821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0001 0.00011897087097168
SELECT * FROM productimages WHERE product_id = '7833' ORDER BY sortorder ASC
138 0.0001 0.00014495849609375
SELECT * FROM product_image_select WHERE product_id = '7833'
139 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7833'
140 0.0004 0.00039410591125488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7833' AND a.name = n.originalname
141 0.0001 0.00010323524475098
SELECT * FROM productoffers WHERE product_id = '7833' AND merchantid = 'ATVPDKIKX0DER'
142 0.0001 0.00012588500976562
SELECT * FROM productoffers
                WHERE product_id = '7833' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0002 0.00018095970153809
SELECT value FROM productattributes WHERE product_id = '7833' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0001 0.00010991096496582
SELECT * FROM productimages WHERE product_id = '7836' ORDER BY sortorder ASC
145 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '7836'
146 0.0001 0.00010490417480469
SELECT * FROM productcustomimages WHERE product_id = '7836'
147 0.0005 0.00051498413085938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7836' AND a.name = n.originalname
148 0.0001 0.00014400482177734
SELECT * FROM productoffers WHERE product_id = '7836' AND merchantid = 'ATVPDKIKX0DER'
149 0.0001 0.0001220703125
SELECT * FROM productoffers
                WHERE product_id = '7836' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0001 0.00013899803161621
SELECT value FROM productattributes WHERE product_id = '7836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0001 0.00010991096496582
SELECT * FROM productimages WHERE product_id = '7831' ORDER BY sortorder ASC
152 0.0001 0.00013279914855957
SELECT * FROM product_image_select WHERE product_id = '7831'
153 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '7831'
154 0.0003 0.00034904479980469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7831' AND a.name = n.originalname
155 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '7831' AND merchantid = 'ATVPDKIKX0DER'
156 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7831' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0001 0.00013017654418945
SELECT value FROM productattributes WHERE product_id = '7831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '7832' ORDER BY sortorder ASC
159 0.0001 0.00014090538024902
SELECT * FROM product_image_select WHERE product_id = '7832'
160 0.0001 0.00011301040649414
SELECT * FROM productcustomimages WHERE product_id = '7832'
161 0.0004 0.0003960132598877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7832' AND a.name = n.originalname
162 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '7832' AND merchantid = 'ATVPDKIKX0DER'
163 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7832' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0001 0.00014495849609375
SELECT value FROM productattributes WHERE product_id = '7832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '7835' ORDER BY sortorder ASC
166 0.0002 0.00017118453979492
SELECT * FROM product_image_select WHERE product_id = '7835'
167 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7835'
168 0.0005 0.00046586990356445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7835' AND a.name = n.originalname
169 0.0001 0.00012588500976562
SELECT * FROM productoffers WHERE product_id = '7835' AND merchantid = 'ATVPDKIKX0DER'
170 0.0001 0.00012302398681641
SELECT * FROM productoffers
                WHERE product_id = '7835' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7835' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0001 0.00011515617370605
SELECT * FROM productimages WHERE product_id = '7837' ORDER BY sortorder ASC
173 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7837'
174 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7837'
175 0.0004 0.00040698051452637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7837' AND a.name = n.originalname
176 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '7837' AND merchantid = 'ATVPDKIKX0DER'
177 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7837' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0001 0.00012707710266113
SELECT value FROM productattributes WHERE product_id = '7837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0001 0.00010800361633301
SELECT * FROM productimages WHERE product_id = '748' ORDER BY sortorder ASC
180 0.0001 0.00014710426330566
SELECT * FROM product_image_select WHERE product_id = '748'
181 0.0001 0.00010895729064941
SELECT * FROM productcustomimages WHERE product_id = '748'
182 0.0004 0.00044012069702148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
183 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
184 0.0001 0.0001068115234375
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0001 0.00010299682617188
SELECT * FROM productoffers
                WHERE product_id = 748
                ORDER BY price ASC LIMIT 1
186 0.0001 0.0001220703125
SELECT value FROM productattributes
                WHERE product_id = '748'
                AND name = 'ListPriceAmount'
187 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
189 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '775'
190 0.0001 0.00011587142944336
SELECT * FROM productcustomimages WHERE product_id = '775'
191 0.0005 0.00046110153198242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
192 0.0001 0.0001068115234375
SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'ATVPDKIKX0DER'
193 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '775' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0001 0.00011515617370605
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
196 0.0001 0.00013518333435059
SELECT * FROM product_image_select WHERE product_id = '819'
197 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '819'
198 0.0005 0.00047612190246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '819' AND a.name = n.originalname
199 0.0001 9.5844268798828E-5
SELECT * FROM productoffers WHERE product_id = '819' AND merchantid = 'ATVPDKIKX0DER'
200 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '819' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0001 0.00010180473327637
SELECT * FROM productoffers
                WHERE product_id = 819
                ORDER BY price ASC LIMIT 1
202 0.0001 0.00011610984802246
SELECT value FROM productattributes
                WHERE product_id = '819'
                AND name = 'ListPriceAmount'
203 0.0001 0.00014901161193848
SELECT value FROM productattributes WHERE product_id = '819' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0002 0.00015687942504883
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
205 0.0001 0.00012087821960449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
206 0.0001 8.1062316894531E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
207 0.0001 0.00011706352233887
SELECT * FROM pages WHERE id = 38
208 0.0001 9.9897384643555E-5
SELECT * FROM categories WHERE id = '27'
209 0.0002 0.00020694732666016
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
210 0.0001 7.319450378418E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
211 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '27'
212 0.0002 0.0001990795135498
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 
213 0.0001 9.8943710327148E-5
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 
214 0.0001 0.00011301040649414
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
215 0.0001 7.319450378418E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
216 0.0002 0.00017404556274414
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
217 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
218 0.0002 0.00020980834960938
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 
219 0.0001 8.2015991210938E-5
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 
220 0.0001 9.5129013061523E-5
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
221 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
222 0.0001 7.8201293945312E-5
SELECT id FROM categories WHERE parent_id = '27'
223 0.0002 0.00022411346435547
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
224 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
225 0.0001 0.00011897087097168
SELECT * FROM categoryimages WHERE category_id = 27
226 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
227 0.0002 0.0001990795135498
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
228 0.0001 0.00010180473327637
SELECT * FROM categories WHERE id = '30'
229 0.0003 0.00028300285339355
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
230 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
231 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
232 0.0003 0.00028300285339355
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 
233 0.0001 8.5115432739258E-5
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 
234 0.0001 9.4175338745117E-5
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
235 0.0001 7.9154968261719E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
236 0.0003 0.00028586387634277
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
237 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
238 0.0003 0.00027990341186523
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 
239 0.0001 7.9870223999023E-5
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 
240 0.0001 9.2983245849609E-5
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
241 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
242 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
243 0.0003 0.00030612945556641
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
244 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
245 0.0001 8.0108642578125E-5
SELECT * FROM categoryimages WHERE category_id = 30
246 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
247 0.0003 0.00029516220092773
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
248 0.0001 0.00011110305786133
SELECT * FROM pages WHERE id = 59
249 0.0001 9.608268737793E-5
SELECT * FROM pages WHERE id = 55
250 0.0002 0.00015091896057129
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
251 0.0001 0.00013113021850586
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653686729;s:8:\"products\";a:0:{}}' WHERE id = '8'
252 0.0002 0.00023221969604492
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
253 0.0001 0.00010895729064941
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653686729;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
254 0.0001 0.00014615058898926
SELECT * FROM products WHERE id = 7004
255 0.0001 0.00011420249938965
SELECT * FROM products WHERE id = 7011
256 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
257 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7004'
258 0.0001 0.00012588500976562
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
259 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7004'
260 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
261 0.0005 0.00049591064453125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
262 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
263 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0001 0.00014185905456543
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0001 0.0001220703125
SELECT * FROM products WHERE id = '7011'
266 0.0001 0.0001220703125
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
267 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7011'
268 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
269 0.0005 0.00053596496582031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
270 0.0001 0.00011205673217773
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
271 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
273 0.0001 0.00012016296386719
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
274 0.0001 0.00011706352233887
SELECT * FROM products WHERE id = '7045'
275 0.0001 0.00010108947753906
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
276 0.0001 0.00014805793762207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
277 0.0001 0.00014591217041016
SELECT * FROM product_image_select WHERE product_id = '7045'
278 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
279 0.0001 0.0001368522644043
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '7045'
                GROUP BY o.product_id
280 0.0003 0.00028395652770996
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
281 0.0001 0.00011706352233887
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
282 0.0005 0.00054788589477539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
283 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
284 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
286 0.0001 0.00011396408081055
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
287 0.0001 0.00014591217041016
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '7045'
                GROUP BY o.product_id
288 0.0002 0.00019598007202148
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
289 0.0001 0.00011491775512695
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
290 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0002 0.00015592575073242
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
292 0.0001 0.00014996528625488
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
293 0.0003 0.00026202201843262
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
294 0.0002 0.00017595291137695
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
295 0.0004 0.00037407875061035
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
296 0.0002 0.00022697448730469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
297 0.0002 0.00015783309936523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
298 0.0003 0.00025701522827148
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
299 0.0002 0.00019383430480957
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
300 0.0002 0.00015997886657715
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'