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
08:52:10.859090 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.216.75',
  'HTTP_X_REAL_IP' => '216.73.216.75',
  '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' => '-119.1091',
  'GEOIP_LATITUDE' => '34.1453',
  'GEOIP_CITY_CONTINENT_CODE' => 'NA',
  'GEOIP_POSTAL_CODE' => '93033',
  'GEOIP_CITY' => 'Oxnard',
  '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.216.75',
  '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' => 1780908730.854157,
  'REQUEST_TIME' => 1780908730,
)
08:52:10.860658 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)
08:52:10.861036 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)
08:52:10.861115 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)
08:52:10.861179 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)
08:52:10.861629 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)
08:52:10.864923 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)
08:52:10.865170 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)
08:52:10.865237 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)
08:52:10.865351 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)
08:52:10.867598 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)
08:52:10.867605 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')
08:52:10.868417 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')
08:52:10.868505 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)
08:52:10.879112 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)
08:52:10.879118 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')
08:52:10.879998 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')
08:52:10.880153 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)
08:52:10.880271 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)
08:52:10.881006 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)
08:52:10.882021 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)
08:52:10.883023 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)
08:52:10.883264 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)
08:52:10.883269 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')
08:52:10.884697 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')
08:52:10.885157 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)
08:52:10.885162 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')
08:52:10.885581 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')
08:52:10.885629 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)
08:52:10.887650 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)
08:52:10.887655 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')
08:52:10.888147 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')
08:52:10.888194 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)
08:52:10.888196 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')
08:52:10.888462 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')
08:52:10.888492 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)
08:52:10.888494 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')
08:52:10.888714 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')
08:52:10.888756 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)
08:52:10.888758 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')
08:52:10.888998 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')
08:52:10.889027 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)
08:52:10.889029 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')
08:52:10.889229 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')
08:52:10.889257 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)
08:52:10.889260 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')
08:52:10.889503 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')
08:52:10.889823 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)
08:52:10.889827 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')
08:52:10.890130 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')
08:52:10.890166 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)
08:52:10.890171 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')
08:52:10.890408 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')
08:52:10.890444 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)
08:52:10.890448 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')
08:52:10.890705 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')
08:52:10.890736 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)
08:52:10.890738 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')
08:52:10.891263 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')
08:52:10.891546 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)
08:52:10.891550 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')
08:52:10.891822 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')
08:52:10.891858 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)
08:52:10.891860 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')
08:52:10.892107 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')
08:52:10.892137 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)
08:52:10.892139 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')
08:52:10.892380 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')
08:52:10.892425 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)
08:52:10.892426 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')
08:52:10.892657 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')
08:52:10.892707 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)
08:52:10.892709 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')
08:52:10.892971 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')
08:52:10.893006 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)
08:52:10.893008 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')
08:52:10.893290 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')
08:52:10.893603 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)
08:52:10.893608 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')
08:52:10.894042 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')
08:52:10.894445 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)
08:52:10.894449 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')
08:52:10.894723 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')
08:52:10.894781 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)
08:52:10.894783 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')
08:52:10.895052 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')
08:52:10.895088 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)
08:52:10.895092 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')
08:52:10.895374 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')
08:52:10.895406 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)
08:52:10.895409 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')
08:52:10.895693 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')
08:52:10.895726 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)
08:52:10.895987 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)
08:52:10.895992 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')
08:52:10.896226 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')
08:52:10.900717 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)
08:52:10.900727 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')
08:52:10.901318 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')
08:52:10.901588 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)
08:52:10.901989 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)
08:52:10.902224 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)
08:52:10.902311 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)
08:52:10.902316 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')
08:52:10.904934 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')
08:52:10.905864 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)
08:52:10.906589 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)
08:52:10.910080 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)
08:52:10.910376 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)
08:52:10.912065 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)
08:52:10.912857 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)
08:52:10.912866 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')
08:52:10.913748 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')
08:52:10.914105 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)
08:52:10.929481 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)
08:52:10.929784 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)
08:52:10.930121 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)
08:52:10.930783 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)
08:52:10.930901 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)
08:52:10.930908 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)
08:52:10.933123 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)
08:52:10.933455 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)
08:52:10.933689 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)
08:52:10.933696 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)
08:52:10.934570 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)
08:52:10.935265 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)
08:52:10.935616 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)
08:52:10.935878 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)
08:52:10.935884 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')
08:52:10.937096 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')
08:52:10.938044 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)
08:52:10.938539 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)
08:52:10.938546 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')
08:52:10.939287 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')
08:52:10.939466 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)
08:52:10.939472 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')
08:52:10.939843 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')
08:52:10.940411 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)
08:52:10.940767 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)
08:52:10.940851 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)
08:52:10.940857 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')
08:52:10.941215 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')
08:52:10.941514 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)
08:52:10.941628 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)
08:52:10.941689 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)
08:52:10.941694 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')
08:52:10.942055 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')
08:52:10.942142 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)
08:52:10.942231 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)
08:52:10.942472 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)
08:52:10.943197 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780908730,
:id='71mqnqcsq2c84basvol13bqlah'
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)
08:52:10.943203 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780908730,
:id='71mqnqcsq2c84basvol13bqlah')
08:52:10.943600 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1780908730,
:id='71mqnqcsq2c84basvol13bqlah')
08:52:10.944035 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)
08:52:10.944102 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)
08:52:10.944106 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')
08:52:10.944422 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')
08:52:10.944608 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)
08:52:10.944674 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)
08:52:10.944679 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')
08:52:10.945008 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')
08:52:10.945296 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)
08:52:10.945405 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)
08:52:10.945455 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)
08:52:10.945458 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')
08:52:10.945751 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')
08:52:10.945939 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)
08:52:10.945983 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)
08:52:10.946001 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')
08:52:10.946279 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')
08:52:10.946516 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)
08:52:10.946520 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')
08:52:10.946851 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')
08:52:10.946935 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.09272s, Memory: 2,627KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes') 1 0.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.common') 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.translate') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.cdn') 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.html-blocks') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.tour') 1 0.00024 0.00024 0.00024 0.00024
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.00024 0.00024 0.00024 0.00024
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.00022 0.00022 0.00022 0.00022
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.00020 0.00020 0.00020 0.00020
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.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.ckeditor') 1 0.00052 0.00052 0.00052 0.00052
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.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.email-verification') 1 0.00027 0.00027 0.00027 0.00027
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.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.payment-gateway-paypal') 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.list-form-custom-redirect') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.recaptcha') 1 0.00024 0.00024 0.00024 0.00024
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.00024 0.00024 0.00024 0.00024
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.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.search') 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.license') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 1 0.00262 0.00262 0.00262 0.00262
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.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.articles-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.theme.frontend') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customization') 1 0.00088 0.00088 0.00088 0.00088
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.00221 0.00221 0.00221 0.00221
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.00087 0.00087 0.00087 0.00087
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.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.urls') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1780908730, :id='71mqnqcsq2c84basvol13bqlah') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customer_registration') 1 0.00037 0.00037 0.00037 0.00037
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.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 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.landing-pages-content-builder') 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=2, :yp1='active') 1 0.00033 0.00033 0.00033 0.00033
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.00029 0.00029 0.00029 0.00029
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.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.social_links') 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.pages-content-builder') 1 0.00027 0.00027 0.00027 0.00027