Loto 7: Publics

Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 202]

            ),
            'pastAverageCount' => array(
                'numbers' => $pastExpectNumbers['numbers'],

$expectNumbers = array(
	'numbers' => array(
		(int) 1 => (int) 10,
		(int) 7 => (int) 16,
		(int) 5 => (int) 18,
		(int) 3 => (int) 22,
		(int) 6 => (int) 29,
		(int) 2 => (int) 30,
		(int) 4 => (int) 35
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '12',
			'target_degree' => '661',
			'parameter_id' => '12',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '75',
			'average_match_count' => '1.78',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-01-25 12:12:07',
			'modified' => '2026-01-25 12:12:07',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '12',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 662

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 202
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 203]

Code Context

            'pastAverageCount' => array(
                'numbers' => $pastExpectNumbers['numbers'],
                'appearance' => $pastExpectNumbers['appearance'],

$expectNumbers = array(
	'numbers' => array(
		(int) 1 => (int) 10,
		(int) 7 => (int) 16,
		(int) 5 => (int) 18,
		(int) 3 => (int) 22,
		(int) 6 => (int) 29,
		(int) 2 => (int) 30,
		(int) 4 => (int) 35
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '12',
			'target_degree' => '661',
			'parameter_id' => '12',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '75',
			'average_match_count' => '1.78',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-01-25 12:12:07',
			'modified' => '2026-01-25 12:12:07',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '12',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 662

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 203
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: numbers [APP/Controller/Component/CalcComponent.php, line 206]

Code Context

            ),
            'pastAverageMoney' => array(
                'numbers' => $pastMoneyExpectNumbers['numbers'],

$expectNumbers = array(
	'numbers' => array(
		(int) 1 => (int) 10,
		(int) 7 => (int) 16,
		(int) 5 => (int) 18,
		(int) 3 => (int) 22,
		(int) 6 => (int) 29,
		(int) 2 => (int) 30,
		(int) 4 => (int) 35
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '12',
			'target_degree' => '661',
			'parameter_id' => '12',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '75',
			'average_match_count' => '1.78',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-01-25 12:12:07',
			'modified' => '2026-01-25 12:12:07',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '12',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 662

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 206
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Notice (8): Undefined index: appearance [APP/Controller/Component/CalcComponent.php, line 207]

Code Context

            'pastAverageMoney' => array(
                'numbers' => $pastMoneyExpectNumbers['numbers'],
                'appearance' => $pastMoneyExpectNumbers['appearance'],

$expectNumbers = array(
	'numbers' => array(
		(int) 1 => (int) 10,
		(int) 7 => (int) 16,
		(int) 5 => (int) 18,
		(int) 3 => (int) 22,
		(int) 6 => (int) 29,
		(int) 2 => (int) 30,
		(int) 4 => (int) 35
	),
	'appearance' => array(
		'Appearance' => array(
			'id' => '12',
			'target_degree' => '661',
			'parameter_id' => '12',
			'pickup_id' => '1',
			'json' => array(
				[maximum depth reached]
			),
			'average_money' => '75',
			'average_match_count' => '1.78',
			'sample_count' => '100',
			'average_1_count' => '0',
			'average_2_count' => '0',
			'average_3_count' => '0',
			'created' => '2026-01-25 12:12:07',
			'modified' => '2026-01-25 12:12:07',
			'deleted' => false
		),
		'Parameter' => array(
			'id' => '12',
			'json' => array(
				[maximum depth reached]
			)
		),
		'Pickup' => array(
			'id' => '1',
			'json' => array(
				[maximum depth reached]
			)
		)
	)
)
$pastExpectNumbers = array()
$pastMoneyExpectNumbers = array()
$nextDegree = (int) 662

CalcComponent::getExpectNumbersByApperancesLatestAndPast() - APP/Controller/Component/CalcComponent.php, line 207
PublicsController::showAppearanceList() - APP/Controller/PublicsController.php, line 125
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 117

Page 1 of 1, showing 18 records out of 18 total, starting on record 1, ending on 18

import

remake

calcAp

mailAp

次回（第662回）予想ナンバー

array(4) { ["degree"]=> int(662) ["latest"]=> array(2) { ["numbers"]=> array(7) { [1]=> int(10) [7]=> int(16) [5]=> int(18) [3]=> int(22) [6]=> int(29) [2]=> int(30) [4]=> int(35) } ["appearance"]=> array(3) { ["Appearance"]=> array(14) { ["id"]=> string(2) "12" ["target_degree"]=> string(3) "661" ["parameter_id"]=> string(2) "12" ["pickup_id"]=> string(1) "1" ["json"]=> array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } } ["average_money"]=> string(2) "75" ["average_match_count"]=> string(4) "1.78" ["sample_count"]=> string(3) "100" ["average_1_count"]=> string(1) "0" ["average_2_count"]=> string(1) "0" ["average_3_count"]=> string(1) "0" ["created"]=> string(19) "2026-01-25 12:12:07" ["modified"]=> string(19) "2026-01-25 12:12:07" ["deleted"]=> bool(false) } ["Parameter"]=> array(2) { ["id"]=> string(2) "12" ["json"]=> array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> int(0) ["count"]=> int(100) } } ["Pickup"]=> array(2) { ["id"]=> string(1) "1" ["json"]=> array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) } } } } ["pastAverageCount"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } ["pastAverageMoney"]=> array(2) { ["numbers"]=> NULL ["appearance"]=> NULL } }

ID	平均金額	平均合致数	サンプル回数	json	パラメーター	ピックアップ
1	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(0) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
2	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.1) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
3	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.2) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
4	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.3) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
5	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.4) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
6	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.5) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
7	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.6) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
8	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.7) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
9	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.8) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
10	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> float(0.9) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
11	60	1.77	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(6000) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(2) ["6_count"]=> int(3) ["match_count"]=> int(177) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.949) ["bonusRate"]=> int(1) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
12	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> int(0) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
13	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.1) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
14	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.2) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
15	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.3) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
16	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.4) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
17	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.5) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }
18	75	1.78	100	array(3) { ["totals"]=> array(8) { ["money"]=> int(7500) ["1_count"]=> int(0) ["2_count"]=> int(0) ["3_count"]=> int(0) ["4_count"]=> int(0) ["5_count"]=> int(3) ["6_count"]=> int(3) ["match_count"]=> int(178) } ["details"]=> array(0) { } ["memos"]=> array(1) { [0]=> array(0) { } } }	array(4) { ["const"]=> int(0) ["base"]=> float(0.951) ["bonusRate"]=> float(0.6) ["count"]=> int(100) }	array(7) { [0]=> int(1) [1]=> int(2) [2]=> int(3) [3]=> int(4) [4]=> int(5) [5]=> int(6) [6]=> int(7) }

(default) 7 queries took 7 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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 50	18	18	1
2	SELECT `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` DESC	662	662	2
3	SELECT `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 1	1	1	0
4	SELECT `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` DESC	662	662	2
5	SELECT `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 1	0	0	0
6	SELECT `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` DESC	662	662	2
7	SELECT `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 1	0	0	0

(default) 7 queries took 7 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 50

SELECT `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` DESC

662

SELECT `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 1

662

SELECT `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 1