September 2021 Promotions

Home / Shop / Promotions

Save on Carefresh!

Get $3.00 OFF any size or color Carefresh Bedding!

*Offer available in store. Limit 12. Call for more details. Ends 12/31/2021

Save on FirstMate Dry Cat Food!

Get $2.00 OFF Small Bags and $4.00 OFF Large Bags of Dry Cat Food!

*Offer available in store. Limit 1. Call for more details. Ends 09/30/2021

Up To $8 Off Honest Kitchen!

Get $4.00 OFF on 3lb – 4lb Boxes and $8.00 OFF 7lb – 10lb Boxes of Dehydrated Diets!

*Offer available in store. Call for more details. Ends 09/30/2021

Austin & Kat

$2 Off Oxbow!

Get $2.00 OFF on Oxbow Foods 1-10lb Bags!

*Offer available in store. Limit 3. Call for more details. Ends 09/30/2021

Save on Tucker’s Raw Formulas!

Get $3.00 OFF 6lb Bags, $2.00 OFF 3lb Bags of Raw Frozen Formulas for Dogs, and $2.00 OFF 24oz Bags of Raw Frozen Formulas for Cats!

*Offer available in store. Call for more details. Ends 09/30/2021

Challenger

$5 Off Select Victor Dog Food

Save $5.00 on 30lb and 40lb Bags of Victor Select.

*Offer available in store. Limit 10. Ends 09/30/2021

NutriSource PureVita

20% OFF Select Toppers!

Save 20% on a variety of toppers!

*Offer available in store only. Call or come in for more details. Ends 09/30/2021

THE renowned FREE BAG!

It’s like a punch card, but better! Buy so many participating items and get one FREE! Best of all, we keep track of it for you, all year long.

Learn More

#	SQL	Time
1	SELECT * FROM wp_say_what_strings	0.2610683ms
2	SHOW FULL COLUMNS FROM `wp_options`	1.0328292ms
3	UPDATE `wp_options` SET `option_value` = '23' WHERE `option_name` = 'auth0_db_version'	1.2090206ms
4	show tables like 'wp_fbv'	0.9469985ms
5	show tables like 'wp_fbv_attachment_folder'	0.7860660ms
6	SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 200	0.3740787ms
7	SELECT wp_redirection_items.*,wp_redirection_groups.position AS group_pos FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' AND wp_redirection_groups.module_id=1 WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/promotions/')	0.5159378ms
8	SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('promotions') AND post_type IN ('page','attachment')	0.4470348ms
9	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '25424') AND wp_posts.post_type = 'page' ORDER BY wp_posts.post_date DESC	0.2789497ms
10	SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 25424 ORDER BY wp_posts.post_title ASC LIMIT 0,1	1.3828277ms
11	SELECT tr.object_id FROM wp_term_relationships AS tr LEFT JOIN wp_term_taxonomy AS tt USING( term_taxonomy_id ) WHERE tt.taxonomy = 'product_visibility' AND tr.term_taxonomy_id = 10082	0.2760887ms
12	SELECT ID FROM wp_posts AS p WHERE post_type = 'product' AND post_status = 'publish'	0.8509159ms
13	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.3099441ms
14	SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_sidebar_to_replace' AND wp_postmeta.meta_value != '' ) AND ( mt1.meta_key = '_condition' AND mt1.meta_value IN ('page-template-page-blank','postwc-25424','post-25424','page','post-type-page','singular') ) ) AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 200	0.4689693ms
15	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2714,2715,2716,5705,125089,125090,126494,126913) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.2999305ms
16	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.2961158ms
17	SELECT post_name, ID, comment_count FROM wp_posts WHERE post_type = 'deprecated_log'	1.0590553ms

SQL

Time

Call Stack

SELECT * FROM wp_say_what_strings

0.2610683ms

SHOW FULL COLUMNS FROM `wp_options`

1.0328292ms

UPDATE `wp_options` SET `option_value` = '23' WHERE `option_name` = 'auth0_db_version'

1.2090206ms

show tables like 'wp_fbv'

0.9469985ms

show tables like 'wp_fbv_attachment_folder'

0.7860660ms

SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 200

0.3740787ms

SELECT wp_redirection_items.*,wp_redirection_groups.position AS group_pos FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' AND wp_redirection_groups.module_id=1 WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/promotions/')

0.5159378ms

SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('promotions') AND post_type IN ('page','attachment')

0.4470348ms

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '25424') AND wp_posts.post_type = 'page' ORDER BY wp_posts.post_date DESC

0.2789497ms

SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') AND post_parent = 25424 ORDER BY wp_posts.post_title ASC LIMIT 0,1

1.3828277ms

SELECT tr.object_id FROM wp_term_relationships AS tr LEFT JOIN wp_term_taxonomy AS tt USING( term_taxonomy_id ) WHERE tt.taxonomy = 'product_visibility' AND tr.term_taxonomy_id = 10082

0.2760887ms

SELECT ID FROM wp_posts AS p WHERE post_type = 'product' AND post_status = 'publish'

0.8509159ms

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC

0.3099441ms

SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_sidebar_to_replace' AND wp_postmeta.meta_value != '' ) AND ( mt1.meta_key = '_condition' AND mt1.meta_value IN ('page-template-page-blank','postwc-25424','post-25424','page','post-type-page','singular') ) ) AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 200

0.4689693ms

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2714,2715,2716,5705,125089,125090,126494,126913) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC

0.2999305ms

0.2961158ms

SELECT post_name, ID, comment_count FROM wp_posts WHERE post_type = 'deprecated_log'

1.0590553ms