You currently have no items in your cart.

More Information

Above are the items you have added to your shopping basket. If you are ready to place your order, simply click "Checkout" above. You will be taken to Amazon and guided through the process of entering the details needed to complete your order, including your delivery address and payment option. Your details are 100% guaranteed to be completely secure.

If you are looking for more products why don't you continue looking through our store.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.47475099563599 159 0.0612 0


No Amazon API Requests Made.


App Debug - Total Time 0.47475099563599 seconds

Number Time From Start Name Description
1 0.33389282226562 Initialise Initialise FSB Function
2 0.3346209526062 App Controller Start Start of the App controller (called before the controller of every page)
3 0.3393828868866 Start of getCategoryListByGroup Function Before first category groups query
4 0.3395369052887 After initial query Before first category groups query
5 0.33953785896301 Get Category List for Group Before the call to getCategoryList function
6 0.33953976631165 Start of GetCategoryList function Start of the function
7 0.33954286575317 Before getting categories Query to get specific category list
8 0.33973979949951 After getting categories Query to get specific category list
9 0.33974099159241 Before getting category custom Before call to function getCategoryCustom
10 0.34262585639954 After getting category custom After call to function getCategoryCustom
11 0.34262681007385 Before getting category custom Before call to function getCategoryCustom
12 0.34387278556824 After getting category custom After call to function getCategoryCustom
13 0.34387493133545 Before getting category custom Before call to function getCategoryCustom
14 0.34513592720032 After getting category custom After call to function getCategoryCustom
15 0.34513783454895 Before getting category custom Before call to function getCategoryCustom
16 0.3462438583374 After getting category custom After call to function getCategoryCustom
17 0.34624481201172 End of GetCategoryList function End of the function
18 0.34624886512756 Get Category List for Group Before the call to getCategoryList function
19 0.34624981880188 Start of GetCategoryList function Start of the function
20 0.34625196456909 Before getting categories Query to get specific category list
21 0.34638786315918 End of getCategoryListByGroup Function Before return()
22 0.37950277328491 App Controller End End of the App controller (called before the controller of every page)
23 0.38144993782043 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.3817617893219 Before Get Options Before the call to getOptions in the tpl class
25 0.39826488494873 After Get Options After the call to getOptions in the tpl class
26 0.39830493927002 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.47474098205566 Finalizing debug Before the debug is output to the page.
28 0.47475099563599 End of App This is the end of the app logging, final timestamp


Query Debug - 159 Database Queries. Total time 0.0612 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00022602081298828
SELECT parameter, value FROM parameters
2 0.0005 0.00046014785766602
SELECT * FROM `bad_bots`
3 0.0002 0.00018095970153809
SET time_zone = 'Europe/London'
4 0.0002 0.00020217895507812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00022196769714355
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.173.214.227\";}'
6 0.0001 0.00014805793762207
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642881058'
7 0.0004 0.0003511905670166
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017809867858887
UPDATE autorun SET lastrun = '2022-01-22 19:50:58' WHERE id = '15'
9 0.0001 0.00012302398681641
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00019192695617676
SELECT id FROM pages WHERE pagename = 'basket' LIMIT 1
11 0.0001 0.00012493133544922
SELECT * FROM pages WHERE id = 43
12 0.0004 0.00035786628723145
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0038 0.0038020610809326
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00016188621520996
SELECT * FROM pages WHERE pagename = 'basket'
15 0.0001 0.00014305114746094
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0002 0.00018310546875
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0004 0.0003511905670166
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
18 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
19 0.0001 0.00014114379882812
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 8.5115432739258E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00022101402282715
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 
22 0.0001 0.00014519691467285
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 
23 0.0012 0.0012118816375732
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
24 0.0004 0.00036787986755371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.9168548583984E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0003 0.00027203559875488
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
27 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
28 0.0001 8.702278137207E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00026798248291016
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 
31 0.0001 8.7976455688477E-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 
32 0.0001 9.918212890625E-5
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
33 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00028109550476074
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
36 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 = 30
37 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00028800964355469
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 
40 0.0001 8.4161758422852E-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 
41 0.0001 9.608268737793E-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
42 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 9.2029571533203E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00017714500427246
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
45 0.0001 0.00011205673217773
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
46 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00021815299987793
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 
49 0.0001 8.2969665527344E-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 
50 0.0001 9.7036361694336E-5
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
51 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00012707710266113
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0013 0.0013358592987061
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0002 0.00019598007202148
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00017118453979492
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
57 0.0002 0.00020503997802734
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0004 0.0003819465637207
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0295 0.029501914978027
SELECT * FROM ipgeocountries WHERE INET_ATON('54.173.214.227') >= INET_ATON(ip_start) AND INET_ATON('54.173.214.227') <= INET_ATON(ip_end)
60 0.0003 0.00026607513427734
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0002 0.00016498565673828
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.00015091896057129
SELECT * FROM pages WHERE pagename = 'basket'
63 0.0005 0.00048995018005371
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
64 0.0001 0.00013494491577148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
65 0.0001 8.3208084106445E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
66 0.0001 0.00011014938354492
SELECT * FROM pages WHERE id = 38
67 0.0001 0.00011205673217773
SELECT * FROM categories WHERE id = '27'
68 0.0003 0.00025486946105957
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
69 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
70 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '27'
71 0.0002 0.00021195411682129
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 
72 0.0001 9.1075897216797E-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 
73 0.0001 0.00010204315185547
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
74 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
75 0.0002 0.00018310546875
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
76 0.0001 8.4161758422852E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
77 0.0002 0.00019288063049316
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 
78 0.0001 8.1062316894531E-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 
79 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
80 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
81 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '27'
82 0.0002 0.0002291202545166
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
83 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
84 0.0001 0.00012707710266113
SELECT * FROM categoryimages WHERE category_id = 27
85 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
86 0.0002 0.00020503997802734
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
87 0.0001 9.2983245849609E-5
SELECT * FROM categories WHERE id = '30'
88 0.0003 0.00027704238891602
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
89 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
90 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '30'
91 0.0003 0.0002899169921875
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 
92 0.0001 8.4161758422852E-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 
93 0.0001 0.00011014938354492
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
94 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
95 0.0003 0.00026917457580566
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
96 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
97 0.0003 0.00029301643371582
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 
98 0.0001 7.9154968261719E-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 
99 0.0001 9.2029571533203E-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
100 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
101 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
102 0.0003 0.00030303001403809
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
103 0.0001 0.00014090538024902
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
104 0.0001 8.0108642578125E-5
SELECT * FROM categoryimages WHERE category_id = 30
105 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
106 0.0003 0.00028681755065918
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
107 0.0001 9.4175338745117E-5
SELECT * FROM pages WHERE id = 59
108 0.0001 0.00011801719665527
SELECT * FROM pages WHERE id = 55
109 0.0002 0.00022196769714355
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
110 0.0001 0.00012803077697754
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:1642881058;s:8:\"products\";a:0:{}}' WHERE id = '8'
111 0.0002 0.00022292137145996
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
112 0.0001 0.00010204315185547
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:1642881058;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'
113 0.0001 0.00013494491577148
SELECT * FROM products WHERE id = 7004
114 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7011
115 0.0001 0.00012922286987305
SELECT * FROM products WHERE id = 7045
116 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7004'
117 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
118 0.0002 0.00018095970153809
SELECT * FROM product_image_select WHERE product_id = '7004'
119 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '7004'
120 0.0006 0.00057792663574219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
121 0.0001 0.00011801719665527
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
122 0.0001 0.00012588500976562
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0001 0.00014805793762207
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0001 0.0001368522644043
SELECT * FROM products WHERE id = '7011'
125 0.0001 0.00011086463928223
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
126 0.0001 0.00013494491577148
SELECT * FROM product_image_select WHERE product_id = '7011'
127 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
128 0.0006 0.00056791305541992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
129 0.0001 0.00010013580322266
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
130 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00010204315185547
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
132 0.0001 0.00011992454528809
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
133 0.0001 0.00012302398681641
SELECT * FROM products WHERE id = '7045'
134 0.0001 0.00010180473327637
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
135 0.0002 0.0001528263092041
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
136 0.0001 0.00013279914855957
SELECT * FROM product_image_select WHERE product_id = '7045'
137 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
138 0.0001 0.0001370906829834
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
139 0.0003 0.00027799606323242
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
140 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
141 0.0006 0.00055098533630371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
142 0.0001 0.00013208389282227
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0001 0.00011014938354492
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
145 0.0001 0.00011610984802246
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
146 0.0002 0.00015115737915039
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
147 0.0002 0.00017595291137695
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
148 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
149 0.0002 0.00015687942504883
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0002 0.00017404556274414
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
151 0.0002 0.0001530647277832
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
152 0.0002 0.00024914741516113
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
153 0.0002 0.00019097328186035
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
154 0.0004 0.00039505958557129
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
155 0.0002 0.00022101402282715
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0002 0.00017118453979492
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
157 0.0003 0.00028300285339355
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
158 0.0002 0.00019979476928711
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
159 0.0001 0.00014591217041016
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'