Terms & Conditions (Terms of Use)

General

We may change or withdraw any part of the website, or may refuse you access to the website at any time if we consider it necessary. Use of We and these terms are subject to the laws of England and the jurisdiction of the English Courts.Neither you nor We will be held liable for any failure to perform any obligation to the other due to causes beyond your or We respective reasonable control.

Disclaimer

Orders are placed through Amazon and as such We do not dispatch, fulfill or refund any orders. Returns, disputes and any order queries remain the responsibility of Amazon. We does not accept any responsibility for orders placed with Amazon.

Availability of our website

We will try to make our website available but cannot guarantee that our website will operate continuously or without interruptions or be error free and can accept no liability for its unavailability. You must not attempt to interfere with the proper working of our website and, in particular, you must not attempt to circumvent security, tamper with, hack into, or otherwise disrupt any computer system, server, website, router or any other Internet connected device.

We will do our best to ensure that all materials and information published on our website are accurate, but please note that all content, materials and information on our website are provided on an as is basis and you assume total responsibility and risk for your use of our website and use of all information contained within it.

We will do our best to correct errors and omissions as quickly as practicable after being notified of them.

Prices

Prices of products and postage costs are subject to change at any time. You will always be confirmed of the exact price you will pay before confirming your order. We will not honour any previous prices of products or shipping under any circumstances.

Liability

We does not accept liability (except as set out in these terms and conditions) for any errors or omissions.You will be responsible for any breach of these terms by you and if you use We in breach of these terms you will be liable to and will reimburse We for any loss or damage caused as a result.We shall have no liability (including liability for negligence) for the acts or omissions of telecommunications service providers or for failures of, or faults in, their networks and equipment.

Privacy

We do not hold any personal information unless you choose to sign up to our We newsletter. Please review our Privacy Policy for full details.

Confirmation of Terms

By using this website you agree to these conditions of use. By agreeing to these conditions of use, you warrant and undertake that you will not use our website for any purpose that is illegal or prohibited by these conditions of use, including without limitation the posting or transmitting of any libellous, defamatory, inflammatory or obscene material. If you breach these terms and conditions then your permission to use this website terminates immediately without the necessity of any notice being given to you. We retain the right to deny access to any person who fails to comply with these terms of use.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.39567494392395 159 0.0888 0


No Amazon API Requests Made.


App Debug - Total Time 0.39567494392395 seconds

Number Time From Start Name Description
1 0.26226997375488 Initialise Initialise FSB Function
2 0.26401901245117 App Controller Start Start of the App controller (called before the controller of every page)
3 0.27148103713989 Start of getCategoryListByGroup Function Before first category groups query
4 0.27199196815491 After initial query Before first category groups query
5 0.27199196815491 Get Category List for Group Before the call to getCategoryList function
6 0.27199387550354 Start of GetCategoryList function Start of the function
7 0.27199602127075 Before getting categories Query to get specific category list
8 0.27254486083984 After getting categories Query to get specific category list
9 0.27254605293274 Before getting category custom Before call to function getCategoryCustom
10 0.27750205993652 After getting category custom After call to function getCategoryCustom
11 0.27750682830811 Before getting category custom Before call to function getCategoryCustom
12 0.2785849571228 After getting category custom After call to function getCategoryCustom
13 0.27858686447144 Before getting category custom Before call to function getCategoryCustom
14 0.2796778678894 After getting category custom After call to function getCategoryCustom
15 0.2796790599823 Before getting category custom Before call to function getCategoryCustom
16 0.28057789802551 After getting category custom After call to function getCategoryCustom
17 0.28058004379272 End of GetCategoryList function End of the function
18 0.28058290481567 Get Category List for Group Before the call to getCategoryList function
19 0.28058385848999 Start of GetCategoryList function Start of the function
20 0.2805860042572 Before getting categories Query to get specific category list
21 0.28070783615112 End of getCategoryListByGroup Function Before return()
22 0.32560086250305 App Controller End End of the App controller (called before the controller of every page)
23 0.32833290100098 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.32900190353394 Before Get Options Before the call to getOptions in the tpl class
25 0.35789084434509 After Get Options After the call to getOptions in the tpl class
26 0.35792803764343 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.39566588401794 Finalizing debug Before the debug is output to the page.
28 0.39567494392395 End of App This is the end of the app logging, final timestamp


Query Debug - 159 Database Queries. Total time 0.0888 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010249614715576
SELECT parameter, value FROM parameters
2 0.0013 0.0012750625610352
SELECT * FROM `bad_bots`
3 0.0010 0.00098800659179688
SET time_zone = 'Europe/London'
4 0.0003 0.00030994415283203
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019121170043945
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6 0.0011 0.0010561943054199
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679623759'
7 0.0021 0.0020830631256104
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014090538024902
UPDATE autorun SET lastrun = '2023-03-24 02:09:19' WHERE id = '17'
9 0.0001 0.00011301040649414
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0008 0.00084400177001953
SELECT id FROM pages WHERE pagename = 'terms-of-use' LIMIT 1
11 0.0001 9.7990036010742E-5
SELECT * FROM pages WHERE id = 55
12 0.0012 0.0012309551239014
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0057 0.0056560039520264
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0001 0.0001380443572998
SELECT * FROM pages WHERE pagename = 'terms-of-use'
15 0.0005 0.00049996376037598
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00053310394287109
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0022 0.002234935760498
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.0005 0.00046300888061523
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.0003 0.00029397010803223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0005 0.00052905082702637
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.0003 0.00032496452331543
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.0005 0.00051093101501465
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.0003 0.00032186508178711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 7.7009201049805E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00023794174194336
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 9.2983245849609E-5
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 5.9127807617188E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0002 0.00022983551025391
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 7.5101852416992E-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 8.392333984375E-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 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 6.8902969360352E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0002 0.0002439022064209
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.7036361694336E-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 5.8889389038086E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 6.6995620727539E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0002 0.00024104118347168
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 7.2956085205078E-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 8.2969665527344E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.0001530647277832
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 9.3936920166016E-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
46 0.0001 5.9843063354492E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00016307830810547
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 7.319450378418E-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 8.2015991210938E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00011205673217773
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0012 0.0011780261993408
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0007 0.00068306922912598
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00018596649169922
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.00018310546875
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0005 0.00048112869262695
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0357 0.03574013710022
SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
60 0.0008 0.00075483322143555
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0003 0.00029301643371582
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0001 0.00014710426330566
SELECT * FROM pages WHERE pagename = 'terms-of-use'
63 0.0006 0.00061297416687012
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
64 0.0005 0.00051283836364746
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
65 0.0001 8.2015991210938E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
66 0.0001 9.4175338745117E-5
SELECT * FROM pages WHERE id = 38
67 0.0001 8.7976455688477E-5
SELECT * FROM categories WHERE id = '27'
68 0.0002 0.00018191337585449
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 6.3896179199219E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
70 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
71 0.0002 0.00017213821411133
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 7.7009201049805E-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 9.7990036010742E-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
74 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
75 0.0001 0.00014591217041016
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 5.9127807617188E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
77 0.0002 0.00016117095947266
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 7.1048736572266E-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.7990036010742E-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 5.8174133300781E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
81 0.0001 6.413459777832E-5
SELECT id FROM categories WHERE parent_id = '27'
82 0.0002 0.00023484230041504
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.0011 0.0011301040649414
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
84 0.0005 0.00046110153198242
SELECT * FROM categoryimages WHERE category_id = 27
85 0.0001 7.6055526733398E-5
SELECT * FROM categorygroups WHERE id = '1'
86 0.0002 0.00019288063049316
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 8.6069107055664E-5
SELECT * FROM categories WHERE id = '30'
88 0.0002 0.00022721290588379
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 5.9843063354492E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
90 0.0001 6.2942504882812E-5
SELECT id FROM categories WHERE parent_id = '30'
91 0.0003 0.00025701522827148
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 7.7009201049805E-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 8.2969665527344E-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
94 0.0001 6.6041946411133E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
95 0.0002 0.00022101402282715
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 5.8889389038086E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
97 0.0003 0.00032591819763184
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 0.0001060962677002
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 0.00010085105895996
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.1988830566406E-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.00025296211242676
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.0009 0.00089311599731445
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
104 0.0001 7.2002410888672E-5
SELECT * FROM categoryimages WHERE category_id = 30
105 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '1'
106 0.0002 0.00024819374084473
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 0.00010299682617188
SELECT * FROM pages WHERE id = 59
108 0.0001 8.4877014160156E-5
SELECT * FROM pages WHERE id = 55
109 0.0005 0.00046801567077637
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.0001070499420166
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:1679623760;s:8:\"products\";a:0:{}}' WHERE id = '8'
111 0.0002 0.00020885467529297
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 9.0837478637695E-5
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:1679623760;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.00011420249938965
SELECT * FROM products WHERE id = 7004
114 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = 7011
115 0.0001 9.9897384643555E-5
SELECT * FROM products WHERE id = 7045
116 0.0001 0.00010299682617188
SELECT * FROM products WHERE id = '7004'
117 0.0007 0.00065302848815918
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
118 0.0005 0.00052618980407715
SELECT * FROM product_image_select WHERE product_id = '7004'
119 0.0005 0.00050687789916992
SELECT * FROM productcustomimages WHERE product_id = '7004'
120 0.0025 0.0025250911712646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
121 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
122 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0001 0.00011610984802246
SELECT * FROM products WHERE id = '7011'
125 0.0001 9.8943710327148E-5
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
126 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '7011'
127 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
128 0.0011 0.0010950565338135
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.00010013580322266
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0001 9.2029571533203E-5
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
132 0.0001 0.00010919570922852
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
133 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = '7045'
134 0.0001 0.0001070499420166
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
135 0.0001 0.00013208389282227
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.00014090538024902
SELECT * FROM product_image_select WHERE product_id = '7045'
137 0.0001 8.6069107055664E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
138 0.0001 0.0001380443572998
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.0010 0.00097894668579102
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.00011086463928223
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.00060415267944336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
142 0.0001 9.2983245849609E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 9.7036361694336E-5
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0001 8.702278137207E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
145 0.0001 0.00010299682617188
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
146 0.0001 0.00013589859008789
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.00017499923706055
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.00010585784912109
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.0001 0.00014710426330566
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0001 0.00014495849609375
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.0001 0.00013899803161621
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.0007 0.00065708160400391
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
153 0.0002 0.00018405914306641
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
154 0.0012 0.0011889934539795
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
155 0.0007 0.00069904327392578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0002 0.00017189979553223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
157 0.0002 0.00020885467529297
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
158 0.0001 0.00014805793762207
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
159 0.0001 0.00013303756713867
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'