0 items

Books

How You Can Maximize Student Aid: Strate...

only $24.99

Buy at Amazon

Add to Cart

Military Divorce Tips: Health Care, CHCB...

only $29.99

Buy at Amazon

Add to Cart

YouTube Seo Ranking Checklists: Targeted...

only $14.51

Buy at Amazon

Add to Cart

Make Money Online Using Zazzle: Internet...

only $19.99

Buy at Amazon

Add to Cart

The Kid's ROTH IRA Handbook: Securing Ta...

only $19.99

Buy at Amazon

Add to Cart

The Military Family: A Casualty of War

only $19.99

Buy at Amazon

Add to Cart

Now You Tell Me! 12 Army Wives Give the ...

only $28.07

Buy at Amazon

Add to Cart

11 Mistakes Couples Make During Deployme...

only $5.50

Buy at Amazon

Add to Cart

I'm a Work-at-Home Mommy--You can be too...

only $16.95

Buy at Amazon

Add to Cart

The Military Divorce Handbook: A Practic...

$179.95 $149.99

Buy at Amazon

Add to Cart

Effects of the Uniformed Services Former...

only $49.00

Buy at Amazon

Add to Cart

Make Money on Amazon Video Direct: The B...

only $19.99

Buy at Amazon

Add to Cart

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
0.50005078315735	302	0.0807	0

No Amazon API Requests Made.

App Debug - Total Time 0.50005078315735 seconds

Number	Time From Start	Name	Description
1	0.31654500961304	Initialise	Initialise FSB Function
2	0.31773686408997	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.35527992248535	App Controller End	End of the App controller (called before the controller of every page)
4	0.35946893692017	Category Start	Start of the category controller
5	0.3594708442688	Before Get Category	Before getting the category information
6	0.36168098449707	After Get Category	After getting the category information
7	0.36168193817139	Before Get Category List	Before getting the updated category list
8	0.36175799369812	Start of getCategoryListByGroup Function	Before first category groups query
9	0.36183595657349	After initial query	Before first category groups query
10	0.3618369102478	Get Category List for Group	Before the call to getCategoryList function
11	0.36183881759644	Start of GetCategoryList function	Start of the function
12	0.36184096336365	Before getting categories	Query to get specific category list
13	0.36197185516357	After getting categories	Query to get specific category list
14	0.36197185516357	Before getting category custom	Before call to function getCategoryCustom
15	0.36289095878601	After getting category custom	After call to function getCategoryCustom
16	0.36289191246033	Before getting sub category list	Before call to recursive function getCategoryList
17	0.36289286613464	Start of GetCategoryList function	Start of the function
18	0.36289381980896	Before getting categories	Query to get specific category list
19	0.3629949092865	After getting sub category list	After call to recursive function getCategoryList
20	0.36299896240234	Before getting category custom	Before call to function getCategoryCustom
21	0.36398792266846	After getting category custom	After call to function getCategoryCustom
22	0.36398983001709	Before getting category custom	Before call to function getCategoryCustom
23	0.36504101753235	After getting category custom	After call to function getCategoryCustom
24	0.36504292488098	Before getting category custom	Before call to function getCategoryCustom
25	0.36593699455261	After getting category custom	After call to function getCategoryCustom
26	0.36593794822693	End of GetCategoryList function	End of the function
27	0.36594080924988	Get Category List for Group	Before the call to getCategoryList function
28	0.36594080924988	Start of GetCategoryList function	Start of the function
29	0.36594295501709	Before getting categories	Query to get specific category list
30	0.36604595184326	End of getCategoryListByGroup Function	Before return()
31	0.36604690551758	After Get Category List	After getting the updated category list
32	0.36604690551758	Before Category Images	Before getting the category images
33	0.36611986160278	After Category Images	After getting the category images
34	0.36628079414368	Before Sub Category Check	Before checking for sub category or products category
35	0.36638498306274	Before Category Products Controller	Before loading the category products controller
36	0.36693382263184	Start Category Products	Start of Category Products Controller
37	0.36694598197937	After Pagination Options	After pagination options in Category Products Controller
38	0.36713695526123	After Cache	After Cache checking in Category Products Controller
39	0.36908388137817	After Filter Options	After getting filter options and SQL in Category Products Controller
40	0.3694019317627	After Counting Products	After counting products in the Category Products Controller
41	0.36949181556702	After Counting Bundles	After counting bundles in the Category Products Controller
42	0.36958384513855	After Counting Products	After counting products in the Category Products Controller
43	0.37013792991638	After Getting Products	After getting products and bundles in the Category Products Controller
44	0.37016582489014	After Pagination Links	After getting pagination listing links in the Category Products Controller
45	0.37016582489014	After Getting Bundle Details	After getting full details for the bundles in the Category Products Controller
46	0.39031291007996	After Getting Product Details	After getting full product details in the Category Products Controller
47	0.39167380332947	After Getting Product/Bundle Reviews	After getting full product/bundle customer review in the Category Products Controller
48	0.39237689971924	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
49	0.39261794090271	Before Get Options	Before the call to getOptions in the tpl class
50	0.40657997131348	After Get Options	After the call to getOptions in the tpl class
51	0.4066858291626	App_after Controller End	End of the App_after controller (called after the controller of every page)
52	0.40670084953308	Before Smarty	Before passing everything over to Smarty in the Category Products Controller
53	0.50004291534424	After Loading sub/product controller	After checking for sub category or products category and then loading the relevant controller
54	0.50004482269287	Finalizing debug	Before the debug is output to the page.
55	0.50005078315735	End of App	This is the end of the app logging, final timestamp

Query Debug - 302 Database Queries. Total time 0.0807 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679629395'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2023-03-24 03:43:15' WHERE id = '8'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'books' LIMIT 1
SELECT id FROM products WHERE pagename = 'books' AND hidden = 0 LIMIT 1
SELECT id FROM ebay_products WHERE pagename = 'books'
SELECT id FROM custom_products WHERE pagename = 'books'
SELECT id FROM categories WHERE pagename = 'books' LIMIT 1
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'books'
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
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
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM categories WHERE pagename = 'books'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT id FROM categories WHERE parent_id = '27'
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
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 27
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT parent_id FROM categories WHERE id = '27'
SELECT parent_id FROM categories WHERE id = '27'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
SELECT id FROM categories WHERE parent_id = '38'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 27
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
SELECT * FROM categories WHERE parent_id = '27'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 27
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND hide = 0
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 27
			AND p.disabled = 0
			
			AND 1 = 1
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'custom'
		AND hide = 0
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 27
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 27
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
SELECT * FROM products WHERE id = '770'
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '770'
SELECT * FROM productcustomimages WHERE product_id = '770'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '798'
SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '798'
SELECT * FROM productcustomimages WHERE product_id = '798'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '798' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '798' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '798' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '798' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '750'
SELECT * FROM productimages WHERE product_id = '750' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '750'
SELECT * FROM productcustomimages WHERE product_id = '750'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '750' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '750' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '750' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '802'
SELECT * FROM productimages WHERE product_id = '802' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '802'
SELECT * FROM productcustomimages WHERE product_id = '802'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '802' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '802' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '802' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '802' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '807'
SELECT * FROM productimages WHERE product_id = '807' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '807'
SELECT * FROM productcustomimages WHERE product_id = '807'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '807' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '807' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '807' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '764'
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '764'
SELECT * FROM productcustomimages WHERE product_id = '764'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '822'
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '822'
SELECT * FROM productcustomimages WHERE product_id = '822'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '811'
SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '811'
SELECT * FROM productcustomimages WHERE product_id = '811'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '811' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '780'
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '780'
SELECT * FROM productcustomimages WHERE product_id = '780'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '819'
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '819'
SELECT * FROM productcustomimages WHERE product_id = '819'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '819' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '819' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '819' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '819' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '724'
SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '724'
SELECT * FROM productcustomimages WHERE product_id = '724'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '724' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4399'
SELECT * FROM productimages WHERE product_id = '4399' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4399'
SELECT * FROM productcustomimages WHERE product_id = '4399'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4399' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4399' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '4399' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4399' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '798' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '750' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '802' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '807' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '764' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '811' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '780' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '819' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '724' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4399' ORDER BY timestamp DESC
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 27
		AND c.prod_type = 'ebay'
		AND hide = 0
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
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT * FROM pages WHERE id = 38
SELECT * FROM categories WHERE id = '27'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT id FROM categories WHERE parent_id = '27'
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
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 27
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT * FROM categories WHERE id = '30'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT id FROM categories WHERE parent_id = '30'
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
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 30
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT * FROM pages WHERE id = 59
SELECT * FROM pages WHERE id = 55
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
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:1679629395;s:8:\"products\";a:0:{}}' WHERE id = '8'
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
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:1679629395;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'
SELECT * FROM products WHERE id = 7004
SELECT * FROM products WHERE id = 7011
SELECT * FROM products WHERE id = 7045
SELECT * FROM products WHERE id = '7004'
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7004'
SELECT * FROM productcustomimages WHERE product_id = '7004'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '7011'
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7011'
SELECT * FROM productcustomimages WHERE product_id = '7011'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '7045'
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
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
SELECT * FROM product_image_select WHERE product_id = '7045'
SELECT * FROM productcustomimages WHERE product_id = '7045'
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
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
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
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
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
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
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
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
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
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0004	0.0003960132598877	SELECT parameter, value FROM parameters
2	0.0004	0.00042295455932617	SELECT * FROM `bad_bots`
3	0.0002	0.00015497207641602	SET time_zone = 'Europe/London'
4	0.0001	0.0001368522644043	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0002	0.0001838207244873	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6	0.0001	0.00013494491577148	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679629395'
7	0.0003	0.00026297569274902	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0001	0.00012302398681641	UPDATE autorun SET lastrun = '2023-03-24 03:43:15' WHERE id = '8'
9	0.0001	8.4161758422852E-5	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0002	0.00015401840209961	SELECT id FROM pages WHERE pagename = 'books' LIMIT 1
11	0.0002	0.00021195411682129	SELECT id FROM products WHERE pagename = 'books' AND hidden = 0 LIMIT 1
12	0.0001	0.00013899803161621	SELECT id FROM ebay_products WHERE pagename = 'books'
13	0.0001	0.00012922286987305	SELECT id FROM custom_products WHERE pagename = 'books'
14	0.0002	0.00017404556274414	SELECT id FROM categories WHERE pagename = 'books' LIMIT 1
15	0.0003	0.00034189224243164	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
16	0.0036	0.0035750865936279	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
17	0.0001	0.00010204315185547	SELECT * FROM pages WHERE pagename = 'books'
18	0.0005	0.00045919418334961	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19	0.0002	0.00019121170043945	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20	0.0002	0.00021815299987793	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
21	0.0002	0.00017189979553223	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
22	0.0003	0.00028300285339355	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23	0.0308	0.030816078186035	SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
24	0.0002	0.00016903877258301	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25	0.0001	0.00011706352233887	SELECT * FROM countryredirects WHERE countrycode = 'US'
26	0.0001	0.00011205673217773	SELECT * FROM categories WHERE pagename = 'books'
27	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 = 27
28	0.0001	0.00010490417480469	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0001	6.9141387939453E-5	SELECT id FROM categories WHERE parent_id = '27'
30	0.0002	0.00017690658569336	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
31	0.0001	0.00014400482177734	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
32	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 (27) AND c.prod_type = 'custom' AND cp.hide = 0
33	0.0002	0.00015497207641602	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0001	6.6041946411133E-5	SELECT id FROM categories WHERE parent_id = '27'
35	0.0002	0.00018811225891113	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
36	0.0002	0.00016593933105469	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
37	0.0001	0.00011110305786133	SELECT * FROM categoryimages WHERE category_id = 27
38	0.0001	0.00014400482177734	SELECT * FROM categorygroups WHERE id = '1'
39	0.0002	0.0001988410949707	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
40	0.0001	7.0095062255859E-5	SELECT parent_id FROM categories WHERE id = '27'
41	0.0001	6.413459777832E-5	SELECT parent_id FROM categories WHERE id = '27'
42	0.0001	6.8902969360352E-5	SELECT * FROM categorygroups ORDER BY sortorder ASC
43	0.0001	0.00011587142944336	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
44	0.0002	0.00015497207641602	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
45	0.0001	9.0122222900391E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
46	0.0001	5.5074691772461E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
47	0.0001	7.7009201049805E-5	SELECT id FROM categories WHERE parent_id = '27'
48	0.0002	0.00017380714416504	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
49	0.0001	7.2002410888672E-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
50	0.0001	8.082389831543E-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
51	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
52	0.0001	6.6041946411133E-5	SELECT * FROM categorygroups WHERE id = '1'
53	0.0001	9.1791152954102E-5	SELECT * FROM categories WHERE parent_id = '27' AND hidden = 0 ORDER BY sortorder ASC
54	0.0002	0.00019693374633789	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
55	0.0001	8.392333984375E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
56	0.0001	7.0095062255859E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
57	0.0001	7.2956085205078E-5	SELECT id FROM categories WHERE parent_id = '29'
58	0.0002	0.00020313262939453	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
59	0.0001	7.2002410888672E-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
60	0.0001	7.9870223999023E-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
61	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
62	0.0001	6.4849853515625E-5	SELECT * FROM categorygroups WHERE id = '1'
63	0.0002	0.0002281665802002	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
64	0.0001	8.392333984375E-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
65	0.0001	6.8902969360352E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
66	0.0001	6.3896179199219E-5	SELECT id FROM categories WHERE parent_id = '30'
67	0.0002	0.00023794174194336	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
68	0.0001	7.4148178100586E-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
69	0.0001	8.1062316894531E-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
70	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
71	0.0001	6.5088272094727E-5	SELECT * FROM categorygroups WHERE id = '1'
72	0.0002	0.00015091896057129	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
73	0.0001	8.4161758422852E-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
74	0.0001	7.1048736572266E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
75	0.0001	7.2002410888672E-5	SELECT id FROM categories WHERE parent_id = '38'
76	0.0002	0.00016093254089355	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
77	0.0001	7.0095062255859E-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
78	0.0001	7.8916549682617E-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
79	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
80	0.0001	6.6041946411133E-5	SELECT * FROM categorygroups WHERE id = '1'
81	0.0001	9.3936920166016E-5	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
82	0.0001	6.6041946411133E-5	SELECT * FROM categoryimages WHERE category_id = 27
83	0.0001	0.00013518333435059	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
84	0.0001	9.3936920166016E-5	SELECT * FROM categories WHERE parent_id = '27'
85	0.0004	0.00041103363037109	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0004	0.00037097930908203	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0002	0.00015997886657715	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
88	0.0004	0.00039005279541016	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89	0.0004	0.00035786628723145	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90	0.0001	0.00010395050048828	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
91	0.0002	0.00018620491027832	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND parent_id = 0 AND c.category_id = 27 AND (c.prod_type = '' OR c.prod_type = 'amz') AND hidden = 0 AND enabled = 1 AND 1 = 1
92	0.0001	0.00010514259338379	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id = 27 AND c.prod_type = 'ebay' AND hide = 0
93	0.0001	7.5101852416992E-5	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND parent_id = 0 AND c.category_id = 27 AND p.disabled = 0 AND 1 = 1
94	0.0001	8.2015991210938E-5	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id = 27 AND c.prod_type = 'custom' AND hide = 0
95	0.0005	0.0005180835723877	SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c WHERE p.id = c.product_id AND p.parent_id = 0 AND c.category_id = 27 AND hidden = 0 AND enabled = 1 AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c WHERE p.id = c.product_id AND c.category_id = 27 AND c.prod_type = 'ebay' AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c WHERE p.id = c.product_id AND c.category_id = 27 AND c.prod_type = 'custom' AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id = 27 AND disabled = 0 AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
96	0.0001	0.0001220703125	SELECT * FROM products WHERE id = '770'
97	0.0001	0.00013208389282227	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
98	0.0002	0.00017714500427246	SELECT * FROM product_image_select WHERE product_id = '770'
99	0.0001	0.00013399124145508	SELECT * FROM productcustomimages WHERE product_id = '770'
100	0.0004	0.0003960132598877	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
101	0.0002	0.00016498565673828	SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'ATVPDKIKX0DER'
102	0.0001	0.00011587142944336	SELECT * FROM productoffers WHERE product_id = '770' AND price > 0 ORDER BY price ASC LIMIT 1
103	0.0001	0.00012707710266113	SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104	0.0001	0.00011205673217773	SELECT * FROM products WHERE id = '798'
105	0.0001	0.00012016296386719	SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
106	0.0001	0.00012993812561035	SELECT * FROM product_image_select WHERE product_id = '798'
107	0.0001	8.5115432739258E-5	SELECT * FROM productcustomimages WHERE product_id = '798'
108	0.0003	0.00034403800964355	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '798' AND a.name = n.originalname
109	0.0001	0.00010204315185547	SELECT * FROM productoffers WHERE product_id = '798' AND merchantid = 'ATVPDKIKX0DER'
110	0.0001	0.00010919570922852	SELECT * FROM productoffers WHERE product_id = '798' AND price > 0 ORDER BY price ASC LIMIT 1
111	0.0001	0.00012302398681641	SELECT value FROM productattributes WHERE product_id = '798' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112	0.0001	0.00011801719665527	SELECT * FROM products WHERE id = '750'
113	0.0001	0.00012493133544922	SELECT * FROM productimages WHERE product_id = '750' ORDER BY sortorder ASC
114	0.0001	0.00012898445129395	SELECT * FROM product_image_select WHERE product_id = '750'
115	0.0001	8.4161758422852E-5	SELECT * FROM productcustomimages WHERE product_id = '750'
116	0.0004	0.00037717819213867	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '750' AND a.name = n.originalname
117	0.0042	0.004162073135376	SELECT * FROM productoffers WHERE product_id = '750' AND merchantid = 'ATVPDKIKX0DER'
118	0.0001	0.00012683868408203	SELECT * FROM productoffers WHERE product_id = '750' AND price > 0 ORDER BY price ASC LIMIT 1
119	0.0001	0.0001370906829834	SELECT value FROM productattributes WHERE product_id = '750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120	0.0001	0.00010800361633301	SELECT * FROM products WHERE id = '802'
121	0.0001	0.00010895729064941	SELECT * FROM productimages WHERE product_id = '802' ORDER BY sortorder ASC
122	0.0001	0.00013017654418945	SELECT * FROM product_image_select WHERE product_id = '802'
123	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '802'
124	0.0005	0.00052213668823242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '802' AND a.name = n.originalname
125	0.0001	9.8943710327148E-5	SELECT * FROM productoffers WHERE product_id = '802' AND merchantid = 'ATVPDKIKX0DER'
126	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '802' AND price > 0 ORDER BY price ASC LIMIT 1
127	0.0001	0.00013399124145508	SELECT value FROM productattributes WHERE product_id = '802' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128	0.0001	0.00011086463928223	SELECT * FROM products WHERE id = '807'
129	0.0001	0.0001218318939209	SELECT * FROM productimages WHERE product_id = '807' ORDER BY sortorder ASC
130	0.0002	0.00015091896057129	SELECT * FROM product_image_select WHERE product_id = '807'
131	0.0001	8.5830688476562E-5	SELECT * FROM productcustomimages WHERE product_id = '807'
132	0.0003	0.00030303001403809	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '807' AND a.name = n.originalname
133	0.0001	9.608268737793E-5	SELECT * FROM productoffers WHERE product_id = '807' AND merchantid = 'ATVPDKIKX0DER'
134	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '807' AND price > 0 ORDER BY price ASC LIMIT 1
135	0.0001	0.00011992454528809	SELECT value FROM productattributes WHERE product_id = '807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136	0.0001	0.00012111663818359	SELECT * FROM products WHERE id = '764'
137	0.0001	0.00012397766113281	SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
138	0.0001	0.00012707710266113	SELECT * FROM product_image_select WHERE product_id = '764'
139	0.0001	9.7990036010742E-5	SELECT * FROM productcustomimages WHERE product_id = '764'
140	0.0005	0.00047206878662109	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
141	0.0001	0.00012898445129395	SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'ATVPDKIKX0DER'
142	0.0001	0.00011110305786133	SELECT * FROM productoffers WHERE product_id = '764' AND price > 0 ORDER BY price ASC LIMIT 1
143	0.0001	0.00013279914855957	SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144	0.0001	0.00010800361633301	SELECT * FROM products WHERE id = '822'
145	0.0001	0.00010204315185547	SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
146	0.0001	0.00012898445129395	SELECT * FROM product_image_select WHERE product_id = '822'
147	0.0001	8.4877014160156E-5	SELECT * FROM productcustomimages WHERE product_id = '822'
148	0.0004	0.00039505958557129	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
149	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'ATVPDKIKX0DER'
150	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '822' AND price > 0 ORDER BY price ASC LIMIT 1
151	0.0001	0.00012516975402832	SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152	0.0001	0.0001070499420166	SELECT * FROM products WHERE id = '811'
153	0.0001	0.0001060962677002	SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
154	0.0002	0.0001530647277832	SELECT * FROM product_image_select WHERE product_id = '811'
155	0.0001	8.6784362792969E-5	SELECT * FROM productcustomimages WHERE product_id = '811'
156	0.0003	0.00034809112548828	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
157	0.0001	9.7990036010742E-5	SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'ATVPDKIKX0DER'
158	0.0001	0.00010800361633301	SELECT * FROM productoffers WHERE product_id = '811' AND price > 0 ORDER BY price ASC LIMIT 1
159	0.0001	0.00012493133544922	SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160	0.0001	0.0001218318939209	SELECT * FROM products WHERE id = '780'
161	0.0001	0.00010299682617188	SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
162	0.0001	0.00012683868408203	SELECT * FROM product_image_select WHERE product_id = '780'
163	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '780'
164	0.0003	0.00028800964355469	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
165	0.0001	9.5129013061523E-5	SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'ATVPDKIKX0DER'
166	0.0001	0.00012993812561035	SELECT * FROM productoffers WHERE product_id = '780' AND price > 0 ORDER BY price ASC LIMIT 1
167	0.0001	0.00012302398681641	SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168	0.0001	0.0001070499420166	SELECT * FROM products WHERE id = '819'
169	0.0001	0.00010204315185547	SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
170	0.0001	0.00012898445129395	SELECT * FROM product_image_select WHERE product_id = '819'
171	0.0001	8.392333984375E-5	SELECT * FROM productcustomimages WHERE product_id = '819'
172	0.0004	0.00041699409484863	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '819' AND a.name = n.originalname
173	0.0001	9.4890594482422E-5	SELECT * FROM productoffers WHERE product_id = '819' AND merchantid = 'ATVPDKIKX0DER'
174	0.0001	0.00010585784912109	SELECT * FROM productoffers WHERE product_id = '819' AND price > 0 ORDER BY price ASC LIMIT 1
175	0.0001	0.00013494491577148	SELECT value FROM productattributes WHERE product_id = '819' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176	0.0001	0.0001070499420166	SELECT * FROM products WHERE id = '724'
177	0.0001	0.0001060962677002	SELECT * FROM productimages WHERE product_id = '724' ORDER BY sortorder ASC
178	0.0001	0.00012803077697754	SELECT * FROM product_image_select WHERE product_id = '724'
179	0.0001	9.7990036010742E-5	SELECT * FROM productcustomimages WHERE product_id = '724'
180	0.0002	0.00022006034851074	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '724' AND a.name = n.originalname
181	0.0001	9.5129013061523E-5	SELECT * FROM productoffers WHERE product_id = '724' AND merchantid = 'ATVPDKIKX0DER'
182	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '724' AND price > 0 ORDER BY price ASC LIMIT 1
183	0.0001	0.00011682510375977	SELECT value FROM productattributes WHERE product_id = '724' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184	0.0001	0.0001070499420166	SELECT * FROM products WHERE id = '4399'
185	0.0001	0.00010895729064941	SELECT * FROM productimages WHERE product_id = '4399' ORDER BY sortorder ASC
186	0.0002	0.0001528263092041	SELECT * FROM product_image_select WHERE product_id = '4399'
187	0.0001	8.702278137207E-5	SELECT * FROM productcustomimages WHERE product_id = '4399'
188	0.0003	0.00032901763916016	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4399' AND a.name = n.originalname
189	0.0001	9.4890594482422E-5	SELECT * FROM productoffers WHERE product_id = '4399' AND merchantid = 'ATVPDKIKX0DER'
190	0.0001	0.0001070499420166	SELECT * FROM productoffers WHERE product_id = '4399' AND price > 0 ORDER BY price ASC LIMIT 1
191	0.0001	0.00012397766113281	SELECT value FROM productattributes WHERE product_id = '4399' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192	0.0005	0.0004580020904541	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
193	0.0001	7.319450378418E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '798' ORDER BY timestamp DESC
194	0.0001	6.6995620727539E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '750' ORDER BY timestamp DESC
195	0.0001	6.3896179199219E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '802' ORDER BY timestamp DESC
196	0.0001	6.6995620727539E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '807' ORDER BY timestamp DESC
197	0.0001	6.3896179199219E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '764' ORDER BY timestamp DESC
198	0.0001	6.5088272094727E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
199	0.0001	6.3896179199219E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '811' ORDER BY timestamp DESC
200	0.0001	7.6055526733398E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '780' ORDER BY timestamp DESC
201	0.0001	6.6041946411133E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '819' ORDER BY timestamp DESC
202	0.0001	6.4849853515625E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '724' ORDER BY timestamp DESC
203	0.0001	6.413459777832E-5	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4399' ORDER BY timestamp DESC
204	0.0001	0.00010299682617188	SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id = 27 AND c.prod_type = 'ebay' AND hide = 0
205	0.0001	0.00014305114746094	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
206	0.0001	0.00010895729064941	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
207	0.0001	0.00012612342834473	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
208	0.0001	6.8187713623047E-5	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
209	0.0001	9.1075897216797E-5	SELECT * FROM pages WHERE id = 38
210	0.0001	8.2015991210938E-5	SELECT * FROM categories WHERE id = '27'
211	0.0002	0.00015902519226074	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
212	0.0001	6.103515625E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
213	0.0001	6.413459777832E-5	SELECT id FROM categories WHERE parent_id = '27'
214	0.0002	0.00017881393432617	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
215	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 (27) AND p.disabled = 0
216	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 (27) AND c.prod_type = 'custom' AND cp.hide = 0
217	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
218	0.0001	0.00014710426330566	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
219	0.0001	5.8889389038086E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
220	0.0002	0.00016188621520996	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
221	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 (27) AND p.disabled = 0
222	0.0001	8.2015991210938E-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
223	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
224	0.0001	7.7962875366211E-5	SELECT id FROM categories WHERE parent_id = '27'
225	0.0002	0.00019001960754395	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
226	0.0001	0.00011205673217773	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
227	0.0001	6.8902969360352E-5	SELECT * FROM categoryimages WHERE category_id = 27
228	0.0001	6.6041946411133E-5	SELECT * FROM categorygroups WHERE id = '1'
229	0.0002	0.00017309188842773	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
230	0.0001	8.2969665527344E-5	SELECT * FROM categories WHERE id = '30'
231	0.0002	0.00024700164794922	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
232	0.0001	6.9141387939453E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
233	0.0001	6.3896179199219E-5	SELECT id FROM categories WHERE parent_id = '30'
234	0.0002	0.00023984909057617	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
235	0.0001	7.2002410888672E-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
236	0.0001	8.1062316894531E-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
237	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
238	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
239	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
240	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 (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
241	0.0001	7.2002410888672E-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
242	0.0001	7.9870223999023E-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
243	0.0001	5.5789947509766E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
244	0.0001	6.1988830566406E-5	SELECT id FROM categories WHERE parent_id = '30'
245	0.0003	0.00025391578674316	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
246	0.0001	0.00011897087097168	SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
247	0.0001	8.392333984375E-5	SELECT * FROM categoryimages WHERE category_id = 30
248	0.0001	7.7962875366211E-5	SELECT * FROM categorygroups WHERE id = '1'
249	0.0002	0.00024890899658203	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
250	0.0001	8.2969665527344E-5	SELECT * FROM pages WHERE id = 59
251	0.0001	8.5115432739258E-5	SELECT * FROM pages WHERE id = 55
252	0.0001	0.00014400482177734	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
253	0.0001	9.7990036010742E-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:1679629395;s:8:\"products\";a:0:{}}' WHERE id = '8'
254	0.0002	0.00020813941955566	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
255	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:1679629395;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'
256	0.0001	0.00011301040649414	SELECT * FROM products WHERE id = 7004
257	0.0001	0.00010395050048828	SELECT * FROM products WHERE id = 7011
258	0.0001	0.00010204315185547	SELECT * FROM products WHERE id = 7045
259	0.0001	0.00010299682617188	SELECT * FROM products WHERE id = '7004'
260	0.0001	0.00011301040649414	SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
261	0.0001	0.00013303756713867	SELECT * FROM product_image_select WHERE product_id = '7004'
262	0.0001	9.8228454589844E-5	SELECT * FROM productcustomimages WHERE product_id = '7004'
263	0.0005	0.00049710273742676	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
264	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
265	0.0001	0.00010895729064941	SELECT * FROM productoffers WHERE product_id = '7004' AND price > 0 ORDER BY price ASC LIMIT 1
266	0.0002	0.00015592575073242	SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267	0.0001	0.00010991096496582	SELECT * FROM products WHERE id = '7011'
268	0.0001	9.5844268798828E-5	SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
269	0.0001	0.00013184547424316	SELECT * FROM product_image_select WHERE product_id = '7011'
270	0.0001	8.6069107055664E-5	SELECT * FROM productcustomimages WHERE product_id = '7011'
271	0.0006	0.00057506561279297	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
272	0.0001	9.4890594482422E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
273	0.0001	9.5844268798828E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND price > 0 ORDER BY price ASC LIMIT 1
274	0.0001	9.2029571533203E-5	SELECT * FROM productoffers WHERE product_id = 7011 ORDER BY price ASC LIMIT 1
275	0.0001	0.00010800361633301	SELECT value FROM productattributes WHERE product_id = '7011' AND name = 'ListPriceAmount'
276	0.0001	0.00010800361633301	SELECT * FROM products WHERE id = '7045'
277	0.0001	9.1075897216797E-5	SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
278	0.0001	0.00014805793762207	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
279	0.0001	0.00014400482177734	SELECT * FROM product_image_select WHERE product_id = '7045'
280	0.0001	8.702278137207E-5	SELECT * FROM productcustomimages WHERE product_id = '7045'
281	0.0001	0.00012898445129395	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
282	0.0003	0.00026202201843262	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
283	0.0001	0.00010991096496582	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
284	0.0006	0.00057601928710938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
285	0.0001	9.0837478637695E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
286	0.0001	9.7990036010742E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0001	8.702278137207E-5	SELECT * FROM productoffers WHERE product_id = 7045 ORDER BY price ASC LIMIT 1
288	0.0001	0.00010204315185547	SELECT value FROM productattributes WHERE product_id = '7045' AND name = 'ListPriceAmount'
289	0.0001	0.0001220703125	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
290	0.0002	0.00017595291137695	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
291	0.0001	0.0001070499420166	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
292	0.0001	0.00013589859008789	SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293	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 = 'Size' GROUP BY o.value ORDER BY o.value ASC
294	0.0001	0.00013995170593262	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
295	0.0002	0.00023913383483887	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
296	0.0002	0.00016283988952637	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
297	0.0003	0.00033998489379883	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
298	0.0002	0.00022602081298828	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
299	0.0002	0.00015783309936523	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
300	0.0001	0.00014114379882812	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
301	0.0001	0.00014495849609375	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
302	0.0001	0.00012493133544922	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

Books

How You Can Maximize Student Aid: Strate...

Military Divorce Tips: Health Care, CHCB...

YouTube Seo Ranking Checklists: Targeted...

Make Money Online Using Zazzle: Internet...

The Kid's ROTH IRA Handbook: Securing Ta...

The Military Family: A Casualty of War

Now You Tell Me! 12 Army Wives Give the ...

11 Mistakes Couples Make During Deployme...

I'm a Work-at-Home Mommy--You can be too...

The Military Divorce Handbook: A Practic...

Effects of the Uniformed Services Former...

Make Money on Amazon Video Direct: The B...

Connect with Us!

Browse Categories

Connect with us!

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 0.50005078315735 seconds

Query Debug - 302 Database Queries. Total time 0.0807 seconds