3
Avg. Attendees
League Inactive
Past Season: Fall 2024
1396 Points
League Champ
Past Season: Summer 2024
2203 Points
League Champ
Past Season: Spring 2024
2061 Points
League Champ
Past Season: Winter 2024
1463 Points
League Champ

Venue

1020 Eisenhower Blvd, Johnstown, PA 15904, USA, Johnstown, PA, 15904
Request history8.3.16PHP Version749msRequest Duration8MBMemory UsageGET venues/{alias}Route
    • Booting (40.43ms)time
    • Application (708ms)time
    • 1 x Application (94.6%)
      708ms
      1 x Booting (5.4%)
      40.43ms
      39 templates were rendered
      • site.league.indexindex.blade.php#?blade
      • site.includes.home_become_a_host_section_content_defaulthome_become_a_host_section_content_default.blade.php#?blade
      • components.site.breadcrumb-itembreadcrumb-item.blade.php#?blade
      • components.site.breadcrumbsbreadcrumbs.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • site.includes.qualifier_tournamentsqualifier_tournaments.blade.php#?blade
      • site.includes.qualifier_tournaments.multiple_qualifiersmultiple_qualifiers.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • site.includes.social_sharesocial_share.blade.php#?blade
      • site.league.index_gridindex_grid.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-background-imagelazyload-background-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • site.includes.social_sharesocial_share.blade.php#?blade
      • site.includes.social_sharesocial_share.blade.php#?blade
      • site.includes.venue_map_locationvenue_map_location.blade.php#?blade
      • site.articles.card.right_section_related_newsright_section_related_news.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • components.lazyload-imagelazyload-image.blade.php#?blade
      • site.layouts.appapp.blade.php#?blade
      • site.includes.headerheader.blade.php#?blade
      • flash::messagemessage.blade.php#?blade
      • site.includes.code_of_conductcode_of_conduct.blade.php#?blade
      • site.includes.footerfooter.blade.php#?blade
      • site.includes.footer_modules.dpt_infodpt_info.blade.php#?blade
      • site.includes.footer_modules.social_mediasocial_media.blade.php#?blade
      • site.includes.footer_modules.about_dptabout_dpt.blade.php#?blade
      • site.includes.footer_modules.quick_linkquick_link.blade.php#?blade
      • site.includes.footer_modules.fpn_contactfpn_contact.blade.php#?blade
      • site.includes.footer_modules.copyrightcopyright.blade.php#?blade
      uri
      GET venues/{alias}
      middleware
      web, PersonalInfoMiddleware
      controller
      App\Http\Controllers\Site\LeagueController@index
      as
      site.venues.show
      namespace
      prefix
      where
      file
      app/Http/Controllers/Site/LeagueController.php:52-246
      103 statements were executed (15 duplicates)Show only duplicatesfpnstaging541ms
      • # Query soft limit for Debugbar is reached after 100 queries, additional 3 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
      • League.php#786fpnstaging9.95msselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-02' order by `start_date` asc
        Bindings
        • 0: 2025-05-02
        Backtrace
        • app/Models/League.php:786
        • app/Http/Controllers/Site/LeagueController.php:58
        • vendor/laravel/framework/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#793fpnstaging6.56msselect * from `fpn_promotions` where FIND_IN_SET(21, season_id) limit 1
        Bindings
        • 0: 21
        Backtrace
        • app/Models/League.php:793
        • app/Http/Controllers/Site/LeagueController.php:58
        • vendor/laravel/framework/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#793fpnstaging7.03msselect * from `fpn_promotions` where FIND_IN_SET(22, season_id) limit 1
        Bindings
        • 0: 22
        Backtrace
        • app/Models/League.php:793
        • app/Http/Controllers/Site/LeagueController.php:58
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#62fpnstaging1.91msselect * from `fpn_venues` where `status` = '1' and `alias` = 'pappy-s-family-pub' limit 1
        Bindings
        • 0: 1
        • 1: pappy-s-family-pub
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:62
        • vendor/laravel/framework/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
      • LeagueController.php#70fpnstaging490μsselect count(*) as aggregate from `fpn_leagues` where `venue_id` = 236
        Bindings
        • 0: 236
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:70
        • vendor/laravel/framework/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
      • QualifierService.php#200fpnstaging106msselect `fpn_tournaments`.`id`, `fpn_tournaments`.`qualifier_types`, `fpn_tournaments`.`alias`, `fpn_tournaments`.`name`, `fpn_tournaments`.`start_date`, `fpn_tournaments`.`qualifier_total_reg_players`, `fpn_tournaments`.`qualifiers_playoff`, `fpn_tournaments`.`venue_id`, `fpn_tournaments`.`qualifier_types`, `fpn_tournaments`.`qualifier_promotion_ids`, `fpn_venues`.`name` as `venue_name`, `fpn_venues`.`alias` as `venue_alias` from `fpn_tournaments` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where `qualifiers_playoff` = 1 and `fpn_tournaments`.`status` = 1 and FIND_IN_SET('236', filter_qualifier_venue_ids) order by `start_date` desc
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Services/QualifierService.php:200
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/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#55fpnstaging710μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = '24' limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Services/ConfigSevice.php:55
        • app/Services/QualifierService.php:230
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#95fpnstaging550μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = '24' limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Services/ConfigSevice.php:95
        • app/Services/QualifierService.php:231
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • QualifierService.php#252fpnstaging1.24msselect `users`.`id`, `users`.`first_name`, `users`.`avatar`, `users`.`last_name`, `users`.`alias`, `tournament_players`.`score` from `tournament_players` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `tournament_id` = 57171 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 57171
        • 1: 1
        • 2: 1
        Backtrace
        • app/Services/QualifierService.php:252
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/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#55fpnstaging430μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = '23' limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Services/ConfigSevice.php:55
        • app/Services/QualifierService.php:230
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#95fpnstaging500μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = '23' limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Services/ConfigSevice.php:95
        • app/Services/QualifierService.php:231
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • QualifierService.php#252fpnstaging850μsselect `users`.`id`, `users`.`first_name`, `users`.`avatar`, `users`.`last_name`, `users`.`alias`, `tournament_players`.`score` from `tournament_players` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `tournament_id` = 33646 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 33646
        • 1: 1
        • 2: 1
        Backtrace
        • app/Services/QualifierService.php:252
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/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#786fpnstaging830μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-02' order by `start_date` asc
        Bindings
        • 0: 2025-05-02
        Backtrace
        • app/Models/League.php:786
        • app/Models/League.php:818
        • app/Services/LeagueSevice.php:21
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#793fpnstaging7.03msselect * from `fpn_promotions` where FIND_IN_SET(21, season_id) limit 1
        Bindings
        • 0: 21
        Backtrace
        • app/Models/League.php:793
        • app/Models/League.php:818
        • app/Services/LeagueSevice.php:21
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#793fpnstaging6.97msselect * from `fpn_promotions` where FIND_IN_SET(22, season_id) limit 1
        Bindings
        • 0: 22
        Backtrace
        • app/Models/League.php:793
        • app/Models/League.php:818
        • app/Services/LeagueSevice.php:21
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#896fpnstaging2.01msselect `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias`, `fpn_leagues`.`promotion_id`, `fpn_leagues`.`tourney_day`, `fpn_leagues`.`tournament_start_in`, `fpn_leagues`.`description`, `fpn_leagues`.`logo`, `fpn_leagues`.`multi_game`, `fpn_leagues`.`tourney_day`, `fpn_venues`.`name` as `venue_name`, `fpn_venues`.`alias` as `venue_alias`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`logo` as `promotion_logo`, `fpn_promotions`.`name` as `promotion_name`, `fpn_tournaments`.`alias` as `tournament_alias`, `fpn_tournaments`.`start_date` as `tournament_start_date`, `fpn_tournaments`.`event_id` as `eventID` from `fpn_leagues` left join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` where `fpn_tournaments`.`start_date` >= '2025-05-02 22:38:00' and `fpn_leagues`.`status` = 1 and `fpn_promotions`.`status` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_leagues`.`id` != 5 and `fpn_venues`.`id` = 236 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`start_date` asc
        Bindings
        • 0: 2025-05-02 22:38:00
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 5
        • 5: 236
        Backtrace
        • app/Models/League.php:896
        • app/Services/LeagueSevice.php:21
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#786fpnstaging730μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-02' order by `start_date` asc
        Bindings
        • 0: 2025-05-02
        Backtrace
        • app/Models/League.php:786
        • app/Models/League.php:924
        • app/Services/LeagueSevice.php:34
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#793fpnstaging7.38msselect * from `fpn_promotions` where FIND_IN_SET(21, season_id) limit 1
        Bindings
        • 0: 21
        Backtrace
        • app/Models/League.php:793
        • app/Models/League.php:924
        • app/Services/LeagueSevice.php:34
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#793fpnstaging7.25msselect * from `fpn_promotions` where FIND_IN_SET(22, season_id) limit 1
        Bindings
        • 0: 22
        Backtrace
        • app/Models/League.php:793
        • app/Models/League.php:924
        • app/Services/LeagueSevice.php:34
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#997fpnstaging113msselect `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias`, `fpn_leagues`.`promotion_id`, `fpn_leagues`.`tourney_day`, `fpn_leagues`.`tournament_start_in`, `fpn_leagues`.`description`, `fpn_leagues`.`logo`, `fpn_leagues`.`tourney_day`, `fpn_leagues`.`multi_game`, `fpn_venues`.`name` as `venue_name`, `fpn_venues`.`alias` as `venue_alias`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`logo` as `promotion_logo`, `fpn_promotions`.`name` as `promotion_name`, `fpn_tournaments`.`alias` as `tournament_alias`, `fpn_tournaments`.`start_date` as `tournament_start_date`, `fpn_tournaments`.`event_id` as `eventID` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` where `fpn_tournaments`.`id` in (select MAX(fpn_tournaments.id) from `fpn_tournaments` where `fpn_tournaments`.`start_date` < '2025-05-02 22:38:00' group by `fpn_tournaments`.`event_id`) and `fpn_leagues`.`status` = 1 and `fpn_promotions`.`status` = 1 and `fpn_leagues`.`id` != 5 and `fpn_venues`.`id` = 236 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`end_date` desc
        Bindings
        • 0: 2025-05-02 22:38:00
        • 1: 1
        • 2: 1
        • 3: 5
        • 4: 236
        Backtrace
        • app/Models/League.php:997
        • app/Services/LeagueSevice.php:34
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#71fpnstaging630μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 25 limit 1
        Bindings
        • 0: 25
        Backtrace
        • app/Services/ConfigSevice.php:71
        • app/Http/Controllers/Site/LeagueController.php:2232
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#111fpnstaging480μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 25 limit 1
        Bindings
        • 0: 25
        Backtrace
        • app/Services/ConfigSevice.php:111
        • app/Http/Controllers/Site/LeagueController.php:2235
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1967fpnstaging540μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 963 limit 1
        Bindings
        • 0: 963
        Backtrace
        • app/Models/League.php:1967
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1972fpnstaging570μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-02 22:38:58' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 19
        • 1: 20
        • 2: 2025-05-02 22:38:58
        • 3: 1
        Backtrace
        • app/Models/League.php:1972
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging710μsselect `id` from `fpn_tournaments` where `event_id` = 963 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
        Bindings
        • 0: 963
        • 1: 2025-01-01 00:00:00
        • 2: 2025-03-31 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging2.04msselect `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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 963 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (55355, 55356, 55357, 55358, 55359, 55360, 55361, 55362, 55363, 55364, 55365, 55366, 55367, 55381, 55382, 55383, 55384, 55385, 55386, 55387, 55388, 55389, 55390, 55391, 55392, 55393) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 963
        • 1: 1
        • 2: 55355
        • 3: 55356
        • 4: 55357
        • 5: 55358
        • 6: 55359
        • 7: 55360
        • 8: 55361
        • 9: 55362
        • 10: 55363
        • 11: 55364
        • 12: 55365
        • 13: 55366
        • 14: 55367
        • 15: 55381
        • 16: 55382
        • 17: 55383
        • 18: 55384
        • 19: 55385
        • 20: 55386
        • 21: 55387
        • 22: 55388
        • 23: 55389
        • 24: 55390
        • 25: 55391
        • 26: 55392
        • 27: 55393
        • 28: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging820μsselect `id` from `fpn_tournaments` where `event_id` = 963 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
        Bindings
        • 0: 963
        • 1: 2024-10-01 00:00:00
        • 2: 2024-12-31 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging5.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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 963 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (55342, 55343, 55344, 55345, 55346, 55347, 55348, 55349, 55350, 55351, 55352, 55353, 55354, 55368, 55369, 55370, 55371, 55372, 55373, 55374, 55375, 55376, 55377, 55378, 55379, 55380) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 963
        • 1: 1
        • 2: 55342
        • 3: 55343
        • 4: 55344
        • 5: 55345
        • 6: 55346
        • 7: 55347
        • 8: 55348
        • 9: 55349
        • 10: 55350
        • 11: 55351
        • 12: 55352
        • 13: 55353
        • 14: 55354
        • 15: 55368
        • 16: 55369
        • 17: 55370
        • 18: 55371
        • 19: 55372
        • 20: 55373
        • 21: 55374
        • 22: 55375
        • 23: 55376
        • 24: 55377
        • 25: 55378
        • 26: 55379
        • 27: 55380
        • 28: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueController.php#2241fpnstaging12.59msselect * from `fpn_tournaments` where `event_id` = 963 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-02' order by `start_date` desc limit 1
        Bindings
        • 0: 963
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2241
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#2295fpnstaging11.99msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 963 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-02'
        Bindings
        • 0: 963
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2295
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/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#1061fpnstaging480μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 25 limit 1
        Bindings
        • 0: 25
        Backtrace
        • app/Models/League.php:1061
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1070fpnstaging520μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('19', '20') order by `start_date` asc
        Bindings
        • 0: 19
        • 1: 20
        Backtrace
        • app/Models/League.php:1070
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#906fpnstaging460μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 25 limit 1
        Bindings
        • 0: 25
        Backtrace
        • app/Models/League.php:906
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#917fpnstaging510μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('19', '20') and date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 19
        • 1: 20
        • 2: 2025-05-02
        • 3: 2025-05-02
        • 4: 1
        Backtrace
        • app/Models/League.php:917
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2057fpnstaging650μsselect * from `fpn_leagues` where `id` = 963 limit 1
        Bindings
        • 0: 963
        Backtrace
        • app/Models/League.php:2057
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2058fpnstaging12.76msselect * from `fpn_promotions` where `id` = 25 limit 1
        Bindings
        • 0: 25
        Backtrace
        • app/Models/League.php:2058
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2060fpnstaging13.17msselect count(distinct `tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 963 and `status` = 1
        Bindings
        • 0: 963
        • 1: 1
        Backtrace
        • app/Models/League.php:2060
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2062fpnstaging12.95msselect count(`tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 963 and `status` = 1
        Bindings
        • 0: 963
        • 1: 1
        Backtrace
        • app/Models/League.php:2062
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2065fpnstaging660μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `id` in ('19', '20') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 2025-05-02
        • 2: 19
        • 3: 20
        • 4: 1
        Backtrace
        • app/Models/League.php:2065
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2069fpnstaging510μsselect * from `fpn_season` where date(`end_date`) < '2025-05-02' and `id` in ('19', '20') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 19
        • 2: 20
        • 3: 1
        Backtrace
        • app/Models/League.php:2069
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2101fpnstaging12.84msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where date(`fpn_tournaments`.`start_date`) >= '2024-10-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2024-12-31 00:00:00' and `fpn_tournaments`.`event_id` = 963 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 2024-10-01 00:00:00
        • 1: 2024-12-31 00:00:00
        • 2: 963
        • 3: 1
        • 4: 1
        Backtrace
        • app/Models/League.php:2101
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2108fpnstaging12.18msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 963 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 963
        • 1: 1
        Backtrace
        • app/Models/League.php:2108
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2113fpnstaging1.75msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (55342, 55343, 55344, 55345, 55347, 55348, 55349, 55352, 55353, 55368, 55369, 55370, 55371, 55374, 55375, 55378, 55379) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 55342
        • 1: 55343
        • 2: 55344
        • 3: 55345
        • 4: 55347
        • 5: 55348
        • 6: 55349
        • 7: 55352
        • 8: 55353
        • 9: 55368
        • 10: 55369
        • 11: 55370
        • 12: 55371
        • 13: 55374
        • 14: 55375
        • 15: 55378
        • 16: 55379
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2117fpnstaging660μsselect * from `users` where `users`.`id` = 11270 limit 1
        Bindings
        • 0: 11270
        Backtrace
        • app/Models/League.php:2117
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueSevice.php#140fpnstaging450μsselect `league_status` from `fpn_leagues` where `id` = 963 limit 1
        Bindings
        • 0: 963
        Backtrace
        • app/Services/LeagueSevice.php:140
        • app/Http/Controllers/Site/LeagueController.php:2335
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#71fpnstaging560μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 24 limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Services/ConfigSevice.php:71
        • app/Http/Controllers/Site/LeagueController.php:2232
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#111fpnstaging510μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 24 limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Services/ConfigSevice.php:111
        • app/Http/Controllers/Site/LeagueController.php:2235
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1967fpnstaging530μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 719 limit 1
        Bindings
        • 0: 719
        Backtrace
        • app/Models/League.php:1967
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1972fpnstaging610μsselect * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 22:38:58' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 17
        • 1: 18
        • 2: 2025-05-02 22:38:58
        • 3: 1
        Backtrace
        • app/Models/League.php:1972
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging760μsselect `id` from `fpn_tournaments` where `event_id` = 719 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
        Bindings
        • 0: 719
        • 1: 2024-07-01 00:00:00
        • 2: 2024-09-30 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging7.9msselect `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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 719 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (42565, 42566, 42567, 42568, 42569, 42570, 42571, 42572, 42573, 42574, 42575, 42576, 42577, 42591, 42592, 42593, 42594, 42595, 42596, 42597, 42598, 42599, 42600, 42601, 42602, 42603) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 719
        • 1: 1
        • 2: 42565
        • 3: 42566
        • 4: 42567
        • 5: 42568
        • 6: 42569
        • 7: 42570
        • 8: 42571
        • 9: 42572
        • 10: 42573
        • 11: 42574
        • 12: 42575
        • 13: 42576
        • 14: 42577
        • 15: 42591
        • 16: 42592
        • 17: 42593
        • 18: 42594
        • 19: 42595
        • 20: 42596
        • 21: 42597
        • 22: 42598
        • 23: 42599
        • 24: 42600
        • 25: 42601
        • 26: 42602
        • 27: 42603
        • 28: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging870μsselect `id` from `fpn_tournaments` where `event_id` = 719 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
        Bindings
        • 0: 719
        • 1: 2024-04-01 00:00:00
        • 2: 2024-06-30 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging8.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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 719 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (42552, 42553, 42554, 42555, 42556, 42557, 42558, 42559, 42560, 42561, 42562, 42563, 42564, 42578, 42579, 42580, 42581, 42582, 42583, 42584, 42585, 42586, 42587, 42588, 42589, 42590) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 719
        • 1: 1
        • 2: 42552
        • 3: 42553
        • 4: 42554
        • 5: 42555
        • 6: 42556
        • 7: 42557
        • 8: 42558
        • 9: 42559
        • 10: 42560
        • 11: 42561
        • 12: 42562
        • 13: 42563
        • 14: 42564
        • 15: 42578
        • 16: 42579
        • 17: 42580
        • 18: 42581
        • 19: 42582
        • 20: 42583
        • 21: 42584
        • 22: 42585
        • 23: 42586
        • 24: 42587
        • 25: 42588
        • 26: 42589
        • 27: 42590
        • 28: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueController.php#2241fpnstaging9.55msselect * from `fpn_tournaments` where `event_id` = 719 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-02' order by `start_date` desc limit 1
        Bindings
        • 0: 719
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2241
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#2295fpnstaging8.77msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 719 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-02'
        Bindings
        • 0: 719
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2295
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/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#1061fpnstaging530μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 24 limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Models/League.php:1061
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1070fpnstaging490μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('17', '18') order by `start_date` asc
        Bindings
        • 0: 17
        • 1: 18
        Backtrace
        • app/Models/League.php:1070
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#906fpnstaging420μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 24 limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Models/League.php:906
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#917fpnstaging480μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('17', '18') and date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 17
        • 1: 18
        • 2: 2025-05-02
        • 3: 2025-05-02
        • 4: 1
        Backtrace
        • app/Models/League.php:917
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2057fpnstaging680μsselect * from `fpn_leagues` where `id` = 719 limit 1
        Bindings
        • 0: 719
        Backtrace
        • app/Models/League.php:2057
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2058fpnstaging5.88msselect * from `fpn_promotions` where `id` = 24 limit 1
        Bindings
        • 0: 24
        Backtrace
        • app/Models/League.php:2058
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2060fpnstaging12.3msselect count(distinct `tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 719 and `status` = 1
        Bindings
        • 0: 719
        • 1: 1
        Backtrace
        • app/Models/League.php:2060
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2062fpnstaging11.69msselect count(`tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 719 and `status` = 1
        Bindings
        • 0: 719
        • 1: 1
        Backtrace
        • app/Models/League.php:2062
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2065fpnstaging590μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `id` in ('17', '18') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 2025-05-02
        • 2: 17
        • 3: 18
        • 4: 1
        Backtrace
        • app/Models/League.php:2065
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2069fpnstaging490μsselect * from `fpn_season` where date(`end_date`) < '2025-05-02' and `id` in ('17', '18') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 17
        • 2: 18
        • 3: 1
        Backtrace
        • app/Models/League.php:2069
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2101fpnstaging9.39msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where date(`fpn_tournaments`.`start_date`) >= '2024-04-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2024-06-30 00:00:00' and `fpn_tournaments`.`event_id` = 719 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 2024-04-01 00:00:00
        • 1: 2024-06-30 00:00:00
        • 2: 719
        • 3: 1
        • 4: 1
        Backtrace
        • app/Models/League.php:2101
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2108fpnstaging9.6msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 719 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 719
        • 1: 1
        Backtrace
        • app/Models/League.php:2108
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2113fpnstaging2.68msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (42552, 42553, 42554, 42555, 42556, 42557, 42558, 42559, 42560, 42561, 42562, 42563, 42564, 42578, 42579, 42580, 42581, 42582, 42583, 42584, 42585, 42586, 42587, 42588, 42589, 42590) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 42552
        • 1: 42553
        • 2: 42554
        • 3: 42555
        • 4: 42556
        • 5: 42557
        • 6: 42558
        • 7: 42559
        • 8: 42560
        • 9: 42561
        • 10: 42562
        • 11: 42563
        • 12: 42564
        • 13: 42578
        • 14: 42579
        • 15: 42580
        • 16: 42581
        • 17: 42582
        • 18: 42583
        • 19: 42584
        • 20: 42585
        • 21: 42586
        • 22: 42587
        • 23: 42588
        • 24: 42589
        • 25: 42590
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2117fpnstaging660μsselect * from `users` where `users`.`id` = 10964 limit 1
        Bindings
        • 0: 10964
        Backtrace
        • app/Models/League.php:2117
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueSevice.php#140fpnstaging430μsselect `league_status` from `fpn_leagues` where `id` = 719 limit 1
        Bindings
        • 0: 719
        Backtrace
        • app/Services/LeagueSevice.php:140
        • app/Http/Controllers/Site/LeagueController.php:2335
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#71fpnstaging510μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Services/ConfigSevice.php:71
        • app/Http/Controllers/Site/LeagueController.php:2232
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#111fpnstaging520μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Services/ConfigSevice.php:111
        • app/Http/Controllers/Site/LeagueController.php:2235
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1967fpnstaging470μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 493 limit 1
        Bindings
        • 0: 493
        Backtrace
        • app/Models/League.php:1967
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1972fpnstaging610μsselect * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-02 22:38:59' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 15
        • 1: 16
        • 2: 2025-05-02 22:38:59
        • 3: 1
        Backtrace
        • app/Models/League.php:1972
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging630μsselect `id` from `fpn_tournaments` where `event_id` = 493 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
        Bindings
        • 0: 493
        • 1: 2024-01-01 00:00:00
        • 2: 2024-03-31 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging4.51msselect `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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 493 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (33123, 33124, 33125, 33136, 33137, 33504, 33505, 33506, 33507, 33948, 33949, 33950, 33951) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 493
        • 1: 1
        • 2: 33123
        • 3: 33124
        • 4: 33125
        • 5: 33136
        • 6: 33137
        • 7: 33504
        • 8: 33505
        • 9: 33506
        • 10: 33507
        • 11: 33948
        • 12: 33949
        • 13: 33950
        • 14: 33951
        • 15: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1984fpnstaging700μsselect `id` from `fpn_tournaments` where `event_id` = 493 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
        Bindings
        • 0: 493
        • 1: 2023-10-01 00:00:00
        • 2: 2023-12-31 00:00:00
        Backtrace
        • app/Models/League.php:1984
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2016fpnstaging1.25msselect `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` 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_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 493 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (33126, 33127, 33128, 33129, 33130, 33131, 33132, 33133, 33134, 33135) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 493
        • 1: 1
        • 2: 33126
        • 3: 33127
        • 4: 33128
        • 5: 33129
        • 6: 33130
        • 7: 33131
        • 8: 33132
        • 9: 33133
        • 10: 33134
        • 11: 33135
        • 12: 1
        Backtrace
        • app/Models/League.php:2016
        • app/Http/Controllers/Site/LeagueController.php:2238
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueController.php#2241fpnstaging1.07msselect * from `fpn_tournaments` where `event_id` = 493 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-02' order by `start_date` desc limit 1
        Bindings
        • 0: 493
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2241
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#2295fpnstaging580μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 493 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-02'
        Bindings
        • 0: 493
        • 1: 1
        • 2: 2025-05-02
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2295
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/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#1061fpnstaging430μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Models/League.php:1061
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1070fpnstaging480μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('15', '16') order by `start_date` asc
        Bindings
        • 0: 15
        • 1: 16
        Backtrace
        • app/Models/League.php:1070
        • app/Http/Controllers/Site/LeagueController.php:2301
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#906fpnstaging430μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Models/League.php:906
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#917fpnstaging480μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('15', '16') and date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 15
        • 1: 16
        • 2: 2025-05-02
        • 3: 2025-05-02
        • 4: 1
        Backtrace
        • app/Models/League.php:917
        • app/Http/Controllers/Site/LeagueController.php:2302
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2057fpnstaging630μsselect * from `fpn_leagues` where `id` = 493 limit 1
        Bindings
        • 0: 493
        Backtrace
        • app/Models/League.php:2057
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2058fpnstaging5.55msselect * from `fpn_promotions` where `id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Models/League.php:2058
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2060fpnstaging7.7msselect count(distinct `tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 493 and `status` = 1
        Bindings
        • 0: 493
        • 1: 1
        Backtrace
        • app/Models/League.php:2060
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2062fpnstaging7.98msselect count(`tournament_players`.`user_id`) as aggregate from `fpn_tournaments` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` where `fpn_tournaments`.`event_id` = 493 and `status` = 1
        Bindings
        • 0: 493
        • 1: 1
        Backtrace
        • app/Models/League.php:2062
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2065fpnstaging580μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-02' and date(`end_date`) >= '2025-05-02' and `id` in ('15', '16') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 2025-05-02
        • 2: 15
        • 3: 16
        • 4: 1
        Backtrace
        • app/Models/League.php:2065
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2069fpnstaging500μsselect * from `fpn_season` where date(`end_date`) < '2025-05-02' and `id` in ('15', '16') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-02
        • 1: 15
        • 2: 16
        • 3: 1
        Backtrace
        • app/Models/League.php:2069
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2101fpnstaging770μsselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where date(`fpn_tournaments`.`start_date`) >= '2023-10-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2023-12-31 00:00:00' and `fpn_tournaments`.`event_id` = 493 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 2023-10-01 00:00:00
        • 1: 2023-12-31 00:00:00
        • 2: 493
        • 3: 1
        • 4: 1
        Backtrace
        • app/Models/League.php:2101
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2108fpnstaging7.2msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 493 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 493
        • 1: 1
        Backtrace
        • app/Models/League.php:2108
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2113fpnstaging670μsselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where 0 = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueSevice.php#140fpnstaging490μsselect `league_status` from `fpn_leagues` where `id` = 493 limit 1
        Bindings
        • 0: 493
        Backtrace
        • app/Services/LeagueSevice.php:140
        • app/Http/Controllers/Site/LeagueController.php:2335
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueController.php#116fpnstaging6.49msselect * from `fpn_venues` where `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:116
        • vendor/laravel/framework/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
      • LeagueController.php#119fpnstaging980μsselect * from `fpn_regions` where `status` = 1 order by `name` asc
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:119
        • vendor/laravel/framework/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
      • LeagueController.php#162fpnstaging710μsselect * from `fpn_venues` where `status` = 1 and `id` = 236 limit 1
        Bindings
        • 0: 1
        • 1: 236
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:162
        • vendor/laravel/framework/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
      • LeagueController.php#189fpnstaging830μsselect `fpn_venues`.`name`, `fpn_venues`.`map_location_latitude`, `fpn_venues`.`map_location_longitude`, `fpn_leagues`.`id` as `leagueId`, `fpn_leagues`.`alias` as `league_alias`, `fpn_leagues`.`name` as `league_name` from `fpn_venues` left join `fpn_leagues` on `fpn_leagues`.`venue_id` = `fpn_venues`.`id` where `fpn_venues`.`id` = 236 order by `fpn_venues`.`name` asc
        Bindings
        • 0: 236
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:189
        • vendor/laravel/framework/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
      • Article.php#163fpnstaging1.44msselect count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and `venue_id` = 236
        Bindings
        • 0: 1
        • 1: 236
        Backtrace
        • app/Models/Article.php:163
        • app/Http/Controllers/Site/LeagueController.php:204
        • vendor/laravel/framework/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#174fpnstaging980μsselect * from `articles` where `status` = '1' and `category_id` is not null and `venue_id` = 236 order by `published_at` desc limit 6
        Bindings
        • 0: 1
        • 1: 236
        Backtrace
        • app/Models/Article.php:174
        • app/Http/Controllers/Site/LeagueController.php:204
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • fpnstaging510μsselect `default_article_image` from `configurations`
      • fpnstaging670μsselect * from `fpn_venues` where `id` = ? limit 1
      • fpnstaging450μsselect `featured_hosts` from `fpn_venues` where `id` = ? limit 1
      App\Models\Venue
      252Venue.php#?
      App\Models\Promotion
      28Promotion.php#?
      App\Models\Season
      21Season.php#?
      App\Models\Region
      19Region.php#?
      App\Models\League
      6League.php#?
      App\Models\Article
      6Article.php#?
      App\Models\TournamentPlayer
      4TournamentPlayer.php#?
      App\Models\Tournament
      2Tournament.php#?
      App\Models\User
      2User.php#?
          • missed dw3ugZFqShqr7UdtA9QZmX5LFSITkDf6RoKLEv9e (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
          • 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 dw3ugZFqShqr7UdtA9QZmX5LFSITkDf6RoKLEv9e (0μs)forget
          • 1 x missed dw3ugZFqShqr7UdtA9QZmX5LFSITkDf6RoKLEv9e (0%)
            0μs
            16 x hit c_config (0%)
            0μs
            1 x written dw3ugZFqShqr7UdtA9QZmX5LFSITkDf6RoKLEv9e (0%)
            0μs
          _token
          l9VF20L9xgmb05wR74WzRa9P8Y7rMhZMpvnC4hft
          _previous
          array:1 [ "url" => "https://staging.freepokernetwork.com/venues/pappy-s-family-pub" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /venues/pappy-s-family-pub
          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 => "Sat, 03 May 2025 03:38:59 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNsbXRuRzM2VlNOa1cvVitRTDkrN0E9PSIsInZhbHVlIjoiV2dYb1FkVzRJb3hBVjdxdm5CUzk5cDRUc2JhaTJaSXc5NlJlaTVrSERvT1ZUUWVKM1BUUEJkbDJlMkJHYzM5UmhtUVJJSG1WZGQwQUZEY25hS3duekxqUUM1a0VwRWNPZG51SHgxU0pPMmFQMHdka01uRXVVK1JGdThjQ2tSalciLCJtYWMiOiJhM2U4ZmYyZjE4OGUxZGE3ODdiMGE2ODU5MTE0MjkzNGJmNGEyZmRlNWQwMzQwNGI2MTI1YTU1ZjM5ZmRjOTNkIiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 03:38:59 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkNsbXRuRzM2VlNOa1cvVitRTDkrN0E9PSIsInZhbHVlIjoiV2dYb1FkVzRJb3hBVjdxdm5CUzk5cDRUc2JhaTJaSXc5NlJlaTVrSERvT1ZUUWVKM1BUUEJkbDJlMkJHYzM5UmhtUVJJS" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImNUUkEwR042WlR6OEp4NE1JeE1Ea2c9PSIsInZhbHVlIjoiVFFWV2x0Y1dFZHNXU0NZWmVuVU02eHJZY3NiYlBEaHhENjVpN1RxdkI1dEtERUFJL2gzb215VEhheU5SY3g2T0VUNUw3QzJVY081WDlVTCtEMEt2OFJVVXorcTJDRktWQU9XY0R6QWNmNW42SHZ4YVpkYkFuYjQvMm9JaytSTmYiLCJtYWMiOiI3MTAxZjcyMjVlYjE1YmIzNTA5YjVhOTNmY2Y3NjdkNDJhNzMzOWI4YjllZDUwNTZhOTdmMzBiYmFiMTg1YTUxIiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 03:38:59 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6ImNUUkEwR042WlR6OEp4NE1JeE1Ea2c9PSIsInZhbHVlIjoiVFFWV2x0Y1dFZHNXU0NZWmVuVU02eHJZY3NiYlBEaHhENjVpN1RxdkI1dEtERUFJL2gzb21" 2 => "RSVP_status=eyJpdiI6Im1qWGJLUkhIMlFDa01MOEJLbTVqcXc9PSIsInZhbHVlIjoiVi9KMmR0cUpWZmwyZkc5TnBQcjdhRGhhY3lJZXJTNVcwY0NRRHpPWlo3ZWxvMnk4cHBmNHJPenZRdlBGVmNUeSIsIm1hYyI6IjQ3YjU3MTBjNjRhMmZjNzhlNTdmYzg0MmE2MTFlMmUyOWNhYjNlMDk0YWYxMzczNmZmZTIxMWZjMTFkZGY4MGQiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04 May 2020 03:38:58 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6Im1qWGJLUkhIMlFDa01MOEJLbTVqcXc9PSIsInZhbHVlIjoiVi9KMmR0cUpWZmwyZkc5TnBQcjdhRGhhY3lJZXJTNVcwY0NRRHpPWlo3ZWxvMnk4cHBmNHJPenZRdlBGVmNUeSIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNsbXRuRzM2VlNOa1cvVitRTDkrN0E9PSIsInZhbHVlIjoiV2dYb1FkVzRJb3hBVjdxdm5CUzk5cDRUc2JhaTJaSXc5NlJlaTVrSERvT1ZUUWVKM1BUUEJkbDJlMkJHYzM5UmhtUVJJSG1WZGQwQUZEY25hS3duekxqUUM1a0VwRWNPZG51SHgxU0pPMmFQMHdka01uRXVVK1JGdThjQ2tSalciLCJtYWMiOiJhM2U4ZmYyZjE4OGUxZGE3ODdiMGE2ODU5MTE0MjkzNGJmNGEyZmRlNWQwMzQwNGI2MTI1YTU1ZjM5ZmRjOTNkIiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 03:38:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkNsbXRuRzM2VlNOa1cvVitRTDkrN0E9PSIsInZhbHVlIjoiV2dYb1FkVzRJb3hBVjdxdm5CUzk5cDRUc2JhaTJaSXc5NlJlaTVrSERvT1ZUUWVKM1BUUEJkbDJlMkJHYzM5UmhtUVJJS" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImNUUkEwR042WlR6OEp4NE1JeE1Ea2c9PSIsInZhbHVlIjoiVFFWV2x0Y1dFZHNXU0NZWmVuVU02eHJZY3NiYlBEaHhENjVpN1RxdkI1dEtERUFJL2gzb215VEhheU5SY3g2T0VUNUw3QzJVY081WDlVTCtEMEt2OFJVVXorcTJDRktWQU9XY0R6QWNmNW42SHZ4YVpkYkFuYjQvMm9JaytSTmYiLCJtYWMiOiI3MTAxZjcyMjVlYjE1YmIzNTA5YjVhOTNmY2Y3NjdkNDJhNzMzOWI4YjllZDUwNTZhOTdmMzBiYmFiMTg1YTUxIiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 03:38:59 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6ImNUUkEwR042WlR6OEp4NE1JeE1Ea2c9PSIsInZhbHVlIjoiVFFWV2x0Y1dFZHNXU0NZWmVuVU02eHJZY3NiYlBEaHhENjVpN1RxdkI1dEtERUFJL2gzb21" 2 => "RSVP_status=eyJpdiI6Im1qWGJLUkhIMlFDa01MOEJLbTVqcXc9PSIsInZhbHVlIjoiVi9KMmR0cUpWZmwyZkc5TnBQcjdhRGhhY3lJZXJTNVcwY0NRRHpPWlo3ZWxvMnk4cHBmNHJPenZRdlBGVmNUeSIsIm1hYyI6IjQ3YjU3MTBjNjRhMmZjNzhlNTdmYzg0MmE2MTFlMmUyOWNhYjNlMDk0YWYxMzczNmZmZTIxMWZjMTFkZGY4MGQiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04-May-2020 03:38:58 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6Im1qWGJLUkhIMlFDa01MOEJLbTVqcXc9PSIsInZhbHVlIjoiVi9KMmR0cUpWZmwyZkc5TnBQcjdhRGhhY3lJZXJTNVcwY0NRRHpPWlo3ZWxvMnk4cHBmNHJPenZRdlBGVmNUeSIsIm1h" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "l9VF20L9xgmb05wR74WzRa9P8Y7rMhZMpvnC4hft" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/venues/pappy-s-family-pub" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-02 22:38:59GET/venues/pappy-s-family-pub3910334018