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 = 'mccallpattern' AND d.domain = 'mccall.com' and sd.domain = 'mccall.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] => mccallpattern
[word] => mccallpattern
[domain] => mccall.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 = 'mccallpattern' AND (s.promoteOrder > 0 OR s.promoteOrder IS NULL) AND d.domain = 'mccall.com' AND s.id = 971 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 = 'mccallpattern' AND s.promoteOrder = 0 AND d.domain = 'mccall.com' AND s.id = 971 GROUP BY word ORDER BY s.promoteOrder, s.render ASC LIMIT 1000
)
Array
(
[0] => pppppppp
[1] => Array
(
[word] => mccall patterns search
[dest] => https://mccallpattern.mccall.com/product-search?ref=%s
[hasChild] => 0
[icon] =>
[parentIcon] => mccall.com.png
[ownIcon] =>
[keyword] => the mccall pattern company
[fm] => app
[mcoreAdult] => 0
[parent_term] => the mccall pattern company
[parentID] => 2068531
[src] => search
[_cid] => 971
[promote] => 0
[promoteOrder] => 0
[hint] => results from mccallpattern.mccall.com
[domain] => mccall.com
[lang] => *
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => mccallpattern
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => mccallpattern
[last_updated] => 2026-03-13 3:16:48
)
[2] =>
[3] =>
)
Array
(
[0] => importedIDES
[1] => '971'
[2] => UPDATE search SET order_adjusted = 1, imported = 1
WHERE id IN ('971')
[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] => 19713206853143
)
Array
(
[0] => here
[1] => 19713206853143
[2] =>
[3] => Array
(
[word] => mccall patterns search
[dest] => https://mccallpattern.mccall.com/product-search?ref=%s
[hasChild] => 0
[icon] =>
[parentIcon] => mccall.com.png
[ownIcon] =>
[keyword] => the mccall pattern company
[fm] => app
[mcoreAdult] => 0
[parent_term] => the mccall pattern company
[parentID] => 2068531
[src] => search
[_cid] => 971
[promote] => 0
[promoteOrder] => 0
[hint] => results from mccallpattern.mccall.com
[domain] => mccall.com
[lang] => *
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => mccallpattern
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => mccallpattern
[last_updated] => 2026-03-13 3:16:48
[type] => search
[data_type] => subdomain
)
)
Array
(
[0] => row_id
[1] => 19713206853143
[2] => Array
(
[word] => mccall patterns search
[dest] => https://mccallpattern.mccall.com/product-search?ref=%s
[hasChild] => 0
[icon] =>
[parentIcon] => mccall.com.png
[ownIcon] =>
[keyword] => the mccall pattern company
[fm] => app
[mcoreAdult] => 0
[parent_term] => the mccall pattern company
[parentID] => 2068531
[src] => search
[_cid] => 971
[promote] => 0
[promoteOrder] => 0
[hint] => results from mccallpattern.mccall.com
[domain] => mccall.com
[lang] => *
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => mccallpattern
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => mccallpattern
[last_updated] => 2026-03-13 3:16:48
[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] => mccall.com
)
)
[1] => Array
(
[match] => Array
(
[_cid] => 971
)
)
[2] => Array
(
[match] => Array
(
[parentID] => 2068531
)
)
[3] => Array
(
[match] => Array
(
[type] => search
)
)
[4] => Array
(
[match] => Array
(
[data_type] => subdomain
)
)
[5] => Array
(
[match] => Array
(
[fm] => app
)
)
)
)
)
)
)
[3] => Array
(
[word] => mccall patterns search
[dest] => https://mccallpattern.mccall.com/product-search?ref=%s
[hasChild] => 0
[icon] =>
[parentIcon] => mccall.com.png
[ownIcon] =>
[keyword] => the mccall pattern company
[fm] => app
[mcoreAdult] => 0
[parent_term] => the mccall pattern company
[parentID] => 2068531
[src] => search
[_cid] => 971
[promote] => 0
[promoteOrder] => 0
[hint] => results from mccallpattern.mccall.com
[domain] => mccall.com
[lang] => *
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => mccallpattern
[bookSearch] =>
[replace_rule] =>
[supportSearchOrder] =>
[orderNum] => 2000
[responseID] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => mccallpattern
[last_updated] => 2026-03-13 3:16:48
[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] => 27.282896
[hits] => Array
(
[0] => Array
(
[_index] => ceec_and_apps_and_words_v3
[_id] => 19713206853143
[_score] => 27.282896
[_source] => Array
(
[word] => mccall patterns search
[dest] => https://mccallpattern.mccall.com/product-search?ref=%s
[hasChild] => 0
[parentIcon] => mccall.com.png
[ownIcon] =>
[keyword] => the mccall pattern company
[fm] => app
[mcoreAdult] => 0
[parent_term] => the mccall pattern company
[parentID] => 2068531
[src] => search
[_cid] => 971
[promote] => 0
[promoteOrder] => 0
[hint] => results from mccallpattern.mccall.com
[domain] => mccall.com
[lang] => *
[supportSearch] => 0
[cat1] =>
[esOrderNum] =>
[subdomain] => mccallpattern
[soc_link] =>
[bookSearch] =>
[orderNum] => 2000
[responseID] => 1
[import_v] => 1
[_otype] => 3_v1_2000
[src_index] => web_subdomains
[assigned_to] => mccallpattern
[icon] =>
[type] => search
[data_type] => subdomain
[replace_rule] =>
[supportSearchOrder] =>
[last_updated] => 2025-12-08 6:01:29
)
)
)
)
)
)
Array
(
[0] => $this->checkedItems
[1] => Array
(
[mccallpattern] => Array
(
)
)
[2] => mccallpattern
)