RC

Robert Carmichael

Robert Carmichael

All Time Points : 848
|
Wins : 0

Tournaments Played : 16

Robert Carmichael

Tournament History

Robert Carmichael Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version604msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[01:41:06] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (64.39ms)time
  • Application (540ms)time
  • 1 x Application (89.34%)
    540ms
    1 x Booting (10.66%)
    64.39ms
    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
    48 statements were executed (9 duplicates)Show only duplicates385ms
    • 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.77msselect * from `users` where `alias` = 'robert-carmichael' limit 1
      Bindings
      • 0: robert-carmichael
      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.93msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 19056 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 19056
      • 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.15msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 19056 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 19056
      • 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` = 19056 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 19056
      • 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#187fpnstaging2.12msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 19056 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: 19056
      • 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#189fpnstaging3msselect `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` = 19056) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 19056
      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#195fpnstaging1.9msselect 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` = 19056) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 19056
      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#195fpnstaging1.92msselect 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` = 19056) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 19056
      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#196fpnstaging5.96msselect 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` = 19056) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 19056
      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#196fpnstaging4.79msselect 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` = 19056) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 19056
      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#163fpnstaging43.9msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('19056',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#174fpnstaging89.06msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('19056',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#176fpnstaging85.38msselect * from `articles` where find_in_set(19056, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 19056
      • 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#214fpnstaging940μ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` = 19056 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: 19056
      • 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.1msselect `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` = 'robert-carmichael' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: robert-carmichael
      • 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.05msselect `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` = 'robert-carmichael' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 26
      • 1: 1
      • 2: robert-carmichael
      • 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#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` = 1089 limit 1
      Bindings
      • 0: 1089
      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 ('21', '22') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-10 01:41:06
      • 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#1865fpnstaging800μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1075 limit 1
      Bindings
      • 0: 1075
      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#1870fpnstaging730μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-10 01:41:06
      • 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#1865fpnstaging1.52msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1127 limit 1
      Bindings
      • 0: 1127
      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#1870fpnstaging730μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 21
      • 1: 22
      • 2: 2025-06-10 01:41:06
      • 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#1856fpnstaging1.85msselect `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` = 'robert-carmichael' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 25
      • 1: 1
      • 2: robert-carmichael
      • 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#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` = 862 limit 1
      Bindings
      • 0: 862
      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#1870fpnstaging1.22msselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-10 01:41:06
      • 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.24msselect `id` from `fpn_tournaments` where `event_id` = 862 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 862
      • 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#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` = 862 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (51897, 51898, 51899, 51900, 51901, 51902, 51903, 51904, 51905, 51906, 51907, 51908, 51909) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 862
      • 1: 1
      • 2: 51897
      • 3: 51898
      • 4: 51899
      • 5: 51900
      • 6: 51901
      • 7: 51902
      • 8: 51903
      • 9: 51904
      • 10: 51905
      • 11: 51906
      • 12: 51907
      • 13: 51908
      • 14: 51909
      • 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.1msselect `id` from `fpn_tournaments` where `event_id` = 862 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 862
      • 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#1923fpnstaging11.24msselect `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` = 862 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (51884, 51885, 51886, 51887, 51888, 51889, 51890, 51891, 51892, 51893, 51894, 51895, 51896) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 862
      • 1: 1
      • 2: 51884
      • 3: 51885
      • 4: 51886
      • 5: 51887
      • 6: 51888
      • 7: 51889
      • 8: 51890
      • 9: 51891
      • 10: 51892
      • 11: 51893
      • 12: 51894
      • 13: 51895
      • 14: 51896
      • 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#1865fpnstaging870μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 819 limit 1
      Bindings
      • 0: 819
      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#1870fpnstaging1.2msselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-10 01:41:06
      • 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` = 819 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 819
      • 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.19msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 819 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50520, 50521, 50522, 50523, 50524, 50525, 50526, 50527, 50528, 50529, 50530, 50531) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 819
      • 1: 1
      • 2: 50520
      • 3: 50521
      • 4: 50522
      • 5: 50523
      • 6: 50524
      • 7: 50525
      • 8: 50526
      • 9: 50527
      • 10: 50528
      • 11: 50529
      • 12: 50530
      • 13: 50531
      • 14: 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#1882fpnstaging980μsselect `id` from `fpn_tournaments` where `event_id` = 819 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 819
      • 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#1923fpnstaging17.65msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 819 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (50506, 50507, 50508, 50509, 50510, 50511, 50512, 50513, 50514, 50515, 50516, 50517, 50518, 50519) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 819
      • 1: 1
      • 2: 50506
      • 3: 50507
      • 4: 50508
      • 5: 50509
      • 6: 50510
      • 7: 50511
      • 8: 50512
      • 9: 50513
      • 10: 50514
      • 11: 50515
      • 12: 50516
      • 13: 50517
      • 14: 50518
      • 15: 50519
      • 16: 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#1865fpnstaging850μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 934 limit 1
      Bindings
      • 0: 934
      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#1870fpnstaging730μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-10 01:41:06
      • 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#1882fpnstaging1msselect `id` from `fpn_tournaments` where `event_id` = 934 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 934
      • 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#1923fpnstaging9.7msselect `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` = 934 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (58384, 58385, 58386, 58387, 58388, 58389, 58390, 58391, 58392, 58393, 58394, 58395, 58396) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 934
      • 1: 1
      • 2: 58384
      • 3: 58385
      • 4: 58386
      • 5: 58387
      • 6: 58388
      • 7: 58389
      • 8: 58390
      • 9: 58391
      • 10: 58392
      • 11: 58393
      • 12: 58394
      • 13: 58395
      • 14: 58396
      • 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.11msselect `id` from `fpn_tournaments` where `event_id` = 934 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 934
      • 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.36msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 934 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (58371, 58372, 58373, 58374, 58375, 58376, 58377, 58378, 58379, 58380, 58381, 58382, 58383) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 934
      • 1: 1
      • 2: 58371
      • 3: 58372
      • 4: 58373
      • 5: 58374
      • 6: 58375
      • 7: 58376
      • 8: 58377
      • 9: 58378
      • 10: 58379
      • 11: 58380
      • 12: 58381
      • 13: 58382
      • 14: 58383
      • 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.33msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 804 limit 1
      Bindings
      • 0: 804
      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#1870fpnstaging850μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-06-10 01:41:06' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 19
      • 1: 20
      • 2: 2025-06-10 01:41:06
      • 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.75msselect `id` from `fpn_tournaments` where `event_id` = 804 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
      Bindings
      • 0: 804
      • 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#1923fpnstaging21.57msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 804 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (49999, 50000, 50001, 50002, 50003, 50004, 50005, 50006, 50007, 50008, 50009, 50010, 50011) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 804
      • 1: 1
      • 2: 49999
      • 3: 50000
      • 4: 50001
      • 5: 50002
      • 6: 50003
      • 7: 50004
      • 8: 50005
      • 9: 50006
      • 10: 50007
      • 11: 50008
      • 12: 50009
      • 13: 50010
      • 14: 50011
      • 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#1882fpnstaging920μsselect `id` from `fpn_tournaments` where `event_id` = 804 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
      Bindings
      • 0: 804
      • 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#1923fpnstaging16.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` = 804 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (49986, 49987, 49988, 49989, 49990, 49991, 49992, 49993, 49994, 49995, 49996, 49997, 49998) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 804
      • 1: 1
      • 2: 49986
      • 3: 49987
      • 4: 49988
      • 5: 49989
      • 6: 49990
      • 7: 49991
      • 8: 49992
      • 9: 49993
      • 10: 49994
      • 11: 49995
      • 12: 49996
      • 13: 49997
      • 14: 49998
      • 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
    App\Models\Season
    8Season.php#?
    App\Models\Promotion
    7Promotion.php#?
    App\Models\User
    1User.php#?
        • missed 3P3Yu9EA7fp9lpB6D2muqw0btaA2LFnMYkGhlftO (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 3P3Yu9EA7fp9lpB6D2muqw0btaA2LFnMYkGhlftO (0μs)forget
        • 1 x missed 3P3Yu9EA7fp9lpB6D2muqw0btaA2LFnMYkGhlftO (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written 3P3Yu9EA7fp9lpB6D2muqw0btaA2LFnMYkGhlftO (0%)
          0μs
        _token
        ppZavt1i6gQurKdJlQyNU1gG6zAox8jxXIEhTMJa
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/robert-carmichael" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/robert-carmichael
        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 => "Tue, 10 Jun 2025 06:41:06 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6InhTN0tFU2Jmb05LUnFqcUkrcksxRUE9PSIsInZhbHVlIjoibHdmYnkrZVJjTmhQZHpUTHV3eWg4bFdwM01oUkhVYmUxY3dYT3pZM2dTN2xMajhJcWdEVjZTakFZNVpJV2d6c0RnaDRDbFROTEpxZXdTeWJDdzlHY3RpSkxrbTlqWHNmYjdkN2szY05yUml2L2pQQVZrZDhyNEhQdmMwaXJYUUUiLCJtYWMiOiJhOTJmNzlmMzFmMmYxYjczODQ2ZDliYjgyZmY1ZjA0MTFlNWNiY2YxOTAxMGZjYTNkNjBmYjk3NGIwYzNiYWI4IiwidGFnIjoiIn0%3D; expires=Wed, 10 Jun 2026 06:41:06 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InhTN0tFU2Jmb05LUnFqcUkrcksxRUE9PSIsInZhbHVlIjoibHdmYnkrZVJjTmhQZHpUTHV3eWg4bFdwM01oUkhVYmUxY3dYT3pZM2dTN2xMajhJcWdEVjZTakFZNVpJV2d6c0RnaDRDb" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ii9VU3hzL0pZN1RIbUJMak9GbTd6VGc9PSIsInZhbHVlIjoibWRwMW0zQk9uTVA1cUlmYjArb0pRSm5NQlZxTUlXS2s3MDR6cHBMN0JTWjJWa1B2OWl1Z2FQMk1LaXl0NFhCVjdHYTVoMm9wWTZlWmFESFFtcThLS2RrRmpVOTBzdUc5dTlXYUcvQ2hUdldTVks5cVk5blJMenNoR0FpNGxmdlkiLCJtYWMiOiIxY2IzNDUwM2Y5MjQ5ZWUzNDdlNjFlZDUyMTJjMTc4MjMyYTVjZDVhMDBiYjk0MDFmN2ViNDliYzI4ODZlMzE3IiwidGFnIjoiIn0%3D; expires=Wed, 10 Jun 2026 06:41:06 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6Ii9VU3hzL0pZN1RIbUJMak9GbTd6VGc9PSIsInZhbHVlIjoibWRwMW0zQk9uTVA1cUlmYjArb0pRSm5NQlZxTUlXS2s3MDR6cHBMN0JTWjJWa1B2OWl1Z2F" 2 => "RSVP_status=eyJpdiI6InRLa1lJWWMxNWVBL2g1OEV5N0x6cHc9PSIsInZhbHVlIjoiVGFyR2VXTTlRbFA4TFJBMUpMRE1uYmJwQzdydlpGYmpwdzRocHMrUHRucE5zNHFKWkY2OWRsWkVVZXRRdk92ZiIsIm1hYyI6IjViMjQ2MGFjN2U4MTJjYzU4ODdmMjc5YzE3ZmMyNTY0YmVhNjIwZDRiZTBlYTI1ZWM4MmE3Yzg4ZDlhYzg0MDEiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 11 Jun 2020 06:41:06 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6InRLa1lJWWMxNWVBL2g1OEV5N0x6cHc9PSIsInZhbHVlIjoiVGFyR2VXTTlRbFA4TFJBMUpMRE1uYmJwQzdydlpGYmpwdzRocHMrUHRucE5zNHFKWkY2OWRsWkVVZXRRdk92ZiIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6InhTN0tFU2Jmb05LUnFqcUkrcksxRUE9PSIsInZhbHVlIjoibHdmYnkrZVJjTmhQZHpUTHV3eWg4bFdwM01oUkhVYmUxY3dYT3pZM2dTN2xMajhJcWdEVjZTakFZNVpJV2d6c0RnaDRDbFROTEpxZXdTeWJDdzlHY3RpSkxrbTlqWHNmYjdkN2szY05yUml2L2pQQVZrZDhyNEhQdmMwaXJYUUUiLCJtYWMiOiJhOTJmNzlmMzFmMmYxYjczODQ2ZDliYjgyZmY1ZjA0MTFlNWNiY2YxOTAxMGZjYTNkNjBmYjk3NGIwYzNiYWI4IiwidGFnIjoiIn0%3D; expires=Wed, 10-Jun-2026 06:41:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InhTN0tFU2Jmb05LUnFqcUkrcksxRUE9PSIsInZhbHVlIjoibHdmYnkrZVJjTmhQZHpUTHV3eWg4bFdwM01oUkhVYmUxY3dYT3pZM2dTN2xMajhJcWdEVjZTakFZNVpJV2d6c0RnaDRDb" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ii9VU3hzL0pZN1RIbUJMak9GbTd6VGc9PSIsInZhbHVlIjoibWRwMW0zQk9uTVA1cUlmYjArb0pRSm5NQlZxTUlXS2s3MDR6cHBMN0JTWjJWa1B2OWl1Z2FQMk1LaXl0NFhCVjdHYTVoMm9wWTZlWmFESFFtcThLS2RrRmpVOTBzdUc5dTlXYUcvQ2hUdldTVks5cVk5blJMenNoR0FpNGxmdlkiLCJtYWMiOiIxY2IzNDUwM2Y5MjQ5ZWUzNDdlNjFlZDUyMTJjMTc4MjMyYTVjZDVhMDBiYjk0MDFmN2ViNDliYzI4ODZlMzE3IiwidGFnIjoiIn0%3D; expires=Wed, 10-Jun-2026 06:41:06 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6Ii9VU3hzL0pZN1RIbUJMak9GbTd6VGc9PSIsInZhbHVlIjoibWRwMW0zQk9uTVA1cUlmYjArb0pRSm5NQlZxTUlXS2s3MDR6cHBMN0JTWjJWa1B2OWl1Z2F" 2 => "RSVP_status=eyJpdiI6InRLa1lJWWMxNWVBL2g1OEV5N0x6cHc9PSIsInZhbHVlIjoiVGFyR2VXTTlRbFA4TFJBMUpMRE1uYmJwQzdydlpGYmpwdzRocHMrUHRucE5zNHFKWkY2OWRsWkVVZXRRdk92ZiIsIm1hYyI6IjViMjQ2MGFjN2U4MTJjYzU4ODdmMjc5YzE3ZmMyNTY0YmVhNjIwZDRiZTBlYTI1ZWM4MmE3Yzg4ZDlhYzg0MDEiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 11-Jun-2020 06:41:06 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6InRLa1lJWWMxNWVBL2g1OEV5N0x6cHc9PSIsInZhbHVlIjoiVGFyR2VXTTlRbFA4TFJBMUpMRE1uYmJwQzdydlpGYmpwdzRocHMrUHRucE5zNHFKWkY2OWRsWkVVZXRRdk92ZiIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "ppZavt1i6gQurKdJlQyNU1gG6zAox8jxXIEhTMJa" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/robert-carmichael" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-10 01:41:06GET/player/robert-carmichael117481611