当サイトは、株式会社エクセレント(以下「当社」)が管理・運営しています。
以下の内容をご確認いただき、ご了解のうえご利用ください。
本サイトに掲載されているすべての著作物(文章・写真・画像・プログラム等)に関する著作権その他の権利は、当社または当社に使用を認めた権利者に帰属しますので、私的使用など法律によって認められる範囲を超えて、無断で使用(複製、改ざん、頒布などを含む。)することはできません。。
当社は、本サイトに掲載されている全ての情報を慎重に作成し管理しますが、その正確性、有用性、確実性、安全性その他いかなる保証もいたしません。万が一、当サイト上のコンテンツのご利用、もしくはご利用になれないことにより何らかの損害が発生した場合も、当社は、何ら責任を負うものではありません。
また、当サイト上のコンテンツやURLを予告なく変更もしくは削除することがあります。これらによって生じるいかなる損害についても、当社は、何ら責任を負うものではありません。
<div class="side_box"><div class="side_btn"><a href="/contacts/?articles_id=<?= $entity->id ?>">
$viewFile = '/usr/share/nginx/html/chemenviron.org/project/src/Template/Element/side.ctp'
$dataForView = [
'count' => object(stdClass) {
articles => (int) 6595
rooms => (int) 50016
},
'common' => object(stdClass) {
base_title => null
title => '個人情報保護方針 | 中央区の高級賃貸'
company => 'エクセレント'
meta => object(stdClass) {}
bread => object(stdClass) {}
default => object(stdClass) {}
mobile => object(stdClass) {}
element => object(stdClass) {}
},
'side' => [
'おすすめの物件' => object(Cake\ORM\ResultSet) {}
],
'room' => object(stdClass) {
number => [
[maximum depth reached]
]
layout => [
[maximum depth reached]
]
direction => [
[maximum depth reached]
]
type => [
[maximum depth reached]
]
},
'random' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flg = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flg = 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 flg = 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 flg = 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 flg = 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.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, articles.created AS `articles__created`, articles.modified AS `articles__modified` FROM articles articles WHERE (articles.flg = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flg = 2)) ORDER BY imgs_id = 0 ASC, RAND() LIMIT 15',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\ArticlesTable) {}
},
'api' => object(stdClass) {
default => object(stdClass) {}
google => object(stdClass) {}
}
]
$count = object(stdClass) {
articles => (int) 6595
rooms => (int) 50016
}
$common = object(stdClass) {
base_title => null
title => '個人情報保護方針 | 中央区の高級賃貸'
company => 'エクセレント'
meta => object(stdClass) {}
bread => object(stdClass) {}
default => object(stdClass) {}
mobile => object(stdClass) {}
element => object(stdClass) {}
}
$side = [
'おすすめの物件' => object(Cake\ORM\ResultSet) {
'items' => [
[maximum depth reached]
]
}
]
$room = object(stdClass) {
number => [
(int) 0 => '-',
(int) 1 => '1',
(int) 2 => '2',
(int) 3 => '3',
(int) 4 => '4',
(int) 5 => '5',
(int) 6 => '6',
(int) 7 => '7',
(int) 8 => '8',
(int) 9 => '9',
(int) 10 => '10'
]
layout => [
(int) 0 => '-',
(int) 10 => 'R',
(int) 20 => 'K',
(int) 25 => 'SK',
(int) 30 => 'DK',
(int) 35 => 'SDK',
(int) 40 => 'LK',
(int) 45 => 'SLK',
(int) 50 => 'LDK',
(int) 55 => 'SLDK'
]
direction => [
(int) 0 => '-',
(int) 1 => '南',
(int) 2 => '南東',
(int) 3 => '東',
(int) 4 => '北東',
(int) 5 => '北',
(int) 6 => '北西',
(int) 7 => '西',
(int) 8 => '南西'
]
type => [
(int) 0 => '-',
(int) 1 => '和室',
(int) 2 => '洋室',
(int) 3 => 'リビング',
(int) 4 => 'キッチン',
(int) 5 => 'ダイニング',
(int) 6 => 'ダイニングキッチン',
(int) 7 => 'リビングダイニング',
(int) 8 => 'リビングダイニングキッチン',
(int) 9 => 'サービスルーム',
(int) 10 => 'ロフト',
(int) 11 => 'その他'
]
}
$random = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flg = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flg = 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 flg = 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 flg = 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 flg = 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.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, articles.created AS `articles__created`, articles.modified AS `articles__modified` FROM articles articles WHERE (articles.flg = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flg = 2)) ORDER BY imgs_id = 0 ASC, RAND() LIMIT 15',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'articles__id' => 'biginteger',
'articles.id' => 'biginteger',
'id' => 'biginteger',
'articles__source_id' => 'biginteger',
'articles.source_id' => 'biginteger',
'source_id' => 'biginteger',
'articles__flg' => 'integer',
'articles.flg' => 'integer',
'flg' => '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__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__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__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__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__type' => 'integer',
'articles.type' => 'integer',
'type' => 'integer',
'articles__structures_id' => 'biginteger',
'articles.structures_id' => 'biginteger',
'structures_id' => 'biginteger',
'articles__parking' => 'text',
'articles.parking' => 'text',
'parking' => 'text',
'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__youtube' => 'string',
'articles.youtube' => 'string',
'youtube' => 'string',
'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__rooms_count' => 'integer',
'articles.rooms_count' => 'integer',
'rooms_count' => 'integer',
'articles__rooms_release_count' => 'integer',
'articles.rooms_release_count' => 'integer',
'rooms_release_count' => 'integer',
'articles__rooms_wanted_count' => 'integer',
'articles.rooms_wanted_count' => 'integer',
'rooms_wanted_count' => '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'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ArticlesTable) {}
}
$api = object(stdClass) {
default => object(stdClass) {}
google => object(stdClass) {}
}include - APP/Template/Element/side.ctp, line 5 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1011 Cake\View\View::_render() - CORE/src/View/View.php, line 972 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1358 Cake\View\View::element() - CORE/src/View/View.php, line 499 include - APP/Template/Layout/default.ctp, line 64 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1011 Cake\View\View::_render() - CORE/src/View/View.php, line 972 Cake\View\View::renderLayout() - CORE/src/View/View.php, line 643 Cake\View\View::render() - CORE/src/View/View.php, line 601 App\View\AppView::render() - APP/View/AppView.php, line 74 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 623 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 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
Notice (8): Trying to get property of non-object [APP/Template/Element/side.ctp, line 5]">Code Context<div class="side_box"><div class="side_btn"><a href="/contacts/?articles_id=<?= $entity->id ?>">$viewFile = '/usr/share/nginx/html/chemenviron.org/project/src/Template/Element/side.ctp' $dataForView = [ 'count' => object(stdClass) { articles => (int) 6595 rooms => (int) 50016 }, 'common' => object(stdClass) { base_title => null title => '個人情報保護方針 | 中央区の高級賃貸' company => 'エクセレント' meta => object(stdClass) {} bread => object(stdClass) {} default => object(stdClass) {} mobile => object(stdClass) {} element => object(stdClass) {} }, 'side' => [ 'おすすめの物件' => object(Cake\ORM\ResultSet) {} ], 'room' => object(stdClass) { number => [ [maximum depth reached] ] layout => [ [maximum depth reached] ] direction => [ [maximum depth reached] ] type => [ [maximum depth reached] ] }, 'random' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flg = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flg = 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 flg = 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 flg = 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 flg = 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.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, articles.created AS `articles__created`, articles.modified AS `articles__modified` FROM articles articles WHERE (articles.flg = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flg = 2)) ORDER BY imgs_id = 0 ASC, RAND() LIMIT 15', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [[maximum depth reached]], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\ArticlesTable) {} }, 'api' => object(stdClass) { default => object(stdClass) {} google => object(stdClass) {} } ] $count = object(stdClass) { articles => (int) 6595 rooms => (int) 50016 } $common = object(stdClass) { base_title => null title => '個人情報保護方針 | 中央区の高級賃貸' company => 'エクセレント' meta => object(stdClass) {} bread => object(stdClass) {} default => object(stdClass) {} mobile => object(stdClass) {} element => object(stdClass) {} } $side = [ 'おすすめの物件' => object(Cake\ORM\ResultSet) { 'items' => [ [maximum depth reached] ] } ] $room = object(stdClass) { number => [ (int) 0 => '-', (int) 1 => '1', (int) 2 => '2', (int) 3 => '3', (int) 4 => '4', (int) 5 => '5', (int) 6 => '6', (int) 7 => '7', (int) 8 => '8', (int) 9 => '9', (int) 10 => '10' ] layout => [ (int) 0 => '-', (int) 10 => 'R', (int) 20 => 'K', (int) 25 => 'SK', (int) 30 => 'DK', (int) 35 => 'SDK', (int) 40 => 'LK', (int) 45 => 'SLK', (int) 50 => 'LDK', (int) 55 => 'SLDK' ] direction => [ (int) 0 => '-', (int) 1 => '南', (int) 2 => '南東', (int) 3 => '東', (int) 4 => '北東', (int) 5 => '北', (int) 6 => '北西', (int) 7 => '西', (int) 8 => '南西' ] type => [ (int) 0 => '-', (int) 1 => '和室', (int) 2 => '洋室', (int) 3 => 'リビング', (int) 4 => 'キッチン', (int) 5 => 'ダイニング', (int) 6 => 'ダイニングキッチン', (int) 7 => 'リビングダイニング', (int) 8 => 'リビングダイニングキッチン', (int) 9 => 'サービスルーム', (int) 10 => 'ロフト', (int) 11 => 'その他' ] } $random = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flg = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND stations_id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flg = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flg = 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 flg = 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 flg = 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 flg = 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.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND trait_id = articles.id ORDER BY class = 1 DESC, id ASC LIMIT 1 OFFSET 2), 0) AS `imgs_id`, articles.created AS `articles__created`, articles.modified AS `articles__modified` FROM articles articles WHERE (articles.flg = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flg = 2)) ORDER BY imgs_id = 0 ASC, RAND() LIMIT 15', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'articles__id' => 'biginteger', 'articles.id' => 'biginteger', 'id' => 'biginteger', 'articles__source_id' => 'biginteger', 'articles.source_id' => 'biginteger', 'source_id' => 'biginteger', 'articles__flg' => 'integer', 'articles.flg' => 'integer', 'flg' => '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__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__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__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__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__type' => 'integer', 'articles.type' => 'integer', 'type' => 'integer', 'articles__structures_id' => 'biginteger', 'articles.structures_id' => 'biginteger', 'structures_id' => 'biginteger', 'articles__parking' => 'text', 'articles.parking' => 'text', 'parking' => 'text', '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__youtube' => 'string', 'articles.youtube' => 'string', 'youtube' => 'string', '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__rooms_count' => 'integer', 'articles.rooms_count' => 'integer', 'rooms_count' => 'integer', 'articles__rooms_release_count' => 'integer', 'articles.rooms_release_count' => 'integer', 'rooms_release_count' => 'integer', 'articles__rooms_wanted_count' => 'integer', 'articles.rooms_wanted_count' => 'integer', 'rooms_wanted_count' => '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' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\ArticlesTable) {} } $api = object(stdClass) { default => object(stdClass) {} google => object(stdClass) {} }include - APP/Template/Element/side.ctp, line 5 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1011 Cake\View\View::_render() - CORE/src/View/View.php, line 972 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1358 Cake\View\View::element() - CORE/src/View/View.php, line 499 include - APP/Template/Layout/default.ctp, line 64 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1011 Cake\View\View::_render() - CORE/src/View/View.php, line 972 Cake\View\View::renderLayout() - CORE/src/View/View.php, line 643 Cake\View\View::render() - CORE/src/View/View.php, line 601 App\View\AppView::render() - APP/View/AppView.php, line 74 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 623 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 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