Heckle Sports

Sports Whats your favorite sport?
About Us We want to be your one stop sports spot.
Forum Speak what is on your mind.
Contact Us Come drop us a line.

Sign In

News Updates

Updates go here

Ads go here

AFC

AFC North

Baltimore Ravens
roster schedule
Cincinnati Bengals
roster schedule
Cleveland Browns
roster schedule
Pittsburgh Steelers
roster schedule

AFC South

Houston Texans
roster schedule
Indianapolis Colts
roster schedule
Jacksonville Jaguars
roster schedule
Tennessee Titans
roster schedule

AFC West

Denver Broncos
roster schedule
Kansas City Chiefs
roster schedule
Oakland Raiders
roster schedule
San Diego Chargers
roster schedule

AFC East

Buffalo Bills
roster schedule
Miami Dolphins
roster schedule
New England Patriots
roster schedule
New York Jets
roster schedule

NFC

NFC North

Chicago Bears
roster schedule
Detroit Lions
roster schedule
Green Bay Packers
roster schedule
Minnesota Vikings
roster schedule

NFC South

Atlanta Falcons
roster schedule
Carolina Panthers
roster schedule
New Orleans Saints
roster schedule
Tampa Bay Buccaneers
roster schedule

NFC West

Arizona Cardinals
roster schedule
San Francisco 49ers
roster schedule
Seattle Seahawks
roster schedule
St. Louis Rams
roster schedule

NFC East

Dallas Cowboys
roster schedule
New York Giants
roster schedule
Philadelphia Eagles
roster schedule
Washington Redskins
roster schedule

(default) 19 queries took 770 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	10
2	DESCRIBE `acos`	7	7	0
3	DESCRIBE `aros_acos`	7	7	0
4	DESCRIBE `teams`	7	7	0
5	DESCRIBE `sports`	2	2	10
6	DESCRIBE `divisions`	2	2	0
7	DESCRIBE `team_xml_datas`	3	3	20
8	DESCRIBE `game_xml_datas`	3	3	0
9	DESCRIBE `team_icons`	4	4	0
10	DESCRIBE `games`	7	7	0
11	DESCRIBE `players`	11	11	10
12	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 4 GROUP BY `Team`.`id`	4	4	300
13	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 3 GROUP BY `Team`.`id`	4	4	40
14	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 2 GROUP BY `Team`.`id`	4	4	100
15	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 1 GROUP BY `Team`.`id`	4	4	120
16	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 7 GROUP BY `Team`.`id`	4	4	90
17	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 8 GROUP BY `Team`.`id`	4	4	50
18	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 6 GROUP BY `Team`.`id`	4	4	0
19	SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 5 GROUP BY `Team`.`id`	4	4	20

(default) 19 queries took 770 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `teams`

DESCRIBE `sports`

DESCRIBE `divisions`

DESCRIBE `team_xml_datas`

DESCRIBE `game_xml_datas`

DESCRIBE `team_icons`

DESCRIBE `games`

DESCRIBE `players`

SELECT `Team`.`id`, `Team`.`sport_id`, `Team`.`league_id`, `Team`.`division_id`, `Team`.`conference_id`, `Team`.`location`, `Team`.`team`, `Sport`.`id`, `Sport`.`sport`, `Division`.`id`, `Division`.`division`, `TeamXmlData`.`url`, `GameXmlData`.`url`, `TeamIcon`.`id`, `TeamIcon`.`team_id`, `TeamIcon`.`image`, `TeamIcon`.`image_type`, `Game`.`id`, `Game`.`league_id`, `Game`.`home_team_id`, `Game`.`away_team_id`, `Game`.`home_team_score`, `Game`.`away_team_score`, `Game`.`date` FROM `teams` AS `Team` LEFT JOIN `sports` AS `Sport` ON (`Team`.`sport_id` = `Sport`.`id`) LEFT JOIN `divisions` AS `Division` ON (`Team`.`division_id` = `Division`.`id`) LEFT JOIN `team_xml_datas` AS `TeamXmlData` ON (`TeamXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `game_xml_datas` AS `GameXmlData` ON (`GameXmlData`.`team_id` = `Team`.`id`) LEFT JOIN `team_icons` AS `TeamIcon` ON (`TeamIcon`.`team_id` = `Team`.`id`) LEFT JOIN `games` AS `Game` ON (`Game`.`Away_team_id` = `Team`.`id`) WHERE `Team`.`division_id` = 4 GROUP BY `Team`.`id`

300

100

120