Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Greenland Home Black Bear Lodge Quilt Set

Greenland Home Black Bear Lodge Quilt Set
Greenland Home Black Bear Lodge Quilt Set Greenland Home Black Bear Lodge Quilt Set Greenland Home Black Bear Lodge Quilt Set Greenland Home Black Bear Lodge Quilt Set Greenland Home Black Bear Lodge Quilt Set (click images to enlarge)
Click Button for Price
Not Available Discontinued

Notice: Undefined index: pricelastupdated in /home/fsi65be/public_html/storeukwelovebearsclub56958/cache/fsb-smoothstore/smarty/79c9c034ee80a3352dc2151b717c3e17e2d70e94.template.pricebox.php on line 211

Notice: Trying to get property of non-object in /home/fsi65be/public_html/storeukwelovebearsclub56958/cache/fsb-smoothstore/smarty/79c9c034ee80a3352dc2151b717c3e17e2d70e94.template.pricebox.php on line 211

Notice: Undefined index: amazonurl in /home/fsi65be/public_html/storeukwelovebearsclub56958/cache/fsb-smoothstore/smarty/79c9c034ee80a3352dc2151b717c3e17e2d70e94.template.pricebox.php on line 211

Notice: Trying to get property of non-object in /home/fsi65be/public_html/storeukwelovebearsclub56958/cache/fsb-smoothstore/smarty/79c9c034ee80a3352dc2151b717c3e17e2d70e94.template.pricebox.php on line 211
Product prices and availability are accurate as of and are subject to change. Any price and availability information displayed on at the time of purchase will apply to the purchase of this product.

Product Features

Choose from twin, full/queen, and king size options Includes quilt and 1-2 shams 100% cotton face and fill Machine quilting adds durability and surface interest Reverses to a coodrinating print

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

Write a Review

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.68059921264648 265 0.1698 0


No Amazon API Requests Made.

Total time 0.68059921264648 seconds

Number Time From Start Name Description
1 0.16675901412964 Initialise Initialise FSB Function
2 0.16893100738525 App Controller Start Start of the App controller (called before the controller of every page)
3 0.17778301239014 Start of getCategoryListByGroup Function Before first category groups query
4 0.17852020263672 After initial query Before first category groups query
5 0.17852115631104 Get Category List for Group Before the call to getCategoryList function
6 0.17852306365967 Start of GetCategoryList function Start of the function
7 0.17853617668152 Before getting categories Query to get specific category list
8 0.17907810211182 After getting categories Query to get specific category list
9 0.17907905578613 Before getting category custom Before call to function getCategoryCustom
10 0.18511509895325 After getting category custom After call to function getCategoryCustom
11 0.18511819839478 Before getting category custom Before call to function getCategoryCustom
12 0.18820405006409 After getting category custom After call to function getCategoryCustom
13 0.18820810317993 Before getting category custom Before call to function getCategoryCustom
14 0.1921501159668 After getting category custom After call to function getCategoryCustom
15 0.19215512275696 Before getting category custom Before call to function getCategoryCustom
16 0.19460415840149 After getting category custom After call to function getCategoryCustom
17 0.19460821151733 Before getting category custom Before call to function getCategoryCustom
18 0.19747018814087 After getting category custom After call to function getCategoryCustom
19 0.19747519493103 Before getting category custom Before call to function getCategoryCustom
20 0.19980216026306 After getting category custom After call to function getCategoryCustom
21 0.19980716705322 Before getting category custom Before call to function getCategoryCustom
22 0.20232701301575 After getting category custom After call to function getCategoryCustom
23 0.20233106613159 Before getting category custom Before call to function getCategoryCustom
24 0.20496010780334 After getting category custom After call to function getCategoryCustom
25 0.20496320724487 Before getting category custom Before call to function getCategoryCustom
26 0.20824217796326 After getting category custom After call to function getCategoryCustom
27 0.20824503898621 End of GetCategoryList function End of the function
28 0.2082531452179 End of getCategoryListByGroup Function Before return()
29 0.28465819358826 App Controller End End of the App controller (called before the controller of every page)
30 0.28513503074646 Product Start Start of the product info controller
31 0.28614521026611 Cache file not found Starting get product details
32 0.29780006408691 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.62413501739502 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.62534403800964 Related products Start getting related products if enabled
35 0.62534403800964 Related Products Start Before the related products are found
36 0.62534499168396 Related Products Keywords Before the related product keywords are found
37 0.62534999847412 Create Keyword List Function Start of function
38 0.62544298171997 Create Keyword List Function After looping provided content - 18 keywords found
39 0.62583112716675 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
40 0.62584018707275 Create Keyword List Function After reducing keyword list
41 0.62588214874268 Create Keyword List Function After selecting by scoring keywords
42 0.62589502334595 Create Keyword List Function After final loop of keywords
43 0.62589621543884 Related Products Keywords After the related product keywords are found
44 0.63459300994873 Related Products End After the related products are found
45 0.64482021331787 Product End End of the product info controller (Product Info)
46 0.64622211456299 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.64691114425659 Before Get Options Before the call to getOptions in the tpl class
48 0.66771101951599 After Get Options After the call to getOptions in the tpl class
49 0.66782808303833 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.66785907745361 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.67293405532837 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.6729371547699 Product Info: Before Template Display Before the template is displayed
53 0.68058609962463 Product Info: After Template Display After the template is displayed
54 0.68059015274048 Finalizing debug Before the debug is output to the page.
55 0.68059921264648 End of App This is the end of the app logging, final timestamp


Query Debug - 265 Database Queries. Total time 0.1698 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00035500526428223
SELECT parameter, value FROM parameters
2 0.0010 0.0010371208190918
SELECT * FROM `bad_bots`
3 0.0005 0.00047397613525391
SET time_zone = 'Europe/London'
4 0.0011 0.0011448860168457
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.00097489356994629
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00025081634521484
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0007 0.00072503089904785
SELECT id FROM pages WHERE pagename = 'greenland-home-black-bear-lodge-quilt-set' LIMIT 1
8 0.0008 0.00076603889465332
SELECT id FROM products WHERE pagename = 'greenland-home-black-bear-lodge-quilt-set' AND hidden = 0 LIMIT 1
9 0.0008 0.00083708763122559
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0069 0.0068759918212891
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0003 0.00031399726867676
SELECT * FROM pages WHERE pagename = 'greenland-home-black-bear-lodge-quilt-set'
12 0.0007 0.00072693824768066
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0005 0.00050902366638184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0016 0.0016489028930664
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.0005 0.0005180835723877
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
16 0.0004 0.00036883354187012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '26'
18 0.0014 0.00142502784729
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.0006 0.00055813789367676
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.0005 0.00050497055053711
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
21 0.0004 0.00037002563476562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0002 0.00023698806762695
SELECT * FROM categorygroups WHERE id = '1'
23 0.0006 0.0005650520324707
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.0002448558807373
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.00020289421081543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0002 0.00018906593322754
SELECT id FROM categories WHERE parent_id = '27'
27 0.0006 0.00057101249694824
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.00028896331787109
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.00029087066650391
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.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0003 0.00031185150146484
SELECT * FROM categorygroups WHERE id = '1'
32 0.0009 0.00093603134155273
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.00027203559875488
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.0002140998840332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '28'
36 0.0007 0.00072193145751953
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.00026893615722656
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.0006 0.00058794021606445
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.00022411346435547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0003 0.00028896331787109
SELECT * FROM categorygroups WHERE id = '1'
41 0.0006 0.00055289268493652
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.00023698806762695
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.00018692016601562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '29'
45 0.0003 0.00031399726867676
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.00021600723266602
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.00021195411682129
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
50 0.0006 0.00056314468383789
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.00024700164794922
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.00017619132995605
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '30'
54 0.0006 0.00058197975158691
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.00023007392883301
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.00032997131347656
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0002 0.0001978874206543
SELECT * FROM categorygroups WHERE id = '1'
59 0.0004 0.00039887428283691
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.00021505355834961
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.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '31'
63 0.0004 0.00042104721069336
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.00020313262939453
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.00021696090698242
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '1'
68 0.0004 0.00042915344238281
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.00022411346435547
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.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '32'
72 0.0004 0.00043296813964844
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.0002129077911377
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.00023198127746582
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.0002 0.00022292137145996
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.0003969669342041
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.00023603439331055
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.00018501281738281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '33'
81 0.0004 0.0004279613494873
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.00021910667419434
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.00020790100097656
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.0003 0.00030899047851562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0003 0.00029897689819336
SELECT * FROM categorygroups WHERE id = '1'
86 0.0006 0.00063800811767578
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.0003 0.00030303001403809
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.00023484230041504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '34'
90 0.0007 0.00067400932312012
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.0003 0.00027203559875488
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.0003 0.0003201961517334
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.00024199485778809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.00021600723266602
SELECT * FROM categorygroups WHERE id = '1'
95 0.0008 0.0008389949798584
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0008 0.00079703330993652
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.00032997131347656
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.00048089027404785
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.00041604042053223
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0705 0.070466995239258
SELECT * FROM ipgeocountries WHERE INET_ATON('35.172.233.2') >= INET_ATON(ip_start) AND INET_ATON('35.172.233.2') <= INET_ATON(ip_end)
101 0.0010 0.0010380744934082
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0009 0.00085210800170898
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0002 0.00023722648620605
SELECT * FROM countryredirects WHERE id <> 1
104 0.0004 0.0004119873046875
SELECT * FROM products WHERE pagename = 'greenland-home-black-bear-lodge-quilt-set'
105 0.0003 0.00029397010803223
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1643
106 0.0003 0.00025582313537598
SELECT * FROM manufacturers WHERE id = '246'
107 0.0002 0.00023508071899414
SELECT category_id FROM products_categories WHERE product_id = '1643'
108 0.0003 0.00026702880859375
SELECT * FROM categories WHERE id = '31'
109 0.0004 0.00043082237243652
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
110 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
111 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '31'
112 0.0004 0.00043296813964844
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 
113 0.0002 0.00021505355834961
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 
114 0.0002 0.00023698806762695
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
115 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
116 0.0008 0.00080609321594238
SELECT * FROM productimages WHERE product_id = '1643' ORDER BY sortorder ASC
117 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '1643'
118 0.0006 0.00061702728271484
SELECT * FROM productcustomimages WHERE product_id = '1643'
119 0.0006 0.00059103965759277
SELECT * FROM productfeeds WHERE product_id = '1643' ORDER BY item_date DESC
120 0.0010 0.0010309219360352
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1643' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
121 0.0009 0.00092387199401855
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1643' AND t.hidden = 0 AND display_product = 1
122 0.0005 0.0005030632019043
SELECT * FROM productamazoncontent WHERE product_id = '1643'
123 0.0006 0.00062084197998047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1643' AND a.name = n.originalname
124 0.0004 0.00037407875061035
SELECT * FROM productoffers WHERE product_id = '1643' AND merchantid = 'A3P5ROKL5A1OLE'
125 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '1643' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = 1643
                ORDER BY price ASC LIMIT 1
127 0.0003 0.00025296211242676
SELECT value FROM productattributes
                WHERE product_id = '1643'
                AND name = 'ListPriceAmount'
128 0.0003 0.00026893615722656
SELECT value FROM productattributes WHERE product_id = '1643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00026893615722656
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
130 0.0003 0.00028610229492188
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.0005 0.00050592422485352
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
132 0.0003 0.00026392936706543
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
133 0.0009 0.00090909004211426
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=Greenland+Home+Black+Bear+Lodge+Quilt+Set&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.32634520530701', '7fe5f65d7c7ea42f3076e5a556b7672a', 'https://store-uk.welovebears.club/greenland-home-black-bear-lodge-quilt-set/'
134 0.0016 0.0015900135040283
SELECT *, MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AND 1643 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
135 0.0003 0.00027108192443848
SELECT *, MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AND 1643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
136 0.0003 0.00025701522827148
SELECT *, MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('greenland home black' IN BOOLEAN MODE) AND 1643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
137 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
138 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '745'
139 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '745'
140 0.0006 0.00056314468383789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
141 0.0002 0.0002281665802002
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
142 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0003 0.00032305717468262
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
145 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '751'
146 0.0002 0.00021505355834961
SELECT * FROM productcustomimages WHERE product_id = '751'
147 0.0003 0.00033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
148 0.0002 0.00022315979003906
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
149 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '1659' ORDER BY sortorder ASC
152 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '1659'
153 0.0002 0.00017809867858887
SELECT * FROM productcustomimages WHERE product_id = '1659'
154 0.0006 0.00059604644775391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1659' AND a.name = n.originalname
155 0.0002 0.00021982192993164
SELECT * FROM productoffers WHERE product_id = '1659' AND merchantid = 'A3P5ROKL5A1OLE'
156 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '1659' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '1659' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0002 0.0002140998840332
SELECT id,asin FROM products WHERE parent_id = 1643
159 0.0008 0.00075197219848633
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1643' ORDER BY timestamp DESC
160 0.0002 0.00021100044250488
SELECT category_id FROM products_categories WHERE product_id = '1643'
161 0.0002 0.00022506713867188
SELECT * FROM categories WHERE id = '31'
162 0.0004 0.00039887428283691
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
163 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
164 0.0003 0.00026583671569824
SELECT id FROM categories WHERE parent_id = '31'
165 0.0004 0.00040483474731445
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 
166 0.0003 0.00026297569274902
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 
167 0.0002 0.00021910667419434
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
168 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
169 0.0006 0.00063490867614746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1643' AND a.name = n.originalname
170 0.0002 0.00023293495178223
SELECT * FROM productoffers WHERE product_id = '1643' AND merchantid = 'A3P5ROKL5A1OLE'
171 0.0002 0.00024318695068359
SELECT * FROM productoffers
                WHERE product_id = '1643' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = 1643
                ORDER BY price ASC LIMIT 1
173 0.0005 0.00046610832214355
SELECT value FROM productattributes
                WHERE product_id = '1643'
                AND name = 'ListPriceAmount'
174 0.0002 0.00023484230041504
SELECT * FROM products WHERE id = '1643'
175 0.0003 0.00026416778564453
SELECT value FROM productattributes WHERE product_id = '1643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0006 0.0005948543548584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1643' AND a.name = n.originalname
177 0.0002 0.00024294853210449
SELECT * FROM productoffers WHERE product_id = '1643' AND merchantid = 'A3P5ROKL5A1OLE'
178 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '1643' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = 1643
                ORDER BY price ASC LIMIT 1
180 0.0002 0.00023484230041504
SELECT value FROM productattributes
                WHERE product_id = '1643'
                AND name = 'ListPriceAmount'
181 0.0002 0.00022506713867188
SELECT category_id FROM products_categories WHERE product_id = '1643' AND prod_type = 'amz'
182 0.0002 0.00022196769714355
SELECT parent_id FROM categories WHERE id = '31'
183 0.0002 0.00023198127746582
SELECT * FROM categories WHERE id = '31'
184 0.0004 0.00041794776916504
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
185 0.0002 0.00020909309387207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
186 0.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '31'
187 0.0005 0.00046896934509277
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 
188 0.0002 0.00022196769714355
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 
189 0.0002 0.0001981258392334
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
190 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
191 0.0007 0.00074887275695801
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
192 0.0004 0.0003669261932373
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0002 0.0001981258392334
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = 42
195 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = 55
196 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = 45
197 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = 51
198 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = 42
199 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = 37
200 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = 44
201 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = 53
202 0.0008 0.0008089542388916
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
203 0.0002 0.00024104118347168
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:1596984572;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'
204 0.0002 0.00022101402282715
SELECT * FROM products WHERE id = 739
205 0.0002 0.0002129077911377
SELECT * FROM products WHERE id = 745
206 0.0002 0.00021195411682129
SELECT * FROM products WHERE id = 751
207 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = 755
208 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = 769
209 0.0002 0.00021004676818848
SELECT * FROM products WHERE id = 1229
210 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '739'
211 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
212 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '739'
213 0.0002 0.00017404556274414
SELECT * FROM productcustomimages WHERE product_id = '739'
214 0.0005 0.00051999092102051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
215 0.0003 0.00026512145996094
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
216 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0002 0.00024890899658203
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0002 0.00024199485778809
SELECT * FROM products WHERE id = '745'
219 0.0003 0.00029611587524414
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
220 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '745'
221 0.0002 0.00017118453979492
SELECT * FROM productcustomimages WHERE product_id = '745'
222 0.0005 0.0005040168762207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
223 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
224 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0002 0.00023293495178223
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0003 0.0002739429473877
SELECT * FROM products WHERE id = '751'
227 0.0003 0.00027608871459961
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
228 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '751'
229 0.0002 0.00016593933105469
SELECT * FROM productcustomimages WHERE product_id = '751'
230 0.0007 0.00070500373840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
231 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
232 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0002 0.00023913383483887
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0002 0.00021004676818848
SELECT * FROM products WHERE id = '755'
235 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
236 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '755'
237 0.0002 0.00016593933105469
SELECT * FROM productcustomimages WHERE product_id = '755'
238 0.0005 0.00054407119750977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
239 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
240 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0002 0.00021004676818848
SELECT * FROM products WHERE id = '769'
243 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
244 0.0002 0.00018501281738281
SELECT * FROM product_image_select WHERE product_id = '769'
245 0.0002 0.00016593933105469
SELECT * FROM productcustomimages WHERE product_id = '769'
246 0.0004 0.00038504600524902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
247 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
248 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0002 0.00020790100097656
SELECT * FROM products WHERE id = '1229'
251 0.0003 0.00031113624572754
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
252 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '1229'
253 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '1229'
254 0.0005 0.00051116943359375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
255 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
256 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0002 0.00023388862609863
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0006 0.00063991546630859
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
259 0.0003 0.00030994415283203
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
260 0.0009 0.00085592269897461
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
261 0.0005 0.00045490264892578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
262 0.0003 0.00027608871459961
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
263 0.0003 0.00032591819763184
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
264 0.0003 0.00026106834411621
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
265 0.0003 0.00026798248291016
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'