順位

TOP 戦歴表

2024 Blue Wave Growing up League U-16 関西

最終更新日: 2024-12-19 17:58:36
<<　スワイプでご覧いただけます。　>>
畝傍 三田松聖 大体大浪商 城陽 河南 桜宮 刀根山 羽衣学園 京都両洋 五條 暫定順位
畝傍   2○1
 1○0
 1(4)▲(2)1
 3○0
 1○0
 7○1
 5○0
 2○0
 6○1
 1
三田松聖 1●2
   2○1
 2(4)▲(2)2
 4○1
 6○4
 5○1
 3○0
 2○0
 7○0
 2
大体大浪商 0●1
 1●2
   1(4)▲(2)1
 3○1
 5○1
 3○1
 7○0
 7○0
 11○1
 3
城陽 1(2)△(4)1
 2(2)△(4)2
 1(2)△(4)1
   0●4
 3○1
 3○1
 2○0
 1○0
 2○0
 4
河南 0●3
 1●4
 1●3
 4○0
   3○1
 3○1
 0●1
 2●3
 5○0
 5
桜宮 0●1
 4●6
 1●5
 1●3
 1●3
   1(0)▲(0)1
 2○1
 5○1
 8○0
 6
刀根山 1●7
 1●5
 1●3
 1●3
 1●3
 1(0)△(0)1
   5○3
 1○0
 6○0
 7
羽衣学園 0●5
 0●3
 0●7
 0●2
 1○0
 1●2
 3●5
   5○3
 5○0
 8
京都両洋 0●2
 0●2
 0●7
 0●1
 3○2
 1●5
 0●1
 3●5
   1●2
 9
五條 1●6
 0●7
 1●11
 0●2
 0●5
 0●8
 0●6
 0●5
 2○1
   10

関連情報

  • sports concierge office Blue Wave
  • 株式会社グリーンカード
MessagesTimelineExceptionsViews5RouteQueries11MailsAuthGateSessionRequest
39.84msRequest Duration7.75MBMemory UsageGET table/index/{group_id?}/{yyyy?}RouteGuestAuth status
    • Booting (11.64ms)
    • Application (31.68ms)
      5 templates were rendered
      • front.league.table (resources/views/front/league/table.blade.php)11blade
        Params
        0
        groups
        1
        group_id
        2
        nav_on
        3
        resultObj
        4
        table
        5
        leagues
        6
        teamAry
        7
        teamObj
        8
        yyyy
        9
        period
        10
        default_period
      • front.parts.side (resources/views/front/parts/side.blade.php)27blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups
        5
        group_id
        6
        nav_on
        7
        resultObj
        8
        table
        9
        leagues
        10
        teamAry
        11
        teamObj
        12
        yyyy
        13
        period
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        k
        22
        row
        23
        i
        24
        col
        25
        j
        26
        val
      • layouts.front (resources/views/layouts/front.blade.php)27blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups
        5
        group_id
        6
        nav_on
        7
        resultObj
        8
        table
        9
        leagues
        10
        teamAry
        11
        teamObj
        12
        yyyy
        13
        period
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        k
        22
        row
        23
        i
        24
        col
        25
        j
        26
        val
      • layouts.front.parts.header (resources/views/layouts/front/parts/header.blade.php)27blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups
        5
        group_id
        6
        nav_on
        7
        resultObj
        8
        table
        9
        leagues
        10
        teamAry
        11
        teamObj
        12
        yyyy
        13
        period
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        k
        22
        row
        23
        i
        24
        col
        25
        j
        26
        val
      • layouts.front.parts.footer (resources/views/layouts/front/parts/footer.blade.php)27blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups
        5
        group_id
        6
        nav_on
        7
        resultObj
        8
        table
        9
        leagues
        10
        teamAry
        11
        teamObj
        12
        yyyy
        13
        period
        14
        default_period
        15
        page_title
        16
        year
        17
        group
        18
        __empty_1
        19
        league
        20
        result
        21
        k
        22
        row
        23
        i
        24
        col
        25
        j
        26
        val
      uri
      GET table/index/{group_id?}/{yyyy?}
      as
      front.table.index
      controller
      App\Http\Controllers\Front\PcLeagueController@table
      namespace
      App\Http\Controllers
      prefix
      null
      where
      file
      app/Http/Controllers/Front/PcLeagueController.php:381-484
      11 statements were executed13.34ms
      greencard12_teamdb
      • select * from `groups` where `id` = '66' limit 1250μs/app/Http/Controllers/Front/PcLeagueController.php:387greencard12_teamdb
        Metadata
        Bindings
        • 0. 66
        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:387
        • 61. /public/index.php:54
      • select * from `groups` where `convention` = '16' and `grouping` = '23'120μs/app/Http/Controllers/Front/PcLeagueController.php:388greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        • 1. 23
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:388
        • 60. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `year` = '2024' and `is_publish` = '2' and `group_id` = '66'140μs/app/Http/Controllers/Front/PcLeagueController.php:392greencard12_teamdb
        Metadata
        Bindings
        • 0. 2024
        • 1. 2
        • 2. 66
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:392
        • 60. /public/index.php:54
      • select `name`, `id` from `league_teams` where `leagues_id` = '140' and `abstention` = '0' order by `id` asc130μs/app/Http/Controllers/Front/PcLeagueController.php:406greencard12_teamdb
        Metadata
        Bindings
        • 0. 140
        • 1. 0
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:406
        • 60. /public/index.php:54
      • select * from `leagues` where `id` = '140' limit 1110μs/app/helper.php:6greencard12_teamdb
        Metadata
        Bindings
        • 0. 140
        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 1100μ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=140 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=140 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=140 and is_filled=1 union all select away_id as team,away_pt,home_pt,away_pk,home_pk from matches where leagues_id=140 and is_filled=1 ) as sub right join league_teams on sub.team_id=league_teams.team_id where league_teams.leagues_id = 140 and league_teams.abstention = 0 group by league_teams.team_id order by rank;11.47ms/app/helper.php:50greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/helper.php:50
        • 12. /app/helper.php:50
        • 62. /public/index.php:54
      • SELECT t.id, t.leagues_id, ti.home_id, ti.away_id, ti.home_pt, ti.away_pt, ti.home_pk, ti.away_pk FROM league_teams AS t1 INNER JOIN (league_teams t INNER JOIN matches ti ON t.team_id = ti.home_id) ON t1.team_id = ti.away_id WHERE ti.deleted_at is null and t.leagues_id = 140 and ti.leagues_id = 140 and t1.leagues_id = 140 and t1.abstention = 0 and t.abstention = 0210μs/app/Http/Controllers/Front/PcLeagueController.php:423greencard12_teamdb
        Metadata
        Backtrace
        • 11. /app/Http/Controllers/Front/PcLeagueController.php:423
        • 12. /app/Http/Controllers/Front/PcLeagueController.php:423
        • 61. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '140' and `matches`.`leagues_id` is not null590μsview::front.league.table:81greencard12_teamdb
        Metadata
        Bindings
        • 0. 140
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.league.table:81
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '66' and `groups`.`id` is not null limit 1120μsview::front.league.table:87greencard12_teamdb
        Metadata
        Bindings
        • 0. 66
        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.table:87
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `groups` where `convention` = '16' limit 1100μ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.table:157
        • 31. /vendor/symfony/http-foundation/Response.php:202
        • 78. /public/index.php:54
        guest
        true
          _token
          hLdffBnUu441BdvuKyFbJBXJDffvyiV6Ykn1QQvu
          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 => "Thu...
          path_info
          /table/index/66/2024
          session_attributes
          array:2 [ "_token" => "hLdffBnUu441BdvuKyFbJBXJDffvyiV6Ykn1QQvu" "PHPDEBUGBAR_STACK_DATA" => [] ...