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.46365594863892 159 0.0575 0


No Amazon API Requests Made.


App Debug - Total Time 0.46365594863892 seconds

Number Time From Start Name Description
1 0.38714599609375 Initialise Initialise FSB Function
2 0.38780093193054 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39287710189819 Start of getCategoryListByGroup Function Before first category groups query
4 0.39303302764893 After initial query Before first category groups query
5 0.39303398132324 Get Category List for Group Before the call to getCategoryList function
6 0.39303588867188 Start of GetCategoryList function Start of the function
7 0.39303803443909 Before getting categories Query to get specific category list
8 0.39343500137329 After getting categories Query to get specific category list
9 0.39343500137329 Before getting category custom Before call to function getCategoryCustom
10 0.39502692222595 After getting category custom After call to function getCategoryCustom
11 0.3950309753418 Before getting category custom Before call to function getCategoryCustom
12 0.39608192443848 After getting category custom After call to function getCategoryCustom
13 0.39608311653137 Before getting category custom Before call to function getCategoryCustom
14 0.39716792106628 After getting category custom After call to function getCategoryCustom
15 0.3971700668335 Before getting category custom Before call to function getCategoryCustom
16 0.39809203147888 After getting category custom After call to function getCategoryCustom
17 0.39809393882751 End of GetCategoryList function End of the function
18 0.39809703826904 Get Category List for Group Before the call to getCategoryList function
19 0.39809703826904 Start of GetCategoryList function Start of the function
20 0.39809894561768 Before getting categories Query to get specific category list
21 0.39820504188538 End of getCategoryListByGroup Function Before return()
22 0.4308340549469 App Controller End End of the App controller (called before the controller of every page)
23 0.43644595146179 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.43670511245728 Before Get Options Before the call to getOptions in the tpl class
25 0.45154500007629 After Get Options After the call to getOptions in the tpl class
26 0.45157408714294 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.46364688873291 Finalizing debug Before the debug is output to the page.
28 0.4636549949646 End of App This is the end of the app logging, final timestamp


Query Debug - 159 Database Queries. Total time 0.0575 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00028896331787109
SELECT parameter, value FROM parameters
2 0.0004 0.0004119873046875
SELECT * FROM `bad_bots`
3 0.0001 0.00014615058898926
SET time_zone = 'Europe/London'
4 0.0002 0.00016307830810547
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00022411346435547
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6 0.0001 0.00014519691467285
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679624813'
7 0.0002 0.00023102760314941
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00011515617370605
UPDATE autorun SET lastrun = '2023-03-24 02:26:53' WHERE id = '9'
9 0.0001 8.082389831543E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00018405914306641
SELECT id FROM pages WHERE pagename = 'terms-of-use' LIMIT 1
11 0.0001 8.9883804321289E-5
SELECT * FROM pages WHERE id = 55
12 0.0004 0.00035786628723145
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0041 0.004133939743042
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00016307830810547
SELECT * FROM pages WHERE pagename = 'terms-of-use'
15 0.0001 0.00014591217041016
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.0003819465637207
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00034284591674805
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.00017595291137695
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.00011801719665527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 6.8902969360352E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00020503997802734
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.0002 0.00016498565673828
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.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.0002291202545166
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 8.8930130004883E-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.793571472168E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0002 0.0002129077911377
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 9.5129013061523E-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.702278137207E-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.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0002 0.00023293495178223
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 8.6069107055664E-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.6982040405273E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00027298927307129
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.5101852416992E-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.4161758422852E-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.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00015497207641602
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 8.6069107055664E-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.8174133300781E-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.00016498565673828
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 9.7990036010742E-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.6069107055664E-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.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 9.7036361694336E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0005 0.0004570484161377
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0002 0.00022482872009277
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00016117095947266
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.00017094612121582
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00029492378234863
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0303 0.030308961868286
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.0002 0.00017809867858887
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0001 0.00014185905456543
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0001 0.00012993812561035
SELECT * FROM pages WHERE pagename = 'terms-of-use'
63 0.0002 0.00016403198242188
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
64 0.0001 0.0001227855682373
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
65 0.0001 6.9141387939453E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
66 0.0001 0.0001060962677002
SELECT * FROM pages WHERE id = 38
67 0.0001 8.5115432739258E-5
SELECT * FROM categories WHERE id = '27'
68 0.0002 0.0001671314239502
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.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
70 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '27'
71 0.0002 0.00016999244689941
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.6055526733398E-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 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
74 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
75 0.0002 0.00016999244689941
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 6.103515625E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
77 0.0002 0.00016188621520996
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.2002410888672E-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 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
80 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
81 0.0001 6.1988830566406E-5
SELECT id FROM categories WHERE parent_id = '27'
82 0.0002 0.0001978874206543
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.00019407272338867
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
84 0.0001 0.00012898445129395
SELECT * FROM categoryimages WHERE category_id = 27
85 0.0001 6.9856643676758E-5
SELECT * FROM categorygroups WHERE id = '1'
86 0.0002 0.00019097328186035
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.5115432739258E-5
SELECT * FROM categories WHERE id = '30'
88 0.0002 0.00023007392883301
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.0796737670898E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
90 0.0001 8.6069107055664E-5
SELECT id FROM categories WHERE parent_id = '30'
91 0.0002 0.00024580955505371
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.5101852416992E-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.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 (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
94 0.0001 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
95 0.0002 0.00022196769714355
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.9127807617188E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
97 0.0003 0.0002601146697998
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.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 
99 0.0001 8.1062316894531E-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 5.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
101 0.0001 6.3896179199219E-5
SELECT id FROM categories WHERE parent_id = '30'
102 0.0003 0.00025582313537598
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.00013208389282227
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
104 0.0001 6.9856643676758E-5
SELECT * FROM categoryimages WHERE category_id = 30
105 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '1'
106 0.0003 0.00025296211242676
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 8.702278137207E-5
SELECT * FROM pages WHERE id = 59
108 0.0001 8.3208084106445E-5
SELECT * FROM pages WHERE id = 55
109 0.0002 0.00021600723266602
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.00010299682617188
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:1679624813;s:8:\"products\";a:0:{}}' WHERE id = '8'
111 0.0002 0.00020980834960938
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 8.9883804321289E-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:1679624813;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.0001220703125
SELECT * FROM products WHERE id = 7004
114 0.0001 0.00010514259338379
SELECT * FROM products WHERE id = 7011
115 0.0001 0.00010108947753906
SELECT * FROM products WHERE id = 7045
116 0.0001 0.00010299682617188
SELECT * FROM products WHERE id = '7004'
117 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
118 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '7004'
119 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '7004'
120 0.0006 0.00063705444335938
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.00011301040649414
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
122 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0001 0.00014710426330566
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0001 0.00011682510375977
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.00012993812561035
SELECT * FROM product_image_select WHERE product_id = '7011'
127 0.0001 8.5115432739258E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
128 0.0006 0.00056695938110352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
129 0.0001 9.6797943115234E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
130 0.0001 9.7990036010742E-5
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.00013303756713867
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
133 0.0001 0.00013089179992676
SELECT * FROM products WHERE id = '7045'
134 0.0001 0.00010085105895996
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
135 0.0001 0.00013184547424316
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.00013184547424316
SELECT * FROM product_image_select WHERE product_id = '7045'
137 0.0001 8.5115432739258E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
138 0.0001 0.00013113021850586
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.0002741813659668
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.00012087821960449
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.00057506561279297
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.00011610984802246
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 9.9897384643555E-5
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0001 8.8930130004883E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
145 0.0001 0.00010418891906738
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
146 0.0001 0.00012302398681641
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.00015807151794434
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.0001060962677002
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.0001370906829834
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0002 0.00016498565673828
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.00014114379882812
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.00023913383483887
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
153 0.0002 0.00016403198242188
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
154 0.0004 0.00039887428283691
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
155 0.0002 0.00020694732666016
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0001 0.00014686584472656
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
157 0.0001 0.00014090538024902
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
158 0.0001 0.0001368522644043
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
159 0.0001 0.00012087821960449
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'