0 items

NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle by Nightforce

Price: Click Button for Price

As of 2019-06-23 23:11:09 UTC (more info)

Product prices and availability are accurate as of 2019-06-23 23:11:09 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

Our Combat Gear shop is proud to present the quality NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle today at this limited price.

With so many competing tactical, combat and survival products on offer right now, it is wise to have a make that you can trust. The NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle is certainly all that and will be a sound acquisition for your combat equipment or tactical ability.

We pride ourselves to provide the best quality tactical gear for all your training requirements.

For this special price, the NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle comes greatly respected and is a favored choice for lots of like minded people. Nightforce have provided some nice touches and this equals improved value.

Manufacturer Description

NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle C460

Product Features

Nightforce,ATACR,Riflescope,w/ Zerostop RIFLESCOPE 1 Mil-Radian NXS Objective Diameter: 32mm

Nightforce

User Reviews
Amazon Product Reviews

Write a Review

See more NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle by Nightforce on eBay

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.0901038646698	747	1.3702	0

No Amazon API Requests Made.

App Debug - Total Time 2.0901038646698 seconds

Number	Time From Start	Name	Description
1	0.50236797332764	Initialise	Initialise FSB Function
2	0.5044310092926	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.51565504074097	Start of getCategoryListByGroup Function	Before first category groups query
4	0.5158269405365	After initial query	Before first category groups query
5	0.51582789421082	Get Category List for Group	Before the call to getCategoryList function
6	0.51583194732666	Start of GetCategoryList function	Start of the function
7	0.51583695411682	Before getting categories	Query to get specific category list
8	0.51641583442688	After getting categories	Query to get specific category list
9	0.51641702651978	Before getting category custom	Before call to function getCategoryCustom
10	0.51828598976135	After getting category custom	After call to function getCategoryCustom
11	0.51828789710999	Before getting category custom	Before call to function getCategoryCustom
12	0.52890706062317	After getting category custom	After call to function getCategoryCustom
13	0.52891087532043	Before getting category custom	Before call to function getCategoryCustom
14	0.53447198867798	After getting category custom	After call to function getCategoryCustom
15	0.53447484970093	Before getting category custom	Before call to function getCategoryCustom
16	0.53859400749207	After getting category custom	After call to function getCategoryCustom
17	0.53859686851501	End of GetCategoryList function	End of the function
18	0.53860783576965	Get Category List for Group	Before the call to getCategoryList function
19	0.53861093521118	Start of GetCategoryList function	Start of the function
20	0.53861403465271	Before getting categories	Query to get specific category list
21	0.5390419960022	After getting categories	Query to get specific category list
22	0.53904390335083	Before getting category custom	Before call to function getCategoryCustom
23	0.54459404945374	After getting category custom	After call to function getCategoryCustom
24	0.54459691047668	Before getting category custom	Before call to function getCategoryCustom
25	0.5552339553833	After getting category custom	After call to function getCategoryCustom
26	0.55523705482483	End of GetCategoryList function	End of the function
27	0.55524587631226	Get Category List for Group	Before the call to getCategoryList function
28	0.55524897575378	Start of GetCategoryList function	Start of the function
29	0.55525302886963	Before getting categories	Query to get specific category list
30	0.55596685409546	After getting categories	Query to get specific category list
31	0.55596899986267	Before getting category custom	Before call to function getCategoryCustom
32	0.56527900695801	After getting category custom	After call to function getCategoryCustom
33	0.56528186798096	Before getting category custom	Before call to function getCategoryCustom
34	0.58277201652527	After getting category custom	After call to function getCategoryCustom
35	0.58277606964111	Before getting category custom	Before call to function getCategoryCustom
36	0.58934688568115	After getting category custom	After call to function getCategoryCustom
37	0.58934903144836	Before getting category custom	Before call to function getCategoryCustom
38	0.59558200836182	After getting category custom	After call to function getCategoryCustom
39	0.59558391571045	Before getting category custom	Before call to function getCategoryCustom
40	0.60282897949219	After getting category custom	After call to function getCategoryCustom
41	0.60283184051514	Before getting category custom	Before call to function getCategoryCustom
42	0.62730884552002	After getting category custom	After call to function getCategoryCustom
43	0.62731289863586	Before getting category custom	Before call to function getCategoryCustom
44	0.63176989555359	After getting category custom	After call to function getCategoryCustom
45	0.63177299499512	Before getting category custom	Before call to function getCategoryCustom
46	0.63681983947754	After getting category custom	After call to function getCategoryCustom
47	0.63682198524475	End of GetCategoryList function	End of the function
48	0.63683795928955	Get Category List for Group	Before the call to getCategoryList function
49	0.63684105873108	Start of GetCategoryList function	Start of the function
50	0.63684391975403	Before getting categories	Query to get specific category list
51	0.63725304603577	After getting categories	Query to get specific category list
52	0.63725399971008	Before getting category custom	Before call to function getCategoryCustom
53	0.63967490196228	After getting category custom	After call to function getCategoryCustom
54	0.63967704772949	Before getting category custom	Before call to function getCategoryCustom
55	0.64217305183411	After getting category custom	After call to function getCategoryCustom
56	0.64217495918274	End of GetCategoryList function	End of the function
57	0.64218091964722	Get Category List for Group	Before the call to getCategoryList function
58	0.64218306541443	Start of GetCategoryList function	Start of the function
59	0.64218592643738	Before getting categories	Query to get specific category list
60	0.64248991012573	After getting categories	Query to get specific category list
61	0.64249086380005	Before getting category custom	Before call to function getCategoryCustom
62	0.64759683609009	After getting category custom	After call to function getCategoryCustom
63	0.64759993553162	End of GetCategoryList function	End of the function
64	0.64760589599609	End of getCategoryListByGroup Function	Before return()
65	0.69728803634644	App Controller End	End of the App controller (called before the controller of every page)
66	0.69789791107178	Product Start	Start of the product info controller
67	0.69871401786804	Cache file not found	Starting get product details
68	0.73867702484131	Related products	Start getting related products if enabled
69	0.73867893218994	Related Products Start	Before the related products are found
70	0.73867988586426	Related Products Keywords	Before the related product keywords are found
71	0.73868703842163	Create Keyword List Function	Start of function
72	0.73927187919617	Create Keyword List Function	After looping provided content - 334 keywords found
73	0.76033997535706	Create Keyword List Function	After looping initial keyword list - 296 keywords remaining
74	0.76041984558105	Create Keyword List Function	After reducing keyword list
75	0.76184701919556	Create Keyword List Function	After selecting by scoring keywords
76	0.76185393333435	Create Keyword List Function	After final loop of keywords
77	0.76185584068298	Related Products Keywords	After the related product keywords are found
78	1.1104118824005	Related Products End	After the related products are found
79	1.3188149929047	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
80	1.4499399662018	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
81	1.7114250659943	Product End	End of the product info controller (Product Info)
82	1.7118020057678	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
83	1.7118968963623	Before Get Options	Before the call to getOptions in the tpl class
84	2.0500988960266	After Get Options	After the call to getOptions in the tpl class
85	2.0502939224243	App_after Controller End	End of the App_after controller (called after the controller of every page)
86	2.0503079891205	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
87	2.0662019252777	Product Info: After Smarty Fetch	After the product.tpl template is fetched
88	2.0662100315094	Product Info: Before Template Display	Before the template is displayed
89	2.0900800228119	Product Info: After Template Display	After the template is displayed
90	2.0900859832764	Finalizing debug	Before the debug is output to the page.
91	2.0901029109955	End of App	This is the end of the app logging, final timestamp

Query Debug - 747 Database Queries. Total time 1.3702 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 = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle' LIMIT 1
SELECT id FROM products WHERE pagename = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle' 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 = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle'
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 = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle'
SELECT * FROM manufacturers WHERE id = '1247'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1247'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '1247' LIMIT 1
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1247'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '1247'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '1247'
SELECT category_id FROM products_categories WHERE product_id = '406509'
SELECT * FROM categories WHERE id = '34'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 productimages WHERE product_id = '406509' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406509'
SELECT * FROM productcustomimages WHERE product_id = '406509'
SELECT * FROM productfeeds WHERE product_id = '406509' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '406509' 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 = '406509' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '3334'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3334'
				  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 = '3334'
				  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 = '3334' 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 = '274141' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '406509'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406509' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406509' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 406509
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '406509'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '406509' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('nightforce' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('nightforce' IN BOOLEAN MODE) AND 406509 <> 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 = '47380' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '47380'
SELECT * FROM productcustomimages WHERE product_id = '47380'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '47380' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '47380' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '47380' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '47380' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '25900' WHERE id = '47380'
SELECT * FROM productimages WHERE product_id = '26100' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '26100'
SELECT * FROM productcustomimages WHERE product_id = '26100'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26100' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '26100' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '26100' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '26100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '132600' WHERE id = '26100'
SELECT * FROM productimages WHERE product_id = '28249' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '28249'
SELECT * FROM productcustomimages WHERE product_id = '28249'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28249' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '28249' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '28249' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '28249' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '132600' WHERE id = '28249'
SELECT * FROM productimages WHERE product_id = '128973' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '128973'
SELECT * FROM productcustomimages WHERE product_id = '128973'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128973' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '128973' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '128973' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '128973' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '18400' WHERE id = '128973'
SELECT * FROM productimages WHERE product_id = '112976' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '112976'
SELECT * FROM productcustomimages WHERE product_id = '112976'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '112976' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '112976' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '112976' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '112976' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19000' WHERE id = '112976'
SELECT * FROM productimages WHERE product_id = '198882' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '198882'
SELECT * FROM productcustomimages WHERE product_id = '198882'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '198882' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '198882' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '198882' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '198882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '209000' WHERE id = '198882'
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 = 'deca7d0fe4b0fdc993725b957b534845' 
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 = 'deca7d0fe4b0fdc993725b957b534845' 
SELECT id,asin FROM products WHERE parent_id = 406509
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406509' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '406509'
SELECT * FROM categories WHERE id = '34'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406509' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406509' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 406509
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '406509'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '406509'
SELECT value FROM productattributes WHERE product_id = '406509' 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 = '406509' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406509' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406509' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 406509
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '406509'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '406509'
SELECT parent_id FROM categories WHERE id = '34'
SELECT * FROM categories WHERE id = '34'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 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:1561608598;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:11;s:6:\"412382\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";i:18;s:6:\"408078\";i:23;s:6:\"398823\";}}' WHERE id = '175'
SELECT * FROM products WHERE id IN (398315,412382,414825,414188,408078,398823) ORDER BY FIELD(id, 398315,412382,414825,414188,408078,398823 )
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '398315'
SELECT * FROM productcustomimages WHERE product_id = '398315'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1999' WHERE id = '398315'
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '412382'
SELECT * FROM productcustomimages WHERE product_id = '412382'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '3199' WHERE id = '412382'
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414825'
SELECT * FROM productcustomimages WHERE product_id = '414825'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '11999' WHERE id = '414825'
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414188'
SELECT * FROM productcustomimages WHERE product_id = '414188'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414188'
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408078'
SELECT * FROM productcustomimages WHERE product_id = '408078'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '24109' WHERE id = '408078'
SELECT * FROM productimages WHERE product_id = '398823' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '398823'
SELECT * FROM productcustomimages WHERE product_id = '398823'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398823' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '398823' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '398823' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '398823' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2147' WHERE id = '398823'
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:1561608599;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:7;s:6:\"410950\";i:9;s:6:\"402983\";i:14;s:6:\"247027\";i:15;s:6:\"406758\";i:18;s:6:\"408078\";}}' WHERE id = '177'
SELECT * FROM products WHERE id IN (407595,410950,402983,247027,406758,408078) ORDER BY FIELD(id, 407595,410950,402983,247027,406758,408078 )
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407595'
SELECT * FROM productcustomimages WHERE product_id = '407595'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2497' WHERE id = '407595'
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '410950'
SELECT * FROM productcustomimages WHERE product_id = '410950'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '399999' WHERE id = '410950'
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '402983'
SELECT * FROM productcustomimages WHERE product_id = '402983'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '10392' WHERE id = '402983'
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '247027'
SELECT * FROM productcustomimages WHERE product_id = '247027'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1492' WHERE id = '247027'
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406758'
SELECT * FROM productcustomimages WHERE product_id = '406758'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2694' WHERE id = '406758'
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408078'
SELECT * FROM productcustomimages WHERE product_id = '408078'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '24109' WHERE id = '408078'
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:1561608599;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:9;s:6:\"402983\";i:13;s:6:\"414188\";i:15;s:6:\"406758\";i:20;s:6:\"131163\";i:21;s:6:\"406901\";}}' WHERE id = '181'
SELECT * FROM products WHERE id IN (407595,402983,414188,406758,131163,406901) ORDER BY FIELD(id, 407595,402983,414188,406758,131163,406901 )
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407595'
SELECT * FROM productcustomimages WHERE product_id = '407595'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2497' WHERE id = '407595'
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '402983'
SELECT * FROM productcustomimages WHERE product_id = '402983'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '10392' WHERE id = '402983'
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414188'
SELECT * FROM productcustomimages WHERE product_id = '414188'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414188'
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406758'
SELECT * FROM productcustomimages WHERE product_id = '406758'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2694' WHERE id = '406758'
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '131163'
SELECT * FROM productcustomimages WHERE product_id = '131163'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '20362' WHERE id = '131163'
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406901'
SELECT * FROM productcustomimages WHERE product_id = '406901'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '395' WHERE id = '406901'
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:1561608599;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:6;s:6:\"185812\";i:7;s:6:\"410950\";i:11;s:6:\"412382\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";}}' WHERE id = '183'
SELECT * FROM products WHERE id IN (414940,185812,410950,412382,414825,414188) ORDER BY FIELD(id, 414940,185812,410950,412382,414825,414188 )
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414940'
SELECT * FROM productcustomimages WHERE product_id = '414940'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '4490' WHERE id = '414940'
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '185812'
SELECT * FROM productcustomimages WHERE product_id = '185812'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '314900' WHERE id = '185812'
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '410950'
SELECT * FROM productcustomimages WHERE product_id = '410950'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '399999' WHERE id = '410950'
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '412382'
SELECT * FROM productcustomimages WHERE product_id = '412382'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '3199' WHERE id = '412382'
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414825'
SELECT * FROM productcustomimages WHERE product_id = '414825'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '11999' WHERE id = '414825'
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414188'
SELECT * FROM productcustomimages WHERE product_id = '414188'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414188'
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.0001678466796875	SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2	0.0006	0.00056815147399902	SHOW TABLES LIKE 'bad_bots'
3	0.0002	0.00018811225891113	SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4	0.0002	0.00015902519226074	SELECT * FROM `bad_bots`
5	0.0005	0.00051498413085938	SELECT parameter, value FROM parameters
6	0.0001	0.00014805793762207	SET time_zone = 'Europe/London'
7	0.0004	0.00040197372436523	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0001	0.00014495849609375	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0001	0.00011086463928223	delete from cachefiles
10	0.0002	0.00024700164794922	SELECT id FROM pages WHERE pagename = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle' LIMIT 1
11	0.0002	0.00024604797363281	SELECT id FROM products WHERE pagename = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle' AND hidden = 0 LIMIT 1
12	0.0008	0.00079107284545898	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13	0.0094	0.0093550682067871	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14	0.0003	0.00026798248291016	SELECT * FROM pages WHERE pagename = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle'
15	0.0002	0.00015592575073242	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.0005	0.00047898292541504	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.0003	0.00025391578674316	SELECT id FROM categories WHERE parent_id = '49'
19	0.0004	0.0004420280456543	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.0001	0.00014281272888184	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.0001	0.00014996528625488	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.00018095970153809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23	0.0001	0.00012588500976562	SELECT * FROM categorygroups WHERE id = '1'
24	0.0030	0.0029809474945068	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.00028204917907715	SELECT id FROM categories WHERE parent_id = '50'
26	0.0002	0.00020408630371094	SELECT id FROM categories WHERE parent_id = '96'
27	0.0002	0.0001988410949707	SELECT id FROM categories WHERE parent_id = '97'
28	0.0002	0.00020909309387207	SELECT id FROM categories WHERE parent_id = '111'
29	0.0002	0.0001988410949707	SELECT id FROM categories WHERE parent_id = '129'
30	0.0057	0.0057060718536377	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.00019693374633789	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.00016093254089355	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.00017905235290527	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34	0.0001	0.00012993812561035	SELECT * FROM categorygroups WHERE id = '1'
35	0.0023	0.0022878646850586	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.00028204917907715	SELECT id FROM categories WHERE parent_id = '80'
37	0.0023	0.0022938251495361	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.0002	0.0001530647277832	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.0002	0.00015807151794434	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.00012397766113281	SELECT * FROM categorygroups WHERE id = '1'
42	0.0012	0.0011520385742188	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.00025796890258789	SELECT id FROM categories WHERE parent_id = '51'
44	0.0002	0.00021505355834961	SELECT id FROM categories WHERE parent_id = '101'
45	0.0018	0.0017859935760498	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.00016212463378906	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.0002	0.0001518726348877	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.00016689300537109	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49	0.0001	0.0001227855682373	SELECT * FROM categorygroups WHERE id = '1'
50	0.0004	0.00040292739868164	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
51	0.0023	0.0023019313812256	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.00025606155395508	SELECT id FROM categories WHERE parent_id = '30'
53	0.0023	0.0022799968719482	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.00015902519226074	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.0002	0.0001530647277832	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.00017094612121582	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57	0.0001	0.00012588500976562	SELECT * FROM categorygroups WHERE id = '2'
58	0.0048	0.0047879219055176	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.00030398368835449	SELECT id FROM categories WHERE parent_id = '61'
60	0.0048	0.004784107208252	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.00016498565673828	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.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 (61) AND c.prod_type = 'ebay' AND ep.hide = 1
63	0.0002	0.00016689300537109	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64	0.0001	0.00013089179992676	SELECT * FROM categorygroups WHERE id = '2'
65	0.0006	0.00064992904663086	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10' AND hidden = 0 ORDER BY sortorder ASC
66	0.0041	0.0041310787200928	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.00028896331787109	SELECT id FROM categories WHERE parent_id = '64'
68	0.0041	0.0041389465332031	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.00016403198242188	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.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 (64) AND c.prod_type = 'ebay' AND ep.hide = 1
71	0.0002	0.00017714500427246	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72	0.0001	0.00012993812561035	SELECT * FROM categorygroups WHERE id = '10'
73	0.0081	0.0081450939178467	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.00032186508178711	SELECT id FROM categories WHERE parent_id = '65'
75	0.0083	0.0082600116729736	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.00017309188842773	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.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 (65) AND c.prod_type = 'ebay' AND ep.hide = 1
78	0.0002	0.00017690658569336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79	0.0001	0.00012993812561035	SELECT * FROM categorygroups WHERE id = '10'
80	0.0028	0.0027880668640137	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.00027894973754883	SELECT id FROM categories WHERE parent_id = '81'
82	0.0028	0.0028080940246582	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.0001518726348877	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.00017380714416504	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '10'
87	0.0028	0.0028150081634521	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.00025415420532227	SELECT id FROM categories WHERE parent_id = '31'
89	0.0025	0.002471923828125	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.00016212463378906	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.0001	0.00014686584472656	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.00016498565673828	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '10'
94	0.0028	0.002777099609375	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.00025701522827148	SELECT id FROM categories WHERE parent_id = '66'
96	0.0002	0.00020503997802734	SELECT id FROM categories WHERE parent_id = '131'
97	0.0033	0.0033111572265625	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.00014996528625488	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.00015902519226074	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '10'
102	0.0107	0.010657072067261	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.00028896331787109	SELECT id FROM categories WHERE parent_id = '34'
104	0.0002	0.00020313262939453	SELECT id FROM categories WHERE parent_id = '94'
105	0.0002	0.00021100044250488	SELECT id FROM categories WHERE parent_id = '98'
106	0.0002	0.00020098686218262	SELECT id FROM categories WHERE parent_id = '99'
107	0.0002	0.0001990795135498	SELECT id FROM categories WHERE parent_id = '110'
108	0.0002	0.0001990795135498	SELECT id FROM categories WHERE parent_id = '130'
109	0.0117	0.011709928512573	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.00017690658569336	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.00015401840209961	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.0001981258392334	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113	0.0001	0.00013089179992676	SELECT * FROM categorygroups WHERE id = '10'
114	0.0017	0.0017280578613281	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.00026488304138184	SELECT id FROM categories WHERE parent_id = '32'
116	0.0018	0.0018031597137451	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.0001	0.00014519691467285	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.00014400482177734	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.00015997886657715	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '10'
121	0.0021	0.0020561218261719	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.0002601146697998	SELECT id FROM categories WHERE parent_id = '89'
123	0.0021	0.0020561218261719	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.00014805793762207	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.0001	0.00014400482177734	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.00016498565673828	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.00038480758666992	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17' AND hidden = 0 ORDER BY sortorder ASC
129	0.0007	0.00073814392089844	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.00023913383483887	SELECT id FROM categories WHERE parent_id = '84'
131	0.0008	0.00077104568481445	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.0002	0.0001521110534668	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.00014495849609375	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.00016212463378906	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135	0.0001	0.00012111663818359	SELECT * FROM categorygroups WHERE id = '17'
136	0.0008	0.00079202651977539	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.0002	0.00023293495178223	SELECT id FROM categories WHERE parent_id = '90'
138	0.0008	0.00081396102905273	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.00014209747314453	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.00014185905456543	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.00015401840209961	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142	0.0001	0.00013089179992676	SELECT * FROM categorygroups WHERE id = '17'
143	0.0003	0.00029110908508301	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20' AND hidden = 0 ORDER BY sortorder ASC
144	0.0021	0.0020849704742432	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.0002	0.00024819374084473	SELECT id FROM categories WHERE parent_id = '92'
146	0.0021	0.0021078586578369	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.0002	0.00015497207641602	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.00014615058898926	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.00014710426330566	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150	0.0001	0.00012588500976562	SELECT * FROM categorygroups WHERE id = '20'
151	0.0052	0.0051681995391846	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152	0.0004	0.00037002563476562	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153	0.0002	0.00018811225891113	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
154	0.0002	0.00016999244689941	SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '67'
156	0.0002	0.00015878677368164	SELECT * FROM pages WHERE id = '82'
157	0.0002	0.00016021728515625	SELECT * FROM pages WHERE id = '84'
158	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '94'
159	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '116'
160	0.0002	0.00020790100097656	SELECT * FROM pages WHERE id = '52'
161	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '135'
162	0.0002	0.00015377998352051	SELECT * FROM pages WHERE id = '245'
163	0.0002	0.00016283988952637	SELECT * FROM pages WHERE id = '269'
164	0.0002	0.00018596649169922	SELECT * FROM pages WHERE id = '275'
165	0.0002	0.00019288063049316	SELECT * FROM pages WHERE id = '280'
166	0.0002	0.00018405914306641	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.0002	0.00015521049499512	SELECT * FROM pages WHERE id = '454'
171	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '457'
172	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '458'
173	0.0001	0.00014901161193848	SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '41'
175	0.0002	0.00016283988952637	SELECT * FROM pages WHERE id = '43'
176	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '44'
177	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '68'
178	0.0002	0.00019311904907227	SELECT * FROM pages WHERE id = '80'
179	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '85'
180	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '97'
181	0.0002	0.00016593933105469	SELECT * FROM pages WHERE id = '107'
182	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '108'
183	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '128'
184	0.0002	0.00015878677368164	SELECT * FROM pages WHERE id = '133'
185	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '148'
186	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '217'
187	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '228'
188	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '257'
189	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '271'
190	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '286'
191	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '287'
192	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '291'
193	0.0002	0.00016212463378906	SELECT * FROM pages WHERE id = '380'
194	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '344'
195	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '354'
196	0.0002	0.00017714500427246	SELECT * FROM pages WHERE id = '363'
197	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '364'
198	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '368'
199	0.0002	0.00017714500427246	SELECT * FROM pages WHERE id = '369'
200	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '400'
201	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '463'
202	0.0002	0.00016093254089355	SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203	0.0002	0.00024509429931641	SELECT * FROM pages WHERE id = '66'
204	0.0002	0.00019001960754395	SELECT * FROM pages WHERE id = '77'
205	0.0002	0.00018310546875	SELECT * FROM pages WHERE id = '90'
206	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '414'
207	0.0001	0.00014519691467285	SELECT * FROM pages WHERE id = '119'
208	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '406'
209	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '149'
210	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '150'
211	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '412'
212	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '162'
213	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '164'
214	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '167'
215	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '180'
216	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '187'
217	0.0002	0.00018405914306641	SELECT * FROM pages WHERE id = '265'
218	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '268'
219	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '411'
220	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '290'
221	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '413'
222	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '409'
223	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '327'
224	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '336'
225	0.0002	0.00015521049499512	SELECT * FROM pages WHERE id = '351'
226	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '358'
227	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '360'
228	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '362'
229	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '366'
230	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '370'
231	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '377'
232	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '386'
233	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '408'
234	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '415'
235	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '416'
236	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '419'
237	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '423'
238	0.0002	0.00016283988952637	SELECT * FROM pages WHERE id = '427'
239	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '428'
240	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '432'
241	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '433'
242	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '436'
243	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '437'
244	0.0002	0.00015521049499512	SELECT * FROM pages WHERE id = '461'
245	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '464'
246	0.0001	0.00014305114746094	SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '74'
248	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '137'
249	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '145'
250	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '156'
251	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '407'
252	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '410'
253	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '266'
254	0.0002	0.00019383430480957	SELECT * FROM pages WHERE id = '316'
255	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '332'
256	0.0002	0.00017786026000977	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.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '389'
260	0.0002	0.0001528263092041	SELECT * FROM pages WHERE id = '397'
261	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '449'
262	0.0002	0.00016188621520996	SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '42'
264	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '79'
265	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '86'
266	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '95'
267	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '102'
268	0.0001	0.00014519691467285	SELECT * FROM pages WHERE id = '109'
269	0.0002	0.00019598007202148	SELECT * FROM pages WHERE id = '114'
270	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '121'
271	0.0002	0.00018596649169922	SELECT * FROM pages WHERE id = '138'
272	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '142'
273	0.0002	0.00018310546875	SELECT * FROM pages WHERE id = '62'
274	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '157'
275	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '246'
276	0.0002	0.00018501281738281	SELECT * FROM pages WHERE id = '276'
277	0.0002	0.00018787384033203	SELECT * FROM pages WHERE id = '278'
278	0.0002	0.00019598007202148	SELECT * FROM pages WHERE id = '279'
279	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '317'
280	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '405'
281	0.0002	0.0001680850982666	SELECT * FROM pages WHERE id = '343'
282	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '345'
283	0.0002	0.00018405914306641	SELECT * FROM pages WHERE id = '346'
284	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '347'
285	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '348'
286	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '349'
287	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '381'
288	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '392'
289	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '393'
290	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '394'
291	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '395'
292	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '399'
293	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '421'
294	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '426'
295	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '430'
296	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '431'
297	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '434'
298	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '435'
299	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '440'
300	0.0002	0.00016379356384277	SELECT * FROM pages WHERE id = '441'
301	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '451'
302	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '453'
303	0.0001	0.00013589859008789	SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '146'
305	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '158'
306	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '163'
307	0.0002	0.00020694732666016	SELECT * FROM pages WHERE id = '293'
308	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '340'
309	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '417'
310	0.0001	0.0001370906829834	SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '173'
312	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '181'
313	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '288'
314	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '299'
315	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '300'
316	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '383'
317	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '385'
318	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '438'
319	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '442'
320	0.0001	0.00013518333435059	SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321	0.0002	0.00021910667419434	SELECT * FROM pages WHERE id = '103'
322	0.0002	0.00022292137145996	SELECT * FROM pages WHERE id = '134'
323	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '139'
324	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '143'
325	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '234'
326	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '248'
327	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '260'
328	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '398'
329	0.0001	0.00014996528625488	SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '61'
331	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '87'
332	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '104'
333	0.0002	0.00018811225891113	SELECT * FROM pages WHERE id = '115'
334	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '124'
335	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '144'
336	0.0002	0.00017309188842773	SELECT * FROM pages WHERE id = '151'
337	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '199'
338	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '200'
339	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '304'
340	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '321'
341	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '333'
342	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '350'
343	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '378'
344	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '422'
345	0.0002	0.00018191337585449	SELECT * FROM pages WHERE id = '425'
346	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '443'
347	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '444'
348	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '445'
349	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '446'
350	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '447'
351	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '448'
352	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '455'
353	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '456'
354	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '459'
355	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '460'
356	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '462'
357	0.0001	0.00013995170593262	SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '153'
359	0.0002	0.00019693374633789	SELECT * FROM pages WHERE id = '182'
360	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '238'
361	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '240'
362	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '242'
363	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '252'
364	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '253'
365	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '262'
366	0.0001	0.00013494491577148	SELECT * FROM pages WHERE id = '267'
367	0.0001	0.00014519691467285	SELECT * FROM pages WHERE id = '420'
368	0.0001	0.0001380443572998	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
369	0.0001	0.00012397766113281	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
370	0.0001	0.00011587142944336	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
371	0.0014	0.0014469623565674	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372	0.0002	0.00016880035400391	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
373	0.0001	0.00011992454528809	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
374	0.0001	0.00011897087097168	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
375	0.0003	0.00029802322387695	SELECT * FROM products WHERE pagename = 'nightforce-25-10x42mm-nxs-illuminated-compact-riflescope-w-ihr-reticle'
376	0.0002	0.00020098686218262	SELECT * FROM manufacturers WHERE id = '1247'
377	0.0010	0.0010008811950684	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1247'
378	0.0001	0.00013589859008789	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '1247' LIMIT 1
379	0.0009	0.00089311599731445	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1247'
380	0.0010	0.00095105171203613	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '1247' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
381	0.0001	0.0001378059387207	SELECT * FROM manufacturerimages WHERE manufacturer_id = '1247'
382	0.0001	0.0001368522644043	SELECT category_id FROM products_categories WHERE product_id = '406509'
383	0.0002	0.00023388862609863	SELECT * FROM categories WHERE id = '34'
384	0.0104	0.010375022888184	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
385	0.0001	0.00014996528625488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
386	0.0003	0.00027108192443848	SELECT id FROM categories WHERE parent_id = '34'
387	0.0002	0.00020503997802734	SELECT id FROM categories WHERE parent_id = '94'
388	0.0002	0.0001990795135498	SELECT id FROM categories WHERE parent_id = '98'
389	0.0002	0.00020599365234375	SELECT id FROM categories WHERE parent_id = '99'
390	0.0002	0.0001978874206543	SELECT id FROM categories WHERE parent_id = '110'
391	0.0002	0.00019693374633789	SELECT id FROM categories WHERE parent_id = '130'
392	0.0106	0.010555028915405	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
393	0.0002	0.0001838207244873	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
394	0.0002	0.00015997886657715	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
395	0.0002	0.00017905235290527	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
396	0.0002	0.0001988410949707	SELECT * FROM productimages WHERE product_id = '406509' ORDER BY sortorder ASC
397	0.0002	0.00022697448730469	SELECT * FROM product_image_select WHERE product_id = '406509'
398	0.0001	0.0001218318939209	SELECT * FROM productcustomimages WHERE product_id = '406509'
399	0.0001	0.00011181831359863	SELECT * FROM productfeeds WHERE product_id = '406509' ORDER BY item_date DESC
400	0.0004	0.00036406517028809	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
401	0.0003	0.00034999847412109	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '406509' AND t.hidden = 0 AND display_product = 1
402	0.0001	0.00014305114746094	SELECT * FROM tags WHERE id = '3334'
403	0.0018	0.0017940998077393	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3334' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
404	0.0015	0.0015361309051514	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3334' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
405	0.0017	0.0016860961914062	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3334' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
406	0.0003	0.0002739429473877	SELECT * FROM productimages WHERE product_id = '274141' ORDER BY sortorder ASC
407	0.0002	0.00016593933105469	SELECT * FROM productamazoncontent WHERE product_id = '406509'
408	0.0043	0.0043458938598633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname
409	0.0002	0.00019001960754395	SELECT * FROM productoffers WHERE product_id = '406509' AND merchantid = 'ATVPDKIKX0DER'
410	0.0002	0.00019598007202148	SELECT * FROM productoffers WHERE product_id = '406509' AND price > 0 ORDER BY price ASC LIMIT 1
411	0.0002	0.00017499923706055	SELECT * FROM productoffers WHERE product_id = 406509 ORDER BY price ASC LIMIT 1
412	0.0003	0.00026392936706543	SELECT value FROM productattributes WHERE product_id = '406509' AND name = 'ListPriceAmount'
413	0.0005	0.00046110153198242	SELECT value FROM productattributes WHERE product_id = '406509' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414	0.2397	0.23966193199158	SELECT *, MATCH (description, keyfeatures, title) AGAINST ('nightforce' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('nightforce' IN BOOLEAN MODE) AND 406509 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
415	0.0004	0.00039005279541016	SELECT * FROM productimages WHERE product_id = '47380' ORDER BY sortorder ASC
416	0.0002	0.00021719932556152	SELECT * FROM product_image_select WHERE product_id = '47380'
417	0.0001	0.00012302398681641	SELECT * FROM productcustomimages WHERE product_id = '47380'
418	0.0034	0.0033891201019287	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '47380' AND a.name = n.originalname
419	0.0002	0.00020694732666016	SELECT * FROM productoffers WHERE product_id = '47380' AND merchantid = 'ATVPDKIKX0DER'
420	0.0002	0.00020885467529297	SELECT * FROM productoffers WHERE product_id = '47380' AND price > 0 ORDER BY price ASC LIMIT 1
421	0.0004	0.0003969669342041	SELECT value FROM productattributes WHERE product_id = '47380' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422	0.0001	0.0001368522644043	UPDATE products SET price = '25900' WHERE id = '47380'
423	0.0003	0.00032496452331543	SELECT * FROM productimages WHERE product_id = '26100' ORDER BY sortorder ASC
424	0.0002	0.00020885467529297	SELECT * FROM product_image_select WHERE product_id = '26100'
425	0.0001	0.00011897087097168	SELECT * FROM productcustomimages WHERE product_id = '26100'
426	0.0026	0.0026330947875977	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26100' AND a.name = n.originalname
427	0.0002	0.00018405914306641	SELECT * FROM productoffers WHERE product_id = '26100' AND merchantid = 'ATVPDKIKX0DER'
428	0.0002	0.00019502639770508	SELECT * FROM productoffers WHERE product_id = '26100' AND price > 0 ORDER BY price ASC LIMIT 1
429	0.0004	0.00039005279541016	SELECT value FROM productattributes WHERE product_id = '26100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430	0.0001	0.00012302398681641	UPDATE products SET price = '132600' WHERE id = '26100'
431	0.0003	0.00033998489379883	SELECT * FROM productimages WHERE product_id = '28249' ORDER BY sortorder ASC
432	0.0002	0.00022482872009277	SELECT * FROM product_image_select WHERE product_id = '28249'
433	0.0001	0.0001220703125	SELECT * FROM productcustomimages WHERE product_id = '28249'
434	0.0029	0.0029449462890625	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28249' AND a.name = n.originalname
435	0.0002	0.00019693374633789	SELECT * FROM productoffers WHERE product_id = '28249' AND merchantid = 'ATVPDKIKX0DER'
436	0.0002	0.00020909309387207	SELECT * FROM productoffers WHERE product_id = '28249' AND price > 0 ORDER BY price ASC LIMIT 1
437	0.0004	0.00039982795715332	SELECT value FROM productattributes WHERE product_id = '28249' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438	0.0001	0.00013995170593262	UPDATE products SET price = '132600' WHERE id = '28249'
439	0.0003	0.00026106834411621	SELECT * FROM productimages WHERE product_id = '128973' ORDER BY sortorder ASC
440	0.0002	0.00021004676818848	SELECT * FROM product_image_select WHERE product_id = '128973'
441	0.0001	0.00012588500976562	SELECT * FROM productcustomimages WHERE product_id = '128973'
442	0.0035	0.003471851348877	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128973' AND a.name = n.originalname
443	0.0002	0.00019192695617676	SELECT * FROM productoffers WHERE product_id = '128973' AND merchantid = 'ATVPDKIKX0DER'
444	0.0002	0.00020384788513184	SELECT * FROM productoffers WHERE product_id = '128973' AND price > 0 ORDER BY price ASC LIMIT 1
445	0.0004	0.00044894218444824	SELECT value FROM productattributes WHERE product_id = '128973' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446	0.0001	0.00013399124145508	UPDATE products SET price = '18400' WHERE id = '128973'
447	0.0003	0.00025606155395508	SELECT * FROM productimages WHERE product_id = '112976' ORDER BY sortorder ASC
448	0.0002	0.00022482872009277	SELECT * FROM product_image_select WHERE product_id = '112976'
449	0.0001	0.00012707710266113	SELECT * FROM productcustomimages WHERE product_id = '112976'
450	0.0034	0.0033869743347168	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '112976' AND a.name = n.originalname
451	0.0002	0.00019001960754395	SELECT * FROM productoffers WHERE product_id = '112976' AND merchantid = 'ATVPDKIKX0DER'
452	0.0002	0.00020980834960938	SELECT * FROM productoffers WHERE product_id = '112976' AND price > 0 ORDER BY price ASC LIMIT 1
453	0.0004	0.00042200088500977	SELECT value FROM productattributes WHERE product_id = '112976' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
454	0.0001	0.00013303756713867	UPDATE products SET price = '19000' WHERE id = '112976'
455	0.0004	0.00041818618774414	SELECT * FROM productimages WHERE product_id = '198882' ORDER BY sortorder ASC
456	0.0002	0.00022315979003906	SELECT * FROM product_image_select WHERE product_id = '198882'
457	0.0001	0.00013303756713867	SELECT * FROM productcustomimages WHERE product_id = '198882'
458	0.0030	0.0030419826507568	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '198882' AND a.name = n.originalname
459	0.0002	0.00020813941955566	SELECT * FROM productoffers WHERE product_id = '198882' AND merchantid = 'ATVPDKIKX0DER'
460	0.0002	0.00020503997802734	SELECT * FROM productoffers WHERE product_id = '198882' AND price > 0 ORDER BY price ASC LIMIT 1
461	0.0004	0.00042510032653809	SELECT value FROM productattributes WHERE product_id = '198882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
462	0.0784	0.078400850296021	UPDATE products SET price = '209000' WHERE id = '198882'
463	0.0002	0.00020790100097656	SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME'
464	0.0001	0.00012588500976562	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
465	0.0001	0.00013589859008789	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
466	0.0001	0.00012803077697754	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
467	0.0001	0.00012707710266113	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
468	0.0001	0.00012707710266113	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
469	0.0002	0.0001530647277832	SELECT * FROM ebay_locale_details WHERE cur_code = 'USD'
470	0.2062	0.20618009567261	SELECT * FROM ebay_products_cache WHERE cachekey = 'deca7d0fe4b0fdc993725b957b534845'
471	0.0003	0.00027894973754883	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
472	0.0001	0.00012516975402832	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
473	0.0001	0.00011920928955078	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
474	0.0001	0.00011706352233887	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
475	0.0001	0.00011610984802246	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
476	0.2063	0.20634603500366	SELECT * FROM ebay_products_cache WHERE cachekey = 'deca7d0fe4b0fdc993725b957b534845'
477	0.0003	0.00028109550476074	SELECT id,asin FROM products WHERE parent_id = 406509
478	0.0003	0.00034308433532715	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406509' ORDER BY timestamp DESC
479	0.0001	0.00014305114746094	SELECT category_id FROM products_categories WHERE product_id = '406509'
480	0.0002	0.00023388862609863	SELECT * FROM categories WHERE id = '34'
481	0.0096	0.0095829963684082	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
482	0.0002	0.0001528263092041	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
483	0.0003	0.00027704238891602	SELECT id FROM categories WHERE parent_id = '34'
484	0.0002	0.0002138614654541	SELECT id FROM categories WHERE parent_id = '94'
485	0.0002	0.00021100044250488	SELECT id FROM categories WHERE parent_id = '98'
486	0.0002	0.00020003318786621	SELECT id FROM categories WHERE parent_id = '99'
487	0.0002	0.00020003318786621	SELECT id FROM categories WHERE parent_id = '110'
488	0.0002	0.0001981258392334	SELECT id FROM categories WHERE parent_id = '130'
489	0.0101	0.010119915008545	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
490	0.0002	0.00019001960754395	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
491	0.0002	0.00016212463378906	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
492	0.0002	0.00018501281738281	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
493	0.0036	0.0036239624023438	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname
494	0.0002	0.00018191337585449	SELECT * FROM productoffers WHERE product_id = '406509' AND merchantid = 'ATVPDKIKX0DER'
495	0.0002	0.00019192695617676	SELECT * FROM productoffers WHERE product_id = '406509' AND price > 0 ORDER BY price ASC LIMIT 1
496	0.0002	0.00016188621520996	SELECT * FROM productoffers WHERE product_id = 406509 ORDER BY price ASC LIMIT 1
497	0.0002	0.00022983551025391	SELECT value FROM productattributes WHERE product_id = '406509' AND name = 'ListPriceAmount'
498	0.0002	0.00021600723266602	SELECT * FROM products WHERE id = '406509'
499	0.0004	0.0004429817199707	SELECT value FROM productattributes WHERE product_id = '406509' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
500	0.0036	0.0036160945892334	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406509' AND a.name = n.originalname

NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle by Nightforce

Product Description

Manufacturer Description

Product Features

Write a Review

Nightforce 1.375" Unimount Scope Mo...

NightForce 8-32x56 Precision Benchrest I...

New, NEW NightForce 8-32x56 Precision Be...

Nightforce A265 Ultralite 6 Screw Scope ...

Nightforce Optics Ultralite 1.125" ...

NightForce Tactical 5.5-22x50 NXS Rifles...

New, NightForce 2.5-10x42mm NXS Illu... $ 1990.00

29 Day(s) 5 h(s)

Worldwide

Tactical Gear

Survival Gear

Tactical Optics

Weapons

Reviewed Products

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.0901038646698 seconds

Query Debug - 747 Database Queries. Total time 1.3702 seconds

NightForce 2.5-10x42mm NXS Illuminated Compact Riflescope w/ IHR Reticle by Nightforce

Product Description

Manufacturer Description

Product Features

Write a Review

Related Products

Nightforce 1.375" Unimount Scope Mo...

NightForce 8-32x56 Precision Benchrest I...

New, NEW NightForce 8-32x56 Precision Be...

Nightforce A265 Ultralite 6 Screw Scope ...

Nightforce Optics Ultralite 1.125" ...

NightForce Tactical 5.5-22x50 NXS Rifles...

Current deals from eBay

New, NightForce 2.5-10x42mm NXS Illu... $ 1990.00

29 Day(s) 5 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.0901038646698 seconds

Query Debug - 747 Database Queries. Total time 1.3702 seconds