SET NAMES utf8 - array(0) { }
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (core_url_rewrite.request_path='dog/boots.html') AND (store_id=0 or store_id='1') ORDER BY `store_id` ASC - array(0) { }
SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = '1') AND ((date_from <= :_mage_bind_var_1 or date_from is null)) AND ((date_to >= :_mage_bind_var_2 or date_to is null)) - array(2) { [":_mage_bind_var_1"]=> string(19) "2015-02-28 05:18:46" [":_mage_bind_var_2"]=> string(19) "2015-02-28 05:18:46" }
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES (?, ?, ?, ?, ?) - array(5) { [0]=> string(26) "topgksqbskmno8bnrr1aaguav4" [1]=> string(19) "2015-02-28 05:18:46" [2]=> string(19) "2015-02-28 05:18:46" [3]=> int(0) [4]=> string(1) "1" }
INSERT INTO `log_visitor_info` (`visitor_id`, `http_referer`, `http_user_agent`, `http_accept_charset`, `http_accept_language`, `server_addr`, `remote_addr`) VALUES (?, ?, ?, ?, ?, ?, ?) - array(7) { [0]=> string(7) "3395224" [1]=> bool(false) [2]=> string(39) "CCBot/2.0 (http://commoncrawl.org/faq/)" [3]=> string(0) "" [4]=> string(28) "en-us,en-gb,en;q=0.7,*;q=0.3" [5]=> int(1169124845) [6]=> int(916366186) }
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code='catalog_category') - array(0) { }
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id=17) - array(0) { }
SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id='3') - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_text` AS `default` LEFT JOIN `catalog_category_entity_text` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='17' WHERE (default.entity_id='17') AND (default.store_id=0) - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_id='98') - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_id='98') - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_varchar` AS `default` LEFT JOIN `catalog_category_entity_varchar` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='17' WHERE (default.entity_id='17') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_int` AS `default` LEFT JOIN `catalog_category_entity_int` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='17' WHERE (default.entity_id='17') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_datetime` AS `default` LEFT JOIN `catalog_category_entity_datetime` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='17' WHERE (default.entity_id='17') AND (default.store_id=0) - array(0) { }
SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id = '17') AND (path LIKE (SELECT CONCAT(path, '/%') FROM `catalog_category_entity` WHERE (entity_id = '2'))) - array(0) { }
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id=3) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_text` AS `default` LEFT JOIN `catalog_category_entity_text` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='3' WHERE (default.entity_id='3') AND (default.store_id=0) - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_id='98') - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_id='98') - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_varchar` AS `default` LEFT JOIN `catalog_category_entity_varchar` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='3' WHERE (default.entity_id='3') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_int` AS `default` LEFT JOIN `catalog_category_entity_int` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='3' WHERE (default.entity_id='3') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_datetime` AS `default` LEFT JOIN `catalog_category_entity_datetime` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='3' WHERE (default.entity_id='3') AND (default.store_id=0) - array(0) { }
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id=2) - array(0) { }
SELECT `main_table`.*, `entity_attribute`.* FROM `eav_attribute` AS `main_table` INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id WHERE (main_table.entity_type_id='3') AND (entity_attribute.attribute_set_id='3') ORDER BY sort_order ASC - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_text` AS `default` INNER JOIN `eav_entity_attribute` AS `set_table` ON default.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=3 LEFT JOIN `catalog_category_entity_text` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='2' WHERE (default.entity_id='2') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_varchar` AS `default` INNER JOIN `eav_entity_attribute` AS `set_table` ON default.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=3 LEFT JOIN `catalog_category_entity_varchar` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='2' WHERE (default.entity_id='2') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_int` AS `default` INNER JOIN `eav_entity_attribute` AS `set_table` ON default.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=3 LEFT JOIN `catalog_category_entity_int` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='2' WHERE (default.entity_id='2') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_datetime` AS `default` INNER JOIN `eav_entity_attribute` AS `set_table` ON default.attribute_id=set_table.attribute_id AND set_table.attribute_set_id=3 LEFT JOIN `catalog_category_entity_datetime` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='2' WHERE (default.entity_id='2') AND (default.store_id=0) - array(0) { }
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id=1) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_text` AS `default` LEFT JOIN `catalog_category_entity_text` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='1' WHERE (default.entity_id='1') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_varchar` AS `default` LEFT JOIN `catalog_category_entity_varchar` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='1' WHERE (default.entity_id='1') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_int` AS `default` LEFT JOIN `catalog_category_entity_int` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='1' WHERE (default.entity_id='1') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_datetime` AS `default` LEFT JOIN `catalog_category_entity_datetime` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='1' WHERE (default.entity_id='1') AND (default.store_id=0) - array(0) { }
SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_text` AS `default` LEFT JOIN `catalog_category_entity_text` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='' WHERE (default.entity_id='') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_varchar` AS `default` LEFT JOIN `catalog_category_entity_varchar` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='' WHERE (default.entity_id='') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_int` AS `default` LEFT JOIN `catalog_category_entity_int` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='' WHERE (default.entity_id='') AND (default.store_id=0) - array(0) { }
SELECT `default`.*, `main`.`value_id` AS `store_value_id`, `main`.`value` AS `store_value` FROM `catalog_category_entity_datetime` AS `default` LEFT JOIN `catalog_category_entity_datetime` AS `main` ON main.attribute_id=default.attribute_id AND main.store_id=1 AND main.entity_id='' WHERE (default.entity_id='') AND (default.store_id=0) - array(0) { }
SELECT `a`.`attribute_id`, `t`.* FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (entity_type_code = 'catalog_category') AND (attribute_code = 'is_active') - array(0) { }
SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = '32' AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = '32' AND c.store_id = '1' AND c.entity_id = m.entity_id WHERE (m.path like '1/2/3/17/%') AND ((IFNULL(c.value, d.value) = '1')) - array(0) { }
SELECT `main_table`.`poll_id` FROM `poll` AS `main_table` INNER JOIN `poll_store` AS `store` ON main_table.poll_id=store.poll_id AND store.store_id = '1' WHERE (closed = 0) ORDER BY RAND() LIMIT 1 - array(0) { }
SELECT `poll`.* FROM `poll` WHERE (poll.poll_id='1') - array(0) { }
SELECT `main_table`.* FROM `poll_answer` AS `main_table` WHERE (poll_id IN('1') ) - array(0) { }
SELECT `e`.*, IFNULL(_table_is_active.value, _table_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `_table_is_active_default` ON (_table_is_active_default.entity_id = e.entity_id) AND (_table_is_active_default.attribute_id='32') AND _table_is_active_default.store_id=0 LEFT JOIN `catalog_category_entity_int` AS `_table_is_active` ON (_table_is_active.entity_id = e.entity_id) AND (_table_is_active.attribute_id='32') AND (_table_is_active.store_id='1') WHERE (e.entity_type_id = '3') AND (e.entity_id in ('3', '17')) AND (IFNULL(_table_is_active.value, _table_is_active_default.value) = '1') - array(0) { }
SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IFNULL(store.value, default.value) AS `value` FROM `catalog_category_entity_varchar` AS `default` LEFT JOIN `catalog_category_entity_varchar` AS `store` ON store.attribute_id=default.attribute_id AND store.entity_id=default.entity_id AND store.store_id=1 WHERE (default.entity_type_id=3) AND (default.entity_id in (3, 17)) AND (default.attribute_id in ('31', '33')) AND (default.store_id = 0) - array(0) { }
SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (core_url_rewrite.id_path='category/3') AND (store_id=0 or store_id='1') ORDER BY `store_id` ASC - array(0) { }
SELECT `eav_entity_type`.`entity_type_id` FROM `eav_entity_type` WHERE (entity_type_code='catalog_product') - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (entity_type_id='4') AND (used_for_sort_by=1) - array(0) { }
SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code='catalog_product') - array(0) { }
INSERT INTO `log_url_info` (`url`, `referer`) VALUES (?, ?) - array(2) { [0]=> string(41) "http://discountpetplus.com/dog/boots.html" [1]=> bool(false) }
UPDATE `log_visitor` SET `session_id` = ?, `first_visit_at` = ?, `last_visit_at` = ?, `last_url_id` = ?, `store_id` = ? WHERE (visitor_id='3395224') - array(5) { [0]=> string(26) "topgksqbskmno8bnrr1aaguav4" [1]=> string(19) "2015-02-28 05:18:46" [2]=> string(19) "2015-02-28 05:18:46" [3]=> string(7) "3842442" [4]=> string(1) "1" }
INSERT INTO `log_url` (`url_id`, `visitor_id`, `visit_time`) VALUES (?, ?, ?) - array(3) { [0]=> string(7) "3842442" [1]=> string(7) "3395224" [2]=> string(19) "2015-02-28 05:18:46" } Boots - Dog

DiscountPetSupply

Skip to Main Content »

Search Site

Category Navigation:

You're currently on:

Boots

These beautiful boots are made of Supple Suede Leather or Cordura Nylon. Cordura is water repellant and wear resistant.


SELECT `eav_entity_type`.`entity_type_id` FROM `eav_entity_type` WHERE (entity_type_code='catalog_product') - array(0) { }
SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (entity_type_id='4') AND (used_in_product_listing=1) - array(0) { }
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='17' AND cat_index.is_parent=1 - array(0) { }
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `_price_rule`.`rule_price` AS `_rule_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='17' AND cat_index.is_parent=1 LEFT JOIN `catalogrule_product_price` AS `_price_rule` ON _price_rule.product_id = e.entity_id AND _price_rule.rule_date = '2015-02-28' AND _price_rule.website_id = '1' AND _price_rule.customer_group_id = '0' ORDER BY `cat_index_position` asc, `cat_index`.`product_id` asc LIMIT 9 - array(0) { }
There are no products matching the selection.
 

My Cart

You have no items in your shopping cart.

Compare Products

You have no items to compare.

Keep your eyes open for our special Back to School items and save A LOT!

Community Poll

Which grooming task are you least fond of?