Tactical Equipment - Survivalist Equipment

Ka-Bar Usmc Fighting Knife - Choose Style from Ka-bar :: Combat Knife :: Tactical Knife :: Hunting Knife :: Fixed Blade Knife :: Folding Blade Knife

Price: $107.99
Product prices and availability are accurate as of 2019-07-18 00:48:28 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: Not Available Discontinued
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

Stocking the best combat knives :: We are delighted to present the highest quality Combat Knife: Ka-Bar Usmc Fighting Knife - Choose Style today at this amazing price.

With a great selection of, Combat Knives and Tactical Knives on offer recently, it is good to have a blade make that you can recognize. The Combat Knife - Ka-Bar Usmc Fighting Knife - Choose Style is certainly all that and will be a superb addition for your combat gear, surveillance or tactical ability with hunting, combat defense and knife fighting.

At Tactical Survivalist we pride ourselves on providing the finest quality survivalist gear for all your on the job requirements. We have a variety of Tactical Knives and Survival knives in stock.

For this reduced price, the Combat Knife model : Ka-Bar Usmc Fighting Knife - Choose Style is highly respected and is always a regular choice amongst many like minded military and martial arts minded individuals. Ka-bar have produced some nice specialized touches and this equals good value for money in your knife selection.

Manufacturer Description

The Ka-Bar USMC combating knife is a lengendary blade that was very first developed to serve United States soldiers during World War II. Now, more than 50 years later it still offers the same premium design you can depend upon. It boasts a 1095 carbon steel blade that is epoxy powder coated and a stacked leather deal with. Includes a leather USMC sheath. Made in the USA.

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.2326200008392 757 1.1229 0


No Amazon API Requests Made.


App Debug - Total Time 2.2326200008392 seconds

Number Time From Start Name Description
1 0.36864113807678 Initialise Initialise FSB Function
2 0.38126301765442 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39240407943726 Start of getCategoryListByGroup Function Before first category groups query
4 0.39258003234863 After initial query Before first category groups query
5 0.39258098602295 Get Category List for Group Before the call to getCategoryList function
6 0.39258599281311 Start of GetCategoryList function Start of the function
7 0.39258909225464 Before getting categories Query to get specific category list
8 0.39314603805542 After getting categories Query to get specific category list
9 0.39314699172974 Before getting category custom Before call to function getCategoryCustom
10 0.39498615264893 After getting category custom After call to function getCategoryCustom
11 0.39498805999756 Before getting category custom Before call to function getCategoryCustom
12 0.40547013282776 After getting category custom After call to function getCategoryCustom
13 0.40547299385071 Before getting category custom Before call to function getCategoryCustom
14 0.41127109527588 After getting category custom After call to function getCategoryCustom
15 0.41127419471741 Before getting category custom Before call to function getCategoryCustom
16 0.41534519195557 After getting category custom After call to function getCategoryCustom
17 0.41534805297852 End of GetCategoryList function End of the function
18 0.41535615921021 Get Category List for Group Before the call to getCategoryList function
19 0.41535902023315 Start of GetCategoryList function Start of the function
20 0.41536116600037 Before getting categories Query to get specific category list
21 0.41578102111816 After getting categories Query to get specific category list
22 0.41578197479248 Before getting category custom Before call to function getCategoryCustom
23 0.42129302024841 After getting category custom After call to function getCategoryCustom
24 0.42129516601562 Before getting category custom Before call to function getCategoryCustom
25 0.4318311214447 After getting category custom After call to function getCategoryCustom
26 0.43183302879333 End of GetCategoryList function End of the function
27 0.43183898925781 Get Category List for Group Before the call to getCategoryList function
28 0.43184208869934 Start of GetCategoryList function Start of the function
29 0.43184399604797 Before getting categories Query to get specific category list
30 0.43253207206726 After getting categories Query to get specific category list
31 0.43253302574158 Before getting category custom Before call to function getCategoryCustom
32 0.44167613983154 After getting category custom After call to function getCategoryCustom
33 0.44167900085449 Before getting category custom Before call to function getCategoryCustom
34 0.4590539932251 After getting category custom After call to function getCategoryCustom
35 0.45905613899231 Before getting category custom Before call to function getCategoryCustom
36 0.46489906311035 After getting category custom After call to function getCategoryCustom
37 0.46490097045898 Before getting category custom Before call to function getCategoryCustom
38 0.47075605392456 After getting category custom After call to function getCategoryCustom
39 0.47075796127319 Before getting category custom Before call to function getCategoryCustom
40 0.47693300247192 After getting category custom After call to function getCategoryCustom
41 0.47693610191345 Before getting category custom Before call to function getCategoryCustom
42 0.4983971118927 After getting category custom After call to function getCategoryCustom
43 0.49839997291565 Before getting category custom Before call to function getCategoryCustom
44 0.50243496894836 After getting category custom After call to function getCategoryCustom
45 0.50243806838989 Before getting category custom Before call to function getCategoryCustom
46 0.5073230266571 After getting category custom After call to function getCategoryCustom
47 0.50732517242432 End of GetCategoryList function End of the function
48 0.5073401927948 Get Category List for Group Before the call to getCategoryList function
49 0.50734210014343 Start of GetCategoryList function Start of the function
50 0.50734496116638 Before getting categories Query to get specific category list
51 0.50776600837708 After getting categories Query to get specific category list
52 0.50776815414429 Before getting category custom Before call to function getCategoryCustom
53 0.51001596450806 After getting category custom After call to function getCategoryCustom
54 0.51001811027527 Before getting category custom Before call to function getCategoryCustom
55 0.51227402687073 After getting category custom After call to function getCategoryCustom
56 0.51227712631226 End of GetCategoryList function End of the function
57 0.51228308677673 Get Category List for Group Before the call to getCategoryList function
58 0.51228499412537 Start of GetCategoryList function Start of the function
59 0.51228809356689 Before getting categories Query to get specific category list
60 0.51260209083557 After getting categories Query to get specific category list
61 0.51260304450989 Before getting category custom Before call to function getCategoryCustom
62 0.51752305030823 After getting category custom After call to function getCategoryCustom
63 0.51752519607544 End of GetCategoryList function End of the function
64 0.51753115653992 End of getCategoryListByGroup Function Before return()
65 0.56900501251221 App Controller End End of the App controller (called before the controller of every page)
66 0.56963515281677 Product Start Start of the product info controller
67 0.57047700881958 Cache file not found Starting get product details
68 0.60677218437195 Related products Start getting related products if enabled
69 0.60677409172058 Related Products Start Before the related products are found
70 0.6067750453949 Related Products Keywords Before the related product keywords are found
71 0.60678195953369 Create Keyword List Function Start of function
72 0.60767507553101 Create Keyword List Function After looping provided content - 577 keywords found
73 0.64535808563232 Create Keyword List Function After looping initial keyword list - 530 keywords remaining
74 0.64549207687378 Create Keyword List Function After reducing keyword list
75 0.64637517929077 Create Keyword List Function After selecting by scoring keywords
76 0.64638113975525 Create Keyword List Function After final loop of keywords
77 0.64638304710388 Related Products Keywords After the related product keywords are found
78 0.91031217575073 Related Products End After the related products are found
79 1.1194260120392 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.2611830234528 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.49702501297 Product End End of the product info controller (Product Info)
82 1.4974081516266 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.4974989891052 Before Get Options Before the call to getOptions in the tpl class
84 1.7089660167694 After Get Options After the call to getOptions in the tpl class
85 1.7091631889343 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.7091760635376 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.0166790485382 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.0166840553284 Product Info: Before Template Display Before the template is displayed
89 2.2325961589813 Product Info: After Template Display After the template is displayed
90 2.2326030731201 Finalizing debug Before the debug is output to the page.
91 2.2326190471649 End of App This is the end of the app logging, final timestamp


Query Debug - 757 Database Queries. Total time 1.1229 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016689300537109
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044083595275879
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00018000602722168
SELECT * FROM `bad_bots`
5 0.0004 0.00044798851013184
SELECT parameter, value FROM parameters
6 0.0002 0.00015902519226074
SET time_zone = 'Europe/London'
7 0.0003 0.00028014183044434
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014400482177734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001060962677002
delete from cachefiles
10 0.0002 0.00024986267089844
SELECT id FROM pages WHERE pagename = 'ka-bar-usmc-fighting-knife-choose-style-combat-knife-tactical-knife-hunting-knife-fixed-blade-knife-folding-blade-knife' LIMIT 1
11 0.0002 0.00023508071899414
SELECT id FROM products WHERE pagename = 'ka-bar-usmc-fighting-knife-choose-style-combat-knife-tactical-knife-hunting-knife-fixed-blade-knife-folding-blade-knife' AND hidden = 0 LIMIT 1
12 0.0008 0.00079894065856934
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0093 0.0093109607696533
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00024795532226562
SELECT * FROM pages WHERE pagename = 'ka-bar-usmc-fighting-knife-choose-style-combat-knife-tactical-knife-hunting-knife-fixed-blade-knife-folding-blade-knife'
15 0.0002 0.0001521110534668
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051689147949219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049519538879395
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00022220611572266
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043201446533203
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0001 0.00014209747314453
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.00015807151794434
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030019283294678
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.00025296211242676
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00019979476928711
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056707859039307
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.00016903877258301
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
35 0.0024 0.0024340152740479
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.00025510787963867
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0024490356445312
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011460781097412
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017790794372559
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.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016593933105469
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.00039505958557129
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022969245910645
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.00024509429931641
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022909641265869
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015020370483398
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.00014400482177734
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0047810077667236
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.00026512145996094
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048010349273682
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.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0001 0.00014591217041016
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.0006258487701416
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041129589080811
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040829181671143
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.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014591217041016
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '10'
73 0.0082 0.0081689357757568
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.0082211494445801
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.00016617774963379
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016093254089355
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024421215057373
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '81'
82 0.0024 0.0024440288543701
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.00014877319335938
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.00014185905456543
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024468898773193
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024559497833252
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.00015091896057129
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.00014495849609375
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022351741790771
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.00025296211242676
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.002791166305542
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.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00015592575073242
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093920230865479
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.00029206275939941
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020098686218262
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.00019598007202148
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '130'
109 0.0100 0.010008096694946
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.00017595291137695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.00154709815979
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.0002589225769043
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015678405761719
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014591217041016
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.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019810199737549
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '89'
123 0.0020 0.0019588470458984
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.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.0003969669342041
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066494941711426
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.00023698806762695
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00067877769470215
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.00014090538024902
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.00014877319335938
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.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00067615509033203
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.0002281665802002
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00070405006408691
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014305114746094
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.0001528263092041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00030112266540527
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019998550415039
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.00023579597473145
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020360946655273
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.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051810741424561
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036191940307617
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.0001671314239502
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014615058898926
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021886825561523
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016283988952637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015711784362793
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.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00023198127746582
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023913383483887
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001518726348877
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.00016903877258301
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013613700866699
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.00013613700866699
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
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.0013880729675293
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00017499923706055
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.00012302398681641
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00028300285339355
SELECT * FROM products WHERE pagename = 'ka-bar-usmc-fighting-knife-choose-style-combat-knife-tactical-knife-hunting-knife-fixed-blade-knife-folding-blade-knife'
376 0.0002 0.00022196769714355
SELECT * FROM manufacturers WHERE id = '468'
377 0.0003 0.00029706954956055
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '468'
378 0.0001 0.00011992454528809
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '468' LIMIT 1
379 0.0002 0.00023293495178223
SELECT pagename, id FROM products p WHERE manufacturer_id = '468' ORDER BY RAND() LIMIT 1
380 0.0003 0.00029397010803223
SELECT * FROM productimages WHERE product_id = '95407' ORDER BY sortorder ASC
381 0.0002 0.00022792816162109
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '468'
382 0.0003 0.00025582313537598
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '468'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00011491775512695
SELECT * FROM manufacturerimages WHERE manufacturer_id = '468'
384 0.0001 0.00013184547424316
SELECT category_id FROM products_categories WHERE product_id = '290360'
385 0.0002 0.00023102760314941
SELECT * FROM categories WHERE id = '50'
386 0.0030 0.0030229091644287
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
387 0.0001 0.00012612342834473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 50
388 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '50'
389 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '96'
390 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '97'
391 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '111'
392 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '129'
393 0.0058 0.0057649612426758
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 
394 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
395 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 (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
396 0.0002 0.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
397 0.0002 0.00016593933105469
SELECT * FROM productimages WHERE product_id = '290360' ORDER BY sortorder ASC
398 0.0002 0.00020694732666016
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '290360' AND p.id = pi.product_id ORDER BY pi.sortorder
399 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '290360'
400 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '290360'
401 0.0001 0.00011110305786133
SELECT * FROM productfeeds WHERE product_id = '290360' ORDER BY item_date DESC
402 0.0004 0.00035715103149414
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '290360' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
403 0.0003 0.00030303001403809
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '290360' AND t.hidden = 0 AND display_product = 1
404 0.0001 0.00014209747314453
SELECT * FROM tags WHERE id = '3066'
405 0.0050 0.0050427913665771
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3066'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
406 0.0049 0.0049340724945068
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3066'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
407 0.0050 0.0050220489501953
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3066' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408 0.0005 0.00045990943908691
SELECT * FROM productimages WHERE product_id = '13317' ORDER BY sortorder ASC
409 0.0005 0.00053000450134277
SELECT * FROM productamazoncontent WHERE product_id = '290360'
410 0.0003 0.00028514862060547
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '290360'
                GROUP BY o.product_id
411 0.0003 0.00025796890258789
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '290360'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
412 0.0002 0.00017786026000977
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 290360
413 0.0028 0.0027561187744141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290360' AND a.name = n.originalname
414 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '290360' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00018095970153809
SELECT * FROM productoffers
                WHERE product_id = '290360' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 290360
                ORDER BY price ASC LIMIT 1
417 0.0003 0.00028204917907715
SELECT value FROM productattributes
                WHERE product_id = '290360'
                AND name = 'ListPriceAmount'
418 0.0002 0.00020480155944824
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '290360'
                GROUP BY o.product_id
419 0.0002 0.00022292137145996
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '290360'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
420 0.0002 0.00016999244689941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 290360
421 0.0001 0.00013089179992676
UPDATE products SET price = '10799' WHERE id = '290360'
422 0.0002 0.0002131462097168
SELECT * FROM products WHERE parent_id = '290360'
423 0.2388 0.23875594139099
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('knife' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('knife' IN BOOLEAN MODE) AND 290360 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
424 0.0004 0.00036406517028809
SELECT * FROM productimages WHERE product_id = '95407' ORDER BY sortorder ASC
425 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '95407'
426 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '95407'
427 0.0020 0.0020051002502441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '95407' AND a.name = n.originalname
428 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '95407' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '95407' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '95407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00013613700866699
UPDATE products SET price = '10010' WHERE id = '95407'
432 0.0002 0.00017619132995605
SELECT * FROM productimages WHERE product_id = '48877' ORDER BY sortorder ASC
433 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '48877'
434 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '48877'
435 0.0028 0.0027639865875244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '48877' AND a.name = n.originalname
436 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '48877' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '48877' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '48877' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00011992454528809
UPDATE products SET price = '1000' WHERE id = '48877'
440 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '97492' ORDER BY sortorder ASC
441 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '97492'
442 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '97492'
443 0.0022 0.0022380352020264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '97492' AND a.name = n.originalname
444 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '97492' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '97492' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0003 0.00031614303588867
SELECT value FROM productattributes WHERE product_id = '97492' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.00011801719665527
UPDATE products SET price = '3299' WHERE id = '97492'
448 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '48259' ORDER BY sortorder ASC
449 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '48259'
450 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '48259'
451 0.0027 0.002744197845459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '48259' AND a.name = n.originalname
452 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '48259' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '48259' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '48259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00012016296386719
UPDATE products SET price = '1206' WHERE id = '48259'
456 0.0002 0.00016999244689941
SELECT * FROM productimages WHERE product_id = '130296' ORDER BY sortorder ASC
457 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '130296'
458 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '130296'
459 0.0028 0.0027568340301514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130296' AND a.name = n.originalname
460 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '130296' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '130296' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '130296' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.0001218318939209
UPDATE products SET price = '2199' WHERE id = '130296'
464 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '183404' ORDER BY sortorder ASC
465 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '183404'
466 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '183404'
467 0.0025 0.0025169849395752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183404' AND a.name = n.originalname
468 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '183404' AND merchantid = 'ATVPDKIKX0DER'
469 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '183404' AND price > 0
                ORDER BY price ASC LIMIT 1
470 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '183404' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
471 0.0001 0.0001220703125
UPDATE products SET price = '3999' WHERE id = '183404'
472 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
473 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
474 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
475 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
476 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
477 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
478 0.0001 0.00013399124145508
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
479 0.2071 0.20707416534424
SELECT * FROM ebay_products_cache WHERE cachekey = 'df2f5de1735ce0036f4d682bf98abcbd' 
480 0.0003 0.00026702880859375
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
481 0.0001 0.00012397766113281
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
482 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
483 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
484 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
485 0.2047 0.20474004745483
SELECT * FROM ebay_products_cache WHERE cachekey = 'df2f5de1735ce0036f4d682bf98abcbd' 
486 0.0003 0.00027585029602051
SELECT id,asin FROM products WHERE parent_id = 290360
487 0.0003 0.0003359317779541
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290360' ORDER BY timestamp DESC
488 0.0001 0.00014710426330566
SELECT category_id FROM products_categories WHERE product_id = '290360'
489 0.0002 0.0002288818359375
SELECT * FROM categories WHERE id = '50'
490 0.0031 0.0030519962310791
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
491 0.0001 0.00012493133544922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 50
492 0.0003 0.00026512145996094
SELECT id FROM categories WHERE parent_id = '50'
493 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '96'
494 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '97'
495 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '111'
496 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '129'
497 0.0057 0.005673885345459
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 
498 0.0002 0.00017189979553223
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 
499 0.0002 0.00016593933105469
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 
500 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
501 0.0028 0.0027878284454346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290360' AND a.name = n.originalname
502 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290360' AND merchantid = 'ATVPDKIKX0DER'
503 0.0002 0.00018715858459473
SELECT * FROM productoffers
                WHERE product_id = '290360' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 290360
                ORDER BY price ASC LIMIT 1
505 0.0003 0.00027203559875488
SELECT value FROM productattributes
                WHERE product_id = '290360'
                AND name = 'ListPriceAmount'
506 0.0002 0.00021481513977051
SELECT * FROM products WHERE id = '290360'
507 0.0002 0.00021100044250488
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '290360'
                GROUP BY o.product_id
508 0.0002 0.00023484230041504
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '290360'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
509 0.0002 0.00017499923706055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 290360
510 0.0001 0.00012898445129395
UPDATE products SET price = '10799' WHERE id = '290360'
511 0.0027 0.0027332305908203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290360' AND a.name = n.originalname
512 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '290360' AND merchantid = 'ATVPDKIKX0DER'
513 0.0002 0.00018095970153809
SELECT * FROM productoffers
                WHERE product_id = '290360' AND price > 0
                ORDER BY price ASC LIMIT 1
514 0.0002 0.00016307830810547
SELECT * FROM productoffers
                WHERE product_id = 290360
                ORDER BY price ASC LIMIT 1
515 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '290360'
                AND name = 'ListPriceAmount'
516 0.0001 0.00013303756713867
SELECT category_id FROM products_categories WHERE product_id = '290360'
517 0.0001 0.00012111663818359
SELECT parent_id FROM categories WHERE id = '50'
518 0.0002 0.00020003318786621
SELECT * FROM categories WHERE id = '50'
519 0.0029 0.0029010772705078
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
520 0.0001 0.00012493133544922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 50
521 0.0002 0.00024509429931641
SELECT id FROM categories WHERE parent_id = '50'
522 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '96'
523 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '97'
524 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '111'
525 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '129'
526 0.0056 0.0055849552154541
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 
527 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
528 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 
529 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
530 0.0002 0.00016999244689941
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
531 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = 2
532 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 4
533 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 12
534 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 10
535 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = 7
536 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = 18
537 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 28
538 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 13
539 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
540 0.0140 0.013998031616211
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
541 0.0002 0.00020813941955566
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:1563416771;s:8:\"products\";a:6:{i:1;s:6:\"407595\";i:4;s:6:\"170197\";i:7;s:6:\"408079\";i:8;s:6:\"404868\";i:9;s:6:\"402058\";i:11;s:6:\"402907\";}}' WHERE id = '175'
542 0.0004 0.00043392181396484
SELECT * FROM products WHERE id IN (407595,170197,408079,404868,402058,402907) ORDER BY FIELD(id, 407595,170197,408079,404868,402058,402907 )
543 0.0002 0.00024294853210449
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
544 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '407595'
545 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '407595'
546 0.0034 0.0033860206604004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
547 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
548 0.0003 0.00025415420532227
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
549 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
550 0.0001 0.0001220703125
UPDATE products SET price = '2497' WHERE id = '407595'
551 0.0007 0.00069189071655273
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
552 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '170197'
553 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '170197'
554 0.0032 0.0032150745391846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
555 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
556 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
557 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
558 0.0001 0.00011801719665527
UPDATE products SET price = '324500' WHERE id = '170197'
559 0.0002 0.00017380714416504
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
560 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '408079'
561 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '408079'
562 0.0026 0.0026159286499023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
563 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
564 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
565 0.0004 0.00035881996154785
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
566 0.0001 0.00011992454528809
UPDATE products SET price = '26458' WHERE id = '408079'
567 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
568 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '404868'
569 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '404868'
570 0.0030 0.0029811859130859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
571 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
572 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
573 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
574 0.0001 0.00011897087097168
UPDATE products SET price = '46999' WHERE id = '404868'
575 0.0003 0.00027990341186523
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
576 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402058'
577 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '402058'
578 0.0028 0.0028071403503418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
579 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
580 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
581 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
582 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '402058'
583 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
584 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '402907'
585 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '402907'
586 0.0030 0.0030050277709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
587 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
588 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
589 0.0003 0.00034189224243164
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
590 0.0001 0.00011587142944336
UPDATE products SET price = '9400' WHERE id = '402907'
591 0.0138 0.013784170150757
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
592 0.0002 0.00021004676818848
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:1563416771;s:8:\"products\";a:6:{i:1;s:6:\"407595\";i:3;s:6:\"290575\";i:4;s:6:\"170197\";i:8;s:6:\"404868\";i:12;s:6:\"410951\";i:0;s:6:\"398858\";}}' WHERE id = '177'
593 0.0004 0.00043106079101562
SELECT * FROM products WHERE id IN (407595,290575,170197,404868,410951,398858) ORDER BY FIELD(id, 407595,290575,170197,404868,410951,398858 )
594 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
595 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407595'
596 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407595'
597 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
598 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
599 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
600 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
601 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
602 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
603 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '290575'
604 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '290575'
605 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
606 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
607 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
608 0.0004 0.00042819976806641
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
609 0.0001 0.00011682510375977
UPDATE products SET price = '549500' WHERE id = '290575'
610 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
611 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '170197'
612 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '170197'
613 0.0032 0.0032298564910889
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
614 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
615 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
616 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
617 0.0001 0.00011706352233887
UPDATE products SET price = '324500' WHERE id = '170197'
618 0.0003 0.00028610229492188
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
619 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '404868'
620 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404868'
621 0.0030 0.002985954284668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
622 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
623 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
624 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
625 0.0001 0.00011992454528809
UPDATE products SET price = '46999' WHERE id = '404868'
626 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
627 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '410951'
628 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '410951'
629 0.0021 0.0020840167999268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
630 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
631 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
632 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
633 0.0001 0.00011897087097168
UPDATE products SET price = '94700' WHERE id = '410951'
634 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
635 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '398858'
636 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '398858'
637 0.0030 0.0030269622802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
638 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
639 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
640 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
641 0.0001 0.00011801719665527
UPDATE products SET price = '2999' WHERE id = '398858'
642 0.0286 0.028630971908569
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
643 0.0002 0.00021505355834961
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:1563416771;s:8:\"products\";a:6:{i:2;s:6:\"415083\";i:4;s:6:\"170197\";i:6;s:6:\"127345\";i:10;s:6:\"258602\";i:13;s:6:\"411183\";i:23;s:6:\"398316\";}}' WHERE id = '181'
644 0.0007 0.0006871223449707
SELECT * FROM products WHERE id IN (415083,170197,127345,258602,411183,398316) ORDER BY FIELD(id, 415083,170197,127345,258602,411183,398316 )
645 0.0002 0.00018215179443359
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
646 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '415083'
647 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '415083'
648 0.0035 0.0034520626068115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
649 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
650 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
651 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
652 0.0002 0.00024604797363281
UPDATE products SET price = '2299' WHERE id = '415083'
653 0.0007 0.00066614151000977
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
654 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '170197'
655 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '170197'
656 0.0032 0.0032269954681396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
657 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
658 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
659 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
660 0.0001 0.00011897087097168
UPDATE products SET price = '324500' WHERE id = '170197'
661 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
662 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '127345'
663 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '127345'
664 0.0026 0.0026378631591797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
665 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
666 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
667 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
668 0.0001 0.00011587142944336
UPDATE products SET price = '19286' WHERE id = '127345'
669 0.0003 0.00032186508178711
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
670 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '258602'
671 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '258602'
672 0.0031 0.0030989646911621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
673 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
674 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
675 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
676 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '258602'
677 0.0004 0.00039815902709961
SELECT * FROM productimages WHERE product_id = '411183' ORDER BY sortorder ASC
678 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '411183'
679 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '411183'
680 0.0025 0.0024709701538086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411183' AND a.name = n.originalname
681 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '411183' AND merchantid = 'ATVPDKIKX0DER'
682 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '411183' AND price > 0
                ORDER BY price ASC LIMIT 1
683 0.0004 0.00035405158996582
SELECT value FROM productattributes WHERE product_id = '411183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
684 0.0001 0.00012516975402832
UPDATE products SET price = '16999' WHERE id = '411183'
685 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '398316' ORDER BY sortorder ASC
686 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398316'
687 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '398316'
688 0.0031 0.0031278133392334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398316' AND a.name = n.originalname
689 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '398316' AND merchantid = 'ATVPDKIKX0DER'
690 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '398316' AND price > 0
                ORDER BY price ASC LIMIT 1
691 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '398316' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
692 0.0001 0.00011682510375977
UPDATE products SET price = '4999' WHERE id = '398316'
693 0.0284 0.028423070907593
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
694 0.0002 0.00021696090698242
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:1563416772;s:8:\"products\";a:6:{i:2;s:6:\"415083\";i:3;s:6:\"290575\";i:9;s:6:\"402058\";i:12;s:6:\"410951\";i:17;s:6:\"406156\";i:18;s:6:\"406078\";}}' WHERE id = '183'
695 0.0007 0.00069594383239746
SELECT * FROM products WHERE id IN (415083,290575,402058,410951,406156,406078) ORDER BY FIELD(id, 415083,290575,402058,410951,406156,406078 )
696 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
697 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '415083'
698 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '415083'
699 0.0035 0.0034911632537842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
700 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
701 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
702 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
703 0.0002 0.00024819374084473
UPDATE products SET price = '2299' WHERE id = '415083'
704 0.0006 0.0005800724029541
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
705 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '290575'
706 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '290575'
707 0.0034 0.0034198760986328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
708 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
709 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
710 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
711 0.0001 0.00011801719665527
UPDATE products SET price = '549500' WHERE id = '290575'
712 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
713 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402058'
714 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402058'
715 0.0028 0.0028090476989746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
716 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
717 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
718 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
719 0.0001 0.00011801719665527
UPDATE products SET price = '19900' WHERE id = '402058'
720 0.0003 0.00025391578674316
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
721 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '410951'
722 0.0001 0.00011777877807617
SELECT * FROM productcustomimages WHERE product_id = '410951'
723 0.0021 0.0020828247070312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
724 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
725 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
726 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
727 0.0001 0.00011610984802246
UPDATE products SET price = '94700' WHERE id = '410951'
728 0.0002 0.00016212463378906
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
729 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '406156'
730 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '406156'
731 0.0032 0.0032429695129395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
732 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
733 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
734 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
735 0.0001 0.00012111663818359
UPDATE products SET price = '1015' WHERE id = '406156'
736 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '406078' ORDER BY sortorder ASC
737 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406078'
738 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '406078'
739 0.0028 0.0027761459350586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406078' AND a.name = n.originalname
740 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '406078' AND merchantid = 'ATVPDKIKX0DER'
741 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '406078' AND price > 0
                ORDER BY price ASC LIMIT 1
742 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '406078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
743 0.0001 0.00011682510375977
UPDATE products SET price = '998' WHERE id = '406078'
744 0.0004 0.00039386749267578
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
745 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
746 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
747 0.0001 0.00012779235839844
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
748 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
749 0.0004 0.00038981437683105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
750 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
751 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
752 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
753 0.0009 0.00094008445739746
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
754 0.0003 0.00031709671020508
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
755 0.0003 0.00027990341186523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
756 0.0004 0.00042605400085449
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
757 0.0003 0.0003361701965332
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'