Tactical Equipment - Survivalist Equipment

LED Tactical Flashlight :: Best Tactical Flashlight :: Gun Flashlights :: LED Torch

Best Tactical Flashlights

TACTICAL FLASHLIGHTS, SIGHTS & LASERS

UPDATED :  

FIELD TACTICS HI-TECH PROBLEM SOLVERS - LOOKING FOR LUMENS

Somehow the lumens get bigger and the lights get smaller. I used to think some of these flashlights were over kill until I tasked them with jobs suitable to their size. Especially after a class at Gunsite. I was taught the thing which defeats light is — light. Well then, give me the 2,200 lumen monster and let's see who can still see!

While ANSI FL-1 flashlight standards provide basic guidelines for comparing different lights, end user preference ultimately determines the light that meets that serviceman's needs. While basic information is provided here, more detailed research by the warfighter may be needed, and this often happens when he or she has the chance to physicaliy go to retailer to compare lights, much iike trying on a pack for fit.

The Gear Guide focuses mainly on light output and beam distance, where that information was available. Additional considerations must include the need for different colored lenses or LEDs, and possibly even more important- a steady supply of that light's type of battery on the battlefield.

Combat Flashlight For Soldiers

Be Prepared :: The Police Perspective

A little forethought, on what you're likely to run across on your beat and planning will make life on the streets a little more tolerable for you and your co-workers. You may be a "hero" to your partner when his flashlight batteries die or when a sudden headache develops in the middle of the shift. After all, as Reserve/Auxiliary Officers, isn't that our job — to "be there"?



Stocking the most popular brand LED flashlights for survivalist, preppers, outdoor activities and general home use. Not surprisingly, the humble torch or rather, flashlight has evolved over the years from it's original fuel powered format such as an oil lamp or candle, to the more modern battery powered filament bulb versions. And as we continue with technological advances, we have moved to the modern LED flashlight which offers more light at less power. Flashlights now also come purpose built for firearms, drone mounting and head mounted flashlights for hands-free use.

LED Flashlights :: Flashlight Sale :: Surefire :: Streamlight :: Ultrafire :: LED RV Camp Lighting

Surefire Flashlight - Cree R5 - Ultrafire C3 - Ultrafire - Maglight - Ultra Fire - Surefire - Streamlight

Ultrafire CR123, WF-138, WF-606A, WF-139, SSC P7, RL-2088, WF-1000L, WF-188, WF-500, 504B

LED Flashlights are affordable, and become essential on a regular basis. Ever had the power go out? How about the car braking down on the side of the road? Or simply drop something behind a piece of furniture at home? The discount flashlight has 101 uses and need not be an expensive addition to your daily kit of essential life tools!

A great selection of rechargable flashlights, solar powered and self charging (torches with their own generators) flashlights are available to be delivered direct to your door.


STAYING IN CHARGE

The approach to 12V auto electrics can often make or break a reliable touring set-up. Done the right way, you can be essentially self-sufficient for campsite power. Check out these beaut auto electrical set-ups.

  1. Setting up a 12V system in your RV requires a bit of prior planning long before you start running the wires. By using boxes to house the relays, fuses and distribution blocks you can ensure cargo won't damage your equipment.

  2. If you're looking to set your vehicle up with 12V lights, you'll need to determine the current they are likely to draw. LED and fluorescent units are both power-efficient options, which is the primary consideration when you're running them off a finite DC power supply.

  3. 12V set-ups should be fitted with a manual isolating switch, because you never know when you'll need to cut power in a hurry. Make sure the isolator is rated to take the maximum current capacity of the wiring.

  4. It's recommended electrical equipment like a 220V inverter be mounted up high that helps protect them should you get in over your depth while crossing a river. The size of an inverter is measured in watts (W), which translate to amperage (A) based on voltage (V). To determine the current draw, simply divide the watts by the voltage and you have your amperage.

12V accessories such as inverters and solar regulators should be mounted high with good ventilation. These units lose energy in the form of heat and need to stay cool to operate efficiently

The development of solar technology means you can now stay in the bush indefinitely. DC solar panels are becoming more affordable, which is good news for those of us who wish to recharge the batteries without running the engine.


Vendor Samples...


Surefire Flashlights

TORCHES or more commonly known as FLASHLIGHTS have come a long way in the past few years, with a number of ranges of tough and powerful light makers out there. An interesting range is the Streamlight Junior and Pocket Mate series made in the USA.

Machined from aircraft quality aluminium with an anodised finish, the Streamlights have an 'unbreakable' Lexan lens, high output bulbs and adjustable spot-to-flood focus to give you plenty of light when you need it.

Shock, dust and water resistant and powered by two AA batts, the Streamlight range is right up there with the best of them.

The manufacturers claim a 300 gain over regular flashlights.

Police Flashlight

Our SUREFIRE FLASHLIGHT range covers: SureFire Flashlights, SureFire Torches and SureFire Weapon Lights SureFire for Police, Military SureFire, Law Enforcement SureFire, Outdoor, Hunting and Camping SureFire Flashlights.

Looking for the Best Tactical LED Flashlights, Weapon Lights, pistol torches

Tactical torches, flashlights and weapon mounted gun lights from Olight, Klarus and Solarforce.


WOLF EYES X-BEAM BLUE Flashlights

Wolf Eyes X-Beam Blue Led Flashlight

Wolf Eyes has released a new torch, the blood tracking X-Beam Blue. This torch has two LEDs in it, one white and one 470Nm Blue. This is the exact wavelength Wolf Eyes supply to the Police for crime scene use, and when combined with orange goggles enables identification of biological matter such as blood.

If you have ever lost a wounded animal you know how useful this torch can be. It is also bright enough to shoot with, out to about 100 metres. Of course when you need bright white light it is there at the flick of a lever.


Leupold MX Flashlights

Leupold Flashlights

For decades Leupold has been a leader in the field of sports optics and light management. From this extensive experience came a desire to provide customers with the most advanced flashlights money can buy.

Years of design effort have culminated in the introduction of the Leupold MX Modular Flashlight Series.

This growing line of components allows you to custom build a flashlight to suit your individual illumination needs.


LIGHTFORCE 140 LED ENFORCER RED/WHITE VARIABLE SPOTLIGHT

Lightforce 140 led enforcer handheld cordless spotlight

The new Enforcer 140mm LED handheld introduces Fresnel technology to the sporting market. The specially designed lens produces a superior tight beam for maximum light output and performance.

In addition to the standard LED Enforcer, a new red / white switchable Enforcer is now available, which incorporates red and white diodes into single handheld light, allowing for maximum performance from a light.

The internal battery has a runtime of over 4 hours and you can even attach a clip on Enforcer battery to produce an extended runtime of up to 18.5 hours. It also has a lightweight ergonomic grip and an in-built battery indicator.

LightForce 140 LED Enforcer Specifications : white light: 376m / 411yd @ 1 LUX, lightweight for convenient long term use at only 450 grams, sealed from rain and dust, Fresnel technology for maximum light output and performance, Fresnel lens is combined with an in-built focusing mechanism that allows you to change from wide pattern to long distance spot.

The 140 Enforcer LED red / white comes with all the great features of the standard Enforcer while incorporating an easy to use switch that allows users to change from high to low intensity white, through to a strong red beam. It is compatible with the Lightforce Ni-MH Enforcer battery / charger which provides an extended runtime of up to 18.5 hours.


PISTOL TACTICAL FLASHLIGHTS

Streamlight TLR-1 for sale

The only necessity we see in a defensive handgun is a weapon-mounted light. Night sights may be fine for some folks, but they do nothing when it comes to identifying your target or determining threat assessment.

Brownells offers a variety of flashlights that can be mounted to a pistol via the framerail, and one of our favorites is the TLR-1 by Streamlight. There's a trick to getting this longer light on a short-railed compact pistol by inserting a second rail key toward the rear and using it to actually hold the light.

The TLR-1 gives you 300 lumens of pure white light. We like how the controls are placed on the light so the shooter can control the output between momentary or constant-on. There's a strobe setting, which some folks like, but we find it pretty useless without associated techno music and Patron shots.


RIFLE TACTICAL FLASHLIGHTS

Inforce WML white ir 200 for sale

When it comes to lights, again there are options. Consider that outfitting an AR with rails, optics, lights, and other accessories adds a considerable amount of weight to what was engineered originally as a 7-pound rifle. Most can get closer to 10 pounds if you start bolting parts on like you are building Legos.

Three pounds of extra weight does not sound like a lot, but you feel every ounce of it as you are moving and shooting, even if it's slung or attached to a plate carrier. So we think of reducing that fighting weight in terms of ounces.

That's why we like these lightweight lights by Inforce that we keep in stock. Their light weight (3 ounces) and low price makes them perfect for a home defense carbine.

We tried out two single-cell lights — a 200-lumen white LED and one with an infrared option. They weigh about 3 ounces each due to their fiberglass construction and the WML 200 boasts 200 lumens for 90 minutes of runtime. The LED/IR version gives you 175 lumens for 1.5 hours, 30 lumens for 10 hours, and provides an infrared light option with 75mW high (3.5 hours) and 25mW low (17 hours) modes.

Inforce WMLx for sale

If that lighting option sounds a bit mild, there's always the Inforce WMLx White, which produces 500 lumens of concentrated white light with a generous peripheral beam. It runs off two batteries as opposed to the single-cell lights. You may have problems identifying targets at greater distances than 100 yards due to the throw and beam, but in those instances there are other choices to be had.

SureFire M300 C Mini Scout for sale

In keeping with something light-weight, but boasting a greater beam throw, we like the SureFire M300 C Mini Scout Light. Weighing in at a scant 4.3 ounces, this versatile LED gives you 300 lumens for 1 hour and 20 minutes of runtime. Unlike the Inforce lights, SureFire allows you to equip their light with a tape switch to put the on/off capability right where you want it. No matter the lumens rating, you need controls to activate or deactivate the light when you need to do so.


SHOTGUN TACTICAL FLASHLIGHTS

Surefire Shotgun Flashlight for sale

If you rely on a shotgun for home defense, you'll want to add a light as well. Lights that clamp to the magazine tube went out with the hula hoop, and railed forends can be overkill when you just want a single flashlight and nothing else.

We're fans of SureFire's dedicated weapon lights for shotguns and we have them on hand for the big three: Remington, Mossberg, and Winchester. We've been running an older one on a Remington 1100 for close to 20 years, but wanted a newer version for our 870.

The latest SureFire unit features; a recoil-proof LED illuminator that delivers 600 lumens of clean, white light in high mode, and 200 lumens in low mode. The buttons are built into the forend as well to let you switch modes and choose between constant-on or momentary operation.

This light system is a completely sealed unit, and there are no tape switches or exposed wires.

Installation takes about five minutes. You remove your old forend via an included spanner wrench, slip on the new one, and tighten up the retaining nut with the same wrench.

If a dedicated weapon light sounds too expensive, the other option is to add a forend that accepts a rail mount, and any of the lights we looked at for rifles will make a fine fit.


Streamlight Super Siege Flashlights

Surefire super siege lantern for sale

Streamlight's Super Siege and the "mini-me" Siege AA lights are like brothers from another mother. The Super Siege is a powerhouse of 1,100 lumens and is rechargeable, also enabling you to charge other USB chargeables using its port. It has D rings on the top and bottom and a storage container for the charger!

The Siege AA is named after its power source and has three modes. The Siege will cast a glow 360 degrees and the white (4 LED option produces 200 lumens. There's also the blue LED model with less than one lumen - it runs for up to 12 days. Bonus, if you buy the Blue model, $2 of every purchase goes to the Concerns of Police Survivors (C.O.P.S.).


Pelican 3310 Emergency Lighting System

Pelican glowing in the dark safety flashlight

The 3310 Emergency Lighting System by Pelican may be the perfect emergency light. It provides 234 lumens for up to 190 hours! The mountable case keeps the ELS exactly where you need it in an emergency situation, and it glows in the dark. This light is perfect for home emergencies or in your disaster preparedness kit.


Elzetta Bravo B333 LED Flashlight

Elzetta Bravo 650 B333 Led Flashlight

The Bravo B333 by Elzetta is fully customizable and has fully encased circuit boards and soldered joints in a hardened epoxy to eliminate failures. There are numerous bezels, lenses and tail caps for over 144 configurations and up to 900 lumens. Elzetta lights a re proudly made in the USA and come with a lifetime guarantee.


SureFire PX2 Fury Flashlight Intellibeam Technology

Surefire Intellibeam PX2 Fury

The SureFire PX2 Fury with Intellibeam Technology has auto-adjusting technology and multiple settings. At 600 lumens it runs for 1.5 hours. The "auto adjusting" beam continuously changes the light output as needed, adjusting the intensity to the environment. This "smart" light does the thinking for you. Amazing.


Kinetic Concealment LC-01 Tactical Light

Kinetic Concealment LC-01 Light

The Kinetic Concealment LC-01 light and laser combo pairs both your love for lasers and a need for light. The 200-lumen light has three modes and can be run with or without the laser. The battery changes out easily with the push of a button. The LC-01 weighs in at 5.32 oz. and it's light on bulk, but heavy on features.


Tuff Writer Bolt Action Mini Flashlight

Tuff Writer Bolt Action Pen Flashlight

The newest edition to the Tuff Writer family of flashlights is the Bolt Action Mini. Housed in an aerospace-grade aluminum tube with a stainless steel clip and bolt, the smooth "bolt" action flashlight has three modes ranging from 100 lumens down to five. The Bolt Action Mini is just over 0.5" thick and just under 5" long. This handsome light is sleek enough to wear with your suit, yet durable enough to withstand punishment.


LIGHTFORCE PRED9X TACTICAL FLASHLIGHT

Lightforce PRED9X Hunting Spotlight For Sale

Designed for mid range hunting or hunting on foot, the Lightforce PRED9X offers a viewing range of more than 200 metres. The purpose built reflector and inbuilt shroud produce a tight beam. By using a CRT Bulb the PRED9X produces a beam that improves clarity and contrast, aiding vermin detection.

The lamp features a universal scope mount, a quick release cam mechanism, and a wireless RF switch that can be placed anywhere on the gun's stock. Its polymer construction and recoil resistant mean it's lightweight and resilient.

Price: $239.99.


VANGUARD HUNTING SET FLASHLIGHT

LED WAVE VANGUARD HUNTING SET FLASHLIGHT

Supplied in a compact plastic carry case, the Vanguard Hunting set is small enough to stash in a kitbag and fast to set up. Its basic mount has a large locking wheel for fuss-free deployment, and gives plenty of clearance over turrets and objective lens.

Being relatively light, this robust little lamp has little effect on the balance of the gun, and its 220-lumen LED throws light out to over 150 metres with a bright central spot.

The kit includes a remote switch that attaches to the stock with Velcro to allow you to power up with either constant or momentary illumination. The Vanguard comes with green and red filtersto mute the beam for close-range work.

Price: $124.99.


WHITE EYE WE1-GL TACTICAL FLASHLIGHT

White Eye WE1 GL Flashlight

A 250-lumen gun light with a choice of high or low beam, yielding two or ten hours of battery life respectively. The White Eye comes with a removable lamp, li-on battery, charger, remote switch and pressure switch and gun mount.

It's designed to accept a variety of different LED lamps, which can be ordered separately to create a versatile product that can be easily converted for different uses. These options include red, green, infrared and 1000 lumen lights.

Price: $96.


NIGHT MASTER VENOM STRIKE FLASHLIGHT

Venom flashlight body parts

This versatile torch is an infrared illuminator and much, much more. Additional interchangeable LED units give you the option of white, red and green light, as well as the all-important infrared to maximise the potential of your NV device.

Waterproof and encased in an aircraft-grade aluminium tube, the Venom Strike has a runtime of up to four hours, and attaches to your telescopic sight by means of a simple mount that has a single locking knob for fast deployment.

Price: From $124.95


TRACER F SERIES FLASHLIGHTS

Tracer F Series LED Tactical Flashlights LEDRAY

Tracer has launched of three new ranges of LED focusable gun lights, the F400, F600 and F900. The F400 is available in a white, green or red LED offering a 300, 250 & 150m beam respectively. The F600 can be switched between four LED colours; white, red, green and blue, all in one torch, with a beam up to 200m.

The F900 lights have been developed to provide long-range beams for solo hunting up to 800m and have interchangeable white, red, green and IR LEDs. Other optional extras include a 66mm lens head with snoot.

Price: F400 $89.99, F600 $129.99, F900 $149.99.


Coast HP17 Light

Coast HP17 Tactical Light For Sale

The Coast HP17 offers huge power from a manageable size. At 30 ounces it'stoo heavy for everyday carry (EDC),so store it at work and in the house.

The slide-focus on the beam easily transitions from a 2,000- foot reaching spotlight to a 7-foot-wide broad flood light. Also, it'ssimple to manage power consumption by click-cycling through three output settings.

Our only qualm is that depending on how it's held in your hand the power button can be tricky to engage, especially with gloved hands.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5777370929718 924 0.7720 0


No Amazon API Requests Made.


App Debug - Total Time 1.5777370929718 seconds

Number Time From Start Name Description
1 0.3902280330658 Initialise Initialise FSB Function
2 0.39282703399658 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4548180103302 App Controller End End of the App controller (called before the controller of every page)
4 0.45497298240662 Category Start Start of the category controller
5 0.45497608184814 Before Get Category Before getting the category information
6 0.46383094787598 After Get Category After getting the category information
7 0.46383309364319 Before Get Category List Before getting the updated category list
8 0.46396899223328 Start of getCategoryListByGroup Function Before first category groups query
9 0.46412706375122 After initial query Before first category groups query
10 0.46412897109985 Get Category List for Group Before the call to getCategoryList function
11 0.46413207054138 Start of GetCategoryList function Start of the function
12 0.46413612365723 Before getting categories Query to get specific category list
13 0.46465992927551 After getting categories Query to get specific category list
14 0.46466207504272 Before getting category custom Before call to function getCategoryCustom
15 0.46642804145813 After getting category custom After call to function getCategoryCustom
16 0.46643090248108 Before getting category custom Before call to function getCategoryCustom
17 0.47720098495483 After getting category custom After call to function getCategoryCustom
18 0.477205991745 Before getting category custom Before call to function getCategoryCustom
19 0.48285508155823 After getting category custom After call to function getCategoryCustom
20 0.48285889625549 Before getting category custom Before call to function getCategoryCustom
21 0.48702311515808 After getting category custom After call to function getCategoryCustom
22 0.48702597618103 Before getting sub category list Before call to recursive function getCategoryList
23 0.48702812194824 Start of GetCategoryList function Start of the function
24 0.48703098297119 Before getting categories Query to get specific category list
25 0.48736906051636 After getting categories Query to get specific category list
26 0.48737096786499 Before getting category custom Before call to function getCategoryCustom
27 0.48985409736633 After getting category custom After call to function getCategoryCustom
28 0.48985505104065 Before getting sub category list Before call to recursive function getCategoryList
29 0.48985695838928 Start of GetCategoryList function Start of the function
30 0.48985910415649 Before getting categories Query to get specific category list
31 0.49014711380005 After getting sub category list After call to recursive function getCategoryList
32 0.49014806747437 End of GetCategoryList function End of the function
33 0.49015498161316 After getting sub category list After call to recursive function getCategoryList
34 0.49015593528748 End of GetCategoryList function End of the function
35 0.49016690254211 Get Category List for Group Before the call to getCategoryList function
36 0.49016904830933 Start of GetCategoryList function Start of the function
37 0.49017310142517 Before getting categories Query to get specific category list
38 0.49055004119873 After getting categories Query to get specific category list
39 0.49055099487305 Before getting category custom Before call to function getCategoryCustom
40 0.49626398086548 After getting category custom After call to function getCategoryCustom
41 0.49626803398132 Before getting category custom Before call to function getCategoryCustom
42 0.50720191001892 After getting category custom After call to function getCategoryCustom
43 0.50720596313477 End of GetCategoryList function End of the function
44 0.5072169303894 Get Category List for Group Before the call to getCategoryList function
45 0.50722002983093 Start of GetCategoryList function Start of the function
46 0.50722408294678 Before getting categories Query to get specific category list
47 0.5079231262207 After getting categories Query to get specific category list
48 0.50792503356934 Before getting category custom Before call to function getCategoryCustom
49 0.51734399795532 After getting category custom After call to function getCategoryCustom
50 0.51734805107117 Before getting category custom Before call to function getCategoryCustom
51 0.53531098365784 After getting category custom After call to function getCategoryCustom
52 0.53531503677368 Before getting category custom Before call to function getCategoryCustom
53 0.54137206077576 After getting category custom After call to function getCategoryCustom
54 0.54137492179871 Before getting category custom Before call to function getCategoryCustom
55 0.54740810394287 After getting category custom After call to function getCategoryCustom
56 0.54741191864014 Before getting category custom Before call to function getCategoryCustom
57 0.55377292633057 After getting category custom After call to function getCategoryCustom
58 0.55377697944641 Before getting category custom Before call to function getCategoryCustom
59 0.57644701004028 After getting category custom After call to function getCategoryCustom
60 0.57645106315613 Before getting category custom Before call to function getCategoryCustom
61 0.58058309555054 After getting category custom After call to function getCategoryCustom
62 0.58058500289917 Before getting category custom Before call to function getCategoryCustom
63 0.58520102500916 After getting category custom After call to function getCategoryCustom
64 0.58520293235779 End of GetCategoryList function End of the function
65 0.58521890640259 Get Category List for Group Before the call to getCategoryList function
66 0.58522295951843 Start of GetCategoryList function Start of the function
67 0.58522605895996 Before getting categories Query to get specific category list
68 0.58564305305481 After getting categories Query to get specific category list
69 0.58564400672913 Before getting category custom Before call to function getCategoryCustom
70 0.58790111541748 After getting category custom After call to function getCategoryCustom
71 0.58790302276611 Before getting category custom Before call to function getCategoryCustom
72 0.5902271270752 After getting category custom After call to function getCategoryCustom
73 0.59022903442383 End of GetCategoryList function End of the function
74 0.59023499488831 Get Category List for Group Before the call to getCategoryList function
75 0.59023690223694 Start of GetCategoryList function Start of the function
76 0.59024000167847 Before getting categories Query to get specific category list
77 0.59054493904114 After getting categories Query to get specific category list
78 0.59054613113403 Before getting category custom Before call to function getCategoryCustom
79 0.59548711776733 After getting category custom After call to function getCategoryCustom
80 0.59548997879028 End of GetCategoryList function End of the function
81 0.59549593925476 End of getCategoryListByGroup Function Before return()
82 0.59550499916077 After Get Category List After getting the updated category list
83 0.59550595283508 Before Category Images Before getting the category images
84 0.59562206268311 After Category Images After getting the category images
85 0.59601497650146 Before Sub Category Check Before checking for sub category or products category
86 0.59752202033997 Before Category Products Controller Before loading the category products controller
87 0.5976939201355 Start Category Products Start of Category Products Controller
88 0.5977189540863 After Pagination Options After pagination options in Category Products Controller
89 0.59816002845764 After Cache After Cache checking in Category Products Controller
90 0.6759729385376 After Filter Options After getting filter options and SQL in Category Products Controller
91 0.67753291130066 After Counting Products After counting products in the Category Products Controller
92 0.67770195007324 After Counting Bundles After counting bundles in the Category Products Controller
93 0.67786598205566 After Counting Products After counting products in the Category Products Controller
94 0.68022012710571 After Getting Products After getting products and bundles in the Category Products Controller
95 0.68029999732971 After Pagination Links After getting pagination listing links in the Category Products Controller
96 0.68030095100403 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
97 0.7702739238739 After Getting Product Details After getting full product details in the Category Products Controller
98 0.77520298957825 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
99 0.77657294273376 App_after Controller Start Start of the App_after controller (called after the controller of every page)
100 0.77664995193481 Before Get Options Before the call to getOptions in the tpl class
101 1.189022064209 After Get Options After the call to getOptions in the tpl class
102 1.1893119812012 App_after Controller End End of the App_after controller (called after the controller of every page)
103 1.1893260478973 Before Smarty Before passing everything over to Smarty in the Category Products Controller
104 1.5777161121368 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
105 1.5777199268341 Finalizing debug Before the debug is output to the page.
106 1.5777359008789 End of App This is the end of the app logging, final timestamp


Query Debug - 924 Database Queries. Total time 0.7720 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00019192695617676
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00052809715270996
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00018692016601562
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015711784362793
SELECT * FROM `bad_bots`
5 0.0005 0.00054502487182617
SELECT parameter, value FROM parameters
6 0.0002 0.00017285346984863
SET time_zone = 'Europe/London'
7 0.0004 0.00037503242492676
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014710426330566
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011301040649414
delete from cachefiles
10 0.0003 0.0002591609954834
SELECT id FROM pages WHERE pagename = 'best-tactical-flashlight' LIMIT 1
11 0.0002 0.00024104118347168
SELECT id FROM products WHERE pagename = 'best-tactical-flashlight' AND hidden = 0 LIMIT 1
12 0.0001 0.00013208389282227
SELECT id FROM ebay_products WHERE pagename = 'best-tactical-flashlight'
13 0.0002 0.00016188621520996
SELECT id FROM categories WHERE pagename = 'best-tactical-flashlight' LIMIT 1
14 0.0008 0.00078010559082031
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0097 0.009666919708252
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0003 0.00027799606323242
SELECT * FROM pages WHERE pagename = 'best-tactical-flashlight'
17 0.0051 0.0051369667053223
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00040197372436523
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0003 0.00025200843811035
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '84'
24 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '357'
33 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '379'
34 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '401'
35 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '450'
36 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.0001671314239502
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '43'
42 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '44'
43 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '107'
48 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '108'
49 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '133'
51 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '217'
53 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '228'
54 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '271'
56 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '286'
57 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '364'
64 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '369'
66 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00016689300537109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '90'
72 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '414'
73 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '119'
74 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '406'
75 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '149'
76 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '150'
77 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '162'
79 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '164'
80 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '167'
81 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '180'
82 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '268'
85 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '411'
86 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '290'
87 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '413'
88 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '409'
89 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '327'
90 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '351'
92 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '370'
97 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '386'
99 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '408'
100 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '428'
106 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '432'
107 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '433'
108 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '436'
109 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '437'
110 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '464'
112 0.0001 0.00014996528625488
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '74'
114 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '145'
116 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '156'
117 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '407'
118 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '316'
121 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '334'
123 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '367'
124 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '387'
125 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00017213821411133
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '42'
130 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '86'
132 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '95'
133 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '102'
134 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '62'
140 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '317'
146 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '343'
148 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '349'
153 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '393'
156 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '394'
157 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '421'
160 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '426'
161 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '430'
162 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '441'
167 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '451'
168 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '453'
169 0.0001 0.00014090538024902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '146'
171 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '158'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '293'
174 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '417'
176 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '181'
179 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '299'
181 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '300'
182 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '385'
184 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '442'
186 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '134'
189 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '248'
193 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '115'
200 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '151'
203 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '200'
205 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '304'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '321'
207 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '350'
209 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '378'
210 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '425'
212 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '443'
213 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '444'
214 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '445'
215 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '446'
216 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '447'
217 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '448'
218 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '455'
219 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '456'
220 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
222 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '462'
223 0.0001 0.00014710426330566
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '182'
226 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '238'
227 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '240'
228 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '242'
229 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '252'
230 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '253'
231 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '262'
232 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '267'
233 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '420'
234 0.0001 0.00014591217041016
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0014 0.0014219284057617
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00029206275939941
SELECT * FROM categories WHERE pagename = 'best-tactical-flashlight'
239 0.0013 0.0012609958648682
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
240 0.0001 0.0001220703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 51
241 0.0003 0.00027179718017578
SELECT id FROM categories WHERE parent_id = '51'
242 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '101'
243 0.0018 0.0018279552459717
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 
244 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
245 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 (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
246 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
247 0.0002 0.000244140625
SELECT id FROM categories WHERE parent_id = '51'
248 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '101'
249 0.0019 0.0018770694732666
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (101, 51) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
250 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '404440' ORDER BY sortorder ASC
251 0.0001 0.00010991096496582
SELECT * FROM categoryimages WHERE category_id = 51
252 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '1'
253 0.0012 0.0012130737304688
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '51'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
254 0.0001 0.00014805793762207
SELECT parent_id FROM categories WHERE id = '51'
255 0.0001 0.00012111663818359
SELECT parent_id FROM categories WHERE id = '51'
256 0.0001 0.00014209747314453
SELECT * FROM categorygroups ORDER BY sortorder ASC
257 0.0005 0.00047993659973145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
258 0.0004 0.00043392181396484
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
259 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '49'
260 0.0004 0.00043296813964844
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 
261 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
262 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 
263 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
264 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
265 0.0030 0.0030479431152344
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
266 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '50'
267 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '96'
268 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '97'
269 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '111'
270 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
271 0.0058 0.0057969093322754
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 
272 0.0002 0.00019192695617676
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 
273 0.0002 0.00017094612121582
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 
274 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
275 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '1'
276 0.0023 0.0023248195648193
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
277 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '80'
278 0.0023 0.0023369789123535
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 
279 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
280 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
281 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
282 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
283 0.0012 0.0011749267578125
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
284 0.0003 0.00025582313537598
SELECT id FROM categories WHERE parent_id = '51'
285 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '101'
286 0.0018 0.0018131732940674
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 
287 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
288 0.0002 0.00015020370483398
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 
289 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
290 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '1'
291 0.0003 0.0003209114074707
SELECT * FROM categories WHERE parent_id = '51'  AND hidden = 0 ORDER BY sortorder ASC
292 0.0008 0.00076699256896973
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 = 101
293 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '101'
294 0.0008 0.00080513954162598
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
295 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101)
				  AND p.disabled = 0 
296 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 (101)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
297 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '101'
298 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '1'
299 0.0003 0.00027704238891602
SELECT * FROM categories WHERE parent_id = '101'  AND hidden = 0 ORDER BY sortorder ASC
300 0.0004 0.00035285949707031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
301 0.0024 0.0023670196533203
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
302 0.0003 0.00025510787963867
SELECT id FROM categories WHERE parent_id = '30'
303 0.0024 0.0023660659790039
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 
304 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 (30)
				  AND p.disabled = 0 
305 0.0002 0.00015807151794434
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 
306 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
307 0.0001 0.00012779235839844
SELECT * FROM categorygroups WHERE id = '2'
308 0.0049 0.0049169063568115
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
309 0.0003 0.00030398368835449
SELECT id FROM categories WHERE parent_id = '61'
310 0.0050 0.0049540996551514
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 
311 0.0002 0.00016689300537109
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 
312 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
313 0.0002 0.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
314 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '2'
315 0.0006 0.00063705444335938
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
316 0.0042 0.0041930675506592
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
317 0.0003 0.0002899169921875
SELECT id FROM categories WHERE parent_id = '64'
318 0.0042 0.0041849613189697
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 
319 0.0002 0.00017118453979492
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 
320 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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
321 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
322 0.0001 0.00012993812561035
SELECT * FROM categorygroups WHERE id = '10'
323 0.0083 0.0083198547363281
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
324 0.0003 0.00034403800964355
SELECT id FROM categories WHERE parent_id = '65'
325 0.0085 0.008465051651001
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 
326 0.0002 0.0001978874206543
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 
327 0.0002 0.00017285346984863
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 
328 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
329 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
330 0.0025 0.0025279521942139
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
331 0.0003 0.0002892017364502
SELECT id FROM categories WHERE parent_id = '81'
332 0.0025 0.0025289058685303
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 
333 0.0002 0.00016212463378906
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 
334 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
335 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
336 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
337 0.0025 0.002514123916626
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
338 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '31'
339 0.0025 0.0025260448455811
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 
340 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
341 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
342 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
343 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
344 0.0023 0.0023000240325928
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
345 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '66'
346 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '131'
347 0.0029 0.0028541088104248
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 
348 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
349 0.0002 0.0001530647277832
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 
350 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
351 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
352 0.0097 0.0097389221191406
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
353 0.0004 0.00035500526428223
SELECT id FROM categories WHERE parent_id = '34'
354 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '94'
355 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '98'
356 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '99'
357 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '110'
358 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '130'
359 0.0107 0.010658979415894
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 
360 0.0002 0.00021696090698242
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 
361 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
362 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
363 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
364 0.0016 0.0015909671783447
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
365 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '32'
366 0.0016 0.0015919208526611
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 
367 0.0001 0.00014781951904297
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 
368 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
369 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
370 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '10'
371 0.0018 0.0018348693847656
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
372 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '89'
373 0.0018 0.0018410682678223
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 
374 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
375 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
376 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
377 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
378 0.0004 0.00039315223693848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
379 0.0007 0.0006709098815918
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
380 0.0002 0.00023412704467773
SELECT id FROM categories WHERE parent_id = '84'
381 0.0007 0.0006871223449707
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 
382 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 
383 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
384 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
385 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
386 0.0007 0.00069499015808105
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
387 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '90'
388 0.0007 0.00072503089904785
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 
389 0.0001 0.00014090538024902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
390 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
391 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
392 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
393 0.0003 0.00029110908508301
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
394 0.0020 0.0020039081573486
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
395 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '92'
396 0.0020 0.0020201206207275
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 
397 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
398 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 (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
399 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
400 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '20'
401 0.0001 0.0001068115234375
SELECT * FROM categoryimages WHERE category_id = 51
402 0.0002 0.00016498565673828
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
403 0.0003 0.00026798248291016
SELECT * FROM categories WHERE parent_id = '51'
404 0.0012 0.0011970996856689
SELECT COUNT(*) FROM products_categories c, products p WHERE p.id = c.product_id AND c.category_id = '51' AND p.hidden = 0 AND (p.price > 0 OR p.parent = 1)
405 0.0320 0.032013177871704
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
406 0.0061 0.0061330795288086
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
407 0.0003 0.00028204917907715
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
408 0.0317 0.031656980514526
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
409 0.0061 0.0060849189758301
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
410 0.0003 0.00030398368835449
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
411 0.0014 0.0013551712036133
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 51
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
412 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 51
		AND c.prod_type = 'ebay'
		AND hide = 1
413 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 51
			AND p.disabled = 0
			
			AND 1 = 1
414 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 51
		AND c.prod_type = 'custom'
		AND hide = 1
415 0.0023 0.002263069152832
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 51
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 51
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 51
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 51
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
416 0.0002 0.00022506713867188
SELECT * FROM products WHERE id = '105259'
417 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '105259' ORDER BY sortorder ASC
418 0.0002 0.00021910667419434
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '105259' AND p.id = pi.product_id ORDER BY pi.sortorder
419 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '105259'
420 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '105259'
421 0.0002 0.00020694732666016
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '105259'
                GROUP BY o.product_id
422 0.0002 0.00024294853210449
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '105259'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
423 0.0002 0.00017595291137695
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 105259
424 0.0034 0.0033779144287109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '105259' AND a.name = n.originalname
425 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '105259' AND merchantid = 'ATVPDKIKX0DER'
426 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '105259' AND price > 0
                ORDER BY price ASC LIMIT 1
427 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 105259
                ORDER BY price ASC LIMIT 1
428 0.0003 0.0002748966217041
SELECT value FROM productattributes
                WHERE product_id = '105259'
                AND name = 'ListPriceAmount'
429 0.0002 0.0001990795135498
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '105259'
                GROUP BY o.product_id
430 0.0002 0.00022602081298828
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '105259'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
431 0.0002 0.00018000602722168
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 105259
432 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '105259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0002 0.00019097328186035
SELECT * FROM products WHERE parent_id = '105259'
434 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '409245'
435 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '409245' ORDER BY sortorder ASC
436 0.0003 0.0002748966217041
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '409245' AND p.id = pi.product_id ORDER BY pi.sortorder
437 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '409245'
438 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '409245'
439 0.0002 0.0002281665802002
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '409245'
                GROUP BY o.product_id
440 0.0003 0.00026607513427734
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '409245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
441 0.0002 0.00018596649169922
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 409245
442 0.0008 0.00076699256896973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409245' AND a.name = n.originalname
443 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '409245' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '409245' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 409245
                ORDER BY price ASC LIMIT 1
446 0.0003 0.00027799606323242
SELECT value FROM productattributes
                WHERE product_id = '409245'
                AND name = 'ListPriceAmount'
447 0.0002 0.00021100044250488
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '409245'
                GROUP BY o.product_id
448 0.0003 0.00025200843811035
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '409245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
449 0.0002 0.0001828670501709
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 409245
450 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '409245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
451 0.0003 0.00030803680419922
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '409245'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
452 0.0002 0.00021195411682129
SELECT * FROM products WHERE parent_id = '409245'
453 0.0002 0.0002291202545166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410980' AND a.name = n.originalname
454 0.0002 0.00016188621520996
SELECT * FROM productoffers WHERE product_id = '410980' AND merchantid = 'ATVPDKIKX0DER'
455 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '410980' AND price > 0
                ORDER BY price ASC LIMIT 1
456 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 410980
                ORDER BY price ASC LIMIT 1
457 0.0002 0.0002281665802002
SELECT value FROM productattributes
                WHERE product_id = '410980'
                AND name = 'ListPriceAmount'
458 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = '412050'
459 0.0001 0.00014591217041016
SELECT * FROM productimages WHERE product_id = '412050' ORDER BY sortorder ASC
460 0.0002 0.00020098686218262
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '412050' AND p.id = pi.product_id ORDER BY pi.sortorder
461 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '412050'
462 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412050'
463 0.0002 0.00020599365234375
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412050'
                GROUP BY o.product_id
464 0.0002 0.00022602081298828
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412050'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
465 0.0002 0.00017309188842773
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412050
466 0.0007 0.0007171630859375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412050' AND a.name = n.originalname
467 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '412050' AND merchantid = 'ATVPDKIKX0DER'
468 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '412050' AND price > 0
                ORDER BY price ASC LIMIT 1
469 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 412050
                ORDER BY price ASC LIMIT 1
470 0.0003 0.00027012825012207
SELECT value FROM productattributes
                WHERE product_id = '412050'
                AND name = 'ListPriceAmount'
471 0.0002 0.00020003318786621
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412050'
                GROUP BY o.product_id
472 0.0002 0.00022387504577637
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412050'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
473 0.0002 0.00017189979553223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412050
474 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '412050' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
475 0.0002 0.00019097328186035
SELECT * FROM products WHERE parent_id = '412050'
476 0.0002 0.00019598007202148
SELECT * FROM products WHERE id = '131223'
477 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '131223' ORDER BY sortorder ASC
478 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '131223'
479 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '131223'
480 0.0022 0.002249002456665
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131223' AND a.name = n.originalname
481 0.0002 0.00017619132995605
SELECT * FROM productoffers WHERE product_id = '131223' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '131223' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 131223
                ORDER BY price ASC LIMIT 1
484 0.0002 0.00023698806762695
SELECT value FROM productattributes
                WHERE product_id = '131223'
                AND name = 'ListPriceAmount'
485 0.0001 0.00012993812561035
UPDATE products SET price = '10995' WHERE id = '131223'
486 0.0002 0.00019502639770508
SELECT * FROM products WHERE id = '407566'
487 0.0002 0.00023388862609863
SELECT * FROM productimages WHERE product_id = '407566' ORDER BY sortorder ASC
488 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '407566'
489 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407566'
490 0.0031 0.0030560493469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407566' AND a.name = n.originalname
491 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '407566' AND merchantid = 'ATVPDKIKX0DER'
492 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = '407566' AND price > 0
                ORDER BY price ASC LIMIT 1
493 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 407566
                ORDER BY price ASC LIMIT 1
494 0.0002 0.00022387504577637
SELECT value FROM productattributes
                WHERE product_id = '407566'
                AND name = 'ListPriceAmount'
495 0.0001 0.00011992454528809
UPDATE products SET price = '11996' WHERE id = '407566'
496 0.0002 0.00019311904907227
SELECT * FROM products WHERE id = '306866'
497 0.0001 0.00014710426330566
SELECT * FROM productimages WHERE product_id = '306866' ORDER BY sortorder ASC
498 0.0002 0.00023698806762695
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '306866' AND p.id = pi.product_id ORDER BY pi.sortorder
499 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '306866'
500 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '306866'
501 0.0002 0.00021791458129883
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '306866'
                GROUP BY o.product_id
502 0.0003 0.0002892017364502
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '306866'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
503 0.0002 0.00019192695617676
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 306866
504 0.0006 0.00060677528381348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '306866' AND a.name = n.originalname
505 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '306866' AND merchantid = 'ATVPDKIKX0DER'
506 0.0002 0.00017619132995605
SELECT * FROM productoffers
                WHERE product_id = '306866' AND price > 0
                ORDER BY price ASC LIMIT 1
507 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 306866
                ORDER BY price ASC LIMIT 1
508 0.0002 0.00023913383483887
SELECT value FROM productattributes
                WHERE product_id = '306866'
                AND name = 'ListPriceAmount'
509 0.0002 0.00021910667419434
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '306866'
                GROUP BY o.product_id
510 0.0003 0.00028300285339355
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '306866'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
511 0.0002 0.00019288063049316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 306866
512 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '306866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
513 0.0003 0.00032591819763184
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '306866'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
514 0.0002 0.00020718574523926
SELECT * FROM products WHERE id = '171660'
515 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '171660' ORDER BY sortorder ASC
516 0.0002 0.00024604797363281
SELECT * FROM product_image_select WHERE product_id = '171660'
517 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '171660'
518 0.0025 0.0025100708007812
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171660' AND a.name = n.originalname
519 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '171660' AND merchantid = 'ATVPDKIKX0DER'
520 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '171660' AND price > 0
                ORDER BY price ASC LIMIT 1
521 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '171660' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
522 0.0001 0.0001218318939209
UPDATE products SET price = '2099' WHERE id = '171660'
523 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '407540'
524 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '407540' ORDER BY sortorder ASC
525 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407540'
526 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '407540'
527 0.0027 0.0027050971984863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407540' AND a.name = n.originalname
528 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '407540' AND merchantid = 'ATVPDKIKX0DER'
529 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '407540' AND price > 0
                ORDER BY price ASC LIMIT 1
530 0.0002 0.00017094612121582
SELECT * FROM productoffers
                WHERE product_id = 407540
                ORDER BY price ASC LIMIT 1
531 0.0002 0.00024890899658203
SELECT value FROM productattributes
                WHERE product_id = '407540'
                AND name = 'ListPriceAmount'
532 0.0001 0.00011897087097168
UPDATE products SET price = '31620' WHERE id = '407540'
533 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '413912'
534 0.0001 0.00014519691467285
SELECT * FROM productimages WHERE product_id = '413912' ORDER BY sortorder ASC
535 0.0003 0.0002748966217041
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '413912' AND p.id = pi.product_id ORDER BY pi.sortorder
536 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '413912'
537 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '413912'
538 0.0002 0.00021100044250488
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '413912'
                GROUP BY o.product_id
539 0.0003 0.00027298927307129
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '413912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
540 0.0002 0.00018906593322754
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413912
541 0.0005 0.00053191184997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413912' AND a.name = n.originalname
542 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '413912' AND merchantid = 'ATVPDKIKX0DER'
543 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '413912' AND price > 0
                ORDER BY price ASC LIMIT 1
544 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 413912
                ORDER BY price ASC LIMIT 1
545 0.0002 0.00024986267089844
SELECT value FROM productattributes
                WHERE product_id = '413912'
                AND name = 'ListPriceAmount'
546 0.0002 0.00021100044250488
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '413912'
                GROUP BY o.product_id
547 0.0003 0.00026607513427734
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '413912'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
548 0.0002 0.0001838207244873
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413912
549 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '413912' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
550 0.0003 0.00030398368835449
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '413912'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
551 0.0002 0.0002129077911377
SELECT * FROM products WHERE parent_id = '413912'
552 0.0002 0.00021505355834961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413913' AND a.name = n.originalname
553 0.0002 0.00016498565673828
SELECT * FROM productoffers WHERE product_id = '413913' AND merchantid = 'ATVPDKIKX0DER'
554 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '413913' AND price > 0
                ORDER BY price ASC LIMIT 1
555 0.0002 0.00015878677368164
SELECT * FROM productoffers
                WHERE product_id = 413913
                ORDER BY price ASC LIMIT 1
556 0.0002 0.00024509429931641
SELECT value FROM productattributes
                WHERE product_id = '413913'
                AND name = 'ListPriceAmount'
557 0.0002 0.0001978874206543
SELECT * FROM products WHERE id = '194742'
558 0.0004 0.00035905838012695
SELECT * FROM productimages WHERE product_id = '194742' ORDER BY sortorder ASC
559 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '194742'
560 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '194742'
561 0.0034 0.0034489631652832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '194742' AND a.name = n.originalname
562 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '194742' AND merchantid = 'ATVPDKIKX0DER'
563 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = '194742' AND price > 0
                ORDER BY price ASC LIMIT 1
564 0.0002 0.00015878677368164
SELECT * FROM productoffers
                WHERE product_id = 194742
                ORDER BY price ASC LIMIT 1
565 0.0003 0.0002748966217041
SELECT value FROM productattributes
                WHERE product_id = '194742'
                AND name = 'ListPriceAmount'
566 0.0001 0.00012111663818359
UPDATE products SET price = '2599' WHERE id = '194742'
567 0.0002 0.00019192695617676
SELECT * FROM products WHERE id = '407557'
568 0.0003 0.00025010108947754
SELECT * FROM productimages WHERE product_id = '407557' ORDER BY sortorder ASC
569 0.0003 0.00032901763916016
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '407557' AND p.id = pi.product_id ORDER BY pi.sortorder
570 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '407557'
571 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '407557'
572 0.0003 0.00026798248291016
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '407557'
                GROUP BY o.product_id
573 0.0004 0.00038599967956543
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '407557'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
574 0.0002 0.00023102760314941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407557
575 0.0005 0.00049304962158203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407557' AND a.name = n.originalname
576 0.0002 0.00016593933105469
SELECT * FROM productoffers WHERE product_id = '407557' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '407557' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0002 0.0001678466796875
SELECT * FROM productoffers
                WHERE product_id = 407557
                ORDER BY price ASC LIMIT 1
579 0.0002 0.00024700164794922
SELECT value FROM productattributes
                WHERE product_id = '407557'
                AND name = 'ListPriceAmount'
580 0.0003 0.00026297569274902
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '407557'
                GROUP BY o.product_id
581 0.0004 0.0003819465637207
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '407557'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
582 0.0002 0.00023508071899414
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 407557
583 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '407557' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
584 0.0001 0.00011801719665527
UPDATE products SET price = '21464' WHERE id = '407557'
585 0.0004 0.0003659725189209
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '407557'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
586 0.0004 0.00035309791564941
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '407557'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
587 0.0002 0.00020599365234375
SELECT * FROM products WHERE id = '148089'
588 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '148089' ORDER BY sortorder ASC
589 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '148089'
590 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '148089'
591 0.0023 0.0022649765014648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '148089' AND a.name = n.originalname
592 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '148089' AND merchantid = 'ATVPDKIKX0DER'
593 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '148089' AND price > 0
                ORDER BY price ASC LIMIT 1
594 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '148089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
595 0.0001 0.00011897087097168
UPDATE products SET price = '5745' WHERE id = '148089'
596 0.0002 0.00019598007202148
SELECT * FROM products WHERE id = '260504'
597 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '260504' ORDER BY sortorder ASC
598 0.0003 0.00025606155395508
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '260504' AND p.id = pi.product_id ORDER BY pi.sortorder
599 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '260504'
600 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '260504'
601 0.0002 0.00023698806762695
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '260504'
                GROUP BY o.product_id
602 0.0003 0.00025701522827148
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '260504'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
603 0.0002 0.00019407272338867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 260504
604 0.0023 0.0023097991943359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '260504' AND a.name = n.originalname
605 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '260504' AND merchantid = 'ATVPDKIKX0DER'
606 0.0002 0.00017714500427246
SELECT * FROM productoffers
                WHERE product_id = '260504' AND price > 0
                ORDER BY price ASC LIMIT 1
607 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 260504
                ORDER BY price ASC LIMIT 1
608 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '260504'
                AND name = 'ListPriceAmount'
609 0.0002 0.00022482872009277
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '260504'
                GROUP BY o.product_id
610 0.0003 0.00026512145996094
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '260504'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
611 0.0002 0.00019097328186035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 260504
612 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '260504' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
613 0.0001 0.00011801719665527
UPDATE products SET price = '2802' WHERE id = '260504'
614 0.0003 0.00031399726867676
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '260504'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
615 0.0002 0.00021195411682129
SELECT * FROM products WHERE parent_id = '260504'
616 0.0002 0.0002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411008' AND a.name = n.originalname
617 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '411008' AND merchantid = 'ATVPDKIKX0DER'
618 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '411008' AND price > 0
                ORDER BY price ASC LIMIT 1
619 0.0002 0.00020003318786621
SELECT * FROM products WHERE id = '149634'
620 0.0005 0.00053310394287109
SELECT * FROM productimages WHERE product_id = '149634' ORDER BY sortorder ASC
621 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '149634'
622 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '149634'
623 0.0021 0.0020999908447266
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '149634' AND a.name = n.originalname
624 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '149634' AND merchantid = 'ATVPDKIKX0DER'
625 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '149634' AND price > 0
                ORDER BY price ASC LIMIT 1
626 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 149634
                ORDER BY price ASC LIMIT 1
627 0.0002 0.0002448558807373
SELECT value FROM productattributes
                WHERE product_id = '149634'
                AND name = 'ListPriceAmount'
628 0.0001 0.00012111663818359
UPDATE products SET price = '6203' WHERE id = '149634'
629 0.0002 0.00019717216491699
SELECT * FROM products WHERE id = '162816'
630 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '162816' ORDER BY sortorder ASC
631 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '162816'
632 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '162816'
633 0.0019 0.0019159317016602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '162816' AND a.name = n.originalname
634 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '162816' AND merchantid = 'ATVPDKIKX0DER'
635 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '162816' AND price > 0
                ORDER BY price ASC LIMIT 1
636 0.0003 0.00032591819763184
SELECT value FROM productattributes WHERE product_id = '162816' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
637 0.0001 0.0001220703125
UPDATE products SET price = '1095' WHERE id = '162816'
638 0.0002 0.0001990795135498
SELECT * FROM products WHERE id = '406095'
639 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '406095' ORDER BY sortorder ASC
640 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '406095'
641 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406095'
642 0.0024 0.0023560523986816
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406095' AND a.name = n.originalname
643 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '406095' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '406095' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0002 0.00017094612121582
SELECT * FROM productoffers
                WHERE product_id = 406095
                ORDER BY price ASC LIMIT 1
646 0.0002 0.00020790100097656
SELECT value FROM productattributes
                WHERE product_id = '406095'
                AND name = 'ListPriceAmount'
647 0.0001 0.00011992454528809
UPDATE products SET price = '7708' WHERE id = '406095'
648 0.0002 0.00019717216491699
SELECT * FROM products WHERE id = '263868'
649 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '263868' ORDER BY sortorder ASC
650 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '263868'
651 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '263868'
652 0.0023 0.0023210048675537
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263868' AND a.name = n.originalname
653 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '263868' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '263868' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 263868
                ORDER BY price ASC LIMIT 1
656 0.0002 0.00020098686218262
SELECT value FROM productattributes
                WHERE product_id = '263868'
                AND name = 'ListPriceAmount'
657 0.0001 0.00011801719665527
UPDATE products SET price = '2399' WHERE id = '263868'
658 0.0002 0.00020790100097656
SELECT * FROM products WHERE id = '128353'
659 0.0003 0.00031590461730957
SELECT * FROM productimages WHERE product_id = '128353' ORDER BY sortorder ASC
660 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '128353'
661 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '128353'
662 0.0016 0.0015978813171387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128353' AND a.name = n.originalname
663 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '128353' AND merchantid = 'ATVPDKIKX0DER'
664 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '128353' AND price > 0
                ORDER BY price ASC LIMIT 1
665 0.0003 0.00034189224243164
SELECT value FROM productattributes WHERE product_id = '128353' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
666 0.0001 0.00011801719665527
UPDATE products SET price = '5995' WHERE id = '128353'
667 0.0003 0.0003058910369873
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '105259' ORDER BY timestamp DESC
668 0.0003 0.00027322769165039
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '409245' ORDER BY timestamp DESC
669 0.0003 0.00025701522827148
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '412050' ORDER BY timestamp DESC
670 0.0003 0.00025486946105957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '131223' ORDER BY timestamp DESC
671 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407566' ORDER BY timestamp DESC
672 0.0003 0.00026297569274902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '306866' ORDER BY timestamp DESC
673 0.0003 0.00025486946105957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '171660' ORDER BY timestamp DESC
674 0.0003 0.00025582313537598
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407540' ORDER BY timestamp DESC
675 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413912' ORDER BY timestamp DESC
676 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '194742' ORDER BY timestamp DESC
677 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '407557' ORDER BY timestamp DESC
678 0.0003 0.00025105476379395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '148089' ORDER BY timestamp DESC
679 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '260504' ORDER BY timestamp DESC
680 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '149634' ORDER BY timestamp DESC
681 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '162816' ORDER BY timestamp DESC
682 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406095' ORDER BY timestamp DESC
683 0.0003 0.00026607513427734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '263868' ORDER BY timestamp DESC
684 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '128353' ORDER BY timestamp DESC
685 0.0002 0.00016307830810547
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 51
		AND c.prod_type = 'ebay'
		AND hide = 1
686 0.0001 0.00013184547424316
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
687 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
688 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
689 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
690 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
691 0.0001 0.00013303756713867
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
692 0.0002 0.00016093254089355
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
693 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 2
694 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 4
695 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
696 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 10
697 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
698 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = 18
699 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 28
700 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 13
701 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 3
702 0.0433 0.043287038803101
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
703 0.0003 0.00031495094299316
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:1560757206;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:1;s:6:\"407595\";i:3;s:6:\"171938\";i:4;s:6:\"410588\";i:5;s:6:\"412927\";i:6;s:6:\"409759\";}}' WHERE id = '175'
704 0.0005 0.00047087669372559
SELECT * FROM products WHERE id IN (398315,407595,171938,410588,412927,409759) ORDER BY FIELD(id, 398315,407595,171938,410588,412927,409759 )
705 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
706 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '398315'
707 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '398315'
708 0.0026 0.0026259422302246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
709 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
710 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
711 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
712 0.0001 0.00012707710266113
UPDATE products SET price = '1999' WHERE id = '398315'
713 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
714 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407595'
715 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '407595'
716 0.0034 0.0034201145172119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
717 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0004 0.00043678283691406
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.00012493133544922
UPDATE products SET price = '2497' WHERE id = '407595'
721 0.0006 0.0006108283996582
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
722 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
723 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '171938'
724 0.0026 0.0025699138641357
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
725 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.00012683868408203
UPDATE products SET price = '389500' WHERE id = '171938'
729 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
730 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '410588'
731 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '410588'
732 0.0020 0.0020060539245605
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
733 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.0001220703125
UPDATE products SET price = '269999' WHERE id = '410588'
737 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
738 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '412927'
739 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '412927'
740 0.0037 0.0036609172821045
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
741 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00012898445129395
UPDATE products SET price = '199900' WHERE id = '412927'
745 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
746 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '409759'
747 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '409759'
748 0.0028 0.002816915512085
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
749 0.0002 0.00020289421081543
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
750 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
751 0.0004 0.00039577484130859
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
752 0.0001 0.00012397766113281
UPDATE products SET price = '229000' WHERE id = '409759'
753 0.0435 0.043503046035767
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
754 0.0003 0.00029611587524414
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:1560757206;s:8:\"products\";a:6:{i:14;s:6:\"414188\";i:17;s:6:\"408078\";i:19;s:6:\"131163\";i:1;s:6:\"407595\";i:2;s:6:\"290575\";i:4;s:6:\"410588\";}}' WHERE id = '177'
755 0.0005 0.00047516822814941
SELECT * FROM products WHERE id IN (414188,408078,131163,407595,290575,410588) ORDER BY FIELD(id, 414188,408078,131163,407595,290575,410588 )
756 0.0003 0.00028896331787109
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
757 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '414188'
758 0.0002 0.0001530647277832
SELECT * FROM productcustomimages WHERE product_id = '414188'
759 0.0027 0.0026810169219971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
760 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
761 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
762 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
763 0.0001 0.00012707710266113
UPDATE products SET price = '9999' WHERE id = '414188'
764 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
765 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '408078'
766 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '408078'
767 0.0031 0.003122091293335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
768 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00012493133544922
UPDATE products SET price = '23352' WHERE id = '408078'
772 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
773 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '131163'
774 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '131163'
775 0.0026 0.0025739669799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
776 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
777 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
779 0.0001 0.00013399124145508
UPDATE products SET price = '20362' WHERE id = '131163'
780 0.0002 0.00023007392883301
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
781 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '407595'
782 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '407595'
783 0.0034 0.0034010410308838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
784 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
785 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
786 0.0004 0.0004417896270752
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
787 0.0001 0.00012707710266113
UPDATE products SET price = '2497' WHERE id = '407595'
788 0.0006 0.00057387351989746
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
789 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '290575'
790 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '290575'
791 0.0034 0.0034310817718506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
792 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
793 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
794 0.0004 0.00042819976806641
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
795 0.0001 0.00012302398681641
UPDATE products SET price = '549500' WHERE id = '290575'
796 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
797 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '410588'
798 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '410588'
799 0.0020 0.0019910335540771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
800 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
801 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
803 0.0001 0.00012302398681641
UPDATE products SET price = '269999' WHERE id = '410588'
804 0.1051 0.10513377189636
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
805 0.0003 0.00027799606323242
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:1560757206;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:2;s:6:\"290575\";i:4;s:6:\"410588\";i:12;s:6:\"414825\";i:22;s:6:\"406901\";i:3;s:6:\"171938\";}}' WHERE id = '181'
806 0.0005 0.00045609474182129
SELECT * FROM products WHERE id IN (398315,290575,410588,414825,406901,171938) ORDER BY FIELD(id, 398315,290575,410588,414825,406901,171938 )
807 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
808 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '398315'
809 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '398315'
810 0.0025 0.0024988651275635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
811 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
812 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
813 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
814 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
815 0.0006 0.0005791187286377
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
816 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '290575'
817 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '290575'
818 0.0034 0.0033810138702393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
819 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
820 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
821 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
822 0.0001 0.00011992454528809
UPDATE products SET price = '549500' WHERE id = '290575'
823 0.0002 0.00017905235290527
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
824 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410588'
825 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '410588'
826 0.0020 0.0019710063934326
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
827 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
828 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
829 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
830 0.0001 0.00012016296386719
UPDATE products SET price = '269999' WHERE id = '410588'
831 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
832 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '414825'
833 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414825'
834 0.0020 0.0020129680633545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
835 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
836 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
837 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
838 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
839 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
840 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '406901'
841 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '406901'
842 0.0023 0.0023319721221924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
843 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
844 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
845 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
846 0.0001 0.00012016296386719
UPDATE products SET price = '395' WHERE id = '406901'
847 0.0006 0.00060701370239258
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
848 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '171938'
849 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '171938'
850 0.0025 0.0025460720062256
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
851 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
852 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
853 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
854 0.0001 0.00011897087097168
UPDATE products SET price = '389500' WHERE id = '171938'
855 0.1036 0.10363698005676
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
856 0.0003 0.00026202201843262
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:1560757206;s:8:\"products\";a:6:{i:12;s:6:\"414825\";i:14;s:6:\"414188\";i:16;s:6:\"407620\";i:20;s:6:\"410949\";i:21;s:6:\"408079\";i:23;s:6:\"400044\";}}' WHERE id = '183'
857 0.0004 0.00044488906860352
SELECT * FROM products WHERE id IN (414825,414188,407620,410949,408079,400044) ORDER BY FIELD(id, 414825,414188,407620,410949,408079,400044 )
858 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
859 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414825'
860 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414825'
861 0.0020 0.0020120143890381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
862 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
863 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
864 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
865 0.0001 0.0001220703125
UPDATE products SET price = '11999' WHERE id = '414825'
866 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
867 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '414188'
868 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414188'
869 0.0025 0.0025341510772705
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
870 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
871 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
872 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
873 0.0001 0.00011706352233887
UPDATE products SET price = '9999' WHERE id = '414188'
874 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
875 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '407620'
876 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '407620'
877 0.0023 0.0022749900817871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
878 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
879 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
880 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
881 0.0001 0.00011801719665527
UPDATE products SET price = '20323' WHERE id = '407620'
882 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
883 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '410949'
884 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '410949'
885 0.0026 0.0026171207427979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
886 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
887 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
888 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
889 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
890 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
891 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408079'
892 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '408079'
893 0.0032 0.0032088756561279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
894 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
895 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
896 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
897 0.0001 0.00012111663818359
UPDATE products SET price = '20106' WHERE id = '408079'
898 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
899 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '400044'
900 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '400044'
901 0.0027 0.002748966217041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
902 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
903 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
904 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
905 0.0001 0.00012779235839844
UPDATE products SET price = '16091' WHERE id = '400044'
906 0.0004 0.00040197372436523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
907 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
908 0.0001 0.00013518333435059
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
909 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
910 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
911 0.0004 0.00039315223693848
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
912 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
913 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
914 0.0009 0.00093197822570801
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
915 0.0003 0.00030207633972168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
916 0.0003 0.00029706954956055
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
917 0.0004 0.0003960132598877
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
918 0.0002 0.00016188621520996
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
919 0.0001 0.0001380443572998
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
920 0.0001 0.00013589859008789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
921 0.0001 0.0001370906829834
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
922 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
923 0.0003 0.00034809112548828
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
924 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'