Tactical Equipment - Survivalist Equipment
   

Riflescope Reviews :: Hunting :: Combat :: We Investigate Which Is The Best Riflescope?

Best Tactical Rifle Scopes

UPDATED :  

Traditional wisdom tells us that the rule of choosing a good riflescope is to buy the most expensive one that you can afford. But not everyone can shell out a grand for something that they'll use two weeks out of the year. What about the bargain scopes? - you know, those riflescopes for sale cheap. We set out to objectively evaluate some of the most common budget priced rifleseopes on the market. We chose five categories by which to evaluate these scopes: optical quality, mechanical quality durability, eye relief, and ergonomics so you choos ethe best rifle scope for your weapon.

Optics testing is difficult as results can be greatly dependent on the user's perception rather than measurable metrics. Our testing and rifle scope reviews took place under the most realistic conditions we could devise, using some methods developed specifically for this evaluation. We spent hours looking through these scopes in various lighting conditions and subjected them to rigorous tests of durability and accuracy. We played no favorites and kept it as objective as possible. Our results are a hell of a lot more valuable at finding the best riflescope than staring through the scope at the counter of a well-lit retail store. Just a note though, this isn't a rifle scope comparrison, rather a brief review on their individual merrits.

Budget Class Riflescope Reviews


LEUPOLD VX-1 3-9X40 RIFLESCOPE REVIEW

LEUPOLD VX-1 RIFLESCOPE

LEUPOLD'S BASIC DUPLEX RETICLE HAS BEEN AROUND FOR DECADES BECAUSE HUNTERS LOVE IT. IT'S SIMPLE AND EFFECTIVE AND, WHEN USED IN CONJUNCTION WITH THE POWER ADJUSTMENT, CAN SERVE AS A BASIC RANGEFINDING DEVICE.

The VX-1 is a light and compact optic with generous eye relief - all qualities that Leupold is well known for. The Leupolds glass was very crisp and clean during daylight hours and finished just behind the Zeiss and Weaver scopes at dusk. The basic ergonomics were strong, but the adjustment clicks could have been more positive. The VX-1 did show some tracking issues on the range that prevented a full 5-pointscore in the mechanical quality category. At $400 retail with a street price just under $360, this scope is a solid value for most hunting applications. Leupold's warranty and reputation for customer service are second to none and are an important consideration as hunting optics-do break.

Best Price Scopes

LEUPOLD VX-1 3-9X40 RIFLESCOPE Sale

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Leupold Models: View All Available Leupold Scopes


NIKKO STIRLING PANAMAX Riflescope REVIEW

NIKKO STIRLING PANAMAX RIFLESCOPE

New from Nikko Stirling is the Panamax compact 1" hunting scope which features extreme wide field of view - 20% more than average 1" scopes. With an appealing design - by a leader of the optics industry, it is stable and ruggedly built. With parallax adjustment starting from 10 yards on AO models, and professional half Mil Dot reticle, the scope features a 1-inch hard anodized one-piece aircraft grade aluminium main body tube. It is offered in three different magnification options in a 3-9x40, 3-9x50 and a 4-12x50 AO

Best Price Scopes

NIKKO STIRLING PANAMAX Riflescope Sale

3-9x40 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

3-9x50 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

4-12x50 AO Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All Nikko Stirling Models: View All Available Nikko Scopes


WEAVER KASPA 3-12X50 RIFLESCOPE REVIEW

WEAVER KASPA 3-12X50 RIFLESCOPE

THE KASPA'S BALLISTIC-X RETICLE COMBINES A CENTER CROSSHAIR WITH THREE "COME-UP" MARKS BELOW IT THAT VERY ROUGHLY EQUATE TO 300, 400, AND 500 YARDS WITH A 200-YARD ZERO. USING THE INTERACTIVE EBX BALLISTICS CHART ON WEAVER'S WEBSITE, YOU CAN DETERMINE WHAT YOUR BULLET'S DROP WILL BE FOR EACH OF THOSE HASH MARKS.

The Weaver is, without a doubt, the best value of all of the scopes evaluated. This scope nearly tied the Zeiss in total points and did it at less than half the price. The Kaspas image was bright and clear and performed well in low light. This scope offers the most magnification of all of our test optics and still has the most generous eye relief. My only complaint about the Weaver is that the size and configuration of the objective made mounting the scope where it wouldn't touch the Sendero profile barrel nearly impossible in the Leupold medium rings we had on hand. The good news was that even with the scope pushed far enough forward to allow the scope to clear the barrel, there was adequate eye relief for testing.

Best Price Scopes

WEAVER KASPA 3-12X50 RIFLESCOPE Sale

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All Weaver KASPA models: View All Available Weaver KASPA Scopes


BUSHNELL ELITE 3500 3-9X50 RIFLESCOPE REVIEW

BUSHNELL ELITE 3500 3-9X50 RIFLESCOPE

BUSHNELL'S DOA 600 RETICLE DOES DOUBLE-DUTY AS A BULLET DROP COMPENSATOR AND AS A MEANS FOR. ESTIMATING A DEER'S RACK AT VARIOUS DISTANCES. FOUR ELEVATION MARKS WITH MOA DOTS HAVE VERTICAL BRACKETS THAT COMPUTE TO 24 INCHES AT VARIOUS DISTANCES WHEN THE SCOPE IS AT FULL POWER.

This is the most expensive optic in our test by a wide margin, but far from the best performing. This is the largest and heaviest scope of the five and is a full three inches longer than the Zeiss. In this case, the size of the package wasn't a great indicator of performance. The optics were solid during daylight use, but the DOA reticle all but disappeared in low light, making it unusable seven minutes before legal shooting hours ended. The Bushnell's clicks were very positive, and it received top marks for overall ergonomics, but its performance on the test range indicated some inconsistency in the tracking of the adjustments— a key component in a rifle scope that is marketed for long-range use. This is probably a better scope than the score suggests, but the test parameters are fair and equitable across the board.

Best Price Scopes

BUSHNELL ELITE 3500 3-9X50 RIFLESCOPE Sale

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Bushnell Models: View All Available Bushnell Scopes


BURRIS DROPTINE 3-9X50 RIFLESCOPE REVIEW

BURRIS DROPTINE 3-9X50 RIFLESCOPE

THE BURRIS BALLISTIC PLEX RETICLE IS A DUPLEX-STYLE WITH FOUR ADDITIONAL ELEVATION HOLDS. THE HOLDS EQUATE TO 1.4,4.3,7.2, AND 10.5 MOA FROM A 100-YARD ZERO AND MATCH THE AVERAGE BULLET PATH OF MANY COMMON CARTRIDGES.

This riflescope is a bit heavier than the pack, surely due to its larger 50mm objective lens. The optics were excellent during daylight but appeared out of focus (despite attempts to adjust to a better image) at dusk, which affected its score. The scope performed perfectly when it came to the precision of its adjustments, though the clicks could be missed unless I really concentrated on the dials. Eye relief was better than the Bushnell and Zeiss but fellshort of the four-inch mark, which cost it a point.

Best Price Scopes

BURRIS DROPTINE 3-9X50 RIFLESCOPE Sale

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Burris Models: View All Available Burris Scopes


STEINER RANGER RIFLESCOPE REVIEW

STEINER RANGER 3-12X56 RIFLESCOPE

The Ranger rifle scope series delivers a short construction with a wide field of view. These rifle scopes deliver High-Contrast-Optics and are superbly capable in low light with a light transmission of more than 90%. Their lightweight, shock proof and appealing design give you the most for your money and will always deliver unfailing performance whatever firearm or target you prefer. The proven 4x zoom range lets hunters around the world pair their new rifle scope with their favourite rifle.

The Ranger 3-12x56 is a powerful all-round rifle scope for high seat and still hunting. Lightweight, weighing in at only 705g and features a large field of view. High light transmission makes this rifle scope a perfect companion for hunting at night. Precise illumination adjustment delivers perfect perform Compact versatility for virtually any rifle, plus an optical performance to pick out prey from any environment.

Best Price Scopes

STEINER RANGER 3-12X56 RIFLESCOPE Sale

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Steiner Models: View All Available Steiner Scopes


Professional High-End Riflescope Reviews


MEOPTA MEOSTAR R2 RIFLESCOPE REVIEW

MEOPTA MEOSTAR R2 RIFLESCOPE

Like that one guy who slept on your couch in college, some of the most memorable beasts earn their reputation by sleeping all day and rocking all night. Meopta will help you party with the big boys when the light turns low. Put any of the MeoStar R2 scopes to your eye and you'll instantly be struck with sobering clarity, from dawn to dusk. A new 1.7-10x42 configuration with two illuminated reticle options, a wide field of view, and a fast-focus eyepiece will ensure you don't miss out on any of the action. This riflescope best performs in low light condition.

Best Price Scopes

MEOSTAR R2 RIFLESCOPE 1.7-10X42 RIFLESCOPE Sale

MEOSTAR R2 4K Reticle

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

MEOSTAR R2 4C Reticle

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Meostar Models: View All Available Meostar Scopes


ZEISS TERRA XB75 RIFLESCOPE REVIEW

ZEISS TERRA XB75 CROSSBOW SCOPE

The enhancements to crossbow technology haven't directly correlated to the improvement of crossbow-specific optics. Its still not uncommon to see a throwaway scope sold in a high-end crossbow "package." But with the rapidly expanding popularity of horizontal bowhunting, its a smart move by a highbrow optics company like Zeiss to create a premium crossbow scope. The 2-7x32 Terra XB75 is a low-profile scope made for crossbows that sling bolts at 275-425 fps. A shooter can calibrate the patented ballistic reticle to match the speed of their bow, and multiple vertical aiming points will provide precise drop compensation in 2.5-yard increments out to 75 yards.

Best Price Scopes

ZEISS TERRA XB75 RIFLESCOPE Sale

Carl Zeiss Terra 2-7x32 Plex Crossbow Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

Carl Zeiss Terra 2-7x32 Plex Riflescope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All Carl Zeiss Models: View All Available Carl Zeiss Scopes


LEICA ER5 RIFLESCOPE REVIEW

LEICA ER5 RIFLESCOPE

"Conceived in Germany; Born in the USA." That's the tag line floating around for Leica's new ER5 series of riflescopes. Yes, this means Leica is applying its legendary German optical engineering to design these scopes, but they're built on American soil. Six models range from an in-your-face 1-5x24 to a hair-splitting 5-25x26 (model currently unavailable) - all with 5:1 zoom ratios. These scopes sport a matte finish with low-profile turrets and an overall classy look that should appeal to minimalists. Choose from six reticles and feel free to pick a ballistic option if the extra lines help you make longershots under pressure. Four inches of eye relief will save you from wearing black-and-blue magnum makeup.

Best Price Scopes

LEICA ER5 RIFLESCOPE Sale

LEICA ER5 1-5x24 Plex Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

LEICA ER5 1-5x24 LE-TAC Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Leica Rifle Scope Models: View All Available Leica Scopes


STEINER GS3 "GAME SENSING" RIFLESCOPE REVIEW

STEINER GS3 RIFLESCOPE

The new Steiner GS3 "game sensing" scope utilises exclusive CAT (colour adjusted transmission) lens coatings to amplify contrast in the peak human vision sensitivity range. The optimised contrast effectively separates game from leafy or shadow dappled backgrounds, exposing your target to a clean, accurate shot.

The GS3 5x zoom range lets hunters easily pair their new scope with their favourite centerfire, rimfire or muzzleloader rifle. Models include, 2-10x42mm which offers a wide field of view making it easier to find your target; the 3-15x50mm for low light performance that mounts on most rifles without extra-high rings; 3-15x56mm gives varmint and pig hunters sharp images at night and in dim light; and 4-20x50mm for varmint shooting, target shooting and long distance shots

Best Price Scopes

STEINER GS3 "GAME SENSING" RIFLESCOPE Sale

STEINER GS3 2-10x42 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

STEINER GS3 3-15x50 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

STEINER GS3 3-15x56 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All STEINER GS3 Models: View All Available STEINER GS3 Scopes


LEUPOLD MARK 4 RIFLESCOPE REVIEW

LEUPOLD MARK 4 RIFLESCOPE

If tactical makes you tick, you're probably aware of Leupold's long-range tactical Mark 4 scopes. But if you've never been employed by Uncle Sam to serve our country, there's a good chance a mil-dot reticle is as foreign to you as riding a camel. Your grandpa told you four clicks will move your bullet an inch across a football field? Good news: Leupold is now offering MOA-based reticles for its Mark 4s and sports side parallax adjustments. As usual, this scope is designed and built in America and backed by a full lifetime guarantee.

Best Price Scopes

LEUPOLD MARK 4 RIFLESCOPE Sale

LEUPOLD MARK 4 1-5x24

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All LEUPOLD MARK 4 Models: View All Available LEUPOLD MARK 4 Scopes ($737-$1,500)


BURRIS XTR II RIFLESCOPE REVIEW

BURRIS XTR II RIFLESCOPE

A high degree of precision and a low price are the two most attractive attributes of the Burris XTR II line. These long-range scopes aren't new, but the Special Competition Reticle (SCR) is. The SCR is available in MIL or MOA versions, each with an illuminated center for faster target acquisition. You'll also find an improved click adjustment knob that offers 100 clicks per rotation, allowing shooters to adjust for 1,000 yard shots within a single turn. You'd be hard-pressed to find a thread-the-needle scope of this caliber at this price point. Oh, and if you judge a book by its cover, Burris got a much-needed brand facelift with a sleek new logo and fresh vibe.

Best Price Scopes

BURRIS XTR II Sale

BURRIS XTR II with F-Class MOA Illuminated Reticle 8-40x50mm Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Burris XTR II Models: View All Available Burris XTR Scopes


BUSHNELL LRHS ELITE RIFLESCOPE REVIEW

BUSHNELL LRHS ELITE RIFLESCOPE

You can't hit what you can't see...especially when your target has horns and it's standing on a rocky slope at 600 yards in freezing rain. If you're seasoned in the long-range shooting game, you demand a rugged optical companion atop your trusted tack-driver. This new Elite Long Range Hunting Scope (LRHS) 4.5-18x44 from Bushnell steps up the magnification from last year's 12X model, allowing you to zoom so close with its fully multicoated glass that you can danged near read your quarry's mind. Choose MIL- or MOA-based reticles with .1- and .25-click adjustments respectively. Bushnells RevLimiter zero stop helps you return to zero by touch confirmation—no need to take your eyes off your next meal.

Best Price Scopes

Bushnell Tactical LRHS RIFLESCOPE Sale

Bushnell Tactical E3124H Elite Hunter LRHS Riflescope with G2H FFP Long Range Reticle, 3-12x 44mm Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All Bushnell Tactical LRHS Models: View All Available Bushnell Scopes


WEAVER KASPA RIMFIRE RIFLESCOPE REVIEW

WEAVER KASPA RIMFIRE RIFLESCOPE

From punching holes in pop cans to dumping prairie dogs or smacking squirrels, everybody loves a rimfire. Half the hoot of cracking through piles of tiny rounds is that it's a cheap thrill, so a do-all scope for .22 Long Rifle, .22 Win. Mag., and the flat-shooting .17 HMR is a sensible approach to rimfire optics. That's what you'll get with this Kaspa - three turret dials that you can swap out depending on what kiddy caliber you feel like playing with. Fully multicoated lenses and a practical Dual-X reticle add to the fun.

Best Price Scopes

WEAVER KASPA RIMFIRE RIFLESCOPE Sale

Weaver 849851 Turret Dial Optics Kaspa Rimfire Scope, 3-9 x 40mm

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All WEAVER KASPA Models: View All Available WEAVER KASPA Scopes


NIKON MONARCH 5 RIFLESCOPE REVIEW

NIKON MONARCH 5 RIFLESCOPE

Nikon continues to expand its proven Monarch line of scopes, thistime with a 5X zoom ratio and a new glass-etched Advanced BDC (Bullet Drop Compensation) reticle option for long-range shooters. This reticle takes the original BDC reticle to the next level by adding windage marks on the horizontal crosshair, which can be used to hold left or right for a 10-mph crosswind. The Monarch 5 series is being offered in seven configurations ranging from 2-10x42 to 6-30x50. As you'd expect, these vivid Monarchs contain Nikon's fully multicoated ED glass len

Best Price Scopes

NIKON MONARCH 5 RIFLESCOPE Sale

NIKON MONARCH 5 2-10x42 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

NIKON MONARCH 5 6-30x50 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Leica ER Models: View All Available Leica Scopes


STYRKA S7 RIFLESCOPE REVIEW

STRYKA S7 RIFLESCOPE

Another hunting optics company? Bold move, indeed, but this newcomer is coming outswinging. Styrka (pronounced steer-ka) is Scandinavian for "strength." Its parent company has roots in telescope manufacturing. These eye-catching new optics are backed with a head-turning warranty that saysif you ever have a problem with their stuff, they'll fix it. Period. And if you're interested, they'll clean and tune your optics every year on their dime. In riflescopes, the flagship S7 series offers three configurations: 1-6x24 (plex reticle), 3-12x42 (plex reticle), and 2.5-15x50 (plex or mil-dot reticle); illuminated reticles optional. Each scope has fully multicoated lenses and 30mm tubes made from aircraft-grade aluminum. Check out the Styrka S5 series if you're pinching pennies.

Best Price Scopes

STYRKA S7 RIFLESCOPE Sale

STYRKA S7 1-6x24 Plex Reticle Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

STYRKA S7 3-12x42 Plex Reticle Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

STYRKA S7 2.5-15x50 Plex Reticle Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

STYRKA S7 2.5-15x50 Mil-Dot Reticle Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All STYRKA S7 Models: View All Available STYRKA Scopes


VORTEX STRIKE EAGLE RIFLESCOPE REVIEW

VORTEX STRIKE EAGLE RIFLESCOPE

Most ARowners prefer a compact optic to streamline their black rig for nimble performance. Close-quarters target acquisition is key, but some magnification for popping accurate shots at a distance is also desirable. The 1-6x24 Strike Eagle covers all those bases, plus it incorporates an illuminated BDC reticle with 11 light intensity settings. A raised paddle on the magnification ring lets you keep your eye on the prize while you're quickly adjusting for long- or close-range engagements. Definitely a pretty package for less than five Benjamins.

Best Price Scopes

VORTEX STRIKE EAGLE RIFLESCOPE Sale

VORTEX STRIKE EAGLE 1-6x24 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All VORTEX STRIKE Models: View All Available VORTEX Scopes


ZEISS TERRA 3-9X42 RIFLESCOPE REVIEW

VORTEX STRIKE EAGLE RIFLESCOPE

THE TERRA"S DUPLEX RECTICLE USES A SLIGHTLY THICKER CROSSHAIR THAN MANY COMPETITORS' OPTICS, WHICH MADE THE SCOPE QUITE USEFUL AT DUSK.

As you might expect from the brand - and the price - the Zeiss was the all-around best-performing scope in our test. The optics were clear and bright and allowed us to use every minute of legal shooting hours. The simple duplex reticle isn't fancy, but it showed up better than the competition in our lowlight testing—where I hunt that can make the difference between a dead buck and a lonely walk to the truck. The eye relief was the shortest of our test, which is something to think about on heavy-recoiling rifles. Ergonomics were good—my only complaint is that the 1/4-inch click adjustments were difficult to discern while wearing gloves. It's worth noting that while the Terra was the best-performing scope in our testing, it is among the most compact, which makes it a great choice for a big-game rifle. The Terra is clearly our top choice, but it just barely beat out the runners-up.

Best Price Scopes

ZEISS TERRA 3 RIFLESCOPE Sale

CARL ZEISS 3-9x42 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All ZEISS TERRA 3 Models: View All Available ZEISS TERRA 3 Scopes


SWAROVSKI OPTIK X5(i) RIFLE SCOPE REVIEW

SWAROVSKI X5i RIFLESCOPE

The new X5(i) rifle scope from Swarovski Optik is said to be a long-range expert - you will only successfully achieve accurate hits over long distances and in challenging situations if your equipment reliably performs at its best, together with having plenty of experience and in-depth knowledge of the local conditions.

Precision is the number one condition for long-range shooting, including for the X5(i). Using the turrets and the spring retention system, you can adjust the impact point to your exact requirements with the X5(i). Another crucial factor is the intuitive operating features. The innovative spring retention system enables the X5(i) rifle scope to reach a very large adjustment range of up to 116 MOA. The role of the retention lever is to ensure constant pressure in each HHRBI B position of the inversion system. This means that an extremely accurate impact point adjustment is guaranteed across the whole adjustment range of 1/4 or 1/8 MOA (depending on the model) in terms of both elevation and windage.

The parallax turret enables you to adjust the parallax perfectly to the relevant shooting distance. The magnification indicator ring allows you to easily read the set magnification from any shooting position.

Every X5(i) rifle scope is crafted from the finest materials and undergoes the most stringent quality control checks. Thicker walls in the main tube, integrated steel parts in the turrets, and the inversion system's spring retention system provide maximum stability, even when powerful calibers are used and in extreme temperatures. The X5(i) illumination unit offers 10 different illumination levels. When they are inactive, the reticles are completely black and clear, while when active, they are illuminated across the whole surface. The illuminated reticle produces the maximum contrast both during the day and at night, including in poor light and weather conditions, while also ensuring greater accuracy.

From September 2015 there will be three different models X5(i) 3.5-18x50 P and X5(i) 5-25x56 P, offering specific reticles and an optional personalized extreme cam (PXC).

Best Price Scopes

Swarovski X5i RIFLESCOPE Sale

Swarovski X5i 5-25x56 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All Swarovski X5 Models: View All Available Swarovski X5 Scopes


Vortex Razor GEN II Variable Rifle Scope

Vortex Razor GEN 2 Variable Rifle Scope

VORTEX Mil Spec optics are fast becoming a preferred sighting system amongst many European and US special operations and law enforcement agencies, including Tier 1 military units.

Vortex's Vortex Razor Gen II 1-6 x 24 variable rifle scope features the company's outstanding optical performance in a super ruggedised unit machined from high grade 61T aluminium, capable of withstanding 40G recoil shock without any variation in weapon zero or round Point Of Impact.

The Vortex Razor Gen II 1-6 x 24 is designed for Close Quarter shooting and delivers outstanding long eye relief and a fine diopter able to accommodate every eye to effect ultra rapid, super positive target acquisition and engagement without compromising the shooter's situational awareness.

Best Price Scopes

Vortex Razor GEN II RIFLESCOPE Sale

Vortex Razor 1-6x24 Scope

  Ready To Purchase: Buy Now

  Read User Reviews: Available

  View All Vortex Razor Models: View All Available Vortex Razor Scopes


RIFLESCOPE EVALUATION CONSIDERATIONS

OPTICAL QUALITY

Optical quality was evaluated by mounting all of the scopes side-by-side in a special jig built for me by custom gunmaker D'Arcy Echols. The tripod-mounted jig allows me to focus all of the scopes on a single object simultaneously, and, with minimal movement, I can move my eye back and forth between the respective scopes to make the score as objective as possible. General optical quality was evaluated by studying optical test charts through the scopes as well as by using the scopes in open country under realistic hunting conditions. Low-light performance, which falls under the optical quality category, was examined by watching a 3-D deer target at dusk through each of the scopes at 6X—the later that the deer was "shootable" through a given scope, the higher the score. The deer was 70 yards away and in the shade of several oak trees, which accurately replicated real-world hunting conditions. The Zeiss Terra with its bright glass and healthy duplex reticle won thisrace hands-down, but the difference between first and last place was a mere six minutes. That said, six minutes can be an eternity on the last evening of a hunt.

RIFLE SCOPE MECHANICAL DUALITY

Scopes were mounted to a rifle of known accuracy: a Remington Model 700 VLS loaded with match ammo. Scopes were examined through a collimator while moving through the power range to determine whether the reticle was prone to wandering. The scopes were then zeroed at 100 yards before "shooting the box" by adjusting the point-of-impact by four inches in each direction to determine whether the adjustments tracked with consistency and precision. A point was lost for any shots that deviated from the one-inch blocks on the target. The Weaver and Burris scopes were mechanically perfect, but all of the others faltered in one way or another. The Zeiss tracked with consistency, but the 1/2-inch clicks didn't correspond exactly to that standard downrange. The remainder of the scopes showed slight deviations in windage and/or elevation as they tracked around the target.

RIFLE SCOPE DURABILITY

Each scope was immersed in hot water with the dial covers removed, placed in the freezer, and mounted on the rifle with a minimum of 10 rounds fired. This was a pass/fail category for which all of the scopes received full points. If you think this is an easy test, you'd be surprised to know how many scopes I break during the normal course of testing and evaluation (two so far this year). Letting my kids chew on them and bounce them on the driveway would have made it more interesting, but we decided that it wasn't very objective.

RIFLE SCOPE EYE RELIEF

This is a purely subjective category based on the scopes max eye relief - anyone with a scar on their forehead knows how important this quality is on a riflescope. European scopes usually lack in this : department, and that held true with the Zeiss, even though this model is made in Japan. The Weaver and Leupold scopes* had the greatest eye relief in our testing! and would be my choice for anything over a .30-06 on the recoil spectrum.

RIFLE SCOPE ERGONOMICS

No hunting scope is useful if it can't be operated under stress and in the crappy conditions we often encounter in the field. Things like the ease of turning they power ring, the ability to make point-of-impact adjustments wearing gloves, and the overall user-friendliness of the scope were evaluated with points awarded appropriately. Lack of tactile clicks on the adjustment knobs was the most common gripe—the fact is, all of the scopes were more or less idiot-proof.

RIFLE SCOPE VALUE

As each reader's budget, needs, and preferences vary tremendously, we did not assign points for value. For stand hunting whitetails in the South, three additional minutes of shooting light may be worth $200 while a guy who shoots from canyon to canyon may put more value on a scope's mechanical precision. We let you decide which scope's attributes best match your wallet.


Aim Sports XPF Rifle Scopes

Aim Sport XPF rifle scopes

The XPF series delivers affordability and now features locking windage and elevation knobs. The XPFs all have 30mm tubes and 50mm objective lenses, with side-focus parallax adjustment—along with illuminated, glass-etched reticles.

Reticles are in the second plane; choices include mil dot and rangefinder styles. Nitrogen-purged for fog proofing, and they're shock- and recoil-resistant. Each XPF comes with rings for slotted bases. Models include 3-12X, 4-16X, 6-24X (shown) and 10-40X. Approx price range: $140 - $170.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2859969139099 604 0.5919 0


No Amazon API Requests Made.


App Debug - Total Time 1.2859969139099 seconds

Number Time From Start Name Description
1 0.44403100013733 Initialise Initialise FSB Function
2 0.45543193817139 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46722102165222 Start of getCategoryListByGroup Function Before first category groups query
4 0.46740889549255 After initial query Before first category groups query
5 0.46741104125977 Get Category List for Group Before the call to getCategoryList function
6 0.46741390228271 Start of GetCategoryList function Start of the function
7 0.46742105484009 Before getting categories Query to get specific category list
8 0.46809005737305 After getting categories Query to get specific category list
9 0.46809196472168 Before getting category custom Before call to function getCategoryCustom
10 0.47012090682983 After getting category custom After call to function getCategoryCustom
11 0.47012400627136 Before getting category custom Before call to function getCategoryCustom
12 0.48097395896912 After getting category custom After call to function getCategoryCustom
13 0.48097801208496 Before getting category custom Before call to function getCategoryCustom
14 0.48666191101074 After getting category custom After call to function getCategoryCustom
15 0.48666501045227 Before getting category custom Before call to function getCategoryCustom
16 0.49092292785645 After getting category custom After call to function getCategoryCustom
17 0.49092602729797 End of GetCategoryList function End of the function
18 0.4909360408783 Get Category List for Group Before the call to getCategoryList function
19 0.49093890190125 Start of GetCategoryList function Start of the function
20 0.49094200134277 Before getting categories Query to get specific category list
21 0.49141192436218 After getting categories Query to get specific category list
22 0.4914128780365 Before getting category custom Before call to function getCategoryCustom
23 0.49707794189453 After getting category custom After call to function getCategoryCustom
24 0.49708104133606 Before getting category custom Before call to function getCategoryCustom
25 0.5078010559082 After getting category custom After call to function getCategoryCustom
26 0.50780296325684 End of GetCategoryList function End of the function
27 0.50781083106995 Get Category List for Group Before the call to getCategoryList function
28 0.50781393051147 Start of GetCategoryList function Start of the function
29 0.507817029953 Before getting categories Query to get specific category list
30 0.50868105888367 After getting categories Query to get specific category list
31 0.5086829662323 Before getting category custom Before call to function getCategoryCustom
32 0.51797485351562 After getting category custom After call to function getCategoryCustom
33 0.51797795295715 Before getting category custom Before call to function getCategoryCustom
34 0.53537583351135 After getting category custom After call to function getCategoryCustom
35 0.53537893295288 Before getting category custom Before call to function getCategoryCustom
36 0.54141497612 After getting category custom After call to function getCategoryCustom
37 0.54141783714294 Before getting category custom Before call to function getCategoryCustom
38 0.54742193222046 After getting category custom After call to function getCategoryCustom
39 0.54742503166199 Before getting category custom Before call to function getCategoryCustom
40 0.55377101898193 After getting category custom After call to function getCategoryCustom
41 0.55377388000488 Before getting category custom Before call to function getCategoryCustom
42 0.57585000991821 After getting category custom After call to function getCategoryCustom
43 0.57585406303406 Before getting category custom Before call to function getCategoryCustom
44 0.58005785942078 After getting category custom After call to function getCategoryCustom
45 0.5800609588623 Before getting category custom Before call to function getCategoryCustom
46 0.58478093147278 After getting category custom After call to function getCategoryCustom
47 0.58478403091431 End of GetCategoryList function End of the function
48 0.58479785919189 Get Category List for Group Before the call to getCategoryList function
49 0.58480095863342 Start of GetCategoryList function Start of the function
50 0.58480501174927 Before getting categories Query to get specific category list
51 0.58526492118835 After getting categories Query to get specific category list
52 0.58526682853699 Before getting category custom Before call to function getCategoryCustom
53 0.58765697479248 After getting category custom After call to function getCategoryCustom
54 0.58765983581543 Before getting category custom Before call to function getCategoryCustom
55 0.59008884429932 After getting category custom After call to function getCategoryCustom
56 0.59009099006653 End of GetCategoryList function End of the function
57 0.59009790420532 Get Category List for Group Before the call to getCategoryList function
58 0.59010100364685 Start of GetCategoryList function Start of the function
59 0.5901038646698 Before getting categories Query to get specific category list
60 0.59045004844666 After getting categories Query to get specific category list
61 0.59045100212097 Before getting category custom Before call to function getCategoryCustom
62 0.59549498558044 After getting category custom After call to function getCategoryCustom
63 0.59549784660339 End of GetCategoryList function End of the function
64 0.59550404548645 End of getCategoryListByGroup Function Before return()
65 0.65229296684265 App Controller End End of the App controller (called before the controller of every page)
66 0.65429186820984 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.65445303916931 Before Get Options Before the call to getOptions in the tpl class
68 1.0684249401093 After Get Options After the call to getOptions in the tpl class
69 1.0685038566589 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2859778404236 Finalizing debug Before the debug is output to the page.
71 1.2859959602356 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5919 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.00044393539428711
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015401840209961
SELECT * FROM `bad_bots`
5 0.0005 0.00046586990356445
SELECT parameter, value FROM parameters
6 0.0001 0.00014996528625488
SET time_zone = 'Europe/London'
7 0.0003 0.00031709671020508
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016188621520996
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010991096496582
delete from cachefiles
10 0.0003 0.0002748966217041
SELECT id FROM pages WHERE pagename = 'riflescope-reviews' LIMIT 1
11 0.0003 0.0003199577331543
SELECT * FROM pages WHERE id = 66
12 0.0008 0.00084686279296875
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0092 0.0092458724975586
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0004 0.00039100646972656
SELECT * FROM pages WHERE pagename = 'riflescope-reviews'
15 0.0002 0.0001680850982666
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00056695938110352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049400329589844
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.0003 0.00026178359985352
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00045990943908691
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.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00016593933105469
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.00019693374633789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.003032922744751
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.00027084350585938
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022578239440918
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '129'
30 0.0058 0.0057861804962158
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.00018215179443359
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.00016999244689941
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.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0002 0.0001530647277832
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.002324104309082
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.00027108192443848
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.002331018447876
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.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 (80)
				  AND p.disabled = 0 
39 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011589527130127
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.001798152923584
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.00017809867858887
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.00016403198242188
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00043797492980957
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023019313812256
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.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023090839385986
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.0002 0.00015711784362793
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.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048110485076904
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0048551559448242
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.00016403198242188
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.0002 0.00016283988952637
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00069499015808105
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040998458862305
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.00028610229492188
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041060447692871
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.00017404556274414
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0002 0.00015401840209961
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0081169605255127
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.00028800964355469
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081789493560791
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.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00017595291137695
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024788379669189
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0025031566619873
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.0002 0.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00017595291137695
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024540424346924
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.00027108192443848
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024900436401367
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.0001678466796875
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.0002 0.00016307830810547
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022339820861816
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028390884399414
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.00016403198242188
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0094759464263916
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.00029492378234863
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00023007392883301
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.010296106338501
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.0001828670501709
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.00016903877258301
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.00019216537475586
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015671253204346
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016069412231445
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.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018439292907715
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.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018529891967773
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.0002 0.00015711784362793
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.0002 0.00016212463378906
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00043106079101562
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069308280944824
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.00024914741516113
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00070691108703613
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.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 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 (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069117546081543
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.00024604797363281
SELECT id FROM categories WHERE parent_id = '90'
138 0.0008 0.00075197219848633
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00032782554626465
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.002007007598877
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.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020279884338379
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.0002 0.00016188621520996
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.0002 0.00015878677368164
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051510334014893
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00040006637573242
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00017905235290527
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016880035400391
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00017309188842773
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00018501281738281
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00031018257141113
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018620491027832
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00018882751464844
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.000244140625
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.0002598762512207
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00024199485778809
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00017023086547852
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '104'
333 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00016379356384277
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '252'
364 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00014805793762207
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013184547424316
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014069080352783
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0004 0.00039386749267578
SELECT * FROM pages WHERE pagename = 'riflescope-reviews'
373 0.0002 0.00021910667419434
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = 2
375 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 4
376 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = 12
377 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = 10
378 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = 7
379 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 18
380 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 28
381 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 13
382 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 3
383 0.0430 0.043004035949707
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
384 0.0003 0.00026392936706543
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:1560834318;s:8:\"products\";a:6:{i:7;s:6:\"409759\";i:12;s:6:\"414825\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:19;s:6:\"410949\";i:20;s:6:\"408079\";}}' WHERE id = '175'
385 0.0005 0.00048184394836426
SELECT * FROM products WHERE id IN (409759,414825,130885,408078,410949,408079) ORDER BY FIELD(id, 409759,414825,130885,408078,410949,408079 )
386 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
387 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '409759'
388 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '409759'
389 0.0028 0.0028350353240967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
390 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00014281272888184
UPDATE products SET price = '229000' WHERE id = '409759'
394 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
395 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '414825'
396 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414825'
397 0.0020 0.0020208358764648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
398 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00013995170593262
UPDATE products SET price = '11999' WHERE id = '414825'
402 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
403 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '130885'
404 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '130885'
405 0.0020 0.0020060539245605
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
406 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00012993812561035
UPDATE products SET price = '1521' WHERE id = '130885'
410 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
411 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '408078'
412 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '408078'
413 0.0031 0.0030820369720459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
414 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00013184547424316
UPDATE products SET price = '23352' WHERE id = '408078'
418 0.0002 0.00018715858459473
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
419 0.0002 0.00023317337036133
SELECT * FROM product_image_select WHERE product_id = '410949'
420 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '410949'
421 0.0027 0.002701997756958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
422 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00013494491577148
UPDATE products SET price = '47995' WHERE id = '410949'
426 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
427 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '408079'
428 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '408079'
429 0.0032 0.0032198429107666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
430 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00014376640319824
UPDATE products SET price = '18547' WHERE id = '408079'
434 0.0424 0.042433023452759
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
435 0.0002 0.00022578239440918
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:1560834318;s:8:\"products\";a:6:{i:5;s:6:\"404554\";i:7;s:6:\"409759\";i:21;s:6:\"406901\";i:23;s:5:\"43519\";i:14;s:6:\"406758\";i:22;s:6:\"400044\";}}' WHERE id = '177'
436 0.0005 0.00046706199645996
SELECT * FROM products WHERE id IN (404554,409759,406901,43519,406758,400044) ORDER BY FIELD(id, 404554,409759,406901,43519,406758,400044 )
437 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
438 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '404554'
439 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '404554'
440 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
441 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00013184547424316
UPDATE products SET price = '399999' WHERE id = '404554'
445 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
446 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '409759'
447 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '409759'
448 0.0028 0.0027921199798584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
449 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00013208389282227
UPDATE products SET price = '229000' WHERE id = '409759'
453 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
454 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '406901'
455 0.0001 0.00014901161193848
SELECT * FROM productcustomimages WHERE product_id = '406901'
456 0.0023 0.0023269653320312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
457 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00036382675170898
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00013184547424316
UPDATE products SET price = '395' WHERE id = '406901'
461 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
462 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '43519'
463 0.0001 0.00014281272888184
SELECT * FROM productcustomimages WHERE product_id = '43519'
464 0.0027 0.0026898384094238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
465 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00013113021850586
UPDATE products SET price = '1330' WHERE id = '43519'
469 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
470 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '406758'
471 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406758'
472 0.0026 0.0026490688323975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
473 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00021481513977051
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00013184547424316
UPDATE products SET price = '2694' WHERE id = '406758'
477 0.0002 0.00022482872009277
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
478 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '400044'
479 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '400044'
480 0.0028 0.0027978420257568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
481 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00013017654418945
UPDATE products SET price = '16091' WHERE id = '400044'
485 0.1034 0.10340785980225
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
486 0.0003 0.00026988983154297
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:1560834319;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"412927\";i:14;s:6:\"406758\";i:17;s:6:\"405644\";i:22;s:6:\"400044\";i:2;s:6:\"407595\";}}' WHERE id = '181'
487 0.0005 0.00049805641174316
SELECT * FROM products WHERE id IN (398315,412927,406758,405644,400044,407595) ORDER BY FIELD(id, 398315,412927,406758,405644,400044,407595 )
488 0.0002 0.00023317337036133
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
489 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '398315'
490 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '398315'
491 0.0025 0.0025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
492 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00013494491577148
UPDATE products SET price = '1999' WHERE id = '398315'
496 0.0003 0.00027823448181152
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
497 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '412927'
498 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '412927'
499 0.0037 0.0037009716033936
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
500 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00013208389282227
UPDATE products SET price = '199900' WHERE id = '412927'
504 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
505 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '406758'
506 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406758'
507 0.0026 0.0026311874389648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
508 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00013303756713867
UPDATE products SET price = '2694' WHERE id = '406758'
512 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
513 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '405644'
514 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '405644'
515 0.0040 0.003957986831665
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
516 0.0003 0.00025296211242676
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0006 0.00056886672973633
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0002 0.00016212463378906
UPDATE products SET price = '63539' WHERE id = '405644'
520 0.0003 0.00025582313537598
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
521 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '400044'
522 0.0002 0.0001530647277832
SELECT * FROM productcustomimages WHERE product_id = '400044'
523 0.0035 0.00350022315979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
524 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00014114379882812
UPDATE products SET price = '16091' WHERE id = '400044'
528 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
529 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '407595'
530 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '407595'
531 0.0034 0.0033988952636719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
532 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.0001220703125
UPDATE products SET price = '2497' WHERE id = '407595'
536 0.1026 0.10263800621033
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
537 0.0003 0.00026512145996094
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:1560834319;s:8:\"products\";a:6:{i:6;s:6:\"412927\";i:9;s:6:\"103845\";i:21;s:6:\"406901\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:2;s:6:\"407595\";}}' WHERE id = '183'
538 0.0005 0.00047492980957031
SELECT * FROM products WHERE id IN (412927,103845,406901,414940,398315,407595) ORDER BY FIELD(id, 412927,103845,406901,414940,398315,407595 )
539 0.0003 0.00027608871459961
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
540 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '412927'
541 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '412927'
542 0.0037 0.0036511421203613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
543 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.0001220703125
UPDATE products SET price = '199900' WHERE id = '412927'
547 0.0002 0.00019478797912598
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
548 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '103845'
549 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '103845'
550 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
551 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
555 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
556 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '406901'
557 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406901'
558 0.0023 0.0023360252380371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
559 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0003 0.00034379959106445
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011992454528809
UPDATE products SET price = '395' WHERE id = '406901'
563 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
564 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '414940'
565 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '414940'
566 0.0033 0.0032610893249512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
567 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011706352233887
UPDATE products SET price = '4490' WHERE id = '414940'
571 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
572 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '398315'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '398315'
574 0.0025 0.0025269985198975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
575 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00012016296386719
UPDATE products SET price = '1999' WHERE id = '398315'
579 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
580 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '407595'
581 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '407595'
582 0.0033 0.0033490657806396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
583 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011706352233887
UPDATE products SET price = '2497' WHERE id = '407595'
587 0.0004 0.00041604042053223
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00012707710266113
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00089502334594727
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00031304359436035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00028109550476074
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.0003659725189209
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00034499168395996
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'