API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 31st, 2013
258
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 114.63 KB | None | 0 0
raw download clone embed print report
  1. ## 2013-08-31 15:27:32
  2. ## 10156 ## CONNECT
  3. TIME: 0.0042
  4. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(0, '') called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:315]
  5. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_connect() called at [lib/Zend/Db/Adapter/Abstract.php:459]
  6. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->query('SET NAMES utf8;', array()) called at [lib/Zend/Db/Adapter/Pdo/Abstract.php:238]
  7. #4 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Pdo_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->query('SET NAMES utf8;', array()) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:420]
  8. #5 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SET NAMES utf8;') called at [app/code/core/Mage/Core/Model/Resource.php:169]
  9. #6 Mage_Core_Model_Resource#0296f327240329552d89bf582c438fb2#->_newConnection('pdo_mysql', &Mage_Core_Model_Config_Element#c610d762ab4e2cda049637e1bc856f58#) called at [app/code/core/Mage/Core/Model/Resource.php:110]
  10. #7 Mage_Core_Model_Resource#0296f327240329552d89bf582c438fb2#->getConnection('core_write') called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:320]
  11. #8 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getConnection('write') called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:350]
  12. #9 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getWriteAdapter() called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:335]
  13. #10 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getReadAdapter() called at [app/code/core/Mage/Core/Model/Resource/Config.php:55]
  14. #11 Mage_Core_Model_Resource_Config#1d5a89b885dd0dc30ae6328cc99819ca#->loadToXml(&Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#) called at [app/code/core/Mage/Core/Model/Config.php:354]
  15. #12 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->loadDb() called at [app/code/core/Mage/Core/Model/Config.php:260]
  16. #13 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->init(array()) called at [app/code/core/Mage/Core/Model/App.php:270]
  17. #14 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  18. #15 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  19. #16 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  20.  
  21.  
  22. ## 2013-08-31 15:27:32
  23. ## 10156 ## QUERY
  24. SQL: SET NAMES utf8;
  25. AFF: 0
  26. TIME: 0.0162
  27. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SET NAMES utf8;', array(), &Varien_Db_Statement_Pdo_Mysql#1149269771370607809b83a0195d9bd1#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  28. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SET NAMES utf8;') called at [app/code/core/Mage/Core/Model/Resource.php:169]
  29. #3 Mage_Core_Model_Resource#0296f327240329552d89bf582c438fb2#->_newConnection('pdo_mysql', &Mage_Core_Model_Config_Element#c610d762ab4e2cda049637e1bc856f58#) called at [app/code/core/Mage/Core/Model/Resource.php:110]
  30. #4 Mage_Core_Model_Resource#0296f327240329552d89bf582c438fb2#->getConnection('core_write') called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:320]
  31. #5 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getConnection('write') called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:350]
  32. #6 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getWriteAdapter() called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:335]
  33. #7 Mage_Core_Model_Resource_Config[Mage_Core_Model_Resource_Db_Abstract]#1d5a89b885dd0dc30ae6328cc99819ca#->_getReadAdapter() called at [app/code/core/Mage/Core/Model/Resource/Config.php:55]
  34. #8 Mage_Core_Model_Resource_Config#1d5a89b885dd0dc30ae6328cc99819ca#->loadToXml(&Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#) called at [app/code/core/Mage/Core/Model/Config.php:354]
  35. #9 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->loadDb() called at [app/code/core/Mage/Core/Model/Config.php:260]
  36. #10 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->init(array()) called at [app/code/core/Mage/Core/Model/App.php:270]
  37. #11 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  38. #12 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  39. #13 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  40.  
  41.  
  42. ## 2013-08-31 15:27:32
  43. ## 10156 ## QUERY
  44. SQL: SELECT `core_website`.`website_id`, `core_website`.`code`, `core_website`.`name` FROM `core_website`
  45. AFF: 4
  46. TIME: 0.0007
  47. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `core_web...', array(), &Varien_Db_Statement_Pdo_Mysql#29bf6b259db236a38f70cdd138e079c5#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  48. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#73c8a622d3c168e2b169bf36dcd69c69#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:773]
  49. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAssoc(&Varien_Db_Select#73c8a622d3c168e2b169bf36dcd69c69#) called at [app/code/core/Mage/Core/Model/Resource/Config.php:63]
  50. #4 Mage_Core_Model_Resource_Config#1d5a89b885dd0dc30ae6328cc99819ca#->loadToXml(&Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#) called at [app/code/core/Mage/Core/Model/Config.php:354]
  51. #5 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->loadDb() called at [app/code/core/Mage/Core/Model/Config.php:260]
  52. #6 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->init(array()) called at [app/code/core/Mage/Core/Model/App.php:270]
  53. #7 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  54. #8 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  55. #9 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  56.  
  57.  
  58. ## 2013-08-31 15:27:32
  59. ## 10156 ## QUERY
  60. SQL: SELECT `core_store`.`store_id`, `core_store`.`code`, `core_store`.`name`, `core_store`.`website_id` FROM `core_store` ORDER BY `sort_order` ASC
  61. AFF: 4
  62. TIME: 0.0007
  63. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `core_sto...', array(), &Varien_Db_Statement_Pdo_Mysql#73c8a622d3c168e2b169bf36dcd69c69#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  64. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#1149269771370607809b83a0195d9bd1#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:773]
  65. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAssoc(&Varien_Db_Select#1149269771370607809b83a0195d9bd1#) called at [app/code/core/Mage/Core/Model/Resource/Config.php:74]
  66. #4 Mage_Core_Model_Resource_Config#1d5a89b885dd0dc30ae6328cc99819ca#->loadToXml(&Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#) called at [app/code/core/Mage/Core/Model/Config.php:354]
  67. #5 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->loadDb() called at [app/code/core/Mage/Core/Model/Config.php:260]
  68. #6 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->init(array()) called at [app/code/core/Mage/Core/Model/App.php:270]
  69. #7 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  70. #8 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  71. #9 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  72.  
  73.  
  74. ## 2013-08-31 15:27:32
  75. ## 10156 ## QUERY
  76. SQL: SELECT `core_config_data`.`scope`, `core_config_data`.`scope_id`, `core_config_data`.`path`, `core_config_data`.`value` FROM `core_config_data`
  77. AFF: 1097
  78. TIME: 0.0008
  79. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `core_con...', array(), &Varien_Db_Statement_Pdo_Mysql#1149269771370607809b83a0195d9bd1#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  80. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#af5d79a460cbe5788bc57da490899e98#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  81. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll(&Varien_Db_Select#af5d79a460cbe5788bc57da490899e98#) called at [app/code/core/Mage/Core/Model/Resource/Config.php:96]
  82. #4 Mage_Core_Model_Resource_Config#1d5a89b885dd0dc30ae6328cc99819ca#->loadToXml(&Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#) called at [app/code/core/Mage/Core/Model/Config.php:354]
  83. #5 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->loadDb() called at [app/code/core/Mage/Core/Model/Config.php:260]
  84. #6 Mage_Core_Model_Config#8954fab32320230673c44f619f203c85#->init(array()) called at [app/code/core/Mage/Core/Model/App.php:270]
  85. #7 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  86. #8 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  87. #9 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  88.  
  89.  
  90. ## 2013-08-31 15:27:32
  91. ## 10156 ## QUERY
  92. SQL: SELECT `main_table`.* FROM `core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC
  93. AFF: 4
  94. TIME: 0.0003
  95. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#899c19f86c8440b3ba75e183fafcb990#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  96. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  97. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  98. #4 Mage_Core_Model_Resource_Store_Collection[Varien_Data_Collection_Db]#a24adf7299861b74a62cbc34f28c7eb3#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  99. #5 Mage_Core_Model_Resource_Store_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#a24adf7299861b74a62cbc34f28c7eb3#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  100. #6 Mage_Core_Model_Resource_Store_Collection[Varien_Data_Collection_Db]#a24adf7299861b74a62cbc34f28c7eb3#->load(false, false) called at [app/code/core/Mage/Core/Model/Resource/Store/Collection.php:174]
  101. #7 Mage_Core_Model_Resource_Store_Collection#a24adf7299861b74a62cbc34f28c7eb3#->load() called at [lib/Varien/Data/Collection.php:752]
  102. #8 Mage_Core_Model_Resource_Store_Collection[Varien_Data_Collection]#a24adf7299861b74a62cbc34f28c7eb3#->count() called at [app/code/core/Mage/Core/Model/App.php:624]
  103. #9 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initStores() called at [app/code/core/Mage/Core/Model/App.php:466]
  104. #10 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initCurrentStore('admin', 'store') called at [app/code/core/Mage/Core/Model/App.php:274]
  105. #11 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  106. #12 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  107. #13 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  108.  
  109.  
  110. ## 2013-08-31 15:27:32
  111. ## 10156 ## QUERY
  112. SQL: SELECT `main_table`.* FROM `core_website` AS `main_table` ORDER BY main_table.sort_order ASC, main_table.name ASC
  113. AFF: 4
  114. TIME: 0.0002
  115. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#fbb0ed9648a3473128c56e79d1d1ecdc#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  116. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  117. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  118. #4 Mage_Core_Model_Resource_Website_Collection[Varien_Data_Collection_Db]#362086c52f1097ca09d6a93e187c52e5#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  119. #5 Mage_Core_Model_Resource_Website_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#362086c52f1097ca09d6a93e187c52e5#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  120. #6 Mage_Core_Model_Resource_Website_Collection[Varien_Data_Collection_Db]#362086c52f1097ca09d6a93e187c52e5#->load(false, false) called at [app/code/core/Mage/Core/Model/Resource/Website/Collection.php:137]
  121. #7 Mage_Core_Model_Resource_Website_Collection#362086c52f1097ca09d6a93e187c52e5#->load() called at [lib/Varien/Data/Collection.php:729]
  122. #8 Mage_Core_Model_Resource_Website_Collection[Varien_Data_Collection]#362086c52f1097ca09d6a93e187c52e5#->getItemById(0) called at [app/code/core/Mage/Core/Model/App.php:634]
  123. #9 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initStores() called at [app/code/core/Mage/Core/Model/App.php:466]
  124. #10 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initCurrentStore('admin', 'store') called at [app/code/core/Mage/Core/Model/App.php:274]
  125. #11 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  126. #12 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  127. #13 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  128.  
  129.  
  130. ## 2013-08-31 15:27:32
  131. ## 10156 ## QUERY
  132. SQL: SELECT `main_table`.* FROM `core_store_group` AS `main_table` ORDER BY main_table.name ASC
  133. AFF: 4
  134. TIME: 0.0002
  135. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#2c80217e876debfa3f3e97775fbb56af#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  136. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  137. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  138. #4 Mage_Core_Model_Resource_Store_Group_Collection[Varien_Data_Collection_Db]#80f238e544d492e2eafbd7cd79345558#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  139. #5 Mage_Core_Model_Resource_Store_Group_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#80f238e544d492e2eafbd7cd79345558#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  140. #6 Mage_Core_Model_Resource_Store_Group_Collection[Varien_Data_Collection_Db]#80f238e544d492e2eafbd7cd79345558#->load() called at [lib/Varien/Data/Collection.php:729]
  141. #7 Mage_Core_Model_Resource_Store_Group_Collection[Varien_Data_Collection]#80f238e544d492e2eafbd7cd79345558#->getItemById(0) called at [app/code/core/Mage/Core/Model/App.php:635]
  142. #8 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initStores() called at [app/code/core/Mage/Core/Model/App.php:466]
  143. #9 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->_initCurrentStore('admin', 'store') called at [app/code/core/Mage/Core/Model/App.php:274]
  144. #10 Mage_Core_Model_App#0e2e59e3654348f6c7337bbd9a59d2dd#->init('admin', 'store', array()) called at [app/Mage.php:615]
  145. #11 Mage::app('admin', 'store') called at [shell/abstract.php:79]
  146. #12 Mage_Shell_Compiler[Mage_Shell_Abstract]#92ed897b8db83c60430eaccb7c46ef9c#->__construct() called at [shell/indexer.php:197]
  147.  
  148.  
  149. ## 2013-08-31 15:27:32
  150. ## 10156 ## QUERY
  151. SQL: SELECT `main_table`.* FROM `index_process` AS `main_table`
  152. AFF: 9
  153. TIME: 0.0007
  154. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#362086c52f1097ca09d6a93e187c52e5#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  155. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  156. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  157. #4 Mage_Index_Model_Resource_Process_Collection[Varien_Data_Collection_Db]#a99f1fc92123b762e43a0bb8bbe84573#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  158. #5 Mage_Index_Model_Resource_Process_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#a99f1fc92123b762e43a0bb8bbe84573#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  159. #6 Mage_Index_Model_Resource_Process_Collection[Varien_Data_Collection_Db]#a99f1fc92123b762e43a0bb8bbe84573#->load() called at [lib/Varien/Data/Collection.php:741]
  160. #7 Mage_Index_Model_Resource_Process_Collection[Varien_Data_Collection]#a99f1fc92123b762e43a0bb8bbe84573#->getIterator() called at [app/code/core/Mage/Index/Model/Indexer.php:104]
  161. #8 Mage_Index_Model_Indexer#a24adf7299861b74a62cbc34f28c7eb3#->getProcessByCode('catalog_product_...') called at [shell/indexer.php:65]
  162. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->_parseIndexerString('catalog_product_...') called at [shell/indexer.php:150]
  163. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  164.  
  165.  
  166. ## 2013-08-31 15:27:32
  167. ## 10156 ## QUERY
  168. SQL: SELECT `index_process_event`.* FROM `index_process_event` WHERE (process_id = '2') AND (status = 'new')
  169. AFF: 0
  170. TIME: 0.0299
  171. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `index_pr...', array(), &Varien_Db_Statement_Pdo_Mysql#c6e33f4c2851da55d77750c84b975b63#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  172. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#01827b262c8af5e3646a2cd8a98985d6#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  173. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll(&Varien_Db_Select#01827b262c8af5e3646a2cd8a98985d6#) called at [app/code/core/Mage/Index/Model/Resource/Event.php:146]
  174. #4 Mage_Index_Model_Resource_Event#80fd6a2d17204d1ae8252404c1b2580d#->getUnprocessedEvents(&Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#) called at [app/code/core/Mage/Index/Model/Process.php:241]
  175. #5 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  176. #6 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  177.  
  178.  
  179. ## 2013-08-31 15:27:32
  180. ## 10156 ## QUERY
  181. SQL: SELECT `index_process_event`.* FROM `index_process_event` WHERE (process_id = '13') AND (status = 'new')
  182. AFF: 0
  183. TIME: 0.0367
  184. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `index_pr...', array(), &Varien_Db_Statement_Pdo_Mysql#01827b262c8af5e3646a2cd8a98985d6#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  185. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#c6e33f4c2851da55d77750c84b975b63#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  186. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll(&Varien_Db_Select#c6e33f4c2851da55d77750c84b975b63#) called at [app/code/core/Mage/Index/Model/Resource/Event.php:146]
  187. #4 Mage_Index_Model_Resource_Event#80fd6a2d17204d1ae8252404c1b2580d#->getUnprocessedEvents(&Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#) called at [app/code/core/Mage/Index/Model/Process.php:241]
  188. #5 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  189. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  190. #7 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  191.  
  192.  
  193. ## 2013-08-31 15:27:32
  194. ## 10156 ## QUERY
  195. SQL: UPDATE `index_process` SET `status` = ?, `started_at` = ? WHERE (process_id='13')
  196. BIND: array (
  197.   0 => 'working',
  198.   1 => '2013-08-31 15:27:32',
  199. )
  200. AFF: 1
  201. TIME: 0.0074
  202. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('working', '2013-08-31 15:27...'), &Varien_Db_Statement_Pdo_Mysql#f07fc3e1208cffc374974dcf2e7703c1#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  203. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('working', '2013-08-31 15:27...')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  204. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process', array('status' => 'working', 'started_at' => '2013-08-31 15:27...'), array('process_id=?' => 13)) called at [app/code/core/Mage/Index/Model/Resource/Process.php:137]
  205. #4 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->_updateProcessData(13, array('status' => 'working', 'started_at' => '2013-08-31 15:27...')) called at [app/code/core/Mage/Index/Model/Resource/Process.php:93]
  206. #5 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->startProcess(&Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#) called at [app/code/core/Mage/Index/Model/Process.php:187]
  207. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  208. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  209. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  210. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  211.  
  212.  
  213. ## 2013-08-31 15:27:33
  214. ## 10156 ## QUERY
  215. SQL: SELECT `main_table`.*, `process_event`.`status` AS `process_event_status` FROM `index_event` AS `main_table`
  216.  INNER JOIN `index_process_event` AS `process_event` ON process_event.event_id=main_table.event_id WHERE (process_event.process_id = '13') AND (process_event.status = 'new')
  217. AFF: 0
  218. TIME: 0.4496
  219. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#f07fc3e1208cffc374974dcf2e7703c1#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  220. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  221. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  222. #4 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection_Db]#fe41641b1c485fda5a690d0c2c7c37d7#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  223. #5 Mage_Index_Model_Resource_Event_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#fe41641b1c485fda5a690d0c2c7c37d7#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  224. #6 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection_Db]#fe41641b1c485fda5a690d0c2c7c37d7#->load() called at [lib/Varien/Data/Collection.php:752]
  225. #7 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection]#fe41641b1c485fda5a690d0c2c7c37d7#->count() called at [app/code/core/Mage/Index/Model/Process.php:195]
  226. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  227. #9 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  228. #10 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  229. #11 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  230.  
  231.  
  232. ## 2013-08-31 15:27:33
  233. ## 10156 ## QUERY
  234. SQL: UPDATE `index_process_event` SET `status` = ? WHERE (process_id = '13')
  235. BIND: array (
  236.   0 => 'done',
  237. )
  238. AFF: 0
  239. TIME: 0.0609
  240. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('done'), &Varien_Db_Statement_Pdo_Mysql#f07fc3e1208cffc374974dcf2e7703c1#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  241. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('done')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  242. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process_ev...', array('status' => 'done'), array('process_id = ?' => 13)) called at [app/code/core/Mage/Index/Model/Resource/Event.php:129]
  243. #4 Mage_Index_Model_Resource_Event#80fd6a2d17204d1ae8252404c1b2580d#->updateProcessEvents(&Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#) called at [app/code/core/Mage/Index/Model/Process.php:208]
  244. #5 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  245. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  246. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  247. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  248.  
  249.  
  250. ## 2013-08-31 15:27:33
  251. ## 10156 ## TRANSACTION BEGIN
  252. TIME: 0.0002
  253. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(1, 'BEGIN') called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:221]
  254. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->beginTransaction() called at [app/code/core/Mage/Core/Model/Resource/Abstract.php:76]
  255. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Core_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->beginTransaction() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:243]
  256. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  257. #5 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  258. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  259. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  260. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  261. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  262.  
  263.  
  264. ## 2013-08-31 15:27:33
  265. ## 10156 ## QUERY
  266. SQL: DELETE FROM `cataloginventory_stock_status_idx`
  267. AFF: 17488
  268. TIME: 0.2306
  269. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#1eafa62c89980538e06ae3e3da29cf41#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  270. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  271. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('cataloginventory...') called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:235]
  272. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Index_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->clearTemporaryIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:245]
  273. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  274. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  275. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  276. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  277. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  278. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  279.  
  280.  
  281. ## 2013-08-31 15:27:33
  282. ## 10156 ## QUERY
  283. SQL: SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (`eav_entity_type`.`entity_type_code`='catalog_product')
  284. AFF: 1
  285. TIME: 0.0005
  286. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `eav_enti...', array(), &Varien_Db_Statement_Pdo_Mysql#28ef5e9a69136ed318f4c290793fef1b#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  287. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#d3314ea7a8e92996785fa5797ecbad96#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:753]
  288. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchRow(&Varien_Db_Select#d3314ea7a8e92996785fa5797ecbad96#) called at [app/code/core/Mage/Core/Model/Resource/Db/Abstract.php:380]
  289. #4 Mage_Eav_Model_Resource_Entity_Type[Mage_Core_Model_Resource_Db_Abstract]#21ef89e19c7c014870991154f961fd6e#->load(&Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#, 'catalog_product', 'entity_type_code') called at [app/code/core/Mage/Eav/Model/Resource/Entity/Type.php:54]
  290. #5 Mage_Eav_Model_Resource_Entity_Type#21ef89e19c7c014870991154f961fd6e#->loadByCode(&Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#, 'catalog_product') called at [app/code/core/Mage/Eav/Model/Entity/Type.php:100]
  291. #6 Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#->loadByCode('catalog_product') called at [app/code/core/Mage/Eav/Model/Config.php:324]
  292. #7 Mage_Eav_Model_Config#36e5e2f27f5cf917f718213a0aa46ea9#->getEntityType('catalog_product') called at [app/code/core/Mage/Eav/Model/Config.php:386]
  293. #8 Mage_Eav_Model_Config#36e5e2f27f5cf917f718213a0aa46ea9#->getAttribute('catalog_product', 'status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:45]
  294. #9 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_getAttribute('status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:63]
  295. #10 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_addAttributeToSelect(&Varien_Db_Select#43ebcf3bfe4da34c4ca5a6c876f41c4c#, 'status', 'e.entity_id', 'cs.store_id', '=1') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:182]
  296. #11 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  297. #12 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  298. #13 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  299. #14 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  300. #15 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  301. #16 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  302. #17 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  303. #18 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  304. #19 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  305.  
  306.  
  307. ## 2013-08-31 15:27:33
  308. ## 10156 ## QUERY
  309. SQL: SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='status') AND (entity_type_id = :entity_type_id)
  310. BIND: array (
  311.   ':entity_type_id' => '10',
  312. )
  313. AFF: 1
  314. TIME: 0.0005
  315. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `eav_attr...', array(':entity_type_id' => 10), &Varien_Db_Statement_Pdo_Mysql#9ed682380293a3b4bf5e249b89ee4a73#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  316. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#, array(':entity_type_id' => 10)) called at [lib/Zend/Db/Adapter/Abstract.php:753]
  317. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchRow(&Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#, array(':entity_type_id' => 10)) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:104]
  318. #4 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->loadByCode(&Mage_Catalog_Model_Resource_Eav_Attribute#28ef5e9a69136ed318f4c290793fef1b#, 10, 'status') called at [app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php:118]
  319. #5 Mage_Catalog_Model_Resource_Eav_Attribute[Mage_Eav_Model_Entity_Attribute_Abstract]#28ef5e9a69136ed318f4c290793fef1b#->loadByCode(&Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#, 'status') called at [app/code/core/Mage/Eav/Model/Config.php:422]
  320. #6 Mage_Eav_Model_Config#36e5e2f27f5cf917f718213a0aa46ea9#->getAttribute('catalog_product', 'status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:45]
  321. #7 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_getAttribute('status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:63]
  322. #8 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_addAttributeToSelect(&Varien_Db_Select#43ebcf3bfe4da34c4ca5a6c876f41c4c#, 'status', 'e.entity_id', 'cs.store_id', '=1') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:182]
  323. #9 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  324. #10 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  325. #11 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  326. #12 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  327. #13 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  328. #14 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  329. #15 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  330. #16 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  331. #17 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  332.  
  333.  
  334. ## 2013-08-31 15:27:33
  335. ## 10156 ## QUERY
  336. SQL: SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = :entity_type_id)
  337. BIND: array (
  338.   ':entity_type_id' => '10',
  339. )
  340. AFF: 1
  341. TIME: 0.0004
  342. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `eav_enti...', array(':entity_type_id' => 10), &Varien_Db_Statement_Pdo_Mysql#d290d4b6668544e9823c5f000a183262#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  343. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#9ed682380293a3b4bf5e249b89ee4a73#, array('entity_type_id' => 10)) called at [lib/Zend/Db/Adapter/Abstract.php:825]
  344. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchOne(&Varien_Db_Select#9ed682380293a3b4bf5e249b89ee4a73#, array('entity_type_id' => 10)) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Type.php:71]
  345. #4 Mage_Eav_Model_Resource_Entity_Type#21ef89e19c7c014870991154f961fd6e#->getAdditionalAttributeTable(10) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:483]
  346. #5 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->getAdditionalAttributeTable(10) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:500]
  347. #6 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->_afterLoad(&Mage_Catalog_Model_Resource_Eav_Attribute#28ef5e9a69136ed318f4c290793fef1b#) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:108]
  348. #7 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->loadByCode(&Mage_Catalog_Model_Resource_Eav_Attribute#28ef5e9a69136ed318f4c290793fef1b#, 10, 'status') called at [app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php:118]
  349. #8 Mage_Catalog_Model_Resource_Eav_Attribute[Mage_Eav_Model_Entity_Attribute_Abstract]#28ef5e9a69136ed318f4c290793fef1b#->loadByCode(&Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#, 'status') called at [app/code/core/Mage/Eav/Model/Config.php:422]
  350. #9 Mage_Eav_Model_Config#36e5e2f27f5cf917f718213a0aa46ea9#->getAttribute('catalog_product', 'status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:45]
  351. #10 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_getAttribute('status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:63]
  352. #11 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_addAttributeToSelect(&Varien_Db_Select#43ebcf3bfe4da34c4ca5a6c876f41c4c#, 'status', 'e.entity_id', 'cs.store_id', '=1') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:182]
  353. #12 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  354. #13 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  355. #14 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  356. #15 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  357. #16 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  358. #17 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  359. #18 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  360. #19 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  361. #20 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  362.  
  363.  
  364. ## 2013-08-31 15:27:33
  365. ## 10156 ## QUERY
  366. SQL: SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = :attribute_id)
  367. BIND: array (
  368.   ':attribute_id' => '273',
  369. )
  370. AFF: 1
  371. TIME: 0.0003
  372. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `catalog_...', array(':attribute_id' => 273), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  373. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#9ed682380293a3b4bf5e249b89ee4a73#, array(':attribute_id' => 273)) called at [lib/Zend/Db/Adapter/Abstract.php:753]
  374. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchRow(&Varien_Db_Select#9ed682380293a3b4bf5e249b89ee4a73#, array(':attribute_id' => 273)) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:510]
  375. #4 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->_afterLoad(&Mage_Catalog_Model_Resource_Eav_Attribute#28ef5e9a69136ed318f4c290793fef1b#) called at [app/code/core/Mage/Eav/Model/Resource/Entity/Attribute.php:108]
  376. #5 Mage_Catalog_Model_Resource_Attribute[Mage_Eav_Model_Resource_Entity_Attribute]#bfed3d838a90cc8baacc44ed7922f59a#->loadByCode(&Mage_Catalog_Model_Resource_Eav_Attribute#28ef5e9a69136ed318f4c290793fef1b#, 10, 'status') called at [app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php:118]
  377. #6 Mage_Catalog_Model_Resource_Eav_Attribute[Mage_Eav_Model_Entity_Attribute_Abstract]#28ef5e9a69136ed318f4c290793fef1b#->loadByCode(&Mage_Eav_Model_Entity_Type#4f5f81f2f05c613e6a717541216c5c9a#, 'status') called at [app/code/core/Mage/Eav/Model/Config.php:422]
  378. #7 Mage_Eav_Model_Config#36e5e2f27f5cf917f718213a0aa46ea9#->getAttribute('catalog_product', 'status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:45]
  379. #8 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_getAttribute('status') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Abstract.php:63]
  380. #9 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default[Mage_Catalog_Model_Resource_Product_Indexer_Abstract]#22b552057f0e696ec900f869c72ba455#->_addAttributeToSelect(&Varien_Db_Select#43ebcf3bfe4da34c4ca5a6c876f41c4c#, 'status', 'e.entity_id', 'cs.store_id', '=1') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:182]
  381. #10 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  382. #11 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  383. #12 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  384. #13 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  385. #14 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  386. #15 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  387. #16 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  388. #17 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  389. #18 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  390.  
  391.  
  392. ## 2013-08-31 15:27:33
  393. ## 10156 ## QUERY
  394. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, IF(cisi.qty > 0, cisi.qty, 0) AS `qty`, IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock) AS `status` FROM `catalog_product_entity` AS `e`
  395.  CROSS JOIN `core_website` AS `cw`
  396.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  397.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  398.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  399.  CROSS JOIN `cataloginventory_stock` AS `cis`
  400.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  401.  INNER JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  402.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'downloadable') AND (IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1) ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  403. AFF: 0
  404. TIME: 0.0441
  405. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  406. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  407. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  408. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#22b552057f0e696ec900f869c72ba455#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  409. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  410. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  411. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  412. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  413. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  414. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  415.  
  416.  
  417. ## 2013-08-31 15:27:35
  418. ## 10156 ## QUERY
  419. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, IF(cisi.qty > 0, cisi.qty, 0) AS `qty`, IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock) AS `status` FROM `catalog_product_entity` AS `e`
  420.  CROSS JOIN `core_website` AS `cw`
  421.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  422.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  423.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  424.  CROSS JOIN `cataloginventory_stock` AS `cis`
  425.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  426.  INNER JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  427.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'simple') AND (IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1) ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  428. AFF: 17354
  429. TIME: 1.7092
  430. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#d09de748e5f46d1957072aee3171dc02#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  431. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  432. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#e93263191bacf3eadbce94cf73a98ba3#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  433. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#e93263191bacf3eadbce94cf73a98ba3#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  434. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  435. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  436. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  437. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  438. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  439. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  440.  
  441.  
  442. ## 2013-08-31 15:27:35
  443. ## 10156 ## QUERY
  444. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, IF(cisi.qty > 0, cisi.qty, 0) AS `qty`, IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock) AS `status` FROM `catalog_product_entity` AS `e`
  445.  CROSS JOIN `core_website` AS `cw`
  446.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  447.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  448.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  449.  CROSS JOIN `cataloginventory_stock` AS `cis`
  450.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  451.  INNER JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  452.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'virtual') AND (IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1) ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  453. AFF: 0
  454. TIME: 0.0689
  455. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#60f04742fb38da8d18a91e36baec2f26#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  456. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  457. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#2eec745392c32fe62ff8e321b776ac26#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  458. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default#2eec745392c32fe62ff8e321b776ac26#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  459. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  460. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  461. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  462. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  463. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  464. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  465.  
  466.  
  467. ## 2013-08-31 15:27:35
  468. ## 10156 ## QUERY
  469. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, 0 AS `qty`, LEAST(MAX(IF(IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1 AND le.required_options = 0, i.stock_status, 0)), MIN(IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock))) AS `status` FROM `catalog_product_entity` AS `e`
  470.  CROSS JOIN `core_website` AS `cw`
  471.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  472.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  473.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  474.  CROSS JOIN `cataloginventory_stock` AS `cis`
  475.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  476.  LEFT JOIN `catalog_product_super_link` AS `l` ON l.parent_id = e.entity_id
  477.  INNER JOIN `catalog_product_entity` AS `le` ON le.entity_id = l.product_id
  478.  LEFT JOIN `cataloginventory_stock_status_idx` AS `i` ON i.product_id = l.product_id AND cw.website_id = i.website_id AND cis.stock_id = i.stock_id
  479.  LEFT JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  480.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'configurable') GROUP BY `e`.`entity_id`,
  481.     `cw`.`website_id`,
  482.     `cis`.`stock_id` ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  483. AFF: 0
  484. TIME: 0.0022
  485. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  486. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  487. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Configurable[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#83d6d1d0f8b8b74ed7306d51f066c278#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  488. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Configurable[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#83d6d1d0f8b8b74ed7306d51f066c278#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  489. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  490. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  491. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  492. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  493. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  494. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  495.  
  496.  
  497. ## 2013-08-31 15:27:35
  498. ## 10156 ## QUERY
  499. SQL: DELETE FROM `catalog_product_bundle_stock_index`
  500. AFF: 0
  501. TIME: 0.0005
  502. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  503. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  504. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('catalog_product_...') called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:226]
  505. #4 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_cleanBundleOptionStockData() called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:69]
  506. #5 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareBundleOptionStockData(NULL, false) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:133]
  507. #6 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  508. #7 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable(NULL) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:199]
  509. #8 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  510. #9 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  511. #10 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  512. #11 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  513. #12 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  514. #13 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  515. #14 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  516. #15 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  517.  
  518.  
  519. ## 2013-08-31 15:27:35
  520. ## 10156 ## QUERY
  521. SQL: INSERT INTO `catalog_product_bundle_stock_index` SELECT `bo`.`parent_id`, `cw`.`website_id`, `cis`.`stock_id`, `bo`.`option_id`, MAX(IF(e.required_options = 0, i.stock_status, 0)) AS `status` FROM `catalog_product_bundle_option` AS `bo`
  522.  CROSS JOIN `core_website` AS `cw`
  523.  CROSS JOIN `cataloginventory_stock` AS `cis`
  524.  LEFT JOIN `catalog_product_bundle_selection` AS `bs` ON bs.option_id = bo.option_id
  525.  LEFT JOIN `cataloginventory_stock_status_idx` AS `i` ON i.product_id = bs.product_id AND i.website_id = cw.website_id AND i.stock_id = cis.stock_id
  526.  LEFT JOIN `catalog_product_entity` AS `e` ON e.entity_id = bs.product_id WHERE (cw.website_id != 0) AND (bo.required = 1) GROUP BY `bo`.`parent_id`,
  527.     `cw`.`website_id`,
  528.     `cis`.`stock_id`,
  529.     `bo`.`option_id` ON DUPLICATE KEY UPDATE `stock_status` = VALUES(`stock_status`)
  530. AFF: 0
  531. TIME: 0.0011
  532. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  533. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:116]
  534. #3 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareBundleOptionStockData(NULL, false) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:133]
  535. #4 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  536. #5 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable(NULL) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:199]
  537. #6 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  538. #7 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  539. #8 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  540. #9 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  541. #10 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  542. #11 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  543. #12 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  544. #13 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  545.  
  546.  
  547. ## 2013-08-31 15:27:35
  548. ## 10156 ## QUERY
  549. SQL: INSERT INTO `catalog_product_bundle_stock_index` SELECT `bo`.`parent_id`, `cw`.`website_id`, `cis`.`stock_id`, `bo`.`option_id`, MAX(IF(e.required_options = 0, i.stock_status, 0)) AS `status` FROM `catalog_product_bundle_option` AS `bo`
  550.  CROSS JOIN `core_website` AS `cw`
  551.  CROSS JOIN `cataloginventory_stock` AS `cis`
  552.  LEFT JOIN `catalog_product_bundle_selection` AS `bs` ON bs.option_id = bo.option_id
  553.  LEFT JOIN `cataloginventory_stock_status_idx` AS `i` ON i.product_id = bs.product_id AND i.website_id = cw.website_id AND i.stock_id = cis.stock_id
  554.  LEFT JOIN `catalog_product_entity` AS `e` ON e.entity_id = bs.product_id WHERE (cw.website_id != 0) AND (bo.required = 0) GROUP BY `bo`.`parent_id`,
  555.     `cw`.`website_id`,
  556.     `cis`.`stock_id`,
  557.     `bo`.`option_id` HAVING (MAX(IF(e.required_options = 0, i.stock_status, 0)) = 1) ON DUPLICATE KEY UPDATE `stock_status` = VALUES(`stock_status`)
  558. AFF: 0
  559. TIME: 0.0006
  560. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  561. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:119]
  562. #3 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareBundleOptionStockData(NULL, false) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:133]
  563. #4 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_getStockStatusSelect(NULL) called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:210]
  564. #5 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable(NULL) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:199]
  565. #6 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  566. #7 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  567. #8 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  568. #9 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  569. #10 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  570. #11 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  571. #12 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  572. #13 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  573.  
  574.  
  575. ## 2013-08-31 15:27:35
  576. ## 10156 ## QUERY
  577. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, 0 AS `qty`, LEAST(MIN(IF(o.stock_status IS NOT NULL, o.stock_status, 0)), MIN(IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock))) AS `status` FROM `catalog_product_entity` AS `e`
  578.  CROSS JOIN `core_website` AS `cw`
  579.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  580.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  581.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  582.  CROSS JOIN `cataloginventory_stock` AS `cis`
  583.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  584.  LEFT JOIN `catalog_product_bundle_stock_index` AS `o` ON o.entity_id = e.entity_id AND o.website_id = cw.website_id AND o.stock_id = cis.stock_id
  585.  INNER JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  586.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'bundle') AND (IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1) GROUP BY `e`.`entity_id`,
  587.     `cw`.`website_id`,
  588.     `cis`.`stock_id` ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  589. AFF: 0
  590. TIME: 0.0112
  591. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#60f04742fb38da8d18a91e36baec2f26#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  592. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  593. #3 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable(NULL) called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:199]
  594. #4 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  595. #5 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  596. #6 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  597. #7 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  598. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  599. #9 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  600. #10 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  601. #11 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  602.  
  603.  
  604. ## 2013-08-31 15:27:35
  605. ## 10156 ## QUERY
  606. SQL: DELETE FROM `catalog_product_bundle_stock_index`
  607. AFF: 0
  608. TIME: 0.0003
  609. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#850b523110579208c7e39e31d7cec061#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  610. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  611. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('catalog_product_...') called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:226]
  612. #4 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_cleanBundleOptionStockData() called at [app/code/core/Mage/Bundle/Model/Resource/Indexer/Stock.php:200]
  613. #5 Mage_Bundle_Model_Resource_Indexer_Stock#b45301acd7e7dca5f0d25cf3761fb8a6#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  614. #6 Mage_Bundle_Model_Resource_Indexer_Stock[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#b45301acd7e7dca5f0d25cf3761fb8a6#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  615. #7 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  616. #8 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  617. #9 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  618. #10 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  619. #11 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  620. #12 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  621.  
  622.  
  623. ## 2013-08-31 15:27:35
  624. ## 10156 ## QUERY
  625. SQL: INSERT INTO `cataloginventory_stock_status_idx` SELECT `e`.`entity_id`, `cw`.`website_id`, `cis`.`stock_id`, 0 AS `qty`, LEAST(MAX(IF(IF(IFNULL(tas_status.value_id, -1) > 0, tas_status.value, tad_status.value)=1 AND le.required_options = 0, i.stock_status, 0)), MIN(IF(cisi.use_config_manage_stock = 0 AND cisi.manage_stock = 0, 1, cisi.is_in_stock))) AS `status` FROM `catalog_product_entity` AS `e`
  626.  CROSS JOIN `core_website` AS `cw`
  627.  INNER JOIN `core_store_group` AS `csg` ON csg.group_id = cw.default_group_id
  628.  INNER JOIN `core_store` AS `cs` ON cs.store_id = csg.default_store_id
  629.  INNER JOIN `catalog_product_website` AS `pw` ON pw.product_id = e.entity_id AND pw.website_id = cw.website_id
  630.  CROSS JOIN `cataloginventory_stock` AS `cis`
  631.  LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON cisi.stock_id = cis.stock_id AND cisi.product_id = e.entity_id
  632.  LEFT JOIN `catalog_product_link` AS `l` ON e.entity_id = l.product_id AND l.link_type_id=3
  633.  LEFT JOIN `catalog_product_entity` AS `le` ON le.entity_id = l.linked_product_id
  634.  LEFT JOIN `cataloginventory_stock_status_idx` AS `i` ON i.product_id = l.linked_product_id AND cw.website_id = i.website_id AND cis.stock_id = i.stock_id
  635.  LEFT JOIN `catalog_product_entity_int` AS `tad_status` ON tad_status.entity_id = e.entity_id AND tad_status.attribute_id = 273 AND tad_status.store_id = 0
  636.  LEFT JOIN `catalog_product_entity_int` AS `tas_status` ON tas_status.entity_id = e.entity_id AND tas_status.attribute_id = 273 AND tas_status.store_id = cs.store_id WHERE (cw.website_id != 0) AND (e.type_id = 'grouped') GROUP BY `e`.`entity_id`,
  637.     `cw`.`website_id`,
  638.     `cis`.`stock_id` ON DUPLICATE KEY UPDATE `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  639. AFF: 0
  640. TIME: 0.0099
  641. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  642. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:212]
  643. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Grouped[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#09062ffe8a786a973fbf5225758e9911#->_prepareIndexTable() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock/Default.php:72]
  644. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock_Grouped[Mage_CatalogInventory_Model_Resource_Indexer_Stock_Default]#09062ffe8a786a973fbf5225758e9911#->reindexAll() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:248]
  645. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  646. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  647. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  648. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  649. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  650. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  651.  
  652.  
  653. ## 2013-08-31 15:27:35
  654. ## 10156 ## QUERY
  655. SQL: DELETE FROM `cataloginventory_stock_status`
  656. AFF: 17354
  657. TIME: 0.2781
  658. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  659. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  660. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('cataloginventory...') called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:112]
  661. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Index_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->syncData() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:251]
  662. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  663. #6 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  664. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  665. #8 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  666. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  667. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  668.  
  669.  
  670. ## 2013-08-31 15:27:36
  671. ## 10156 ## QUERY
  672. SQL: INSERT INTO `cataloginventory_stock_status` (`product_id`, `website_id`, `stock_id`, `qty`, `stock_status`) SELECT `cataloginventory_stock_status_idx`.`product_id`, `cataloginventory_stock_status_idx`.`website_id`, `cataloginventory_stock_status_idx`.`stock_id`, `cataloginventory_stock_status_idx`.`qty`, `cataloginventory_stock_status_idx`.`stock_status` FROM `cataloginventory_stock_status_idx` ON DUPLICATE KEY UPDATE `product_id` = VALUES(`product_id`), `website_id` = VALUES(`website_id`), `stock_id` = VALUES(`stock_id`), `qty` = VALUES(`qty`), `stock_status` = VALUES(`stock_status`)
  673. AFF: 17354
  674. TIME: 0.5357
  675. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  676. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:179]
  677. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Index_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->insertFromSelect(&Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#, 'cataloginventory...', array('product_id', 'website_id', 'stock_id', 'qty', 'stock_status'), false) called at [app/code/core/Mage/Index/Model/Resource/Helper/Mysql4.php:48]
  678. #4 Mage_Index_Model_Resource_Helper_Mysql4#3d33a1945486ae6e98e1b11b0757dd73#->insertData(&Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#, &Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#, 'cataloginventory...', array('product_id', 'website_id', 'stock_id', 'qty', 'stock_status'), false) called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:153]
  679. #5 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Index_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->insertFromTable('cataloginventory...', 'cataloginventory...', false) called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:113]
  680. #6 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Index_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->syncData() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:251]
  681. #7 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  682. #8 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  683. #9 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  684. #10 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  685. #11 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  686. #12 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  687.  
  688.  
  689. ## 2013-08-31 15:27:36
  690. ## 10156 ## TRANSACTION COMMIT
  691. TIME: 0.0083
  692. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(1, 'COMMIT') called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:237]
  693. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->commit() called at [app/code/core/Mage/Core/Model/Resource/Abstract.php:100]
  694. #3 Mage_CatalogInventory_Model_Resource_Indexer_Stock[Mage_Core_Model_Resource_Abstract]#120531dc3b5fa4e0a7a1bdd820988e2f#->commit() called at [app/code/core/Mage/CatalogInventory/Model/Resource/Indexer/Stock.php:252]
  695. #4 Mage_CatalogInventory_Model_Resource_Indexer_Stock#120531dc3b5fa4e0a7a1bdd820988e2f#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  696. #5 Mage_CatalogInventory_Model_Indexer_Stock[Mage_Index_Model_Indexer_Abstract]#01827b262c8af5e3646a2cd8a98985d6#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  697. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  698. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  699. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  700. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  701.  
  702.  
  703. ## 2013-08-31 15:27:36
  704. ## 10156 ## QUERY
  705. SQL: SELECT `index_process_event`.* FROM `index_process_event` WHERE (process_id = '13') AND (status = 'new')
  706. AFF: 0
  707. TIME: 0.0004
  708. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `index_pr...', array(), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  709. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  710. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll(&Varien_Db_Select#325ab2d1aac515f04e360fb11e6ab67c#) called at [app/code/core/Mage/Index/Model/Resource/Event.php:146]
  711. #4 Mage_Index_Model_Resource_Event#80fd6a2d17204d1ae8252404c1b2580d#->getUnprocessedEvents(&Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#) called at [app/code/core/Mage/Index/Model/Process.php:213]
  712. #5 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  713. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  714. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  715. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  716.  
  717.  
  718. ## 2013-08-31 15:27:36
  719. ## 10156 ## QUERY
  720. SQL: UPDATE `index_process` SET `status` = ?, `ended_at` = ? WHERE (process_id='13')
  721. BIND: array (
  722.   0 => 'pending',
  723.   1 => '2013-08-31 15:27:36',
  724. )
  725. AFF: 1
  726. TIME: 0.0013
  727. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('pending', '2013-08-31 15:27...'), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  728. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('pending', '2013-08-31 15:27...')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  729. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process', array('status' => 'pending', 'ended_at' => '2013-08-31 15:27...'), array('process_id=?' => 13)) called at [app/code/core/Mage/Index/Model/Resource/Process.php:137]
  730. #4 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->_updateProcessData(13, array('status' => 'pending', 'ended_at' => '2013-08-31 15:27...')) called at [app/code/core/Mage/Index/Model/Resource/Process.php:77]
  731. #5 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->endProcess(&Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#) called at [app/code/core/Mage/Index/Model/Process.php:217]
  732. #6 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  733. #7 Mage_Index_Model_Process#ffd9f576a87987898b88f303f19d2d10#->reindexEverything() called at [app/code/core/Mage/Index/Model/Process.php:249]
  734. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  735. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  736.  
  737.  
  738. ## 2013-08-31 15:27:36
  739. ## 10156 ## QUERY
  740. SQL: UPDATE `index_process` SET `status` = ?, `started_at` = ? WHERE (process_id='2')
  741. BIND: array (
  742.   0 => 'working',
  743.   1 => '2013-08-31 15:27:36',
  744. )
  745. AFF: 1
  746. TIME: 0.0013
  747. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('working', '2013-08-31 15:27...'), &Varien_Db_Statement_Pdo_Mysql#fe41641b1c485fda5a690d0c2c7c37d7#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  748. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('working', '2013-08-31 15:27...')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  749. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process', array('status' => 'working', 'started_at' => '2013-08-31 15:27...'), array('process_id=?' => 2)) called at [app/code/core/Mage/Index/Model/Resource/Process.php:137]
  750. #4 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->_updateProcessData(2, array('status' => 'working', 'started_at' => '2013-08-31 15:27...')) called at [app/code/core/Mage/Index/Model/Resource/Process.php:93]
  751. #5 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->startProcess(&Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#) called at [app/code/core/Mage/Index/Model/Process.php:187]
  752. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  753. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  754. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  755.  
  756.  
  757. ## 2013-08-31 15:27:36
  758. ## 10156 ## QUERY
  759. SQL: SELECT `main_table`.*, `process_event`.`status` AS `process_event_status` FROM `index_event` AS `main_table`
  760.  INNER JOIN `index_process_event` AS `process_event` ON process_event.event_id=main_table.event_id WHERE (process_event.process_id = '2') AND (process_event.status = 'new')
  761. AFF: 0
  762. TIME: 0.0294
  763. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `main_tab...', array(), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  764. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('SELECT `main_tab...', array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  765. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll('SELECT `main_tab...', array()) called at [lib/Varien/Data/Collection/Db.php:734]
  766. #4 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection_Db]#fe41641b1c485fda5a690d0c2c7c37d7#->_fetchAll('SELECT `main_tab...', array()) called at [app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php:521]
  767. #5 Mage_Index_Model_Resource_Event_Collection[Mage_Core_Model_Resource_Db_Collection_Abstract]#fe41641b1c485fda5a690d0c2c7c37d7#->getData() called at [lib/Varien/Data/Collection/Db.php:566]
  768. #6 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection_Db]#fe41641b1c485fda5a690d0c2c7c37d7#->load() called at [lib/Varien/Data/Collection.php:752]
  769. #7 Mage_Index_Model_Resource_Event_Collection[Varien_Data_Collection]#fe41641b1c485fda5a690d0c2c7c37d7#->count() called at [app/code/core/Mage/Index/Model/Process.php:195]
  770. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  771. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  772. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  773.  
  774.  
  775. ## 2013-08-31 15:27:36
  776. ## 10156 ## QUERY
  777. SQL: UPDATE `index_process_event` SET `status` = ? WHERE (process_id = '2')
  778. BIND: array (
  779.   0 => 'done',
  780. )
  781. AFF: 0
  782. TIME: 0.0458
  783. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('done'), &Varien_Db_Statement_Pdo_Mysql#325ab2d1aac515f04e360fb11e6ab67c#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  784. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('done')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  785. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process_ev...', array('status' => 'done'), array('process_id = ?' => 2)) called at [app/code/core/Mage/Index/Model/Resource/Event.php:129]
  786. #4 Mage_Index_Model_Resource_Event#80fd6a2d17204d1ae8252404c1b2580d#->updateProcessEvents(&Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#) called at [app/code/core/Mage/Index/Model/Process.php:208]
  787. #5 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  788. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  789. #7 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  790.  
  791.  
  792. ## 2013-08-31 15:27:36
  793. ## 10156 ## TRANSACTION BEGIN
  794. TIME: 0.0001
  795. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(1, 'BEGIN') called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:221]
  796. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->beginTransaction() called at [app/code/core/Mage/Core/Model/Resource/Abstract.php:76]
  797. #3 Mage_Catalog_Model_Resource_Product_Indexer_Price[Mage_Core_Model_Resource_Abstract]#d290d4b6668544e9823c5f000a183262#->beginTransaction() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:375]
  798. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  799. #5 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  800. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  801. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  802. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  803.  
  804.  
  805. ## 2013-08-31 15:27:39
  806. ## 10156 ## QUERY
  807. SQL: DELETE FROM `catalog_product_index_price_idx`
  808. AFF: 125769
  809. TIME: 3.4800
  810. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#60f04742fb38da8d18a91e36baec2f26#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  811. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  812. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('catalog_product_...') called at [app/code/core/Mage/Index/Model/Resource/Abstract.php:235]
  813. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price[Mage_Index_Model_Resource_Abstract]#d290d4b6668544e9823c5f000a183262#->clearTemporaryIndexTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:377]
  814. #5 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  815. #6 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  816. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  817. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  818. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  819.  
  820.  
  821. ## 2013-08-31 15:27:39
  822. ## 10156 ## QUERY
  823. SQL: SELECT `cw`.`website_id`, `csg`.`default_store_id` AS `store_id` FROM `core_website` AS `cw`
  824.  INNER JOIN `core_store_group` AS `csg` ON cw.default_group_id = csg.group_id WHERE (cw.website_id != 0)
  825. AFF: 3
  826. TIME: 0.0007
  827. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `cw`.`web...', array(), &Varien_Db_Statement_Pdo_Mysql#5f398253079bec1851e59af96569b3da#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  828. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#60f04742fb38da8d18a91e36baec2f26#, array()) called at [lib/Zend/Db/Adapter/Abstract.php:734]
  829. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchAll(&Varien_Db_Select#60f04742fb38da8d18a91e36baec2f26#) called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:567]
  830. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareWebsiteDateTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:378]
  831. #5 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  832. #6 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  833. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  834. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  835. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  836.  
  837.  
  838. ## 2013-08-31 15:27:39
  839. ## 10156 ## QUERY
  840. SQL: SELECT `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to)
  841. BIND: array (
  842.   ':currency_from' => 'USD',
  843.   ':currency_to' => 'IDR',
  844. )
  845. AFF: 1
  846. TIME: 0.0005
  847. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `director...', array(':currency_from' => 'USD', ':currency_to' => 'IDR'), &Varien_Db_Statement_Pdo_Mysql#6fe92c956800f908d795e6ed5ead42d0#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  848. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#2473675206a68ada24510a7883a86d67#, array(':currency_from' => 'USD', ':currency_to' => 'IDR')) called at [lib/Zend/Db/Adapter/Abstract.php:825]
  849. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchOne(&Varien_Db_Select#2473675206a68ada24510a7883a86d67#, array(':currency_from' => 'USD', ':currency_to' => 'IDR')) called at [app/code/core/Mage/Directory/Model/Resource/Currency.php:93]
  850. #4 Mage_Directory_Model_Resource_Currency#17f2c83f1691fb866ca4ee44f34a399d#->getRate('USD', 'IDR') called at [app/code/core/Mage/Directory/Model/Currency.php:126]
  851. #5 Mage_Directory_Model_Currency#5f398253079bec1851e59af96569b3da#->getRate('IDR') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:574]
  852. #6 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareWebsiteDateTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:378]
  853. #7 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  854. #8 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  855. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  856. #10 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  857. #11 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  858.  
  859.  
  860. ## 2013-08-31 15:27:39
  861. ## 10156 ## QUERY
  862. SQL: SELECT `directory_currency_rate`.`rate` FROM `directory_currency_rate` WHERE (currency_from = :currency_from) AND (currency_to = :currency_to)
  863. BIND: array (
  864.   ':currency_from' => 'USD',
  865.   ':currency_to' => 'MYR',
  866. )
  867. AFF: 1
  868. TIME: 0.0005
  869. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'SELECT `director...', array(':currency_from' => 'USD', ':currency_to' => 'MYR'), &Varien_Db_Statement_Pdo_Mysql#6fe92c956800f908d795e6ed5ead42d0#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  870. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query(&Varien_Db_Select#2473675206a68ada24510a7883a86d67#, array(':currency_from' => 'USD', ':currency_to' => 'MYR')) called at [lib/Zend/Db/Adapter/Abstract.php:825]
  871. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->fetchOne(&Varien_Db_Select#2473675206a68ada24510a7883a86d67#, array(':currency_from' => 'USD', ':currency_to' => 'MYR')) called at [app/code/core/Mage/Directory/Model/Resource/Currency.php:93]
  872. #4 Mage_Directory_Model_Resource_Currency#17f2c83f1691fb866ca4ee44f34a399d#->getRate('USD', 'MYR') called at [app/code/core/Mage/Directory/Model/Currency.php:126]
  873. #5 Mage_Directory_Model_Currency#5f398253079bec1851e59af96569b3da#->getRate('MYR') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:574]
  874. #6 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareWebsiteDateTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:378]
  875. #7 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  876. #8 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  877. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  878. #10 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  879. #11 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  880.  
  881.  
  882. ## 2013-08-31 15:27:39
  883. ## 10156 ## QUERY
  884. SQL: DELETE FROM `catalog_product_index_website`
  885. AFF: 3
  886. TIME: 0.0010
  887. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#e4e5542d4c52769833e8a2cde2893412#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  888. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  889. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('catalog_product_...') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:596]
  890. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareWebsiteDateTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:378]
  891. #5 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  892. #6 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  893. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  894. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  895. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  896.  
  897.  
  898. ## 2013-08-31 15:27:39
  899. ## 10156 ## QUERY
  900. SQL: INSERT INTO `catalog_product_index_website` (`website_id`,`website_date`,`rate`) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?)
  901. BIND: array (
  902.   0 => '1',
  903.   1 => '2013-08-31',
  904.   2 => 1,
  905.   3 => '2',
  906.   4 => '2013-08-31',
  907.   5 => '9597.000000000000',
  908.   6 => '3',
  909.   7 => '2013-08-31',
  910.   8 => '3.057500000000',
  911. )
  912. AFF: 3
  913. TIME: 0.0014
  914. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array(1, '2013-08-31', 1, 2, '2013-08-31', 9597.000000000000, 3, '2013-08-31', 3.057500000000), &Varien_Db_Statement_Pdo_Mysql#e4e5542d4c52769833e8a2cde2893412#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  915. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...', array(1, '2013-08-31', 1, 2, '2013-08-31', 9597.000000000000, 3, '2013-08-31', 3.057500000000)) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:1975]
  916. #3 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->insertArray('catalog_product_...', array('website_id', 'website_date', 'rate'), array(array(1, '2013-08-31', 1), array(2, '2013-08-31', 9597.000000000000), array(3, '2013-08-31', 3.057500000000))) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:1948]
  917. #4 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->insertMultiple('catalog_product_...', array(array('website_id' => 1, 'website_date' => '2013-08-31', 'rate' => 1), array('website_id' => 2, 'website_date' => '2013-08-31', 'rate' => 9597.000000000000), array('website_id' => 3, 'website_date' => '2013-08-31', 'rate' => 3.057500000000))) called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:599]
  918. #5 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareWebsiteDateTable() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:378]
  919. #6 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  920. #7 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  921. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  922. #9 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  923. #10 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  924.  
  925.  
  926. ## 2013-08-31 15:27:39
  927. ## 10156 ## QUERY
  928. SQL: DELETE FROM `catalog_product_index_tier_price`
  929. AFF: 0
  930. TIME: 0.0003
  931. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'DELETE FROM `cat...', array(), &Varien_Db_Statement_Pdo_Mysql#d3314ea7a8e92996785fa5797ecbad96#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  932. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('DELETE FROM `cat...') called at [lib/Zend/Db/Adapter/Abstract.php:661]
  933. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->delete('catalog_product_...') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:427]
  934. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareTierPriceIndex() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:379]
  935. #5 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  936. #6 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  937. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  938. #8 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  939. #9 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  940.  
  941.  
  942. ## 2013-08-31 15:27:39
  943. ## 10156 ## QUERY
  944. SQL: INSERT INTO `catalog_product_index_tier_price` SELECT `tp`.`entity_id`, `cg`.`customer_group_id`, `cw`.`website_id`, MIN(IF(tp.website_id = 0, ROUND(tp.value * cwd.rate, 4), tp.value)) FROM `catalog_product_entity_tier_price` AS `tp`
  945.  INNER JOIN `customer_group` AS `cg` ON tp.all_groups = 1 OR (tp.all_groups = 0 AND tp.customer_group_id = cg.customer_group_id)
  946.  INNER JOIN `core_website` AS `cw` ON tp.website_id = 0 OR tp.website_id = cw.website_id
  947.  INNER JOIN `catalog_product_index_website` AS `cwd` ON cw.website_id = cwd.website_id WHERE (cw.website_id != 0) GROUP BY `tp`.`entity_id`,
  948.     `cg`.`customer_group_id`,
  949.     `cw`.`website_id` ON DUPLICATE KEY UPDATE `min_price` = VALUES(`min_price`)
  950. TIME: 0.0031
  951. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'INSERT INTO `cat...', array()) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:422]
  952. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('INSERT INTO `cat...') called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:455]
  953. #3 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->_prepareTierPriceIndex() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:379]
  954. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  955. #5 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  956. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  957. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  958. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  959.  
  960.  
  961. ## 2013-08-31 15:27:39
  962. EXCEPTION
  963. exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`pikomik_magento/catalog_product_index_tier_price`, CONSTRAINT `FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_i)' in /home/pikomik/public_html/lib/Zend/Db/Statement/Pdo.php:228
  964. Stack trace:
  965. #0 /home/pikomik/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
  966. #1 /home/pikomik/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
  967. #2 /home/pikomik/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
  968. #3 /home/pikomik/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
  969. #4 /home/pikomik/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
  970. #5 /home/pikomik/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(420): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
  971. #6 /home/pikomik/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
  972. #7 /home/pikomik/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prepareTierPriceIndex()
  973. #8 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
  974. #9 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
  975. #10 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
  976. #11 /home/pikomik/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
  977. #12 /home/pikomik/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
  978. #13 {main}
  979.  
  980. Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`pikomik_magento/catalog_product_index_tier_price`, CONSTRAINT `FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_i)' in /home/pikomik/public_html/lib/Zend/Db/Statement/Pdo.php:234
  981. Stack trace:
  982. #0 /home/pikomik/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
  983. #1 /home/pikomik/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
  984. #2 /home/pikomik/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
  985. #3 /home/pikomik/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
  986. #4 /home/pikomik/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(420): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
  987. #5 /home/pikomik/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
  988. #6 /home/pikomik/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prepareTierPriceIndex()
  989. #7 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
  990. #8 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
  991. #9 /home/pikomik/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
  992. #10 /home/pikomik/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
  993. #11 /home/pikomik/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
  994. #12 {main}
  995.  
  996. ## 2013-08-31 15:27:43
  997. ## 10156 ## TRANSACTION ROLLBACK
  998. TIME: 3.3697
  999. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(1, 'ROLLBACK') called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:253]
  1000. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->rollback() called at [app/code/core/Mage/Core/Model/Resource/Abstract.php:124]
  1001. #3 Mage_Catalog_Model_Resource_Product_Indexer_Price[Mage_Core_Model_Resource_Abstract]#d290d4b6668544e9823c5f000a183262#->rollBack() called at [app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php:391]
  1002. #4 Mage_Catalog_Model_Resource_Product_Indexer_Price#d290d4b6668544e9823c5f000a183262#->reindexAll() called at [app/code/core/Mage/Index/Model/Indexer/Abstract.php:143]
  1003. #5 Mage_Catalog_Model_Product_Indexer_Price[Mage_Index_Model_Indexer_Abstract]#43ebcf3bfe4da34c4ca5a6c876f41c4c#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:209]
  1004. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  1005. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  1006. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
  1007.  
  1008.  
  1009. ## 2013-08-31 15:27:43
  1010. ## 10156 ## QUERY
  1011. SQL: UPDATE `index_process` SET `status` = ?, `ended_at` = ? WHERE (process_id='2')
  1012. BIND: array (
  1013.   0 => 'require_reindex',
  1014.   1 => '2013-08-31 15:27:43',
  1015. )
  1016. AFF: 1
  1017. TIME: 0.0022
  1018. TRACE: #1 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->_debugStat(2, 'UPDATE `index_pr...', array('require_reindex', '2013-08-31 15:27...'), &Varien_Db_Statement_Pdo_Mysql#5f398253079bec1851e59af96569b3da#) called at [lib/Varien/Db/Adapter/Pdo/Mysql.php:425]
  1019. #2 Varien_Db_Adapter_Pdo_Mysql#bf20a25b9d4d1869ce848b400ff3955b#->query('UPDATE `index_pr...', array('require_reindex', '2013-08-31 15:27...')) called at [lib/Zend/Db/Adapter/Abstract.php:632]
  1020. #3 Varien_Db_Adapter_Pdo_Mysql[Zend_Db_Adapter_Abstract]#bf20a25b9d4d1869ce848b400ff3955b#->update('index_process', array('status' => 'require_reindex', 'ended_at' => '2013-08-31 15:27...'), array('process_id=?' => 2)) called at [app/code/core/Mage/Index/Model/Resource/Process.php:137]
  1021. #4 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->_updateProcessData(2, array('status' => 'require_reindex', 'ended_at' => '2013-08-31 15:27...')) called at [app/code/core/Mage/Index/Model/Resource/Process.php:109]
  1022. #5 Mage_Index_Model_Resource_Process#e068e61fb899a7e3bbe3a82a17108cbb#->failProcess(&Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#) called at [app/code/core/Mage/Index/Model/Process.php:221]
  1023. #6 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexAll() called at [app/code/core/Mage/Index/Model/Process.php:255]
  1024. #7 Mage_Index_Model_Process#b59f47d5fcf9677ff54b50c936de9de9#->reindexEverything() called at [shell/indexer.php:158]
  1025. #8 Mage_Shell_Compiler#92ed897b8db83c60430eaccb7c46ef9c#->run() called at [shell/indexer.php:198]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!