Tactical Equipment - Survivalist Equipment

Rifle Scopes :: Tactical Knives :: Stun Guns Online

UUQ Tactical 3.5-10X40 illuminated Red/Green Mil Dot Rifle Scope W/ Re...

only $39.99

U.S. MARINES Knife Licensed USMC MARINES Assisted Military Knives BLAC...

only $13.56

Tactical Warrior Tanto Full Tang Emergency Outdoor Survival Gear Boot ...

only $6.72

Tactical First Aid Kit: Pac-Kit by First Aid Only 6135 435 Piece Steel...

$110.99 $78.13

SNIPER® 6-24x50 AOE Illuminated Rifle Hunting Sniper Scope by Sniper

only $92.50

Sightmark CJRK Tactical Riflescope QD Mount by Sellmark Corporation

$82.61 $73.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.0705251693726 832 0.4862 0


No Amazon API Requests Made.


App Debug - Total Time 1.0705251693726 seconds

Number Time From Start Name Description
1 0.42169404029846 Initialise Initialise FSB Function
2 0.4225549697876 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43387699127197 Start of getCategoryListByGroup Function Before first category groups query
4 0.43404197692871 After initial query Before first category groups query
5 0.43404316902161 Get Category List for Group Before the call to getCategoryList function
6 0.43404698371887 Start of GetCategoryList function Start of the function
7 0.43405199050903 Before getting categories Query to get specific category list
8 0.43463706970215 After getting categories Query to get specific category list
9 0.43463897705078 Before getting category custom Before call to function getCategoryCustom
10 0.43661499023438 After getting category custom After call to function getCategoryCustom
11 0.4366180896759 Before getting category custom Before call to function getCategoryCustom
12 0.44774198532104 After getting category custom After call to function getCategoryCustom
13 0.44774413108826 Before getting category custom Before call to function getCategoryCustom
14 0.45394396781921 After getting category custom After call to function getCategoryCustom
15 0.45394611358643 Before getting category custom Before call to function getCategoryCustom
16 0.45836901664734 After getting category custom After call to function getCategoryCustom
17 0.45837116241455 End of GetCategoryList function End of the function
18 0.45837998390198 Get Category List for Group Before the call to getCategoryList function
19 0.45838308334351 Start of GetCategoryList function Start of the function
20 0.45838594436646 Before getting categories Query to get specific category list
21 0.45881915092468 After getting categories Query to get specific category list
22 0.45882105827332 Before getting category custom Before call to function getCategoryCustom
23 0.46453499794006 After getting category custom After call to function getCategoryCustom
24 0.46453809738159 Before getting category custom Before call to function getCategoryCustom
25 0.47624206542969 After getting category custom After call to function getCategoryCustom
26 0.47624397277832 End of GetCategoryList function End of the function
27 0.47625112533569 Get Category List for Group Before the call to getCategoryList function
28 0.47625398635864 Start of GetCategoryList function Start of the function
29 0.47625708580017 Before getting categories Query to get specific category list
30 0.47704911231995 After getting categories Query to get specific category list
31 0.47705101966858 Before getting category custom Before call to function getCategoryCustom
32 0.48728799819946 After getting category custom After call to function getCategoryCustom
33 0.48729109764099 Before getting category custom Before call to function getCategoryCustom
34 0.50595903396606 After getting category custom After call to function getCategoryCustom
35 0.50596213340759 Before getting category custom Before call to function getCategoryCustom
36 0.51240801811218 After getting category custom After call to function getCategoryCustom
37 0.51241016387939 Before getting category custom Before call to function getCategoryCustom
38 0.51852607727051 After getting category custom After call to function getCategoryCustom
39 0.51852798461914 Before getting category custom Before call to function getCategoryCustom
40 0.52540016174316 After getting category custom After call to function getCategoryCustom
41 0.52540302276611 Before getting category custom Before call to function getCategoryCustom
42 0.5483570098877 After getting category custom After call to function getCategoryCustom
43 0.54836010932922 Before getting category custom Before call to function getCategoryCustom
44 0.55293607711792 After getting category custom After call to function getCategoryCustom
45 0.55293893814087 Before getting category custom Before call to function getCategoryCustom
46 0.55830001831055 After getting category custom After call to function getCategoryCustom
47 0.55830216407776 End of GetCategoryList function End of the function
48 0.55831503868103 Get Category List for Group Before the call to getCategoryList function
49 0.55831813812256 Start of GetCategoryList function Start of the function
50 0.55832099914551 Before getting categories Query to get specific category list
51 0.55874514579773 After getting categories Query to get specific category list
52 0.55874609947205 Before getting category custom Before call to function getCategoryCustom
53 0.56124114990234 After getting category custom After call to function getCategoryCustom
54 0.56124401092529 Before getting category custom Before call to function getCategoryCustom
55 0.56365299224854 After getting category custom After call to function getCategoryCustom
56 0.56365513801575 End of GetCategoryList function End of the function
57 0.56366109848022 Get Category List for Group Before the call to getCategoryList function
58 0.56366300582886 Start of GetCategoryList function Start of the function
59 0.56366515159607 Before getting categories Query to get specific category list
60 0.56397795677185 After getting categories Query to get specific category list
61 0.56397914886475 Before getting category custom Before call to function getCategoryCustom
62 0.56936311721802 After getting category custom After call to function getCategoryCustom
63 0.56936502456665 End of GetCategoryList function End of the function
64 0.56937098503113 End of getCategoryListByGroup Function Before return()
65 0.62119317054749 App Controller End End of the App controller (called before the controller of every page)
66 0.7814929485321 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.78160405158997 Before Get Options Before the call to getOptions in the tpl class
68 0.93592810630798 After Get Options After the call to getOptions in the tpl class
69 0.93651008605957 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.0705001354218 Finalizing debug Before the debug is output to the page.
71 1.0705230236053 End of App This is the end of the app logging, final timestamp


Query Debug - 832 Database Queries. Total time 0.4862 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016188621520996
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044107437133789
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014615058898926
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015687942504883
SELECT * FROM `bad_bots`
5 0.0004 0.00043797492980957
SELECT parameter, value FROM parameters
6 0.0002 0.00015902519226074
SET time_zone = 'Europe/London'
7 0.0003 0.00028705596923828
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014400482177734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010800361633301
delete from cachefiles
10 0.0008 0.00084400177001953
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
11 0.0094 0.009350061416626
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
12 0.0003 0.00027108192443848
SELECT * FROM pages WHERE pagename = ''
13 0.0002 0.00015020370483398
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0005 0.00051999092102051
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0005 0.00052118301391602
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.00023508071899414
SELECT id FROM categories WHERE parent_id = '49'
17 0.0005 0.00051593780517578
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.00016498565673828
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.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
20 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
21 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
22 0.0031 0.0030910968780518
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.00021600723266602
SELECT id FROM categories WHERE parent_id = '96'
25 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '97'
26 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '111'
27 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
28 0.0062 0.0061759948730469
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
29 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
30 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
31 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
32 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
33 0.0028 0.0028350353240967
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.0002589225769043
SELECT id FROM categories WHERE parent_id = '80'
35 0.0024 0.0024330615997314
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
36 0.0001 0.00014781951904297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
37 0.0001 0.00014519691467285
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
39 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
40 0.0014 0.0013818740844727
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.00025320053100586
SELECT id FROM categories WHERE parent_id = '51'
42 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
43 0.0019 0.0018589496612549
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.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
45 0.0001 0.00014996528625488
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
47 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
48 0.0004 0.00040888786315918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
49 0.0024 0.0023961067199707
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '30'
51 0.0024 0.0023589134216309
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.0001521110534668
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.0001671314239502
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
55 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '2'
56 0.0052 0.0052440166473389
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.00028085708618164
SELECT id FROM categories WHERE parent_id = '61'
58 0.0055 0.00547194480896
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.00016093254089355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
60 0.0001 0.00014781951904297
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
62 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '2'
63 0.0006 0.00064706802368164
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
64 0.0046 0.0045919418334961
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.0002751350402832
SELECT id FROM categories WHERE parent_id = '64'
66 0.0047 0.004662036895752
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.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
68 0.0001 0.00014686584472656
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.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
70 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
71 0.0088 0.008796215057373
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.00029087066650391
SELECT id FROM categories WHERE parent_id = '65'
73 0.0089 0.0088741779327393
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.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
75 0.0001 0.00014996528625488
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
77 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
78 0.0028 0.0027749538421631
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '81'
80 0.0027 0.0027010440826416
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.00015521049499512
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.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
83 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
84 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
85 0.0026 0.0026130676269531
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.00027108192443848
SELECT id FROM categories WHERE parent_id = '31'
87 0.0025 0.0025248527526855
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
88 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
89 0.0002 0.00015687942504883
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
91 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
92 0.0023 0.0023438930511475
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '66'
94 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '131'
95 0.0034 0.0033519268035889
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.00015687942504883
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.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
98 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
99 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '10'
100 0.0100 0.010042905807495
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.00030016899108887
SELECT id FROM categories WHERE parent_id = '34'
102 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '94'
103 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '98'
104 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '99'
105 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '110'
106 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '130'
107 0.0108 0.010792970657349
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.00018095970153809
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.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
110 0.0002 0.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
111 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
112 0.0019 0.0018579959869385
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.00026488304138184
SELECT id FROM categories WHERE parent_id = '32'
114 0.0018 0.0017800331115723
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.0001521110534668
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
116 0.0001 0.00014400482177734
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.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
118 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
119 0.0024 0.002357006072998
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.00025010108947754
SELECT id FROM categories WHERE parent_id = '89'
121 0.0021 0.0020670890808105
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
122 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
123 0.0001 0.00014686584472656
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.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
125 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
126 0.0004 0.00039196014404297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
127 0.0008 0.00076913833618164
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.00023603439331055
SELECT id FROM categories WHERE parent_id = '84'
129 0.0008 0.00080108642578125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
130 0.0001 0.00014495849609375
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.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
132 0.0002 0.00017404556274414
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.00074982643127441
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.0002448558807373
SELECT id FROM categories WHERE parent_id = '90'
136 0.0008 0.00075197219848633
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.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 (90)
				  AND p.disabled = 0 
138 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
139 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
140 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
141 0.0003 0.00029897689819336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0023 0.0023200511932373
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.00024580955505371
SELECT id FROM categories WHERE parent_id = '92'
144 0.0022 0.0021510124206543
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.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
146 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
147 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
148 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
149 0.0052 0.0051701068878174
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
150 0.0004 0.00037217140197754
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
151 0.0002 0.00019407272338867
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.0001678466796875
SELECT * FROM pages WHERE id = '67'
154 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '82'
155 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '84'
156 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '94'
157 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '116'
158 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '52'
159 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '135'
160 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '245'
161 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '269'
162 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '275'
163 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '280'
164 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '357'
165 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '379'
166 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '401'
167 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '450'
168 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '454'
169 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '457'
170 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '458'
171 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
172 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
173 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '43'
174 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '44'
175 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '68'
176 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '80'
177 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '85'
178 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '97'
179 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '107'
180 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '108'
181 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '128'
182 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '133'
183 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
184 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '217'
185 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '228'
186 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '257'
187 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '271'
188 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '286'
189 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
190 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '291'
191 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '380'
192 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '344'
193 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '354'
194 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '363'
195 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '364'
196 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '368'
197 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '369'
198 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '400'
199 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '463'
200 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
201 0.0003 0.00027608871459961
SELECT * FROM pages WHERE id = '66'
202 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '77'
203 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '90'
204 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '414'
205 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '119'
206 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '406'
207 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '149'
208 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '150'
209 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '412'
210 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '162'
211 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '164'
212 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
213 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '180'
214 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '187'
215 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '265'
216 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '268'
217 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '411'
218 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '290'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '413'
220 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '409'
221 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '327'
222 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '336'
223 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '351'
224 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '358'
225 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '360'
226 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '362'
227 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '366'
228 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '370'
229 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '377'
230 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '386'
231 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '408'
232 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '415'
233 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '416'
234 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '419'
235 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '423'
236 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '427'
237 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '428'
238 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '432'
239 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '433'
240 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '436'
241 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '437'
242 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '461'
243 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '464'
244 0.0001 0.00014901161193848
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
245 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '74'
246 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '137'
247 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '145'
248 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '156'
249 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '407'
250 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '410'
251 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '266'
252 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '316'
253 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '332'
254 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '334'
255 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '367'
256 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '387'
257 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '389'
258 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '397'
259 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '449'
260 0.0002 0.00016188621520996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
261 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '42'
262 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
263 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '86'
264 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '95'
265 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '102'
266 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '109'
267 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '114'
268 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '121'
269 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '138'
270 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '142'
271 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '62'
272 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '157'
273 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '246'
274 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '276'
275 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '278'
276 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '279'
277 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '317'
278 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '405'
279 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '343'
280 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
281 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '346'
282 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '347'
283 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
284 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '349'
285 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '381'
286 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '392'
287 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '393'
288 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '394'
289 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '395'
290 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '399'
291 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '421'
292 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
293 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '430'
294 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '431'
295 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '434'
296 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '435'
297 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '440'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '441'
299 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '451'
300 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '453'
301 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
302 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
303 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '158'
304 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '163'
305 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '293'
306 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '340'
307 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '417'
308 0.0001 0.0001370906829834
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
309 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '173'
310 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
311 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '288'
312 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '299'
313 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '300'
314 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '383'
315 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '385'
316 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '438'
317 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '442'
318 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
319 0.0002 0.00023913383483887
SELECT * FROM pages WHERE id = '103'
320 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '134'
321 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '139'
322 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '143'
323 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '234'
324 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '248'
325 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '260'
326 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '398'
327 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
328 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '61'
329 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '87'
330 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
331 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '115'
332 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '124'
333 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '144'
334 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '151'
335 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '199'
336 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '200'
337 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '304'
338 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
339 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '333'
340 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '350'
341 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '378'
342 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '422'
343 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '425'
344 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '443'
345 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '444'
346 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '445'
347 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '446'
348 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '447'
349 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '448'
350 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '455'
351 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '456'
352 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
353 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
354 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '462'
355 0.0001 0.00014686584472656
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
356 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '153'
357 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '182'
358 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '238'
359 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '240'
360 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '242'
361 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '252'
362 0.0001 0.00013208389282227
SELECT * FROM pages WHERE id = '253'
363 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '262'
364 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '267'
365 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '420'
366 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
367 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
368 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
369 0.0015 0.0014610290527344
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
370 0.0002 0.00016212463378906
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid' ORDER BY optionid
371 0.0003 0.00025105476379395
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
372 0.0003 0.00025081634521484
SELECT * FROM pages WHERE pagename = ''
373 0.0132 0.013174057006836
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
374 0.0002 0.00022387504577637
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:1563293374;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:3;s:6:\"117539\";i:4;s:5:\"90837\";i:7;s:6:\"411045\";i:8;s:6:\"411065\";i:10;s:6:\"263846\";}}' WHERE id = '181'
375 0.0004 0.00043582916259766
SELECT * FROM products WHERE id IN (398315,117539,90837,411045,411065,263846) ORDER BY FIELD(id, 398315,117539,90837,411045,411065,263846 )
376 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
377 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398315'
378 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398315'
379 0.0025 0.0024950504302979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
380 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
381 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0001 0.0001218318939209
UPDATE products SET price = '1999' WHERE id = '398315'
384 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
385 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '117539'
386 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '117539'
387 0.0027 0.0026829242706299
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
388 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
389 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
390 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
391 0.0001 0.00011587142944336
UPDATE products SET price = '8699' WHERE id = '117539'
392 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
393 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '90837'
394 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '90837'
395 0.0019 0.0018901824951172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
396 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.00011610984802246
UPDATE products SET price = '9999' WHERE id = '90837'
400 0.0002 0.00017976760864258
SELECT * FROM productimages WHERE product_id = '411045' ORDER BY sortorder ASC
401 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '411045'
402 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '411045'
403 0.0031 0.0031380653381348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411045' AND a.name = n.originalname
404 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '411045' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '411045' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '411045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00012016296386719
UPDATE products SET price = '11500' WHERE id = '411045'
408 0.0002 0.00017619132995605
SELECT * FROM productimages WHERE product_id = '411065' ORDER BY sortorder ASC
409 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '411065'
410 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '411065'
411 0.0024 0.002424955368042
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411065' AND a.name = n.originalname
412 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '411065' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '411065' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '411065' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00011706352233887
UPDATE products SET price = '12390' WHERE id = '411065'
416 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '263846' ORDER BY sortorder ASC
417 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '263846'
418 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '263846'
419 0.0030 0.0030200481414795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263846' AND a.name = n.originalname
420 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '263846' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '263846' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '263846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00011992454528809
UPDATE products SET price = '672' WHERE id = '263846'
424 0.0004 0.00037002563476562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '398315' ORDER BY timestamp DESC
425 0.0003 0.00027704238891602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '117539' ORDER BY timestamp DESC
426 0.0003 0.00026702880859375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '90837' ORDER BY timestamp DESC
427 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411045' ORDER BY timestamp DESC
428 0.0003 0.00025010108947754
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411065' ORDER BY timestamp DESC
429 0.0003 0.00025701522827148
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '263846' ORDER BY timestamp DESC
430 0.0079 0.0079178810119629
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:1563293374;s:8:\"products\";a:6:{i:8;s:6:\"411065\";i:9;s:5:\"53240\";i:13;s:6:\"195608\";i:15;s:6:\"407551\";i:17;s:6:\"404157\";i:22;s:6:\"413570\";}}' WHERE id = '175'
432 0.0004 0.00044798851013184
SELECT * FROM products WHERE id IN (411065,53240,195608,407551,404157,413570) ORDER BY FIELD(id, 411065,53240,195608,407551,404157,413570 )
433 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '411065' ORDER BY sortorder ASC
434 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '411065'
435 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '411065'
436 0.0025 0.0024540424346924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411065' AND a.name = n.originalname
437 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '411065' AND merchantid = 'ATVPDKIKX0DER'
438 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '411065' AND price > 0
                ORDER BY price ASC LIMIT 1
439 0.0004 0.00036215782165527
SELECT value FROM productattributes WHERE product_id = '411065' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440 0.0001 0.00011897087097168
UPDATE products SET price = '12390' WHERE id = '411065'
441 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '53240' ORDER BY sortorder ASC
442 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '53240'
443 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '53240'
444 0.0023 0.0023288726806641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53240' AND a.name = n.originalname
445 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '53240' AND merchantid = 'ATVPDKIKX0DER'
446 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '53240' AND price > 0
                ORDER BY price ASC LIMIT 1
447 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '53240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
448 0.0001 0.00011897087097168
UPDATE products SET price = '8199' WHERE id = '53240'
449 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '195608' ORDER BY sortorder ASC
450 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '195608'
451 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '195608'
452 0.0018 0.0017869472503662
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '195608' AND a.name = n.originalname
453 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '195608' AND merchantid = 'ATVPDKIKX0DER'
454 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '195608' AND price > 0
                ORDER BY price ASC LIMIT 1
455 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '195608' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
456 0.0001 0.00012683868408203
UPDATE products SET price = '3995' WHERE id = '195608'
457 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '407551' ORDER BY sortorder ASC
458 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '407551'
459 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '407551'
460 0.0036 0.0036220550537109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407551' AND a.name = n.originalname
461 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '407551' AND merchantid = 'ATVPDKIKX0DER'
462 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '407551' AND price > 0
                ORDER BY price ASC LIMIT 1
463 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '407551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
464 0.0001 0.00011992454528809
UPDATE products SET price = '10596' WHERE id = '407551'
465 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '404157' ORDER BY sortorder ASC
466 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '404157'
467 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '404157'
468 0.0027 0.0027360916137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404157' AND a.name = n.originalname
469 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '404157' AND merchantid = 'ATVPDKIKX0DER'
470 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '404157' AND price > 0
                ORDER BY price ASC LIMIT 1
471 0.0004 0.00037312507629395
SELECT value FROM productattributes WHERE product_id = '404157' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
472 0.0001 0.00011587142944336
UPDATE products SET price = '7475' WHERE id = '404157'
473 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '413570' ORDER BY sortorder ASC
474 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '413570'
475 0.0001 0.00011777877807617
SELECT * FROM productcustomimages WHERE product_id = '413570'
476 0.0033 0.0032598972320557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413570' AND a.name = n.originalname
477 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '413570' AND merchantid = 'ATVPDKIKX0DER'
478 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '413570' AND price > 0
                ORDER BY price ASC LIMIT 1
479 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '413570' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
480 0.0001 0.00011706352233887
UPDATE products SET price = '79999' WHERE id = '413570'
481 0.0003 0.00029706954956055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411065' ORDER BY timestamp DESC
482 0.0003 0.00026607513427734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '53240' ORDER BY timestamp DESC
483 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '195608' ORDER BY timestamp DESC
484 0.0003 0.00025081634521484
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407551' ORDER BY timestamp DESC
485 0.0003 0.00026488304138184
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '404157' ORDER BY timestamp DESC
486 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413570' ORDER BY timestamp DESC
487 0.0078 0.0077710151672363
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.00020194053649902
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:1563293374;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:1;s:6:\"410951\";i:10;s:6:\"263846\";i:11;s:6:\"106913\";i:22;s:6:\"413570\";i:4;s:5:\"90837\";}}' WHERE id = '177'
489 0.0004 0.00039505958557129
SELECT * FROM products WHERE id IN (398315,410951,263846,106913,413570,90837) ORDER BY FIELD(id, 398315,410951,263846,106913,413570,90837 )
490 0.0002 0.00021815299987793
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
491 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398315'
492 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '398315'
493 0.0025 0.0024869441986084
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.0001828670501709
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
495 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
496 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0001 0.00012898445129395
UPDATE products SET price = '1999' WHERE id = '398315'
498 0.0003 0.00025105476379395
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
499 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '410951'
500 0.0002 0.00016093254089355
SELECT * FROM productcustomimages WHERE product_id = '410951'
501 0.0021 0.0020668506622314
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
502 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
503 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
504 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
505 0.0001 0.00011706352233887
UPDATE products SET price = '94700' WHERE id = '410951'
506 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '263846' ORDER BY sortorder ASC
507 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '263846'
508 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '263846'
509 0.0030 0.0030179023742676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263846' AND a.name = n.originalname
510 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '263846' AND merchantid = 'ATVPDKIKX0DER'
511 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '263846' AND price > 0
                ORDER BY price ASC LIMIT 1
512 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '263846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
513 0.0001 0.00011706352233887
UPDATE products SET price = '672' WHERE id = '263846'
514 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '106913' ORDER BY sortorder ASC
515 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '106913'
516 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '106913'
517 0.0022 0.0021939277648926
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '106913' AND a.name = n.originalname
518 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '106913' AND merchantid = 'ATVPDKIKX0DER'
519 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '106913' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '106913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0001 0.00011706352233887
UPDATE products SET price = '2795' WHERE id = '106913'
522 0.0004 0.00040316581726074
SELECT * FROM productimages WHERE product_id = '413570' ORDER BY sortorder ASC
523 0.0002 0.00024008750915527
SELECT * FROM product_image_select WHERE product_id = '413570'
524 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '413570'
525 0.0032 0.0032131671905518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413570' AND a.name = n.originalname
526 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '413570' AND merchantid = 'ATVPDKIKX0DER'
527 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '413570' AND price > 0
                ORDER BY price ASC LIMIT 1
528 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '413570' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
529 0.0001 0.00014114379882812
UPDATE products SET price = '79999' WHERE id = '413570'
530 0.0004 0.00040197372436523
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
531 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '90837'
532 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '90837'
533 0.0019 0.0018951892852783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
534 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
535 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
536 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
537 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '90837'
538 0.0003 0.00029993057250977
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '398315' ORDER BY timestamp DESC
539 0.0003 0.0002748966217041
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410951' ORDER BY timestamp DESC
540 0.0003 0.00025820732116699
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '263846' ORDER BY timestamp DESC
541 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '106913' ORDER BY timestamp DESC
542 0.0003 0.00025320053100586
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413570' ORDER BY timestamp DESC
543 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '90837' ORDER BY timestamp DESC
544 0.0129 0.012881994247437
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.00021004676818848
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563293374;s:8:\"products\";a:6:{i:2;s:6:\"407089\";i:5;s:6:\"266827\";i:10;s:6:\"263846\";i:12;s:6:\"266847\";i:18;s:6:\"181838\";i:21;s:6:\"178036\";}}' WHERE id = '183'
546 0.0004 0.00042414665222168
SELECT * FROM products WHERE id IN (407089,266827,263846,266847,181838,178036) ORDER BY FIELD(id, 407089,266827,263846,266847,181838,178036 )
547 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '407089' ORDER BY sortorder ASC
548 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407089'
549 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407089'
550 0.0034 0.0033841133117676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407089' AND a.name = n.originalname
551 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '407089' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407089' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '407089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00012803077697754
UPDATE products SET price = '3999' WHERE id = '407089'
555 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '266827' ORDER BY sortorder ASC
556 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '266827'
557 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '266827'
558 0.0023 0.0022530555725098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266827' AND a.name = n.originalname
559 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '266827' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '266827' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '266827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00012612342834473
UPDATE products SET price = '1356' WHERE id = '266827'
563 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '263846' ORDER BY sortorder ASC
564 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '263846'
565 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '263846'
566 0.0030 0.0030179023742676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263846' AND a.name = n.originalname
567 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '263846' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '263846' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '263846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011587142944336
UPDATE products SET price = '672' WHERE id = '263846'
571 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '266847' ORDER BY sortorder ASC
572 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '266847'
573 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '266847'
574 0.0030 0.0030310153961182
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266847' AND a.name = n.originalname
575 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '266847' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '266847' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00042319297790527
SELECT value FROM productattributes WHERE product_id = '266847' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011491775512695
UPDATE products SET price = '7813' WHERE id = '266847'
579 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '181838' ORDER BY sortorder ASC
580 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '181838'
581 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '181838'
582 0.0021 0.0021119117736816
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '181838' AND a.name = n.originalname
583 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '181838' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '181838' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '181838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011992454528809
UPDATE products SET price = '9250' WHERE id = '181838'
587 0.0003 0.00028800964355469
SELECT * FROM productimages WHERE product_id = '178036' ORDER BY sortorder ASC
588 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '178036'
589 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '178036'
590 0.0027 0.0027091503143311
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '178036' AND a.name = n.originalname
591 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '178036' AND merchantid = 'ATVPDKIKX0DER'
592 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '178036' AND price > 0
                ORDER BY price ASC LIMIT 1
593 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '178036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0001 0.00011491775512695
UPDATE products SET price = '7399' WHERE id = '178036'
595 0.0003 0.00028300285339355
SELECT	m.*, COUNT(p.id) as productcount FROM manufacturers m, products p
				WHERE	m.id = p.manufacturer_id
				  AND	m.merge_manufacturer_id = 0
				  AND	p.parent_id	= 0
				  AND	p.enabled	= 1
				  AND	p.hidden	= 0
				  AND   offers > 0
				  AND	m.display_homepage	= 1
				  AND	m.id IN (SELECT manufacturer_id FROM manufacturerimages)
				GROUP BY m.id HAVING COUNT(p.id) > 0 ORDER BY COUNT(p.id) DESC LIMIT 8
596 0.0001 0.00011086463928223
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
597 0.0015 0.0015270709991455
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
598 0.0002 0.00019598007202148
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
599 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = 2
600 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 4
601 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = 12
602 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 10
603 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 7
604 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 18
605 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 28
606 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = 13
607 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 3
608 0.0079 0.0079109668731689
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.00019192695617676
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:1563293374;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:9;s:5:\"53240\";i:11;s:6:\"106913\";i:13;s:6:\"195608\";i:17;s:6:\"404157\";i:20;s:6:\"264565\";}}' WHERE id = '175'
610 0.0004 0.00044798851013184
SELECT * FROM products WHERE id IN (398315,53240,106913,195608,404157,264565) ORDER BY FIELD(id, 398315,53240,106913,195608,404157,264565 )
611 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
612 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398315'
613 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '398315'
614 0.0025 0.0025079250335693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
615 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
616 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
617 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
618 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
619 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '53240' ORDER BY sortorder ASC
620 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '53240'
621 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '53240'
622 0.0022 0.0022461414337158
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53240' AND a.name = n.originalname
623 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '53240' AND merchantid = 'ATVPDKIKX0DER'
624 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '53240' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '53240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0001 0.00012493133544922
UPDATE products SET price = '8199' WHERE id = '53240'
627 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '106913' ORDER BY sortorder ASC
628 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '106913'
629 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '106913'
630 0.0022 0.0022039413452148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '106913' AND a.name = n.originalname
631 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '106913' AND merchantid = 'ATVPDKIKX0DER'
632 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '106913' AND price > 0
                ORDER BY price ASC LIMIT 1
633 0.0004 0.00036215782165527
SELECT value FROM productattributes WHERE product_id = '106913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
634 0.0001 0.00011587142944336
UPDATE products SET price = '2795' WHERE id = '106913'
635 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '195608' ORDER BY sortorder ASC
636 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '195608'
637 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '195608'
638 0.0018 0.0017800331115723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '195608' AND a.name = n.originalname
639 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '195608' AND merchantid = 'ATVPDKIKX0DER'
640 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '195608' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '195608' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0001 0.00011706352233887
UPDATE products SET price = '3995' WHERE id = '195608'
643 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '404157' ORDER BY sortorder ASC
644 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '404157'
645 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '404157'
646 0.0028 0.0027570724487305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404157' AND a.name = n.originalname
647 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '404157' AND merchantid = 'ATVPDKIKX0DER'
648 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '404157' AND price > 0
                ORDER BY price ASC LIMIT 1
649 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '404157' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
650 0.0001 0.00011801719665527
UPDATE products SET price = '7475' WHERE id = '404157'
651 0.0003 0.00034499168395996
SELECT * FROM productimages WHERE product_id = '264565' ORDER BY sortorder ASC
652 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '264565'
653 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '264565'
654 0.0029 0.002877950668335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264565' AND a.name = n.originalname
655 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '264565' AND merchantid = 'ATVPDKIKX0DER'
656 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '264565' AND price > 0
                ORDER BY price ASC LIMIT 1
657 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '264565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
658 0.0001 0.00011992454528809
UPDATE products SET price = '48849' WHERE id = '264565'
659 0.0078 0.0077841281890869
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.0001988410949707
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:1563293374;s:8:\"products\";a:6:{i:3;s:6:\"117539\";i:16;s:6:\"143805\";i:20;s:6:\"264565\";i:23;s:6:\"405719\";i:4;s:5:\"90837\";i:9;s:5:\"53240\";}}' WHERE id = '177'
661 0.0004 0.00041604042053223
SELECT * FROM products WHERE id IN (117539,143805,264565,405719,90837,53240) ORDER BY FIELD(id, 117539,143805,264565,405719,90837,53240 )
662 0.0003 0.00026512145996094
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
663 0.0002 0.00020480155944824
SELECT * FROM product_image_select WHERE product_id = '117539'
664 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '117539'
665 0.0027 0.0026998519897461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
666 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
667 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
668 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
669 0.0001 0.00011801719665527
UPDATE products SET price = '8699' WHERE id = '117539'
670 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '143805' ORDER BY sortorder ASC
671 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '143805'
672 0.0001 0.00011777877807617
SELECT * FROM productcustomimages WHERE product_id = '143805'
673 0.0022 0.002169132232666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '143805' AND a.name = n.originalname
674 0.0002 0.00017786026000977
SELECT * FROM productoffers WHERE product_id = '143805' AND merchantid = 'ATVPDKIKX0DER'
675 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '143805' AND price > 0
                ORDER BY price ASC LIMIT 1
676 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '143805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
677 0.0001 0.00011897087097168
UPDATE products SET price = '10999' WHERE id = '143805'
678 0.0003 0.00032997131347656
SELECT * FROM productimages WHERE product_id = '264565' ORDER BY sortorder ASC
679 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '264565'
680 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '264565'
681 0.0029 0.0028622150421143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264565' AND a.name = n.originalname
682 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '264565' AND merchantid = 'ATVPDKIKX0DER'
683 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '264565' AND price > 0
                ORDER BY price ASC LIMIT 1
684 0.0003 0.00033688545227051
SELECT value FROM productattributes WHERE product_id = '264565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
685 0.0001 0.00011897087097168
UPDATE products SET price = '48849' WHERE id = '264565'
686 0.0003 0.00032877922058105
SELECT * FROM productimages WHERE product_id = '405719' ORDER BY sortorder ASC
687 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '405719'
688 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '405719'
689 0.0024 0.0024490356445312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405719' AND a.name = n.originalname
690 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '405719' AND merchantid = 'ATVPDKIKX0DER'
691 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '405719' AND price > 0
                ORDER BY price ASC LIMIT 1
692 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '405719' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
693 0.0001 0.00012707710266113
UPDATE products SET price = '36200' WHERE id = '405719'
694 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
695 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '90837'
696 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '90837'
697 0.0019 0.0018868446350098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
698 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
699 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
700 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
701 0.0001 0.00011610984802246
UPDATE products SET price = '9999' WHERE id = '90837'
702 0.0002 0.00017809867858887
SELECT * FROM productimages WHERE product_id = '53240' ORDER BY sortorder ASC
703 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '53240'
704 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '53240'
705 0.0022 0.0022389888763428
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53240' AND a.name = n.originalname
706 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '53240' AND merchantid = 'ATVPDKIKX0DER'
707 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '53240' AND price > 0
                ORDER BY price ASC LIMIT 1
708 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '53240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
709 0.0001 0.00011801719665527
UPDATE products SET price = '8199' WHERE id = '53240'
710 0.0129 0.012907028198242
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.0002 0.00020599365234375
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:1563293374;s:8:\"products\";a:6:{i:4;s:5:\"90837\";i:10;s:6:\"263846\";i:12;s:6:\"266847\";i:17;s:6:\"404157\";i:18;s:6:\"181838\";i:19;s:6:\"263829\";}}' WHERE id = '181'
712 0.0004 0.00043416023254395
SELECT * FROM products WHERE id IN (90837,263846,266847,404157,181838,263829) ORDER BY FIELD(id, 90837,263846,266847,404157,181838,263829 )
713 0.0004 0.00038313865661621
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
714 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '90837'
715 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '90837'
716 0.0019 0.0018999576568604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
717 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0003 0.00033998489379883
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '90837'
721 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '263846' ORDER BY sortorder ASC
722 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '263846'
723 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '263846'
724 0.0030 0.0030050277709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263846' AND a.name = n.originalname
725 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '263846' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '263846' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '263846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.00011587142944336
UPDATE products SET price = '672' WHERE id = '263846'
729 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '266847' ORDER BY sortorder ASC
730 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '266847'
731 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '266847'
732 0.0031 0.0030779838562012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266847' AND a.name = n.originalname
733 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '266847' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '266847' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '266847' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.00011706352233887
UPDATE products SET price = '7813' WHERE id = '266847'
737 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '404157' ORDER BY sortorder ASC
738 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '404157'
739 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '404157'
740 0.0027 0.0027310848236084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404157' AND a.name = n.originalname
741 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '404157' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '404157' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '404157' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00011801719665527
UPDATE products SET price = '7475' WHERE id = '404157'
745 0.0003 0.00033283233642578
SELECT * FROM productimages WHERE product_id = '181838' ORDER BY sortorder ASC
746 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '181838'
747 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '181838'
748 0.0021 0.00211501121521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '181838' AND a.name = n.originalname
749 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '181838' AND merchantid = 'ATVPDKIKX0DER'
750 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '181838' AND price > 0
                ORDER BY price ASC LIMIT 1
751 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '181838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
752 0.0001 0.00011706352233887
UPDATE products SET price = '9250' WHERE id = '181838'
753 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '263829' ORDER BY sortorder ASC
754 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '263829'
755 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '263829'
756 0.0022 0.0022351741790771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263829' AND a.name = n.originalname
757 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '263829' AND merchantid = 'ATVPDKIKX0DER'
758 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '263829' AND price > 0
                ORDER BY price ASC LIMIT 1
759 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '263829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
760 0.0001 0.00011610984802246
UPDATE products SET price = '60799' WHERE id = '263829'
761 0.0128 0.012815952301025
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.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:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563293374;s:8:\"products\";a:6:{i:3;s:6:\"117539\";i:7;s:6:\"411045\";i:12;s:6:\"266847\";i:15;s:6:\"407551\";i:20;s:6:\"264565\";i:23;s:6:\"405719\";}}' WHERE id = '183'
763 0.0004 0.00043582916259766
SELECT * FROM products WHERE id IN (117539,411045,266847,407551,264565,405719) ORDER BY FIELD(id, 117539,411045,266847,407551,264565,405719 )
764 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
765 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '117539'
766 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '117539'
767 0.0027 0.0027039051055908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
768 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00011706352233887
UPDATE products SET price = '8699' WHERE id = '117539'
772 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '411045' ORDER BY sortorder ASC
773 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '411045'
774 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '411045'
775 0.0032 0.0031778812408447
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411045' AND a.name = n.originalname
776 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '411045' AND merchantid = 'ATVPDKIKX0DER'
777 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '411045' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '411045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
779 0.0001 0.00011992454528809
UPDATE products SET price = '11500' WHERE id = '411045'
780 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '266847' ORDER BY sortorder ASC
781 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '266847'
782 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '266847'
783 0.0031 0.0030739307403564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '266847' AND a.name = n.originalname
784 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '266847' AND merchantid = 'ATVPDKIKX0DER'
785 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '266847' AND price > 0
                ORDER BY price ASC LIMIT 1
786 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '266847' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
787 0.0001 0.00011920928955078
UPDATE products SET price = '7813' WHERE id = '266847'
788 0.0002 0.0001838207244873
SELECT * FROM productimages WHERE product_id = '407551' ORDER BY sortorder ASC
789 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '407551'
790 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '407551'
791 0.0037 0.0036718845367432
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407551' AND a.name = n.originalname
792 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '407551' AND merchantid = 'ATVPDKIKX0DER'
793 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '407551' AND price > 0
                ORDER BY price ASC LIMIT 1
794 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '407551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
795 0.0001 0.00012111663818359
UPDATE products SET price = '10596' WHERE id = '407551'
796 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '264565' ORDER BY sortorder ASC
797 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '264565'
798 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '264565'
799 0.0033 0.003270149230957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264565' AND a.name = n.originalname
800 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '264565' AND merchantid = 'ATVPDKIKX0DER'
801 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '264565' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '264565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
803 0.0001 0.00012588500976562
UPDATE products SET price = '48849' WHERE id = '264565'
804 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '405719' ORDER BY sortorder ASC
805 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '405719'
806 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '405719'
807 0.0025 0.0024590492248535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405719' AND a.name = n.originalname
808 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '405719' AND merchantid = 'ATVPDKIKX0DER'
809 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '405719' AND price > 0
                ORDER BY price ASC LIMIT 1
810 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '405719' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
811 0.0001 0.00011897087097168
UPDATE products SET price = '36200' WHERE id = '405719'
812 0.0004 0.00039815902709961
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
813 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
814 0.0001 0.00012397766113281
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.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
817 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
818 0.0004 0.0004119873046875
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
819 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
820 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
821 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
822 0.0009 0.00093317031860352
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
823 0.0003 0.00030517578125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
824 0.0003 0.00027608871459961
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
825 0.0004 0.00037598609924316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
826 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
829 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
830 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
832 0.0003 0.00029897689819336
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'