1R | 2R | 3R | 4R | 5R | 6R | 7R | 8R | 9R | 10R | 11R | 12R | |
1R | 2R | 3R | 4R | 5R | 6R | 7R | 8R | 9R | 10R | 11R | 12R |
枠番 | 馬番 | 馬名 | 騎手 厩舎 (勝率-連対率) (指数) 最大 平均 |
着順 | 指数印 | 展開印 | 爆発力印 | 間隔 | 前走 | 2走前 | 3走前 | 4走前 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 |
牝
5
栗毛
差
ハーツクライ ハーツフェルト マチカネタマカズラ (Kingmambo) |
森一馬 58K
(0.0% - 0.0%)
栗東 斉藤崇史
(12.2% - 21.0%)
49
29
|
6 | 15週 |
阪神 6/7
良 芝ダ2970
障3歳上未勝利
5/10
5/10
6人
森一馬 58K
7番
490
スズカマイゲ
-1
3248 (1.9)
6-7-6
13.8
|
新潟 5/10
良 芝1600
4歳上1勝(500万)
13/13
13/13
12人
石川裕 55K
8番
476
ウインメルシー
35
1364 (2.5)
9-9
36.3
|
福島 4/25
良 芝2000
4歳上1勝(500万)
8/9
8/9
8人
西村淳 54K
7番
474
レッドルーヴ
49
2036 (2.8)
2-2-2
37.9
|
新潟 10/19
稍重 芝1600
3歳上1勝(500万)
8/18
8/18
14人
西村淳 54K
5番
478
キャンディスト
33
1367 (0.9)
3-2
36.0
|
|||
2 | 2 |
牡
4
栗毛
追
ダンカーク ゴルトグランツ スイリンカ (ワイルドラッシュ) |
小野寺祐 60K
(0.0% - 0.0%)
美浦 萱野浩二
(2.8% - 6.3%)
32
15
|
7 | 8週 |
福島 7/19
良 ダ1700
3歳上1勝(500万)
12/15
12/15
15人
小林脩 54K
5番
476
ファイアランス
30
1481 (1.9)
14-13-14
40.2
|
新潟 5/17
稍重 芝2890
障3歳上未勝利
9/14
9/14
14人
小野寺 59K
13番
470
クールエイジア
-1
3186 (7.8)
12-10-10
13.7
|
福島 4/19
不良 芝2750
障3歳上未勝利
11/12
11/12
11人
小野寺 59K
4番
480
オブリゲーシ
-1
3183 (13.1)
12-11-11
14.4
|
東京 2/22
良 ダ1600
4歳上1勝(500万)
12/16
12/16
14人
菊沢一 56K
1番
470
パイロテクニク
32
1400 (1.8)
7-8
37.8
|
|||
3 | 3 |
牝
4
黒鹿毛
差
キングヘイロー ルンルンキャット ホッコーユニバース (アグネスタキオン) |
植野貴也 58K
(0.0% - 0.0%)
栗東 高柳大輔
(10.2% - 22.1%)
8
1
|
1 | 3週 |
新潟 8/22
良 芝2850
障3歳上未勝利
12/14
12/14
4人
植野貴 58K
14番
450
メイショウハニー
-1
3103 (4.2)
9-10-10
13.4
|
新潟 5/24
良 芝2890
障3歳上未勝利
3/14
3/14
5人
植野貴 57K
8番
452
ダノンキング
-1
3106 (4.1)
3-2-2
13.2
|
福島 5/3
良 芝2770
障3歳上未勝利
4/14
4/14
6人
植野貴 57K
7番
444
クリノライジン
8
3038 (2.1)
4-5-6
13.3
|
福島 4/11
良 芝2750
障3歳上未勝利
5/14
5/14
8人
植野貴 57K
5番
446
フィスキオ
-1
3055 (3.8)
8-6-6
13.5
|
|||
4 | 4 |
牡
4
栗毛
差
マツリダゴッホ ホウオウアクセル タニノエクセレント (ブライアンズタイム) |
北沢伸也 60K
(0.0% - 0.0%)
栗東 宮徹
(4.4% - 11.7%)
-1
-1
|
4 | 3週 |
新潟 8/22
良 芝2850
障3歳上未勝利
5/14
5/14
3人
北沢伸 60K
1番
456
メイショウハニー
-1
3081 (2.0)
11-7-7
13.2
|
阪神 7/19
良 芝ダ2970
障3歳上未勝利
7/13
7/13
2人
北沢伸 60K
2番
464
マサハヤドリー
-1
3236 (2.5)
7-6-6
13.7
|
阪神 6/21
良 芝ダ2970
障3歳上未勝利
2/10
2/10
5人
北沢伸 60K
4番
462
ギラーミン
-1
3259 (0.6)
5-5-2
13.9
|
新潟 5/10
良 芝2890
障3歳上未勝利
6/14
6/14
10人
北沢伸 59K
11番
456
マーニ
-1
3109 (3.3)
7-5-5
13.2
|
|||
5 | 5 |
牡
4
栗毛
追
サウンドボルケーノ ヤサカリベルテ ヤサカシャイニー (アドマイヤジャパン) |
上野翔 60K
(0.0% - 0.0%)
美浦 水野貴広
(5.1% - 11.4%)
26
12
|
3 | 2週 |
新潟 8/30
良 芝2850
障3歳上未勝利
3/14
3/14
5人
上野翔 60K
1番
460
ケイブルグラ
-1
3088 (1.8)
7-3-2
13.2
|
阪神 7/5
稍重 芝ダ2970
障3歳上未勝利
5/10
5/10
10人
上野翔 60K
6番
452
ガッツィーソー
-1
3280 (2.1)
7-7-7
14.0
|
東京 6/6
良 ダ1400
3歳上1勝(500万)
13/16
13/16
16人
武藤雅 57K
12番
456
プリマジア
26
1269 (2.4)
15-15
36.9
|
中山 3/31
稍重 ダ1200
4歳上1勝(500万)
13/16
13/16
8人
柴田善 57K
11番
468
シゲルルビー
24
1129 (1.4)
12-11
37.4
|
|||
6 | 6 |
牡
6
鹿毛
差
アドマイヤムーン エミーリオ プライムオブユース (Deputy Minister) |
江田勇亮 60K
(0.0% - 0.0%)
美浦 田中剛
(5.0% - 10.3%)
2
-0
|
5 | 2週 |
新潟 8/30
良 芝2850
障3歳上未勝利
2/14
2/14
3人
大江原 60K
3番
496
ケイブルグラ
-1
3088 (1.8)
5-7-5
13.2
|
東京 5/30
良 芝ダ3000
障3歳上未勝利
2/14
2/14
4人
江田勇 60K
3番
496
マンノグランフ
-1
3229 (1.2)
3-3-2
13.5
|
新潟 5/9
良 芝2890
障3歳上未勝利
2/14
2/14
7人
上野翔 60K
3番
496
シャリオヴァル
2
3091 (0.2)
9-7-3
13.1
|
中京 3/1
稍重 芝3000
障3歳上未勝利
6/14
6/14
10人
草野太 60K
4番
490
エムアイグラン
-1
3206 (1.8)
13-9-9
13.4
|
|||
7 | 7 |
牡
4
鹿毛
追
ヘニーヒューズ ジュンノサップ サイレントラヴ (サンデーサイレンス) |
草野太郎 60K
(0.0% - 0.0%)
美浦 畠山吉宏
(4.8% - 10.2%)
27
24
|
9 | 19週 |
東京 5/10
良 ダ1300
4歳上1勝(500万)
15/16
15/16
13人
野中悠 57K
1番
478
ジョガールホ
27
1205 (2.7)
5-6
38.4
|
福島 4/19
重 芝1200
医王寺特別 4歳上1勝(500万)
13/16
13/16
15人
柴山雄 57K
1番
476
タガノカルラ
23
1124 (1.5)
9-11
37.8
|
中山 3/20
良 ダ1200
4歳上1勝(500万)
15/16
15/16
13人
藤井勘 57K
15番
486
エンパイアシュ
23
1135 (1.9)
4-6
39.5
|
中京 3/7
良 ダ1400
4歳上1勝(500万)
12/16
12/16
16人
藤井勘 57K
3番
484
グレートバニ
22
1268 (2.3)
13-12
39.3
|
|||
8 | 8 |
牝
4
鹿毛
差
ノヴェリスト オレンジオレンジ ギフトオブザラック (ディープインパクト) |
黒岩悠 58K
(0.0% - 0.0%)
栗東 平田修
(6.7% - 13.5%)
46
19
|
2 | 3週 |
新潟 8/22
良 芝2850
障3歳上未勝利
3/14
3/14
11人
黒岩悠 58K
9番
454
メイショウハニー
-1
3079 (1.8)
3-6-5
13.2
|
中京 3/28
稍重 芝3000
障3歳上未勝利
12/14
12/14
14人
黒岩悠 57K
10番
456
メイショウジサ
-1
3236 (5.4)
12-12-12
13.6
|
小倉 9/1
重 芝2000
3歳未勝利
7/18
7/18
10人
松山弘 54K
4番
446
イルマタル
32
2045 (0.7)
5-4-4
38.6
|
小倉 8/17
良 芝2000
3歳未勝利
3/18
3/18
6人
松山弘 54K
6番
442
ルンルンクオリテ
46
2012 (0.5)
5-6-4
36.7
|
|||
8 | 9 |
牡
3
鹿毛
追
トーセンジョーダン クリノビックスター ツルマルミホ (ネオユニヴァース) |
佐久間寛 58K
(0.0% - 0.0%)
栗東 渡辺薫彦
(6.7% - 16.8%)
19
13
|
8 | 4週 |
小倉 8/15
良 ダ1700
3歳未勝利
11/15
11/15
13人
森裕太 55K
10番
472
スプリットロッ
7
1502 (3.0)
13-12-11
40.2
|
阪神 6/27
良 ダ1800
3歳未勝利
6/16
6/16
13人
森裕太 55K
2番
474
メイショウハクサ
19
1557 (2.1)
15-14-12
38.8
|
福島 4/26
良 ダ1700
3歳未勝利
7/15
7/15
12人
森裕太 55K
6番
470
メイショウメイユ
19
1504 (1.5)
10-11-8
40.3
|
阪神 3/20
良 ダ2000
3歳未勝利
7/14
7/14
13人
森裕太 55K
10番
462
ウインダークロ
5
2115 (1.8)
11-11-10
38.9
|
着順 | 異常 | 枠番 | 馬番 | 馬名 | 性齢 | 斤量 | 馬体重 | 増減 | 騎手 | タイム | 着差 | 通過順位 | 上3F | 人気 | オッズ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3 | 3 | ルンルンキャット | 牝4 | 58.0 | 460 | +10 | 植野貴也 | 3201 | ③③③③ | 38.5 | 6 | 13.0 | ||
2 | 8 | 8 | オレンジオレンジ | 牝4 | 58.0 | 458 | +4 | 黒岩悠 | 3204 | 2 | ①①①① | 38.5 | 2 | 4.0 | |
3 | 5 | 5 | ヤサカリベルテ | 牡4 | 60.0 | 460 | 0 | 上野翔 | 3207 | 13/4 | ④④③② | 38.5 | 3 | 6.2 | |
4 | 4 | 4 | ホウオウアクセル | 牡4 | 60.0 | 454 | -2 | 北沢伸也 | 3211 | 21/2 | ⑥⑤⑤⑤ | 38.5 | 4 | 6.8 | |
5 | 6 | 6 | エミーリオ | 牡6 | 60.0 | 502 | +6 | 江田勇亮 | 3212 | 3/4 | ②②②③ | 38.5 | 1 | 2.2 | |
6 | 1 | 1 | ハーツフェルト | 牝5 | 58.0 | 480 | -10 | 森一馬 | 3213 | 3/4 | ⑤⑤⑤⑥ | 38.5 | 5 | 7.0 | |
7 | 2 | 2 | ゴルトグランツ | 牡4 | 60.0 | 486 | +10 | 小野寺祐 | 3274 | 大差 | ⑦⑦⑦⑦ | 38.5 | 9 | 154.5 | |
8 | 8 | 9 | クリノビックスター | 牡3 | 58.0 | 480 | +8 | 佐久間寛 | 3283 | 5 | ⑧⑧⑧⑨ | 38.5 | 7 | 64.3 | |
9 | 7 | 7 | ジュンノサップ | 牡4 | 60.0 | 488 | +10 | 草野太郎 | 3304 | 大差 | ⑨⑨⑧⑦ | 38.5 | 8 | 77.5 |
|
|
|
10
Console |
3.528 s
Load Time |
178 Queries
Database |
12.18 MB
Memory Used |
115 Files
Included |
476 Config
items loaded |
0 Session
vars loaded |
1 GET
vars loaded |
0 POST
vars loaded |
3Logs |
0 Errors |
0 Memory |
7 Speed |
speed | 24.071 msFuel\Core\Profiler::init Start |
speed | 108.337 msFuel\Core\Fuel::init End |
speed | 109.136 msFuel\Core\Uri::__construct Start |
speed | 134.074 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "jra/detail/20200920/47/01" |
speed | 208.550 msFuel\Core\Request::execute: Start of jra/detail/20200920/47/01 |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 1.701 sFuel\Core\Request::execute: End of jra/detail/20200920/47/01 |
speed | 2.860 sEnd of Fuel Execution |
3.528 sLoad Time |
30 s Max Execution Time |
24.071 msFuel\Core\Profiler::init Start |
108.337 msFuel\Core\Fuel::init End |
109.136 msFuel\Core\Uri::__construct Start |
134.074 msFuel\Core\Uri::__construct End |
208.550 msFuel\Core\Request::execute: Start of jra/detail/20200920/47/01 |
1.701 sFuel\Core\Request::execute: End of jra/detail/20200920/47/01 |
2.860 sEnd of Fuel Execution |
178Total Queries |
724.956 ms Total Time |
43 Duplicates |
SELECT * FROM OSUSUME2Connection name: default Speed: 0.261 ms Query analysis: · Query: SIMPLE on OSUSUME2 · Type: ALL · Rows: 15 Call trace for this query:File: APPPATH/classes/model/narjra.php, line 111File: APPPATH/classes/controller/front/base.php, line 438File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 69 |
SELECT rc.*, hjc.ATOJI, hjc.ATOFUN FROM RACE as rc LEFT JOIN HASSOU_JIKOKU_CHANGE as hjc ON rc.YEAR = hjc.YEAR AND rc.MONTHDAY = hjc.MONTHDAY AND rc.JYOCD = hjc.JYOCD AND rc.RACENUM = hjc.RACENUM WHERE rc.YEAR = '2020' AND rc.MONTHDAY = '0920' AND rc.DATAKUBUN > 1 AND rc.DATAKUBUN <= 7 GROUP BY CONCAT(rc.YEAR,rc.MONTHDAY,rc.JYOCD,rc.RACENUM) ORDER BY rc.RACENUMConnection name: default Speed: 13.889 ms Query analysis: · Query: SIMPLE on rc · Possible keys: PRIMARY,race_index · Key Used: PRIMARY · Type: ref · Rows: 22 (Using where; Using temporary; Using filesort) · Query: SIMPLE on hjc · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 269File: APPPATH/classes/controller/front/jra.php, line 353File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT wpp.* FROM wp_posts as wpp LEFT JOIN wp_term_relationships as wtr ON wpp.ID = wtr.object_id LEFT JOIN wp_term_taxonomy as wtt ON wtr.term_taxonomy_id = wtt.term_taxonomy_id WHERE wpp.post_status = "publish" AND wtt.taxonomy = "category" AND wtt.term_id <> "3" ORDER BY post_date DESC LIMIT 0,1Connection name: wp2 Speed: 199.245 ms Query analysis: · Query: SIMPLE on wtt · Possible keys: PRIMARY,term_id_taxonomy,taxonomy · Key Used: taxonomy · Type: ref · Rows: 15 (Using where; Using temporary; Using filesort) · Query: SIMPLE on wtr · Possible keys: PRIMARY,term_taxonomy_id · Key Used: term_taxonomy_id · Type: ref · Rows: 15 (Using where; Using index) · Query: SIMPLE on wpp · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/narjra.php, line 206File: APPPATH/classes/controller/front/jra.php, line 369File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, seibetsu.seibetsu, keiro.keiro, touzai.touzai, uma.KETTO3INFOBAMEI1, uma.KETTO3INFOBAMEI2 , uma.KETTO3INFOBAMEI5, jrace.*, harai.PAYFUKUSYOUMABAN1, harai.PAYFUKUSYOUMABAN2, harai.PAYTANSYOPAY1, harai.PAYTANSYOPAY2, harai.PAYFUKUSYOPAY1, harai.PAYFUKUSYOPAY2, harai.PAYFUKUSYOPAY3, harai.PAYFUKUSYOPAY4, harai.PAYWAKURENPAY1, harai.PAYWAKURENPAY2, harai.PAYUMARENPAY1, harai.PAYUMARENPAY2, harai.PAYUMATANPAY1, harai.PAYUMATANPAY2, harai.PAYWIDEPAY1, harai.PAYWIDEPAY2, harai.PAYWIDEPAY3, harai.PAYWIDEPAY4, harai.PAYWIDEPAY5, harai.PAYSANRENPUKUPAY1, PAYSANRENPUKUPAY2, harai.PAYSANRENTANPAY1, PAYSANRENTANPAY2, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, hjc.ATOJI, hjc.ATOFUN, ATOKISYUNAME, ATOKISYUCODE, ATOFUTAN, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM UMA_RACE as uma_race LEFT JOIN SEIBETSU as seibetsu ON uma_race.SEXCD = seibetsu.seibetsu_id LEFT JOIN KEIRO as keiro ON uma_race.KEIROCD = keiro.keiro_id LEFT JOIN TOUZAI as touzai ON uma_race.TOZAICD = touzai.touzai_id LEFT JOIN UMA as uma ON uma_race.KETTONUM = uma.KETTONUM LEFT JOIN RACE as jrace ON uma_race.YEAR = jrace.YEAR AND uma_race.MONTHDAY = jrace.MONTHDAY AND uma_race.JYOCD = jrace.JYOCD AND uma_race.RACENUM = jrace.RACENUM LEFT JOIN HASSOU_JIKOKU_CHANGE as hjc ON jrace.YEAR = hjc.YEAR AND jrace.MONTHDAY = hjc.MONTHDAY AND jrace.JYOCD = hjc.JYOCD AND jrace.RACENUM = hjc.RACENUM LEFT JOIN KISYU_CHANGE as ksc ON uma_race.YEAR = ksc.YEAR AND uma_race.MONTHDAY = ksc.MONTHDAY AND uma_race.JYOCD = ksc.JYOCD AND uma_race.RACENUM = ksc.RACENUM AND uma_race.UMABAN = ksc.UMABAN AND ksc.ATOKISYUNAME != "未定" LEFT JOIN HARAI as harai ON uma_race.YEAR = harai.YEAR AND uma_race.MONTHDAY = harai.MONTHDAY AND uma_race.JYOCD = harai.JYOCD AND uma_race.RACENUM = harai.RACENUM LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE uma_race.YEAR = '2020' AND uma_race.MONTHDAY = '0920' AND uma_race.JYOCD = '07' AND uma_race.RACENUM = '01' AND uma_race.DATAKUBUN != "1" GROUP BY uma_race.BAMEI ORDER BY cast(uma_race.UMABAN as SIGNED ) ASCConnection name: default Speed: 4.730 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on seibetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on keiro · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on touzai · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on uma · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 · Query: SIMPLE on hjc · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 · Query: SIMPLE on ksc · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 2 · Query: SIMPLE on harai · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 365 · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 960File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT * FROM katsuragi WHERE race_id = '2020092007020401'Connection name: default Speed: 0.192 ms Query analysis: · Query: SIMPLE on katsuragi · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 2732File: APPPATH/classes/model/jra.php, line 1001File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2015105010' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 11.532 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 42 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0607' AND JYOCD = '09' AND RACENUM = '01'Connection name: default Speed: 0.801 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019060749'Connection name: default Speed: 0.104 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018060749'Connection name: default Speed: 0.098 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.110 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0510' AND JYOCD = '04' AND RACENUM = '08'Connection name: default Speed: 0.481 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019051044'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018051044'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.092 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0425' AND JYOCD = '03' AND RACENUM = '07'Connection name: default Speed: 0.432 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019042543'Connection name: default Speed: 0.100 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018042543'Connection name: default Speed: 0.105 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.103 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2019' AND MONTHDAY = '1019' AND JYOCD = '04' AND RACENUM = '08'Connection name: default Speed: 0.480 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018101944'Connection name: default Speed: 0.306 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2017101944'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 2.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '01' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.575 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '01' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.544 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016103573' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 30.250 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 29 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0719' AND JYOCD = '03' AND RACENUM = '12'Connection name: default Speed: 6.418 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019071943'Connection name: default Speed: 0.103 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018071943'Connection name: default Speed: 0.107 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0517' AND JYOCD = '04' AND RACENUM = '05'Connection name: default Speed: 0.473 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019051744'Connection name: default Speed: 15.495 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018051744'Connection name: default Speed: 0.092 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.105 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0419' AND JYOCD = '03' AND RACENUM = '05'Connection name: default Speed: 0.417 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019041943'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018041943'Connection name: default Speed: 0.093 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.106 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0222' AND JYOCD = '05' AND RACENUM = '04'Connection name: default Speed: 0.714 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019022245'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018022245'Connection name: default Speed: 0.087 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '45'Connection name: default Speed: 0.102 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '02' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.565 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '02' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.624 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016102443' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 40.184 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 32 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0822' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 11.373 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019082244'Connection name: default Speed: 0.100 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018082244'Connection name: default Speed: 0.100 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0524' AND JYOCD = '04' AND RACENUM = '04'Connection name: default Speed: 0.439 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019052444'Connection name: default Speed: 0.097 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018052444'Connection name: default Speed: 0.114 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 3.742 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0503' AND JYOCD = '03' AND RACENUM = '04'Connection name: default Speed: 0.441 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019050343'Connection name: default Speed: 0.112 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018050343'Connection name: default Speed: 0.094 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0411' AND JYOCD = '03' AND RACENUM = '04'Connection name: default Speed: 4.716 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019041143'Connection name: default Speed: 0.117 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018041143'Connection name: default Speed: 0.098 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.117 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '03' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.546 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '03' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.577 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016105492' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 58.706 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 71 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0822' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 0.486 ms · DUPLICATE Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019082244'Connection name: default Speed: 0.109 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018082244'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.092 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0719' AND JYOCD = '09' AND RACENUM = '01'Connection name: default Speed: 0.427 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019071949'Connection name: default Speed: 0.107 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018071949'Connection name: default Speed: 0.096 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0621' AND JYOCD = '09' AND RACENUM = '01'Connection name: default Speed: 0.429 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019062149'Connection name: default Speed: 0.182 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018062149'Connection name: default Speed: 0.127 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.125 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0510' AND JYOCD = '04' AND RACENUM = '04'Connection name: default Speed: 1.229 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019051044'Connection name: default Speed: 0.114 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018051044'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.107 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '04' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.795 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '04' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.634 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016100220' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 27.197 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 44 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0830' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 1.392 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019083044'Connection name: default Speed: 0.115 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018083044'Connection name: default Speed: 0.094 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.092 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0705' AND JYOCD = '09' AND RACENUM = '01'Connection name: default Speed: 7.035 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019070549'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018070549'Connection name: default Speed: 0.100 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.146 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0606' AND JYOCD = '05' AND RACENUM = '07'Connection name: default Speed: 13.425 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019060645'Connection name: default Speed: 0.106 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018060645'Connection name: default Speed: 0.097 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '45'Connection name: default Speed: 0.322 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0331' AND JYOCD = '06' AND RACENUM = '07'Connection name: default Speed: 7.467 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019033146'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018033146'Connection name: default Speed: 0.088 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '46'Connection name: default Speed: 0.088 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '05' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.525 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '05' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 4.585 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2014102394' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 27.474 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 71 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0830' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 0.459 ms · DUPLICATE Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019083044'Connection name: default Speed: 0.119 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018083044'Connection name: default Speed: 0.095 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0530' AND JYOCD = '05' AND RACENUM = '04'Connection name: default Speed: 0.457 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019053045'Connection name: default Speed: 0.099 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018053045'Connection name: default Speed: 0.093 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '45'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0509' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 18.467 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019050944'Connection name: default Speed: 3.465 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018050944'Connection name: default Speed: 3.506 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.101 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0301' AND JYOCD = '07' AND RACENUM = '04'Connection name: default Speed: 3.694 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019030147'Connection name: default Speed: 0.114 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018030147'Connection name: default Speed: 0.090 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '47'Connection name: default Speed: 0.094 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '06' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.591 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '06' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.550 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016103534' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 38.243 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 21 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0510' AND JYOCD = '05' AND RACENUM = '06'Connection name: default Speed: 0.501 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019051045'Connection name: default Speed: 0.100 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018051045'Connection name: default Speed: 0.096 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '45'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0419' AND JYOCD = '03' AND RACENUM = '10'Connection name: default Speed: 5.959 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019041943'Connection name: default Speed: 0.105 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018041943'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.103 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0320' AND JYOCD = '06' AND RACENUM = '07'Connection name: default Speed: 0.491 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019032046'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018032046'Connection name: default Speed: 6.276 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '46'Connection name: default Speed: 0.104 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0307' AND JYOCD = '07' AND RACENUM = '08'Connection name: default Speed: 0.810 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019030747'Connection name: default Speed: 0.112 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018030747'Connection name: default Speed: 0.102 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '47'Connection name: default Speed: 0.121 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '07' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.547 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '07' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.758 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2016105972' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 46.905 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 39 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0822' AND JYOCD = '04' AND RACENUM = '01'Connection name: default Speed: 0.504 ms · DUPLICATE Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019082244'Connection name: default Speed: 0.116 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018082244'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '44'Connection name: default Speed: 0.095 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0328' AND JYOCD = '07' AND RACENUM = '04'Connection name: default Speed: 2.442 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019032847'Connection name: default Speed: 0.105 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018032847'Connection name: default Speed: 0.098 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '47'Connection name: default Speed: 0.093 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2019' AND MONTHDAY = '0901' AND JYOCD = '10' AND RACENUM = '06'Connection name: default Speed: 0.509 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018090150'Connection name: default Speed: 0.101 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2017090150'Connection name: default Speed: 0.616 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '50'Connection name: default Speed: 0.097 ms Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2019' AND MONTHDAY = '0817' AND JYOCD = '10' AND RACENUM = '07'Connection name: default Speed: 0.469 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018081750'Connection name: default Speed: 0.107 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2017081750'Connection name: default Speed: 0.143 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '50'Connection name: default Speed: 0.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '08' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 4.260 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '08' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 18.235 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT uma_race.*, ijyou.ijyou FROM UMA_RACE as uma_race LEFT JOIN IJYOU as ijyou ON uma_race.IJYOCD = ijyou.ijyou_id WHERE uma_race.KETTONUM = '2017100841' AND CONCAT(uma_race.YEAR,uma_race.MONTHDAY) < '20200920' AND NOT uma_race.DATAKUBUN IN("0","1","9") ORDER BY CONCAT(uma_race.YEAR,uma_race.MONTHDAY) DESC LIMIT 4Connection name: default Speed: 25.001 ms Query analysis: · Query: SIMPLE on uma_race · Possible keys: KETTONUM · Key Used: KETTONUM · Type: ref · Rows: 19 (Using where; Using filesort) · Query: SIMPLE on ijyou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1661File: APPPATH/classes/model/jra.php, line 1007File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0815' AND JYOCD = '10' AND RACENUM = '03'Connection name: default Speed: 0.501 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019081550'Connection name: default Speed: 0.105 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018081550'Connection name: default Speed: 0.096 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '50'Connection name: default Speed: 0.094 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0627' AND JYOCD = '09' AND RACENUM = '04'Connection name: default Speed: 7.054 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019062749'Connection name: default Speed: 0.103 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018062749'Connection name: default Speed: 0.093 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.097 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0426' AND JYOCD = '03' AND RACENUM = '03'Connection name: default Speed: 0.439 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019042643'Connection name: default Speed: 0.122 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018042643'Connection name: default Speed: 0.132 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '43'Connection name: default Speed: 0.150 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT jrace.*, ky_syubetsu.ky_syubetsu, ky_jyouken1.ky_jyouken as ky_jyouken1, ky_jyouken2.ky_jyouken as ky_jyouken2, ky_jyouken3.ky_jyouken as ky_jyouken3, ky_kigou.ky_kigou, jy_syubetsu.jy_syubetsu, grade.grade, track.track, baba_shiba.babajyoutai as babajyoutai_s, baba_dirt.babajyoutai as babajyoutai_d FROM RACE as jrace LEFT JOIN KY_SYUBETSU as ky_syubetsu ON jrace.SYUBETUCD = ky_syubetsu.ky_syubetsu_id LEFT JOIN KY_JYOUKEN as ky_jyouken1 ON jrace.JYOKENCD1 = ky_jyouken1.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken2 ON jrace.JYOKENCD2 = ky_jyouken2.ky_jyouken_id LEFT JOIN KY_JYOUKEN as ky_jyouken3 ON jrace.JYOKENCD3 = ky_jyouken3.ky_jyouken_id LEFT JOIN KY_KIGOU as ky_kigou ON jrace.KIGOCD = ky_kigou.ky_kigou_id LEFT JOIN JY_SYUBETSU as jy_syubetsu ON jrace.JYURYOCD = jy_syubetsu.jy_syubetsu_id LEFT JOIN GRADE as grade ON jrace.GRADECD = grade.grade_id LEFT JOIN TRACK as track ON jrace.TRACKCD = track.track_id LEFT JOIN BABAJYOUTAI as baba_shiba ON jrace.SIBABABACD = baba_shiba.babajyoutai_id LEFT JOIN BABAJYOUTAI as baba_dirt ON jrace.DIRTBABACD = baba_dirt.babajyoutai_id WHERE YEAR = '2020' AND MONTHDAY = '0320' AND JYOCD = '09' AND RACENUM = '04'Connection name: default Speed: 0.506 ms Query analysis: · Query: SIMPLE on jrace · Possible keys: PRIMARY,race_index · Key Used: race_index · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on ky_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_jyouken3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on ky_kigou · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on jy_syubetsu · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on grade · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on track · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_shiba · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on baba_dirt · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jra.php, line 1742File: APPPATH/classes/model/jra.php, line 1026File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2019032049'Connection name: default Speed: 1.489 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1063File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM race_schedules WHERE race_sc_id = '2018032049'Connection name: default Speed: 0.093 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: APPPATH/classes/model/nar.php, line 1076File: APPPATH/classes/model/nar.php, line 3136File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT kj_furlong_time FROM kj_htimes WHERE kj_id = '49'Connection name: default Speed: 0.120 ms · DUPLICATE Query analysis: · Query: SIMPLE on kj_htimes · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/nar.php, line 1135File: APPPATH/classes/model/nar.php, line 3142File: APPPATH/classes/model/jra.php, line 2579File: APPPATH/classes/model/jra.php, line 1092File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(kss.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(kss.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(kss.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(kss.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(kss.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(kss.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN KISYU as ks ON ur.KISYUCODE = ks.KISYUCODE LEFT JOIN KISYU_SEISEKI as kss ON ur.KISYUCODE = kss.KISYUCODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '09' AND kss.NUM <> 3 GROUP BY kss.KISYUCODEConnection name: default Speed: 1.549 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on kss · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 44 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3234File: APPPATH/classes/model/jra.php, line 1223File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT SUM(cks.HEICHICHAKUKAISU1) AS tyaku1_count, SUM(cks.HEICHICHAKUKAISU2) AS tyaku2_count, SUM(cks.HEICHICHAKUKAISU3) AS tyaku3_count, SUM(cks.HEICHICHAKUKAISU4) AS tyaku4_count, SUM(cks.HEICHICHAKUKAISU5) AS tyaku5_count, SUM(cks.HEICHICHAKUKAISU6) AS tyakugai_count FROM UMA_RACE as ur LEFT JOIN CHOKYO as ck ON ur.CHOKYOSICODE = ck.CHOKYOSICODE LEFT JOIN CHOKYO_SEISEKI as cks ON ur.CHOKYOSICODE = cks.CHOKYOSICODE WHERE ur.YEAR = '2020' AND ur.MONTHDAY = '0920' AND ur.JYOCD = '07' AND ur.RACENUM = '01' AND ur.UMABAN = '09' AND cks.NUM <> 3 GROUP BY cks.CHOKYOSICODEConnection name: default Speed: 1.550 ms Query analysis: · Query: SIMPLE on ur · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 307 (Using where; Using temporary; Using filesort) · Query: SIMPLE on ck · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: SIMPLE on cks · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/jra.php, line 3292File: APPPATH/classes/model/jra.php, line 1226File: APPPATH/classes/controller/front/jra.php, line 389File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT string FROM OSUSUME LIMIT 1Connection name: default Speed: 0.111 ms Query analysis: · Query: SIMPLE on OSUSUME · Type: system · Rows: 1 Call trace for this query:File: APPPATH/classes/model/narjra.php, line 86File: APPPATH/classes/controller/front/jra.php, line 637File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
SELECT * FROM OSUSUME2Connection name: default Speed: 0.119 ms · DUPLICATE Query analysis: · Query: SIMPLE on OSUSUME2 · Type: ALL · Rows: 15 Call trace for this query:File: APPPATH/classes/model/narjra.php, line 111File: APPPATH/classes/controller/front/jra.php, line 640File: COREPATH/base56.php, line 37File: COREPATH/classes/controller/hybrid.php, line 81File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 69 |
8Finder Paths |
115Total Files |
1.02 MB Total Size |
94.26 kB Largest |
Finder paths: |
/home/httpd/keiba0.com/fuel/app/ |
/home/httpd/keiba0.com/fuel/packages/auth/ |
/home/httpd/keiba0.com/fuel/packages/email/ |
/home/httpd/keiba0.com/fuel/packages/excel/ |
/home/httpd/keiba0.com/fuel/packages/ranking/ |
/home/httpd/keiba0.com/fuel/packages/parser/ |
/home/httpd/keiba0.com/fuel/packages/orm/ |
/home/httpd/keiba0.com/fuel/core/ |
Loaded files: |
2.33 kB /home/httpd/keiba0.com/html/index.php |
10.08 kB /home/httpd/keiba0.com/fuel/app/bootstrap.php |
9.39 kB /home/httpd/keiba0.com/fuel/core/classes/autoloader.php |
16.74 kB /home/httpd/keiba0.com/fuel/core/bootstrap.php |
14.68 kB /home/httpd/keiba0.com/fuel/core/base.php |
1.33 kB /home/httpd/keiba0.com/fuel/core/base56.php |
182 bytes /home/httpd/keiba0.com/fuel/vendor/autoload.php |
1.21 kB /home/httpd/keiba0.com/fuel/vendor/composer/autoload_real.php |
6.45 kB /home/httpd/keiba0.com/fuel/vendor/composer/ClassLoader.php |
317 bytes /home/httpd/keiba0.com/fuel/vendor/composer/autoload_namespaces.php |
155 bytes /home/httpd/keiba0.com/fuel/vendor/composer/autoload_classmap.php |
8.81 kB /home/httpd/keiba0.com/fuel/core/classes/fuel.php |
5.59 kB /home/httpd/keiba0.com/fuel/core/classes/config.php |
2.55 kB /home/httpd/keiba0.com/fuel/core/classes/config/php.php |
4.95 kB /home/httpd/keiba0.com/fuel/core/classes/config/file.php |
163 bytes /home/httpd/keiba0.com/fuel/core/classes/config/interface.php |
12.46 kB /home/httpd/keiba0.com/fuel/core/classes/finder.php |
33.64 kB /home/httpd/keiba0.com/fuel/core/classes/arr.php |
1.49 kB /home/httpd/keiba0.com/fuel/core/config/file.php |
11.01 kB /home/httpd/keiba0.com/fuel/core/config/config.php |
8.45 kB /home/httpd/keiba0.com/fuel/app/config/config.php |
493 bytes /home/httpd/keiba0.com/fuel/app/config/development/config.php |
14.34 kB /home/httpd/keiba0.com/fuel/core/classes/input.php |
1.73 kB /home/httpd/keiba0.com/fuel/core/classes/profiler.php |
2.46 kB /home/httpd/keiba0.com/fuel/core/vendor/phpquickprofiler/console.php |
6.60 kB /home/httpd/keiba0.com/fuel/core/vendor/phpquickprofiler/phpquickprofiler.php |
11.20 kB /home/httpd/keiba0.com/fuel/core/classes/security.php |
1.80 kB /home/httpd/keiba0.com/fuel/core/classes/event.php |
4.72 kB /home/httpd/keiba0.com/fuel/core/classes/event/instance.php |
3.36 kB /home/httpd/keiba0.com/fuel/core/classes/package.php |
2.01 kB /home/httpd/keiba0.com/fuel/packages/orm/bootstrap.php |
124 bytes /home/httpd/keiba0.com/fuel/packages/orm/config/orm.php |
1.27 kB /home/httpd/keiba0.com/fuel/packages/parser/bootstrap.php |
408 bytes /home/httpd/keiba0.com/fuel/packages/ranking/bootstrap.php |
567 bytes /home/httpd/keiba0.com/fuel/packages/excel/bootstrap.php |
2.88 kB /home/httpd/keiba0.com/fuel/packages/excel/classes/PHPExcel/Autoloader.php |
22.31 kB /home/httpd/keiba0.com/fuel/packages/excel/classes/PHPExcel/Shared/String.php |
2.07 kB /home/httpd/keiba0.com/fuel/packages/email/bootstrap.php |
2.35 kB /home/httpd/keiba0.com/fuel/packages/auth/bootstrap.php |
3.96 kB /home/httpd/keiba0.com/fuel/core/classes/module.php |
9.19 kB /home/httpd/keiba0.com/fuel/app/config/routes.php |
8.46 kB /home/httpd/keiba0.com/fuel/core/classes/router.php |
5.15 kB /home/httpd/keiba0.com/fuel/core/classes/route.php |
7.39 kB /home/httpd/keiba0.com/fuel/core/classes/redis/db.php |
13.68 kB /home/httpd/keiba0.com/fuel/core/classes/request.php |
8.35 kB /home/httpd/keiba0.com/fuel/core/classes/uri.php |
5.91 kB /home/httpd/keiba0.com/fuel/core/classes/log.php |
15.67 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Logger.php |
2.90 kB /home/httpd/keiba0.com/fuel/vendor/psr/log/Psr/Log/LoggerInterface.php |
2.13 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
1.47 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
3.80 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
2.44 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
2.84 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Formatter/LineFormatter.php |
2.47 kB /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php |
787 bytes /home/httpd/keiba0.com/fuel/vendor/monolog/monolog/src/Monolog/Formatter/FormatterInterface.php |
12.40 kB /home/httpd/keiba0.com/fuel/core/classes/inflector.php |
8.24 kB /home/httpd/keiba0.com/fuel/core/classes/lang.php |
3.09 kB /home/httpd/keiba0.com/fuel/core/classes/lang/php.php |
4.43 kB /home/httpd/keiba0.com/fuel/core/classes/lang/file.php |
174 bytes /home/httpd/keiba0.com/fuel/core/classes/lang/interface.php |
3.27 kB /home/httpd/keiba0.com/fuel/core/lang/en/inflector.php |
10.67 kB /home/httpd/keiba0.com/fuel/core/classes/str.php |
52.44 kB /home/httpd/keiba0.com/fuel/app/classes/controller/front/jra.php |
10.31 kB /home/httpd/keiba0.com/fuel/app/classes/controller/front/base.php |
2.99 kB /home/httpd/keiba0.com/fuel/core/classes/controller/hybrid.php |
12.91 kB /home/httpd/keiba0.com/fuel/core/classes/controller/rest.php |
1.55 kB /home/httpd/keiba0.com/fuel/core/classes/controller.php |
22.61 kB /home/httpd/keiba0.com/fuel/core/classes/theme.php |
6.49 kB /home/httpd/keiba0.com/fuel/core/classes/asset.php |
2.69 kB /home/httpd/keiba0.com/fuel/core/config/asset.php |
2.46 kB /home/httpd/keiba0.com/fuel/app/config/asset.php |
15.08 kB /home/httpd/keiba0.com/fuel/core/classes/asset/instance.php |
56.16 kB /home/httpd/keiba0.com/fuel/app/classes/model/narjra.php |
54.46 kB /home/httpd/keiba0.com/fuel/packages/orm/classes/model.php |
618 bytes /home/httpd/keiba0.com/fuel/core/classes/sanitization.php |
10.78 kB /home/httpd/keiba0.com/fuel/core/classes/db.php |
6.58 kB /home/httpd/keiba0.com/fuel/core/classes/database/query.php |
25.41 kB /home/httpd/keiba0.com/fuel/core/classes/database/connection.php |
1.76 kB /home/httpd/keiba0.com/fuel/core/config/db.php |
159 bytes /home/httpd/keiba0.com/fuel/app/config/db.php |
2.39 kB /home/httpd/keiba0.com/fuel/app/config/development/db.php |
15.68 kB /home/httpd/keiba0.com/fuel/core/classes/database/mysqli/connection.php |
17.36 kB /home/httpd/keiba0.com/fuel/core/classes/database/schema.php |
1.58 kB /home/httpd/keiba0.com/fuel/core/classes/database/mysqli/result.php |
7.40 kB /home/httpd/keiba0.com/fuel/core/classes/database/result.php |
2.12 kB /home/httpd/keiba0.com/fuel/packages/parser/classes/view.php |
14.86 kB /home/httpd/keiba0.com/fuel/core/classes/view.php |
6.39 kB /home/httpd/keiba0.com/fuel/packages/parser/config/parser.php |
1.92 kB /home/httpd/keiba0.com/fuel/app/classes/agent.php |
17.66 kB /home/httpd/keiba0.com/fuel/core/classes/agent.php |
3.22 kB /home/httpd/keiba0.com/fuel/core/config/agent.php |
2.56 kB /home/httpd/keiba0.com/fuel/app/config/agent.php |
4.54 kB /home/httpd/keiba0.com/fuel/core/classes/cache.php |
367 bytes /home/httpd/keiba0.com/fuel/core/classes/cache/notfound.php |
2.29 kB /home/httpd/keiba0.com/fuel/core/config/cache.php |
2.10 kB /home/httpd/keiba0.com/fuel/app/config/cache.php |
11.33 kB /home/httpd/keiba0.com/fuel/core/classes/cache/storage/memcached.php |
11.37 kB /home/httpd/keiba0.com/fuel/core/classes/cache/storage/driver.php |
94.26 kB /home/httpd/keiba0.com/fuel/app/classes/model/jra.php |
75.85 kB /home/httpd/keiba0.com/fuel/app/classes/model/nar.php |
477 bytes /home/httpd/keiba0.com/fuel/core/classes/cache/handler/serialized.php |
549 bytes /home/httpd/keiba0.com/fuel/core/classes/cache/handler/driver.php |
8.90 kB /home/httpd/keiba0.com/fuel/core/classes/response.php |
497 bytes /home/httpd/keiba0.com/fuel/app/views/front/layout.html |
730 bytes /home/httpd/keiba0.com/fuel/app/views/front/jra/headtag_meta_jra_detail.html |
766 bytes /home/httpd/keiba0.com/fuel/app/views/front/jra/headtag_css_jra_detail.html |
1.25 kB /home/httpd/keiba0.com/fuel/app/views/front/headtag_js.html |
133 bytes /home/httpd/keiba0.com/fuel/app/views/front/headtag_other.html |
0 bytes /home/httpd/keiba0.com/fuel/app/views/front/header_detail.html |
41.64 kB /home/httpd/keiba0.com/fuel/app/views/front/jra/detail_ver2.html |
3.83 kB /home/httpd/keiba0.com/fuel/core/classes/cookie.php |
42 bytes /home/httpd/keiba0.com/fuel/app/views/front/ad.html |
33.35 kB /home/httpd/keiba0.com/fuel/app/views/front/info/osusume.html |
450 bytes /home/httpd/keiba0.com/fuel/app/views/front/footer_detail.html |
476 Configuration items |
file |
› base_config |
null› › basedir |
null› › extensions |
null› › url |
null› › use_locks |
› › file_handlers |
› areas |
null› magic_file |
› chmod |
438› › files |
511› › folders |
/base_url |
url_suffix |
falseindex_file |
trueprofiling |
profiling_paths |
/home/httpd/keiba0.com/fuel/app/› APPPATH |
/home/httpd/keiba0.com/fuel/core/› COREPATH |
/home/httpd/keiba0.com/fuel/packages/› PKGPATH |
/home/httpd/keiba0.com/fuel/app/cache/cache_dir |
falsecaching |
3600cache_lifetime |
nullob_callback |
errors |
› continue_on |
10› throttle |
true› notices |
false› render_prior |
jalanguage |
enlanguage_fallback |
ja_JP.utf8locale |
UTF-8encoding |
0server_gmt_offset |
Asia/Tokyodefault_timezone |
99log_threshold |
nulllog_file |
/home/httpd/keiba0.com/fuel/app/logs/log_path |
Y-m-d H:i:slog_date_format |
falsecli_backtrace |
security |
false› csrf_autoload |
› csrf_autoload_methods |
post› › 0 |
put› › 1 |
delete› › 2 |
false› csrf_bad_request_on_fail |
false› csrf_auto_token |
_t› csrf_token_key |
0› csrf_expiration |
X{} f]N;2>-1p5ERqb9^y%7mh;>+@--oL<EP3rxAL^ K:<WI&lVh7Nb-y9}fN;;{› token_salt |
false› allow_x_headers |
3› htmlentities_flags |
false› htmlentities_double_encode |
true› auto_filter_output |
true› filter_closures |
› whitelisted_classes |
Fuel\Core\Response› › 0 |
Fuel\Core\View› › 1 |
Fuel\Core\ViewModel› › 2 |
Closure› › 3 |
Fuel\Core\Pagination› › 4 |
false› form-double-urlencoded |
› clean_paths |
› uri_filter |
htmlentities› › 0 |
› output_filter |
Security::htmlentities› › 0 |
› input_filter |
cookie |
0› expiration |
/› path |
null› domain |
false› secure |
false› http_only |
validation |
true› global_input_fallback |
Controller_controller_prefix |
routing |
true› case_sensitive |
true› strip_extension |
response |
true› redirect_with_wildcards |
config |
config› table_name |
null› database |
› memcached |
config› › identifier |
› › servers |
› › › 0 |
127.0.0.1› › › › host |
11211› › › › port |
100› › › › weight |
lang |
lang› table_name |
module_paths |
package_paths |
/home/httpd/keiba0.com/fuel/packages/› 0 |
always_load |
› packages |
orm› › 0 |
parser› › 1 |
ranking› › 2 |
excel› › 3 |
email› › 4 |
auth› › 5 |
› modules |
› classes |
› config |
› language |
event |
orm |
2038-01-18 22:14:08› sql_max_timestamp_mysql |
2147483647› sql_max_timestamp_unix |
routes |
/front/top/index› _root_ |
/front/error/404› _404_ |
/front/nar/index› nar |
/front/nar/index/$1› nar/(:num) |
/front/nar/list/$1/$2› nar/list/(:num)/(:num) |
/front/nar/detail/$1/$2/$3› nar/detail/(:num)/(:num)/(:num) |
/front/nar/detail/$1/$2/$3/$4› nar/detail/(:num)/(:num)/(:num)/(:num) |
/front/nar/umainfo/$1› nar/umainfo/(:any) |
/front/nar/umainfo/$1/$2› nar/umainfo/(:any)/(:num) |
/front/nar/login/$1/$2/$3› nar/login/(:num)/(:num)/(:num) |
/front/nar/loginlist/$1/$2› nar/loginlist/(:num)/(:num) |
/front/nar/loginexceldl› nar/loginexceldl |
/front/nar/excellist/$1/$2› nar/excellist/(:num)/(:num) |
/front/nar/excel/$1/$2/$3› nar/excel/(:num)/(:num)/(:num) |
/front/nar/exceldownload› nar/exceldownload |
/front/nar/alist/$1/$2› nar/alist/(:num)/(:num) |
/front/nar/adetail/$1/$2/$3› nar/adetail/(:num)/(:num)/(:num) |
/front/nar/aexcellist/$1/$2› nar/aexcellist/(:num)/(:num) |
/front/nar/aexcel/$1/$2/$3› nar/aexcel/(:num)/(:num)/(:num) |
/front/test/nartest/$1› nar/test/(:num) |
/front/jra/index› jra |
/front/jra/index/$1› jra/(:num) |
/front/jra/list/$1/$2› jra/list/(:num)/(:num) |
/front/jra/detail/$1/$2/$3› jra/detail/(:num)/(:num)/(:num) |
/front/jra/detail/$1/$2/$3/$4› jra/detail/(:num)/(:num)/(:num)/(:num) |
/front/jra/alist/$1/$2› jra/alist/(:num)/(:num) |
/front/jraold/alist/$1/$2› jra/alistold/(:num)/(:num) |
/front/jra/adetail/$1/$2/$3› jra/adetail/(:num)/(:num)/(:num) |
/front/jraold/adetail/$1/$2/$3› jra/adetailold/(:num)/(:num)/(:num) |
/front/jra/advcsv/$1› jra/advcsv/(:num) |
/front/jra/atari/$1/$2› jra/atari/(:any)/(:num) |
/front/jra/umainfo/$1› jra/umainfo/(:any) |
/front/jra/umainfo/$1/$2› jra/umainfo/(:any)/(:num) |
/front/world/index› world |
/front/world/detail/$1› world/detail/(:num) |
/front/world/detail/$1/$2› world/detail/(:num)/(:num) |
/front/login/index› login |
/front/login/logout› logout |
/front/yosou/index› yosou |
/front/yosou/index/$1› yosou/(:num) |
/front/yosou/yosoudetail/$1› yosou/detail/(:num) |
/front/yosou/yosouresult› yosou/result |
/front/yosou/yosouresult/$1› yosou/result/(:num) |
/front/yosou/yosouresult/$1/$2› yosou/result/(:num)/(:num) |
/front/yosou/yosouabout› yosou/about |
/front/yosou/yosouvoice› yosou/voice |
/front/yosou/yosougraph› yosou/graph |
/front/cgensen/index› yosou/gensen |
/front/cgensen/index/$1› yosou/gensen/(:num) |
/front/cgensen/detail/$1› yosou/gensen/detail/(:num) |
/front/cgensen/result› yosou/gensen/result |
/front/cgensen/result/$1› yosou/gensen/result/(:num) |
/front/cgensen/result/$1/$2› yosou/gensen/result/(:num)/(:num) |
/front/cgensen2/index› yosou/gensen2 |
/front/cgensen2/index/$1› yosou/gensen2/(:num) |
/front/cgensen2/detail/$1› yosou/gensen2/detail/(:num) |
/front/cgensen2/result› yosou/gensen2/result |
/front/cgensen2/result/$1› yosou/gensen2/result/(:num) |
/front/cgensen2/result/$1/$2› yosou/gensen2/result/(:num)/(:num) |
/front/cnext/index› next |
/front/fpoint/index› fpoint |
/front/fpoint/backend› fpoint/backend |
/front/soft/index› soft |
/front/soft/advmaster1› soft/advmaster1 |
/front/soft/advmaster1manual› soft/advmaster1manual |
/front/contact/index› contact |
/front/info/koukoku› koukoku |
/front/info/index› info |
/front/info/detail/$1› info/(:any) |
/front/contact/bankmail› bankmail |
/front/info/osusume› osusume |
/front/ifosusume/index› ifosusume |
/front/info/faq› faq |
/front/info/kiyaku› kiyaku |
/front/info/mikata› mikata |
/front/info/baken› baken |
/front/info/about› about |
/front/info/licence› licence |
/front/info/telecom› telecom |
/front/admin/admin› admin |
/front/admin/yosouindex› admin/yosouindex |
/front/admin/yosouindex/$1› admin/yosouindex/(:num) |
/front/admin/yosoulist/$1/$2› admin/yosoulist/(:num)/(:num) |
/front/admin/yosoudetail/$1/$2/$3› admin/yosoudetail/(:num)/(:num)/(:num) |
/front/admin/yosoutopcomment› admin/yosoutopcomment |
/front/admin/uriage› admin/uriage |
/front/admin/uriage/$1› admin/uriage/(:any) |
/front/admin/aff› admin/aff |
/front/admin/advanalynar› admin/advanaly/nar |
/front/admin/advanalyjra› admin/advanaly/jra |
/front/admin/advanalyfshiki› admin/advanaly/fshiki |
/front/admin/advanalynewfshiki› admin/advanaly/newfshiki |
/front/admin/yosoulist2/$1/$2› admin/yosoulist2/(:num)/(:num) |
/front/admin/yosoudetail2/$1/$2/$3› admin/yosoudetail2/(:num)/(:num)/(:num) |
/front/cgensen/admindetail/$1/$2/$3› admin/gensendetail/(:num)/(:num)/(:num) |
/front/cgensen/mailform› admin/mailform |
/front/cgensen/mailform/$1› admin/mailform/(:num) |
asset |
› paths |
› › 0 |
img/› img_dir |
js/› js_dir |
css/› css_dir |
› folders |
› › css |
› › js |
› › img |
/› url |
true› add_mtime |
1› indent_level |
› indent_with |
true› auto_render |
false› fail_silently |
false› always_resolve |
db |
default› active |
› default |
mysqli› › type |
› › connection |
› › › dsn |
localhost› › › hostname |
editor1› › › username |
editor1› › › password |
keiba0_test› › › database |
false› › › persistent |
false› › › compress |
`› › identifier |
› › table_prefix |
utf8› › charset |
false› › collation |
true› › enable_cache |
true› › profiling |
false› › readonly |
false› › caching |
› redis |
› › default |
127.0.0.1› › › hostname |
6379› › › port |
null› › › timeout |
0› › › database |
› dondon |
mysqli› › type |
› › connection |
localhost› › › hostname |
dondon› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
› openx2 |
mysqli› › type |
› › connection |
localhost› › › hostname |
openx2› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
› odds |
mysqli› › type |
› › connection |
localhost› › › hostname |
keiba0_odds› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
› wp |
mysqli› › type |
› › connection |
localhost› › › hostname |
keiba0_wp› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
› wp2 |
mysqli› › type |
› › connection |
localhost› › › hostname |
keiba0_wp7› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
› odds_jitaku |
mysqli› › type |
› › connection |
106.168.222.228› › › hostname |
everydb2› › › database |
editor1› › › username |
editor1› › › password |
false› › › persistent |
› › table_prefix |
utf8› › charset |
false› › caching |
true› › profiling |
parser |
› extensions |
View› › php |
View_Twig› › twig |
› › mthaml |
View_HamlTwig› › › class |
twig› › › extension |
View_Mustache› › mustache |
View_Markdown› › md |
› › dwoo |
View_Dwoo› › › class |
tpl› › › extension |
View_Jade› › jade |
View_Haml› › haml |
View_Smarty› › smarty |
View_Phptal› › phptal |
View_Lex› › lex |
› View_Markdown |
/home/httpd/keiba0.com/fuel/packages/parser/vendor/markdown/markdown.php› › include |
true› › auto_encode |
true› › allow_php |
› View_Twig |
true› › auto_encode |
› › views_paths |
/home/httpd/keiba0.com/fuel/app/views› › › 0 |
› › delimiters |
› › › tag_block |
{%› › › › left |
%}› › › › right |
› › › tag_comment |
{#› › › › left |
#}› › › › right |
› › › tag_variable |
{{› › › › left |
}}› › › › right |
› › environment |
false› › › debug |
utf-8› › › charset |
Twig_Template› › › base_template_class |
/home/httpd/keiba0.com/fuel/app/cache/twig/› › › cache |
true› › › auto_reload |
false› › › strict_variables |
false› › › autoescape |
-1› › › optimizations |
› › extensions |
Twig_Fuel_Extension› › › 0 |
› View_HamlTwig |
true› › auto_encode |
› › environment |
true› › › auto_escaper |
true› › › escape_html |
true› › › escape_attrs |
UTF-8› › › charset |
html5› › › format |
› View_Dwoo |
/home/httpd/keiba0.com/fuel/app/vendor/Dwoo/dwooAutoload.php› › include |
true› › auto_encode |
› › delimiters |
{{› › › left |
}}› › › right |
› › environment |
false› › › autoescape |
false› › › nested_comments |
false› › › allow_spaces |
/home/httpd/keiba0.com/fuel/app/cache/dwoo/› › › cache_dir |
/home/httpd/keiba0.com/fuel/app/cache/dwoo/compiled/› › › compile_dir |
0› › › cache_time |
2› › › allow_php_tags |
› › › allow_php_func |
› View_Mustache |
true› › auto_encode |
› › environment |
/home/httpd/keiba0.com/fuel/app/cache/mustache/› › › cache_dir |
› › › partials |
› › › helpers |
UTF-8› › › charset |
› View_Jade |
/home/httpd/keiba0.com/fuel/app/cache/jade/› › cache_dir |
/home/httpd/keiba0.com/fuel/app/vendor/Jade/autoload.php.dist› › include |
true› › auto_encode |
3600› › lifetime |
false› › pretty |
› View_Haml |
/home/httpd/keiba0.com/fuel/app/vendor/Phamlp/haml/HamlParser.php› › include |
true› › auto_encode |
/home/httpd/keiba0.com/fuel/app/cache/haml/› › cache_dir |
› View_Smarty |
true› › auto_encode |
› › delimiters |
{› › › left |
}› › › right |
› › environment |
/home/httpd/keiba0.com/fuel/app/tmp/Smarty/templates_c/› › › compile_dir |
/home/httpd/keiba0.com/fuel/app/tmp/Smarty/configs/› › › config_dir |
/home/httpd/keiba0.com/fuel/app/cache/Smarty/› › › cache_dir |
› › › plugins_dir |
false› › › caching |
0› › › cache_lifetime |
false› › › force_compile |
true› › › compile_check |
false› › › debugging |
› › › autoload_filters |
› › › default_modifiers |
› View_Phptal |
/home/httpd/keiba0.com/fuel/app/vendor/PHPTAL/PHPTAL.php› › include |
true› › auto_encode |
/home/httpd/keiba0.com/fuel/app/cache/PHPTAL/› › cache_dir |
0› › cache_lifetime |
UTF-8› › encoding |
PHPTAL::XHTML› › output_mode |
› › template_repository |
false› › force_reparse |
› View_Lex |
.› › scope_glue |
false› › allow_php |
agent |
› browscap |
false› › enabled |
http://browscap.org/stream?q=Lite_PHP_BrowsCapINI› › url |
wrapper› › method |
› › proxy |
null› › › host |
null› › › port |
none› › › auth |
null› › › username |
null› › › password |
/tmp/php_browscap.ini› › file |
› cache |
› › driver |
604800› › expiry |
fuel.agent› › identifier |
cache |
memcached› driver |
10› expiration |
› file |
› › path |
› memcached |
fuel› › cache_id |
› › servers |
› › › default |
127.0.0.1› › › › host |
11211› › › › port |
100› › › › weight |
› apc |
fuel› › cache_id |
› redis |
default› › database |
› xcache |
fuel› › cache_id |
1 GET variables |
/jra/detail/20200920/47/01 |
Based on PHP Quick Profiler | Close Height Bottom |