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

沖縄県のカレンダー （2024年12月）| スポエンCYCLE

沖縄県のカレンダー（2024年12月）

／ 全5件

受付中のみ表示

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

2024年12月

01日(日)

受付終了【一次先着特典付き】新城幸也サイクリングイベント 20246

沖縄県

受付終了追加応募【先着特典付き】新城幸也サイクリングイベント 20244

沖縄県

受付終了【特典なし】新城幸也サイクリングイベント 2024

沖縄県

09日(月)

受付終了第2回 首里城復興チャリティーサイクリングイベント6

沖縄県

受付終了The 2nd Shurijo Castle Reconstruction Charity Ride Event

沖縄県

全5件

検索条件を変更

Page Top
  ベンチマーク  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Search / Calendar )  0.5888
Total Execution Time  0.5894
  GET データ  
$_GET['m']   12
$_GET['y']   2024
  メモリ使用量  
1,649,104 bytes
  POST データ  
POST データはありません
  URI 文字列  
calendar/okinawa
  クラス/メソッド  
search/calendar
  データベース:  entry   クエリ: 3  (隠す)
0.0049   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.3719    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 (47) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (47))) AND TO_CHAR(c.startdate,'YYYYMM') = '202412' 
0.1895   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 (99388,99119,99975,99323,99719,99721,99395,99279,99716,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 (47) OR EXISTS(SELECT 1 FROM tournamentevents e WHERE t.tid = e.tid AND e.event_loc_area IN (47))) AND TO_CHAR(c.startdate,'YYYYMM') = '202412' ORDER BY c.startdate ASC, t.loc_area ASC LIMIT 500 
  HTTP ヘッダ  (表示)
  設定変数  (表示)