Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Animals - Advanced Graphics Life Size Cardboard Standup
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Animals - Advanced Graphics Life Size Cardboard Standup

Animals - Advanced Graphics Life Size Cardboard Standup
Animals - Advanced Graphics Life Size Cardboard Standup Animals - Advanced Graphics Life Size Cardboard Standup Animals - Advanced Graphics Life Size Cardboard Standup Animals - Advanced Graphics Life Size Cardboard Standup Animals - Advanced Graphics Life Size Cardboard Standup (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-16 00:59:49 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

How to Set Up Your Standup: 1. Unfold standup and easel.  Lay standup face down on a clean, flat surface. 2. Fold easel up along the long vertical crease that runs the length of the standup. 3. Lift upper and lower tab to lock easel in place. 4. Attach upper tab to top of easel. About Advanced Graphics:  Since 1984, Advanced Graphics has been committed to producing the highest quality Cardboard Standups and Custom Prints in the world. We are the worldwide industry leader in the licensing and distribution of Cardboard Standups. We are also the #1 source for Licensed and Custom cardboard standups in the industry. Our goal is to provide the highest quality prints to our customers. We put our customers first and will continue to provide the best customer service to those who keep us in business.

Product Features

HUGE SELECTION: Perfect For Children's Birthday Parties, Special Events, School, Corporate Events, Awards Programs, Fairs, Festivals, Galas, Fundraisers And Green/Eco Events. WOW: Make Any Special Event Or Party Spectacular With The Coolest Decorations. Wow Your Loved Ones With A Unique Gift That They Will Remember For Years! Display As A Prop At Trade Shows, Performances, Plays, Holidays And More. MADE IN AMERICA: Proudly Manufactured In The USA. HIGH QUALITY: Advanced Graphics Produces The Highest Quality Cardboard Standups And Custom Prints In The World. 100% SATISFACTION GUARANTEE: We Put Our Customers First And Will Continue To Provide The Best Customer Service To Those Who Keep Us In Business.

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) 15 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

27 Day(s) 13 h(s)
Worldwide

N/A

No Returns

Buy it Now

New other (see details)

19 Day(s) 16 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
0.92302894592285 336 0.2236 0


No Amazon API Requests Made.

Total time 0.92302894592285 seconds

Number Time From Start Name Description
1 0.21043586730957 Initialise Initialise FSB Function
2 0.21211385726929 App Controller Start Start of the App controller (called before the controller of every page)
3 0.22185802459717 Start of getCategoryListByGroup Function Before first category groups query
4 0.22236204147339 After initial query Before first category groups query
5 0.22236299514771 Get Category List for Group Before the call to getCategoryList function
6 0.22236585617065 Start of GetCategoryList function Start of the function
7 0.22236895561218 Before getting categories Query to get specific category list
8 0.2228798866272 After getting categories Query to get specific category list
9 0.22288084030151 Before getting category custom Before call to function getCategoryCustom
10 0.22945499420166 After getting category custom After call to function getCategoryCustom
11 0.22945785522461 Before getting category custom Before call to function getCategoryCustom
12 0.23203182220459 After getting category custom After call to function getCategoryCustom
13 0.23203301429749 Before getting category custom Before call to function getCategoryCustom
14 0.23468589782715 After getting category custom After call to function getCategoryCustom
15 0.23468804359436 Before getting category custom Before call to function getCategoryCustom
16 0.23686981201172 After getting category custom After call to function getCategoryCustom
17 0.23687100410461 Before getting category custom Before call to function getCategoryCustom
18 0.23951601982117 After getting category custom After call to function getCategoryCustom
19 0.2395179271698 Before getting category custom Before call to function getCategoryCustom
20 0.24186086654663 After getting category custom After call to function getCategoryCustom
21 0.24186396598816 Before getting category custom Before call to function getCategoryCustom
22 0.24431586265564 After getting category custom After call to function getCategoryCustom
23 0.24431800842285 Before getting category custom Before call to function getCategoryCustom
24 0.24669003486633 After getting category custom After call to function getCategoryCustom
25 0.24669289588928 Before getting category custom Before call to function getCategoryCustom
26 0.24892592430115 After getting category custom After call to function getCategoryCustom
27 0.24892902374268 End of GetCategoryList function End of the function
28 0.24893498420715 End of getCategoryListByGroup Function Before return()
29 0.3065710067749 App Controller End End of the App controller (called before the controller of every page)
30 0.30731081962585 Product Start Start of the product info controller
31 0.30852890014648 Cache file not found Starting get product details
32 0.32669401168823 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.78462696075439 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.78949403762817 Related products Start getting related products if enabled
35 0.78949594497681 Related Products Start Before the related products are found
36 0.78949785232544 Related Products Keywords Before the related product keywords are found
37 0.78950691223145 Create Keyword List Function Start of function
38 0.78971791267395 Create Keyword List Function After looping provided content - 18 keywords found
39 0.79192781448364 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
40 0.79194784164429 Create Keyword List Function After reducing keyword list
41 0.79208183288574 Create Keyword List Function After selecting by scoring keywords
42 0.7920880317688 Create Keyword List Function After final loop of keywords
43 0.79209089279175 Related Products Keywords After the related product keywords are found
44 0.80084800720215 Related Products End After the related products are found
45 0.85671281814575 Product End End of the product info controller (Product Info)
46 0.85880494117737 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.86630988121033 Before Get Options Before the call to getOptions in the tpl class
48 0.90272402763367 After Get Options After the call to getOptions in the tpl class
49 0.90279293060303 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.90282988548279 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.91030192375183 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.91030788421631 Product Info: Before Template Display Before the template is displayed
53 0.92300391197205 Product Info: After Template Display After the template is displayed
54 0.92301201820374 Finalizing debug Before the debug is output to the page.
55 0.92302799224854 End of App This is the end of the app logging, final timestamp


Query Debug - 336 Database Queries. Total time 0.2236 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.0003819465637207
SELECT parameter, value FROM parameters
2 0.0012 0.0012149810791016
SELECT * FROM `bad_bots`
3 0.0002 0.00021910667419434
SET time_zone = 'Europe/London'
4 0.0011 0.0011022090911865
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00083804130554199
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0002 0.00022387504577637
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0005 0.00051307678222656
SELECT id FROM pages WHERE pagename = 'animals-advanced-graphics-life-size-cardboard-standup' LIMIT 1
8 0.0005 0.00050902366638184
SELECT id FROM products WHERE pagename = 'animals-advanced-graphics-life-size-cardboard-standup' AND hidden = 0 LIMIT 1
9 0.0009 0.0008699893951416
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0078 0.0078480243682861
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0003 0.0002598762512207
SELECT * FROM pages WHERE pagename = 'animals-advanced-graphics-life-size-cardboard-standup'
12 0.0005 0.00049304962158203
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0005 0.00048208236694336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0023 0.0022811889648438
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
15 0.0006 0.00063085556030273
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
16 0.0004 0.00039100646972656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '26'
18 0.0014 0.0014331340789795
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 
19 0.0005 0.00048685073852539
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 
20 0.0004 0.00041007995605469
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
21 0.0004 0.00036787986755371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
23 0.0005 0.00052404403686523
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
24 0.0002 0.00020813941955566
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
25 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '27'
27 0.0006 0.0005500316619873
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 
28 0.0002 0.00022697448730469
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 
29 0.0002 0.00021219253540039
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
30 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0002 0.00018787384033203
SELECT * FROM categorygroups WHERE id = '1'
32 0.0005 0.00052714347839355
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
33 0.0002 0.00020503997802734
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
34 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '28'
36 0.0006 0.00055193901062012
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 
37 0.0002 0.00022697448730469
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 
38 0.0002 0.00023603439331055
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
39 0.0002 0.0002140998840332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0002 0.00022292137145996
SELECT * FROM categorygroups WHERE id = '1'
41 0.0003 0.00029802322387695
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
42 0.0002 0.00023794174194336
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
43 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '29'
45 0.0003 0.0003049373626709
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 
46 0.0002 0.00020790100097656
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 
47 0.0002 0.00021886825561523
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
48 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00020289421081543
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00053310394287109
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
51 0.0002 0.00022792816162109
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
52 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '30'
54 0.0006 0.00056099891662598
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 
55 0.0002 0.00020599365234375
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 
56 0.0002 0.00022196769714355
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
57 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0002 0.00021100044250488
SELECT * FROM categorygroups WHERE id = '1'
59 0.0004 0.00038719177246094
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
60 0.0002 0.00022101402282715
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
61 0.0002 0.00019383430480957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '31'
63 0.0004 0.0003972053527832
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 
64 0.0002 0.00021195411682129
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 
65 0.0002 0.00021982192993164
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
66 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
68 0.0004 0.00039196014404297
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
69 0.0002 0.00022697448730469
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 32
70 0.0002 0.00020194053649902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '32'
72 0.0005 0.0004580020904541
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 
73 0.0002 0.00022220611572266
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 
74 0.0002 0.00022101402282715
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
75 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0002 0.00021004676818848
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00040507316589355
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
78 0.0002 0.00022387504577637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
79 0.0002 0.0002140998840332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '33'
81 0.0004 0.0003960132598877
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 
82 0.0003 0.00026893615722656
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 
83 0.0002 0.00020194053649902
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
84 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0002 0.00018620491027832
SELECT * FROM categorygroups WHERE id = '1'
86 0.0004 0.00036191940307617
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
87 0.0002 0.00021505355834961
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 34
88 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '34'
90 0.0004 0.00039196014404297
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 
91 0.0002 0.00018596649169922
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 
92 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 (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
93 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.00019001960754395
SELECT * FROM categorygroups WHERE id = '1'
95 0.0008 0.00078392028808594
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0006 0.00056791305541992
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.00030994415283203
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
98 0.0005 0.00046992301940918
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.0003960132598877
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0523 0.052345991134644
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.108.191') >= INET_ATON(ip_start) AND INET_ATON('18.207.108.191') <= INET_ATON(ip_end)
101 0.0010 0.0010089874267578
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0005 0.00049996376037598
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0002 0.00024795532226562
SELECT * FROM countryredirects WHERE id <> 1
104 0.0005 0.00046896934509277
SELECT * FROM products WHERE pagename = 'animals-advanced-graphics-life-size-cardboard-standup'
105 0.0003 0.00032687187194824
UPDATE products SET viewcount = viewcount + 1 WHERE id = 898
106 0.0003 0.00027918815612793
SELECT * FROM manufacturers WHERE id = '199'
107 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '199'
108 0.0007 0.0007021427154541
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '199' LIMIT 1
109 0.0009 0.00088810920715332
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '199' ORDER BY RAND() LIMIT 1
110 0.0003 0.00030088424682617
SELECT * FROM productimages WHERE product_id = '898' ORDER BY sortorder ASC
111 0.0003 0.00027990341186523
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '199'
112 0.0003 0.00033998489379883
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '199'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
113 0.0002 0.0002140998840332
SELECT * FROM manufacturerimages WHERE manufacturer_id = '199'
114 0.0002 0.00021100044250488
SELECT category_id FROM products_categories WHERE product_id = '898'
115 0.0002 0.00018310546875
SELECT * FROM categories WHERE id = '36'
116 0.0002 0.00023484230041504
SELECT * FROM productimages WHERE product_id = '898' ORDER BY sortorder ASC
117 0.0020 0.0020499229431152
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '898' AND p.id = pi.product_id ORDER BY pi.sortorder
118 0.0008 0.0007631778717041
SELECT * FROM product_image_select WHERE product_id = '898'
119 0.0007 0.00066804885864258
SELECT * FROM productcustomimages WHERE product_id = '898'
120 0.0006 0.00064301490783691
SELECT * FROM productfeeds WHERE product_id = '898' ORDER BY item_date DESC
121 0.0008 0.00084710121154785
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '898' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
122 0.0006 0.00062417984008789
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '898' AND t.hidden = 0 AND display_product = 1
123 0.0005 0.00052905082702637
SELECT * FROM productamazoncontent WHERE product_id = '898'
124 0.0007 0.00065207481384277
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 = '898'
                GROUP BY o.product_id
125 0.0011 0.0010521411895752
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     = '898'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
126 0.0005 0.00046586990356445
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 898
127 0.0007 0.00068998336791992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '898' AND a.name = n.originalname
128 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '898' AND merchantid = 'A3P5ROKL5A1OLE'
129 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '898' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = 898
                ORDER BY price ASC LIMIT 1
131 0.0002 0.00020194053649902
SELECT value FROM productattributes
                WHERE product_id = '898'
                AND name = 'ListPriceAmount'
132 0.0005 0.0005040168762207
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 = '898'
                GROUP BY o.product_id
133 0.0006 0.0005948543548584
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     = '898'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0004 0.00042319297790527
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 898
135 0.0002 0.00022411346435547
SELECT value FROM productattributes WHERE product_id = '898' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00058984756469727
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '898'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
137 0.0003 0.00026106834411621
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
138 0.0002 0.00024104118347168
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
139 0.0004 0.00035810470581055
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
140 0.0003 0.00027799606323242
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
141 0.0012 0.0011889934539795
SELECT id FROM ebay_products WHERE itemid = '124256040417' 
142 0.0003 0.00027608871459961
SELECT id FROM ebay_products WHERE itemid = '121647053863' 
143 0.0003 0.00028896331787109
SELECT id FROM ebay_products WHERE itemid = '191936564991' 
144 0.0015 0.0015149116516113
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=Animals+-+Advanced+Graphics+Life+Size+Cardboard+Standup&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.4579439163208', '1bfc64dd4c33f825800bb95887245c3d', 'https://store-uk.welovebears.club/animals-advanced-graphics-life-size-cardboard-standup'
145 0.0041 0.0041000843048096
SELECT *, MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AND 898 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
146 0.0004 0.00039100646972656
SELECT *, MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AND 898 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
147 0.0003 0.00031495094299316
SELECT *, MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('animals advanced graphics' IN BOOLEAN MODE) AND 898 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
148 0.0024 0.0023510456085205
SELECT *, MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AND 898 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
149 0.0004 0.0003969669342041
SELECT *, MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AND 898 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0005 0.00046706199645996
SELECT *, MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('size cardboard standup' IN BOOLEAN MODE) AND 898 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
151 0.0006 0.00061988830566406
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '898') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
152 0.0006 0.00058913230895996
SELECT id,asin FROM products WHERE parent_id = 898
153 0.0004 0.00039291381835938
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 899
154 0.0006 0.00063014030456543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 899
155 0.0004 0.00040292739868164
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 901
156 0.0005 0.00053811073303223
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 901
157 0.0004 0.00036811828613281
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 902
158 0.0005 0.00053119659423828
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 902
159 0.0004 0.00042605400085449
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 903
160 0.0007 0.00069308280944824
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 903
161 0.0004 0.00035691261291504
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 904
162 0.0006 0.00056600570678711
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 904
163 0.0003 0.00034308433532715
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 905
164 0.0005 0.00053620338439941
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 905
165 0.0004 0.00040102005004883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 906
166 0.0005 0.00045204162597656
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 906
167 0.0004 0.00041818618774414
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 907
168 0.0004 0.00036287307739258
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 907
169 0.0003 0.0003349781036377
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 908
170 0.0004 0.00037908554077148
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 908
171 0.0003 0.00034999847412109
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 910
172 0.0004 0.00036311149597168
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 910
173 0.0004 0.00035619735717773
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 911
174 0.0003 0.00032997131347656
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 911
175 0.0003 0.00030183792114258
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 913
176 0.0003 0.00034189224243164
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 913
177 0.0004 0.0003511905670166
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 914
178 0.0005 0.00046896934509277
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 914
179 0.0003 0.0003349781036377
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 916
180 0.0004 0.00037097930908203
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 916
181 0.0003 0.00033402442932129
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 917
182 0.0004 0.0003809928894043
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 917
183 0.0003 0.00030303001403809
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 919
184 0.0004 0.00037598609924316
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 919
185 0.0003 0.00034904479980469
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 920
186 0.0004 0.00042605400085449
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 920
187 0.0003 0.0003209114074707
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 921
188 0.0005 0.00053286552429199
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 921
189 0.0004 0.00035500526428223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 922
190 0.0005 0.00052905082702637
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 922
191 0.0004 0.00037097930908203
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 923
192 0.0003 0.00033903121948242
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 923
193 0.0003 0.0003209114074707
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 924
194 0.0004 0.00041317939758301
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 924
195 0.0004 0.00036907196044922
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 925
196 0.0003 0.00031900405883789
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 925
197 0.0003 0.00029897689819336
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 926
198 0.0004 0.00044393539428711
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 926
199 0.0004 0.0003969669342041
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 927
200 0.0006 0.00056004524230957
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 927
201 0.0003 0.00033092498779297
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 929
202 0.0005 0.00050020217895508
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 929
203 0.0004 0.00036883354187012
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 930
204 0.0005 0.00046706199645996
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 930
205 0.0005 0.00053501129150391
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 931
206 0.0011 0.0010738372802734
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 931
207 0.0006 0.00058388710021973
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 932
208 0.0004 0.00038695335388184
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 932
209 0.0003 0.00029802322387695
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 933
210 0.0005 0.00048303604125977
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 933
211 0.0005 0.00054001808166504
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 934
212 0.0007 0.00066685676574707
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 934
213 0.0006 0.00057387351989746
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 936
214 0.0011 0.0010929107666016
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 936
215 0.0003 0.0002892017364502
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 937
216 0.0007 0.0007331371307373
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 937
217 0.0004 0.00038290023803711
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 938
218 0.0007 0.00067710876464844
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 938
219 0.0006 0.00056314468383789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 939
220 0.0007 0.00065398216247559
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 939
221 0.0009 0.00086498260498047
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 940
222 0.0008 0.00076389312744141
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 940
223 0.0006 0.00057482719421387
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1170
224 0.0005 0.00054597854614258
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1170
225 0.0004 0.0003809928894043
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1169
226 0.0005 0.00046896934509277
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1169
227 0.0004 0.00040292739868164
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1171
228 0.0007 0.00069403648376465
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1171
229 0.0003 0.00025081634521484
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1172
230 0.0004 0.00040912628173828
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1172
231 0.0008 0.00082182884216309
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1173
232 0.0007 0.00073099136352539
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1173
233 0.0003 0.00027990341186523
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1210
234 0.0003 0.00034904479980469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1210
235 0.0003 0.00029993057250977
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1211
236 0.0004 0.00042510032653809
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1211
237 0.0010 0.00095987319946289
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '898' ORDER BY timestamp DESC
238 0.0003 0.00033998489379883
SELECT category_id FROM products_categories WHERE product_id = '898'
239 0.0003 0.00033807754516602
SELECT * FROM categories WHERE id = '36'
240 0.0010 0.00099492073059082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '898' AND a.name = n.originalname
241 0.0004 0.00035309791564941
SELECT * FROM productoffers WHERE product_id = '898' AND merchantid = 'A3P5ROKL5A1OLE'
242 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '898' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = 898
                ORDER BY price ASC LIMIT 1
244 0.0002 0.00023603439331055
SELECT value FROM productattributes
                WHERE product_id = '898'
                AND name = 'ListPriceAmount'
245 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = '898'
246 0.0008 0.00077199935913086
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 = '898'
                GROUP BY o.product_id
247 0.0011 0.0010650157928467
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     = '898'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
248 0.0008 0.00077104568481445
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 898
249 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '898' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0010 0.00096487998962402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '898' AND a.name = n.originalname
251 0.0004 0.00040912628173828
SELECT * FROM productoffers WHERE product_id = '898' AND merchantid = 'A3P5ROKL5A1OLE'
252 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '898' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = 898
                ORDER BY price ASC LIMIT 1
254 0.0003 0.00028514862060547
SELECT value FROM productattributes
                WHERE product_id = '898'
                AND name = 'ListPriceAmount'
255 0.0004 0.00042390823364258
SELECT DISTINCT (name) FROM productoptions
256 0.0012 0.0011839866638184
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 898))
257 0.0011 0.0010850429534912
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 898
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
258 0.0005 0.00052285194396973
SELECT * FROM translationsfilter
259 0.0009 0.00092887878417969
SELECT category_id FROM products_categories WHERE product_id = '898' AND prod_type = 'amz'
260 0.0003 0.00028491020202637
SELECT parent_id FROM categories WHERE id = '36'
261 0.0004 0.00041103363037109
SELECT * FROM categories WHERE id = '36'
262 0.0011 0.001121997833252
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
263 0.0071 0.0070979595184326
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
264 0.0003 0.00026488304138184
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
265 0.0003 0.00032401084899902
SELECT * FROM pages WHERE id = 42
266 0.0007 0.00068092346191406
SELECT * FROM pages WHERE id = 55
267 0.0003 0.00034809112548828
SELECT * FROM pages WHERE id = 45
268 0.0004 0.00035691261291504
SELECT * FROM pages WHERE id = 51
269 0.0004 0.00035905838012695
SELECT * FROM pages WHERE id = 42
270 0.0003 0.00029397010803223
SELECT * FROM pages WHERE id = 37
271 0.0004 0.00044512748718262
SELECT * FROM pages WHERE id = 44
272 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = 53
273 0.0018 0.001788854598999
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
274 0.0004 0.00036406517028809
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:1597329400;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"745|amazon\";i:2;s:10:\"751|amazon\";i:3;s:10:\"755|amazon\";i:4;s:10:\"769|amazon\";i:5;s:11:\"1229|amazon\";}}' WHERE id = '244'
275 0.0004 0.00037693977355957
SELECT * FROM products WHERE id = 739
276 0.0003 0.00031900405883789
SELECT * FROM products WHERE id = 745
277 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = 751
278 0.0004 0.00038790702819824
SELECT * FROM products WHERE id = 755
279 0.0004 0.00036716461181641
SELECT * FROM products WHERE id = 769
280 0.0003 0.00033092498779297
SELECT * FROM products WHERE id = 1229
281 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = '739'
282 0.0004 0.00038886070251465
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
283 0.0004 0.00037598609924316
SELECT * FROM product_image_select WHERE product_id = '739'
284 0.0003 0.0003049373626709
SELECT * FROM productcustomimages WHERE product_id = '739'
285 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
286 0.0004 0.00039100646972656
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
287 0.0003 0.00028800964355469
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0004 0.00038480758666992
SELECT * FROM products WHERE id = '745'
290 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
291 0.0004 0.00037717819213867
SELECT * FROM product_image_select WHERE product_id = '745'
292 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '745'
293 0.0011 0.0010941028594971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
294 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
295 0.0004 0.00041484832763672
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0004 0.00037693977355957
SELECT * FROM products WHERE id = '751'
298 0.0005 0.00047993659973145
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
299 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '751'
300 0.0002 0.0002448558807373
SELECT * FROM productcustomimages WHERE product_id = '751'
301 0.0004 0.00044703483581543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
302 0.0004 0.00036001205444336
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
303 0.0004 0.00036787986755371
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0004 0.0003819465637207
SELECT * FROM products WHERE id = '755'
306 0.0004 0.00035905838012695
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
307 0.0003 0.00028109550476074
SELECT * FROM product_image_select WHERE product_id = '755'
308 0.0002 0.00015997886657715
SELECT * FROM productcustomimages WHERE product_id = '755'
309 0.0012 0.0012431144714355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
310 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
311 0.0004 0.00036096572875977
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0003 0.00029206275939941
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0002 0.00024700164794922
SELECT * FROM products WHERE id = '769'
314 0.0002 0.00023388862609863
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
315 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '769'
316 0.0003 0.00025606155395508
SELECT * FROM productcustomimages WHERE product_id = '769'
317 0.0008 0.00075507164001465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
318 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
319 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0002 0.00023508071899414
SELECT * FROM products WHERE id = '1229'
322 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
323 0.0002 0.00020217895507812
SELECT * FROM product_image_select WHERE product_id = '1229'
324 0.0002 0.00018811225891113
SELECT * FROM productcustomimages WHERE product_id = '1229'
325 0.0016 0.0015799999237061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
326 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
327 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0013 0.0013301372528076
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
330 0.0006 0.00061702728271484
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
331 0.0019 0.0019359588623047
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
332 0.0012 0.0012350082397461
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
333 0.0008 0.00078010559082031
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
334 0.0006 0.00064492225646973
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
335 0.0005 0.00053691864013672
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
336 0.0005 0.00051593780517578
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'