Tactical Equipment - Survivalist Equipment
   

Latest Trends In Tactical Knives And Tools :: Ontario RD 7 :: TOPS Prather War Bowie :: SOG Demo :: Hogue EX-F01 :: Chris Reeve Professional Soldier :: Spartan Blades Phobos :: Knives Of Alaska Xtreme Model V :: Ontario Ranger :: Reeve Umnumzaan

Best Knives Review

UPDATED :  

Every year, the tactical segment of the cutlery industry continues to impress with fresh designs and new technology, allowing the serious user to choose from a bumper crop of offerings from manufacturers home and abroad.

What started out as focus on combat knives 15 years ago has now broadened into a group of sub-categories under the "tactical" umbrella, which hone in on specific usage.

Law enforcement and military personnel have always been the focus of the tactical genre, but the everyday user has become a big beneficiary in the tactical blade market as well.


Knife Blade Steel Options :: Strongest Knife Blades

One of the key factors in determining the knife you'll choose is steel. What was once a simpler choice has now been made more difficult, as new manufacturers have jumped into the cutlery market with exotic blends of stainless steel, each aiming to be more efficient than the next. Crucible industries, whose latest offering is the S35VN, has dominated this category for the past few years, but other foreign manufacturers, such as domestic supplier Carpenter Steel and foreign giant Bohler-Uddeholm of Austria, have made impressive gains in the cutlery arena.

The modern steels have advantages in that they are tougher, hold an edge longer and are more corrosion-resistant than non-stainless carbon steels. With those benefits, however, come disadvantages. The very toughness of these newer steels requires they be sharpened using diamond hones - an ordinary sharpening stone will not work. For this reason, many serious users prefer carbon steel blades such as 1095 and D2 — as they both can be sharpened using traditional ineans, and can even be edged in the field using a rock in a pinch. It should also be noted that some of the more traditional stainless steels, such as 440, could be sharpened without a diamond sharpener.

Handle materials present a less imposing challenge for the user, simply because there are so many good ones. Micarta, a layered synthetic composite that has been around since the early 1900s, is still the most common handle on tactical knives, followed closely by G-10. Carbon fiber is still considered an exotic (read: expensive) handle material but all three are extremely durable. For the budget conscious, there are mold-injected Zytel and cord-wrapped options, while on the other end of the spectrum, titanium is an upscale option for folders. Organic materials such as wood, stag, and bone tend to fall by the wayside on tactical knives, but aren't out of the question.


The Fixed-Blade Icon :: Best Combat Knives

While folding knives have captured the majority of attention throughout the modern-day era of tactical knives, fixed-blades have always been at the heart of edged weapons armament.

The reason is elementary — they're more dependable. Folders have all kinds of things that can go wrong, the most alarming being the failure of the blade lock. They also tend to be smaller, which limits their ability to handle tough chores.

There will always be a need for large fixed-blade knives, if only for one reason. They can chop. When ever circumstances call for building a shelter and a knife is the carrying tool of choice, you'll need a blade of around 6" or more to effectively make things happen, and the thicker the blade steel, the better.


Fixed Blade Options :: Lessons From War

Ontario Knife Company RD7 Review & Prather War Bowie Review

Big knives are for big jobs, and shown here are two big ones: the Ontario RD 7 at the top and the TOPS Prather War Bowie knife at bottom.

TOPS Knives' Prather War Bowie, a collaboration with Warschool founder Jeff Prathcr, is a modern classic. At a hair over 12.5" in length, the knife's 7.25" trailing-point blade hints at Bowies knives of old. Its corrugated Rocky Mountain Tread handle, however, is modern beyond all doubt and the 1095 high carbon blade steel makes this knife easy to sharpen in the wilderness. Prather, a martial arts expert, likes a knife this size for combat as well — and who are we to argue?


OKC 8422 Spax for sale

Ontario Knife Company SPAX

Ontario Knife Company has an extensive line of survival and hunting knives and bladed tools, but the updated SPAX is one of the best general-purpose outdoor tools you can carry.

Two years ago I did a story about a hunter that fell between a melting ice shelf and the side of a mountain in Idaho, and he would have died had it not been for a small axe he carried on his belt.

In survival situations, you need multi-purpose tools that don't create a lot of bulk. The SPAX is versatile and efficient, and it comes with a belt sheath to keep it close to your side.

The 1095 carbon steel blade is powder coated, and the SPAX blade can serve to shop wood, cut rope, or hammer through ice.

In emergency situations, the SPAX will break through glass windows and can cut through sheet metal, and the orange handle is large and comfortable for a secure grip.

The blade also includes a wrench for fire hydrant and gas mains, so this is a favorite tool of rescue personnel as well. If you're in the outdoors, you need a SPAX.

The updated SPAX from the Ontario Knife Company is one of the best general-purpose outdoor tools you can carry.


  View The Prather War Bowie Fixed Blade Knife: View All Available Prather War Bowie Fixed Blade Knives


Ontario Knife Company's RD 7 Model is part of their Ready Detachment series designed by Jason Gingrich. The knife's versatile 7.5" clip-point blade of .25" steel take down small trees with ease and the high carbon blade steel makes it a breeze to re-edge in the field. If you like the RD 7 design, you'll be delighted to know alternate blade lengths are available ranging from 4.5" to 9.5".


  View Ontario Knife Products: View All Available Ontario Knives


SOG Demo Knife Review & Hogue EX F01 Knife Review

ABOVE : A fixed blade for all tastes. The SOG Demo (top) is an old design brought up to modern standards. The Hogue EX-F01 (bottom) is just outright modern.

Hogue Inc. (yep, the pistol grip people) launched a folder line last year with famed custom knife maker Allen Elishewitz as their collaborator. This year they've announced the EX-F01 fixed-blade series to the line-up. Available in blade lengths of 5.5" and 7.0", the EX-FG1 features Elishewitz's slick, well-grounded design and a choice of handle materials, including the company's patented black, green and tan G-Mascus. An Alien wrench slips into the handle from removing the scales, which are hollowed out for packing away small survival items like fish hooks and such.


  View All Hogue EX-F01 Fixed Blade Knife Models: Check price and knife reviews at Amazon


The SOG Demo is patterned after one of the rarest Special Forces knives ever made. The companywent to great pains to produce a modern yet faithful rendition of the original Scuba/Demo used in Viet Nam — and succeeded quite nicely. Just under 12" in overall length, the Demo has a 7.2" double-ground blade with a straight cutting edge on the front and 5" of serrations along the back. Built tough, the Demo has a stainless steely guard and pommel and these, along with the blade, are done up in a black Tini coating for low reflectance. The finger-grooved handle uses Kraton for comfort and is checkered for enhanced grip; with all this you get a genuine black leather sheath.


  View The SOG Demo Fixed Blade Knife: Check knife price here on our site


More Fixed-Blade Options :: The Future Combat Knife

Chris Reeve's Professional Soldier Review & Spartan Blades Phobos Knife Review

ABOVE : When stealth is of the essence, a skeletonized knife is easy to conceal. Chris Reeve's Professional Soldier (top) and Spartan Blades' Phobos knife get the job done.

If you need to add stealth into your equation, skeletonized knives are just the ticket. Skeletonized knives are not new but have been coming on strong recently. These knives can be used as is or cord-wrapped for a more comfortable grip that keeps an emergency length of paracord at hand. Spartan Blades' Phobos is a compact 6.5" knife with a wicked 2.75" Wharnecliff blade that can be worn as a neck knife or carried in a pocket stored in its Kydex sheath. Chris Reeve's Professional Soldier is a collaboration with noted custom knifemaker Bill Harsey. This knife is 7.5" overall with a 3.375" drop-point blade and a cleverly designed cutout in the handle can serve as a shackle wrench!


  View All Chris Reeve Professional Soldier Fixed Blade Knife models: Check prices on Chris Reeve Professional Soldier knife


  View All Spartan Phobos Fixed Blade Knife models: Check all Spartan Phobos Knife Prices


Cord wrapped knives Alaska Extreme model V review and Ontario Ranger Shiv knife review

ABOVE : Cord-wrapped knives offer that little bit extra when needed. At the top is the Knives of Alaska Xtreme Model V, at the bottom the Ontario Ranger Shiv.

If you want your knife cord-wrapped from the factory, you're in luck. Ontario's Ranger Shiv — one of many cord-wrapped knives in the company's line — has a 4.5" carbon steel blade that offers excellent protection in an easy-to-conceal package. Knives of Alaska offers the Xtreme Model V with a 5" partially-serrated blade of D2 steel, and there are other blade lengths available in this series. An added bonus for skeletonized and cord-wrapped knives is to be more affordable than knives with more handle materials.


  View All Knives Of Alaska Xtreme Model V Fixed Blade Knife models: Check Knives Of Alaska Xtreme Model V Price


  View All Ontario Ranger Shiv Fixed Blade Knife: Check Ontario Ranger Shiv knife price


A Force Of Folders :: Concealed Folding Blade Knives

By far. the most competitive battles fought in the tactical side of the cutlery market are over folding knives. It's here new design ideas are tested and innovative technologies surface. Don't look for this to change, as folders, which offer more opportunities (such as locking mechanisms), make for an ideal platform for pushing the industry farther.

In tactical circles, Chris Reeve is known as "Mr Quality", and has the industry awards to prove it. His Umnumzaan folder is a bulletproof work of art that is every bit as tough as it is good looking. At over 8" fulley extended with a 3.675" blade, the "Zaan" is a large folder designed to perform a myriad of functions from combat to field duty. The handle is made of thick titanium rails; Reeve's sturdy frame-lock blade securing mechanism, which is popularized, is one of the strongest in knifedom.


  View All Reeve Umnumzaan Folding Blade Knife models: Check Reeve Umnumzaan Folding Blade Knife Prices


Cutting-edge design is never more real than in Spyderco's Vallotton Sub-Hilt folder. The company had been wanting to do a collaboration with noted knifemaker Butch Vallotton for years and it was worth the wait.

This Italian-inspired tactical folder (8.675" overall with a sleek 3.75" drop-point blade) has all the look and feel of a custom-made knife and includes innovative features such as a thumb-stud stop lock. As manufactured knives go, it dosen't get much slicker than this!


  View All Spyderco Vallotton Sub Hilt Folding Blade models: Check Spyderco Vallotton Knife Prices


Reeve Umnumzaan Knife Review & Spyderco Valloton Sub Hilt Knife Review & CRKT Ikoma Sampa Knife Review

ABOVE : Variety abounds in the tactical folder marketplace. At top is the Reeve Umnumzaan Kinfe, the Spyderco Valloton Sub-Hilt knife in the middle, and the CRKT Ikoma Sampa knife at bottom.


After viewing the CRKT Ikoma Sampa you may want to accuse me of throwing a gents' folder in the mix. It's exquisitely machined handle looks upscale, but the Sampa is plenty large enough (7.25" overall with a 3.125" re-curved drop-point blade) to serve light field duties. Its innovative IKBS ball-bearing system allows the user to access the blade in a blink of an eye.

Designed by custom knifemaker Flavio Ikoma, the Sampa will not only perform as a worthy backup but will be the talk among your buddies. If the Sampa is a little too fancy for you, check out the company's Fire Spark model. It's mean looking in an all-black oxide blade finish with G10 handles, incorporates CRKT's OutBurst assisted-opening mechanism, and to puncture the attitude, has a "skull cracker" tip on the base of the handle.


  View All CRKT Ikoma Sampa Folding Blade Knives: Check price here on our site.


  View All CRKT Fire Spark Folding Blade Knives: Check knife price here on our site.


CRKT Fire Spark Knife Review & Boker Haddok Knife Review & Benchmade Mini Onslaught Knife Review

ABOVE : The wicked trio here shows the wide range of blade styles available in tactical folders. From top to bottom: CRKT's Fire Spark, Boker's Haddock, and Benchmade's Mini-Onslaught.

The Benchmade Mini-Onslaught, designed in conjunction with custom knifemaker Bob Lum (deceased), is a smaller version of it's big brother. The more manageable, easier to conceal Mini-Onslaught sports a modified clip-point blade of upscale 154 CPM blade steel that has the cool feel of an Iron Mistress bowie. The knife design is curvaceous yet stout, has a 3.75" clip-point blade and a nicely sculpted G10 handle. Users who liked the original but found it too big for the pocket will be delighted with the Mini-Onslaught.


  View The Benchmade Mini Onslaught Folding Blade Knife (BLACK BLADE): Check price here on our site.


  View The Benchmade Mini Onslaught Folding Blade Knife (SILVER BLADE): Check price here on our site.


Boker hit a home run when they added Denmark knifemaker Jens Anso to their design team. Anso is widely popular worldwide and is known for his sound-yet-unorthodox designs. The newly released Haddock is one of his most popular models and very typical of Anso's groove. This is a frame-lock folder with an upper scale of machined G10 and back liner of 3mm solid titanium. With an overall length of 7.65" and a 3.4" blade, the Haddock knife is a medium-size tactical that can perform a lot of tasks without taking up a lot of your pocket.


  View The Boker Haddock Folding Blade Knife: Check knife price here on our site.


Mantis Kunitza Knife Review

ABOVE :Bigger than it looks, the Mantis Kunitza is a feast of curves from tip to base. Note the concentric pattern machined into the handle. Not just for looks, it makes for great gripping.

Mantis Knives has always been an envelope-pusher. With enough curves to make a Corvette blush, the Mantis Kunitza has flair to spare. What's deceptive about the knife is it's size. At 9" fully opened - large by typical folder standards - the Kunitza has 3.5" of that in a swoopy, deeply ground spear point blade. The handle features a concentric machined patternand a blade flipper stands coiled, ready to strike when the blade is tucked in. A large, spacey-looking pivot and pocket clip complete the package for this aggressive cutter.


  View The Mantis Kunitza Folding Blade Knife: Check price and knife reviews at Amazon


Emergency Edges :: Survival Knives & Medic Knives

One of the fastest emerging segments among tacticals is in rescue knives. Most of these are folding knives so they can be easily stored, and unlike their oft-stealthy brethren are typically in bright handles. This makes sense, as most have blunt tips to keep from injuring victims and their brightly colored handles make them easy to spot in an emergency situation. Cutting webbing is a key duty for these knives.

CRKT M16 12ZER Knife Review & Benchmade Triage Knife Review & SOG Flash Rescue Knife Review

ABOVE : Emergency rescue folders are a breed all their own. Pictured here are the CRKT M16-12ZER (top), Benchmade Triage (middle), and SOG Flash Rescue (bottom).

The Benchmade Triage is an example of just how handy these knives can be in an emergency situation. Built around the manufacturer's sturdy AXIS-lock platform, the Triage features a 3.5" straight-cutting sheep foot blade (with ambidextrous thumb studs to facilitate lefties) and durable G10 handles. A foldout safety cutter — ideal for cutting webbing — folds out from the base and a carbide glass breaker is located on the base.


  View The Benchmade Triage Emergency Rescue Folding Knife: Check knife price here on our site.


The SOG Flash Rescue is a derivative of their Flash series folders, incorporating the company's S.A.T. (Sog Assisted Technology, a speed-assist blade-opening mechanism), which accesses the blade at the flick of the thumb. The 3.5" AUS 8 stainless steel blade has a webbing hungry row of serrations and the tip is blunt to decrease the chance of accidental harm to a victim. The Flash Rescue has a safety catch on the handle to prevent accidental engagement.


  View The SOG Flash Rescue Emergency Rescue Folding Knife (SILVER BLADE): Check price here on our site.


  View The SOG Flash Rescue Emergency Rescue Folding Knife (BLACK BLADE): Check price here on our site.


CRKT's M16-12ZER rescue folder is a modified version of their popular Kit Carson designed M16 folder which incorporates the company's patented AutoLawks safety system. The conversion includes emergency orange handles, a seat belt cutter milled into the blade flipper, and a tungsten carbide glass breaker incorporated into the base. The M16-12ZER has a 3.75" triple point tanto blade, partially serrated for making quick work of cutting webbing.


  View the CRKT M16-12ZER Emergency Rescue Folding Knife: Check price here on our site.


Field Muli-Tools For Hunters And Survivalist

A Combat Soldiers Tool Kit :: Essential Field Knife

CRKT Picatinny Multi Tool Crimson Trace Knife Review

ABOVE : Think of it as a multitool made just for firearms users. The CRKT Picatinny Multi-Tool was designed in conjunction with Crimson Trace to tackle a myriad of chores, from adjusting scopes to clearing jams.

Not necessarily an emergency knife, but one that could be crucial in a pinch, the CRKT Picatinny Multi-Tool — designed in conjunction with Crimson Trace for firearms users is a highly versatile tool for the attachment and adjustment of CTC sights designed for attachment to Picatinny rails. It is also useful for the breakdown and cleaning of automatic pistols and rifles.

This knife/multi-tool includes a hex wrench driver with a plethora of bits, foldout blade with scraper edge, and a foldout pin to help clear failure-to-eject jams and remove slide release pins. In addition, two CTC Allen tools are tucked into its molded grooves in the Zytel scales. The main blade is 2.8" in length with a locking liner to ensure a strong lock-up. Multi-tools are extremely handy out on the range or in the bush. With a Multi-tool in your pocket, help is never too far away!


  View All CRKT Picatinny Multi Tool - The Combat Swiss Army Knife For Firearms Users: Check price here on our site.


Multi-Plier 600 Needlenose/Fisherman Review

Gerber Multi Plier 600 Review

The toolbox that fits in the palm of your hand

If fishing is your idea of fun when the deer, pigs or goats are nowhere to be found, you'll be interested in Gerber's Fisherman multi-tool. It has all the great attributes, practicality and quality that make the MP600 series so sought-after, plus unique features designed specifically for those who enjoy fishing.

The functionality starts at the flick of the wrist - all that is needed to open the tool with one hand.

The extra-long plier jaws have large gripping teeth near the fulcrum. The extra-long needle nose construction with precision grip flat tip and small teeth is ideal for removing hooks quickly and cleanly as well as being ideal for the fine work needed in fabricating tackle.

The nickel-plated tungsten/cobalt carbide indexable cutter inserts make cutting tracer lines quick and easy, even in the most awkward situations. The cutter inserts also make preparing tackle simple, allowing clean cuts to even the hardest and heaviest tracer wire.

Three sizes of fishing line splicing band crimpers also assist quick and accurate tackle preparation. The Fisherman also includes a carbide fishhook sharpening groove in the double cut file tool. The Fiskars scissors make short work of braided or fused fishing line.

Two knives are included - a serrated sheepsfoot blade and a drop point blade. This ideal fishing companion is available for about $200.

Features at a glance

  • Serrated sheepsfoot blade
  • Bottle opener/medium screwdriver
  • Awl
  • Small screwdriver
  • Carbide fishhook sharpening groove
  • Carbide and double cut file
  • Drop point blade
  • #2 cross head screwdriver
  • Retractable lanyard
  • Fiskars scissors
  • Replaceable nickel plated tungsten/cobalt steel cutter inserts
  • Heavy-duty ballistic sheath

  View All Gerber Multi Plier 600 models: Check multi-plier price here on our site.


NEW LEATHERMAN TOOLS

New Leatherman pocket tools

New from Leatherman comes the OHT, the world’s first full size, 100% one-hand operable multi-tool. Packed inside the 11.5 cm frame are 16 tools that can all be deployed with just one hand, including spring action pliers, wire cutters, knife blade, strap cutter, oxygen tank wrench and cleaning rod attachment. Like all Leatherman tools, the OHT is made in the USA and covered by a 25 year warranty. Available in a black or coyote tan finish.


  View All LEATHERMAN TOOLS: View All Available Leatherman pocket tools


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2437770366669 604 0.5787 0


No Amazon API Requests Made.


App Debug - Total Time 1.2437770366669 seconds

Number Time From Start Name Description
1 0.41643095016479 Initialise Initialise FSB Function
2 0.42778992652893 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43951201438904 Start of getCategoryListByGroup Function Before first category groups query
4 0.4396800994873 After initial query Before first category groups query
5 0.43968105316162 Get Category List for Group Before the call to getCategoryList function
6 0.43968510627747 Start of GetCategoryList function Start of the function
7 0.43969106674194 Before getting categories Query to get specific category list
8 0.44030594825745 After getting categories Query to get specific category list
9 0.44030809402466 Before getting category custom Before call to function getCategoryCustom
10 0.44217610359192 After getting category custom After call to function getCategoryCustom
11 0.44217896461487 Before getting category custom Before call to function getCategoryCustom
12 0.4525580406189 After getting category custom After call to function getCategoryCustom
13 0.45256090164185 Before getting category custom Before call to function getCategoryCustom
14 0.45803689956665 After getting category custom After call to function getCategoryCustom
15 0.45803904533386 Before getting category custom Before call to function getCategoryCustom
16 0.46209096908569 After getting category custom After call to function getCategoryCustom
17 0.46209311485291 End of GetCategoryList function End of the function
18 0.46210193634033 Get Category List for Group Before the call to getCategoryList function
19 0.46210408210754 Start of GetCategoryList function Start of the function
20 0.46210694313049 Before getting categories Query to get specific category list
21 0.46249604225159 After getting categories Query to get specific category list
22 0.4624969959259 Before getting category custom Before call to function getCategoryCustom
23 0.46793293952942 After getting category custom After call to function getCategoryCustom
24 0.46793603897095 Before getting category custom Before call to function getCategoryCustom
25 0.4783980846405 After getting category custom After call to function getCategoryCustom
26 0.47839999198914 End of GetCategoryList function End of the function
27 0.47840690612793 Get Category List for Group Before the call to getCategoryList function
28 0.47841000556946 Start of GetCategoryList function Start of the function
29 0.47841191291809 Before getting categories Query to get specific category list
30 0.47918605804443 After getting categories Query to get specific category list
31 0.47918796539307 Before getting category custom Before call to function getCategoryCustom
32 0.48815608024597 After getting category custom After call to function getCategoryCustom
33 0.4881579875946 Before getting category custom Before call to function getCategoryCustom
34 0.50520801544189 After getting category custom After call to function getCategoryCustom
35 0.50520992279053 Before getting category custom Before call to function getCategoryCustom
36 0.51101398468018 After getting category custom After call to function getCategoryCustom
37 0.51101589202881 Before getting category custom Before call to function getCategoryCustom
38 0.51681208610535 After getting category custom After call to function getCategoryCustom
39 0.5168149471283 Before getting category custom Before call to function getCategoryCustom
40 0.52293300628662 After getting category custom After call to function getCategoryCustom
41 0.52293491363525 Before getting category custom Before call to function getCategoryCustom
42 0.54416298866272 After getting category custom After call to function getCategoryCustom
43 0.54416489601135 Before getting category custom Before call to function getCategoryCustom
44 0.54816389083862 After getting category custom After call to function getCategoryCustom
45 0.54816699028015 Before getting category custom Before call to function getCategoryCustom
46 0.55264496803284 After getting category custom After call to function getCategoryCustom
47 0.55264711380005 End of GetCategoryList function End of the function
48 0.55266189575195 Get Category List for Group Before the call to getCategoryList function
49 0.55266404151917 Start of GetCategoryList function Start of the function
50 0.55266690254211 Before getting categories Query to get specific category list
51 0.55308294296265 After getting categories Query to get specific category list
52 0.55308389663696 Before getting category custom Before call to function getCategoryCustom
53 0.55533289909363 After getting category custom After call to function getCategoryCustom
54 0.55533599853516 Before getting category custom Before call to function getCategoryCustom
55 0.55760598182678 After getting category custom After call to function getCategoryCustom
56 0.55760788917542 End of GetCategoryList function End of the function
57 0.55761408805847 Get Category List for Group Before the call to getCategoryList function
58 0.5576159954071 Start of GetCategoryList function Start of the function
59 0.55761909484863 Before getting categories Query to get specific category list
60 0.55792689323425 After getting categories Query to get specific category list
61 0.55792808532715 Before getting category custom Before call to function getCategoryCustom
62 0.56278491020203 After getting category custom After call to function getCategoryCustom
63 0.56278705596924 End of GetCategoryList function End of the function
64 0.56279301643372 End of getCategoryListByGroup Function Before return()
65 0.61414694786072 App Controller End End of the App controller (called before the controller of every page)
66 0.61602401733398 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.61616706848145 Before Get Options Before the call to getOptions in the tpl class
68 1.0251269340515 After Get Options After the call to getOptions in the tpl class
69 1.0252070426941 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2437589168549 Finalizing debug Before the debug is output to the page.
71 1.2437760829926 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5787 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0001671314239502
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044989585876465
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016188621520996
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014495849609375
SELECT * FROM `bad_bots`
5 0.0005 0.00046300888061523
SELECT parameter, value FROM parameters
6 0.0002 0.00015902519226074
SET time_zone = 'Europe/London'
7 0.0003 0.0003058910369873
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014400482177734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010919570922852
delete from cachefiles
10 0.0003 0.00027298927307129
SELECT id FROM pages WHERE pagename = 'latest-trends-in-tactical-knives-and-tools' LIMIT 1
11 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = 114
12 0.0008 0.00079107284545898
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0093531608581543
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00033283233642578
SELECT * FROM pages WHERE pagename = 'latest-trends-in-tactical-knives-and-tools'
15 0.0002 0.0001521110534668
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00053095817565918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00047802925109863
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.00023293495178223
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043511390686035
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0001 0.00014591217041016
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.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '1'
24 0.0029 0.0029339790344238
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.00025177001953125
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
30 0.0056 0.0056178569793701
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.00018095970153809
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.00015592575073242
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022521018981934
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022730827331543
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00015115737915039
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.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011351108551025
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.00024294853210449
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017609596252441
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.00015497207641602
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.00014901161193848
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00036501884460449
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0022 0.0022377967834473
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022599697113037
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.00014996528625488
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.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013089179992676
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.0047221183776855
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0047509670257568
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.00015783309936523
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00015091896057129
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00062203407287598
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0040 0.004011869430542
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
68 0.0040 0.0039970874786377
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.00015997886657715
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.00014710426330566
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
73 0.0080 0.0079860687255859
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.00027894973754883
SELECT id FROM categories WHERE parent_id = '65'
75 0.0081 0.0080580711364746
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.00016903877258301
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.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024189949035645
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '81'
82 0.0024 0.0024409294128418
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.00014686584472656
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.00014710426330566
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024230480194092
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.00025701522827148
SELECT id FROM categories WHERE parent_id = '31'
89 0.0024 0.0024380683898926
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.00015521049499512
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.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0021889209747314
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027701854705811
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.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 (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '10'
102 0.0092 0.0092489719390869
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.00020694732666016
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '130'
109 0.0099 0.0099070072174072
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.00017690658569336
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.00015592575073242
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015161037445068
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '32'
116 0.0015 0.0015439987182617
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014519691467285
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017638206481934
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.00024700164794922
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0017969608306885
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.00014805793762207
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.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00038909912109375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00065398216247559
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.00023508071899414
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00067496299743652
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.00014305114746094
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00067901611328125
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.00022792816162109
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00070500373840332
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.00014090538024902
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029492378234863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019760131835938
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.00023603439331055
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0019841194152832
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.00014710426330566
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.00014400482177734
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051560401916504
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036787986755371
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018191337585449
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '135'
162 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017976760864258
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00028204917907715
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014400482177734
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.0001530647277832
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '360'
228 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '362'
229 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001518726348877
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.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '397'
261 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001368522644043
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015997886657715
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.00015616416931152
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '438'
319 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001521110534668
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014090538024902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011920928955078
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0013 0.0013320446014404
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00034618377685547
SELECT * FROM pages WHERE pagename = 'latest-trends-in-tactical-knives-and-tools'
373 0.0002 0.00022697448730469
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = 2
375 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = 10
378 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 7
379 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 18
380 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
381 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 3
383 0.0426 0.042555093765259
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
384 0.0002 0.00024008750915527
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:1560834867;s:8:\"products\";a:6:{i:9;s:6:\"103845\";i:11;s:6:\"403517\";i:15;s:6:\"130885\";i:17;s:6:\"405644\";i:19;s:6:\"410949\";i:23;s:5:\"43519\";}}' WHERE id = '175'
385 0.0004 0.00044488906860352
SELECT * FROM products WHERE id IN (103845,403517,130885,405644,410949,43519) ORDER BY FIELD(id, 103845,403517,130885,405644,410949,43519 )
386 0.0002 0.00021719932556152
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
387 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '103845'
388 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '103845'
389 0.0024 0.00242018699646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
390 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00037479400634766
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012302398681641
UPDATE products SET price = '14499' WHERE id = '103845'
394 0.0003 0.0002601146697998
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
395 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '403517'
396 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '403517'
397 0.0029 0.0029439926147461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
398 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00011801719665527
UPDATE products SET price = '6699' WHERE id = '403517'
402 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
403 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '130885'
404 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '130885'
405 0.0019 0.0019419193267822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
406 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00011801719665527
UPDATE products SET price = '1521' WHERE id = '130885'
410 0.0002 0.00019216537475586
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
411 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '405644'
412 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '405644'
413 0.0034 0.0033800601959229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
414 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00011682510375977
UPDATE products SET price = '63539' WHERE id = '405644'
418 0.0002 0.00017309188842773
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
419 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '410949'
420 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
421 0.0027 0.0026631355285645
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
422 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00019979476928711
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00039982795715332
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
426 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
427 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '43519'
428 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '43519'
429 0.0027 0.0026609897613525
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
430 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00011897087097168
UPDATE products SET price = '1330' WHERE id = '43519'
434 0.0422 0.042184829711914
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
435 0.0002 0.0002129077911377
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:1560834867;s:8:\"products\";a:6:{i:6;s:6:\"412927\";i:8;s:6:\"408792\";i:14;s:6:\"406758\";i:17;s:6:\"405644\";i:3;s:6:\"290575\";i:9;s:6:\"103845\";}}' WHERE id = '177'
436 0.0004 0.0004429817199707
SELECT * FROM products WHERE id IN (412927,408792,406758,405644,290575,103845) ORDER BY FIELD(id, 412927,408792,406758,405644,290575,103845 )
437 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
438 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '412927'
439 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '412927'
440 0.0036 0.0036499500274658
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
441 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00012302398681641
UPDATE products SET price = '199900' WHERE id = '412927'
445 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
446 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408792'
447 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408792'
448 0.0036 0.0035781860351562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
449 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
453 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
454 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '406758'
455 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406758'
456 0.0026 0.0025749206542969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
457 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00039076805114746
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011992454528809
UPDATE products SET price = '2694' WHERE id = '406758'
461 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
462 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '405644'
463 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '405644'
464 0.0034 0.0033531188964844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
465 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
469 0.0006 0.00057792663574219
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
470 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '290575'
471 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '290575'
472 0.0034 0.0033779144287109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
473 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00012707710266113
UPDATE products SET price = '549500' WHERE id = '290575'
477 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
478 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '103845'
479 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '103845'
480 0.0024 0.0023760795593262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
481 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00012516975402832
UPDATE products SET price = '14499' WHERE id = '103845'
485 0.1025 0.10252094268799
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
486 0.0003 0.00027585029602051
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:1560834867;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:17;s:6:\"405644\";i:22;s:6:\"400044\";i:8;s:6:\"408792\";}}' WHERE id = '181'
487 0.0004 0.00044894218444824
SELECT * FROM products WHERE id IN (398315,130885,408078,405644,400044,408792) ORDER BY FIELD(id, 398315,130885,408078,405644,400044,408792 )
488 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
489 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '398315'
490 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '398315'
491 0.0025 0.0024809837341309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
492 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
496 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
497 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '130885'
498 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '130885'
499 0.0020 0.0019538402557373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
500 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00011801719665527
UPDATE products SET price = '1521' WHERE id = '130885'
504 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
505 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408078'
506 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408078'
507 0.0031 0.0030550956726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
508 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00012087821960449
UPDATE products SET price = '23352' WHERE id = '408078'
512 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
513 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '405644'
514 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '405644'
515 0.0033 0.0033400058746338
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
516 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00011682510375977
UPDATE products SET price = '63539' WHERE id = '405644'
520 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
521 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '400044'
522 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '400044'
523 0.0027 0.0027370452880859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
524 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00041580200195312
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00011801719665527
UPDATE products SET price = '16091' WHERE id = '400044'
528 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
529 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '408792'
530 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '408792'
531 0.0036 0.0035610198974609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
532 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011706352233887
UPDATE products SET price = '13499' WHERE id = '408792'
536 0.1024 0.10236310958862
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
537 0.0003 0.00025701522827148
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560834867;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:11;s:6:\"403517\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:17;s:6:\"405644\";i:19;s:6:\"410949\";}}' WHERE id = '183'
538 0.0004 0.00044703483581543
SELECT * FROM products WHERE id IN (414940,403517,130885,408078,405644,410949) ORDER BY FIELD(id, 414940,403517,130885,408078,405644,410949 )
539 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
540 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '414940'
541 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414940'
542 0.0033 0.0032711029052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
543 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012016296386719
UPDATE products SET price = '4490' WHERE id = '414940'
547 0.0003 0.00026679039001465
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
548 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '403517'
549 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '403517'
550 0.0030 0.0029549598693848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
551 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00040316581726074
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011801719665527
UPDATE products SET price = '6699' WHERE id = '403517'
555 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
556 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '130885'
557 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '130885'
558 0.0020 0.0020029544830322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
559 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00012111663818359
UPDATE products SET price = '1521' WHERE id = '130885'
563 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
564 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '408078'
565 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408078'
566 0.0031 0.0030570030212402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
567 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00012111663818359
UPDATE products SET price = '23352' WHERE id = '408078'
571 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
572 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '405644'
573 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '405644'
574 0.0034 0.0033628940582275
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
575 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
579 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
580 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410949'
581 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
582 0.0027 0.0026800632476807
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
583 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
587 0.0004 0.00040292739868164
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013089179992676
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00012516975402832
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00039291381835938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00013589859008789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00091695785522461
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00030207633972168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.0003659725189209
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.0001370906829834
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00032496452331543
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00033116340637207
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'