1

My product list page is very slow as I have customized things and use custom phtml for that, I have enabled the profiler and found this:

Memory usage: real: 78643200, emalloc: 49273704

Code Profiler   Time    Cnt Emalloc RealMem
mage    18.9151 1   0   0
mage::app::init::system_config  0.0012  1   27,520  0
CORE::create_object_of::Mage_Core_Model_Cache   0.0005  1   94,224  0
mage::app::init::config::load_cache 0.0164  1   1,784   0
mage::app::init::stores 0.0213  1   1,167,712   1,310,720
CORE::create_object_of::Mage_Core_Model_Resource_Website    0.0002  1   23,496  0
CORE::create_object_of::Mage_Core_Model_Resource_Website_Collection 0.0110  1   488,808 524,288
DISPATCH EVENT:resource_get_tablename   0.0110  1100    56,272  0
DISPATCH EVENT:core_collection_abstract_load_after  0.0064  9   920 0
init_config_section:stores_default  0.0051  1   2,144   0
mage::app::init_front_controller    0.0119  1   243,976 0
mage::app::init_front_controller::collect_routers   0.0107  1   134,912 0
DISPATCH EVENT:controller_front_init_routers    0.0010  1   95,544  0
CORE::create_object_of::Mage_Core_Model_Url_Rewrite_Request 0.0002  1   44,248  0
CORE::create_object_of::Mage_Core_Model_Url_Rewrite 0.0008  47  27,032  0
mage::dispatch::db_url_rewrite  0.0074  1   45,872  0
DISPATCH EVENT:model_load_after 0.0072  251 12,504  0
DISPATCH EVENT:core_abstract_load_after 0.0004  60  3,352   0
mage::dispatch::routers_match   18.8396 1   0   0
mage::dispatch::controller::action::predispatch 0.2293  1   1,024,568   786,432
CORE::create_object_of::Mage_Core_Model_Layout  0.0003  1   33,184  0
CORE::create_object_of::Mage_Core_Model_Session 0.0077  2   53,472  0
Mage_Core_Model_Session_Abstract_Varien::start/start    0.0017  1   10,528  0
mage::dispatch::controller::action::predispatch::load_area::frontend::design    0.0074  1   123,544 262,144
CORE::create_object_of::Mage_Core_Model_Design_Package  0.0005  1   29,688  0
mage::dispatch::controller::action::predispatch::load_area::frontend::translate 0.0010  1   64,336  0
DISPATCH EVENT:controller_action_predispatch    0.2130  1   668,384 524,288
OBSERVER: clearandfizzy_enhancedcms_feed    0.0006  1   86,472  0
OBSERVER: ophirah_qquoteadv 0.0002  1   17,368  0
OBSERVER: log   0.2088  1   193,288 262,144
CORE::create_object_of::Mage_Log_Model_Visitor  0.0044  1   36,616  0
OBSERVER: pagecache 0.0007  1   18,920  0
OBSERVER: persistent    0.0010  3   181,784 262,144
OBSERVER: persistent_quote  0.0006  1   130,320 0
CORE::create_object_of::Mage_Customer_Model_Session 0.0004  1   80,816  0
mage::dispatch::controller::action::catalog_category_view   18.6098 1   0   0
CORE::create_object_of::Mage_Catalog_Model_Category 0.0032  114 104,840 0
CORE::create_object_of::Mage_Catalog_Model_Resource_Category    0.0045  1   96,984  262,144
EAV: Mage_Eav_Model_Config::getEntityType   0.0100  231 115,064 0
DISPATCH EVENT:model_load_before    0.0023  247 12,440  0
DISPATCH EVENT:catalog_category_load_before 0.0020  112 5,848   0
__EAV_LOAD_MODEL__  4.2640  190 19,415,008  4,194,304
CORE::create_object_of::Mage_Catalog_Model_Resource_Category_Attribute_Collection   0.0013  2   48,328  262,144
CORE::create_object_of::Mage_Catalog_Model_Resource_Eav_Attribute   0.0012  140 92,352  0
EAV: Mage_Eav_Model_Config::getAttribute    0.0071  180 43,648  0
__EAV_LOAD_MODEL_ATTRIBUTES__   2.0602  190 18,576,912  524,288
CORE::create_object_of::Mage_Eav_Model_Entity_Attribute_Backend_Default 0.0002  81  16,984  0
__EAV_LOAD_MODEL_AFTER_LOAD__   1.7099  190 5,359,920   2,097,152
DISPATCH EVENT:catalog_category_load_after  0.0050  112 5,848   0
CORE::create_object_of::Mage_Catalog_Model_Resource_Category_Collection 0.0012  3   27,896  0
__EAV_COLLECTION_BEFORE_LOAD__  0.0011  19  6,472   0
DISPATCH EVENT:eav_collection_abstract_load_before  0.0004  19  1,400   0
__EAV_COLLECTION_LOAD_ENT__ 1.2535  19  23,477,232  24,117,248
__EAV_COLLECTION_LOAD_ATTR__    1.1862  19  8,286,640   29,622,272
__EAV_COLLECTION_ORIG_DATA__    0.0118  19  1,128   0
__EAV_COLLECTION_AFTER_LOAD__   0.5069  19  6,504,168   524,288
DISPATCH EVENT:controller_action_layout_load_before 0.0011  1   10,880  0
mage::dispatch::controller::action::catalog_category_view::layout_load  0.1046  1   119,896 262,144
layout/package_update: default  0.0203  1   28,872  0
layout/db_update: default   18.5108 1   0   0
CORE::create_object_of::Mage_Core_Model_Resource_Layout 0.0002  12  6,144   0
layout/db_update: catalog_category_layered_nochildren   18.5044 1   0   0
layout/db_update: STORE_default 18.5012 1   0   0
layout/db_update: THEME_frontend_sterling_default   18.4961 1   0   0
layout/db_update: catalog_category_view 18.4929 1   0   0
layout/package_update: catalog_category_layered 0.0395  1   25,616  0
layout/db_update: SHORTCUT_popup    18.4834 1   0   0
layout/db_update: SHORTCUT_uk_popup 18.4703 1   0   0
layout/db_update: product_list  18.4602 1   0   0
layout/db_update: lot_lot_category  18.4530 1   0   0
layout/db_update: catalog_category_layered  18.4454 1   0   0
layout/db_update: CATEGORY_137  18.4368 1   0   0
layout/db_update: customer_logged_out   18.4329 1   0   0
mage::dispatch::controller::action::catalog_category_view::layout_generate_xml  0.0028  1   552 0
mage::dispatch::controller::action::catalog_category_view::layout_generate_blocks   0.4341  1   9,526,104   10,223,616
BLOCK: formkey  0.0015  1   261,448 262,144
DISPATCH EVENT:core_block_abstract_prepare_layout_before    0.0012  137 7,080   0
DISPATCH EVENT:core_block_abstract_prepare_layout_after 0.0356  137 140,224 1,048,576
OBSERVER: M2ePro_observer_view_order    0.0033  137 29,784  0
OBSERVER: M2ePro_observer_view_shipment_before  0.0053  137 18,872  0
OBSERVER: productedit   0.0099  137 24,672  0
OBSERVER: customercredit    0.0012  137 18,768  0
OBSERVER: sunarc_hidetab    0.0036  137 122,544 262,144
CORE::create_object_of::Mage_Admin_Model_Session    0.0003  1   54,288  0
CORE::create_object_of::Mage_Admin_Model_Redirectpolicy 0.0001  1   47,624  0
DISPATCH EVENT:core_layout_block_create_after   0.0009  136 7,256   0
BLOCK: root 0.0088  1   72,304  0
BLOCK: head 0.0005  1   74,888  0
BLOCK ACTION: head -> addJs 0.0001  14  21,568  0
BLOCK: js_cookies   0.0005  1   68,032  262,144
BLOCK ACTION: head -> addItem   0.0006  21  38,112  0
BLOCK: head.viewport    0.0006  1   57,360  0
BLOCK: after_body_start 0.0004  1   57,440  0
BLOCK: global_notices   0.0078  1   66,368  0
BLOCK: header   0.0005  1   67,256  262,144
BLOCK: store_language   0.0005  1   69,672  0
BLOCK: catalog.topnav   0.0009  1   304,560 262,144
BLOCK: catalog.topnav.renderer  0.0007  1   181,120 262,144
BLOCK: top.container    0.0004  1   57,880  0
BLOCK: welcome  0.0004  1   65,520  0
BLOCK: breadcrumbs  0.0004  1   66,536  0
BLOCK: left_first   0.0034  1   1,312   262,144
BLOCK: global_messages  0.0007  1   82,752  0
BLOCK: footer   0.0006  1   102,360 0
BLOCK: global_cookie_notice 0.0004  1   66,216  262,144
BLOCK: core_profiler    0.0004  1   112,416 0
BLOCK: currency 0.0037  1   67,424  0
BLOCK: cms_footer_links 0.0006  1   58,120  262,144
BLOCK: catalog.compare.sidebar  0.0006  1   237,568 0
BLOCK: catalog_product_price_template   0.0004  1   57,192  262,144
BLOCK: checkout_cart_link   0.0004  1   65,848  0
BLOCK ACTION: checkout_cart_link -> addCheckoutLink 0.0003  1   19,600  0
BLOCK: minicart_head    0.0042  1   140,240 262,144
BLOCK: minicart_content 0.0005  1   77,568  0
BLOCK: paypal.partner.top_cart.shortcut 0.0006  1   155,208 0
BLOCK: right.poll   0.0006  1   115,048 0
BLOCK: right.reports.product.compared   0.0005  1   166,544 262,144
BLOCK: google_analytics 0.0004  1   70,600  0
BLOCK: wishlist_link    0.0029  1   140,856 0
BLOCK: wishlist_sidebar 0.0006  1   179,912 262,144
BLOCK: paypaluk.partner.top_cart.shortcut   0.0004  1   67,808  0
BLOCK: head_rss 0.0019  1   124,808 262,144
CORE::create_object_of::Mage_Core_Model_Url 0.0052  247 146,664 0
BLOCK: footer.newsletter    0.0005  1   67,496  0
BLOCK: head.livechat.monitor    0.0004  1   65,384  0
BLOCK ACTION: header -> setTemplate 0.0044  1   38,792  262,144
BLOCK: miniquote_head   0.0006  1   152,312 0
BLOCK: qquoteadv_links  0.0004  1   66,272  0
BLOCK: quote_sidebar    0.0004  1   73,576  262,144
BLOCK ACTION: head -> addCss    0.0003  2   19,936  0
BLOCK:  0.0008  1   68,776  0
BLOCK: left.reports.product.viewed  0.0005  1   86,088  0
BLOCK: catalog.leftnav  0.3192  1   4,187,024   6,029,312
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Collection  0.0180  16  624,144 786,432
DISPATCH EVENT:core_abstract_load_before    0.0004  57  3,208   0
CORE::create_object_of::Mage_Index_Model_Lock_Storage_Db    0.0007  1   30,424  0
DISPATCH EVENT:catalog_product_collection_apply_limitations_before  0.0004  40  2,440   0
DISPATCH EVENT:catalog_product_collection_apply_limitations_after   0.0004  40  2,696   0
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Attribute_Collection    0.0026  3   105,008 0
CORE::create_object_of::Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection  0.0015  3   43,056  0
Mage_Catalog_Model_Layer::getState  0.0001  1   23,744  0
BLOCK: catalog.leftnav.state.renderers  0.0014  1   1,800   0
BLOCK: category.products    0.0249  1   183,632 0
REWRITE: Mage_Catalog_Model_Category_Url::getCategoryUrl    0.0326  7   60,160  0
BLOCK: product_list 0.0006  1   91,008  0
BLOCK: product_list_toolbar 0.0059  1   94,304  0
BLOCK: product_list_toolbar_pager   0.0008  1   89,272  0
BLOCK: paypal.partner.right.logo    0.0004  1   65,904  0
BLOCK: bml.center.logo  0.0052  1   67,248  0
BLOCK: configurableswatches.media.js.list   0.0009  1   135,968 0
BLOCK: category.info.lots   0.0005  1   66,160  0
BLOCK: sale.reorder.sidebar 0.0040  1   68,384  0
DISPATCH EVENT:controller_action_layout_generate_blocks_after   0.0009  1   73,936  0
OBSERVER: configurableswatches  0.0092  158 98,752  0
mage::dispatch::controller::action::catalog_category_view::layout_render    17.9900 1   0   0
DISPATCH EVENT:core_block_abstract_to_html_before   0.0061  78  7,160   0
OBSERVER: qquoteadv_class_listener  0.0014  78  10,824  0
Mage_Core_Model_Design_Package::getFilename 0.0056  60  66,984  0
frontend/sterling/default/template/page/1column.phtml   17.9887 1   0   0
frontend/sterling/default/template/page/html/head.phtml 0.0400  1   346,192 0
Mage_Core_Model_Design_Package::getSkinUrl  0.0198  137 157,280 0
DISPATCH EVENT:core_block_abstract_to_html_after    0.0137  76  18,256  0
OBSERVER: M2ePro_observer_view_shipment_after   0.0018  76  17,240  0
OBSERVER: apptrian_minify_core_block_abstract_to_html_after 0.0014  76  25,456  0
frontend/base/default/template/directory/js/optional_zip_countries.phtml    0.0004  1   26,968  0
frontend/base/default/template/googleanalytics/ga.phtml 0.0006  1   19,560  0
frontend/sterling/default/template/qquoteadv/page/html/header.phtml 0.7145  1   2,927,056   3,145,728
CORE::create_object_of::Mage_Widget_Model_Template_Filter   0.0006  6   86,816  0
frontend/sterling/default/template/checkout/cart/minicart.phtml 0.0096  1   63,480  262,144
frontend/sterling/default/template/webandpeople/custommenu/top.phtml    0.6426  1   2,312,672   2,621,440
frontend/sterling/default/template/catalogsearch/form.mini.phtml    0.0020  2   47,960  0
frontend/base/default/template/catalog/category/view.phtml  17.2045 1   29,815,576  58,458,112
DISPATCH EVENT:catalog_helper_output_construct  0.0004  1   21,144  0
OBSERVER: jvs_fileattribute 0.0003  1   18,096  0
DISPATCH EVENT:catalog_block_product_list_collection    0.8719  1   17,649,664  18,350,080
OBSERVER: review    0.8716  1   17,645,296  18,350,080
DISPATCH EVENT:catalog_product_collection_load_before   0.0002  16  1,504   0
DISPATCH EVENT:catalog_product_collection_load_after    0.2589  8   6,194,032   262,144
OBSERVER: inventory 0.4556  86  4,353,792   262,144
OBSERVER: tax   0.0023  8   74,000  0
OBSERVER: bundle_observer   0.0121  8   80,416  0
frontend/sterling/default/template/qquoteadv/catalog/product/list.phtml 16.3058 1   29,806,776  46,137,344
EAV: Mage_Eav_Model_Config::_initAttributes 0.0115  2   934,320 786,432
CORE::create_object_of::Inchoo_CustomLinkedProducts_Model_Catalog_Product   0.0108  80  68,680  0
locale/currency 0.0024  1   75,264  262,144
DISPATCH EVENT:currency_display_options_forming 0.0007  1   43,984  262,144
OBSERVER: mage_currencysymbol_currency_display_options  0.0006  1   41,072  262,144
DISPATCH EVENT:catalog_product_is_salable_before    0.0048  438 21,512  0
DISPATCH EVENT:catalog_product_is_salable_after 0.0040  438 21,512  0
_LOAD_ATTRIBUTE_BY_CODE__   0.0054  1   13,320  0
DISPATCH EVENT:catalog_product_get_final_price  0.0638  39  115,992 0
OBSERVER: catalogrule   0.0613  39  119,736 0
CORE::create_object_of::Mage_CatalogRule_Model_Resource_Rule    0.0010  40  20,712  0
CORE::create_object_of::Mage_CatalogRule_Model_Rule 0.0012  39  28,312  0
CORE::create_object_of::Mage_Catalog_Model_Product_Url  0.0075  693 175,592 0
CORE::create_object_of::Mage_Catalog_Model_Product_Image    0.0004  39  22,360  0
DISPATCH EVENT:catalog_product_load_before  0.0005  78  4,216   0
DISPATCH EVENT:catalog_product_attribute_backend_media_load_gallery_before  0.0062  78  6,296   0
DISPATCH EVENT:catalog_product_load_after   0.2378  78  -1,668,200  0
CORE::create_object_of::Mage_CatalogInventory_Model_Stock_Item  0.0011  39  69,688  0
OBSERVER: qquoteadv_set_allowed_to_quote    0.0041  78  38,432  0
init_config_section:stores_admin    0.0028  1   1,736   0
frontend/sterling/default/template/qquoteadv/catalog/product/c2qBtnList.phtml   1.3172  39  926,688 1,572,864
DISPATCH EVENT:catalog_product_type_prepare_full_options    0.0085  39  10,416  0
OBSERVER: payment_recurring_profile_prepare_options 0.0063  39  17,480  0
CORE::create_object_of::Mage_Catalog_Model_Product_Configuration_Item_Option    0.0005  39  13,936  0
frontend/base/default/template/lot_lot/catalog/category/list/lot.phtml  0.0034  1   100,800 0
CORE::create_object_of::Lot_Lot_Model_Resource_Lot_Collection   0.0005  1   32,832  0
frontend/sterling/default/template/page/html/footer.phtml   0.0219  1   0   0
frontend/sterling/default/template/newsletter/subscribe.phtml   0.0054  1   15,760  0

Can anyone help to analysis it what's going wrong

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.