H is for Honor: A Military Family Alphabet

Price: $17.95 $16.14
You Save: $1.81 (10%)
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

Used Book in Good Condition

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.41147208213806 240 0.0703 0


No Amazon API Requests Made.


App Debug - Total Time 0.41147208213806 seconds

Number Time From Start Name Description
1 0.32464504241943 Initialise Initialise FSB Function
2 0.32533597946167 App Controller Start Start of the App controller (called before the controller of every page)
3 0.32999706268311 Start of getCategoryListByGroup Function Before first category groups query
4 0.33010411262512 After initial query Before first category groups query
5 0.33010506629944 Get Category List for Group Before the call to getCategoryList function
6 0.33010697364807 Start of GetCategoryList function Start of the function
7 0.33010911941528 Before getting categories Query to get specific category list
8 0.33025813102722 After getting categories Query to get specific category list
9 0.33025908470154 Before getting category custom Before call to function getCategoryCustom
10 0.33153510093689 After getting category custom After call to function getCategoryCustom
11 0.33153700828552 Before getting category custom Before call to function getCategoryCustom
12 0.33275294303894 After getting category custom After call to function getCategoryCustom
13 0.33275413513184 Before getting category custom Before call to function getCategoryCustom
14 0.33405208587646 After getting category custom After call to function getCategoryCustom
15 0.33405303955078 Before getting category custom Before call to function getCategoryCustom
16 0.33512496948242 After getting category custom After call to function getCategoryCustom
17 0.33512616157532 End of GetCategoryList function End of the function
18 0.33512902259827 Get Category List for Group Before the call to getCategoryList function
19 0.33512997627258 Start of GetCategoryList function Start of the function
20 0.33513212203979 Before getting categories Query to get specific category list
21 0.33525204658508 End of getCategoryListByGroup Function Before return()
22 0.36686515808105 App Controller End End of the App controller (called before the controller of every page)
23 0.36732912063599 Product Start Start of the product info controller
24 0.36803793907166 Cache file not found Starting get product details
25 0.37361097335815 Related products Start getting related products if enabled
26 0.37361097335815 Related Products Start Before the related products are found
27 0.37361216545105 Related Products Keywords Before the related product keywords are found
28 0.373615026474 Create Keyword List Function Start of function
29 0.37368607521057 Create Keyword List Function After looping provided content - 21 keywords found
30 0.37414503097534 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
31 0.37415599822998 Create Keyword List Function After reducing keyword list
32 0.37419009208679 Create Keyword List Function After selecting by scoring keywords
33 0.37419295310974 Create Keyword List Function After final loop of keywords
34 0.37419414520264 Related Products Keywords After the related product keywords are found
35 0.37913298606873 Related Products End After the related products are found
36 0.3836350440979 Product End End of the product info controller (Product Info)
37 0.3841609954834 App_after Controller Start Start of the App_after controller (called after the controller of every page)
38 0.38442707061768 Before Get Options Before the call to getOptions in the tpl class
39 0.39991211891174 After Get Options After the call to getOptions in the tpl class
40 0.40002512931824 App_after Controller End End of the App_after controller (called after the controller of every page)
41 0.4000461101532 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
42 0.40336513519287 Product Info: After Smarty Fetch After the product.tpl template is fetched
43 0.40336799621582 Product Info: Before Template Display Before the template is displayed
44 0.41146016120911 Product Info: After Template Display After the template is displayed
45 0.41146397590637 Finalizing debug Before the debug is output to the page.
46 0.41147208213806 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.0703 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00024986267089844
SELECT parameter, value FROM parameters
2 0.0004 0.00037908554077148
SELECT * FROM `bad_bots`
3 0.0002 0.00020217895507812
SET time_zone = 'Europe/London'
4 0.0001 0.00014615058898926
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00017905235290527
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.173.214.227\";}'
6 0.0001 0.0001070499420166
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642887724'
7 0.0003 0.00025296211242676
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00018501281738281
UPDATE autorun SET lastrun = '2022-01-22 21:42:04' WHERE id = '13'
9 0.0001 0.00011992454528809
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0001 0.00014019012451172
SELECT id FROM pages WHERE pagename = 'h-is-for-honor-a-military-family-alphabet' LIMIT 1
11 0.0001 0.00014996528625488
SELECT id FROM products WHERE pagename = 'h-is-for-honor-a-military-family-alphabet' AND hidden = 0 LIMIT 1
12 0.0004 0.00036883354187012
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0037 0.0037350654602051
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0001 0.00012516975402832
SELECT * FROM pages WHERE pagename = 'h-is-for-honor-a-military-family-alphabet'
15 0.0001 9.7036361694336E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0001 0.00013494491577148
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00026416778564453
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.0001 0.00011396408081055
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 7.7009201049805E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 9.5129013061523E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00021982192993164
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 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 (27)
				  AND p.disabled = 0 
23 0.0001 0.00013017654418945
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 9.2983245849609E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 9.4890594482422E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00023603439331055
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.00011801719665527
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.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 8.082389831543E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00025796890258789
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 0.00011110305786133
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.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00029301643371582
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.7036361694336E-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 6.9856643676758E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00031685829162598
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.4877014160156E-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 0.00011205673217773
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.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00017809867858887
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.7036361694336E-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.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.9168548583984E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00019216537475586
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 9.0122222900391E-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.2002410888672E-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.00011086463928223
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0005 0.00049304962158203
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0002 0.00017690658569336
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.0001828670501709
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.00023007392883301
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00033116340637207
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0290 0.029032945632935
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.0002 0.00019502639770508
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0001 0.00010108947753906
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.0002138614654541
SELECT * FROM products WHERE pagename = 'h-is-for-honor-a-military-family-alphabet'
63 0.0002 0.00015115737915039
UPDATE products SET viewcount = viewcount + 1 WHERE id = 813
64 0.0001 0.00011491775512695
SELECT * FROM manufacturers WHERE id = '180'
65 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '180'
66 0.0001 0.0001370906829834
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '180' LIMIT 1
67 0.0002 0.00021719932556152
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '180' ORDER BY RAND() LIMIT 1
68 0.0001 0.00013995170593262
SELECT * FROM productimages WHERE product_id = '757' ORDER BY sortorder ASC
69 0.0001 0.00012898445129395
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '180'
70 0.0001 0.00013899803161621
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '180'
				  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 = '180'
72 0.0001 0.0001060962677002
SELECT category_id FROM products_categories WHERE product_id = '813'
73 0.0001 9.6797943115234E-5
SELECT * FROM categories WHERE id = '30'
74 0.0003 0.00027704238891602
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
75 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
76 0.0001 8.0108642578125E-5
SELECT id FROM categories WHERE parent_id = '30'
77 0.0003 0.00028800964355469
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 
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 (30)
				  AND p.disabled = 0 
79 0.0001 0.00012898445129395
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
80 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
81 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '813' ORDER BY sortorder ASC
82 0.0002 0.00019216537475586
SELECT * FROM product_image_select WHERE product_id = '813'
83 0.0001 0.00014281272888184
SELECT * FROM productcustomimages WHERE product_id = '813'
84 0.0001 0.00013899803161621
SELECT * FROM productfeeds WHERE product_id = '813' ORDER BY item_date DESC
85 0.0003 0.00026512145996094
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '813' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
86 0.0002 0.00020003318786621
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '813' AND t.hidden = 0 AND display_product = 1
87 0.0004 0.00042891502380371
SELECT * FROM productamazoncontent WHERE product_id = '813'
88 0.0005 0.00046706199645996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '813' AND a.name = n.originalname
89 0.0002 0.00015807151794434
SELECT * FROM productoffers WHERE product_id = '813' AND merchantid = 'ATVPDKIKX0DER'
90 0.0001 0.00012493133544922
SELECT * FROM productoffers
                WHERE product_id = '813' AND price > 0
                ORDER BY price ASC LIMIT 1
91 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '813' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
92 0.0002 0.00017285346984863
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.0009 0.00090694427490234
SELECT *, MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AND 813 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
94 0.0002 0.00015592575073242
SELECT *, MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AND 813 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
95 0.0001 0.00014781951904297
SELECT *, MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('military family alphabet' IN BOOLEAN MODE) AND 813 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
96 0.0001 0.00013899803161621
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
97 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '740'
98 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '740'
99 0.0004 0.00041007995605469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
100 0.0001 0.00012683868408203
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'ATVPDKIKX0DER'
101 0.0001 0.0001380443572998
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0001 0.00012302398681641
SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
104 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '724'
105 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '724'
106 0.0003 0.00026583671569824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
107 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
108 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '724' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0001 0.00012493133544922
SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
111 0.0001 0.00014114379882812
SELECT * FROM product_image_select WHERE product_id = '739'
112 0.0001 0.00010013580322266
SELECT * FROM productcustomimages WHERE product_id = '739'
113 0.0003 0.00034308433532715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
114 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'ATVPDKIKX0DER'
115 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0001 0.00012993812561035
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0001 8.4161758422852E-5
SELECT id,asin FROM products WHERE parent_id = 813
118 0.0001 8.7976455688477E-5
SELECT category_id FROM products_categories WHERE product_id = '813'
119 0.0001 0.00010800361633301
SELECT * FROM categories WHERE id = '30'
120 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 = 30
121 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
122 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
123 0.0003 0.0002892017364502
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 
124 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 (30)
				  AND p.disabled = 0 
125 0.0001 0.00010895729064941
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
126 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
127 0.0004 0.00041103363037109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '813' AND a.name = n.originalname
128 0.0001 0.0001060962677002
SELECT * FROM productoffers WHERE product_id = '813' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '813' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = '813'
131 0.0001 0.00014901161193848
SELECT value FROM productattributes WHERE product_id = '813' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0005 0.00045204162597656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '813' AND a.name = n.originalname
133 0.0001 0.00011610984802246
SELECT * FROM productoffers WHERE product_id = '813' AND merchantid = 'ATVPDKIKX0DER'
134 0.0001 0.00012612342834473
SELECT * FROM productoffers
                WHERE product_id = '813' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0001 0.0001070499420166
SELECT category_id FROM products_categories WHERE product_id = '813' AND prod_type = 'amz'
136 0.0001 8.5115432739258E-5
SELECT parent_id FROM categories WHERE id = '30'
137 0.0001 0.00010108947753906
SELECT * FROM categories WHERE id = '30'
138 0.0003 0.00026893615722656
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
139 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
140 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
141 0.0003 0.00028491020202637
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 
142 0.0001 0.00010180473327637
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 
143 0.0001 0.00010895729064941
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
144 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
145 0.0002 0.0001528263092041
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
146 0.0001 0.00011897087097168
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
147 0.0001 9.4175338745117E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
148 0.0001 0.0001060962677002
SELECT * FROM pages WHERE id = 38
149 0.0001 0.00010395050048828
SELECT * FROM categories WHERE id = '27'
150 0.0002 0.00018191337585449
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
151 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
152 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '27'
153 0.0002 0.00019192695617676
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 
154 0.0001 0.00010108947753906
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 
155 0.0001 0.00010800361633301
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
156 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
157 0.0002 0.00017094612121582
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
158 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
159 0.0002 0.00019097328186035
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.0108642578125E-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 8.8930130004883E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
163 0.0001 8.082389831543E-5
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00022220611572266
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
165 0.0001 0.00011897087097168
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
166 0.0001 0.00012302398681641
SELECT * FROM categoryimages WHERE category_id = 27
167 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups WHERE id = '1'
168 0.0002 0.00020980834960938
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
169 0.0001 0.00011610984802246
SELECT * FROM categories WHERE id = '30'
170 0.0003 0.00027704238891602
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
171 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
172 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
173 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 
174 0.0001 8.0108642578125E-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 
175 0.0001 0.00011491775512695
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
176 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
177 0.0003 0.00027990341186523
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
178 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
179 0.0003 0.00028109550476074
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 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 
181 0.0001 9.2983245849609E-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
182 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
183 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
184 0.0003 0.00030684471130371
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
185 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
186 0.0001 7.9870223999023E-5
SELECT * FROM categoryimages WHERE category_id = 30
187 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
188 0.0003 0.00031304359436035
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
189 0.0001 0.00010800361633301
SELECT * FROM pages WHERE id = 59
190 0.0001 9.8943710327148E-5
SELECT * FROM pages WHERE id = 55
191 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
192 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:1642887724;s:8:\"products\";a:0:{}}' WHERE id = '8'
193 0.0002 0.0002138614654541
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
194 0.0001 0.00011706352233887
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:1642887724;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'
195 0.0001 0.00012993812561035
SELECT * FROM products WHERE id = 7004
196 0.0001 0.00011420249938965
SELECT * FROM products WHERE id = 7011
197 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
198 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7004'
199 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
200 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7004'
201 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
202 0.0005 0.00049901008605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
203 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
204 0.0001 0.00012493133544922
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0001 0.00014591217041016
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0001 0.00013899803161621
SELECT * FROM products WHERE id = '7011'
207 0.0001 0.00010991096496582
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
208 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7011'
209 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
210 0.0006 0.00055599212646484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
211 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
212 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0001 0.00010299682617188
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
214 0.0001 0.00012707710266113
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
215 0.0001 0.00011610984802246
SELECT * FROM products WHERE id = '7045'
216 0.0001 0.00010204315185547
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
217 0.0002 0.00017189979553223
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
218 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '7045'
219 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
220 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
221 0.0003 0.0002598762512207
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
222 0.0001 0.00011706352233887
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
223 0.0006 0.00055193901062012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
224 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
225 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0001 9.8943710327148E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
227 0.0001 0.00011610984802246
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
228 0.0002 0.0001528263092041
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
229 0.0002 0.0001838207244873
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
230 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
231 0.0001 0.00014591217041016
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0002 0.00015711784362793
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
233 0.0002 0.00015711784362793
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
234 0.0002 0.00024795532226562
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
235 0.0002 0.00019001960754395
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
236 0.0004 0.0003969669342041
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
237 0.0002 0.00023818016052246
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
238 0.0002 0.00016188621520996
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
239 0.0002 0.0001978874206543
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
240 0.0001 0.00014305114746094
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'