Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Member`.`id`, `Member`.`name`, `Member`.`pref`, `Member`.`ward`, `Member`.`addr`, `Member`.`addr2`, `Member`.`addr_kana`, `Member`.`tel`, `Member`.`url`, `Member`.`created`, `Member`.`modified` FROM `tftc`.`members` AS `Member` WHERE YEAR(created) = '2024' AND MONTH(created) = '11'	0	0	2	maybe slow
SELECT COUNT(*) AS `count` FROM `tftc`.`members` AS `Member` WHERE 1 = 1	1	1	152	maybe slow
SELECT `Member`.`id`, `Member`.`name`, `Member`.`pref`, `Member`.`ward`, `Member`.`addr`, `Member`.`addr2`, `Member`.`addr_kana`, `Member`.`tel`, `Member`.`url`, `Member`.`created`, `Member`.`modified` FROM `tftc`.`members` AS `Member` WHERE `Member`.`pref` = '沖縄県' ORDER BY `Member`.`addr_kana` asc LIMIT 10, 10	10	10	1	maybe slow
SELECT COUNT(*) AS `count` FROM `tftc`.`members` AS `Member` WHERE `Member`.`pref` = '沖縄県'	1	1	1
SELECT COUNT(*) AS `count` FROM `tftc`.`members` AS `Member` WHERE `Member`.`pref` = '沖縄県'	1	1	1
SELECT `Member`.`id`, `Member`.`name`, `Member`.`pref`, `Member`.`ward`, `Member`.`addr`, `Member`.`addr2`, `Member`.`addr_kana`, `Member`.`tel`, `Member`.`url`, `Member`.`created`, `Member`.`modified` FROM `tftc`.`members` AS `Member` WHERE `Member`.`pref` = '沖縄県' ORDER BY `Member`.`addr_kana` asc LIMIT 10, 10	10	10	1	maybe slow
SELECT COUNT(*) AS `count` FROM `tftc`.`members` AS `Member` WHERE `Member`.`pref` = '沖縄県'	1	1	1

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	18.78
Event: Controller.initialize	0.03
Event: Controller.startup	0.25
Controller action	192.00
Event: Controller.beforeRender	69.54
» Processing toolbar data	69.44
Rendering View	12.20
» Event: View.beforeRender	0.03
» Rendering APP/View/Members/index.ctp	9.37
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	2.17
» » Rendering APP/View/Elements/favicon.ctp	0.11
» » Rendering APP/View/Elements/analyticstracking.ctp	0.07
» » Rendering APP/View/Elements/global-navigation.ctp	0.81
Event: View.afterLayout	0.00

Environment Variable	Value
Php Version	5.4.16
Redirect Redirect Unique Id	ZyQZ7jQhixw6emFMVyQJkAAAAAE
Redirect Redirect Lang	ja_JP.UTF-8
Redirect Redirect Status	200
Redirect Unique Id	ZyQZ7jQhixw6emFMVyQJkAAAAAE
Redirect Lang	ja_JP.UTF-8
Redirect Status	200
Unique Id	ZyQZ7jQhixw6emFMVyQJkAAAAAE
Lang	ja_JP.UTF-8
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
Http Host	www.tftc.gr.jp
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.tftc.gr.jp
Server Addr	182.93.119.225
Server Port	80
Remote Addr	3.144.12.29
Document Root	/var/www/html
Request Scheme	http
Context Prefix
Context Document Root	/var/www/html
Server Admin	root@tftc.gr.jp
Script Filename	/var/www/html/_test/webroot/index.php
Remote Port	59001
Redirect Query String	direction=asc&page=2
Redirect Url	/_test/webroot/members/index/pref:沖縄県
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String	direction=asc&page=2
Request Uri	/_test/members/index/pref:%E6%B2%96%E7%B8%84%E7%9C%8C?direction=asc&page=2
Script Name	/_test/webroot/index.php
Php Self	/_test/webroot/index.php
Request Time Float	1730419182.004
Request Time	1730419182

会員（店）とは

今月の新会員店