404 ページが見つかりません

Notice (8): Trying to access array offset on value of type bool [APP/Controller/AppController.php, line 98]Code Context        $this->Security->requireSecure();
        $this->agent = checkAgentClass::check();
        $this->dir = $this->agent["category"]=="phone"?"phone":"pc";
AppController::beforeFilter() - APP/Controller/AppController.php, line 98
WaitController::beforeFilter() - APP/Controller/WaitController.php, line 57
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 244
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 682
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 189
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/kir060294/public_html/testshop6.cross-test.xyz/index.php, line 111

Notice (8): Trying to access array offset on value of type bool [APP/Controller/AppController.php, line 98]Code Context        $this->Security->requireSecure();
        $this->agent = checkAgentClass::check();
        $this->dir = $this->agent["category"]=="phone"?"phone":"pc";
AppController::beforeFilter() - APP/Controller/AppController.php, line 98
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 244
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 682
ExceptionRenderer::_getController() - CORE/Cake/Error/ExceptionRenderer.php, line 158
ExceptionRenderer::__construct() - CORE/Cake/Error/ExceptionRenderer.php, line 95
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 126
[main] - [internal], line ??

404 ページが見つかりません

404

Not Found

TOP PAGE

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerwait
- actionindex
- named(empty)
- pass(empty)
- _Token(array)
  key9f7aeba2ee70ebf8d125d243eb56f7b7b474a38465e7ec12eaf1f6dea23a340bf3c45f74dd79f76ab819409f28b80bf036acc838659a2708ee3a88fbf3029366
  unlockedFields(empty)
- paging(array)
  Cast(array)
  page1
  current0
  count0
  prevPage(false)
  nextPage(false)
  pageCount0
  orderFIELD(Cast.id,491,76,260,502,340,483,364,81,410,246,315,369,56,284,336,78,405)
  limit20
  options(array)
  page2
  paramTypequerystring
  queryScope(null)
- isAjax(false)
Post data

No post data.

Query string
- page2
Cookie
- 0(empty)
Current Route
- keys(array)
  0controller
- options(array)
  defaultRoute(true)
- defaults(array)
  actionindex
  plugin(null)
- template/:controller
====

Sql Log

Sql Logs

default

Total Time: 10 ms
Total Queries: 36 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop6`.`settings` AS `Setting` WHERE 1 = 1	31	31	0
SHOW TABLE STATUS	32	32	4	maybe slow
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'normal_prices' AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc	9	9	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'delivery_prices' AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc	10	10	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'annotation' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 44 AND `display_flag` = '1' ORDER BY `number` asc	3	3	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'information' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 45 AND `display_flag` = '1' ORDER BY `number` asc	0	0	0
SELECT `Ranking`.`id`, `Ranking`.`display_flag`, `Ranking`.`title`, `Ranking`.`number`, `Ranking`.`created`, `Ranking`.`modified` FROM `kir060294_testshop6`.`rankings` AS `Ranking` WHERE `display_flag` = '1' ORDER BY `number` asc LIMIT 1	1	1	0
SELECT `Ranker`.`cast_id`, `Ranker`.`rank`, `Ranker`.`ranking_id` FROM `kir060294_testshop6`.`rankers` AS `Ranker` WHERE `Ranker`.`ranking_id` = (13) ORDER BY `Ranker`.`rank` asc	5	5	0
SELECT `FooterVendorBanner`.`id`, `FooterVendorBanner`.`display_flag`, `FooterVendorBanner`.`type`, `FooterVendorBanner`.`file_name`, `FooterVendorBanner`.`source`, `FooterVendorBanner`.`link`, `FooterVendorBanner`.`alt`, `FooterVendorBanner`.`new_tab`, `FooterVendorBanner`.`number`, `FooterVendorBanner`.`created`, `FooterVendorBanner`.`modifield` FROM `kir060294_testshop6`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc	0	0	0
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop6`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc	13	13	0
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop6`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc	22	22	0
SELECT `Reserve`.`cast_id` FROM `kir060294_testshop6`.`reserves` AS `Reserve` WHERE `Reserve`.`end` >= '2025-04-05 05:44:11' ORDER BY `Reserve`.`end` asc	0	0	0
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified`, `Reserve`.`id`, `Reserve`.`schedule_id`, `Reserve`.`cast_id`, `Reserve`.`start`, `Reserve`.`end`, `Reserve`.`created`, `Reserve`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` LEFT JOIN `kir060294_testshop6`.`reserves` AS `Reserve` ON (`Reserve`.`schedule_id` = `Schedule`.`id` AND `Reserve`.`start` >= '2025-04-05 09:00:00' AND `Reserve`.`end` <= '2025-04-06 05:00:00') WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (`Schedule`.`status` = 'normal') AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	0	0	1	maybe slow
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (`Schedule`.`status` = 'tentative') AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	17	17	1	maybe slow
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (`Schedule`.`status` = 'waitingList') AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	0	0	0
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (`Schedule`.`status` = 'soldOut') AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	0	0	0
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (((`Schedule`.`status` = 'closed') OR (`Schedule`.`end` > '2025-04-05 05:44:11'))) AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	17	17	1	maybe slow
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop6`.`schedules` AS `Schedule` WHERE ((NOT (`Schedule`.`cast_id` IS NULL)) AND (`Schedule`.`status` = 'absence') AND (`Schedule`.`start` >= '2025-04-05 09:00:00') AND (`Schedule`.`end` <= '2025-04-06 05:00:00')) ORDER BY `Schedule`.`start` asc	0	0	0
SELECT `Cast`.`id`, `Cast`.`group_id`, `Cast`.`display_flag`, `Cast`.`name`, `Cast`.`age`, `Cast`.`height`, `Cast`.`bust`, `Cast`.`cup`, `Cast`.`waist`, `Cast`.`hip`, `Cast`.`image_kind`, `Cast`.`real_time_information_flag`, `Cast`.`real_time_information_title`, `Cast`.`real_time_information_comment`, `Cast`.`real_time_information_number`, `Cast`.`delivery_flag`, `Cast`.`meet_up_flag`, `Cast`.`comment`, `Cast`.`heaven_id`, `Cast`.`extra_charge`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified`, `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified`, `Reserve`.`id`, `Reserve`.`schedule_id`, `Reserve`.`cast_id`, `Reserve`.`start`, `Reserve`.`end`, `Reserve`.`created`, `Reserve`.`modified` FROM `kir060294_testshop6`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop6`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id`) LEFT JOIN `kir060294_testshop6`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-05 09:00:00' AND `Reserve`.`end` <= '2025-04-06 05:00:00') WHERE `Cast`.`display_flag` = '1' AND `Schedule`.`start` >= '2025-04-05 09:00:00' AND `Schedule`.`end` <= '2025-04-06 05:00:00' ORDER BY FIELD(`Cast`.`id`,491,76,260,502,340,483,364,81,410,246,315,369,56,284,336,78,405) ASC LIMIT 20, 20	0	0	2	maybe slow
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop6`.`settings` AS `Setting` WHERE 1 = 1	31	31	0
SHOW TABLE STATUS	32	32	1
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'normal_prices' AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc	9	9	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'delivery_prices' AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc	10	10	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'annotation' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 44 AND `display_flag` = '1' ORDER BY `number` asc	3	3	0
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `name` = 'information' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1	1	1	0
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop6`.`prices` AS `Price` WHERE `parent_id` = 45 AND `display_flag` = '1' ORDER BY `number` asc	0	0	0
SELECT `Ranking`.`id`, `Ranking`.`display_flag`, `Ranking`.`title`, `Ranking`.`number`, `Ranking`.`created`, `Ranking`.`modified` FROM `kir060294_testshop6`.`rankings` AS `Ranking` WHERE `display_flag` = '1' ORDER BY `number` asc LIMIT 1	1	1	0
SELECT `Ranker`.`cast_id`, `Ranker`.`rank`, `Ranker`.`ranking_id` FROM `kir060294_testshop6`.`rankers` AS `Ranker` WHERE `Ranker`.`ranking_id` = (13) ORDER BY `Ranker`.`rank` asc	5	5	0
SELECT `FooterVendorBanner`.`id`, `FooterVendorBanner`.`display_flag`, `FooterVendorBanner`.`type`, `FooterVendorBanner`.`file_name`, `FooterVendorBanner`.`source`, `FooterVendorBanner`.`link`, `FooterVendorBanner`.`alt`, `FooterVendorBanner`.`new_tab`, `FooterVendorBanner`.`number`, `FooterVendorBanner`.`created`, `FooterVendorBanner`.`modifield` FROM `kir060294_testshop6`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc	0	0	0

13 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

cms

Total Time: 2 ms
Total Queries: 8 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE `id` = 3 LIMIT 1	1	1	0
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` = 3)) LIMIT 1	1	1	0
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, `Shop`.`default_linked_page`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` != 3)) ORDER BY `list_number` asc	10	10	1	maybe slow
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, `Shop`.`default_linked_page`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` != 3)) ORDER BY `list_number` asc	10	10	1	maybe slow
SELECT `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE `id` = 3 LIMIT 1	1	1	0
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` = 3)) LIMIT 1	1	1	0
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, `Shop`.`default_linked_page`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` != 3)) ORDER BY `list_number` asc	10	10	0
SELECT `Shop`.`id`, `Shop`.`display_flag`, `Shop`.`number`, `Shop`.`list_display_flag`, `Shop`.`list_number`, `Shop`.`category_jp`, `Shop`.`category_short`, `Shop`.`category_eng`, `Shop`.`name_jp`, `Shop`.`name_eng`, `Shop`.`area_eng`, `Shop`.`area_jp`, `Shop`.`db_name`, `Shop`.`scheme`, `Shop`.`domain`, `Shop`.`thumb`, `Shop`.`gm_key`, `Shop`.`pd`, `Shop`.`default_linked_page`, (X(location)) AS `Shop__lat`, (Y(location)) AS `Shop__lng` FROM `kir060294_newcms`.`shops` AS `Shop` WHERE ((`list_display_flag` = '1') AND (`id` != 3)) ORDER BY `list_number` asc	10	10	0

5 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 9.46 MB

Message	Memory use
Component initialization	770 KB
Controller action start	1.81 MB
Component initialization #2	2.05 MB
Controller action start #2	2.39 MB
Controller render start	2.50 MB
View render complete	2.60 MB

Timers

Total Request Time: 155 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	9.01
Event: Controller.initialize	38.82
Event: Controller.startup	0.34
Controller action	29.56
» Event: Controller.initialize #2	11.54
» Event: Controller.startup #2	0.09
Controller action #2	0.00
» Event: Controller.beforeRender	23.18
» » Processing toolbar data	23.12
» Rendering View	10.22
» » Event: View.beforeRender	0.01
» » Rendering APP/View/Errors/error400.ctp	4.96
» » Event: View.afterRender	0.01
» » Event: View.beforeLayout	0.01
» » Rendering APP/View/Layouts/error.ctp	4.95
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- nameNot Found
- messageNot Found
- url/wait?page=2
- error(object)
- _serialize(array)
  0name
  1message
  2url
- pureLoverSrchttps://purelovers.com/shop/21208/
- footerVendorBanners(empty)
- defaultRanking(array)
  Ranking(array)
  id13
  display_flag(true)
  title3月度指名ランキング
  number0
  created2024-10-01 03:12:15
  modified2025-04-02 14:52:52
  Ranker(array)
  0(array)
  cast_id2
  rank1
  ranking_id13
  1(array)
  cast_id406
  rank2
  ranking_id13
  2(array)
  cast_id284
  rank3
  ranking_id13
  3(array)
  cast_id364
  rank4
  ranking_id13
  4(array)
  cast_id278
  rank5
  ranking_id13
- creditLogoImages(array)
  0(array)
  src//img.real-group.love/creditCards/masterCard.svg
  altMASTER CARD
  classMasterCard
  1(array)
  src//img.real-group.love/creditCards/VISA.svg
  altVISA
  classVisa
  2(array)
  src//img.real-group.love/creditCards/americanExpress.svg
  altAMERICAN EXPRESS
  classAmericanExpress
  3(array)
  src//img.real-group.love/creditCards/JCB.svg
  altJCB
  classJcb
  4(array)
  src//img.real-group.love/creditCards/dinersClub.svg
  altDiners Club
  classDinersClub
  5(array)
  src//img.real-group.love/creditCards/discover.svg
  altDISCOVER
  classDiscover
- prices(array)
  normalPrice(array)
  title通常料金
  id1
  body(array)
  0(array)
  Price(array)
  id3
  display_flag(true)
  parent_id1
  name60分
  typeprice
  value14,000円
  top_value
  bottom_flag(false)
  number0
  created2020-11-21 17:28:28
  modified2021-08-07 15:02:49.0
  1(array)
  Price(array)
  id4
  display_flag(true)
  parent_id1
  name90分
  typeprice
  value20,000円
  top_value
  bottom_flag(false)
  number1
  created2020-11-21 17:28:28
  modified2021-08-07 15:02:49.0
  2(array)
  Price(array)
  id5
  display_flag(true)
  parent_id1
  name120分
  typeprice
  value29,000円
  top_value
  bottom_flag(false)
  number2
  created0000-00-00 00:00:00
  modified2021-08-07 15:02:49.0
  3(array)
  Price(array)
  id6
  display_flag(true)
  parent_id1
  name150分
  typeprice
  value37,000円
  top_value
  bottom_flag(false)
  number3
  created2020-11-21 17:28:28
  modified2021-08-07 15:02:49.0
  4(array)
  Price(array)
  id7
  display_flag(true)
  parent_id1
  name180分
  typeprice
  value45,000円
  top_value
  bottom_flag(false)
  number4
  created2020-11-21 17:28:28
  modified2021-08-07 15:02:49.0
  5(array)
  Price(array)
  id8
  display_flag(true)
  parent_id1
  nameTEL予約/本指名 ※御予約は1週間前より承ります。（ご新規様は当日予約のみ）
  typeprice
  value2,000円
  top_value
  bottom_flag(false)
  number5
  created2020-11-21 17:32:09
  modified2021-08-07 15:02:49.0
  6(array)
  Price(array)
  id9
  display_flag(true)
  parent_id1
  name入会金
  typeprice
  value1,000円
  top_value
  bottom_flag(false)
  number6
  created2020-11-21 17:32:09
  modified2021-08-07 15:02:49.0
  7(array)
  Price(array)
  id10
  display_flag(true)
  parent_id1
  nameパネル指名料
  typeprice
  value1,000円
  top_value
  bottom_flag(false)
  number7
  created2020-11-21 17:32:09
  modified2021-08-08 13:52:52.0
  8(array)
  Price(array)
  id11
  display_flag(true)
  parent_id1
  nameホテル代（オールタイム）
  typeprice
  value2,000円~
  top_value
  bottom_flag(true)
  number8
  created2020-11-21 17:32:09
  modified2021-12-01 18:21:28.0
  deliveryPrice(array)
  titleデリバリー料金
  id2
  body(array)
  0(array)
  Price(array)
  id12
  display_flag(true)
  parent_id2
  name60分
  typeprice
  value15,000円
  top_value
  bottom_flag(false)
  number0
  created2020-11-21 17:37:51
  modified2021-07-02 17:02:35.0
  1(array)
  Price(array)
  id13
  display_flag(true)
  parent_id2
  name75分
  typeprice
  value18,000円
  top_value
  bottom_flag(false)
  number1
  created2020-11-21 17:37:51
  modified2021-07-02 17:02:34.0
  2(array)
  Price(array)
  id14
  display_flag(true)
  parent_id2
  name90分
  typeprice
  value21,000円
  top_value
  bottom_flag(false)
  number2
  created2020-11-21 17:37:51
  modified2020-11-23 13:35:04.0
  3(array)
  Price(array)
  id15
  display_flag(true)
  parent_id2
  name120分
  typeprice
  value30,000円
  top_value
  bottom_flag(false)
  number3
  created2020-11-21 17:37:51
  modified2020-11-23 13:35:04.0
  4(array)
  Price(array)
  id16
  display_flag(true)
  parent_id2
  name150分
  typeprice
  value38,000円
  top_value
  bottom_flag(false)
  number4
  created2020-11-21 17:37:51
  modified2020-11-23 13:35:04.0
  5(array)
  Price(array)
  id17
  display_flag(true)
  parent_id2
  name180分
  typeprice
  value45,000円
  top_value
  bottom_flag(false)
  number5
  created2020-11-21 17:38:14
  modified2020-11-23 13:35:04.0
  6(array)
  Price(array)
  id18
  display_flag(true)
  parent_id2
  name本指名　※御予約は1週間前より承ります。
  typeprice
  value2,000円
  top_value
  bottom_flag(false)
  number6
  created2020-11-21 17:40:08
  modified2020-11-23 13:35:04.0
  7(array)
  Price(array)
  id19
  display_flag(true)
  parent_id2
  nameネットパネル指名料
  typeprice
  value1,000円
  top_value
  bottom_flag(false)
  number7
  created2020-11-21 17:40:08
  modified2020-11-23 13:35:04.0
  8(array)
  Price(array)
  id20
  display_flag(true)
  parent_id2
  nameチェンジ
  typeprice
  value5,000円
  top_value
  bottom_flag(false)
  number8
  created2020-11-21 17:40:08
  modified2020-11-23 13:35:04.0
  9(array)
  Price(array)
  id21
  display_flag(true)
  parent_id2
  nameキャンセル
  typeprice
  value10,000円
  top_value
  bottom_flag(false)
  number9
  created2020-11-21 17:40:08
  modified2020-11-23 13:35:04.0
  annotation(array)
  title特記事項
  id44
  body(array)
  0(array)
  Price(array)
  id22
  display_flag(true)
  parent_id44
  name特記事項1
  typetext
  value※別途「特別指名料金」や、イベント割り等の際にのみ＋1000円加算の女性も御座いますのでご了承下さいませ。
  top_value
  bottom_flag(false)
  number0
  created2020-11-21 18:09:59
  modified2021-08-22 15:16:01.0
  1(array)
  Price(array)
  id23
  display_flag(true)
  parent_id44
  namecredit card
  typetext
  value※カード手数料10％が加算されます。（支払い回数は1回のみ）
  top_value
  bottom_flag(false)
  number1
  created2020-11-21 18:09:59
  modified2021-08-07 15:46:17.0
  2(array)
  Price(array)
  id24
  display_flag(true)
  parent_id44
  name特記事項3
  typetext
  value上記の記載料金より、一切かかりません！ご安心下さい。
  top_value
  bottom_flag(false)
  number2
  created2020-11-21 19:16:55
  modified2022-09-23 16:56:33.0
  information(array)
  titleインフォメーション
  id44
  body(empty)
- cityHeavenShopUrlhttps://www.cityheaven.net/osaka/A2701/A270102/real_kyobashi/
- panelSetting(array)
  thumb(array)
  src//testshop6.cross-test.xyz/img/cast/thumb/
  width180
  detail(array)
  src//testshop6.cross-test.xyz/img/cast/390/
  width390
- detailSrc//testshop6.cross-test.xyz/img/cast/390/
- thumbSrc//testshop6.cross-test.xyz/img/cast/thumb/
- businessHours(array)
  openTime(array)
  Y2025
  m04
  n4
  d05
  N6
  j5
  H09
  G9
  i00
  stamp1743811200
  closeTime(array)
  Y2025
  m04
  n4
  d06
  N7
  j6
  H05
  G5
  i00
  stamp1743883200
  difference72000
- now(array)
  general(array)
  Y2025
  m04
  n4
  d05
  N6
  j5
  H05
  G5
  i44
  stamp1743799451
  site(array)
  Y2025
  m04
  n4
  d04
  j4
  H29
  G29
  prefix翌5
  i44
  stamp1743799440
  straddlingTheDay(true)
- maxQueryDayFeatureSpan8640000
- maxQueryDayPastSpan2678400
- $request->data(empty)
- $this->validationErrors(array)
  Setting(empty)
  Shop(empty)
  Cast(empty)
  CastImage(empty)
  Schedule(empty)
  Reserve(empty)
  Option(empty)
  HasOption(empty)
  Type(empty)
  HasType(empty)
  Price(empty)
  Ranking(empty)
  Ranker(empty)
  FooterVendorBanner(empty)
- Loaded Helpers(array)
  0MyHtml
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5HtmlToolbar
  6Html
  7Form
====

Environment

App Constants

Constant	Value
CONFIG	/home/kir060294/cakephp/testshop6.cross-test.xyz/Config/

CakePHP Constants

Constant	Value
APP	/home/kir060294/cakephp/testshop6.cross-test.xyz/
APP_DIR	testshop6.cross-test.xyz
APPLIBS	/home/kir060294/cakephp/testshop6.cross-test.xyz/Lib/
CACHE	/home/kir060294/cakephp/testshop6.cross-test.xyz/tmp/cache/
CAKE	/home/kir060294/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/kir060294/cakephp/lib
CORE_PATH	/home/kir060294/cakephp/lib/
CAKE_VERSION	2.10.24
CSS	/home/kir060294/public_html/testshop6.cross-test.xyz/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://testshop6.cross-test.xyz
IMAGES	/home/kir060294/public_html/testshop6.cross-test.xyz/img/
IMAGES_URL	img/
JS	/home/kir060294/public_html/testshop6.cross-test.xyz/js/
JS_URL	js/
LOGS	/home/kir060294/cakephp/testshop6.cross-test.xyz/tmp/logs/
ROOT	/home/kir060294/cakephp
TESTS	/home/kir060294/cakephp/testshop6.cross-test.xyz/Test/
TMP	/home/kir060294/cakephp/testshop6.cross-test.xyz/tmp/
VENDORS	/home/kir060294/cakephp/vendors/
WEBROOT_DIR	testshop6.cross-test.xyz
WWW_ROOT	/home/kir060294/public_html/testshop6.cross-test.xyz/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
Redirect Unique Id	Z_BEmwhiRVzzw_vpOQ_pkQAAAAE
Redirect Magick Thread Limit	1
Redirect Https	ON
Redirect Status	200
Unique Id	Z_BEmwhiRVzzw_vpOQ_pkQAAAAE
Magick Thread Limit	1
Https	ON
Http Host	testshop6.cross-test.xyz
Http X Real Ip	3.145.113.9
Http X Forwarded Proto	https
Http X Forwarded Host	testshop6.cross-test.xyz
Http X Forwarded Server	testshop6.cross-test.xyz
Http Connection	close
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	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	testshop6.cross-test.xyz
Server Addr	127.0.0.1
Server Port	80
Remote Addr	3.145.113.9
Document Root	/home/kir060294/public_html/testshop6.cross-test.xyz
Request Scheme	http
Context Prefix
Context Document Root	/home/kir060294/public_html/testshop6.cross-test.xyz
Server Admin	kir060294@kagoya.net
Script Filename	/home/kir060294/public_html/testshop6.cross-test.xyz/index.php
Remote Port	48406
Redirect Url	/wait
Redirect Query String	page=2
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String	page=2
Request Uri	/wait?page=2
Script Name	/index.php
Php Self	/index.php
Request Time Float	1743799451.7245
Request Time	1743799451
Argc	1

====

Include
+
Included Files

Include Paths
- 0/home/kir060294/cakephp/lib
- 2/opt/remi/php74/root/usr/share/pear
- 3/opt/remi/php74/root/usr/share/php
- 4/usr/share/pear
- 5/usr/share/php
- 6-> /home/kir060294/cakephp/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/SecurityComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/PaginatorComponent.php
  4CORE/Controller/Component/RequestHandlerComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  3CORE/Controller/CakeErrorController.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  2CORE/Error/ExceptionRenderer.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/WaitController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Setting.php
  1APP/Model/AppModel.php
  2APP/Model/Shop.php
  3APP/Model/Cast.php
  4APP/Model/CastImage.php
  5APP/Model/Schedule.php
  6APP/Model/Reserve.php
  7APP/Model/Option.php
  8APP/Model/HasOption.php
  9APP/Model/Type.php
  10APP/Model/HasType.php
  11APP/Model/Price.php
  12APP/Model/Ranking.php
  13APP/Model/Ranker.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 10 ms Total Queries: 36 queries

Query Explain:

cms

Total Time: 2 ms Total Queries: 8 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 10 ms
Total Queries: 36 queries

Total Time: 2 ms
Total Queries: 8 queries