0 items

Sightmark Core Shot from Sellmark Corporation

Price: $79.69

As of 2019-06-17 01:42:44 UTC (more info)

Product prices and availability are accurate as of 2019-06-17 01:42:44 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.

Availability: Not Available - stock arriving soon

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 happy to stock the brilliant Sightmark Core Shot today at this great price.

With so many competing tactical, combat and survival products available recently, it is wise to have a make that you can trust. The Sightmark Core Shot is certainly all that and will be a superb acquisition for your combat gear or tactical ability.

We pride ourselves on providing the highest quality combat gear for all your on the job requirements.

For this special price, the Sightmark Core Shot is greatly recommended and is always a regular choice amongst most like minded people. Sellmark Corporation have passed on some excellent touches and this means good value for money.

Manufacturer Description

Including an advanced optical system with dual-pane glass and a wider unbiased lens, Sightmark is pleased to present the core shot Pro spec - an improved variation of the initial core shot Reflex sight. Bridging the space between full-size Reflex sights such as the ultra shot and compact handgun Reflex sights such as the Mini shot, the mid-sized core shot Pro spec is the perfect Red dot sight for ars, shotguns, hunting rifles and competitors pistols with an optics install. Its huge unbiased lens delivers a wider field of view, making it simpler to get the reticle and view with both eyes open. The sight consists of windage and elevation click adjustments to dial in quickly and an external battery compartment for simpler access to the battery. Equipped with six day and nighttime brightness settings, low power consumption and a battery life as much as 1,400 hours, the core shot Pro spec is developed for long-lasting operation shot after shot.

Product Features

Click adjustable windage/Elevation Wide field of view Reliable and durable Digital switch controls 6 reticle brightness settings Weaver/Picatinny Mount Digital Switch 3 MOA Red Dot 5 Reticle Brightness Settings

User Reviews
Amazon Product Reviews

Write a Review

See more Sightmark Core Shot from Sellmark Corporation on eBay

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
3.8671188354492	778	1.8942	0

No Amazon API Requests Made.

App Debug - Total Time 3.8671188354492 seconds

Number	Time From Start	Name	Description
1	0.42926096916199	Initialise	Initialise FSB Function
2	0.43140983581543	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.44263696670532	Start of getCategoryListByGroup Function	Before first category groups query
4	0.44280385971069	After initial query	Before first category groups query
5	0.44280481338501	Get Category List for Group	Before the call to getCategoryList function
6	0.44280791282654	Start of GetCategoryList function	Start of the function
7	0.44281196594238	Before getting categories	Query to get specific category list
8	0.44336080551147	After getting categories	Query to get specific category list
9	0.44336199760437	Before getting category custom	Before call to function getCategoryCustom
10	0.44516897201538	After getting category custom	After call to function getCategoryCustom
11	0.44517087936401	Before getting category custom	Before call to function getCategoryCustom
12	0.45573496818542	After getting category custom	After call to function getCategoryCustom
13	0.45573687553406	Before getting category custom	Before call to function getCategoryCustom
14	0.46123290061951	After getting category custom	After call to function getCategoryCustom
15	0.46123600006104	Before getting category custom	Before call to function getCategoryCustom
16	0.46528100967407	After getting category custom	After call to function getCategoryCustom
17	0.46528387069702	End of GetCategoryList function	End of the function
18	0.46529197692871	Get Category List for Group	Before the call to getCategoryList function
19	0.46529388427734	Start of GetCategoryList function	Start of the function
20	0.46529698371887	Before getting categories	Query to get specific category list
21	0.46572184562683	After getting categories	Query to get specific category list
22	0.46572279930115	Before getting category custom	Before call to function getCategoryCustom
23	0.47119092941284	After getting category custom	After call to function getCategoryCustom
24	0.47119283676147	Before getting category custom	Before call to function getCategoryCustom
25	0.48170495033264	After getting category custom	After call to function getCategoryCustom
26	0.48170685768127	End of GetCategoryList function	End of the function
27	0.48171281814575	Get Category List for Group	Before the call to getCategoryList function
28	0.48171591758728	Start of GetCategoryList function	Start of the function
29	0.48171782493591	Before getting categories	Query to get specific category list
30	0.48240399360657	After getting categories	Query to get specific category list
31	0.4824059009552	Before getting category custom	Before call to function getCategoryCustom
32	0.49150490760803	After getting category custom	After call to function getCategoryCustom
33	0.49150800704956	Before getting category custom	Before call to function getCategoryCustom
34	0.50928497314453	After getting category custom	After call to function getCategoryCustom
35	0.50928997993469	Before getting category custom	Before call to function getCategoryCustom
36	0.51538801193237	After getting category custom	After call to function getCategoryCustom
37	0.51539182662964	Before getting category custom	Before call to function getCategoryCustom
38	0.52137589454651	After getting category custom	After call to function getCategoryCustom
39	0.52137899398804	Before getting category custom	Before call to function getCategoryCustom
40	0.52771496772766	After getting category custom	After call to function getCategoryCustom
41	0.52771782875061	Before getting category custom	Before call to function getCategoryCustom
42	0.55050992965698	After getting category custom	After call to function getCategoryCustom
43	0.55051493644714	Before getting category custom	Before call to function getCategoryCustom
44	0.55491900444031	After getting category custom	After call to function getCategoryCustom
45	0.55492281913757	Before getting category custom	Before call to function getCategoryCustom
46	0.55962491035461	After getting category custom	After call to function getCategoryCustom
47	0.55962800979614	End of GetCategoryList function	End of the function
48	0.55964303016663	Get Category List for Group	Before the call to getCategoryList function
49	0.55964493751526	Start of GetCategoryList function	Start of the function
50	0.5596489906311	Before getting categories	Query to get specific category list
51	0.56007289886475	After getting categories	Query to get specific category list
52	0.56007480621338	Before getting category custom	Before call to function getCategoryCustom
53	0.56237483024597	After getting category custom	After call to function getCategoryCustom
54	0.5623779296875	Before getting category custom	Before call to function getCategoryCustom
55	0.56474590301514	After getting category custom	After call to function getCategoryCustom
56	0.56474781036377	End of GetCategoryList function	End of the function
57	0.56475591659546	Get Category List for Group	Before the call to getCategoryList function
58	0.56475782394409	Start of GetCategoryList function	Start of the function
59	0.56476187705994	Before getting categories	Query to get specific category list
60	0.5650749206543	After getting categories	Query to get specific category list
61	0.56507587432861	Before getting category custom	Before call to function getCategoryCustom
62	0.57016396522522	After getting category custom	After call to function getCategoryCustom
63	0.57016682624817	End of GetCategoryList function	End of the function
64	0.57017493247986	End of getCategoryListByGroup Function	Before return()
65	0.62255692481995	App Controller End	End of the App controller (called before the controller of every page)
66	0.62322282791138	Product Start	Start of the product info controller
67	0.62408685684204	Cache file not found	Starting get product details
68	0.64964485168457	Related products	Start getting related products if enabled
69	0.64964699745178	Related Products Start	Before the related products are found
70	0.6496479511261	Related Products Keywords	Before the related product keywords are found
71	0.64965987205505	Create Keyword List Function	Start of function
72	0.65107297897339	Create Keyword List Function	After looping provided content - 967 keywords found
73	0.71537089347839	Create Keyword List Function	After looping initial keyword list - 896 keywords remaining
74	0.71561288833618	Create Keyword List Function	After reducing keyword list
75	0.71666502952576	Create Keyword List Function	After selecting by scoring keywords
76	0.71667098999023	Create Keyword List Function	After final loop of keywords
77	0.71667385101318	Related Products Keywords	After the related product keywords are found
78	0.98247098922729	Related Products End	After the related products are found
79	1.1755800247192	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
80	1.4382050037384	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
81	1.6310579776764	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
82	1.8507997989655	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
83	2.0607759952545	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
84	2.3236658573151	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
85	2.5179369449615	Start Remote Request	http://svcs.ebay.com/services/search/FindingServic...
86	2.7606048583984	End Remote Request	http://svcs.ebay.com/services/search/FindingServic...
87	2.9812049865723	Product End	End of the product info controller (Product Info)
88	2.9815928936005	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
89	2.9816749095917	Before Get Options	Before the call to getOptions in the tpl class
90	3.4057338237762	After Get Options	After the call to getOptions in the tpl class
91	3.406035900116	App_after Controller End	End of the App_after controller (called after the controller of every page)
92	3.4060509204865	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
93	3.6591567993164	Product Info: After Smarty Fetch	After the product.tpl template is fetched
94	3.6591639518738	Product Info: Before Template Display	Before the template is displayed
95	3.8670949935913	Product Info: After Template Display	After the template is displayed
96	3.8671009540558	Finalizing debug	Before the debug is output to the page.
97	3.8671169281006	End of App	This is the end of the app logging, final timestamp

Query Debug - 778 Database Queries. Total time 1.8942 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 = 'sightmark-core-shot' LIMIT 1
SELECT id FROM products WHERE pagename = 'sightmark-core-shot' 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 = 'sightmark-core-shot'
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 = 'sightmark-core-shot'
SELECT * FROM manufacturers WHERE id = '348'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '348' LIMIT 1
SELECT pagename, id FROM products p WHERE manufacturer_id = '348' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '413358' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '348'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '348'
SELECT category_id FROM products_categories WHERE product_id = '331198'
SELECT * FROM categories WHERE id = '64'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 productimages WHERE product_id = '331198' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '331198'
SELECT * FROM productcustomimages WHERE product_id = '331198'
SELECT * FROM productfeeds WHERE product_id = '331198' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '331198' 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 = '331198' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '4189'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '4189'
				  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 = '4189'
				  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 = '4189' 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 = '371594' ORDER BY sortorder ASC
SELECT * FROM tags WHERE id = '3385'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3385'
				  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 = '3385'
				  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 = '3385' 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 = '412716' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '331198'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '331198' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '331198' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '331198' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 331198
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '331198'
                AND name = 'ListPriceAmount'
UPDATE products SET price = '7969' WHERE id = '331198'
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('shot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('shot' IN BOOLEAN MODE) AND 331198 <> 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 = '115381' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '115381'
SELECT * FROM productcustomimages WHERE product_id = '115381'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '115381' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '115381' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '115381' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '115381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '12999' WHERE id = '115381'
SELECT * FROM productimages WHERE product_id = '54123' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '54123' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '54123'
SELECT * FROM productcustomimages WHERE product_id = '54123'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '54123'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '54123'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 54123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '54123' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '54123' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '54123' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 54123
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '54123'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '54123'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '54123'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 54123
SELECT value FROM productattributes WHERE product_id = '54123' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '8062' WHERE id = '54123'
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '54123'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '138270' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '138270'
SELECT * FROM productcustomimages WHERE product_id = '138270'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '138270' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '138270' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '138270' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '138270' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '94999' WHERE id = '138270'
SELECT * FROM productimages WHERE product_id = '272785' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '272785'
SELECT * FROM productcustomimages WHERE product_id = '272785'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '272785' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '272785' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '272785' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '272785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2645' WHERE id = '272785'
SELECT * FROM productimages WHERE product_id = '268101' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '268101'
SELECT * FROM productcustomimages WHERE product_id = '268101'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268101' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '268101' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '268101' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '268101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '4323' WHERE id = '268101'
SELECT * FROM productimages WHERE product_id = '406398' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406398'
SELECT * FROM productcustomimages WHERE product_id = '406398'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406398' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406398' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406398' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406398' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1699' WHERE id = '406398'
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 = '010ed9f83e28ae2b465d58d54ca65166' 
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 = '010ed9f83e28ae2b465d58d54ca65166' 
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 = '010ed9f83e28ae2b465d58d54ca65166' 
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 = '010ed9f83e28ae2b465d58d54ca65166' 
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 = '010ed9f83e28ae2b465d58d54ca65166' 
SELECT id FROM ebay_products WHERE itemid = '273584376615' 
SELECT id FROM ebay_products WHERE itemid = '183821278729' 
SELECT id FROM ebay_products WHERE itemid = '273571373194' 
SELECT id FROM ebay_products WHERE itemid = '123784522625' 
SELECT id FROM ebay_products WHERE itemid = '312161232274' 
SELECT id FROM ebay_products WHERE itemid = '264326872779' 
SELECT id FROM ebay_products WHERE itemid = '233201127246' 
SELECT id FROM ebay_products WHERE itemid = '143292482114' 
SELECT id FROM ebay_products WHERE itemid = '382999891666' 
SELECT id FROM ebay_products WHERE itemid = '382999885399' 
UPDATE ebay_products_cache SET products = 'a:11:{i:0;a:14:{s:6:\"itemId\";s:12:\"273584376615\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=273584376615\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mReetXsDLvBYn4ohFN_HfHg/140.jpg\";s:5:\"title\";s:53:\"Sight Mark Core Shot A- Spec FMS Reflex Sight SM26017\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P9DT13H6M45S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"129.97\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:1;a:14:{s:6:\"itemId\";s:12:\"183821278729\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=183821278729\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/mRUnyVebC-L5DnD-tjW6q_A/140.jpg\";s:5:\"title\";s:49:\"Sightmark Core Shot Pro Spec Reflex Sight SM26001\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P4DT14H39M19S\";s:15:\"returnsAccepted\";s:5:\"false\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"99.97\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"0\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:2;a:14:{s:6:\"itemId\";s:12:\"273571373194\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=273571373194\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/m0s3bVFmP-ekSQU5Szl7OKA/140.jpg\";s:5:\"title\";s:36:\"SightMark Core Shot Pro Spec SM26001\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P1DT19H21M46S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"99.97\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:3;a:14:{s:6:\"itemId\";s:12:\"123784522625\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=123784522625\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/mgn1tEz0D_7c6FC3xKUgNzA/140.jpg\";s:5:\"title\";s:35:\"Sightmark  Core Shot A-Spec SM26017\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P10DT11H14M56S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"155.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"2\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:4;a:14:{s:6:\"itemId\";s:12:\"312161232274\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=312161232274\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mvfdkh1lGvniQtrhTsHNWvQ/140.jpg\";s:5:\"title\";s:54:\"Sightmark Core Shot Red Dot Sight, Dot Reticle SM26001\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P22DT2H45M38S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"101.90\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"3\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:5;a:14:{s:6:\"itemId\";s:12:\"264326872779\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=264326872779\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mQ5qCBGGu32N5Y4tl6Us1wA/140.jpg\";s:5:\"title\";s:27:\"SIGHTMARK Core Shot SM26001\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P29DT18H59M47S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"155.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:6;a:14:{s:6:\"itemId\";s:12:\"233201127246\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=233201127246\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mAAnwHeyjdoquMPUqWfxd3Q/140.jpg\";s:5:\"title\";s:77:\"Sightmark 1x28x29 Core Shot Pro Spec Reflex Sight w/5 moa Dot Reticle SM26001\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P29DT8H50M4S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"129.97\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"3\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:7;a:14:{s:6:\"itemId\";s:12:\"143292482114\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=143292482114\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mhMFWSF-GnLry0mc-Qr91bw/140.jpg\";s:5:\"title\";s:27:\"SIGHTMARK Core Shot SM26001\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P25DT14H4M38S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"155.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"2\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:8;a:14:{s:6:\"itemId\";s:12:\"382999891666\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=382999891666\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mKDTr9bwAvvJV0Lvmxx_HYQ/140.jpg\";s:5:\"title\";s:80:\"Sightmark SM26017 Core Shot A-Spec FMS Red Dot Tactical Holographic/Reflex Sight\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P23DT12H4M6S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";s:6:\"199.11\";s:12:\"currentPrice\";s:6:\"151.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:9;a:14:{s:6:\"itemId\";s:12:\"382999885399\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=382999885399\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mJICdRhKVt5B99HxtNyr_ZQ/140.jpg\";s:5:\"title\";s:40:\"Sightmark SM26001 Core Shot Reflex Sight\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P23DT11H55M33S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";s:6:\"170.26\";s:12:\"currentPrice\";s:6:\"129.97\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"2\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:10;s:205:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=4&toolid=10041&campid=5338345274&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.com%2Fsch%2Fi.html%3F_nkw%3DSightmark%2BCore%2BShot%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1560755185' WHERE id = '64282'
SELECT id,asin FROM products WHERE parent_id = 331198
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '331198' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '331198'
SELECT * FROM categories WHERE id = '64'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '331198' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '331198' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '331198' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 331198
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '331198'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '331198'
UPDATE products SET price = '7969' WHERE id = '331198'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '331198' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '331198' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '331198' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 331198
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '331198'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '331198'
SELECT parent_id FROM categories WHERE id = '64'
SELECT * FROM categories WHERE id = '64'
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 COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE 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 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:1560755187;s:8:\"products\";a:6:{i:1;s:6:\"407595\";i:5;s:6:\"412927\";i:9;s:6:\"103845\";i:14;s:6:\"414188\";i:18;s:6:\"127345\";i:20;s:6:\"410949\";}}' WHERE id = '175'
SELECT * FROM products WHERE id IN (407595,412927,103845,414188,127345,410949) ORDER BY FIELD(id, 407595,412927,103845,414188,127345,410949 )
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407595'
SELECT * FROM productcustomimages WHERE product_id = '407595'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2497' WHERE id = '407595'
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '412927'
SELECT * FROM productcustomimages WHERE product_id = '412927'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '199900' WHERE id = '412927'
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '103845'
SELECT * FROM productcustomimages WHERE product_id = '103845'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '11900' WHERE id = '103845'
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414188'
SELECT * FROM productcustomimages WHERE product_id = '414188'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414188'
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '127345'
SELECT * FROM productcustomimages WHERE product_id = '127345'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '21963' WHERE id = '127345'
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 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:1560755187;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:3;s:6:\"171938\";i:11;s:6:\"403517\";i:13;s:6:\"407831\";i:15;s:6:\"406758\";i:20;s:6:\"410949\";}}' WHERE id = '177'
SELECT * FROM products WHERE id IN (290575,171938,403517,407831,406758,410949) ORDER BY FIELD(id, 290575,171938,403517,407831,406758,410949 )
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 = '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 = '389500' WHERE id = '171938'
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '403517'
SELECT * FROM productcustomimages WHERE product_id = '403517'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '6699' WHERE id = '403517'
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407831'
SELECT * FROM productcustomimages WHERE product_id = '407831'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1293' WHERE id = '407831'
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406758'
SELECT * FROM productcustomimages WHERE product_id = '406758'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2694' WHERE id = '406758'
SELECT * FROM productimages WHERE product_id = '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 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:1560755187;s:8:\"products\";a:6:{i:10;s:6:\"370121\";i:13;s:6:\"407831\";i:20;s:6:\"410949\";i:21;s:6:\"408079\";i:23;s:6:\"400044\";i:1;s:6:\"407595\";}}' WHERE id = '181'
SELECT * FROM products WHERE id IN (370121,407831,410949,408079,400044,407595) ORDER BY FIELD(id, 370121,407831,410949,408079,400044,407595 )
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '370121'
SELECT * FROM productcustomimages WHERE product_id = '370121'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9899' WHERE id = '370121'
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407831'
SELECT * FROM productcustomimages WHERE product_id = '407831'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1293' WHERE id = '407831'
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 = '408079' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '408079'
SELECT * FROM productcustomimages WHERE product_id = '408079'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '20106' WHERE id = '408079'
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '400044'
SELECT * FROM productcustomimages WHERE product_id = '400044'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '16091' WHERE id = '400044'
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407595'
SELECT * FROM productcustomimages WHERE product_id = '407595'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2497' WHERE id = '407595'
SELECT 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:1560755187;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:7;s:6:\"183732\";i:8;s:6:\"408792\";i:13;s:6:\"407831\";i:14;s:6:\"414188\";i:15;s:6:\"406758\";}}' WHERE id = '183'
SELECT * FROM products WHERE id IN (290575,183732,408792,407831,414188,406758) ORDER BY FIELD(id, 290575,183732,408792,407831,414188,406758 )
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 = '183732' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '183732'
SELECT * FROM productcustomimages WHERE product_id = '183732'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '38249' WHERE id = '183732'
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 = '407831' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '407831'
SELECT * FROM productcustomimages WHERE product_id = '407831'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '1293' WHERE id = '407831'
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '414188'
SELECT * FROM productcustomimages WHERE product_id = '414188'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '9999' WHERE id = '414188'
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '406758'
SELECT * FROM productcustomimages WHERE product_id = '406758'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
UPDATE products SET price = '2694' WHERE id = '406758'
SELECT * FROM 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.00016593933105469	SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2	0.0005	0.00054502487182617	SHOW TABLES LIKE 'bad_bots'
3	0.0002	0.00018692016601562	SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4	0.0001	0.00014090538024902	SELECT * FROM `bad_bots`
5	0.0006	0.00055408477783203	SELECT parameter, value FROM parameters
6	0.0002	0.00017786026000977	SET time_zone = 'Europe/London'
7	0.0003	0.00028109550476074	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0001	0.00014400482177734	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0001	0.00011587142944336	delete from cachefiles
10	0.0002	0.00022602081298828	SELECT id FROM pages WHERE pagename = 'sightmark-core-shot' LIMIT 1
11	0.0002	0.00022292137145996	SELECT id FROM products WHERE pagename = 'sightmark-core-shot' AND hidden = 0 LIMIT 1
12	0.0008	0.00076889991760254	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13	0.0094	0.0094330310821533	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14	0.0003	0.00025296211242676	SELECT * FROM pages WHERE pagename = 'sightmark-core-shot'
15	0.0002	0.00015115737915039	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0005	0.00050997734069824	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0005	0.00046992301940918	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18	0.0002	0.00022196769714355	SELECT id FROM categories WHERE parent_id = '49'
19	0.0004	0.0004420280456543	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (49) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
20	0.0001	0.00014090538024902	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (49) AND p.disabled = 0
21	0.0001	0.00014710426330566	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.00016903877258301	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '1'
24	0.0030	0.002997875213623	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.00027108192443848	SELECT id FROM categories WHERE parent_id = '50'
26	0.0002	0.00020408630371094	SELECT id FROM categories WHERE parent_id = '96'
27	0.0002	0.0001978874206543	SELECT id FROM categories WHERE parent_id = '97'
28	0.0002	0.00019693374633789	SELECT id FROM categories WHERE parent_id = '111'
29	0.0002	0.0001978874206543	SELECT id FROM categories WHERE parent_id = '129'
30	0.0057	0.0057289600372314	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.00016999244689941	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (96,97,111,129,50) AND p.disabled = 0
32	0.0002	0.00015401840209961	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (96,97,111,129,50) AND c.prod_type = 'ebay' AND ep.hide = 1
33	0.0002	0.0001828670501709	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34	0.0001	0.00012588500976562	SELECT * FROM categorygroups WHERE id = '1'
35	0.0023	0.0022778511047363	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.00025582313537598	SELECT id FROM categories WHERE parent_id = '80'
37	0.0023	0.0022969245910645	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (80) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
38	0.0001	0.00014901161193848	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (80) AND p.disabled = 0
39	0.0001	0.00014615058898926	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.00015711784362793	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '1'
42	0.0011	0.0011341571807861	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.00025391578674316	SELECT id FROM categories WHERE parent_id = '51'
44	0.0002	0.00020313262939453	SELECT id FROM categories WHERE parent_id = '101'
45	0.0018	0.0017609596252441	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.0001521110534668	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (101,51) AND p.disabled = 0
47	0.0001	0.00014781951904297	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.00016593933105469	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '1'
50	0.0004	0.00040102005004883	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
51	0.0023	0.0022649765014648	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.0002	0.00024580955505371	SELECT id FROM categories WHERE parent_id = '30'
53	0.0023	0.0022819042205811	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.0001	0.00014781951904297	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
55	0.0001	0.00014615058898926	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.00016689300537109	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57	0.0001	0.00012302398681641	SELECT * FROM categorygroups WHERE id = '2'
58	0.0048	0.0047590732574463	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.00026202201843262	SELECT id FROM categories WHERE parent_id = '61'
60	0.0048	0.0047900676727295	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.00015878677368164	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (61) AND p.disabled = 0
62	0.0001	0.00014901161193848	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.00017404556274414	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64	0.0001	0.00012516975402832	SELECT * FROM categorygroups WHERE id = '2'
65	0.0006	0.00062394142150879	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10' AND hidden = 0 ORDER BY sortorder ASC
66	0.0040	0.0040249824523926	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.00026082992553711	SELECT id FROM categories WHERE parent_id = '64'
68	0.0041	0.0040719509124756	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.00016212463378906	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (64) AND p.disabled = 0
70	0.0001	0.00014996528625488	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.00016903877258301	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72	0.0001	0.00013899803161621	SELECT * FROM categorygroups WHERE id = '10'
73	0.0082	0.0082488059997559	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.00033116340637207	SELECT id FROM categories WHERE parent_id = '65'
75	0.0084	0.0083801746368408	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.00019502639770508	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.00015878677368164	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.00018405914306641	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79	0.0001	0.00013303756713867	SELECT * FROM categorygroups WHERE id = '10'
80	0.0025	0.0024900436401367	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.00032901763916016	SELECT id FROM categories WHERE parent_id = '81'
82	0.0025	0.0025458335876465	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.00015616416931152	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (81) AND p.disabled = 0
84	0.0001	0.00014996528625488	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.00016307830810547	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86	0.0001	0.00012898445129395	SELECT * FROM categorygroups WHERE id = '10'
87	0.0025	0.0024831295013428	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.00027990341186523	SELECT id FROM categories WHERE parent_id = '31'
89	0.0025	0.002514123916626	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.00015616416931152	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.0001521110534668	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'ebay' AND ep.hide = 1
92	0.0002	0.0001680850982666	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93	0.0001	0.00012683868408203	SELECT * FROM categorygroups WHERE id = '10'
94	0.0023	0.0022702217102051	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.00020694732666016	SELECT id FROM categories WHERE parent_id = '131'
97	0.0029	0.0028500556945801	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.00016093254089355	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.00015401840209961	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.00017499923706055	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101	0.0001	0.00012898445129395	SELECT * FROM categorygroups WHERE id = '10'
102	0.0098	0.0098109245300293	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.0004	0.0003659725189209	SELECT id FROM categories WHERE parent_id = '34'
104	0.0002	0.00020694732666016	SELECT id FROM categories WHERE parent_id = '94'
105	0.0002	0.00020408630371094	SELECT id FROM categories WHERE parent_id = '98'
106	0.0002	0.00021195411682129	SELECT id FROM categories WHERE parent_id = '99'
107	0.0002	0.00020194053649902	SELECT id FROM categories WHERE parent_id = '110'
108	0.0002	0.00020003318786621	SELECT id FROM categories WHERE parent_id = '130'
109	0.0106	0.010619878768921	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.00024509429931641	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.00016689300537109	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.00020599365234375	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113	0.0001	0.00014710426330566	SELECT * FROM categorygroups WHERE id = '10'
114	0.0016	0.0016379356384277	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.00028800964355469	SELECT id FROM categories WHERE parent_id = '32'
116	0.0018	0.0017509460449219	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (32) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
117	0.0002	0.00016307830810547	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.0001680850982666	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120	0.0001	0.00012993812561035	SELECT * FROM categorygroups WHERE id = '10'
121	0.0019	0.0018630027770996	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.00027084350585938	SELECT id FROM categories WHERE parent_id = '89'
123	0.0019	0.0018680095672607	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.00015115737915039	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (89) AND p.disabled = 0
125	0.0001	0.00014686584472656	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.00017595291137695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127	0.0001	0.00012803077697754	SELECT * FROM categorygroups WHERE id = '10'
128	0.0004	0.00039911270141602	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17' AND hidden = 0 ORDER BY sortorder ASC
129	0.0007	0.0006871223449707	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.00023484230041504	SELECT id FROM categories WHERE parent_id = '84'
131	0.0007	0.00069808959960938	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.00014591217041016	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (84) AND p.disabled = 0
133	0.0001	0.00014591217041016	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.0001678466796875	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135	0.0001	0.00012397766113281	SELECT * FROM categorygroups WHERE id = '17'
136	0.0007	0.00071477890014648	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.00023603439331055	SELECT id FROM categories WHERE parent_id = '90'
138	0.0007	0.00074291229248047	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.00014591217041016	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (90) AND p.disabled = 0
140	0.0001	0.00014519691467285	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id IN (90) AND c.prod_type = 'ebay' AND ep.hide = 1
141	0.0002	0.00016593933105469	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142	0.0001	0.00012516975402832	SELECT * FROM categorygroups WHERE id = '17'
143	0.0003	0.00029897689819336	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20' AND hidden = 0 ORDER BY sortorder ASC
144	0.0020	0.0020489692687988	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145	0.0002	0.00024700164794922	SELECT id FROM categories WHERE parent_id = '92'
146	0.0021	0.0021138191223145	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.0001530647277832	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (92) AND p.disabled = 0
148	0.0001	0.00014996528625488	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.0001530647277832	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150	0.0001	0.00012588500976562	SELECT * FROM categorygroups WHERE id = '20'
151	0.0052	0.0052399635314941	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152	0.0004	0.00042319297790527	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153	0.0003	0.00026392936706543	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
154	0.0002	0.00016903877258301	SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '67'
156	0.0002	0.00015878677368164	SELECT * FROM pages WHERE id = '82'
157	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '84'
158	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '94'
159	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '116'
160	0.0002	0.0002131462097168	SELECT * FROM pages WHERE id = '52'
161	0.0002	0.00016021728515625	SELECT * FROM pages WHERE id = '135'
162	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '245'
163	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '269'
164	0.0002	0.00018787384033203	SELECT * FROM pages WHERE id = '275'
165	0.0003	0.00034904479980469	SELECT * FROM pages WHERE id = '280'
166	0.0002	0.0001978874206543	SELECT * FROM pages WHERE id = '357'
167	0.0002	0.00015020370483398	SELECT * FROM pages WHERE id = '379'
168	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '401'
169	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '450'
170	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '454'
171	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '457'
172	0.0002	0.00015091896057129	SELECT * FROM pages WHERE id = '458'
173	0.0002	0.0001528263092041	SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174	0.0002	0.00016117095947266	SELECT * FROM pages WHERE id = '41'
175	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '43'
176	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '44'
177	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '68'
178	0.0002	0.00019693374633789	SELECT * FROM pages WHERE id = '80'
179	0.0002	0.00016188621520996	SELECT * FROM pages WHERE id = '85'
180	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '97'
181	0.0002	0.00016617774963379	SELECT * FROM pages WHERE id = '107'
182	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '108'
183	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '128'
184	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '133'
185	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '148'
186	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '217'
187	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '228'
188	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '257'
189	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '271'
190	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '286'
191	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '287'
192	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '291'
193	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '380'
194	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '344'
195	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '354'
196	0.0002	0.00018000602722168	SELECT * FROM pages WHERE id = '363'
197	0.0002	0.00018119812011719	SELECT * FROM pages WHERE id = '364'
198	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '368'
199	0.0002	0.00017595291137695	SELECT * FROM pages WHERE id = '369'
200	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '400'
201	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '463'
202	0.0002	0.00016593933105469	SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203	0.0002	0.00024700164794922	SELECT * FROM pages WHERE id = '66'
204	0.0002	0.00019192695617676	SELECT * FROM pages WHERE id = '77'
205	0.0002	0.00018596649169922	SELECT * FROM pages WHERE id = '90'
206	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '414'
207	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '119'
208	0.0002	0.00016999244689941	SELECT * FROM pages WHERE id = '406'
209	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '149'
210	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '150'
211	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '412'
212	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '162'
213	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '164'
214	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '167'
215	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '180'
216	0.0001	0.00014019012451172	SELECT * FROM pages WHERE id = '187'
217	0.0002	0.00018787384033203	SELECT * FROM pages WHERE id = '265'
218	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '268'
219	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '411'
220	0.0002	0.0001528263092041	SELECT * FROM pages WHERE id = '290'
221	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '413'
222	0.0001	0.00014281272888184	SELECT * FROM pages WHERE id = '409'
223	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '327'
224	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '336'
225	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '351'
226	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '358'
227	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '360'
228	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '362'
229	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '366'
230	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '370'
231	0.0002	0.00015592575073242	SELECT * FROM pages WHERE id = '377'
232	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '386'
233	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '408'
234	0.0001	0.00014209747314453	SELECT * FROM pages WHERE id = '415'
235	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '416'
236	0.0002	0.00018095970153809	SELECT * FROM pages WHERE id = '419'
237	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '423'
238	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '427'
239	0.0002	0.00017786026000977	SELECT * FROM pages WHERE id = '428'
240	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '432'
241	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '433'
242	0.0002	0.00015377998352051	SELECT * FROM pages WHERE id = '436'
243	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '437'
244	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '461'
245	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '464'
246	0.0001	0.00014710426330566	SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '74'
248	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '137'
249	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '145'
250	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '156'
251	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '407'
252	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '410'
253	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '266'
254	0.0002	0.00020408630371094	SELECT * FROM pages WHERE id = '316'
255	0.0002	0.0001518726348877	SELECT * FROM pages WHERE id = '332'
256	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '334'
257	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '367'
258	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '387'
259	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '389'
260	0.0002	0.00015902519226074	SELECT * FROM pages WHERE id = '397'
261	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '449'
262	0.0002	0.00016307830810547	SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263	0.0002	0.00018501281738281	SELECT * FROM pages WHERE id = '42'
264	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '79'
265	0.0002	0.0001680850982666	SELECT * FROM pages WHERE id = '86'
266	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '95'
267	0.0002	0.0001521110534668	SELECT * FROM pages WHERE id = '102'
268	0.0001	0.00014519691467285	SELECT * FROM pages WHERE id = '109'
269	0.0002	0.00020194053649902	SELECT * FROM pages WHERE id = '114'
270	0.0002	0.00019001960754395	SELECT * FROM pages WHERE id = '121'
271	0.0002	0.00019097328186035	SELECT * FROM pages WHERE id = '138'
272	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '142'
273	0.0002	0.00018501281738281	SELECT * FROM pages WHERE id = '62'
274	0.0001	0.00014376640319824	SELECT * FROM pages WHERE id = '157'
275	0.0002	0.00016403198242188	SELECT * FROM pages WHERE id = '246'
276	0.0002	0.00018596649169922	SELECT * FROM pages WHERE id = '276'
277	0.0002	0.00017905235290527	SELECT * FROM pages WHERE id = '278'
278	0.0002	0.00020098686218262	SELECT * FROM pages WHERE id = '279'
279	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '317'
280	0.0002	0.00019001960754395	SELECT * FROM pages WHERE id = '405'
281	0.0002	0.00017905235290527	SELECT * FROM pages WHERE id = '343'
282	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '345'
283	0.0002	0.00018715858459473	SELECT * FROM pages WHERE id = '346'
284	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '347'
285	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '348'
286	0.0002	0.00015377998352051	SELECT * FROM pages WHERE id = '349'
287	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '381'
288	0.0001	0.00014996528625488	SELECT * FROM pages WHERE id = '392'
289	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '393'
290	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '394'
291	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '395'
292	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '399'
293	0.0002	0.00015377998352051	SELECT * FROM pages WHERE id = '421'
294	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '426'
295	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '430'
296	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '431'
297	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '434'
298	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '435'
299	0.0002	0.00016212463378906	SELECT * FROM pages WHERE id = '440'
300	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '441'
301	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '451'
302	0.0001	0.00014185905456543	SELECT * FROM pages WHERE id = '453'
303	0.0002	0.00015091896057129	SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304	0.0002	0.00016903877258301	SELECT * FROM pages WHERE id = '146'
305	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '158'
306	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '163'
307	0.0002	0.00023102760314941	SELECT * FROM pages WHERE id = '293'
308	0.0002	0.00016093254089355	SELECT * FROM pages WHERE id = '340'
309	0.0002	0.00015997886657715	SELECT * FROM pages WHERE id = '417'
310	0.0001	0.00014090538024902	SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311	0.0002	0.00016593933105469	SELECT * FROM pages WHERE id = '173'
312	0.0002	0.00015497207641602	SELECT * FROM pages WHERE id = '181'
313	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '288'
314	0.0002	0.0001978874206543	SELECT * FROM pages WHERE id = '299'
315	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '300'
316	0.0002	0.00015687942504883	SELECT * FROM pages WHERE id = '383'
317	0.0003	0.00025391578674316	SELECT * FROM pages WHERE id = '385'
318	0.0003	0.00030183792114258	SELECT * FROM pages WHERE id = '438'
319	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '442'
320	0.0001	0.00014209747314453	SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321	0.0004	0.00037217140197754	SELECT * FROM pages WHERE id = '103'
322	0.0004	0.0003509521484375	SELECT * FROM pages WHERE id = '134'
323	0.0002	0.00019478797912598	SELECT * FROM pages WHERE id = '139'
324	0.0004	0.0003659725189209	SELECT * FROM pages WHERE id = '143'
325	0.0002	0.00017714500427246	SELECT * FROM pages WHERE id = '234'
326	0.0002	0.00016498565673828	SELECT * FROM pages WHERE id = '248'
327	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '260'
328	0.0002	0.00015616416931152	SELECT * FROM pages WHERE id = '398'
329	0.0002	0.0001671314239502	SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330	0.0002	0.00019001960754395	SELECT * FROM pages WHERE id = '61'
331	0.0002	0.00016188621520996	SELECT * FROM pages WHERE id = '87'
332	0.0002	0.00016307830810547	SELECT * FROM pages WHERE id = '104'
333	0.0002	0.00020885467529297	SELECT * FROM pages WHERE id = '115'
334	0.0001	0.00014495849609375	SELECT * FROM pages WHERE id = '124'
335	0.0002	0.0001671314239502	SELECT * FROM pages WHERE id = '144'
336	0.0002	0.00017499923706055	SELECT * FROM pages WHERE id = '151'
337	0.0001	0.00014615058898926	SELECT * FROM pages WHERE id = '199'
338	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '200'
339	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '304'
340	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '321'
341	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '333'
342	0.0002	0.0001678466796875	SELECT * FROM pages WHERE id = '350'
343	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '378'
344	0.0001	0.00014805793762207	SELECT * FROM pages WHERE id = '422'
345	0.0002	0.00017690658569336	SELECT * FROM pages WHERE id = '425'
346	0.0002	0.00015783309936523	SELECT * FROM pages WHERE id = '443'
347	0.0001	0.00014710426330566	SELECT * FROM pages WHERE id = '444'
348	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '445'
349	0.0002	0.00015711784362793	SELECT * FROM pages WHERE id = '446'
350	0.0001	0.00014400482177734	SELECT * FROM pages WHERE id = '447'
351	0.0002	0.0001530647277832	SELECT * FROM pages WHERE id = '448'
352	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '455'
353	0.0002	0.00015401840209961	SELECT * FROM pages WHERE id = '456'
354	0.0001	0.00013995170593262	SELECT * FROM pages WHERE id = '459'
355	0.0002	0.00015807151794434	SELECT * FROM pages WHERE id = '460'
356	0.0001	0.00014781951904297	SELECT * FROM pages WHERE id = '462'
357	0.0002	0.00015401840209961	SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358	0.0002	0.00017094612121582	SELECT * FROM pages WHERE id = '153'
359	0.0002	0.00020480155944824	SELECT * FROM pages WHERE id = '182'
360	0.0001	0.00014901161193848	SELECT * FROM pages WHERE id = '238'
361	0.0001	0.00014305114746094	SELECT * FROM pages WHERE id = '240'
362	0.0001	0.00014686584472656	SELECT * FROM pages WHERE id = '242'
363	0.0001	0.00014090538024902	SELECT * FROM pages WHERE id = '252'
364	0.0001	0.0001380443572998	SELECT * FROM pages WHERE id = '253'
365	0.0001	0.00014114379882812	SELECT * FROM pages WHERE id = '262'
366	0.0001	0.00013899803161621	SELECT * FROM pages WHERE id = '267'
367	0.0001	0.00014591217041016	SELECT * FROM pages WHERE id = '420'
368	0.0001	0.00014901161193848	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
369	0.0001	0.00012397766113281	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
370	0.0001	0.00012016296386719	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
371	0.0014	0.0014340877532959	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372	0.0002	0.00019502639770508	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY'
373	0.0001	0.00012397766113281	SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY'
374	0.0001	0.00011992454528809	SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE'
375	0.0003	0.00028896331787109	SELECT * FROM products WHERE pagename = 'sightmark-core-shot'
376	0.0002	0.00021791458129883	SELECT * FROM manufacturers WHERE id = '348'
377	0.0008	0.00075507164001465	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
378	0.0001	0.00012898445129395	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '348' LIMIT 1
379	0.0007	0.00066995620727539	SELECT pagename, id FROM products p WHERE manufacturer_id = '348' ORDER BY RAND() LIMIT 1
380	0.0002	0.00021600723266602	SELECT * FROM productimages WHERE product_id = '413358' ORDER BY sortorder ASC
381	0.0006	0.00063896179199219	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '348'
382	0.0007	0.00068902969360352	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '348' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
383	0.0001	0.00012707710266113	SELECT * FROM manufacturerimages WHERE manufacturer_id = '348'
384	0.0001	0.00013494491577148	SELECT category_id FROM products_categories WHERE product_id = '331198'
385	0.0002	0.0002129077911377	SELECT * FROM categories WHERE id = '64'
386	0.0042	0.0041821002960205	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
387	0.0001	0.00014495849609375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 64
388	0.0003	0.0002748966217041	SELECT id FROM categories WHERE parent_id = '64'
389	0.0042	0.0041871070861816	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
390	0.0002	0.00016999244689941	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
391	0.0002	0.00015616416931152	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
392	0.0002	0.00018405914306641	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
393	0.0005	0.00046396255493164	SELECT * FROM productimages WHERE product_id = '331198' ORDER BY sortorder ASC
394	0.0002	0.00022196769714355	SELECT * FROM product_image_select WHERE product_id = '331198'
395	0.0001	0.00014090538024902	SELECT * FROM productcustomimages WHERE product_id = '331198'
396	0.0001	0.00011992454528809	SELECT * FROM productfeeds WHERE product_id = '331198' ORDER BY item_date DESC
397	0.0003	0.00034213066101074	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '331198' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398	0.0003	0.00033092498779297	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '331198' AND t.hidden = 0 AND display_product = 1
399	0.0001	0.00014710426330566	SELECT * FROM tags WHERE id = '4189'
400	0.0005	0.00049686431884766	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '4189' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
401	0.0005	0.00047397613525391	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '4189' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
402	0.0005	0.00050497055053711	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '4189' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403	0.0002	0.00020694732666016	SELECT * FROM productimages WHERE product_id = '371594' ORDER BY sortorder ASC
404	0.0002	0.00015616416931152	SELECT * FROM tags WHERE id = '3385'
405	0.0012	0.0011968612670898	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3385' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
406	0.0011	0.0011398792266846	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3385' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
407	0.0012	0.001162052154541	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3385' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408	0.0002	0.00019502639770508	SELECT * FROM productimages WHERE product_id = '412716' ORDER BY sortorder ASC
409	0.0002	0.00017309188842773	SELECT * FROM productamazoncontent WHERE product_id = '331198'
410	0.0028	0.0027861595153809	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '331198' AND a.name = n.originalname
411	0.0002	0.00019288063049316	SELECT * FROM productoffers WHERE product_id = '331198' AND merchantid = 'ATVPDKIKX0DER'
412	0.0002	0.00018596649169922	SELECT * FROM productoffers WHERE product_id = '331198' AND price > 0 ORDER BY price ASC LIMIT 1
413	0.0002	0.0001678466796875	SELECT * FROM productoffers WHERE product_id = 331198 ORDER BY price ASC LIMIT 1
414	0.0002	0.00023412704467773	SELECT value FROM productattributes WHERE product_id = '331198' AND name = 'ListPriceAmount'
415	0.0003	0.00031805038452148	UPDATE products SET price = '7969' WHERE id = '331198'
416	0.2361	0.23608899116516	SELECT *, MATCH (description, keyfeatures, title) AGAINST ('shot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('shot' IN BOOLEAN MODE) AND 331198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
417	0.0004	0.00036406517028809	SELECT * FROM productimages WHERE product_id = '115381' ORDER BY sortorder ASC
418	0.0002	0.00023603439331055	SELECT * FROM product_image_select WHERE product_id = '115381'
419	0.0001	0.00012803077697754	SELECT * FROM productcustomimages WHERE product_id = '115381'
420	0.0030	0.0030179023742676	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '115381' AND a.name = n.originalname
421	0.0002	0.0001981258392334	SELECT * FROM productoffers WHERE product_id = '115381' AND merchantid = 'ATVPDKIKX0DER'
422	0.0002	0.00020694732666016	SELECT * FROM productoffers WHERE product_id = '115381' AND price > 0 ORDER BY price ASC LIMIT 1
423	0.0004	0.00042390823364258	SELECT value FROM productattributes WHERE product_id = '115381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
424	0.0001	0.00013995170593262	UPDATE products SET price = '12999' WHERE id = '115381'
425	0.0002	0.00017404556274414	SELECT * FROM productimages WHERE product_id = '54123' ORDER BY sortorder ASC
426	0.0003	0.00026392936706543	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '54123' AND p.id = pi.product_id ORDER BY pi.sortorder
427	0.0002	0.00022983551025391	SELECT * FROM product_image_select WHERE product_id = '54123'
428	0.0001	0.00012397766113281	SELECT * FROM productcustomimages WHERE product_id = '54123'
429	0.0003	0.00026392936706543	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '54123' GROUP BY o.product_id
430	0.0003	0.00030088424682617	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '54123' GROUP BY n.displayname ORDER BY n.displayname DESC
431	0.0002	0.00023412704467773	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 54123
432	0.0018	0.0017530918121338	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '54123' AND a.name = n.originalname
433	0.0002	0.00018596649169922	SELECT * FROM productoffers WHERE product_id = '54123' AND merchantid = 'ATVPDKIKX0DER'
434	0.0002	0.00017905235290527	SELECT * FROM productoffers WHERE product_id = '54123' AND price > 0 ORDER BY price ASC LIMIT 1
435	0.0002	0.00015997886657715	SELECT * FROM productoffers WHERE product_id = 54123 ORDER BY price ASC LIMIT 1
436	0.0002	0.00023412704467773	SELECT value FROM productattributes WHERE product_id = '54123' AND name = 'ListPriceAmount'
437	0.0003	0.00026702880859375	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '54123' GROUP BY o.product_id
438	0.0003	0.00028204917907715	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '54123' GROUP BY n.displayname ORDER BY n.displayname DESC
439	0.0002	0.0002138614654541	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 54123
440	0.0003	0.00034403800964355	SELECT value FROM productattributes WHERE product_id = '54123' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
441	0.0001	0.00013995170593262	UPDATE products SET price = '8062' WHERE id = '54123'
442	0.0003	0.00032997131347656	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '54123' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
443	0.0003	0.0002899169921875	SELECT * FROM productimages WHERE product_id = '138270' ORDER BY sortorder ASC
444	0.0002	0.00021910667419434	SELECT * FROM product_image_select WHERE product_id = '138270'
445	0.0001	0.00013899803161621	SELECT * FROM productcustomimages WHERE product_id = '138270'
446	0.0032	0.0032141208648682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '138270' AND a.name = n.originalname
447	0.0002	0.00019288063049316	SELECT * FROM productoffers WHERE product_id = '138270' AND merchantid = 'ATVPDKIKX0DER'
448	0.0002	0.00020194053649902	SELECT * FROM productoffers WHERE product_id = '138270' AND price > 0 ORDER BY price ASC LIMIT 1
449	0.0004	0.00042510032653809	SELECT value FROM productattributes WHERE product_id = '138270' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450	0.0001	0.00012588500976562	UPDATE products SET price = '94999' WHERE id = '138270'
451	0.0003	0.00034594535827637	SELECT * FROM productimages WHERE product_id = '272785' ORDER BY sortorder ASC
452	0.0002	0.00022602081298828	SELECT * FROM product_image_select WHERE product_id = '272785'
453	0.0001	0.00012397766113281	SELECT * FROM productcustomimages WHERE product_id = '272785'
454	0.0025	0.0024929046630859	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '272785' AND a.name = n.originalname
455	0.0002	0.00020503997802734	SELECT * FROM productoffers WHERE product_id = '272785' AND merchantid = 'ATVPDKIKX0DER'
456	0.0002	0.00020599365234375	SELECT * FROM productoffers WHERE product_id = '272785' AND price > 0 ORDER BY price ASC LIMIT 1
457	0.0003	0.00034689903259277	SELECT value FROM productattributes WHERE product_id = '272785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458	0.0001	0.00012302398681641	UPDATE products SET price = '2645' WHERE id = '272785'
459	0.0002	0.00024509429931641	SELECT * FROM productimages WHERE product_id = '268101' ORDER BY sortorder ASC
460	0.0002	0.00021505355834961	SELECT * FROM product_image_select WHERE product_id = '268101'
461	0.0001	0.00012421607971191	SELECT * FROM productcustomimages WHERE product_id = '268101'
462	0.0033	0.0033040046691895	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268101' AND a.name = n.originalname
463	0.0002	0.00020194053649902	SELECT * FROM productoffers WHERE product_id = '268101' AND merchantid = 'ATVPDKIKX0DER'
464	0.0002	0.00020599365234375	SELECT * FROM productoffers WHERE product_id = '268101' AND price > 0 ORDER BY price ASC LIMIT 1
465	0.0003	0.00032711029052734	SELECT value FROM productattributes WHERE product_id = '268101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466	0.0001	0.00012302398681641	UPDATE products SET price = '4323' WHERE id = '268101'
467	0.0002	0.00018811225891113	SELECT * FROM productimages WHERE product_id = '406398' ORDER BY sortorder ASC
468	0.0002	0.00021791458129883	SELECT * FROM product_image_select WHERE product_id = '406398'
469	0.0001	0.0001220703125	SELECT * FROM productcustomimages WHERE product_id = '406398'
470	0.0025	0.0024850368499756	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406398' AND a.name = n.originalname
471	0.0002	0.00018906593322754	SELECT * FROM productoffers WHERE product_id = '406398' AND merchantid = 'ATVPDKIKX0DER'
472	0.0002	0.0001990795135498	SELECT * FROM productoffers WHERE product_id = '406398' AND price > 0 ORDER BY price ASC LIMIT 1
473	0.0004	0.00037813186645508	SELECT value FROM productattributes WHERE product_id = '406398' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474	0.0001	0.00012493133544922	UPDATE products SET price = '1699' WHERE id = '406398'
475	0.0001	0.00014615058898926	SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME'
476	0.0001	0.00012421607971191	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
477	0.0001	0.0001220703125	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
478	0.0001	0.00011992454528809	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
479	0.0001	0.00011897087097168	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
480	0.0001	0.00012707710266113	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
481	0.0001	0.00013899803161621	SELECT * FROM ebay_locale_details WHERE cur_code = 'USD'
482	0.1910	0.19100689888	SELECT * FROM ebay_products_cache WHERE cachekey = '010ed9f83e28ae2b465d58d54ca65166'
483	0.0003	0.00026583671569824	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
484	0.0001	0.00012588500976562	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
485	0.0001	0.00011992454528809	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
486	0.0001	0.00011801719665527	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
487	0.0001	0.00012898445129395	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
488	0.1918	0.19182205200195	SELECT * FROM ebay_products_cache WHERE cachekey = '010ed9f83e28ae2b465d58d54ca65166'
489	0.0003	0.00027585029602051	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
490	0.0001	0.00012993812561035	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
491	0.0001	0.00012087821960449	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
492	0.0001	0.00011992454528809	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
493	0.0001	0.00011706352233887	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
494	0.2088	0.20883297920227	SELECT * FROM ebay_products_cache WHERE cachekey = '010ed9f83e28ae2b465d58d54ca65166'
495	0.0003	0.00027298927307129	SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID'
496	0.0001	0.00014400482177734	SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID'
497	0.0001	0.00013422966003418	SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID'
498	0.0001	0.00014805793762207	SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE'
499	0.0002	0.00015807151794434	SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN'
500	0.1933	0.19326090812683	SELECT * FROM ebay_products_cache WHERE cachekey = '010ed9f83e28ae2b465d58d54ca65166'

Sightmark Core Shot from Sellmark Corporation

Product Description

Manufacturer Description

Product Features

Write a Review

Related Products

Pyle PSHTCM88 Handheld Night Vision Came...

Mueller Quick Shot Rifle Scope from Spor...

Pulsar N750 Digisight Riflescope by Puls...

First Aid Kit: FIRST AID KIT FULLY STOCK...

BARSKA 3-9x40 Huntmaster Easy Shot Rifle...

Ade Advanced Optics Spring Field Tactica...

Current deals from eBay

Sight Mark Core Shot A- Spec FMS Ref... $ 129.97

9 Day(s) 13 h(s)

Worldwide

Sightmark Core Shot Pro Spec Reflex ... $ 99.97

4 Day(s) 14 h(s)

Worldwide

SightMark Core Shot Pro Spec SM26001 $ 99.97

1 Day(s) 19 h(s)

Worldwide

Sightmark Core Shot A-Spec SM26017 $ 155.99

10 Day(s) 11 h(s)

Worldwide

Sightmark Core Shot Red Dot Sight, D... $ 101.90

22 Day(s) 2 h(s)

Worldwide

SIGHTMARK Core Shot SM26001 $ 155.99

29 Day(s) 18 h(s)

Worldwide

Sightmark 1x28x29 Core Shot Pro Spec... $ 129.97

29 Day(s) 8 h(s)

Worldwide

SIGHTMARK Core Shot SM26001 $ 155.99

25 Day(s) 14 h(s)

Worldwide

Sightmark SM26017 Core Shot A-Spec F... $ 199.11$ 151.99 (24% Discount)

23 Day(s) 12 h(s)

Worldwide

Sightmark SM26001 Core Shot Reflex S... $ 170.26$ 129.97 (24% Discount)

23 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 3.8671188354492 seconds

Query Debug - 778 Database Queries. Total time 1.8942 seconds