Campaign tags and filters


When sending a campaign, you are able to use a number of custom tags and filters.
Most common tags are listed below:

Tag Required
[UNSUBSCRIBE_URL] YES
[COMPANY_FULL_ADDRESS] YES
[UPDATE_PROFILE_URL] NO
[WEB_VERSION_URL] NO
[CAMPAIGN_URL] NO
[LIST_NAME] NO
[LIST_SUBJECT] NO
[LIST_DESCRIPTION] NO
[LIST_FROM_NAME] NO
[CURRENT_YEAR] NO
[CURRENT_MONTH] NO
[CURRENT_DAY] NO
[CURRENT_DATE] NO
[COMPANY_NAME] NO
[COMPANY_ADDRESS_1] NO
[COMPANY_ADDRESS_2] NO
[COMPANY_CITY] NO
[COMPANY_ZONE] NO
[COMPANY_ZIP] NO
[COMPANY_COUNTRY] NO
[COMPANY_PHONE] NO
[CAMPAIGN_SUBJECT] NO
[CAMPAIGN_TO_NAME] NO
[CAMPAIGN_FROM_NAME] NO
[CAMPAIGN_REPLY_TO] NO
[CAMPAIGN_UID] NO
[SUBSCRIBER_UID] NO
[EMAIL] NO
[FNAME] NO
[LNAME] NO
Now, each of the above tags is able to receive a set of filters.
Filters are a simple way of transforming the tag in a way or another, for example you might want to embed a sharing link to twitter in your campaign, say the campaign url itself.

Using only the tags you would embed it like:

https://twitter.com/intent/tweet?text=[CAMPAIGN_SUBJECT]&url=[CAMPAIGN_URL]

But there is a problem, because twitter expects your arguments to be url encoded, and by that, i mean twitter expects to get

https://twitter.com/intent/tweet?text=my%20super%20campaign&url=http%3A%2F%2Fwww.domain.com%2Fcampaigns%2F1cart129djat3

but instead it will get https://twitter.com/intent/tweet?text=my super campaign&url=http://www.domain.com/campaigns/1cart129djat3

In order to overcome this issue, we will apply filters over our tags, therefore, the twitter url becomes:

https://twitter.com/intent/tweet?text=[CAMPAIGN_SUBJECT:filter:urlencode]&url=[CAMPAIGN_URL:filter:urlencode]

Pretty simple eh?
But we can do even more, let's say we want to make sure our twitter text starts with a capitalized letter and the rest of the letters will be lowercase.
In order to accomplish this, we can apply multiple filters(separate by a pipe) to same tag, for example:

https://twitter.com/intent/tweet?text=[CAMPAIGN_SUBJECT:filter:lowercase|ucfirst|urlencode]&url=[CAMPAIGN_URL:filter:urlencode]
Please note, the order in which you add the filters is the same order they are applied.

Bellow is the entire list of filters, for now there are a few, but in the future the number might increase.
urlencode will urlencode your tag
rawurlencode will rawurlencode your url
htmlencode will convert html tags into their entities
trim will trim the white spaces from begining and end of your tag
uppercase will transform your tag in uppercase only chars
lowercase will transform your tag in lowercase only chars
ucwords will capitalize each first letter from your tag content
ucfirst will capitalize only the first letter of your tag
reverse will reverse your tag content

Categories: Informations
Application Log
Timestamp Level Category Message
11:02:14.386023 info application
User: Guest (ID: )

$_GET=array (
  'slug' => 'campaign-tag-filters',
)

$_SERVER=array (
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_ACCEPT' =>
'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_HOST' => 'sender.mailbul.com',
  'HTTP_CONNECTION' => 'Keep-Alive',
  'PATH' =>
'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin',
  'SERVER_SIGNATURE' => 'Apache/2.4.41 (Ubuntu) Server at
sender.mailbul.com Port 80',
  'SERVER_SOFTWARE' => 'Apache/2.4.41 (Ubuntu)',
  'SERVER_NAME' => 'sender.mailbul.com',
  'SERVER_ADDR' => '78.142.62.200',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '18.97.14.89',
  'DOCUMENT_ROOT' => '/var/www/sender.bulklist.email/public_html',
  'REQUEST_SCHEME' => 'http',
  'CONTEXT_PREFIX' => '',
  'CONTEXT_DOCUMENT_ROOT' => '/var/www/sender.bulklist.email/public_html',
  'SERVER_ADMIN' => 'admin@sender.bulklist.email',
  'SCRIPT_FILENAME' =>
'/var/www/sender.bulklist.email/public_html/index.php',
  'REMOTE_PORT' => '39798',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/index.php/article/campaign-tag-filters',
  'SCRIPT_NAME' => '/index.php',
  'PATH_INFO' => '/article/campaign-tag-filters',
  'PATH_TRANSLATED' =>
'/var/www/sender.bulklist.email/public_html/article/campaign-tag-filters',
  'PHP_SELF' => '/index.php/article/campaign-tag-filters',
  'REQUEST_TIME_FLOAT' => 1745751734.38227,
  'REQUEST_TIME' => 1745751734,
)
11:02:14.387778 trace system.CModule
Loading "log" application component
in /var/www/sender.bulklist.email/public_html/apps/init.php (177)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.388236 trace system.CModule
Loading "systemInit" application component
in /var/www/sender.bulklist.email/public_html/apps/init.php (177)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.388325 trace system.CModule
Loading "frontendSystemInit" application component
in /var/www/sender.bulklist.email/public_html/apps/init.php (177)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.388430 trace system.CModule
Loading "request" application component
in /var/www/sender.bulklist.email/public_html/apps/init.php (177)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.389060 trace system.CModule
Loading "dependencyInjectionContainer" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(111)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(46)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.393817 trace system.CModule
Loading "hooks" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(60)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseFormModel.php
(100)
in
/var/www/sender.bulklist.email/public_html/vendor/league/container/src/Definition/Definition.php
(256)
11:02:14.394187 trace system.CModule
Loading "options" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(52)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(67)
11:02:14.394288 trace system.CModule
Loading "db" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(130)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(235)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
11:02:14.394386 trace system.db.CDbConnection
Opening DB connection
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(130)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(235)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
11:02:14.397228 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.397242 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.reverse_proxy')
11:02:14.398322 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.reverse_proxy')
11:02:14.398720 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.common'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.398729 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.common')
11:02:14.399863 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.common')
11:02:14.400003 trace system.CModule
Loading "ioFilter" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(103)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(68)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.405083 trace system.CModule
Loading "cache" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(132)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(180)
11:02:14.405616 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=server2:server2:{{language}}" from
cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(132)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(180)
11:02:14.406265 trace system.db.ar.CActiveRecord
Language.findByAttributes()
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(180)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(274)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(76)
11:02:14.406543 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0
LIMIT 1. Bound with :yp0='yes'
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Language.php
(180)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(274)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(76)
11:02:14.406550 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE
`t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes')
11:02:14.407362 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE
`t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes')
11:02:14.407864 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.cdn'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.407874 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.cdn')
11:02:14.408531 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.cdn')
11:02:14.408586 trace system.CModule
Loading "extensionsManager" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(299)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(108)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.411843 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.411851 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate')
11:02:14.412524 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.translate')
11:02:14.412579 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-assets'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.412586 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-assets')
11:02:14.413269 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-assets')
11:02:14.413325 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ip-location-maxmind'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.413331 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ip-location-maxmind')
11:02:14.413988 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ip-location-maxmind')
11:02:14.414043 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.campaign-activity-map'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.414051 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.campaign-activity-map')
11:02:14.414707 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.campaign-activity-map')
11:02:14.414774 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-redirect'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.414782 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-redirect')
11:02:14.415451 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-redirect')
11:02:14.415503 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-paypal'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.415509 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-paypal')
11:02:14.416249 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-paypal')
11:02:14.416312 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ai-assistant'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.416325 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ai-assistant')
11:02:14.417100 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ai-assistant')
11:02:14.417154 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.html-blocks'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.417159 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.html-blocks')
11:02:14.417820 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.html-blocks')
11:02:14.417866 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-template-builder'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.417871 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-template-builder')
11:02:14.418597 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-template-builder')
11:02:14.418855 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.cookie-consent'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.418860 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.cookie-consent')
11:02:14.419698 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.cookie-consent')
11:02:14.419753 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-verification'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.419758 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-verification')
11:02:14.420499 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.email-verification')
11:02:14.420545 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.recaptcha'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.420550 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.recaptcha')
11:02:14.421279 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.recaptcha')
11:02:14.421325 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-webhooks'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.421330 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-webhooks')
11:02:14.422169 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.list-form-custom-webhooks')
11:02:14.422216 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.extension.tour'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.422223 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.tour')
11:02:14.423075 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.tour')
11:02:14.423258 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-offline'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.423264 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-offline')
11:02:14.424025 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.payment-gateway-offline')
11:02:14.424069 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ckeditor'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.424074 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ckeditor')
11:02:14.424810 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.ckeditor')
11:02:14.424988 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.extension.search'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.424994 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.search')
11:02:14.425858 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.search')
11:02:14.426035 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.articles-content-builder'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.426040 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.articles-content-builder')
11:02:14.426870 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.articles-content-builder')
11:02:14.426914 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.landing-pages-content-builder'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.426919 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.landing-pages-content-builder')
11:02:14.427836 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.landing-pages-content-builder')
11:02:14.427884 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.pages-content-builder'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.427887 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.pages-content-builder')
11:02:14.428592 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.pages-content-builder')
11:02:14.428637 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.extension.content-builder'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ExtensionsManager.php
(224)
11:02:14.428642 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.content-builder')
11:02:14.429266 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.extension.content-builder')
11:02:14.429297 trace system.CModule
Loading "themeManager" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/init/SystemInit.php
(118)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.429507 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.theme.frontend'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/ThemeManager.php
(118)
11:02:14.429512 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.theme.frontend')
11:02:14.430170 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.theme.frontend')
11:02:14.430283 trace system.CModule
Loading "urlManager" application component
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.430810 trace system.caching.CFileCache
Serving "Yii.CUrlManager.rules" from cache
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
in /var/www/sender.bulklist.email/public_html/index.php (18)
11:02:14.433669 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.license'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.433676 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.license')
11:02:14.434336 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.license')
11:02:14.434592 trace application
Did frontend_controller_before_action action, 2 action hooks were
triggered!
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/HooksManager.php
(118)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(512)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.434916 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=server2:server2:{{article}}" from
cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/Article.php
(139)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(150)
11:02:14.435129 trace system.db.ar.CActiveRecord
Article.findByAttributes()
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(150)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(102)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.435208 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1.
Bound with :yp0='campaign-tag-filters'
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(150)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(102)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.435213 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters')
11:02:14.436269 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters')
11:02:14.443571 trace system.CModule
Loading "clientScript" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(275)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(116)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.443912 trace system.CModule
Loading "securityManager" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(582)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(119)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.444080 trace system.CModule
Loading "statePersister" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(582)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(119)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.444319 trace system.caching.CFileCache
Serving
"Yii.CStatePersister./var/www/sender.bulklist.email/public_html/apps/common/runtime/state.bin"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(582)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(119)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
11:02:14.445430 trace application
Did register_scripts filter, 1 filter hooks were triggered!
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/HooksManager.php
(302)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(627)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(594)
11:02:14.445914 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.customization'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.445920 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.customization')
11:02:14.446624 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.customization')
11:02:14.446820 trace application
Did register_styles filter, 1 filter hooks were triggered!
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/HooksManager.php
(302)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(630)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(594)
11:02:14.455595 trace system.CModule
Loading "widgetFactory" application component
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/articles/view.php
(47)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(119)
11:02:14.455773 trace system.db.ar.CActiveRecord
lazy loading Article.activeCategories
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(549)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(36)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/articles/view.php
(47)
11:02:14.456065 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=server2:server2:{{article_category}}"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(191)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(257)
11:02:14.456497 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=server2:server2:{{article_to_category}}"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(893)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(536)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(171)
11:02:14.456604 trace system.db.CDbCommand
Querying SQL: SELECT `activeCategories`.`category_id` AS `t1_c0`,
`activeCategories`.`parent_id` AS `t1_c1`, `activeCategories`.`name` AS
`t1_c2`, `activeCategories`.`slug` AS `t1_c3`,
`activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS
`t1_c5`, `activeCategories`.`date_added` AS `t1_c6`,
`activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`activeCategories`  INNER JOIN `mw_article_to_category`
`activeCategories_activeCategories` ON
(`activeCategories_activeCategories`.`article_id`=:ypl0) AND
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (activeCategories.status = :st). Bound with :st='active', :ypl0=8
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(543)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(171)
11:02:14.456613 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `activeCategories`.`category_id` AS
`t1_c0`, `activeCategories`.`parent_id` AS `t1_c1`,
`activeCategories`.`name` AS `t1_c2`, `activeCategories`.`slug` AS `t1_c3`,
`activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS
`t1_c5`, `activeCategories`.`date_added` AS `t1_c6`,
`activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`activeCategories`  INNER JOIN `mw_article_to_category`
`activeCategories_activeCategories` ON
(`activeCategories_activeCategories`.`article_id`=:ypl0) AND
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (activeCategories.status = :st). Bound with :st='active', :ypl0=8)
11:02:14.457964 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `activeCategories`.`category_id` AS
`t1_c0`, `activeCategories`.`parent_id` AS `t1_c1`,
`activeCategories`.`name` AS `t1_c2`, `activeCategories`.`slug` AS `t1_c3`,
`activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS
`t1_c5`, `activeCategories`.`date_added` AS `t1_c6`,
`activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`activeCategories`  INNER JOIN `mw_article_to_category`
`activeCategories_activeCategories` ON
(`activeCategories_activeCategories`.`article_id`=:ypl0) AND
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (activeCategories.status = :st). Bound with :st='active', :ypl0=8)
11:02:14.458164 trace system.db.ar.CActiveRecord
lazy loading Article.categories
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(549)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(41)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/articles/view.php
(47)
11:02:14.458275 trace system.db.CDbCommand
Querying SQL: SELECT `categories`.`category_id` AS `t1_c0`,
`categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS `t1_c2`,
`categories`.`slug` AS `t1_c3`, `categories`.`description` AS `t1_c4`,
`categories`.`status` AS `t1_c5`, `categories`.`date_added` AS `t1_c6`,
`categories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`categories`  INNER JOIN `mw_article_to_category` `categories_categories`
ON (`categories_categories`.`article_id`=:ypl0) AND
(`categories`.`category_id`=`categories_categories`.`category_id`). Bound
with :ypl0=8
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(543)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(171)
11:02:14.458281 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `categories`.`category_id` AS
`t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS
`t1_c2`, `categories`.`slug` AS `t1_c3`, `categories`.`description` AS
`t1_c4`, `categories`.`status` AS `t1_c5`, `categories`.`date_added` AS
`t1_c6`, `categories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`categories`  INNER JOIN `mw_article_to_category` `categories_categories`
ON (`categories_categories`.`article_id`=:ypl0) AND
(`categories`.`category_id`=`categories_categories`.`category_id`). Bound
with :ypl0=8)
11:02:14.459278 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `categories`.`category_id` AS
`t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS
`t1_c2`, `categories`.`slug` AS `t1_c3`, `categories`.`description` AS
`t1_c4`, `categories`.`status` AS `t1_c5`, `categories`.`date_added` AS
`t1_c6`, `categories`.`last_updated` AS `t1_c7` FROM `mw_article_category`
`categories`  INNER JOIN `mw_article_to_category` `categories_categories`
ON (`categories_categories`.`article_id`=:ypl0) AND
(`categories`.`category_id`=`categories_categories`.`category_id`). Bound
with :ypl0=8)
11:02:14.459621 trace system.CModule
Loading "messages" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(324)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/article/views/categories.php
(23)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(53)
11:02:14.459836 trace system.db.ar.CActiveRecord
Article.findAll()
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/article/ArticleRelatedArticlesWidget.php
(74)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/articles/view.php
(50)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(236)
11:02:14.460041 trace system.db.CDbCommand
Querying SQL: SELECT `t`.`article_id` AS `t0_c0`, `t`.`title` AS `t0_c1`,
`t`.`slug` AS `t0_c2`, `t`.`content` AS `t0_c3`, `t`.`status` AS `t0_c4`,
`t`.`date_added` AS `t0_c5`, `t`.`last_updated` AS `t0_c6`,
`activeCategories`.`category_id` AS `t1_c0`, `activeCategories`.`parent_id`
AS `t1_c1`, `activeCategories`.`name` AS `t1_c2`, `activeCategories`.`slug`
AS `t1_c3`, `activeCategories`.`description` AS `t1_c4`,
`activeCategories`.`status` AS `t1_c5`, `activeCategories`.`date_added` AS
`t1_c6`, `activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article` `t`
 INNER JOIN `mw_article_to_category` `activeCategories_activeCategories` ON
(`t`.`article_id`=`activeCategories_activeCategories`.`article_id`) INNER
JOIN `mw_article_category` `activeCategories` ON
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (((t.status=:ycp0) AND (t.article_id != :id)) AND
(activeCategories.category_id=:ycp1)) AND (activeCategories.status = :st)
LIMIT 8. Bound with :ycp0='published', :id=8, :ycp1=4, :st='active'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(470)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/CActiveFinder.php
(71)
11:02:14.460047 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`article_id` AS `t0_c0`,
`t`.`title` AS `t0_c1`, `t`.`slug` AS `t0_c2`, `t`.`content` AS `t0_c3`,
`t`.`status` AS `t0_c4`, `t`.`date_added` AS `t0_c5`, `t`.`last_updated` AS
`t0_c6`, `activeCategories`.`category_id` AS `t1_c0`,
`activeCategories`.`parent_id` AS `t1_c1`, `activeCategories`.`name` AS
`t1_c2`, `activeCategories`.`slug` AS `t1_c3`,
`activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS
`t1_c5`, `activeCategories`.`date_added` AS `t1_c6`,
`activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article` `t`  INNER
JOIN `mw_article_to_category` `activeCategories_activeCategories` ON
(`t`.`article_id`=`activeCategories_activeCategories`.`article_id`) INNER
JOIN `mw_article_category` `activeCategories` ON
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (((t.status=:ycp0) AND (t.article_id != :id)) AND
(activeCategories.category_id=:ycp1)) AND (activeCategories.status = :st)
LIMIT 8. Bound with :ycp0='published', :id=8, :ycp1=4, :st='active')
11:02:14.461558 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`article_id` AS `t0_c0`,
`t`.`title` AS `t0_c1`, `t`.`slug` AS `t0_c2`, `t`.`content` AS `t0_c3`,
`t`.`status` AS `t0_c4`, `t`.`date_added` AS `t0_c5`, `t`.`last_updated` AS
`t0_c6`, `activeCategories`.`category_id` AS `t1_c0`,
`activeCategories`.`parent_id` AS `t1_c1`, `activeCategories`.`name` AS
`t1_c2`, `activeCategories`.`slug` AS `t1_c3`,
`activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS
`t1_c5`, `activeCategories`.`date_added` AS `t1_c6`,
`activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article` `t`  INNER
JOIN `mw_article_to_category` `activeCategories_activeCategories` ON
(`t`.`article_id`=`activeCategories_activeCategories`.`article_id`) INNER
JOIN `mw_article_category` `activeCategories` ON
(`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`)
WHERE (((t.status=:ycp0) AND (t.article_id != :id)) AND
(activeCategories.category_id=:ycp1)) AND (activeCategories.status = :st)
LIMIT 8. Bound with :ycp0='published', :id=8, :ycp1=4, :st='active')
11:02:14.475075 trace application
Did after_opening_body_tag action, 1 action hooks were triggered!
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/HooksManager.php
(118)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(452)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/layouts/main.php
(45)
11:02:14.475642 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.urls'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.475651 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.urls')
11:02:14.476207 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.urls')
11:02:14.476341 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with
:c='system.customer_registration'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/models/OptionAttributes.php
(35)
11:02:14.476349 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.customer_registration')
11:02:14.476823 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.customer_registration')
11:02:14.477293 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=server2:server2:{{menu_zone}}"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/var/www/sender.bulklist.email/public_html/apps/common/models/MenuZone.php
(133)
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(193)
11:02:14.477432 trace system.db.ar.CActiveRecord
MenuZone.findByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(193)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/header.php
(41)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
11:02:14.477513 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT
1. Bound with :yp0='frontend-header'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(193)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/header.php
(41)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
11:02:14.477519 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header')
11:02:14.478077 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header')
11:02:14.478298 trace system.caching.CFileCache
Serving "yii:dbschemamysql:host=localhost;dbname=server2:server2:{{menu}}"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(134)
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(198)
11:02:14.478404 trace system.db.ar.CActiveRecord
Menu.findAllByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(198)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/header.php
(41)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
11:02:14.478462 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu` `t` WHERE `t`.`zone_id`=:yp0 AND
`t`.`status`=:yp1. Bound with :yp0=1, :yp1='active'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(198)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/header.php
(41)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
11:02:14.478468 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE
`t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=1, :yp1='active')
11:02:14.478965 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE
`t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=1, :yp1='active')
11:02:14.479053 trace system.CModule
Loading "notify" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(44)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/layouts/main.php
(59)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/web/BaseController.php
(236)
11:02:14.479123 trace system.CModule
Loading "user" application component
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(95)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/NotifyManager.php
(92)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/views/layouts/main.php
(59)
11:02:14.479356 trace system.CModule
Loading "session" application component
in
/var/www/sender.bulklist.email/public_html/apps/backend/components/web/auth/WebUser.php
(29)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(95)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/NotifyManager.php
(92)
11:02:14.479629 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745751734,
:id='3t3hqdtc9dh6aai6l872a40lma'
in
/var/www/sender.bulklist.email/public_html/apps/backend/components/web/auth/WebUser.php
(29)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/utils/functions.php
(95)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/NotifyManager.php
(92)
11:02:14.479635 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745751734,
:id='3t3hqdtc9dh6aai6l872a40lma')
11:02:14.480124 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745751734,
:id='3t3hqdtc9dh6aai6l872a40lma')
11:02:14.480346 trace system.db.ar.CActiveRecord
MenuZone.findByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(193)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.480401 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT
1. Bound with :yp0='frontend-footer'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(193)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.480407 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer')
11:02:14.480761 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE
`t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer')
11:02:14.480871 trace system.db.ar.CActiveRecord
Menu.findAllByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(198)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.480925 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu` `t` WHERE `t`.`zone_id`=:yp0 AND
`t`.`status`=:yp1. Bound with :yp0=2, :yp1='active'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Menu.php
(198)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.480931 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE
`t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=2, :yp1='active')
11:02:14.481300 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE
`t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=2, :yp1='active')
11:02:14.481549 trace system.caching.CFileCache
Serving "yii:dbschemamysql:host=localhost;dbname=server2:server2:{{page}}"
from cache
in
/var/www/sender.bulklist.email/public_html/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(148)
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(229)
11:02:14.481698 trace system.db.ar.CActiveRecord
Page.findByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(229)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(36)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.481795 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_page` `t` WHERE `t`.`slug`=:yp0 AND
`t`.`status`=:yp1 LIMIT 1. Bound with :yp0='terms-and-conditions',
:yp1='active'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(229)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(36)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.481801 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE
`t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with
:yp0='terms-and-conditions', :yp1='active')
11:02:14.482328 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE
`t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with
:yp0='terms-and-conditions', :yp1='active')
11:02:14.482512 trace system.db.ar.CActiveRecord
Page.findByAttributes()
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(229)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(39)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.482567 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_page` `t` WHERE `t`.`slug`=:yp0 AND
`t`.`status`=:yp1 LIMIT 1. Bound with :yp0='privacy-policy', :yp1='active'
in /var/www/sender.bulklist.email/public_html/apps/common/models/Page.php
(229)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(39)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/FooterWidget.php
(31)
11:02:14.482573 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE
`t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with
:yp0='privacy-policy', :yp1='active')
11:02:14.482970 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE
`t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with
:yp0='privacy-policy', :yp1='active')
11:02:14.483187 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.social_links'
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(236)
in
/var/www/sender.bulklist.email/public_html/apps/common/components/managers/OptionsManager.php
(99)
in
/var/www/sender.bulklist.email/public_html/apps/frontend/components/web/widgets/views/footer.php
(50)
11:02:14.483195 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.social_links')
11:02:14.483648 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `category`, `key`, `value`,
`is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with
:c='system.social_links')
11:02:14.483752 trace system.CModule
Loading "assetManager" application component
in
/var/www/sender.bulklist.email/public_html/apps/frontend/controllers/ArticlesController.php
(119)
in /var/www/sender.bulklist.email/public_html/apps/init.php (223)
in /var/www/sender.bulklist.email/public_html/index.php (18)
Profiling Summary Report (Time: 0.10100s, Memory: 2,621KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.common') 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 1 0.00108 0.00108 0.00108 0.00108
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.landing-pages-content-builder') 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes') 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.tour') 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.cookie-consent') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.list-form-custom-webhooks') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.email-verification') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.search') 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.cdn') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.payment-gateway-paypal') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ai-assistant') 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.payment-gateway-offline') 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ckeditor') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.recaptcha') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.list-form-custom-assets') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.translate') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.list-form-custom-redirect') 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.campaign-activity-map') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ip-location-maxmind') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.html-blocks') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.email-template-builder') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.articles-content-builder') 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SELECT `t`.`article_id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`slug` AS `t0_c2`, `t`.`content` AS `t0_c3`, `t`.`status` AS `t0_c4`, `t`.`date_added` AS `t0_c5`, `t`.`last_updated` AS `t0_c6`, `activeCategories`.`category_id` AS `t1_c0`, `activeCategories`.`parent_id` AS `t1_c1`, `activeCategories`.`name` AS `t1_c2`, `activeCategories`.`slug` AS `t1_c3`, `activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS `t1_c5`, `activeCategories`.`date_added` AS `t1_c6`, `activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article` `t` INNER JOIN `mw_article_to_category` `activeCategories_activeCategories` ON (`t`.`article_id`=`activeCategories_activeCategories`.`article_id`) INNER JOIN `mw_article_category` `activeCategories` ON (`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`) WHERE (((t.status=:ycp0) AND (t.article_id != :id)) AND (activeCategories.category_id=:ycp1)) AND (activeCategories.status = :st) LIMIT 8. Bound with :ycp0='published', :id=8, :ycp1=4, :st='active') 1 0.00151 0.00151 0.00151 0.00151
system.db.CDbCommand.query(SELECT `activeCategories`.`category_id` AS `t1_c0`, `activeCategories`.`parent_id` AS `t1_c1`, `activeCategories`.`name` AS `t1_c2`, `activeCategories`.`slug` AS `t1_c3`, `activeCategories`.`description` AS `t1_c4`, `activeCategories`.`status` AS `t1_c5`, `activeCategories`.`date_added` AS `t1_c6`, `activeCategories`.`last_updated` AS `t1_c7` FROM `mw_article_category` `activeCategories` INNER JOIN `mw_article_to_category` `activeCategories_activeCategories` ON (`activeCategories_activeCategories`.`article_id`=:ypl0) AND (`activeCategories`.`category_id`=`activeCategories_activeCategories`.`category_id`) WHERE (activeCategories.status = :st). Bound with :st='active', :ypl0=8) 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SELECT `categories`.`category_id` AS `t1_c0`, `categories`.`parent_id` AS `t1_c1`, `categories`.`name` AS `t1_c2`, `categories`.`slug` AS `t1_c3`, `categories`.`description` AS `t1_c4`, `categories`.`status` AS `t1_c5`, `categories`.`date_added` AS `t1_c6`, `categories`.`last_updated` AS `t1_c7` FROM `mw_article_category` `categories` INNER JOIN `mw_article_to_category` `categories_categories` ON (`categories_categories`.`article_id`=:ypl0) AND (`categories`.`category_id`=`categories_categories`.`category_id`). Bound with :ypl0=8) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.pages-content-builder') 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customization') 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.license') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.theme.frontend') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.content-builder') 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.urls') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE `t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with :yp0='terms-and-conditions', :yp1='active') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE `t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=1, :yp1='active') 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1745751734, :id='3t3hqdtc9dh6aai6l872a40lma') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customer_registration') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.social_links') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT * FROM `mw_page` `t` WHERE `t`.`slug`=:yp0 AND `t`.`status`=:yp1 LIMIT 1. Bound with :yp0='privacy-policy', :yp1='active') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT * FROM `mw_menu` `t` WHERE `t`.`zone_id`=:yp0 AND `t`.`status`=:yp1. Bound with :yp0=2, :yp1='active') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 1 0.00035 0.00035 0.00035 0.00035