Colts

Flag Football

Flag Football 7v7 Draft League
Spring Saturdays

Spring Saturdays
Overall Team Skill Ratings

Hands

Speed

Stamina

Game Knowledge

Quarterbacking

Pass Rush

Flag Tackle

Kicking

    Team Roster

    Player
    Hands
    Speed
    Stamina
    Game Knowledge
    Quarterbacking
    Pass Rush
    Flag Tackle
    Kicking
    Dotlichc
    | WR, CB, SF
    Coach
    A
    B
    C
    A
    A
    C
    C
    B
    jasoza
    | WR, SF, CB
    B
    A
    B
    B
    C
      434
      Array
(
    [team_id] => 434
    [sport_id] => 2
    [league_id] => 0
    [division_id] => 
    [wins] => 0
    [losses] => 0
    [wins_all] => 0
    [losses_all] => 0
    [fullname] => Colts
    [shortname] => 
    [abbr] => 
    [fullmascot] => 
    [shortmascot] => 
    [url] => colts
    [logo_id] => 110
    [court_id] => 0
    [color_id] => #000000
    [max_roster_size] => 15
    [gallery_id] => 4075
    [approved] => 1
    [active] => 1
    [current_roster_size] => 2
    [owner_id] => 3496
    [public] => 1
    [chat_room_id] => 0
    [personal] => 0
    [deleted] => 0
    [invite_code] => 
    [featured_bg] => 6542
    [color_id_2] => #000000
    [color_id_3] => #000000
    [description] => 
    [shirt_color] => Cobalt Blue or Ash
    [jersey_img] => 0
    [jersey_img_away] => 0
    [leagues] => 1
    [thumb] => /files/gallery/misc/thumbs/purple-blue_recjoe1436998458.png
    [large] => /files/gallery/misc/purple-blue_recjoe1436998458.png
    [alt] => -110 110
    [name] => Colts
    [sport_name] => Flag Football
    [sport_icon] => fa-regular fa-football
    [sport_url] => flag-football
    [gameimage] => 
    [roster] => 1
    [earnings] => -
    [group_type] => teams
    [teamorg] => 
    [link] => /team/colts/
    [image] => Array
        (
            [id] => colts
            [thumb] => /files/gallery/misc/thumbs/purple-blue_recjoe1436998458.png
            [large] => /files/gallery/misc/purple-blue_recjoe1436998458.png
            [alt] => -110 110
            [link] => /team/colts/
        )

    [label] => team
    [game] => All Games
    [tools] => Array
        (
            [score] => 
            [homelink] => /team/colts/
            [homelink_type] => teams
        )

    [featured_bg_img] => https://leaguejoe.com/files/gallery/misc/default-green_recjoe1704996203.webp
    [settings] => 
    [perm_team_level] => 0
    [perm_team_name] => Guest
    [perm_team_score] => 0
    [score] => 0
    [games] => 16
    [sponsors] => 0
    [reports] => 0
)
      PEAK MEMORY: 2.83 MiB
      MEMORY USAGE AFTER: 2.11 MiB

      Debug Information


      Request Variables

      var = team

      varb = colts

      vara =

      varc =

      vard =

      vare =

      Debug Messages

      Site ID: 1

      Sub Domain:

      Domain: netstuffersdev1.com

      Site name: LeagueJoe

      Template: lj

      SECURETOKEN: ff07d64cbb7c54d193aea63e4b9e5824

      Login Type:

      BASE:: team

      FULL LINK:: team/colts

      Page ID: 49

      Page ID:: 49

      Page Template:: lj

      Template Layout:: default

      Headers: : Loading page header code

      Active Blocks: Array ( [0] => [1] => 1 [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => 1 )

      Block Types: Array ( [0] => [1] => Array ( [0] => module ) [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => Array ( [0] => module ) )

      Element ID: Array ( [0] => [1] => Array ( [0] => 5 ) [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => Array ( [0] => 5 ) )

      Admin Login Level: :

      Admin Login Level: :

      USER CACHE: User cache reset

      Footer: : Loading page footer code


      Session Variables

      securetoken = ff07d64cbb7c54d193aea63e4b9e5824
      fullstate =


      Cookie Variables

      RWSESSID = 47bd472ae20f232e9a09ac924ebec4fd


      Server Variables

      USER = leaguejo_dev
      HOME = /home/leaguejo_dev
      SCRIPT_NAME = /index.php
      REQUEST_URI = /team/colts/
      QUERY_STRING = var=team&varb=colts
      REQUEST_METHOD = GET
      SERVER_PROTOCOL = HTTP/1.1
      GATEWAY_INTERFACE = CGI/1.1
      REDIRECT_QUERY_STRING = var=team&varb=colts
      REDIRECT_URL = /team/colts/
      REMOTE_PORT = 30084
      SCRIPT_FILENAME = /home/leaguejo_dev/public_html/index.php
      SERVER_ADMIN = support@aod.net
      CONTEXT_DOCUMENT_ROOT = /home/leaguejo_dev/public_html
      CONTEXT_PREFIX =
      REQUEST_SCHEME = https
      DOCUMENT_ROOT = /home/leaguejo_dev/public_html
      REMOTE_ADDR = 3.144.100.252
      SERVER_PORT = 443
      SERVER_ADDR = 162.248.190.150
      SERVER_NAME = netstuffersdev1.com
      SERVER_SOFTWARE = Apache
      SERVER_SIGNATURE =
      PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
      HTTP_HOST = netstuffersdev1.com
      HTTP_REFERER = https://netstuffersdev1.com/team/colts
      HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
      HTTP_COOKIE = RWSESSID=47bd472ae20f232e9a09ac924ebec4fd
      HTTP_USER_AGENT = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
      HTTP_ACCEPT = */*
      proxy-nokeepalive = 1
      SSL_TLS_SNI = netstuffersdev1.com
      HTTPS = on
      SCRIPT_URI = https://netstuffersdev1.com/team/colts/
      SCRIPT_URL = /team/colts/
      UNIQUE_ID = Z0BdImB3TiEvUYAimyePzAAAAEo
      REDIRECT_STATUS = 200
      REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
      REDIRECT_HTTPS = on
      REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/team/colts/
      REDIRECT_SCRIPT_URL = /team/colts/
      REDIRECT_UNIQUE_ID = Z0BdImB3TiEvUYAimyePzAAAAEo
      FCGI_ROLE = RESPONDER
      PHP_SELF = /index.php
      REQUEST_TIME_FLOAT = 1732271394.0031
      REQUEST_TIME = 1732271394


      SQL Queries


      Total Queries: 148
      Total Execution Time: 57.7222ms
      Avg Execution Time:0.39001486486486ms

      QUERY(1.431ms) - INSERT INTO security_log (domain,username, log_date, log_time, method, page, ip, address, browser, getvars, postvars, sessionvars,badlogin,userlogin,timestamp) VALUES ('.netstuffersdev1.com','','2024-11-22', '10:29:54', 'GET', '/team/colts/', '3.144.100.252', 'https://netstuffersdev1.com/team/colts' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhdzVyTnZ0Q2xtTEY3bFlyL2dHTVFZay9KZ0hidnJnS1JQRkhkT0xiUUEvUEtZY0pzMFNkdlEwT3pKalVkMEhId2hqSVlqQ2VFVGp4Y1YzZmhuUVBPa3o=','0','','1732271394') ON DUPLICATE KEY UPDATE `ip`=`ip`

      QUERY(1.754ms) - SELECT SQL_CACHE `end_timestamp` FROM `security_locks` WHERE ((`who`='3.144.100.252' && `which`='IP'))

      QUERY(0.3099ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/team/colts/'

      QUERY(0.2561ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='team/colts' ORDER BY `domain`='1' DESC,`domain` ASC

      QUERY(0.257ms) - SELECT SQL_CACHE `id`,`layout`,`light`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='team' ORDER BY `domain`='1' DESC,`domain` ASC

      QUERY(0.1471ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay`,`customize` FROM `pages` WHERE `id`='49'

      QUERY(0.1731ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.159ms) - SELECT * FROM userprofiles_config

      QUERY(0.1721ms) - SELECT SQL_CACHE `name` FROM `states` WHERE `abbr`='' LIMIT 0,1

      QUERY(0.1659ms) - SELECT SQL_CACHE title,metakeys,metadescript,seomodule,seotitlefield,seodescfield,seotitletable,seodesctable,urllinkfield FROM pages WHERE `id`='49' && `domain`='1'

      QUERY(0.1509ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1702ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.5929ms) - SELECT COUNT(*) FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'colts'

      QUERY(0.845ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,`photo`.`thumb_url` AS `thumb`,`photo`.`img_url` AS `large`,`photo`.`title` AS `alt`,`leagues`.`name`,`teams_players`.`player_id`,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`gamephoto`.`img_url` AS `gameimage`,`teams_privacy`.`public`,`teams_privacy`.`roster` FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'colts' GROUP BY `teams`.`team_id`

      QUERY(0.2098ms) - SELECT `team_id`, `league_id` FROM `league_teams` WHERE `league_id` = 0 AND `season_id` = 0 AND `team_id` = 434 LIMIT 1

      QUERY(0.1318ms) - SELECT SQL_CACHE `img_url` FROM `photo` WHERE `photo_id`=6542 LIMIT 0,1

      QUERY(0.2611ms) - SELECT COUNT(`player_id`) FROM `teams_players` WHERE `team_id`=434 && quit=0

      QUERY(0.1359ms) - SELECT * FROM `teams_settings` WHERE `team_id`=434

      QUERY(0.165ms) - SELECT SQL_CACHE * FROM `teams_cache` WHERE `team_id`=434 && `updated`>=(NOW() - INTERVAL 60 MINUTE) LIMIT 0,1

      QUERY(0.1349ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=434 LIMIT 0,1

      QUERY(0.334ms) - SELECT COUNT(`game_id`) FROM `games` WHERE (`home_team_id`=434||`away_team_id`=434) && `cancelled`=0

      QUERY(0.2301ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=434

      QUERY(2.1939ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=434

      QUERY(0.1559ms) - INSERT INTO `teams_cache` (`team_id`,`products`,`sponsors`,`reports`) VALUES ('434',0,0,0) ON DUPLICATE KEY UPDATE `team_id`='434',`products`=0,`sponsors`=0,`reports`=0

      QUERY(0.232ms) - SELECT SQL_CACHE `code` FROM `page_headers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:49:%' || (`global`=1 && `exclude` NOT LIKE '%:49:%') ) ORDER BY `id` ASC

      QUERY(0.1278ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='UTC'

      QUERY(0.2141ms) - SELECT count(`league_id`) FROM `league_players` WHERE `player_id`=''

      QUERY(0.181ms) - SELECT SQL_CACHE `block_id`,`element_id`,`function_id`,`type` FROM `blocks` WHERE `page_id`='49' ORDER BY `order` ASC

      QUERY(0.1991ms) - SELECT `abbr`,`name` FROM `states` WHERE `active`=1 ORDER BY `name` ASC

      QUERY(0.133ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='5'

      QUERY(0.138ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1249ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1419ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.124ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.164ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1218ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.139ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1509ms) - SELECT * FROM userprofiles_config

      QUERY(0.144ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.118ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.423ms) - SELECT COUNT(*) FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'colts'

      QUERY(0.772ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,`photo`.`thumb_url` AS `thumb`,`photo`.`img_url` AS `large`,`photo`.`title` AS `alt`,`leagues`.`name`,`teams_players`.`player_id`,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`gamephoto`.`img_url` AS `gameimage`,`teams_privacy`.`public`,`teams_privacy`.`roster` FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'colts' GROUP BY `teams`.`team_id`

      QUERY(0.227ms) - SELECT `team_id`, `league_id` FROM `league_teams` WHERE `league_id` = 0 AND `season_id` = 0 AND `team_id` = 434 LIMIT 1

      QUERY(0.1321ms) - SELECT SQL_CACHE `img_url` FROM `photo` WHERE `photo_id`=6542 LIMIT 0,1

      QUERY(0.2251ms) - SELECT COUNT(`player_id`) FROM `teams_players` WHERE `team_id`=434 && quit=0

      QUERY(0.1311ms) - SELECT * FROM `teams_settings` WHERE `team_id`=434

      QUERY(0.1621ms) - SELECT SQL_CACHE * FROM `teams_cache` WHERE `team_id`=434 && `updated`>=(NOW() - INTERVAL 60 MINUTE) LIMIT 0,1

      QUERY(0.128ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=434 LIMIT 0,1

      QUERY(0.3409ms) - SELECT COUNT(`game_id`) FROM `games` WHERE (`home_team_id`=434||`away_team_id`=434) && `cancelled`=0

      QUERY(0.1779ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=434

      QUERY(2.1138ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=434

      QUERY(0.1519ms) - INSERT INTO `teams_cache` (`team_id`,`products`,`sponsors`,`reports`) VALUES ('434',0,0,0) ON DUPLICATE KEY UPDATE `team_id`='434',`products`=0,`sponsors`=0,`reports`=0

      QUERY(0.2048ms) - SELECT `season_id` FROM `league_teams` WHERE `team_id`=434

      QUERY(0.139ms) - SELECT `league_id` FROM `league_seasons` WHERE `season_id`=105 LIMIT 0,1

      QUERY(0.515ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams` FROM `leagues` INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`leagues`.`venue_id` = `venues`.`venue_id`) WHERE `leagues`.`league_id` = '68' LIMIT 0,1

      QUERY(0.17ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=2

      QUERY(0.53ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '68' and `league_seasons`.`season_id` = '105' ORDER BY `league_dates`.`start_date` ASC

      QUERY(0.1521ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=2

      QUERY(0.1099ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

      QUERY(0.1509ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

      QUERY(0.1588ms) - SELECT SQL_CACHE `allow_couples`,`disable_standings`,`type`,`groups`,`group_size`,`divisions`,`schedule_type`,`allow_alts`,`show_schedule_level` FROM `league_schedule_options` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

      QUERY(0.2129ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=68 && `season_id`=105 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

      QUERY(0.19ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=105 LIMIT 0,1

      QUERY(0.1671ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=434

      QUERY(0.129ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1199ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1578ms) - SELECT `league_id`,`season_id` FROM `league_teams` WHERE `team_id`=434

      QUERY(0.4239ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams` FROM `leagues` INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`leagues`.`venue_id` = `venues`.`venue_id`) WHERE `leagues`.`league_id` = '68' LIMIT 0,1

      QUERY(0.133ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=2

      QUERY(0.464ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '68' and `league_seasons`.`season_id` = '105' ORDER BY `league_dates`.`start_date` ASC

      QUERY(0.18ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=2

      QUERY(0.1149ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

      QUERY(0.1771ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

      QUERY(0.1571ms) - SELECT SQL_CACHE `allow_couples`,`disable_standings`,`type`,`groups`,`group_size`,`divisions`,`schedule_type`,`allow_alts`,`show_schedule_level` FROM `league_schedule_options` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

      QUERY(0.1972ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=68 && `season_id`=105 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

      QUERY(0.1769ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=105 LIMIT 0,1

      QUERY(0.2642ms) - SELECT count(player_id) AS `player`,`coach`,`access`,`team_player_id` AS `tpi` FROM `teams_players` WHERE `team_id`='434' && `player_id`='' && `quit`=0 ORDER BY `season_id` DESC

      QUERY(0.1121ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='5'

      QUERY(0.129ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1099ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.123ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.098ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.134ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1211ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.15ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1171ms) - SELECT * FROM userprofiles_config

      QUERY(0.128ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.1171ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.1249ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=434

      QUERY(0.1831ms) - SELECT * FROM `team_strength` WHERE `team_id`=434 && `season_id`=105

      QUERY(0.1659ms) - SELECT * FROM `team_strength` WHERE `team_id`=434 && `season_id`=105

      QUERY(0.2599ms) - SELECT SQL_CACHE `attribute`.`attribute_id`,`attribute`.`name`,`attribute`.`description`,`attribute`.`url`,`attribute`.`icon`,`attribute`.`min`,`attribute`.`max` FROM `attribute` WHERE `attribute`.`sport_id` = '2' and `attribute`.`active` = '1' ORDER BY `attribute`.`fieldorder` asc

      QUERY(0.1419ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='sports'

      QUERY(0.102ms) - SELECT SQL_CACHE * FROM sports_config

      QUERY(0.129ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.119ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1268ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.109ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1791ms) - SELECT `position_id`,UPPER(`abbr`) AS `abbr` FROM `sports_positions` WHERE `sport_id`=2

      QUERY(0.138ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='68' && `season_id`='105'

      QUERY(0.9739ms) - SELECT SQL_CACHE `teams`.`url`,`teams`.`team_id`,`teams`.`fullname`,`teams`.`personal`,`teams`.`owner_id`,(SELECT `player_id` FROM `teams_players` WHERE `team_id`=`teams`.`team_id` && `access`=4 LIMIT 0,1) AS `coach_id`,`league_teams`.`league_teams_id`,`league_teams`.`league_id`,`league_teams`.`season_id`,`league_teams`.`ready`,`users`.`user_url`,`users`.`username`,`users`.`first_name`,`users`.`last_name`,`photo`.`thumb_url` FROM `teams` INNER JOIN `league_teams` ON (`teams`.`team_id` = `league_teams`.`team_id`) LEFT JOIN `users` ON (`teams`.`owner_id` = `users`.`id`) LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `league_teams`.`deleted` != '1' and `teams`.`personal` = '0' and `league_teams`.`league_id` = '68' and `league_teams`.`season_id` = '105' ORDER BY `teams`.`fullname` desc

      QUERY(0.1481ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=432 && `league_id`='68' && `season_id`='105'

      QUERY(0.1431ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=434 && `league_id`='68' && `season_id`='105'

      QUERY(0.1631ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=431 && `league_id`='68' && `season_id`='105'

      QUERY(0.1571ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=433 && `league_id`='68' && `season_id`='105'

      QUERY(4.9479ms) - SELECT SQL_CACHE `users`.`rookie`,`users`.`id`,`users`.`username`,`users`.`first_name`,`users`.`last_name`,`users`.`avatar_id`,`users`.`gender`,`users`.`user_url`,`users`.`level`,`users`.`confirmed`,`users`.`phone_number`,`users`.`email`,`users`.`approved`,`users`.`noemail`,`teams_players`.`player_id`,`teams_players`.`alternate`,`teams_players`.`coach`,`teams_players`.`paid`,`teams_players`.`couple`,`teams_players`.`couple_uname`,`teams_players`.`first_name` AS `manual_first_name`,`teams_players`.`last_name` AS `manual_last_name`,`teams_players`.`email` AS `manual_email`,`league_players`.`league_players_id`,`league_players`.`ready`,`league_players`.`season_id`,`league_players`.`created`,`league_players`.`package_id`,`league_players`.`closed`,`league_players`.`moretime`,`league_players`.`player_id`,`league_players`.`league_id`,`league_players`.`alternate`,`league_players`.`coach`,`league_players`.`paid`,`league_players`.`couple`,`league_players`.`couple_uname`,`league_players`.`access`,`league_players`.`nosalary`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=50 LIMIT 0,1) AS `kicking`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=49 LIMIT 0,1) AS `flag-tackle`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=48 LIMIT 0,1) AS `football-rush`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=12 LIMIT 0,1) AS `quarterbacking`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=11 LIMIT 0,1) AS `game-knowledge`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=10 LIMIT 0,1) AS `stamina`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=9 LIMIT 0,1) AS `football-speed`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=8 LIMIT 0,1) AS `hands`,(SELECT `salary` FROM `draft_scouting_reports` WHERE `draft_scouting_reports`.`player_id`=`league_players`.`player_id` && `draft_scouting_reports`.`season_id`=`league_players`.`season_id` ORDER BY `lock` DESC LIMIT 0,1) AS `salary`,(SELECT `injury` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=1 && `sports_positions`.`sport_id`=2 ORDER BY `season_id`=105 DESC LIMIT 0,1) AS `injury`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=1 && `sports_positions`.`sport_id`=2 ORDER BY `season_id`=105 DESC LIMIT 0,1) AS `primary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=2 && `sports_positions`.`sport_id`=2 ORDER BY `season_id`=105 DESC LIMIT 0,1) AS `secondary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=3 && `sports_positions`.`sport_id`=2 ORDER BY `season_id`=105 DESC LIMIT 0,1) AS `tertiary`,(SELECT `thumb_url` FROM `photo` WHERE `photo_id`=`users`.`avatar_id`) AS `avatar` FROM `users` INNER JOIN `teams_players` ON (`users`.`id` = `teams_players`.`player_id`) INNER JOIN `league_players` ON (`users`.`id` = `league_players`.`player_id`) WHERE `league_players`.`season_id` = '105' and `teams_players`.`team_id` = '434' and `teams_players`.`quit` = '0' ORDER BY `users`.`last_name` ASC LIMIT 0,500

      QUERY(0.272ms) - SELECT * FROM `attribute` WHERE `sport_id`=2 ORDER BY `fieldorder` ASC

      QUERY(0.1719ms) - SELECT `name`,`abbr` FROM `sports_positions` WHERE `sport_id`=1

      QUERY(0.392ms) - SELECT `player_id` AS coach_id,`team_id`,`users`.`username`,`users`.`user_url`,`img_url` FROM `teams_players` INNER JOIN `users` ON `player_id`=`id` INNER JOIN `photo` ON `photo_id`=`avatar_id` WHERE `teams_players`.`team_id`=434 && (`coach`=1 || `access`=4 || `access`=5 || `access`=6) ORDER BY `access` DESC

      QUERY(0.1259ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1302ms) - SELECT * FROM userprofiles_config

      QUERY(0.3781ms) - SELECT SQL_CACHE `users`.*,`cart_customers`.`customer_id` FROM `users` LEFT JOIN `users_profile` ON `users_profile`.`user_id`=`users`.`id` LEFT JOIN `cart_customers` ON `cart_customers`.`user_id`=`users`.`id` WHERE `users`.`user_url`='dotlichc' LIMIT 0,1

      QUERY(0.113ms) - SELECT `img_url`,`thumb_url` FROM `photo` WHERE `photo_id`=99

      QUERY(0.2291ms) - SELECT SQL_CACHE * FROM `userprofiles_cache` WHERE `user_id`=3496 && `updated`>=(NOW() - INTERVAL 60 MINUTE)

      QUERY(0.144ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.113ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(1.0562ms) - UPDATE users SET `lastip`='3.144.100.252' WHERE `id`=3496

      QUERY(0.1609ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='3496' LIMIT 0,1

      QUERY(0.1721ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='3496' && `finish_rank`=1 LIMIT 0,1

      QUERY(0.1881ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='3496' && `finish_rank`=2 LIMIT 0,1

      QUERY(0.2451ms) - SELECT SQL_CACHE count(`teams`.`team_id`) FROM `teams` INNER JOIN `teams_players` ON `teams`.`team_id`=`teams_players`.`team_id` WHERE `teams_players`.`player_id`='3496'

      QUERY(0.2532ms) - SELECT COUNT(`coach`) FROM `league_players` WHERE `player_id`=3496 && (`coach`=1||`access`=4) && `deleted`=0 LIMIT 0,1

      QUERY(0.1221ms) - SELECT `avatar_id` FROM `users` WHERE `id`=3496

      QUERY(0.1721ms) - SELECT COUNT(`report_id`) FROM `teams_players_scouting_reports` WHERE `player_id`=3496 && `public_text`!=''

      QUERY(0.355ms) - SELECT COUNT(`league_players_id`) FROM `league_players` INNER JOIN `league_seasons` ON `league_seasons`.`season_id`=`league_players`.`season_id` INNER JOIN `leagues` ON `leagues`.`league_id`=`league_seasons`.`league_id` && `leagues`.`tournament`=0 WHERE `player_id`=3496 && `deleted`=0

      QUERY(0.3419ms) - SELECT COUNT(`league_players_id`) FROM `league_players` INNER JOIN `league_seasons` ON `league_seasons`.`season_id`=`league_players`.`season_id` INNER JOIN `leagues` ON `leagues`.`league_id`=`league_seasons`.`league_id` && `leagues`.`ultra`=1 WHERE `player_id`=3496 && `deleted`=0

      QUERY(5.9221ms) - SELECT AVG(`salary`) FROM `draft_scouting_reports` WHERE `player_id`=3496

      QUERY(0.2902ms) - SELECT SUM(`points`) FROM `users_points` INNER JOIN `users_points_periods` ON `users_points`.`period_id`=`users_points_periods`.`id` WHERE `users_points_periods`.`active`=1 && `user_id`=3496 && `spent`=0

      QUERY(0.236ms) - SELECT SUM(`amount`) FROM `users_balance` WHERE `user_id`=3496 && `spent`=0

      QUERY(0.1471ms) - SELECT id FROM `users_overdue_balances` WHERE `player_id`=3496 && `paid`=0

      QUERY(0.175ms) - SELECT AVG(`score`) FROM `users_trust` WHERE `user_id`=3496

      QUERY(0.1278ms) - SELECT COUNT(`user_id`) FROM `commish` WHERE `user_id`=3496 && `active`=1

      QUERY(0.1709ms) - SELECT `event` FROM `email_errors` WHERE `receiver_id`=3496 && `resolved`=0

      QUERY(0.1249ms) - SELECT `birthdate` FROM `users` WHERE `id`=3496

      QUERY(0.1509ms) - UPDATE `users` SET `age`=26 WHERE `id`=3496

      QUERY(0.1771ms) - SELECT value,text FROM userprofile_fields_initialvalues WHERE field_id = 4

      QUERY(7.2811ms) - SELECT fieldvalue FROM userprofile_profiledata WHERE field_id = '4' && user_id='3496'

      QUERY(0.3421ms) - SELECT `name_url`,`sports`.`name` FROM `sports` INNER JOIN `leagues` ON `sports`.`sport_id`=`leagues`.`sport_id` INNER JOIN `league_players` ON `leagues`.`league_id`=`league_players`.`league_id` && `league_players`.`player_id`=3496 GROUP BY `sports`.`sport_id`

      QUERY(1.1261ms) - INSERT INTO `userprofiles_cache` (`user_id`,`clan_recruiter`,`team_recruiter`,`totalinvites`,`totaloffers`,`age`,`report_id`,`highlights`,`articles`,`venues`,`accomplishments`,`classifieds`,`tracked`,`freeagents`,`groups`,`teams`,`completion`,`unread_offers`,`personal_team`,`reviews`,`coach`,`ships`,`silvers`,`sports`,`active_leagues`,`total_leagues`,`total_ultras`,`avg_salary`,`points_balance`,`cash_balance`,`trust`,`overdue`,`flags`,`commish`,`updated`) VALUES ('3496',0,0,0,0,26,0,0,0,0,0,0,0,0,0,'3',0,0,0,0,'1',0,0,'Softball,Flag Football',0,'3',0,'10',0,0.5,0,0,'',0,NOW()) ON DUPLICATE KEY UPDATE `user_id`='3496',`clan_recruiter`=0,`team_recruiter`=0,`totalinvites`=0,`totaloffers`=0,`age`=26,`report_id`=0,`highlights`=0,`articles`=0,`venues`=0,`accomplishments`=0,`classifieds`=0,`tracked`=0,`freeagents`=0,`groups`=0,`teams`='3',`completion`=0,`unread_offers`=0,`personal_team`=0,`reviews`=0,`coach`='1',`ships`=0,`silvers`=0,`sports`='Softball,Flag Football',`active_leagues`=0,`total_leagues`='3',`total_ultras`=0,`avg_salary`='10',`points_balance`=0,`cash_balance`=0.5,`trust`=0,`overdue`=0,`flags`='',`commish`=0,`updated`=NOW()

      QUERY(0.1531ms) - SELECT `season_unfinished` FROM `userprofiles_cache` WHERE `user_id`=3496

      QUERY(0.139ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.104ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.283ms) - SELECT * FROM `users_sizing` WHERE `user_id`=3496 && (`sport_id`=2 || `sport_id`=0) && (`season_id`=105 || `season_id`=0) ORDER BY `season_id` DESC, `sport_id` DESC

      QUERY(1.3711ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=3496 && `sports_positions_link`.`sport_id`=2 && `primary`=1 && (`season_id`=105 || `season_id`=0) ORDER BY `season_id`=105 DESC LIMIT 0,1

      QUERY(0.3591ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=3496 && `sports_positions_link`.`sport_id`=2 && `primary`=2 && (`season_id`=105 || `season_id`=0) ORDER BY `season_id`=105 DESC LIMIT 0,1

      QUERY(0.463ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=3496 && `sports_positions_link`.`sport_id`=2 && `primary`=3 && (`season_id`=105 || `season_id`=0) ORDER BY `season_id`=105 DESC LIMIT 0,1

      QUERY(0.165ms) - SELECT * FROM `photo` WHERE `photo_id`=0

      QUERY(0.2561ms) - SELECT SQL_CACHE `code` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:49:%' || (`global`=1 && `exclude` NOT LIKE '%:49:%') ) ORDER BY `id` ASC