Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad

Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad
Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad Papa Bear Tshirt, Mama Bear Shirt, Matching Family Shirt Mom Dad (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-08-03 21:35:31 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

Matching gift set for man and woman. Click on our brand name above the title to see our other shirts and shirt sets including bodysuits and toddler tee designs.
  • Men's Shirt Dimensions
  • Please allow 1" tolerance on length and width.
  • Mens Small: Length 27" - Width 18"
  • Mens Medium: Length 28" - Width 20"
  • Mens Large: Length 29" - Width 22"
  • Mens XL: Length 30" - Width 24"
  • Mens 2XL: Length 31" - Width 26"


  • Women's Shirt Dimensions
  • Please allow 1" tolerance on length and width.
  • Womens Small: Length 25.5" - Width 17.25"
  • Womens Medium: Length 26" - Width 19.25"
  • Womens Large: Length 27" - Width 21.25"
  • Womens XL: Length 28" - Width 23.25"
  • Womens 2XL: Length 28.5" - Width 25.25"

Product Features

Amazon size chart is not specific to our brand. Please see Description for dimensions on t-shirts Screen printed design on a Cotton shirt for comfort and softness. Gift Set Includes 1 T-shirt. Black T-shirts are 100% cotton. Heather Gray shirts are 65/35% cotton-poly blend. The graphic design is a registered copyrighted design. Infringing companies will be prosecuted.

Product Tags

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

Write a Review

The Best Products on eBay

Buy it Now

New with tags

20 Day(s) 6 h(s)
Worldwide

N/A

No Returns

Buy it Now

New without tags

9 Day(s) 6 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

2 Day(s) 12 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

22 Day(s) 1 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.85337805747986 267 0.1287 0


No Amazon API Requests Made.

Total time 0.85337805747986 seconds

Number Time From Start Name Description
1 0.17754602432251 Initialise Initialise FSB Function
2 0.1801061630249 App Controller Start Start of the App controller (called before the controller of every page)
3 0.18795299530029 Start of getCategoryListByGroup Function Before first category groups query
4 0.18817400932312 After initial query Before first category groups query
5 0.18817520141602 Get Category List for Group Before the call to getCategoryList function
6 0.18817710876465 Start of GetCategoryList function Start of the function
7 0.18818020820618 Before getting categories Query to get specific category list
8 0.18868803977966 After getting categories Query to get specific category list
9 0.18868899345398 Before getting category custom Before call to function getCategoryCustom
10 0.1962890625 After getting category custom After call to function getCategoryCustom
11 0.19629120826721 Before getting category custom Before call to function getCategoryCustom
12 0.19864702224731 After getting category custom After call to function getCategoryCustom
13 0.19864821434021 Before getting category custom Before call to function getCategoryCustom
14 0.20095109939575 After getting category custom After call to function getCategoryCustom
15 0.20095205307007 Before getting category custom Before call to function getCategoryCustom
16 0.20269203186035 After getting category custom After call to function getCategoryCustom
17 0.20269322395325 Before getting category custom Before call to function getCategoryCustom
18 0.20499205589294 After getting category custom After call to function getCategoryCustom
19 0.20499300956726 Before getting category custom Before call to function getCategoryCustom
20 0.20701003074646 After getting category custom After call to function getCategoryCustom
21 0.20701122283936 Before getting category custom Before call to function getCategoryCustom
22 0.20902919769287 After getting category custom After call to function getCategoryCustom
23 0.20903015136719 Before getting category custom Before call to function getCategoryCustom
24 0.21097612380981 After getting category custom After call to function getCategoryCustom
25 0.21097612380981 Before getting category custom Before call to function getCategoryCustom
26 0.21300220489502 After getting category custom After call to function getCategoryCustom
27 0.21300315856934 End of GetCategoryList function End of the function
28 0.21300601959229 End of getCategoryListByGroup Function Before return()
29 0.26301717758179 App Controller End End of the App controller (called before the controller of every page)
30 0.2634961605072 Product Start Start of the product info controller
31 0.26442313194275 Cache file not found Starting get product details
32 0.27502918243408 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.79366612434387 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.79571914672852 Related products Start getting related products if enabled
35 0.79571914672852 Related Products Start Before the related products are found
36 0.79572010040283 Related Products Keywords Before the related product keywords are found
37 0.79572510719299 Create Keyword List Function Start of function
38 0.79583311080933 Create Keyword List Function After looping provided content - 28 keywords found
39 0.79645419120789 Create Keyword List Function After looping initial keyword list - 26 keywords remaining
40 0.79646515846252 Create Keyword List Function After reducing keyword list
41 0.79652810096741 Create Keyword List Function After selecting by scoring keywords
42 0.79653120040894 Create Keyword List Function After final loop of keywords
43 0.79653215408325 Related Products Keywords After the related product keywords are found
44 0.80605220794678 Related Products End After the related products are found
45 0.81090211868286 Product End End of the product info controller (Product Info)
46 0.81152820587158 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.81197905540466 Before Get Options Before the call to getOptions in the tpl class
48 0.82982110977173 After Get Options After the call to getOptions in the tpl class
49 0.82991099357605 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.82993221282959 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.83554410934448 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.83554720878601 Product Info: Before Template Display Before the template is displayed
53 0.85334801673889 Product Info: After Template Display After the template is displayed
54 0.85335922241211 Finalizing debug Before the debug is output to the page.
55 0.85337805747986 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 0.1287 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00049996376037598
SELECT parameter, value FROM parameters
2 0.0003 0.00028395652770996
SELECT * FROM `bad_bots`
3 0.0002 0.00020694732666016
SET time_zone = 'Europe/London'
4 0.0002 0.00024199485778809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0003 0.00027918815612793
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0002 0.00020909309387207
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0002 0.00022506713867188
SELECT id FROM pages WHERE pagename = 'papa-bear-tshirt-mama-bear-shirt-matching-family-shirt-mom-dad' LIMIT 1
8 0.0018 0.0018410682678223
SELECT id FROM products WHERE pagename = 'papa-bear-tshirt-mama-bear-shirt-matching-family-shirt-mom-dad' AND hidden = 0 LIMIT 1
9 0.0006 0.00059294700622559
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0064 0.0064120292663574
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0002 0.00022602081298828
SELECT * FROM pages WHERE pagename = 'papa-bear-tshirt-mama-bear-shirt-matching-family-shirt-mom-dad'
12 0.0002 0.00021004676818848
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0005 0.00048303604125977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0028 0.0027661323547363
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.00032615661621094
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.0002 0.00024795532226562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '26'
18 0.0028 0.0028278827667236
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.00026798248291016
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.00033307075500488
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.00025010108947754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0002 0.00024104118347168
SELECT * FROM categorygroups WHERE id = '1'
23 0.0006 0.00058984756469727
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.00018715858459473
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.00015902519226074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '27'
27 0.0005 0.0005040168762207
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.00017094612121582
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.00018000602722168
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0002 0.00017309188842773
SELECT * FROM categorygroups WHERE id = '1'
32 0.0005 0.00048089027404785
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.00018000602722168
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.00015687942504883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '28'
36 0.0005 0.00049519538879395
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.00019407272338867
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.0002129077911377
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
41 0.0002 0.00023698806762695
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.00018000602722168
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.00015687942504883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00017380714416504
SELECT id FROM categories WHERE parent_id = '29'
45 0.0002 0.00024914741516113
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.0001680850982666
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.00017809867858887
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.00015878677368164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00049185752868652
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.00020408630371094
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.00020813941955566
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '30'
54 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 (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
55 0.0002 0.00017309188842773
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.00020599365234375
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
59 0.0003 0.0003349781036377
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.00018000602722168
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.00018501281738281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '31'
63 0.0004 0.00036311149597168
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.00019311904907227
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.00020313262939453
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
68 0.0003 0.00034499168395996
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.00018405914306641
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.00015711784362793
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.0001671314239502
SELECT id FROM categories WHERE parent_id = '32'
72 0.0004 0.00035619735717773
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.00017690658569336
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.00021100044250488
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0002 0.00018811225891113
SELECT * FROM categorygroups WHERE id = '1'
77 0.0003 0.00033092498779297
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.00018095970153809
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.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00016880035400391
SELECT id FROM categories WHERE parent_id = '33'
81 0.0003 0.00034308433532715
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.00016999244689941
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.0001838207244873
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.00015616416931152
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
86 0.0003 0.00032591819763184
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.00017809867858887
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.00018596649169922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '34'
90 0.0004 0.00036811828613281
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
91 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (34)
				  AND p.disabled = 0 
92 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 (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
93 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
95 0.0002 0.00021982192993164
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0002 0.00024008750915527
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.0002589225769043
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.00045108795166016
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.00040793418884277
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0468 0.046758890151978
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.0004 0.00039410591125488
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0003 0.00025200843811035
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0002 0.00020909309387207
SELECT * FROM countryredirects WHERE id <> 1
104 0.0003 0.00032305717468262
SELECT * FROM products WHERE pagename = 'papa-bear-tshirt-mama-bear-shirt-matching-family-shirt-mom-dad'
105 0.0003 0.00027680397033691
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1703
106 0.0002 0.00021719932556152
SELECT * FROM manufacturers WHERE id = '0'
107 0.0002 0.00021791458129883
SELECT category_id FROM products_categories WHERE product_id = '1703'
108 0.0002 0.00021004676818848
SELECT * FROM categories WHERE id = '35'
109 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '1703' ORDER BY sortorder ASC
110 0.0003 0.00029897689819336
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1703' AND p.id = pi.product_id ORDER BY pi.sortorder
111 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '1703'
112 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '1703'
113 0.0002 0.00018501281738281
SELECT * FROM productfeeds WHERE product_id = '1703' ORDER BY item_date DESC
114 0.0003 0.0003199577331543
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1703' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
115 0.0003 0.00032401084899902
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1703' AND t.hidden = 0 AND display_product = 1
116 0.0002 0.00022101402282715
SELECT * FROM tags WHERE id = '1'
117 0.0007 0.00069093704223633
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
118 0.0006 0.00064492225646973
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
119 0.0007 0.00066804885864258
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
120 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '1696' ORDER BY sortorder ASC
121 0.0003 0.00034999847412109
SELECT * FROM productamazoncontent WHERE product_id = '1703'
122 0.0003 0.00026202201843262
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 = '1703'
                GROUP BY o.product_id
123 0.0003 0.00027012825012207
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     = '1703'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
124 0.0002 0.00023078918457031
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1703
125 0.0006 0.00057196617126465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1703' AND a.name = n.originalname
126 0.0003 0.00025105476379395
SELECT * FROM productoffers WHERE product_id = '1703' AND merchantid = 'A3P5ROKL5A1OLE'
127 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '1703' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = 1703
                ORDER BY price ASC LIMIT 1
129 0.0002 0.0002129077911377
SELECT value FROM productattributes
                WHERE product_id = '1703'
                AND name = 'ListPriceAmount'
130 0.0003 0.00027608871459961
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 = '1703'
                GROUP BY o.product_id
131 0.0002 0.00024604797363281
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     = '1703'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
132 0.0003 0.00026702880859375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1703
133 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '1703' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00028800964355469
SELECT * FROM products WHERE parent_id = '1703'
135 0.0003 0.00031304359436035
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.00029802322387695
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
137 0.0002 0.00023984909057617
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
138 0.0003 0.00031185150146484
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.0005 0.00047588348388672
SELECT id FROM ebay_products WHERE itemid = '153669320234' 
140 0.0003 0.00025391578674316
SELECT id FROM ebay_products WHERE itemid = '192866885517' 
141 0.0002 0.00019502639770508
SELECT id FROM ebay_products WHERE itemid = '184365771071' 
142 0.0002 0.00019001960754395
SELECT id FROM ebay_products WHERE itemid = '153671822795' 
143 0.0003 0.00029683113098145
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=Papa+Bear+Tshirt%2C+Mama+Bear+Shirt%2C+Matching+Family+Shirt+Mom+Dad&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.5186460018158', '11eb2a6c0893cdba19e1de4ae0d25b74', 'https://store-uk.welovebears.club/papa-bear-tshirt-mama-bear-shirt-matching-family-shirt-mom-dad'
144 0.0014 0.0014350414276123
SELECT *, MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AND 1703 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
145 0.0003 0.0002591609954834
SELECT *, MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AND 1703 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
146 0.0003 0.00026702880859375
SELECT *, MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('matching family shirt' IN BOOLEAN MODE) AND 1703 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
147 0.0014 0.0014278888702393
SELECT *, MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AND 1703 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
148 0.0002 0.00024700164794922
SELECT *, MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AND 1703 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
149 0.0002 0.00020599365234375
SELECT *, MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bear tshirt mama' IN BOOLEAN MODE) AND 1703 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0003 0.00033092498779297
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
151 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '751'
152 0.0002 0.00017809867858887
SELECT * FROM productcustomimages WHERE product_id = '751'
153 0.0003 0.00030612945556641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
154 0.0002 0.00020623207092285
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
155 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
158 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '745'
159 0.0002 0.00019288063049316
SELECT * FROM productcustomimages WHERE product_id = '745'
160 0.0005 0.00051403045654297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
161 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
162 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
165 0.0002 0.00018215179443359
SELECT * FROM product_image_select WHERE product_id = '739'
166 0.0002 0.00015711784362793
SELECT * FROM productcustomimages WHERE product_id = '739'
167 0.0005 0.00048613548278809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
168 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
169 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0002 0.0002140998840332
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0002 0.00017309188842773
SELECT id,asin FROM products WHERE parent_id = 1703
172 0.0002 0.00017309188842773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1703' ORDER BY timestamp DESC
173 0.0002 0.00019598007202148
SELECT category_id FROM products_categories WHERE product_id = '1703'
174 0.0002 0.00017309188842773
SELECT * FROM categories WHERE id = '35'
175 0.0004 0.00043010711669922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1703' AND a.name = n.originalname
176 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '1703' AND merchantid = 'A3P5ROKL5A1OLE'
177 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '1703' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = 1703
                ORDER BY price ASC LIMIT 1
179 0.0002 0.00019407272338867
SELECT value FROM productattributes
                WHERE product_id = '1703'
                AND name = 'ListPriceAmount'
180 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '1703'
181 0.0002 0.00024580955505371
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 = '1703'
                GROUP BY o.product_id
182 0.0002 0.00022292137145996
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     = '1703'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
183 0.0002 0.00019502639770508
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1703
184 0.0002 0.00021886825561523
SELECT value FROM productattributes WHERE product_id = '1703' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0005 0.00045108795166016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1703' AND a.name = n.originalname
186 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '1703' AND merchantid = 'A3P5ROKL5A1OLE'
187 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '1703' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = 1703
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00019407272338867
SELECT value FROM productattributes
                WHERE product_id = '1703'
                AND name = 'ListPriceAmount'
190 0.0002 0.00018095970153809
SELECT category_id FROM products_categories WHERE product_id = '1703' AND prod_type = 'amz'
191 0.0002 0.00015687942504883
SELECT parent_id FROM categories WHERE id = '35'
192 0.0002 0.00016593933105469
SELECT * FROM categories WHERE id = '35'
193 0.0002 0.00019407272338867
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
194 0.0002 0.00020003318786621
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
195 0.0002 0.00017905235290527
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
196 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = 42
197 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = 55
198 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = 45
199 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = 51
200 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = 42
201 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = 37
202 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = 44
203 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = 53
204 0.0006 0.00057697296142578
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
205 0.0002 0.0002140998840332
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:1597329437;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'
206 0.0002 0.00022983551025391
SELECT * FROM products WHERE id = 739
207 0.0002 0.00019693374633789
SELECT * FROM products WHERE id = 745
208 0.0002 0.00019502639770508
SELECT * FROM products WHERE id = 751
209 0.0002 0.00019407272338867
SELECT * FROM products WHERE id = 755
210 0.0002 0.00019192695617676
SELECT * FROM products WHERE id = 769
211 0.0002 0.00021910667419434
SELECT * FROM products WHERE id = 1229
212 0.0002 0.00019502639770508
SELECT * FROM products WHERE id = '739'
213 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
214 0.0002 0.00017690658569336
SELECT * FROM product_image_select WHERE product_id = '739'
215 0.0002 0.00015807151794434
SELECT * FROM productcustomimages WHERE product_id = '739'
216 0.0005 0.00048708915710449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
217 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
218 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '745'
221 0.0002 0.00023818016052246
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
222 0.0002 0.00017619132995605
SELECT * FROM product_image_select WHERE product_id = '745'
223 0.0002 0.00016593933105469
SELECT * FROM productcustomimages WHERE product_id = '745'
224 0.0005 0.0004570484161377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
225 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
226 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.0002589225769043
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0002 0.00020194053649902
SELECT * FROM products WHERE id = '751'
229 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
230 0.0002 0.00017714500427246
SELECT * FROM product_image_select WHERE product_id = '751'
231 0.0002 0.00015902519226074
SELECT * FROM productcustomimages WHERE product_id = '751'
232 0.0003 0.0002739429473877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
233 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
234 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00023007392883301
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0002 0.00022697448730469
SELECT * FROM products WHERE id = '755'
237 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
238 0.0002 0.00017595291137695
SELECT * FROM product_image_select WHERE product_id = '755'
239 0.0002 0.00015592575073242
SELECT * FROM productcustomimages WHERE product_id = '755'
240 0.0005 0.00054192543029785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
241 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
242 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0002 0.00023603439331055
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0002 0.00020194053649902
SELECT * FROM products WHERE id = '769'
245 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
246 0.0002 0.00017595291137695
SELECT * FROM product_image_select WHERE product_id = '769'
247 0.0002 0.00015592575073242
SELECT * FROM productcustomimages WHERE product_id = '769'
248 0.0004 0.00040197372436523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
249 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
250 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0002 0.00021910667419434
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0002 0.00021505355834961
SELECT * FROM products WHERE id = '1229'
253 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
254 0.0002 0.00017619132995605
SELECT * FROM product_image_select WHERE product_id = '1229'
255 0.0002 0.00015616416931152
SELECT * FROM productcustomimages WHERE product_id = '1229'
256 0.0005 0.00048518180847168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
257 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
258 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0004 0.00035500526428223
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
261 0.0003 0.00029516220092773
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
262 0.0007 0.00066614151000977
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
263 0.0003 0.00027799606323242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
264 0.0003 0.00028085708618164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
265 0.0004 0.0003821849822998
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
266 0.0003 0.0002899169921875
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
267 0.0003 0.00032496452331543
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'