13
Avg. Attendees
865 Points
Leading

Past Season: Winter 2025
2293 Points
League Champ
Past Season: Fall 2024
2024 Points
League Champ
Past Season: Summer 2024
2545 Points
League Champ
Past Season: Spring 2024
2321 Points
League Champ
Past Season: Winter 2024
1598 Points
League Champ
Past Season: Fall 2023
1929 Points
League Champ
Past Season: Summer
1777 Points
League Champ
Past Season: Spring
1493 Points
League Champ
Past Season: Winter
1488 Points
League Champ
Past Season: Fall
1308 Points
League Champ

Venue

7465 Lancaster Pike, Hockessin, DE 19707, USA, Hockessin, DE, 19707
Phone: (302) 489-7287
Request history8.3.16PHP Version1.19sRequest Duration11MBMemory UsageGET venues/{alias}Route
    • Booting (42.45ms)time
    • Application (1.15s)time
    • 1 x Application (96.45%)
      1.15s
      1 x Booting (3.55%)
      42.45ms
      48 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
      • 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-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
      • 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-imagelazyload-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
      • 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
      204 statements were executed (134 duplicates)Show only duplicatesfpnstaging865ms
      • # Query soft limit for Debugbar is reached after 100 queries, additional 104 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#786fpnstaging1.92msselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-05' order by `start_date` asc
        Bindings
        • 0: 2025-05-05
        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#793fpnstaging7.97msselect * 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.84msselect * 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.62msselect * from `fpn_venues` where `status` = '1' and `alias` = '6-paupers-tavern-restaurant' limit 1
        Bindings
        • 0: 1
        • 1: 6-paupers-tavern-restaurant
        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#70fpnstaging620μsselect count(*) as aggregate from `fpn_leagues` where `venue_id` = 114
        Bindings
        • 0: 114
        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#200fpnstaging107msselect `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('114', 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#55fpnstaging600μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = '25' limit 1
        Bindings
        • 0: 25
        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#95fpnstaging680μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = '25' limit 1
        Bindings
        • 0: 25
        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.12msselect `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` = 70154 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 70154
        • 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#55fpnstaging490μ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#95fpnstaging880μ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.35msselect `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` = 49857 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 49857
        • 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#55fpnstaging1.11msselect `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#95fpnstaging610μ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#252fpnstaging890μ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` = 41005 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 41005
        • 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#135fpnstaging600μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = '16' limit 1
        Bindings
        • 0: 16
        Backtrace
        • app/Services/ConfigSevice.php:135
        • app/Services/QualifierService.php:235
        • 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#143fpnstaging560μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = '16' limit 1
        Bindings
        • 0: 16
        Backtrace
        • app/Services/ConfigSevice.php:143
        • app/Services/QualifierService.php:236
        • 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#252fpnstaging890μ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` = 20253 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 20253
        • 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
      • QualifierService.php#208fpnstaging520μsselect `id` from `fpn_promotions` where `status` = 1 and `id` in ('15', '16') order by `id` desc limit 1
        Bindings
        • 0: 1
        • 1: 15
        • 2: 16
        Backtrace
        • app/Services/QualifierService.php:208
        • 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#55fpnstaging1.46msselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 16 limit 1
        Bindings
        • 0: 16
        Backtrace
        • app/Services/ConfigSevice.php:55
        • app/Services/QualifierService.php:211
        • 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#95fpnstaging630μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 16 limit 1
        Bindings
        • 0: 16
        Backtrace
        • app/Services/ConfigSevice.php:95
        • app/Services/QualifierService.php:212
        • 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#252fpnstaging870μ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` = 20250 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 20250
        • 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#786fpnstaging770μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-05' order by `start_date` asc
        Bindings
        • 0: 2025-05-05
        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#793fpnstaging10.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:818
        • app/Services/LeagueSevice.php:21
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • League.php#793fpnstaging9.86msselect * 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#896fpnstaging3.46msselect `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-05 23:46: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` = 114 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`start_date` asc
        Bindings
        • 0: 2025-05-05 23:46:00
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 5
        • 5: 114
        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
      • ConfigSevice.php#71fpnstaging1.65msselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 26 limit 1
        Bindings
        • 0: 26
        Backtrace
        • app/Services/ConfigSevice.php:71
        • app/Http/Controllers/Site/LeagueController.php:2232
        • 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
      • ConfigSevice.php#111fpnstaging1.7msselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 26 limit 1
        Bindings
        • 0: 26
        Backtrace
        • app/Services/ConfigSevice.php:111
        • app/Http/Controllers/Site/LeagueController.php:2235
        • 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#1967fpnstaging1.2msselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1076 limit 1
        Bindings
        • 0: 1076
        Backtrace
        • app/Models/League.php:1967
        • app/Http/Controllers/Site/LeagueController.php:2238
        • 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#1972fpnstaging790μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-05 23:46:04' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-05 23:46:04
        • 3: 1
        Backtrace
        • app/Models/League.php:1972
        • app/Http/Controllers/Site/LeagueController.php:2238
        • 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
      • LeagueController.php#2241fpnstaging2.18msselect * from `fpn_tournaments` where `event_id` = 1076 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-05' order by `start_date` desc limit 1
        Bindings
        • 0: 1076
        • 1: 1
        • 2: 2025-05-05
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2241
        • 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
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#2295fpnstaging890μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 1076 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-05'
        Bindings
        • 0: 1076
        • 1: 1
        • 2: 2025-05-05
        Backtrace
        • app/Http/Controllers/Site/LeagueController.php:2295
        • 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
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • League.php#1061fpnstaging710μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        Backtrace
        • app/Models/League.php:1061
        • app/Http/Controllers/Site/LeagueController.php:2301
        • 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#1070fpnstaging670μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') order by `start_date` asc
        Bindings
        • 0: 21
        • 1: 22
        Backtrace
        • app/Models/League.php:1070
        • app/Http/Controllers/Site/LeagueController.php:2301
        • 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#906fpnstaging510μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        Backtrace
        • app/Models/League.php:906
        • app/Http/Controllers/Site/LeagueController.php:2302
        • 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#917fpnstaging600μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') and date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-05
        • 3: 2025-05-05
        • 4: 1
        Backtrace
        • app/Models/League.php:917
        • app/Http/Controllers/Site/LeagueController.php:2302
        • 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#2057fpnstaging770μsselect * from `fpn_leagues` where `id` = 1076 limit 1
        Bindings
        • 0: 1076
        Backtrace
        • app/Models/League.php:2057
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2058fpnstaging10.28msselect * from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        Backtrace
        • app/Models/League.php:2058
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2060fpnstaging15.82msselect 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` = 1076 and `status` = 1
        Bindings
        • 0: 1076
        • 1: 1
        Backtrace
        • app/Models/League.php:2060
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2062fpnstaging14.71msselect 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` = 1076 and `status` = 1
        Bindings
        • 0: 1076
        • 1: 1
        Backtrace
        • app/Models/League.php:2062
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2065fpnstaging680μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `id` in ('21', '22') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-05
        • 1: 2025-05-05
        • 2: 21
        • 3: 22
        • 4: 1
        Backtrace
        • app/Models/League.php:2065
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2101fpnstaging1.24msselect `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`) >= '2025-04-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2025-06-30 00:00:00' and `fpn_tournaments`.`event_id` = 1076 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 2025-04-01 00:00:00
        • 1: 2025-06-30 00:00:00
        • 2: 1076
        • 3: 1
        • 4: 1
        Backtrace
        • app/Models/League.php:2101
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2108fpnstaging14.43msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 1076 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 1076
        • 1: 1
        Backtrace
        • app/Models/League.php:2108
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2113fpnstaging1.71msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (63199, 63200, 63201) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 63199
        • 1: 63200
        • 2: 63201
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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#2117fpnstaging5.31msselect * from `users` where `users`.`id` = 1419 limit 1
        Bindings
        • 0: 1419
        Backtrace
        • app/Models/League.php:2117
        • app/Http/Controllers/Site/LeagueController.php:2305
        • 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
      • LeagueSevice.php#140fpnstaging2.2msselect `league_status` from `fpn_leagues` where `id` = 1076 limit 1
        Bindings
        • 0: 1076
        Backtrace
        • app/Services/LeagueSevice.php:140
        • app/Http/Controllers/Site/LeagueController.php:2335
        • 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#786fpnstaging780μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-05' order by `start_date` asc
        Bindings
        • 0: 2025-05-05
        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.95msselect * 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#793fpnstaging9.54msselect * 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#997fpnstaging177msselect `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-05 23:46: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` = 114 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`end_date` desc
        Bindings
        • 0: 2025-05-05 23:46:00
        • 1: 1
        • 2: 1
        • 3: 5
        • 4: 114
        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#71fpnstaging1.28msselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = 26 limit 1
        Bindings
        • 0: 26
        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#111fpnstaging670μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = 26 limit 1
        Bindings
        • 0: 26
        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#1967fpnstaging680μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1076 limit 1
        Bindings
        • 0: 1076
        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#1972fpnstaging750μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-05 23:46:04' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-05 23:46:04
        • 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
      • LeagueController.php#2241fpnstaging1.13msselect * from `fpn_tournaments` where `event_id` = 1076 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-05' order by `start_date` desc limit 1
        Bindings
        • 0: 1076
        • 1: 1
        • 2: 2025-05-05
        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#2295fpnstaging630μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 1076 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-05'
        Bindings
        • 0: 1076
        • 1: 1
        • 2: 2025-05-05
        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#1061fpnstaging590μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        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#1070fpnstaging540μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') order by `start_date` asc
        Bindings
        • 0: 21
        • 1: 22
        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#906fpnstaging530μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        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#917fpnstaging530μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') and date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-05
        • 3: 2025-05-05
        • 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#2057fpnstaging600μsselect * from `fpn_leagues` where `id` = 1076 limit 1
        Bindings
        • 0: 1076
        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#2058fpnstaging6.34msselect * from `fpn_promotions` where `id` = 26 limit 1
        Bindings
        • 0: 26
        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#2060fpnstaging15.97msselect 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` = 1076 and `status` = 1
        Bindings
        • 0: 1076
        • 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#2062fpnstaging14.04msselect 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` = 1076 and `status` = 1
        Bindings
        • 0: 1076
        • 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#2065fpnstaging680μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `id` in ('21', '22') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-05
        • 1: 2025-05-05
        • 2: 21
        • 3: 22
        • 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#2101fpnstaging1msselect `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`) >= '2025-04-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2025-06-30 00:00:00' and `fpn_tournaments`.`event_id` = 1076 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 2025-04-01 00:00:00
        • 1: 2025-06-30 00:00:00
        • 2: 1076
        • 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#2108fpnstaging13.83msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 1076 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 1076
        • 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.37msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (63199, 63200, 63201) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 63199
        • 1: 63200
        • 2: 63201
        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#2117fpnstaging740μsselect * from `users` where `users`.`id` = 1419 limit 1
        Bindings
        • 0: 1419
        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#140fpnstaging630μsselect `league_status` from `fpn_leagues` where `id` = 1076 limit 1
        Bindings
        • 0: 1076
        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#71fpnstaging790μ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#111fpnstaging660μ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#1967fpnstaging620μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 805 limit 1
        Bindings
        • 0: 805
        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#1972fpnstaging900μsselect * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-05 23:46:05' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 19
        • 1: 20
        • 2: 2025-05-05 23:46:05
        • 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#1984fpnstaging780μsselect `id` from `fpn_tournaments` where `event_id` = 805 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
        Bindings
        • 0: 805
        • 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#2016fpnstaging7.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` = 805 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (57262, 57263, 57264, 57265, 57266, 57267, 57268, 57269, 57270, 57271, 57272, 57273, 57274) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 805
        • 1: 1
        • 2: 57262
        • 3: 57263
        • 4: 57264
        • 5: 57265
        • 6: 57266
        • 7: 57267
        • 8: 57268
        • 9: 57269
        • 10: 57270
        • 11: 57271
        • 12: 57272
        • 13: 57273
        • 14: 57274
        • 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#1984fpnstaging820μsselect `id` from `fpn_tournaments` where `event_id` = 805 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
        Bindings
        • 0: 805
        • 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#2016fpnstaging7.4msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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` = 805 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (57249, 57250, 57251, 57252, 57253, 57254, 57255, 57256, 57257, 57258, 57259, 57260, 57261) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 10
        Bindings
        • 0: 805
        • 1: 1
        • 2: 57249
        • 3: 57250
        • 4: 57251
        • 5: 57252
        • 6: 57253
        • 7: 57254
        • 8: 57255
        • 9: 57256
        • 10: 57257
        • 11: 57258
        • 12: 57259
        • 13: 57260
        • 14: 57261
        • 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
      • LeagueController.php#2241fpnstaging1.39msselect * from `fpn_tournaments` where `event_id` = 805 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-05' order by `start_date` desc limit 1
        Bindings
        • 0: 805
        • 1: 1
        • 2: 2025-05-05
        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#2295fpnstaging690μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 805 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-05'
        Bindings
        • 0: 805
        • 1: 1
        • 2: 2025-05-05
        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#1061fpnstaging410μ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#1070fpnstaging460μ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#906fpnstaging980μ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#917fpnstaging690μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('19', '20') and date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 19
        • 1: 20
        • 2: 2025-05-05
        • 3: 2025-05-05
        • 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#2057fpnstaging770μsselect * from `fpn_leagues` where `id` = 805 limit 1
        Bindings
        • 0: 805
        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#2058fpnstaging14.93msselect * 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#2060fpnstaging18.18msselect 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` = 805 and `status` = 1
        Bindings
        • 0: 805
        • 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#2062fpnstaging17.54msselect 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` = 805 and `status` = 1
        Bindings
        • 0: 805
        • 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#2065fpnstaging850μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-05' and date(`end_date`) >= '2025-05-05' and `id` in ('19', '20') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-05
        • 1: 2025-05-05
        • 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#2069fpnstaging1.18msselect * from `fpn_season` where date(`end_date`) < '2025-05-05' and `id` in ('19', '20') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-05
        • 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#2101fpnstaging1.34msselect `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` = 805 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: 805
        • 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#2108fpnstaging14.34msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 805 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 805
        • 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#2113fpnstaging3.42msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (57249, 57250, 57251, 57252, 57253, 57254, 57255, 57256, 57257, 57258, 57259, 57260, 57261) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 57249
        • 1: 57250
        • 2: 57251
        • 3: 57252
        • 4: 57253
        • 5: 57254
        • 6: 57255
        • 7: 57256
        • 8: 57257
        • 9: 57258
        • 10: 57259
        • 11: 57260
        • 12: 57261
        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` = 1209 limit 1
        Bindings
        • 0: 1209
        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#140fpnstaging820μsselect `league_status` from `fpn_leagues` where `id` = 805 limit 1
        Bindings
        • 0: 805
        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#71fpnstaging980μ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#111fpnstaging540μ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#1967fpnstaging680μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 509 limit 1
        Bindings
        • 0: 509
        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-05 23:46:05' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 17
        • 1: 18
        • 2: 2025-05-05 23:46:05
        • 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#1984fpnstaging790μsselect `id` from `fpn_tournaments` where `event_id` = 509 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
        Bindings
        • 0: 509
        • 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
      • fpnstaging9.5msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging760μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging10.06msselect `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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging1.27msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging620μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging450μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging420μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging550μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging480μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) and date(`start_date`) <= ? and date(`end_date`) >= ? and `status` = ? order by `start_date` desc limit 1
      • fpnstaging620μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging6.78msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging15.49msselect 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` = ? and `status` = ?
      • fpnstaging14.39msselect 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` = ? and `status` = ?
      • fpnstaging750μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging630μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.33msselect `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`) >= ? and date(`fpn_tournaments`.`end_date`) <= ? and `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging12.29msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging4.18msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) group by `tournament_players`.`user_id` order by `score` desc limit 1
      • fpnstaging1.09msselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging470μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging480μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging610μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging510μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = ? limit 1
      • fpnstaging1.19msselect * from `fpn_season` where `id` in (?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging1.04msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.77msselect `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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging680μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.02msselect `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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging1.15msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging760μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging390μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging420μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging1.12msselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging1.38msselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) and date(`start_date`) <= ? and date(`end_date`) >= ? and `status` = ? order by `start_date` desc limit 1
      • fpnstaging950μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging7.47msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging12.02msselect 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` = ? and `status` = ?
      • fpnstaging8.52msselect 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` = ? and `status` = ?
      • fpnstaging640μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging520μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.27msselect `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`) >= ? and date(`fpn_tournaments`.`end_date`) <= ? and `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging11.62msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging2.75msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) group by `tournament_players`.`user_id` order by `score` desc limit 1
      • fpnstaging870μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging510μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging510μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging680μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging910μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = ? limit 1
      • fpnstaging570μsselect * from `fpn_season` where `id` in (?, ?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging780μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.64msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging790μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging4.93msselect `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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging780μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.57msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging4.02msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging3.71msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging480μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging480μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?, ?) order by `start_date` asc
      • fpnstaging400μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging470μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?, ?) and date(`start_date`) <= ? and date(`end_date`) >= ? and `status` = ? order by `start_date` desc limit 1
      • fpnstaging610μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging16.46msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging8.03msselect 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` = ? and `status` = ?
      • fpnstaging6.86msselect 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` = ? and `status` = ?
      • fpnstaging600μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?, ?) and `status` = ? limit 1
      • fpnstaging470μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?, ?) and `status` = ? limit 1
      • fpnstaging4.33msselect `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`) >= ? and date(`fpn_tournaments`.`end_date`) <= ? and `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging4.8msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging2.29msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) group by `tournament_players`.`user_id` order by `score` desc limit 1
      • fpnstaging900μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging440μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging550μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging590μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging680μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = ? limit 1
      • fpnstaging670μsselect * from `fpn_season` where `id` in (?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging620μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.21msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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` = ? and `fpn_tournaments`.`status` = ? and `tournament_players`.`tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`user_id` order by `score` desc limit 10
      • fpnstaging1.85msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging630μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging410μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging400μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?) order by `start_date` asc
      • fpnstaging430μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging400μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?) and date(`start_date`) <= ? and date(`end_date`) >= ? and `status` = ? order by `start_date` desc limit 1
      • fpnstaging660μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging600μsselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging2.22msselect 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` = ? and `status` = ?
      • fpnstaging1.83msselect 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` = ? and `status` = ?
      • fpnstaging470μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?) and `status` = ? limit 1
      • fpnstaging440μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?) and `status` = ? limit 1
      • fpnstaging1.28msselect `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`) >= ? and date(`fpn_tournaments`.`end_date`) <= ? and `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? and `fpn_tournaments`.`finalized_tournament` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging940μsselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging2.54msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) group by `tournament_players`.`user_id` order by `score` desc limit 1
      • fpnstaging680μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging480μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging5.73msselect * from `fpn_venues` where `status` = ?
      • fpnstaging1.27msselect * from `fpn_regions` where `status` = ? order by `name` asc
      • fpnstaging1.2msselect * from `fpn_venues` where `status` = ? and `id` = ? limit 1
      • fpnstaging1.14msselect `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` = ? order by `fpn_venues`.`name` asc
      • fpnstaging1msselect count(*) as aggregate from `articles` where `status` = ? and `category_id` is not null and `venue_id` = ?
      • fpnstaging1.16msselect * from `articles` where `status` = ? and `category_id` is not null and `venue_id` = ? order by `published_at` desc limit 6
      • fpnstaging400μsselect `default_article_image` from `configurations`
      • fpnstaging650μsselect * from `fpn_venues` where `id` = ? limit 1
      • fpnstaging440μsselect `featured_hosts` from `fpn_venues` where `id` = ? limit 1
      App\Models\Venue
      255Venue.php#?
      App\Models\Promotion
      59Promotion.php#?
      App\Models\Season
      39Season.php#?
      App\Models\Region
      19Region.php#?
      App\Models\League
      14League.php#?
      App\Models\TournamentPlayer
      12TournamentPlayer.php#?
      App\Models\Tournament
      7Tournament.php#?
      App\Models\User
      7User.php#?
      App\Models\Article
      6Article.php#?
          • missed XUQQAC2WMU7uaHHtTwIn1f4p1CObdCjisHYS75JC (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
          • 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 XUQQAC2WMU7uaHHtTwIn1f4p1CObdCjisHYS75JC (0μs)forget
          • 1 x missed XUQQAC2WMU7uaHHtTwIn1f4p1CObdCjisHYS75JC (0%)
            0μs
            30 x hit c_config (0%)
            0μs
            1 x written XUQQAC2WMU7uaHHtTwIn1f4p1CObdCjisHYS75JC (0%)
            0μs
          _token
          1xKNMZ4EDA7y93M0s3H9EjR0SGyScl0PGAPAL8Ty
          _previous
          array:1 [ "url" => "https://staging.freepokernetwork.com/venues/6-paupers-tavern-restaurant" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /venues/6-paupers-tavern-restaurant
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "host" => array:1 [ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 06 May 2025 04:46:05 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFaaittc2F5NzQzamxOYkZIbForU3c9PSIsInZhbHVlIjoiV0NBMzBwc2t3OWtNa21kbGZGRXk1KzRJVHZQaUdLRmJydlVPR1hGZEVZMms1L3drTWQvd0JPb3doQ1AxZit3OEc3cSt4a1NXbXEvLzZPQ0ZGV3liNDU5Nlh1bnFWcmNzN0dvNG56bGhKOTB2Um4vSFJxRS9uUXR1elpQcWRkTVQiLCJtYWMiOiIzNGNkZjgwM2I5NGRjMWIwNmY2Mjk3ZWJmMWE4YjJkMDgxNDIyZWNiMWVhNjI5MDgzNGEyYTQ0OGIxMmIwZDU4IiwidGFnIjoiIn0%3D; expires=Wed, 06 May 2026 04:46:05 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImFaaittc2F5NzQzamxOYkZIbForU3c9PSIsInZhbHVlIjoiV0NBMzBwc2t3OWtNa21kbGZGRXk1KzRJVHZQaUdLRmJydlVPR1hGZEVZMms1L3drTWQvd0JPb3doQ1AxZit3OEc3cSt4a" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImdGTHgvZjNxemNvQzdZd1BGM2R3bGc9PSIsInZhbHVlIjoiVHMxT3E5WWRzNmhvb0VhWU5QRVFMZ3JlZlg1OU9kZE1TaXB1N0pjLytla2ZoVWRjNnJwRWJxR2g4clVmT1NNNUFWWE5UOG9RSHBkYlYzTlM0dkphY0N0M0JNZ2RYNTk4N2gweHpycEVXODF0S3J5YTl0OUhvTmlwN293bWhlTWMiLCJtYWMiOiIyMjdhYmIzODg1NTllMjI2MmUxMmNmMmU3ZDZjZGVlMDcwYjIwMTVhN2Q4MzcxMmZiNjc5NGE0MWFhNmNmY2ZlIiwidGFnIjoiIn0%3D; expires=Wed, 06 May 2026 04:46:05 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6ImdGTHgvZjNxemNvQzdZd1BGM2R3bGc9PSIsInZhbHVlIjoiVHMxT3E5WWRzNmhvb0VhWU5QRVFMZ3JlZlg1OU9kZE1TaXB1N0pjLytla2ZoVWRjNnJwRWJ" 2 => "RSVP_status=eyJpdiI6InQxNmZ5cHA4akxnYlI4aGFtaWhxcXc9PSIsInZhbHVlIjoiYXJtNjA1TDZkYXAreXMyT2NVNDNIOHpxc05ManU0cS9FNDQvbXlnUjZ3UXBtTGhpRWFrdzJiRmxocW0yTlNvZyIsIm1hYyI6ImZlNTg0MDMwZTMyZjYzZjY3NGE1OTZjZDc5ODhlY2UzMzIyNjcxNjA4NDMzZTY5Nzk5YTI3ZDk0MjliODllNTUiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 07 May 2020 04:46:04 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6InQxNmZ5cHA4akxnYlI4aGFtaWhxcXc9PSIsInZhbHVlIjoiYXJtNjA1TDZkYXAreXMyT2NVNDNIOHpxc05ManU0cS9FNDQvbXlnUjZ3UXBtTGhpRWFrdzJiRmxocW0yTlNvZyIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFaaittc2F5NzQzamxOYkZIbForU3c9PSIsInZhbHVlIjoiV0NBMzBwc2t3OWtNa21kbGZGRXk1KzRJVHZQaUdLRmJydlVPR1hGZEVZMms1L3drTWQvd0JPb3doQ1AxZit3OEc3cSt4a1NXbXEvLzZPQ0ZGV3liNDU5Nlh1bnFWcmNzN0dvNG56bGhKOTB2Um4vSFJxRS9uUXR1elpQcWRkTVQiLCJtYWMiOiIzNGNkZjgwM2I5NGRjMWIwNmY2Mjk3ZWJmMWE4YjJkMDgxNDIyZWNiMWVhNjI5MDgzNGEyYTQ0OGIxMmIwZDU4IiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:46:05 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImFaaittc2F5NzQzamxOYkZIbForU3c9PSIsInZhbHVlIjoiV0NBMzBwc2t3OWtNa21kbGZGRXk1KzRJVHZQaUdLRmJydlVPR1hGZEVZMms1L3drTWQvd0JPb3doQ1AxZit3OEc3cSt4a" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImdGTHgvZjNxemNvQzdZd1BGM2R3bGc9PSIsInZhbHVlIjoiVHMxT3E5WWRzNmhvb0VhWU5QRVFMZ3JlZlg1OU9kZE1TaXB1N0pjLytla2ZoVWRjNnJwRWJxR2g4clVmT1NNNUFWWE5UOG9RSHBkYlYzTlM0dkphY0N0M0JNZ2RYNTk4N2gweHpycEVXODF0S3J5YTl0OUhvTmlwN293bWhlTWMiLCJtYWMiOiIyMjdhYmIzODg1NTllMjI2MmUxMmNmMmU3ZDZjZGVlMDcwYjIwMTVhN2Q4MzcxMmZiNjc5NGE0MWFhNmNmY2ZlIiwidGFnIjoiIn0%3D; expires=Wed, 06-May-2026 04:46:05 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6ImdGTHgvZjNxemNvQzdZd1BGM2R3bGc9PSIsInZhbHVlIjoiVHMxT3E5WWRzNmhvb0VhWU5QRVFMZ3JlZlg1OU9kZE1TaXB1N0pjLytla2ZoVWRjNnJwRWJ" 2 => "RSVP_status=eyJpdiI6InQxNmZ5cHA4akxnYlI4aGFtaWhxcXc9PSIsInZhbHVlIjoiYXJtNjA1TDZkYXAreXMyT2NVNDNIOHpxc05ManU0cS9FNDQvbXlnUjZ3UXBtTGhpRWFrdzJiRmxocW0yTlNvZyIsIm1hYyI6ImZlNTg0MDMwZTMyZjYzZjY3NGE1OTZjZDc5ODhlY2UzMzIyNjcxNjA4NDMzZTY5Nzk5YTI3ZDk0MjliODllNTUiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 07-May-2020 04:46:04 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6InQxNmZ5cHA4akxnYlI4aGFtaWhxcXc9PSIsInZhbHVlIjoiYXJtNjA1TDZkYXAreXMyT2NVNDNIOHpxc05ManU0cS9FNDQvbXlnUjZ3UXBtTGhpRWFrdzJiRmxocW0yTlNvZyIsIm1h" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "1xKNMZ4EDA7y93M0s3H9EjR0SGyScl0PGAPAL8Ty" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/venues/6-paupers-tavern-restaurant" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-05 23:46:05GET/venues/6-paupers-tavern-restaurant4820441832