Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
OK Lighting OK-603AB-BE8 14.25-Inch Touch Lamp with Bear Theme, Antique Bronze
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

OK Lighting OK-603AB-BE8 14.25-Inch Touch Lamp with Bear Theme, Antique Bronze

£34.02
- stock arriving soon
Product prices and availability are accurate as of 2020-04-17 17:17:09 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.co.uk/ at the time of purchase will apply to the purchase of this product.

Manufacturer Description

OK Lighting 14. 25" Antique Bronze Touch Lamp With Bear Theme. The lamp is antique brass plated with glass shades. The lamps is unassembled. Assembly involves inserting the glass in the shade and then putting the shade on the base.

Product Features

3-WAY TOUCH 40-watt LIGHT BULB INCLUDED The panel are made of glass

There are no customer reviews yet. Be the first to Write a Review!

Write a Review

The Best Products on eBay

Buy it Now

New

28 Day(s) 21 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

12 Day(s) 4 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

12 Day(s) 4 h(s)
Worldwide

N/A

No Returns

Buy it Now

Used

12 Day(s) 13 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

20 Day(s) 22 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

19 Day(s) 3 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

20 Day(s) 1 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

14 Day(s) 4 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

27 Day(s) 9 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

28 Day(s) 8 h(s)
Worldwide

N/A

No Returns

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.880401134491 281 0.3686 0


No Amazon API Requests Made.

Total time 1.880401134491 seconds

Number Time From Start Name Description
1 0.24898910522461 Initialise Initialise FSB Function
2 0.25414609909058 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29021406173706 Start of getCategoryListByGroup Function Before first category groups query
4 0.29148006439209 After initial query Before first category groups query
5 0.29148101806641 Get Category List for Group Before the call to getCategoryList function
6 0.29148507118225 Start of GetCategoryList function Start of the function
7 0.2914891242981 Before getting categories Query to get specific category list
8 0.29286313056946 After getting categories Query to get specific category list
9 0.29286408424377 Before getting category custom Before call to function getCategoryCustom
10 0.31019306182861 After getting category custom After call to function getCategoryCustom
11 0.31019902229309 Before getting category custom Before call to function getCategoryCustom
12 0.3135621547699 After getting category custom After call to function getCategoryCustom
13 0.31356501579285 Before getting category custom Before call to function getCategoryCustom
14 0.31610298156738 After getting category custom After call to function getCategoryCustom
15 0.31610512733459 Before getting category custom Before call to function getCategoryCustom
16 0.31820201873779 After getting category custom After call to function getCategoryCustom
17 0.318204164505 Before getting category custom Before call to function getCategoryCustom
18 0.32293105125427 After getting category custom After call to function getCategoryCustom
19 0.3229341506958 Before getting category custom Before call to function getCategoryCustom
20 0.32636117935181 After getting category custom After call to function getCategoryCustom
21 0.32636308670044 Before getting category custom Before call to function getCategoryCustom
22 0.33002209663391 After getting category custom After call to function getCategoryCustom
23 0.33002400398254 Before getting category custom Before call to function getCategoryCustom
24 0.33343005180359 After getting category custom After call to function getCategoryCustom
25 0.33343315124512 Before getting category custom Before call to function getCategoryCustom
26 0.33699607849121 After getting category custom After call to function getCategoryCustom
27 0.33699917793274 End of GetCategoryList function End of the function
28 0.33701300621033 End of getCategoryListByGroup Function Before return()
29 0.49418497085571 App Controller End End of the App controller (called before the controller of every page)
30 0.49499797821045 Product Start Start of the product info controller
31 0.49623918533325 Cache file not found Starting get product details
32 0.54834914207458 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.9433319568634 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.94662404060364 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.3772251605988 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.3784930706024 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
37 1.7852680683136 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
38 1.7880911827087 Related products Start getting related products if enabled
39 1.7880921363831 Related Products Start Before the related products are found
40 1.7880921363831 Related Products Keywords Before the related product keywords are found
41 1.7880980968475 Create Keyword List Function Start of function
42 1.7882101535797 Create Keyword List Function After looping provided content - 30 keywords found
43 1.7888669967651 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
44 1.7888791561127 Create Keyword List Function After reducing keyword list
45 1.788948059082 Create Keyword List Function After selecting by scoring keywords
46 1.7889521121979 Create Keyword List Function After final loop of keywords
47 1.7889530658722 Related Products Keywords After the related product keywords are found
48 1.8026270866394 Related Products End After the related products are found
49 1.812952041626 Product End End of the product info controller (Product Info)
50 1.8146121501923 App_after Controller Start Start of the App_after controller (called after the controller of every page)
51 1.8163151741028 Before Get Options Before the call to getOptions in the tpl class
52 1.8533141613007 After Get Options After the call to getOptions in the tpl class
53 1.8535070419312 App_after Controller End End of the App_after controller (called after the controller of every page)
54 1.8535561561584 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
55 1.8629469871521 Product Info: After Smarty Fetch After the product.tpl template is fetched
56 1.8629531860352 Product Info: Before Template Display Before the template is displayed
57 1.8803761005402 Product Info: After Template Display After the template is displayed
58 1.8803861141205 Finalizing debug Before the debug is output to the page.
59 1.8804001808167 End of App This is the end of the app logging, final timestamp


Query Debug - 281 Database Queries. Total time 0.3686 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00065803527832031
SELECT parameter, value FROM parameters
2 0.0017 0.0017449855804443
SELECT * FROM `bad_bots`
3 0.0003 0.00029587745666504
SET time_zone = 'Europe/London'
4 0.0018 0.0017778873443604
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.0024960041046143
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0026 0.0025520324707031
UPDATE autorun SET lastrun = '2020-08-06 10:19:05' WHERE id = '15'
7 0.0004 0.00041413307189941
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0016 0.0015869140625
SELECT id FROM pages WHERE pagename = 'ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique' LIMIT 1
9 0.0025 0.0025331974029541
SELECT id FROM products WHERE pagename = 'ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique' AND hidden = 0 LIMIT 1
10 0.0037 0.0037028789520264
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0312 0.031193017959595
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0004 0.00038909912109375
SELECT * FROM pages WHERE pagename = 'ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique'
13 0.0012 0.0012481212615967
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0013 0.0013401508331299
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0049 0.0048720836639404
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
16 0.0019 0.0019381046295166
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
17 0.0014 0.001410961151123
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0004 0.00037097930908203
SELECT id FROM categories WHERE parent_id = '26'
19 0.0029 0.0028841495513916
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0014 0.0014240741729736
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
21 0.0020 0.0019609928131104
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
22 0.0018 0.0018219947814941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0004 0.00035381317138672
SELECT * FROM categorygroups WHERE id = '1'
24 0.0012 0.0012011528015137
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
25 0.0002 0.00023889541625977
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
26 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '27'
28 0.0006 0.00055217742919922
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 
29 0.0002 0.00020098686218262
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 
30 0.0002 0.00021100044250488
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
31 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0002 0.00024986267089844
SELECT * FROM categorygroups WHERE id = '1'
33 0.0005 0.00053691864013672
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
34 0.0002 0.00021696090698242
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
35 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '28'
37 0.0005 0.00052499771118164
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00020289421081543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
39 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
40 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00019097328186035
SELECT * FROM categorygroups WHERE id = '1'
42 0.0003 0.00031304359436035
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
43 0.0002 0.00021219253540039
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
44 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '29'
46 0.0003 0.00029802322387695
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 
47 0.0002 0.00019502639770508
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 
48 0.0002 0.00023102760314941
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
49 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00019001960754395
SELECT * FROM categorygroups WHERE id = '1'
51 0.0009 0.00087308883666992
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
52 0.0006 0.00064682960510254
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
53 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '30'
55 0.0010 0.00097823143005371
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 
56 0.0005 0.00045108795166016
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 
57 0.0003 0.00031590461730957
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
58 0.0003 0.00027704238891602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0003 0.00030803680419922
SELECT * FROM categorygroups WHERE id = '1'
60 0.0006 0.00062203407287598
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
61 0.0003 0.00033211708068848
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
62 0.0002 0.00023484230041504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '31'
64 0.0007 0.00068783760070801
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
65 0.0003 0.0003049373626709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
66 0.0003 0.00032496452331543
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
67 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0003 0.00030207633972168
SELECT * FROM categorygroups WHERE id = '1'
69 0.0007 0.00066399574279785
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 = 32
70 0.0003 0.00031399726867676
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 32
71 0.0004 0.00036787986755371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '32'
73 0.0007 0.00074195861816406
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
74 0.0003 0.00030922889709473
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
75 0.0003 0.0003199577331543
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
76 0.0003 0.00027298927307129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0003 0.0002899169921875
SELECT * FROM categorygroups WHERE id = '1'
78 0.0006 0.0006248950958252
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 = 33
79 0.0003 0.00033187866210938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
80 0.0003 0.00028586387634277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '33'
82 0.0007 0.00067901611328125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0003 0.00029993057250977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
84 0.0003 0.00032997131347656
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
85 0.0002 0.00023913383483887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0003 0.00026607513427734
SELECT * FROM categorygroups WHERE id = '1'
87 0.0006 0.0006411075592041
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 = 34
88 0.0003 0.00030612945556641
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 34
89 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '34'
91 0.0007 0.0006709098815918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
92 0.0003 0.00031900405883789
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (34)
				  AND p.disabled = 0 
93 0.0004 0.00037193298339844
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
94 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0003 0.00028300285339355
SELECT * FROM categorygroups WHERE id = '1'
96 0.0015 0.0015461444854736
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0018 0.0017938613891602
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0006 0.00060701370239258
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
99 0.0012 0.0011849403381348
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0009 0.00086498260498047
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.1455 0.14552402496338
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.160.29') >= INET_ATON(ip_start) AND INET_ATON('3.80.160.29') <= INET_ATON(ip_end)
102 0.0021 0.0020699501037598
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0018 0.0017969608306885
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0004 0.0003809928894043
SELECT * FROM countryredirects WHERE id <> 1
105 0.0004 0.0004270076751709
SELECT * FROM products WHERE pagename = 'ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique'
106 0.0003 0.00034689903259277
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1679
107 0.0003 0.00028514862060547
SELECT * FROM manufacturers WHERE id = '267'
108 0.0003 0.00028681755065918
SELECT category_id FROM products_categories WHERE product_id = '1679'
109 0.0002 0.00022387504577637
SELECT * FROM categories WHERE id = '33'
110 0.0004 0.00040102005004883
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 = 33
111 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
112 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '33'
113 0.0004 0.00039005279541016
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
114 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
115 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
116 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
117 0.0017 0.0016639232635498
SELECT * FROM productimages WHERE product_id = '1679' ORDER BY sortorder ASC
118 0.0013 0.0013260841369629
SELECT * FROM product_image_select WHERE product_id = '1679'
119 0.0026 0.0025930404663086
SELECT * FROM productcustomimages WHERE product_id = '1679'
120 0.0014 0.0014441013336182
SELECT * FROM productfeeds WHERE product_id = '1679' ORDER BY item_date DESC
121 0.0026 0.0026130676269531
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1679' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
122 0.0146 0.014611005783081
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1679' AND t.hidden = 0 AND display_product = 1
123 0.0145 0.014535903930664
SELECT * FROM productamazoncontent WHERE product_id = '1679'
124 0.0039 0.0039188861846924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1679' AND a.name = n.originalname
125 0.0014 0.0014450550079346
SELECT * FROM productoffers WHERE product_id = '1679' AND merchantid = 'A3P5ROKL5A1OLE'
126 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '1679' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = 1679
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00040006637573242
SELECT value FROM productattributes
                WHERE product_id = '1679'
                AND name = 'ListPriceAmount'
129 0.0005 0.00047802925109863
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
130 0.0004 0.00042605400085449
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
131 0.0019 0.0018730163574219
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
132 0.0005 0.00045394897460938
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
133 0.0022 0.0021638870239258
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsAdvanced&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-GB&SECURITY-APPNAME=CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=OK+Lighting+OK-603AB-BE8+14.25-Inch+Touch+Lamp+with+Bear+Theme%2C+Antique+Bronze&paginationInput.pageNumber=1&paginationInput.entriesPerPage=10&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=5338348474&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:40:\"CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12\";s:9:\"authtoken\";s:872:\"AgAAAA**AQAAAA**aAAAAA**nHudXg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wJloekCJmCpwSdj6x9nY+seQ**vzUGAA**AAMAAA**0PcLL5IjXlYT4KWKSP6TQmbS1jHqlPkPchO3UmdfnXAnitHzji9pyoChVgnUmNrM6cTGqAIcJoboQONk44n/aqA4+MJT6ODp++3Nl7zFLIbn+RcglkVr4HF8aFEEVNILdX3erQzQIHSDmODv+QL1TpjPA7Csr13Tpin5QkS9bSNdmAV7rzZ6bR9ECHEYSSISh3XYw1ee0MzO0gx7yQ/w1vXwvi2OtBjuDDIZI71cBlReIsYC42CZgbLabTytchW7EVbdY/fsH2hrNI41ewUgntdf4dsPZ/wkfUBNx4alBE3jwzdbH0guT+B5EuUKblmxNvCZc/2Gzj7lX+79M9A8nRBXZJ5RARjabquo2jBCqAYzT/YGZWMMPWC7Y1C4Nd7lWEL36ii6fmC4z3qvrxar0ztEuMvbm4zRJpP+XmMhxjJ65q1fzcK8gHiSR5sp3C7S9cDN5xW+a6psHAf306B9WSvDk1k6JSwQDmG2DbZuEQmZqXQrjG1dLxB9IPKrN7Zg12DTwKoTU7+y4ITRzh6xJDz9DV9dA4imi9EnswineabPdD8/cReOZuNwp5zY6sl4HoAtttnqBH4M3xpj20prLHwyDv6pmWg0GtXedfLnISXCuVzODdKDGfl4W/GL8cy1UqXAwinzI9y0hlNhgeWB///rRY8OVk2huaGVRvdrf+2dhrZczeKT4fQ4E1qcaFeVWGwhUI6LLdEM8pVds6xUpRt2/z+HyLSHcVCrgCbrWphvWbpBQZweoWVtTBs3Tib5\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:10:\"5338348474\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:40:\"6LeE2Y8UAAAAAFJdEBXWuCq7RGueqpK1wBa3dZjT\";s:13:\"googlesitekey\";s:40:\"6LeE2Y8UAAAAAAy6cXScXGvVSQgPK-E5iV0dbTAk\";s:12:\"ebayglobalid\";s:7:\"EBAY-GB\";s:10:\"ebaysiteid\";s:1:\"3\";s:8:\"currency\";s:3:\"GBP\";}', '', '0.39499378204346', '44a9f08e870abadd7713a4300e9b6fa5', 'https://store-uk.welovebears.club/ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique/'
134 0.0006 0.00063300132751465
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
135 0.0006 0.0005650520324707
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsAdvanced&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-GB&SECURITY-APPNAME=CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=OK+Lighting+OK603ABBE8&paginationInput.pageNumber=1&paginationInput.entriesPerPage=10&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=5338348474&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:40:\"CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12\";s:9:\"authtoken\";s:872:\"AgAAAA**AQAAAA**aAAAAA**nHudXg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wJloekCJmCpwSdj6x9nY+seQ**vzUGAA**AAMAAA**0PcLL5IjXlYT4KWKSP6TQmbS1jHqlPkPchO3UmdfnXAnitHzji9pyoChVgnUmNrM6cTGqAIcJoboQONk44n/aqA4+MJT6ODp++3Nl7zFLIbn+RcglkVr4HF8aFEEVNILdX3erQzQIHSDmODv+QL1TpjPA7Csr13Tpin5QkS9bSNdmAV7rzZ6bR9ECHEYSSISh3XYw1ee0MzO0gx7yQ/w1vXwvi2OtBjuDDIZI71cBlReIsYC42CZgbLabTytchW7EVbdY/fsH2hrNI41ewUgntdf4dsPZ/wkfUBNx4alBE3jwzdbH0guT+B5EuUKblmxNvCZc/2Gzj7lX+79M9A8nRBXZJ5RARjabquo2jBCqAYzT/YGZWMMPWC7Y1C4Nd7lWEL36ii6fmC4z3qvrxar0ztEuMvbm4zRJpP+XmMhxjJ65q1fzcK8gHiSR5sp3C7S9cDN5xW+a6psHAf306B9WSvDk1k6JSwQDmG2DbZuEQmZqXQrjG1dLxB9IPKrN7Zg12DTwKoTU7+y4ITRzh6xJDz9DV9dA4imi9EnswineabPdD8/cReOZuNwp5zY6sl4HoAtttnqBH4M3xpj20prLHwyDv6pmWg0GtXedfLnISXCuVzODdKDGfl4W/GL8cy1UqXAwinzI9y0hlNhgeWB///rRY8OVk2huaGVRvdrf+2dhrZczeKT4fQ4E1qcaFeVWGwhUI6LLdEM8pVds6xUpRt2/z+HyLSHcVCrgCbrWphvWbpBQZweoWVtTBs3Tib5\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:10:\"5338348474\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:40:\"6LeE2Y8UAAAAAFJdEBXWuCq7RGueqpK1wBa3dZjT\";s:13:\"googlesitekey\";s:40:\"6LeE2Y8UAAAAAAy6cXScXGvVSQgPK-E5iV0dbTAk\";s:12:\"ebayglobalid\";s:7:\"EBAY-GB\";s:10:\"ebaysiteid\";s:1:\"3\";s:8:\"currency\";s:3:\"GBP\";}', '', '0.43061017990112', '44a9f08e870abadd7713a4300e9b6fa5', 'https://store-uk.welovebears.club/ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique/'
136 0.0005 0.00046801567077637
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
137 0.0002 0.00020813941955566
SELECT id FROM ebay_products WHERE itemid = '402349818049' 
138 0.0002 0.00017094612121582
SELECT id FROM ebay_products WHERE itemid = '193524502063' 
139 0.0002 0.00018095970153809
SELECT id FROM ebay_products WHERE itemid = '193524496297' 
140 0.0002 0.00016617774963379
SELECT id FROM ebay_products WHERE itemid = '123378393783' 
141 0.0002 0.00017881393432617
SELECT id FROM ebay_products WHERE itemid = '362927605907' 
142 0.0001 0.0001218318939209
SELECT id FROM ebay_products WHERE itemid = '230952858198' 
143 0.0002 0.00016212463378906
SELECT id FROM ebay_products WHERE itemid = '264776581476' 
144 0.0002 0.00016593933105469
SELECT id FROM ebay_products WHERE itemid = '333660726636' 
145 0.0002 0.00016903877258301
SELECT id FROM ebay_products WHERE itemid = '153991965078' 
146 0.0002 0.00018095970153809
SELECT id FROM ebay_products WHERE itemid = '124211427451' 
147 0.0003 0.00026082992553711
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsAdvanced&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-GB&SECURITY-APPNAME=CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=OK+Lighting&paginationInput.pageNumber=1&paginationInput.entriesPerPage=10&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=5338348474&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:40:\"CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12\";s:9:\"authtoken\";s:872:\"AgAAAA**AQAAAA**aAAAAA**nHudXg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wJloekCJmCpwSdj6x9nY+seQ**vzUGAA**AAMAAA**0PcLL5IjXlYT4KWKSP6TQmbS1jHqlPkPchO3UmdfnXAnitHzji9pyoChVgnUmNrM6cTGqAIcJoboQONk44n/aqA4+MJT6ODp++3Nl7zFLIbn+RcglkVr4HF8aFEEVNILdX3erQzQIHSDmODv+QL1TpjPA7Csr13Tpin5QkS9bSNdmAV7rzZ6bR9ECHEYSSISh3XYw1ee0MzO0gx7yQ/w1vXwvi2OtBjuDDIZI71cBlReIsYC42CZgbLabTytchW7EVbdY/fsH2hrNI41ewUgntdf4dsPZ/wkfUBNx4alBE3jwzdbH0guT+B5EuUKblmxNvCZc/2Gzj7lX+79M9A8nRBXZJ5RARjabquo2jBCqAYzT/YGZWMMPWC7Y1C4Nd7lWEL36ii6fmC4z3qvrxar0ztEuMvbm4zRJpP+XmMhxjJ65q1fzcK8gHiSR5sp3C7S9cDN5xW+a6psHAf306B9WSvDk1k6JSwQDmG2DbZuEQmZqXQrjG1dLxB9IPKrN7Zg12DTwKoTU7+y4ITRzh6xJDz9DV9dA4imi9EnswineabPdD8/cReOZuNwp5zY6sl4HoAtttnqBH4M3xpj20prLHwyDv6pmWg0GtXedfLnISXCuVzODdKDGfl4W/GL8cy1UqXAwinzI9y0hlNhgeWB///rRY8OVk2huaGVRvdrf+2dhrZczeKT4fQ4E1qcaFeVWGwhUI6LLdEM8pVds6xUpRt2/z+HyLSHcVCrgCbrWphvWbpBQZweoWVtTBs3Tib5\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:10:\"5338348474\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:40:\"6LeE2Y8UAAAAAFJdEBXWuCq7RGueqpK1wBa3dZjT\";s:13:\"googlesitekey\";s:40:\"6LeE2Y8UAAAAAAy6cXScXGvVSQgPK-E5iV0dbTAk\";s:12:\"ebayglobalid\";s:7:\"EBAY-GB\";s:10:\"ebaysiteid\";s:1:\"3\";s:8:\"currency\";s:3:\"GBP\";}', '1', '0.40678405761719', '44a9f08e870abadd7713a4300e9b6fa5', 'https://store-uk.welovebears.club/ok-lighting-ok-603ab-be8-1425-inch-touch-lamp-with-bear-theme-antique/'
148 0.0015 0.001471996307373
SELECT *, MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AND 1679 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
149 0.0003 0.00030207633972168
SELECT *, MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AND 1679 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0003 0.00026202201843262
SELECT *, MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('lighting ok-603ab-be8 1425-inch' IN BOOLEAN MODE) AND 1679 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
151 0.0015 0.0015299320220947
SELECT *, MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AND 1679 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
152 0.0003 0.00028181076049805
SELECT *, MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AND 1679 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
153 0.0002 0.00021886825561523
SELECT *, MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('lamp with bear' IN BOOLEAN MODE) AND 1679 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
154 0.0012 0.0012459754943848
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
155 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '751'
156 0.0002 0.00016403198242188
SELECT * FROM productcustomimages WHERE product_id = '751'
157 0.0009 0.00087714195251465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
158 0.0003 0.00033187866210938
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
159 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
162 0.0002 0.00017809867858887
SELECT * FROM product_image_select WHERE product_id = '739'
163 0.0002 0.00017881393432617
SELECT * FROM productcustomimages WHERE product_id = '739'
164 0.0014 0.0014398097991943
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
165 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
166 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0007 0.00071001052856445
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
169 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '745'
170 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '745'
171 0.0007 0.00065493583679199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
172 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
173 0.0002 0.0002448558807373
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0002 0.00023913383483887
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0002 0.00022602081298828
SELECT id,asin FROM products WHERE parent_id = 1679
176 0.0011 0.0011179447174072
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1679' ORDER BY timestamp DESC
177 0.0002 0.00020503997802734
SELECT category_id FROM products_categories WHERE product_id = '1679'
178 0.0003 0.00028204917907715
SELECT * FROM categories WHERE id = '33'
179 0.0005 0.0005030632019043
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 = 33
180 0.0002 0.0002281665802002
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
181 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '33'
182 0.0005 0.00049281120300293
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
183 0.0002 0.00023984909057617
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
184 0.0002 0.0001978874206543
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
185 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
186 0.0007 0.00073003768920898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1679' AND a.name = n.originalname
187 0.0002 0.00023007392883301
SELECT * FROM productoffers WHERE product_id = '1679' AND merchantid = 'A3P5ROKL5A1OLE'
188 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = '1679' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00023913383483887
SELECT * FROM productoffers
                WHERE product_id = 1679
                ORDER BY price ASC LIMIT 1
190 0.0002 0.00023889541625977
SELECT value FROM productattributes
                WHERE product_id = '1679'
                AND name = 'ListPriceAmount'
191 0.0002 0.00022292137145996
SELECT * FROM products WHERE id = '1679'
192 0.0008 0.00078606605529785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1679' AND a.name = n.originalname
193 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '1679' AND merchantid = 'A3P5ROKL5A1OLE'
194 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '1679' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = 1679
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00023412704467773
SELECT value FROM productattributes
                WHERE product_id = '1679'
                AND name = 'ListPriceAmount'
197 0.0002 0.00020885467529297
SELECT category_id FROM products_categories WHERE product_id = '1679' AND prod_type = 'amz'
198 0.0002 0.00019192695617676
SELECT parent_id FROM categories WHERE id = '33'
199 0.0002 0.00018882751464844
SELECT * FROM categories WHERE id = '33'
200 0.0004 0.00036501884460449
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 = 33
201 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
202 0.0002 0.00018501281738281
SELECT id FROM categories WHERE parent_id = '33'
203 0.0004 0.00036811828613281
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
204 0.0002 0.00019216537475586
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
205 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
206 0.0003 0.00031399726867676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
207 0.0012 0.0011730194091797
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
208 0.0014 0.0014009475708008
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
209 0.0002 0.00015902519226074
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
210 0.0004 0.00036811828613281
SELECT * FROM pages WHERE id = 42
211 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = 55
212 0.0003 0.00026607513427734
SELECT * FROM pages WHERE id = 45
213 0.0003 0.0002741813659668
SELECT * FROM pages WHERE id = 51
214 0.0002 0.00024914741516113
SELECT * FROM pages WHERE id = 42
215 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = 37
216 0.0003 0.00034117698669434
SELECT * FROM pages WHERE id = 44
217 0.0002 0.00024080276489258
SELECT * FROM pages WHERE id = 53
218 0.0007 0.00069999694824219
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
219 0.0011 0.0011160373687744
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:0:\"\";s:8:\"maxprice\";s:0:\"\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:3:\"all\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1596709147;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"740|amazon\";i:2;s:10:\"745|amazon\";i:3;s:10:\"751|amazon\";i:4;s:10:\"755|amazon\";i:5;s:10:\"769|amazon\";}}' WHERE id = '244'
220 0.0002 0.00024509429931641
SELECT * FROM products WHERE id = 739
221 0.0014 0.0013940334320068
SELECT * FROM products WHERE id = 740
222 0.0003 0.00031185150146484
SELECT * FROM products WHERE id = 745
223 0.0003 0.0002739429473877
SELECT * FROM products WHERE id = 751
224 0.0003 0.00033187866210938
SELECT * FROM products WHERE id = 755
225 0.0003 0.00026798248291016
SELECT * FROM products WHERE id = 769
226 0.0013 0.0012881755828857
SELECT * FROM products WHERE id = '739'
227 0.0003 0.00028181076049805
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
228 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '739'
229 0.0002 0.00023198127746582
SELECT * FROM productcustomimages WHERE product_id = '739'
230 0.0008 0.00078511238098145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
231 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
232 0.0006 0.00055885314941406
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0013 0.0012669563293457
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0004 0.00038290023803711
SELECT * FROM products WHERE id = '740'
235 0.0007 0.00068092346191406
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
236 0.0003 0.00025606155395508
SELECT * FROM product_image_select WHERE product_id = '740'
237 0.0002 0.00023198127746582
SELECT * FROM productcustomimages WHERE product_id = '740'
238 0.0015 0.0015339851379395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
239 0.0005 0.00045680999755859
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'A3P5ROKL5A1OLE'
240 0.0003 0.00031304359436035
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = '745'
243 0.0004 0.00040388107299805
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
244 0.0003 0.0003049373626709
SELECT * FROM product_image_select WHERE product_id = '745'
245 0.0002 0.00023412704467773
SELECT * FROM productcustomimages WHERE product_id = '745'
246 0.0005 0.00052714347839355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
247 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
248 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0002 0.00023007392883301
SELECT * FROM products WHERE id = '751'
251 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
252 0.0002 0.00018692016601562
SELECT * FROM product_image_select WHERE product_id = '751'
253 0.0002 0.00016403198242188
SELECT * FROM productcustomimages WHERE product_id = '751'
254 0.0003 0.00029301643371582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
255 0.0002 0.00023818016052246
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
256 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0002 0.00022196769714355
SELECT * FROM products WHERE id = '755'
259 0.0005 0.0004730224609375
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
260 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '755'
261 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '755'
262 0.0010 0.0010311603546143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
263 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
264 0.0003 0.00029706954956055
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = '769'
267 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
268 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '769'
269 0.0002 0.00022411346435547
SELECT * FROM productcustomimages WHERE product_id = '769'
270 0.0007 0.00069499015808105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
271 0.0003 0.00027990341186523
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
272 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0017 0.0017180442810059
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
275 0.0004 0.0003669261932373
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
276 0.0030 0.0030131340026855
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
277 0.0017 0.0016720294952393
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
278 0.0003 0.00028681755065918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
279 0.0004 0.00037288665771484
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
280 0.0003 0.00034499168395996
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
281 0.0004 0.00041699409484863
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'