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
06:06:52.159854 info application
User: Guest (ID: )

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

$_SERVER=array (
  'USER' => 'qayak-gawab',
  'HOME' => '/home/qayak-gawab',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko;
compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_CONNECTION' => 'close',
  'HTTP_X_FORWARDED_FOR' => '216.73.217.95',
  'HTTP_X_REAL_IP' => '216.73.217.95',
  'HTTP_X_FORWARDED_HOST' => 'gawab.qayak.net',
  'PHP_VALUE' => 'error_log=/home/qayak-gawab/logs/php/error.log;
memory_limit=512M;
max_execution_time=300;
max_input_time=60;
max_input_vars=10000;
post_max_size=64M;
upload_max_filesize=64M;
date.timezone=America/New_York;
display_errors=off;',
  'HTTPS' => 'on',
  'MGT' => '1',
  'GEOIP_LONGITUDE' => '-118.0276',
  'GEOIP_LATITUDE' => '34.0686',
  'GEOIP_CITY_CONTINENT_CODE' => 'NA',
  'GEOIP_POSTAL_CODE' => '',
  'GEOIP_CITY' => 'El Monte',
  'GEOIP_REGION' => 'CA',
  'GEOIP_CITY_COUNTRY_NAME' => 'United States',
  'GEOIP_CITY_COUNTRY_CODE3' => 'USA',
  'GEOIP_CITY_COUNTRY_CODE' => 'US',
  'GEOIP_COUNTRY_NAME' => 'United States',
  'GEOIP_COUNTRY_CODE3' => 'USA',
  'GEOIP_COUNTRY_CODE' => 'US',
  'REDIRECT_STATUS' => '200',
  'HTTP_HOST' => 'gawab.qayak.net',
  'SERVER_NAME' => 'gawab.qayak.net',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '127.0.0.1',
  'REMOTE_PORT' => '',
  'REMOTE_ADDR' => '216.73.217.95',
  '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' => 1788070012.156069,
  'REQUEST_TIME' => 1788070012,
)
06:06:52.161006 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)
06:06:52.161241 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)
06:06:52.161277 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)
06:06:52.161325 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)
06:06:52.161720 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)
06:06:52.164369 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)
06:06:52.164588 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)
06:06:52.164659 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)
06:06:52.164741 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)
06:06:52.165887 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)
06:06:52.165894 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')
06:06:52.166354 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')
06:06:52.166410 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)
06:06:52.174020 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)
06:06:52.174025 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')
06:06:52.174649 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')
06:06:52.174782 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)
06:06:52.174863 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)
06:06:52.175447 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)
06:06:52.176246 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)
06:06:52.176611 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)
06:06:52.176800 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)
06:06:52.176804 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')
06:06:52.177278 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')
06:06:52.177628 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)
06:06:52.177632 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')
06:06:52.177969 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')
06:06:52.178005 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)
06:06:52.179745 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)
06:06:52.179749 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')
06:06:52.180042 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')
06:06:52.180069 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)
06:06:52.180073 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')
06:06:52.180250 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')
06:06:52.180273 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)
06:06:52.180274 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')
06:06:52.180430 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')
06:06:52.180450 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)
06:06:52.180453 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')
06:06:52.180646 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')
06:06:52.180680 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)
06:06:52.180682 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')
06:06:52.180892 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')
06:06:52.180918 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)
06:06:52.180921 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')
06:06:52.181130 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')
06:06:52.181327 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)
06:06:52.181329 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')
06:06:52.181596 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')
06:06:52.181628 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)
06:06:52.181632 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')
06:06:52.181869 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')
06:06:52.181900 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)
06:06:52.181902 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')
06:06:52.182095 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')
06:06:52.182123 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)
06:06:52.182126 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')
06:06:52.182317 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')
06:06:52.182527 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)
06:06:52.182529 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')
06:06:52.182799 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')
06:06:52.182823 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)
06:06:52.182826 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')
06:06:52.182986 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')
06:06:52.183007 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)
06:06:52.183010 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')
06:06:52.183186 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')
06:06:52.183212 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)
06:06:52.183213 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')
06:06:52.183367 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')
06:06:52.183396 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)
06:06:52.183398 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')
06:06:52.183566 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')
06:06:52.183594 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)
06:06:52.183598 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')
06:06:52.183809 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')
06:06:52.184012 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)
06:06:52.184015 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')
06:06:52.184247 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')
06:06:52.184453 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)
06:06:52.184457 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')
06:06:52.184760 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')
06:06:52.184786 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)
06:06:52.184787 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')
06:06:52.184957 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')
06:06:52.184978 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)
06:06:52.184981 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')
06:06:52.185134 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')
06:06:52.185156 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)
06:06:52.185157 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')
06:06:52.185308 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')
06:06:52.185327 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)
06:06:52.185482 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)
06:06:52.185483 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')
06:06:52.185657 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')
06:06:52.188447 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)
06:06:52.188452 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')
06:06:52.188904 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')
06:06:52.189079 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)
06:06:52.189378 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)
06:06:52.189553 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)
06:06:52.189620 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)
06:06:52.189623 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')
06:06:52.189934 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')
06:06:52.190265 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)
06:06:52.190617 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)
06:06:52.192194 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)
06:06:52.192347 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)
06:06:52.193077 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)
06:06:52.193330 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)
06:06:52.193334 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')
06:06:52.194240 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')
06:06:52.194421 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)
06:06:52.203181 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)
06:06:52.203350 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)
06:06:52.203591 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)
06:06:52.203983 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)
06:06:52.204058 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)
06:06:52.204063 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)
06:06:52.204741 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)
06:06:52.204907 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)
06:06:52.205032 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)
06:06:52.205034 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)
06:06:52.205459 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)
06:06:52.205728 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)
06:06:52.205916 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)
06:06:52.206044 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)
06:06:52.206048 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')
06:06:52.206465 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')
06:06:52.207070 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)
06:06:52.207382 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)
06:06:52.207386 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')
06:06:52.207740 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')
06:06:52.207842 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)
06:06:52.207845 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')
06:06:52.208051 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')
06:06:52.208323 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)
06:06:52.208400 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)
06:06:52.208445 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)
06:06:52.208446 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')
06:06:52.208709 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')
06:06:52.208940 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)
06:06:52.209028 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)
06:06:52.209084 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)
06:06:52.209089 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')
06:06:52.209333 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')
06:06:52.209404 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)
06:06:52.209500 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)
06:06:52.209793 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)
06:06:52.210180 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788070012,
:id='6dh11ukm9ob03du685b4j49rq2'
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)
06:06:52.210186 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788070012,
:id='6dh11ukm9ob03du685b4j49rq2')
06:06:52.210452 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788070012,
:id='6dh11ukm9ob03du685b4j49rq2')
06:06:52.210730 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)
06:06:52.210786 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)
06:06:52.210788 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')
06:06:52.210988 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')
06:06:52.211091 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)
06:06:52.211132 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)
06:06:52.211134 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')
06:06:52.211352 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')
06:06:52.211534 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)
06:06:52.211623 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)
06:06:52.211662 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)
06:06:52.211664 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')
06:06:52.211873 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')
06:06:52.211988 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)
06:06:52.212022 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)
06:06:52.212024 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')
06:06:52.212197 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')
06:06:52.212351 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)
06:06:52.212353 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')
06:06:52.212701 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')
06:06:52.212775 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.05569s, Memory: 2,627KB)
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.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SELECT * FROM `mw_language` `t` WHERE `t`.`is_default`=:yp0 LIMIT 1. Bound with :yp0='yes') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 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.cdn') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.translate') 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.ip-location-maxmind') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.tour') 1 0.00021 0.00021 0.00021 0.00021
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.00019 0.00019 0.00019 0.00019
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.00018 0.00018 0.00018 0.00018
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.00016 0.00016 0.00016 0.00016
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.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.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.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.email-template-builder') 1 0.00021 0.00021 0.00021 0.00021
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.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ckeditor') 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.recaptcha') 1 0.00018 0.00018 0.00018 0.00018
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.00017 0.00017 0.00017 0.00017
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.00016 0.00016 0.00016 0.00016
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.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.search') 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.license') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.theme.frontend') 1 0.00017 0.00017 0.00017 0.00017
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.00015 0.00015 0.00015 0.00015
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.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.customization') 1 0.00091 0.00091 0.00091 0.00091
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.00068 0.00068 0.00068 0.00068
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.00042 0.00042 0.00042 0.00042
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.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.urls') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1788070012, :id='6dh11ukm9ob03du685b4j49rq2') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 1 0.00026 0.00026 0.00026 0.00026
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.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.customer_registration') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 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.landing-pages-content-builder') 1 0.00017 0.00017 0.00017 0.00017
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.00022 0.00022 0.00022 0.00022
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.00021 0.00021 0.00021 0.00021
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.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.social_links') 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.pages-content-builder') 1 0.00030 0.00030 0.00030 0.00030