US Marine Corps Pill Box Keepsake United States Military Patriotic Collectibles

Price: $23.95
Product prices and availability are accurate as of 2022-08-16 21:47:25 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: 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.45755791664124 246 0.0983 0


No Amazon API Requests Made.


App Debug - Total Time 0.45755791664124 seconds

Number Time From Start Name Description
1 0.33508205413818 Initialise Initialise FSB Function
2 0.33657503128052 App Controller Start Start of the App controller (called before the controller of every page)
3 0.34304404258728 Start of getCategoryListByGroup Function Before first category groups query
4 0.34320592880249 After initial query Before first category groups query
5 0.34320592880249 Get Category List for Group Before the call to getCategoryList function
6 0.3432080745697 Start of GetCategoryList function Start of the function
7 0.34321093559265 Before getting categories Query to get specific category list
8 0.34340000152588 After getting categories Query to get specific category list
9 0.34340000152588 Before getting category custom Before call to function getCategoryCustom
10 0.34485507011414 After getting category custom After call to function getCategoryCustom
11 0.34486103057861 Before getting category custom Before call to function getCategoryCustom
12 0.34608793258667 After getting category custom After call to function getCategoryCustom
13 0.34608912467957 Before getting category custom Before call to function getCategoryCustom
14 0.34736514091492 After getting category custom After call to function getCategoryCustom
15 0.34736609458923 Before getting category custom Before call to function getCategoryCustom
16 0.3484411239624 After getting category custom After call to function getCategoryCustom
17 0.34844207763672 End of GetCategoryList function End of the function
18 0.34844493865967 Get Category List for Group Before the call to getCategoryList function
19 0.34844613075256 Start of GetCategoryList function Start of the function
20 0.3484480381012 Before getting categories Query to get specific category list
21 0.34858703613281 End of getCategoryListByGroup Function Before return()
22 0.40097498893738 App Controller End End of the App controller (called before the controller of every page)
23 0.40175199508667 Product Start Start of the product info controller
24 0.40314412117004 Cache file not found Starting get product details
25 0.41029596328735 Related products Start getting related products if enabled
26 0.41029691696167 Related Products Start Before the related products are found
27 0.41029691696167 Related Products Keywords Before the related product keywords are found
28 0.41030097007751 Create Keyword List Function Start of function
29 0.41038012504578 Create Keyword List Function After looping provided content - 30 keywords found
30 0.41114497184753 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
31 0.41115498542786 Create Keyword List Function After reducing keyword list
32 0.41121196746826 Create Keyword List Function After selecting by scoring keywords
33 0.41121602058411 Create Keyword List Function After final loop of keywords
34 0.41121697425842 Related Products Keywords After the related product keywords are found
35 0.41750597953796 Related Products End After the related products are found
36 0.42199301719666 Product End End of the product info controller (Product Info)
37 0.42294812202454 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.42321801185608 Before Get Options Before the call to getOptions in the tpl class
39 0.43901896476746 After Get Options After the call to getOptions in the tpl class
40 0.43913102149963 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.43915104866028 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.44808411598206 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.44808602333069 Product Info: Before Template Display Before the template is displayed
44 0.45754313468933 Product Info: After Template Display After the template is displayed
45 0.45754909515381 Finalizing debug Before the debug is output to the page.
46 0.45755696296692 End of App This is the end of the app logging, final timestamp


Query Debug - 246 Database Queries. Total time 0.0983 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00022983551025391
SELECT parameter, value FROM parameters
2 0.0004 0.00036311149597168
SELECT * FROM `bad_bots`
3 0.0002 0.00015807151794434
SET time_zone = 'Europe/London'
4 0.0002 0.00018906593322754
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0005 0.00049090385437012
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.200.171.74\";}'
6 0.0004 0.00036406517028809
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1660772712'
7 0.0003 0.00033092498779297
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00018310546875
UPDATE autorun SET lastrun = '2022-08-17 21:45:12' WHERE id = '16'
9 0.0001 0.00012302398681641
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00018191337585449
SELECT id FROM pages WHERE pagename = 'us-marine-corps-pill-box-keepsake-united-states-military-patriotic' LIMIT 1
11 0.0007 0.00071191787719727
SELECT id FROM products WHERE pagename = 'us-marine-corps-pill-box-keepsake-united-states-military-patriotic' AND hidden = 0 LIMIT 1
12 0.0004 0.00037097930908203
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0055 0.005518913269043
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0001 0.00012993812561035
SELECT * FROM pages WHERE pagename = 'us-marine-corps-pill-box-keepsake-united-states-military-patriotic'
15 0.0001 0.0001380443572998
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0002 0.00017499923706055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00028800964355469
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.00015592575073242
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.00011301040649414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 9.7036361694336E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00021696090698242
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.00012588500976562
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.0001530647277832
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.00011301040649414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.6784362792969E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0003 0.00025606155395508
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.00010204315185547
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 7.319450378418E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00026416778564453
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 9.9897384643555E-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.4148178100586E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 0.00010085105895996
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00028204917907715
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.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 9.1075897216797E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00029516220092773
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 9.7036361694336E-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.7990036010742E-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.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 8.5115432739258E-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 0.00010585784912109
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.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00019383430480957
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.4877014160156E-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 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 (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 8.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00012993812561035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0005 0.00050616264343262
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0004 0.00041604042053223
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00019192695617676
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.0002140998840332
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00033211708068848
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0491 0.049120903015137
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.171.74') >= INET_ATON(ip_start) AND INET_ATON('44.200.171.74') <= INET_ATON(ip_end)
60 0.0005 0.00051593780517578
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0001 0.00014185905456543
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.00020408630371094
SELECT * FROM products WHERE pagename = 'us-marine-corps-pill-box-keepsake-united-states-military-patriotic'
63 0.0008 0.00080990791320801
UPDATE products SET viewcount = viewcount + 1 WHERE id = 805
64 0.0001 0.00012302398681641
SELECT * FROM manufacturers WHERE id = '176'
65 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
66 0.0004 0.00035500526428223
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '176' LIMIT 1
67 0.0002 0.00022721290588379
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.00012397766113281
SELECT * FROM productimages WHERE product_id = '805' ORDER BY sortorder ASC
69 0.0001 0.00013017654418945
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '176'
70 0.0001 0.00014400482177734
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.6055526733398E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '176'
72 0.0001 9.0122222900391E-5
SELECT category_id FROM products_categories WHERE product_id = '805'
73 0.0001 0.00010085105895996
SELECT * FROM categories WHERE id = '29'
74 0.0002 0.00024914741516113
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.6055526733398E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '29'
77 0.0003 0.00025415420532227
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 9.9897384643555E-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.918212890625E-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.0810317993164E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0001 0.00011396408081055
SELECT * FROM productimages WHERE product_id = '805' ORDER BY sortorder ASC
82 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '805'
83 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '805'
84 0.0004 0.00037193298339844
SELECT * FROM productfeeds WHERE product_id = '805' ORDER BY item_date DESC
85 0.0002 0.00021910667419434
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '805' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
86 0.0009 0.00086283683776855
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '805' AND t.hidden = 0 AND display_product = 1
87 0.0006 0.00060486793518066
SELECT * FROM productamazoncontent WHERE product_id = '805'
88 0.0008 0.00081801414489746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '805' AND a.name = n.originalname
89 0.0001 0.00014495849609375
SELECT * FROM productoffers WHERE product_id = '805' AND merchantid = 'ATVPDKIKX0DER'
90 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '805' AND price > 0
                ORDER BY price ASC LIMIT 1
91 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = 805
                ORDER BY price ASC LIMIT 1
92 0.0001 0.00011110305786133
SELECT value FROM productattributes
                WHERE product_id = '805'
                AND name = 'ListPriceAmount'
93 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0002 0.00016212463378906
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.0011 0.001082181930542
SELECT *, MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AND 805 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
96 0.0002 0.0001530647277832
SELECT *, MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AND 805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
97 0.0001 0.00013399124145508
SELECT *, MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('military patriotic collectibles' IN BOOLEAN MODE) AND 805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
98 0.0001 0.00012588500976562
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
99 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '740'
100 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '740'
101 0.0008 0.0008389949798584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
102 0.0003 0.00031614303588867
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'ATVPDKIKX0DER'
103 0.0001 0.00012111663818359
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
104 0.0001 0.00013589859008789
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0001 0.00012302398681641
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
106 0.0001 0.00013613700866699
SELECT * FROM product_image_select WHERE product_id = '739'
107 0.0001 0.00011014938354492
SELECT * FROM productcustomimages WHERE product_id = '739'
108 0.0006 0.00055098533630371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
109 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'ATVPDKIKX0DER'
110 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
111 0.0001 0.00013113021850586
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0001 0.00012016296386719
SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
113 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '724'
114 0.0001 0.00010013580322266
SELECT * FROM productcustomimages WHERE product_id = '724'
115 0.0003 0.00026607513427734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
116 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
117 0.0001 0.00011706352233887
SELECT * FROM productoffers
                WHERE product_id = '724' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0001 0.00012397766113281
SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0001 8.2969665527344E-5
SELECT id,asin FROM products WHERE parent_id = 805
120 0.0001 8.392333984375E-5
SELECT category_id FROM products_categories WHERE product_id = '805'
121 0.0001 9.9897384643555E-5
SELECT * FROM categories WHERE id = '29'
122 0.0002 0.00024795532226562
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
123 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
124 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '29'
125 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 
126 0.0001 8.6069107055664E-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 
127 0.0001 0.00010395050048828
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
128 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
129 0.0004 0.00039196014404297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '805' AND a.name = n.originalname
130 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '805' AND merchantid = 'ATVPDKIKX0DER'
131 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '805' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0001 9.9897384643555E-5
SELECT * FROM productoffers
                WHERE product_id = 805
                ORDER BY price ASC LIMIT 1
133 0.0001 0.00011491775512695
SELECT value FROM productattributes
                WHERE product_id = '805'
                AND name = 'ListPriceAmount'
134 0.0001 0.00011801719665527
SELECT * FROM products WHERE id = '805'
135 0.0001 0.00012302398681641
SELECT value FROM productattributes WHERE product_id = '805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.0003819465637207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '805' AND a.name = n.originalname
137 0.0001 9.5129013061523E-5
SELECT * FROM productoffers WHERE product_id = '805' AND merchantid = 'ATVPDKIKX0DER'
138 0.0001 0.00010418891906738
SELECT * FROM productoffers
                WHERE product_id = '805' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0001 0.00010204315185547
SELECT * FROM productoffers
                WHERE product_id = 805
                ORDER BY price ASC LIMIT 1
140 0.0001 0.0001060962677002
SELECT value FROM productattributes
                WHERE product_id = '805'
                AND name = 'ListPriceAmount'
141 0.0001 8.8930130004883E-5
SELECT category_id FROM products_categories WHERE product_id = '805' AND prod_type = 'amz'
142 0.0001 7.6055526733398E-5
SELECT parent_id FROM categories WHERE id = '29'
143 0.0001 8.9883804321289E-5
SELECT * FROM categories WHERE id = '29'
144 0.0002 0.00022482872009277
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
145 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
146 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '29'
147 0.0002 0.00024700164794922
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 
148 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 (29)
				  AND p.disabled = 0 
149 0.0001 9.3936920166016E-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
150 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
151 0.0004 0.00036406517028809
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
152 0.0001 0.00013399124145508
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
153 0.0001 7.9870223999023E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
154 0.0001 0.00010514259338379
SELECT * FROM pages WHERE id = 38
155 0.0001 9.2983245849609E-5
SELECT * FROM categories WHERE id = '27'
156 0.0002 0.00019097328186035
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
157 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
158 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
159 0.0002 0.00020217895507812
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 
160 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 (27)
				  AND p.disabled = 0 
161 0.0001 9.5844268798828E-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
162 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
163 0.0002 0.00016999244689941
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
164 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0002 0.00018596649169922
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 
166 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 (27)
				  AND p.disabled = 0 
167 0.0001 9.3936920166016E-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
168 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '27'
170 0.0002 0.00021195411682129
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
171 0.0001 0.00012707710266113
SELECT * FROM productimages WHERE product_id = '750' ORDER BY sortorder ASC
172 0.0001 0.00012588500976562
SELECT * FROM categoryimages WHERE category_id = 27
173 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
174 0.0002 0.00019979476928711
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
175 0.0001 0.0001070499420166
SELECT * FROM categories WHERE id = '30'
176 0.0003 0.0002739429473877
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
177 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
178 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
179 0.0003 0.00029897689819336
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 
180 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 (30)
				  AND p.disabled = 0 
181 0.0001 0.0001060962677002
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
182 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
183 0.0003 0.00026106834411621
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
184 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
185 0.0003 0.00028705596923828
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 
186 0.0001 7.9154968261719E-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 
187 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
188 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
189 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
190 0.0003 0.00029206275939941
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
191 0.0001 0.00013399124145508
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
192 0.0001 7.8916549682617E-5
SELECT * FROM categoryimages WHERE category_id = 30
193 0.0001 7.9870223999023E-5
SELECT * FROM categorygroups WHERE id = '1'
194 0.0003 0.00030088424682617
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
195 0.0001 9.9897384643555E-5
SELECT * FROM pages WHERE id = 59
196 0.0001 9.7036361694336E-5
SELECT * FROM pages WHERE id = 55
197 0.0001 0.00014495849609375
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
198 0.0001 0.00012683868408203
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:1660772712;s:8:\"products\";a:0:{}}' WHERE id = '8'
199 0.0002 0.00021886825561523
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
200 0.0001 0.00011301040649414
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:1660772712;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'
201 0.0001 0.00011706352233887
SELECT * FROM products WHERE id = 7004
202 0.0001 0.00011086463928223
SELECT * FROM products WHERE id = 7011
203 0.0001 0.00010991096496582
SELECT * FROM products WHERE id = 7045
204 0.0001 0.00011110305786133
SELECT * FROM products WHERE id = '7004'
205 0.0001 0.00013399124145508
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
206 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7004'
207 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
208 0.0005 0.00048422813415527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
209 0.0001 0.00011181831359863
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
210 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0001 0.00014090538024902
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0001 0.00012612342834473
SELECT * FROM products WHERE id = '7011'
213 0.0001 0.0001070499420166
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
214 0.0001 0.00013613700866699
SELECT * FROM product_image_select WHERE product_id = '7011'
215 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
216 0.0006 0.0005500316619873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
217 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
218 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0001 0.00010108947753906
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
220 0.0001 0.00011897087097168
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
221 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = '7045'
222 0.0001 0.00010013580322266
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
223 0.0001 0.00013899803161621
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
224 0.0001 0.00014805793762207
SELECT * FROM product_image_select WHERE product_id = '7045'
225 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
226 0.0001 0.00013589859008789
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
227 0.0003 0.00025296211242676
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
228 0.0001 0.00011491775512695
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
229 0.0005 0.00053286552429199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
230 0.0001 9.608268737793E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
231 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0001 9.7036361694336E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
233 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
234 0.0001 0.00013303756713867
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
235 0.0002 0.00018501281738281
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
236 0.0001 0.00011301040649414
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
237 0.0001 0.00014090538024902
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0002 0.00015902519226074
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
239 0.0001 0.00014901161193848
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
240 0.0003 0.00025010108947754
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
241 0.0002 0.00018000602722168
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
242 0.0011 0.0010709762573242
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
243 0.0002 0.00022387504577637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
244 0.0002 0.00018215179443359
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
245 0.0002 0.00018405914306641
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
246 0.0001 0.00013995170593262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'