Tactical Equipment - Survivalist Equipment

Nc Star High Resolution Spotting Scope with Carry Case, 20-60X60 from Green Supply

Price: $84.99
Product prices and availability are accurate as of 2019-07-17 08:44:04 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
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Description

The Tactical and Survivalist shop is proud to bring you the beneficial Nc Star High Resolution Spotting Scope with Carry Case, 20-60X60 today at this amazing price.

With so many competing tactical, combat and survival products on offer these days, it is good to have a provider that you can recognize. The Nc Star High Resolution Spotting Scope with Carry Case, 20-60X60 is certainly all that and will be a great acquisition for your combat equipment or tactical training.

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

For this low price, the Nc Star High Resolution Spotting Scope with Carry Case, 20-60X60 is highly recommended and is a regular choice amongst many like minded people. Green Supply have passed on some great touches and this results in great value for money.

Manufacturer Description

High Resolution 20-60x60 Spotter w/Case - High Resolution Optics Provide a Super Crisp and Clear Image - 60mm Objective, Fully Multi Coated lens for optimum light and clarity - Built in Slide Out Sunshade for reduced glare - Rubber Armored Over-Molded Body Provides a Superior Level of Protection - Includes a Custom Soft Carry Case that can be left on the Spotting scope while mounted on the Tripod and during usage. Requirements: Magnification: 20x-60x Objective Diameter (mm): 60 Field of View (ft. @ 100 YDS): 96-48 Exit Pupil (mm): 2.5 @ 20x Weight (oz.): 27.8 Length (in): 14 Lens Coating: Green.

Product Features

20x-60x Magnification, 60mm Objective lens Black Rubber Armored body Built-in sliding sunshade Nitrogen filled and O-ring sealed 60mm Objective, Fully Multi Coated lens for maximum light and clarity Rubber Armored Over-Molded Body Built in Slide Out Sunshade for decreased glare Includes a Custom Soft Carry Case

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.9076318740845 729 1.0886 0


No Amazon API Requests Made.


App Debug - Total Time 1.9076318740845 seconds

Number Time From Start Name Description
1 0.45519185066223 Initialise Initialise FSB Function
2 0.4593620300293 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47333788871765 Start of getCategoryListByGroup Function Before first category groups query
4 0.47353196144104 After initial query Before first category groups query
5 0.47353386878967 Get Category List for Group Before the call to getCategoryList function
6 0.4735369682312 Start of GetCategoryList function Start of the function
7 0.47354102134705 Before getting categories Query to get specific category list
8 0.474200963974 After getting categories Query to get specific category list
9 0.47420191764832 Before getting category custom Before call to function getCategoryCustom
10 0.4765248298645 After getting category custom After call to function getCategoryCustom
11 0.47652697563171 Before getting category custom Before call to function getCategoryCustom
12 0.48764395713806 After getting category custom After call to function getCategoryCustom
13 0.48764681816101 Before getting category custom Before call to function getCategoryCustom
14 0.49354195594788 After getting category custom After call to function getCategoryCustom
15 0.49354386329651 Before getting category custom Before call to function getCategoryCustom
16 0.49765181541443 After getting category custom After call to function getCategoryCustom
17 0.49765396118164 End of GetCategoryList function End of the function
18 0.49766492843628 Get Category List for Group Before the call to getCategoryList function
19 0.49766683578491 Start of GetCategoryList function Start of the function
20 0.49766993522644 Before getting categories Query to get specific category list
21 0.49811100959778 After getting categories Query to get specific category list
22 0.49811291694641 Before getting category custom Before call to function getCategoryCustom
23 0.50364303588867 After getting category custom After call to function getCategoryCustom
24 0.5036449432373 Before getting category custom Before call to function getCategoryCustom
25 0.51424789428711 After getting category custom After call to function getCategoryCustom
26 0.51425004005432 End of GetCategoryList function End of the function
27 0.51425695419312 Get Category List for Group Before the call to getCategoryList function
28 0.51425886154175 Start of GetCategoryList function Start of the function
29 0.51426196098328 Before getting categories Query to get specific category list
30 0.51496887207031 After getting categories Query to get specific category list
31 0.51497101783752 Before getting category custom Before call to function getCategoryCustom
32 0.52422595024109 After getting category custom After call to function getCategoryCustom
33 0.52422785758972 Before getting category custom Before call to function getCategoryCustom
34 0.54168200492859 After getting category custom After call to function getCategoryCustom
35 0.54168391227722 Before getting category custom Before call to function getCategoryCustom
36 0.54757785797119 After getting category custom After call to function getCategoryCustom
37 0.5475800037384 Before getting category custom Before call to function getCategoryCustom
38 0.55343294143677 After getting category custom After call to function getCategoryCustom
39 0.5534360408783 Before getting category custom Before call to function getCategoryCustom
40 0.55963897705078 After getting category custom After call to function getCategoryCustom
41 0.55964088439941 Before getting category custom Before call to function getCategoryCustom
42 0.58135199546814 After getting category custom After call to function getCategoryCustom
43 0.58135485649109 Before getting category custom Before call to function getCategoryCustom
44 0.58541798591614 After getting category custom After call to function getCategoryCustom
45 0.58542084693909 Before getting category custom Before call to function getCategoryCustom
46 0.59027004241943 After getting category custom After call to function getCategoryCustom
47 0.59027194976807 End of GetCategoryList function End of the function
48 0.59028601646423 Get Category List for Group Before the call to getCategoryList function
49 0.59028887748718 Start of GetCategoryList function Start of the function
50 0.59029197692871 Before getting categories Query to get specific category list
51 0.59070491790771 After getting categories Query to get specific category list
52 0.59070682525635 Before getting category custom Before call to function getCategoryCustom
53 0.5929958820343 After getting category custom After call to function getCategoryCustom
54 0.59299802780151 Before getting category custom Before call to function getCategoryCustom
55 0.59528183937073 After getting category custom After call to function getCategoryCustom
56 0.59528398513794 End of GetCategoryList function End of the function
57 0.59528994560242 Get Category List for Group Before the call to getCategoryList function
58 0.59529185295105 Start of GetCategoryList function Start of the function
59 0.59529495239258 Before getting categories Query to get specific category list
60 0.5956130027771 After getting categories Query to get specific category list
61 0.59561395645142 Before getting category custom Before call to function getCategoryCustom
62 0.60060381889343 After getting category custom After call to function getCategoryCustom
63 0.60060596466064 End of GetCategoryList function End of the function
64 0.60061192512512 End of getCategoryListByGroup Function Before return()
65 0.65029191970825 App Controller End End of the App controller (called before the controller of every page)
66 0.65089392662048 Product Start Start of the product info controller
67 0.65170192718506 Cache file not found Starting get product details
68 0.66407585144043 Related products Start getting related products if enabled
69 0.66407704353333 Related Products Start Before the related products are found
70 0.66407799720764 Related Products Keywords Before the related product keywords are found
71 0.66408491134644 Create Keyword List Function Start of function
72 0.66500091552734 Create Keyword List Function After looping provided content - 617 keywords found
73 0.70427989959717 Create Keyword List Function After looping initial keyword list - 567 keywords remaining
74 0.70442700386047 Create Keyword List Function After reducing keyword list
75 0.70553493499756 Create Keyword List Function After selecting by scoring keywords
76 0.70554184913635 Create Keyword List Function After final loop of keywords
77 0.7055459022522 Related Products Keywords After the related product keywords are found
78 0.97534990310669 Related Products End After the related products are found
79 1.1855068206787 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.3353109359741 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.5561039447784 Product End End of the product info controller (Product Info)
82 1.5564789772034 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.5565588474274 Before Get Options Before the call to getOptions in the tpl class
84 1.7589929103851 After Get Options After the call to getOptions in the tpl class
85 1.7591989040375 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.7592120170593 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 1.8827819824219 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 1.8827888965607 Product Info: Before Template Display Before the template is displayed
89 1.9076099395752 Product Info: After Template Display After the template is displayed
90 1.9076149463654 Finalizing debug Before the debug is output to the page.
91 1.9076309204102 End of App This is the end of the app logging, final timestamp


Query Debug - 729 Database Queries. Total time 1.0886 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00021100044250488
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00049591064453125
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00019097328186035
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00016999244689941
SELECT * FROM `bad_bots`
5 0.0004 0.00043582916259766
SELECT parameter, value FROM parameters
6 0.0001 0.00014996528625488
SET time_zone = 'Europe/London'
7 0.0004 0.00036311149597168
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017714500427246
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011897087097168
delete from cachefiles
10 0.0003 0.00027108192443848
SELECT id FROM pages WHERE pagename = 'nc-star-high-resolution-spotting-scope-with-carry-case-20-60x60' LIMIT 1
11 0.0003 0.00026488304138184
SELECT id FROM products WHERE pagename = 'nc-star-high-resolution-spotting-scope-with-carry-case-20-60x60' AND hidden = 0 LIMIT 1
12 0.0010 0.0009758472442627
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0119 0.011942863464355
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00026702880859375
SELECT * FROM pages WHERE pagename = 'nc-star-high-resolution-spotting-scope-with-carry-case-20-60x60'
15 0.0002 0.00017905235290527
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00062108039855957
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0003 0.00031805038452148
SELECT id FROM categories WHERE parent_id = '49'
19 0.0006 0.00056695938110352
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.0001978874206543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00018501281738281
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.00021791458129883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00014710426330566
SELECT * FROM categorygroups WHERE id = '1'
24 0.0035 0.003547191619873
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.00028300285339355
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057179927825928
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.0001680850982666
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.0001530647277832
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
35 0.0025 0.002479076385498
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '80'
37 0.0025 0.0024831295013428
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.00014996528625488
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.00014591217041016
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.001162052154541
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017809867858887
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.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00041699409484863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023138523101807
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.00024986267089844
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022921562194824
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048348903656006
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.00026488304138184
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048110485076904
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.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00015711784362793
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00064516067504883
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0042 0.0041520595550537
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.00027108192443848
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.004115104675293
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.00016117095947266
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00016307830810547
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
73 0.0083 0.0082800388336182
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0082011222839355
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.00016188621520996
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0001 0.00014781951904297
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.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024909973144531
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024700164794922
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.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 (81)
				  AND p.disabled = 0 
84 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024502277374268
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024600028991699
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.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014591217041016
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.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0022521018981934
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.00026488304138184
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027987957000732
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.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0001 0.00014591217041016
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.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0094630718231201
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00019979476928711
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019621849060059
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010174036026001
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.00017380714416504
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.00015497207641602
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015709400177002
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.00025510787963867
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015718936920166
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.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014185905456543
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019669532775879
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.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '89'
123 0.0020 0.0019590854644775
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00038909912109375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00068807601928711
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.00023007392883301
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069499015808105
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.00014305114746094
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.00014376640319824
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00067400932312012
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.00024199485778809
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00069999694824219
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.00014114379882812
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00030398368835449
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020451545715332
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.00024914741516113
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020468235015869
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014591217041016
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.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051741600036621
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036811828613281
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019097328186035
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00019621849060059
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001518726348877
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.00018095970153809
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00024104118347168
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014495849609375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020480155944824
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001368522644043
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00013589859008789
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '398'
329 0.0001 0.00014996528625488
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014181137084961
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00015711784362793
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00027203559875488
SELECT * FROM products WHERE pagename = 'nc-star-high-resolution-spotting-scope-with-carry-case-20-60x60'
376 0.0002 0.00022578239440918
SELECT * FROM manufacturers WHERE id = '1328'
377 0.0006 0.00060200691223145
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1328'
378 0.0001 0.0001220703125
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '1328' LIMIT 1
379 0.0005 0.00053882598876953
SELECT pagename, id FROM products p WHERE manufacturer_id = '1328' ORDER BY RAND() LIMIT 1
380 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '407564' ORDER BY sortorder ASC
381 0.0005 0.00052380561828613
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '1328'
382 0.0006 0.0005650520324707
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '1328'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.0001220703125
SELECT * FROM manufacturerimages WHERE manufacturer_id = '1328'
384 0.0001 0.00014805793762207
SELECT category_id FROM products_categories WHERE product_id = '268888'
385 0.0002 0.00017404556274414
SELECT * FROM categories WHERE id = '32'
386 0.0016 0.001615047454834
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
387 0.0001 0.00011897087097168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
388 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '32'
389 0.0016 0.0015900135040283
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 
390 0.0002 0.0001528263092041
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 
391 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
393 0.0002 0.00023508071899414
SELECT * FROM productimages WHERE product_id = '268888' ORDER BY sortorder ASC
394 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '268888'
395 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '268888'
396 0.0001 0.00011301040649414
SELECT * FROM productfeeds WHERE product_id = '268888' ORDER BY item_date DESC
397 0.0003 0.00032782554626465
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '268888' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00030684471130371
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '268888' AND t.hidden = 0 AND display_product = 1
399 0.0005 0.00052213668823242
SELECT * FROM productamazoncontent WHERE product_id = '268888'
400 0.0018 0.0017609596252441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268888' AND a.name = n.originalname
401 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '268888' AND merchantid = 'ATVPDKIKX0DER'
402 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '268888' AND price > 0
                ORDER BY price ASC LIMIT 1
403 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 268888
                ORDER BY price ASC LIMIT 1
404 0.0002 0.00022792816162109
SELECT value FROM productattributes
                WHERE product_id = '268888'
                AND name = 'ListPriceAmount'
405 0.0001 0.00013518333435059
UPDATE products SET price = '8499' WHERE id = '268888'
406 0.2448 0.24482989311218
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('carry case' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('carry case' IN BOOLEAN MODE) AND 268888 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
407 0.0005 0.00046992301940918
SELECT * FROM productimages WHERE product_id = '130584' ORDER BY sortorder ASC
408 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '130584'
409 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '130584'
410 0.0027 0.002701997756958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130584' AND a.name = n.originalname
411 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '130584' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '130584' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '130584' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0001 0.0001380443572998
UPDATE products SET price = '7999' WHERE id = '130584'
415 0.0002 0.00017786026000977
SELECT * FROM productimages WHERE product_id = '163658' ORDER BY sortorder ASC
416 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '163658'
417 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '163658'
418 0.0020 0.0020210742950439
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '163658' AND a.name = n.originalname
419 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '163658' AND merchantid = 'ATVPDKIKX0DER'
420 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '163658' AND price > 0
                ORDER BY price ASC LIMIT 1
421 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '163658' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0001 0.00012111663818359
UPDATE products SET price = '12321' WHERE id = '163658'
423 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '106913' ORDER BY sortorder ASC
424 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '106913'
425 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '106913'
426 0.0022 0.0022130012512207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '106913' AND a.name = n.originalname
427 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '106913' AND merchantid = 'ATVPDKIKX0DER'
428 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '106913' AND price > 0
                ORDER BY price ASC LIMIT 1
429 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '106913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430 0.0001 0.00011992454528809
UPDATE products SET price = '2795' WHERE id = '106913'
431 0.0002 0.0002281665802002
SELECT * FROM productimages WHERE product_id = '133677' ORDER BY sortorder ASC
432 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '133677'
433 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '133677'
434 0.0022 0.0021870136260986
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '133677' AND a.name = n.originalname
435 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '133677' AND merchantid = 'ATVPDKIKX0DER'
436 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '133677' AND price > 0
                ORDER BY price ASC LIMIT 1
437 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '133677' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438 0.0001 0.00012016296386719
UPDATE products SET price = '3097' WHERE id = '133677'
439 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '122200' ORDER BY sortorder ASC
440 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '122200'
441 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '122200'
442 0.0025 0.0025060176849365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '122200' AND a.name = n.originalname
443 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '122200' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '122200' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '122200' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446 0.0001 0.00012087821960449
UPDATE products SET price = '925' WHERE id = '122200'
447 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '136887' ORDER BY sortorder ASC
448 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '136887'
449 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '136887'
450 0.0030 0.0030388832092285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '136887' AND a.name = n.originalname
451 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '136887' AND merchantid = 'ATVPDKIKX0DER'
452 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '136887' AND price > 0
                ORDER BY price ASC LIMIT 1
453 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '136887' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
454 0.0001 0.00011801719665527
UPDATE products SET price = '1025' WHERE id = '136887'
455 0.0001 0.00014209747314453
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
456 0.0001 0.00014209747314453
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
457 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
458 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
459 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
460 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
461 0.0001 0.00013589859008789
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
462 0.2081 0.20808792114258
SELECT * FROM ebay_products_cache WHERE cachekey = 'edb3e1518a41171bd59d19da886e53f0' 
463 0.0003 0.00028014183044434
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
464 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
465 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
466 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
467 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
468 0.2053 0.20532083511353
SELECT * FROM ebay_products_cache WHERE cachekey = 'edb3e1518a41171bd59d19da886e53f0' 
469 0.0003 0.00028514862060547
SELECT id,asin FROM products WHERE parent_id = 268888
470 0.0003 0.00032496452331543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '268888' ORDER BY timestamp DESC
471 0.0001 0.00014400482177734
SELECT category_id FROM products_categories WHERE product_id = '268888'
472 0.0002 0.00019001960754395
SELECT * FROM categories WHERE id = '32'
473 0.0017 0.0016617774963379
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
474 0.0001 0.00012087821960449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
475 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '32'
476 0.0016 0.0015881061553955
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 
477 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
478 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
479 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
480 0.0017 0.001708984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268888' AND a.name = n.originalname
481 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '268888' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '268888' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 268888
                ORDER BY price ASC LIMIT 1
484 0.0002 0.00022792816162109
SELECT value FROM productattributes
                WHERE product_id = '268888'
                AND name = 'ListPriceAmount'
485 0.0002 0.0002138614654541
SELECT * FROM products WHERE id = '268888'
486 0.0001 0.00012803077697754
UPDATE products SET price = '8499' WHERE id = '268888'
487 0.0017 0.001666784286499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '268888' AND a.name = n.originalname
488 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '268888' AND merchantid = 'ATVPDKIKX0DER'
489 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '268888' AND price > 0
                ORDER BY price ASC LIMIT 1
490 0.0002 0.00015783309936523
SELECT * FROM productoffers
                WHERE product_id = 268888
                ORDER BY price ASC LIMIT 1
491 0.0002 0.00022196769714355
SELECT value FROM productattributes
                WHERE product_id = '268888'
                AND name = 'ListPriceAmount'
492 0.0001 0.00013184547424316
SELECT category_id FROM products_categories WHERE product_id = '268888'
493 0.0001 0.00012707710266113
SELECT parent_id FROM categories WHERE id = '32'
494 0.0002 0.00015687942504883
SELECT * FROM categories WHERE id = '32'
495 0.0015 0.0015208721160889
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
496 0.0001 0.00011897087097168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
497 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '32'
498 0.0016 0.0015668869018555
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 
499 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
500 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
501 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
502 0.0002 0.00016903877258301
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
503 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = 2
504 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 4
505 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 12
506 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 10
507 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 7
508 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 18
509 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 28
510 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = 13
511 0.0001 0.00013279914855957
SELECT * FROM pages WHERE id = 3
512 0.0138 0.013833045959473
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
513 0.0002 0.00020623207092285
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:1563417253;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:9;s:6:\"258602\";i:13;s:6:\"169659\";i:14;s:6:\"407337\";i:15;s:6:\"123223\";i:19;s:6:\"406728\";}}' WHERE id = '175'
514 0.0004 0.00041699409484863
SELECT * FROM products WHERE id IN (398858,258602,169659,407337,123223,406728) ORDER BY FIELD(id, 398858,258602,169659,407337,123223,406728 )
515 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
516 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '398858'
517 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398858'
518 0.0031 0.0030579566955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
519 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
520 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
521 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
522 0.0001 0.00011897087097168
UPDATE products SET price = '2999' WHERE id = '398858'
523 0.0003 0.00034499168395996
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
524 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '258602'
525 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '258602'
526 0.0031 0.0031368732452393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
527 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
528 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
529 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
530 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '258602'
531 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '169659' ORDER BY sortorder ASC
532 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '169659'
533 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '169659'
534 0.0023 0.0022969245910645
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '169659' AND a.name = n.originalname
535 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '169659' AND merchantid = 'ATVPDKIKX0DER'
536 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '169659' AND price > 0
                ORDER BY price ASC LIMIT 1
537 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '169659' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
538 0.0001 0.00011801719665527
UPDATE products SET price = '10900' WHERE id = '169659'
539 0.0002 0.00016403198242188
SELECT * FROM productimages WHERE product_id = '407337' ORDER BY sortorder ASC
540 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407337'
541 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '407337'
542 0.0033 0.0032811164855957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407337' AND a.name = n.originalname
543 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '407337' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '407337' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '407337' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00011992454528809
UPDATE products SET price = '8999' WHERE id = '407337'
547 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
548 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '123223'
549 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '123223'
550 0.0027 0.0027470588684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
551 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011682510375977
UPDATE products SET price = '19661' WHERE id = '123223'
555 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '406728' ORDER BY sortorder ASC
556 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '406728'
557 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406728'
558 0.0022 0.0021851062774658
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406728' AND a.name = n.originalname
559 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '406728' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '406728' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '406728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011706352233887
UPDATE products SET price = '1359' WHERE id = '406728'
563 0.0135 0.013540983200073
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
564 0.0002 0.00020480155944824
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:1563417253;s:8:\"products\";a:6:{i:4;s:6:\"414321\";i:7;s:6:\"404868\";i:10;s:6:\"402907\";i:14;s:6:\"407337\";i:11;s:6:\"410951\";i:22;s:6:\"414983\";}}' WHERE id = '177'
565 0.0004 0.00043392181396484
SELECT * FROM products WHERE id IN (414321,404868,402907,407337,410951,414983) ORDER BY FIELD(id, 414321,404868,402907,407337,410951,414983 )
566 0.0002 0.00022482872009277
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
567 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '414321'
568 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414321'
569 0.0025 0.0024890899658203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
570 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
571 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
572 0.0004 0.00038981437683105
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
573 0.0001 0.0001220703125
UPDATE products SET price = '9999' WHERE id = '414321'
574 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
575 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '404868'
576 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '404868'
577 0.0030 0.00301194190979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
578 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
579 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
580 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
581 0.0001 0.00012898445129395
UPDATE products SET price = '46999' WHERE id = '404868'
582 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
583 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '402907'
584 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402907'
585 0.0030 0.0029969215393066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
586 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
589 0.0001 0.00011706352233887
UPDATE products SET price = '9400' WHERE id = '402907'
590 0.0002 0.00016307830810547
SELECT * FROM productimages WHERE product_id = '407337' ORDER BY sortorder ASC
591 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '407337'
592 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '407337'
593 0.0033 0.0032589435577393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407337' AND a.name = n.originalname
594 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '407337' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '407337' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '407337' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
597 0.0001 0.00012087821960449
UPDATE products SET price = '8999' WHERE id = '407337'
598 0.0002 0.00024890899658203
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
599 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '410951'
600 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '410951'
601 0.0021 0.0020821094512939
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
602 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
603 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
604 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
605 0.0001 0.00011801719665527
UPDATE products SET price = '94700' WHERE id = '410951'
606 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '414983' ORDER BY sortorder ASC
607 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '414983'
608 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '414983'
609 0.0024 0.0023820400238037
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414983' AND a.name = n.originalname
610 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '414983' AND merchantid = 'ATVPDKIKX0DER'
611 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '414983' AND price > 0
                ORDER BY price ASC LIMIT 1
612 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '414983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0001 0.00011897087097168
UPDATE products SET price = '1299' WHERE id = '414983'
614 0.0283 0.028269052505493
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
615 0.0002 0.00021100044250488
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:1563417253;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:4;s:6:\"414321\";i:8;s:6:\"402058\";i:14;s:6:\"407337\";i:1;s:6:\"415083\";i:5;s:6:\"127345\";}}' WHERE id = '181'
616 0.0007 0.00068402290344238
SELECT * FROM products WHERE id IN (290575,414321,402058,407337,415083,127345) ORDER BY FIELD(id, 290575,414321,402058,407337,415083,127345 )
617 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
618 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '290575'
619 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '290575'
620 0.0035 0.0034608840942383
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
621 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
622 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
623 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
624 0.0001 0.00012016296386719
UPDATE products SET price = '549500' WHERE id = '290575'
625 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
626 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '414321'
627 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '414321'
628 0.0025 0.0024940967559814
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
629 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
630 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
631 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
632 0.0001 0.00011992454528809
UPDATE products SET price = '9999' WHERE id = '414321'
633 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
634 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '402058'
635 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '402058'
636 0.0028 0.0028319358825684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
637 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0003 0.00034713745117188
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '402058'
641 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '407337' ORDER BY sortorder ASC
642 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '407337'
643 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '407337'
644 0.0033 0.0032501220703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407337' AND a.name = n.originalname
645 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '407337' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '407337' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '407337' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00011992454528809
UPDATE products SET price = '8999' WHERE id = '407337'
649 0.0002 0.00016880035400391
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
650 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '415083'
651 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '415083'
652 0.0035 0.0034971237182617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
653 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0002 0.0002439022064209
UPDATE products SET price = '2299' WHERE id = '415083'
657 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
658 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '127345'
659 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '127345'
660 0.0026 0.0026490688323975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
661 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
662 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
663 0.0004 0.0003972053527832
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
664 0.0001 0.00011897087097168
UPDATE products SET price = '19286' WHERE id = '127345'
665 0.0279 0.027940034866333
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
666 0.0002 0.00021100044250488
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:1563417253;s:8:\"products\";a:6:{i:4;s:6:\"414321\";i:7;s:6:\"404868\";i:8;s:6:\"402058\";i:9;s:6:\"258602\";i:15;s:6:\"123223\";i:16;s:6:\"406156\";}}' WHERE id = '183'
667 0.0004 0.00042581558227539
SELECT * FROM products WHERE id IN (414321,404868,402058,258602,123223,406156) ORDER BY FIELD(id, 414321,404868,402058,258602,123223,406156 )
668 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
669 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '414321'
670 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414321'
671 0.0025 0.0024950504302979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
672 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0001 0.00012111663818359
UPDATE products SET price = '9999' WHERE id = '414321'
676 0.0003 0.00028705596923828
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
677 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '404868'
678 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '404868'
679 0.0030 0.0029940605163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
680 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
681 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
682 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
683 0.0001 0.00012993812561035
UPDATE products SET price = '46999' WHERE id = '404868'
684 0.0003 0.00028014183044434
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
685 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402058'
686 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '402058'
687 0.0028 0.0028481483459473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
688 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
689 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
690 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
691 0.0001 0.00011706352233887
UPDATE products SET price = '19900' WHERE id = '402058'
692 0.0003 0.00031089782714844
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
693 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '258602'
694 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '258602'
695 0.0031 0.0031130313873291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
696 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '258602'
700 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
701 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '123223'
702 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '123223'
703 0.0027 0.0027470588684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
704 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
705 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
706 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
707 0.0001 0.00011920928955078
UPDATE products SET price = '19661' WHERE id = '123223'
708 0.0002 0.00016403198242188
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
709 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '406156'
710 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '406156'
711 0.0033 0.0032529830932617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
712 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
713 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
714 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
715 0.0001 0.00012016296386719
UPDATE products SET price = '1015' WHERE id = '406156'
716 0.0004 0.00039505958557129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
717 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
718 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
719 0.0001 0.00013089179992676
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
720 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
721 0.0004 0.00038480758666992
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
722 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
723 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
724 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
725 0.0009 0.0009160041809082
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
726 0.0003 0.00030112266540527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
727 0.0003 0.00028491020202637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
728 0.0005 0.0004580020904541
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
729 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'