AM

Austin Murphy

Austin Murphy

All Time Points : 300
|
Wins : 1

Tournaments Played : 13

Austin Murphy

Tournament History

Austin Murphy Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version410msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[23:23:07] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (43.92ms)time
  • Application (366ms)time
  • 1 x Application (89.28%)
    366ms
    1 x Booting (10.72%)
    43.92ms
    16 templates were rendered
    • site.leaderboard.showshow.blade.php#?blade
    • site.leaderboard.card.player_infoplayer_info.blade.php#?blade
    • site.leaderboard.card.player_tournament_statplayer_tournament_stat.blade.php#?blade
    • site.leaderboard.card.player_related_newsplayer_related_news.blade.php#?blade
    • site.leaderboard.card.player_related_videosplayer_related_videos.blade.php#?blade
    • site.layouts.appapp.blade.php#?blade
    • site.includes.headerheader.blade.php#?blade
    • flash::messagemessage.blade.php#?blade
    • site.includes.code_of_conductcode_of_conduct.blade.php#?blade
    • site.includes.footerfooter.blade.php#?blade
    • site.includes.footer_modules.dpt_infodpt_info.blade.php#?blade
    • site.includes.footer_modules.social_mediasocial_media.blade.php#?blade
    • site.includes.footer_modules.about_dptabout_dpt.blade.php#?blade
    • site.includes.footer_modules.quick_linkquick_link.blade.php#?blade
    • site.includes.footer_modules.fpn_contactfpn_contact.blade.php#?blade
    • site.includes.footer_modules.copyrightcopyright.blade.php#?blade
    uri
    GET player/{id}
    middleware
    web, PersonalInfoMiddleware
    controller
    App\Http\Controllers\Site\LeaderBoardController@show
    as
    site.leaderboard.show
    namespace
    prefix
    where
    file
    app/Http/Controllers/Site/LeaderBoardController.php:237-338
    36 statements were executed (4 duplicates)Show only duplicates285ms
    • PersonalInfoMiddleware.php#16fpnstagingConnection Established
      Backtrace
      • middleware::PersonalInfoMiddleware:16
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/CheckUserStatus.php:26
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/UpdateLastActivity.php:26
    • LeaderBoardController.php#239fpnstaging2.42msselect * from `users` where `alias` = 'austin-murphy' limit 1
      Bindings
      • 0: austin-murphy
      Backtrace
      • app/Http/Controllers/Site/LeaderBoardController.php:239
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • User.php#154fpnstaging1.56msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 14999 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 14999
      • 1: 0
      Backtrace
      • app/Models/User.php:154
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#166fpnstaging910μsselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 14999 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 14999
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Models/User.php:166
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#178fpnstaging1.05msselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 14999 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 14999
      • 1: 1
      • 2: 1
      Backtrace
      • app/Models/User.php:178
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#190fpnstaging1.11msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 14999 and `tournament_players`.`final_table` = 1 and `fpn_tournaments`.`payout_distribution_id` != 2 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 14999
      • 1: 1
      • 2: 2
      • 3: 1
      • 4: 1
      Backtrace
      • app/Models/User.php:190
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#192fpnstaging1.25msselect `tournament_players`.*, `users`.`id` as `uid`, `users`.*, `fpn_tournaments`.`name` as `tournament_name`, `fpn_tournaments`.`id` as `tid`, `fpn_tournaments`.`start_date` as `tournament_start_date`, `fpn_promotions`.`id` as `sid`, `fpn_promotions`.`name` as `season_name`, `fpn_leagues`.`id`, `fpn_leagues`.`season_id`, `fpn_venues`.`name` as `venue_name`, `fpn_venues`.`address`, `fpn_venues`.`city`, `fpn_venues`.`state` from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 14999) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 14999
      Backtrace
      • app/Models/User.php:192
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#198fpnstaging1.08msselect sum(`winnings`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 14999) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 14999
      Backtrace
      • app/Models/User.php:198
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#198fpnstaging1.15msselect sum(`bounty`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 14999) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 14999
      Backtrace
      • app/Models/User.php:198
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#199fpnstaging1.19msselect sum(`score`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 14999) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 14999
      Backtrace
      • app/Models/User.php:199
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • User.php#199fpnstaging1.03msselect sum(`bounty`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 14999) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 14999
      Backtrace
      • app/Models/User.php:199
      • app/Http/Controllers/Site/LeaderBoardController.php:243
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Article.php#163fpnstaging54.67msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('14999',associated_user_ids)
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Article.php:163
      • app/Http/Controllers/Site/LeaderBoardController.php:264
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Article.php#174fpnstaging48.51msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('14999',associated_user_ids) order by `published_at` desc
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Article.php:174
      • app/Http/Controllers/Site/LeaderBoardController.php:264
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • TournamentPlayer.php#176fpnstaging49.37msselect * from `articles` where find_in_set(14999, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 14999
      • 1: 1
      • 2: 
      Backtrace
      • app/Models/TournamentPlayer.php:176
      • app/Http/Controllers/Site/LeaderBoardController.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ConfigSevice.php#214fpnstaging620μsselect `default_article_image` from `configurations`
      Backtrace
      • app/Services/ConfigSevice.php:214
      • app/Http/Controllers/Site/LeaderBoardController.php:271
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • LeaderBoardController.php#304fpnstaging1.87msselect `fpn_promotions`.`id`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_promotions`.`icons_badges_tooltip`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_tournaments`.`alias` as `tournament_alias`, `fpn_tournaments`.`start_date` from `fpn_tournaments` left join `fpn_promotions` on FIND_IN_SET(fpn_promotions.id, fpn_tournaments.qualifier_promotion_ids) > 0 inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`qualifier_types` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 and `tournament_players`.`rank` = 1 and `tournament_players`.`user_id` = 14999 and `fpn_tournaments`.`event_id` not in (502) group by `fpn_tournaments`.`id` order by `fpn_promotions`.`id` desc
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 14999
      • 4: 502
      Backtrace
      • app/Http/Controllers/Site/LeaderBoardController.php:304
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • League.php#1828fpnstaging1.21msselect `fpn_promotions`.`id`, `fpn_promotions`.`name`, `fpn_promotions`.`icons_badges`, `fpn_promotions`.`alias`, `fpn_promotions`.`icons_badges_tooltip` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'austin-murphy' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: austin-murphy
      • 2: 502
      • 3: 957
      Backtrace
      • app/Models/League.php:1828
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1848fpnstaging980μsselect `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 25 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'austin-murphy' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 25
      • 1: 1
      • 2: austin-murphy
      • 3: 502
      • 4: 957
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging470μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 899 limit 1
      Bindings
      • 0: 899
      Backtrace
      • app/Models/League.php:1857
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1862fpnstaging560μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-02 23:23:07' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-05-02 23:23:07
      • 3: 1
      Backtrace
      • app/Models/League.php:1862
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.12msselect `id` from `fpn_tournaments` where `event_id` = 899 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 899
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging17.6msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 899 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53353, 53354, 53355, 53356, 53357, 53358, 53359, 53360, 53361, 53362, 53363, 53364, 53365, 53379, 53380, 53381, 53382, 53383, 53384, 53385, 53386, 53387, 53388, 53389, 53390, 53391, 53406, 53407, 53408, 53409, 53410, 53411, 53412, 53413, 53414, 53415, 53416, 53417, 53431, 53432, 53433, 53434, 53435, 53436, 53437, 53438, 53439, 53440, 53441, 53442, 53443, 53457, 53458, 53459, 53460, 53461, 53462, 53463, 53464, 53465, 53466, 53467, 53468, 53469, 53483, 53484, 53485, 53486, 53487, 53488, 53489, 53490, 53491, 53492, 53493, 53494, 53495, 53509, 53510, 53511, 53512, 53513, 53514, 53515, 53516, 53517, 53518, 53519, 53520, 53521) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 899
      • 1: 1
      • 2: 53353
      • 3: 53354
      • 4: 53355
      • 5: 53356
      • 6: 53357
      • 7: 53358
      • 8: 53359
      • 9: 53360
      • 10: 53361
      • 11: 53362
      • 12: 53363
      • 13: 53364
      • 14: 53365
      • 15: 53379
      • 16: 53380
      • 17: 53381
      • 18: 53382
      • 19: 53383
      • 20: 53384
      • 21: 53385
      • 22: 53386
      • 23: 53387
      • 24: 53388
      • 25: 53389
      • 26: 53390
      • 27: 53391
      • 28: 53406
      • 29: 53407
      • 30: 53408
      • 31: 53409
      • 32: 53410
      • 33: 53411
      • 34: 53412
      • 35: 53413
      • 36: 53414
      • 37: 53415
      • 38: 53416
      • 39: 53417
      • 40: 53431
      • 41: 53432
      • 42: 53433
      • 43: 53434
      • 44: 53435
      • 45: 53436
      • 46: 53437
      • 47: 53438
      • 48: 53439
      • 49: 53440
      • 50: 53441
      • 51: 53442
      • 52: 53443
      • 53: 53457
      • 54: 53458
      • 55: 53459
      • 56: 53460
      • 57: 53461
      • 58: 53462
      • 59: 53463
      • 60: 53464
      • 61: 53465
      • 62: 53466
      • 63: 53467
      • 64: 53468
      • 65: 53469
      • 66: 53483
      • 67: 53484
      • 68: 53485
      • 69: 53486
      • 70: 53487
      • 71: 53488
      • 72: 53489
      • 73: 53490
      • 74: 53491
      • 75: 53492
      • 76: 53493
      • 77: 53494
      • 78: 53495
      • 79: 53509
      • 80: 53510
      • 81: 53511
      • 82: 53512
      • 83: 53513
      • 84: 53514
      • 85: 53515
      • 86: 53516
      • 87: 53517
      • 88: 53518
      • 89: 53519
      • 90: 53520
      • 91: 53521
      • 92: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.41msselect `id` from `fpn_tournaments` where `event_id` = 899 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 899
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging14.56msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 899 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53340, 53341, 53342, 53343, 53344, 53345, 53346, 53347, 53348, 53349, 53350, 53351, 53352, 53366, 53367, 53368, 53369, 53370, 53371, 53372, 53373, 53374, 53375, 53376, 53377, 53378, 53392, 53393, 53394, 53395, 53396, 53397, 53398, 53399, 53400, 53401, 53402, 53403, 53404, 53405, 53418, 53419, 53420, 53421, 53422, 53423, 53424, 53425, 53426, 53427, 53428, 53429, 53430, 53444, 53445, 53446, 53447, 53448, 53449, 53450, 53451, 53452, 53453, 53454, 53455, 53456, 53470, 53471, 53472, 53473, 53474, 53475, 53476, 53477, 53478, 53479, 53480, 53481, 53482, 53496, 53497, 53498, 53499, 53500, 53501, 53502, 53503, 53504, 53505, 53506, 53507, 53508) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 899
      • 1: 1
      • 2: 53340
      • 3: 53341
      • 4: 53342
      • 5: 53343
      • 6: 53344
      • 7: 53345
      • 8: 53346
      • 9: 53347
      • 10: 53348
      • 11: 53349
      • 12: 53350
      • 13: 53351
      • 14: 53352
      • 15: 53366
      • 16: 53367
      • 17: 53368
      • 18: 53369
      • 19: 53370
      • 20: 53371
      • 21: 53372
      • 22: 53373
      • 23: 53374
      • 24: 53375
      • 25: 53376
      • 26: 53377
      • 27: 53378
      • 28: 53392
      • 29: 53393
      • 30: 53394
      • 31: 53395
      • 32: 53396
      • 33: 53397
      • 34: 53398
      • 35: 53399
      • 36: 53400
      • 37: 53401
      • 38: 53402
      • 39: 53403
      • 40: 53404
      • 41: 53405
      • 42: 53418
      • 43: 53419
      • 44: 53420
      • 45: 53421
      • 46: 53422
      • 47: 53423
      • 48: 53424
      • 49: 53425
      • 50: 53426
      • 51: 53427
      • 52: 53428
      • 53: 53429
      • 54: 53430
      • 55: 53444
      • 56: 53445
      • 57: 53446
      • 58: 53447
      • 59: 53448
      • 60: 53449
      • 61: 53450
      • 62: 53451
      • 63: 53452
      • 64: 53453
      • 65: 53454
      • 66: 53455
      • 67: 53456
      • 68: 53470
      • 69: 53471
      • 70: 53472
      • 71: 53473
      • 72: 53474
      • 73: 53475
      • 74: 53476
      • 75: 53477
      • 76: 53478
      • 77: 53479
      • 78: 53480
      • 79: 53481
      • 80: 53482
      • 81: 53496
      • 82: 53497
      • 83: 53498
      • 84: 53499
      • 85: 53500
      • 86: 53501
      • 87: 53502
      • 88: 53503
      • 89: 53504
      • 90: 53505
      • 91: 53506
      • 92: 53507
      • 93: 53508
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1848fpnstaging1.28msselect `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 24 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'austin-murphy' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 24
      • 1: 1
      • 2: austin-murphy
      • 3: 502
      • 4: 957
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging540μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 638 limit 1
      Bindings
      • 0: 638
      Backtrace
      • app/Models/League.php:1857
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1862fpnstaging570μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 23:23:07' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-05-02 23:23:07
      • 3: 1
      Backtrace
      • app/Models/League.php:1862
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.16msselect `id` from `fpn_tournaments` where `event_id` = 638 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 638
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging15.11msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 638 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (47534, 47535, 47536, 47537, 47538, 47547, 47548, 47549, 47550, 47551, 47552, 47562, 47563, 47564, 47565, 47566, 47567, 47576, 47577, 47578, 47579, 47580, 47590, 47591, 47592, 47593, 47594, 47604, 47605, 47606, 47607, 47608, 47618, 47619, 47620, 47621, 47622, 48992, 48993, 48994, 48995, 48996, 48997, 48998, 48999, 49000, 49001, 49002, 49003, 49004, 49005, 49006, 49007, 49008, 49009, 49010, 49011, 49012, 49013, 49014, 49015, 49016, 49017, 49018, 49019, 49020, 49021, 49022, 49023, 49024, 49025, 49026, 49027, 49028, 49029, 49030, 49031, 49032, 49033, 49034, 49035, 49036, 49037, 49038, 49039, 49040, 49041, 49042, 49043, 49044, 49045, 49046) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 638
      • 1: 1
      • 2: 47534
      • 3: 47535
      • 4: 47536
      • 5: 47537
      • 6: 47538
      • 7: 47547
      • 8: 47548
      • 9: 47549
      • 10: 47550
      • 11: 47551
      • 12: 47552
      • 13: 47562
      • 14: 47563
      • 15: 47564
      • 16: 47565
      • 17: 47566
      • 18: 47567
      • 19: 47576
      • 20: 47577
      • 21: 47578
      • 22: 47579
      • 23: 47580
      • 24: 47590
      • 25: 47591
      • 26: 47592
      • 27: 47593
      • 28: 47594
      • 29: 47604
      • 30: 47605
      • 31: 47606
      • 32: 47607
      • 33: 47608
      • 34: 47618
      • 35: 47619
      • 36: 47620
      • 37: 47621
      • 38: 47622
      • 39: 48992
      • 40: 48993
      • 41: 48994
      • 42: 48995
      • 43: 48996
      • 44: 48997
      • 45: 48998
      • 46: 48999
      • 47: 49000
      • 48: 49001
      • 49: 49002
      • 50: 49003
      • 51: 49004
      • 52: 49005
      • 53: 49006
      • 54: 49007
      • 55: 49008
      • 56: 49009
      • 57: 49010
      • 58: 49011
      • 59: 49012
      • 60: 49013
      • 61: 49014
      • 62: 49015
      • 63: 49016
      • 64: 49017
      • 65: 49018
      • 66: 49019
      • 67: 49020
      • 68: 49021
      • 69: 49022
      • 70: 49023
      • 71: 49024
      • 72: 49025
      • 73: 49026
      • 74: 49027
      • 75: 49028
      • 76: 49029
      • 77: 49030
      • 78: 49031
      • 79: 49032
      • 80: 49033
      • 81: 49034
      • 82: 49035
      • 83: 49036
      • 84: 49037
      • 85: 49038
      • 86: 49039
      • 87: 49040
      • 88: 49041
      • 89: 49042
      • 90: 49043
      • 91: 49044
      • 92: 49045
      • 93: 49046
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.27msselect `id` from `fpn_tournaments` where `event_id` = 638 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 638
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging16.63msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 638 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (38677, 38678, 38679, 38680, 38681, 38682, 38683, 38684, 38685, 38686, 38687, 38688, 38703, 38704, 38705, 38706, 38707, 38708, 38709, 38710, 38711, 38712, 38713, 38714, 38715, 38730, 38731, 38732, 38733, 38734, 38735, 38736, 38737, 38738, 38739, 38740, 38741, 38742, 38756, 38757, 38758, 38759, 38760, 38761, 38762, 38763, 38764, 38765, 38766, 38767, 38782, 38783, 38784, 38785, 38786, 38787, 38788, 38789, 38790, 38791, 38792, 38793, 38808, 38809, 38810, 38811, 38812, 38813, 38814, 38815, 38816, 38817, 38818, 38819, 38834, 38835, 38836, 38837, 38838, 38839, 38840, 38841, 38842, 38843, 38844, 38845, 47533, 47561, 47575, 47589, 47603, 47617) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 638
      • 1: 1
      • 2: 38677
      • 3: 38678
      • 4: 38679
      • 5: 38680
      • 6: 38681
      • 7: 38682
      • 8: 38683
      • 9: 38684
      • 10: 38685
      • 11: 38686
      • 12: 38687
      • 13: 38688
      • 14: 38703
      • 15: 38704
      • 16: 38705
      • 17: 38706
      • 18: 38707
      • 19: 38708
      • 20: 38709
      • 21: 38710
      • 22: 38711
      • 23: 38712
      • 24: 38713
      • 25: 38714
      • 26: 38715
      • 27: 38730
      • 28: 38731
      • 29: 38732
      • 30: 38733
      • 31: 38734
      • 32: 38735
      • 33: 38736
      • 34: 38737
      • 35: 38738
      • 36: 38739
      • 37: 38740
      • 38: 38741
      • 39: 38742
      • 40: 38756
      • 41: 38757
      • 42: 38758
      • 43: 38759
      • 44: 38760
      • 45: 38761
      • 46: 38762
      • 47: 38763
      • 48: 38764
      • 49: 38765
      • 50: 38766
      • 51: 38767
      • 52: 38782
      • 53: 38783
      • 54: 38784
      • 55: 38785
      • 56: 38786
      • 57: 38787
      • 58: 38788
      • 59: 38789
      • 60: 38790
      • 61: 38791
      • 62: 38792
      • 63: 38793
      • 64: 38808
      • 65: 38809
      • 66: 38810
      • 67: 38811
      • 68: 38812
      • 69: 38813
      • 70: 38814
      • 71: 38815
      • 72: 38816
      • 73: 38817
      • 74: 38818
      • 75: 38819
      • 76: 38834
      • 77: 38835
      • 78: 38836
      • 79: 38837
      • 80: 38838
      • 81: 38839
      • 82: 38840
      • 83: 38841
      • 84: 38842
      • 85: 38843
      • 86: 38844
      • 87: 38845
      • 88: 47533
      • 89: 47561
      • 90: 47575
      • 91: 47589
      • 92: 47603
      • 93: 47617
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging600μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 637 limit 1
      Bindings
      • 0: 637
      Backtrace
      • app/Models/League.php:1857
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1862fpnstaging570μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 23:23:07' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-05-02 23:23:07
      • 3: 1
      Backtrace
      • app/Models/League.php:1862
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.13msselect `id` from `fpn_tournaments` where `event_id` = 637 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 637
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging19.02msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 637 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (47632, 47633, 47634, 47635, 47636, 47645, 47646, 47647, 47648, 47649, 47650, 47660, 47661, 47662, 47663, 47664, 47665, 47674, 47675, 47676, 47677, 47678, 47688, 47689, 47690, 47691, 47692, 47702, 47703, 47704, 47705, 47706, 47716, 47717, 47718, 47719, 47720, 49047, 49048, 49049, 49050, 49051, 49052, 49053, 49054, 49055, 49056, 49057, 49058, 49059, 49060, 49061, 49062, 49063, 49064, 49065, 49066, 49067, 49068, 49069, 49070, 49071, 49072, 49073, 49074, 49075, 49076, 49077, 49078, 49079, 49080, 49081, 49082, 49083, 49084, 49085, 49086, 49087, 49088, 49089, 49090, 49091, 49092, 49093, 49094, 49095, 49096, 49097, 49098, 49099, 49100, 49101) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 637
      • 1: 1
      • 2: 47632
      • 3: 47633
      • 4: 47634
      • 5: 47635
      • 6: 47636
      • 7: 47645
      • 8: 47646
      • 9: 47647
      • 10: 47648
      • 11: 47649
      • 12: 47650
      • 13: 47660
      • 14: 47661
      • 15: 47662
      • 16: 47663
      • 17: 47664
      • 18: 47665
      • 19: 47674
      • 20: 47675
      • 21: 47676
      • 22: 47677
      • 23: 47678
      • 24: 47688
      • 25: 47689
      • 26: 47690
      • 27: 47691
      • 28: 47692
      • 29: 47702
      • 30: 47703
      • 31: 47704
      • 32: 47705
      • 33: 47706
      • 34: 47716
      • 35: 47717
      • 36: 47718
      • 37: 47719
      • 38: 47720
      • 39: 49047
      • 40: 49048
      • 41: 49049
      • 42: 49050
      • 43: 49051
      • 44: 49052
      • 45: 49053
      • 46: 49054
      • 47: 49055
      • 48: 49056
      • 49: 49057
      • 50: 49058
      • 51: 49059
      • 52: 49060
      • 53: 49061
      • 54: 49062
      • 55: 49063
      • 56: 49064
      • 57: 49065
      • 58: 49066
      • 59: 49067
      • 60: 49068
      • 61: 49069
      • 62: 49070
      • 63: 49071
      • 64: 49072
      • 65: 49073
      • 66: 49074
      • 67: 49075
      • 68: 49076
      • 69: 49077
      • 70: 49078
      • 71: 49079
      • 72: 49080
      • 73: 49081
      • 74: 49082
      • 75: 49083
      • 76: 49084
      • 77: 49085
      • 78: 49086
      • 79: 49087
      • 80: 49088
      • 81: 49089
      • 82: 49090
      • 83: 49091
      • 84: 49092
      • 85: 49093
      • 86: 49094
      • 87: 49095
      • 88: 49096
      • 89: 49097
      • 90: 49098
      • 91: 49099
      • 92: 49100
      • 93: 49101
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.25msselect `id` from `fpn_tournaments` where `event_id` = 637 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 637
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging19.68msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 637 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (38494, 38495, 38496, 38497, 38498, 38499, 38500, 38501, 38502, 38503, 38504, 38505, 38520, 38521, 38522, 38523, 38524, 38525, 38526, 38527, 38528, 38529, 38530, 38531, 38532, 38547, 38548, 38549, 38550, 38551, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38573, 38574, 38575, 38576, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38584, 38599, 38600, 38601, 38602, 38603, 38604, 38605, 38606, 38607, 38608, 38609, 38610, 38625, 38626, 38627, 38628, 38629, 38630, 38631, 38632, 38633, 38634, 38635, 38636, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38658, 38659, 38660, 38661, 38662, 47631, 47659, 47673, 47687, 47701, 47715) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 637
      • 1: 1
      • 2: 38494
      • 3: 38495
      • 4: 38496
      • 5: 38497
      • 6: 38498
      • 7: 38499
      • 8: 38500
      • 9: 38501
      • 10: 38502
      • 11: 38503
      • 12: 38504
      • 13: 38505
      • 14: 38520
      • 15: 38521
      • 16: 38522
      • 17: 38523
      • 18: 38524
      • 19: 38525
      • 20: 38526
      • 21: 38527
      • 22: 38528
      • 23: 38529
      • 24: 38530
      • 25: 38531
      • 26: 38532
      • 27: 38547
      • 28: 38548
      • 29: 38549
      • 30: 38550
      • 31: 38551
      • 32: 38552
      • 33: 38553
      • 34: 38554
      • 35: 38555
      • 36: 38556
      • 37: 38557
      • 38: 38558
      • 39: 38573
      • 40: 38574
      • 41: 38575
      • 42: 38576
      • 43: 38577
      • 44: 38578
      • 45: 38579
      • 46: 38580
      • 47: 38581
      • 48: 38582
      • 49: 38583
      • 50: 38584
      • 51: 38599
      • 52: 38600
      • 53: 38601
      • 54: 38602
      • 55: 38603
      • 56: 38604
      • 57: 38605
      • 58: 38606
      • 59: 38607
      • 60: 38608
      • 61: 38609
      • 62: 38610
      • 63: 38625
      • 64: 38626
      • 65: 38627
      • 66: 38628
      • 67: 38629
      • 68: 38630
      • 69: 38631
      • 70: 38632
      • 71: 38633
      • 72: 38634
      • 73: 38635
      • 74: 38636
      • 75: 38651
      • 76: 38652
      • 77: 38653
      • 78: 38654
      • 79: 38655
      • 80: 38656
      • 81: 38657
      • 82: 38658
      • 83: 38659
      • 84: 38660
      • 85: 38661
      • 86: 38662
      • 87: 47631
      • 88: 47659
      • 89: 47673
      • 90: 47687
      • 91: 47701
      • 92: 47715
      • 93: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    App\Models\Season
    6Season.php#?
    App\Models\Promotion
    3Promotion.php#?
    App\Models\User
    1User.php#?
        • missed 3QH6uNM4VRo5SjuqjjuCteoeGnIDvEzKRnvS2Z8m (0μs)
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • hit c_config (0μs)forget
        • written 3QH6uNM4VRo5SjuqjjuCteoeGnIDvEzKRnvS2Z8m (0μs)forget
        • 1 x missed 3QH6uNM4VRo5SjuqjjuCteoeGnIDvEzKRnvS2Z8m (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written 3QH6uNM4VRo5SjuqjjuCteoeGnIDvEzKRnvS2Z8m (0%)
          0μs
        _token
        e63D4fideWyfMVbgXpaLNmiptqPRgimFONMdKBWf
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/austin-murphy" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/austin-murphy
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sat, 03 May 2025 04:23:07 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJhS3dkQjdVVEh4WlZHUGdCNzhrZnc9PSIsInZhbHVlIjoiQXgrSjBKVk83Zy82eTVzekFrU3ZkU0R0UmF3ZDBjNlFuMHR6QVlzVFJVa0Z2dnhDOHgyL3hlWk5SVjhVNVFoM0FYMG5YZzUwUzluMG0rdWdvYU82ck80QTM2bzhEaE1PZCtXNGxaR0tKS1BpajVXck1CWjB6ZHRDSndIRnd0YjMiLCJtYWMiOiJlNWQ4NmQyZDkyZGY4OTE1NWIyNTQzZjk4ZWNkZGVkMjdlYjlmYmFlMGM4ODgyZjNkNmVlZjIwYmUzYWE5YjY2IiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 04:23:07 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjJhS3dkQjdVVEh4WlZHUGdCNzhrZnc9PSIsInZhbHVlIjoiQXgrSjBKVk83Zy82eTVzekFrU3ZkU0R0UmF3ZDBjNlFuMHR6QVlzVFJVa0Z2dnhDOHgyL3hlWk5SVjhVNVFoM0FYMG5YZ" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImY2d1VvVmt0aDkvVndZeGM4aHhRQVE9PSIsInZhbHVlIjoiMXUxWndYZWQ5NHJrMmZSV2ZJYXNIK2ZBNGx2QnFZYkhVVTA2VExRSWYrSWxJQ3FmVnBPUkZEUFpZRXUyWk8yTHZteldjUGg1SDBmL2JZTHFNTy82cHFiNmhKRUR4SWt0YzNybnBvVDhQWnprZS8yYWtaTyt5d24yc3VNcmhBbysiLCJtYWMiOiI3ZDRhMzNjYTk1NzFhZDMyMGY1MjM5Y2VlYTk2MzNiNDc2OTUxMDZlNzhmYjEwZTU0YmRhYWU1MzFlM2NhNjljIiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 04:23:07 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6ImY2d1VvVmt0aDkvVndZeGM4aHhRQVE9PSIsInZhbHVlIjoiMXUxWndYZWQ5NHJrMmZSV2ZJYXNIK2ZBNGx2QnFZYkhVVTA2VExRSWYrSWxJQ3FmVnBPUkZ" 2 => "RSVP_status=eyJpdiI6InBmUW5LYkp0Um5WRUFqaWFTcXBBSlE9PSIsInZhbHVlIjoic0sybXJnVmlTUzFsRUVsR0lQVnBRZ2tLa3FOU081bGVKMlJ4dmg3dS9mUkJvcktVV2dVcXV4RktqQmFqazJDTCIsIm1hYyI6Ijc5NjNhMWU3NzFhMmYzZDhiZDA3ZGZiOWM5Y2EyMjA4ZWM2MTEwMDFlYTJmZDUwMWYzOWJiNWIxY2QyMWIwMDYiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04 May 2020 04:23:07 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6InBmUW5LYkp0Um5WRUFqaWFTcXBBSlE9PSIsInZhbHVlIjoic0sybXJnVmlTUzFsRUVsR0lQVnBRZ2tLa3FOU081bGVKMlJ4dmg3dS9mUkJvcktVV2dVcXV4RktqQmFqazJDTCIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJhS3dkQjdVVEh4WlZHUGdCNzhrZnc9PSIsInZhbHVlIjoiQXgrSjBKVk83Zy82eTVzekFrU3ZkU0R0UmF3ZDBjNlFuMHR6QVlzVFJVa0Z2dnhDOHgyL3hlWk5SVjhVNVFoM0FYMG5YZzUwUzluMG0rdWdvYU82ck80QTM2bzhEaE1PZCtXNGxaR0tKS1BpajVXck1CWjB6ZHRDSndIRnd0YjMiLCJtYWMiOiJlNWQ4NmQyZDkyZGY4OTE1NWIyNTQzZjk4ZWNkZGVkMjdlYjlmYmFlMGM4ODgyZjNkNmVlZjIwYmUzYWE5YjY2IiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 04:23:07 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjJhS3dkQjdVVEh4WlZHUGdCNzhrZnc9PSIsInZhbHVlIjoiQXgrSjBKVk83Zy82eTVzekFrU3ZkU0R0UmF3ZDBjNlFuMHR6QVlzVFJVa0Z2dnhDOHgyL3hlWk5SVjhVNVFoM0FYMG5YZ" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImY2d1VvVmt0aDkvVndZeGM4aHhRQVE9PSIsInZhbHVlIjoiMXUxWndYZWQ5NHJrMmZSV2ZJYXNIK2ZBNGx2QnFZYkhVVTA2VExRSWYrSWxJQ3FmVnBPUkZEUFpZRXUyWk8yTHZteldjUGg1SDBmL2JZTHFNTy82cHFiNmhKRUR4SWt0YzNybnBvVDhQWnprZS8yYWtaTyt5d24yc3VNcmhBbysiLCJtYWMiOiI3ZDRhMzNjYTk1NzFhZDMyMGY1MjM5Y2VlYTk2MzNiNDc2OTUxMDZlNzhmYjEwZTU0YmRhYWU1MzFlM2NhNjljIiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 04:23:07 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6ImY2d1VvVmt0aDkvVndZeGM4aHhRQVE9PSIsInZhbHVlIjoiMXUxWndYZWQ5NHJrMmZSV2ZJYXNIK2ZBNGx2QnFZYkhVVTA2VExRSWYrSWxJQ3FmVnBPUkZ" 2 => "RSVP_status=eyJpdiI6InBmUW5LYkp0Um5WRUFqaWFTcXBBSlE9PSIsInZhbHVlIjoic0sybXJnVmlTUzFsRUVsR0lQVnBRZ2tLa3FOU081bGVKMlJ4dmg3dS9mUkJvcktVV2dVcXV4RktqQmFqazJDTCIsIm1hYyI6Ijc5NjNhMWU3NzFhMmYzZDhiZDA3ZGZiOWM5Y2EyMjA4ZWM2MTEwMDFlYTJmZDUwMWYzOWJiNWIxY2QyMWIwMDYiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04-May-2020 04:23:07 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6InBmUW5LYkp0Um5WRUFqaWFTcXBBSlE9PSIsInZhbHVlIjoic0sybXJnVmlTUzFsRUVsR0lQVnBRZ2tLa3FOU081bGVKMlJ4dmg3dS9mUkJvcktVV2dVcXV4RktqQmFqazJDTCIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "e63D4fideWyfMVbgXpaLNmiptqPRgimFONMdKBWf" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/austin-murphy" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-02 23:23:07GET/player/austin-murphy116361011