Tactical Equipment - Survivalist Equipment
   

Zylon Body Armor :: Bullet Proof Vest

Bullet Proof Vest

UPDATED:  

Professional Trainer Louis Awerbuck has been known to say that two things have saved more lives in law enforcement than anything else — bright flashlights and soft body armor. Recent reports about body armor may change that view by many. Veteran body armor manufacturer Second Chance has stopped production of particular models of its vests containing Zylon after bullet penetrations killed one officer and wounded another. The issues here involve life and death and require some historical and factual information to be fully understood.

THE HISTORY OF BULLET RESISTANT VESTS

Stephanie Kwolek and Herbert Blades, working for DuPont, discovered paraaramid (Kevlar) in 1965. Kevlar was the beginning of body armor as we know it today as it began enhancement of the stronger, lighter, and more flexible garments. Private industry and the United States government have striven to improve body armor since that time. According to the National Institute of Justice (NIJ) publication Selection and Application Guide to Police Body Armor, a law enforcement officer who does not wear a bullet resistant vest stands a four-teen times greater chance of sustaining a fatal injury than an officer who does wear a vest. Since the development of ballistic body armor, there have been an estimated 2500 saves.

Since man’s first combat, a variety of materials has been used to protect them from injury. This has ranged from shields to protective clothing. Animal skins, leather vestments, and suits of armor worked well for many hundred years considering the crude weapons used—until the advent of gunpowder. Man quickly learned the difference between what we now know as coverand concealment. Soft body armor is designed to stop most low and medium velocity handgun bullets. It is constructed of very strong fibers designed to absorb and disperse the energy of a bullet impact.

The National Law Enforcementand Corrections Technology Center Guide to Police Body Armor describes how bullet resistant vests work: "When a handgun bullet strikes body armor, it is caught in a web of very strong fibers. Long strands of fiber are interlaced to form a net."

"These fibers absorb and disperse the impact energy that is transmitted to the vest from the bullet, causing the bullet to deform or mushroom. Additional energy is absorbed by each successive layer of material in the vest until such time as the bullet has been stopped." Modern day vests have been used since the early 1900s. According to A History of Body Armor Bullet Proof Vests ,“The U.S. Patent and Trademark Office lists records dating back to 1919 for various designs of bullet resistant and body armor type of garments… it was not found to be feasible.” During the 1930s, the vests were steel plates sewn to fabric so they overlapped. Although they stopped many pistol bullets, mobility was greatly reduced. (Remember, we shoot and move!)

Gangsters learned what armies of the middle-ages learned and discarded the bulky, heavy body armor. Bulky vests (flak jackets) were designed and worn by the military throughout WWI and WWII. They were especially favored by bomber pilots and crews for protection from heavy flak. The National Institute of Law Enforcement and Criminal Justice, the predecessor to the National Institute of Justice(NIJ), began research into light weight armor that law enforcement and the military could comfortably wear. Nylon was the early favorite until the NIJ technology assessment recognized thepotential of Kevlar as vest material. It proved to be five times the tensile strength of steel by weight.

Kevlar is currently used in the ropes that secure airbags of the Mars pathfinder, light-weight ropes that help moor the largest U.S. Navy vessels, shrapnel-resisting shielding in jet aircraft engines, run-flattires, gloves that protect against cuts and more. The NIJ spent more than three million dollars from 1971 through 1976 on body armor development. About 1973, research at the Army’s Edgewood Arsenal had developed a seven-layer Kevlar garment for trials. They found that its bullet resistant properties diminished when exposed to UV light, when wet, dry cleaned, bleached or laundered. Design changes were made for water-proofing and light exposure to lessen the degradation. (Kevlar does degrade, thus the standard five year warranty cycle.)

Another phase investigated the effects blunt trauma, and the final phase involved the effectiveness and “wearability.” By 1975, field testing was conducted in fifteen major law enforcement agencies. The goal was to ensure a 95% probability of survival after a .38 caliber bullet strike at 800 feet-per-second. The testing concluded in 1976 with the realization that a vest could be worn for a full shift and be resistant to common handgun bullets. The body armor industry took off at a greater pace. Many law enforcement agencies developed policies on use of bodyarmor. These policies commonly required that all uniformed patrol officers will wear the department issued body armor at all times while in uniform. The vests were required to meet current standards of the NIJ. There are several methods of construction by the various companies.

A ballistic panel is made of many layers of ballistic fabric. It may also be made of composites and coatings and a variety of stitching. Each manufacturer chooses their ballistic materials and manufacturing process for their end product. How-ever, all must conform to the NIJ rules.As many as five new fibers were offered during the last several years. These were offered as a lighter, more flexible, more “wearable” vest. Kevlar was the main component until Allied Signal/Honeywell developed spectrafiber and Shield Technology composites including Gold Shield and Gold Flex. Twaron was the next offering.

It was introduced by Akzo Accordis Nobel. It, as the other fibers, uses the spun fibers to absorb the bullet’s energy. Twaron was one of the first to successfully reduce the overall weight of the vest, enhancing comfort and wearability. Zylon was the next offering. Zylon was introduced by Toyobo Company, Ltd. of Osaka, Japan in 1998. (It was invented by Dow Chemical as a high performance polymer called PBZ and sold to Toyobo.) It has a high tensile strength and provides ballistic protection at a low weight and improved comfort. Some say it is twice as strong as Kevlar. Toyobo sells the filament yarn(in varying thicknesses) and companies either weave the fiber into a fabric or make a composite by using layers of resin, according to Armor Holdings Company. Several body armor manufacturers made vests with Zylon: PointBlank, PACA, Safariland, AmericanBody Armor, and others. However, Second Chance had an eighteen month exclusive agreement with Toyobo for Zylon according to Second Chance Spokesman Gregg Smith.

WHERE THE PROBLEM SEEMS TO BEGIN

Zylon is where the problems seem to begin. The industry continued to work hard to make vests lighter and stronger for the comfort and safety of the customer. Something went awry.Toyobo reported to its customers in early 2001 that the Zylon fiber would lose some strength after exposure to high heat and high humidity. According to Technical Information (Revised 2001.9) Pro Fiber Zylon by Toyobo: “The strength of ZYLON decreases in the condition of high temperature and high humidity… The strength of Zylon gradually decreases even at the temperature of less than 100 degrees C in high humidity conditions.

Zylonfiber should be stored free from high humidity at normal room temperatures… The strength of ZYLON decreases with the exposure to sunlight… The residual strength of ZYLON after 6 months exposure today light is about 35%. ZYLON should be protected not only from ultraviolet light but also from visible light.” The final page notes: “The information in this brochure, to the best of our knowledge, is accurate and correct… Users determine for themselves the suitability for their intended use of the material… The materials are to be stored free from exposure to light.” Basically light, time, moisture, and heat (heat approximately five degrees over body temperature and 80% relative humidity level) degraded the ballistic protection of the vests below the five year warranty standard in the industry.

The temperatures and humidity levels are easily reachable by officers in normal wear.BSST, a German armor manufacturer recalled all of their Zylon-based vests and reported their findings in July of 2001 to their consumers: “BSST believes that test conditions can be reached during daily use of body armor, even for a limited period of time.” The BSST website offers a time line: July 18, 2001 DSM, the sole manufacturer of Zylon UD holds introduction of Zylon UD - July 19, 2001 recalls by BSST bodyarmor - July 20, 2001 “BSST decided to recall already delivered (Zylon) vests as a precaution.” - November 30, 2001 reports decreased performance of Zylon “is greater than expected. The latest results of the aging test with Zylon are causing great concern.” On May 16, 2003, US Armor goes on record that it would be irresponsible for them to produce any Zylon-based body armor.

They also say that “…our path was clear and there was no other decision to be made; we were not going to take the safety risks that appeared to be inherent with the use of Zylon. While our logic was not shared by the other major armor manufacturers, two ballistic weavers indicated their concern by requiring Zylon Liability Waivers from armor companies, something never done before.” (emphasis added.) “We’ve never used Zylon. Our vests are Kevlar, T-Flex and Gold Flex” commented HS Armor President John Holland. “Zylon seemed too good to be true when it came out, and we had heard rumors as to problems with UV light. It ended up being a water problem.” The military is the majority of the market for HS, but they do offer a covert line in Level II and IIIA certified to NIJ Standard 0101.04. They only offer covert vests with full side wraps. Sadly, the reports from Toyobo and its interpretation by BSST and US Armor were proven true on June 13, 2003 in Oceanside, California, when Officer Tony Zeppetella’s Second Chance Ultima II vest was penetrated two times by a 9mm.

An Associated Press article of December 23, 2003 stated “An autopsy report said one of these shots was likely fatal.” The article also said, “Second Chance contends Zeppettla’s Ultima II performed to federal standards. The fatal bullets struck about an inch from the vest’s edge.

For certification tests, bullets are fired no closer than three inches from the edge (emphasis added) so the destructive energy can dissipate, company (Second Chance) spokesman Gregg Smith said.” Ten days later, Officer Edward Limbacher was shot in the abdomen with a .40 caliber pistol in Forest Hills, PA. The bullet penetrated center mass of the vest and remains in the officer. Toyobo came out with additional reports in October, November, and December 2003. The October report told law enforcement officials that “it firmly stands behind Zylon and believes it is asuperior fiber for personal body armor manufacturers…” Toyobo explained that it is concerned by Second Chance Body Armor’s comments that the Zylon vestswere wearing out sooner than anticipated.

They note that Second Chance is alone in the decision to withdraw the Zylon vests from the market. (emphasis added) As to their 2001 report: “Tests we have conducted on Zylon fiber were intended to estimate the aging performance of the fiber itself, not to assess the actual ballistic performance of any individual manufacturer’s final product.” They encouraged the end manufacturer to conduct tests to determine the actual performance of their vests. Toyobo also notes it will offer NIJ its technical assistance intesting. The November report continued comments that Second Chance was the sole manufacturer to discontinue use of Zylon in vests. Further more, Toyobo encouraged NIJ to seek input of the various manufacturers to explain the difference of their composition and design of vests. They go on to point out that they reported the results of their testing of Zylon in July 2001 and August 2001 to the body armor manufacturers, specifically Second Chance.

Moreover, in that same letter, Toyobo specifically counseled Second Chance that it should "please share this information with your customers." Continued reports to the body armor industry concerning the degradation issue continued from Toyobo on a quarterly and semi-annual basis since January, 2002. In December, 2003 Toyobo corresponded again with its customers. "Zylon is Not a Defective Product." Toyobo believes that Second Chance has adesign issue, not a defective product issue.

WHAT HAS BEEN DONE BY THE INDUSTRY AND GOVERNMENT?

Second Chance discontinued the production of Zylon vests in September 2003 (well over two years after BSST discontinued and recalled its Zylon vests) and issued a “free upgrade for our Zylon-based Ultima and Ultimax concealable body armor. We’re doing this because our in-service testing has shown that previously worn Zylon vests wear out sooner than expected and indicates that there is a potential officer safety issue.” The free upgrade consisted of additional ballistic pads to be installed by the officer so the vest could “maintain its expected performance through-out the original warranty period.”

They also offered a matrix to determine the credit offered for the user to purchase a Monarch or Monarch Summit (Twaron) vest ranging from 0% for a 60 month old vest to 98.3% credit for a 1 month old vest. Second Chance’s Gregg Smith said that the replacement "Performance Packs" were made of Kevlar and added 1/10-inch to the front and back panel. Smith went on to say that the delivery time is thought to be approximately thirty days. (Reports from officers in the field seem to indicate the upgrade takes significantly longer.) Officers wearing the Performance Pack gave mixed reviews as to its comfort and the additional bulk. "When it (the Performance Pack) came packed in a large envelope I began to worry if it would do its job. I’m anxious to get my new (Twaron) vest. I’ve lost faith in Second Chance," said Cary Clanton, an officer with a police department in the Midwest.

Second Chance Body Armor

Many agencies were able to negotiate a different settlement from Second Chance involving the replacement of the vests with a Kevlar garment for no charge and the refusal of the Performance Pack. Second Chance’s Smith noted the no cost replacement had to do with contract agreements with those agencies. Pennsylvania State Police received nearly one million dollars inreplacement body armor in mid-Novem- ber, 2003. The vests were Monarch Summit (Aramid Kevlar) vests, replacing the Ultima and Ultimax (Zylon) vests. The State of Colorado and Los Angeles Police received a similar replacement. Second Chance has in excess of 920 saves with their vests since they started business in 1971 and at least 40 of those were Zylon vests according to Smith. He also believes that they have about 40% of the U.S. vest market. (Armor Holdings web site reports that Second Chance has 53% of the vests reimbursed by the Bulletproof Vest Partnership administered by the U.S. Department of Justice.)

When asked about the founder of Second Chance, Richard Davis, Smith said that Davis stepped down in June 2003 as Second Chance President and was back doing what he loves to do - invent. "He’s just an inventor and tinkerer. That’s what he has always done best." Davis designed the concealable bodyarmor after being shot delivering a pizza in Detroit in 1969. He was widely known for his demonstrations of shooting himself to show his confidence in the vests. Paul Banducci stepped up from Vice President to President. He had come from DuPont Corporation. Other manufacturers still make and offer their Zylon vests.

These companies include Safariland, Protective Apparel Corporation of America (PACA), Armor-shield, Gatorhawk, Reliance Armor, Point Blank and others. The Justice Technology Information Network reported on November 7, 2003 that they were beginning “to investigate the effects of naturally occurring environments on personal body armor andits component materials.” The NIJ would monitor and assist with the process. Specifically, they were to investigate the effects of temperature and moisture on Kevlar, Spectra, and Zylon. Reportedly the Phase 1 Testing is complete and the data is being analyzed. Second Chance’s Smith advised that the testing completed on Pennsylvania Officer Limbacher’s vest by NIJ, "…found also degradation in the used Zylon fiber according to their preliminary test results. And this is what we were finding."

We tested used vests for over two years and that was what was disturbing to us. Although the test results were inconsistent, we were finding degradation was accelerated from what the data that Toyobo at that time had given us. Now then they (Toyobo) later came back in October of 2003 and confirmed that, they disclosed to us for the first time as well as other bodyarmor manufacturers, that even undernormal shelf life conditions Zylon degrades. And they also revealed at that time even further degradation. Smith also said that Second Chance had collected in excess of 200 vests from 37 agencies from various climates for testing since fall of 2001. United States Attorney General John Ashcroft announced November 18, 2003, "…a Department of Justice initiative to address the reliability of body armorused by law enforcement personnel and to examine the future of bullet-resistant technology and testing."

The U.S. Attorney General ordered the NIJ to begin an immediate examination of Zylon-based vests, new and used (used for the first time in NIJ History), to test the performance upgrade packs offered by SecondChance, and to examine their own certification process. They are to report back within 90 days. He also ordered a "Summit" within 120 days with all levels of law enforcement, the vest industry (fabric and garments), and the peopleinvolved in testing of vests. In the pressrelease, Ashcroft said, Summit participants will review the information available from NIJ’s examination, including the suitability of Zylon-based bullet-resistant vests for law enforcement use and the effectiveness of NIJ’s certification process.

Summit participants also will consider the future of bullet-resistant technology and testing technology. Reportedly, the 2004 Federal Budget awaiting President Bush’s signature contains comments expressing concerns about the funding of NIJ and its vest testing program. The Bulletproof Vest Partnership Program offered by the Department of Justice (A grant available to law enforcement agencies reimbursing them for 50% of their body armor purchases) has adapted their application process to include additional emergency funding for replacement of the Zylon vests. The monies requested here are in addition to that requested for initial purchase of body armor.

WHAT HAS BEEN DONE BY THOSE WHO WEAR THE VESTS?

The Fraternal Order of Police (FOP), International Association of Chiefs of Police (IACP), various state FOPs and Sheriffs Associations have begun investigations into the Zylon issue. Numerous Attorneys General have begun investigations or filed suit against SecondChance, Toyobo, and other body armor manufacturers. These states include Idaho, Ohio, Massachusetts, Arkansas, Georgia, Illinois, Connecticut, and others. Many seek refunds of the hundreds of thousands of dollars spent to purchase vests to keep their officers alive.

The New York Times (December 26, 2003) quotes the Connecticut Attorney General commenting that Second Chance is playing "real-life Russian roulette" with the police wearing their Zylon vests. There is concern in Central Lake, Michigan, according to The Detroit News, thatSecond Chance "…could be hit with sig-nificant financial losses if pending cases go against it." Officials in western states are attempting to force changes in the design process through the pocketbooks of the armor companies. Michael Wallace is the State Procurement Officer of the State of Colorado. In his letter to the Executive Director of the IACP and the President of the Colorado FOP, Wallace stated, "No manufacturer or government agency has done conclusive tests to prove or disprove the possible degradation issues, nor have tests been done to prove that any vest produced today can expect to protect peace officers for the 5 year standard." Wallace noted that the NIJ only tests new, unused vests and officials want used vests to be tested. "Two manufacturers notified me by phone that they would not participate in the testing. The other manufacturers did not respond." He was requesting support for a solicitation that addressed the issues of environmental degradation of vests and testing of new and used vests. Signatories in this Colorado Armor Initiative so far include Utah, Arizona, Oklahoma, New Mexico, Alaska and Hawaii.

WHAT DOES ALL THIS MEAN?

It appears that the vest industry has been aware since early 2001 of serious question of the reliability of their Zylon-based vests. Second Chance did not discontinue the Zylon vests until September 2003 - three months after Tony Zeppetella was killed by two 9mm pistol bullets which penetrated his eight-month-old Second Chance Zylon vest and Edward Limbacher was seriously wounded by a .40 caliber bullet which penetrated the front panel of his seven-month-old Second Chance Ultima Level II-A (Zylon) vest. DOJ advised the public in November of 2003 that they were reviewing police body armor. Second Chance believes they have taken the lead in looking to resolve the issue, but it put them squarely in the middle of the controversy. Smith said, "…Second Chance does not want to seem Holier than Thou. Officer safety is the bottom line for Second Chance…. Our position is, we feel that the fundamental Zylon fiber is flawed. We were not told about it in time. We weren’t told until October of 2003 that there was even further degradation than what Toyobo had originally said, or that there was even shelf life degradation." They hadn’t revealed that at all.

When all this information came in, even prior to that because we went public with this in September because of our test results there was never any question that the Company was going to take the lead on this. And we are out there all alone. "We are a lightning rod for all these lawsuits." Second Chance blames Toyobo and claims that Second Chance is punished for pointing out the issues with Zylon. Toyobo claims that Second Chance and their method of manufacture is the problem. It seems companies in the soft bodyarmor market have taken great risks (and some continue to do so) with the lives of those on the street protecting them and their families. There is issue with the NIJ as well for their archaic methods of testing body armor. Ask alaw enforcement officer’s spouse about what he or she thinks of the risk the companies and NIJ are taking with their loved ones. Dr. Gary K. Roberts is well known and respected in the wound ballistics field. He is on staff of Stanford Medical Center, a reserve peace officer, and a Lt.Commander in the U.S. Navy Reserve. As one of the leading experts on wound ballistics, he offered the following comments to a northern California Sheriff Department at the conclusion of testing of various vests conducted in September 2003: "Avoid Zylon!"

Perhaps when Toyobo institutes improved manufacturing processing Zylon will become an outstanding armor material, but at this time, Zylon is NOT an acceptable vest material option. “Limit laminate materials, like Spectra, in soft body armor applications, as they do not provide as much protection against contact shots as woven p-aramids and they are subjectively less comfortable to wear. "Use vests made of proven woven p-aramid fibers like Kevlar and Twaron. These vests continue to provide adequate protection many years past their warranty period."  Each officer and agency must decide if they desire a thinner, more "wearable" vest or a slightly thicker vest that provides better protection against both non-ballistic, blunt trauma injuries that can occur inhand-to-hand confrontations, MVAs (motor vehicle accidents), and industrial accidents, as well as better protection against certain types of ammunition.

This is an individual choice that depends on expected threat types and wear environment. "My personal preference is thicker, level IIIa vests (with additional hard armorinserts, as needed) for uniformed Patroland Tactical environments and thinner, level II vests for discreet wear in other situations." Prudent advice.


Buy Cheap Bullet Proof Vest Online :: Body Armor Sale

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3135828971863 604 0.5843 0


No Amazon API Requests Made.


App Debug - Total Time 1.3135828971863 seconds

Number Time From Start Name Description
1 0.44022393226624 Initialise Initialise FSB Function
2 0.45132899284363 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4625837802887 Start of getCategoryListByGroup Function Before first category groups query
4 0.46275281906128 After initial query Before first category groups query
5 0.46275401115417 Get Category List for Group Before the call to getCategoryList function
6 0.46275782585144 Start of GetCategoryList function Start of the function
7 0.46276187896729 Before getting categories Query to get specific category list
8 0.46333885192871 After getting categories Query to get specific category list
9 0.46334099769592 Before getting category custom Before call to function getCategoryCustom
10 0.46518683433533 After getting category custom After call to function getCategoryCustom
11 0.46518898010254 Before getting category custom Before call to function getCategoryCustom
12 0.4757080078125 After getting category custom After call to function getCategoryCustom
13 0.47570991516113 Before getting category custom Before call to function getCategoryCustom
14 0.48121094703674 After getting category custom After call to function getCategoryCustom
15 0.48121380805969 Before getting category custom Before call to function getCategoryCustom
16 0.48530387878418 After getting category custom After call to function getCategoryCustom
17 0.48530578613281 End of GetCategoryList function End of the function
18 0.48531579971313 Get Category List for Group Before the call to getCategoryList function
19 0.48531794548035 Start of GetCategoryList function Start of the function
20 0.4853208065033 Before getting categories Query to get specific category list
21 0.48576092720032 After getting categories Query to get specific category list
22 0.48576188087463 Before getting category custom Before call to function getCategoryCustom
23 0.49124598503113 After getting category custom After call to function getCategoryCustom
24 0.49124884605408 Before getting category custom Before call to function getCategoryCustom
25 0.50179600715637 After getting category custom After call to function getCategoryCustom
26 0.50179886817932 End of GetCategoryList function End of the function
27 0.5018048286438 Get Category List for Group Before the call to getCategoryList function
28 0.50180792808533 Start of GetCategoryList function Start of the function
29 0.50181078910828 Before getting categories Query to get specific category list
30 0.50249886512756 After getting categories Query to get specific category list
31 0.50249981880188 Before getting category custom Before call to function getCategoryCustom
32 0.51157188415527 After getting category custom After call to function getCategoryCustom
33 0.51157379150391 Before getting category custom Before call to function getCategoryCustom
34 0.5288097858429 After getting category custom After call to function getCategoryCustom
35 0.52881288528442 Before getting category custom Before call to function getCategoryCustom
36 0.53468084335327 After getting category custom After call to function getCategoryCustom
37 0.5346839427948 Before getting category custom Before call to function getCategoryCustom
38 0.54057097434998 After getting category custom After call to function getCategoryCustom
39 0.54057383537292 Before getting category custom Before call to function getCategoryCustom
40 0.54672479629517 After getting category custom After call to function getCategoryCustom
41 0.54672694206238 Before getting category custom Before call to function getCategoryCustom
42 0.56848192214966 After getting category custom After call to function getCategoryCustom
43 0.56848478317261 Before getting category custom Before call to function getCategoryCustom
44 0.57251501083374 After getting category custom After call to function getCategoryCustom
45 0.57251691818237 Before getting category custom Before call to function getCategoryCustom
46 0.57706594467163 After getting category custom After call to function getCategoryCustom
47 0.57706785202026 End of GetCategoryList function End of the function
48 0.57708287239075 Get Category List for Group Before the call to getCategoryList function
49 0.57708597183228 Start of GetCategoryList function Start of the function
50 0.57708883285522 Before getting categories Query to get specific category list
51 0.57752084732056 After getting categories Query to get specific category list
52 0.57752180099487 Before getting category custom Before call to function getCategoryCustom
53 0.57977080345154 After getting category custom After call to function getCategoryCustom
54 0.57977390289307 Before getting category custom Before call to function getCategoryCustom
55 0.58206295967102 After getting category custom After call to function getCategoryCustom
56 0.58206486701965 End of GetCategoryList function End of the function
57 0.58207082748413 Get Category List for Group Before the call to getCategoryList function
58 0.58207297325134 Start of GetCategoryList function Start of the function
59 0.58207583427429 Before getting categories Query to get specific category list
60 0.5823769569397 After getting categories Query to get specific category list
61 0.58237791061401 Before getting category custom Before call to function getCategoryCustom
62 0.58727979660034 After getting category custom After call to function getCategoryCustom
63 0.58728194236755 End of GetCategoryList function End of the function
64 0.58728790283203 End of getCategoryListByGroup Function Before return()
65 0.63695096969604 App Controller End End of the App controller (called before the controller of every page)
66 0.6386559009552 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.63875389099121 Before Get Options Before the call to getOptions in the tpl class
68 1.0521199703217 After Get Options After the call to getOptions in the tpl class
69 1.0521709918976 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.3135659694672 Finalizing debug Before the debug is output to the page.
71 1.313581943512 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5843 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00048494338989258
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00013995170593262
SELECT * FROM `bad_bots`
5 0.0005 0.00046920776367188
SELECT parameter, value FROM parameters
6 0.0002 0.00017404556274414
SET time_zone = 'Europe/London'
7 0.0003 0.00031399726867676
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014805793762207
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011610984802246
delete from cachefiles
10 0.0003 0.00027203559875488
SELECT id FROM pages WHERE pagename = 'zylon-body-armor' LIMIT 1
11 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = 80
12 0.0008 0.00077700614929199
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0093741416931152
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00033688545227051
SELECT * FROM pages WHERE pagename = 'zylon-body-armor'
15 0.0002 0.0001530647277832
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00053906440734863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00047898292541504
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00044989585876465
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.00014495849609375
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029759407043457
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.00026082992553711
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057151317596436
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.00016999244689941
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022678375244141
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.00025320053100586
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023097991943359
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.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0001 0.00014495849609375
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.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011610984802246
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017728805541992
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.00015401840209961
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.00016593933105469
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.00041604042053223
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022718906402588
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022819042205811
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.0001518726348877
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.00014710426330566
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.004770040512085
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.00026512145996094
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048148632049561
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.00015711784362793
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.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00060296058654785
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040619373321533
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.00026082992553711
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040569305419922
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.00015401840209961
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.00014805793762207
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.00016117095947266
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0080819129943848
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.008152961730957
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.00017213821411133
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00015902519226074
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024478435516357
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
81 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024750232696533
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00015020370483398
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.00014281272888184
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024511814117432
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024662017822266
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.0001530647277832
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.00014710426330566
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.0001378059387207
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022070407867432
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.00025415420532227
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027921199798584
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0001 0.00014901161193848
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.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093801021575928
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.00028419494628906
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.01029109954834
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.00017809867858887
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.00015783309936523
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.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015299320220947
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
115 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.001568078994751
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.00014495849609375
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.00014400482177734
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017938613891602
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018129348754883
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.00014519691467285
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040698051452637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066304206848145
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.00023698806762695
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00067591667175293
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.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068998336791992
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.00023198127746582
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00072002410888672
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.00014281272888184
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.00014114379882812
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00028800964355469
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019910335540771
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.00024700164794922
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020129680633545
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.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.00014615058898926
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.0052249431610107
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.00019192695617676
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.00016403198242188
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '135'
162 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '454'
171 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015115737915039
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00027585029602051
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '360'
228 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '362'
229 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019621849060059
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017285346984863
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.0001528263092041
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001370906829834
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014090538024902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '438'
319 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001368522644043
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00024008750915527
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021886825561523
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '139'
324 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '398'
329 0.0001 0.00014996528625488
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '104'
333 0.0003 0.00025296211242676
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013749599456787
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00032210350036621
SELECT * FROM pages WHERE pagename = 'zylon-body-armor'
373 0.0002 0.00022602081298828
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 2
375 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 7
379 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 18
380 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 3
383 0.0430 0.042955875396729
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.00023889541625977
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:1560835988;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"412927\";i:16;s:6:\"408078\";i:15;s:6:\"130885\";i:4;s:6:\"171938\";i:5;s:6:\"404554\";}}' WHERE id = '175'
385 0.0005 0.00045299530029297
SELECT * FROM products WHERE id IN (398315,412927,408078,130885,171938,404554) ORDER BY FIELD(id, 398315,412927,408078,130885,171938,404554 )
386 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
387 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '398315'
388 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
389 0.0025 0.002518892288208
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
390 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00039815902709961
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012397766113281
UPDATE products SET price = '1999' WHERE id = '398315'
394 0.0003 0.0002591609954834
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
395 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
396 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
397 0.0036 0.0035698413848877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
398 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00012111663818359
UPDATE products SET price = '199900' WHERE id = '412927'
402 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
403 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '408078'
404 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '408078'
405 0.0031 0.0031068325042725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
406 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.00041723251342773
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00012302398681641
UPDATE products SET price = '23352' WHERE id = '408078'
410 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
411 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '130885'
412 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '130885'
413 0.0019 0.0019431114196777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
414 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00011706352233887
UPDATE products SET price = '1521' WHERE id = '130885'
418 0.0006 0.00062203407287598
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
419 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '171938'
420 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '171938'
421 0.0025 0.0025160312652588
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
422 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011897087097168
UPDATE products SET price = '389500' WHERE id = '171938'
426 0.0003 0.00027012825012207
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
427 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '404554'
428 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
429 0.0033 0.0032999515533447
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
430 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
434 0.0424 0.04243803024292
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.00021600723266602
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560835988;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:21;s:6:\"406901\";i:0;s:6:\"414940\";i:5;s:6:\"404554\";}}' WHERE id = '177'
436 0.0004 0.00042486190795898
SELECT * FROM products WHERE id IN (398315,408792,103845,406901,414940,404554) ORDER BY FIELD(id, 398315,408792,103845,406901,414940,404554 )
437 0.0002 0.0002131462097168
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
438 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '398315'
439 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
440 0.0025 0.0024819374084473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
441 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
445 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
446 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '408792'
447 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '408792'
448 0.0036 0.0035531520843506
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.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
453 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
454 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '103845'
455 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '103845'
456 0.0024 0.0024170875549316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
457 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
461 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
462 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406901'
463 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '406901'
464 0.0023 0.0023112297058105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
465 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0003 0.00034785270690918
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00012016296386719
UPDATE products SET price = '395' WHERE id = '406901'
469 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
470 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414940'
471 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '414940'
472 0.0033 0.0032508373260498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
473 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011801719665527
UPDATE products SET price = '4490' WHERE id = '414940'
477 0.0003 0.00027012825012207
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
478 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '404554'
479 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '404554'
480 0.0033 0.003303050994873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
481 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
485 0.1033 0.10332918167114
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.00027108192443848
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:1560835988;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:6;s:6:\"412927\";i:8;s:6:\"408792\";i:17;s:6:\"405644\";}}' WHERE id = '181'
487 0.0005 0.00046205520629883
SELECT * FROM products WHERE id IN (398315,290575,171938,412927,408792,405644) ORDER BY FIELD(id, 398315,290575,171938,412927,408792,405644 )
488 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
489 0.0002 0.00022792816162109
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.0025060176849365
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.00019717216491699
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
496 0.0006 0.00058603286743164
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
497 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '290575'
498 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '290575'
499 0.0033 0.0033121109008789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
500 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00011801719665527
UPDATE products SET price = '549500' WHERE id = '290575'
504 0.0006 0.00061988830566406
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
505 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '171938'
506 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
507 0.0025 0.0025029182434082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
508 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00011992454528809
UPDATE products SET price = '389500' WHERE id = '171938'
512 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
513 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '412927'
514 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '412927'
515 0.0036 0.0035650730133057
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
516 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00011801719665527
UPDATE products SET price = '199900' WHERE id = '412927'
520 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
521 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '408792'
522 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408792'
523 0.0036 0.0036191940307617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
524 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00043678283691406
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
528 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
529 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '405644'
530 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '405644'
531 0.0033 0.0033249855041504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
532 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
536 0.1030 0.10295915603638
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.00027608871459961
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:1560835989;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:5;s:6:\"404554\";i:6;s:6:\"412927\";i:12;s:6:\"414825\";i:19;s:6:\"410949\";i:23;s:5:\"43519\";}}' WHERE id = '183'
538 0.0005 0.0004570484161377
SELECT * FROM products WHERE id IN (398315,404554,412927,414825,410949,43519) ORDER BY FIELD(id, 398315,404554,412927,414825,410949,43519 )
539 0.0002 0.00024008750915527
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
540 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398315'
541 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '398315'
542 0.0025 0.0025169849395752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
543 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00038719177246094
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00013208389282227
UPDATE products SET price = '1999' WHERE id = '398315'
547 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
548 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '404554'
549 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '404554'
550 0.0033 0.0033190250396729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
551 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00012016296386719
UPDATE products SET price = '399999' WHERE id = '404554'
555 0.0003 0.00025510787963867
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
556 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '412927'
557 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
558 0.0037 0.0036551952362061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
559 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
563 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
564 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '414825'
565 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414825'
566 0.0020 0.0019998550415039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
567 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011992454528809
UPDATE products SET price = '11999' WHERE id = '414825'
571 0.0002 0.0001678466796875
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
572 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '410949'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
574 0.0027 0.0027058124542236
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
575 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011682510375977
UPDATE products SET price = '47995' WHERE id = '410949'
579 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
580 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '43519'
581 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '43519'
582 0.0026 0.0026450157165527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
583 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011897087097168
UPDATE products SET price = '1330' WHERE id = '43519'
587 0.0004 0.00040721893310547
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00040102005004883
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00012707710266113
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00092315673828125
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00031685829162598
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00028085708618164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.00035309791564941
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00012803077697754
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0004 0.00036287307739258
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00032901763916016
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'