Notice (8): Undefined index: STN [APP/Controller/SearchesController.php, line 283]Code Context$condition[$key][] = $stations[$k]."駅";
// 重複データを削除する
$condition[$key] = array_unique($condition[$key]);
$pass = [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ] $sort = 'created' $direction = 'asc' $page = (int) 1 $limit = (int) 10 $value = [ '' => (int) 1 ] $param = object(stdClass) { sort => 'created' direction => 'asc' page => (int) 1 limit => (int) 10 link => object(stdClass) {} search => [ 'NLK' => (int) 0, 'CLS' => (int) 0, 'FWD' => null, 'CTY' => [[maximum depth reached]], 'TWN' => [[maximum depth reached]], 'RTS' => [ [maximum depth reached] ], 'STN' => [ [maximum depth reached] ], 'SCH' => [[maximum depth reached]], 'SCT' => [[maximum depth reached]], 'SCD' => (int) 0, 'TYP' => [[maximum depth reached]], 'MDR' => [[maximum depth reached]], 'ILC' => [[maximum depth reached]], 'KWR' => [[maximum depth reached]], 'AFE' => [[maximum depth reached]], 'RFA' => [[maximum depth reached]], 'RTL' => (int) 0, 'RTB' => (int) 0, 'RTT' => (int) 0, 'STL' => (int) 0, 'STB' => (int) 0, 'STT' => (int) 0, 'AAL' => (int) 0, 'AAB' => (int) 0, 'AAT' => (int) 0, 'WLK' => (int) 0, 'BLD' => (int) 0, 'FLR' => (int) 0, 'LTT' => (int) 0, 'SHP' => (int) 0, 'LLT' => (int) 0, 'LLB' => (int) 0, 'VCY' => (int) 0 ] } $division_count = (int) 3 $row = 'STN' $key = 'STN' $v = (int) 1 $k = '' $condition = [ 'NLK' => [], 'CLS' => [], 'FWD' => [], 'CTY' => [], 'TWN' => [] ] $stations = [ (int) 9940401 => '二俣川', (int) 9940402 => '南万騎が原', (int) 9940403 => '緑園都市', (int) 9940404 => '弥生台', (int) 9940405 => 'いずみ野', (int) 9940406 => 'いずみ中央', (int) 9940407 => 'ゆめが丘', (int) 9940408 => '湘南台' ] $routes = (int) 99404App\Controller\SearchesController::getParam() - APP/Controller/SearchesController.php, line 283 App\Controller\SearchesController::index() - APP/Controller/SearchesController.php, line 32 Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 440 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 119 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 92 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 DebugKit\Middleware\DebugKitMiddleware::__invoke() - ROOT/vendor/cakephp/debug_kit/src/Middleware/DebugKitMiddleware.php, line 52 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 80
Warning (2): array_unique() expects parameter 1 to be array, null given [APP/Controller/SearchesController.php, line 283]Code Context$condition[$key][] = $stations[$k]."駅";
// 重複データを削除する
$condition[$key] = array_unique($condition[$key]);
$pass = [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ] $sort = 'created' $direction = 'asc' $page = (int) 1 $limit = (int) 10 $value = [ '' => (int) 1 ] $param = object(stdClass) { sort => 'created' direction => 'asc' page => (int) 1 limit => (int) 10 link => object(stdClass) {} search => [ 'NLK' => (int) 0, 'CLS' => (int) 0, 'FWD' => null, 'CTY' => [[maximum depth reached]], 'TWN' => [[maximum depth reached]], 'RTS' => [ [maximum depth reached] ], 'STN' => [ [maximum depth reached] ], 'SCH' => [[maximum depth reached]], 'SCT' => [[maximum depth reached]], 'SCD' => (int) 0, 'TYP' => [[maximum depth reached]], 'MDR' => [[maximum depth reached]], 'ILC' => [[maximum depth reached]], 'KWR' => [[maximum depth reached]], 'AFE' => [[maximum depth reached]], 'RFA' => [[maximum depth reached]], 'RTL' => (int) 0, 'RTB' => (int) 0, 'RTT' => (int) 0, 'STL' => (int) 0, 'STB' => (int) 0, 'STT' => (int) 0, 'AAL' => (int) 0, 'AAB' => (int) 0, 'AAT' => (int) 0, 'WLK' => (int) 0, 'BLD' => (int) 0, 'FLR' => (int) 0, 'LTT' => (int) 0, 'SHP' => (int) 0, 'LLT' => (int) 0, 'LLB' => (int) 0, 'VCY' => (int) 0 ] } $division_count = (int) 3 $row = 'STN' $key = 'STN' $v = (int) 1 $k = '' $condition = [ 'NLK' => [], 'CLS' => [], 'FWD' => [], 'CTY' => [], 'TWN' => [] ] $stations = [ (int) 9940401 => '二俣川', (int) 9940402 => '南万騎が原', (int) 9940403 => '緑園都市', (int) 9940404 => '弥生台', (int) 9940405 => 'いずみ野', (int) 9940406 => 'いずみ中央', (int) 9940407 => 'ゆめが丘', (int) 9940408 => '湘南台' ] $routes = (int) 99404array_unique - [internal], line ?? App\Controller\SearchesController::getParam() - APP/Controller/SearchesController.php, line 283 App\Controller\SearchesController::index() - APP/Controller/SearchesController.php, line 32 Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 440 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 119 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 92 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 DebugKit\Middleware\DebugKitMiddleware::__invoke() - ROOT/vendor/cakephp/debug_kit/src/Middleware/DebugKitMiddleware.php, line 52 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Warning (2): array_values() expects parameter 1 to be array, null given [APP/Controller/SearchesController.php, line 284]Code Context// 重複データを削除する
$condition[$key] = array_unique($condition[$key]);
$condition[$key] = array_values($condition[$key]);
$pass = [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ] $sort = 'created' $direction = 'asc' $page = (int) 1 $limit = (int) 10 $value = [ '' => (int) 1 ] $param = object(stdClass) { sort => 'created' direction => 'asc' page => (int) 1 limit => (int) 10 link => object(stdClass) {} search => [ 'NLK' => (int) 0, 'CLS' => (int) 0, 'FWD' => null, 'CTY' => [[maximum depth reached]], 'TWN' => [[maximum depth reached]], 'RTS' => [ [maximum depth reached] ], 'STN' => [ [maximum depth reached] ], 'SCH' => [[maximum depth reached]], 'SCT' => [[maximum depth reached]], 'SCD' => (int) 0, 'TYP' => [[maximum depth reached]], 'MDR' => [[maximum depth reached]], 'ILC' => [[maximum depth reached]], 'KWR' => [[maximum depth reached]], 'AFE' => [[maximum depth reached]], 'RFA' => [[maximum depth reached]], 'RTL' => (int) 0, 'RTB' => (int) 0, 'RTT' => (int) 0, 'STL' => (int) 0, 'STB' => (int) 0, 'STT' => (int) 0, 'AAL' => (int) 0, 'AAB' => (int) 0, 'AAT' => (int) 0, 'WLK' => (int) 0, 'BLD' => (int) 0, 'FLR' => (int) 0, 'LTT' => (int) 0, 'SHP' => (int) 0, 'LLT' => (int) 0, 'LLB' => (int) 0, 'VCY' => (int) 0 ] } $division_count = (int) 3 $row = 'STN' $key = 'STN' $v = (int) 1 $k = '' $condition = [ 'NLK' => [], 'CLS' => [], 'FWD' => [], 'CTY' => [], 'TWN' => [], 'STN' => null ] $stations = [ (int) 9940401 => '二俣川', (int) 9940402 => '南万騎が原', (int) 9940403 => '緑園都市', (int) 9940404 => '弥生台', (int) 9940405 => 'いずみ野', (int) 9940406 => 'いずみ中央', (int) 9940407 => 'ゆめが丘', (int) 9940408 => '湘南台' ] $routes = (int) 99404array_values - [internal], line ?? App\Controller\SearchesController::getParam() - APP/Controller/SearchesController.php, line 284 App\Controller\SearchesController::index() - APP/Controller/SearchesController.php, line 32 Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 440 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 119 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 92 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 DebugKit\Middleware\DebugKitMiddleware::__invoke() - ROOT/vendor/cakephp/debug_kit/src/Middleware/DebugKitMiddleware.php, line 52 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51
Warning (512): Unable to emit headers. Headers sent in file=/usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php line=822 [CORE/src/Http/ResponseEmitter.php, line 48]Code Context$message = "Unable to emit headers. Headers sent in file=$file line=$line";
if (Configure::read('debug')) {
trigger_error($message, E_USER_WARNING);
$response = object(Cake\Http\Response) { 'status' => (int) 500, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ], 'X-DEBUGKIT-ID' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $maxBufferLength = (int) 8192 $file = '/usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php' $line = (int) 822 $message = 'Unable to emit headers. Headers sent in file=/usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php line=822'Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 48 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105 [main] - /usr/share/nginx/html/concierent.sate5/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 148]Code Context$response->getProtocolVersion(),
$response->getStatusCode(),
($reasonPhrase ? ' ' . $reasonPhrase : '')
$response = object(Cake\Http\Response) { 'status' => (int) 500, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ], 'X-DEBUGKIT-ID' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $reasonPhrase = 'Internal Server Error'header - [internal], line ?? Cake\Http\ResponseEmitter::emitStatusLine() - CORE/src/Http/ResponseEmitter.php, line 148 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 54 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105 [main] - /usr/share/nginx/html/concierent.sate5/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]Code Context$name,
$value
), $first);
$response = object(Cake\Http\Response) { 'status' => (int) 500, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ], 'X-DEBUGKIT-ID' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $cookies = [] $values = [ (int) 0 => 'text/html; charset=UTF-8' ] $name = 'Content-Type' $first = true $value = 'text/html; charset=UTF-8'header - [internal], line ?? Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 181 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105 [main] - /usr/share/nginx/html/concierent.sate5/webroot/index.php, line 39
Warning (2): Cannot modify header information - headers already sent by (output started at /usr/share/nginx/html/concierent.sate5/project/vendor/cakephp/cakephp/src/Error/Debugger.php:822) [CORE/src/Http/ResponseEmitter.php, line 181]Code Context$name,
$value
), $first);
$response = object(Cake\Http\Response) { 'status' => (int) 500, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ [maximum depth reached] ], 'X-DEBUGKIT-ID' => [ [maximum depth reached] ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } $cookies = [] $values = [ (int) 0 => 'cc998f26-e50b-4534-977e-1055264994a7' ] $name = 'X-DEBUGKIT-ID' $first = true $value = 'cc998f26-e50b-4534-977e-1055264994a7'header - [internal], line ?? Cake\Http\ResponseEmitter::emitHeaders() - CORE/src/Http/ResponseEmitter.php, line 181 Cake\Http\ResponseEmitter::emit() - CORE/src/Http/ResponseEmitter.php, line 55 Cake\Http\Server::emit() - CORE/src/Http/Server.php, line 105 [main] - /usr/share/nginx/html/concierent.sate5/webroot/index.php, line 39
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR stations_id_2 = OR stations_id_3 = OR stations_id_4 = OR stations_id_5 = )' at line 1
$connection = $this->_driver->connection(); |
|
|
|
try { |
|
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults); |
|
$result = $this->_statement->execute($params); |
|
} finally { |
|
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); |
|
} |
|
|
null
public function execute($params = null) |
|
{ |
|
$this->_hasExecuted = true; |
|
|
|
return $this->_statement->execute($params); |
|
} |
|
|
|
/** |
|
* Returns the next row for the result set after executing this statement. |
null
$t = microtime(true); |
|
$query = new LoggedQuery(); |
|
|
|
try { |
|
$result = parent::execute($params); |
|
} catch (Exception $e) { |
|
$e->queryString = $this->queryString; |
|
$query->error = $e; |
|
$this->_log($query, $params, $t); |
null
public function run(Query $query) |
|
{ |
|
$statement = $this->prepare($query); |
|
$query->valueBinder()->attachTo($statement); |
|
$statement->execute(); |
|
|
|
return $statement; |
|
} |
|
|
No arguments
* @return \Cake\Database\StatementInterface |
|
*/ |
|
public function execute() |
|
{ |
|
$statement = $this->_connection->run($this); |
|
$driver = $this->_connection->driver(); |
|
$typeMap = $this->getSelectTypeMap(); |
|
|
|
if ($typeMap->toArray() && $this->_typeCastAttached === false) { |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT id AS `text`, articles.id AS `articles__id`, articles.class AS `articles__class`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, articles.title AS `articles__title`, articles.title_kana AS `articles__title_kana`, articles.title_hide AS `articles__title_hide`, articles.address AS `articles__address`, articles.address_etc AS `articles__address_etc`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route1`, (SELECT title FROM routes WHERE id = articles.routes_id_2 LIMIT 1) AS `route2`, (SELECT title FROM routes WHERE id = articles.routes_id_3 LIMIT 1) AS `route3`, (SELECT title FROM routes WHERE id = articles.routes_id_4 LIMIT 1) AS `route4`, (SELECT title FROM routes WHERE id = articles.routes_id_5 LIMIT 1) AS `route5`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station1`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_2 AND stations_id = articles.stations_id_2 LIMIT 1) AS `station2`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_3 AND stations_id = articles.stations_id_3 LIMIT 1) AS `station3`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_4 AND stations_id = articles.stations_id_4 LIMIT 1) AS `station4`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_5 AND stations_id = articles.stations_id_5 LIMIT 1) AS `station5`, articles.routes_id_1 AS `articles__routes_id_1`, articles.routes_id_2 AS `articles__routes_id_2`, articles.routes_id_3 AS `articles__routes_id_3`, articles.routes_id_4 AS `articles__routes_id_4`, articles.routes_id_5 AS `articles__routes_id_5`, articles.stations_id_1 AS `articles__stations_id_1`, articles.stations_id_2 AS `articles__stations_id_2`, articles.stations_id_3 AS `articles__stations_id_3`, articles.stations_id_4 AS `articles__stations_id_4`, articles.stations_id_5 AS `articles__stations_id_5`, articles.station_walk_1 AS `articles__station_walk_1`, articles.station_walk_2 AS `articles__station_walk_2`, articles.station_walk_3 AS `articles__station_walk_3`, articles.station_walk_4 AS `articles__station_walk_4`, articles.station_walk_5 AS `articles__station_walk_5`, articles.bus_time_1 AS `articles__bus_time_1`, articles.bus_time_2 AS `articles__bus_time_2`, articles.bus_time_3 AS `articles__bus_time_3`, articles.bus_time_4 AS `articles__bus_time_4`, articles.bus_time_5 AS `articles__bus_time_5`, articles.bus_stop_1 AS `articles__bus_stop_1`, articles.bus_stop_2 AS `articles__bus_stop_2`, articles.bus_stop_3 AS `articles__bus_stop_3`, articles.bus_stop_4 AS `articles__bus_stop_4`, articles.bus_stop_5 AS `articles__bus_stop_5`, articles.bus_stop_walk_1 AS `articles__bus_stop_walk_1`, articles.bus_stop_walk_2 AS `articles__bus_stop_walk_2`, articles.bus_stop_walk_3 AS `articles__bus_stop_walk_3`, articles.bus_stop_walk_4 AS `articles__bus_stop_walk_4`, articles.bus_stop_walk_5 AS `articles__bus_stop_walk_5`, articles.type AS `articles__type`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 900 DESC, class ASC LIMIT 1), 0) AS `imgs_id`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common ASC LIMIT 1), 0) AS `common_min`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common DESC LIMIT 1), 0) AS `common_max`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, articles.structures_id AS `articles__structures_id`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT '新 築' FROM articles b WHERE b.id = articles.id AND CONCAT(b.year, LPAD(b.month, 2, '0')) >= 201812 limit 1) AS `icon1`, (SELECT 'ペット相談可' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 3 OR facilities_id = 23 OR facilities_id = 308) LIMIT 1) AS `icon2`, (SELECT '分 譲' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 5 OR facilities_id = 17 OR facilities_id = 320) LIMIT 1) AS `icon3`, (SELECT 'デザイナーズ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 20 LIMIT 1) AS `icon4`, (SELECT '防犯カメラ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 357 LIMIT 1) AS `icon5`, (SELECT '24時間セキュリティ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 205 LIMIT 1) AS `icon6`, COALESCE((SELECT __created FROM rooms WHERE articles_id = articles.id ORDER BY __created DESC LIMIT 1), (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1)) AS `created`, COALESCE((SELECT __modified FROM rooms WHERE articles_id = articles.id ORDER BY __modified DESC LIMIT 1), (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1)) AS `modified`, (SELECT count(*) FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2) AS `vacancy` FROM articles articles WHERE (articles.flag = :c0 AND articles.class = :c1 AND EXISTS (SELECT rooms.articles_id AS `rooms__articles_id` FROM rooms rooms WHERE (rooms.flag = 2 AND EXISTS (SELECT id FROM articles WHERE id = rooms.articles_id AND flag = 2 LIMIT 1) AND rooms.status = :c0 AND rooms.articles_id IN (SELECT id FROM articles WHERE routes_id_1 = 11334 OR routes_id_2 = 11334 OR routes_id_3 = 11334 OR routes_id_4 = 11334 OR routes_id_5 = 11334) AND rooms.articles_id IN (SELECT id FROM articles WHERE stations_id_1 = OR stations_id_2 = OR stations_id_3 = OR stations_id_4 = OR stations_id_5 = ) AND articles.id = rooms.articles_id))) ORDER BY articles.created asc LIMIT 10 OFFSET 0', 'params' => [ ':c0' => [ 'value' => (int) 2, 'type' => 'integer', 'placeholder' => 'c0' ], ':c1' => [ 'value' => (int) 0, 'type' => 'integer', 'placeholder' => 'c1' ] ], 'defaultTypes' => [ 'articles__id' => 'biginteger', 'articles.id' => 'biginteger', 'id' => 'biginteger', 'articles__source_id' => 'string', 'articles.source_id' => 'string', 'source_id' => 'string', 'articles__class' => 'integer', 'articles.class' => 'integer', 'class' => 'integer', 'articles__flag' => 'integer', 'articles.flag' => 'integer', 'flag' => 'integer', 'articles__title' => 'string', 'articles.title' => 'string', 'title' => 'string', 'articles__title_hide' => 'integer', 'articles.title_hide' => 'integer', 'title_hide' => 'integer', 'articles__title_kana' => 'string', 'articles.title_kana' => 'string', 'title_kana' => 'string', 'articles__sub_title' => 'string', 'articles.sub_title' => 'string', 'sub_title' => 'string', 'articles__explanation' => 'text', 'articles.explanation' => 'text', 'explanation' => 'text', 'articles__recommend' => 'text', 'articles.recommend' => 'text', 'recommend' => 'text', 'articles__shops_id' => 'biginteger', 'articles.shops_id' => 'biginteger', 'shops_id' => 'biginteger', 'articles__staffs_id' => 'biginteger', 'articles.staffs_id' => 'biginteger', 'staffs_id' => 'biginteger', 'articles__postcode' => 'string', 'articles.postcode' => 'string', 'postcode' => 'string', 'articles__address' => 'string', 'articles.address' => 'string', 'address' => 'string', 'articles__address_etc' => 'text', 'articles.address_etc' => 'text', 'address_etc' => 'text', 'articles__routes_id_1' => 'biginteger', 'articles.routes_id_1' => 'biginteger', 'routes_id_1' => 'biginteger', 'articles__stations_id_1' => 'biginteger', 'articles.stations_id_1' => 'biginteger', 'stations_id_1' => 'biginteger', 'articles__station_walk_1' => 'integer', 'articles.station_walk_1' => 'integer', 'station_walk_1' => 'integer', 'articles__bus_time_1' => 'integer', 'articles.bus_time_1' => 'integer', 'bus_time_1' => 'integer', 'articles__bus_stop_1' => 'string', 'articles.bus_stop_1' => 'string', 'bus_stop_1' => 'string', 'articles__bus_stop_walk_1' => 'integer', 'articles.bus_stop_walk_1' => 'integer', 'bus_stop_walk_1' => 'integer', 'articles__schools_id_1' => 'biginteger', 'articles.schools_id_1' => 'biginteger', 'schools_id_1' => 'biginteger', 'articles__schools_distance_1' => 'integer', 'articles.schools_distance_1' => 'integer', 'schools_distance_1' => 'integer', 'articles__routes_id_2' => 'biginteger', 'articles.routes_id_2' => 'biginteger', 'routes_id_2' => 'biginteger', 'articles__stations_id_2' => 'biginteger', 'articles.stations_id_2' => 'biginteger', 'stations_id_2' => 'biginteger', 'articles__station_walk_2' => 'integer', 'articles.station_walk_2' => 'integer', 'station_walk_2' => 'integer', 'articles__bus_time_2' => 'integer', 'articles.bus_time_2' => 'integer', 'bus_time_2' => 'integer', 'articles__bus_stop_2' => 'string', 'articles.bus_stop_2' => 'string', 'bus_stop_2' => 'string', 'articles__bus_stop_walk_2' => 'integer', 'articles.bus_stop_walk_2' => 'integer', 'bus_stop_walk_2' => 'integer', 'articles__schools_id_2' => 'biginteger', 'articles.schools_id_2' => 'biginteger', 'schools_id_2' => 'biginteger', 'articles__schools_distance_2' => 'integer', 'articles.schools_distance_2' => 'integer', 'schools_distance_2' => 'integer', 'articles__routes_id_3' => 'biginteger', 'articles.routes_id_3' => 'biginteger', 'routes_id_3' => 'biginteger', 'articles__stations_id_3' => 'biginteger', 'articles.stations_id_3' => 'biginteger', 'stations_id_3' => 'biginteger', 'articles__station_walk_3' => 'integer', 'articles.station_walk_3' => 'integer', 'station_walk_3' => 'integer', 'articles__bus_time_3' => 'integer', 'articles.bus_time_3' => 'integer', 'bus_time_3' => 'integer', 'articles__bus_stop_3' => 'string', 'articles.bus_stop_3' => 'string', 'bus_stop_3' => 'string', 'articles__bus_stop_walk_3' => 'integer', 'articles.bus_stop_walk_3' => 'integer', 'bus_stop_walk_3' => 'integer', 'articles__schools_id_3' => 'biginteger', 'articles.schools_id_3' => 'biginteger', 'schools_id_3' => 'biginteger', 'articles__schools_distance_3' => 'integer', 'articles.schools_distance_3' => 'integer', 'schools_distance_3' => 'integer', 'articles__routes_id_4' => 'biginteger', 'articles.routes_id_4' => 'biginteger', 'routes_id_4' => 'biginteger', 'articles__stations_id_4' => 'biginteger', 'articles.stations_id_4' => 'biginteger', 'stations_id_4' => 'biginteger', 'articles__station_walk_4' => 'integer', 'articles.station_walk_4' => 'integer', 'station_walk_4' => 'integer', 'articles__bus_time_4' => 'integer', 'articles.bus_time_4' => 'integer', 'bus_time_4' => 'integer', 'articles__bus_stop_4' => 'string', 'articles.bus_stop_4' => 'string', 'bus_stop_4' => 'string', 'articles__bus_stop_walk_4' => 'integer', 'articles.bus_stop_walk_4' => 'integer', 'bus_stop_walk_4' => 'integer', 'articles__schools_id_4' => 'biginteger', 'articles.schools_id_4' => 'biginteger', 'schools_id_4' => 'biginteger', 'articles__schools_distance_4' => 'integer', 'articles.schools_distance_4' => 'integer', 'schools_distance_4' => 'integer', 'articles__routes_id_5' => 'biginteger', 'articles.routes_id_5' => 'biginteger', 'routes_id_5' => 'biginteger', 'articles__stations_id_5' => 'biginteger', 'articles.stations_id_5' => 'biginteger', 'stations_id_5' => 'biginteger', 'articles__station_walk_5' => 'integer', 'articles.station_walk_5' => 'integer', 'station_walk_5' => 'integer', 'articles__bus_time_5' => 'integer', 'articles.bus_time_5' => 'integer', 'bus_time_5' => 'integer', 'articles__bus_stop_5' => 'string', 'articles.bus_stop_5' => 'string', 'bus_stop_5' => 'string', 'articles__bus_stop_walk_5' => 'integer', 'articles.bus_stop_walk_5' => 'integer', 'bus_stop_walk_5' => 'integer', 'articles__schools_id_5' => 'biginteger', 'articles.schools_id_5' => 'biginteger', 'schools_id_5' => 'biginteger', 'articles__schools_distance_5' => 'integer', 'articles.schools_distance_5' => 'integer', 'schools_distance_5' => 'integer', 'articles__type' => 'integer', 'articles.type' => 'integer', 'type' => 'integer', 'articles__structures_id' => 'biginteger', 'articles.structures_id' => 'biginteger', 'structures_id' => 'biginteger', 'articles__parking' => 'integer', 'articles.parking' => 'integer', 'parking' => 'integer', 'articles__rooms' => 'integer', 'articles.rooms' => 'integer', 'rooms' => 'integer', 'articles__floor' => 'integer', 'articles.floor' => 'integer', 'floor' => 'integer', 'articles__floor_under' => 'integer', 'articles.floor_under' => 'integer', 'floor_under' => 'integer', 'articles__year' => 'integer', 'articles.year' => 'integer', 'year' => 'integer', 'articles__month' => 'integer', 'articles.month' => 'integer', 'month' => 'integer', 'articles__information' => 'json', 'articles.information' => 'json', 'information' => 'json', 'articles__media' => 'json', 'articles.media' => 'json', 'media' => 'json', 'articles__remarks' => 'text', 'articles.remarks' => 'text', 'remarks' => 'text', 'articles__memo' => 'text', 'articles.memo' => 'text', 'memo' => 'text', 'articles__mcompanies_id' => 'biginteger', 'articles.mcompanies_id' => 'biginteger', 'mcompanies_id' => 'biginteger', 'articles__lat' => 'float', 'articles.lat' => 'float', 'lat' => 'float', 'articles__lng' => 'float', 'articles.lng' => 'float', 'lng' => 'float', 'articles__seo_keywords' => 'text', 'articles.seo_keywords' => 'text', 'seo_keywords' => 'text', 'articles__seo_description' => 'text', 'articles.seo_description' => 'text', 'seo_description' => 'text', 'articles__access' => 'biginteger', 'articles.access' => 'biginteger', 'access' => 'biginteger', 'articles__autoupdate_link' => 'string', 'articles.autoupdate_link' => 'string', 'autoupdate_link' => 'string', 'articles__autoupdate_flag' => 'integer', 'articles.autoupdate_flag' => 'integer', 'autoupdate_flag' => 'integer', 'articles__autoupdate_priority' => 'integer', 'articles.autoupdate_priority' => 'integer', 'autoupdate_priority' => 'integer', 'articles__admins_id' => 'biginteger', 'articles.admins_id' => 'biginteger', 'admins_id' => 'biginteger', 'articles____created' => 'datetime', 'articles.__created' => 'datetime', '__created' => 'datetime', 'articles____modified' => 'datetime', 'articles.__modified' => 'datetime', '__modified' => 'datetime', 'articles__created' => 'datetime', 'articles.created' => 'datetime', 'created' => 'datetime', 'articles__modified' => 'datetime', 'articles.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [ 'scope' => null, 'whitelist' => [ (int) 0 => 'limit', (int) 1 => 'sort', (int) 2 => 'page', (int) 3 => 'direction' ] ], 'repository' => object(App\Model\Table\ArticlesTable) { 'registryAlias' => 'Articles', 'table' => 'articles', 'alias' => 'articles', 'entityClass' => 'App\Model\Entity\Article', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } }
|
|
return new $decorator($this->_results); |
|
} |
|
|
|
$statement = $this->getEagerLoader()->loadExternal($this, $this->execute()); |
|
|
|
return new ResultSet($this, $statement); |
|
} |
|
|
No arguments
if ($this->_cache) { |
|
$results = $this->_cache->fetch($this); |
|
} |
|
if (!isset($results)) { |
|
$results = $this->_decorateResults($this->_execute()); |
|
if ($this->_cache) { |
|
$this->_cache->store($this, $results); |
|
} |
|
} |
No arguments
'You cannot call all() on a non-select query. Use execute() instead.' |
|
); |
|
} |
|
|
|
return $this->_all(); |
|
} |
|
|
|
/** |
|
* Trigger the beforeFind event on the query's repository object. |
No arguments
} else { |
|
$query->applyOptions($options); |
|
} |
|
|
|
$results = $query->all(); |
|
$numResults = count($results); |
|
$count = $numResults ? $query->count() : 0; |
|
|
|
$defaults = $this->getDefaults($alias, $settings); |
No arguments
throw new RuntimeException('Unable to locate an object compatible with paginate.'); |
|
} |
|
$settings += $this->paginate; |
|
|
|
return $this->Paginator->paginate($table, $settings); |
|
} |
|
|
|
/** |
|
* Method to check that an action is accessible from a URL. |
object(App\Model\Table\ArticlesTable) { 'registryAlias' => 'Articles', 'table' => 'articles', 'alias' => 'articles', 'entityClass' => 'App\Model\Entity\Article', 'associations' => [], 'behaviors' => [ (int) 0 => 'Timestamp' ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [ 'order' => [ 'created' => 'asc' ], 'page' => (int) 1, 'limit' => (int) 10, 'maxLimit' => (int) 200 ]
// リスト取得 |
|
try { |
|
// キャッシュがある場合、ない場合 |
|
if (($rows = Cache::read($cache->key, "file")) === false) { |
|
$rows = $this->paginate($this->Articles->getList($param->search)); |
|
foreach ($rows as $item) $this->Articles->entity($item, $param->search); |
|
Cache::write($cache->key, $rows, "file"); |
|
} else { |
|
$cache->enable = true; |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT id AS `text`, articles.id AS `articles__id`, articles.class AS `articles__class`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, articles.title AS `articles__title`, articles.title_kana AS `articles__title_kana`, articles.title_hide AS `articles__title_hide`, articles.address AS `articles__address`, articles.address_etc AS `articles__address_etc`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route1`, (SELECT title FROM routes WHERE id = articles.routes_id_2 LIMIT 1) AS `route2`, (SELECT title FROM routes WHERE id = articles.routes_id_3 LIMIT 1) AS `route3`, (SELECT title FROM routes WHERE id = articles.routes_id_4 LIMIT 1) AS `route4`, (SELECT title FROM routes WHERE id = articles.routes_id_5 LIMIT 1) AS `route5`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station1`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_2 AND stations_id = articles.stations_id_2 LIMIT 1) AS `station2`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_3 AND stations_id = articles.stations_id_3 LIMIT 1) AS `station3`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_4 AND stations_id = articles.stations_id_4 LIMIT 1) AS `station4`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_5 AND stations_id = articles.stations_id_5 LIMIT 1) AS `station5`, articles.routes_id_1 AS `articles__routes_id_1`, articles.routes_id_2 AS `articles__routes_id_2`, articles.routes_id_3 AS `articles__routes_id_3`, articles.routes_id_4 AS `articles__routes_id_4`, articles.routes_id_5 AS `articles__routes_id_5`, articles.stations_id_1 AS `articles__stations_id_1`, articles.stations_id_2 AS `articles__stations_id_2`, articles.stations_id_3 AS `articles__stations_id_3`, articles.stations_id_4 AS `articles__stations_id_4`, articles.stations_id_5 AS `articles__stations_id_5`, articles.station_walk_1 AS `articles__station_walk_1`, articles.station_walk_2 AS `articles__station_walk_2`, articles.station_walk_3 AS `articles__station_walk_3`, articles.station_walk_4 AS `articles__station_walk_4`, articles.station_walk_5 AS `articles__station_walk_5`, articles.bus_time_1 AS `articles__bus_time_1`, articles.bus_time_2 AS `articles__bus_time_2`, articles.bus_time_3 AS `articles__bus_time_3`, articles.bus_time_4 AS `articles__bus_time_4`, articles.bus_time_5 AS `articles__bus_time_5`, articles.bus_stop_1 AS `articles__bus_stop_1`, articles.bus_stop_2 AS `articles__bus_stop_2`, articles.bus_stop_3 AS `articles__bus_stop_3`, articles.bus_stop_4 AS `articles__bus_stop_4`, articles.bus_stop_5 AS `articles__bus_stop_5`, articles.bus_stop_walk_1 AS `articles__bus_stop_walk_1`, articles.bus_stop_walk_2 AS `articles__bus_stop_walk_2`, articles.bus_stop_walk_3 AS `articles__bus_stop_walk_3`, articles.bus_stop_walk_4 AS `articles__bus_stop_walk_4`, articles.bus_stop_walk_5 AS `articles__bus_stop_walk_5`, articles.type AS `articles__type`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 900 DESC, class ASC LIMIT 1), 0) AS `imgs_id`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common ASC LIMIT 1), 0) AS `common_min`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common DESC LIMIT 1), 0) AS `common_max`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, articles.structures_id AS `articles__structures_id`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT '新 築' FROM articles b WHERE b.id = articles.id AND CONCAT(b.year, LPAD(b.month, 2, '0')) >= 201812 limit 1) AS `icon1`, (SELECT 'ペット相談可' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 3 OR facilities_id = 23 OR facilities_id = 308) LIMIT 1) AS `icon2`, (SELECT '分 譲' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 5 OR facilities_id = 17 OR facilities_id = 320) LIMIT 1) AS `icon3`, (SELECT 'デザイナーズ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 20 LIMIT 1) AS `icon4`, (SELECT '防犯カメラ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 357 LIMIT 1) AS `icon5`, (SELECT '24時間セキュリティ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 205 LIMIT 1) AS `icon6`, COALESCE((SELECT __created FROM rooms WHERE articles_id = articles.id ORDER BY __created DESC LIMIT 1), (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1)) AS `created`, COALESCE((SELECT __modified FROM rooms WHERE articles_id = articles.id ORDER BY __modified DESC LIMIT 1), (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1)) AS `modified`, (SELECT count(*) FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2) AS `vacancy` FROM articles articles WHERE (articles.flag = :c0 AND articles.class = :c1 AND EXISTS (SELECT rooms.articles_id AS `rooms__articles_id` FROM rooms rooms WHERE (rooms.flag = 2 AND EXISTS (SELECT id FROM articles WHERE id = rooms.articles_id AND flag = 2 LIMIT 1) AND rooms.status = :c0 AND rooms.articles_id IN (SELECT id FROM articles WHERE routes_id_1 = 11334 OR routes_id_2 = 11334 OR routes_id_3 = 11334 OR routes_id_4 = 11334 OR routes_id_5 = 11334) AND rooms.articles_id IN (SELECT id FROM articles WHERE stations_id_1 = OR stations_id_2 = OR stations_id_3 = OR stations_id_4 = OR stations_id_5 = ) AND articles.id = rooms.articles_id))) ORDER BY articles.created asc LIMIT 10 OFFSET 0', 'params' => [ ':c0' => [ 'value' => (int) 2, 'type' => 'integer', 'placeholder' => 'c0' ], ':c1' => [ 'value' => (int) 0, 'type' => 'integer', 'placeholder' => 'c1' ] ], 'defaultTypes' => [ 'articles__id' => 'biginteger', 'articles.id' => 'biginteger', 'id' => 'biginteger', 'articles__source_id' => 'string', 'articles.source_id' => 'string', 'source_id' => 'string', 'articles__class' => 'integer', 'articles.class' => 'integer', 'class' => 'integer', 'articles__flag' => 'integer', 'articles.flag' => 'integer', 'flag' => 'integer', 'articles__title' => 'string', 'articles.title' => 'string', 'title' => 'string', 'articles__title_hide' => 'integer', 'articles.title_hide' => 'integer', 'title_hide' => 'integer', 'articles__title_kana' => 'string', 'articles.title_kana' => 'string', 'title_kana' => 'string', 'articles__sub_title' => 'string', 'articles.sub_title' => 'string', 'sub_title' => 'string', 'articles__explanation' => 'text', 'articles.explanation' => 'text', 'explanation' => 'text', 'articles__recommend' => 'text', 'articles.recommend' => 'text', 'recommend' => 'text', 'articles__shops_id' => 'biginteger', 'articles.shops_id' => 'biginteger', 'shops_id' => 'biginteger', 'articles__staffs_id' => 'biginteger', 'articles.staffs_id' => 'biginteger', 'staffs_id' => 'biginteger', 'articles__postcode' => 'string', 'articles.postcode' => 'string', 'postcode' => 'string', 'articles__address' => 'string', 'articles.address' => 'string', 'address' => 'string', 'articles__address_etc' => 'text', 'articles.address_etc' => 'text', 'address_etc' => 'text', 'articles__routes_id_1' => 'biginteger', 'articles.routes_id_1' => 'biginteger', 'routes_id_1' => 'biginteger', 'articles__stations_id_1' => 'biginteger', 'articles.stations_id_1' => 'biginteger', 'stations_id_1' => 'biginteger', 'articles__station_walk_1' => 'integer', 'articles.station_walk_1' => 'integer', 'station_walk_1' => 'integer', 'articles__bus_time_1' => 'integer', 'articles.bus_time_1' => 'integer', 'bus_time_1' => 'integer', 'articles__bus_stop_1' => 'string', 'articles.bus_stop_1' => 'string', 'bus_stop_1' => 'string', 'articles__bus_stop_walk_1' => 'integer', 'articles.bus_stop_walk_1' => 'integer', 'bus_stop_walk_1' => 'integer', 'articles__schools_id_1' => 'biginteger', 'articles.schools_id_1' => 'biginteger', 'schools_id_1' => 'biginteger', 'articles__schools_distance_1' => 'integer', 'articles.schools_distance_1' => 'integer', 'schools_distance_1' => 'integer', 'articles__routes_id_2' => 'biginteger', 'articles.routes_id_2' => 'biginteger', 'routes_id_2' => 'biginteger', 'articles__stations_id_2' => 'biginteger', 'articles.stations_id_2' => 'biginteger', 'stations_id_2' => 'biginteger', 'articles__station_walk_2' => 'integer', 'articles.station_walk_2' => 'integer', 'station_walk_2' => 'integer', 'articles__bus_time_2' => 'integer', 'articles.bus_time_2' => 'integer', 'bus_time_2' => 'integer', 'articles__bus_stop_2' => 'string', 'articles.bus_stop_2' => 'string', 'bus_stop_2' => 'string', 'articles__bus_stop_walk_2' => 'integer', 'articles.bus_stop_walk_2' => 'integer', 'bus_stop_walk_2' => 'integer', 'articles__schools_id_2' => 'biginteger', 'articles.schools_id_2' => 'biginteger', 'schools_id_2' => 'biginteger', 'articles__schools_distance_2' => 'integer', 'articles.schools_distance_2' => 'integer', 'schools_distance_2' => 'integer', 'articles__routes_id_3' => 'biginteger', 'articles.routes_id_3' => 'biginteger', 'routes_id_3' => 'biginteger', 'articles__stations_id_3' => 'biginteger', 'articles.stations_id_3' => 'biginteger', 'stations_id_3' => 'biginteger', 'articles__station_walk_3' => 'integer', 'articles.station_walk_3' => 'integer', 'station_walk_3' => 'integer', 'articles__bus_time_3' => 'integer', 'articles.bus_time_3' => 'integer', 'bus_time_3' => 'integer', 'articles__bus_stop_3' => 'string', 'articles.bus_stop_3' => 'string', 'bus_stop_3' => 'string', 'articles__bus_stop_walk_3' => 'integer', 'articles.bus_stop_walk_3' => 'integer', 'bus_stop_walk_3' => 'integer', 'articles__schools_id_3' => 'biginteger', 'articles.schools_id_3' => 'biginteger', 'schools_id_3' => 'biginteger', 'articles__schools_distance_3' => 'integer', 'articles.schools_distance_3' => 'integer', 'schools_distance_3' => 'integer', 'articles__routes_id_4' => 'biginteger', 'articles.routes_id_4' => 'biginteger', 'routes_id_4' => 'biginteger', 'articles__stations_id_4' => 'biginteger', 'articles.stations_id_4' => 'biginteger', 'stations_id_4' => 'biginteger', 'articles__station_walk_4' => 'integer', 'articles.station_walk_4' => 'integer', 'station_walk_4' => 'integer', 'articles__bus_time_4' => 'integer', 'articles.bus_time_4' => 'integer', 'bus_time_4' => 'integer', 'articles__bus_stop_4' => 'string', 'articles.bus_stop_4' => 'string', 'bus_stop_4' => 'string', 'articles__bus_stop_walk_4' => 'integer', 'articles.bus_stop_walk_4' => 'integer', 'bus_stop_walk_4' => 'integer', 'articles__schools_id_4' => 'biginteger', 'articles.schools_id_4' => 'biginteger', 'schools_id_4' => 'biginteger', 'articles__schools_distance_4' => 'integer', 'articles.schools_distance_4' => 'integer', 'schools_distance_4' => 'integer', 'articles__routes_id_5' => 'biginteger', 'articles.routes_id_5' => 'biginteger', 'routes_id_5' => 'biginteger', 'articles__stations_id_5' => 'biginteger', 'articles.stations_id_5' => 'biginteger', 'stations_id_5' => 'biginteger', 'articles__station_walk_5' => 'integer', 'articles.station_walk_5' => 'integer', 'station_walk_5' => 'integer', 'articles__bus_time_5' => 'integer', 'articles.bus_time_5' => 'integer', 'bus_time_5' => 'integer', 'articles__bus_stop_5' => 'string', 'articles.bus_stop_5' => 'string', 'bus_stop_5' => 'string', 'articles__bus_stop_walk_5' => 'integer', 'articles.bus_stop_walk_5' => 'integer', 'bus_stop_walk_5' => 'integer', 'articles__schools_id_5' => 'biginteger', 'articles.schools_id_5' => 'biginteger', 'schools_id_5' => 'biginteger', 'articles__schools_distance_5' => 'integer', 'articles.schools_distance_5' => 'integer', 'schools_distance_5' => 'integer', 'articles__type' => 'integer', 'articles.type' => 'integer', 'type' => 'integer', 'articles__structures_id' => 'biginteger', 'articles.structures_id' => 'biginteger', 'structures_id' => 'biginteger', 'articles__parking' => 'integer', 'articles.parking' => 'integer', 'parking' => 'integer', 'articles__rooms' => 'integer', 'articles.rooms' => 'integer', 'rooms' => 'integer', 'articles__floor' => 'integer', 'articles.floor' => 'integer', 'floor' => 'integer', 'articles__floor_under' => 'integer', 'articles.floor_under' => 'integer', 'floor_under' => 'integer', 'articles__year' => 'integer', 'articles.year' => 'integer', 'year' => 'integer', 'articles__month' => 'integer', 'articles.month' => 'integer', 'month' => 'integer', 'articles__information' => 'json', 'articles.information' => 'json', 'information' => 'json', 'articles__media' => 'json', 'articles.media' => 'json', 'media' => 'json', 'articles__remarks' => 'text', 'articles.remarks' => 'text', 'remarks' => 'text', 'articles__memo' => 'text', 'articles.memo' => 'text', 'memo' => 'text', 'articles__mcompanies_id' => 'biginteger', 'articles.mcompanies_id' => 'biginteger', 'mcompanies_id' => 'biginteger', 'articles__lat' => 'float', 'articles.lat' => 'float', 'lat' => 'float', 'articles__lng' => 'float', 'articles.lng' => 'float', 'lng' => 'float', 'articles__seo_keywords' => 'text', 'articles.seo_keywords' => 'text', 'seo_keywords' => 'text', 'articles__seo_description' => 'text', 'articles.seo_description' => 'text', 'seo_description' => 'text', 'articles__access' => 'biginteger', 'articles.access' => 'biginteger', 'access' => 'biginteger', 'articles__autoupdate_link' => 'string', 'articles.autoupdate_link' => 'string', 'autoupdate_link' => 'string', 'articles__autoupdate_flag' => 'integer', 'articles.autoupdate_flag' => 'integer', 'autoupdate_flag' => 'integer', 'articles__autoupdate_priority' => 'integer', 'articles.autoupdate_priority' => 'integer', 'autoupdate_priority' => 'integer', 'articles__admins_id' => 'biginteger', 'articles.admins_id' => 'biginteger', 'admins_id' => 'biginteger', 'articles____created' => 'datetime', 'articles.__created' => 'datetime', '__created' => 'datetime', 'articles____modified' => 'datetime', 'articles.__modified' => 'datetime', '__modified' => 'datetime', 'articles__created' => 'datetime', 'articles.created' => 'datetime', 'created' => 'datetime', 'articles__modified' => 'datetime', 'articles.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [ 'scope' => null, 'whitelist' => [ (int) 0 => 'limit', (int) 1 => 'sort', (int) 2 => 'page', (int) 3 => 'direction' ] ], 'repository' => object(App\Model\Table\ArticlesTable) { 'registryAlias' => 'Articles', 'table' => 'articles', 'alias' => 'articles', 'entityClass' => 'App\Model\Entity\Article', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } }
} |
|
/* @var callable $callable */ |
|
$callable = [$this, $request->getParam('action')]; |
|
|
|
return $callable(...array_values($request->getParam('pass'))); |
|
} |
|
|
|
/** |
|
* Merge components, helpers vars from |
'RTS11334' 'STN'
if ($result instanceof Response) { |
|
return $result; |
|
} |
|
|
|
$response = $controller->invokeAction(); |
|
if ($response !== null && !($response instanceof Response)) { |
|
throw new LogicException('Controller actions can only return Cake\Http\Response or null.'); |
|
} |
|
|
No arguments
} else { |
|
$controller = $this->factory->create($request, $response); |
|
} |
|
|
|
$response = $this->_invoke($controller); |
|
if (isset($request->params['return'])) { |
|
return $response; |
|
} |
|
|
object(App\Controller\SearchesController) { api => object(stdClass) { default => object(stdClass) {} google => object(stdClass) {} } name => 'Searches' helpers => [] request => object(Cake\Http\ServerRequest) { params => [ [maximum depth reached] ] data => [[maximum depth reached]] query => [[maximum depth reached]] cookies => [[maximum depth reached]] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ [maximum depth reached] ] [protected] _input => null [protected] _detectors => [ [maximum depth reached] ] [protected] _detectorCache => [ [maximum depth reached] ] [protected] stream => object(Zend\Diactoros\PhpInputStream) {} [protected] uri => object(Zend\Diactoros\Uri) {} [protected] session => object(Cake\Network\Session) {} [protected] attributes => [[maximum depth reached]] [protected] emulatedAttributes => [ [maximum depth reached] ] [protected] uploadedFiles => [[maximum depth reached]] [protected] protocol => null [protected] requestTarget => null } response => object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ [maximum depth reached] ], 'file' => null, 'fileRange' => [[maximum depth reached]], 'cookies' => [[maximum depth reached]], 'cacheDirectives' => [[maximum depth reached]], 'body' => '' } paginate => [ 'order' => [ 'created' => 'asc' ], 'page' => (int) 1, 'limit' => (int) 10, 'maxLimit' => (int) 200 ] autoRender => true components => [] View => null plugin => null passedArgs => [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ] modelClass => 'Searches' viewClass => null viewVars => [ 'condition' => [ 'NLK' => [[maximum depth reached]], 'CLS' => [[maximum depth reached]], 'FWD' => [[maximum depth reached]], 'CTY' => [[maximum depth reached]], 'TWN' => [[maximum depth reached]], 'STN' => null, 'SCH' => [[maximum depth reached]], 'SCT' => [[maximum depth reached]], 'SCD' => [[maximum depth reached]], 'TYP' => [[maximum depth reached]], 'MDR' => [[maximum depth reached]], 'ILC' => [[maximum depth reached]], 'KWR' => [[maximum depth reached]], 'AFE' => [[maximum depth reached]], 'RFA' => [[maximum depth reached]], 'RTL' => [[maximum depth reached]], 'RTB' => [[maximum depth reached]], 'RTT' => [[maximum depth reached]], 'STL' => [[maximum depth reached]], 'STB' => [[maximum depth reached]], 'STT' => [[maximum depth reached]], 'AAL' => [[maximum depth reached]], 'AAB' => [[maximum depth reached]], 'AAT' => [[maximum depth reached]], 'WLK' => [[maximum depth reached]], 'BLD' => [[maximum depth reached]], 'FLR' => [[maximum depth reached]], 'LTT' => [[maximum depth reached]], 'SHP' => [[maximum depth reached]], 'LLT' => [[maximum depth reached]], 'LLB' => [[maximum depth reached]], 'VCY' => [[maximum depth reached]] ], 'search' => [ 'routes' => [ [maximum depth reached] ], 'stations' => [ [maximum depth reached] ], 'type' => [ [maximum depth reached] ], 'rent' => [ [maximum depth reached] ], 'sell' => [ [maximum depth reached] ], 'initial' => [ [maximum depth reached] ], 'madoris' => [ [maximum depth reached] ], 'living' => [ [maximum depth reached] ], 'area' => [ [maximum depth reached] ], 'build' => [ [maximum depth reached] ], 'walk' => [ [maximum depth reached] ], 'floor' => [ [maximum depth reached] ], 'kodawari' => [ [maximum depth reached] ], 'latest' => [ [maximum depth reached] ] ], 'favorite' => null, 'shops' => object(Cake\ORM\Query) {}, 'api' => object(stdClass) {} ] RequestHandler => object(Cake\Controller\Component\RequestHandlerComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Flash => object(Cake\Controller\Component\FlashComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } Imgs => object(App\Model\Table\ImgsTable) { 'registryAlias' => 'Imgs', 'table' => 'imgs', 'alias' => 'imgs', 'entityClass' => 'App\Model\Entity\Img', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Routes => object(App\Model\Table\RoutesTable) { 'registryAlias' => 'Routes', 'table' => 'routes', 'alias' => 'routes', 'entityClass' => 'App\Model\Entity\Route', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Stations => object(App\Model\Table\StationsTable) { 'registryAlias' => 'Stations', 'table' => 'stations', 'alias' => 'stations', 'entityClass' => 'App\Model\Entity\Station', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Shops => object(App\Model\Table\ShopsTable) { 'registryAlias' => 'Shops', 'table' => 'shops', 'alias' => 'shops', 'entityClass' => 'App\Model\Entity\Shop', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Staffs => object(App\Model\Table\StaffsTable) { 'registryAlias' => 'Staffs', 'table' => 'staffs', 'alias' => 'staffs', 'entityClass' => 'App\Model\Entity\Staff', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } News => object(App\Model\Table\NewsTable) { 'registryAlias' => 'News', 'table' => 'news', 'alias' => 'news', 'entityClass' => 'App\Model\Entity\News', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Searches => object(App\Model\Table\SearchesTable) { 'registryAlias' => 'Searches', 'table' => 'searches', 'alias' => 'searches', 'entityClass' => '\Cake\ORM\Entity', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Paginator => object(Cake\Controller\Component\PaginatorComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } [protected] Articles => object(App\Model\Table\ArticlesTable) { 'registryAlias' => 'Articles', 'table' => 'articles', 'alias' => 'articles', 'entityClass' => 'App\Model\Entity\Article', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [protected] Rooms => object(App\Model\Table\RoomsTable) { 'registryAlias' => 'Rooms', 'table' => 'rooms', 'alias' => 'rooms', 'entityClass' => 'App\Model\Entity\Room', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [protected] Facilities => null [protected] common => object(stdClass) { base_title => '|ペット佳選' title => null company => 'NEXTRIBE株式会社' bread => object(stdClass) {} default => object(stdClass) {} mobile => object(stdClass) {} element => object(stdClass) {} meta => object(stdClass) {} } [protected] _responseClass => 'Cake\Http\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) { '_Controller' => object(App\Controller\SearchesController) {}, '_loaded' => [ [maximum depth reached] ], '_eventManager' => object(Cake\Event\EventManager) {}, '_eventClass' => '\Cake\Event\Event' } [protected] _validViewOptions => [ (int) 0 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) { '_listeners' => [ [maximum depth reached] ], '_isGlobal' => false, '_eventList' => null, '_trackEvents' => false, '_generalManager' => '(object) EventManager' } [protected] _eventClass => '\Cake\Event\Event' [protected] _tableLocator => object(Cake\ORM\Locator\TableLocator) { [protected] _config => [[maximum depth reached]] [protected] _instances => [ [maximum depth reached] ] [protected] _fallbacked => [[maximum depth reached]] [protected] _options => [ [maximum depth reached] ] } [protected] _modelFactories => [ 'Table' => [ (int) 0 => object(Cake\ORM\Locator\TableLocator) {}, (int) 1 => 'get' ] ] [protected] _modelType => 'Table' [protected] _viewBuilder => null [private] redirect => '/searches/district/' [private] link => false [private] counts => [] [private] area => (int) 0 }
* @return \Psr\Http\Message\ResponseInterface |
|
*/ |
|
public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next) |
|
{ |
|
return $this->getDispatcher()->dispatch($request, $response); |
|
} |
|
|
|
/** |
|
* Get the ActionDispatcher. |
object(Cake\Http\ServerRequest) { params => [ 'pass' => [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ], 'controller' => 'Searches', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/search/*', 'isAjax' => false ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'mobile' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'pass' => [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ], 'controller' => 'Searches', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/search/*', 'isAjax' => false ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'mobile' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 5 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
$response->getHeaders() |
|
); |
|
} |
|
|
|
return $next($request, $response); |
|
} |
|
} |
|
|
object(Cake\Http\ServerRequest) { params => [ 'pass' => [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ], 'controller' => 'Searches', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/search/*', 'isAjax' => false ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'mobile' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'pass' => [ (int) 0 => 'RTS11334', (int) 1 => 'STN' ], 'controller' => 'Searches', 'action' => 'index', 'plugin' => null, '_matchedRoute' => '/search/*', 'isAjax' => false ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_REFERER' => null, 'HTTP_IF_NONE_MATCH' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'mobile' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 5 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
public function __invoke($request, $response, $next) |
|
{ |
|
$url = $request->getUri()->getPath(); |
|
if (strpos($url, '..') !== false || strpos($url, '.') === false) { |
|
return $next($request, $response); |
|
} |
|
|
|
$assetFile = $this->_getAssetFile($url); |
|
if ($assetFile === null || !file_exists($assetFile)) { |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 5 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
*/ |
|
public function __invoke($request, $response, $next) |
|
{ |
|
try { |
|
return $next($request, $response); |
|
} catch (\Exception $e) { |
|
return $this->handleException($e, $request, $response); |
|
} |
|
} |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 5 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
public function __invoke($request, $response, $next) |
|
{ |
|
$this->service->loadPanels(); |
|
$this->service->initializePanels(); |
|
$response = $next($request, $response); |
|
$row = $this->service->saveData($request, $response); |
|
if (!$row) { |
|
return $response; |
|
} |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 5 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
{ |
|
$this->middleware = $middleware; |
|
$this->index = 0; |
|
|
|
return $this->__invoke($request, $response); |
|
} |
|
|
|
/** |
|
* @param \Psr\Http\Message\ServerRequestInterface $request The server request |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
throw new RuntimeException('The application `middleware` method did not return a middleware queue.'); |
|
} |
|
$this->dispatchEvent('Server.buildMiddleware', ['middleware' => $middleware]); |
|
$middleware->add($this->app); |
|
$response = $this->runner->run($middleware, $request, $response); |
|
|
|
if (!($response instanceof ResponseInterface)) { |
|
throw new RuntimeException(sprintf( |
|
'Application did not create a response. Got "%s" instead.', |
object(Cake\Http\MiddlewareQueue) { [protected] queue => [ (int) 0 => object(DebugKit\Middleware\DebugKitMiddleware) {}, (int) 1 => 'Cake\Error\Middleware\ErrorHandlerMiddleware', (int) 2 => 'Cake\Routing\Middleware\AssetMiddleware', (int) 3 => 'Cake\Routing\Middleware\RoutingMiddleware', (int) 4 => object(App\Application) {} ] [protected] callables => [ (int) 0 => object(DebugKit\Middleware\DebugKitMiddleware) {}, (int) 1 => object(Cake\Error\Middleware\ErrorHandlerMiddleware) {}, (int) 2 => object(Cake\Routing\Middleware\AssetMiddleware) {}, (int) 3 => object(Cake\Routing\Middleware\RoutingMiddleware) {}, (int) 4 => object(App\Application) {} ] } object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'search/RTS11334/STN/' base => '' webroot => '/' here => '/search/RTS11334/STN/' trustProxy => false [protected] _environment => [ 'USER' => 'nginx', 'HOME' => '/var/cache/nginx', 'HTTP_ACCEPT_ENCODING' => 'gzip', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'casamiatapas.com', 'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 21:14:59 UTC', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'REDIRECT_STATUS' => '200', 'SERVER_NAME' => 'casamiatapas.com', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '133.18.171.187', 'REMOTE_PORT' => '33802', 'REMOTE_ADDR' => '18.205.60.226', 'SERVER_SOFTWARE' => 'nginx/1.15.9', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTPS' => 'on', 'REQUEST_SCHEME' => 'https', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'DOCUMENT_ROOT' => '/usr/share/nginx/html/concierent.sate5/webroot', 'DOCUMENT_URI' => '/index.php', 'REQUEST_URI' => '/search/RTS11334/STN/', 'SCRIPT_NAME' => '/index.php', 'CONTENT_LENGTH' => '', 'CONTENT_TYPE' => '', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_FILENAME' => '/usr/share/nginx/html/concierent.sate5/webroot/index.php', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => (float) 1575697913.1406, 'REQUEST_TIME' => (int) 1575697913, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'casamiatapas.com' [private] port => null [private] path => '/search/RTS11334/STN/' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => null [protected] _lifetime => '1440' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => [], 'cacheDirectives' => [], 'body' => '' }
$server = new Server(new Application($cakephpRoot . '/config')); |
|
|
|
// Run the request/response through the application |
|
// and emit the response. |
|
$server->emit($server->run()); |
|
|
No arguments
If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.
SQL Query:
SELECT id AS `text`, articles.id AS `articles__id`, articles.class AS `articles__class`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, articles.title AS `articles__title`, articles.title_kana AS `articles__title_kana`, articles.title_hide AS `articles__title_hide`, articles.address AS `articles__address`, articles.address_etc AS `articles__address_etc`, articles.year AS `articles__year`, articles.month AS `articles__month`, articles.lat AS `articles__lat`, articles.lng AS `articles__lng`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route1`, (SELECT title FROM routes WHERE id = articles.routes_id_2 LIMIT 1) AS `route2`, (SELECT title FROM routes WHERE id = articles.routes_id_3 LIMIT 1) AS `route3`, (SELECT title FROM routes WHERE id = articles.routes_id_4 LIMIT 1) AS `route4`, (SELECT title FROM routes WHERE id = articles.routes_id_5 LIMIT 1) AS `route5`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station1`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_2 AND stations_id = articles.stations_id_2 LIMIT 1) AS `station2`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_3 AND stations_id = articles.stations_id_3 LIMIT 1) AS `station3`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_4 AND stations_id = articles.stations_id_4 LIMIT 1) AS `station4`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_5 AND stations_id = articles.stations_id_5 LIMIT 1) AS `station5`, articles.routes_id_1 AS `articles__routes_id_1`, articles.routes_id_2 AS `articles__routes_id_2`, articles.routes_id_3 AS `articles__routes_id_3`, articles.routes_id_4 AS `articles__routes_id_4`, articles.routes_id_5 AS `articles__routes_id_5`, articles.stations_id_1 AS `articles__stations_id_1`, articles.stations_id_2 AS `articles__stations_id_2`, articles.stations_id_3 AS `articles__stations_id_3`, articles.stations_id_4 AS `articles__stations_id_4`, articles.stations_id_5 AS `articles__stations_id_5`, articles.station_walk_1 AS `articles__station_walk_1`, articles.station_walk_2 AS `articles__station_walk_2`, articles.station_walk_3 AS `articles__station_walk_3`, articles.station_walk_4 AS `articles__station_walk_4`, articles.station_walk_5 AS `articles__station_walk_5`, articles.bus_time_1 AS `articles__bus_time_1`, articles.bus_time_2 AS `articles__bus_time_2`, articles.bus_time_3 AS `articles__bus_time_3`, articles.bus_time_4 AS `articles__bus_time_4`, articles.bus_time_5 AS `articles__bus_time_5`, articles.bus_stop_1 AS `articles__bus_stop_1`, articles.bus_stop_2 AS `articles__bus_stop_2`, articles.bus_stop_3 AS `articles__bus_stop_3`, articles.bus_stop_4 AS `articles__bus_stop_4`, articles.bus_stop_5 AS `articles__bus_stop_5`, articles.bus_stop_walk_1 AS `articles__bus_stop_walk_1`, articles.bus_stop_walk_2 AS `articles__bus_stop_walk_2`, articles.bus_stop_walk_3 AS `articles__bus_stop_walk_3`, articles.bus_stop_walk_4 AS `articles__bus_stop_walk_4`, articles.bus_stop_walk_5 AS `articles__bus_stop_walk_5`, articles.type AS `articles__type`, articles.floor AS `articles__floor`, articles.floor_under AS `articles__floor_under`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 900 DESC, class ASC LIMIT 1), 0) AS `imgs_id`, (SELECT explanation FROM rooms WHERE articles_id = articles.id ORDER BY id ASC LIMIT 1) AS `room_explanation`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance ASC LIMIT 1), 0) AS `maintenance_min`, COALESCE((SELECT maintenance FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY maintenance DESC LIMIT 1), 0) AS `maintenance_max`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common ASC LIMIT 1), 0) AS `common_min`, COALESCE((SELECT common FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY common DESC LIMIT 1), 0) AS `common_max`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit ASC LIMIT 1) AS `security_deposit_min`, (SELECT security_deposit FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY security_deposit DESC LIMIT 1) AS `security_deposit_max`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward ASC LIMIT 1) AS `reward_min`, (SELECT reward FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY reward DESC LIMIT 1) AS `reward_max`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, articles.structures_id AS `articles__structures_id`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `area_min`, (SELECT area FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `area_max`, (SELECT '新 築' FROM articles b WHERE b.id = articles.id AND CONCAT(b.year, LPAD(b.month, 2, '0')) >= 201812 limit 1) AS `icon1`, (SELECT 'ペット相談可' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 3 OR facilities_id = 23 OR facilities_id = 308) LIMIT 1) AS `icon2`, (SELECT '分 譲' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND (facilities_id = 5 OR facilities_id = 17 OR facilities_id = 320) LIMIT 1) AS `icon3`, (SELECT 'デザイナーズ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 20 LIMIT 1) AS `icon4`, (SELECT '防犯カメラ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 357 LIMIT 1) AS `icon5`, (SELECT '24時間セキュリティ' FROM facilities_trait WHERE flag = 2 AND trait_id = articles.id AND type = 1 AND facilities_id = 205 LIMIT 1) AS `icon6`, COALESCE((SELECT __created FROM rooms WHERE articles_id = articles.id ORDER BY __created DESC LIMIT 1), (SELECT created FROM rooms WHERE articles_id = articles.id ORDER BY created DESC LIMIT 1)) AS `created`, COALESCE((SELECT __modified FROM rooms WHERE articles_id = articles.id ORDER BY __modified DESC LIMIT 1), (SELECT modified FROM rooms WHERE articles_id = articles.id ORDER BY modified DESC LIMIT 1)) AS `modified`, (SELECT count(*) FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2) AS `vacancy` FROM articles articles WHERE (articles.flag = :c0 AND articles.class = :c1 AND EXISTS (SELECT rooms.articles_id AS `rooms__articles_id` FROM rooms rooms WHERE (rooms.flag = 2 AND EXISTS (SELECT id FROM articles WHERE id = rooms.articles_id AND flag = 2 LIMIT 1) AND rooms.status = :c0 AND rooms.articles_id IN (SELECT id FROM articles WHERE routes_id_1 = 11334 OR routes_id_2 = 11334 OR routes_id_3 = 11334 OR routes_id_4 = 11334 OR routes_id_5 = 11334) AND rooms.articles_id IN (SELECT id FROM articles WHERE stations_id_1 = OR stations_id_2 = OR stations_id_3 = OR stations_id_4 = OR stations_id_5 = ) AND articles.id = rooms.articles_id))) ORDER BY articles.created asc LIMIT 10 OFFSET 0
If you want to customize this error message, create src/Template/Error/pdo_error.ctp