US Army Pill Box Keepsake United States Military Collectibles Patriotic Gifts

Price: $23.95
Availability: Not Available Discontinued
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.3756639957428 249 0.0706 0


No Amazon API Requests Made.


App Debug - Total Time 0.3756639957428 seconds

Number Time From Start Name Description
1 0.29100918769836 Initialise Initialise FSB Function
2 0.2917320728302 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29661202430725 Start of getCategoryListByGroup Function Before first category groups query
4 0.2967541217804 After initial query Before first category groups query
5 0.29675507545471 Get Category List for Group Before the call to getCategoryList function
6 0.29675722122192 Start of GetCategoryList function Start of the function
7 0.29675912857056 Before getting categories Query to get specific category list
8 0.29693222045898 After getting categories Query to get specific category list
9 0.2969331741333 Before getting category custom Before call to function getCategoryCustom
10 0.29839110374451 After getting category custom After call to function getCategoryCustom
11 0.29839611053467 Before getting category custom Before call to function getCategoryCustom
12 0.29951119422913 After getting category custom After call to function getCategoryCustom
13 0.29951214790344 Before getting category custom Before call to function getCategoryCustom
14 0.30056214332581 After getting category custom After call to function getCategoryCustom
15 0.30056405067444 Before getting category custom Before call to function getCategoryCustom
16 0.30147314071655 After getting category custom After call to function getCategoryCustom
17 0.30147504806519 End of GetCategoryList function End of the function
18 0.30147814750671 Get Category List for Group Before the call to getCategoryList function
19 0.30147910118103 Start of GetCategoryList function Start of the function
20 0.30148005485535 Before getting categories Query to get specific category list
21 0.30158615112305 End of getCategoryListByGroup Function Before return()
22 0.33365106582642 App Controller End End of the App controller (called before the controller of every page)
23 0.33401203155518 Product Start Start of the product info controller
24 0.3345410823822 Cache file not found Starting get product details
25 0.33974313735962 Related products Start getting related products if enabled
26 0.33974409103394 Related Products Start Before the related products are found
27 0.33974409103394 Related Products Keywords Before the related product keywords are found
28 0.33974719047546 Create Keyword List Function Start of function
29 0.33980512619019 Create Keyword List Function After looping provided content - 30 keywords found
30 0.34067010879517 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
31 0.34067916870117 Create Keyword List Function After reducing keyword list
32 0.3407461643219 Create Keyword List Function After selecting by scoring keywords
33 0.34074807167053 Create Keyword List Function After final loop of keywords
34 0.34074902534485 Related Products Keywords After the related product keywords are found
35 0.34677815437317 Related Products End After the related products are found
36 0.35157012939453 Product End End of the product info controller (Product Info)
37 0.35205912590027 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.35232710838318 Before Get Options Before the call to getOptions in the tpl class
39 0.36664915084839 After Get Options After the call to getOptions in the tpl class
40 0.36672210693359 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.36673712730408 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.36952209472656 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.3695240020752 Product Info: Before Template Display Before the template is displayed
44 0.37565302848816 Product Info: After Template Display After the template is displayed
45 0.375657081604 Finalizing debug Before the debug is output to the page.
46 0.37566304206848 End of App This is the end of the app logging, final timestamp


Query Debug - 249 Database Queries. Total time 0.0706 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00028395652770996
SELECT parameter, value FROM parameters
2 0.0003 0.00033998489379883
SELECT * FROM `bad_bots`
3 0.0001 0.00012612342834473
SET time_zone = 'Europe/London'
4 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00019383430480957
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.207.238.28\";}'
6 0.0001 0.0001380443572998
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1674926667'
7 0.0002 0.00019407272338867
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00012397766113281
UPDATE autorun SET lastrun = '2023-01-28 17:24:27' WHERE id = '17'
9 0.0001 8.3208084106445E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00015902519226074
SELECT id FROM pages WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles' LIMIT 1
11 0.0002 0.00020194053649902
SELECT id FROM products WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles' AND hidden = 0 LIMIT 1
12 0.0004 0.00036787986755371
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0040 0.0039529800415039
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0001 0.00012397766113281
SELECT * FROM pages WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles'
15 0.0001 0.00013089179992676
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0002 0.00015902519226074
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00026679039001465
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.00018501281738281
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.00011396408081055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 6.8902969360352E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00019001960754395
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.00013303756713867
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.00017094612121582
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.0001370906829834
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.8930130004883E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0003 0.00028395652770996
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 0.00010490417480469
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 6.0081481933594E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 7.6055526733398E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0002 0.00020194053649902
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.702278137207E-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 8.6069107055664E-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 6.0081481933594E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 6.8187713623047E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0002 0.00021910667419434
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 8.5830688476562E-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 5.6982040405273E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 7.5101852416992E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0002 0.00023102760314941
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.7976455688477E-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 8.3208084106445E-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 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0001 0.00014901161193848
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 8.6069107055664E-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 5.5789947509766E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00015997886657715
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 7.1048736572266E-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.00010204315185547
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 6.0081481933594E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 9.7990036010742E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0004 0.00041007995605469
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0002 0.00018095970153809
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00015997886657715
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.00018596649169922
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00030207633972168
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0298 0.029818058013916
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.238.28') >= INET_ATON(ip_start) AND INET_ATON('18.207.238.28') <= INET_ATON(ip_end)
60 0.0002 0.00020194053649902
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0001 0.0001060962677002
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0001 0.00014495849609375
SELECT * FROM products WHERE pagename = 'us-army-pill-box-keepsake-united-states-military-collectibles'
63 0.0001 0.00014591217041016
UPDATE products SET viewcount = viewcount + 1 WHERE id = 748
64 0.0001 9.7990036010742E-5
SELECT * FROM manufacturers WHERE id = '176'
65 0.0001 0.00012922286987305
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
66 0.0001 0.00011491775512695
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '176' LIMIT 1
67 0.0002 0.00020790100097656
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.00012302398681641
SELECT * FROM productimages WHERE product_id = '828' ORDER BY sortorder ASC
69 0.0001 0.00011801719665527
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
70 0.0001 0.0001218318939209
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 6.2942504882812E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '176'
72 0.0001 7.2956085205078E-5
SELECT category_id FROM products_categories WHERE product_id = '748'
73 0.0001 8.2969665527344E-5
SELECT * FROM categories WHERE id = '29'
74 0.0002 0.00020384788513184
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 6.103515625E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0001 7.2002410888672E-5
SELECT id FROM categories WHERE parent_id = '29'
77 0.0002 0.0002129077911377
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 7.7962875366211E-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 8.4877014160156E-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 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0001 9.7990036010742E-5
SELECT * FROM productimages WHERE product_id = '748' ORDER BY sortorder ASC
82 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '748'
83 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '748'
84 0.0001 0.00014781951904297
SELECT * FROM productfeeds WHERE product_id = '748' ORDER BY item_date DESC
85 0.0002 0.00023889541625977
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.00021600723266602
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.0005 0.00051999092102051
SELECT * FROM productamazoncontent WHERE product_id = '748'
88 0.0005 0.00045108795166016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
89 0.0002 0.00016379356384277
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
90 0.0001 0.00010395050048828
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
91 0.0001 0.00011181831359863
SELECT * FROM productoffers
                WHERE product_id = 748
                ORDER BY price ASC LIMIT 1
92 0.0001 0.00011110305786133
SELECT value FROM productattributes
                WHERE product_id = '748'
                AND name = 'ListPriceAmount'
93 0.0001 0.00012993812561035
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0001 0.00014495849609375
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
95 0.0007 0.00068998336791992
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
96 0.0001 0.0001378059387207
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
97 0.0001 0.00011897087097168
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
98 0.0007 0.00072884559631348
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
99 0.0001 0.00013089179992676
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
100 0.0001 0.00011491775512695
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
101 0.0001 0.00011110305786133
SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
102 0.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '724'
103 0.0001 9.2029571533203E-5
SELECT * FROM productcustomimages WHERE product_id = '724'
104 0.0002 0.00024914741516113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
105 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
106 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '724' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0001 0.00012302398681641
SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
109 0.0001 0.00012993812561035
SELECT * FROM product_image_select WHERE product_id = '739'
110 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '739'
111 0.0003 0.00033783912658691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
112 0.0003 0.00034999847412109
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'ATVPDKIKX0DER'
113 0.0001 0.00011777877807617
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0001 0.00014185905456543
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
116 0.0001 0.00012993812561035
SELECT * FROM product_image_select WHERE product_id = '740'
117 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '740'
118 0.0004 0.00040602684020996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
119 0.0003 0.00034499168395996
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'ATVPDKIKX0DER'
120 0.0001 0.00011587142944336
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0001 0.00013017654418945
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0001 7.7962875366211E-5
SELECT id,asin FROM products WHERE parent_id = 748
123 0.0001 8.702278137207E-5
SELECT category_id FROM products_categories WHERE product_id = '748'
124 0.0001 8.7976455688477E-5
SELECT * FROM categories WHERE id = '29'
125 0.0002 0.00020599365234375
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
126 0.0001 6.3896179199219E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
127 0.0001 6.6995620727539E-5
SELECT id FROM categories WHERE parent_id = '29'
128 0.0002 0.00020289421081543
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 
129 0.0001 7.7009201049805E-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 
130 0.0001 8.5830688476562E-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
131 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
132 0.0005 0.00047183036804199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
133 0.0001 9.3936920166016E-5
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
134 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = 748
                ORDER BY price ASC LIMIT 1
136 0.0001 0.00011610984802246
SELECT value FROM productattributes
                WHERE product_id = '748'
                AND name = 'ListPriceAmount'
137 0.0001 0.00010991096496582
SELECT * FROM products WHERE id = '748'
138 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0004 0.00043988227844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '748' AND a.name = n.originalname
140 0.0001 9.1075897216797E-5
SELECT * FROM productoffers WHERE product_id = '748' AND merchantid = 'ATVPDKIKX0DER'
141 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '748' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0001 8.8930130004883E-5
SELECT * FROM productoffers
                WHERE product_id = 748
                ORDER BY price ASC LIMIT 1
143 0.0001 0.0001220703125
SELECT value FROM productattributes
                WHERE product_id = '748'
                AND name = 'ListPriceAmount'
144 0.0001 8.2969665527344E-5
SELECT category_id FROM products_categories WHERE product_id = '748' AND prod_type = 'amz'
145 0.0001 6.6995620727539E-5
SELECT parent_id FROM categories WHERE id = '29'
146 0.0001 8.1062316894531E-5
SELECT * FROM categories WHERE id = '29'
147 0.0002 0.00018620491027832
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
148 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
149 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '29'
150 0.0002 0.0002129077911377
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 
151 0.0001 7.4863433837891E-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 
152 0.0001 8.392333984375E-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
153 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
154 0.0002 0.00016188621520996
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
155 0.0001 0.00012898445129395
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
156 0.0001 8.5115432739258E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
157 0.0001 0.00010180473327637
SELECT * FROM pages WHERE id = 38
158 0.0001 8.4161758422852E-5
SELECT * FROM categories WHERE id = '27'
159 0.0002 0.00016403198242188
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
160 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
161 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '27'
162 0.0002 0.00017595291137695
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 
163 0.0001 7.7009201049805E-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 
164 0.0001 0.00010013580322266
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
165 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
166 0.0001 0.00014591217041016
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
167 0.0001 6.3896179199219E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0002 0.00015997886657715
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 
169 0.0001 7.7009201049805E-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 
170 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
171 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '27'
173 0.0002 0.00020194053649902
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
174 0.0001 0.00011920928955078
SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
175 0.0001 0.0001218318939209
SELECT * FROM categoryimages WHERE category_id = 27
176 0.0001 7.2002410888672E-5
SELECT * FROM categorygroups WHERE id = '1'
177 0.0002 0.00019121170043945
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
178 0.0001 9.5844268798828E-5
SELECT * FROM categories WHERE id = '30'
179 0.0002 0.00022006034851074
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
180 0.0001 7.4863433837891E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
181 0.0001 6.6995620727539E-5
SELECT id FROM categories WHERE parent_id = '30'
182 0.0002 0.00023412704467773
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 
183 0.0001 7.6055526733398E-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 
184 0.0001 8.392333984375E-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
185 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
186 0.0002 0.00022101402282715
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
187 0.0001 5.9843063354492E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
188 0.0002 0.00024509429931641
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 
189 0.0001 7.2956085205078E-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 
190 0.0001 8.2969665527344E-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
191 0.0001 5.8174133300781E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
192 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '30'
193 0.0003 0.00028419494628906
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
194 0.0001 0.00011110305786133
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
195 0.0001 7.1048736572266E-5
SELECT * FROM categoryimages WHERE category_id = 30
196 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
197 0.0002 0.00024199485778809
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
198 0.0001 9.0122222900391E-5
SELECT * FROM pages WHERE id = 59
199 0.0001 8.8214874267578E-5
SELECT * FROM pages WHERE id = 55
200 0.0002 0.00015807151794434
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
201 0.0001 9.8943710327148E-5
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:1674926667;s:8:\"products\";a:0:{}}' WHERE id = '8'
202 0.0002 0.00019979476928711
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
203 0.0001 9.1075897216797E-5
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:1674926667;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'
204 0.0001 0.00010991096496582
SELECT * FROM products WHERE id = 7004
205 0.0001 0.0001070499420166
SELECT * FROM products WHERE id = 7011
206 0.0001 0.00010395050048828
SELECT * FROM products WHERE id = 7045
207 0.0001 0.00010800361633301
SELECT * FROM products WHERE id = '7004'
208 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
209 0.0001 0.00013184547424316
SELECT * FROM product_image_select WHERE product_id = '7004'
210 0.0001 0.0001060962677002
SELECT * FROM productcustomimages WHERE product_id = '7004'
211 0.0005 0.00051593780517578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
212 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
213 0.0001 0.00011181831359863
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00015401840209961
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7011'
216 0.0001 0.00010013580322266
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
217 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7011'
218 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
219 0.0006 0.00058293342590332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
220 0.0001 9.5844268798828E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
221 0.0001 9.9897384643555E-5
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0001 9.608268737793E-5
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
223 0.0001 0.00011086463928223
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
224 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7045'
225 0.0001 9.4890594482422E-5
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
226 0.0001 0.00014710426330566
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
227 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7045'
228 0.0001 8.7976455688477E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
229 0.0001 0.00013279914855957
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
230 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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
231 0.0001 0.00011086463928223
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
232 0.0006 0.00059080123901367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
233 0.0001 9.4175338745117E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
234 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0001 9.1075897216797E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
236 0.0001 0.0001070499420166
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
237 0.0001 0.00014209747314453
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
238 0.0002 0.00015616416931152
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
239 0.0001 0.0001068115234375
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
240 0.0001 0.00013899803161621
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0002 0.00015401840209961
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
242 0.0001 0.00014209747314453
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
243 0.0002 0.00024604797363281
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
244 0.0002 0.00016903877258301
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
245 0.0004 0.00037097930908203
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
246 0.0002 0.00024104118347168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
247 0.0001 0.00014090538024902
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
248 0.0001 0.00014901161193848
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
249 0.0001 0.00012612342834473
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'