2025 Blue Wave Growing up League U-16 公式サイト

順位

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

最終更新日: 2025-05-11 10:58:47

<<　スワイプでご覧いただけます。　>>

	倉敷翠松	丸亀城西	新居浜東	小津	大洲	新居浜工業	高松西	暫定順位
倉敷翠松		-	-	-	-	-	-	1
丸亀城西	-		-	-	-	-	-	1
新居浜東	-	-		-	-	-	-	1
小津	-	-	-		-	-	-	1
大洲	-	-	-	-		-	-	1
新居浜工業	-	-	-	-	-		-	1
高松西	-	-	-	-	-	-		1

関連情報

sports concierge office Blue Wave
株式会社グリーンカード

Messages Timeline Exceptions Views5 Route Queries12 Mails Auth Gate Session Request

54.11ms7.5MBGET table/index/{group_id?}/{yyyy?}Guest

Booting (13.54ms)
Application (44.7ms)

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

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


obLevel
__env
app
errors
groups
group_id
nav_on
resultObj
table
leagues
teamAry
teamObj
yyyy
period
default_period
page_title
year
group
__empty_1
league
result
k
row
i
col
j
val

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


obLevel
__env
app
errors
groups
group_id
nav_on
resultObj
table
leagues
teamAry
teamObj
yyyy
period
default_period
page_title
year
group
__empty_1
league
result
k
row
i
col
j
val

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


obLevel
__env
app
errors
groups
group_id
nav_on
resultObj
table
leagues
teamAry
teamObj
yyyy
period
default_period
page_title
year
group
__empty_1
league
result
k
row
i
col
j
val

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


obLevel
__env
app
errors
groups
group_id
nav_on
resultObj
table
leagues
teamAry
teamObj
yyyy
period
default_period
page_title
year
group
__empty_1
league
result
k
row
i
col
j
val

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:422-542

12 statements were executed25.39ms

select * from `groups` where `id` = '86' limit 1320μs/app/Http/Controllers/Front/PcLeagueController.php:428greencard12_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	12. /app/Http/Controllers/Front/PcLeagueController.php:428 61. /public/index.php:54

select * from `groups` where `convention` = '16' and `grouping` = '23' and `id` <> '66'170μs/app/Http/Controllers/Front/PcLeagueController.php:443greencard12_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:443
60. /public/index.php:54
select `id` from `groups` where `convention` = '16' and `grouping` = '23' and `id` <> '66'120μs/app/Http/Controllers/Front/PcLeagueController.php:445greencard12_teamdb
Metadata
Bindings
0. 16
1. 23
2. 66
Backtrace
11. /app/Http/Controllers/Front/PcLeagueController.php:445
60. /public/index.php:54
select * from `leagues` where `leagues`.`deleted_at` is null and `year` = '2025' and `is_publish` = '2' and `group_id` = '86'170μs/app/Http/Controllers/Front/PcLeagueController.php:450greencard12_teamdb
Metadata
Bindings
0. 2025
1. 2
2. 86
Hints
Use SELECT * only if you need all columns from table
Backtrace
11. /app/Http/Controllers/Front/PcLeagueController.php:450
60. /public/index.php:54
select `name`, `id` from `league_teams` where `leagues_id` = '246' and `abstention` = '0' order by `id` asc120μs/app/Http/Controllers/Front/PcLeagueController.php:464greencard12_teamdb
Metadata
Bindings
0. 246
1. 0
Backtrace
11. /app/Http/Controllers/Front/PcLeagueController.php:464
60. /public/index.php:54

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:443 60. /public/index.php:54

Metadata
Bindings	0. 16 1. 23 2. 66
Backtrace	11. /app/Http/Controllers/Front/PcLeagueController.php:445 60. /public/index.php:54

Metadata
Bindings	0. 2025 1. 2 2. 86
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/Http/Controllers/Front/PcLeagueController.php:450 60. /public/index.php:54

Metadata
Bindings	0. 246 1. 0
Backtrace	11. /app/Http/Controllers/Front/PcLeagueController.php:464 60. /public/index.php:54

select * from `leagues` where `id` = '246' limit 1120μ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 1110μ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;18.16ms/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 = 246 and ti.leagues_id = 246 and t1.leagues_id = 246 and t1.abstention = 0 and t.abstention = 05.49ms/app/Http/Controllers/Front/PcLeagueController.php:481greencard12_teamdb
Metadata
Backtrace
11. /app/Http/Controllers/Front/PcLeagueController.php:481
12. /app/Http/Controllers/Front/PcLeagueController.php:481
61. /public/index.php:54

Metadata
Backtrace	11. /app/helper.php:50 12. /app/helper.php:50 62. /public/index.php:54

Metadata
Backtrace	11. /app/Http/Controllers/Front/PcLeagueController.php:481 12. /app/Http/Controllers/Front/PcLeagueController.php:481 61. /public/index.php:54

select * from `matches` where `matches`.`deleted_at` is null and `matches`.`leagues_id` = '246' and `matches`.`leagues_id` is not null

370μsview::front.league.table:81greencard12_teamdb

Metadata
Bindings	0. 246
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` = '86' and `groups`.`id` is not null limit 1130μsview::front.league.table:87greencard12_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.table:87 24. /vendor/symfony/http-foundation/Response.php:202 71. /public/index.php:54

select * from `groups` where `convention` = '16' limit 1110μ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: MqbpZsD6loBK1xD1bBMpoTrnPQN7ZmoN8c68pz6Q
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 => "Sat...
path_info: /table/index/86
session_attributes: array:2 [ "_token" => "MqbpZsD6loBK1xD1bBMpoTrnPQN7ZmoN8c68pz6Q" "PHPDEBUGBAR_STACK_DATA" => [] ...

順位

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

関連情報

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