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
10:26:30.801470 info application
User: Guest (ID: )

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

$_SERVER=array (
  'USER' => 'qayak-gawab',
  'HOME' => '/home/qayak-gawab',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko;
compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_CONNECTION' => 'close',
  'HTTP_X_FORWARDED_FOR' => '216.73.217.94',
  'HTTP_X_REAL_IP' => '216.73.217.94',
  'HTTP_X_FORWARDED_HOST' => 'gawab.qayak.net',
  'PHP_VALUE' => 'error_log=/home/qayak-gawab/logs/php/error.log;
memory_limit=512M;
max_execution_time=300;
max_input_time=60;
max_input_vars=10000;
post_max_size=64M;
upload_max_filesize=64M;
date.timezone=America/New_York;
display_errors=off;',
  'HTTPS' => 'on',
  'MGT' => '1',
  'GEOIP_LONGITUDE' => '-118.0276',
  'GEOIP_LATITUDE' => '34.0686',
  'GEOIP_CITY_CONTINENT_CODE' => 'NA',
  'GEOIP_POSTAL_CODE' => '',
  'GEOIP_CITY' => 'El Monte',
  'GEOIP_REGION' => 'CA',
  'GEOIP_CITY_COUNTRY_NAME' => 'United States',
  'GEOIP_CITY_COUNTRY_CODE3' => 'USA',
  'GEOIP_CITY_COUNTRY_CODE' => 'US',
  'GEOIP_COUNTRY_NAME' => 'United States',
  'GEOIP_COUNTRY_CODE3' => 'USA',
  'GEOIP_COUNTRY_CODE' => 'US',
  'REDIRECT_STATUS' => '200',
  'HTTP_HOST' => 'gawab.qayak.net',
  'SERVER_NAME' => 'gawab.qayak.net',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '127.0.0.1',
  'REMOTE_PORT' => '',
  'REMOTE_ADDR' => '216.73.217.94',
  'SERVER_SOFTWARE' => 'nginx/1.28.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.0',
  'DOCUMENT_ROOT' => '/home/qayak-gawab/htdocs/gawab',
  'DOCUMENT_URI' => '/index.php',
  'REQUEST_URI' => '/article/campaign-tag-filters',
  'SCRIPT_NAME' => '/index.php',
  'SCRIPT_FILENAME' => '/home/qayak-gawab/htdocs/gawab/index.php',
  'CONTENT_LENGTH' => '',
  'CONTENT_TYPE' => '',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1780914390.795165,
  'REQUEST_TIME' => 1780914390,
)
10:26:30.803277 trace system.CModule
Loading "log" application component
in /home/qayak-gawab/htdocs/gawab/apps/init.php (177)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
10:26:30.803796 trace system.CModule
Loading "systemInit" application component
in /home/qayak-gawab/htdocs/gawab/apps/init.php (177)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
10:26:30.803878 trace system.CModule
Loading "frontendSystemInit" application component
in /home/qayak-gawab/htdocs/gawab/apps/init.php (177)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
10:26:30.803941 trace system.CModule
Loading "request" application component
in /home/qayak-gawab/htdocs/gawab/apps/init.php (177)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
10:26:30.804466 trace system.CModule
Loading "dependencyInjectionContainer" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(111)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(46)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.808446 trace system.CModule
Loading "hooks" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(60)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseFormModel.php
(100)
in
/home/qayak-gawab/htdocs/gawab/vendor/league/container/src/Definition/Definition.php
(256)
10:26:30.808828 trace system.CModule
Loading "options" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(52)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(67)
10:26:30.808898 trace system.CModule
Loading "db" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(130)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(235)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
10:26:30.808990 trace system.db.CDbConnection
Opening DB connection
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(130)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(235)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
10:26:30.811379 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.811389 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')
10:26:30.812329 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')
10:26:30.812436 trace system.CModule
Loading "ioFilter" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(103)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseHttpRequest.php
(136)
in
/home/qayak-gawab/htdocs/gawab/apps/common/models/option/OptionReverseProxy.php
(97)
10:26:30.824233 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.common'
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.824240 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')
10:26:30.825356 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')
10:26:30.825510 trace system.CModule
Loading "urlManager" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(291)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(72)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.825706 trace system.CModule
Loading "cache" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(291)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(72)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.826664 trace system.caching.CFileCache
Serving "Yii.CUrlManager.rules" from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(291)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(72)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.828025 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{language}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Language.php (132)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Language.php (180)
10:26:30.828582 trace system.db.ar.CActiveRecord
Language.findByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Language.php (180)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(274)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(76)
10:26:30.828834 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0
LIMIT 1. Bound with :yp0='yes'
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Language.php (180)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(274)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(76)
10:26:30.828839 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')
10:26:30.829648 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')
10:26:30.830154 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.cdn'
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.830161 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')
10:26:30.830770 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')
10:26:30.830831 trace system.CModule
Loading "extensionsManager" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(299)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(108)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.833048 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.833055 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')
10:26:30.833832 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')
10:26:30.833901 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.833905 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')
10:26:30.834440 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')
10:26:30.834492 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.834496 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')
10:26:30.834907 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')
10:26:30.834953 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.834955 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')
10:26:30.835277 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')
10:26:30.835314 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.835319 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')
10:26:30.835633 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')
10:26:30.835675 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.835679 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')
10:26:30.835988 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')
10:26:30.836277 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.836282 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')
10:26:30.836647 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')
10:26:30.836751 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.836755 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')
10:26:30.837052 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')
10:26:30.837090 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.837093 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')
10:26:30.837374 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')
10:26:30.837413 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.837415 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')
10:26:30.837728 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')
10:26:30.838037 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.838042 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')
10:26:30.838404 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')
10:26:30.838444 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.838448 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')
10:26:30.838762 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')
10:26:30.838800 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.838804 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')
10:26:30.839097 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')
10:26:30.839134 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.839138 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')
10:26:30.839431 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')
10:26:30.839489 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.839493 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')
10:26:30.839822 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')
10:26:30.839859 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.839860 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')
10:26:30.840173 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')
10:26:30.840456 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.840461 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')
10:26:30.840866 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')
10:26:30.841118 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.841121 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')
10:26:30.841454 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')
10:26:30.841496 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.841500 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')
10:26:30.841804 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')
10:26:30.841842 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.841845 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')
10:26:30.842134 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')
10:26:30.842171 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ExtensionsManager.php
(224)
10:26:30.842174 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')
10:26:30.842473 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')
10:26:30.842505 trace system.CModule
Loading "themeManager" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/init/SystemInit.php
(118)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
10:26:30.842808 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/ThemeManager.php
(118)
10:26:30.842813 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')
10:26:30.843147 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')
10:26:30.848468 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.license'
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.848475 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')
10:26:30.849298 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')
10:26:30.849625 trace application
Did frontend_controller_before_action action, 2 action hooks were
triggered!
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/HooksManager.php
(118)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(512)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.850085 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{article}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Article.php (139)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(150)
10:26:30.850361 trace system.db.ar.CActiveRecord
Article.findByAttributes()
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(150)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(102)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.850455 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1.
Bound with :yp0='campaign-tag-filters'
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(150)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(102)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.850461 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')
10:26:30.851187 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')
10:26:30.851861 trace system.CModule
Loading "clientScript" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(275)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(116)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.852505 trace system.CModule
Loading "securityManager" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(582)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(119)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.855549 trace system.CModule
Loading "statePersister" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(582)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(119)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.855881 trace system.caching.CFileCache
Serving
"Yii.CStatePersister./home/qayak-gawab/htdocs/gawab/apps/common/runtime/state.bin"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(582)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(119)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
10:26:30.857441 trace application
Did register_scripts filter, 1 filter hooks were triggered!
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/HooksManager.php
(302)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(627)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(594)
10:26:30.858158 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.customization'
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.858165 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')
10:26:30.858957 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')
10:26:30.859239 trace application
Did register_styles filter, 1 filter hooks were triggered!
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/HooksManager.php
(302)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(630)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(594)
10:26:30.872395 trace system.CModule
Loading "widgetFactory" application component
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/articles/view.php
(47)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(119)
10:26:30.872956 trace system.db.ar.CActiveRecord
lazy loading Article.activeCategories
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(549)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(36)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/articles/view.php
(47)
10:26:30.873322 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{article_category}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(191)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(257)
10:26:30.873987 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{article_to_category}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(893)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(536)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(171)
10:26:30.874123 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(543)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(171)
10:26:30.874129 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)
10:26:30.875231 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)
10:26:30.875530 trace system.db.ar.CActiveRecord
lazy loading Article.categories
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(549)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(41)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/articles/view.php
(47)
10:26:30.875792 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(543)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(171)
10:26:30.875835 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)
10:26:30.876621 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)
10:26:30.877137 trace system.CModule
Loading "messages" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(324)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/article/views/categories.php
(23)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/article/ArticleCategoriesWidget.php
(53)
10:26:30.877532 trace system.db.ar.CActiveRecord
Article.findAll()
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/article/ArticleRelatedArticlesWidget.php
(74)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/articles/view.php
(50)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(236)
10:26:30.878040 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(690)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(470)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/CActiveFinder.php
(71)
10:26:30.878046 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')
10:26:30.879169 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')
10:26:30.880358 trace application
Did after_opening_body_tag action, 1 action hooks were triggered!
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/HooksManager.php
(118)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(452)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/layouts/main.php (45)
10:26:30.881078 trace system.db.CDbCommand
Querying SQL: SELECT `category`, `key`, `value`, `is_serialized` FROM
`mw_option` WHERE `category` = :c. Bound with :c='system.urls'
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.881088 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')
10:26:30.881846 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')
10:26:30.882049 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/models/OptionAttributes.php
(35)
10:26:30.882055 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')
10:26:30.882662 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')
10:26:30.883306 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{menu_zone}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/MenuZone.php (133)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (193)
10:26:30.883476 trace system.db.ar.CActiveRecord
MenuZone.findByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (193)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/header.php
(41)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
10:26:30.883693 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT
1. Bound with :yp0='frontend-header'
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (193)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/header.php
(41)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
10:26:30.883699 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')
10:26:30.884179 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')
10:26:30.884609 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{menu}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (134)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (198)
10:26:30.884746 trace system.db.ar.CActiveRecord
Menu.findAllByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (198)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/header.php
(41)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
10:26:30.884849 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 /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (198)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/header.php
(41)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/HeaderWidget.php
(31)
10:26:30.884854 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')
10:26:30.885389 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')
10:26:30.885494 trace system.CModule
Loading "notify" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(44)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/layouts/main.php (59)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/web/BaseController.php
(236)
10:26:30.885657 trace system.CModule
Loading "user" application component
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(95)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/NotifyManager.php
(92)
in /home/qayak-gawab/htdocs/gawab/apps/frontend/views/layouts/main.php (59)
10:26:30.885946 trace system.CModule
Loading "session" application component
in
/home/qayak-gawab/htdocs/gawab/apps/backend/components/web/auth/WebUser.php
(29)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(95)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/NotifyManager.php
(92)
10:26:30.886476 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780914390,
:id='9sfkqf5hvpi4478g59nu8i3kum'
in
/home/qayak-gawab/htdocs/gawab/apps/backend/components/web/auth/WebUser.php
(29)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/utils/functions.php
(95)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/NotifyManager.php
(92)
10:26:30.886482 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780914390,
:id='9sfkqf5hvpi4478g59nu8i3kum')
10:26:30.887027 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780914390,
:id='9sfkqf5hvpi4478g59nu8i3kum')
10:26:30.887531 trace system.db.ar.CActiveRecord
MenuZone.findByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (193)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.887662 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT
1. Bound with :yp0='frontend-footer'
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (193)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.887669 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')
10:26:30.888281 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')
10:26:30.888503 trace system.db.ar.CActiveRecord
Menu.findAllByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (198)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.888619 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 /home/qayak-gawab/htdocs/gawab/apps/common/models/Menu.php (198)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(30)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.888624 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')
10:26:30.889151 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')
10:26:30.889605 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;port=3306;dbname=gawabwizz:gawabwizzuser:{{page}}"
from cache
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/db/ar/BaseActiveRecord.php
(155)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (148)
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (229)
10:26:30.889775 trace system.db.ar.CActiveRecord
Page.findByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (229)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(36)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.889864 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 /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (229)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(36)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.889869 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')
10:26:30.890347 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')
10:26:30.890631 trace system.db.ar.CActiveRecord
Page.findByAttributes()
in /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (229)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(39)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.890705 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 /home/qayak-gawab/htdocs/gawab/apps/common/models/Page.php (229)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(39)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/FooterWidget.php
(31)
10:26:30.890711 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')
10:26:30.891170 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')
10:26:30.891505 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
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(236)
in
/home/qayak-gawab/htdocs/gawab/apps/common/components/managers/OptionsManager.php
(99)
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/components/web/widgets/views/footer.php
(50)
10:26:30.891510 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')
10:26:30.891993 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')
10:26:30.892122 trace system.CModule
Loading "assetManager" application component
in
/home/qayak-gawab/htdocs/gawab/apps/frontend/controllers/ArticlesController.php
(119)
in /home/qayak-gawab/htdocs/gawab/apps/init.php (223)
in /home/qayak-gawab/htdocs/gawab/index.php (18)
Profiling Summary Report (Time: 0.09457s, Memory: 2,627KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
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.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 1 0.00094 0.00094 0.00094 0.00094
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.common') 1 0.00112 0.00112 0.00112 0.00112
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.cdn') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.translate') 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.urls') 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 1 0.00061 0.00061 0.00061 0.00061
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.00054 0.00054 0.00054 0.00054
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.00041 0.00041 0.00041 0.00041
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.00037 0.00037 0.00037 0.00037
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.00036 0.00036 0.00036 0.00036
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.00032 0.00032 0.00032 0.00032
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.00031 0.00031 0.00031 0.00031
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.00031 0.00031 0.00031 0.00031
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.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.tour') 1 0.00031 0.00031 0.00031 0.00031
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.00030 0.00030 0.00030 0.00030
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.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customer_registration') 1 0.00061 0.00061 0.00061 0.00061
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.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ckeditor') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.recaptcha') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.license') 1 0.00082 0.00082 0.00082 0.00082
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.00029 0.00029 0.00029 0.00029
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.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customization') 1 0.00079 0.00079 0.00079 0.00079
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.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 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.theme.frontend') 1 0.00033 0.00033 0.00033 0.00033
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.00030 0.00030 0.00030 0.00030
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.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1780914390, :id='9sfkqf5hvpi4478g59nu8i3kum') 1 0.00055 0.00055 0.00055 0.00055
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.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 1 0.00048 0.00048 0.00048 0.00048
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.00054 0.00054 0.00054 0.00054
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.00053 0.00053 0.00053 0.00053
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.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.search') 1 0.00041 0.00041 0.00041 0.00041
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.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.social_links') 1 0.00048 0.00048 0.00048 0.00048
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.00033 0.00033 0.00033 0.00033