Home /
Search results for: 'order+by+1000/*"+and+"x"="y'

Search results for 'order+by+1000/*"+and+"x"="y'

HTC Touch Diamond

$750.00

Re-defining the perception of advanced mobile phones… the HTC Touch Diamond™ signals a giant leap forward in combining hi-tech prowess with intuitive usability and exhilarating design. Learn More
- Add to Wishlist
- | Add to Compare
22" Syncmaster LCD Monitor

$399.99

The wide, 16:10 format of SAMSUNG's 226BW digital/Analog widescreen LCD monitor gives you plenty of room for all your computer applications and multiple images. DC 3000:1 contrast ratio creates crisp, easy-to-view images and gaming graphics, without ghosting or blurring. Complete with Microsoft® Vista® Premium certification and advanced dual interface for both analog digital video signals, the 226BW monitor is future-ready. Learn More
- Add to Wishlist
- | Add to Compare
AMD Phenom X4 9850 Black Ed. 2.50GHz Retail

$335.99

Deliver more sophisticated solutions with the leading-edge technology of AMD Phenom™ 9000 Series processor. Learn More
- Add to Wishlist
- | Add to Compare
Crucial 512MB PC4200 DDR2 533MHz Memory

$99.99

Crucial 512MB PC4200 DDR2 533MHz Memory Crucial Technologies is part of Micron, the largest DRAM manufacturer in the U.S. and one of the largest in the world. Because they actually manufacture memory, they have unparalleled expertise in the upgrade industry. Crucial is the only consumer memory upgrade supplier that is part of a major DRAM manufacturer. Every single Crucial memory module is tested before it goes out their doors. Crucial chips are individually tested under varying temperatures, voltages, and operational conditions for performance and functionality. Learn More
- Add to Wishlist
- | Add to Compare
Crucial 1GB PC4200 DDR2 533MHz Memory

$150.99

Crucial 1024MB PC4200 DDR2 533MHz Memory Crucial Technologies is part of Micron, the largest DRAM manufacturer in the U.S. and one of the largest in the world. Because they actually manufacture memory, they have unparalleled expertise in the upgrade industry. Crucial is the only consumer memory upgrade supplier that is part of a major DRAM manufacturer. Every single Crucial memory module is tested before it goes out their doors. Crucial chips are individually tested under varying temperatures, voltages, and operational conditions for performance and functionality. Learn More
- Add to Wishlist
- | Add to Compare
Crucial 2GB PC4200 DDR2 533MHz Memory

$199.99

Crucial 2GB PC4200 DDR2 533MHz Memory Crucial Technologies is part of Micron, the largest DRAM manufacturer in the U.S. and one of the largest in the world. Because they actually manufacture memory, they have unparalleled expertise in the upgrade industry. Crucial is the only consumer memory upgrade supplier that is part of a major DRAM manufacturer. Every single Crucial memory module is tested before it goes out their doors. Crucial chips are individually tested under varying temperatures, voltages, and operational conditions for performance and functionality. Learn More
- Add to Wishlist
- | Add to Compare
NZXT Lexa Silver Aluminum ATX Mid-Tower Case (Default)

$199.99

The Lexa boasts a ridgid, but light weight aluminum chassis. The Lexa's high-air-flow design, while quiet, ensures cooling options for the more ambitious computing enthusiasts. Three thermal probes provide temperature readings to the illuminated LCD display for monitoring your systems core components. The Lexa ships with a rugged carrying strap with protective window cover for easy single-handed transportation. Learn More
- Add to Wishlist
- | Add to Compare
Apevia Black X-Cruiser Case ATX Mid-Tower Case (Default)

$150.00

This magnificent new case features 2 x 80mm built-in fans with space for 2 optional fans. The Aspire X-Cruiser features front temperature gauge, front fan speed controller and gauge, and front volume controller and gauge. It also features USB2.0, Firewire and audio ports. The superior cooling solution that X-Cruiser delivers can only be found in very few of the expensive chassis in the market. Learn More
- Add to Wishlist
- | Add to Compare
Anashria Womens Premier Leather Sandal

4 Review(s) | Add Your Review

$41.95

Buckle embellished contrasting straps adorn both the heel and canvas covered wedge of this t-strap sandal to make it a truly unique addition to your wardrobe Learn More
- Add to Wishlist
- | Add to Compare
Universal Camera Charger

$19.00

Features foldable Flat Pin for Easy Storage/ Slim/ Lightweight Design and Smart Charging LED Indicator. Learn More
- Add to Wishlist
- | Add to Compare
Universal Camera Case

$34.00

A stylish digital camera demands stylish protection. This leather carrying case will defend your camera from the dings and scratches of travel and everyday use while looking smart all the time. Learn More
- Add to Wishlist
- | Add to Compare
SLR Camera Tripod

$99.00

Sturdy, lightweight tripods are designed to meet the needs of amateur and professional photographers and videographers. Learn More
- Add to Wishlist
- | Add to Compare
Zolof The Rock And Roll Destroyer: LOL Cat T-shirt

$13.50 As low as: $9.50

Printed on American Apparel Classic style 5495 California t-shirts. Learn More
- Add to Wishlist
- | Add to Compare
AMD A64 X2 3800+ 2.0GHz OEM

$98.99

AMD Athlon 64 X2 3800+ Processor ADO3800IAA5CZ - 2.0GHz, 2 x 512KB Cache, 1000MHz (2000 MT/s) FSB, Windsor, Dual Core, OEM, Socket AM2, Processor Learn More
- Add to Wishlist
- | Add to Compare
Intel C2D E8400 3.0GHz Retail

$98.99

Intel® Core™2 Duo processor is the new brand name for our next-generation energy-efficient performance desktop and mobile processors. Learn More
- Add to Wishlist
- | Add to Compare
My Computer

From: $635.98

To: $3,786.70

test description Learn More
- Add to Wishlist
- | Add to Compare
Gaming Computer

From: $4,999.95

To: $6,348.95

Make a computer Learn More
- Add to Wishlist
- | Add to Compare
Computer

From: $447.98

To: $4,477.92

Make a computer Learn More
- Add to Wishlist
- | Add to Compare
Microsoft Wireless Optical Mouse 5000

$59.99

Experience smoother tracking and wireless freedom. Navigate with enhanced precision with this ergonomic High Definition Optical mouse. Learn More
- Add to Wishlist
- | Add to Compare
Logitech diNovo Edge Keyboard

$239.99

PerfectStroke key system for the ultimate keyboard feel. Bluetooth wireless and Li-Ion powered. Learn More
- Add to Wishlist
- | Add to Compare

Popular Tags

View All Tags

My Cart

You have no items in your shopping cart.

Compare Products

You have no items to compare.

Community Poll

Controller Class:	Mage_CatalogSearch_ResultController
Controller Module:	Mage_CatalogSearch
Controller Action:	index
Params:	Array ( [q] => order+by+1000/*"+and+"x"="y )

Website Id:	1
Website Name:	Main Website
Store Id:	1
Store Name:	Main Store
Store View Id:	1
Store View Code:	default
Store View Name:	English
Cache Method:	File

Frontend Hints:	(Disable cache to use this feature)
Translate Inline:
Clear Cache:

Executed:	100 queries in 0.031003475189209 seconds
Average query length:	0.00031003475189209 seconds
Queries per second:	3225.4448699611
Longest query length:	0.0012369155883789
Longest query:	SELECT FLOOR(((price_index.min_price ) * 1) / 1000) + 1 AS `range`, COUNT() AS `count` FROM `catalog_product_entity` AS `e` INNER JOIN `catalogsearch_result` AS `search_result` ON search_result.product_id=e.entity_id AND search_result.query_id='55' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='3' GROUP BY FLOOR(((price_index.min_price ) 1) / 1000) + 1
Total queries:	100
Insert queries:	2
Update queries:	0
Read queries:	95
Delete queries:	0
Transactions:	2

default
STORE_default
THEME_frontend_default_default
catalogsearch_result_index
customer_logged_out
MAP_popup

Name	Time	Cnt	Emalloc	RealMem
mage	0.607359	1	0	0.00 KB
mage::dispatch::routers_match	0.449561	1	0	0.00 KB
mage::dispatch::controller::action::catalogsearch_result_index	0.400332	1	0	0.00 KB
layout/db_update: default	0.344830	1	0	0.00 KB
layout/db_update: STORE_default	0.343700	1	0	0.00 KB
layout/db_update: THEME_frontend_default_default	0.342793	1	0	0.00 KB
layout/db_update: MAP_popup	0.341622	1	0	0.00 KB
layout/db_update: catalogsearch_result_index	0.340343	1	0	0.00 KB
layout/db_update: customer_logged_out	0.339233	1	0	0.00 KB
mage::dispatch::controller::action::catalogsearch_result_index::layout_render	0.269984	1	0	0.00 KB
frontend/base/default/template/page/3columns.phtml	0.269239	1	0	0.00 KB
frontend/base/default/template/catalogsearch/result.phtml	0.154912	1	3,230,232	3.08 MB
frontend/base/default/template/catalog/product/list.phtml	0.139704	1	2,536,464	2.42 MB
config/load-modules	0.088479	1	4,384	4.28 KB
CONFIGURABLE:Mage_Catalog_Model_Product_Type_Configurable::getConfigurableAttributes	0.073030	2	1,528,344	1.46 MB
mage::dispatch::controller::action::catalogsearch_result_index::layout_generate_blocks	0.067792	1	8,777,696	8.37 MB
mage::dispatch::controller::action::catalogsearch_result_index::layout_load	0.059122	1	80,040	78.16 KB
layout/package_update: default	0.052754	1	21,664	21.16 KB
mage::dispatch::controller::action::predispatch	0.048719	1	815,760	796.64 KB
mage::dispatch::controller::action::predispatch::load_area::frontend::translate	0.039769	1	78,312	76.48 KB
config/load-db	0.038649	1	39,672	38.74 KB
CONFIGURABLE:Mage_Catalog_Model_Product_Type_Configurable::getUsedProducts	0.037669	30	782,072	763.74 KB
TTT2:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad	0.037638	2	713,904	697.17 KB
BLOCK: catalogsearch.leftnav	0.037451	1	3,464,856	3.30 MB
Mage_Core_Model_Design_Package::getFilename	0.033309	190	214,928	209.89 KB
frontend/base/default/template/catalog/layer/view.phtml	0.033240	1	238,472	232.88 KB
frontend/default/default/template/mgt_developertoolbar/toolbar.phtml	0.029972	1	0	0.00 KB
frontend/default/default/template/mgt_developertoolbar/tabcontainer.phtml	0.027326	2	557,408	544.34 KB
TTT1:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad	0.027302	2	603,408	589.27 KB
frontend/base/default/template/catalog/product/price.phtml	0.016867	17	445,624	435.18 KB
frontend/base/default/template/page/html/header.phtml	0.015649	1	444,688	434.27 KB
__EAV_COLLECTION_LOAD_ATTR__	0.015205	5	163,680	159.84 KB
mage::app::init::apply_db_schema_updates	0.014139	1	1,230,136	1.17 MB
__EAV_LOAD_MODEL__	0.012692	2	899,880	878.79 KB
config/load-modules-declaration	0.012589	1	107,384	104.87 KB
DISPATCH EVENT:catalog_block_product_list_collection	0.012436	1	538,520	525.90 KB
frontend/default/default/template/mgt_developertoolbar/tab/blocks.phtml	0.012386	1	18,616	18.18 KB
OBSERVER: review	0.012355	1	535,624	523.07 KB
frontend/base/default/template/catalog/navigation/top.phtml	0.011696	1	408,176	398.61 KB