Tactical Equipment - Survivalist Equipment

Rifle Scopes :: Tactical Knives :: Stun Guns Online

Zeus 640 2-16x50 (30 Hz) Thermal Imaging Weapon Sight, FLIR Tau 2 - 64...

only $3,895.00

Yukon NVMT 1x24 Head Mount Kit from Yukon :: Night Vision :: Night Vis...

only $382.49

Wosports Rechargeable Hunting Rangefinder, 800 Yards USB Charging Lase...

only $119.99

Wild Hunting Rangefinder - Laser Range Finder for Hunting with Speed, ...

only $99.99

Weaver Tactical 1-5 x 24mm Illuminated Intermediate Range Scope from V...

only $635.39

Weaver Base Top Mount from Vista Outdoor Sales LLC

only $3.95

Rifle Scopes :: Tactical Knives :: Stun Guns Online

Todays Tactical Survivalist & Combat Products Specials


Tactical and Survivalist - They go hand in hand

Tactical Mission Survival

The tactical fighter has a mission which will put them in testing, unfamiliar and hostile environments. Getting in, getting the job done, and getting out again can be partially calculated by the strength of a plan along with it's supporting equipment. Past this, it lies in the hands of a soldiers ability and lastly, fate.

Should fate play it's nasty part and the mission deviate from the plan, survivalism needs to kick in - and fast! Not only do your skills and physical performance play an important part in carrying out a tactical operation but they also need to help you escape, evade and elude any threat whether they be human, environmental or other. This is where survival skills are an essential part of the initial mission plan. From hand to hand combat to emergency medical and first aid proceedures along with standard bushcraft and wilderness survival or desert survival skills, this can be often the difference between leaving the situation alive - or not...


Combat Gear :: Tactical Equipment :: SWAT Gear :: Survival Tools :: AR15 Scopes :: Night Vision Goggles :: First Aid Kits

Tactical Gear :: Survival Tools :: Combat Equipment

Buy military gear cheap and police gear at civilian prices! Our aim is to provide the best possible combat gear for the soldier, hunter or special ops warrior and also the most useful survival knives for the survivalist. Read our interview about the specialist SAS skills of the UK's Bear Grylls with his TV series.

When considering a tactical pack for a combat mission or hunting expedition equal attention should be paid to the simplist items such as first aid kit (IFAK) to the more work orientated devices and tools such as laser rangefinder binoculars, the military tactical knife or a survival knife, you can also buy body armour online through our store.

Shop online and save on all your infantry fighting combat gear for sale available direct to the public stocking some of the best brands like Condor Tactical Gear and the ever popular 5.11 Tactical Gear. We also carry a wide range of gun optics, Vipertek stun guns, military gas masks and long range rifle scopes for every tactical need.


Popular Military And Survivalist Articles

See How It Is In The Real World


Weapons of war and tools of survival - all developed through human necessity - we are all survivalists

War, hunting and survivalism have very close ties throughout history. Each can show innovation that has crossed over to another to provide a better way in which to complete an operation or better tools for which to do it with. Level IIIA Bullet Proof Vests and Ballistic Plates at Unbeatable Prices!

Today, affordable military quality tactical optics equipment such as night vision goggles is readily available at reasonable prices and most of the areas now share reasonably equal footing on what is available for a particular purpose (weapons excluded for obvious reasons - though de-tuned equivalents are often avaialble). With this in mind there is no reson to put yourself in a situation unprepared, your life depends on it!


WHATS THE ULTIMATE RIFLE CALIBRE?

Modern .338 rounds include the .338 Win Mag, the .338 Norma Magnum and the now world-renown .338 Lapua, widely regarded as one of the best of, if not the best, of the long range tactical rounds. These .338 loads however are way too grunty for average size hunting game, producing what most US hunters would consider excessive muzzle blast and recoil.

...the .338 calibre does offer superior long range ballistics among calibres that are considered suitable for rifles.

The United States military, having known how good the .338 cal is ever since the 1950s, has finally decided to adopt it for the battlefield. General Dynamics Corp is developing a .338 light machine gun to fill the gap between the current .30 cal and .50 cal guns. The LWMMG (lightweight Medium Machine Gun) is chambered in .338 Norma and designed to engage targets, light vehicles and personnel, at ranges out to 1700 metres.

How good is the .338 cartridge? The Norma round has a maximum range of over five and a half kilometres (no other round rifle round can shoot as far), and at 1000 metres it has almost twice the power of the .308 Nato.


PRIVATE SECURITY

ISSUES AND TRENDS ON THE PRIVATE SIDE OF LAW ENFORCEMENT

As the world turns or disintegrates, depending on whether you have an eco-friendly, holistic global warming approach to life on this planet, or — heaven forbid — view life from a rational, empirical, evidence-based perspective, the words we use to describe the various disciplines of our profession mutate as well. And the seeds of confusion are thus sewn.

An illustration : Several years ago members of a privately funded, paramilitary force, inserted into a "foreign" country, for whatever reason — suppression, protection services — were called mercenaries. In some quarters they still are, but the meaning of the word, strongly influenced as applied, or misapplied, by the media, becomes muddled when attempts are made to simultaneously describe both private security endeavors in support of nation-building and mercenary force operations, sometimes in the same region. It gets more confusing when the same companies offer both "services." (I recommend John Irvin's 1981 Dogs of War for cinematic clarity, at least, regarding the meaning of "mercenary ")

The Definition

Are these men and women thoughtful professionals, surrendering a significant chunk of their lives, not to mention exposure to enormous personal risk as they volunteer to assist our government to stabilize broken institutions overseas? Or, "person(s) who takes part in an armed conflict who is not a national of a Party to the conflict and is motivated to take part in the hostilities essentially by the desire for private gain and, in fact, is promised, by or on behalf of a Party to the con diet, material compensation substantially in excess of that promised or paid to combatants of similar ranks and functions in the armed forces of that Party" (the definition of mercenary according to Wikipedia!)?

The recent travails of Black water and the attendant media frenzy further blur the distinction between what is and is not a mercenary. Or is there a distinction? What's the difference between the operations of a private security team helping to train a police force in Afghanistan and a private security team in Baghdad assigned to protect US diplomats? Both are, usually, armed. Both are populated by former military types, and/or current or former law enforcement officers. Both are in country as a direct result of a critical inability on the part of local government to protect its own borders, institutions, and people.

EXPONENTIAL EXPANSION

Those who employ the modern "mere" shy away from the term mercenary: The post 9-11 world has seen a remarkable expansion of specialized forms of private security contractor, the so-called private military company, or PMC. Blaekwater, Dyneorp, ArmorGroup, Control Risks have expanded the role of private-sector protective security to fill gaps left in Iraq, Bosnia, Afghanistan and elsewhere. This has led to some interesting and controversial exploits having implications for the security profession.

It has also led to less controversial — as judged by the media and many American politicians, who need little reason to fault US government, US corporations, and certainly anyone who bears arms for a living — but spectacularly horrifying deaths — of PMC employees, Blaekwater, for example — whereas only alleged deaths at the hands of Blaekwater rate non-stop media scrutiny and Congressional eondem nation. Was there a Senate hearing when four American Blaekwater team members were slaughtered and burned in Fallujah? If so, I blinked and missed it entirely.

CONSULTANT VS MERCENARY

The rise of the private security company in emerging nations, war zones and high-risk areas has created a new breed of private soldiers, armed mercenaries, security guards, and companies who have the license to resort to full-scale violence if attacked. But are they the same people? Are all  those disciplines fairly and accurately lumped together? When does a private security contractor providing protective or intelligence services in emerging markets to an MNC (sorry, multi-national corporation) cease being a consultant and become a mercenary? Is it a matter of intent? Does the identity or nationality of the MNC matter?

In the eyes of many "they" constitute freelance and mostly unregulated warriors who operate with, at best, murky legal restraint. (Wise elders in the US Congress recently passed legislation placing any such PMC, of US origin, under the laws of the United States). The commercial provision of an armed force has become a standard way of doing business, as well as the potential for creating a supplemental tool of foreign policy. This isn't a new idea; you only have to know the history of American business, and note the private security amis of economic icons such as Ford, or, on behalf of US agri-businesses in Central America in the late twenties, the US Marine Corps, to realize our government has influenced public policy with such means, internally and externally, for well over a hundred years.

Is there a need to find a proper place for "PMC" organizations? Does congressional oversight help? Was it ever? What's the impact, if any, on the security profession?

In the next installment we'll break this out further and interview several real people whose mercenary actions are the sum and substance of the debate and the center of the controversy.


SNIPER SCHOOL - LONG RANGE SHOOTING

sniper school long range shooting rifle scopes

EVERYTHING YOU NEED TO GET STARTED IN LONG-RANGE SHOOTING

BY KEVIN ESTELA

Long-range marksmanship is more than dropping down behind a scoped rifle, getting a sight picture, squeezing the trigger and hitting targets at will.

The more you read, the more you'll learn about breathing control, consistent trigger pulls, body position, reading the wind and discerning its value, density altitude, spin drift and all the other factors that come into play.

Some shooters will become discouraged by all the variables they must consider and never take up long-range shooting. It's wise to understand the challenges you have in front of you before you invest your time, money and energy into a shooting discipline you may not like.

Seek out others who are competent in long-range marksmanship and audit their range session. Take a class where you can borrow a rifle for the course of instruction. Long-range marksmanship is not a casual hobby; you should try before you buy.

THE RIGHT STUFF

Steel sharpens steel, and the rifle you choose to sharpen your skills with is at the heart of long- range shooting. Browse the aisles of gun stores and you'll have more than a few rifles to select from.

The secret lies in finding the rifle that fits you and your long-distance goals. For most, this will mean a bolt-action centerfire rifle in a common long-range caliber such as the .308 Winchester or 6.5 Creedmoor.

The rifle you choose will need to fit you. That is, your rifle should have the appropriate-height cheek rest and length of pull to match your frame and the optic you eventually install.

Speaking of stocks, focus on selecting a rifle with a synthetic stock less likely to be affected by changes in temperature and humidity as wooden counterparts.

Don't fret if your rifle and optic aren't a perfect pair, as you can build up a cheek rest with closed-cell foam and duct tape or purchase a quality after-market model like those from Bradley Cheek Rest made from Kydex.

When you've decided on your rifle, the next major decision is the optic you will become very familiar with for hours on end at the range. There are equally as many choices to decide from.

Front-focal-plane (FFP) or second-focal-plane (SFP) reticle? Mil adjustments or MOA? One inch or 30mm tube? The choices are overwhelming, but remember your goals and think about what choices will make the most sense for you, not someone else.

Ask yourself logical questions. How much magnification do I need? What features help make adjustments to windage and elevation easier? What reticle am I willing to learn and become competent with?

Make sure you don't skimp on the way your expensive optic is mounted to your expensive rifle and invest in a solid mount and precision-ground rings like those from Badger Ordnance.

If you plan on going out to 1,000 yards, a base with 20 minutes of angle (MOA) built in will be appreciated. When you make fewer adjustments at greater distances, you'II thank yourself for thinking ahead and purchasing it.

Weak links in your precision rifle setup are created when corners are cut on quality. Equally important is finding the right ammunition. Barrel twist rates and bullet weights will yield mixed results when combined.

Purchase quality match ammunition from different manufacturers and discover what combination works best. Consider your precision rifle a high-end sports car and feed it premium fuel.

Just shy of reloading your own ammo, you'll find a quality round that performs the best in your rifle; stick with it religiously, and even look for matching lot numbers on the box of ammo for consistency.

The little things follow the big purchases. Look into purchasing a bubble level for your optic as well as a good bipod with an adjustable swivel in case the ground is uneven.

Front and rear shooting bags may also be used, serving to stabilize the rifle. A good padded sling will help you carry your 15-pound rifle, and a solid case like a Pelican 1750 will protect it in transport.

Cleaning and maintenance schedules will vary, but a good one-piece cleaning rod and bore guide are great accessories to have.

SELF-DISCOVERY

Long-range marksmanship requires learning what works best for you. Starting from the prone position, or seated if you have physical limitations, learn and document in a log book what happens to your accuracy when you use different parts of your trigger finger to break each shot.

Use the tip of the first pad, the center and the first joint and determine which provides the best accuracy for you. Think of squeezing the trigger as compressing your fingerprint.

Try placing your thumb on one section of the stock and then another. When you find out which results in the best accuracy, stick with it.

Find out where you should break your shot in your breathing cycle. Are you full-, half- or empty-lung shooter? Again, fire a few strings with each and document your results.

Note how your vision is affected and how clear the reticle is just before you break your shot. Learn what scope magnification you are most comfortable with. Just because your optic maxes out at 25X magnification doesn't mean you should use it for every range.

You may find working with the lowest magnification will yield the best results. There is truth to the maxim "aim small, miss small."

GOOD HABITS

In order to excel in this arena, you need to develop good habits. If you are a blank slate to this type of training, you won't have to erase the bad habits and training scars you may or may not be aware of.

Repeatable long-range accuracy is all about consistency. This is why a log book where you can track all of your data is essential.

What you need to develop for better accuracy is a consistent routine to follow each time you drop behind the rifle.

A sample routine may include lining up your natural point of aim, loading the bipod with forward pressure, placing your cheek straight down on the stock to prevent pushing it right or left, acquiring a sight picture, closing the bolt, checking your bubble level, adjusting your reticle, disengaging the safety, breathing, squeezing the trigger and reacquiring the sight picture after the round is fired.

If that sounds like a lot to do in succession, it is, but it becomes second nature with enough good repetitions. Perform that routine enough times correctly and it will become second nature and habit.

Soon enough, you'll instinctively be able to index where your body belongs on the rifle by where your cheek rests on the stock and where the buttstock slips into the pocket between your shoulder and your pectoral muscle.

FORCES OF NATURE

Of course, you cannot control the environment. While gravity is consistent, wind is not. Learning to read the wind and estimate its speed and value is a skill in itself.

A mild wind at 100 yards might not be as noticeable as it is at 300, 600 and 1,000 yards. Learn what a 5-mph wind feels like on your face and what it does to grass and vegetation.

Notice what wind looks like at ground level, standing height and at the tree line, as your shot may fly through all those different levels.

Density altitude (the combination of barometric pressure, temperature and humidity) is another concern, as it will dictate how easily a bullet will travel through the air.

The best tool to calculate this is a Kestrel Applied Ballistics meter paired with data you’ve collected on your rifle through chronographing and using ballistics tables.

Other environmental factors will affect your performance, including the amount of sunlight, altitude and precipitation.

Track how your rifle performs in all conditions and set up your shot correctly the next time you face similar conditions.

GOOD DATA

At the beginning of each range session, you should always keep track of your cold-bore shot. This will give you an indi­cation where your first round will impact before the barrel becomes fouled.

Fire a five-shot group and track where the center is. Don't be afraid to move your windage or elevation to compensate for a shift from your last session.

Just be careful not to get in the habit of moving your windage and elevation after each shot, as flyers could be the result of user error and not the rifle.

After you’ve spent some considerable time shooting and mastering your rifle’s trigger, l it’s important to challenge yourself. At the Sig Sauer Academy, shooters have to hit hanging price tags at 100 yards.

If you can consistently shoot a one- hole, five-shot group, try putting 10 rounds into a single hole. See what happens when you increase the round count and your time behind the gun.

Speaking of optics, every once in a while, run a box drill to make sure your optic’s adjustments are true.

A box drill will result in shot groups in a square pattern when the shooter aims at the bullseye after adjustments are made in a clockwise or counterclockwise direction.

If only elevation or if only windage is the concern, a line drill should result in holes punched in your target in a straight line.

THE NEXT STEPS

No long-range marksman I know is ever fully satisfied with their performance, rifle or training. This is a constant pursuit of smaller groups and better equipment.

At some point, you will likely upgrade your optic to one with greater magnification, improve your rifle with a detachable magazine or a better stock, and purchase a suppressor.

Eventually, you'II probably start loading your own ammunition, too. When punching holes in paper with no time limit becomes less exciting, you can modify your training to challenge yourself and increase the pressure on your skills.

Different shooting positions, increased distance, decreased time limits, smaller targets and moving targets are all ways to change up your range experience.

One particular challenge I picked up at the Sig Sauer Academy is shooting a swinging price tag at 100 yards. I've heard about practicing until you get it right.

I’ve also heard about prac­ ticing until you never get it wrong. With long-distance marksmanship, the ultimate goal would be a single hole in the absolute dead-center of the target on command.

Since so many factors contribute to thrown shots and enlarged groups, this difficult standard is one many will chase over thousands of rounds. Accuracy is a drug, and long-range accuracy is one of the most addictive. It's never too late to start on your quest for this precision rifle skillset.


LONG RANGE EXPERTS SPEAK

long range sniper scope

KYLE DEFOOR - Professional shooter, retired military operator and sniper with experience in two wars.

Choose quality glass from the big five: Schmidt & Bender, Leopold, Vortex, Nightforce or U.S. Optics.

Pick a max power setting for the caliber you're shooting—10X for the 5.56mm, 15X for the 7.62mm and 20X for the .300 Winchester Magnum and above. A variable-power scope is ideal in my opinion so as not to over-magnify closer targets if applicable.

Focal plane choice is really decided based on what targets you're shooting and if you're at varying distances (first focal plane) or one yard line (second focal plane) only.

Reticle choice is again based on your type of shooting, but it's hard to beat a mil-based reticle. I'd stay away from BDCs since I've never seen them work that well.

Keep your scope setup "same/same," meaning mil/mil or MOA/MOA when it comes to the reticle type and turret adjustments. Mixing the two, as in a mil reticle with MOA turret, makes the process harder in every aspect.

Lastly, pick a mount or rings that are correct in height for your chosen rifle, with consideration of buttstock type and objective lens size versus type of rail. For mounts, I like Bobro; for rings, I like Badger Ordnance or Nightforce.

Also choose a quality stainless steel barrel that is chrome lined. Proven performers include Krieger, Lilja and Douglas. Keep with a twist rate that has been proven for your choice of bullet weight.

Pick quality ammo that is solid. This one is easy: You will never find anything better out there than Black Hills Ammunition.


DAVID HINKELL - Sig Sauer Academy senior instructor, retired Marine, retired state trooper Seek quality professional instruction.

Most folks can only get so far being self-taught. There are some key ingredients to successful scoped rifle and long-range shooting that can more easily be attained through proper and meaningful instruction.

There are many instructors out there and much information. Find a combination that works for you and your needs. Be a good student.

Take copious amounts of quality notes. Learn to keep a good record of your progress. Learn the true fundamentals. Try to apply those funda- mentals to every shot.

Too much emphasis can be placed on equipment in the early stages of this endeavor. Get what you absolutely need. Then, when you start out shooting the equipment through proper application of the fundamentals, upgrade the equipment.

Develop a sound, repeatable, successful "shot process." Just like an athlete getting ready to swing a bat, a golf club or step up to the foul line, have a way that you prepare to take your next shot.

Develop your process, then be consistent with it. Build your rifle and scope to fit you so you're not competing with your gear.

Figure out and record the fine details of your body s position, all pressures applied to the rifle, how you see your reticle and move your trigger. It's all important.


BILL RAPIER - American Tactical Shooting Instruction owner/lead instructor, retired Navy SEAL with over 10 deployments since 9/11.

Get quality instruction. We all probably know multiple guys that have an amazing collection of the latest and greatest firearms but do not know how to properly use them well.

Skip the next "must-have" custom rifle for long-range shooting and instead put that money into quality training. Don't skimp on glass and ammunition. Get a quality scope with a Christmas-tree-type mil reticle and mil adjustments from one of the top companies (I only use Vortex scopes).

I recommend going all mil over MOA because there are simply more binoculars, spotting scopes and riflescopes out there with mil reticles. Buy the best-quality scope you can afford along with good rings.

This, along with quality match ammunition (I run Black Hills ammunition or my own handloads), is foundational if you want to shoot at distance, beyond 600 yards. Finally, get out and train!

Find a spot where you can get some distance and go shoot. Recruit a friend that is interested so that you can spot for each other.

Shoot in different weather conditions, different lighting conditions, different elevations, but most importantly, get out and shoot.


TOM KIER - Sayoc Tactical Group director of operations. Study the different long-range competitions: 1,000-yard Benchrest, F-Class, PRS, etc.

Maybe long-range hunting is what you may be looking for or just going out and seeing what you and your rifle can do for fun. It's all part of long-range shooting, but the gear and training varies.

Start really studying what you can find out there and talk to people already involved in it. Try to get a real idea of the time and money it takes to give it an honest start, and plan out the steps you’ll need to take.

Seek out the top guys in this arena — the guys who have dedi­ cated significant time to becoming who they are in long-range shooting.

Invest in good gear that you can afford to use and maintain. There aren’t any good scopes for long range under $1,500; don’t waste time and money on cheap glass.

As far as rifles, look for something you can get ammo for if you don’t load your own, but get ready to become a precision handloader. This is part of the natural progression.

Understand the caliber and realize the ballistic limitations of what you are investing in; you can outgrow a lot of calibers and rifles.

Invest in spotting scopes, lasers, chronographs and ballis­ tic programs as things progress. Ask a lot of questions and read reviews before you buy any gear.

Finally, practice with each piece of gear and keep good data. Learn to read the conditions. Wind is the hardest part of getting hits at real distances. Every­ thing else can be tracked and calculated accurately through technology.


The Longest Ever Sniper Shot Recorded

longest confirmed kill

By Eduardo Abril de Fontcuberta

DISTANCE: 3,540 METERS

  • Shooter: JTF2 sniper

  • (name withheld), Canada

  • Location: Iraq, May 2017

  • Weapon: McMillan TAC-50

Not much is known about this record, but the team used a McMillan TAC-50 with a modular aluminum Cadex stock (known in Canadian service as the C15A1) and loaded with 750-grain Hornady A-MAX ammo.

The rifle used a Schmidt & Bender PM II scope paired with a TacomHQ Charlie TARAC optical device.

There is a lot of misinformation out there, but reports state that the Joint Task Force 2 sniper was firing from a high-rise during the operation, and the bullet took just under 10 seconds to hit the target.

DISTANCE: 2,475 METERS

  • Shooter: CoH Craig Harrison, UK

  • Location: Afghanistan, November 2009

  • Weapon: Accuracy International L115A3

The record from Corporal of Horse (CoH) Craig Harrison has been covered by a multitude of media outlets, but none has supplied accurate data about it. Even his own book, The Longest Kill, does not discuss the ballistics of the shots.

Harrison made his record-breaking shots after his commander and some Afghan soldiers took fire while patrolling in Helmand Province in November 2009. In his own words, Conditions were perfect, no wind, mild weather, clear visibility.

The first round was a miss, and the second hit a machine gunner in the stomach. He went straight down and didn’t move. The second insurgent grabbed the weapon, and my third shot hit him in the side."

In 2013, I tried to replicate Harrison’s shotsjn an article for Rifle Firepower magazine. I repeated the shots with my own .338 Lapua Magnum rifle, shooting the same Lapua 250-grain Scenar and Lock Base ammunition Harrison used.

In both cases, I found that the optical system was the greatest limitation, even more than the subsonic flight.

DISTANCE: 2,430 METERS

  • Shooter: Corp. Rob Furlong, Canada

  • Location: Afghanistan, March 2002

  • Weapon: McMillan TAC-50

As a member of the 3rd Battalion of Princess Patricia's Canadian Light Infantry during Operation Anaconda in Afghanistans Shah-i-Kot Valley, Furlong witnessed and took aim at three Al-Qaeda fighters armed with a 7.62x39mm RPK machine gun.

Furlongs first 750-grain Hornady A-MAX shot missed the machine-gun-toting insurgent, and his second hit the gunners backpack. The third shot from the McMillan TAC-50 struck the target’s torso and killed him.

DISTANCE: 2,414 METERS

  • Shooter: SAS sniper (name withheld), UK

  • Location: Iraq, May 2017

  • Weapon: CheyTac M200 Intervention

The M200 Intervention in .408 CheyTac was reportedly on loan to the British army as part of a battlefield trial.

The kill shot happened in a classic countersniper oper­ ation in Mosul after a four-hour game of cat and mouse that ended when the ISIS sniper let his guard down as he moved.

DISTANCE: 2,310 METERS

  • Shooter: MCpI Aaron Perry, Canada

  • Location: Afghanistan, March 2002

  • Weapon: McMillan TAC-50

Master Corporal (MCpI) Aaron Perry was a member of a Canadian team of snipers deployed to Afghanistan that supported NATO and Northern Alliance forces during Operation Anaconda.

The six snipers on the team amassed over 20 confirmed kills in a matter of days during the battle.

DISTANCE: 2,300 METERS

  • Shooter: Sgt. Bryan Kremer, U.S. Army

  • Location: Iraq, October 2004

  • Weapon: Barrett M82A1

Sergeant Bryan Kremer’s 1.43-mile shot is the longest made by an American sniper, and it’s impressive considering he was using a Barrett M82A1 rifle with Raufoss Mk 211 ammunition.

I have personally shot thousands of 661-grain Raufoss multipurpose rounds in M82A1s with 4.5-14x50mm scopes, and in my humble opinion, this record is probably the most impressive of the eight records listed here.

DISTANCE: 2,286 METERS

  • Shooter: Gunnery Sergeant Carlos Hatchcock II, USMC

  • Location: Vietnam, February 1967

  • Weapon: Browning M2

Hathcock held the record for the longest confirmed sniper kill for 35 years. The 2,500-yard shot was just one of the 93 confirmed kills Hathcock made during his career.

At one time, the North Vietnamese Army placed a $30,000 bounty on him due to his soon-to-be legendary status as a sniper.

But while every NVA sniper pur­ sued "White Feather," the nickname given to him by NVA and Viet Cong personnel due to his habit of wearing one in his bush hat, none were successful.

The gunnery sergeant’s military career came to an end after his transport unit struck an anti-tank mine. He later passed away in 1999.

DISTANCE: 2,125 METERS

  • Shooter: South African sniper

  • (name withheld), UN

  • Location: Congo, August 2013

  • Weapon: Denel NTW-14.5

This record-breaking shot took place during the Battle of Kibati in the Dem­ ocratic Republic of the Congo.

During the battle, an unnamed South African sniper killed six M23 rebel officers in a single day. His longest kill that day was an amazing 1.32-mile shot using a Denel NTW-14.5 anti-material rifle.

This is the longest confirmed kill ever made with a 14.5x114mm cartridge. The NTW-14.5 is the NTW-20 fitted with the 14.5 series barrel and bolt. It can also chamber the less powerful 20x82mm and 20x110mm rounds.

The rifle is not man portable at approximately 75 pounds, but its 1,026-grain bullet-traveling at 3,300 fps—is quite devastating.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.585321187973 832 1.0046 0


No Amazon API Requests Made.


App Debug - Total Time 1.585321187973 seconds

Number Time From Start Name Description
1 0.45349311828613 Initialise Initialise FSB Function
2 0.45510506629944 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46884918212891 Start of getCategoryListByGroup Function Before first category groups query
4 0.46903109550476 After initial query Before first category groups query
5 0.46903204917908 Get Category List for Group Before the call to getCategoryList function
6 0.46903610229492 Start of GetCategoryList function Start of the function
7 0.46904015541077 Before getting categories Query to get specific category list
8 0.46966409683228 After getting categories Query to get specific category list
9 0.46966600418091 Before getting category custom Before call to function getCategoryCustom
10 0.47175002098083 After getting category custom After call to function getCategoryCustom
11 0.47175312042236 Before getting category custom Before call to function getCategoryCustom
12 0.48340201377869 After getting category custom After call to function getCategoryCustom
13 0.48340511322021 Before getting category custom Before call to function getCategoryCustom
14 0.48950910568237 After getting category custom After call to function getCategoryCustom
15 0.48951101303101 Before getting category custom Before call to function getCategoryCustom
16 0.49382519721985 After getting category custom After call to function getCategoryCustom
17 0.49382710456848 End of GetCategoryList function End of the function
18 0.4938371181488 Get Category List for Group Before the call to getCategoryList function
19 0.49383902549744 Start of GetCategoryList function Start of the function
20 0.49384212493896 Before getting categories Query to get specific category list
21 0.49426102638245 After getting categories Query to get specific category list
22 0.49426198005676 Before getting category custom Before call to function getCategoryCustom
23 0.50015616416931 After getting category custom After call to function getCategoryCustom
24 0.50015902519226 Before getting category custom Before call to function getCategoryCustom
25 0.51154708862305 After getting category custom After call to function getCategoryCustom
26 0.51154899597168 End of GetCategoryList function End of the function
27 0.51155614852905 Get Category List for Group Before the call to getCategoryList function
28 0.511559009552 Start of GetCategoryList function Start of the function
29 0.51156210899353 Before getting categories Query to get specific category list
30 0.51223301887512 After getting categories Query to get specific category list
31 0.51223397254944 Before getting category custom Before call to function getCategoryCustom
32 0.52198505401611 After getting category custom After call to function getCategoryCustom
33 0.52198815345764 Before getting category custom Before call to function getCategoryCustom
34 0.54056620597839 After getting category custom After call to function getCategoryCustom
35 0.54056906700134 Before getting category custom Before call to function getCategoryCustom
36 0.5469172000885 After getting category custom After call to function getCategoryCustom
37 0.54691910743713 Before getting category custom Before call to function getCategoryCustom
38 0.55318713188171 After getting category custom After call to function getCategoryCustom
39 0.55318903923035 Before getting category custom Before call to function getCategoryCustom
40 0.55989503860474 After getting category custom After call to function getCategoryCustom
41 0.55989813804626 Before getting category custom Before call to function getCategoryCustom
42 0.58329701423645 After getting category custom After call to function getCategoryCustom
43 0.58330011367798 Before getting category custom Before call to function getCategoryCustom
44 0.58758807182312 After getting category custom After call to function getCategoryCustom
45 0.58759117126465 Before getting category custom Before call to function getCategoryCustom
46 0.59242820739746 After getting category custom After call to function getCategoryCustom
47 0.59243011474609 End of GetCategoryList function End of the function
48 0.59244513511658 Get Category List for Group Before the call to getCategoryList function
49 0.59244704246521 Start of GetCategoryList function Start of the function
50 0.59245109558105 Before getting categories Query to get specific category list
51 0.59287309646606 After getting categories Query to get specific category list
52 0.59287405014038 Before getting category custom Before call to function getCategoryCustom
53 0.59515619277954 After getting category custom After call to function getCategoryCustom
54 0.59515810012817 Before getting category custom Before call to function getCategoryCustom
55 0.5975821018219 After getting category custom After call to function getCategoryCustom
56 0.59758400917053 End of GetCategoryList function End of the function
57 0.59759116172791 Get Category List for Group Before the call to getCategoryList function
58 0.59759306907654 Start of GetCategoryList function Start of the function
59 0.59759616851807 Before getting categories Query to get specific category list
60 0.59791302680969 After getting categories Query to get specific category list
61 0.5979151725769 Before getting category custom Before call to function getCategoryCustom
62 0.60341620445251 After getting category custom After call to function getCategoryCustom
63 0.60341811180115 End of GetCategoryList function End of the function
64 0.60342502593994 End of getCategoryListByGroup Function Before return()
65 0.65489816665649 App Controller End End of the App controller (called before the controller of every page)
66 1.0770690441132 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0771641731262 Before Get Options Before the call to getOptions in the tpl class
68 1.486958026886 After Get Options After the call to getOptions in the tpl class
69 1.4875111579895 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.585303068161 Finalizing debug Before the debug is output to the page.
71 1.5853199958801 End of App This is the end of the app logging, final timestamp


Query Debug - 832 Database Queries. Total time 1.0046 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0006 0.00057101249694824
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00019717216491699
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015997886657715
SELECT * FROM `bad_bots`
5 0.0005 0.00054097175598145
SELECT parameter, value FROM parameters
6 0.0002 0.00017595291137695
SET time_zone = 'Europe/London'
7 0.0003 0.00031709671020508
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014209747314453
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011491775512695
delete from cachefiles
10 0.0009 0.00093603134155273
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
11 0.0118 0.011784076690674
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
12 0.0003 0.00025606155395508
SELECT * FROM pages WHERE pagename = ''
13 0.0002 0.00016593933105469
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0006 0.00058412551879883
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0005 0.00052905082702637
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
16 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '49'
17 0.0005 0.00053691864013672
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 
18 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
19 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 (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
20 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
21 0.0001 0.00014209747314453
SELECT * FROM categorygroups WHERE id = '1'
22 0.0036 0.0036320686340332
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
23 0.0003 0.00029492378234863
SELECT id FROM categories WHERE parent_id = '50'
24 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '96'
25 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '97'
26 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '111'
27 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '129'
28 0.0058 0.0058150291442871
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 
29 0.0002 0.0001828670501709
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 
30 0.0003 0.0002901554107666
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 
31 0.0002 0.00022196769714355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
32 0.0001 0.00012993812561035
SELECT * FROM categorygroups WHERE id = '1'
33 0.0027 0.0026512145996094
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
34 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '80'
35 0.0025 0.0025100708007812
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 
36 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
37 0.0001 0.00014805793762207
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 
38 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
39 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '1'
40 0.0012 0.0011980533599854
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
41 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '51'
42 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
43 0.0019 0.00193190574646
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 
44 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 (101,51)
				  AND p.disabled = 0 
45 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
46 0.0002 0.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
47 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
48 0.0004 0.00039315223693848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
49 0.0025 0.0024819374084473
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
50 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '30'
51 0.0024 0.0024449825286865
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 
52 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
53 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
54 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
55 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '2'
56 0.0052 0.0051939487457275
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
57 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '61'
58 0.0052 0.0052311420440674
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 
59 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 (61)
				  AND p.disabled = 0 
60 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
61 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
62 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '2'
63 0.0006 0.00060915946960449
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
64 0.0044 0.0043709278106689
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
65 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '64'
66 0.0044 0.0044028759002686
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 
67 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 (64)
				  AND p.disabled = 0 
68 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
69 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
70 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
71 0.0088 0.0087511539459229
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
72 0.0003 0.00029492378234863
SELECT id FROM categories WHERE parent_id = '65'
73 0.0088 0.0088169574737549
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 
74 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
75 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
76 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
77 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
78 0.0027 0.0026898384094238
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
79 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '81'
80 0.0027 0.0027060508728027
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 
81 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
82 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
83 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
84 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
85 0.0026 0.0025949478149414
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
86 0.0003 0.00026607513427734
SELECT id FROM categories WHERE parent_id = '31'
87 0.0027 0.0027108192443848
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 
88 0.0002 0.0001518726348877
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 
89 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 (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
90 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
91 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
92 0.0024 0.0024428367614746
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
93 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '66'
94 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '131'
95 0.0031 0.003087043762207
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 
96 0.0002 0.00015783309936523
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 
97 0.0002 0.00015115737915039
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 
98 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
99 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
100 0.0103 0.010258197784424
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
101 0.0003 0.00028491020202637
SELECT id FROM categories WHERE parent_id = '34'
102 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '94'
103 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '98'
104 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '99'
105 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '110'
106 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '130'
107 0.0110 0.011035919189453
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 
108 0.0002 0.00017786026000977
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 
109 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
110 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
111 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
112 0.0017 0.0016951560974121
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
113 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '32'
114 0.0017 0.0016660690307617
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 
115 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
116 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
117 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
118 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
119 0.0019 0.0019350051879883
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
120 0.0003 0.00025677680969238
SELECT id FROM categories WHERE parent_id = '89'
121 0.0020 0.0019547939300537
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 
122 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 (89)
				  AND p.disabled = 0 
123 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
124 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
125 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
126 0.0004 0.00039505958557129
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
127 0.0007 0.00066709518432617
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
128 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '84'
129 0.0007 0.00068497657775879
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 
130 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
131 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
132 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
133 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '17'
134 0.0007 0.00070595741271973
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
135 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '90'
136 0.0008 0.00081300735473633
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 
137 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
138 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
139 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
140 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
141 0.0003 0.00030303001403809
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0022 0.0022239685058594
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
143 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '92'
144 0.0024 0.0023541450500488
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 
145 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
146 0.0001 0.00014805793762207
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 
147 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
148 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '20'
149 0.0053 0.0052950382232666
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
150 0.0004 0.00037908554077148
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
151 0.0002 0.0001990795135498
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
152 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
153 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '67'
154 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '82'
155 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '84'
156 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '94'
157 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '116'
158 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '52'
159 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '135'
160 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '245'
161 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '269'
162 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '275'
163 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '280'
164 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '357'
165 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '379'
166 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '401'
167 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '450'
168 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '454'
169 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '457'
170 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
171 0.0002 0.00016379356384277
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
172 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '41'
173 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '43'
174 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '44'
175 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '68'
176 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '80'
177 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '85'
178 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '97'
179 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '107'
180 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '108'
181 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '128'
182 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '133'
183 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '148'
184 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '217'
185 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '228'
186 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '257'
187 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '271'
188 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '286'
189 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '287'
190 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '291'
191 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '380'
192 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '344'
193 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '354'
194 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '363'
195 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '364'
196 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '368'
197 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '369'
198 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '400'
199 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '463'
200 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
201 0.0003 0.00025391578674316
SELECT * FROM pages WHERE id = '66'
202 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '77'
203 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '90'
204 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '414'
205 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '119'
206 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '406'
207 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
208 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '150'
209 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '412'
210 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '162'
211 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '164'
212 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '167'
213 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '180'
214 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '187'
215 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '265'
216 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '268'
217 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '411'
218 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '290'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '413'
220 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '409'
221 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '327'
222 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '336'
223 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '351'
224 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '358'
225 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '360'
226 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '362'
227 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '366'
228 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
229 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '377'
230 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '386'
231 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '408'
232 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '415'
233 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '416'
234 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '419'
235 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '423'
236 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '427'
237 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '428'
238 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '432'
239 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '433'
240 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '436'
241 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '437'
242 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '461'
243 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
244 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
245 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '74'
246 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
247 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '145'
248 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '156'
249 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '407'
250 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '410'
251 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '266'
252 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '316'
253 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '332'
254 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '334'
255 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '367'
256 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '387'
257 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '389'
258 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '397'
259 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '449'
260 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
261 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '42'
262 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
263 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
264 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '95'
265 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '102'
266 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '109'
267 0.0002 0.0002281665802002
SELECT * FROM pages WHERE id = '114'
268 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '121'
269 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '138'
270 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '142'
271 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '62'
272 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '157'
273 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '246'
274 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '276'
275 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '278'
276 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '279'
277 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
278 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '405'
279 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '343'
280 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '345'
281 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '346'
282 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '347'
283 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
284 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '349'
285 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '381'
286 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '392'
287 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '393'
288 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '394'
289 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '395'
290 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '399'
291 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '421'
292 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
293 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '430'
294 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '431'
295 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '434'
296 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '435'
297 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '440'
298 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '441'
299 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '451'
300 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '453'
301 0.0001 0.00014710426330566
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
302 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '146'
303 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '158'
304 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '163'
305 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '293'
306 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '340'
307 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '417'
308 0.0001 0.00014090538024902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
309 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '173'
310 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '181'
311 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '288'
312 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '299'
313 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '300'
314 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '383'
315 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '385'
316 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '438'
317 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '442'
318 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
319 0.0002 0.000244140625
SELECT * FROM pages WHERE id = '103'
320 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '134'
321 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '139'
322 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '143'
323 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '234'
324 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '248'
325 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '260'
326 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '398'
327 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
328 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '61'
329 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '87'
330 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '104'
331 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '115'
332 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '124'
333 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '144'
334 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '151'
335 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '199'
336 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '200'
337 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '304'
338 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '321'
339 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '333'
340 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '350'
341 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '378'
342 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '422'
343 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '425'
344 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '443'
345 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '444'
346 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '445'
347 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '446'
348 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '447'
349 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '448'
350 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '455'
351 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '456'
352 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '459'
353 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '460'
354 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '462'
355 0.0001 0.00014495849609375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
356 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '153'
357 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '182'
358 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '238'
359 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '240'
360 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '242'
361 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '252'
362 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
363 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '262'
364 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '267'
365 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '420'
366 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
367 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
368 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
369 0.0014 0.0013749599456787
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
370 0.0002 0.00017309188842773
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
371 0.0003 0.00025200843811035
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
372 0.0003 0.00026607513427734
SELECT * FROM pages WHERE pagename = ''
373 0.1106 0.11062288284302
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
374 0.0002 0.00024890899658203
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:1560778216;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:1;s:6:\"407595\";i:9;s:6:\"103845\";i:13;s:6:\"406758\";i:16;s:6:\"131163\";i:20;s:6:\"400044\";}}' WHERE id = '181'
375 0.0005 0.0004570484161377
SELECT * FROM products WHERE id IN (398315,407595,103845,406758,131163,400044) ORDER BY FIELD(id, 398315,407595,103845,406758,131163,400044 )
376 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
377 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '398315'
378 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '398315'
379 0.0029 0.0029299259185791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
380 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
381 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0001 0.00013422966003418
UPDATE products SET price = '1999' WHERE id = '398315'
384 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
385 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '407595'
386 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '407595'
387 0.0039 0.0039210319519043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
388 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
389 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
390 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
391 0.0001 0.00013113021850586
UPDATE products SET price = '2497' WHERE id = '407595'
392 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
393 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '103845'
394 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '103845'
395 0.0033 0.0032780170440674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
396 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.00012397766113281
UPDATE products SET price = '14499' WHERE id = '103845'
400 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
401 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '406758'
402 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406758'
403 0.0035 0.00347900390625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
404 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00042319297790527
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00012397766113281
UPDATE products SET price = '2694' WHERE id = '406758'
408 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
409 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '131163'
410 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '131163'
411 0.0026 0.0026259422302246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
412 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.0001220703125
UPDATE products SET price = '20362' WHERE id = '131163'
416 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
417 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '400044'
418 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '400044'
419 0.0028 0.0028030872344971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
420 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00013184547424316
UPDATE products SET price = '16091' WHERE id = '400044'
424 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '398315' ORDER BY timestamp DESC
425 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407595' ORDER BY timestamp DESC
426 0.0003 0.00026392936706543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '103845' ORDER BY timestamp DESC
427 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406758' ORDER BY timestamp DESC
428 0.0003 0.00025010108947754
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '131163' ORDER BY timestamp DESC
429 0.0003 0.00025010108947754
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400044' ORDER BY timestamp DESC
430 0.0423 0.042315006256104
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
431 0.0002 0.00022315979003906
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:1560778217;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:9;s:6:\"103845\";i:12;s:6:\"414188\";i:16;s:6:\"131163\";i:22;s:5:\"43519\";i:3;s:6:\"171938\";}}' WHERE id = '175'
432 0.0004 0.00042581558227539
SELECT * FROM products WHERE id IN (290575,103845,414188,131163,43519,171938) ORDER BY FIELD(id, 290575,103845,414188,131163,43519,171938 )
433 0.0006 0.00057816505432129
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
434 0.0002 0.00023078918457031
SELECT * FROM product_image_select WHERE product_id = '290575'
435 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '290575'
436 0.0035 0.0034701824188232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
437 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
438 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
439 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440 0.0001 0.0001220703125
UPDATE products SET price = '549500' WHERE id = '290575'
441 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
442 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '103845'
443 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '103845'
444 0.0024 0.0023958683013916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
445 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
446 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
447 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
448 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
449 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
450 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414188'
451 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
452 0.0026 0.0025558471679688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
453 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
454 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
455 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
456 0.0001 0.00012707710266113
UPDATE products SET price = '9999' WHERE id = '414188'
457 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
458 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '131163'
459 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '131163'
460 0.0026 0.0025639533996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
461 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
462 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
463 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
464 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
465 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
466 0.0002 0.00019979476928711
SELECT * FROM product_image_select WHERE product_id = '43519'
467 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '43519'
468 0.0027 0.0027151107788086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
469 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
470 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
471 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
472 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
473 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
474 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
475 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
476 0.0026 0.0025680065155029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
477 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
478 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
479 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
480 0.0001 0.00011897087097168
UPDATE products SET price = '389500' WHERE id = '171938'
481 0.0003 0.00029802322387695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290575' ORDER BY timestamp DESC
482 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '103845' ORDER BY timestamp DESC
483 0.0003 0.00026893615722656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414188' ORDER BY timestamp DESC
484 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '131163' ORDER BY timestamp DESC
485 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '43519' ORDER BY timestamp DESC
486 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '171938' ORDER BY timestamp DESC
487 0.0422 0.042233943939209
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
488 0.0002 0.00022006034851074
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:1560778217;s:8:\"products\";a:6:{i:10;s:6:\"370121\";i:13;s:6:\"406758\";i:17;s:6:\"410949\";i:2;s:6:\"290575\";i:3;s:6:\"171938\";i:4;s:6:\"410588\";}}' WHERE id = '177'
489 0.0004 0.00043487548828125
SELECT * FROM products WHERE id IN (370121,406758,410949,290575,171938,410588) ORDER BY FIELD(id, 370121,406758,410949,290575,171938,410588 )
490 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
491 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '370121'
492 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '370121'
493 0.0028 0.002769947052002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
494 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
495 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
496 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0001 0.00011992454528809
UPDATE products SET price = '9899' WHERE id = '370121'
498 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
499 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '406758'
500 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '406758'
501 0.0026 0.002640962600708
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
502 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
503 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
505 0.0001 0.0001218318939209
UPDATE products SET price = '2694' WHERE id = '406758'
506 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
507 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '410949'
508 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
509 0.0026 0.0026419162750244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
510 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
511 0.0002 0.00020122528076172
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
512 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
513 0.0001 0.00012803077697754
UPDATE products SET price = '47995' WHERE id = '410949'
514 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
515 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '290575'
516 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '290575'
517 0.0034 0.0034010410308838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
518 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
519 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0001 0.00012111663818359
UPDATE products SET price = '549500' WHERE id = '290575'
522 0.0006 0.00061297416687012
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
523 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '171938'
524 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
525 0.0026 0.0025568008422852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
526 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
527 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
528 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
529 0.0001 0.00012087821960449
UPDATE products SET price = '389500' WHERE id = '171938'
530 0.0002 0.00017905235290527
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
531 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '410588'
532 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '410588'
533 0.0020 0.002000093460083
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
534 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
535 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
536 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
537 0.0001 0.00012087821960449
UPDATE products SET price = '269999' WHERE id = '410588'
538 0.0003 0.00029897689819336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '370121' ORDER BY timestamp DESC
539 0.0003 0.00027012825012207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406758' ORDER BY timestamp DESC
540 0.0003 0.00026702880859375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410949' ORDER BY timestamp DESC
541 0.0003 0.00025582313537598
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290575' ORDER BY timestamp DESC
542 0.0002 0.00024986267089844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '171938' ORDER BY timestamp DESC
543 0.0003 0.00025105476379395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410588' ORDER BY timestamp DESC
544 0.1028 0.10283899307251
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
545 0.0003 0.00026798248291016
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:1560778217;s:8:\"products\";a:6:{i:3;s:6:\"171938\";i:8;s:6:\"183732\";i:11;s:6:\"414825\";i:12;s:6:\"414188\";i:15;s:6:\"405644\";i:19;s:6:\"406901\";}}' WHERE id = '183'
546 0.0004 0.00044918060302734
SELECT * FROM products WHERE id IN (171938,183732,414825,414188,405644,406901) ORDER BY FIELD(id, 171938,183732,414825,414188,405644,406901 )
547 0.0006 0.00063300132751465
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
548 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
549 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '171938'
550 0.0026 0.0026171207427979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
551 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.0001220703125
UPDATE products SET price = '389500' WHERE id = '171938'
555 0.0002 0.00016283988952637
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
556 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '183732'
557 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '183732'
558 0.0027 0.0026578903198242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
559 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00012087821960449
UPDATE products SET price = '38249' WHERE id = '183732'
563 0.0002 0.00020885467529297
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
564 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '414825'
565 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414825'
566 0.0020 0.0020110607147217
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
567 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00021982192993164
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011920928955078
UPDATE products SET price = '11999' WHERE id = '414825'
571 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
572 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '414188'
573 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414188'
574 0.0026 0.0025739669799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
575 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
579 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
580 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '405644'
581 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '405644'
582 0.0034 0.0033891201019287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
583 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
587 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
588 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '406901'
589 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406901'
590 0.0024 0.0023510456085205
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
591 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
592 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
593 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0001 0.00012016296386719
UPDATE products SET price = '395' WHERE id = '406901'
595 0.0003 0.00029110908508301
SELECT	m.*, COUNT(p.id) as productcount FROM manufacturers m, products p
				WHERE	m.id = p.manufacturer_id
				  AND	m.merge_manufacturer_id = 0
				  AND	p.parent_id	= 0
				  AND	p.enabled	= 1
				  AND	p.hidden	= 0
				  AND   offers > 0
				  AND	m.display_homepage	= 1
				  AND	m.id IN (SELECT manufacturer_id FROM manufacturerimages)
				GROUP BY m.id HAVING COUNT(p.id) > 0 ORDER BY COUNT(p.id) DESC LIMIT 8
596 0.0001 0.00011086463928223
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
597 0.0015 0.0014522075653076
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
598 0.0002 0.00019717216491699
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
599 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = 2
600 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 4
601 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = 12
602 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 10
603 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 7
604 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 18
605 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 28
606 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 13
607 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 3
608 0.0423 0.042320966720581
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
609 0.0002 0.00024104118347168
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:1560778217;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:4;s:6:\"410588\";i:5;s:6:\"404554\";i:7;s:6:\"409759\";i:9;s:6:\"103845\";i:12;s:6:\"414188\";}}' WHERE id = '175'
610 0.0005 0.00047779083251953
SELECT * FROM products WHERE id IN (398315,410588,404554,409759,103845,414188) ORDER BY FIELD(id, 398315,410588,404554,409759,103845,414188 )
611 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
612 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398315'
613 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
614 0.0025 0.0025238990783691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
615 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
616 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
617 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
618 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
619 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
620 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '410588'
621 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '410588'
622 0.0020 0.0020039081573486
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
623 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
624 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0001 0.0001220703125
UPDATE products SET price = '269999' WHERE id = '410588'
627 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
628 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '404554'
629 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404554'
630 0.0034 0.0033919811248779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
631 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
632 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
633 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
634 0.0001 0.00011992454528809
UPDATE products SET price = '399999' WHERE id = '404554'
635 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
636 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '409759'
637 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '409759'
638 0.0028 0.0028080940246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
639 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
640 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0001 0.00012302398681641
UPDATE products SET price = '229000' WHERE id = '409759'
643 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
644 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '103845'
645 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '103845'
646 0.0024 0.0023951530456543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
647 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
648 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
649 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
650 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
651 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
652 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414188'
653 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414188'
654 0.0026 0.0026280879974365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
655 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
656 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
657 0.0004 0.00038981437683105
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
658 0.0001 0.00011920928955078
UPDATE products SET price = '9999' WHERE id = '414188'
659 0.0423 0.042279958724976
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
660 0.0002 0.00022006034851074
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:1560778217;s:8:\"products\";a:6:{i:1;s:6:\"407595\";i:7;s:6:\"409759\";i:14;s:6:\"407620\";i:16;s:6:\"131163\";i:3;s:6:\"171938\";i:5;s:6:\"404554\";}}' WHERE id = '177'
661 0.0004 0.00044584274291992
SELECT * FROM products WHERE id IN (407595,409759,407620,131163,171938,404554) ORDER BY FIELD(id, 407595,409759,407620,131163,171938,404554 )
662 0.0002 0.00023913383483887
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
663 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '407595'
664 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '407595'
665 0.0034 0.0033669471740723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
666 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
667 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
668 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
669 0.0001 0.00012111663818359
UPDATE products SET price = '2497' WHERE id = '407595'
670 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
671 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '409759'
672 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '409759'
673 0.0028 0.0028080940246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
674 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
675 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
676 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
677 0.0001 0.0001218318939209
UPDATE products SET price = '229000' WHERE id = '409759'
678 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
679 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '407620'
680 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407620'
681 0.0023 0.0022859573364258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
682 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
683 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
684 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
685 0.0001 0.00011801719665527
UPDATE products SET price = '20323' WHERE id = '407620'
686 0.0002 0.00023007392883301
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
687 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '131163'
688 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '131163'
689 0.0026 0.0025649070739746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
690 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
691 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
692 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
693 0.0001 0.00012803077697754
UPDATE products SET price = '20362' WHERE id = '131163'
694 0.0006 0.0005948543548584
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
695 0.0002 0.00023221969604492
SELECT * FROM product_image_select WHERE product_id = '171938'
696 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '171938'
697 0.0025 0.0025420188903809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
698 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
699 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
700 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
701 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
702 0.0003 0.00026702880859375
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
703 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '404554'
704 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '404554'
705 0.0034 0.00337815284729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
706 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
707 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
708 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
709 0.0001 0.00012016296386719
UPDATE products SET price = '399999' WHERE id = '404554'
710 0.1030 0.1030490398407
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
711 0.0003 0.00029301643371582
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:1560778217;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:1;s:6:\"407595\";i:4;s:6:\"410588\";i:16;s:6:\"131163\";i:23;s:6:\"398823\";i:2;s:6:\"290575\";}}' WHERE id = '181'
712 0.0005 0.00049281120300293
SELECT * FROM products WHERE id IN (398315,407595,410588,131163,398823,290575) ORDER BY FIELD(id, 398315,407595,410588,131163,398823,290575 )
713 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
714 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '398315'
715 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
716 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
717 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0004 0.00039482116699219
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.00012516975402832
UPDATE products SET price = '1999' WHERE id = '398315'
721 0.0002 0.00022721290588379
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
722 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '407595'
723 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407595'
724 0.0034 0.0033869743347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
725 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.00012087821960449
UPDATE products SET price = '2497' WHERE id = '407595'
729 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
730 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '410588'
731 0.0001 0.0001227855682373
SELECT * FROM productcustomimages WHERE product_id = '410588'
732 0.0020 0.0020010471343994
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
733 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.00011992454528809
UPDATE products SET price = '269999' WHERE id = '410588'
737 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
738 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '131163'
739 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '131163'
740 0.0026 0.0025579929351807
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
741 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00012111663818359
UPDATE products SET price = '20362' WHERE id = '131163'
745 0.0002 0.00016498565673828
SELECT * FROM productimages WHERE product_id = '398823' ORDER BY sortorder ASC
746 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '398823'
747 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '398823'
748 0.0030 0.0030419826507568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398823' AND a.name = n.originalname
749 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398823' AND merchantid = 'ATVPDKIKX0DER'
750 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '398823' AND price > 0
                ORDER BY price ASC LIMIT 1
751 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '398823' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
752 0.0001 0.00011801719665527
UPDATE products SET price = '2150' WHERE id = '398823'
753 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
754 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '290575'
755 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '290575'
756 0.0034 0.0034091472625732
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
757 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
758 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
759 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
760 0.0001 0.00012111663818359
UPDATE products SET price = '549500' WHERE id = '290575'
761 0.1023 0.10227394104004
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
762 0.0003 0.00026893615722656
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:1560778217;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:6;s:6:\"412927\";i:12;s:6:\"414188\";i:21;s:6:\"406913\";i:3;s:6:\"171938\";i:13;s:6:\"406758\";}}' WHERE id = '183'
763 0.0005 0.00046181678771973
SELECT * FROM products WHERE id IN (290575,412927,414188,406913,171938,406758) ORDER BY FIELD(id, 290575,412927,414188,406913,171938,406758 )
764 0.0006 0.00058078765869141
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
765 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '290575'
766 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '290575'
767 0.0034 0.0034329891204834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
768 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00012087821960449
UPDATE products SET price = '549500' WHERE id = '290575'
772 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
773 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '412927'
774 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
775 0.0036 0.0036377906799316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
776 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
777 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
779 0.0001 0.0001220703125
UPDATE products SET price = '199900' WHERE id = '412927'
780 0.0003 0.00026416778564453
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
781 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '414188'
782 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
783 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
784 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
785 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
786 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
787 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
788 0.0002 0.00016903877258301
SELECT * FROM productimages WHERE product_id = '406913' ORDER BY sortorder ASC
789 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '406913'
790 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406913'
791 0.0025 0.002500057220459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406913' AND a.name = n.originalname
792 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406913' AND merchantid = 'ATVPDKIKX0DER'
793 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '406913' AND price > 0
                ORDER BY price ASC LIMIT 1
794 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '406913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
795 0.0001 0.00011801719665527
UPDATE products SET price = '1499' WHERE id = '406913'
796 0.0006 0.00061583518981934
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
797 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '171938'
798 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
799 0.0026 0.0025629997253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
800 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
801 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
803 0.0001 0.00011992454528809
UPDATE products SET price = '389500' WHERE id = '171938'
804 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
805 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '406758'
806 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406758'
807 0.0026 0.0026180744171143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
808 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
809 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
810 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
811 0.0001 0.00011992454528809
UPDATE products SET price = '2694' WHERE id = '406758'
812 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
813 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
814 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
815 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
816 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
817 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
818 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
819 0.0001 0.00012421607971191
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
820 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
821 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
822 0.0009 0.00092482566833496
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
823 0.0003 0.00030183792114258
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
824 0.0003 0.0002901554107666
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
825 0.0004 0.00037598609924316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
826 0.0001 0.00014090538024902
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
829 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
830 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
832 0.0003 0.00029897689819336
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'