RJ

Roleen Johnson

Roleen Johnson

All Time Points : 20
|
Wins : 0

Tournaments Played : 1

Roleen Johnson

Tournament History

Roleen Johnson Highlighted in FPN News

No Records found

Videos

No Records found
Request history8.3.16PHP Version363msRequest Duration4MBMemory UsageGET player/{id}Route
  • warninglog[17:35:54] LOG.warning: Creation of dynamic property App\Http\Controllers\Site\LeaderBoardController...
  • Booting (54.43ms)time
  • Application (309ms)time
  • 1 x Application (85.02%)
    309ms
    1 x Booting (14.98%)
    54.43ms
    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
    23 statements were executed (2 duplicates)Show only duplicates221ms
    • PersonalInfoMiddleware.php#16fpnstagingConnection Established
      Backtrace
      • middleware::PersonalInfoMiddleware:16
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/CheckUserStatus.php:26
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/UpdateLastActivity.php:26
    • LeaderBoardController.php#239fpnstaging3.09msselect * from `users` where `alias` = 'roleen-johnson' limit 1
      Bindings
      • 0: roleen-johnson
      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.65msselect count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 11808 and `tournament_players`.`winnings` != 0)
      Bindings
      • 0: 11808
      • 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.53msselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 11808 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 11808
      • 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#175fpnstaging920μsselect count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 11808 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
      Bindings
      • 0: 11808
      • 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#187fpnstaging690μsselect count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 11808 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: 11808
      • 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.99msselect `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` = 11808) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11808
      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.02msselect 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` = 11808) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11808
      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.1msselect 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` = 11808) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11808
      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#196fpnstaging1.41msselect 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` = 11808) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11808
      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#196fpnstaging900μsselect 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` = 11808) limit 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 11808
      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#163fpnstaging29.24msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('11808',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#174fpnstaging53.78msselect * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('11808',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#176fpnstaging56.05msselect * from `articles` where find_in_set(11808, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
      Bindings
      • 0: 11808
      • 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#214fpnstaging950μ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.36msselect `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` = 11808 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: 11808
      • 4: 502
      Backtrace
      • app/Http/Controllers/Site/LeaderBoardController.php:304
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • League.php#1828fpnstaging2.44msselect `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` = 'roleen-johnson' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
      Bindings
      • 0: 1
      • 1: roleen-johnson
      • 2: 502
      • 3: 957
      • 4: 1212
      Backtrace
      • app/Models/League.php:1828
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1848fpnstaging1.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` = 'roleen-johnson' and `fpn_leagues`.`id` not in (502, 957, 1212) group by `fpn_leagues`.`id`
      Bindings
      • 0: 23
      • 1: 1
      • 2: roleen-johnson
      • 3: 502
      • 4: 957
      • 5: 1212
      Backtrace
      • app/Models/League.php:1848
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1857fpnstaging650μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 399 limit 1
      Bindings
      • 0: 399
      Backtrace
      • app/Models/League.php:1857
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1862fpnstaging970μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-06-15 17:35:54' and `status` = 1 order by `start_date` desc
      Bindings
      • 0: 15
      • 1: 16
      • 2: 2025-06-15 17:35:54
      • 3: 1
      Backtrace
      • app/Models/League.php:1862
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.16msselect `id` from `fpn_tournaments` where `event_id` = 399 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
      Bindings
      • 0: 399
      • 1: 2024-01-01 00:00:00
      • 2: 2024-03-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging31.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` = 399 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (28375, 28376, 28398, 28399, 28400, 28422, 28423, 28424, 28446, 28447, 28448, 28470, 28471, 28494, 28495, 28518, 28519, 32508, 32509, 32510, 32511, 32512, 32513, 32514, 32515, 32516, 32517, 32518, 32519, 32520, 32521, 32522, 32523, 32524, 32525, 32526, 32527, 32528, 32529, 32530, 32531, 32532, 32533, 32534, 32535, 32536, 32537, 32538, 32539, 32540, 32541, 32542, 32543, 32544, 32545, 32546, 32547, 32548, 32549, 32550, 32551, 32552, 32553, 32554, 32555, 32556, 32557, 32558, 32559, 32560, 32561, 32562, 32563, 32564, 32565, 32566, 32567, 32568, 32569, 32570, 32571, 32572, 32573, 32574, 32575, 32576, 32577, 32578, 32579, 32580, 32581, 32582) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 399
      • 1: 1
      • 2: 28375
      • 3: 28376
      • 4: 28398
      • 5: 28399
      • 6: 28400
      • 7: 28422
      • 8: 28423
      • 9: 28424
      • 10: 28446
      • 11: 28447
      • 12: 28448
      • 13: 28470
      • 14: 28471
      • 15: 28494
      • 16: 28495
      • 17: 28518
      • 18: 28519
      • 19: 32508
      • 20: 32509
      • 21: 32510
      • 22: 32511
      • 23: 32512
      • 24: 32513
      • 25: 32514
      • 26: 32515
      • 27: 32516
      • 28: 32517
      • 29: 32518
      • 30: 32519
      • 31: 32520
      • 32: 32521
      • 33: 32522
      • 34: 32523
      • 35: 32524
      • 36: 32525
      • 37: 32526
      • 38: 32527
      • 39: 32528
      • 40: 32529
      • 41: 32530
      • 42: 32531
      • 43: 32532
      • 44: 32533
      • 45: 32534
      • 46: 32535
      • 47: 32536
      • 48: 32537
      • 49: 32538
      • 50: 32539
      • 51: 32540
      • 52: 32541
      • 53: 32542
      • 54: 32543
      • 55: 32544
      • 56: 32545
      • 57: 32546
      • 58: 32547
      • 59: 32548
      • 60: 32549
      • 61: 32550
      • 62: 32551
      • 63: 32552
      • 64: 32553
      • 65: 32554
      • 66: 32555
      • 67: 32556
      • 68: 32557
      • 69: 32558
      • 70: 32559
      • 71: 32560
      • 72: 32561
      • 73: 32562
      • 74: 32563
      • 75: 32564
      • 76: 32565
      • 77: 32566
      • 78: 32567
      • 79: 32568
      • 80: 32569
      • 81: 32570
      • 82: 32571
      • 83: 32572
      • 84: 32573
      • 85: 32574
      • 86: 32575
      • 87: 32576
      • 88: 32577
      • 89: 32578
      • 90: 32579
      • 91: 32580
      • 92: 32581
      • 93: 32582
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1874fpnstaging1.96msselect `id` from `fpn_tournaments` where `event_id` = 399 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
      Bindings
      • 0: 399
      • 1: 2023-10-01 00:00:00
      • 2: 2023-12-31 00:00:00
      Backtrace
      • app/Models/League.php:1874
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • League.php#1915fpnstaging25.91msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 399 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25479, 25480, 25481, 25506, 25507, 25508, 25532, 25533, 25558, 25559, 25584, 25585, 25610, 25611, 25636, 25637, 28364, 28365, 28366, 28367, 28368, 28369, 28370, 28371, 28372, 28373, 28374, 28388, 28389, 28390, 28391, 28392, 28393, 28394, 28395, 28396, 28397, 28411, 28412, 28413, 28414, 28415, 28416, 28417, 28418, 28419, 28420, 28421, 28435, 28436, 28437, 28438, 28439, 28440, 28441, 28442, 28443, 28444, 28445, 28459, 28460, 28461, 28462, 28463, 28464, 28465, 28466, 28467, 28468, 28469, 28483, 28484, 28485, 28486, 28487, 28488, 28489, 28490, 28491, 28492, 28493, 28507, 28508, 28509, 28510, 28511, 28512, 28513, 28514, 28515, 28516, 28517) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
      Bindings
      • 0: 399
      • 1: 1
      • 2: 25479
      • 3: 25480
      • 4: 25481
      • 5: 25506
      • 6: 25507
      • 7: 25508
      • 8: 25532
      • 9: 25533
      • 10: 25558
      • 11: 25559
      • 12: 25584
      • 13: 25585
      • 14: 25610
      • 15: 25611
      • 16: 25636
      • 17: 25637
      • 18: 28364
      • 19: 28365
      • 20: 28366
      • 21: 28367
      • 22: 28368
      • 23: 28369
      • 24: 28370
      • 25: 28371
      • 26: 28372
      • 27: 28373
      • 28: 28374
      • 29: 28388
      • 30: 28389
      • 31: 28390
      • 32: 28391
      • 33: 28392
      • 34: 28393
      • 35: 28394
      • 36: 28395
      • 37: 28396
      • 38: 28397
      • 39: 28411
      • 40: 28412
      • 41: 28413
      • 42: 28414
      • 43: 28415
      • 44: 28416
      • 45: 28417
      • 46: 28418
      • 47: 28419
      • 48: 28420
      • 49: 28421
      • 50: 28435
      • 51: 28436
      • 52: 28437
      • 53: 28438
      • 54: 28439
      • 55: 28440
      • 56: 28441
      • 57: 28442
      • 58: 28443
      • 59: 28444
      • 60: 28445
      • 61: 28459
      • 62: 28460
      • 63: 28461
      • 64: 28462
      • 65: 28463
      • 66: 28464
      • 67: 28465
      • 68: 28466
      • 69: 28467
      • 70: 28468
      • 71: 28469
      • 72: 28483
      • 73: 28484
      • 74: 28485
      • 75: 28486
      • 76: 28487
      • 77: 28488
      • 78: 28489
      • 79: 28490
      • 80: 28491
      • 81: 28492
      • 82: 28493
      • 83: 28507
      • 84: 28508
      • 85: 28509
      • 86: 28510
      • 87: 28511
      • 88: 28512
      • 89: 28513
      • 90: 28514
      • 91: 28515
      • 92: 28516
      • 93: 28517
      • 94: 1
      Backtrace
      • app/Models/League.php:1915
      • app/Http/Controllers/Site/LeaderBoardController.php:308
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    App\Models\Season
    2Season.php#?
    App\Models\User
    1User.php#?
    App\Models\Promotion
    1Promotion.php#?
        • missed EnZSPy8stSxfEGNe0j2Sm2YBTwDiveZz7AIOAJTh (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 EnZSPy8stSxfEGNe0j2Sm2YBTwDiveZz7AIOAJTh (0μs)forget
        • 1 x missed EnZSPy8stSxfEGNe0j2Sm2YBTwDiveZz7AIOAJTh (0%)
          0μs
          9 x hit c_config (0%)
          0μs
          1 x written EnZSPy8stSxfEGNe0j2Sm2YBTwDiveZz7AIOAJTh (0%)
          0μs
        _token
        8ZCQAYaiH5BdqG5oqnaSeWruSfVHonPwpifBL8z2
        _previous
        array:1 [ "url" => "https://staging.freepokernetwork.com/player/roleen-johnson" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /player/roleen-johnson
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 15 Jun 2025 22:35:54 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhjMXV1QXJKdmcrT1p3MFp1bXVKSFE9PSIsInZhbHVlIjoiZlJpbkQrWFExREhZZE81MFVNaWZTT1J2bFAwYzNEbCtPVGZTd3l2NkM0b2k3bW14djZDKzJObG43WW0vYStuVjQweDZ3R3IxSDlGZ0wwa3Ura0E2LzFqbjd4WXIvTVBlblNXd1gzRDVCQlVLdlhxbUhZZHdYZ1pUVXFUbC9XcUEiLCJtYWMiOiJkMjkwNjVhODkyNmVjZjdlOTNhZGM0Nzk1MGQ5YmY1ZDEwNDk3M2U5MzhiYWQ4ZGZkZTYwY2U5NWU0ZWZmODdmIiwidGFnIjoiIn0%3D; expires=Mon, 15 Jun 2026 22:35:54 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjhjMXV1QXJKdmcrT1p3MFp1bXVKSFE9PSIsInZhbHVlIjoiZlJpbkQrWFExREhZZE81MFVNaWZTT1J2bFAwYzNEbCtPVGZTd3l2NkM0b2k3bW14djZDKzJObG43WW0vYStuVjQweDZ3R" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ik9KdGt1dGFvTHJEMnNwRi9KQWhCd1E9PSIsInZhbHVlIjoiWTRyV1RYYWdlMjFQRm9COE5UOWk3R2lOdnlXaVdTWDhrSjVGQ1FNb2JLTXI0V3lYQi9HQ1hYWmxJWTFXWUs5OWtuRnJ2QS8vcHlmMmdQcFo1MVBxSjJHR1gvRjBubnZhYUEyczRYcEhGY1l5cHBUdERXZWhkcGhkZVZlZ2pOQWoiLCJtYWMiOiI4ZmMzYmJlMThmZTkzNzZmNTRhMmEwZTU5NzYwNjM5MTBmNjczMDliMjUyMDM1MjYxOWFlMDdlNjA4ODIyYzA3IiwidGFnIjoiIn0%3D; expires=Mon, 15 Jun 2026 22:35:54 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6Ik9KdGt1dGFvTHJEMnNwRi9KQWhCd1E9PSIsInZhbHVlIjoiWTRyV1RYYWdlMjFQRm9COE5UOWk3R2lOdnlXaVdTWDhrSjVGQ1FNb2JLTXI0V3lYQi9HQ1h" 2 => "RSVP_status=eyJpdiI6IjlsTWpOY0M5QnRBYzVNL2VQaW9UeFE9PSIsInZhbHVlIjoib0NTdnhoV0hLTTZuRmhHdThaMXpQOUtHazRYK3lRSVNibHh4NlowWjQycFFRY0l6bUlyR0M2TFEvcW9OdW04SSIsIm1hYyI6ImI3Nzg3MGQ3ZWIzMzBmMGEwY2IxOWJiNjY4NzdhODcwYTFkNTI3Nzc3NjJlODNlODQ1ZTM2NThhMzJlNjU4ZDciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 16 Jun 2020 22:35:54 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6IjlsTWpOY0M5QnRBYzVNL2VQaW9UeFE9PSIsInZhbHVlIjoib0NTdnhoV0hLTTZuRmhHdThaMXpQOUtHazRYK3lRSVNibHh4NlowWjQycFFRY0l6bUlyR0M2TFEvcW9OdW04SSIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhjMXV1QXJKdmcrT1p3MFp1bXVKSFE9PSIsInZhbHVlIjoiZlJpbkQrWFExREhZZE81MFVNaWZTT1J2bFAwYzNEbCtPVGZTd3l2NkM0b2k3bW14djZDKzJObG43WW0vYStuVjQweDZ3R3IxSDlGZ0wwa3Ura0E2LzFqbjd4WXIvTVBlblNXd1gzRDVCQlVLdlhxbUhZZHdYZ1pUVXFUbC9XcUEiLCJtYWMiOiJkMjkwNjVhODkyNmVjZjdlOTNhZGM0Nzk1MGQ5YmY1ZDEwNDk3M2U5MzhiYWQ4ZGZkZTYwY2U5NWU0ZWZmODdmIiwidGFnIjoiIn0%3D; expires=Mon, 15-Jun-2026 22:35:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjhjMXV1QXJKdmcrT1p3MFp1bXVKSFE9PSIsInZhbHVlIjoiZlJpbkQrWFExREhZZE81MFVNaWZTT1J2bFAwYzNEbCtPVGZTd3l2NkM0b2k3bW14djZDKzJObG43WW0vYStuVjQweDZ3R" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ik9KdGt1dGFvTHJEMnNwRi9KQWhCd1E9PSIsInZhbHVlIjoiWTRyV1RYYWdlMjFQRm9COE5UOWk3R2lOdnlXaVdTWDhrSjVGQ1FNb2JLTXI0V3lYQi9HQ1hYWmxJWTFXWUs5OWtuRnJ2QS8vcHlmMmdQcFo1MVBxSjJHR1gvRjBubnZhYUEyczRYcEhGY1l5cHBUdERXZWhkcGhkZVZlZ2pOQWoiLCJtYWMiOiI4ZmMzYmJlMThmZTkzNzZmNTRhMmEwZTU5NzYwNjM5MTBmNjczMDliMjUyMDM1MjYxOWFlMDdlNjA4ODIyYzA3IiwidGFnIjoiIn0%3D; expires=Mon, 15-Jun-2026 22:35:54 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6Ik9KdGt1dGFvTHJEMnNwRi9KQWhCd1E9PSIsInZhbHVlIjoiWTRyV1RYYWdlMjFQRm9COE5UOWk3R2lOdnlXaVdTWDhrSjVGQ1FNb2JLTXI0V3lYQi9HQ1h" 2 => "RSVP_status=eyJpdiI6IjlsTWpOY0M5QnRBYzVNL2VQaW9UeFE9PSIsInZhbHVlIjoib0NTdnhoV0hLTTZuRmhHdThaMXpQOUtHazRYK3lRSVNibHh4NlowWjQycFFRY0l6bUlyR0M2TFEvcW9OdW04SSIsIm1hYyI6ImI3Nzg3MGQ3ZWIzMzBmMGEwY2IxOWJiNjY4NzdhODcwYTFkNTI3Nzc3NjJlODNlODQ1ZTM2NThhMzJlNjU4ZDciLCJ0YWciOiIifQ%3D%3D; expires=Tue, 16-Jun-2020 22:35:54 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6IjlsTWpOY0M5QnRBYzVNL2VQaW9UeFE9PSIsInZhbHVlIjoib0NTdnhoV0hLTTZuRmhHdThaMXpQOUtHazRYK3lRSVNibHh4NlowWjQycFFRY0l6bUlyR0M2TFEvcW9OdW04SSIsIm1h" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "8ZCQAYaiH5BdqG5oqnaSeWruSfVHonPwpifBL8z2" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/player/roleen-johnson" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-15 17:35:54GET/player/roleen-johnson11723411