eo

edgar ogaz

edgar ogaz

All Time Points : 1355
|
Wins : 0

Tournaments Played : 65

edgar ogaz

Tournament History

edgar ogaz Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version864msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[10:05:41] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (55.52ms)time
  • Application (808ms)time
  • 1 x Application (93.57%)
    808ms
    1 x Booting (6.43%)
    55.52ms
    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
    104 statements were executed (20 duplicates)Show only duplicatesfpnstaging653ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 4 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • 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.74msselect * from `users` where `alias` = 'edgar-ogaz' limit 1
      Bindings
      • 0: edgar-ogaz
      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#151fpnstaging1.53msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 10215 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 10215
      • 1: 0
      Backtrace
      • app/Models/User.php:151
      • 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#163fpnstaging1.12msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10215 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 10215
      • 1: 1
      • 2: 1
      • 3: 1
      Backtrace
      • app/Models/User.php:163
      • 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#175fpnstaging1.45msselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10215 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 10215
      • 1: 1
      • 2: 1
      Backtrace
      • app/Models/User.php:175
      • 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#187fpnstaging1.27msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 10215 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: 10215
      • 1: 1
      • 2: 2
      • 3: 1
      • 4: 1
      Backtrace
      • app/Models/User.php:187
      • 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#189fpnstaging1.67msselect `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` 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 `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 and (`users`.`id` = 10215) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10215
      Backtrace
      • app/Models/User.php:189
      • 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#195fpnstaging2.3msselect 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` 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 `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 and (`users`.`id` = 10215) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10215
      Backtrace
      • app/Models/User.php:195
      • 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#195fpnstaging2.61msselect 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` 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 `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 and (`users`.`id` = 10215) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10215
      Backtrace
      • app/Models/User.php:195
      • 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#196fpnstaging3.16msselect 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` 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 `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 and (`users`.`id` = 10215) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10215
      Backtrace
      • app/Models/User.php:196
      • 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#196fpnstaging5.67msselect 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` 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 `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 and (`users`.`id` = 10215) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 10215
      Backtrace
      • app/Models/User.php:196
      • 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.47msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('10215',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#174fpnstaging49.18msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('10215',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#176fpnstaging48.78msselect * from `articles` where find_in_set(10215, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 10215
      • 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#214fpnstaging470μsselect `default_article_image` from `configurations`
      Backtrace
      • app/Services/ConfigSevice.php:214
      • app/Http/Controllers/Site/LeaderBoardController.php:271
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • LeaderBoardController.php#304fpnstaging1.87msselect `fpn_promotions`.`id`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_promotions`.`icons_badges_tooltip`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_tournaments`.`alias` as `tournament_alias`, `fpn_tournaments`.`start_date` from `fpn_tournaments` left join `fpn_promotions` on FIND_IN_SET(fpn_promotions.id, fpn_tournaments.qualifier_promotion_ids) > 0 inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`qualifier_types` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 and `tournament_players`.`rank` = 1 and `tournament_players`.`user_id` = 10215 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: 10215
      • 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#1836fpnstaging2.72msselect `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` = 'edgar-ogaz' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: edgar-ogaz
      • 2: 502
      • 3: 957
      • 4: 1212
      Backtrace
      • app/Models/League.php:1836
      • 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#1856fpnstaging2.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` = 26 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'edgar-ogaz' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 26
      • 1: 1
      • 2: edgar-ogaz
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1856
      • 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#1865fpnstaging700μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1080 limit 1
      Bindings
      • 0: 1080
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging650μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1865fpnstaging660μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1161 limit 1
      Bindings
      • 0: 1161
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging630μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1865fpnstaging610μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1081 limit 1
      Bindings
      • 0: 1081
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging570μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1856fpnstaging3.08msselect `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` = 'edgar-ogaz' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 25
      • 1: 1
      • 2: edgar-ogaz
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1856
      • 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#1865fpnstaging740μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 810 limit 1
      Bindings
      • 0: 810
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging790μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.17msselect `id` from `fpn_tournaments` where `event_id` = 810 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 810
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging28.88msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 810 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50181, 50182, 50183, 50184, 50185, 50207, 50208, 50209, 50210, 50211, 50234, 50235, 50236, 50237, 50238, 62751, 62752, 62753, 62754, 62755, 62756, 62757, 62758, 62759, 62760, 62761, 62762, 62763, 62764, 62765, 62766, 62767, 62768, 62769, 62770, 62771, 62772, 62773, 63035) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 810
      • 1: 1
      • 2: 50181
      • 3: 50182
      • 4: 50183
      • 5: 50184
      • 6: 50185
      • 7: 50207
      • 8: 50208
      • 9: 50209
      • 10: 50210
      • 11: 50211
      • 12: 50234
      • 13: 50235
      • 14: 50236
      • 15: 50237
      • 16: 50238
      • 17: 62751
      • 18: 62752
      • 19: 62753
      • 20: 62754
      • 21: 62755
      • 22: 62756
      • 23: 62757
      • 24: 62758
      • 25: 62759
      • 26: 62760
      • 27: 62761
      • 28: 62762
      • 29: 62763
      • 30: 62764
      • 31: 62765
      • 32: 62766
      • 33: 62767
      • 34: 62768
      • 35: 62769
      • 36: 62770
      • 37: 62771
      • 38: 62772
      • 39: 62773
      • 40: 63035
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.27msselect `id` from `fpn_tournaments` where `event_id` = 810 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 810
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging25.62msselect `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` = 810 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50168, 50169, 50170, 50171, 50172, 50173, 50174, 50175, 50176, 50177, 50178, 50179, 50180, 50194, 50195, 50196, 50197, 50198, 50199, 50200, 50201, 50202, 50203, 50204, 50205, 50206, 50220, 50221, 50222, 50223, 50224, 50225, 50226, 50227, 50228, 50229, 50230, 50231, 50232, 50233) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 810
      • 1: 1
      • 2: 50168
      • 3: 50169
      • 4: 50170
      • 5: 50171
      • 6: 50172
      • 7: 50173
      • 8: 50174
      • 9: 50175
      • 10: 50176
      • 11: 50177
      • 12: 50178
      • 13: 50179
      • 14: 50180
      • 15: 50194
      • 16: 50195
      • 17: 50196
      • 18: 50197
      • 19: 50198
      • 20: 50199
      • 21: 50200
      • 22: 50201
      • 23: 50202
      • 24: 50203
      • 25: 50204
      • 26: 50205
      • 27: 50206
      • 28: 50220
      • 29: 50221
      • 30: 50222
      • 31: 50223
      • 32: 50224
      • 33: 50225
      • 34: 50226
      • 35: 50227
      • 36: 50228
      • 37: 50229
      • 38: 50230
      • 39: 50231
      • 40: 50232
      • 41: 50233
      • 42: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging710μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 900 limit 1
      Bindings
      • 0: 900
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging660μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging930μsselect `id` from `fpn_tournaments` where `event_id` = 900 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 900
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging15.64msselect `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` = 900 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53535, 53536, 53537, 53538, 53539, 53540, 53561, 53562, 53563, 53564, 53565, 53587, 53588, 53589, 53590, 53591, 62720, 62721, 62722, 62723, 62724, 62725, 62726, 62727, 62728, 62729, 62730, 62731, 62732, 62733, 62734, 62735, 62736, 62737, 62738, 62739, 62740, 62741, 62742) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 900
      • 1: 1
      • 2: 53535
      • 3: 53536
      • 4: 53537
      • 5: 53538
      • 6: 53539
      • 7: 53540
      • 8: 53561
      • 9: 53562
      • 10: 53563
      • 11: 53564
      • 12: 53565
      • 13: 53587
      • 14: 53588
      • 15: 53589
      • 16: 53590
      • 17: 53591
      • 18: 62720
      • 19: 62721
      • 20: 62722
      • 21: 62723
      • 22: 62724
      • 23: 62725
      • 24: 62726
      • 25: 62727
      • 26: 62728
      • 27: 62729
      • 28: 62730
      • 29: 62731
      • 30: 62732
      • 31: 62733
      • 32: 62734
      • 33: 62735
      • 34: 62736
      • 35: 62737
      • 36: 62738
      • 37: 62739
      • 38: 62740
      • 39: 62741
      • 40: 62742
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.24msselect `id` from `fpn_tournaments` where `event_id` = 900 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 900
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging12.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` = 900 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53522, 53523, 53524, 53525, 53526, 53527, 53528, 53529, 53530, 53531, 53532, 53533, 53534, 53548, 53549, 53550, 53551, 53552, 53553, 53554, 53555, 53556, 53557, 53558, 53559, 53560, 53574, 53575, 53576, 53577, 53578, 53579, 53580, 53581, 53582, 53583, 53584, 53585, 53586) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 900
      • 1: 1
      • 2: 53522
      • 3: 53523
      • 4: 53524
      • 5: 53525
      • 6: 53526
      • 7: 53527
      • 8: 53528
      • 9: 53529
      • 10: 53530
      • 11: 53531
      • 12: 53532
      • 13: 53533
      • 14: 53534
      • 15: 53548
      • 16: 53549
      • 17: 53550
      • 18: 53551
      • 19: 53552
      • 20: 53553
      • 21: 53554
      • 22: 53555
      • 23: 53556
      • 24: 53557
      • 25: 53558
      • 26: 53559
      • 27: 53560
      • 28: 53574
      • 29: 53575
      • 30: 53576
      • 31: 53577
      • 32: 53578
      • 33: 53579
      • 34: 53580
      • 35: 53581
      • 36: 53582
      • 37: 53583
      • 38: 53584
      • 39: 53585
      • 40: 53586
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging690μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 811 limit 1
      Bindings
      • 0: 811
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging600μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging790μsselect `id` from `fpn_tournaments` where `event_id` = 811 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 811
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging11.56msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 811 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50259, 50260, 50261, 50262, 50263, 62743, 62744, 62745, 62746, 62747, 62748, 62749, 62750) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 811
      • 1: 1
      • 2: 50259
      • 3: 50260
      • 4: 50261
      • 5: 50262
      • 6: 50263
      • 7: 62743
      • 8: 62744
      • 9: 62745
      • 10: 62746
      • 11: 62747
      • 12: 62748
      • 13: 62749
      • 14: 62750
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging910μsselect `id` from `fpn_tournaments` where `event_id` = 811 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 811
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging8.29msselect `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` = 811 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50246, 50247, 50248, 50249, 50250, 50251, 50252, 50253, 50254, 50255, 50256, 50257, 50258) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 811
      • 1: 1
      • 2: 50246
      • 3: 50247
      • 4: 50248
      • 5: 50249
      • 6: 50250
      • 7: 50251
      • 8: 50252
      • 9: 50253
      • 10: 50254
      • 11: 50255
      • 12: 50256
      • 13: 50257
      • 14: 50258
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging650μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 898 limit 1
      Bindings
      • 0: 898
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging610μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.09msselect `id` from `fpn_tournaments` where `event_id` = 898 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 898
      • 1: 2025-01-01 00:00:00
      • 2: 2025-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging20.89msselect `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` = 898 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53171, 53172, 53173, 53174, 53175, 53176, 53177, 53178, 53179, 53180, 53181, 53182, 53183, 53197, 53198, 53199, 53200, 53201, 53202, 53203, 53204, 53205, 53206, 53207, 53208, 53209, 53224, 53225, 53226, 53227, 53228, 53229, 53230, 53231, 53232, 53233, 53234, 53235, 53249, 53250, 53251, 53252, 53253, 53254, 53255, 53256, 53257, 53258, 53259, 53260, 53261, 53275, 53276, 53277, 53278, 53279, 53280, 53281, 53282, 53283, 53284, 53285, 53286, 53287, 53301, 53302, 53303, 53304, 53305, 53306, 53307, 53308, 53309, 53310, 53311, 53312, 53313, 53327, 53328, 53329, 53330, 53331, 53332, 53333, 53334, 53335, 53336, 53337, 53338, 53339) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 898
      • 1: 1
      • 2: 53171
      • 3: 53172
      • 4: 53173
      • 5: 53174
      • 6: 53175
      • 7: 53176
      • 8: 53177
      • 9: 53178
      • 10: 53179
      • 11: 53180
      • 12: 53181
      • 13: 53182
      • 14: 53183
      • 15: 53197
      • 16: 53198
      • 17: 53199
      • 18: 53200
      • 19: 53201
      • 20: 53202
      • 21: 53203
      • 22: 53204
      • 23: 53205
      • 24: 53206
      • 25: 53207
      • 26: 53208
      • 27: 53209
      • 28: 53224
      • 29: 53225
      • 30: 53226
      • 31: 53227
      • 32: 53228
      • 33: 53229
      • 34: 53230
      • 35: 53231
      • 36: 53232
      • 37: 53233
      • 38: 53234
      • 39: 53235
      • 40: 53249
      • 41: 53250
      • 42: 53251
      • 43: 53252
      • 44: 53253
      • 45: 53254
      • 46: 53255
      • 47: 53256
      • 48: 53257
      • 49: 53258
      • 50: 53259
      • 51: 53260
      • 52: 53261
      • 53: 53275
      • 54: 53276
      • 55: 53277
      • 56: 53278
      • 57: 53279
      • 58: 53280
      • 59: 53281
      • 60: 53282
      • 61: 53283
      • 62: 53284
      • 63: 53285
      • 64: 53286
      • 65: 53287
      • 66: 53301
      • 67: 53302
      • 68: 53303
      • 69: 53304
      • 70: 53305
      • 71: 53306
      • 72: 53307
      • 73: 53308
      • 74: 53309
      • 75: 53310
      • 76: 53311
      • 77: 53312
      • 78: 53313
      • 79: 53327
      • 80: 53328
      • 81: 53329
      • 82: 53330
      • 83: 53331
      • 84: 53332
      • 85: 53333
      • 86: 53334
      • 87: 53335
      • 88: 53336
      • 89: 53337
      • 90: 53338
      • 91: 53339
      • 92: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.45msselect `id` from `fpn_tournaments` where `event_id` = 898 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 898
      • 1: 2024-10-01 00:00:00
      • 2: 2024-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging21.1msselect `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` = 898 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (53158, 53159, 53160, 53161, 53162, 53163, 53164, 53165, 53166, 53167, 53168, 53169, 53170, 53184, 53185, 53186, 53187, 53188, 53189, 53190, 53191, 53192, 53193, 53194, 53195, 53196, 53210, 53211, 53212, 53213, 53214, 53215, 53216, 53217, 53218, 53219, 53220, 53221, 53222, 53223, 53236, 53237, 53238, 53239, 53240, 53241, 53242, 53243, 53244, 53245, 53246, 53247, 53248, 53262, 53263, 53264, 53265, 53266, 53267, 53268, 53269, 53270, 53271, 53272, 53273, 53274, 53288, 53289, 53290, 53291, 53292, 53293, 53294, 53295, 53296, 53297, 53298, 53299, 53300, 53314, 53315, 53316, 53317, 53318, 53319, 53320, 53321, 53322, 53323, 53324, 53325, 53326) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 898
      • 1: 1
      • 2: 53158
      • 3: 53159
      • 4: 53160
      • 5: 53161
      • 6: 53162
      • 7: 53163
      • 8: 53164
      • 9: 53165
      • 10: 53166
      • 11: 53167
      • 12: 53168
      • 13: 53169
      • 14: 53170
      • 15: 53184
      • 16: 53185
      • 17: 53186
      • 18: 53187
      • 19: 53188
      • 20: 53189
      • 21: 53190
      • 22: 53191
      • 23: 53192
      • 24: 53193
      • 25: 53194
      • 26: 53195
      • 27: 53196
      • 28: 53210
      • 29: 53211
      • 30: 53212
      • 31: 53213
      • 32: 53214
      • 33: 53215
      • 34: 53216
      • 35: 53217
      • 36: 53218
      • 37: 53219
      • 38: 53220
      • 39: 53221
      • 40: 53222
      • 41: 53223
      • 42: 53236
      • 43: 53237
      • 44: 53238
      • 45: 53239
      • 46: 53240
      • 47: 53241
      • 48: 53242
      • 49: 53243
      • 50: 53244
      • 51: 53245
      • 52: 53246
      • 53: 53247
      • 54: 53248
      • 55: 53262
      • 56: 53263
      • 57: 53264
      • 58: 53265
      • 59: 53266
      • 60: 53267
      • 61: 53268
      • 62: 53269
      • 63: 53270
      • 64: 53271
      • 65: 53272
      • 66: 53273
      • 67: 53274
      • 68: 53288
      • 69: 53289
      • 70: 53290
      • 71: 53291
      • 72: 53292
      • 73: 53293
      • 74: 53294
      • 75: 53295
      • 76: 53296
      • 77: 53297
      • 78: 53298
      • 79: 53299
      • 80: 53300
      • 81: 53314
      • 82: 53315
      • 83: 53316
      • 84: 53317
      • 85: 53318
      • 86: 53319
      • 87: 53320
      • 88: 53321
      • 89: 53322
      • 90: 53323
      • 91: 53324
      • 92: 53325
      • 93: 53326
      • 94: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1856fpnstaging1.94msselect `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` = 'edgar-ogaz' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 24
      • 1: 1
      • 2: edgar-ogaz
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1856
      • 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#1865fpnstaging560μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 515 limit 1
      Bindings
      • 0: 515
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging590μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging960μsselect `id` from `fpn_tournaments` where `event_id` = 515 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 515
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging20.99msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 515 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34319, 34320, 34321, 34322, 34323, 34324, 34325, 34326, 34327, 34328, 34329, 34330, 34331, 34332, 34346, 34347, 34348, 34349, 34350, 34351, 34352, 34353, 34354, 34355, 34356, 34357, 34358, 34372, 34373, 34374, 34375, 34376, 34377, 34378, 34379, 34380, 34381, 34382, 34383, 34384) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 515
      • 1: 1
      • 2: 34319
      • 3: 34320
      • 4: 34321
      • 5: 34322
      • 6: 34323
      • 7: 34324
      • 8: 34325
      • 9: 34326
      • 10: 34327
      • 11: 34328
      • 12: 34329
      • 13: 34330
      • 14: 34331
      • 15: 34332
      • 16: 34346
      • 17: 34347
      • 18: 34348
      • 19: 34349
      • 20: 34350
      • 21: 34351
      • 22: 34352
      • 23: 34353
      • 24: 34354
      • 25: 34355
      • 26: 34356
      • 27: 34357
      • 28: 34358
      • 29: 34372
      • 30: 34373
      • 31: 34374
      • 32: 34375
      • 33: 34376
      • 34: 34377
      • 35: 34378
      • 36: 34379
      • 37: 34380
      • 38: 34381
      • 39: 34382
      • 40: 34383
      • 41: 34384
      • 42: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.22msselect `id` from `fpn_tournaments` where `event_id` = 515 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 515
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging22.54msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 515 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34306, 34307, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34318, 34333, 34334, 34335, 34336, 34337, 34338, 34339, 34340, 34341, 34342, 34343, 34344, 34345, 34359, 34360, 34361, 34362, 34363, 34364, 34365, 34366, 34367, 34368, 34369, 34370, 34371) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 515
      • 1: 1
      • 2: 34306
      • 3: 34307
      • 4: 34308
      • 5: 34309
      • 6: 34310
      • 7: 34311
      • 8: 34312
      • 9: 34313
      • 10: 34314
      • 11: 34315
      • 12: 34316
      • 13: 34317
      • 14: 34318
      • 15: 34333
      • 16: 34334
      • 17: 34335
      • 18: 34336
      • 19: 34337
      • 20: 34338
      • 21: 34339
      • 22: 34340
      • 23: 34341
      • 24: 34342
      • 25: 34343
      • 26: 34344
      • 27: 34345
      • 28: 34359
      • 29: 34360
      • 30: 34361
      • 31: 34362
      • 32: 34363
      • 33: 34364
      • 34: 34365
      • 35: 34366
      • 36: 34367
      • 37: 34368
      • 38: 34369
      • 39: 34370
      • 40: 34371
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging670μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 517 limit 1
      Bindings
      • 0: 517
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging870μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging730μsselect `id` from `fpn_tournaments` where `event_id` = 517 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 517
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging9.54msselect `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` = 517 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34424, 34425, 34426, 48448, 48449, 48450, 48451, 48452, 48453, 48454, 48455, 48456, 48457) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 517
      • 1: 1
      • 2: 34424
      • 3: 34425
      • 4: 34426
      • 5: 48448
      • 6: 48449
      • 7: 48450
      • 8: 48451
      • 9: 48452
      • 10: 48453
      • 11: 48454
      • 12: 48455
      • 13: 48456
      • 14: 48457
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging890μsselect `id` from `fpn_tournaments` where `event_id` = 517 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 517
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging11.5msselect `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` = 517 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34411, 34412, 34413, 34414, 34415, 34416, 34417, 34418, 34419, 34420, 34421, 34422, 34423) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 517
      • 1: 1
      • 2: 34411
      • 3: 34412
      • 4: 34413
      • 5: 34414
      • 6: 34415
      • 7: 34416
      • 8: 34417
      • 9: 34418
      • 10: 34419
      • 11: 34420
      • 12: 34421
      • 13: 34422
      • 14: 34423
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging700μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 637 limit 1
      Bindings
      • 0: 637
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging600μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.3msselect `id` from `fpn_tournaments` where `event_id` = 637 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 637
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging24.1msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 637 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (47632, 47633, 47634, 47635, 47636, 47645, 47646, 47647, 47648, 47649, 47650, 47660, 47661, 47662, 47663, 47664, 47665, 47674, 47675, 47676, 47677, 47678, 47688, 47689, 47690, 47691, 47692, 47702, 47703, 47704, 47705, 47706, 47716, 47717, 47718, 47719, 47720, 49047, 49048, 49049, 49050, 49051, 49052, 49053, 49054, 49055, 49056, 49057, 49058, 49059, 49060, 49061, 49062, 49063, 49064, 49065, 49066, 49067, 49068, 49069, 49070, 49071, 49072, 49073, 49074, 49075, 49076, 49077, 49078, 49079, 49080, 49081, 49082, 49083, 49084, 49085, 49086, 49087, 49088, 49089, 49090, 49091, 49092, 49093, 49094, 49095, 49096, 49097, 49098, 49099, 49100, 49101) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 637
      • 1: 1
      • 2: 47632
      • 3: 47633
      • 4: 47634
      • 5: 47635
      • 6: 47636
      • 7: 47645
      • 8: 47646
      • 9: 47647
      • 10: 47648
      • 11: 47649
      • 12: 47650
      • 13: 47660
      • 14: 47661
      • 15: 47662
      • 16: 47663
      • 17: 47664
      • 18: 47665
      • 19: 47674
      • 20: 47675
      • 21: 47676
      • 22: 47677
      • 23: 47678
      • 24: 47688
      • 25: 47689
      • 26: 47690
      • 27: 47691
      • 28: 47692
      • 29: 47702
      • 30: 47703
      • 31: 47704
      • 32: 47705
      • 33: 47706
      • 34: 47716
      • 35: 47717
      • 36: 47718
      • 37: 47719
      • 38: 47720
      • 39: 49047
      • 40: 49048
      • 41: 49049
      • 42: 49050
      • 43: 49051
      • 44: 49052
      • 45: 49053
      • 46: 49054
      • 47: 49055
      • 48: 49056
      • 49: 49057
      • 50: 49058
      • 51: 49059
      • 52: 49060
      • 53: 49061
      • 54: 49062
      • 55: 49063
      • 56: 49064
      • 57: 49065
      • 58: 49066
      • 59: 49067
      • 60: 49068
      • 61: 49069
      • 62: 49070
      • 63: 49071
      • 64: 49072
      • 65: 49073
      • 66: 49074
      • 67: 49075
      • 68: 49076
      • 69: 49077
      • 70: 49078
      • 71: 49079
      • 72: 49080
      • 73: 49081
      • 74: 49082
      • 75: 49083
      • 76: 49084
      • 77: 49085
      • 78: 49086
      • 79: 49087
      • 80: 49088
      • 81: 49089
      • 82: 49090
      • 83: 49091
      • 84: 49092
      • 85: 49093
      • 86: 49094
      • 87: 49095
      • 88: 49096
      • 89: 49097
      • 90: 49098
      • 91: 49099
      • 92: 49100
      • 93: 49101
      • 94: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.5msselect `id` from `fpn_tournaments` where `event_id` = 637 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 637
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging25.98msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 637 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (38494, 38495, 38496, 38497, 38498, 38499, 38500, 38501, 38502, 38503, 38504, 38505, 38520, 38521, 38522, 38523, 38524, 38525, 38526, 38527, 38528, 38529, 38530, 38531, 38532, 38547, 38548, 38549, 38550, 38551, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38573, 38574, 38575, 38576, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38584, 38599, 38600, 38601, 38602, 38603, 38604, 38605, 38606, 38607, 38608, 38609, 38610, 38625, 38626, 38627, 38628, 38629, 38630, 38631, 38632, 38633, 38634, 38635, 38636, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38658, 38659, 38660, 38661, 38662, 47631, 47659, 47673, 47687, 47701, 47715) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 637
      • 1: 1
      • 2: 38494
      • 3: 38495
      • 4: 38496
      • 5: 38497
      • 6: 38498
      • 7: 38499
      • 8: 38500
      • 9: 38501
      • 10: 38502
      • 11: 38503
      • 12: 38504
      • 13: 38505
      • 14: 38520
      • 15: 38521
      • 16: 38522
      • 17: 38523
      • 18: 38524
      • 19: 38525
      • 20: 38526
      • 21: 38527
      • 22: 38528
      • 23: 38529
      • 24: 38530
      • 25: 38531
      • 26: 38532
      • 27: 38547
      • 28: 38548
      • 29: 38549
      • 30: 38550
      • 31: 38551
      • 32: 38552
      • 33: 38553
      • 34: 38554
      • 35: 38555
      • 36: 38556
      • 37: 38557
      • 38: 38558
      • 39: 38573
      • 40: 38574
      • 41: 38575
      • 42: 38576
      • 43: 38577
      • 44: 38578
      • 45: 38579
      • 46: 38580
      • 47: 38581
      • 48: 38582
      • 49: 38583
      • 50: 38584
      • 51: 38599
      • 52: 38600
      • 53: 38601
      • 54: 38602
      • 55: 38603
      • 56: 38604
      • 57: 38605
      • 58: 38606
      • 59: 38607
      • 60: 38608
      • 61: 38609
      • 62: 38610
      • 63: 38625
      • 64: 38626
      • 65: 38627
      • 66: 38628
      • 67: 38629
      • 68: 38630
      • 69: 38631
      • 70: 38632
      • 71: 38633
      • 72: 38634
      • 73: 38635
      • 74: 38636
      • 75: 38651
      • 76: 38652
      • 77: 38653
      • 78: 38654
      • 79: 38655
      • 80: 38656
      • 81: 38657
      • 82: 38658
      • 83: 38659
      • 84: 38660
      • 85: 38661
      • 86: 38662
      • 87: 47631
      • 88: 47659
      • 89: 47673
      • 90: 47687
      • 91: 47701
      • 92: 47715
      • 93: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging650μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 567 limit 1
      Bindings
      • 0: 567
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging570μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.07msselect `id` from `fpn_tournaments` where `event_id` = 567 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 567
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging2.85msselect `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` = 567 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (44133, 44134, 44135, 44136, 44137, 44138, 44139, 44140, 44141, 44142, 44156, 44157, 44158, 44159, 44160, 44161, 44162, 44163, 44164, 44165, 44181, 44182, 44183, 44184, 44185, 44186, 44187, 44188, 44189, 44190, 49872, 49873, 49874, 49875, 49876, 49877, 49878, 49879, 49880, 49881) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 567
      • 1: 1
      • 2: 44133
      • 3: 44134
      • 4: 44135
      • 5: 44136
      • 6: 44137
      • 7: 44138
      • 8: 44139
      • 9: 44140
      • 10: 44141
      • 11: 44142
      • 12: 44156
      • 13: 44157
      • 14: 44158
      • 15: 44159
      • 16: 44160
      • 17: 44161
      • 18: 44162
      • 19: 44163
      • 20: 44164
      • 21: 44165
      • 22: 44181
      • 23: 44182
      • 24: 44183
      • 25: 44184
      • 26: 44185
      • 27: 44186
      • 28: 44187
      • 29: 44188
      • 30: 44189
      • 31: 44190
      • 32: 49872
      • 33: 49873
      • 34: 49874
      • 35: 49875
      • 36: 49876
      • 37: 49877
      • 38: 49878
      • 39: 49879
      • 40: 49880
      • 41: 49881
      • 42: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging900μsselect `id` from `fpn_tournaments` where `event_id` = 567 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 567
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging7.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` = 567 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (42631, 42632, 42657, 42658, 42659, 42684, 42685, 44122, 44123, 44124, 44125, 44126, 44127, 44128, 44129, 44130, 44131, 44132, 44146, 44147, 44148, 44149, 44150, 44151, 44152, 44153, 44154, 44155, 44170, 44171, 44172, 44173, 44174, 44175, 44176, 44177, 44178, 44179, 44180) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 567
      • 1: 1
      • 2: 42631
      • 3: 42632
      • 4: 42657
      • 5: 42658
      • 6: 42659
      • 7: 42684
      • 8: 42685
      • 9: 44122
      • 10: 44123
      • 11: 44124
      • 12: 44125
      • 13: 44126
      • 14: 44127
      • 15: 44128
      • 16: 44129
      • 17: 44130
      • 18: 44131
      • 19: 44132
      • 20: 44146
      • 21: 44147
      • 22: 44148
      • 23: 44149
      • 24: 44150
      • 25: 44151
      • 26: 44152
      • 27: 44153
      • 28: 44154
      • 29: 44155
      • 30: 44170
      • 31: 44171
      • 32: 44172
      • 33: 44173
      • 34: 44174
      • 35: 44175
      • 36: 44176
      • 37: 44177
      • 38: 44178
      • 39: 44179
      • 40: 44180
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging690μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 784 limit 1
      Bindings
      • 0: 784
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging620μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 17
      • 1: 18
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.02msselect `id` from `fpn_tournaments` where `event_id` = 784 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
      Bindings
      • 0: 784
      • 1: 2024-07-01 00:00:00
      • 2: 2024-09-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging3.99msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 784 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (48471, 48472, 48473, 48474, 48475, 48476, 48477, 48478, 48479, 48480, 48481, 48482, 48483) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 784
      • 1: 1
      • 2: 48471
      • 3: 48472
      • 4: 48473
      • 5: 48474
      • 6: 48475
      • 7: 48476
      • 8: 48477
      • 9: 48478
      • 10: 48479
      • 11: 48480
      • 12: 48481
      • 13: 48482
      • 14: 48483
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.37msselect `id` from `fpn_tournaments` where `event_id` = 784 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
      Bindings
      • 0: 784
      • 1: 2024-04-01 00:00:00
      • 2: 2024-06-30 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging2.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` = 784 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (48458, 48459, 48460, 48461, 48462, 48463, 48464, 48465, 48466, 48467, 48468, 48469, 48470) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 784
      • 1: 1
      • 2: 48458
      • 3: 48459
      • 4: 48460
      • 5: 48461
      • 6: 48462
      • 7: 48463
      • 8: 48464
      • 9: 48465
      • 10: 48466
      • 11: 48467
      • 12: 48468
      • 13: 48469
      • 14: 48470
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1856fpnstaging2.25msselect `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` = 'edgar-ogaz' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: edgar-ogaz
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1856
      • 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#1865fpnstaging770μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 400 limit 1
      Bindings
      • 0: 400
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging740μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.06msselect `id` from `fpn_tournaments` where `event_id` = 400 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 400
      • 1: 2024-01-01 00:00:00
      • 2: 2024-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging21.21msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 400 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (31741, 31742, 31743, 31744, 31745, 31746, 31747, 31748, 31749, 31750, 31751, 31752, 31753, 31755, 31756, 31757, 31758, 31759, 31760, 31761, 31762, 31763, 31764, 31765, 31766, 31767, 31770, 31771, 31772, 31773, 31774, 31775, 31776, 31777, 31778, 31779, 31780, 31781, 31782) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 400
      • 1: 1
      • 2: 31741
      • 3: 31742
      • 4: 31743
      • 5: 31744
      • 6: 31745
      • 7: 31746
      • 8: 31747
      • 9: 31748
      • 10: 31749
      • 11: 31750
      • 12: 31751
      • 13: 31752
      • 14: 31753
      • 15: 31755
      • 16: 31756
      • 17: 31757
      • 18: 31758
      • 19: 31759
      • 20: 31760
      • 21: 31761
      • 22: 31762
      • 23: 31763
      • 24: 31764
      • 25: 31765
      • 26: 31766
      • 27: 31767
      • 28: 31770
      • 29: 31771
      • 30: 31772
      • 31: 31773
      • 32: 31774
      • 33: 31775
      • 34: 31776
      • 35: 31777
      • 36: 31778
      • 37: 31779
      • 38: 31780
      • 39: 31781
      • 40: 31782
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.16msselect `id` from `fpn_tournaments` where `event_id` = 400 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 400
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging19.49msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 400 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25662, 25663, 25664, 25665, 25666, 25667, 25668, 25669, 25670, 25671, 25672, 25673, 25688, 25689, 25690, 25691, 25692, 25693, 25694, 25695, 25696, 25697, 25698, 25699, 25714, 25715, 25716, 25717, 25718, 25719, 25720, 25721, 25722, 25723, 25724, 31740, 31754, 31768, 31769) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 400
      • 1: 1
      • 2: 25662
      • 3: 25663
      • 4: 25664
      • 5: 25665
      • 6: 25666
      • 7: 25667
      • 8: 25668
      • 9: 25669
      • 10: 25670
      • 11: 25671
      • 12: 25672
      • 13: 25673
      • 14: 25688
      • 15: 25689
      • 16: 25690
      • 17: 25691
      • 18: 25692
      • 19: 25693
      • 20: 25694
      • 21: 25695
      • 22: 25696
      • 23: 25697
      • 24: 25698
      • 25: 25699
      • 26: 25714
      • 27: 25715
      • 28: 25716
      • 29: 25717
      • 30: 25718
      • 31: 25719
      • 32: 25720
      • 33: 25721
      • 34: 25722
      • 35: 25723
      • 36: 25724
      • 37: 31740
      • 38: 31754
      • 39: 31768
      • 40: 31769
      • 41: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging1.07msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 266 limit 1
      Bindings
      • 0: 266
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging960μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.12msselect `id` from `fpn_tournaments` where `event_id` = 266 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 266
      • 1: 2024-01-01 00:00:00
      • 2: 2024-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging9.55msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 266 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20703, 20704, 20705, 20706, 20707, 20708, 20709, 20710, 20711, 20712, 33996, 33997, 33998) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 266
      • 1: 1
      • 2: 20703
      • 3: 20704
      • 4: 20705
      • 5: 20706
      • 6: 20707
      • 7: 20708
      • 8: 20709
      • 9: 20710
      • 10: 20711
      • 11: 20712
      • 12: 33996
      • 13: 33997
      • 14: 33998
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging700μsselect `id` from `fpn_tournaments` where `event_id` = 266 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 266
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging10.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` = 266 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20690, 20691, 20692, 20693, 20694, 20695, 20696, 20697, 20698, 20699, 20700, 20701, 20702) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 266
      • 1: 1
      • 2: 20690
      • 3: 20691
      • 4: 20692
      • 5: 20693
      • 6: 20694
      • 7: 20695
      • 8: 20696
      • 9: 20697
      • 10: 20698
      • 11: 20699
      • 12: 20700
      • 13: 20701
      • 14: 20702
      • 15: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging1.02msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 398 limit 1
      Bindings
      • 0: 398
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging650μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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#1882fpnstaging1.07msselect `id` from `fpn_tournaments` where `event_id` = 398 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 398
      • 1: 2024-01-01 00:00:00
      • 2: 2024-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging31.5msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 398 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (28663, 28664, 28665, 28666, 28667, 28668, 28669, 28670, 28671, 28672, 28673, 28674, 28675, 28686, 28687, 28688, 28689, 28690, 28691, 28692, 28693, 28694, 28695, 28696, 28697, 28698, 28709, 28710, 28711, 28712, 28713, 28714, 28715, 28716, 28717, 28718, 28719, 28720, 28721, 28732, 28733, 28734, 28735, 28736, 28737, 28738, 28739, 28740, 28741, 28742, 28743, 28744, 28756, 28757, 28758, 28759, 28760, 28761, 28762, 28763, 28764, 28765, 28766, 28767, 28768, 28780, 28781, 28782, 28783, 28784, 28785, 28786, 28787, 28788, 28789, 28790, 28791, 28792, 28804, 28805, 28806, 28807, 28808, 28809, 28810, 28811, 28812, 28813, 28814, 28815, 28816) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 398
      • 1: 1
      • 2: 28663
      • 3: 28664
      • 4: 28665
      • 5: 28666
      • 6: 28667
      • 7: 28668
      • 8: 28669
      • 9: 28670
      • 10: 28671
      • 11: 28672
      • 12: 28673
      • 13: 28674
      • 14: 28675
      • 15: 28686
      • 16: 28687
      • 17: 28688
      • 18: 28689
      • 19: 28690
      • 20: 28691
      • 21: 28692
      • 22: 28693
      • 23: 28694
      • 24: 28695
      • 25: 28696
      • 26: 28697
      • 27: 28698
      • 28: 28709
      • 29: 28710
      • 30: 28711
      • 31: 28712
      • 32: 28713
      • 33: 28714
      • 34: 28715
      • 35: 28716
      • 36: 28717
      • 37: 28718
      • 38: 28719
      • 39: 28720
      • 40: 28721
      • 41: 28732
      • 42: 28733
      • 43: 28734
      • 44: 28735
      • 45: 28736
      • 46: 28737
      • 47: 28738
      • 48: 28739
      • 49: 28740
      • 50: 28741
      • 51: 28742
      • 52: 28743
      • 53: 28744
      • 54: 28756
      • 55: 28757
      • 56: 28758
      • 57: 28759
      • 58: 28760
      • 59: 28761
      • 60: 28762
      • 61: 28763
      • 62: 28764
      • 63: 28765
      • 64: 28766
      • 65: 28767
      • 66: 28768
      • 67: 28780
      • 68: 28781
      • 69: 28782
      • 70: 28783
      • 71: 28784
      • 72: 28785
      • 73: 28786
      • 74: 28787
      • 75: 28788
      • 76: 28789
      • 77: 28790
      • 78: 28791
      • 79: 28792
      • 80: 28804
      • 81: 28805
      • 82: 28806
      • 83: 28807
      • 84: 28808
      • 85: 28809
      • 86: 28810
      • 87: 28811
      • 88: 28812
      • 89: 28813
      • 90: 28814
      • 91: 28815
      • 92: 28816
      • 93: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1882fpnstaging1.64msselect `id` from `fpn_tournaments` where `event_id` = 398 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 398
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1882
      • 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#1923fpnstaging27.68msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 398 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25296, 25297, 25298, 25323, 25324, 25325, 25349, 25350, 25351, 25375, 25376, 25377, 25401, 25402, 25427, 25428, 25453, 25454, 28652, 28653, 28654, 28655, 28656, 28657, 28658, 28659, 28660, 28661, 28662, 28676, 28677, 28678, 28679, 28680, 28681, 28682, 28683, 28684, 28685, 28699, 28700, 28701, 28702, 28703, 28704, 28705, 28706, 28707, 28708, 28722, 28723, 28724, 28725, 28726, 28727, 28728, 28729, 28730, 28731, 28745, 28746, 28747, 28748, 28749, 28750, 28751, 28752, 28753, 28754, 28755, 28769, 28770, 28771, 28772, 28773, 28774, 28775, 28776, 28777, 28778, 28779, 28793, 28794, 28795, 28796, 28797, 28798, 28799, 28800, 28801, 28802, 28803) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 398
      • 1: 1
      • 2: 25296
      • 3: 25297
      • 4: 25298
      • 5: 25323
      • 6: 25324
      • 7: 25325
      • 8: 25349
      • 9: 25350
      • 10: 25351
      • 11: 25375
      • 12: 25376
      • 13: 25377
      • 14: 25401
      • 15: 25402
      • 16: 25427
      • 17: 25428
      • 18: 25453
      • 19: 25454
      • 20: 28652
      • 21: 28653
      • 22: 28654
      • 23: 28655
      • 24: 28656
      • 25: 28657
      • 26: 28658
      • 27: 28659
      • 28: 28660
      • 29: 28661
      • 30: 28662
      • 31: 28676
      • 32: 28677
      • 33: 28678
      • 34: 28679
      • 35: 28680
      • 36: 28681
      • 37: 28682
      • 38: 28683
      • 39: 28684
      • 40: 28685
      • 41: 28699
      • 42: 28700
      • 43: 28701
      • 44: 28702
      • 45: 28703
      • 46: 28704
      • 47: 28705
      • 48: 28706
      • 49: 28707
      • 50: 28708
      • 51: 28722
      • 52: 28723
      • 53: 28724
      • 54: 28725
      • 55: 28726
      • 56: 28727
      • 57: 28728
      • 58: 28729
      • 59: 28730
      • 60: 28731
      • 61: 28745
      • 62: 28746
      • 63: 28747
      • 64: 28748
      • 65: 28749
      • 66: 28750
      • 67: 28751
      • 68: 28752
      • 69: 28753
      • 70: 28754
      • 71: 28755
      • 72: 28769
      • 73: 28770
      • 74: 28771
      • 75: 28772
      • 76: 28773
      • 77: 28774
      • 78: 28775
      • 79: 28776
      • 80: 28777
      • 81: 28778
      • 82: 28779
      • 83: 28793
      • 84: 28794
      • 85: 28795
      • 86: 28796
      • 87: 28797
      • 88: 28798
      • 89: 28799
      • 90: 28800
      • 91: 28801
      • 92: 28802
      • 93: 28803
      • 94: 1
      Backtrace
      • app/Models/League.php:1923
      • 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#1865fpnstaging960μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 264 limit 1
      Bindings
      • 0: 264
      Backtrace
      • app/Models/League.php:1865
      • 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#1870fpnstaging2.81msselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-06-12 10:05:42' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-06-12 10:05:42
      • 3: 1
      Backtrace
      • app/Models/League.php:1870
      • 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
    • fpnstaging1.07msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
    • fpnstaging20.3msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 1
    • fpnstaging1.56msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
    • fpnstaging12.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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 1
    App\Models\Season
    26Season.php#?
    App\Models\Promotion
    16Promotion.php#?
    App\Models\User
    1User.php#?
        • missed vVlQXAFSrwfxYOiMlIbnn8grpKto8zh9IP5negB3 (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 vVlQXAFSrwfxYOiMlIbnn8grpKto8zh9IP5negB3 (0μs)forget
        • 1 x missed vVlQXAFSrwfxYOiMlIbnn8grpKto8zh9IP5negB3 (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written vVlQXAFSrwfxYOiMlIbnn8grpKto8zh9IP5negB3 (0%)
          0μs
        _token
        4h66wfLHY9oGV8vAV08VIyqmuF9ixMwdlKn4xLrF
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/edgar-ogaz" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/edgar-ogaz
        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 => "Thu, 12 Jun 2025 15:05:42 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjMrQmUvN1k0T0JMQ24rN3NiSDNYYlE9PSIsInZhbHVlIjoiVnNCeTl0di93VmRQSG53cTJRQ1dmanlCVWxPU0kxd2hlNEtETlZoYVBqOWtOU0FIakJTWVVqTzNieDdUTXBTdG1WZEVma0hva2wrMHFndUhJYTQ0aVBSY2FMMEkySmFsZ1RwcC9jZEZER0RrMXN6RGlGVGlHc1pnd0F0YXFuWG8iLCJtYWMiOiJiZWNlNDkxMzkwMDJiNGQzMTQ3NjBlNjAxNTVhZDEyMjEyOWU3NTFjYTQzODNhMGY3MGI0NTk4YzUwOWE3NGU0IiwidGFnIjoiIn0%3D; expires=Fri, 12 Jun 2026 15:05:42 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjMrQmUvN1k0T0JMQ24rN3NiSDNYYlE9PSIsInZhbHVlIjoiVnNCeTl0di93VmRQSG53cTJRQ1dmanlCVWxPU0kxd2hlNEtETlZoYVBqOWtOU0FIakJTWVVqTzNieDdUTXBTdG1WZEVma" 1 => "freepokernetwork_upgrade_session=eyJpdiI6InpUWmF4djlwT1BxN3QxQVJpeGR5MVE9PSIsInZhbHVlIjoiNFJPMi9EbEF0aVg5bzh3Q2Qrb0tTU1Q0NFgyVXErOE05N052WC9PaEx5bk5VcVpGTkFtcnVxQ2diRlhwNmI0WXVNU0NXNGRuNExVMms5K1QyUnpDNUIzRHFmRHRYQTlva1pTV245QUFmRFpQVlQ4YS9JaU1kcEZnaXlyc2dJejMiLCJtYWMiOiJlNTliMGU3ZTczMjU2ZTlhMzg3MTNiMjA3MTc2NGYzODA4ZTlkM2IxOWI1OWViOThhZjA0YzU1NGQ0M2MyZmZjIiwidGFnIjoiIn0%3D; expires=Fri, 12 Jun 2026 15:05:42 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6InpUWmF4djlwT1BxN3QxQVJpeGR5MVE9PSIsInZhbHVlIjoiNFJPMi9EbEF0aVg5bzh3Q2Qrb0tTU1Q0NFgyVXErOE05N052WC9PaEx5bk5VcVpGTkFtcnV" 2 => "RSVP_status=eyJpdiI6InNHcmI5cjJYSVhYeE0yVXZydFlkQnc9PSIsInZhbHVlIjoidmFibmJnYVQ5dVgrZWFQZjRWNWx3dzdrQ0Rwb1RtZGNReE1UVWVHWXIvdHhTNjArYTJEb0svbEpnajBGMFNzTCIsIm1hYyI6ImZhNjE5YTlmOThkOTc0MTQ1MTNkZDQ2OGQ3NjhmYmVhNGI1Njc5N2JhMTYyZTA1MTYyZjJiNzZlODc0MjJhOTEiLCJ0YWciOiIifQ%3D%3D; expires=Sat, 13 Jun 2020 15:05:41 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6InNHcmI5cjJYSVhYeE0yVXZydFlkQnc9PSIsInZhbHVlIjoidmFibmJnYVQ5dVgrZWFQZjRWNWx3dzdrQ0Rwb1RtZGNReE1UVWVHWXIvdHhTNjArYTJEb0svbEpnajBGMFNzTCIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjMrQmUvN1k0T0JMQ24rN3NiSDNYYlE9PSIsInZhbHVlIjoiVnNCeTl0di93VmRQSG53cTJRQ1dmanlCVWxPU0kxd2hlNEtETlZoYVBqOWtOU0FIakJTWVVqTzNieDdUTXBTdG1WZEVma0hva2wrMHFndUhJYTQ0aVBSY2FMMEkySmFsZ1RwcC9jZEZER0RrMXN6RGlGVGlHc1pnd0F0YXFuWG8iLCJtYWMiOiJiZWNlNDkxMzkwMDJiNGQzMTQ3NjBlNjAxNTVhZDEyMjEyOWU3NTFjYTQzODNhMGY3MGI0NTk4YzUwOWE3NGU0IiwidGFnIjoiIn0%3D; expires=Fri, 12-Jun-2026 15:05:42 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjMrQmUvN1k0T0JMQ24rN3NiSDNYYlE9PSIsInZhbHVlIjoiVnNCeTl0di93VmRQSG53cTJRQ1dmanlCVWxPU0kxd2hlNEtETlZoYVBqOWtOU0FIakJTWVVqTzNieDdUTXBTdG1WZEVma" 1 => "freepokernetwork_upgrade_session=eyJpdiI6InpUWmF4djlwT1BxN3QxQVJpeGR5MVE9PSIsInZhbHVlIjoiNFJPMi9EbEF0aVg5bzh3Q2Qrb0tTU1Q0NFgyVXErOE05N052WC9PaEx5bk5VcVpGTkFtcnVxQ2diRlhwNmI0WXVNU0NXNGRuNExVMms5K1QyUnpDNUIzRHFmRHRYQTlva1pTV245QUFmRFpQVlQ4YS9JaU1kcEZnaXlyc2dJejMiLCJtYWMiOiJlNTliMGU3ZTczMjU2ZTlhMzg3MTNiMjA3MTc2NGYzODA4ZTlkM2IxOWI1OWViOThhZjA0YzU1NGQ0M2MyZmZjIiwidGFnIjoiIn0%3D; expires=Fri, 12-Jun-2026 15:05:42 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6InpUWmF4djlwT1BxN3QxQVJpeGR5MVE9PSIsInZhbHVlIjoiNFJPMi9EbEF0aVg5bzh3Q2Qrb0tTU1Q0NFgyVXErOE05N052WC9PaEx5bk5VcVpGTkFtcnV" 2 => "RSVP_status=eyJpdiI6InNHcmI5cjJYSVhYeE0yVXZydFlkQnc9PSIsInZhbHVlIjoidmFibmJnYVQ5dVgrZWFQZjRWNWx3dzdrQ0Rwb1RtZGNReE1UVWVHWXIvdHhTNjArYTJEb0svbEpnajBGMFNzTCIsIm1hYyI6ImZhNjE5YTlmOThkOTc0MTQ1MTNkZDQ2OGQ3NjhmYmVhNGI1Njc5N2JhMTYyZTA1MTYyZjJiNzZlODc0MjJhOTEiLCJ0YWciOiIifQ%3D%3D; expires=Sat, 13-Jun-2020 15:05:41 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6InNHcmI5cjJYSVhYeE0yVXZydFlkQnc9PSIsInZhbHVlIjoidmFibmJnYVQ5dVgrZWFQZjRWNWx3dzdrQ0Rwb1RtZGNReE1UVWVHWXIvdHhTNjArYTJEb0svbEpnajBGMFNzTCIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "4h66wfLHY9oGV8vAV08VIyqmuF9ixMwdlKn4xLrF" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/edgar-ogaz" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-12 10:05:42GET/player/edgar-ogaz1171044311