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
07:47:06.033011 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.32',
  'HTTP_X_REAL_IP' => '216.73.217.32',
  'HTTP_X_FORWARDED_HOST' => 't.unitedvoices.co',
  'PHP_VALUE' => 'error_log=/home/qayak-gawab/logs/php/error.log;
memory_limit=512M;
max_execution_time=300;
max_input_time=60;
max_input_vars=10000;
post_max_size=64M;
upload_max_filesize=64M;
date.timezone=America/New_York;
display_errors=off;',
  'HTTPS' => 'on',
  'MGT' => '1',
  'GEOIP_LONGITUDE' => '-118.0276',
  'GEOIP_LATITUDE' => '34.0686',
  'GEOIP_CITY_CONTINENT_CODE' => 'NA',
  'GEOIP_POSTAL_CODE' => '',
  'GEOIP_CITY' => 'El Monte',
  'GEOIP_REGION' => 'CA',
  'GEOIP_CITY_COUNTRY_NAME' => 'United States',
  'GEOIP_CITY_COUNTRY_CODE3' => 'USA',
  'GEOIP_CITY_COUNTRY_CODE' => 'US',
  'GEOIP_COUNTRY_NAME' => 'United States',
  'GEOIP_COUNTRY_CODE3' => 'USA',
  'GEOIP_COUNTRY_CODE' => 'US',
  'REDIRECT_STATUS' => '200',
  'HTTP_HOST' => 't.unitedvoices.co',
  'SERVER_NAME' => 'gawab.qayak.net',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '127.0.0.1',
  'REMOTE_PORT' => '',
  'REMOTE_ADDR' => '216.73.217.32',
  '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' => 1788076026.029091,
  'REQUEST_TIME' => 1788076026,
)
07:47:06.033978 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)
07:47:06.034174 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)
07:47:06.034203 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)
07:47:06.034243 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)
07:47:06.034495 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)
07:47:06.036401 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)
07:47:06.036633 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)
07:47:06.036675 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)
07:47:06.036730 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)
07:47:06.037777 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)
07:47:06.037786 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')
07:47:06.038310 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')
07:47:06.038371 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)
07:47:06.044799 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)
07:47:06.044804 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')
07:47:06.045348 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')
07:47:06.045428 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)
07:47:06.045505 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)
07:47:06.046044 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)
07:47:06.046725 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)
07:47:06.047000 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)
07:47:06.047126 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)
07:47:06.047128 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')
07:47:06.047714 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')
07:47:06.047988 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)
07:47:06.047993 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')
07:47:06.048369 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')
07:47:06.048417 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)
07:47:06.049946 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)
07:47:06.049951 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')
07:47:06.050369 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')
07:47:06.050412 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)
07:47:06.050415 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')
07:47:06.050750 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')
07:47:06.050777 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)
07:47:06.050781 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')
07:47:06.050966 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')
07:47:06.050990 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)
07:47:06.050992 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')
07:47:06.051160 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')
07:47:06.051192 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)
07:47:06.051196 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')
07:47:06.051422 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')
07:47:06.051453 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)
07:47:06.051455 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')
07:47:06.051704 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')
07:47:06.051943 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)
07:47:06.051944 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')
07:47:06.052150 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')
07:47:06.052184 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)
07:47:06.052187 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')
07:47:06.052362 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')
07:47:06.052408 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)
07:47:06.052412 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')
07:47:06.052617 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')
07:47:06.052639 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)
07:47:06.052642 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')
07:47:06.052797 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')
07:47:06.052932 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)
07:47:06.052933 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')
07:47:06.053123 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')
07:47:06.053148 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)
07:47:06.053148 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')
07:47:06.053312 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')
07:47:06.053333 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)
07:47:06.053334 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')
07:47:06.053498 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')
07:47:06.053519 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)
07:47:06.053520 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')
07:47:06.053703 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')
07:47:06.053734 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)
07:47:06.053735 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')
07:47:06.053930 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')
07:47:06.053951 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)
07:47:06.053952 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')
07:47:06.054117 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')
07:47:06.054241 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)
07:47:06.054244 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')
07:47:06.054419 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')
07:47:06.054529 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)
07:47:06.054532 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')
07:47:06.054738 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')
07:47:06.054761 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)
07:47:06.054763 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')
07:47:06.054924 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')
07:47:06.054956 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)
07:47:06.054960 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')
07:47:06.055179 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')
07:47:06.055206 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)
07:47:06.055208 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')
07:47:06.055386 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')
07:47:06.055438 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)
07:47:06.055632 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)
07:47:06.055634 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')
07:47:06.055871 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')
07:47:06.058814 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)
07:47:06.058818 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')
07:47:06.059164 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')
07:47:06.059326 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)
07:47:06.059607 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)
07:47:06.059748 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)
07:47:06.059798 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)
07:47:06.059801 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')
07:47:06.060080 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')
07:47:06.060458 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)
07:47:06.060904 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)
07:47:06.062829 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)
07:47:06.063043 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)
07:47:06.064218 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)
07:47:06.064724 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)
07:47:06.064729 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')
07:47:06.065222 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')
07:47:06.065429 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)
07:47:06.077261 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)
07:47:06.077466 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)
07:47:06.077760 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)
07:47:06.078332 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)
07:47:06.078433 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)
07:47:06.078438 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)
07:47:06.079101 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)
07:47:06.079308 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)
07:47:06.079493 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)
07:47:06.079499 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)
07:47:06.080063 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)
07:47:06.080432 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)
07:47:06.080701 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)
07:47:06.080878 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)
07:47:06.080883 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')
07:47:06.081665 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')
07:47:06.082474 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)
07:47:06.083080 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)
07:47:06.083086 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')
07:47:06.083529 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')
07:47:06.083687 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)
07:47:06.083693 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')
07:47:06.084011 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')
07:47:06.084508 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)
07:47:06.084707 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)
07:47:06.084774 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)
07:47:06.084778 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')
07:47:06.085102 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')
07:47:06.085376 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)
07:47:06.085478 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)
07:47:06.085536 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)
07:47:06.085540 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')
07:47:06.085885 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')
07:47:06.085952 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)
07:47:06.086028 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)
07:47:06.086242 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)
07:47:06.086779 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788076026,
:id='r2ep0fm21jt9gcl9p3g7d5eur2'
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)
07:47:06.086782 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788076026,
:id='r2ep0fm21jt9gcl9p3g7d5eur2')
07:47:06.087234 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `data`
FROM `mw_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1788076026,
:id='r2ep0fm21jt9gcl9p3g7d5eur2')
07:47:06.087497 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)
07:47:06.087569 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)
07:47:06.087574 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')
07:47:06.087836 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')
07:47:06.087982 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)
07:47:06.088035 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)
07:47:06.088038 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')
07:47:06.088330 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')
07:47:06.088571 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)
07:47:06.088695 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)
07:47:06.088749 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)
07:47:06.088754 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')
07:47:06.089036 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')
07:47:06.089200 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)
07:47:06.089246 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)
07:47:06.089260 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')
07:47:06.089472 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')
07:47:06.089720 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)
07:47:06.089725 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')
07:47:06.090006 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')
07:47:06.090121 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.06148s, 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.00059 0.00059 0.00059 0.00059
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.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.common') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.reverse_proxy') 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.translate') 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.cdn') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.html-blocks') 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.tour') 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.ip-location-maxmind') 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.list-form-custom-assets') 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.campaign-activity-map') 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.payment-gateway-offline') 1 0.00021 0.00021 0.00021 0.00021
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.00066 0.00066 0.00066 0.00066
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.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.cookie-consent') 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.payment-gateway-paypal') 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.ai-assistant') 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.email-template-builder') 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.recaptcha') 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.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.license') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.extension.ckeditor') 1 0.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.theme.frontend') 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.articles-content-builder') 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.content-builder') 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.landing-pages-content-builder') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM `mw_article` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='campaign-tag-filters') 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.customization') 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.extension.email-verification') 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT `data` FROM `mw_session` WHERE expire>:expire AND id=:id. Bound with :expire=1788076026, :id='r2ep0fm21jt9gcl9p3g7d5eur2') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT `category`, `key`, `value`, `is_serialized` FROM `mw_option` WHERE `category` = :c. Bound with :c='system.urls') 1 0.00044 0.00044 0.00044 0.00044
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.00020 0.00020 0.00020 0.00020
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.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-header') 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.customer_registration') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT * FROM `mw_menu_zone` `t` WHERE `t`.`slug`=:yp0 LIMIT 1. Bound with :yp0='frontend-footer') 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=2, :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='terms-and-conditions', :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.extension.search') 1 0.00018 0.00018 0.00018 0.00018
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.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.social_links') 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.pages-content-builder') 1 0.00021 0.00021 0.00021 0.00021