A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1106

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1106

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1004

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1004

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1010

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1010

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1006

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1006

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1011

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1011

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1012

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1012

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1104

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1104

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1105

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1105

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1213

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1213

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1107

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1107

Filename: core/MY_Controller.php

Line Number: 88

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1009

Filename: core/MY_Controller.php

Line Number: 87

A PHP Error was encountered

Severity: Notice

Message: Undefined index: 1009

Filename: core/MY_Controller.php

Line Number: 88

大分県のカレンダー （2023年10月）| スポエンCYCLE

大分県のカレンダー（2023年10月）

／ 全5件

受付中のみ表示

  • 開催月
  • 開催日
  • イベント名
  • 開催地

2023年10月

01日(日)

受付終了第1回 ツール・ド・やばけい202336

大分県

受付終了OITA CYCLE FES ENDURO 2hours4

大分県

08日(日)

受付終了九州チャレンジサイクリング大分県大会　ツール・ド・佐伯202394

大分県

28日(土)

受付終了2023BRM（AJ福岡 R熊本 AJ長崎 AR鹿児島）

大分県

29日(日)

受付終了第2回 HIJIシクロクロス3

大分県

全5件

検索条件を変更

Page Top
  ベンチマーク  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Search / Calendar )  0.2702
Total Execution Time  0.2708
  GET データ  
$_GET['m']   10
$_GET['y']   2023
  メモリ使用量  
1,600,232 bytes
  POST データ  
POST データはありません
  URI 文字列  
calendar/oita
  クラス/メソッド  
search/calendar
  データベース:  entry   クエリ: 3  (隠す)
0.0052   SELECT *
FROM "news_etc"
WHERE (timestamp_open is null or timestamp_open<=now()) and (timestamp_close is null or timestamp_close>now())
AND "category_news" =  1
AND "flag_open" =  1
ORDER BY "date_create" desc, "cd_news" desc
LIMIT 1 
0.1460    SELECT COUNT(*) AS count
                    FROM tournaments t LEFT OUTER JOIN category_calendar c ON t.tid = c.tid
                  WHERE (t.status = 1 AND t.timestamp_expose < now())
                  
                    AND (LOWER(t.category) = 'c' OR LOWER(t.subcategory) like '%c%') AND (t.loc_area IN (44) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (44))) AND TO_CHAR(c.startdate,'YYYYMM') = '202310' 
0.1085   SELECT t.tid,
                        t.name,
                        t.pr,
                        t.opendate,
                        t.loc_area,
                        t.location,
                        t.entrystart,
                        t.entrylimit,
                        t.entrystarttime,
                        t.entrylimittime,
                        t.onlinesubscription,
                        t.hidden,
                        t.openterm,
                        to_char(opendate,'D') as yobi,
                        t.etc,
                        CASE WHEN (t.tid IN (99377,100240,99388,99975,99323,99719,99721,99395,99279,98620,111,65808,73327,74292,74450,74848,74223,75061,75189,75357,75416,75377,75407,75368,75538,75665,76097,76354,77406,77416,77803,79099,76302,78586) and (t.entrylimit is null OR t.entrylimit >= CURRENT_DATE)) THEN 'pr' ELSE '' END AS important,c.startdate,c.event_loc_area,
                        (ARRAY_TO_STRING(ARRAY(SELECT CASE WHEN is_s3 = 1 THEN 's3_files/pr_photos/' || to_char(tid, 'FM99999999999') || '/' || name ELSE 'photos/' || name END FROM photos WHERE tid = t.tid and flag = 1 order by torder ASC),',')) AS photos,
                        (SELECT count(*) FROM cafe_new_articles a WHERE a.tournament_id = t.tid) AS cafecount,
                        (ARRAY_TO_STRING(ARRAY(SELECT genre FROM cycle_genre3 WHERE tid = t.tid ),',')) AS genre,
                        (ARRAY_TO_STRING(ARRAY(SELECT point FROM cycle_point WHERE tid = t.tid ),',')) AS point,
                        t.reverse_flag
                    FROM tournaments t LEFT OUTER JOIN category_calendar c ON t.tid = c.tid
                  WHERE (t.status = 1 AND timestamp_expose < now())
                    
                    AND (LOWER(t.category) = 'c' OR LOWER(t.subcategory) like '%c%') AND (t.loc_area IN (44) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (44))) AND TO_CHAR(c.startdate,'YYYYMM') = '202310' ORDER BY c.startdate ASC, t.loc_area ASC LIMIT 500 
  HTTP ヘッダ  (表示)
  設定変数  (表示)