General
| Name |
Open Connections |
Max Connections |
| shopdoterra_PRF1 |
1 |
INF |
| shopdoterra-voprf1 |
1 |
INF |
| doterra-voprf1 |
1 |
INF |
| _queryofquerydb |
1 |
100 |
SQL Queries
| |
Name |
Records |
Time |
Usage |
Datasource |
Source |
Line |
Cached |
|
|
Variables.GetCompanyInformation
|
1 |
0 ms |
84% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/sharedconfig/cfg_CompanyQueries.cfm |
16 |
Yes |
SQL
SELECT COMPANY_ID, COMPANY_NAME, CUST_SUPPORT_PHONE, CUST_SUPPORT_EMAIL, SITE_TITLE,
CUST_SUPPORT_HOURS, DEFAULT_LANGUAGE_CD, MAIN_MENU_LINK, MENU_LIST, DEFAULT_PHOTO_URL, ROOT_PATH,
HEADER_PHOTO_URL, LOGIN_PHOTO_URL, TELEVOX_NAME, CHANGE_PASS_DAYS, PASS_LEN_MIN, ACCOUNT_MANAGER_EMAIL, VERITY_SEARCH, PERFORMANCE_THROTTLE
FROM COMPANIES
WHERE COMPANY_ID=461
Query column usage
the following columns are NOT used:
COMPANY_ID
ROOT_PATH
PASS_LEN_MIN
|
|
|
Variables.CorporateBusinessSite
|
0 |
0 ms |
100% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/sharedconfig/cfg_CompanyQueries.cfm |
185 |
Yes |
SQL
select Website_Alias
from USERS
where EXTERNAL_ID = '3'
and COMPANY_ID = 461
Query column usage
All columns are used
|
|
|
getServerTime
|
0 |
3.48 ms |
100% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/sharedconfig/cfg_CompanyQueries.cfm |
198 |
No |
SQL
SELECT TIMEZONE_ID, END_LOCAL_DATETIME FROM TIMEZONE_DATES
WHERE GMT_OFFSET = -7
AND START_LOCAL_DATETIME < {ts '2026-01-01 12:20:23'}
AND END_LOCAL_DATETIME >= {ts '2026-01-01 12:20:23'}
ORDER BY TIMEZONE_ID DESC
Query column usage
All columns are used
|
|
|
variables.GetCMSMarkets
|
44 |
0 ms |
100% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/wwwroot/cfg_LanguageStructs.cfm |
4 |
Yes |
SQL
SELECT CMS_MARKETS_ID, COUNTRY_CD, CMS_MARKET_CD_DEFAULT
from CMS_MARKETS
Query column usage
All columns are used
|
|
|
variables.CMSLanguagesAvailable
|
79 |
0 ms |
80% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/wwwroot/cfg_LanguageStructs.cfm |
33 |
Yes |
SQL
SELECT CMS_MARKET_LANGUAGES_ID, CMS_MARKET_ID, CMS_MARKET_CD, EVO_LNG_CD, EVO_LNG_LABEL
from CMS_MARKET_LANGUAGES
WHERE CMS_MARKET_ID in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,26,27,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,46,47)
Query column usage
the following columns are NOT used:
CMS_MARKET_LANGUAGES_ID
|
|
|
GetLabelIDList
|
0 |
0.817 ms |
0% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/modules/Translation/Queries/qry_SelectPageTranslations.cfm |
9 |
No |
SQL
SELECT LABEL_ID FROM LABEL_DETAILS WHERE COMPANY_ID=461 AND FUSE='IndexLoggedOut' AND PAGE='main'
Query column usage
None of the columns are used
|
|
|
GetTranslation
|
0 |
0 ms |
0% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/modules/Translation/Queries/qry_SelectPageTranslations.cfm |
21 |
Yes |
SQL
SELECT ls.LABEL_ID, ls.LABEL_NAME , lt.Translation
FROM LABELS ls
INNER JOIN LABEL_TRANSLATIONS lt ON (
ls.LABEL_ID = lt.LABEL_ID
)
WHERE ls.LABEL_ID IN (0)
AND lt.LANGUAGE_CD='en_dot'
Query column usage
None of the columns are used
|
|
|
GetLabelIDList
|
2 |
0 ms |
100% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/modules/Translation/Queries/qry_SelectPageTranslationsAll.cfm |
12 |
Yes |
SQL
SELECT LABEL_ID FROM LABEL_DETAILS WHERE COMPANY_ID=461 AND FUSE='ALL'
Query column usage
All columns are used
|
|
|
GetTranslationALL
|
0 |
0.879 ms |
0% |
shopdoterra-voprf1 |
/www/shopdoterra-iact/system/modules/Translation/Queries/qry_SelectPageTranslationsAll.cfm |
22 |
No |
SQL
SELECT ls.LABEL_ID, ls.LABEL_NAME , lt.Translation
FROM LABELS ls
INNER JOIN LABEL_TRANSLATIONS lt ON (
ls.LABEL_ID = lt.LABEL_ID
)
WHERE ls.LABEL_ID IN (873571,875397)
AND lt.LANGUAGE_CD='en_dot'
Query column usage
None of the columns are used
|
|
|