協賛 - ひろしまドイツクリスマスマーケット

Notice (8): Undefined index: LANG [APP/Controller/PagesController.php, line 77]

        $this->set('result',$res);
        
        $this->render("sponsor".$_SESSION['LANG']);

$res = array(
	(int) 0 => array(
		'displays' => array(
			'mid' => '48',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'hiroshimadentetsu@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '広島電鉄株式会社',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '10',
			'mdate' => '2020-10-26 09:05:35',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'JUcANTAsCZ481',
			'pstatus' => '10'
		)
	),
	(int) 1 => array(
		'displays' => array(
			'mid' => '49',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'hirodenkensetsu@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '広電建設株式会社',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '20',
			'mdate' => '2020-10-26 09:08:41',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'WTwbxhbK3t491',
			'pstatus' => '10'
		)
	),
	(int) 2 => array(
		'displays' => array(
			'mid' => '50',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'hirodenplaza@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社ヒロデンプラザ(広電ゴルフ、広電ボウル)',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '30',
			'mdate' => '2020-10-26 09:10:27',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'SZAqrk4Vqc501',
			'pstatus' => '10'
		)
	),
	(int) 3 => array(
		'displays' => array(
			'mid' => '64',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'alambic@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社アランビック',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '40',
			'mdate' => '2020-10-30 07:13:54',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'YYPpWDrBSj641',
			'pstatus' => '10'
		)
	),
	(int) 4 => array(
		'displays' => array(
			'mid' => '65',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'wako@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社WAKO',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '50',
			'mdate' => '2020-10-30 07:15:37',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'GbPB5Wggw2651',
			'pstatus' => '10'
		)
	),
	(int) 5 => array(
		'displays' => array(
			'mid' => '51',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'hometv@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '広島ホームテレビ（ヒロシマリード)',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '60',
			'mdate' => '2020-10-26 09:11:59',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'hhJkNVRTHx511',
			'pstatus' => '10'
		)
	),
	(int) 6 => array(
		'displays' => array(
			'mid' => '52',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'kubota@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社久保田本店',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '70',
			'mdate' => '2020-10-26 09:17:47',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'HvzazKbkj4521',
			'pstatus' => '10'
		)
	),
	(int) 7 => array(
		'displays' => array(
			'mid' => '53',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'asahikoukoku@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社広島朝日広告社',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '80',
			'mdate' => '2020-10-26 09:20:08',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'bnpkxxWyx3531',
			'pstatus' => '10'
		)
	),
	(int) 8 => array(
		'displays' => array(
			'mid' => '54',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'nakayoshi@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '中吉エンジニアリング株式会社',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '90',
			'mdate' => '2020-10-26 09:26:01',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'z5hhqFJEyF541',
			'pstatus' => '10'
		)
	),
	(int) 9 => array(
		'displays' => array(
			'mid' => '55',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'sugita@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社杉田三郎建築設計事務所',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '100',
			'mdate' => '2020-10-26 09:56:03',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'TXq22Z6G56551',
			'pstatus' => '10'
		)
	),
	(int) 10 => array(
		'displays' => array(
			'mid' => '56',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'dreambed@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => 'ドリームベッド株式会社',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '110',
			'mdate' => '2020-10-26 10:00:59',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'CmyDU6DrzR561',
			'pstatus' => '10'
		)
	),
	(int) 11 => array(
		'displays' => array(
			'mid' => '57',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'Felderchef@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => 'Felderchef',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '120',
			'mdate' => '2020-10-26 10:02:31',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'CXHZDDZxar571',
			'pstatus' => '10'
		)
	),
	(int) 12 => array(
		'displays' => array(
			'mid' => '58',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'ryouwa@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '株式会社良和ハウス',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '130',
			'mdate' => '2020-10-26 10:03:50',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'RZNyNUjEwd581',
			'pstatus' => '10'
		)
	),
	(int) 13 => array(
		'displays' => array(
			'mid' => '66',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'nigiwai@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '紙屋町基町にぎわいづくり協議会',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '140',
			'mdate' => '2020-10-30 07:16:20',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'jjEkS5FCAm661',
			'pstatus' => '10'
		)
	),
	(int) 14 => array(
		'displays' => array(
			'mid' => '68',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'byouricenter@actad.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '病理センター',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '150',
			'mdate' => '2020-11-10 08:48:43',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'vamyS7WcBY681',
			'pstatus' => '10'
		)
	),
	(int) 15 => array(
		'displays' => array(
			'mid' => '69',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'xmas@hi.enjoy.ne.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '  そごう広島店',
			'mdesc' => '',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '160',
			'mdate' => '2020-12-01 01:25:11',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'CLRk2tP7vY691',
			'pstatus' => '10'
		)
	),
	(int) 16 => array(
		'displays' => array(
			'mid' => '70',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'kimura@hi.enjoy.ne.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => '広島バスセンター',
			'mdesc' => '　　',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '170',
			'mdate' => '2020-12-01 01:32:31',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'mFVWybg7fC701',
			'pstatus' => '10'
		)
	),
	(int) 17 => array(
		'displays' => array(
			'mid' => '71',
			'mname' => '',
			'maddr' => '',
			'mroom' => '',
			'mtel' => '',
			'murl' => '',
			'memail' => 'masahiko@hi.enjoy.ne.jp',
			'mpassword' => null,
			'magent' => '',
			'mphone' => '',
			'mtype' => '4',
			'mtitle' => 'NTT都市開発',
			'mdesc' => '　　',
			'mcontact' => '',
			'myoutube' => '',
			'mlocation' => '0',
			'mlogin' => '10',
			'mstatus' => '10',
			'mupdate' => '10',
			'morder' => '180',
			'mdate' => '2020-12-01 01:35:11',
			'mpasscord' => null,
			'mlivedate' => null,
			'mlivestart' => null,
			'mliveend' => null,
			'mlivetext' => null
		),
		'photos' => array(
			'phash' => 'uBp5FVD7cD711',
			'pstatus' => '10'
		)
	)
)

PagesController::sponsor() - APP/Controller/PagesController.php, line 77
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 122

協賛

Query	Affected	Num. rows	Took (ms)	Actions
SELECT * FROM dynamics WHERE dlang=0 AND did<10 ORDER BY did;	2	2	0
SELECT * FROM configures WHERE config_id=1;	1	1	0
SELECT displays.*,phash,pstatus FROM displays LEFT JOIN members ON displays.mid=members.mid LEFT JOIN photos ON members.mid=photos.mid WHERE members.mtype=4 AND members.mstatus>=10 AND (porder=1 or porder is null) ORDER BY morder,mid	18	18	2	maybe slow

Message	Memory use
Component initialization	730 KB
Controller action start	1.04 MB
Controller render start	1.15 MB
View render complete	1.24 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.96
Event: Controller.initialize	4.00
Event: Controller.startup	0.58
Controller action	6.40
Event: Controller.beforeRender	6.22
» Processing toolbar data	6.13
Rendering View	23.03
» Event: View.beforeRender	0.03
» Rendering APP/View/Pages/sponsor.ctp	22.03
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/standard.ctp	0.42
» » Rendering APP/View/Elements/common/gmenu0.ctp	0.07
Event: View.afterLayout	0.00

Constant	Value
CONFIG	'/home/christmasmarket/www/dev/app/Config/'
DEV	true
DEBUG_LEVEL	(int) 2
SECURITY_SALT	'AYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi'
SECURITY_SEED	'16859309657453542496749683645'
COOKIE_DOMAIN	'hiroshima-christmasmarket.jp'
COOKIE_NAME	'christmasmarket'
SYSTEM_NAME	'ひろしまドイツクリスマスマーケット'
SYSTEM_NAME_EN	'Hiroshima Germany Christmas Market'
BASE_URL	'https://dev.hiroshima-christmasmarket.jp'
DB_HOST	'mysql57.christmasmarket.sakura.ne.jp'
DB_NAME	'christmasmarket_dev'
DB_LOGIN	'christmasmarket'
DB_PASSWORD	'bbc3ie4V2Wt8mZt'
ADMIN_MAIL	'info@digitalcreate.jp'
MAILFOOTER_URL	'https://hiroshima-christmasmarket.jp'
PICT_WIDTH	(int) 1020
PICT_HEIGHT	(int) 765

Constant	Value
APP	'/home/christmasmarket/www/dev/app/'
APP_DIR	'app'
APPLIBS	'/home/christmasmarket/www/dev/app/Lib/'
CACHE	'/home/christmasmarket/www/dev/app/tmp/cache/'
CAKE	'/home/christmasmarket/www/dev/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/home/christmasmarket/www/dev/lib'
CORE_PATH	'/home/christmasmarket/www/dev/lib/'
CAKE_VERSION	'2.10.14'
CSS	'/home/christmasmarket/www/dev/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'https://dev.hiroshima-christmasmarket.jp'
IMAGES	'/home/christmasmarket/www/dev/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/home/christmasmarket/www/dev/app/webroot/js/'
JS_URL	'js/'
LOGS	'/home/christmasmarket/www/dev/app/tmp/logs/'
ROOT	'/home/christmasmarket/www/dev'
TESTS	'/home/christmasmarket/www/dev/app/Test/'
TMP	'/home/christmasmarket/www/dev/app/tmp/'
VENDORS	'/home/christmasmarket/www/dev/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/home/christmasmarket/www/dev/app/webroot/'

ひろしまドイツクリスマス
マーケット 2022

協賛

default

Total Time: 2 ms
Total Queries: 3 queries

Query Explain:

Memory

Timers

Environment Variable	Value
Php Version	'7.4.33'
Redirect Redirect Https	'on'
Redirect Redirect Status	'200'
Redirect Https	'on'
Redirect Http Authorization	''
Redirect Status	'200'
Https	'on'
Http Authorization	''
Http Host	'dev.hiroshima-christmasmarket.jp'
Http X Real Ip	'216.73.216.115'
Http Listen Ipaddr	'133.242.249.194'
Http Accept	'/'
Http User Agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Http Accept Encoding	'gzip, br, zstd, deflate'
Path	'/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin'
Server Signature	''
Server Software	'Apache'
Server Name	'dev.hiroshima-christmasmarket.jp'
Server Addr	'100.64.0.90'
Server Port	'443'
Remote Addr	'216.73.216.115'
Document Root	'/home/christmasmarket/www/dev/'
Request Scheme	'https'
Context Prefix	''
Context Document Root	'/home/christmasmarket/www/dev/'
Server Admin	'[no address given]'
Script Filename	'/home/christmasmarket/www/dev/app/webroot/index.php'
Remote Port	'0'
Redirect Url	'/app/webroot/sponsor'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/sponsor'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1772736899.5099
Request Time	(int) 1772736899
Argc	(int) 0

協賛

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 2 ms Total Queries: 3 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 2 ms
Total Queries: 3 queries