8
Avg. Attendees
420 Points
Leading

0
Avg. Attendees

League Inactive
Past Season: Winter 2025
1439 Points
League Champ
Past Season: Fall 2024
1039 Points
League Champ
Past Season: Summer 2024
1266 Points
League Champ
Past Season: Spring 2024
1512 Points
League Champ
Past Season: Summer 2024
1063 Points
League Champ
Past Season: Spring 2024
1407 Points
League Champ
Past Season: Winter 2024
1437 Points
League Champ
Past Season: Fall 2023
1119 Points
League Champ
Past Season: Winter 2024
1584 Points
League Champ
Past Season: Fall 2023
1752 Points
League Champ
Past Season: Summer
1509 Points
League Champ
Past Season: Spring
1778 Points
League Champ
Past Season: Winter
1655 Points
League Champ
Past Season: Summer
1819 Points
League Champ
Past Season: Spring
1577 Points
League Champ
Past Season: Winter
1403 Points
League Champ

Venue

6405 W 127th St, Palos Heights, IL, 60463
Phone: (708) 824-9600
Request history8.3.16PHP Version1.94sRequest Duration12MBMemory UsageGET venues/{alias}Route
    • Booting (42.76ms)time
    • Application (1.89s)time
    • 1 x Application (97.79%)
      1.89s
      1 x Booting (2.21%)
      42.76ms
      57 templates were rendered
      • 1x site.league.indexindex.blade.php#?blade
      • 1x site.includes.home_become_a_host_section_content_defaulthome_become_a_host_section_content_default.blade.php#?blade
      • 1x components.site.breadcrumb-itembreadcrumb-item.blade.php#?blade
      • 1x components.site.breadcrumbsbreadcrumbs.blade.php#?blade
      • 29x components.lazyload-imagelazyload-image.blade.php#?blade
      • 1x site.includes.qualifier_tournamentsqualifier_tournaments.blade.php#?blade
      • 1x site.includes.qualifier_tournaments.multiple_qualifiersmultiple_qualifiers.blade.php#?blade
      • 3x site.includes.social_sharesocial_share.blade.php#?blade
      • 1x site.league.index_gridindex_grid.blade.php#?blade
      • 4x components.lazyload-background-imagelazyload-background-image.blade.php#?blade
      • 1x pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • 1x site.includes.venue_map_locationvenue_map_location.blade.php#?blade
      • 1x site.articles.card.right_section_related_newsright_section_related_news.blade.php#?blade
      • 1x site.layouts.appapp.blade.php#?blade
      • 1x site.includes.headerheader.blade.php#?blade
      • 1x flash::messagemessage.blade.php#?blade
      • 1x site.includes.code_of_conductcode_of_conduct.blade.php#?blade
      • 1x site.includes.footerfooter.blade.php#?blade
      • 1x site.includes.footer_modules.dpt_infodpt_info.blade.php#?blade
      • 1x site.includes.footer_modules.social_mediasocial_media.blade.php#?blade
      • 1x site.includes.footer_modules.about_dptabout_dpt.blade.php#?blade
      • 1x site.includes.footer_modules.quick_linkquick_link.blade.php#?blade
      • 1x site.includes.footer_modules.fpn_contactfpn_contact.blade.php#?blade
      • 1x 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
      328 statements were executed (291 duplicates)Show only duplicatesfpnstaging1.49s
      • # Query soft limit for Debugbar is reached after 100 queries, additional 228 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#786fpnstaging2.2msselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-04' order by `start_date` asc
        Bindings
        • 0: 2025-05-04
        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.75msselect * from `fpn_promotions` where FIND_IN_SET(22, season_id) limit 1
        Bindings
        • 0: 22
        Backtrace
        • app/Models/League.php:793
        • app/Http/Controllers/Site/LeagueController.php:58
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • LeagueController.php#62fpnstaging1.91msselect * from `fpn_venues` where `status` = '1' and `alias` = 'x-s-o-s-sports-bar-palos-heights' limit 1
        Bindings
        • 0: 1
        • 1: x-s-o-s-sports-bar-palos-heights
        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#70fpnstaging1.25msselect count(*) as aggregate from `fpn_leagues` where `venue_id` = 90
        Bindings
        • 0: 90
        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#200fpnstaging181msselect `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('90', 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#55fpnstaging570μ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#95fpnstaging620μ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#252fpnstaging710μ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` = 73231 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 73231
        • 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#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#95fpnstaging690μ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#252fpnstaging910μ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` = 71023 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 71023
        • 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#55fpnstaging520μ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#95fpnstaging510μ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.71msselect `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` = 57495 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 57495
        • 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#55fpnstaging480μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = '23' limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Services/ConfigSevice.php:55
        • app/Services/QualifierService.php:230
        • app/Http/Controllers/Site/LeagueController.php:78
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ConfigSevice.php#95fpnstaging560μ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#252fpnstaging1.67msselect `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` = 42080 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 42080
        • 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#135fpnstaging680μ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#143fpnstaging770μ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#252fpnstaging1.76msselect `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` = 16664 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 16664
        • 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#208fpnstaging530μ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#55fpnstaging520μsselect `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#95fpnstaging590μ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#252fpnstaging1.73msselect `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` = 20214 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 20214
        • 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#208fpnstaging610μ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#55fpnstaging580μsselect `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#95fpnstaging570μ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#252fpnstaging1.57msselect `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` = 20213 and `rank` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 limit 1
        Bindings
        • 0: 20213
        • 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#786fpnstaging800μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-04' order by `start_date` asc
        Bindings
        • 0: 2025-05-04
        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#793fpnstaging11.04msselect * 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#793fpnstaging11.19msselect * 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.15msselect `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-04 18:45: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` = 90 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`start_date` asc
        Bindings
        • 0: 2025-05-04 18:45:00
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: 5
        • 5: 90
        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#71fpnstaging610μsselect `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#111fpnstaging500μ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:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1967fpnstaging790μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1184 limit 1
        Bindings
        • 0: 1184
        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#1972fpnstaging630μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-04 18:45:42' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04 18:45:42
        • 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#2241fpnstaging1.36msselect * from `fpn_tournaments` where `event_id` = 1184 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-04' order by `start_date` desc limit 1
        Bindings
        • 0: 1184
        • 1: 1
        • 2: 2025-05-04
        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#2295fpnstaging850μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 1184 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-04'
        Bindings
        • 0: 1184
        • 1: 1
        • 2: 2025-05-04
        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#1061fpnstaging520μ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#1070fpnstaging550μ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#917fpnstaging550μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') and date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04
        • 3: 2025-05-04
        • 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#2057fpnstaging760μsselect * from `fpn_leagues` where `id` = 1184 limit 1
        Bindings
        • 0: 1184
        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#2058fpnstaging8.66msselect * 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#2060fpnstaging22.51msselect 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` = 1184 and `status` = 1
        Bindings
        • 0: 1184
        • 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#2062fpnstaging21.64msselect 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` = 1184 and `status` = 1
        Bindings
        • 0: 1184
        • 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#2065fpnstaging620μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `id` in ('21', '22') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-04
        • 1: 2025-05-04
        • 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#2101fpnstaging990μsselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where date(`fpn_tournaments`.`start_date`) >= '2025-04-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2025-06-30 00:00:00' and `fpn_tournaments`.`event_id` = 1184 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: 1184
        • 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#2108fpnstaging26.2msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 1184 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 1184
        • 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.63msselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where `tournament_id` in (67083, 67084) group by `tournament_players`.`user_id` order by `score` desc limit 1
        Bindings
        • 0: 67083
        • 1: 67084
        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#2117fpnstaging910μsselect * from `users` where `users`.`id` = 1732 limit 1
        Bindings
        • 0: 1732
        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#140fpnstaging650μsselect `league_status` from `fpn_leagues` where `id` = 1184 limit 1
        Bindings
        • 0: 1184
        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
      • ConfigSevice.php#71fpnstaging650μsselect `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#111fpnstaging660μ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:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#1967fpnstaging640μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1185 limit 1
        Bindings
        • 0: 1185
        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#1972fpnstaging610μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-04 18:45:42' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04 18:45:42
        • 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#2241fpnstaging1.93msselect * from `fpn_tournaments` where `event_id` = 1185 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-04' order by `start_date` desc limit 1
        Bindings
        • 0: 1185
        • 1: 1
        • 2: 2025-05-04
        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#2295fpnstaging860μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 1185 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-04'
        Bindings
        • 0: 1185
        • 1: 1
        • 2: 2025-05-04
        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#1061fpnstaging460μ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#1070fpnstaging600μ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#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:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#917fpnstaging610μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') and date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04
        • 3: 2025-05-04
        • 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#2057fpnstaging2.2msselect * from `fpn_leagues` where `id` = 1185 limit 1
        Bindings
        • 0: 1185
        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#2058fpnstaging7.46msselect * 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#2060fpnstaging22.23msselect 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` = 1185 and `status` = 1
        Bindings
        • 0: 1185
        • 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#2062fpnstaging18.3msselect 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` = 1185 and `status` = 1
        Bindings
        • 0: 1185
        • 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#2065fpnstaging720μsselect * from `fpn_season` where date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `id` in ('21', '22') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-04
        • 1: 2025-05-04
        • 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.08msselect `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` = 1185 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: 1185
        • 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#2108fpnstaging19.78msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 1185 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 1185
        • 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#2113fpnstaging660μsselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where 0 = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:87
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueSevice.php#140fpnstaging590μsselect `league_status` from `fpn_leagues` where `id` = 1185 limit 1
        Bindings
        • 0: 1185
        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#786fpnstaging940μsselect * from `fpn_season` where date(`fpn_season`.`end_date`) >= '2025-05-04' order by `start_date` asc
        Bindings
        • 0: 2025-05-04
        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#793fpnstaging11.89msselect * 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#793fpnstaging11.34msselect * 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#997fpnstaging161msselect `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-04 18:45: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` = 90 group by `fpn_leagues`.`id` order by `fpn_tournaments`.`end_date` desc
        Bindings
        • 0: 2025-05-04 18:45:00
        • 1: 1
        • 2: 1
        • 3: 5
        • 4: 90
        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#71fpnstaging610μsselect `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#111fpnstaging490μ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` = 1185 limit 1
        Bindings
        • 0: 1185
        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#1972fpnstaging680μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-04 18:45:42' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04 18:45:42
        • 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.1msselect * from `fpn_tournaments` where `event_id` = 1185 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-04' order by `start_date` desc limit 1
        Bindings
        • 0: 1185
        • 1: 1
        • 2: 2025-05-04
        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#2295fpnstaging1.69msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = 1185 and `status` = 1 and date(`fpn_tournaments`.`end_date`) > '2025-05-04'
        Bindings
        • 0: 1185
        • 1: 1
        • 2: 2025-05-04
        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#1061fpnstaging440μ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#1070fpnstaging470μ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#906fpnstaging420μ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#917fpnstaging480μsselect `id`, `name`, `start_date`, `end_date` from `fpn_season` where `id` in ('21', '22') and date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `status` = 1 order by `start_date` desc limit 1
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04
        • 3: 2025-05-04
        • 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#2057fpnstaging570μsselect * from `fpn_leagues` where `id` = 1185 limit 1
        Bindings
        • 0: 1185
        Backtrace
        • app/Models/League.php:2057
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • League.php#2058fpnstaging5.95msselect * 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.34msselect 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` = 1185 and `status` = 1
        Bindings
        • 0: 1185
        • 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#2062fpnstaging19.34msselect 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` = 1185 and `status` = 1
        Bindings
        • 0: 1185
        • 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#2065fpnstaging1.27msselect * from `fpn_season` where date(`start_date`) <= '2025-05-04' and date(`end_date`) >= '2025-05-04' and `id` in ('21', '22') and `status` = 1 limit 1
        Bindings
        • 0: 2025-05-04
        • 1: 2025-05-04
        • 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#2101fpnstaging980μsselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where date(`fpn_tournaments`.`start_date`) >= '2025-04-01 00:00:00' and date(`fpn_tournaments`.`end_date`) <= '2025-06-30 00:00:00' and `fpn_tournaments`.`event_id` = 1185 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: 1185
        • 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#2108fpnstaging20.65msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = 1185 and `fpn_tournaments`.`status` = 1 group by `tournament_players`.`tournament_id`
        Bindings
        • 0: 1185
        • 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#2113fpnstaging400μsselect SUM(tournament_players.score) as score,tournament_players.user_id from `tournament_players` where 0 = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
        Backtrace
        • app/Models/League.php:2113
        • app/Http/Controllers/Site/LeagueController.php:2305
        • app/Http/Controllers/Site/LeagueController.php:88
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • LeagueSevice.php#140fpnstaging410μsselect `league_status` from `fpn_leagues` where `id` = 1185 limit 1
        Bindings
        • 0: 1185
        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#71fpnstaging2.05msselect `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#111fpnstaging700μ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#1967fpnstaging970μsselect `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1184 limit 1
        Bindings
        • 0: 1184
        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#1972fpnstaging890μsselect * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-04 18:45:42' and `status` = 1 order by `start_date` desc
        Bindings
        • 0: 21
        • 1: 22
        • 2: 2025-05-04 18:45:42
        • 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.27msselect * from `fpn_tournaments` where `event_id` = 1184 and `status` = 1 and date(`fpn_tournaments`.`start_date`) >= '2025-05-04' order by `start_date` desc limit 1
        Bindings
        • 0: 1184
        • 1: 1
        • 2: 2025-05-04
        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
      • fpnstaging940μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging380μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging510μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging1msselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging790μ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
      • fpnstaging920μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging7msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging21.72msselect 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` = ?
      • fpnstaging23.53msselect 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` = ?
      • fpnstaging1.06msselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.15msselect `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`
      • fpnstaging18.6msselect `tournament_players`.`tournament_id` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`event_id` = ? and `fpn_tournaments`.`status` = ? group by `tournament_players`.`tournament_id`
      • fpnstaging900μsselect 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
      • fpnstaging800μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging410μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging490μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging480μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging440μ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
      • fpnstaging510μsselect * from `fpn_season` where `id` in (?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging1.01msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging13.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.81msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging8.36msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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.68msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging1msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging610μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging840μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging570μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging560μ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
      • fpnstaging740μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging14.78msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging15.23msselect 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.85msselect 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` = ?
      • fpnstaging790μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging740μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.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`) >= ? 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`
      • fpnstaging14.37msselect `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.42msselect 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
      • fpnstaging630μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging1.2msselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging1.15msselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging730μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging580μ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
      • fpnstaging650μsselect * from `fpn_season` where `id` in (?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging860μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging3.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
      • fpnstaging880μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging7.44msselect `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
      • fpnstaging2.28msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging1.83msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging1.54msselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging960μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging860μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging580μ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
      • fpnstaging740μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging31.41msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging19.93msselect 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` = ?
      • fpnstaging21.24msselect 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` = ?
      • fpnstaging800μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging580μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.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`) >= ? 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`
      • fpnstaging16.82msselect `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.35msselect 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
      • fpnstaging760μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging640μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging900μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging920μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging610μ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
      • fpnstaging680μsselect * from `fpn_season` where `id` in (?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging800μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging9.66msselect `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
      • fpnstaging850μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging9.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
      • fpnstaging1.56msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging930μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging540μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging540μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging480μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging590μ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
      • fpnstaging780μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging8.02msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging20.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` = ? and `status` = ?
      • fpnstaging18.73msselect 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` = ?
      • fpnstaging720μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging580μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.3msselect `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`
      • fpnstaging17.39msselect `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.12msselect 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
      • fpnstaging790μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging510μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging660μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging720μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging620μ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
      • fpnstaging790μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.47msselect `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
      • fpnstaging840μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging7.89msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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.46msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging780μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging530μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging540μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging510μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging610μ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
      • fpnstaging760μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging7.7msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging19.9msselect 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.67msselect 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` = ?
      • fpnstaging630μ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
      • fpnstaging1.11msselect `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`
      • fpnstaging13.36msselect `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.76msselect 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
      • fpnstaging430μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging520μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging470μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging610μ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
      • fpnstaging640μsselect * from `fpn_season` where `id` in (?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging630μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging11.37msselect `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
      • fpnstaging870μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging7.51msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = ? 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.36msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging590μsselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging470μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging530μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?) order by `start_date` asc
      • fpnstaging460μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging610μ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
      • fpnstaging650μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging5.95msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging10.37msselect 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` = ?
      • fpnstaging9.56msselect 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.12msselect `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`
      • fpnstaging8.28msselect `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`
      • fpnstaging1.96msselect 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
      • fpnstaging610μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging410μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging580μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging630μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging480μ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
      • fpnstaging820μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging13.75msselect `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
      • fpnstaging970μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging10.56msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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.26msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging1.03msselect count(*) as aggregate from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`end_date`) > ?
      • fpnstaging440μ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
      • fpnstaging730μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging560μ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
      • fpnstaging730μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging5.84msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging11.75msselect 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` = ?
      • fpnstaging9.63msselect 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` = ?
      • fpnstaging690μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging530μsselect * from `fpn_season` where date(`end_date`) < ? and `id` in (?, ?) and `status` = ? limit 1
      • fpnstaging1.14msselect `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`
      • fpnstaging7.87msselect `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.62msselect 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
      • fpnstaging750μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging920μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging630μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging850μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging550μ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
      • fpnstaging700μsselect * from `fpn_season` where `id` in (?, ?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging1.02msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging5.49msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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
      • fpnstaging950μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging6.97msselect `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.09msselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging7.83msselect `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.58msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging740μsselect 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
      • fpnstaging500μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?, ?) order by `start_date` asc
      • fpnstaging470μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging1.2msselect `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
      • fpnstaging1.19msselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging20.11msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging8.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` = ? and `status` = ?
      • fpnstaging7.47msselect 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` = ?
      • fpnstaging790μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?, ?) and `status` = ? limit 1
      • fpnstaging750μ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`
      • fpnstaging5.4msselect `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.14msselect 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
      • fpnstaging800μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging490μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging560μsselect `icons_badges` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging510μsselect `icons_badges_tooltip` from `fpn_promotions` where `fpn_promotions`.`id` = ? limit 1
      • fpnstaging470μ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
      • fpnstaging550μsselect * from `fpn_season` where `id` in (?, ?, ?) and `end_date` < ? and `status` = ? order by `start_date` desc
      • fpnstaging660μsselect `id` from `fpn_tournaments` where `event_id` = ? and date(`start_date`) >= ? and date(`end_date`) <= ?
      • fpnstaging8.66msselect `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`) <= ?
      • fpnstaging8.42msselect `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`) <= ?
      • fpnstaging16.7msselect `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname` 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.42msselect * from `fpn_tournaments` where `event_id` = ? and `status` = ? and date(`fpn_tournaments`.`start_date`) >= ? order by `start_date` desc limit 1
      • fpnstaging670μ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
      • fpnstaging450μsselect `name`, `start_date`, `end_date` from `fpn_season` where `id` in (?, ?, ?) order by `start_date` asc
      • fpnstaging440μsselect `fpn_promotions`.`season_id` as `season_ids` from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging490μ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
      • fpnstaging730μsselect * from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging14.8msselect * from `fpn_promotions` where `id` = ? limit 1
      • fpnstaging11.64msselect 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` = ?
      • fpnstaging7.77msselect 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` = ?
      • fpnstaging820μsselect * from `fpn_season` where date(`start_date`) <= ? and date(`end_date`) >= ? and `id` in (?, ?, ?) and `status` = ? limit 1
      • fpnstaging510μ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`
      • 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.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
      • fpnstaging930μsselect * from `users` where `users`.`id` = ? limit 1
      • fpnstaging810μsselect `league_status` from `fpn_leagues` where `id` = ? limit 1
      • fpnstaging6.35msselect * from `fpn_venues` where `status` = ?
      • fpnstaging1.14msselect * from `fpn_regions` where `status` = ? order by `name` asc
      • fpnstaging750μsselect * from `fpn_venues` where `status` = ? and `id` = ? limit 1
      • fpnstaging1.11msselect `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
      • fpnstaging1.45msselect count(*) as aggregate from `articles` where `status` = ? and `category_id` is not null and `venue_id` = ?
      • fpnstaging1.19msselect * from `articles` where `status` = ? and `category_id` is not null and `venue_id` = ? order by `published_at` desc limit 6
      • fpnstaging580μsselect `default_article_image` from `configurations`
      • fpnstaging740μsselect * from `fpn_venues` where `id` = ? limit 1
      • fpnstaging460μsselect `featured_hosts` from `fpn_venues` where `id` = ? limit 1
      App\Models\Venue
      259Venue.php#?
      App\Models\Promotion
      94Promotion.php#?
      App\Models\Season
      66Season.php#?
      App\Models\League
      24League.php#?
      App\Models\Region
      19Region.php#?
      App\Models\TournamentPlayer
      15TournamentPlayer.php#?
      App\Models\Tournament
      11Tournament.php#?
      App\Models\User
      10User.php#?
      App\Models\Article
      6Article.php#?
          • missed eJ3LeN34YFvU6DytLEGvMniWk48hnP18wumO2XYv (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
          • 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 eJ3LeN34YFvU6DytLEGvMniWk48hnP18wumO2XYv (0μs)forget
          • 1 x missed eJ3LeN34YFvU6DytLEGvMniWk48hnP18wumO2XYv (0%)
            0μs
            44 x hit c_config (0%)
            0μs
            1 x written eJ3LeN34YFvU6DytLEGvMniWk48hnP18wumO2XYv (0%)
            0μs
          _token
          OcBQvUNQeDVwCmm27VgQMrirDKA1w7vF9oZmJQzL
          _previous
          array:1 [ "url" => "https://staging.freepokernetwork.com/venues/x-s-o-s-sports-bar-palos-heights" ...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /venues/x-s-o-s-sports-bar-palos-heights
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "host" => array:1 [ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 04 May 2025 23:45:43 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImgwL2lsRmgzTERWN014YjVPY1BDdkE9PSIsInZhbHVlIjoiMi8wSjY2ZjlBbWRObWl4ZExwU2Z4MmFVSVZBU0h5V2ZuYUE0L2RSVjR1NHVoTVluZFh2ZXltaUVqNVNwL01qUXlibkRmWE1NSmJ6RHZ1d3dYbkVrTUkyZ3ZZVTZnUlNDajhEYmw4U3R3a1ZuN0FCV2tNWFlWQVVDTTZVSk5XMEoiLCJtYWMiOiJjMTA3YmFkNTJmNmUzZDYwN2M5MWRmMzNkZGIzMzhhNjYzNWVlNzc1MjBhZWQ3NDM0MzA4N2EzMDM4NmVlZDdmIiwidGFnIjoiIn0%3D; expires=Mon, 04 May 2026 23:45:43 GMT; Max-Age=31536000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImgwL2lsRmgzTERWN014YjVPY1BDdkE9PSIsInZhbHVlIjoiMi8wSjY2ZjlBbWRObWl4ZExwU2Z4MmFVSVZBU0h5V2ZuYUE0L2RSVjR1NHVoTVluZFh2ZXltaUVqNVNwL01qUXlibkRmW" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImQ5VFVISTZ1ZWZKOXc4NWp0V3R2Y1E9PSIsInZhbHVlIjoielA5aHZYWndyV2hBMzcwR2loWmQzOTZHdGExTnk4VUpsQUY1VkI1V0pEakdjUlJodTBqRzd5OVFMN0Z1NHI5QzJPeUN5aStqampjQk1PSllmYXVpaHErWU5yNjV4OWIvWnNua1l5Q2thK0xtMm0vZjg3U1RucUttUDVQajd2ZGoiLCJtYWMiOiJkNjQ1ZWMwOWI1NTQ2NGYxNjBjNTE5ZTU5YjA2NzZhZWE5YzMzZWM1ODI1MTc4YzdhMjVlMzcxYTMzODUyM2UyIiwidGFnIjoiIn0%3D; expires=Mon, 04 May 2026 23:45:43 GMT; Max-Age=31536000; path=/; httponly; samesite=laxfreepokernetwork_upgrade_session=eyJpdiI6ImQ5VFVISTZ1ZWZKOXc4NWp0V3R2Y1E9PSIsInZhbHVlIjoielA5aHZYWndyV2hBMzcwR2loWmQzOTZHdGExTnk4VUpsQUY1VkI1V0pEakdjUlJodTBqRzd" 2 => "RSVP_status=eyJpdiI6IlRTOEdweGZTdGJQS3JQSlRpUFh3YWc9PSIsInZhbHVlIjoiMUlZa0NsWTFYbDhnMDhKZmorbEpNTG5INDBpckJkUFU1Y0F0Wjc1dC8wTk9hUnJLY3hjalhQYmlYWFVYYzBQMCIsIm1hYyI6ImQwZDg0ZmI2NDJmNzRlYjNjZmJkMmEwZjMyMTIzM2FiNDY1MzlkMDQxZTQ0N2JjZjFiOThhZjkxMjYzMDFkMTkiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 05 May 2020 23:45:41 GMT; Max-Age=0; path=/; secure; httponly; samesite=laxRSVP_status=eyJpdiI6IlRTOEdweGZTdGJQS3JQSlRpUFh3YWc9PSIsInZhbHVlIjoiMUlZa0NsWTFYbDhnMDhKZmorbEpNTG5INDBpckJkUFU1Y0F0Wjc1dC8wTk9hUnJLY3hjalhQYmlYWFVYYzBQMCIsIm1h" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImgwL2lsRmgzTERWN014YjVPY1BDdkE9PSIsInZhbHVlIjoiMi8wSjY2ZjlBbWRObWl4ZExwU2Z4MmFVSVZBU0h5V2ZuYUE0L2RSVjR1NHVoTVluZFh2ZXltaUVqNVNwL01qUXlibkRmWE1NSmJ6RHZ1d3dYbkVrTUkyZ3ZZVTZnUlNDajhEYmw4U3R3a1ZuN0FCV2tNWFlWQVVDTTZVSk5XMEoiLCJtYWMiOiJjMTA3YmFkNTJmNmUzZDYwN2M5MWRmMzNkZGIzMzhhNjYzNWVlNzc1MjBhZWQ3NDM0MzA4N2EzMDM4NmVlZDdmIiwidGFnIjoiIn0%3D; expires=Mon, 04-May-2026 23:45:43 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImgwL2lsRmgzTERWN014YjVPY1BDdkE9PSIsInZhbHVlIjoiMi8wSjY2ZjlBbWRObWl4ZExwU2Z4MmFVSVZBU0h5V2ZuYUE0L2RSVjR1NHVoTVluZFh2ZXltaUVqNVNwL01qUXlibkRmW" 1 => "freepokernetwork_upgrade_session=eyJpdiI6ImQ5VFVISTZ1ZWZKOXc4NWp0V3R2Y1E9PSIsInZhbHVlIjoielA5aHZYWndyV2hBMzcwR2loWmQzOTZHdGExTnk4VUpsQUY1VkI1V0pEakdjUlJodTBqRzd5OVFMN0Z1NHI5QzJPeUN5aStqampjQk1PSllmYXVpaHErWU5yNjV4OWIvWnNua1l5Q2thK0xtMm0vZjg3U1RucUttUDVQajd2ZGoiLCJtYWMiOiJkNjQ1ZWMwOWI1NTQ2NGYxNjBjNTE5ZTU5YjA2NzZhZWE5YzMzZWM1ODI1MTc4YzdhMjVlMzcxYTMzODUyM2UyIiwidGFnIjoiIn0%3D; expires=Mon, 04-May-2026 23:45:43 GMT; path=/; httponlyfreepokernetwork_upgrade_session=eyJpdiI6ImQ5VFVISTZ1ZWZKOXc4NWp0V3R2Y1E9PSIsInZhbHVlIjoielA5aHZYWndyV2hBMzcwR2loWmQzOTZHdGExTnk4VUpsQUY1VkI1V0pEakdjUlJodTBqRzd" 2 => "RSVP_status=eyJpdiI6IlRTOEdweGZTdGJQS3JQSlRpUFh3YWc9PSIsInZhbHVlIjoiMUlZa0NsWTFYbDhnMDhKZmorbEpNTG5INDBpckJkUFU1Y0F0Wjc1dC8wTk9hUnJLY3hjalhQYmlYWFVYYzBQMCIsIm1hYyI6ImQwZDg0ZmI2NDJmNzRlYjNjZmJkMmEwZjMyMTIzM2FiNDY1MzlkMDQxZTQ0N2JjZjFiOThhZjkxMjYzMDFkMTkiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 05-May-2020 23:45:41 GMT; path=/; secure; httponlyRSVP_status=eyJpdiI6IlRTOEdweGZTdGJQS3JQSlRpUFh3YWc9PSIsInZhbHVlIjoiMUlZa0NsWTFYbDhnMDhKZmorbEpNTG5INDBpckJkUFU1Y0F0Wjc1dC8wTk9hUnJLY3hjalhQYmlYWFVYYzBQMCIsIm1h" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "OcBQvUNQeDVwCmm27VgQMrirDKA1w7vF9oZmJQzL" "_previous" => array:1 [ "url" => "https://staging.freepokernetwork.com/venues/x-s-o-s-sports-bar-palos-heights" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-04 18:45:43GET/venues/x-s-o-s-sports-bar-palos-heights5732850446