Tactical Equipment - Survivalist Equipment

Rifle Scopes :: 22 Rifle Scope :: Hunting Rifle Scope :: Sniper Riflescope :: Tactical Riflescope Optics

Best Tactical Rifle Scopes Sale

UPDATED :  

A full range of affordable, high quality rifle scope optics to suit everything from plinkers to the super sniper scope sniper rifles. A rifle scope is an essential piece of equipment for placing accurate shots downrange, choosing a rifle scope is key to targeting success. When an iron sight just wont cut it, or in competition shooting whether you are looking for and air rifle scope, a cheap 22 rifle scope optics or other - it now becomes affordable to have the best chance of placing the perfect shot. Check our rifle scope comparison reviews on the lower left menu.

Precision Riflescope Optics

Rifle scopes online: Buying a rifle scope shouldn't be a tedious affair. Our most popular Nikon rifle scope promotes itself with unparalleled superiority and clarity in their glass optics, a top choice for long term reliability and resale value when buying a rifle scope. Looking for top-of-the-range optics? ...the best tactical rifle scopes? Maybe a rifle scope with rangefinder? The high quality Swarovski riflescope is second to none. Our riflescope range covers some of the best brands in the world including: Bushnell, Nikon, CVLIFE, Swarovski, ADF, BSA, Leica, Leupold, VORTEX, UTG, Barska, Beileshi, Leupold, Vokul, Sightmark, Tasco, FSI optics and Nightforce riflescopes to name a few. We have a comprehensive range of riflescopes for sale right here from the humble .22 riflescope to the many rifle scope AR15 users regularly use.

How To Choose A Rifle Scope Reticle

Our reticle selection covers Multi-X, MOAR, Nikoplex, BDC, Z-Plex, Mil-Dot and many more. There is also a wide selection of various passive and active illuminated rifle scope reticles available for various manufactorers including the ever famous Trijicon.


Hold-Over Reticle, vs. Ballistic Turret, vs. MOA

which reticle to use

Since the beginning of time, American’s have striven to get the maximum potential out of everything we do. For shooters and hunters alike, it was only a matter of time before we were going to find a way to shoot rifles out to a 1,000 yards and beyond!

With any new quest to push the limits farther than previously thought possible, comes trial and error, as well as the need to develop different strategies for making it happen.

Shooting a projectile from point 'A' to point 'B' would be no exception. Case in point — for as long as I can remember, when your target was beyond your sight in distance, you would aim above the target.

‘How much?’ you ask. That was simply a guess-timation based on how far away you perceived the target to be, and how many inches you guess-timated your aim point to be above your target.

Using this method was sometimes effective, but actually worked less often than one would hope for, hence, the hold-over reticle system was born.

Hold-over reticles added some intelligence to this above-mentioned method. For a period of time, it was thought that, with a decently working yardage rangefinder, these hold-over reticles would give us a sure fire aiming point.

I’m sure that a lot of hunters hit the woods with these systems and had immediate success. Heck, I was one of them; however, as you begin to run this system through the paces in a few different conditions, several flaws come to the surface.

Why? It could be one of many factors, but let's stick to the reticle itself. First, in order for many manufacturers to cut down on SKU’s, they made a reticle that was a come-one, come-all approach.

Meaning, if you mount this optic with this reticle on your rifle, you’re going to hit perfectly where you aim, in reference to which reticle line you choose.

That approach seemed like a good one at the time, however, it neither accounted for different velocities in a given cartridge, nor did it account for the ballistic coefficient of the many different bullets the shooter might be using.

The approaches were based on generic estimations for many calibers. The next generation upgraded with ballistic dial compensation.

This method has really taken hold with a fairly large group of guys who have implemented extended-range shots into their hunting tactics. This method appealed to add some of the missing pieces the hold-over reticles did not have.

Having the ability to laser-etch certain ballistic details on the turret cap itself, shooters were now able to add the detailed velocity and bullet information for the exact rifle they would be shooting.

However, even with those improvements, there was still similarity to the hold-over reticle, due to the static information that is given to the shooting system.

Static? What I mean by this is fixed information. Even with the information that has been compiled to make the above scenarios work, it leaves out the most important factor of all — atmospheric conditions -- more commonly known as air density, density altitude, barometric pressure, etc.

Up to this point, the most important variable in shooting a projectile from point 'A' to point 'B' accurately, has been neglected.

Admittedly, through the evolution of the above scenarios, there has been the introduction of the reticle calculator and the implementation of several different turret caps; but one would have to ask, why go through all of this when you can now incorporate the very software used to get us to this point right into your own shooting system? This leads us to our final stop, minute of angle (MOA.)

To keep things simple, MOA is a term that describes a unit of measurement. This unit of measurement is what most trajectory programs are based on. It also is how most common optic manufacturers build their turret adjustments, 1/4 MOA per click.

We now have rangefinders that can be set to give MOA output as a standard. When woricing your shooting system in MOA, as opposed to hold-over or yardage, you can become proficient by simply utilizing the amount of angle needed to make any shot, in any condition, at the time of the shot.

When given the correct information, air density, MOA works, no matter the distance of the shot. It simply accounts for how much angle is needed to get the bullet from the muzzle to the target, based on how thick or thin the air is at the time of the shot.

When looking back through the evolution of products, it is interesting to me that the best products use the facts at hand, to get me to my desired result.

Right now, and for the foreseeable future, all the rave is long-range shooting; however, I will be certain to prepare myself for what the next era blings!

Remember what makes us a responsible shooters is, practice, practice, practice. When you’re tiled of practicing, practice some more!

Bob Beck

Extreme Outer Limits T.V.


Matthew Carson discusses optics...

Rifle Scope SelectionThe Savage LRPV .22-250 with a 6-24x50 Simmons vari-power is an effective varminting rig.

Over thirty-five years of active shooting some rifles have come and gone, and the same applies to scope sights, the good the bad and the plain ugly. Unfortunately in this day and age the advertising hype would have you believe that unless you’re using a modern 36x scope with a tactical illuminated reticle and rose tinted lenses you will surely miss what you are aiming at!

At its most basic all a scope is useful for is to increase magnification which will allow better projectile placement, subject to the accuracy of your rifle. Extra magnification alone is no guarantee of extra accuracy; recently my best ever personal group with a rifle was shot with a 10x scope. You can spend a fortune on sights but at the other end of the scale there are now much cheaper versions that appear to be getting better in quality by the day. For most shooters/hunters the best option lies somewhere in the middle of the two extremes.

Further, the old saying that you only get what you pay for may not be exactly correct.

There are several cheap thirty-five year old scopes still in use by our family, although at the time of purchase, these sights, a straight 6x40, a 6x40 wide-angle, and a 4-12-x40 variable were considered of questionable Japanese quality.

Today it is not unusual for optical glass to be made in Japan or China, with the actual scopes being assembled in another country. Some still have a long way to go in terms of quality, but from personal observation the quality continues to get better. At the other end of the scale, our most expensive sight, costing over $1000, packed up after fifteen years of slight use, and it was not dropped or abused.

How A Rifle Scope Works

The requirements of the average hunter differ from the long range varmint hunter or the benchrest shooter; the distance to the potential target also plays a part and may influence the degree of magnification you require. The choice of reticles available at the present time is mind- numbing. There are so many variations that offering advice is fraught with danger. All I can do is offer suggestions based on experience and I would say that except for very specialist uses the clearer and less cluttered the reticle the better.

We do have fixed power sights, but the variable offers better flexibility. For general hunting possibly the most used scope is a 3-9x40; either with a standard cross-hair or a duplex reticle. The duplex has thicker cross-hairs at the edges, that become thinner near the middle, and this naturally concentrates the eye on the centre of the sight and allows for a clear picture.

The 3-9x40 size covers a range of uses and is well suited to spotlighting. On 3x it is ideal for bush and the quick acquisition of close-up targets.

Its close cousin the 4-12 vari- power is equally useful. Plain cross-hairs are useful in some circumstances, and very fine cross-hairs are popular for target and benchrest shooting.

The Plex reticle is one of the most popular for general hunting, and the Mil-Dot for long range and target shooting.

Usually sights of this type are of a fixed high power, and 36x is common when you are aiming to shoot a group only slightly bigger than a singular projectile diameter. However high magnification fixed-power scopes like 36x, due to their limited field of view, can make acquiring targets, even at long distance, an exercise in futility; a higher power variable is much more suitable. In addition, with high power sights you need to shoot off front and rear bags to get the necessary stability.

A couple of years ago a new 6.5x55 Tikka T3 arrived in the gun safe, and I could not go past a Bushnell 3-9 variable. Other American sights we’ve used over the years in this medium price range are Burris, Redfield and Weaver, and we have never had a problem with them.

Many deer are taken in poor light conditions, i.e., on dusk, so your scope should be able to make use of the minimum amount of light available. My mates recommend good quality European sights, like 3-12x50s because aside from poor light conditions, the background for dusk shots is likely to be on the dark side also.

The needs of the long range varmint hunter are different; here you have small targets (usually rabbits) that may be as much as 400 metres or more distant, sometimes over a valley with an unknown wind velocity thrown in, and we wonder why we miss even with the most accurate rifles!

For varminting a good variable sight allows quick acquisition and then you dial up the power to allow the precise shot location. Higher power variables like 6.5-20, 6-24 or perhaps an 8-32, are popular.

The cheap Japanese 6x40 wide-angle scope on this Husqvana .270 is still working okay after 30 plus years of use.

The very high power sights will show up your heartbeat, which can be a problem if you’re just using a bipod, a rear bag will allow for a steadier hold. This is a situation faced by benchrest shooters all the time.

When a Savage LRPV .22-250 appeared in the gun safe some years ago I contemplated what type and power of scope to mount.

Rifle scopes cheap: Something of reasonably high power was required to take advantage of the cartridge’s capability. Eventually I came across a US shooting web site that had a sale on Simmons 6-24x50 with a mil dot reticle for US $69.95. If the sight lasted twelve months I would have had my money’s worth.

3-9x Bushnell Scope The author’s Tikka T3 in 6.5x55 wears a 3–9x Bushnell, an ideal combination for deer.

Eight years later it’s still there! The only complaint is that the spacing of the mil dots has an incorrect value, a mil dot is 3.6 inches at 100 yards, on this sight the mil dots are spaced at 2-inches! Aside from that I have had nothing to complain about. For the price I would suggest that the sight was of Chinese manufacture.

Our 1895 Marlin .45-70 has worn a 1:3.5 variable Tasco scope for most of its life, and only recently has a newer Leupold 2-7x taken its place after the original fogged up, probably the seals leaked. However after twenty years of constant use we’re not complaining.

SIGHTING IN

If your new scope is not sighted in correctly the advantages of your cartridge/ rifle combination will be lost.

1-3.5x Tasco ScopeThis 1-3.5x Tasco short- range scope lasted 20 years on Matthew’s .45-70 before replacement.

In relation to hunting rifles like .243, .270 Winchester or 6.5x55, at what distance should the projectile impact meet the horizontal cross-hairs of the sight? The old understanding was that a hunting rifle should be sighted in three inches high at a hundred yards. Knowing the B.C of a particular projectile and the muzzle velocity of the same projectile it is not difficult using a computer program such as Load from a Disc (or similar) to work out the figures.

Don’t forget to use the actual figures from your rifle, reloading manuals are only a guide to velocities. The following table was worked out using Load from a Disc and our family rifles.

I still reckon that sighting in to be 3-inches high at 100 yards is not a bad idea. However, for scopes on lever-action rifles all our shooting group members sight in for a zero range of 100 yards, using either the .30-30 Win or 45-70 cartridges.

VARMINTING

For long-range varmint rifles the waters are somewhat muddier! It would be unusual to find a higher power scope that is not fitted with ranging marks, either mil dot or some other type.

CARTRIDGE PROJECTILE GR/B.C VELOCITY ZERO RANGE DROP/ 300 YDS.
.243 100/.446 2767FPS 242 YDS 4.9"
.270 130/.380 2735FPS 235 YDS 6"
6.5X55 140/.498 2450FPS 213 YDS 9.2"
.30-06 165/.446 2550FPS 220 YDS 8"

 

A ranging reticle need not be all that elaborate, it can be as simple as a set of cross-hairs plus lower ranging marks spaced at one inch intervals below the horizontal crosshairs. Using a program such as Load from a Disc it is not difficult to produce a table of projectile impact having regard to both the B.C. of a particular projectile and its initial velocity. Usually most sights in this category also have ranging marks horizontally on the central cross hairs to allow for wind drift, and there are many variations.

With long range varminting wind is a continual problem. You can measure wind strength at your location but almost invariably it will be stronger across an intervening valley. It’s a lot easier shooting over flat country.

Matthew


A RIFLEMAN'S OPTICS :: SCOPE EYE RELIEF

Shooting tips scope eye reliefTilting a rifle to shoot uphill or downhill tends to move a scope closer to the eye, increasing the possibility of hitting the eyebrow when the rifle fires.

Shoot a hard-kicking rifle or hold almost any rifle incorrectly, and sooner than later recoil is going to cause a scope to rear back and bite you. Some shooters wear their scar from a scope cut like a badge of courage. Others hold their heads down, concealing their cuts like a disfigurement. Whatever a shooter's temperament, tattooing an eyebrow or nose with a scope is not conducive to continued good shooting.

Eye relief is the distance from the last glass surface to where the eye is positioned to see the full field of view through a scope. A generous amount of eye relief is the best protection against receiving a smack on the forehead. Attention to your shooting position also goes a long way to keep a scope's ocular lens bell at a safe distance during recoil.

"For hard-kicking rifles you want to stay within that 3-1/2 inch range of eye relief," said Dave Domin, of Leupold & Stevens. "For such rifles, you probably want to stay away from high-magnification scopes that go down to about 2-1/2 inches of eye relief."

A scope's eye relief is intertwined with its magnification and field of view (FOV). If magnification is increased, FOV must decrease or eye relief must be reduced. Enlarge FOV, and magnification must decline or eye relief is shortened. If eye relief is increased, FOV or magnification must be decreased.

A variable scope allows magnification adjustment to provide the right mix of eye relief, FOV and magnification. For example, a Leupold VX-3 1.5-5x 20mm scope set on 1.5x has 4.40 inches of eye relief and 3.70 inches of eye relief when turned up to 5x. Such a relatively low-power scope is a good choice for a hard-kicking rifle, like a .416 magnum, that will be shot at short distances. Its FOV of 68 feet at 100 yards at the lowest power and 23.80 feet at the highest power is a plus for quickly getting on target.

Increased magnification provides more exact aiming for long-range shooting. A Leupold VX-3 4.5-14x 40mm scope provides the same eye relief at its lowest and highest settings as the 1.5-5x 20mm scope. That comes mainly from the higher-power scope's objective lens that is twice as large in diameter. However, the higher magnification variable's FOV is about a third of the lower-magnification variable's FOV.

Extended eye relief scopes, commonly called scout scopes, could be the solution to preventing scope cuts, because their extra-long eye relief allows mounting them far forward on a rifle. "But these scopes usually don't have enough magnification for long-range shooting," Domin said, "and their FOV is rather narrow." Leupold's VX-2 1.5-4x 28mm IER Scout Scope has 6.90 and 6.0 inches of eye relief at its lowest and highest settings, but its FOV is a narrow 41.70 and 17.30 feet, respectively, at 100 yards.

Properly placing a scope in its rings is important to attain the maximum amount of eye relief. Domin said when mounting a scope, turn it to its highest power and slowly push it forward in the rings until the full FOV is lost. "Then slightly pull the scope back to where you can see the full FOV, and it will be correctly positioned," he said. That scope position provides some rearward leeway in placing your eye.

The shooter's position behind a scope also determines if a scope can get a running start at his eyebrow. Scopes with a 40mm diameter or narrower objective lens allow mounting it fairly low over a rifle's receiver. That helps keep a shooter's cheek in tight contact with the stock comb, the head from sliding forward during recoil and the eyebrow away from the scope. "It's best to strap a comb riser on a stock when using scopes with a larger objective lens, like a 56mm," Domin said.


The Modern Rifle Scope...

"With the widespread acceptance of the 30mm scope tube in recent years, advancements have been employed that have corrected many of the problems encountered with one-inch tubes. In addition to better optical quality, light transmission, coatings, etc., 30mm tubes allow significantly greater MOA adjustment. In other words, a rifle can be zeroed at 300 yards and still offer plenty of elevation adjustment to "dial" the scope turrent for a dead zero aim at 1,000 yards and beyond."

"Other important features include zero stops, 1/4 - and even 1/8 - MOA repeatable adjustments, advanced reticles, mil-dots and other tools. Click adjustments, along with custom ballistic-matched turrets, allow the shooter to precisely adjust or dial to bring zero to a specific distance in just moments. Naturally, the shooter will need to compensate for win d drift, bullet rotation drift and earth rotation during the bullet's time of flight, but scopes with a first focal plane and various reticles help make those adjustments easier."


TAGS: rifle scope comparison RIFLE SCOPE CLEARANCE rifle scope AR15 .22 RIFLE SCOPE buying a rifle scope CHOOSING A RIFLESCOPE rifle scope buyers guide RIFLESCOPE REVIEWS best riflescopes RIFLE SCOPE DEALS


Check our many rifle scope reviews in the sidebar such as the Leupold scope for military use, high quality Meopta scopes and the military grade Nightforce rifle scopes.


Nikon BLACK FORCE 1000 1-4X24mm Riflescope

Nikon black force 1000 for sale

The new BLACK FORCE1000 scope delivers fast targeting speed, repeatable precision, and superior accuracy for AR-type rifles.

It features true 1X magnification and 4X zoom, rugged construction with metal-capped turrets, lead-free and arsenic-free multicoated glass, an aircraft-grade aluminum-alloy 30mm main tube, and a Type-III hard anodizing surface finish.

Located in the second focal plane, Nikons SPEEDFORCE glass-etched, illuminated reticle is an MOA subtension reticle engineered to enable shooters to continue momentum from target to target.

It offers 10 intensity settings and powers down after 1 hour of non-operation.


Shepherd Rugged Series Riflescopes

Shepherd scopes for sale

Shepherds new Rugged riflescopes, which are just beginning to be available as you read this, are built to "endure any tactical weapon system or environment there is," according to the company.

These scopes have added strength to the turret assemblies, lens retainers, and interior support systems. As with all Shepherd scopes, the best extra-low dispersion glass is used to synchronize colors and focus wavelength.

Two models are offered in the Rugged series: 1-4X 24mm and 2.5-15X 50mm. Both scopes feature 30mm tubes, fully multicoated lenses, and recoil resistance ratings of 1,000g.

The 1-4X 24mm comes with a dual-color red and green illuminated BDC combat reticle; the 2.5-15X 50mm comes with a red illuminated RFP cross-hair reticle. All Shepherd scopes come with a lifetime warranty. MSRP: $575 (1-4X 24mm); $850 (2.5-15X 50mm)


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.9199371337891 925 1.0056 0


No Amazon API Requests Made.


App Debug - Total Time 1.9199371337891 seconds

Number Time From Start Name Description
1 0.45733618736267 Initialise Initialise FSB Function
2 0.46943497657776 App Controller Start Start of the App controller (called before the controller of every page)
3 0.53154611587524 App Controller End End of the App controller (called before the controller of every page)
4 0.53168916702271 Category Start Start of the category controller
5 0.53169298171997 Before Get Category Before getting the category information
6 0.57822513580322 After Get Category After getting the category information
7 0.57822704315186 Before Get Category List Before getting the updated category list
8 0.57835912704468 Start of getCategoryListByGroup Function Before first category groups query
9 0.57853007316589 After initial query Before first category groups query
10 0.57853198051453 Get Category List for Group Before the call to getCategoryList function
11 0.57853507995605 Start of GetCategoryList function Start of the function
12 0.5785391330719 Before getting categories Query to get specific category list
13 0.57907104492188 After getting categories Query to get specific category list
14 0.57907199859619 Before getting category custom Before call to function getCategoryCustom
15 0.58082318305969 After getting category custom After call to function getCategoryCustom
16 0.58082604408264 Before getting category custom Before call to function getCategoryCustom
17 0.59130096435547 After getting category custom After call to function getCategoryCustom
18 0.59130501747131 Before getting category custom Before call to function getCategoryCustom
19 0.59719014167786 After getting category custom After call to function getCategoryCustom
20 0.59719300270081 Before getting category custom Before call to function getCategoryCustom
21 0.60126805305481 After getting category custom After call to function getCategoryCustom
22 0.60127115249634 End of GetCategoryList function End of the function
23 0.60127806663513 Get Category List for Group Before the call to getCategoryList function
24 0.60127997398376 Start of GetCategoryList function Start of the function
25 0.60128307342529 Before getting categories Query to get specific category list
26 0.60169219970703 After getting categories Query to get specific category list
27 0.60169315338135 Before getting category custom Before call to function getCategoryCustom
28 0.60727620124817 After getting category custom After call to function getCategoryCustom
29 0.60727906227112 Before getting category custom Before call to function getCategoryCustom
30 0.61801218986511 After getting category custom After call to function getCategoryCustom
31 0.61801505088806 End of GetCategoryList function End of the function
32 0.61802315711975 Get Category List for Group Before the call to getCategoryList function
33 0.6180260181427 Start of GetCategoryList function Start of the function
34 0.61803007125854 Before getting categories Query to get specific category list
35 0.6187059879303 After getting categories Query to get specific category list
36 0.61870813369751 Before getting category custom Before call to function getCategoryCustom
37 0.62812304496765 After getting category custom After call to function getCategoryCustom
38 0.62812614440918 Before getting category custom Before call to function getCategoryCustom
39 0.64601397514343 After getting category custom After call to function getCategoryCustom
40 0.64601707458496 Before getting category custom Before call to function getCategoryCustom
41 0.65194702148438 After getting category custom After call to function getCategoryCustom
42 0.6519501209259 Before getting category custom Before call to function getCategoryCustom
43 0.65782904624939 After getting category custom After call to function getCategoryCustom
44 0.6578311920166 Before getting category custom Before call to function getCategoryCustom
45 0.66407203674316 After getting category custom After call to function getCategoryCustom
46 0.66407513618469 Before getting category custom Before call to function getCategoryCustom
47 0.68586611747742 After getting category custom After call to function getCategoryCustom
48 0.68586802482605 Before getting sub category list Before call to recursive function getCategoryList
49 0.68587112426758 Start of GetCategoryList function Start of the function
50 0.68587398529053 Before getting categories Query to get specific category list
51 0.68625903129578 After getting categories Query to get specific category list
52 0.68626117706299 Before getting category custom Before call to function getCategoryCustom
53 0.68845415115356 After getting category custom After call to function getCategoryCustom
54 0.68845510482788 Before getting sub category list Before call to recursive function getCategoryList
55 0.68845701217651 Start of GetCategoryList function Start of the function
56 0.68845915794373 Before getting categories Query to get specific category list
57 0.68873810768127 After getting sub category list After call to recursive function getCategoryList
58 0.68874001502991 Before getting category custom Before call to function getCategoryCustom
59 0.69109010696411 After getting category custom After call to function getCategoryCustom
60 0.69109106063843 Before getting sub category list Before call to recursive function getCategoryList
61 0.69109201431274 Start of GetCategoryList function Start of the function
62 0.69109511375427 Before getting categories Query to get specific category list
63 0.69137215614319 After getting sub category list After call to recursive function getCategoryList
64 0.69137501716614 Before getting category custom Before call to function getCategoryCustom
65 0.69263911247253 After getting category custom After call to function getCategoryCustom
66 0.69264197349548 Before getting sub category list Before call to recursive function getCategoryList
67 0.69264316558838 Start of GetCategoryList function Start of the function
68 0.69264507293701 Before getting categories Query to get specific category list
69 0.69291710853577 After getting sub category list After call to recursive function getCategoryList
70 0.6929190158844 Before getting category custom Before call to function getCategoryCustom
71 0.69452214241028 After getting category custom After call to function getCategoryCustom
72 0.69452404975891 Before getting sub category list Before call to recursive function getCategoryList
73 0.69452619552612 Start of GetCategoryList function Start of the function
74 0.69453001022339 Before getting categories Query to get specific category list
75 0.69482898712158 After getting sub category list After call to recursive function getCategoryList
76 0.69483113288879 Before getting category custom Before call to function getCategoryCustom
77 0.69728708267212 After getting category custom After call to function getCategoryCustom
78 0.69728803634644 Before getting sub category list Before call to recursive function getCategoryList
79 0.69729018211365 Start of GetCategoryList function Start of the function
80 0.69729208946228 Before getting categories Query to get specific category list
81 0.69759011268616 After getting sub category list After call to recursive function getCategoryList
82 0.69759106636047 End of GetCategoryList function End of the function
83 0.6976010799408 After getting sub category list After call to recursive function getCategoryList
84 0.69760203361511 Before getting category custom Before call to function getCategoryCustom
85 0.70170712471008 After getting category custom After call to function getCategoryCustom
86 0.70170998573303 Before getting category custom Before call to function getCategoryCustom
87 0.70703315734863 After getting category custom After call to function getCategoryCustom
88 0.70703506469727 End of GetCategoryList function End of the function
89 0.70705103874207 Get Category List for Group Before the call to getCategoryList function
90 0.70705318450928 Start of GetCategoryList function Start of the function
91 0.70705604553223 Before getting categories Query to get specific category list
92 0.70747017860413 After getting categories Query to get specific category list
93 0.70747113227844 Before getting category custom Before call to function getCategoryCustom
94 0.70975613594055 After getting category custom After call to function getCategoryCustom
95 0.7097589969635 Before getting category custom Before call to function getCategoryCustom
96 0.71205306053162 After getting category custom After call to function getCategoryCustom
97 0.71205496788025 End of GetCategoryList function End of the function
98 0.71206212043762 Get Category List for Group Before the call to getCategoryList function
99 0.71206402778625 Start of GetCategoryList function Start of the function
100 0.71206712722778 Before getting categories Query to get specific category list
101 0.71237516403198 After getting categories Query to get specific category list
102 0.7123761177063 Before getting category custom Before call to function getCategoryCustom
103 0.71737718582153 After getting category custom After call to function getCategoryCustom
104 0.71737909317017 End of GetCategoryList function End of the function
105 0.71738505363464 End of getCategoryListByGroup Function Before return()
106 0.71738910675049 After Get Category List After getting the updated category list
107 0.71738910675049 Before Category Images Before getting the category images
108 0.7175190448761 After Category Images After getting the category images
109 0.71788501739502 Before Sub Category Check Before checking for sub category or products category
110 0.72787117958069 Before Category Products Controller Before loading the category products controller
111 0.72803115844727 Start Category Products Start of Category Products Controller
112 0.72805905342102 After Pagination Options After pagination options in Category Products Controller
113 0.728520154953 After Cache After Cache checking in Category Products Controller
114 0.81079697608948 After Filter Options After getting filter options and SQL in Category Products Controller
115 0.82164096832275 After Counting Products After counting products in the Category Products Controller
116 0.82180619239807 After Counting Bundles After counting bundles in the Category Products Controller
117 0.82196116447449 After Counting Products After counting products in the Category Products Controller
118 0.85474514961243 After Getting Products After getting products and bundles in the Category Products Controller
119 0.85488605499268 After Pagination Links After getting pagination listing links in the Category Products Controller
120 0.85488820075989 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
121 0.97131609916687 After Getting Product Details After getting full product details in the Category Products Controller
122 0.97659397125244 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
123 0.9781551361084 App_after Controller Start Start of the App_after controller (called after the controller of every page)
124 0.9782440662384 Before Get Options Before the call to getOptions in the tpl class
125 1.5028760433197 After Get Options After the call to getOptions in the tpl class
126 1.503406047821 App_after Controller End End of the App_after controller (called after the controller of every page)
127 1.5034251213074 Before Smarty Before passing everything over to Smarty in the Category Products Controller
128 1.9199111461639 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
129 1.9199151992798 Finalizing debug Before the debug is output to the page.
130 1.9199349880219 End of App This is the end of the app logging, final timestamp


Query Debug - 925 Database Queries. Total time 1.0056 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016117095947266
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00051593780517578
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00018787384033203
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017905235290527
SELECT * FROM `bad_bots`
5 0.0004 0.00043106079101562
SELECT parameter, value FROM parameters
6 0.0002 0.00015401840209961
SET time_zone = 'Europe/London'
7 0.0003 0.00029706954956055
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015783309936523
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00019598007202148
delete from cachefiles
10 0.0002 0.00022506713867188
SELECT id FROM pages WHERE pagename = 'rifle-scopes' LIMIT 1
11 0.0002 0.00020408630371094
SELECT id FROM products WHERE pagename = 'rifle-scopes' AND hidden = 0 LIMIT 1
12 0.0001 0.00011086463928223
SELECT id FROM ebay_products WHERE pagename = 'rifle-scopes'
13 0.0002 0.00016188621520996
SELECT id FROM categories WHERE pagename = 'rifle-scopes' LIMIT 1
14 0.0008 0.0007779598236084
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0096 0.009598970413208
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0002 0.00024700164794922
SELECT * FROM pages WHERE pagename = 'rifle-scopes'
17 0.0051 0.0050978660583496
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.0003662109375
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.00018882751464844
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00017309188842773
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '84'
24 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '135'
28 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '357'
33 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '379'
34 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '401'
35 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '450'
36 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '43'
42 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '44'
43 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '107'
48 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '108'
49 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '133'
51 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '217'
53 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '228'
54 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '271'
56 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '286'
57 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '364'
64 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '369'
66 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00016283988952637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '90'
72 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '414'
73 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '119'
74 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '406'
75 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '149'
76 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '150'
77 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '162'
79 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '164'
80 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '167'
81 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '180'
82 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '265'
84 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '268'
85 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
86 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '290'
87 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '413'
88 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '409'
89 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '327'
90 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '351'
92 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '370'
97 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '386'
99 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '408'
100 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '428'
106 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '432'
107 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '433'
108 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '436'
109 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '437'
110 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
112 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '74'
114 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '145'
116 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '156'
117 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '407'
118 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '316'
121 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '334'
123 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '367'
124 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '387'
125 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '42'
130 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '86'
132 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '95'
133 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '102'
134 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '138'
138 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '62'
140 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '317'
146 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '343'
148 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '349'
153 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '393'
156 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '394'
157 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '421'
160 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '426'
161 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '430'
162 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '441'
167 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '451'
168 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '453'
169 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '146'
171 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
172 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '293'
174 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '417'
176 0.0001 0.00014090538024902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00019121170043945
SELECT * FROM pages WHERE id = '181'
179 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '299'
181 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '300'
182 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '385'
184 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '442'
186 0.0002 0.00018906593322754
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0003 0.00026082992553711
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = '134'
189 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '248'
193 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.0001671314239502
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '115'
200 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '151'
203 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '200'
205 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
206 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '321'
207 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '350'
209 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '378'
210 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '425'
212 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '443'
213 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '444'
214 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '445'
215 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '446'
216 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '447'
217 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '448'
218 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '455'
219 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '456'
220 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '460'
222 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '462'
223 0.0001 0.00014400482177734
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '182'
226 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '238'
227 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '240'
228 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '242'
229 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '252'
230 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '253'
231 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '262'
232 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = '267'
233 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '420'
234 0.0001 0.00014686584472656
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00011491775512695
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0015 0.0015158653259277
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00031113624572754
SELECT * FROM categories WHERE pagename = 'rifle-scopes'
239 0.0099 0.0098509788513184
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
240 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
241 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '34'
242 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '94'
243 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '98'
244 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '99'
245 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '110'
246 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '130'
247 0.0105 0.010494947433472
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 
248 0.0002 0.00020909309387207
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 
249 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 (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
250 0.0002 0.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
251 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '34'
252 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '94'
253 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '98'
254 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '99'
255 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '110'
256 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '130'
257 0.0119 0.01192307472229
SELECT 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.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
258 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '405638' ORDER BY sortorder ASC
259 0.0001 0.00011205673217773
SELECT * FROM categoryimages WHERE category_id = 34
260 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '10'
261 0.0096 0.0096020698547363
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '34'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
262 0.0002 0.00015807151794434
SELECT parent_id FROM categories WHERE id = '34'
263 0.0001 0.00011587142944336
SELECT parent_id FROM categories WHERE id = '34'
264 0.0002 0.0001530647277832
SELECT * FROM categorygroups ORDER BY sortorder ASC
265 0.0005 0.00049209594726562
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
266 0.0004 0.00043582916259766
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
267 0.0002 0.00022578239440918
SELECT id FROM categories WHERE parent_id = '49'
268 0.0004 0.0004279613494873
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 
269 0.0001 0.00013494491577148
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 
270 0.0002 0.00015401840209961
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 
271 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
272 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '1'
273 0.0030 0.0029828548431396
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
274 0.0003 0.00025320053100586
SELECT id FROM categories WHERE parent_id = '50'
275 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '96'
276 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '97'
277 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '111'
278 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '129'
279 0.0057 0.0057029724121094
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 
280 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
281 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
282 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
283 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '1'
284 0.0025 0.0024869441986084
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
285 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '80'
286 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 (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
287 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
288 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
289 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
290 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '1'
291 0.0011 0.0011489391326904
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
292 0.0003 0.00025320053100586
SELECT id FROM categories WHERE parent_id = '51'
293 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '101'
294 0.0018 0.0017871856689453
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 
295 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 (101,51)
				  AND p.disabled = 0 
296 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
297 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
298 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '1'
299 0.0004 0.00038504600524902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
300 0.0023 0.0023281574249268
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
301 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '30'
302 0.0023 0.0023291110992432
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 
303 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
304 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
305 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
306 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '2'
307 0.0048 0.0048458576202393
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
308 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '61'
309 0.0049 0.0049221515655518
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 
310 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
311 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
312 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
313 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '2'
314 0.0006 0.00061511993408203
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
315 0.0042 0.0042281150817871
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
316 0.0003 0.00027084350585938
SELECT id FROM categories WHERE parent_id = '64'
317 0.0042 0.0042099952697754
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 
318 0.0002 0.00016021728515625
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
319 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
320 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
321 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
322 0.0085 0.0084881782531738
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
323 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '65'
324 0.0084 0.0084190368652344
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 
325 0.0002 0.00016999244689941
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 
326 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
327 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
328 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
329 0.0025 0.0025088787078857
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
330 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '81'
331 0.0025 0.002493143081665
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 
332 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 (81)
				  AND p.disabled = 0 
333 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
334 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
335 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
336 0.0025 0.0024650096893311
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
337 0.0003 0.00027084350585938
SELECT id FROM categories WHERE parent_id = '31'
338 0.0025 0.0024631023406982
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 
339 0.0001 0.00014686584472656
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 
340 0.0002 0.00015401840209961
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 
341 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
342 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
343 0.0023 0.0022571086883545
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
344 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '66'
345 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '131'
346 0.0028 0.0028200149536133
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 
347 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
348 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
349 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
350 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '10'
351 0.0095 0.0095150470733643
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
352 0.0003 0.00028419494628906
SELECT id FROM categories WHERE parent_id = '34'
353 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '94'
354 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '98'
355 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '99'
356 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '110'
357 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '130'
358 0.0102 0.010209083557129
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 
359 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
360 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 (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
361 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
362 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
363 0.0004 0.00035881996154785
SELECT * FROM categories WHERE parent_id = '34'  AND hidden = 0 ORDER BY sortorder ASC
364 0.0006 0.00064206123352051
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 = 94
365 0.0002 0.00022411346435547
SELECT id FROM categories WHERE parent_id = '94'
366 0.0007 0.00066804885864258
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
367 0.0001 0.00014114379882812
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94)
				  AND p.disabled = 0 
368 0.0001 0.00014090538024902
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
369 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '94'
370 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
371 0.0003 0.00026798248291016
SELECT * FROM categories WHERE parent_id = '94'  AND hidden = 0 ORDER BY sortorder ASC
372 0.0007 0.00071597099304199
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 = 98
373 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '98'
374 0.0008 0.00076198577880859
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
375 0.0001 0.00013899803161621
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
376 0.0001 0.00014019012451172
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
377 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
378 0.0001 0.00012016296386719
SELECT * FROM categorygroups WHERE id = '10'
379 0.0003 0.00026702880859375
SELECT * FROM categories WHERE parent_id = '98'  AND hidden = 0 ORDER BY sortorder ASC
380 0.0002 0.00020790100097656
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 = 99
381 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '99'
382 0.0002 0.00021791458129883
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (99)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
383 0.0001 0.00013113021850586
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (99)
				  AND p.disabled = 0 
384 0.0001 0.0001380443572998
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (99)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
385 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '99'
386 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '10'
387 0.0003 0.00026106834411621
SELECT * FROM categories WHERE parent_id = '99'  AND hidden = 0 ORDER BY sortorder ASC
388 0.0003 0.00033783912658691
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 = 110
389 0.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '110'
390 0.0004 0.00036406517028809
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (110)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
391 0.0001 0.00013208389282227
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (110)
				  AND p.disabled = 0 
392 0.0001 0.00013899803161621
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (110)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
393 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '110'
394 0.0002 0.00015592575073242
SELECT * FROM categorygroups WHERE id = '10'
395 0.0003 0.00028586387634277
SELECT * FROM categories WHERE parent_id = '110'  AND hidden = 0 ORDER BY sortorder ASC
396 0.0008 0.00078487396240234
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 = 130
397 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '130'
398 0.0008 0.00080394744873047
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (130)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
399 0.0001 0.00014090538024902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (130)
				  AND p.disabled = 0 
400 0.0001 0.00014114379882812
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (130)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
401 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '130'
402 0.0001 0.00011897087097168
SELECT * FROM categorygroups WHERE id = '1'
403 0.0003 0.00028800964355469
SELECT * FROM categories WHERE parent_id = '130'  AND hidden = 0 ORDER BY sortorder ASC
404 0.0016 0.0015881061553955
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
405 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '32'
406 0.0016 0.0015850067138672
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 
407 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
408 0.0001 0.00014185905456543
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 
409 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
410 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
411 0.0022 0.0022070407867432
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
412 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '89'
413 0.0022 0.0021941661834717
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 
414 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
415 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
416 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
417 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '10'
418 0.0004 0.00037693977355957
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
419 0.0007 0.00067710876464844
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
420 0.0002 0.00023603439331055
SELECT id FROM categories WHERE parent_id = '84'
421 0.0007 0.00069618225097656
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 
422 0.0001 0.00014114379882812
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 
423 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
424 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
425 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '17'
426 0.0007 0.00069999694824219
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
427 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '90'
428 0.0007 0.00071406364440918
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 
429 0.0001 0.00013995170593262
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
430 0.0001 0.00014114379882812
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
431 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
432 0.0001 0.00011897087097168
SELECT * FROM categorygroups WHERE id = '17'
433 0.0003 0.00029492378234863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
434 0.0020 0.0020461082458496
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
435 0.0002 0.00023913383483887
SELECT id FROM categories WHERE parent_id = '92'
436 0.0021 0.0020549297332764
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 
437 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
438 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
439 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
440 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '20'
441 0.0001 0.00011301040649414
SELECT * FROM categoryimages WHERE category_id = 34
442 0.0002 0.00015997886657715
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
443 0.0003 0.00028085708618164
SELECT * FROM categories WHERE parent_id = '34'
444 0.0096 0.0096449851989746
SELECT COUNT(*) FROM products_categories c, products p WHERE p.id = c.product_id AND c.category_id = '34' AND p.hidden = 0 AND (p.price > 0 OR p.parent = 1)
445 0.0339 0.03386402130127
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
446 0.0062 0.0061500072479248
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
447 0.0003 0.00031304359436035
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
448 0.0339 0.033941984176636
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
449 0.0063 0.0062870979309082
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
450 0.0003 0.00032782554626465
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
451 0.0105 0.010526895523071
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 34
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
452 0.0003 0.00025510787963867
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 34
		AND c.prod_type = 'ebay'
		AND hide = 1
453 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 34
			AND p.disabled = 0
			
			AND 1 = 1
454 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 34
		AND c.prod_type = 'custom'
		AND hide = 1
455 0.0327 0.032674074172974
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 34
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 34
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 34
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 34
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
456 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = '405638'
457 0.0003 0.0002892017364502
SELECT * FROM productimages WHERE product_id = '405638' ORDER BY sortorder ASC
458 0.0006 0.00057315826416016
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '405638' AND p.id = pi.product_id ORDER BY pi.sortorder
459 0.0004 0.00036907196044922
SELECT * FROM product_image_select WHERE product_id = '405638'
460 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '405638'
461 0.0004 0.00040388107299805
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405638'
                GROUP BY o.product_id
462 0.0006 0.00055193901062012
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405638'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
463 0.0003 0.00034618377685547
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405638
464 0.0127 0.01273512840271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405638' AND a.name = n.originalname
465 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '405638' AND merchantid = 'ATVPDKIKX0DER'
466 0.0003 0.00030708312988281
SELECT * FROM productoffers
                WHERE product_id = '405638' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = 405638
                ORDER BY price ASC LIMIT 1
468 0.0004 0.00039410591125488
SELECT value FROM productattributes
                WHERE product_id = '405638'
                AND name = 'ListPriceAmount'
469 0.0004 0.00043511390686035
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405638'
                GROUP BY o.product_id
470 0.0005 0.00053215026855469
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405638'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
471 0.0004 0.0003669261932373
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405638
472 0.0006 0.00063204765319824
SELECT value FROM productattributes WHERE product_id = '405638' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0006 0.00064516067504883
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '405638'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
474 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = '232837'
475 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
476 0.0003 0.00034713745117188
SELECT * FROM product_image_select WHERE product_id = '232837'
477 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '232837'
478 0.0058 0.0057930946350098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232837' AND a.name = n.originalname
479 0.0004 0.00039291381835938
SELECT * FROM productoffers WHERE product_id = '232837' AND merchantid = 'ATVPDKIKX0DER'
480 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '232837' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0006 0.00058984756469727
SELECT value FROM productattributes WHERE product_id = '232837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0002 0.00020003318786621
UPDATE products SET price = '8077' WHERE id = '232837'
483 0.0003 0.00030112266540527
SELECT * FROM products WHERE id = '232842'
484 0.0007 0.00072002410888672
SELECT * FROM productimages WHERE product_id = '232842' ORDER BY sortorder ASC
485 0.0004 0.00037908554077148
SELECT * FROM product_image_select WHERE product_id = '232842'
486 0.0002 0.00017309188842773
SELECT * FROM productcustomimages WHERE product_id = '232842'
487 0.0036 0.0035691261291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232842' AND a.name = n.originalname
488 0.0003 0.00033402442932129
SELECT * FROM productoffers WHERE product_id = '232842' AND merchantid = 'ATVPDKIKX0DER'
489 0.0003 0.00028800964355469
SELECT * FROM productoffers
                WHERE product_id = '232842' AND price > 0
                ORDER BY price ASC LIMIT 1
490 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = 232842
                ORDER BY price ASC LIMIT 1
491 0.0004 0.00040888786315918
SELECT value FROM productattributes
                WHERE product_id = '232842'
                AND name = 'ListPriceAmount'
492 0.0002 0.00020408630371094
UPDATE products SET price = '24999' WHERE id = '232842'
493 0.0003 0.00030612945556641
SELECT * FROM products WHERE id = '360231'
494 0.0006 0.0005648136138916
SELECT * FROM productimages WHERE product_id = '360231' ORDER BY sortorder ASC
495 0.0004 0.00035595893859863
SELECT * FROM product_image_select WHERE product_id = '360231'
496 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '360231'
497 0.0041 0.0041048526763916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '360231' AND a.name = n.originalname
498 0.0003 0.00026822090148926
SELECT * FROM productoffers WHERE product_id = '360231' AND merchantid = 'ATVPDKIKX0DER'
499 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '360231' AND price > 0
                ORDER BY price ASC LIMIT 1
500 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 360231
                ORDER BY price ASC LIMIT 1
501 0.0003 0.00028014183044434
SELECT value FROM productattributes
                WHERE product_id = '360231'
                AND name = 'ListPriceAmount'
502 0.0001 0.00014591217041016
UPDATE products SET price = '3797' WHERE id = '360231'
503 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '414375'
504 0.0002 0.00015401840209961
SELECT * FROM productimages WHERE product_id = '414375' ORDER BY sortorder ASC
505 0.0006 0.00059318542480469
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '414375' AND p.id = pi.product_id ORDER BY pi.sortorder
506 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '414375'
507 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '414375'
508 0.0003 0.00025582313537598
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414375'
                GROUP BY o.product_id
509 0.0004 0.00038790702819824
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414375'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
510 0.0002 0.00023484230041504
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414375
511 0.0005 0.00049400329589844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414375' AND a.name = n.originalname
512 0.0002 0.00016593933105469
SELECT * FROM productoffers WHERE product_id = '414375' AND merchantid = 'ATVPDKIKX0DER'
513 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = '414375' AND price > 0
                ORDER BY price ASC LIMIT 1
514 0.0002 0.00017213821411133
SELECT * FROM productoffers
                WHERE product_id = 414375
                ORDER BY price ASC LIMIT 1
515 0.0002 0.000244140625
SELECT value FROM productattributes
                WHERE product_id = '414375'
                AND name = 'ListPriceAmount'
516 0.0002 0.0002448558807373
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414375'
                GROUP BY o.product_id
517 0.0004 0.00036787986755371
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414375'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
518 0.0002 0.00022006034851074
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414375
519 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '414375' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
520 0.0004 0.00035810470581055
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '414375'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
521 0.0004 0.00036811828613281
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '414375'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
522 0.0002 0.00020813941955566
SELECT * FROM products WHERE id = '405444'
523 0.0001 0.00014901161193848
SELECT * FROM productimages WHERE product_id = '405444' ORDER BY sortorder ASC
524 0.0002 0.0002291202545166
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '405444' AND p.id = pi.product_id ORDER BY pi.sortorder
525 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '405444'
526 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '405444'
527 0.0002 0.00021815299987793
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405444'
                GROUP BY o.product_id
528 0.0003 0.00027298927307129
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405444'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
529 0.0002 0.00020503997802734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405444
530 0.0027 0.0026509761810303
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405444' AND a.name = n.originalname
531 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '405444' AND merchantid = 'ATVPDKIKX0DER'
532 0.0002 0.00018477439880371
SELECT * FROM productoffers
                WHERE product_id = '405444' AND price > 0
                ORDER BY price ASC LIMIT 1
533 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 405444
                ORDER BY price ASC LIMIT 1
534 0.0003 0.00025606155395508
SELECT value FROM productattributes
                WHERE product_id = '405444'
                AND name = 'ListPriceAmount'
535 0.0002 0.00021886825561523
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405444'
                GROUP BY o.product_id
536 0.0003 0.00028085708618164
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405444'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
537 0.0002 0.00019407272338867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405444
538 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '405444' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
539 0.0003 0.00033092498779297
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '405444'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
540 0.0002 0.00021004676818848
SELECT * FROM products WHERE id = '400671'
541 0.0002 0.00023508071899414
SELECT * FROM productimages WHERE product_id = '400671' ORDER BY sortorder ASC
542 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '400671'
543 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '400671'
544 0.0029 0.0029489994049072
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400671' AND a.name = n.originalname
545 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '400671' AND merchantid = 'ATVPDKIKX0DER'
546 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '400671' AND price > 0
                ORDER BY price ASC LIMIT 1
547 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '400671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
548 0.0001 0.00012898445129395
UPDATE products SET price = '6113' WHERE id = '400671'
549 0.0002 0.00019717216491699
SELECT * FROM products WHERE id = '251867'
550 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '251867' ORDER BY sortorder ASC
551 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '251867'
552 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '251867'
553 0.0027 0.0027461051940918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '251867' AND a.name = n.originalname
554 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '251867' AND merchantid = 'ATVPDKIKX0DER'
555 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '251867' AND price > 0
                ORDER BY price ASC LIMIT 1
556 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '251867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
557 0.0001 0.00011897087097168
UPDATE products SET price = '9085' WHERE id = '251867'
558 0.0002 0.0001990795135498
SELECT * FROM products WHERE id = '354233'
559 0.0003 0.00027918815612793
SELECT * FROM productimages WHERE product_id = '354233' ORDER BY sortorder ASC
560 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '354233'
561 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '354233'
562 0.0022 0.0022139549255371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '354233' AND a.name = n.originalname
563 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '354233' AND merchantid = 'ATVPDKIKX0DER'
564 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '354233' AND price > 0
                ORDER BY price ASC LIMIT 1
565 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '354233' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
566 0.0001 0.00012111663818359
UPDATE products SET price = '34200' WHERE id = '354233'
567 0.0002 0.00020718574523926
SELECT * FROM products WHERE id = '403127'
568 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '403127' ORDER BY sortorder ASC
569 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '403127'
570 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '403127'
571 0.0031 0.0031278133392334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403127' AND a.name = n.originalname
572 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '403127' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00018787384033203
SELECT * FROM productoffers
                WHERE product_id = '403127' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0002 0.00016117095947266
SELECT * FROM productoffers
                WHERE product_id = 403127
                ORDER BY price ASC LIMIT 1
575 0.0002 0.00020408630371094
SELECT value FROM productattributes
                WHERE product_id = '403127'
                AND name = 'ListPriceAmount'
576 0.0001 0.00011801719665527
UPDATE products SET price = '6736' WHERE id = '403127'
577 0.0002 0.00020003318786621
SELECT * FROM products WHERE id = '407044'
578 0.0002 0.00016379356384277
SELECT * FROM productimages WHERE product_id = '407044' ORDER BY sortorder ASC
579 0.0004 0.00040197372436523
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '407044' AND p.id = pi.product_id ORDER BY pi.sortorder
580 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '407044'
581 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407044'
582 0.0002 0.00023818016052246
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '407044'
                GROUP BY o.product_id
583 0.0003 0.00031614303588867
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '407044'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
584 0.0002 0.00021886825561523
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407044
585 0.0007 0.00071096420288086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407044' AND a.name = n.originalname
586 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '407044' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.00018000602722168
SELECT * FROM productoffers
                WHERE product_id = '407044' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0002 0.00016283988952637
SELECT * FROM productoffers
                WHERE product_id = 407044
                ORDER BY price ASC LIMIT 1
589 0.0003 0.00027108192443848
SELECT value FROM productattributes
                WHERE product_id = '407044'
                AND name = 'ListPriceAmount'
590 0.0002 0.00023484230041504
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '407044'
                GROUP BY o.product_id
591 0.0003 0.00031208992004395
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '407044'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
592 0.0002 0.00020909309387207
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407044
593 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '407044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
594 0.0006 0.00058698654174805
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '407044'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
595 0.0002 0.0002291202545166
SELECT * FROM products WHERE id = '403983'
596 0.0003 0.00029087066650391
SELECT * FROM productimages WHERE product_id = '403983' ORDER BY sortorder ASC
597 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '403983'
598 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '403983'
599 0.0033 0.0032920837402344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403983' AND a.name = n.originalname
600 0.0002 0.00022220611572266
SELECT * FROM productoffers WHERE product_id = '403983' AND merchantid = 'ATVPDKIKX0DER'
601 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '403983' AND price > 0
                ORDER BY price ASC LIMIT 1
602 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '403983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
603 0.0002 0.0001530647277832
UPDATE products SET price = '6651' WHERE id = '403983'
604 0.0002 0.00021791458129883
SELECT * FROM products WHERE id = '406869'
605 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '406869' ORDER BY sortorder ASC
606 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '406869'
607 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '406869'
608 0.0030 0.0030081272125244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406869' AND a.name = n.originalname
609 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '406869' AND merchantid = 'ATVPDKIKX0DER'
610 0.0002 0.00018906593322754
SELECT * FROM productoffers
                WHERE product_id = '406869' AND price > 0
                ORDER BY price ASC LIMIT 1
611 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 406869
                ORDER BY price ASC LIMIT 1
612 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '406869'
                AND name = 'ListPriceAmount'
613 0.0001 0.00014781951904297
UPDATE products SET price = '3771' WHERE id = '406869'
614 0.0002 0.0001981258392334
SELECT * FROM products WHERE id = '401579'
615 0.0005 0.00048708915710449
SELECT * FROM productimages WHERE product_id = '401579' ORDER BY sortorder ASC
616 0.0003 0.00025415420532227
SELECT * FROM product_image_select WHERE product_id = '401579'
617 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '401579'
618 0.0028 0.0027849674224854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '401579' AND a.name = n.originalname
619 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '401579' AND merchantid = 'ATVPDKIKX0DER'
620 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '401579' AND price > 0
                ORDER BY price ASC LIMIT 1
621 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '401579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
622 0.0001 0.00011897087097168
UPDATE products SET price = '15999' WHERE id = '401579'
623 0.0002 0.0001978874206543
SELECT * FROM products WHERE id = '406324'
624 0.0004 0.00039100646972656
SELECT * FROM productimages WHERE product_id = '406324' ORDER BY sortorder ASC
625 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '406324'
626 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406324'
627 0.0025 0.0024809837341309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406324' AND a.name = n.originalname
628 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '406324' AND merchantid = 'ATVPDKIKX0DER'
629 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '406324' AND price > 0
                ORDER BY price ASC LIMIT 1
630 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '406324' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
631 0.0002 0.00016283988952637
UPDATE products SET price = '4900' WHERE id = '406324'
632 0.0003 0.00025486946105957
SELECT * FROM products WHERE id = '407886'
633 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '407886' ORDER BY sortorder ASC
634 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '407886'
635 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '407886'
636 0.0031 0.0030632019042969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407886' AND a.name = n.originalname
637 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '407886' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '407886' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '407886' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.00013399124145508
UPDATE products SET price = '1999' WHERE id = '407886'
641 0.0002 0.00020694732666016
SELECT * FROM products WHERE id = '402100'
642 0.0001 0.00014996528625488
SELECT * FROM productimages WHERE product_id = '402100' ORDER BY sortorder ASC
643 0.0002 0.0002129077911377
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '402100' AND p.id = pi.product_id ORDER BY pi.sortorder
644 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '402100'
645 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '402100'
646 0.0002 0.00021100044250488
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '402100'
                GROUP BY o.product_id
647 0.0002 0.00023412704467773
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '402100'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
648 0.0002 0.00018405914306641
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 402100
649 0.0027 0.0027399063110352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402100' AND a.name = n.originalname
650 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '402100' AND merchantid = 'ATVPDKIKX0DER'
651 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '402100' AND price > 0
                ORDER BY price ASC LIMIT 1
652 0.0002 0.00016617774963379
SELECT * FROM productoffers
                WHERE product_id = 402100
                ORDER BY price ASC LIMIT 1
653 0.0003 0.0002739429473877
SELECT value FROM productattributes
                WHERE product_id = '402100'
                AND name = 'ListPriceAmount'
654 0.0002 0.0002138614654541
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '402100'
                GROUP BY o.product_id
655 0.0003 0.00025701522827148
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '402100'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
656 0.0002 0.00021195411682129
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 402100
657 0.0001 0.0001380443572998
UPDATE products SET price = '19999' WHERE id = '402100'
658 0.0002 0.00020503997802734
SELECT * FROM products WHERE parent_id = '402100'
659 0.0002 0.00019717216491699
SELECT * FROM products WHERE id = '407877'
660 0.0003 0.00033879280090332
SELECT * FROM productimages WHERE product_id = '407877' ORDER BY sortorder ASC
661 0.0003 0.00026679039001465
SELECT * FROM product_image_select WHERE product_id = '407877'
662 0.0001 0.00012779235839844
SELECT * FROM productcustomimages WHERE product_id = '407877'
663 0.0021 0.0021049976348877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407877' AND a.name = n.originalname
664 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407877' AND merchantid = 'ATVPDKIKX0DER'
665 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '407877' AND price > 0
                ORDER BY price ASC LIMIT 1
666 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '407877' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
667 0.0001 0.00012397766113281
UPDATE products SET price = '1699' WHERE id = '407877'
668 0.0003 0.00033903121948242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405638' ORDER BY timestamp DESC
669 0.0003 0.00026893615722656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '232837' ORDER BY timestamp DESC
670 0.0003 0.00026297569274902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '232842' ORDER BY timestamp DESC
671 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '360231' ORDER BY timestamp DESC
672 0.0003 0.00026082992553711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414375' ORDER BY timestamp DESC
673 0.0003 0.00026702880859375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405444' ORDER BY timestamp DESC
674 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '400671' ORDER BY timestamp DESC
675 0.0003 0.0002739429473877
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '251867' ORDER BY timestamp DESC
676 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '354233' ORDER BY timestamp DESC
677 0.0003 0.00025701522827148
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '403127' ORDER BY timestamp DESC
678 0.0003 0.00026798248291016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407044' ORDER BY timestamp DESC
679 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '403983' ORDER BY timestamp DESC
680 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406869' ORDER BY timestamp DESC
681 0.0003 0.00026082992553711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '401579' ORDER BY timestamp DESC
682 0.0003 0.00030684471130371
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406324' ORDER BY timestamp DESC
683 0.0003 0.00029516220092773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407886' ORDER BY timestamp DESC
684 0.0003 0.00029921531677246
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '402100' ORDER BY timestamp DESC
685 0.0003 0.0002899169921875
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407877' ORDER BY timestamp DESC
686 0.0002 0.00021100044250488
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 34
		AND c.prod_type = 'ebay'
		AND hide = 1
687 0.0002 0.00015592575073242
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
688 0.0001 0.00014090538024902
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
689 0.0001 0.0001380443572998
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
690 0.0001 0.00013899803161621
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
691 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
692 0.0001 0.00014686584472656
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
693 0.0002 0.00018310546875
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
694 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = 2
695 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = 4
696 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = 12
697 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = 10
698 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = 7
699 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = 18
700 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = 28
701 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = 13
702 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = 3
703 0.0584 0.058418989181519
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
704 0.0002 0.00023388862609863
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:1563783838;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"185812\";i:12;s:6:\"402983\";i:19;s:6:\"406758\";i:7;s:6:\"410588\";i:17;s:6:\"407831\";}}' WHERE id = '175'
705 0.0005 0.00048613548278809
SELECT * FROM products WHERE id IN (398315,185812,402983,406758,410588,407831) ORDER BY FIELD(id, 398315,185812,402983,406758,410588,407831 )
706 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
707 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '398315'
708 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '398315'
709 0.0030 0.0030300617218018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
710 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
711 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
712 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
713 0.0005 0.00047183036804199
UPDATE products SET price = '1999' WHERE id = '398315'
714 0.0006 0.00064611434936523
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
715 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '185812'
716 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '185812'
717 0.0023 0.0022690296173096
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
718 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
719 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
721 0.0017 0.0017139911651611
UPDATE products SET price = '314900' WHERE id = '185812'
722 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
723 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '402983'
724 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '402983'
725 0.0029 0.0028541088104248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
726 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
727 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
728 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
729 0.0046 0.0045790672302246
UPDATE products SET price = '10396' WHERE id = '402983'
730 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
731 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '406758'
732 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '406758'
733 0.0033 0.0032799243927002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
734 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
735 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
736 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
737 0.0010 0.00096893310546875
UPDATE products SET price = '2695' WHERE id = '406758'
738 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
739 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '410588'
740 0.0001 0.00014209747314453
SELECT * FROM productcustomimages WHERE product_id = '410588'
741 0.0024 0.002432107925415
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
742 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
743 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
744 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
745 0.0022 0.0022070407867432
UPDATE products SET price = '269999' WHERE id = '410588'
746 0.0002 0.00024580955505371
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
747 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '407831'
748 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '407831'
749 0.0040 0.0039870738983154
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
750 0.0002 0.00020480155944824
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
751 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
752 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
753 0.0002 0.0001518726348877
UPDATE products SET price = '1293' WHERE id = '407831'
754 0.0508 0.05076789855957
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
755 0.0003 0.0002591609954834
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:1563783838;s:8:\"products\";a:6:{i:2;s:6:\"398858\";i:7;s:6:\"410588\";i:11;s:6:\"408792\";i:13;s:6:\"370121\";i:16;s:6:\"414321\";i:17;s:6:\"407831\";}}' WHERE id = '177'
756 0.0005 0.00045895576477051
SELECT * FROM products WHERE id IN (398858,410588,408792,370121,414321,407831) ORDER BY FIELD(id, 398858,410588,408792,370121,414321,407831 )
757 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
758 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398858'
759 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '398858'
760 0.0048 0.0048201084136963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
761 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
762 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
763 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
764 0.0008 0.000823974609375
UPDATE products SET price = '2999' WHERE id = '398858'
765 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
766 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '410588'
767 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '410588'
768 0.0035 0.0034899711608887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
769 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
770 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
771 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0083 0.008342981338501
UPDATE products SET price = '269999' WHERE id = '410588'
773 0.0002 0.00023579597473145
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
774 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '408792'
775 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408792'
776 0.0049 0.0049400329589844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
777 0.0002 0.00020384788513184
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
778 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
779 0.0005 0.00050687789916992
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
780 0.0021 0.00205397605896
UPDATE products SET price = '13499' WHERE id = '408792'
781 0.0002 0.00023412704467773
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
782 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '370121'
783 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '370121'
784 0.0039 0.003917932510376
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
785 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
786 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
787 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
788 0.0001 0.00011992454528809
UPDATE products SET price = '12979' WHERE id = '370121'
789 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
790 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414321'
791 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414321'
792 0.0036 0.0035779476165771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
793 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
794 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
795 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
796 0.0020 0.0020430088043213
UPDATE products SET price = '9999' WHERE id = '414321'
797 0.0002 0.00022792816162109
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
798 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '407831'
799 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '407831'
800 0.0040 0.0039560794830322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
801 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
802 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
803 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
804 0.0015 0.0014510154724121
UPDATE products SET price = '1293' WHERE id = '407831'
805 0.1114 0.11142706871033
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
806 0.0003 0.00030112266540527
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:1563783838;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"407595\";i:4;s:6:\"415083\";i:9;s:6:\"410950\";i:11;s:6:\"408792\";i:13;s:6:\"370121\";}}' WHERE id = '181'
807 0.0007 0.00071501731872559
SELECT * FROM products WHERE id IN (398315,407595,415083,410950,408792,370121) ORDER BY FIELD(id, 398315,407595,415083,410950,408792,370121 )
808 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
809 0.0002 0.00023317337036133
SELECT * FROM product_image_select WHERE product_id = '398315'
810 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
811 0.0026 0.002575159072876
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
812 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
813 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
814 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
815 0.0001 0.00012397766113281
UPDATE products SET price = '1999' WHERE id = '398315'
816 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
817 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407595'
818 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407595'
819 0.0034 0.0034329891204834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
820 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
821 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
822 0.0004 0.0004267692565918
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
823 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
824 0.0002 0.00017285346984863
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
825 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '415083'
826 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '415083'
827 0.0035 0.0034689903259277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
828 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
829 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
830 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
831 0.0003 0.00025606155395508
UPDATE products SET price = '2299' WHERE id = '415083'
832 0.0003 0.00025415420532227
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
833 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '410950'
834 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410950'
835 0.0031 0.0031049251556396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
836 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
837 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
838 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
839 0.0001 0.00013208389282227
UPDATE products SET price = '241603' WHERE id = '410950'
840 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
841 0.0002 0.00020217895507812
SELECT * FROM product_image_select WHERE product_id = '408792'
842 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '408792'
843 0.0036 0.0035688877105713
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
844 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
845 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
846 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
847 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
848 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
849 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '370121'
850 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '370121'
851 0.0028 0.002816915512085
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
852 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
853 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
854 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
855 0.0001 0.00012302398681641
UPDATE products SET price = '12979' WHERE id = '370121'
856 0.1229 0.12287282943726
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
857 0.0004 0.00038981437683105
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:1563783838;s:8:\"products\";a:6:{i:3;s:6:\"407595\";i:4;s:6:\"415083\";i:6;s:6:\"185812\";i:11;s:6:\"408792\";i:13;s:6:\"370121\";i:14;s:6:\"403517\";}}' WHERE id = '183'
858 0.0008 0.00079989433288574
SELECT * FROM products WHERE id IN (407595,415083,185812,408792,370121,403517) ORDER BY FIELD(id, 407595,415083,185812,408792,370121,403517 )
859 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
860 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '407595'
861 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '407595'
862 0.0035 0.0035490989685059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
863 0.0006 0.00055980682373047
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
864 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
865 0.0008 0.00080299377441406
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
866 0.0002 0.00020790100097656
UPDATE products SET price = '2497' WHERE id = '407595'
867 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '415083' ORDER BY sortorder ASC
868 0.0003 0.00033402442932129
SELECT * FROM product_image_select WHERE product_id = '415083'
869 0.0002 0.00017714500427246
SELECT * FROM productcustomimages WHERE product_id = '415083'
870 0.0058 0.0058338642120361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415083' AND a.name = n.originalname
871 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '415083' AND merchantid = 'ATVPDKIKX0DER'
872 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = '415083' AND price > 0
                ORDER BY price ASC LIMIT 1
873 0.0008 0.00080084800720215
SELECT value FROM productattributes WHERE product_id = '415083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
874 0.0005 0.00048398971557617
UPDATE products SET price = '2299' WHERE id = '415083'
875 0.0013 0.0012619495391846
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
876 0.0004 0.00042986869812012
SELECT * FROM product_image_select WHERE product_id = '185812'
877 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '185812'
878 0.0036 0.0035557746887207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
879 0.0004 0.00041484832763672
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
880 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
881 0.0007 0.00067019462585449
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
882 0.0003 0.00026106834411621
UPDATE products SET price = '314900' WHERE id = '185812'
883 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
884 0.0004 0.00039219856262207
SELECT * FROM product_image_select WHERE product_id = '408792'
885 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '408792'
886 0.0059 0.0059459209442139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
887 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
888 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
889 0.0008 0.00081586837768555
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
890 0.0002 0.00024604797363281
UPDATE products SET price = '13499' WHERE id = '408792'
891 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
892 0.0004 0.00040888786315918
SELECT * FROM product_image_select WHERE product_id = '370121'
893 0.0002 0.00023388862609863
SELECT * FROM productcustomimages WHERE product_id = '370121'
894 0.0047 0.0046958923339844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
895 0.0004 0.00041389465332031
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
896 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
897 0.0007 0.00073885917663574
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
898 0.0002 0.00024795532226562
UPDATE products SET price = '12979' WHERE id = '370121'
899 0.0005 0.00049185752868652
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
900 0.0004 0.00039982795715332
SELECT * FROM product_image_select WHERE product_id = '403517'
901 0.0002 0.00022411346435547
SELECT * FROM productcustomimages WHERE product_id = '403517'
902 0.0049 0.0049128532409668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
903 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
904 0.0004 0.00040888786315918
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
905 0.0008 0.00076818466186523
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
906 0.0003 0.00025200843811035
UPDATE products SET price = '6699' WHERE id = '403517'
907 0.0008 0.000762939453125
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
908 0.0003 0.00025796890258789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
909 0.0002 0.00023102760314941
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
910 0.0002 0.00023889541625977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
911 0.0002 0.00022602081298828
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
912 0.0008 0.00078797340393066
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
913 0.0003 0.00025200843811035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
914 0.0002 0.00024604797363281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
915 0.0016 0.0015709400177002
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
916 0.0006 0.00056290626525879
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
917 0.0005 0.00053191184997559
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
918 0.0005 0.00050497055053711
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
919 0.0002 0.00020313262939453
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
920 0.0002 0.00015521049499512
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
921 0.0001 0.00014495849609375
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
922 0.0001 0.00014805793762207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
923 0.0001 0.00014591217041016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
924 0.0005 0.0004580020904541
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
925 0.0005 0.00046515464782715
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'