Tactical Equipment - Survivalist Equipment

Rifle Scopes :: Tactical Knives :: Stun Guns Online

Zwjpw-ww2 Us Army Normandy D-day M5/m7 Gas Mask Pack Rplica

only $44.90

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

only $5,495.00

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

only $3,889.00

Zeus 336 3-12x50 (60 Hz) Thermal Imaging Weapon Sight, FLIR Tau 2 - 33...

only $3,245.00

XS Sight Systems GL-0003S-5 Dxt Big Dot, Glock 42, 43 from Green Suppl...

$105.19 $103.92

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

only $99.99

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.8034980297089 832 0.8529 0


No Amazon API Requests Made.


App Debug - Total Time 1.8034980297089 seconds

Number Time From Start Name Description
1 0.49035596847534 Initialise Initialise FSB Function
2 0.49194288253784 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50399398803711 Start of getCategoryListByGroup Function Before first category groups query
4 0.50417399406433 After initial query Before first category groups query
5 0.50417494773865 Get Category List for Group Before the call to getCategoryList function
6 0.50418186187744 Start of GetCategoryList function Start of the function
7 0.5041868686676 Before getting categories Query to get specific category list
8 0.50487303733826 After getting categories Query to get specific category list
9 0.50487399101257 Before getting category custom Before call to function getCategoryCustom
10 0.50688600540161 After getting category custom After call to function getCategoryCustom
11 0.50688886642456 Before getting category custom Before call to function getCategoryCustom
12 0.5174548625946 After getting category custom After call to function getCategoryCustom
13 0.51745796203613 Before getting category custom Before call to function getCategoryCustom
14 0.52303886413574 After getting category custom After call to function getCategoryCustom
15 0.52304196357727 Before getting category custom Before call to function getCategoryCustom
16 0.52722787857056 After getting category custom After call to function getCategoryCustom
17 0.52723002433777 End of GetCategoryList function End of the function
18 0.52724003791809 Get Category List for Group Before the call to getCategoryList function
19 0.52724194526672 Start of GetCategoryList function Start of the function
20 0.52724504470825 Before getting categories Query to get specific category list
21 0.52770805358887 After getting categories Query to get specific category list
22 0.52770900726318 Before getting category custom Before call to function getCategoryCustom
23 0.53327393531799 After getting category custom After call to function getCategoryCustom
24 0.53327608108521 Before getting category custom Before call to function getCategoryCustom
25 0.54378890991211 After getting category custom After call to function getCategoryCustom
26 0.54379105567932 End of GetCategoryList function End of the function
27 0.54379796981812 Get Category List for Group Before the call to getCategoryList function
28 0.54379987716675 Start of GetCategoryList function Start of the function
29 0.54380393028259 Before getting categories Query to get specific category list
30 0.54464507102966 After getting categories Query to get specific category list
31 0.5446469783783 Before getting category custom Before call to function getCategoryCustom
32 0.55387592315674 After getting category custom After call to function getCategoryCustom
33 0.55387902259827 Before getting category custom Before call to function getCategoryCustom
34 0.57106590270996 After getting category custom After call to function getCategoryCustom
35 0.57106900215149 Before getting category custom Before call to function getCategoryCustom
36 0.57703900337219 After getting category custom After call to function getCategoryCustom
37 0.57704186439514 Before getting category custom Before call to function getCategoryCustom
38 0.58303594589233 After getting category custom After call to function getCategoryCustom
39 0.58303904533386 Before getting category custom Before call to function getCategoryCustom
40 0.58932495117188 After getting category custom After call to function getCategoryCustom
41 0.5893280506134 Before getting category custom Before call to function getCategoryCustom
42 0.61084389686584 After getting category custom After call to function getCategoryCustom
43 0.61084699630737 Before getting category custom Before call to function getCategoryCustom
44 0.61500287055969 After getting category custom After call to function getCategoryCustom
45 0.6150050163269 Before getting category custom Before call to function getCategoryCustom
46 0.61967802047729 After getting category custom After call to function getCategoryCustom
47 0.61967992782593 End of GetCategoryList function End of the function
48 0.61970591545105 Get Category List for Group Before the call to getCategoryList function
49 0.61970806121826 Start of GetCategoryList function Start of the function
50 0.61971187591553 Before getting categories Query to get specific category list
51 0.62015604972839 After getting categories Query to get specific category list
52 0.62015795707703 Before getting category custom Before call to function getCategoryCustom
53 0.62260985374451 After getting category custom After call to function getCategoryCustom
54 0.62261390686035 Before getting category custom Before call to function getCategoryCustom
55 0.62491989135742 After getting category custom After call to function getCategoryCustom
56 0.62492203712463 End of GetCategoryList function End of the function
57 0.62492895126343 Get Category List for Group Before the call to getCategoryList function
58 0.62493205070496 Start of GetCategoryList function Start of the function
59 0.62493491172791 Before getting categories Query to get specific category list
60 0.62523889541626 After getting categories Query to get specific category list
61 0.62523984909058 Before getting category custom Before call to function getCategoryCustom
62 0.63012385368347 After getting category custom After call to function getCategoryCustom
63 0.63012599945068 End of GetCategoryList function End of the function
64 0.63013195991516 End of getCategoryListByGroup Function Before return()
65 0.68136596679688 App Controller End End of the App controller (called before the controller of every page)
66 1.0335130691528 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0336229801178 Before Get Options Before the call to getOptions in the tpl class
68 1.3760678768158 After Get Options After the call to getOptions in the tpl class
69 1.3766040802002 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.8034770488739 Finalizing debug Before the debug is output to the page.
71 1.8034958839417 End of App This is the end of the app logging, final timestamp


Query Debug - 832 Database Queries. Total time 0.8529 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017809867858887
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044107437133789
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015783309936523
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.0001678466796875
SELECT * FROM `bad_bots`
5 0.0005 0.00045490264892578
SELECT parameter, value FROM parameters
6 0.0001 0.00014591217041016
SET time_zone = 'Europe/London'
7 0.0003 0.00027990341186523
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015902519226074
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001070499420166
delete from cachefiles
10 0.0009 0.0009009838104248
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
11 0.0096 0.0095729827880859
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
12 0.0003 0.00026297569274902
SELECT * FROM pages WHERE pagename = ''
13 0.0002 0.00016117095947266
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0006 0.00058794021606445
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0005 0.00050091743469238
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.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '49'
17 0.0005 0.00047206878662109
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.00015783309936523
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.00016212463378906
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
21 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
22 0.0030 0.0029699802398682
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.00026988983154297
SELECT id FROM categories WHERE parent_id = '50'
24 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '96'
25 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '97'
26 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '111'
27 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '129'
28 0.0056 0.0056359767913818
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.00017595291137695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
30 0.0002 0.00016498565673828
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
32 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
33 0.0023 0.0022668838500977
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '80'
35 0.0023 0.0022881031036377
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.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
37 0.0002 0.00016021728515625
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
39 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '1'
40 0.0011 0.0011448860168457
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.00025701522827148
SELECT id FROM categories WHERE parent_id = '51'
42 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '101'
43 0.0018 0.0017828941345215
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.00015997886657715
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.0002 0.00016283988952637
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
47 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
48 0.0004 0.00042295455932617
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
49 0.0023 0.0022799968719482
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.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
51 0.0023 0.002269983291626
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.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (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.00017976760864258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
55 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '2'
56 0.0047 0.0047180652618408
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.00027298927307129
SELECT id FROM categories WHERE parent_id = '61'
58 0.0047 0.0047421455383301
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.00016593933105469
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.0002 0.00016188621520996
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
61 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
62 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '2'
63 0.0007 0.00067615509033203
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
64 0.0041 0.0040907859802246
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.00027298927307129
SELECT id FROM categories WHERE parent_id = '64'
66 0.0041 0.0040769577026367
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.00016903877258301
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.0002 0.00016117095947266
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
70 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
71 0.0080 0.0080318450927734
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.00028300285339355
SELECT id FROM categories WHERE parent_id = '65'
73 0.0081 0.0080749988555908
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.00017786026000977
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.0002 0.00017213821411133
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
76 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
77 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
78 0.0024 0.0024349689483643
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.00027799606323242
SELECT id FROM categories WHERE parent_id = '81'
80 0.0025 0.0024778842926025
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.00016593933105469
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.0002 0.00016021728515625
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
84 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
85 0.0025 0.0024509429931641
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.00027608871459961
SELECT id FROM categories WHERE parent_id = '31'
87 0.0025 0.0024769306182861
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.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
89 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
90 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
91 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
92 0.0022 0.0022170543670654
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '66'
94 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '131'
95 0.0028 0.0028009414672852
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.00017094612121582
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.00016212463378906
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
98 0.0002 0.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
99 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
100 0.0093 0.0092990398406982
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.00029897689819336
SELECT id FROM categories WHERE parent_id = '34'
102 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '94'
103 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '98'
104 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '99'
105 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '110'
106 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '130'
107 0.0100 0.0099658966064453
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.00018191337585449
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.0001680850982666
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.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
111 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '10'
112 0.0015 0.0015449523925781
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '32'
114 0.0016 0.0015859603881836
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.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 (32)
				  AND p.disabled = 0 
116 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
117 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
118 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
119 0.0018 0.0018229484558105
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '89'
121 0.0018 0.0018448829650879
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.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
123 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
124 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
125 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
126 0.0004 0.00040388107299805
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
127 0.0007 0.00070095062255859
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.00024700164794922
SELECT id FROM categories WHERE parent_id = '84'
129 0.0007 0.00070786476135254
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.0002 0.00015020370483398
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
131 0.0002 0.00019407272338867
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
133 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '17'
134 0.0007 0.00069284439086914
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.00023698806762695
SELECT id FROM categories WHERE parent_id = '90'
136 0.0007 0.00072002410888672
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
137 0.0001 0.00013995170593262
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.00014114379882812
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
140 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
141 0.0003 0.0002899169921875
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0020 0.0019650459289551
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.00023198127746582
SELECT id FROM categories WHERE parent_id = '92'
144 0.0020 0.0020160675048828
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.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
146 0.0002 0.00015091896057129
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.0001 0.00014781951904297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
148 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '20'
149 0.0051 0.0051350593566895
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
150 0.0004 0.00036787986755371
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
151 0.0002 0.00019001960754395
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
152 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
153 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '67'
154 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '82'
155 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '84'
156 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '94'
157 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '116'
158 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '52'
159 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '135'
160 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '245'
161 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '269'
162 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '275'
163 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '280'
164 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '357'
165 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '379'
166 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '401'
167 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '450'
168 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '454'
169 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '457'
170 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '458'
171 0.0001 0.00014901161193848
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
172 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '41'
173 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '43'
174 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '44'
175 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '68'
176 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '80'
177 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '85'
178 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '97'
179 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '107'
180 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '108'
181 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '128'
182 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '133'
183 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '148'
184 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '217'
185 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
186 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '257'
187 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '271'
188 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '286'
189 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '287'
190 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '291'
191 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '380'
192 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '344'
193 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '354'
194 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '363'
195 0.0002 0.00018978118896484
SELECT * FROM pages WHERE id = '364'
196 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '368'
197 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '369'
198 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '400'
199 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '463'
200 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
201 0.0003 0.00027108192443848
SELECT * FROM pages WHERE id = '66'
202 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '77'
203 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '90'
204 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '414'
205 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '119'
206 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '406'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '149'
208 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '150'
209 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '412'
210 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '162'
211 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '164'
212 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '167'
213 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '180'
214 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '187'
215 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '265'
216 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '268'
217 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '411'
218 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '290'
219 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '413'
220 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '409'
221 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '327'
222 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '336'
223 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '351'
224 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '358'
225 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '360'
226 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '362'
227 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '366'
228 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '370'
229 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '377'
230 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '386'
231 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '408'
232 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '415'
233 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '416'
234 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '419'
235 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '423'
236 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '427'
237 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '428'
238 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '432'
239 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '433'
240 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
241 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '437'
242 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '461'
243 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '464'
244 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
245 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '74'
246 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '137'
247 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '145'
248 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '156'
249 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '407'
250 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '410'
251 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '266'
252 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '316'
253 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '332'
254 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '334'
255 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
256 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '387'
257 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '389'
258 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '397'
259 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '449'
260 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
261 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '42'
262 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '79'
263 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '86'
264 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
265 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '102'
266 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '109'
267 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '114'
268 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '121'
269 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '138'
270 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '142'
271 0.0002 0.00019478797912598
SELECT * FROM pages WHERE id = '62'
272 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '157'
273 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '246'
274 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '276'
275 0.0002 0.00018620491027832
SELECT * FROM pages WHERE id = '278'
276 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '279'
277 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '317'
278 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '405'
279 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '343'
280 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '345'
281 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '346'
282 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '347'
283 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '348'
284 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '349'
285 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '381'
286 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '392'
287 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '393'
288 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '394'
289 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '395'
290 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '399'
291 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '421'
292 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '426'
293 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '430'
294 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '431'
295 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '434'
296 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '435'
297 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '440'
298 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '441'
299 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '451'
300 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '453'
301 0.0001 0.00013518333435059
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
302 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '146'
303 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '158'
304 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '163'
305 0.0002 0.00021886825561523
SELECT * FROM pages WHERE id = '293'
306 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '340'
307 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '417'
308 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
309 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '173'
310 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '181'
311 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '288'
312 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '299'
313 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '300'
314 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '383'
315 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '385'
316 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '438'
317 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '442'
318 0.0001 0.00013494491577148
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
319 0.0002 0.00024795532226562
SELECT * FROM pages WHERE id = '103'
320 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '134'
321 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '139'
322 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '143'
323 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '234'
324 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '248'
325 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '260'
326 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '398'
327 0.0001 0.00014901161193848
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
328 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '61'
329 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '87'
330 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '104'
331 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '115'
332 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '124'
333 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '144'
334 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '151'
335 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '199'
336 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '200'
337 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '304'
338 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '321'
339 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '333'
340 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '350'
341 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '378'
342 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '422'
343 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '425'
344 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '443'
345 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '444'
346 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '445'
347 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
348 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '447'
349 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '448'
350 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '455'
351 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '456'
352 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '459'
353 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '460'
354 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '462'
355 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
356 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '153'
357 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '182'
358 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '238'
359 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '240'
360 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '242'
361 0.0001 0.00013279914855957
SELECT * FROM pages WHERE id = '252'
362 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '253'
363 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '262'
364 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
365 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '420'
366 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
367 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
368 0.0001 0.00011610984802246
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
369 0.0014 0.0014328956604004
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
370 0.0002 0.00018501281738281
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
371 0.0003 0.00025391578674316
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
372 0.0003 0.00025105476379395
SELECT * FROM pages WHERE pagename = ''
373 0.0820 0.081992864608765
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.0003 0.00026583671569824
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:1561608908;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:3;s:6:\"290575\";i:5;s:6:\"170197\";i:6;s:6:\"185812\";i:17;s:6:\"407620\";i:10;s:6:\"370121\";}}' WHERE id = '181'
375 0.0004 0.00044989585876465
SELECT * FROM products WHERE id IN (407595,290575,170197,185812,407620,370121) ORDER BY FIELD(id, 407595,290575,170197,185812,407620,370121 )
376 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
377 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407595'
378 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407595'
379 0.0033 0.0033040046691895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
380 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
381 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0001 0.00013208389282227
UPDATE products SET price = '2497' WHERE id = '407595'
384 0.0006 0.00056815147399902
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
385 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '290575'
386 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '290575'
387 0.0033 0.0033318996429443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
388 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
389 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
390 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
391 0.0001 0.00011610984802246
UPDATE products SET price = '549500' WHERE id = '290575'
392 0.0007 0.00065708160400391
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
393 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '170197'
394 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '170197'
395 0.0031 0.0031380653381348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
396 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0004 0.00041413307189941
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.0001220703125
UPDATE products SET price = '324500' WHERE id = '170197'
400 0.0006 0.00063395500183105
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
401 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '185812'
402 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '185812'
403 0.0020 0.0019900798797607
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
404 0.0002 0.00017714500427246
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00012087821960449
UPDATE products SET price = '314900' WHERE id = '185812'
408 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
409 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '407620'
410 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '407620'
411 0.0022 0.0022399425506592
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
412 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00011610984802246
UPDATE products SET price = '20323' WHERE id = '407620'
416 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
417 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '370121'
418 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '370121'
419 0.0027 0.002716064453125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
420 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00011515617370605
UPDATE products SET price = '11679' WHERE id = '370121'
424 0.0003 0.00031089782714844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407595' ORDER BY timestamp DESC
425 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290575' ORDER BY timestamp DESC
426 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '170197' ORDER BY timestamp DESC
427 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '185812' ORDER BY timestamp DESC
428 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407620' ORDER BY timestamp DESC
429 0.0003 0.00027084350585938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '370121' ORDER BY timestamp DESC
430 0.0318 0.031761884689331
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.00020503997802734
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:1561608908;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:6;s:6:\"185812\";i:12;s:6:\"414825\";i:17;s:6:\"407620\";i:2;s:6:\"407595\";}}' WHERE id = '175'
432 0.0004 0.0004279613494873
SELECT * FROM products WHERE id IN (290575,171938,185812,414825,407620,407595) ORDER BY FIELD(id, 290575,171938,185812,414825,407620,407595 )
433 0.0006 0.00058221817016602
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
434 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '290575'
435 0.0001 0.00014901161193848
SELECT * FROM productcustomimages WHERE product_id = '290575'
436 0.0034 0.0033800601959229
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.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
438 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
439 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440 0.0001 0.00011801719665527
UPDATE products SET price = '549500' WHERE id = '290575'
441 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
442 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '171938'
443 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
444 0.0025 0.0024809837341309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
445 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
446 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
447 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
448 0.0001 0.00011610984802246
UPDATE products SET price = '388900' WHERE id = '171938'
449 0.0007 0.00065207481384277
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
450 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '185812'
451 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '185812'
452 0.0020 0.0020110607147217
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
453 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
454 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
455 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
456 0.0001 0.00012111663818359
UPDATE products SET price = '314900' WHERE id = '185812'
457 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
458 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '414825'
459 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '414825'
460 0.0020 0.0019991397857666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
461 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
462 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
463 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
464 0.0001 0.00011610984802246
UPDATE products SET price = '11999' WHERE id = '414825'
465 0.0002 0.00019717216491699
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
466 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '407620'
467 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '407620'
468 0.0023 0.0022668838500977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
469 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
470 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
471 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
472 0.0001 0.00012612342834473
UPDATE products SET price = '20323' WHERE id = '407620'
473 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
474 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '407595'
475 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '407595'
476 0.0033 0.0033087730407715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
477 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
478 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
479 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
480 0.0001 0.00012493133544922
UPDATE products SET price = '2497' WHERE id = '407595'
481 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '290575' ORDER BY timestamp DESC
482 0.0003 0.00026297569274902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '171938' ORDER BY timestamp DESC
483 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '185812' ORDER BY timestamp DESC
484 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414825' ORDER BY timestamp DESC
485 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407620' ORDER BY timestamp DESC
486 0.0003 0.00025486946105957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407595' ORDER BY timestamp DESC
487 0.0317 0.031691789627075
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.00020694732666016
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:1561608908;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:11;s:6:\"412382\";i:16;s:6:\"130885\";i:0;s:6:\"414940\";i:2;s:6:\"407595\";i:4;s:6:\"171938\";}}' WHERE id = '177'
489 0.0004 0.00044989585876465
SELECT * FROM products WHERE id IN (398315,412382,130885,414940,407595,171938) ORDER BY FIELD(id, 398315,412382,130885,414940,407595,171938 )
490 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
491 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '398315'
492 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '398315'
493 0.0025 0.0024721622467041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
494 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
495 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
496 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0001 0.00011897087097168
UPDATE products SET price = '1999' WHERE id = '398315'
498 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
499 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '412382'
500 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '412382'
501 0.0020 0.0020301342010498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
502 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
503 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
505 0.0001 0.00011682510375977
UPDATE products SET price = '3199' WHERE id = '412382'
506 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
507 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '130885'
508 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '130885'
509 0.0020 0.0019791126251221
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
510 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
511 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
512 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
513 0.0001 0.0001220703125
UPDATE products SET price = '1521' WHERE id = '130885'
514 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
515 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '414940'
516 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414940'
517 0.0032 0.0031960010528564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
518 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
519 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0001 0.00011587142944336
UPDATE products SET price = '4490' WHERE id = '414940'
522 0.0002 0.00022411346435547
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
523 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '407595'
524 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '407595'
525 0.0033 0.0032839775085449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
526 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
527 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
528 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
529 0.0001 0.00011587142944336
UPDATE products SET price = '2497' WHERE id = '407595'
530 0.0006 0.00061917304992676
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
531 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '171938'
532 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
533 0.0025 0.0025110244750977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
534 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
535 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
536 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
537 0.0001 0.00011920928955078
UPDATE products SET price = '388900' WHERE id = '171938'
538 0.0003 0.00030708312988281
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '398315' ORDER BY timestamp DESC
539 0.0003 0.00026082992553711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '412382' ORDER BY timestamp DESC
540 0.0003 0.00026893615722656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '130885' ORDER BY timestamp DESC
541 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414940' ORDER BY timestamp DESC
542 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407595' ORDER BY timestamp DESC
543 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '171938' ORDER BY timestamp DESC
544 0.0819 0.081867933273315
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.0002 0.00024700164794922
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:1561608908;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:5;s:6:\"170197\";i:9;s:6:\"402983\";i:13;s:6:\"414188\";}}' WHERE id = '183'
546 0.0005 0.00045299530029297
SELECT * FROM products WHERE id IN (414940,290575,171938,170197,402983,414188) ORDER BY FIELD(id, 414940,290575,171938,170197,402983,414188 )
547 0.0002 0.0001838207244873
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
548 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '414940'
549 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414940'
550 0.0032 0.0032129287719727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
551 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011897087097168
UPDATE products SET price = '4490' WHERE id = '414940'
555 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
556 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '290575'
557 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '290575'
558 0.0033 0.0033321380615234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
559 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00043582916259766
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011587142944336
UPDATE products SET price = '549500' WHERE id = '290575'
563 0.0006 0.00060391426086426
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
564 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '171938'
565 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
566 0.0025 0.0024819374084473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
567 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00037217140197754
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011682510375977
UPDATE products SET price = '388900' WHERE id = '171938'
571 0.0006 0.00064897537231445
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
572 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '170197'
573 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '170197'
574 0.0031 0.0031239986419678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
575 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00012087821960449
UPDATE products SET price = '324500' WHERE id = '170197'
579 0.0002 0.00018715858459473
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
580 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '402983'
581 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '402983'
582 0.0022 0.002155065536499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
583 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011897087097168
UPDATE products SET price = '10392' WHERE id = '402983'
587 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
588 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414188'
589 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '414188'
590 0.0025 0.0025229454040527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
591 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
592 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
593 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0001 0.00011610984802246
UPDATE products SET price = '9999' WHERE id = '414188'
595 0.0003 0.00027894973754883
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.00011014938354492
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
597 0.0015 0.0014939308166504
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
598 0.0002 0.00020003318786621
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
599 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 2
600 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 4
601 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 12
602 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 10
603 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 7
604 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 18
605 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 28
606 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 13
607 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 3
608 0.0320 0.031982898712158
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.00022196769714355
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:1561608908;s:8:\"products\";a:6:{i:7;s:6:\"410950\";i:9;s:6:\"402983\";i:14;s:6:\"247027\";i:21;s:6:\"406901\";i:4;s:6:\"171938\";i:6;s:6:\"185812\";}}' WHERE id = '175'
610 0.0004 0.0004432201385498
SELECT * FROM products WHERE id IN (410950,402983,247027,406901,171938,185812) ORDER BY FIELD(id, 410950,402983,247027,406901,171938,185812 )
611 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
612 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '410950'
613 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '410950'
614 0.0031 0.0030689239501953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
615 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
616 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
617 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
618 0.0001 0.00011897087097168
UPDATE products SET price = '399999' WHERE id = '410950'
619 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
620 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '402983'
621 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '402983'
622 0.0022 0.0021779537200928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
623 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
624 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0001 0.00012898445129395
UPDATE products SET price = '10392' WHERE id = '402983'
627 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
628 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '247027'
629 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '247027'
630 0.0020 0.002000093460083
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
631 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
632 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
633 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
634 0.0001 0.00011897087097168
UPDATE products SET price = '1492' WHERE id = '247027'
635 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
636 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406901'
637 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406901'
638 0.0023 0.0022799968719482
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
639 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
640 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0001 0.00011801719665527
UPDATE products SET price = '395' WHERE id = '406901'
643 0.0006 0.00062990188598633
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
644 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '171938'
645 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
646 0.0025 0.0024869441986084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
647 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
648 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
649 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
650 0.0001 0.00011682510375977
UPDATE products SET price = '388900' WHERE id = '171938'
651 0.0006 0.00064492225646973
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
652 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '185812'
653 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '185812'
654 0.0020 0.0019910335540771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
655 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
656 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
657 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
658 0.0001 0.00011992454528809
UPDATE products SET price = '314900' WHERE id = '185812'
659 0.0316 0.031629085540771
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.00020217895507812
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:1561608909;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:6;s:6:\"185812\";i:7;s:6:\"410950\";i:15;s:6:\"406758\";}}' WHERE id = '177'
661 0.0004 0.00041985511779785
SELECT * FROM products WHERE id IN (414940,290575,171938,185812,410950,406758) ORDER BY FIELD(id, 414940,290575,171938,185812,410950,406758 )
662 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
663 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414940'
664 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '414940'
665 0.0033 0.0032920837402344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
666 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
667 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
668 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
669 0.0001 0.00011777877807617
UPDATE products SET price = '4490' WHERE id = '414940'
670 0.0006 0.0005800724029541
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
671 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '290575'
672 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '290575'
673 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
674 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
675 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
676 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
677 0.0001 0.00011610984802246
UPDATE products SET price = '549500' WHERE id = '290575'
678 0.0006 0.00063204765319824
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
679 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '171938'
680 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '171938'
681 0.0025 0.0024840831756592
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
682 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
683 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
684 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
685 0.0001 0.00011706352233887
UPDATE products SET price = '388900' WHERE id = '171938'
686 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
687 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '185812'
688 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '185812'
689 0.0020 0.0020079612731934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
690 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
691 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
692 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
693 0.0001 0.00012111663818359
UPDATE products SET price = '314900' WHERE id = '185812'
694 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
695 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '410950'
696 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '410950'
697 0.0031 0.0030579566955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
698 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
699 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
700 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
701 0.0001 0.00011610984802246
UPDATE products SET price = '399999' WHERE id = '410950'
702 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
703 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '406758'
704 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406758'
705 0.0026 0.0025858879089355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
706 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
707 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
708 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
709 0.0001 0.00011610984802246
UPDATE products SET price = '2694' WHERE id = '406758'
710 0.0822 0.082229137420654
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.00027084350585938
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:1561608909;s:8:\"products\";a:6:{i:10;s:6:\"370121\";i:12;s:6:\"414825\";i:16;s:6:\"130885\";i:17;s:6:\"407620\";i:21;s:6:\"406901\";i:9;s:6:\"402983\";}}' WHERE id = '181'
712 0.0005 0.00046300888061523
SELECT * FROM products WHERE id IN (370121,414825,130885,407620,406901,402983) ORDER BY FIELD(id, 370121,414825,130885,407620,406901,402983 )
713 0.0002 0.00019621849060059
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
714 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '370121'
715 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '370121'
716 0.0027 0.0027239322662354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
717 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0004 0.00039219856262207
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.00012922286987305
UPDATE products SET price = '11679' WHERE id = '370121'
721 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
722 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '414825'
723 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '414825'
724 0.0020 0.0019879341125488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
725 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.00011587142944336
UPDATE products SET price = '11999' WHERE id = '414825'
729 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
730 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '130885'
731 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '130885'
732 0.0020 0.0019609928131104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
733 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0003 0.00034618377685547
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.00013184547424316
UPDATE products SET price = '1521' WHERE id = '130885'
737 0.0002 0.00019478797912598
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
738 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407620'
739 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '407620'
740 0.0023 0.002269983291626
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
741 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00011610984802246
UPDATE products SET price = '20323' WHERE id = '407620'
745 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
746 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '406901'
747 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406901'
748 0.0023 0.0022809505462646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
749 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
750 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
751 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
752 0.0001 0.00011801719665527
UPDATE products SET price = '395' WHERE id = '406901'
753 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
754 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '402983'
755 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402983'
756 0.0022 0.0021519660949707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
757 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
758 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
759 0.0003 0.00033998489379883
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
760 0.0001 0.00011801719665527
UPDATE products SET price = '10392' WHERE id = '402983'
761 0.0825 0.082473039627075
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.00026702880859375
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:1561608909;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:5;s:6:\"170197\";i:6;s:6:\"185812\";i:10;s:6:\"370121\";i:17;s:6:\"407620\";}}' WHERE id = '183'
763 0.0005 0.00046801567077637
SELECT * FROM products WHERE id IN (407595,171938,170197,185812,370121,407620) ORDER BY FIELD(id, 407595,171938,170197,185812,370121,407620 )
764 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
765 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '407595'
766 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '407595'
767 0.0033 0.0033299922943115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
768 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00013399124145508
UPDATE products SET price = '2497' WHERE id = '407595'
772 0.0006 0.00060701370239258
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
773 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '171938'
774 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '171938'
775 0.0025 0.0024878978729248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
776 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
777 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
779 0.0001 0.00011610984802246
UPDATE products SET price = '388900' WHERE id = '171938'
780 0.0007 0.00065398216247559
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
781 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '170197'
782 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '170197'
783 0.0031 0.0031280517578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
784 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
785 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
786 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
787 0.0001 0.00012087821960449
UPDATE products SET price = '324500' WHERE id = '170197'
788 0.0006 0.00064301490783691
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
789 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '185812'
790 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '185812'
791 0.0020 0.0019850730895996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
792 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
793 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
794 0.0003 0.00034785270690918
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
795 0.0001 0.00012016296386719
UPDATE products SET price = '314900' WHERE id = '185812'
796 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
797 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '370121'
798 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '370121'
799 0.0027 0.0027179718017578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
800 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
801 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
803 0.0001 0.00011587142944336
UPDATE products SET price = '11679' WHERE id = '370121'
804 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
805 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '407620'
806 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407620'
807 0.0023 0.0022621154785156
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
808 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
809 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
810 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
811 0.0001 0.00011706352233887
UPDATE products SET price = '20323' WHERE id = '407620'
812 0.0004 0.00040888786315918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
813 0.0001 0.00012993812561035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
814 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
815 0.0001 0.00011706352233887
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.00011587142944336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
818 0.0004 0.00038719177246094
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
819 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
820 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
821 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
822 0.0009 0.00092506408691406
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
823 0.0003 0.00030398368835449
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
824 0.0003 0.00028610229492188
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
825 0.0004 0.00043010711669922
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
826 0.0002 0.00016093254089355
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.0001378059387207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
829 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
830 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0004 0.00039005279541016
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
832 0.0003 0.00034189224243164
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'