LE

Luke Elgin

Luke Elgin

All Time Points : 1290
|
Wins : 3

Tournaments Played : 44

Luke Elgin

Tournament History

Luke Elgin Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version1.4sRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[17:50:47] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (48.28ms)time
  • Application (1.35s)time
  • 1 x Application (96.54%)
    1.35s
    1 x Booting (3.45%)
    48.28ms
    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
    75 statements were executed (9 duplicates)Show only duplicates1.21s
    • 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#239fpnstaging4.27msselect * from `users` where `alias` = 'luke-elgin' limit 1
      Bindings
      • 0: luke-elgin
      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#154fpnstaging30.09msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 8361 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 8361
      • 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#166fpnstaging1.51msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 8361 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 8361
      • 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.66msselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 8361 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 8361
      • 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.31msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 8361 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: 8361
      • 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.37msselect `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` = 8361) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 8361
      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.63msselect 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` = 8361) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 8361
      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.77msselect 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` = 8361) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 8361
      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.94msselect 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` = 8361) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 8361
      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#199fpnstaging3.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` = 8361) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 8361
      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#163fpnstaging33.96msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('8361',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#174fpnstaging46.36msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('8361',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#176fpnstaging47.75msselect * from `articles` where find_in_set(8361, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 8361
      • 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.69msselect `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` = 8361 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: 8361
      • 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#1828fpnstaging2.26msselect `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` = 'luke-elgin' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: luke-elgin
      • 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#1848fpnstaging1.65msselect `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` = 'luke-elgin' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 24
      • 1: 1
      • 2: luke-elgin
      • 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#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` = 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#1862fpnstaging790μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-04-27 17:50:48
      • 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.18msselect `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#1915fpnstaging103msselect `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.51msselect `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#1915fpnstaging98.88msselect `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
    • League.php#1857fpnstaging780μ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#1862fpnstaging730μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-04-27 17:50:48
      • 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.43msselect `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#1915fpnstaging57.3msselect `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.58msselect `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#1915fpnstaging52.69msselect `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#1857fpnstaging950μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 515 limit 1
      Bindings
      • 0: 515
      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#1862fpnstaging760μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-04-27 17:50:48
      • 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.03msselect `id` from `fpn_tournaments` where `event_id` = 515 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 515
      • 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#1915fpnstaging21.87msselect `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` = 515 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34319, 34320, 34321, 34322, 34323, 34324, 34325, 34326, 34327, 34328, 34329, 34330, 34331, 34332, 34346, 34347, 34348, 34349, 34350, 34351, 34352, 34353, 34354, 34355, 34356, 34357, 34358, 34372, 34373, 34374, 34375, 34376, 34377, 34378, 34379, 34380, 34381, 34382, 34383, 34384) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 515
      • 1: 1
      • 2: 34319
      • 3: 34320
      • 4: 34321
      • 5: 34322
      • 6: 34323
      • 7: 34324
      • 8: 34325
      • 9: 34326
      • 10: 34327
      • 11: 34328
      • 12: 34329
      • 13: 34330
      • 14: 34331
      • 15: 34332
      • 16: 34346
      • 17: 34347
      • 18: 34348
      • 19: 34349
      • 20: 34350
      • 21: 34351
      • 22: 34352
      • 23: 34353
      • 24: 34354
      • 25: 34355
      • 26: 34356
      • 27: 34357
      • 28: 34358
      • 29: 34372
      • 30: 34373
      • 31: 34374
      • 32: 34375
      • 33: 34376
      • 34: 34377
      • 35: 34378
      • 36: 34379
      • 37: 34380
      • 38: 34381
      • 39: 34382
      • 40: 34383
      • 41: 34384
      • 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#1874fpnstaging1.31msselect `id` from `fpn_tournaments` where `event_id` = 515 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 515
      • 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#1915fpnstaging23.88msselect `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` = 515 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34306, 34307, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34318, 34333, 34334, 34335, 34336, 34337, 34338, 34339, 34340, 34341, 34342, 34343, 34344, 34345, 34359, 34360, 34361, 34362, 34363, 34364, 34365, 34366, 34367, 34368, 34369, 34370, 34371) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 515
      • 1: 1
      • 2: 34306
      • 3: 34307
      • 4: 34308
      • 5: 34309
      • 6: 34310
      • 7: 34311
      • 8: 34312
      • 9: 34313
      • 10: 34314
      • 11: 34315
      • 12: 34316
      • 13: 34317
      • 14: 34318
      • 15: 34333
      • 16: 34334
      • 17: 34335
      • 18: 34336
      • 19: 34337
      • 20: 34338
      • 21: 34339
      • 22: 34340
      • 23: 34341
      • 24: 34342
      • 25: 34343
      • 26: 34344
      • 27: 34345
      • 28: 34359
      • 29: 34360
      • 30: 34361
      • 31: 34362
      • 32: 34363
      • 33: 34364
      • 34: 34365
      • 35: 34366
      • 36: 34367
      • 37: 34368
      • 38: 34369
      • 39: 34370
      • 40: 34371
      • 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#1848fpnstaging2msselect `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` = 'luke-elgin' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: luke-elgin
      • 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#1857fpnstaging670μ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#1862fpnstaging710μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-04-27 17:50:48
      • 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.51msselect `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#1915fpnstaging126msselect `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.9msselect `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#1915fpnstaging95.23msselect `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#1857fpnstaging700μ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#1862fpnstaging720μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-04-27 17:50:48
      • 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#1874fpnstaging1msselect `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#1915fpnstaging43.31msselect `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#1874fpnstaging1.38msselect `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#1915fpnstaging40.99msselect `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#1857fpnstaging1.01msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 399 limit 1
      Bindings
      • 0: 399
      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#1862fpnstaging770μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-04-27 17:50:48
      • 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#1874fpnstaging2.3msselect `id` from `fpn_tournaments` where `event_id` = 399 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 399
      • 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#1915fpnstaging52.58msselect `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` = 399 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (28375, 28376, 28398, 28399, 28400, 28422, 28423, 28424, 28446, 28447, 28448, 28470, 28471, 28494, 28495, 28518, 28519, 32508, 32509, 32510, 32511, 32512, 32513, 32514, 32515, 32516, 32517, 32518, 32519, 32520, 32521, 32522, 32523, 32524, 32525, 32526, 32527, 32528, 32529, 32530, 32531, 32532, 32533, 32534, 32535, 32536, 32537, 32538, 32539, 32540, 32541, 32542, 32543, 32544, 32545, 32546, 32547, 32548, 32549, 32550, 32551, 32552, 32553, 32554, 32555, 32556, 32557, 32558, 32559, 32560, 32561, 32562, 32563, 32564, 32565, 32566, 32567, 32568, 32569, 32570, 32571, 32572, 32573, 32574, 32575, 32576, 32577, 32578, 32579, 32580, 32581, 32582) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 399
      • 1: 1
      • 2: 28375
      • 3: 28376
      • 4: 28398
      • 5: 28399
      • 6: 28400
      • 7: 28422
      • 8: 28423
      • 9: 28424
      • 10: 28446
      • 11: 28447
      • 12: 28448
      • 13: 28470
      • 14: 28471
      • 15: 28494
      • 16: 28495
      • 17: 28518
      • 18: 28519
      • 19: 32508
      • 20: 32509
      • 21: 32510
      • 22: 32511
      • 23: 32512
      • 24: 32513
      • 25: 32514
      • 26: 32515
      • 27: 32516
      • 28: 32517
      • 29: 32518
      • 30: 32519
      • 31: 32520
      • 32: 32521
      • 33: 32522
      • 34: 32523
      • 35: 32524
      • 36: 32525
      • 37: 32526
      • 38: 32527
      • 39: 32528
      • 40: 32529
      • 41: 32530
      • 42: 32531
      • 43: 32532
      • 44: 32533
      • 45: 32534
      • 46: 32535
      • 47: 32536
      • 48: 32537
      • 49: 32538
      • 50: 32539
      • 51: 32540
      • 52: 32541
      • 53: 32542
      • 54: 32543
      • 55: 32544
      • 56: 32545
      • 57: 32546
      • 58: 32547
      • 59: 32548
      • 60: 32549
      • 61: 32550
      • 62: 32551
      • 63: 32552
      • 64: 32553
      • 65: 32554
      • 66: 32555
      • 67: 32556
      • 68: 32557
      • 69: 32558
      • 70: 32559
      • 71: 32560
      • 72: 32561
      • 73: 32562
      • 74: 32563
      • 75: 32564
      • 76: 32565
      • 77: 32566
      • 78: 32567
      • 79: 32568
      • 80: 32569
      • 81: 32570
      • 82: 32571
      • 83: 32572
      • 84: 32573
      • 85: 32574
      • 86: 32575
      • 87: 32576
      • 88: 32577
      • 89: 32578
      • 90: 32579
      • 91: 32580
      • 92: 32581
      • 93: 32582
      • 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.86msselect `id` from `fpn_tournaments` where `event_id` = 399 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 399
      • 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#1915fpnstaging53.2msselect `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` = 399 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25479, 25480, 25481, 25506, 25507, 25508, 25532, 25533, 25558, 25559, 25584, 25585, 25610, 25611, 25636, 25637, 28364, 28365, 28366, 28367, 28368, 28369, 28370, 28371, 28372, 28373, 28374, 28388, 28389, 28390, 28391, 28392, 28393, 28394, 28395, 28396, 28397, 28411, 28412, 28413, 28414, 28415, 28416, 28417, 28418, 28419, 28420, 28421, 28435, 28436, 28437, 28438, 28439, 28440, 28441, 28442, 28443, 28444, 28445, 28459, 28460, 28461, 28462, 28463, 28464, 28465, 28466, 28467, 28468, 28469, 28483, 28484, 28485, 28486, 28487, 28488, 28489, 28490, 28491, 28492, 28493, 28507, 28508, 28509, 28510, 28511, 28512, 28513, 28514, 28515, 28516, 28517) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 399
      • 1: 1
      • 2: 25479
      • 3: 25480
      • 4: 25481
      • 5: 25506
      • 6: 25507
      • 7: 25508
      • 8: 25532
      • 9: 25533
      • 10: 25558
      • 11: 25559
      • 12: 25584
      • 13: 25585
      • 14: 25610
      • 15: 25611
      • 16: 25636
      • 17: 25637
      • 18: 28364
      • 19: 28365
      • 20: 28366
      • 21: 28367
      • 22: 28368
      • 23: 28369
      • 24: 28370
      • 25: 28371
      • 26: 28372
      • 27: 28373
      • 28: 28374
      • 29: 28388
      • 30: 28389
      • 31: 28390
      • 32: 28391
      • 33: 28392
      • 34: 28393
      • 35: 28394
      • 36: 28395
      • 37: 28396
      • 38: 28397
      • 39: 28411
      • 40: 28412
      • 41: 28413
      • 42: 28414
      • 43: 28415
      • 44: 28416
      • 45: 28417
      • 46: 28418
      • 47: 28419
      • 48: 28420
      • 49: 28421
      • 50: 28435
      • 51: 28436
      • 52: 28437
      • 53: 28438
      • 54: 28439
      • 55: 28440
      • 56: 28441
      • 57: 28442
      • 58: 28443
      • 59: 28444
      • 60: 28445
      • 61: 28459
      • 62: 28460
      • 63: 28461
      • 64: 28462
      • 65: 28463
      • 66: 28464
      • 67: 28465
      • 68: 28466
      • 69: 28467
      • 70: 28468
      • 71: 28469
      • 72: 28483
      • 73: 28484
      • 74: 28485
      • 75: 28486
      • 76: 28487
      • 77: 28488
      • 78: 28489
      • 79: 28490
      • 80: 28491
      • 81: 28492
      • 82: 28493
      • 83: 28507
      • 84: 28508
      • 85: 28509
      • 86: 28510
      • 87: 28511
      • 88: 28512
      • 89: 28513
      • 90: 28514
      • 91: 28515
      • 92: 28516
      • 93: 28517
      • 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#1857fpnstaging650μ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#1862fpnstaging620μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-04-27 17:50:48' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-04-27 17:50:48
      • 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#1874fpnstaging840μ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#1915fpnstaging39.59msselect `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.07msselect `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#1915fpnstaging20.78msselect `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#1857fpnstaging1.04msselect `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#1862fpnstaging930μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-04-27 17:50:49' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-04-27 17:50:49
      • 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#1874fpnstaging740μ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#1915fpnstaging14.98msselect `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#1874fpnstaging810μ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#1915fpnstaging13.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` = 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
    • League.php#1848fpnstaging2.43msselect `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` = 16 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'luke-elgin' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 16
      • 1: 1
      • 2: luke-elgin
      • 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#1857fpnstaging1.07msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 229 limit 1
      Bindings
      • 0: 229
      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#1862fpnstaging970μsselect * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-04-27 17:50:49' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 10
      • 1: 12
      • 2: 13
      • 3: 2025-04-27 17:50:49
      • 4: 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.38msselect `id` from `fpn_tournaments` where `event_id` = 229 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
      Bindings
      • 0: 229
      • 1: 2023-07-01 00:00:00
      • 2: 2023-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#1915fpnstaging113msselect `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` = 229 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (14658, 14659, 14697, 14698, 14736, 14775, 14814, 14853, 14891, 14892, 15156, 15524, 15719, 15999, 16011, 16023, 16035, 16253, 16254, 16264, 16265, 16275, 16276, 16286, 16297, 16308, 16309, 16320, 16321, 16946, 17014, 17082, 17559, 17560, 17561, 17562, 17563, 17564, 17565, 17566, 17567, 17568, 17569, 17570, 17571, 17572, 17573, 17574, 17575, 17576, 17577, 17578, 17579, 17580, 17581, 17582, 17583, 17584, 17585, 17586, 17587, 17588, 17589, 17590, 17591, 17592, 17593, 17594, 17595, 17596, 17597, 17598, 17599, 17600, 17601, 17602, 17603, 17604, 17605, 17606, 17607, 17608, 17609, 17610, 17611, 17612, 17613, 17614, 17615, 17616, 17617, 17618, 17619, 17620, 17621, 17622, 17623, 17624, 17625, 17626) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 229
      • 1: 1
      • 2: 14658
      • 3: 14659
      • 4: 14697
      • 5: 14698
      • 6: 14736
      • 7: 14775
      • 8: 14814
      • 9: 14853
      • 10: 14891
      • 11: 14892
      • 12: 15156
      • 13: 15524
      • 14: 15719
      • 15: 15999
      • 16: 16011
      • 17: 16023
      • 18: 16035
      • 19: 16253
      • 20: 16254
      • 21: 16264
      • 22: 16265
      • 23: 16275
      • 24: 16276
      • 25: 16286
      • 26: 16297
      • 27: 16308
      • 28: 16309
      • 29: 16320
      • 30: 16321
      • 31: 16946
      • 32: 17014
      • 33: 17082
      • 34: 17559
      • 35: 17560
      • 36: 17561
      • 37: 17562
      • 38: 17563
      • 39: 17564
      • 40: 17565
      • 41: 17566
      • 42: 17567
      • 43: 17568
      • 44: 17569
      • 45: 17570
      • 46: 17571
      • 47: 17572
      • 48: 17573
      • 49: 17574
      • 50: 17575
      • 51: 17576
      • 52: 17577
      • 53: 17578
      • 54: 17579
      • 55: 17580
      • 56: 17581
      • 57: 17582
      • 58: 17583
      • 59: 17584
      • 60: 17585
      • 61: 17586
      • 62: 17587
      • 63: 17588
      • 64: 17589
      • 65: 17590
      • 66: 17591
      • 67: 17592
      • 68: 17593
      • 69: 17594
      • 70: 17595
      • 71: 17596
      • 72: 17597
      • 73: 17598
      • 74: 17599
      • 75: 17600
      • 76: 17601
      • 77: 17602
      • 78: 17603
      • 79: 17604
      • 80: 17605
      • 81: 17606
      • 82: 17607
      • 83: 17608
      • 84: 17609
      • 85: 17610
      • 86: 17611
      • 87: 17612
      • 88: 17613
      • 89: 17614
      • 90: 17615
      • 91: 17616
      • 92: 17617
      • 93: 17618
      • 94: 17619
      • 95: 17620
      • 96: 17621
      • 97: 17622
      • 98: 17623
      • 99: 17624
      • 100: 17625
      • 101: 17626
      • 102: 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.99msselect `id` from `fpn_tournaments` where `event_id` = 229 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
      Bindings
      • 0: 229
      • 1: 2023-04-01 00:00:00
      • 2: 2023-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#1915fpnstaging5.2msselect `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` = 229 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (14645, 14646, 14647, 14648, 14649, 14650, 14651, 14652, 14653, 14654, 14655, 14656, 14657, 14684, 14685, 14686, 14687, 14688, 14689, 14690, 14691, 14692, 14693, 14694, 14695, 14696, 14723, 14724, 14725, 14726, 14727, 14728, 14729, 14730, 14731, 14732, 14733, 14734, 14735, 14762, 14763, 14764, 14765, 14766, 14767, 14768, 14769, 14770, 14771, 14772, 14773, 14774, 14801, 14802, 14803, 14804, 14805, 14806, 14807, 14808, 14809, 14810, 14811, 14812, 14813, 14840, 14841, 14842, 14843, 14844, 14845, 14846, 14847, 14848, 14849, 14850, 14851, 14852, 14878, 14879, 14880, 14881, 14882, 14883, 14884, 14885, 14886, 14887, 14888, 14889, 14890) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 229
      • 1: 1
      • 2: 14645
      • 3: 14646
      • 4: 14647
      • 5: 14648
      • 6: 14649
      • 7: 14650
      • 8: 14651
      • 9: 14652
      • 10: 14653
      • 11: 14654
      • 12: 14655
      • 13: 14656
      • 14: 14657
      • 15: 14684
      • 16: 14685
      • 17: 14686
      • 18: 14687
      • 19: 14688
      • 20: 14689
      • 21: 14690
      • 22: 14691
      • 23: 14692
      • 24: 14693
      • 25: 14694
      • 26: 14695
      • 27: 14696
      • 28: 14723
      • 29: 14724
      • 30: 14725
      • 31: 14726
      • 32: 14727
      • 33: 14728
      • 34: 14729
      • 35: 14730
      • 36: 14731
      • 37: 14732
      • 38: 14733
      • 39: 14734
      • 40: 14735
      • 41: 14762
      • 42: 14763
      • 43: 14764
      • 44: 14765
      • 45: 14766
      • 46: 14767
      • 47: 14768
      • 48: 14769
      • 49: 14770
      • 50: 14771
      • 51: 14772
      • 52: 14773
      • 53: 14774
      • 54: 14801
      • 55: 14802
      • 56: 14803
      • 57: 14804
      • 58: 14805
      • 59: 14806
      • 60: 14807
      • 61: 14808
      • 62: 14809
      • 63: 14810
      • 64: 14811
      • 65: 14812
      • 66: 14813
      • 67: 14840
      • 68: 14841
      • 69: 14842
      • 70: 14843
      • 71: 14844
      • 72: 14845
      • 73: 14846
      • 74: 14847
      • 75: 14848
      • 76: 14849
      • 77: 14850
      • 78: 14851
      • 79: 14852
      • 80: 14878
      • 81: 14879
      • 82: 14880
      • 83: 14881
      • 84: 14882
      • 85: 14883
      • 86: 14884
      • 87: 14885
      • 88: 14886
      • 89: 14887
      • 90: 14888
      • 91: 14889
      • 92: 14890
      • 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.61msselect `id` from `fpn_tournaments` where `event_id` = 229 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
      Bindings
      • 0: 229
      • 1: 2023-01-01 00:00:00
      • 2: 2023-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#1915fpnstaging5.99msselect `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` = 229 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (14632, 14633, 14634, 14635, 14636, 14637, 14638, 14639, 14640, 14641, 14642, 14643, 14644, 14671, 14672, 14673, 14674, 14675, 14676, 14677, 14678, 14679, 14680, 14681, 14682, 14683, 14710, 14711, 14712, 14713, 14714, 14715, 14716, 14717, 14718, 14719, 14720, 14721, 14722, 14749, 14750, 14751, 14752, 14753, 14754, 14755, 14756, 14757, 14758, 14759, 14760, 14761, 14788, 14789, 14790, 14791, 14792, 14793, 14794, 14795, 14796, 14797, 14798, 14799, 14800, 14827, 14828, 14829, 14830, 14831, 14832, 14833, 14834, 14835, 14836, 14837, 14838, 14839, 14866, 14867, 14868, 14869, 14870, 14871, 14872, 14873, 14874, 14875, 14876, 14877) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 229
      • 1: 1
      • 2: 14632
      • 3: 14633
      • 4: 14634
      • 5: 14635
      • 6: 14636
      • 7: 14637
      • 8: 14638
      • 9: 14639
      • 10: 14640
      • 11: 14641
      • 12: 14642
      • 13: 14643
      • 14: 14644
      • 15: 14671
      • 16: 14672
      • 17: 14673
      • 18: 14674
      • 19: 14675
      • 20: 14676
      • 21: 14677
      • 22: 14678
      • 23: 14679
      • 24: 14680
      • 25: 14681
      • 26: 14682
      • 27: 14683
      • 28: 14710
      • 29: 14711
      • 30: 14712
      • 31: 14713
      • 32: 14714
      • 33: 14715
      • 34: 14716
      • 35: 14717
      • 36: 14718
      • 37: 14719
      • 38: 14720
      • 39: 14721
      • 40: 14722
      • 41: 14749
      • 42: 14750
      • 43: 14751
      • 44: 14752
      • 45: 14753
      • 46: 14754
      • 47: 14755
      • 48: 14756
      • 49: 14757
      • 50: 14758
      • 51: 14759
      • 52: 14760
      • 53: 14761
      • 54: 14788
      • 55: 14789
      • 56: 14790
      • 57: 14791
      • 58: 14792
      • 59: 14793
      • 60: 14794
      • 61: 14795
      • 62: 14796
      • 63: 14797
      • 64: 14798
      • 65: 14799
      • 66: 14800
      • 67: 14827
      • 68: 14828
      • 69: 14829
      • 70: 14830
      • 71: 14831
      • 72: 14832
      • 73: 14833
      • 74: 14834
      • 75: 14835
      • 76: 14836
      • 77: 14837
      • 78: 14838
      • 79: 14839
      • 80: 14866
      • 81: 14867
      • 82: 14868
      • 83: 14869
      • 84: 14870
      • 85: 14871
      • 86: 14872
      • 87: 14873
      • 88: 14874
      • 89: 14875
      • 90: 14876
      • 91: 14877
      • 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
    App\Models\Season
    19Season.php#?
    App\Models\Promotion
    9Promotion.php#?
    App\Models\User
    1User.php#?
        • missed ACv4jRaUUcIUSCisbmfS2D3AxiiyYubDyJQQyBFH (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 ACv4jRaUUcIUSCisbmfS2D3AxiiyYubDyJQQyBFH (0μs)forget
        • 1 x missed ACv4jRaUUcIUSCisbmfS2D3AxiiyYubDyJQQyBFH (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written ACv4jRaUUcIUSCisbmfS2D3AxiiyYubDyJQQyBFH (0%)
          0μs
        _token
        Xft6WjnrWF5WmifW2DfdGIdIlR673gUYentP82UV
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/luke-elgin" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/luke-elgin
        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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "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 => "Sun, 27 Apr 2025 22:50:49 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdUWWQ3clg2T0xNZDdhVmR0NC9CVUE9PSIsInZhbHVlIjoiVzl3YTVBY3pQTURTVDFacHQ1N0YzWkQ5cG9saVZWMzhnb3o1YWM1MDdUUWRsZ1ZZenVtL0diSEtqc0hOQWd1NjF5UDZpcmYwZXJFSVlXU2s1QUFjRUtuUE9zVGhra2FWdlNQUWJDSm8vWHBZbFdJcXJSaVFoNXBHR2xUajhLZDAiLCJtYWMiOiJmZjFlMDJlNDk0YjNhNTdlNTI5ZDg5MGU1NzExMjI5ZTk0MDRjOGU5NGQzNWQ1YmUxZDhhYzc4OGIzMjE3YzYyIiwidGFnIjoiIn0%3D; expires=Mon, 27 Apr 2026 22:50:49 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkdUWWQ3clg2T0xNZDdhVmR0NC9CVUE9PSIsInZhbHVlIjoiVzl3YTVBY3pQTURTVDFacHQ1N0YzWkQ5cG9saVZWMzhnb3o1YWM1MDdUUWRsZ1ZZenVtL0diSEtqc0hOQWd1NjF5UDZpc" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Img4VTZKUGFLMjhIbHQzSEo4aFlGUUE9PSIsInZhbHVlIjoiL0IzVWdXYjI2dloya0ZQUURSc2dIZTQyU3JBQ0ltWW96VDh3ZWJYdVBCZGZHcTZjeVhJL2xTY3lPMUNoMGYyL2RSNVVzdThVeTVjMTZDRHdxTnBBRE9DejZNTnlZV25DWTU2aTZtT1lnU3NYYmpWb0dob3d6MlhRSFRxbm9ZOFQiLCJtYWMiOiJiODFjYzcwZTVhMzVlZWZmNWU2MDBkZTdiMjdkM2I5MDk2MTYwNTY4M2RkYzc3ODYwMGQyN2RhZDFmNmY1OTJhIiwidGFnIjoiIn0%3D; expires=Mon, 27 Apr 2026 22:50:49 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6Img4VTZKUGFLMjhIbHQzSEo4aFlGUUE9PSIsInZhbHVlIjoiL0IzVWdXYjI2dloya0ZQUURSc2dIZTQyU3JBQ0ltWW96VDh3ZWJYdVBCZGZHcTZjeVhJL2x" 2 => "RSVP_status=eyJpdiI6Ill6ZGtLbVVWTDNIRU8xU3Y5UHl0VlE9PSIsInZhbHVlIjoia1FGbjhIMGM2dWloZUxZV2RzS2VhZ0Z5bjJKV1Q3Y2VWVWdYNU5aQUFjWlVUZE5oSlZEcHRMVzVDNkxwVXh0SCIsIm1hYyI6ImIyYjM3ZDMzZGNiMTY2ZjFjODg1YzljZDZhNWVjN2NjMjRiOGY2YzFhZTE3MzdkNmYwYTk2NjNjNjQxNzhkZjMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 28 Apr 2020 22:50:47 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6Ill6ZGtLbVVWTDNIRU8xU3Y5UHl0VlE9PSIsInZhbHVlIjoia1FGbjhIMGM2dWloZUxZV2RzS2VhZ0Z5bjJKV1Q3Y2VWVWdYNU5aQUFjWlVUZE5oSlZEcHRMVzVDNkxwVXh0SCIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdUWWQ3clg2T0xNZDdhVmR0NC9CVUE9PSIsInZhbHVlIjoiVzl3YTVBY3pQTURTVDFacHQ1N0YzWkQ5cG9saVZWMzhnb3o1YWM1MDdUUWRsZ1ZZenVtL0diSEtqc0hOQWd1NjF5UDZpcmYwZXJFSVlXU2s1QUFjRUtuUE9zVGhra2FWdlNQUWJDSm8vWHBZbFdJcXJSaVFoNXBHR2xUajhLZDAiLCJtYWMiOiJmZjFlMDJlNDk0YjNhNTdlNTI5ZDg5MGU1NzExMjI5ZTk0MDRjOGU5NGQzNWQ1YmUxZDhhYzc4OGIzMjE3YzYyIiwidGFnIjoiIn0%3D; expires=Mon, 27-Apr-2026 22:50:49 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkdUWWQ3clg2T0xNZDdhVmR0NC9CVUE9PSIsInZhbHVlIjoiVzl3YTVBY3pQTURTVDFacHQ1N0YzWkQ5cG9saVZWMzhnb3o1YWM1MDdUUWRsZ1ZZenVtL0diSEtqc0hOQWd1NjF5UDZpc" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Img4VTZKUGFLMjhIbHQzSEo4aFlGUUE9PSIsInZhbHVlIjoiL0IzVWdXYjI2dloya0ZQUURSc2dIZTQyU3JBQ0ltWW96VDh3ZWJYdVBCZGZHcTZjeVhJL2xTY3lPMUNoMGYyL2RSNVVzdThVeTVjMTZDRHdxTnBBRE9DejZNTnlZV25DWTU2aTZtT1lnU3NYYmpWb0dob3d6MlhRSFRxbm9ZOFQiLCJtYWMiOiJiODFjYzcwZTVhMzVlZWZmNWU2MDBkZTdiMjdkM2I5MDk2MTYwNTY4M2RkYzc3ODYwMGQyN2RhZDFmNmY1OTJhIiwidGFnIjoiIn0%3D; expires=Mon, 27-Apr-2026 22:50:49 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6Img4VTZKUGFLMjhIbHQzSEo4aFlGUUE9PSIsInZhbHVlIjoiL0IzVWdXYjI2dloya0ZQUURSc2dIZTQyU3JBQ0ltWW96VDh3ZWJYdVBCZGZHcTZjeVhJL2x" 2 => "RSVP_status=eyJpdiI6Ill6ZGtLbVVWTDNIRU8xU3Y5UHl0VlE9PSIsInZhbHVlIjoia1FGbjhIMGM2dWloZUxZV2RzS2VhZ0Z5bjJKV1Q3Y2VWVWdYNU5aQUFjWlVUZE5oSlZEcHRMVzVDNkxwVXh0SCIsIm1hYyI6ImIyYjM3ZDMzZGNiMTY2ZjFjODg1YzljZDZhNWVjN2NjMjRiOGY2YzFhZTE3MzdkNmYwYTk2NjNjNjQxNzhkZjMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 28-Apr-2020 22:50:47 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6Ill6ZGtLbVVWTDNIRU8xU3Y5UHl0VlE9PSIsInZhbHVlIjoia1FGbjhIMGM2dWloZUxZV2RzS2VhZ0Z5bjJKV1Q3Y2VWVWdYNU5aQUFjWlVUZE5oSlZEcHRMVzVDNkxwVXh0SCIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "Xft6WjnrWF5WmifW2DfdGIdIlR673gUYentP82UV" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/luke-elgin" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-27 17:50:49GET/player/luke-elgin116752911