0item(s)

You have no items in your shopping cart.

Product was successfully added to your shopping cart.

Bear and Ollie’s Pet Shop

Set Ascending Direction

14 Item(s)

Set Ascending Direction

14 Item(s)

[profiler]
Memory usage: real: 26476544, emalloc: 24954648
Code ProfilerTimeCntEmallocRealMem
mage1.2072100
mage::app::init::system_config0.0013127,2800
CORE::create_object_of::Mage_Core_Model_Cache0.00781150,8640
mage::app::init::config::load_cache0.012615520
mage::app::init::stores0.021111,159,5521,310,720
CORE::create_object_of::Mage_Core_Model_Resource_Website0.0001113,0880
CORE::create_object_of::Mage_Core_Model_Resource_Website_Collection0.00711481,056524,288
DISPATCH EVENT:resource_get_tablename0.002725314,4640
DISPATCH EVENT:core_collection_abstract_load_before0.0003392,6160
DISPATCH EVENT:core_collection_abstract_load_after0.0005392,3600
init_config_section:stores_panel_store_view0.004918960
mage::app::init_front_controller0.00441237,7040
DISPATCH EVENT:controller_front_init_before0.0003197,1600
OBSERVER: avatax0.0001146,9440
mage::app::init_front_controller::collect_routers0.00381119,8560
init_config_section:admin0.001815120
CORE::create_object_of::Mage_Core_Model_Url_Rewrite_Request0.0002143,8720
mage::dispatch::db_url_rewrite0.0018137,7680
DISPATCH EVENT:model_load_after0.0010261,7040
DISPATCH EVENT:core_abstract_load_after0.0001181,3360
mage::dispatch::routers_match1.1430100
mage::dispatch::controller::action::predispatch0.02191872,080786,432
CORE::create_object_of::Smartwave_All_Model_Core_Layout0.0003132,8160
CORE::create_object_of::Mage_Core_Model_Session0.0055252,0560
Mage_Core_Model_Session_Abstract_Varien::start/start0.0013110,3200
mage::dispatch::controller::action::predispatch::load_area::frontend::design0.00321118,744262,144
CORE::create_object_of::Mage_Core_Model_Design_Package0.0014128,0880
CORE::create_object_of::Mage_Core_Model_Design_Config0.001211,6640
mage::dispatch::controller::action::predispatch::load_area::frontend::translate0.0021146,5840
DISPATCH EVENT:controller_action_predispatch0.01031513,664524,288
OBSERVER: log0.00751156,056262,144
CORE::create_object_of::Mage_Log_Model_Visitor0.0005135,6800
OBSERVER: pagecache0.0003118,5440
OBSERVER: persistent0.00116180,3600
OBSERVER: persistent_quote0.00061130,720262,144
CORE::create_object_of::Mage_Customer_Model_Session0.0004181,3360
mage::dispatch::controller::action::catalog_category_view1.1201100
CORE::create_object_of::Mage_Catalog_Model_Category0.0003130,2720
CORE::create_object_of::Mage_Catalog_Model_Resource_Category0.0018196,3920
EAV: Mage_Eav_Model_Config::getEntityType0.0066804196,8400
DISPATCH EVENT:model_load_before0.0002211,6160
__EAV_LOAD_MODEL__0.106372,325,4081,572,864
CORE::create_object_of::Mage_Catalog_Model_Resource_Category_Attribute_Collection0.0005140,7600
CORE::create_object_of::Mage_Catalog_Model_Resource_Eav_Attribute0.001114293,480262,144
EAV: Mage_Eav_Model_Config::getAttribute0.003528650,5760
__EAV_LOAD_MODEL_ATTRIBUTES__0.028671,104,736262,144
CORE::create_object_of::Mage_Eav_Model_Entity_Attribute_Backend_Default0.00039018,8560
__EAV_LOAD_MODEL_AFTER_LOAD__0.06137590,712262,144
CORE::create_object_of::Mage_Catalog_Model_Resource_Category_Collection0.0006221,9200
__EAV_COLLECTION_BEFORE_LOAD__0.0006156,0160
DISPATCH EVENT:eav_collection_abstract_load_before0.0002151,2080
__EAV_COLLECTION_LOAD_ENT__0.021815266,560262,144
__EAV_COLLECTION_LOAD_ATTR__0.066515264,912524,288
__EAV_COLLECTION_ORIG_DATA__0.0002159360
__EAV_COLLECTION_AFTER_LOAD__0.035115940,6560
DISPATCH EVENT:controller_action_layout_load_before0.0007170,9520
OBSERVER: quickview_check_referer_url0.0004158,2480
mage::dispatch::controller::action::catalog_category_view::layout_load0.0028147,784262,144
mage::dispatch::controller::action::catalog_category_view::layout_generate_xml0.004116560
mage::dispatch::controller::action::catalog_category_view::layout_generate_blocks0.082517,157,9047,077,888
BLOCK: formkey0.00071161,7120
DISPATCH EVENT:core_block_abstract_prepare_layout_before0.005415033,776262,144
OBSERVER: smartwave_ajaxcart_prepare_layout_before0.001515043,7600
DISPATCH EVENT:core_block_abstract_prepare_layout_after0.004315015,5360
OBSERVER: configurableproductssimpleprices_show_enabled0.001315025,4880
DISPATCH EVENT:core_layout_block_create_after0.00081507,9280
BLOCK: root0.0005171,9440
BLOCK: head0.00051146,272262,144
CORE::create_object_of::Smartwave_All_Model_Compiler0.000721330,8080
BLOCK ACTION: head -> addJs0.00043948,3440
BLOCK: js_cookies0.0003167,5760
BLOCK ACTION: head -> addCss0.00031942,5520
BLOCK ACTION: head -> addItem0.00022440,9600
BLOCK: after_body_start0.00051112,608262,144
BLOCK: global_notices0.0003165,9200
BLOCK: header0.0003166,8080
BLOCK: top.links0.0003169,2160
BLOCK: store_language0.0003168,264262,144
BLOCK: catalog.topnav0.00051113,5200
BLOCK: welcome0.0003165,1360
BLOCK: top.container0.0003157,720262,144
BLOCK: breadcrumbs0.0003166,2080
BLOCK: global_messages0.0005181,9680
BLOCK: footer0.00041101,736262,144
BLOCK: global_cookie_notice0.0003165,7360
BLOCK: core_profiler0.0003157,2560
BLOCK: cms_footer_links0.0003158,3360
BLOCK ACTION: top.links -> addLink0.0014244,376262,144
CORE::create_object_of::Mage_Core_Model_Url0.001611769,6560
BLOCK: catalog.compare.sidebar0.00061236,1760
BLOCK ACTION: footer_links -> addLink0.0015490,6720
BLOCK: catalog_product_price_template0.0004157,3360
BLOCK: top.search0.0004265,576262,144
BLOCK: return_link0.00061141,360262,144
BLOCK: paypal.partner.top_cart.shortcut0.00051154,5600
BLOCK: right.poll0.00041114,424262,144
BLOCK: right.reports.product.compared0.00051165,5600
BLOCK: google_analytics0.0003170,2160
BLOCK: wishlist_link0.0003172,344262,144
BLOCK: wishlist_sidebar0.00051176,9280
BLOCK: paypaluk.partner.top_cart.shortcut0.0003167,352262,144
BLOCK: sidebar.right.top0.0003165,4640
BLOCK: top.search.content0.0003167,0400
BLOCK: 0.0004178,8880
BLOCK: store_currency0.0003166,928262,144
BLOCK: minicart0.00061212,3840
BLOCK: checkout.cart.totals0.0005276,616262,144
BLOCK: left.reports.product.viewed0.0003186,1280
BLOCK: ajaxcatalog0.0005180,3920
BLOCK: catalog.leftnav0.035212,451,0802,883,584
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Collection0.00252175,1600
CORE::create_object_of::Mage_Catalog_Model_Resource_Product0.0016194,4880
DISPATCH EVENT:catalog_product_collection_apply_limitations_before0.0002201,4800
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Attribute_Collection0.00273102,0560
EAV: Mage_Eav_Model_Config::_initAttributes0.00611644,856786,432
DISPATCH EVENT:catalog_prepare_price_select0.00192255,6640
OBSERVER: tax0.001915186,6000
OBSERVER: weee0.0005268,4160
Mage_Catalog_Model_Layer::getState0.0002123,656262,144
BLOCK: category.products0.00551154,8080
REWRITE: Mage_Catalog_Model_Category_Url::getCategoryUrl0.0012110,0800
DISPATCH EVENT:core_abstract_load_before0.0001141,1440
BLOCK: product_list0.0004186,8960
BLOCK: product_list_toolbar0.0036194,288262,144
BLOCK: product_list_toolbar_pager0.0004187,8880
BLOCK: bml.center.logo0.0004166,3600
BLOCK: catalog.category0.0004171,7280
BLOCK: sale.reorder.sidebar0.0004167,4880
DISPATCH EVENT:controller_action_layout_generate_blocks_after0.0007173,3200
OBSERVER: configurableswatches0.00071471,9040
mage::dispatch::controller::action::catalog_category_view::layout_render0.9941100
DISPATCH EVENT:core_block_abstract_to_html_before0.0007934,9520
Mage_Core_Model_Design_Package::getFilename0.007496109,6320
frontend/smartwave/porto_child/template/page/2columns-left.phtml0.9912111,848,22413,369,344
frontend/smartwave/porto_child/template/page/html/head.phtml0.01651459,888262,144
Mage_Core_Model_Design_Package::getSkinUrl0.00342830,8240
DISPATCH EVENT:core_block_abstract_to_html_after0.01179226,1760
OBSERVER: amorderattr0.00289224,9520
OBSERVER: sharingtool0.00179224,3040
OBSERVER: integration_intercept_response0.00139226,1040
frontend/base/default/template/directory/js/optional_zip_countries.phtml0.0004126,5120
frontend/smartwave/porto/template/smartwave/quickview/page/lablequickview.phtml0.0003114,8960
frontend/smartwave/porto_child/template/hic/headSession.phtml0.00321320,512262,144
DISPATCH EVENT:custom_quote_process0.0002314,4640
CORE::create_object_of::Mage_Sales_Model_Quote0.0001133,7760
frontend/smartwave/porto_child/template/page/html/header_type11.phtml0.02941213,752262,144
frontend/base/default/template/page/template/links.phtml0.0015137,9520
frontend/smartwave/porto/template/checkout/cart/minicart.phtml0.0245174,4080
locale/currency0.02083868,8080
DISPATCH EVENT:currency_display_options_forming0.0006143,5120
OBSERVER: mage_currencysymbol_currency_display_options0.0005140,4880
frontend/smartwave/porto_child/template/page/html/topcontainer.phtml0.0011126,6400
frontend/smartwave/porto/template/catalog/category/page_header.phtml0.0003118,4720
CORE::create_object_of::Magestore_Bannerslider_Model_Mysql4_Bannerslider_Collection0.0006835,0640
frontend/base/default/template/bannerslider/bannerslider.phtml0.008727176,032262,144
frontend/smartwave/porto_child/template/catalog/category/view.phtml0.875219,884,82411,272,192
DISPATCH EVENT:catalog_block_product_list_collection0.02391503,224786,432
OBSERVER: review0.02371498,936786,432
DISPATCH EVENT:catalog_product_collection_load_before0.0001131,1040
DISPATCH EVENT:catalog_product_collection_load_after0.032013926,9120
OBSERVER: inventory0.042819917,2880
OBSERVER: bundle_observer0.00311390,4000
CORE::create_object_of::Mage_Review_Model_Review0.0002148,2800
frontend/smartwave/porto_child/template/catalog/product/list.phtml0.850219,294,92810,485,760
frontend/smartwave/porto_child/template/catalog/product/list/toolbar.phtml0.001714,2960
CORE::create_object_of::Mage_Catalog_Model_Product_Url0.0002143,6960
CORE::create_object_of::Mage_Catalog_Model_Product_Image0.00032816,1120
CORE::create_object_of::Mage_Review_Model_Review_Summary0.0001135,7520
frontend/smartwave/porto/template/review/helper/summary_short.phtml0.00101411,2720
frontend/base/default/template/catalog/product/price.phtml0.04601455,6880
DISPATCH EVENT:catalog_product_is_salable_before0.0005583,2640
DISPATCH EVENT:catalog_product_is_salable_after0.0004583,2720
CONFIGURABLE:Mage_Catalog_Model_Product_Type_Configurable::getConfigurableAttributes0.2984126,842,88810,223,616
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection0.0024664,6240
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute0.00151314,9120
TTT1:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad0.06156216,744786,432
TTT2:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad0.08706622,4080
CONFIGURABLE:Mage_Catalog_Model_Product_Type_Configurable::getUsedProducts0.086930762,3200
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Type_Configurable_Product_Collection0.00431285,1280
CORE::create_object_of::Mage_CatalogInventory_Model_Stock0.0001127,1440
CORE::create_object_of::Mage_CatalogInventory_Model_Resource_Stock_Item_Collection0.002912110,7200
CORE::create_object_of::Mage_CatalogInventory_Model_Resource_Stock_Item0.0002136,7200
TTT3:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad0.008069,6480
TTT4:Mage_Catalog_Model_Resource_Product_Type_Configurable_Attribute_Collection::_afterLoad0.131665,801,1369,175,040
CORE::create_object_of::Mage_Eav_Model_Resource_Entity_Attribute_Option_Collection0.0005212,1520
frontend/smartwave/porto_child/template/configurableproductssimpleprices/max-regular-price.phtml0.252461,648,7760
DISPATCH EVENT:catalog_product_load_after0.0165699,6320
CORE::create_object_of::Mage_CatalogInventory_Model_Stock_Item0.0001610,7920
OBSERVER: customgiftcard_observer0.0004612,1600
CORE::create_object_of::Mage_Catalog_Model_Resource_Product_Option_Collection0.0004626,5680
DISPATCH EVENT:catalog_product_get_final_price0.01761592,6320
OBSERVER: catalogrule0.01651592,1760
CORE::create_object_of::Mage_CatalogRule_Model_Resource_Rule0.0003158,1360
frontend/smartwave/porto_child/template/configurableproductssimpleprices/min-price.phtml0.0187624,5520
frontend/smartwave/porto/template/catalog/layer/view.phtml0.0211187,1680
frontend/base/default/template/page/html/cookienotice.phtml0.0003116,6240
Executed 215 queries in 0.26996517181396 seconds
Average query length: 0.0012556519619254 seconds
Queries per second: 796.39902642019
Longest query length: 0.034241199493408
Longest query:
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '2' WHERE (`attribute_id` = '138') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC