Array
(
[0] => QUERYALL
[1] => SELECT DISTINCT(sd.subdomain), sd.subdomain as word, d.domain,
sd.subdomain as subdomain, sd.icon as parentIcon
FROM domain d
LEFT JOIN subdomain sd ON sd.domain = d.domain
WHERE sd.subdomain = 'hoogle' AND d.domain = 'haskell.org' and sd.domain = 'haskell.org' AND (d.site_language LIKE '%en%' OR d.site_language = '*')
GROUP BY sd.subdomain, sd.domain
ORDER BY sd.subdomain ASC LIMIT 0, 1
[2] => Array
(
[0] => Array
(
[subdomain] => hoogle
[word] => hoogle
[domain] => haskell.org
[parentIcon] =>
)
)
)
Array
(
[0] => SQL
[1] => SELECT s.render as word, s.destination as dest, '0' as 'hasChild', i.link as icon,d.icon as parentIcon, s.icon as ownIcon, d.keyword, 'app' as fm, s.adult as mcoreAdult, d.keyword as parent_term, d.id as parentID, 'search' as 'src',
s.id as _cid , s.promote, s.promoteOrder , s.placeholder as hint, d.domain, d.site_language as lang,
s.supportSearch,s.cat1, s.esOrderNum, s.subdomain,s.bookSearch, s.replace_rule, s.supportSearchOrder
FROM domain d
LEFT JOIN search s ON s.d_id = d.id
LEFT JOIN iconography i ON i.id = s.icon
WHERE s.subdomain = 'hoogle' AND (s.promoteOrder > 0 OR s.promoteOrder IS NULL) AND d.domain = 'haskell.org' AND s.id = 3139 GROUP BY word ORDER BY s.promoteOrder, s.render ASC LIMIT 1000
)
Array
(
[0] => pppppppp
[1] => Array
(
[word] => hoogle search
[dest] => https://hoogle.haskell.org/?hoogle=%s
[hasChild] => 0
[icon] =>
[parentIcon] => haskell.org/haskell.org.png
[ownIcon] =>
[keyword] => haskell
[fm] => app
[mcoreAdult] => 0
[parent_term] => haskell
[parentID] => 10682
[src] => search
[_cid] => 3139
[promote] => 0
[promoteOrder] => 0
[hint] => results from haskell.org
[domain] => haskell.org
[lang] => en,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => hoogle
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 1
[responseID] => 1
[_otype] => 1_v1_1
[src_index] => web_subdomains
[assigned_to] => hoogle
[last_updated] => 2026-03-17 3:42:35
)
[2] =>
[3] =>
)
Array
(
[0] => importedIDES
[1] => '3139'
[2] => UPDATE search SET order_adjusted = 1, imported = 1
WHERE id IN ('3139')
[3] => Array
(
[0] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/models/CoreCeecQuery.php|2602|ic_debug_backtrace
[1] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/models/InsertSCV.php|1583|setAsImported
[2] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/models/InsertSCV.php|1199|get_search_items
[3] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/views/search/update.php|36|importSubdomainToES
[4] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/View.php|348|require
[5] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/View.php|257|renderPhpFile
[6] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/View.php|156|renderFile
[7] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/Controller.php|384|render
[8] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/controllers/SearchController.php|95|render
[9] => ||actionUpdate
[10] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/InlineAction.php|57|call_user_func_array
[11] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/Controller.php|157|runWithParams
[12] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/Module.php|528|runAction
[13] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/web/Application.php|103|runAction
[14] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/vendor/yiisoft/yii2/base/Application.php|386|handleRequest
[15] => /var/www/vhosts/ceec.com/apiv2.ceec.com/study/backend/web/index.php|17|run
)
)
Array
(
[0] => here_id
[1] => 1313931068243
)
Array
(
[0] => here
[1] => 1313931068243
[2] =>
[3] => Array
(
[word] => hoogle search
[dest] => https://hoogle.haskell.org/?hoogle=%s
[hasChild] => 0
[icon] =>
[parentIcon] => haskell.org/haskell.org.png
[ownIcon] =>
[keyword] => haskell
[fm] => app
[mcoreAdult] => 0
[parent_term] => haskell
[parentID] => 10682
[src] => search
[_cid] => 3139
[promote] => 0
[promoteOrder] => 0
[hint] => results from haskell.org
[domain] => haskell.org
[lang] => en,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => hoogle
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 1
[responseID] => 1
[_otype] => 1_v1_1
[src_index] => web_subdomains
[assigned_to] => hoogle
[last_updated] => 2026-03-17 3:42:35
[type] => search
[data_type] => subdomain
)
)
Array
(
[0] => row_id
[1] => 1313931068243
[2] => Array
(
[word] => hoogle search
[dest] => https://hoogle.haskell.org/?hoogle=%s
[hasChild] => 0
[icon] =>
[parentIcon] => haskell.org/haskell.org.png
[ownIcon] =>
[keyword] => haskell
[fm] => app
[mcoreAdult] => 0
[parent_term] => haskell
[parentID] => 10682
[src] => search
[_cid] => 3139
[promote] => 0
[promoteOrder] => 0
[hint] => results from haskell.org
[domain] => haskell.org
[lang] => en,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => hoogle
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 1
[responseID] => 1
[_otype] => 1_v1_1
[src_index] => web_subdomains
[assigned_to] => hoogle
[last_updated] => 2026-03-17 3:42:35
[type] => search
[data_type] => subdomain
)
)
Array
(
[0] => cleanup---
[1] => 1
[2] => Array
(
[index] => ceec_and_apps_and_words_v3
[size] => 100
[from] => 0
[body] => Array
(
[query] => Array
(
[bool] => Array
(
[must] => Array
(
[0] => Array
(
[match] => Array
(
[domain] => haskell.org
)
)
[1] => Array
(
[match] => Array
(
[_cid] => 3139
)
)
[2] => Array
(
[match] => Array
(
[parentID] => 10682
)
)
[3] => Array
(
[match] => Array
(
[type] => search
)
)
[4] => Array
(
[match] => Array
(
[data_type] => subdomain
)
)
[5] => Array
(
[match] => Array
(
[fm] => app
)
)
)
)
)
)
)
[3] => Array
(
[word] => hoogle search
[dest] => https://hoogle.haskell.org/?hoogle=%s
[hasChild] => 0
[icon] =>
[parentIcon] => haskell.org/haskell.org.png
[ownIcon] =>
[keyword] => haskell
[fm] => app
[mcoreAdult] => 0
[parent_term] => haskell
[parentID] => 10682
[src] => search
[_cid] => 3139
[promote] => 0
[promoteOrder] => 0
[hint] => results from haskell.org
[domain] => haskell.org
[lang] => en,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => hoogle
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 1
[responseID] => 1
[_otype] => 1_v1_1
[src_index] => web_subdomains
[assigned_to] => hoogle
[last_updated] => 2026-03-17 3:42:35
[type] => search
[data_type] => subdomain
)
[4] => Array
(
[took] => 1
[timed_out] =>
[_shards] => Array
(
[total] => 5
[successful] => 5
[skipped] => 0
[failed] => 0
)
[hits] => Array
(
[total] => Array
(
[value] => 1
[relation] => eq
)
[max_score] => 26.898462
[hits] => Array
(
[0] => Array
(
[_index] => ceec_and_apps_and_words_v3
[_id] => 1313931068243
[_score] => 26.898462
[_source] => Array
(
[word] => hoogle search
[dest] => https://hoogle.haskell.org/?hoogle=%s
[hasChild] => 0
[parentIcon] => haskell.org/haskell.org.png
[ownIcon] =>
[keyword] => haskell
[fm] => app
[mcoreAdult] => 0
[parent_term] => haskell
[parentID] => 10682
[src] => search
[_cid] => 3139
[promote] => 0
[promoteOrder] => 0
[hint] => results from haskell.org
[domain] => haskell.org
[lang] => en,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => hoogle
[soc_link] =>
[bookSearch] =>
[orderNum] => 1
[responseID] => 1
[import_v] => 1
[_otype] => 1_v1_1
[src_index] => web_subdomains
[assigned_to] => hoogle
[icon] =>
[type] => search
[data_type] => subdomain
[replace_rule] =>
[last_updated] => 2025-11-06 9:11:02
[supportSearchOrder] =>
)
)
)
)
)
)
Array
(
[0] => SQL
[1] => SELECT s.render as word, s.destination as dest, '0' as 'hasChild', i.link as icon,d.icon as parentIcon, s.icon as ownIcon, d.keyword, 'app' as fm, s.adult as mcoreAdult, d.keyword as parent_term, d.id as parentID, 'search' as 'src',
s.id as _cid , s.promote, s.promoteOrder , s.placeholder as hint, d.domain, d.site_language as lang,
s.supportSearch,s.cat1, s.esOrderNum, s.subdomain,s.bookSearch, s.replace_rule, s.supportSearchOrder
FROM domain d
LEFT JOIN search s ON s.d_id = d.id
LEFT JOIN iconography i ON i.id = s.icon
WHERE s.subdomain = 'hoogle' AND s.promoteOrder = 0 AND d.domain = 'haskell.org' AND s.id = 3139 GROUP BY word ORDER BY s.promoteOrder, s.render ASC LIMIT 1000
)
Array
(
[0] => $this->checkedItems
[1] => Array
(
[hoogle] => Array
(
)
)
[2] => hoogle
)