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 => '6705b67b-d1ce-4b36-8e88-99dc804a9ba4' ] $name = 'X-DEBUGKIT-ID' $first = true $value = '6705b67b-d1ce-4b36-8e88-99dc804a9ba4'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')) >= 201810 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')) >= 201810 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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'ORIGINAL_REQUEST_METHOD' => 'GET',
'HTTP_X_REQUESTED_WITH' => null,
'HTTP_REFERER' => null,
'HTTP_IF_NONE_MATCH' => null,
'HTTP_IF_MODIFIED_SINCE' => 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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'ORIGINAL_REQUEST_METHOD' => 'GET',
'HTTP_X_REQUESTED_WITH' => null,
'HTTP_REFERER' => null,
'HTTP_IF_NONE_MATCH' => null,
'HTTP_IF_MODIFIED_SINCE' => 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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'ORIGINAL_REQUEST_METHOD' => 'GET',
'HTTP_X_REQUESTED_WITH' => null,
'HTTP_REFERER' => null,
'HTTP_IF_NONE_MATCH' => null,
'HTTP_IF_MODIFIED_SINCE' => 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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'ORIGINAL_REQUEST_METHOD' => 'GET',
'HTTP_X_REQUESTED_WITH' => null,
'HTTP_REFERER' => null,
'HTTP_IF_NONE_MATCH' => null,
'HTTP_IF_MODIFIED_SINCE' => 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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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_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' => '52238',
'REMOTE_ADDR' => '3.85.245.126',
'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) 1571173878.2047,
'REQUEST_TIME' => (int) 1571173878,
'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')) >= 201810 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