順位

TOP 順位

2025 Blue Wave Growing up League U-16 九州

最終更新日: 2025-07-22 18:42:32
<<　スワイプでご覧いただけます。　>>
順位 チーム名 勝点 試合数 勝数 敗数 得点 失点 得失点差
1 筑前 12 5 4 1 11 6 5
2 福智 11 5 3 0 14 6 8
3 新宮 10 5 3 1 17 6 11
4 佐世保実業 9 4 3 1 14 5 9
5 香椎工業 9 4 3 1 9 6 3
6 近大福岡 6 4 2 2 21 5 16
7 福岡西陵 4 5 1 3 10 12 -2
8 福工大城東 3 4 0 1 3 9 -6
9 鳥栖工業 1 5 0 4 0 25 -25
10 佐賀農業 0 5 0 5 4 23 -19

2025 Blue Wave Growing up League U-16 関西 グループA

最終更新日: 2025-07-23 20:13:48
<<　スワイプでご覧いただけます。　>>
順位 チーム名 勝点 試合数 勝数 敗数 PK勝 PK負 得点 失点 得失点差
1 河南 14 5 3 1 1 0 8 5 3
2 羽衣学園 13 4 3 0 0 1 21 2 19
3 近大新宮 8 4 2 2 0 0 14 16 -2
4 千里 8 4 2 2 0 0 5 10 -5
5 城陽 4 3 1 2 0 0 3 4 -1
6 桜宮 4 2 1 1 0 0 1 3 -2
7 畝傍 0 4 0 4 0 0 2 14 -12

2025 Blue Wave Growing up League U-16 関西 グループB

最終更新日: 2025-07-22 21:27:14
<<　スワイプでご覧いただけます。　>>
順位 チーム名 勝点 試合数 勝数 敗数 PK勝 PK負 得点 失点 得失点差
1 大体大浪商 16 4 4 0 0 0 29 2 27
2 三田松聖 16 4 4 0 0 0 19 3 16
3 大冠 12 5 3 2 0 0 14 10 4
4 比叡山 8 5 2 3 0 0 6 9 -3
5 刀根山 4 3 1 2 0 0 4 11 -7
6 京都両洋 0 4 0 4 0 0 2 20 -18
7 五條 0 3 0 3 0 0 2 21 -19

2025 Blue Wave Growing up League U-16 中四国 グループA

最終更新日: 2025-07-24 13:42:22
<<　スワイプでご覧いただけます。　>>
順位 チーム名 勝点 試合数 勝数 敗数 PK勝 PK負 得点 失点 得失点差
1 新居浜東 9 3 2 0 0 1 6 2 4
2 小津 4 1 1 0 0 0 6 0 6
3 倉敷翠松 4 1 1 0 0 0 2 0 2
4 大洲 4 2 1 1 0 0 4 4 0
5 高松西 3 2 0 0 1 1 3 3 0
6 新居浜工業 2 4 0 3 1 0 4 13 -9
7 丸亀城西 0 1 0 1 0 0 1 4 -3

2025 Blue Wave Growing up League U-16 中四国 グループB

最終更新日: 2025-07-13 15:11:50
<<　スワイプでご覧いただけます。　>>
順位 チーム名 勝点 試合数 勝数 敗数 PK勝 PK負 得点 失点 得失点差
1 宇和島東 13 4 3 0 0 1 17 4 13
2 鳴門 12 4 3 1 0 0 21 4 17
3 東温 4 1 1 0 0 0 2 0 2
4 英明 4 3 1 2 0 0 3 8 -5
5 新居浜西 4 3 1 2 0 0 7 15 -8
6 藤井 2 1 0 0 1 0 1 1 0
7 観音寺総合 0 4 0 4 0 0 3 22 -19

関連情報

  • sports concierge office Blue Wave
  • 株式会社グリーンカード
MessagesTimelineExceptionsViews5RouteQueries36MailsAuthGateSessionRequest
118.69msRequest Duration8.75MBMemory UsageGET order/{group_id?}/{yyyy?}/{period?}RouteGuestAuth status
    • Booting (12.67ms)
    • Application (110.35ms)
      5 templates were rendered
      • front.league.order (resources/views/front/league/order.blade.php)11blade
        Params
        0
        groups_id
        1
        nav_on
        2
        leagues
        3
        resultObj
        4
        teamObj
        5
        yyyy
        6
        period
        7
        groups
        8
        groupings
        9
        g
        10
        default_period
      • front.parts.side (resources/views/front/parts/side.blade.php)22blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        leagues
        7
        resultObj
        8
        teamObj
        9
        yyyy
        10
        period
        11
        groups
        12
        groupings
        13
        g
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        i
      • layouts.front (resources/views/layouts/front.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        leagues
        7
        resultObj
        8
        teamObj
        9
        yyyy
        10
        period
        11
        groups
        12
        groupings
        13
        g
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        i
        22
        title
      • layouts.front.parts.header (resources/views/layouts/front/parts/header.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        leagues
        7
        resultObj
        8
        teamObj
        9
        yyyy
        10
        period
        11
        groups
        12
        groupings
        13
        g
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        i
        22
        title
      • layouts.front.parts.footer (resources/views/layouts/front/parts/footer.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        leagues
        7
        resultObj
        8
        teamObj
        9
        yyyy
        10
        period
        11
        groups
        12
        groupings
        13
        g
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        i
        22
        title
      uri
      GET order/{group_id?}/{yyyy?}/{period?}
      as
      front.order.index
      controller
      App\Http\Controllers\Front\PcLeagueController@order
      namespace
      App\Http\Controllers
      prefix
      null
      where
      file
      app/Http/Controllers/Front/PcLeagueController.php:36-163
      36 statements were executed, 4 of which were duplicated, 32 unique80.16ms
      greencard12_teamdb
      • select * from `groups` where `id` = '87' limit 1250μs/app/Http/Controllers/Front/PcLeagueController.php:58greencard12_teamdb
        Metadata
        Bindings
        • 0. 87
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. /app/Http/Controllers/Front/PcLeagueController.php:58
        • 61. /public/index.php:54
      • select * from `groups` where `convention` = '16' and `grouping` = '23' and `id` <> '66'110μs/app/Http/Controllers/Front/PcLeagueController.php:74greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        • 1. 23
        • 2. 66
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:74
        • 60. /public/index.php:54
      • select `id` from `groups` where `convention` = '16' and `grouping` = '23' and `id` <> '66'70μs/app/Http/Controllers/Front/PcLeagueController.php:76greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        • 1. 23
        • 2. 66
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:76
        • 60. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `convention` = '16' and `is_publish` = '2' and `year` = '2025' and `group_id` in ('65', '69', '84', '85', '86', '87')160μs/app/Http/Controllers/Front/PcLeagueController.php:82greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        • 1. 2
        • 2. 2025
        • 3. 65
        • 4. 69
        • 5. 84
        • 6. 85
        • 7. 86
        • 8. 87
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:82
        • 60. /public/index.php:54
      • select `id` from `leagues` where `leagues`.`deleted_at` is null and `convention` = '16' and `is_publish` = '2' and `year` = '2025' and `group_id` in ('65', '69', '84', '85', '86', '87')80μs/app/Http/Controllers/Front/PcLeagueController.php:84greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        • 1. 2
        • 2. 2025
        • 3. 65
        • 4. 69
        • 5. 84
        • 6. 85
        • 7. 86
        • 8. 87
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:84
        • 60. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '243' order by `id` asc80μs/app/Http/Controllers/Front/PcLeagueController.php:89greencard12_teamdb
        Metadata
        Bindings
        • 0. 243
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:89
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '243' limit 1100μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 243
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:6
        • 60. /public/index.php:54
      • select * from `v_point_settings` where `id` = '3' limit 180μs/app/helper.php:7greencard12_teamdb
        Metadata
        Bindings
        • 0. 3
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:7
        • 60. /public/index.php:54
      • select ( select count(*)+1 from ( select team_id ,coalesce(sum((home_pt>away_pt)*3 +(home_pt=away_pt)*1+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*0 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*0),0) as 勝ち点 ,coalesce(sum(home_pt) - sum(away_pt),0) as 得失点差 ,coalesce(sum(home_pt),0) as 得点 from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=243 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=243 and is_filled=1 ) as sub1 group by team_id order by 勝ち点 desc, 得失点差 desc, 得点 desc ) as sub2 where 勝ち点>(@a:=coalesce(sum((home_pt>away_pt)*3 +(home_pt=away_pt)*1+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*0 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*0),0)) or ( 勝ち点=@a and 得失点差>@b:=coalesce((sum(home_pt) - sum(away_pt)),0)) or ( 勝ち点=@a and 得失点差=@b and 得点>coalesce(sum(home_pt),0)) ) as rank ,name ,league_teams.team_id ,league_teams.leagues_id ,coalesce(sum((home_pt>away_pt)*3 +(home_pt=away_pt)*1+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*0 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*0),0) as win_pt ,coalesce(count(sub.team_id),0) as match_cnt ,coalesce(sum(home_pt>away_pt),0) as win_cnt ,coalesce(sum(home_pt=away_pt),0) as draw_cnt ,coalesce(sum(home_pt<away_pt),0) as lose_cnt ,coalesce(sum(home_pk>away_pk),0) as pk_win_cnt ,coalesce(sum(home_pk<away_pk),0) as pk_lose_cnt ,coalesce(sum(home_pt),0) as get_pt ,coalesce(sum(away_pt),0) as lose_pt ,coalesce(sum(home_pt) - sum(away_pt),0) as get_lose from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=243 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=243 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 243 and league_teams.abstention = 0 group by league_teams.team_id order by rank;14.66ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '244' order by `id` asc90μs/app/Http/Controllers/Front/PcLeagueController.php:89greencard12_teamdb
        Metadata
        Bindings
        • 0. 244
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:89
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '244' limit 1110μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 244
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:6
        • 60. /public/index.php:54
      • select * from `v_point_settings` where `id` = '1' limit 180μs/app/helper.php:7greencard12_teamdb
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:7
        • 60. /public/index.php:54
      • select ( select count(*)+1 from ( select team_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as 勝ち点 ,coalesce(sum(home_pt) - sum(away_pt),0) as 得失点差 ,coalesce(sum(home_pt),0) as 得点 from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=244 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=244 and is_filled=1 ) as sub1 group by team_id order by 勝ち点 desc, 得失点差 desc, 得点 desc ) as sub2 where 勝ち点>(@a:=coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0)) or ( 勝ち点=@a and 得失点差>@b:=coalesce((sum(home_pt) - sum(away_pt)),0)) or ( 勝ち点=@a and 得失点差=@b and 得点>coalesce(sum(home_pt),0)) ) as rank ,name ,league_teams.team_id ,league_teams.leagues_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as win_pt ,coalesce(count(sub.team_id),0) as match_cnt ,coalesce(sum(home_pt>away_pt),0) as win_cnt ,coalesce(sum(home_pt=away_pt),0) as draw_cnt ,coalesce(sum(home_pt<away_pt),0) as lose_cnt ,coalesce(sum(home_pk>away_pk),0) as pk_win_cnt ,coalesce(sum(home_pk<away_pk),0) as pk_lose_cnt ,coalesce(sum(home_pt),0) as get_pt ,coalesce(sum(away_pt),0) as lose_pt ,coalesce(sum(home_pt) - sum(away_pt),0) as get_lose from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=244 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=244 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 244 and league_teams.abstention = 0 group by league_teams.team_id order by rank;12.18ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '245' order by `id` asc90μs/app/Http/Controllers/Front/PcLeagueController.php:89greencard12_teamdb
        Metadata
        Bindings
        • 0. 245
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:89
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '245' limit 1100μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 245
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:6
        • 60. /public/index.php:54
      • select * from `v_point_settings` where `id` = '1' limit 170μs/app/helper.php:7greencard12_teamdb
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:7
        • 60. /public/index.php:54
      • select ( select count(*)+1 from ( select team_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as 勝ち点 ,coalesce(sum(home_pt) - sum(away_pt),0) as 得失点差 ,coalesce(sum(home_pt),0) as 得点 from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=245 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=245 and is_filled=1 ) as sub1 group by team_id order by 勝ち点 desc, 得失点差 desc, 得点 desc ) as sub2 where 勝ち点>(@a:=coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0)) or ( 勝ち点=@a and 得失点差>@b:=coalesce((sum(home_pt) - sum(away_pt)),0)) or ( 勝ち点=@a and 得失点差=@b and 得点>coalesce(sum(home_pt),0)) ) as rank ,name ,league_teams.team_id ,league_teams.leagues_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as win_pt ,coalesce(count(sub.team_id),0) as match_cnt ,coalesce(sum(home_pt>away_pt),0) as win_cnt ,coalesce(sum(home_pt=away_pt),0) as draw_cnt ,coalesce(sum(home_pt<away_pt),0) as lose_cnt ,coalesce(sum(home_pk>away_pk),0) as pk_win_cnt ,coalesce(sum(home_pk<away_pk),0) as pk_lose_cnt ,coalesce(sum(home_pt),0) as get_pt ,coalesce(sum(away_pt),0) as lose_pt ,coalesce(sum(home_pt) - sum(away_pt),0) as get_lose from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=245 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=245 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 245 and league_teams.abstention = 0 group by league_teams.team_id order by rank;12.3ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '246' order by `id` asc100μs/app/Http/Controllers/Front/PcLeagueController.php:89greencard12_teamdb
        Metadata
        Bindings
        • 0. 246
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:89
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '246' limit 1100μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 246
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:6
        • 60. /public/index.php:54
      • select * from `v_point_settings` where `id` = '1' limit 170μs/app/helper.php:7greencard12_teamdb
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:7
        • 60. /public/index.php:54
      • select ( select count(*)+1 from ( select team_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as 勝ち点 ,coalesce(sum(home_pt) - sum(away_pt),0) as 得失点差 ,coalesce(sum(home_pt),0) as 得点 from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=246 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=246 and is_filled=1 ) as sub1 group by team_id order by 勝ち点 desc, 得失点差 desc, 得点 desc ) as sub2 where 勝ち点>(@a:=coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0)) or ( 勝ち点=@a and 得失点差>@b:=coalesce((sum(home_pt) - sum(away_pt)),0)) or ( 勝ち点=@a and 得失点差=@b and 得点>coalesce(sum(home_pt),0)) ) as rank ,name ,league_teams.team_id ,league_teams.leagues_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as win_pt ,coalesce(count(sub.team_id),0) as match_cnt ,coalesce(sum(home_pt>away_pt),0) as win_cnt ,coalesce(sum(home_pt=away_pt),0) as draw_cnt ,coalesce(sum(home_pt<away_pt),0) as lose_cnt ,coalesce(sum(home_pk>away_pk),0) as pk_win_cnt ,coalesce(sum(home_pk<away_pk),0) as pk_lose_cnt ,coalesce(sum(home_pt),0) as get_pt ,coalesce(sum(away_pt),0) as lose_pt ,coalesce(sum(home_pt) - sum(away_pt),0) as get_lose from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=246 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=246 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 246 and league_teams.abstention = 0 group by league_teams.team_id order by rank;11.95ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '247' order by `id` asc90μs/app/Http/Controllers/Front/PcLeagueController.php:89greencard12_teamdb
        Metadata
        Bindings
        • 0. 247
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:89
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '247' limit 190μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 247
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:6
        • 60. /public/index.php:54
      • select * from `v_point_settings` where `id` = '1' limit 170μs/app/helper.php:7greencard12_teamdb
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 10. /app/helper.php:7
        • 60. /public/index.php:54
      • select ( select count(*)+1 from ( select team_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as 勝ち点 ,coalesce(sum(home_pt) - sum(away_pt),0) as 得失点差 ,coalesce(sum(home_pt),0) as 得点 from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=247 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=247 and is_filled=1 ) as sub1 group by team_id order by 勝ち点 desc, 得失点差 desc, 得点 desc ) as sub2 where 勝ち点>(@a:=coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0)) or ( 勝ち点=@a and 得失点差>@b:=coalesce((sum(home_pt) - sum(away_pt)),0)) or ( 勝ち点=@a and 得失点差=@b and 得点>coalesce(sum(home_pt),0)) ) as rank ,name ,league_teams.team_id ,league_teams.leagues_id ,coalesce(sum((home_pt>away_pt)*4 +(home_pt=away_pt)*0+(home_pt<away_pt)*0+(home_pt = away_pt and coalesce(home_pk,0) > coalesce(away_pk,0))*2 + (home_pt=away_pt and coalesce(home_pk,0)<coalesce(away_pk,0))*1),0) as win_pt ,coalesce(count(sub.team_id),0) as match_cnt ,coalesce(sum(home_pt>away_pt),0) as win_cnt ,coalesce(sum(home_pt=away_pt),0) as draw_cnt ,coalesce(sum(home_pt<away_pt),0) as lose_cnt ,coalesce(sum(home_pk>away_pk),0) as pk_win_cnt ,coalesce(sum(home_pk<away_pk),0) as pk_lose_cnt ,coalesce(sum(home_pt),0) as get_pt ,coalesce(sum(away_pt),0) as lose_pt ,coalesce(sum(home_pt) - sum(away_pt),0) as get_lose from ( select home_id as team_id,home_pt,away_pt,home_pk,away_pk from matches where leagues_id=247 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=247 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 247 and league_teams.abstention = 0 group by league_teams.team_id order by rank;12.01ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '243' and `matches`.`leagues_id` is not null4.42msview::front.league.order:88greencard12_teamdb
        Metadata
        Bindings
        • 0. 243
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.order:88
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '69' and `groups`.`id` is not null limit 1120μsview::front.league.order:94greencard12_teamdb
        Metadata
        Bindings
        • 0. 69
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.league.order:94
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '244' and `matches`.`leagues_id` is not null290μsview::front.league.order:88greencard12_teamdb
        Metadata
        Bindings
        • 0. 244
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.order:88
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '84' and `groups`.`id` is not null limit 1110μsview::front.league.order:94greencard12_teamdb
        Metadata
        Bindings
        • 0. 84
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.league.order:94
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '245' and `matches`.`leagues_id` is not null3.27msview::front.league.order:88greencard12_teamdb
        Metadata
        Bindings
        • 0. 245
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.order:88
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '85' and `groups`.`id` is not null limit 1110μsview::front.league.order:94greencard12_teamdb
        Metadata
        Bindings
        • 0. 85
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.league.order:94
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '246' and `matches`.`leagues_id` is not null3.27msview::front.league.order:88greencard12_teamdb
        Metadata
        Bindings
        • 0. 246
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.order:88
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '86' and `groups`.`id` is not null limit 190μsview::front.league.order:94greencard12_teamdb
        Metadata
        Bindings
        • 0. 86
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.league.order:94
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '247' and `matches`.`leagues_id` is not null3.21msview::front.league.order:88greencard12_teamdb
        Metadata
        Bindings
        • 0. 247
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.order:88
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '87' and `groups`.`id` is not null limit 1100μsview::front.league.order:94greencard12_teamdb
        Metadata
        Bindings
        • 0. 87
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.league.order:94
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `groups` where `convention` = '16' limit 180μsview::layouts.front.parts.header:103greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. view::layouts.front.parts.header:103
        • 18. view::layouts.front:1
        • 24. view::front.league.order:192
        • 31. /vendor/symfony/http-foundation/Response.php:202
        • 78. /public/index.php:54
        guest
        true
          _token
          TojOiskO4w5WlKZLnPebL33q1F5IeG74zm6SNBFj
          PHPDEBUGBAR_STACK_DATA
          []
          format
          html
          content_type
          text/html; charset=UTF-8
          status_text
          OK
          status_code
          200
          request_query
          []
          request_request
          []
          request_headers
          array:27 [ "priority" => array:1 [ 0 => "u=0, i" ] "sec-fetch-dest" => array:1 [ 0 => ...
          request_server
          array:67 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "PWD" => "/home/userfas...
          request_cookies
          []
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Fri...
          path_info
          /order/87/2025
          session_attributes
          array:2 [ "_token" => "TojOiskO4w5WlKZLnPebL33q1F5IeG74zm6SNBFj" "PHPDEBUGBAR_STACK_DATA" => [] ...