Tactical Equipment - Survivalist Equipment
   

Meopta Meopro 80 HD Spotting Scope Review

Meopta Meopro 80 HD spotting scope review

ABOVE : Peering through a spotting scope changes the way you see the world!

THE FINEST SPOTTING SCOPE Y0U NEVER HEARD OF!

UPDATED :  

This article is about optics, and not even optics that mount to a gun. It's about a spotting scope! Why on earth would I report on anything as mundane as a spotting scope? Pead on the see why the Meopta MeoPro 80 HD Spotting Scopre Review is one great read!

Spotting scope close up of .22 accuracyWhen you try to see .22-caliber bullet holes on a black bull at 200 yards, your optics are strained. Not so with the scope we are reviewing!

Well, for starters, how about the fact that over the past half-century I have owned a host of spotting scopes and found all of them lacking. Some were just marginal while others were like looking through a funhouse peephole.

I know I'm not the only shooter with this problem, because every time I go to the range someone else shows up with a cheap rickety spotting scope that all but ruins his day. It seems like the only ones who don't have the problem are the competitive shooters.

In the past I've paid what I thought was good money to buy inferior optics I've purchased scopes based on their specifications that never panned out. I have bought scopes based on the makers name and reputation, and that did't work, either I have been gifted several spoiling scopes that fell far short of the mark I even tried to acquire a surplus military scope, remembering pleasant experiences on rimfire target ranges.

East German border guards Zeiss binoculars

ABOVE : Americans know the stunning quality of the Zeiss binoculars made for the East German border guards. Meopta optics are on par with them! Their Di6 military binocular has similar features.

On that one I backed off when I discovered it was way too underpowered for my needs. Fine for 50-foot ranges with rimfire rounds and 100 yards with .30 caliber bullets—not so fine at 200 yards and beyond. Over all this time I have perhaps had a dozen spotting scopes, none of which was satisfactory.

What Does a Spotting Scope Do?

A spotting scope is supposed to bring images in the field closer, making them easier to see. You may think it's OK to scan the countryside with the scope on your rifle, but if there are other people around you run the risk of pointing a loaded weapon at them—very precisely! But, hey. no sweat. You're cool with it. You'll keep your finger off the trigger, right?

High quality Meopta spotting scope lensesMeopta lenses meet the highest specifications. So high, in fact, that firms like Hassleblad and Leica use them! Photo provided by Meopta USA.

Unfortunately that's the attitude some shooters take. However, in the course I took in the 1970s to get my German hunting license, I learned that a hunter never does that.

During the two years I hunted in Germany there was only one "accident." It happened when a visiting French hunter shot at a rustling noise in the brush without identifying his quarry first.

Binoculars are useful for some of this viewing, but most binos don't magnify the image sufficiently to see the kind of detail I need to see.

A .22-caliber bullet hole at 200 yards is not that big and you're not going to see it through binoculars—at least not binos you can carry.

A spotting scope is the only tool for the job. There's just one problem. Most spotting scopes being used by American shooters today aren't good enough to see .22 caliber bullet holes at 200 yards. Some can't even do it at 100!

How many times have you seen guys with their el-cheapo spotting scopes, trying to see their target downrange, only to ask for a cease-fire so they can drive down and have a look. Until a few years ago. I was one of them.

I Paid Too Much :: Spotting Scopes Of The Past

My last disappointment was a Celestron C70 Mini Mak spotting scope. Yes, I knew that Celestron sources that telescope from China; they make no attempt to hide the fact. But I reasoned that a prestigious name like Celestron, a company known for high-quality astronomic telescopes. would never sully their reputation with inferior products.

Meopta make high quality opticsWhen the Iron Curtin fell, a lot of talent went looking for work. Meopta had t h e reputation to make lenses and optical packages for the top houses. Photo provided by Meopta USA.

Well, guess again! Apparently their marketing department is full of 30-something hotshots who know how to trade the corporate reputation and inertia for profits today. Its a short game every time, but the people playing it float their resumes before the ship hits the sand! And the "executives" watching over them played the same game when they were younger, so quality goes to hell in a picnic basket.

One day on the 50-yard range I happened by chance to use a friend's Burris 15-45x60 spotting scope, because once more my Celestron was letting me down. The inexpensive Burris shouldn't have been a good scope, but every once in awhile an exceptional one escapes the factory. Lo and behold, this is one of them! I could see my target clearly for the first time!

My friend had recently acquired this scope in a trade, and I made certain he didn't leave the range with it. When I calculated what I traded for it, it came about double what this sub-$200 scope was selling for online. But this particular one was special. It worked.

I had looked through it and pronounced it clear and sharp! I had finally arrived at that point in life where what works is worth whatever it costs. You old silverbacks know what I'm talking about. I have used that scope for several years. Like an accurate gun, I've learned to never get rid of clear optics. Enter Meopta.

Who?

Meopta optical packageEach element in the optical package meets the same demanding standards. Photo provided by Meopta USA

I visited the Meopta booth at the 2016 SHOT Show to meet someone I work with in another capacity. No, I had never heard of them before then. Did I miss a memo? While in their booth I looked through a pair of their MeoStar binoculars and was pleasantly surprised— shocked, really.

It's difficult inside a convention hall to assess the true performance of optics, but you can get a sense of the quality. When you can see flies walking on a ceiling girder 50 yards away, that's an indicator that the glass you're looking through is clear and sharp. I could tell, just by looking at the optical packages, and feeling their weight, that these were quality products.

So, when I got a press release several months after the show, announcing the Outdoor Life magazine editor's choice award for the Meopta 80 HD spotting scope, it was something I had to test. The remainder of this report will concentrate on that scope, but first let's find out about Meopta.

Who is Meopta?

Meopta optics laboratory

ABOVE RIGHT : Meopta uses its high-dollar precision optical manufacturing machinery to make sporting optics, as the schedule permits. Photo provided by Meopta USA.

I interviewed Reinhard Seipp, the general manager and chief operations officer for Meopta USA. He gave me a thumbnail overview of the company.

Meopta was founded in Czechoslovakia in 1933 as a maker of darkroom equipment—enlargers, contact printers and the like. You'll find their early products listed on eBay.

Several of my blog readers are professional photographers who worked during the film era, and they know Meopta enlargers and print equipment very well. They have nothing but praise for everything the company made.

Field testing the Meopta Meopro 80HD

ABOVE LEFT : The equatorial scope mount ring allows rotation of the main tube to position the 45-degree eyepiece anywhere the shooter desires. This one feature makes this scope very convenient to position.

ABOVE RIGHT : I tried the scope on a camera stand clamped to the shooting bench, but it was too flexible. Vibration killed the view!

You will also occasionally find Meopta military binoculars from the eastern block nations for sale online. I have never looked through any of these because they aren't common in this country, but if they are anything like the Zeiss NVA binos made for the East German border guards, they are nearly as fine as the top-branded binoculars on the market today!

Meopta is large. With 2,500-plus employees and almost 1.5 million square feet of production space in New York and the Czech Republic they have a huge footprint in the optics world. How did such a monster come to be? When World War II came, they expanded from purely photographic products into military optics.

Meopta Meopro 80 HD for sale cheap online

ABOVE : The MeoPro 80 HD is real value in a spotting scope. It rivals scopes costing twice as much! Photo provided by Meopta USA.

At the end of the war the iron curtain went up and they found themselves on the communist side. They continued making military optics, and, because the communists had no free trade, they were under no pressure to control costs. The combination of meeting rigid military specifications and a lack of competition meant they were free to turn out the finest optics that could be made, so that's what they did. They made no sporting optics at this time.

Iron Curtain Falls

When the Berlin Wall collapsed in 1989, the company had over 6,000 employees—all suddenly unemployed! Following the fall of communism as a result of the Velvet Revolution, Czechoslovakia became the Czech Republic in 1993, and life became the same "anything for a buck" routine that West Germany endured right after the war.

A powerful spotting scope for long range shooting

ABOVE : When you shoot a .221 Fireball at a target 200 yards away, you need a powerful spotting scope to see the holes. Even a good varmint riflescope isn't enough!

American entrepreneurs started marketing the company's sterling optics capability and soon found willing buyers among the world's best-known houses—places like Leica and Hasselblad!

At first they sold lenses ground to specification, then optical subassemblies and packages. Finally they gained enough respect among their customer base that they were asked to make entire OEM products.

If you are a user of ultra high-end optics you may already have used something made by Meopta without knowing it. Military a n d Industrial Applications Meopta continued to make optics for the military and also for industry. These are their two biggest divisions.

For example, one of their industrial lines makes the high-speed optical scanners that check integrated circuits after manufacture. This work is extremely precise and requires the best optics—way beyond the level of products normally sold to sporting consumers.

A lens-coating station can be purchased for around $60,000 today, but Meopta has several of them that cost $1.5 million each. The difference is seen in the precision of their finished lenses. But most of us will never use their military or industrial products.

The Best Optics You Never Heard Of

In 2007 the Meopta brand of sport optics was introduced to the American market. No wonder no one ever heard of them!

Seriously, Meopta considers itself to be a boutique manufacturer of sport optics, and although they still manufacture high-end sporting OEM products for others, they don't compete with them. They rely on word-of-mouth rather than on advertising, and on the reports written by outdoor sports writers.

Meopro spotting scope focus ringThe focus ring (dark portion) adjusts smoothly from 5 meters to infinity, and the control is there. The black knob (arrow) is the locking screw for the equatorial scope tube ring. The tube can be rotated 360 degrees, making placement of the scope's eyepiece very convenient.

They excel because they have all that high-dollar precision machinery that can be used for sport optics during the downtimes of industrial and military production. They don't care about sales volume in the sport optics line—it's not their major moneymaker. But when they pitch an industrial or military customer, it doesn't hurt to have a stunning, if recent, reputation for quality sporting optics.

They will not compete on price in the marketplace, yet the lack of an advertising budget, coupled with the ability to use ultra-sophisticated optical manufacturing equipment, means they can offer a superior product for a relative bargain price.

Their prices will seem high to the uninitiated (like me), but they actually cost only a fraction of what optics of similar quality sell for. The MeoPro 80 HD I am evaluating for you is particularly outstanding at a street price of $1,500. That's less than half of half of what an equivalent Swarovski spotting scope costs, yet this one offers the same quality. Let's test it!

Meopta MeoPro 80 HD Spotting Scope Description

The first thing you notice is that this spotting scope is heavy. Compared to my 1 lb. 13.5 oz. bantamweight Burris Landmark that magnifies from 15X to 45X and has a 60mm objective lens, the 4 lb. 6.38 oz. Meopta is a light-heavyweight that magnifies from 20X to 60X. And I tested it right up to the limit—something I can only do with the Burris in bright sunlight. The objective lens on the MeoPro is 80 mm, and the weight of the package alone makes me believe the optics are better. They are certainly bigger!

I thought if this scope can give a bright clear image at 60X it would be better than any spotting scope I have ever used. Sure, I've looked through the Zeiss scopes at IWA (the German equivalent of the SHOT Show) but you can't really tell much inside an exhibit hall. I want to see bullet holes at 200 yards.

The MeoPro 80 HD Advantage

Meopta has two lines of sporting optics. The top line is called MeoStar and they have the finest of everything. They are priced at around two-thirds of what competitive brands with identical features sell for.

The MeoStar spotting scope has interchangeable eye-pieces that allow owners to readily change the performance parameters of their scope. While that sounds like something you want, in fact most people never use the feature. They buy the scope and several eyepieces and then use just one eyepiece most of the time. And, this feature comes with a drawback. Besides the higher cost, each optical package has to be sealed to retain the nitrogen gas that's used to prevent fogging of the lenses.

Modern long range spotting scope with smart phone

ABOVE LEFT : My shooting buddy had to look at through the MeoPro scope to see his 200-yard target his bullet holes.

ABOVE RIGHT : The smart phone hangs down from the scope's eyepiece. It takes a sturdy tripod to steady this arrangement.

If the eyepiece can be removed from the scope body, both the scope body and the eyepiece have to have a window on the side where they connect to seal the nitrogen inside. That window is just another piece of glass that does absolutely nothing for the performance of the scope.

For the sportsman on a budget, there is the MeoPro line that is still high quality, but less expensive than the MeoStar. Sometimes, however, less can be more, which it is in this case. That is how the MeoPro 80 HD scope I'm testing garnered that Outdoor Life editor's choice award. With a North American transferable lifetime warranty, it's a bulletproof piece of kit.

By having an integrated eyepiece, the MeoPro 80 HD has two fewer pieces of glass in the optical path, which means greater light transmission. So it's not just cheaer—it's also brighter.

The eyepiece is quite large. The outer diameter is 57mm, much larger than most spotting scope eye pieces. The result is an image you don't have to search for. It's right there and easy to see at all times. On other scopes the exit pupil is so small that the image goes dark if you move your eye just a little, but with this one, you can relax.

Easy to Position :: Form :: Function :: Control

The scope mount base is mounted on a ring around the equator of the scope tube. This allows rotation of the scope tube to position the eyepiece anywhere you want for convenient viewing. A thumbscrew lets you lock the scope in whatever orientation you desire. That makes it so much easier to set up at the range. With the eyepiece set at a 45-degree angle, you can position the scope to allow convenient viewing.

When Using A Spotting Scope, Get a Solid Tripod!

Your tripod or mount needs to be strong and rigid. This is not the place for a $10 bargain tripod, because any shake will ruin the view. I used a professional Bogen model made to support a heavy medium-format camera of similar weight. The stability makes it possible to take pictures through the scope like a telephoto lens.

A captive sunscreen is built into the tube and extends quietly from the objective end. You need it with that 80mm objective, because any sunlight that falls on the objective will dim your image! And both lens caps stay on positively—something the caps on none of my other spotting scopes ever did.

MeoPro 80 HD Razor Sharp Focus Control

Meopta Meopro 80 HD spotting scope for sale

The Centric Drive focus ring wraps around the scope tube. No matter what orientation the scope is in, the focus is always placed conveniently. The ring is turned several rotations for perfect focus. I was able to see images clearly at 60 power as close as 5 meters (16.4 feet)! Few shooters need performance like that, but I write about airguns, and for me the close stuff matters.

At 60 power the depth of field is very short, so it's essential that the scope be solidly mounted. I stress the need for a solid tripod or mount.

One last comment: the 80 HD does not have a fine focus adjustment like the more expensive scopes. This is another area for cost savings, but Meopta compensated for it by making the ring work for both fine and coarse adjustments. It turns slowly until the focus is razor-sharp at all distances inside the broad envelope. You don't need a separate fine-focus adjustment with this ring!

My Evaluation Of Meopta's Spotting Scope

To be perfectly honest, I'm out of my element testing this product. I'm a user—not a testing specialist. I know that the ability to resolve a lot of line pairs per millimeter is one test, but it's one I will never do.

I'm Joe Sixpack. I know what I like, but I don't know all the tests that rank one optic over another. Like 10 percent of men I am red-green colorblind, so the degree of color-correction that I'm certain this scope has is lost on me.

My right eye that I normally use for spotting has recently had the retina completely detached and surgically repaired, so it's not 100 percent, either. The doctor says I see 20/20 through that eye now, but the image it sees still doesn't line up with the left eyes image, and riflescope reticle' lines all appear bent. Enough temporizing! Lets look through the scope.

Hello There! :: First Impressions OF The MeoPro 80 HD

Actual target view of 100 yard shootThis is what the target actually looks like. The hole on the left has three rounds through it. The other two were the first and second shot after cleaning the bore.

The first image I saw through the MeoPro 80 HD at the range during setup was a ripened head of field grass, with something crawling up the right side. When I adjusted the focus, the "something" resolved into an inchworm on a head of grass about 60 yards away. This was on the lowest power.

Low power is the best way to find an object. Then center it and zoom in as much as you want. In bright daylight the images were as clear on 60X as they were on 20X. But I could always see well at 100 yards with my Burris.

The real test came at 200 yards, looking at .22-caliber bullet holes in a black bullseye. I normally don't use a black bull at 200 yards because the holes are impossible to see even in direct sunlight. However, the MeoPro 80 HD changed that.

The 200-yard Spotting Scope Acid Test

The first time I looked out to 200 yards I could see three of four .22-caliber bullet holes in the black bull. It was the first time I've been able to do that, but three out of four is not perfect. However, a surprise was in store.

The second time I had the scope out to the range, my shooting buddy asked if I could please look at his 200 - yard target. He could not see any holes from his .221 Fireball, or from his 7.62x39mm rifles.

Both of these rifles are extremely accurate, so, unless his scope had come loose or failed in some way, they were probably there. I looked and saw them right away. There were three from the Fireball and three more from the 7.62. I described where they were inside the bull.

Then he told me there should have been a fourth .221 hole and I responded that one of the holes looked larger than the others, but not as large as the three 7.62 holes. Wait a minute! I am now describing the difference in size between a two-into-one .22-caliber bullet hole and a .30-caliber bullet hole in a black bullseye 200 yards away with an eye that was blind just 45 days before! I would say that proves the MeoPro can do the work!

After I did that, my friend came over to look for himself. He has a vintage Redfield 20-60X spotting scope that has always trumped other scopes on the range. He bought it for a bargain at a local pawnshop, but this model is so well regarded that it often fetches over $600 online.

Stunning is how I would describe the clarity and sharpness of the images I see through this spotting scope. It's like moving from an arms-room 1911 to one made by Wilson Combat. All the things you hope for when reading a report like this really do come true with this 80 HD spotting scope. Move over Steiner and Leica—there's a new kid in town and he has all your quality at a fraction of the price. Looking to buy the best spotting scope at a discount price, the Meopta MeoPro 80 HD is for you.

Spotting Scopes & Smart Phone Use

Meopta spotting scope phone case adaptorMeopta USA provided the eyepiece adaptor on the left, which had to-be epoxied to the back of a large smart phone case on the right. The glue residue is from the first failed attempt.

Meopta also includes a mount for your smart phone that lets you attach it to the scope. You can watch the target on the screen of your phone instead of looking through the optics! This allows onlookers to see the target along with the shooter. Pictures of the target can also be taken this way.

The spotting scope mount they include is for conventional phones — not the oversized iPhone 6 Plus I have, so I had to do some scrambling to make this feature work. Meopta sent me an adaptor that could be fitted to any size phone case, and I made good use of it.

The first time I tried it I used JB Weld, which is a wonderful epoxy-based product. I didn't get the product to cover the mating surfaces completely, though, plus JB Weld is not specifically recommended for plastics. It held the weight of the phone until I bumped the edge of the phone with my shoulder getting up from the shooting bench. That broke the bond, dropping the phone to the ground. The second time I tried it I roughed up both surfaces to be bonded, then I made several dozen divots in each surface with a dental burr on a rotary tool.

That gave additional surface for the epoxy to bond to, plus if the divots are made deep enough, it gives some mechanical "tooth" or grasp to the bond. This time I used an epoxy from Permatex that's specifically recommended for plastics, and this time the bond held tight for several outings. It's still holding strong as this is written.

Does it Work? :: Taking Video & Photos Through A Spotting Scope

Smart phone spotting scope viewMeopta USA provided the eyepiece adaptor on the left, which had to-be epoxied to the back of a large smart phone case on the right. The glue residue is from the first failed attempt.

Does it work? Can you actually take photographs with a smart phone hooked up to the spotting scope this way? Yes and no. Yes, it is possible to take photos, but no, they aren't of the quality I need for my work.

The smart phone software is automatic, taking control of the image and trying to make sense of it. That works well in some situations, but not in all. Let me show you.

I guess smart phones are fine for selfies and filming brief TV ads, but when you need to control the camera, they fall short. The spotting scope, though, is a high quality optic that I plan to use for pictures.

I will buy a rigid camera mount that can hold my camera steady. That way I can control the process and take full advantage of all that quality with a camera that has manual controls. I have seen what other photographers can do with similar setups and the quality is remarkable.

Not a Complete Test :: Rather An In-Depth Evaluation

I realize that what I did was not a complete test on this particular spotting scope. It's more of an evaluation of the MeoPro 80 HD. And, from the results I can say with confidence, "Yep, that'll do!" I wasn't trying to be scientific or even to be fair. I want to see tiny bullet holes a long way away, the MeoPro 80 HD spotting scope is the best way I've seen to do that.

A spotting scope of this quality will probably not appeal to many shooters, because until you need one this good, you really don't care. I suspect professional hunters and guides already own equivalent scopes. Varmint hunters certainly have them—at least those who are serious.

And, every benchrester alive has a good spotting scope as a part of their kit. Otherwise they are just pulling bullets.

Years ago I learned that to be a good gun writer, I need good equipment. Even airgun writers put their equipment to the test all the time. Over the years I have upgraded my stable of equipment until I have nearly everything I need—until now.

Yes, I paid this Meopta spotting scope the highest compliment a writer can give: I bought it. Each time I see the MeoPro 80 HD it's like seeing the most attractive woman at a party and envying the guy going home with her an instant before realizing she's mine!

Where to Get One :: Right Here!

Maybe this report resonated with you. If you have had my experience with bad spotting scopes and would like to upgrade to the best, you'll find Meopta sporting optics sold right here at Tactical Survivalist, online, discounted and direct to the public.

Thanks

I would like to thank Meopta USA for the opportunity to review this wonderful instrument, and specifically Reinhard Seipp for taking the time to explain both the Meopta history and also the technology behind the scope.


VIDEO REVIEW : Meopta Minute

MeoPro 80HD Spotter & MeoPix iScoping Adapter


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7653739452362 841 1.0003 0


No Amazon API Requests Made.


App Debug - Total Time 1.7653739452362 seconds

Number Time From Start Name Description
1 0.41632008552551 Initialise Initialise FSB Function
2 0.42499494552612 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43620109558105 Start of getCategoryListByGroup Function Before first category groups query
4 0.43636989593506 After initial query Before first category groups query
5 0.43637204170227 Get Category List for Group Before the call to getCategoryList function
6 0.43637609481812 Start of GetCategoryList function Start of the function
7 0.43637990951538 Before getting categories Query to get specific category list
8 0.43695211410522 After getting categories Query to get specific category list
9 0.43695402145386 Before getting category custom Before call to function getCategoryCustom
10 0.43880009651184 After getting category custom After call to function getCategoryCustom
11 0.43880200386047 Before getting category custom Before call to function getCategoryCustom
12 0.44931197166443 After getting category custom After call to function getCategoryCustom
13 0.44931507110596 Before getting category custom Before call to function getCategoryCustom
14 0.45484495162964 After getting category custom After call to function getCategoryCustom
15 0.45484709739685 Before getting category custom Before call to function getCategoryCustom
16 0.4589250087738 After getting category custom After call to function getCategoryCustom
17 0.45892691612244 End of GetCategoryList function End of the function
18 0.45893597602844 Get Category List for Group Before the call to getCategoryList function
19 0.45893812179565 Start of GetCategoryList function Start of the function
20 0.4589409828186 Before getting categories Query to get specific category list
21 0.45935797691345 After getting categories Query to get specific category list
22 0.45935893058777 Before getting category custom Before call to function getCategoryCustom
23 0.46487808227539 After getting category custom After call to function getCategoryCustom
24 0.46488094329834 Before getting category custom Before call to function getCategoryCustom
25 0.47541904449463 After getting category custom After call to function getCategoryCustom
26 0.47542095184326 End of GetCategoryList function End of the function
27 0.47542810440063 Get Category List for Group Before the call to getCategoryList function
28 0.47543001174927 Start of GetCategoryList function Start of the function
29 0.4754331111908 Before getting categories Query to get specific category list
30 0.47613000869751 After getting categories Query to get specific category list
31 0.47613096237183 Before getting category custom Before call to function getCategoryCustom
32 0.48520612716675 After getting category custom After call to function getCategoryCustom
33 0.48520803451538 Before getting category custom Before call to function getCategoryCustom
34 0.50239205360413 After getting category custom After call to function getCategoryCustom
35 0.50239491462708 Before getting category custom Before call to function getCategoryCustom
36 0.50819396972656 After getting category custom After call to function getCategoryCustom
37 0.50819611549377 Before getting category custom Before call to function getCategoryCustom
38 0.51404690742493 After getting category custom After call to function getCategoryCustom
39 0.51405000686646 Before getting category custom Before call to function getCategoryCustom
40 0.52022290229797 After getting category custom After call to function getCategoryCustom
41 0.52022504806519 Before getting category custom Before call to function getCategoryCustom
42 0.54194211959839 After getting category custom After call to function getCategoryCustom
43 0.54194498062134 Before getting category custom Before call to function getCategoryCustom
44 0.54598999023438 After getting category custom After call to function getCategoryCustom
45 0.5459930896759 Before getting category custom Before call to function getCategoryCustom
46 0.55053091049194 After getting category custom After call to function getCategoryCustom
47 0.55054306983948 End of GetCategoryList function End of the function
48 0.55055594444275 Get Category List for Group Before the call to getCategoryList function
49 0.55055904388428 Start of GetCategoryList function Start of the function
50 0.55056190490723 Before getting categories Query to get specific category list
51 0.55097794532776 After getting categories Query to get specific category list
52 0.55097889900208 Before getting category custom Before call to function getCategoryCustom
53 0.55324196815491 After getting category custom After call to function getCategoryCustom
54 0.55324411392212 Before getting category custom Before call to function getCategoryCustom
55 0.55553007125854 After getting category custom After call to function getCategoryCustom
56 0.55553197860718 End of GetCategoryList function End of the function
57 0.55554890632629 Get Category List for Group Before the call to getCategoryList function
58 0.55555105209351 Start of GetCategoryList function Start of the function
59 0.55555391311646 Before getting categories Query to get specific category list
60 0.55586504936218 After getting categories Query to get specific category list
61 0.5558660030365 Before getting category custom Before call to function getCategoryCustom
62 0.56074690818787 After getting category custom After call to function getCategoryCustom
63 0.56074905395508 End of GetCategoryList function End of the function
64 0.56075406074524 End of getCategoryListByGroup Function Before return()
65 0.61006212234497 App Controller End End of the App controller (called before the controller of every page)
66 1.0642731189728 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0643429756165 Before Get Options Before the call to getOptions in the tpl class
68 1.4807441234589 After Get Options After the call to getOptions in the tpl class
69 1.4807910919189 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.7653560638428 Finalizing debug Before the debug is output to the page.
71 1.7653729915619 End of App This is the end of the app logging, final timestamp


Query Debug - 841 Database Queries. Total time 1.0003 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016593933105469
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044989585876465
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00013995170593262
SELECT * FROM `bad_bots`
5 0.0005 0.0004570484161377
SELECT parameter, value FROM parameters
6 0.0002 0.00016212463378906
SET time_zone = 'Europe/London'
7 0.0003 0.0002748966217041
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014305114746094
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011801719665527
delete from cachefiles
10 0.0003 0.00026416778564453
SELECT id FROM pages WHERE pagename = 'meopta-meopro-80-hd-spotting-scope-review' LIMIT 1
11 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = 293
12 0.0008 0.00078511238098145
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0093 0.0092999935150146
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00033688545227051
SELECT * FROM pages WHERE pagename = 'meopta-meopro-80-hd-spotting-scope-review'
15 0.0002 0.0001530647277832
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00053286552429199
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00024199485778809
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043511390686035
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029768943786621
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 50
25 0.0003 0.00025320053100586
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019979476928711
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057051181793213
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022881031036377
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 80
36 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022988319396973
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011460781097412
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017769336700439
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00039315223693848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022859573364258
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022921562194824
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.0047478675842285
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
59 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048420429229736
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00063610076904297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0040 0.0040440559387207
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 64
67 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040819644927979
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
73 0.0080 0.0080268383026123
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 65
74 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081620216369629
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024199485778809
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
81 0.0003 0.00025820732116699
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024540424346924
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0001 0.00014519691467285
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024380683898926
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
88 0.0003 0.0002591609954834
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024678707122803
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.00016021728515625
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014877319335938
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022130012512207
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027961730957031
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.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 (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.009354829788208
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.010279893875122
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 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 (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015299320220947
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
115 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015671253204346
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017900466918945
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018291473388672
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039196014404297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.0006709098815918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068879127502441
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
137 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00071310997009277
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029778480529785
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019688606262207
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020051002502441
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0053079128265381
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037097930908203
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019001960754395
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015521049499512
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '287'
192 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00024008750915527
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '358'
227 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '423'
238 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014686584472656
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017094612121582
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '138'
272 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '434'
298 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00014019012451172
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019121170043945
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0013 0.001345157623291
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00029397010803223
SELECT * FROM pages WHERE pagename = 'meopta-meopro-80-hd-spotting-scope-review'
373 0.0003 0.00026798248291016
SELECT * FROM products WHERE id = '400795'
374 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '400795' ORDER BY sortorder ASC
375 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '400795'
376 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '400795'
377 0.0031 0.0031261444091797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400795' AND a.name = n.originalname
378 0.0002 0.00021815299987793
SELECT * FROM productoffers WHERE product_id = '400795' AND merchantid = 'ATVPDKIKX0DER'
379 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '400795' AND price > 0
                ORDER BY price ASC LIMIT 1
380 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '400795' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381 0.0001 0.00013399124145508
UPDATE products SET price = '139500' WHERE id = '400795'
382 0.0003 0.00031089782714844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400795' ORDER BY timestamp DESC
383 0.0002 0.00016617774963379
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
384 0.0002 0.00017094612121582
INSERT INTO ga_users (`ips`) SELECT 'a:1:{i:0;s:12:\"52.91.39.106\";}'
385 0.0002 0.0001530647277832
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1560832692'
386 0.0001 0.00013399124145508
INSERT INTO tracker_action (`gauser_id`, `gasession_id`, `action`, `notes`, `timestamp`) SELECT '139438', '140373', 'basket_view', '', '1560832692'
387 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = 2
388 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 4
389 0.0001 0.00013184547424316
SELECT * FROM pages WHERE id = 12
390 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 10
391 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
392 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 18
393 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 28
394 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 13
395 0.0001 0.00013208389282227
SELECT * FROM pages WHERE id = 3
396 0.0429 0.042924880981445
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
397 0.0002 0.00024294853210449
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:1560832692;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:6;s:6:\"412927\";i:8;s:6:\"408792\";i:10;s:6:\"370121\";i:16;s:6:\"408078\";}}' WHERE id = '175'
398 0.0004 0.00043797492980957
SELECT * FROM products WHERE id IN (398315,407595,412927,408792,370121,408078) ORDER BY FIELD(id, 398315,407595,412927,408792,370121,408078 )
399 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
400 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '398315'
401 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '398315'
402 0.0025 0.0025260448455811
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
403 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
404 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
405 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406 0.0001 0.0001227855682373
UPDATE products SET price = '1999' WHERE id = '398315'
407 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
408 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '407595'
409 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '407595'
410 0.0033 0.0033369064331055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
411 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
415 0.0003 0.00026988983154297
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
416 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
417 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
418 0.0036 0.0036308765411377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
419 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
420 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
421 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0001 0.00012111663818359
UPDATE products SET price = '199900' WHERE id = '412927'
423 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
424 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '408792'
425 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '408792'
426 0.0036 0.0035991668701172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
427 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
428 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
429 0.0004 0.0004432201385498
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
431 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
432 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '370121'
433 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '370121'
434 0.0028 0.002763032913208
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
435 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
436 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
437 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438 0.0001 0.00011801719665527
UPDATE products SET price = '9899' WHERE id = '370121'
439 0.0002 0.00022220611572266
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
440 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '408078'
441 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '408078'
442 0.0031 0.00307297706604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
443 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446 0.0001 0.00012087821960449
UPDATE products SET price = '23352' WHERE id = '408078'
447 0.0424 0.042369842529297
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
448 0.0002 0.00021195411682129
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:1560832692;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:16;s:6:\"408078\";i:17;s:6:\"405644\";}}' WHERE id = '177'
449 0.0004 0.00042295455932617
SELECT * FROM products WHERE id IN (398315,290575,408792,103845,408078,405644) ORDER BY FIELD(id, 398315,290575,408792,103845,408078,405644 )
450 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
451 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '398315'
452 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '398315'
453 0.0026 0.0026030540466309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
454 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
455 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
456 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
457 0.0001 0.00012612342834473
UPDATE products SET price = '1999' WHERE id = '398315'
458 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
459 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '290575'
460 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '290575'
461 0.0034 0.0033988952636719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
462 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
465 0.0001 0.00011920928955078
UPDATE products SET price = '549500' WHERE id = '290575'
466 0.0002 0.00024890899658203
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
467 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '408792'
468 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '408792'
469 0.0036 0.0036020278930664
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
470 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
471 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
472 0.0004 0.00043511390686035
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0001 0.00013899803161621
UPDATE products SET price = '13499' WHERE id = '408792'
474 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
475 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '103845'
476 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '103845'
477 0.0024 0.0024290084838867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
478 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
479 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
480 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0001 0.00012111663818359
UPDATE products SET price = '14499' WHERE id = '103845'
482 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
483 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '408078'
484 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '408078'
485 0.0031 0.0030560493469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
486 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
487 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
488 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
489 0.0001 0.00012111663818359
UPDATE products SET price = '23352' WHERE id = '408078'
490 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
491 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '405644'
492 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '405644'
493 0.0034 0.0033600330352783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
494 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
495 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
496 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
498 0.1038 0.10378813743591
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
499 0.0003 0.00028491020202637
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:1560832693;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:13;s:6:\"414188\";i:17;s:6:\"405644\";i:19;s:6:\"410949\";}}' WHERE id = '181'
500 0.0004 0.00043487548828125
SELECT * FROM products WHERE id IN (398315,408792,103845,414188,405644,410949) ORDER BY FIELD(id, 398315,408792,103845,414188,405644,410949 )
501 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
502 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '398315'
503 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
504 0.0025 0.0025038719177246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
505 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
506 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
507 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
508 0.0001 0.0001218318939209
UPDATE products SET price = '1999' WHERE id = '398315'
509 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
510 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '408792'
511 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408792'
512 0.0036 0.0035979747772217
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
513 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
514 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
516 0.0001 0.00013399124145508
UPDATE products SET price = '13499' WHERE id = '408792'
517 0.0002 0.00019621849060059
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
518 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '103845'
519 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '103845'
520 0.0024 0.0024368762969971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
521 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
522 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
523 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
524 0.0001 0.00012087821960449
UPDATE products SET price = '14499' WHERE id = '103845'
525 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
526 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414188'
527 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
528 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
529 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
530 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
531 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
532 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
533 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
534 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '405644'
535 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '405644'
536 0.0035 0.0034589767456055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
537 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
538 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
539 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
540 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
541 0.0002 0.00016999244689941
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
542 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '410949'
543 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '410949'
544 0.0027 0.0026838779449463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
545 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
546 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
547 0.0004 0.00038909912109375
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
548 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
549 0.1034 0.10342001914978
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
550 0.0003 0.00026106834411621
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:1560832693;s:8:\"products\";a:6:{i:5;s:6:\"404554\";i:9;s:6:\"103845\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";i:17;s:6:\"405644\";}}' WHERE id = '183'
551 0.0004 0.00044584274291992
SELECT * FROM products WHERE id IN (404554,103845,403517,414825,414188,405644) ORDER BY FIELD(id, 404554,103845,403517,414825,414188,405644 )
552 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
553 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '404554'
554 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '404554'
555 0.0034 0.0034019947052002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
556 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
557 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
558 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
559 0.0001 0.0001220703125
UPDATE products SET price = '399999' WHERE id = '404554'
560 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
561 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '103845'
562 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '103845'
563 0.0024 0.0024099349975586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
564 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
565 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
566 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
567 0.0001 0.00012016296386719
UPDATE products SET price = '14499' WHERE id = '103845'
568 0.0003 0.00025391578674316
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
569 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '403517'
570 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '403517'
571 0.0029 0.0029327869415283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
572 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
575 0.0001 0.00012898445129395
UPDATE products SET price = '6699' WHERE id = '403517'
576 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
577 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414825'
578 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414825'
579 0.0020 0.002011775970459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
580 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
581 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
582 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
583 0.0001 0.00011920928955078
UPDATE products SET price = '11999' WHERE id = '414825'
584 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
585 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '414188'
586 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414188'
587 0.0026 0.0025620460510254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
588 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
589 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
590 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
591 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '414188'
592 0.0002 0.0001838207244873
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
593 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '405644'
594 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '405644'
595 0.0034 0.0033690929412842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
596 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
597 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
598 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
599 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
600 0.0004 0.00040102005004883
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
601 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
604 0.0004 0.00039291381835938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
605 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
606 0.0001 0.00011920928955078
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0009 0.00088095664978027
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
608 0.0003 0.00030303001403809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
609 0.0003 0.00027894973754883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
610 0.0002 0.00022983551025391
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
611 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = 2
612 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
613 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 12
614 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = 10
615 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
616 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 18
617 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 28
618 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = 13
619 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
620 0.0429 0.042897939682007
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
621 0.0002 0.00023603439331055
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:1560832693;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:6;s:6:\"412927\";i:8;s:6:\"408792\";i:14;s:6:\"406758\";i:16;s:6:\"408078\";i:2;s:6:\"407595\";}}' WHERE id = '175'
622 0.0004 0.00044894218444824
SELECT * FROM products WHERE id IN (414940,412927,408792,406758,408078,407595) ORDER BY FIELD(id, 414940,412927,408792,406758,408078,407595 )
623 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
624 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '414940'
625 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '414940'
626 0.0033 0.0032739639282227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
627 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
628 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
629 0.0004 0.00042819976806641
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
630 0.0001 0.00012588500976562
UPDATE products SET price = '4490' WHERE id = '414940'
631 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
632 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '412927'
633 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
634 0.0036 0.0036280155181885
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
635 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
636 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
637 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
638 0.0001 0.00012111663818359
UPDATE products SET price = '199900' WHERE id = '412927'
639 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
640 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '408792'
641 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '408792'
642 0.0036 0.0035989284515381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
643 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0004 0.00043320655822754
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
646 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
647 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
648 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '406758'
649 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406758'
650 0.0026 0.0026319026947021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
651 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
652 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
653 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
654 0.0001 0.00012993812561035
UPDATE products SET price = '2694' WHERE id = '406758'
655 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
656 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '408078'
657 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408078'
658 0.0031 0.0030710697174072
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
659 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
660 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
661 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
662 0.0001 0.0001220703125
UPDATE products SET price = '23352' WHERE id = '408078'
663 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
664 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407595'
665 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407595'
666 0.0033 0.0033309459686279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
667 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
668 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
669 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
670 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
671 0.0426 0.042561054229736
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
672 0.0002 0.00020980834960938
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:1560832693;s:8:\"products\";a:6:{i:5;s:6:\"404554\";i:6;s:6:\"412927\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";i:10;s:6:\"370121\";i:16;s:6:\"408078\";}}' WHERE id = '177'
673 0.0004 0.00043296813964844
SELECT * FROM products WHERE id IN (404554,412927,409759,408792,370121,408078) ORDER BY FIELD(id, 404554,412927,409759,408792,370121,408078 )
674 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
675 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '404554'
676 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '404554'
677 0.0034 0.003385066986084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
678 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
679 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
680 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0001 0.00012087821960449
UPDATE products SET price = '399999' WHERE id = '404554'
682 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
683 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '412927'
684 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '412927'
685 0.0037 0.0036859512329102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
686 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
687 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
688 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.0001 0.00011897087097168
UPDATE products SET price = '199900' WHERE id = '412927'
690 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
691 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '409759'
692 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '409759'
693 0.0028 0.0027930736541748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
694 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
695 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
696 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
697 0.0001 0.00012302398681641
UPDATE products SET price = '229000' WHERE id = '409759'
698 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
699 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '408792'
700 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408792'
701 0.0036 0.0035820007324219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
702 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
703 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
704 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
705 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
706 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
707 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '370121'
708 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '370121'
709 0.0028 0.0027649402618408
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
710 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
711 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
712 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
713 0.0001 0.00011801719665527
UPDATE products SET price = '9899' WHERE id = '370121'
714 0.0002 0.00021219253540039
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
715 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '408078'
716 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408078'
717 0.0031 0.0030848979949951
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
718 0.0002 0.00018477439880371
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
719 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
721 0.0001 0.00012111663818359
UPDATE products SET price = '23352' WHERE id = '408078'
722 0.1038 0.1038339138031
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
723 0.0003 0.00025701522827148
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:1560832693;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:4;s:6:\"171938\";i:5;s:6:\"404554\";i:6;s:6:\"412927\";i:9;s:6:\"103845\";}}' WHERE id = '181'
724 0.0005 0.00045609474182129
SELECT * FROM products WHERE id IN (414940,398315,171938,404554,412927,103845) ORDER BY FIELD(id, 414940,398315,171938,404554,412927,103845 )
725 0.0002 0.00018882751464844
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
726 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '414940'
727 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '414940'
728 0.0033 0.0032999515533447
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
729 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
730 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
731 0.0004 0.00044417381286621
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
732 0.0001 0.0001220703125
UPDATE products SET price = '4490' WHERE id = '414940'
733 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
734 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '398315'
735 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
736 0.0025 0.0024809837341309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
737 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
738 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
739 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0001 0.00012087821960449
UPDATE products SET price = '1999' WHERE id = '398315'
741 0.0006 0.00059604644775391
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
742 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '171938'
743 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
744 0.0026 0.0025520324707031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
745 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
746 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
747 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
748 0.0001 0.00012016296386719
UPDATE products SET price = '389500' WHERE id = '171938'
749 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
750 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '404554'
751 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
752 0.0033 0.0033359527587891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
753 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
754 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
755 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
756 0.0001 0.00011992454528809
UPDATE products SET price = '399999' WHERE id = '404554'
757 0.0003 0.00025320053100586
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
758 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '412927'
759 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '412927'
760 0.0037 0.0036699771881104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
761 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
762 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
763 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
764 0.0001 0.00012111663818359
UPDATE products SET price = '199900' WHERE id = '412927'
765 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
766 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '103845'
767 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '103845'
768 0.0024 0.0023999214172363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
769 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
770 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
771 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
773 0.1035 0.10352897644043
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
774 0.0003 0.00025701522827148
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:1560832693;s:8:\"products\";a:6:{i:5;s:6:\"404554\";i:9;s:6:\"103845\";i:12;s:6:\"414825\";i:14;s:6:\"406758\";i:19;s:6:\"410949\";i:3;s:6:\"290575\";}}' WHERE id = '183'
775 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (404554,103845,414825,406758,410949,290575) ORDER BY FIELD(id, 404554,103845,414825,406758,410949,290575 )
776 0.0003 0.00027990341186523
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
777 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '404554'
778 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '404554'
779 0.0034 0.0033769607543945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
780 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
781 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
782 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
783 0.0001 0.00012302398681641
UPDATE products SET price = '399999' WHERE id = '404554'
784 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
785 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '103845'
786 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '103845'
787 0.0024 0.0024151802062988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
788 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
789 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
790 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
791 0.0001 0.00011777877807617
UPDATE products SET price = '14499' WHERE id = '103845'
792 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
793 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '414825'
794 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414825'
795 0.0020 0.0019979476928711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
796 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
797 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
798 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
799 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
800 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
801 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '406758'
802 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
803 0.0026 0.0026280879974365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
804 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
805 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
806 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
807 0.0001 0.00011992454528809
UPDATE products SET price = '2694' WHERE id = '406758'
808 0.0002 0.00017094612121582
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
809 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410949'
810 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
811 0.0027 0.0026910305023193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
812 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
813 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
814 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
815 0.0001 0.00011587142944336
UPDATE products SET price = '47995' WHERE id = '410949'
816 0.0006 0.00056791305541992
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
817 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '290575'
818 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '290575'
819 0.0034 0.0034139156341553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
820 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
821 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
822 0.0004 0.00043511390686035
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
823 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
824 0.0004 0.0003960132598877
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
825 0.0001 0.00014090538024902
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
826 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0004 0.0003969669342041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
829 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
830 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0009 0.0009000301361084
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
832 0.0003 0.00029897689819336
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
833 0.0003 0.00029206275939941
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
834 0.0003 0.00033998489379883
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
835 0.0001 0.00014281272888184
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
836 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
837 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
838 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
839 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
840 0.0004 0.00037908554077148
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
841 0.0003 0.00033092498779297
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'