object(Cake\ORM\Query\SelectQuery) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Bbtopics.topic_title AS Bbtopics__topic_title, Bbposts.post_subject AS Bbposts__post_subject, Bbposts.post_text AS Bbposts__post_text, Bbposts.topic_id AS Bbposts__topic_id, Bbposts.created AS Bbposts__created, Bbposts.post_username AS Bbposts__post_username, (((1.3 * (MATCH(post_text) AGAINST ('Kostuch' IN BOOLEAN MODE))) + (0.6 * (MATCH(Bbtopics.topic_title) AGAINST ('Kostuch' IN BOOLEAN MODE))))) AS relevance FROM bbposts Bbposts INNER JOIN bbtopics Bbtopics ON Bbtopics.topic_id = Bbposts.topic_id INNER JOIN bbforums Bbforums ON Bbforums.forum_id = Bbposts.forum_id GROUP BY Bbposts.topic_id ORDER BY ((1.3 * (MATCH(post_text) AGAINST ('Kostuch' IN BOOLEAN MODE))) + (0.6 * (MATCH(Bbtopics.topic_title) AGAINST ('Kostuch' IN BOOLEAN MODE)))) DESC, relevance DESC LIMIT 20 OFFSET 0'
'params' => [
]
'defaultTypes' => [
'Bbposts__post_id' => 'integer',
'Bbposts.post_id' => 'integer',
'post_id' => 'integer',
'Bbposts__topic_id' => 'integer',
'Bbposts.topic_id' => 'integer',
'topic_id' => 'integer',
'Bbposts__forum_id' => 'smallinteger',
'Bbposts.forum_id' => 'smallinteger',
'forum_id' => 'smallinteger',
'Bbposts__poster_id' => 'integer',
'Bbposts.poster_id' => 'integer',
'poster_id' => 'integer',
'Bbposts__poster_ip' => 'string',
'Bbposts.poster_ip' => 'string',
'poster_ip' => 'string',
'Bbposts__post_username' => 'string',
'Bbposts.post_username' => 'string',
'post_username' => 'string',
'Bbposts__enable_bbcode' => 'boolean',
'Bbposts.enable_bbcode' => 'boolean',
'enable_bbcode' => 'boolean',
'Bbposts__enable_html' => 'boolean',
'Bbposts.enable_html' => 'boolean',
'enable_html' => 'boolean',
'Bbposts__enable_smilies' => 'boolean',
'Bbposts.enable_smilies' => 'boolean',
'enable_smilies' => 'boolean',
'Bbposts__enable_sig' => 'boolean',
'Bbposts.enable_sig' => 'boolean',
'enable_sig' => 'boolean',
'Bbposts__post_edit_count' => 'smallinteger',
'Bbposts.post_edit_count' => 'smallinteger',
'post_edit_count' => 'smallinteger',
'Bbposts__modified' => 'datetime',
'Bbposts.modified' => 'datetime',
'modified' => 'datetime',
'Bbposts__created' => 'datetime',
'Bbposts.created' => 'datetime',
'created' => 'datetime',
'Bbposts__bbcode_uid' => 'string',
'Bbposts.bbcode_uid' => 'string',
'bbcode_uid' => 'string',
'Bbposts__post_subject' => 'string',
'Bbposts.post_subject' => 'string',
'post_subject' => 'string',
'Bbposts__post_text' => 'text',
'Bbposts.post_text' => 'text',
'post_text' => 'text',
'Bbtopics__topic_id' => 'integer',
'Bbtopics.topic_id' => 'integer',
'Bbtopics__forum_id' => 'smallinteger',
'Bbtopics.forum_id' => 'smallinteger',
'Bbtopics__topic_title' => 'string',
'Bbtopics.topic_title' => 'string',
'topic_title' => 'string',
'Bbtopics__topic_poster' => 'integer',
'Bbtopics.topic_poster' => 'integer',
'topic_poster' => 'integer',
'Bbtopics__topic_views' => 'integer',
'Bbtopics.topic_views' => 'integer',
'topic_views' => 'integer',
'Bbtopics__topic_replies' => 'integer',
'Bbtopics.topic_replies' => 'integer',
'topic_replies' => 'integer',
'Bbtopics__topic_status' => 'tinyinteger',
'Bbtopics.topic_status' => 'tinyinteger',
'topic_status' => 'tinyinteger',
'Bbtopics__topic_vote' => 'boolean',
'Bbtopics.topic_vote' => 'boolean',
'topic_vote' => 'boolean',
'Bbtopics__topic_type' => 'tinyinteger',
'Bbtopics.topic_type' => 'tinyinteger',
'topic_type' => 'tinyinteger',
'Bbtopics__topic_last_post_id' => 'integer',
'Bbtopics.topic_last_post_id' => 'integer',
'topic_last_post_id' => 'integer',
'Bbtopics__topic_first_post_id' => 'integer',
'Bbtopics.topic_first_post_id' => 'integer',
'topic_first_post_id' => 'integer',
'Bbtopics__topic_moved_id' => 'integer',
'Bbtopics.topic_moved_id' => 'integer',
'topic_moved_id' => 'integer',
'Bbtopics__sid' => 'integer',
'Bbtopics.sid' => 'integer',
'sid' => 'integer',
'Bbtopics__topic_last_poster_name' => 'string',
'Bbtopics.topic_last_poster_name' => 'string',
'topic_last_poster_name' => 'string',
'Bbtopics__created' => 'datetime',
'Bbtopics.created' => 'datetime',
'Bbtopics__modified' => 'datetime',
'Bbtopics.modified' => 'datetime',
'Bbtopics__sid_type' => 'string',
'Bbtopics.sid_type' => 'string',
'sid_type' => 'string',
'Bbforums__forum_id' => 'smallinteger',
'Bbforums.forum_id' => 'smallinteger',
'Bbforums__category' => 'string',
'Bbforums.category' => 'string',
'category' => 'string',
'Bbforums__forum_name' => 'string',
'Bbforums.forum_name' => 'string',
'forum_name' => 'string',
'Bbforums__forum_desc' => 'text',
'Bbforums.forum_desc' => 'text',
'forum_desc' => 'text',
'Bbforums__forum_status' => 'tinyinteger',
'Bbforums.forum_status' => 'tinyinteger',
'forum_status' => 'tinyinteger',
'Bbforums__forum_order' => 'integer',
'Bbforums.forum_order' => 'integer',
'forum_order' => 'integer',
'Bbforums__forum_posts' => 'integer',
'Bbforums.forum_posts' => 'integer',
'forum_posts' => 'integer',
'Bbforums__forum_topics' => 'integer',
'Bbforums.forum_topics' => 'integer',
'forum_topics' => 'integer',
'Bbforums__forum_last_post_id' => 'integer',
'Bbforums.forum_last_post_id' => 'integer',
'forum_last_post_id' => 'integer',
'Bbforums__auth_view' => 'tinyinteger',
'Bbforums.auth_view' => 'tinyinteger',
'auth_view' => 'tinyinteger',
'Bbforums__auth_read' => 'tinyinteger',
'Bbforums.auth_read' => 'tinyinteger',
'auth_read' => 'tinyinteger',
'Bbforums__parent' => 'integer',
'Bbforums.parent' => 'integer',
'parent' => 'integer',
'Bbforums__forum_last_poster_name' => 'string',
'Bbforums.forum_last_poster_name' => 'string',
'forum_last_poster_name' => 'string',
'Bbforums__forum_last_post_date' => 'datetime',
'Bbforums.forum_last_post_date' => 'datetime',
'forum_last_post_date' => 'datetime',
]
'decorators' => (int) 0
'executed' => false
'hydrate' => true
'buffered' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'Bbtopics' => [
],
'Bbforums' => [
],
]
'matching' => [
]
'extraOptions' => [
'request' => object(Cake\Http\ServerRequest) id:1 {
trustProxy => false
protected params => [
'' => [maximum depth reached],
]
protected data => [
'' => [maximum depth reached],
]
protected query => [
'' => [maximum depth reached],
]
protected cookies => [
'' => [maximum depth reached],
]
protected _environment => [
'' => [maximum depth reached],
]
protected base => ''
protected webroot => '/'
protected trustedProxies => [
'' => [maximum depth reached],
]
protected _detectors => [
'' => [maximum depth reached],
]
protected _detectorCache => [
'' => [maximum depth reached],
]
protected stream => object(Laminas\Diactoros\PhpInputStream) id:2 {
}
protected uri => object(Cake\Http\Uri) id:3 {
}
protected session => object(Cake\Http\Session) id:4 {
}
protected flash => object(Cake\Http\FlashMessage) id:5 {
}
protected attributes => [
'' => [maximum depth reached],
]
protected emulatedAttributes => [
'' => [maximum depth reached],
]
protected uploadedFiles => [
'' => [maximum depth reached],
]
protected protocol => null
protected requestTarget => null
},
]
'repository' => object(App\Model\Table\BbpostsTable) id:6 {
'registryAlias' => 'Bbposts'
'table' => 'bbposts'
'alias' => 'Bbposts'
'entityClass' => 'App\Model\Entity\Bbpost'
'associations' => [
(int) 0 => 'Bbtopics',
(int) 1 => 'Bbforums',
(int) 2 => 'Users',
(int) 3 => 'Bbmoderators',
]
'behaviors' => [
(int) 0 => 'Timestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}
[
'request' => object(Cake\Http\ServerRequest) id:0 {
trustProxy => false
protected params => [
'action' => 'search',
'pass' => [
'' => [maximum depth reached],
],
'controller' => 'Bbforums',
'plugin' => null,
'_matchedRoute' => '/forum/:action/*',
'?' => [
'' => [maximum depth reached],
],
'_ext' => null,
]
protected data => [
]
protected query => [
'q' => 'Kostuch',
'model' => '/forum/search',
]
protected cookies => [
'darkplanet' => 'p4hefc3qti709tvh802aekha7h',
]
protected _environment => [
'REDIRECT_HTTPS' => 'on',
'REDIRECT_SSL_TLS_SNI' => 'www.darkplanet.pl',
'REDIRECT_STATUS' => '200',
'HTTPS' => 'on',
'SSL_TLS_SNI' => 'www.darkplanet.pl',
'HTTP_ACCEPT' => '*/*',
'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
'HTTP_REFERER' => 'https://www.darkplanet.pl/users/profile/Kostuch',
'HTTP_COOKIE' => 'darkplanet=p4hefc3qti709tvh802aekha7h',
'HTTP_HOST' => 'www.darkplanet.pl',
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin',
'SERVER_SIGNATURE' => '<address>Apache/2.4.58 (Ubuntu) Server at www.darkplanet.pl Port 443</address>
',
'SERVER_SOFTWARE' => 'Apache/2.4.58 (Ubuntu)',
'SERVER_NAME' => 'www.darkplanet.pl',
'SERVER_ADDR' => '142.4.215.81',
'SERVER_PORT' => '443',
'REMOTE_ADDR' => '216.73.216.11',
'DOCUMENT_ROOT' => '/var/www/darkplanet/webroot',
'REQUEST_SCHEME' => 'https',
'CONTEXT_PREFIX' => '',
'CONTEXT_DOCUMENT_ROOT' => '/var/www/darkplanet/webroot',
'SERVER_ADMIN' => '[no address given]',
'SCRIPT_FILENAME' => '/var/www/darkplanet/webroot/index.php',
'REMOTE_PORT' => '28090',
'REDIRECT_URL' => '/forum/search',
'REDIRECT_QUERY_STRING' => 'q=Kostuch&model=%2Fforum%2Fsearch',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => 'q=Kostuch&model=%2Fforum%2Fsearch',
'REQUEST_URI' => '/forum/search?q=Kostuch&model=%2Fforum%2Fsearch',
'SCRIPT_NAME' => '/index.php',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => (float) 1763077013.762,
'REQUEST_TIME' => (int) 1763077013,
'ORIGINAL_REQUEST_METHOD' => 'GET',
'HTTP_X_REQUESTED_WITH' => null,
]
protected base => ''
protected webroot => '/'
protected trustedProxies => [
]
protected _detectors => [
'get' => [
'' => [maximum depth reached],
],
'post' => [
'' => [maximum depth reached],
],
'put' => [
'' => [maximum depth reached],
],
'patch' => [
'' => [maximum depth reached],
],
'delete' => [
'' => [maximum depth reached],
],
'head' => [
'' => [maximum depth reached],
],
'options' => [
'' => [maximum depth reached],
],
'ssl' => [
'' => [maximum depth reached],
],
'https' => [
'' => [maximum depth reached],
],
'ajax' => [
'' => [maximum depth reached],
],
'json' => [
'' => [maximum depth reached],
],
'xml' => [
'' => [maximum depth reached],
],
'mobile' => object(Closure) id:1 {
},
'tablet' => object(Closure) id:2 {
},
]
protected _detectorCache => [
'ajax' => false,
]
protected stream => object(Laminas\Diactoros\PhpInputStream) id:3 {
}
protected uri => object(Cake\Http\Uri) id:4 {
}
protected session => object(Cake\Http\Session) id:5 {
}
protected flash => object(Cake\Http\FlashMessage) id:6 {
}
protected attributes => [
'route' => object(Cake\Routing\Route\DashedRoute) id:7 {
},
'isAjax' => false,
]
protected emulatedAttributes => [
(int) 0 => 'session',
(int) 1 => 'flash',
(int) 2 => 'webroot',
(int) 3 => 'base',
(int) 4 => 'params',
(int) 5 => 'here',
]
protected uploadedFiles => [
]
protected protocol => null
protected requestTarget => null
},
]