Tactical Equipment - Survivalist Equipment

Combat Knife :: Tactical Knife :: Hunting Knife :: Fixed Blade Knife :: Folding Blade Knife Blade

Best Combat Knives

Basic Combat Knife fighting Technique

UPDATED :  

Tactical knives for sale online: How well a combat knife performs is largely to do with the technique employed by the user, given that the right tool for the job has been selected in the first place. Athletes, particularly field event exponents performing with implements, learn the value of a good technique very early in the piece - essential for mastering combat knife fighting techniques.

Extra heights and distances come with lots of practice using the proper technique in doing things. Big, muscle-bound athletes don't necessarily win explosive power events, for example, javelin throwing, where maximum running speed is striven for without losing control of the throwing action. Technique is the special ingredient that enables a fast-moving field athlete to transform the energy generated into a final mighty effort.

How threatening knives are in the hands of assailants depends upon their state of mind, level of desperation and ability to use what they've transformed into a weapon - given that the intended purpose of most knives is for use as a tool. How well any tool serves its user is determined by the technique known to and applied by the user, either with passive or not-so-passive intentions. Choosing the best combat knife for personal defense must always encompass the users ability - otherwise you can become a danger to yourself!



Lots of people struggle to efficiently employ uniquely styled bladeware, when you buy a tactical knife, there are so many to choose from - folding tactical knives, fixed blade knives, to gurkas, kukris, parangs, goloks for example - until they've learned the using-technique peculiar to that style of knife. All knives have a right and not-so-right technique of usage. Oh, you can cut with them, but how much better might you cut when you get the knack of using them properly? When you are ready to buy a tactical knife online, you should consider that choosing a combat knife shouldn't be based on price alone, it's specific use, and your capabilities must be taken into consideration. Part of proper knife usage involves maintaining the edge in sharp order, that is, the correct sharpening technique (there's that word technique again!).

Sharpening methods are not the province of this article; suffice to say there are various ways of achieving shaving-sharpness on all manner of bladeware - from your quality tactical folding knife, to little folders to big bush blades including the fixed blade combat knife. Too many people discard perfectly good knives because they've not learned how to efficiently cut with them or how to properly sharpen the edges


Combat Knife : : Tactical Knife Sharpening Tips

KA-BAR D2 Camillus Combat Knife

DESPITE THE multitude of gadgets available to sharpen your knives, try an oilstone in a wooden half-box, clamped in a vice and lubricated with WD40 to stop clogging.

OK, you buy a combat knife, then what? Most new combat knives come with a shop ground short edge and shoulder. This shoulder should be removed using the coarse side of the stone so that its edge merges with the whole blade. Next, using the fine side of the stone, proceed to finish this work on each side of the combat knife by holding the blade almost flat on the stone and at an angle of about 45 degrees from the vertical. Each side should be stroked in one direction only, with the sharp edge leading, alternating sides until the ground areas reach the very edge of the blade.

To test the knife, gently draw the edge over your thumbnail. Parts of the edge that are completed will drag, and the parts that are not yet fully sharp will slide over the nail. The final result is a series of microscopic teeth on the edge. These eventually tend to fold over to some degree.

To restore sharpness stroke each side of the blade on a fine steel to stand them back up. No metal needs to be removed until the minute teeth break or flatten.


A real knife attack is likely to look like this...

Having the best tactical knife isn't a guaranteed win


DPx Gear HEAT/F Grey Back Up Knife

DPx Gear Heat/F folding knife

The DPX HEAT Is a small knife that thinks It's a big knife. It's fun to watch It get into big knife trouble and watch all the big knife guys snicker... until that little guy goes all Rocky Balboa and drops the champ on the canvas.

Yeah, the HEAT punches way above its weight. With 0.18 Inches of black PVD coated and stonewashed Elmax steel, we're surprised the little guy doesn't think It's a crowbar.

This 2.26-Inch, titanium frame locking underdog might be scarce, but if you live in a place that outlaws Digger species, you might want to track one down.


Zero Tolerance 0095BW

New Zero Tolerance 0095BW Folding Knife

The Zero Tolerance 0095BW offers a dramatic look and top performance. The 3.6-inch, harpoon-style blade is made of ultra-durable S35VN steel with a BlackWash finish to give the knife a sleek, A unified look and to hide hard-use scratches.

The blade is paired with a titanium handle with wide, contoured chamfers to provide a secure, comfortable grip. Zero Tolerance's KVT ball-bearing system lets you open the knife quickly, and a titanium frame lock with a hardened lock-bar insert holds the blade open during use.


HAA'S NEW BIG FIXED BLADE BFK-01 GEN II Knife

BFK01 GEN2 For Sale

HHA's next evolution of their fixed blades, the BFK-01 GEN II is the biggest and toughest HHA blade ever. Every part of HHA's futuristic BFK design has been redeveloped from the ground up to bring you a true multi-purpose blade capable of coping with the most extreme duties in the most severe environments.

Whether you're a tactical operator, soldier, hunter, bushman or just need a super tough 'all purpose' knife, the BFK-01 GEN II should be high on your wish list. It can chop, saw, slash, dig, baton, smash, stab, pry, skin and spear - making it more of an all round 'tool' than just a fixed blade.

The 172mm long, 41mm wide modified Tanto point blade is made from HHA's trademark D2 steel with a Teflon coating, comes with its own sheath and is available in Black or Desert.


Black Bird Noir

OKC Black Bird SK-5 Noir

ONTARIO KNIFE COMPANY

Although the Black Bird SK-5 from Ontario Knife Company has been a favorite with knife users since its debut in 2011, OKC received feedback from U.S. military troops and law enforcement members requesting a version to fit their special needs.

In response to these requests, the Black Bird SK-5 Noir was born. Designed by survivalist Paul Scheiter, the Black Bird SK-5 Noir was built as a stripped-down survival knife with only the essential features—a 5-inch blade with a center point and a full, flat grind.

At 10 inches overall, the 0.13-inch thick stainless steel 154CM blade isstrong enough to meet the challenges of bushcraft, survival, hunting and tactical situations.

The new Noir version sports a durable black epoxy powder coat. "In direct response to feedback from military and law enforcement users, we are now introducing the Noir variant of the Black Bird SK-5 Knife," says Scheiter.

"It's identical in all dimensions, materials and functionality to the original blade, but is differentiated by a non-reflective powdercoat finish. This gives the knife a more stealthy capability geared specifically to the needs of tactical operators."

The Black Bird SK-5 Noir is outfitted with a dark Micarta handle to ensure durability and a solid grip regardless of the conditions. A new MOLLE-compatible tactical black sheath offers the same reliability and function as its companion. The sheath also allows the wearer the ability to use an integrated belt loop for a more traditional carry.


Buck's Compadres

Buck Knives Compadre Series

Buck Knives has expanded its line of knives with the brand new Compadre Series consisting of a camp knife, hatchet and chopping froe. All Compadre components feature unique red powder-coat blades and Heritage Walnut Dymondwood handles.

The Compadre camp knife was designed and engineered with the outdoor enthusiast in mind. Features include full-tang construction and a heavy-duty, stylish Heritage Walnut Dymondwood handle for easy carry.

A red powder-coat finish adds style and resistance to corrosion. The blade's constructed of 5160 steel, and measures in at a little more than 9 inches.


High-Status Blades

Elite tactical folders

ELITETACTICAL FOLDERSTHAT WILL MAKE EVERYONE JEALOUS

BY STEVEN DICK

I was sitting at a SHOT Show press room table with a couple of other magazine editors a few years ago when one of them held up his wrist to show me the watch he was wearing.

It was obviously one of those common, inexpensive, digital models—much the same as what I had on at the time. His comment, though, kind of caught me by surprise: "I can see your publisher doesn't pay you any better than mine does me!"

Up until that point, it had never really occurred to me that people in my profession were passing judgment on my status based on the watch I wore.

While I knew the gold standard for "successful in your field" was a Rolex watch prominently displayed on your wrist, the honest truth was that the writing business really doesn't produce much opportunity to own one of these luxury Swiss timepieces.

Eventually, I settled on a Ball Hydrocarbon. You might say wearing the watch to an industry trade show was an experiment, but I was soon surprised at how many people were asking, "Is that a Ball you have on?" So what do watches have to do with tactical folders?

Once you gain entry to the world of indulgent timepieces, you quickly notice another obvious fact: The same people wearing those high-end Swiss watches take their tactical folders just as seriously.

Now, the conventional wisdom is that custom tactical folders are bought by people that think of them as an investment and would never actually use them. I'm here to tell you that is not necessarily true.

A well-worn, high-end tactical folder can be just another way of saying "I've made it. Have you?" My personal example of this is the Bob Terzuola folder I have carried for almost three decades on at least four continents.

There are some that feel Bob actually invented the tactical category of folders. His knives are often plain but elegantly functional at the same time.

I first decided I needed one after seeing how many of my ex-Ranger brothers that had moved on to other "agencies" carried a Terzuola.

Bob's following has exploded since the early '90s, and today you need to have your name drawn out of a box at a show for just the chance of purchasing a $1,000-plus folder from the maker.

That doesn't mean you can expect to see mine being retired anytime soon. Given that there are dozens of potential knife choices these days, I'm setting a few rules for the folders included in this feature. First, the maker needs to be well known and have a following.

Second, the minimum blade length is 3 inches. I feel anything under that is too small for heavy use or self-defense. Third, the blade steel should be a modern, high-performance alloy.

Fourth, while the handles may be top tier, they should still be functional. The scars a working tool picks up have a beauty all their own and are more impressive to the educated eye than pure bling.


Benchmade 781 ANTHEM

Benchmade 781 Anthem

Practically any Benchmade model carries a fair amount of status among knowledgeable knife users, but the new Anthem is a little more special than most.

The handle frame is made from a single billet of titanium, with the company's patented Axis lock securing the blade open. Its 3.5-inch blade is made from CPM- 20CV.

This is an extremely high carbon (1.9 percent) and high chromium (20 percent) steel that offers both great edge retention and superior resistance to corrosion.

Dual opening pegs allow ambidextrous use, and the carry clip can be reversed for right- or left-hand tip-up carry. I especially like the flat profile of the handle frame and its light 3.66-ounce weight (benchmade.com)


JAKE HOBACK KWAIBACK

Jake Hoback Kwaiback folder knife

The original Japanese Kwaiback seems to have been a smaller version of the tanto dagger and was used mostly for concealed carry.

Hoback has taken the basic concept and turned it into a very heavy-duty tactical folder. The katana-style CPM-20CV stainless blade is 3.75 inches long and 0.188 inches thick.

There are a number of handle frame options offered, but the knife shown here is a combination of carbon fiber and titanium with a reversible tip-up carry clip.

The blade is opened by means of a spin-mounted flipper and held in that position with a massive frame-lock bar. Few tactical folders can match this one for pure strength, (jakehobackknives.com)


RICK HINDERER MP-1

RICK HINDERER MP-1 folder knife

Given Rick Hinderer's background as a firefighter, EMT and rescue diver, it probably shouldn't come as a surprise that his folders are built with an extra margin of strength.

The MP-1 (Modular Platform) is an excellent example of this design philosophy. The 3.5-inch blade is made of 0.165-inch-thick S35VN steel mounted on a titanium and G10 handle frame.

If you really must pry with your folder, the MP-1's unique heavy drop point should be ideal for you. The knife is se t up for tip-down, right-hand carry and weighs 5.6 ounces, (rickhindererknives.com)


SPARTAN KRANOS

SPARTAN KRANOS folding knife

Spartan Blades h a s the distinction of being run by a couple of retired Special Forces NCOs who have truly been there and done that several times over.

Their designs reflect that combined battlefield experience at a level few cutlery companies can ever approach. When the Kranos tactical folder was awarded "American Made Knife of the Year" for 2017, it wasn't a surprise.

The 3.37-inch blade is ground from S35VN stainless and is mounted on a titanium frame with G10 scales. The blade is opened by means of a spine-mounted flipper, and a Special-Forces-inspired clip provides tip-up, right-hand carry. The Kranos weighs 4.3 ounces, (spartanbladesusa.com)


TRUE NORTH ELISHEWITZ STRYKER REDUX

True North Elishewitz Stryker Redux knife

Over the years, there have been many versions of the Elishewitz Stryker in both factory and custom offerings. This includes a Benchmade military-issued auto that has been carried by thousands of troops in Afghanistan and Iraq.

True North Knives' exclusive version is certainly a Rolex-level interpretation of this classic. The 3.85-inch blade is made of CTX-XHP, a high carbon (1.6 percent), medium chromium (16 percent) alloy. The titanium handle has an Elishewitz trademark bolster. The knife weighs 5.5 ounces, (truenorthknives.com)


TRUE NORTH/CHRIS REEVE INKOSI

True North Chris Reeve Inkosi folding knife

Many would probably put the Chris Reeve family of folders at the top of the list when it comes to status-symbol tactical knives.

Adding True North Knives' special touches to the Inkosi only makes it more noticeable among the knowledgeable collectors out there. The 3.56-inch blade is ground from S35VN stainless and mounted on a titanium handle frame with Micarta inserts.

The blade can be opened from either side by ambidextrous thumb studs and is held there by the solid frame lock that was basically invented by Chris Reeve. This knife weighs only 4.8 ounces, (truenorthknives.com)


A.G. RUSSELL GENT'S HUNTER II

A. G. Russell Gents Hunter II knife

I normally wouldn't give a runner-up to the aforementioned status-symbol tactical folders, but A.G. Russell's new Gent's Hunter II is one model that deserves to be the exception to that rule.

A.G. is a living legend in cutlery circles, and this particular knife is one of his extremely well-thought-out designs. You can start with the handle-to-blade-length ratio.

The standard rule is that the blade will be an inch shorter than the handle frame. If the blade is longer than that, it's considered a plus; shorter, a negative.

To that end, the Gent's Hunter II has a 4.38-inch handle frame with a 3.63-inch 9Cr13CoMoV blade. A.G. also designed the 1-inch-wide blade to sit as low as possible in the 0.88-inch-wide handle frame.

Handle scales are available in carbon fiber, cocobolo and green G10, all with a reversible pocket clip. And all of the handle scales are contoured for added comfort.

STANDING OUT : One of the unusual design features of the Gent's Hunter II is its lack of thumb pegs, an opening hole or a spine flipper.

There are dual thumb nicks on the blade for conventional two-handed opening, but the way A.G. personally opens the knife is with a snap of the wrist.

The butter-smooth fit and finish of the knife makes this incredibly easy. It also uses a traditional rocker-bar lock rather than the more common frame or liner lock.

In keeping with the "gent's" factor in this design, the pocket clip is set for very low, discreet carry. With the exception of the extreme top of the clip, the knife will be virtually concealed by your clothing at all times.

While I would still not recommend carrying this knife in New York City, it should be ideal for everyday carry in most parts of the country.

The MSRP for the carbon-fiber model is $145 with the other handle options running from $85. (agrussell.com) —Steven Dick

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7108340263367 943 0.8439 0


No Amazon API Requests Made.


App Debug - Total Time 1.7108340263367 seconds

Number Time From Start Name Description
1 0.42596411705017 Initialise Initialise FSB Function
2 0.44266104698181 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50906801223755 App Controller End End of the App controller (called before the controller of every page)
4 0.50921607017517 Category Start Start of the category controller
5 0.50922012329102 Before Get Category Before getting the category information
6 0.53186202049255 After Get Category After getting the category information
7 0.53186416625977 Before Get Category List Before getting the updated category list
8 0.53201508522034 Start of getCategoryListByGroup Function Before first category groups query
9 0.53219294548035 After initial query Before first category groups query
10 0.53219509124756 Get Category List for Group Before the call to getCategoryList function
11 0.5321991443634 Start of GetCategoryList function Start of the function
12 0.53220295906067 Before getting categories Query to get specific category list
13 0.53286695480347 After getting categories Query to get specific category list
14 0.53286910057068 Before getting category custom Before call to function getCategoryCustom
15 0.53482294082642 After getting category custom After call to function getCategoryCustom
16 0.53482699394226 Before getting category custom Before call to function getCategoryCustom
17 0.54562401771545 After getting category custom After call to function getCategoryCustom
18 0.5456280708313 Before getting sub category list Before call to recursive function getCategoryList
19 0.54562997817993 Start of GetCategoryList function Start of the function
20 0.54563307762146 Before getting categories Query to get specific category list
21 0.54609608650208 After getting categories Query to get specific category list
22 0.54609704017639 Before getting category custom Before call to function getCategoryCustom
23 0.54944109916687 After getting category custom After call to function getCategoryCustom
24 0.5494430065155 Before getting sub category list Before call to recursive function getCategoryList
25 0.54944396018982 Start of GetCategoryList function Start of the function
26 0.54944705963135 Before getting categories Query to get specific category list
27 0.5497670173645 After getting sub category list After call to recursive function getCategoryList
28 0.54976916313171 Before getting category custom Before call to function getCategoryCustom
29 0.55268311500549 After getting category custom After call to function getCategoryCustom
30 0.55268406867981 Before getting sub category list Before call to recursive function getCategoryList
31 0.55268597602844 Start of GetCategoryList function Start of the function
32 0.55268907546997 Before getting categories Query to get specific category list
33 0.55301094055176 After getting sub category list After call to recursive function getCategoryList
34 0.55301403999329 Before getting category custom Before call to function getCategoryCustom
35 0.55534815788269 After getting category custom After call to function getCategoryCustom
36 0.55534911155701 Before getting sub category list Before call to recursive function getCategoryList
37 0.55535101890564 Start of GetCategoryList function Start of the function
38 0.55535411834717 Before getting categories Query to get specific category list
39 0.55566215515137 After getting sub category list After call to recursive function getCategoryList
40 0.5556640625 Before getting category custom Before call to function getCategoryCustom
41 0.55798816680908 After getting category custom After call to function getCategoryCustom
42 0.5579891204834 Before getting sub category list Before call to recursive function getCategoryList
43 0.55799102783203 Start of GetCategoryList function Start of the function
44 0.55799412727356 Before getting categories Query to get specific category list
45 0.55830311775208 After getting sub category list After call to recursive function getCategoryList
46 0.55830502510071 End of GetCategoryList function End of the function
47 0.5583131313324 After getting sub category list After call to recursive function getCategoryList
48 0.55831408500671 Before getting category custom Before call to function getCategoryCustom
49 0.56450200080872 After getting category custom After call to function getCategoryCustom
50 0.56450510025024 Before getting category custom Before call to function getCategoryCustom
51 0.56880497932434 After getting category custom After call to function getCategoryCustom
52 0.56880807876587 End of GetCategoryList function End of the function
53 0.56881713867188 Get Category List for Group Before the call to getCategoryList function
54 0.56881999969482 Start of GetCategoryList function Start of the function
55 0.56882309913635 Before getting categories Query to get specific category list
56 0.56929707527161 After getting categories Query to get specific category list
57 0.56929898262024 Before getting category custom Before call to function getCategoryCustom
58 0.57510900497437 After getting category custom After call to function getCategoryCustom
59 0.57511305809021 Before getting category custom Before call to function getCategoryCustom
60 0.58611798286438 After getting category custom After call to function getCategoryCustom
61 0.58612108230591 End of GetCategoryList function End of the function
62 0.5861279964447 Get Category List for Group Before the call to getCategoryList function
63 0.58613109588623 Start of GetCategoryList function Start of the function
64 0.58613395690918 Before getting categories Query to get specific category list
65 0.5870361328125 After getting categories Query to get specific category list
66 0.58704304695129 Before getting category custom Before call to function getCategoryCustom
67 0.59669709205627 After getting category custom After call to function getCategoryCustom
68 0.59670114517212 Before getting category custom Before call to function getCategoryCustom
69 0.61504101753235 After getting category custom After call to function getCategoryCustom
70 0.61504411697388 Before getting category custom Before call to function getCategoryCustom
71 0.62120008468628 After getting category custom After call to function getCategoryCustom
72 0.62120413780212 Before getting category custom Before call to function getCategoryCustom
73 0.62732005119324 After getting category custom After call to function getCategoryCustom
74 0.62732410430908 Before getting category custom Before call to function getCategoryCustom
75 0.63385796546936 After getting category custom After call to function getCategoryCustom
76 0.63386106491089 Before getting category custom Before call to function getCategoryCustom
77 0.65641617774963 After getting category custom After call to function getCategoryCustom
78 0.65641903877258 Before getting category custom Before call to function getCategoryCustom
79 0.66073513031006 After getting category custom After call to function getCategoryCustom
80 0.66073799133301 Before getting category custom Before call to function getCategoryCustom
81 0.66626214981079 After getting category custom After call to function getCategoryCustom
82 0.66626501083374 End of GetCategoryList function End of the function
83 0.66627907752991 Get Category List for Group Before the call to getCategoryList function
84 0.66628217697144 Start of GetCategoryList function Start of the function
85 0.66628503799438 Before getting categories Query to get specific category list
86 0.66674900054932 After getting categories Query to get specific category list
87 0.66675114631653 Before getting category custom Before call to function getCategoryCustom
88 0.66917514801025 After getting category custom After call to function getCategoryCustom
89 0.6691780090332 Before getting category custom Before call to function getCategoryCustom
90 0.67162013053894 After getting category custom After call to function getCategoryCustom
91 0.67162299156189 End of GetCategoryList function End of the function
92 0.67163014411926 Get Category List for Group Before the call to getCategoryList function
93 0.67163300514221 Start of GetCategoryList function Start of the function
94 0.67163610458374 Before getting categories Query to get specific category list
95 0.67198514938354 After getting categories Query to get specific category list
96 0.67198610305786 Before getting category custom Before call to function getCategoryCustom
97 0.67713904380798 After getting category custom After call to function getCategoryCustom
98 0.67714214324951 End of GetCategoryList function End of the function
99 0.67714905738831 End of getCategoryListByGroup Function Before return()
100 0.67715406417847 After Get Category List After getting the updated category list
101 0.67715501785278 Before Category Images Before getting the category images
102 0.67728996276855 After Category Images After getting the category images
103 0.67770195007324 Before Sub Category Check Before checking for sub category or products category
104 0.68124413490295 Before Category Products Controller Before loading the category products controller
105 0.68141198158264 Start Category Products Start of Category Products Controller
106 0.68143796920776 After Pagination Options After pagination options in Category Products Controller
107 0.68189001083374 After Cache After Cache checking in Category Products Controller
108 0.76459097862244 After Filter Options After getting filter options and SQL in Category Products Controller
109 0.76822400093079 After Counting Products After counting products in the Category Products Controller
110 0.76840901374817 After Counting Bundles After counting bundles in the Category Products Controller
111 0.76858305931091 After Counting Products After counting products in the Category Products Controller
112 0.77415800094604 After Getting Products After getting products and bundles in the Category Products Controller
113 0.77424716949463 After Pagination Links After getting pagination listing links in the Category Products Controller
114 0.77424907684326 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
115 0.88379001617432 After Getting Product Details After getting full product details in the Category Products Controller
116 0.88879609107971 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
117 0.89015507698059 App_after Controller Start Start of the App_after controller (called after the controller of every page)
118 0.89023399353027 Before Get Options Before the call to getOptions in the tpl class
119 1.3156461715698 After Get Options After the call to getOptions in the tpl class
120 1.3159811496735 App_after Controller End End of the App_after controller (called after the controller of every page)
121 1.3159940242767 Before Smarty Before passing everything over to Smarty in the Category Products Controller
122 1.7108130455017 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
123 1.7108161449432 Finalizing debug Before the debug is output to the page.
124 1.710832118988 End of App This is the end of the app logging, final timestamp


Query Debug - 943 Database Queries. Total time 0.8439 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016188621520996
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00047087669372559
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015997886657715
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017118453979492
SELECT * FROM `bad_bots`
5 0.0004 0.0004420280456543
SELECT parameter, value FROM parameters
6 0.0001 0.00014805793762207
SET time_zone = 'Europe/London'
7 0.0004 0.00037717819213867
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016498565673828
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00020003318786621
delete from cachefiles
10 0.0003 0.00026416778564453
SELECT id FROM pages WHERE pagename = 'combat-knife' LIMIT 1
11 0.0002 0.00022697448730469
SELECT id FROM products WHERE pagename = 'combat-knife' AND hidden = 0 LIMIT 1
12 0.0001 0.0001220703125
SELECT id FROM ebay_products WHERE pagename = 'combat-knife'
13 0.0002 0.00016999244689941
SELECT id FROM categories WHERE pagename = 'combat-knife' LIMIT 1
14 0.0009 0.00087213516235352
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0094 0.0093700885772705
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0003 0.00025606155395508
SELECT * FROM pages WHERE pagename = 'combat-knife'
17 0.0052 0.0051651000976562
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00039505958557129
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.00017189979553223
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00016689300537109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '84'
24 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.0002448558807373
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '357'
33 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '379'
34 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '401'
35 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '450'
36 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.00017118453979492
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '43'
42 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '44'
43 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00021910667419434
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '107'
48 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '108'
49 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '133'
51 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '217'
53 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '228'
54 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '271'
56 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '286'
57 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '364'
64 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '369'
66 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00018215179443359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0003 0.00027585029602051
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '90'
72 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '414'
73 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '119'
74 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '406'
75 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '149'
76 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '150'
77 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '162'
79 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '164'
80 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '167'
81 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '180'
82 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '268'
85 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '411'
86 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '290'
87 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '413'
88 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '409'
89 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '327'
90 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '351'
92 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '370'
97 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '386'
99 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '408'
100 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '428'
106 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '432'
107 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '433'
108 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '436'
109 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '437'
110 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '464'
112 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '74'
114 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '145'
116 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '156'
117 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '407'
118 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.0002291202545166
SELECT * FROM pages WHERE id = '316'
121 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '334'
123 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '367'
124 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '387'
125 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00017809867858887
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '42'
130 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '86'
132 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '95'
133 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '102'
134 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00024008750915527
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '62'
140 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '317'
146 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '343'
148 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '349'
153 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '393'
156 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '394'
157 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '421'
160 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '426'
161 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '430'
162 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '441'
167 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '451'
168 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '453'
169 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '146'
171 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '158'
172 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.00023412704467773
SELECT * FROM pages WHERE id = '293'
174 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '417'
176 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '181'
179 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '299'
181 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '300'
182 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '385'
184 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '442'
186 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0003 0.00025510787963867
SELECT * FROM pages WHERE id = '103'
188 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = '134'
189 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '248'
193 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.00021910667419434
SELECT * FROM pages WHERE id = '115'
200 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '151'
203 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '200'
205 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '304'
206 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '321'
207 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '350'
209 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '378'
210 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '425'
212 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '443'
213 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '444'
214 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '445'
215 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '446'
216 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '447'
217 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '448'
218 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '455'
219 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '456'
220 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '460'
222 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '462'
223 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '182'
226 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '238'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '240'
228 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '242'
229 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '252'
230 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '253'
231 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '262'
232 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '267'
233 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '420'
234 0.0002 0.00017118453979492
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0015 0.0014779567718506
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00033092498779297
SELECT * FROM categories WHERE pagename = 'combat-knife'
239 0.0032 0.0031828880310059
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
240 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 50
241 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '50'
242 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '96'
243 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '97'
244 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '111'
245 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '129'
246 0.0059 0.0058810710906982
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 
247 0.0002 0.00018191337585449
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 
248 0.0002 0.00017189979553223
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 
249 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
250 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '50'
251 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '96'
252 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '97'
253 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '111'
254 0.0002 0.00022983551025391
SELECT id FROM categories WHERE parent_id = '129'
255 0.0059 0.0059149265289307
SELECT 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.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
256 0.0003 0.0003211498260498
SELECT * FROM productimages WHERE product_id = '136554' ORDER BY sortorder ASC
257 0.0001 0.00012302398681641
SELECT * FROM categoryimages WHERE category_id = 50
258 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
259 0.0031 0.0031118392944336
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '50'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
260 0.0001 0.00014901161193848
SELECT parent_id FROM categories WHERE id = '50'
261 0.0001 0.00013089179992676
SELECT parent_id FROM categories WHERE id = '50'
262 0.0002 0.0001530647277832
SELECT * FROM categorygroups ORDER BY sortorder ASC
263 0.0005 0.00054502487182617
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
264 0.0005 0.00046586990356445
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
265 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '49'
266 0.0005 0.0004730224609375
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 
267 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 (49)
				  AND p.disabled = 0 
268 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
269 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
270 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
271 0.0030 0.0030059814453125
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
272 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '50'
273 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '96'
274 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '97'
275 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '111'
276 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '129'
277 0.0058 0.0057821273803711
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 
278 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
279 0.0002 0.00017094612121582
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 
280 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
281 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
282 0.0004 0.00039291381835938
SELECT * FROM categories WHERE parent_id = '50'  AND hidden = 0 ORDER BY sortorder ASC
283 0.0012 0.0011589527130127
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 = 96
284 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '96'
285 0.0012 0.0011780261993408
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
286 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96)
				  AND p.disabled = 0 
287 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
288 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '96'
289 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '1'
290 0.0003 0.00030303001403809
SELECT * FROM categories WHERE parent_id = '96'  AND hidden = 0 ORDER BY sortorder ASC
291 0.0009 0.00094914436340332
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 = 97
292 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '97'
293 0.0010 0.00098514556884766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (97)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
294 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (97)
				  AND p.disabled = 0 
295 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 (97)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
296 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '97'
297 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
298 0.0003 0.00030708312988281
SELECT * FROM categories WHERE parent_id = '97'  AND hidden = 0 ORDER BY sortorder ASC
299 0.0007 0.00065994262695312
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 = 111
300 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '111'
301 0.0007 0.00068402290344238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (111)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
302 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (111)
				  AND p.disabled = 0 
303 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (111)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
304 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '111'
305 0.0001 0.00013279914855957
SELECT * FROM categorygroups WHERE id = '1'
306 0.0003 0.00029397010803223
SELECT * FROM categories WHERE parent_id = '111'  AND hidden = 0 ORDER BY sortorder ASC
307 0.0006 0.00064992904663086
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 = 129
308 0.0002 0.00023818016052246
SELECT id FROM categories WHERE parent_id = '129'
309 0.0007 0.00067281723022461
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (129)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
310 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (129)
				  AND p.disabled = 0 
311 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (129)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
312 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '129'
313 0.0001 0.00014591217041016
SELECT * FROM categorygroups WHERE id = '1'
314 0.0003 0.00029492378234863
SELECT * FROM categories WHERE parent_id = '129'  AND hidden = 0 ORDER BY sortorder ASC
315 0.0026 0.0026140213012695
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
316 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '80'
317 0.0026 0.0025582313537598
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 
318 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
319 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
320 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
321 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
322 0.0012 0.0011801719665527
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
323 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '51'
324 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '101'
325 0.0018 0.0018360614776611
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 
326 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
327 0.0002 0.0001678466796875
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 
328 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
329 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
330 0.0004 0.00044393539428711
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
331 0.0024 0.0023889541625977
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
332 0.0003 0.00027799606323242
SELECT id FROM categories WHERE parent_id = '30'
333 0.0024 0.002373218536377
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 
334 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
335 0.0002 0.00016188621520996
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 
336 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
337 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '2'
338 0.0049 0.0049488544464111
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
339 0.0003 0.00028014183044434
SELECT id FROM categories WHERE parent_id = '61'
340 0.0050 0.0049920082092285
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 
341 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
342 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
343 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
344 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '2'
345 0.0007 0.00070405006408691
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
346 0.0043 0.0042998790740967
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
347 0.0003 0.00028419494628906
SELECT id FROM categories WHERE parent_id = '64'
348 0.0043 0.0042738914489746
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 
349 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
350 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
351 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
352 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
353 0.0086 0.008613109588623
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
354 0.0003 0.00029206275939941
SELECT id FROM categories WHERE parent_id = '65'
355 0.0086 0.0086359977722168
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 
356 0.0002 0.00017094612121582
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 
357 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
358 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
359 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
360 0.0025 0.0025358200073242
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
361 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '81'
362 0.0026 0.0025680065155029
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 
363 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
364 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
365 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
366 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
367 0.0025 0.0025160312652588
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
368 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '31'
369 0.0025 0.0025479793548584
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 
370 0.0002 0.00015807151794434
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 
371 0.0002 0.00017309188842773
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 
372 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
373 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
374 0.0023 0.0023322105407715
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
375 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '66'
376 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '131'
377 0.0029 0.0029079914093018
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 
378 0.0002 0.00017118453979492
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 
379 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
380 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
381 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
382 0.0097 0.0097379684448242
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
383 0.0003 0.0003058910369873
SELECT id FROM categories WHERE parent_id = '34'
384 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '94'
385 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '98'
386 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '99'
387 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '110'
388 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '130'
389 0.0105 0.010491132736206
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 
390 0.0002 0.00018501281738281
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 
391 0.0002 0.00017213821411133
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 
392 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
393 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
394 0.0016 0.001615047454834
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
395 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '32'
396 0.0017 0.0016608238220215
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 
397 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
398 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
399 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
400 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
401 0.0022 0.0022320747375488
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
402 0.0003 0.00026512145996094
SELECT id FROM categories WHERE parent_id = '89'
403 0.0023 0.0022568702697754
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 
404 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
405 0.0002 0.0001680850982666
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 
406 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
407 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
408 0.0004 0.00043416023254395
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
409 0.0007 0.00071406364440918
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
410 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '84'
411 0.0007 0.00072002410888672
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 
412 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 (84)
				  AND p.disabled = 0 
413 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
414 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
415 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '17'
416 0.0007 0.00072288513183594
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
417 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '90'
418 0.0008 0.00075316429138184
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 
419 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
420 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
421 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
422 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '17'
423 0.0003 0.00032901763916016
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
424 0.0021 0.0020761489868164
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
425 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '92'
426 0.0021 0.0020909309387207
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 
427 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
428 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
429 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
430 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '20'
431 0.0001 0.00011587142944336
SELECT * FROM categoryimages WHERE category_id = 50
432 0.0002 0.00018405914306641
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
433 0.0003 0.00032711029052734
SELECT * FROM categories WHERE parent_id = '50'
434 0.0031 0.0031399726867676
SELECT COUNT(*) FROM products_categories c, products p WHERE p.id = c.product_id AND c.category_id = '50' AND p.hidden = 0 AND (p.price > 0 OR p.parent = 1)
435 0.0339 0.03394603729248
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
436 0.0063 0.006317138671875
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
437 0.0003 0.00030279159545898
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
438 0.0338 0.03384804725647
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
439 0.0062 0.0062179565429688
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
440 0.0003 0.00029706954956055
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
441 0.0034 0.0033960342407227
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 50
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
442 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 50
		AND c.prod_type = 'ebay'
		AND hide = 1
443 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 50
			AND p.disabled = 0
			
			AND 1 = 1
444 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 50
		AND c.prod_type = 'custom'
		AND hide = 1
445 0.0055 0.0054740905761719
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 50
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 50
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 50
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 50
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
446 0.0002 0.00024819374084473
SELECT * FROM products WHERE id = '13317'
447 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '13317' ORDER BY sortorder ASC
448 0.0007 0.00066494941711426
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '13317' AND p.id = pi.product_id ORDER BY pi.sortorder
449 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '13317'
450 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '13317'
451 0.0004 0.0003669261932373
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 = '13317'
                GROUP BY o.product_id
452 0.0005 0.00045013427734375
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     = '13317'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
453 0.0003 0.00029206275939941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 13317
454 0.0012 0.0012280941009521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '13317' AND a.name = n.originalname
455 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '13317' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '13317' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0002 0.00017309188842773
SELECT * FROM productoffers
                WHERE product_id = 13317
                ORDER BY price ASC LIMIT 1
458 0.0002 0.00021886825561523
SELECT value FROM productattributes
                WHERE product_id = '13317'
                AND name = 'ListPriceAmount'
459 0.0003 0.00034308433532715
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 = '13317'
                GROUP BY o.product_id
460 0.0004 0.0004119873046875
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     = '13317'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
461 0.0003 0.00028705596923828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 13317
462 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '13317' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00013899803161621
UPDATE products SET price = '5761' WHERE id = '13317'
464 0.0004 0.00043702125549316
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '13317'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
465 0.0002 0.00023007392883301
SELECT * FROM products WHERE id = '290360'
466 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '290360' ORDER BY sortorder ASC
467 0.0002 0.00021600723266602
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
468 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '290360'
469 0.0001 0.00014114379882812
SELECT * FROM productcustomimages WHERE product_id = '290360'
470 0.0002 0.00021696090698242
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
471 0.0002 0.00023603439331055
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
472 0.0002 0.00018596649169922
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
473 0.0026 0.0025739669799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290360' AND a.name = n.originalname
474 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '290360' AND merchantid = 'ATVPDKIKX0DER'
475 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '290360' AND price > 0
                ORDER BY price ASC LIMIT 1
476 0.0002 0.00017809867858887
SELECT * FROM productoffers
                WHERE product_id = 290360
                ORDER BY price ASC LIMIT 1
477 0.0002 0.00024199485778809
SELECT value FROM productattributes
                WHERE product_id = '290360'
                AND name = 'ListPriceAmount'
478 0.0002 0.00021696090698242
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
479 0.0002 0.00023698806762695
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
480 0.0002 0.0001838207244873
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
481 0.0001 0.00014090538024902
UPDATE products SET price = '10799' WHERE id = '290360'
482 0.0002 0.00021100044250488
SELECT * FROM products WHERE parent_id = '290360'
483 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '249704'
484 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '249704' ORDER BY sortorder ASC
485 0.0004 0.00042510032653809
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '249704' AND p.id = pi.product_id ORDER BY pi.sortorder
486 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '249704'
487 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '249704'
488 0.0004 0.0003809928894043
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 = '249704'
                GROUP BY o.product_id
489 0.0004 0.00042295455932617
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     = '249704'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
490 0.0003 0.00030899047851562
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 249704
491 0.0031 0.0031039714813232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '249704' AND a.name = n.originalname
492 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '249704' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '249704' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0002 0.00017309188842773
SELECT * FROM productoffers
                WHERE product_id = 249704
                ORDER BY price ASC LIMIT 1
495 0.0003 0.00027799606323242
SELECT value FROM productattributes
                WHERE product_id = '249704'
                AND name = 'ListPriceAmount'
496 0.0004 0.00036811828613281
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 = '249704'
                GROUP BY o.product_id
497 0.0004 0.00040888786315918
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     = '249704'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
498 0.0003 0.00032401084899902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 249704
499 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '249704' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
500 0.0001 0.00013089179992676
UPDATE products SET price = '2699' WHERE id = '249704'
501 0.0004 0.00043392181396484
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '249704'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
502 0.0002 0.00022315979003906
SELECT * FROM products WHERE id = '266825'
503 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '266825' ORDER BY sortorder ASC
504 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '266825'
505 0.0001 0.00014209747314453
SELECT * FROM productcustomimages WHERE product_id = '266825'
506 0.0019 0.0018830299377441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266825' AND a.name = n.originalname
507 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '266825' AND merchantid = 'ATVPDKIKX0DER'
508 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '266825' AND price > 0
                ORDER BY price ASC LIMIT 1
509 0.0002 0.00017809867858887
SELECT * FROM productoffers
                WHERE product_id = 266825
                ORDER BY price ASC LIMIT 1
510 0.0002 0.00024509429931641
SELECT value FROM productattributes
                WHERE product_id = '266825'
                AND name = 'ListPriceAmount'
511 0.0001 0.00014209747314453
UPDATE products SET price = '926' WHERE id = '266825'
512 0.0002 0.0002140998840332
SELECT * FROM products WHERE id = '413883'
513 0.0002 0.00016498565673828
SELECT * FROM productimages WHERE product_id = '413883' ORDER BY sortorder ASC
514 0.0003 0.00031113624572754
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '413883' AND p.id = pi.product_id ORDER BY pi.sortorder
515 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '413883'
516 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '413883'
517 0.0002 0.00023603439331055
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 = '413883'
                GROUP BY o.product_id
518 0.0003 0.00029301643371582
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     = '413883'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
519 0.0002 0.00021696090698242
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413883
520 0.0004 0.00044584274291992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413883' AND a.name = n.originalname
521 0.0002 0.00017714500427246
SELECT * FROM productoffers WHERE product_id = '413883' AND merchantid = 'ATVPDKIKX0DER'
522 0.0002 0.00018906593322754
SELECT * FROM productoffers
                WHERE product_id = '413883' AND price > 0
                ORDER BY price ASC LIMIT 1
523 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = 413883
                ORDER BY price ASC LIMIT 1
524 0.0002 0.00023698806762695
SELECT value FROM productattributes
                WHERE product_id = '413883'
                AND name = 'ListPriceAmount'
525 0.0002 0.00023412704467773
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 = '413883'
                GROUP BY o.product_id
526 0.0003 0.00028586387634277
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     = '413883'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
527 0.0002 0.0002140998840332
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413883
528 0.0003 0.00033688545227051
SELECT value FROM productattributes WHERE product_id = '413883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
529 0.0003 0.0003361701965332
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '413883'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
530 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = '186017'
531 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '186017' ORDER BY sortorder ASC
532 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '186017'
533 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '186017'
534 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '186017' AND a.name = n.originalname
535 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '186017' AND merchantid = 'ATVPDKIKX0DER'
536 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '186017' AND price > 0
                ORDER BY price ASC LIMIT 1
537 0.0004 0.00041413307189941
SELECT value FROM productattributes WHERE product_id = '186017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
538 0.0001 0.00013279914855957
UPDATE products SET price = '1299' WHERE id = '186017'
539 0.0002 0.00021910667419434
SELECT * FROM products WHERE id = '198388'
540 0.0003 0.00025010108947754
SELECT * FROM productimages WHERE product_id = '198388' ORDER BY sortorder ASC
541 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '198388'
542 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '198388'
543 0.0027 0.0026719570159912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '198388' AND a.name = n.originalname
544 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '198388' AND merchantid = 'ATVPDKIKX0DER'
545 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '198388' AND price > 0
                ORDER BY price ASC LIMIT 1
546 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = 198388
                ORDER BY price ASC LIMIT 1
547 0.0003 0.00027608871459961
SELECT value FROM productattributes
                WHERE product_id = '198388'
                AND name = 'ListPriceAmount'
548 0.0001 0.00012898445129395
UPDATE products SET price = '1325' WHERE id = '198388'
549 0.0002 0.00022196769714355
SELECT * FROM products WHERE id = '194384'
550 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '194384' ORDER BY sortorder ASC
551 0.0003 0.00025320053100586
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '194384' AND p.id = pi.product_id ORDER BY pi.sortorder
552 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '194384'
553 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '194384'
554 0.0003 0.00025200843811035
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 = '194384'
                GROUP BY o.product_id
555 0.0004 0.00036811828613281
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     = '194384'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
556 0.0002 0.0002138614654541
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 194384
557 0.0008 0.00081706047058105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '194384' AND a.name = n.originalname
558 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '194384' AND merchantid = 'ATVPDKIKX0DER'
559 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '194384' AND price > 0
                ORDER BY price ASC LIMIT 1
560 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = 194384
                ORDER BY price ASC LIMIT 1
561 0.0003 0.00025081634521484
SELECT value FROM productattributes
                WHERE product_id = '194384'
                AND name = 'ListPriceAmount'
562 0.0002 0.00024199485778809
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 = '194384'
                GROUP BY o.product_id
563 0.0004 0.00037193298339844
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     = '194384'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
564 0.0002 0.0002129077911377
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 194384
565 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '194384' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
566 0.0004 0.00036096572875977
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '194384'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
567 0.0004 0.00035691261291504
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '194384'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
568 0.0002 0.00021696090698242
SELECT * FROM products WHERE id = '244462'
569 0.0004 0.00040411949157715
SELECT * FROM productimages WHERE product_id = '244462' ORDER BY sortorder ASC
570 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '244462'
571 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '244462'
572 0.0022 0.0022118091583252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '244462' AND a.name = n.originalname
573 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '244462' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '244462' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '244462' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00013399124145508
UPDATE products SET price = '2942' WHERE id = '244462'
577 0.0002 0.00021696090698242
SELECT * FROM products WHERE id = '75854'
578 0.0002 0.0002291202545166
SELECT * FROM productimages WHERE product_id = '75854' ORDER BY sortorder ASC
579 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '75854'
580 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '75854'
581 0.0027 0.0027499198913574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '75854' AND a.name = n.originalname
582 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '75854' AND merchantid = 'ATVPDKIKX0DER'
583 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '75854' AND price > 0
                ORDER BY price ASC LIMIT 1
584 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 75854
                ORDER BY price ASC LIMIT 1
585 0.0002 0.00023508071899414
SELECT value FROM productattributes
                WHERE product_id = '75854'
                AND name = 'ListPriceAmount'
586 0.0001 0.00012993812561035
UPDATE products SET price = '3999' WHERE id = '75854'
587 0.0002 0.00020408630371094
SELECT * FROM products WHERE id = '275735'
588 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '275735' ORDER BY sortorder ASC
589 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '275735'
590 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '275735'
591 0.0162 0.016204118728638
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '275735' AND a.name = n.originalname
592 0.0002 0.000244140625
SELECT * FROM productoffers WHERE product_id = '275735' AND merchantid = 'ATVPDKIKX0DER'
593 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '275735' AND price > 0
                ORDER BY price ASC LIMIT 1
594 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '275735' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
595 0.0001 0.0001218318939209
UPDATE products SET price = '675' WHERE id = '275735'
596 0.0002 0.00021886825561523
SELECT * FROM products WHERE id = '274331'
597 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '274331' ORDER BY sortorder ASC
598 0.0003 0.0003349781036377
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '274331' AND p.id = pi.product_id ORDER BY pi.sortorder
599 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '274331'
600 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '274331'
601 0.0002 0.00024104118347168
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 = '274331'
                GROUP BY o.product_id
602 0.0003 0.00032997131347656
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     = '274331'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
603 0.0002 0.0002131462097168
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 274331
604 0.0022 0.0021851062774658
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '274331' AND a.name = n.originalname
605 0.0002 0.00017309188842773
SELECT * FROM productoffers WHERE product_id = '274331' AND merchantid = 'ATVPDKIKX0DER'
606 0.0002 0.00017213821411133
SELECT * FROM productoffers
                WHERE product_id = '274331' AND price > 0
                ORDER BY price ASC LIMIT 1
607 0.0002 0.00015592575073242
SELECT * FROM productoffers
                WHERE product_id = 274331
                ORDER BY price ASC LIMIT 1
608 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '274331'
                AND name = 'ListPriceAmount'
609 0.0003 0.00025010108947754
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 = '274331'
                GROUP BY o.product_id
610 0.0003 0.0003201961517334
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     = '274331'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
611 0.0002 0.00020980834960938
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 274331
612 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '274331' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0004 0.00035405158996582
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '274331'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
614 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '271923'
615 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '271923' ORDER BY sortorder ASC
616 0.0002 0.00022101402282715
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '271923' AND p.id = pi.product_id ORDER BY pi.sortorder
617 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '271923'
618 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '271923'
619 0.0002 0.00021004676818848
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 = '271923'
                GROUP BY o.product_id
620 0.0003 0.00027012825012207
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     = '271923'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
621 0.0002 0.00018501281738281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 271923
622 0.0017 0.0016801357269287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '271923' AND a.name = n.originalname
623 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '271923' AND merchantid = 'ATVPDKIKX0DER'
624 0.0002 0.00017309188842773
SELECT * FROM productoffers
                WHERE product_id = '271923' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0002 0.00016498565673828
SELECT * FROM productoffers
                WHERE product_id = 271923
                ORDER BY price ASC LIMIT 1
626 0.0002 0.00022387504577637
SELECT value FROM productattributes
                WHERE product_id = '271923'
                AND name = 'ListPriceAmount'
627 0.0002 0.00020790100097656
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 = '271923'
                GROUP BY o.product_id
628 0.0003 0.00027084350585938
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     = '271923'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
629 0.0002 0.00018477439880371
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 271923
630 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '271923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
631 0.0003 0.0003349781036377
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '271923'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
632 0.0002 0.00022315979003906
SELECT * FROM products WHERE parent_id = '271923'
633 0.0002 0.00021696090698242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406862' AND a.name = n.originalname
634 0.0002 0.00015997886657715
SELECT * FROM productoffers WHERE product_id = '406862' AND merchantid = 'ATVPDKIKX0DER'
635 0.0002 0.00017189979553223
SELECT * FROM productoffers
                WHERE product_id = '406862' AND price > 0
                ORDER BY price ASC LIMIT 1
636 0.0002 0.00017285346984863
SELECT * FROM productoffers
                WHERE product_id = 406862
                ORDER BY price ASC LIMIT 1
637 0.0002 0.00022387504577637
SELECT value FROM productattributes
                WHERE product_id = '406862'
                AND name = 'ListPriceAmount'
638 0.0002 0.0001978874206543
SELECT * FROM products WHERE id = '148634'
639 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '148634' ORDER BY sortorder ASC
640 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '148634'
641 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '148634'
642 0.0024 0.002439022064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '148634' AND a.name = n.originalname
643 0.0002 0.00017213821411133
SELECT * FROM productoffers WHERE product_id = '148634' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '148634' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 148634
                ORDER BY price ASC LIMIT 1
646 0.0002 0.00021195411682129
SELECT value FROM productattributes
                WHERE product_id = '148634'
                AND name = 'ListPriceAmount'
647 0.0001 0.00011801719665527
UPDATE products SET price = '7495' WHERE id = '148634'
648 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '179709'
649 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '179709' ORDER BY sortorder ASC
650 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '179709'
651 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '179709'
652 0.0021 0.0020699501037598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '179709' AND a.name = n.originalname
653 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '179709' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00018405914306641
SELECT * FROM productoffers
                WHERE product_id = '179709' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 179709
                ORDER BY price ASC LIMIT 1
656 0.0002 0.00020003318786621
SELECT value FROM productattributes
                WHERE product_id = '179709'
                AND name = 'ListPriceAmount'
657 0.0001 0.00011610984802246
UPDATE products SET price = '2249' WHERE id = '179709'
658 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '16779'
659 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '16779' ORDER BY sortorder ASC
660 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '16779'
661 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '16779'
662 0.0018 0.0018010139465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '16779' AND a.name = n.originalname
663 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '16779' AND merchantid = 'ATVPDKIKX0DER'
664 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '16779' AND price > 0
                ORDER BY price ASC LIMIT 1
665 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '16779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
666 0.0001 0.00012111663818359
UPDATE products SET price = '1625' WHERE id = '16779'
667 0.0002 0.00020790100097656
SELECT * FROM products WHERE id = '339144'
668 0.0003 0.00026702880859375
SELECT * FROM productimages WHERE product_id = '339144' ORDER BY sortorder ASC
669 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '339144'
670 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '339144'
671 0.0027 0.0027158260345459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '339144' AND a.name = n.originalname
672 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '339144' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00017380714416504
SELECT * FROM productoffers
                WHERE product_id = '339144' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 339144
                ORDER BY price ASC LIMIT 1
675 0.0002 0.00019288063049316
SELECT value FROM productattributes
                WHERE product_id = '339144'
                AND name = 'ListPriceAmount'
676 0.0001 0.00011491775512695
UPDATE products SET price = '3152' WHERE id = '339144'
677 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '277307'
678 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '277307' ORDER BY sortorder ASC
679 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '277307'
680 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '277307'
681 0.0031 0.0031049251556396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '277307' AND a.name = n.originalname
682 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '277307' AND merchantid = 'ATVPDKIKX0DER'
683 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '277307' AND price > 0
                ORDER BY price ASC LIMIT 1
684 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '277307' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
685 0.0001 0.00011587142944336
UPDATE products SET price = '5266' WHERE id = '277307'
686 0.0003 0.0003201961517334
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '13317' ORDER BY timestamp DESC
687 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290360' ORDER BY timestamp DESC
688 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '249704' ORDER BY timestamp DESC
689 0.0003 0.00027012825012207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '266825' ORDER BY timestamp DESC
690 0.0003 0.0002589225769043
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413883' ORDER BY timestamp DESC
691 0.0003 0.0002589225769043
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '186017' ORDER BY timestamp DESC
692 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '198388' ORDER BY timestamp DESC
693 0.0003 0.00026798248291016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '194384' ORDER BY timestamp DESC
694 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '244462' ORDER BY timestamp DESC
695 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '75854' ORDER BY timestamp DESC
696 0.0003 0.00026679039001465
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '275735' ORDER BY timestamp DESC
697 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '274331' ORDER BY timestamp DESC
698 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '271923' ORDER BY timestamp DESC
699 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '148634' ORDER BY timestamp DESC
700 0.0003 0.00026798248291016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '179709' ORDER BY timestamp DESC
701 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '16779' ORDER BY timestamp DESC
702 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '339144' ORDER BY timestamp DESC
703 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '277307' ORDER BY timestamp DESC
704 0.0002 0.00017189979553223
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 50
		AND c.prod_type = 'ebay'
		AND hide = 1
705 0.0001 0.00013279914855957
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
706 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
707 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
708 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
709 0.0001 0.00011515617370605
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
710 0.0001 0.00013089179992676
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
711 0.0002 0.00015997886657715
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
712 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = 2
713 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 4
714 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 12
715 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 10
716 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 7
717 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 18
718 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
719 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 13
720 0.0001 0.00013208389282227
SELECT * FROM pages WHERE id = 3
721 0.0432 0.043185949325562
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
722 0.0002 0.00022697448730469
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:1563784381;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"407595\";i:5;s:6:\"170197\";i:8;s:6:\"404554\";i:13;s:6:\"370121\";i:18;s:6:\"415052\";}}' WHERE id = '175'
723 0.0005 0.00046491622924805
SELECT * FROM products WHERE id IN (398315,407595,170197,404554,370121,415052) ORDER BY FIELD(id, 398315,407595,170197,404554,370121,415052 )
724 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
725 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '398315'
726 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '398315'
727 0.0026 0.002579927444458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
728 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
729 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
730 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
731 0.0001 0.00012111663818359
UPDATE products SET price = '1999' WHERE id = '398315'
732 0.0002 0.00022983551025391
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
733 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '407595'
734 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '407595'
735 0.0034 0.0034189224243164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
736 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
737 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
738 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
739 0.0001 0.00011515617370605
UPDATE products SET price = '2497' WHERE id = '407595'
740 0.0007 0.00067400932312012
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
741 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '170197'
742 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '170197'
743 0.0033 0.0032758712768555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
744 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
745 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
746 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
747 0.0001 0.00011992454528809
UPDATE products SET price = '324500' WHERE id = '170197'
748 0.0003 0.00026679039001465
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
749 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '404554'
750 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404554'
751 0.0033 0.0033450126647949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
752 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
753 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
754 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
755 0.0001 0.00011610984802246
UPDATE products SET price = '375926' WHERE id = '404554'
756 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
757 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '370121'
758 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '370121'
759 0.0028 0.0027639865875244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
760 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
761 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
762 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
763 0.0001 0.00012803077697754
UPDATE products SET price = '12979' WHERE id = '370121'
764 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '415052' ORDER BY sortorder ASC
765 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '415052'
766 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '415052'
767 0.0026 0.0026469230651855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415052' AND a.name = n.originalname
768 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '415052' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '415052' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '415052' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00012898445129395
UPDATE products SET price = '6999' WHERE id = '415052'
772 0.0429 0.042850017547607
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
773 0.0002 0.00023984909057617
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:1563784381;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:6;s:6:\"185812\";i:15;s:6:\"412382\";i:17;s:6:\"407831\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";}}' WHERE id = '177'
774 0.0004 0.00042390823364258
SELECT * FROM products WHERE id IN (398858,185812,412382,407831,414940,398315) ORDER BY FIELD(id, 398858,185812,412382,407831,414940,398315 )
775 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
776 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '398858'
777 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '398858'
778 0.0031 0.0030581951141357
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
779 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
780 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
781 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
782 0.0001 0.00011801719665527
UPDATE products SET price = '2999' WHERE id = '398858'
783 0.0007 0.00067496299743652
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
784 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '185812'
785 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '185812'
786 0.0021 0.0020759105682373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
787 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
788 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
789 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
790 0.0001 0.00012016296386719
UPDATE products SET price = '314900' WHERE id = '185812'
791 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
792 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '412382'
793 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '412382'
794 0.0021 0.0020730495452881
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
795 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
796 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
797 0.0003 0.00031495094299316
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
798 0.0001 0.00011682510375977
UPDATE products SET price = '3199' WHERE id = '412382'
799 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
800 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '407831'
801 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '407831'
802 0.0034 0.0034210681915283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
803 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
804 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
805 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
806 0.0001 0.00011706352233887
UPDATE products SET price = '1293' WHERE id = '407831'
807 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
808 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '414940'
809 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '414940'
810 0.0033 0.0032930374145508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
811 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
812 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
813 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
814 0.0001 0.00011420249938965
UPDATE products SET price = '4490' WHERE id = '414940'
815 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
816 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '398315'
817 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '398315'
818 0.0026 0.0025699138641357
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
819 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
820 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
821 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
822 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
823 0.1087 0.10869383811951
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
824 0.0003 0.00028586387634277
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:1563784381;s:8:\"products\";a:6:{i:5;s:6:\"170197\";i:8;s:6:\"404554\";i:18;s:6:\"415052\";i:21;s:6:\"147874\";i:3;s:6:\"407595\";i:6;s:6:\"185812\";}}' WHERE id = '181'
825 0.0005 0.00048589706420898
SELECT * FROM products WHERE id IN (170197,404554,415052,147874,407595,185812) ORDER BY FIELD(id, 170197,404554,415052,147874,407595,185812 )
826 0.0007 0.0006721019744873
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
827 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '170197'
828 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '170197'
829 0.0034 0.0033562183380127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
830 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
831 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
832 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
833 0.0001 0.00012397766113281
UPDATE products SET price = '324500' WHERE id = '170197'
834 0.0003 0.00026702880859375
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
835 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '404554'
836 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
837 0.0034 0.0033810138702393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
838 0.0002 0.00017976760864258
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
839 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
840 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
841 0.0001 0.00011587142944336
UPDATE products SET price = '375926' WHERE id = '404554'
842 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '415052' ORDER BY sortorder ASC
843 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '415052'
844 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '415052'
845 0.0026 0.0026149749755859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415052' AND a.name = n.originalname
846 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '415052' AND merchantid = 'ATVPDKIKX0DER'
847 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '415052' AND price > 0
                ORDER BY price ASC LIMIT 1
848 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '415052' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
849 0.0001 0.00012898445129395
UPDATE products SET price = '6999' WHERE id = '415052'
850 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
851 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '147874'
852 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '147874'
853 0.0028 0.0028440952301025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
854 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
855 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
856 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
857 0.0001 0.00011610984802246
UPDATE products SET price = '1486' WHERE id = '147874'
858 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
859 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407595'
860 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '407595'
861 0.0034 0.0034298896789551
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
862 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
863 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
864 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
865 0.0001 0.00011706352233887
UPDATE products SET price = '2497' WHERE id = '407595'
866 0.0007 0.00066399574279785
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
867 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '185812'
868 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '185812'
869 0.0021 0.0020759105682373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
870 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
871 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
872 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
873 0.0001 0.00011801719665527
UPDATE products SET price = '314900' WHERE id = '185812'
874 0.1083 0.10827612876892
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
875 0.0003 0.00026679039001465
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:1563784381;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:4;s:6:\"415083\";i:10;s:6:\"409759\";i:12;s:6:\"402983\";i:21;s:6:\"147874\";}}' WHERE id = '183'
876 0.0007 0.00074911117553711
SELECT * FROM products WHERE id IN (414940,398315,415083,409759,402983,147874) ORDER BY FIELD(id, 414940,398315,415083,409759,402983,147874 )
877 0.0002 0.00019121170043945
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
878 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '414940'
879 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '414940'
880 0.0033 0.0033118724822998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
881 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
882 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
883 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
884 0.0001 0.00011897087097168
UPDATE products SET price = '4490' WHERE id = '414940'
885 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
886 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '398315'
887 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '398315'
888 0.0026 0.0025629997253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
889 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
890 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
891 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
892 0.0001 0.00011920928955078
UPDATE products SET price = '1999' WHERE id = '398315'
893 0.0002 0.00016689300537109
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
894 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '415083'
895 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '415083'
896 0.0035 0.0035240650177002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
897 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
898 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
899 0.0004 0.00042819976806641
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
900 0.0002 0.0002439022064209
UPDATE products SET price = '2299' WHERE id = '415083'
901 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
902 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '409759'
903 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '409759'
904 0.0028 0.0028231143951416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
905 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
906 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
907 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
908 0.0001 0.00011801719665527
UPDATE products SET price = '229000' WHERE id = '409759'
909 0.0002 0.00018882751464844
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
910 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402983'
911 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '402983'
912 0.0022 0.0022308826446533
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
913 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
914 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
915 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
916 0.0001 0.0001380443572998
UPDATE products SET price = '10396' WHERE id = '402983'
917 0.0002 0.00018477439880371
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
918 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '147874'
919 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '147874'
920 0.0029 0.0028741359710693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
921 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
922 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
923 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
924 0.0001 0.00011610984802246
UPDATE products SET price = '1486' WHERE id = '147874'
925 0.0004 0.00041699409484863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
926 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
927 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
928 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
929 0.0001 0.00011587142944336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
930 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
931 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
932 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
933 0.0009 0.00091195106506348
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
934 0.0003 0.00030398368835449
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
935 0.0003 0.00027298927307129
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
936 0.0004 0.00036907196044922
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
937 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
938 0.0001 0.00012993812561035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
939 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
940 0.0001 0.00011587142944336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
941 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
942 0.0003 0.0003349781036377
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
943 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'