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
05:46:31.008184 info application
User: Guest (ID: )

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

$_COOKIE=array (
  'csrf_token' =>
'242a3b9e937b7b5d78eb110866b5674ebe4dceeds:88:"cGcwM2Q0djVLRFFoRHhTV1duNThuemJmVlMyT0I0WTNB-Y50hBMw6Z74UZ_p6g2NPqZ53DcEP0n24SJc-kExQQ==";',
  'mwsid' => 'k5t0mvhspt2kcv82tv3if4mfvl',
)

$_SERVER=array (
  'USER' => 'qayak-gawab',
  'HOME' => '/home/qayak-gawab',
  'HTTP_COOKIE' =>
'csrf_token=242a3b9e937b7b5d78eb110866b5674ebe4dceeds%3A88%3A%22cGcwM2Q0djVLRFFoRHhTV1duNThuemJmVlMyT0I0WTNB-Y50hBMw6Z74UZ_p6g2NPqZ53DcEP0n24SJc-kExQQ%3D%3D%22%3B;
mwsid=k5t0mvhspt2kcv82tv3if4mfvl',
  '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.142',
  'HTTP_X_REAL_IP' => '216.73.217.142',
  'HTTP_X_FORWARDED_HOST' => 't.unitedvoices.co',
  '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' => 't.unitedvoices.co',
  'SERVER_NAME' => 'gawab.qayak.net',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '127.0.0.1',
  'REMOTE_PORT' => '',
  'REMOTE_ADDR' => '216.73.217.142',
  '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' => 1795239991.006123,
  'REQUEST_TIME' => 1795239991,
)
05:46:31.009200 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)
05:46:31.009403 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)
05:46:31.009440 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)
05:46:31.009479 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)
05:46:31.009807 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)
05:46:31.012648 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)
05:46:31.012865 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)
05:46:31.012919 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)
05:46:31.012962 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)
05:46:31.015332 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)
05:46:31.015341 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')
05:46:31.016127 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')
05:46:31.016228 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)
05:46:31.019495 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)
05:46:31.019503 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')
05:46:31.020457 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')
05:46:31.020633 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)
05:46:31.020823 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)
05:46:31.021636 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)
05:46:31.022541 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)
05:46:31.022924 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)
05:46:31.023091 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)
05:46:31.023096 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')
05:46:31.023870 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')
05:46:31.024425 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)
05:46:31.024431 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')
05:46:31.025532 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')
05:46:31.025774 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)
05:46:31.027721 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)
05:46:31.027729 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')
05:46:31.028426 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')
05:46:31.028497 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)
05:46:31.028501 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')
05:46:31.029037 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')
05:46:31.029095 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)
05:46:31.029099 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')
05:46:31.029583 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')
05:46:31.029632 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)
05:46:31.029634 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')
05:46:31.029985 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')
05:46:31.030035 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)
05:46:31.030039 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')
05:46:31.030385 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')
05:46:31.030425 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)
05:46:31.030427 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')
05:46:31.030783 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')
05:46:31.031155 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)
05:46:31.031158 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')
05:46:31.031517 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')
05:46:31.031586 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)
05:46:31.031589 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')
05:46:31.032094 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')
05:46:31.032131 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)
05:46:31.032135 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')
05:46:31.032633 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')
05:46:31.032680 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)
05:46:31.032684 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')
05:46:31.033111 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')
05:46:31.033412 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)
05:46:31.033417 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')
05:46:31.033795 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')
05:46:31.033835 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)
05:46:31.033839 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')
05:46:31.034117 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')
05:46:31.034157 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)
05:46:31.034162 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')
05:46:31.034436 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')
05:46:31.034476 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)
05:46:31.034478 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')
05:46:31.034842 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')
05:46:31.034877 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)
05:46:31.034879 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')
05:46:31.035120 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')
05:46:31.035160 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)
05:46:31.035161 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')
05:46:31.035454 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')
05:46:31.035729 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)
05:46:31.035732 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')
05:46:31.036071 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')
05:46:31.036289 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)
05:46:31.036293 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')
05:46:31.036612 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')
05:46:31.036653 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)
05:46:31.036655 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')
05:46:31.036933 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')
05:46:31.036971 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)
05:46:31.036973 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')
05:46:31.037224 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')
05:46:31.037261 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)
05:46:31.037265 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')
05:46:31.037529 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')
05:46:31.037585 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)
05:46:31.037805 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)
05:46:31.037808 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')
05:46:31.038162 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')
05:46:31.039772 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)
05:46:31.039782 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')
05:46:31.040767 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')
05:46:31.041047 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)
05:46:31.041456 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)
05:46:31.041856 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)
05:46:31.041948 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)
05:46:31.041951 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')
05:46:31.042540 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')
05:46:31.043119 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)
05:46:31.043406 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)
05:46:31.043467 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)
05:46:31.043689 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)
05:46:31.044872 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)
05:46:31.045433 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)
05:46:31.045439 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')
05:46:31.046169 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')
05:46:31.046457 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)
05:46:31.059483 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)
05:46:31.059745 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)
05:46:31.060086 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)
05:46:31.060549 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)
05:46:31.060691 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)
05:46:31.060698 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)
05:46:31.061676 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)
05:46:31.061964 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)
05:46:31.062154 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)
05:46:31.062159 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)
05:46:31.062952 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)
05:46:31.063484 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)
05:46:31.063894 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)
05:46:31.064150 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)
05:46:31.064156 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')
05:46:31.065228 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')
05:46:31.066256 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)
05:46:31.066967 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)
05:46:31.066976 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')
05:46:31.067701 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')
05:46:31.067888 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)
05:46:31.067897 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')
05:46:31.068312 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')
05:46:31.068805 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)
05:46:31.068964 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)
05:46:31.069056 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)
05:46:31.069062 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')
05:46:31.069628 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')
05:46:31.070024 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)
05:46:31.070152 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)
05:46:31.070239 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)
05:46:31.070242 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')
05:46:31.070858 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')
05:46:31.070961 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)
05:46:31.071070 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)
05:46:31.071293 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)
05:46:31.071587 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1795239991,
:id='k5t0mvhspt2kcv82tv3if4mfvl'
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)
05:46:31.071593 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1795239991,
:id='k5t0mvhspt2kcv82tv3if4mfvl')
05:46:31.072103 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1795239991,
:id='k5t0mvhspt2kcv82tv3if4mfvl')
05:46:31.072412 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)
05:46:31.072496 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)
05:46:31.072501 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')
05:46:31.072913 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')
05:46:31.073124 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)
05:46:31.073195 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)
05:46:31.073199 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')
05:46:31.073651 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')
05:46:31.073951 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)
05:46:31.074091 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)
05:46:31.074158 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)
05:46:31.074163 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')
05:46:31.074580 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')
05:46:31.074831 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)
05:46:31.074892 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)
05:46:31.074896 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')
05:46:31.075256 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')
05:46:31.075525 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)
05:46:31.075529 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')
05:46:31.075984 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')
05:46:31.076123 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.07188s, Memory: 2,646KB)
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.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.cdn') 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.license') 1 0.00099 0.00099 0.00099 0.00099
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.00107 0.00107 0.00107 0.00107
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes') 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customization') 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.translate') 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.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.cookie-consent') 1 0.00050 0.00050 0.00050 0.00050
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.00050 0.00050 0.00050 0.00050
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.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.payment-gateway-offline') 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.tour') 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.00035 0.00035 0.00035 0.00035
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.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ckeditor') 1 0.00043 0.00043 0.00043 0.00043
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.00028 0.00028 0.00028 0.00028
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.00098 0.00098 0.00098 0.00098
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 `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ai-assistant') 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.theme.frontend') 1 0.00035 0.00035 0.00035 0.00035
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.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.extension.landing-pages-content-builder') 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.content-builder') 1 0.00026 0.00026 0.00026 0.00026
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.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 1 0.00059 0.00059 0.00059 0.00059
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.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.urls') 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.recaptcha') 1 0.00027 0.00027 0.00027 0.00027
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.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.customer_registration') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1795239991, :id='k5t0mvhspt2kcv82tv3if4mfvl') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 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.list-form-custom-webhooks') 1 0.00024 0.00024 0.00024 0.00024
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.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='terms-and-conditions', :yp1='active') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.search') 1 0.00034 0.00034 0.00034 0.00034
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.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.social_links') 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.extension.pages-content-builder') 1 0.00032 0.00032 0.00032 0.00032