Tactical Equipment - Survivalist Equipment

Porsonal & Self Defence Stun Guns

Buy Stun Gun Online Cheap

UPDATED :  

VIPERTEK VTS-880 - 35,000,000 VOLT MINI STUN GUN

Best selling Vipertek stun gun

The VIPERTEK VTS-880 mini stun gun really packs a punch!

Just test firing this unit into the air is often enough to stop an attacker. As the bright electric current pulsates between the test prongs and creates an intimidating electrical crackling sound, an attacker with any sense at all will be stopped in his tracks.

If the sight and sound doesn't stop him, a jolt from this stun gun certainly will bring an attacker down. When an attacker is touched by the stun gun it will disrupt the message the brain sends to the voluntary muscles.

Simply touching an attacker will deliver a high voltage shock causing loss of balance and muscle control, confusion, and disorientation bringing him to his knees and making him incapable of further aggressive activity.



VENDOR SAMPLES


STUN MASTER® STUN GUN

The STUN MASTER® LI'L GUY 12 MILLION VOLT STUN GUN WITH FLASHLIGHT and Nylon Holster. This little stun gun is small and compact with 4.4 milliamps depending on the charge of the batteries. It has a super bright LED flashlight, built-in charger, and comes with a nylon case. Don't let the name Stun Master* Li'l Guy fool you, It has a beast inside just waiting to be released. Just press the shock button and the Li'l Guy unleashes 12 Million volts out of the metal probes. The safety switch is off when in the down position, middle position is the super bright LED flashlight, and in the up position the shock is turned on once the trigger is pressed. Available in 9 colors: Black, Pink, Purple, Red, Blue, Green, Snake Skin, Animal Print, and fower Design. Matching leatherette holster sold seperatly. LIFETIME WARRANTY


STUN MASTER® 4.5 MILLION VOLT MINI STUN BATON

STUN MASTER® 4.5 MILLION VOLT MINI BATON comes with a rechargeable battery, LED Flashlight, Safety Switch, Safety Wrist Strap and Pull Pin. Special conductive screws will shock anyone trying to grab the stun baton from you.

If they touch anywhere near the screws on the barrel of the stun baton they will be shocked and forced to let go. 4.4 milliamps depending on the charge of the batteries. LIFETIME WARRANTY.


STUN MASTER® 12 MILLION VOLT STUN BATON

STUN MASTER® 12 MILLION VOLT STUN BATON - The rubberized coating ensures a firm grip and the strips down the barrel of the stun baton release a hellish shock to anyone trying to take the baton from you. It is rechargeable and has a super bright 3 function flashlight with 3 modes: a high beam, low beam, and strobe. The baton has a wrist strap with disable pin that prevents the stun gun from functioning if the baton gets taken away from you during an attack. Includes wrist strap disable pin, wall charger, and nylon holster. 4.6 milliamps depending on the charge of the battery. Available in 3 colors: Black, Pink, and Purple. LIFETIME WARRANTY.


STUN MASTER® HOT SHOT STUN GUN

The STUN MASTER® HOT SHOT is only 3 inches long and looks like a Blackberry or other hand-held mobile device. With a dazzling 11 million volts, it has the effect of a baseball bat, combined with the element of surprise. This uniquely designed stun gun is equipped with a safety on/off switch and an illuminated red light that tells you it's ready to unleash pain on your attacker. Uses 3 Lithium CR123A batteries (included free), a $10.00 value. Comes with a free nylon holster with belt loop. 48 milliamps depending on the freshness of the batteries. LIFETIME WARRANTY.


STUN MASTER® 20 MILLION VOLT BAD ASS METAL STUN BATON and FLASHLIGHT

STUN MASTER® 20 MILLION VOLT BAD ASS METAL STUN BATON and FLASHLIGHT - Blind, Buzz and Bash! Introducing the all new Stun Master* Bad Ass! This 3 in 1 baton is the first combination of its kind made out of aircraft quality aluminum. It features a high end tactical flashlight and a powerful 20 million volt blast of electricity that will put the biggest, baddest attacker on well.... his ass.

Often imitated but never quite duplicated, the Bad Ass Baton is made of some of the strongest material known to man. The 120 Lumen super bright LED flashlight will provide that beacon of light in a dark and scary world. With its firm rubberized grip and wrist strap, the Bad Ass Baton can easily be used as a heavy duty clubber. At the front end of the baton is a jaw dropping 20 million volt stun gun. The baton emits an electrifying shock with the simple ease of pushing a button. 4.9 milliamps depending on the charge of the batteries. The baton includes charger cord. LIFETIME WARRANTY.


The STUN MASTER® 15 MILLION VOLT MINI BADASS FLASHLIGHT STUN GUN

The STUN MASTER® 15 MILLION VOLT MINI BADASS FLASHLIGHT STUN GUN is made of high quality aircraft aluminum and delivers a shocking blow when used as a stun gun, flashlight, or baton, You can carry 15 million volts of stopping power almost anywhere with no one even knowing because the stun gun is concealed in the flashlight. Light up any attacker and leave them wishing they had never approached you. 4.7 milliamps depending on the charge of the batteries. LIFETIME WARRANTY.


STUN MASTER® COVERT STUN GUN FLASHLIGHT

The STUN MASTER® COVERT STUN GUN FLASHLIGHT is a great addition to your arsenal for self defense. The hidden probes make it look like it is just an ordinary flashlight. If given the chance this ordinary looking flashlight will pump 9 million volts right into any attacker, it is rechargeable in two different ways. It can be charged with the supplied wall charger and a cigarette lighter adaptor so it can be charged on the go. It comes with a standard wrist strap and has a rubberized coating to help secure a firm grip. 4.7 milliamps depending on the charge of the batteries. LIFETIME WARRANTY.


STUN MASTER® 18 MILLION VOLT FLASHLIGHT STUN GUN

The STUN MASTER® 18 MILLION VOLT FLASHLIGHT STUN GUN with MOBILE CHARGER is made of high quality aircraft aluminum and delivers a shocking blow when used as a stun gun, flashlight, or baton. You can carry 18 million volts of stopping power almost anywhere with no one even knowing becaus e the stun gun is concealed in the flashlight.

It has a built-in USB charger to charge iPods, iPad, iPhone, iPhone 5S, and a mini USB to charge most other smart phones. It also comes with a wall wall charger. Light up any attacker and leave them wishing they had never approached you. 4.6 milliamps depending on the charge of the batteries. LIFETIME WARRANTY.


MULTIPURPOSE 10 MILLION VOLT STUN ALARM FLASHLIGHT

The new and improved MULTIPURPOSE 10 MILLION VOLT STUN ALARM FLASHLIGHT is rechargeable and has LED bulbs in the flashlight. It features a stun gun function, 150 db alarm with steady red light, bright led flash light, led red flash light, led red flashing light for signaling, and shoulder strap. This is a great item for police, security, and for self defense. 4.8 milliamps depending on the charge of the battery. LIFETIME WARRANTY.


DOUBLE TROUBLE STUN GUN

Is like having two stun guns in one. TWICE the contact -- totaling 1.2 million volts -- TWICE the stopping power! More effective than most stun guns because of the space between the contacts. The greater the space, the greater the effect. Most stun guns only have 1.5 inches.

  • Double Trouble has 5 inches between contacts.
  • Rubber Coated Soft Contour Grip to make it easy to hold and hang on to.
  • Safety switch is on the top with a red LED on/off indicator to let you know if the stun gun is ready to fire.
  • Also comes with a hand strap and FREE Nylon Carrying Case with Belt Clip ($15.00 Value).
  • Only 6 inches long. Weighs 6.9 oz.
  • Uses two CR123A batteries (included).

KNUCKLE BLASTER STUN GUN

The KNUCLE BLASTER is a 950,000 Volt stun gun designed to give you a punch with power. Just touch your attacker to instantly repel them and give you time to get away. Longer contact will cause further disorientation and after some seconds may drop them to their knees.

  • Uses 2 Lithium batteries (included).
  • Comes with a FREE nylon belt holster ($15.00 Value)
  • designed to allow quick access and deployment of this amazing stun weapon.
  • This patented device has a soft rubber skin and is sized to accommodate all hand sizes.
  • A safety switch is built in and accessible to your thumb. Once you grab the Knuckle

Blaster stun gun you can flip off the safety and fire with the same hand. No need to use two hands. One year warranty


RUNT STUN GUN

Buy Runt stun guns online cheap

THE RECHARGEABLE 20 MILLION VOLT RUNT STUN GUNS now has an LED flashlight and wrist strap disable pin. It's easily concealable, and virtually undetectable in the hand of a woman or a man. The Runt uses a new cutting edge micro-technology to deliver super powere d protection. You can carry the Runt in your han d or pocket. It also has a rubberized coating for a better grip. If you would like to wear it like a cell phone there is a heavy duty nylon belt loop holster included. Available in 6 colors: Black, Pink, Red, Purple, Green, and Blue. Specifications: 4.5 milliamps depending on the charge of the batteries, 20,000,000 volts, Rechargeable.


PERSONAL SAFETY EQUIPMENT


TASER (not for sale)

The TASER Electronic Control Devices are non-lethal, self-defense alternatives that are almost 100% effective.

They combine the injury reducing benefits of traditional stun technology with a quantum leap in stopping power via new Electro-Muscular Disruption (EMD) technology. In police studies, TASEP®electronic control devices have a higher instant incapacitation rate than a 9mm hand gun.

The TASEP® control devices use replaceable cartridges which contain compressed nitrogen to deploy two small probes that attach to the main unit by insulated conductive wires with a maximum length of 15 feet. 50,000 volts travels over the wires and overrides the central nervous system providing incredible take down power. The energy can penetrate up to two cumulative inches of clothing.

These devices can stop a threat up to 15 feet away, allowing you a safe distance to protect yourself and your family from an attacker.

If a dose quarter defense is warranted, TASEP® devices double as contact stun devices to repel someone as a powerful and unexpected backup capability.

Cartridges for TASER® devices have a unique serial numbers and are equipped with an Anti-Felon Identification system, which discharges 20-30 serialized paper tags when deployed. Law enforcement can later retrieve this confetti from the scene and contact TASER® International to get the name of the owner of the device, allowing police to track any potential misuse. Lifetime Replacement Guarantee included with each device.

The TASER® C2 GOLD KIT™ has everything a user needs to carry and practice using the TASER® C2™ device. Utilizing the same technology as their proven law enforcement models, the C2™ has incredible take down power. Dimensions of TASEP® C2™ device: 5-1/2" x 2-1/10" x 1-1/4"


Our most popular product: Rechargable Micro Stun Gun


STUN GUN LAWS BY STATE

States Where Stun Guns Are Illegal: Rhode Island, Michigan, Hawaii, Illinois, Massachusetts, New Jersey, Wisconsin, and New York.

A few cities such as Philadelphia and Baltimore have enacted city stun gun illegal laws, even though the state laws do not prohibit the possession of a stun gun. It should also be noted that some of the states that allow possession of a stun gun do not allow them to be taken to school or other public buildings.

Stun gun laws map USA legal states

State Legal for Consumer
Use/Possession
Permit Required for Consumers
to Possess
Alabama Legal No permit required
Alaska Legal No permit required
Arizona Legal No permit required
Arkansas Legal No permit required
California Legal No permit required
Colorado Legal No permit required
Connecticut Legal in Home only n/a
Delaware Legal No permit required
District of Columbia Illegal No permit required
Florida Legal No permit required
Georgia Legal No permit required
Hawaii Illegal n/a
Idaho Legal No permit required
Illinois Legal with FOID
Click here to apply FOID
permit required
Indiana Legal (TASER subject to requirement of handgun license) No permit required
Iowa Legal permit required
Kansas Legal No permit required
Kentucky Legal No permit required
Louisiana Legal No permit required
Maine Legal No permit required
Maryland Legal except
Prohibited in Annapolis, Baltimore & Howard County
No permit required
Massachusetts Illegal n/a
Michigan Legal with Firearm license
Can only purhcase from local dealer
No online purchase.
permit required
Minnesota Legal No permit required
Mississippi Legal permit required
Missouri Legal No permit required
Montana Legal No permit required
Nebraska Legal No permit required
Nevada Legal No permit required
New Hampshire Legal No permit required
New Jersey Illegal n/a
New Mexico Legal No permit required
New York Illegal n/a
North Carolina Legal
(no concealed carry outside of own premises)
No permit required
North Dakota Legal permit required to carry conceal
Ohio Legal No permit required
Oklahoma Legal No permit required
Oregon Legal No permit required
Pennsylvania Legal except
Prohibited in Philadelphia
No permit required
Rhode Island Illegal n/a
South Carolina Legal No permit required
South Dakota Legal No permit required
Tennessee Legal No permit required
Texas Legal No permit required
Utah Legal No permit required
Vermont Legal No permit required
Virginia Legal No permit required
Washington Legal No permit required
West Virginia Legal No permit required
Wisconsin Legal with CCW license
Click here to apply CCW
permit required
Wyoming Legal No permit required

Liability Disclaimer

Absolutely no sales to minors under 18 years of age or any person who falls in one of the following categories: convicted of a crime punishable by imprisonment for any terms; fugitive from Justice (requires interstate flight to avoid prosecution or testimony in a criminal case); drug users or addicts (may be shown by recent conviction for use, recent possession of drugs, or recent arrest for use of drugs, or positive drug tests); aliens illegally or unlawfully within the US or those lawfully admitted in non-immigrant status (i.e. aliens without permanent residence status); mental defectives or persons committed to a mental institution; formally renounced US citizenship; dishonorably discharged from the military; subject to a court order prohibiting harassing, stalking, or threatening of an intimate partner or child of an intimate partner or placing such persons in reasonable fear of bodily injury; and convicted of a misdemeanor crime of domestic violence. It is the responsibility of the buyer and not the seller (tactical-survivalist.com) to ascertain and obey all applicable federal, state and local laws in regard to the possession and use of all products on this site. By placing an order the buyer represents that he/she is of legal age, he/she does not fall in one of the above categories and that the products will be used in a legal manner. Tactical-Survivalist.com will not assume any liability for the use of these products and recommend the buyer become familiar with the laws in their city, state, province, that regulates the use and possession of these products. Consult your local and state authority before ordering if you are in doubt.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6939129829407 847 0.8498 0


No Amazon API Requests Made.


App Debug - Total Time 1.6939129829407 seconds

Number Time From Start Name Description
1 0.4372718334198 Initialise Initialise FSB Function
2 0.44432091712952 App Controller Start Start of the App controller (called before the controller of every page)
3 0.57723188400269 App Controller End End of the App controller (called before the controller of every page)
4 0.57739496231079 Category Start Start of the category controller
5 0.57739782333374 Before Get Category Before getting the category information
6 0.58255887031555 After Get Category After getting the category information
7 0.58256101608276 Before Get Category List Before getting the updated category list
8 0.58269596099854 Start of getCategoryListByGroup Function Before first category groups query
9 0.58284902572632 After initial query Before first category groups query
10 0.58285093307495 Get Category List for Group Before the call to getCategoryList function
11 0.58285403251648 Start of GetCategoryList function Start of the function
12 0.58285999298096 Before getting categories Query to get specific category list
13 0.58342885971069 After getting categories Query to get specific category list
14 0.58342981338501 Before getting category custom Before call to function getCategoryCustom
15 0.58520293235779 After getting category custom After call to function getCategoryCustom
16 0.58520603179932 Before getting category custom Before call to function getCategoryCustom
17 0.5957658290863 After getting category custom After call to function getCategoryCustom
18 0.59576988220215 Before getting category custom Before call to function getCategoryCustom
19 0.60133290290833 After getting category custom After call to function getCategoryCustom
20 0.60133481025696 Before getting category custom Before call to function getCategoryCustom
21 0.60544085502625 After getting category custom After call to function getCategoryCustom
22 0.60544395446777 End of GetCategoryList function End of the function
23 0.60545182228088 Get Category List for Group Before the call to getCategoryList function
24 0.60545492172241 Start of GetCategoryList function Start of the function
25 0.60545682907104 Before getting categories Query to get specific category list
26 0.60585379600525 After getting categories Query to get specific category list
27 0.60585498809814 Before getting category custom Before call to function getCategoryCustom
28 0.61142301559448 After getting category custom After call to function getCategoryCustom
29 0.61142587661743 Before getting category custom Before call to function getCategoryCustom
30 0.62214589118958 After getting category custom After call to function getCategoryCustom
31 0.62214779853821 End of GetCategoryList function End of the function
32 0.62215399742126 Get Category List for Group Before the call to getCategoryList function
33 0.62215685844421 Start of GetCategoryList function Start of the function
34 0.62216091156006 Before getting categories Query to get specific category list
35 0.62294983863831 After getting categories Query to get specific category list
36 0.6229510307312 Before getting category custom Before call to function getCategoryCustom
37 0.63206100463867 After getting category custom After call to function getCategoryCustom
38 0.63206386566162 Before getting category custom Before call to function getCategoryCustom
39 0.64926695823669 After getting category custom After call to function getCategoryCustom
40 0.64926886558533 Before getting category custom Before call to function getCategoryCustom
41 0.65514588356018 After getting category custom After call to function getCategoryCustom
42 0.65514898300171 Before getting category custom Before call to function getCategoryCustom
43 0.66106200218201 After getting category custom After call to function getCategoryCustom
44 0.66106390953064 Before getting category custom Before call to function getCategoryCustom
45 0.66726303100586 After getting category custom After call to function getCategoryCustom
46 0.66726589202881 Before getting category custom Before call to function getCategoryCustom
47 0.68896484375 After getting category custom After call to function getCategoryCustom
48 0.68896794319153 Before getting category custom Before call to function getCategoryCustom
49 0.69308590888977 After getting category custom After call to function getCategoryCustom
50 0.6930890083313 Before getting category custom Before call to function getCategoryCustom
51 0.69770002365112 After getting category custom After call to function getCategoryCustom
52 0.69770193099976 End of GetCategoryList function End of the function
53 0.69771480560303 Get Category List for Group Before the call to getCategoryList function
54 0.69771695137024 Start of GetCategoryList function Start of the function
55 0.69771981239319 Before getting categories Query to get specific category list
56 0.69814395904541 After getting categories Query to get specific category list
57 0.69814586639404 Before getting category custom Before call to function getCategoryCustom
58 0.70039987564087 After getting category custom After call to function getCategoryCustom
59 0.70040202140808 Before getting sub category list Before call to recursive function getCategoryList
60 0.70040488243103 Start of GetCategoryList function Start of the function
61 0.70040702819824 Before getting categories Query to get specific category list
62 0.70068597793579 After getting sub category list After call to recursive function getCategoryList
63 0.70068788528442 Before getting category custom Before call to function getCategoryCustom
64 0.70302391052246 After getting category custom After call to function getCategoryCustom
65 0.70302581787109 End of GetCategoryList function End of the function
66 0.70303392410278 Get Category List for Group Before the call to getCategoryList function
67 0.7030348777771 Start of GetCategoryList function Start of the function
68 0.70303797721863 Before getting categories Query to get specific category list
69 0.70333480834961 After getting categories Query to get specific category list
70 0.7033360004425 Before getting category custom Before call to function getCategoryCustom
71 0.70829892158508 After getting category custom After call to function getCategoryCustom
72 0.70830082893372 End of GetCategoryList function End of the function
73 0.70830702781677 End of getCategoryListByGroup Function Before return()
74 0.70831489562988 After Get Category List After getting the updated category list
75 0.7083158493042 Before Category Images Before getting the category images
76 0.70843195915222 After Category Images After getting the category images
77 0.70885396003723 Before Sub Category Check Before checking for sub category or products category
78 0.7091269493103 Before Category Products Controller Before loading the category products controller
79 0.70928597450256 Start Category Products Start of Category Products Controller
80 0.70931196212769 After Pagination Options After pagination options in Category Products Controller
81 0.7098708152771 After Cache After Cache checking in Category Products Controller
82 0.79316687583923 After Filter Options After getting filter options and SQL in Category Products Controller
83 0.79421591758728 After Counting Products After counting products in the Category Products Controller
84 0.79438400268555 After Counting Bundles After counting bundles in the Category Products Controller
85 0.7945408821106 After Counting Products After counting products in the Category Products Controller
86 0.79602694511414 After Getting Products After getting products and bundles in the Category Products Controller
87 0.7961118221283 After Pagination Links After getting pagination listing links in the Category Products Controller
88 0.79611396789551 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
89 0.87854480743408 After Getting Product Details After getting full product details in the Category Products Controller
90 0.88346290588379 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
91 0.88482689857483 App_after Controller Start Start of the App_after controller (called after the controller of every page)
92 0.88493585586548 Before Get Options Before the call to getOptions in the tpl class
93 1.3207290172577 After Get Options After the call to getOptions in the tpl class
94 1.3211579322815 App_after Controller End End of the App_after controller (called after the controller of every page)
95 1.3211698532104 Before Smarty Before passing everything over to Smarty in the Category Products Controller
96 1.6938779354095 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
97 1.6938829421997 Finalizing debug Before the debug is output to the page.
98 1.6939120292664 End of App This is the end of the app logging, final timestamp


Query Debug - 847 Database Queries. Total time 0.8498 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00050091743469238
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00019693374633789
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015687942504883
SELECT * FROM `bad_bots`
5 0.0005 0.00046992301940918
SELECT parameter, value FROM parameters
6 0.0002 0.0001530647277832
SET time_zone = 'Europe/London'
7 0.0003 0.00031208992004395
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00016188621520996
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011086463928223
delete from cachefiles
10 0.0002 0.00022387504577637
SELECT id FROM pages WHERE pagename = 'stun-guns' LIMIT 1
11 0.0002 0.00022101402282715
SELECT id FROM products WHERE pagename = 'stun-guns' AND hidden = 0 LIMIT 1
12 0.0001 0.0001220703125
SELECT id FROM ebay_products WHERE pagename = 'stun-guns'
13 0.0002 0.00017595291137695
SELECT id FROM categories WHERE pagename = 'stun-guns' LIMIT 1
14 0.0692 0.069164991378784
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0096 0.0096390247344971
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0003 0.0002739429473877
SELECT * FROM pages WHERE pagename = 'stun-guns'
17 0.0053 0.0052950382232666
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00038313865661621
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.00017189979553223
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00018596649169922
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00021719932556152
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '84'
24 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '357'
33 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '379'
34 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '401'
35 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '450'
36 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '43'
42 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
43 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '107'
48 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '108'
49 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '133'
51 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '217'
53 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
54 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '271'
56 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '286'
57 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '364'
64 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '369'
66 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0003 0.00026893615722656
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '90'
72 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '414'
73 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '119'
74 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
75 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '149'
76 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '150'
77 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '162'
79 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '164'
80 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '167'
81 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '180'
82 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '268'
85 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '411'
86 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
87 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '413'
88 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '409'
89 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
90 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '351'
92 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '358'
93 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '360'
94 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '370'
97 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '377'
98 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '386'
99 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '408'
100 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '423'
104 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '428'
106 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '432'
107 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '433'
108 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '436'
109 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '437'
110 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '464'
112 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '74'
114 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '145'
116 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '156'
117 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '407'
118 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '316'
121 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '334'
123 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '367'
124 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '387'
125 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '42'
130 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
132 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
133 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '102'
134 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '62'
140 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '317'
146 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '343'
148 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
152 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '349'
153 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '392'
155 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '393'
156 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '394'
157 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '421'
160 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '426'
161 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '430'
162 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '441'
167 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '451'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '453'
169 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '146'
171 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '158'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '293'
174 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '417'
176 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '181'
179 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '299'
181 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '300'
182 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '383'
183 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '385'
184 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '442'
186 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0002 0.00024318695068359
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '134'
189 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '248'
193 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '115'
200 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '151'
203 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '199'
204 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '200'
205 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '304'
206 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
207 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '350'
209 0.0001 0.00014376640319824
SELECT * FROM pages WHERE id = '378'
210 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '425'
212 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '443'
213 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '444'
214 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '445'
215 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '446'
216 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '447'
217 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '448'
218 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '455'
219 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '456'
220 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '460'
222 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '462'
223 0.0001 0.00014400482177734
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '182'
226 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '238'
227 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '240'
228 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '242'
229 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '252'
230 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '253'
231 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '262'
232 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '267'
233 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '420'
234 0.0001 0.00013494491577148
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00011777877807617
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0013 0.0013370513916016
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00032877922058105
SELECT * FROM categories WHERE pagename = 'stun-guns'
239 0.0007 0.00074315071105957
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
240 0.0001 0.00011801719665527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 84
241 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '84'
242 0.0007 0.00069999694824219
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 
243 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 (84)
				  AND p.disabled = 0 
244 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
245 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
246 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '84'
247 0.0007 0.00074195861816406
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (84) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
248 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '409450' ORDER BY sortorder ASC
249 0.0001 0.00010800361633301
SELECT * FROM categoryimages WHERE category_id = 84
250 0.0001 0.00011801719665527
SELECT * FROM categorygroups WHERE id = '17'
251 0.0007 0.00071310997009277
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 = '84'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
252 0.0001 0.00012803077697754
SELECT parent_id FROM categories WHERE id = '84'
253 0.0001 0.00011682510375977
SELECT parent_id FROM categories WHERE id = '84'
254 0.0001 0.0001380443572998
SELECT * FROM categorygroups ORDER BY sortorder ASC
255 0.0005 0.00047612190246582
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
256 0.0004 0.00042605400085449
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
257 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '49'
258 0.0004 0.00043106079101562
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 
259 0.0001 0.00013995170593262
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
260 0.0001 0.00014185905456543
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
261 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
262 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '1'
263 0.0030 0.0030078887939453
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
264 0.0003 0.00025582313537598
SELECT id FROM categories WHERE parent_id = '50'
265 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '96'
266 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '97'
267 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '111'
268 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
269 0.0057 0.0057358741760254
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 
270 0.0002 0.00017189979553223
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 
271 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 (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
272 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
273 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
274 0.0023 0.0023069381713867
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
275 0.0003 0.00025510787963867
SELECT id FROM categories WHERE parent_id = '80'
276 0.0023 0.0023159980773926
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 
277 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
278 0.0002 0.00016188621520996
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 
279 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
280 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
281 0.0012 0.0011520385742188
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
282 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '51'
283 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '101'
284 0.0018 0.001774787902832
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 
285 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 (101,51)
				  AND p.disabled = 0 
286 0.0001 0.00014781951904297
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 
287 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
288 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
289 0.0004 0.00036787986755371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
290 0.0023 0.0023031234741211
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
291 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '30'
292 0.0023 0.0022990703582764
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 
293 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 (30)
				  AND p.disabled = 0 
294 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
295 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
296 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '2'
297 0.0048 0.0048110485076904
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
298 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '61'
299 0.0049 0.0049412250518799
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 
300 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 (61)
				  AND p.disabled = 0 
301 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
302 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
303 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
304 0.0006 0.00060415267944336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
305 0.0041 0.0040619373321533
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 64
306 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
307 0.0041 0.0040879249572754
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 
308 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
309 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
310 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
311 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
312 0.0081 0.0080609321594238
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
313 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '65'
314 0.0081 0.0081241130828857
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 
315 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
316 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
317 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
318 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '10'
319 0.0024 0.0024449825286865
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
320 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '81'
321 0.0025 0.0024831295013428
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 
322 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
323 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
324 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
325 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
326 0.0025 0.0024540424346924
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
327 0.0003 0.00025582313537598
SELECT id FROM categories WHERE parent_id = '31'
328 0.0025 0.0025031566619873
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 
329 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
330 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 (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
331 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
332 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
333 0.0022 0.0022270679473877
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
334 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '66'
335 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '131'
336 0.0028 0.002810001373291
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 
337 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
338 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
339 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
340 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
341 0.0094 0.0094459056854248
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
342 0.0003 0.00029206275939941
SELECT id FROM categories WHERE parent_id = '34'
343 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '94'
344 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '98'
345 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '99'
346 0.0002 0.00019383430480957
SELECT id FROM categories WHERE parent_id = '110'
347 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '130'
348 0.0102 0.010179042816162
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 
349 0.0002 0.00017595291137695
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 
350 0.0002 0.0001528263092041
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 
351 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
352 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
353 0.0016 0.0015501976013184
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
354 0.0003 0.00025415420532227
SELECT id FROM categories WHERE parent_id = '32'
355 0.0016 0.0015909671783447
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 
356 0.0002 0.00016880035400391
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 
357 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
358 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
359 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
360 0.0018 0.0018351078033447
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
361 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '89'
362 0.0019 0.0018560886383057
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 
363 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
364 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
365 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
366 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
367 0.0004 0.00040006637573242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
368 0.0007 0.00065898895263672
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
369 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '84'
370 0.0007 0.00067496299743652
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
371 0.0002 0.00015902519226074
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 
372 0.0001 0.00014519691467285
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
373 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
374 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
375 0.0003 0.00026798248291016
SELECT * FROM categories WHERE parent_id = '84'  AND hidden = 0 ORDER BY sortorder ASC
376 0.0007 0.0007169246673584
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
377 0.0002 0.00022315979003906
SELECT id FROM categories WHERE parent_id = '90'
378 0.0007 0.00073790550231934
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 
379 0.0001 0.00014281272888184
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
380 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
381 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
382 0.0001 0.00012993812561035
SELECT * FROM categorygroups WHERE id = '17'
383 0.0003 0.00028395652770996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
384 0.0020 0.0020160675048828
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
385 0.0002 0.00023818016052246
SELECT id FROM categories WHERE parent_id = '92'
386 0.0020 0.0020380020141602
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 
387 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
388 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
389 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
390 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
391 0.0001 0.00010585784912109
SELECT * FROM categoryimages WHERE category_id = 84
392 0.0002 0.00016903877258301
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
393 0.0003 0.00025796890258789
SELECT * FROM categories WHERE parent_id = '84'
394 0.0332 0.033236026763916
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
395 0.0078 0.0077681541442871
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
396 0.0003 0.00034403800964355
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
397 0.0337 0.033672094345093
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
398 0.0062 0.0062267780303955
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
399 0.0003 0.00030398368835449
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
400 0.0008 0.0008389949798584
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 = 84
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
401 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 84
		AND c.prod_type = 'ebay'
		AND hide = 1
402 0.0001 0.00014400482177734
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 = 84
			AND p.disabled = 0
			
			AND 1 = 1
403 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 84
		AND c.prod_type = 'custom'
		AND hide = 1
404 0.0014 0.0013978481292725
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 = 84
			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 = 84
		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 = 84
		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 = 84
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
405 0.0002 0.00024199485778809
SELECT * FROM products WHERE id = '409450'
406 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '409450' ORDER BY sortorder ASC
407 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '409450'
408 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '409450'
409 0.0032 0.0032188892364502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409450' AND a.name = n.originalname
410 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '409450' AND merchantid = 'ATVPDKIKX0DER'
411 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '409450' AND price > 0
                ORDER BY price ASC LIMIT 1
412 0.0002 0.00018000602722168
SELECT * FROM productoffers
                WHERE product_id = 409450
                ORDER BY price ASC LIMIT 1
413 0.0002 0.00022292137145996
SELECT value FROM productattributes
                WHERE product_id = '409450'
                AND name = 'ListPriceAmount'
414 0.0001 0.00013303756713867
UPDATE products SET price = '2398' WHERE id = '409450'
415 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '406132'
416 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '406132' ORDER BY sortorder ASC
417 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '406132'
418 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '406132'
419 0.0023 0.0022821426391602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406132' AND a.name = n.originalname
420 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '406132' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00020718574523926
SELECT * FROM productoffers
                WHERE product_id = '406132' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '406132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.0001220703125
UPDATE products SET price = '1598' WHERE id = '406132'
424 0.0002 0.00019407272338867
SELECT * FROM products WHERE id = '406078'
425 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '406078' ORDER BY sortorder ASC
426 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '406078'
427 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406078'
428 0.0029 0.0028550624847412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406078' AND a.name = n.originalname
429 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '406078' AND merchantid = 'ATVPDKIKX0DER'
430 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '406078' AND price > 0
                ORDER BY price ASC LIMIT 1
431 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '406078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
432 0.0001 0.00011920928955078
UPDATE products SET price = '998' WHERE id = '406078'
433 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '406148'
434 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '406148' ORDER BY sortorder ASC
435 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '406148'
436 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '406148'
437 0.0021 0.0021288394927979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406148' AND a.name = n.originalname
438 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '406148' AND merchantid = 'ATVPDKIKX0DER'
439 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '406148' AND price > 0
                ORDER BY price ASC LIMIT 1
440 0.0002 0.00017118453979492
SELECT * FROM productoffers
                WHERE product_id = 406148
                ORDER BY price ASC LIMIT 1
441 0.0002 0.00022196769714355
SELECT value FROM productattributes
                WHERE product_id = '406148'
                AND name = 'ListPriceAmount'
442 0.0001 0.00012016296386719
UPDATE products SET price = '1298' WHERE id = '406148'
443 0.0002 0.0001981258392334
SELECT * FROM products WHERE id = '406142'
444 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '406142' ORDER BY sortorder ASC
445 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '406142'
446 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '406142'
447 0.0020 0.0019900798797607
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406142' AND a.name = n.originalname
448 0.0002 0.00017285346984863
SELECT * FROM productoffers WHERE product_id = '406142' AND merchantid = 'ATVPDKIKX0DER'
449 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '406142' AND price > 0
                ORDER BY price ASC LIMIT 1
450 0.0002 0.00016903877258301
SELECT * FROM productoffers
                WHERE product_id = 406142
                ORDER BY price ASC LIMIT 1
451 0.0002 0.00020599365234375
SELECT value FROM productattributes
                WHERE product_id = '406142'
                AND name = 'ListPriceAmount'
452 0.0001 0.00013089179992676
UPDATE products SET price = '2298' WHERE id = '406142'
453 0.0002 0.00019693374633789
SELECT * FROM products WHERE id = '406135'
454 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '406135' ORDER BY sortorder ASC
455 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '406135'
456 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406135'
457 0.0021 0.0021481513977051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406135' AND a.name = n.originalname
458 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406135' AND merchantid = 'ATVPDKIKX0DER'
459 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '406135' AND price > 0
                ORDER BY price ASC LIMIT 1
460 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '406135' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461 0.0001 0.00012898445129395
UPDATE products SET price = '1098' WHERE id = '406135'
462 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '406137'
463 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '406137' ORDER BY sortorder ASC
464 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '406137'
465 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406137'
466 0.0023 0.0023388862609863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406137' AND a.name = n.originalname
467 0.0002 0.00017619132995605
SELECT * FROM productoffers WHERE product_id = '406137' AND merchantid = 'ATVPDKIKX0DER'
468 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '406137' AND price > 0
                ORDER BY price ASC LIMIT 1
469 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 406137
                ORDER BY price ASC LIMIT 1
470 0.0002 0.00022387504577637
SELECT value FROM productattributes
                WHERE product_id = '406137'
                AND name = 'ListPriceAmount'
471 0.0001 0.00012087821960449
UPDATE products SET price = '998' WHERE id = '406137'
472 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = '406138'
473 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '406138' ORDER BY sortorder ASC
474 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406138'
475 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406138'
476 0.0029 0.0028560161590576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406138' AND a.name = n.originalname
477 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '406138' AND merchantid = 'ATVPDKIKX0DER'
478 0.0002 0.00017714500427246
SELECT * FROM productoffers
                WHERE product_id = '406138' AND price > 0
                ORDER BY price ASC LIMIT 1
479 0.0002 0.00016689300537109
SELECT * FROM productoffers
                WHERE product_id = 406138
                ORDER BY price ASC LIMIT 1
480 0.0002 0.00022101402282715
SELECT value FROM productattributes
                WHERE product_id = '406138'
                AND name = 'ListPriceAmount'
481 0.0001 0.0001218318939209
UPDATE products SET price = '1598' WHERE id = '406138'
482 0.0002 0.00020813941955566
SELECT * FROM products WHERE id = '406081'
483 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '406081' ORDER BY sortorder ASC
484 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406081'
485 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406081'
486 0.0022 0.0022480487823486
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406081' AND a.name = n.originalname
487 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '406081' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '406081' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '406081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00012898445129395
UPDATE products SET price = '1398' WHERE id = '406081'
491 0.0002 0.00020694732666016
SELECT * FROM products WHERE id = '406079'
492 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '406079' ORDER BY sortorder ASC
493 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '406079'
494 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406079'
495 0.0032 0.0032148361206055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406079' AND a.name = n.originalname
496 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '406079' AND merchantid = 'ATVPDKIKX0DER'
497 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '406079' AND price > 0
                ORDER BY price ASC LIMIT 1
498 0.0002 0.00016117095947266
SELECT * FROM productoffers
                WHERE product_id = 406079
                ORDER BY price ASC LIMIT 1
499 0.0003 0.00028204917907715
SELECT value FROM productattributes
                WHERE product_id = '406079'
                AND name = 'ListPriceAmount'
500 0.0001 0.00012087821960449
UPDATE products SET price = '998' WHERE id = '406079'
501 0.0002 0.00019693374633789
SELECT * FROM products WHERE id = '406082'
502 0.0002 0.00020980834960938
SELECT * FROM productimages WHERE product_id = '406082' ORDER BY sortorder ASC
503 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '406082'
504 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406082'
505 0.0027 0.0027329921722412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406082' AND a.name = n.originalname
506 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '406082' AND merchantid = 'ATVPDKIKX0DER'
507 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '406082' AND price > 0
                ORDER BY price ASC LIMIT 1
508 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '406082' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 0.00011897087097168
UPDATE products SET price = '1098' WHERE id = '406082'
510 0.0002 0.0002129077911377
SELECT * FROM products WHERE id = '406077'
511 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '406077' ORDER BY sortorder ASC
512 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '406077'
513 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406077'
514 0.0023 0.0023319721221924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406077' AND a.name = n.originalname
515 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '406077' AND merchantid = 'ATVPDKIKX0DER'
516 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '406077' AND price > 0
                ORDER BY price ASC LIMIT 1
517 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '406077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
518 0.0001 0.00011801719665527
UPDATE products SET price = '1098' WHERE id = '406077'
519 0.0002 0.00020694732666016
SELECT * FROM products WHERE id = '406080'
520 0.0002 0.00020217895507812
SELECT * FROM productimages WHERE product_id = '406080' ORDER BY sortorder ASC
521 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406080'
522 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '406080'
523 0.0021 0.0020909309387207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406080' AND a.name = n.originalname
524 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '406080' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '406080' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '406080' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00011801719665527
UPDATE products SET price = '1298' WHERE id = '406080'
528 0.0002 0.00020885467529297
SELECT * FROM products WHERE id = '406134'
529 0.0002 0.00020718574523926
SELECT * FROM productimages WHERE product_id = '406134' ORDER BY sortorder ASC
530 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406134'
531 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406134'
532 0.0032 0.0032179355621338
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406134' AND a.name = n.originalname
533 0.0002 0.00017309188842773
SELECT * FROM productoffers WHERE product_id = '406134' AND merchantid = 'ATVPDKIKX0DER'
534 0.0002 0.00017380714416504
SELECT * FROM productoffers
                WHERE product_id = '406134' AND price > 0
                ORDER BY price ASC LIMIT 1
535 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 406134
                ORDER BY price ASC LIMIT 1
536 0.0002 0.0002281665802002
SELECT value FROM productattributes
                WHERE product_id = '406134'
                AND name = 'ListPriceAmount'
537 0.0001 0.00011897087097168
UPDATE products SET price = '998' WHERE id = '406134'
538 0.0002 0.00020384788513184
SELECT * FROM products WHERE id = '260504'
539 0.0002 0.00018620491027832
SELECT * FROM productimages WHERE product_id = '260504' ORDER BY sortorder ASC
540 0.0003 0.00026416778564453
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
541 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '260504'
542 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '260504'
543 0.0002 0.00023603439331055
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
544 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     = '260504'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
545 0.0002 0.0001988410949707
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
546 0.0008 0.0008089542388916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '260504' AND a.name = n.originalname
547 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '260504' AND merchantid = 'ATVPDKIKX0DER'
548 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '260504' AND price > 0
                ORDER BY price ASC LIMIT 1
549 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 260504
                ORDER BY price ASC LIMIT 1
550 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '260504'
                AND name = 'ListPriceAmount'
551 0.0002 0.00022411346435547
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
552 0.0003 0.00026297569274902
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
553 0.0002 0.00019502639770508
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
554 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '260504' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
555 0.0001 0.00011897087097168
UPDATE products SET price = '2802' WHERE id = '260504'
556 0.0003 0.00031709671020508
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
557 0.0002 0.00021791458129883
SELECT * FROM products WHERE parent_id = '260504'
558 0.0002 0.00022006034851074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411008' AND a.name = n.originalname
559 0.0002 0.00017189979553223
SELECT * FROM productoffers WHERE product_id = '411008' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '411008' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '406156'
562 0.0002 0.00016403198242188
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
563 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '406156'
564 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406156'
565 0.0032 0.0031640529632568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
566 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
567 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
568 0.0002 0.00015783309936523
SELECT * FROM productoffers
                WHERE product_id = 406156
                ORDER BY price ASC LIMIT 1
569 0.0003 0.00027203559875488
SELECT value FROM productattributes
                WHERE product_id = '406156'
                AND name = 'ListPriceAmount'
570 0.0001 0.0001220703125
UPDATE products SET price = '1017' WHERE id = '406156'
571 0.0002 0.00020813941955566
SELECT * FROM products WHERE id = '406146'
572 0.0002 0.00016903877258301
SELECT * FROM productimages WHERE product_id = '406146' ORDER BY sortorder ASC
573 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '406146'
574 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '406146'
575 0.0031 0.0030639171600342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406146' AND a.name = n.originalname
576 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '406146' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '406146' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0004 0.00043511390686035
SELECT value FROM productattributes WHERE product_id = '406146' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
579 0.0001 0.00011897087097168
UPDATE products SET price = '1199' WHERE id = '406146'
580 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '248726'
581 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '248726' ORDER BY sortorder ASC
582 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '248726'
583 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '248726'
584 0.0026 0.0025660991668701
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '248726' AND a.name = n.originalname
585 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '248726' AND merchantid = 'ATVPDKIKX0DER'
586 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '248726' AND price > 0
                ORDER BY price ASC LIMIT 1
587 0.0002 0.0001671314239502
SELECT * FROM productoffers
                WHERE product_id = 248726
                ORDER BY price ASC LIMIT 1
588 0.0003 0.0002601146697998
SELECT value FROM productattributes
                WHERE product_id = '248726'
                AND name = 'ListPriceAmount'
589 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '248726' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
590 0.0003 0.0003049373626709
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '409450' ORDER BY timestamp DESC
591 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406132' ORDER BY timestamp DESC
592 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406078' ORDER BY timestamp DESC
593 0.0002 0.00024986267089844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406148' ORDER BY timestamp DESC
594 0.0003 0.00026297569274902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406142' ORDER BY timestamp DESC
595 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406135' ORDER BY timestamp DESC
596 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406137' ORDER BY timestamp DESC
597 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406138' ORDER BY timestamp DESC
598 0.0003 0.00026297569274902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406081' ORDER BY timestamp DESC
599 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406079' ORDER BY timestamp DESC
600 0.0003 0.00025177001953125
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406082' ORDER BY timestamp DESC
601 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406077' ORDER BY timestamp DESC
602 0.0003 0.00026988983154297
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406080' ORDER BY timestamp DESC
603 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406134' ORDER BY timestamp DESC
604 0.0003 0.00025105476379395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '260504' ORDER BY timestamp DESC
605 0.0003 0.0002589225769043
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406156' ORDER BY timestamp DESC
606 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406146' ORDER BY timestamp DESC
607 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '248726' ORDER BY timestamp DESC
608 0.0002 0.00016403198242188
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 = 84
		AND c.prod_type = 'ebay'
		AND hide = 1
609 0.0001 0.00013184547424316
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
610 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
611 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
612 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
613 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
614 0.0001 0.00013303756713867
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
615 0.0002 0.00016188621520996
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
616 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 2
617 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 4
618 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 12
619 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 10
620 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 7
621 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = 18
622 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 28
623 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 13
624 0.0001 0.00013208389282227
SELECT * FROM pages WHERE id = 3
625 0.0431 0.043123960494995
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
626 0.0002 0.00024604797363281
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:1560753815;s:8:\"products\";a:6:{i:18;s:6:\"127345\";i:19;s:6:\"131163\";i:2;s:6:\"290575\";i:3;s:6:\"171938\";i:5;s:6:\"412927\";i:7;s:6:\"183732\";}}' WHERE id = '175'
627 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (127345,131163,290575,171938,412927,183732) ORDER BY FIELD(id, 127345,131163,290575,171938,412927,183732 )
628 0.0003 0.0003209114074707
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
629 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '127345'
630 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '127345'
631 0.0026 0.0026180744171143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
632 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
633 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
634 0.0004 0.00039815902709961
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
635 0.0001 0.00012397766113281
UPDATE products SET price = '21963' WHERE id = '127345'
636 0.0002 0.00021815299987793
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
637 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '131163'
638 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '131163'
639 0.0026 0.0025539398193359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
640 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
641 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
642 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
643 0.0001 0.00011992454528809
UPDATE products SET price = '20362' WHERE id = '131163'
644 0.0006 0.00057601928710938
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
645 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '290575'
646 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '290575'
647 0.0034 0.0033760070800781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
648 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
649 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
650 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
651 0.0001 0.0001218318939209
UPDATE products SET price = '549500' WHERE id = '290575'
652 0.0006 0.00060701370239258
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
653 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '171938'
654 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '171938'
655 0.0025 0.0025408267974854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
656 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
657 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
658 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
659 0.0001 0.00011992454528809
UPDATE products SET price = '389500' WHERE id = '171938'
660 0.0003 0.00028610229492188
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
661 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '412927'
662 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
663 0.0036 0.0036239624023438
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
664 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
665 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
666 0.0005 0.00048494338989258
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
667 0.0001 0.00012397766113281
UPDATE products SET price = '199900' WHERE id = '412927'
668 0.0002 0.0001671314239502
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
669 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '183732'
670 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '183732'
671 0.0026 0.0026371479034424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
672 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0001 0.0001220703125
UPDATE products SET price = '38249' WHERE id = '183732'
676 0.0429 0.042873859405518
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
677 0.0002 0.00022697448730469
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:1560753815;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:5;s:6:\"412927\";i:13;s:6:\"407831\";i:16;s:6:\"407620\";i:19;s:6:\"131163\";i:23;s:6:\"400044\";}}' WHERE id = '177'
678 0.0005 0.00045013427734375
SELECT * FROM products WHERE id IN (398315,412927,407831,407620,131163,400044) ORDER BY FIELD(id, 398315,412927,407831,407620,131163,400044 )
679 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
680 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '398315'
681 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '398315'
682 0.0025 0.0025122165679932
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
683 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
684 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
685 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
686 0.0001 0.0001218318939209
UPDATE products SET price = '1999' WHERE id = '398315'
687 0.0003 0.0002598762512207
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
688 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '412927'
689 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '412927'
690 0.0036 0.0036361217498779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
691 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
692 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
693 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
694 0.0001 0.00013184547424316
UPDATE products SET price = '199900' WHERE id = '412927'
695 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
696 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '407831'
697 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407831'
698 0.0034 0.0033900737762451
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
699 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
700 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
701 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
702 0.0001 0.00012898445129395
UPDATE products SET price = '1293' WHERE id = '407831'
703 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
704 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '407620'
705 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407620'
706 0.0023 0.0022521018981934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
707 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
708 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
709 0.0004 0.00036787986755371
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
710 0.0001 0.00011897087097168
UPDATE products SET price = '20323' WHERE id = '407620'
711 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
712 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '131163'
713 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '131163'
714 0.0026 0.0025639533996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
715 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
716 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
717 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
718 0.0001 0.00011897087097168
UPDATE products SET price = '20362' WHERE id = '131163'
719 0.0002 0.00020718574523926
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
720 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '400044'
721 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '400044'
722 0.0028 0.002810001373291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
723 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
724 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
725 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
726 0.0001 0.00011801719665527
UPDATE products SET price = '16091' WHERE id = '400044'
727 0.1075 0.10751509666443
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
728 0.0003 0.00025200843811035
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:1560753815;s:8:\"products\";a:6:{i:4;s:6:\"410588\";i:6;s:6:\"409759\";i:9;s:6:\"103845\";i:14;s:6:\"414188\";i:15;s:6:\"406758\";i:20;s:6:\"410949\";}}' WHERE id = '181'
729 0.0005 0.00046896934509277
SELECT * FROM products WHERE id IN (410588,409759,103845,414188,406758,410949) ORDER BY FIELD(id, 410588,409759,103845,414188,406758,410949 )
730 0.0003 0.00025415420532227
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
731 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '410588'
732 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '410588'
733 0.0025 0.002504825592041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
734 0.0002 0.00020718574523926
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
735 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
736 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
737 0.0014 0.0013968944549561
UPDATE products SET price = '269999' WHERE id = '410588'
738 0.0003 0.00025582313537598
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
739 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '409759'
740 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '409759'
741 0.0033 0.003338098526001
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
742 0.0002 0.0002138614654541
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
743 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
744 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
745 0.0024 0.0023739337921143
UPDATE products SET price = '229000' WHERE id = '409759'
746 0.0003 0.00025391578674316
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
747 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '103845'
748 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '103845'
749 0.0030 0.0030369758605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
750 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
751 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
752 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
753 0.0016 0.0016410350799561
UPDATE products SET price = '11900' WHERE id = '103845'
754 0.0003 0.00033092498779297
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
755 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '414188'
756 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '414188'
757 0.0031 0.0030529499053955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
758 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
759 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
760 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
761 0.0001 0.00013995170593262
UPDATE products SET price = '9999' WHERE id = '414188'
762 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
763 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '406758'
764 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '406758'
765 0.0031 0.0031299591064453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
766 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
767 0.0002 0.00021481513977051
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
768 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
769 0.0014 0.0013871192932129
UPDATE products SET price = '2694' WHERE id = '406758'
770 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
771 0.0002 0.00024604797363281
SELECT * FROM product_image_select WHERE product_id = '410949'
772 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '410949'
773 0.0033 0.0032510757446289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
774 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
775 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
776 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
777 0.0013 0.0013360977172852
UPDATE products SET price = '47995' WHERE id = '410949'
778 0.1111 0.11107707023621
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
779 0.0002 0.00024509429931641
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:1560753815;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:6;s:6:\"409759\";i:20;s:6:\"410949\";i:5;s:6:\"412927\";i:9;s:6:\"103845\";i:10;s:6:\"370121\";}}' WHERE id = '183'
780 0.0004 0.00043702125549316
SELECT * FROM products WHERE id IN (290575,409759,410949,412927,103845,370121) ORDER BY FIELD(id, 290575,409759,410949,412927,103845,370121 )
781 0.0006 0.00059413909912109
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
782 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '290575'
783 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '290575'
784 0.0035 0.0035200119018555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
785 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
786 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
787 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
788 0.0001 0.00012493133544922
UPDATE products SET price = '549500' WHERE id = '290575'
789 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
790 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '409759'
791 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '409759'
792 0.0029 0.0028700828552246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
793 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
794 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
795 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
796 0.0001 0.00012111663818359
UPDATE products SET price = '229000' WHERE id = '409759'
797 0.0002 0.00017094612121582
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
798 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '410949'
799 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '410949'
800 0.0027 0.0026829242706299
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
801 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
802 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
803 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
804 0.0001 0.00011897087097168
UPDATE products SET price = '47995' WHERE id = '410949'
805 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
806 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '412927'
807 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
808 0.0036 0.0036311149597168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
809 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
810 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
811 0.0004 0.00044679641723633
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
812 0.0001 0.00013279914855957
UPDATE products SET price = '199900' WHERE id = '412927'
813 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
814 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '103845'
815 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '103845'
816 0.0024 0.0024361610412598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
817 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
818 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
819 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
820 0.0001 0.00012111663818359
UPDATE products SET price = '11900' WHERE id = '103845'
821 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
822 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '370121'
823 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '370121'
824 0.0028 0.0027759075164795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
825 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
826 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
827 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
828 0.0001 0.00011992454528809
UPDATE products SET price = '9899' WHERE id = '370121'
829 0.0004 0.00041317939758301
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
830 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
832 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
833 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
834 0.0004 0.00039505958557129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
835 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
836 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
837 0.0009 0.00092983245849609
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
838 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
839 0.0003 0.00027799606323242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
840 0.0004 0.00041604042053223
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
841 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
842 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
843 0.0001 0.00014185905456543
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
844 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
845 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
846 0.0003 0.00034093856811523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
847 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'