0 items

First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor by Night Owl Security

Price: Click Button for Price

As of 2019-07-18 00:46:12 UTC (more info)

Product prices and availability are accurate as of 2019-07-18 00:46:12 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.

Availability: Not Available Discontinued

Product Information (more info)

See All User Reviews
View Product Details
Read Amazon Product Reviews

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 Description

The Tactical and Survivalist shop is proud to offer the valuable First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor today at this special price.

With so many competing tactical, combat and survival products available recently, it is wise to have a provider that you can recognize. The First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor is certainly all that and will be a superb acquisition for your combat equipment or tactical ability.

We pride ourselves to provide the highest quality survival gear for all your on the job requirements.

For this reduced price, the First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor comes greatly respected and is a regular choice with many like minded people. Night Owl Security have added some great touches and this equals great value for money.

Manufacturer Description

This hand held extremely compact night vision unit allows you to view things in total darkness as it sports an effective built-in IR illuminator that impressively ranges up to 70 m. Stylist, weatherproof design makes this device easy to use and with a 2x large angle optical system, it has a viewing range of over 150m. Light weight and portable, this unit is ideal for lots of night time pursuits from navigating to house security

Product Features

3 Power Lens Technology Generation 1 500X Ambient Light Amplification 32-Ft Dia & 150-Ft Powerful Infrared Illumination

Night

User Reviews
Amazon Product Reviews

Write a Review

See more First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor by Night Owl Security on eBay

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.2566318511963	749	1.1440	0

No Amazon API Requests Made.

App Debug - Total Time 2.2566318511963 seconds

Number	Time From Start	Name	Description
1	0.47853684425354	Initialise	Initialise FSB Function
2	0.48073983192444	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.49233603477478	Start of getCategoryListByGroup Function	Before first category groups query
4	0.49250602722168	After initial query	Before first category groups query
5	0.49250793457031	Get Category List for Group	Before the call to getCategoryList function
6	0.49251294136047	Start of GetCategoryList function	Start of the function
7	0.49251699447632	Before getting categories	Query to get specific category list
8	0.49314594268799	After getting categories	Query to get specific category list
9	0.4931468963623	Before getting category custom	Before call to function getCategoryCustom
10	0.49519801139832	After getting category custom	After call to function getCategoryCustom
11	0.49519991874695	Before getting category custom	Before call to function getCategoryCustom
12	0.50643086433411	After getting category custom	After call to function getCategoryCustom
13	0.50643396377563	Before getting category custom	Before call to function getCategoryCustom
14	0.51232695579529	After getting category custom	After call to function getCategoryCustom
15	0.51233005523682	Before getting category custom	Before call to function getCategoryCustom
16	0.51645588874817	After getting category custom	After call to function getCategoryCustom
17	0.5164589881897	End of GetCategoryList function	End of the function
18	0.51646900177002	Get Category List for Group	Before the call to getCategoryList function
19	0.51647186279297	Start of GetCategoryList function	Start of the function
20	0.51647400856018	Before getting categories	Query to get specific category list
21	0.51690697669983	After getting categories	Query to get specific category list
22	0.51690888404846	Before getting category custom	Before call to function getCategoryCustom
23	0.52257299423218	After getting category custom	After call to function getCategoryCustom
24	0.52257585525513	Before getting category custom	Before call to function getCategoryCustom
25	0.53326392173767	After getting category custom	After call to function getCategoryCustom
26	0.5332658290863	End of GetCategoryList function	End of the function
27	0.53327488899231	Get Category List for Group	Before the call to getCategoryList function
28	0.53327798843384	Start of GetCategoryList function	Start of the function
29	0.53328084945679	Before getting categories	Query to get specific category list
30	0.53410887718201	After getting categories	Query to get specific category list
31	0.53411102294922	Before getting category custom	Before call to function getCategoryCustom
32	0.54337692260742	After getting category custom	After call to function getCategoryCustom
33	0.54338002204895	Before getting category custom	Before call to function getCategoryCustom
34	0.56091403961182	After getting category custom	After call to function getCategoryCustom
35	0.56091690063477	Before getting category custom	Before call to function getCategoryCustom
36	0.56681394577026	After getting category custom	After call to function getCategoryCustom
37	0.5668158531189	Before getting category custom	Before call to function getCategoryCustom
38	0.57274985313416	After getting category custom	After call to function getCategoryCustom
39	0.57275199890137	Before getting category custom	Before call to function getCategoryCustom
40	0.57899689674377	After getting category custom	After call to function getCategoryCustom
41	0.57899904251099	Before getting category custom	Before call to function getCategoryCustom
42	0.60076594352722	After getting category custom	After call to function getCategoryCustom
43	0.60076904296875	Before getting category custom	Before call to function getCategoryCustom
44	0.60487103462219	After getting category custom	After call to function getCategoryCustom
45	0.60487389564514	Before getting category custom	Before call to function getCategoryCustom
46	0.60970783233643	After getting category custom	After call to function getCategoryCustom
47	0.60970997810364	End of GetCategoryList function	End of the function
48	0.60972499847412	Get Category List for Group	Before the call to getCategoryList function
49	0.60972785949707	Start of GetCategoryList function	Start of the function
50	0.6097309589386	Before getting categories	Query to get specific category list
51	0.61014699935913	After getting categories	Query to get specific category list
52	0.61014795303345	Before getting category custom	Before call to function getCategoryCustom
53	0.612468957901	After getting category custom	After call to function getCategoryCustom
54	0.61247086524963	Before getting category custom	Before call to function getCategoryCustom
55	0.6147928237915	After getting category custom	After call to function getCategoryCustom
56	0.61479496955872	End of GetCategoryList function	End of the function
57	0.61480093002319	Get Category List for Group	Before the call to getCategoryList function
58	0.61480283737183	Start of GetCategoryList function	Start of the function
59	0.61480593681335	Before getting categories	Query to get specific category list
60	0.61511087417603	After getting categories	Query to get specific category list
61	0.61511182785034	Before getting category custom	Before call to function getCategoryCustom
62	0.6201000213623	After getting category custom	After call to function getCategoryCustom
63	0.62010192871094	End of GetCategoryList function	End of the function
64	0.62010788917542	End of getCategoryListByGroup Function	Before return()
65	0.71238303184509	App Controller End	End of the App controller (called before the controller of every page)
66	0.7130868434906	Product Start	Start of the product info controller
67	0.71410894393921	Cache file not found	Starting get product details
68	0.73440098762512	Related products	Start getting related products if enabled
69	0.73440289497375	Related Products Start	Before the related products are found
70	0.73440384864807	Related Products Keywords	Before the related product keywords are found
71	0.73441505432129	Create Keyword List Function	Start of function
72	0.73536205291748	Create Keyword List Function	After looping provided content - 556 keywords found
73	0.77106904983521	Create Keyword List Function	After looping initial keyword list - 507 keywords remaining
74	0.77120089530945	Create Keyword List Function	After reducing keyword list
75	0.77252101898193	Create Keyword List Function	After selecting by scoring keywords
76	0.77252793312073	Create Keyword List Function	After final loop of keywords
77	0.77252984046936	Related Products Keywords	After the related product keywords are found
78	1.0378038883209	Related Products End	After the related products are found
79	1.2532279491425	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
80	1.4066209793091	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
81	1.6387929916382	Product End	End of the product info controller (Product Info)
82	1.6391890048981	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
83	1.639328956604	Before Get Options	Before the call to getOptions in the tpl class
84	1.8401880264282	After Get Options	After the call to getOptions in the tpl class
85	1.8404538631439	App_after Controller End	End of the App_after controller (called after the controller of every page)
86	1.8404669761658	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
87	2.0507969856262	Product Info: After Smarty Fetch	After the product.tpl template is fetched
88	2.0508029460907	Product Info: Before Template Display	Before the template is displayed
89	2.2566080093384	Product Info: After Template Display	After the template is displayed
90	2.2566139698029	Finalizing debug	Before the debug is output to the page.
91	2.256630897522	End of App	This is the end of the app logging, final timestamp

Query Debug - 749 Database Queries. Total time 1.1440 seconds


SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
SHOW TABLES LIKE 'bad_bots'
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
SELECT * FROM `bad_bots`
SELECT parameter, value FROM parameters
SET time_zone = 'Europe/London'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
delete from cachefiles
SELECT id FROM pages WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor' LIMIT 1
SELECT id FROM products WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor' AND hidden = 0 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 = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor'
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 = 49
SELECT id FROM categories WHERE parent_id = '49'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  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 (49)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
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 = 50
SELECT id FROM categories WHERE parent_id = '50'
SELECT id FROM categories WHERE parent_id = '96'
SELECT id FROM categories WHERE parent_id = '97'
SELECT id FROM categories WHERE parent_id = '111'
SELECT id FROM categories WHERE parent_id = '129'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  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 (96,97,111,129,50)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
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 = 80
SELECT id FROM categories WHERE parent_id = '80'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  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 (80)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
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 = 51
SELECT id FROM categories WHERE parent_id = '51'
SELECT id FROM categories WHERE parent_id = '101'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  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 (101,51)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
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 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 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(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '2'
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 = 61
SELECT id FROM categories WHERE parent_id = '61'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  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 (61)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
SELECT * FROM categorygroups WHERE id = '2'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  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 = 64
SELECT id FROM categories WHERE parent_id = '64'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  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 (64)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
SELECT * FROM categorygroups WHERE id = '10'
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 = 65
SELECT id FROM categories WHERE parent_id = '65'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  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 (65)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
SELECT * FROM categorygroups WHERE id = '10'
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 = 81
SELECT id FROM categories WHERE parent_id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  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 (81)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
SELECT * FROM categorygroups WHERE id = '10'
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 = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  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 (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '10'
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 = 66
SELECT id FROM categories WHERE parent_id = '66'
SELECT id FROM categories WHERE parent_id = '131'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  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 (131,66)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
SELECT * FROM categorygroups WHERE id = '10'
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 = 34
SELECT id FROM categories WHERE parent_id = '34'
SELECT id FROM categories WHERE parent_id = '94'
SELECT id FROM categories WHERE parent_id = '98'
SELECT id FROM categories WHERE parent_id = '99'
SELECT id FROM categories WHERE parent_id = '110'
SELECT id FROM categories WHERE parent_id = '130'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  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 (94,98,99,110,130,34)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
SELECT * FROM categorygroups WHERE id = '10'
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 = 32
SELECT id FROM categories WHERE parent_id = '32'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  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 (32)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
SELECT * FROM categorygroups WHERE id = '10'
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 = 89
SELECT id FROM categories WHERE parent_id = '89'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  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 (89)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
SELECT * FROM categorygroups WHERE id = '10'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  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 = 84
SELECT id FROM categories WHERE parent_id = '84'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  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 (84)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
SELECT * FROM categorygroups WHERE id = '17'
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 = 90
SELECT id FROM categories WHERE parent_id = '90'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  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 (90)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
SELECT * FROM categorygroups WHERE id = '17'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  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 = 92
SELECT id FROM categories WHERE parent_id = '92'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  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 (92)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
SELECT * FROM categorygroups WHERE id = '20'
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 = 'EBAY_APP_ID' 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
SELECT * FROM pages WHERE id = '67'
SELECT * FROM pages WHERE id = '82'
SELECT * FROM pages WHERE id = '84'
SELECT * FROM pages WHERE id = '94'
SELECT * FROM pages WHERE id = '116'
SELECT * FROM pages WHERE id = '52'
SELECT * FROM pages WHERE id = '135'
SELECT * FROM pages WHERE id = '245'
SELECT * FROM pages WHERE id = '269'
SELECT * FROM pages WHERE id = '275'
SELECT * FROM pages WHERE id = '280'
SELECT * FROM pages WHERE id = '357'
SELECT * FROM pages WHERE id = '379'
SELECT * FROM pages WHERE id = '401'
SELECT * FROM pages WHERE id = '450'
SELECT * FROM pages WHERE id = '454'
SELECT * FROM pages WHERE id = '457'
SELECT * FROM pages WHERE id = '458'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
SELECT * FROM pages WHERE id = '41'
SELECT * FROM pages WHERE id = '43'
SELECT * FROM pages WHERE id = '44'
SELECT * FROM pages WHERE id = '68'
SELECT * FROM pages WHERE id = '80'
SELECT * FROM pages WHERE id = '85'
SELECT * FROM pages WHERE id = '97'
SELECT * FROM pages WHERE id = '107'
SELECT * FROM pages WHERE id = '108'
SELECT * FROM pages WHERE id = '128'
SELECT * FROM pages WHERE id = '133'
SELECT * FROM pages WHERE id = '148'
SELECT * FROM pages WHERE id = '217'
SELECT * FROM pages WHERE id = '228'
SELECT * FROM pages WHERE id = '257'
SELECT * FROM pages WHERE id = '271'
SELECT * FROM pages WHERE id = '286'
SELECT * FROM pages WHERE id = '287'
SELECT * FROM pages WHERE id = '291'
SELECT * FROM pages WHERE id = '380'
SELECT * FROM pages WHERE id = '344'
SELECT * FROM pages WHERE id = '354'
SELECT * FROM pages WHERE id = '363'
SELECT * FROM pages WHERE id = '364'
SELECT * FROM pages WHERE id = '368'
SELECT * FROM pages WHERE id = '369'
SELECT * FROM pages WHERE id = '400'
SELECT * FROM pages WHERE id = '463'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
SELECT * FROM pages WHERE id = '66'
SELECT * FROM pages WHERE id = '77'
SELECT * FROM pages WHERE id = '90'
SELECT * FROM pages WHERE id = '414'
SELECT * FROM pages WHERE id = '119'
SELECT * FROM pages WHERE id = '406'
SELECT * FROM pages WHERE id = '149'
SELECT * FROM pages WHERE id = '150'
SELECT * FROM pages WHERE id = '412'
SELECT * FROM pages WHERE id = '162'
SELECT * FROM pages WHERE id = '164'
SELECT * FROM pages WHERE id = '167'
SELECT * FROM pages WHERE id = '180'
SELECT * FROM pages WHERE id = '187'
SELECT * FROM pages WHERE id = '265'
SELECT * FROM pages WHERE id = '268'
SELECT * FROM pages WHERE id = '411'
SELECT * FROM pages WHERE id = '290'
SELECT * FROM pages WHERE id = '413'
SELECT * FROM pages WHERE id = '409'
SELECT * FROM pages WHERE id = '327'
SELECT * FROM pages WHERE id = '336'
SELECT * FROM pages WHERE id = '351'
SELECT * FROM pages WHERE id = '358'
SELECT * FROM pages WHERE id = '360'
SELECT * FROM pages WHERE id = '362'
SELECT * FROM pages WHERE id = '366'
SELECT * FROM pages WHERE id = '370'
SELECT * FROM pages WHERE id = '377'
SELECT * FROM pages WHERE id = '386'
SELECT * FROM pages WHERE id = '408'
SELECT * FROM pages WHERE id = '415'
SELECT * FROM pages WHERE id = '416'
SELECT * FROM pages WHERE id = '419'
SELECT * FROM pages WHERE id = '423'
SELECT * FROM pages WHERE id = '427'
SELECT * FROM pages WHERE id = '428'
SELECT * FROM pages WHERE id = '432'
SELECT * FROM pages WHERE id = '433'
SELECT * FROM pages WHERE id = '436'
SELECT * FROM pages WHERE id = '437'
SELECT * FROM pages WHERE id = '461'
SELECT * FROM pages WHERE id = '464'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
SELECT * FROM pages WHERE id = '74'
SELECT * FROM pages WHERE id = '137'
SELECT * FROM pages WHERE id = '145'
SELECT * FROM pages WHERE id = '156'
SELECT * FROM pages WHERE id = '407'
SELECT * FROM pages WHERE id = '410'
SELECT * FROM pages WHERE id = '266'
SELECT * FROM pages WHERE id = '316'
SELECT * FROM pages WHERE id = '332'
SELECT * FROM pages WHERE id = '334'
SELECT * FROM pages WHERE id = '367'
SELECT * FROM pages WHERE id = '387'
SELECT * FROM pages WHERE id = '389'
SELECT * FROM pages WHERE id = '397'
SELECT * FROM pages WHERE id = '449'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
SELECT * FROM pages WHERE id = '42'
SELECT * FROM pages WHERE id = '79'
SELECT * FROM pages WHERE id = '86'
SELECT * FROM pages WHERE id = '95'
SELECT * FROM pages WHERE id = '102'
SELECT * FROM pages WHERE id = '109'
SELECT * FROM pages WHERE id = '114'
SELECT * FROM pages WHERE id = '121'
SELECT * FROM pages WHERE id = '138'
SELECT * FROM pages WHERE id = '142'
SELECT * FROM pages WHERE id = '62'
SELECT * FROM pages WHERE id = '157'
SELECT * FROM pages WHERE id = '246'
SELECT * FROM pages WHERE id = '276'
SELECT * FROM pages WHERE id = '278'
SELECT * FROM pages WHERE id = '279'
SELECT * FROM pages WHERE id = '317'
SELECT * FROM pages WHERE id = '405'
SELECT * FROM pages WHERE id = '343'
SELECT * FROM pages WHERE id = '345'
SELECT * FROM pages WHERE id = '346'
SELECT * FROM pages WHERE id = '347'
SELECT * FROM pages WHERE id = '348'
SELECT * FROM pages WHERE id = '349'
SELECT * FROM pages WHERE id = '381'
SELECT * FROM pages WHERE id = '392'
SELECT * FROM pages WHERE id = '393'
SELECT * FROM pages WHERE id = '394'
SELECT * FROM pages WHERE id = '395'
SELECT * FROM pages WHERE id = '399'
SELECT * FROM pages WHERE id = '421'
SELECT * FROM pages WHERE id = '426'
SELECT * FROM pages WHERE id = '430'
SELECT * FROM pages WHERE id = '431'
SELECT * FROM pages WHERE id = '434'
SELECT * FROM pages WHERE id = '435'
SELECT * FROM pages WHERE id = '440'
SELECT * FROM pages WHERE id = '441'
SELECT * FROM pages WHERE id = '451'
SELECT * FROM pages WHERE id = '453'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
SELECT * FROM pages WHERE id = '146'
SELECT * FROM pages WHERE id = '158'
SELECT * FROM pages WHERE id = '163'
SELECT * FROM pages WHERE id = '293'
SELECT * FROM pages WHERE id = '340'
SELECT * FROM pages WHERE id = '417'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
SELECT * FROM pages WHERE id = '173'
SELECT * FROM pages WHERE id = '181'
SELECT * FROM pages WHERE id = '288'
SELECT * FROM pages WHERE id = '299'
SELECT * FROM pages WHERE id = '300'
SELECT * FROM pages WHERE id = '383'
SELECT * FROM pages WHERE id = '385'
SELECT * FROM pages WHERE id = '438'
SELECT * FROM pages WHERE id = '442'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
SELECT * FROM pages WHERE id = '103'
SELECT * FROM pages WHERE id = '134'
SELECT * FROM pages WHERE id = '139'
SELECT * FROM pages WHERE id = '143'
SELECT * FROM pages WHERE id = '234'
SELECT * FROM pages WHERE id = '248'
SELECT * FROM pages WHERE id = '260'
SELECT * FROM pages WHERE id = '398'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
SELECT * FROM pages WHERE id = '61'
SELECT * FROM pages WHERE id = '87'
SELECT * FROM pages WHERE id = '104'
SELECT * FROM pages WHERE id = '115'
SELECT * FROM pages WHERE id = '124'
SELECT * FROM pages WHERE id = '144'
SELECT * FROM pages WHERE id = '151'
SELECT * FROM pages WHERE id = '199'
SELECT * FROM pages WHERE id = '200'
SELECT * FROM pages WHERE id = '304'
SELECT * FROM pages WHERE id = '321'
SELECT * FROM pages WHERE id = '333'
SELECT * FROM pages WHERE id = '350'
SELECT * FROM pages WHERE id = '378'
SELECT * FROM pages WHERE id = '422'
SELECT * FROM pages WHERE id = '425'
SELECT * FROM pages WHERE id = '443'
SELECT * FROM pages WHERE id = '444'
SELECT * FROM pages WHERE id = '445'
SELECT * FROM pages WHERE id = '446'
SELECT * FROM pages WHERE id = '447'
SELECT * FROM pages WHERE id = '448'
SELECT * FROM pages WHERE id = '455'
SELECT * FROM pages WHERE id = '456'
SELECT * FROM pages WHERE id = '459'
SELECT * FROM pages WHERE id = '460'
SELECT * FROM pages WHERE id = '462'
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
SELECT * FROM pages WHERE id = '153'
SELECT * FROM pages WHERE id = '182'
SELECT * FROM pages WHERE id = '238'
SELECT * FROM pages WHERE id = '240'
SELECT * FROM pages WHERE id = '242'
SELECT * FROM pages WHERE id = '252'
SELECT * FROM pages WHERE id = '253'
SELECT * FROM pages WHERE id = '262'
SELECT * FROM pages WHERE id = '267'
SELECT * FROM pages WHERE id = '420'
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
SELECT * FROM products WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor'
SELECT * FROM manufacturers WHERE id = '7740'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '7740'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '7740' LIMIT 1
SELECT pagename, id FROM products p WHERE manufacturer_id = '7740' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '405132' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '7740'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '7740'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '7740'
SELECT category_id FROM products_categories WHERE product_id = '405132'
SELECT * FROM categories WHERE id = '81'
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 = 81
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 81
SELECT id FROM categories WHERE parent_id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  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 (81)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
SELECT * FROM productimages WHERE product_id = '405132' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '405132'
SELECT * FROM productcustomimages WHERE product_id = '405132'
SELECT * FROM productfeeds WHERE product_id = '405132' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '405132' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '3261'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3261'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3261'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3261' 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 = '407361' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '405132'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '405132' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '405132' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 405132
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '405132'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '405132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('night' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('night' IN BOOLEAN MODE) AND 405132 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '37914' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '37914'
SELECT * FROM productcustomimages WHERE product_id = '37914'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '37914' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '37914' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '37914' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '37914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '17718' WHERE id = '37914'
SELECT * FROM productimages WHERE product_id = '37917' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '37917' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '37917'
SELECT * FROM productcustomimages WHERE product_id = '37917'
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 = '37917'
                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     = '37917'
                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 = 37917
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '37917' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '37917' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '37917' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 37917
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '37917'
                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 = '37917'
                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     = '37917'
                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 = 37917
SELECT value FROM productattributes WHERE product_id = '37917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '16899' WHERE id = '37917'
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '37917'
                  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     = '37917'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '37917'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414494' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414494' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414494' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '54902' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '54902'
SELECT * FROM productcustomimages WHERE product_id = '54902'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '54902' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '54902' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '54902' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '54902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '8500' WHERE id = '54902'
SELECT * FROM productimages WHERE product_id = '90437' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '90437'
SELECT * FROM productcustomimages WHERE product_id = '90437'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90437' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '90437' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '90437' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '90437' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '10149' WHERE id = '90437'
SELECT * FROM productimages WHERE product_id = '109549' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '109549'
SELECT * FROM productcustomimages WHERE product_id = '109549'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '109549' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '109549' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '109549' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '109549' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '12995' WHERE id = '109549'
SELECT * FROM productimages WHERE product_id = '272720' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '272720'
SELECT * FROM productcustomimages WHERE product_id = '272720'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '272720' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '272720' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '272720' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '272720' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '14997' WHERE id = '272720'
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
SELECT * FROM ebay_products_cache WHERE cachekey = '1c2deec590fc23ea5506757ffe3c2587' 
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
SELECT * FROM ebay_products_cache WHERE cachekey = '1c2deec590fc23ea5506757ffe3c2587' 
SELECT id,asin FROM products WHERE parent_id = 405132
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405132' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '405132'
SELECT * FROM categories WHERE id = '81'
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 = 81
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 81
SELECT id FROM categories WHERE parent_id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  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 (81)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '405132' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '405132' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 405132
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '405132'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '405132'
SELECT value FROM productattributes WHERE product_id = '405132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '405132' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '405132' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 405132
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '405132'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '405132'
SELECT parent_id FROM categories WHERE id = '81'
SELECT * FROM categories WHERE id = '81'
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 = 81
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 81
SELECT id FROM categories WHERE parent_id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  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 (81)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
SELECT * FROM pages WHERE id = 2
SELECT * FROM pages WHERE id = 4
SELECT * FROM pages WHERE id = 12
SELECT * FROM pages WHERE id = 10
SELECT * FROM pages WHERE id = 7
SELECT * FROM pages WHERE id = 18
SELECT * FROM pages WHERE id = 28
SELECT * FROM pages WHERE id = 13
SELECT * FROM pages WHERE id = 3
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";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\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563419888;s:8:\"products\";a:6:{i:2;s:6:\"170197\";i:9;s:6:\"402907\";i:10;s:6:\"411183\";i:11;s:6:\"169659\";i:15;s:6:\"406078\";i:18;s:6:\"413807\";}}' WHERE id = '175'
SELECT * FROM products WHERE id IN (170197,402907,411183,169659,406078,413807) ORDER BY FIELD(id, 170197,402907,411183,169659,406078,413807 )
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '170197'
SELECT * FROM productcustomimages WHERE product_id = '170197'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '324500' WHERE id = '170197'
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '402907'
SELECT * FROM productcustomimages WHERE product_id = '402907'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9400' WHERE id = '402907'
SELECT * FROM productimages WHERE product_id = '411183' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '411183'
SELECT * FROM productcustomimages WHERE product_id = '411183'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411183' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '411183' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '411183' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '411183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '16999' WHERE id = '411183'
SELECT * FROM productimages WHERE product_id = '169659' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '169659'
SELECT * FROM productcustomimages WHERE product_id = '169659'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '169659' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '169659' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '169659' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '169659' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '10900' WHERE id = '169659'
SELECT * FROM productimages WHERE product_id = '406078' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406078'
SELECT * FROM productcustomimages WHERE product_id = '406078'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406078' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406078' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406078' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '998' WHERE id = '406078'
SELECT * FROM productimages WHERE product_id = '413807' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '413807'
SELECT * FROM productcustomimages WHERE product_id = '413807'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413807' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '413807' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '413807' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '413807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '179900' WHERE id = '413807'
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563419888;s:8:\"products\";a:6:{i:4;s:6:\"127345\";i:7;s:6:\"402058\";i:8;s:6:\"258602\";i:17;s:6:\"406728\";i:23;s:6:\"396333\";i:0;s:6:\"398858\";}}' WHERE id = '177'
SELECT * FROM products WHERE id IN (127345,402058,258602,406728,396333,398858) ORDER BY FIELD(id, 127345,402058,258602,406728,396333,398858 )
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '127345'
SELECT * FROM productcustomimages WHERE product_id = '127345'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19286' WHERE id = '127345'
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '402058'
SELECT * FROM productcustomimages WHERE product_id = '402058'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19900' WHERE id = '402058'
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '258602'
SELECT * FROM productcustomimages WHERE product_id = '258602'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19900' WHERE id = '258602'
SELECT * FROM productimages WHERE product_id = '406728' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406728'
SELECT * FROM productcustomimages WHERE product_id = '406728'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406728' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406728' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406728' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1359' WHERE id = '406728'
SELECT * FROM productimages WHERE product_id = '396333' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '396333'
SELECT * FROM productcustomimages WHERE product_id = '396333'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '396333' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '396333' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '396333' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '396333' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '3773' WHERE id = '396333'
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '398858'
SELECT * FROM productcustomimages WHERE product_id = '398858'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2999' WHERE id = '398858'
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563419888;s:8:\"products\";a:6:{i:5;s:6:\"408079\";i:14;s:6:\"406156\";i:15;s:6:\"406078\";i:17;s:6:\"406728\";i:20;s:6:\"398316\";i:3;s:6:\"414321\";}}' WHERE id = '181'
SELECT * FROM products WHERE id IN (408079,406156,406078,406728,398316,414321) ORDER BY FIELD(id, 408079,406156,406078,406728,398316,414321 )
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408079'
SELECT * FROM productcustomimages WHERE product_id = '408079'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '26458' WHERE id = '408079'
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406156'
SELECT * FROM productcustomimages WHERE product_id = '406156'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1015' WHERE id = '406156'
SELECT * FROM productimages WHERE product_id = '406078' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406078'
SELECT * FROM productcustomimages WHERE product_id = '406078'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406078' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406078' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406078' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '998' WHERE id = '406078'
SELECT * FROM productimages WHERE product_id = '406728' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406728'
SELECT * FROM productcustomimages WHERE product_id = '406728'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406728' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406728' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406728' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1359' WHERE id = '406728'
SELECT * FROM productimages WHERE product_id = '398316' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '398316'
SELECT * FROM productcustomimages WHERE product_id = '398316'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398316' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '398316' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '398316' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '398316' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '4999' WHERE id = '398316'
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414321'
SELECT * FROM productcustomimages WHERE product_id = '414321'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414321'
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563419888;s:8:\"products\";a:6:{i:8;s:6:\"258602\";i:22;s:6:\"396333\";i:5;s:6:\"408079\";i:11;s:6:\"169659\";i:12;s:6:\"407337\";i:14;s:6:\"406156\";}}' WHERE id = '183'
SELECT * FROM products WHERE id IN (258602,396333,408079,169659,407337,406156) ORDER BY FIELD(id, 258602,396333,408079,169659,407337,406156 )
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '258602'
SELECT * FROM productcustomimages WHERE product_id = '258602'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19900' WHERE id = '258602'
SELECT * FROM productimages WHERE product_id = '396333' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '396333'
SELECT * FROM productcustomimages WHERE product_id = '396333'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '396333' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '396333' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '396333' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '396333' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '3773' WHERE id = '396333'
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408079'
SELECT * FROM productcustomimages WHERE product_id = '408079'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '26458' WHERE id = '408079'
SELECT * FROM productimages WHERE product_id = '169659' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '169659'
SELECT * FROM productcustomimages WHERE product_id = '169659'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '169659' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '169659' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '169659' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '169659' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '10900' WHERE id = '169659'
SELECT * FROM productimages WHERE product_id = '407337' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407337'
SELECT * FROM productcustomimages WHERE product_id = '407337'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407337' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407337' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407337' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407337' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '8999' WHERE id = '407337'
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406156'
SELECT * FROM productcustomimages WHERE product_id = '406156'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1015' WHERE id = '406156'
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
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 = 'HEAD_CUSTOM_BANNER'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0002	0.00016283988952637	SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2	0.0005	0.00045895576477051	SHOW TABLES LIKE 'bad_bots'
3	0.0002	0.00016307830810547	SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4	0.0002	0.00015997886657715	SELECT * FROM `bad_bots`
5	0.0005	0.0004580020904541	SELECT parameter, value FROM parameters
6	0.0002	0.00017189979553223	SET time_zone = 'Europe/London'
7	0.0003	0.00032901763916016	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0001	0.00014591217041016	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0001	0.00010180473327637	delete from cachefiles
10	0.0002	0.00022482872009277	SELECT id FROM pages WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor' LIMIT 1
11	0.0002	0.00024700164794922	SELECT id FROM products WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor' AND hidden = 0 LIMIT 1
12	0.0008	0.00084090232849121	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13	0.0092	0.0091829299926758	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14	0.0002	0.00024700164794922	SELECT * FROM pages WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor'
15	0.0002	0.00015497207641602	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0005	0.00053811073303223	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0006	0.00055193901062012	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 = 49
18	0.0002	0.00023198127746582	SELECT id FROM categories WHERE parent_id = '49'
19	0.0005	0.00053501129150391	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (49) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
20	0.0002	0.00015592575073242	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (49) AND p.disabled = 0
21	0.0002	0.00015091896057129	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (49) AND c.prod_type = 'ebay' AND ep.hide = 1
22	0.0002	0.00017595291137695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23	0.0001	0.00013113021850586	SELECT * FROM categorygroups WHERE id = '1'
24	0.0031	0.0030548572540283	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 = 50
25	0.0003	0.00026702880859375	SELECT id FROM categories WHERE parent_id = '50'
26	0.0002	0.00020694732666016	SELECT id FROM categories WHERE parent_id = '96'
27	0.0002	0.00020194053649902	SELECT id FROM categories WHERE parent_id = '97'
28	0.0002	0.00020098686218262	SELECT id FROM categories WHERE parent_id = '111'
29	0.0002	0.00021195411682129	SELECT id FROM categories WHERE parent_id = '129'
30	0.0063	0.0063049793243408	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (96,97,111,129,50) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
31	0.0002	0.00017595291137695	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (96,97,111,129,50) AND p.disabled = 0
32	0.0002	0.00015401840209961	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (96,97,111,129,50) AND c.prod_type = 'ebay' AND ep.hide = 1
33	0.0002	0.00017094612121582	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34	0.0001	0.0001370906829834	SELECT * FROM categorygroups WHERE id = '1'
35	0.0025	0.0024640560150146	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 = 80
36	0.0003	0.00026607513427734	SELECT id FROM categories WHERE parent_id = '80'
37	0.0025	0.0024728775024414	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (80) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
38	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (80) AND p.disabled = 0
39	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (80) AND c.prod_type = 'ebay' AND ep.hide = 1
40	0.0002	0.00015902519226074	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '1'
42	0.0012	0.0011579990386963	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 = 51
43	0.0003	0.00025200843811035	SELECT id FROM categories WHERE parent_id = '51'
44	0.0002	0.00020813941955566	SELECT id FROM categories WHERE parent_id = '101'
45	0.0018	0.0018069744110107	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (101,51) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
46	0.0002	0.0001518726348877	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (101,51) AND p.disabled = 0
47	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (101,51) AND c.prod_type = 'ebay' AND ep.hide = 1
48	0.0002	0.00016617774963379	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49	0.0001	0.00012493133544922	SELECT * FROM categorygroups WHERE id = '1'
50	0.0004	0.00040793418884277	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
51	0.0023	0.0023398399353027	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
52	0.0003	0.00028109550476074	SELECT id FROM categories WHERE parent_id = '30'
53	0.0023	0.0023128986358643	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
54	0.0002	0.00015687942504883	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
55	0.0001	0.00014781951904297	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'ebay' AND ep.hide = 1
56	0.0002	0.00018596649169922	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57	0.0001	0.00012683868408203	SELECT * FROM categorygroups WHERE id = '2'
58	0.0049	0.0048720836639404	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 = 61
59	0.0003	0.0002751350402832	SELECT id FROM categories WHERE parent_id = '61'
60	0.0048	0.00484299659729	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (61) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
61	0.0002	0.00015687942504883	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (61) AND p.disabled = 0
62	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (61) AND c.prod_type = 'ebay' AND ep.hide = 1
63	0.0002	0.00016498565673828	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '2'
65	0.0007	0.00066900253295898	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10' AND hidden = 0 ORDER BY sortorder ASC
66	0.0042	0.0041680335998535	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 = 64
67	0.0003	0.00027680397033691	SELECT id FROM categories WHERE parent_id = '64'
68	0.0041	0.0041110515594482	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (64) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
69	0.0002	0.00015997886657715	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (64) AND p.disabled = 0
70	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (64) AND c.prod_type = 'ebay' AND ep.hide = 1
71	0.0002	0.00016379356384277	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72	0.0001	0.0001380443572998	SELECT * FROM categorygroups WHERE id = '10'
73	0.0083	0.0082540512084961	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 = 65
74	0.0003	0.00028395652770996	SELECT id FROM categories WHERE parent_id = '65'
75	0.0083	0.0082800388336182	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (65) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
76	0.0002	0.00017714500427246	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (65) AND p.disabled = 0
77	0.0001	0.00014901161193848	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (65) AND c.prod_type = 'ebay' AND ep.hide = 1
78	0.0002	0.00016999244689941	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79	0.0001	0.00012683868408203	SELECT * FROM categorygroups WHERE id = '10'
80	0.0025	0.0024619102478027	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 = 81
81	0.0003	0.00027298927307129	SELECT id FROM categories WHERE parent_id = '81'
82	0.0025	0.0024650096893311	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (81) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
83	0.0002	0.00015902519226074	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (81) AND p.disabled = 0
84	0.0001	0.00014901161193848	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (81) AND c.prod_type = 'ebay' AND ep.hide = 1
85	0.0002	0.00015997886657715	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '10'
87	0.0025	0.0024559497833252	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 = 31
88	0.0003	0.00026106834411621	SELECT id FROM categories WHERE parent_id = '31'
89	0.0025	0.0024800300598145	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
90	0.0002	0.00015521049499512	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
91	0.0002	0.00015902519226074	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'ebay' AND ep.hide = 1
92	0.0002	0.0001680850982666	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93	0.0001	0.00012493133544922	SELECT * FROM categorygroups WHERE id = '10'
94	0.0023	0.0022549629211426	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 = 66
95	0.0003	0.00026202201843262	SELECT id FROM categories WHERE parent_id = '66'
96	0.0002	0.00022220611572266	SELECT id FROM categories WHERE parent_id = '131'
97	0.0028	0.0028159618377686	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (131,66) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
98	0.0002	0.00015592575073242	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (131,66) AND p.disabled = 0
99	0.0001	0.00014901161193848	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (131,66) AND c.prod_type = 'ebay' AND ep.hide = 1
100	0.0002	0.00016093254089355	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '10'
102	0.0095	0.009486198425293	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 = 34
103	0.0003	0.00029587745666504	SELECT id FROM categories WHERE parent_id = '34'
104	0.0002	0.00020503997802734	SELECT id FROM categories WHERE parent_id = '94'
105	0.0002	0.00020313262939453	SELECT id FROM categories WHERE parent_id = '98'
106	0.0002	0.00021219253540039	SELECT id FROM categories WHERE parent_id = '99'
107	0.0002	0.00020098686218262	SELECT id FROM categories WHERE parent_id = '110'
108	0.0002	0.0001990795135498	SELECT id FROM categories WHERE parent_id = '130'
109	0.0102	0.010152101516724	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (94,98,99,110,130,34) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
110	0.0002	0.00017714500427246	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (94,98,99,110,130,34) AND p.disabled = 0
111	0.0002	0.0001678466796875	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (94,98,99,110,130,34) AND c.prod_type = 'ebay' AND ep.hide = 1
112	0.0002	0.00017905235290527	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113	0.0001	0.00012707710266113	SELECT * FROM categorygroups WHERE id = '10'
114	0.0016	0.0015671253204346	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 = 32
115	0.0003	0.00026607513427734	SELECT id FROM categories WHERE parent_id = '32'
116	0.0016	0.0015840530395508	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (32) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
117	0.0002	0.00016117095947266	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (32) AND p.disabled = 0
118	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (32) AND c.prod_type = 'ebay' AND ep.hide = 1
119	0.0002	0.00016307830810547	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120	0.0001	0.0001227855682373	SELECT * FROM categorygroups WHERE id = '10'
121	0.0019	0.0019369125366211	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 = 89
122	0.0003	0.00025105476379395	SELECT id FROM categories WHERE parent_id = '89'
123	0.0020	0.0019569396972656	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (89) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
124	0.0001	0.00014591217041016	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (89) AND p.disabled = 0
125	0.0002	0.00016117095947266	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (89) AND c.prod_type = 'ebay' AND ep.hide = 1
126	0.0002	0.00016999244689941	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '10'
128	0.0004	0.00038409233093262	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17' AND hidden = 0 ORDER BY sortorder ASC
129	0.0007	0.00068902969360352	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 = 84
130	0.0002	0.00023198127746582	SELECT id FROM categories WHERE parent_id = '84'
131	0.0007	0.0007021427154541	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (84) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
132	0.0001	0.00014209747314453	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (84) AND p.disabled = 0
133	0.0001	0.00014209747314453	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (84) AND c.prod_type = 'ebay' AND ep.hide = 1
134	0.0002	0.00017094612121582	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '17'
136	0.0007	0.00068902969360352	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 = 90
137	0.0003	0.00025010108947754	SELECT id FROM categories WHERE parent_id = '90'
138	0.0007	0.00071406364440918	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (90) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
139	0.0001	0.00014901161193848	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (90) AND p.disabled = 0
140	0.0001	0.00014519691467285	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (90) AND c.prod_type = 'ebay' AND ep.hide = 1
141	0.0002	0.00015497207641602	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142	0.0001	0.0001218318939209	SELECT * FROM categorygroups WHERE id = '17'
143	0.0003	0.00029206275939941	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20' AND hidden = 0 ORDER BY sortorder ASC
144	0.0020	0.0020349025726318	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 = 92
145	0.0003	0.00025010108947754	SELECT id FROM categories WHERE parent_id = '92'
146	0.0020	0.0020358562469482	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (92) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
147	0.0001	0.00014710426330566	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (92) AND p.disabled = 0
148	0.0001	0.00014591217041016	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (92) AND c.prod_type = 'ebay' AND ep.hide = 1
149	0.0001	0.00014781951904297	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '20'
151	0.0051	0.0051450729370117	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152	0.0004	0.00038290023803711	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153	0.0002	0.00018692016601562	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
154	0.0002	0.00015497207641602	SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '67'
156	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '82'
157	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '84'
158	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '94'
159	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '116'
160	0.0002	0.00022101402282715	SELECT * FROM pages WHERE id = '52'
161	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '135'
162	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '245'
163	0.0002	0.00017189979553223	SELECT * FROM pages WHERE id = '269'
164	0.0002	0.00020384788513184	SELECT * FROM pages WHERE id = '275'
165	0.0002	0.00021696090698242	SELECT * FROM pages WHERE id = '280'
166	0.0002	0.00020599365234375	SELECT * FROM pages WHERE id = '357'
167	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '379'
168	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '401'
169	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '450'
170	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '454'
171	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '457'
172	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '458'
173	0.0002	0.00015902519226074	SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '41'
175	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '43'
176	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '44'
177	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '68'
178	0.0002	0.00021505355834961	SELECT * FROM pages WHERE id = '80'
179	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '85'
180	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '97'
181	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '107'
182	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '108'
183	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '128'
184	0.0002	0.00017118453979492	SELECT * FROM pages WHERE id = '133'
185	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '148'
186	0.0002	0.00016379356384277	SELECT * FROM pages WHERE id = '217'
187	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '228'
188	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '257'
189	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '271'
190	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '286'
191	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '287'
192	0.0002	0.00017189979553223	SELECT * FROM pages WHERE id = '291'
193	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '380'
194	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '344'
195	0.0305	0.030463933944702	SELECT * FROM pages WHERE id = '354'
196	0.0003	0.00027203559875488	SELECT * FROM pages WHERE id = '363'
197	0.0002	0.0001978874206543	SELECT * FROM pages WHERE id = '364'
198	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '368'
199	0.0002	0.00017309188842773	SELECT * FROM pages WHERE id = '369'
200	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '400'
201	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '463'
202	0.0002	0.00016999244689941	SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203	0.0003	0.0002748966217041	SELECT * FROM pages WHERE id = '66'
204	0.0002	0.00020384788513184	SELECT * FROM pages WHERE id = '77'
205	0.0002	0.00019097328186035	SELECT * FROM pages WHERE id = '90'
206	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '414'
207	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '119'
208	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '406'
209	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '149'
210	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '150'
211	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '412'
212	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '162'
213	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '164'
214	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '167'
215	0.0001	0.00013613700866699	SELECT * FROM pages WHERE id = '180'
216	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '187'
217	0.0002	0.0001981258392334	SELECT * FROM pages WHERE id = '265'
218	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '268'
219	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '411'
220	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '290'
221	0.0001	0.00014781951904297	SELECT * FROM pages WHERE id = '413'
222	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '409'
223	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '327'
224	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '336'
225	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '351'
226	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '358'
227	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '360'
228	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '362'
229	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '366'
230	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '370'
231	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '377'
232	0.0001	0.00014781951904297	SELECT * FROM pages WHERE id = '386'
233	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '408'
234	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '415'
235	0.0002	0.00017118453979492	SELECT * FROM pages WHERE id = '416'
236	0.0002	0.00019407272338867	SELECT * FROM pages WHERE id = '419'
237	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '423'
238	0.0002	0.00016379356384277	SELECT * FROM pages WHERE id = '427'
239	0.0002	0.00018310546875	SELECT * FROM pages WHERE id = '428'
240	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '432'
241	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '433'
242	0.0002	0.00015020370483398	SELECT * FROM pages WHERE id = '436'
243	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '437'
244	0.0001	0.00014376640319824	SELECT * FROM pages WHERE id = '461'
245	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '464'
246	0.0001	0.00014400482177734	SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '74'
248	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '137'
249	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '145'
250	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '156'
251	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '407'
252	0.0001	0.00014019012451172	SELECT * FROM pages WHERE id = '410'
253	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '266'
254	0.0002	0.00022792816162109	SELECT * FROM pages WHERE id = '316'
255	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '332'
256	0.0002	0.00019192695617676	SELECT * FROM pages WHERE id = '334'
257	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '367'
258	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '387'
259	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '389'
260	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '397'
261	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '449'
262	0.0002	0.00016117095947266	SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263	0.0002	0.00020813941955566	SELECT * FROM pages WHERE id = '42'
264	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '79'
265	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '86'
266	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '95'
267	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '102'
268	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '109'
269	0.0002	0.00024819374084473	SELECT * FROM pages WHERE id = '114'
270	0.0002	0.0001828670501709	SELECT * FROM pages WHERE id = '121'
271	0.0002	0.00022411346435547	SELECT * FROM pages WHERE id = '138'
272	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '142'
273	0.0002	0.00020885467529297	SELECT * FROM pages WHERE id = '62'
274	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '157'
275	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '246'
276	0.0002	0.00020503997802734	SELECT * FROM pages WHERE id = '276'
277	0.0002	0.00019979476928711	SELECT * FROM pages WHERE id = '278'
278	0.0073	0.0073339939117432	SELECT * FROM pages WHERE id = '279'
279	0.0002	0.00023388862609863	SELECT * FROM pages WHERE id = '317'
280	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '405'
281	0.0002	0.0002129077911377	SELECT * FROM pages WHERE id = '343'
282	0.0002	0.00019407272338867	SELECT * FROM pages WHERE id = '345'
283	0.0003	0.00025582313537598	SELECT * FROM pages WHERE id = '346'
284	0.0002	0.00020408630371094	SELECT * FROM pages WHERE id = '347'
285	0.0002	0.00018906593322754	SELECT * FROM pages WHERE id = '348'
286	0.0002	0.00019192695617676	SELECT * FROM pages WHERE id = '349'
287	0.0002	0.00018191337585449	SELECT * FROM pages WHERE id = '381'
288	0.0002	0.00017905235290527	SELECT * FROM pages WHERE id = '392'
289	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '393'
290	0.0002	0.00017189979553223	SELECT * FROM pages WHERE id = '394'
291	0.0002	0.00018477439880371	SELECT * FROM pages WHERE id = '395'
292	0.0003	0.00025200843811035	SELECT * FROM pages WHERE id = '399'
293	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '421'
294	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '426'
295	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '430'
296	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '431'
297	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '434'
298	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '435'
299	0.0002	0.00016617774963379	SELECT * FROM pages WHERE id = '440'
300	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '441'
301	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '451'
302	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '453'
303	0.0001	0.00014305114746094	SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304	0.0002	0.00017404556274414	SELECT * FROM pages WHERE id = '146'
305	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '158'
306	0.0001	0.0001378059387207	SELECT * FROM pages WHERE id = '163'
307	0.0003	0.00026416778564453	SELECT * FROM pages WHERE id = '293'
308	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '340'
309	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '417'
310	0.0001	0.0001370906829834	SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311	0.0002	0.00016188621520996	SELECT * FROM pages WHERE id = '173'
312	0.0002	0.0001678466796875	SELECT * FROM pages WHERE id = '181'
313	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '288'
314	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '299'
315	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '300'
316	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '383'
317	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '385'
318	0.0002	0.00016212463378906	SELECT * FROM pages WHERE id = '438'
319	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '442'
320	0.0001	0.0001368522644043	SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321	0.0003	0.00025296211242676	SELECT * FROM pages WHERE id = '103'
322	0.0002	0.00023293495178223	SELECT * FROM pages WHERE id = '134'
323	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '139'
324	0.0002	0.0001528263092041	SELECT * FROM pages WHERE id = '143'
325	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '234'
326	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '248'
327	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '260'
328	0.0002	0.00021982192993164	SELECT * FROM pages WHERE id = '398'
329	0.0002	0.00018787384033203	SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330	0.0002	0.00020790100097656	SELECT * FROM pages WHERE id = '61'
331	0.0002	0.00020122528076172	SELECT * FROM pages WHERE id = '87'
332	0.0002	0.00020384788513184	SELECT * FROM pages WHERE id = '104'
333	0.0003	0.00025081634521484	SELECT * FROM pages WHERE id = '115'
334	0.0002	0.00018000602722168	SELECT * FROM pages WHERE id = '124'
335	0.0002	0.0001838207244873	SELECT * FROM pages WHERE id = '144'
336	0.0002	0.00022411346435547	SELECT * FROM pages WHERE id = '151'
337	0.0002	0.00016689300537109	SELECT * FROM pages WHERE id = '199'
338	0.0002	0.00017809867858887	SELECT * FROM pages WHERE id = '200'
339	0.0002	0.00017786026000977	SELECT * FROM pages WHERE id = '304'
340	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '321'
341	0.0002	0.00018405914306641	SELECT * FROM pages WHERE id = '333'
342	0.0002	0.00020408630371094	SELECT * FROM pages WHERE id = '350'
343	0.0002	0.0001678466796875	SELECT * FROM pages WHERE id = '378'
344	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '422'
345	0.0002	0.00020194053649902	SELECT * FROM pages WHERE id = '425'
346	0.0002	0.00018000602722168	SELECT * FROM pages WHERE id = '443'
347	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '444'
348	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '445'
349	0.0002	0.00017714500427246	SELECT * FROM pages WHERE id = '446'
350	0.0002	0.0001678466796875	SELECT * FROM pages WHERE id = '447'
351	0.0002	0.00018715858459473	SELECT * FROM pages WHERE id = '448'
352	0.0002	0.00017380714416504	SELECT * FROM pages WHERE id = '455'
353	0.0002	0.00018215179443359	SELECT * FROM pages WHERE id = '456'
354	0.0002	0.00017380714416504	SELECT * FROM pages WHERE id = '459'
355	0.0002	0.00018978118896484	SELECT * FROM pages WHERE id = '460'
356	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '462'
357	0.0002	0.00017809867858887	SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358	0.0002	0.00019598007202148	SELECT * FROM pages WHERE id = '153'
359	0.0002	0.00024795532226562	SELECT * FROM pages WHERE id = '182'
360	0.0002	0.00020194053649902	SELECT * FROM pages WHERE id = '238'
361	0.0002	0.00017404556274414	SELECT * FROM pages WHERE id = '240'
362	0.0002	0.00016593933105469	SELECT * FROM pages WHERE id = '242'
363	0.0002	0.00016379356384277	SELECT * FROM pages WHERE id = '252'
364	0.0002	0.0001678466796875	SELECT * FROM pages WHERE id = '253'
365	0.0002	0.00018215179443359	SELECT * FROM pages WHERE id = '262'
366	0.0002	0.0001680850982666	SELECT * FROM pages WHERE id = '267'
367	0.0002	0.00017905235290527	SELECT * FROM pages WHERE id = '420'
368	0.0002	0.00016283988952637	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
369	0.0001	0.00014305114746094	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
370	0.0001	0.00014996528625488	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
371	0.0017	0.0016961097717285	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372	0.0002	0.00020503997802734	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
373	0.0001	0.00014400482177734	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
374	0.0001	0.0001380443572998	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
375	0.0004	0.00037288665771484	SELECT * FROM products WHERE pagename = 'first-texas-nonexgen-w-20x-magnification-night-owl-lightweight-monocolor'
376	0.0002	0.00023913383483887	SELECT * FROM manufacturers WHERE id = '7740'
377	0.0003	0.00027585029602051	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '7740'
378	0.0001	0.0001370906829834	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '7740' LIMIT 1
379	0.0002	0.0002288818359375	SELECT pagename, id FROM products p WHERE manufacturer_id = '7740' ORDER BY RAND() LIMIT 1
380	0.0003	0.0002591609954834	SELECT * FROM productimages WHERE product_id = '405132' ORDER BY sortorder ASC
381	0.0002	0.0002288818359375	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '7740'
382	0.0003	0.00026082992553711	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '7740' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
383	0.0001	0.00013494491577148	SELECT * FROM manufacturerimages WHERE manufacturer_id = '7740'
384	0.0002	0.00015687942504883	SELECT category_id FROM products_categories WHERE product_id = '405132'
385	0.0002	0.00019407272338867	SELECT * FROM categories WHERE id = '81'
386	0.0031	0.0030767917633057	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 = 81
387	0.0001	0.00013184547424316	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 81
388	0.0003	0.00026702880859375	SELECT id FROM categories WHERE parent_id = '81'
389	0.0025	0.0025038719177246	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (81) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
390	0.0002	0.00015711784362793	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (81) AND p.disabled = 0
391	0.0002	0.0001521110534668	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (81) AND c.prod_type = 'ebay' AND ep.hide = 1
392	0.0002	0.00016498565673828	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
393	0.0002	0.00019407272338867	SELECT * FROM productimages WHERE product_id = '405132' ORDER BY sortorder ASC
394	0.0002	0.00023317337036133	SELECT * FROM product_image_select WHERE product_id = '405132'
395	0.0001	0.00012493133544922	SELECT * FROM productcustomimages WHERE product_id = '405132'
396	0.0001	0.00011205673217773	SELECT * FROM productfeeds WHERE product_id = '405132' ORDER BY item_date DESC
397	0.0004	0.00036191940307617	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398	0.0003	0.00031590461730957	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '405132' AND t.hidden = 0 AND display_product = 1
399	0.0001	0.00014805793762207	SELECT * FROM tags WHERE id = '3261'
400	0.0014	0.0014150142669678	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3261' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
401	0.0013	0.001345157623291	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3261' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
402	0.0014	0.0013890266418457	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3261' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403	0.0003	0.0003049373626709	SELECT * FROM productimages WHERE product_id = '407361' ORDER BY sortorder ASC
404	0.0004	0.00042414665222168	SELECT * FROM productamazoncontent WHERE product_id = '405132'
405	0.0035	0.0034608840942383	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname
406	0.0002	0.00017905235290527	SELECT * FROM productoffers WHERE product_id = '405132' AND merchantid = 'ATVPDKIKX0DER'
407	0.0002	0.00019216537475586	SELECT * FROM productoffers WHERE product_id = '405132' AND price > 0 ORDER BY price ASC LIMIT 1
408	0.0002	0.00015997886657715	SELECT * FROM productoffers WHERE product_id = 405132 ORDER BY price ASC LIMIT 1
409	0.0002	0.00022697448730469	SELECT value FROM productattributes WHERE product_id = '405132' AND name = 'ListPriceAmount'
410	0.0004	0.00044393539428711	SELECT value FROM productattributes WHERE product_id = '405132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
411	0.2360	0.23597502708435	SELECT *, MATCH (description, keyfeatures, title) AGAINST ('night' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('night' IN BOOLEAN MODE) AND 405132 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
412	0.0003	0.0003209114074707	SELECT * FROM productimages WHERE product_id = '37914' ORDER BY sortorder ASC
413	0.0002	0.00022387504577637	SELECT * FROM product_image_select WHERE product_id = '37914'
414	0.0001	0.00012612342834473	SELECT * FROM productcustomimages WHERE product_id = '37914'
415	0.0027	0.0026540756225586	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '37914' AND a.name = n.originalname
416	0.0002	0.00019001960754395	SELECT * FROM productoffers WHERE product_id = '37914' AND merchantid = 'ATVPDKIKX0DER'
417	0.0002	0.00021791458129883	SELECT * FROM productoffers WHERE product_id = '37914' AND price > 0 ORDER BY price ASC LIMIT 1
418	0.0004	0.00039911270141602	SELECT value FROM productattributes WHERE product_id = '37914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
419	0.0001	0.00013899803161621	UPDATE products SET price = '17718' WHERE id = '37914'
420	0.0002	0.00022292137145996	SELECT * FROM productimages WHERE product_id = '37917' ORDER BY sortorder ASC
421	0.0003	0.00026988983154297	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '37917' AND p.id = pi.product_id ORDER BY pi.sortorder
422	0.0002	0.00020909309387207	SELECT * FROM product_image_select WHERE product_id = '37917'
423	0.0001	0.00011897087097168	SELECT * FROM productcustomimages WHERE product_id = '37917'
424	0.0003	0.00025296211242676	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 = '37917' GROUP BY o.product_id
425	0.0003	0.00031018257141113	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 = '37917' GROUP BY n.displayname ORDER BY n.displayname DESC
426	0.0002	0.00020098686218262	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 37917
427	0.0029	0.002938985824585	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '37917' AND a.name = n.originalname
428	0.0002	0.00017499923706055	SELECT * FROM productoffers WHERE product_id = '37917' AND merchantid = 'ATVPDKIKX0DER'
429	0.0002	0.00017595291137695	SELECT * FROM productoffers WHERE product_id = '37917' AND price > 0 ORDER BY price ASC LIMIT 1
430	0.0002	0.00016283988952637	SELECT * FROM productoffers WHERE product_id = 37917 ORDER BY price ASC LIMIT 1
431	0.0003	0.00026607513427734	SELECT value FROM productattributes WHERE product_id = '37917' AND name = 'ListPriceAmount'
432	0.0002	0.00022792816162109	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 = '37917' GROUP BY o.product_id
433	0.0003	0.00028491020202637	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 = '37917' GROUP BY n.displayname ORDER BY n.displayname DESC
434	0.0002	0.00020503997802734	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 37917
435	0.0004	0.00040817260742188	SELECT value FROM productattributes WHERE product_id = '37917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
436	0.0001	0.00012516975402832	UPDATE products SET price = '16899' WHERE id = '37917'
437	0.0003	0.0003209114074707	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '37917' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
438	0.0003	0.00031495094299316	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '37917' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
439	0.0002	0.00022006034851074	SELECT * FROM products WHERE parent_id = '37917'
440	0.0002	0.00021791458129883	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414494' AND a.name = n.originalname
441	0.0002	0.00020503997802734	SELECT * FROM productoffers WHERE product_id = '414494' AND merchantid = 'ATVPDKIKX0DER'
442	0.0002	0.0001988410949707	SELECT * FROM productoffers WHERE product_id = '414494' AND price > 0 ORDER BY price ASC LIMIT 1
443	0.0002	0.00022292137145996	SELECT * FROM productimages WHERE product_id = '54902' ORDER BY sortorder ASC
444	0.0002	0.00021195411682129	SELECT * FROM product_image_select WHERE product_id = '54902'
445	0.0001	0.00011992454528809	SELECT * FROM productcustomimages WHERE product_id = '54902'
446	0.0028	0.0027940273284912	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '54902' AND a.name = n.originalname
447	0.0002	0.0001981258392334	SELECT * FROM productoffers WHERE product_id = '54902' AND merchantid = 'ATVPDKIKX0DER'
448	0.0002	0.00019693374633789	SELECT * FROM productoffers WHERE product_id = '54902' AND price > 0 ORDER BY price ASC LIMIT 1
449	0.0004	0.00040006637573242	SELECT value FROM productattributes WHERE product_id = '54902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450	0.0001	0.00012397766113281	UPDATE products SET price = '8500' WHERE id = '54902'
451	0.0003	0.00025010108947754	SELECT * FROM productimages WHERE product_id = '90437' ORDER BY sortorder ASC
452	0.0002	0.0002129077911377	SELECT * FROM product_image_select WHERE product_id = '90437'
453	0.0001	0.00012087821960449	SELECT * FROM productcustomimages WHERE product_id = '90437'
454	0.0021	0.0020759105682373	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90437' AND a.name = n.originalname
455	0.0002	0.00018095970153809	SELECT * FROM productoffers WHERE product_id = '90437' AND merchantid = 'ATVPDKIKX0DER'
456	0.0002	0.00020503997802734	SELECT * FROM productoffers WHERE product_id = '90437' AND price > 0 ORDER BY price ASC LIMIT 1
457	0.0003	0.00031399726867676	SELECT value FROM productattributes WHERE product_id = '90437' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458	0.0001	0.00011897087097168	UPDATE products SET price = '10149' WHERE id = '90437'
459	0.0003	0.00032305717468262	SELECT * FROM productimages WHERE product_id = '109549' ORDER BY sortorder ASC
460	0.0002	0.00021982192993164	SELECT * FROM product_image_select WHERE product_id = '109549'
461	0.0001	0.00012016296386719	SELECT * FROM productcustomimages WHERE product_id = '109549'
462	0.0014	0.0013880729675293	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '109549' AND a.name = n.originalname
463	0.0002	0.00018095970153809	SELECT * FROM productoffers WHERE product_id = '109549' AND merchantid = 'ATVPDKIKX0DER'
464	0.0002	0.00020503997802734	SELECT * FROM productoffers WHERE product_id = '109549' AND price > 0 ORDER BY price ASC LIMIT 1
465	0.0003	0.00032210350036621	SELECT value FROM productattributes WHERE product_id = '109549' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466	0.0001	0.00011992454528809	UPDATE products SET price = '12995' WHERE id = '109549'
467	0.0003	0.00027585029602051	SELECT * FROM productimages WHERE product_id = '272720' ORDER BY sortorder ASC
468	0.0002	0.00021600723266602	SELECT * FROM product_image_select WHERE product_id = '272720'
469	0.0001	0.00011992454528809	SELECT * FROM productcustomimages WHERE product_id = '272720'
470	0.0030	0.0030100345611572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '272720' AND a.name = n.originalname
471	0.0002	0.00018596649169922	SELECT * FROM productoffers WHERE product_id = '272720' AND merchantid = 'ATVPDKIKX0DER'
472	0.0002	0.00020003318786621	SELECT * FROM productoffers WHERE product_id = '272720' AND price > 0 ORDER BY price ASC LIMIT 1
473	0.0004	0.00042295455932617	SELECT value FROM productattributes WHERE product_id = '272720' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474	0.0001	0.00012397766113281	UPDATE products SET price = '14997' WHERE id = '272720'
475	0.0001	0.00013899803161621	SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME'
476	0.0001	0.00011897087097168	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
477	0.0001	0.00014090538024902	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
478	0.0001	0.00011682510375977	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
479	0.0001	0.00011706352233887	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
480	0.0001	0.00011491775512695	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
481	0.0001	0.00013303756713867	SELECT * FROM ebay_locale_details WHERE cur_code = 'USD'
482	0.2134	0.21336388587952	SELECT * FROM ebay_products_cache WHERE cachekey = '1c2deec590fc23ea5506757ffe3c2587'
483	0.0003	0.00027203559875488	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
484	0.0001	0.00012612342834473	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
485	0.0001	0.0001220703125	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
486	0.0001	0.00012087821960449	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
487	0.0001	0.00011801719665527	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
488	0.2093	0.20933604240417	SELECT * FROM ebay_products_cache WHERE cachekey = '1c2deec590fc23ea5506757ffe3c2587'
489	0.0003	0.00029492378234863	SELECT id,asin FROM products WHERE parent_id = 405132
490	0.0003	0.00033092498779297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405132' ORDER BY timestamp DESC
491	0.0001	0.00014686584472656	SELECT category_id FROM products_categories WHERE product_id = '405132'
492	0.0002	0.00015687942504883	SELECT * FROM categories WHERE id = '81'
493	0.0025	0.0025441646575928	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 = 81
494	0.0001	0.00012803077697754	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 81
495	0.0003	0.00025606155395508	SELECT id FROM categories WHERE parent_id = '81'
496	0.0025	0.0024697780609131	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (81) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
497	0.0002	0.00015902519226074	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (81) AND p.disabled = 0
498	0.0002	0.0001521110534668	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (81) AND c.prod_type = 'ebay' AND ep.hide = 1
499	0.0002	0.00016498565673828	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
500	0.0035	0.0034809112548828	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405132' AND a.name = n.originalname

First Texas NONEXGEN-W 2.0x Magnification Night Owl LightWeight Monocolor by Night Owl Security

Product Description

Manufacturer Description

Product Features

Write a Review

Related Products

Night Owl Lighweight Night Vision Monocu...

ATN Digital Night Vision Monocular from ...

Armasight Mounting System #4 for Day-Tim...

Trijicon 3-Dot Night Sight Set for Sig P...

Lasertac Rechargeable Subcompact Green L...

Pulsar L-808S Laser IR Night Vision Acce...

Current deals from eBay

NEW First Texas Bounty Hunter Metal ... $ 132.00

9 Day(s) 7 h(s)

Worldwide

First Texas Products Metal Detector ... $ 123.99

21 Day(s) 16 h(s)

Worldwide

FREE SHIPPING! First Texas Products ... $ 134.99

9 Day(s) 23 h(s)

Worldwide

The First Texas Cook Book 1883 ( Rep... $ 10.99

28 Day(s) 8 h(s)

Worldwide

The First Texas Legion by Allen G. H... $ 29.95

6 Day(s) 14 h(s)

Worldwide

3x5 Conrad Zavala Independence 1st R... $ 8.88

12 Day(s) 19 h(s)

Worldwide

3x5 1st Cavalry 11 Star Texas Magnol... $ 7.99

28 Day(s) 15 h(s)

Worldwide

Texas Historical First Flag Tuxedo S... $ 49.99

15 Day(s) 9 h(s)

Worldwide

(Lot of 2) 3x5 First Republic of Tex... $ 10.44

21 Day(s) 7 h(s)

Worldwide

Burnet's 1st Texas Republic Polyeste... $ 5.95

15 Day(s) 12 h(s)

Worldwide

Tactical Gear

Survival Gear

Tactical Optics

Weapons

Reviewed Products

Newsletter

Survival Articles

Tactical Articles

Rifle Scope Reviews

Night Vision Reviews

Knife & Tool Reviews

Spotting Scope Reviews

Laser Range Finder Reviews

Flashlight Reviews

Product Reviews

Manufacturers

Check Price On Amazon

FREE DOWNLOAD

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.2566318511963 seconds

Query Debug - 749 Database Queries. Total time 1.1440 seconds