RB

Ryan Beals

Ryan Beals

All Time Points : 320
|
Wins : 0

Tournaments Played : 15

Ryan Beals

Tournament History

Ryan Beals Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version424msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[02:57:13] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (49.51ms)time
  • Application (375ms)time
  • 1 x Application (88.32%)
    375ms
    1 x Booting (11.67%)
    49.51ms
    17 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.fpn_store_footerfpn_store_footer.php#?php
    • 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
    41 statements were executed (6 duplicates)Show only duplicates287ms
    • 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.08msselect * from `users` where `alias` = 'ryan-beals' limit 1
      Bindings
      • 0: ryan-beals
      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#154fpnstaging880μsselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 9005 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 9005
      • 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#166fpnstaging840μsselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 9005 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 9005
      • 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#178fpnstaging770μsselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 9005 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 9005
      • 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#190fpnstaging780μsselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 9005 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: 9005
      • 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.34msselect `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` = 9005) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 9005
      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.37msselect 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` = 9005) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 9005
      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.07msselect 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` = 9005) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 9005
      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.14msselect 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` = 9005) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 9005
      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.54msselect 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` = 9005) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 9005
      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#163fpnstaging32.95msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('9005',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#174fpnstaging51.16msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('9005',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#176fpnstaging46.3msselect * from `articles` where find_in_set(9005, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 9005
      • 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#214fpnstaging430μ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.34msselect `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` = 9005 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: 9005
      • 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.38msselect `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` = 'ryan-beals' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: ryan-beals
      • 2: 502
      • 3: 957
      • 4: 1212
      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#1848fpnstaging1.11msselect `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` = 23 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'ryan-beals' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: ryan-beals
      • 3: 502
      • 4: 957
      • 5: 1212
      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#1857fpnstaging510μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 264 limit 1
      Bindings
      • 0: 264
      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#1862fpnstaging540μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-28 02:57:13' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-28 02:57:13
      • 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#1874fpnstaging760μsselect `id` from `fpn_tournaments` where `event_id` = 264 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 264
      • 1: 2024-01-01 00:00:00
      • 2: 2024-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#1915fpnstaging19.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` = 264 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (30786, 30787, 30788, 30789, 30790, 30791, 30792, 30793, 30794, 30795, 30796, 30797, 30798, 30804, 30805, 30806, 30807, 30808, 30809, 30810, 30811, 30812, 30813, 30814, 30815, 30816, 30821, 30822, 30823, 30824, 30825, 30826, 30827, 30828, 30829, 30830, 30831, 30832, 30833) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 264
      • 1: 1
      • 2: 30786
      • 3: 30787
      • 4: 30788
      • 5: 30789
      • 6: 30790
      • 7: 30791
      • 8: 30792
      • 9: 30793
      • 10: 30794
      • 11: 30795
      • 12: 30796
      • 13: 30797
      • 14: 30798
      • 15: 30804
      • 16: 30805
      • 17: 30806
      • 18: 30807
      • 19: 30808
      • 20: 30809
      • 21: 30810
      • 22: 30811
      • 23: 30812
      • 24: 30813
      • 25: 30814
      • 26: 30815
      • 27: 30816
      • 28: 30821
      • 29: 30822
      • 30: 30823
      • 31: 30824
      • 32: 30825
      • 33: 30826
      • 34: 30827
      • 35: 30828
      • 36: 30829
      • 37: 30830
      • 38: 30831
      • 39: 30832
      • 40: 30833
      • 41: 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.01msselect `id` from `fpn_tournaments` where `event_id` = 264 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 264
      • 1: 2023-10-01 00:00:00
      • 2: 2023-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#1915fpnstaging11.4msselect `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` = 264 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20585, 20586, 20587, 20588, 20589, 20590, 20591, 20592, 20593, 20611, 20612, 20613, 20614, 20615, 20616, 20617, 20618, 20619, 20638, 20639, 20640, 20641, 20642, 20643, 20644, 20645, 20646, 30782, 30783, 30784, 30785, 30799, 30800, 30801, 30802, 30803, 30817, 30818, 30819, 30820) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 264
      • 1: 1
      • 2: 20585
      • 3: 20586
      • 4: 20587
      • 5: 20588
      • 6: 20589
      • 7: 20590
      • 8: 20591
      • 9: 20592
      • 10: 20593
      • 11: 20611
      • 12: 20612
      • 13: 20613
      • 14: 20614
      • 15: 20615
      • 16: 20616
      • 17: 20617
      • 18: 20618
      • 19: 20619
      • 20: 20638
      • 21: 20639
      • 22: 20640
      • 23: 20641
      • 24: 20642
      • 25: 20643
      • 26: 20644
      • 27: 20645
      • 28: 20646
      • 29: 30782
      • 30: 30783
      • 31: 30784
      • 32: 30785
      • 33: 30799
      • 34: 30800
      • 35: 30801
      • 36: 30802
      • 37: 30803
      • 38: 30817
      • 39: 30818
      • 40: 30819
      • 41: 30820
      • 42: 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#1857fpnstaging610μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 398 limit 1
      Bindings
      • 0: 398
      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#1862fpnstaging580μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-28 02:57:13' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-28 02:57:13
      • 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.14msselect `id` from `fpn_tournaments` where `event_id` = 398 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 398
      • 1: 2024-01-01 00:00:00
      • 2: 2024-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#1915fpnstaging30.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` = 398 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (28663, 28664, 28665, 28666, 28667, 28668, 28669, 28670, 28671, 28672, 28673, 28674, 28675, 28686, 28687, 28688, 28689, 28690, 28691, 28692, 28693, 28694, 28695, 28696, 28697, 28698, 28709, 28710, 28711, 28712, 28713, 28714, 28715, 28716, 28717, 28718, 28719, 28720, 28721, 28732, 28733, 28734, 28735, 28736, 28737, 28738, 28739, 28740, 28741, 28742, 28743, 28744, 28756, 28757, 28758, 28759, 28760, 28761, 28762, 28763, 28764, 28765, 28766, 28767, 28768, 28780, 28781, 28782, 28783, 28784, 28785, 28786, 28787, 28788, 28789, 28790, 28791, 28792, 28804, 28805, 28806, 28807, 28808, 28809, 28810, 28811, 28812, 28813, 28814, 28815, 28816) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 398
      • 1: 1
      • 2: 28663
      • 3: 28664
      • 4: 28665
      • 5: 28666
      • 6: 28667
      • 7: 28668
      • 8: 28669
      • 9: 28670
      • 10: 28671
      • 11: 28672
      • 12: 28673
      • 13: 28674
      • 14: 28675
      • 15: 28686
      • 16: 28687
      • 17: 28688
      • 18: 28689
      • 19: 28690
      • 20: 28691
      • 21: 28692
      • 22: 28693
      • 23: 28694
      • 24: 28695
      • 25: 28696
      • 26: 28697
      • 27: 28698
      • 28: 28709
      • 29: 28710
      • 30: 28711
      • 31: 28712
      • 32: 28713
      • 33: 28714
      • 34: 28715
      • 35: 28716
      • 36: 28717
      • 37: 28718
      • 38: 28719
      • 39: 28720
      • 40: 28721
      • 41: 28732
      • 42: 28733
      • 43: 28734
      • 44: 28735
      • 45: 28736
      • 46: 28737
      • 47: 28738
      • 48: 28739
      • 49: 28740
      • 50: 28741
      • 51: 28742
      • 52: 28743
      • 53: 28744
      • 54: 28756
      • 55: 28757
      • 56: 28758
      • 57: 28759
      • 58: 28760
      • 59: 28761
      • 60: 28762
      • 61: 28763
      • 62: 28764
      • 63: 28765
      • 64: 28766
      • 65: 28767
      • 66: 28768
      • 67: 28780
      • 68: 28781
      • 69: 28782
      • 70: 28783
      • 71: 28784
      • 72: 28785
      • 73: 28786
      • 74: 28787
      • 75: 28788
      • 76: 28789
      • 77: 28790
      • 78: 28791
      • 79: 28792
      • 80: 28804
      • 81: 28805
      • 82: 28806
      • 83: 28807
      • 84: 28808
      • 85: 28809
      • 86: 28810
      • 87: 28811
      • 88: 28812
      • 89: 28813
      • 90: 28814
      • 91: 28815
      • 92: 28816
      • 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
    • League.php#1874fpnstaging1.14msselect `id` from `fpn_tournaments` where `event_id` = 398 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 398
      • 1: 2023-10-01 00:00:00
      • 2: 2023-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#1915fpnstaging26.53msselect `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` = 398 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25296, 25297, 25298, 25323, 25324, 25325, 25349, 25350, 25351, 25375, 25376, 25377, 25401, 25402, 25427, 25428, 25453, 25454, 28652, 28653, 28654, 28655, 28656, 28657, 28658, 28659, 28660, 28661, 28662, 28676, 28677, 28678, 28679, 28680, 28681, 28682, 28683, 28684, 28685, 28699, 28700, 28701, 28702, 28703, 28704, 28705, 28706, 28707, 28708, 28722, 28723, 28724, 28725, 28726, 28727, 28728, 28729, 28730, 28731, 28745, 28746, 28747, 28748, 28749, 28750, 28751, 28752, 28753, 28754, 28755, 28769, 28770, 28771, 28772, 28773, 28774, 28775, 28776, 28777, 28778, 28779, 28793, 28794, 28795, 28796, 28797, 28798, 28799, 28800, 28801, 28802, 28803) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 398
      • 1: 1
      • 2: 25296
      • 3: 25297
      • 4: 25298
      • 5: 25323
      • 6: 25324
      • 7: 25325
      • 8: 25349
      • 9: 25350
      • 10: 25351
      • 11: 25375
      • 12: 25376
      • 13: 25377
      • 14: 25401
      • 15: 25402
      • 16: 25427
      • 17: 25428
      • 18: 25453
      • 19: 25454
      • 20: 28652
      • 21: 28653
      • 22: 28654
      • 23: 28655
      • 24: 28656
      • 25: 28657
      • 26: 28658
      • 27: 28659
      • 28: 28660
      • 29: 28661
      • 30: 28662
      • 31: 28676
      • 32: 28677
      • 33: 28678
      • 34: 28679
      • 35: 28680
      • 36: 28681
      • 37: 28682
      • 38: 28683
      • 39: 28684
      • 40: 28685
      • 41: 28699
      • 42: 28700
      • 43: 28701
      • 44: 28702
      • 45: 28703
      • 46: 28704
      • 47: 28705
      • 48: 28706
      • 49: 28707
      • 50: 28708
      • 51: 28722
      • 52: 28723
      • 53: 28724
      • 54: 28725
      • 55: 28726
      • 56: 28727
      • 57: 28728
      • 58: 28729
      • 59: 28730
      • 60: 28731
      • 61: 28745
      • 62: 28746
      • 63: 28747
      • 64: 28748
      • 65: 28749
      • 66: 28750
      • 67: 28751
      • 68: 28752
      • 69: 28753
      • 70: 28754
      • 71: 28755
      • 72: 28769
      • 73: 28770
      • 74: 28771
      • 75: 28772
      • 76: 28773
      • 77: 28774
      • 78: 28775
      • 79: 28776
      • 80: 28777
      • 81: 28778
      • 82: 28779
      • 83: 28793
      • 84: 28794
      • 85: 28795
      • 86: 28796
      • 87: 28797
      • 88: 28798
      • 89: 28799
      • 90: 28800
      • 91: 28801
      • 92: 28802
      • 93: 28803
      • 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#1857fpnstaging660μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 400 limit 1
      Bindings
      • 0: 400
      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#1862fpnstaging550μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-28 02:57:13' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-28 02:57:13
      • 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#1874fpnstaging880μsselect `id` from `fpn_tournaments` where `event_id` = 400 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 400
      • 1: 2024-01-01 00:00:00
      • 2: 2024-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#1915fpnstaging13.19msselect `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` = 400 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (31741, 31742, 31743, 31744, 31745, 31746, 31747, 31748, 31749, 31750, 31751, 31752, 31753, 31755, 31756, 31757, 31758, 31759, 31760, 31761, 31762, 31763, 31764, 31765, 31766, 31767, 31770, 31771, 31772, 31773, 31774, 31775, 31776, 31777, 31778, 31779, 31780, 31781, 31782) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 400
      • 1: 1
      • 2: 31741
      • 3: 31742
      • 4: 31743
      • 5: 31744
      • 6: 31745
      • 7: 31746
      • 8: 31747
      • 9: 31748
      • 10: 31749
      • 11: 31750
      • 12: 31751
      • 13: 31752
      • 14: 31753
      • 15: 31755
      • 16: 31756
      • 17: 31757
      • 18: 31758
      • 19: 31759
      • 20: 31760
      • 21: 31761
      • 22: 31762
      • 23: 31763
      • 24: 31764
      • 25: 31765
      • 26: 31766
      • 27: 31767
      • 28: 31770
      • 29: 31771
      • 30: 31772
      • 31: 31773
      • 32: 31774
      • 33: 31775
      • 34: 31776
      • 35: 31777
      • 36: 31778
      • 37: 31779
      • 38: 31780
      • 39: 31781
      • 40: 31782
      • 41: 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#1874fpnstaging880μsselect `id` from `fpn_tournaments` where `event_id` = 400 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 400
      • 1: 2023-10-01 00:00:00
      • 2: 2023-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#1915fpnstaging11.79msselect `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` = 400 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25662, 25663, 25664, 25665, 25666, 25667, 25668, 25669, 25670, 25671, 25672, 25673, 25688, 25689, 25690, 25691, 25692, 25693, 25694, 25695, 25696, 25697, 25698, 25699, 25714, 25715, 25716, 25717, 25718, 25719, 25720, 25721, 25722, 25723, 25724, 31740, 31754, 31768, 31769) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 400
      • 1: 1
      • 2: 25662
      • 3: 25663
      • 4: 25664
      • 5: 25665
      • 6: 25666
      • 7: 25667
      • 8: 25668
      • 9: 25669
      • 10: 25670
      • 11: 25671
      • 12: 25672
      • 13: 25673
      • 14: 25688
      • 15: 25689
      • 16: 25690
      • 17: 25691
      • 18: 25692
      • 19: 25693
      • 20: 25694
      • 21: 25695
      • 22: 25696
      • 23: 25697
      • 24: 25698
      • 25: 25699
      • 26: 25714
      • 27: 25715
      • 28: 25716
      • 29: 25717
      • 30: 25718
      • 31: 25719
      • 32: 25720
      • 33: 25721
      • 34: 25722
      • 35: 25723
      • 36: 25724
      • 37: 31740
      • 38: 31754
      • 39: 31768
      • 40: 31769
      • 41: 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#1857fpnstaging610μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 266 limit 1
      Bindings
      • 0: 266
      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#1862fpnstaging550μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-28 02:57:13' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-28 02:57:13
      • 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#1874fpnstaging630μsselect `id` from `fpn_tournaments` where `event_id` = 266 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 266
      • 1: 2024-01-01 00:00:00
      • 2: 2024-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#1915fpnstaging9.45msselect `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` = 266 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20703, 20704, 20705, 20706, 20707, 20708, 20709, 20710, 20711, 20712, 33996, 33997, 33998) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 266
      • 1: 1
      • 2: 20703
      • 3: 20704
      • 4: 20705
      • 5: 20706
      • 6: 20707
      • 7: 20708
      • 8: 20709
      • 9: 20710
      • 10: 20711
      • 11: 20712
      • 12: 33996
      • 13: 33997
      • 14: 33998
      • 15: 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#1874fpnstaging660μsselect `id` from `fpn_tournaments` where `event_id` = 266 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 266
      • 1: 2023-10-01 00:00:00
      • 2: 2023-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#1915fpnstaging6.92msselect `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` = 266 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20690, 20691, 20692, 20693, 20694, 20695, 20696, 20697, 20698, 20699, 20700, 20701, 20702) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 266
      • 1: 1
      • 2: 20690
      • 3: 20691
      • 4: 20692
      • 5: 20693
      • 6: 20694
      • 7: 20695
      • 8: 20696
      • 9: 20697
      • 10: 20698
      • 11: 20699
      • 12: 20700
      • 13: 20701
      • 14: 20702
      • 15: 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
    8Season.php#?
    App\Models\Promotion
    4Promotion.php#?
    App\Models\User
    1User.php#?
        • missed KITZEd4Yqju05zTwA86uRbOVbDYIOQpxwwrOiboy (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 KITZEd4Yqju05zTwA86uRbOVbDYIOQpxwwrOiboy (0μs)forget
        • 1 x missed KITZEd4Yqju05zTwA86uRbOVbDYIOQpxwwrOiboy (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written KITZEd4Yqju05zTwA86uRbOVbDYIOQpxwwrOiboy (0%)
          0μs
        _token
        HOYdHExGEGB7bNIvgJwurBctF37804lMQrDrF985
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/ryan-beals" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/ryan-beals
        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 => "Wed, 28 May 2025 07:57:13 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNMNFhKMURzWlF5R2Q4SklXb3p2Wmc9PSIsInZhbHVlIjoiWnlhZmswVEF6YmJudEVRMGM5dXExRkMwRW4vNGRGZEFiWmpnNkdOZi8xRFFyM1UzaEd4VEM0eWs3UTRQZjVlSXRlY29TNjBLdk9RZHZxUnptTGo3cmN3TUpLRWU5TkZoSTQrMU9YL2NKRmtqeXk3bmFkQzZ0VzNmVWJZcnpsYnUiLCJtYWMiOiJkYjRlYTViNmIyODk4N2Q1Yzg2ZWQxYjRiOGE2NzliYTk5MDQ0ZjEyNGZkODdjNDI0MjUyODRlOGFjNTQwM2I2IiwidGFnIjoiIn0%3D; expires=Thu, 28 May 2026 07:57:13 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjNMNFhKMURzWlF5R2Q4SklXb3p2Wmc9PSIsInZhbHVlIjoiWnlhZmswVEF6YmJudEVRMGM5dXExRkMwRW4vNGRGZEFiWmpnNkdOZi8xRFFyM1UzaEd4VEM0eWs3UTRQZjVlSXRlY29TN" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IlZYbjNUa3FidXNOZk12d1F6RURLNnc9PSIsInZhbHVlIjoiOFg5aHFvVEVJMUhrUmF5dVRSbzMyT0l6dXB0Y3l6bnQ0a0xvUFhiNTNhdHVQaG1JYXVueUtEdElEQlZwS2VMNzVrL2N3YUVNUVdYQ2hkMVVPNWNjMnI2blJ3bkRnS1ZrcE1EeHBkUkltaXM4elFvSnJ0ZGx1QkFRM2NUVUxBSUYiLCJtYWMiOiI0NmMxY2UzYWQyY2MxN2M3ZWU3OTFkMDZhYjJiMzdhYTU2NTU0YzA1ZDQ0OWVkMjk0OTc3NTdlZGM0ZTc4NWQ3IiwidGFnIjoiIn0%3D; expires=Thu, 28 May 2026 07:57:13 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6IlZYbjNUa3FidXNOZk12d1F6RURLNnc9PSIsInZhbHVlIjoiOFg5aHFvVEVJMUhrUmF5dVRSbzMyT0l6dXB0Y3l6bnQ0a0xvUFhiNTNhdHVQaG1JYXVueUt" 2 => "RSVP_status=eyJpdiI6IkFDM0FiVFhiSjdNVzZrZ0lLQjBhU2c9PSIsInZhbHVlIjoiMzJQTlJaSmE3OUdCZHNEZXR4dXpDbGMxeTVBMWhmN0d5aXNEbTQ5eWQwOThsUDFjaDZLc2tpeW5LTXY2aFdpcSIsIm1hYyI6IjNmNjRkYjQzYzQ3MTVhOWE2ZjIxYmEzZTQ0MzlmMjYxZjE2ODE2ZDYzZmVlNzNjY2ViMmE2ZjIzMmZkODI1OTciLCJ0YWciOiIifQ%3D%3D; expires=Fri, 29 May 2020 07:57:13 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6IkFDM0FiVFhiSjdNVzZrZ0lLQjBhU2c9PSIsInZhbHVlIjoiMzJQTlJaSmE3OUdCZHNEZXR4dXpDbGMxeTVBMWhmN0d5aXNEbTQ5eWQwOThsUDFjaDZLc2tpeW5LTXY2aFdpcSIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNMNFhKMURzWlF5R2Q4SklXb3p2Wmc9PSIsInZhbHVlIjoiWnlhZmswVEF6YmJudEVRMGM5dXExRkMwRW4vNGRGZEFiWmpnNkdOZi8xRFFyM1UzaEd4VEM0eWs3UTRQZjVlSXRlY29TNjBLdk9RZHZxUnptTGo3cmN3TUpLRWU5TkZoSTQrMU9YL2NKRmtqeXk3bmFkQzZ0VzNmVWJZcnpsYnUiLCJtYWMiOiJkYjRlYTViNmIyODk4N2Q1Yzg2ZWQxYjRiOGE2NzliYTk5MDQ0ZjEyNGZkODdjNDI0MjUyODRlOGFjNTQwM2I2IiwidGFnIjoiIn0%3D; expires=Thu, 28-May-2026 07:57:13 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjNMNFhKMURzWlF5R2Q4SklXb3p2Wmc9PSIsInZhbHVlIjoiWnlhZmswVEF6YmJudEVRMGM5dXExRkMwRW4vNGRGZEFiWmpnNkdOZi8xRFFyM1UzaEd4VEM0eWs3UTRQZjVlSXRlY29TN" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IlZYbjNUa3FidXNOZk12d1F6RURLNnc9PSIsInZhbHVlIjoiOFg5aHFvVEVJMUhrUmF5dVRSbzMyT0l6dXB0Y3l6bnQ0a0xvUFhiNTNhdHVQaG1JYXVueUtEdElEQlZwS2VMNzVrL2N3YUVNUVdYQ2hkMVVPNWNjMnI2blJ3bkRnS1ZrcE1EeHBkUkltaXM4elFvSnJ0ZGx1QkFRM2NUVUxBSUYiLCJtYWMiOiI0NmMxY2UzYWQyY2MxN2M3ZWU3OTFkMDZhYjJiMzdhYTU2NTU0YzA1ZDQ0OWVkMjk0OTc3NTdlZGM0ZTc4NWQ3IiwidGFnIjoiIn0%3D; expires=Thu, 28-May-2026 07:57:13 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6IlZYbjNUa3FidXNOZk12d1F6RURLNnc9PSIsInZhbHVlIjoiOFg5aHFvVEVJMUhrUmF5dVRSbzMyT0l6dXB0Y3l6bnQ0a0xvUFhiNTNhdHVQaG1JYXVueUt" 2 => "RSVP_status=eyJpdiI6IkFDM0FiVFhiSjdNVzZrZ0lLQjBhU2c9PSIsInZhbHVlIjoiMzJQTlJaSmE3OUdCZHNEZXR4dXpDbGMxeTVBMWhmN0d5aXNEbTQ5eWQwOThsUDFjaDZLc2tpeW5LTXY2aFdpcSIsIm1hYyI6IjNmNjRkYjQzYzQ3MTVhOWE2ZjIxYmEzZTQ0MzlmMjYxZjE2ODE2ZDYzZmVlNzNjY2ViMmE2ZjIzMmZkODI1OTciLCJ0YWciOiIifQ%3D%3D; expires=Fri, 29-May-2020 07:57:13 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6IkFDM0FiVFhiSjdNVzZrZ0lLQjBhU2c9PSIsInZhbHVlIjoiMzJQTlJaSmE3OUdCZHNEZXR4dXpDbGMxeTVBMWhmN0d5aXNEbTQ5eWQwOThsUDFjaDZLc2tpeW5LTXY2aFdpcSIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "HOYdHExGEGB7bNIvgJwurBctF37804lMQrDrF985" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/ryan-beals" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-28 02:57:13GET/player/ryan-beals117411311