0 items

Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm from Bushnell

Price: $165.23 $157.49

As of 2019-06-25 06:42:08 UTC (more info)

Product prices and availability are accurate as of 2019-06-25 06:42:08 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.

You Save: $7.74 (5%)

Availability: In Stock

Click and Choose Options

Usually ships in 24 hours

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

Tactical Survivalist : Combat Gear : Survival Gear : Combat Equipment is proud to stock the brilliant Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm today at this limited price.

With so many competing tactical, combat and survival products available recently, it is great to have a provider that you can trust. The Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm is certainly all that and will be a perfect acquisition for your combat kit or tactical training.

We pride ourselves to provide the finest quality survivalist gear for all your training requirements.

For this great price, the Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm comes greatly recommended and is always a favored choice amongst lots of like minded people. Bushnell have added some great touches and this means great value for money.

Manufacturer Description

Ask any prize hunter. They'll inform you more tags are filled in the low-light hours than any other time. Enter the Bushnell Banner 6-24x 40 Mil Dot riflescope, a scope designed to master early-morning and late-evening light. Including Dusk & Dawn Brightness (DDB) multi-coated lenses for clearness and brightness in low light, you'll add precious minutes to every searching day with the Banner Dusk & Dawn series. With one-piece tube design, the Banner Dusk & Dawn line consists of a full selection of specialty scopes for big-game, varmint,.22 rimfire, slug, black powder and turkey searching.

Product Features

6-24x magnification 40mm objective Mil-Dot reticle One piece tube construction Dry-nitrogen filled 1/4 M.O.A. fingertip, resettable windage and elevation adjustment Riflescope with 40mm objective lens with 6x to 24x magnification Dusk & Dawn Brightness (DDB) multi-coated lens; fast-focus eyepiece Mil dot reticle Field-of-view at 100-yards is 17-feet at 6x, 5-feet at 24x 100-percent waterproof/fogproof/shockproof construction

Reticle

User Reviews
Amazon Product Reviews

Write a Review

See more Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm from Bushnell on eBay

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.7191669940948	763	1.2681	0

No Amazon API Requests Made.

App Debug - Total Time 2.7191669940948 seconds

Number	Time From Start	Name	Description
1	0.65972304344177	Initialise	Initialise FSB Function
2	0.67107892036438	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.68268990516663	Start of getCategoryListByGroup Function	Before first category groups query
4	0.68288087844849	After initial query	Before first category groups query
5	0.68288207054138	Get Category List for Group	Before the call to getCategoryList function
6	0.68288898468018	Start of GetCategoryList function	Start of the function
7	0.68289303779602	Before getting categories	Query to get specific category list
8	0.6834990978241	After getting categories	Query to get specific category list
9	0.68350100517273	Before getting category custom	Before call to function getCategoryCustom
10	0.68549990653992	After getting category custom	After call to function getCategoryCustom
11	0.68550300598145	Before getting category custom	Before call to function getCategoryCustom
12	0.69614195823669	After getting category custom	After call to function getCategoryCustom
13	0.69614505767822	Before getting category custom	Before call to function getCategoryCustom
14	0.70171904563904	After getting category custom	After call to function getCategoryCustom
15	0.70172190666199	Before getting category custom	Before call to function getCategoryCustom
16	0.70591592788696	After getting category custom	After call to function getCategoryCustom
17	0.70591902732849	End of GetCategoryList function	End of the function
18	0.70592999458313	Get Category List for Group	Before the call to getCategoryList function
19	0.70593309402466	Start of GetCategoryList function	Start of the function
20	0.70593595504761	Before getting categories	Query to get specific category list
21	0.70639991760254	After getting categories	Query to get specific category list
22	0.70640206336975	Before getting category custom	Before call to function getCategoryCustom
23	0.71203207969666	After getting category custom	After call to function getCategoryCustom
24	0.7120349407196	Before getting category custom	Before call to function getCategoryCustom
25	0.72248196601868	After getting category custom	After call to function getCategoryCustom
26	0.72248506546021	End of GetCategoryList function	End of the function
27	0.722491979599	Get Category List for Group	Before the call to getCategoryList function
28	0.72249507904053	Start of GetCategoryList function	Start of the function
29	0.72249794006348	Before getting categories	Query to get specific category list
30	0.72323298454285	After getting categories	Query to get specific category list
31	0.72323393821716	Before getting category custom	Before call to function getCategoryCustom
32	0.73239207267761	After getting category custom	After call to function getCategoryCustom
33	0.73239493370056	Before getting category custom	Before call to function getCategoryCustom
34	0.74963808059692	After getting category custom	After call to function getCategoryCustom
35	0.74964189529419	Before getting category custom	Before call to function getCategoryCustom
36	0.75570893287659	After getting category custom	After call to function getCategoryCustom
37	0.75571203231812	Before getting category custom	Before call to function getCategoryCustom
38	0.76190209388733	After getting category custom	After call to function getCategoryCustom
39	0.76190590858459	Before getting category custom	Before call to function getCategoryCustom
40	0.7682409286499	After getting category custom	After call to function getCategoryCustom
41	0.76824402809143	Before getting category custom	Before call to function getCategoryCustom
42	0.78992295265198	After getting category custom	After call to function getCategoryCustom
43	0.78992700576782	Before getting category custom	Before call to function getCategoryCustom
44	0.79409694671631	After getting category custom	After call to function getCategoryCustom
45	0.79410004615784	Before getting category custom	Before call to function getCategoryCustom
46	0.79880309104919	After getting category custom	After call to function getCategoryCustom
47	0.79880595207214	End of GetCategoryList function	End of the function
48	0.79882001876831	Get Category List for Group	Before the call to getCategoryList function
49	0.79882287979126	Start of GetCategoryList function	Start of the function
50	0.79882597923279	Before getting categories	Query to get specific category list
51	0.79928088188171	After getting categories	Query to get specific category list
52	0.79928302764893	Before getting category custom	Before call to function getCategoryCustom
53	0.8016369342804	After getting category custom	After call to function getCategoryCustom
54	0.80163908004761	Before getting category custom	Before call to function getCategoryCustom
55	0.80404496192932	After getting category custom	After call to function getCategoryCustom
56	0.80404710769653	End of GetCategoryList function	End of the function
57	0.80405402183533	Get Category List for Group	Before the call to getCategoryList function
58	0.80405592918396	Start of GetCategoryList function	Start of the function
59	0.80405902862549	Before getting categories	Query to get specific category list
60	0.80439209938049	After getting categories	Query to get specific category list
61	0.80439305305481	Before getting category custom	Before call to function getCategoryCustom
62	0.80940890312195	After getting category custom	After call to function getCategoryCustom
63	0.80941104888916	End of GetCategoryList function	End of the function
64	0.80941700935364	End of getCategoryListByGroup Function	Before return()
65	0.86057806015015	App Controller End	End of the App controller (called before the controller of every page)
66	0.86118006706238	Product Start	Start of the product info controller
67	0.8620970249176	Cache file not found	Starting get product details
68	0.90366506576538	Related products	Start getting related products if enabled
69	0.9036660194397	Related Products Start	Before the related products are found
70	0.90366697311401	Related Products Keywords	Before the related product keywords are found
71	0.90367794036865	Create Keyword List Function	Start of function
72	0.90483808517456	Create Keyword List Function	After looping provided content - 734 keywords found
73	0.9546320438385	Create Keyword List Function	After looping initial keyword list - 685 keywords remaining
74	0.95481491088867	Create Keyword List Function	After reducing keyword list
75	0.955894947052	Create Keyword List Function	After selecting by scoring keywords
76	0.95590090751648	Create Keyword List Function	After final loop of keywords
77	0.95590305328369	Related Products Keywords	After the related product keywords are found
78	1.2209520339966	Related Products End	After the related products are found
79	1.4207720756531	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
80	1.551656961441	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
81	1.8044309616089	Product End	End of the product info controller (Product Info)
82	1.8048410415649	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
83	1.8049778938293	Before Get Options	Before the call to getOptions in the tpl class
84	2.1473169326782	After Get Options	After the call to getOptions in the tpl class
85	2.1475870609283	App_after Controller End	End of the App_after controller (called after the controller of every page)
86	2.1476008892059	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
87	2.5182619094849	Product Info: After Smarty Fetch	After the product.tpl template is fetched
88	2.5182681083679	Product Info: Before Template Display	Before the template is displayed
89	2.7191460132599	Product Info: After Template Display	After the template is displayed
90	2.71915102005	Finalizing debug	Before the debug is output to the page.
91	2.7191660404205	End of App	This is the end of the app logging, final timestamp

Query Debug - 763 Database Queries. Total time 1.2681 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 = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm' LIMIT 1
SELECT id FROM products WHERE pagename = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm' 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 = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm'
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 = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm'
SELECT * FROM manufacturers WHERE id = '344'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '344' LIMIT 1
SELECT pagename, id FROM products p WHERE manufacturer_id = '344' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '199783' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '344'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '344'
SELECT category_id FROM products_categories WHERE product_id = '399477'
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 categories WHERE id = '120'
SELECT * FROM categories WHERE id = '130'
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 = 130
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 130
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 (130)
				  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 (130)
				  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 (130)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
SELECT * FROM productimages WHERE product_id = '399477' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '399477'
SELECT * FROM productcustomimages WHERE product_id = '399477'
SELECT * FROM productfeeds WHERE product_id = '399477' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '399477' 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 = '399477' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '3345'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3345'
				  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 = '3345'
				  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 = '3345' 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 = '232837' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '399477'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '399477' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '399477' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '399477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '15749' WHERE id = '399477'
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AND 399477 <> 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 = '28477' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '28477'
SELECT * FROM productcustomimages WHERE product_id = '28477'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '28477' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '28477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '47724' WHERE id = '28477'
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 = '156919' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '156919'
SELECT * FROM productcustomimages WHERE product_id = '156919'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '156919' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '156919' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '156919' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '156919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '156919'
SELECT * FROM productimages WHERE product_id = '131949' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '131949'
SELECT * FROM productcustomimages WHERE product_id = '131949'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131949' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '131949' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '131949' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '131949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '11995' WHERE id = '131949'
SELECT * FROM productimages WHERE product_id = '136817' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '136817'
SELECT * FROM productcustomimages WHERE product_id = '136817'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '136817' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '136817' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '136817' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '136817' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19480' WHERE id = '136817'
SELECT * FROM productimages WHERE product_id = '184781' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '184781'
SELECT * FROM productcustomimages WHERE product_id = '184781'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '184781' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '184781' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '184781' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '184781' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '47289' WHERE id = '184781'
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 = '23a703ed4d83dd23408268a5e2ffe5b7' 
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 = '23a703ed4d83dd23408268a5e2ffe5b7' 
SELECT id,asin FROM products WHERE parent_id = 399477
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '399477' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '399477'
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 categories WHERE id = '120'
SELECT * FROM categories WHERE id = '130'
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 = 130
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 130
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 (130)
				  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 (130)
				  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 (130)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '399477' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '399477' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM products WHERE id = '399477'
SELECT value FROM productattributes WHERE product_id = '399477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '15749' WHERE id = '399477'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '399477' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '399477' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT category_id FROM products_categories WHERE product_id = '399477'
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:1561545558;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:10;s:6:\"414825\";i:12;s:6:\"247027\";i:22;s:6:\"258602\";i:2;s:6:\"398858\";}}' WHERE id = '175'
SELECT * FROM products WHERE id IN (414940,398315,414825,247027,258602,398858) ORDER BY FIELD(id, 414940,398315,414825,247027,258602,398858 )
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 = '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 = '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 = '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 = '258602' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '258602'
SELECT * FROM productcustomimages WHERE product_id = '258602'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '19900' WHERE id = '258602'
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '398858'
SELECT * FROM productcustomimages WHERE product_id = '398858'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2999' WHERE id = '398858'
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND 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:1561545558;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:8;s:6:\"408792\";i:16;s:6:\"408078\";i:23;s:6:\"404072\";i:1;s:6:\"398315\";i:5;s:6:\"185812\";}}' WHERE id = '177'
SELECT * FROM products WHERE id IN (171938,408792,408078,404072,398315,185812) ORDER BY FIELD(id, 171938,408792,408078,404072,398315,185812 )
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '171938'
SELECT * FROM productcustomimages WHERE product_id = '171938'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '388900' WHERE id = '171938'
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408792'
SELECT * FROM productcustomimages WHERE product_id = '408792'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '13499' WHERE id = '408792'
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 = '404072' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '404072'
SELECT * FROM productcustomimages WHERE product_id = '404072'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404072' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '404072' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '404072' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '404072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '22900' WHERE id = '404072'
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 = '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 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:1561545558;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:8;s:6:\"408792\";i:14;s:6:\"130885\";i:16;s:6:\"408078\";i:18;s:6:\"410949\";i:23;s:6:\"404072\";}}' WHERE id = '181'
SELECT * FROM products WHERE id IN (290575,408792,130885,408078,410949,404072) ORDER BY FIELD(id, 290575,408792,130885,408078,410949,404072 )
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '290575'
SELECT * FROM productcustomimages WHERE product_id = '290575'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '549500' WHERE id = '290575'
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408792'
SELECT * FROM productcustomimages WHERE product_id = '408792'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '13499' WHERE id = '408792'
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '130885'
SELECT * FROM productcustomimages WHERE product_id = '130885'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1521' WHERE id = '130885'
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 = '410949' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '410949'
SELECT * FROM productcustomimages WHERE product_id = '410949'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '47995' WHERE id = '410949'
SELECT * FROM productimages WHERE product_id = '404072' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '404072'
SELECT * FROM productcustomimages WHERE product_id = '404072'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404072' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '404072' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '404072' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '404072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '22900' WHERE id = '404072'
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:1561545558;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:7;s:6:\"415016\";i:9;s:6:\"402983\";i:14;s:6:\"130885\";i:18;s:6:\"410949\";i:23;s:6:\"404072\";}}' WHERE id = '183'
SELECT * FROM products WHERE id IN (290575,415016,402983,130885,410949,404072) ORDER BY FIELD(id, 290575,415016,402983,130885,410949,404072 )
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '290575'
SELECT * FROM productcustomimages WHERE product_id = '290575'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '549500' WHERE id = '290575'
SELECT * FROM productimages WHERE product_id = '415016' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '415016'
SELECT * FROM productcustomimages WHERE product_id = '415016'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415016' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '415016' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '415016' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '415016' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '8899' WHERE id = '415016'
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 = '130885' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '130885'
SELECT * FROM productcustomimages WHERE product_id = '130885'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1521' WHERE id = '130885'
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '410949'
SELECT * FROM productcustomimages WHERE product_id = '410949'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '47995' WHERE id = '410949'
SELECT * FROM productimages WHERE product_id = '404072' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '404072'
SELECT * FROM productcustomimages WHERE product_id = '404072'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404072' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '404072' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '404072' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '404072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '22900' WHERE id = '404072'
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.00016403198242188	SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2	0.0004	0.00044703483581543	SHOW TABLES LIKE 'bad_bots'
3	0.0002	0.00016498565673828	SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4	0.0002	0.0001671314239502	SELECT * FROM `bad_bots`
5	0.0005	0.00046396255493164	SELECT parameter, value FROM parameters
6	0.0001	0.00014495849609375	SET time_zone = 'Europe/London'
7	0.0003	0.00030088424682617	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0002	0.00017714500427246	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0001	0.0001060962677002	delete from cachefiles
10	0.0002	0.00022983551025391	SELECT id FROM pages WHERE pagename = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm' LIMIT 1
11	0.0002	0.000244140625	SELECT id FROM products WHERE pagename = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm' AND hidden = 0 LIMIT 1
12	0.0012	0.0012099742889404	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13	0.0093	0.0093181133270264	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14	0.0002	0.00024199485778809	SELECT * FROM pages WHERE pagename = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm'
15	0.0002	0.00016188621520996	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0006	0.00056195259094238	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0005	0.00049686431884766	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.00025010108947754	SELECT id FROM categories WHERE parent_id = '49'
19	0.0005	0.0004570484161377	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (49) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
20	0.0002	0.00016689300537109	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (49) AND p.disabled = 0
21	0.0002	0.00016093254089355	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.00018310546875	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23	0.0001	0.00013494491577148	SELECT * FROM categorygroups WHERE id = '1'
24	0.0030	0.0029838085174561	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.00027298927307129	SELECT id FROM categories WHERE parent_id = '50'
26	0.0002	0.00022506713867188	SELECT id FROM categories WHERE parent_id = '96'
27	0.0002	0.00021100044250488	SELECT id FROM categories WHERE parent_id = '97'
28	0.0002	0.00020813941955566	SELECT id FROM categories WHERE parent_id = '111'
29	0.0002	0.00020813941955566	SELECT id FROM categories WHERE parent_id = '129'
30	0.0057	0.0056779384613037	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.00017690658569336	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.00016403198242188	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.00019598007202148	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34	0.0001	0.00013494491577148	SELECT * FROM categorygroups WHERE id = '1'
35	0.0023	0.0022788047790527	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.0002739429473877	SELECT id FROM categories WHERE parent_id = '80'
37	0.0023	0.0022869110107422	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.00015687942504883	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.00017189979553223	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41	0.0001	0.00013399124145508	SELECT * FROM categorygroups WHERE id = '1'
42	0.0012	0.001154899597168	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.0002598762512207	SELECT id FROM categories WHERE parent_id = '51'
44	0.0002	0.0002138614654541	SELECT id FROM categories WHERE parent_id = '101'
45	0.0018	0.0017950534820557	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.00015997886657715	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.00015687942504883	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.00017881393432617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49	0.0001	0.00014686584472656	SELECT * FROM categorygroups WHERE id = '1'
50	0.0004	0.00043296813964844	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
51	0.0023	0.002316951751709	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.00027585029602051	SELECT id FROM categories WHERE parent_id = '30'
53	0.0023	0.0022809505462646	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.00015401840209961	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.00015711784362793	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.00018095970153809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57	0.0001	0.00013518333435059	SELECT * FROM categorygroups WHERE id = '2'
58	0.0047	0.0046889781951904	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.00029397010803223	SELECT id FROM categories WHERE parent_id = '61'
60	0.0047	0.0046889781951904	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.00017285346984863	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.00015902519226074	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.00017809867858887	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64	0.0001	0.00013399124145508	SELECT * FROM categorygroups WHERE id = '2'
65	0.0007	0.00066494941711426	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10' AND hidden = 0 ORDER BY sortorder ASC
66	0.0041	0.0040609836578369	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.00027298927307129	SELECT id FROM categories WHERE parent_id = '64'
68	0.0040	0.0040478706359863	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.00016093254089355	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.00017499923706055	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.00013494491577148	SELECT * FROM categorygroups WHERE id = '10'
73	0.0080	0.0080289840698242	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.00030398368835449	SELECT id FROM categories WHERE parent_id = '65'
75	0.0081	0.0081090927124023	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.00017809867858887	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.00016307830810547	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.00018191337585449	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79	0.0001	0.00014519691467285	SELECT * FROM categorygroups WHERE id = '10'
80	0.0025	0.0025019645690918	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.00028300285339355	SELECT id FROM categories WHERE parent_id = '81'
82	0.0025	0.0025320053100586	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.00015997886657715	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.0002	0.00015687942504883	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.00013494491577148	SELECT * FROM categorygroups WHERE id = '10'
87	0.0026	0.0025761127471924	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.00029182434082031	SELECT id FROM categories WHERE parent_id = '31'
89	0.0025	0.0025420188903809	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.00016593933105469	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
91	0.0002	0.00016093254089355	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.0001838207244873	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93	0.0001	0.00014090538024902	SELECT * FROM categorygroups WHERE id = '10'
94	0.0023	0.002255916595459	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.00027799606323242	SELECT id FROM categories WHERE parent_id = '66'
96	0.0002	0.0002131462097168	SELECT id FROM categories WHERE parent_id = '131'
97	0.0028	0.0028078556060791	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.00016188621520996	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.0002	0.00018000602722168	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.00017404556274414	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101	0.0001	0.00013089179992676	SELECT * FROM categorygroups WHERE id = '10'
102	0.0093	0.0093281269073486	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.00031900405883789	SELECT id FROM categories WHERE parent_id = '34'
104	0.0002	0.0002129077911377	SELECT id FROM categories WHERE parent_id = '94'
105	0.0002	0.00020885467529297	SELECT id FROM categories WHERE parent_id = '98'
106	0.0002	0.00020694732666016	SELECT id FROM categories WHERE parent_id = '99'
107	0.0002	0.00020694732666016	SELECT id FROM categories WHERE parent_id = '110'
108	0.0002	0.00021600723266602	SELECT id FROM categories WHERE parent_id = '130'
109	0.0101	0.010071992874146	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.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
111	0.0002	0.00016903877258301	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.00019693374633789	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113	0.0001	0.00014805793762207	SELECT * FROM categorygroups WHERE id = '10'
114	0.0016	0.001572847366333	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.00027894973754883	SELECT id FROM categories WHERE parent_id = '32'
116	0.0016	0.0015780925750732	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.00014901161193848	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.0002	0.00015521049499512	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.00018692016601562	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120	0.0001	0.00013208389282227	SELECT * FROM categorygroups WHERE id = '10'
121	0.0018	0.0018491744995117	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.00026106834411621	SELECT id FROM categories WHERE parent_id = '89'
123	0.0019	0.0018608570098877	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.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 (89) AND p.disabled = 0
125	0.0002	0.00015497207641602	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.00017905235290527	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127	0.0001	0.00013089179992676	SELECT * FROM categorygroups WHERE id = '10'
128	0.0004	0.00042295455932617	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17' AND hidden = 0 ORDER BY sortorder ASC
129	0.0007	0.00069499015808105	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.00024509429931641	SELECT id FROM categories WHERE parent_id = '84'
131	0.0007	0.00069689750671387	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (84) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
132	0.0001	0.00014400482177734	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.0002	0.0001528263092041	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.00017499923706055	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135	0.0001	0.00012898445129395	SELECT * FROM categorygroups WHERE id = '17'
136	0.0007	0.00070905685424805	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.000244140625	SELECT id FROM categories WHERE parent_id = '90'
138	0.0007	0.00073790550231934	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.00014495849609375	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.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 (90) AND c.prod_type = 'ebay' AND ep.hide = 1
141	0.0002	0.00016903877258301	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.00031495094299316	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20' AND hidden = 0 ORDER BY sortorder ASC
144	0.0020	0.0020091533660889	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145	0.0003	0.00025391578674316	SELECT id FROM categories WHERE parent_id = '92'
146	0.0020	0.0020051002502441	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.00016498565673828	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.0002	0.00016117095947266	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (92) AND c.prod_type = 'ebay' AND ep.hide = 1
149	0.0002	0.00016307830810547	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150	0.0001	0.00013494491577148	SELECT * FROM categorygroups WHERE id = '20'
151	0.0054	0.0054481029510498	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152	0.0004	0.00038981437683105	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153	0.0002	0.00017094612121582	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
154	0.0002	0.00016403198242188	SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155	0.0002	0.00017786026000977	SELECT * FROM pages WHERE id = '67'
156	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '82'
157	0.0002	0.00016880035400391	SELECT * FROM pages WHERE id = '84'
158	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '94'
159	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '116'
160	0.0002	0.00021195411682129	SELECT * FROM pages WHERE id = '52'
161	0.0002	0.00016593933105469	SELECT * FROM pages WHERE id = '135'
162	0.0002	0.00017786026000977	SELECT * FROM pages WHERE id = '245'
163	0.0002	0.00017404556274414	SELECT * FROM pages WHERE id = '269'
164	0.0002	0.0001988410949707	SELECT * FROM pages WHERE id = '275'
165	0.0002	0.00018787384033203	SELECT * FROM pages WHERE id = '280'
166	0.0002	0.00019693374633789	SELECT * FROM pages WHERE id = '357'
167	0.0002	0.00017619132995605	SELECT * FROM pages WHERE id = '379'
168	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '401'
169	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '450'
170	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '454'
171	0.0002	0.00016617774963379	SELECT * FROM pages WHERE id = '457'
172	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '458'
173	0.0002	0.0001671314239502	SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '41'
175	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '43'
176	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '44'
177	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '68'
178	0.0002	0.00020599365234375	SELECT * FROM pages WHERE id = '80'
179	0.0002	0.0001988410949707	SELECT * FROM pages WHERE id = '85'
180	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '97'
181	0.0002	0.00016689300537109	SELECT * FROM pages WHERE id = '107'
182	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '108'
183	0.0002	0.0001528263092041	SELECT * FROM pages WHERE id = '128'
184	0.0002	0.00017285346984863	SELECT * FROM pages WHERE id = '133'
185	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '148'
186	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '217'
187	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '228'
188	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '257'
189	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '271'
190	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '286'
191	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '287'
192	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '291'
193	0.0002	0.00018405914306641	SELECT * FROM pages WHERE id = '380'
194	0.0002	0.00017118453979492	SELECT * FROM pages WHERE id = '344'
195	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '354'
196	0.0002	0.00019097328186035	SELECT * FROM pages WHERE id = '363'
197	0.0002	0.00019407272338867	SELECT * FROM pages WHERE id = '364'
198	0.0002	0.00016593933105469	SELECT * FROM pages WHERE id = '368'
199	0.0002	0.00018501281738281	SELECT * FROM pages WHERE id = '369'
200	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '400'
201	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '463'
202	0.0002	0.00019001960754395	SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203	0.0003	0.00031113624572754	SELECT * FROM pages WHERE id = '66'
204	0.0003	0.00027012825012207	SELECT * FROM pages WHERE id = '77'
205	0.0002	0.0001981258392334	SELECT * FROM pages WHERE id = '90'
206	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '414'
207	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '119'
208	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '406'
209	0.0002	0.00017285346984863	SELECT * FROM pages WHERE id = '149'
210	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '150'
211	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '412'
212	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '162'
213	0.0001	0.0001368522644043	SELECT * FROM pages WHERE id = '164'
214	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '167'
215	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '180'
216	0.0001	0.0001370906829834	SELECT * FROM pages WHERE id = '187'
217	0.0002	0.00018191337585449	SELECT * FROM pages WHERE id = '265'
218	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '268'
219	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '411'
220	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '290'
221	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '413'
222	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '409'
223	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '327'
224	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '336'
225	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '351'
226	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '358'
227	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '360'
228	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '362'
229	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '366'
230	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '370'
231	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '377'
232	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '386'
233	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '408'
234	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '415'
235	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '416'
236	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '419'
237	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '423'
238	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '427'
239	0.0002	0.00018191337585449	SELECT * FROM pages WHERE id = '428'
240	0.0001	0.0001370906829834	SELECT * FROM pages WHERE id = '432'
241	0.0001	0.00014019012451172	SELECT * FROM pages WHERE id = '433'
242	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '436'
243	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '437'
244	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '461'
245	0.0002	0.00017714500427246	SELECT * FROM pages WHERE id = '464'
246	0.0001	0.00014615058898926	SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '74'
248	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '137'
249	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '145'
250	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '156'
251	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '407'
252	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '410'
253	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '266'
254	0.0002	0.00018787384033203	SELECT * FROM pages WHERE id = '316'
255	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '332'
256	0.0002	0.00017213821411133	SELECT * FROM pages WHERE id = '334'
257	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '367'
258	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '387'
259	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '389'
260	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '397'
261	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '449'
262	0.0002	0.00016999244689941	SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263	0.0002	0.0001828670501709	SELECT * FROM pages WHERE id = '42'
264	0.0001	0.00014519691467285	SELECT * FROM pages WHERE id = '79'
265	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '86'
266	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '95'
267	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '102'
268	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '109'
269	0.0002	0.00019407272338867	SELECT * FROM pages WHERE id = '114'
270	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '121'
271	0.0002	0.0001828670501709	SELECT * FROM pages WHERE id = '138'
272	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '142'
273	0.0002	0.00018715858459473	SELECT * FROM pages WHERE id = '62'
274	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '157'
275	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '246'
276	0.0002	0.00017809867858887	SELECT * FROM pages WHERE id = '276'
277	0.0002	0.00017285346984863	SELECT * FROM pages WHERE id = '278'
278	0.0002	0.0001990795135498	SELECT * FROM pages WHERE id = '279'
279	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '317'
280	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '405'
281	0.0002	0.00016617774963379	SELECT * FROM pages WHERE id = '343'
282	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '345'
283	0.0002	0.00017809867858887	SELECT * FROM pages WHERE id = '346'
284	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '347'
285	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '348'
286	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '349'
287	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '381'
288	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '392'
289	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '393'
290	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '394'
291	0.0001	0.00014019012451172	SELECT * FROM pages WHERE id = '395'
292	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '399'
293	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '421'
294	0.0001	0.00013494491577148	SELECT * FROM pages WHERE id = '426'
295	0.0001	0.0001368522644043	SELECT * FROM pages WHERE id = '430'
296	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '431'
297	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '434'
298	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '435'
299	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '440'
300	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '441'
301	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '451'
302	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '453'
303	0.0001	0.00013589859008789	SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '146'
305	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '158'
306	0.0001	0.00013589859008789	SELECT * FROM pages WHERE id = '163'
307	0.0002	0.0001990795135498	SELECT * FROM pages WHERE id = '293'
308	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '340'
309	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '417'
310	0.0001	0.00013589859008789	SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '173'
312	0.0002	0.00015115737915039	SELECT * FROM pages WHERE id = '181'
313	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '288'
314	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '299'
315	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '300'
316	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '383'
317	0.0001	0.00013613700866699	SELECT * FROM pages WHERE id = '385'
318	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '438'
319	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '442'
320	0.0001	0.00014495849609375	SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321	0.0002	0.00022101402282715	SELECT * FROM pages WHERE id = '103'
322	0.0002	0.00020885467529297	SELECT * FROM pages WHERE id = '134'
323	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '139'
324	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '143'
325	0.0002	0.00017809867858887	SELECT * FROM pages WHERE id = '234'
326	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '248'
327	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '260'
328	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '398'
329	0.0001	0.00014710426330566	SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '61'
331	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '87'
332	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '104'
333	0.0002	0.00018405914306641	SELECT * FROM pages WHERE id = '115'
334	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '124'
335	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '144'
336	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '151'
337	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '199'
338	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '200'
339	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '304'
340	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '321'
341	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '333'
342	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '350'
343	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '378'
344	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '422'
345	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '425'
346	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '443'
347	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '444'
348	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '445'
349	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '446'
350	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '447'
351	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '448'
352	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '455'
353	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '456'
354	0.0001	0.00013494491577148	SELECT * FROM pages WHERE id = '459'
355	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '460'
356	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '462'
357	0.0001	0.0001370906829834	SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '153'
359	0.0002	0.00018215179443359	SELECT * FROM pages WHERE id = '182'
360	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '238'
361	0.0001	0.00013589859008789	SELECT * FROM pages WHERE id = '240'
362	0.0001	0.00013184547424316	SELECT * FROM pages WHERE id = '242'
363	0.0001	0.00013113021850586	SELECT * FROM pages WHERE id = '252'
364	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '253'
365	0.0001	0.00013613700866699	SELECT * FROM pages WHERE id = '262'
366	0.0001	0.00013184547424316	SELECT * FROM pages WHERE id = '267'
367	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '420'
368	0.0001	0.00013399124145508	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
369	0.0001	0.00011491775512695	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
370	0.0001	0.00011396408081055	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
371	0.0015	0.0014650821685791	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372	0.0002	0.0001671314239502	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
373	0.0001	0.00011897087097168	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
374	0.0001	0.00011491775512695	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
375	0.0003	0.00028586387634277	SELECT * FROM products WHERE pagename = 'bushnell-banner-dusk-dawn-mil-dot-reticle-adjustable-objective-riflescope-6-24x-40mm'
376	0.0002	0.00020384788513184	SELECT * FROM manufacturers WHERE id = '344'
377	0.0010	0.0010459423065186	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
378	0.0001	0.00012087821960449	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '344' LIMIT 1
379	0.0009	0.00093913078308105	SELECT pagename, id FROM products p WHERE manufacturer_id = '344' ORDER BY RAND() LIMIT 1
380	0.0002	0.00024199485778809	SELECT * FROM productimages WHERE product_id = '199783' ORDER BY sortorder ASC
381	0.0009	0.00091409683227539	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '344'
382	0.0010	0.00097012519836426	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '344' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
383	0.0001	0.00012111663818359	SELECT * FROM manufacturerimages WHERE manufacturer_id = '344'
384	0.0002	0.00015020370483398	SELECT category_id FROM products_categories WHERE product_id = '399477'
385	0.0002	0.0002140998840332	SELECT * FROM categories WHERE id = '34'
386	0.0095	0.009472131729126	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
387	0.0001	0.0001380443572998	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
388	0.0003	0.00029301643371582	SELECT id FROM categories WHERE parent_id = '34'
389	0.0002	0.00020098686218262	SELECT id FROM categories WHERE parent_id = '94'
390	0.0002	0.00019693374633789	SELECT id FROM categories WHERE parent_id = '98'
391	0.0002	0.00019383430480957	SELECT id FROM categories WHERE parent_id = '99'
392	0.0002	0.00020503997802734	SELECT id FROM categories WHERE parent_id = '110'
393	0.0002	0.00019383430480957	SELECT id FROM categories WHERE parent_id = '130'
394	0.0099	0.0099461078643799	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
395	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
396	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 (94,98,99,110,130,34) AND c.prod_type = 'ebay' AND ep.hide = 1
397	0.0002	0.00018215179443359	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
398	0.0001	0.00013208389282227	SELECT * FROM categories WHERE id = '120'
399	0.0001	0.00014901161193848	SELECT * FROM categories WHERE id = '130'
400	0.0007	0.00073909759521484	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 = 130
401	0.0001	0.00012683868408203	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 130
402	0.0002	0.00024700164794922	SELECT id FROM categories WHERE parent_id = '130'
403	0.0008	0.0007929801940918	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (130) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
404	0.0001	0.00013899803161621	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (130) AND p.disabled = 0
405	0.0001	0.00014114379882812	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (130) AND c.prod_type = 'ebay' AND ep.hide = 1
406	0.0001	0.00014400482177734	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
407	0.0002	0.0002439022064209	SELECT * FROM productimages WHERE product_id = '399477' ORDER BY sortorder ASC
408	0.0002	0.00021481513977051	SELECT * FROM product_image_select WHERE product_id = '399477'
409	0.0001	0.00012087821960449	SELECT * FROM productcustomimages WHERE product_id = '399477'
410	0.0001	0.00010895729064941	SELECT * FROM productfeeds WHERE product_id = '399477' ORDER BY item_date DESC
411	0.0003	0.00033688545227051	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
412	0.0003	0.00034904479980469	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '399477' AND t.hidden = 0 AND display_product = 1
413	0.0001	0.00013899803161621	SELECT * FROM tags WHERE id = '3345'
414	0.0021	0.0020718574523926	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3345' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
415	0.0020	0.0020051002502441	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3345' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
416	0.0020	0.0020461082458496	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3345' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
417	0.0003	0.00027799606323242	SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
418	0.0002	0.00016403198242188	SELECT * FROM productamazoncontent WHERE product_id = '399477'
419	0.0026	0.0026450157165527	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399477' AND a.name = n.originalname
420	0.0002	0.00019693374633789	SELECT * FROM productoffers WHERE product_id = '399477' AND merchantid = 'ATVPDKIKX0DER'
421	0.0002	0.00021004676818848	SELECT * FROM productoffers WHERE product_id = '399477' AND price > 0 ORDER BY price ASC LIMIT 1
422	0.0004	0.00039100646972656	SELECT value FROM productattributes WHERE product_id = '399477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423	0.0001	0.00013399124145508	UPDATE products SET price = '15749' WHERE id = '399477'
424	0.2387	0.23865914344788	SELECT *, MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('bushnell' IN BOOLEAN MODE) AND 399477 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
425	0.0004	0.00042080879211426	SELECT * FROM productimages WHERE product_id = '28477' ORDER BY sortorder ASC
426	0.0002	0.00022220611572266	SELECT * FROM product_image_select WHERE product_id = '28477'
427	0.0001	0.00012111663818359	SELECT * FROM productcustomimages WHERE product_id = '28477'
428	0.0029	0.0029070377349854	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28477' AND a.name = n.originalname
429	0.0002	0.00018715858459473	SELECT * FROM productoffers WHERE product_id = '28477' AND merchantid = 'ATVPDKIKX0DER'
430	0.0002	0.00022006034851074	SELECT * FROM productoffers WHERE product_id = '28477' AND price > 0 ORDER BY price ASC LIMIT 1
431	0.0004	0.00041604042053223	SELECT value FROM productattributes WHERE product_id = '28477' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
432	0.0001	0.00013589859008789	UPDATE products SET price = '47724' WHERE id = '28477'
433	0.0002	0.00021910667419434	SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
434	0.0002	0.00021600723266602	SELECT * FROM product_image_select WHERE product_id = '131163'
435	0.0001	0.00011897087097168	SELECT * FROM productcustomimages WHERE product_id = '131163'
436	0.0027	0.0026500225067139	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
437	0.0002	0.00018906593322754	SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
438	0.0002	0.00020694732666016	SELECT * FROM productoffers WHERE product_id = '131163' AND price > 0 ORDER BY price ASC LIMIT 1
439	0.0004	0.0003821849822998	SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440	0.0001	0.00013089179992676	UPDATE products SET price = '20362' WHERE id = '131163'
441	0.0002	0.00019598007202148	SELECT * FROM productimages WHERE product_id = '156919' ORDER BY sortorder ASC
442	0.0002	0.00020384788513184	SELECT * FROM product_image_select WHERE product_id = '156919'
443	0.0001	0.00011706352233887	SELECT * FROM productcustomimages WHERE product_id = '156919'
444	0.0025	0.0025489330291748	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '156919' AND a.name = n.originalname
445	0.0002	0.00018000602722168	SELECT * FROM productoffers WHERE product_id = '156919' AND merchantid = 'ATVPDKIKX0DER'
446	0.0002	0.00019288063049316	SELECT * FROM productoffers WHERE product_id = '156919' AND price > 0 ORDER BY price ASC LIMIT 1
447	0.0004	0.00038599967956543	SELECT value FROM productattributes WHERE product_id = '156919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
448	0.0001	0.00012087821960449	UPDATE products SET price = '9999' WHERE id = '156919'
449	0.0002	0.00019383430480957	SELECT * FROM productimages WHERE product_id = '131949' ORDER BY sortorder ASC
450	0.0002	0.00020599365234375	SELECT * FROM product_image_select WHERE product_id = '131949'
451	0.0001	0.00011587142944336	SELECT * FROM productcustomimages WHERE product_id = '131949'
452	0.0023	0.0023369789123535	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131949' AND a.name = n.originalname
453	0.0002	0.00018000602722168	SELECT * FROM productoffers WHERE product_id = '131949' AND merchantid = 'ATVPDKIKX0DER'
454	0.0002	0.00019502639770508	SELECT * FROM productoffers WHERE product_id = '131949' AND price > 0 ORDER BY price ASC LIMIT 1
455	0.0003	0.00033402442932129	SELECT value FROM productattributes WHERE product_id = '131949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
456	0.0001	0.00012683868408203	UPDATE products SET price = '11995' WHERE id = '131949'
457	0.0003	0.00031805038452148	SELECT * FROM productimages WHERE product_id = '136817' ORDER BY sortorder ASC
458	0.0002	0.00020790100097656	SELECT * FROM product_image_select WHERE product_id = '136817'
459	0.0001	0.00011610984802246	SELECT * FROM productcustomimages WHERE product_id = '136817'
460	0.0023	0.0022599697113037	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '136817' AND a.name = n.originalname
461	0.0002	0.00018620491027832	SELECT * FROM productoffers WHERE product_id = '136817' AND merchantid = 'ATVPDKIKX0DER'
462	0.0002	0.0001990795135498	SELECT * FROM productoffers WHERE product_id = '136817' AND price > 0 ORDER BY price ASC LIMIT 1
463	0.0004	0.00036311149597168	SELECT value FROM productattributes WHERE product_id = '136817' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
464	0.0001	0.00013995170593262	UPDATE products SET price = '19480' WHERE id = '136817'
465	0.0002	0.00024890899658203	SELECT * FROM productimages WHERE product_id = '184781' ORDER BY sortorder ASC
466	0.0002	0.00020503997802734	SELECT * FROM product_image_select WHERE product_id = '184781'
467	0.0001	0.00011515617370605	SELECT * FROM productcustomimages WHERE product_id = '184781'
468	0.0033	0.0032579898834229	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '184781' AND a.name = n.originalname
469	0.0002	0.00018501281738281	SELECT * FROM productoffers WHERE product_id = '184781' AND merchantid = 'ATVPDKIKX0DER'
470	0.0002	0.0001981258392334	SELECT * FROM productoffers WHERE product_id = '184781' AND price > 0 ORDER BY price ASC LIMIT 1
471	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '184781' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
472	0.0001	0.00013303756713867	UPDATE products SET price = '47289' WHERE id = '184781'
473	0.0001	0.00013899803161621	SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME'
474	0.0001	0.00011706352233887	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
475	0.0001	0.00011491775512695	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
476	0.0001	0.00011396408081055	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
477	0.0001	0.00011301040649414	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
478	0.0001	0.00012397766113281	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
479	0.0001	0.00013303756713867	SELECT * FROM ebay_locale_details WHERE cur_code = 'USD'
480	0.1978	0.19782185554504	SELECT * FROM ebay_products_cache WHERE cachekey = '23a703ed4d83dd23408268a5e2ffe5b7'
481	0.0003	0.0002591609954834	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
482	0.0001	0.00012302398681641	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
483	0.0001	0.00011801719665527	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
484	0.0001	0.00011587142944336	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
485	0.0001	0.00011491775512695	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
486	0.1978	0.1977698802948	SELECT * FROM ebay_products_cache WHERE cachekey = '23a703ed4d83dd23408268a5e2ffe5b7'
487	0.0003	0.00026512145996094	SELECT id,asin FROM products WHERE parent_id = 399477
488	0.0003	0.00034594535827637	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '399477' ORDER BY timestamp DESC
489	0.0002	0.00016212463378906	SELECT category_id FROM products_categories WHERE product_id = '399477'
490	0.0002	0.00024104118347168	SELECT * FROM categories WHERE id = '34'
491	0.0095	0.0094609260559082	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
492	0.0001	0.00014400482177734	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
493	0.0003	0.00028705596923828	SELECT id FROM categories WHERE parent_id = '34'
494	0.0002	0.00021600723266602	SELECT id FROM categories WHERE parent_id = '94'
495	0.0002	0.00021100044250488	SELECT id FROM categories WHERE parent_id = '98'
496	0.0002	0.00020909309387207	SELECT id FROM categories WHERE parent_id = '99'
497	0.0002	0.00021791458129883	SELECT id FROM categories WHERE parent_id = '110'
498	0.0002	0.00020790100097656	SELECT id FROM categories WHERE parent_id = '130'
499	0.0099	0.009882926940918	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
500	0.0002	0.00018811225891113	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

Bushnell Banner Dusk & Dawn Mil Dot Reticle Adjustable Objective Riflescope, 6-24X 40mm from Bushnell

Product Description

Manufacturer Description

Product Features

Write a Review

Related Products

Bushnell Elite 15-45x 60mm Roof Prism PC...

Weaver K4 4X38 Riflescope (Matte) from V...

Bushnell 119514C 6MP No-Glow Black LED S...

Bushnell Trophy XLT Multi-X Reticle Rifl...

Bushnell Trophy XLT 15-45x 50mm Waterpro...

Bushnell Elite 20-60x 80mm Porro Prism W...

Current deals from eBay

Bushnell Banner Dusk & Dawn 6-18x50 ... $ 94.99

11 Day(s) 8 h(s)

Worldwide

Weaver 613944 Bushnell Banner Dusk A... $ 81.74$ 79.37 (3% Discount)

15 Day(s) 11 h(s)

Worldwide

Nice Bushnell Banner Dusk to Dawn 3-... $ 50.00

2 Day(s) 18 h(s)

Worldwide

Bushnell Banner Dusk & Dawn 6-18x50m... $ 139.99$ 109.99 (21% Discount)

19 Day(s) 7 h(s)

Worldwide

Bushnell Banner Scope 3-9X40 Matte D... $ 85.77

29 Day(s) 19 h(s)

Worldwide

Bushnell Banner Dusk To Dawn, Rifle ... $ 49.99

6 Day(s) 6 h(s)

Worldwide

Bushnell Banner Dusk & Dawn Riflesco... $ 69.00

27 Day(s) 7 h(s)

Worldwide

Bushnell Banner Dusk & Dawn Multi-X ... $ 89.89

13 Day(s) 7 h(s)

Worldwide

Bushnell Banner Dusk & Dawn 6-18x50m... $ 129.99

22 Day(s) 7 h(s)

Worldwide

Bushnell Banner 3-9x 40mm Multi-X Re... $ 35.00

6 Day(s) 11 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.7191669940948 seconds

Query Debug - 763 Database Queries. Total time 1.2681 seconds