Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Gango Home Decor Rustic Deer Bear Beaver and Moose Sign; Cabin Lodge Décor
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Gango Home Decor Rustic Deer Bear Beaver and Moose Sign; Cabin Lodge Décor

Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-18 06:57:14 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

All of our posters are high-quality prints on paper. Posters are printed an off-set lithographic process . Perfect for a cabin or lodge!

Product Features

Rustic bear dear Artist Stephanie Marrott Printed with high quality inks Satisfaction Guaranteed Made in the USA

Product Tags

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

13 Day(s) 13 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
4.4656789302826 305 1.3939 0


No Amazon API Requests Made.

Total time 4.4656789302826 seconds

Number Time From Start Name Description
1 0.51432085037231 Initialise Initialise FSB Function
2 0.53530693054199 App Controller Start Start of the App controller (called before the controller of every page)
3 0.56269192695618 Start of getCategoryListByGroup Function Before first category groups query
4 0.56474900245667 After initial query Before first category groups query
5 0.5647509098053 Get Category List for Group Before the call to getCategoryList function
6 0.56475591659546 Start of GetCategoryList function Start of the function
7 0.56476092338562 Before getting categories Query to get specific category list
8 0.5664689540863 After getting categories Query to get specific category list
9 0.56647086143494 Before getting category custom Before call to function getCategoryCustom
10 0.64251589775085 After getting category custom After call to function getCategoryCustom
11 0.64252185821533 Before getting category custom Before call to function getCategoryCustom
12 0.64712190628052 After getting category custom After call to function getCategoryCustom
13 0.64712691307068 Before getting category custom Before call to function getCategoryCustom
14 0.65149879455566 After getting category custom After call to function getCategoryCustom
15 0.65150284767151 Before getting category custom Before call to function getCategoryCustom
16 0.65438199043274 After getting category custom After call to function getCategoryCustom
17 0.65438580513 Before getting category custom Before call to function getCategoryCustom
18 0.6763858795166 After getting category custom After call to function getCategoryCustom
19 0.67639183998108 Before getting category custom Before call to function getCategoryCustom
20 0.67970991134644 After getting category custom After call to function getCategoryCustom
21 0.67971396446228 Before getting category custom Before call to function getCategoryCustom
22 0.68760585784912 After getting category custom After call to function getCategoryCustom
23 0.68761086463928 Before getting category custom Before call to function getCategoryCustom
24 0.7119779586792 After getting category custom After call to function getCategoryCustom
25 0.71198391914368 Before getting category custom Before call to function getCategoryCustom
26 0.72481989860535 After getting category custom After call to function getCategoryCustom
27 0.72482395172119 End of GetCategoryList function End of the function
28 0.72483491897583 End of getCategoryListByGroup Function Before return()
29 1.2951788902283 App Controller End End of the App controller (called before the controller of every page)
30 1.2959899902344 Product Start Start of the product info controller
31 1.3099629878998 Cache file not found Starting get product details
32 1.5813097953796 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 2.0787308216095 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 2.0846908092499 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 2.5966639518738 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 2.597865819931 Related products Start getting related products if enabled
37 2.5978689193726 Related Products Start Before the related products are found
38 2.5978698730469 Related Products Keywords Before the related product keywords are found
39 2.5978758335114 Create Keyword List Function Start of function
40 2.5993847846985 Create Keyword List Function After looping provided content - 36 keywords found
41 2.6051249504089 Create Keyword List Function After looping initial keyword list - 35 keywords remaining
42 2.6051428318024 Create Keyword List Function After reducing keyword list
43 2.6053159236908 Create Keyword List Function After selecting by scoring keywords
44 2.6053218841553 Create Keyword List Function After final loop of keywords
45 2.6053237915039 Related Products Keywords After the related product keywords are found
46 2.6629858016968 Related Products End After the related products are found
47 2.7347009181976 Product End End of the product info controller (Product Info)
48 2.7529129981995 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 2.7678928375244 Before Get Options Before the call to getOptions in the tpl class
50 2.9329988956451 After Get Options After the call to getOptions in the tpl class
51 2.9331839084625 App_after Controller End End of the App_after controller (called after the controller of every page)
52 2.9332308769226 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
53 4.3614637851715 Product Info: After Smarty Fetch After the product.tpl template is fetched
54 4.3614687919617 Product Info: Before Template Display Before the template is displayed
55 4.4656419754028 Product Info: After Template Display After the template is displayed
56 4.4656538963318 Finalizing debug Before the debug is output to the page.
57 4.4656779766083 End of App This is the end of the app logging, final timestamp


Query Debug - 305 Database Queries. Total time 1.3939 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0131 0.013098955154419
SELECT parameter, value FROM parameters
2 0.0017 0.0016829967498779
SELECT * FROM `bad_bots`
3 0.0003 0.00028514862060547
SET time_zone = 'Europe/London'
4 0.0018 0.0017650127410889
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020489692687988
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00026106834411621
UPDATE autorun SET lastrun = '2020-08-06 10:45:36' WHERE id = '16'
7 0.0003 0.00028395652770996
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0145 0.014506101608276
SELECT id FROM pages WHERE pagename = 'gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge' LIMIT 1
9 0.0054 0.0053679943084717
SELECT id FROM products WHERE pagename = 'gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge' AND hidden = 0 LIMIT 1
10 0.0038 0.0038421154022217
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0220 0.022027969360352
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0003 0.00031399726867676
SELECT * FROM pages WHERE pagename = 'gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge'
13 0.0020 0.0020270347595215
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0017 0.0016541481018066
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0243 0.024293184280396
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.0080 0.0080380439758301
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.0091 0.0091440677642822
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0003 0.00033688545227051
SELECT id FROM categories WHERE parent_id = '26'
19 0.0127 0.012717008590698
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.0080 0.0080301761627197
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.0111 0.011068820953369
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.0017 0.0016601085662842
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0003 0.00034904479980469
SELECT * FROM categorygroups WHERE id = '1'
24 0.0017 0.0017142295837402
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.00023603439331055
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.0003 0.00025200843811035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '27'
28 0.0008 0.00079607963562012
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.0003 0.00026512145996094
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.0003 0.00029993057250977
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.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0003 0.00027585029602051
SELECT * FROM categorygroups WHERE id = '1'
33 0.0009 0.00087904930114746
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.0010 0.00095415115356445
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.00023293495178223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0002 0.0002439022064209
SELECT id FROM categories WHERE parent_id = '28'
37 0.0009 0.00086712837219238
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.0003 0.00031590461730957
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.0003 0.00025200843811035
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.00024604797363281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00018715858459473
SELECT * FROM categorygroups WHERE id = '1'
42 0.0004 0.00042295455932617
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.0003 0.00029706954956055
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.00023603439331055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '29'
46 0.0005 0.0004730224609375
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.0003 0.00029897689819336
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.000244140625
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.0003 0.00028300285339355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00018191337585449
SELECT * FROM categorygroups WHERE id = '1'
51 0.0009 0.00092601776123047
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.0003 0.00025796890258789
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.0035 0.0035099983215332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54 0.0091 0.00913405418396
SELECT id FROM categories WHERE parent_id = '30'
55 0.0068 0.0068469047546387
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.0003 0.00029110908508301
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.00030112266540527
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.0002 0.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0003 0.00025486946105957
SELECT * FROM categorygroups WHERE id = '1'
60 0.0006 0.00062894821166992
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.00028800964355469
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.00023508071899414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '31'
64 0.0007 0.00067496299743652
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.00027298927307129
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.00029301643371582
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.0002 0.00023508071899414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0003 0.00025296211242676
SELECT * FROM categorygroups WHERE id = '1'
69 0.0006 0.00064897537231445
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.00028896331787109
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.0010 0.0010221004486084
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0007 0.00073909759521484
SELECT id FROM categories WHERE parent_id = '32'
73 0.0010 0.00098800659179688
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.0018 0.0017719268798828
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.0006 0.00064802169799805
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.0010 0.00099301338195801
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0006 0.00060701370239258
SELECT * FROM categorygroups WHERE id = '1'
78 0.0033 0.0032589435577393
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.0036 0.0036499500274658
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.0103 0.010283946990967
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0013 0.0013418197631836
SELECT id FROM categories WHERE parent_id = '33'
82 0.0006 0.00064396858215332
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.0019 0.0018529891967773
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.0012 0.0012021064758301
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.0007 0.00073385238647461
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0012 0.0011558532714844
SELECT * FROM categorygroups WHERE id = '1'
87 0.0026 0.0025858879089355
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.0013 0.0013318061828613
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.0006 0.000640869140625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0010 0.001021146774292
SELECT id FROM categories WHERE parent_id = '34'
91 0.0026 0.0025990009307861
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.0013 0.0012609958648682
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.0013 0.001288890838623
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.0011 0.0011191368103027
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0008 0.00075197219848633
SELECT * FROM categorygroups WHERE id = '1'
96 0.0074 0.0074200630187988
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0122 0.0122389793396
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0037 0.0036511421203613
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.0024 0.0024499893188477
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0030 0.0029730796813965
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.4992 0.4991729259491
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.0320 0.03203296661377
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0056 0.0055820941925049
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0032 0.0031518936157227
SELECT * FROM countryredirects WHERE id <> 1
105 0.0005 0.00045514106750488
SELECT * FROM products WHERE pagename = 'gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge'
106 0.0053 0.0053369998931885
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1411
107 0.0003 0.00028300285339355
SELECT * FROM manufacturers WHERE id = '228'
108 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '228'
109 0.0019 0.0019478797912598
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '228' LIMIT 1
110 0.0004 0.00038814544677734
SELECT pagename, id FROM products p WHERE manufacturer_id = '228' ORDER BY RAND() LIMIT 1
111 0.0020 0.0019738674163818
SELECT * FROM productimages WHERE product_id = '1412' ORDER BY sortorder ASC
112 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '228'
113 0.0003 0.0003199577331543
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '228'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
114 0.0003 0.00027799606323242
SELECT * FROM manufacturerimages WHERE manufacturer_id = '228'
115 0.0003 0.00029802322387695
SELECT category_id FROM products_categories WHERE product_id = '1411'
116 0.0003 0.00025796890258789
SELECT * FROM categories WHERE id = '27'
117 0.0007 0.00069093704223633
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
118 0.0003 0.00026082992553711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
119 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '27'
120 0.0008 0.00078916549682617
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 
121 0.0003 0.00033688545227051
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 
122 0.0003 0.00031709671020508
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
123 0.0002 0.00023508071899414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
124 0.0003 0.00030803680419922
SELECT * FROM productimages WHERE product_id = '1411' ORDER BY sortorder ASC
125 0.0038 0.0037949085235596
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1411' AND p.id = pi.product_id ORDER BY pi.sortorder
126 0.0022 0.0021770000457764
SELECT * FROM product_image_select WHERE product_id = '1411'
127 0.0300 0.030045986175537
SELECT * FROM productcustomimages WHERE product_id = '1411'
128 0.0014 0.0014059543609619
SELECT * FROM productfeeds WHERE product_id = '1411' ORDER BY item_date DESC
129 0.0042 0.0042080879211426
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1411' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
130 0.0370 0.037039995193481
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1411' AND t.hidden = 0 AND display_product = 1
131 0.0003 0.00031805038452148
SELECT * FROM tags WHERE id = '1'
132 0.0024 0.0023729801177979
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
133 0.0011 0.0011260509490967
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
134 0.0026 0.002593994140625
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
135 0.0102 0.01016902923584
SELECT * FROM productimages WHERE product_id = '1696' ORDER BY sortorder ASC
136 0.0154 0.01537299156189
SELECT * FROM productamazoncontent WHERE product_id = '1411'
137 0.0486 0.048568964004517
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 = '1411'
                GROUP BY o.product_id
138 0.0733 0.0732581615448
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     = '1411'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
139 0.0107 0.010694980621338
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1411
140 0.0031 0.003122091293335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1411' AND a.name = n.originalname
141 0.0003 0.00031399726867676
SELECT * FROM productoffers WHERE product_id = '1411' AND merchantid = 'A3P5ROKL5A1OLE'
142 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = '1411' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = 1411
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00039386749267578
SELECT value FROM productattributes
                WHERE product_id = '1411'
                AND name = 'ListPriceAmount'
145 0.0005 0.00045108795166016
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 = '1411'
                GROUP BY o.product_id
146 0.0008 0.00078797340393066
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     = '1411'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
147 0.0005 0.00050210952758789
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1411
148 0.0007 0.00065183639526367
SELECT value FROM productattributes WHERE product_id = '1411' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0050 0.0050139427185059
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1411'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
150 0.0020 0.0019569396972656
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
151 0.0005 0.00045299530029297
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
152 0.0020 0.0020139217376709
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
153 0.0005 0.00046110153198242
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
154 0.0047 0.004673957824707
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=Gango+Home+Decor+Rustic+Deer+Bear+Beaver+and+Moose+Sign%3B+Cabin+Lodge+D%C3%A9cor&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.49743390083313', '12c735bce770e1471fc1b77b701cf354', 'https://store-uk.welovebears.club/gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge/'
155 0.0006 0.00055289268493652
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
156 0.0004 0.00041699409484863
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=Gango+Home+Decor&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.51198315620422', '12c735bce770e1471fc1b77b701cf354', 'https://store-uk.welovebears.club/gango-home-decor-rustic-deer-bear-beaver-and-moose-sign-cabin-lodge/'
157 0.0194 0.019442081451416
SELECT *, MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AND 1411 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
158 0.0003 0.00032711029052734
SELECT *, MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AND 1411 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
159 0.0004 0.00035810470581055
SELECT *, MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('decor rustic deer' IN BOOLEAN MODE) AND 1411 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
160 0.0075 0.0074751377105713
SELECT * FROM productimages WHERE product_id = '1665' ORDER BY sortorder ASC
161 0.0003 0.00028395652770996
SELECT * FROM product_image_select WHERE product_id = '1665'
162 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '1665'
163 0.0062 0.0061888694763184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1665' AND a.name = n.originalname
164 0.0030 0.0030429363250732
SELECT * FROM productoffers WHERE product_id = '1665' AND merchantid = 'A3P5ROKL5A1OLE'
165 0.0003 0.00033712387084961
SELECT * FROM productoffers
                WHERE product_id = '1665' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.0003511905670166
SELECT value FROM productattributes WHERE product_id = '1665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0008 0.0008392333984375
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
168 0.0003 0.0003211498260498
SELECT * FROM product_image_select WHERE product_id = '740'
169 0.0002 0.00017404556274414
SELECT * FROM productcustomimages WHERE product_id = '740'
170 0.0045 0.004457950592041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
171 0.0003 0.00031208992004395
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'A3P5ROKL5A1OLE'
172 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0070 0.0069849491119385
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0007 0.00065183639526367
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
175 0.0004 0.0003960132598877
SELECT * FROM product_image_select WHERE product_id = '751'
176 0.0008 0.00077295303344727
SELECT * FROM productcustomimages WHERE product_id = '751'
177 0.0013 0.0013158321380615
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
178 0.0007 0.00069808959960938
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
179 0.0004 0.00041389465332031
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00049591064453125
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0004 0.00036406517028809
SELECT id,asin FROM products WHERE parent_id = 1411
182 0.0004 0.00035309791564941
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1412
183 0.0004 0.0004420280456543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1412
184 0.0004 0.00040006637573242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1413
185 0.0022 0.0022439956665039
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1413
186 0.0006 0.00056314468383789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1416
187 0.0028 0.0027520656585693
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1416
188 0.0022 0.0022480487823486
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1577
189 0.0030 0.0029838085174561
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1577
190 0.0017 0.0017170906066895
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1594
191 0.0004 0.00041604042053223
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1594
192 0.0092 0.0091769695281982
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1411' ORDER BY timestamp DESC
193 0.0006 0.00063705444335938
SELECT category_id FROM products_categories WHERE product_id = '1411'
194 0.0006 0.0005500316619873
SELECT * FROM categories WHERE id = '27'
195 0.0009 0.00091099739074707
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
196 0.0002 0.00024294853210449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
197 0.0003 0.00026917457580566
SELECT id FROM categories WHERE parent_id = '27'
198 0.0008 0.00084495544433594
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 
199 0.0003 0.00031495094299316
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 
200 0.0003 0.00030803680419922
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
201 0.0002 0.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
202 0.0021 0.0021212100982666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1411' AND a.name = n.originalname
203 0.0016 0.0015780925750732
SELECT * FROM productoffers WHERE product_id = '1411' AND merchantid = 'A3P5ROKL5A1OLE'
204 0.0006 0.00056290626525879
SELECT * FROM productoffers
                WHERE product_id = '1411' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00053620338439941
SELECT * FROM productoffers
                WHERE product_id = 1411
                ORDER BY price ASC LIMIT 1
206 0.0020 0.0019969940185547
SELECT value FROM productattributes
                WHERE product_id = '1411'
                AND name = 'ListPriceAmount'
207 0.0009 0.00094795227050781
SELECT * FROM products WHERE id = '1411'
208 0.0019 0.0019199848175049
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 = '1411'
                GROUP BY o.product_id
209 0.0023 0.0023238658905029
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     = '1411'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
210 0.0005 0.00047516822814941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1411
211 0.0010 0.00095701217651367
SELECT value FROM productattributes WHERE product_id = '1411' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0030 0.0030350685119629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1411' AND a.name = n.originalname
213 0.0004 0.00037693977355957
SELECT * FROM productoffers WHERE product_id = '1411' AND merchantid = 'A3P5ROKL5A1OLE'
214 0.0008 0.00080680847167969
SELECT * FROM productoffers
                WHERE product_id = '1411' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0013 0.0012640953063965
SELECT * FROM productoffers
                WHERE product_id = 1411
                ORDER BY price ASC LIMIT 1
216 0.0011 0.0010719299316406
SELECT value FROM productattributes
                WHERE product_id = '1411'
                AND name = 'ListPriceAmount'
217 0.0005 0.00045585632324219
SELECT DISTINCT (name) FROM productoptions
218 0.0007 0.00070691108703613
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 1411))
219 0.0014 0.0014219284057617
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 1411
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
220 0.0132 0.013213872909546
SELECT * FROM translationsfilter
221 0.0005 0.00046586990356445
SELECT category_id FROM products_categories WHERE product_id = '1411' AND prod_type = 'amz'
222 0.0005 0.00051093101501465
SELECT parent_id FROM categories WHERE id = '27'
223 0.0003 0.00030899047851562
SELECT * FROM categories WHERE id = '27'
224 0.0008 0.00079011917114258
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
225 0.0003 0.00034093856811523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
226 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '27'
227 0.0008 0.0008089542388916
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 
228 0.0024 0.0023770332336426
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 
229 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
230 0.0004 0.00038504600524902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
231 0.0121 0.012064933776855
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
232 0.0141 0.014091014862061
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
233 0.0007 0.00069212913513184
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
234 0.0008 0.00082993507385254
SELECT * FROM pages WHERE id = 42
235 0.0008 0.00078606605529785
SELECT * FROM pages WHERE id = 55
236 0.0006 0.00056719779968262
SELECT * FROM pages WHERE id = 45
237 0.0011 0.0011088848114014
SELECT * FROM pages WHERE id = 51
238 0.0006 0.00056099891662598
SELECT * FROM pages WHERE id = 42
239 0.0005 0.00054502487182617
SELECT * FROM pages WHERE id = 37
240 0.0007 0.00068092346191406
SELECT * FROM pages WHERE id = 44
241 0.0023 0.0023050308227539
SELECT * FROM pages WHERE id = 53
242 0.0021 0.002079963684082
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
243 0.0025 0.0024819374084473
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:1596710738;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'
244 0.0035 0.0035450458526611
SELECT * FROM products WHERE id = 739
245 0.0020 0.0020339488983154
SELECT * FROM products WHERE id = 740
246 0.0033 0.003291130065918
SELECT * FROM products WHERE id = 745
247 0.0007 0.00070905685424805
SELECT * FROM products WHERE id = 751
248 0.0008 0.000823974609375
SELECT * FROM products WHERE id = 755
249 0.0019 0.0019450187683105
SELECT * FROM products WHERE id = 769
250 0.0003 0.00032782554626465
SELECT * FROM products WHERE id = '739'
251 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
252 0.0003 0.00028800964355469
SELECT * FROM product_image_select WHERE product_id = '739'
253 0.0002 0.00017714500427246
SELECT * FROM productcustomimages WHERE product_id = '739'
254 0.0335 0.033516883850098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
255 0.0010 0.0010459423065186
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
256 0.0004 0.00038790702819824
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '740'
259 0.0004 0.00039291381835938
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
260 0.0003 0.00028800964355469
SELECT * FROM product_image_select WHERE product_id = '740'
261 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '740'
262 0.0007 0.00067496299743652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
263 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'A3P5ROKL5A1OLE'
264 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0005 0.00049710273742676
SELECT * FROM products WHERE id = '745'
267 0.0004 0.00039196014404297
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
268 0.0003 0.00027799606323242
SELECT * FROM product_image_select WHERE product_id = '745'
269 0.0002 0.00024199485778809
SELECT * FROM productcustomimages WHERE product_id = '745'
270 0.0024 0.0023789405822754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
271 0.0016 0.0016119480133057
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
272 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0032 0.0031518936157227
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0004 0.00037884712219238
SELECT * FROM products WHERE id = '751'
275 0.0004 0.00042819976806641
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
276 0.0003 0.00027918815612793
SELECT * FROM product_image_select WHERE product_id = '751'
277 0.0035 0.0034980773925781
SELECT * FROM productcustomimages WHERE product_id = '751'
278 0.0006 0.00058984756469727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
279 0.0003 0.00030684471130371
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
280 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0028 0.0028409957885742
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0004 0.00036907196044922
SELECT * FROM products WHERE id = '755'
283 0.0019 0.0018680095672607
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
284 0.0003 0.00030803680419922
SELECT * FROM product_image_select WHERE product_id = '755'
285 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '755'
286 0.0053 0.0052869319915771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
287 0.0012 0.0012238025665283
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
288 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0014 0.0013630390167236
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0006 0.00059604644775391
SELECT * FROM products WHERE id = '769'
291 0.0014 0.0014200210571289
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
292 0.0009 0.00094079971313477
SELECT * FROM product_image_select WHERE product_id = '769'
293 0.0034 0.0034239292144775
SELECT * FROM productcustomimages WHERE product_id = '769'
294 0.0008 0.00079488754272461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
295 0.0004 0.00042915344238281
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
296 0.0004 0.00037789344787598
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0070 0.0069980621337891
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0175 0.017493009567261
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
299 0.0116 0.011628150939941
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
300 0.0207 0.020740032196045
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
301 0.0022 0.0022470951080322
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
302 0.0005 0.00047397613525391
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
303 0.0042 0.0041921138763428
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
304 0.0005 0.00046396255493164
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
305 0.0006 0.00059700012207031
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'