Earphones (In Ear Monitors and Headphones) & Earbuds at HIFIMAN| Head-Direct

Home /
Earphones
Earphones
In-ear headphones (aka earphones) are a great way to combine superb sound with portability. HIFIMAN offers some of the most popular in-ear phones such as the RE400, RE600/600S, RE300a/I/h and the new ES100 premium ear bud. RE400 and RE300 are available in models for Android and iPhone devices.

SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
 LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (496, 1021, 1022, 1071, 1072, 1073, 1100, 1114, 1115, 1020, 957, 897, 573, 663, 720, 776, 810, 840, 864, 865, 174, 157, 143, 249)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '118', '119')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
 LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (496, 1021, 1022, 1071, 1072, 1073, 1100, 1114, 1115, 1020, 957, 897, 573, 663, 720, 776, 810, 840, 864, 865, 174, 157, 143, 249)) AND (t_d.attribute_id IN ('73')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
 LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (496, 1021, 1022, 1071, 1072, 1073, 1100, 1114, 1115, 1020, 957, 897, 573, 663, 720, 776, 810, 840, 864, 865, 174, 157, 143, 249)) AND (t_d.attribute_id IN ('75', '76', '120')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
 LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (496, 1021, 1022, 1071, 1072, 1073, 1100, 1114, 1115, 1020, 957, 897, 573, 663, 720, 776, 810, 840, 864, 865, 174, 157, 143, 249)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
 LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (496, 1021, 1022, 1071, 1072, 1073, 1100, 1114, 1115, 1020, 957, 897, 573, 663, 720, 776, 810, 840, 864, 865, 174, 157, 143, 249)) AND (t_d.attribute_id IN ('96', '122', '124', '126', '127', '128', '129', '132', '136', '137', '138', '139', '140', '142', '145', '146', '147', '148', '150', '152', '155')) AND (t_d.store_id = 0)

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

#0 D:\web\hifiman.com\store\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 D:\web\hifiman.com\store\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 D:\web\hifiman.com\store\lib\Zend\Db\Adapter\Abstract.php(487): Zend_Db_Statement->execute(Array)
#3 D:\web\hifiman.com\store\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `t_d`.`e...', Array)
#4 D:\web\hifiman.com\store\lib\Varien\Db\Adapter\Pdo\Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `t_d`.`e...', Array)
#5 D:\web\hifiman.com\store\lib\Zend\Db\Adapter\Abstract.php(741): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `t_d`.`e...', Array)
#6 D:\web\hifiman.com\store\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(1111): Zend_Db_Adapter_Abstract->fetchAll('SELECT `t_d`.`e...')
#7 D:\web\hifiman.com\store\app\code\core\Mage\Catalog\Model\Resource\Product\Collection.php(459): Mage_Eav_Model_Entity_Collection_Abstract->_loadAttributes(false, false)
#8 D:\web\hifiman.com\store\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(874): Mage_Catalog_Model_Resource_Product_Collection->_loadAttributes(false, false)
#9 D:\web\hifiman.com\store\app\code\core\Mage\Review\Model\Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 D:\web\hifiman.com\store\app\code\core\Mage\Core\Model\App.php(1341): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer))
#11 D:\web\hifiman.com\store\app\code\core\Mage\Core\Model\App.php(1314): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), 'catalogBlockPro...', Object(Varien_Event_Observer))
#12 D:\web\hifiman.com\store\app\Mage.php(447): Mage_Core_Model_App->dispatchEvent('catalog_block_p...', Array)
#13 D:\web\hifiman.com\store\app\code\core\Mage\Catalog\Block\Product\List.php(163): Mage::dispatchEvent('catalog_block_p...', Array)
#14 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(862): Mage_Catalog_Block_Product_List->_beforeToHtml()
#15 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#16 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml('product_list', true)
#17 D:\web\hifiman.com\store\app\code\core\Mage\Catalog\Block\Category\View.php(85): Mage_Core_Block_Abstract->getChildHtml('product_list')
#18 D:\web\hifiman.com\store\app\design\frontend\hms\default\template\catalog\category\view.phtml(71): Mage_Catalog_Block_Category_View->getProductListHtml()
#19 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(241): include('D:\\web\\hifiman....')
#20 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView('frontend\\hms\\de...')
#21 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(286): Mage_Core_Block_Template->renderView()
#22 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#23 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Text\List.php(43): Mage_Core_Block_Abstract->toHtml()
#24 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#25 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#26 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#27 D:\web\hifiman.com\store\app\design\frontend\base\default\template\page\2columns-left.phtml(48): Mage_Core_Block_Abstract->getChildHtml('content')
#28 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(241): include('D:\\web\\hifiman....')
#29 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView('frontend\\base\\d...')
#30 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Template.php(286): Mage_Core_Block_Template->renderView()
#31 D:\web\hifiman.com\store\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#32 D:\web\hifiman.com\store\app\code\core\Mage\Core\Model\Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#33 D:\web\hifiman.com\store\app\code\core\Mage\Core\Controller\Varien\Action.php(390): Mage_Core_Model_Layout->getOutput()
#34 D:\web\hifiman.com\store\app\code\core\Mage\Catalog\controllers\CategoryController.php(159): Mage_Core_Controller_Varien_Action->renderLayout()
#35 D:\web\hifiman.com\store\app\code\core\Mage\Core\Controller\Varien\Action.php(418): Mage_Catalog_CategoryController->viewAction()
#36 D:\web\hifiman.com\store\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch('view')
#37 D:\web\hifiman.com\store\app\code\core\Mage\Core\Controller\Varien\Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#38 D:\web\hifiman.com\store\app\code\core\Mage\Core\Model\App.php(357): Mage_Core_Controller_Varien_Front->dispatch()
#39 D:\web\hifiman.com\store\app\Mage.php(685): Mage_Core_Model_App->run(Array)
#40 D:\web\hifiman.com\store\index.php(134): Mage::run('', 'store')
#41 {main}