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 = 'candy' AND d.domain = 'candywarehouse.com' and sd.domain = 'candywarehouse.com' 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] => candy
[word] => candy
[domain] => candywarehouse.com
[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 = 'candy' AND (s.promoteOrder > 0 OR s.promoteOrder IS NULL) AND d.domain = 'candywarehouse.com' AND s.id = 255 GROUP BY word ORDER BY s.promoteOrder, s.render ASC LIMIT 1000
)
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 = 'candy' AND s.promoteOrder = 0 AND d.domain = 'candywarehouse.com' AND s.id = 255 GROUP BY word ORDER BY s.promoteOrder, s.render ASC LIMIT 1000
)
Array
(
[0] => pppppppp
[1] => Array
(
[word] => candywarehouse search
[dest] => https://candy.candywarehouse.com/search?w=%s
[hasChild] => 0
[icon] =>
[parentIcon] => candywarehouse.com/candywarehouse.com.png
[ownIcon] =>
[keyword] => candywarehouse
[fm] => app
[mcoreAdult] => 0
[parent_term] => candywarehouse
[parentID] => 75419
[src] => search
[_cid] => 255
[promote] => 0
[promoteOrder] => 0
[hint] => results from candywarehouse.com
[domain] => candywarehouse.com
[lang] => en-us,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => candy
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => candy
[last_updated] => 2026-03-12 8:13:07
)
[2] =>
[3] =>
)
Array
(
[0] => importedIDES
[1] => '255'
[2] => UPDATE search SET order_adjusted = 1, imported = 1
WHERE id IN ('255')
[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|1214|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] => 125537541943
)
Array
(
[0] => here
[1] => 125537541943
[2] =>
[3] => Array
(
[word] => candywarehouse search
[dest] => https://candy.candywarehouse.com/search?w=%s
[hasChild] => 0
[icon] =>
[parentIcon] => candywarehouse.com/candywarehouse.com.png
[ownIcon] =>
[keyword] => candywarehouse
[fm] => app
[mcoreAdult] => 0
[parent_term] => candywarehouse
[parentID] => 75419
[src] => search
[_cid] => 255
[promote] => 0
[promoteOrder] => 0
[hint] => results from candywarehouse.com
[domain] => candywarehouse.com
[lang] => en-us,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => candy
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => candy
[last_updated] => 2026-03-12 8:13:07
[type] => search
[data_type] => subdomain
)
)
Array
(
[0] => row_id
[1] => 125537541943
[2] => Array
(
[word] => candywarehouse search
[dest] => https://candy.candywarehouse.com/search?w=%s
[hasChild] => 0
[icon] =>
[parentIcon] => candywarehouse.com/candywarehouse.com.png
[ownIcon] =>
[keyword] => candywarehouse
[fm] => app
[mcoreAdult] => 0
[parent_term] => candywarehouse
[parentID] => 75419
[src] => search
[_cid] => 255
[promote] => 0
[promoteOrder] => 0
[hint] => results from candywarehouse.com
[domain] => candywarehouse.com
[lang] => en-us,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => candy
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => candy
[last_updated] => 2026-03-12 8:13:07
[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] => candywarehouse.com
)
)
[1] => Array
(
[match] => Array
(
[_cid] => 255
)
)
[2] => Array
(
[match] => Array
(
[parentID] => 75419
)
)
[3] => Array
(
[match] => Array
(
[type] => search
)
)
[4] => Array
(
[match] => Array
(
[data_type] => subdomain
)
)
[5] => Array
(
[match] => Array
(
[fm] => app
)
)
)
)
)
)
)
[3] => Array
(
[word] => candywarehouse search
[dest] => https://candy.candywarehouse.com/search?w=%s
[hasChild] => 0
[icon] =>
[parentIcon] => candywarehouse.com/candywarehouse.com.png
[ownIcon] =>
[keyword] => candywarehouse
[fm] => app
[mcoreAdult] => 0
[parent_term] => candywarehouse
[parentID] => 75419
[src] => search
[_cid] => 255
[promote] => 0
[promoteOrder] => 0
[hint] => results from candywarehouse.com
[domain] => candywarehouse.com
[lang] => en-us,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => candy
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => candy
[last_updated] => 2026-03-12 8:13:07
[type] => search
[data_type] => subdomain
)
[4] => Array
(
[took] => 2
[timed_out] =>
[_shards] => Array
(
[total] => 5
[successful] => 5
[skipped] => 0
[failed] => 0
)
[hits] => Array
(
[total] => Array
(
[value] => 1
[relation] => eq
)
[max_score] => 28.306616
[hits] => Array
(
[0] => Array
(
[_index] => ceec_and_apps_and_words_v3
[_id] => 125537541943
[_score] => 28.306616
[_source] => Array
(
[word] => candywarehouse search
[dest] => https://candy.candywarehouse.com/search?w=%s
[hasChild] => 0
[parentIcon] => candywarehouse.com/candywarehouse.com.png
[ownIcon] =>
[keyword] => candywarehouse
[fm] => app
[mcoreAdult] => 0
[parent_term] => candywarehouse
[parentID] => 75419
[src] => search
[_cid] => 255
[promote] => 0
[promoteOrder] => 0
[hint] => results from candywarehouse.com
[domain] => candywarehouse.com
[lang] => en-us,
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => candy
[soc_link] =>
[bookSearch] =>
[orderNum] => 2000
[responseID] => 1
[import_v] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => candy
[icon] =>
[type] => search
[data_type] => subdomain
[replace_rule] =>
[supportSearchOrder] =>
[last_updated] => 2025-12-08 6:02:32
)
)
)
)
)
)
Array
(
[0] => $this->checkedItems
[1] => Array
(
[candy] => Array
(
)
)
[2] => candy
)