AuRORA Borealis SC

Soccer

Speakeasy Soccer
Spring 2024

Spring 2024
Overall Team Skill Ratings

Striking

Passing

Ball Handling

Speed

Stamina

Defense

Goalkeeping

    Team Roster

    Player

    Striking
    Passing
    Ball Handling
    Speed
    Stamina
    Defense
    Goalkeeping
    Georon
    | W, DEF, DM
    Rookie

    C
    C
    N
    Aelsar
    | S, W, CF
    Coach

    B
    C
    N
    Damas jean
    | AM, S, DM
    Rookie

    A
    A
    N
    Jair3k
    | W, DM, DEF
    Rookie

    C
    C
    C
    Efrain
    | DM, S, AM

    C
    B
    C
    Cromerov10
    | S, AM, G
    Rookie

    B
    C
    B
    Tsamba
    | S, AM, CF
    Rookie

    A
    A
    N
    BRArchaeologist
    | CB, DM, DEF
    Rookie

    D
    D
    N
    SpeakeasySoccerNoah
    | CB, DEF, AM
    Admin

    C
    D
    N
    JordanTaylor
    | DM, AM, S
    Rookie

    C
    D
    D
      966
      Array
      (
          [team_id] => 966
          [sport_id] => 9
          [league_id] => 0
          [division_id] => 
          [wins] => 0
          [losses] => 0
          [wins_all] => 0
          [losses_all] => 0
          [fullname] => AuRORA Borealis SC
          [shortname] => 
          [abbr] => 
          [fullmascot] => 
          [shortmascot] => 
          [url] => team-austin-soccer-1715737630
          [logo_id] => 9999
          [court_id] => 0
          [color_id] => #18f2e3
          [max_roster_size] => 15
          [gallery_id] => 0
          [approved] => 1
          [active] => 1
          [current_roster_size] => 10
          [owner_id] => 9342
          [public] => 1
          [chat_room_id] => 0
          [personal] => 0
          [deleted] => 0
          [invite_code] => 
          [featured_bg] => 6542
          [color_id_2] => #9313fb
          [color_id_3] => #000000
          [description] => 
          [shirt_color] => 
          [jersey_img] => 0
          [jersey_img_away] => 0
          [leagues] => 1
          [thumb] => /files/gallery/misc/thumbs/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
          [large] => /files/gallery/misc/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
          [alt] => League
          [name] => AuRORA Borealis SC
          [sport_name] => Soccer
          [sport_icon] => fa-solid fa-futbol
          [sport_url] => soccer
          [gameimage] => 
          [roster] => 1
          [earnings] => -
          [group_type] => teams
          [teamorg] => 
          [link] => /team/team-austin-soccer-1715737630/
          [image] => Array
              (
                  [id] => team-austin-soccer-1715737630
                  [thumb] => /files/gallery/misc/thumbs/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
                  [large] => /files/gallery/misc/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
                  [alt] => League
                  [link] => /team/team-austin-soccer-1715737630/
              )
      
          [label] => team
          [game] => All Games
          [tools] => Array
              (
                  [score] => 
                  [homelink] => /team/team-austin-soccer-1715737630/
                  [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] => 9
          [sponsors] => 0
          [reports] => 0
      )
      
      PEAK MEMORY: 2.84 MiB
      MEMORY USAGE AFTER: 2.12 MiB

      Debug Information


      Request Variables

      var = team

      varb = team-austin-soccer-1715737630

      vara =

      varc =

      vard =

      vare =

      Debug Messages

      Site ID: 1

      Sub Domain:

      Domain: netstuffersdev1.com

      Site name: LeagueJoe

      Template: lj

      SECURETOKEN: 375adec5bf587a2be4ffc519bb915d89

      Login Type:

      BASE:: team

      FULL LINK:: team/team-austin-soccer-1715737630

      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 = 375adec5bf587a2be4ffc519bb915d89
      fullstate =


      Cookie Variables

      fikker-61vm-nk2N = MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
      care_did = d2ca0557-b4d3-48c4-82ea-576fa84601ee
      fikker-wPwr-oPkV = AKsHK2s8gMidmJGbYX7hYpSHKrYLWH1P


      Server Variables

      USER = leaguejo_dev
      HOME = /home/leaguejo_dev
      SCRIPT_NAME = /index.php
      REQUEST_URI = /team/team-austin-soccer-1715737630/
      QUERY_STRING = var=team&varb=team-austin-soccer-1715737630
      REQUEST_METHOD = GET
      SERVER_PROTOCOL = HTTP/1.1
      GATEWAY_INTERFACE = CGI/1.1
      REDIRECT_QUERY_STRING = var=team&varb=team-austin-soccer-1715737630
      REDIRECT_URL = /team/team-austin-soccer-1715737630/
      REMOTE_PORT = 10534
      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 = 18.117.154.229
      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/team-austin-soccer-1715737630
      HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
      HTTP_COOKIE = fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E; care_did=d2ca0557-b4d3-48c4-82ea-576fa84601ee; fikker-wPwr-oPkV=AKsHK2s8gMidmJGbYX7hYpSHKrYLWH1P
      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/team-austin-soccer-1715737630/
      SCRIPT_URL = /team/team-austin-soccer-1715737630/
      UNIQUE_ID = Z0AQhe9urvFP-X@yUD3GLgAAAJE
      REDIRECT_STATUS = 200
      REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
      REDIRECT_HTTPS = on
      REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/team/team-austin-soccer-1715737630/
      REDIRECT_SCRIPT_URL = /team/team-austin-soccer-1715737630/
      REDIRECT_UNIQUE_ID = Z0AQhe9urvFP-X@yUD3GLgAAAJE
      FCGI_ROLE = RESPONDER
      PHP_SELF = /index.php
      REQUEST_TIME_FLOAT = 1732251781.2953
      REQUEST_TIME = 1732251781


      SQL Queries


      Total Queries: 148
      Total Execution Time: 54.516ms
      Avg Execution Time:0.36835135135135ms

      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', '05:03:01', 'GET', '/team/team-austin-soccer-1715737630/', '18.117.154.229', 'https://netstuffersdev1.com/team/team-austin-soccer-1715737630' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheGx6WkxGY1NrRlpsdHpFV28wZkVsbkxOc2NSbUpPS0lOMzZTYjVtZWUxK202NDhuWGFqQTBIZGZ2SmlZaHB6V004N2lMc1N3dnNRdy9hanZQbWQzSGs=','0','','1732251781') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

      QUERY(0.1521ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/team/team-austin-soccer-1715737630/'

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

      QUERY(0.2198ms) - 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.1621ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1409ms) - SELECT * FROM userprofiles_config

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

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

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

      QUERY(0.1302ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.447ms) - 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` = 'team-austin-soccer-1715737630'

      QUERY(0.7391ms) - 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` = 'team-austin-soccer-1715737630' GROUP BY `teams`.`team_id`

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

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

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

      QUERY(0.1168ms) - SELECT * FROM `teams_settings` WHERE `team_id`=966

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

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

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

      QUERY(0.1471ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=966

      QUERY(2.131ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=966

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

      QUERY(0.237ms) - 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.1299ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='UTC'

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

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

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

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

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

      QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.104ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.164ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.108ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.4621ms) - 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` = 'team-austin-soccer-1715737630'

      QUERY(0.6738ms) - 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` = 'team-austin-soccer-1715737630' GROUP BY `teams`.`team_id`

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

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

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

      QUERY(0.1161ms) - SELECT * FROM `teams_settings` WHERE `team_id`=966

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

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

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

      QUERY(0.1578ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=966

      QUERY(2.0659ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=966

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

      QUERY(0.1671ms) - SELECT `season_id` FROM `league_teams` WHERE `team_id`=966

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

      QUERY(0.4752ms) - 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` = '133' LIMIT 0,1

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

      QUERY(0.545ms) - 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` = '133' and `league_seasons`.`season_id` = '254' ORDER BY `league_dates`.`start_date` ASC

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

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

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

      QUERY(0.1891ms) - 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`=133 && `season_id`=254 LIMIT 0,1

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

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

      QUERY(0.154ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=966

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

      QUERY(0.108ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1502ms) - SELECT `league_id`,`season_id` FROM `league_teams` WHERE `team_id`=966

      QUERY(0.448ms) - 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` = '133' LIMIT 0,1

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

      QUERY(0.4432ms) - 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` = '133' and `league_seasons`.`season_id` = '254' ORDER BY `league_dates`.`start_date` ASC

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

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

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

      QUERY(0.1841ms) - 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`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.206ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

      QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.0961ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.0951ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.1352ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.1261ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.145ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=966

      QUERY(0.268ms) - SELECT * FROM `team_strength` WHERE `team_id`=966 && `season_id`=254

      QUERY(0.185ms) - SELECT * FROM `team_strength` WHERE `team_id`=966 && `season_id`=254

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

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

      QUERY(0.1111ms) - SELECT SQL_CACHE * FROM sports_config

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

      QUERY(0.102ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.1202ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.165ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='133' && `season_id`='254'

      QUERY(0.9351ms) - 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` = '133' and `league_teams`.`season_id` = '254' ORDER BY `teams`.`fullname` desc

      QUERY(0.273ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=965 && `league_id`='133' && `season_id`='254'

      QUERY(0.169ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=963 && `league_id`='133' && `season_id`='254'

      QUERY(0.149ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=966 && `league_id`='133' && `season_id`='254'

      QUERY(0.1571ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=964 && `league_id`='133' && `season_id`='254'

      QUERY(4.858ms) - 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`=32 LIMIT 0,1) AS `stamina`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=33 LIMIT 0,1) AS `goalkeeping`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=34 LIMIT 0,1) AS `speed`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=35 LIMIT 0,1) AS `passing`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=36 LIMIT 0,1) AS `striking`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=37 LIMIT 0,1) AS `defense`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=38 LIMIT 0,1) AS `dribble`,(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`=9 ORDER BY `season_id`=254 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`=9 ORDER BY `season_id`=254 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`=9 ORDER BY `season_id`=254 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`=9 ORDER BY `season_id`=254 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` = '254' and `teams_players`.`team_id` = '966' and `teams_players`.`quit` = '0' ORDER BY `users`.`last_name` ASC LIMIT 0,500

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

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

      QUERY(0.3982ms) - 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`=966 && (`coach`=1 || `access`=4 || `access`=5 || `access`=6) ORDER BY `access` DESC

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

      QUERY(0.1359ms) - SELECT * FROM userprofiles_config

      QUERY(0.5012ms) - 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`='aelsar' LIMIT 0,1

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

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

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

      QUERY(0.128ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(1.1461ms) - UPDATE users SET `lastip`='18.117.154.229' WHERE `id`=9342

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

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

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

      QUERY(0.2921ms) - 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`='9342'

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

      QUERY(0.145ms) - SELECT `avatar_id` FROM `users` WHERE `id`=9342

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

      QUERY(0.3519ms) - 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`=9342 && `deleted`=0

      QUERY(0.3569ms) - 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`=9342 && `deleted`=0

      QUERY(5.6269ms) - SELECT AVG(`salary`) FROM `draft_scouting_reports` WHERE `player_id`=9342

      QUERY(0.267ms) - 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`=9342 && `spent`=0

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

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

      QUERY(0.1929ms) - SELECT AVG(`score`) FROM `users_trust` WHERE `user_id`=9342

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

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

      QUERY(0.1171ms) - SELECT `birthdate` FROM `users` WHERE `id`=9342

      QUERY(0.1671ms) - UPDATE `users` SET `age`=25 WHERE `id`=9342

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

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

      QUERY(0.3209ms) - 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`=9342 GROUP BY `sports`.`sport_id`

      QUERY(1.3051ms) - 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 ('9342',0,0,0,0,25,0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'1',0,0,'Soccer',0,'1',0,'9',0,0.5,0,0,'',0,NOW()) ON DUPLICATE KEY UPDATE `user_id`='9342',`clan_recruiter`=0,`team_recruiter`=0,`totalinvites`=0,`totaloffers`=0,`age`=25,`report_id`=0,`highlights`=0,`articles`=0,`venues`=0,`accomplishments`=0,`classifieds`=0,`tracked`=0,`freeagents`=0,`groups`=0,`teams`='1',`completion`=0,`unread_offers`=0,`personal_team`=0,`reviews`=0,`coach`='1',`ships`=0,`silvers`=0,`sports`='Soccer',`active_leagues`=0,`total_leagues`='1',`total_ultras`=0,`avg_salary`='9',`points_balance`=0,`cash_balance`=0.5,`trust`=0,`overdue`=0,`flags`='',`commish`=0,`updated`=NOW()

      QUERY(0.1519ms) - SELECT `season_unfinished` FROM `userprofiles_cache` WHERE `user_id`=9342

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

      QUERY(0.176ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.3359ms) - SELECT * FROM `users_sizing` WHERE `user_id`=9342 && (`sport_id`=9 || `sport_id`=0) && (`season_id`=254 || `season_id`=0) ORDER BY `season_id` DESC, `sport_id` DESC

      QUERY(0.864ms) - 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`=9342 && `sports_positions_link`.`sport_id`=9 && `primary`=1 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

      QUERY(0.4561ms) - 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`=9342 && `sports_positions_link`.`sport_id`=9 && `primary`=2 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

      QUERY(0.387ms) - 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`=9342 && `sports_positions_link`.`sport_id`=9 && `primary`=3 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

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

      QUERY(0.2251ms) - 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