US Army Pill Box Keepsake United States Military Collectibles Patriotic Gifts

Price: $23.95
Product prices and availability are accurate as of 2022-01-22 08:04:57 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
In Stock.
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.

Product Features

Polished Brass Detailed Pewter Logo Box Measures 1.5" Round Secure Hinged Lid Free velvet gift pouch

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.42872500419617 250 0.0752 0


No Amazon API Requests Made.


App Debug - Total Time 0.42872500419617 seconds

Number Time From Start Name Description
1 0.3372368812561 Initialise Initialise FSB Function
2 0.33793091773987 App Controller Start Start of the App controller (called before the controller of every page)
3 0.34261703491211 Start of getCategoryListByGroup Function Before first category groups query
4 0.34276986122131 After initial query Before first category groups query
5 0.34276986122131 Get Category List for Group Before the call to getCategoryList function
6 0.34277296066284 Start of GetCategoryList function Start of the function
7 0.34277486801147 Before getting categories Query to get specific category list
8 0.34299492835999 After getting categories Query to get specific category list
9 0.34299492835999 Before getting category custom Before call to function getCategoryCustom
10 0.34442687034607 After getting category custom After call to function getCategoryCustom
11 0.34442901611328 Before getting category custom Before call to function getCategoryCustom
12 0.34563207626343 After getting category custom After call to function getCategoryCustom
13 0.34563398361206 Before getting category custom Before call to function getCategoryCustom
14 0.34693908691406 After getting category custom After call to function getCategoryCustom
15 0.3469409942627 Before getting category custom Before call to function getCategoryCustom
16 0.34800601005554 After getting category custom After call to function getCategoryCustom
17 0.34800696372986 End of GetCategoryList function End of the function
18 0.3480110168457 Get Category List for Group Before the call to getCategoryList function
19 0.34801197052002 Start of GetCategoryList function Start of the function
20 0.34801387786865 Before getting categories Query to get specific category list
21 0.3481330871582 End of getCategoryListByGroup Function Before return()
22 0.38246607780457 App Controller End End of the App controller (called before the controller of every page)
23 0.38305997848511 Product Start Start of the product info controller
24 0.38380599021912 Cache file not found Starting get product details
25 0.38909602165222 Related products Start getting related products if enabled
26 0.38909697532654 Related Products Start Before the related products are found
27 0.38909697532654 Related Products Keywords Before the related product keywords are found
28 0.38910102844238 Create Keyword List Function Start of function
29 0.38917708396912 Create Keyword List Function After looping provided content - 30 keywords found
30 0.38995885848999 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
31 0.38997101783752 Create Keyword List Function After reducing keyword list
32 0.3900249004364 Create Keyword List Function After selecting by scoring keywords
33 0.39002895355225 Create Keyword List Function After final loop of keywords
34 0.39002990722656 Related Products Keywords After the related product keywords are found
35 0.39766001701355 Related Products End After the related products are found
36 0.40194606781006 Product End End of the product info controller (Product Info)
37 0.40249586105347 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.40276288986206 Before Get Options Before the call to getOptions in the tpl class
39 0.41805291175842 After Get Options After the call to getOptions in the tpl class
40 0.41815900802612 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.41817808151245 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.42146992683411 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.42147207260132 Product Info: Before Template Display Before the template is displayed
44 0.42871189117432 Product Info: After Template Display After the template is displayed
45 0.42871809005737 Finalizing debug Before the debug is output to the page.
46 0.42872500419617 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.0752 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00023698806762695
SELECT parameter, value FROM parameters
2 0.0004 0.0003960132598877
SELECT * FROM `bad_bots`
3 0.0002 0.00016689300537109
SET time_zone = 'Europe/London'
4 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00022196769714355
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.173.214.227\";}'
6 0.0002 0.00016903877258301
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642883850'
7 0.0003 0.00029897689819336
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016283988952637
UPDATE autorun SET lastrun = '2022-01-22 20:37:31' WHERE id = '13'
9 0.0001 0.00011610984802246
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0001 0.00012588500976562
SELECT id FROM pages WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles' LIMIT 1
11 0.0001 0.00014400482177734
SELECT id FROM products WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles' AND hidden = 0 LIMIT 1
12 0.0003 0.00031685829162598
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0038 0.003803014755249
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0001 0.00013899803161621
SELECT * FROM pages WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles'
15 0.0001 0.00014305114746094
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0002 0.00020384788513184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00026607513427734
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
18 0.0002 0.00015497207641602
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
19 0.0001 0.00010991096496582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00022792816162109
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 
22 0.0001 0.0001368522644043
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 
23 0.0002 0.0001521110534668
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
24 0.0001 0.00011205673217773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00024008750915527
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
27 0.0001 9.9897384643555E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
28 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 9.9897384643555E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00025200843811035
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 
31 0.0001 8.5115432739258E-5
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 
32 0.0001 9.8943710327148E-5
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
33 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 8.5115432739258E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00029993057250977
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
36 0.0001 9.7990036010742E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
37 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00031304359436035
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 
40 0.0001 8.392333984375E-5
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 
41 0.0001 9.7036361694336E-5
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
42 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 9.4175338745117E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00017905235290527
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 = 38
45 0.0001 9.6797943115234E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
46 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
50 0.0001 0.0001070499420166
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 9.7990036010742E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00010991096496582
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0005 0.00048708915710449
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0002 0.00021505355834961
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00017499923706055
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
57 0.0002 0.00020098686218262
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00033903121948242
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0315 0.031501054763794
SELECT * FROM ipgeocountries WHERE INET_ATON('54.173.214.227') >= INET_ATON(ip_start) AND INET_ATON('54.173.214.227') <= INET_ATON(ip_end)
60 0.0004 0.00035285949707031
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0002 0.00017690658569336
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.0002140998840332
SELECT * FROM products WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles'
63 0.0002 0.00016498565673828
UPDATE products SET viewcount = viewcount + 1 WHERE id = 748
64 0.0001 0.00013518333435059
SELECT * FROM manufacturers WHERE id = '176'
65 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
66 0.0001 0.00011587142944336
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '176' LIMIT 1
67 0.0002 0.00022315979003906
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '176' ORDER BY RAND() LIMIT 1
68 0.0001 0.00012493133544922
SELECT * FROM productimages WHERE product_id = '805' ORDER BY sortorder ASC
69 0.0001 0.00013303756713867
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
70 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '176'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
71 0.0001 7.2956085205078E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '176'
72 0.0001 8.9883804321289E-5
SELECT category_id FROM products_categories WHERE product_id = '748'
73 0.0001 0.00010204315185547
SELECT * FROM categories WHERE id = '29'
74 0.0003 0.00025796890258789
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
75 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '29'
77 0.0003 0.0002739429473877
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 
78 0.0001 8.8930130004883E-5
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 
79 0.0001 9.8943710327148E-5
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
80 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '748' ORDER BY sortorder ASC
82 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '748'
83 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '748'
84 0.0002 0.00015592575073242
SELECT * FROM productfeeds WHERE product_id = '748' ORDER BY item_date DESC
85 0.0002 0.00017213821411133
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
86 0.0002 0.00019502639770508
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '748' AND t.hidden = 0 AND display_product = 1
87 0.0004 0.0004279613494873
SELECT * FROM productamazoncontent WHERE product_id = '748'
88 0.0004 0.0003969669342041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
89 0.0001 0.00011515617370605
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
90 0.0001 0.00012397766113281
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
91 0.0002 0.0001530647277832
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
92 0.0002 0.00017499923706055
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
93 0.0008 0.00080394744873047
SELECT *, MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AND 748 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
94 0.0002 0.00018191337585449
SELECT *, MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AND 748 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
95 0.0001 0.00012993812561035
SELECT *, MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('keepsake united states' IN BOOLEAN MODE) AND 748 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
96 0.0001 0.00011396408081055
SELECT * FROM productimages WHERE product_id = '748' ORDER BY sortorder ASC
97 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '748'
98 0.0001 0.00010299682617188
SELECT * FROM productcustomimages WHERE product_id = '748'
99 0.0006 0.00056600570678711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
100 0.0002 0.0001521110534668
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
101 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0002 0.0001530647277832
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0009 0.00088691711425781
SELECT *, MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AND 748 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
104 0.0002 0.0001518726348877
SELECT *, MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AND 748 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
105 0.0001 0.0001380443572998
SELECT *, MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('military collectibles patriotic' IN BOOLEAN MODE) AND 748 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
106 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
107 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '740'
108 0.0001 0.00010085105895996
SELECT * FROM productcustomimages WHERE product_id = '740'
109 0.0004 0.0004119873046875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
110 0.0001 0.00011992454528809
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'ATVPDKIKX0DER'
111 0.0001 0.0001218318939209
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0001 0.00014090538024902
SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
114 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '724'
115 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '724'
116 0.0003 0.0002739429473877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
117 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
118 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '724' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0001 0.00014591217041016
SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0001 0.00011897087097168
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
121 0.0001 0.00013184547424316
SELECT * FROM product_image_select WHERE product_id = '739'
122 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '739'
123 0.0003 0.00033187866210938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
124 0.0001 0.00010299682617188
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'ATVPDKIKX0DER'
125 0.0001 0.00013399124145508
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0001 0.00013113021850586
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0001 8.392333984375E-5
SELECT id,asin FROM products WHERE parent_id = 748
128 0.0001 9.2983245849609E-5
SELECT category_id FROM products_categories WHERE product_id = '748'
129 0.0001 0.00011205673217773
SELECT * FROM categories WHERE id = '29'
130 0.0003 0.00026321411132812
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
131 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
132 0.0001 9.2983245849609E-5
SELECT id FROM categories WHERE parent_id = '29'
133 0.0002 0.0002439022064209
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 
134 0.0001 0.00010085105895996
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 
135 0.0001 0.00011301040649414
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
136 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
137 0.0004 0.00038480758666992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
138 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
139 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0001 0.00013208389282227
SELECT * FROM products WHERE id = '748'
141 0.0001 0.00014805793762207
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0004 0.00039196014404297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
143 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
144 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0001 9.1075897216797E-5
SELECT category_id FROM products_categories WHERE product_id = '748' AND prod_type = 'amz'
146 0.0001 8.702278137207E-5
SELECT parent_id FROM categories WHERE id = '29'
147 0.0001 0.00010299682617188
SELECT * FROM categories WHERE id = '29'
148 0.0002 0.00023293495178223
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
149 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
150 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '29'
151 0.0002 0.00024104118347168
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 
152 0.0001 8.5115432739258E-5
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 
153 0.0001 0.00010490417480469
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
154 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
155 0.0002 0.00015401840209961
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
156 0.0001 0.00012898445129395
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
157 0.0001 8.1062316894531E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
158 0.0001 0.00011801719665527
SELECT * FROM pages WHERE id = 38
159 0.0001 9.9897384643555E-5
SELECT * FROM categories WHERE id = '27'
160 0.0002 0.00018787384033203
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
161 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
163 0.0002 0.00019407272338867
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 
164 0.0001 8.702278137207E-5
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 
165 0.0001 0.00010514259338379
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
166 0.0001 8.5830688476562E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0002 0.00017285346984863
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
168 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0002 0.00018715858459473
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 
170 0.0001 8.1062316894531E-5
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 
171 0.0001 9.4890594482422E-5
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
172 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0001 8.6069107055664E-5
SELECT id FROM categories WHERE parent_id = '27'
174 0.0002 0.00022411346435547
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
175 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
176 0.0001 0.00011992454528809
SELECT * FROM categoryimages WHERE category_id = 27
177 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
178 0.0002 0.00020217895507812
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
179 0.0001 9.3221664428711E-5
SELECT * FROM categories WHERE id = '30'
180 0.0003 0.00029397010803223
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
181 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
182 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
183 0.0003 0.00028204917907715
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 
184 0.0001 8.1062316894531E-5
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 
185 0.0001 9.3221664428711E-5
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
186 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
187 0.0003 0.0002892017364502
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
188 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
189 0.0003 0.00028300285339355
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 
190 0.0001 7.8916549682617E-5
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 
191 0.0001 9.2029571533203E-5
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
192 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
193 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
194 0.0003 0.00033020973205566
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
195 0.0001 0.00012302398681641
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
196 0.0001 8.0108642578125E-5
SELECT * FROM categoryimages WHERE category_id = 30
197 0.0001 8.5830688476562E-5
SELECT * FROM categorygroups WHERE id = '1'
198 0.0003 0.0002901554107666
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
199 0.0001 0.0001060962677002
SELECT * FROM pages WHERE id = 59
200 0.0001 0.00010895729064941
SELECT * FROM pages WHERE id = 55
201 0.0001 0.00014996528625488
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
202 0.0001 0.0001220703125
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1642883851;s:8:\"products\";a:0:{}}' WHERE id = '8'
203 0.0002 0.00021100044250488
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
204 0.0001 0.00010013580322266
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1642883851;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
205 0.0001 0.00012588500976562
SELECT * FROM products WHERE id = 7004
206 0.0001 0.00012397766113281
SELECT * FROM products WHERE id = 7011
207 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
208 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7004'
209 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
210 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7004'
211 0.0001 0.00010013580322266
SELECT * FROM productcustomimages WHERE product_id = '7004'
212 0.0005 0.00050091743469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
213 0.0001 0.00010991096496582
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
214 0.0001 0.00012493133544922
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0001 0.00011610984802246
SELECT * FROM products WHERE id = '7011'
217 0.0001 0.00011897087097168
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
218 0.0002 0.00016188621520996
SELECT * FROM product_image_select WHERE product_id = '7011'
219 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
220 0.0005 0.00052094459533691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
221 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
222 0.0001 0.00012016296386719
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0001 0.00010395050048828
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
224 0.0001 0.0001218318939209
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
225 0.0001 0.00011587142944336
SELECT * FROM products WHERE id = '7045'
226 0.0001 0.00010180473327637
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
227 0.0001 0.00014209747314453
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
228 0.0001 0.00014305114746094
SELECT * FROM product_image_select WHERE product_id = '7045'
229 0.0001 0.00011587142944336
SELECT * FROM productcustomimages WHERE product_id = '7045'
230 0.0001 0.00013995170593262
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 = '7045'
                GROUP BY o.product_id
231 0.0003 0.00025010108947754
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
232 0.0001 0.00011920928955078
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
233 0.0005 0.00053882598876953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
234 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
235 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
237 0.0001 0.00011491775512695
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
238 0.0001 0.0001370906829834
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 = '7045'
                GROUP BY o.product_id
239 0.0002 0.00018405914306641
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0001 0.00012993812561035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
241 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0002 0.00015687942504883
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
243 0.0002 0.0001521110534668
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
244 0.0003 0.00025701522827148
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
245 0.0002 0.00021791458129883
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
246 0.0004 0.00037193298339844
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
247 0.0002 0.00020790100097656
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
248 0.0002 0.00015997886657715
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
249 0.0002 0.00019502639770508
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
250 0.0001 0.0001378059387207
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'