Tactical Equipment - Survivalist Equipment
   

NightForce Compact 2.5-10X32 NXS Riflescope Review

Nightforce compact 2.5-10x32 NXS riflescope review

UPDATED :  

Nightforce riflescopes have carved out an enviable reputation for long range target/varmint and benchrest shooting, but their weight and bulk limited their usefulness for hunting. Now Nightforce is offering a pair of NXS Hunting Compacts with three new reticles tailored for low, medium and high velocity calibres.

NIGHTFORCE MANUFACTURES THEIR optical sights in Idaho, U.S.A to an uncompromising standard of quality and not to a price. Consequently they are quite expensive, but the Nightforce people make no apologies for this because their stated purpose is to build the best scopes possible for the precision rifleman. Since 1992, Nightforce's big high-range variables have been winning countless benchrest competitions and shown their superiority for long range target shooting.

Typical of what I call the "brilliant breed" Nightforce produced big, bulky 30mm scopes - 5.5-22x50, 3.5-15x50, 3.5-15x56 and 8-32x56 - and the giant super high-power 12-42x56. Serious varmint hunters with super-accurate, heavy-barreled rifles to whom weight and bulk were unimportant soon discovered the optical advantages of Nightforce - extremely high magnification coupled to resolution comparable to the highest-quality spotting scopes - and made good use of them. But there was nothing in the range light enough and compact enough to appeal to the hunter who stalked his game on foot - at least not until Nightforce designed a pair of compact NSX models originally designed for - and still in use by the U.S Special Operations community.

The Nightforce scope was tested on a big bore range at ranges from 300 to 600 yards. Reticle graduations were found to be precise and the clicks repeatable.

Nightforce successfully met the challenge of building a compact high-performance scope that was rugged enough to not only stand up to extreme climatic conditions and weather, but to withstand the repeated recoil of the most powerful magnum rifles. Tests include submersion in 100 ft. of water for 24 horus, freezing in a box cooled to minus 80 degreees F, then heating within an hour to 250 degrees F. Every scope is subjected to being hammered forth and back in a recoil machine that delivers 1,250 Gs, simulating the pounding of magnum rifles. After a scope takes numerous hits, it should be good for thousands of rounds. I know of no other brand of scope that undergoes such drastic testing for ruggedness!

The 1-4x24 NXS is a dangerous game scope. At 1x the field of view is 100 ft. at 100 yds., which makes it as quick to aim with as open sights because you can shoot with both eyes open - it's just like looking through a picture window.

At one time I thought highly of low-power variables (1-4x), but I'm less inclined to favour them now. The magnification range is small, and at 1x I can see a distracting length of barrel. Therefore, I am more inclined to favour the 2.5-10x32 which is just as light in weight and has a low enough profile to mount close to receiver and barrel.

NightForce NXS turrent view

ABOVE : Turrets are marked externally as well as internally for direction of impact. Eyepiece focusing uses a fine thread and a lock-ring.

The 2.5-10x32 spans 30cm in length but adds a significant 540 grams to your rifle. Like a good many other variables with a top power of 10x, the Nightforce NXS Compact makes no provision for parallax, and the third turret is actually a rheostat which serves to illuminate the reticle.

Lighted reticles are all the rage now, and they show up quickly in dim light. They'll also help you distinguish the reticle from a network of branches. The reticle has 9 different settings to increase or decrease the brightness. In dark conditions you dial on less illumination for the reticle to show up.

Brilliant sunshine floods out the glow of all but the highest setting. Keep the brightness low, and reduce it as light fades. A glowing reticle can dilate your eye,making the target harder to discern. The halo effect can also compromise precision. While Nightforce's illuminated reticles may appeal because they cover so little of the field. Big thick reticles work just as well for dim-light shooting as electronic reticles, often better.

The 30mm main tube is machined from solid bar stock 6061-T6 aircraft grade, durable lightweight bronze alloy finished in matte black. Being two or three times thicker than other riflescopes reduces overall stress and provides greater thermal stability, while providing maximum protection for the precision optics inside. But it also adds weight.

Dissimilar alloy in the erector tube assembly guarantees repeatable movement. Every lens is perfectly matched being aligned by hand with all other lens elements. This "optical indexing" yields the highest possible optical performance by focusing light rays more precisely for exceptional image clarity and true colour rendition. All air-to-glass surfaces are given Nightforce's proprietary broadband multi-coating applied to tolerances of 1.4 wave deposition or .000005 inches, which exceeds the toughest Mil-spec abrasion test.

Just like a fine Swiss watch, tolerances, materials, and optical design are as close to perfection as humanly possible. Naturally this kind of high-tech manufacture justifies the scope's high cost.

The 2.5-10x32 compact is available with two types of adjustments. The test scope had caps which when removed expose windage and elevation knobs easily adjusted with the fingers. Optional exposed tactical-type adjustments with ZeroStop and windage limiter adjustments feature an elevation dial that can be set to return reliably to any of 400 detents in its adjustment range. Or it can be returned to absolute zero by feel, regardless of how many elevation adjustments you have made.

Discount NightForce NXS rifle scope sale

ABOVE : The titanium jaws on the ultralite rings are clamped immovably by nuts rather than the usual small screws.

Like any progressive firm Nightforce is committed to eliminating the faults that occur in other scopes. One important improvement is the spring that maintains pressure on elevation and windage adjustments. When spring tension isn't strong enough the erector tube doesn't always move assertively if you are turning the screw out. That's why we sometimes have to tap turrets with a screwdriver handle after adjusting, and why some scopes don't register a change in point of impact.

Some scopemakers use two or three leaf return springs, but Nightforce eliminated this problem by using a pure titanium spring. This is the only metal in the world that can be repeatedly compressed and held in place, even for years without developing fatigue or memory, guaranteeing a consistent zero and precise repeatability. The titanium spring spends two weeks in a polishing tumbler before being installed In the scope to assure there are no rough spots or burrs that might interfere with perfectly smooth operation. The combination of tight fit and self lubricating crector tube guarantees that zero wont shift as you change magnification. Just .001 inch of slop in the guts of a scope can cause one-inch of bullet displacement at 100yds!

Furthermore, Nightforce machines the screw that controls elevation adjustments to an unheard of 110 threads per inch. It is precisely calibrated and mated to its receiver by hand resulting in backlash clearance of less than 1/30 the thickness of a human hair! All of these added refinements add to the cost of the scope, but Nightforce's major concern is with building the best riflescope.

Nightforce signature reticles are in the second plane and appear permanently centred in the field of view. The Compacts feature 4-times zoom and .25 MoA clicks. The turrets are marked for direction of impact change on the outside of the saddle as well as top of each turret.

The power change ring is heavily knurled and has a thumb rest. The reticle is brought into sharp focus by rotating the eyepiece which has a lock ring. One European feature I'd like to see adopted by Nightforce is a quick focus eyepiece which would make a good scope even better. The old American system has the eyepiece on very fine threads with a lock-ring to hold it in place after focusing. Older eyes would benefit from a little finer tuning, and it takes a fair bit of time and trouble screwing the eyepiece in and out on those super-fine threads.The Euro-system only rotates the rear lens, not the entire rear bell. The rear lens screws in and out on relatively coarse threads, and needs no lock-ring, focusing quickly and easily. This is an advantage, especially if you're over 40.

Test firing with the nightforce VXS scope

ABOVE : Long eye relief of 95mm makes the compact 2.5-10x32 N XS scope ideal for use on heavy kicking rifles.

The NXS Compacts are offered with new Velocity reticles that are claimed to be the answer for the hunter seeking an effective ballistic solution without complicated calculations.

Three variations inlcude - NP1 HV which takes in high velocity calibres from the 270 Winchester to the .300 Ultra Mag; the NP1 MV for medium velocity calibres from .243 to .308 with lighter bullets; and NP1 LV for low-velocity rounds from 7x57 to .338 Win. Mag. with heavy bullets. My test scope was equipped with the LV reticle despite my not owning a rifle in the low velocity category to test it with. In desperation I borrowed my esteemed editor's Marlin XL7 in .30-06 and fired it with 180gn bullet at 2700fps to conform with the specs for the LV reticle.

NightForce riflescopes reviewedRight side view of Nightforce's excellent ultralite scope rings which have titanium crossbolts and jaws.

The reticle has two thick side-bars with flat ends and a pointed picket at the bottom with elevation lines of varying widths in the centre. These lines are marked in 100yd. intervals from 100 to 600 yds. (as as well as 50yd. increments between 300 and 600 yds). Not only will it assist in estimating range and maintaining holdover, its hash-marked horizontal lines enable you to correct for 5 mph 90-degree winds. Windage compensation is marked in 5 and 10 mph increments.

I'm not keen on complex rangefinding reticles that clutter the field with lines, dots, bars, posts, circles and numbers. A reticle's primary function is to help you aim. All this flotsom and jetsom only impairs aiming. However, Nightforce helps you determine range accurately, so it may be excused for imposing a little clutter in your field.

The problem I faced with this reticle was that the horizontal aiming points are so fine that I had trouble distinguishing them in bright sunlight and they simply faded away in twilight, unless I illuminated them. I've already commented about this feature, but practical hunters don't care for the extra weight, bulk and expense of having an extra turret and batterycompartment. I'd like to see this scope made available without such gadgetry. With the complex, second plane reticle these values are valid only at 10x magnification. At any other magnification these values will undergo substantial change.

NXS scope holdover points Technical data for the 2.5-10x32 N XS and holdover points in the Nightforce reticle.

Reticles are etched on flat glass which is generally more durable and suffers less distortion than a wire reticle. It's also easier to illuminate. The problem is that it introduces another drain on light within the scope, which combined with the 32mm objective must affect image brightness. I compared the brightness of the Compact 2.5-10x32 against a 3-9x40 Zeiss Conquest and a 2.5-10x42 Sightron Big Sky from 20 minutes after sunset to full dark and found it slightly less bright compared with the larger objective scopes.

This scope is different; unusually, it has a 30mm tube and 32mm objective. Why, when it could have been made trimmer and lighter by using a one-inch tube. Don't think that one-inch scopes aren't as bright as 30mm scopes - they are.

The reason why 30mm European scopes have a reputation for brightness has nothing to do with their 30mm tube, but their excellent multi-coated lenses. If you doubt this, then compare a one-inch Zeiss or Swarovski with a 30mm scope of the same make. You won't be able to tell any difference, unless the objective lenses are larger creating larger exit pupils. A larger objective lens does make a scope brighter but normally only at magnifications above 6x - and not by all that much. And 30mm tubes are only an advantage on tactical scopes which must be adjustable to 1000 yds. That's why they have 30mm tubes and erector assemblies no bigger than those in standard one-inch tubes offering more latitude of adjustment.

 YardsMinutes of angle (MOA)
    HV MV LV
A 100 -1.16 -1.40 -1.80
B 200 0.00 0.00 0.00
C 300 1.92 2.25 2.71
D 350 2.98 3.50 4.25
E 400 4.16 4.92 5.90
F 450 5.41 6.40 7.77
G 500 6.70 8.00 9.71
H 550 8.07 9.75 11.85
I 600 9.57 11.56 14.00

The 2.5-10x32 NXS has a 3.2mm exit pupil on 10x whereas a 10x with a 42mm objective rates a 4.2mm exit pupil. But good glass and multi-coated lenses make more difference in scope brightness than a larger objective lens.

Thus the 2.5-10x32 is brighter than many cheaper scopes having 40 and 50mm objectives. The point I'm trying to make is that having the brightest optics takes second place to other positives in a hunting scope.

The laser rangefinder made accurate big-game shooting out to 500 metres possible. It also provided the kind of stimulus necessary for scopemakers like Nightforce to develop multipoint scope reticles. All the hunter has to do is measure the range with his rangefinder and then aim using the hash mark on the reticle that corresponds to the measured distance.

An oft-heard criticism to reticle range estimation is that game doesn't stand around to be measured. Well, if a deer is far enough away to need accurate range estimation, it usually isn't aware of the hunter. Going on tests I carried out on a full-bore range out to 600 yds., if you use a laser rangefinder to measure the exact range, and then aim using the correct horizontal hash mark, you'll stand a good chance of hitting game out to 600yds. And I think that's about twice as far as the average sportsman should be shooting at game.

The scope was attached to a Marlin XL7 in .30-06 using the firm's Ultralite rings. These are special being CNC machined from 7075-T6 alloy and held on with titanium beta series crossbolts and jaws. After the rifle was sighted in and zeroed at 200 yd.,I took it to the big bore range for testing out to 600 yd. The scope's adjustments were very tight but the clicks were distinct enough and more importantly shifted the point of impact the correct distance and returned to zero.

Engaging targets set up at 300,400, 500 and 600yd., using the LV reticle my handloads with 58gn of AR2209 driving the Sierra 180gn SPBT Gameking at a neat 2700fps, revealed that the LV reticle did in fact provide accurate aiming points out to 600yd; the margin ensured a bullet in the chest area of a deer at all ranges.

NightForce Compact 2.5-10x32 NXS Riflescope Specifications
Objective diameter 32mm
Exit pupil diameter 2.5 x 13.3/10x: 3.3mm
Eye relief 95mm/3.7"
Internal adjustment range e: 100 moa/w: 100moa
Click value .250 moa (1/4 moa)
Tube diameter 30mm/1.18"
Ocular lens diameter 33mm
Overall length 12"
Weight 19 oz
Mounting length 5.7"
Reticles available NP-1/NP-R2/FC-2/MIL DOT/Ballistic

This very clearly shows the necessity of matching the reticle in your Nightforce scope to the ammo - bullet weight and muzzle velocity. Laser rangefinders solve the problem of estimating distance, but even a gentle crosswind will drift your bullet off course, and then there's the basic reality that in most hunting situations you don't get a rock steady aim.

The only thing you can be sure of is that if you can't get out of taking a shot at 500 metres, or even beyond, there are rifles and scopes that are up to the task - if you are.

Without being too critical of what I found to be an excellent optical instrument, it's too heavy for mounting on a mountain rifle. Big country calls for powerful, but lightweight scopes. Extra weight means extra inertia when the rifle recoils, so that hard-kicking rifles are more apt to tear a heavy scope free of the rings or the bases free of their moorings. Maybe Nightforce relied too much on their benchrest heritage when designing a hunting scope. They could have made it lighter and offered more practical choices without the third turret, and offered it with Euro-focus, traditional reticle choices, a one- inch tube and 42mm objective. Having said that, while the Nightforce 2.5-10x NXS may outperform many larger scopes it's priced alongside such prestigious brands as Zeiss, Schmidt & Bender and Swarovski, who with their long tradition and reputation for making superior hunting scopes offer some tough competition.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3639800548553 610 0.5841 0


No Amazon API Requests Made.


App Debug - Total Time 1.3639800548553 seconds

Number Time From Start Name Description
1 0.53403902053833 Initialise Initialise FSB Function
2 0.54279398918152 App Controller Start Start of the App controller (called before the controller of every page)
3 0.55435800552368 Start of getCategoryListByGroup Function Before first category groups query
4 0.55452799797058 After initial query Before first category groups query
5 0.55452919006348 Get Category List for Group Before the call to getCategoryList function
6 0.55453205108643 Start of GetCategoryList function Start of the function
7 0.5545380115509 Before getting categories Query to get specific category list
8 0.55514907836914 After getting categories Query to get specific category list
9 0.55515003204346 Before getting category custom Before call to function getCategoryCustom
10 0.55701303482056 After getting category custom After call to function getCategoryCustom
11 0.55701613426208 Before getting category custom Before call to function getCategoryCustom
12 0.56749510765076 After getting category custom After call to function getCategoryCustom
13 0.56750798225403 Before getting category custom Before call to function getCategoryCustom
14 0.57298612594604 After getting category custom After call to function getCategoryCustom
15 0.57298803329468 Before getting category custom Before call to function getCategoryCustom
16 0.57706713676453 After getting category custom After call to function getCategoryCustom
17 0.57706999778748 End of GetCategoryList function End of the function
18 0.57707905769348 Get Category List for Group Before the call to getCategoryList function
19 0.57708096504211 Start of GetCategoryList function Start of the function
20 0.57708406448364 Before getting categories Query to get specific category list
21 0.57749509811401 After getting categories Query to get specific category list
22 0.57750701904297 Before getting category custom Before call to function getCategoryCustom
23 0.58295607566833 After getting category custom After call to function getCategoryCustom
24 0.58295798301697 Before getting category custom Before call to function getCategoryCustom
25 0.59348106384277 After getting category custom After call to function getCategoryCustom
26 0.59348297119141 End of GetCategoryList function End of the function
27 0.59349012374878 Get Category List for Group Before the call to getCategoryList function
28 0.59349203109741 Start of GetCategoryList function Start of the function
29 0.59349513053894 Before getting categories Query to get specific category list
30 0.59429311752319 After getting categories Query to get specific category list
31 0.59429407119751 Before getting category custom Before call to function getCategoryCustom
32 0.60339212417603 After getting category custom After call to function getCategoryCustom
33 0.60339403152466 Before getting category custom Before call to function getCategoryCustom
34 0.6204559803009 After getting category custom After call to function getCategoryCustom
35 0.62045907974243 Before getting category custom Before call to function getCategoryCustom
36 0.62630605697632 After getting category custom After call to function getCategoryCustom
37 0.62630915641785 Before getting category custom Before call to function getCategoryCustom
38 0.63215303421021 After getting category custom After call to function getCategoryCustom
39 0.63215613365173 Before getting category custom Before call to function getCategoryCustom
40 0.63831305503845 After getting category custom After call to function getCategoryCustom
41 0.63831496238708 Before getting category custom Before call to function getCategoryCustom
42 0.65993404388428 After getting category custom After call to function getCategoryCustom
43 0.65993809700012 Before getting category custom Before call to function getCategoryCustom
44 0.66396999359131 After getting category custom After call to function getCategoryCustom
45 0.66397309303284 Before getting category custom Before call to function getCategoryCustom
46 0.66852307319641 After getting category custom After call to function getCategoryCustom
47 0.66852498054504 End of GetCategoryList function End of the function
48 0.66853904724121 Get Category List for Group Before the call to getCategoryList function
49 0.66854214668274 Start of GetCategoryList function Start of the function
50 0.66854500770569 Before getting categories Query to get specific category list
51 0.66895818710327 After getting categories Query to get specific category list
52 0.66895914077759 Before getting category custom Before call to function getCategoryCustom
53 0.6712110042572 After getting category custom After call to function getCategoryCustom
54 0.67121410369873 Before getting category custom Before call to function getCategoryCustom
55 0.67350912094116 After getting category custom After call to function getCategoryCustom
56 0.67351102828979 End of GetCategoryList function End of the function
57 0.67351698875427 Get Category List for Group Before the call to getCategoryList function
58 0.67351913452148 Start of GetCategoryList function Start of the function
59 0.67352199554443 Before getting categories Query to get specific category list
60 0.67382717132568 After getting categories Query to get specific category list
61 0.673828125 Before getting category custom Before call to function getCategoryCustom
62 0.67871904373169 After getting category custom After call to function getCategoryCustom
63 0.67872214317322 End of GetCategoryList function End of the function
64 0.6787281036377 End of getCategoryListByGroup Function Before return()
65 0.73023509979248 App Controller End End of the App controller (called before the controller of every page)
66 0.73322916030884 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.73336315155029 Before Get Options Before the call to getOptions in the tpl class
68 1.1462960243225 After Get Options After the call to getOptions in the tpl class
69 1.1463761329651 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.3639621734619 Finalizing debug Before the debug is output to the page.
71 1.3639781475067 End of App This is the end of the app logging, final timestamp


Query Debug - 610 Database Queries. Total time 0.5841 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00043892860412598
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016617774963379
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014185905456543
SELECT * FROM `bad_bots`
5 0.0005 0.00046396255493164
SELECT parameter, value FROM parameters
6 0.0002 0.00015902519226074
SET time_zone = 'Europe/London'
7 0.0003 0.00031113624572754
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014495849609375
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010299682617188
delete from cachefiles
10 0.0003 0.00026392936706543
SELECT id FROM pages WHERE pagename = 'nightforce-compact-25-10x32-nxs-riflescope-review' LIMIT 1
11 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 265
12 0.0008 0.00079798698425293
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0092 0.0091819763183594
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00031781196594238
SELECT * FROM pages WHERE pagename = 'nightforce-compact-25-10x32-nxs-riflescope-review'
15 0.0002 0.00015401840209961
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051498413085938
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.0004880428314209
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043416023254395
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029599666595459
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 50
25 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057039260864258
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022599697113037
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 80
36 0.0003 0.00025820732116699
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022788047790527
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011398792266846
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0002 0.00024580955505371
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017731189727783
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00038719177246094
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022549629211426
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022621154785156
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0001 0.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 
55 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0047550201416016
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
59 0.0003 0.00026583671569824
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048060417175293
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00063204765319824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040698051452637
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 64
67 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.004058837890625
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
73 0.0080 0.0079848766326904
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 65
74 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '65'
75 0.0081 0.00807785987854
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024487972259521
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
81 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024731159210205
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024349689483643
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
88 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024571418762207
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022130012512207
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.00026416778564453
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027899742126465
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016021728515625
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093550682067871
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010165929794312
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015280246734619
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
115 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015580654144287
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014519691467285
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017988681793213
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0002 0.00024914741516113
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018210411071777
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00038790702819824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066900253295898
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.0006861686706543
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
137 0.0002 0.00023317337036133
SELECT id FROM categories WHERE parent_id = '90'
138 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 
139 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012016296386719
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029087066650391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019772052764893
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0019989013671875
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '20'
151 0.0050 0.0050208568572998
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037384033203125
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018811225891113
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015521049499512
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016617774963379
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00029802322387695
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014400482177734
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021791458129883
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001378059387207
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025081634521484
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021219253540039
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
324 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013549327850342
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00032401084899902
SELECT * FROM pages WHERE pagename = 'nightforce-compact-25-10x32-nxs-riflescope-review'
373 0.0002 0.00024795532226562
SELECT * FROM products WHERE id = '405824'
374 0.0002 0.00016498565673828
SELECT * FROM productimages WHERE product_id = '' ORDER BY sortorder ASC
375 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = ''
376 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = ''
377 0.0001 0.00010490417480469
SELECT pagename FROM products WHERE id = ''
378 0.0003 0.00025081634521484
SELECT value FROM productattributes WHERE product_id = '' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379 0.0002 0.00017094612121582
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
380 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = 2
381 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 4
382 0.0001 0.00013279914855957
SELECT * FROM pages WHERE id = 12
383 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 10
384 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 7
385 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = 18
386 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 28
387 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 13
388 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 3
389 0.0430 0.042991876602173
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
390 0.0002 0.00023698806762695
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:1560833822;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:5;s:6:\"404554\";i:15;s:6:\"130885\";i:17;s:6:\"405644\";i:3;s:6:\"290575\";}}' WHERE id = '175'
391 0.0004 0.00044798851013184
SELECT * FROM products WHERE id IN (414940,398315,404554,130885,405644,290575) ORDER BY FIELD(id, 414940,398315,404554,130885,405644,290575 )
392 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
393 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414940'
394 0.0001 0.00013422966003418
SELECT * FROM productcustomimages WHERE product_id = '414940'
395 0.0032 0.003248929977417
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
396 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0004 0.00043821334838867
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.00012302398681641
UPDATE products SET price = '4490' WHERE id = '414940'
400 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
401 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '398315'
402 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
403 0.0025 0.0024709701538086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
404 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00011897087097168
UPDATE products SET price = '1999' WHERE id = '398315'
408 0.0003 0.00027012825012207
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
409 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '404554'
410 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
411 0.0034 0.0033671855926514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
412 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
416 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
417 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '130885'
418 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '130885'
419 0.0020 0.0019688606262207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
420 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00011897087097168
UPDATE products SET price = '1521' WHERE id = '130885'
424 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
425 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '405644'
426 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '405644'
427 0.0034 0.0033590793609619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
428 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00043416023254395
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
432 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
433 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '290575'
434 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '290575'
435 0.0034 0.003385066986084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
436 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00013089179992676
UPDATE products SET price = '549500' WHERE id = '290575'
440 0.0428 0.042830944061279
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
441 0.0002 0.00021600723266602
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:1560833822;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:13;s:6:\"414188\";i:15;s:6:\"130885\";i:17;s:6:\"405644\";i:22;s:6:\"400044\";}}' WHERE id = '177'
442 0.0004 0.00042080879211426
SELECT * FROM products WHERE id IN (407595,171938,414188,130885,405644,400044) ORDER BY FIELD(id, 407595,171938,414188,130885,405644,400044 )
443 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
444 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '407595'
445 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407595'
446 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
447 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
448 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
449 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450 0.0001 0.00013184547424316
UPDATE products SET price = '2497' WHERE id = '407595'
451 0.0006 0.00061583518981934
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
452 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '171938'
453 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '171938'
454 0.0026 0.0025520324707031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
455 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
459 0.0003 0.00028014183044434
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
460 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '414188'
461 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
462 0.0026 0.0025720596313477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
463 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
464 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
465 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466 0.0001 0.00011706352233887
UPDATE products SET price = '9999' WHERE id = '414188'
467 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
468 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '130885'
469 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '130885'
470 0.0020 0.00199294090271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
471 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
472 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
473 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00011801719665527
UPDATE products SET price = '1521' WHERE id = '130885'
475 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
476 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '405644'
477 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '405644'
478 0.0034 0.0033879280090332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
479 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
480 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0001 0.00011682510375977
UPDATE products SET price = '63539' WHERE id = '405644'
483 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
484 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '400044'
485 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '400044'
486 0.0028 0.0028030872344971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
487 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00011801719665527
UPDATE products SET price = '16091' WHERE id = '400044'
491 0.1044 0.10442304611206
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
492 0.0003 0.00030303001403809
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:1560833822;s:8:\"products\";a:6:{i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";i:16;s:6:\"408078\";}}' WHERE id = '181'
493 0.0005 0.0004580020904541
SELECT * FROM products WHERE id IN (408792,103845,403517,414825,414188,408078) ORDER BY FIELD(id, 408792,103845,403517,414825,414188,408078 )
494 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
495 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '408792'
496 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '408792'
497 0.0037 0.0036580562591553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
498 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
499 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
500 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
501 0.0001 0.00012302398681641
UPDATE products SET price = '13499' WHERE id = '408792'
502 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
503 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '103845'
504 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '103845'
505 0.0024 0.0024139881134033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
506 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
507 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
508 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 0.00012016296386719
UPDATE products SET price = '14499' WHERE id = '103845'
510 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
511 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '403517'
512 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '403517'
513 0.0030 0.0029580593109131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
514 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
515 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
516 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0001 0.00011897087097168
UPDATE products SET price = '6699' WHERE id = '403517'
518 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
519 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '414825'
520 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414825'
521 0.0020 0.0020170211791992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
522 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
523 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
524 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
525 0.0001 0.00011920928955078
UPDATE products SET price = '11999' WHERE id = '414825'
526 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
527 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '414188'
528 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414188'
529 0.0025 0.0025498867034912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
530 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
531 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
532 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
533 0.0001 0.00011682510375977
UPDATE products SET price = '9999' WHERE id = '414188'
534 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
535 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '408078'
536 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '408078'
537 0.0031 0.0030579566955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
538 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
539 0.0002 0.00020122528076172
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
540 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
541 0.0001 0.00011992454528809
UPDATE products SET price = '23352' WHERE id = '408078'
542 0.1040 0.10400700569153
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
543 0.0003 0.00026082992553711
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:1560833822;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:9;s:6:\"103845\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:21;s:6:\"406901\";}}' WHERE id = '183'
544 0.0005 0.00045680999755859
SELECT * FROM products WHERE id IN (398315,290575,103845,130885,408078,406901) ORDER BY FIELD(id, 398315,290575,103845,130885,408078,406901 )
545 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
546 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '398315'
547 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '398315'
548 0.0025 0.0025198459625244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
549 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
550 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
551 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
552 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
553 0.0006 0.00058794021606445
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
554 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '290575'
555 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '290575'
556 0.0034 0.0034139156341553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
557 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
558 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
559 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
560 0.0001 0.00012016296386719
UPDATE products SET price = '549500' WHERE id = '290575'
561 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
562 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '103845'
563 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '103845'
564 0.0024 0.0024139881134033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
565 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
566 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
567 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0001 0.00011706352233887
UPDATE products SET price = '14499' WHERE id = '103845'
569 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
570 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '130885'
571 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '130885'
572 0.0020 0.0019869804382324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
573 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00012898445129395
UPDATE products SET price = '1521' WHERE id = '130885'
577 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
578 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '408078'
579 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '408078'
580 0.0031 0.0030820369720459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
581 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
582 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
583 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
584 0.0001 0.00011992454528809
UPDATE products SET price = '23352' WHERE id = '408078'
585 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
586 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '406901'
587 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406901'
588 0.0023 0.0023479461669922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
589 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
590 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
591 0.0003 0.0003359317779541
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
592 0.0001 0.00011897087097168
UPDATE products SET price = '395' WHERE id = '406901'
593 0.0004 0.00040888786315918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
594 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
595 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
596 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
597 0.0004 0.0003969669342041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
598 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0009 0.0009009838104248
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
601 0.0003 0.0003049373626709
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
602 0.0003 0.00027894973754883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
603 0.0004 0.00035595893859863
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
604 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
605 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
606 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
608 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
609 0.0003 0.00032615661621094
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
610 0.0003 0.00032591819763184
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'