Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts

Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts
Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts Pink Queen Womens Loose Crew Neck Batwing Sleeve Patches Blouse Top T-Shirts (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-17 18:57:05 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


Pink Queen Womens Mid-Lenght O Neck Batwing Sleeve Bear Print Patches Blouse Top T-Shirts

Material:
Cotton blend

Wash suggestion:
Hand wash or machine wash/Cold water
Line dry, Low-heat iron
Do Not Bleach
Suitable for dry

Size Chart

S: Chest 37.80", Sleeve 29.13", Length 27.56";

M: Chest 40.16", Sleeve 29.53", Length 28.35";

L: Chest 42.52", Sleeve 29.92", Length 29.13";

XL: Chest 44.88", Sleeve 30.31", Length 29.92";

2XL: Chest 47.24", Sleeve 30.71", Length 30.71".


Style: mid-lenght t-shirt

Design: elbow patch & color block

Color: black / light grey / khaki

Package Content: 1 x Women T-Shirt

Product Features

Baggy loose fitting,Long sleeves,Casual and cozy top Two styles: no pockets and with two side pockets Great outfit to pair with leggings or jeans and boots in fall,winter Package Content: 1 x Mama bear shirts Garment Care: Recommended Hand Wash,No Bleach,Hang to dry

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 without tags

1 Day(s) 18 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

10 Day(s) 7 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

24 Day(s) 18 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

27 Day(s) 21 h(s)
Worldwide

N/A

No Returns

Buy it Now

New without tags

14 Day(s) 5 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

3 Day(s) 22 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

7 Day(s) 1 h(s)
Worldwide

N/A

No Returns

Buy it Now

New without tags

14 Day(s) 16 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

27 Day(s) 7 h(s)
Worldwide

N/A

No Returns

Buy it Now

New without tags

15 Day(s) 20 h(s)
Worldwide

N/A

No Returns

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

Wait! We have a something for you...

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

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


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2779200077057 253 0.1638 0


No Amazon API Requests Made.

Total time 1.2779200077057 seconds

Number Time From Start Name Description
1 0.19771003723145 Initialise Initialise FSB Function
2 0.19959688186646 App Controller Start Start of the App controller (called before the controller of every page)
3 0.21275687217712 Start of getCategoryListByGroup Function Before first category groups query
4 0.21306586265564 After initial query Before first category groups query
5 0.21306800842285 Get Category List for Group Before the call to getCategoryList function
6 0.21307301521301 Start of GetCategoryList function Start of the function
7 0.21308088302612 Before getting categories Query to get specific category list
8 0.21360397338867 After getting categories Query to get specific category list
9 0.21360492706299 Before getting category custom Before call to function getCategoryCustom
10 0.21972393989563 After getting category custom After call to function getCategoryCustom
11 0.21972703933716 Before getting category custom Before call to function getCategoryCustom
12 0.2242579460144 After getting category custom After call to function getCategoryCustom
13 0.22426199913025 Before getting category custom Before call to function getCategoryCustom
14 0.2283079624176 After getting category custom After call to function getCategoryCustom
15 0.22831201553345 Before getting category custom Before call to function getCategoryCustom
16 0.23147988319397 After getting category custom After call to function getCategoryCustom
17 0.2314829826355 Before getting category custom Before call to function getCategoryCustom
18 0.23689103126526 After getting category custom After call to function getCategoryCustom
19 0.23689603805542 Before getting category custom Before call to function getCategoryCustom
20 0.24043989181519 After getting category custom After call to function getCategoryCustom
21 0.24045085906982 Before getting category custom Before call to function getCategoryCustom
22 0.24580693244934 After getting category custom After call to function getCategoryCustom
23 0.24580883979797 Before getting category custom Before call to function getCategoryCustom
24 0.24811100959778 After getting category custom After call to function getCategoryCustom
25 0.24811291694641 Before getting category custom Before call to function getCategoryCustom
26 0.25041604042053 After getting category custom After call to function getCategoryCustom
27 0.25041890144348 End of GetCategoryList function End of the function
28 0.25042700767517 End of getCategoryListByGroup Function Before return()
29 0.30926895141602 App Controller End End of the App controller (called before the controller of every page)
30 0.3097779750824 Product Start Start of the product info controller
31 0.31121802330017 Cache file not found Starting get product details
32 0.32078504562378 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.76312303543091 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.76435685157776 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.2114078998566 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.2163410186768 Related products Start getting related products if enabled
37 1.2163419723511 Related Products Start Before the related products are found
38 1.2163429260254 Related Products Keywords Before the related product keywords are found
39 1.2163479328156 Create Keyword List Function Start of function
40 1.2165238857269 Create Keyword List Function After looping provided content - 33 keywords found
41 1.217798948288 Create Keyword List Function After looping initial keyword list - 32 keywords remaining
42 1.2178139686584 Create Keyword List Function After reducing keyword list
43 1.217973947525 Create Keyword List Function After selecting by scoring keywords
44 1.2179789543152 Create Keyword List Function After final loop of keywords
45 1.2179808616638 Related Products Keywords After the related product keywords are found
46 1.2288248538971 Related Products End After the related products are found
47 1.2379159927368 Product End End of the product info controller (Product Info)
48 1.2390749454498 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 1.2397298812866 Before Get Options Before the call to getOptions in the tpl class
50 1.2616448402405 After Get Options After the call to getOptions in the tpl class
51 1.2616889476776 App_after Controller End End of the App_after controller (called after the controller of every page)
52 1.2617118358612 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
53 1.2670078277588 Product Info: After Smarty Fetch After the product.tpl template is fetched
54 1.2670109272003 Product Info: Before Template Display Before the template is displayed
55 1.2779049873352 Product Info: After Template Display After the template is displayed
56 1.2779099941254 Finalizing debug Before the debug is output to the page.
57 1.2779200077057 End of App This is the end of the app logging, final timestamp


Query Debug - 253 Database Queries. Total time 0.1638 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00047683715820312
SELECT parameter, value FROM parameters
2 0.0003 0.00030612945556641
SELECT * FROM `bad_bots`
3 0.0002 0.00020003318786621
SET time_zone = 'Europe/London'
4 0.0004 0.00036001205444336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0005 0.00048089027404785
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00034403800964355
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0004 0.00036001205444336
SELECT id FROM pages WHERE pagename = 'pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t' LIMIT 1
8 0.0004 0.00039505958557129
SELECT id FROM products WHERE pagename = 'pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t' AND hidden = 0 LIMIT 1
9 0.0013 0.0013279914855957
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0101 0.010061025619507
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0003 0.00033903121948242
SELECT * FROM pages WHERE pagename = 'pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t'
12 0.0003 0.00028300285339355
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0005 0.00048589706420898
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0021 0.0020511150360107
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.0003 0.00032401084899902
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.0003 0.00031590461730957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0003 0.00031900405883789
SELECT id FROM categories WHERE parent_id = '26'
18 0.0017 0.0017030239105225
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.0003 0.00034499168395996
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.0003 0.00031113624572754
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.0003 0.00030279159545898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
23 0.0013 0.0012519359588623
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.0003 0.00033807754516602
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.0003 0.00027298927307129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '27'
27 0.0010 0.0009920597076416
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.0003 0.00032591819763184
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.0003 0.00032687187194824
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.0003 0.00027298927307129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0003 0.00029397010803223
SELECT * FROM categorygroups WHERE id = '1'
32 0.0009 0.00089001655578613
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.0003 0.00027704238891602
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.0003 0.00027084350585938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0003 0.0002899169921875
SELECT id FROM categories WHERE parent_id = '28'
36 0.0010 0.00098490715026855
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.0003 0.00030803680419922
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.0003 0.00031208992004395
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.0003 0.00027704238891602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0003 0.00028610229492188
SELECT * FROM categorygroups WHERE id = '1'
41 0.0004 0.00044894218444824
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.0003 0.00034499168395996
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.0003 0.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0003 0.00029301643371582
SELECT id FROM categories WHERE parent_id = '29'
45 0.0005 0.00049114227294922
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.0003 0.00029206275939941
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.0003 0.0003359317779541
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.0003 0.0002601146697998
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
50 0.0008 0.00081682205200195
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.0004 0.00038886070251465
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.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '30'
54 0.0024 0.0023598670959473
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.0003 0.00032711029052734
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.0003 0.00031685829162598
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.0003 0.00028395652770996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0003 0.0002739429473877
SELECT * FROM categorygroups WHERE id = '1'
59 0.0007 0.00070285797119141
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.0003 0.00033307075500488
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.0003 0.00027799606323242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '31'
63 0.0007 0.0006561279296875
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.0003 0.00028610229492188
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.0003 0.00030207633972168
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.0003 0.00027799606323242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0003 0.00026893615722656
SELECT * FROM categorygroups WHERE id = '1'
68 0.0007 0.00067996978759766
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.0003 0.00032711029052734
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.0024 0.0024080276489258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '32'
72 0.0005 0.00053787231445312
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.00021600723266602
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.00022602081298828
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0003 0.00033688545227051
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00037789344787598
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.00020408630371094
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.00023794174194336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00016188621520996
SELECT id FROM categories WHERE parent_id = '33'
81 0.0004 0.00042605400085449
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.0002 0.00024294853210449
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.00023412704467773
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.0001 0.00012707710266113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0002 0.00018715858459473
SELECT * FROM categorygroups WHERE id = '1'
86 0.0004 0.00037097930908203
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.00020480155944824
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.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '34'
90 0.0004 0.00042891502380371
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.00022578239440918
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.00020909309387207
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.00018787384033203
SELECT * FROM categorygroups WHERE id = '1'
95 0.0003 0.00025200843811035
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0003 0.00029492378234863
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.00033903121948242
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.0004 0.00043582916259766
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.00038814544677734
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0549 0.054883003234863
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.0005 0.00054192543029785
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0003 0.00032591819763184
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0004 0.00038504600524902
SELECT * FROM countryredirects WHERE id <> 1
104 0.0005 0.00052785873413086
SELECT * FROM products WHERE pagename = 'pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t'
105 0.0004 0.00037884712219238
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1702
106 0.0003 0.00031399726867676
SELECT * FROM manufacturers WHERE id = '0'
107 0.0003 0.00029516220092773
SELECT category_id FROM products_categories WHERE product_id = '1702'
108 0.0003 0.00028491020202637
SELECT * FROM categories WHERE id = '35'
109 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '1702' ORDER BY sortorder ASC
110 0.0004 0.0003972053527832
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1702' AND p.id = pi.product_id ORDER BY pi.sortorder
111 0.0003 0.00030207633972168
SELECT * FROM product_image_select WHERE product_id = '1702'
112 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '1702'
113 0.0003 0.00028610229492188
SELECT * FROM productfeeds WHERE product_id = '1702' ORDER BY item_date DESC
114 0.0005 0.00051403045654297
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1702' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
115 0.0003 0.00028586387634277
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1702' AND t.hidden = 0 AND display_product = 1
116 0.0003 0.00032997131347656
SELECT * FROM productamazoncontent WHERE product_id = '1702'
117 0.0004 0.00037813186645508
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 = '1702'
                GROUP BY o.product_id
118 0.0004 0.00036311149597168
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     = '1702'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
119 0.0002 0.00022196769714355
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1702
120 0.0011 0.0010569095611572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1702' AND a.name = n.originalname
121 0.0002 0.00023484230041504
SELECT * FROM productoffers WHERE product_id = '1702' AND merchantid = 'A3P5ROKL5A1OLE'
122 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '1702' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = 1702
                ORDER BY price ASC LIMIT 1
124 0.0002 0.00019097328186035
SELECT value FROM productattributes
                WHERE product_id = '1702'
                AND name = 'ListPriceAmount'
125 0.0002 0.00024080276489258
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 = '1702'
                GROUP BY o.product_id
126 0.0002 0.00023984909057617
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     = '1702'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0002 0.00022697448730469
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1702
128 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '1702' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0002 0.00023293495178223
SELECT * FROM products WHERE parent_id = '1702'
130 0.0003 0.00030279159545898
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
131 0.0003 0.0002899169921875
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
132 0.0001 0.00014781951904297
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
133 0.0003 0.0002899169921875
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
134 0.0004 0.00039005279541016
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=Pink+Queen+Womens+Loose+Crew+Neck+Batwing+Sleeve+Patches+Blouse+Top+T-Shirts&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.44234991073608', '31536e225775429033711fb44fd78c9b', 'https://store-uk.welovebears.club/pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t'
135 0.0004 0.00042486190795898
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
136 0.0003 0.00028395652770996
SELECT id FROM ebay_products WHERE itemid = '224046144918' 
137 0.0003 0.00027990341186523
SELECT id FROM ebay_products WHERE itemid = '263514734124' 
138 0.0003 0.00026893615722656
SELECT id FROM ebay_products WHERE itemid = '283839960213' 
139 0.0002 0.00024700164794922
SELECT id FROM ebay_products WHERE itemid = '124113079125' 
140 0.0003 0.0002589225769043
SELECT id FROM ebay_products WHERE itemid = '322341886391' 
141 0.0003 0.00025677680969238
SELECT id FROM ebay_products WHERE itemid = '133467678899' 
142 0.0003 0.00026106834411621
SELECT id FROM ebay_products WHERE itemid = '293655108701' 
143 0.0003 0.00025510787963867
SELECT id FROM ebay_products WHERE itemid = '133097156470' 
144 0.0002 0.00024604797363281
SELECT id FROM ebay_products WHERE itemid = '133489383490' 
145 0.0003 0.00025701522827148
SELECT id FROM ebay_products WHERE itemid = '273826221610' 
146 0.0005 0.00045990943908691
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=Pink+Queen+Womens&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.44705510139465', '31536e225775429033711fb44fd78c9b', 'https://store-uk.welovebears.club/pink-queen-womens-loose-crew-neck-batwing-sleeve-patches-blouse-top-t'
147 0.0035 0.0035009384155273
SELECT *, MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AND 1702 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
148 0.0006 0.00060081481933594
SELECT *, MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
149 0.0004 0.00042915344238281
SELECT *, MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('batwing sleeve patches' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0026 0.0025548934936523
SELECT *, MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AND 1702 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
151 0.0003 0.00030016899108887
SELECT *, MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
152 0.0003 0.00031304359436035
SELECT *, MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('queen womens loose' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
153 0.0017 0.0016939640045166
SELECT *, MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AND 1702 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
154 0.0004 0.00039315223693848
SELECT *, MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
155 0.0005 0.00045013427734375
SELECT *, MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('blouse top t-shirts' IN BOOLEAN MODE) AND 1702 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
156 0.0005 0.0004878044128418
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1702') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
157 0.0003 0.00032615661621094
SELECT id,asin FROM products WHERE parent_id = 1702
158 0.0003 0.00028204917907715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1702' ORDER BY timestamp DESC
159 0.0004 0.00035190582275391
SELECT category_id FROM products_categories WHERE product_id = '1702'
160 0.0003 0.00034594535827637
SELECT * FROM categories WHERE id = '35'
161 0.0025 0.0025091171264648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1702' AND a.name = n.originalname
162 0.0003 0.00031185150146484
SELECT * FROM productoffers WHERE product_id = '1702' AND merchantid = 'A3P5ROKL5A1OLE'
163 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = '1702' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0003 0.00029611587524414
SELECT * FROM productoffers
                WHERE product_id = 1702
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '1702'
                AND name = 'ListPriceAmount'
166 0.0003 0.00026202201843262
SELECT * FROM products WHERE id = '1702'
167 0.0003 0.0002591609954834
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 = '1702'
                GROUP BY o.product_id
168 0.0003 0.00025200843811035
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     = '1702'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0002 0.00023889541625977
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1702
170 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '1702' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0008 0.00084686279296875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1702' AND a.name = n.originalname
172 0.0002 0.00022196769714355
SELECT * FROM productoffers WHERE product_id = '1702' AND merchantid = 'A3P5ROKL5A1OLE'
173 0.0002 0.00024890899658203
SELECT * FROM productoffers
                WHERE product_id = '1702' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = 1702
                ORDER BY price ASC LIMIT 1
175 0.0002 0.00023412704467773
SELECT value FROM productattributes
                WHERE product_id = '1702'
                AND name = 'ListPriceAmount'
176 0.0002 0.00020790100097656
SELECT category_id FROM products_categories WHERE product_id = '1702' AND prod_type = 'amz'
177 0.0002 0.00018978118896484
SELECT parent_id FROM categories WHERE id = '35'
178 0.0002 0.00019598007202148
SELECT * FROM categories WHERE id = '35'
179 0.0002 0.00024199485778809
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
180 0.0002 0.00024795532226562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
181 0.0003 0.00025486946105957
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
182 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = 42
183 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = 55
184 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = 45
185 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = 51
186 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = 42
187 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = 37
188 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = 44
189 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = 53
190 0.0007 0.00074100494384766
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
191 0.0003 0.0002739429473877
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:1597331377;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"745|amazon\";i:2;s:10:\"755|amazon\";i:3;s:10:\"769|amazon\";i:4;s:11:\"1229|amazon\";i:5;s:11:\"1236|amazon\";}}' WHERE id = '244'
192 0.0002 0.00023412704467773
SELECT * FROM products WHERE id = 739
193 0.0002 0.00021815299987793
SELECT * FROM products WHERE id = 745
194 0.0003 0.0002589225769043
SELECT * FROM products WHERE id = 755
195 0.0003 0.00027799606323242
SELECT * FROM products WHERE id = 769
196 0.0002 0.00022506713867188
SELECT * FROM products WHERE id = 1229
197 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = 1236
198 0.0002 0.00021815299987793
SELECT * FROM products WHERE id = '739'
199 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
200 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '739'
201 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '739'
202 0.0006 0.00058698654174805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
203 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
204 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0002 0.00024580955505371
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0002 0.00024294853210449
SELECT * FROM products WHERE id = '745'
207 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
208 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '745'
209 0.0002 0.00020694732666016
SELECT * FROM productcustomimages WHERE product_id = '745'
210 0.0005 0.0005488395690918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
211 0.0002 0.00023984909057617
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
212 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0003 0.00032305717468262
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0002 0.00021982192993164
SELECT * FROM products WHERE id = '755'
215 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
216 0.0003 0.00025177001953125
SELECT * FROM product_image_select WHERE product_id = '755'
217 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '755'
218 0.0006 0.00057506561279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
219 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
220 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0002 0.00021505355834961
SELECT * FROM products WHERE id = '769'
223 0.0002 0.00023818016052246
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
224 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '769'
225 0.0002 0.00021600723266602
SELECT * FROM productcustomimages WHERE product_id = '769'
226 0.0004 0.00041890144348145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
227 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
228 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0002 0.00021791458129883
SELECT * FROM products WHERE id = '1229'
231 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
232 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '1229'
233 0.0002 0.00017094612121582
SELECT * FROM productcustomimages WHERE product_id = '1229'
234 0.0005 0.00052618980407715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
235 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
236 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0002 0.00023818016052246
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0002 0.00021505355834961
SELECT * FROM products WHERE id = '1236'
239 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '1236' ORDER BY sortorder ASC
240 0.0003 0.00025582313537598
SELECT * FROM product_image_select WHERE product_id = '1236'
241 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '1236'
242 0.0008 0.00083708763122559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1236' AND a.name = n.originalname
243 0.0005 0.00049018859863281
SELECT * FROM productoffers WHERE product_id = '1236' AND merchantid = 'A3P5ROKL5A1OLE'
244 0.0003 0.00030016899108887
SELECT * FROM productoffers
                WHERE product_id = '1236' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '1236' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
247 0.0004 0.0003509521484375
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
248 0.0007 0.00071811676025391
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
249 0.0003 0.00034999847412109
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
250 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
251 0.0003 0.00029611587524414
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
252 0.0006 0.00061511993408203
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
253 0.0003 0.00034403800964355
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'