DC

Dave Cody

Dave Cody

All Time Points : 3929
|
Wins : 1

Tournaments Played : 92

Dave Cody

Tournament History

Dave Cody Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version472msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[20:17:27] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (46.19ms)time
  • Application (426ms)time
  • 1 x Application (90.21%)
    426ms
    1 x Booting (9.79%)
    46.19ms
    17 templates were rendered
    • site.leaderboard.showshow.blade.php#?blade
    • site.leaderboard.card.player_infoplayer_info.blade.php#?blade
    • site.leaderboard.card.player_tournament_statplayer_tournament_stat.blade.php#?blade
    • site.leaderboard.card.player_related_newsplayer_related_news.blade.php#?blade
    • site.leaderboard.card.player_related_videosplayer_related_videos.blade.php#?blade
    • site.layouts.appapp.blade.php#?blade
    • site.includes.headerheader.blade.php#?blade
    • flash::messagemessage.blade.php#?blade
    • site.includes.code_of_conductcode_of_conduct.blade.php#?blade
    • site.includes.footerfooter.blade.php#?blade
    • site.includes.footer_modules.dpt_infodpt_info.blade.php#?blade
    • site.includes.footer_modules.social_mediasocial_media.blade.php#?blade
    • site.includes.footer_modules.about_dptabout_dpt.blade.php#?blade
    • site.includes.footer_modules.quick_linkquick_link.blade.php#?blade
    • site.includes.footer_modules.fpn_contactfpn_contact.blade.php#?blade
    • site.includes.footer_modules.fpn_store_footerfpn_store_footer.php#?php
    • site.includes.footer_modules.copyrightcopyright.blade.php#?blade
    uri
    GET player/{id}
    middleware
    web, PersonalInfoMiddleware
    controller
    App\Http\Controllers\Site\LeaderBoardController@show
    as
    site.leaderboard.show
    namespace
    prefix
    where
    file
    app/Http/Controllers/Site/LeaderBoardController.php:237-338
    64 statements were executed (8 duplicates)Show only duplicates305ms
    • PersonalInfoMiddleware.php#16fpnstagingConnection Established
      Backtrace
      • middleware::PersonalInfoMiddleware:16
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/CheckUserStatus.php:26
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/UpdateLastActivity.php:26
    • LeaderBoardController.php#239fpnstaging2.43msselect * from `users` where `alias` = 'dave-cody' limit 1
      Bindings
      • 0: dave-cody
      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#154fpnstaging2.58msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 2200 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 2200
      • 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.74msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 2200 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 2200
      • 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.72msselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 2200 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 2200
      • 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.6msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 2200 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: 2200
      • 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.47msselect `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` = 2200) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 2200
      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#198fpnstaging2.6msselect 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` = 2200) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 2200
      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#198fpnstaging2.22msselect 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` = 2200) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 2200
      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#199fpnstaging3.48msselect 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` = 2200) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 2200
      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#199fpnstaging8.8msselect 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` = 2200) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 2200
      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#163fpnstaging35.84msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('2200',associated_user_ids)
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Article.php:163
      • app/Http/Controllers/Site/LeaderBoardController.php:264
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Article.php#174fpnstaging51.44msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('2200',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#176fpnstaging52.31msselect * from `articles` where find_in_set(2200, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 2200
      • 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#214fpnstaging520μ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.83msselect `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` = 2200 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: 2200
      • 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.75msselect `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` = 'dave-cody' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: dave-cody
      • 2: 502
      • 3: 957
      • 4: 1212
      Backtrace
      • app/Models/League.php:1828
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1848fpnstaging2.41msselect `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` = 'dave-cody' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 24
      • 1: 1
      • 2: dave-cody
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging600μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 670 limit 1
      Bindings
      • 0: 670
      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#1862fpnstaging660μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-05-24 20:17:28
      • 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#1874fpnstaging770μsselect `id` from `fpn_tournaments` where `event_id` = 670 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 670
      • 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#1915fpnstaging5.17msselect `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` = 670 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (39764, 39765, 39766, 39767, 39768, 39769, 39770, 39771, 39772, 39773, 39774, 57136, 57137) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 670
      • 1: 1
      • 2: 39764
      • 3: 39765
      • 4: 39766
      • 5: 39767
      • 6: 39768
      • 7: 39769
      • 8: 39770
      • 9: 39771
      • 10: 39772
      • 11: 39773
      • 12: 39774
      • 13: 57136
      • 14: 57137
      • 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#1874fpnstaging900μsselect `id` from `fpn_tournaments` where `event_id` = 670 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 670
      • 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#1915fpnstaging6.15msselect `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` = 670 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (39751, 39752, 39753, 39754, 39755, 39756, 39757, 39758, 39759, 39760, 39761, 39762, 39763) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 670
      • 1: 1
      • 2: 39751
      • 3: 39752
      • 4: 39753
      • 5: 39754
      • 6: 39755
      • 7: 39756
      • 8: 39757
      • 9: 39758
      • 10: 39759
      • 11: 39760
      • 12: 39761
      • 13: 39762
      • 14: 39763
      • 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#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` = 669 limit 1
      Bindings
      • 0: 669
      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#1862fpnstaging590μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-05-24 20:17:28
      • 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#1874fpnstaging780μsselect `id` from `fpn_tournaments` where `event_id` = 669 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 669
      • 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#1915fpnstaging6.91msselect `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` = 669 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (39737, 39738, 39739, 39740, 39741, 39742, 39743, 39744, 39745, 39746, 39747, 57138, 57139, 57140) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 669
      • 1: 1
      • 2: 39737
      • 3: 39738
      • 4: 39739
      • 5: 39740
      • 6: 39741
      • 7: 39742
      • 8: 39743
      • 9: 39744
      • 10: 39745
      • 11: 39746
      • 12: 39747
      • 13: 57138
      • 14: 57139
      • 15: 57140
      • 16: 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#1874fpnstaging930μsselect `id` from `fpn_tournaments` where `event_id` = 669 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 669
      • 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#1915fpnstaging4.97msselect `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` = 669 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (39724, 39725, 39726, 39727, 39728, 39729, 39730, 39731, 39732, 39733, 39734, 39735, 39736) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 669
      • 1: 1
      • 2: 39724
      • 3: 39725
      • 4: 39726
      • 5: 39727
      • 6: 39728
      • 7: 39729
      • 8: 39730
      • 9: 39731
      • 10: 39732
      • 11: 39733
      • 12: 39734
      • 13: 39735
      • 14: 39736
      • 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.33msselect `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` = 'dave-cody' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: dave-cody
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging520μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 433 limit 1
      Bindings
      • 0: 433
      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#1862fpnstaging640μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-24 20:17:28
      • 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#1874fpnstaging590μsselect `id` from `fpn_tournaments` where `event_id` = 433 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 433
      • 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#1915fpnstaging7.8msselect `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` = 433 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (31019, 31020, 31021, 31022, 31023, 31024, 31025, 31026, 31027, 31028, 31029, 31030, 31031) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 433
      • 1: 1
      • 2: 31019
      • 3: 31020
      • 4: 31021
      • 5: 31022
      • 6: 31023
      • 7: 31024
      • 8: 31025
      • 9: 31026
      • 10: 31027
      • 11: 31028
      • 12: 31029
      • 13: 31030
      • 14: 31031
      • 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` = 433 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 433
      • 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#1915fpnstaging7.36msselect `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` = 433 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (27318, 27650, 27651, 27652, 27653, 27654, 27655, 27656, 27657, 31016, 31017, 31018, 31032) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 433
      • 1: 1
      • 2: 27318
      • 3: 27650
      • 4: 27651
      • 5: 27652
      • 6: 27653
      • 7: 27654
      • 8: 27655
      • 9: 27656
      • 10: 27657
      • 11: 31016
      • 12: 31017
      • 13: 31018
      • 14: 31032
      • 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#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` = 434 limit 1
      Bindings
      • 0: 434
      Backtrace
      • app/Models/League.php:1857
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1862fpnstaging560μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-24 20:17:28
      • 3: 1
      Backtrace
      • app/Models/League.php:1862
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging630μsselect `id` from `fpn_tournaments` where `event_id` = 434 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 434
      • 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#1915fpnstaging7.26msselect `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` = 434 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (30953, 30954, 30955, 30956, 30957, 30958, 30959, 30960, 30961, 30962, 30963, 30964, 30965) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 434
      • 1: 1
      • 2: 30953
      • 3: 30954
      • 4: 30955
      • 5: 30956
      • 6: 30957
      • 7: 30958
      • 8: 30959
      • 9: 30960
      • 10: 30961
      • 11: 30962
      • 12: 30963
      • 13: 30964
      • 14: 30965
      • 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#1874fpnstaging1.42msselect `id` from `fpn_tournaments` where `event_id` = 434 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 434
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging6.65msselect `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` = 434 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (27305, 27625, 27626, 27627, 27628, 27629, 27630, 27631, 27632, 30949, 30950, 30951, 30952) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 434
      • 1: 1
      • 2: 27305
      • 3: 27625
      • 4: 27626
      • 5: 27627
      • 6: 27628
      • 7: 27629
      • 8: 27630
      • 9: 27631
      • 10: 27632
      • 11: 30949
      • 12: 30950
      • 13: 30951
      • 14: 30952
      • 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.51msselect `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` = 'dave-cody' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 16
      • 1: 1
      • 2: dave-cody
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging850μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 41 limit 1
      Bindings
      • 0: 41
      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#1862fpnstaging820μsselect * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 10
      • 1: 12
      • 2: 13
      • 3: 2025-05-24 20:17:28
      • 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#1874fpnstaging3.19msselect `id` from `fpn_tournaments` where `event_id` = 41 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
      Bindings
      • 0: 41
      • 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#1915fpnstaging12.06msselect `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` = 41 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (13998, 13999, 14000, 14001, 19038, 19039, 19040, 19041, 19042, 19043, 19044, 19045, 19046) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 41
      • 1: 1
      • 2: 13998
      • 3: 13999
      • 4: 14000
      • 5: 14001
      • 6: 19038
      • 7: 19039
      • 8: 19040
      • 9: 19041
      • 10: 19042
      • 11: 19043
      • 12: 19044
      • 13: 19045
      • 14: 19046
      • 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#1874fpnstaging820μsselect `id` from `fpn_tournaments` where `event_id` = 41 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
      Bindings
      • 0: 41
      • 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#1915fpnstaging7.14msselect `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` = 41 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 41
      • 1: 1
      • 2: 904
      • 3: 905
      • 4: 906
      • 5: 907
      • 6: 908
      • 7: 909
      • 8: 910
      • 9: 911
      • 10: 912
      • 11: 913
      • 12: 914
      • 13: 915
      • 14: 916
      • 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#1874fpnstaging950μsselect `id` from `fpn_tournaments` where `event_id` = 41 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
      Bindings
      • 0: 41
      • 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#1915fpnstaging8msselect `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` = 41 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (893, 895, 896, 897, 898, 899, 900, 901, 902, 903, 4613, 4614, 4921) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 41
      • 1: 1
      • 2: 893
      • 3: 895
      • 4: 896
      • 5: 897
      • 6: 898
      • 7: 899
      • 8: 900
      • 9: 901
      • 10: 902
      • 11: 903
      • 12: 4613
      • 13: 4614
      • 14: 4921
      • 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#1857fpnstaging560μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 40 limit 1
      Bindings
      • 0: 40
      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#1862fpnstaging600μsselect * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 10
      • 1: 12
      • 2: 13
      • 3: 2025-05-24 20:17:28
      • 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#1874fpnstaging670μsselect `id` from `fpn_tournaments` where `event_id` = 40 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
      Bindings
      • 0: 40
      • 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#1915fpnstaging6.09msselect `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` = 40 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (14011, 14012, 14013, 14014, 14015, 19047, 19048, 19049, 19050, 19051, 19052, 19053, 19054, 19055) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 40
      • 1: 1
      • 2: 14011
      • 3: 14012
      • 4: 14013
      • 5: 14014
      • 6: 14015
      • 7: 19047
      • 8: 19048
      • 9: 19049
      • 10: 19050
      • 11: 19051
      • 12: 19052
      • 13: 19053
      • 14: 19054
      • 15: 19055
      • 16: 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#1874fpnstaging680μsselect `id` from `fpn_tournaments` where `event_id` = 40 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
      Bindings
      • 0: 40
      • 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#1915fpnstaging4.57msselect `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` = 40 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 40
      • 1: 1
      • 2: 878
      • 3: 879
      • 4: 880
      • 5: 881
      • 6: 882
      • 7: 883
      • 8: 884
      • 9: 885
      • 10: 886
      • 11: 887
      • 12: 888
      • 13: 889
      • 14: 890
      • 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#1874fpnstaging680μsselect `id` from `fpn_tournaments` where `event_id` = 40 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
      Bindings
      • 0: 40
      • 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.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` = 40 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 40
      • 1: 1
      • 2: 865
      • 3: 866
      • 4: 867
      • 5: 868
      • 6: 869
      • 7: 870
      • 8: 871
      • 9: 872
      • 10: 873
      • 11: 874
      • 12: 875
      • 13: 876
      • 14: 877
      • 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.06msselect `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` = 15 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'dave-cody' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 15
      • 1: 1
      • 2: dave-cody
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging560μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 5 limit 1
      Bindings
      • 0: 5
      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#1862fpnstaging490μsselect * from `fpn_season` where `id` in ('7') and `end_date` < '2025-05-24 20:17:28' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 7
      • 1: 2025-05-24 20:17:28
      • 2: 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.86msselect `id` from `fpn_tournaments` where `event_id` = 5 and date(`start_date`) >= '2022-10-01 00:00:00' and date(`end_date`) <= '2022-12-31 00:00:00'
      Bindings
      • 0: 5
      • 1: 2022-10-01 00:00:00
      • 2: 2022-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#1915fpnstaging910μsselect `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` = 5 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (120) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 5
      • 1: 1
      • 2: 120
      • 3: 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
    15Season.php#?
    App\Models\Promotion
    7Promotion.php#?
    App\Models\User
    1User.php#?
        • missed gzu97rBLtHZyDqOfhQSE2I5ePAll548FYseQmXnQ (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 gzu97rBLtHZyDqOfhQSE2I5ePAll548FYseQmXnQ (0μs)forget
        • 1 x missed gzu97rBLtHZyDqOfhQSE2I5ePAll548FYseQmXnQ (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written gzu97rBLtHZyDqOfhQSE2I5ePAll548FYseQmXnQ (0%)
          0μs
        _token
        eG3BPwgMPUmLznB3rImNwxJMXP0K6xTytVVHKL9I
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/dave-cody" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/dave-cody
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 25 May 2025 01:17:28 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkpQV1Zwd2hTS0dnTVFUb3gwS2o1VHc9PSIsInZhbHVlIjoiNVZveG9DallaLzRPK2ZueFJMYktzYmVPNHBERmppSUZlRXBwOGF6d1Y4dU1oM0kzaDY0MzJxRnJTNFcxbyt1SHBNTDQ4TkVySkI2bkdkMHhRaEpLZ2FPVHA0OGUvbGFDcjI0UGhQeUVFZ1NFdkVvRGFJdHdzcXRJU0tHZ3Vzc0ciLCJtYWMiOiJkYzNiMmEyM2EzOWYzNGJlYjU5ZTcwNmMyMDRmNjhhZjM3YWI5YWFiYzI3NTEzMGQ1ZGM4N2MzZDY1OGZhNDJlIiwidGFnIjoiIn0%3D; expires=Mon, 25 May 2026 01:17:28 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkpQV1Zwd2hTS0dnTVFUb3gwS2o1VHc9PSIsInZhbHVlIjoiNVZveG9DallaLzRPK2ZueFJMYktzYmVPNHBERmppSUZlRXBwOGF6d1Y4dU1oM0kzaDY0MzJxRnJTNFcxbyt1SHBNTDQ4T" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IkV1bFMrL1BmSlp1dnYvNVdUbldPRnc9PSIsInZhbHVlIjoiVEs4RkhjOGNtb3lTUlhhUkVlSjVwK091Q2NHWU5NZUo3RmZGa0ltclZkZUFqVDVrTWRweHM1N21VSlRoanVyNjR1cWk2N2NuVndRUFlCaWpkejhzRHczc2hSYTVNeTZEc20yUHo0eGpQTUl1WUcyMzl4aHFnSDQ3TnB5dy9iV1IiLCJtYWMiOiJhMGE4M2JmNWViMGQ4MTY0ZDEyNjFkYjExNDVkZjEwMzRiMmVjYjY1ZWJhOTllNTgxYThhNTA4N2Q2NTNmZTE3IiwidGFnIjoiIn0%3D; expires=Mon, 25 May 2026 01:17:28 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6IkV1bFMrL1BmSlp1dnYvNVdUbldPRnc9PSIsInZhbHVlIjoiVEs4RkhjOGNtb3lTUlhhUkVlSjVwK091Q2NHWU5NZUo3RmZGa0ltclZkZUFqVDVrTWRweHM" 2 => "RSVP_status=eyJpdiI6Ind3NngrbzRheHpjRTJieVRrL2hVSVE9PSIsInZhbHVlIjoiV2Vhanp0KytxOFZoTTl6Szk2amQzelpHRGcvNjcyWVBXaEJXVUhjMHU0NkN2R1AxaFl0SnBNMElDN2JrQ1VsQSIsIm1hYyI6IjQ5ZTkxYmFkMmI1YWQ3ODM1ZDdmOGY3Mzc0NjUxZTQwM2UzZTI4YmE0OTBiNDhkNDFmNWU4Mjg5ZDUyODI2MTciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 26 May 2020 01:17:27 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6Ind3NngrbzRheHpjRTJieVRrL2hVSVE9PSIsInZhbHVlIjoiV2Vhanp0KytxOFZoTTl6Szk2amQzelpHRGcvNjcyWVBXaEJXVUhjMHU0NkN2R1AxaFl0SnBNMElDN2JrQ1VsQSIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkpQV1Zwd2hTS0dnTVFUb3gwS2o1VHc9PSIsInZhbHVlIjoiNVZveG9DallaLzRPK2ZueFJMYktzYmVPNHBERmppSUZlRXBwOGF6d1Y4dU1oM0kzaDY0MzJxRnJTNFcxbyt1SHBNTDQ4TkVySkI2bkdkMHhRaEpLZ2FPVHA0OGUvbGFDcjI0UGhQeUVFZ1NFdkVvRGFJdHdzcXRJU0tHZ3Vzc0ciLCJtYWMiOiJkYzNiMmEyM2EzOWYzNGJlYjU5ZTcwNmMyMDRmNjhhZjM3YWI5YWFiYzI3NTEzMGQ1ZGM4N2MzZDY1OGZhNDJlIiwidGFnIjoiIn0%3D; expires=Mon, 25-May-2026 01:17:28 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkpQV1Zwd2hTS0dnTVFUb3gwS2o1VHc9PSIsInZhbHVlIjoiNVZveG9DallaLzRPK2ZueFJMYktzYmVPNHBERmppSUZlRXBwOGF6d1Y4dU1oM0kzaDY0MzJxRnJTNFcxbyt1SHBNTDQ4T" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IkV1bFMrL1BmSlp1dnYvNVdUbldPRnc9PSIsInZhbHVlIjoiVEs4RkhjOGNtb3lTUlhhUkVlSjVwK091Q2NHWU5NZUo3RmZGa0ltclZkZUFqVDVrTWRweHM1N21VSlRoanVyNjR1cWk2N2NuVndRUFlCaWpkejhzRHczc2hSYTVNeTZEc20yUHo0eGpQTUl1WUcyMzl4aHFnSDQ3TnB5dy9iV1IiLCJtYWMiOiJhMGE4M2JmNWViMGQ4MTY0ZDEyNjFkYjExNDVkZjEwMzRiMmVjYjY1ZWJhOTllNTgxYThhNTA4N2Q2NTNmZTE3IiwidGFnIjoiIn0%3D; expires=Mon, 25-May-2026 01:17:28 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6IkV1bFMrL1BmSlp1dnYvNVdUbldPRnc9PSIsInZhbHVlIjoiVEs4RkhjOGNtb3lTUlhhUkVlSjVwK091Q2NHWU5NZUo3RmZGa0ltclZkZUFqVDVrTWRweHM" 2 => "RSVP_status=eyJpdiI6Ind3NngrbzRheHpjRTJieVRrL2hVSVE9PSIsInZhbHVlIjoiV2Vhanp0KytxOFZoTTl6Szk2amQzelpHRGcvNjcyWVBXaEJXVUhjMHU0NkN2R1AxaFl0SnBNMElDN2JrQ1VsQSIsIm1hYyI6IjQ5ZTkxYmFkMmI1YWQ3ODM1ZDdmOGY3Mzc0NjUxZTQwM2UzZTI4YmE0OTBiNDhkNDFmNWU4Mjg5ZDUyODI2MTciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 26-May-2020 01:17:27 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6Ind3NngrbzRheHpjRTJieVRrL2hVSVE9PSIsInZhbHVlIjoiV2Vhanp0KytxOFZoTTl6Szk2amQzelpHRGcvNjcyWVBXaEJXVUhjMHU0NkN2R1AxaFl0SnBNMElDN2JrQ1VsQSIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "eG3BPwgMPUmLznB3rImNwxJMXP0K6xTytVVHKL9I" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/dave-cody" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-24 20:17:28GET/player/dave-cody117642311