TM

Tommy Mills

Tommy Mills

All Time Points : 9445
|
Wins : 24

Tournaments Played : 285

Tommy Mills

Request history8.3.16PHP Version525msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[18:55:59] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[18:55:59] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (45.73ms)time
  • Application (479ms)time
  • 1 x Application (91.28%)
    479ms
    1 x Booting (8.72%)
    45.73ms
    30 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
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
    • components.lazyload-background-imagelazyload-background-image.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
    51 statements were executed (2 duplicates)Show only duplicates354ms
    • 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#239fpnstaging3.16msselect * from `users` where `alias` = 'tommy-mille' limit 1
      Bindings
      • 0: tommy-mille
      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#154fpnstaging4.65msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 10377 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 10377
      • 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#166fpnstaging2.78msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10377 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 10377
      • 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#178fpnstaging4.58msselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10377 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 10377
      • 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#190fpnstaging6.3msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10377 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: 10377
      • 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#192fpnstaging2.06msselect `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` = 10377) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10377
      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#198fpnstaging5.1msselect 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` = 10377) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10377
      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#198fpnstaging5.17msselect 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` = 10377) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10377
      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#199fpnstaging4.72msselect 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` = 10377) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10377
      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#199fpnstaging13.52msselect 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` = 10377) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10377
      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#163fpnstaging30.31msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('10377',associated_user_ids)
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Article.php:163
      • app/Http/Controllers/Site/LeaderBoardController.php:264
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Article.php#174fpnstaging48.65msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('10377',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#176fpnstaging51.64msselect * from `articles` where find_in_set(10377, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 10377
      • 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#214fpnstaging870μ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#304fpnstaging2.43msselect `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` = 10377 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: 10377
      • 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#1828fpnstaging4.59msselect `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` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: tommy-mille
      • 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#1848fpnstaging4.15msselect `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 25 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 25
      • 1: 1
      • 2: tommy-mille
      • 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#1857fpnstaging660μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 867 limit 1
      Bindings
      • 0: 867
      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#1862fpnstaging1.07msselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-12 18:55:59' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-05-12 18:55:59
      • 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.16msselect `id` from `fpn_tournaments` where `event_id` = 867 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 867
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging16.4msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 867 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (60296, 60297, 60313, 60314, 60328, 60329, 60330, 60344, 60345, 60346, 60360, 60361, 60362, 60376, 60377, 60378, 61800, 61801, 61811, 61812, 61821, 61822, 61831, 61832, 61841, 61842, 61851, 61852, 62310, 62311, 62312, 62313, 62314, 62315, 62316, 62317, 62318, 62319, 62320, 62321, 62322, 62323, 62324, 62325, 62326, 62327, 62328, 62329, 62330, 62331, 62332, 62333, 62334, 62335, 62336, 62337, 62338, 62339, 62340, 62341, 62342, 62343, 62344, 62345, 62346, 62347, 62348, 62349, 62350, 62351, 62352, 62353, 62354, 62355, 62356, 62357, 62358) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 867
      • 1: 1
      • 2: 60296
      • 3: 60297
      • 4: 60313
      • 5: 60314
      • 6: 60328
      • 7: 60329
      • 8: 60330
      • 9: 60344
      • 10: 60345
      • 11: 60346
      • 12: 60360
      • 13: 60361
      • 14: 60362
      • 15: 60376
      • 16: 60377
      • 17: 60378
      • 18: 61800
      • 19: 61801
      • 20: 61811
      • 21: 61812
      • 22: 61821
      • 23: 61822
      • 24: 61831
      • 25: 61832
      • 26: 61841
      • 27: 61842
      • 28: 61851
      • 29: 61852
      • 30: 62310
      • 31: 62311
      • 32: 62312
      • 33: 62313
      • 34: 62314
      • 35: 62315
      • 36: 62316
      • 37: 62317
      • 38: 62318
      • 39: 62319
      • 40: 62320
      • 41: 62321
      • 42: 62322
      • 43: 62323
      • 44: 62324
      • 45: 62325
      • 46: 62326
      • 47: 62327
      • 48: 62328
      • 49: 62329
      • 50: 62330
      • 51: 62331
      • 52: 62332
      • 53: 62333
      • 54: 62334
      • 55: 62335
      • 56: 62336
      • 57: 62337
      • 58: 62338
      • 59: 62339
      • 60: 62340
      • 61: 62341
      • 62: 62342
      • 63: 62343
      • 64: 62344
      • 65: 62345
      • 66: 62346
      • 67: 62347
      • 68: 62348
      • 69: 62349
      • 70: 62350
      • 71: 62351
      • 72: 62352
      • 73: 62353
      • 74: 62354
      • 75: 62355
      • 76: 62356
      • 77: 62357
      • 78: 62358
      • 79: 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.45msselect `id` from `fpn_tournaments` where `event_id` = 867 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 867
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging15.34msselect `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` = 867 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (52066, 52067, 52068, 52069, 52070, 52071, 52072, 52073, 52074, 52092, 52093, 52094, 52095, 52096, 52097, 52098, 52099, 52100, 52101, 52118, 52119, 52120, 52121, 52122, 52123, 52124, 52125, 52126, 52127, 52144, 52145, 52146, 52147, 52148, 52149, 52150, 52151, 52152, 52153, 52170, 52171, 52172, 52173, 52174, 52175, 52176, 52177, 52178, 52179, 52196, 52197, 52198, 52199, 52200, 52201, 52202, 52203, 52204, 52205, 60292, 60293, 60294, 60295, 60309, 60310, 60311, 60312, 60325, 60326, 60327, 60341, 60342, 60343, 60357, 60358, 60359, 60373, 60374, 60375) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 867
      • 1: 1
      • 2: 52066
      • 3: 52067
      • 4: 52068
      • 5: 52069
      • 6: 52070
      • 7: 52071
      • 8: 52072
      • 9: 52073
      • 10: 52074
      • 11: 52092
      • 12: 52093
      • 13: 52094
      • 14: 52095
      • 15: 52096
      • 16: 52097
      • 17: 52098
      • 18: 52099
      • 19: 52100
      • 20: 52101
      • 21: 52118
      • 22: 52119
      • 23: 52120
      • 24: 52121
      • 25: 52122
      • 26: 52123
      • 27: 52124
      • 28: 52125
      • 29: 52126
      • 30: 52127
      • 31: 52144
      • 32: 52145
      • 33: 52146
      • 34: 52147
      • 35: 52148
      • 36: 52149
      • 37: 52150
      • 38: 52151
      • 39: 52152
      • 40: 52153
      • 41: 52170
      • 42: 52171
      • 43: 52172
      • 44: 52173
      • 45: 52174
      • 46: 52175
      • 47: 52176
      • 48: 52177
      • 49: 52178
      • 50: 52179
      • 51: 52196
      • 52: 52197
      • 53: 52198
      • 54: 52199
      • 55: 52200
      • 56: 52201
      • 57: 52202
      • 58: 52203
      • 59: 52204
      • 60: 52205
      • 61: 60292
      • 62: 60293
      • 63: 60294
      • 64: 60295
      • 65: 60309
      • 66: 60310
      • 67: 60311
      • 68: 60312
      • 69: 60325
      • 70: 60326
      • 71: 60327
      • 72: 60341
      • 73: 60342
      • 74: 60343
      • 75: 60357
      • 76: 60358
      • 77: 60359
      • 78: 60373
      • 79: 60374
      • 80: 60375
      • 81: 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#1848fpnstaging4.34msselect `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` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 24
      • 1: 1
      • 2: tommy-mille
      • 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#1857fpnstaging680μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 589 limit 1
      Bindings
      • 0: 589
      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-12 18:55:59' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-05-12 18:55:59
      • 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.39msselect `id` from `fpn_tournaments` where `event_id` = 589 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 589
      • 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#1915fpnstaging18.03msselect `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` = 589 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (44581, 44582, 44583, 44605, 44606, 44607, 44628, 44629, 44651, 44652, 44674, 44675, 48143, 48176, 48358, 48359, 48360, 48369, 48370, 48371, 48379, 48380, 48381, 48390, 48391, 48392, 48401, 48402, 48411, 48412, 48413, 49159, 49160, 49161, 49162, 49163, 49164, 49165, 49166, 49167, 49168, 49169, 49170, 49171, 49172, 49173, 49174, 49175, 49176, 49177, 49178, 49179, 49180, 49181, 49182, 49183, 49184, 49185, 49186, 49187, 49188, 49189, 49190, 49191, 49192, 49193, 49194, 49195, 49196, 49197, 49198, 49199, 49200, 49201, 49202, 49203, 49204, 49205) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 589
      • 1: 1
      • 2: 44581
      • 3: 44582
      • 4: 44583
      • 5: 44605
      • 6: 44606
      • 7: 44607
      • 8: 44628
      • 9: 44629
      • 10: 44651
      • 11: 44652
      • 12: 44674
      • 13: 44675
      • 14: 48143
      • 15: 48176
      • 16: 48358
      • 17: 48359
      • 18: 48360
      • 19: 48369
      • 20: 48370
      • 21: 48371
      • 22: 48379
      • 23: 48380
      • 24: 48381
      • 25: 48390
      • 26: 48391
      • 27: 48392
      • 28: 48401
      • 29: 48402
      • 30: 48411
      • 31: 48412
      • 32: 48413
      • 33: 49159
      • 34: 49160
      • 35: 49161
      • 36: 49162
      • 37: 49163
      • 38: 49164
      • 39: 49165
      • 40: 49166
      • 41: 49167
      • 42: 49168
      • 43: 49169
      • 44: 49170
      • 45: 49171
      • 46: 49172
      • 47: 49173
      • 48: 49174
      • 49: 49175
      • 50: 49176
      • 51: 49177
      • 52: 49178
      • 53: 49179
      • 54: 49180
      • 55: 49181
      • 56: 49182
      • 57: 49183
      • 58: 49184
      • 59: 49185
      • 60: 49186
      • 61: 49187
      • 62: 49188
      • 63: 49189
      • 64: 49190
      • 65: 49191
      • 66: 49192
      • 67: 49193
      • 68: 49194
      • 69: 49195
      • 70: 49196
      • 71: 49197
      • 72: 49198
      • 73: 49199
      • 74: 49200
      • 75: 49201
      • 76: 49202
      • 77: 49203
      • 78: 49204
      • 79: 49205
      • 80: 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` = 589 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 589
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging16.72msselect `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` = 589 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (41946, 41947, 41948, 41973, 41974, 41975, 41999, 42000, 42001, 42025, 42026, 42027, 42051, 42052, 42053, 44571, 44572, 44573, 44574, 44575, 44576, 44577, 44578, 44579, 44580, 44595, 44596, 44597, 44598, 44599, 44600, 44601, 44602, 44603, 44604, 44618, 44619, 44620, 44621, 44622, 44623, 44624, 44625, 44626, 44627, 44641, 44642, 44643, 44644, 44645, 44646, 44647, 44648, 44649, 44650, 44664, 44665, 44666, 44667, 44668, 44669, 44670, 44671, 44672, 44673) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 589
      • 1: 1
      • 2: 41946
      • 3: 41947
      • 4: 41948
      • 5: 41973
      • 6: 41974
      • 7: 41975
      • 8: 41999
      • 9: 42000
      • 10: 42001
      • 11: 42025
      • 12: 42026
      • 13: 42027
      • 14: 42051
      • 15: 42052
      • 16: 42053
      • 17: 44571
      • 18: 44572
      • 19: 44573
      • 20: 44574
      • 21: 44575
      • 22: 44576
      • 23: 44577
      • 24: 44578
      • 25: 44579
      • 26: 44580
      • 27: 44595
      • 28: 44596
      • 29: 44597
      • 30: 44598
      • 31: 44599
      • 32: 44600
      • 33: 44601
      • 34: 44602
      • 35: 44603
      • 36: 44604
      • 37: 44618
      • 38: 44619
      • 39: 44620
      • 40: 44621
      • 41: 44622
      • 42: 44623
      • 43: 44624
      • 44: 44625
      • 45: 44626
      • 46: 44627
      • 47: 44641
      • 48: 44642
      • 49: 44643
      • 50: 44644
      • 51: 44645
      • 52: 44646
      • 53: 44647
      • 54: 44648
      • 55: 44649
      • 56: 44650
      • 57: 44664
      • 58: 44665
      • 59: 44666
      • 60: 44667
      • 61: 44668
      • 62: 44669
      • 63: 44670
      • 64: 44671
      • 65: 44672
      • 66: 44673
      • 67: 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#1848fpnstaging4.4msselect `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` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: tommy-mille
      • 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#1857fpnstaging660μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 348 limit 1
      Bindings
      • 0: 348
      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#1862fpnstaging700μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-12 18:55:59' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-05-12 18:55:59
      • 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#1874fpnstaging940μsselect `id` from `fpn_tournaments` where `event_id` = 348 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 348
      • 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#1915fpnstaging15.22msselect `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` = 348 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (23667, 23668, 23693, 23694, 23720, 23747, 32440, 32451, 32462, 32474, 32486, 32667, 32668, 32669, 32670, 32671, 32672, 32673, 32674, 32675, 32676, 32677, 32678, 32679, 32680, 32681, 32682, 32683, 32684, 32685, 32686, 32687, 32688, 32689, 32690, 32691, 32692, 32693, 32694, 32695, 32696, 32697, 32698, 32699, 32700, 32701, 32702, 32703, 32704, 32705, 32706, 32707, 32708, 32709, 32710, 32711, 32712, 32713, 32714, 32715, 32716, 32717, 32718) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 348
      • 1: 1
      • 2: 23667
      • 3: 23668
      • 4: 23693
      • 5: 23694
      • 6: 23720
      • 7: 23747
      • 8: 32440
      • 9: 32451
      • 10: 32462
      • 11: 32474
      • 12: 32486
      • 13: 32667
      • 14: 32668
      • 15: 32669
      • 16: 32670
      • 17: 32671
      • 18: 32672
      • 19: 32673
      • 20: 32674
      • 21: 32675
      • 22: 32676
      • 23: 32677
      • 24: 32678
      • 25: 32679
      • 26: 32680
      • 27: 32681
      • 28: 32682
      • 29: 32683
      • 30: 32684
      • 31: 32685
      • 32: 32686
      • 33: 32687
      • 34: 32688
      • 35: 32689
      • 36: 32690
      • 37: 32691
      • 38: 32692
      • 39: 32693
      • 40: 32694
      • 41: 32695
      • 42: 32696
      • 43: 32697
      • 44: 32698
      • 45: 32699
      • 46: 32700
      • 47: 32701
      • 48: 32702
      • 49: 32703
      • 50: 32704
      • 51: 32705
      • 52: 32706
      • 53: 32707
      • 54: 32708
      • 55: 32709
      • 56: 32710
      • 57: 32711
      • 58: 32712
      • 59: 32713
      • 60: 32714
      • 61: 32715
      • 62: 32716
      • 63: 32717
      • 64: 32718
      • 65: 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.5msselect `id` from `fpn_tournaments` where `event_id` = 348 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 348
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging11.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` = 348 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (23654, 23655, 23656, 23657, 23658, 23659, 23660, 23661, 23662, 23663, 23664, 23665, 23666, 23680, 23681, 23682, 23683, 23684, 23685, 23686, 23687, 23688, 23689, 23690, 23691, 23692, 23706, 23707, 23708, 23709, 23710, 23711, 23712, 23713, 23714, 23715, 23716, 23717, 23718, 23719, 23733, 23734, 23735, 23736, 23737, 23738, 23739, 23740, 23741, 23742, 23743, 23744, 23745, 23746) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 348
      • 1: 1
      • 2: 23654
      • 3: 23655
      • 4: 23656
      • 5: 23657
      • 6: 23658
      • 7: 23659
      • 8: 23660
      • 9: 23661
      • 10: 23662
      • 11: 23663
      • 12: 23664
      • 13: 23665
      • 14: 23666
      • 15: 23680
      • 16: 23681
      • 17: 23682
      • 18: 23683
      • 19: 23684
      • 20: 23685
      • 21: 23686
      • 22: 23687
      • 23: 23688
      • 24: 23689
      • 25: 23690
      • 26: 23691
      • 27: 23692
      • 28: 23706
      • 29: 23707
      • 30: 23708
      • 31: 23709
      • 32: 23710
      • 33: 23711
      • 34: 23712
      • 35: 23713
      • 36: 23714
      • 37: 23715
      • 38: 23716
      • 39: 23717
      • 40: 23718
      • 41: 23719
      • 42: 23733
      • 43: 23734
      • 44: 23735
      • 45: 23736
      • 46: 23737
      • 47: 23738
      • 48: 23739
      • 49: 23740
      • 50: 23741
      • 51: 23742
      • 52: 23743
      • 53: 23744
      • 54: 23745
      • 55: 23746
      • 56: 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#1848fpnstaging4.2msselect `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` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 16
      • 1: 1
      • 2: tommy-mille
      • 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#1857fpnstaging660μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 185 limit 1
      Bindings
      • 0: 185
      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 ('10', '12', '13') and `end_date` < '2025-05-12 18:55:59' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 10
      • 1: 12
      • 2: 13
      • 3: 2025-05-12 18:55:59
      • 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.14msselect `id` from `fpn_tournaments` where `event_id` = 185 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
      Bindings
      • 0: 185
      • 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#1915fpnstaging10.41msselect `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` = 185 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (11874, 11875, 11876, 11877, 11894, 11895, 11896, 11897, 11913, 11914, 11915, 11916, 17696, 17697, 17698, 17699, 17700, 17701, 17702, 17703, 17704, 17705, 17706, 17707, 17708, 17709, 17710, 17711, 17712, 17713, 17714, 17715, 17716, 17717, 17718, 17719, 17720, 17721, 17722, 17723, 17724, 17725, 17726, 17727, 17728, 17729, 17730, 17731) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 185
      • 1: 1
      • 2: 11874
      • 3: 11875
      • 4: 11876
      • 5: 11877
      • 6: 11894
      • 7: 11895
      • 8: 11896
      • 9: 11897
      • 10: 11913
      • 11: 11914
      • 12: 11915
      • 13: 11916
      • 14: 17696
      • 15: 17697
      • 16: 17698
      • 17: 17699
      • 18: 17700
      • 19: 17701
      • 20: 17702
      • 21: 17703
      • 22: 17704
      • 23: 17705
      • 24: 17706
      • 25: 17707
      • 26: 17708
      • 27: 17709
      • 28: 17710
      • 29: 17711
      • 30: 17712
      • 31: 17713
      • 32: 17714
      • 33: 17715
      • 34: 17716
      • 35: 17717
      • 36: 17718
      • 37: 17719
      • 38: 17720
      • 39: 17721
      • 40: 17722
      • 41: 17723
      • 42: 17724
      • 43: 17725
      • 44: 17726
      • 45: 17727
      • 46: 17728
      • 47: 17729
      • 48: 17730
      • 49: 17731
      • 50: 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.29msselect `id` from `fpn_tournaments` where `event_id` = 185 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
      Bindings
      • 0: 185
      • 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#1915fpnstaging8.27msselect `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` = 185 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (9271, 9272, 9273, 9274, 9275, 9276, 9310, 9311, 9312, 9313, 9314, 9315, 9348, 9349, 9350, 9351, 9352, 9353, 9354, 11867, 11868, 11869, 11870, 11871, 11872, 11873, 11887, 11888, 11889, 11890, 11891, 11892, 11893, 11907, 11908, 11909, 11910, 11911, 11912) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 185
      • 1: 1
      • 2: 9271
      • 3: 9272
      • 4: 9273
      • 5: 9274
      • 6: 9275
      • 7: 9276
      • 8: 9310
      • 9: 9311
      • 10: 9312
      • 11: 9313
      • 12: 9314
      • 13: 9315
      • 14: 9348
      • 15: 9349
      • 16: 9350
      • 17: 9351
      • 18: 9352
      • 19: 9353
      • 20: 9354
      • 21: 11867
      • 22: 11868
      • 23: 11869
      • 24: 11870
      • 25: 11871
      • 26: 11872
      • 27: 11873
      • 28: 11887
      • 29: 11888
      • 30: 11889
      • 31: 11890
      • 32: 11891
      • 33: 11892
      • 34: 11893
      • 35: 11907
      • 36: 11908
      • 37: 11909
      • 38: 11910
      • 39: 11911
      • 40: 11912
      • 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.32msselect `id` from `fpn_tournaments` where `event_id` = 185 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
      Bindings
      • 0: 185
      • 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#1915fpnstaging3.13msselect `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` = 185 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (9258, 9259, 9260, 9261, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9297, 9298, 9299, 9300, 9301, 9302, 9303, 9304, 9305, 9306, 9307, 9308, 9309, 9336, 9337, 9338, 9339, 9340, 9341, 9342, 9343, 9344, 9345, 9346, 9347) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 185
      • 1: 1
      • 2: 9258
      • 3: 9259
      • 4: 9260
      • 5: 9261
      • 6: 9262
      • 7: 9263
      • 8: 9264
      • 9: 9265
      • 10: 9266
      • 11: 9267
      • 12: 9268
      • 13: 9269
      • 14: 9270
      • 15: 9297
      • 16: 9298
      • 17: 9299
      • 18: 9300
      • 19: 9301
      • 20: 9302
      • 21: 9303
      • 22: 9304
      • 23: 9305
      • 24: 9306
      • 25: 9307
      • 26: 9308
      • 27: 9309
      • 28: 9336
      • 29: 9337
      • 30: 9338
      • 31: 9339
      • 32: 9340
      • 33: 9341
      • 34: 9342
      • 35: 9343
      • 36: 9344
      • 37: 9345
      • 38: 9346
      • 39: 9347
      • 40: 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#1848fpnstaging6.3msselect `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` = 'tommy-mille' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
      Bindings
      • 0: 15
      • 1: 1
      • 2: tommy-mille
      • 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#1857fpnstaging750μ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#1862fpnstaging560μsselect * from `fpn_season` where `id` in ('7') and `end_date` < '2025-05-12 18:55:59' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 7
      • 1: 2025-05-12 18:55:59
      • 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#1874fpnstaging3.82msselect `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#1915fpnstaging1.46msselect `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\Article
    15Article.php#?
    App\Models\Season
    10Season.php#?
    App\Models\Promotion
    5Promotion.php#?
    App\Models\User
    1User.php#?
        • missed IWta0ys6ciLt5H7f7B0CqpJSgCO9sIM50wxKMAOJ (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 IWta0ys6ciLt5H7f7B0CqpJSgCO9sIM50wxKMAOJ (0μs)forget
        • 1 x missed IWta0ys6ciLt5H7f7B0CqpJSgCO9sIM50wxKMAOJ (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written IWta0ys6ciLt5H7f7B0CqpJSgCO9sIM50wxKMAOJ (0%)
          0μs
        _token
        5gha4E5fY0aXnF8AkFplcRthRlxgdKyJ7RmDHI3Y
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/tommy-mille" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/tommy-mille
        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 => "Mon, 12 May 2025 23:55:59 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImthQzMvQ3VQQTFlSU9sOGlReHZSSGc9PSIsInZhbHVlIjoiZExKWnc5b0ZPeitWMjR2Ykl0R0xEeEkwMWxqbHRZK21VcU0wRVF0R2dCYU03YS80V04yeCtseVR1Nzc2NEEvRms5L2dVNjUyb1I0dDBUdkYzTmhUU2VFUTB3OVNiQ3F2WG9OZ0xqSU5BMGhoQWgzUlZ4VWtRbERlOU1zMDZOeEwiLCJtYWMiOiIxNzY3Y2QzZjBlNzY2YTI0NmM0YjQ5NDc4MDc5MmU2YTYwOTNlMGFkOGY2NjdmYTNjZTRkNDZhMWNmMDZiODY2IiwidGFnIjoiIn0%3D; expires=Tue, 12 May 2026 23:55:59 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImthQzMvQ3VQQTFlSU9sOGlReHZSSGc9PSIsInZhbHVlIjoiZExKWnc5b0ZPeitWMjR2Ykl0R0xEeEkwMWxqbHRZK21VcU0wRVF0R2dCYU03YS80V04yeCtseVR1Nzc2NEEvRms5L2dVN" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IjZId3NBUUZ2ZTlSekoySWRGa0tJc2c9PSIsInZhbHVlIjoiM0E0UFJCaG5xWm1LbkxnQVF6bWpVRVg2OTduTW1Xdk1PeWxVaDBpY2dBRDBBQXFlT1BjTkhjT2RoWnkyUnJSSDlBZUVBcnpiTEdoeEE5N2VNL1pvMVAwM2dldEVPNlF0WURtTHNuN2Z1bTdTVTBlaUtjc3U4NndwSWtsWVlPU2IiLCJtYWMiOiI5YjJkNTllNzkwZjU3NTI3ZTQxMTU3ODIyMGJmYzI1NjBmODRhNTE3ZmE4MmQyY2YxZTU1NDU3NDA4YWJmOWUyIiwidGFnIjoiIn0%3D; expires=Tue, 12 May 2026 23:55:59 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6IjZId3NBUUZ2ZTlSekoySWRGa0tJc2c9PSIsInZhbHVlIjoiM0E0UFJCaG5xWm1LbkxnQVF6bWpVRVg2OTduTW1Xdk1PeWxVaDBpY2dBRDBBQXFlT1BjTkh" 2 => "RSVP_status=eyJpdiI6IkhBalFlMTdQSDJKTGx1alRWQ1ZWNFE9PSIsInZhbHVlIjoiMTAwUmJIKzg3ZlJZNEFGWVFkbnJ4YUhoakhPRVU1em5tazdxYU1TelY0YXZ3T3E2MDVCS1NiYUR2bnAxWmc0eSIsIm1hYyI6IjZkOTgxY2JmMTY0OGM1NmNkMGRlY2E3ZjkyYmZiMWY0YTg4OWMzOTRhOGU0NTQxODk0ODYxNmQ5ZDUzYzg0ZjIiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 13 May 2020 23:55:59 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6IkhBalFlMTdQSDJKTGx1alRWQ1ZWNFE9PSIsInZhbHVlIjoiMTAwUmJIKzg3ZlJZNEFGWVFkbnJ4YUhoakhPRVU1em5tazdxYU1TelY0YXZ3T3E2MDVCS1NiYUR2bnAxWmc0eSIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImthQzMvQ3VQQTFlSU9sOGlReHZSSGc9PSIsInZhbHVlIjoiZExKWnc5b0ZPeitWMjR2Ykl0R0xEeEkwMWxqbHRZK21VcU0wRVF0R2dCYU03YS80V04yeCtseVR1Nzc2NEEvRms5L2dVNjUyb1I0dDBUdkYzTmhUU2VFUTB3OVNiQ3F2WG9OZ0xqSU5BMGhoQWgzUlZ4VWtRbERlOU1zMDZOeEwiLCJtYWMiOiIxNzY3Y2QzZjBlNzY2YTI0NmM0YjQ5NDc4MDc5MmU2YTYwOTNlMGFkOGY2NjdmYTNjZTRkNDZhMWNmMDZiODY2IiwidGFnIjoiIn0%3D; expires=Tue, 12-May-2026 23:55:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImthQzMvQ3VQQTFlSU9sOGlReHZSSGc9PSIsInZhbHVlIjoiZExKWnc5b0ZPeitWMjR2Ykl0R0xEeEkwMWxqbHRZK21VcU0wRVF0R2dCYU03YS80V04yeCtseVR1Nzc2NEEvRms5L2dVN" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IjZId3NBUUZ2ZTlSekoySWRGa0tJc2c9PSIsInZhbHVlIjoiM0E0UFJCaG5xWm1LbkxnQVF6bWpVRVg2OTduTW1Xdk1PeWxVaDBpY2dBRDBBQXFlT1BjTkhjT2RoWnkyUnJSSDlBZUVBcnpiTEdoeEE5N2VNL1pvMVAwM2dldEVPNlF0WURtTHNuN2Z1bTdTVTBlaUtjc3U4NndwSWtsWVlPU2IiLCJtYWMiOiI5YjJkNTllNzkwZjU3NTI3ZTQxMTU3ODIyMGJmYzI1NjBmODRhNTE3ZmE4MmQyY2YxZTU1NDU3NDA4YWJmOWUyIiwidGFnIjoiIn0%3D; expires=Tue, 12-May-2026 23:55:59 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6IjZId3NBUUZ2ZTlSekoySWRGa0tJc2c9PSIsInZhbHVlIjoiM0E0UFJCaG5xWm1LbkxnQVF6bWpVRVg2OTduTW1Xdk1PeWxVaDBpY2dBRDBBQXFlT1BjTkh" 2 => "RSVP_status=eyJpdiI6IkhBalFlMTdQSDJKTGx1alRWQ1ZWNFE9PSIsInZhbHVlIjoiMTAwUmJIKzg3ZlJZNEFGWVFkbnJ4YUhoakhPRVU1em5tazdxYU1TelY0YXZ3T3E2MDVCS1NiYUR2bnAxWmc0eSIsIm1hYyI6IjZkOTgxY2JmMTY0OGM1NmNkMGRlY2E3ZjkyYmZiMWY0YTg4OWMzOTRhOGU0NTQxODk0ODYxNmQ5ZDUzYzg0ZjIiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 13-May-2020 23:55:59 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6IkhBalFlMTdQSDJKTGx1alRWQ1ZWNFE9PSIsInZhbHVlIjoiMTAwUmJIKzg3ZlJZNEFGWVFkbnJ4YUhoakhPRVU1em5tazdxYU1TelY0YXZ3T3E2MDVCS1NiYUR2bnAxWmc0eSIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "5gha4E5fY0aXnF8AkFplcRthRlxgdKyJ7RmDHI3Y" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/tommy-mille" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-12 18:55:59GET/player/tommy-mille1630513111