Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 198]
Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 199]
Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 202]
Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 203]
Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 206]
Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 207]
Loto 7: Publics
Page 1 of 1, showing 0 records out of 0 total, starting on record 0, ending on 0
次回(第662回)予想ナンバー
array(4) { ["degree"]=> int(662) ["latest"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } ["pastAverageCount"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } ["pastAverageMoney"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } }
ID 平均金額 平均一等回数 平均二等回数 平均三等回数 平均合致数 サンプル回数 json パラメーター ピックアップ
(default) 7 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Appearance`.`id`, `Appearance`.`target_degree`, `Appearance`.`parameter_id`, `Appearance`.`pickup_id`, `Appearance`.`json`, `Appearance`.`average_money`, `Appearance`.`average_match_count`, `Appearance`.`sample_count`, `Appearance`.`average_1_count`, `Appearance`.`average_2_count`, `Appearance`.`average_3_count`, `Appearance`.`created`, `Appearance`.`modified`, `Appearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto7`.`appearances` AS `Appearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`id` ASC LIMIT 50001
2SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC6626622
3SELECT `Appearance`.`id`, `Appearance`.`target_degree`, `Appearance`.`parameter_id`, `Appearance`.`pickup_id`, `Appearance`.`json`, `Appearance`.`average_money`, `Appearance`.`average_match_count`, `Appearance`.`sample_count`, `Appearance`.`average_1_count`, `Appearance`.`average_2_count`, `Appearance`.`average_3_count`, `Appearance`.`created`, `Appearance`.`modified`, `Appearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto7`.`appearances` AS `Appearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`Appearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`Appearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `Appearance`.`average_match_count` DESC, `Appearance`.`id` ASC LIMIT 1000
4SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC6626622
5SELECT `PastAppearance`.`id`, `PastAppearance`.`target_degree`, `PastAppearance`.`parameter_id`, `PastAppearance`.`pickup_id`, `PastAppearance`.`json`, `PastAppearance`.`average_money`, `PastAppearance`.`average_match_count`, `PastAppearance`.`sample_count`, `PastAppearance`.`average_1_count`, `PastAppearance`.`average_2_count`, `PastAppearance`.`average_3_count`, `PastAppearance`.`created`, `PastAppearance`.`modified`, `PastAppearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1000
6SELECT `Result`.`id`, `Result`.`degree`, `Result`.`result_date`, `Result`.`number_1`, `Result`.`number_2`, `Result`.`number_3`, `Result`.`number_4`, `Result`.`number_5`, `Result`.`number_6`, `Result`.`number_7`, `Result`.`number_b1`, `Result`.`number_b2` FROM `loto7`.`results` AS `Result` WHERE 1 = 1 ORDER BY `degree` DESC6626622
7SELECT `PastAppearance`.`id`, `PastAppearance`.`target_degree`, `PastAppearance`.`parameter_id`, `PastAppearance`.`pickup_id`, `PastAppearance`.`json`, `PastAppearance`.`average_money`, `PastAppearance`.`average_match_count`, `PastAppearance`.`sample_count`, `PastAppearance`.`average_1_count`, `PastAppearance`.`average_2_count`, `PastAppearance`.`average_3_count`, `PastAppearance`.`created`, `PastAppearance`.`modified`, `PastAppearance`.`deleted`, `Parameter`.`id`, `Parameter`.`json`, `Pickup`.`id`, `Pickup`.`json` FROM `loto7`.`past_appearances` AS `PastAppearance` LEFT JOIN `loto7`.`parameters` AS `Parameter` ON (`PastAppearance`.`parameter_id` = `Parameter`.`id`) LEFT JOIN `loto7`.`pickups` AS `Pickup` ON (`PastAppearance`.`pickup_id` = `Pickup`.`id`) WHERE 1 = 1 ORDER BY `PastAppearance`.`average_money` * `PastAppearance`.`average_match_count` DESC, `PastAppearance`.`id` ASC LIMIT 1001